INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-25 ','11:30:53');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-17';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-16';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-16' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-17';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-25 ','11:31:25');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-18','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-18';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-17';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-17';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-17' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-17';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-17';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-17';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-17';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-18' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-17' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-18';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-25 ','11:31:47');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-18';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-18' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-19';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-25 ','11:32:12');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-19';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-19' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-20';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-25 ','11:32:40');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-20';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-20' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-21';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-25 ','11:33:44');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-21';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-21' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-22';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-25 ','11:34:11');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-22';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-22' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-23';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-25 ','11:34:28');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-23';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-23';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-23' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-24';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-25 ','11:34:49');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-25','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-24';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-08-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-24' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-25';