2024-03-30 23:59:02 -- == sync_order start == 2024-03-30 23:59:02 -- start:2024-03-30,end:2024-03-30 2024-03-30 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-03-30%' OR l.modify_date like '2024-03-30%'; 2024-03-30 23:59:03 -- == sync omo_order_list == 2024-03-30 23:59:03 -- == update lake.omo_order_list == update omo_order_list set userId = '79700', process_status = '3', pay_status = '1', totalprice_after = '3140', lunar_date = '2024-02-20', invoice_status = '1',category_name = '美村當日宅配', category_id = '28' where ordernumber = 'S24030109710' 2024-03-30 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 ('346966','383699',1,'','','O24030111665','1','11','1','1','1','','','0','0000-00-00','435','0','0','','0','30','8700','106','台北市','大安區','235','新北市','中和區','8235','2024-03-30 00:30:48','2024-02-21') 2024-03-30 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 ('346966','383699',1,'','','O24030111782','1','11','1','1','1','','','0','0000-00-00','478','0','0','','0','30','9570','106','台北市','大安區','100','台北市','中正區','9062','2024-03-30 00:36:25','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('310608','347800',1,'','','O24030111819','1','2','1','0','0','','','0','0000-00-00','0','0','0','','150','0','699','354','苗栗縣','獅潭鄉','354','苗栗縣','獅潭鄉','849','2024-03-30 02:17:13','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('100981','71878',1,'','','O24030111917','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1440','235','新北市','中和區','235','新北市','中和區','1590','2024-03-30 09:02:14','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('171065','138055',1,'','','O24030112043','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','780','251','新北市','淡水區','251','新北市','淡水區','930','2024-03-30 09:12:48','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('346979','383712',1,'','','O24030112156','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','699','268','宜蘭縣','五結鄉','268','宜蘭縣','五結鄉','819','2024-03-30 10:31:08','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('75450','48044',1,'','','O24030112293','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','0','990','404','台中市','北區','978','花蓮縣','瑞穗鄉','1140','2024-03-30 10:33:42','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('346980','383713',1,'','','O24030112387','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','699','701','台南市','東區','701','台南市','東區','819','2024-03-30 10:38:44','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('345945','382689',1,'','','O24030112473','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1508','950','台東縣','台東市','950','台東縣','台東市','1628','2024-03-30 11:25:43','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('222269','241935',1,'','','O24030112587','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','150','1680','506','彰化縣','福興鄉','506','彰化縣','福興鄉','1680','2024-03-30 11:40:21','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('347000','383733',1,'','','O24030112666','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1350','115','台北市','南港區','249','新北市','八里區','1470','2024-03-30 12:58:18','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('140908','108993',1,'','','O24030112798','1','2','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1380','813','高雄市','左營區','833','高雄市','鳥松區','1530','2024-03-30 12:58:36','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('347003','383736',1,'','','O24030112818','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','699','971','花蓮縣','新城鄉','971','花蓮縣','新城鄉','819','2024-03-30 13:26:40','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('241573','271851',1,'','','O24030112932','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','100','1235','327','桃園市','新屋區','327','桃園市','新屋區','1285','2024-03-30 14:08:48','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('347014','383747',1,'','','O24030113093','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','2698','950','台東縣','台東市','950','台東縣','台東市','2818','2024-03-30 14:32:52','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('317801','354884',1,'','','O24030113138','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','990','640','雲林縣','斗六市','640','雲林縣','斗六市','1140','2024-03-30 14:58:52','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('325094','362075',1,'美村門市訂單','32','S24030113216','1','1','1','1','1','','','0','2024-04-02','0','429','0','','0','100','8580','320','桃園市','中壢區','320','桃園市','中壢區','8051','2024-03-30 15:54:52','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('177940','144640',1,'','','O24030113379','1','1','1','0','0','','','0','0000-00-00','0','0','0','','0','0','7575','248','新北市','五股區','248','新北市','五股區','7575','2024-03-30 15:46:54','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('177940','144640',1,'','','O24030113440','1','2','1','1','1','','','0','0000-00-00','0','0','0','','0','0','5790','248','新北市','五股區','248','新北市','五股區','5790','2024-03-30 15:52:25','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('346994','383727',1,'','','O24030113569','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1398','806','高雄市','前鎮區','806','高雄市','前鎮區','1518','2024-03-30 16:19:57','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('347037','383770',1,'','','O24030113629','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1350','324','桃園市','平鎮區','324','桃園市','平鎮區','1470','2024-03-30 16:24:23','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('281575','319112',1,'','','O24030113744','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','2069','830','高雄市','鳳山區','830','高雄市','鳳山區','2219','2024-03-30 16:27:54','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('347046','383779',1,'','','O24030113837','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1350','742','台南市','大內區','742','台南市','大內區','1470','2024-03-30 17:09:16','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('347054','383787',1,'','','O24030113993','2','11','1','1','1','','','0','0000-00-00','0','0','0','','280','100','1280','406','台中市','北屯區','892','金門縣','金寧鄉','1460','2024-03-30 17:56:12','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('347057','383790',1,'','','O24030114087','1','1','1','0','0','','','0','0000-00-00','0','0','0','','150','0','960','709','台南市','安南區','709','台南市','安南區','1110','2024-03-30 18:13:15','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('328501','365443',1,'','','O24030114173','1','1','1','1','1','','','0','0000-00-00','0','0','0','','150','0','1740','334','桃園市','八德區','334','桃園市','八德區','1890','2024-03-30 19:15:47','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('344502','381264',1,'','','O24030114287','1','11','1','1','1','','','0','0000-00-00','0','0','0','','150','30','1980','830','高雄市','鳳山區','830','高雄市','鳳山區','2100','2024-03-30 20:30:13','2024-02-21') 2024-03-30 23:59:04 -- == inster lake.omo_order_list == INSERT INTO `omo_order_list` (mid,userId,channel,category_name,category_id,ordernumber,location,payway,delivery_way,pay_status,process_status,company_number,company_title,invoice_status,etd,web_discount,class_discount,member_discount,web_gift,freight,entity_discount,totalprice,orderzip,orderaddresscity,orderaddressarea,recipientzip,recipientaddresscity,recipientaddressarea,totalprice_after,create_date,lunar_date) VALUES ('347089','383822',1,'','','O24030114346','1','2','1','1','1','','','0','0000-00-00','0','0','0','','0','0','5640','108','台北市','萬華區','251','新北市','淡水區','5640','2024-03-30 23:07:55','2024-02-21') 2024-03-30 23:59:04 -- == sync_order end == 2024-03-30 23:59:04 -- == sync_order_detail start == 2024-03-30 23:59:04 -- start:2024-03-30,end:2024-03-30 2024-03-30 23:59:04 -- == sync omo_order_detail == 2024-03-30 23:59:04 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-03-30%' OR modify_date like '2024-03-30%' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24030109710' and product_code = 'FL010308-01' 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230380',`firm_id` = '8',`ordernumber` = 'S24030109710', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010308-01',`product_sn` = '12586',`product_spec` = '24入鳳梨酥',`invoice_name` = '禮盒-24入家庭號【鳳梨酥】',`listprice` = '390',`sellingprice` = '390',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '390',`etd` = '2024-03-30',`create_date` = '2024-03-29 15:10:24',`modify_date` = '2024-03-30 11:49:13',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-02-20'where ordernumber = 'S24030109710' and product_code = 'FL010308-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24030109710' and product_code = '04191' 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230380',`firm_id` = '8',`ordernumber` = 'S24030109710', `product_name` = '加購－一口鳳梨酥',`product_code` = '04191',`product_sn` = '04191',`product_spec` = '8入鳳梨酥',`invoice_name` = '加購-(盒)鳳梨酥',`listprice` = '130',`sellingprice` = '120',`isadd` = '1',`isbaby` = '0',`addprice` = '120',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '20',`total_price` = '2400',`etd` = '2024-03-30',`create_date` = '2024-03-29 15:10:24',`modify_date` = '2024-03-30 11:49:13',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-20'where ordernumber = 'S24030109710' and product_code = '04191' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030111665' and product_code = '13657' 2024-03-30 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,'230399','8','O24030111665','8結蛋捲【紅提袋裝】','13657','13656','40入芝麻蛋捲','組合-40入芝麻+紅提袋','290','290','0','0','0','0','1','0.0','30','8700','2024-04-02','2024-03-30 00:30:48','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230399',`firm_id` = '8',`ordernumber` = 'O24030111665', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13657',`product_sn` = '13656',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '組合-40入芝麻+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '30',`total_price` = '8700',`etd` = '2024-04-02',`create_date` = '2024-03-30 00:30:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030111665' and product_code = '13657' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030111782' and product_code = '13657' 2024-03-30 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,'230400','8','O24030111782','8結蛋捲【紅提袋裝】','13657','13656','40入芝麻蛋捲','組合-40入芝麻+紅提袋','290','290','0','0','0','0','1','0.0','33','9570','2024-04-02','2024-03-30 00:36:25','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230400',`firm_id` = '8',`ordernumber` = 'O24030111782', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13657',`product_sn` = '13656',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '組合-40入芝麻+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '33',`total_price` = '9570',`etd` = '2024-04-02',`create_date` = '2024-03-30 00:36:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030111782' and product_code = '13657' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030111819' and product_code = 'DG010566-56' 2024-03-30 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,'230401','8','O24030111819','經典蛋捲三入組','DG010566-56','DG010566','阿薩姆紅茶+阿薩姆紅茶+阿薩姆紅茶','組合-32入(阿薩姆紅茶+阿薩姆紅茶+阿薩姆紅茶)','699','699','0','0','0','1','1','0.0','1','699','2024-04-08','2024-03-30 02:17:13','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230401',`firm_id` = '8',`ordernumber` = 'O24030111819', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-56',`product_sn` = 'DG010566',`product_spec` = '阿薩姆紅茶+阿薩姆紅茶+阿薩姆紅茶',`invoice_name` = '組合-32入(阿薩姆紅茶+阿薩姆紅茶+阿薩姆紅茶)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-08',`create_date` = '2024-03-30 02:17:13',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030111819' and product_code = 'DG010566-56' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030111917' and product_code = 'DG0103148-06' 2024-03-30 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,'230402','8','O24030111917','金典8結禮盒','DG0103148-06','DG0103148','芝麻+芝麻','禮盒-金典(紅)【芝麻+芝麻】','480','480','0','0','0','0','1','0.0','2','960','2024-04-02','2024-03-30 09:02:14','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230402',`firm_id` = '8',`ordernumber` = 'O24030111917', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-06',`product_sn` = 'DG0103148',`product_spec` = '芝麻+芝麻',`invoice_name` = '禮盒-金典(紅)【芝麻+芝麻】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '960',`etd` = '2024-04-02',`create_date` = '2024-03-30 09:02:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030111917' and product_code = 'DG0103148-06' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030111917' and product_code = 'DG0103148-01' 2024-03-30 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,'230402','8','O24030111917','金典8結禮盒','DG0103148-01','DG0103148','原味+原味','禮盒-金典(紅)【原味+原味】','480','480','0','0','0','0','1','0.0','1','480','2024-04-02','2024-03-30 09:02:14','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230402',`firm_id` = '8',`ordernumber` = 'O24030111917', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-01',`product_sn` = 'DG0103148',`product_spec` = '原味+原味',`invoice_name` = '禮盒-金典(紅)【原味+原味】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2024-04-02',`create_date` = '2024-03-30 09:02:14',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030111917' and product_code = 'DG0103148-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112043' and product_code = 'TG010106-01' 2024-03-30 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,'230403','8','O24030112043','分享包-黑曜芝麻糕','TG010106-01','TG010106','25入芝麻糕分享包','(紅袋)芝麻糕','300','300','0','0','0','0','1','0.0','1','300','2024-04-02','2024-03-30 09:12:48','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230403',`firm_id` = '8',`ordernumber` = 'O24030112043', `product_name` = '分享包-黑曜芝麻糕',`product_code` = 'TG010106-01',`product_sn` = 'TG010106',`product_spec` = '25入芝麻糕分享包',`invoice_name` = '(紅袋)芝麻糕',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-04-02',`create_date` = '2024-03-30 09:12:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112043' and product_code = 'TG010106-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112043' and product_code = 'DG0103148-07' 2024-03-30 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,'230403','8','O24030112043','金典8結禮盒','DG0103148-07','DG0103148','芝麻+咖啡','禮盒-金典(紅)【芝麻+咖啡】','480','480','0','0','0','0','1','0.0','1','480','2024-04-02','2024-03-30 09:12:48','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230403',`firm_id` = '8',`ordernumber` = 'O24030112043', `product_name` = '金典8結禮盒',`product_code` = 'DG0103148-07',`product_sn` = 'DG0103148',`product_spec` = '芝麻+咖啡',`invoice_name` = '禮盒-金典(紅)【芝麻+咖啡】',`listprice` = '480',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '480',`etd` = '2024-04-02',`create_date` = '2024-03-30 09:12:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112043' and product_code = 'DG0103148-07' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112156' and product_code = 'DG010566-10' 2024-03-30 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,'230404','8','O24030112156','經典蛋捲三入組','DG010566-10','DG010566','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)','699','699','0','0','0','1','1','0.0','1','699','2024-04-10','2024-03-30 10:31:08','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230404',`firm_id` = '8',`ordernumber` = 'O24030112156', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-10',`product_sn` = 'DG010566',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-10',`create_date` = '2024-03-30 10:31:08',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112156' and product_code = 'DG010566-10' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112293' and product_code = 'DG010523-09' 2024-03-30 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,'230405','8','O24030112293','SNOOPY帶走心意-蛋捲三入組','DG010523-09','DG010523','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-04-02','2024-03-30 10:33:42','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230405',`firm_id` = '8',`ordernumber` = 'O24030112293', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-09',`product_sn` = 'DG010523',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-04-02',`create_date` = '2024-03-30 10:33:42',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112293' and product_code = 'DG010523-09' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112387' and product_code = 'DG010566-01' 2024-03-30 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,'230406','8','O24030112387','經典蛋捲三入組','DG010566-01','DG010566','原味+原味+原味','組合-32入(原味+原味+原味)','699','699','0','0','0','1','1','0.0','1','699','2024-04-02','2024-03-30 10:38:44','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230406',`firm_id` = '8',`ordernumber` = 'O24030112387', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-01',`product_sn` = 'DG010566',`product_spec` = '原味+原味+原味',`invoice_name` = '組合-32入(原味+原味+原味)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-02',`create_date` = '2024-03-30 10:38:44',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112387' and product_code = 'DG010566-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112473' and product_code = 'DG010566-11' 2024-03-30 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,'230407','8','O24030112473','經典蛋捲三入組','DG010566-11','DG010566','原味+芝麻+阿薩姆紅茶','組合-32入(原味+芝麻+阿薩姆紅茶)','699','699','0','0','0','1','1','0.0','1','699','2024-04-02','2024-03-30 11:25:43','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230407',`firm_id` = '8',`ordernumber` = 'O24030112473', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-11',`product_sn` = 'DG010566',`product_spec` = '原味+芝麻+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+芝麻+阿薩姆紅茶)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-02',`create_date` = '2024-03-30 11:25:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112473' and product_code = 'DG010566-11' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112473' and product_code = 'DG010566-08' 2024-03-30 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,'230407','8','O24030112473','經典蛋捲三入組','DG010566-08','DG010566','原味+芝麻+咖啡','組合-32入(原味+芝麻+咖啡)','699','699','0','0','0','1','1','0.0','1','699','2024-04-02','2024-03-30 11:25:43','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230407',`firm_id` = '8',`ordernumber` = 'O24030112473', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-08',`product_sn` = 'DG010566',`product_spec` = '原味+芝麻+咖啡',`invoice_name` = '組合-32入(原味+芝麻+咖啡)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-02',`create_date` = '2024-03-30 11:25:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112473' and product_code = 'DG010566-08' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112473' and product_code = '13044' 2024-03-30 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,'230407','8','O24030112473','[加購]加購-香酥醬燒海苔(純素)','13044','13044','-','加購-香酥醬燒海苔(純素)','110','110','1','1','110','0','0','0.0','1','110','2024-04-02','2024-03-30 11:25:43','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230407',`firm_id` = '8',`ordernumber` = 'O24030112473', `product_name` = '[加購]加購-香酥醬燒海苔(純素)',`product_code` = '13044',`product_sn` = '13044',`product_spec` = '-',`invoice_name` = '加購-香酥醬燒海苔(純素)',`listprice` = '110',`sellingprice` = '110',`isadd` = '1',`isbaby` = '1',`addprice` = '110',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '110',`etd` = '2024-04-02',`create_date` = '2024-03-30 11:25:43',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112473' and product_code = '13044' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112587' and product_code = 'DG010101-01' 2024-03-30 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,'230408','8','O24030112587','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-04-02','2024-03-30 11:40:21','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230408',`firm_id` = '8',`ordernumber` = 'O24030112587', `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` = '3',`total_price` = '840',`etd` = '2024-04-02',`create_date` = '2024-03-30 11:40:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112587' and product_code = 'DG010101-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112587' and product_code = 'DG010101-02' 2024-03-30 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,'230408','8','O24030112587','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','3','840','2024-04-02','2024-03-30 11:40:21','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230408',`firm_id` = '8',`ordernumber` = 'O24030112587', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '3',`total_price` = '840',`etd` = '2024-04-02',`create_date` = '2024-03-30 11:40:21',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112587' and product_code = 'DG010101-02' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112666' and product_code = 'DG010567-70' 2024-03-30 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,'230409','8','O24030112666','熱銷蛋捲六入組','DG010567-70','DG010567','原味+原味+芝麻+芝麻+巧克力+阿薩姆紅茶','組合-32入(原味+原味+芝麻+芝麻+巧克力+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','1','1350','2024-04-02','2024-03-30 12:58:18','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230409',`firm_id` = '8',`ordernumber` = 'O24030112666', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-70',`product_sn` = 'DG010567',`product_spec` = '原味+原味+芝麻+芝麻+巧克力+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+原味+芝麻+芝麻+巧克力+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-04-02',`create_date` = '2024-03-30 12:58:18',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112666' and product_code = 'DG010567-70' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112798' and product_code = 'DG010523-03' 2024-03-30 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,'230410','8','O24030112798','SNOOPY帶走心意-蛋捲三入組','DG010523-03','DG010523','原味+原味+咖啡','組合-32入(原味+原味+咖啡)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-04-08','2024-03-30 12:58:36','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230410',`firm_id` = '8',`ordernumber` = 'O24030112798', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-03',`product_sn` = 'DG010523',`product_spec` = '原味+原味+咖啡',`invoice_name` = '組合-32入(原味+原味+咖啡)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-04-08',`create_date` = '2024-03-30 12:58:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112798' and product_code = 'DG010523-03' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112798' and product_code = 'BP010157-01' 2024-03-30 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,'230410','8','O24030112798','[加購]加購-SNOOPY心意提袋','BP010157-01','BP010157','-','加購-SNOOPY心意提袋','390','390','1','1','390','0','0','0.0','1','390','2024-04-08','2024-03-30 12:58:36','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230410',`firm_id` = '8',`ordernumber` = 'O24030112798', `product_name` = '[加購]加購-SNOOPY心意提袋',`product_code` = 'BP010157-01',`product_sn` = 'BP010157',`product_spec` = '-',`invoice_name` = '加購-SNOOPY心意提袋',`listprice` = '390',`sellingprice` = '390',`isadd` = '1',`isbaby` = '1',`addprice` = '390',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '390',`etd` = '2024-04-08',`create_date` = '2024-03-30 12:58:36',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112798' and product_code = 'BP010157-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112818' and product_code = 'DG010566-09' 2024-03-30 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,'230411','8','O24030112818','經典蛋捲三入組','DG010566-09','DG010566','原味+芝麻+海苔','組合-32入(原味+芝麻+海苔)','699','699','0','0','0','1','1','0.0','1','699','2024-04-02','2024-03-30 13:26:40','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230411',`firm_id` = '8',`ordernumber` = 'O24030112818', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-09',`product_sn` = 'DG010566',`product_spec` = '原味+芝麻+海苔',`invoice_name` = '組合-32入(原味+芝麻+海苔)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-02',`create_date` = '2024-03-30 13:26:40',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112818' and product_code = 'DG010566-09' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112932' and product_code = 'FL010310-01' 2024-03-30 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,'230412','8','O24030112932','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-24入家庭號【鳳梨酥+鳳梅酥】','435','435','0','0','0','0','1','0.0','1','435','2024-04-03','2024-03-30 14:08:48','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230412',`firm_id` = '8',`ordernumber` = 'O24030112932', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-24入家庭號【鳳梨酥+鳳梅酥】',`listprice` = '435',`sellingprice` = '435',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '435',`etd` = '2024-04-03',`create_date` = '2024-03-30 14:08:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112932' and product_code = 'FL010310-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112932' and product_code = 'DG010107-01' 2024-03-30 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,'230412','8','O24030112932','阿薩姆紅茶蛋捲','DG010107-01','DG010107','32入阿薩姆蛋捲','32入阿薩姆紅茶','240','240','0','0','0','0','1','0.0','1','240','2024-04-03','2024-03-30 14:08:48','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230412',`firm_id` = '8',`ordernumber` = 'O24030112932', `product_name` = '阿薩姆紅茶蛋捲',`product_code` = 'DG010107-01',`product_sn` = 'DG010107',`product_spec` = '32入阿薩姆蛋捲',`invoice_name` = '32入阿薩姆紅茶',`listprice` = '240',`sellingprice` = '240',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '240',`etd` = '2024-04-03',`create_date` = '2024-03-30 14:08:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112932' and product_code = 'DG010107-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112932' and product_code = 'DG010101-01' 2024-03-30 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,'230412','8','O24030112932','經典原味蛋捲','DG010101-01','DG010101','原味','40入原味蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-04-03','2024-03-30 14:08:48','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230412',`firm_id` = '8',`ordernumber` = 'O24030112932', `product_name` = '經典原味蛋捲',`product_code` = 'DG010101-01',`product_sn` = 'DG010101',`product_spec` = '原味',`invoice_name` = '40入原味蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-04-03',`create_date` = '2024-03-30 14:08:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112932' and product_code = 'DG010101-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030112932' and product_code = 'DG010101-02' 2024-03-30 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,'230412','8','O24030112932','香醇芝麻蛋捲','DG010101-02','DG010101','芝麻','40入芝麻蛋捲','320','280','0','0','0','0','1','280.0','1','280','2024-04-03','2024-03-30 14:08:48','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230412',`firm_id` = '8',`ordernumber` = 'O24030112932', `product_name` = '香醇芝麻蛋捲',`product_code` = 'DG010101-02',`product_sn` = 'DG010101',`product_spec` = '芝麻',`invoice_name` = '40入芝麻蛋捲',`listprice` = '320',`sellingprice` = '280',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '280.0',`amount` = '1',`total_price` = '280',`etd` = '2024-04-03',`create_date` = '2024-03-30 14:08:48',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030112932' and product_code = 'DG010101-02' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113093' and product_code = 'DG010566-56' 2024-03-30 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,'230413','8','O24030113093','經典蛋捲三入組','DG010566-56','DG010566','阿薩姆紅茶+阿薩姆紅茶+阿薩姆紅茶','組合-32入(阿薩姆紅茶+阿薩姆紅茶+阿薩姆紅茶)','699','699','0','0','0','1','1','0.0','1','699','2024-04-02','2024-03-30 14:32:52','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230413',`firm_id` = '8',`ordernumber` = 'O24030113093', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-56',`product_sn` = 'DG010566',`product_spec` = '阿薩姆紅茶+阿薩姆紅茶+阿薩姆紅茶',`invoice_name` = '組合-32入(阿薩姆紅茶+阿薩姆紅茶+阿薩姆紅茶)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-02',`create_date` = '2024-03-30 14:32:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113093' and product_code = 'DG010566-56' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113093' and product_code = 'DG010566-53' 2024-03-30 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,'230413','8','O24030113093','經典蛋捲三入組','DG010566-53','DG010566','巧克力+巧克力+巧克力','組合-32入(巧克力+巧克力+巧克力)','699','699','0','0','0','1','1','0.0','1','699','2024-04-02','2024-03-30 14:32:52','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230413',`firm_id` = '8',`ordernumber` = 'O24030113093', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-53',`product_sn` = 'DG010566',`product_spec` = '巧克力+巧克力+巧克力',`invoice_name` = '組合-32入(巧克力+巧克力+巧克力)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-02',`create_date` = '2024-03-30 14:32:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113093' and product_code = 'DG010566-53' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113093' and product_code = 'DG0103155-12' 2024-03-30 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,'230413','8','O24030113093','【SNOOPY聯名】友你相伴-8結禮盒','DG0103155-12','DG0103155','咖啡蛋捲,巧克力蛋捲','禮盒-SNOOPY【咖啡+巧克力】','500','500','0','0','0','0','1','0.0','2','1000','2024-04-02','2024-03-30 14:32:52','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230413',`firm_id` = '8',`ordernumber` = 'O24030113093', `product_name` = '【SNOOPY聯名】友你相伴-8結禮盒',`product_code` = 'DG0103155-12',`product_sn` = 'DG0103155',`product_spec` = '咖啡蛋捲,巧克力蛋捲',`invoice_name` = '禮盒-SNOOPY【咖啡+巧克力】',`listprice` = '500',`sellingprice` = '500',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '2',`total_price` = '1000',`etd` = '2024-04-02',`create_date` = '2024-03-30 14:32:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113093' and product_code = 'DG0103155-12' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113093' and product_code = 'DG010261-05' 2024-03-30 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,'230413','8','O24030113093','【SNOOPY聯名】美好食光-8結提盒','DG010261-05','DG010261','40入巧克力蛋捲','提盒-SNOOPY-40入巧克力','300','300','0','0','0','0','1','0.0','1','300','2024-04-02','2024-03-30 14:32:52','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230413',`firm_id` = '8',`ordernumber` = 'O24030113093', `product_name` = '【SNOOPY聯名】美好食光-8結提盒',`product_code` = 'DG010261-05',`product_sn` = 'DG010261',`product_spec` = '40入巧克力蛋捲',`invoice_name` = '提盒-SNOOPY-40入巧克力',`listprice` = '300',`sellingprice` = '300',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '300',`etd` = '2024-04-02',`create_date` = '2024-03-30 14:32:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113093' and product_code = 'DG010261-05' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113138' and product_code = 'DG010523-07' 2024-03-30 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,'230414','8','O24030113138','SNOOPY帶走心意-蛋捲三入組','DG010523-07','DG010523','原味+芝麻+咖啡','組合-32入(原味+芝麻+咖啡)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-04-22','2024-03-30 14:58:52','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230414',`firm_id` = '8',`ordernumber` = 'O24030113138', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-07',`product_sn` = 'DG010523',`product_spec` = '原味+芝麻+咖啡',`invoice_name` = '組合-32入(原味+芝麻+咖啡)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-04-22',`create_date` = '2024-03-30 14:58:52',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113138' and product_code = 'DG010523-07' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'S24030113216' and product_code = 'FL010308-01' 2024-03-30 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,'230415','8','S24030113216','鳳梨酥24入家庭號禮盒','FL010308-01','FL010308','24入鳳梨酥','禮盒-24入鳳梨酥','390','390','0','0','0','0','1','0.0','22','8580','2024-04-02','2024-03-30 15:46:03','2024-03-30 23:59:06',0,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230415',`firm_id` = '8',`ordernumber` = 'S24030113216', `product_name` = '鳳梨酥24入家庭號禮盒',`product_code` = 'FL010308-01',`product_sn` = 'FL010308',`product_spec` = '24入鳳梨酥',`invoice_name` = '禮盒-24入鳳梨酥',`listprice` = '390',`sellingprice` = '390',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '22',`total_price` = '8580',`etd` = '2024-04-02',`create_date` = '2024-03-30 15:46:03',`modify_date` = '2024-03-30 15:54:52',`points_use_id` = 0,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'S24030113216' and product_code = 'FL010308-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113379' and product_code = 'FL010310-01' 2024-03-30 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,'230416','8','O24030113379','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-24入家庭號【鳳梨酥+鳳梅酥】','435','435','0','0','0','0','1','0.0','5','2175','2024-04-08','2024-03-30 15:46:54','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230416',`firm_id` = '8',`ordernumber` = 'O24030113379', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-24入家庭號【鳳梨酥+鳳梅酥】',`listprice` = '435',`sellingprice` = '435',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '5',`total_price` = '2175',`etd` = '2024-04-08',`create_date` = '2024-03-30 15:46:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113379' and product_code = 'FL010310-01' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113379' and product_code = 'DG010567-78' 2024-03-30 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,'230416','8','O24030113379','熱銷蛋捲六入組','DG010567-78','DG010567','原味+原味+芝麻+咖啡+海苔+阿薩姆紅茶','組合-32入(原味+原味+芝麻+咖啡+海苔+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','4','5400','2024-04-08','2024-03-30 15:46:54','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230416',`firm_id` = '8',`ordernumber` = 'O24030113379', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-78',`product_sn` = 'DG010567',`product_spec` = '原味+原味+芝麻+咖啡+海苔+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+原味+芝麻+咖啡+海苔+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '5400',`etd` = '2024-04-08',`create_date` = '2024-03-30 15:46:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113379' and product_code = 'DG010567-78' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113440' and product_code = 'DG010567-78' 2024-03-30 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,'230417','8','O24030113440','熱銷蛋捲六入組','DG010567-78','DG010567','原味+原味+芝麻+咖啡+海苔+阿薩姆紅茶','組合-32入(原味+原味+芝麻+咖啡+海苔+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','1','1350','2024-04-08','2024-03-30 15:52:25','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230417',`firm_id` = '8',`ordernumber` = 'O24030113440', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-78',`product_sn` = 'DG010567',`product_spec` = '原味+原味+芝麻+咖啡+海苔+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+原味+芝麻+咖啡+海苔+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-04-08',`create_date` = '2024-03-30 15:52:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113440' and product_code = 'DG010567-78' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113440' and product_code = 'DG010567-302' 2024-03-30 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,'230417','8','O24030113440','熱銷蛋捲六入組','DG010567-302','DG010567','芝麻+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶','組合-32入(芝麻+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','1','1350','2024-04-08','2024-03-30 15:52:25','2024-03-30 23:59:06',null,'1','2024-02-21') 2024-03-30 23:59:06 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230417',`firm_id` = '8',`ordernumber` = 'O24030113440', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-302',`product_sn` = 'DG010567',`product_spec` = '芝麻+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶',`invoice_name` = '組合-32入(芝麻+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-04-08',`create_date` = '2024-03-30 15:52:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113440' and product_code = 'DG010567-302' 2024-03-30 23:59:06 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113440' and product_code = 'DG010567-86' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230417','8','O24030113440','熱銷蛋捲六入組','DG010567-86','DG010567','原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶','組合-32入(原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','1','1350','2024-04-08','2024-03-30 15:52:25','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230417',`firm_id` = '8',`ordernumber` = 'O24030113440', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-86',`product_sn` = 'DG010567',`product_spec` = '原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-04-08',`create_date` = '2024-03-30 15:52:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113440' and product_code = 'DG010567-86' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113440' and product_code = 'FL010310-01' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230417','8','O24030113440','一口酥24入家庭號禮盒','FL010310-01','12586','12入鳳梨酥+12入鳳梅酥','禮盒-24入家庭號【鳳梨酥+鳳梅酥】','435','435','0','0','0','0','1','0.0','4','1740','2024-04-08','2024-03-30 15:52:25','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230417',`firm_id` = '8',`ordernumber` = 'O24030113440', `product_name` = '一口酥24入家庭號禮盒',`product_code` = 'FL010310-01',`product_sn` = '12586',`product_spec` = '12入鳳梨酥+12入鳳梅酥',`invoice_name` = '禮盒-24入家庭號【鳳梨酥+鳳梅酥】',`listprice` = '435',`sellingprice` = '435',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1740',`etd` = '2024-04-08',`create_date` = '2024-03-30 15:52:25',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113440' and product_code = 'FL010310-01' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113569' and product_code = 'DG010566-37' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230418','8','O24030113569','經典蛋捲三入組','DG010566-37','DG010566','咖啡+咖啡+咖啡','組合-32入(咖啡+咖啡+咖啡)','699','699','0','0','0','1','1','0.0','1','699','2024-04-22','2024-03-30 16:19:57','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230418',`firm_id` = '8',`ordernumber` = 'O24030113569', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-37',`product_sn` = 'DG010566',`product_spec` = '咖啡+咖啡+咖啡',`invoice_name` = '組合-32入(咖啡+咖啡+咖啡)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-22',`create_date` = '2024-03-30 16:19:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113569' and product_code = 'DG010566-37' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113569' and product_code = 'DG010566-09' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230418','8','O24030113569','經典蛋捲三入組','DG010566-09','DG010566','原味+芝麻+海苔','組合-32入(原味+芝麻+海苔)','699','699','0','0','0','1','1','0.0','1','699','2024-04-22','2024-03-30 16:19:57','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230418',`firm_id` = '8',`ordernumber` = 'O24030113569', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-09',`product_sn` = 'DG010566',`product_spec` = '原味+芝麻+海苔',`invoice_name` = '組合-32入(原味+芝麻+海苔)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-22',`create_date` = '2024-03-30 16:19:57',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113569' and product_code = 'DG010566-09' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113629' and product_code = 'DG010567-176' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230419','8','O24030113629','熱銷蛋捲六入組','DG010567-176','DG010567','原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶','組合-32入(原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','1','1350','2024-04-02','2024-03-30 16:24:23','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230419',`firm_id` = '8',`ordernumber` = 'O24030113629', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-176',`product_sn` = 'DG010567',`product_spec` = '原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+芝麻+咖啡+海苔+巧克力+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-04-02',`create_date` = '2024-03-30 16:24:23',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113629' and product_code = 'DG010567-176' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113744' and product_code = 'DG010567-86' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230420','8','O24030113744','熱銷蛋捲六入組','DG010567-86','DG010567','原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶','組合-32入(原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','1','1350','2024-04-22','2024-03-30 16:27:54','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230420',`firm_id` = '8',`ordernumber` = 'O24030113744', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-86',`product_sn` = 'DG010567',`product_spec` = '原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+原味+芝麻+海苔+巧克力+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-04-22',`create_date` = '2024-03-30 16:27:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113744' and product_code = 'DG010567-86' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113744' and product_code = 'DG010566-10' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230420','8','O24030113744','經典蛋捲三入組','DG010566-10','DG010566','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)','699','699','0','0','0','1','1','0.0','1','699','2024-04-22','2024-03-30 16:27:54','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230420',`firm_id` = '8',`ordernumber` = 'O24030113744', `product_name` = '經典蛋捲三入組',`product_code` = 'DG010566-10',`product_sn` = 'DG010566',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)',`listprice` = '699',`sellingprice` = '699',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '699',`etd` = '2024-04-22',`create_date` = '2024-03-30 16:27:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113744' and product_code = 'DG010566-10' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113744' and product_code = 'DG010404-01' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230420','8','O24030113744','[加購]紅色提袋','DG010404-01','DG010404','-','紅色提袋','10','10','1','0','10','0','0','0.0','1','10','2024-04-22','2024-03-30 16:27:54','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230420',`firm_id` = '8',`ordernumber` = 'O24030113744', `product_name` = '[加購]紅色提袋',`product_code` = 'DG010404-01',`product_sn` = 'DG010404',`product_spec` = '-',`invoice_name` = '紅色提袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '1',`isbaby` = '0',`addprice` = '10',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '10',`etd` = '2024-04-22',`create_date` = '2024-03-30 16:27:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113744' and product_code = 'DG010404-01' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113744' and product_code = 'BP010128-01' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230420','8','O24030113744','[加購]8結小禮袋','BP010128-01','BP010128','-','8結小禮袋','10','10','1','0','10','0','0','0.0','1','10','2024-04-22','2024-03-30 16:27:54','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230420',`firm_id` = '8',`ordernumber` = 'O24030113744', `product_name` = '[加購]8結小禮袋',`product_code` = 'BP010128-01',`product_sn` = 'BP010128',`product_spec` = '-',`invoice_name` = '8結小禮袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '1',`isbaby` = '0',`addprice` = '10',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '1',`total_price` = '10',`etd` = '2024-04-22',`create_date` = '2024-03-30 16:27:54',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113744' and product_code = 'BP010128-01' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113837' and product_code = 'DG010567-63' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230421','8','O24030113837','熱銷蛋捲六入組','DG010567-63','DG010567','原味+原味+芝麻+芝麻+咖啡+海苔','組合-32入(原味+原味+芝麻+芝麻+咖啡+海苔)','1350','1350','0','0','0','1','1','0.0','1','1350','2024-04-02','2024-03-30 17:09:16','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230421',`firm_id` = '8',`ordernumber` = 'O24030113837', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-63',`product_sn` = 'DG010567',`product_spec` = '原味+原味+芝麻+芝麻+咖啡+海苔',`invoice_name` = '組合-32入(原味+原味+芝麻+芝麻+咖啡+海苔)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '1350',`etd` = '2024-04-02',`create_date` = '2024-03-30 17:09:16',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113837' and product_code = 'DG010567-63' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113993' and product_code = 'DG010312-02' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230422','8','O24030113993','【原味+芝麻】金8結禮盒','DG010312-02','DG010312','金8結盒','禮盒-金8結【原味+芝麻】','590','480','0','0','0','0','1','480.0','2','960','2024-04-02','2024-03-30 17:56:12','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230422',`firm_id` = '8',`ordernumber` = 'O24030113993', `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-04-02',`create_date` = '2024-03-30 17:56:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113993' and product_code = 'DG010312-02' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030113993' and product_code = '12505' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230422','8','O24030113993','剛好一口酥禮盒','12505','12505','鳳梨酥,鳳梅酥','禮盒-剛好一口酥【鳳梨酥+鳳梅酥】','320','320','0','0','0','0','1','0.0','1','320','2024-04-02','2024-03-30 17:56:12','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230422',`firm_id` = '8',`ordernumber` = 'O24030113993', `product_name` = '剛好一口酥禮盒',`product_code` = '12505',`product_sn` = '12505',`product_spec` = '鳳梨酥,鳳梅酥',`invoice_name` = '禮盒-剛好一口酥【鳳梨酥+鳳梅酥】',`listprice` = '320',`sellingprice` = '320',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '320',`etd` = '2024-04-02',`create_date` = '2024-03-30 17:56:12',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030113993' and product_code = '12505' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030114087' and product_code = 'DG010312-01' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230423','8','O24030114087','【原味＋原味】金8結禮盒','DG010312-01','DG010312','金8結盒','禮盒-金8結【原味+原味】','590','480','0','0','0','0','1','480.0','2','960','2024-04-02','2024-03-30 18:13:15','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230423',`firm_id` = '8',`ordernumber` = 'O24030114087', `product_name` = '【原味＋原味】金8結禮盒',`product_code` = 'DG010312-01',`product_sn` = 'DG010312',`product_spec` = '金8結盒',`invoice_name` = '禮盒-金8結【原味+原味】',`listprice` = '590',`sellingprice` = '480',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '480.0',`amount` = '2',`total_price` = '960',`etd` = '2024-04-02',`create_date` = '2024-03-30 18:13:15',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030114087' and product_code = 'DG010312-01' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030114173' and product_code = '13657' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230424','8','O24030114173','8結蛋捲【紅提袋裝】','13657','13656','40入芝麻蛋捲','組合-40入芝麻+紅提袋','290','290','0','0','0','0','1','0.0','4','1160','2024-04-02','2024-03-30 19:15:47','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230424',`firm_id` = '8',`ordernumber` = 'O24030114173', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13657',`product_sn` = '13656',`product_spec` = '40入芝麻蛋捲',`invoice_name` = '組合-40入芝麻+紅提袋',`listprice` = '290',`sellingprice` = '290',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '0',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '1160',`etd` = '2024-04-02',`create_date` = '2024-03-30 19:15:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030114173' and product_code = '13657' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030114173' and product_code = '13660' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230424','8','O24030114173','8結蛋捲【紅提袋裝】','13660','13656','40入巧克力蛋捲','組合-40入巧克力+紅提袋','290','290','0','0','0','0','1','0.0','2','580','2024-04-02','2024-03-30 19:15:47','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230424',`firm_id` = '8',`ordernumber` = 'O24030114173', `product_name` = '8結蛋捲【紅提袋裝】',`product_code` = '13660',`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` = '2',`total_price` = '580',`etd` = '2024-04-02',`create_date` = '2024-03-30 19:15:47',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030114173' and product_code = '13660' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030114287' and product_code = 'DG010523-09' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230425','8','O24030114287','SNOOPY帶走心意-蛋捲三入組','DG010523-09','DG010523','原味+芝麻+巧克力','組合-32入(原味+芝麻+巧克力)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-04-02','2024-03-30 20:30:13','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230425',`firm_id` = '8',`ordernumber` = 'O24030114287', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-09',`product_sn` = 'DG010523',`product_spec` = '原味+芝麻+巧克力',`invoice_name` = '組合-32入(原味+芝麻+巧克力)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-04-02',`create_date` = '2024-03-30 20:30:13',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030114287' and product_code = 'DG010523-09' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030114287' and product_code = 'DG010523-14' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230425','8','O24030114287','SNOOPY帶走心意-蛋捲三入組','DG010523-14','DG010523','原味+巧克力+海苔','組合-32入(原味+海苔+巧克力)+SNOOPY心意提袋','990','990','0','0','0','1','1','0.0','1','990','2024-04-02','2024-03-30 20:30:13','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230425',`firm_id` = '8',`ordernumber` = 'O24030114287', `product_name` = 'SNOOPY帶走心意-蛋捲三入組',`product_code` = 'DG010523-14',`product_sn` = 'DG010523',`product_spec` = '原味+巧克力+海苔',`invoice_name` = '組合-32入(原味+海苔+巧克力)+SNOOPY心意提袋',`listprice` = '990',`sellingprice` = '990',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '1',`total_price` = '990',`etd` = '2024-04-02',`create_date` = '2024-03-30 20:30:13',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030114287' and product_code = 'DG010523-14' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030114346' and product_code = 'DG010567-80' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230426','8','O24030114346','熱銷蛋捲六入組','DG010567-80','DG010567','原味+原味+芝麻+咖啡+巧克力+阿薩姆紅茶','組合-32入(原味+原味+芝麻+咖啡+巧克力+阿薩姆紅茶)','1350','1350','0','0','0','1','1','0.0','4','5400','2024-04-02','2024-03-30 23:07:55','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230426',`firm_id` = '8',`ordernumber` = 'O24030114346', `product_name` = '熱銷蛋捲六入組',`product_code` = 'DG010567-80',`product_sn` = 'DG010567',`product_spec` = '原味+原味+芝麻+咖啡+巧克力+阿薩姆紅茶',`invoice_name` = '組合-32入(原味+原味+芝麻+咖啡+巧克力+阿薩姆紅茶)',`listprice` = '1350',`sellingprice` = '1350',`isadd` = '0',`isbaby` = '0',`addprice` = '0',`is_exclude` = '1',`freight_type` = '1',`commission` = '0.0',`amount` = '4',`total_price` = '5400',`etd` = '2024-04-02',`create_date` = '2024-03-30 23:07:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030114346' and product_code = 'DG010567-80' 2024-03-30 23:59:07 -- == SELECT lake.omo_order_detail == select ordernumber from omo_order_detail where ordernumber = 'O24030114346' and product_code = 'BP010128-01' 2024-03-30 23:59:07 -- == INSERT lake.omo_order_detail == INSERT INTO `omo_order_detail`(`id`,`channel`, `order_id`, `firm_id`, `ordernumber`, `product_name`, `product_code`, `product_sn`, `product_spec`, `invoice_name`, `listprice`, `sellingprice`, `isadd`, `isbaby`, `addprice`, `is_exclude`, `freight_type`, `commission`, `amount`, `total_price`, `etd`, `create_date`, `modify_date`, `points_use_id`, `item_status`, `lunar_date`) VALUES (null, 1,'230426','8','O24030114346','[加購]8結小禮袋','BP010128-01','BP010128','-','8結小禮袋','10','10','1','0','10','0','0','0.0','24','240','2024-04-02','2024-03-30 23:07:55','2024-03-30 23:59:07',null,'1','2024-02-21') 2024-03-30 23:59:07 -- == UPDATE lake.order_detail == UPDATE `omo_order_detail` SET `order_id` = '230426',`firm_id` = '8',`ordernumber` = 'O24030114346', `product_name` = '[加購]8結小禮袋',`product_code` = 'BP010128-01',`product_sn` = 'BP010128',`product_spec` = '-',`invoice_name` = '8結小禮袋',`listprice` = '10',`sellingprice` = '10',`isadd` = '1',`isbaby` = '0',`addprice` = '10',`is_exclude` = '0',`freight_type` = '0',`commission` = '0.0',`amount` = '24',`total_price` = '240',`etd` = '2024-04-02',`create_date` = '2024-03-30 23:07:55',`modify_date` = '0000-00-00 00:00:00',`points_use_id` = null,`item_status` = '1', `lunar_date` = '2024-02-21'where ordernumber = 'O24030114346' and product_code = 'BP010128-01' 2024-03-30 23:59:07 -- == sync_order_detail end == 2024-03-30 23:59:07 -- == sync_order start == 2024-03-30 23:59:07 -- start:2024-03-30,end:2024-03-30 2024-03-30 23:59:07 -- == select june1.order_list == select l.mid,m.uid,l.category_name,l.category_id,l.ordernumber,l.location,l.payway,l.delivery_way,l.pay_status,l.process_status,l.company_number,l.company_title,l.invoice_status,l.etd,l.web_discount,l.class_discount,l.member_discount,l.web_gift,l.freight,l.entity_discount,l.totalprice,l.orderzip,l.orderaddresscity,l.orderaddressarea,l.recipientzip,l.recipientaddresscity,l.recipientaddressarea,l.totalprice_after-web_discount-class_discount-member_discount-entity_discount as totalprice_after,l.create_date FROM `order_list` l LEFT JOIN member_list m on l.mid = m.id WHERE l.create_date like '2024-03-30%' OR l.modify_date like '2024-03-30%'; 2024-03-30 23:59:07 -- == sync omo_order_list == 2024-03-30 23:59:07 -- == sync_order end == 2024-03-30 23:59:07 -- == sync_order_detail start == 2024-03-30 23:59:07 -- start:2024-03-30,end:2024-03-30 2024-03-30 23:59:07 -- == sync omo_order_detail == 2024-03-30 23:59:07 -- == SELECT order_detail == SELECT * from order_detail WHERE create_date like '2024-03-30%' OR modify_date like '2024-03-30%' 2024-03-30 23:59:07 -- == sync_order_detail end == 2024-03-30 23:59:07 -- == select one.order_list == SELECT o.code,o.pay_status,o.order_status,o.user_id,o.pay_method_id,o.activity_freight_id,o.freight_fee,o.items_total,o.total,DATE(o.shipped_at) as shipped_at,o.created_at as create_date, inv.company_number,inv.company_title,inv.invoice_status, cust.zipcode,cust.county,cust.district, rec.zipcode as recipientzip,rec.county as recipientaddresscity,rec.district as recipientaddressarea, af.type as freight_type FROM `orders` o LEFT JOIN systemlead_invoices inv on o.id = inv.order_id LEFT JOIN order_customers cust on o.id = cust.order_id LEFT JOIN order_receivers rec on o.id = rec.order_id LEFT JOIN activity_freights af on o.activity_freight_id = af.id WHERE (DATE(o.created_at) = '2024-03-30' OR o.updated_at = '2024-03-30') and o.deleted_at is null 2024-03-30 23:59:07 -- == sync_order_detail start == 2024-03-30 23:59:07 -- start:2024-03-30,end:2024-03-30 2024-03-30 23:59:08 -- step1: SELECT id,sku,combinations_product_spec_id FROM `product_specs` 2024-03-30 23:59:08 -- step2: SELECT * FROM `product_specs` WHERE combinations_product_spec_id is not null 2024-03-30 23:59:10 -- step3: SELECT id,product_code,product_sn FROM `omo_order_detail` WHERE `channel` = 6 and product_code like '%,%' and create_date LIKE '2024-03-30%';