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-20260722-0001','1','E2D-ZGBA-215-0','1','1.670','1.670','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-215-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-215-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-215-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-215-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-215-0','1','1.670','1.670','1','1.670','1.670','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-ZGBA-215-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-215-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-20260722-0001','1','E2D-ZGBA-216-0','1','1.680','1.680','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-216-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-216-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-216-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-216-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-216-0','1','1.680','1.680','1','1.680','1.680','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-ZGBA-216-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-216-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-20260722-0001','1','E2D-ZGBA-217-0','1','2.260','2.260','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-217-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-217-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-217-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-217-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-217-0','1','2.260','2.260','1','2.260','2.260','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-ZGBA-217-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-217-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-20260722-0001','1','E2D-ZGBA-218-0','1','1.200','1.200','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-218-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-218-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-218-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-218-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-218-0','1','1.200','1.200','1','1.200','1.200','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-ZGBA-218-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-218-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-20260722-0001','1','E2D-ZGBA-219-0','1','0.960','0.960','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-219-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-219-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-219-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-219-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-219-0','1','0.960','0.960','1','0.960','0.960','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-ZGBA-219-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-219-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-20260722-0001','1','E2D-ZGBA-220-0','1','0.900','0.900','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-220-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-220-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-220-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-220-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-220-0','1','0.900','0.900','1','0.900','0.900','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-ZGBA-220-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-220-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-20260722-0001','1','E2D-ZGBA-221-0','1','0.970','0.970','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-221-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-221-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-221-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-221-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-221-0','1','0.970','0.970','1','0.970','0.970','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-ZGBA-221-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-221-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-20260722-0001','1','E2D-ZGBA-222-0','1','1.010','1.010','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-222-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-222-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-222-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-222-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-222-0','1','1.010','1.010','1','1.010','1.010','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-ZGBA-222-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-222-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-20260722-0001','1','E2D-ZGBA-223-0','1','0.830','0.830','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-223-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-223-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-223-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-223-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-223-0','1','0.830','0.830','1','0.830','0.830','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-ZGBA-223-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-223-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-20260722-0001','1','E2D-ZGBA-224-0','1','0.820','0.820','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-224-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-224-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-224-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-224-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-224-0','1','0.820','0.820','1','0.820','0.820','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-ZGBA-224-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-224-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-20260722-0001','1','E2D-ZGBA-225-0','1','1.030','1.030','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-225-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-225-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-225-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-225-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-225-0','1','1.030','1.030','1','1.030','1.030','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-ZGBA-225-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-225-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-20260722-0001','1','E2D-ZGBA-226-0','1','1.110','1.110','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-226-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-226-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-226-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-226-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-226-0','1','1.110','1.110','1','1.110','1.110','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-ZGBA-226-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-226-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-20260722-0001','1','E2D-ZGBA-227-0','1','1.010','1.010','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-227-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-227-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-227-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-227-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-227-0','1','1.010','1.010','1','1.010','1.010','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-ZGBA-227-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-227-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-20260722-0001','1','E2D-ZGBA-228-0','1','0.660','0.660','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZGBA-228-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-228-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2D-ZGBA-228-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZGBA-228-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2D','E2D-ZGBA-228-0','1','0.660','0.660','1','0.660','0.660','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-ZGBA-228-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZGBA-228-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-20260722-0001','1','E2E-ZGBA-229-0','1','0.550','0.550','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZGBA-229-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-229-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2E-ZGBA-229-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZGBA-229-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2E','E2E-ZGBA-229-0','1','0.550','0.550','1','0.550','0.550','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-ZGBA-229-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-229-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-20260722-0001','1','E2E-ZGBA-230-0','1','0.510','0.510','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZGBA-230-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-230-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2E-ZGBA-230-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZGBA-230-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2E','E2E-ZGBA-230-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZGBA-230-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-230-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-20260722-0001','1','E2E-ZGBA-231-0','1','0.430','0.430','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZGBA-231-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-231-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2E-ZGBA-231-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZGBA-231-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2E','E2E-ZGBA-231-0','1','0.430','0.430','1','0.430','0.430','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-ZGBA-231-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-231-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-20260722-0001','1','E2E-ZGBA-232-0','1','0.510','0.510','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZGBA-232-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-232-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2E-ZGBA-232-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZGBA-232-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2E','E2E-ZGBA-232-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZGBA-232-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-232-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-20260722-0001','1','E2E-ZGBA-233-0','1','0.500','0.500','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZGBA-233-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-233-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E2E-ZGBA-233-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZGBA-233-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E2E','E2E-ZGBA-233-0','1','0.500','0.500','1','0.500','0.500','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-ZGBA-233-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZGBA-233-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-20260722-0001','1','E1E-ZGBA-234-0','1','0.520','0.520','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGBA-234-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-234-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E1E-ZGBA-234-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGBA-234-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E1E','E1E-ZGBA-234-0','1','0.520','0.520','1','0.520','0.520','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-ZGBA-234-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-234-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-20260722-0001','1','E1E-ZGBA-235-0','1','0.520','0.520','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGBA-235-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-235-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E1E-ZGBA-235-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGBA-235-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E1E','E1E-ZGBA-235-0','1','0.520','0.520','1','0.520','0.520','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-ZGBA-235-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-235-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-20260722-0001','1','E1E-ZGBA-236-0','1','0.570','0.570','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGBA-236-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-236-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E1E-ZGBA-236-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGBA-236-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E1E','E1E-ZGBA-236-0','1','0.570','0.570','1','0.570','0.570','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-ZGBA-236-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-236-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-20260722-0001','1','E1E-ZGBA-237-0','1','0.470','0.470','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGBA-237-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-237-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E1E-ZGBA-237-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGBA-237-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E1E','E1E-ZGBA-237-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-ZGBA-237-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-237-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-20260722-0001','1','E1E-ZGBA-238-0','1','0.500','0.500','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGBA-238-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-238-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E1E-ZGBA-238-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGBA-238-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E1E','E1E-ZGBA-238-0','1','0.500','0.500','1','0.500','0.500','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-ZGBA-238-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-238-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-20260722-0001','1','E1E-ZGBA-239-0','1','0.750','0.750','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGBA-239-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-239-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E1E-ZGBA-239-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGBA-239-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E1E','E1E-ZGBA-239-0','1','0.750','0.750','1','0.750','0.750','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-ZGBA-239-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-239-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-20260722-0001','1','E1E-ZGBA-240-0','1','0.420','0.420','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZGBA-240-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-240-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E1E-ZGBA-240-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZGBA-240-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E1E','E1E-ZGBA-240-0','1','0.420','0.420','1','0.420','0.420','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-ZGBA-240-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZGBA-240-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-20260722-0001','1','E1F-ZGBA-241-0','1','0.360','0.360','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZGBA-241-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZGBA-241-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E1F-ZGBA-241-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZGBA-241-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E1F','E1F-ZGBA-241-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZGBA-241-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZGBA-241-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-20260722-0001','1','E1D-ZGBA-242-0','1','1.190','1.190','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZGBA-242-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZGBA-242-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-07-22 07:53:19' WHERE kode_barang='E1D-ZGBA-242-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZGBA-242-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:19','TOKO','SMBK-E','E1D','E1D-ZGBA-242-0','1','1.190','1.190','1','1.190','1.190','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-ZGBA-242-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZGBA-242-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260722-0001','2026-07-22','07:53','23.910','input','2026-07-22 07:53:19');
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-20260722-0001','1','F2E-ZGBA-25-0','1','2.950','2.950','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZGBA-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZGBA-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-22 07:53:48' WHERE kode_barang='F2E-ZGBA-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZGBA-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:48','TOKO','SMBK-F','F2E','F2E-ZGBA-25-0','1','2.950','2.950','1','2.950','2.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-ZGBA-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZGBA-25-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-20260722-0001','1','F3E-ZGBA-55-0','1','2.050','2.050','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBA-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-22 07:53:48' WHERE kode_barang='F3E-ZGBA-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBA-55-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:48','TOKO','SMBK-F','F3E','F3E-ZGBA-55-0','1','2.050','2.050','1','2.050','2.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZGBA-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-55-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-20260722-0001','1','F3E-ZGBA-56-0','1','1.410','1.410','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBA-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-56-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-22 07:53:48' WHERE kode_barang='F3E-ZGBA-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBA-56-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:48','TOKO','SMBK-F','F3E','F3E-ZGBA-56-0','1','1.410','1.410','1','1.410','1.410','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-ZGBA-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-56-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-20260722-0001','1','F3E-ZGBA-57-0','1','1.070','1.070','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBA-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-57-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-22 07:53:48' WHERE kode_barang='F3E-ZGBA-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBA-57-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:48','TOKO','SMBK-F','F3E','F3E-ZGBA-57-0','1','1.070','1.070','1','1.070','1.070','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-ZGBA-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-57-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-20260722-0001','1','F3E-ZGBA-58-0','1','1.220','1.220','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBA-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-22 07:53:48' WHERE kode_barang='F3E-ZGBA-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBA-58-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:48','TOKO','SMBK-F','F3E','F3E-ZGBA-58-0','1','1.220','1.220','1','1.220','1.220','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-ZGBA-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-58-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-20260722-0001','1','F3E-ZGBA-59-0','1','1.350','1.350','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBA-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-22 07:53:48' WHERE kode_barang='F3E-ZGBA-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBA-59-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:48','TOKO','SMBK-F','F3E','F3E-ZGBA-59-0','1','1.350','1.350','1','1.350','1.350','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-ZGBA-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-59-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-20260722-0001','1','F3E-ZGBA-60-0','1','0.550','0.550','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBA-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-22 07:53:48' WHERE kode_barang='F3E-ZGBA-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBA-60-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:48','TOKO','SMBK-F','F3E','F3E-ZGBA-60-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-ZGBA-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-60-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-20260722-0001','1','F3E-ZGBA-61-0','1','0.470','0.470','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGBA-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-07-22 07:53:48' WHERE kode_barang='F3E-ZGBA-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGBA-61-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:53:48','TOKO','SMBK-F','F3E','F3E-ZGBA-61-0','1','0.470','0.470','1','0.470','0.470','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-ZGBA-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGBA-61-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260722-0001','2026-07-22','07:53','11.070','input','2026-07-22 07:53: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-20260722-0001','1','H2J-ZGBA-88-0','1','1.270','1.270','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-ZGBA-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZGBA-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-22 07:54:06' WHERE kode_barang='H2J-ZGBA-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZGBA-88-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:54:06','TOKO','SMBK-H','H2J','H2J-ZGBA-88-0','1','1.270','1.270','1','1.270','1.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-ZGBA-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZGBA-88-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-20260722-0001','1','H1E-ZGBA-89-0','1','1.850','1.850','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGBA-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGBA-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-22 07:54:06' WHERE kode_barang='H1E-ZGBA-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGBA-89-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:54:06','TOKO','SMBK-H','H1E','H1E-ZGBA-89-0','1','1.850','1.850','1','1.850','1.850','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-ZGBA-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGBA-89-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-20260722-0001','1','H1E-ZGBA-90-0','1','2.230','2.230','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGBA-90-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGBA-90-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-22 07:54:06' WHERE kode_barang='H1E-ZGBA-90-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGBA-90-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:54:06','TOKO','SMBK-H','H1E','H1E-ZGBA-90-0','1','2.230','2.230','1','2.230','2.230','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-ZGBA-90-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGBA-90-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-20260722-0001','1','H1E-ZGBA-91-0','1','1.680','1.680','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGBA-91-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGBA-91-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-22 07:54:06' WHERE kode_barang='H1E-ZGBA-91-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGBA-91-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:54:06','TOKO','SMBK-H','H1E','H1E-ZGBA-91-0','1','1.680','1.680','1','1.680','1.680','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-ZGBA-91-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGBA-91-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260722-0001','1','H1E-ZGBA-92-0','1','6.260','6.260','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGBA-92-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGBA-92-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-07-22 07:54:06' WHERE kode_barang='H1E-ZGBA-92-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGBA-92-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-07-22 07:54:06','TOKO','SMBK-H','H1E','H1E-ZGBA-92-0','1','6.260','6.260','1','6.260','6.260','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-ZGBA-92-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGBA-92-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260722-0001','2026-07-22','07:53','13.290','input','2026-07-22 07:54:06');
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 ('F226220926191','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGXB-72-T','CC MDOEL ISYANA SLEP LG 16 8K ','OL','0.500','1','100.00','522000','0','0','15000','528000','0','5000','0','533000','LUS','T0080900','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1E-ZGXB-72-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 ('F226220926191','2026-07-22','0.500','2026-07-22','09:26:19','PLG0082438','528000','528000','5000','533000','533000','kasir','2026-07-22 09:26:19','F22622092619');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220926191','2026-07-22','09:26:19','LUS','533000','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-260722-0002','D','2026-07-22','09:26:19','kasir','PENJUALAN','F226220926191','12383378000','533000','12383911000');
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 ('F226220927161','kasir','1',' TEF1 X UB5','TOKO','TBK-F','F1TE-ZFXE-104-T','GL X OVAL C SLEP UB 58 17K ','OL','3.060','1','100.00','5845000','0','0','15000','5885000','0','21000','0','5906000','LUS','T0080406','F1TE','0','0','-','0','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZFXE-104-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='F1TE-ZFXE-104-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 ('F226220927161','2026-07-22','3.060','2026-07-22','09:27:17','PLG0082439','5885000','5885000','21000','5906000','5906000','kasir','2026-07-22 09:27:16','F22622092716');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220927161','2026-07-22','09:27:17','LUS','5906000','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-260722-0003','D','2026-07-22','09:27:17','kasir','PENJUALAN','F226220927161','12383911000','5906000','12389817000');
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 ('F226220959221','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZGBA-33-T','CC MODEL PITA PASIR SLEP CM 14 8K ','OL','0.780','1','100.00','815000','0','0','15000','827000','0','5000','0','832000','TIN','T0081403','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGBA-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1E-ZGBA-33-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 ('F226220959221','2026-07-22','0.780','2026-07-22','09:59:23','PLG0082440','827000','827000','5000','832000','832000','kasir','2026-07-22 09:59:22','F22622095922');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220959221','2026-07-22','09:59:23','TIN','832000','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-260722-0004','D','2026-07-22','09:59:23','kasir','PENJUALAN','F226220959221','12389817000','832000','12390649000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='832000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220959221' 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 ('F226220959222','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZGBA-30-T','CC MODEL PITA PASIR SLEP CM 16 8K ','OL','0.800','1','100.00','836000','0','0','15000','848000','0','5000','0','853000','TIN','T0081400','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGBA-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1E-ZGBA-30-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 ('F226220959222','2026-07-22','0.800','2026-07-22','09:59:23','PLG0082441','848000','848000','5000','853000','853000','kasir','2026-07-22 09:59:22','F22622095922');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220959222','2026-07-22','09:59:23','TIN','853000','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-260722-0005','D','2026-07-22','09:59:23','kasir','PENJUALAN','F226220959222','12390649000','853000','12391502000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='853000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220959222' 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 ('F226221000171','kasir','1',' MDD2D X LG','TOKO','SMBK-D','D2D-ZEBE-129-0','LT X MODEL MATA LG 8K ','OL','1.200','1','100.00','1230000','0','0','15000','1238000','0','10000','0','1248000','TIN','00404828','D2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZEBE-129-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='D2D-ZEBE-129-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 ('F226221000171','2026-07-22','1.200','2026-07-22','10:00:18','PLG0082442','1238000','1238000','10000','1248000','1248000','kasir','2026-07-22 10:00:17','F22622100017');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221000171','2026-07-22','10:00:18','TIN','1248000','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-260722-0006','D','2026-07-22','10:00:18','kasir','PENJUALAN','F226221000171','12391502000','1248000','12392750000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1248000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221000171' 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 ('F226221000172','kasir',' 1',' MEH1 KH 44','TOKO','SMBK-H','H1E-YLAX-69-T','KL SANTA 44CM KH 8K ','OL','4.020','1','100.00','4201000','0','0','15000','4241000','0','20000','0','4261000','TIN','T0075653','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAX-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='H1E-YLAX-69-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 ('F226221000172','2026-07-22','4.020','2026-07-22','10:00:18','PLG0082443','4241000','4241000','20000','4261000','4261000','kasir','2026-07-22 10:00:17','F22622100017');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221000172','2026-07-22','10:00:18','TIN','4261000','20000');
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-260722-0007','D','2026-07-22','10:00:18','kasir','PENJUALAN','F226221000172','12392750000','4261000','12397011000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4261000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221000172' 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 ('F226221000401','kasir','1',' MEE2 X LG ','TOKO','SMBK-E','E2E-ZGBA-232-0','CC X MODEL MATA LG 14 8K ','OL','0.510','1','100.00','533000','0','0','15000','541000','0','5000','0','546000','TIN','00414714','E2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGBA-232-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E2E-ZGBA-232-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 ('F226221000401','2026-07-22','0.510','2026-07-22','10:00:41','PLG0082444','541000','541000','5000','546000','546000','kasir','2026-07-22 10:00:40','F22622100040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221000401','2026-07-22','10:00:41','TIN','546000','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-260722-0008','D','2026-07-22','10:00:41','kasir','PENJUALAN','F226221000401','12397011000','546000','12397557000');
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 ('F226221016281','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGAA-17-T','CC MODEL ISYANA SLEP LG 12 8K ','OL','0.560','1','100.00','585000','0','0','15000','600000','0','5000','0','605000','LUS','T0081028','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGAA-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1E-ZGAA-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 ('F226221016281','2026-07-22','0.560','2026-07-22','10:16:29','PLG0082445','600000','600000','5000','605000','605000','kasir','2026-07-22 10:16:28','F22622101628');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221016281','2026-07-22','10:16:29','LUS','605000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260722-0009','D','2026-07-22','10:16:29','kasir','PENJUALAN','F226221016281','12397557000','605000','12398162000');
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 ('F226221042161','kasir','1',' MEB1E LG P','TOKO','SMBK-B','B1E-ZGAE-55-T','GW DAISY MATA SLEP LG PE 8K ','','0.500','1','100.00','522000','0','0','15000','525000','0','0','0','525000','LUS','T0081200','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAE-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='B1E-ZGAE-55-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 ('F226221042161','2026-07-22','0.500','2026-07-22','10:42:16','PLG0082446','525000','525000','0','525000','525000','kasir','2026-07-22 10:42:16','F22622104216');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221042161','2026-07-22','10:42:16','LUS','525000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260722-0010','D','2026-07-22','10:42:16','kasir','PENJUALAN','F226221042161','12398162000','525000','12398687000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='525000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221042161' 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 ('F226221042162','kasir',' 1',' MEF1E TD 6','TOKO','SMBK-F','F1E-ZGAE-75-T','GL OVAL C SLEP TD 60 8K ','','3.560','1','100.00','3720000','0','0','15000','3738000','0','0','0','3738000','LUS','T0081220','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAE-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.560',berat_jual_asli=berat_jual_asli+'3.560',stock_jual='1',berat_akhir=berat_akhir-'3.560',berat_akhir_asli=berat_akhir_asli-'3.560',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='F1E-ZGAE-75-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 ('F226221042162','2026-07-22','3.560','2026-07-22','10:42:16','PLG0082447','3738000','3738000','0','3738000','3738000','kasir','2026-07-22 10:42:16','F22622104216');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221042162','2026-07-22','10:42:16','LUS','3738000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260722-0011','D','2026-07-22','10:42:16','kasir','PENJUALAN','F226221042162','12398687000','3738000','12402425000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3738000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221042162' 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 ('F226221044381','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBA-17-T','CC MODEL PAKU SLEP KH 12 8K ','OL','0.400','1','100.00','426000','0','0','15000','432000','0','5000','0','437000','TIN','T0081387','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1F-ZGBA-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 ('F226221044381','2026-07-22','0.400','2026-07-22','10:44:38','PLG0082448','432000','432000','5000','437000','437000','kasir','2026-07-22 10:44:38','F22622104438');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221044381','2026-07-22','10:44:38','TIN','437000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260722-0012','D','2026-07-22','10:44:38','kasir','PENJUALAN','F226221044381','12402425000','437000','12402862000');
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 ('F226221045221','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBA-21-T','CC MODEL PAKU SLEP KH 15 8K ','OL','0.390','1','100.00','415000','0','0','15000','421000','0','5000','0','426000','TIN','T0081391','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.390',berat_jual_asli=berat_jual_asli+'0.390',stock_jual='1',berat_akhir=berat_akhir-'0.390',berat_akhir_asli=berat_akhir_asli-'0.390',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1F-ZGBA-21-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 ('F226221045221','2026-07-22','0.390','2026-07-22','10:45:23','PLG0082449','421000','421000','5000','426000','426000','kasir','2026-07-22 10:45:22','F22622104522');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221045221','2026-07-22','10:45:23','TIN','426000','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-260722-0013','D','2026-07-22','10:45:23','kasir','PENJUALAN','F226221045221','12402862000','426000','12403288000');
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 ('F226221141531','kasir','1',' MEB1 X CM ','TOKO','SMBK-B','B1E-ZGXI-49-0','GW X MODEL SLEP CM PE 8K ','OL','0.580','1','100.00','606000','0','0','15000','621000','0','5000','0','626000','LUS','00412768','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXI-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='B1E-ZGXI-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226221141531','2026-07-22','0.580','2026-07-22','11:41:53','PLG0082450','621000','621000','5000','626000','626000','kasir','2026-07-22 11:41:53','F22622114153');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221141531','2026-07-22','11:41:53','LUS','626000','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-260722-0014','D','2026-07-22','11:41:53','kasir','PENJUALAN','F226221141531','12403288000','626000','12403914000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221141531';
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 ('F226221147171','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBA-7-T','CC MODEL SPECTRA SLEP KH 12 8K ','ol','0.340','1','100.00','362000','0','0','15000','367000','0','5000','0','372000','LUS','T0081377','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1F-ZGBA-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226221147171','2026-07-22','0.340','2026-07-22','11:47:18','PLG0082451','367000','367000','5000','372000','372000','kasir','2026-07-22 11:47:17','F22622114717');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221147171','2026-07-22','11:47:18','LUS','372000','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-260722-0015','D','2026-07-22','11:47:18','kasir','PENJUALAN','F226221147171','12403914000','372000','12404286000');
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 ('F226221149091','kasir','1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZGAE-31-T','LT CHARM HATI SLEP BG 8K ','','0.500','1','100.00','532000','0','0','15000','535000','0','5000','0','540000','DIN','T0081176','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAE-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='D1F-ZGAE-31-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 ('F226221149091','2026-07-22','0.500','2026-07-22','11:49:09','PLG0082452','535000','535000','5000','540000','540000','kasir','2026-07-22 11:49:09','F22622114909');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221149091','2026-07-22','11:49:09','DIN','540000','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-260722-0016','D','2026-07-22','11:49:09','kasir','PENJUALAN','F226221149091','12404286000','540000','12404826000');
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 ('F226221149531','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBA-9-T','CC MODEL SPECTRA SLEP KH 18 8K ','','0.370','1','100.00','394000','0','0','15000','396000','0','0','0','396000','TIN','T0081379','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1F-ZGBA-9-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 ('F226221149531','2026-07-22','0.370','2026-07-22','11:49:54','PLG0082453','396000','396000','0','396000','396000','kasir','2026-07-22 11:49:53','F22622114953');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221149531','2026-07-22','11:49:54','TIN','396000','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-260722-0017','D','2026-07-22','11:49:54','kasir','PENJUALAN','F226221149531','12404826000','396000','12405222000');
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 ('F226221208441','kasir','1',' MDE1D LG 1','TOKO','SMBK-E','E1D-ZGXB-94-T','CC MODEL ISYANA SLEP LG 16 8K ','','0.970','1','100.00','994000','0','0','15000','1000000','0','0','0','1000000','LUS','T0080922','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGXB-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1D-ZGXB-94-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 ('F226221208441','2026-07-22','0.970','2026-07-22','12:08:45','PLG0082454','1000000','1000000','0','1000000','1000000','kasir','2026-07-22 12:08:44','F22622120844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221208441','2026-07-22','12:08:45','LUS','1000000','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-260722-0018','D','2026-07-22','12:08:45','kasir','PENJUALAN','F226221208441','12405222000','1000000','12406222000');
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 ('F226221219321','kasir','1',' MEH1 UB 42','TOKO','SMBK-H','H1E-ZEAB-42-T','KL SANTA UB 42CM 8K ','ol','1.070','1','100.00','1118000','0','0','15000','1130000','0','5000','0','1135000','TIN','T0079400','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEAB-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='H1E-ZEAB-42-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 ('F226221219321','2026-07-22','1.070','2026-07-22','12:19:32','PLG0082455','1130000','1130000','5000','1135000','1135000','kasir','2026-07-22 12:19:32','F22622121932');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221219321','2026-07-22','12:19:32','TIN','1135000','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-260722-0019','D','2026-07-22','12:19:32','kasir','PENJUALAN','F226221219321','12406222000','1135000','12407357000');
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 ('F226221228281','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGBA-41-T','KL RANTAI HOLLOW VAR KH 42 8K ','ol','1.870','1','100.00','1954000','0','0','15000','1973000','0','9000','0','1982000','DIN','T0081411','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBA-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='H1E-ZGBA-41-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 ('F226221228281','2026-07-22','1.870','2026-07-22','12:28:29','PLG0082456','1973000','1973000','9000','1982000','1982000','kasir','2026-07-22 12:28:28','F22622122828');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226221228281','2026-07-22','12:28:29','DIN','1982000','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-260722-0020','D','2026-07-22','12:28:29','kasir','PENJUALAN','F226221228281','12407357000','1982000','12409339000');
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 ('F226220104101','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBA-16-T','CC MODEL PAKU SLEP KH 10 8K ','ol','0.390','1','100.00','415000','0','0','15000','421000','0','5000','0','426000','TIN','T0081386','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.390',berat_jual_asli=berat_jual_asli+'0.390',stock_jual='1',berat_akhir=berat_akhir-'0.390',berat_akhir_asli=berat_akhir_asli-'0.390',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1F-ZGBA-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226220104101','2026-07-22','0.390','2026-07-22','13:04:10','PLG0082457','421000','421000','5000','426000','426000','kasir','2026-07-22 13:04:10','F22622010410');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220104101','2026-07-22','13:04:10','TIN','426000','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-260722-0021','D','2026-07-22','13:04:10','kasir','PENJUALAN','F226220104101','12409339000','426000','12409765000');
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 ('F226220104371','kasir','1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZGBA-50-T','GL OVAL C SLEP TD 52 8K ','ol','2.970','1','100.00','3104000','0','0','15000','3133000','0','15000','0','3148000','TIN','T0081420','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGBA-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='F1E-ZGBA-50-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 ('F226220104371','2026-07-22','2.970','2026-07-22','13:04:38','PLG0082458','3133000','3133000','15000','3148000','3148000','kasir','2026-07-22 13:04:37','F22622010437');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220104371','2026-07-22','13:04:38','TIN','3148000','15000');
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-260722-0022','D','2026-07-22','13:04:38','kasir','PENJUALAN','F226220104371','12409765000','3148000','12412913000');
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 ('F226220151301','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGBA-10-T','CC MODEL SPECTRA SLEP KH 10 8K ','ol','0.320','1','100.00','341000','0','0','15000','346000','0','5000','0','351000','DIN','T0081380','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1F-ZGBA-10-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 ('F226220151301','2026-07-22','0.320','2026-07-22','13:51:31','PLG0082459','346000','346000','5000','351000','351000','kasir','2026-07-22 13:51:30','F22622015130');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220151301','2026-07-22','13:51:31','DIN','351000','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-260722-0023','D','2026-07-22','13:51:31','kasir','PENJUALAN','F226220151301','12412913000','351000','12413264000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='351000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220151301' 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 ('F226220151302','kasir',' 1',' MFE1F HW 1','TOKO','SMBK-E','E1F-ZGBA-28-T','CC MODEL GELOMBANG SLEP HW 12 8K ','ol','0.320','1','100.00','341000','0','0','15000','346000','0','5000','0','351000','DIN','T0081398','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1F-ZGBA-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 ('F226220151302','2026-07-22','0.320','2026-07-22','13:51:31','PLG0082460','346000','346000','5000','351000','351000','kasir','2026-07-22 13:51:30','F22622015130');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220151302','2026-07-22','13:51:31','DIN','351000','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-260722-0024','D','2026-07-22','13:51:31','kasir','PENJUALAN','F226220151302','12413264000','351000','12413615000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='351000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220151302' 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 ('F226220152331','kasir','1',' MEF3 6K UB','TOKO','SMBK-F','F3E-ZFXD-34-T','GL RANTAI P3 SLEP UB 8K ','','1.030','1','100.00','1076000','0','0','15000','1081000','0','6000','0','1087000','RHM','T0080199','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='F3E-ZFXD-34-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 ('F226220152331','2026-07-22','1.030','2026-07-22','13:52:34','PLG0082461','1081000','1081000','6000','1087000','1087000','kasir','2026-07-22 13:52:33','F22622015233');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220152331','2026-07-22','13:52:34','RHM','1087000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260722-0025','D','2026-07-22','13:52:34','kasir','PENJUALAN','F226220152331','12413615000','1087000','12414702000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1087000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220152331' 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 ('F226220152332','kasir',' 1',' MIS1I LG ','TOKO','SMBK-S','S1G-ZGXB-4-T','AS EXTENSION LG 8K ','','0.180','1','100.00','195000','0','0','15000','203000','0','0','0','203000','RHM','T0080832','S1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZGXB-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.180',berat_jual_asli=berat_jual_asli+'0.180',stock_jual='1',berat_akhir=berat_akhir-'0.180',berat_akhir_asli=berat_akhir_asli-'0.180',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='S1G-ZGXB-4-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' 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 ('F226220152332','2026-07-22','0.180','2026-07-22','13:52:34','PLG0082462','203000','203000','0','203000','203000','kasir','2026-07-22 13:52:33','F22622015233');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220152332','2026-07-22','13:52:34','RHM','203000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260722-0026','D','2026-07-22','13:52:34','kasir','PENJUALAN','F226220152332','12414702000','203000','12414905000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='203000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220152332' 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 ('F226220219051','kasir','1',' MDE2 5K LG','TOKO','SMBK-E','E2D-ZDBB-83-T','CC ANAK EROPA MATA LG 8K ','','1.230','1','100.00','1261000','0','0','15000','1267000','0','5000','0','1272000','RHM','T0078873','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBB-83-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E2D-ZDBB-83-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 ('F226220219051','2026-07-22','1.230','2026-07-22','14:19:06','PLG0082463','1267000','1267000','5000','1272000','1272000','kasir','2026-07-22 14:19:05','F22622021905');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220219051','2026-07-22','14:19:06','RHM','1272000','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-260722-0027','D','2026-07-22','14:19:06','kasir','PENJUALAN','F226220219051','12414905000','1272000','12416177000');
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 ('F226220231571','kasir','1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZFBI-117-0','CC X BONEKA ANAK CAT MATA LG 8K ','','0.580','1','100.00','606000','0','0','15000','609000','0','0','0','609000','NOV','00411109','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBI-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1E-ZFBI-117-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 ('F226220231571','2026-07-22','0.580','2026-07-22','14:31:57','PLG0082464','609000','609000','0','609000','0','kasir','2026-07-22 14:31:57','F22622023157');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220231571','2026-07-22','14:31:57','NOV','609000','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-260722-0001','2026-07-22','2026-07-22 14:31:57','PENJUALAN : F226220231571','3344557766877989','BCA','609000','609000','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-260722-0002','D','2026-07-22','14:31:57','BCA','PENJUALAN','F226220231571','4638035888','609000','4638644888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('3344557766877989','VIONITA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='609000' WHERE no_faktur_jual='F226220231571' 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 ('F226220242481','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGAX-31-0','KL SANTA KH 42 8K ','ol','2.020','1','100.00','2111000','0','0','15000','2131000','0','10000','0','2141000','DIN','00413107','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAX-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='H1E-ZGAX-31-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 ('F226220242481','2026-07-22','2.020','2026-07-22','14:42:48','PLG0082465','2131000','2131000','10000','2141000','2141000','kasir','2026-07-22 14:42:48','F22622024248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220242481','2026-07-22','14:42:48','DIN','2141000','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-260722-0028','D','2026-07-22','14:42:48','kasir','PENJUALAN','F226220242481','12416177000','2141000','12418318000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2141000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220242481' 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 ('F226220242482','kasir',' 1',' MFD1F HW ','TOKO','SMBK-D','D1F-ZFBE-81-T','LT MODEL PITA SLEP HW 8K ','ol','0.310','1','100.00','330000','0','0','15000','335000','0','5000','0','340000','DIN','T0080823','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFBE-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='D1F-ZFBE-81-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 ('F226220242482','2026-07-22','0.310','2026-07-22','14:42:48','PLG0082466','335000','335000','5000','340000','340000','kasir','2026-07-22 14:42:48','F22622024248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220242482','2026-07-22','14:42:48','DIN','340000','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-260722-0029','D','2026-07-22','14:42:48','kasir','PENJUALAN','F226220242482','12418318000','340000','12418658000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='340000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220242482' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220926191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220926191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220926191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220927161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220927161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220927161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220959221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220959221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220959221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220959222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220959222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220959222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221000171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221000171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221000171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221000172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221000172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221000172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221000401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221000401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221000401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221016281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221016281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221016281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221042161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221042161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221042161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221042162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221042162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221042162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221044381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221044381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221044381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221045221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221045221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221045221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220104101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220104101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220104101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220104371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220104371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220104371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220151301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220151301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220151301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220151302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220151302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220151302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220152331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220152331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220152331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220152332' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220152332' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220152332';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220219051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220219051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220219051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220231571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220231571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220231571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220242481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220242481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220242481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220242482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220242482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220242482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221147171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221147171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221147171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221149091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221149091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221149091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221149531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221149531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221149531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221208441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221208441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221208441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221219321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221219321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221219321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221228281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221228281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221228281';
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-00005552','X-00005552','AT KLIP MODEL MATA VAR SB','GR','---','A1E','BELI','BELI001','770000','2026-07-22','1.000','1','admin','2026-07-22 15:18:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005552','X-00005552');
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-260722-0001','F224271256291','DIN','1','BELI','BELI001','A1E', 'X-00005552', 'AT KLIP MODEL MATA VAR SB','1.300','1.000','100.00','774000','770000','770000','1045000','1','770000','770000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260722-0001','2026-07-22','2026-07-22','15:18:36','DIN','---','1.000','770000','770000','770000','770000','770000','admin','2026-07-22 15:18:36','FB-260722-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260722-0001','ALIYA','JURUG SOOKO 1/3','','','082136321275','admin','2026-07-22 15:18:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-22' 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-260722-0030','K','2026-07-22','15:18:36','admin','PEMBELIAN UMUM','FB-260722-0001','12418658000','770000','12417888000');
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-00005553','X-00005553','AT X ITALY SLEP VAR UB 8K','GR','---','A1D','BELI','BELI001','975000','2026-07-22','1.030','1','admin','2026-07-22 15:18:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005553','X-00005553');
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-260722-0002','F226200221421','DIN','2','BELI','BELI001','A1D', 'X-00005553', 'AT X ITALY SLEP VAR UB 8K','1.030','1.030','100.00','1267000','975000','946602','1025000','1','975000','975000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-260722-0002','2026-07-22','2026-07-22','15:18:36','DIN','---','1.030','975000','975000','975000','975000','975000','admin','2026-07-22 15:18:36','FB-260722-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260722-0002','KALIMAH','BABADAN','','','085132047236','admin','2026-07-22 15:18:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-22' 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-260722-0031','K','2026-07-22','15:18:36','admin','PEMBELIAN UMUM','FB-260722-0002','12417888000','975000','12416913000');
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-00005554','X-00005554','AT JERSY POLOS LG 8K','GR','---','A1D','BELI','BELI001','880000','2026-07-22','0.950','1','admin','2026-07-22 15:18:36');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005554','X-00005554');
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-260722-0003','F226071011211','DIN','3','BELI','BELI001','A1D', 'X-00005554', 'AT JERSY POLOS LG 8K','0.950','0.950','100.00','1150000','880000','926316','1025000','1','880000','880000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-260722-0003','2026-07-22','2026-07-22','15:18:36','DIN','---','0.950','880000','880000','880000','880000','880000','admin','2026-07-22 15:18:36','FB-260722-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260722-0003','DESCHA','BABADAN','','','081353358676','admin','2026-07-22 15:18:36');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-22' 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-260722-0032','K','2026-07-22','15:18:36','admin','PEMBELIAN UMUM','FB-260722-0003','12416913000','880000','12416033000');
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-00005555','X-00005555','CC X MODEL MATA CM 12 8K','GR','---','E2E','BELI','BELI001','720000','2026-07-22','0.750','1','admin','2026-07-22 15:19:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005555','X-00005555');
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-260722-0004','F226070256251','LUS','1','BELI','BELI001','E2E', 'X-00005555', 'CC X MODEL MATA CM 12 8K','0.750','0.750','100.00','870000','720000','960000','1045000','1','720000','720000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260722-0004','2026-07-22','2026-07-22','15:19:15','LUS','---','0.750','720000','720000','720000','720000','720000','admin','2026-07-22 15:19:16','FB-260722-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260722-0004','RAHMA','TRENCENG MRICAN','','','085707688902','admin','2026-07-22 15:19:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-22' 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-260722-0033','K','2026-07-22','15:19:15','admin','PEMBELIAN UMUM','FB-260722-0004','12416033000','720000','12415313000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260722-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260722-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260722-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260722-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260722-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260722-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260722-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260722-0004';
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 ('F226220331121','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGAX-25-T','KL SIEM COBRA MATA VAR SLEP KH 42 8K ','OL','2.030','1','100.00','2121000','0','0','15000','2132000','0','10000','0','2142000','LUS','T0080985','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAX-25-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-07-22' AND kode_barang='H1E-ZGAX-25-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 ('F226220331121','2026-07-22','2.030','2026-07-22','15:31:12','PLG0082467','2132000','2132000','10000','2142000','2142000','kasir','2026-07-22 15:31:12','F22622033112');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220331121','2026-07-22','15:31:12','LUS','2142000','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-260722-0034','D','2026-07-22','15:31:12','kasir','PENJUALAN','F226220331121','12415313000','2142000','12417455000');
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 ('F226220335481','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZGAH-3-T','CC WEDDING MATA SLEP CM 20 8K ','','1.530','1','100.00','1568000','0','0','15000','1576000','0','10000','0','1586000','NOV','T0081308','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAH-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E2D-ZGAH-3-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 ('F226220335481','2026-07-22','1.530','2026-07-22','15:35:49','PLG0082468','1576000','1576000','10000','1586000','1586000','kasir','2026-07-22 15:35:48','F22622033548');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220335481','2026-07-22','15:35:49','NOV','1586000','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-260722-0035','D','2026-07-22','15:35:49','kasir','PENJUALAN','F226220335481','12417455000','1586000','12419041000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1586000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220335481' 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 ('F226220335482','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZEBF-40-T','CC WEDDING MATA SLEP CM 12 8K ','','1.600','1','100.00','1640000','0','0','15000','1648000','0','10000','0','1658000','NOV','T0079923','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBF-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E2D-ZEBF-40-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 ('F226220335482','2026-07-22','1.600','2026-07-22','15:35:49','PLG0082469','1648000','1648000','10000','1658000','1658000','kasir','2026-07-22 15:35:48','F22622033548');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220335482','2026-07-22','15:35:49','NOV','1658000','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-260722-0036','D','2026-07-22','15:35:49','kasir','PENJUALAN','F226220335482','12419041000','1658000','12420699000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1658000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220335482' 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 ('F226220340581','kasir','1',' MED1E HW ','TOKO','SMBK-D','D1E-ZGAH-44-T','LT MODEL SPECTRA SLEP HW 8K ','OL','0.600','1','100.00','627000','0','0','15000','645000','0','5000','0','650000','LUS','T0081349','D1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZGAH-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='D1E-ZGAH-44-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 ('F226220340581','2026-07-22','0.600','2026-07-22','15:40:58','PLG0082470','645000','645000','5000','650000','650000','kasir','2026-07-22 15:40:58','F22622034058');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220340581','2026-07-22','15:40:58','LUS','650000','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-260722-0037','D','2026-07-22','15:40:58','kasir','PENJUALAN','F226220340581','12420699000','650000','12421349000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220340581' 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 ('F226220340582','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGAA-33-T','KL MILANO UB 40 8K ','OL','2.120','1','100.00','2215000','0','0','15000','2269000','0','11000','0','2280000','LUS','T0081044','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAA-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='H1E-ZGAA-33-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 ('F226220340582','2026-07-22','2.120','2026-07-22','15:40:58','PLG0082471','2269000','2269000','11000','2280000','2280000','kasir','2026-07-22 15:40:58','F22622034058');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220340582','2026-07-22','15:40:58','LUS','2280000','11000');
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-260722-0038','D','2026-07-22','15:40:58','kasir','PENJUALAN','F226220340582','12421349000','2280000','12423629000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2280000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220340582' 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 ('F226220341301','kasir','1',' MFE1 X HW ','TOKO','SMBK-E','E1F-ZFBI-118-0','CC X RIG GELOMBANG HW 13 8K ','OL','0.350','1','100.00','373000','0','0','15000','383000','0','5000','0','388000','LUS','00411110','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZFBI-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='E1F-ZFBI-118-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 ('F226220341301','2026-07-22','0.350','2026-07-22','15:41:30','PLG0082472','383000','383000','5000','388000','388000','kasir','2026-07-22 15:41:30','F22622034130');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-22','F226220341301','2026-07-22','15:41:30','LUS','388000','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-260722-0039','D','2026-07-22','15:41:30','kasir','PENJUALAN','F226220341301','12423629000','388000','12424017000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220331121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220331121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220331121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220335481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220335481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220335481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220335482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220335482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220335482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220340581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220340581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220340581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220340582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220340582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220340582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220341301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220341301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220341301';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-22';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-22' 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-260723-0001','D','2026-07-23','16:20:41','SYSTEM','SALDO AWAL','SALDO AWAL','0','12424017000','12424017000');
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-260723-0001','D','2026-07-23','16:20:41','BCA','SALDO AWAL','SALDO AWAL','0','4638644888','4638644888');
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-260723-0001','D','2026-07-23','16:20:41','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260723-0001','D','2026-07-23','16:20:41','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-260723-0001','D','2026-07-23','16:20:41','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-260723-0001','D','2026-07-23','16:20:41','','SALDO AWAL','SALDO AWAL','0','2260000','2260000');
UPDATE tp_system SET tgl_system='2026-07-23';