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-20260421-0001','1','B1E-ZDXI-61-0','1','0.570','0.570','TOKO','SBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZDXI-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZDXI-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-04-21 08:06:08' WHERE kode_barang='B1E-ZDXI-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZDXI-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-04-21 08:06:08','TOKO','SMBK-B','B1E','B1E-ZDXI-61-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZDXI-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZDXI-61-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260421-0001','2026-04-21','08:06','0.570','input','2026-04-21 08:06:07');
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-20260421-0001','1','A1D-ZDBX-221-0','1','1.250','1.250','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZDBX-221-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZDBX-221-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-04-21 08:09:43' WHERE kode_barang='A1D-ZDBX-221-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZDBX-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-04-21 08:09:43','TOKO','SMBK-A','A1D','A1D-ZDBX-221-0','1','1.250','1.250','1','1.250','1.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZDBX-221-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZDBX-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-20260421-0001','1','A1E-ZDBX-222-0','1','0.550','0.550','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZDBX-222-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZDBX-222-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-04-21 08:09:43' WHERE kode_barang='A1E-ZDBX-222-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZDBX-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-04-21 08:09:43','TOKO','SMBK-A','A1E','A1E-ZDBX-222-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZDBX-222-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZDBX-222-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260421-0001','2026-04-21','08:09','1.800','input','2026-04-21 08:09:42');
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-20260421-0001','1','B1E-ZDBX-242-0','1','0.580','0.580','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZDBX-242-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZDBX-242-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-04-21 08:10:01' WHERE kode_barang='B1E-ZDBX-242-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZDBX-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-04-21 08:10:01','TOKO','SMBK-B','B1E','B1E-ZDBX-242-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZDBX-242-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZDBX-242-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-20260421-0001','1','B1E-ZDBX-243-0','1','0.550','0.550','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZDBX-243-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZDBX-243-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-04-21 08:10:01' WHERE kode_barang='B1E-ZDBX-243-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZDBX-243-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-04-21 08:10:01','TOKO','SMBK-B','B1E','B1E-ZDBX-243-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZDBX-243-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZDBX-243-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260421-0001','2026-04-21','08:09','1.130','input','2026-04-21 08:10:01');
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-20260421-0001','1','D1E-ZDBX-274-0','1','0.480','0.480','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZDBX-274-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZDBX-274-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-21 08:10:21' WHERE kode_barang='D1E-ZDBX-274-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZDBX-274-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-04-21 08:10:21','TOKO','SMBK-D','D1E','D1E-ZDBX-274-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZDBX-274-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZDBX-274-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-20260421-0001','1','D1G-ZDBX-275-0','1','0.320','0.320','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZDBX-275-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZDBX-275-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-21 08:10:21' WHERE kode_barang='D1G-ZDBX-275-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZDBX-275-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-04-21 08:10:21','TOKO','SMBK-D','D1G','D1G-ZDBX-275-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZDBX-275-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZDBX-275-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-20260421-0001','1','D1G-ZDBX-276-0','1','0.360','0.360','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1G-ZDBX-276-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1G-ZDBX-276-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-04-21 08:10:21' WHERE kode_barang='D1G-ZDBX-276-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1G-ZDBX-276-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-04-21 08:10:21','TOKO','SMBK-D','D1G','D1G-ZDBX-276-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1G-ZDBX-276-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1G-ZDBX-276-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260421-0001','2026-04-21','08:10','1.160','input','2026-04-21 08:10:20');
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-20260421-0001','1','E2D-ZDBX-333-0','1','1.450','1.450','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDBX-333-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDBX-333-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2D-ZDBX-333-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDBX-333-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-04-21 08:10:37','TOKO','SMBK-E','E2D','E2D-ZDBX-333-0','1','1.450','1.450','1','1.450','1.450','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-ZDBX-333-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDBX-333-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-20260421-0001','1','E2D-ZDBX-334-0','1','0.930','0.930','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDBX-334-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDBX-334-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2D-ZDBX-334-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDBX-334-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-04-21 08:10:37','TOKO','SMBK-E','E2D','E2D-ZDBX-334-0','1','0.930','0.930','1','0.930','0.930','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-ZDBX-334-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDBX-334-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-20260421-0001','1','E2D-ZDBX-335-0','1','1.150','1.150','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDBX-335-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDBX-335-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2D-ZDBX-335-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDBX-335-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-04-21 08:10:37','TOKO','SMBK-E','E2D','E2D-ZDBX-335-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZDBX-335-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDBX-335-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-20260421-0001','1','E2D-ZDBX-336-0','1','1.000','1.000','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZDBX-336-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZDBX-336-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2D-ZDBX-336-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZDBX-336-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-04-21 08:10:37','TOKO','SMBK-E','E2D','E2D-ZDBX-336-0','1','1.000','1.000','1','1.000','1.000','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-ZDBX-336-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZDBX-336-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-20260421-0001','1','E2E-ZDBX-337-0','1','0.730','0.730','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZDBX-337-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-337-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2E-ZDBX-337-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZDBX-337-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-04-21 08:10:37','TOKO','SMBK-E','E2E','E2E-ZDBX-337-0','1','0.730','0.730','1','0.730','0.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZDBX-337-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-337-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-20260421-0001','1','E2E-ZDBX-338-0','1','0.620','0.620','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZDBX-338-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-338-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2E-ZDBX-338-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZDBX-338-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-04-21 08:10:37','TOKO','SMBK-E','E2E','E2E-ZDBX-338-0','1','0.620','0.620','1','0.620','0.620','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-ZDBX-338-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-338-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-20260421-0001','1','E2E-ZDBX-339-0','1','0.510','0.510','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZDBX-339-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-339-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2E-ZDBX-339-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZDBX-339-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-04-21 08:10:37','TOKO','SMBK-E','E2E','E2E-ZDBX-339-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-ZDBX-339-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-339-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-20260421-0001','1','E2E-ZDBX-340-0','1','0.680','0.680','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZDBX-340-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-340-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2E-ZDBX-340-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZDBX-340-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-04-21 08:10:37','TOKO','SMBK-E','E2E','E2E-ZDBX-340-0','1','0.680','0.680','1','0.680','0.680','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-ZDBX-340-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-340-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-20260421-0001','1','E2E-ZDBX-341-0','1','0.480','0.480','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZDBX-341-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-341-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2E-ZDBX-341-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZDBX-341-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-04-21 08:10:37','TOKO','SMBK-E','E2E','E2E-ZDBX-341-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZDBX-341-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-341-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-20260421-0001','1','E2E-ZDBX-342-0','1','0.430','0.430','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZDBX-342-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-342-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2E-ZDBX-342-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZDBX-342-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-04-21 08:10:37','TOKO','SMBK-E','E2E','E2E-ZDBX-342-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-ZDBX-342-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-342-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-20260421-0001','1','E2E-ZDBX-343-0','1','0.600','0.600','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZDBX-343-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-343-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E2E-ZDBX-343-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZDBX-343-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-04-21 08:10:37','TOKO','SMBK-E','E2E','E2E-ZDBX-343-0','1','0.600','0.600','1','0.600','0.600','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-ZDBX-343-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZDBX-343-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-20260421-0001','1','E1D-ZDBX-344-0','1','1.170','1.170','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZDBX-344-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZDBX-344-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E1D-ZDBX-344-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZDBX-344-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-04-21 08:10:37','TOKO','SMBK-E','E1D','E1D-ZDBX-344-0','1','1.170','1.170','1','1.170','1.170','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-ZDBX-344-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZDBX-344-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-20260421-0001','1','E1E-ZDBX-345-0','1','0.670','0.670','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZDBX-345-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZDBX-345-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-21 08:10:37' WHERE kode_barang='E1E-ZDBX-345-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZDBX-345-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-04-21 08:10:37','TOKO','SMBK-E','E1E','E1E-ZDBX-345-0','1','0.670','0.670','1','0.670','0.670','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-ZDBX-345-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZDBX-345-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260421-0001','2026-04-21','08:10','10.420','input','2026-04-21 08:10:37');
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-20260421-0001','1','F3E-ZDBX-135-0','1','1.150','1.150','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZDBX-135-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZDBX-135-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-04-21 08:10:57' WHERE kode_barang='F3E-ZDBX-135-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZDBX-135-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-21 08:10:57','TOKO','SMBK-F','F3E','F3E-ZDBX-135-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZDBX-135-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZDBX-135-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260421-0001','1','F3E-ZDBX-136-0','1','2.750','2.750','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZDBX-136-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZDBX-136-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-04-21 08:10:57' WHERE kode_barang='F3E-ZDBX-136-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZDBX-136-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-21 08:10:57','TOKO','SMBK-F','F3E','F3E-ZDBX-136-0','1','2.750','2.750','1','2.750','2.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZDBX-136-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZDBX-136-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-20260421-0001','1','F3G-ZDBX-137-0','1','0.350','0.350','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3G-ZDBX-137-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3G-ZDBX-137-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-04-21 08:10:57' WHERE kode_barang='F3G-ZDBX-137-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3G-ZDBX-137-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-04-21 08:10:57','TOKO','SMBK-F','F3G','F3G-ZDBX-137-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3G-ZDBX-137-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3G-ZDBX-137-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260421-0001','2026-04-21','08:10','4.250','input','2026-04-21 08:10:57');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260421-0001','1','H1E-ZDBX-173-0','1','2.390','2.390','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZDBX-173-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZDBX-173-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-04-21 08:11:19' WHERE kode_barang='H1E-ZDBX-173-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZDBX-173-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-21 08:11:19','TOKO','SMBK-H','H1E','H1E-ZDBX-173-0','1','2.390','2.390','1','2.390','2.390','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-ZDBX-173-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZDBX-173-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260421-0001','1','H1E-ZDBX-174-0','1','2.100','2.100','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZDBX-174-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZDBX-174-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-04-21 08:11:19' WHERE kode_barang='H1E-ZDBX-174-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZDBX-174-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-21 08:11:19','TOKO','SMBK-H','H1E','H1E-ZDBX-174-0','1','2.100','2.100','1','2.100','2.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZDBX-174-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZDBX-174-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260421-0001','2026-04-21','08:11','4.490','input','2026-04-21 08:11:18');
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-20260421-0001','1','S1G-ZDBX-179-0','1','0.330','0.330','TOKO','SSBK-S','TOKO','SMBK-S');
DELETE FROM tm_barang WHERE kode_barang='S1G-ZDBX-179-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1G-ZDBX-179-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-S',tgl_last_beli='2026-04-21 08:11:43' WHERE kode_barang='S1G-ZDBX-179-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1G-ZDBX-179-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-21 08:11:43','TOKO','SMBK-S','S1G','S1G-ZDBX-179-0','1','0.330','0.330','1','0.330','0.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='S1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='S1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='S1G-ZDBX-179-0';
DELETE FROM tm_barang_export WHERE kode_barang='S1G-ZDBX-179-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260421-0001','1','S1G-ZDBX-180-0','1','0.320','0.320','TOKO','SSBK-S','TOKO','SMBK-S');
DELETE FROM tm_barang WHERE kode_barang='S1G-ZDBX-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1G-ZDBX-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-S',tgl_last_beli='2026-04-21 08:11:43' WHERE kode_barang='S1G-ZDBX-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1G-ZDBX-180-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-21 08:11:43','TOKO','SMBK-S','S1G','S1G-ZDBX-180-0','1','0.320','0.320','1','0.320','0.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='S1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='S1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='S1G-ZDBX-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='S1G-ZDBX-180-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260421-0001','2026-04-21','08:11','0.650','input','2026-04-21 08:11:42');
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 ('F226210829041','kasir','1',' MED1 HW ','TOKO','SMBK-D','D1E-ZBAH-38-T','LT MODEL COIN DOLLAR HW 8K ','OLS 5GBCA','0.500','1','100.00','587000','0','0','15000','595000','0','111000','0','706000','RHM','T0077483','D1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZBAH-38-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-04-21' AND kode_barang='D1E-ZBAH-38-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 ('F226210829041','2026-04-21','0.500','2026-04-21','08:29:05','PLG0079248','595000','595000','111000','706000','706000','kasir','2026-04-21 08:29:04','F22621082904');
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-04-21','F226210829041','2026-04-21','08:29:05','RHM','706000','111000');
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-260421-0002','D','2026-04-21','08:29:05','kasir','PENJUALAN','F226210829041','8733318000','706000','8734024000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZDBA-1-T','T0078772','MEB1 LG ','GW TRIXIE PANJANG MODEL MATA LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','749000','2026-04-21','749000','0.640','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:31:27','0.640','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZDBA-1-T','T0078772');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','B1E-ZDBA-1-T','B1E','TOKO','01-SEM','100.00','0.640','0.640','1','0.640','0.640','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZDBA-2-T','T0078773','MEB1 LG ','GW TRIXIE PANJANG MODEL MATA LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','749000','2026-04-21','749000','0.640','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:31:38','0.640','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZDBA-2-T','T0078773');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','B1E-ZDBA-2-T','B1E','TOKO','01-SEM','100.00','0.640','0.640','1','0.640','0.640','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZDBA-3-T','T0078774','MEB1 LG ','GW TRIXIE PANJANG MODEL MATA LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','667000','2026-04-21','667000','0.570','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:32:37','0.570','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZDBA-3-T','T0078774');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','B1E-ZDBA-3-T','B1E','TOKO','01-SEM','100.00','0.570','0.570','1','0.570','0.570','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZDBA-4-T','T0078775','MEB1 LG ','GW TRIXIE PANJANG MODEL MATA LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','667000','2026-04-21','667000','0.570','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:32:53','0.570','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZDBA-4-T','T0078775');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','B1E-ZDBA-4-T','B1E','TOKO','01-SEM','100.00','0.570','0.570','1','0.570','0.570','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZDBA-5-T','T0078776','MEB1 LG ','GW TRIXIE PANJANG MODEL MATA LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','573500','2026-04-21','573500','0.490','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:34:14','0.490','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZDBA-5-T','T0078776');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','B1E-ZDBA-5-T','B1E','TOKO','01-SEM','100.00','0.490','0.490','1','0.490','0.490','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZDBA-6-T','T0078777','MEB1 LG ','GW TRIXIE PANJANG MODEL MATA LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','562000','2026-04-21','562000','0.480','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:34:23','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZDBA-6-T','T0078777');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','B1E-ZDBA-6-T','B1E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZDBA-7-T','T0078778','MEB1 LG ','GW TRIXIE PANJANG MODEL MATA LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','667000','2026-04-21','667000','0.570','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:35:08','0.570','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZDBA-7-T','T0078778');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','B1E-ZDBA-7-T','B1E','TOKO','01-SEM','100.00','0.570','0.570','1','0.570','0.570','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('B1E-ZDBA-8-T','T0078779','MEB1 LG ','GW TRIXIE PANJANG MODEL MATA LG 8K ','','GR','---','ME','B1E','TOKO','01-SEM','667000','2026-04-21','667000','0.570','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:35:16','0.570','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1E','B1E-ZDBA-8-T','T0078779');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','B1E-ZDBA-8-T','B1E','TOKO','01-SEM','100.00','0.570','0.570','1','0.570','0.570','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0001','1','B1E-ZDBA-1-T','1','0.64','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZDBA-1-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-B','B1E','B1E-ZDBA-1-T' , '1','0.64','0.64', '1','0.64','0.64','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.64',berat_out_asli=berat_out_asli+'0.64',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZDBA-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0001','2','B1E-ZDBA-2-T','1','0.64','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZDBA-2-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-B','B1E','B1E-ZDBA-2-T' , '1','0.64','0.64', '1','0.64','0.64','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.64',berat_out_asli=berat_out_asli+'0.64',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZDBA-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0001','3','B1E-ZDBA-3-T','1','0.57','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZDBA-3-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-B','B1E','B1E-ZDBA-3-T' , '1','0.57','0.57', '1','0.57','0.57','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.57',berat_out_asli=berat_out_asli+'0.57',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZDBA-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0001','4','B1E-ZDBA-4-T','1','0.57','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZDBA-4-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-B','B1E','B1E-ZDBA-4-T' , '1','0.57','0.57', '1','0.57','0.57','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.57',berat_out_asli=berat_out_asli+'0.57',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZDBA-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0001','5','B1E-ZDBA-5-T','1','0.49','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZDBA-5-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-B','B1E','B1E-ZDBA-5-T' , '1','0.49','0.49', '1','0.49','0.49','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.49',berat_out_asli=berat_out_asli+'0.49',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZDBA-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0001','6','B1E-ZDBA-6-T','1','0.48','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZDBA-6-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-B','B1E','B1E-ZDBA-6-T' , '1','0.48','0.48', '1','0.48','0.48','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.48',berat_out_asli=berat_out_asli+'0.48',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZDBA-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0001','7','B1E-ZDBA-7-T','1','0.57','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZDBA-7-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-B','B1E','B1E-ZDBA-7-T' , '1','0.57','0.57', '1','0.57','0.57','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.57',berat_out_asli=berat_out_asli+'0.57',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZDBA-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0001','8','B1E-ZDBA-8-T','1','0.57','0','TOKO','01-SEM','TOKO','SMBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-B' WHERE kode_barang = 'B1E-ZDBA-8-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-B','B1E','B1E-ZDBA-8-T' , '1','0.57','0.57', '1','0.57','0.57','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.57',berat_out_asli=berat_out_asli+'0.57',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1E-ZDBA-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260421-0001','2026-04-21','2026-04-21','08:35','4.53','input','2026-04-21 08:36:03');
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 ('F226210836201','kasir','1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZDAC-15-T','GL MODEL RANTAI HOLLOW VAR KH 8K ','OL','1.550','1','100.00','1821000','0','0','15000','1821000','0','16000','0','1837000','RTA','T0078634','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAC-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='F3E-ZDAC-15-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 ('F226210836201','2026-04-21','1.550','2026-04-21','08:36:21','PLG0079249','1821000','1821000','16000','1837000','1837000','kasir','2026-04-21 08:36:20','F22621083620');
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-04-21','F226210836201','2026-04-21','08:36:21','RTA','1837000','16000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260421-0003','D','2026-04-21','08:36:21','kasir','PENJUALAN','F226210836201','8734024000','1837000','8735861000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1837000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210836201' 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 ('F226210836202','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDXI-4-T','GL LONG LING UB 8K ','OL','0.980','1','100.00','1151000','0','0','15000','1152000','0','10000','0','1162000','RTA','T0078596','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXI-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='F3E-ZDXI-4-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 ('F226210836202','2026-04-21','0.980','2026-04-21','08:36:21','PLG0079250','1152000','1152000','10000','1162000','1162000','kasir','2026-04-21 08:36:20','F22621083620');
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-04-21','F226210836202','2026-04-21','08:36:21','RTA','1162000','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-260421-0004','D','2026-04-21','08:36:21','kasir','PENJUALAN','F226210836202','8735861000','1162000','8737023000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1162000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210836202' 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 ('F226210836203','kasir',' 1',' MEF3 5K UB','TOKO','SMBK-F','F3E-ZDXF-77-T','GL RANTAI HOLLOW P3 SLEP UB 8K ','OL','1.010','1','100.00','1187000','0','0','15000','1187000','0','10000','0','1197000','RTA','T0078539','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDXF-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='F3E-ZDXF-77-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 ('F226210836203','2026-04-21','1.010','2026-04-21','08:36:21','PLG0079251','1187000','1187000','10000','1197000','1197000','kasir','2026-04-21 08:36:20','F22621083620');
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-04-21','F226210836203','2026-04-21','08:36:21','RTA','1197000','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-260421-0005','D','2026-04-21','08:36:21','kasir','PENJUALAN','F226210836203','8737023000','1197000','8738220000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1197000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210836203' 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 ('F226210836204','kasir',' 1',' MEE2 CM 10','TOKO','SMBK-E','E2E-ZDXG-15-T','CC MODEL PITA MATA CM 10 8K ','OL','0.420','1','100.00','493000','0','0','15000','498000','0','8000','0','506000','RTA','T0078555','E2E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDXG-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E2E-ZDXG-15-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 ('F226210836204','2026-04-21','0.420','2026-04-21','08:36:21','PLG0079252','498000','498000','8000','506000','506000','kasir','2026-04-21 08:36:20','F22621083620');
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-04-21','F226210836204','2026-04-21','08:36:21','RTA','506000','8000');
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-260421-0006','D','2026-04-21','08:36:21','kasir','PENJUALAN','F226210836204','8738220000','506000','8738726000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='506000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210836204' 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 ('F226210836205','kasir',' 1',' MEE1 X LG ','TOKO','SMBK-E','E2E-ZDAX-351-0','CC X MODEL MATA LG 14 8K ','OL','0.520','1','100.00','611000','0','0','15000','616000','0','8000','0','624000','RTA','00399121','E2E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDAX-351-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E2E-ZDAX-351-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 ('F226210836205','2026-04-21','0.520','2026-04-21','08:36:21','PLG0079253','616000','616000','8000','624000','624000','kasir','2026-04-21 08:36:20','F22621083620');
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-04-21','F226210836205','2026-04-21','08:36:21','RTA','624000','8000');
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-260421-0007','D','2026-04-21','08:36:21','kasir','PENJUALAN','F226210836205','8738726000','624000','8739350000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='624000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210836205' 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 ('F226210836206','kasir',' 1',' MEE1 CM 12','TOKO','SMBK-E','E1E-ZDXG-7-T','CC MODEL AUREL POLOS CM 12 8K ','OL','0.480','1','100.00','564000','0','0','15000','570000','0','8000','0','578000','RTA','T0078547','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDXG-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1E-ZDXG-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 ('F226210836206','2026-04-21','0.480','2026-04-21','08:36:21','PLG0079254','570000','570000','8000','578000','578000','kasir','2026-04-21 08:36:20','F22621083620');
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-04-21','F226210836206','2026-04-21','08:36:21','RTA','578000','8000');
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-260421-0008','D','2026-04-21','08:36:21','kasir','PENJUALAN','F226210836206','8739350000','578000','8739928000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='578000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210836206' 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 ('F226210836207','kasir',' 1',' MEE1 CM 12','TOKO','SMBK-E','E1E-ZDXG-6-T','CC MODEL AUREL POLOS CM 12 8K ','OL','0.510','1','100.00','599000','0','0','15000','605000','0','8000','0','613000','RTA','T0078546','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDXG-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1E-ZDXG-6-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 ('F226210836207','2026-04-21','0.510','2026-04-21','08:36:21','PLG0079255','605000','605000','8000','613000','613000','kasir','2026-04-21 08:36:20','F22621083620');
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-04-21','F226210836207','2026-04-21','08:36:21','RTA','613000','8000');
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-260421-0009','D','2026-04-21','08:36:21','kasir','PENJUALAN','F226210836207','8739928000','613000','8740541000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210836207' 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 ('F226210836208','kasir',' 1',' MEE1 X LG ','TOKO','SMBK-E','E2E-ZDAX-352-0','CC X MODEL MATA LG 12 8K ','OL','0.510','1','100.00','599000','0','0','15000','605000','0','8000','0','613000','RTA','00399122','E2E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDAX-352-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-04-21' AND kode_barang='E2E-ZDAX-352-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 ('F226210836208','2026-04-21','0.510','2026-04-21','08:36:21','PLG0079256','605000','605000','8000','613000','613000','kasir','2026-04-21 08:36:20','F22621083620');
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-04-21','F226210836208','2026-04-21','08:36:21','RTA','613000','8000');
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-260421-0010','D','2026-04-21','08:36:21','kasir','PENJUALAN','F226210836208','8740541000','613000','8741154000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210836208' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDBA-9-T','T0078780','MDE2X 10K CM 15 ','CC X WEDDING MATA CM 15 8K ','','GR','---','MD','E2D','TOKO','01-SEM','1759500','2026-04-21','1759500','1.530','100.00','8','0','1150000.00','1','0.04', 'input','2026-04-21 08:37:37','1.530','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDBA-9-T','T0078780');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E2D-ZDBA-9-T','E2D','TOKO','01-SEM','100.00','1.530','1.530','1','1.530','1.530','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDBA-10-T','T0078781','MDE2X 10K CM 11 ','CC X WEDDING MATA CM 11 8K ','','GR','---','MD','E2D','TOKO','01-SEM','2070000','2026-04-21','2070000','1.800','100.00','8','0','1150000.00','1','0.04', 'input','2026-04-21 08:37:47','1.800','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDBA-10-T','T0078781');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E2D-ZDBA-10-T','E2D','TOKO','01-SEM','100.00','1.800','1.800','1','1.800','1.800','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDBA-11-T','T0078782','MDE2X 10K CM 18 ','CC X WEDDING MATA CM 18 8K ','','GR','---','MD','E2D','TOKO','01-SEM','2323000','2026-04-21','2323000','2.020','100.00','8','0','1150000.00','1','0.04', 'input','2026-04-21 08:37:59','2.020','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDBA-11-T','T0078782');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E2D-ZDBA-11-T','E2D','TOKO','01-SEM','100.00','2.020','2.020','1','2.020','2.020','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 ('F226210840091','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZCAB-37-T','CC PIPA KUKU MACAN SLEP CM 14 8K ','OL','0.570','1','100.00','670000','0','0','15000','675000','0','8000','0','683000','RTA','T0078108','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAB-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1E-ZCAB-37-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 ('F226210840091','2026-04-21','0.570','2026-04-21','08:40:09','PLG0079257','675000','675000','8000','683000','683000','kasir','2026-04-21 08:40:09','F22621084009');
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-04-21','F226210840091','2026-04-21','08:40:09','RTA','683000','8000');
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-260421-0011','D','2026-04-21','08:40:09','kasir','PENJUALAN','F226210840091','8741154000','683000','8741837000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='683000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210840091' 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 ('F226210840092','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZCAB-39-T','CC PIPA KUKU MACAN SLEP CM 12 8K ','OL','0.530','1','100.00','623000','0','0','15000','628000','0','8000','0','636000','RTA','T0078110','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAB-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1E-ZCAB-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210840092','2026-04-21','0.530','2026-04-21','08:40:09','PLG0079258','628000','628000','8000','636000','636000','kasir','2026-04-21 08:40:09','F22621084009');
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-04-21','F226210840092','2026-04-21','08:40:09','RTA','636000','8000');
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-260421-0012','D','2026-04-21','08:40:09','kasir','PENJUALAN','F226210840092','8741837000','636000','8742473000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='636000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210840092' 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 ('F226210840093','kasir',' 1',' MGE1 LG 14','TOKO','SMBK-E','E1G-ZBAF-17-T','CC MODEL PASIR VAR LG 14 8K ','OL','0.330','1','100.00','401000','0','0','15000','404000','0','8000','0','412000','RTA','T0077396','E1G','0','0','-','0','1210000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZBAF-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1G-ZBAF-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 ('F226210840093','2026-04-21','0.330','2026-04-21','08:40:09','PLG0079259','404000','404000','8000','412000','412000','kasir','2026-04-21 08:40:09','F22621084009');
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-04-21','F226210840093','2026-04-21','08:40:09','RTA','412000','8000');
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-260421-0013','D','2026-04-21','08:40:09','kasir','PENJUALAN','F226210840093','8742473000','412000','8742885000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='412000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210840093' 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 ('F226210840094','kasir',' 1',' MEE2 CM 16','TOKO','SMBK-E','E2E-ZDXG-13-T','CC MODEL AUREL MATA CM 16 8K ','OL','0.670','1','100.00','787000','0','0','15000','794000','0','8000','0','802000','RTA','T0078553','E2E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDXG-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E2E-ZDXG-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210840094','2026-04-21','0.670','2026-04-21','08:40:09','PLG0079260','794000','794000','8000','802000','802000','kasir','2026-04-21 08:40:09','F22621084009');
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-04-21','F226210840094','2026-04-21','08:40:09','RTA','802000','8000');
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-260421-0014','D','2026-04-21','08:40:09','kasir','PENJUALAN','F226210840094','8742885000','802000','8743687000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='802000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210840094' 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 ('F226210840095','kasir',' 1',' MDE1 X 5K ','TOKO','SMBK-D','D1E-ZCBD-132-0','LT X MODEL APEL CAT HITAM LG 8K ','OL','0.500','1','100.00','587000','0','0','15000','593000','0','8000','0','601000','RTA','00396612','D1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCBD-132-0' 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-04-21' AND kode_barang='D1E-ZCBD-132-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210840095','2026-04-21','0.500','2026-04-21','08:40:09','PLG0079261','593000','593000','8000','601000','601000','kasir','2026-04-21 08:40:09','F22621084009');
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-04-21','F226210840095','2026-04-21','08:40:09','RTA','601000','8000');
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-260421-0015','D','2026-04-21','08:40:09','kasir','PENJUALAN','F226210840095','8743687000','601000','8744288000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='601000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210840095' 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 ('F226210840096','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZDAC-40-T','GW TRIXIE PANJANG MODEL MATA LG 8K ','OL','0.570','1','100.00','670000','0','0','15000','675000','0','8000','0','683000','RTA','T0078659','B1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDAC-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='B1E-ZDAC-40-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 ('F226210840096','2026-04-21','0.570','2026-04-21','08:40:09','PLG0079262','675000','675000','8000','683000','683000','kasir','2026-04-21 08:40:09','F22621084009');
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-04-21','F226210840096','2026-04-21','08:40:09','RTA','683000','8000');
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-260421-0016','D','2026-04-21','08:40:09','kasir','PENJUALAN','F226210840096','8744288000','683000','8744971000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='683000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210840096' 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 ('F226210840097','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZDAF-7-T','GW TRIXIE PANJANG MODEL MATA LG 8K ','OL','0.570','1','100.00','670000','0','0','15000','675000','0','8000','0','683000','RTA','T0078673','B1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDAF-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='B1E-ZDAF-7-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 ('F226210840097','2026-04-21','0.570','2026-04-21','08:40:09','PLG0079263','675000','675000','8000','683000','683000','kasir','2026-04-21 08:40:09','F22621084009');
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-04-21','F226210840097','2026-04-21','08:40:09','RTA','683000','8000');
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-260421-0017','D','2026-04-21','08:40:09','kasir','PENJUALAN','F226210840097','8744971000','683000','8745654000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='683000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210840097' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDBA-12-T','T0078783','MDE2X 10K CM 20 ','CC X WEDDING MATA CM 20 8K ','','GR','---','MD','E2D','TOKO','01-SEM','2254000','2026-04-21','2254000','1.960','100.00','8','0','1150000.00','1','0.04', 'input','2026-04-21 08:44:25','1.960','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDBA-12-T','T0078783');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E2D-ZDBA-12-T','E2D','TOKO','01-SEM','100.00','1.960','1.960','1','1.960','1.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E2D-ZDBA-13-T','T0078784','MDE2X 10K CM 14 ','CC X WEDDING MATA CM 14 8K ','','GR','---','MD','E2D','TOKO','01-SEM','2300000','2026-04-21','2300000','2.000','100.00','8','0','1150000.00','1','0.04', 'input','2026-04-21 08:45:01','2.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2D' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2D','E2D-ZDBA-13-T','T0078784');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E2D-ZDBA-13-T','E2D','TOKO','01-SEM','100.00','2.000','2.000','1','2.000','2.000','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0002','1','E2D-ZDBA-9-T','1','1.530','1.530','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E2D-ZDBA-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-21','TOKO','SMBK-E','E2D','E2D-ZDBA-9-T','100.00','1','1.530','1.530','1','1.530','1.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.530',berat_out_asli=berat_out_asli+'1.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-21' AND kode_barang='E2D-ZDBA-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0002','2','E2D-ZDBA-10-T','1','1.800','1.800','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E2D-ZDBA-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-21','TOKO','SMBK-E','E2D','E2D-ZDBA-10-T','100.00','1','1.800','1.800','1','1.800','1.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.800',berat_out_asli=berat_out_asli+'1.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-21' AND kode_barang='E2D-ZDBA-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0002','3','E2D-ZDBA-11-T','1','2.020','2.020','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E2D-ZDBA-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-21','TOKO','SMBK-E','E2D','E2D-ZDBA-11-T','100.00','1','2.020','2.020','1','2.020','2.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.020',berat_out_asli=berat_out_asli+'2.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-21' AND kode_barang='E2D-ZDBA-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0002','4','E2D-ZDBA-12-T','1','1.960','1.960','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E2D-ZDBA-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-21','TOKO','SMBK-E','E2D','E2D-ZDBA-12-T','100.00','1','1.960','1.960','1','1.960','1.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.960',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-21' AND kode_barang='E2D-ZDBA-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260421-0002','2026-04-21','2026-04-21','08:45','7.31','input','2026-04-21 08:45:49');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0003','1','E2D-ZDBA-13-T','1','2.000','2.000','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E2D-ZDBA-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-04-21','TOKO','SMBK-E','E2D','E2D-ZDBA-13-T','100.00','1','2.000','2.000','1','2.000','2.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.000',berat_out_asli=berat_out_asli+'2.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-21' AND kode_barang='E2D-ZDBA-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260421-0003','2026-04-21','2026-04-21','08:45','2','input','2026-04-21 08:47:47');
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 ('F226210852481','kasir','1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZDXI-61-0','GW TRIXIE PANJANG MODEL MATA LG 8K ','OL','0.570','1','100.00','661000','0','0','15000','675000','0','5000','0','680000','RTA','00398631','B1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDXI-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='B1E-ZDXI-61-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 ('F226210852481','2026-04-21','0.570','2026-04-21','08:52:48','PLG0079264','675000','675000','5000','680000','680000','kasir','2026-04-21 08:52:48','F22621085248');
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-04-21','F226210852481','2026-04-21','08:52:48','RTA','680000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260421-0018','D','2026-04-21','08:52:48','kasir','PENJUALAN','F226210852481','8745654000','680000','8746334000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDBA-14-T','T0078785','MEE1 YT 12 ','CC BANGKOK MODEL C YT 12 8K ','','GR','---','ME','E1E','TOKO','01-SEM','562000','2026-04-21','562000','0.480','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:55:08','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDBA-14-T','T0078785');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E1E-ZDBA-14-T','E1E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDBA-15-T','T0078786','MEE1 YT 12 ','CC BANGKOK MODEL C YT 12 8K ','','GR','---','ME','E1E','TOKO','01-SEM','562000','2026-04-21','562000','0.480','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:55:15','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDBA-15-T','T0078786');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E1E-ZDBA-15-T','E1E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDBA-16-T','T0078787','MEE1 YT 14 ','CC BANGKOK MODEL C YT 14 8K ','','GR','---','ME','E1E','TOKO','01-SEM','562000','2026-04-21','562000','0.480','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:55:24','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDBA-16-T','T0078787');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E1E-ZDBA-16-T','E1E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDBA-17-T','T0078788','MEE1 YT 14 ','CC BANGKOK MODEL C YT 14 8K ','','GR','---','ME','E1E','TOKO','01-SEM','538500','2026-04-21','538500','0.460','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:55:35','0.460','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDBA-17-T','T0078788');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E1E-ZDBA-17-T','E1E','TOKO','01-SEM','100.00','0.460','0.460','1','0.460','0.460','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDBA-18-T','T0078789','MEE1 YT 16 ','CC BANGKOK MODEL C YT 16 8K ','','GR','---','ME','E1E','TOKO','01-SEM','562000','2026-04-21','562000','0.480','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:55:45','0.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDBA-18-T','T0078789');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E1E-ZDBA-18-T','E1E','TOKO','01-SEM','100.00','0.480','0.480','1','0.480','0.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('E1E-ZDBA-19-T','T0078790','MEE1 YT 18 ','CC BANGKOK MODEL C YT 18 8K ','','GR','---','ME','E1E','TOKO','01-SEM','550000','2026-04-21','550000','0.470','100.00','8','0','1170000.00','1','0.04', 'input','2026-04-21 08:55:54','0.470','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1E','E1E-ZDBA-19-T','T0078790');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-04-21','E1E-ZDBA-19-T','E1E','TOKO','01-SEM','100.00','0.470','0.470','1','0.470','0.470','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0004','1','E1E-ZDBA-14-T','1','0.48','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDBA-14-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-E','E1E','E1E-ZDBA-14-T' , '1','0.48','0.48', '1','0.48','0.48','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.48',berat_out_asli=berat_out_asli+'0.48',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDBA-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0004','2','E1E-ZDBA-15-T','1','0.48','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDBA-15-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-E','E1E','E1E-ZDBA-15-T' , '1','0.48','0.48', '1','0.48','0.48','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.48',berat_out_asli=berat_out_asli+'0.48',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDBA-15-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0004','3','E1E-ZDBA-16-T','1','0.48','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDBA-16-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-E','E1E','E1E-ZDBA-16-T' , '1','0.48','0.48', '1','0.48','0.48','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.48',berat_out_asli=berat_out_asli+'0.48',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDBA-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0004','4','E1E-ZDBA-17-T','1','0.46','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDBA-17-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-E','E1E','E1E-ZDBA-17-T' , '1','0.46','0.46', '1','0.46','0.46','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.46',berat_out_asli=berat_out_asli+'0.46',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDBA-17-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0004','5','E1E-ZDBA-18-T','1','0.48','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDBA-18-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-E','E1E','E1E-ZDBA-18-T' , '1','0.48','0.48', '1','0.48','0.48','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.48',berat_out_asli=berat_out_asli+'0.48',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDBA-18-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260421-0004','6','E1E-ZDBA-19-T','1','0.47','0','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-E' WHERE kode_barang = 'E1E-ZDBA-19-T' AND kode_lokasi_toko = '01-SEM';
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-04-21','TOKO','SMBK-E','E1E','E1E-ZDBA-19-T' , '1','0.47','0.47', '1','0.47','0.47','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.47',berat_out_asli=berat_out_asli+'0.47',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1E-ZDBA-19-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-260421-0004','2026-04-21','2026-04-21','08:56','2.85','input','2026-04-21 08:56:15');
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 ('F226210936141','kasir','1',' MDE1 X UB ','TOKO','SMBK-E','E1D-ZBXF-196-0','CC X MODEL SLEP UB 14 8K ','OL','0.840','1','100.00','970000','0','0','15000','979000','0','5000','0','984000','TIN','00388778','E1D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBXF-196-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.840',berat_jual_asli=berat_jual_asli+'0.840',stock_jual='1',berat_akhir=berat_akhir-'0.840',berat_akhir_asli=berat_akhir_asli-'0.840',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1D-ZBXF-196-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 ('F226210936141','2026-04-21','0.840','2026-04-21','09:36:14','PLG0079265','979000','979000','5000','984000','984000','kasir','2026-04-21 09:36:14','F22621093614');
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-04-21','F226210936141','2026-04-21','09:36:14','TIN','984000','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-260421-0019','D','2026-04-21','09:36:14','kasir','PENJUALAN','F226210936141','8746334000','984000','8747318000');
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 ('F226210937521','kasir','1',' TEH1 X KH ','TOKO','TBK-H','H1TE-ZCBC-34-T','KL X SIEM COBRA KH SI 42CM 17K ','OL','1.270','1','100.00','2692000','0','0','15000','2709000','0','9000','0','2718000','TIN','T0078269','H1TE','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZCBC-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='H1TE-ZCBC-34-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210937521','2026-04-21','1.270','2026-04-21','09:37:53','PLG0079266','2709000','2709000','9000','2718000','0','kasir','2026-04-21 09:37:52','F22621093752');
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-04-21','F226210937521','2026-04-21','09:37:53','TIN','2718000','9000');
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-260421-0001','2026-04-21','2026-04-21 09:37:52','PENJUALAN : F226210937521','5343435586876','BCA','2718000','2718000','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-260421-0002','D','2026-04-21','09:37:53','BCA','PENJUALAN','F226210937521','4367244888','2718000','4369962888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('5343435586876','EKA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2718000' WHERE no_faktur_jual='F226210937521' 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 ('F226211019091','kasir','1',' TFH1 UB 46','TOKO','TBK-H','H1TF-YIXE-38-T','KL KOREA UB 46CM 17K ','','0.900','1','100.00','1926000','0','0','15000','1935000','0','0','0','1935000','RTA','T0073008','H1TF','0','0','-','0','2140000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-YIXE-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='H1TF-YIXE-38-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226211019091','2026-04-21','0.900','2026-04-21','10:19:10','PLG0079267','1935000','1935000','0','1935000','1935000','kasir','2026-04-21 10:19:09','F22621101909');
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-04-21','F226211019091','2026-04-21','10:19:10','RTA','1935000','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-260421-0020','D','2026-04-21','10:19:10','kasir','PENJUALAN','F226211019091','8747318000','1935000','8749253000');
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 ('F226211114551','kasir','1',' MED1E X YT','TOKO','SMBK-D','D1E-ZDBX-274-0','LT X MODEL MATA YT 8K ','OL','0.480','1','100.00','562000','0','0','15000','569000','0','5000','0','574000','TIN','00400211','D1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDBX-274-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='D1E-ZDBX-274-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 ('F226211114551','2026-04-21','0.480','2026-04-21','11:14:55','PLG0079268','569000','569000','5000','574000','574000','kasir','2026-04-21 11:14:55','F22621111455');
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-04-21','F226211114551','2026-04-21','11:14:55','TIN','574000','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-260421-0021','D','2026-04-21','11:14:55','kasir','PENJUALAN','F226211114551','8749253000','574000','8749827000');
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 ('F226211115371','kasir','1',' MGD1 HW ','TOKO','SMBK-D','D1G-ZCAA-65-T','LT MODEL PITA VAR HW 8K ','OL','0.350','1','100.00','425000','0','0','15000','429000','0','5000','0','434000','RTA','T0078064','D1G','0','0','-','0','1210000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZCAA-65-T' 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-04-21' AND kode_barang='D1G-ZCAA-65-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 ('F226211115371','2026-04-21','0.350','2026-04-21','11:15:38','PLG0079269','429000','429000','5000','434000','0','kasir','2026-04-21 11:15:37','F22621111537');
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-04-21','F226211115371','2026-04-21','11:15:38','RTA','434000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260421-0002','2026-04-21','2026-04-21 11:15:37','PENJUALAN : F226211115371','87676545436587','BCA','434000','434000','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-260421-0003','D','2026-04-21','11:15:38','BCA','PENJUALAN','F226211115371','4369962888','434000','4370396888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('87676545436587','EKO');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='434000' WHERE no_faktur_jual='F226211115371' 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 ('F226211118271','kasir','1',' TEB1 X HK ','TOKO','TBK-B','B1TE-ZDXD-113-T','GW X TOGE MODEL MATA VAR HK 17K ','OL','0.500','1','100.00','1060000','0','0','15000','1070000','0','7000','0','1077000','NS','T0078400','B1TE','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-ZDXD-113-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-04-21' AND kode_barang='B1TE-ZDXD-113-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226211118271','2026-04-21','0.500','2026-04-21','11:18:27','PLG0079270','1070000','1070000','7000','1077000','1077000','kasir','2026-04-21 11:18:27','F22621111827');
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-04-21','F226211118271','2026-04-21','11:18:27','NS','1077000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260421-0022','D','2026-04-21','11:18:27','kasir','PENJUALAN','F226211118271','8749827000','1077000','8750904000');
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 ('F226211119181','kasir','1',' MEA1 CM ','TOKO','SMBK-A','A1E-ZDXG-37-T','AT MODEL HATI ARESO CM 8K ','OL','0.650','1','100.00','764000','0','0','15000','770000','0','5000','0','775000','NS','T0078577','A1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDXG-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='A1E-ZDXG-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226211119181','2026-04-21','0.650','2026-04-21','11:19:18','PLG0079271','770000','770000','5000','775000','775000','kasir','2026-04-21 11:19:18','F22621111918');
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-04-21','F226211119181','2026-04-21','11:19:18','NS','775000','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-260421-0023','D','2026-04-21','11:19:18','kasir','PENJUALAN','F226211119181','8750904000','775000','8751679000');
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 ('F226211130411','kasir','1',' MDE2 CM 14','TOKO','SMBK-E','E2D-ZBAD-43-T','CC MODEL MATA SLEP VAR CM 14 8K ','','1.010','1','100.00','1167000','0','0','15000','1167000','0','0','0','1167000','RTA','T0077332','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBAD-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E2D-ZBAD-43-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 ('F226211130411','2026-04-21','1.010','2026-04-21','11:30:42','PLG0079272','1167000','1167000','0','1167000','1167000','kasir','2026-04-21 11:30:41','F22621113041');
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-04-21','F226211130411','2026-04-21','11:30:42','RTA','1167000','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-260421-0024','D','2026-04-21','11:30:42','kasir','PENJUALAN','F226211130411','8751679000','1167000','8752846000');
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 ('F226211141591','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZDXG-21-T','CC MODEL SOLITAIRE MATA CM 18 8K ','OL','1.110','1','100.00','1282000','0','0','15000','1290000','0','10000','0','1300000','NS','T0078561','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDXG-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E2D-ZDXG-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 ('F226211141591','2026-04-21','1.110','2026-04-21','11:42:00','PLG0079273','1290000','1290000','10000','1300000','1300000','kasir','2026-04-21 11:41:59','F22621114159');
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-04-21','F226211141591','2026-04-21','11:42:00','NS','1300000','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-260421-0025','D','2026-04-21','11:42:00','kasir','PENJUALAN','F226211141591','8752846000','1300000','8754146000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1300000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226211141591' 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 ('F226211141592','kasir',' 1',' MFE1 10K B','TOKO','SMBK-E','E1F-ZDAF-21-T','CC MODEL BUNGA PASIR VAR BG 18 8K ','OL','2.160','1','100.00','2581000','0','0','15000','2603000','0','11000','0','2614000','NS','T0078687','E1F','0','0','-','0','1205000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZDAF-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1F-ZDAF-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 ('F226211141592','2026-04-21','2.160','2026-04-21','11:42:00','PLG0079274','2603000','2603000','11000','2614000','2614000','kasir','2026-04-21 11:41:59','F22621114159');
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-04-21','F226211141592','2026-04-21','11:42:00','NS','2614000','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-260421-0026','D','2026-04-21','11:42:00','kasir','PENJUALAN','F226211141592','8754146000','2614000','8756760000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2614000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226211141592' 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 ('F226211141593','kasir',' 1',' MDE1 HW 17','TOKO','SMBK-E','E1D-ZDXF-65-T','CC VELG POLOS HW 17 8K ','OL','0.980','1','100.00','1132000','0','0','15000','1147000','0','5000','0','1152000','NS','T0078527','E1D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDXF-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1D-ZDXF-65-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 ('F226211141593','2026-04-21','0.980','2026-04-21','11:42:00','PLG0079275','1147000','1147000','5000','1152000','1152000','kasir','2026-04-21 11:41:59','F22621114159');
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-04-21','F226211141593','2026-04-21','11:42:00','NS','1152000','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-260421-0027','D','2026-04-21','11:42:00','kasir','PENJUALAN','F226211141593','8756760000','1152000','8757912000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1152000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226211141593' 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 ('F226211141594','kasir',' 1',' MEB1 X LG ','TOKO','SMBK-B','B1E-ZDAH-218-0','GW X TIFF MATA VAR LG 8K ','OL','0.610','1','100.00','717000','0','0','15000','726000','0','5000','0','731000','NS','00399919','B1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDAH-218-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='B1E-ZDAH-218-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 ('F226211141594','2026-04-21','0.610','2026-04-21','11:42:00','PLG0079276','726000','726000','5000','731000','731000','kasir','2026-04-21 11:41:59','F22621114159');
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-04-21','F226211141594','2026-04-21','11:42:00','NS','731000','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-260421-0028','D','2026-04-21','11:42:00','kasir','PENJUALAN','F226211141594','8757912000','731000','8758643000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='731000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226211141594' 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 ('F226211153421','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZBAX-39-T','GL FANCY MODEL PITA VAR UB 8K ','','1.060','1','100.00','1245000','0','0','15000','1246000','0','0','0','1246000','RTA','T0077154','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAX-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='F3E-ZBAX-39-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 ('F226211153421','2026-04-21','1.060','2026-04-21','11:53:43','PLG0079277','1246000','1246000','0','1246000','1246000','kasir','2026-04-21 11:53:42','F22621115342');
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-04-21','F226211153421','2026-04-21','11:53:43','RTA','1246000','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-260421-0029','D','2026-04-21','11:53:43','kasir','PENJUALAN','F226211153421','8758643000','1246000','8759889000');
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 ('F226211155301','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZCCX-475-0','CC X MODEL MATA CM 14 8K ','','1.500','1','100.00','1732000','0','0','15000','1733000','0','0','0','1733000','TJ','00397129','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-475-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E2D-ZCCX-475-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 ('F226211155301','2026-04-21','1.500','2026-04-21','11:55:30','PLG0079278','1733000','1733000','0','1733000','1733000','kasir','2026-04-21 11:55:30','F22621115530');
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-04-21','F226211155301','2026-04-21','11:55:30','TJ','1733000','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-260421-0030','D','2026-04-21','11:55:30','kasir','PENJUALAN','F226211155301','8759889000','1733000','8761622000');
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 ('F226211231241','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDBX-2-T','GL MODEL PREMIER BOLA VAR UB 8K ','OL','1.740','1','100.00','2044000','0','0','15000','2053000','0','9000','0','2062000','RTA','T0078737','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBX-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='F3E-ZDBX-2-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 ('F226211231241','2026-04-21','1.740','2026-04-21','12:31:24','PLG0079279','2053000','2053000','9000','2062000','2062000','kasir','2026-04-21 12:31:24','F22621123124');
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-04-21','F226211231241','2026-04-21','12:31:24','RTA','2062000','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-260421-0031','D','2026-04-21','12:31:24','kasir','PENJUALAN','F226211231241','8761622000','2062000','8763684000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211231241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211231241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211231241';
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 ('F226211254081','kasir','1',' MEE1 YT 12','TOKO','SMBK-E','E1E-ZDBA-14-T','CC BANGKOK MODEL C YT 12 8K ','ol','0.480','1','100.00','562000','0','0','15000','566000','0','5000','0','571000','NS','T0078785','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBA-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1E-ZDBA-14-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 ('F226211254081','2026-04-21','0.480','2026-04-21','12:54:09','PLG0079280','566000','566000','5000','571000','571000','kasir','2026-04-21 12:54:08','F22621125408');
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-04-21','F226211254081','2026-04-21','12:54:09','NS','571000','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-260421-0032','D','2026-04-21','12:54:09','kasir','PENJUALAN','F226211254081','8763684000','571000','8764255000');
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 ('F226210106091','kasir','1',' MDA1 CM ','TOKO','SMBK-A','A1D-ZBAD-86-T','AT KLIP MODEL DAUN VAR CM 8K ','ol','1.030','1','100.00','1190000','0','0','15000','1190000','0','10000','0','1200000','TIN','T0077375','A1D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBAD-86-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-04-21' AND kode_barang='A1D-ZBAD-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210106091','2026-04-21','1.030','2026-04-21','13:06:09','PLG0079281','1190000','1190000','10000','1200000','1200000','kasir','2026-04-21 13:06:09','F22621010609');
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-04-21','F226210106091','2026-04-21','13:06:09','TIN','1200000','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-260421-0033','D','2026-04-21','13:06:09','kasir','PENJUALAN','F226210106091','8764255000','1200000','8765455000');
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 ('F226210122531','kasir','1',' MGD1G X UB','TOKO','SMBK-D','D1G-ZDBX-275-0','LT X MODEL SLEP UB 8K ','ol','0.320','1','100.00','387000','0','0','15000','392000','0','5000','0','397000','RTA','00400212','D1G','0','0','-','0','1210000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZDBX-275-0' 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-04-21' AND kode_barang='D1G-ZDBX-275-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 ('F226210122531','2026-04-21','0.320','2026-04-21','13:22:54','PLG0079282','392000','392000','5000','397000','0','kasir','2026-04-21 13:22:53','F22621012253');
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-04-21','F226210122531','2026-04-21','13:22:54','RTA','397000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260421-0003','2026-04-21','2026-04-21 13:22:53','PENJUALAN : F226210122531','8787676554','BCA','397000','397000','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-260421-0004','D','2026-04-21','13:22:54','BCA','PENJUALAN','F226210122531','4370396888','397000','4370793888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('8787676554','MEI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='397000' WHERE no_faktur_jual='F226210122531' 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 ('F226210136181','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZDAG-10-T','GL KOREA UB 8K ','','0.440','1','100.00','517000','0','0','15000','515000','0','0','0','515000','RHM','T0078722','F3E','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAG-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.440',berat_jual_asli=berat_jual_asli+'0.440',stock_jual='1',berat_akhir=berat_akhir-'0.440',berat_akhir_asli=berat_akhir_asli-'0.440',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='F3E-ZDAG-10-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 ('F226210136181','2026-04-21','0.440','2026-04-21','13:36:19','PLG0079283','515000','515000','0','515000','515000','kasir','2026-04-21 13:36:18','F22621013618');
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-04-21','F226210136181','2026-04-21','13:36:19','RHM','515000','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-260421-0034','D','2026-04-21','13:36:19','kasir','PENJUALAN','F226210136181','8765455000','515000','8765970000');
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 ('F226210146091','kasir','1',' TEE2 CM LG','TOKO','TBK-E','E2TE-WIAD-23-T','CC ANAK BONEKA CAT MATA LG ','','0.980','1','100.00','2078000','0','0','15000','2078000','0','0','0','2078000','TIN','T0048720','E2TE','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WIAD-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E2TE-WIAD-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210146091','2026-04-21','0.980','2026-04-21','13:46:09','PLG0079284','2078000','2078000','0','2078000','2078000','kasir','2026-04-21 13:46:09','F22621014609');
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-04-21','F226210146091','2026-04-21','13:46:09','TIN','2078000','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-260421-0035','D','2026-04-21','13:46:09','kasir','PENJUALAN','F226210146091','8765970000','2078000','8768048000');
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 ('F226210153541','kasir','1',' MDE2 X UB ','TOKO','SMBK-E','E2D-ZAAF-249-0','CC X MODEL MATA UB 14 8K ','OL','0.890','1','100.00','1028000','0','0','15000','1032000','0','5000','0','1037000','TIN','00385700','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAF-249-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.890',berat_jual_asli=berat_jual_asli+'0.890',stock_jual='1',berat_akhir=berat_akhir-'0.890',berat_akhir_asli=berat_akhir_asli-'0.890',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E2D-ZAAF-249-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 ('F226210153541','2026-04-21','0.890','2026-04-21','13:53:55','PLG0079285','1032000','1032000','5000','1037000','1037000','kasir','2026-04-21 13:53:54','F22621015354');
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-04-21','F226210153541','2026-04-21','13:53:55','TIN','1037000','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-260421-0036','D','2026-04-21','13:53:55','kasir','PENJUALAN','F226210153541','8768048000','1037000','8769085000');
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 ('F226210159581','kasir','1',' MEH1 UB 40','TOKO','SMBK-H','H1E-ZCBX-24-T','KL MILANO UB 40CM 8K ','','2.120','1','100.00','2491000','0','0','15000','2480000','0','0','0','2480000','RTA','T0078234','H1E','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCBX-24-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-04-21' AND kode_barang='H1E-ZCBX-24-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 ('F226210159581','2026-04-21','2.120','2026-04-21','13:59:58','PLG0079286','2480000','2480000','0','2480000','2480000','kasir','2026-04-21 13:59:58','F22621015958');
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-04-21','F226210159581','2026-04-21','13:59:58','RTA','2480000','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-260421-0037','D','2026-04-21','13:59:58','kasir','PENJUALAN','F226210159581','8769085000','2480000','8771565000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210159581' 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 ('F226210159582','kasir',' 1',' MED2E X LG','TOKO','SMBK-D','D2E-YIBD-131-0','LT X MODEL MATA LG 8K ','','1.130','1','100.00','1328000','0','0','15000','1322000','0','10000','0','1332000','RTA','00370552','D2E','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YIBD-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='D2E-YIBD-131-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 ('F226210159582','2026-04-21','1.130','2026-04-21','13:59:58','PLG0079287','1322000','1322000','10000','1332000','1332000','kasir','2026-04-21 13:59:58','F22621015958');
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-04-21','F226210159582','2026-04-21','13:59:58','RTA','1332000','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-260421-0038','D','2026-04-21','13:59:58','kasir','PENJUALAN','F226210159582','8771565000','1332000','8772897000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1332000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210159582' 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 ('F226210159583','kasir',' 1',' MEE1 5K HW','TOKO','SMBK-E','E1E-ZDXG-48-T','CC MODEL SLEP VAR HW 15 8K ','','0.720','1','100.00','846000','0','0','15000','846000','0','5000','0','851000','RTA','T0078588','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDXG-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1E-ZDXG-48-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 ('F226210159583','2026-04-21','0.720','2026-04-21','13:59:58','PLG0079288','846000','846000','5000','851000','851000','kasir','2026-04-21 13:59:58','F22621015958');
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-04-21','F226210159583','2026-04-21','13:59:58','RTA','851000','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-260421-0039','D','2026-04-21','13:59:58','kasir','PENJUALAN','F226210159583','8772897000','851000','8773748000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='851000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210159583' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210159581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210159581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210159581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210159582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210159582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210159582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210159583' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210159583' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210159583';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210106091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210106091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210106091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210122531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210122531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210122531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210136181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210136181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210136181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210146091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210146091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210146091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210153541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210153541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210153541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210829041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210829041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210829041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210836201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210836202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836203' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836203' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210836203';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836204' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836204' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210836204';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836205' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836205' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210836205';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836206' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836206' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210836206';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836207' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836207' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210836207';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836208' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210836208' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210836208';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210840091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840092' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840092' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210840092';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840093' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840093' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210840093';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840094' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840094' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210840094';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840095' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840095' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210840095';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840096' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840096' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210840096';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840097' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210840097' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210840097';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210852481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210852481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210852481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210936141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210936141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210936141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210937521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210937521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210937521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211019091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211019091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211019091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211114551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211114551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211114551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211115371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211115371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211115371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211118271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211118271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211118271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211119181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211119181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211119181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211130411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211130411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211130411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211141591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211141591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211141591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211141592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211141592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211141592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211141593' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211141593' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211141593';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211141594' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211141594' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211141594';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211153421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211153421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211153421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211155301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211155301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211155301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226211254081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226211254081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226211254081';
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 ('F226210233151','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZDBX-6-T','AT JERSY SLEP LG 8K ','','1.000','1','100.00','1155000','0','0','15000','1150000','0','0','0','1150000','NS','T0078741','A1D','0','0','-','1','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDBX-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='A1D-ZDBX-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210233151','2026-04-21','1.000','2026-04-21','14:33:15','PLG0079289','1150000','1150000','0','1150000','1150000','kasir','2026-04-21 14:33:15','F22621023315');
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-04-21','F226210233151','2026-04-21','14:33:15','NS','1150000','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-260421-0040','D','2026-04-21','14:33:15','kasir','PENJUALAN','F226210233151','8773748000','1150000','8774898000');
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-00005282','X-00005282','CC COR M 17K','GR','---','E2TE','BELI','BELI001','4042000','2026-04-21','2.350','1','kasir','2026-04-21 14:40:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00005282','X-00005282');
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-260421-0001','F223260217041','RTA','1','BELI','BELI001','E2TE', 'X-00005282', 'CC COR M 17K','2.450','2.350','100.00','1950000','4042000','1720000','2120000','1','4042000','4042000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.350',berat_beli_asli=berat_beli_asli+'2.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.350',berat_akhir_asli=berat_akhir_asli+'2.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-260421-0001','2026-04-21','2026-04-21','14:40:42','RTA','---','2.350','4042000','4042000','4042000','4042000','4042000','kasir','2026-04-21 14:40:43','FB-260421-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260421-0001','LINDA','MRAYAN 11 NGRAYUN','','','','kasir','2026-04-21 14:40:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-21' 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-260421-0041','K','2026-04-21','14:40:42','kasir','PEMBELIAN UMUM','FB-260421-0001','8774898000','4042000','8770856000');
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-00005283','X-00005283','GL TRIXIE BUNGA CLOVER SLEP LT 8K','GR','---','F3E','BELI','BELI001','1579000','2026-04-21','1.500','1','kasir','2026-04-21 14:41:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005283','X-00005283');
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-260421-0002','F226031139481','RTA','1','BELI','BELI001','F3E', 'X-00005283', 'GL TRIXIE BUNGA CLOVER SLEP LT 8K','1.500','1.500','100.00','1755000','1579000','1052667','1170000','1','1579000','1579000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-260421-0002','2026-04-21','2026-04-21','14:41:06','RTA','---','1.500','1579000','1579000','1579000','1579000','1579000','kasir','2026-04-21 14:41:06','FB-260421-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260421-0002','KRISIDA','KEPUHRUBUH SIMAN','','','087860913030','kasir','2026-04-21 14:41:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-21' 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-260421-0042','K','2026-04-21','14:41:06','kasir','PEMBELIAN UMUM','FB-260421-0002','8770856000','1579000','8769277000');
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-00005284','X-00005284','AT JERSY SLEP LG 8K','GR','---','A1D','BELI','BELI001','924000','2026-04-21','1.000','1','kasir','2026-04-21 14:41:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005284','X-00005284');
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-260421-0003','F226150915491','RHM','1','BELI','BELI001','A1D', 'X-00005284', 'AT JERSY SLEP LG 8K','1.000','1.000','100.00','1180000','924000','924000','1150000','1','924000','924000','RUSAK');
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-04-21' 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-260421-0003','2026-04-21','2026-04-21','14:41:28','RHM','---','1.000','924000','924000','924000','924000','924000','kasir','2026-04-21 14:41:28','FB-260421-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260421-0003','EVA','CARAT SUMOROTO','','','081331585317','kasir','2026-04-21 14:41:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-21' 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-260421-0043','K','2026-04-21','14:41:28','kasir','PEMBELIAN UMUM','FB-260421-0003','8769277000','924000','8768353000');
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 ('F226210242161','kasir','1',' MEE1 YT 18','TOKO','SMBK-E','E1E-ZDBA-19-T','CC BANGKOK MODEL C YT 18 8K ','','0.470','1','100.00','550000','0','0','15000','550000','0','0','0','550000','TIN','T0078790','E1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBA-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='E1E-ZDBA-19-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 ('F226210242161','2026-04-21','0.470','2026-04-21','14:42:17','PLG0079290','550000','550000','0','550000','550000','kasir','2026-04-21 14:42:16','F22621024216');
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-04-21','F226210242161','2026-04-21','14:42:17','TIN','550000','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-260421-0044','D','2026-04-21','14:42:17','kasir','PENJUALAN','F226210242161','8768353000','550000','8768903000');
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-00005285','X-00005285','KL NORY UB 46CM 8K','GR','---','H1E','BELI','BELI001','926000','2026-04-21','0.990','1','kasir','2026-04-21 14:42:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005285','X-00005285');
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-260421-0004','F226140130023','NS','1','BELI','BELI001','H1E', 'X-00005285', 'KL NORY UB 46CM 8K','1.000','0.990','100.00','1195000','926000','935354','1170000','1','926000','926000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.990',berat_beli_asli=berat_beli_asli+'0.990',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.990',berat_akhir_asli=berat_akhir_asli+'0.990',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-260421-0004','2026-04-21','2026-04-21','14:42:55','NS','---','0.990','926000','926000','926000','926000','926000','kasir','2026-04-21 14:42:55','FB-260421-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260421-0004','BITA','TRISONO BBD','','','082197547847','kasir','2026-04-21 14:42:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-21' 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-260421-0045','K','2026-04-21','14:42:55','kasir','PEMBELIAN UMUM','FB-260421-0004','8768903000','926000','8767977000');
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-00005286','X-00005286','KL SANTA KH 42CM 8K','GR','---','H1E','BELI','BELI001','2135000','2026-04-21','2.020','1','kasir','2026-04-21 14:44:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00005286','X-00005286');
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-260421-0005','F226140939471','RTA','1','BELI','BELI001','H1E', 'X-00005286', 'KL SANTA KH 42CM 8K','2.020','2.020','100.00','2415000','2135000','1056931','1170000','1','2135000','2135000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-260421-0005','2026-04-21','2026-04-21','14:44:04','RTA','---','2.020','2135000','2135000','2135000','2135000','2135000','kasir','2026-04-21 14:44:04','FB-260421-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260421-0005','RIKA','JL ONTOSENO 1 43C','','','085232247216','kasir','2026-04-21 14:44:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-21' 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-260421-0046','K','2026-04-21','14:44:04','kasir','PEMBELIAN UMUM','FB-260421-0005','8767977000','2135000','8765842000');
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-00005287','X-00005287','LT SLOBOK BOLA ARESO LG 8K','GR','---','D1G','BELI','BELI001','342000','2026-04-21','0.320','1','kasir','2026-04-21 14:44:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00005287','X-00005287');
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-260421-0006','F226140939472','RTA','2','BELI','BELI001','D1G', 'X-00005287', 'LT SLOBOK BOLA ARESO LG 8K','0.320','0.320','100.00','395000','342000','1068750','1210000','1','342000','342000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.320',berat_beli_asli=berat_beli_asli+'0.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.320',berat_akhir_asli=berat_akhir_asli+'0.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-21' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' 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-260421-0006','2026-04-21','2026-04-21','14:44:04','RTA','---','0.320','342000','342000','342000','342000','342000','kasir','2026-04-21 14:44:04','FB-260421-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260421-0006','RIKA','JL ONTOSENO 1 43C','','','085232247216','kasir','2026-04-21 14:44:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-21' 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-260421-0047','K','2026-04-21','14:44:04','kasir','PEMBELIAN UMUM','FB-260421-0006','8765842000','342000','8765500000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210233151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210233151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210233151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210242161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210242161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210242161';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260421-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260421-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260421-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260421-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260421-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260421-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260421-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260421-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260421-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260421-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260421-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260421-0006';
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 ('F226210312341','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZBAC-23-T','GL CASTELA SLEP VAR HW 8K ','','1.580','1','100.00','1856000','0','0','15000','1850000','0','0','0','1850000','RTA','T0077232','F3E','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAC-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='F3E-ZBAC-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210312341','2026-04-21','1.580','2026-04-21','15:12:34','PLG0079291','1850000','1850000','0','1850000','1850000','kasir','2026-04-21 15:12:34','F22621031234');
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-04-21','F226210312341','2026-04-21','15:12:34','RTA','1850000','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-260421-0048','D','2026-04-21','15:12:34','kasir','PENJUALAN','F226210312341','8765500000','1850000','8767350000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1850000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210312341' 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 ('F226210312342','kasir',' 1',' MEA1E CM ','TOKO','SMBK-A','A1E-YLBX-57-T','AT MODEL ARESO VAR CM 8K ','','0.480','1','100.00','564000','0','0','15000','562000','0','0','0','562000','RTA','T0076042','A1E','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLBX-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='A1E-YLBX-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210312342','2026-04-21','0.480','2026-04-21','15:12:34','PLG0079292','562000','562000','0','562000','562000','kasir','2026-04-21 15:12:34','F22621031234');
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-04-21','F226210312342','2026-04-21','15:12:34','RTA','562000','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-260421-0049','D','2026-04-21','15:12:34','kasir','PENJUALAN','F226210312342','8767350000','562000','8767912000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='562000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226210312342' 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 ('F226210315441','kasir','1',' MEH1 X LT ','TOKO','SMBK-H','H1E-YKBD-121-0','KL X NORY LT 34 8K ','','2.010','1','100.00','2362000','0','0','15000','2352000','0','0','0','2352000','TIN','00378530','H1E','0','0','-','1','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKBD-121-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-04-21' AND kode_barang='H1E-YKBD-121-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 ('F226210315441','2026-04-21','2.010','2026-04-21','15:15:44','PLG0079293','2352000','2352000','0','2352000','2352000','kasir','2026-04-21 15:15:44','F22621031544');
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-04-21','F226210315441','2026-04-21','15:15:44','TIN','2352000','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-260421-0050','D','2026-04-21','15:15:44','kasir','PENJUALAN','F226210315441','8767912000','2352000','8770264000');
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 ('F226210333231','kasir','1',' TEA1 X HK ','TOKO','TBK-A','A1TE-YLBF-3-T','AT X TINDIK BABY MRICAN HK 17K ','','0.500','1','100.00','1060000','0','0','15000','1060000','0','0','0','1060000','RTA','T0076173','A1TE','0','0','-','0','2120000');
UPDATE tm_barang SET tgl_last_jual='2026-04-21', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-YLBF-3-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-04-21' AND kode_barang='A1TE-YLBF-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226210333231','2026-04-21','0.500','2026-04-21','15:33:24','PLG0079294','1060000','1060000','0','1060000','1060000','kasir','2026-04-21 15:33:23','F22621033323');
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-04-21','F226210333231','2026-04-21','15:33:24','RTA','1060000','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-260421-0051','D','2026-04-21','15:33:24','kasir','PENJUALAN','F226210333231','8770264000','1060000','8771324000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210312341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210312341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210312341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210312342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210312342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210312342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210315441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210315441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210315441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226210333231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226210333231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226210333231';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-21';
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-04-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-21' 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-260422-0001','D','2026-04-22','16:02:19','SYSTEM','SALDO AWAL','SALDO AWAL','0','8771324000','8771324000');
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-260422-0001','D','2026-04-22','16:02:19','BCA','SALDO AWAL','SALDO AWAL','0','4370793888','4370793888');
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-260422-0001','D','2026-04-22','16:02:19','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260422-0001','D','2026-04-22','16:02:19','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-260422-0001','D','2026-04-22','16:02:19','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-260422-0001','D','2026-04-22','16:02:19','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-04-22';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260422-0001','1','E1D-ZCXG-337-0','1','1.140','1.140','TOKO','SBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCXG-337-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCXG-337-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-04-22 17:33:05' WHERE kode_barang='E1D-ZCXG-337-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCXG-337-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-04-22 17:33:05','TOKO','SMBK-E','E1D','E1D-ZCXG-337-0','1','1.140','1.140','1','1.140','1.140','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-ZCXG-337-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCXG-337-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260422-0001','2026-04-22','17:32','1.140','input','2026-04-21 17:33:05');