﻿------------屏蔽原来废弃的菜单及无用菜单:E邮宝订单/4PX配置/采购流程/产品销售管理/增加商品网名/商品网名管理/今日订单/作废订单/Zenrt配置/下载Zenrt订单/------
--------------上传ebay订单/上传速卖通订单/上传亚马逊订单/上传通用订单/产品导出/新增单个产品---------------------------------------
delete from db_opermenu where menuid in('1110','1317','4104','5105','2203','2204','2213','2214','1102','1108','7112','1311','1306','1307','1308','1309','2105','2101');
delete from db_menufunc where funid in('1110','1317','4104','5105','2203','2204','2213','2214','1102','1108','7112','1311','1306','1307','1308','1309','2105','2101');
----------------------退货管理-----------------------
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE,RESERVE5) VALUES('1500','退货管理','退货管理','#','0','2','1000','3','5','2');
INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','1500');
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE) VALUES('9007','退货列表','退货列表','/eshop/order.do?method=returnProductList','0','3','1500','1','3');INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','9007');
INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','9007');
-----------------------订单运单号管理----------------
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE) VALUES('1315','订单运单号管理','订单运单号管理','/eshop/expresstype.do?method=expressidlist','0','3','1300','30','3');
INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','1315');
-----------------------商品搜索脚本------------------
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE) VALUES('2212','商品搜索脚本','商品搜索脚本','/eshop/product.do?method=productSearchList','0','3','2200','5','3');
INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','2212');
-----------------------手动入库----------------------
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE) VALUES('2110','手动入库','手动入库','/eshop/purchase.do?method=handstorage','0','3','2100','20','3');
INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','2110');
-----------------------手动出库----------------------
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE) VALUES('2111','手动出库','手动出库','/eshop/company.do?method=findoutbound','0','3','2100','25','3');
INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','2111');
-----------------------调拔清单----------------------
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE) VALUES('4203','调拨清单','调拨清单','/eshop/brand.do?method=DiaoboList','0','3','4200','1','3');
INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','4203');
-----------------------异常调拔单--------------------
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE) VALUES('4202','异常调拨单','异常调拨单','/eshop/purchase.do?method=questionAllocate','0','3','4200','5','3');
INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','4202');
-----------------------销售项目管理------------------
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE) VALUES('5114','销售项目管理','销售项目管理','/eshop/project.do?method=listbbs','0','3','5100','20','3');
INSERT INTO DB_OPERMENU (OPER,MENUID) VALUES('admin','5114');
-------------------------订单上传-------------------
INSERT INTO DB_MENUFUNC (FUNID,FUNNAME,FUNDESC,URL,IFWINOPEN,IFPARENT,PARENTID,SORT,TYPE) VALUES('1317','订单上传','订单上传','/eshop/other.do?method=touploadfile','0','3','1300','1','3');
insert into db_opermenu values('admin',1317);

