2024-10-12 23:59:02 -- == sync_order start == 2024-10-12 23:59:02 -- start:2024-10-12,end:2024-10-12 2024-10-12 23:59:02 -- == select june1.order_list == SELECT l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-10-12%' OR l.modify_date like '2024-10-12%'; 2024-10-12 23:59:04 -- == sync omo_order_list == 2024-10-12 23:59:04 -- == update lake.omo_order_list == update omo_order_list set userId = '424728', process_status = '3', pay_status = '1', totalprice_after = '2400', lunar_date = '2024-09-06', invoice_status = '1',category_name = '美村門市訂單', category_id = '32' where ordernumber = 'S24100027322' 2024-10-12 23:59:04 -- == 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 ('184830','151208',1,'','','O24100039361','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','240','806','高雄市','前鎮區','806','高雄市','前鎮區','390','2024-10-12 01:03:30','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('389161','425445',1,'','','O24100039463','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','300','811','高雄市','楠梓區','811','高雄市','楠梓區','420','2024-10-12 01:03:38','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('389133','425417',1,'','','O24100039562','1','11','1','1','1','25122281','劉致瑩','0','0000-00-00','0','0','0','','150','30','1410','251','新北市','淡水區','251','新北市','淡水區','1530','2024-10-12 01:05:17','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('8633','7063',1,'','','O24100039632','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1370','420','台中市','豐原區','420','台中市','豐原區','1520','2024-10-12 02:44:25','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('388714','424999',1,'','','O24100039785','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','3600','238','新北市','樹林區','238','新北市','樹林區','3720','2024-10-12 06:24:03','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('389163','425447',1,'','','O24100039858','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1200','717','台南市','仁德區','708','台南市','安平區','1320','2024-10-12 07:22:49','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('316424','353527',1,'永康門市訂單','31','S24100039959','1','1','6','1','1','83599094','千附精密股份有限公司','0','2024-10-13','0','720','0','','0','0','14400','106','台北市','大安區','106','台北市','大安區','13680','2024-10-12 12:11:01','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('389200','425485',1,'','','O24100040082','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2490','807','高雄市','三民區','807','高雄市','三民區','2610','2024-10-12 12:43:29','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('371050','407559',1,'','','O24100040169','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','100','1140','200','基隆市','仁愛區','200','基隆市','仁愛區','1190','2024-10-12 13:05:11','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('388754','425039',1,'','','O24100040274','1','1','1','1','1','','','0','0000-00-00','0','0','0','','0','30','6750','830','高雄市','鳳山區','830','高雄市','鳳山區','6720','2024-10-12 14:17:18','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('167249','134374',1,'','','O24100040338','1','1','1','1','1','','','0','0000-00-00','1440','0','0','','0','0','29040','437','台中市','大甲區','437','台中市','大甲區','27600','2024-10-12 14:24:06','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('389243','425528',1,'','','O24100040438','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1750','220','新北市','板橋區','220','新北市','板橋區','1870','2024-10-12 14:46:04','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('136101','104430',1,'','','O24100040525','1','1','1','1','1','','','0','0000-00-00','0','0','0','','0','0','11250','508','彰化縣','和美鎮','508','彰化縣','和美鎮','11250','2024-10-12 14:58:12','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('347489','384211',1,'','','O24100040652','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','1370','514','彰化縣','溪湖鎮','514','彰化縣','溪湖鎮','1520','2024-10-12 15:23:13','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('387695','423990',1,'','','O24100040784','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','990','334','桃園市','八德區','334','桃園市','八德區','1110','2024-10-12 15:40:45','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('316481','353582',1,'','','O24100040828','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2880','702','台南市','南區','702','台南市','南區','3030','2024-10-12 16:39:36','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('389293','425578',1,'','','O24100040995','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2250','300','新竹市','北區','300','新竹市','北區','2370','2024-10-12 16:45:07','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('388475','424762',1,'','','O24100041069','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','30','4100','427','台中市','潭子區','427','台中市','潭子區','4220','2024-10-12 16:52:18','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('389296','425581',1,'','','O24100041186','1','1','1','1','1','86968161','萬振昌倉儲設備股份有限公司','0','0000-00-00','0','0','0','','0','0','5760','913','屏東縣','萬丹鄉','913','屏東縣','萬丹鄉','5760','2024-10-12 16:52:31','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('389330','425615',1,'','','O24100041266','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','690','710','台南市','永康區','710','台南市','永康區','810','2024-10-12 18:29:01','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('389298','425583',1,'','','O24100041355','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1370','220','新北市','板橋區','220','新北市','板橋區','1490','2024-10-12 19:11:16','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('388404','424691',1,'','','O24100041462','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','1370','806','高雄市','前鎮區','812','高雄市','小港區','1520','2024-10-12 19:56:42','2024-09-10') 2024-10-12 23:59:04 -- == 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 ('388404','424691',1,'','','O24100041548','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1370','806','高雄市','前鎮區','812','高雄市','小港區','1520','2024-10-12 20:36:24','2024-09-10') 2024-10-12 23:59:04 -- == sync_order end == 2024-10-12 23:59:04 -- == sync_order_detail start == 2024-10-12 23:59:04 -- start:2024-10-12,end:2024-10-12 2024-10-12 23:59:04 -- == sync omo_order_detail == 2024-10-12 23:59:04 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-10-12%' OR modify_date like '2024-10-12%' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100027322' and product_code = 'DG0105142-01' 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249591',`firm_id` = '8',`ordernumber` = 'S24100027322', `product_name` = '澎派蛋捲10入組(原味x1+咖啡x5+巧克力x4)',`product_code` = 'DG0105142-01',`product_sn` = 'DG0105142',`product_spec` = '32入原味蛋捲+32入咖啡蛋捲+32入咖啡蛋捲+32入咖啡蛋',`invoice_name` = '組合-32入(原味x1+咖啡x5+巧克力x4)',`listprice` = '2250',`sellingprice` = '2250',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '2250',`etd` = '2024-10-12',`create_date` = '2024-10-08 11:42:50',`modify_date` = '2024-10-12 12:05:47',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-06'where ordernumber = 'S24100027322' and product_code = 'DG0105142-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100039361' and product_code = 'DG010107-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249714','8','O24100039361','【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','1','1','0.0','1','240','2024-10-16','2024-10-12 01:03:30','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249714',`firm_id` = '8',`ordernumber` = 'O24100039361', `product_name` = '【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2024-10-16',`create_date` = '2024-10-12 01:03:30',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100039361' and product_code = 'DG010107-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100039463' and product_code = 'BP010184-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249715','8','O24100039463','SNOOPY盥洗收納包','BP010184-01','BP010184','SNOOPY盥洗收納包','SNOOPY盥洗收納包','300','300','0','0','0','0','1','0.0','1','300','2024-10-14','2024-10-12 01:03:38','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249715',`firm_id` = '8',`ordernumber` = 'O24100039463', `product_name` = 'SNOOPY盥洗收納包',`product_code` = 'BP010184-01',`product_sn` = 'BP010184',`product_spec` = 'SNOOPY盥洗收納包',`invoice_name` = 'SNOOPY盥洗收納包',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-10-14',`create_date` = '2024-10-12 01:03:38',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100039463' and product_code = 'BP010184-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100039562' and product_code = 'DG0105127-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249716','8','O24100039562','【官網限定】熱銷蛋捲6入組','DG0105127-01','DG0105127','原味x6+紅色提袋x2','組合-32入(原味x6)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-14','2024-10-12 01:05:17','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249716',`firm_id` = '8',`ordernumber` = 'O24100039562', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-01',`product_sn` = 'DG0105127',`product_spec` = '原味x6+紅色提袋x2',`invoice_name` = '組合-32入(原味x6)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-14',`create_date` = '2024-10-12 01:05:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100039562' and product_code = 'DG0105127-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100039562' and product_code = 'DG010404-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249716','8','O24100039562','紅色提袋','DG010404-01','DG010404','提袋/個','紅色提袋','10','10','0','0','0','0','1','0.0','4','40','2024-10-14','2024-10-12 01:05:17','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249716',`firm_id` = '8',`ordernumber` = 'O24100039562', `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` = '4',`total_price` = '40',`etd` = '2024-10-14',`create_date` = '2024-10-12 01:05:17',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100039562' and product_code = 'DG010404-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100039632' and product_code = 'DG0105127-305' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249717','8','O24100039632','【官網限定】熱銷蛋捲6入組','DG0105127-305','DG0105127','芝麻x2+咖啡+巧克力x2+阿薩姆紅茶+紅色提袋x2','組合-32入(芝麻x2+咖啡x1+巧克力x2+阿薩姆紅茶x1)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-14','2024-10-12 02:44:25','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249717',`firm_id` = '8',`ordernumber` = 'O24100039632', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-305',`product_sn` = 'DG0105127',`product_spec` = '芝麻x2+咖啡+巧克力x2+阿薩姆紅茶+紅色提袋x2',`invoice_name` = '組合-32入(芝麻x2+咖啡x1+巧克力x2+阿薩姆紅茶x1)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-14',`create_date` = '2024-10-12 02:44:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100039632' and product_code = 'DG0105127-305' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100039785' and product_code = 'DG010265-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249718','8','O24100039785','【SNOOPY 聯名】獨特心意-8結提盒','DG010265-01','DG010265','原味','提盒-SNOOPY(粉)-40入原味','300','300','0','0','0','0','1','0.0','12','3600','2024-10-14','2024-10-12 06:24:03','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249718',`firm_id` = '8',`ordernumber` = 'O24100039785', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-01',`product_sn` = 'DG010265',`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` = '12',`total_price` = '3600',`etd` = '2024-10-14',`create_date` = '2024-10-12 06:24:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100039785' and product_code = 'DG010265-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100039785' and product_code = 'ZP010146-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249718','8','O24100039785','贈品-南棗核桃糕分享包','ZP010146-01','ZP010146','一組','贈品-(紅袋)南棗核桃糕','0','0','0','0','0','0','1','0.0','1','0','2024-10-14','2024-10-12 06:24:03','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249718',`firm_id` = '8',`ordernumber` = 'O24100039785', `product_name` = '贈品-南棗核桃糕分享包',`product_code` = 'ZP010146-01',`product_sn` = 'ZP010146',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-14',`create_date` = '2024-10-12 06:24:03',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100039785' and product_code = 'ZP010146-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100039858' and product_code = 'DG0105121-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249719','8','O24100039858','【期間限定】復古紅提袋蛋捲組(32入蛋捲+復古提袋)','DG0105121-01','DG0105121','原味+復古紅提袋','組合-32入原味+［復古］提袋x1','400','400','0','0','0','1','1','0.0','3','1200','2024-10-14','2024-10-12 07:22:49','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249719',`firm_id` = '8',`ordernumber` = 'O24100039858', `product_name` = '【期間限定】復古紅提袋蛋捲組(32入蛋捲+復古提袋)',`product_code` = 'DG0105121-01',`product_sn` = 'DG0105121',`product_spec` = '原味+復古紅提袋',`invoice_name` = '組合-32入原味+［復古］提袋x1',`listprice` = '400',`sellingprice` = '400',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '1200',`etd` = '2024-10-14',`create_date` = '2024-10-12 07:22:49',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100039858' and product_code = 'DG0105121-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100039959' and product_code = 'DG010312-03' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249720','8','S24100039959','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','30','14400','2024-10-13','2024-10-12 12:11:01','2024-10-12 23:59:06',0,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249720',`firm_id` = '8',`ordernumber` = 'S24100039959', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '30',`total_price` = '14400',`etd` = '2024-10-13',`create_date` = '2024-10-12 12:11:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'S24100039959' and product_code = 'DG010312-03' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040082' and product_code = 'DG0105135-08' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249721','8','O24100040082','【官網限定】澎派蛋捲10入組','DG0105135-08','DG0105135','咖啡x5+阿薩姆紅茶x5','組合-32入(咖啡x5+阿薩姆紅茶x5)','2250','2250','0','0','0','1','1','0.0','1','2250','2024-10-14','2024-10-12 12:43:29','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249721',`firm_id` = '8',`ordernumber` = 'O24100040082', `product_name` = '【官網限定】澎派蛋捲10入組',`product_code` = 'DG0105135-08',`product_sn` = 'DG0105135',`product_spec` = '咖啡x5+阿薩姆紅茶x5',`invoice_name` = '組合-32入(咖啡x5+阿薩姆紅茶x5)',`listprice` = '2250',`sellingprice` = '2250',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '2250',`etd` = '2024-10-14',`create_date` = '2024-10-12 12:43:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040082' and product_code = 'DG0105135-08' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040082' and product_code = 'DG010107-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249721','8','O24100040082','【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','1','1','0.0','1','240','2024-10-14','2024-10-12 12:43:29','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249721',`firm_id` = '8',`ordernumber` = 'O24100040082', `product_name` = '【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2024-10-14',`create_date` = '2024-10-12 12:43:29',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040082' and product_code = 'DG010107-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040169' and product_code = 'DG010101-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249722','8','O24100040169','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-14','2024-10-12 13:05:11','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249722',`firm_id` = '8',`ordernumber` = 'O24100040169', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-14',`create_date` = '2024-10-12 13:05:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040169' and product_code = 'DG010101-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040169' and product_code = 'DG010101-02' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249722','8','O24100040169','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-14','2024-10-12 13:05:11','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249722',`firm_id` = '8',`ordernumber` = 'O24100040169', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-14',`create_date` = '2024-10-12 13:05:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040169' and product_code = 'DG010101-02' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040169' and product_code = '13656' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249722','8','O24100040169','8結蛋捲【紅提袋裝】','13656','13656','40入原味蛋捲','組合-40入原味+紅提袋','290','290','0','0','0','0','1','0.0','1','290','2024-10-14','2024-10-12 13:05:11','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249722',`firm_id` = '8',`ordernumber` = 'O24100040169', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13656',`product_sn` = '13656',`product_spec` = '40入原味蛋捲',`invoice_name` = '組合-40入原味+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '290',`etd` = '2024-10-14',`create_date` = '2024-10-12 13:05:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040169' and product_code = '13656' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040169' and product_code = '13657' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249722','8','O24100040169','8結蛋捲【紅提袋裝】','13657','13656','40入芝麻蛋捲','組合-40入芝麻+紅提袋','290','290','0','0','0','0','1','0.0','1','290','2024-10-14','2024-10-12 13:05:11','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249722',`firm_id` = '8',`ordernumber` = 'O24100040169', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13657',`product_sn` = '13656',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '組合-40入芝麻+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '290',`etd` = '2024-10-14',`create_date` = '2024-10-12 13:05:11',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040169' and product_code = '13657' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040274' and product_code = 'DG0105135-10' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249723','8','O24100040274','【官網限定】澎派蛋捲10入組','DG0105135-10','DG0105135','原味x2+芝麻x2+咖啡x2+海苔x2+巧克力x2','組合-32入(原味x2+芝麻x2+咖啡x2+海苔x2+巧克力x2)','2250','2250','0','0','0','1','1','0.0','1','2250','2024-10-31','2024-10-12 14:17:18','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249723',`firm_id` = '8',`ordernumber` = 'O24100040274', `product_name` = '【官網限定】澎派蛋捲10入組',`product_code` = 'DG0105135-10',`product_sn` = 'DG0105135',`product_spec` = '原味x2+芝麻x2+咖啡x2+海苔x2+巧克力x2',`invoice_name` = '組合-32入(原味x2+芝麻x2+咖啡x2+海苔x2+巧克力x2)',`listprice` = '2250',`sellingprice` = '2250',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '2250',`etd` = '2024-10-31',`create_date` = '2024-10-12 14:17:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040274' and product_code = 'DG0105135-10' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040274' and product_code = 'DG0105135-07' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249723','8','O24100040274','【官網限定】澎派蛋捲10入組','DG0105135-07','DG0105135','巧克力x5+阿薩姆紅茶x5','組合-32入(巧克力x5+阿薩姆紅茶x5)','2250','2250','0','0','0','1','1','0.0','2','4500','2024-10-31','2024-10-12 14:17:18','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249723',`firm_id` = '8',`ordernumber` = 'O24100040274', `product_name` = '【官網限定】澎派蛋捲10入組',`product_code` = 'DG0105135-07',`product_sn` = 'DG0105135',`product_spec` = '巧克力x5+阿薩姆紅茶x5',`invoice_name` = '組合-32入(巧克力x5+阿薩姆紅茶x5)',`listprice` = '2250',`sellingprice` = '2250',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '4500',`etd` = '2024-10-31',`create_date` = '2024-10-12 14:17:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040274' and product_code = 'DG0105135-07' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040274' and product_code = 'ZP010146-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249723','8','O24100040274','贈品-南棗核桃糕分享包','ZP010146-01','ZP010146','一組','贈品-(紅袋)南棗核桃糕','0','0','0','0','0','0','1','0.0','1','0','2024-10-31','2024-10-12 14:17:18','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249723',`firm_id` = '8',`ordernumber` = 'O24100040274', `product_name` = '贈品-南棗核桃糕分享包',`product_code` = 'ZP010146-01',`product_sn` = 'ZP010146',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-31',`create_date` = '2024-10-12 14:17:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040274' and product_code = 'ZP010146-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040338' and product_code = 'DG010107-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249724','8','O24100040338','【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','1','1','0.0','1','240','2024-11-04','2024-10-12 14:24:06','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249724',`firm_id` = '8',`ordernumber` = 'O24100040338', `product_name` = '【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2024-11-04',`create_date` = '2024-10-12 14:24:06',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040338' and product_code = 'DG010107-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040338' and product_code = 'DG0103148-14' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249724','8','O24100040338','金典8結禮盒','DG0103148-14','DG0103148','巧克力+海苔','禮盒-金典(紅)【海苔+巧克力】','480','480','0','0','0','0','1','0.0','60','28800','2024-11-04','2024-10-12 14:24:06','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249724',`firm_id` = '8',`ordernumber` = 'O24100040338', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-14',`product_sn` = 'DG0103148',`product_spec` = '巧克力+海苔',`invoice_name` = '禮盒-金典(紅)【海苔+巧克力】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '60',`total_price` = '28800',`etd` = '2024-11-04',`create_date` = '2024-10-12 14:24:06',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040338' and product_code = 'DG0103148-14' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040338' and product_code = 'ZP010529-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249724','8','O24100040338','贈品-南棗核桃糕分享包x8','ZP010529-01','ZP010529','一組','贈品-(紅袋)南棗核桃糕x8','0','0','0','0','0','0','1','0.0','1','0','2024-11-04','2024-10-12 14:24:06','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249724',`firm_id` = '8',`ordernumber` = 'O24100040338', `product_name` = '贈品-南棗核桃糕分享包x8',`product_code` = 'ZP010529-01',`product_sn` = 'ZP010529',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕x8',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-11-04',`create_date` = '2024-10-12 14:24:06',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040338' and product_code = 'ZP010529-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040438' and product_code = 'DG010312-03' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249725','8','O24100040438','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2024-10-14','2024-10-12 14:46:04','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249725',`firm_id` = '8',`ordernumber` = 'O24100040438', `product_name` = '【原味+咖啡】金8結禮盒',`product_code` = 'DG010312-03',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+咖啡】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-10-14',`create_date` = '2024-10-12 14:46:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040438' and product_code = 'DG010312-03' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040438' and product_code = 'DG010312-05' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249725','8','O24100040438','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-10-14','2024-10-12 14:46:04','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249725',`firm_id` = '8',`ordernumber` = 'O24100040438', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-10-14',`create_date` = '2024-10-12 14:46:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040438' and product_code = 'DG010312-05' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040438' and product_code = 'DG010206-01' 2024-10-12 23:59:06 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'249725','8','O24100040438','8結蛋捲【紅提盒裝】','DG010206-01','DG010206','原味','提盒-品牌(紅)-40入原味蛋捲','295','295','0','0','0','0','1','0.0','1','295','2024-10-14','2024-10-12 14:46:04','2024-10-12 23:59:06',null,'1','2024-09-10') 2024-10-12 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249725',`firm_id` = '8',`ordernumber` = 'O24100040438', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-01',`product_sn` = 'DG010206',`product_spec` = '原味',`invoice_name` = '提盒-品牌(紅)-40入原味蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-10-14',`create_date` = '2024-10-12 14:46:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040438' and product_code = 'DG010206-01' 2024-10-12 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040438' and product_code = 'DG010206-02' 2024-10-12 23:59:07 -- == 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,'249725','8','O24100040438','8結蛋捲【紅提盒裝】','DG010206-02','DG010206','芝麻','提盒-品牌(紅)-40入芝麻蛋捲','295','295','0','0','0','0','1','0.0','1','295','2024-10-14','2024-10-12 14:46:04','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249725',`firm_id` = '8',`ordernumber` = 'O24100040438', `product_name` = '8結蛋捲【紅提盒裝】',`product_code` = 'DG010206-02',`product_sn` = 'DG010206',`product_spec` = '芝麻',`invoice_name` = '提盒-品牌(紅)-40入芝麻蛋捲',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '295',`etd` = '2024-10-14',`create_date` = '2024-10-12 14:46:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040438' and product_code = 'DG010206-02' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040438' and product_code = 'LS010104-01' 2024-10-12 23:59:07 -- == 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,'249725','8','O24100040438','分享包-乳酪絲','LS010104-01','LS010104','45g原味乳酪絲','(藍袋)乳酪絲【原味】','200','200','0','0','0','0','1','0.0','1','200','2024-10-14','2024-10-12 14:46:04','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249725',`firm_id` = '8',`ordernumber` = 'O24100040438', `product_name` = '分享包-乳酪絲',`product_code` = 'LS010104-01',`product_sn` = 'LS010104',`product_spec` = '45g原味乳酪絲',`invoice_name` = '(藍袋)乳酪絲【原味】',`listprice` = '200',`sellingprice` = '200',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '200',`etd` = '2024-10-14',`create_date` = '2024-10-12 14:46:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040438' and product_code = 'LS010104-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040525' and product_code = 'DG0105135-07' 2024-10-12 23:59:07 -- == 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,'249726','8','O24100040525','【官網限定】澎派蛋捲10入組','DG0105135-07','DG0105135','巧克力x5+阿薩姆紅茶x5','組合-32入(巧克力x5+阿薩姆紅茶x5)','2250','2250','0','0','0','1','1','0.0','5','11250','2024-10-14','2024-10-12 14:58:12','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249726',`firm_id` = '8',`ordernumber` = 'O24100040525', `product_name` = '【官網限定】澎派蛋捲10入組',`product_code` = 'DG0105135-07',`product_sn` = 'DG0105135',`product_spec` = '巧克力x5+阿薩姆紅茶x5',`invoice_name` = '組合-32入(巧克力x5+阿薩姆紅茶x5)',`listprice` = '2250',`sellingprice` = '2250',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '11250',`etd` = '2024-10-14',`create_date` = '2024-10-12 14:58:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040525' and product_code = 'DG0105135-07' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040525' and product_code = 'ZP010524-01' 2024-10-12 23:59:07 -- == 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,'249726','8','O24100040525','贈品-南棗核桃糕分享包x3','ZP010524-01','ZP010524','一組','贈品-(紅袋)南棗核桃糕x3','0','0','0','0','0','0','1','0.0','1','0','2024-10-14','2024-10-12 14:58:12','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249726',`firm_id` = '8',`ordernumber` = 'O24100040525', `product_name` = '贈品-南棗核桃糕分享包x3',`product_code` = 'ZP010524-01',`product_sn` = 'ZP010524',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕x3',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-14',`create_date` = '2024-10-12 14:58:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040525' and product_code = 'ZP010524-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040652' and product_code = 'DG0105127-19' 2024-10-12 23:59:07 -- == 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,'249727','8','O24100040652','【官網限定】熱銷蛋捲6入組','DG0105127-19','DG0105127','原味x4+巧克力x2+紅色提袋x2','組合-32入(原味x4+巧克力x2)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-17','2024-10-12 15:23:13','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249727',`firm_id` = '8',`ordernumber` = 'O24100040652', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-19',`product_sn` = 'DG0105127',`product_spec` = '原味x4+巧克力x2+紅色提袋x2',`invoice_name` = '組合-32入(原味x4+巧克力x2)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-17',`create_date` = '2024-10-12 15:23:13',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040652' and product_code = 'DG0105127-19' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040784' and product_code = 'DG0105103-14' 2024-10-12 23:59:07 -- == 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,'249728','8','O24100040784','SNOOPY美好心意-蛋捲三入組','DG0105103-14','DG0105103','原味+海苔+巧克力','組合-32入(原味+海苔+巧克力)+SNOOPY美好提袋','990','990','0','0','0','1','1','0.0','1','990','2024-10-14','2024-10-12 15:40:45','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249728',`firm_id` = '8',`ordernumber` = 'O24100040784', `product_name` = 'SNOOPY美好心意-蛋捲三入組',`product_code` = 'DG0105103-14',`product_sn` = 'DG0105103',`product_spec` = '原味+海苔+巧克力',`invoice_name` = '組合-32入(原味+海苔+巧克力)+SNOOPY美好提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-10-14',`create_date` = '2024-10-12 15:40:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040784' and product_code = 'DG0105103-14' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040828' and product_code = 'DG010312-05' 2024-10-12 23:59:07 -- == 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,'249729','8','O24100040828','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','5','2400','2024-10-15','2024-10-12 16:39:36','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249729',`firm_id` = '8',`ordernumber` = 'O24100040828', `product_name` = '【原味+巧克力】金8結禮盒',`product_code` = 'DG010312-05',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '5',`total_price` = '2400',`etd` = '2024-10-15',`create_date` = '2024-10-12 16:39:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040828' and product_code = 'DG010312-05' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040828' and product_code = 'DG010312-01' 2024-10-12 23:59:07 -- == 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,'249729','8','O24100040828','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','1','480','2024-10-15','2024-10-12 16:39:36','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249729',`firm_id` = '8',`ordernumber` = 'O24100040828', `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` = '1',`total_price` = '480',`etd` = '2024-10-15',`create_date` = '2024-10-12 16:39:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040828' and product_code = 'DG010312-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100040995' and product_code = 'DG0105135-10' 2024-10-12 23:59:07 -- == 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,'249730','8','O24100040995','【官網限定】澎派蛋捲10入組','DG0105135-10','DG0105135','原味x2+芝麻x2+咖啡x2+海苔x2+巧克力x2','組合-32入(原味x2+芝麻x2+咖啡x2+海苔x2+巧克力x2)','2250','2250','0','0','0','1','1','0.0','1','2250','2024-10-31','2024-10-12 16:45:07','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249730',`firm_id` = '8',`ordernumber` = 'O24100040995', `product_name` = '【官網限定】澎派蛋捲10入組',`product_code` = 'DG0105135-10',`product_sn` = 'DG0105135',`product_spec` = '原味x2+芝麻x2+咖啡x2+海苔x2+巧克力x2',`invoice_name` = '組合-32入(原味x2+芝麻x2+咖啡x2+海苔x2+巧克力x2)',`listprice` = '2250',`sellingprice` = '2250',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '2250',`etd` = '2024-10-31',`create_date` = '2024-10-12 16:45:07',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100040995' and product_code = 'DG0105135-10' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041069' and product_code = 'DG0103188-09' 2024-10-12 23:59:07 -- == 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,'249731','8','O24100041069','【SNOOPY 聯名】美好探尋-8結禮盒','DG0103188-09','DG0103188','原味蛋捲,巧克力蛋捲','禮盒-SNOOPY(橘)【原味+巧克力】','500','500','0','0','0','0','1','0.0','1','500','2024-10-14','2024-10-12 16:52:18','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249731',`firm_id` = '8',`ordernumber` = 'O24100041069', `product_name` = '【SNOOPY 聯名】美好探尋-8結禮盒',`product_code` = 'DG0103188-09',`product_sn` = 'DG0103188',`product_spec` = '原味蛋捲,巧克力蛋捲',`invoice_name` = '禮盒-SNOOPY(橘)【原味+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '500',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041069' and product_code = 'DG0103188-09' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041069' and product_code = 'DG010527-03' 2024-10-12 23:59:07 -- == 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,'249731','8','O24100041069','8結蛋捲【小禮袋裝】','DG010527-03','DG010527','40入咖啡蛋捲','組合-40入咖啡+8結小禮袋','290','290','0','0','0','0','1','0.0','2','580','2024-10-14','2024-10-12 16:52:18','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249731',`firm_id` = '8',`ordernumber` = 'O24100041069', `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` = '2',`total_price` = '580',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041069' and product_code = 'DG010527-03' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041069' and product_code = 'DG010527-05' 2024-10-12 23:59:07 -- == 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,'249731','8','O24100041069','8結蛋捲【小禮袋裝】','DG010527-05','DG010527','40入巧克力蛋捲','組合-40入巧克力+8結小禮袋','290','290','0','0','0','0','1','0.0','3','870','2024-10-14','2024-10-12 16:52:18','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249731',`firm_id` = '8',`ordernumber` = 'O24100041069', `product_name` = '8結蛋捲【小禮袋裝】',`product_code` = 'DG010527-05',`product_sn` = 'DG010527',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '組合-40入巧克力+8結小禮袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '870',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041069' and product_code = 'DG010527-05' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041069' and product_code = 'DG010527-02' 2024-10-12 23:59:07 -- == 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,'249731','8','O24100041069','8結蛋捲【小禮袋裝】','DG010527-02','DG010527','40入芝麻蛋捲','組合-40入芝麻+8結小禮袋','290','290','0','0','0','0','1','0.0','3','870','2024-10-14','2024-10-12 16:52:18','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249731',`firm_id` = '8',`ordernumber` = 'O24100041069', `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` = '2024-10-14',`create_date` = '2024-10-12 16:52:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041069' and product_code = 'DG010527-02' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041069' and product_code = 'DG010107-01' 2024-10-12 23:59:07 -- == 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,'249731','8','O24100041069','【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','1','1','0.0','3','720','2024-10-14','2024-10-12 16:52:18','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249731',`firm_id` = '8',`ordernumber` = 'O24100041069', `product_name` = '【限定口味】阿薩姆紅茶蛋捲(32入蛋捲x1)',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '720',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041069' and product_code = 'DG010107-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041069' and product_code = 'DG010101-01' 2024-10-12 23:59:07 -- == 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,'249731','8','O24100041069','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-14','2024-10-12 16:52:18','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249731',`firm_id` = '8',`ordernumber` = 'O24100041069', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041069' and product_code = 'DG010101-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041069' and product_code = 'DG010101-03' 2024-10-12 23:59:07 -- == 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,'249731','8','O24100041069','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-10-14','2024-10-12 16:52:18','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249731',`firm_id` = '8',`ordernumber` = 'O24100041069', `product_name` = '極上咖啡蛋捲',`product_code` = 'DG010101-03',`product_sn` = 'DG010101',`product_spec` = '咖啡',`invoice_name` = '40入咖啡蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041069' and product_code = 'DG010101-03' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041069' and product_code = 'ZP010146-01' 2024-10-12 23:59:07 -- == 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,'249731','8','O24100041069','贈品-南棗核桃糕分享包','ZP010146-01','ZP010146','一組','贈品-(紅袋)南棗核桃糕','0','0','0','0','0','0','1','0.0','1','0','2024-10-14','2024-10-12 16:52:18','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249731',`firm_id` = '8',`ordernumber` = 'O24100041069', `product_name` = '贈品-南棗核桃糕分享包',`product_code` = 'ZP010146-01',`product_sn` = 'ZP010146',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041069' and product_code = 'ZP010146-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'DG0105127-153' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','【官網限定】熱銷蛋捲6入組','DG0105127-153','DG0105127','原味+芝麻x2+海苔x2+巧克力+紅色提袋x2','組合-32入(原味x1+芝麻x2+海苔x2+巧克力x1)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-153',`product_sn` = 'DG0105127',`product_spec` = '原味+芝麻x2+海苔x2+巧克力+紅色提袋x2',`invoice_name` = '組合-32入(原味x1+芝麻x2+海苔x2+巧克力x1)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'DG0105127-153' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'GG010110-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','手工腰果脆糖分享包','GG010110-01','GG010110','一組','手工腰果脆糖100g','270','270','0','0','0','0','1','0.0','2','540','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '手工腰果脆糖分享包',`product_code` = 'GG010110-01',`product_sn` = 'GG010110',`product_spec` = '一組',`invoice_name` = '手工腰果脆糖100g',`listprice` = '270',`sellingprice` = '270',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '540',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'GG010110-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'LS010124-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','韓式梅子海苔(純素)','LS010124-01','LS010124','韓式梅子海苔','韓式梅子海苔','150','150','0','0','0','0','1','0.0','3','450','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '韓式梅子海苔(純素)',`product_code` = 'LS010124-01',`product_sn` = 'LS010124',`product_spec` = '韓式梅子海苔',`invoice_name` = '韓式梅子海苔',`listprice` = '150',`sellingprice` = '150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '3',`total_price` = '450',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'LS010124-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'LS010101-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','分享包-無糖芒果乾','LS010101-01','LS010101','180g芒果乾分享包','(紅袋)芒果乾','360','360','0','0','0','0','1','0.0','2','720','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '分享包-無糖芒果乾',`product_code` = 'LS010101-01',`product_sn` = 'LS010101',`product_spec` = '180g芒果乾分享包',`invoice_name` = '(紅袋)芒果乾',`listprice` = '360',`sellingprice` = '360',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '720',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'LS010101-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'TG010106-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','分享包-黑曜芝麻糕','TG010106-01','TG010106','25入芝麻糕分享包','(紅袋)芝麻糕','300','300','0','0','0','0','1','0.0','2','600','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '分享包-黑曜芝麻糕',`product_code` = 'TG010106-01',`product_sn` = 'TG010106',`product_spec` = '25入芝麻糕分享包',`invoice_name` = '(紅袋)芝麻糕',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '600',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'TG010106-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'LS010103-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','厚切椒鹽海苔(純素)','LS010103-01','LS010103','椒鹽海苔40g','椒鹽海苔片','150','150','0','0','0','0','1','0.0','2','300','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '厚切椒鹽海苔(純素)',`product_code` = 'LS010103-01',`product_sn` = 'LS010103',`product_spec` = '椒鹽海苔40g',`invoice_name` = '椒鹽海苔片',`listprice` = '150',`sellingprice` = '150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '300',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'LS010103-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'LS010143-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','香酥岩烤海苔(純素)','LS010143-01','LS010143','一組','香酥岩烤海苔','150','150','0','0','0','0','1','0.0','2','300','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '香酥岩烤海苔(純素)',`product_code` = 'LS010143-01',`product_sn` = 'LS010143',`product_spec` = '一組',`invoice_name` = '香酥岩烤海苔',`listprice` = '150',`sellingprice` = '150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '300',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'LS010143-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'LS010135-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','無籽梅肉','LS010135-01','LS010135','一組','(盒)無籽梅肉','255','255','0','0','0','0','1','0.0','2','510','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '無籽梅肉',`product_code` = 'LS010135-01',`product_sn` = 'LS010135',`product_spec` = '一組',`invoice_name` = '(盒)無籽梅肉',`listprice` = '255',`sellingprice` = '255',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '510',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'LS010135-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'ZP010146-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','贈品-南棗核桃糕分享包','ZP010146-01','ZP010146','一組','贈品-(紅袋)南棗核桃糕','0','0','0','0','0','0','1','0.0','1','0','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '贈品-南棗核桃糕分享包',`product_code` = 'ZP010146-01',`product_sn` = 'ZP010146',`product_spec` = '一組',`invoice_name` = '贈品-(紅袋)南棗核桃糕',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'ZP010146-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'FL010103-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','[加購]加購－一口鳳梅酥','FL010103-01','FL010103','-','加購-(盒)鳳梅酥','185','185','1','1','185','0','0','0.0','1','185','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '[加購]加購－一口鳳梅酥',`product_code` = 'FL010103-01',`product_sn` = 'FL010103',`product_spec` = '-',`invoice_name` = '加購-(盒)鳳梅酥',`listprice` = '185',`sellingprice` = '185',`isadd` = '1',`isbaby` = '1',`addprice` = '185',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '185',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'FL010103-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'FL010104-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','[加購]加購－一口鳳梨酥','FL010104-01','FL010104','-','加購-(盒)鳳梨酥','155','155','1','1','155','0','0','0.0','1','155','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '[加購]加購－一口鳳梨酥',`product_code` = 'FL010104-01',`product_sn` = 'FL010104',`product_spec` = '-',`invoice_name` = '加購-(盒)鳳梨酥',`listprice` = '155',`sellingprice` = '155',`isadd` = '1',`isbaby` = '1',`addprice` = '155',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '155',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'FL010104-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'GG010104-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','[加購]加購-義式皇家黑松露腰果','GG010104-01','GG010104','-','加購-(盒)堅果【腰果】','180','180','1','1','180','0','0','0.0','1','180','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '[加購]加購-義式皇家黑松露腰果',`product_code` = 'GG010104-01',`product_sn` = 'GG010104',`product_spec` = '-',`invoice_name` = '加購-(盒)堅果【腰果】',`listprice` = '180',`sellingprice` = '180',`isadd` = '1',`isbaby` = '1',`addprice` = '180',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '180',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'GG010104-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'GG010105-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','[加購]加購-義式皇家黑松露杏仁果','GG010105-01','GG010105','-','加購-(盒)堅果【杏仁果】','180','180','1','1','180','0','0','0.0','1','180','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '[加購]加購-義式皇家黑松露杏仁果',`product_code` = 'GG010105-01',`product_sn` = 'GG010105',`product_spec` = '-',`invoice_name` = '加購-(盒)堅果【杏仁果】',`listprice` = '180',`sellingprice` = '180',`isadd` = '1',`isbaby` = '1',`addprice` = '180',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '180',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'GG010105-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041186' and product_code = 'GG010106-01' 2024-10-12 23:59:07 -- == 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,'249732','8','O24100041186','[加購]加購-義式皇家黑松露夏威夷果','GG010106-01','GG010106','-','加購-(盒)堅果【夏威夷果】','270','270','1','1','270','0','0','0.0','1','270','2024-10-14','2024-10-12 16:52:31','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249732',`firm_id` = '8',`ordernumber` = 'O24100041186', `product_name` = '[加購]加購-義式皇家黑松露夏威夷果',`product_code` = 'GG010106-01',`product_sn` = 'GG010106',`product_spec` = '-',`invoice_name` = '加購-(盒)堅果【夏威夷果】',`listprice` = '270',`sellingprice` = '270',`isadd` = '1',`isbaby` = '1',`addprice` = '270',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '270',`etd` = '2024-10-14',`create_date` = '2024-10-12 16:52:31',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041186' and product_code = 'GG010106-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041266' and product_code = 'DG010265-01' 2024-10-12 23:59:07 -- == 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,'249733','8','O24100041266','【SNOOPY 聯名】獨特心意-8結提盒','DG010265-01','DG010265','原味','提盒-SNOOPY(粉)-40入原味','300','300','0','0','0','0','1','0.0','1','300','2024-10-14','2024-10-12 18:29:01','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249733',`firm_id` = '8',`ordernumber` = 'O24100041266', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-01',`product_sn` = 'DG010265',`product_spec` = '原味',`invoice_name` = '提盒-SNOOPY(粉)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-10-14',`create_date` = '2024-10-12 18:29:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041266' and product_code = 'DG010265-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041266' and product_code = 'BP010179-01' 2024-10-12 23:59:07 -- == 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,'249733','8','O24100041266','[加購]加購-SNOOPY美好提袋','BP010179-01','BP010179','-','加購-SNOOPY美好提袋','390','390','1','1','390','0','0','0.0','1','390','2024-10-14','2024-10-12 18:29:01','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249733',`firm_id` = '8',`ordernumber` = 'O24100041266', `product_name` = '[加購]加購-SNOOPY美好提袋',`product_code` = 'BP010179-01',`product_sn` = 'BP010179',`product_spec` = '-',`invoice_name` = '加購-SNOOPY美好提袋',`listprice` = '390',`sellingprice` = '390',`isadd` = '1',`isbaby` = '1',`addprice` = '390',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '390',`etd` = '2024-10-14',`create_date` = '2024-10-12 18:29:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041266' and product_code = 'BP010179-01' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041355' and product_code = 'DG0105127-194' 2024-10-12 23:59:07 -- == 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,'249734','8','O24100041355','【官網限定】熱銷蛋捲6入組','DG0105127-194','DG0105127','原味+芝麻+巧克力x2+阿薩姆紅茶x2+紅色提袋x2','組合-32入(原味x1+芝麻x1+巧克力x2+阿薩姆紅茶x2)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-17','2024-10-12 19:11:16','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249734',`firm_id` = '8',`ordernumber` = 'O24100041355', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-194',`product_sn` = 'DG0105127',`product_spec` = '原味+芝麻+巧克力x2+阿薩姆紅茶x2+紅色提袋x2',`invoice_name` = '組合-32入(原味x1+芝麻x1+巧克力x2+阿薩姆紅茶x2)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-17',`create_date` = '2024-10-12 19:11:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041355' and product_code = 'DG0105127-194' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041462' and product_code = 'DG0105127-71' 2024-10-12 23:59:07 -- == 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,'249735','8','O24100041462','【官網限定】熱銷蛋捲6入組','DG0105127-71','DG0105127','原味x2+芝麻x2+阿薩姆紅茶x2+紅色提袋x2','組合-32入(原味x2+芝麻x2+阿薩姆紅茶x2)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-14','2024-10-12 19:56:42','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249735',`firm_id` = '8',`ordernumber` = 'O24100041462', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-71',`product_sn` = 'DG0105127',`product_spec` = '原味x2+芝麻x2+阿薩姆紅茶x2+紅色提袋x2',`invoice_name` = '組合-32入(原味x2+芝麻x2+阿薩姆紅茶x2)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-14',`create_date` = '2024-10-12 19:56:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041462' and product_code = 'DG0105127-71' 2024-10-12 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24100041548' and product_code = 'DG0105127-71' 2024-10-12 23:59:07 -- == 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,'249736','8','O24100041548','【官網限定】熱銷蛋捲6入組','DG0105127-71','DG0105127','原味x2+芝麻x2+阿薩姆紅茶x2+紅色提袋x2','組合-32入(原味x2+芝麻x2+阿薩姆紅茶x2)+紅色提袋x2','1370','1370','0','0','0','1','1','0.0','1','1370','2024-10-14','2024-10-12 20:36:24','2024-10-12 23:59:07',null,'1','2024-09-10') 2024-10-12 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '249736',`firm_id` = '8',`ordernumber` = 'O24100041548', `product_name` = '【官網限定】熱銷蛋捲6入組',`product_code` = 'DG0105127-71',`product_sn` = 'DG0105127',`product_spec` = '原味x2+芝麻x2+阿薩姆紅茶x2+紅色提袋x2',`invoice_name` = '組合-32入(原味x2+芝麻x2+阿薩姆紅茶x2)+紅色提袋x2',`listprice` = '1370',`sellingprice` = '1370',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1370',`etd` = '2024-10-14',`create_date` = '2024-10-12 20:36:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-09-10'where ordernumber = 'O24100041548' and product_code = 'DG0105127-71' 2024-10-12 23:59:07 -- == sync_order_detail end == 2024-10-12 23:59:07 -- == sync_order start == 2024-10-12 23:59:07 -- start:2024-10-12,end:2024-10-12 2024-10-12 23:59:07 -- == select june1.order_list == select l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-10-12%' OR l.modify_date like '2024-10-12%'; 2024-10-12 23:59:08 -- == sync omo_order_list == 2024-10-12 23:59:08 -- == sync_order end == 2024-10-12 23:59:08 -- == sync_order_detail start == 2024-10-12 23:59:08 -- start:2024-10-12,end:2024-10-12 2024-10-12 23:59:08 -- == sync omo_order_detail == 2024-10-12 23:59:08 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-10-12%' OR modify_date like '2024-10-12%' 2024-10-12 23:59:08 -- == sync_order_detail end == 2024-10-12 23:59:08 -- == select one.order_list == SELECT o.code,o.pay_status,o.order_status,o.user_id,o.pay_method_id,o.activity_freight_id,o.freight_fee,o.items_total,o.total,DATE(o.shipped_at) as shipped_at,o.created_at as create_date, inv.company_number,inv.company_title,inv.invoice_status, cust.zipcode,cust.county,cust.district, rec.zipcode as recipientzip,rec.county as recipientaddresscity,rec.district as recipientaddressarea, af.type as freight_type FROM `orders` o LEFT JOIN systemlead_invoices inv on o.id = inv.order_id LEFT JOIN order_customers cust on o.id = cust.order_id LEFT JOIN order_receivers rec on o.id = rec.order_id LEFT JOIN activity_freights af on o.activity_freight_id = af.id WHERE (DATE(o.created_at) = '2024-10-12' OR o.updated_at = '2024-10-12') and o.deleted_at is null 2024-10-12 23:59:08 -- == sync_order_detail start == 2024-10-12 23:59:08 -- start:2024-10-12,end:2024-10-12 2024-10-12 23:59:08 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2024-10-12 23:59:09 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2024-10-12 23:59:13 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2024-10-12%';