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-20260826-0001','1','A1D-ZHBA-213-0','1','1.050','1.050','TOKO','SBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZHBA-213-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZHBA-213-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:01:14' WHERE kode_barang='A1D-ZHBA-213-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZHBA-213-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-08-26 08:01:14','TOKO','SMBK-A','A1D','A1D-ZHBA-213-0','1','1.050','1.050','1','1.050','1.050','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-ZHBA-213-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZHBA-213-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260826-0001','2026-08-26','08:01','1.050','input','2026-08-26 08:01:13');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','A1D-ZHBE-154-0','1','1.020','1.020','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZHBE-154-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZHBE-154-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:06:56' WHERE kode_barang='A1D-ZHBE-154-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZHBE-154-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-08-26 08:06:56','TOKO','SMBK-A','A1D','A1D-ZHBE-154-0','1','1.020','1.020','1','1.020','1.020','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-ZHBE-154-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZHBE-154-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-20260826-0001','1','A1D-ZHBE-155-0','1','0.970','0.970','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZHBE-155-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZHBE-155-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:06:56' WHERE kode_barang='A1D-ZHBE-155-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZHBE-155-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-08-26 08:06:56','TOKO','SMBK-A','A1D','A1D-ZHBE-155-0','1','0.970','0.970','1','0.970','0.970','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-ZHBE-155-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZHBE-155-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-20260826-0001','1','A1D-ZHBE-156-0','1','1.020','1.020','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZHBE-156-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZHBE-156-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:06:56' WHERE kode_barang='A1D-ZHBE-156-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZHBE-156-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-08-26 08:06:56','TOKO','SMBK-A','A1D','A1D-ZHBE-156-0','1','1.020','1.020','1','1.020','1.020','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-ZHBE-156-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZHBE-156-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-20260826-0001','1','A1E-ZHBE-157-0','1','0.600','0.600','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBE-157-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBE-157-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:06:56' WHERE kode_barang='A1E-ZHBE-157-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBE-157-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-08-26 08:06:56','TOKO','SMBK-A','A1E','A1E-ZHBE-157-0','1','0.600','0.600','1','0.600','0.600','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-ZHBE-157-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBE-157-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-20260826-0001','1','A1E-ZHBE-158-0','1','0.540','0.540','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBE-158-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBE-158-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:06:56' WHERE kode_barang='A1E-ZHBE-158-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBE-158-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-08-26 08:06:56','TOKO','SMBK-A','A1E','A1E-ZHBE-158-0','1','0.540','0.540','1','0.540','0.540','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-ZHBE-158-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBE-158-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-20260826-0001','1','A1E-ZHBE-159-0','1','0.580','0.580','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBE-159-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBE-159-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:06:56' WHERE kode_barang='A1E-ZHBE-159-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBE-159-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-08-26 08:06:56','TOKO','SMBK-A','A1E','A1E-ZHBE-159-0','1','0.580','0.580','1','0.580','0.580','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-ZHBE-159-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBE-159-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-20260826-0001','1','A1E-ZHBE-160-0','1','0.600','0.600','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBE-160-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBE-160-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:06:56' WHERE kode_barang='A1E-ZHBE-160-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBE-160-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-08-26 08:06:56','TOKO','SMBK-A','A1E','A1E-ZHBE-160-0','1','0.600','0.600','1','0.600','0.600','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-ZHBE-160-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBE-160-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-20260826-0001','1','A1G-ZHBE-161-0','1','0.260','0.260','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1G-ZHBE-161-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1G-ZHBE-161-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:06:56' WHERE kode_barang='A1G-ZHBE-161-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1G-ZHBE-161-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-08-26 08:06:56','TOKO','SMBK-A','A1G','A1G-ZHBE-161-0','1','0.260','0.260','1','0.260','0.260','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1G-ZHBE-161-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1G-ZHBE-161-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-20260826-0001','1','A1G-ZHBE-162-0','1','0.270','0.270','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1G-ZHBE-162-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1G-ZHBE-162-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-08-26 08:06:56' WHERE kode_barang='A1G-ZHBE-162-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1G-ZHBE-162-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-08-26 08:06:56','TOKO','SMBK-A','A1G','A1G-ZHBE-162-0','1','0.270','0.270','1','0.270','0.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1G-ZHBE-162-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1G-ZHBE-162-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260826-0001','2026-08-26','08:06','5.860','input','2026-08-26 08:06:56');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','B1E-ZHBE-182-0','1','0.470','0.470','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHBE-182-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-182-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1E-ZHBE-182-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHBE-182-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:07:23','TOKO','SMBK-B','B1E','B1E-ZHBE-182-0','1','0.470','0.470','1','0.470','0.470','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-ZHBE-182-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-182-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','B1E-ZHBE-183-0','1','0.530','0.530','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHBE-183-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-183-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1E-ZHBE-183-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHBE-183-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:07:23','TOKO','SMBK-B','B1E','B1E-ZHBE-183-0','1','0.530','0.530','1','0.530','0.530','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-ZHBE-183-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-183-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','B1E-ZHBE-184-0','1','0.740','0.740','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHBE-184-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-184-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1E-ZHBE-184-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHBE-184-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:07:23','TOKO','SMBK-B','B1E','B1E-ZHBE-184-0','1','0.740','0.740','1','0.740','0.740','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-ZHBE-184-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-184-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','B1D-ZHBE-185-0','1','0.840','0.840','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZHBE-185-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZHBE-185-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1D-ZHBE-185-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZHBE-185-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:07:23','TOKO','SMBK-B','B1D','B1D-ZHBE-185-0','1','0.840','0.840','1','0.840','0.840','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-ZHBE-185-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZHBE-185-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','B1D-ZHBE-186-0','1','1.060','1.060','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZHBE-186-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZHBE-186-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1D-ZHBE-186-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZHBE-186-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:07:23','TOKO','SMBK-B','B1D','B1D-ZHBE-186-0','1','1.060','1.060','1','1.060','1.060','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-ZHBE-186-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZHBE-186-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-20260826-0001','1','B1E-ZHBE-187-0','1','0.550','0.550','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHBE-187-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-187-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1E-ZHBE-187-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHBE-187-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-08-26 08:07:23','TOKO','SMBK-B','B1E','B1E-ZHBE-187-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-ZHBE-187-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-187-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-20260826-0001','1','B1E-ZHBE-188-0','1','0.480','0.480','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHBE-188-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-188-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1E-ZHBE-188-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHBE-188-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-08-26 08:07:23','TOKO','SMBK-B','B1E','B1E-ZHBE-188-0','1','0.480','0.480','1','0.480','0.480','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-ZHBE-188-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHBE-188-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-20260826-0001','1','B1F-ZHBE-189-0','1','0.350','0.350','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1F-ZHBE-189-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1F-ZHBE-189-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1F-ZHBE-189-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1F-ZHBE-189-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-08-26 08:07:23','TOKO','SMBK-B','B1F','B1F-ZHBE-189-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1F-ZHBE-189-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1F-ZHBE-189-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-20260826-0001','1','B1G-ZHBE-190-0','1','0.230','0.230','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1G-ZHBE-190-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZHBE-190-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1G-ZHBE-190-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZHBE-190-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-08-26 08:07:23','TOKO','SMBK-B','B1G','B1G-ZHBE-190-0','1','0.230','0.230','1','0.230','0.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1G-ZHBE-190-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZHBE-190-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-20260826-0001','1','B1G-ZHBE-191-0','1','0.220','0.220','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1G-ZHBE-191-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1G-ZHBE-191-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-08-26 08:07:23' WHERE kode_barang='B1G-ZHBE-191-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1G-ZHBE-191-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-08-26 08:07:23','TOKO','SMBK-B','B1G','B1G-ZHBE-191-0','1','0.220','0.220','1','0.220','0.220','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1G-ZHBE-191-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1G-ZHBE-191-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260826-0001','2026-08-26','08:07','5.470','input','2026-08-26 08:07:23');
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-20260826-0001','1','D2E-ZHBE-151-0','1','0.800','0.800','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZHBE-151-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZHBE-151-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-08-26 08:07:44' WHERE kode_barang='D2E-ZHBE-151-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZHBE-151-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-08-26 08:07:44','TOKO','SMBK-D','D2E','D2E-ZHBE-151-0','1','0.800','0.800','1','0.800','0.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' 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='D2E-ZHBE-151-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZHBE-151-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-20260826-0001','1','D1E-ZHBE-152-0','1','0.600','0.600','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZHBE-152-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZHBE-152-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-08-26 08:07:44' WHERE kode_barang='D1E-ZHBE-152-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZHBE-152-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-08-26 08:07:44','TOKO','SMBK-D','D1E','D1E-ZHBE-152-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZHBE-152-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZHBE-152-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-20260826-0001','1','D1F-ZHBE-153-0','1','0.670','0.670','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZHBE-153-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZHBE-153-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-08-26 08:07:44' WHERE kode_barang='D1F-ZHBE-153-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZHBE-153-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-08-26 08:07:44','TOKO','SMBK-D','D1F','D1F-ZHBE-153-0','1','0.670','0.670','1','0.670','0.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZHBE-153-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZHBE-153-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260826-0001','2026-08-26','08:07','2.070','input','2026-08-26 08:07:43');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','E1E-ZHBE-124-0','1','0.560','0.560','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZHBE-124-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZHBE-124-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E1E-ZHBE-124-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZHBE-124-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-08-26 08:08:03','TOKO','SMBK-E','E1E','E1E-ZHBE-124-0','1','0.560','0.560','1','0.560','0.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZHBE-124-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZHBE-124-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-20260826-0001','1','E1E-ZHBE-125-0','1','0.650','0.650','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZHBE-125-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZHBE-125-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E1E-ZHBE-125-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZHBE-125-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-08-26 08:08:03','TOKO','SMBK-E','E1E','E1E-ZHBE-125-0','1','0.650','0.650','1','0.650','0.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZHBE-125-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZHBE-125-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-20260826-0001','1','E1E-ZHBE-126-0','1','0.470','0.470','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZHBE-126-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZHBE-126-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E1E-ZHBE-126-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZHBE-126-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-08-26 08:08:03','TOKO','SMBK-E','E1E','E1E-ZHBE-126-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZHBE-126-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZHBE-126-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-20260826-0001','1','E2F-ZHBE-127-0','1','0.400','0.400','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZHBE-127-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZHBE-127-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E2F-ZHBE-127-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZHBE-127-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-08-26 08:08:03','TOKO','SMBK-E','E2F','E2F-ZHBE-127-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' 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='E2F-ZHBE-127-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZHBE-127-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-20260826-0001','1','E1F-ZHBE-128-0','1','0.350','0.350','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZHBE-128-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZHBE-128-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E1F-ZHBE-128-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZHBE-128-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-08-26 08:08:03','TOKO','SMBK-E','E1F','E1F-ZHBE-128-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZHBE-128-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZHBE-128-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-20260826-0001','1','E1F-ZHBE-129-0','1','0.390','0.390','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZHBE-129-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZHBE-129-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E1F-ZHBE-129-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZHBE-129-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-08-26 08:08:03','TOKO','SMBK-E','E1F','E1F-ZHBE-129-0','1','0.390','0.390','1','0.390','0.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZHBE-129-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZHBE-129-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-20260826-0001','1','E1F-ZHBE-130-0','1','0.380','0.380','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZHBE-130-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZHBE-130-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E1F-ZHBE-130-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZHBE-130-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-08-26 08:08:03','TOKO','SMBK-E','E1F','E1F-ZHBE-130-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZHBE-130-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZHBE-130-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-20260826-0001','1','E2E-ZHBE-131-0','1','0.480','0.480','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZHBE-131-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZHBE-131-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E2E-ZHBE-131-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZHBE-131-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-08-26 08:08:03','TOKO','SMBK-E','E2E','E2E-ZHBE-131-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZHBE-131-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZHBE-131-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-20260826-0001','1','E2E-ZHBE-132-0','1','0.730','0.730','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZHBE-132-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZHBE-132-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E2E-ZHBE-132-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZHBE-132-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-08-26 08:08:03','TOKO','SMBK-E','E2E','E2E-ZHBE-132-0','1','0.730','0.730','1','0.730','0.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZHBE-132-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZHBE-132-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-20260826-0001','1','E2E-ZHBE-133-0','1','0.740','0.740','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZHBE-133-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZHBE-133-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E2E-ZHBE-133-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZHBE-133-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-08-26 08:08:03','TOKO','SMBK-E','E2E','E2E-ZHBE-133-0','1','0.740','0.740','1','0.740','0.740','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZHBE-133-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZHBE-133-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-20260826-0001','1','E2D-ZHBE-134-0','1','1.050','1.050','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZHBE-134-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZHBE-134-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E2D-ZHBE-134-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZHBE-134-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-08-26 08:08:03','TOKO','SMBK-E','E2D','E2D-ZHBE-134-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZHBE-134-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZHBE-134-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-20260826-0001','1','E1D-ZHBE-135-0','1','1.160','1.160','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZHBE-135-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZHBE-135-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E1D-ZHBE-135-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZHBE-135-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-08-26 08:08:03','TOKO','SMBK-E','E1D','E1D-ZHBE-135-0','1','1.160','1.160','1','1.160','1.160','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-ZHBE-135-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZHBE-135-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-20260826-0001','1','E1D-ZHBE-136-0','1','0.950','0.950','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZHBE-136-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZHBE-136-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-08-26 08:08:03' WHERE kode_barang='E1D-ZHBE-136-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZHBE-136-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-08-26 08:08:03','TOKO','SMBK-E','E1D','E1D-ZHBE-136-0','1','0.950','0.950','1','0.950','0.950','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-ZHBE-136-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZHBE-136-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260826-0001','2026-08-26','08:07','8.310','input','2026-08-26 08:08:02');
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-20260826-0001','1','F1E-ZHBE-11-0','1','4.050','4.050','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZHBE-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZHBE-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F1E-ZHBE-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZHBE-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:27','TOKO','SMBK-F','F1E','F1E-ZHBE-11-0','1','4.050','4.050','1','4.050','4.050','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-ZHBE-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZHBE-11-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','F1E-ZHBE-13-0','1','3.380','3.380','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZHBE-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZHBE-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F1E-ZHBE-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZHBE-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:27','TOKO','SMBK-F','F1E','F1E-ZHBE-13-0','1','3.380','3.380','1','3.380','3.380','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-ZHBE-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZHBE-13-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','F1E-ZHBE-15-0','1','2.270','2.270','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZHBE-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZHBE-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F1E-ZHBE-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZHBE-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:27','TOKO','SMBK-F','F1E','F1E-ZHBE-15-0','1','2.270','2.270','1','2.270','2.270','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-ZHBE-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZHBE-15-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-20260826-0001','1','F2E-ZHBE-21-0','1','4.950','4.950','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZHBE-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZHBE-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F2E-ZHBE-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZHBE-21-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:27','TOKO','SMBK-F','F2E','F2E-ZHBE-21-0','1','4.950','4.950','1','4.950','4.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZHBE-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZHBE-21-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','F2E-ZHBE-22-0','1','3.940','3.940','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZHBE-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZHBE-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F2E-ZHBE-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZHBE-22-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-08-26 08:08:27','TOKO','SMBK-F','F2E','F2E-ZHBE-22-0','1','3.940','3.940','1','3.940','3.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZHBE-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZHBE-22-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-20260826-0001','1','F3E-ZHBE-71-0','1','0.550','0.550','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-71-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-71-0','1','0.550','0.550','1','0.550','0.550','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-ZHBE-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-71-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','F3E-ZHBE-72-0','1','2.130','2.130','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-72-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-72-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-72-0','1','2.130','2.130','1','2.130','2.130','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-ZHBE-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-72-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','F3E-ZHBE-73-0','1','4.500','4.500','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-73-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-73-0','1','4.500','4.500','1','4.500','4.500','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-ZHBE-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-73-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','F3E-ZHBE-74-0','1','3.580','3.580','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-74-0','1','3.580','3.580','1','3.580','3.580','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-ZHBE-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-74-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260826-0001','1','F3E-ZHBE-75-0','1','1.620','1.620','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-75-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-75-0','1','1.620','1.620','1','1.620','1.620','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-ZHBE-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-75-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-20260826-0001','1','F3E-ZHBE-76-0','1','1.850','1.850','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-76-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-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-76-0','1','1.850','1.850','1','1.850','1.850','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-ZHBE-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-76-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-20260826-0001','1','F3E-ZHBE-77-0','1','1.020','1.020','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-77-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-77-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-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-77-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZHBE-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-77-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-20260826-0001','1','F3E-ZHBE-78-0','1','0.570','0.570','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-78-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-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-78-0','1','0.570','0.570','1','0.570','0.570','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-ZHBE-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-78-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-20260826-0001','1','F3E-ZHBE-79-0','1','1.810','1.810','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-79-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-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-79-0','1','1.810','1.810','1','1.810','1.810','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-ZHBE-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-79-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-20260826-0001','1','F3E-ZHBE-80-0','1','1.960','1.960','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBE-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-08-26 08:08:27' WHERE kode_barang='F3E-ZHBE-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBE-80-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-08-26 08:08:27','TOKO','SMBK-F','F3E','F3E-ZHBE-80-0','1','1.960','1.960','1','1.960','1.960','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-ZHBE-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBE-80-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260826-0001','2026-08-26','08:08','38.180','input','2026-08-26 08:08:27');
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-20260826-0001','1','H1E-ZHBE-40-0','1','1.700','1.700','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZHBE-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZHBE-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-08-26 08:08:49' WHERE kode_barang='H1E-ZHBE-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZHBE-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-08-26 08:08:49','TOKO','SMBK-H','H1E','H1E-ZHBE-40-0','1','1.700','1.700','1','1.700','1.700','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-ZHBE-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZHBE-40-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-20260826-0001','1','H1E-ZHBE-47-0','1','1.140','1.140','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZHBE-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZHBE-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-08-26 08:08:49' WHERE kode_barang='H1E-ZHBE-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZHBE-47-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-26 08:08:49','TOKO','SMBK-H','H1E','H1E-ZHBE-47-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-ZHBE-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZHBE-47-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260826-0001','2026-08-26','08:08','2.840','input','2026-08-26 08:08:48');
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-20260826-0001','1','S1F-ZHBE-1-0','1','0.340','0.340','TOKO','SSBK-S','TOKO','SMBK-S');
DELETE FROM tm_barang WHERE kode_barang='S1F-ZHBE-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1F-ZHBE-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-S',tgl_last_beli='2026-08-26 08:09:14' WHERE kode_barang='S1F-ZHBE-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1F-ZHBE-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-08-26 08:09:14','TOKO','SMBK-S','S1F','S1F-ZHBE-1-0','1','0.340','0.340','1','0.340','0.340','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-ZHBE-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='S1F-ZHBE-1-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260826-0001','2026-08-26','08:09','0.340','input','2026-08-26 08:09:14');
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 ('F226260908431','kasir','1',' MEE2 X UB ','TOKO','SMBK-E','E2E-ZHAE-187-0','CC X MODEL MATA UB 16 8K ','OL','0.680','1','100.00','734000','0','0','15000','738000','0','5000','0','743000','LUS','00419208','E2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHAE-187-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E2E-ZHAE-187-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 ('F226260908431','2026-08-26','0.680','2026-08-26','09:08:43','PLG0083955','738000','738000','5000','743000','743000','kasir','2026-08-26 09:08:43','F22626090843');
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-08-26','F226260908431','2026-08-26','09:08:43','LUS','743000','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-260826-0002','D','2026-08-26','09:08:43','kasir','PENJUALAN','F226260908431','14042327000','743000','14043070000');
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 ('F226260923231','kasir','1',' TEE1 HT 13','TOKO','TBK-E','E1TE-ZGAG-56-T','CC BANGKOK VAR SLEP HT 13 17K ','OL','0.610','1','100.00','1214000','0','0','15000','1214000','0','7000','0','1221000','DIN','T0081279','E1TE','0','0','-','0','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZGAG-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E1TE-ZGAG-56-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 ('F226260923231','2026-08-26','0.610','2026-08-26','09:23:23','PLG0083956','1214000','1214000','7000','1221000','1221000','kasir','2026-08-26 09:23:23','F22626092323');
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-08-26','F226260923231','2026-08-26','09:23:23','DIN','1221000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260826-0003','D','2026-08-26','09:23:23','kasir','PENJUALAN','F226260923231','14043070000','1221000','14044291000');
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 ('F226260942011','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZHXH-17-T','KL SIEM COBRA KH 42 8K ','','2.030','1','100.00','2192000','0','0','15000','2182000','0','0','0','2182000','LUS','T0082136','H1E','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXH-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='H1E-ZHXH-17-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260942011','2026-08-26','2.030','2026-08-26','09:42:02','PLG0083957','2182000','2182000','0','2182000','2182000','kasir','2026-08-26 09:42:01','F22626094201');
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-08-26','F226260942011','2026-08-26','09:42:02','LUS','2182000','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-260826-0004','D','2026-08-26','09:42:02','kasir','PENJUALAN','F226260942011','14044291000','2182000','14046473000');
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 ('F226260946431','kasir','1',' MEF1E UB 5','TOKO','SMBK-F','F1E-ZHXG-48-T','GL OVAL C SLEP UB 54 8K ','OL','4.270','1','100.00','4612000','0','0','15000','4612000','0','21000','0','4633000','DIN','T0082101','F1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHXG-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.270',berat_jual_asli=berat_jual_asli+'4.270',stock_jual='1',berat_akhir=berat_akhir-'4.270',berat_akhir_asli=berat_akhir_asli-'4.270',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='F1E-ZHXG-48-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 ('F226260946431','2026-08-26','4.270','2026-08-26','09:46:44','PLG0083958','4612000','4612000','21000','4633000','4633000','kasir','2026-08-26 09:46:43','F22626094643');
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-08-26','F226260946431','2026-08-26','09:46:44','DIN','4633000','21000');
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-260826-0005','D','2026-08-26','09:46:44','kasir','PENJUALAN','F226260946431','14046473000','4633000','14051106000');
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 ('F226261031511','kasir','1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZHBE-47-0','KL X TIFF SLEP VAR UB 40 8K','OL','1.140','1','100.00','1225000','0','0','15000','1231000','0','6000','0','1237000','DIN','00420089','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBE-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.140',berat_jual_asli=berat_jual_asli+'1.140',stock_jual='1',berat_akhir=berat_akhir-'1.140',berat_akhir_asli=berat_akhir_asli-'1.140',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='H1E-ZHBE-47-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 ('F226261031511','2026-08-26','1.140','2026-08-26','10:31:52','PLG0083959','1231000','1231000','6000','1237000','1237000','kasir','2026-08-26 10:31:51','F22626103151');
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-08-26','F226261031511','2026-08-26','10:31:52','DIN','1237000','6000');
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-260826-0006','D','2026-08-26','10:31:52','kasir','PENJUALAN','F226261031511','14051106000','1237000','14052343000');
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 ('F226261044031','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZHBD-21-T','GL CASTELI SPECTRA VAR HWT 8K ','OL','1.550','1','100.00','1674000','0','0','15000','1674000','0','8000','0','1682000','DIN','T0082428','F3E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBD-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='F3E-ZHBD-21-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 ('F226261044031','2026-08-26','1.550','2026-08-26','10:44:03','PLG0083960','1674000','1674000','8000','1682000','0','kasir','2026-08-26 10:44:03','F22626104403');
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-08-26','F226261044031','2026-08-26','10:44:03','DIN','1682000','8000');
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-260826-0001','2026-08-26','2026-08-26 10:44:03','PENJUALAN : F226261044031','0987654321','BCA','1682000','1682000','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-260826-0002','D','2026-08-26','10:44:03','BCA','PENJUALAN','F226261044031','4758386888','1682000','4760068888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','DEWI');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261044031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261044031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261044031';
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 ('F226261053281','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-ZHAA-19-T','GW MODEL DAISY MATA LG 8K PE ','OL','0.500','1','100.00','540000','0','0','15000','543000','0','5000','0','548000','LUS','T0082159','B1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZHAA-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='B1E-ZHAA-19-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 ('F226261053281','2026-08-26','0.500','2026-08-26','10:53:28','PLG0083961','543000','543000','5000','548000','548000','kasir','2026-08-26 10:53:28','F22626105328');
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-08-26','F226261053281','2026-08-26','10:53:28','LUS','548000','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-260826-0007','D','2026-08-26','10:53:28','kasir','PENJUALAN','F226261053281','14052343000','548000','14052891000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261053281' 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 ('F226261053282','kasir',' 1',' MDD2 X LG ','TOKO','SMBK-D','D2D-ZGCA-203-0','LT X MODEL MATA LG 8K ','','1.170','1','100.00','1240000','0','0','15000','1236000','0','10000','0','1246000','LUS','00416289','D2D','0','0','-','1','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZGCA-203-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='D2D-ZGCA-203-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 ('F226261053282','2026-08-26','1.170','2026-08-26','10:53:28','PLG0083962','1236000','1236000','10000','1246000','1246000','kasir','2026-08-26 10:53:28','F22626105328');
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-08-26','F226261053282','2026-08-26','10:53:28','LUS','1246000','10000');
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-260826-0008','D','2026-08-26','10:53:28','kasir','PENJUALAN','F226261053282','14052891000','1246000','14054137000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1246000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261053282' 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 ('F226261053283','kasir',' 1',' MEE2E KH 1','TOKO','SMBK-E','E2E-ZHBA-28-T','CC MODEL SNACK MATA SLEP KH 14 8K ','OL','0.490','1','100.00','529000','0','0','15000','532000','0','5000','0','537000','LUS','T0082320','E2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E2E-ZHBA-28-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 ('F226261053283','2026-08-26','0.490','2026-08-26','10:53:28','PLG0083963','532000','532000','5000','537000','537000','kasir','2026-08-26 10:53:28','F22626105328');
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-08-26','F226261053283','2026-08-26','10:53:28','LUS','537000','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-260826-0009','D','2026-08-26','10:53:28','kasir','PENJUALAN','F226261053283','14054137000','537000','14054674000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='537000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261053283' 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 ('F226261053284','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZHXE-95-T','KL SIEM COBRA KH 42 8K ','OL','1.300','1','100.00','1404000','0','0','15000','1404000','0','7000','0','1411000','LUS','T0082008','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXE-95-T' 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-08-26' AND kode_barang='H1E-ZHXE-95-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261053284','2026-08-26','1.300','2026-08-26','10:53:28','PLG0083964','1404000','1404000','7000','1411000','1411000','kasir','2026-08-26 10:53:28','F22626105328');
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-08-26','F226261053284','2026-08-26','10:53:28','LUS','1411000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260826-0010','D','2026-08-26','10:53:28','kasir','PENJUALAN','F226261053284','14054674000','1411000','14056085000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1411000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261053284' 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 ('F226261057281','kasir','1',' MEE2E KH 1','TOKO','SMBK-E','E2E-ZHBA-109-T','CC MODEL PAKU MATA SLEP KH 12 8K ','OL','0.420','1','100.00','454000','0','0','15000','456000','0','5000','0','461000','DIN','T0082401','E2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-109-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E2E-ZHBA-109-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 ('F226261057281','2026-08-26','0.420','2026-08-26','10:57:28','PLG0083965','456000','456000','5000','461000','461000','kasir','2026-08-26 10:57:28','F22626105728');
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-08-26','F226261057281','2026-08-26','10:57:28','DIN','461000','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-260826-0011','D','2026-08-26','10:57:28','kasir','PENJUALAN','F226261057281','14056085000','461000','14056546000');
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 ('F226261107051','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZHBE-78-0','GL X SHANIA SLEP UB 8K','OL','0.570','1','100.00','613000','0','0','15000','618000','0','5000','0','623000','DIN','00420120','F3E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBE-78-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-08-26' AND kode_barang='F3E-ZHBE-78-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 ('F226261107051','2026-08-26','0.570','2026-08-26','11:07:06','PLG0083966','618000','618000','5000','623000','623000','kasir','2026-08-26 11:07:05','F22626110705');
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-08-26','F226261107051','2026-08-26','11:07:06','DIN','623000','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-260826-0012','D','2026-08-26','11:07:06','kasir','PENJUALAN','F226261107051','14056546000','623000','14057169000');
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 ('F226261144131','kasir','1',' MDE1D BM 2','TOKO','SMBK-E','E1D-ZGAH-12-T','CC MODEL SLEP BM 22 8K ','OL','1.270','1','100.00','1346000','0','0','15000','1347000','0','6000','0','1353000','TIN','T0081317','E1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGAH-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E1D-ZGAH-12-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 ('F226261144131','2026-08-26','1.270','2026-08-26','11:44:14','PLG0083967','1347000','1347000','6000','1353000','0','kasir','2026-08-26 11:44:13','F22626114413');
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-08-26','F226261144131','2026-08-26','11:44:14','TIN','1353000','6000');
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-260826-0002','2026-08-26','2026-08-26 11:44:13','PENJUALAN : F226261144131','746576765768','BCA','1353000','1353000','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-260826-0003','D','2026-08-26','11:44:14','BCA','PENJUALAN','F226261144131','4760068888','1353000','4761421888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('746576765768','SAEDAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1353000' WHERE no_faktur_jual='F226261144131' 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 ('F226261144501','kasir','1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZHBE-14-T','LT CHARM VERONA SLEP LG 8K ','OL','0.400','1','100.00','440000','0','0','15000','442000','0','5000','0','447000','TIN','T0082448','D1F','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHBE-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='D1F-ZHBE-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261144501','2026-08-26','0.400','2026-08-26','11:44:50','PLG0083968','442000','442000','5000','447000','447000','kasir','2026-08-26 11:44:50','F22626114450');
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-08-26','F226261144501','2026-08-26','11:44:50','TIN','447000','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-260826-0013','D','2026-08-26','11:44:50','kasir','PENJUALAN','F226261144501','14057169000','447000','14057616000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='447000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261144501' 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 ('F226261144502','kasir',' 1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZHBE-16-T','LT CHARM VERONA SLEP LG 8K ','OL','0.400','1','100.00','440000','0','0','15000','442000','0','5000','0','447000','TIN','T0082450','D1F','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHBE-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='D1F-ZHBE-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226261144502','2026-08-26','0.400','2026-08-26','11:44:50','PLG0083969','442000','442000','5000','447000','447000','kasir','2026-08-26 11:44:50','F22626114450');
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-08-26','F226261144502','2026-08-26','11:44:50','TIN','447000','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-260826-0014','D','2026-08-26','11:44:50','kasir','PENJUALAN','F226261144502','14057616000','447000','14058063000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='447000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226261144502' 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 ('F226260106381','kasir','1',' MEF1E UB 5','TOKO','SMBK-F','F1E-ZHBA-63-T','GL OVAL C SLEP UB 52 8K ','','2.070','1','100.00','2236000','0','0','15000','2225000','0','0','0','2225000','NOV','T0082355','F1E','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHBA-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='F1E-ZHBA-63-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 ('F226260106381','2026-08-26','2.070','2026-08-26','13:06:38','PLG0083970','2225000','2225000','0','2225000','0','kasir','2026-08-26 13:06:38','F22626010638');
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-08-26','F226260106381','2026-08-26','13:06:38','NOV','2225000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260826-0003','2026-08-26','2026-08-26 13:06:38','PENJUALAN : F226260106381','2234567890','BCA','2225000','2225000','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-260826-0004','D','2026-08-26','13:06:38','BCA','PENJUALAN','F226260106381','4761421888','2225000','4763646888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('2234567890','ALFINA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2225000' WHERE no_faktur_jual='F226260106381' 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 ('F226260112141','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZHAI-55-0','GL X CAPELLA SLEEP HW 8K ','OL','1.360','1','100.00','1469000','0','0','15000','1469000','0','7000','0','1476000','TIN','00419455','F3E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHAI-55-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='F3E-ZHAI-55-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 ('F226260112141','2026-08-26','1.360','2026-08-26','13:12:15','PLG0083971','1469000','1469000','7000','1476000','1476000','kasir','2026-08-26 13:12:14','F22626011214');
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-08-26','F226260112141','2026-08-26','13:12:15','TIN','1476000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260826-0015','D','2026-08-26','13:12:15','kasir','PENJUALAN','F226260112141','14058063000','1476000','14059539000');
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 ('F226260124261','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZHBA-13-T','CC MODEL SPECTRA SLEP KH 14 8K ','OL','0.370','1','100.00','407000','0','0','15000','410000','0','5000','0','415000','LUS','T0082305','E1F','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHBA-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E1F-ZHBA-13-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 ('F226260124261','2026-08-26','0.370','2026-08-26','13:24:26','PLG0083972','410000','410000','5000','415000','415000','kasir','2026-08-26 13:24:26','F22626012426');
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-08-26','F226260124261','2026-08-26','13:24:26','LUS','415000','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-260826-0016','D','2026-08-26','13:24:26','kasir','PENJUALAN','F226260124261','14059539000','415000','14059954000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260124261' 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 ('F226260124262','kasir',' 1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZHAE-206-0','CC X MODEL SLEP LG 14 8K ','OL','0.430','1','100.00','464000','0','0','15000','467000','0','5000','0','472000','LUS','00419227','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHAE-206-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E1E-ZHAE-206-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 ('F226260124262','2026-08-26','0.430','2026-08-26','13:24:26','PLG0083973','467000','467000','5000','472000','472000','kasir','2026-08-26 13:24:26','F22626012426');
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-08-26','F226260124262','2026-08-26','13:24:26','LUS','472000','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-260826-0017','D','2026-08-26','13:24:26','kasir','PENJUALAN','F226260124262','14059954000','472000','14060426000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='472000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260124262' 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 ('F226260158121','kasir','1',' MEE1 PM 10','TOKO','SMBK-E','E1E-ZHBD-17-T','CC COR MODEL SLEP 10 PM SI 8K ','ol','0.520','1','100.00','562000','0','0','15000','565000','0','5000','0','570000','TIN','T0082424','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBD-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E1E-ZHBD-17-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 ('F226260158121','2026-08-26','0.520','2026-08-26','13:58:13','PLG0083974','565000','565000','5000','570000','570000','kasir','2026-08-26 13:58:12','F22626015812');
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-08-26','F226260158121','2026-08-26','13:58:13','TIN','570000','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-260826-0018','D','2026-08-26','13:58:13','kasir','PENJUALAN','F226260158121','14060426000','570000','14060996000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='570000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260158121' 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 ('F226260158122','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZHBD-27-T','KL SIEM COBRA MATA VAR 42 KH 8K ','ol','1.940','1','100.00','2095000','0','0','15000','2095000','0','10000','0','2105000','TIN','T0082434','H1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBD-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='H1E-ZHBD-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226260158122','2026-08-26','1.940','2026-08-26','13:58:13','PLG0083975','2095000','2095000','10000','2105000','2105000','kasir','2026-08-26 13:58:12','F22626015812');
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-08-26','F226260158122','2026-08-26','13:58:13','TIN','2105000','10000');
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-260826-0019','D','2026-08-26','13:58:13','kasir','PENJUALAN','F226260158122','14060996000','2105000','14063101000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2105000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260158122' 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 ('F226260212031','kasir','1',' MEF1E TD 6','TOKO','SMBK-F','F1E-ZHBA-72-T','GL OVAL C SLEP TD 60 8K ','','3.360','1','100.00','3629000','0','0','15000','3612000','0','0','0','3612000','LUS','T0082364','F1E','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHBA-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.360',berat_jual_asli=berat_jual_asli+'3.360',stock_jual='1',berat_akhir=berat_akhir-'3.360',berat_akhir_asli=berat_akhir_asli-'3.360',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='F1E-ZHBA-72-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 ('F226260212031','2026-08-26','3.360','2026-08-26','14:12:04','PLG0083976','3612000','3612000','0','3612000','3612000','kasir','2026-08-26 14:12:03','F22626021203');
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-08-26','F226260212031','2026-08-26','14:12:04','LUS','3612000','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-260826-0020','D','2026-08-26','14:12:04','kasir','PENJUALAN','F226260212031','14063101000','3612000','14066713000');
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 ('F226260226271','kasir','1',' MDA1D CM ','TOKO','SMBK-A','A1D-ZHBA-213-0','AT KLIP VERONA SLEP CM 8K ','OL','1.050','1','100.00','1102000','0','0','15000','1113000','0','5000','0','1118000','TIN','00419792','A1D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZHBA-213-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='A1D-ZHBA-213-0' 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 ('F226260226271','2026-08-26','1.050','2026-08-26','14:26:27','PLG0083977','1113000','1113000','5000','1118000','1118000','kasir','2026-08-26 14:26:27','F22626022627');
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-08-26','F226260226271','2026-08-26','14:26:27','TIN','1118000','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-260826-0021','D','2026-08-26','14:26:27','kasir','PENJUALAN','F226260226271','14066713000','1118000','14067831000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1118000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260226271' 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 ('F226260226272','kasir',' 1',' MEE1E 5K C','TOKO','SMBK-E','E1E-ZHBA-98-T','CC MODEL SLEP CM 12 8K ','OL','0.550','1','100.00','594000','0','0','15000','597000','0','5000','0','602000','TIN','T0082390','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBA-98-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-08-26' AND kode_barang='E1E-ZHBA-98-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 ('F226260226272','2026-08-26','0.550','2026-08-26','14:26:27','PLG0083978','597000','597000','5000','602000','602000','kasir','2026-08-26 14:26:27','F22626022627');
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-08-26','F226260226272','2026-08-26','14:26:27','TIN','602000','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-260826-0022','D','2026-08-26','14:26:27','kasir','PENJUALAN','F226260226272','14067831000','602000','14068433000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260226272' 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 ('F226260226273','kasir',' 1',' MEE1E 5K C','TOKO','SMBK-E','E1E-ZHBA-101-T','CC MODEL SLEP CM 16 8K','OL','0.550','1','100.00','594000','0','0','15000','597000','0','5000','0','602000','TIN','T0082393','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBA-101-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-08-26' AND kode_barang='E1E-ZHBA-101-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 ('F226260226273','2026-08-26','0.550','2026-08-26','14:26:27','PLG0083979','597000','597000','5000','602000','602000','kasir','2026-08-26 14:26:27','F22626022627');
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-08-26','F226260226273','2026-08-26','14:26:27','TIN','602000','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-260826-0023','D','2026-08-26','14:26:27','kasir','PENJUALAN','F226260226273','14068433000','602000','14069035000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260226273' 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 ('F226260226274','kasir',' 1',' MEE1E 5K C','TOKO','SMBK-E','E1E-ZHBA-96-T','CC MODEL SLEP CM 14 8K ','OL','0.630','1','100.00','680000','0','0','15000','684000','0','5000','0','689000','TIN','T0082388','E1E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBA-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E1E-ZHBA-96-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 ('F226260226274','2026-08-26','0.630','2026-08-26','14:26:27','PLG0083980','684000','684000','5000','689000','689000','kasir','2026-08-26 14:26:27','F22626022627');
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-08-26','F226260226274','2026-08-26','14:26:27','TIN','689000','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-260826-0024','D','2026-08-26','14:26:27','kasir','PENJUALAN','F226260226274','14069035000','689000','14069724000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='689000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260226274' 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 ('F226260226581','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZHXG-74-0','CC X MODEL MATA CM 22 8K ','OL','1.750','1','100.00','1855000','0','0','15000','1855000','0','9000','0','1864000','TIN','00417493','E2D','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHXG-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E2D-ZHXG-74-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 ('F226260226581','2026-08-26','1.750','2026-08-26','14:26:59','PLG0083981','1855000','1855000','9000','1864000','1864000','kasir','2026-08-26 14:26:58','F22626022658');
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-08-26','F226260226581','2026-08-26','14:26:59','TIN','1864000','9000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260826-0025','D','2026-08-26','14:26:59','kasir','PENJUALAN','F226260226581','14069724000','1864000','14071588000');
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 ('F226260228261','kasir','1',' MEF3 10K U','TOKO','SMBK-F','F3E-ZHBA-81-T','GL TIFF SPECTRA CAT SERUT SLEP UB 8K ','OL','1.820','1','100.00','1966000','0','0','15000','1965000','0','10000','0','1975000','TIN','T0082373','F3E','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHBA-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='F3E-ZHBA-81-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 ('F226260228261','2026-08-26','1.820','2026-08-26','14:28:27','PLG0083982','1965000','1965000','10000','1975000','1975000','kasir','2026-08-26 14:28:26','F22626022826');
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-08-26','F226260228261','2026-08-26','14:28:27','TIN','1975000','10000');
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-260826-0026','D','2026-08-26','14:28:27','kasir','PENJUALAN','F226260228261','14071588000','1975000','14073563000');
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 ('F226260244031','kasir','1',' ME2EE KH 1','TOKO','SMBK-E','E2E-ZHBA-112-T','CC MODEL PAKU MATA SLEP KH 16 8K ','OL','0.430','1','100.00','464000','0','0','15000','469000','0','5000','0','474000','DIN','T0082404','E2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-112-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E2E-ZHBA-112-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 ('F226260244031','2026-08-26','0.430','2026-08-26','14:44:04','PLG0083983','469000','469000','5000','474000','474000','kasir','2026-08-26 14:44:03','F22626024403');
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-08-26','F226260244031','2026-08-26','14:44:04','DIN','474000','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-260826-0027','D','2026-08-26','14:44:04','kasir','PENJUALAN','F226260244031','14073563000','474000','14074037000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='474000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260244031' 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 ('F226260244032','kasir',' 1',' ME2EE KH 1','TOKO','SMBK-E','E2E-ZHBA-114-T','CC MODEL PAKU MATA SLEP KH 16 8K ','OL','0.450','1','100.00','486000','0','0','15000','491000','0','5000','0','496000','DIN','T0082406','E2E','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-114-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='E2E-ZHBA-114-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 ('F226260244032','2026-08-26','0.450','2026-08-26','14:44:04','PLG0083984','491000','491000','5000','496000','496000','kasir','2026-08-26 14:44:03','F22626024403');
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-08-26','F226260244032','2026-08-26','14:44:04','DIN','496000','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-260826-0028','D','2026-08-26','14:44:04','kasir','PENJUALAN','F226260244032','14074037000','496000','14074533000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='496000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226260244032' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260908431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260908431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260908431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260923231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260923231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260923231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260942011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260942011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260942011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260946431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260946431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260946431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261031511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261031511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261031511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260106381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260106381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260106381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260112141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260112141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260112141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260124261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260124261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260124261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260124262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260124262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260124262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260158121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260158121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260158121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260158122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260158122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260158122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260212031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260212031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260212031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260226271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260226272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226273' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226273' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260226273';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226274' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226274' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260226274';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260226581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260226581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260228261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260228261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260228261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260244031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260244031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260244031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260244032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260244032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260244032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261053281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261053281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261053281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261053282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261053282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261053282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261053283' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261053283' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261053283';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261053284' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261053284' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261053284';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261057281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261057281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261057281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261107051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261107051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261107051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261144131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261144131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261144131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261144501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261144501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261144501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226261144502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226261144502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226261144502';
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 ('F226260337301','kasir','1',' TEF3 X LT ','TOKO','TBK-F','F3TE-YLBF-46-T','GL X RANTAI HOLLOW P4 SLEP LT 17K ','','4.910','1','100.00','9771000','0','0','15000','9722000','0','0','0','9722000','DIN','T0076216','F3TE','0','0','-','1','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-08-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YLBF-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.910',berat_jual_asli=berat_jual_asli+'4.910',stock_jual='1',berat_akhir=berat_akhir-'4.910',berat_akhir_asli=berat_akhir_asli-'4.910',stock_akhir='0' WHERE tanggal='2026-08-26' AND kode_barang='F3TE-YLBF-46-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226260337301','2026-08-26','4.910','2026-08-26','15:37:30','PLG0083985','9722000','9722000','0','9722000','9722000','kasir','2026-08-26 15:37:30','F22626033730');
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-08-26','F226260337301','2026-08-26','15:37:30','DIN','9722000','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-260826-0029','D','2026-08-26','15:37:30','kasir','PENJUALAN','F226260337301','14074533000','9722000','14084255000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226260337301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226260337301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226260337301';
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-00005661','X-00005661','CC WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','1935000','2026-08-26','2.100','1','admin','2026-08-26 15:46:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005661','X-00005661');
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-260826-0001','F226150235221','TIN','1','BELI','BELI001','E2D', 'X-00005661', 'CC WEDDING MATA CM 20 8K','2.100','2.100','100.00','2153000','1935000','921429','1055000','1','1935000','1935000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.100',berat_beli_asli=berat_beli_asli+'2.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.100',berat_akhir_asli=berat_akhir_asli+'2.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-260826-0001','2026-08-26','2026-08-26','15:46:24','TIN','---','2.100','1935000','1935000','1935000','1935000','1935000','admin','2026-08-26 15:46:25','FB-260826-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260826-0001','HERU','SEMANDING JENANGAN','','','085196639557','admin','2026-08-26 15:46:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-26' 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-260826-0030','K','2026-08-26','15:46:24','admin','PEMBELIAN UMUM','FB-260826-0001','14084255000','1935000','14082320000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260826-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260826-0001';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-26';
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-08-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-26' 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-260827-0001','D','2026-08-27','16:23:56','SYSTEM','SALDO AWAL','SALDO AWAL','0','14082320000','14082320000');
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-260827-0001','D','2026-08-27','16:23:56','BCA','SALDO AWAL','SALDO AWAL','0','4763646888','4763646888');
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-260827-0001','D','2026-08-27','16:23:56','','SALDO AWAL','SALDO AWAL','0','3346000','3346000');
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-260827-0001','D','2026-08-27','16:23:56','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260827-0001','D','2026-08-27','16:23:56','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-260827-0001','D','2026-08-27','16:23:56','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-27';