delete from botton_main_table;
delete from category_group_table;
delete from category_table;
delete from config_cmd_table;
delete from cust_type_table;
delete from follow_table;
delete from menu_table;
delete from setting_menu_table;
delete from spec_group_table;  
delete from spec_op_table;  
delete from spec_table;  

INSERT INTO `botton_main_table` (`BottonID`, `L1`, `L2`, `LogoUrl`, `Type`, `Method`, `Weight`, `RightType`, `CreateTime`, `IsShow`, `DoubleCheck`) VALUES (10,'Open Drawer','钱箱','images/icon/icon_cashdraw.png',1,'openCashDraw',9,1,'2018-04-02',0,0),(11,'Order List','订单列表','images/icon/icon_orderlist.png',2,'orderList.html',13,0,'2018-04-10',0,0),(12,'中文','English','images/menuIcon/icon_lang.png',1,'changeLang',3,0,'2018-04-12',0,0),(13,'Map','地图','images/icon/icon_map.png',1,'openMap',6,0,'2018-04-12',1,0),(14,'Send / Print','打印','images/icon/icon_print1.png',2,'sendprint.html',11,0,'2018-04-12',1,0),(15,'Report','报表','images/icon/icon_summary.png',2,'report/index.html',8,3,'2018-04-12',0,0),(16,'Pick Up','取货','images/icon/icon_pickup.png',2,'pickup.html',12,0,'2018-04-12',0,0),(17,'Batch','信用卡','images/icon/icon_batch.png',2,'batch.html',7,2,'2018-04-12',0,0),(18,'Manage','设置','images/icon/icon_manager.png',2,'setting/index.html',2,3,'2018-04-12',0,0),(19,'Time Clock','签到','images/icon/icon_timeclock.png',1,'doSignIn',5,0,'2018-04-12',1,0),(20,'Shut Down','关机','images/icon/icon_shutdown.png',1,'shutdown',1,0,'2018-04-12',1,0),(21,'VIP','VIP','images/icon/icon_vip.png',1,'querygiftcard',4,0,'2018-07-20',1,0),(22,'Modify','修改','images/icon/icon_orderlist.png',2,'modify.html',10,0,'2018-08-10',1,0),(23,'Remote','远程协助','images/icon/icon_remote.png',3,'AnyDesk.exe',0,2,'2018-09-29',0,0),(24,'Cash In/Out','Cash In/Out','images/icon/icon_cashdraw.png',1,'cashinout',0,1,'2019-02-02',1,0);
INSERT INTO `category_group_table` (`CategoryGroupID`, `L1`, `L2`, `IsShow`, `Weight`, `Remark`, `CreateTime`, `Type`, `OnlineShowFlag`, `OnlineLang`) VALUES (1,'Menu','Menu',0,999999,NULL,'2018-11-08',0,0,'');
INSERT INTO `category_table` (`CategoryID`, `L1`, `L2`, `CategoryGroupID`, `IsShow`, `FollowItemGroupID`, `Weight`, `Remark`, `CreateTime`, `Type`, `BottonColor`, `OnlineShowFlag`, `OnlineLang`, `TimeGroupID`, `Picurl`) VALUES (90,'Washin Machine','洗衣机',1,0,'',5,'','2019-10-15',0,'',0,'',0,NULL),(91,'Wash Supplies','洗护用品',1,0,'',4,'','2019-10-15',0,'',0,'',0,NULL),(92,'Drop Off Service','代洗服务',1,0,'10',3,'','2019-10-15',0,'',0,'',0,NULL),(93,'Free','免费',1,0,'',1,'','2019-10-15',0,'',0,'',0,NULL),(94,'Side Order','其它',1,0,'',2,'','2019-10-15',0,'',0,'',0,NULL);
INSERT INTO `config_cmd_table` (`ID`, `L1`, `L2`, `LogoUrl`, `FunGroup`, `Cmd`, `Weight`, `RightType`, `IsShow`, `CreateTime`, `IsMain`, `DoubleCheck`) VALUES (1,'Discount','打折','images/blackIcon/icon_discount.png','paymentfun','discount',0,0,0,'2018-05-10',0,0),(2,'Service Charge','服务费','images/blackIcon/icon_tip.png','paymentfun','tip',0,0,0,'2018-05-10',0,0),(4,'Pay Split','分单','images/blackIcon/icon_split.png','paymentfun','paysplit',0,1,0,'2018-05-10',1,0),(5,'Change Type','类型','images/menuIcon/icon_custtype.png','menurightfun','changetype',12,0,1,'2018-05-10',0,0),(6,'Cook Time','时间','images/menuIcon/icon_date.png','menurightfun','setcooktime',10,0,1,'2018-05-10',0,0),(7,'Discount','折扣','images/menuIcon/icon_discount.png','menurightfun','discount',9,0,0,'2018-05-10',0,0),(8,'Split','分隔符','images/menuIcon/icon_split2.png','menurightfun','split',7,0,0,'2018-05-10',0,0),(9,'Change Price','改价','images/menuIcon/icon_changeprice.png','menurightfun','changeprice',8,0,0,'2018-05-10',0,0),(10,'Self Input','其他','images/menuIcon/icon_changeprice.png','menurightfun','selfinput',4,0,0,'2018-05-10',0,0),(11,'中文','English','images/menuIcon/icon_lang.png','menurightfun','changelang',2,0,0,'2018-05-10',0,0),(12,'Resume','恢复','images/menuIcon/icon_resume.png','menurightfun','resume',3,0,0,'2018-05-10',0,0),(13,'Exit','退出','images/menuIcon/icon_exit.png','menurightfun','exit',1,0,0,'2018-05-10',0,0),(14,'Remove/-','减少/-','','menunumfun','less',0,0,0,'2018-05-10',0,0),(15,'Add/+','增加/+','','menunumfun','add',0,0,0,'2018-05-10',0,0),(16,'Quantity','数量','','menunumfun','num',0,0,0,'2018-05-10',0,0),(17,'Save','存单','images/icon/icon_orderlist.png','menumainfun','save',0,0,0,'2018-05-10',0,0),(18,'Payment','付款','images/icon/icon_payment.png','menumainfun','payment',0,0,0,'2018-05-10',0,0),(19,'Print','打印','images/icon/icon_send.png','menumainfun','send',0,0,0,'2018-05-10',0,0),(20,'Modify','修改','images/icon/icon_update.png','orderlistmainfun','modify',13,0,0,'2018-05-10',0,0),(21,'Print','打印','images/icon/icon_print1.png','orderlistmainfun','printreceipt',12,0,0,'2018-05-10',0,0),(22,'Payment','付款','images/icon/icon_payment.png','orderlistmainfun','payment',11,0,0,'2018-05-10',0,1),(23,'Tip','小费','images/icon/icon_tip.png','orderlistmainfun','tip',10,0,0,'2018-05-10',0,0),(24,'Void Order','取消订单','images/icon/icon_cancelorder.png','orderlistmainfun','voidorder',9,2,0,'2018-05-10',0,1),(25,'Void Pay.','取消付款','images/icon/icon_cancelpayment.png','orderlistmainfun','voidpayment',8,1,0,'2018-05-10',0,1),(26,'Pick Up','取货','images/icon/icon_driver.png','orderlistmainfun','pickup',7,0,0,'2018-05-10',0,0),(27,'Print Sum.','打印日报','images/icon/icon_summary.png','orderlistmainfun','printsummary',6,2,0,'2018-05-10',0,0),(28,'Print List','打印列表','images/icon/icon_print1.png','orderlistmainfun','printlist',5,2,0,'2018-05-10',0,0),(29,'Map','地图','images/icon/icon_map.png','orderlistmainfun','map',4,0,1,'2018-05-10',0,0),(30,'中文','English','images/menuIcon/icon_lang.png','orderlistmainfun','changelang',3,0,0,'2018-05-10',0,0),(31,'Exit','退出','images/menuIcon/icon_exit.png','orderlistmainfun','exit',1,0,0,'2018-05-10',0,0),(32,'List All','全部','','orderlistqueryfun','listall',10,0,0,'2018-05-10',0,0),(33,'List By Date','按日期列出','','orderlistqueryfun','listbydate',9,0,0,'2018-05-10',0,0),(34,'List By Server','按服务员列出','','orderlistqueryfun','listbyserver',8,0,0,'2018-05-10',0,0),(35,'List Unpaid Only','列出未支付','','orderlistqueryfun','listunpaidonly',6,0,0,'2018-05-10',0,0),(40,'More','更多','images/icon/icon_update.png','userinfomainfun','more',0,0,0,'2018-05-11',0,0),(41,'Type','类型','images/menuIcon/icon_custtype.png','userinfomainfun','changetype',0,0,0,'2018-05-11',0,0),(42,'Map','地图','images/icon/icon_map.png','userinfomainfun','map',0,0,0,'2018-05-11',0,0),(43,'Resume','恢复','images/menuIcon/icon_resume.png','userinfomainfun','clear',0,0,0,'2018-05-11',0,0),(44,'Cancel','取消','images/menuIcon/icon_exit.png','userinfomainfun','cancel',0,0,0,'2018-05-11',0,0),(45,'OK','确定','images/icon/icon_orderlist.png','userinfomainfun','ok',0,0,0,'2018-05-11',1,0),(46,'Modify','修改','images/icon/icon_update.png','tableinfomainfun','modify',0,0,0,'2018-06-06',0,0),(47,'Print','打印','images/icon/icon_print1.png','tableinfomainfun','print',0,0,0,'2018-06-06',0,0),(48,'Payment','付款','images/icon/icon_payment.png','tableinfomainfun','payment',0,0,0,'2018-06-06',0,0),(49,'Close','关闭','images/menuIcon/icon_exit.png','tableinfomainfun','close',0,0,0,'2018-06-06',0,0),(50,'Change Table','更改餐桌','','tableinfotablefun','changetable',0,0,0,'2018-06-06',0,0),(51,'Clear Table','清除餐桌','','tableinfotablefun','cleartable',0,0,0,'2018-06-06',0,0),(52,'Add New Guest','加新客人','','tableinfotablefun','addnewguest',0,0,0,'2018-06-06',0,0),(53,'Add More Tables','加新桌子','','tableinfotablefun','addnewtable',0,0,0,'2018-06-06',0,0),(54,'Change Server','更改侍者','','tableinfotablefun','changeserver',0,0,0,'2018-06-06',0,0),(55,'Split Table','分桌','','tableinfotablefun','splittable',0,0,0,'2018-06-06',0,0),(56,'Gift Card','礼品卡','images/icon/icon_giftcard.png','menurightfun','giftcard',6,1,1,'2018-06-19',0,0),(58,'List Paid','列出已付款','','orderlistqueryfun','listpaid',5,0,0,'2018-07-23',0,0),(59,'List Printed','列出已打印','','orderlistqueryfun','listprinted',4,0,0,'2018-07-23',0,0),(60,'LIst void','列出已取消','','orderlistqueryfun','listvoided',1,0,0,'2018-07-23',0,0),(61,'List By PayType','按付款方式','','orderlistqueryfun','listbypaytype',2,0,0,'2018-07-23',0,0),(62,'LIst Un Print','列出未打印','','orderlistqueryfun','listunprinted',3,0,0,'2018-07-23',0,0),(63,'Cust Info','资料','images/icon/icon_summary.png','menurightfun','custinfo',11,0,1,'2018-08-03',0,0),(64,'Pick Up','取货','images/icon/icon_orderlist.png','menurightfun','pickup',13,0,0,'2018-09-21',0,0),(65,'Order List','订单','images/icon/icon_orderlist.png','menurightfun','orderlist',14,0,1,'2018-09-26',0,0),(66,'Quick Pay','快捷付款','images/icon/icon_pay.png','orderlistmainfun','allcashpay',2,2,0,'2018-10-18',0,0);
INSERT INTO `cust_type_table` (`CustType`, `L1`, `L2`, `LogoUrl`, `PreFun`, `IsNoTax`, `MenuID`, `CreateTime`, `Weight`, `IsShow`, `Type`, `DeliveryCharge`, `PrintAddr`, `PrintServer`, `OnlyPrintPhone`, `PrintSelect`, `ShowMode`, `DefaultGroupID`, `DefaultCategoryID`, `FunPrintCopy`, `NeedDelivery`, `ServiceCharge`, `ServiceCustNo`, `QuickPayShow`, `DeliveryChargeMin`, `AutoPrint`, `SelfFlag`) VALUES (4,'Laundry','洗衣','images/icon/icon_market.png',1,0,NULL,'2018-04-10',12,0,2,0,0,1,0,1,1,NULL,NULL,1,2,0.00,0,0,1000000000,0,0),(7,'Gift Card','礼品卡','images/icon/icon_giftcard.png',3,0,NULL,'2018-06-25',3,1,1,0,1,1,0,1,0,NULL,NULL,1,0,0.00,0,0,1000000000,0,0);
INSERT INTO `follow_table` (`FollowID`, `FollowGroupID`, `ItemNo`, `L1`, `L2`, `Price`, `isMain`, `PriceMode`, `Printer`, `IsNoTax`, `IsDiscount`, `Weight`, `Remark`, `CreateTime`, `FollowItemType`, `BottonColor`, `Commission`, `OnlineShowFlag`, `OnlineLang`, `Picurl`, `PrintMode`, `CountGroupID`) VALUES (1,'10','101','Ice Water','冰水',0,1,0,'9',0,0,0,'','2018-11-08',0,'',0,0,'',NULL,0,0),(2,'10','103','Warm Water','温水',0,1,0,'9',0,0,0,'','2018-11-08',0,'',0,0,'',NULL,0,0),(2277,'10','103','Hot Water','热水',0,1,0,'9',0,0,0,'','2019-10-15',0,'',0,0,'',NULL,0,0),(2278,'10','103','Dry Cleaning','干洗',0,1,0,'9',0,0,0,'','2019-10-15',0,'',0,0,'',NULL,0,0);
INSERT INTO `menu_table` (`MenuID`, `CategoryID`, `ItemNo`, `L1`, `L2`, `Price1`, `Price2`, `Price3`, `Price4`, `Price5`, `Price6`, `Price7`, `Price8`, `Price9`, `Price10`, `FollowGroupID`, `isMain`, `PriceMode`, `Printer`, `IsNoTax`, `IsDiscount`, `Weight`, `Remark`, `CreateTime`, `MutliSelect`, `CountGroupID`, `LunchDinnerShow`, `BottonColor`, `WithItem`, `StoreNum`, `Commission`, `FollowGroupID2`, `MutliSelect2`, `FollowGroupID3`, `MutliSelect3`, `FollowGroupID4`, `MutliSelect4`, `FollowGroupID5`, `MutliSelect5`, `FollowGroupID6`, `MutliSelect6`, `FollowGroupID7`, `MutliSelect7`, `FollowGroupID8`, `MutliSelect8`, `OnlineShowFlag`, `OnlineLang`, `NewFlag`, `HotFlag`, `HotLevel`, `LabelInfo`, `Picurl`, `GroupMode`, `FGroupMenuID`) VALUES (11504,89,'I01','Bubble ','珍珠',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2018-11-14',999,0,0,'','',-1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,NULL,NULL,0,NULL),(11505,89,'I02','Red Bean','红豆',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2018-11-14',999,0,0,'','',-1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,NULL,NULL,0,NULL),(11506,89,'I03','Jelly','果冻',75,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2018-11-14',999,0,0,'','',-1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,NULL,NULL,0,NULL),(11507,89,'null04','Oreo Cookies','奥利奥饼干',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11508,89,'I05','Milk','牛奶',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11509,89,'I06','White Sugar','白糖',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11510,89,'I07','Cream Cheese','芝士奶油',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11511,89,'I08','-------','',0,0,0,0,0,0,0,0,0,0,'',0,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11512,89,'I09','Watermelon','西瓜',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11513,89,'I10','Pineapple','菠萝',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11514,89,'I11','Blueberries','蓝莓',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11515,89,'I12','Mango','芒果',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11516,89,'I13','Papaya','木瓜',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11517,89,'I14','Banana','香蕉',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11518,89,'I15','Avocado','奶油果',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11519,89,'I16','Lime','青柠檬',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11520,89,'I17','Yellow Lomon','黄柠檬',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11521,89,'I18','Orange','橙',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11522,89,'I19','Red Pomelo','红柚子',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11523,89,'I19','more ice','多冰',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-22',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11524,89,'I19','less ice','少冰',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-22',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11525,89,'I19','more Sugar','多糖',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-22',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11526,89,'I19','less Sugar','少糖',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-22',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11527,89,'I19','no ice','去冰',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11528,89,'I19','No sugar','不要糖',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11529,89,'I19','no bubble','不要珍珠',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11530,89,'I19','add cream','加奶盖',75,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11531,89,'I19','No jelly','不要果冻',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11532,89,'I19','no red bean','不要红豆',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11535,89,'I19','Fruit tea bag','鲜果森林乌龙',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11536,89,'I19','Osmanthus Oolong tea','金票乌龙',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11537,89,'I19','four season tea','高山青茶',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11538,89,'I19','Dark Oolong tea','太极红岩',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11539,89,'I19','jasmine tea','红颜茉莉',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11540,89,'I19','Oolong tea','金贵乌龙 ',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11605,90,'W1','Washin Machine (20LB)','',325,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11606,90,'W1','Washin Machine (30LB)','',475,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11607,90,'W1','Washin Machine (40LB)','',600,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11608,90,'W1','Washin Machine (60LB)','',875,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11609,90,'W1','Washin Machine (80LB)','',1025,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11610,91,'W1','Tide (25 oz)','',575,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11611,91,'W1','Tide (10 oz)','',300,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11612,91,'W1','Tide (粉)','',200,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11613,91,'W4','Gain (50 oz)','',675,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11614,91,'W4','Gain (25 oz)','',525,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11615,91,'W4','Gain (10 oz)','',275,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11616,91,'W4','XTRA (51 oz)','',425,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11617,91,'W4','A & H Liq Ultar (45 oz)','',550,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11618,91,'W9','45 Gal Bags','洗衣袋',50,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11619,91,'W10','Downy (34 oz)','',475,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11620,91,'W10','Downy (19 oz)','',395,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11621,91,'W10','Downy (10 oz)','',295,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11622,91,'W10','Downy (34 sheets)','',295,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11623,91,'W10','Downy Floral (15.21 oz)','',195,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11624,91,'W10','Suavitel (850ml)','',275,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11625,91,'W10','Suavitel (1ct)','',300,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11626,91,'W17','Bounce','',295,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11627,91,'W18','Clorox Bleach (16 oz)','',150,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11628,91,'W18','Clorox Bleach (30 oz)','',275,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11629,91,'W10','Suavitel Baby','',175,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11630,91,'W21','Fresh\'s Soft','',255,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11631,92,'D1','Drop Off Service (9 LBS)','',870,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11632,92,'D1','Drop Off Service (Minimum 8 LBS OR)','',800,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,2,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11633,92,'D1','Drop Off Service (10 LBS)','',940,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11634,92,'D1','Drop Off Service (11 LBS)','',1010,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11635,92,'D1','Drop Off Service (12 LBS)','',1080,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11636,92,'D1','Drop Off Service (13 LBS)','',1150,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11637,92,'D1','Drop Off Service (14 LBS)','',1220,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11638,92,'D1','Drop Off Service (15 LBS)','',1290,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11639,92,'D1','Drop Off Service (16 LBS)','',1360,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11640,92,'D1','Drop Off Service (17 LBS)','',1430,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11641,92,'D1','Drop Off Service (18 LBS)','',1500,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11642,92,'D1','Drop Off Service (19 LBS)','',1570,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11643,92,'D1','Drop Off Service (20 LBS)','',1640,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11644,92,'D1','Drop Off Service (21 LBS)','',1710,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11645,92,'D1','Drop Off Service (22 LBS)','',1780,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11646,92,'D1','Drop Off Service (23 LBS)','',1850,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11647,92,'D1','Drop Off Service (24 LBS)','',1920,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11648,92,'D1','Drop Off Service (25 LBS)','',1990,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11649,92,'D1','Drop Off Service (26 LBS)','',2060,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11650,92,'D1','Drop Off Service (27 LBS)','',2130,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11651,92,'D1','Drop Off Service (28 LBS)','',2200,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11652,92,'D1','Drop Off Service (29 LBS)','',2270,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11653,92,'D1','Drop Off Service (30 LBS)','',2340,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11654,92,'D1','Drop Off Service (31 LBS)','',2410,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11655,92,'D1','Drop Off Service (32 LBS)','',2480,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11656,92,'D1','Drop Off Service (33 LBS)','',2550,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11657,92,'D1','Drop Off Service (34 LBS)','',2620,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11658,92,'D1','Drop Off Service (35 LBS)','',2690,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11659,92,'D1','Drop Off Service (36 LBS)','',2760,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11660,92,'D1','Drop Off Service (37 LBS)','',2830,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11661,92,'D1','Drop Off Service (38 LBS)','',2990,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11662,92,'D1','Drop Off Service (39 LBS)','',2970,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11663,92,'D1','Drop Off Service (40 LBS)','',3040,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11664,92,'D1','Drop Off Service (41 LBS)','',3110,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11665,92,'D1','Drop Off Service (42 LBS)','',3180,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11666,92,'D1','Drop Off Service (43 LBS)','',3250,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11667,92,'D1','Drop Off Service (44 LBS)','',3320,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11668,92,'D1','Drop Off Service (45 LBS)','',3390,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11669,92,'D1','Drop Off Service (46 LBS)','',3460,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11670,92,'D1','Drop Off Service (47 LBS)','',3530,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11671,92,'D1','Drop Off Service (48 LBS)','',3600,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11672,92,'D1','Drop Off Service (49 LBS)','',3670,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11673,92,'D1','Drop Off Service (50 LBS)','',3740,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11674,92,'D1','Drop Off Service (51 LBS)','',3810,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11675,92,'D1','Drop Off Service (52 LBS)','',3880,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11676,92,'D1','Drop Off Service (53 LBS)','',3950,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11677,92,'D1','Drop Off Service (54 LBS)','',4020,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11678,92,'D1','Drop Off Service (55 LBS)','',4090,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,1,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11679,92,'D49','Samll Blanket','',500,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11680,92,'D49','Big Blanket','',600,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11681,93,'F1','Free Soap','',0,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11682,93,'F2','Free Drier','',0,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11683,94,'S1','Cigarettes','',0,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11684,94,'S2','Snacks','',0,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11685,94,'S3','Phone Cards Available','',0,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11686,94,'S4','Palottery','',0,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11687,94,'S5','Bottle Snapple','',195,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11688,94,'S5','Bottle Coke','',195,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11689,94,'S5','Bottle Diet Coke','',195,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11690,94,'S5','Bottle Sprite','',195,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11691,94,'S5','Bottle Ginger Ale','',195,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11692,94,'S5','Bottle Pepsi','',195,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11693,94,'S5','Bottle Diet Pepsi','',195,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11694,94,'S12','Spring Water','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11695,94,'S13','Can Coke','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11696,94,'S13','Can Diet Coke','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11697,94,'S13','Can Sprite','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11698,94,'S13','Can Fanta Orange','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11699,94,'S13','Can Lemonade','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11700,94,'S13','Can Ginger Ale','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11701,94,'S13','Can Mtn Dew','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11702,94,'S13','Can Pepsi','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL),(11703,94,'S13','Can Diet Pepsi','',100,0,0,0,0,0,0,0,0,0,'',0,0,'',0,0,0,'','2019-10-15',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,'',0,0,0,'','',0,NULL);
INSERT INTO `setting_menu_table` (`ID`, `FID`, `L1`, `L2`, `TargetUrl`, `CreateTime`, `Weight`, `MenuGroup`, `Status`, `RightType`, `LogoUrl`) VALUES (1,0,'Base Setting','基础设置',NULL,'2018-06-07',0,0,0,0,NULL),(2,0,'Menu Setting','菜单设置',NULL,'2018-06-07',0,0,0,0,NULL),(3,0,'Module Setting','功能设置',NULL,'2018-06-07',0,0,0,0,NULL),(4,0,'Options Setting','选项设置',NULL,'2018-06-07',0,0,0,0,NULL),(5,1,'UTOP Setting','主要信息设置','utop.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_maininfo.png'),(6,1,'Cust Type Setting','客户类型设置','custType.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_custtype.png'),(7,1,'Pay Type Setting','付款类型设置','payType.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_paytype.png'),(9,1,'Printer Setting','打印机设置','printer.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_printset.png'),(10,2,'Group Setting','菜单组设置','categoryGroup.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menugroupset.png'),(12,2,'Menu Setting','菜单设置','category.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menuset.png'),(13,2,'Follow Setting','跟随项设置','follow.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_followset.png'),(14,3,'Index Setting','首页功能设置','indexpage.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_indexset.png'),(15,3,'Menu Right Setting','点单页右侧栏设置','configCmd.html?funGroup=menurightfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menurightset.png'),(16,3,'Menu Main Setting','点单页主功能设置','configCmd.html?funGroup=menumainfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menumainset.png'),(17,3,'Menu Num Setting','点单页数量功能设置','configCmd.html?funGroup=menunumfun&needlogo=0','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menunumset.png'),(18,3,'Payment Setting','	付款页功能设置\r\n','configCmd.html?funGroup=paymentfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_paymentset.png'),(19,3,'Order Main Setting','订单页面主功能设置','configCmd.html?funGroup=orderlistmainfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_ordermainset.png'),(20,3,'Order Query Setting','订单页面查询功能设置','configCmd.html?funGroup=orderlistqueryfun&needlogo=0','2018-06-07',0,0,0,0,'/images/blackIcon/icon_orderqueryset.png'),(21,3,'User Main Setting','用户信息页面主功能设置','configCmd.html?funGroup=userinfomainfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_usermainset.png'),(24,4,'Print Options Setting',' 打印选项设置','options.html?settingGroup=1','2018-06-07',0,0,0,0,'/images/blackIcon/icon_printoptions.png'),(25,4,'Right Setting','权限设置','options.html?settingGroup=2','2018-06-07',0,0,0,0,'/images/blackIcon/icon_rightoptions.png'),(26,2,'Spec Group Setting','特殊组设置','specGroup.html','2018-06-14',0,0,0,0,'/images/blackIcon/icon_specgroupset.png'),(27,2,'Spec Setting','特殊项设置','spec.html','2018-06-14',0,0,0,0,'/images/blackIcon/icon_specset.png'),(28,2,'Spec Operation Setting','特殊操作设置','specOperation.html','2018-06-14',0,0,0,0,'/images/blackIcon/icon_specopset.png'),(29,1,'User Setting','用户设置','user.html','2018-06-15',0,0,0,0,'/images/blackIcon/icon_userset.png'),(31,4,'Display Options Setting','显示选项设置','options.html?settingGroup=4&menudisplayflag=1','2018-06-22',0,0,0,0,'/images/blackIcon/icon_displayoptions.png'),(32,4,'Business Setting','营业设置','options.html?settingGroup=3','2018-06-22',0,0,0,0,'/images/blackIcon/icon_busoptions.png'),(33,4,'Double Display Setting','双屏设置','options.html?settingGroup=5','2018-06-22',0,0,0,0,'/images/blackIcon/icon_doubledisplayoptions.png'),(34,0,'Report Setting','报表设置',NULL,'2018-06-25',0,0,0,0,NULL),(35,34,'Group Setting','统计组设置','countgourp.html','2018-06-25',0,0,0,0,'/images/blackIcon/icon_countgroupset.png'),(36,4,'Hardware Setting','外设设置','options.html?settingGroup=6','2018-06-26',0,0,0,0,'/images/blackIcon/icon_hardwareoptions.png'),(37,0,'PAX Setting','PAX刷卡设置',NULL,'2018-06-29',0,0,0,0,NULL),(38,37,'Machine Setting','刷卡机设置','reader.html','2018-06-29',0,0,0,0,'/images/blackIcon/icon_paxset.png'),(39,0,'Other Setting','其他设置',NULL,'2018-07-12',0,0,0,0,NULL),(40,39,'Tip Rate Setting','小费比例设置','commonConf.html?groupID=1','2018-07-12',0,0,0,0,'/images/blackIcon/icon_rateset.png'),(41,39,'Tip Amount Setting','小费金额设置','commonConf.html?groupID=2','2018-07-12',0,0,0,0,'/images/blackIcon/icon_amountset.png'),(42,39,'Discount Rate Setting','打折比例设置','commonConf.html?groupID=3','2018-07-12',0,0,0,0,'/images/blackIcon/icon_rateset.png'),(43,39,'Discount Amount Setting','打折金额设置','commonConf.html?groupID=4','2018-07-12',0,0,0,0,'/images/blackIcon/icon_amountset.png'),(44,39,'Tip Suggestion','建议小费','tipSuggestion.html','2018-08-10',0,0,0,0,'/images/blackIcon/icon_tipsuggestionset.png'),(45,1,'System Setting','系统设置','systemConf.html','2018-09-06',0,0,0,0,'/images/blackIcon/icon_sysset.png'),(1001,0,'Total Report','统计报表','','2018-06-20',0,1,0,0,NULL),(1002,0,'Other Report','其他报表','','2018-06-20',0,1,0,0,NULL),(1003,1001,'Daily Report','日报表','dailyreport.html','2018-06-20',0,1,0,0,'/images/blackIcon/icon_report1.png'),(1004,1001,'Detail Report','细目报表','detailreport.html','2018-06-20',4,1,0,0,'/images/blackIcon/icon_report2.png'),(1005,1001,'Monthly Report','月报表','monthreport.html','2018-06-20',2,1,0,0,'/images/blackIcon/icon_report3.png'),(1006,1002,'Employee Report','员工报表','employeereport.html','2018-06-20',0,1,0,0,'/images/blackIcon/icon_userreport.png'),(1008,1001,'Yearly Report','年报表','yearreport.html','2018-06-21',3,1,0,0,'/images/blackIcon/icon_report4.png'),(1009,1001,'Weekly Report','周报表','weeklyreport.html','2018-06-21',1,1,0,0,'/images/blackIcon/icon_report5.png'),(1010,1002,'Cost Report','成本报表','commissionReport.html','2018-09-19',0,1,0,0,'/images/blackIcon/icon_costreport.png'),(1011,1002,'Store Log Report','库存变动报表','storeLogReport.html','2019-02-02',0,1,0,0,'/images/blackIcon/icon_storelogreport.png'),(1012,1002,'Store Report','库存报表','storeReport.html','2019-02-02',0,1,0,0,'/images/blackIcon/icon_store.png'),(1013,1002,'Cash In/Out Report','Cash In/Out报表','cashinoutReport.html','2019-02-02',0,1,0,0,'/images/blackIcon/icon_cashinoutreport.png'),(1017,39,'Pay Amount Setting','付款金额配置','commonConf.html?groupID=5','2019-04-23',0,0,0,0,'/images/blackIcon/icon_paymentamountset.png'),(1018,39,'Special Amount Setting','调味金额配置','commonConf.html?groupID=6','2019-04-23',0,0,0,0,'/images/blackIcon/icon_specamountset.png'),(1019,39,'Online Order Setting','在线网站配置','onlineOrder.html','2019-04-23',0,0,0,0,'/images/blackIcon/icon_onlineorderset.png'),(1025,2,'Time Group Setting','时间组配置','timeGroup.html','2020-08-11',0,0,0,0,'/images/blackIcon/icon_time.png'),(1026,39,'Time Select Setting','时间选择配置','commonConf.html?groupID=7','2020-08-11',0,0,0,0,'/images/blackIcon/icon_time.png'),(1027,1002,'Payout Report','支出报表','payout.html','2020-08-11',0,1,0,0,'/images/blackIcon/icon_costreport.png');