INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260731-0001','1','F3E-ZECX-56-T','1','0.530','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZECX-56-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-ZECX-56-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-F';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3E-ZECX-56-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.530',berat_out_asli='0.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.530',berat_akhir_asli =berat_akhir_asli-'0.530' WHERE kode_barang='F3E-ZECX-56-T' 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-260731-0001','2026-07-31','2026-07-31','07:48','0.530','input','260731');
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-20260731-0001','1','A1D-ZGCX-14-0','1','1.570','1.570','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZGCX-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZGCX-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-07-31 07:49:34' WHERE kode_barang='A1D-ZGCX-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZGCX-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-07-31 07:49:34','TOKO','SMBK-A','A1D','A1D-ZGCX-14-0','1','1.570','1.570','1','1.570','1.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZGCX-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZGCX-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-20260731-0001','1','A1D-ZGCX-19-0','1','0.930','0.930','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZGCX-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZGCX-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-07-31 07:49:35' WHERE kode_barang='A1D-ZGCX-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZGCX-19-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-07-31 07:49:35','TOKO','SMBK-A','A1D','A1D-ZGCX-19-0','1','0.930','0.930','1','0.930','0.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZGCX-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZGCX-19-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-20260731-0001','1','A1D-ZGCX-21-0','1','1.010','1.010','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZGCX-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZGCX-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-07-31 07:49:35' WHERE kode_barang='A1D-ZGCX-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZGCX-21-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-07-31 07:49:35','TOKO','SMBK-A','A1D','A1D-ZGCX-21-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZGCX-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZGCX-21-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-20260731-0001','1','A1E-ZGCX-26-0','1','0.450','0.450','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZGCX-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZGCX-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-07-31 07:49:35' WHERE kode_barang='A1E-ZGCX-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZGCX-26-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-07-31 07:49:35','TOKO','SMBK-A','A1E','A1E-ZGCX-26-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZGCX-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZGCX-26-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260731-0001','2026-07-31','07:49','3.960','input','2026-07-31 07:49:34');
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-20260731-0001','1','B1G-ZGCX-34-0','1','0.260','0.260','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1G-ZGCX-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZGCX-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-07-31 07:50:37' WHERE kode_barang='B1G-ZGCX-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZGCX-34-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-07-31 07:50:37','TOKO','SMBK-B','B1G','B1G-ZGCX-34-0','1','0.260','0.260','1','0.260','0.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1G-ZGCX-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZGCX-34-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-20260731-0001','1','B1G-ZGCX-35-0','1','0.250','0.250','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1G-ZGCX-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZGCX-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-07-31 07:50:37' WHERE kode_barang='B1G-ZGCX-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZGCX-35-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-07-31 07:50:37','TOKO','SMBK-B','B1G','B1G-ZGCX-35-0','1','0.250','0.250','1','0.250','0.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1G-ZGCX-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZGCX-35-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-20260731-0001','1','B1F-ZGCX-36-0','1','0.320','0.320','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1F-ZGCX-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1F-ZGCX-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-07-31 07:50:37' WHERE kode_barang='B1F-ZGCX-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1F-ZGCX-36-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-07-31 07:50:37','TOKO','SMBK-B','B1F','B1F-ZGCX-36-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1F-ZGCX-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1F-ZGCX-36-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-20260731-0001','1','B1E-ZGCX-37-0','1','0.500','0.500','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZGCX-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZGCX-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-07-31 07:50:37' WHERE kode_barang='B1E-ZGCX-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZGCX-37-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-07-31 07:50:37','TOKO','SMBK-B','B1E','B1E-ZGCX-37-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZGCX-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZGCX-37-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260731-0001','2026-07-31','07:50','1.330','input','2026-07-31 07:50:36');
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-20260731-0001','1','D1F-ZGCX-46-0','1','0.350','0.350','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZGCX-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZGCX-46-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-07-31 07:50:57' WHERE kode_barang='D1F-ZGCX-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZGCX-46-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-07-31 07:50:57','TOKO','SMBK-D','D1F','D1F-ZGCX-46-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZGCX-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZGCX-46-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-20260731-0001','1','D1E-ZGCX-47-0','1','0.470','0.470','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZGCX-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZGCX-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-07-31 07:50:57' WHERE kode_barang='D1E-ZGCX-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZGCX-47-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-07-31 07:50:57','TOKO','SMBK-D','D1E','D1E-ZGCX-47-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZGCX-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZGCX-47-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260731-0001','2026-07-31','07:50','0.820','input','2026-07-31 07:50:56');
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-20260731-0001','1','E1F-ZGBI-16-0','1','0.350','0.350','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGBI-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGBI-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1F-ZGBI-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGBI-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-07-31 07:51:15','TOKO','SMBK-E','E1F','E1F-ZGBI-16-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZGBI-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGBI-16-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-20260731-0001','1','E2D-ZGCX-172-0','1','1.360','1.360','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGCX-172-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGCX-172-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E2D-ZGCX-172-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGCX-172-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-07-31 07:51:15','TOKO','SMBK-E','E2D','E2D-ZGCX-172-0','1','1.360','1.360','1','1.360','1.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZGCX-172-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGCX-172-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-20260731-0001','1','E2D-ZGCX-173-0','1','1.150','1.150','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGCX-173-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGCX-173-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E2D-ZGCX-173-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGCX-173-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-07-31 07:51:15','TOKO','SMBK-E','E2D','E2D-ZGCX-173-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZGCX-173-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGCX-173-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-20260731-0001','1','E2D-ZGCX-174-0','1','0.870','0.870','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGCX-174-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGCX-174-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E2D-ZGCX-174-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGCX-174-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-07-31 07:51:15','TOKO','SMBK-E','E2D','E2D-ZGCX-174-0','1','0.870','0.870','1','0.870','0.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZGCX-174-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGCX-174-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-20260731-0001','1','E2E-ZGCX-175-0','1','0.520','0.520','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZGCX-175-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZGCX-175-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E2E-ZGCX-175-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZGCX-175-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-07-31 07:51:15','TOKO','SMBK-E','E2E','E2E-ZGCX-175-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZGCX-175-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZGCX-175-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-20260731-0001','1','E2E-ZGCX-176-0','1','0.510','0.510','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZGCX-176-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZGCX-176-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E2E-ZGCX-176-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZGCX-176-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-07-31 07:51:15','TOKO','SMBK-E','E2E','E2E-ZGCX-176-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZGCX-176-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZGCX-176-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-20260731-0001','1','E1E-ZGCX-177-0','1','0.680','0.680','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGCX-177-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGCX-177-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1E-ZGCX-177-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGCX-177-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-07-31 07:51:15','TOKO','SMBK-E','E1E','E1E-ZGCX-177-0','1','0.680','0.680','1','0.680','0.680','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZGCX-177-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGCX-177-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-20260731-0001','1','E1E-ZGCX-178-0','1','0.550','0.550','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGCX-178-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGCX-178-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1E-ZGCX-178-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGCX-178-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-07-31 07:51:15','TOKO','SMBK-E','E1E','E1E-ZGCX-178-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZGCX-178-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGCX-178-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-20260731-0001','1','E1F-ZGCX-179-0','1','0.370','0.370','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGCX-179-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-179-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1F-ZGCX-179-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGCX-179-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-07-31 07:51:15','TOKO','SMBK-E','E1F','E1F-ZGCX-179-0','1','0.370','0.370','1','0.370','0.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZGCX-179-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-179-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-20260731-0001','1','E1F-ZGCX-180-0','1','0.360','0.360','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGCX-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1F-ZGCX-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGCX-180-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-07-31 07:51:15','TOKO','SMBK-E','E1F','E1F-ZGCX-180-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZGCX-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-180-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-20260731-0001','1','E1F-ZGCX-181-0','1','0.360','0.360','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGCX-181-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-181-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1F-ZGCX-181-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGCX-181-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-07-31 07:51:15','TOKO','SMBK-E','E1F','E1F-ZGCX-181-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZGCX-181-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-181-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-20260731-0001','1','E1F-ZGCX-182-0','1','0.350','0.350','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGCX-182-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-182-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1F-ZGCX-182-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGCX-182-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-07-31 07:51:15','TOKO','SMBK-E','E1F','E1F-ZGCX-182-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZGCX-182-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-182-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-20260731-0001','1','E1F-ZGCX-183-0','1','0.330','0.330','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGCX-183-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-183-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1F-ZGCX-183-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGCX-183-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-07-31 07:51:15','TOKO','SMBK-E','E1F','E1F-ZGCX-183-0','1','0.330','0.330','1','0.330','0.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZGCX-183-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-183-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-20260731-0001','1','E1D-ZGCX-184-0','1','1.560','1.560','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZGCX-184-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZGCX-184-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1D-ZGCX-184-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZGCX-184-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-07-31 07:51:15','TOKO','SMBK-E','E1D','E1D-ZGCX-184-0','1','1.560','1.560','1','1.560','1.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZGCX-184-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZGCX-184-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-20260731-0001','1','E1F-ZGCX-185-0','1','0.360','0.360','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGCX-185-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-185-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1F-ZGCX-185-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGCX-185-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-07-31 07:51:15','TOKO','SMBK-E','E1F','E1F-ZGCX-185-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZGCX-185-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-185-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-20260731-0001','1','E1F-ZGCX-186-0','1','0.320','0.320','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGCX-186-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-186-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 07:51:15' WHERE kode_barang='E1F-ZGCX-186-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGCX-186-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-07-31 07:51:15','TOKO','SMBK-E','E1F','E1F-ZGCX-186-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZGCX-186-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGCX-186-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260731-0001','2026-07-31','07:51','10.000','input','2026-07-31 07:51:14');
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-20260731-0001','1','F3E-ZGCX-91-0','1','2.030','2.030','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-91-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-91-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-91-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-91-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-91-0','1','2.030','2.030','1','2.030','2.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-91-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-91-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-20260731-0001','1','F3E-ZGCX-92-0','1','2.770','2.770','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-92-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-92-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-92-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-92-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-92-0','1','2.770','2.770','1','2.770','2.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-92-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-92-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-20260731-0001','1','F3E-ZGCX-93-0','1','1.760','1.760','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-93-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-93-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-93-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-93-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-93-0','1','1.760','1.760','1','1.760','1.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-93-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-93-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-20260731-0001','1','F3E-ZGCX-94-0','1','1.800','1.800','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-94-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-94-0','1','1.800','1.800','1','1.800','1.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-94-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-20260731-0001','1','F3E-ZGCX-95-0','1','2.150','2.150','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-95-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-95-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-95-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-95-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-95-0','1','2.150','2.150','1','2.150','2.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-95-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-95-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-20260731-0001','1','F3E-ZGCX-96-0','1','2.200','2.200','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-96-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-96-0','1','2.200','2.200','1','2.200','2.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-96-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-20260731-0001','1','F3E-ZGCX-97-0','1','3.080','3.080','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-97-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-97-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-97-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-97-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-97-0','1','3.080','3.080','1','3.080','3.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-97-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-97-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-20260731-0001','1','F3E-ZGCX-98-0','1','2.150','2.150','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-98-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-98-0','1','2.150','2.150','1','2.150','2.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-98-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-20260731-0001','1','F3E-ZGCX-99-0','1','1.450','1.450','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-99-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-99-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-99-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-99-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-99-0','1','1.450','1.450','1','1.450','1.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-99-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-99-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-20260731-0001','1','F3E-ZGCX-100-0','1','1.480','1.480','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-100-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-100-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-100-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-100-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-100-0','1','1.480','1.480','1','1.480','1.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-100-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-100-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-20260731-0001','1','F3E-ZGCX-101-0','1','1.020','1.020','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGCX-101-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-101-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F3E-ZGCX-101-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGCX-101-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-07-31 07:51:36','TOKO','SMBK-F','F3E','F3E-ZGCX-101-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGCX-101-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGCX-101-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-20260731-0001','1','F1E-ZGCX-119-0','1','3.010','3.010','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZGCX-119-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZGCX-119-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F1E-ZGCX-119-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZGCX-119-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-07-31 07:51:36','TOKO','SMBK-F','F1E','F1E-ZGCX-119-0','1','3.010','3.010','1','3.010','3.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZGCX-119-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZGCX-119-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-20260731-0001','1','F1E-ZGCX-120-0','1','3.450','3.450','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZGCX-120-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZGCX-120-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F1E-ZGCX-120-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZGCX-120-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-07-31 07:51:36','TOKO','SMBK-F','F1E','F1E-ZGCX-120-0','1','3.450','3.450','1','3.450','3.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZGCX-120-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZGCX-120-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-20260731-0001','1','F2E-ZGCX-121-0','1','2.980','2.980','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZGCX-121-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZGCX-121-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F2E-ZGCX-121-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZGCX-121-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-07-31 07:51:36','TOKO','SMBK-F','F2E','F2E-ZGCX-121-0','1','2.980','2.980','1','2.980','2.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZGCX-121-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZGCX-121-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-20260731-0001','1','F2E-ZGCX-122-0','1','1.180','1.180','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZGCX-122-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZGCX-122-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-31 07:51:36' WHERE kode_barang='F2E-ZGCX-122-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZGCX-122-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-07-31 07:51:36','TOKO','SMBK-F','F2E','F2E-ZGCX-122-0','1','1.180','1.180','1','1.180','1.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZGCX-122-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZGCX-122-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260731-0001','2026-07-31','07:51','32.510','input','2026-07-31 07:51:36');
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-20260731-0001','1','H1E-ZGCX-69-0','1','3.880','3.880','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGCX-69-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-69-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-31 07:51:57' WHERE kode_barang='H1E-ZGCX-69-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGCX-69-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-07-31 07:51:57','TOKO','SMBK-H','H1E','H1E-ZGCX-69-0','1','3.880','3.880','1','3.880','3.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZGCX-69-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-69-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-20260731-0001','1','H1E-ZGCX-70-0','1','2.020','2.020','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGCX-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-70-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-31 07:51:57' WHERE kode_barang='H1E-ZGCX-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGCX-70-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-07-31 07:51:57','TOKO','SMBK-H','H1E','H1E-ZGCX-70-0','1','2.020','2.020','1','2.020','2.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZGCX-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-70-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-20260731-0001','1','H1E-ZGCX-71-0','1','1.030','1.030','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGCX-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-31 07:51:57' WHERE kode_barang='H1E-ZGCX-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGCX-71-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-07-31 07:51:57','TOKO','SMBK-H','H1E','H1E-ZGCX-71-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZGCX-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-71-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-20260731-0001','1','H1E-ZGCX-72-0','1','3.020','3.020','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGCX-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-72-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-31 07:51:57' WHERE kode_barang='H1E-ZGCX-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGCX-72-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-07-31 07:51:57','TOKO','SMBK-H','H1E','H1E-ZGCX-72-0','1','3.020','3.020','1','3.020','3.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZGCX-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-72-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-20260731-0001','1','H1E-ZGCX-73-0','1','3.000','3.000','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGCX-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-31 07:51:57' WHERE kode_barang='H1E-ZGCX-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGCX-73-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-07-31 07:51:57','TOKO','SMBK-H','H1E','H1E-ZGCX-73-0','1','3.000','3.000','1','3.000','3.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZGCX-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-73-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-20260731-0001','1','H1E-ZGCX-74-0','1','2.080','2.080','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGCX-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-31 07:51:57' WHERE kode_barang='H1E-ZGCX-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGCX-74-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-07-31 07:51:57','TOKO','SMBK-H','H1E','H1E-ZGCX-74-0','1','2.080','2.080','1','2.080','2.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZGCX-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-74-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-20260731-0001','1','H1E-ZGCX-75-0','1','2.050','2.050','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGCX-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-31 07:51:57' WHERE kode_barang='H1E-ZGCX-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGCX-75-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-07-31 07:51:57','TOKO','SMBK-H','H1E','H1E-ZGCX-75-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZGCX-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGCX-75-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260731-0001','2026-07-31','07:51','17.080','input','2026-07-31 07:51:57');
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-20260731-0001','1','S1G-ZGCX-2-0','1','0.200','0.200','TOKO','SSBK-S','TOKO','SMBK-S');
DELETE FROM tm_barang WHERE kode_barang='S1G-ZGCX-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1G-ZGCX-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-S',tgl_last_beli='2026-07-31 07:52:13' WHERE kode_barang='S1G-ZGCX-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1G-ZGCX-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-07-31 07:52:13','TOKO','SMBK-S','S1G','S1G-ZGCX-2-0','1','0.200','0.200','1','0.200','0.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='S1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='S1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='S1G-ZGCX-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='S1G-ZGCX-2-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260731-0001','2026-07-31','07:52','0.200','input','2026-07-31 07:52:13');
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,status_otorisasi,harga_skrg) VALUES ('F226310830321','kasir','1',' MFE1 X 10K','TOKO','SMBK-E','E1F-ZGBI-16-0','CC X BLACK GOLD RING SLEP UB 14 8K ','OL','0.350','1','100.00','373000','0','0','15000','373000','0','8000','0','381000','TIN','00415776','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBI-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1F-ZGBI-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310830321','2026-07-31','0.350','2026-07-31','08:30:33','PLG0082842','373000','373000','8000','381000','381000','kasir','2026-07-31 08:30:32','F22631083032');
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-07-31','F226310830321','2026-07-31','08:30:33','TIN','381000','8000');
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-260731-0002','D','2026-07-31','08:30:33','kasir','PENJUALAN','F226310830321','12807440000','381000','12807821000');
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,status_otorisasi,harga_skrg) VALUES ('F226310849101','kasir','1',' TEE1 LG 14','TOKO','TBK-E','E1TE-ZGAG-19-T','CC MODEL BANGKOK SLEP LG 14 17K ','OL','0.500','1','100.00','950000','0','0','15000','960000','0','7000','0','967000','LUS','T0081242','E1TE','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZGAG-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1TE-ZGAG-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' 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 ('F226310849101','2026-07-31','0.500','2026-07-31','08:49:10','PLG0082843','960000','960000','7000','967000','967000','kasir','2026-07-31 08:49:10','F22631084910');
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-07-31','F226310849101','2026-07-31','08:49:10','LUS','967000','7000');
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-260731-0003','D','2026-07-31','08:49:10','kasir','PENJUALAN','F226310849101','12807821000','967000','12808788000');
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,status_otorisasi,harga_skrg) VALUES ('F226310900331','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZFBE-39-T','CC MODEL SLEP CM 14 8K ','','0.510','1','100.00','530000','0','0','15000','533000','0','0','0','533000','RHM','T0080781','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1E-ZFBE-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310900331','2026-07-31','0.510','2026-07-31','09:00:34','PLG0082844','533000','533000','0','533000','533000','kasir','2026-07-31 09:00:33','F22631090033');
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-07-31','F226310900331','2026-07-31','09:00:34','RHM','533000','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-260731-0004','D','2026-07-31','09:00:34','kasir','PENJUALAN','F226310900331','12808788000','533000','12809321000');
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,status_otorisasi,harga_skrg) VALUES ('F226310925031','kasir','1',' TFH2 X UB ','TOKO','TBK-H','H2TF-XDXI-75-T','KL X CARENDELANO ALPHABET UB V 17K ','OLS 0F92M','2.660','1','100.00','5107000','0','0','15000','5166000','0','325000','0','5491000','DIN','T0056246','H2TF','0','0','-','0','1920000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2TF-XDXI-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.660',berat_jual_asli=berat_jual_asli+'2.660',stock_jual='1',berat_akhir=berat_akhir-'2.660',berat_akhir_asli=berat_akhir_asli-'2.660',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='H2TF-XDXI-75-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' 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 ('F226310925031','2026-07-31','2.660','2026-07-31','09:25:04','PLG0082845','5166000','5166000','325000','5491000','5491000','kasir','2026-07-31 09:25:03','F22631092503');
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-07-31','F226310925031','2026-07-31','09:25:04','DIN','5491000','325000');
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-260731-0005','D','2026-07-31','09:25:04','kasir','PENJUALAN','F226310925031','12809321000','5491000','12814812000');
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,status_otorisasi,harga_skrg) VALUES ('F226310927051','kasir','1',' MEH1 UB 40','TOKO','SMBK-H','H1E-ZBAG-10-T','KL MILANO UB 40CM 8K ','OLS SBKE4','3.030','1','100.00','3151000','0','0','15000','3318000','0','265000','0','3583000','DIN','T0077452','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAG-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='H1E-ZBAG-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226310927051','2026-07-31','3.030','2026-07-31','09:27:06','PLG0082846','3318000','3318000','265000','3583000','3583000','kasir','2026-07-31 09:27:05','F22631092705');
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-07-31','F226310927051','2026-07-31','09:27:06','DIN','3583000','265000');
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-260731-0006','D','2026-07-31','09:27:06','kasir','PENJUALAN','F226310927051','12814812000','3583000','12818395000');
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,status_otorisasi,harga_skrg) VALUES ('F226310945021','kasir','1',' MDE1D BM 1','TOKO','SMBK-E','E1D-ZGAA-20-T','CC MODEL C SLEP BM 18 8K ','OL','1.030','1','100.00','1051000','0','0','15000','1061000','0','5000','0','1066000','TIN','T0081031','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGAA-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1D-ZGAA-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310945021','2026-07-31','1.030','2026-07-31','09:45:02','PLG0082847','1061000','1061000','5000','1066000','0','kasir','2026-07-31 09:45:02','F22631094502');
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-07-31','F226310945021','2026-07-31','09:45:02','TIN','1066000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260731-0001','2026-07-31','2026-07-31 09:45:02','PENJUALAN : F226310945021','47657676','BCA','1066000','1066000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260731-0002','D','2026-07-31','09:45:02','BCA','PENJUALAN','F226310945021','4651735888','1066000','4652801888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('47657676','ANGGI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1066000' WHERE no_faktur_jual='F226310945021' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226311008481','kasir','1',' MGD1G 5K B','TOKO','SMBK-D','D1G-ZGAA-49-T','LT CHARM BULAT SLEP BG 8K ','','0.380','1','100.00','410000','0','0','15000','412000','0','5000','0','417000','LUS','T0081060','D1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZGAA-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='D1G-ZGAA-49-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226311008481','2026-07-31','0.380','2026-07-31','10:08:48','PLG0082848','412000','412000','5000','417000','417000','kasir','2026-07-31 10:08:48','F22631100848');
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-07-31','F226311008481','2026-07-31','10:08:48','LUS','417000','5000');
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-260731-0007','D','2026-07-31','10:08:48','kasir','PENJUALAN','F226311008481','12818395000','417000','12818812000');
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,status_otorisasi,harga_skrg) VALUES ('F226311025331','kasir','1',' MEE2 X HA ','TOKO','SMBK-E','E2E-WHXH-133-0','CC X MODEL HURUF MATA HA 18 ','','1.250','1','100.00','1300000','0','0','15000','1306000','0','0','0','1306000','NOV','00247316','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-WHXH-133-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E2E-WHXH-133-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226311025331','2026-07-31','1.250','2026-07-31','10:25:33','PLG0082849','1306000','1306000','0','1306000','1306000','kasir','2026-07-31 10:25:33','F22631102533');
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-07-31','F226311025331','2026-07-31','10:25:33','NOV','1306000','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-260731-0008','D','2026-07-31','10:25:33','kasir','PENJUALAN','F226311025331','12818812000','1306000','12820118000');
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,status_otorisasi,harga_skrg) VALUES ('F226311026061','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZFAH-189-0','CC X MODEL MATA CM 12 8K ','OL','0.970','1','100.00','989000','0','0','15000','1004000','0','5000','0','1009000','TIN','00409196','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAH-189-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E2D-ZFAH-189-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226311026061','2026-07-31','0.970','2026-07-31','10:26:07','PLG0082850','1004000','1004000','5000','1009000','1009000','kasir','2026-07-31 10:26:06','F22631102606');
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-07-31','F226311026061','2026-07-31','10:26:07','TIN','1009000','5000');
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-260731-0009','D','2026-07-31','10:26:07','kasir','PENJUALAN','F226311026061','12820118000','1009000','12821127000');
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,status_otorisasi,harga_skrg) VALUES ('F226311026391','kasir','1',' MEE2 X HT ','TOKO','SMBK-E','E2E-ZFAH-200-0','CC X PIPI MATA HT 12 8K ','OL','0.600','1','100.00','624000','0','0','15000','633000','0','5000','0','638000','TIN','00409207','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZFAH-200-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E2E-ZFAH-200-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226311026391','2026-07-31','0.600','2026-07-31','10:26:39','PLG0082851','633000','633000','5000','638000','0','kasir','2026-07-31 10:26:39','F22631102639');
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-07-31','F226311026391','2026-07-31','10:26:39','TIN','638000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260731-0002','2026-07-31','2026-07-31 10:26:39','PENJUALAN : F226311026391','454756767','BCA','638000','638000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260731-0003','D','2026-07-31','10:26:39','BCA','PENJUALAN','F226311026391','4652801888','638000','4653439888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('454756767','YULIANINGSIH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='638000' WHERE no_faktur_jual='F226311026391' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226311027051','kasir','1',' MEF2E PM 5','TOKO','SMBK-F','F2E-ZGAX-23-T','GL PIPA MATA PM 56 8K ','OL','2.960','1','100.00','3078000','0','0','15000','3108000','0','15000','0','3123000','TIN','T0080983','F2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZGAX-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='F2E-ZGAX-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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 ('F226311027051','2026-07-31','2.960','2026-07-31','10:27:06','PLG0082852','3108000','3108000','15000','3123000','0','kasir','2026-07-31 10:27:05','F22631102705');
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-07-31','F226311027051','2026-07-31','10:27:06','TIN','3123000','15000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260731-0003','2026-07-31','2026-07-31 10:27:05','PENJUALAN : F226311027051','7465746757','BCA','3123000','3123000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260731-0004','D','2026-07-31','10:27:06','BCA','PENJUALAN','F226311027051','4653439888','3123000','4656562888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('7465746757','YULIANNGSIH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3123000' WHERE no_faktur_jual='F226311027051' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226311047211','kasir','1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZGAD-25-T','GL OVAL C SLEP TD 54 8K ','OL','3.020','1','100.00','3141000','0','0','15000','3171000','0','15000','0','3186000','LUS','T0081102','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAD-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='F1E-ZGAD-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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 ('F226311047211','2026-07-31','3.020','2026-07-31','10:47:21','PLG0082853','3171000','3171000','15000','3186000','3186000','kasir','2026-07-31 10:47:21','F22631104721');
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-07-31','F226311047211','2026-07-31','10:47:21','LUS','3186000','15000');
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 ('KM-260731-0010','D','2026-07-31','10:47:21','kasir','PENJUALAN','F226311047211','12821127000','3186000','12824313000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3186000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226311047211' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226311047212','kasir',' 1',' MEF1E PM 5','TOKO','SMBK-F','F1E-ZFBD-13-T','GL OVAL VERONA SLEP PM 54 8K ','OL','3.110','1','100.00','3234000','0','0','15000','3265000','0','16000','0','3281000','LUS','T0080701','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFBD-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='F1E-ZFBD-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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 ('F226311047212','2026-07-31','3.110','2026-07-31','10:47:21','PLG0082854','3265000','3265000','16000','3281000','3281000','kasir','2026-07-31 10:47:21','F22631104721');
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-07-31','F226311047212','2026-07-31','10:47:21','LUS','3281000','16000');
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 ('KM-260731-0011','D','2026-07-31','10:47:21','kasir','PENJUALAN','F226311047212','12824313000','3281000','12827594000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3281000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226311047212' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226311126421','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFXE-25-T','CC MDOEL ISYANA SLEP LG 12 8K ','','0.420','1','100.00','437000','0','0','15000','439000','0','0','0','439000','RHM','T0080327','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXE-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1E-ZFXE-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226311126421','2026-07-31','0.420','2026-07-31','11:26:43','PLG0082855','439000','439000','0','439000','439000','kasir','2026-07-31 11:26:42','F22631112642');
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-07-31','F226311126421','2026-07-31','11:26:43','RHM','439000','0');
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 ('KM-260731-0012','D','2026-07-31','11:26:43','kasir','PENJUALAN','F226311126421','12827594000','439000','12828033000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='439000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226311126421' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226311126422','kasir',' 1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBD-23-T','CC MODEL SPECTRA SLEP KH 12 8K ','','0.370','1','100.00','392000','0','0','15000','394000','0','0','0','394000','RHM','T0081450','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBD-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1F-ZGBD-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226311126422','2026-07-31','0.370','2026-07-31','11:26:43','PLG0082856','394000','394000','0','394000','394000','kasir','2026-07-31 11:26:42','F22631112642');
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-07-31','F226311126422','2026-07-31','11:26:43','RHM','394000','0');
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 ('KM-260731-0013','D','2026-07-31','11:26:43','kasir','PENJUALAN','F226311126422','12828033000','394000','12828427000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='394000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226311126422' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226311217441','kasir','1',' MEF3F YT ','TOKO','SMBK-F','F3E-ZGBD-147-T','GL TIFF VAR SLEP YT 8K ','','1.900','1','100.00','1976000','0','0','15000','1986000','0','0','0','1986000','LUS','T0081574','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-147-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='F3E-ZGBD-147-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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 ('F226311217441','2026-07-31','1.900','2026-07-31','12:17:45','PLG0082857','1986000','1986000','0','1986000','1986000','kasir','2026-07-31 12:17:44','F22631121744');
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-07-31','F226311217441','2026-07-31','12:17:45','LUS','1986000','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-260731-0014','D','2026-07-31','12:17:45','kasir','PENJUALAN','F226311217441','12828427000','1986000','12830413000');
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,status_otorisasi,harga_skrg) VALUES ('F226311245451','kasir','1',' TED1 X UB ','TOKO','TBK-D','D1TE-ZGBH-14-T','LT X MODEL HATI ARESO SLEP UB 17K ','','0.500','1','100.00','950000','0','0','15000','960000','0','7000','0','967000','LUS','T0081614','D1TE','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TE-ZGBH-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='D1TE-ZGBH-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' 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 ('F226311245451','2026-07-31','0.500','2026-07-31','12:45:45','PLG0082858','960000','960000','7000','967000','967000','kasir','2026-07-31 12:45:45','F22631124545');
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-07-31','F226311245451','2026-07-31','12:45:45','LUS','967000','7000');
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 ('KM-260731-0015','D','2026-07-31','12:45:45','kasir','PENJUALAN','F226311245451','12830413000','967000','12831380000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='967000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226311245451' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226311245452','kasir',' 1',' TEE2 X HT ','TOKO','TBK-E','E2TE-ZGBH-23-T','CC X MODEL MATA SLEP HT 14 17K ','','0.610','1','100.00','1159000','0','0','15000','1171000','0','7000','0','1178000','LUS','T0081623','E2TE','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-ZGBH-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E2TE-ZGBH-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' 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 ('F226311245452','2026-07-31','0.610','2026-07-31','12:45:45','PLG0082859','1171000','1171000','7000','1178000','1178000','kasir','2026-07-31 12:45:45','F22631124545');
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-07-31','F226311245452','2026-07-31','12:45:45','LUS','1178000','7000');
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 ('KM-260731-0016','D','2026-07-31','12:45:45','kasir','PENJUALAN','F226311245452','12831380000','1178000','12832558000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1178000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226311245452' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310102291','kasir','1',' MEB1E CM P','TOKO','SMBK-B','B1E-ZGAD-50-T','GW MODEL HATI SLEP CM PE 8K ','','0.600','1','100.00','624000','0','0','15000','627000','0','0','0','627000','NOV','T0081127','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAD-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='B1E-ZGAD-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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 ('F226310102291','2026-07-31','0.600','2026-07-31','13:02:30','PLG0082860','627000','627000','0','627000','0','kasir','2026-07-31 13:02:29','F22631010229');
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-07-31','F226310102291','2026-07-31','13:02:30','NOV','627000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260731-0004','2026-07-31','2026-07-31 13:02:29','PENJUALAN : F226310102291','344556879890','BCA','627000','627000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260731-0005','D','2026-07-31','13:02:30','BCA','PENJUALAN','F226310102291','4656562888','627000','4657189888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('344556879890','DIANING');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='627000' WHERE no_faktur_jual='F226310102291' LIMIT 1;
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-20260731-0001','1','E1E-ZGAX-75-0','1','0.560','0.560','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGAX-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGAX-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-31 13:45:52' WHERE kode_barang='E1E-ZGAX-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGAX-75-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-07-31 13:45:52','TOKO','SMBK-E','E1E','E1E-ZGAX-75-0','1','0.560','0.560','1','0.560','0.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZGAX-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGAX-75-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260731-0001','2026-07-31','13:45','0.560','input','2026-07-31 13:45:51');
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,status_otorisasi,harga_skrg) VALUES ('F226310204411','kasir','1',' MEH1 KH 44','TOKO','SMBK-H','H1E-ZDCX-40-T','KL RANTAI HOLLOW KH 44CM 8K ','','3.050','1','100.00','3172000','0','0','15000','3187000','0','0','0','3187000','NOV','T0079109','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDCX-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='H1E-ZDCX-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226310204411','2026-07-31','3.050','2026-07-31','14:04:42','PLG0082861','3187000','3187000','0','3187000','3187000','kasir','2026-07-31 14:04:41','F22631020441');
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-07-31','F226310204411','2026-07-31','14:04:42','NOV','3187000','0');
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 ('KM-260731-0017','D','2026-07-31','14:04:42','kasir','PENJUALAN','F226310204411','12832558000','3187000','12835745000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3187000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310204411' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310204412','kasir',' 1',' MEE2E CM 1','TOKO','SMBK-E','E2E-ZGAH-16-T','CC MODEL SOLITAIRE MATA SLEP CM 18 8K ','','0.720','1','100.00','749000','0','0','15000','752000','0','0','0','752000','NOV','T0081321','E2E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGAH-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E2E-ZGAH-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310204412','2026-07-31','0.720','2026-07-31','14:04:42','PLG0082862','752000','752000','0','752000','752000','kasir','2026-07-31 14:04:41','F22631020441');
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-07-31','F226310204412','2026-07-31','14:04:42','NOV','752000','0');
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 ('KM-260731-0018','D','2026-07-31','14:04:42','kasir','PENJUALAN','F226310204412','12835745000','752000','12836497000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='752000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310204412' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310204413','kasir',' 1',' MED1 HTM ','TOKO','SMBK-D','D1E-ZEAB-33-T','LT MODEL SLEP VAR HTM 8K ','','0.700','1','100.00','728000','0','0','15000','732000','0','0','0','732000','NOV','T0079391','D1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEAB-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='D1E-ZEAB-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226310204413','2026-07-31','0.700','2026-07-31','14:04:42','PLG0082863','732000','732000','0','732000','732000','kasir','2026-07-31 14:04:41','F22631020441');
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-07-31','F226310204413','2026-07-31','14:04:42','NOV','732000','0');
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 ('KM-260731-0019','D','2026-07-31','14:04:42','kasir','PENJUALAN','F226310204413','12836497000','732000','12837229000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='732000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310204413' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310217521','kasir','1',' TDE1 X KH ','TOKO','TBK-E','E1TD-ZGBI-14-T','CC X MODEL SLEP KH 14 17K ','OL','1.350','1','100.00','2538000','0','0','15000','2556000','0','9000','0','2565000','LUS','T0081673','E1TD','0','0','-','0','1880000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-ZGBI-14-T' 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-07-31' AND kode_barang='E1TD-ZGBI-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' 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 ('F226310217521','2026-07-31','1.350','2026-07-31','14:17:53','PLG0082864','2556000','2556000','9000','2565000','2565000','kasir','2026-07-31 14:17:52','F22631021752');
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-07-31','F226310217521','2026-07-31','14:17:53','LUS','2565000','9000');
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-260731-0020','D','2026-07-31','14:17:53','kasir','PENJUALAN','F226310217521','12837229000','2565000','12839794000');
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,status_otorisasi,harga_skrg) VALUES ('F226310235001','kasir','1',' MFE1 X KH ','TOKO','SMBK-E','E1F-ZGCX-183-0','CC X MODEL ARESO SLEP KH 12 8K ','OL','0.330','1','100.00','351000','0','0','15000','356000','0','5000','0','361000','DIN','00416082','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGCX-183-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1F-ZGCX-183-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310235001','2026-07-31','0.330','2026-07-31','14:35:00','PLG0082865','356000','356000','5000','361000','361000','kasir','2026-07-31 14:35:00','F22631023500');
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-07-31','F226310235001','2026-07-31','14:35:00','DIN','361000','5000');
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 ('KM-260731-0021','D','2026-07-31','14:35:00','kasir','PENJUALAN','F226310235001','12839794000','361000','12840155000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='361000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310235001' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310235002','kasir',' 1',' MFE1 X KH ','TOKO','SMBK-E','E1F-ZGCX-182-0','CC X MODEL ARESO SLEP KH 14 8K ','OL','0.350','1','100.00','373000','0','0','15000','378000','0','5000','0','383000','DIN','00416081','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGCX-182-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1F-ZGCX-182-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310235002','2026-07-31','0.350','2026-07-31','14:35:00','PLG0082866','378000','378000','5000','383000','383000','kasir','2026-07-31 14:35:00','F22631023500');
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-07-31','F226310235002','2026-07-31','14:35:00','DIN','383000','5000');
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 ('KM-260731-0022','D','2026-07-31','14:35:00','kasir','PENJUALAN','F226310235002','12840155000','383000','12840538000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='383000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310235002' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310235003','kasir',' 1',' MFE1F HW 1','TOKO','SMBK-E','E1F-ZGBA-26-T','CC MODEL GELOMBANG SLEP HW 14 8K ','OL','0.360','1','100.00','382000','0','0','15000','389000','0','5000','0','394000','DIN','T0081396','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1F-ZGBA-26-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310235003','2026-07-31','0.360','2026-07-31','14:35:00','PLG0082867','389000','389000','5000','394000','394000','kasir','2026-07-31 14:35:00','F22631023500');
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-07-31','F226310235003','2026-07-31','14:35:00','DIN','394000','5000');
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 ('KM-260731-0023','D','2026-07-31','14:35:00','kasir','PENJUALAN','F226310235003','12840538000','394000','12840932000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='394000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310235003' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310235004','kasir',' 1',' MEE1 LG 22','TOKO','SMBK-E','E1E-ZGAX-75-0','CC MODEL DAUN SLEP LG 22 8K ','OL','0.560','1','100.00','585000','0','0','15000','594000','0','5000','0','599000','DIN','00413151','E1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAX-75-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E1E-ZGAX-75-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310235004','2026-07-31','0.560','2026-07-31','14:35:00','PLG0082868','594000','594000','5000','599000','599000','kasir','2026-07-31 14:35:00','F22631023500');
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-07-31','F226310235004','2026-07-31','14:35:00','DIN','599000','5000');
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 ('KM-260731-0024','D','2026-07-31','14:35:00','kasir','PENJUALAN','F226310235004','12840932000','599000','12841531000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='599000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310235004' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310235005','kasir',' 1',' MDE2 X TD ','TOKO','SMBK-E','E2D-ZGBA-227-0','CC X MODEL MATA TD 16 8K ','OL','1.010','1','100.00','1030000','0','0','15000','1045000','0','5000','0','1050000','DIN','00414709','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGBA-227-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E2D-ZGBA-227-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310235005','2026-07-31','1.010','2026-07-31','14:35:00','PLG0082869','1045000','1045000','5000','1050000','1050000','kasir','2026-07-31 14:35:00','F22631023500');
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-07-31','F226310235005','2026-07-31','14:35:00','DIN','1050000','5000');
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 ('KM-260731-0025','D','2026-07-31','14:35:00','kasir','PENJUALAN','F226310235005','12841531000','1050000','12842581000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1050000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310235005' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310237271','kasir','1',' MGD1G 5K B','TOKO','SMBK-D','D1G-ZGAE-33-T','LT CHARM BULAT SLEP BG 8K ','OL','0.370','1','100.00','400000','0','0','15000','407000','0','5000','0','412000','DIN','T0081178','D1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZGAE-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='D1G-ZGAE-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226310237271','2026-07-31','0.370','2026-07-31','14:37:27','PLG0082870','407000','407000','5000','412000','412000','kasir','2026-07-31 14:37:27','F22631023727');
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-07-31','F226310237271','2026-07-31','14:37:27','DIN','412000','5000');
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 ('KM-260731-0026','D','2026-07-31','14:37:27','kasir','PENJUALAN','F226310237271','12842581000','412000','12842993000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='412000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310237271' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310237272','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZGAE-32-T','LT CHARM BULAT SLEP BG 8K ','OL','0.400','1','100.00','424000','0','0','15000','432000','0','5000','0','437000','DIN','T0081177','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAE-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='D1F-ZGAE-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226310237272','2026-07-31','0.400','2026-07-31','14:37:27','PLG0082871','432000','432000','5000','437000','437000','kasir','2026-07-31 14:37:27','F22631023727');
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-07-31','F226310237272','2026-07-31','14:37:27','DIN','437000','5000');
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 ('KM-260731-0027','D','2026-07-31','14:37:27','kasir','PENJUALAN','F226310237272','12842993000','437000','12843430000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='437000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310237272' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310237273','kasir',' 1',' MDD2 X CM ','TOKO','SMBK-D','D2D-ZCXC-113-0','LT X MODEL MATA CM 8K ','OL','0.910','1','100.00','928000','0','0','15000','946000','0','5000','0','951000','DIN','00391916','D2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZCXC-113-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='D2D-ZCXC-113-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' 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 ('F226310237273','2026-07-31','0.910','2026-07-31','14:37:27','PLG0082872','946000','946000','5000','951000','951000','kasir','2026-07-31 14:37:27','F22631023727');
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-07-31','F226310237273','2026-07-31','14:37:27','DIN','951000','5000');
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 ('KM-260731-0028','D','2026-07-31','14:37:27','kasir','PENJUALAN','F226310237273','12843430000','951000','12844381000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='951000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310237273' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310237274','kasir',' 1',' MGB1G X CM','TOKO','SMBK-B','B1G-ZGCX-34-0','GW X TUSUK DAISY MATA CM 8K ','OL','0.260','1','100.00','282000','0','0','15000','286000','0','5000','0','291000','DIN','00415933','B1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZGCX-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='B1G-ZGCX-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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 ('F226310237274','2026-07-31','0.260','2026-07-31','14:37:27','PLG0082873','286000','286000','5000','291000','291000','kasir','2026-07-31 14:37:27','F22631023727');
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-07-31','F226310237274','2026-07-31','14:37:27','DIN','291000','5000');
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 ('KM-260731-0029','D','2026-07-31','14:37:27','kasir','PENJUALAN','F226310237274','12844381000','291000','12844672000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='291000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310237274' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310237275','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZEXA-15-T','KL SANTA KH 42CM 8K ','OL','3.020','1','100.00','3141000','0','0','15000','3186000','0','15000','0','3201000','DIN','T0079127','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXA-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='H1E-ZEXA-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' 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 ('F226310237275','2026-07-31','3.020','2026-07-31','14:37:27','PLG0082874','3186000','3186000','15000','3201000','3201000','kasir','2026-07-31 14:37:27','F22631023727');
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-07-31','F226310237275','2026-07-31','14:37:27','DIN','3201000','15000');
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 ('KM-260731-0030','D','2026-07-31','14:37:27','kasir','PENJUALAN','F226310237275','12844672000','3201000','12847873000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3201000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226310237275' LIMIT 1;
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,status_otorisasi,harga_skrg) VALUES ('F226310240301','kasir','1',' MEF3E X LT','TOKO','SMBK-F','F3E-ZGXI-124-0','GL X TIFF SPECTRA VAR SLEP LT 8K ','OL','1.480','1','100.00','1539000','0','0','15000','1554000','0','7000','0','1561000','LUS','00412843','F3E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXI-124-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='F3E-ZGXI-124-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' 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 ('F226310240301','2026-07-31','1.480','2026-07-31','14:40:30','PLG0082875','1554000','1554000','7000','1561000','1561000','kasir','2026-07-31 14:40:30','F22631024030');
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-07-31','F226310240301','2026-07-31','14:40:30','LUS','1561000','7000');
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-260731-0031','D','2026-07-31','14:40:30','kasir','PENJUALAN','F226310240301','12847873000','1561000','12849434000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310102291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310102291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310102291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310204411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310204411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310204411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310204412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310204412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310204412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310204413' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310204413' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310204413';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310217521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310217521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310217521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310235001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310235002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310235003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310235004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310235005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310235005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310237271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310237272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237273' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237273' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310237273';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237274' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237274' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310237274';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237275' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310237275' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310237275';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310240301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310240301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310240301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310830321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310830321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310830321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310849101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310849101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310849101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310900331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310900331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310900331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310925031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310925031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310925031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310927051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310927051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310927051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310945021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310945021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310945021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311008481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311008481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311008481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311025331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311025331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311025331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311026061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311026061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311026061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311026391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311026391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311026391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311027051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311027051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311027051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311047211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311047211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311047211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311047212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311047212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311047212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311126421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311126421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311126421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311126422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311126422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311126422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311217441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311217441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311217441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311245451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311245451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311245451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226311245452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226311245452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226311245452';
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,status_otorisasi,harga_skrg) VALUES ('F226310328361','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZEBH-405-0','CC X SOLITAIRE MATA CM 14 8K ','','0.730','1','100.00','759000','0','0','15000','763000','0','0','0','763000','LUS','00405623','E2E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEBH-405-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E2E-ZEBH-405-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310328361','2026-07-31','0.730','2026-07-31','15:28:36','PLG0082876','763000','763000','0','763000','763000','kasir','2026-07-31 15:28:36','F22631032836');
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-07-31','F226310328361','2026-07-31','15:28:36','LUS','763000','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-260731-0032','D','2026-07-31','15:28:36','kasir','PENJUALAN','F226310328361','12849434000','763000','12850197000');
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-00005581','X-00005581','AT KLIP MODEL MATA VAR SB','GR','---','A1E','BELI','BELI001','920000','2026-07-31','1.300','1','kasir','2026-07-31 15:32:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005581','X-00005581');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260731-0001','F224240344261','NOV','1','BELI','BELI001','A1E', 'X-00005581', 'AT KLIP MODEL MATA VAR SB','1.820','1.300','100.00','892000','920000','707692','1040000','1','920000','920000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.300',berat_beli_asli=berat_beli_asli+'1.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.300',berat_akhir_asli=berat_akhir_asli+'1.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 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) VALUES ('FB-260731-0001','2026-07-31','2026-07-31','15:32:48','NOV','---','1.300','920000','920000','920000','920000','920000','kasir','2026-07-31 15:32:49','FB-260731-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260731-0001','ANDRI','GEMAHARJO PACITAN','','','087758965077','kasir','2026-07-31 15:32:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-31' 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) VALUES ('KK-260731-0033','K','2026-07-31','15:32:48','kasir','PEMBELIAN UMUM','FB-260731-0001','12850197000','920000','12849277000');
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-00005582','X-00005582','CC X MODEL MATA LG 12 8K','GR','---','E2E','BELI','BELI001','490000','2026-07-31','0.510','1','kasir','2026-07-31 15:33:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005582','X-00005582');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260731-0002','F226130212231','LUS','1','BELI','BELI001','E2E', 'X-00005582', 'CC X MODEL MATA LG 12 8K','0.510','0.510','100.00','538000','490000','960784','1040000','1','490000','490000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-31' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 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) VALUES ('FB-260731-0002','2026-07-31','2026-07-31','15:33:31','LUS','---','0.510','490000','490000','490000','490000','490000','kasir','2026-07-31 15:33:31','FB-260731-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260731-0002','DITA','TEGALOMBO PACITAN','','','087757322978','kasir','2026-07-31 15:33:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-31' 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) VALUES ('KK-260731-0034','K','2026-07-31','15:33:31','kasir','PEMBELIAN UMUM','FB-260731-0002','12849277000','490000','12848787000');
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,status_otorisasi,harga_skrg) VALUES ('F226310337201','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZGBA-219-0','CC X MODEL MATA CM 14 8K ','','0.960','1','100.00','979000','0','0','15000','984000','0','0','0','984000','NOV','00414701','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGBA-219-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-07-31' AND kode_barang='E2D-ZGBA-219-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' 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 ('F226310337201','2026-07-31','0.960','2026-07-31','15:37:21','PLG0082877','984000','984000','0','984000','0','kasir','2026-07-31 15:37:20','F22631033720');
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-07-31','F226310337201','2026-07-31','15:37:21','NOV','984000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260731-0005','2026-07-31','2026-07-31 15:37:20','PENJUALAN : F226310337201','34565678789','BCA','984000','984000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260731-0006','D','2026-07-31','15:37:21','BCA','PENJUALAN','F226310337201','4657189888','984000','4658173888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('34565678789','TRIANA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='984000' WHERE no_faktur_jual='F226310337201' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310328361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310328361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310328361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226310337201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226310337201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226310337201';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260731-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260731-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260731-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260731-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-31';
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-07-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-31';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-08-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-31' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-260801-0001','D','2026-08-01','16:17:07','SYSTEM','SALDO AWAL','SALDO AWAL','0','12848787000','12848787000');
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-260801-0001','D','2026-08-01','16:17:07','BCA','SALDO AWAL','SALDO AWAL','0','4658173888','4658173888');
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-260801-0001','D','2026-08-01','16:17:07','','SALDO AWAL','SALDO AWAL','0','2260000','2260000');
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-260801-0001','D','2026-08-01','16:17:07','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260801-0001','D','2026-08-01','16:17:07','BRI','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-260801-0001','D','2026-08-01','16:17:07','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-01';