#平台系统(后台)相关 #数据中心相关 insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('F01000','数据中心','进行系统角色、用户的管理','M00000','0','1','1',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M01000','系统管理','进行系统角色、用户的管理','F01000','0','2','1',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M02000','客户管理','进行客户、信用、部门的管理','F01000','0','2','2',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M05000','商品管理','商品品牌、分类、类目的增删改查','F01000','0','2','3',NULL); #业务中心相关 insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('F02000','业务中心 ','业务模块','M00000','0','1','2',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M09000','采购管理','采购合同、采购订单','F02000','0','2','4',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M10000','销售管理','销售合同、销售订单','F02000','0','2','6',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M12000','发票管理','发票查看及申请','F02000','0','2','13',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M13000','物流管理','物流信息查看','F02000','0','2','6',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M14000','支付管理','收付款信息查看','F02000','0','2','9',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M21000','预付款管理','预付款添加','F02000','0','2','9',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M33000','出入库单管理','出入库单管理','F02000','0','2','21',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M48000','供应链管理','供应链管理','F02000','0','2','22',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M02001','系统内采购','系统内采购-发货到厂或直发','F02000','0','2','5',NULL); #仓储信息 insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('F05000','仓储信息','仓储管理','M00000','0','1','3',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M06000','仓储管理','用于创建仓库等操作','F05000','0','2','7',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M08000','结算管理','结算规则的添加、结算管理、仓储费用管理','F05000','0','2','10',NULL); #协同管理 insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('F06000','协同管理','协同管理','M00000','0','1','4',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M07000','协同管理','进行生产计划,采购计划,生产计划上报,发货计划的增删改查','F06000','0','2','11',NULL); #消息中心相关 insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('F03000','消息中心 ','业务模块','M00000','0','1','6',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M03000','信息管理','进行文章、信息的管理','F03000','0','2','14',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M11000','消息管理','消息查看,消息审批','F03000','0','2','12',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M04000','安全管理','日志查看','F03000','0','2','15',NULL); #报表相关 insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('F04000','报表信息 ','物流、氧化铝、铝产品、订单、合同报表','M00000','0','1','5',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M15000','物流相关','山西成品、铁路运输、货物对账单','F04000','0','2','8',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M16000','铝产品相关','铝锭在途,月度库存,生产计划,铝锭产存,铝锭销售','F04000','0','2','16',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M17000','氧化铝相关','山西库存,生产计划,对账单统计,当前订单,港口物流','F04000','0','2','17',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M18000','订单相关','发票,物流,收付款','F04000','0','2','18',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M19000','合同相关','现货合同,上海采销合同','F04000','0','2','19',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M20000','综合对账表','综合对账单','F04000','0','2','20',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M24000','长单进度管理','长单进度管理','F04000','0','2','24',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M22000','厂内库存管理','综合对账单','F02000','0','2','20',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M25000','价格管理表','价格管理','F04000','0','2','25',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M26000','进度管理表','进度管理','F04000','0','2','26',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M27000','日常统计表','日常管理','F04000','0','2','27',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M28000','上报管理表','上报管理','F04000','0','2','28',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M29000','分析管理表','分析管理','F04000','0','2','29',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M30000','财务核对表','财务核对管理','F04000','0','2','30',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M31000','合同管理表','合同管理','F04000','0','2','31',NULL); insert into `im_menu` (`MEU_ID`, `MEU_NAME`, `MEU_DESC`, `MEU_PARENTID`, `MEU_STT`, `MEU_LEVEL`, `MEU_SERIALNO`, `MEU_IMG_PATH`) values('M32000','购销统计表','购销统计管理','F04000','0','2','32',NULL);