開始執行時光機補救計畫...
正在將 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 筆資料。
🎉 補救計畫執行完畢!