INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226090842001','kasir','1',' MDA1D UB ','TOKO','SMBK-A','A1D-ZFAI-77-T','AT HUGGIES BUNGA SLEP UB 8K ','OL','0.970','1','100.00','999000','0','0','15000','1009000','0','5000','0','1014000','TIN','T0080577','A1D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFAI-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='A1D-ZFAI-77-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 ('F226090842001','2026-07-09','0.970','2026-07-09','08:42:01','PLG0081985','1009000','1009000','5000','1014000','1014000','kasir','2026-07-09 08:42:00','F22609084200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090842001','2026-07-09','08:42:01','TIN','1014000','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-260709-0002','D','2026-07-09','08:42:01','kasir','PENJUALAN','F226090842001','11823591000','1014000','11824605000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1014000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226090842001' 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 ('F226090842002','kasir',' 1',' MEF3E X YT','TOKO','SMBK-F','F3E-ZFCX-215-0','GL X FLIK SPECTRA VAR YT 8K ','OL','1.680','1','100.00','1764000','0','0','15000','1773000','0','8000','0','1781000','TIN','00411422','F3E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFCX-215-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='F3E-ZFCX-215-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 ('F226090842002','2026-07-09','1.680','2026-07-09','08:42:01','PLG0081986','1773000','1773000','8000','1781000','1781000','kasir','2026-07-09 08:42:00','F22609084200');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090842002','2026-07-09','08:42:01','TIN','1781000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260709-0003','D','2026-07-09','08:42:01','kasir','PENJUALAN','F226090842002','11824605000','1781000','11826386000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1781000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226090842002' 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 ('F226090842481','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZFCX-214-0','GL X RANTAI HOLLOW SLEP VAR HW 8K ','OL','1.160','1','100.00','1218000','0','0','15000','1224000','0','6000','0','1230000','TIN','00411421','F3E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFCX-214-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='F3E-ZFCX-214-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 ('F226090842481','2026-07-09','1.160','2026-07-09','08:42:49','PLG0081987','1224000','1224000','6000','1230000','1230000','kasir','2026-07-09 08:42:48','F22609084248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090842481','2026-07-09','08:42:49','TIN','1230000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260709-0004','D','2026-07-09','08:42:49','kasir','PENJUALAN','F226090842481','11826386000','1230000','11827616000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226090847021','kasir','1',' MFD1F X LG','TOKO','SMBK-D','D1F-ZFCX-33-0','LT X SLOBOK KUPU SLEP LG 8K ','OL','0.310','1','100.00','332000','0','0','15000','335000','0','5000','0','340000','LUS','00411240','D1F','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFCX-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='D1F-ZFCX-33-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 ('F226090847021','2026-07-09','0.310','2026-07-09','08:47:02','PLG0081988','335000','335000','5000','340000','340000','kasir','2026-07-09 08:47:02','F22609084702');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090847021','2026-07-09','08:47:02','LUS','340000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260709-0005','D','2026-07-09','08:47:02','kasir','PENJUALAN','F226090847021','11827616000','340000','11827956000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226091042411','kasir','1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZEBE-185-0','KL X TIFF MATA VAR UB 8K ','','1.760','1','100.00','1848000','0','0','15000','1848000','0','0','0','1848000','RHM','00404884','H1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBE-185-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='H1E-ZEBE-185-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 ('F226091042411','2026-07-09','1.760','2026-07-09','10:42:41','PLG0081989','1848000','1848000','0','1848000','1848000','kasir','2026-07-09 10:42:41','F22609104241');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226091042411','2026-07-09','10:42:41','RHM','1848000','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-260709-0006','D','2026-07-09','10:42:41','kasir','PENJUALAN','F226091042411','11827956000','1848000','11829804000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226091133011','kasir','1',' MEF1E TD 6','TOKO','SMBK-F','F1E-ZEBX-52-T','GL OVAL C SLEP TD 6 8K ','OL','5.530','1','100.00','5806000','0','0','15000','5834000','0','28000','0','5862000','LUS','T0079643','F1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBX-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.530',berat_jual_asli=berat_jual_asli+'5.530',stock_jual='1',berat_akhir=berat_akhir-'5.530',berat_akhir_asli=berat_akhir_asli-'5.530',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='F1E-ZEBX-52-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226091133011','2026-07-09','5.530','2026-07-09','11:33:02','PLG0081990','5834000','5834000','28000','5862000','5862000','kasir','2026-07-09 11:33:01','F22609113301');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226091133011','2026-07-09','11:33:02','LUS','5862000','28000');
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-260709-0007','D','2026-07-09','11:33:02','kasir','PENJUALAN','F226091133011','11829804000','5862000','11835666000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226091228561','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZFXD-119-T','GL CASTELI BOLA ARESO VAR SLEP HW 8K ','','2.710','1','100.00','2845000','0','0','15000','2846000','0','0','0','2846000','TIN','T0080284','F3E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-119-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.710',berat_jual_asli=berat_jual_asli+'2.710',stock_jual='1',berat_akhir=berat_akhir-'2.710',berat_akhir_asli=berat_akhir_asli-'2.710',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='F3E-ZFXD-119-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 ('F226091228561','2026-07-09','2.710','2026-07-09','12:28:57','PLG0081991','2846000','2846000','0','2846000','2846000','kasir','2026-07-09 12:28:56','F22609122856');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226091228561','2026-07-09','12:28:57','TIN','2846000','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-260709-0008','D','2026-07-09','12:28:57','kasir','PENJUALAN','F226091228561','11835666000','2846000','11838512000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226090100001','kasir','1',' MEH1 KH ','TOKO','SMBK-H','H1E-ZDBX-31-T','KL SANTA MODEL HATI MATA VAR KH 8K ','OL','2.720','1','100.00','2856000','0','0','15000','2869000','0','14000','0','2883000','TIN','T0078766','H1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBX-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.720',berat_jual_asli=berat_jual_asli+'2.720',stock_jual='1',berat_akhir=berat_akhir-'2.720',berat_akhir_asli=berat_akhir_asli-'2.720',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='H1E-ZDBX-31-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 ('F226090100001','2026-07-09','2.720','2026-07-09','13:00:00','PLG0081992','2869000','2869000','14000','2883000','0','kasir','2026-07-09 13:00:00','F22609010000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090100001','2026-07-09','13:00:00','TIN','2883000','14000');
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-260709-0001','2026-07-09','2026-07-09 13:00:00','PENJUALAN : F226090100001','0987867564534','BCA','2883000','2883000','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-260709-0002','D','2026-07-09','13:00:00','BCA','PENJUALAN','F226090100001','4616219888','2883000','4619102888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987867564534','NUR ISTIQOMAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2883000' WHERE no_faktur_jual='F226090100001' 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 ('F226090126111','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZFAI-56-T','GL CAPELLA SPECTRA VAR SLEP HW 8K ','','2.270','1','100.00','2383000','0','0','15000','2384000','0','0','0','2384000','RHM','T0080556','F3E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAI-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='F3E-ZFAI-56-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 ('F226090126111','2026-07-09','2.270','2026-07-09','13:26:12','PLG0081993','2384000','2384000','0','2384000','2384000','kasir','2026-07-09 13:26:11','F22609012611');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090126111','2026-07-09','13:26:12','RHM','2384000','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-260709-0009','D','2026-07-09','13:26:12','kasir','PENJUALAN','F226090126111','11838512000','2384000','11840896000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226090130481','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZEBH-382-0','CC X MODEL MATA CM 18 8K ','OL','1.580','1','100.00','1627000','0','0','15000','1633000','0','10000','0','1643000','LUS','00405600','E2D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-382-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='E2D-ZEBH-382-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 ('F226090130481','2026-07-09','1.580','2026-07-09','13:30:49','PLG0081994','1633000','1633000','10000','1643000','1643000','kasir','2026-07-09 13:30:48','F22609013048');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090130481','2026-07-09','13:30:49','LUS','1643000','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-260709-0010','D','2026-07-09','13:30:49','kasir','PENJUALAN','F226090130481','11840896000','1643000','11842539000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226090136311','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBH-26-T','CC MODEL ISYANA SLEP LG 12 8K ','','0.430','1','100.00','451000','0','0','15000','452000','0','0','0','452000','RHM','T0079967','E1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-26-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-07-09' AND kode_barang='E1E-ZEBH-26-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 ('F226090136311','2026-07-09','0.430','2026-07-09','13:36:32','PLG0081995','452000','452000','0','452000','452000','kasir','2026-07-09 13:36:31','F22609013631');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090136311','2026-07-09','13:36:32','RHM','452000','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-260709-0011','D','2026-07-09','13:36:32','kasir','PENJUALAN','F226090136311','11842539000','452000','11842991000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='452000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226090136311' 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 ('F226090136312','kasir',' 1',' MFE1F X BM','TOKO','SMBK-E','E1F-ZGXA-139-0','CC X MODEL SPECTRA SLEP BM 14 8K ','','0.400','1','100.00','428000','0','0','15000','420000','0','0','0','420000','RHM','00411663','E1F','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGXA-139-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='E1F-ZGXA-139-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 ('F226090136312','2026-07-09','0.400','2026-07-09','13:36:32','PLG0081996','420000','420000','0','420000','420000','kasir','2026-07-09 13:36:31','F22609013631');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090136312','2026-07-09','13:36:32','RHM','420000','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-260709-0012','D','2026-07-09','13:36:32','kasir','PENJUALAN','F226090136312','11842991000','420000','11843411000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='420000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226090136312' 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 ('F226090217351','kasir','1',' MDD2 LG A ','TOKO','SMBK-D','D2D-YIBI-74-T','LT MODEL HURUF MATA LG A 8K ','OL','0.970','1','100.00','999000','0','0','15000','1010000','0','5000','0','1015000','LUS','T0073387','D2D','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YIBI-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='D2D-YIBI-74-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 ('F226090217351','2026-07-09','0.970','2026-07-09','14:17:36','PLG0081997','1010000','1010000','5000','1015000','1015000','kasir','2026-07-09 14:17:35','F22609021735');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090217351','2026-07-09','14:17:36','LUS','1015000','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-260709-0013','D','2026-07-09','14:17:36','kasir','PENJUALAN','F226090217351','11843411000','1015000','11844426000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1015000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226090217351' 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 ('F226090217352','kasir',' 1',' MEH1 X KH ','TOKO','SMBK-H','H1E-ZBBE-16-0','KL X NORI KH 42 8K ','OL','2.090','1','100.00','2194000','0','0','15000','2205000','0','10000','0','2215000','LUS','00391162','H1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBBE-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='H1E-ZBBE-16-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 ('F226090217352','2026-07-09','2.090','2026-07-09','14:17:36','PLG0081998','2205000','2205000','10000','2215000','2215000','kasir','2026-07-09 14:17:35','F22609021735');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090217352','2026-07-09','14:17:36','LUS','2215000','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-260709-0014','D','2026-07-09','14:17:36','kasir','PENJUALAN','F226090217352','11844426000','2215000','11846641000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2215000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226090217352' 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 ('F226090247271','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZGXB-105-T','GL TIFF MODEL SLEP HW 8K ','OL','1.460','1','100.00','1533000','0','0','15000','1541000','0','7000','0','1548000','LUS','T0080933','F3E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXB-105-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='F3E-ZGXB-105-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 ('F226090247271','2026-07-09','1.460','2026-07-09','14:47:27','PLG0081999','1541000','1541000','7000','1548000','1548000','kasir','2026-07-09 14:47:27','F22609024727');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090247271','2026-07-09','14:47:27','LUS','1548000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260709-0015','D','2026-07-09','14:47:27','kasir','PENJUALAN','F226090247271','11846641000','1548000','11848189000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226090302241','kasir','1',' MEF1 HW D4','TOKO','SMBK-F','F1E-ZEAF-8-T','GL ANAK MODEL C HW D42 8K ','','1.960','1','100.00','2058000','0','0','15000','2058000','0','0','0','2058000','TIN','T0079530','F1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAF-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='F1E-ZEAF-8-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 ('F226090302241','2026-07-09','1.960','2026-07-09','15:02:25','PLG0082000','2058000','2058000','0','2058000','2058000','kasir','2026-07-09 15:02:24','F22609030224');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090302241','2026-07-09','15:02:25','TIN','2058000','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-260709-0016','D','2026-07-09','15:02:25','kasir','PENJUALAN','F226090302241','11848189000','2058000','11850247000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2058000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226090302241' 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 ('F226090302242','kasir',' 1',' MEE1 HW 13','TOKO','SMBK-E','E1E-YKXA-94-T','CC MODEL SLEP VAR HW 13 8K ','','0.680','1','100.00','714000','0','0','15000','714000','0','0','0','714000','TIN','T0074889','E1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKXA-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='E1E-YKXA-94-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226090302242','2026-07-09','0.680','2026-07-09','15:02:25','PLG0082001','714000','714000','0','714000','714000','kasir','2026-07-09 15:02:24','F22609030224');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090302242','2026-07-09','15:02:25','TIN','714000','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-260709-0017','D','2026-07-09','15:02:25','kasir','PENJUALAN','F226090302242','11850247000','714000','11850961000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='714000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226090302242' 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 ('F226090302243','kasir',' 1',' MEE2E CM10','TOKO','SMBK-E','E2E-ZECX-32-T','CC MODEL SOLITAIRE MATA CM 10 8K ','','0.640','1','100.00','672000','0','0','15000','672000','0','0','0','672000','TIN','T0080098','E2E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZECX-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.640',berat_jual_asli=berat_jual_asli+'0.640',stock_jual='1',berat_akhir=berat_akhir-'0.640',berat_akhir_asli=berat_akhir_asli-'0.640',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='E2E-ZECX-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 ('F226090302243','2026-07-09','0.640','2026-07-09','15:02:25','PLG0082002','672000','672000','0','672000','672000','kasir','2026-07-09 15:02:24','F22609030224');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090302243','2026-07-09','15:02:25','TIN','672000','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-260709-0018','D','2026-07-09','15:02:25','kasir','PENJUALAN','F226090302243','11850961000','672000','11851633000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='672000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226090302243' 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 ('F226090316261','kasir','1',' MEE1E HW 1','TOKO','SMBK-E','E1E-ZEBH-41-T','CC MODEL SLEP HW 13 8K ','','0.700','1','100.00','735000','0','0','15000','735000','0','0','0','735000','TIN','T0079982','E1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-41-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-07-09' AND kode_barang='E1E-ZEBH-41-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 ('F226090316261','2026-07-09','0.700','2026-07-09','15:16:27','PLG0082003','735000','735000','0','735000','735000','kasir','2026-07-09 15:16:26','F22609031626');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090316261','2026-07-09','15:16:27','TIN','735000','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-260709-0019','D','2026-07-09','15:16:27','kasir','PENJUALAN','F226090316261','11851633000','735000','11852368000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090100001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090100001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090100001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090126111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090126111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090126111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090130481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090130481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090130481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090136311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090136311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090136311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090136312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090136312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090136312';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090217351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090217351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090217351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090217352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090217352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090217352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090247271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090247271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090247271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090302241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090302241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090302241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090302242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090302242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090302242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090302243' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090302243' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090302243';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090316261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090316261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090316261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090842001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090842001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090842001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090842002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090842002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090842002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090842481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090842481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090842481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090847021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090847021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090847021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226091042411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226091042411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226091042411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226091133011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226091133011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226091133011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226091228561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226091228561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226091228561';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F226090401431','kasir','1',' MEH1 X KH ','TOKO','SMBK-H','H1E-ZFBI-205-0','KL X NORY KH 42 8K ','','2.070','1','100.00','2173000','0','0','15000','2174000','0','0','0','2174000','TIN','00411197','H1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFBI-205-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-07-09' AND kode_barang='H1E-ZFBI-205-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 ('F226090401431','2026-07-09','2.070','2026-07-09','16:01:44','PLG0082004','2174000','2174000','0','2174000','2174000','kasir','2026-07-09 16:01:43','F22609040143');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-09','F226090401431','2026-07-09','16:01:44','TIN','2174000','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-260709-0020','D','2026-07-09','16:01:44','kasir','PENJUALAN','F226090401431','11852368000','2174000','11854542000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226090401431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226090401431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226090401431';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-09';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-09';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-09' 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-260710-0001','D','2026-07-10','16:08:17','SYSTEM','SALDO AWAL','SALDO AWAL','0','11854542000','11854542000');
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-260710-0001','D','2026-07-10','16:08:17','BCA','SALDO AWAL','SALDO AWAL','0','4619102888','4619102888');
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-260710-0001','D','2026-07-10','16:08:17','','SALDO AWAL','SALDO AWAL','0','2260000','2260000');
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-260710-0001','D','2026-07-10','16:08:17','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-260710-0001','D','2026-07-10','16:08:17','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-260710-0001','D','2026-07-10','16:08:17','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-10';