2024-11-02 23:59:02 -- == sync_order start == 2024-11-02 23:59:02 -- start:2024-11-02,end:2024-11-02 2024-11-02 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-11-02%' OR l.modify_date like '2024-11-02%'; 2024-11-02 23:59:03 -- == sync omo_order_list == 2024-11-02 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '0', process_status = '3', pay_status = '1', totalprice_after = '45428', lunar_date = '2024-09-19', invoice_status = '1',category_name = '迪化門市訂單', category_id = '43' where ordernumber = 'S24100065761RB' 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392296','428556',1,'','','O24110002518','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','30','900','815','高雄市','大社區','815','高雄市','大社區','1020','2024-11-02 00:11:41','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392296','428556',1,'','','O24110002652','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','900','815','高雄市','大社區','815','高雄市','大社區','1020','2024-11-02 00:15:50','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('127418','95961',1,'','','O24110002742','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','560','632','雲林縣','虎尾鎮','632','雲林縣','虎尾鎮','710','2024-11-02 01:02:49','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392302','428562',1,'','','O24110002870','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','300','302','新竹縣','竹北市','302','新竹縣','竹北市','420','2024-11-02 08:23:08','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('384716','421044',1,'','','O24110002936','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2360','813','高雄市','左營區','813','高雄市','左營區','2510','2024-11-02 08:45:46','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392304','428564',1,'','','O24110003025','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1170','840','高雄市','大樹區','840','高雄市','大樹區','1290','2024-11-02 09:42:44','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392035','428300',1,'','','O24110003138','1','1','1','1','1','13539974','元生國小','0','0000-00-00','0','0','0','','0','0','6380','320','桃園市','中壢區','320','桃園市','中壢區','6380','2024-11-02 09:47:45','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392320','428580',1,'','','O24110003270','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','400','630','雲林縣','斗南鎮','630','雲林縣','斗南鎮','520','2024-11-02 11:55:43','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('174674','141513',1,'','','O24110003396','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1160','110','台北市','信義區','110','台北市','信義區','1310','2024-11-02 12:08:36','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392347','428606',1,'','','O24110003495','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2475','434','台中市','龍井區','434','台中市','龍井區','2595','2024-11-02 13:47:34','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('81742','0',1,'永康當日宅配','19','S24110003566','1','1','7','1','3','','','1','2024-11-02','0','0','0','','250','0','3360','110','台北市','信義區','110','台北市','信義區','3610','2024-11-02 14:14:12','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392365','428624',1,'','','O24110003665','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','3080','812','高雄市','小港區','831','高雄市','大寮區','3200','2024-11-02 14:54:59','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('313471','350627',1,'','','O24110003752','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2800','105','台北市','松山區','950','台東縣','台東市','2950','2024-11-02 15:09:22','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392410','428669',1,'','','O24110003824','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2100','330','桃園市','桃園區','330','桃園市','桃園區','2250','2024-11-02 16:29:28','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392298','428558',1,'','','O24110003976','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1120','436','台中市','清水區','436','台中市','清水區','1240','2024-11-02 17:31:13','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('332250','369147',1,'','','O24110004060','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','100','1930','811','高雄市','楠梓區','811','高雄市','楠梓區','1980','2024-11-02 17:59:33','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392442','428701',1,'','','O24110004167','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','770','812','高雄市','小港區','812','高雄市','小港區','890','2024-11-02 18:05:19','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392430','428689',1,'','','O24110004230','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','4200','242','新北市','新莊區','220','新北市','板橋區','4320','2024-11-02 18:10:04','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('276193','313770',1,'','','O24110004373','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','960','900','屏東縣','屏東市','900','屏東縣','屏東市','1110','2024-11-02 18:56:01','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('121941','90755',1,'','','O24110004491','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','100','1080','632','雲林縣','虎尾鎮','632','雲林縣','虎尾鎮','1130','2024-11-02 19:24:54','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392430','428689',1,'','','O24110004511','1','1','1','1','1','','','0','0000-00-00','0','0','0','','0','30','6600','242','新北市','新莊區','220','新北市','板橋區','6570','2024-11-02 19:41:21','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392461','428720',1,'','','O24110004655','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','900','821','高雄市','路竹區','821','高雄市','路竹區','1020','2024-11-02 19:42:55','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('385575','421896',1,'','','O24110004721','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1660','238','新北市','樹林區','238','新北市','樹林區','1810','2024-11-02 20:12:58','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392465','428724',1,'','','O24110004896','1','11','1','0','0','','','0','0000-00-00','0','0','0','','150','30','825','103','台北市','大同區','103','台北市','大同區','945','2024-11-02 21:09:24','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392467','428726',1,'','','O24110004978','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','480','806','高雄市','前鎮區','806','高雄市','前鎮區','600','2024-11-02 22:11:25','2024-10-02') 2024-11-02 23:59:03 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('392468','428727',1,'','','O24110005055','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2950','330','桃園市','桃園區','330','桃園市','桃園區','3100','2024-11-02 22:26:21','2024-10-02') 2024-11-02 23:59:03 -- == sync_order end == 2024-11-02 23:59:03 -- == sync_order_detail start == 2024-11-02 23:59:03 -- start:2024-11-02,end:2024-11-02 2024-11-02 23:59:03 -- == sync omo_order_detail == 2024-11-02 23:59:03 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-11-02%' OR modify_date like '2024-11-02%' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100065761RB' and product_code = '13656' 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250017',`firm_id` = '8',`ordernumber` = 'S24100065761RB', `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` = '165',`total_price` = '47850',`etd` = '2024-11-02',`create_date` = '2024-10-20 16:12:27',`modify_date` = '2024-11-02 18:27:50',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-18'where ordernumber = 'S24100065761RB' and product_code = '13656' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100065761RB' and product_code = 'BP010189-01' 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250017',`firm_id` = '8',`ordernumber` = 'S24100065761RB', `product_name` = '贈品-SNOOPY面紙套',`product_code` = 'BP010189-01',`product_sn` = 'BP010189',`product_spec` = '贈品-SNOOPY面紙套',`invoice_name` = '贈品-SNOOPY面紙套',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '12',`total_price` = '0',`etd` = '2024-11-02',`create_date` = '2024-10-20 16:12:27',`modify_date` = '2024-11-02 18:27:50',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-18'where ordernumber = 'S24100065761RB' and product_code = 'BP010189-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24100065761RB' and product_code = 'BP010183-01' 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250017',`firm_id` = '8',`ordernumber` = 'S24100065761RB', `product_name` = '贈品-SNOOPY飲料提袋',`product_code` = 'BP010183-01',`product_sn` = 'BP010183',`product_spec` = '贈品-SNOOPY飲料提袋',`invoice_name` = '贈品-SNOOPY飲料提袋',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '0',`etd` = '2024-11-02',`create_date` = '2024-10-20 16:12:27',`modify_date` = '2024-11-02 18:27:50',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-09-18'where ordernumber = 'S24100065761RB' and product_code = 'BP010183-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110002518' and product_code = 'LS010143-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250314','8','O24110002518','香酥岩烤海苔(純素)','LS010143-01','LS010143','一組','香酥岩烤海苔','150','150','0','0','0','0','1','0.0','6','900','2024-11-05','2024-11-02 00:11:41','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250314',`firm_id` = '8',`ordernumber` = 'O24110002518', `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` = '6',`total_price` = '900',`etd` = '2024-11-05',`create_date` = '2024-11-02 00:11:41',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110002518' and product_code = 'LS010143-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110002652' and product_code = 'LS010143-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250315','8','O24110002652','香酥岩烤海苔(純素)','LS010143-01','LS010143','一組','香酥岩烤海苔','150','150','0','0','0','0','1','0.0','6','900','2024-11-05','2024-11-02 00:15:50','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250315',`firm_id` = '8',`ordernumber` = 'O24110002652', `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` = '6',`total_price` = '900',`etd` = '2024-11-05',`create_date` = '2024-11-02 00:15:50',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110002652' and product_code = 'LS010143-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110002742' and product_code = 'DG010101-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250316','8','O24110002742','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-11-04','2024-11-02 01:02:49','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250316',`firm_id` = '8',`ordernumber` = 'O24110002742', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-11-04',`create_date` = '2024-11-02 01:02:49',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110002742' and product_code = 'DG010101-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110002870' and product_code = 'BP010184-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250317','8','O24110002870','SNOOPY盥洗收納包','BP010184-01','BP010184','SNOOPY盥洗收納包','SNOOPY盥洗收納包','300','300','0','0','0','0','1','0.0','1','300','2024-11-04','2024-11-02 08:23:08','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250317',`firm_id` = '8',`ordernumber` = 'O24110002870', `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-11-04',`create_date` = '2024-11-02 08:23:08',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110002870' and product_code = 'BP010184-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110002936' and product_code = 'DG0103195-02' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250318','8','O24110002936','【吳淡如聯名】樂饗-8結隨享禮盒','DG0103195-02','DG0103195','原味+原味,鳳梨酥,鳳梅酥','禮盒-吳淡如【原味+原味】+鳳梨酥+鳳梅酥','560','560','0','0','0','0','1','0.0','2','1120','2024-11-04','2024-11-02 08:45:46','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250318',`firm_id` = '8',`ordernumber` = 'O24110002936', `product_name` = '【吳淡如聯名】樂饗-8結隨享禮盒',`product_code` = 'DG0103195-02',`product_sn` = 'DG0103195',`product_spec` = '原味+原味,鳳梨酥,鳳梅酥',`invoice_name` = '禮盒-吳淡如【原味+原味】+鳳梨酥+鳳梅酥',`listprice` = '560',`sellingprice` = '560',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1120',`etd` = '2024-11-04',`create_date` = '2024-11-02 08:45:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110002936' and product_code = 'DG0103195-02' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110002936' and product_code = 'FL010104-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250318','8','O24110002936','[加購]加購-一口鳳梨酥','FL010104-01','FL010104','-','加購-(盒)鳳梨酥','155','155','1','1','155','0','0','0.0','8','1240','2024-11-04','2024-11-02 08:45:46','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250318',`firm_id` = '8',`ordernumber` = 'O24110002936', `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` = '8',`total_price` = '1240',`etd` = '2024-11-04',`create_date` = '2024-11-02 08:45:46',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110002936' and product_code = 'FL010104-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003025' and product_code = 'FL010309-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250319','8','O24110003025','一口酥24入家庭號禮盒','FL010309-01','12586','24入鳳梅酥','禮盒-24入家庭號【鳳梅酥】','585','585','0','0','0','0','1','0.0','2','1170','2024-11-04','2024-11-02 09:42:44','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250319',`firm_id` = '8',`ordernumber` = 'O24110003025', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010309-01',`product_sn` = '12586',`product_spec` = '24入鳳梅酥',`invoice_name` = '禮盒-24入家庭號【鳳梅酥】',`listprice` = '585',`sellingprice` = '585',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1170',`etd` = '2024-11-04',`create_date` = '2024-11-02 09:42:44',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003025' and product_code = 'FL010309-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003138' and product_code = 'DG010101-02' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250320','8','O24110003138','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','11','3080','2024-11-04','2024-11-02 09:47:45','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250320',`firm_id` = '8',`ordernumber` = 'O24110003138', `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` = '11',`total_price` = '3080',`etd` = '2024-11-04',`create_date` = '2024-11-02 09:47:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003138' and product_code = 'DG010101-02' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003138' and product_code = 'DG010226-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250320','8','O24110003138','蓮花式溫碗8結蛋捲提盒【國立故宮博物院】','DG010226-01','DG010226','40入原味蛋捲','提盒-故宮(文物款)-40入原味','300','300','0','0','0','0','1','0.0','11','3300','2024-11-04','2024-11-02 09:47:45','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250320',`firm_id` = '8',`ordernumber` = 'O24110003138', `product_name` = '蓮花式溫碗8結蛋捲提盒【國立故宮博物院】',`product_code` = 'DG010226-01',`product_sn` = 'DG010226',`product_spec` = '40入原味蛋捲',`invoice_name` = '提盒-故宮(文物款)-40入原味',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '11',`total_price` = '3300',`etd` = '2024-11-04',`create_date` = '2024-11-02 09:47:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003138' and product_code = 'DG010226-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003138' and product_code = 'BP010189-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250320','8','O24110003138','贈品-SNOOPY面紙套','BP010189-01','BP010189','贈品-SNOOPY面紙套','贈品-SNOOPY面紙套','0','0','0','0','0','0','1','0.0','1','0','2024-11-04','2024-11-02 09:47:45','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250320',`firm_id` = '8',`ordernumber` = 'O24110003138', `product_name` = '贈品-SNOOPY面紙套',`product_code` = 'BP010189-01',`product_sn` = 'BP010189',`product_spec` = '贈品-SNOOPY面紙套',`invoice_name` = '贈品-SNOOPY面紙套',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-11-04',`create_date` = '2024-11-02 09:47:45',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003138' and product_code = 'BP010189-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003270' and product_code = 'BP010181-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250321','8','O24110003270','SNOOPY飲料提袋','BP010181-01','BP010181','SNOOPY飲料提袋','SNOOPY飲料提袋','150','150','0','0','0','0','1','0.0','1','150','2024-11-04','2024-11-02 11:55:43','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250321',`firm_id` = '8',`ordernumber` = 'O24110003270', `product_name` = 'SNOOPY飲料提袋',`product_code` = 'BP010181-01',`product_sn` = 'BP010181',`product_spec` = 'SNOOPY飲料提袋',`invoice_name` = 'SNOOPY飲料提袋',`listprice` = '150',`sellingprice` = '150',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '150',`etd` = '2024-11-04',`create_date` = '2024-11-02 11:55:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003270' and product_code = 'BP010181-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003270' and product_code = 'BP010185-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250321','8','O24110003270','[加購]加購-SNOOPY盥洗收納包','BP010185-01','BP010185','-','加購-SNOOPY盥洗收納包','250','250','1','1','250','0','0','0.0','1','250','2024-11-04','2024-11-02 11:55:43','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250321',`firm_id` = '8',`ordernumber` = 'O24110003270', `product_name` = '[加購]加購-SNOOPY盥洗收納包',`product_code` = 'BP010185-01',`product_sn` = 'BP010185',`product_spec` = '-',`invoice_name` = '加購-SNOOPY盥洗收納包',`listprice` = '250',`sellingprice` = '250',`isadd` = '1',`isbaby` = '1',`addprice` = '250',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '250',`etd` = '2024-11-04',`create_date` = '2024-11-02 11:55:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003270' and product_code = 'BP010185-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003396' and product_code = 'DG010312-03' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250322','8','O24110003396','【原味+咖啡】金8結禮盒','DG010312-03','DG010312','金8結盒','禮盒-金8結【原味+咖啡】','590','480','0','0','0','0','1','480.0','1','480','2024-11-04','2024-11-02 12:08:36','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250322',`firm_id` = '8',`ordernumber` = 'O24110003396', `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-11-04',`create_date` = '2024-11-02 12:08:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003396' and product_code = 'DG010312-03' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003396' and product_code = 'TG010117-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250322','8','O24110003396','分享包-南棗核桃糕','TG010117-01','TG010117','25入核棗糕分享包','(紅袋)南棗核桃糕','300','300','0','0','0','0','1','0.0','1','300','2024-11-04','2024-11-02 12:08:36','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250322',`firm_id` = '8',`ordernumber` = 'O24110003396', `product_name` = '分享包-南棗核桃糕',`product_code` = 'TG010117-01',`product_sn` = 'TG010117',`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` = '1',`total_price` = '300',`etd` = '2024-11-04',`create_date` = '2024-11-02 12:08:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003396' and product_code = 'TG010117-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003396' and product_code = 'LS010108-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250322','8','O24110003396','[加購]加購-原味乳酪絲','LS010108-01','LS010108','-','加購-(藍袋)乳酪絲【原味】','190','190','1','1','190','0','0','0.0','1','190','2024-11-04','2024-11-02 12:08:36','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250322',`firm_id` = '8',`ordernumber` = 'O24110003396', `product_name` = '[加購]加購-原味乳酪絲',`product_code` = 'LS010108-01',`product_sn` = 'LS010108',`product_spec` = '-',`invoice_name` = '加購-(藍袋)乳酪絲【原味】',`listprice` = '190',`sellingprice` = '190',`isadd` = '1',`isbaby` = '1',`addprice` = '190',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '190',`etd` = '2024-11-04',`create_date` = '2024-11-02 12:08:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003396' and product_code = 'LS010108-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003396' and product_code = 'LS010108-03' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250322','8','O24110003396','[加購]加購-黑松露乳酪絲','LS010108-03','LS010108','-','加購-(藍袋)乳酪絲【黑松露】','190','190','1','1','190','0','0','0.0','1','190','2024-11-04','2024-11-02 12:08:36','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250322',`firm_id` = '8',`ordernumber` = 'O24110003396', `product_name` = '[加購]加購-黑松露乳酪絲',`product_code` = 'LS010108-03',`product_sn` = 'LS010108',`product_spec` = '-',`invoice_name` = '加購-(藍袋)乳酪絲【黑松露】',`listprice` = '190',`sellingprice` = '190',`isadd` = '1',`isbaby` = '1',`addprice` = '190',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '190',`etd` = '2024-11-04',`create_date` = '2024-11-02 12:08:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003396' and product_code = 'LS010108-03' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003495' and product_code = 'DG010347-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250323','8','O24110003495','六月初一&成真咖啡禮盒','DG010347-01','DG010347','原味蛋捲+6入咖啡','禮盒-ESG藍金【原味+成真咖啡】','495','495','0','0','0','0','1','0.0','5','2475','2024-11-04','2024-11-02 13:47:34','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250323',`firm_id` = '8',`ordernumber` = 'O24110003495', `product_name` = '六月初一&成真咖啡禮盒',`product_code` = 'DG010347-01',`product_sn` = 'DG010347',`product_spec` = '原味蛋捲+6入咖啡',`invoice_name` = '禮盒-ESG藍金【原味+成真咖啡】',`listprice` = '495',`sellingprice` = '495',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '2475',`etd` = '2024-11-04',`create_date` = '2024-11-02 13:47:34',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003495' and product_code = 'DG010347-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24110003566' and product_code = 'DG010101-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250324','8','S24110003566','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-11-02','2024-11-02 14:14:12','2024-11-02 23:59:05',0,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250324',`firm_id` = '8',`ordernumber` = 'S24110003566', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-11-02',`create_date` = '2024-11-02 14:14:12',`modify_date` = '2024-11-02 14:27:06',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'S24110003566' and product_code = 'DG010101-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24110003566' and product_code = 'DG010101-02' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250324','8','S24110003566','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-11-02','2024-11-02 14:14:12','2024-11-02 23:59:05',0,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250324',`firm_id` = '8',`ordernumber` = 'S24110003566', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-11-02',`create_date` = '2024-11-02 14:14:12',`modify_date` = '2024-11-02 14:27:06',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'S24110003566' and product_code = 'DG010101-02' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24110003566' and product_code = 'DG010101-03' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250324','8','S24110003566','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-11-02','2024-11-02 14:14:12','2024-11-02 23:59:05',0,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250324',`firm_id` = '8',`ordernumber` = 'S24110003566', `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` = '3',`total_price` = '840',`etd` = '2024-11-02',`create_date` = '2024-11-02 14:14:12',`modify_date` = '2024-11-02 14:27:06',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'S24110003566' and product_code = 'DG010101-03' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24110003566' and product_code = 'DG010101-04' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250324','8','S24110003566','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-11-02','2024-11-02 14:14:12','2024-11-02 23:59:05',0,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250324',`firm_id` = '8',`ordernumber` = 'S24110003566', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`product_sn` = 'DG010101',`product_spec` = '單盒',`invoice_name` = '40入海苔蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '3',`total_price` = '840',`etd` = '2024-11-02',`create_date` = '2024-11-02 14:14:12',`modify_date` = '2024-11-02 14:27:06',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'S24110003566' and product_code = 'DG010101-04' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24110003566' and product_code = 'DG010101-05' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250324','8','S24110003566','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-11-02','2024-11-02 14:14:12','2024-11-02 23:59:05',0,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250324',`firm_id` = '8',`ordernumber` = 'S24110003566', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-11-02',`create_date` = '2024-11-02 14:14:12',`modify_date` = '2024-11-02 14:27:06',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'S24110003566' and product_code = 'DG010101-05' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003665' and product_code = 'DG010312-02' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250325','8','O24110003665','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','2','960','2024-11-04','2024-11-02 14:54:59','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250325',`firm_id` = '8',`ordernumber` = 'O24110003665', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2024-11-04',`create_date` = '2024-11-02 14:54:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003665' and product_code = 'DG010312-02' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003665' and product_code = 'DG010404-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250325','8','O24110003665','紅色提袋','DG010404-01','DG010404','提袋/個','紅色提袋','10','10','0','0','0','0','1','0.0','2','20','2024-11-04','2024-11-02 14:54:59','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250325',`firm_id` = '8',`ordernumber` = 'O24110003665', `product_name` = '紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '提袋/個',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '20',`etd` = '2024-11-04',`create_date` = '2024-11-02 14:54:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003665' and product_code = 'DG010404-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003665' and product_code = 'ZS010201-02' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250325','8','O24110003665','提盒裝肉酥酥','ZS010201-02','ZS010201','原味+辣味','提盒-肉酥酥【原+辣】','300','300','0','0','0','0','1','300.0','2','600','2024-11-04','2024-11-02 14:54:59','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250325',`firm_id` = '8',`ordernumber` = 'O24110003665', `product_name` = '提盒裝肉酥酥',`product_code` = 'ZS010201-02',`product_sn` = 'ZS010201',`product_spec` = '原味+辣味',`invoice_name` = '提盒-肉酥酥【原+辣】',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '2',`total_price` = '600',`etd` = '2024-11-04',`create_date` = '2024-11-02 14:54:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003665' and product_code = 'ZS010201-02' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003665' and product_code = 'FL010310-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250325','8','O24110003665','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-24入家庭號【鳳梨酥+鳳梅酥】','540','540','0','0','0','0','1','0.0','1','540','2024-11-04','2024-11-02 14:54:59','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250325',`firm_id` = '8',`ordernumber` = 'O24110003665', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-24入家庭號【鳳梨酥+鳳梅酥】',`listprice` = '540',`sellingprice` = '540',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '540',`etd` = '2024-11-04',`create_date` = '2024-11-02 14:54:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003665' and product_code = 'FL010310-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003665' and product_code = 'DG010312-12' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250325','8','O24110003665','【咖啡+巧克力】金8結禮盒','DG010312-12','DG010312','金8結盒','禮盒-金8結【咖啡+巧克力】','590','480','0','0','0','0','1','480.0','2','960','2024-11-04','2024-11-02 14:54:59','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250325',`firm_id` = '8',`ordernumber` = 'O24110003665', `product_name` = '【咖啡+巧克力】金8結禮盒',`product_code` = 'DG010312-12',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【咖啡+巧克力】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2024-11-04',`create_date` = '2024-11-02 14:54:59',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003665' and product_code = 'DG010312-12' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003752' and product_code = 'DG010101-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250326','8','O24110003752','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-11-04','2024-11-02 15:09:22','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250326',`firm_id` = '8',`ordernumber` = 'O24110003752', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-11-04',`create_date` = '2024-11-02 15:09:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003752' and product_code = 'DG010101-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003752' and product_code = 'DG010101-02' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250326','8','O24110003752','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','6','1680','2024-11-04','2024-11-02 15:09:22','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250326',`firm_id` = '8',`ordernumber` = 'O24110003752', `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` = '6',`total_price` = '1680',`etd` = '2024-11-04',`create_date` = '2024-11-02 15:09:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003752' and product_code = 'DG010101-02' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003752' and product_code = 'DG010101-03' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250326','8','O24110003752','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-11-04','2024-11-02 15:09:22','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250326',`firm_id` = '8',`ordernumber` = 'O24110003752', `product_name` = '極上咖啡蛋捲',`product_code` = 'DG010101-03',`product_sn` = 'DG010101',`product_spec` = '咖啡',`invoice_name` = '40入咖啡蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-11-04',`create_date` = '2024-11-02 15:09:22',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003752' and product_code = 'DG010101-03' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003824' and product_code = 'DG010265-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250327','8','O24110003824','【SNOOPY 聯名】獨特心意-8結提盒','DG010265-01','DG010265','原味','提盒-SNOOPY(粉)-40入原味','300','300','0','0','0','0','1','0.0','7','2100','2024-11-04','2024-11-02 16:29:28','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250327',`firm_id` = '8',`ordernumber` = 'O24110003824', `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` = '7',`total_price` = '2100',`etd` = '2024-11-04',`create_date` = '2024-11-02 16:29:28',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003824' and product_code = 'DG010265-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003976' and product_code = 'DG010101-01' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250328','8','O24110003976','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','2','560','2024-11-08','2024-11-02 17:31:13','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250328',`firm_id` = '8',`ordernumber` = 'O24110003976', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '2',`total_price` = '560',`etd` = '2024-11-08',`create_date` = '2024-11-02 17:31:13',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003976' and product_code = 'DG010101-01' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003976' and product_code = 'DG010101-03' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250328','8','O24110003976','極上咖啡蛋捲','DG010101-03','DG010101','咖啡','40入咖啡蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-11-08','2024-11-02 17:31:13','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250328',`firm_id` = '8',`ordernumber` = 'O24110003976', `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-11-08',`create_date` = '2024-11-02 17:31:13',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003976' and product_code = 'DG010101-03' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110003976' and product_code = 'DG010101-05' 2024-11-02 23:59:05 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'250328','8','O24110003976','濃情巧克力蛋捲','DG010101-05','DG010101','巧克力','40入巧克力蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-11-08','2024-11-02 17:31:13','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:05 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250328',`firm_id` = '8',`ordernumber` = 'O24110003976', `product_name` = '濃情巧克力蛋捲',`product_code` = 'DG010101-05',`product_sn` = 'DG010101',`product_spec` = '巧克力',`invoice_name` = '40入巧克力蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-11-08',`create_date` = '2024-11-02 17:31:13',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110003976' and product_code = 'DG010101-05' 2024-11-02 23:59:05 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004060' and product_code = 'DG010206-02' 2024-11-02 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,'250329','8','O24110004060','8結蛋捲【紅提盒裝】','DG010206-02','DG010206','芝麻','提盒-品牌(紅)-40入芝麻蛋捲','295','295','0','0','0','0','1','0.0','2','590','2024-11-08','2024-11-02 17:59:33','2024-11-02 23:59:05',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250329',`firm_id` = '8',`ordernumber` = 'O24110004060', `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` = '2',`total_price` = '590',`etd` = '2024-11-08',`create_date` = '2024-11-02 17:59:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004060' and product_code = 'DG010206-02' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004060' and product_code = 'DG010312-08' 2024-11-02 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,'250329','8','O24110004060','【芝麻+海苔】金8結禮盒','DG010312-08','DG010312','金8結盒','禮盒-金8結【芝麻+海苔】','590','480','0','0','0','0','1','480.0','1','480','2024-11-08','2024-11-02 17:59:33','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250329',`firm_id` = '8',`ordernumber` = 'O24110004060', `product_name` = '【芝麻+海苔】金8結禮盒',`product_code` = 'DG010312-08',`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-11-08',`create_date` = '2024-11-02 17:59:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004060' and product_code = 'DG010312-08' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004060' and product_code = 'DG010101-04' 2024-11-02 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,'250329','8','O24110004060','日式海苔蛋捲','DG010101-04','DG010101','單盒','40入海苔蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-11-08','2024-11-02 17:59:33','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250329',`firm_id` = '8',`ordernumber` = 'O24110004060', `product_name` = '日式海苔蛋捲',`product_code` = 'DG010101-04',`product_sn` = 'DG010101',`product_spec` = '單盒',`invoice_name` = '40入海苔蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '3',`total_price` = '840',`etd` = '2024-11-08',`create_date` = '2024-11-02 17:59:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004060' and product_code = 'DG010101-04' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004060' and product_code = 'BP010128-01' 2024-11-02 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,'250329','8','O24110004060','8結小禮袋','BP010128-01','BP010128','提袋/個','8結小禮袋','10','10','0','0','0','0','1','0.0','2','20','2024-11-08','2024-11-02 17:59:33','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250329',`firm_id` = '8',`ordernumber` = 'O24110004060', `product_name` = '8結小禮袋',`product_code` = 'BP010128-01',`product_sn` = 'BP010128',`product_spec` = '提袋/個',`invoice_name` = '8結小禮袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '20',`etd` = '2024-11-08',`create_date` = '2024-11-02 17:59:33',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004060' and product_code = 'BP010128-01' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004167' and product_code = 'DG010265-01' 2024-11-02 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,'250330','8','O24110004167','【SNOOPY 聯名】獨特心意-8結提盒','DG010265-01','DG010265','原味','提盒-SNOOPY(粉)-40入原味','300','300','0','0','0','0','1','0.0','2','600','2024-11-04','2024-11-02 18:05:19','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250330',`firm_id` = '8',`ordernumber` = 'O24110004167', `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` = '2',`total_price` = '600',`etd` = '2024-11-04',`create_date` = '2024-11-02 18:05:19',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004167' and product_code = 'DG010265-01' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004167' and product_code = 'LS010510-02' 2024-11-02 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,'250330','8','O24110004167','梅子零嘴任選二入組','LS010510-02','LS010510','(袋)烏梅絲+(袋)無籽梅肉','(袋)烏梅絲+(袋)無籽梅肉','170','170','0','0','0','0','1','0.0','1','170','2024-11-04','2024-11-02 18:05:19','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250330',`firm_id` = '8',`ordernumber` = 'O24110004167', `product_name` = '梅子零嘴任選二入組',`product_code` = 'LS010510-02',`product_sn` = 'LS010510',`product_spec` = '(袋)烏梅絲+(袋)無籽梅肉',`invoice_name` = '(袋)烏梅絲+(袋)無籽梅肉',`listprice` = '170',`sellingprice` = '170',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '170',`etd` = '2024-11-04',`create_date` = '2024-11-02 18:05:19',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004167' and product_code = 'LS010510-02' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004230' and product_code = 'DG010265-05' 2024-11-02 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,'250331','8','O24110004230','【SNOOPY 聯名】獨特心意-8結提盒','DG010265-05','DG010265','巧克力','提盒-SNOOPY(粉)-40入巧克力','300','300','0','0','0','0','1','0.0','14','4200','2024-11-04','2024-11-02 18:10:04','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250331',`firm_id` = '8',`ordernumber` = 'O24110004230', `product_name` = '【SNOOPY 聯名】獨特心意-8結提盒',`product_code` = 'DG010265-05',`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` = '14',`total_price` = '4200',`etd` = '2024-11-04',`create_date` = '2024-11-02 18:10:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004230' and product_code = 'DG010265-05' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004230' and product_code = 'BP010189-01' 2024-11-02 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,'250331','8','O24110004230','贈品-SNOOPY面紙套','BP010189-01','BP010189','贈品-SNOOPY面紙套','贈品-SNOOPY面紙套','0','0','0','0','0','0','1','0.0','1','0','2024-11-04','2024-11-02 18:10:04','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250331',`firm_id` = '8',`ordernumber` = 'O24110004230', `product_name` = '贈品-SNOOPY面紙套',`product_code` = 'BP010189-01',`product_sn` = 'BP010189',`product_spec` = '贈品-SNOOPY面紙套',`invoice_name` = '贈品-SNOOPY面紙套',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-11-04',`create_date` = '2024-11-02 18:10:04',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004230' and product_code = 'BP010189-01' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004373' and product_code = 'DG010312-02' 2024-11-02 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,'250332','8','O24110004373','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2024-11-04','2024-11-02 18:56:01','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250332',`firm_id` = '8',`ordernumber` = 'O24110004373', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-11-04',`create_date` = '2024-11-02 18:56:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004373' and product_code = 'DG010312-02' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004373' and product_code = 'DG010312-05' 2024-11-02 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,'250332','8','O24110004373','【原味+巧克力】金8結禮盒','DG010312-05','DG010312','金8結盒','禮盒-金8結【原味+巧克力】','590','480','0','0','0','0','1','480.0','1','480','2024-11-04','2024-11-02 18:56:01','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250332',`firm_id` = '8',`ordernumber` = 'O24110004373', `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-11-04',`create_date` = '2024-11-02 18:56:01',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004373' and product_code = 'DG010312-05' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004491' and product_code = 'DG0103195-245' 2024-11-02 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,'250333','8','O24110004491','【吳淡如聯名】樂饗-8結隨享禮盒','DG0103195-245','DG0103195','原味+咖啡,南棗核桃糕,國寶茶','禮盒-吳淡如【原味+咖啡】+南棗核桃糕+國寶茶','540','540','0','0','0','0','1','0.0','2','1080','2024-11-04','2024-11-02 19:24:54','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250333',`firm_id` = '8',`ordernumber` = 'O24110004491', `product_name` = '【吳淡如聯名】樂饗-8結隨享禮盒',`product_code` = 'DG0103195-245',`product_sn` = 'DG0103195',`product_spec` = '原味+咖啡,南棗核桃糕,國寶茶',`invoice_name` = '禮盒-吳淡如【原味+咖啡】+南棗核桃糕+國寶茶',`listprice` = '540',`sellingprice` = '540',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1080',`etd` = '2024-11-04',`create_date` = '2024-11-02 19:24:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004491' and product_code = 'DG0103195-245' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004511' and product_code = 'DG010265-01' 2024-11-02 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,'250334','8','O24110004511','【SNOOPY 聯名】獨特心意-8結提盒','DG010265-01','DG010265','原味','提盒-SNOOPY(粉)-40入原味','300','300','0','0','0','0','1','0.0','22','6600','2024-11-04','2024-11-02 19:41:21','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250334',`firm_id` = '8',`ordernumber` = 'O24110004511', `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` = '22',`total_price` = '6600',`etd` = '2024-11-04',`create_date` = '2024-11-02 19:41:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004511' and product_code = 'DG010265-01' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004511' and product_code = 'BP010189-01' 2024-11-02 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,'250334','8','O24110004511','贈品-SNOOPY面紙套','BP010189-01','BP010189','贈品-SNOOPY面紙套','贈品-SNOOPY面紙套','0','0','0','0','0','0','1','0.0','1','0','2024-11-04','2024-11-02 19:41:21','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250334',`firm_id` = '8',`ordernumber` = 'O24110004511', `product_name` = '贈品-SNOOPY面紙套',`product_code` = 'BP010189-01',`product_sn` = 'BP010189',`product_spec` = '贈品-SNOOPY面紙套',`invoice_name` = '贈品-SNOOPY面紙套',`listprice` = '0',`sellingprice` = '0',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '0',`etd` = '2024-11-04',`create_date` = '2024-11-02 19:41:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004511' and product_code = 'BP010189-01' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004655' and product_code = 'ZS010201-01' 2024-11-02 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,'250335','8','O24110004655','提盒裝肉酥酥','ZS010201-01','ZS010201','原味+原味','提盒-肉酥酥【原味】','300','300','0','0','0','0','1','300.0','3','900','2024-11-08','2024-11-02 19:42:55','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250335',`firm_id` = '8',`ordernumber` = 'O24110004655', `product_name` = '提盒裝肉酥酥',`product_code` = 'ZS010201-01',`product_sn` = 'ZS010201',`product_spec` = '原味+原味',`invoice_name` = '提盒-肉酥酥【原味】',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '300.0',`amount` = '3',`total_price` = '900',`etd` = '2024-11-08',`create_date` = '2024-11-02 19:42:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004655' and product_code = 'ZS010201-01' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004721' and product_code = 'DG010101-02' 2024-11-02 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,'250336','8','O24110004721','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','4','1120','2024-11-07','2024-11-02 20:12:58','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250336',`firm_id` = '8',`ordernumber` = 'O24110004721', `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` = '4',`total_price` = '1120',`etd` = '2024-11-07',`create_date` = '2024-11-02 20:12:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004721' and product_code = 'DG010101-02' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004721' and product_code = '14146' 2024-11-02 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,'250336','8','O24110004721','[加購]加購-原味乳酪絲家庭分享包','14146','14146','-','加購-(紅袋)乳酪絲【原味】','540','540','1','1','540','0','0','0.0','1','540','2024-11-07','2024-11-02 20:12:58','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250336',`firm_id` = '8',`ordernumber` = 'O24110004721', `product_name` = '[加購]加購-原味乳酪絲家庭分享包',`product_code` = '14146',`product_sn` = '14146',`product_spec` = '-',`invoice_name` = '加購-(紅袋)乳酪絲【原味】',`listprice` = '540',`sellingprice` = '540',`isadd` = '1',`isbaby` = '1',`addprice` = '540',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '540',`etd` = '2024-11-07',`create_date` = '2024-11-02 20:12:58',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004721' and product_code = '14146' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004896' and product_code = 'DG0103191-01' 2024-11-02 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,'250337','8','O24110004896','【SNOOPY 聯名】美好探尋-8結肉酥酥禮盒','DG0103191-01','DG0103191','原味蛋捲,原味肉酥酥','禮盒-SNOOPY(橘)【原味+原味肉酥酥】','575','575','0','0','0','0','1','0.0','1','575','2024-11-06','2024-11-02 21:09:24','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250337',`firm_id` = '8',`ordernumber` = 'O24110004896', `product_name` = '【SNOOPY 聯名】美好探尋-8結肉酥酥禮盒',`product_code` = 'DG0103191-01',`product_sn` = 'DG0103191',`product_spec` = '原味蛋捲,原味肉酥酥',`invoice_name` = '禮盒-SNOOPY(橘)【原味+原味肉酥酥】',`listprice` = '575',`sellingprice` = '575',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '575',`etd` = '2024-11-06',`create_date` = '2024-11-02 21:09:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004896' and product_code = 'DG0103191-01' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004896' and product_code = 'BP010185-01' 2024-11-02 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,'250337','8','O24110004896','[加購]加購-SNOOPY盥洗收納包','BP010185-01','BP010185','-','加購-SNOOPY盥洗收納包','250','250','1','1','250','0','0','0.0','1','250','2024-11-06','2024-11-02 21:09:24','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250337',`firm_id` = '8',`ordernumber` = 'O24110004896', `product_name` = '[加購]加購-SNOOPY盥洗收納包',`product_code` = 'BP010185-01',`product_sn` = 'BP010185',`product_spec` = '-',`invoice_name` = '加購-SNOOPY盥洗收納包',`listprice` = '250',`sellingprice` = '250',`isadd` = '1',`isbaby` = '1',`addprice` = '250',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '250',`etd` = '2024-11-06',`create_date` = '2024-11-02 21:09:24',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004896' and product_code = 'BP010185-01' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110004978' and product_code = 'DG010312-02' 2024-11-02 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,'250338','8','O24110004978','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','1','480','2024-11-04','2024-11-02 22:11:25','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250338',`firm_id` = '8',`ordernumber` = 'O24110004978', `product_name` = '【原味+芝麻】金8結禮盒',`product_code` = 'DG010312-02',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+芝麻】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '1',`total_price` = '480',`etd` = '2024-11-04',`create_date` = '2024-11-02 22:11:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110004978' and product_code = 'DG010312-02' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24110005055' and product_code = 'DG010258-03' 2024-11-02 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,'250339','8','O24110005055','金豐收8結提盒','DG010258-03','DG010258','40入咖啡蛋捲','提盒-金豐收(藍)-40入咖啡','295','295','0','0','0','0','1','0.0','10','2950','2024-11-04','2024-11-02 22:26:21','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '250339',`firm_id` = '8',`ordernumber` = 'O24110005055', `product_name` = '金豐收8結提盒',`product_code` = 'DG010258-03',`product_sn` = 'DG010258',`product_spec` = '40入咖啡蛋捲',`invoice_name` = '提盒-金豐收(藍)-40入咖啡',`listprice` = '295',`sellingprice` = '295',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '10',`total_price` = '2950',`etd` = '2024-11-04',`create_date` = '2024-11-02 22:26:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-10-02'where ordernumber = 'O24110005055' and product_code = 'DG010258-03' 2024-11-02 23:59:06 -- == sync_order_detail end == 2024-11-02 23:59:06 -- == sync_order start == 2024-11-02 23:59:06 -- start:2024-11-02,end:2024-11-02 2024-11-02 23:59:06 -- == select june1.order_list == select l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-11-02%' OR l.modify_date like '2024-11-02%'; 2024-11-02 23:59:06 -- == sync omo_order_list == 2024-11-02 23:59:06 -- == update lake.omo_order_list == update omo_order_list set userId = '428073', process_status = '3', pay_status = '1', totalprice_after = '200', lunar_date = '2024-09-26', invoice_status = '1', category_name = '彌月試吃,FB訂單', category_id = '2,10' where ordernumber = 'M24100024146' 2024-11-02 23:59:06 -- == 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 ('152391','428418',2,'','','M24110001243','1','2','12','1','1','','','0','2024-11-04','0','493','0','','230','30','9900','970','花蓮縣','花蓮市','970','花蓮縣','花蓮市','9607','2024-11-02 18:05:50','2024-10-02') 2024-11-02 23:59:06 -- == sync_order end == 2024-11-02 23:59:06 -- == sync_order_detail start == 2024-11-02 23:59:06 -- start:2024-11-02,end:2024-11-02 2024-11-02 23:59:06 -- == sync omo_order_detail == 2024-11-02 23:59:06 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-11-02%' OR modify_date like '2024-11-02%' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24100024146' and product_code = 'DG010267-05' 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33202',`firm_id` = '11',`ordernumber` = 'M24100024146', `product_name` = 'SNOOPY獨特心意提盒(粉)-彌月試吃【A2】',`product_code` = 'DG010267-05',`product_sn` = 'DG010267',`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-11-02',`create_date` = '2024-10-28 17:44:14',`modify_date` = '2024-11-02 16:52:11',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24100024146' and product_code = 'DG010267-05', `lunar_date` = '2024-09-26' 2024-11-02 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'M24110001243' and product_code = 'DG010266-01' 2024-11-02 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, 2,'33246','8','M24110001243','SNOOPY獨特心意-8結彌月提盒','DG010266-01','DG010266','原味','提盒-彌月SNOOPY(粉)-40入原味','300','300','0','0','0','0','1','0.0','33','9900','2024-11-04','2024-11-02 18:05:50','2024-11-02 23:59:06',null,'1','2024-10-02') 2024-11-02 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '33246',`firm_id` = '8',`ordernumber` = 'M24110001243', `product_name` = 'SNOOPY獨特心意-8結彌月提盒',`product_code` = 'DG010266-01',`product_sn` = 'DG010266',`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` = '33',`total_price` = '9900',`etd` = '2024-11-04',`create_date` = '2024-11-02 18:05:50',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1' where ordernumber = 'M24110001243' and product_code = 'DG010266-01', `lunar_date` = '2024-10-02' 2024-11-02 23:59:06 -- == sync_order_detail end == 2024-11-02 23:59:06 -- == select one.order_list == SELECT o.code,o.pay_status,o.order_status,o.user_id,o.pay_method_id,o.activity_freight_id,o.freight_fee,o.items_total,o.total,DATE(o.shipped_at) as shipped_at,o.created_at as create_date, inv.company_number,inv.company_title,inv.invoice_status, cust.zipcode,cust.county,cust.district, rec.zipcode as recipientzip,rec.county as recipientaddresscity,rec.district as recipientaddressarea, af.type as freight_type FROM `orders` o LEFT JOIN systemlead_invoices inv on o.id = inv.order_id LEFT JOIN order_customers cust on o.id = cust.order_id LEFT JOIN order_receivers rec on o.id = rec.order_id LEFT JOIN activity_freights af on o.activity_freight_id = af.id WHERE (DATE(o.created_at) = '2024-11-02' OR o.updated_at = '2024-11-02') and o.deleted_at is null 2024-11-02 23:59:06 -- == sync_order_detail start == 2024-11-02 23:59:06 -- start:2024-11-02,end:2024-11-02 2024-11-02 23:59:07 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2024-11-02 23:59:08 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2024-11-02 23:59:11 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2024-11-02%';