INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-01-21 ','09:08:58');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-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='2026-01-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-19' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-01-20';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-01-21 ','09:09:31');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-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='2026-01-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-20' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-01-21';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-01-21 ','09:11:41');
UPDATE tm_group SET harga='1125000' WHERE kode_group = 'MD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MD','1125000','admin','2026-01-21 09:12:00');
UPDATE tm_group SET harga='1125000' WHERE kode_group = 'MS' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MS','1125000','admin','2026-01-21 09:12:14');
UPDATE tm_group SET harga='1965000' WHERE kode_group = 'MT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MT','1965000','admin','2026-01-21 09:12:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-01-21 ','13:36:31');
UPDATE tm_group SET harga='1145000' WHERE kode_group = 'MD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MD','1145000','admin','2026-01-21 13:36:52');
UPDATE tm_group SET harga='1145000' WHERE kode_group = 'MS' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MS','1145000','admin','2026-01-21 13:37:00');
UPDATE tm_group SET harga='1990000' WHERE kode_group = 'MT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MT','1990000','admin','2026-01-21 13:37:12');