INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-25 ','08:28:21');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-25','126','0','-142400000','126','0','-142400000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-25';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-24';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-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='2026-02-24' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-24';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-24';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-24';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-24';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-25' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-24' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260225-0001','D','2026-02-25','08:28:44','','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260225-0001','D','2026-02-25','08:28:44','BCA','SALDO AWAL','SALDO AWAL','0','1766548074','1766548074');
UPDATE tp_system SET tgl_system='2026-02-25';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-02-25 ','08:29:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-25 ','08:33:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-25 ','08:33:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-02-25 ','08:36:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-25 ','09:03:34');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260225-0001','1','X-00009218','BELI','BELI001','CN COR TDK BT LC2','1','1.600','1727000.00' ,'0.00','1727000','','1727000','1727000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-02-25 09:04:15' WHERE kode_barang='X-00009218' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009218' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009218' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.600',berat_hancur_asli=berat_hancur_asli+'1.600', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260225-0001','2','X-00009219','BELI','BELI001','CN COR BT MK','1','0.830','895500.00' ,'0.00','895500','','895500','4349500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-02-25 09:04:15' WHERE kode_barang='X-00009219' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009219' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009219' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.830',berat_hancur_asli=berat_hancur_asli+'0.830', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260225-0001','3','X-00009220','BELI','BELI001','AT JEPSI POLOS MK','1','0.970','1047000.00' ,'0.00','1047000','','1047000','6292000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-02-25 09:04:15' WHERE kode_barang='X-00009220' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009220' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009220' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'0.970',berat_hancur_asli=berat_hancur_asli+'0.970', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDAT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260225-0001','4','X-00009221','BELI','BELI001','GL RESIN 18CM KKT PER SHB','1','7.020','11575000.00' ,'0.00','11575000','','11575000','18914000','RONGSOK');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-02-25 09:04:15' WHERE kode_barang='X-00009221' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009221' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009221' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'7.020',berat_hancur_asli=berat_hancur_asli+'7.020', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'7.020',berat_akhir_asli=berat_akhir_asli-'7.020' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260225-0001','adminpusat','2026-02-25','2026-02-25','09:04:16','15244500','18914000', 'adminpusat','2026-02-25 09:04:15');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MDCN-ZBBC-1-0','1','0.830','0.830','TOKO','BCNMD','TOKO','BTCNMD');
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBBC-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDCN-ZBBC-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMD',tgl_last_beli='2026-02-25 09:10:11' WHERE kode_barang='MDCN-ZBBC-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDCN-ZBBC-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:10:11','TOKO','BTCNMD','MDCN','MDCN-ZBBC-1-0','1','0.830','0.820','1','0.830','0.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDCN-ZBBC-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDCN-ZBBC-1-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:09','0.830','cashier1','2026-02-25 09:10:11');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MSCN-ZBBC-7-0','1','1.350','1.350','TOKO','BCNMS','TOKO','BTCNMS');
DELETE FROM tm_barang WHERE kode_barang='MSCN-ZBBC-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MSCN-ZBBC-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMS',tgl_last_beli='2026-02-25 09:10:27' WHERE kode_barang='MSCN-ZBBC-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MSCN-ZBBC-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:10:27','TOKO','BTCNMS','MSCN','MSCN-ZBBC-7-0','1','1.350','1.340','1','1.350','1.340','100.00');
DELETE FROM tm_dept WHERE kode_dept='MSCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MSCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MSCN-ZBBC-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MSCN-ZBBC-7-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:10','1.350','cashier1','2026-02-25 09:10:26');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MDGL-ZBBC-2-0','1','2.190','2.190','TOKO','BGLMD','TOKO','BTGLMD');
DELETE FROM tm_barang WHERE kode_barang='MDGL-ZBBC-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGL-ZBBC-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMD',tgl_last_beli='2026-02-25 09:10:52' WHERE kode_barang='MDGL-ZBBC-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGL-ZBBC-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:10:52','TOKO','BTGLMD','MDGL','MDGL-ZBBC-2-0','1','2.190','2.180','1','2.190','2.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGL-ZBBC-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-ZBBC-2-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:10','2.190','cashier1','2026-02-25 09:10:51');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MDGW-ZBBC-3-0','1','0.480','0.480','TOKO','BGWMD','TOKO','BTGWMD');
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBBC-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDGW-ZBBC-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMD',tgl_last_beli='2026-02-25 09:11:14' WHERE kode_barang='MDGW-ZBBC-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDGW-ZBBC-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:11:14','TOKO','BTGWMD','MDGW','MDGW-ZBBC-3-0','1','0.480','0.470','1','0.480','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDGW-ZBBC-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDGW-ZBBC-3-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:10','0.480','cashier1','2026-02-25 09:11:13');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MTCN-ZBBC-8-0','1','2.570','2.570','TOKO','BKCNMT','TOKO','BTCNMT');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZBBC-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZBBC-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTCNMT',tgl_last_beli='2026-02-25 09:11:39' WHERE kode_barang='MTCN-ZBBC-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZBBC-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:11:39','TOKO','BTCNMT','MTCN','MTCN-ZBBC-8-0','1','2.570','2.560','1','2.570','2.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZBBC-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZBBC-8-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:11','2.570','cashier1','2026-02-25 09:11:39');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MTGL-ZBBC-9-0','1','3.100','3.100','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBBC-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBBC-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-25 09:11:59' WHERE kode_barang='MTGL-ZBBC-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBBC-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:11:59','TOKO','BTGLMT','MTGL','MTGL-ZBBC-9-0','1','3.100','3.090','1','3.100','3.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBBC-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBBC-9-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MTGL-ZBBC-10-0','1','2.190','2.190','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBBC-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBBC-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-25 09:11:59' WHERE kode_barang='MTGL-ZBBC-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBBC-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:11:59','TOKO','BTGLMT','MTGL','MTGL-ZBBC-10-0','1','2.190','2.180','1','2.190','2.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBBC-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBBC-10-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MTGL-ZBBC-11-0','1','2.810','2.810','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBBC-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBBC-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-25 09:11:59' WHERE kode_barang='MTGL-ZBBC-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBBC-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:11:59','TOKO','BTGLMT','MTGL','MTGL-ZBBC-11-0','1','2.810','2.800','1','2.810','2.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBBC-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBBC-11-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MTGL-ZBBC-12-0','1','11.800','11.800','TOKO','BKGLMT','TOKO','BTGLMT');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZBBC-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZBBC-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGLMT',tgl_last_beli='2026-02-25 09:11:59' WHERE kode_barang='MTGL-ZBBC-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZBBC-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:11:59','TOKO','BTGLMT','MTGL','MTGL-ZBBC-12-0','1','11.800','11.790','1','11.800','11.790','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZBBC-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZBBC-12-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:11','19.900','cashier1','2026-02-25 09:11:58');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MTGW-ZBBC-13-0','1','2.390','2.390','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBBC-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBBC-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-25 09:12:23' WHERE kode_barang='MTGW-ZBBC-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBBC-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:12:23','TOKO','BTGWMT','MTGW','MTGW-ZBBC-13-0','1','2.390','2.380','1','2.390','2.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZBBC-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBBC-13-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MTGW-ZBBC-14-0','1','1.100','1.100','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBBC-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBBC-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-25 09:12:23' WHERE kode_barang='MTGW-ZBBC-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBBC-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:12:23','TOKO','BTGWMT','MTGW','MTGW-ZBBC-14-0','1','1.100','1.090','1','1.100','1.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZBBC-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBBC-14-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MTGW-ZBBC-15-0','1','0.790','0.790','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZBBC-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZBBC-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-02-25 09:12:23' WHERE kode_barang='MTGW-ZBBC-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZBBC-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:12:23','TOKO','BTGWMT','MTGW','MTGW-ZBBC-15-0','1','0.790','0.780','1','0.790','0.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZBBC-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZBBC-15-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:12','4.280','cashier1','2026-02-25 09:12:22');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MTKL-ZBBC-16-0','1','3.040','3.040','TOKO','BKKLMT','TOKO','BTKLMT');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZBBC-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZBBC-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMT',tgl_last_beli='2026-02-25 09:12:43' WHERE kode_barang='MTKL-ZBBC-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZBBC-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:12:43','TOKO','BTKLMT','MTKL','MTKL-ZBBC-16-0','1','3.040','3.030','1','3.040','3.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZBBC-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZBBC-16-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:12','3.040','cashier1','2026-02-25 09:12:43');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MDKL-ZBBC-4-0','1','2.990','2.990','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBC-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBC-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-25 09:13:04' WHERE kode_barang='MDKL-ZBBC-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBC-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:13:04','TOKO','BTKLMD','MDKL','MDKL-ZBBC-4-0','1','2.990','2.980','1','2.990','2.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZBBC-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBC-4-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MDKL-ZBBC-5-0','1','1.980','1.980','TOKO','BKLMD','TOKO','BTKLMD');
DELETE FROM tm_barang WHERE kode_barang='MDKL-ZBBC-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDKL-ZBBC-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTKLMD',tgl_last_beli='2026-02-25 09:13:04' WHERE kode_barang='MDKL-ZBBC-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDKL-ZBBC-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:13:04','TOKO','BTKLMD','MDKL','MDKL-ZBBC-5-0','1','1.980','1.970','1','1.980','1.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDKL-ZBBC-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-ZBBC-5-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:12','4.970','cashier1','2026-02-25 09:13:03');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260225-0001','1','MDLT-ZBBC-6-0','1','0.630','0.630','TOKO','BLTMD','TOKO','BTLTMD');
DELETE FROM tm_barang WHERE kode_barang='MDLT-ZBBC-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MDLT-ZBBC-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMD',tgl_last_beli='2026-02-25 09:13:27' WHERE kode_barang='MDLT-ZBBC-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MDLT-ZBBC-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-02-25 09:13:27','TOKO','BTLTMD','MDLT','MDLT-ZBBC-6-0','1','0.630','0.620','1','0.630','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='MDLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MDLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MDLT-ZBBC-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MDLT-ZBBC-6-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260225-0001','2026-02-25','09:13','0.630','cashier1','2026-02-25 09:13:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-25 ','11:48:48');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009222','X-00009222','CN COR TDK BT SHB','GR','---','MTCN','BELI','BELI001','4778500','2026-02-25','2.550','1','sales','2026-02-25 12:45:35');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009222','X-00009222');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260225-0001','FJ-251010-0008','2602','1','BELI','BELI001','MTCN', 'X-00009222', 'CN COR TDK BT SHB','2.550','2.550','100.00','4182000','4778500','1873922','1','4778500','4778500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-02-25','BELI','BELI001','MTCN','MTCN','100.00','2.550','2.550','1','2.550','2.550','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260225-0001','2026-02-25','2026-02-25','12:45:34','2602','---','2.550','4778500','4778500','4778500','4778500','4778500','sales','2026-02-25 12:45:35','FB-260225-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260225-0001','KHOLILAH','DUPAK BANGUNSARI 1/37','','','','sales','2026-02-25 12:45:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-02-25' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260225-0002','K','2026-02-25','12:45:34','sales','PEMBELIAN UMUM','FB-260225-0001','192769056','4778500','187990556','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260225-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260225-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-25 ','14:16:04');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260225-0003','K','2026-02-25','14:24:40','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB ','187990556','51000','187939556');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260225-0001','sales','1',' ','TOKO','BTCNMD','MDCN-ZBXF-142-0','CN COR TDK BT SHB ','','1.350','1','100.00','1694500','0','0','0','1694500','0','0','0','1694500','2501','00027788','MDCN','175500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-02-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZBXF-142-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-02-25' AND kode_barang='MDCN-ZBXF-142-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('FJ-260225-0001','2026-02-25','1.350','2026-02-25','15:25:50','PLG0018151','1694500','1694500','0','1694500','1694500','sales','2026-02-25 15:25:50','FJ-260225-0001');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-02-25','FJ-260225-0001','2026-02-25','15:25:50','2501','1694500','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260225-0004','D','2026-02-25','15:25:50','sales','PENJUALAN','FJ-260225-0001','187939556','1694500','189634056');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260225-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260225-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260225-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-25 ','16:14:40');