INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-14';
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-03-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-14' 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-260315-0001','D','2026-03-15','08:04:23','SYSTEM','SALDO AWAL','SALDO AWAL','0','7154987000','7154987000');
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-260315-0001','D','2026-03-15','08:04:23','BCA','SALDO AWAL','SALDO AWAL','0','4306160888','4306160888');
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-260315-0001','D','2026-03-15','08:04:23','','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-260315-0001','D','2026-03-15','08:04:23','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-260315-0001','D','2026-03-15','08:04:23','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-260315-0001','D','2026-03-15','08:04:23','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-03-15';
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-20260315-0001','1','B1D-ZCAD-35-0','1','1.050','1.050','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZCAD-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZCAD-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-03-15 08:08:04' WHERE kode_barang='B1D-ZCAD-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZCAD-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:08:04','TOKO','SMBK-B','B1D','B1D-ZCAD-35-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1D-ZCAD-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZCAD-35-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260315-0001','2026-03-15','08:07','1.050','input','2026-03-15 08:08:03');
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-20260315-0001','1','D2E-ZCAD-49-0','1','0.480','0.480','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZCAD-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZCAD-49-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-03-15 08:08:24' WHERE kode_barang='D2E-ZCAD-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZCAD-49-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-03-15 08:08:24','TOKO','SMBK-D','D2E','D2E-ZCAD-49-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZCAD-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZCAD-49-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-20260315-0001','1','D2E-ZCAD-54-0','1','0.520','0.520','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZCAD-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZCAD-54-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-03-15 08:08:24' WHERE kode_barang='D2E-ZCAD-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZCAD-54-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-03-15 08:08:24','TOKO','SMBK-D','D2E','D2E-ZCAD-54-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZCAD-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZCAD-54-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260315-0001','2026-03-15','08:08','1.000','input','2026-03-15 08:08:24');
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-20260315-0001','1','E1F-ZAAI-202-0','1','1.460','1.460','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZAAI-202-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZAAI-202-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-15 08:08:43' WHERE kode_barang='E1F-ZAAI-202-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZAAI-202-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-03-15 08:08:43','TOKO','SMBK-E','E1F','E1F-ZAAI-202-0','1','1.460','1.460','1','1.460','1.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZAAI-202-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZAAI-202-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-20260315-0001','1','E2E-ZCAD-229-0','1','0.470','0.470','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZCAD-229-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZCAD-229-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-15 08:08:43' WHERE kode_barang='E2E-ZCAD-229-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZCAD-229-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:08:43','TOKO','SMBK-E','E2E','E2E-ZCAD-229-0','1','0.470','0.470','1','0.470','0.470','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-ZCAD-229-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZCAD-229-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','E2E-ZCAD-230-0','1','0.610','0.610','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZCAD-230-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZCAD-230-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-15 08:08:43' WHERE kode_barang='E2E-ZCAD-230-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZCAD-230-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:08:43','TOKO','SMBK-E','E2E','E2E-ZCAD-230-0','1','0.610','0.610','1','0.610','0.610','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-ZCAD-230-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZCAD-230-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','E2E-ZCAD-231-0','1','0.670','0.670','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZCAD-231-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZCAD-231-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-15 08:08:43' WHERE kode_barang='E2E-ZCAD-231-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZCAD-231-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:08:43','TOKO','SMBK-E','E2E','E2E-ZCAD-231-0','1','0.670','0.670','1','0.670','0.670','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-ZCAD-231-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZCAD-231-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','E2D-ZCAD-232-0','1','1.010','1.010','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZCAD-232-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZCAD-232-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-15 08:08:43' WHERE kode_barang='E2D-ZCAD-232-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZCAD-232-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:08:43','TOKO','SMBK-E','E2D','E2D-ZCAD-232-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZCAD-232-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZCAD-232-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','E2D-ZCAD-233-0','1','1.050','1.050','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZCAD-233-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZCAD-233-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-15 08:08:43' WHERE kode_barang='E2D-ZCAD-233-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZCAD-233-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:08:43','TOKO','SMBK-E','E2D','E2D-ZCAD-233-0','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZCAD-233-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZCAD-233-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','E2D-ZCAD-234-0','1','0.880','0.880','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZCAD-234-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZCAD-234-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-15 08:08:43' WHERE kode_barang='E2D-ZCAD-234-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZCAD-234-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:08:43','TOKO','SMBK-E','E2D','E2D-ZCAD-234-0','1','0.880','0.880','1','0.880','0.880','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-ZCAD-234-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZCAD-234-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','E1D-ZCAD-235-0','1','1.050','1.050','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCAD-235-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCAD-235-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-15 08:08:43' WHERE kode_barang='E1D-ZCAD-235-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCAD-235-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:08:43','TOKO','SMBK-E','E1D','E1D-ZCAD-235-0','1','1.050','1.050','1','1.050','1.050','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-ZCAD-235-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCAD-235-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','E1D-ZCAD-236-0','1','0.620','0.620','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZCAD-236-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZCAD-236-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-03-15 08:08:43' WHERE kode_barang='E1D-ZCAD-236-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZCAD-236-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:08:43','TOKO','SMBK-E','E1D','E1D-ZCAD-236-0','1','0.620','0.620','1','0.620','0.620','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-ZCAD-236-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZCAD-236-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260315-0001','2026-03-15','08:08','7.820','input','2026-03-15 08:08:43');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','F4I-ZCAD-126-0','1','0.900','0.900','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F4I-ZCAD-126-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F4I-ZCAD-126-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-03-15 08:09:09' WHERE kode_barang='F4I-ZCAD-126-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F4I-ZCAD-126-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:09:09','TOKO','SMBK-F','F4I','F4I-ZCAD-126-0','1','0.900','0.900','1','0.900','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='F4I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F4I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F4I-ZCAD-126-0';
DELETE FROM tm_barang_export WHERE kode_barang='F4I-ZCAD-126-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','F4J-ZCAD-127-0','1','0.620','0.620','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F4J-ZCAD-127-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F4J-ZCAD-127-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-03-15 08:09:09' WHERE kode_barang='F4J-ZCAD-127-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F4J-ZCAD-127-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:09:09','TOKO','SMBK-F','F4J','F4J-ZCAD-127-0','1','0.620','0.620','1','0.620','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='F4J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F4J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F4J-ZCAD-127-0';
DELETE FROM tm_barang_export WHERE kode_barang='F4J-ZCAD-127-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260315-0001','2026-03-15','08:08','1.520','input','2026-03-15 08:09:09');
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-20260315-0001','1','H1E-ZCAD-93-0','1','1.310','1.310','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZCAD-93-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZCAD-93-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-03-15 08:09:39' WHERE kode_barang='H1E-ZCAD-93-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZCAD-93-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:09:39','TOKO','SMBK-H','H1E','H1E-ZCAD-93-0','1','1.310','1.310','1','1.310','1.310','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-ZCAD-93-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZCAD-93-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260315-0001','1','H1E-ZCAD-94-0','1','1.920','1.920','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZCAD-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZCAD-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-03-15 08:09:39' WHERE kode_barang='H1E-ZCAD-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZCAD-94-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-03-15 08:09:39','TOKO','SMBK-H','H1E','H1E-ZCAD-94-0','1','1.920','1.920','1','1.920','1.920','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-ZCAD-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZCAD-94-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260315-0001','2026-03-15','08:09','3.230','input','2026-03-15 08:09:38');
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 ('D1F-ZCAE-1-T','T0078155','MFD1 5K BG ','LT SLOBOK BULAN BINTANG PASIR BG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','648000','2026-03-15','648000','0.510','100.00','8','0','1270000.00','1','0.04', 'input','2026-03-15 08:22:17','0.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZCAE-1-T','T0078155');
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-03-15','D1F-ZCAE-1-T','D1F','TOKO','01-SEM','100.00','0.510','0.510','1','0.510','0.510','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 ('D1F-ZCAE-2-T','T0078156','MFD1 5K BG ','LT SLOBOK BULAN BINTANG PASIR BG 8K ','','GR','---','MF','D1F','TOKO','01-SEM','648000','2026-03-15','648000','0.510','100.00','8','0','1270000.00','1','0.04', 'input','2026-03-15 08:22:25','0.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1F','D1F-ZCAE-2-T','T0078156');
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-03-15','D1F-ZCAE-2-T','D1F','TOKO','01-SEM','100.00','0.510','0.510','1','0.510','0.510','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 ('D1E-ZCAE-3-T','T0078157','MED1 5K LG ','LT MODEL APEL CAT VAR LG 8K ','','GR','---','ME','D1E','TOKO','01-SEM','597500','2026-03-15','597500','0.500','100.00','8','0','1195000.00','1','0.04', 'input','2026-03-15 08:22:59','0.500','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCAE-3-T','T0078157');
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-03-15','D1E-ZCAE-3-T','D1E','TOKO','01-SEM','100.00','0.500','0.500','1','0.500','0.500','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 ('D1E-ZCAE-4-T','T0078158','MED1 5K LG ','LT MODEL APEL CAT VAR LG 8K ','','GR','---','ME','D1E','TOKO','01-SEM','633500','2026-03-15','633500','0.530','100.00','8','0','1195000.00','1','0.04', 'input','2026-03-15 08:23:12','0.530','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCAE-4-T','T0078158');
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-03-15','D1E-ZCAE-4-T','D1E','TOKO','01-SEM','100.00','0.530','0.530','1','0.530','0.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 ('D1E-ZCAE-5-T','T0078159','MED1 5K LG ','LT MODEL APEL CAT VAR LG 8K ','','GR','---','ME','D1E','TOKO','01-SEM','609500','2026-03-15','609500','0.510','100.00','8','0','1195000.00','1','0.04', 'input','2026-03-15 08:25:33','0.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1E','D1E-ZCAE-5-T','T0078159');
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-03-15','D1E-ZCAE-5-T','D1E','TOKO','01-SEM','100.00','0.510','0.510','1','0.510','0.510','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-260315-0001','1','D1E-ZCAE-3-T','1','0.5','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1E-ZCAE-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-03-15','TOKO','SMBK-D','D1E','D1E-ZCAE-3-T' , '1','0.5','0.5', '1','0.5','0.5','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.5',berat_out_asli=berat_out_asli+'0.5',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1E-ZCAE-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-260315-0001','2','D1E-ZCAE-4-T','1','0.53','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1E-ZCAE-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-03-15','TOKO','SMBK-D','D1E','D1E-ZCAE-4-T' , '1','0.53','0.53', '1','0.53','0.53','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.53',berat_out_asli=berat_out_asli+'0.53',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1E-ZCAE-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-260315-0001','3','D1E-ZCAE-5-T','1','0.51','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1E-ZCAE-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-03-15','TOKO','SMBK-D','D1E','D1E-ZCAE-5-T' , '1','0.51','0.51', '1','0.51','0.51','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.51',berat_out_asli=berat_out_asli+'0.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1E-ZCAE-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-260315-0001','4','D1F-ZCAE-1-T','1','0.51','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZCAE-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-03-15','TOKO','SMBK-D','D1F','D1F-ZCAE-1-T' , '1','0.51','0.51', '1','0.51','0.51','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.51',berat_out_asli=berat_out_asli+'0.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZCAE-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-260315-0001','5','D1F-ZCAE-2-T','1','0.51','0','TOKO','01-SEM','TOKO','SMBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-D' WHERE kode_barang = 'D1F-ZCAE-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-03-15','TOKO','SMBK-D','D1F','D1F-ZCAE-2-T' , '1','0.51','0.51', '1','0.51','0.51','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.51',berat_out_asli=berat_out_asli+'0.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1F-ZCAE-2-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-260315-0001','2026-03-15','2026-03-15','08:26','2.56','input','2026-03-15 08:26:12');
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 ('F226151016121','kasir','1',' MEF3 18K U','TOKO','SMBK-F','F3E-ZCXB-6-T','GL MODEL MEDAN PASIR VAR UB 8K ','OL','3.710','1','100.00','4508000','0','0','15000','4452000','0','19000','0','4471000','RTA','T0077640','F3E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXB-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.710',berat_jual_asli=berat_jual_asli+'3.710',stock_jual='1',berat_akhir=berat_akhir-'3.710',berat_akhir_asli=berat_akhir_asli-'3.710',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='F3E-ZCXB-6-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 ('F226151016121','2026-03-15','3.710','2026-03-15','10:16:13','PLG0078167','4452000','4452000','19000','4471000','4471000','kasir','2026-03-15 10:16:12','F22615101612');
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-03-15','F226151016121','2026-03-15','10:16:13','RTA','4471000','19000');
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-260315-0002','D','2026-03-15','10:16:13','kasir','PENJUALAN','F226151016121','7154987000','4471000','7159458000');
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 ('F226151030431','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZCXG-3-T','AT TINDIK BABY LG 8K ','','0.480','1','100.00','583000','0','0','15000','581000','0','5000','0','586000','RTA','T0077874','A1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCXG-3-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-03-15' AND kode_barang='A1E-ZCXG-3-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 ('F226151030431','2026-03-15','0.480','2026-03-15','10:30:43','PLG0078168','581000','581000','5000','586000','586000','kasir','2026-03-15 10:30:43','F22615103043');
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-03-15','F226151030431','2026-03-15','10:30:43','RTA','586000','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-260315-0003','D','2026-03-15','10:30:43','kasir','PENJUALAN','F226151030431','7159458000','586000','7160044000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='586000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151030431' 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 ('F226151030432','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZCAC-2-T','GL MODEL FLIK HATI VAR HW 8K ','OL','1.360','1','100.00','1632000','0','0','15000','1639000','0','7000','0','1646000','RTA','T0078115','F3E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAC-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='F3E-ZCAC-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 ('F226151030432','2026-03-15','1.360','2026-03-15','10:30:43','PLG0078169','1639000','1639000','7000','1646000','1646000','kasir','2026-03-15 10:30:43','F22615103043');
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-03-15','F226151030432','2026-03-15','10:30:43','RTA','1646000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260315-0004','D','2026-03-15','10:30:43','kasir','PENJUALAN','F226151030432','7160044000','1646000','7161690000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1646000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151030432' 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 ('F226151036201','kasir','1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZCAC-31-T','GW TRIXIE PANJANG HATI MATA VAR LG 8K ','OL','0.560','1','100.00','672000','0','0','15000','678000','0','5000','0','683000','RTA','T0078144','B1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZCAC-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1E-ZCAC-31-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 ('F226151036201','2026-03-15','0.560','2026-03-15','10:36:21','PLG0078170','678000','678000','5000','683000','683000','kasir','2026-03-15 10:36:20','F22615103620');
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-03-15','F226151036201','2026-03-15','10:36:21','RTA','683000','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-260315-0005','D','2026-03-15','10:36:21','kasir','PENJUALAN','F226151036201','7161690000','683000','7162373000','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='F226151036201' 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 ('F226151036202','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZCAC-29-T','GW TRIXIE PANJANG HATI MATA VAR LG 8K ','OL','0.560','1','100.00','672000','0','0','15000','678000','0','5000','0','683000','RTA','T0078142','B1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZCAC-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1E-ZCAC-29-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 ('F226151036202','2026-03-15','0.560','2026-03-15','10:36:21','PLG0078171','678000','678000','5000','683000','683000','kasir','2026-03-15 10:36:20','F22615103620');
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-03-15','F226151036202','2026-03-15','10:36:21','RTA','683000','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-260315-0006','D','2026-03-15','10:36:21','kasir','PENJUALAN','F226151036202','7162373000','683000','7163056000','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='F226151036202' 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 ('F226151036203','kasir',' 1',' MEA1E LG ','TOKO','SMBK-A','A1E-ZBAC-75-T','AT DAISY MATA LG 8K ','OL','0.580','1','100.00','705000','0','0','15000','702000','0','5000','0','707000','RTA','T0077284','A1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAC-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='A1E-ZBAC-75-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 ('F226151036203','2026-03-15','0.580','2026-03-15','10:36:21','PLG0078172','702000','702000','5000','707000','707000','kasir','2026-03-15 10:36:20','F22615103620');
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-03-15','F226151036203','2026-03-15','10:36:21','RTA','707000','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-260315-0007','D','2026-03-15','10:36:21','kasir','PENJUALAN','F226151036203','7163056000','707000','7163763000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='707000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151036203' 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 ('F226151036204','kasir',' 1',' MEA1E X LG','TOKO','SMBK-A','A1E-ZAAC-16-0','AT X DAISY MATA LG 8K ','OL','0.500','1','100.00','607000','0','0','15000','605000','0','5000','0','610000','RTA','00384923','A1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZAAC-16-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-03-15' AND kode_barang='A1E-ZAAC-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226151036204','2026-03-15','0.500','2026-03-15','10:36:21','PLG0078173','605000','605000','5000','610000','610000','kasir','2026-03-15 10:36:20','F22615103620');
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-03-15','F226151036204','2026-03-15','10:36:21','RTA','610000','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-260315-0008','D','2026-03-15','10:36:21','kasir','PENJUALAN','F226151036204','7163763000','610000','7164373000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='610000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151036204' 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 ('F226151036205','kasir',' 1',' MGE1 LG 18','TOKO','SMBK-E','E1G-ZCXF-47-T','CC MODEL HATI VAR LG 18 8K ','OL','0.350','1','100.00','439000','0','0','15000','438000','0','5000','0','443000','RTA','T0077869','E1G','0','0','-','1','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCXF-47-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-03-15' AND kode_barang='E1G-ZCXF-47-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 ('F226151036205','2026-03-15','0.350','2026-03-15','10:36:21','PLG0078174','438000','438000','5000','443000','443000','kasir','2026-03-15 10:36:20','F22615103620');
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-03-15','F226151036205','2026-03-15','10:36:21','RTA','443000','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-260315-0009','D','2026-03-15','10:36:21','kasir','PENJUALAN','F226151036205','7164373000','443000','7164816000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='443000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151036205' 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 ('F226151036206','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-ZCXG-64-T','GW TUSUK DEASY MATA LG PE 8K ','OL','0.580','1','100.00','705000','0','0','15000','702000','0','5000','0','707000','RTA','T0077935','B1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZCXG-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1E-ZCXG-64-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226151036206','2026-03-15','0.580','2026-03-15','10:36:21','PLG0078175','702000','702000','5000','707000','707000','kasir','2026-03-15 10:36:20','F22615103620');
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-03-15','F226151036206','2026-03-15','10:36:21','RTA','707000','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-260315-0010','D','2026-03-15','10:36:21','kasir','PENJUALAN','F226151036206','7164816000','707000','7165523000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='707000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151036206' 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 ('F226151036207','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-ZCXG-63-T','GW TUSUK DEASY MATA LG PE 8K ','OL','0.550','1','100.00','668000','0','0','15000','666000','0','5000','0','671000','RTA','T0077934','B1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZCXG-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1E-ZCXG-63-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226151036207','2026-03-15','0.550','2026-03-15','10:36:21','PLG0078176','666000','666000','5000','671000','671000','kasir','2026-03-15 10:36:20','F22615103620');
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-03-15','F226151036207','2026-03-15','10:36:21','RTA','671000','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-260315-0011','D','2026-03-15','10:36:21','kasir','PENJUALAN','F226151036207','7165523000','671000','7166194000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='671000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151036207' 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 ('F226151109041','kasir','1',' TEF3 X AU ','TOKO','TBK-F','F3TE-YLBF-44-T','GL X BAMBU ARESO VAR AU 17K ','','3.560','1','100.00','7832000','0','0','15000','7690000','0','0','0','7690000','TIN','T0076214','F3TE','0','0','-','1','2200000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YLBF-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.560',berat_jual_asli=berat_jual_asli+'3.560',stock_jual='1',berat_akhir=berat_akhir-'3.560',berat_akhir_asli=berat_akhir_asli-'3.560',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='F3TE-YLBF-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226151109041','2026-03-15','3.560','2026-03-15','11:09:05','PLG0078177','7690000','7690000','0','7690000','7690000','kasir','2026-03-15 11:09:04','F22615110904');
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-03-15','F226151109041','2026-03-15','11:09:05','TIN','7690000','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-260315-0012','D','2026-03-15','11:09:05','kasir','PENJUALAN','F226151109041','7166194000','7690000','7173884000');
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 ('F226151110231','kasir','1',' MEE2 5K LG','TOKO','SMBK-E','E2E-ZCXF-12-T','CC ANAK OSROT BONEKA CAT MATA LG 8K ','','0.460','1','100.00','559000','0','0','15000','550000','0','5000','0','555000','RTA','T0077834','E2E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCXF-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E2E-ZCXF-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226151110231','2026-03-15','0.460','2026-03-15','11:10:24','PLG0078178','550000','550000','5000','555000','555000','kasir','2026-03-15 11:10:23','F22615111023');
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-03-15','F226151110231','2026-03-15','11:10:24','RTA','555000','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-260315-0013','D','2026-03-15','11:10:24','kasir','PENJUALAN','F226151110231','7173884000','555000','7174439000');
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 ('F226151112571','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZCAA-53-T','GL MODEL FANCY VAR HW 8K ','','0.810','1','100.00','984000','0','0','15000','968000','0','0','0','968000','RHM','T0078052','F3E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAA-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='F3E-ZCAA-53-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 ('F226151112571','2026-03-15','0.810','2026-03-15','11:12:58','PLG0078179','968000','968000','0','968000','968000','kasir','2026-03-15 11:12:57','F22615111257');
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-03-15','F226151112571','2026-03-15','11:12:58','RHM','968000','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-260315-0014','D','2026-03-15','11:12:58','kasir','PENJUALAN','F226151112571','7174439000','968000','7175407000');
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 ('F226151124591','kasir','1',' MEE2 X LG ','TOKO','SMBK-E','E2E-YLAG-223-0','CC X MODEL MATA LG 10 8K','','0.550','1','100.00','668000','0','0','15000','657000','0','0','0','657000','RTA','00381577','E2E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLAG-223-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E2E-YLAG-223-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 ('F226151124591','2026-03-15','0.550','2026-03-15','11:24:59','PLG0078180','657000','657000','0','657000','657000','kasir','2026-03-15 11:24:59','F22615112459');
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-03-15','F226151124591','2026-03-15','11:24:59','RTA','657000','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-260315-0015','D','2026-03-15','11:24:59','kasir','PENJUALAN','F226151124591','7175407000','657000','7176064000');
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 ('F226151130551','kasir','1',' MGE1 HW 17','TOKO','SMBK-E','E1G-ZCXF-39-T','CC LITRING GELOMBANG HW 17 8K ','OL','0.350','1','100.00','439000','0','0','15000','436000','0','5000','0','441000','TIN','T0077861','E1G','0','0','-','1','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCXF-39-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-03-15' AND kode_barang='E1G-ZCXF-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 ('F226151130551','2026-03-15','0.350','2026-03-15','11:30:56','PLG0078181','436000','436000','5000','441000','441000','kasir','2026-03-15 11:30:55','F22615113055');
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-03-15','F226151130551','2026-03-15','11:30:56','TIN','441000','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-260315-0016','D','2026-03-15','11:30:56','kasir','PENJUALAN','F226151130551','7176064000','441000','7176505000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='441000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151130551' 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 ('F226151130552','kasir',' 1',' MEE2 HW 17','TOKO','SMBK-E','E2E-YHAA-24-T','CC MODEL MATA VAR HW 17 8K ','OL','0.550','1','100.00','668000','0','0','15000','663000','0','5000','0','668000','TIN','T0072199','E2E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHAA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E2E-YHAA-24-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 ('F226151130552','2026-03-15','0.550','2026-03-15','11:30:56','PLG0078182','663000','663000','5000','668000','668000','kasir','2026-03-15 11:30:55','F22615113055');
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-03-15','F226151130552','2026-03-15','11:30:56','TIN','668000','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-260315-0017','D','2026-03-15','11:30:56','kasir','PENJUALAN','F226151130552','7176505000','668000','7177173000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='668000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226151130552' 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 ('F226151142291','kasir','1',' MEF3 14K L','TOKO','SMBK-F','F3E-ZCAX-52-T','GL MODEL MEDAN PASIR VAR LG 8K','OL','2.730','1','100.00','3317000','0','0','15000','3289000','0','14000','0','3303000','RTA','T0077993','F3E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAX-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.730',berat_jual_asli=berat_jual_asli+'2.730',stock_jual='1',berat_akhir=berat_akhir-'2.730',berat_akhir_asli=berat_akhir_asli-'2.730',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='F3E-ZCAX-52-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 ('F226151142291','2026-03-15','2.730','2026-03-15','11:42:29','PLG0078183','3289000','3289000','14000','3303000','3303000','kasir','2026-03-15 11:42:29','F22615114229');
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-03-15','F226151142291','2026-03-15','11:42:29','RTA','3303000','14000');
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-260315-0018','D','2026-03-15','11:42:29','kasir','PENJUALAN','F226151142291','7177173000','3303000','7180476000');
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 ('F226151156301','kasir','1',' MEH1 X HW ','TOKO','SMBK-H','H1E-ZCXB-368-0','KL X SANTA AUREL MATA HW 42 8K ','OL','2.370','1','100.00','2880000','0','0','15000','2844000','0','12000','0','2856000','RTA','00391791','H1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCXB-368-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.370',berat_jual_asli=berat_jual_asli+'2.370',stock_jual='1',berat_akhir=berat_akhir-'2.370',berat_akhir_asli=berat_akhir_asli-'2.370',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='H1E-ZCXB-368-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 ('F226151156301','2026-03-15','2.370','2026-03-15','11:56:31','PLG0078184','2844000','2844000','12000','2856000','2856000','kasir','2026-03-15 11:56:30','F22615115630');
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-03-15','F226151156301','2026-03-15','11:56:31','RTA','2856000','12000');
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-260315-0019','D','2026-03-15','11:56:31','kasir','PENJUALAN','F226151156301','7180476000','2856000','7183332000');
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 ('F226151224111','kasir','1',' MEE2E CM 1','TOKO','SMBK-E','E2E-ZBAC-42-T','CC WEDDING MATA CM 12 8K ','','1.100','1','100.00','1336000','0','0','15000','1315000','0','0','0','1315000','RTA','T0077251','E2E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZBAC-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E2E-ZBAC-42-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 ('F226151224111','2026-03-15','1.100','2026-03-15','12:24:12','PLG0078185','1315000','1315000','0','1315000','1315000','kasir','2026-03-15 12:24:11','F22615122411');
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-03-15','F226151224111','2026-03-15','12:24:12','RTA','1315000','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-260315-0020','D','2026-03-15','12:24:12','kasir','PENJUALAN','F226151224111','7183332000','1315000','7184647000');
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 ('F226150117351','kasir','1',' TFE1 LG ','TOKO','TBK-E','E1TF-WCBD-66-T','CC BABY PLAT GRAFIR VAR LG ','OL','0.520','1','100.00','1154000','0','0','15000','1139000','0','7000','0','1146000','RTA','T0042919','E1TF','0','0','-','1','2220000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TF-WCBD-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E1TF-WCBD-66-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 ('F226150117351','2026-03-15','0.520','2026-03-15','13:17:35','PLG0078186','1139000','1139000','7000','1146000','1146000','kasir','2026-03-15 13:17:35','F22615011735');
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-03-15','F226150117351','2026-03-15','13:17:35','RTA','1146000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260315-0021','D','2026-03-15','13:17:35','kasir','PENJUALAN','F226150117351','7184647000','1146000','7185793000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1146000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150117351' 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 ('F226150117352','kasir',' 1',' TEA1 X UB ','TOKO','TBK-A','A1TE-YJXB-95-T','AT X JERSY SLEP UB 17K ','OL','0.570','1','100.00','1254000','0','0','15000','1238000','0','7000','0','1245000','RTA','T0073675','A1TE','0','0','-','1','2200000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-YJXB-95-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-03-15' AND kode_barang='A1TE-YJXB-95-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 ('F226150117352','2026-03-15','0.570','2026-03-15','13:17:35','PLG0078187','1238000','1238000','7000','1245000','1245000','kasir','2026-03-15 13:17:35','F22615011735');
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-03-15','F226150117352','2026-03-15','13:17:35','RTA','1245000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260315-0022','D','2026-03-15','13:17:35','kasir','PENJUALAN','F226150117352','7185793000','1245000','7187038000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1245000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150117352' 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 ('F226150120571','kasir','1',' TEE2 X LG ','TOKO','TBK-E','E2TE-XEAX-39-T','CC X ANAK OSROT EROPA MATA LG 17K ','','1.160','1','100.00','2552000','0','0','15000','2506000','0','10000','0','2516000','TJ','T0057061','E2TE','0','0','-','1','2200000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-XEAX-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E2TE-XEAX-39-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 ('F226150120571','2026-03-15','1.160','2026-03-15','13:20:57','PLG0078188','2506000','2506000','10000','2516000','2516000','kasir','2026-03-15 13:20:57','F22615012057');
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-03-15','F226150120571','2026-03-15','13:20:57','TJ','2516000','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-260315-0023','D','2026-03-15','13:20:57','kasir','PENJUALAN','F226150120571','7187038000','2516000','7189554000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2516000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150120571' 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 ('F226150120572','kasir',' 1',' TEE2 CM 16','TOKO','TBK-E','E2TE-WACA-44-T','CC SOLITAIRE INFINITY MATA CM 16 ','','1.650','1','100.00','3630000','0','0','15000','3564000','0','10000','0','3574000','TJ','T0041908','E2TE','0','0','-','1','2200000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WACA-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E2TE-WACA-44-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 ('F226150120572','2026-03-15','1.650','2026-03-15','13:20:57','PLG0078189','3564000','3564000','10000','3574000','3574000','kasir','2026-03-15 13:20:57','F22615012057');
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-03-15','F226150120572','2026-03-15','13:20:57','TJ','3574000','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-260315-0024','D','2026-03-15','13:20:57','kasir','PENJUALAN','F226150120572','7189554000','3574000','7193128000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3574000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150120572' 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 ('F226150214151','kasir','1',' MDE1 CM 18','TOKO','SMBK-E','E1D-ZBAI-28-T','CC MODEL SLEP VAR CM 18 8K ','OL','1.300','1','100.00','1553000','0','0','15000','1540000','0','7000','0','1547000','NS','T0077560','E1D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBAI-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E1D-ZBAI-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226150214151','2026-03-15','1.300','2026-03-15','14:14:15','PLG0078190','1540000','1540000','7000','1547000','1547000','kasir','2026-03-15 14:14:15','F22615021415');
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-03-15','F226150214151','2026-03-15','14:14:15','NS','1547000','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-260315-0025','D','2026-03-15','14:14:15','kasir','PENJUALAN','F226150214151','7193128000','1547000','7194675000');
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 ('F226150242421','kasir','1',' MHB1 LG ','TOKO','SMBK-B','B1H-ZBAF-59-T','GW TUSUK MRICAN POLOS LG 8K ','OL','0.250','1','100.00','319000','0','0','15000','316000','0','5000','0','321000','TIN','T0077438','B1H','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZBAF-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1H-ZBAF-59-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 ('F226150242421','2026-03-15','0.250','2026-03-15','14:42:43','PLG0078191','316000','316000','5000','321000','321000','kasir','2026-03-15 14:42:42','F22615024242');
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-03-15','F226150242421','2026-03-15','14:42:43','TIN','321000','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-260315-0026','D','2026-03-15','14:42:43','kasir','PENJUALAN','F226150242421','7194675000','321000','7194996000');
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 ('F226150250201','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZCXF-17-T','LT MODEL COIN DOLLAR VAR LG 8K ','OL','0.460','1','100.00','559000','0','0','15000','557000','0','10000','0','567000','RTA','T0077839','D1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXF-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='D1E-ZCXF-17-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 ('F226150250201','2026-03-15','0.460','2026-03-15','14:50:21','PLG0078192','557000','557000','10000','567000','567000','kasir','2026-03-15 14:50:20','F22615025020');
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-03-15','F226150250201','2026-03-15','14:50:21','RTA','567000','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-260315-0027','D','2026-03-15','14:50:21','kasir','PENJUALAN','F226150250201','7194996000','567000','7195563000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150250201' 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 ('F226150250202','kasir',' 1',' MDE1 CM 18','TOKO','SMBK-E','E1D-ZCXE-28-T','CC VELG PASIR VAR CM 18 8K ','OL','1.070','1','100.00','1279000','0','0','15000','1262000','0','11000','0','1273000','RTA','T0077704','E1D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCXE-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E1D-ZCXE-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226150250202','2026-03-15','1.070','2026-03-15','14:50:21','PLG0078193','1262000','1262000','11000','1273000','1273000','kasir','2026-03-15 14:50:20','F22615025020');
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-03-15','F226150250202','2026-03-15','14:50:21','RTA','1273000','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-260315-0028','D','2026-03-15','14:50:21','kasir','PENJUALAN','F226150250202','7195563000','1273000','7196836000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1273000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150250202' 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 ('F226150250203','kasir',' 1',' MEE1 X UB ','TOKO','SMBK-E','E1E-YGBA-54-0','CC X BANGKOK POLOS UB 14 8K ','OL','0.700','1','100.00','850000','0','0','15000','847000','0','10000','0','857000','RTA','00361935','E1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YGBA-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E1E-YGBA-54-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 ('F226150250203','2026-03-15','0.700','2026-03-15','14:50:21','PLG0078194','847000','847000','10000','857000','857000','kasir','2026-03-15 14:50:20','F22615025020');
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-03-15','F226150250203','2026-03-15','14:50:21','RTA','857000','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-260315-0029','D','2026-03-15','14:50:21','kasir','PENJUALAN','F226150250203','7196836000','857000','7197693000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='857000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150250203' 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 ('F226150253101','kasir','1',' MEE1 BA 14','TOKO','SMBK-E','E1E-ZCAA-29-T','CC BANGKOK SLEP BA 14 8K ','OL','0.520','1','100.00','632000','0','0','15000','630000','0','10000','0','640000','RTA','T0078028','E1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAA-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E1E-ZCAA-29-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 ('F226150253101','2026-03-15','0.520','2026-03-15','14:53:10','PLG0078195','630000','630000','10000','640000','640000','kasir','2026-03-15 14:53:10','F22615025310');
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-03-15','F226150253101','2026-03-15','14:53:10','RTA','640000','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-260315-0030','D','2026-03-15','14:53:10','kasir','PENJUALAN','F226150253101','7197693000','640000','7198333000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='640000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150253101' 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 ('F226150253102','kasir',' 1',' MFF3F UB ','TOKO','SMBK-F','F3F-ZBAC-19-T','GL KOREA UB 8K ','OL','1.500','1','100.00','1852000','0','0','15000','1830000','0','15000','0','1845000','RTA','T0077228','F3F','0','0','-','1','1270000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-ZBAC-19-T' 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-03-15' AND kode_barang='F3F-ZBAC-19-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 ('F226150253102','2026-03-15','1.500','2026-03-15','14:53:10','PLG0078196','1830000','1830000','15000','1845000','1845000','kasir','2026-03-15 14:53:10','F22615025310');
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-03-15','F226150253102','2026-03-15','14:53:10','RTA','1845000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260315-0031','D','2026-03-15','14:53:10','kasir','PENJUALAN','F226150253102','7198333000','1845000','7200178000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1845000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150253102' 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 ('F226150254101','kasir','1',' MEF3 KH ','TOKO','SMBK-F','F3E-YLXD-24-T','GL LEMES MODEL KOREA KH 8K ','OL','1.150','1','100.00','1397000','0','0','15000','1380000','0','12000','0','1392000','RTA','T0075492','F3E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXD-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='F3E-YLXD-24-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 ('F226150254101','2026-03-15','1.150','2026-03-15','14:54:11','PLG0078197','1380000','1380000','12000','1392000','1392000','kasir','2026-03-15 14:54:10','F22615025410');
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-03-15','F226150254101','2026-03-15','14:54:11','RTA','1392000','12000');
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-260315-0032','D','2026-03-15','14:54:11','kasir','PENJUALAN','F226150254101','7200178000','1392000','7201570000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150117351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150117351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150117351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150117352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150117352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150117352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150120571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150120571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150120571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150120572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150120572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150120572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150214151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150214151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150214151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150242421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150242421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150242421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150250201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150250201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150250201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150250202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150250202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150250202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150250203' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150250203' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150250203';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150253101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150253101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150253101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150253102' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150253102' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150253102';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150254101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150254101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150254101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151016121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151016121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151016121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151030431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151030431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151030431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151030432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151030432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151030432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151036201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151036202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036203' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036203' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151036203';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036204' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036204' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151036204';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036205' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036205' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151036205';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036206' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036206' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151036206';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036207' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151036207' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151036207';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151109041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151109041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151109041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151110231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151110231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151110231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151112571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151112571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151112571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151124591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151124591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151124591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151130551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151130551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151130551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151130552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151130552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151130552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151142291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151142291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151142291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151156301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151156301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151156301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226151224111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226151224111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226151224111';
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 ('F226150319051','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZCAE-4-T','LT MODEL APEL CAT VAR LG 8K ','','0.530','1','100.00','633000','0','0','15000','633000','0','5000','0','638000','NS','T0078158','D1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCAE-4-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-03-15' AND kode_barang='D1E-ZCAE-4-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 ('F226150319051','2026-03-15','0.530','2026-03-15','15:19:06','PLG0078198','633000','633000','5000','638000','638000','kasir','2026-03-15 15:19:05','F22615031905');
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-03-15','F226150319051','2026-03-15','15:19:06','NS','638000','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-260315-0033','D','2026-03-15','15:19:06','kasir','PENJUALAN','F226150319051','7201570000','638000','7202208000');
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 ('F226150321591','kasir','1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZCAC-26-T','GW TUSUK HATI POLOS CM 8K ','OL','0.250','1','100.00','319000','0','0','15000','318000','0','5000','0','323000','TIN','T0078139','B1H','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZCAC-26-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1H-ZCAC-26-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 ('F226150321591','2026-03-15','0.250','2026-03-15','15:22:00','PLG0078199','318000','318000','5000','323000','323000','kasir','2026-03-15 15:21:59','F22615032159');
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-03-15','F226150321591','2026-03-15','15:22:00','TIN','323000','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-260315-0034','D','2026-03-15','15:22:00','kasir','PENJUALAN','F226150321591','7202208000','323000','7202531000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='323000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150321591' 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 ('F226150321592','kasir',' 1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZCAC-18-T','GW TUSUK HATI POLOS CM 8K ','OL','0.250','1','100.00','319000','0','0','15000','318000','0','5000','0','323000','TIN','T0078131','B1H','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZCAC-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1H-ZCAC-18-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 ('F226150321592','2026-03-15','0.250','2026-03-15','15:22:00','PLG0078200','318000','318000','5000','323000','323000','kasir','2026-03-15 15:21:59','F22615032159');
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-03-15','F226150321592','2026-03-15','15:22:00','TIN','323000','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-260315-0035','D','2026-03-15','15:22:00','kasir','PENJUALAN','F226150321592','7202531000','323000','7202854000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='323000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150321592' 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 ('F226150321593','kasir',' 1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZCAC-16-T','GW TUSUK HATI POLOS CM 8K ','OL','0.250','1','100.00','319000','0','0','15000','318000','0','5000','0','323000','TIN','T0078129','B1H','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZCAC-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1H-ZCAC-16-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 ('F226150321593','2026-03-15','0.250','2026-03-15','15:22:00','PLG0078201','318000','318000','5000','323000','323000','kasir','2026-03-15 15:21:59','F22615032159');
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-03-15','F226150321593','2026-03-15','15:22:00','TIN','323000','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-260315-0036','D','2026-03-15','15:22:00','kasir','PENJUALAN','F226150321593','7202854000','323000','7203177000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='323000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150321593' 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 ('F226150321594','kasir',' 1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZCAC-20-T','GW TUSUK HATI POLOS CM 8K ','OL','0.250','1','100.00','319000','0','0','15000','318000','0','5000','0','323000','TIN','T0078133','B1H','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZCAC-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1H-ZCAC-20-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 ('F226150321594','2026-03-15','0.250','2026-03-15','15:22:00','PLG0078202','318000','318000','5000','323000','323000','kasir','2026-03-15 15:21:59','F22615032159');
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-03-15','F226150321594','2026-03-15','15:22:00','TIN','323000','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-260315-0037','D','2026-03-15','15:22:00','kasir','PENJUALAN','F226150321594','7203177000','323000','7203500000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='323000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150321594' 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 ('F226150321595','kasir',' 1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZCAC-23-T','GW TUSUK HATI POLOS CM 8K ','OL','0.250','1','100.00','319000','0','0','15000','318000','0','5000','0','323000','TIN','T0078136','B1H','0','0','-','1','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZCAC-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='B1H-ZCAC-23-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 ('F226150321595','2026-03-15','0.250','2026-03-15','15:22:00','PLG0078203','318000','318000','5000','323000','323000','kasir','2026-03-15 15:21:59','F22615032159');
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-03-15','F226150321595','2026-03-15','15:22:00','TIN','323000','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-260315-0038','D','2026-03-15','15:22:00','kasir','PENJUALAN','F226150321595','7203500000','323000','7203823000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='323000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150321595' 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 ('F226150321596','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZAAG-13-T','LT SLOBOK BALOK HURUF BG H 8K ','OL','0.620','1','100.00','766000','0','0','15000','763000','0','5000','0','768000','TIN','T0076607','D1F','0','0','-','1','1270000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZAAG-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='D1F-ZAAG-13-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 ('F226150321596','2026-03-15','0.620','2026-03-15','15:22:00','PLG0078204','763000','763000','5000','768000','768000','kasir','2026-03-15 15:21:59','F22615032159');
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-03-15','F226150321596','2026-03-15','15:22:00','TIN','768000','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-260315-0039','D','2026-03-15','15:22:00','kasir','PENJUALAN','F226150321596','7203823000','768000','7204591000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='768000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150321596' 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 ('F226150321597','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLCX-40-T','LT SLOBOK BULAT HURUF BG N 8K ','OL','0.660','1','100.00','815000','0','0','15000','812000','0','5000','0','817000','TIN','T0076281','D1F','0','0','-','1','1270000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLCX-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='D1F-YLCX-40-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 ('F226150321597','2026-03-15','0.660','2026-03-15','15:22:00','PLG0078205','812000','812000','5000','817000','817000','kasir','2026-03-15 15:21:59','F22615032159');
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-03-15','F226150321597','2026-03-15','15:22:00','TIN','817000','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-260315-0040','D','2026-03-15','15:22:00','kasir','PENJUALAN','F226150321597','7204591000','817000','7205408000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='817000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150321597' 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 ('F226150321598','kasir',' 1',' MGE1 UB 18','TOKO','SMBK-E','E1G-ZCAA-35-T','CC PIPA POLOS UB 18 8K ','OL','0.380','1','100.00','477000','0','0','15000','475000','0','5000','0','480000','TIN','T0078034','E1G','0','0','-','1','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZCAA-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E1G-ZCAA-35-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 ('F226150321598','2026-03-15','0.380','2026-03-15','15:22:00','PLG0078206','475000','475000','5000','480000','480000','kasir','2026-03-15 15:21:59','F22615032159');
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-03-15','F226150321598','2026-03-15','15:22:00','TIN','480000','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-260315-0041','D','2026-03-15','15:22:00','kasir','PENJUALAN','F226150321598','7205408000','480000','7205888000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150321598' 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 ('F226150325291','kasir','1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZCAA-31-T','CC BANGKOK SLEP LG 16 8K ','OL','0.480','1','100.00','583000','0','0','15000','581000','0','5000','0','586000','TIN','T0078030','E1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAA-31-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-03-15' AND kode_barang='E1E-ZCAA-31-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 ('F226150325291','2026-03-15','0.480','2026-03-15','15:25:30','PLG0078207','581000','581000','5000','586000','586000','kasir','2026-03-15 15:25:29','F22615032529');
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-03-15','F226150325291','2026-03-15','15:25:30','TIN','586000','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-260315-0042','D','2026-03-15','15:25:30','kasir','PENJUALAN','F226150325291','7205888000','586000','7206474000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='586000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150325291' 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 ('F226150325292','kasir',' 1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZCAA-30-T','CC BANGKOK SLEP LG 16 8K ','OL','0.510','1','100.00','620000','0','0','15000','617000','0','5000','0','622000','TIN','T0078029','E1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAA-30-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-03-15' AND kode_barang='E1E-ZCAA-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226150325292','2026-03-15','0.510','2026-03-15','15:25:30','PLG0078208','617000','617000','5000','622000','622000','kasir','2026-03-15 15:25:29','F22615032529');
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-03-15','F226150325292','2026-03-15','15:25:30','TIN','622000','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-260315-0043','D','2026-03-15','15:25:30','kasir','PENJUALAN','F226150325292','7206474000','622000','7207096000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='622000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150325292' 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 ('F226150325293','kasir',' 1',' MEE1 BA 14','TOKO','SMBK-E','E1E-ZCAA-28-T','CC BANGKOK SLEP BA 14 8K ','OL','0.510','1','100.00','620000','0','0','15000','617000','0','5000','0','622000','TIN','T0078027','E1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAA-28-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-03-15' AND kode_barang='E1E-ZCAA-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226150325293','2026-03-15','0.510','2026-03-15','15:25:30','PLG0078209','617000','617000','5000','622000','622000','kasir','2026-03-15 15:25:29','F22615032529');
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-03-15','F226150325293','2026-03-15','15:25:30','TIN','622000','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-260315-0044','D','2026-03-15','15:25:30','kasir','PENJUALAN','F226150325293','7207096000','622000','7207718000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='622000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150325293' 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 ('F226150325294','kasir',' 1',' MEE1 BA 18','TOKO','SMBK-E','E1E-ZCAA-25-T','CC BANGKOK SLEP BA 18 8K ','OL','0.530','1','100.00','644000','0','0','15000','641000','0','5000','0','646000','TIN','T0078024','E1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAA-25-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-03-15' AND kode_barang='E1E-ZCAA-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226150325294','2026-03-15','0.530','2026-03-15','15:25:30','PLG0078210','641000','641000','5000','646000','646000','kasir','2026-03-15 15:25:29','F22615032529');
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-03-15','F226150325294','2026-03-15','15:25:30','TIN','646000','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-260315-0045','D','2026-03-15','15:25:30','kasir','PENJUALAN','F226150325294','7207718000','646000','7208364000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='646000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150325294' 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 ('F226150325295','kasir',' 1',' MDE1 HW 17','TOKO','SMBK-E','E1E-ZCAA-24-T','CC MODEL SLEP VAR HW 17 8K ','OL','0.730','1','100.00','887000','0','0','15000','869000','0','5000','0','874000','TIN','T0078023','E1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAA-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E1E-ZCAA-24-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 ('F226150325295','2026-03-15','0.730','2026-03-15','15:25:30','PLG0078211','869000','869000','5000','874000','874000','kasir','2026-03-15 15:25:29','F22615032529');
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-03-15','F226150325295','2026-03-15','15:25:30','TIN','874000','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-260315-0046','D','2026-03-15','15:25:30','kasir','PENJUALAN','F226150325295','7208364000','874000','7209238000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='874000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150325295' 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 ('F226150325296','kasir',' 1',' MDE2 X LG ','TOKO','SMBK-E','E2D-ZCXI-120-0','CC X MODEL MATA LG 12 8K ','OL','0.930','1','100.00','1111000','0','0','15000','1107000','0','5000','0','1112000','TIN','00392935','E2D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCXI-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='E2D-ZCXI-120-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 ('F226150325296','2026-03-15','0.930','2026-03-15','15:25:30','PLG0078212','1107000','1107000','5000','1112000','1112000','kasir','2026-03-15 15:25:29','F22615032529');
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-03-15','F226150325296','2026-03-15','15:25:30','TIN','1112000','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-260315-0047','D','2026-03-15','15:25:30','kasir','PENJUALAN','F226150325296','7209238000','1112000','7210350000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1112000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150325296' 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 ('F226150325297','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZCXG-24-T','GL MODEL GENIA UB 8K ','OL','0.470','1','100.00','571000','0','0','15000','569000','0','5000','0','574000','TIN','T0077895','F3E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXG-24-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-03-15' AND kode_barang='F3E-ZCXG-24-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 ('F226150325297','2026-03-15','0.470','2026-03-15','15:25:30','PLG0078213','569000','569000','5000','574000','574000','kasir','2026-03-15 15:25:29','F22615032529');
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-03-15','F226150325297','2026-03-15','15:25:30','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,status_valid) VALUES ('KM-260315-0048','D','2026-03-15','15:25:30','kasir','PENJUALAN','F226150325297','7210350000','574000','7210924000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='574000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150325297' 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 ('F226150325298','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZCXG-23-T','GL MODEL GENIA UB 8K ','OL','0.470','1','100.00','571000','0','0','15000','569000','0','5000','0','574000','TIN','T0077894','F3E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXG-23-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-03-15' AND kode_barang='F3E-ZCXG-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 ('F226150325298','2026-03-15','0.470','2026-03-15','15:25:30','PLG0078214','569000','569000','5000','574000','574000','kasir','2026-03-15 15:25:29','F22615032529');
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-03-15','F226150325298','2026-03-15','15:25:30','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,status_valid) VALUES ('KM-260315-0049','D','2026-03-15','15:25:30','kasir','PENJUALAN','F226150325298','7210924000','574000','7211498000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='574000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150325298' 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 ('F226150327231','kasir','1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZCAB-18-T','GL MODEL FANCY VAR KH 8K ','OL','2.080','1','100.00','2496000','0','0','15000','2507000','0','10000','0','2517000','TIN','T0078089','F3E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAB-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='F3E-ZCAB-18-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 ('F226150327231','2026-03-15','2.080','2026-03-15','15:27:23','PLG0078215','2507000','2507000','10000','2517000','2517000','kasir','2026-03-15 15:27:23','F22615032723');
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-03-15','F226150327231','2026-03-15','15:27:23','TIN','2517000','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-260315-0050','D','2026-03-15','15:27:23','kasir','PENJUALAN','F226150327231','7211498000','2517000','7214015000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2517000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150327231' 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 ('F226150327232','kasir',' 1',' MEH1 UB ','TOKO','SMBK-H','H1E-ZCAA-56-T','KL TRIXIE MODEL HATI MATA VAR UB 8K ','OL','1.210','1','100.00','1470000','0','0','15000','1458000','0','6000','0','1464000','TIN','T0078055','H1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAA-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='H1E-ZCAA-56-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 ('F226150327232','2026-03-15','1.210','2026-03-15','15:27:23','PLG0078216','1458000','1458000','6000','1464000','1464000','kasir','2026-03-15 15:27:23','F22615032723');
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-03-15','F226150327232','2026-03-15','15:27:23','TIN','1464000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260315-0051','D','2026-03-15','15:27:23','kasir','PENJUALAN','F226150327232','7214015000','1464000','7215479000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1464000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150327232' 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 ('F226150327233','kasir',' 1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZCXG-242-0','KL X TIFF MATA VAR UB 8K ','OL','1.850','1','100.00','2248000','0','0','15000','2230000','0','9000','0','2239000','TIN','00392678','H1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCXG-242-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='H1E-ZCXG-242-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 ('F226150327233','2026-03-15','1.850','2026-03-15','15:27:23','PLG0078217','2230000','2230000','9000','2239000','2239000','kasir','2026-03-15 15:27:23','F22615032723');
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-03-15','F226150327233','2026-03-15','15:27:23','TIN','2239000','9000');
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-260315-0052','D','2026-03-15','15:27:23','kasir','PENJUALAN','F226150327233','7215479000','2239000','7217718000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2239000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150327233' 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 ('F226150327234','kasir',' 1',' MEH1 10K U','TOKO','SMBK-H','H1E-ZCAA-57-T','KL TRIXIE SPECTRA MERAH VAR UB 8K ','OL','1.950','1','100.00','2369000','0','0','15000','2350000','0','10000','0','2360000','TIN','T0078056','H1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAA-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='H1E-ZCAA-57-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 ('F226150327234','2026-03-15','1.950','2026-03-15','15:27:23','PLG0078218','2350000','2350000','10000','2360000','2360000','kasir','2026-03-15 15:27:23','F22615032723');
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-03-15','F226150327234','2026-03-15','15:27:23','TIN','2360000','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-260315-0053','D','2026-03-15','15:27:23','kasir','PENJUALAN','F226150327234','7217718000','2360000','7220078000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2360000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226150327234' LIMIT 1;
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-00005194','X-00005194','AT X BABY TINDIK DG 8K','GR','---','A1H','BELI','BELI001','205000','2026-03-15','0.250','1','kasir','2026-03-15 15:40:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1H','X-00005194','X-00005194');
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-260315-0001','F225291215541','RTA','1','BELI','BELI001','A1H', 'X-00005194', 'AT X BABY TINDIK DG 8K','0.250','0.250','100.00','226000','205000','820000','1275000','1','205000','205000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.250',berat_beli_asli=berat_beli_asli+'0.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.250',berat_akhir_asli=berat_akhir_asli+'0.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1H' 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-260315-0001','2026-03-15','2026-03-15','15:40:59','RTA','---','0.250','205000','205000','205000','205000','205000','kasir','2026-03-15 15:40:59','FB-260315-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260315-0001','R.AYU','MUNGGUNG PULUNG','','','','kasir','2026-03-15 15:40:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-15' 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-260315-0054','K','2026-03-15','15:40:59','kasir','PEMBELIAN UMUM','FB-260315-0001','7220078000','205000','7219873000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150319051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150319051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150319051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150321591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150321592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321593' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321593' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150321593';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321594' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321594' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150321594';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321595' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321595' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150321595';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321596' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321596' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150321596';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321597' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321597' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150321597';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321598' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150321598' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150321598';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150325291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150325292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150325293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325294' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325294' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150325294';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325295' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325295' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150325295';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325296' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325296' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150325296';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325297' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325297' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150325297';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325298' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150325298' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150325298';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150327231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150327231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150327231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150327232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150327232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150327232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150327233' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150327233' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150327233';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226150327234' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226150327234' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226150327234';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260315-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260315-0001';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-15';
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-03-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-15' 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-260316-0001','D','2026-03-16','16:06:51','SYSTEM','SALDO AWAL','SALDO AWAL','0','7219873000','7219873000');
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-260316-0001','D','2026-03-16','16:06:51','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260316-0001','D','2026-03-16','16:06:51','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-260316-0001','D','2026-03-16','16:06:51','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-260316-0001','D','2026-03-16','16:06:51','','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-260316-0001','D','2026-03-16','16:06:51','BCA','SALDO AWAL','SALDO AWAL','0','4306160888','4306160888');
UPDATE tp_system SET tgl_system='2026-03-16';