開始執行時光機補救計畫...
正在將 2026-04-01 的庫存推算至 2026-04-02 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '02', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-01' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-02' ) " ✅ 2026-04-02 補救完成,新增了 12 筆資料。
正在將 2026-04-02 的庫存推算至 2026-04-03 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '03', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-02' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-03' ) " ✅ 2026-04-03 補救完成,新增了 60 筆資料。
正在將 2026-04-03 的庫存推算至 2026-04-04 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '04', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-03' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-04' ) " ✅ 2026-04-04 補救完成,新增了 0 筆資料。
正在將 2026-04-04 的庫存推算至 2026-04-05 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '05', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-04' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-05' ) " ✅ 2026-04-05 補救完成,新增了 0 筆資料。
正在將 2026-04-05 的庫存推算至 2026-04-06 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '06', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-05' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-06' ) " ✅ 2026-04-06 補救完成,新增了 0 筆資料。
正在將 2026-04-06 的庫存推算至 2026-04-07 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '07', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-06' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-07' ) " ✅ 2026-04-07 補救完成,新增了 0 筆資料。
正在將 2026-04-07 的庫存推算至 2026-04-08 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '08', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-07' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-08' ) " ✅ 2026-04-08 補救完成,新增了 146 筆資料。
正在將 2026-04-08 的庫存推算至 2026-04-09 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '09', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-08' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-09' ) " ✅ 2026-04-09 補救完成,新增了 92 筆資料。
正在將 2026-04-09 的庫存推算至 2026-04-10 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '10', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-09' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-10' ) " ✅ 2026-04-10 補救完成,新增了 106 筆資料。
正在將 2026-04-10 的庫存推算至 2026-04-11 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '11', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-10' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-11' ) " ✅ 2026-04-11 補救完成,新增了 72 筆資料。
正在將 2026-04-11 的庫存推算至 2026-04-12 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '12', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-11' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-12' ) " ✅ 2026-04-12 補救完成,新增了 0 筆資料。
正在將 2026-04-12 的庫存推算至 2026-04-13 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '13', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-12' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-13' ) " ✅ 2026-04-13 補救完成,新增了 0 筆資料。
正在將 2026-04-13 的庫存推算至 2026-04-14 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '14', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-13' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-14' ) " ✅ 2026-04-14 補救完成,新增了 15524 筆資料。
正在將 2026-04-14 的庫存推算至 2026-04-15 ...
string(616) " INSERT INTO oh_inventory (`ID`, `year`, `month`, `day`, `product_id`, `inventory`, `worth`, `avg`, `operator_id`, `close_datetime`) SELECT NULL, '2026', '04', '15', product_id, inventory, worth, avg, operator_id, close_datetime FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-14' AND product_id NOT IN ( -- 排除今天已經因為「新增商品」而建好庫存的 product_id SELECT product_id FROM oh_inventory WHERE DATE(close_datetime) = '2026-04-15' ) " ✅ 2026-04-15 補救完成,新增了 0 筆資料。
🎉 補救計畫執行完畢!