?? setup_data1.sql
字號(hào):
INSERT INTO `#@__area` VALUES (2211, '永州市', 22, 0);
INSERT INTO `#@__area` VALUES (2212, '懷化市', 22, 0);
INSERT INTO `#@__area` VALUES (2213, '婁底市', 22, 0);
INSERT INTO `#@__area` VALUES (2214, '湘西州', 22, 0);
INSERT INTO `#@__area` VALUES (23, '廣西區(qū)', 0, 0);
INSERT INTO `#@__area` VALUES (2301, '南寧市', 23, 0);
INSERT INTO `#@__area` VALUES (2302, '柳州市', 23, 0);
INSERT INTO `#@__area` VALUES (2303, '桂林市', 23, 0);
INSERT INTO `#@__area` VALUES (2304, '梧州市', 23, 0);
INSERT INTO `#@__area` VALUES (2305, '北海市', 23, 0);
INSERT INTO `#@__area` VALUES (2306, '防城港市', 23, 0);
INSERT INTO `#@__area` VALUES (2307, '欽州市', 23, 0);
INSERT INTO `#@__area` VALUES (2308, '貴港市', 23, 0);
INSERT INTO `#@__area` VALUES (2309, '玉林市', 23, 0);
INSERT INTO `#@__area` VALUES (2310, '南寧地區(qū)', 23, 0);
INSERT INTO `#@__area` VALUES (2311, '柳州地區(qū)', 23, 0);
INSERT INTO `#@__area` VALUES (2312, '賀州地區(qū)', 23, 0);
INSERT INTO `#@__area` VALUES (2313, '百色地區(qū)', 23, 0);
INSERT INTO `#@__area` VALUES (2314, '河池地區(qū)', 23, 0);
INSERT INTO `#@__area` VALUES (24, '海南省', 0, 0);
INSERT INTO `#@__area` VALUES (2401, '海口市', 24, 0);
INSERT INTO `#@__area` VALUES (2402, '三亞市', 24, 0);
INSERT INTO `#@__area` VALUES (2403, '五指山市', 24, 0);
INSERT INTO `#@__area` VALUES (2404, '瓊海市', 24, 0);
INSERT INTO `#@__area` VALUES (2405, '儋州市', 24, 0);
INSERT INTO `#@__area` VALUES (2406, '瓊山市', 24, 0);
INSERT INTO `#@__area` VALUES (2407, '文昌市', 24, 0);
INSERT INTO `#@__area` VALUES (2408, '萬寧市', 24, 0);
INSERT INTO `#@__area` VALUES (2409, '東方市', 24, 0);
INSERT INTO `#@__area` VALUES (2410, '澄邁縣', 24, 0);
INSERT INTO `#@__area` VALUES (2411, '定安縣', 24, 0);
INSERT INTO `#@__area` VALUES (2412, '屯昌縣', 24, 0);
INSERT INTO `#@__area` VALUES (2413, '臨高縣', 24, 0);
INSERT INTO `#@__area` VALUES (2414, '白沙縣', 24, 0);
INSERT INTO `#@__area` VALUES (2415, '昌江縣', 24, 0);
INSERT INTO `#@__area` VALUES (2416, '樂東縣', 24, 0);
INSERT INTO `#@__area` VALUES (2417, '陵水縣', 24, 0);
INSERT INTO `#@__area` VALUES (2418, '保亭縣', 24, 0);
INSERT INTO `#@__area` VALUES (2419, '瓊中縣', 24, 0);
INSERT INTO `#@__area` VALUES (25, '云南省', 0, 0);
INSERT INTO `#@__area` VALUES (2501, '昆明市', 25, 0);
INSERT INTO `#@__area` VALUES (2502, '曲靖市', 25, 0);
INSERT INTO `#@__area` VALUES (2503, '玉溪市', 25, 0);
INSERT INTO `#@__area` VALUES (2504, '保山市', 25, 0);
INSERT INTO `#@__area` VALUES (2505, '昭通市', 25, 0);
INSERT INTO `#@__area` VALUES (2506, '思茅地區(qū)', 25, 0);
INSERT INTO `#@__area` VALUES (2507, '臨滄地區(qū)', 25, 0);
INSERT INTO `#@__area` VALUES (2508, '麗江地區(qū)', 25, 0);
INSERT INTO `#@__area` VALUES (2509, '文山州', 25, 0);
INSERT INTO `#@__area` VALUES (2510, '紅河州', 25, 0);
INSERT INTO `#@__area` VALUES (2511, '西雙版納', 25, 0);
INSERT INTO `#@__area` VALUES (2512, '楚雄州', 25, 0);
INSERT INTO `#@__area` VALUES (2513, '大理州', 25, 0);
INSERT INTO `#@__area` VALUES (2514, '德宏州', 25, 0);
INSERT INTO `#@__area` VALUES (2515, '怒江州', 25, 0);
INSERT INTO `#@__area` VALUES (2516, '迪慶州', 25, 0);
INSERT INTO `#@__area` VALUES (26, '貴州省', 0, 0);
INSERT INTO `#@__area` VALUES (2601, '貴陽市', 26, 0);
INSERT INTO `#@__area` VALUES (2602, '六盤水市', 26, 0);
INSERT INTO `#@__area` VALUES (2603, '遵義市', 26, 0);
INSERT INTO `#@__area` VALUES (2604, '安順市', 26, 0);
INSERT INTO `#@__area` VALUES (2605, '銅仁地區(qū)', 26, 0);
INSERT INTO `#@__area` VALUES (2606, '畢節(jié)地區(qū)', 26, 0);
INSERT INTO `#@__area` VALUES (2607, '黔西南州', 26, 0);
INSERT INTO `#@__area` VALUES (2608, '黔東南州', 26, 0);
INSERT INTO `#@__area` VALUES (2609, '黔南州', 26, 0);
INSERT INTO `#@__area` VALUES (27, '西藏區(qū)', 0, 0);
INSERT INTO `#@__area` VALUES (2701, '拉薩市', 27, 0);
INSERT INTO `#@__area` VALUES (2702, '那曲地區(qū)', 27, 0);
INSERT INTO `#@__area` VALUES (2703, '昌都地區(qū)', 27, 0);
INSERT INTO `#@__area` VALUES (2704, '山南地區(qū)', 27, 0);
INSERT INTO `#@__area` VALUES (2705, '日喀則', 27, 0);
INSERT INTO `#@__area` VALUES (2706, '阿里地區(qū)', 27, 0);
INSERT INTO `#@__area` VALUES (2707, '林芝地區(qū)', 27, 0);
INSERT INTO `#@__area` VALUES (28, '甘肅省', 0, 0);
INSERT INTO `#@__area` VALUES (2801, '蘭州市', 28, 0);
INSERT INTO `#@__area` VALUES (2802, '金昌市', 28, 0);
INSERT INTO `#@__area` VALUES (2803, '白銀市', 28, 0);
INSERT INTO `#@__area` VALUES (2804, '天水市', 28, 0);
INSERT INTO `#@__area` VALUES (2805, '嘉峪關(guān)市', 28, 0);
INSERT INTO `#@__area` VALUES (2806, '武威市', 28, 0);
INSERT INTO `#@__area` VALUES (2807, '定西地區(qū)', 28, 0);
INSERT INTO `#@__area` VALUES (2808, '平?jīng)龅貐^(qū)', 28, 0);
INSERT INTO `#@__area` VALUES (2809, '慶陽地區(qū)', 28, 0);
INSERT INTO `#@__area` VALUES (2810, '隴南地區(qū)', 28, 0);
INSERT INTO `#@__area` VALUES (2811, '張掖地區(qū)', 28, 0);
INSERT INTO `#@__area` VALUES (2812, '酒泉地區(qū)', 28, 0);
INSERT INTO `#@__area` VALUES (2813, '甘南州', 28, 0);
INSERT INTO `#@__area` VALUES (2814, '臨夏州', 28, 0);
INSERT INTO `#@__area` VALUES (29, '寧夏區(qū)', 0, 0);
INSERT INTO `#@__area` VALUES (2901, '銀川市', 29, 0);
INSERT INTO `#@__area` VALUES (2902, '石嘴山市', 29, 0);
INSERT INTO `#@__area` VALUES (2903, '吳忠市', 29, 0);
INSERT INTO `#@__area` VALUES (2904, '固原市', 29, 0);
INSERT INTO `#@__area` VALUES (30, '青海省', 0, 0);
INSERT INTO `#@__area` VALUES (3001, '西寧市', 30, 0);
INSERT INTO `#@__area` VALUES (3002, '海東地區(qū)', 30, 0);
INSERT INTO `#@__area` VALUES (3003, '海北州', 30, 0);
INSERT INTO `#@__area` VALUES (3004, '黃南州', 30, 0);
INSERT INTO `#@__area` VALUES (3005, '海南州', 30, 0);
INSERT INTO `#@__area` VALUES (3006, '果洛州', 30, 0);
INSERT INTO `#@__area` VALUES (3007, '玉樹州', 30, 0);
INSERT INTO `#@__area` VALUES (3008, '海西州', 30, 0);
INSERT INTO `#@__area` VALUES (31, '新疆區(qū)', 0, 0);
INSERT INTO `#@__area` VALUES (3101, '烏魯木齊', 31, 0);
INSERT INTO `#@__area` VALUES (3102, '克拉瑪依', 31, 0);
INSERT INTO `#@__area` VALUES (3103, '石河子市', 31, 0);
INSERT INTO `#@__area` VALUES (3104, '吐魯番', 31, 0);
INSERT INTO `#@__area` VALUES (3105, '哈密地區(qū)', 31, 0);
INSERT INTO `#@__area` VALUES (3106, '和田地區(qū)', 31, 0);
INSERT INTO `#@__area` VALUES (3107, '阿克蘇', 31, 0);
INSERT INTO `#@__area` VALUES (3108, '喀什地區(qū)', 31, 0);
INSERT INTO `#@__area` VALUES (3109, '克孜勒蘇', 31, 0);
INSERT INTO `#@__area` VALUES (3110, '巴音郭楞', 31, 0);
INSERT INTO `#@__area` VALUES (3111, '昌吉州', 31, 0);
INSERT INTO `#@__area` VALUES (3112, '博爾塔拉', 31, 0);
INSERT INTO `#@__area` VALUES (3113, '伊犁州', 31, 0);
INSERT INTO `#@__area` VALUES (3117, '東城區(qū)', 1, 0);
INSERT INTO `#@__area` VALUES (32, '香港區(qū)', 0, 0);
INSERT INTO `#@__area` VALUES (33, '澳門區(qū)', 0, 0);
INSERT INTO `#@__area` VALUES (35, '臺(tái)灣省', 0, 0);
INSERT INTO `#@__menu` VALUES (1, '快捷操作菜單', '',0, '');
INSERT INTO `#@__menu` VALUES (9, '系統(tǒng)變量設(shè)置', 'system_basic.php',1, '');
INSERT INTO `#@__menu` VALUES (10, '財(cái)戶管理', 'system_bank.php',1, '');
INSERT INTO `#@__menu` VALUES (11, '產(chǎn)品入庫(kù)', 'system_rk.php',1, '');
INSERT INTO `#@__menu` VALUES (12, '庫(kù)存查詢', 'system_kc.php',1, '');
INSERT INTO `#@__menu` VALUES (13, '產(chǎn)品銷售前臺(tái)', 'sale.php',1, '');
INSERT INTO `#@__menu` VALUES (14, '客戶管理', 'system_guest.php',1, '');
INSERT INTO `#@__menu` VALUES (15, '帳務(wù)查詢', 'system_account.php',1, '');
INSERT INTO `#@__menu` VALUES (2, '系統(tǒng)設(shè)置', '',0, '');
INSERT INTO `#@__menu` VALUES (16, '系統(tǒng)變量設(shè)置', 'system_basic.php',2, '');
INSERT INTO `#@__menu` VALUES (17, '產(chǎn)品基本信息', 'system_basic_cp.php',2, '');
INSERT INTO `#@__menu` VALUES (18, '產(chǎn)品分類管理', 'system_class.php',2, '');
INSERT INTO `#@__menu` VALUES (19, '產(chǎn)品計(jì)量單位管理', 'system_dw.php',2, '');
INSERT INTO `#@__menu` VALUES (20, '供應(yīng)商管理', 'system_gys.php',2, '');
INSERT INTO `#@__menu` VALUES (21, '員工管理', 'system_worker.php',2, '');
INSERT INTO `#@__menu` VALUES (22, '倉(cāng)庫(kù)管理', 'system_lab.php',2, '');
INSERT INTO `#@__menu` VALUES (3, '入庫(kù)管理', '',0, '');
INSERT INTO `#@__menu` VALUES (23, '產(chǎn)品入庫(kù)', 'system_rk.php',3, '');
INSERT INTO `#@__menu` VALUES (24, '入庫(kù)記錄查詢', 'system_rk.php?action=seek',3, '');
INSERT INTO `#@__menu` VALUES (25, '退回供應(yīng)商', 'system_gys_back.php',3, '');
INSERT INTO `#@__menu` VALUES (26, '退回供應(yīng)商查詢', 'system_gys_back.php?action=seek',3, '');
INSERT INTO `#@__menu` VALUES (4, '銷售管理', '',0, '');
INSERT INTO `#@__menu` VALUES (27, '產(chǎn)品銷售平臺(tái)', 'sale.php',4, '');
INSERT INTO `#@__menu` VALUES (28, '銷售記錄查詢', 'sale.php?action=seek',4, '');
INSERT INTO `#@__menu` VALUES (29, '客戶退貨管理', 'sale_back.php',4, '');
INSERT INTO `#@__menu` VALUES (30, '退貨記錄', 'sale_back.php?action=seek',4, '');
INSERT INTO `#@__menu` VALUES (31, '報(bào)廢產(chǎn)品', 'product_destory.php',4, '');
INSERT INTO `#@__menu` VALUES (5, '庫(kù)存管理', '',0, '');
INSERT INTO `#@__menu` VALUES (32, '庫(kù)存情況查詢', 'system_kc.php',5, '');
INSERT INTO `#@__menu` VALUES (33, '倉(cāng)庫(kù)調(diào)拔', 'system_switch.php',5, '');
INSERT INTO `#@__menu` VALUES (34, '調(diào)撥記錄查詢', 'system_switch.php?type=query',5, '');
INSERT INTO `#@__menu` VALUES (35, '庫(kù)存缺貨查詢', 'system_kc_lost.php',5, '');
INSERT INTO `#@__menu` VALUES (6, '客戶管理', '',0, '');
INSERT INTO `#@__menu` VALUES (36, '添加新客戶', 'system_guest.php?action=new',6, '');
INSERT INTO `#@__menu` VALUES (37, '客戶列表', 'system_guest.php',6, '');
INSERT INTO `#@__menu` VALUES (38, '客戶分組', 'guest_group.php',6, '');
INSERT INTO `#@__menu` VALUES (7, '統(tǒng)計(jì)報(bào)表', '',0, '');
INSERT INTO `#@__menu` VALUES (39, '入庫(kù)報(bào)表', 'report_rk.php',7, '');
INSERT INTO `#@__menu` VALUES (40, '銷售報(bào)表', 'report_sale.php',7, '');
INSERT INTO `#@__menu` VALUES (41, '退回供應(yīng)商報(bào)表', 'report_b_gys.php',7, '');
INSERT INTO `#@__menu` VALUES (42, '退貨報(bào)表', 'report_s_back.php',7, '');
INSERT INTO `#@__menu` VALUES (43, '作廢報(bào)表', 'report_none.php',7, '');
INSERT INTO `#@__menu` VALUES (44, '員工工資報(bào)表', 'report_worker.php',7, '');
INSERT INTO `#@__menu` VALUES (8, '財(cái)務(wù)管理', '',0, '');
INSERT INTO `#@__menu` VALUES (45, '帳戶管理', 'bank.php',8, '');
INSERT INTO `#@__menu` VALUES (46, '帳務(wù)分類', 'cate.php',8, '');
INSERT INTO `#@__menu` VALUES (47, '手動(dòng)添加帳務(wù)', 'add_money.php',8, '');
INSERT INTO `#@__menu` VALUES (48, '帳務(wù)查詢', 'system_money.php',8, '');
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -