2023-11-23 10:40:19 -- == sync_order start == 2023-11-23 10:40:19 -- start:2023-11-23,end:2023-11-23 2023-11-23 10:40:19 -- == 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 '2023-11-23%' OR l.modify_date like '2023-11-23%'; 2023-11-23 10:40:20 -- == sync omo_order_list == 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '267007', process_status = '2', pay_status = '1', totalprice_after = '5600', lunar_date = '2023-09-11', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23100107819' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '1', pay_status = '0', totalprice_after = '17100', lunar_date = '2023-09-11', invoice_status = '0',category_name = 'LINE@訂單', category_id = '9' where ordernumber = 'S23100110257' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '289884', process_status = '2', pay_status = '1', totalprice_after = '2790', lunar_date = '2023-09-28', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110041511' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '3', pay_status = '0', totalprice_after = '1280640', lunar_date = '2023-10-04', invoice_status = '0',category_name = '通路訂單', category_id = '5' where ordernumber = 'S23110059779' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '347380', process_status = '3', pay_status = '1', totalprice_after = '3020', lunar_date = '2023-10-04', invoice_status = '1',category_name = '', category_id = '' where ordernumber = 'O23110060224' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '347498', process_status = '1', pay_status = '1', totalprice_after = '2570', lunar_date = '2023-10-06', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110065179' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348163', process_status = '2', pay_status = '1', totalprice_after = '680', lunar_date = '2023-10-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110066352' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '274495', process_status = '2', pay_status = '1', totalprice_after = '1110', lunar_date = '2023-10-07', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110066697' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348282', process_status = '3', pay_status = '1', totalprice_after = '1800', lunar_date = '2023-10-07', invoice_status = '1',category_name = '', category_id = '' where ordernumber = 'O23110066989' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '346775', process_status = '3', pay_status = '1', totalprice_after = '2040', lunar_date = '2023-10-08', invoice_status = '1',category_name = '', category_id = '' where ordernumber = 'O23110067793' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '347982', process_status = '2', pay_status = '1', totalprice_after = '999', lunar_date = '2023-10-08', invoice_status = '0',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110069134' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '347549', process_status = '3', pay_status = '1', totalprice_after = '1299', lunar_date = '2023-10-08', invoice_status = '1',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110070487' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '345755', process_status = '3', pay_status = '1', totalprice_after = '2070', lunar_date = '2023-10-08', invoice_status = '1',category_name = '', category_id = '' where ordernumber = 'O23110070626' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '345755', process_status = '3', pay_status = '1', totalprice_after = '1299', lunar_date = '2023-10-08', invoice_status = '1',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110071451' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '1', totalprice_after = '41952', lunar_date = '2023-10-09', invoice_status = '0',category_name = '電話訂單,企業訂單', category_id = '12,4' where ordernumber = 'S23110075495' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348683', process_status = '2', pay_status = '1', totalprice_after = '320', lunar_date = '2023-10-09', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110079388' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348687', process_status = '2', pay_status = '1', totalprice_after = '1020', lunar_date = '2023-10-09', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110079487' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348690', process_status = '2', pay_status = '1', totalprice_after = '5800', lunar_date = '2023-10-09', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110079578' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348692', process_status = '2', pay_status = '1', totalprice_after = '3600', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110079769' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '342602', process_status = '2', pay_status = '1', totalprice_after = '1650', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110079920' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348680', process_status = '2', pay_status = '1', totalprice_after = '1290', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110080864' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348702', process_status = '2', pay_status = '1', totalprice_after = '4188', lunar_date = '2023-10-10', invoice_status = '0',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110080962' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '291627', process_status = '2', pay_status = '1', totalprice_after = '4188', lunar_date = '2023-10-10', invoice_status = '0',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110081092' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '343172', process_status = '2', pay_status = '1', totalprice_after = '1299', lunar_date = '2023-10-10', invoice_status = '0',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110081127' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348706', process_status = '2', pay_status = '1', totalprice_after = '2648', lunar_date = '2023-10-10', invoice_status = '0',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110081226' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348167', process_status = '2', pay_status = '1', totalprice_after = '1299', lunar_date = '2023-10-10', invoice_status = '0',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110081563' 2023-11-23 10:40:20 -- == update lake.omo_order_list == update omo_order_list set userId = '348718', process_status = '2', pay_status = '1', totalprice_after = '1299', lunar_date = '2023-10-10', invoice_status = '0',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110081699' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348701', process_status = '2', pay_status = '1', totalprice_after = '1299', lunar_date = '2023-10-10', invoice_status = '0',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110081758' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '7', totalprice_after = '450', lunar_date = '2023-10-10', invoice_status = '2',category_name = 'line禮物', category_id = '38' where ordernumber = 'S23110081998' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '7', totalprice_after = '450', lunar_date = '2023-10-10', invoice_status = '2',category_name = 'line禮物', category_id = '38' where ordernumber = 'S23110082066' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '7', totalprice_after = '650', lunar_date = '2023-10-10', invoice_status = '2',category_name = 'line禮物', category_id = '38' where ordernumber = 'S23110082192' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '7', totalprice_after = '445', lunar_date = '2023-10-10', invoice_status = '2',category_name = 'line禮物', category_id = '38' where ordernumber = 'S23110082235' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '7', totalprice_after = '450', lunar_date = '2023-10-10', invoice_status = '2',category_name = 'line禮物', category_id = '38' where ordernumber = 'S23110082364' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '347061', process_status = '2', pay_status = '1', totalprice_after = '1800', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110082422' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '117910', process_status = '2', pay_status = '1', totalprice_after = '1290', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110082544' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '347498', process_status = '0', pay_status = '0', totalprice_after = '120', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'S23110082665' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348103', process_status = '2', pay_status = '1', totalprice_after = '1100', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110082839' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '7', totalprice_after = '0', lunar_date = '2023-10-10', invoice_status = '2',category_name = '公關訂單,企業試吃', category_id = '6,8' where ordernumber = 'S23110082948' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348790', process_status = '2', pay_status = '1', totalprice_after = '750', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110083034' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348795', process_status = '2', pay_status = '1', totalprice_after = '1320', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110083148' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348786', process_status = '2', pay_status = '1', totalprice_after = '4188', lunar_date = '2023-10-10', invoice_status = '0',category_name = '免運專區活動', category_id = '27' where ordernumber = 'O23110083259' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348797', process_status = '2', pay_status = '1', totalprice_after = '2800', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110083375' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348563', process_status = '2', pay_status = '1', totalprice_after = '19255', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110083482' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348815', process_status = '2', pay_status = '1', totalprice_after = '1370', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110083867' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348676', process_status = '2', pay_status = '1', totalprice_after = '2570', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110083969' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '166697', process_status = '2', pay_status = '1', totalprice_after = '710', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110084178' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348833', process_status = '2', pay_status = '1', totalprice_after = '420', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110084360' 2023-11-23 10:40:21 -- == update lake.omo_order_list == update omo_order_list set userId = '348840', process_status = '2', pay_status = '1', totalprice_after = '1240', lunar_date = '2023-10-10', invoice_status = '0',category_name = '', category_id = '' where ordernumber = 'O23110084649' 2023-11-23 10:40:21 -- == 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 ('311651','348834',1,'','','O23110084728','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','300','640','雲林縣','斗六市','237','新北市','三峽區','420','2023-11-23 00:19:01','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311660','348843',1,'','','O23110084823','1','11','1','0','0','','','0','0000-00-00','0','0','0','','150','0','590','802','高雄市','苓雅區','802','高雄市','苓雅區','740','2023-11-23 02:25:56','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311660','348843',1,'','','O23110084910','1','11','1','0','0','','','0','0000-00-00','0','0','0','','150','0','590','802','高雄市','苓雅區','802','高雄市','苓雅區','740','2023-11-23 02:27:47','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311468','348654',1,'','','O23110085086','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1180','303','新竹縣','湖口鄉','303','新竹縣','湖口鄉','1300','2023-11-23 06:22:47','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311664','348847',1,'','','O23110085188','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2375','406','台中市','北屯區','406','台中市','北屯區','2495','2023-11-23 08:54:01','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('291274','328715',1,'免運專區活動','27','O23110085230','1','1','1','1','2','','','0','2023-11-24','0','0','0','','0','0','1299','741','台南市','善化區','741','台南市','善化區','1299','2023-11-23 09:03:38','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311652','348835',1,'免運專區活動','27','O23110085359','1','1','1','1','2','','','0','2023-11-24','0','0','0','','0','0','1299','737','台南市','鹽水區','737','台南市','鹽水區','1299','2023-11-23 09:03:54','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311653','348836',1,'免運專區活動','27','O23110085465','1','1','1','1','2','97998590','安徳聯合診所','0','2023-11-24','0','0','0','','0','0','2298','100','台北市','中正區','100','台北市','中正區','2298','2023-11-23 09:04:14','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('235886','265810',1,'免運專區活動','27','O23110085592','1','1','1','1','2','','','0','2023-11-24','0','0','0','','0','0','2658','402','台中市','南區','265','宜蘭縣','羅東鎮','2658','2023-11-23 09:04:31','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311663','348846',1,'免運專區活動','27','O23110085618','1','1','1','1','2','','','0','2023-11-24','0','0','0','','0','0','4188','510','彰化縣','員林市','404','台中市','北區','4188','2023-11-23 09:05:24','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311666','348849',1,'','','O23110085736','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','780','711','台南市','歸仁區','912','屏東縣','內埔鄉','930','2023-11-23 09:34:15','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('211928','216202',1,'','','O23110085878','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','150','2740','103','台北市','大同區','551','南投縣','名間鄉','2740','2023-11-23 09:39:34','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('139774','247872',1,',測試訂單',',30','O23110085934','1','2','6','7','6','','','0','2023-11-30','2370','0','0','','150','0','2370','545','南投縣','埔里鎮','545','南投縣','埔里鎮','150','2023-11-23 09:40:01','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('250319','284052',1,'電話訂單,迪化當日宅配','12,44','S23110086082','1','1','12','1','1','02142005','台灣區表面處理工業同業公會','0','2023-11-27','0','498','0','','0','0','9960','236','新北市','土城區','242','新北市','新莊區','9462','2023-11-23 09:45:35','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311671','348853',1,'','','O23110086167','1','2','1','0','0','33821252','同仁醫院','0','0000-00-00','0','0','0','','150','0','1335','231','新北市','新店區','231','新北市','新店區','1485','2023-11-23 10:27:45','2023-10-11') 2023-11-23 10:40:21 -- == 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 ('311669','348852',1,'','','O23110086245','1','1','1','0','0','29089812','亞克先進科技股份有限公司','0','0000-00-00','0','0','0','','0','30','5915','351','苗栗縣','頭份市','351','苗栗縣','頭份市','5885','2023-11-23 10:40:02','2023-10-11') 2023-11-23 10:40:21 -- == sync_order end == 2023-11-23 10:40:21 -- == sync_order_detail start == 2023-11-23 10:40:21 -- start:2023-11-23,end:2023-11-23 2023-11-23 10:40:21 -- == sync omo_order_detail == 2023-11-23 10:40:21 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2023-11-23%' OR modify_date like '2023-11-23%' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23100107819' and product_code = 'DG010539-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212374',`firm_id` = '8',`ordernumber` = 'O23100107819', `product_name` = '阿薩姆紅茶蛋捲x2入組',`product_code` = 'DG010539-01',`product_sn` = 'DG010539',`product_spec` = '32入阿薩姆蛋捲+32入阿薩姆蛋捲',`invoice_name` = '阿薩姆蛋捲x2',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1920',`etd` = '2023-11-23',`create_date` = '2023-10-25 00:49:39',`modify_date` = '2023-11-23 08:35:45',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'O23100107819' and product_code = 'DG010539-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23100107819' and product_code = 'DG010540-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212374',`firm_id` = '8',`ordernumber` = 'O23100107819', `product_name` = '宜蘭三星蔥蛋捲x2入組',`product_code` = 'DG010540-01',`product_sn` = 'DG010540',`product_spec` = '32入三星蔥蛋捲+32入三星蔥蛋捲',`invoice_name` = '三星蔥蛋捲x2',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1920',`etd` = '2023-11-23',`create_date` = '2023-10-25 00:49:39',`modify_date` = '2023-11-23 08:35:45',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'O23100107819' and product_code = 'DG010540-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23100107819' and product_code = 'DG010541-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212374',`firm_id` = '8',`ordernumber` = 'O23100107819', `product_name` = '法式焦糖蛋捲x2入組',`product_code` = 'DG010541-01',`product_sn` = 'DG010541',`product_spec` = '32入法式焦糖蛋捲+32入法式焦糖蛋捲',`invoice_name` = '32入法式焦糖蛋捲x2',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '1500',`etd` = '2023-11-23',`create_date` = '2023-10-25 00:49:39',`modify_date` = '2023-11-23 08:35:45',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'O23100107819' and product_code = 'DG010541-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23100107819' and product_code = 'DG010404-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212374',`firm_id` = '8',`ordernumber` = 'O23100107819', `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` = '10',`total_price` = '100',`etd` = '2023-11-23',`create_date` = '2023-10-25 00:49:39',`modify_date` = '2023-11-23 08:35:45',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'O23100107819' and product_code = 'DG010404-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23100107819' and product_code = 'TE010101-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212374',`firm_id` = '8',`ordernumber` = 'O23100107819', `product_name` = '棗香枸杞茶',`product_code` = 'TE010101-01',`product_sn` = 'TE010101',`product_spec` = '6入枸杞茶盒裝',`invoice_name` = '棗香枸杞茶',`listprice` = '160',`sellingprice` = '160',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '160.0',`amount` = '1',`total_price` = '160',`etd` = '2023-11-23',`create_date` = '2023-10-25 00:49:39',`modify_date` = '2023-11-23 08:35:45',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'O23100107819' and product_code = 'TE010101-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23100107819' and product_code = 'ZP010155-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212374',`firm_id` = '8',`ordernumber` = 'O23100107819', `product_name` = '贈品-鳳梨造型擦手球',`product_code` = 'ZP010155-01',`product_sn` = 'ZP010155',`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` = '2023-11-23',`create_date` = '2023-10-25 00:49:39',`modify_date` = '2023-11-23 08:35:45',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'O23100107819' and product_code = 'ZP010155-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23100110257' and product_code = 'DG010226-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212398',`firm_id` = '8',`ordernumber` = 'S23100110257', `product_name` = '蓮花式溫碗8結蛋捲提盒【國立故宮博物院】',`product_code` = 'DG010226-01',`product_sn` = 'DG010226',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-故宮(文物款)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '20',`total_price` = '6000',`etd` = '2023-12-05',`create_date` = '2023-10-25 13:48:32',`modify_date` = '2023-11-23 09:54:59',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'S23100110257' and product_code = 'DG010226-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23100110257' and product_code = 'DG010226-02' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212398',`firm_id` = '8',`ordernumber` = 'S23100110257', `product_name` = '蓮花式溫碗8結蛋捲提盒【國立故宮博物院】',`product_code` = 'DG010226-02',`product_sn` = 'DG010226',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '提盒-故宮(文物款)-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '20',`total_price` = '6000',`etd` = '2023-12-05',`create_date` = '2023-10-25 13:48:32',`modify_date` = '2023-11-23 09:54:59',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'S23100110257' and product_code = 'DG010226-02' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23100110257' and product_code = 'DG010226-05' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212398',`firm_id` = '8',`ordernumber` = 'S23100110257', `product_name` = '蓮花式溫碗8結蛋捲提盒【國立故宮博物院】',`product_code` = 'DG010226-05',`product_sn` = 'DG010226',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '提盒-故宮(文物款)-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '20',`total_price` = '6000',`etd` = '2023-12-05',`create_date` = '2023-10-25 13:48:32',`modify_date` = '2023-11-23 09:54:59',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'S23100110257' and product_code = 'DG010226-05' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23100110257' and product_code = 'ZP010155-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '212398',`firm_id` = '8',`ordernumber` = 'S23100110257', `product_name` = '贈品-鳳梨造型擦手球',`product_code` = 'ZP010155-01',`product_sn` = 'ZP010155',`product_spec` = '贈品-鳳梨造型擦手球',`invoice_name` = '贈品-鳳梨造型擦手球',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '0',`etd` = '2023-12-05',`create_date` = '2023-10-25 13:48:32',`modify_date` = '2023-11-23 09:54:59',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-09-11'where ordernumber = 'S23100110257' and product_code = 'ZP010155-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110041511' and product_code = 'DG010539-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213124',`firm_id` = '8',`ordernumber` = 'O23110041511', `product_name` = '阿薩姆紅茶蛋捲x2入組',`product_code` = 'DG010539-01',`product_sn` = 'DG010539',`product_spec` = '32入阿薩姆蛋捲+32入阿薩姆蛋捲',`invoice_name` = '阿薩姆蛋捲x2',`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` = '2023-11-24',`create_date` = '2023-11-11 15:02:15',`modify_date` = '2023-11-23 10:34:43',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-28'where ordernumber = 'O23110041511' and product_code = 'DG010539-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110041511' and product_code = 'DG010101-02' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213124',`firm_id` = '8',`ordernumber` = 'O23110041511', `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` = '2',`total_price` = '560',`etd` = '2023-11-24',`create_date` = '2023-11-11 15:02:15',`modify_date` = '2023-11-23 10:34:43',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-28'where ordernumber = 'O23110041511' and product_code = 'DG010101-02' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110041511' and product_code = 'DG010101-05' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213124',`firm_id` = '8',`ordernumber` = 'O23110041511', `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` = '2023-11-24',`create_date` = '2023-11-11 15:02:15',`modify_date` = '2023-11-23 10:34:43',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-28'where ordernumber = 'O23110041511' and product_code = 'DG010101-05' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110041511' and product_code = 'DG010101-04' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213124',`firm_id` = '8',`ordernumber` = 'O23110041511', `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` = '2023-11-24',`create_date` = '2023-11-11 15:02:15',`modify_date` = '2023-11-23 10:34:43',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-09-28'where ordernumber = 'O23110041511' and product_code = 'DG010101-04' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110060224' and product_code = 'DG010527-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213317',`firm_id` = '8',`ordernumber` = 'O23110060224', `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` = '4',`total_price` = '1160',`etd` = '2023-11-22',`create_date` = '2023-11-16 17:26:18',`modify_date` = '2023-11-23 10:18:03',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-04'where ordernumber = 'O23110060224' and product_code = 'DG010527-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110060224' and product_code = 'DG010527-02' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213317',`firm_id` = '8',`ordernumber` = 'O23110060224', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-02',`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` = '3',`total_price` = '870',`etd` = '2023-11-22',`create_date` = '2023-11-16 17:26:18',`modify_date` = '2023-11-23 10:18:03',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-04'where ordernumber = 'O23110060224' and product_code = 'DG010527-02' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110060224' and product_code = 'DG010527-03' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213317',`firm_id` = '8',`ordernumber` = 'O23110060224', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-03',`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` = '3',`total_price` = '870',`etd` = '2023-11-22',`create_date` = '2023-11-16 17:26:18',`modify_date` = '2023-11-23 10:18:03',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-04'where ordernumber = 'O23110060224' and product_code = 'DG010527-03' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110065179' and product_code = 'DG010539-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213366',`firm_id` = '8',`ordernumber` = 'O23110065179', `product_name` = '阿薩姆紅茶蛋捲x2入組',`product_code` = 'DG010539-01',`product_sn` = 'DG010539',`product_spec` = '32入阿薩姆蛋捲+32入阿薩姆蛋捲',`invoice_name` = '阿薩姆蛋捲x2',`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` = '2023-12-29',`create_date` = '2023-11-18 09:24:32',`modify_date` = '2023-11-23 10:03:41',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-06'where ordernumber = 'O23110065179' and product_code = 'DG010539-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110065179' and product_code = 'DG010129-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213366',`firm_id` = '8',`ordernumber` = 'O23110065179', `product_name` = '【期間限定】皇家伯爵茶蛋捲',`product_code` = 'DG010129-01',`product_sn` = 'DG010129',`product_spec` = '32入皇家伯爵茶蛋捲',`invoice_name` = '32入皇家伯爵茶蛋捲',`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` = '2023-12-29',`create_date` = '2023-11-18 09:24:32',`modify_date` = '2023-11-23 10:03:41',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-06'where ordernumber = 'O23110065179' and product_code = 'DG010129-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110065179' and product_code = 'DG010101-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213366',`firm_id` = '8',`ordernumber` = 'O23110065179', `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` = '2',`total_price` = '560',`etd` = '2023-12-29',`create_date` = '2023-11-18 09:24:32',`modify_date` = '2023-11-23 10:03:41',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-06'where ordernumber = 'O23110065179' and product_code = 'DG010101-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110065179' and product_code = 'DG010101-03' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213366',`firm_id` = '8',`ordernumber` = 'O23110065179', `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` = '2023-12-29',`create_date` = '2023-11-18 09:24:32',`modify_date` = '2023-11-23 10:03:41',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-06'where ordernumber = 'O23110065179' and product_code = 'DG010101-03' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110065179' and product_code = 'DG010101-05' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213366',`firm_id` = '8',`ordernumber` = 'O23110065179', `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` = '2023-12-29',`create_date` = '2023-11-18 09:24:32',`modify_date` = '2023-11-23 10:03:41',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-06'where ordernumber = 'O23110065179' and product_code = 'DG010101-05' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110065179' and product_code = 'BP010128-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213366',`firm_id` = '8',`ordernumber` = 'O23110065179', `product_name` = '8結小禮袋',`product_code` = 'BP010128-01',`product_sn` = 'BP010128',`product_spec` = '提袋/個',`invoice_name` = '8結小禮袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '60',`etd` = '2023-12-29',`create_date` = '2023-11-18 09:24:32',`modify_date` = '2023-11-23 10:03:41',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-06'where ordernumber = 'O23110065179' and product_code = 'BP010128-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23110075495' and product_code = 'DG010312-10' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213471',`firm_id` = '8',`ordernumber` = 'S23110075495', `product_name` = '【咖啡＋咖啡】金8結禮盒',`product_code` = 'DG010312-10',`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` = '10',`total_price` = '4800',`etd` = '2023-11-23',`create_date` = '2023-11-21 10:16:01',`modify_date` = '2023-11-23 08:37:04',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-10-09'where ordernumber = 'S23110075495' and product_code = 'DG010312-10' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23110075495' and product_code = 'DG010312-06' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213471',`firm_id` = '8',`ordernumber` = 'S23110075495', `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` = '20',`total_price` = '9600',`etd` = '2023-11-23',`create_date` = '2023-11-21 10:16:01',`modify_date` = '2023-11-23 08:37:04',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-10-09'where ordernumber = 'S23110075495' and product_code = 'DG010312-06' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23110075495' and product_code = 'DG010312-13' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213471',`firm_id` = '8',`ordernumber` = 'S23110075495', `product_name` = '【海苔＋海苔】金8結禮盒',`product_code` = 'DG010312-13',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【海苔+海苔】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '16',`total_price` = '7680',`etd` = '2023-11-23',`create_date` = '2023-11-21 10:16:01',`modify_date` = '2023-11-23 08:37:04',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-10-09'where ordernumber = 'S23110075495' and product_code = 'DG010312-13' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23110075495' and product_code = 'DG010312-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213471',`firm_id` = '8',`ordernumber` = 'S23110075495', `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` = '30',`total_price` = '14400',`etd` = '2023-11-23',`create_date` = '2023-11-21 10:16:01',`modify_date` = '2023-11-23 08:37:04',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-10-09'where ordernumber = 'S23110075495' and product_code = 'DG010312-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23110075495' and product_code = 'DG010312-15' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213471',`firm_id` = '8',`ordernumber` = 'S23110075495', `product_name` = '【巧克力＋巧克力】金8結禮盒',`product_code` = 'DG010312-15',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【巧克力+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '16',`total_price` = '7680',`etd` = '2023-11-23',`create_date` = '2023-11-21 10:16:01',`modify_date` = '2023-11-23 08:37:04',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-10-09'where ordernumber = 'S23110075495' and product_code = 'DG010312-15' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23110075495' and product_code = 'DG010404-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213471',`firm_id` = '8',`ordernumber` = 'S23110075495', `product_name` = '紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '紅色提袋',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '0',`isadd` = '1',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '184',`total_price` = '0',`etd` = '2023-11-23',`create_date` = '2023-11-21 10:16:01',`modify_date` = '2023-11-23 08:37:04',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-09'where ordernumber = 'S23110075495' and product_code = 'DG010404-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23110082665' and product_code = 'DG010129-01' 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213547',`firm_id` = '8',`ordernumber` = 'S23110082665', `product_name` = '【期間限定】皇家伯爵茶蛋捲',`product_code` = 'DG010129-01',`product_sn` = 'DG010129',`product_spec` = '32入皇家伯爵茶蛋捲',`invoice_name` = '32入皇家伯爵茶蛋捲',`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` = '2023-12-29',`create_date` = '2023-11-22 15:38:55',`modify_date` = '2023-11-23 10:03:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-10-10'where ordernumber = 'S23110082665' and product_code = 'DG010129-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110084728' and product_code = 'DG010261-05' 2023-11-23 10:40:23 -- == 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,'213568','8','O23110084728','【SNOOPY聯名】美好食光-8結提盒','DG010261-05','DG010261','40入巧克力蛋捲','提盒-SNOOPY-40入巧克力','300','300','0','0','0','0','1','0.0','1','300','2023-11-27','2023-11-23 00:19:01','2023-11-23 10:40:23',null,'1','2023-10-11') 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213568',`firm_id` = '8',`ordernumber` = 'O23110084728', `product_name` = '【SNOOPY聯名】美好食光-8結提盒',`product_code` = 'DG010261-05',`product_sn` = 'DG010261',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '提盒-SNOOPY-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-11-27',`create_date` = '2023-11-23 00:19:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110084728' and product_code = 'DG010261-05' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110084823' and product_code = 'DG010255-05' 2023-11-23 10:40:23 -- == 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,'213569','8','O23110084823','金典8結提盒','DG010255-05','DG010255','40入巧克力蛋捲','提盒-金典(紅)-40入巧克力','295','295','0','0','0','0','1','0.0','1','295','2023-11-27','2023-11-23 02:25:56','2023-11-23 10:40:23',null,'1','2023-10-11') 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213569',`firm_id` = '8',`ordernumber` = 'O23110084823', `product_name` = '金典8結提盒',`product_code` = 'DG010255-05',`product_sn` = 'DG010255',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '提盒-金典(紅)-40入巧克力',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2023-11-27',`create_date` = '2023-11-23 02:25:56',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110084823' and product_code = 'DG010255-05' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110084823' and product_code = 'DG010255-02' 2023-11-23 10:40:23 -- == 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,'213569','8','O23110084823','金典8結提盒','DG010255-02','DG010255','40入芝麻蛋捲','提盒-金典(紅)-40入芝麻','295','295','0','0','0','0','1','0.0','1','295','2023-11-27','2023-11-23 02:25:56','2023-11-23 10:40:23',null,'1','2023-10-11') 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213569',`firm_id` = '8',`ordernumber` = 'O23110084823', `product_name` = '金典8結提盒',`product_code` = 'DG010255-02',`product_sn` = 'DG010255',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '提盒-金典(紅)-40入芝麻',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2023-11-27',`create_date` = '2023-11-23 02:25:56',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110084823' and product_code = 'DG010255-02' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110084910' and product_code = 'DG010258-02' 2023-11-23 10:40:23 -- == 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,'213570','8','O23110084910','金豐收8結提盒','DG010258-02','DG010258','40入芝麻蛋捲','提盒-金豐收(藍)-40入芝麻','295','295','0','0','0','0','1','0.0','1','295','2023-11-27','2023-11-23 02:27:47','2023-11-23 10:40:23',null,'1','2023-10-11') 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213570',`firm_id` = '8',`ordernumber` = 'O23110084910', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-02',`product_sn` = 'DG010258',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入芝麻',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2023-11-27',`create_date` = '2023-11-23 02:27:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110084910' and product_code = 'DG010258-02' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110084910' and product_code = 'DG010258-05' 2023-11-23 10:40:23 -- == 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,'213570','8','O23110084910','金豐收8結提盒','DG010258-05','DG010258','40入巧克力蛋捲','提盒-金豐收(藍)-40入巧克力','295','295','0','0','0','0','1','0.0','1','295','2023-11-27','2023-11-23 02:27:47','2023-11-23 10:40:23',null,'1','2023-10-11') 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213570',`firm_id` = '8',`ordernumber` = 'O23110084910', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-05',`product_sn` = 'DG010258',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入巧克力',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2023-11-27',`create_date` = '2023-11-23 02:27:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110084910' and product_code = 'DG010258-05' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085086' and product_code = 'DG010129-01' 2023-11-23 10:40:23 -- == 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,'213571','8','O23110085086','【期間限定】皇家伯爵茶蛋捲','DG010129-01','DG010129','32入皇家伯爵茶蛋捲','32入皇家伯爵茶蛋捲','300','300','0','0','0','0','1','0.0','1','300','2023-12-19','2023-11-23 06:22:47','2023-11-23 10:40:23',null,'1','2023-10-11') 2023-11-23 10:40:23 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213571',`firm_id` = '8',`ordernumber` = 'O23110085086', `product_name` = '【期間限定】皇家伯爵茶蛋捲',`product_code` = 'DG010129-01',`product_sn` = 'DG010129',`product_spec` = '32入皇家伯爵茶蛋捲',`invoice_name` = '32入皇家伯爵茶蛋捲',`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` = '2023-12-19',`create_date` = '2023-11-23 06:22:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085086' and product_code = 'DG010129-01' 2023-11-23 10:40:23 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085086' and product_code = 'DG010261-05' 2023-11-23 10:40:23 -- == 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,'213571','8','O23110085086','【SNOOPY聯名】美好食光-8結提盒','DG010261-05','DG010261','40入巧克力蛋捲','提盒-SNOOPY-40入巧克力','300','300','0','0','0','0','1','0.0','2','600','2023-12-19','2023-11-23 06:22:47','2023-11-23 10:40:23',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213571',`firm_id` = '8',`ordernumber` = 'O23110085086', `product_name` = '【SNOOPY聯名】美好食光-8結提盒',`product_code` = 'DG010261-05',`product_sn` = 'DG010261',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '提盒-SNOOPY-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2023-12-19',`create_date` = '2023-11-23 06:22:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085086' and product_code = 'DG010261-05' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085086' and product_code = 'DG010101-05' 2023-11-23 10:40:24 -- == 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,'213571','8','O23110085086','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2023-12-19','2023-11-23 06:22:47','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213571',`firm_id` = '8',`ordernumber` = 'O23110085086', `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` = '2023-12-19',`create_date` = '2023-11-23 06:22:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085086' and product_code = 'DG010101-05' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085188' and product_code = 'DG010255-02' 2023-11-23 10:40:24 -- == 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,'213572','8','O23110085188','金典8結提盒','DG010255-02','DG010255','40入芝麻蛋捲','提盒-金典(紅)-40入芝麻','295','295','0','0','0','0','1','0.0','5','1475','2023-11-28','2023-11-23 08:54:01','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213572',`firm_id` = '8',`ordernumber` = 'O23110085188', `product_name` = '金典8結提盒',`product_code` = 'DG010255-02',`product_sn` = 'DG010255',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '提盒-金典(紅)-40入芝麻',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '1475',`etd` = '2023-11-28',`create_date` = '2023-11-23 08:54:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085188' and product_code = 'DG010255-02' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085188' and product_code = 'DG010203-05' 2023-11-23 10:40:24 -- == 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,'213572','8','O23110085188','【小王子聯名】閃耀星空8結提盒','DG010203-05','DG010203','40入巧克力蛋捲','提盒-小王子(藍)-40入巧克力','300','300','0','0','0','0','1','0.0','3','900','2023-11-28','2023-11-23 08:54:01','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213572',`firm_id` = '8',`ordernumber` = 'O23110085188', `product_name` = '【小王子聯名】閃耀星空8結提盒',`product_code` = 'DG010203-05',`product_sn` = 'DG010203',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '提盒-小王子(藍)-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '900',`etd` = '2023-11-28',`create_date` = '2023-11-23 08:54:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085188' and product_code = 'DG010203-05' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085230' and product_code = 'DG010533-04' 2023-11-23 10:40:24 -- == 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,'213573','12','O23110085230','台灣友好組','DG010533-04','DG010533','32入楓糖鬆餅蛋捲','組合-32入(原味+芝麻+咖啡+巧克力+楓糖)','1299','1299','0','1','0','0','1','0.0','1','1299','2023-11-24','2023-11-23 09:03:38','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213573',`firm_id` = '12',`ordernumber` = 'O23110085230', `product_name` = '台灣友好組',`product_code` = 'DG010533-04',`product_sn` = 'DG010533',`product_spec` = '32入楓糖鬆餅蛋捲',`invoice_name` = '組合-32入(原味+芝麻+咖啡+巧克力+楓糖)',`listprice` = '1299',`sellingprice` = '1299',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1299',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:03:38',`modify_date` = '2023-11-23 09:03:38',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085230' and product_code = 'DG010533-04' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085359' and product_code = 'DG010533-04' 2023-11-23 10:40:24 -- == 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,'213574','12','O23110085359','台灣友好組','DG010533-04','DG010533','32入楓糖鬆餅蛋捲','組合-32入(原味+芝麻+咖啡+巧克力+楓糖)','1299','1299','0','1','0','0','1','0.0','1','1299','2023-11-24','2023-11-23 09:03:54','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213574',`firm_id` = '12',`ordernumber` = 'O23110085359', `product_name` = '台灣友好組',`product_code` = 'DG010533-04',`product_sn` = 'DG010533',`product_spec` = '32入楓糖鬆餅蛋捲',`invoice_name` = '組合-32入(原味+芝麻+咖啡+巧克力+楓糖)',`listprice` = '1299',`sellingprice` = '1299',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1299',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:03:54',`modify_date` = '2023-11-23 09:03:54',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085359' and product_code = 'DG010533-04' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085465' and product_code = 'DG010533-01' 2023-11-23 10:40:24 -- == 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,'213575','12','O23110085465','台灣友好組','DG010533-01','DG010533','32入三星蔥蛋捲','組合-32入(原味+芝麻+咖啡+巧克力+三星蔥)','1299','1299','0','1','0','0','1','0.0','1','1299','2023-11-24','2023-11-23 09:04:14','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213575',`firm_id` = '12',`ordernumber` = 'O23110085465', `product_name` = '台灣友好組',`product_code` = 'DG010533-01',`product_sn` = 'DG010533',`product_spec` = '32入三星蔥蛋捲',`invoice_name` = '組合-32入(原味+芝麻+咖啡+巧克力+三星蔥)',`listprice` = '1299',`sellingprice` = '1299',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1299',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:04:14',`modify_date` = '2023-11-23 09:04:14',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085465' and product_code = 'DG010533-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085465' and product_code = 'DG010535-08' 2023-11-23 10:40:24 -- == 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,'213575','12','O23110085465','台法浪漫饗宴','DG010535-08','DG010535','三星蔥+三星蔥+三星蔥','組合-32入(三星蔥+三星蔥+三星蔥)+SNOOPY心意提袋','999','999','0','1','0','0','1','0.0','1','999','2023-11-24','2023-11-23 09:04:14','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213575',`firm_id` = '12',`ordernumber` = 'O23110085465', `product_name` = '台法浪漫饗宴',`product_code` = 'DG010535-08',`product_sn` = 'DG010535',`product_spec` = '三星蔥+三星蔥+三星蔥',`invoice_name` = '組合-32入(三星蔥+三星蔥+三星蔥)+SNOOPY心意提袋',`listprice` = '999',`sellingprice` = '999',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '999',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:04:14',`modify_date` = '2023-11-23 09:04:14',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085465' and product_code = 'DG010535-08' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085592' and product_code = 'DG010533-04' 2023-11-23 10:40:24 -- == 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,'213576','12','O23110085592','台灣友好組','DG010533-04','DG010533','32入楓糖鬆餅蛋捲','組合-32入(原味+芝麻+咖啡+巧克力+楓糖)','1299','1299','0','1','0','0','1','0.0','2','2598','2023-11-24','2023-11-23 09:04:31','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213576',`firm_id` = '12',`ordernumber` = 'O23110085592', `product_name` = '台灣友好組',`product_code` = 'DG010533-04',`product_sn` = 'DG010533',`product_spec` = '32入楓糖鬆餅蛋捲',`invoice_name` = '組合-32入(原味+芝麻+咖啡+巧克力+楓糖)',`listprice` = '1299',`sellingprice` = '1299',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '2598',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:04:31',`modify_date` = '2023-11-23 09:05:09',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085592' and product_code = 'DG010533-04' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085592' and product_code = '03466' 2023-11-23 10:40:24 -- == 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,'213576','12','O23110085592','紅色提袋(免運專區用)','03466','03466','提袋/個','紅色提袋','10','10','0','1','0','0','1','0.0','6','60','2023-11-24','2023-11-23 09:04:31','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213576',`firm_id` = '12',`ordernumber` = 'O23110085592', `product_name` = '紅色提袋(免運專區用)',`product_code` = '03466',`product_sn` = '03466',`product_spec` = '提袋/個',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '60',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:04:31',`modify_date` = '2023-11-23 09:05:09',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085592' and product_code = '03466' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085618' and product_code = '03956' 2023-11-23 10:40:24 -- == 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,'213577','12','O23110085618','國際漫遊組','03956','03956','原原+芝芝+巧巧+咖咖+海海','組合-32入(原原+芝芝+巧巧+咖咖+海海)+小王子行李箱','4188','4188','0','1','0','0','1','0.0','1','4188','2023-11-24','2023-11-23 09:05:24','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213577',`firm_id` = '12',`ordernumber` = 'O23110085618', `product_name` = '國際漫遊組',`product_code` = '03956',`product_sn` = '03956',`product_spec` = '原原+芝芝+巧巧+咖咖+海海',`invoice_name` = '組合-32入(原原+芝芝+巧巧+咖咖+海海)+小王子行李箱',`listprice` = '4188',`sellingprice` = '4188',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '4188',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:05:24',`modify_date` = '2023-11-23 09:05:46',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085618' and product_code = '03956' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085736' and product_code = 'DG010312-02' 2023-11-23 10:40:24 -- == 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,'213578','8','O23110085736','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2023-11-27','2023-11-23 09:34:15','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213578',`firm_id` = '8',`ordernumber` = 'O23110085736', `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` = '2023-11-27',`create_date` = '2023-11-23 09:34:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085736' and product_code = 'DG010312-02' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085736' and product_code = 'DG010203-01' 2023-11-23 10:40:24 -- == 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,'213578','8','O23110085736','【小王子聯名】閃耀星空8結提盒','DG010203-01','DG010203','40入原味蛋捲','提盒-小王子(藍)-40入原味','300','300','0','0','0','0','1','0.0','1','300','2023-11-27','2023-11-23 09:34:15','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213578',`firm_id` = '8',`ordernumber` = 'O23110085736', `product_name` = '【小王子聯名】閃耀星空8結提盒',`product_code` = 'DG010203-01',`product_sn` = 'DG010203',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-小王子(藍)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-11-27',`create_date` = '2023-11-23 09:34:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085736' and product_code = 'DG010203-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085878' and product_code = 'DG010101-01' 2023-11-23 10:40:24 -- == 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,'213579','8','O23110085878','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2023-12-11','2023-11-23 09:39:34','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213579',`firm_id` = '8',`ordernumber` = 'O23110085878', `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` = '2',`total_price` = '560',`etd` = '2023-12-11',`create_date` = '2023-11-23 09:39:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085878' and product_code = 'DG010101-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085878' and product_code = 'DG010101-02' 2023-11-23 10:40:24 -- == 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,'213579','8','O23110085878','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','3','840','2023-12-11','2023-11-23 09:39:34','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213579',`firm_id` = '8',`ordernumber` = 'O23110085878', `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` = '2023-12-11',`create_date` = '2023-11-23 09:39:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085878' and product_code = 'DG010101-02' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085878' and product_code = 'DG010101-05' 2023-11-23 10:40:24 -- == 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,'213579','8','O23110085878','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2023-12-11','2023-11-23 09:39:34','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213579',`firm_id` = '8',`ordernumber` = 'O23110085878', `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` = '2023-12-11',`create_date` = '2023-11-23 09:39:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085878' and product_code = 'DG010101-05' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085878' and product_code = 'DG010540-01' 2023-11-23 10:40:24 -- == 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,'213579','8','O23110085878','宜蘭三星蔥蛋捲x2入組','DG010540-01','DG010540','32入三星蔥蛋捲+32入三星蔥蛋捲','三星蔥蛋捲x2','480','480','0','0','0','0','1','0.0','1','480','2023-12-11','2023-11-23 09:39:34','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213579',`firm_id` = '8',`ordernumber` = 'O23110085878', `product_name` = '宜蘭三星蔥蛋捲x2入組',`product_code` = 'DG010540-01',`product_sn` = 'DG010540',`product_spec` = '32入三星蔥蛋捲+32入三星蔥蛋捲',`invoice_name` = '三星蔥蛋捲x2',`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` = '2023-12-11',`create_date` = '2023-11-23 09:39:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085878' and product_code = 'DG010540-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085878' and product_code = 'DG010527-01' 2023-11-23 10:40:24 -- == 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,'213579','8','O23110085878','8結蛋捲【小禮袋裝】','DG010527-01','DG010527','40入原味蛋捲','組合-40入原味+8結小禮袋','290','290','0','0','0','0','1','0.0','2','580','2023-12-11','2023-11-23 09:39:34','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213579',`firm_id` = '8',`ordernumber` = 'O23110085878', `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` = '2',`total_price` = '580',`etd` = '2023-12-11',`create_date` = '2023-11-23 09:39:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085878' and product_code = 'DG010527-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085934' and product_code = 'DG0103170-01' 2023-11-23 10:40:24 -- == 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,'213580','8','O23110085934','【皇家伯爵茶】金8結禮盒','DG0103170-01','DG0103169','32入皇家伯爵茶蛋捲+32入皇家伯爵茶蛋捲','禮盒-金8結【伯爵茶+伯爵茶】','630','630','0','0','0','0','1','0.0','1','630','2023-11-30','2023-11-23 09:40:01','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213580',`firm_id` = '8',`ordernumber` = 'O23110085934', `product_name` = '【皇家伯爵茶】金8結禮盒',`product_code` = 'DG0103170-01',`product_sn` = 'DG0103169',`product_spec` = '32入皇家伯爵茶蛋捲+32入皇家伯爵茶蛋捲',`invoice_name` = '禮盒-金8結【伯爵茶+伯爵茶】',`listprice` = '630',`sellingprice` = '630',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '630',`etd` = '2023-11-30',`create_date` = '2023-11-23 09:40:01',`modify_date` = '2023-11-23 09:43:29',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085934' and product_code = 'DG0103170-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085934' and product_code = 'DG0103169-03' 2023-11-23 10:40:24 -- == 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,'213580','8','O23110085934','【皇家伯爵茶】金8結禮盒','DG0103169-03','DG0103169','咖啡+32入皇家伯爵茶蛋捲','禮盒-金8結【伯爵茶+咖啡】','555','555','0','0','0','0','1','0.0','1','555','2023-11-30','2023-11-23 09:40:01','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213580',`firm_id` = '8',`ordernumber` = 'O23110085934', `product_name` = '【皇家伯爵茶】金8結禮盒',`product_code` = 'DG0103169-03',`product_sn` = 'DG0103169',`product_spec` = '咖啡+32入皇家伯爵茶蛋捲',`invoice_name` = '禮盒-金8結【伯爵茶+咖啡】',`listprice` = '555',`sellingprice` = '555',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '555',`etd` = '2023-11-30',`create_date` = '2023-11-23 09:40:01',`modify_date` = '2023-11-23 09:43:29',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085934' and product_code = 'DG0103169-03' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085934' and product_code = 'DG0103172-01' 2023-11-23 10:40:24 -- == 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,'213580','8','O23110085934','【皇家伯爵茶】金典8結禮盒','DG0103172-01','DG0103171','32入皇家伯爵茶蛋捲+32入皇家伯爵茶蛋捲','禮盒-金典(紅)【伯爵茶+伯爵茶】','630','630','0','0','0','0','1','0.0','1','630','2023-11-30','2023-11-23 09:40:01','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213580',`firm_id` = '8',`ordernumber` = 'O23110085934', `product_name` = '【皇家伯爵茶】金典8結禮盒',`product_code` = 'DG0103172-01',`product_sn` = 'DG0103171',`product_spec` = '32入皇家伯爵茶蛋捲+32入皇家伯爵茶蛋捲',`invoice_name` = '禮盒-金典(紅)【伯爵茶+伯爵茶】',`listprice` = '630',`sellingprice` = '630',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '630',`etd` = '2023-11-30',`create_date` = '2023-11-23 09:40:01',`modify_date` = '2023-11-23 09:43:29',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085934' and product_code = 'DG0103172-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110085934' and product_code = 'DG0103171-05' 2023-11-23 10:40:24 -- == 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,'213580','8','O23110085934','【皇家伯爵茶】金典8結禮盒','DG0103171-05','DG0103171','巧克力+32入皇家伯爵茶蛋捲','禮盒-金典(紅)【伯爵茶+巧克力】','555','555','0','0','0','0','1','0.0','1','555','2023-11-30','2023-11-23 09:40:01','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213580',`firm_id` = '8',`ordernumber` = 'O23110085934', `product_name` = '【皇家伯爵茶】金典8結禮盒',`product_code` = 'DG0103171-05',`product_sn` = 'DG0103171',`product_spec` = '巧克力+32入皇家伯爵茶蛋捲',`invoice_name` = '禮盒-金典(紅)【伯爵茶+巧克力】',`listprice` = '555',`sellingprice` = '555',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '555',`etd` = '2023-11-30',`create_date` = '2023-11-23 09:40:01',`modify_date` = '2023-11-23 09:43:29',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110085934' and product_code = 'DG0103171-05' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23110086082' and product_code = 'DG010258-01' 2023-11-23 10:40:24 -- == 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,'213581','8','S23110086082','金豐收8結提盒','DG010258-01','DG010258','40入原味蛋捲','提盒-金豐收(藍)-40入原味','295','295','0','0','0','0','1','0.0','30','8850','2023-11-27','2023-11-23 09:45:35','2023-11-23 10:40:24',0,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213581',`firm_id` = '8',`ordernumber` = 'S23110086082', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-01',`product_sn` = 'DG010258',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入原味',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '30',`total_price` = '8850',`etd` = '2023-11-27',`create_date` = '2023-11-23 09:45:35',`modify_date` = '2023-11-23 09:55:35',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'S23110086082' and product_code = 'DG010258-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S23110086082' and product_code = 'DG0103169-01' 2023-11-23 10:40:24 -- == 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,'213581','8','S23110086082','【皇家伯爵茶】金8結禮盒','DG0103169-01','DG0103169','原味+32入皇家伯爵茶蛋捲','禮盒-金8結【伯爵茶+原味】','555','555','0','0','0','0','1','0.0','2','1110','2023-11-27','2023-11-23 09:45:35','2023-11-23 10:40:24',0,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213581',`firm_id` = '8',`ordernumber` = 'S23110086082', `product_name` = '【皇家伯爵茶】金8結禮盒',`product_code` = 'DG0103169-01',`product_sn` = 'DG0103169',`product_spec` = '原味+32入皇家伯爵茶蛋捲',`invoice_name` = '禮盒-金8結【伯爵茶+原味】',`listprice` = '555',`sellingprice` = '555',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1110',`etd` = '2023-11-27',`create_date` = '2023-11-23 09:45:35',`modify_date` = '2023-11-23 09:55:35',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'S23110086082' and product_code = 'DG0103169-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110086167' and product_code = '12345' 2023-11-23 10:40:24 -- == 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,'213582','8','O23110086167','8結隨享茶點禮盒','12345','12146','原味+巧克力,鳳梨酥,黑松露腰果','禮盒-8結隨享【原味+巧克力】+鳳梨酥+黑松露腰果','500','500','0','0','0','0','1','0.0','1','500','2023-11-27','2023-11-23 10:27:45','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213582',`firm_id` = '8',`ordernumber` = 'O23110086167', `product_name` = '8結隨享茶點禮盒',`product_code` = '12345',`product_sn` = '12146',`product_spec` = '原味+巧克力,鳳梨酥,黑松露腰果',`invoice_name` = '禮盒-8結隨享【原味+巧克力】+鳳梨酥+黑松露腰果',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2023-11-27',`create_date` = '2023-11-23 10:27:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110086167' and product_code = '12345' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110086167' and product_code = '12241' 2023-11-23 10:40:24 -- == 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,'213582','8','O23110086167','8結隨享茶點禮盒','12241','12146','原味+芝麻,鳳梨酥,夏威夷豆軟糖','禮盒-8結隨享【原味+芝麻】+鳳梨酥+夏威夷豆軟糖','550','550','0','0','0','0','1','0.0','1','550','2023-11-27','2023-11-23 10:27:45','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213582',`firm_id` = '8',`ordernumber` = 'O23110086167', `product_name` = '8結隨享茶點禮盒',`product_code` = '12241',`product_sn` = '12146',`product_spec` = '原味+芝麻,鳳梨酥,夏威夷豆軟糖',`invoice_name` = '禮盒-8結隨享【原味+芝麻】+鳳梨酥+夏威夷豆軟糖',`listprice` = '550',`sellingprice` = '550',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '550',`etd` = '2023-11-27',`create_date` = '2023-11-23 10:27:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110086167' and product_code = '12241' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110086167' and product_code = '03951' 2023-11-23 10:40:24 -- == 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,'213582','8','O23110086167','[加購]加購-黑曜芝麻糕分享包(袋裝25入)','03951','03951','-','加購-黑曜芝麻糕分享包','285','285','1','1','285','0','0','0.0','1','285','2023-11-27','2023-11-23 10:27:45','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213582',`firm_id` = '8',`ordernumber` = 'O23110086167', `product_name` = '[加購]加購-黑曜芝麻糕分享包(袋裝25入)',`product_code` = '03951',`product_sn` = '03951',`product_spec` = '-',`invoice_name` = '加購-黑曜芝麻糕分享包',`listprice` = '285',`sellingprice` = '285',`isadd` = '1',`isbaby` = '1',`addprice` = '285',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '285',`etd` = '2023-11-27',`create_date` = '2023-11-23 10:27:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110086167' and product_code = '03951' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110086245' and product_code = 'DG010527-01' 2023-11-23 10:40:24 -- == 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,'213583','8','O23110086245','8結蛋捲【小禮袋裝】','DG010527-01','DG010527','40入原味蛋捲','組合-40入原味+8結小禮袋','290','290','0','0','0','0','1','0.0','7','2030','2023-11-27','2023-11-23 10:40:02','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:24 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213583',`firm_id` = '8',`ordernumber` = 'O23110086245', `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` = '7',`total_price` = '2030',`etd` = '2023-11-27',`create_date` = '2023-11-23 10:40:02',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110086245' and product_code = 'DG010527-01' 2023-11-23 10:40:24 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O23110086245' and product_code = '02248' 2023-11-23 10:40:25 -- == 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,'213583','8','O23110086245','金巧8結禮盒','02248','02240','原味,鳳梨酥+枸杞茶','禮盒-金巧8結【(原味)-鳳梨酥+枸杞茶】','555','555','0','0','0','0','1','0.0','7','3885','2023-11-27','2023-11-23 10:40:02','2023-11-23 10:40:24',null,'1','2023-10-11') 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '213583',`firm_id` = '8',`ordernumber` = 'O23110086245', `product_name` = '金巧8結禮盒',`product_code` = '02248',`product_sn` = '02240',`product_spec` = '原味,鳳梨酥+枸杞茶',`invoice_name` = '禮盒-金巧8結【(原味)-鳳梨酥+枸杞茶】',`listprice` = '555',`sellingprice` = '555',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '7',`total_price` = '3885',`etd` = '2023-11-27',`create_date` = '2023-11-23 10:40:02',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2023-10-11'where ordernumber = 'O23110086245' and product_code = '02248' 2023-11-23 10:40:25 -- == sync_order_detail end == 2023-11-23 10:40:25 -- == sync_order start == 2023-11-23 10:40:25 -- start:2023-11-23,end:2023-11-23 2023-11-23 10:40:25 -- == 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 '2023-11-23%' OR l.modify_date like '2023-11-23%'; 2023-11-23 10:40:25 -- == sync omo_order_list == 2023-11-23 10:40:25 -- == update lake.omo_order_list == update omo_order_list set userId = '346860', process_status = '2', pay_status = '1', totalprice_after = '22230', lunar_date = '2023-10-02', invoice_status = '0', category_name = '正式彌,LINE@訂單', category_id = '1,9' where ordernumber = 'M23110016771' 2023-11-23 10:40:25 -- == update lake.omo_order_list == update omo_order_list set userId = '346860', process_status = '2', pay_status = '1', totalprice_after = '710', lunar_date = '2023-10-02', invoice_status = '0', category_name = 'LINE@訂單', category_id = '9' where ordernumber = 'M23110017034' 2023-11-23 10:40:25 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '2', pay_status = '1', totalprice_after = '19000', lunar_date = '2023-10-04', invoice_status = '0', category_name = '正式彌,LINE@訂單', category_id = '1,9' where ordernumber = 'M23110019473' 2023-11-23 10:40:25 -- == update lake.omo_order_list == update omo_order_list set userId = '345465', process_status = '2', pay_status = '1', totalprice_after = '8805', lunar_date = '2023-10-05', invoice_status = '0', category_name = '', category_id = '' where ordernumber = 'B23110021272' 2023-11-23 10:40:25 -- == update lake.omo_order_list == update omo_order_list set userId = '347873', process_status = '1', pay_status = '1', totalprice_after = '26715', lunar_date = '2023-10-09', invoice_status = '0', category_name = 'FB訂單,正式彌', category_id = '10,1' where ordernumber = 'B23110021411RB2' 2023-11-23 10:40:25 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '1', pay_status = '1', totalprice_after = '9975', lunar_date = '2023-10-09', invoice_status = '0', category_name = '正式彌,LINE@訂單', category_id = '1,9' where ordernumber = 'M23110026556' 2023-11-23 10:40:25 -- == update lake.omo_order_list == update omo_order_list set userId = '199231', process_status = '1', pay_status = '1', totalprice_after = '13350', lunar_date = '2023-10-10', invoice_status = '0', category_name = '正式彌,LINE@訂單', category_id = '1,9' where ordernumber = 'M23110028254' 2023-11-23 10:40:25 -- == update lake.omo_order_list == update omo_order_list set userId = '347873', process_status = '6', pay_status = '1', totalprice_after = '1425', lunar_date = '2023-10-10', invoice_status = '0', category_name = 'FB訂單,正式彌', category_id = '10,1' where ordernumber = 'M23110028550' 2023-11-23 10:40:25 -- == update lake.omo_order_list == update omo_order_list set userId = '348564', process_status = '6', pay_status = '0', totalprice_after = '18780', lunar_date = '2023-10-10', invoice_status = '0', category_name = '正式彌,LINE@訂單', category_id = '1,9' where ordernumber = 'M23110028764' 2023-11-23 10:40:25 -- == 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 ('71851','0',2,'彌月試吃','2','B23110028953','1','11','1','1','2','','','0','2023-11-24','0','0','0','','0','0','500','112','台北市','北投區','112','台北市','北投區','500','2023-11-23 09:05:50','2023-10-11') 2023-11-23 10:40:25 -- == 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 ('71605','0',2,'正式彌,LINE@訂單','1,9','M23110029022','1','2','1','0','0','','','0','2023-11-30','0','150','0','','0','0','3000','412','台中市','大里區','412','台中市','大里區','2850','2023-11-23 09:14:33','2023-10-11') 2023-11-23 10:40:25 -- == 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 ('71647','348564',2,'正式彌,LINE@訂單','1,9','M23110028764RB','1','1','6','0','0','','','0','2023-12-01','0','990','0','','0','30','19800','251','新北市','淡水區','251','新北市','淡水區','18780','2023-11-23 09:25:48','2023-10-11') 2023-11-23 10:40:25 -- == 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 ('5943','197881',2,'彌月試吃,LINE@訂單','2,9','M23110029130','1','2','1','0','0','','','0','2023-11-24','0','0','0','','0','0','1600','913','屏東縣','萬丹鄉','913','屏東縣','萬丹鄉','1600','2023-11-23 09:51:19','2023-10-11') 2023-11-23 10:40:25 -- == 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 ('71844','0',2,'正式彌,FB訂單','1,10','M23110029254','1','11','1','0','0','','','0','2023-11-29','975','0','0','','0','30','19500','504','彰化縣','秀水鄉','504','彰化縣','秀水鄉','18495','2023-11-23 10:10:49','2023-10-11') 2023-11-23 10:40:25 -- == 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 ('71940','0',2,'正式彌,LINE@訂單','1,9','M23110029379','1','2','1','0','0','','','0','2023-12-06','0','540','0','','0','0','10800','821','高雄市','路竹區','821','高雄市','路竹區','10260','2023-11-23 10:36:21','2023-10-11') 2023-11-23 10:40:25 -- == sync_order end == 2023-11-23 10:40:25 -- == sync_order_detail start == 2023-11-23 10:40:25 -- start:2023-11-23,end:2023-11-23 2023-11-23 10:40:25 -- == sync omo_order_detail == 2023-11-23 10:40:25 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2023-11-23%' OR modify_date like '2023-11-23%' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23110021411RB2' and product_code = 'DG010213-01' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29179',`firm_id` = '8',`ordernumber` = 'B23110021411RB2', `product_name` = '8結彌月提盒－香頌日光',`product_code` = 'DG010213-01',`product_sn` = 'DG010213',`product_spec` = '原味',`invoice_name` = '提盒-彌月香頌日光-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '93',`total_price` = '27900',`etd` = '2023-11-30',`create_date` = '2023-11-17 15:23:50',`modify_date` = '2023-11-23 09:53:13',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23110021411RB2' and product_code = 'DG010213-01', `lunar_date` = '2023-10-05' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23110021411RB2' and product_code = 'ZP010133-01' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29179',`firm_id` = '8',`ordernumber` = 'B23110021411RB2', `product_name` = '贈品-recolte花灑萃取咖啡機(顏色隨機)',`product_code` = 'ZP010133-01',`product_sn` = 'ZP010133',`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` = '2023-11-30',`create_date` = '2023-11-17 15:23:50',`modify_date` = '2023-11-23 09:53:13',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23110021411RB2' and product_code = 'ZP010133-01', `lunar_date` = '2023-10-05' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23110021411RB2' and product_code = '40009' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29179',`firm_id` = '8',`ordernumber` = 'B23110021411RB2', `product_name` = '運費',`product_code` = '40009',`product_sn` = '40000',`product_spec` = '80運費',`invoice_name` = '80運費',`listprice` = '80',`sellingprice` = '80',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '240',`etd` = '2023-11-30',`create_date` = '2023-11-17 15:35:33',`modify_date` = '2023-11-23 09:53:13',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23110021411RB2' and product_code = '40009', `lunar_date` = '2023-10-05' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110026556' and product_code = 'DG010222-01' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29185',`firm_id` = '8',`ordernumber` = 'M23110026556', `product_name` = '【小王子聯名】夢想旅程8結彌月提盒',`product_code` = 'DG010222-01',`product_sn` = 'DG010222',`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` = '17',`total_price` = '5100',`etd` = '2023-11-23',`create_date` = '2023-11-21 11:38:14',`modify_date` = '2023-11-23 09:30:41',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110026556' and product_code = 'DG010222-01', `lunar_date` = '2023-10-09' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110026556' and product_code = 'DG010222-02' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29185',`firm_id` = '8',`ordernumber` = 'M23110026556', `product_name` = '【小王子聯名】夢想旅程8結彌月提盒',`product_code` = 'DG010222-02',`product_sn` = 'DG010222',`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` = '18',`total_price` = '5400',`etd` = '2023-11-23',`create_date` = '2023-11-21 11:38:14',`modify_date` = '2023-11-23 09:30:41',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110026556' and product_code = 'DG010222-02', `lunar_date` = '2023-10-09' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110026556' and product_code = 'ZP010152-01' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29185',`firm_id` = '8',`ordernumber` = 'M23110026556', `product_name` = '贈品-rercolte潔膚儀(顏色隨機)',`product_code` = 'ZP010152-01',`product_sn` = 'ZP010152',`product_spec` = '贈品-rercolte潔膚儀(顏色隨機)',`invoice_name` = '贈品-rercolte潔膚儀(顏色隨機)',`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` = '2023-11-23',`create_date` = '2023-11-21 11:38:14',`modify_date` = '2023-11-23 09:30:41',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110026556' and product_code = 'ZP010152-01', `lunar_date` = '2023-10-09' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110028254' and product_code = 'DG010213-01' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29206',`firm_id` = '8',`ordernumber` = 'M23110028254', `product_name` = '8結彌月提盒－香頌日光',`product_code` = 'DG010213-01',`product_sn` = 'DG010213',`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` = '46',`total_price` = '13800',`etd` = '2023-11-30',`create_date` = '2023-11-22 09:49:43',`modify_date` = '2023-11-23 10:30:18',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110028254' and product_code = 'DG010213-01', `lunar_date` = '2023-10-10' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110028254' and product_code = 'ZP010152-01' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29206',`firm_id` = '8',`ordernumber` = 'M23110028254', `product_name` = '贈品-rercolte潔膚儀(顏色隨機)',`product_code` = 'ZP010152-01',`product_sn` = 'ZP010152',`product_spec` = '贈品-rercolte潔膚儀(顏色隨機)',`invoice_name` = '贈品-rercolte潔膚儀(顏色隨機)',`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` = '2023-11-30',`create_date` = '2023-11-22 09:49:43',`modify_date` = '2023-11-23 10:30:18',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110028254' and product_code = 'ZP010152-01', `lunar_date` = '2023-10-10' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110028254' and product_code = '40009' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29206',`firm_id` = '8',`ordernumber` = 'M23110028254', `product_name` = '運費',`product_code` = '40009',`product_sn` = '40000',`product_spec` = '80運費',`invoice_name` = '80運費',`listprice` = '80',`sellingprice` = '80',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '240',`etd` = '2023-11-30',`create_date` = '2023-11-22 09:49:43',`modify_date` = '2023-11-23 10:30:18',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110028254' and product_code = '40009', `lunar_date` = '2023-10-10' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110028550' and product_code = 'DG010213-01' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29209',`firm_id` = '8',`ordernumber` = 'M23110028550', `product_name` = '8結彌月提盒－香頌日光',`product_code` = 'DG010213-01',`product_sn` = 'DG010213',`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` = '5',`total_price` = '1500',`etd` = '2023-11-30',`create_date` = '2023-11-22 14:49:31',`modify_date` = '2023-11-23 09:53:55',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110028550' and product_code = 'DG010213-01', `lunar_date` = '2023-10-10' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110028764' and product_code = 'DG010203-01' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29211',`firm_id` = '8',`ordernumber` = 'M23110028764', `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` = '66',`total_price` = '19800',`etd` = '2023-12-01',`create_date` = '2023-11-22 16:12:19',`modify_date` = '2023-11-23 09:25:39',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110028764' and product_code = 'DG010203-01', `lunar_date` = '2023-10-10' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110028764' and product_code = 'ZP010152-01' 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29211',`firm_id` = '8',`ordernumber` = 'M23110028764', `product_name` = '贈品-rercolte潔膚儀(顏色隨機)',`product_code` = 'ZP010152-01',`product_sn` = 'ZP010152',`product_spec` = '贈品-rercolte潔膚儀(顏色隨機)',`invoice_name` = '贈品-rercolte潔膚儀(顏色隨機)',`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` = '2023-12-01',`create_date` = '2023-11-22 16:12:19',`modify_date` = '2023-11-23 09:25:39',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110028764' and product_code = 'ZP010152-01', `lunar_date` = '2023-10-10' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'B23110028953' and product_code = 'DG0103138-03' 2023-11-23 10:40:25 -- == 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,'29213','11','B23110028953','小王子彌月試吃禮盒組','DG0103138-03','DG0103138','原味+咖啡','禮盒-小王子(藍)【原味+咖啡】(試吃)','500','500','0','1','0','0','1','0.0','1','500','2023-11-24','2023-11-23 09:05:50','2023-11-23 10:40:25',null,'1','2023-10-11') 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29213',`firm_id` = '11',`ordernumber` = 'B23110028953', `product_name` = '小王子彌月試吃禮盒組',`product_code` = 'DG0103138-03',`product_sn` = 'DG0103138',`product_spec` = '原味+咖啡',`invoice_name` = '禮盒-小王子(藍)【原味+咖啡】(試吃)',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '1',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:05:50',`modify_date` = '2023-11-23 09:05:50',`points_use_id` = null,`item_status` = '1' where ordernumber = 'B23110028953' and product_code = 'DG0103138-03', `lunar_date` = '2023-10-11' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029022' and product_code = 'DG010203-01' 2023-11-23 10:40:25 -- == 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,'29214','8','M23110029022','【小王子聯名】閃耀星空8結彌月提盒','DG010203-01','DG010203','原味','提盒-小王子(藍)-40入原味','300','300','0','0','0','0','1','0.0','10','3000','2023-11-30','2023-11-23 09:14:33','2023-11-23 10:40:25',null,'1','2023-10-11') 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29214',`firm_id` = '8',`ordernumber` = 'M23110029022', `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` = '10',`total_price` = '3000',`etd` = '2023-11-30',`create_date` = '2023-11-23 09:14:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029022' and product_code = 'DG010203-01', `lunar_date` = '2023-10-11' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110028764RB' and product_code = 'DG010203-01' 2023-11-23 10:40:25 -- == 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,'29215','8','M23110028764RB','【小王子聯名】閃耀星空8結彌月提盒','DG010203-01','DG010203','原味','提盒-小王子(藍)-40入原味','300','300','0','0','0','0','1','0.0','66','19800','2023-12-01','2023-11-22 16:12:19','2023-11-23 10:40:25',null,'1','2023-10-10') 2023-11-23 10:40:25 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29215',`firm_id` = '8',`ordernumber` = 'M23110028764RB', `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` = '66',`total_price` = '19800',`etd` = '2023-12-01',`create_date` = '2023-11-22 16:12:19',`modify_date` = '2023-11-23 09:25:48',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110028764RB' and product_code = 'DG010203-01', `lunar_date` = '2023-10-10' 2023-11-23 10:40:25 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110028764RB' and product_code = 'ZP010152-01' 2023-11-23 10:40:25 -- == 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,'29215','8','M23110028764RB','贈品-rercolte潔膚儀(顏色隨機)','ZP010152-01','ZP010152','贈品-rercolte潔膚儀(顏色隨機)','贈品-rercolte潔膚儀(顏色隨機)','0','0','0','0','0','0','1','0.0','1','0','2023-12-01','2023-11-22 16:12:19','2023-11-23 10:40:25',null,'1','2023-10-10') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29215',`firm_id` = '8',`ordernumber` = 'M23110028764RB', `product_name` = '贈品-rercolte潔膚儀(顏色隨機)',`product_code` = 'ZP010152-01',`product_sn` = 'ZP010152',`product_spec` = '贈品-rercolte潔膚儀(顏色隨機)',`invoice_name` = '贈品-rercolte潔膚儀(顏色隨機)',`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` = '2023-12-01',`create_date` = '2023-11-22 16:12:19',`modify_date` = '2023-11-23 09:25:48',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110028764RB' and product_code = 'ZP010152-01', `lunar_date` = '2023-10-10' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029130' and product_code = 'DG010243-01' 2023-11-23 10:40:26 -- == 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,'29216','11','M23110029130','彌月試吃提盒－年輪','DG010243-01','DG010243','原味','提盒-彌月年輪-40入原味(試吃)','300','300','0','0','0','0','1','300.0','1','300','2023-11-24','2023-11-23 09:51:19','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29216',`firm_id` = '11',`ordernumber` = 'M23110029130', `product_name` = '彌月試吃提盒－年輪',`product_code` = 'DG010243-01',`product_sn` = 'DG010243',`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` = '1',`total_price` = '300',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:51:19',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029130' and product_code = 'DG010243-01', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029130' and product_code = 'DG010264-05' 2023-11-23 10:40:26 -- == 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,'29216','11','M23110029130','【SNOOPY聯名】美好食光-8結彌月提盒(試吃)','DG010264-05','DG010264','巧克力','提盒-彌月SNOOPY-40入巧克力(試吃)','300','300','0','0','0','0','1','0.0','1','300','2023-11-24','2023-11-23 09:51:19','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29216',`firm_id` = '11',`ordernumber` = 'M23110029130', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒(試吃)',`product_code` = 'DG010264-05',`product_sn` = 'DG010264',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月SNOOPY-40入巧克力(試吃)',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:51:19',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029130' and product_code = 'DG010264-05', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029130' and product_code = 'DG0103137-14' 2023-11-23 10:40:26 -- == 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,'29216','11','M23110029130','彌月試吃禮盒組（樂芙）','DG0103137-14','DG0103137','海苔+巧克力','禮盒-彌月樂芙【海苔+巧克力】(試吃)','500','500','0','0','0','0','1','500.0','1','500','2023-11-24','2023-11-23 09:51:19','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29216',`firm_id` = '11',`ordernumber` = 'M23110029130', `product_name` = '彌月試吃禮盒組（樂芙）',`product_code` = 'DG0103137-14',`product_sn` = 'DG0103137',`product_spec` = '海苔+巧克力',`invoice_name` = '禮盒-彌月樂芙【海苔+巧克力】(試吃)',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '500.0',`amount` = '1',`total_price` = '500',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:51:19',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029130' and product_code = 'DG0103137-14', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029130' and product_code = 'DG0103157-05' 2023-11-23 10:40:26 -- == 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,'29216','11','M23110029130','【SNOOPY聯名】友你相伴-8結彌月禮盒(試吃)','DG0103157-05','DG0103157','原味+巧克力','禮盒-彌月SNOOPY【原味+巧克力】(試吃)','500','500','0','0','0','0','1','0.0','1','500','2023-11-24','2023-11-23 09:51:19','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29216',`firm_id` = '11',`ordernumber` = 'M23110029130', `product_name` = '【SNOOPY聯名】友你相伴-8結彌月禮盒(試吃)',`product_code` = 'DG0103157-05',`product_sn` = 'DG0103157',`product_spec` = '原味+巧克力',`invoice_name` = '禮盒-彌月SNOOPY【原味+巧克力】(試吃)',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2023-11-24',`create_date` = '2023-11-23 09:51:19',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029130' and product_code = 'DG0103157-05', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029254' and product_code = 'DG010263-02' 2023-11-23 10:40:26 -- == 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,'29217','8','M23110029254','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-02','DG010263','芝麻','提盒-彌月SNOOPY-40入芝麻','300','300','0','0','0','0','1','0.0','63','18900','2023-11-29','2023-11-23 10:10:49','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29217',`firm_id` = '8',`ordernumber` = 'M23110029254', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-02',`product_sn` = 'DG010263',`product_spec` = '芝麻',`invoice_name` = '提盒-彌月SNOOPY-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '63',`total_price` = '18900',`etd` = '2023-11-29',`create_date` = '2023-11-23 10:10:49',`modify_date` = '2023-11-23 10:20:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029254' and product_code = 'DG010263-02', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029254' and product_code = 'DG010263-04' 2023-11-23 10:40:26 -- == 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,'29217','8','M23110029254','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-04','DG010263','海苔','提盒-彌月SNOOPY-40入海苔','300','300','0','0','0','0','1','0.0','1','300','2023-11-29','2023-11-23 10:10:49','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29217',`firm_id` = '8',`ordernumber` = 'M23110029254', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-04',`product_sn` = 'DG010263',`product_spec` = '海苔',`invoice_name` = '提盒-彌月SNOOPY-40入海苔',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-11-29',`create_date` = '2023-11-23 10:10:49',`modify_date` = '2023-11-23 10:20:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029254' and product_code = 'DG010263-04', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029254' and product_code = 'DG010263-01' 2023-11-23 10:40:26 -- == 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,'29217','8','M23110029254','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-01','DG010263','原味','提盒-彌月SNOOPY-40入原味','300','300','0','0','0','0','1','0.0','1','300','2023-11-29','2023-11-23 10:10:49','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29217',`firm_id` = '8',`ordernumber` = 'M23110029254', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-01',`product_sn` = 'DG010263',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2023-11-29',`create_date` = '2023-11-23 10:10:49',`modify_date` = '2023-11-23 10:20:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029254' and product_code = 'DG010263-01', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029254' and product_code = 'ZP010152-01' 2023-11-23 10:40:26 -- == 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,'29217','8','M23110029254','贈品-rercolte潔膚儀(顏色隨機)','ZP010152-01','ZP010152','贈品-rercolte潔膚儀(顏色隨機)','贈品-rercolte潔膚儀(顏色隨機)','0','0','0','0','0','0','1','0.0','1','0','2023-11-29','2023-11-23 10:10:49','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29217',`firm_id` = '8',`ordernumber` = 'M23110029254', `product_name` = '贈品-rercolte潔膚儀(顏色隨機)',`product_code` = 'ZP010152-01',`product_sn` = 'ZP010152',`product_spec` = '贈品-rercolte潔膚儀(顏色隨機)',`invoice_name` = '贈品-rercolte潔膚儀(顏色隨機)',`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` = '2023-11-29',`create_date` = '2023-11-23 10:10:49',`modify_date` = '2023-11-23 10:20:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029254' and product_code = 'ZP010152-01', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029379' and product_code = 'DG010263-02' 2023-11-23 10:40:26 -- == 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,'29218','8','M23110029379','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-02','DG010263','芝麻','提盒-彌月SNOOPY-40入芝麻','300','300','0','0','0','0','1','0.0','27','8100','2023-12-06','2023-11-23 10:36:21','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29218',`firm_id` = '8',`ordernumber` = 'M23110029379', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-02',`product_sn` = 'DG010263',`product_spec` = '芝麻',`invoice_name` = '提盒-彌月SNOOPY-40入芝麻',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '27',`total_price` = '8100',`etd` = '2023-12-06',`create_date` = '2023-11-23 10:36:21',`modify_date` = '2023-11-23 10:37:16',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029379' and product_code = 'DG010263-02', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029379' and product_code = 'DG010263-01' 2023-11-23 10:40:26 -- == 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,'29218','8','M23110029379','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-01','DG010263','原味','提盒-彌月SNOOPY-40入原味','300','300','0','0','0','0','1','0.0','3','900','2023-12-06','2023-11-23 10:36:21','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29218',`firm_id` = '8',`ordernumber` = 'M23110029379', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-01',`product_sn` = 'DG010263',`product_spec` = '原味',`invoice_name` = '提盒-彌月SNOOPY-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '900',`etd` = '2023-12-06',`create_date` = '2023-11-23 10:36:21',`modify_date` = '2023-11-23 10:37:16',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029379' and product_code = 'DG010263-01', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029379' and product_code = 'DG010263-05' 2023-11-23 10:40:26 -- == 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,'29218','8','M23110029379','【SNOOPY聯名】美好食光-8結彌月提盒','DG010263-05','DG010263','巧克力','提盒-彌月SNOOPY-40入巧克力','300','300','0','0','0','0','1','0.0','6','1800','2023-12-06','2023-11-23 10:36:21','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29218',`firm_id` = '8',`ordernumber` = 'M23110029379', `product_name` = '【SNOOPY聯名】美好食光-8結彌月提盒',`product_code` = 'DG010263-05',`product_sn` = 'DG010263',`product_spec` = '巧克力',`invoice_name` = '提盒-彌月SNOOPY-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '6',`total_price` = '1800',`etd` = '2023-12-06',`create_date` = '2023-11-23 10:36:21',`modify_date` = '2023-11-23 10:37:16',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029379' and product_code = 'DG010263-05', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M23110029379' and product_code = 'ZP010152-01' 2023-11-23 10:40:26 -- == 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,'29218','8','M23110029379','贈品-rercolte潔膚儀(顏色隨機)','ZP010152-01','ZP010152','贈品-rercolte潔膚儀(顏色隨機)','贈品-rercolte潔膚儀(顏色隨機)','0','0','0','0','0','0','1','0.0','1','0','2023-12-06','2023-11-23 10:36:21','2023-11-23 10:40:26',null,'1','2023-10-11') 2023-11-23 10:40:26 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '29218',`firm_id` = '8',`ordernumber` = 'M23110029379', `product_name` = '贈品-rercolte潔膚儀(顏色隨機)',`product_code` = 'ZP010152-01',`product_sn` = 'ZP010152',`product_spec` = '贈品-rercolte潔膚儀(顏色隨機)',`invoice_name` = '贈品-rercolte潔膚儀(顏色隨機)',`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` = '2023-12-06',`create_date` = '2023-11-23 10:36:21',`modify_date` = '2023-11-23 10:37:16',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M23110029379' and product_code = 'ZP010152-01', `lunar_date` = '2023-10-11' 2023-11-23 10:40:26 -- == sync_order_detail end == 2023-11-23 10:40:26 -- == 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) = '2023-11-23' OR o.updated_at = '2023-11-23') and o.deleted_at is null 2023-11-23 10:40:26 -- == sync_order_detail start == 2023-11-23 10:40:26 -- start:2023-11-23,end:2023-11-23