INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-31';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-31';
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-05-31' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-31';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-31';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-31';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-31';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-06-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-31' 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-260601-0001','D','2026-06-01','08:43:25','SYSTEM','SALDO AWAL','SALDO AWAL','0','10285164000','10285164000');
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-260601-0001','D','2026-06-01','08:43:25','BCA','SALDO AWAL','SALDO AWAL','0','4460121888','4460121888');
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-260601-0001','D','2026-06-01','08:43:25','','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-260601-0001','D','2026-06-01','08:43:25','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-260601-0001','D','2026-06-01','08:43:25','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-260601-0001','D','2026-06-01','08:43:25','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-06-01';
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 ('F226010845371','kasir','1',' MEA1 HW ','TOKO','SMBK-A','A1E-ZCAA-10-T','AT MODEL ITALY PANJANG VAR HW 8K','OLS T3JKH','0.620','1','100.00','691000','0','0','15000','707000','0','70000','0','777000','TJ','T0078009','A1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCAA-10-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-06-01' AND kode_barang='A1E-ZCAA-10-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 ('F226010845371','2026-06-01','0.620','2026-06-01','08:45:38','PLG0080580','707000','707000','70000','777000','777000','kasir','2026-06-01 08:45:37','F22601084537');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010845371','2026-06-01','08:45:38','TJ','777000','70000');
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-260601-0002','D','2026-06-01','08:45:38','kasir','PENJUALAN','F226010845371','10285164000','777000','10285941000');
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 ('F226010847261','kasir','1',' MGSIG LG ','TOKO','SMBK-S','S1G-ZEBX-72-T','AS EXTENSION LG 8K ','OLS 251WT','0.200','1','100.00','231000','0','0','15000','236000','0','50000','0','286000','TJ','T0079663','S1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZEBX-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='S1G-ZEBX-72-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226010847261','2026-06-01','0.200','2026-06-01','08:47:27','PLG0080581','236000','236000','50000','286000','286000','kasir','2026-06-01 08:47:26','F22601084726');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010847261','2026-06-01','08:47:27','TJ','286000','50000');
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-260601-0003','D','2026-06-01','08:47:27','kasir','PENJUALAN','F226010847261','10285941000','286000','10286227000');
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 ('F226010848291','kasir','1',' MGSIG LG ','TOKO','SMBK-S','S1G-ZEBX-73-T','AS EXTENSION LG 8K ','OLS 7EJYD','0.200','1','100.00','231000','0','0','15000','236000','0','50000','0','286000','TJ','T0079664','S1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZEBX-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='S1G-ZEBX-73-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226010848291','2026-06-01','0.200','2026-06-01','08:48:30','PLG0080582','236000','236000','50000','286000','286000','kasir','2026-06-01 08:48:29','F22601084829');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010848291','2026-06-01','08:48:30','TJ','286000','50000');
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-260601-0004','D','2026-06-01','08:48:30','kasir','PENJUALAN','F226010848291','10286227000','286000','10286513000');
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 ('F226010849541','kasir','1',' MGSIG LG ','TOKO','SMBK-S','S1G-ZEBX-64-T','AS EXTENSION LG 8K ','OLS K4QQ6','0.200','1','100.00','231000','0','0','15000','236000','0','50000','0','286000','TJ','T0079655','S1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZEBX-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='S1G-ZEBX-64-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226010849541','2026-06-01','0.200','2026-06-01','08:49:54','PLG0080583','236000','236000','50000','286000','286000','kasir','2026-06-01 08:49:54','F22601084954');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010849541','2026-06-01','08:49:54','TJ','286000','50000');
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-260601-0005','D','2026-06-01','08:49:54','kasir','PENJUALAN','F226010849541','10286513000','286000','10286799000');
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 ('F226011011341','kasir','1',' MEF3E X YT','TOKO','SMBK-F','F3E-ZEBH-89-0','GL X TIFF ARESO VAR YT 8K ','','1.960','1','100.00','2185000','0','0','15000','2205000','0','0','0','2205000','RHM','00405307','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBH-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEBH-89-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226011011341','2026-06-01','1.960','2026-06-01','10:11:35','PLG0080584','2205000','2205000','0','2205000','2205000','kasir','2026-06-01 10:11:34','F22601101134');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011011341','2026-06-01','10:11:35','RHM','2205000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260601-0006','D','2026-06-01','10:11:35','kasir','PENJUALAN','F226011011341','10286799000','2205000','10289004000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2205000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011011341' 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 ('F226011011342','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBF-21-T','GL MODEL FANCY VAR HW 8K ','','1.380','1','100.00','1539000','0','0','15000','1553000','0','0','0','1553000','RHM','T0079904','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBF-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEBF-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226011011342','2026-06-01','1.380','2026-06-01','10:11:35','PLG0080585','1553000','1553000','0','1553000','1553000','kasir','2026-06-01 10:11:34','F22601101134');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011011342','2026-06-01','10:11:35','RHM','1553000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260601-0007','D','2026-06-01','10:11:35','kasir','PENJUALAN','F226011011342','10289004000','1553000','10290557000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1553000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011011342' 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 ('F226011041041','kasir','1',' MGA1G CM ','TOKO','SMBK-A','A1G-ZEBH-1-T','AT TINDIK BABY CM 8K ','','0.260','1','100.00','300000','0','0','15000','303000','0','0','0','303000','TIN','T0079942','A1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEBH-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='A1G-ZEBH-1-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 ('F226011041041','2026-06-01','0.260','2026-06-01','10:41:05','PLG0080586','303000','303000','0','303000','303000','kasir','2026-06-01 10:41:04','F22601104104');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011041041','2026-06-01','10:41:05','TIN','303000','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-260601-0008','D','2026-06-01','10:41:05','kasir','PENJUALAN','F226011041041','10290557000','303000','10290860000');
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 ('F226011128351','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBF-58-T','GL XASTELI SPECTRA SLEP HW 8K ','','2.250','1','100.00','2509000','0','0','15000','2520000','0','0','0','2520000','LUS','T0079941','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBF-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEBF-58-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 ('F226011128351','2026-06-01','2.250','2026-06-01','11:28:35','PLG0080587','2520000','2520000','0','2520000','2520000','kasir','2026-06-01 11:28:35','F22601112835');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011128351','2026-06-01','11:28:35','LUS','2520000','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-260601-0009','D','2026-06-01','11:28:35','kasir','PENJUALAN','F226011128351','10290860000','2520000','10293380000');
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 ('F226011147471','kasir','1',' MEB1 5K CM','TOKO','SMBK-B','B1E-ZDBE-49-T','GW TUSUK BUNGA CLOVER CAT CM PE 8K ','OL','0.520','1','100.00','580000','0','0','15000','590000','0','5000','0','595000','TIN','T0079018','B1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBE-49-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-06-01' AND kode_barang='B1E-ZDBE-49-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 ('F226011147471','2026-06-01','0.520','2026-06-01','11:47:47','PLG0080588','590000','590000','5000','595000','595000','kasir','2026-06-01 11:47:47','F22601114747');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011147471','2026-06-01','11:47:47','TIN','595000','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-260601-0010','D','2026-06-01','11:47:47','kasir','PENJUALAN','F226011147471','10293380000','595000','10293975000');
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 ('F226011148501','kasir','1',' MEF3 PM ','TOKO','SMBK-F','F3E-ZEXG-1-T','GL MODEL DAUN SLEP PM 8K ','OL','3.020','1','100.00','3367000','0','0','15000','3413000','0','15000','0','3428000','TIN','T0079266','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXG-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEXG-1-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 ('F226011148501','2026-06-01','3.020','2026-06-01','11:48:50','PLG0080589','3413000','3413000','15000','3428000','3428000','kasir','2026-06-01 11:48:50','F22601114850');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011148501','2026-06-01','11:48:50','TIN','3428000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260601-0011','D','2026-06-01','11:48:50','kasir','PENJUALAN','F226011148501','10293975000','3428000','10297403000');
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 ('F226011152141','kasir','1',' MGA1 CM ','TOKO','SMBK-A','A1G-ZEAE-74-T','AT TINDIK BABY CM 8K ','OL','0.250','1','100.00','289000','0','0','15000','294000','0','5000','0','299000','TIN','T0079500','A1G','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEAE-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='A1G-ZEAE-74-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 ('F226011152141','2026-06-01','0.250','2026-06-01','11:52:15','PLG0080590','294000','294000','5000','299000','299000','kasir','2026-06-01 11:52:14','F22601115214');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011152141','2026-06-01','11:52:15','TIN','299000','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-260601-0012','D','2026-06-01','11:52:15','kasir','PENJUALAN','F226011152141','10297403000','299000','10297702000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='299000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011152141' 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 ('F226011152142','kasir',' 1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZDAX-108-0','AT X ITALY SLEP VAR UB 8K ','OL','1.050','1','100.00','1150000','0','0','15000','1166000','0','5000','0','1171000','TIN','00398878','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDAX-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='A1D-ZDAX-108-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 ('F226011152142','2026-06-01','1.050','2026-06-01','11:52:15','PLG0080591','1166000','1166000','5000','1171000','1171000','kasir','2026-06-01 11:52:14','F22601115214');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011152142','2026-06-01','11:52:15','TIN','1171000','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-260601-0013','D','2026-06-01','11:52:15','kasir','PENJUALAN','F226011152142','10297702000','1171000','10298873000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1171000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011152142' 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 ('F226011152143','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBF-55-T','GL CASTELI BOLA ARESO SLEP HW 8K ','OL','2.050','1','100.00','2286000','0','0','15000','2317000','0','10000','0','2327000','TIN','T0079938','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBF-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEBF-55-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 ('F226011152143','2026-06-01','2.050','2026-06-01','11:52:15','PLG0080592','2317000','2317000','10000','2327000','2327000','kasir','2026-06-01 11:52:14','F22601115214');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011152143','2026-06-01','11:52:15','TIN','2327000','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-260601-0014','D','2026-06-01','11:52:15','kasir','PENJUALAN','F226011152143','10298873000','2327000','10301200000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2327000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011152143' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010845371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010845371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010845371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010847261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010847261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010847261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010848291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010848291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010848291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010849541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010849541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010849541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011011341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011011341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011011341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011011342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011011342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011011342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011041041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011041041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011041041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011128351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011128351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011128351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011147471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011147471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011147471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011148501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011148501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011148501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011152141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011152141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011152141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011152142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011152142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011152142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011152143' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011152143' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011152143';
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 ('F226011158151','kasir','1',' MEF1E UB 5','TOKO','SMBK-F','F1E-ZEBX-3-T','GL MODEL OVAL KUPU SLEP UB 56 8K ','OL','1.920','1','100.00','2141000','0','0','15000','2169000','0','10000','0','2179000','TIN','T0079594','F1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBX-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F1E-ZEBX-3-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 ('F226011158151','2026-06-01','1.920','2026-06-01','11:58:16','PLG0080593','2169000','2169000','10000','2179000','2179000','kasir','2026-06-01 11:58:15','F22601115815');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011158151','2026-06-01','11:58:16','TIN','2179000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260601-0015','D','2026-06-01','11:58:16','kasir','PENJUALAN','F226011158151','10301200000','2179000','10303379000');
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 ('F226011159401','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZEBA-37-T','GL LONG LING SLEP UB 8K ','OL','1.050','1','100.00','1171000','0','0','15000','1187000','0','5000','0','1192000','TIN','T0079744','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBA-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEBA-37-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 ('F226011159401','2026-06-01','1.050','2026-06-01','11:59:40','PLG0080594','1187000','1187000','5000','1192000','1192000','kasir','2026-06-01 11:59:40','F22601115940');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011159401','2026-06-01','11:59:40','TIN','1192000','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-260601-0016','D','2026-06-01','11:59:40','kasir','PENJUALAN','F226011159401','10303379000','1192000','10304571000');
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 ('F226011200521','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZEBH-394-0','CC X MODEL MATA CM 14 8K ','OL','1.100','1','100.00','1204000','0','0','15000','1221000','0','6000','0','1227000','TIN','00405612','E2D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-394-0' 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-06-01' AND kode_barang='E2D-ZEBH-394-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 ('F226011200521','2026-06-01','1.100','2026-06-01','12:00:52','PLG0080595','1221000','1221000','6000','1227000','1227000','kasir','2026-06-01 12:00:52','F22601120052');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011200521','2026-06-01','12:00:52','TIN','1227000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260601-0017','D','2026-06-01','12:00:52','kasir','PENJUALAN','F226011200521','10304571000','1227000','10305798000');
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 ('F226011201441','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZEBH-78-0','GL X SANTA PREMIER SERUT UB 8K ','OL','2.090','1','100.00','2330000','0','0','15000','2351000','0','21000','0','2372000','TIN','00405296','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBH-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEBH-78-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226011201441','2026-06-01','2.090','2026-06-01','12:01:45','PLG0080596','2351000','2351000','21000','2372000','2372000','kasir','2026-06-01 12:01:44','F22601120144');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011201441','2026-06-01','12:01:45','TIN','2372000','21000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260601-0018','D','2026-06-01','12:01:45','kasir','PENJUALAN','F226011201441','10305798000','2372000','10308170000');
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 ('F226011203321','kasir','1',' MED1E 5K L','TOKO','SMBK-D','D1E-ZEBH-97-T','LT MODEL APEL CAT HITAM SLEP LG 8K ','OL','0.530','1','100.00','591000','0','0','15000','597000','0','10000','0','607000','TIN','T0080038','D1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEBH-97-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='D1E-ZEBH-97-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 ('F226011203321','2026-06-01','0.530','2026-06-01','12:03:33','PLG0080597','597000','597000','10000','607000','607000','kasir','2026-06-01 12:03:32','F22601120332');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011203321','2026-06-01','12:03:33','TIN','607000','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-260601-0019','D','2026-06-01','12:03:33','kasir','PENJUALAN','F226011203321','10308170000','607000','10308777000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='607000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011203321' 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 ('F226011203322','kasir',' 1',' MED2E CM ','TOKO','SMBK-D','D2E-ZEBH-107-T','LT MODEL HATI MATA SLEP CM 8K ','OL','0.670','1','100.00','747000','0','0','15000','755000','0','10000','0','765000','TIN','T0080048','D2E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZEBH-107-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='D2E-ZEBH-107-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 ('F226011203322','2026-06-01','0.670','2026-06-01','12:03:33','PLG0080598','755000','755000','10000','765000','765000','kasir','2026-06-01 12:03:32','F22601120332');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011203322','2026-06-01','12:03:33','TIN','765000','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-260601-0020','D','2026-06-01','12:03:33','kasir','PENJUALAN','F226011203322','10308777000','765000','10309542000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='765000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011203322' 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 ('F226011213401','kasir','1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZEBG-199-0','AT X HUGGIES KLIP MATA UB 8K ','OL','1.230','1','100.00','1347000','0','0','15000','1365000','0','6000','0','1371000','TIN','00405198','A1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEBG-199-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='A1D-ZEBG-199-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 ('F226011213401','2026-06-01','1.230','2026-06-01','12:13:41','PLG0080599','1365000','1365000','6000','1371000','1371000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011213401','2026-06-01','12:13:41','TIN','1371000','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-260601-0021','D','2026-06-01','12:13:41','kasir','PENJUALAN','F226011213401','10309542000','1371000','10310913000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1371000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011213401' 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 ('F226011213402','kasir',' 1',' MED1E X UB','TOKO','SMBK-D','D1E-ZEBG-74-0','LT X MODEL SPECTRA HITAM UB 8K','OL','0.460','1','100.00','513000','0','0','15000','522000','0','5000','0','527000','TIN','00405072','D1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEBG-74-0' 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-06-01' AND kode_barang='D1E-ZEBG-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226011213402','2026-06-01','0.460','2026-06-01','12:13:41','PLG0080600','522000','522000','5000','527000','527000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011213402','2026-06-01','12:13:41','TIN','527000','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-260601-0022','D','2026-06-01','12:13:41','kasir','PENJUALAN','F226011213402','10310913000','527000','10311440000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='527000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011213402' 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 ('F226011213403','kasir',' 1',' MED2E X HT','TOKO','SMBK-D','D2E-ZEBG-71-0','LT X SOLITAIRE MATA HT 8K ','OL','0.500','1','100.00','557000','0','0','15000','568000','0','5000','0','573000','TIN','00405069','D2E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZEBG-71-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-06-01' AND kode_barang='D2E-ZEBG-71-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226011213403','2026-06-01','0.500','2026-06-01','12:13:41','PLG0080601','568000','568000','5000','573000','573000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011213403','2026-06-01','12:13:41','TIN','573000','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-260601-0023','D','2026-06-01','12:13:41','kasir','PENJUALAN','F226011213403','10311440000','573000','10312013000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='573000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011213403' 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 ('F226011213404','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLAH-42-T','LT CHARM HURUF D BG 8K ','OL','0.700','1','100.00','794000','0','0','15000','809000','0','5000','0','814000','TIN','T0075971','D1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLAH-42-T' 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-06-01' AND kode_barang='D1F-YLAH-42-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 ('F226011213404','2026-06-01','0.700','2026-06-01','12:13:41','PLG0080602','809000','809000','5000','814000','814000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011213404','2026-06-01','12:13:41','TIN','814000','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-260601-0024','D','2026-06-01','12:13:41','kasir','PENJUALAN','F226011213404','10312013000','814000','10312827000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='814000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011213404' 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 ('F226011213405','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBX-101-T','CC MODEL DAUN SLEP LG 18 8K ','OL','0.560','1','100.00','624000','0','0','15000','636000','0','5000','0','641000','TIN','T0079692','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBX-101-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-06-01' AND kode_barang='E1E-ZEBX-101-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226011213405','2026-06-01','0.560','2026-06-01','12:13:41','PLG0080603','636000','636000','5000','641000','641000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011213405','2026-06-01','12:13:41','TIN','641000','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-260601-0025','D','2026-06-01','12:13:41','kasir','PENJUALAN','F226011213405','10312827000','641000','10313468000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='641000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011213405' 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 ('F226011213406','kasir',' 1',' MEE1E HW 1','TOKO','SMBK-E','E1E-ZEBH-43-T','CC MODEL SLEP HW 15 8K ','OL','0.730','1','100.00','814000','0','0','15000','829000','0','5000','0','834000','TIN','T0079984','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-43-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-06-01' AND kode_barang='E1E-ZEBH-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226011213406','2026-06-01','0.730','2026-06-01','12:13:41','PLG0080604','829000','829000','5000','834000','834000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011213406','2026-06-01','12:13:41','TIN','834000','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-260601-0026','D','2026-06-01','12:13:41','kasir','PENJUALAN','F226011213406','10313468000','834000','10314302000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='834000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011213406' 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 ('F226011213407','kasir',' 1',' MDE1 CM 12','TOKO','SMBK-E','E1D-ZDBB-84-T','CC MODEL HATI SLEP VAR CM 12 8K ','OL','1.130','1','100.00','1237000','0','0','15000','1254000','0','6000','0','1260000','TIN','T0078874','E1D','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBB-84-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E1D-ZDBB-84-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 ('F226011213407','2026-06-01','1.130','2026-06-01','12:13:41','PLG0080605','1254000','1254000','6000','1260000','1260000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011213407','2026-06-01','12:13:41','TIN','1260000','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-260601-0027','D','2026-06-01','12:13:41','kasir','PENJUALAN','F226011213407','10314302000','1260000','10315562000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1260000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011213407' 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 ('F226011213408','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZEBX-112-T','GL TIFF VAR HW 8K ','OL','0.820','1','100.00','914000','0','0','15000','931000','0','5000','0','936000','TIN','T0079703','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBX-112-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEBX-112-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 ('F226011213408','2026-06-01','0.820','2026-06-01','12:13:41','PLG0080606','931000','931000','5000','936000','936000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011213408','2026-06-01','12:13:41','TIN','936000','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-260601-0028','D','2026-06-01','12:13:41','kasir','PENJUALAN','F226011213408','10315562000','936000','10316498000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='936000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011213408' 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 ('F226011213409','kasir',' 1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZEBH-79-0','GL X TIFF SLEP VAR HW 8K ','OL','0.820','1','100.00','914000','0','0','15000','931000','0','5000','0','936000','TIN','00405297','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBH-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEBH-79-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226011213409','2026-06-01','0.820','2026-06-01','12:13:41','PLG0080607','931000','931000','5000','936000','936000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011213409','2026-06-01','12:13:41','TIN','936000','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-260601-0029','D','2026-06-01','12:13:41','kasir','PENJUALAN','F226011213409','10316498000','936000','10317434000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='936000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226011213409' 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 ('F2260112134010','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEAC-18-T','GL LONG LING UB 8K ','OL','1.010','1','100.00','1126000','0','0','15000','1141000','0','5000','0','1146000','TIN','T0079423','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAC-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEAC-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 ('F2260112134010','2026-06-01','1.010','2026-06-01','12:13:41','PLG0080608','1141000','1141000','5000','1146000','1146000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F2260112134010','2026-06-01','12:13:41','TIN','1146000','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-260601-0030','D','2026-06-01','12:13:41','kasir','PENJUALAN','F2260112134010','10317434000','1146000','10318580000','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='F2260112134010' 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 ('F2260112134011','kasir',' 1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZEBH-86-0','GL X SANTA ARESO APSIR HW 8K ','OL','1.460','1','100.00','1628000','0','0','15000','1650000','0','7000','0','1657000','TIN','00405304','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBH-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZEBH-86-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F2260112134011','2026-06-01','1.460','2026-06-01','12:13:41','PLG0080609','1650000','1650000','7000','1657000','1657000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F2260112134011','2026-06-01','12:13:41','TIN','1657000','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-260601-0031','D','2026-06-01','12:13:41','kasir','PENJUALAN','F2260112134011','10318580000','1657000','10320237000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1657000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F2260112134011' 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 ('F2260112134012','kasir',' 1',' MEH1E HW 4','TOKO','SMBK-H','H1E-ZEBA-55-T','KL SANTA ARESO HATI SLEP HW 42 8K ','OL','1.890','1','100.00','2107000','0','0','15000','2136000','0','9000','0','2145000','TIN','T0079762','H1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBA-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='H1E-ZEBA-55-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 ('F2260112134012','2026-06-01','1.890','2026-06-01','12:13:41','PLG0080610','2136000','2136000','9000','2145000','2145000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F2260112134012','2026-06-01','12:13:41','TIN','2145000','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-260601-0032','D','2026-06-01','12:13:41','kasir','PENJUALAN','F2260112134012','10320237000','2145000','10322382000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2145000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F2260112134012' 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 ('F2260112134013','kasir',' 1',' MFH1 15K B','TOKO','SMBK-H','H1F-ZEAF-3-T','KL TRIXIE BUNGA PASIR VAR BG 8K ','OL','2.650','1','100.00','3008000','0','0','15000','3046000','0','15000','0','3061000','TIN','T0079525','H1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-ZEAF-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='H1F-ZEAF-3-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 ('F2260112134013','2026-06-01','2.650','2026-06-01','12:13:41','PLG0080611','3046000','3046000','15000','3061000','3061000','kasir','2026-06-01 12:13:40','F22601121340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F2260112134013','2026-06-01','12:13:41','TIN','3061000','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-260601-0033','D','2026-06-01','12:13:41','kasir','PENJUALAN','F2260112134013','10322382000','3061000','10325443000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3061000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F2260112134013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011158151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011158151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011158151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011159401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011159401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011159401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011200521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011200521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011200521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011201441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011201441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011201441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011203321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011203321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011203321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011203322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011203322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011203322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011213401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F2260112134010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F2260112134010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F2260112134010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F2260112134011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F2260112134011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F2260112134011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F2260112134012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F2260112134012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F2260112134012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F2260112134013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F2260112134013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F2260112134013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011213402';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213403' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213403' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011213403';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213404' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213404' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011213404';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213405' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213405' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011213405';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213406' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213406' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011213406';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213407' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213407' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011213407';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213408' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213408' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011213408';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213409' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011213409' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011213409';
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-20260601-0001','1','E1D-ZEAI-73-0','1','1.130','1.130','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZEAI-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZEAI-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-06-01 12:18:58' WHERE kode_barang='E1D-ZEAI-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZEAI-73-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-01 12:18:58','TOKO','SMBK-E','E1D','E1D-ZEAI-73-0','1','1.130','1.130','1','1.130','1.130','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-ZEAI-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZEAI-73-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260601-0001','1','E1D-ZFXA-24-0','1','1.260','1.260','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFXA-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFXA-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-06-01 12:18:58' WHERE kode_barang='E1D-ZFXA-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFXA-24-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-01 12:18:58','TOKO','SMBK-E','E1D','E1D-ZFXA-24-0','1','1.260','1.260','1','1.260','1.260','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-ZFXA-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFXA-24-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-20260601-0001','1','E1D-ZFXA-26-0','1','1.070','1.070','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFXA-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFXA-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-06-01 12:18:58' WHERE kode_barang='E1D-ZFXA-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFXA-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-01 12:18:58','TOKO','SMBK-E','E1D','E1D-ZFXA-26-0','1','1.070','1.070','1','1.070','1.070','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-ZFXA-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFXA-26-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-20260601-0001','1','E1E-ZFXA-28-0','1','0.600','0.600','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFXA-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFXA-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-06-01 12:18:58' WHERE kode_barang='E1E-ZFXA-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFXA-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-01 12:18:58','TOKO','SMBK-E','E1E','E1E-ZFXA-28-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZFXA-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFXA-28-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260601-0001','2026-06-01','12:18','4.060','input','2026-06-01 12:18:58');
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-20260601-0001','1','H1E-ZEBI-107-0','1','2.000','2.000','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZEBI-107-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZEBI-107-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-06-01 12:19:27' WHERE kode_barang='H1E-ZEBI-107-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZEBI-107-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-06-01 12:19:27','TOKO','SMBK-H','H1E','H1E-ZEBI-107-0','1','2.000','2.000','1','2.000','2.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZEBI-107-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZEBI-107-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260601-0001','2026-06-01','12:19','2.000','input','2026-06-01 12:19:26');
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 ('F226011223401','kasir','1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZEBH-414-0','CC X MODEL SLEP LG 18 8K ','OL','0.450','1','100.00','502000','0','0','15000','509000','0','5000','0','514000','TIN','00405632','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-414-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E1E-ZEBH-414-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 ('F226011223401','2026-06-01','0.450','2026-06-01','12:23:40','PLG0080612','509000','509000','5000','514000','514000','kasir','2026-06-01 12:23:40','F22601122340');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011223401','2026-06-01','12:23:40','TIN','514000','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-260601-0034','D','2026-06-01','12:23:40','kasir','PENJUALAN','F226011223401','10325443000','514000','10325957000');
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 ('F226011238371','kasir','1',' MEE2 X YT ','TOKO','SMBK-E','E2E-YJBC-54-0','CC X MODEL MATA YT 12 8K ','OL','0.690','1','100.00','769000','0','0','15000','780000','0','5000','0','785000','TJ','00374372','E2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJBC-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E2E-YJBC-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 ('F226011238371','2026-06-01','0.690','2026-06-01','12:38:38','PLG0080613','780000','780000','5000','785000','785000','kasir','2026-06-01 12:38:37','F22601123837');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011238371','2026-06-01','12:38:38','TJ','785000','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-260601-0035','D','2026-06-01','12:38:38','kasir','PENJUALAN','F226011238371','10325957000','785000','10326742000');
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 ('F226011258591','kasir','1',' MEH1 HW 42','TOKO','SMBK-H','H1E-ZEBI-107-0','KL SANTA HW 42 8K ','OLS RDQPM','2.000','1','100.00','2240000','0','0','15000','2250000','0','156000','0','2406000','TJ','00405764','H1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBI-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='H1E-ZEBI-107-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 ('F226011258591','2026-06-01','2.000','2026-06-01','12:58:59','PLG0080614','2250000','2250000','156000','2406000','2406000','kasir','2026-06-01 12:58:59','F22601125859');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226011258591','2026-06-01','12:58:59','TJ','2406000','156000');
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-260601-0036','D','2026-06-01','12:58:59','kasir','PENJUALAN','F226011258591','10326742000','2406000','10329148000');
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 ('F226010126401','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZECX-2-T','GL CASTELI BOLA ARESO VAR SLEP HW 8K ','OL','2.060','1','100.00','2266000','0','0','15000','2318000','0','10000','0','2328000','TJ','T0080068','F3E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZECX-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F3E-ZECX-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 ('F226010126401','2026-06-01','2.060','2026-06-01','13:26:41','PLG0080615','2318000','2318000','10000','2328000','2328000','kasir','2026-06-01 13:26:40','F22601012640');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010126401','2026-06-01','13:26:41','TJ','2328000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260601-0037','D','2026-06-01','13:26:41','kasir','PENJUALAN','F226010126401','10329148000','2328000','10331476000');
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 ('F226010128311','kasir','1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZEAE-3-T','GL OVAL MODEL C UB D54 8K ','OL','2.180','1','100.00','2431000','0','0','15000','2452000','0','11000','0','2463000','TJ','T0079429','F1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAE-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='F1E-ZEAE-3-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 ('F226010128311','2026-06-01','2.180','2026-06-01','13:28:31','PLG0080616','2452000','2452000','11000','2463000','2463000','kasir','2026-06-01 13:28:31','F22601012831');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010128311','2026-06-01','13:28:31','TJ','2463000','11000');
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-260601-0038','D','2026-06-01','13:28:31','kasir','PENJUALAN','F226010128311','10331476000','2463000','10333939000');
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 ('F226010131431','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBH-50-T','CC MODEL KUPU MATA SLEP CM 12 8K ','OL','0.760','1','100.00','847000','0','0','15000','859000','0','5000','0','864000','TJ','T0079991','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E1E-ZEBH-50-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 ('F226010131431','2026-06-01','0.760','2026-06-01','13:31:43','PLG0080617','859000','859000','5000','864000','864000','kasir','2026-06-01 13:31:43','F22601013143');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010131431','2026-06-01','13:31:43','TJ','864000','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-260601-0039','D','2026-06-01','13:31:43','kasir','PENJUALAN','F226010131431','10333939000','864000','10334803000');
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 ('F226010132481','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBH-49-T','CC MODEL KUPU MATA SLEP CM 14 8K ','OL','0.770','1','100.00','859000','0','0','15000','870000','0','5000','0','875000','TJ','T0079990','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E1E-ZEBH-49-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 ('F226010132481','2026-06-01','0.770','2026-06-01','13:32:48','PLG0080618','870000','870000','5000','875000','875000','kasir','2026-06-01 13:32:48','F22601013248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010132481','2026-06-01','13:32:48','TJ','875000','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-260601-0040','D','2026-06-01','13:32:48','kasir','PENJUALAN','F226010132481','10334803000','875000','10335678000');
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 ('F226010133411','kasir','1',' MEE2 X HW ','TOKO','SMBK-E','E2E-ZEBH-388-0','CC X MODEL MATA HW 17 8K ','OL','0.620','1','100.00','691000','0','0','15000','701000','0','5000','0','706000','TJ','00405606','E2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEBH-388-0' 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-06-01' AND kode_barang='E2E-ZEBH-388-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 ('F226010133411','2026-06-01','0.620','2026-06-01','13:33:42','PLG0080619','701000','701000','5000','706000','706000','kasir','2026-06-01 13:33:41','F22601013341');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010133411','2026-06-01','13:33:42','TJ','706000','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-260601-0041','D','2026-06-01','13:33:42','kasir','PENJUALAN','F226010133411','10335678000','706000','10336384000');
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 ('F226010135031','kasir','1',' MEE1E HW 1','TOKO','SMBK-E','E1E-ZEBH-42-T','CC MODEL SLEP HW 17 8K ','OL','0.750','1','100.00','836000','0','0','15000','848000','0','5000','0','853000','TJ','T0079983','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E1E-ZEBH-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 ('F226010135031','2026-06-01','0.750','2026-06-01','13:35:03','PLG0080620','848000','848000','5000','853000','853000','kasir','2026-06-01 13:35:03','F22601013503');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010135031','2026-06-01','13:35:03','TJ','853000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260601-0042','D','2026-06-01','13:35:03','kasir','PENJUALAN','F226010135031','10336384000','853000','10337237000');
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 ('F226010135441','kasir','1',' MEE1E HW 1','TOKO','SMBK-E','E1E-ZEBH-40-T','CC MODEL SLEP HW 13 8K ','OL','0.670','1','100.00','747000','0','0','15000','757000','0','5000','0','762000','TJ','T0079981','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E1E-ZEBH-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226010135441','2026-06-01','0.670','2026-06-01','13:35:44','PLG0080621','757000','757000','5000','762000','762000','kasir','2026-06-01 13:35:44','F22601013544');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010135441','2026-06-01','13:35:44','TJ','762000','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-260601-0043','D','2026-06-01','13:35:44','kasir','PENJUALAN','F226010135441','10337237000','762000','10337999000');
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 ('F226010137051','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBH-20-T','CC MODEL SLEP CM 13 8K ','OL','0.580','1','100.00','647000','0','0','15000','655000','0','5000','0','660000','TJ','T0079961','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-20-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-06-01' AND kode_barang='E1E-ZEBH-20-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 ('F226010137051','2026-06-01','0.580','2026-06-01','13:37:05','PLG0080622','655000','655000','5000','660000','660000','kasir','2026-06-01 13:37:05','F22601013705');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010137051','2026-06-01','13:37:05','TJ','660000','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-260601-0044','D','2026-06-01','13:37:05','kasir','PENJUALAN','F226010137051','10337999000','660000','10338659000');
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 ('F226010159511','kasir','1',' MEE1E HW15','TOKO','SMBK-E','E1E-ZECX-44-T','CC MODEL BANGKOK VAR SLEP HW 15 8K ','OL','0.420','1','100.00','462000','0','0','15000','475000','0','5000','0','480000','TIN','T0080110','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZECX-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E1E-ZECX-44-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 ('F226010159511','2026-06-01','0.420','2026-06-01','13:59:51','PLG0080623','475000','475000','5000','480000','480000','kasir','2026-06-01 13:59:51','F22601015951');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010159511','2026-06-01','13:59:51','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-260601-0045','D','2026-06-01','13:59:51','kasir','PENJUALAN','F226010159511','10338659000','480000','10339139000','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='F226010159511' 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 ('F226010159512','kasir',' 1',' MEE1E HW15','TOKO','SMBK-E','E1E-ZECX-42-T','CC MODEL BANGKOK VAR SLEP HW 15 8K ','OL','0.420','1','100.00','462000','0','0','15000','475000','0','5000','0','480000','TIN','T0080108','E1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZECX-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E1E-ZECX-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 ('F226010159512','2026-06-01','0.420','2026-06-01','13:59:51','PLG0080624','475000','475000','5000','480000','480000','kasir','2026-06-01 13:59:51','F22601015951');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010159512','2026-06-01','13:59:51','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-260601-0046','D','2026-06-01','13:59:51','kasir','PENJUALAN','F226010159512','10339139000','480000','10339619000','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='F226010159512' 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 ('F226010159513','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZEBF-37-T','CC WEDDING MATA SLEP CM 10 8K','OL','1.600','1','100.00','1752000','0','0','15000','1766000','0','10000','0','1776000','TIN','T0079920','E2D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBF-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E2D-ZEBF-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226010159513','2026-06-01','1.600','2026-06-01','13:59:51','PLG0080625','1766000','1766000','10000','1776000','1776000','kasir','2026-06-01 13:59:51','F22601015951');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010159513','2026-06-01','13:59:51','TIN','1776000','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-260601-0047','D','2026-06-01','13:59:51','kasir','PENJUALAN','F226010159513','10339619000','1776000','10341395000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1776000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226010159513' 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 ('F226010159514','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZEBF-33-T','CC WEDDING MATA SLEP CM 14 8K','OL','1.600','1','100.00','1752000','0','0','15000','1766000','0','10000','0','1776000','TIN','T0079916','E2D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBF-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E2D-ZEBF-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226010159514','2026-06-01','1.600','2026-06-01','13:59:51','PLG0080626','1766000','1766000','10000','1776000','1776000','kasir','2026-06-01 13:59:51','F22601015951');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010159514','2026-06-01','13:59:51','TIN','1776000','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-260601-0048','D','2026-06-01','13:59:51','kasir','PENJUALAN','F226010159514','10341395000','1776000','10343171000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1776000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226010159514' 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 ('F226010206171','kasir','1',' MDE2 X BM ','TOKO','SMBK-E','E2D-YLAG-210-0','CC X MODEL MATA BM 12 8K ','','0.960','1','100.00','1051000','0','0','15000','1056000','0','0','0','1056000','TJ','00381564','E2D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLAG-210-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E2D-YLAG-210-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 ('F226010206171','2026-06-01','0.960','2026-06-01','14:06:17','PLG0080627','1056000','1056000','0','1056000','1056000','kasir','2026-06-01 14:06:17','F22601020617');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010206171','2026-06-01','14:06:17','TJ','1056000','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-260601-0049','D','2026-06-01','14:06:17','kasir','PENJUALAN','F226010206171','10343171000','1056000','10344227000');
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 ('F226010212051','kasir','1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZEBH-103-T','LT CHARM SLOBOK BULAT SLEP LG 8K ','OL','0.310','1','100.00','352000','0','0','15000','357000','0','5000','0','362000','TJ','T0080044','D1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEBH-103-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='D1F-ZEBH-103-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 ('F226010212051','2026-06-01','0.310','2026-06-01','14:12:06','PLG0080628','357000','357000','5000','362000','362000','kasir','2026-06-01 14:12:05','F22601021205');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010212051','2026-06-01','14:12:06','TJ','362000','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-260601-0050','D','2026-06-01','14:12:06','kasir','PENJUALAN','F226010212051','10344227000','362000','10344589000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='362000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226010212051' 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 ('F226010212052','kasir',' 1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZEBH-102-T','LT CHARM SLOBOK BULAT SLEP LG 8K ','OL','0.350','1','100.00','397000','0','0','15000','403000','0','5000','0','408000','TJ','T0080043','D1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEBH-102-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-06-01' AND kode_barang='D1F-ZEBH-102-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 ('F226010212052','2026-06-01','0.350','2026-06-01','14:12:06','PLG0080629','403000','403000','5000','408000','408000','kasir','2026-06-01 14:12:05','F22601021205');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010212052','2026-06-01','14:12:06','TJ','408000','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-260601-0051','D','2026-06-01','14:12:06','kasir','PENJUALAN','F226010212052','10344589000','408000','10344997000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='408000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226010212052' 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 ('F226010257561','kasir','1',' MDD1 LG','TOKO','SMBK-D','D1D-ZBAA-1-T','LT COR MODEL SLEP LG 8K','OL','0.830','1','100.00','909000','0','0','15000','921000','0','5000','0','926000','TIN','T0077200','D1D','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZBAA-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='D1D-ZBAA-1-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 ('F226010257561','2026-06-01','0.830','2026-06-01','14:57:56','PLG0080630','921000','921000','5000','926000','926000','kasir','2026-06-01 14:57:56','F22601025756');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010257561','2026-06-01','14:57:56','TIN','926000','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-260601-0052','D','2026-06-01','14:57:56','kasir','PENJUALAN','F226010257561','10344997000','926000','10345923000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='926000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226010257561' 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 ('F226010257562','kasir',' 1',' MEB1E HW ','TOKO','SMBK-B','B1E-ZECX-5-T','GW MODEL PANJANG VAR MATA SLEP HW 8K ','OL','0.690','1','100.00','759000','0','0','15000','780000','0','5000','0','785000','TIN','T0080071','B1E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZECX-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='B1E-ZECX-5-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 ('F226010257562','2026-06-01','0.690','2026-06-01','14:57:56','PLG0080631','780000','780000','5000','785000','785000','kasir','2026-06-01 14:57:56','F22601025756');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010257562','2026-06-01','14:57:56','TIN','785000','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-260601-0053','D','2026-06-01','14:57:56','kasir','PENJUALAN','F226010257562','10345923000','785000','10346708000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='785000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226010257562' 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 ('F226010259071','kasir','1',' MEE2E CM10','TOKO','SMBK-E','E2E-ZECX-35-T','CC MODEL MATA SLEP CM 10 8K ','OL','0.700','1','100.00','770000','0','0','15000','791000','0','5000','0','796000','TIN','T0080101','E2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZECX-35-T' 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-06-01' AND kode_barang='E2E-ZECX-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 ('F226010259071','2026-06-01','0.700','2026-06-01','14:59:08','PLG0080632','791000','791000','5000','796000','796000','kasir','2026-06-01 14:59:07','F22601025907');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010259071','2026-06-01','14:59:08','TIN','796000','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-260601-0054','D','2026-06-01','14:59:08','kasir','PENJUALAN','F226010259071','10346708000','796000','10347504000');
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 ('F226010302031','kasir','1',' MEE2E CM14','TOKO','SMBK-E','E2E-ZECX-34-T','CC MODEL MATA SLEP CM 14 8K ','OL','0.750','1','100.00','825000','0','0','15000','848000','0','5000','0','853000','TIN','T0080100','E2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZECX-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E2E-ZECX-34-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226010302031','2026-06-01','0.750','2026-06-01','15:02:04','PLG0080633','848000','848000','5000','853000','853000','kasir','2026-06-01 15:02:03','F22601030203');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010302031','2026-06-01','15:02:04','TIN','853000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260601-0055','D','2026-06-01','15:02:04','kasir','PENJUALAN','F226010302031','10347504000','853000','10348357000');
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 ('F226010303031','kasir','1',' MEE2E CM12','TOKO','SMBK-E','E2E-ZECX-36-T','CC MODEL MATA SLEP CM 12 8K ','OL','0.780','1','100.00','858000','0','0','15000','881000','0','5000','0','886000','TIN','T0080102','E2E','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZECX-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E2E-ZECX-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226010303031','2026-06-01','0.780','2026-06-01','15:03:03','PLG0080634','881000','881000','5000','886000','886000','kasir','2026-06-01 15:03:03','F22601030303');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010303031','2026-06-01','15:03:03','TIN','886000','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-260601-0056','D','2026-06-01','15:03:03','kasir','PENJUALAN','F226010303031','10348357000','886000','10349243000');
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 ('F226010307161','kasir','1',' MFD1 8K BG','TOKO','SMBK-D','D1F-ZDBE-48-T','LT MODEL BUNGA PASIR KRAWANG BG 8K ','OL','1.100','1','100.00','1248000','0','0','15000','1257000','0','8000','0','1265000','TIN','T0079017','D1F','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDBE-48-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-06-01' AND kode_barang='D1F-ZDBE-48-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 ('F226010307161','2026-06-01','1.100','2026-06-01','15:07:17','PLG0080635','1257000','1257000','8000','1265000','1265000','kasir','2026-06-01 15:07:16','F22601030716');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010307161','2026-06-01','15:07:17','TIN','1265000','8000');
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-260601-0057','D','2026-06-01','15:07:17','kasir','PENJUALAN','F226010307161','10349243000','1265000','10350508000');
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 ('F226010308401','kasir','1',' TDE1 X CM ','TOKO','TBK-E','E1TD-ZDXD-151-T','CC X MODEL C CM 15 17K ','OL','1.520','1','100.00','3040000','0','0','15000','3075000','0','11000','0','3086000','TIN','T0078438','E1TD','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-ZDXD-151-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-06-01' AND kode_barang='E1TD-ZDXD-151-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 ('F226010308401','2026-06-01','1.520','2026-06-01','15:08:40','PLG0080636','3075000','3075000','11000','3086000','3086000','kasir','2026-06-01 15:08:40','F22601030840');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-01','F226010308401','2026-06-01','15:08:40','TIN','3086000','11000');
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-260601-0058','D','2026-06-01','15:08:40','kasir','PENJUALAN','F226010308401','10350508000','3086000','10353594000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010126401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010126401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010126401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010128311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010128311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010128311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010131431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010131431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010131431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010132481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010132481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010132481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010133411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010133411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010133411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010135031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010135031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010135031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010135441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010135441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010135441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010137051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010137051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010137051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010159511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010159511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010159511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010159512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010159512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010159512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010159513' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010159513' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010159513';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010159514' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010159514' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010159514';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010206171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010206171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010206171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010212051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010212051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010212051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010212052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010212052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010212052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010257561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010257561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010257561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010257562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010257562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010257562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010259071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010259071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010259071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010302031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010302031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010302031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010303031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010303031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010303031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010307161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010307161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010307161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226010308401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226010308401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226010308401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011223401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011223401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011223401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011238371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011238371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011238371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226011258591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226011258591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226011258591';
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-00005405','X-00005405','GL OVAL MODEL C UB D52 8K','GR','---','F1E','BELI','BELI001','1908000','2026-06-01','2.120','1','admin','2026-06-01 16:14:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005405','X-00005405');
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-260601-0001','F226280157381','LUS','1','BELI','BELI001','F1E', 'X-00005405', 'GL OVAL MODEL C UB D52 8K','2.120','2.120','100.00','2661000','1908000','900000','1120000','1','1908000','1908000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.120',berat_beli_asli=berat_beli_asli+'2.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.120',berat_akhir_asli=berat_akhir_asli+'2.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260601-0001','2026-06-01','2026-06-01','16:14:27','LUS','---','2.120','1908000','1908000','1908000','1908000','1908000','admin','2026-06-01 16:14:27','FB-260601-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260601-0001','NINGSIH','TOTOKAN MLARAK','','','082351739606','admin','2026-06-01 16:14:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-01' 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-260601-0059','K','2026-06-01','16:14:27','admin','PEMBELIAN UMUM','FB-260601-0001','10353594000','1908000','10351686000');
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-00005406','X-00005406','GL X CERAMIC GOLD MODEL UB D56 8K','GR','---','F1E','BELI','BELI001','545000','2026-06-01','0.700','1','admin','2026-06-01 16:15:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005406','X-00005406');
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-260601-0002','F225250950011','RHM','1','BELI','BELI001','F1E', 'X-00005406', 'GL X CERAMIC GOLD MODEL UB D56 8K','0.880','0.700','100.00','972000','545000','778571','1120000','1','545000','545000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260601-0002','2026-06-01','2026-06-01','16:15:32','RHM','---','0.700','545000','545000','545000','545000','545000','admin','2026-06-01 16:15:33','FB-260601-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260601-0002','AZZA','JOSARI JETIS','','','','admin','2026-06-01 16:15:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-01' 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-260601-0060','K','2026-06-01','16:15:32','admin','PEMBELIAN UMUM','FB-260601-0002','10351686000','545000','10351141000');
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-00005407','X-00005407','CC MODEL RANTAI SLEP CM 15 8K','GR','---','E1E','BELI','BELI001','546000','2026-06-01','0.610','1','admin','2026-06-01 16:15:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005407','X-00005407');
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-260601-0003','F226290958333','RHM','2','BELI','BELI001','E1E', 'X-00005407', 'CC MODEL RANTAI SLEP CM 15 8K','0.610','0.610','100.00','683000','546000','895082','1120000','1','546000','546000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.610',berat_beli_asli=berat_beli_asli+'0.610',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.610',berat_akhir_asli=berat_akhir_asli+'0.610',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260601-0003','2026-06-01','2026-06-01','16:15:32','RHM','---','0.610','546000','546000','546000','546000','546000','admin','2026-06-01 16:15:33','FB-260601-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260601-0003','ROFI','KBP DURIYAT NO 28 B BARAT POLRES','','','081372984690','admin','2026-06-01 16:15:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-01' 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-260601-0061','K','2026-06-01','16:15:32','admin','PEMBELIAN UMUM','FB-260601-0003','10351141000','546000','10350595000');
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-00005408','X-00005408','LT SLOBOK BOLA ARESO LG 8K','GR','---','D1G','BELI','BELI001','345000','2026-06-01','0.330','1','admin','2026-06-01 16:15:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00005408','X-00005408');
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-260601-0004','F226021239301','RHM','3','BELI','BELI001','D1G', 'X-00005408', 'LT SLOBOK BOLA ARESO LG 8K','0.330','0.330','100.00','400000','345000','1045455','1155000','1','345000','345000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.330',berat_beli_asli=berat_beli_asli+'0.330',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.330',berat_akhir_asli=berat_akhir_asli+'0.330',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260601-0004','2026-06-01','2026-06-01','16:15:32','RHM','---','0.330','345000','345000','345000','345000','345000','admin','2026-06-01 16:15:33','FB-260601-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260601-0004','VERONIKA','DS SINGGAHAN MOJO PULUNG','','','081390014972','admin','2026-06-01 16:15:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-01' 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-260601-0062','K','2026-06-01','16:15:32','admin','PEMBELIAN UMUM','FB-260601-0004','10350595000','345000','10350250000');
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-00005409','X-00005409','GW TRIXIE PANJANG MODEL MATA VAR LG 8K','GR','---','B1F','BELI','BELI001','195000','2026-06-01','0.250','1','admin','2026-06-01 16:15:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00005409','X-00005409');
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-260601-0005','F224150349441','TIN','1','BELI','BELI001','B1F', 'X-00005409', 'GW TRIXIE PANJANG MODEL MATA VAR LG 8K','0.590','0.250','100.00','348000','195000','780000','1135000','1','195000','195000','RUSAK');
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-06-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-260601-0005','2026-06-01','2026-06-01','16:15:57','TIN','---','0.250','195000','195000','195000','195000','195000','admin','2026-06-01 16:15:58','FB-260601-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260601-0005','KHAYLLA DENA','NGGALAK SLAHUNG','','','085855015305','admin','2026-06-01 16:15:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-01' 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-260601-0063','K','2026-06-01','16:15:57','admin','PEMBELIAN UMUM','FB-260601-0005','10350250000','195000','10350055000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260601-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260601-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260601-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260601-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260601-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260601-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260601-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260601-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260601-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260601-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-01';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-01' 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-260602-0001','D','2026-06-02','17:16:40','SYSTEM','SALDO AWAL','SALDO AWAL','0','10350055000','10350055000');
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-260602-0001','D','2026-06-02','17:16:40','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-260602-0001','D','2026-06-02','17:16:40','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-260602-0001','D','2026-06-02','17:16:40','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-260602-0001','D','2026-06-02','17:16:40','','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-260602-0001','D','2026-06-02','17:16:40','BCA','SALDO AWAL','SALDO AWAL','0','4460121888','4460121888');
UPDATE tp_system SET tgl_system='2026-06-02';