setup_data1.sql

关于进售存的 好东西

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, '广西区', 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, '南宁地区', 23, 0);
INSERT INTO `#@__area` VALUES (2311, '柳州地区', 23, 0);
INSERT INTO `#@__area` VALUES (2312, '贺州地区', 23, 0);
INSERT INTO `#@__area` VALUES (2313, '百色地区', 23, 0);
INSERT INTO `#@__area` VALUES (2314, '河池地区', 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, '思茅地区', 25, 0);
INSERT INTO `#@__area` VALUES (2507, '临沧地区', 25, 0);
INSERT INTO `#@__area` VALUES (2508, '丽江地区', 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, '铜仁地区', 26, 0);
INSERT INTO `#@__area` VALUES (2606, '毕节地区', 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, '西藏区', 0, 0);
INSERT INTO `#@__area` VALUES (2701, '拉萨市', 27, 0);
INSERT INTO `#@__area` VALUES (2702, '那曲地区', 27, 0);
INSERT INTO `#@__area` VALUES (2703, '昌都地区', 27, 0);
INSERT INTO `#@__area` VALUES (2704, '山南地区', 27, 0);
INSERT INTO `#@__area` VALUES (2705, '日喀则', 27, 0);
INSERT INTO `#@__area` VALUES (2706, '阿里地区', 27, 0);
INSERT INTO `#@__area` VALUES (2707, '林芝地区', 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, '嘉峪关市', 28, 0);
INSERT INTO `#@__area` VALUES (2806, '武威市', 28, 0);
INSERT INTO `#@__area` VALUES (2807, '定西地区', 28, 0);
INSERT INTO `#@__area` VALUES (2808, '平凉地区', 28, 0);
INSERT INTO `#@__area` VALUES (2809, '庆阳地区', 28, 0);
INSERT INTO `#@__area` VALUES (2810, '陇南地区', 28, 0);
INSERT INTO `#@__area` VALUES (2811, '张掖地区', 28, 0);
INSERT INTO `#@__area` VALUES (2812, '酒泉地区', 28, 0);
INSERT INTO `#@__area` VALUES (2813, '甘南州', 28, 0);
INSERT INTO `#@__area` VALUES (2814, '临夏州', 28, 0);
INSERT INTO `#@__area` VALUES (29, '宁夏区', 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, '海东地区', 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, '新疆区', 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, '哈密地区', 31, 0);
INSERT INTO `#@__area` VALUES (3106, '和田地区', 31, 0);
INSERT INTO `#@__area` VALUES (3107, '阿克苏', 31, 0);
INSERT INTO `#@__area` VALUES (3108, '喀什地区', 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, '东城区', 1, 0);
INSERT INTO `#@__area` VALUES (32, '香港区', 0, 0);
INSERT INTO `#@__area` VALUES (33, '澳门区', 0, 0);
INSERT INTO `#@__area` VALUES (35, '台湾省', 0, 0);

INSERT INTO `#@__menu` VALUES (1, '快捷操作菜单', '',0, '');
INSERT INTO `#@__menu` VALUES (9, '系统变量设置', 'system_basic.php',1, '');
INSERT INTO `#@__menu` VALUES (10, '财户管理', 'system_bank.php',1, '');
INSERT INTO `#@__menu` VALUES (11, '产品入库', 'system_rk.php',1, '');
INSERT INTO `#@__menu` VALUES (12, '库存查询', 'system_kc.php',1, '');
INSERT INTO `#@__menu` VALUES (13, '产品销售前台', 'sale.php',1, '');
INSERT INTO `#@__menu` VALUES (14, '客户管理', 'system_guest.php',1, '');
INSERT INTO `#@__menu` VALUES (15, '帐务查询', 'system_account.php',1, '');

INSERT INTO `#@__menu` VALUES (2, '系统设置', '',0, '');
INSERT INTO `#@__menu` VALUES (16, '系统变量设置', 'system_basic.php',2, '');
INSERT INTO `#@__menu` VALUES (17, '产品基本信息', 'system_basic_cp.php',2, '');
INSERT INTO `#@__menu` VALUES (18, '产品分类管理', 'system_class.php',2, '');
INSERT INTO `#@__menu` VALUES (19, '产品计量单位管理', 'system_dw.php',2, '');
INSERT INTO `#@__menu` VALUES (20, '供应商管理', 'system_gys.php',2, '');
INSERT INTO `#@__menu` VALUES (21, '员工管理', 'system_worker.php',2, '');
INSERT INTO `#@__menu` VALUES (22, '仓库管理', 'system_lab.php',2, '');

INSERT INTO `#@__menu` VALUES (3, '入库管理', '',0, '');
INSERT INTO `#@__menu` VALUES (23, '产品入库', 'system_rk.php',3, '');
INSERT INTO `#@__menu` VALUES (24, '入库记录查询', 'system_rk.php?action=seek',3, '');
INSERT INTO `#@__menu` VALUES (25, '退回供应商', 'system_gys_back.php',3, '');
INSERT INTO `#@__menu` VALUES (26, '退回供应商查询', 'system_gys_back.php?action=seek',3, '');

INSERT INTO `#@__menu` VALUES (4, '销售管理', '',0, '');
INSERT INTO `#@__menu` VALUES (27, '产品销售平台', '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, '报废产品', 'product_destory.php',4, '');

INSERT INTO `#@__menu` VALUES (5, '库存管理', '',0, '');
INSERT INTO `#@__menu` VALUES (32, '库存情况查询', 'system_kc.php',5, '');
INSERT INTO `#@__menu` VALUES (33, '仓库调拔', 'system_switch.php',5, '');
INSERT INTO `#@__menu` VALUES (34, '调拨记录查询', 'system_switch.php?type=query',5, '');
INSERT INTO `#@__menu` VALUES (35, '库存缺货查询', '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, '统计报表', '',0, '');
INSERT INTO `#@__menu` VALUES (39, '入库报表', 'report_rk.php',7, '');
INSERT INTO `#@__menu` VALUES (40, '销售报表', 'report_sale.php',7, '');
INSERT INTO `#@__menu` VALUES (41, '退回供应商报表', 'report_b_gys.php',7, '');
INSERT INTO `#@__menu` VALUES (42, '退货报表', 'report_s_back.php',7, '');
INSERT INTO `#@__menu` VALUES (43, '作废报表', 'report_none.php',7, '');
INSERT INTO `#@__menu` VALUES (44, '员工工资报表', 'report_worker.php',7, '');

INSERT INTO `#@__menu` VALUES (8, '财务管理', '',0, '');
INSERT INTO `#@__menu` VALUES (45, '帐户管理', 'bank.php',8, '');
INSERT INTO `#@__menu` VALUES (46, '帐务分类', 'cate.php',8, '');
INSERT INTO `#@__menu` VALUES (47, '手动添加帐务', 'add_money.php',8, '');
INSERT INTO `#@__menu` VALUES (48, '帐务查询', 'system_money.php',8, '');