mark.tailc13864.ts.net / 127.0.0.1 / reliya_erp / vw_customer_sales_flow

以樹狀顯示資料庫導覽面版於導覽面版，將資料庫樹狀選單改為下拉式選單
連結主面板在主面板凸顯目前的資料庫或資料表。
顯示標誌在導覽面板顯示標誌。
標誌連結網址導覽面板標誌所連結的網址。
標誌連結目標以主視窗 (`main`) 還是新視窗 (`new`) 開啟目標連結。
開啟加強標示當滑鼠指標移至伺服器上時，將之凸顯。
導覽樹第一層項目數量上限導覽樹每一頁可以顯示的第一層項目數量。
設定顯示篩選框的項目數量下限設定篩選框要顯示的項目最小數量 (資料表、檢視表、預存程序和事件) 。
最近使用的資料表最多顯示幾個最近使用的資料表；0 代表不顯示。
最愛資料表顯示最愛資料表的數量上限；設為 0 則關閉此功能。
導覽面板寬度設為 0 則摺疊導覽面板。

導覽樹分支的項目數量上限導覽樹每一頁可以顯示的項目數量。
將導覽樹的項目分組將導覽樹內的項目分組 (依上方「資料庫與資料表」分頁定義的分隔符號來分組)。
開啟導覽樹展開功能於導覽面版，是否提供樹狀選單的展開功能。
在導覽樹顯示資料表在導覽樹，是否於資料庫底下顯示資料表
在導覽樹顯示檢視表在導覽樹，是否於資料庫底下顯示檢視表
在導覽樹顯示函式在導覽樹，是否於資料庫底下顯示函式
在導覽樹顯示預存程序在導覽樹，是否於資料庫底下顯示預存程序
在導覽樹顯示事件在導覽樹，是否於資料庫底下顯示事件
展開單一資料庫是否於導覽樹自動展開單一資料庫。

顯示伺服器選擇在導覽面板上方，顯示伺服器清單。
使用清單方式顯示伺服器顯示伺服器列表時，以清單取代下拉式選單。

設定顯示篩選框的資料庫數量下限
資料庫導覽樹的分隔符號會依據此分隔符號，將資料庫分為不同階層的樹狀。

快速存取圖示要顯示的目標頁面
第二快速存取圖示的目標頁面
資料表導覽樹的分隔符號會依據此分隔符號將資料表分為不同階層的樹狀。
資料表導覽樹深度限制

請按 Ctrl+Enter 執行查詢

資料表導覽列僅使用圖示或文字，又或兩者都使用。
如何顯示各種操作連結僅使用圖示或文字，又或兩者都使用。
允許顯示所有資料列是否顯示「顯示全部資料列」的按鈕。
可顯示的資料列數量上限瀏覽查詢結果時，一次最多顯示的列數。如果結果超過此列數，則會顯示「上一頁」和「下一頁」的連結。
預設排序 `SMART` - 即是對 TIME、DATE、DATETIME 和 TIMESTAMP 類型的欄位遞減排序，其他欄位遞增。
凸顯滑鼠指標凸顯滑鼠指標所指的資料列。
凸顯資料列凸顯所選的資料列。
表格編輯：觸發器動作
表格編輯：一次過儲存所有已編輯資料
重複顯示標題每 X 儲存格重複標題；若要關閉此功能，請設為 `0`。
限制欄位字元數瀏覽非數字欄位時，所顯示的最大字元數。
資料列的連結顯示位置連結包含了編輯、複製和刪除。
一定顯示資料列連結是否顯示缺少獨一鍵的資料列連結。
主鍵預設排序預設使用主鍵來排列資料表。
記住資料表的排序瀏覽資料表時，會使用上次的資料表排序。
關聯顯示顯示用選項

資料表導覽列

僅使用圖示或文字，又或兩者都使用。

如何顯示各種操作連結

僅使用圖示或文字，又或兩者都使用。

允許顯示所有資料列

是否顯示「顯示全部資料列」的按鈕。

可顯示的資料列數量上限

瀏覽查詢結果時，一次最多顯示的列數。如果結果超過此列數，則會顯示「上一頁」和「下一頁」的連結。

預設排序

SMART - 即是對 TIME、DATE、DATETIME 和 TIMESTAMP 類型的欄位遞減排序，其他欄位遞增。

凸顯滑鼠指標

凸顯滑鼠指標所指的資料列。

凸顯資料列

凸顯所選的資料列。

表格編輯：觸發器動作

表格編輯：一次過儲存所有已編輯資料

重複顯示標題

每 X 儲存格重複標題；若要關閉此功能，請設為 0。

限制欄位字元數

瀏覽非數字欄位時，所顯示的最大字元數。

資料列的連結顯示位置

連結包含了編輯、複製和刪除。

一定顯示資料列連結

是否顯示缺少獨一鍵的資料列連結。

主鍵預設排序

預設使用主鍵來排列資料表。

記住資料表的排序

瀏覽資料表時，會使用上次的資料表排序。

關聯顯示

顯示用選項

			customer_id	company_name	quotation_id	quotation_status 1	project_id	project_status
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 2 AND `vw_customer_sales_flow`.`company_name` = '環球晶圓股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 87 AND `vw_customer_sales_flow`.`quotation_status` = 'won' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	2	環球晶圓股份有限公司	87	won	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 6 AND `vw_customer_sales_flow`.`company_name` = '卓益芯奇股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 1 AND `vw_customer_sales_flow`.`quotation_status` = 'won' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	6	卓益芯奇股份有限公司	1	won	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 7 AND `vw_customer_sales_flow`.`company_name` = '國倫科技' AND `vw_customer_sales_flow`.`quotation_id` = 86 AND `vw_customer_sales_flow`.`quotation_status` = 'won' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	7	國倫科技	86	won	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 7 AND `vw_customer_sales_flow`.`company_name` = '國倫科技' AND `vw_customer_sales_flow`.`quotation_id` = 88 AND `vw_customer_sales_flow`.`quotation_status` = 'won' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	7	國倫科技	88	won	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 10 AND `vw_customer_sales_flow`.`company_name` = '深圳海特克機電設備有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 7 AND `vw_customer_sales_flow`.`quotation_status` = 'won' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	10	深圳海特克機電設備有限公司	7	won	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 7 AND `vw_customer_sales_flow`.`company_name` = '國倫科技' AND `vw_customer_sales_flow`.`quotation_id` = 37 AND `vw_customer_sales_flow`.`quotation_status` = 'won' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	7	國倫科技	37	won	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1475 AND `vw_customer_sales_flow`.`company_name` = '旭誼工程股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 89 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	1475	旭誼工程股份有限公司	89	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1479 AND `vw_customer_sales_flow`.`company_name` = '聯華電子股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 79 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	1479	聯華電子股份有限公司	79	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 15 AND `vw_customer_sales_flow`.`company_name` = '帆宣系統科技股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 15 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	15	帆宣系統科技股份有限公司	15	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 9 AND `vw_customer_sales_flow`.`company_name` = '亞洲巴萊斯股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 6 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	9	亞洲巴萊斯股份有限公司	6	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 12 AND `vw_customer_sales_flow`.`company_name` = '鴻揚半導體股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 12 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	12	鴻揚半導體股份有限公司	12	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 672 AND `vw_customer_sales_flow`.`company_name` = '聯穎光電股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 73 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	672	聯穎光電股份有限公司	73	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1476 AND `vw_customer_sales_flow`.`company_name` = '世鴻氣體有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 53 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	1476	世鴻氣體有限公司	53	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1479 AND `vw_customer_sales_flow`.`company_name` = '聯華電子股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 76 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	1479	聯華電子股份有限公司	76	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1480 AND `vw_customer_sales_flow`.`company_name` = '新瑞僑氣體股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 82 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	1480	新瑞僑氣體股份有限公司	82	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 16 AND `vw_customer_sales_flow`.`company_name` = '勤實科技' AND `vw_customer_sales_flow`.`quotation_id` = 16 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	16	勤實科技	16	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 18 AND `vw_customer_sales_flow`.`company_name` = '永鈦氣體工業股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 20 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	18	永鈦氣體工業股份有限公司	20	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 6 AND `vw_customer_sales_flow`.`company_name` = '卓益芯奇股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 3 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	6	卓益芯奇股份有限公司	3	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 7 AND `vw_customer_sales_flow`.`company_name` = '國倫科技' AND `vw_customer_sales_flow`.`quotation_id` = 51 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	7	國倫科技	51	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1158 AND `vw_customer_sales_flow`.`company_name` = '台灣日酸股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 60 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	1158	台灣日酸股份有限公司	60	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1476 AND `vw_customer_sales_flow`.`company_name` = '世鴻氣體有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 55 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	1476	世鴻氣體有限公司	55	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1479 AND `vw_customer_sales_flow`.`company_name` = '聯華電子股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 77 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	1479	聯華電子股份有限公司	77	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 1481 AND `vw_customer_sales_flow`.`company_name` = '垚鋐系統科技股份有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 90 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	1481	垚鋐系統科技股份有限公司	90	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 13 AND `vw_customer_sales_flow`.`company_name` = '豐明興業有限公司' AND `vw_customer_sales_flow`.`quotation_id` = 11 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	13	豐明興業有限公司	11	sent	NULL	NULL
編輯	複製	刪除 DELETE FROM vw_customer_sales_flow WHERE `vw_customer_sales_flow`.`customer_id` = 16 AND `vw_customer_sales_flow`.`company_name` = '勤實科技' AND `vw_customer_sales_flow`.`quotation_id` = 17 AND `vw_customer_sales_flow`.`quotation_status` = 'sent' AND `vw_customer_sales_flow`.`project_id` IS NULL AND `vw_customer_sales_flow`.`project_status` IS NULL LIMIT 1	16	勤實科技	17	sent	NULL	NULL

自訂導覽面版外觀。

自訂導覽樹。

伺服器顯示選項。

資料庫顯示選項。

資料表顯示選項。

SQL 上載 ( 0 ) x -

自訂瀏覽模式。

導覽面板