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-20260618-0001','1','A1D-ZFAG-1-0','1','1.060','1.060','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZFAG-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZFAG-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-06-18 07:41:17' WHERE kode_barang='A1D-ZFAG-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZFAG-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-18 07:41:17','TOKO','SMBK-A','A1D','A1D-ZFAG-1-0','1','1.060','1.060','1','1.060','1.060','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-ZFAG-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZFAG-1-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-20260618-0001','1','A1D-ZFAG-5-0','1','1.000','1.000','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZFAG-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZFAG-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-06-18 07:41:17' WHERE kode_barang='A1D-ZFAG-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZFAG-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-18 07:41:17','TOKO','SMBK-A','A1D','A1D-ZFAG-5-0','1','1.000','1.000','1','1.000','1.000','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-ZFAG-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZFAG-5-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-20260618-0001','1','A1E-ZFAG-9-0','1','0.550','0.550','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFAG-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFAG-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-06-18 07:41:17' WHERE kode_barang='A1E-ZFAG-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFAG-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-18 07:41:17','TOKO','SMBK-A','A1E','A1E-ZFAG-9-0','1','0.550','0.550','1','0.550','0.550','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-ZFAG-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFAG-9-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260618-0001','1','A1E-ZFAG-10-0','1','0.480','0.480','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFAG-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFAG-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-06-18 07:41:17' WHERE kode_barang='A1E-ZFAG-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFAG-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-18 07:41:17','TOKO','SMBK-A','A1E','A1E-ZFAG-10-0','1','0.480','0.480','1','0.480','0.480','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-ZFAG-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFAG-10-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260618-0001','1','A1E-ZFAG-18-0','1','0.680','0.680','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFAG-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFAG-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-06-18 07:41:17' WHERE kode_barang='A1E-ZFAG-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFAG-18-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-06-18 07:41:17','TOKO','SMBK-A','A1E','A1E-ZFAG-18-0','1','0.680','0.680','1','0.680','0.680','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-ZFAG-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFAG-18-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-20260618-0001','1','A1E-ZFAG-19-0','1','0.520','0.520','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFAG-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFAG-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-06-18 07:41:17' WHERE kode_barang='A1E-ZFAG-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFAG-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-06-18 07:41:17','TOKO','SMBK-A','A1E','A1E-ZFAG-19-0','1','0.520','0.520','1','0.520','0.520','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-ZFAG-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFAG-19-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260618-0001','2026-06-18','07:41','4.290','input','2026-06-18 07:41:16');
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-20260618-0001','1','B1E-ZFAG-31-0','1','0.570','0.570','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZFAG-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-06-18 07:41:35' WHERE kode_barang='B1E-ZFAG-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZFAG-31-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-06-18 07:41:35','TOKO','SMBK-B','B1E','B1E-ZFAG-31-0','1','0.570','0.570','1','0.570','0.570','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-ZFAG-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-31-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-20260618-0001','1','B1E-ZFAG-32-0','1','0.570','0.570','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZFAG-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-06-18 07:41:35' WHERE kode_barang='B1E-ZFAG-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZFAG-32-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-06-18 07:41:35','TOKO','SMBK-B','B1E','B1E-ZFAG-32-0','1','0.570','0.570','1','0.570','0.570','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-ZFAG-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-32-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-20260618-0001','1','B1E-ZFAG-33-0','1','0.630','0.630','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZFAG-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-06-18 07:41:35' WHERE kode_barang='B1E-ZFAG-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZFAG-33-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-06-18 07:41:35','TOKO','SMBK-B','B1E','B1E-ZFAG-33-0','1','0.630','0.630','1','0.630','0.630','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-ZFAG-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-33-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-20260618-0001','1','B1E-ZFAG-34-0','1','0.460','0.460','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZFAG-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-06-18 07:41:35' WHERE kode_barang='B1E-ZFAG-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZFAG-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-06-18 07:41:35','TOKO','SMBK-B','B1E','B1E-ZFAG-34-0','1','0.460','0.460','1','0.460','0.460','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-ZFAG-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-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-20260618-0001','1','B1E-ZFAG-35-0','1','0.550','0.550','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZFAG-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-06-18 07:41:35' WHERE kode_barang='B1E-ZFAG-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZFAG-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-06-18 07:41:35','TOKO','SMBK-B','B1E','B1E-ZFAG-35-0','1','0.550','0.550','1','0.550','0.550','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-ZFAG-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-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-20260618-0001','1','B1E-ZFAG-36-0','1','0.600','0.600','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZFAG-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-06-18 07:41:35' WHERE kode_barang='B1E-ZFAG-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZFAG-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-06-18 07:41:35','TOKO','SMBK-B','B1E','B1E-ZFAG-36-0','1','0.600','0.600','1','0.600','0.600','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-ZFAG-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZFAG-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-20260618-0001','1','B1D-ZFAG-37-0','1','1.050','1.050','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZFAG-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZFAG-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-06-18 07:41:35' WHERE kode_barang='B1D-ZFAG-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZFAG-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-06-18 07:41:35','TOKO','SMBK-B','B1D','B1D-ZFAG-37-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' 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='B1D-ZFAG-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZFAG-37-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260618-0001','2026-06-18','07:41','4.430','input','2026-06-18 07:41:35');
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-20260618-0001','1','E1D-ZFAB-30-0','1','1.060','1.060','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFAB-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFAB-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-06-18 07:41:55' WHERE kode_barang='E1D-ZFAB-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFAB-30-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-06-18 07:41:55','TOKO','SMBK-E','E1D','E1D-ZFAB-30-0','1','1.060','1.060','1','1.060','1.060','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-ZFAB-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFAB-30-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260618-0001','2026-06-18','07:41','1.060','input','2026-06-18 07:41:54');
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-20260618-0001','1','F1E-ZFAG-64-0','1','1.710','1.710','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZFAG-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZFAG-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F1E-ZFAG-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZFAG-64-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-06-18 07:42:12','TOKO','SMBK-F','F1E','F1E-ZFAG-64-0','1','1.710','1.710','1','1.710','1.710','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-ZFAG-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZFAG-64-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-20260618-0001','1','F1E-ZFAG-65-0','1','3.690','3.690','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZFAG-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZFAG-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F1E-ZFAG-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZFAG-65-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-06-18 07:42:12','TOKO','SMBK-F','F1E','F1E-ZFAG-65-0','1','3.690','3.690','1','3.690','3.690','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-ZFAG-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZFAG-65-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-20260618-0001','1','F3E-ZFAG-167-0','1','3.120','3.120','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-167-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-167-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-167-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-167-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-167-0','1','3.120','3.120','1','3.120','3.120','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-ZFAG-167-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-167-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-20260618-0001','1','F3E-ZFAG-168-0','1','4.060','4.060','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-168-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-168-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-168-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-168-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-168-0','1','4.060','4.060','1','4.060','4.060','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-ZFAG-168-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-168-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-20260618-0001','1','F3E-ZFAG-169-0','1','1.100','1.100','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-169-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-169-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-169-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-169-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-169-0','1','1.100','1.100','1','1.100','1.100','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-ZFAG-169-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-169-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-20260618-0001','1','F3E-ZFAG-170-0','1','1.050','1.050','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-170-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-170-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-170-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-170-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-170-0','1','1.050','1.050','1','1.050','1.050','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-ZFAG-170-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-170-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-20260618-0001','1','F3E-ZFAG-171-0','1','1.300','1.300','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-171-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-171-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-171-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-171-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-171-0','1','1.300','1.300','1','1.300','1.300','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-ZFAG-171-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-171-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-20260618-0001','1','F3E-ZFAG-172-0','1','1.360','1.360','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-172-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-172-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-172-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-172-0','1','1.360','1.360','1','1.360','1.360','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-ZFAG-172-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-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-20260618-0001','1','F3E-ZFAG-173-0','1','1.750','1.750','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-173-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-173-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-173-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-173-0','1','1.750','1.750','1','1.750','1.750','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-ZFAG-173-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-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-20260618-0001','1','F3E-ZFAG-174-0','1','1.510','1.510','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-174-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-174-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-174-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-174-0','1','1.510','1.510','1','1.510','1.510','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-ZFAG-174-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-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-20260618-0001','1','F3E-ZFAG-175-0','1','1.680','1.680','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-175-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-175-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-175-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-175-0','1','1.680','1.680','1','1.680','1.680','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-ZFAG-175-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-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-20260618-0001','1','F3E-ZFAG-176-0','1','3.150','3.150','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-176-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-176-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-176-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-176-0','1','3.150','3.150','1','3.150','3.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-ZFAG-176-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-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-20260618-0001','1','F3E-ZFAG-177-0','1','1.770','1.770','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-177-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-177-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-177-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-177-0','1','1.770','1.770','1','1.770','1.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-ZFAG-177-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-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-20260618-0001','1','F3E-ZFAG-178-0','1','2.050','2.050','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-178-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-178-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-178-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-178-0','1','2.050','2.050','1','2.050','2.050','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-ZFAG-178-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-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-20260618-0001','1','F3E-ZFAG-179-0','1','1.930','1.930','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-179-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-179-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-179-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-179-0','1','1.930','1.930','1','1.930','1.930','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-ZFAG-179-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-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-20260618-0001','1','F3E-ZFAG-180-0','1','1.950','1.950','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-18 07:42:12' WHERE kode_barang='F3E-ZFAG-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-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-06-18 07:42:12','TOKO','SMBK-F','F3E','F3E-ZFAG-180-0','1','1.950','1.950','1','1.950','1.950','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-ZFAG-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-180-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260618-0001','2026-06-18','07:42','33.180','input','2026-06-18 07:42:11');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260618-0001','1','H1E-ZFAG-94-0','1','2.120','2.120','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAG-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-06-18 07:42:34' WHERE kode_barang='H1E-ZFAG-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAG-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-06-18 07:42:34','TOKO','SMBK-H','H1E','H1E-ZFAG-94-0','1','2.120','2.120','1','2.120','2.120','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-ZFAG-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-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-20260618-0001','1','H1E-ZFAG-95-0','1','2.100','2.100','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAG-95-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-95-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-06-18 07:42:34' WHERE kode_barang='H1E-ZFAG-95-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAG-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-06-18 07:42:34','TOKO','SMBK-H','H1E','H1E-ZFAG-95-0','1','2.100','2.100','1','2.100','2.100','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-ZFAG-95-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-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-20260618-0001','1','H1E-ZFAG-96-0','1','2.530','2.530','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAG-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-06-18 07:42:34' WHERE kode_barang='H1E-ZFAG-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAG-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-06-18 07:42:34','TOKO','SMBK-H','H1E','H1E-ZFAG-96-0','1','2.530','2.530','1','2.530','2.530','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-ZFAG-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-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-20260618-0001','1','H1E-ZFAG-97-0','1','2.160','2.160','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAG-97-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-97-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-06-18 07:42:34' WHERE kode_barang='H1E-ZFAG-97-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAG-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-06-18 07:42:34','TOKO','SMBK-H','H1E','H1E-ZFAG-97-0','1','2.160','2.160','1','2.160','2.160','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-ZFAG-97-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-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-20260618-0001','1','H1E-ZFAG-98-0','1','1.140','1.140','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAG-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-06-18 07:42:34' WHERE kode_barang='H1E-ZFAG-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAG-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-06-18 07:42:34','TOKO','SMBK-H','H1E','H1E-ZFAG-98-0','1','1.140','1.140','1','1.140','1.140','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-ZFAG-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-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-20260618-0001','1','H1E-ZFAG-99-0','1','1.000','1.000','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAG-99-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-99-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-06-18 07:42:34' WHERE kode_barang='H1E-ZFAG-99-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAG-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-06-18 07:42:34','TOKO','SMBK-H','H1E','H1E-ZFAG-99-0','1','1.000','1.000','1','1.000','1.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-ZFAG-99-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-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-20260618-0001','1','H1E-ZFAG-100-0','1','1.300','1.300','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAG-100-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-100-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-06-18 07:42:34' WHERE kode_barang='H1E-ZFAG-100-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAG-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-06-18 07:42:34','TOKO','SMBK-H','H1E','H1E-ZFAG-100-0','1','1.300','1.300','1','1.300','1.300','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-ZFAG-100-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-100-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260618-0001','2026-06-18','07:42','12.350','input','2026-06-18 07:42:33');
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-20260618-0001','1','S1F-ZFAG-40-0','1','0.350','0.350','TOKO','SSBK-S','TOKO','SMBK-S');
DELETE FROM tm_barang WHERE kode_barang='S1F-ZFAG-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1F-ZFAG-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-S',tgl_last_beli='2026-06-18 07:42:53' WHERE kode_barang='S1F-ZFAG-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1F-ZFAG-40-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-06-18 07:42:53','TOKO','SMBK-S','S1F','S1F-ZFAG-40-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='S1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='S1F' 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='S1F-ZFAG-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='S1F-ZFAG-40-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260618-0001','2026-06-18','07:42','0.350','input','2026-06-18 07:42:52');
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 ('F226180914091','kasir','1',' MFB1F LG ','TOKO','SMBK-B','B1F-ZFAF-61-T','GW TUSUK MATA LG 8K','OL','0.300','1','100.00','343000','0','0','15000','345000','0','5000','0','350000','LUS','T0080496','B1F','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZFAF-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='B1F-ZFAF-61-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 ('F226180914091','2026-06-18','0.300','2026-06-18','09:14:09','PLG0081192','345000','345000','5000','350000','350000','kasir','2026-06-18 09:14:09','F22618091409');
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-06-18','F226180914091','2026-06-18','09:14:09','LUS','350000','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-260618-0002','D','2026-06-18','09:14:09','kasir','PENJUALAN','F226180914091','10948653000','350000','10949003000');
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 ('F226180959471','kasir','1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZFAF-3-T','GW TIFF PANJANG VAR CAT HITAM SLEP HW 8K ','OL','0.530','1','100.00','596000','0','0','15000','600000','0','5000','0','605000','LUS','T0080438','B1E','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFAF-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='B1E-ZFAF-3-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 ('F226180959471','2026-06-18','0.530','2026-06-18','09:59:48','PLG0081193','600000','600000','5000','605000','605000','kasir','2026-06-18 09:59:47','F22618095947');
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-06-18','F226180959471','2026-06-18','09:59:48','LUS','605000','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-260618-0003','D','2026-06-18','09:59:48','kasir','PENJUALAN','F226180959471','10949003000','605000','10949608000');
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 ('F226181001571','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZFAB-30-0','CC VELG POLOS CM 16 8K ','OL','1.060','1','100.00','1171000','0','0','15000','1177000','0','5000','0','1182000','LUS','00408499','E1D','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAB-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='E1D-ZFAB-30-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 ('F226181001571','2026-06-18','1.060','2026-06-18','10:01:58','PLG0081194','1177000','1177000','5000','1182000','1182000','kasir','2026-06-18 10:01:57','F22618100157');
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-06-18','F226181001571','2026-06-18','10:01:58','LUS','1182000','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-260618-0004','D','2026-06-18','10:01:58','kasir','PENJUALAN','F226181001571','10949608000','1182000','10950790000');
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 ('F226181005091','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFAF-11-T','GL MODEL SIEM SLEP UB 8K ','OL','0.570','1','100.00','641000','0','0','15000','647000','0','5000','0','652000','TIN','T0080446','F3E','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAF-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='F3E-ZFAF-11-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 ('F226181005091','2026-06-18','0.570','2026-06-18','10:05:09','PLG0081195','647000','647000','5000','652000','652000','kasir','2026-06-18 10:05:09','F22618100509');
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-06-18','F226181005091','2026-06-18','10:05:09','TIN','652000','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-260618-0005','D','2026-06-18','10:05:09','kasir','PENJUALAN','F226181005091','10950790000','652000','10951442000');
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 ('F226181005531','kasir','1',' MFA1F DG ','TOKO','SMBK-A','A1F-ZFAF-25-T','AT TINDIK BABY DG 8K ','OL','0.250','1','100.00','286000','0','0','15000','290000','0','5000','0','295000','TIN','T0080460','A1F','0','0','-','0','1140000');
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 ('F226181006231','kasir','1',' MFA1F DG ','TOKO','SMBK-A','A1F-ZFAF-25-T','AT TINDIK BABY DG 8K ','OL','0.250','1','100.00','286000','0','0','15000','290000','0','5000','0','295000','TIN','T0080460','A1F','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-ZFAF-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='A1F-ZFAF-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226181006231','2026-06-18','0.250','2026-06-18','10:06:24','PLG0081197','290000','290000','5000','295000','295000','kasir','2026-06-18 10:06:23','F22618100623');
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-06-18','F226181006231','2026-06-18','10:06:24','TIN','295000','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-260618-0006','D','2026-06-18','10:06:24','kasir','PENJUALAN','F226181006231','10951442000','295000','10951737000');
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 ('F226181021371','kasir','1',' TDE2 X HK ','TOKO','TBK-E','E2TD-YFBF-88-T','CC X MODEL MATA VAR HK 10 17K ','','1.370','1','100.00','2767000','0','0','15000','2740000','0','0','0','2740000','LUS','T0070455','E2TD','0','0','-','1','2020000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YFBF-88-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='E2TD-YFBF-88-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 ('F226181021371','2026-06-18','1.370','2026-06-18','10:21:38','PLG0081198','2740000','2740000','0','2740000','2740000','kasir','2026-06-18 10:21:37','F22618102137');
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-06-18','F226181021371','2026-06-18','10:21:38','LUS','2740000','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-260618-0007','D','2026-06-18','10:21:38','kasir','PENJUALAN','F226181021371','10951737000','2740000','10954477000');
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 ('F226181031151','kasir','1',' MDE1 X CM ','TOKO','SMBK-E','E1D-ZFXA-24-0','CC X MODEL SLEP CM 20 8K ','OL','1.260','1','100.00','1392000','0','0','15000','1386000','0','6000','0','1392000','TIN','00406192','E1D','0','0','-','1','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXA-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='E1D-ZFXA-24-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 ('F226181031151','2026-06-18','1.260','2026-06-18','10:31:15','PLG0081199','1386000','1386000','6000','1392000','1392000','kasir','2026-06-18 10:31:15','F22618103115');
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-06-18','F226181031151','2026-06-18','10:31:15','TIN','1392000','6000');
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-260618-0008','D','2026-06-18','10:31:15','kasir','PENJUALAN','F226181031151','10954477000','1392000','10955869000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1392000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181031151' 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 ('F226181031152','kasir',' 1',' MEB1E LG P','TOKO','SMBK-B','B1E-ZFAF-64-T','GW MODEL PITA SLEP LG 8K','OL','0.500','1','100.00','562000','0','0','15000','563000','0','5000','0','568000','TIN','T0080499','B1E','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFAF-64-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-06-18' AND kode_barang='B1E-ZFAF-64-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 ('F226181031152','2026-06-18','0.500','2026-06-18','10:31:15','PLG0081200','563000','563000','5000','568000','568000','kasir','2026-06-18 10:31:15','F22618103115');
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-06-18','F226181031152','2026-06-18','10:31:15','TIN','568000','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-260618-0009','D','2026-06-18','10:31:15','kasir','PENJUALAN','F226181031152','10955869000','568000','10956437000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='568000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181031152' 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 ('F226181031153','kasir',' 1',' MFD2F X BW','TOKO','SMBK-D','D2F-YHBH-22-0','LT X SLOBOK BONEKA MATA BW 8K ','OL','0.570','1','100.00','653000','0','0','15000','653000','0','5000','0','658000','TIN','00367008','D2F','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-YHBH-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='D2F-YHBH-22-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 ('F226181031153','2026-06-18','0.570','2026-06-18','10:31:15','PLG0081201','653000','653000','5000','658000','658000','kasir','2026-06-18 10:31:15','F22618103115');
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-06-18','F226181031153','2026-06-18','10:31:15','TIN','658000','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-260618-0010','D','2026-06-18','10:31:15','kasir','PENJUALAN','F226181031153','10956437000','658000','10957095000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='658000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226181031153' 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 ('F226181031551','kasir','1',' MGD1G X LG','TOKO','SMBK-D','D1G-ZEBE-132-0','LT X SLOBOK RIBBON SLEP LG 8K ','OL','0.270','1','100.00','315000','0','0','15000','315000','0','5000','0','320000','TIN','00404831','D1G','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEBE-132-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='D1G-ZEBE-132-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 ('F226181031551','2026-06-18','0.270','2026-06-18','10:31:56','PLG0081202','315000','315000','5000','320000','320000','kasir','2026-06-18 10:31:55','F22618103155');
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-06-18','F226181031551','2026-06-18','10:31:56','TIN','320000','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-260618-0011','D','2026-06-18','10:31:56','kasir','PENJUALAN','F226181031551','10957095000','320000','10957415000');
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 ('F226181105311','kasir','1',' MEB1E LG P','TOKO','SMBK-B','B1E-ZFAF-63-T','GW MODEL PITA SLEP LG 8K','','0.510','1','100.00','574000','0','0','15000','569000','0','0','0','569000','LUS','T0080498','B1E','0','0','-','1','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFAF-63-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-06-18' AND kode_barang='B1E-ZFAF-63-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 ('F226181105311','2026-06-18','0.510','2026-06-18','11:05:31','PLG0081203','569000','569000','0','569000','569000','kasir','2026-06-18 11:05:31','F22618110531');
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-06-18','F226181105311','2026-06-18','11:05:31','LUS','569000','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-260618-0012','D','2026-06-18','11:05:31','kasir','PENJUALAN','F226181105311','10957415000','569000','10957984000');
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 ('F226181128021','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZFAG-176-0','GL X TIFF SPECTRA SERUT VAR UB 8K ','OL','3.150','1','100.00','3544000','0','0','15000','3529000','0','16000','0','3545000','TIN','00408999','F3E','0','0','-','1','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAG-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='F3E-ZFAG-176-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 ('F226181128021','2026-06-18','3.150','2026-06-18','11:28:03','PLG0081204','3529000','3529000','16000','3545000','0','kasir','2026-06-18 11:28:02','F22618112802');
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-06-18','F226181128021','2026-06-18','11:28:03','TIN','3545000','16000');
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-260618-0001','2026-06-18','2026-06-18 11:28:02','PENJUALAN : F226181128021','435674676574','BCA','3545000','3545000','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-260618-0002','D','2026-06-18','11:28:03','BCA','PENJUALAN','F226181128021','4527013888','3545000','4530558888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('435674676574','ELISKA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3545000' WHERE no_faktur_jual='F226181128021' 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 ('F226180131131','kasir','1',' MEA1 HW ','TOKO','SMBK-A','A1E-ZCAH-18-T','AT MODEL ITALY PANJANG VAR HW 8K ','OL','0.600','1','100.00','675000','0','0','15000','675000','0','5000','0','680000','TIN','T0078206','A1E','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCAH-18-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-06-18' AND kode_barang='A1E-ZCAH-18-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226180131131','2026-06-18','0.600','2026-06-18','13:31:14','PLG0081205','675000','675000','5000','680000','680000','kasir','2026-06-18 13:31:13','F22618013113');
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-06-18','F226180131131','2026-06-18','13:31:14','TIN','680000','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-260618-0013','D','2026-06-18','13:31:14','kasir','PENJUALAN','F226180131131','10957984000','680000','10958664000');
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 ('F226180153141','kasir','1',' MEE1 LG 18','TOKO','SMBK-E','E1E-ZFAF-36-T','CC MODEL ISYANA SLEP 18 LG 8K ','OL','0.650','1','100.00','731000','0','0','15000','731000','0','5000','0','736000','TIN','T0080471','E1E','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAF-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='E1E-ZFAF-36-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 ('F226180153141','2026-06-18','0.650','2026-06-18','13:53:14','PLG0081206','731000','731000','5000','736000','736000','kasir','2026-06-18 13:53:14','F22618015314');
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-06-18','F226180153141','2026-06-18','13:53:14','TIN','736000','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-260618-0014','D','2026-06-18','13:53:14','kasir','PENJUALAN','F226180153141','10958664000','736000','10959400000');
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 ('F226180201581','kasir','1',' MEF3E X YT','TOKO','SMBK-F','F3E-ZFAG-171-0','GL X TIFF SPECTRA VAR YT 8K ','OL','1.300','1','100.00','1462000','0','0','15000','1456000','0','7000','0','1463000','TIN','00408994','F3E','0','0','-','1','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAG-171-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='F3E-ZFAG-171-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 ('F226180201581','2026-06-18','1.300','2026-06-18','14:01:59','PLG0081207','1456000','1456000','7000','1463000','0','kasir','2026-06-18 14:01:58','F22618020158');
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-06-18','F226180201581','2026-06-18','14:01:59','TIN','1463000','7000');
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-260618-0002','2026-06-18','2026-06-18 14:01:58','PENJUALAN : F226180201581','75645634534','BCA','1463000','1463000','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-260618-0003','D','2026-06-18','14:01:59','BCA','PENJUALAN','F226180201581','4530558888','1463000','4532021888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('75645634534','DESI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1463000' WHERE no_faktur_jual='F226180201581' 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 ('F226180217221','kasir','1',' MEE1 X HT ','TOKO','SMBK-E','E1E-ZFXI-141-0','CC X MODEL SLEP HT 16 8K ','OL','0.440','1','100.00','495000','0','0','15000','495000','0','5000','0','500000','TIN','00408208','E1E','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXI-141-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.440',berat_jual_asli=berat_jual_asli+'0.440',stock_jual='1',berat_akhir=berat_akhir-'0.440',berat_akhir_asli=berat_akhir_asli-'0.440',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='E1E-ZFXI-141-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 ('F226180217221','2026-06-18','0.440','2026-06-18','14:17:23','PLG0081208','495000','495000','5000','500000','0','kasir','2026-06-18 14:17:22','F22618021722');
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-06-18','F226180217221','2026-06-18','14:17:23','TIN','500000','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-260618-0003','2026-06-18','2026-06-18 14:17:22','PENJUALAN : F226180217221','65453454536','BCA','500000','500000','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-260618-0004','D','2026-06-18','14:17:23','BCA','PENJUALAN','F226180217221','4532021888','500000','4532521888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('65453454536','IWAN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='500000' WHERE no_faktur_jual='F226180217221' 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-20260618-0001','1','H1E-ZCBX-227-0','1','2.880','2.880','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZCBX-227-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZCBX-227-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-06-18 14:50:18' WHERE kode_barang='H1E-ZCBX-227-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZCBX-227-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-06-18 14:50:18','TOKO','SMBK-H','H1E','H1E-ZCBX-227-0','1','2.880','2.880','1','2.880','2.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-ZCBX-227-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZCBX-227-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260618-0001','2026-06-18','14:50','2.880','input','2026-06-18 14:50:17');
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 ('F226180258011','kasir','1',' MEH1 X HW ','TOKO','SMBK-H','H1E-ZCBX-227-0','KL X TRIXIE HURUF SLEP P HW 8K ','OLS 24NTS','2.880','1','100.00','3211000','0','0','15000','3269000','0','173000','0','3442000','TIN','00396434','H1E','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCBX-227-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.880',berat_jual_asli=berat_jual_asli+'2.880',stock_jual='1',berat_akhir=berat_akhir-'2.880',berat_akhir_asli=berat_akhir_asli-'2.880',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='H1E-ZCBX-227-0' 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 ('F226180258011','2026-06-18','2.880','2026-06-18','14:58:01','PLG0081209','3269000','3269000','173000','3442000','3442000','kasir','2026-06-18 14:58:01','F22618025801');
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-06-18','F226180258011','2026-06-18','14:58:01','TIN','3442000','173000');
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-260618-0015','D','2026-06-18','14:58:01','kasir','PENJUALAN','F226180258011','10959400000','3442000','10962842000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180131131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180131131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180131131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180153141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180153141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180153141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180201581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180201581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180201581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180217221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180217221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180217221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180258011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180258011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180258011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180914091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180914091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180914091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180959471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180959471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180959471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181001571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181001571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181001571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181005091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181005091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181005091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181006231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181006231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181006231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181021371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181021371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181021371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181031151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181031151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181031151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181031152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181031152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181031152';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181031153' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181031153' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181031153';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181031551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181031551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181031551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181105311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181105311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181105311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226181128021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226181128021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226181128021';
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 ('F226180338591','admin','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBH-46-T','CC MODEL MATA SLEP CM 14 8K ','','0.650','1','100.00','731000','0','0','15000','725000','0','0','0','725000','RHM','T0079987','E1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='E1E-ZEBH-46-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 ('F226180338591','2026-06-18','0.650','2026-06-18','15:39:00','PLG0081210','725000','725000','0','725000','725000','admin','2026-06-18 15:38:59','F22618033859');
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-06-18','F226180338591','2026-06-18','15:39:00','RHM','725000','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-260618-0016','D','2026-06-18','15:39:00','admin','PENJUALAN','F226180338591','10962842000','725000','10963567000');
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-00005459','X-00005459','CC VELG POLOS HW 21 8K','GR','---','E1D','BELI','BELI001','970000','2026-06-18','0.980','1','admin','2026-06-18 15:39:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00005459','X-00005459');
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-260618-0001','F226260958081','RHM','1','BELI','BELI001','E1D', 'X-00005459', 'CC VELG POLOS HW 21 8K','0.980','0.980','100.00','1078000','970000','989796','1105000','1','970000','970000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260618-0001','2026-06-18','2026-06-18','15:39:56','RHM','---','0.980','970000','970000','970000','970000','970000','admin','2026-06-18 15:39:56','FB-260618-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260618-0001','ROHANA','KARANGGAYAM TRISONO','','','089636187376','admin','2026-06-18 15:39:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-18' 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-260618-0017','K','2026-06-18','15:39:56','admin','PEMBELIAN UMUM','FB-260618-0001','10963567000','970000','10962597000');
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-00005460','X-00005460','GW X MODEL RIBBON SLEP LG PE 8K','GR','---','B1E','BELI','BELI001','450000','2026-06-18','0.460','1','admin','2026-06-18 15:39:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00005460','X-00005460');
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-260618-0002','F225201214261','RHM','2','BELI','BELI001','B1E', 'X-00005460', 'GW X MODEL RIBBON SLEP LG PE 8K','0.460','0.460','100.00','492000','450000','978261','1115000','1','450000','450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260618-0002','2026-06-18','2026-06-18','15:39:56','RHM','---','0.460','450000','450000','450000','450000','450000','admin','2026-06-18 15:39:56','FB-260618-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260618-0002','AIMEE','TAKERAN. MAGETAN','','','082232318317','admin','2026-06-18 15:39:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-18' 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-260618-0018','K','2026-06-18','15:39:56','admin','PEMBELIAN UMUM','FB-260618-0002','10962597000','450000','10962147000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180338591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180338591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180338591';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260618-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260618-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260618-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260618-0002';
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 ('F226180342211','kasir','1',' MEF1 X YT ','TOKO','SMBK-F','F1E-YHAC-35-0','GL X OVAL C SLEP YT 58 8K ','','3.620','1','100.00','4072000','0','0','15000','4036000','0','0','0','4036000','TIN','00365405','F1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHAC-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.620',berat_jual_asli=berat_jual_asli+'3.620',stock_jual='1',berat_akhir=berat_akhir-'3.620',berat_akhir_asli=berat_akhir_asli-'3.620',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='F1E-YHAC-35-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 ('F226180342211','2026-06-18','3.620','2026-06-18','15:42:22','PLG0081211','4036000','4036000','0','4036000','4036000','kasir','2026-06-18 15:42:21','F22618034221');
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-06-18','F226180342211','2026-06-18','15:42:22','TIN','4036000','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-260618-0019','D','2026-06-18','15:42:22','kasir','PENJUALAN','F226180342211','10962147000','4036000','10966183000');
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 ('F226180351471','kasir','1',' TFH1 HW 42','TOKO','TBK-H','H1TF-YJXC-60-T','KL ITALY HW 42CM 17K ','OL','10.080','1','100.00','20765000','0','0','15000','20624000','0','40000','0','20664000','TIN','T0073781','H1TF','0','0','-','1','2060000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-YJXC-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.080',berat_jual_asli=berat_jual_asli+'10.080',stock_jual='1',berat_akhir=berat_akhir-'10.080',berat_akhir_asli=berat_akhir_asli-'10.080',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='H1TF-YJXC-60-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 ('F226180351471','2026-06-18','10.080','2026-06-18','15:51:47','PLG0081212','20624000','20624000','40000','20664000','20664000','kasir','2026-06-18 15:51:47','F22618035147');
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-06-18','F226180351471','2026-06-18','15:51:47','TIN','20664000','40000');
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-260618-0020','D','2026-06-18','15:51:47','kasir','PENJUALAN','F226180351471','10966183000','20664000','10986847000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180342211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180342211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180342211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180351471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180351471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180351471';
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 ('F226180402321','admin','1',' MDE2 CM 16','TOKO','SMBK-E','E2D-ZFXF-7-T','CC WEDDING MATA 16 CM 8K ','','0.870','1','100.00','961000','0','0','15000','953000','0','0','0','953000','TIN','T0080430','E2D','0','0','-','1','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXF-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='E2D-ZFXF-7-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 ('F226180402321','2026-06-18','0.870','2026-06-18','16:02:33','PLG0081213','953000','953000','0','953000','953000','admin','2026-06-18 16:02:32','F22618040232');
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-06-18','F226180402321','2026-06-18','16:02:33','TIN','953000','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-260618-0021','D','2026-06-18','16:02:33','admin','PENJUALAN','F226180402321','10986847000','953000','10987800000');
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 ('F226180406071','admin','1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZFAF-34-T','CC MODEL DAUN SLEP 16 LG 8K ','','0.550','1','100.00','619000','0','0','15000','613000','0','0','0','613000','TIN','T0080469','E1E','0','0','-','1','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAF-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-18' AND kode_barang='E1E-ZFAF-34-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 ('F226180406071','2026-06-18','0.550','2026-06-18','16:06:08','PLG0081214','613000','613000','0','613000','613000','admin','2026-06-18 16:06:07','F22618040607');
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-06-18','F226180406071','2026-06-18','16:06:08','TIN','613000','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-260618-0022','D','2026-06-18','16:06:08','admin','PENJUALAN','F226180406071','10987800000','613000','10988413000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180402321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180402321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180402321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226180406071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226180406071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226180406071';
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260618-0001','1','A1TG-YLAC-48-T','1','0.300','0.300','TOKO','TBK-A','TOKO','PTBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-A' WHERE kode_barang='A1TG-YLAC-48-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-18','TOKO','PTBK-A','A1TG','A1TG-YLAC-48-T','100.00','1','0.300','0.300','1','0.300','0.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.300',berat_out_asli=berat_out_asli+'0.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-18' AND kode_barang='A1TG-YLAC-48-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260618-0001','2','A1TE-ZEBB-12-T','1','0.500','0.500','TOKO','TBK-A','TOKO','PTBK-A');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-A' WHERE kode_barang='A1TE-ZEBB-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-18','TOKO','PTBK-A','A1TE','A1TE-ZEBB-12-T','100.00','1','0.500','0.500','1','0.500','0.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.500',berat_out_asli=berat_out_asli+'0.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-18' AND kode_barang='A1TE-ZEBB-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260618-0001','2026-06-18','2026-06-18','16:17','0.8','admin','2026-06-18 16:17:42');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-18';
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-06-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-18' 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-260619-0001','D','2026-06-19','16:39:34','SYSTEM','SALDO AWAL','SALDO AWAL','0','10988413000','10988413000');
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-260619-0001','D','2026-06-19','16:39:34','BCA','SALDO AWAL','SALDO AWAL','0','4532521888','4532521888');
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-260619-0001','D','2026-06-19','16:39:34','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-260619-0001','D','2026-06-19','16:39:34','DLL','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-260619-0001','D','2026-06-19','16:39:34','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-260619-0001','D','2026-06-19','16:39:34','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-06-19';