INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-01 ','08:06:48');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-30';
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-09-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-10-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-30' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-10-01';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-01 ','09:48:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-01 ','10:57:32');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261001-0001','1','MDAT-ZIBI-1-0','1','1.140','1.140','TOKO','INPUT1','TOKO','BATMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZIBI-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-01','TOKO','BATMD','MDAT','MDAT-ZIBI-1-0','100.00','1','1.140','1.130','1','1.140','1.130');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.140',berat_out_asli=berat_out_asli+'1.130',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-01' AND kode_barang='MDAT-ZIBI-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261001-0001','2026-10-01','2026-10-01','10:57','1.14','adminpusat','2026-10-01 10:58:02');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261001-0002','1','MTKL-ZIBI-2-0','1','2.920','2.920','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIBI-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-01','TOKO','BKKLMT','MTKL','MTKL-ZIBI-2-0','100.00','1','2.920','2.910','1','2.920','2.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.920',berat_out_asli=berat_out_asli+'2.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-01' AND kode_barang='MTKL-ZIBI-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261001-0002','2026-10-01','2026-10-01','10:58','2.92','adminpusat','2026-10-01 10:59:06');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261001-0003','1','MTLT-ZIBI-3-0','1','1.600','1.600','TOKO','INPUT1','TOKO','BKLTMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLTMT' WHERE kode_barang='MTLT-ZIBI-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-01','TOKO','BKLTMT','MTLT','MTLT-ZIBI-3-0','100.00','1','1.600','1.590','1','1.600','1.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.600',berat_out_asli=berat_out_asli+'1.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-01' AND kode_barang='MTLT-ZIBI-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261001-0003','2026-10-01','2026-10-01','10:59','1.6','adminpusat','2026-10-01 11:00:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-10-01 ','15:40:53');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261001-0001','1','MDAT-ZIBI-1-0','1','1.140','TOKO','BATMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDAT-ZIBI-1-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZIBI-1-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDAT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDAT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BATMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BATMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDAT-ZIBI-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.140',berat_out_asli='1.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.140',berat_akhir_asli =berat_akhir_asli-'1.130' WHERE kode_barang='MDAT-ZIBI-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261001-0001','2026-10-01','2026-10-01','15:42','1.140','adminpusat','261001');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261001-0002','1','MTKL-ZIBI-2-0','1','2.920','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIBI-2-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIBI-2-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIBI-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.920',berat_out_asli='2.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.920',berat_akhir_asli =berat_akhir_asli-'2.910' WHERE kode_barang='MTKL-ZIBI-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261001-0002','2026-10-01','2026-10-01','15:42','2.920','adminpusat','261001');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261001-0003','1','MTLT-ZIBI-3-0','1','1.600','TOKO','BKLTMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZIBI-3-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTLT-ZIBI-3-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLTMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLTMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTLT-ZIBI-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.590' WHERE kode_barang='MTLT-ZIBI-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261001-0003','2026-10-01','2026-10-01','15:42','1.600','adminpusat','261001');