USE yami_bbc;

insert into `tz_shop_menu` (`menu_id`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `hidden`, `router_name`, `sys_type`) values
('821','0','','','0','members','7','0',NULL,'3'),
('822','821','','','0','geren','1','0',NULL,'3'),
('823','822','/customer/index','','1','','0','0',NULL,'3'),
('824','823','','user:info','2','','0','1',NULL,'3'),
('825','823','','order:order:pageByUserId','2','','0','1',NULL,'3'),
('826','823','','user:userMember:importCustomer','2','','0','1',NULL,'3'),
('827','823','','user:userMember:downloadTemplate','2','','0','1',NULL,'3'),
('828','823','','user:userMember:exportCustomer','2','','0','1',NULL,'3'),
('829','823','','user:userMember:pageCustomer','2','','0','1',NULL,'3'),
('830','823','','user:userLevel:updateUserLevel','2','','0','1',NULL,'3'),
('831','823','','admin:coupon:send','2','','0','0',NULL,'3'),
('832','823','','customer:customerList:edit','2','','0','0',NULL,'3'),
('833','823','','customer:customerList:exportCustomer','2','','0','0',NULL,'3'),
('834','823','','customer:customerList:importCustomer','2','','0','0',NULL,'3'),
('880','0','','','0','inventory','4','0',NULL,'3'),
('883','998','stock/stowage/transfer-order-create/index','','1','','3','1',NULL,'3'),
('884','998','stock/stowage/transfer-order/index','','1','','0','0',NULL,'3'),
('897','880','','','0','','3','0',NULL,'3'),
('898','897','stock/inventory-counting/detail-take-stock','','1','','0','1',NULL,'3'),
('899','898','','multishop:takeStockProd:export','2','','0','0',NULL,'3'),
('900','897','stock/inventory-counting/edit-take-stock','','1','','0','1',NULL,'3'),
('901','900','','multishop:takeStockProd:download','2','','0','0',NULL,'3'),
('902','900','','multishop:takeStockProd:finish','2','','0','0',NULL,'3'),
('903','900','','multishop:takeStockProd:update','2','','0','0',NULL,'3'),
('904','900','','multishop:takeStockProd:import','2','','0','0',NULL,'3'),
('905','900','','multishop:takeStockProd:select','2','','0','0',NULL,'3'),
('906','897','stock/inventory-counting/new-take-stock','','1','','0','1',NULL,'3'),
('907','906','','multishop:takeStock:save','2','','0','0',NULL,'3'),
('908','897','stock/inventory-counting/take-stock','','1','','0','0',NULL,'3'),
('909','908','','stock:takeStockProd:list','2','','0','1',NULL,'3'),
('910','908','','stock:takeStock:page,stock:takeStock:info','2','','0','1',NULL,'3'),
('911','908','','multishop:takeStock:detail','2','','0','0',NULL,'3'),
('912','908','','multishop:takeStock:voided','2','','0','0',NULL,'3'),
('913','908','','multishop:takeStockProd:edit','2','','0','0',NULL,'3'),
('914','908','','multishop:takeStock:export','2','','0','0',NULL,'3'),
('915','908','','multishop:takeStock:new','2','','0','0',NULL,'3'),
('935','880','','','0','','2','0',NULL,'3'),
('936','935','stock/warehouse/send/detail','','1','','0','1',NULL,'3'),
('937','936','','shop:stockBillLog:page,shop:stockBillLog:info','2','','0','1',NULL,'3'),
('938','935','stock/warehouse/receive/detail','','1','','0','1',NULL,'3'),
('939','938','','shop:stockBillLog:page,shop:stockBillLog:info','2','','0','1',NULL,'3'),
('940','935','stock/warehouse/send/add-or-update','','1','','0','1',NULL,'3'),
('941','940','','shop:stockBillLog:voided','2','','0','1',NULL,'3'),
('942','940','','shop:stockBillLog:export','2','','0','1',NULL,'3'),
('943','940','','shop:stockBillLog:update','2','','0','1',NULL,'3'),
('944','940','','shop:stockBillLog:save','2','','0','1',NULL,'3'),
('945','935','stock/warehouse/receive/add-or-update','','1','','0','1',NULL,'3'),
('946','945','','shop:stockBillLog:voided','2','','0','1',NULL,'3'),
('947','945','','shop:stockBillLog:export','2','','0','1',NULL,'3'),
('948','945','','shop:stockBillLog:update','2','','0','1',NULL,'3'),
('949','945','','shop:stockBillLog:save','2','','0','1',NULL,'3'),
('950','935','stock/warehouse/customizereason','','1','','4','0',NULL,'3'),
('951','950','','shop:stockChangeReason:update','2','','0','1',NULL,'3'),
('952','950','','shop:stockChangeReason:save','2','','0','1',NULL,'3'),
('953','950','','shop:stockChangeReason:page,shop:stockChangeReason:list,shop:stockChangeReason:info','2','','0','1',NULL,'3'),
('954','950','','multishop:stockReason:add','2','','0','0',NULL,'3'),
('955','950','','multishop:stockReason:delete','2','','0','0',NULL,'3'),
('956','950','','multishop:stockReason:disable','2','','0','0',NULL,'3'),
('957','950','','multishop:stockReason:enable','2','','0','0',NULL,'3'),
('958','950','','multishop:stockReason:edit','2','','0','0',NULL,'3'),
('959','935','stock/warehouse/send/list','','1','','3','0',NULL,'3'),
('960','959','','shop:stockBillLogItem:import','2','','0','1',NULL,'3'),
('961','959','','shop:stockBillLogItem:downloadModel','2','','0','1',NULL,'3'),
('962','959','','shop:stockBillLogItem:list','2','','0','1',NULL,'3'),
('963','959','','multishop:sendStock:voided','2','','0','0',NULL,'3'),
('964','959','','multishop:sendStock:edit','2','','0','0',NULL,'3'),
('965','959','','multishop:sendStock:add','2','','0','0',NULL,'3'),
('966','959','','multishop:sendStock:export','2','','0','0',NULL,'3'),
('967','935','stock/warehouse/receive/list','','1','','1','0',NULL,'3'),
('968','967','','shop:stockBillLogItem:import','2','','0','1',NULL,'3'),
('969','967','','shop:stockBillLogItem:downloadModel','2','','0','1',NULL,'3'),
('970','967','','shop:stockBillLogItem:list','2','','0','1',NULL,'3'),
('971','967','','multishop:receiveStock:voided','2','','0','0',NULL,'3'),
('972','967','','multishop:receiveStock:edit','2','','0','0',NULL,'3'),
('973','967','','multishop:receiveStock:export','2','','0','0',NULL,'3'),
('974','967','','multishop:receiveStock:add','2','','0','0',NULL,'3'),
('998','880','','','0','','1','0',NULL,'3'),
('999','998','stock/manage/flow','','1','','2','0',NULL,'3'),
('1000','999','','shop:stockBillLogItem:page','2','','0','1',NULL,'3'),
('1001','999','','shop:stockBillLogItem:export','2','','0','1',NULL,'3'),
('1002','999','','multishop:stockFlow:export','2','','0','0',NULL,'3'),
('1003','998','stock/manage/inquire','','1','','1','0',NULL,'3'),
('1004','1003','','sku:export','2','','0','1',NULL,'3'),
('1005','1003','','sku:page','2','','0','1',NULL,'3'),
('1006','1003','','admin:brand:list','2','','0','1',NULL,'3'),
('1007','1003','','multishop:inquireStock:export','2','','0','0',NULL,'3'),
('1016','0','','','0','set','10','0',NULL,'3'),
('1017','1016','','','0','','3','0',NULL,'3'),
('1027','1017','sys/message-manager/platform-notify/index','','1','','0','0',NULL,'3'),
('1028','1027','','shop:notice:info','2','','0','1',NULL,'3'),
('1029','1016','','','0','','1','0',NULL,'3'),
('1030','1029','sys/organization-structure/employee/index','','1','','0','0',NULL,'3'),
('1031','1030','','sys:shopEmployee:page','2','','0','1',NULL,'3'),
('1032','1030','','sys:shopEmployee:delete','2','','0','0',NULL,'3'),
('1033','1030','','sys:shopEmployee:update,sys:shopRole:list','2','','0','0',NULL,'3'),
('1034','1030','','sys:shopEmployee:info,sys:shopEmployee:page','2','','0','0',NULL,'3'),
('1035','1030','','sys:shopEmployee:save,sys:shopRole:list','2','','0','0',NULL,'3'),
('1036','1029','sys/organization-structure/shop-role/index','','1','','1','0',NULL,'3'),
('1037','1036','','sys:shopRole:info','2','','0','1',NULL,'3'),
('1038','1036','','sys:shopMenu:table','2','','0','0',NULL,'3'),
('1039','1036','','sys:shopRole:delete','2','','0','0',NULL,'3'),
('1040','1036','','sys:shopRole:update,sys:shopMenu:list','2','','0','0',NULL,'3'),
('1041','1036','','sys:shopRole:save,sys:shopMenu:list','2','','0','0',NULL,'3'),
('1042','1036','','sys:shopRole:page,sys:shopRole:info','2','','0','0',NULL,'3'),
('1043','1016','','','0','','2','0',NULL,'3'),
('1044','1043','sys/resource/video-store/index','','1','','1','0',NULL,'3'),
('1045','1044','','admin:file:delete','2','','0','1',NULL,'3'),
('1046','1044','','admin:file:update','2','','0','1',NULL,'3'),
('1047','1044','','admin:file:page','2','','0','0',NULL,'3'),
('1048','1044','','admin:fileGroup:delete','2','','0','1',NULL,'3'),
('1049','1044','','admin:fileGroup:update','2','','0','1',NULL,'3'),
('1050','1044','','admin:fileGroup:save','2','','0','1',NULL,'3'),
('1051','1044','','admin:fileGroup:list','2','','0','1',NULL,'3'),
('1052','1043','sys/resource/picture-store/index','','1','','0','0',NULL,'3'),
('1053','1052','','admin:file:delete','2','','0','1',NULL,'3'),
('1054','1052','','admin:file:update','2','','0','1',NULL,'3'),
('1055','1052','','admin:file:page','2','','0','1',NULL,'3'),
('1056','1052','','admin:fileGroup:delete','2','','0','1',NULL,'3'),
('1057','1052','','admin:fileGroup:update','2','','0','1',NULL,'3'),
('1058','1052','','admin:fileGroup:save','2','','0','1',NULL,'3'),
('1059','1052','','admin:fileGroup:list','2','','0','0',NULL,'3'),
('1067','0','','','0','Data','8','0',NULL,'3'),
('1068','1067','','','0','','0','0',NULL,'3'),
('1069','1068','data/data-analysis/prod-insight/index','','1','','1','0',NULL,'3'),
('1070','1069','','multishop:prodAnalysis:pageEffect,multishop:prodAnalysis:effectInfo','2','','0','1',NULL,'3'),
('1073','1067','','','0','','0','0',NULL,'3'),
('1074','1073','data/data-report/form-model/index','','1','','1','0',NULL,'3'),
('1075','1074','','admin:form:list,admin:form:info','2','','0','1',NULL,'3'),
('1076','1073','data/data-report/shop/index','','1','','0','0',NULL,'3'),
('1077','1076','','admin:form:list,admin:form:info','2','','0','1',NULL,'3'),
('1078','1076','','admin:form:page','2','','0','0',NULL,'3'),
('1079','1076','','admin:form:formExcel','2','','0','0',NULL,'3'),
('1080','1076','','admin:form:delete','2','','0','0',NULL,'3'),
('1081','1076','','admin:form:update','2','','0','0',NULL,'3'),
('1082','1076','','admin:form:save','2','','0','0',NULL,'3'),
('1083','0','','','0','order','6','0',NULL,'3'),
('1107','1083','','manageOrders:view','0','','1','0',NULL,'3'),
('1108','1107','/order/virtual-info-log/index','virtual:verify:page','1','','1','0','/order/virtual-info-log/index','3'),
('1109','1108','','virtual:verify:export','2','','0','0',NULL,'3'),
('1117','1107','order/order-info/index','','1','','1','1',NULL,'3'),
('1118','1117','','admin:delivery:list','2','','0','1',NULL,'3'),
('1129','1107','order/order/index','','1','','0','0',NULL,'3'),
('1130','1129','','delivery:printer:list','2','','0','0',NULL,'3'),
('1131','1129','','delivery:outletConfig:list','2','','0','0',NULL,'3'),
('1132','1129','','order:order:export','2','','0','1',NULL,'3'),
('1133','1129','','order:order:update','2','','0','1',NULL,'3'),
('1134','1129','','order:order:info','2','','0','1',NULL,'3'),
('1135','1129','','order:order:page','2','','0','1',NULL,'3'),
('1136','1129','','admin:station:orderInfo','2','','0','1',NULL,'3'),
('1137','1129','','order:delivery:info','2','','0','1',NULL,'3'),
('1138','1129','','order:delivery:deliveryInfo','2','','0','1',NULL,'3'),
('1139','1129','','order:delivery:unDeliveryInfo','2','','0','1',NULL,'3'),
('1140','1129','','order:virtual:update','2','','0','0',NULL,'3'),
('1141','1129','','order:delivery:update','2','','0','0',NULL,'3'),
('1142','1129','','order:get:info','2','','0','0',NULL,'3'),
('1143','1129','','order:order:exportunorder','2','','0','0',NULL,'3'),
('1144','1129','','admin:station:orderItemsDelivery','2','','0','0',NULL,'3'),
('1145','1129','','order:delivery:orderItemsDelivery','2','','0','0',NULL,'3'),
('1152','0','','','0','Marketing','5','0',NULL,'3'),
('1153','1152','marketing/giveaway/add-or-update','','1','','0','1',NULL,'3'),
('1154','1152','marketing/giveaway/index','','1','','3','0',NULL,'3'),
('1155','1154','','shop:giveaway:update','2','','0','1',NULL,'3'),
('1156','1154','','shop:giveaway:save','2','','0','1',NULL,'3'),
('1157','1154','','shop:giveaway:info','2','','0','1',NULL,'3'),
('1158','1154','','shop:giveaway:page','2','','0','1',NULL,'3'),
('1159','1154','','giveaway:giveaway:close','2','','0','0',NULL,'3'),
('1160','1154','','giveaway:giveaway:open','2','','0','0',NULL,'3'),
('1161','1154','','giveaway:giveaway:delete','2','','0','0',NULL,'3'),
('1162','1154','','giveaway:giveaway:edit','2','','0','0',NULL,'3'),
('1163','1154','','giveaway:giveaway:add','2','','0','0',NULL,'3'),
('1164','1152','marketing/combo/add-or-update','','1','','0','1',NULL,'3'),
('1165','1152','marketing/combo/index','','1','','3','0',NULL,'3'),
('1166','1165','','sku:enableList','2','','0','1',NULL,'3'),
('1167','1165','','shop:combo:update','2','','0','1',NULL,'3'),
('1168','1165','','shop:combo:save','2','','0','1',NULL,'3'),
('1169','1165','','shop:combo:info','2','','0','1',NULL,'3'),
('1170','1165','','shop:combo:page','2','','0','1',NULL,'3'),
('1171','1165','','combo:combo:open','2','','0','0',NULL,'3'),
('1172','1165','','combo:combo:close','2','','0','0',NULL,'3'),
('1173','1165','','combo:combo:delete','2','','0','0',NULL,'3'),
('1174','1165','','combo:combo:edit','2','','0','0',NULL,'3'),
('1175','1165','','combo:combo:add','2','','0','0',NULL,'3'),
('1176','1152','marketing/discount/info','','1','','0','1',NULL,'3'),
('1177','1152','/marketing/live-room/new-live-room','','1','','4','1',NULL,'3'),
('1178','1152','','','0','','4','0',NULL,'3'),
('1179','1178','marketing/distribution-prod/new-distribution-prod','','1','','0','1',NULL,'3'),
('1180','1178','marketing/distribution-prod-log/index','','1','','2','0',NULL,'3'),
('1181','1180','','distribution:distributionProd:pageLog','2','','0','1',NULL,'3'),
('1182','1178','marketing/distribution-prod/index','','1','','1','0',NULL,'3'),
('1183','1182','','distribution:distributionProd:offlineInfo','2','','0','1',NULL,'3'),
('1184','1182','','distribution:distributionProd:info','2','','0','1',NULL,'3'),
('1185','1182','','distribution:distributionProd:count','2','','0','1',NULL,'3'),
('1186','1182','','distribution:distributionProd:page','2','','0','0',NULL,'3'),
('1187','1182','','distribution:distributionProd:delete','2','','0','0',NULL,'3'),
('1188','1182','','distribution:distributionProd:update','2','','0','0',NULL,'3'),
('1189','1182','','distribution:distributionProd:save','2','','0','0',NULL,'3'),
('1190','1182','','distribution:distributionProd:auditApply','2','','0','0',NULL,'3'),
('1191','1152','marketing/seckill/add-or-update','','1','','0','1',NULL,'3'),
('1192','1152','marketing/coupon/new-coupon','','1','','0','1',NULL,'3'),
('1193','1152','marketing/live-room/index','','1','','4','0',NULL,'3'),
('1194','1193','','live:liveRoom:listProd','2','','0','1',NULL,'3'),
('1195','1193','','live:liveRoom:info','2','','0','1',NULL,'3'),
('1196','1193','','live:liveRoom:page','2','','0','1',NULL,'3'),
('1197','1193','','live:liveRoom:update','2','','0','0',NULL,'3'),
('1198','1193','','live:liveRoom:delete','2','','0','0',NULL,'3'),
('1199','1193','','live:liveRoom:save','2','','0','0',NULL,'3'),
('1200','1152','marketing/coupon/index','','1','','3','0',NULL,'3'),
('1201','1200','','admin:coupon:offlineInfo','2','','0','1',NULL,'3'),
('1202','1200','','admin:coupon:info','2','','0','1',NULL,'3'),
('1203','1200','','admin:coupon:page','2','','0','0',NULL,'3'),
('1204','1200','','admin:coupon:delete','2','','0','0',NULL,'3'),
('1205','1200','','admin:coupon:update','2','','0','0',NULL,'3'),
('1206','1200','','admin:coupon:save','2','','0','0',NULL,'3'),
('1207','1200','','admin:coupon:auditApply','2','','0','0',NULL,'3'),
('1208','1152','marketing/discount/index','','1','','2','0',NULL,'3'),
('1209','1208','','prod:prod:page','2','','0','1',NULL,'3'),
('1210','1208','','admin:discountProd:info','2','','0','1',NULL,'3'),
('1211','1208','','admin:discount:offlineInfo','2','','0','1',NULL,'3'),
('1212','1208','','admin:discount:info','2','','0','1',NULL,'3'),
('1213','1208','','admin:discount:page','2','','0','1',NULL,'3'),
('1214','1208','','admin:discount:delete','2','','0','0',NULL,'3'),
('1215','1208','','admin:discount:update','2','','0','0',NULL,'3'),
('1216','1208','','admin:discount:save','2','','0','0',NULL,'3'),
('1217','1208','','admin:discount:auditApply','2','','0','0',NULL,'3'),
('1218','1208','','admin:discount:discountProd','2','','0','0',NULL,'3'),
('1219','1152','marketing/seckill/index','','1','','1','0',NULL,'3'),
('1220','1219','','sku:list','2','','0','1',NULL,'3'),
('1221','1219','','seckill:seckill:page','2','','0','1',NULL,'3'),
('1222','1219','','seckill:seckill:auditApply','2','','0','0',NULL,'3'),
('1223','1219','','seckill:seckill:invalid','2','','0','0',NULL,'3'),
('1224','1219','','seckill:seckill:delete','2','','0','0',NULL,'3'),
('1225','1219','','seckill:seckill:info','2','','0','0',NULL,'3'),
('1226','1219','','seckill:seckill:save','2','','0','0',NULL,'3'),
('1227','1152','','','0','','5','0',NULL,'3'),
('1228','1227','group/groupProd','','1','','0','1',NULL,'3'),
('1229','1227','group/newGroupActivity','','1','','0','1',NULL,'3'),
('1230','1227','marketing/group-team/index','','1','','2','0',NULL,'3'),
('1231','1230','','group:team:page','2','','0','1',NULL,'3'),
('1232','1230','','group:order:info','2','','0','1',NULL,'3'),
('1233','1230','','group:order:page','2','','0','0',NULL,'3'),
('1234','1230','','group:team:info','2','','0','0',NULL,'3'),
('1235','1227','marketing/group-activity/index','','1','','1','0',NULL,'3'),
('1236','1235','','sku:list','2','','0','1',NULL,'3'),
('1237','1235','','group:activity:listProd','2','','0','1',NULL,'3'),
('1238','1235','','group:activity:active','2','','0','1',NULL,'3'),
('1239','1235','','group:activity:info','2','','0','1',NULL,'3'),
('1240','1235','','group:activity:page','2','','0','0',NULL,'3'),
('1241','1235','','group:activity:auditApply','2','','0','0',NULL,'3'),
('1242','1235','','group:activity:manage','2','','0','0',NULL,'3'),
('1243','1235','','group:activity:invalid','2','','0','0',NULL,'3'),
('1244','1235','','group:activity:delete','2','','0','0',NULL,'3'),
('1245','1235','','group:activity:update','2','','0','0',NULL,'3'),
('1246','1235','','group:activity:save','2','','0','0',NULL,'3'),
('1247','0','','','0','store','2','0','','3'),
('1248','1247','finance/billing-details/index','','1','','0','1',NULL,'3'),
('1249','1248','','multishop:orderItem:info','2','','0','1',NULL,'3'),
('1287','1247','shop/shop-wallet-log/index','shop:shopWalletLog:view','1','','1','0',NULL,'3'),
('1291','1287','','shop:shopWalletLog:page','2','','0','1',NULL,'3'),
('1292','1287','','shop:shopWallet:info','2','','0','1',NULL,'3'),
('1299','1247','shop/notice/index','','1','','5','0',NULL,'3'),
('1300','1299','','shop:notice:info','2','','0','1',NULL,'3'),
('1301','1299','','shop:notice:page','2','','0','0',NULL,'3'),
('1310','0','','','0','goods','3','0',NULL,'3'),
('1323','1310','prod/spec/index','','1','','4','0',NULL,'3'),
('1324','1323','','prod:spec:page','2','','0','0',NULL,'3'),
('1325','1323','','prod:spec:delete','2','','0','0',NULL,'3'),
('1326','1323','','prod:spec:update','2','','0','0',NULL,'3'),
('1327','1323','','prod:spec:save','2','','0','0',NULL,'3'),
('1335','1310','prod/manage/index','prod:prod:manage:view','1','','0','0','prod-station-manage','3'),
('1336','1335','','prod:spec:list','2','','0','1',NULL,'3'),
('1337','1335','','prod:prod:import','2','','0','1',NULL,'3'),
('1338','1335','','prod:prod:offlineInfo','2','','0','1',NULL,'3'),
('1339','1335','','prod:category:listCategory','2','','0','1',NULL,'3'),
('1340','1335','','prod:prod:page','2','','0','0',NULL,'3'),
('1341','1335','','prod:prod:downloadModel','2','','0','0',NULL,'3'),
('1342','1335','','prod:prod:exportProd','2','','0','0',NULL,'3'),
('1343','1335','','prod:prod:audit','2','','0','0',NULL,'3'),
('1344','1335','','prod:prod:batchDelete','2','','0','0',NULL,'3'),
('1345','1335','','prod:prod:batchStatus','2','','0','0',NULL,'3'),
('1346','1335','','prod:prod:status','2','','0','0',NULL,'3'),
('1347','1335','','prod:prod:delete','2','','0','0',NULL,'3'),
('1348','1335','','prod:prod:update','2','','0','0',NULL,'3'),
('1349','1335','','prod:prod:save','2','','0','0',NULL,'3'),
('1350','1310','prod/post/index','prod:prod:save','1','','1','0',NULL,'3'),
('1351','1350','','admin:brand:page','2','','0','0',NULL,'3'),
('1352','1350','','prod:prod:info','2','','0','1',NULL,'3'),
('1353','1350','','prod:category:listCategory','2','','0','1',NULL,'3'),
('1354','1247','/shop/station-info/index','','1','','0','0',NULL,'3'),
('1355','1354','','station:station:info','2','','0','0','','3'),
('1356','1354','','admin:station:update','2','','0','1',NULL,'3'),
('1357','1107','order/prod-comm/index','','1','','4','0',NULL,'3'),
('1358','1357','','prod:prodComm:save','2','','0','0',NULL,'3'),
('1359','1357','','prod:prodComm:info','2','','0','0',NULL,'3'),
('1360','1357','','prod:prodComm:page','2','','0','0',NULL,'3'),
('1361','1357','','prod:prodComm:delete','2','','0','0',NULL,'3'),
('1362','1357','','prod:prodComm:update','2','','0','0',NULL,'3'),
('1406','1354','','admin:area:list','2','','0','1','','3'),
('1407','1152','/marketing/live-room/data','','1','','5','1',NULL,'3'),
('1408','1193','','live:liveRoom:liveData','2','','0','0',NULL,'3'),
('1409','1193','','live:liveRoom:explain','2','','0','0',NULL,'3'),
('1410','823','','admin:coupon:pageByUserId','2','','0','0','','3');


insert into `tz_shop_menu_lang` (`menu_id`, `lang`, `name`) values
                ('821','0','客户'),
                ('821','1','Customer'),
                ('822','0','客户管理'),
                ('822','1','Manage Customer'),
                ('823','0','客户列表'),
                ('823','1','Customers'),
                ('824','0','获取用户详情'),
                ('824','1','Get User Details'),
                ('825','0','分页查询订单明细'),
                ('825','1','Query order details by page'),
                ('826','0','导入'),
                ('826','1','import'),
                ('827','0','下载模板'),
                ('827','1','Download template'),
                ('828','0','导出'),
                ('828','1','export'),
                ('829','0','分页查询'),
                ('829','1','paging query'),
                ('830','0','更新用户等级'),
                ('830','1','Update user level'),
                ('831','0','送优惠券'),
                ('831','1','sendCoupon'),
                ('832','0','编辑'),
                ('832','1','Edit'),
                ('833','0','导出客户'),
                ('833','1','Export'),
                ('834','0','导入客户'),
                ('834','1','Import'),
                ('880','0','库存'),
                ('880','1','Stock'),
                ('883','0','新建调拨订单'),
                ('884','0','调拨订单'),
                ('884','1','Transfer Order'),
                ('897','0','库存盘点'),
                ('897','1','Inventory Counting'),
                ('898','0','盘点单详情'),
                ('898','1','Inventory details'),
                ('899','0','导出商品明细'),
                ('899','1','Export Product Detail'),
                ('900','0','实盘录入'),
                ('900','1','Live Entry'),
                ('901','0','下载模板'),
                ('901','1','Download Model'),
                ('902','0','完成盘点'),
                ('902','1','Finish Inventory'),
                ('903','0','保存草稿'),
                ('903','1','save draft'),
                ('904','0','导入'),
                ('904','1',' Import'),
                ('905','0','添加商品'),
                ('905','1','Add Product'),
                ('906','0','新建盘点单'),
                ('906','1','New Inventory'),
                ('907','0','实盘录入'),
                ('907','1','Live Entry'),
                ('908','0','实物盘点'),
                ('908','1','Physical Inventory'),
                ('909','0','获取盘点商品列表'),
                ('909','1','Get the inventory list'),
                ('910','0','查询'),
                ('910','1','query'),
                ('911','0','详情'),
                ('911','1','Detail'),
                ('912','0','作废'),
                ('912','1','Voided'),
                ('913','0','编辑'),
                ('913','1','Edit'),
                ('914','0','导出'),
                ('914','1','Export'),
                ('915','0','新建盘点'),
                ('915','1','New Construction Inventory'),
                ('935','0','出入库管理'),
                ('935','1','Warehouse Management'),
                ('936','0','出库明细详情'),
                ('936','1','Send Detail'),
                ('937','0','分页查询'),
                ('937','1','paging query'),
                ('938','0','入库明细详情'),
                ('938','1','Receive Detail'),
                ('939','0','查询'),
                ('939','1','inquire'),
                ('940','0','出库明细'),
                ('940','1','Send Detail'),
                ('941','0','作废'),
                ('941','1','Invalid'),
                ('942','0','导出'),
                ('942','1','export'),
                ('943','0','修改出库明细'),
                ('943','1','Modify the outbound details'),
                ('944','0','新增出入库明细'),
                ('944','1','Add details of incoming and outgoing storage'),
                ('945','0','入库明细'),
                ('945','1','Receive Detail'),
                ('946','0','作废'),
                ('946','1','Invalid'),
                ('947','0','导出'),
                ('947','1','export'),
                ('948','0','修改出入库明细'),
                ('948','1','Modify the import and export details'),
                ('949','0','新增出入库明细'),
                ('949','1','Add details of incoming and outgoing storage'),
                ('950','0','出入库原因'),
                ('950','1','Customizereason'),
                ('951','0','修改'),
                ('951','1','update'),
                ('952','0','新增'),
                ('952','1','save'),
                ('953','0','查询'),
                ('953','1','query'),
                ('954','0','新增'),
                ('954','1','add'),
                ('955','0','删除'),
                ('955','1','delete'),
                ('956','0','禁用'),
                ('956','1','disable'),
                ('957','0','启用'),
                ('957','1','invoke'),
                ('958','0','编辑'),
                ('958','1','edit'),
                ('959','0','出库明细'),
                ('959','1','Send Detail'),
                ('960','0','导入明细项'),
                ('960','1','Import details'),
                ('961','0','下载明细项模板'),
                ('961','1','Download the detail item template'),
                ('962','0','获取明细项列表'),
                ('962','1','Obtain a list of detailed items'),
                ('963','0','作废'),
                ('963','1','Invalid'),
                ('964','0','编辑'),
                ('964','1','edit'),
                ('965','0','新建'),
                ('965','1','new'),
                ('966','0','导出'),
                ('966','1','export'),
                ('967','0','入库明细'),
                ('967','1','Receive Detail'),
                ('968','0','导入明细项'),
                ('968','1','Import details'),
                ('969','0','下载明细项模板'),
                ('969','1','Download the detail item template'),
                ('970','0','获取明细项列表'),
                ('970','1','Obtain a list of detailed items'),
                ('971','0','作废'),
                ('971','1','Invalid'),
                ('972','0','编辑'),
                ('972','1','edit'),
                ('973','0','导出'),
                ('973','1','export'),
                ('974','0','新建'),
                ('974','1','new'),
                ('998','0','库存管理'),
                ('998','1','Stock Manage'),
                ('999','0','库存流水'),
                ('999','1','Stock'),
                ('1000','0','分页查询'),
                ('1000','1','paging query'),
                ('1001','0','导出'),
                ('1001','1','export'),
                ('1002','0','导出'),
                ('1002','1','export'),
                ('1003','0','库存查询'),
                ('1003','1','Stock Inquire'),
                ('1004','0','导出sku'),
                ('1004','1','Export sku'),
                ('1005','0','分页查询sku'),
                ('1005','1','Page query SKUs'),
                ('1006','0','获取品牌列表'),
                ('1006','1','Get a list of brands'),
                ('1007','0','导出'),
                ('1007','1','export'),
                ('1016','0','系统'),
                ('1016','1','System'),
                ('1017','0','消息管理'),
                ('1017','1','Message Management'),
                ('1027','0','平台公告'),
                ('1027','1','Platform announcement'),
                ('1028','0','获取消息详情'),
                ('1028','1','Get message details'),
                ('1029','0','组织架构'),
                ('1029','1','Organizations'),
                ('1030','0','员工列表'),
                ('1030','1','Staff List'),
                ('1031','0','分页获取用户'),
                ('1031','1','Paging fetch'),
                ('1032','0','删除'),
                ('1032','1','Delete'),
                ('1033','0','修改'),
                ('1033','1','Modify'),
                ('1034','0','查看'),
                ('1034','1','View'),
                ('1035','0','新增'),
                ('1035','1','Add'),
                ('1036','0','角色权限'),
                ('1036','1','Role Permissions'),
                ('1037','0','获取角色详情'),
                ('1037','1','Get Role Details'),
                ('1038','0','获取菜单页面的表'),
                ('1038','1','Gets the table for the menu page'),
                ('1039','0','删除'),
                ('1039','1','Delete'),
                ('1040','0','修改'),
                ('1040','1','Modify'),
                ('1041','0','新增'),
                ('1041','1','Add'),
                ('1042','0','查看'),
                ('1042','1','View'),
                ('1043','0','资源管理'),
                ('1043','1','Resources'),
                ('1044','0','视频管理'),
                ('1044','1','Videos'),
                ('1045','0','删除'),
                ('1045','1','delete'),
                ('1046','0','修改'),
                ('1046','1','update'),
                ('1047','0','查询'),
                ('1047','1','query'),
                ('1048','0','删除分组'),
                ('1048','1','Delete group'),
                ('1049','0','修改分组'),
                ('1049','1','update group'),
                ('1050','0','新增分组'),
                ('1050','1','Add group'),
                ('1051','0','查询'),
                ('1051','1','query'),
                ('1052','0','图片管理'),
                ('1052','1','Images'),
                ('1053','0','删除'),
                ('1053','1','delete'),
                ('1054','0','修改'),
                ('1054','1','update'),
                ('1055','0','查询'),
                ('1055','1','query'),
                ('1056','0','删除分组'),
                ('1056','1','Delete group'),
                ('1057','0','修改分组'),
                ('1057','1','update group'),
                ('1058','0','新增分组'),
                ('1058','1','add group'),
                ('1059','0','查询'),
                ('1059','1','query'),
                ('1067','0','数据'),
                ('1067','1','Datas'),
                ('1068','0','数据分析'),
                ('1068','1','Data Analysis'),
                ('1069','0','商品洞察'),
                ('1069','1','Product Insights'),
                ('1070','0','查询'),
                ('1070','1','query'),
                ('1073','0','数据报表'),
                ('1073','1','Report Forms'),
                ('1074','0','推荐报表'),
                ('1074','1','Reports List'),
                ('1075','0','获取报表列表'),
                ('1075','1','Get report list'),
                ('1076','0','我的报表'),
                ('1076','1','My Reports'),
                ('1077','0','获取报表列表'),
                ('1077','1','Get report list'),
                ('1078','0','查看'),
                ('1078','1','Page'),
                ('1079','0','导出'),
                ('1079','1','Export'),
                ('1080','0','删除'),
                ('1080','1','Delete'),
                ('1081','0','修改'),
                ('1081','1','Modify'),
                ('1082','0','新增'),
                ('1082','1','Add'),
                ('1083','0','订单'),
                ('1083','1','Orders'),
                ('1107','0','订单管理'),
                ('1107','1','Manage Orders'),
                ('1108','0','核销记录'),
                ('1108','1','Verification record'),
                ('1109','0','导出'),
                ('1109','1','export'),
                ('1117','0','订单详情'),
                ('1117','1','Order details'),
                ('1118','0','获取快递列表'),
                ('1118','1','Get delivery list'),
                ('1129','0','订单查询'),
                ('1129','1','Search Orders'),
                ('1130','0','获取打印机列表'),
                ('1130','1','Get a list of printers'),
                ('1131','0','获取网点配置列表'),
                ('1131','1','Obtain the network configuration list'),
                ('1132','0','导出excel'),
                ('1132','1','Export excel'),
                ('1133','0','修改订单'),
                ('1133','1','modify order'),
                ('1134','0','获取详情'),
                ('1134','1','Get details'),
                ('1135','0','分页查询订单'),
                ('1135','1','Paging order query'),
                ('1136','0','获取提货订单详情'),
                ('1136','1','Get pick-up order details'),
                ('1137','0','获取物流包裹'),
                ('1137','1','Get logistics packages'),
                ('1138','0','获取物流信息'),
                ('1138','1','Get logistics information'),
                ('1139','0','获取待发货信息'),
                ('1139','1','Get shipping information'),
                ('1140','0','核销'),
                ('1140','1','charge off'),
                ('1141','0','修改物流'),
                ('1141','1','Modified logistics'),
                ('1142','0','查看订单'),
                ('1142','1','View order'),
                ('1143','0','批量发货'),
                ('1143','1','BulkShipping'),
                ('1144','0','提货'),
                ('1144','1','PickUp'),
                ('1145','0','发货'),
                ('1145','1','Shipment'),
                ('1152','0','营销'),
                ('1152','1','Marketing'),
                ('1153','0','新增赠品'),
                ('1153','1','New Giveaway'),
                ('1154','0','赠品'),
                ('1154','1','Giveaway'),
                ('1155','0','修改'),
                ('1155','1','update'),
                ('1156','0','新增'),
                ('1156','1','save'),
                ('1157','0','获取详情'),
                ('1157','1','Get details'),
                ('1158','0','分页查询'),
                ('1158','1','paging query'),
                ('1159','0','关闭'),
                ('1159','1','close'),
                ('1160','0','开启'),
                ('1160','1','open'),
                ('1161','0','删除'),
                ('1161','1','delete'),
                ('1162','0','编辑'),
                ('1162','1','edit'),
                ('1163','0','新增'),
                ('1163','1','Add'),
                ('1164','0','新增套餐'),
                ('1164','1','New Combo'),
                ('1165','0','优惠套餐'),
                ('1165','1','Discount package'),
                ('1166','0','获取可用sku列表'),
                ('1166','1','Gets a list of available SKUs'),
                ('1167','0','修改'),
                ('1167','1','update'),
                ('1168','0','新增'),
                ('1168','1','save'),
                ('1169','0','获取详情'),
                ('1169','1','Get details'),
                ('1170','0','分页查询'),
                ('1170','1','paging query'),
                ('1171','0','开启'),
                ('1171','1','open'),
                ('1172','0','关闭'),
                ('1172','1','close'),
                ('1173','0','删除'),
                ('1173','1','delete'),
                ('1174','0','编辑'),
                ('1174','1','edit'),
                ('1175','0','新增'),
                ('1175','1','Add'),
                ('1176','0','新增限时折扣'),
                ('1176','1','New full discount'),
                ('1177','0','直播间信息'),
                ('1177','1','Information in the broadcast room'),
                ('1178','0','分销管理'),
                ('1178','1','Distributions'),
                ('1179','0','新增分销商品'),
                ('1179','1','New Distribution Products'),
                ('1180','0','分销记录'),
                ('1180','1','Records'),
                ('1181','0','分页查询'),
                ('1181','1','paging query'),
                ('1182','0','分销商品'),
                ('1182','1','Products'),
                ('1183','0','获取下线详情'),
                ('1183','1','Get offline details'),
                ('1184','0','获取详情'),
                ('1184','1','Get details'),
                ('1185','0','获取分销商品数量'),
                ('1185','1','Get the quantity of goods to be distributed'),
                ('1186','0','查看'),
                ('1186','1','Page'),
                ('1187','0','删除'),
                ('1187','1','Delete'),
                ('1188','0','修改'),
                ('1188','1','update'),
                ('1189','0','新增'),
                ('1189','1','Add'),
                ('1190','0','审核'),
                ('1190','1','Audit'),
                ('1191','0',' 新增秒杀活动'),
                ('1191','1','New seconds added'),
                ('1192','0','新增优惠券'),
                ('1192','1','New Coupons'),
                ('1193','0','直播间'),
                ('1193','1','Live Rooms'),
                ('1194','0','获取直播商品列表'),
                ('1194','1','Get a list of live products'),
                ('1195','0','获取详情'),
                ('1195','1','Get details'),
                ('1196','0','分页查询'),
                ('1196','1','paging query'),
                ('1197','0','更新'),
                ('1197','1','Update'),
                ('1198','0','删除'),
                ('1198','1','Delete'),
                ('1199','0','新增'),
                ('1199','1','Add'),
                ('1200','0','优惠券'),
                ('1200','1','Coupons'),
                ('1201','0','获取下线详情'),
                ('1201','1','Get offline details'),
                ('1202','0','获取详情'),
                ('1202','1','Get details'),
                ('1203','0','查看'),
                ('1203','1','Page'),
                ('1204','0','删除'),
                ('1204','1','Delete'),
                ('1205','0','修改'),
                ('1205','1','Modify'),
                ('1206','0','新增'),
                ('1206','1','Add'),
                ('1207','0','审核'),
                ('1207','1','Audit'),
                ('1208','0','限时折扣'),
                ('1208','1','Promotions'),
                ('1209','0','分页查询商品'),
                ('1209','1','Paging product query'),
                ('1210','0','获取商品详情'),
                ('1210','1','Get product details'),
                ('1211','0','获取下线信息'),
                ('1211','1','Get offline information'),
                ('1212','0','获取详情'),
                ('1212','1','Get details'),
                ('1213','0','分页查询'),
                ('1213','1','paging query'),
                ('1214','0','删除'),
                ('1214','1','Delete'),
                ('1215','0','修改'),
                ('1215','1','Modify'),
                ('1216','0','新增'),
                ('1216','1','Add'),
                ('1217','0','审核'),
                ('1217','1','Audit'),
                ('1218','0','查看'),
                ('1218','1','View'),
                ('1219','0','秒杀活动'),
                ('1219','1','Flash Sale'),
                ('1220','0','获取sku列表'),
                ('1220','1','Gets a list of SKUs'),
                ('1221','0','分页查询'),
                ('1221','1','paging query'),
                ('1222','0','审核'),
                ('1222','1','Audit'),
                ('1223','0','失效'),
                ('1223','1','Invalid'),
                ('1224','0','删除'),
                ('1224','1','Delete'),
                ('1225','0','查看'),
                ('1225','1','View'),
                ('1226','0','新增'),
                ('1226','1','Add'),
                ('1227','0','拼团管理'),
                ('1227','1','Group Buying'),
                ('1228','0','管理商品'),
                ('1228','1','Manage commodities'),
                ('1229','0','新建拼团活动'),
                ('1229','1','New group activity'),
                ('1230','0','拼团订单'),
                ('1230','1','Orders'),
                ('1231','0','分页查询拼团队伍'),
                ('1231','1','Paging query for group teams'),
                ('1232','0','获取详情'),
                ('1232','1','Get details'),
                ('1233','0','分页获取'),
                ('1233','1','Paging fetch'),
                ('1234','0','查看同团订单'),
                ('1234','1','View orders in the same group'),
                ('1235','0','拼团活动'),
                ('1235','1','Activities'),
                ('1236','0','获取sku列表'),
                ('1236','1','Gets a list of SKUs'),
                ('1237','0','获取活动商品列表'),
                ('1237','1','Get a list of event items'),
                ('1238','0','开启活动'),
                ('1238','1','Open an activity'),
                ('1239','0','获取详情'),
                ('1239','1','Get details'),
                ('1240','0','查看'),
                ('1240','1','Page'),
                ('1241','0','申请上架'),
                ('1241','1','Apply on shelve'),
                ('1242','0','管理活动商品'),
                ('1242','1','Manage activity item'),
                ('1243','0','失效活动'),
                ('1243','1','Lapsed activity'),
                ('1244','0','删除'),
                ('1244','1','Delete'),
                ('1245','0','修改'),
                ('1245','1','Modify'),
                ('1246','0','新增'),
                ('1246','1','Add'),
                ('1247','0','门店'),
                ('1247','1','Station'),
                ('1248','0','结算明细'),
                ('1248','1','Settlement details'),
                ('1249','0','获取订单商品详情'),
                ('1249','1','Get order item details'),
                ('1287','0','交易记录'),
                ('1287','1','Trading Record'),
                ('1291','0','分页查询店铺钱包日志'),
                ('1291','1','Pagination query store wallet log'),
                ('1292','0','获取钱包详情'),
                ('1292','1','Get wallet Details'),
                ('1299','0','店铺公告'),
                ('1299','1','Shop Notices'),
                ('1300','0','获取消息详情'),
                ('1300','1','Get message details'),
                ('1301','0','查看'),
                ('1301','1','Page'),
                ('1310','0','商品'),
                ('1310','1','Products'),
                ('1323','0','规格管理'),
                ('1323','1','Specifications'),
                ('1324','0','查看'),
                ('1324','1','Page'),
                ('1325','0','删除'),
                ('1325','1','Delete'),
                ('1326','0','修改'),
                ('1326','1','Modify'),
                ('1327','0','新增'),
                ('1327','1','Add'),
                ('1335','0','商品管理'),
                ('1335','1','Manage Products'),
                ('1336','0','获取规格列表'),
                ('1336','1','Get a list of specifications'),
                ('1337','0','导入'),
                ('1337','1','Import'),
                ('1338','0','获取下线信息'),
                ('1338','1','Get offline information'),
                ('1339','0','获取分类列表'),
                ('1339','1','Get category list'),
                ('1340','0','查看'),
                ('1340','1','Page'),
                ('1341','0','下载模板'),
                ('1341','1','Download Template'),
                ('1342','0','导出'),
                ('1342','1','Export'),
                ('1343','0','审核'),
                ('1343','1','Audit'),
                ('1344','0','批量删除'),
                ('1344','1','Batch delete'),
                ('1345','0','批量更新'),
                ('1345','1','Batch Update'),
                ('1346','0','更新状态'),
                ('1346','1','Update Status'),
                ('1347','0','删除'),
                ('1347','1','Delete'),
                ('1348','0','修改'),
                ('1348','1','Modify'),
                ('1349','0','新增'),
                ('1349','1','Add'),
                ('1350','0','发布商品'),
                ('1350','1','Post Products'),
                ('1351','0','品牌列表'),
                ('1351','1','List of brands'),
                ('1352','0','获取商品详情'),
                ('1352','1','Get product details'),
                ('1353','0','获取分类列表'),
                ('1353','1','Get category list'),
                ('1354','0','门店设置'),
                ('1354','1','Station Setting'),
                ('1355','0','获取门店详情'),
                ('1355','1','Get Station Info'),
                ('1356','0','修改门店'),
                ('1356','1','Update Station'),
                ('1357','0','售后评价'),
                ('1357','1','After-sales service'),
                ('1358','0','新增评论'),
                ('1358','1','Add comment'),
                ('1359','0','获取评论详情'),
                ('1359','1','Get comment details'),
                ('1360','0','查看'),
                ('1360','1','view'),
                ('1361','0','删除'),
                ('1361','1','Delete'),
                ('1362','0','修改'),
                ('1362','1','Update'),
                ('1406','0','获取区域列表'),
                ('1406','1','Get Area List'),
                ('1407','0','直播间数据'),
                ('1407','1','Live room data'),
                ('1408','0','直播数据'),
                ('1408','1','Live Data'),
                ('1409','0','商品讲解'),
                ('1409','1','Explain'),
                ('1410','0','获取用户优惠券明细'),
                ('1410','1','Get user coupon details');


#其中411的上级菜单70是商品管理,799的上级菜单784是财务
insert into `tz_sys_menu` (`menu_id`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `hidden`, `router_name`) values
('411','70','','prod:prod:update','2','','0','0',''),
('799','784','/finance/reconciliation-details/index','','1','','0','1','');

INSERT INTO `tz_sys_menu_lang` (`menu_id`, `lang`, `name`) VALUES
('799','0','对账明细'),
('799','1','Reconciliation details'),
('411','0','产品修改'),
('411','1','Product Modify');

#其中上级菜单568是权益管理,602是商品洞察,601是报表管理
INSERT INTO `tz_sys_menu`(`menu_id`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `hidden`)
VALUES
(958, 568, '', 'user:userRights:getMaxSeq', 2, '', 0, 0),
(1066, 602, '', 'platform:prodAnalysis:pageEffect,platform:prodAnalysis:effectInfo', 2, '', 0, 0),
(1048, 601, '', 'platform:form:listItem', 2, '', 0, 0);

INSERT INTO `tz_sys_menu_lang`(`menu_id`, `lang`, `name`)
VALUES
(958, 0, '获取最大序列号'),
(1066, 0, '查询'),
(1048, 0, '获取报表项列表');
