2024-03-10 23:59:01 -- == sync_order start == 2024-03-10 23:59:01 -- start:2024-03-10,end:2024-03-10 2024-03-10 23:59:01 -- == select june1.order_list == SELECT l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-03-10%' OR l.modify_date like '2024-03-10%'; 2024-03-10 23:59:02 -- == sync omo_order_list == 2024-03-10 23:59:02 -- == update lake.omo_order_list == update omo_order_list set userId = '380330', process_status = '3', pay_status = '1', totalprice_after = '2950', lunar_date = '2024-01-26', invoice_status = '1',category_name = '永康門市訂單', category_id = '31' where ordernumber = 'S24030019750' 2024-03-10 23:59:02 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344093','380861',1,'','','O24030030830','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1350','600','嘉義市','西區','600','嘉義市','西區','1470','2024-03-10 00:25:43','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344097','380865',1,'','','O24030030942','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','535','732','台南市','白河區','732','台南市','白河區','655','2024-03-10 02:06:18','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('343654','380424',1,'','','O24030031022','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','30','3385','235','新北市','中和區','235','新北市','中和區','3505','2024-03-10 06:59:46','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('274588','312178',1,'','','O24030031195','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2065','221','新北市','汐止區','221','新北市','汐止區','2215','2024-03-10 10:25:28','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('317965','355047',1,'','','O24030031255','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','590','640','雲林縣','斗六市','640','雲林縣','斗六市','740','2024-03-10 13:33:20','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('192628','158803',1,'','','O24030031372','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1300','248','新北市','五股區','248','新北市','五股區','1450','2024-03-10 15:48:43','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344189','380957',1,'','','O24030031491','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','699','206','基隆市','七堵區','206','基隆市','七堵區','819','2024-03-10 15:53:52','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344187','380955',1,'','','O24030031559','1','1','1','1','1','','','0','0000-00-00','0','0','0','','0','30','5760','813','高雄市','左營區','840','高雄市','大樹區','5730','2024-03-10 16:03:55','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344218','380986',1,'','','O24030031683','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','3135','709','台南市','安南區','709','台南市','安南區','3255','2024-03-10 17:23:34','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('329211','366151',1,'','','O24030031787','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','885','502','彰化縣','芬園鄉','502','彰化縣','芬園鄉','1035','2024-03-10 18:10:03','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344234','381002',1,'','','O24030031871','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','480','235','新北市','中和區','235','新北市','中和區','630','2024-03-10 18:10:40','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344237','381005',1,'','','O24030031945','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','490','900','屏東縣','屏東市','900','屏東縣','屏東市','640','2024-03-10 18:12:22','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('336955','373805',1,'','','O24030032074','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1460','105','台北市','松山區','105','台北市','松山區','1610','2024-03-10 18:43:28','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344246','381014',1,'','','O24030032180','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1120','557','南投縣','竹山鎮','557','南投縣','竹山鎮','1240','2024-03-10 19:34:37','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344247','381015',1,'','','O24030032232','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1600','114','台北市','內湖區','114','台北市','內湖區','1720','2024-03-10 19:43:35','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('341698','378485',1,'','','O24030032353','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1224','700','台南市','中西區','701','台南市','東區','1374','2024-03-10 20:56:09','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344253','248416',1,'','','O24030032456','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','800','320','桃園市','中壢區','320','桃園市','中壢區','950','2024-03-10 21:14:24','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344254','381021',1,'','','O24030032565','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1350','330','桃園市','桃園區','653','雲林縣','口湖鄉','1470','2024-03-10 21:28:07','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('343853','380623',1,'','','O24030032616','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','30','699','363','苗栗縣','公館鄉','363','苗栗縣','公館鄉','819','2024-03-10 21:36:18','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('327969','364919',1,'','','O24030032732','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','885','710','台南市','永康區','710','台南市','永康區','1035','2024-03-10 21:42:46','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('94764','66140',1,'','','O24030032836','1','11','1','1','1','23932336','富蘭克林證券投資顧問股份有限公司','0','0000-00-00','0','0','0','','0','0','5900','112','台北市','北投區','112','台北市','北投區','5900','2024-03-10 23:30:41','2024-02-01') 2024-03-10 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('321631','358647',1,'','','O24030032974','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','1199','514','彰化縣','溪湖鎮','514','彰化縣','溪湖鎮','1349','2024-03-10 23:53:20','2024-02-01') 2024-03-10 23:59:03 -- == sync_order end == 2024-03-10 23:59:03 -- == sync_order_detail start == 2024-03-10 23:59:03 -- start:2024-03-10,end:2024-03-10 2024-03-10 23:59:03 -- == sync omo_order_detail == 2024-03-10 23:59:03 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-03-10%' OR modify_date like '2024-03-10%' 2024-03-10 23:59:04 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24030019750' and product_code = 'DG010206-01' 2024-03-10 23:59:04 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229471',`firm_id` = '8',`ordernumber` = 'S24030019750', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '10',`total_price` = '2950',`etd` = '2024-03-07',`create_date` = '2024-03-06 12:49:32',`modify_date` = '2024-03-10 17:32:20',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-01-26'where ordernumber = 'S24030019750' and product_code = 'DG010206-01' 2024-03-10 23:59:04 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030030830' and product_code = 'DG010567-86' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229586','8','O24030030830','熱銷蛋捲六入組','DG010567-86','DG010567','原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶','組合-32入(原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','1','1350','2024-03-13','2024-03-10 00:25:43','2024-03-10 23:59:04',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229586',`firm_id` = '8',`ordernumber` = 'O24030030830', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-86',`product_sn` = 'DG010567',`product_spec` = '原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-03-13',`create_date` = '2024-03-10 00:25:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030030830' and product_code = 'DG010567-86' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030030942' and product_code = 'DG010107-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229587','8','O24030030942','阿薩姆紅茶蛋捲','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','0','1','0.0','1','240','2024-03-12','2024-03-10 02:06:18','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229587',`firm_id` = '8',`ordernumber` = 'O24030030942', `product_name` = '阿薩姆紅茶蛋捲',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2024-03-12',`create_date` = '2024-03-10 02:06:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030030942' and product_code = 'DG010107-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030030942' and product_code = 'DG010258-05' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229587','8','O24030030942','金豐收8結提盒','DG010258-05','DG010258','40入巧克力蛋捲','提盒-金豐收(藍)-40入巧克力','295','295','0','0','0','0','1','0.0','1','295','2024-03-12','2024-03-10 02:06:18','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229587',`firm_id` = '8',`ordernumber` = 'O24030030942', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-05',`product_sn` = 'DG010258',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入巧克力',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-03-12',`create_date` = '2024-03-10 02:06:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030030942' and product_code = 'DG010258-05' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031022' and product_code = 'DG010258-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229588','8','O24030031022','金豐收8結提盒','DG010258-01','DG010258','40入原味蛋捲','提盒-金豐收(藍)-40入原味','295','295','0','0','0','0','1','0.0','3','885','2024-03-21','2024-03-10 06:59:46','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229588',`firm_id` = '8',`ordernumber` = 'O24030031022', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-01',`product_sn` = 'DG010258',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入原味',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '885',`etd` = '2024-03-21',`create_date` = '2024-03-10 06:59:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031022' and product_code = 'DG010258-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031022' and product_code = 'DG0103155-12' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229588','8','O24030031022','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-12','DG0103155','咖啡蛋捲,巧克力蛋捲','禮盒-SNOOPY【咖啡+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2024-03-21','2024-03-10 06:59:46','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229588',`firm_id` = '8',`ordernumber` = 'O24030031022', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-12',`product_sn` = 'DG0103155',`product_spec` = '咖啡蛋捲,巧克力蛋捲',`invoice_name` = '禮盒-SNOOPY【咖啡+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-03-21',`create_date` = '2024-03-10 06:59:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031022' and product_code = 'DG0103155-12' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031022' and product_code = 'DG010394-12' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229588','8','O24030031022','游魚轉心瓶8結蛋捲禮盒【國立故宮博物院聯名】','DG010394-12','DG010394','咖啡蛋捲,巧克力蛋捲','禮盒-故宮(文物款)【咖啡+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2024-03-21','2024-03-10 06:59:46','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229588',`firm_id` = '8',`ordernumber` = 'O24030031022', `product_name` = '游魚轉心瓶8結蛋捲禮盒【國立故宮博物院聯名】',`product_code` = 'DG010394-12',`product_sn` = 'DG010394',`product_spec` = '咖啡蛋捲,巧克力蛋捲',`invoice_name` = '禮盒-故宮(文物款)【咖啡+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-03-21',`create_date` = '2024-03-10 06:59:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031022' and product_code = 'DG010394-12' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031022' and product_code = 'DG010222-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229588','8','O24030031022','【小王子聯名】夢想旅程8結提盒','DG010222-01','DG010222','40入原味蛋捲','提盒-小王子(紅)-40入原味','300','300','0','0','0','0','1','0.0','1','300','2024-03-21','2024-03-10 06:59:46','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229588',`firm_id` = '8',`ordernumber` = 'O24030031022', `product_name` = '【小王子聯名】夢想旅程8結提盒',`product_code` = 'DG010222-01',`product_sn` = 'DG010222',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-小王子(紅)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-03-21',`create_date` = '2024-03-10 06:59:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031022' and product_code = 'DG010222-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031022' and product_code = 'DG010226-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229588','8','O24030031022','蓮花式溫碗8結蛋捲提盒【國立故宮博物院】','DG010226-01','DG010226','40入原味蛋捲','提盒-故宮(文物款)-40入原味','300','300','0','0','0','0','1','0.0','4','1200','2024-03-21','2024-03-10 06:59:46','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229588',`firm_id` = '8',`ordernumber` = 'O24030031022', `product_name` = '蓮花式溫碗8結蛋捲提盒【國立故宮博物院】',`product_code` = 'DG010226-01',`product_sn` = 'DG010226',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-故宮(文物款)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1200',`etd` = '2024-03-21',`create_date` = '2024-03-10 06:59:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031022' and product_code = 'DG010226-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031195' and product_code = 'DG010206-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229589','8','O24030031195','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','7','2065','2024-03-15','2024-03-10 10:25:28','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229589',`firm_id` = '8',`ordernumber` = 'O24030031195', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '7',`total_price` = '2065',`etd` = '2024-03-15',`create_date` = '2024-03-10 10:25:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031195' and product_code = 'DG010206-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031255' and product_code = 'DG010206-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229590','8','O24030031255','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','2','590','2024-03-12','2024-03-10 13:33:20','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229590',`firm_id` = '8',`ordernumber` = 'O24030031255', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '590',`etd` = '2024-03-12',`create_date` = '2024-03-10 13:33:20',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031255' and product_code = 'DG010206-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031372' and product_code = 'DG010206-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229591','8','O24030031372','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','4','1180','2024-03-12','2024-03-10 15:48:43','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229591',`firm_id` = '8',`ordernumber` = 'O24030031372', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1180',`etd` = '2024-03-12',`create_date` = '2024-03-10 15:48:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031372' and product_code = 'DG010206-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031372' and product_code = '04191' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229591','8','O24030031372','[加購]加購－一口鳳梨酥','04191','04191','-','加購-(盒)鳳梨酥','120','120','1','1','120','0','0','0.0','1','120','2024-03-12','2024-03-10 15:48:43','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229591',`firm_id` = '8',`ordernumber` = 'O24030031372', `product_name` = '[加購]加購－一口鳳梨酥',`product_code` = '04191',`product_sn` = '04191',`product_spec` = '-',`invoice_name` = '加購-(盒)鳳梨酥',`listprice` = '120',`sellingprice` = '120',`isadd` = '1',`isbaby` = '1',`addprice` = '120',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '120',`etd` = '2024-03-12',`create_date` = '2024-03-10 15:48:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031372' and product_code = '04191' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031491' and product_code = 'DG010566-04' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229592','8','O24030031491','經典蛋捲三入組','DG010566-04','DG010566','原味+原味+海苔','組合-32入(原味+原味+海苔)','699','699','0','0','0','1','1','0.0','1','699','2024-03-29','2024-03-10 15:53:52','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229592',`firm_id` = '8',`ordernumber` = 'O24030031491', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-04',`product_sn` = 'DG010566',`product_spec` = '原味+原味+海苔',`invoice_name` = '組合-32入(原味+原味+海苔)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-03-29',`create_date` = '2024-03-10 15:53:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031491' and product_code = 'DG010566-04' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031559' and product_code = 'DG010312-13' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229593','8','O24030031559','【海苔＋海苔】金8結禮盒','DG010312-13','DG010312','金8結盒','禮盒-金8結【海苔+海苔】','590','480','0','0','0','0','1','480.0','4','1920','2024-03-21','2024-03-10 16:03:55','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229593',`firm_id` = '8',`ordernumber` = 'O24030031559', `product_name` = '【海苔＋海苔】金8結禮盒',`product_code` = 'DG010312-13',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【海苔+海苔】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '4',`total_price` = '1920',`etd` = '2024-03-21',`create_date` = '2024-03-10 16:03:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031559' and product_code = 'DG010312-13' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031559' and product_code = 'DG010312-15' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229593','8','O24030031559','【巧克力＋巧克力】金8結禮盒','DG010312-15','DG010312','金8結盒','禮盒-金8結【巧克力+巧克力】','590','480','0','0','0','0','1','480.0','4','1920','2024-03-21','2024-03-10 16:03:55','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229593',`firm_id` = '8',`ordernumber` = 'O24030031559', `product_name` = '【巧克力＋巧克力】金8結禮盒',`product_code` = 'DG010312-15',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【巧克力+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '4',`total_price` = '1920',`etd` = '2024-03-21',`create_date` = '2024-03-10 16:03:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031559' and product_code = 'DG010312-15' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031559' and product_code = 'DG010312-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229593','8','O24030031559','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','4','1920','2024-03-21','2024-03-10 16:03:55','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229593',`firm_id` = '8',`ordernumber` = 'O24030031559', `product_name` = '【原味＋原味】金8結禮盒',`product_code` = 'DG010312-01',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+原味】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '4',`total_price` = '1920',`etd` = '2024-03-21',`create_date` = '2024-03-10 16:03:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031559' and product_code = 'DG010312-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031683' and product_code = 'DG010567-176' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229594','8','O24030031683','熱銷蛋捲六入組','DG010567-176','DG010567','原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶','組合-32入(原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','2','2700','2024-03-12','2024-03-10 17:23:34','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229594',`firm_id` = '8',`ordernumber` = 'O24030031683', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-176',`product_sn` = 'DG010567',`product_spec` = '原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '2700',`etd` = '2024-03-12',`create_date` = '2024-03-10 17:23:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031683' and product_code = 'DG010567-176' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031683' and product_code = 'DG010405-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229594','8','O24030031683','單入紅提盒','DG010405-01','DG010405','單入紅提盒包材','單入紅提盒','15','15','0','0','0','0','1','0.0','13','195','2024-03-12','2024-03-10 17:23:34','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229594',`firm_id` = '8',`ordernumber` = 'O24030031683', `product_name` = '單入紅提盒',`product_code` = 'DG010405-01',`product_sn` = 'DG010405',`product_spec` = '單入紅提盒包材',`invoice_name` = '單入紅提盒',`listprice` = '15',`sellingprice` = '15',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '13',`total_price` = '195',`etd` = '2024-03-12',`create_date` = '2024-03-10 17:23:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031683' and product_code = 'DG010405-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031683' and product_code = 'DG010107-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229594','8','O24030031683','阿薩姆紅茶蛋捲','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','0','1','0.0','1','240','2024-03-12','2024-03-10 17:23:34','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229594',`firm_id` = '8',`ordernumber` = 'O24030031683', `product_name` = '阿薩姆紅茶蛋捲',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2024-03-12',`create_date` = '2024-03-10 17:23:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031683' and product_code = 'DG010107-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031787' and product_code = 'DG010206-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229595','8','O24030031787','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','1','295','2024-03-12','2024-03-10 18:10:03','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229595',`firm_id` = '8',`ordernumber` = 'O24030031787', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-03-12',`create_date` = '2024-03-10 18:10:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031787' and product_code = 'DG010206-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031787' and product_code = 'DG010206-05' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229595','8','O24030031787','8結蛋捲【紅提盒裝】','DG010206-05','DG010206','巧克力','提盒-品牌(紅)-40入巧克力蛋捲','295','295','0','0','0','0','1','0.0','2','590','2024-03-12','2024-03-10 18:10:03','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229595',`firm_id` = '8',`ordernumber` = 'O24030031787', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-05',`product_sn` = 'DG010206',`product_spec` = '巧克力',`invoice_name` = '提盒-品牌(紅)-40入巧克力蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '590',`etd` = '2024-03-12',`create_date` = '2024-03-10 18:10:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031787' and product_code = 'DG010206-05' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031871' and product_code = 'DG010312-02' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229596','8','O24030031871','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2024-03-12','2024-03-10 18:10:40','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229596',`firm_id` = '8',`ordernumber` = 'O24030031871', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-03-12',`create_date` = '2024-03-10 18:10:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031871' and product_code = 'DG010312-02' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030031945' and product_code = 'BP010156-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229597','8','O24030031945','SNOOPY心意提袋','BP010156-01','BP010156','SNOOPY心意提袋','SNOOPY心意提袋','490','490','0','0','0','0','1','0.0','1','490','2024-03-14','2024-03-10 18:12:22','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229597',`firm_id` = '8',`ordernumber` = 'O24030031945', `product_name` = 'SNOOPY心意提袋',`product_code` = 'BP010156-01',`product_sn` = 'BP010156',`product_spec` = 'SNOOPY心意提袋',`invoice_name` = 'SNOOPY心意提袋',`listprice` = '490',`sellingprice` = '490',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '490',`etd` = '2024-03-14',`create_date` = '2024-03-10 18:12:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030031945' and product_code = 'BP010156-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032074' and product_code = 'DG010312-02' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229598','8','O24030032074','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','2','960','2024-03-12','2024-03-10 18:43:28','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229598',`firm_id` = '8',`ordernumber` = 'O24030032074', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2024-03-12',`create_date` = '2024-03-10 18:43:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032074' and product_code = 'DG010312-02' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032074' and product_code = 'DG0103155-06' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229598','8','O24030032074','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-06','DG0103155','芝麻蛋捲,芝麻蛋捲','禮盒-SNOOPY【芝麻+芝麻】','500','500','0','0','0','0','1','0.0','1','500','2024-03-12','2024-03-10 18:43:28','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229598',`firm_id` = '8',`ordernumber` = 'O24030032074', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-06',`product_sn` = 'DG0103155',`product_spec` = '芝麻蛋捲,芝麻蛋捲',`invoice_name` = '禮盒-SNOOPY【芝麻+芝麻】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-03-12',`create_date` = '2024-03-10 18:43:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032074' and product_code = 'DG0103155-06' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032180' and product_code = 'DG010101-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229599','8','O24030032180','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-03-12','2024-03-10 19:34:37','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229599',`firm_id` = '8',`ordernumber` = 'O24030032180', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-03-12',`create_date` = '2024-03-10 19:34:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032180' and product_code = 'DG010101-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032180' and product_code = 'DG010101-03' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229599','8','O24030032180','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-03-12','2024-03-10 19:34:37','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229599',`firm_id` = '8',`ordernumber` = 'O24030032180', `product_name` = '極上咖啡蛋捲',`product_code` = 'DG010101-03',`product_sn` = 'DG010101',`product_spec` = '咖啡',`invoice_name` = '40入咖啡蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-03-12',`create_date` = '2024-03-10 19:34:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032180' and product_code = 'DG010101-03' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032180' and product_code = 'DG010101-05' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229599','8','O24030032180','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-03-12','2024-03-10 19:34:37','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229599',`firm_id` = '8',`ordernumber` = 'O24030032180', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-03-12',`create_date` = '2024-03-10 19:34:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032180' and product_code = 'DG010101-05' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032232' and product_code = 'DG010203-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229600','8','O24030032232','【小王子聯名】閃耀星空8結提盒','DG010203-01','DG010203','40入原味蛋捲','提盒-小王子(藍)-40入原味','300','300','0','0','0','0','1','0.0','2','600','2024-03-14','2024-03-10 19:43:35','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229600',`firm_id` = '8',`ordernumber` = 'O24030032232', `product_name` = '【小王子聯名】閃耀星空8結提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-小王子(藍)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2024-03-14',`create_date` = '2024-03-10 19:43:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032232' and product_code = 'DG010203-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032232' and product_code = 'DG010327-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229600','8','O24030032232','【小王子聯名】仰望星空8結禮盒 ','DG010327-01','DG010327','原味,原味','禮盒-小王子(藍)【原味+原味】','500','500','0','0','0','0','1','0.0','2','1000','2024-03-14','2024-03-10 19:43:35','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229600',`firm_id` = '8',`ordernumber` = 'O24030032232', `product_name` = '【小王子聯名】仰望星空8結禮盒 ',`product_code` = 'DG010327-01',`product_sn` = 'DG010327',`product_spec` = '原味,原味',`invoice_name` = '禮盒-小王子(藍)【原味+原味】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1000',`etd` = '2024-03-14',`create_date` = '2024-03-10 19:43:35',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032232' and product_code = 'DG010327-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032353' and product_code = 'DG010566-10' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229601','8','O24030032353','經典蛋捲三入組','DG010566-10','DG010566','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)','699','699','0','0','0','1','1','0.0','1','699','2024-03-12','2024-03-10 20:56:09','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229601',`firm_id` = '8',`ordernumber` = 'O24030032353', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-10',`product_sn` = 'DG010566',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-03-12',`create_date` = '2024-03-10 20:56:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032353' and product_code = 'DG010566-10' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032353' and product_code = 'DG010312-05' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229601','8','O24030032353','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-03-12','2024-03-10 20:56:09','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229601',`firm_id` = '8',`ordernumber` = 'O24030032353', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-03-12',`create_date` = '2024-03-10 20:56:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032353' and product_code = 'DG010312-05' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032353' and product_code = 'DG010401-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229601','8','O24030032353','品牌提盒','DG010401-01','DG010401','品牌提盒包材','品牌提盒','15','15','0','0','0','0','1','0.0','3','45','2024-03-12','2024-03-10 20:56:09','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229601',`firm_id` = '8',`ordernumber` = 'O24030032353', `product_name` = '品牌提盒',`product_code` = 'DG010401-01',`product_sn` = 'DG010401',`product_spec` = '品牌提盒包材',`invoice_name` = '品牌提盒',`listprice` = '15',`sellingprice` = '15',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '45',`etd` = '2024-03-12',`create_date` = '2024-03-10 20:56:09',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032353' and product_code = 'DG010401-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032456' and product_code = 'DG010107-01' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229602','8','O24030032456','阿薩姆紅茶蛋捲','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','0','1','0.0','1','240','2024-03-15','2024-03-10 21:14:24','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229602',`firm_id` = '8',`ordernumber` = 'O24030032456', `product_name` = '阿薩姆紅茶蛋捲',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2024-03-15',`create_date` = '2024-03-10 21:14:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032456' and product_code = 'DG010107-01' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032456' and product_code = 'DG010101-05' 2024-03-10 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229602','8','O24030032456','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-03-15','2024-03-10 21:14:24','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229602',`firm_id` = '8',`ordernumber` = 'O24030032456', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-03-15',`create_date` = '2024-03-10 21:14:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032456' and product_code = 'DG010101-05' 2024-03-10 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032565' and product_code = 'DG010567-176' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229603','8','O24030032565','熱銷蛋捲六入組','DG010567-176','DG010567','原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶','組合-32入(原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','1','1350','2024-03-12','2024-03-10 21:28:07','2024-03-10 23:59:05',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229603',`firm_id` = '8',`ordernumber` = 'O24030032565', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-176',`product_sn` = 'DG010567',`product_spec` = '原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-03-12',`create_date` = '2024-03-10 21:28:07',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032565' and product_code = 'DG010567-176' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032616' and product_code = 'DG010566-11' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229604','8','O24030032616','經典蛋捲三入組','DG010566-11','DG010566','原味+芝麻+阿薩姆紅茶','組合-32入(原味+芝麻+阿薩姆紅茶)','699','699','0','0','0','1','1','0.0','1','699','2024-03-12','2024-03-10 21:36:18','2024-03-10 23:59:06',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229604',`firm_id` = '8',`ordernumber` = 'O24030032616', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-11',`product_sn` = 'DG010566',`product_spec` = '原味+芝麻+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+芝麻+阿薩姆紅茶)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-03-12',`create_date` = '2024-03-10 21:36:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032616' and product_code = 'DG010566-11' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032732' and product_code = 'DG010258-02' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229605','8','O24030032732','金豐收8結提盒','DG010258-02','DG010258','40入芝麻蛋捲','提盒-金豐收(藍)-40入芝麻','295','295','0','0','0','0','1','0.0','1','295','2024-03-12','2024-03-10 21:42:46','2024-03-10 23:59:06',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229605',`firm_id` = '8',`ordernumber` = 'O24030032732', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-02',`product_sn` = 'DG010258',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入芝麻',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-03-12',`create_date` = '2024-03-10 21:42:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032732' and product_code = 'DG010258-02' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032732' and product_code = 'DG010258-03' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229605','8','O24030032732','金豐收8結提盒','DG010258-03','DG010258','40入咖啡蛋捲','提盒-金豐收(藍)-40入咖啡','295','295','0','0','0','0','1','0.0','1','295','2024-03-12','2024-03-10 21:42:46','2024-03-10 23:59:06',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229605',`firm_id` = '8',`ordernumber` = 'O24030032732', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-03',`product_sn` = 'DG010258',`product_spec` = '40入咖啡蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入咖啡',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-03-12',`create_date` = '2024-03-10 21:42:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032732' and product_code = 'DG010258-03' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032732' and product_code = 'DG010258-05' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229605','8','O24030032732','金豐收8結提盒','DG010258-05','DG010258','40入巧克力蛋捲','提盒-金豐收(藍)-40入巧克力','295','295','0','0','0','0','1','0.0','1','295','2024-03-12','2024-03-10 21:42:46','2024-03-10 23:59:06',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229605',`firm_id` = '8',`ordernumber` = 'O24030032732', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-05',`product_sn` = 'DG010258',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入巧克力',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-03-12',`create_date` = '2024-03-10 21:42:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032732' and product_code = 'DG010258-05' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032836' and product_code = 'DG010206-01' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229606','8','O24030032836','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','10','2950','2024-03-12','2024-03-10 23:30:41','2024-03-10 23:59:06',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229606',`firm_id` = '8',`ordernumber` = 'O24030032836', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '10',`total_price` = '2950',`etd` = '2024-03-12',`create_date` = '2024-03-10 23:30:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032836' and product_code = 'DG010206-01' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032836' and product_code = 'DG010206-02' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229606','8','O24030032836','8結蛋捲【紅提盒裝】','DG010206-02','DG010206','芝麻','提盒-品牌(紅)-40入芝麻蛋捲','295','295','0','0','0','0','1','0.0','5','1475','2024-03-12','2024-03-10 23:30:41','2024-03-10 23:59:06',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229606',`firm_id` = '8',`ordernumber` = 'O24030032836', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-02',`product_sn` = 'DG010206',`product_spec` = '芝麻',`invoice_name` = '提盒-品牌(紅)-40入芝麻蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '1475',`etd` = '2024-03-12',`create_date` = '2024-03-10 23:30:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032836' and product_code = 'DG010206-02' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032836' and product_code = 'DG010206-03' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229606','8','O24030032836','8結蛋捲【紅提盒裝】','DG010206-03','DG010206','咖啡','提盒-品牌(紅)-40入咖啡蛋捲','295','295','0','0','0','0','1','0.0','5','1475','2024-03-12','2024-03-10 23:30:41','2024-03-10 23:59:06',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229606',`firm_id` = '8',`ordernumber` = 'O24030032836', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-03',`product_sn` = 'DG010206',`product_spec` = '咖啡',`invoice_name` = '提盒-品牌(紅)-40入咖啡蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '1475',`etd` = '2024-03-12',`create_date` = '2024-03-10 23:30:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032836' and product_code = 'DG010206-03' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032974' and product_code = 'DG010327-07' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229607','8','O24030032974','【小王子聯名】仰望星空8結禮盒 ','DG010327-07','DG010327','芝麻,咖啡','禮盒-小王子(藍)【芝麻+咖啡】','500','500','0','0','0','0','1','0.0','1','500','2024-03-14','2024-03-10 23:53:20','2024-03-10 23:59:06',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229607',`firm_id` = '8',`ordernumber` = 'O24030032974', `product_name` = '【小王子聯名】仰望星空8結禮盒 ',`product_code` = 'DG010327-07',`product_sn` = 'DG010327',`product_spec` = '芝麻,咖啡',`invoice_name` = '禮盒-小王子(藍)【芝麻+咖啡】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-03-14',`create_date` = '2024-03-10 23:53:20',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032974' and product_code = 'DG010327-07' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030032974' and product_code = 'DG010566-10' 2024-03-10 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'229607','8','O24030032974','經典蛋捲三入組','DG010566-10','DG010566','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)','699','699','0','0','0','1','1','0.0','1','699','2024-03-14','2024-03-10 23:53:20','2024-03-10 23:59:06',null,'1','2024-02-01') 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '229607',`firm_id` = '8',`ordernumber` = 'O24030032974', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-10',`product_sn` = 'DG010566',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-03-14',`create_date` = '2024-03-10 23:53:20',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-01'where ordernumber = 'O24030032974' and product_code = 'DG010566-10' 2024-03-10 23:59:06 -- == sync_order_detail end == 2024-03-10 23:59:06 -- == sync_order start == 2024-03-10 23:59:06 -- start:2024-03-10,end:2024-03-10 2024-03-10 23:59:06 -- == select june1.order_list == select l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-03-10%' OR l.modify_date like '2024-03-10%'; 2024-03-10 23:59:06 -- == sync omo_order_list == 2024-03-10 23:59:06 -- == update lake.omo_order_list == update omo_order_list set userId = '106542', process_status = '3', pay_status = '1', totalprice_after = '800', lunar_date = '2024-01-24', invoice_status = '1', category_name = 'LINE@訂單,彌月試吃', category_id = '9,2' where ordernumber = 'M24030003291' 2024-03-10 23:59:06 -- == sync_order end == 2024-03-10 23:59:06 -- == sync_order_detail start == 2024-03-10 23:59:06 -- start:2024-03-10,end:2024-03-10 2024-03-10 23:59:06 -- == sync omo_order_detail == 2024-03-10 23:59:06 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-03-10%' OR modify_date like '2024-03-10%' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24030003291' and product_code = 'DG010248-01' 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30440',`firm_id` = '11',`ordernumber` = 'M24030003291', `product_name` = '彌月試吃提盒-香頌日光',`product_code` = 'DG010248-01',`product_sn` = 'DG010248',`product_spec` = '原味',`invoice_name` = '提盒-彌月香頌日光-40入原味(試吃)',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-03-08',`create_date` = '2024-03-04 09:51:11',`modify_date` = '2024-03-10 14:20:46',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24030003291' and product_code = 'DG010248-01', `lunar_date` = '2024-01-24' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24030003291' and product_code = 'DG010244-01' 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30440',`firm_id` = '11',`ordernumber` = 'M24030003291', `product_name` = '小王子彌月試吃提盒',`product_code` = 'DG010244-01',`product_sn` = 'DG010244',`product_spec` = '原味',`invoice_name` = '提盒-小王子(藍)-40入原味(試吃)',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-03-08',`create_date` = '2024-03-04 09:51:11',`modify_date` = '2024-03-10 14:20:46',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24030003291' and product_code = 'DG010244-01', `lunar_date` = '2024-01-24' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24030003291' and product_code = 'DG010253-02' 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30440',`firm_id` = '11',`ordernumber` = 'M24030003291', `product_name` = '【小王子聯名】夢想旅程8結彌月提盒(試吃)',`product_code` = 'DG010253-02',`product_sn` = 'DG010253',`product_spec` = '芝麻',`invoice_name` = '提盒-彌月小王子(紅)-40入芝麻(試吃)',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-03-08',`create_date` = '2024-03-04 09:51:11',`modify_date` = '2024-03-10 14:20:46',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24030003291' and product_code = 'DG010253-02', `lunar_date` = '2024-01-24' 2024-03-10 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24030003291' and product_code = 'DG010264-02' 2024-03-10 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30440',`firm_id` = '11',`ordernumber` = 'M24030003291', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒(試吃)',`product_code` = 'DG010264-02',`product_sn` = 'DG010264',`product_spec` = '芝麻',`invoice_name` = '提盒-彌月SNOOPY-40入芝麻(試吃)',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-03-08',`create_date` = '2024-03-04 09:51:11',`modify_date` = '2024-03-10 14:20:46',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24030003291' and product_code = 'DG010264-02', `lunar_date` = '2024-01-24' 2024-03-10 23:59:06 -- == sync_order_detail end == 2024-03-10 23:59:06 -- == select one.order_list == SELECT o.code,o.pay_status,o.order_status,o.user_id,o.pay_method_id,o.activity_freight_id,o.freight_fee,o.items_total,o.total,DATE(o.shipped_at) as shipped_at,o.created_at as create_date, inv.company_number,inv.company_title,inv.invoice_status, cust.zipcode,cust.county,cust.district, rec.zipcode as recipientzip,rec.county as recipientaddresscity,rec.district as recipientaddressarea, af.type as freight_type FROM `orders` o LEFT JOIN systemlead_invoices inv on o.id = inv.order_id LEFT JOIN order_customers cust on o.id = cust.order_id LEFT JOIN order_receivers rec on o.id = rec.order_id LEFT JOIN activity_freights af on o.activity_freight_id = af.id WHERE (DATE(o.created_at) = '2024-03-10' OR o.updated_at = '2024-03-10') and o.deleted_at is null 2024-03-10 23:59:06 -- == sync_order_detail start == 2024-03-10 23:59:06 -- start:2024-03-10,end:2024-03-10 2024-03-10 23:59:07 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2024-03-10 23:59:07 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2024-03-10 23:59:09 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2024-03-10%';