2024-04-19 13:43:06 -- == sync_order start == 2024-04-19 13:43:06 -- start:2024-04-19,end:2024-04-19 2024-04-19 13:43: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-04-19%' OR l.modify_date like '2024-04-19%'; 2024-04-19 13:43:07 -- == sync omo_order_list == 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '3', pay_status = '1', totalprice_after = '1470', lunar_date = '2023-12-14', invoice_status = '1',category_name = '', category_id = '' where ordernumber = 'S24010835821' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '383568', process_status = '2', pay_status = '1', totalprice_after = '55798', lunar_date = '2024-02-20', invoice_status = '0',category_name = 'LINE@訂單', category_id = '9' where ordernumber = 'S24030108192' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '354884', process_status = '2', pay_status = '1', totalprice_after = '1140', lunar_date = '2024-02-21', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24030113138' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '383727', process_status = '2', pay_status = '1', totalprice_after = '1518', lunar_date = '2024-02-21', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24030113569' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '319112', process_status = '2', pay_status = '1', totalprice_after = '2219', lunar_date = '2024-02-21', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24030113744' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '361582', process_status = '2', pay_status = '1', totalprice_after = '8430', lunar_date = '2024-02-22', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24030118045' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '384408', process_status = '2', pay_status = '1', totalprice_after = '11817', lunar_date = '2024-02-27', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040011761' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '53372', process_status = '2', pay_status = '1', totalprice_after = '3050', lunar_date = '2024-02-30', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040021416' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '384942', process_status = '2', pay_status = '1', totalprice_after = '17908', lunar_date = '2024-03-01', invoice_status = '1',category_name = '電話訂單', category_id = '12' where ordernumber = 'S24040028121' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '382083', process_status = '2', pay_status = '1', totalprice_after = '1620', lunar_date = '2024-03-02', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040030147' 2024-04-19 13:43:07 -- == update lake.omo_order_list == update omo_order_list set userId = '20851', process_status = '3', pay_status = '1', totalprice_after = '38880', lunar_date = '2024-03-03', invoice_status = '1',category_name = '電話訂單,團媽訂單', category_id = '12,3' where ordernumber = 'S24040034220' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '74963', process_status = '2', pay_status = '1', totalprice_after = '34713', lunar_date = '2024-03-07', invoice_status = '0',category_name = 'LINE@訂單', category_id = '9' where ordernumber = 'O24040042959' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385184', process_status = '6', pay_status = '5', totalprice_after = '420', lunar_date = '2024-03-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040043380' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385694', process_status = '2', pay_status = '1', totalprice_after = '1570', lunar_date = '2024-03-08', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040049230' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '3', pay_status = '1', totalprice_after = '384', lunar_date = '2024-03-11', invoice_status = '1',category_name = '員購訂單', category_id = '42' where ordernumber = 'S24040049371' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385713', process_status = '2', pay_status = '1', totalprice_after = '3150', lunar_date = '2024-03-08', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040049513' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '304797', process_status = '2', pay_status = '1', totalprice_after = '2550', lunar_date = '2024-03-08', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040050851' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385802', process_status = '2', pay_status = '1', totalprice_after = '420', lunar_date = '2024-03-09', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040052079' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '52738', process_status = '2', pay_status = '1', totalprice_after = '710', lunar_date = '2024-03-09', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040052198' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385868', process_status = '3', pay_status = '1', totalprice_after = '3500', lunar_date = '2024-03-09', invoice_status = '0',category_name = ',迪化當日宅配', category_id = ',44' where ordernumber = 'S24040053465' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '144048', process_status = '6', pay_status = '6', totalprice_after = '10545', lunar_date = '2024-03-09', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040054833' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385910', process_status = '2', pay_status = '1', totalprice_after = '1080', lunar_date = '2024-03-09', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040055415' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385918', process_status = '2', pay_status = '1', totalprice_after = '890', lunar_date = '2024-03-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040055554' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385926', process_status = '2', pay_status = '1', totalprice_after = '1240', lunar_date = '2024-03-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040055756' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '273441', process_status = '2', pay_status = '0', totalprice_after = '52416', lunar_date = '2024-03-10', invoice_status = '0',category_name = '通路訂單', category_id = '5' where ordernumber = 'S24040055990' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '384942', process_status = '2', pay_status = '1', totalprice_after = '1378', lunar_date = '2024-03-10', invoice_status = '0',category_name = '電話訂單', category_id = '12' where ordernumber = 'S24040056062' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385930', process_status = '2', pay_status = '1', totalprice_after = '1320', lunar_date = '2024-03-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040056342' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385936', process_status = '2', pay_status = '1', totalprice_after = '2720', lunar_date = '2024-03-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040056483' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '385974', process_status = '2', pay_status = '1', totalprice_after = '3940', lunar_date = '2024-03-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040056929' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '370695', process_status = '2', pay_status = '1', totalprice_after = '2390', lunar_date = '2024-03-10', invoice_status = '0',category_name = 'LINE@訂單', category_id = '9' where ordernumber = 'S24040057138' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '386003', process_status = '2', pay_status = '1', totalprice_after = '1430', lunar_date = '2024-03-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040057232' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '0', totalprice_after = '445', lunar_date = '2024-03-10', invoice_status = '0',category_name = 'line禮物', category_id = '38' where ordernumber = 'S24040057394' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '0', totalprice_after = '445', lunar_date = '2024-03-10', invoice_status = '0',category_name = 'line禮物', category_id = '38' where ordernumber = 'S24040057450' 2024-04-19 13:43:08 -- == update lake.omo_order_list == update omo_order_list set userId = '386018', process_status = '2', pay_status = '1', totalprice_after = '620', lunar_date = '2024-03-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O24040057534' 2024-04-19 13:43:08 -- == 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 ('349262','385969',1,'','','O24040057859','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','990','404','台中市','北區','404','台中市','北區','1140','2024-04-19 06:34:25','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('191482','157699',1,'','','O24040057997','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','2630','825','高雄市','橋頭區','825','高雄市','橋頭區','2780','2024-04-19 08:02:21','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('93936','65363',1,'','','O24040058057','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','990','234','新北市','永和區','234','新北市','永和區','1140','2024-04-19 08:06:02','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('55045','29017',1,'','','O24040058173','1','2','1','1','2','','','0','0000-00-00','0','0','0','','150','0','495','330','桃園市','桃園區','247','新北市','蘆洲區','645','2024-04-19 09:12:22','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('349271','385978',1,'免運專區活動','27','O24040058267','1','1','13','1','1','','','1','2024-05-08','0','0','0','','0','0','2400','110','台北市','信義區','110','台北市','信義區','2400','2024-04-19 09:30:02','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('349360','386067',1,'電話訂單,企業訂單','12,4','S24040058347','1','4','1','0','0','09652023','中華精測科技股份有限公司職工福利委員會 ','0','2024-06-03','0','0','0','','0','0','1059300','324','桃園市','平鎮區','324','桃園市','平鎮區','1059300','2024-04-19 09:33:40','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('165726','0',1,'合作廠商訂貨','17','S24040058452','1','2','1','0','0','22182525','臺南蛋品股份有限公司','0','2024-04-22','0','480','0','','0','0','9600','718','台南市','關廟區','718','台南市','關廟區','9120','2024-04-19 10:22:53','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('349346','386053',1,'','','O24040058546','1','2','1','0','0','86933537','碩泰金屬興業股份有限公司','0','0000-00-00','720','0','0','','0','30','14400','507','彰化縣','線西鄉','507','彰化縣','線西鄉','13650','2024-04-19 10:34:40','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('199226','165213',1,'團媽訂單','3','S24040058654','1','4','1','1','2','','','0','2024-04-22','0','7020','0','','0','0','67320','813','高雄市','左營區','813','高雄市','左營區','60300','2024-04-19 10:42:34','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('349362','386069',1,'','','O24040058758','1','1','1','1','1','84617747','誠聚金屬股份有限公司','0','0000-00-00','0','0','0','','0','30','5700','412','台中市','大里區','412','台中市','大里區','5670','2024-04-19 10:50:45','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('103217','73932',1,'','','O24040058844','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1120','302','新竹縣','竹北市','302','新竹縣','竹北市','1270','2024-04-19 11:38:04','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('349345','0',1,'電話訂單','12','S24040058955','1','1','1','0','0','','','0','2024-04-22','0','0','0','','150','30','2075','600','嘉義市','西區','600','嘉義市','西區','2195','2024-04-19 11:39:03','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('349352','386059',1,'','','O24040059093','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','980','251','新北市','淡水區','251','新北市','淡水區','1100','2024-04-19 12:09:15','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('337376','374220',1,'','','O24040059162','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1980','710','台南市','永康區','710','台南市','永康區','2130','2024-04-19 12:51:24','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('349233','385940',1,'','','O24040059219','1','1','1','0','0','','','0','0000-00-00','0','0','0','','0','30','6510','924','屏東縣','崁頂鄉','924','屏東縣','崁頂鄉','6480','2024-04-19 12:53:47','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('349233','385940',1,'','','O24040059316','1','11','1','1','1','','','0','0000-00-00','0','0','0','','0','0','6510','924','屏東縣','崁頂鄉','924','屏東縣','崁頂鄉','6510','2024-04-19 12:59:29','2024-03-11') 2024-04-19 13:43:08 -- == 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 ('69305','42302',1,'LINE@訂單','9','S24040059481','1','1','1','0','0','90041256','盛和進國際有限公司 ','0','2024-04-22','0','168','0','','150','0','3360','242','新北市','新莊區','242','新北市','新莊區','3342','2024-04-19 13:11:16','2024-03-11') 2024-04-19 13:43:08 -- == sync_order end == 2024-04-19 13:43:08 -- == sync_order_detail start == 2024-04-19 13:43:08 -- start:2024-04-19,end:2024-04-19 2024-04-19 13:43:08 -- == sync omo_order_detail == 2024-04-19 13:43:08 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-04-19%' OR modify_date like '2024-04-19%' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24010835821' and product_code = 'DG010523-11' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '226932',`firm_id` = '8',`ordernumber` = 'S24010835821', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-11',`product_sn` = 'DG010523',`product_spec` = '原味+咖啡+海苔',`invoice_name` = '組合-32入(原味+咖啡+海苔)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-02-02',`create_date` = '2024-01-24 09:20:31',`modify_date` = '2024-04-19 10:49:59',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-12-14'where ordernumber = 'S24010835821' and product_code = 'DG010523-11' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24010835821' and product_code = 'DG010312-02' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '226932',`firm_id` = '8',`ordernumber` = 'S24010835821', `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-02-02',`create_date` = '2024-01-24 09:20:31',`modify_date` = '2024-04-19 10:49:59',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-12-14'where ordernumber = 'S24010835821' and product_code = 'DG010312-02' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113138' and product_code = 'DG010523-07' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230414',`firm_id` = '8',`ordernumber` = 'O24030113138', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-07',`product_sn` = 'DG010523',`product_spec` = '原味+芝麻+咖啡',`invoice_name` = '組合-32入(原味+芝麻+咖啡)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-04-22',`create_date` = '2024-03-30 14:58:52',`modify_date` = '2024-04-19 11:30:39',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113138' and product_code = 'DG010523-07' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040034220' and product_code = 'DG010101-01' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230808',`firm_id` = '8',`ordernumber` = 'S24040034220', `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` = '54',`total_price` = '15120',`etd` = '2024-04-15',`create_date` = '2024-04-11 14:10:07',`modify_date` = '2024-04-19 10:39:49',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-03'where ordernumber = 'S24040034220' and product_code = 'DG010101-01' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040034220' and product_code = 'DG010101-02' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230808',`firm_id` = '8',`ordernumber` = 'S24040034220', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`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` = '36',`total_price` = '10080',`etd` = '2024-04-15',`create_date` = '2024-04-11 14:10:07',`modify_date` = '2024-04-19 10:39:49',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-03'where ordernumber = 'S24040034220' and product_code = 'DG010101-02' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040034220' and product_code = 'DG010101-03' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230808',`firm_id` = '8',`ordernumber` = 'S24040034220', `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` = '18',`total_price` = '5040',`etd` = '2024-04-15',`create_date` = '2024-04-11 14:10:07',`modify_date` = '2024-04-19 10:39:49',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-03'where ordernumber = 'S24040034220' and product_code = 'DG010101-03' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040034220' and product_code = 'DG010101-04' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230808',`firm_id` = '8',`ordernumber` = 'S24040034220', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`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` = '18',`total_price` = '5040',`etd` = '2024-04-15',`create_date` = '2024-04-11 14:10:07',`modify_date` = '2024-04-19 10:39:49',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-03'where ordernumber = 'S24040034220' and product_code = 'DG010101-04' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040034220' and product_code = 'DG010101-05' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230808',`firm_id` = '8',`ordernumber` = 'S24040034220', `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` = '36',`total_price` = '10080',`etd` = '2024-04-15',`create_date` = '2024-04-11 14:10:07',`modify_date` = '2024-04-19 10:39:49',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-03'where ordernumber = 'S24040034220' and product_code = 'DG010101-05' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040043380' and product_code = 'DG010225-01' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230899',`firm_id` = '8',`ordernumber` = 'O24040043380', `product_name` = '唐人宮樂8結蛋捲提盒【國立故宮博物院聯名】',`product_code` = 'DG010225-01',`product_sn` = 'DG010225',`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-04-18',`create_date` = '2024-04-15 12:22:14',`modify_date` = '2024-04-19 09:54:46',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-07'where ordernumber = 'O24040043380' and product_code = 'DG010225-01' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040049371' and product_code = 'DG010107-01' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230959',`firm_id` = '8',`ordernumber` = 'S24040049371', `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` = '2',`total_price` = '480',`etd` = '2024-04-15',`create_date` = '2024-04-16 13:40:54',`modify_date` = '2024-04-19 11:48:26',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-08'where ordernumber = 'S24040049371' and product_code = 'DG010107-01' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040053465' and product_code = 'DG010312-02' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231000',`firm_id` = '8',`ordernumber` = 'S24040053465', `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-04-19',`create_date` = '2024-04-17 16:46:25',`modify_date` = '2024-04-19 12:38:18',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-09'where ordernumber = 'S24040053465' and product_code = 'DG010312-02' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040053465' and product_code = 'DG010312-05' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231000',`firm_id` = '8',`ordernumber` = 'S24040053465', `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-04-19',`create_date` = '2024-04-17 16:46:25',`modify_date` = '2024-04-19 12:38:18',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-09'where ordernumber = 'S24040053465' and product_code = 'DG010312-05' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040053465' and product_code = 'DG010527-01' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231000',`firm_id` = '8',`ordernumber` = 'S24040053465', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-01',`product_sn` = 'DG010527',`product_spec` = '40入原味蛋捲',`invoice_name` = '組合-40入原味+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '1740',`etd` = '2024-04-19',`create_date` = '2024-04-17 16:46:25',`modify_date` = '2024-04-19 12:38:18',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-09'where ordernumber = 'S24040053465' and product_code = 'DG010527-01' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040053465' and product_code = 'DG010527-05' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231000',`firm_id` = '8',`ordernumber` = 'S24040053465', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-05',`product_sn` = 'DG010527',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '組合-40入巧克力+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '580',`etd` = '2024-04-19',`create_date` = '2024-04-17 16:46:25',`modify_date` = '2024-04-19 12:38:18',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-09'where ordernumber = 'S24040053465' and product_code = 'DG010527-05' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040053465' and product_code = 'ZP010146-01' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231000',`firm_id` = '8',`ordernumber` = 'S24040053465', `product_name` = '贈品-南棗核桃糕分享包',`product_code` = 'ZP010146-01',`product_sn` = 'ZP010146',`product_spec` = '贈品-南棗核桃糕分享包',`invoice_name` = '贈品-南棗核桃糕分享包',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-04-19',`create_date` = '2024-04-17 16:46:25',`modify_date` = '2024-04-19 12:38:18',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-09'where ordernumber = 'S24040053465' and product_code = 'ZP010146-01' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040054833' and product_code = 'DG010315-04' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231012',`firm_id` = '8',`ordernumber` = 'O24040054833', `product_name` = '金8結肉酥酥禮盒',`product_code` = 'DG010315-04',`product_sn` = 'DG010315',`product_spec` = '原味肉酥酥【芝麻蛋捲】',`invoice_name` = '禮盒-金8結【芝麻+原味肉酥酥】',`listprice` = '555',`sellingprice` = '555',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '555.0',`amount` = '20',`total_price` = '11100',`etd` = '2024-05-31',`create_date` = '2024-04-17 21:09:54',`modify_date` = '2024-04-19 09:25:57',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-09'where ordernumber = 'O24040054833' and product_code = 'DG010315-04' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040054833' and product_code = 'ZP0101107-01' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231012',`firm_id` = '8',`ordernumber` = 'O24040054833', `product_name` = '贈品-SNOOPY提把水瓶',`product_code` = 'ZP0101107-01',`product_sn` = 'ZP0101107',`product_spec` = '贈品-SNOOPY提把水瓶',`invoice_name` = '贈品-SNOOPY提把水瓶',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-05-31',`create_date` = '2024-04-17 21:09:54',`modify_date` = '2024-04-19 09:25:57',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-09'where ordernumber = 'O24040054833' and product_code = 'ZP0101107-01' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040057394' and product_code = 'DG010206-04' 2024-04-19 13:43:10 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231037',`firm_id` = '8',`ordernumber` = 'S24040057394', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-04',`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-04-19',`create_date` = '2024-04-18 16:32:22',`modify_date` = '2024-04-19 09:00:01',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-10'where ordernumber = 'S24040057394' and product_code = 'DG010206-04' 2024-04-19 13:43:10 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040057859' and product_code = 'DG010523-02' 2024-04-19 13:43:11 -- == 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,'231042','8','O24040057859','SNOOPY帶走心意-蛋捲三入組','DG010523-02','DG010523','原味+原味+芝麻','組合-32入(原味+原味+芝麻)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-04-24','2024-04-19 06:34:25','2024-04-19 13:43:10',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231042',`firm_id` = '8',`ordernumber` = 'O24040057859', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-02',`product_sn` = 'DG010523',`product_spec` = '原味+原味+芝麻',`invoice_name` = '組合-32入(原味+原味+芝麻)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-04-24',`create_date` = '2024-04-19 06:34:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040057859' and product_code = 'DG010523-02' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040057997' and product_code = 'DG010101-02' 2024-04-19 13:43:11 -- == 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,'231043','8','O24040057997','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-04-24','2024-04-19 08:02:21','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231043',`firm_id` = '8',`ordernumber` = 'O24040057997', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`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` = '3',`total_price` = '840',`etd` = '2024-04-24',`create_date` = '2024-04-19 08:02:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040057997' and product_code = 'DG010101-02' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040057997' and product_code = 'DG010101-01' 2024-04-19 13:43:11 -- == 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,'231043','8','O24040057997','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','4','1120','2024-04-24','2024-04-19 08:02:21','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231043',`firm_id` = '8',`ordernumber` = 'O24040057997', `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` = '4',`total_price` = '1120',`etd` = '2024-04-24',`create_date` = '2024-04-19 08:02:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040057997' and product_code = 'DG010101-01' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040057997' and product_code = 'DG010101-03' 2024-04-19 13:43:11 -- == 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,'231043','8','O24040057997','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-04-24','2024-04-19 08:02:21','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231043',`firm_id` = '8',`ordernumber` = 'O24040057997', `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-04-24',`create_date` = '2024-04-19 08:02:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040057997' and product_code = 'DG010101-03' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040057997' and product_code = 'BP010157-01' 2024-04-19 13:43:11 -- == 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,'231043','8','O24040057997','[加購]加購-SNOOPY心意提袋','BP010157-01','BP010157','-','加購-SNOOPY心意提袋','390','390','1','1','390','0','0','0.0','1','390','2024-04-24','2024-04-19 08:02:21','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231043',`firm_id` = '8',`ordernumber` = 'O24040057997', `product_name` = '[加購]加購-SNOOPY心意提袋',`product_code` = 'BP010157-01',`product_sn` = 'BP010157',`product_spec` = '-',`invoice_name` = '加購-SNOOPY心意提袋',`listprice` = '390',`sellingprice` = '390',`isadd` = '1',`isbaby` = '1',`addprice` = '390',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '390',`etd` = '2024-04-24',`create_date` = '2024-04-19 08:02:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040057997' and product_code = 'BP010157-01' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058057' and product_code = 'DG010523-21' 2024-04-19 13:43:11 -- == 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,'231044','8','O24040058057','SNOOPY帶走心意-蛋捲三入組','DG010523-21','DG010523','芝麻+咖啡+海苔','組合-32入(芝麻+咖啡+海苔)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-05-01','2024-04-19 08:06:02','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231044',`firm_id` = '8',`ordernumber` = 'O24040058057', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-21',`product_sn` = 'DG010523',`product_spec` = '芝麻+咖啡+海苔',`invoice_name` = '組合-32入(芝麻+咖啡+海苔)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-05-01',`create_date` = '2024-04-19 08:06:02',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058057' and product_code = 'DG010523-21' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058173' and product_code = 'DG010347-01' 2024-04-19 13:43:11 -- == 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,'231045','8','O24040058173','六月初一&成真咖啡禮盒','DG010347-01','DG010347','原味蛋捲+6入咖啡','禮盒-ESG藍金【原味+成真咖啡】','495','495','0','0','0','0','1','0.0','1','495','2024-04-22','2024-04-19 09:12:22','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231045',`firm_id` = '8',`ordernumber` = 'O24040058173', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-01',`product_sn` = 'DG010347',`product_spec` = '原味蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【原味+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '495',`etd` = '2024-04-22',`create_date` = '2024-04-19 09:12:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058173' and product_code = 'DG010347-01' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058267' and product_code = 'GJ010107-01' 2024-04-19 13:43:11 -- == 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,'231046','12','O24040058267','梅酒體驗課程(5/8台北場)','GJ010107-01','GJ010107','梅酒體驗課程(5/8台北場)','梅酒體驗課程','1200','1200','0','1','0','0','1','0.0','2','2400','2024-05-08','2024-04-19 09:30:02','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231046',`firm_id` = '12',`ordernumber` = 'O24040058267', `product_name` = '梅酒體驗課程(5/8台北場)',`product_code` = 'GJ010107-01',`product_sn` = 'GJ010107',`product_spec` = '梅酒體驗課程(5/8台北場)',`invoice_name` = '梅酒體驗課程',`listprice` = '1200',`sellingprice` = '1200',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '2400',`etd` = '2024-05-08',`create_date` = '2024-04-19 09:30:02',`modify_date` = '2024-04-19 09:43:34',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058267' and product_code = 'GJ010107-01' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058347' and product_code = 'DG010523-09' 2024-04-19 13:43:11 -- == 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,'231047','8','S24040058347','SNOOPY帶走心意-蛋捲三入組','DG010523-09','DG010523','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1070','1059300','2024-06-03','2024-04-19 09:33:40','2024-04-19 13:43:11',0,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231047',`firm_id` = '8',`ordernumber` = 'S24040058347', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-09',`product_sn` = 'DG010523',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1070',`total_price` = '1059300',`etd` = '2024-06-03',`create_date` = '2024-04-19 09:33:40',`modify_date` = '2024-04-19 13:28:46',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058347' and product_code = 'DG010523-09' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058452' and product_code = 'DG010312-02' 2024-04-19 13:43:11 -- == 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,'231048','8','S24040058452','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','20','9600','2024-04-22','2024-04-19 10:22:53','2024-04-19 13:43:11',0,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231048',`firm_id` = '8',`ordernumber` = 'S24040058452', `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` = '20',`total_price` = '9600',`etd` = '2024-04-22',`create_date` = '2024-04-19 10:22:53',`modify_date` = '2024-04-19 10:43:37',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058452' and product_code = 'DG010312-02' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058546' and product_code = 'DG010312-09' 2024-04-19 13:43:11 -- == 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,'231049','8','O24040058546','【芝麻+巧克力】金8結禮盒','DG010312-09','DG010312','金8結盒','禮盒-金8結【芝麻+巧克力】','590','480','0','0','0','0','1','480.0','30','14400','2024-04-22','2024-04-19 10:34:40','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231049',`firm_id` = '8',`ordernumber` = 'O24040058546', `product_name` = '【芝麻+巧克力】金8結禮盒',`product_code` = 'DG010312-09',`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` = '30',`total_price` = '14400',`etd` = '2024-04-22',`create_date` = '2024-04-19 10:34:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058546' and product_code = 'DG010312-09' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058546' and product_code = 'BP010527-01' 2024-04-19 13:43:11 -- == 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,'231049','8','O24040058546','贈品-SNOOPY提把水瓶*2','BP010527-01','BP010527','贈品-SNOOPY提把水瓶+贈品-SNOOPY提把水瓶','贈品-SNOOPY提把水瓶*2','0','0','0','0','0','0','1','0.0','1','0','2024-04-22','2024-04-19 10:34:40','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231049',`firm_id` = '8',`ordernumber` = 'O24040058546', `product_name` = '贈品-SNOOPY提把水瓶*2',`product_code` = 'BP010527-01',`product_sn` = 'BP010527',`product_spec` = '贈品-SNOOPY提把水瓶+贈品-SNOOPY提把水瓶',`invoice_name` = '贈品-SNOOPY提把水瓶*2',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-04-22',`create_date` = '2024-04-19 10:34:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058546' and product_code = 'BP010527-01' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058654' and product_code = 'DG010312-01' 2024-04-19 13:43:11 -- == 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,'231050','8','S24040058654','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','48','23040','2024-04-22','2024-04-19 10:42:34','2024-04-19 13:43:11',0,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231050',`firm_id` = '8',`ordernumber` = 'S24040058654', `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` = '48',`total_price` = '23040',`etd` = '2024-04-22',`create_date` = '2024-04-19 10:42:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058654' and product_code = 'DG010312-01' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058654' and product_code = 'DG010312-06' 2024-04-19 13:43:11 -- == 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,'231050','8','S24040058654','【芝麻＋芝麻】金8結禮盒','DG010312-06','DG010312','金8結盒','禮盒-金8結【芝麻+芝麻】','590','480','0','0','0','0','1','480.0','36','17280','2024-04-22','2024-04-19 10:42:34','2024-04-19 13:43:11',0,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231050',`firm_id` = '8',`ordernumber` = 'S24040058654', `product_name` = '【芝麻＋芝麻】金8結禮盒',`product_code` = 'DG010312-06',`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` = '36',`total_price` = '17280',`etd` = '2024-04-22',`create_date` = '2024-04-19 10:42:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058654' and product_code = 'DG010312-06' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058654' and product_code = 'DG010113-03' 2024-04-19 13:43:11 -- == 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,'231050','8','S24040058654','咖啡小盒','DG010113-03','DG010113','咖啡','32入咖啡','225','225','0','0','0','0','1','0.0','48','10800','2024-04-22','2024-04-19 10:42:34','2024-04-19 13:43:11',0,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231050',`firm_id` = '8',`ordernumber` = 'S24040058654', `product_name` = '咖啡小盒',`product_code` = 'DG010113-03',`product_sn` = 'DG010113',`product_spec` = '咖啡',`invoice_name` = '32入咖啡',`listprice` = '225',`sellingprice` = '225',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '48',`total_price` = '10800',`etd` = '2024-04-22',`create_date` = '2024-04-19 10:42:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058654' and product_code = 'DG010113-03' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058654' and product_code = 'DG010113-04' 2024-04-19 13:43:11 -- == 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,'231050','8','S24040058654','海苔小盒','DG010113-04','DG010113','海苔','32入海苔','225','225','0','0','0','0','1','0.0','24','5400','2024-04-22','2024-04-19 10:42:34','2024-04-19 13:43:11',0,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231050',`firm_id` = '8',`ordernumber` = 'S24040058654', `product_name` = '海苔小盒',`product_code` = 'DG010113-04',`product_sn` = 'DG010113',`product_spec` = '海苔',`invoice_name` = '32入海苔',`listprice` = '225',`sellingprice` = '225',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '24',`total_price` = '5400',`etd` = '2024-04-22',`create_date` = '2024-04-19 10:42:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058654' and product_code = 'DG010113-04' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058654' and product_code = 'DG010113-05' 2024-04-19 13:43:11 -- == 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,'231050','8','S24040058654','巧克力小盒','DG010113-05','DG010113','巧克力','32入巧克力','225','225','0','0','0','0','1','0.0','48','10800','2024-04-22','2024-04-19 10:42:34','2024-04-19 13:43:11',0,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231050',`firm_id` = '8',`ordernumber` = 'S24040058654', `product_name` = '巧克力小盒',`product_code` = 'DG010113-05',`product_sn` = 'DG010113',`product_spec` = '巧克力',`invoice_name` = '32入巧克力',`listprice` = '225',`sellingprice` = '225',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '48',`total_price` = '10800',`etd` = '2024-04-22',`create_date` = '2024-04-19 10:42:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058654' and product_code = 'DG010113-05' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058452' and product_code = 'ZP0101107-01' 2024-04-19 13:43:11 -- == 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,'231048','8','S24040058452','贈品-SNOOPY提把水瓶','ZP0101107-01','ZP0101107','贈品-SNOOPY提把水瓶','贈品-SNOOPY提把水瓶','0','0','0','0','0','0','1','0.0','1','0','2024-04-22','2024-04-19 10:43:37','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231048',`firm_id` = '8',`ordernumber` = 'S24040058452', `product_name` = '贈品-SNOOPY提把水瓶',`product_code` = 'ZP0101107-01',`product_sn` = 'ZP0101107',`product_spec` = '贈品-SNOOPY提把水瓶',`invoice_name` = '贈品-SNOOPY提把水瓶',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-04-22',`create_date` = '2024-04-19 10:43:37',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058452' and product_code = 'ZP0101107-01' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058758' and product_code = 'DG0103155-04' 2024-04-19 13:43:11 -- == 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,'231051','8','O24040058758','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-04','DG0103155','原味蛋捲,海苔蛋捲','禮盒-SNOOPY【原味+海苔】','500','500','0','0','0','0','1','0.0','9','4500','2024-04-25','2024-04-19 10:50:45','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231051',`firm_id` = '8',`ordernumber` = 'O24040058758', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-04',`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` = '9',`total_price` = '4500',`etd` = '2024-04-25',`create_date` = '2024-04-19 10:50:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058758' and product_code = 'DG0103155-04' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058758' and product_code = 'DG010101-01' 2024-04-19 13:43:11 -- == 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,'231051','8','O24040058758','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-04-25','2024-04-19 10:50:45','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231051',`firm_id` = '8',`ordernumber` = 'O24040058758', `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-04-25',`create_date` = '2024-04-19 10:50:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058758' and product_code = 'DG010101-01' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058758' and product_code = 'DG010101-05' 2024-04-19 13:43:11 -- == 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,'231051','8','O24040058758','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-04-25','2024-04-19 10:50:45','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231051',`firm_id` = '8',`ordernumber` = 'O24040058758', `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` = '1',`total_price` = '280',`etd` = '2024-04-25',`create_date` = '2024-04-19 10:50:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058758' and product_code = 'DG010101-05' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058758' and product_code = 'DG010101-02' 2024-04-19 13:43:11 -- == 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,'231051','8','O24040058758','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-04-25','2024-04-19 10:50:45','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231051',`firm_id` = '8',`ordernumber` = 'O24040058758', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`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-04-25',`create_date` = '2024-04-19 10:50:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058758' and product_code = 'DG010101-02' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058758' and product_code = 'BP010159-01' 2024-04-19 13:43:11 -- == 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,'231051','8','O24040058758','[加購]加購-SNOOPY提把水瓶','BP010159-01','BP010159','-','加購-SNOOPY提把水瓶','360','360','1','1','360','0','0','0.0','1','360','2024-04-25','2024-04-19 10:50:45','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231051',`firm_id` = '8',`ordernumber` = 'O24040058758', `product_name` = '[加購]加購-SNOOPY提把水瓶',`product_code` = 'BP010159-01',`product_sn` = 'BP010159',`product_spec` = '-',`invoice_name` = '加購-SNOOPY提把水瓶',`listprice` = '360',`sellingprice` = '360',`isadd` = '1',`isbaby` = '1',`addprice` = '360',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '360',`etd` = '2024-04-25',`create_date` = '2024-04-19 10:50:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058758' and product_code = 'BP010159-01' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058844' and product_code = 'DG010101-03' 2024-04-19 13:43:11 -- == 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,'231052','8','O24040058844','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-04-30','2024-04-19 11:38:04','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231052',`firm_id` = '8',`ordernumber` = 'O24040058844', `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` = '2',`total_price` = '560',`etd` = '2024-04-30',`create_date` = '2024-04-19 11:38:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058844' and product_code = 'DG010101-03' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040058844' and product_code = 'DG010101-05' 2024-04-19 13:43:11 -- == 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,'231052','8','O24040058844','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-04-30','2024-04-19 11:38:04','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231052',`firm_id` = '8',`ordernumber` = 'O24040058844', `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-04-30',`create_date` = '2024-04-19 11:38:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040058844' and product_code = 'DG010101-05' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058955' and product_code = '04191' 2024-04-19 13:43:11 -- == 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,'231053','8','S24040058955','加購－一口鳳梨酥','04191','04191','8入鳳梨酥','加購-(盒)鳳梨酥','155','155','1','0','155','1','1','0.0','1','155','2024-04-22','2024-04-19 11:39:03','2024-04-19 13:43:11',0,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231053',`firm_id` = '8',`ordernumber` = 'S24040058955', `product_name` = '加購－一口鳳梨酥',`product_code` = '04191',`product_sn` = '04191',`product_spec` = '8入鳳梨酥',`invoice_name` = '加購-(盒)鳳梨酥',`listprice` = '155',`sellingprice` = '155',`isadd` = '1',`isbaby` = '0',`addprice` = '155',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '155',`etd` = '2024-04-22',`create_date` = '2024-04-19 11:39:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058955' and product_code = '04191' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058955' and product_code = 'DG0103148-02' 2024-04-19 13:43:11 -- == 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,'231053','8','S24040058955','金典8結禮盒','DG0103148-02','DG0103148','原味+芝麻','禮盒-金典(紅)【原味+芝麻】','480','480','0','0','0','0','1','0.0','2','960','2024-04-22','2024-04-19 11:39:03','2024-04-19 13:43:11',0,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231053',`firm_id` = '8',`ordernumber` = 'S24040058955', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-02',`product_sn` = 'DG0103148',`product_spec` = '原味+芝麻',`invoice_name` = '禮盒-金典(紅)【原味+芝麻】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '960',`etd` = '2024-04-22',`create_date` = '2024-04-19 11:39:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058955' and product_code = 'DG0103148-02' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040058955' and product_code = 'DG0103148-07' 2024-04-19 13:43:11 -- == 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,'231053','8','S24040058955','金典8結禮盒','DG0103148-07','DG0103148','芝麻+咖啡','禮盒-金典(紅)【芝麻+咖啡】','480','480','0','0','0','0','1','0.0','2','960','2024-04-22','2024-04-19 11:39:03','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231053',`firm_id` = '8',`ordernumber` = 'S24040058955', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-07',`product_sn` = 'DG0103148',`product_spec` = '芝麻+咖啡',`invoice_name` = '禮盒-金典(紅)【芝麻+咖啡】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '960',`etd` = '2024-04-22',`create_date` = '2024-04-19 11:39:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040058955' and product_code = 'DG0103148-07' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059093' and product_code = 'DG0103148-06' 2024-04-19 13:43:11 -- == 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,'231054','8','O24040059093','金典8結禮盒','DG0103148-06','DG0103148','芝麻+芝麻','禮盒-金典(紅)【芝麻+芝麻】','480','480','0','0','0','0','1','0.0','1','480','2024-04-22','2024-04-19 12:09:15','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:11 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231054',`firm_id` = '8',`ordernumber` = 'O24040059093', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-06',`product_sn` = 'DG0103148',`product_spec` = '芝麻+芝麻',`invoice_name` = '禮盒-金典(紅)【芝麻+芝麻】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2024-04-22',`create_date` = '2024-04-19 12:09:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059093' and product_code = 'DG0103148-06' 2024-04-19 13:43:11 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059093' and product_code = 'DG0103148-15' 2024-04-19 13:43:11 -- == 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,'231054','8','O24040059093','金典8結禮盒','DG0103148-15','DG0103148','巧克力+巧克力','禮盒-金典(紅)【巧克力+巧克力】','480','480','0','0','0','0','1','0.0','1','480','2024-04-22','2024-04-19 12:09:15','2024-04-19 13:43:11',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231054',`firm_id` = '8',`ordernumber` = 'O24040059093', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-15',`product_sn` = 'DG0103148',`product_spec` = '巧克力+巧克力',`invoice_name` = '禮盒-金典(紅)【巧克力+巧克力】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2024-04-22',`create_date` = '2024-04-19 12:09:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059093' and product_code = 'DG0103148-15' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059093' and product_code = 'DG010404-01' 2024-04-19 13:43:12 -- == 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,'231054','8','O24040059093','紅色提袋','DG010404-01','DG010404','提袋/個','紅色提袋','10','10','0','0','0','0','1','0.0','2','20','2024-04-22','2024-04-19 12:09:15','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231054',`firm_id` = '8',`ordernumber` = 'O24040059093', `product_name` = '紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '提袋/個',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '20',`etd` = '2024-04-22',`create_date` = '2024-04-19 12:09:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059093' and product_code = 'DG010404-01' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059162' and product_code = 'DG010523-22' 2024-04-19 13:43:12 -- == 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,'231055','8','O24040059162','SNOOPY帶走心意-蛋捲三入組','DG010523-22','DG010523','芝麻+巧克力+咖啡','組合-32入(芝麻+咖啡+巧克力)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','2','1980','2024-04-23','2024-04-19 12:51:24','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231055',`firm_id` = '8',`ordernumber` = 'O24040059162', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-22',`product_sn` = 'DG010523',`product_spec` = '芝麻+巧克力+咖啡',`invoice_name` = '組合-32入(芝麻+咖啡+巧克力)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1980',`etd` = '2024-04-23',`create_date` = '2024-04-19 12:51:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059162' and product_code = 'DG010523-22' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059219' and product_code = 'DG010527-04' 2024-04-19 13:43:12 -- == 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,'231056','8','O24040059219','8結蛋捲【小禮袋裝】','DG010527-04','DG010527','40入海苔蛋捲','組合-40入海苔+8結小禮袋','290','290','0','0','0','0','1','0.0','8','2320','2024-05-02','2024-04-19 12:53:47','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231056',`firm_id` = '8',`ordernumber` = 'O24040059219', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-04',`product_sn` = 'DG010527',`product_spec` = '40入海苔蛋捲',`invoice_name` = '組合-40入海苔+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '8',`total_price` = '2320',`etd` = '2024-05-02',`create_date` = '2024-04-19 12:53:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059219' and product_code = 'DG010527-04' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059219' and product_code = 'DG010527-05' 2024-04-19 13:43:12 -- == 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,'231056','8','O24040059219','8結蛋捲【小禮袋裝】','DG010527-05','DG010527','40入巧克力蛋捲','組合-40入巧克力+8結小禮袋','290','290','0','0','0','0','1','0.0','11','3190','2024-05-02','2024-04-19 12:53:47','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231056',`firm_id` = '8',`ordernumber` = 'O24040059219', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-05',`product_sn` = 'DG010527',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '組合-40入巧克力+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '11',`total_price` = '3190',`etd` = '2024-05-02',`create_date` = '2024-04-19 12:53:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059219' and product_code = 'DG010527-05' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059219' and product_code = 'DG010383-14' 2024-04-19 13:43:12 -- == 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,'231056','8','O24040059219','【小王子聯名】星光飛行8結禮盒','DG010383-14','DG010383','巧克力+海苔','禮盒-小王子(紅)【巧克力+海苔】','500','500','0','0','0','0','1','0.0','2','1000','2024-05-02','2024-04-19 12:53:47','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231056',`firm_id` = '8',`ordernumber` = 'O24040059219', `product_name` = '【小王子聯名】星光飛行8結禮盒',`product_code` = 'DG010383-14',`product_sn` = 'DG010383',`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-05-02',`create_date` = '2024-04-19 12:53:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059219' and product_code = 'DG010383-14' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059219' and product_code = 'ZP0101107-01' 2024-04-19 13:43:12 -- == 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,'231056','8','O24040059219','贈品-SNOOPY提把水瓶','ZP0101107-01','ZP0101107','贈品-SNOOPY提把水瓶','贈品-SNOOPY提把水瓶','0','0','0','0','0','0','1','0.0','1','0','2024-05-02','2024-04-19 12:53:47','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231056',`firm_id` = '8',`ordernumber` = 'O24040059219', `product_name` = '贈品-SNOOPY提把水瓶',`product_code` = 'ZP0101107-01',`product_sn` = 'ZP0101107',`product_spec` = '贈品-SNOOPY提把水瓶',`invoice_name` = '贈品-SNOOPY提把水瓶',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-05-02',`create_date` = '2024-04-19 12:53:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059219' and product_code = 'ZP0101107-01' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059316' and product_code = 'DG010527-05' 2024-04-19 13:43:12 -- == 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,'231057','8','O24040059316','8結蛋捲【小禮袋裝】','DG010527-05','DG010527','40入巧克力蛋捲','組合-40入巧克力+8結小禮袋','290','290','0','0','0','0','1','0.0','11','3190','2024-05-02','2024-04-19 12:59:29','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231057',`firm_id` = '8',`ordernumber` = 'O24040059316', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-05',`product_sn` = 'DG010527',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '組合-40入巧克力+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '11',`total_price` = '3190',`etd` = '2024-05-02',`create_date` = '2024-04-19 12:59:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059316' and product_code = 'DG010527-05' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059316' and product_code = 'DG010527-04' 2024-04-19 13:43:12 -- == 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,'231057','8','O24040059316','8結蛋捲【小禮袋裝】','DG010527-04','DG010527','40入海苔蛋捲','組合-40入海苔+8結小禮袋','290','290','0','0','0','0','1','0.0','8','2320','2024-05-02','2024-04-19 12:59:29','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231057',`firm_id` = '8',`ordernumber` = 'O24040059316', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-04',`product_sn` = 'DG010527',`product_spec` = '40入海苔蛋捲',`invoice_name` = '組合-40入海苔+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '8',`total_price` = '2320',`etd` = '2024-05-02',`create_date` = '2024-04-19 12:59:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059316' and product_code = 'DG010527-04' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059316' and product_code = 'DG010383-14' 2024-04-19 13:43:12 -- == 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,'231057','8','O24040059316','【小王子聯名】星光飛行8結禮盒','DG010383-14','DG010383','巧克力+海苔','禮盒-小王子(紅)【巧克力+海苔】','500','500','0','0','0','0','1','0.0','2','1000','2024-05-02','2024-04-19 12:59:29','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231057',`firm_id` = '8',`ordernumber` = 'O24040059316', `product_name` = '【小王子聯名】星光飛行8結禮盒',`product_code` = 'DG010383-14',`product_sn` = 'DG010383',`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-05-02',`create_date` = '2024-04-19 12:59:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059316' and product_code = 'DG010383-14' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24040059316' and product_code = 'ZP0101107-01' 2024-04-19 13:43:12 -- == 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,'231057','8','O24040059316','贈品-SNOOPY提把水瓶','ZP0101107-01','ZP0101107','贈品-SNOOPY提把水瓶','贈品-SNOOPY提把水瓶','0','0','0','0','0','0','1','0.0','1','0','2024-05-02','2024-04-19 12:59:29','2024-04-19 13:43:12',null,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231057',`firm_id` = '8',`ordernumber` = 'O24040059316', `product_name` = '贈品-SNOOPY提把水瓶',`product_code` = 'ZP0101107-01',`product_sn` = 'ZP0101107',`product_spec` = '贈品-SNOOPY提把水瓶',`invoice_name` = '贈品-SNOOPY提把水瓶',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-05-02',`create_date` = '2024-04-19 12:59:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'O24040059316' and product_code = 'ZP0101107-01' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040059481' and product_code = 'DG010101-01' 2024-04-19 13:43:12 -- == 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,'231058','8','S24040059481','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','6','1680','2024-04-22','2024-04-19 13:11:16','2024-04-19 13:43:12',0,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231058',`firm_id` = '8',`ordernumber` = 'S24040059481', `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` = '6',`total_price` = '1680',`etd` = '2024-04-22',`create_date` = '2024-04-19 13:11:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040059481' and product_code = 'DG010101-01' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040059481' and product_code = 'DG010101-03' 2024-04-19 13:43:12 -- == 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,'231058','8','S24040059481','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-04-22','2024-04-19 13:11:16','2024-04-19 13:43:12',0,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231058',`firm_id` = '8',`ordernumber` = 'S24040059481', `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` = '2',`total_price` = '560',`etd` = '2024-04-22',`create_date` = '2024-04-19 13:11:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040059481' and product_code = 'DG010101-03' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040059481' and product_code = 'DG010101-04' 2024-04-19 13:43:12 -- == 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,'231058','8','S24040059481','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-04-22','2024-04-19 13:11:16','2024-04-19 13:43:12',0,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231058',`firm_id` = '8',`ordernumber` = 'S24040059481', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`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-04-22',`create_date` = '2024-04-19 13:11:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040059481' and product_code = 'DG010101-04' 2024-04-19 13:43:12 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24040059481' and product_code = 'DG010101-05' 2024-04-19 13:43:12 -- == 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,'231058','8','S24040059481','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-04-22','2024-04-19 13:11:16','2024-04-19 13:43:12',0,'1','2024-03-11') 2024-04-19 13:43:12 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '231058',`firm_id` = '8',`ordernumber` = 'S24040059481', `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` = '3',`total_price` = '840',`etd` = '2024-04-22',`create_date` = '2024-04-19 13:11:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-03-11'where ordernumber = 'S24040059481' and product_code = 'DG010101-05' 2024-04-19 13:43:12 -- == sync_order_detail end == 2024-04-19 13:43:12 -- == sync_order start == 2024-04-19 13:43:12 -- start:2024-04-19,end:2024-04-19 2024-04-19 13:43:12 -- == 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-04-19%' OR l.modify_date like '2024-04-19%'; 2024-04-19 13:43:12 -- == sync omo_order_list == 2024-04-19 13:43:12 -- == update lake.omo_order_list == update omo_order_list set userId = '200535', process_status = '2', pay_status = '1', totalprice_after = '21125', lunar_date = '2024-03-01', invoice_status = '0', category_name = '正式彌,LINE@訂單', category_id = '1,9' where ordernumber = 'M24040005167' 2024-04-19 13:43:13 -- == update lake.omo_order_list == update omo_order_list set userId = '27711', process_status = '2', pay_status = '1', totalprice_after = '17100', lunar_date = '2024-03-01', invoice_status = '0', category_name = '正式彌,LINE@訂單', category_id = '1,9' where ordernumber = 'M24040005542' 2024-04-19 13:43:13 -- == update lake.omo_order_list == update omo_order_list set userId = '385125', process_status = '2', pay_status = '8', totalprice_after = '1200', lunar_date = '2024-03-03', invoice_status = '0', category_name = 'LINE@訂單,彌月試吃', category_id = '9,2' where ordernumber = 'M24040007537' 2024-04-19 13:43:13 -- == update lake.omo_order_list == update omo_order_list set userId = '385016', process_status = '2', pay_status = '1', totalprice_after = '20970', lunar_date = '2024-03-04', invoice_status = '0', category_name = '正式彌,LINE@訂單', category_id = '1,9' where ordernumber = 'M24040008929' 2024-04-19 13:43:13 -- == update lake.omo_order_list == update omo_order_list set userId = '385783', process_status = '3', pay_status = '1', totalprice_after = '6160', lunar_date = '2024-03-08', invoice_status = '1', category_name = '', category_id = '' where ordernumber = 'B24040012583' 2024-04-19 13:43:13 -- == update lake.omo_order_list == update omo_order_list set userId = '381885', process_status = '2', pay_status = '1', totalprice_after = '8550', lunar_date = '2024-03-09', invoice_status = '0', category_name = '', category_id = '' where ordernumber = 'B24040013323' 2024-04-19 13:43:13 -- == update lake.omo_order_list == update omo_order_list set userId = '385928', process_status = '2', pay_status = '1', totalprice_after = '500', lunar_date = '2024-03-10', invoice_status = '0', category_name = 'FB訂單,彌月試吃', category_id = '10,2' where ordernumber = 'M24040014332' 2024-04-19 13:43:13 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '7', totalprice_after = '0', lunar_date = '2024-03-10', invoice_status = '2', category_name = '公關訂單', category_id = '6' where ordernumber = 'M24040014620' 2024-04-19 13:43:13 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '7', totalprice_after = '0', lunar_date = '2024-03-10', invoice_status = '2', category_name = '公關訂單', category_id = '6' where ordernumber = 'M24040014873' 2024-04-19 13:43:13 -- == update lake.omo_order_list == update omo_order_list set userId = '383581', process_status = '2', pay_status = '1', totalprice_after = '10665', lunar_date = '2024-03-10', invoice_status = '0', category_name = 'LINE@訂單,正式彌', category_id = '9,1' where ordernumber = 'M24040015042' 2024-04-19 13:43:13 -- == 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 ('109584','386066',2,'正式彌,LINE@訂單','1,9','M24040015337','1','1','1','1','1','','','0','2024-04-30','0','1200','0','','0','0','24000','433','台中市','沙鹿區','433','台中市','沙鹿區','22800','2024-04-19 09:21:45','2024-03-11') 2024-04-19 13:43:13 -- == 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 ('109612','386093',2,'正式彌,LINE@訂單','1,9','M24040015426','1','1','1','1','1','','','0','2024-05-15','0','750','0','','0','0','15000','927','屏東縣','林邊鄉','927','屏東縣','林邊鄉','14250','2024-04-19 12:48:45','2024-03-11') 2024-04-19 13:43:13 -- == sync_order end == 2024-04-19 13:43:13 -- == sync_order_detail start == 2024-04-19 13:43:13 -- start:2024-04-19,end:2024-04-19 2024-04-19 13:43:13 -- == sync omo_order_detail == 2024-04-19 13:43:13 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-04-19%' OR modify_date like '2024-04-19%' 2024-04-19 13:43:13 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24040012583' and product_code = 'SS010102-01' 2024-04-19 13:43:13 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30818',`firm_id` = '8',`ordernumber` = 'B24040012583', `product_name` = '品純萃鱸魚精30入',`product_code` = 'SS010102-01',`product_sn` = 'SS010102',`product_spec` = '品純萃鱸魚精30入',`invoice_name` = '品純萃鱸魚精30入',`listprice` = '5200',`sellingprice` = '5200',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '1.0',`amount` = '1',`total_price` = '5200',`etd` = '2024-04-18',`create_date` = '2024-04-16 23:54:24',`modify_date` = '2024-04-19 09:01:38',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24040012583' and product_code = 'SS010102-01', `lunar_date` = '2024-03-08' 2024-04-19 13:43:13 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24040012583' and product_code = '05401' 2024-04-19 13:43:13 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30818',`firm_id` = '8',`ordernumber` = 'B24040012583', `product_name` = '品純萃鱸魚精5入試飲組※每帳號限購1組※',`product_code` = '05401',`product_sn` = '05401',`product_spec` = '5入鱸魚精',`invoice_name` = '品純萃鱸魚精5入試飲組',`listprice` = '1100',`sellingprice` = '990',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-04-18',`create_date` = '2024-04-16 23:54:24',`modify_date` = '2024-04-19 09:01:38',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24040012583' and product_code = '05401', `lunar_date` = '2024-03-08' 2024-04-19 13:43:13 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B24040012583' and product_code = 'ZP010151-01' 2024-04-19 13:43:13 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30818',`firm_id` = '8',`ordernumber` = 'B24040012583', `product_name` = '贈品-給足呵護童襪組',`product_code` = 'ZP010151-01',`product_sn` = 'ZP010151',`product_spec` = '一組',`invoice_name` = '贈品-sNug寶寶襪/童襪x4(款式隨機)',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-04-18',`create_date` = '2024-04-16 23:54:24',`modify_date` = '2024-04-19 09:01:38',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B24040012583' and product_code = 'ZP010151-01', `lunar_date` = '2024-03-08' 2024-04-19 13:43:13 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24040015337' and product_code = 'DG010203-01' 2024-04-19 13:43:13 -- == 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, 2,'30850','8','M24040015337','【小王子聯名】閃耀星空8結彌月提盒','DG010203-01','DG010203','原味','提盒-小王子(藍)-40入原味','300','300','0','0','0','0','1','0.0','80','24000','2024-04-30','2024-04-19 09:21:45','2024-04-19 13:43:13',null,'1','2024-03-11') 2024-04-19 13:43:13 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30850',`firm_id` = '8',`ordernumber` = 'M24040015337', `product_name` = '【小王子聯名】閃耀星空8結彌月提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`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` = '80',`total_price` = '24000',`etd` = '2024-04-30',`create_date` = '2024-04-19 09:21:45',`modify_date` = '2024-04-19 12:40:49',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24040015337' and product_code = 'DG010203-01', `lunar_date` = '2024-03-11' 2024-04-19 13:43:13 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24040015337' and product_code = 'ZP0101106-01' 2024-04-19 13:43:13 -- == 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, 2,'30850','8','M24040015337','贈品-SNOOPY熱壓三明治機','ZP0101106-01','ZP0101106','贈品-SNOOPY熱壓三明治機','贈品-SNOOPY熱壓三明治機','0','0','0','0','0','0','1','0.0','1','0','2024-04-30','2024-04-19 09:21:45','2024-04-19 13:43:13',null,'1','2024-03-11') 2024-04-19 13:43:13 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30850',`firm_id` = '8',`ordernumber` = 'M24040015337', `product_name` = '贈品-SNOOPY熱壓三明治機',`product_code` = 'ZP0101106-01',`product_sn` = 'ZP0101106',`product_spec` = '贈品-SNOOPY熱壓三明治機',`invoice_name` = '贈品-SNOOPY熱壓三明治機',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-04-30',`create_date` = '2024-04-19 09:21:45',`modify_date` = '2024-04-19 12:40:49',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24040015337' and product_code = 'ZP0101106-01', `lunar_date` = '2024-03-11' 2024-04-19 13:43:13 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24040015426' and product_code = 'DG010202-01' 2024-04-19 13:43:13 -- == 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, 2,'30851','8','M24040015426','8結彌月提盒-年輪','DG010202-01','DG010202','原味','提盒-彌月年輪-40入原味','0','300','0','0','0','0','1','300.0','20','6000','2024-05-15','2024-04-19 12:48:45','2024-04-19 13:43:13',null,'1','2024-03-11') 2024-04-19 13:43:13 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30851',`firm_id` = '8',`ordernumber` = 'M24040015426', `product_name` = '8結彌月提盒-年輪',`product_code` = 'DG010202-01',`product_sn` = 'DG010202',`product_spec` = '原味',`invoice_name` = '提盒-彌月年輪-40入原味',`listprice` = '0',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '20',`total_price` = '6000',`etd` = '2024-05-15',`create_date` = '2024-04-19 12:48:45',`modify_date` = '2024-04-19 13:20:43',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24040015426' and product_code = 'DG010202-01', `lunar_date` = '2024-03-11' 2024-04-19 13:43:13 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24040015426' and product_code = 'DG010202-02' 2024-04-19 13:43:13 -- == 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, 2,'30851','8','M24040015426','8結彌月提盒-年輪','DG010202-02','DG010202','芝麻','提盒-彌月年輪-40入芝麻','300','300','0','0','0','0','1','300.0','15','4500','2024-05-15','2024-04-19 12:48:45','2024-04-19 13:43:13',null,'1','2024-03-11') 2024-04-19 13:43:13 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30851',`firm_id` = '8',`ordernumber` = 'M24040015426', `product_name` = '8結彌月提盒-年輪',`product_code` = 'DG010202-02',`product_sn` = 'DG010202',`product_spec` = '芝麻',`invoice_name` = '提盒-彌月年輪-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '15',`total_price` = '4500',`etd` = '2024-05-15',`create_date` = '2024-04-19 12:48:45',`modify_date` = '2024-04-19 13:20:43',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24040015426' and product_code = 'DG010202-02', `lunar_date` = '2024-03-11' 2024-04-19 13:43:13 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24040015426' and product_code = 'DG010202-05' 2024-04-19 13:43:13 -- == 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, 2,'30851','8','M24040015426','8結彌月提盒-年輪','DG010202-05','DG010202','巧克力','提盒-彌月年輪-40入巧克力','300','300','0','0','0','0','1','300.0','15','4500','2024-05-15','2024-04-19 12:48:45','2024-04-19 13:43:13',null,'1','2024-03-11') 2024-04-19 13:43:13 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30851',`firm_id` = '8',`ordernumber` = 'M24040015426', `product_name` = '8結彌月提盒-年輪',`product_code` = 'DG010202-05',`product_sn` = 'DG010202',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月年輪-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '15',`total_price` = '4500',`etd` = '2024-05-15',`create_date` = '2024-04-19 12:48:45',`modify_date` = '2024-04-19 13:20:43',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24040015426' and product_code = 'DG010202-05', `lunar_date` = '2024-03-11' 2024-04-19 13:43:13 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24040015426' and product_code = 'ZP0101119-01' 2024-04-19 13:43:13 -- == 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, 2,'30851','8','M24040015426','贈品-recolte熱感美容儀','ZP0101119-01','ZP0101119','贈品-recolte熱感美容儀','贈品-recolte熱感美容儀','0','0','0','0','0','0','1','0.0','1','0','2024-05-15','2024-04-19 12:48:45','2024-04-19 13:43:13',null,'1','2024-03-11') 2024-04-19 13:43:13 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '30851',`firm_id` = '8',`ordernumber` = 'M24040015426', `product_name` = '贈品-recolte熱感美容儀',`product_code` = 'ZP0101119-01',`product_sn` = 'ZP0101119',`product_spec` = '贈品-recolte熱感美容儀',`invoice_name` = '贈品-recolte熱感美容儀',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-05-15',`create_date` = '2024-04-19 12:48:45',`modify_date` = '2024-04-19 13:20:43',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24040015426' and product_code = 'ZP0101119-01', `lunar_date` = '2024-03-11' 2024-04-19 13:43:13 -- == sync_order_detail end == 2024-04-19 13:43:13 -- == 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-04-19' OR o.updated_at = '2024-04-19') and o.deleted_at is null 2024-04-19 13:43:13 -- == sync_order_detail start == 2024-04-19 13:43:13 -- start:2024-04-19,end:2024-04-19 2024-04-19 13:43:13 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2024-04-19 13:43:14 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2024-04-19 13:43:15 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2024-04-19%';