INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-05 ','08:15:17');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-04';
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-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-04';
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-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-04' 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-05';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-05 ','09:34:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-08-05 ','09:43:34');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250805-0001','1','MDAT-YGBI-1-0','TOKO','INPUT1','ANTING DELAPAN ','1','3.200','RETUR SALAH BERAT');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2025-08-05 09:46:49',status_delete='3.000' WHERE kode_barang='MDAT-YGBI-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YGBI-1-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YGBI-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.200,berat_hancur_asli=berat_hancur_asli+3.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='INPUT1' AND kode_barang='MDAT-YGBI-1-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-250805-0001','2025-08-05','admin','2025-08-05','09:46:49','admin','2025-08-05 09:46:49');