guomao/DOC/DB/01_data/im_menu_data.sql

#平台系统(后台)相关

#数据中心相关
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);