INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-21';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-21';
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-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-21' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260622-0001','D','2026-06-22','08:14:56','SYSTEM','SALDO AWAL','SALDO AWAL','0','11072193000','11072193000');
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-260622-0001','D','2026-06-22','08:14:56','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260622-0001','D','2026-06-22','08:14:56','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260622-0001','D','2026-06-22','08:14:56','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-260622-0001','D','2026-06-22','08:14:56','','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-260622-0001','D','2026-06-22','08:14:56','BCA','SALDO AWAL','SALDO AWAL','0','4545951888','4545951888');
UPDATE tp_system SET tgl_system='2026-06-22';
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 ('F226220927191','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZEXA-8-T','AT MODEL JANGKAR MATA VAR LG 8K ','OL','0.550','1','100.00','602000','0','0','15000','608000','0','5000','0','613000','TIN','T0079120','A1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEXA-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='A1E-ZEXA-8-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 ('F226220927191','2026-06-22','0.550','2026-06-22','09:27:20','PLG0081267','608000','608000','5000','613000','613000','kasir','2026-06-22 09:27:19','F22622092719');
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-22','F226220927191','2026-06-22','09:27:20','TIN','613000','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-260622-0002','D','2026-06-22','09:27:20','kasir','PENJUALAN','F226220927191','11072193000','613000','11072806000');
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 ('F226220928411','kasir','1',' MDD1 CM ','TOKO','SMBK-D','D1D-ZEAC-2-T','LT MODEL JANGKAR VAR CM 8K ','OL','1.000','1','100.00','1075000','0','0','15000','1080000','0','5000','0','1085000','TIN','T0079407','D1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZEAC-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='D1D-ZEAC-2-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 ('F226220928411','2026-06-22','1.000','2026-06-22','09:28:42','PLG0081268','1080000','1080000','5000','1085000','1085000','kasir','2026-06-22 09:28:41','F22622092841');
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-22','F226220928411','2026-06-22','09:28:42','TIN','1085000','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-260622-0003','D','2026-06-22','09:28:42','kasir','PENJUALAN','F226220928411','11072806000','1085000','11073891000');
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 ('F226220940241','kasir','1',' MDE1 5K PM','TOKO','SMBK-E','E1D-ZFXE-36-T','CC MODEL BANGKOK SLEP PM 16 8K ','','1.080','1','100.00','1161000','0','0','15000','1161000','0','5000','0','1166000','LUS','T0080338','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXE-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1D-ZFXE-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 ('F226220940241','2026-06-22','1.080','2026-06-22','09:40:25','PLG0081269','1161000','1161000','5000','1166000','1166000','kasir','2026-06-22 09:40:24','F22622094024');
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-22','F226220940241','2026-06-22','09:40:25','LUS','1166000','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-260622-0004','D','2026-06-22','09:40:25','kasir','PENJUALAN','F226220940241','11073891000','1166000','11075057000');
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 ('F226220952201','kasir','1',' TGH1 X UB ','TOKO','TBK-H','H1TG-WLAA-144-T','KL X MILANO SEMI UB 50CM ','','15.050','1','100.00','30702000','0','0','15000','30792000','0','0','0','30792000','TIN','T0051687','H1TG','0','0','-','0','2040000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TG-WLAA-144-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'15.050',berat_jual_asli=berat_jual_asli+'15.050',stock_jual='1',berat_akhir=berat_akhir-'15.050',berat_akhir_asli=berat_akhir_asli-'15.050',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='H1TG-WLAA-144-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226220952201','2026-06-22','15.050','2026-06-22','09:52:21','PLG0081270','30792000','30792000','0','30792000','30792000','kasir','2026-06-22 09:52:20','F22622095220');
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-22','F226220952201','2026-06-22','09:52:21','TIN','30792000','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-260622-0005','D','2026-06-22','09:52:21','kasir','PENJUALAN','F226220952201','11075057000','30792000','11105849000');
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 ('F226221008541','kasir','1',' MFB1F LG ','TOKO','SMBK-B','B1F-ZFXE-98-T','GW DAISY MATA SLEP LG 8K ','OL','0.370','1','100.00','413000','0','0','15000','418000','0','5000','0','423000','LUS','T0080400','B1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZFXE-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1F-ZFXE-98-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 ('F226221008541','2026-06-22','0.370','2026-06-22','10:08:54','PLG0081271','418000','418000','5000','423000','423000','kasir','2026-06-22 10:08:54','F22622100854');
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-22','F226221008541','2026-06-22','10:08:54','LUS','423000','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-260622-0006','D','2026-06-22','10:08:54','kasir','PENJUALAN','F226221008541','11105849000','423000','11106272000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='423000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221008541' 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 ('F226221008542','kasir',' 1',' MFB1F LG ','TOKO','SMBK-B','B1F-ZFXE-97-T','GW DAISY MATA SLEP LG 8K ','OL','0.380','1','100.00','424000','0','0','15000','430000','0','5000','0','435000','LUS','T0080399','B1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZFXE-97-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1F-ZFXE-97-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 ('F226221008542','2026-06-22','0.380','2026-06-22','10:08:54','PLG0081272','430000','430000','5000','435000','435000','kasir','2026-06-22 10:08:54','F22622100854');
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-22','F226221008542','2026-06-22','10:08:54','LUS','435000','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-260622-0007','D','2026-06-22','10:08:54','kasir','PENJUALAN','F226221008542','11106272000','435000','11106707000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='435000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221008542' 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 ('F226221008543','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFXD-74-T','CC MODEL ISYANA SLEP LG 12 8K ','OL','0.510','1','100.00','558000','0','0','15000','566000','0','5000','0','571000','LUS','T0080239','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXD-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZFXD-74-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 ('F226221008543','2026-06-22','0.510','2026-06-22','10:08:54','PLG0081273','566000','566000','5000','571000','571000','kasir','2026-06-22 10:08:54','F22622100854');
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-22','F226221008543','2026-06-22','10:08:54','LUS','571000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260622-0008','D','2026-06-22','10:08:54','kasir','PENJUALAN','F226221008543','11106707000','571000','11107278000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='571000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221008543' 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 ('F226221008544','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFXE-57-T','CC MDOEL SLEP LG 14 8K ','OL','0.520','1','100.00','569000','0','0','15000','577000','0','5000','0','582000','LUS','T0080359','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXE-57-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-22' AND kode_barang='E1E-ZFXE-57-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 ('F226221008544','2026-06-22','0.520','2026-06-22','10:08:54','PLG0081274','577000','577000','5000','582000','582000','kasir','2026-06-22 10:08:54','F22622100854');
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-22','F226221008544','2026-06-22','10:08:54','LUS','582000','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-260622-0009','D','2026-06-22','10:08:54','kasir','PENJUALAN','F226221008544','11107278000','582000','11107860000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='582000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221008544' 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 ('F226221011071','kasir','1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFAI-102-T','GW TUSUK HATI SLEP CM 8K ','OL','0.210','1','100.00','238000','0','0','15000','242000','0','5000','0','247000','LUS','T0080602','B1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFAI-102-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.210',berat_jual_asli=berat_jual_asli+'0.210',stock_jual='1',berat_akhir=berat_akhir-'0.210',berat_akhir_asli=berat_akhir_asli-'0.210',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1G-ZFAI-102-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 ('F226221011071','2026-06-22','0.210','2026-06-22','10:11:07','PLG0081275','242000','242000','5000','247000','247000','kasir','2026-06-22 10:11:07','F22622101107');
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-22','F226221011071','2026-06-22','10:11:07','LUS','247000','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-260622-0010','D','2026-06-22','10:11:07','kasir','PENJUALAN','F226221011071','11107860000','247000','11108107000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='247000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221011071' 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 ('F226221011072','kasir',' 1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFAI-98-T','GW TUSUK MATA SLEP CM 8K ','OL','0.230','1','100.00','261000','0','0','15000','265000','0','5000','0','270000','LUS','T0080598','B1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFAI-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.230',berat_jual_asli=berat_jual_asli+'0.230',stock_jual='1',berat_akhir=berat_akhir-'0.230',berat_akhir_asli=berat_akhir_asli-'0.230',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1G-ZFAI-98-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 ('F226221011072','2026-06-22','0.230','2026-06-22','10:11:07','PLG0081276','265000','265000','5000','270000','270000','kasir','2026-06-22 10:11:07','F22622101107');
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-22','F226221011072','2026-06-22','10:11:07','LUS','270000','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-260622-0011','D','2026-06-22','10:11:07','kasir','PENJUALAN','F226221011072','11108107000','270000','11108377000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='270000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221011072' 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 ('F226221011073','kasir',' 1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFAI-94-T','GW TUSUK MATA SLEP CM 8K ','OL','0.230','1','100.00','261000','0','0','15000','265000','0','5000','0','270000','LUS','T0080594','B1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFAI-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.230',berat_jual_asli=berat_jual_asli+'0.230',stock_jual='1',berat_akhir=berat_akhir-'0.230',berat_akhir_asli=berat_akhir_asli-'0.230',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1G-ZFAI-94-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 ('F226221011073','2026-06-22','0.230','2026-06-22','10:11:07','PLG0081277','265000','265000','5000','270000','270000','kasir','2026-06-22 10:11:07','F22622101107');
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-22','F226221011073','2026-06-22','10:11:07','LUS','270000','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-260622-0012','D','2026-06-22','10:11:07','kasir','PENJUALAN','F226221011073','11108377000','270000','11108647000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='270000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221011073' 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 ('F226221011074','kasir',' 1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFAI-96-T','GW TUSUK MATA SLEP CM 8K ','OL','0.230','1','100.00','261000','0','0','15000','265000','0','5000','0','270000','LUS','T0080596','B1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFAI-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.230',berat_jual_asli=berat_jual_asli+'0.230',stock_jual='1',berat_akhir=berat_akhir-'0.230',berat_akhir_asli=berat_akhir_asli-'0.230',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1G-ZFAI-96-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 ('F226221011074','2026-06-22','0.230','2026-06-22','10:11:07','PLG0081278','265000','265000','5000','270000','270000','kasir','2026-06-22 10:11:07','F22622101107');
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-22','F226221011074','2026-06-22','10:11:07','LUS','270000','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-260622-0013','D','2026-06-22','10:11:07','kasir','PENJUALAN','F226221011074','11108647000','270000','11108917000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='270000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221011074' 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 ('F226221011075','kasir',' 1',' MFB1F LG ','TOKO','SMBK-B','B1F-ZFAF-62-T','GW TUSUK MATA LG 8K ','OL','0.300','1','100.00','334000','0','0','15000','339000','0','5000','0','344000','LUS','T0080497','B1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZFAF-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1F-ZFAF-62-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 ('F226221011075','2026-06-22','0.300','2026-06-22','10:11:07','PLG0081279','339000','339000','5000','344000','344000','kasir','2026-06-22 10:11:07','F22622101107');
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-22','F226221011075','2026-06-22','10:11:07','LUS','344000','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-260622-0014','D','2026-06-22','10:11:07','kasir','PENJUALAN','F226221011075','11108917000','344000','11109261000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='344000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221011075' 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 ('F226221013061','kasir','1',' MED2E X LG','TOKO','SMBK-D','D2E-ZCAD-49-0','LT X MODEL MATA VAR LG 8K ','OL','0.480','1','100.00','526000','0','0','15000','533000','0','5000','0','538000','LUS','00394177','D2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZCAD-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='D2E-ZCAD-49-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 ('F226221013061','2026-06-22','0.480','2026-06-22','10:13:07','PLG0081280','533000','533000','5000','538000','538000','kasir','2026-06-22 10:13:06','F22622101306');
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-22','F226221013061','2026-06-22','10:13:07','LUS','538000','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-260622-0015','D','2026-06-22','10:13:07','kasir','PENJUALAN','F226221013061','11109261000','538000','11109799000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='538000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221013061' 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 ('F226221013062','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZFXD-1-T','KL SANTA VAR MATA SLEP KH 42 8K ','OL','2.860','1','100.00','3132000','0','0','15000','3161000','0','14000','0','3175000','LUS','T0080166','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.860',berat_jual_asli=berat_jual_asli+'2.860',stock_jual='1',berat_akhir=berat_akhir-'2.860',berat_akhir_asli=berat_akhir_asli-'2.860',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='H1E-ZFXD-1-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 ('F226221013062','2026-06-22','2.860','2026-06-22','10:13:07','PLG0081281','3161000','3161000','14000','3175000','3175000','kasir','2026-06-22 10:13:06','F22622101306');
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-22','F226221013062','2026-06-22','10:13:07','LUS','3175000','14000');
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-260622-0016','D','2026-06-22','10:13:07','kasir','PENJUALAN','F226221013062','11109799000','3175000','11112974000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3175000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221013062' 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 ('F226221013063','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFAI-91-T','GL SIEM COBRA SLEP UB 8K ','OL','0.700','1','100.00','766000','0','0','15000','777000','0','5000','0','782000','LUS','T0080591','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAI-91-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-22' AND kode_barang='F3E-ZFAI-91-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 ('F226221013063','2026-06-22','0.700','2026-06-22','10:13:07','PLG0081282','777000','777000','5000','782000','782000','kasir','2026-06-22 10:13:06','F22622101306');
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-22','F226221013063','2026-06-22','10:13:07','LUS','782000','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-260622-0017','D','2026-06-22','10:13:07','kasir','PENJUALAN','F226221013063','11112974000','782000','11113756000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='782000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221013063' 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 ('F226221013064','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFAI-92-T','GL SIEM COBRA SLEP UB 8K ','OL','0.700','1','100.00','766000','0','0','15000','777000','0','5000','0','782000','LUS','T0080592','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAI-92-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-22' AND kode_barang='F3E-ZFAI-92-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 ('F226221013064','2026-06-22','0.700','2026-06-22','10:13:07','PLG0081283','777000','777000','5000','782000','782000','kasir','2026-06-22 10:13:06','F22622101306');
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-22','F226221013064','2026-06-22','10:13:07','LUS','782000','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-260622-0018','D','2026-06-22','10:13:07','kasir','PENJUALAN','F226221013064','11113756000','782000','11114538000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='782000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221013064' 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 ('F226221013065','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFAI-93-T','GL SIEM COBRA SLEP UB 8K ','OL','0.700','1','100.00','766000','0','0','15000','777000','0','5000','0','782000','LUS','T0080593','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAI-93-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-22' AND kode_barang='F3E-ZFAI-93-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 ('F226221013065','2026-06-22','0.700','2026-06-22','10:13:07','PLG0081284','777000','777000','5000','782000','782000','kasir','2026-06-22 10:13:06','F22622101306');
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-22','F226221013065','2026-06-22','10:13:07','LUS','782000','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-260622-0019','D','2026-06-22','10:13:07','kasir','PENJUALAN','F226221013065','11114538000','782000','11115320000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='782000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221013065' 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 ('F226221016121','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZBAG-7-T','LT MODEL BOTEGA LG 8K ','','0.480','1','100.00','526000','0','0','15000','526000','0','0','0','526000','TIN','T0077449','D1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZBAG-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='D1E-ZBAG-7-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 ('F226221016121','2026-06-22','0.480','2026-06-22','10:16:12','PLG0081285','526000','526000','0','526000','0','kasir','2026-06-22 10:16:12','F22622101612');
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-22','F226221016121','2026-06-22','10:16:12','TIN','526000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260622-0001','2026-06-22','2026-06-22 10:16:12','PENJUALAN : F226221016121','0987654321','BCA','526000','526000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260622-0002','D','2026-06-22','10:16:12','BCA','PENJUALAN','F226221016121','4545951888','526000','4546477888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','ERNIS');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221016121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221016121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221016121';
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 ('F226221018241','kasir','1',' MDE1D LG 1','TOKO','SMBK-E','E1D-ZEBH-53-T','CC MODEL ISYANA SLEP LG 14 8K ','','1.000','1','100.00','1075000','0','0','15000','1075000','0','0','0','1075000','TIN','T0079994','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBH-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1D-ZEBH-53-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 ('F226221018241','2026-06-22','1.000','2026-06-22','10:18:25','PLG0081286','1075000','1075000','0','1075000','0','kasir','2026-06-22 10:18:24','F22622101824');
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-22','F226221018241','2026-06-22','10:18:25','TIN','1075000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260622-0002','2026-06-22','2026-06-22 10:18:24','PENJUALAN : F226221018241','0987654321','BCA','1075000','1075000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260622-0003','D','2026-06-22','10:18:25','BCA','PENJUALAN','F226221018241','4546477888','1075000','4547552888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','ERNIS');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221018241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221018241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221018241';
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 ('F226221022071','kasir','1',' MEB1 5K HW','TOKO','SMBK-B','B1E-ZFAF-1-T','GW TIFF PANJANG VAR CAT HITAM SLEP HW 8K','OL','0.510','1','100.00','558000','0','0','15000','565000','0','5000','0','570000','LUS','T0080436','B1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFAF-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1E-ZFAF-1-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 ('F226221022071','2026-06-22','0.510','2026-06-22','10:22:08','PLG0081287','565000','565000','5000','570000','570000','kasir','2026-06-22 10:22:07','F22622102207');
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-22','F226221022071','2026-06-22','10:22:08','LUS','570000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260622-0020','D','2026-06-22','10:22:08','kasir','PENJUALAN','F226221022071','11115320000','570000','11115890000');
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 ('F226221022451','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEAB-30-T','GL RANTAI HOLLOW DOUBLE UB 8K ','OL','2.010','1','100.00','2201000','0','0','15000','2211000','0','10000','0','2221000','LUS','T0079388','F3E','0','0','-','0','1095000');
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 ('F226221023241','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEAB-30-T','GL RANTAI HOLLOW DOUBLE UB 8K ','OL','2.010','1','100.00','2201000','0','0','15000','2211000','0','10000','0','2221000','LUS','T0079388','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAB-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='F3E-ZEAB-30-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 ('F226221023241','2026-06-22','2.010','2026-06-22','10:23:25','PLG0081289','2211000','2211000','10000','2221000','2221000','kasir','2026-06-22 10:23:24','F22622102324');
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-22','F226221023241','2026-06-22','10:23:25','LUS','2221000','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-260622-0021','D','2026-06-22','10:23:25','kasir','PENJUALAN','F226221023241','11115890000','2221000','11118111000');
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 ('F226221024241','kasir','1',' MEB1 X LG ','TOKO','SMBK-B','B1E-ZFAG-31-0','GW X MODEL MATA LG PE 8K ','OL','0.570','1','100.00','624000','0','0','15000','630000','0','5000','0','635000','LUS','00408854','B1E','0','0','-','0','1095000');
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 ('F226221024561','kasir','1',' MEB1 X LG ','TOKO','SMBK-B','B1E-ZFAG-31-0','GW X MODEL MATA LG PE 8K ','OL','0.570','1','100.00','624000','0','0','15000','630000','0','5000','0','635000','LUS','00408854','B1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFAG-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1E-ZFAG-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226221024561','2026-06-22','0.570','2026-06-22','10:24:56','PLG0081291','630000','630000','5000','635000','635000','kasir','2026-06-22 10:24:56','F22622102456');
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-22','F226221024561','2026-06-22','10:24:56','LUS','635000','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-260622-0022','D','2026-06-22','10:24:56','kasir','PENJUALAN','F226221024561','11118111000','635000','11118746000');
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 ('F226221025561','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFAI-34-T','CC MODEL DAUN SLEP LG 14 8K ','OL','0.480','1','100.00','526000','0','0','15000','530000','0','5000','0','535000','LUS','T0080534','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZFAI-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 ('F226221025561','2026-06-22','0.480','2026-06-22','10:25:56','PLG0081292','530000','530000','5000','535000','535000','kasir','2026-06-22 10:25:56','F22622102556');
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-22','F226221025561','2026-06-22','10:25:56','LUS','535000','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-260622-0023','D','2026-06-22','10:25:56','kasir','PENJUALAN','F226221025561','11118746000','535000','11119281000');
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-20260622-0001','1','F3E-ZEXA-9-0','1','1.930','1.930','TOKO','SBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZEXA-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZEXA-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-06-22 10:42:44' WHERE kode_barang='F3E-ZEXA-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZEXA-9-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-22 10:42:44','TOKO','SMBK-F','F3E','F3E-ZEXA-9-0','1','1.930','1.930','1','1.930','1.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZEXA-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZEXA-9-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260622-0001','2026-06-22','10:42','1.930','input','2026-06-22 10:42:43');
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 ('F226221119331','kasir','1',' TAE0 X DW ','TOKO','TBK-E','E0TA-WABX-98-T','CC X POLOS DW 22 ','','4.980','1','100.00','9462000','0','0','15000','9462000','0','0','0','9462000','TIN','T0041584','E0TA','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-WABX-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.980',berat_jual_asli=berat_jual_asli+'4.980',stock_jual='1',berat_akhir=berat_akhir-'4.980',berat_akhir_asli=berat_akhir_asli-'4.980',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E0TA-WABX-98-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 ('F226221119331','2026-06-22','4.980','2026-06-22','11:19:33','PLG0081293','9462000','9462000','0','9462000','9462000','kasir','2026-06-22 11:19:33','F22622111933');
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-22','F226221119331','2026-06-22','11:19:33','TIN','9462000','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-260622-0024','D','2026-06-22','11:19:33','kasir','PENJUALAN','F226221119331','11119281000','9462000','11128743000');
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 ('F226221130541','kasir','1',' MDE1D CM 1','TOKO','SMBK-E','E1D-ZFAI-30-T','CC VELG SLEP CM 16 8K ','OL','1.010','1','100.00','1086000','0','0','15000','1091000','0','5000','0','1096000','TIN','T0080530','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAI-30-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-22' AND kode_barang='E1D-ZFAI-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226221130541','2026-06-22','1.010','2026-06-22','11:30:54','PLG0081294','1091000','1091000','5000','1096000','1096000','kasir','2026-06-22 11:30:54','F22622113054');
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-22','F226221130541','2026-06-22','11:30:54','TIN','1096000','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-260622-0025','D','2026-06-22','11:30:54','kasir','PENJUALAN','F226221130541','11128743000','1096000','11129839000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1096000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221130541' 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 ('F226221130542','kasir',' 1',' MDE1D CM 1','TOKO','SMBK-E','E1D-ZFAI-29-T','CC VELG SLEP CM 14 8K ','OL','1.020','1','100.00','1096000','0','0','15000','1102000','0','5000','0','1107000','TIN','T0080529','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAI-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1D-ZFAI-29-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226221130542','2026-06-22','1.020','2026-06-22','11:30:54','PLG0081295','1102000','1102000','5000','1107000','1107000','kasir','2026-06-22 11:30:54','F22622113054');
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-22','F226221130542','2026-06-22','11:30:54','TIN','1107000','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-260622-0026','D','2026-06-22','11:30:54','kasir','PENJUALAN','F226221130542','11129839000','1107000','11130946000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1107000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221130542' 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 ('F226221134561','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-ZEXH-14-T','GW TUSUK DEASY MATA LG PE 8K ','OL','0.500','1','100.00','547000','0','0','15000','553000','0','5000','0','558000','LUS','T0079313','B1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEXH-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1E-ZEXH-14-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 ('F226221134561','2026-06-22','0.500','2026-06-22','11:34:57','PLG0081296','553000','553000','5000','558000','558000','kasir','2026-06-22 11:34:56','F22622113456');
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-22','F226221134561','2026-06-22','11:34:57','LUS','558000','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-260622-0027','D','2026-06-22','11:34:57','kasir','PENJUALAN','F226221134561','11130946000','558000','11131504000');
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 ('F226221141011','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZCBX-14-T','AT MODEL DEASY MATA LG 8K ','OL','0.510','1','100.00','558000','0','0','15000','564000','0','5000','0','569000','TIN','T0078224','A1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCBX-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='A1E-ZCBX-14-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 ('F226221141011','2026-06-22','0.510','2026-06-22','11:41:01','PLG0081297','564000','564000','5000','569000','569000','kasir','2026-06-22 11:41:01','F22622114101');
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-22','F226221141011','2026-06-22','11:41:01','TIN','569000','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-260622-0028','D','2026-06-22','11:41:01','kasir','PENJUALAN','F226221141011','11131504000','569000','11132073000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='569000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221141011' 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 ('F226221141012','kasir',' 1',' MDA1D CM ','TOKO','SMBK-A','A1D-ZFAI-72-T','AT KLIP DAUN SLEP CM 8K ','','0.950','1','100.00','1021000','0','0','15000','1031000','0','5000','0','1036000','TIN','T0080572','A1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFAI-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='A1D-ZFAI-72-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 ('F226221141012','2026-06-22','0.950','2026-06-22','11:41:01','PLG0081298','1031000','1031000','5000','1036000','1036000','kasir','2026-06-22 11:41:01','F22622114101');
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-22','F226221141012','2026-06-22','11:41:01','TIN','1036000','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-260622-0029','D','2026-06-22','11:41:01','kasir','PENJUALAN','F226221141012','11132073000','1036000','11133109000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1036000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221141012' 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 ('F226221141013','kasir',' 1',' MDA1D CM ','TOKO','SMBK-A','A1D-ZFAI-73-T','AT KLIP DAUN SLEP CM 8K ','OL','0.960','1','100.00','1032000','0','0','15000','1042000','0','5000','0','1047000','TIN','T0080573','A1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFAI-73-T' 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-22' AND kode_barang='A1D-ZFAI-73-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 ('F226221141013','2026-06-22','0.960','2026-06-22','11:41:01','PLG0081299','1042000','1042000','5000','1047000','1047000','kasir','2026-06-22 11:41:01','F22622114101');
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-22','F226221141013','2026-06-22','11:41:01','TIN','1047000','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-260622-0030','D','2026-06-22','11:41:01','kasir','PENJUALAN','F226221141013','11133109000','1047000','11134156000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1047000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221141013' 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 ('F226221141014','kasir',' 1',' MEB1 X CM ','TOKO','SMBK-B','B1E-ZFAG-32-0','GW X MODEL SLEP CM PE 8K ','OL','0.570','1','100.00','624000','0','0','15000','630000','0','5000','0','635000','TIN','00408855','B1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFAG-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1E-ZFAG-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226221141014','2026-06-22','0.570','2026-06-22','11:41:01','PLG0081300','630000','630000','5000','635000','635000','kasir','2026-06-22 11:41:01','F22622114101');
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-22','F226221141014','2026-06-22','11:41:01','TIN','635000','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-260622-0031','D','2026-06-22','11:41:01','kasir','PENJUALAN','F226221141014','11134156000','635000','11134791000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='635000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221141014' 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 ('F226221141015','kasir',' 1',' MED2E X LG','TOKO','SMBK-D','D2E-ZFAH-38-0','LT X MODEL MATA LG 8K ','OL','0.460','1','100.00','504000','0','0','15000','508000','0','5000','0','513000','TIN','00409045','D2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZFAH-38-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-22' AND kode_barang='D2E-ZFAH-38-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 ('F226221141015','2026-06-22','0.460','2026-06-22','11:41:01','PLG0081301','508000','508000','5000','513000','513000','kasir','2026-06-22 11:41:01','F22622114101');
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-22','F226221141015','2026-06-22','11:41:01','TIN','513000','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-260622-0032','D','2026-06-22','11:41:01','kasir','PENJUALAN','F226221141015','11134791000','513000','11135304000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='513000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221141015' 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 ('F226221141016','kasir',' 1',' MDD2D X CM','TOKO','SMBK-D','D2D-ZFAH-46-0','LT X MODEL MATA HITAM CM 8K ','OL','0.960','1','100.00','1032000','0','0','15000','1037000','0','10000','0','1047000','TIN','00409053','D2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZFAH-46-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-22' AND kode_barang='D2D-ZFAH-46-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 ('F226221141016','2026-06-22','0.960','2026-06-22','11:41:01','PLG0081302','1037000','1037000','10000','1047000','1047000','kasir','2026-06-22 11:41:01','F22622114101');
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-22','F226221141016','2026-06-22','11:41:01','TIN','1047000','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-260622-0033','D','2026-06-22','11:41:01','kasir','PENJUALAN','F226221141016','11135304000','1047000','11136351000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1047000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221141016' 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 ('F226221146251','kasir','1',' MEE1 X BM ','TOKO','SMBK-E','E1E-ZFAH-209-0','CC X MODEL SLEP BM 14 8K ','OL','0.430','1','100.00','471000','0','0','15000','475000','0','5000','0','480000','TIN','00409216','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAH-209-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZFAH-209-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 ('F226221146251','2026-06-22','0.430','2026-06-22','11:46:26','PLG0081303','475000','475000','5000','480000','480000','kasir','2026-06-22 11:46:25','F22622114625');
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-22','F226221146251','2026-06-22','11:46:26','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-260622-0034','D','2026-06-22','11:46:26','kasir','PENJUALAN','F226221146251','11136351000','480000','11136831000','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='F226221146251' 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 ('F226221146252','kasir',' 1',' MEE1 LG 14','TOKO','SMBK-E','E1E-ZFAF-33-T','CC MODEL DAUN SLEP 14 LG 8K ','OL','0.480','1','100.00','526000','0','0','15000','530000','0','5000','0','535000','TIN','T0080468','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAF-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZFAF-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 ('F226221146252','2026-06-22','0.480','2026-06-22','11:46:26','PLG0081304','530000','530000','5000','535000','535000','kasir','2026-06-22 11:46:25','F22622114625');
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-22','F226221146252','2026-06-22','11:46:26','TIN','535000','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-260622-0035','D','2026-06-22','11:46:26','kasir','PENJUALAN','F226221146252','11136831000','535000','11137366000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='535000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221146252' 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 ('F226221146253','kasir',' 1',' MEE1 LG 12','TOKO','SMBK-E','E1E-ZFAF-32-T','CC MODEL DAUN SLEP 12 LG 8K ','OL','0.500','1','100.00','547000','0','0','15000','553000','0','5000','0','558000','TIN','T0080467','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAF-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZFAF-32-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 ('F226221146253','2026-06-22','0.500','2026-06-22','11:46:26','PLG0081305','553000','553000','5000','558000','558000','kasir','2026-06-22 11:46:25','F22622114625');
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-22','F226221146253','2026-06-22','11:46:26','TIN','558000','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-260622-0036','D','2026-06-22','11:46:26','kasir','PENJUALAN','F226221146253','11137366000','558000','11137924000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='558000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221146253' 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 ('F226221146254','kasir',' 1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZFAF-30-T','CC MODEL DAUN SLEP 16 LG 8K','OL','0.500','1','100.00','547000','0','0','15000','553000','0','5000','0','558000','TIN','T0080465','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAF-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZFAF-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226221146254','2026-06-22','0.500','2026-06-22','11:46:26','PLG0081306','553000','553000','5000','558000','558000','kasir','2026-06-22 11:46:25','F22622114625');
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-22','F226221146254','2026-06-22','11:46:26','TIN','558000','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-260622-0037','D','2026-06-22','11:46:26','kasir','PENJUALAN','F226221146254','11137924000','558000','11138482000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='558000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221146254' 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 ('F226221146255','kasir',' 1',' MEE1 LG 22','TOKO','SMBK-E','E1E-ZFAF-28-T','CC MODEL DAUN SLEP 22 LG 8K','','0.560','1','100.00','613000','0','0','15000','619000','0','5000','0','624000','TIN','T0080463','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAF-28-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-22' AND kode_barang='E1E-ZFAF-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226221146255','2026-06-22','0.560','2026-06-22','11:46:26','PLG0081307','619000','619000','5000','624000','624000','kasir','2026-06-22 11:46:25','F22622114625');
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-22','F226221146255','2026-06-22','11:46:26','TIN','624000','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-260622-0038','D','2026-06-22','11:46:26','kasir','PENJUALAN','F226221146255','11138482000','624000','11139106000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='624000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221146255' 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 ('F226221146256','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZFXI-107-0','CC X SOLITAIRE MATA CM 16 8K ','OL','1.700','1','100.00','1827000','0','0','15000','1830000','0','15000','0','1845000','TIN','00408174','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXI-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E2D-ZFXI-107-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 ('F226221146256','2026-06-22','1.700','2026-06-22','11:46:26','PLG0081308','1830000','1830000','15000','1845000','1845000','kasir','2026-06-22 11:46:25','F22622114625');
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-22','F226221146256','2026-06-22','11:46:26','TIN','1845000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260622-0039','D','2026-06-22','11:46:26','kasir','PENJUALAN','F226221146256','11139106000','1845000','11140951000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1845000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221146256' 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 ('F226221148081','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFAF-12-T','GL MODEL SIEM SLEP UB 8K ','OL','0.580','1','100.00','635000','0','0','15000','641000','0','5000','0','646000','TIN','T0080447','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAF-12-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-22' AND kode_barang='F3E-ZFAF-12-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 ('F226221148081','2026-06-22','0.580','2026-06-22','11:48:09','PLG0081309','641000','641000','5000','646000','646000','kasir','2026-06-22 11:48:08','F22622114808');
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-22','F226221148081','2026-06-22','11:48:09','TIN','646000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260622-0040','D','2026-06-22','11:48:09','kasir','PENJUALAN','F226221148081','11140951000','646000','11141597000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='646000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221148081' 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 ('F226221148082','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZFXD-4-T','KL LONG LING SLEP UB 44 8K ','OL','2.000','1','100.00','2190000','0','0','15000','2200000','0','10000','0','2210000','TIN','T0080169','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-4-T' 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-22' AND kode_barang='H1E-ZFXD-4-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 ('F226221148082','2026-06-22','2.000','2026-06-22','11:48:09','PLG0081310','2200000','2200000','10000','2210000','2210000','kasir','2026-06-22 11:48:08','F22622114808');
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-22','F226221148082','2026-06-22','11:48:09','TIN','2210000','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-260622-0041','D','2026-06-22','11:48:09','kasir','PENJUALAN','F226221148082','11141597000','2210000','11143807000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2210000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226221148082' 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 ('F226221149041','kasir','1',' MED2D CM 1','TOKO','SMBK-E','E2D-ZFAI-45-T','CC MODEL WEDDING MATA SLEP CM 10 8K ','OL','1.010','1','100.00','1086000','0','0','15000','1111000','0','5000','0','1116000','TIN','T0080545','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAI-45-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-22' AND kode_barang='E2D-ZFAI-45-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 ('F226221149041','2026-06-22','1.010','2026-06-22','11:49:05','PLG0081311','1111000','1111000','5000','1116000','1116000','kasir','2026-06-22 11:49:04','F22622114904');
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-22','F226221149041','2026-06-22','11:49:05','TIN','1116000','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-260622-0042','D','2026-06-22','11:49:05','kasir','PENJUALAN','F226221149041','11143807000','1116000','11144923000');
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 ('F226221210151','kasir','1',' MEF3 10K L','TOKO','SMBK-F','F3E-ZEXA-9-0','GL MODEL MEDAN PASIR VAR LG 8K ','OLS K7PVM','1.930','1','100.00','2094000','0','0','15000','2025000','0','25000','0','2050000','TIN','00401906','F3E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXA-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='F3E-ZEXA-9-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 ('F226221210151','2026-06-22','1.930','2026-06-22','12:10:15','PLG0081312','2025000','2025000','25000','2050000','2050000','kasir','2026-06-22 12:10:15','F22622121015');
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-22','F226221210151','2026-06-22','12:10:15','TIN','2050000','25000');
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-260622-0043','D','2026-06-22','12:10:15','kasir','PENJUALAN','F226221210151','11144923000','2050000','11146973000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221210151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221210151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221210151';
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 ('F226221215071','kasir','1',' MEF3 10K L','TOKO','SMBK-F','F3E-ZEXA-9-0','GL MODEL MEDAN PASIR VAR LG 8K ','OLS K7PVM','1.930','1','100.00','2094000','0','0','15000','2025000','0','25000','0','2050000','TIN','00401906','F3E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXA-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='F3E-ZEXA-9-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 ('F226221215071','2026-06-22','1.930','2026-06-22','12:15:08','PLG0081313','2025000','2025000','25000','2050000','0','kasir','2026-06-22 12:15:07','F22622121507');
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-22','F226221215071','2026-06-22','12:15:08','TIN','2050000','25000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260622-0003','2026-06-22','2026-06-22 12:15:07','PENJUALAN : F226221215071','0987654321','BCA','2050000','2050000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260622-0004','D','2026-06-22','12:15:08','BCA','PENJUALAN','F226221215071','4547552888','2050000','4549602888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','ARDINA');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221215071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221215071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221215071';
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 ('F226220109561','kasir','1',' TDE2 10K C','TOKO','TBK-E','E2TD-ZFXE-109-T','CC WEDIING MATA SLEP CM 10 17K ','OL','1.550','1','100.00','3069000','0','0','15000','3074000','0','11000','0','3085000','LUS','T0080411','E2TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZFXE-109-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E2TD-ZFXE-109-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 ('F226220109561','2026-06-22','1.550','2026-06-22','13:09:57','PLG0081314','3074000','3074000','11000','3085000','3085000','kasir','2026-06-22 13:09:56','F22622010956');
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-22','F226220109561','2026-06-22','13:09:57','LUS','3085000','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-260622-0045','D','2026-06-22','13:09:57','kasir','PENJUALAN','F226220109561','11144923000','3085000','11148008000');
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 ('F226220140001','kasir','1',' MEE1 CM 14','TOKO','SMBK-E','E1E-ZDBE-33-T','CC MODEL BUNGA CLOVER CAT CM 14 8K ','OL','0.430','1','100.00','471000','0','0','15000','475000','0','5000','0','480000','TIN','T0079002','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBE-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZDBE-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 ('F226220140001','2026-06-22','0.430','2026-06-22','13:40:00','PLG0081315','475000','475000','5000','480000','480000','kasir','2026-06-22 13:40:00','F22622014000');
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-22','F226220140001','2026-06-22','13:40:00','TIN','480000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260622-0046','D','2026-06-22','13:40:00','kasir','PENJUALAN','F226220140001','11148008000','480000','11148488000','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='F226220140001' 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 ('F226220140002','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFAI-40-T','CC MODEL ISYANA SLEP LG 18 8K ','OL','0.530','1','100.00','580000','0','0','15000','586000','0','5000','0','591000','TIN','T0080540','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-40-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-22' AND kode_barang='E1E-ZFAI-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 ('F226220140002','2026-06-22','0.530','2026-06-22','13:40:00','PLG0081316','586000','586000','5000','591000','591000','kasir','2026-06-22 13:40:00','F22622014000');
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-22','F226220140002','2026-06-22','13:40:00','TIN','591000','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-260622-0047','D','2026-06-22','13:40:00','kasir','PENJUALAN','F226220140002','11148488000','591000','11149079000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='591000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220140002' 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 ('F226220140003','kasir',' 1',' MEE1E HT 1','TOKO','SMBK-E','E1E-ZFAI-14-T','CC MODEL BANGKOK SLEP HT 16 8K ','OL','0.670','1','100.00','734000','0','0','15000','740000','0','5000','0','745000','TIN','T0080514','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-14-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-22' AND kode_barang='E1E-ZFAI-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226220140003','2026-06-22','0.670','2026-06-22','13:40:00','PLG0081317','740000','740000','5000','745000','745000','kasir','2026-06-22 13:40:00','F22622014000');
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-22','F226220140003','2026-06-22','13:40:00','TIN','745000','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-260622-0048','D','2026-06-22','13:40:00','kasir','PENJUALAN','F226220140003','11149079000','745000','11149824000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='745000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220140003' 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 ('F226220140004','kasir',' 1',' MEH1 X YT ','TOKO','SMBK-H','H1E-ZFAG-96-0','KL X NORY SPECTRA VAR YT 8K ','','2.530','1','100.00','2770000','0','0','15000','2783000','0','13000','0','2796000','TIN','00408919','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAG-96-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='H1E-ZFAG-96-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 ('F226220140004','2026-06-22','2.530','2026-06-22','13:40:00','PLG0081318','2783000','2783000','13000','2796000','2796000','kasir','2026-06-22 13:40:00','F22622014000');
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-22','F226220140004','2026-06-22','13:40:00','TIN','2796000','13000');
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-260622-0049','D','2026-06-22','13:40:00','kasir','PENJUALAN','F226220140004','11149824000','2796000','11152620000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2796000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220140004' 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 ('F226220141021','kasir','1',' MEF1E PM 5','TOKO','SMBK-F','F1E-ZEBH-77-T','GL OVAL DAUN SELEP PM 54 8K ','OL','3.070','1','100.00','3362000','0','0','15000','3377000','0','15000','0','3392000','TIN','T0080018','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBH-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='F1E-ZEBH-77-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226220141021','2026-06-22','3.070','2026-06-22','13:41:03','PLG0081319','3377000','3377000','15000','3392000','3392000','kasir','2026-06-22 13:41:02','F22622014102');
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-22','F226220141021','2026-06-22','13:41:03','TIN','3392000','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-260622-0050','D','2026-06-22','13:41:03','kasir','PENJUALAN','F226220141021','11152620000','3392000','11156012000');
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 ('F226220208321','kasir','1',' MDE1 10K C','TOKO','SMBK-E','E1D-ZEBX-40-T','CC WEDDING MATA SLEP CM 12 8K ','','1.500','1','100.00','1612000','0','0','15000','1613000','0','10000','0','1623000','LUS','T0079631','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBX-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1D-ZEBX-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 ('F226220208321','2026-06-22','1.500','2026-06-22','14:08:32','PLG0081320','1613000','1613000','10000','1623000','1623000','kasir','2026-06-22 14:08:32','F22622020832');
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-22','F226220208321','2026-06-22','14:08:32','LUS','1623000','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-260622-0051','D','2026-06-22','14:08:32','kasir','PENJUALAN','F226220208321','11156012000','1623000','11157635000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1623000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220208321' 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 ('F226220208322','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZFXD-90-T','CC WEDDING MATA SLEP CM 10 8K ','','1.600','1','100.00','1720000','0','0','15000','1720000','0','10000','0','1730000','LUS','T0080255','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXD-90-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-22' AND kode_barang='E2D-ZFXD-90-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 ('F226220208322','2026-06-22','1.600','2026-06-22','14:08:32','PLG0081321','1720000','1720000','10000','1730000','1730000','kasir','2026-06-22 14:08:32','F22622020832');
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-22','F226220208322','2026-06-22','14:08:32','LUS','1730000','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-260622-0052','D','2026-06-22','14:08:32','kasir','PENJUALAN','F226220208322','11157635000','1730000','11159365000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1730000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220208322' 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 ('F226220232201','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZFAI-62-T','LT CHARM SLOBOK VAR SLEP BG 8K ','OL','0.520','1','100.00','580000','0','0','15000','585000','0','5000','0','590000','TIN','T0080562','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFAI-62-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-22' AND kode_barang='D1F-ZFAI-62-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 ('F226220232201','2026-06-22','0.520','2026-06-22','14:32:20','PLG0081322','585000','585000','5000','590000','590000','kasir','2026-06-22 14:32:20','F22622023220');
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-22','F226220232201','2026-06-22','14:32:20','TIN','590000','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-260622-0053','D','2026-06-22','14:32:20','kasir','PENJUALAN','F226220232201','11159365000','590000','11159955000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='590000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220232201' 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 ('F226220232202','kasir',' 1',' MHB1 CM ','TOKO','SMBK-B','B1H-ZDBE-15-T','GW TUSUK DAISY MATA CM 8K ','OL','0.270','1','100.00','312000','0','0','15000','315000','0','5000','0','320000','TIN','T0078984','B1H','0','0','-','0','1155000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZDBE-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1H-ZDBE-15-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 ('F226220232202','2026-06-22','0.270','2026-06-22','14:32:20','PLG0081323','315000','315000','5000','320000','320000','kasir','2026-06-22 14:32:20','F22622023220');
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-22','F226220232202','2026-06-22','14:32:20','TIN','320000','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-260622-0054','D','2026-06-22','14:32:20','kasir','PENJUALAN','F226220232202','11159955000','320000','11160275000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='320000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220232202' 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 ('F226220232203','kasir',' 1',' MDE2 CM 20','TOKO','SMBK-E','E2D-ZFXF-11-T','CC WEDDING MATA 20 CM 8K ','OL','0.960','1','100.00','1032000','0','0','15000','1042000','0','5000','0','1047000','TIN','T0080434','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXF-11-T' 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-22' AND kode_barang='E2D-ZFXF-11-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 ('F226220232203','2026-06-22','0.960','2026-06-22','14:32:20','PLG0081324','1042000','1042000','5000','1047000','1047000','kasir','2026-06-22 14:32:20','F22622023220');
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-22','F226220232203','2026-06-22','14:32:20','TIN','1047000','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-260622-0055','D','2026-06-22','14:32:20','kasir','PENJUALAN','F226220232203','11160275000','1047000','11161322000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1047000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220232203' 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 ('F226220232441','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZFAH-187-0','CC X MODEL MATA CM 16 8K ','OL','1.080','1','100.00','1161000','0','0','15000','1167000','0','5000','0','1172000','TIN','00409194','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAH-187-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E2D-ZFAH-187-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226220232441','2026-06-22','1.080','2026-06-22','14:32:45','PLG0081325','1167000','1167000','5000','1172000','1172000','kasir','2026-06-22 14:32:44','F22622023244');
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-22','F226220232441','2026-06-22','14:32:45','TIN','1172000','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-260622-0056','D','2026-06-22','14:32:45','kasir','PENJUALAN','F226220232441','11161322000','1172000','11162494000');
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 ('F226220247011','kasir','1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZEBX-11-T','LT MODEL CHARM PITA SLEP LG 8K ','','0.330','1','100.00','368000','0','0','15000','368000','0','0','0','368000','LUS','T0079602','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEBX-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='D1F-ZEBX-11-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 ('F226220247011','2026-06-22','0.330','2026-06-22','14:47:02','PLG0081326','368000','368000','0','368000','368000','kasir','2026-06-22 14:47:01','F22622024701');
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-22','F226220247011','2026-06-22','14:47:02','LUS','368000','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-260622-0057','D','2026-06-22','14:47:02','kasir','PENJUALAN','F226220247011','11162494000','368000','11162862000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='368000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220247011' 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 ('F226220247012','kasir',' 1',' MFD1F LG ','TOKO','SMBK-D','D1F-ZEBX-10-T','LT MODEL CHARM PITA SLEP LG 8K ','','0.350','1','100.00','390000','0','0','15000','390000','0','0','0','390000','LUS','T0079601','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEBX-10-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-22' AND kode_barang='D1F-ZEBX-10-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 ('F226220247012','2026-06-22','0.350','2026-06-22','14:47:02','PLG0081327','390000','390000','0','390000','390000','kasir','2026-06-22 14:47:01','F22622024701');
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-22','F226220247012','2026-06-22','14:47:02','LUS','390000','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-260622-0058','D','2026-06-22','14:47:02','kasir','PENJUALAN','F226220247012','11162862000','390000','11163252000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='390000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220247012' 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 ('F226220247013','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFAI-32-T','CC MODEL DAUN SLEP LG 12 8K ','','0.470','1','100.00','515000','0','0','15000','515000','0','0','0','515000','LUS','T0080532','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='E1E-ZFAI-32-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 ('F226220247013','2026-06-22','0.470','2026-06-22','14:47:02','PLG0081328','515000','515000','0','515000','515000','kasir','2026-06-22 14:47:01','F22622024701');
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-22','F226220247013','2026-06-22','14:47:02','LUS','515000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260622-0059','D','2026-06-22','14:47:02','kasir','PENJUALAN','F226220247013','11163252000','515000','11163767000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='515000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220247013' 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 ('F226220258411','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZFXD-135-T','KL KOREA UB 44 8K ','OL','1.450','1','100.00','1588000','0','0','15000','1595000','0','7000','0','1602000','TIN','T0080300','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-135-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='H1E-ZFXD-135-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 ('F226220258411','2026-06-22','1.450','2026-06-22','14:58:41','PLG0081329','1595000','1595000','7000','1602000','1602000','kasir','2026-06-22 14:58:41','F22622025841');
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-22','F226220258411','2026-06-22','14:58:41','TIN','1602000','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-260622-0060','D','2026-06-22','14:58:41','kasir','PENJUALAN','F226220258411','11163767000','1602000','11165369000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220258411' 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 ('F226220258412','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFXD-41-T','GL LONG LING SLEP UB 8K ','OL','1.000','1','100.00','1095000','0','0','15000','1100000','0','5000','0','1105000','TIN','T0080206','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='F3E-ZFXD-41-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 ('F226220258412','2026-06-22','1.000','2026-06-22','14:58:41','PLG0081330','1100000','1100000','5000','1105000','1105000','kasir','2026-06-22 14:58:41','F22622025841');
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-22','F226220258412','2026-06-22','14:58:41','TIN','1105000','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-260622-0061','D','2026-06-22','14:58:41','kasir','PENJUALAN','F226220258412','11165369000','1105000','11166474000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1105000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220258412' 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 ('F226220258413','kasir',' 1',' MDA1 CM ','TOKO','SMBK-A','A1D-ZBAI-68-T','AT MODEL MATA VAR CM 8K ','OL','0.900','1','100.00','967000','0','0','15000','977000','0','5000','0','982000','TIN','T0077600','A1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZBAI-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='A1D-ZBAI-68-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 ('F226220258413','2026-06-22','0.900','2026-06-22','14:58:41','PLG0081331','977000','977000','5000','982000','982000','kasir','2026-06-22 14:58:41','F22622025841');
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-22','F226220258413','2026-06-22','14:58:41','TIN','982000','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-260622-0062','D','2026-06-22','14:58:41','kasir','PENJUALAN','F226220258413','11166474000','982000','11167456000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='982000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220258413' 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 ('F226220306571','kasir','1',' MEA1E X PM','TOKO','SMBK-A','A1E-ZFAG-9-0','AT X ITALY SLEP VAR PM 8K ','OL','0.550','1','100.00','602000','0','0','15000','608000','0','5000','0','613000','LUS','00408832','A1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFAG-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='A1E-ZFAG-9-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 ('F226220306571','2026-06-22','0.550','2026-06-22','15:06:58','PLG0081332','608000','608000','5000','613000','613000','kasir','2026-06-22 15:06:57','F22622030657');
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-22','F226220306571','2026-06-22','15:06:58','LUS','613000','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-260622-0063','D','2026-06-22','15:06:58','kasir','PENJUALAN','F226220306571','11167456000','613000','11168069000');
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 ('F226220311081','kasir','1',' MGA1 LG ','TOKO','SMBK-A','A1G-ZEXA-17-T','AT TINDIK BABY MRICAN LG 8K ','','0.300','1','100.00','340000','0','0','15000','340000','0','0','0','340000','LUS','T0079129','A1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZEXA-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='A1G-ZEXA-17-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 ('F226220311081','2026-06-22','0.300','2026-06-22','15:11:09','PLG0081333','340000','340000','0','340000','340000','kasir','2026-06-22 15:11:08','F22622031108');
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-22','F226220311081','2026-06-22','15:11:09','LUS','340000','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-260622-0064','D','2026-06-22','15:11:09','kasir','PENJUALAN','F226220311081','11168069000','340000','11168409000');
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 ('F226220353241','kasir','1',' MEF3 10K L','TOKO','SMBK-F','F3E-ZEXA-9-0','GL MODEL MEDAN PASIR VAR LG 8K ','OLS K7PVM','1.930','1','100.00','2094000','0','0','15000','2025000','0','65000','0','2090000','TIN','00401906','F3E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXA-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='F3E-ZEXA-9-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 ('F226220353241','2026-06-22','1.930','2026-06-22','15:53:25','PLG0081334','2025000','2025000','65000','2090000','0','kasir','2026-06-22 15:53:24','F22622035324');
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-22','F226220353241','2026-06-22','15:53:25','TIN','2090000','65000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260622-0004','2026-06-22','2026-06-22 15:53:24','PENJUALAN : F226220353241','0987654321','BCA','2090000','2090000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260622-0005','D','2026-06-22','15:53:25','BCA','PENJUALAN','F226220353241','4549602888','2090000','4551692888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','ARDINA');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220353241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220353241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220353241';
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-00005466','X-00005466','KL ITALY HW 42CM 17K','GR','---','H1TF','BELI','BELI001','20500000','2026-06-22','10.080','1','admin','2026-06-22 16:00:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TF','X-00005466','X-00005466');
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-260622-0001','F226180351471','TIN','1','BELI','BELI001','H1TF', 'X-00005466', 'KL ITALY HW 42CM 17K','10.080','10.080','100.00','20624000','20500000','2033730','2020000','1','20500000','20500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'10.080',berat_beli_asli=berat_beli_asli+'10.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'10.080',berat_akhir_asli=berat_akhir_asli+'10.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TF' 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-260622-0001','2026-06-22','2026-06-22','16:00:06','TIN','---','10.080','20500000','20500000','20500000','20500000','20500000','admin','2026-06-22 16:00:07','FB-260622-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0001','MURYANI','NAMBAK BUNGKAL','','','','admin','2026-06-22 16:00:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260622-0065','K','2026-06-22','16:00:06','admin','PEMBELIAN UMUM','FB-260622-0001','11168409000','20500000','11147909000');
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-00005467','X-00005467','GW TUSUK BUNGA PASIR VAR CM PE 8K','GR','---','B1E','BELI','BELI001','689000','2026-06-22','0.700','1','admin','2026-06-22 16:00:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00005467','X-00005467');
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-260622-0002','F226160205061','TIN','2','BELI','BELI001','B1E', 'X-00005467', 'GW TUSUK BUNGA PASIR VAR CM PE 8K','0.700','0.700','100.00','784000','689000','984286','1095000','1','689000','689000','CUCI');
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-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-260622-0002','2026-06-22','2026-06-22','16:00:06','TIN','---','0.700','689000','689000','689000','689000','689000','admin','2026-06-22 16:00:07','FB-260622-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0002','ANA','KARANGLO KIDUL','','','08214657718','admin','2026-06-22 16:00:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260622-0066','K','2026-06-22','16:00:06','admin','PEMBELIAN UMUM','FB-260622-0002','11147909000','689000','11147220000');
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-00005468','X-00005468','GL TRIXIE SERUT BUNGA CLOVER MATA','GR','---','F3F','BELI','BELI001','985000','2026-06-22','1.280','1','admin','2026-06-22 16:02:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00005468','X-00005468');
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-260622-0003','F223210312471','TIN','1','BELI','BELI001','F3F', 'X-00005468', 'GL TRIXIE SERUT BUNGA CLOVER MATA','1.910','1.280','100.00','875000','985000','769531','1115000','1','985000','985000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.280',berat_beli_asli=berat_beli_asli+'1.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.280',berat_akhir_asli=berat_akhir_asli+'1.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-22' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-260622-0003','2026-06-22','2026-06-22','16:02:00','TIN','---','1.280','985000','985000','985000','985000','985000','admin','2026-06-22 16:02:01','FB-260622-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260622-0003','IIN','KARANGAN BALONG','','','','admin','2026-06-22 16:02:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260622-0067','K','2026-06-22','16:02:00','admin','PEMBELIAN UMUM','FB-260622-0003','11147220000','985000','11146235000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220109561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220109561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220109561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220140001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220140001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220140001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220140002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220140002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220140002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220140003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220140003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220140003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220140004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220140004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220140004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220141021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220141021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220141021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220208321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220208321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220208321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220208322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220208322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220208322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220232201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220232201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220232201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220232202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220232202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220232202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220232203' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220232203' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220232203';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220232441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220232441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220232441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220247011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220247011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220247011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220247012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220247012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220247012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220247013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220247013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220247013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220258411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220258411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220258411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220258412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220258412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220258412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220258413' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220258413' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220258413';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220306571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220306571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220306571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220311081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220311081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220311081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220927191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220927191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220927191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220928411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220928411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220928411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220940241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220940241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220940241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220952201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220952201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220952201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221008541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221008541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221008541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221008542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221008542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221008542';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221008543' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221008543' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221008543';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221008544' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221008544' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221008544';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221011071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221011072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011073' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011073' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221011073';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011074' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011074' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221011074';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011075' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221011075' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221011075';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221013061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221013062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013063' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013063' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221013063';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013064' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013064' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221013064';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013065' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221013065' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221013065';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221022071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221022071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221022071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221023241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221023241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221023241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221024561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221024561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221024561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221025561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221025561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221025561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221119331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221119331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221119331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221130541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221130541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221130541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221130542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221130542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221130542';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221134561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221134561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221134561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221141011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221141012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221141013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221141014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221141015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221141016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221141016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221146251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221146252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146253' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146253' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221146253';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146254' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146254' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221146254';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146255' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146255' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221146255';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146256' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221146256' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221146256';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221148081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221148081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221148081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221148082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221148082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221148082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226221149041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226221149041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226221149041';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260622-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260622-0003';
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 ('F226220407291','kasir','1',' TEH1 X HW ','TOKO','TBK-H','H1TE-YLAB-20-T','KL X GUCI 42 HW 17K ','','2.100','1','100.00','4200000','0','0','15000','4200000','0','0','0','4200000','LUS','T0075726','H1TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-YLAB-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='H1TE-YLAB-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226220407291','2026-06-22','2.100','2026-06-22','16:07:30','PLG0081335','4200000','4200000','0','4200000','4200000','kasir','2026-06-22 16:07:29','F22622040729');
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-22','F226220407291','2026-06-22','16:07:30','LUS','4200000','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-260622-0068','D','2026-06-22','16:07:30','kasir','PENJUALAN','F226220407291','11146235000','4200000','11150435000');
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 ('F226220408541','kasir','1',' MEB1E LG P','TOKO','SMBK-B','B1E-ZFAF-65-T','GW MODEL PITA SLEP LG 8K','','0.510','1','100.00','558000','0','0','15000','558000','0','0','0','558000','LUS','T0080500','B1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFAF-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='B1E-ZFAF-65-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 ('F226220408541','2026-06-22','0.510','2026-06-22','16:08:55','PLG0081336','558000','558000','0','558000','558000','kasir','2026-06-22 16:08:54','F22622040854');
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-22','F226220408541','2026-06-22','16:08:55','LUS','558000','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-260622-0069','D','2026-06-22','16:08:55','kasir','PENJUALAN','F226220408541','11150435000','558000','11150993000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='558000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220408541' 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 ('F226220408542','kasir',' 1',' MFD1F X BG','TOKO','SMBK-D','D1F-ZDAH-17-0','LT X SLOBOK HURUF BALOK BG D 8K ','','0.550','1','100.00','613000','0','0','15000','613000','0','0','0','613000','LUS','00399718','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDAH-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='D1F-ZDAH-17-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 ('F226220408542','2026-06-22','0.550','2026-06-22','16:08:55','PLG0081337','613000','613000','0','613000','613000','kasir','2026-06-22 16:08:54','F22622040854');
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-22','F226220408542','2026-06-22','16:08:55','LUS','613000','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-260622-0070','D','2026-06-22','16:08:55','kasir','PENJUALAN','F226220408542','11150993000','613000','11151606000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220408542' 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 ('F226220408543','kasir',' 1',' MEF3E X PM','TOKO','SMBK-F','F3E-ZFAG-168-0','GL X KREPYAK DAUN SLEP PM 8K ','','4.060','1','100.00','4446000','0','0','15000','4446000','0','0','0','4446000','LUS','00408991','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAG-168-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.060',berat_jual_asli=berat_jual_asli+'4.060',stock_jual='1',berat_akhir=berat_akhir-'4.060',berat_akhir_asli=berat_akhir_asli-'4.060',stock_akhir='0' WHERE tanggal='2026-06-22' AND kode_barang='F3E-ZFAG-168-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 ('F226220408543','2026-06-22','4.060','2026-06-22','16:08:55','PLG0081338','4446000','4446000','0','4446000','4446000','kasir','2026-06-22 16:08:54','F22622040854');
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-22','F226220408543','2026-06-22','16:08:55','LUS','4446000','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-260622-0071','D','2026-06-22','16:08:55','kasir','PENJUALAN','F226220408543','11151606000','4446000','11156052000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4446000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226220408543' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220407291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220407291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220407291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220408541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220408541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220408541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220408542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220408542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220408542';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226220408543' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226220408543' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226220408543';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-23';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-22';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-22';
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-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-22' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260623-0001','D','2026-06-23','17:08:48','SYSTEM','SALDO AWAL','SALDO AWAL','0','11156052000','11156052000');
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-260623-0001','D','2026-06-23','17:08:48','BCA','SALDO AWAL','SALDO AWAL','0','4551692888','4551692888');
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-260623-0001','D','2026-06-23','17:08:48','','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-260623-0001','D','2026-06-23','17:08:48','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-260623-0001','D','2026-06-23','17:08:48','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-260623-0001','D','2026-06-23','17:08:48','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-06-23';