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 ('F226040815461','kasir','1',' MEA1E HW ','TOKO','SMBK-A','A1E-ZFXB-12-T','AT MODEL HATI ARESO SLEP HW 8K ','OLS 896Q2','0.770','1','100.00','820000','0','0','15000','866000','0','55000','0','921000','TIN','T0080157','A1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFXB-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='A1E-ZFXB-12-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 ('F226040815461','2026-07-04','0.770','2026-07-04','08:15:46','PLG0081818','866000','866000','55000','921000','921000','kasir','2026-07-04 08:15:46','F22604081546');
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-04','F226040815461','2026-07-04','08:15:46','TIN','921000','55000');
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-260704-0002','D','2026-07-04','08:15:46','kasir','PENJUALAN','F226040815461','11644829000','921000','11645750000');
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 ('F226040844341','kasir','1',' MDA1D HW ','TOKO','SMBK-A','A1D-ZGXB-18-T','AT KLIP MODEL DAUN SLEP CM 8K ','OL','0.960','1','100.00','994000','0','0','15000','1018000','0','5000','0','1023000','TIN','T0080846','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZGXB-18-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-07-04' AND kode_barang='A1D-ZGXB-18-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 ('F226040844341','2026-07-04','0.960','2026-07-04','08:44:34','PLG0081819','1018000','1018000','5000','1023000','1023000','kasir','2026-07-04 08:44:34','F22604084434');
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-04','F226040844341','2026-07-04','08:44:34','TIN','1023000','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-260704-0003','D','2026-07-04','08:44:34','kasir','PENJUALAN','F226040844341','11645750000','1023000','11646773000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1023000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040844341' 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 ('F226040844342','kasir',' 1',' MDA1D HW ','TOKO','SMBK-A','A1D-ZGXB-19-T','AT KLIP MODEL DAUN SLEP CM 8K ','OL','0.960','1','100.00','994000','0','0','15000','1018000','0','5000','0','1023000','TIN','T0080847','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZGXB-19-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-07-04' AND kode_barang='A1D-ZGXB-19-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 ('F226040844342','2026-07-04','0.960','2026-07-04','08:44:34','PLG0081820','1018000','1018000','5000','1023000','1023000','kasir','2026-07-04 08:44:34','F22604084434');
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-04','F226040844342','2026-07-04','08:44:34','TIN','1023000','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-260704-0004','D','2026-07-04','08:44:34','kasir','PENJUALAN','F226040844342','11646773000','1023000','11647796000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1023000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040844342' 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 ('F226040844343','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZFXD-16-T','KL SANTA KH 42 8K ','OL','2.010','1','100.00','2141000','0','0','15000','2161000','0','10000','0','2171000','TIN','T0080181','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-16-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-07-04' AND kode_barang='H1E-ZFXD-16-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 ('F226040844343','2026-07-04','2.010','2026-07-04','08:44:34','PLG0081821','2161000','2161000','10000','2171000','2171000','kasir','2026-07-04 08:44:34','F22604084434');
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-04','F226040844343','2026-07-04','08:44:34','TIN','2171000','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-260704-0005','D','2026-07-04','08:44:34','kasir','PENJUALAN','F226040844343','11647796000','2171000','11649967000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2171000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040844343' 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 ('F226040844344','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZFXD-12-T','KL SANTA KH 44 8K ','OL','2.020','1','100.00','2151000','0','0','15000','2172000','0','10000','0','2182000','TIN','T0080177','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='H1E-ZFXD-12-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 ('F226040844344','2026-07-04','2.020','2026-07-04','08:44:35','PLG0081822','2172000','2172000','10000','2182000','2182000','kasir','2026-07-04 08:44:34','F22604084434');
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-04','F226040844344','2026-07-04','08:44:35','TIN','2182000','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-260704-0006','D','2026-07-04','08:44:35','kasir','PENJUALAN','F226040844344','11649967000','2182000','11652149000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2182000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040844344' 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 ('F226040844345','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZFXD-11-T','KL SANTA KH 42 8K ','OL','2.050','1','100.00','2183000','0','0','15000','2204000','0','10000','0','2214000','TIN','T0080176','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXD-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='H1E-ZFXD-11-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 ('F226040844345','2026-07-04','2.050','2026-07-04','08:44:35','PLG0081823','2204000','2204000','10000','2214000','2214000','kasir','2026-07-04 08:44:34','F22604084434');
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-04','F226040844345','2026-07-04','08:44:35','TIN','2214000','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-260704-0007','D','2026-07-04','08:44:35','kasir','PENJUALAN','F226040844345','11652149000','2214000','11654363000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2214000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040844345' 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 ('F226040928311','kasir','1',' TDE2 X LG ','TOKO','TBK-E','E2TD-ZCBC-14-T','CC X MODEL MATA VAR LG 16 17K ','OL','0.970','1','100.00','1911000','0','0','15000','1892000','0','7000','0','1899000','TIN','T0078249','E2TD','0','0','-','1','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZCBC-14-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-04' AND kode_barang='E2TD-ZCBC-14-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 ('F226040928311','2026-07-04','0.970','2026-07-04','09:28:31','PLG0081824','1892000','1892000','7000','1899000','1899000','kasir','2026-07-04 09:28:31','F22604092831');
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-04','F226040928311','2026-07-04','09:28:31','TIN','1899000','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-260704-0008','D','2026-07-04','09:28:31','kasir','PENJUALAN','F226040928311','11654363000','1899000','11656262000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1899000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040928311' 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 ('F226040928312','kasir',' 1',' TDE2 X AY1','TOKO','TBK-E','E2TD-ZEBB-17-T','CC X MODEL MATA SLEP AY 15 17K ','OL','1.360','1','100.00','2679000','0','0','15000','2642000','0','10000','0','2652000','TIN','T0079780','E2TD','0','0','-','1','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZEBB-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='E2TD-ZEBB-17-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 ('F226040928312','2026-07-04','1.360','2026-07-04','09:28:31','PLG0081825','2642000','2642000','10000','2652000','2652000','kasir','2026-07-04 09:28:31','F22604092831');
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-04','F226040928312','2026-07-04','09:28:31','TIN','2652000','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-260704-0009','D','2026-07-04','09:28:31','kasir','PENJUALAN','F226040928312','11656262000','2652000','11658914000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2652000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040928312' 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 ('F226040928531','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBH-7-T','CC MODEL DAUN SLEP LG 12 8K ','OL','0.460','1','100.00','490000','0','0','15000','497000','0','5000','0','502000','TIN','T0079948','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='E1E-ZEBH-7-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226040928531','2026-07-04','0.460','2026-07-04','09:28:54','PLG0081826','497000','497000','5000','502000','502000','kasir','2026-07-04 09:28:53','F22604092853');
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-04','F226040928531','2026-07-04','09:28:54','TIN','502000','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-260704-0010','D','2026-07-04','09:28:54','kasir','PENJUALAN','F226040928531','11658914000','502000','11659416000');
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 ('F226040933271','kasir','1',' MEE1E KH 1','TOKO','SMBK-E','E1E-ZGXB-85-T','CC MODEL RING DOBLE SLEP KH 12 8K ','','0.520','1','100.00','549000','0','0','15000','556000','0','0','0','556000','RHM','T0080913','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-85-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-07-04' AND kode_barang='E1E-ZGXB-85-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 ('F226040933271','2026-07-04','0.520','2026-07-04','09:33:28','PLG0081827','556000','556000','0','556000','556000','kasir','2026-07-04 09:33:27','F22604093327');
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-04','F226040933271','2026-07-04','09:33:28','RHM','556000','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-260704-0011','D','2026-07-04','09:33:28','kasir','PENJUALAN','F226040933271','11659416000','556000','11659972000');
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 ('F226040949421','kasir','1',' MGB1G LG ','TOKO','SMBK-B','B1G-ZFBD-16-T','GW MRICAN POLOS SLEP LG 8K ','OL','0.240','1','100.00','265000','0','0','15000','269000','0','5000','0','274000','TIN','T0080704','B1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFBD-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.240',berat_jual_asli=berat_jual_asli+'0.240',stock_jual='1',berat_akhir=berat_akhir-'0.240',berat_akhir_asli=berat_akhir_asli-'0.240',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='B1G-ZFBD-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226040949421','2026-07-04','0.240','2026-07-04','09:49:43','PLG0081828','269000','269000','5000','274000','274000','kasir','2026-07-04 09:49:42','F22604094942');
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-04','F226040949421','2026-07-04','09:49:43','TIN','274000','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-260704-0012','D','2026-07-04','09:49:43','kasir','PENJUALAN','F226040949421','11659972000','274000','11660246000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='274000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040949421' 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 ('F226040949422','kasir',' 1',' MGA1G CM ','TOKO','SMBK-A','A1G-ZFBD-40-T','AT TINDIK BABY SLEP CM 8K ','OL','0.260','1','100.00','287000','0','0','15000','291000','0','5000','0','296000','TIN','T0080728','A1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZFBD-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='A1G-ZFBD-40-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 ('F226040949422','2026-07-04','0.260','2026-07-04','09:49:43','PLG0081829','291000','291000','5000','296000','296000','kasir','2026-07-04 09:49:42','F22604094942');
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-04','F226040949422','2026-07-04','09:49:43','TIN','296000','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-260704-0013','D','2026-07-04','09:49:43','kasir','PENJUALAN','F226040949422','11660246000','296000','11660542000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='296000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040949422' 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 ('F226040949423','kasir',' 1',' MGA1G CM ','TOKO','SMBK-A','A1G-ZFBD-37-T','AT TINDIK BABY SLEP CM 8K ','OL','0.260','1','100.00','287000','0','0','15000','291000','0','5000','0','296000','TIN','T0080725','A1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZFBD-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='A1G-ZFBD-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226040949423','2026-07-04','0.260','2026-07-04','09:49:43','PLG0081830','291000','291000','5000','296000','296000','kasir','2026-07-04 09:49:42','F22604094942');
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-04','F226040949423','2026-07-04','09:49:43','TIN','296000','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-260704-0014','D','2026-07-04','09:49:43','kasir','PENJUALAN','F226040949423','11660542000','296000','11660838000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='296000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040949423' 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 ('F226040949424','kasir',' 1',' MGA1G CM ','TOKO','SMBK-A','A1G-ZFBD-41-T','AT TINDIK BABY SLEP CM 8K ','OL','0.260','1','100.00','287000','0','0','15000','291000','0','5000','0','296000','TIN','T0080729','A1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZFBD-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='A1G-ZFBD-41-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 ('F226040949424','2026-07-04','0.260','2026-07-04','09:49:43','PLG0081831','291000','291000','5000','296000','296000','kasir','2026-07-04 09:49:42','F22604094942');
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-04','F226040949424','2026-07-04','09:49:43','TIN','296000','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-260704-0015','D','2026-07-04','09:49:43','kasir','PENJUALAN','F226040949424','11660838000','296000','11661134000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='296000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040949424' 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 ('F226040949425','kasir',' 1',' MEA1E X PM','TOKO','SMBK-A','A1E-ZFCX-306-0','AT X ITALY SLEP VAR PM 8K ','OL','0.550','1','100.00','583000','0','0','15000','594000','0','5000','0','599000','TIN','00411513','A1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFCX-306-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-07-04' AND kode_barang='A1E-ZFCX-306-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 ('F226040949425','2026-07-04','0.550','2026-07-04','09:49:43','PLG0081832','594000','594000','5000','599000','599000','kasir','2026-07-04 09:49:42','F22604094942');
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-04','F226040949425','2026-07-04','09:49:43','TIN','599000','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-260704-0016','D','2026-07-04','09:49:43','kasir','PENJUALAN','F226040949425','11661134000','599000','11661733000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='599000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040949425' 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 ('F226041043231','kasir','1',' TFH1 30K H','TOKO','TBK-H','H1TF-XDBI-13-0','KL KOREA HW 42CM 17K ','','5.120','1','100.00','10291000','0','0','15000','10138000','0','30000','0','10168000','RHM','00295403','H1TF','0','0','-','1','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-XDBI-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.120',berat_jual_asli=berat_jual_asli+'5.120',stock_jual='1',berat_akhir=berat_akhir-'5.120',berat_akhir_asli=berat_akhir_asli-'5.120',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='H1TF-XDBI-13-0' 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 ('F226041043231','2026-07-04','5.120','2026-07-04','10:43:24','PLG0081833','10138000','10138000','30000','10168000','10168000','kasir','2026-07-04 10:43:23','F22604104323');
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-04','F226041043231','2026-07-04','10:43:24','RHM','10168000','30000');
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-260704-0017','D','2026-07-04','10:43:24','kasir','PENJUALAN','F226041043231','11661733000','10168000','11671901000');
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 ('F226041046161','kasir','1',' TDE2 10K C','TOKO','TBK-E','E2TD-ZFXE-110-T','CC WEDIING MATA SLEP CM 12 17K ','OL','1.550','1','100.00','3053000','0','0','15000','3012000','0','11000','0','3023000','TIN','T0080412','E2TD','0','0','-','1','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-ZFXE-110-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-07-04' AND kode_barang='E2TD-ZFXE-110-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 ('F226041046161','2026-07-04','1.550','2026-07-04','10:46:17','PLG0081834','3012000','3012000','11000','3023000','3023000','kasir','2026-07-04 10:46:16','F22604104616');
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-04','F226041046161','2026-07-04','10:46:17','TIN','3023000','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-260704-0018','D','2026-07-04','10:46:17','kasir','PENJUALAN','F226041046161','11671901000','3023000','11674924000');
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 ('F226041058411','kasir','1',' MDE1 X CM ','TOKO','SMBK-E','E1D-ZFXC-140-0','CC X MODEL SLEP CM 18 8K ','','1.450','1','100.00','1515000','0','0','15000','1523000','0','0','0','1523000','TIN','00406683','E1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFXC-140-0' 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-07-04' AND kode_barang='E1D-ZFXC-140-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 ('F226041058411','2026-07-04','1.450','2026-07-04','10:58:42','PLG0081835','1523000','1523000','0','1523000','1523000','kasir','2026-07-04 10:58:41','F22604105841');
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-04','F226041058411','2026-07-04','10:58:42','TIN','1523000','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-260704-0019','D','2026-07-04','10:58:42','kasir','PENJUALAN','F226041058411','11674924000','1523000','11676447000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1523000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041058411' 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 ('F226041058412','kasir',' 1',' MDE1 X CM ','TOKO','SMBK-E','E1D-ZEBE-90-0','CC X MODEL DAUN SLEP CM 18 8K ','','1.390','1','100.00','1453000','0','0','15000','1460000','0','0','0','1460000','TIN','00404789','E1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEBE-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='E1D-ZEBE-90-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 ('F226041058412','2026-07-04','1.390','2026-07-04','10:58:42','PLG0081836','1460000','1460000','0','1460000','1460000','kasir','2026-07-04 10:58:41','F22604105841');
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-04','F226041058412','2026-07-04','10:58:42','TIN','1460000','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-260704-0020','D','2026-07-04','10:58:42','kasir','PENJUALAN','F226041058412','11676447000','1460000','11677907000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1460000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041058412' 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 ('F226041109581','kasir','1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZEBH-72-T','GL OVAL C SLEP TD 56 8K ','OL','3.110','1','100.00','3312000','0','0','15000','3344000','0','16000','0','3360000','TIN','T0080013','F1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBH-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F1E-ZEBH-72-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 ('F226041109581','2026-07-04','3.110','2026-07-04','11:09:59','PLG0081837','3344000','3344000','16000','3360000','3360000','kasir','2026-07-04 11:09:58','F22604110958');
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-04','F226041109581','2026-07-04','11:09:59','TIN','3360000','16000');
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-260704-0021','D','2026-07-04','11:09:59','kasir','PENJUALAN','F226041109581','11677907000','3360000','11681267000');
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 ('F226041115391','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGXB-69-T','CC MDOEL ISYANA SLEP LG 16 8K ','OL','0.610','1','100.00','644000','0','0','15000','659000','0','5000','0','664000','TIN','T0080897','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='E1E-ZGXB-69-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 ('F226041115391','2026-07-04','0.610','2026-07-04','11:15:40','PLG0081838','659000','659000','5000','664000','664000','kasir','2026-07-04 11:15:39','F22604111539');
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-04','F226041115391','2026-07-04','11:15:40','TIN','664000','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-260704-0022','D','2026-07-04','11:15:40','kasir','PENJUALAN','F226041115391','11681267000','664000','11681931000');
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 ('F226041138451','kasir','1',' MEB1 X CM ','TOKO','SMBK-B','B1E-ZFCX-153-0','GW X MODEL MATA CM PE 8K ','OL','0.650','1','100.00','689000','0','0','15000','702000','0','5000','0','707000','TIN','00411360','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFCX-153-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='B1E-ZFCX-153-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 ('F226041138451','2026-07-04','0.650','2026-07-04','11:38:46','PLG0081839','702000','702000','5000','707000','707000','kasir','2026-07-04 11:38:45','F22604113845');
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-04','F226041138451','2026-07-04','11:38:46','TIN','707000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260704-0023','D','2026-07-04','11:38:46','kasir','PENJUALAN','F226041138451','11681931000','707000','11682638000');
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 ('F226041140211','kasir','1',' MEE1E KH 1','TOKO','SMBK-E','E1E-ZGXB-84-T','CC MODEL RING DOBLE SLEP KH 12 8K ','OL','0.500','1','100.00','527000','0','0','15000','540000','0','5000','0','545000','TIN','T0080912','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-84-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-07-04' AND kode_barang='E1E-ZGXB-84-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041140211','2026-07-04','0.500','2026-07-04','11:40:22','PLG0081840','540000','540000','5000','545000','545000','kasir','2026-07-04 11:40:21','F22604114021');
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-04','F226041140211','2026-07-04','11:40:22','TIN','545000','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-260704-0024','D','2026-07-04','11:40:22','kasir','PENJUALAN','F226041140211','11682638000','545000','11683183000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='545000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041140211' 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 ('F226041140212','kasir',' 1',' MEB1 X LG ','TOKO','SMBK-B','B1E-ZFCX-152-0','GW X MODEL MATA LG PE 8K ','OL','0.580','1','100.00','615000','0','0','15000','626000','0','5000','0','631000','TIN','00411359','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFCX-152-0' 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-07-04' AND kode_barang='B1E-ZFCX-152-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 ('F226041140212','2026-07-04','0.580','2026-07-04','11:40:22','PLG0081841','626000','626000','5000','631000','631000','kasir','2026-07-04 11:40:21','F22604114021');
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-04','F226041140212','2026-07-04','11:40:22','TIN','631000','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-260704-0025','D','2026-07-04','11:40:22','kasir','PENJUALAN','F226041140212','11683183000','631000','11683814000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='631000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041140212' 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 ('F226041140561','kasir','1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZFCX-309-0','AT X MODEL ARESO PASIR VAR UB 8K ','OL','0.850','1','100.00','884000','0','0','15000','901000','0','5000','0','906000','TIN','00411516','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFCX-309-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='A1D-ZFCX-309-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 ('F226041140561','2026-07-04','0.850','2026-07-04','11:40:56','PLG0081842','901000','901000','5000','906000','906000','kasir','2026-07-04 11:40:56','F22604114056');
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-04','F226041140561','2026-07-04','11:40:56','TIN','906000','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-260704-0026','D','2026-07-04','11:40:56','kasir','PENJUALAN','F226041140561','11683814000','906000','11684720000');
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 ('F226041141281','kasir','1',' MEE1E CM 1','TOKO','SMBK-E','E1E-ZEBH-44-T','CC MODEL MATA SLEP CM 18 8K ','OL','0.670','1','100.00','714000','0','0','15000','724000','0','5000','0','729000','TIN','T0079985','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-44-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-07-04' AND kode_barang='E1E-ZEBH-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041141281','2026-07-04','0.670','2026-07-04','11:41:29','PLG0081843','724000','724000','5000','729000','729000','kasir','2026-07-04 11:41:28','F22604114128');
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-04','F226041141281','2026-07-04','11:41:29','TIN','729000','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-260704-0027','D','2026-07-04','11:41:29','kasir','PENJUALAN','F226041141281','11684720000','729000','11685449000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='729000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041141281' 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 ('F226041141282','kasir',' 1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZFAG-94-0','KL X MILANO UB 44 8K ','OL','2.120','1','100.00','2258000','0','0','15000','2279000','0','11000','0','2290000','TIN','00408917','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFAG-94-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='H1E-ZFAG-94-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 ('F226041141282','2026-07-04','2.120','2026-07-04','11:41:29','PLG0081844','2279000','2279000','11000','2290000','2290000','kasir','2026-07-04 11:41:28','F22604114128');
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-04','F226041141282','2026-07-04','11:41:29','TIN','2290000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260704-0028','D','2026-07-04','11:41:29','kasir','PENJUALAN','F226041141282','11685449000','2290000','11687739000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2290000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041141282' 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 ('F226041145231','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZGXA-124-0','CC X MODEL MATA CM 8 8K ','','0.580','1','100.00','612000','0','0','15000','621000','0','0','0','621000','TIN','00411648','E2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXA-124-0' 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-07-04' AND kode_barang='E2E-ZGXA-124-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 ('F226041145231','2026-07-04','0.580','2026-07-04','11:45:24','PLG0081845','621000','621000','0','621000','621000','kasir','2026-07-04 11:45:23','F22604114523');
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-04','F226041145231','2026-07-04','11:45:24','TIN','621000','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-260704-0029','D','2026-07-04','11:45:24','kasir','PENJUALAN','F226041145231','11687739000','621000','11688360000');
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 ('F226041158311','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZFBC-37-T','GL FANCY VAR SLEP HW 8K ','','1.020','1','100.00','1086000','0','0','15000','1091000','0','0','0','1091000','RHM','T0080646','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFBC-37-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-07-04' AND kode_barang='F3E-ZFBC-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226041158311','2026-07-04','1.020','2026-07-04','11:58:31','PLG0081846','1091000','1091000','0','1091000','1091000','kasir','2026-07-04 11:58:31','F22604115831');
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-04','F226041158311','2026-07-04','11:58:31','RHM','1091000','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-260704-0030','D','2026-07-04','11:58:31','kasir','PENJUALAN','F226041158311','11688360000','1091000','11689451000');
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 ('F226041233291','kasir','1',' MED2E X LG','TOKO','SMBK-D','D2E-ZEXI-51-0','LT X MODEL HURUF MATA LG N 8K ','OL','0.480','1','100.00','511000','0','0','15000','521000','0','5000','0','526000','TIN','00402872','D2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZEXI-51-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-07-04' AND kode_barang='D2E-ZEXI-51-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 ('F226041233291','2026-07-04','0.480','2026-07-04','12:33:30','PLG0081847','521000','521000','5000','526000','526000','kasir','2026-07-04 12:33:29','F22604123329');
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-04','F226041233291','2026-07-04','12:33:30','TIN','526000','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-260704-0031','D','2026-07-04','12:33:30','kasir','PENJUALAN','F226041233291','11689451000','526000','11689977000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='526000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041233291' 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 ('F226041233292','kasir',' 1',' MED2E X LG','TOKO','SMBK-D','D2E-ZFCX-15-0','LT X MODEL BOLA MATA LG 8K ','OL','0.530','1','100.00','562000','0','0','15000','576000','0','5000','0','581000','TIN','00411222','D2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZFCX-15-0' 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-07-04' AND kode_barang='D2E-ZFCX-15-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 ('F226041233292','2026-07-04','0.530','2026-07-04','12:33:30','PLG0081848','576000','576000','5000','581000','581000','kasir','2026-07-04 12:33:29','F22604123329');
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-04','F226041233292','2026-07-04','12:33:30','TIN','581000','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-260704-0032','D','2026-07-04','12:33:30','kasir','PENJUALAN','F226041233292','11689977000','581000','11690558000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='581000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041233292' 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 ('F226041233293','kasir',' 1',' MEA1E HW ','TOKO','SMBK-A','A1E-ZGXB-14-T','AT MODEL ITALY VAR SLEP HW 8K ','OL','0.550','1','100.00','580000','0','0','15000','597000','0','5000','0','602000','TIN','T0080842','A1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGXB-14-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-07-04' AND kode_barang='A1E-ZGXB-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 ('F226041233293','2026-07-04','0.550','2026-07-04','12:33:30','PLG0081849','597000','597000','5000','602000','602000','kasir','2026-07-04 12:33:29','F22604123329');
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-04','F226041233293','2026-07-04','12:33:30','TIN','602000','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-260704-0033','D','2026-07-04','12:33:30','kasir','PENJUALAN','F226041233293','11690558000','602000','11691160000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041233293' 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 ('F226041233294','kasir',' 1',' MEF3E 10K ','TOKO','SMBK-F','F3E-ZGXB-100-T','GL TIFF SPECTRA CAT MERAH SLEP YT 8K ','OL','1.320','1','100.00','1393000','0','0','15000','1425000','0','7000','0','1432000','TIN','T0080928','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXB-100-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F3E-ZGXB-100-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 ('F226041233294','2026-07-04','1.320','2026-07-04','12:33:30','PLG0081850','1425000','1425000','7000','1432000','1432000','kasir','2026-07-04 12:33:29','F22604123329');
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-04','F226041233294','2026-07-04','12:33:30','TIN','1432000','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-260704-0034','D','2026-07-04','12:33:30','kasir','PENJUALAN','F226041233294','11691160000','1432000','11692592000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1432000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041233294' 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 ('F226041233295','kasir',' 1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZGXB-101-T','GL RANTAI MODEL DAUN SLEP HW 8K ','OL','1.700','1','100.00','1793000','0','0','15000','1836000','0','9000','0','1845000','TIN','T0080929','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXB-101-T' 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-07-04' AND kode_barang='F3E-ZGXB-101-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 ('F226041233295','2026-07-04','1.700','2026-07-04','12:33:30','PLG0081851','1836000','1836000','9000','1845000','1845000','kasir','2026-07-04 12:33:29','F22604123329');
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-04','F226041233295','2026-07-04','12:33:30','TIN','1845000','9000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260704-0035','D','2026-07-04','12:33:30','kasir','PENJUALAN','F226041233295','11692592000','1845000','11694437000','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='F226041233295' 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 ('F226041235241','kasir','1',' MEE1 X UB ','TOKO','SMBK-E','E1E-ZGXA-128-0','CC X MODEL SLEP UB 16 8K ','OL','0.460','1','100.00','485000','0','0','15000','499000','0','5000','0','504000','TIN','00411652','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-128-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-07-04' AND kode_barang='E1E-ZGXA-128-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 ('F226041235241','2026-07-04','0.460','2026-07-04','12:35:25','PLG0081852','499000','499000','5000','504000','504000','kasir','2026-07-04 12:35:24','F22604123524');
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-04','F226041235241','2026-07-04','12:35:25','TIN','504000','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-260704-0036','D','2026-07-04','12:35:25','kasir','PENJUALAN','F226041235241','11694437000','504000','11694941000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='504000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041235241' 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 ('F226041235242','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGXB-55-T','CC MODEL DAUN SLEP LG 16 8K ','OL','0.480','1','100.00','506000','0','0','15000','521000','0','5000','0','526000','TIN','T0080883','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-55-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-07-04' AND kode_barang='E1E-ZGXB-55-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 ('F226041235242','2026-07-04','0.480','2026-07-04','12:35:25','PLG0081853','521000','521000','5000','526000','526000','kasir','2026-07-04 12:35:24','F22604123524');
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-04','F226041235242','2026-07-04','12:35:25','TIN','526000','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-260704-0037','D','2026-07-04','12:35:25','kasir','PENJUALAN','F226041235242','11694941000','526000','11695467000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='526000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041235242' 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 ('F226041235243','kasir',' 1',' MEE1E KH 1','TOKO','SMBK-E','E1E-ZGXB-86-T','CC MODEL RING DOBLE SLEP KH 14 8K ','OL','0.500','1','100.00','527000','0','0','15000','543000','0','5000','0','548000','TIN','T0080914','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-86-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-07-04' AND kode_barang='E1E-ZGXB-86-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 ('F226041235243','2026-07-04','0.500','2026-07-04','12:35:25','PLG0081854','543000','543000','5000','548000','548000','kasir','2026-07-04 12:35:24','F22604123524');
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-04','F226041235243','2026-07-04','12:35:25','TIN','548000','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-260704-0038','D','2026-07-04','12:35:25','kasir','PENJUALAN','F226041235243','11695467000','548000','11696015000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041235243' 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 ('F226041235244','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGXB-54-T','CC MODEL DAUN SLEP LG 18 8K ','OL','0.510','1','100.00','538000','0','0','15000','553000','0','5000','0','558000','TIN','T0080882','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-54-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-07-04' AND kode_barang='E1E-ZGXB-54-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 ('F226041235244','2026-07-04','0.510','2026-07-04','12:35:25','PLG0081855','553000','553000','5000','558000','558000','kasir','2026-07-04 12:35:24','F22604123524');
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-04','F226041235244','2026-07-04','12:35:25','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-260704-0039','D','2026-07-04','12:35:25','kasir','PENJUALAN','F226041235244','11696015000','558000','11696573000','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='F226041235244' 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 ('F226041235245','kasir',' 1',' MEE1 X LG ','TOKO','SMBK-E','E1E-ZGXA-136-0','CC X MODEL DAUN SLEP LG 18 8K ','OL','0.600','1','100.00','633000','0','0','15000','651000','0','5000','0','656000','TIN','00411660','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-136-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='E1E-ZGXA-136-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 ('F226041235245','2026-07-04','0.600','2026-07-04','12:35:25','PLG0081856','651000','651000','5000','656000','656000','kasir','2026-07-04 12:35:24','F22604123524');
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-04','F226041235245','2026-07-04','12:35:25','TIN','656000','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-260704-0040','D','2026-07-04','12:35:25','kasir','PENJUALAN','F226041235245','11696573000','656000','11697229000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='656000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041235245' 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 ('F226041236191','kasir','1',' MEA1E HW ','TOKO','SMBK-A','A1E-ZGXB-11-T','AT MODEL ITALY VAR SLEP HW 8K ','OL','0.550','1','100.00','580000','0','0','15000','594000','0','5000','0','599000','TIN','T0080839','A1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZGXB-11-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-07-04' AND kode_barang='A1E-ZGXB-11-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 ('F226041236191','2026-07-04','0.550','2026-07-04','12:36:20','PLG0081857','594000','594000','5000','599000','599000','kasir','2026-07-04 12:36:19','F22604123619');
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-04','F226041236191','2026-07-04','12:36:20','TIN','599000','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-260704-0041','D','2026-07-04','12:36:20','kasir','PENJUALAN','F226041236191','11697229000','599000','11697828000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='599000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041236191' 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 ('F226041236192','kasir',' 1',' MED1E LG A','TOKO','SMBK-D','D1E-ZBBX-27-0','LT MODEL HURUF MATA LG A 8K ','OL','0.600','1','100.00','639000','0','0','15000','648000','0','5000','0','653000','TIN','00391004','D1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZBBX-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='D1E-ZBBX-27-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 ('F226041236192','2026-07-04','0.600','2026-07-04','12:36:20','PLG0081858','648000','648000','5000','653000','653000','kasir','2026-07-04 12:36:19','F22604123619');
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-04','F226041236192','2026-07-04','12:36:20','TIN','653000','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-260704-0042','D','2026-07-04','12:36:20','kasir','PENJUALAN','F226041236192','11697828000','653000','11698481000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='653000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041236192' 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 ('F226041236193','kasir',' 1',' MEF1 X YT ','TOKO','SMBK-F','F1E-ZFCX-45-0','GL X OVAL C GELOMBANG YT 54 8K ','OL','2.970','1','100.00','3148000','0','0','15000','3193000','0','15000','0','3208000','TIN','00411252','F1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFCX-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F1E-ZFCX-45-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 ('F226041236193','2026-07-04','2.970','2026-07-04','12:36:20','PLG0081859','3193000','3193000','15000','3208000','3208000','kasir','2026-07-04 12:36:19','F22604123619');
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-04','F226041236193','2026-07-04','12:36:20','TIN','3208000','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-260704-0043','D','2026-07-04','12:36:20','kasir','PENJUALAN','F226041236193','11698481000','3208000','11701689000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3208000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226041236193' 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 ('F226040107471','kasir','1',' MDE1D UB 1','TOKO','SMBK-E','E1D-ZGXB-50-T','CC MODEL C SLEP UB 16 8K ','OL','0.960','1','100.00','994000','0','0','15000','1018000','0','5000','0','1023000','TIN','T0080878','E1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGXB-50-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-07-04' AND kode_barang='E1D-ZGXB-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226040107471','2026-07-04','0.960','2026-07-04','13:07:47','PLG0081860','1018000','1018000','5000','1023000','1023000','kasir','2026-07-04 13:07:47','F22604010747');
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-04','F226040107471','2026-07-04','13:07:47','TIN','1023000','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-260704-0044','D','2026-07-04','13:07:47','kasir','PENJUALAN','F226040107471','11701689000','1023000','11702712000');
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 ('F226040108081','kasir','1',' MEF2E PM 5','TOKO','SMBK-F','F2E-ZFBC-73-T','GL PIPA MATA PM 56 8K ','OL','2.950','1','100.00','3142000','0','0','15000','3171000','0','15000','0','3186000','TIN','T0080682','F2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFBC-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F2E-ZFBC-73-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 ('F226040108081','2026-07-04','2.950','2026-07-04','13:08:08','PLG0081861','3171000','3171000','15000','3186000','3186000','kasir','2026-07-04 13:08:08','F22604010808');
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-04','F226040108081','2026-07-04','13:08:08','TIN','3186000','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-260704-0045','D','2026-07-04','13:08:08','kasir','PENJUALAN','F226040108081','11702712000','3186000','11705898000');
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 ('F226040133011','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGXB-124-T','KL KOREA KH 44 8K ','OL','4.060','1','100.00','4283000','0','0','15000','4385000','0','20000','0','4405000','TIN','T0080952','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXB-124-T' 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-07-04' AND kode_barang='H1E-ZGXB-124-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 ('F226040133011','2026-07-04','4.060','2026-07-04','13:33:01','PLG0081862','4385000','4385000','20000','4405000','4405000','kasir','2026-07-04 13:33:01','F22604013301');
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-04','F226040133011','2026-07-04','13:33:01','TIN','4405000','20000');
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-260704-0046','D','2026-07-04','13:33:01','kasir','PENJUALAN','F226040133011','11705898000','4405000','11710303000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4405000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040133011' 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 ('F226040133012','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZFBE-83-T','LT MODEL BUNGA ARESO SLEP BG 8K ','OL','1.000','1','100.00','1085000','0','0','15000','1100000','0','5000','0','1105000','TIN','T0080825','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFBE-83-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-07-04' AND kode_barang='D1F-ZFBE-83-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 ('F226040133012','2026-07-04','1.000','2026-07-04','13:33:01','PLG0081863','1100000','1100000','5000','1105000','1105000','kasir','2026-07-04 13:33:01','F22604013301');
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-04','F226040133012','2026-07-04','13:33:01','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-260704-0047','D','2026-07-04','13:33:01','kasir','PENJUALAN','F226040133012','11710303000','1105000','11711408000','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='F226040133012' 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 ('F226040143581','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZFBE-79-T','GL SANTA VAR CAT MATA SERUT SLEP HW 8K ','','1.630','1','100.00','1736000','0','0','15000','1744000','0','0','0','1744000','RHM','T0080821','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFBE-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F3E-ZFBE-79-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 ('F226040143581','2026-07-04','1.630','2026-07-04','13:43:58','PLG0081864','1744000','1744000','0','1744000','1744000','kasir','2026-07-04 13:43:58','F22604014358');
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-04','F226040143581','2026-07-04','13:43:58','RHM','1744000','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-260704-0048','D','2026-07-04','13:43:58','kasir','PENJUALAN','F226040143581','11711408000','1744000','11713152000');
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 ('F226040144491','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZFXD-43-T','GL CAPELLA SLEP HW 8K ','','1.270','1','100.00','1353000','0','0','15000','1359000','0','0','0','1359000','RHM','T0080208','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='F3E-ZFXD-43-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 ('F226040144491','2026-07-04','1.270','2026-07-04','13:44:49','PLG0081865','1359000','1359000','0','1359000','1359000','kasir','2026-07-04 13:44:49','F22604014449');
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-04','F226040144491','2026-07-04','13:44:49','RHM','1359000','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-260704-0049','D','2026-07-04','13:44:49','kasir','PENJUALAN','F226040144491','11713152000','1359000','11714511000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1359000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040144491' 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 ('F226040144492','kasir',' 1',' MIS1I LG ','TOKO','SMBK-S','S1G-ZGXB-9-T','AS EXTENSION LG 8K ','','0.180','1','100.00','198000','0','0','15000','207000','0','0','0','207000','RHM','T0080837','S1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZGXB-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.180',berat_jual_asli=berat_jual_asli+'0.180',stock_jual='1',berat_akhir=berat_akhir-'0.180',berat_akhir_asli=berat_akhir_asli-'0.180',stock_akhir='0' WHERE tanggal='2026-07-04' AND kode_barang='S1G-ZGXB-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226040144492','2026-07-04','0.180','2026-07-04','13:44:49','PLG0081866','207000','207000','0','207000','207000','kasir','2026-07-04 13:44:49','F22604014449');
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-04','F226040144492','2026-07-04','13:44:49','RHM','207000','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-260704-0050','D','2026-07-04','13:44:49','kasir','PENJUALAN','F226040144492','11714511000','207000','11714718000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='207000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226040144492' 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 ('F226040257261','kasir','1',' MEA1E PM ','TOKO','SMBK-A','A1E-ZFAF-17-T','AT ITALY VAR SLEP PM 8K','OL','0.550','1','100.00','586000','0','0','15000','594000','0','5000','0','599000','TIN','T0080452','A1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFAF-17-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-07-04' AND kode_barang='A1E-ZFAF-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 ('F226040257261','2026-07-04','0.550','2026-07-04','14:57:27','PLG0081867','594000','594000','5000','599000','599000','kasir','2026-07-04 14:57:26','F22604025726');
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-04','F226040257261','2026-07-04','14:57:27','TIN','599000','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-260704-0051','D','2026-07-04','14:57:27','kasir','PENJUALAN','F226040257261','11714718000','599000','11715317000');
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-00005500','X-00005500','GL MODEL GENIA UB 8K','GR','---','F3E','BELI','BELI001','460000','2026-07-04','0.480','1','admin','2026-07-04 15:30:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005500','X-00005500');
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-260704-0001','F226190814581','TIN','1','BELI','BELI001','F3E', 'X-00005500', 'GL MODEL GENIA UB 8K','0.480','0.480','100.00','571000','460000','958333','1055000','1','460000','460000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260704-0001','2026-07-04','2026-07-04','15:30:41','TIN','---','0.480','460000','460000','460000','460000','460000','admin','2026-07-04 15:30:41','FB-260704-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0001','APRILIA','SUMOROTO','','','085748066457','admin','2026-07-04 15:30:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0052','K','2026-07-04','15:30:41','admin','PEMBELIAN UMUM','FB-260704-0001','11715317000','460000','11714857000');
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-00005501','X-00005501','LT SLOBOK BALOK HURUF BG S 8K','GR','---','D1F','BELI','BELI001','560000','2026-07-04','0.570','1','admin','2026-07-04 15:30:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00005501','X-00005501');
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-260704-0002','F226080843311','TIN','2','BELI','BELI001','D1F', 'X-00005501', 'LT SLOBOK BALOK HURUF BG S 8K','0.570','0.570','100.00','656000','560000','982456','1080000','1','560000','560000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.570',berat_beli_asli=berat_beli_asli+'0.570',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.570',berat_akhir_asli=berat_akhir_asli+'0.570',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260704-0002','2026-07-04','2026-07-04','15:30:41','TIN','---','0.570','560000','560000','560000','560000','560000','admin','2026-07-04 15:30:41','FB-260704-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0002','SRI WAHYUNI','NGABAR','','','082335541177','admin','2026-07-04 15:30:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0053','K','2026-07-04','15:30:41','admin','PEMBELIAN UMUM','FB-260704-0002','11714857000','560000','11714297000');
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-00005502','X-00005502','CC BANGKOK SLEP LG 20 8K','GR','---','E1E','BELI','BELI001','450000','2026-07-04','0.470','1','admin','2026-07-04 15:30:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005502','X-00005502');
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-260704-0003','F226061006261','TIN','3','BELI','BELI001','E1E', 'X-00005502', 'CC BANGKOK SLEP LG 20 8K','0.470','0.470','100.00','524000','450000','957447','1055000','1','450000','450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260704-0003','2026-07-04','2026-07-04','15:30:41','TIN','---','0.470','450000','450000','450000','450000','450000','admin','2026-07-04 15:30:41','FB-260704-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0003','P BAMBANG','PERUM. SINGOSAREN','','','085230143636','admin','2026-07-04 15:30:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0054','K','2026-07-04','15:30:41','admin','PEMBELIAN UMUM','FB-260704-0003','11714297000','450000','11713847000');
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-00005503','X-00005503','CC MODEL SLEP VAR HW 17 8K','GR','---','E1E','BELI','BELI001','712000','2026-07-04','0.750','1','admin','2026-07-04 15:30:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005503','X-00005503');
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-260704-0004','F226041018131','TIN','4','BELI','BELI001','E1E', 'X-00005503', 'CC MODEL SLEP VAR HW 17 8K','0.750','0.750','100.00','878000','712000','949333','1055000','1','712000','712000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260704-0004','2026-07-04','2026-07-04','15:30:41','TIN','---','0.750','712000','712000','712000','712000','712000','admin','2026-07-04 15:30:41','FB-260704-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0004','RURI','BETON SIMAN','','','085608890544','admin','2026-07-04 15:30:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0055','K','2026-07-04','15:30:41','admin','PEMBELIAN UMUM','FB-260704-0004','11713847000','712000','11713135000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040107471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040107471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040107471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040108081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040108081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040108081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040133011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040133011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040133011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040133012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040133012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040133012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040143581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040143581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040143581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040144491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040144491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040144491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040144492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040144492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040144492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040257261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040257261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040257261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040815461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040815461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040815461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040844341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040844342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844343' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844343' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040844343';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844344' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844344' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040844344';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844345' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040844345' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040844345';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040928311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040928311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040928311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040928312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040928312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040928312';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040928531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040928531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040928531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040933271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040933271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040933271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040949421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040949422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949423' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949423' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040949423';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949424' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949424' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040949424';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949425' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226040949425' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226040949425';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041043231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041043231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041043231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041046161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041046161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041046161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041058411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041058411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041058411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041058412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041058412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041058412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041109581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041109581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041109581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041115391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041115391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041115391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041138451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041138451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041138451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041140211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041140211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041140211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041140212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041140212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041140212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041140561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041140561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041140561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041141281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041141281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041141281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041141282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041141282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041141282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041145231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041145231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041145231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041158311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041158311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041158311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041233291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041233292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041233293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233294' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233294' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041233294';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233295' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041233295' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041233295';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041235241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041235242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235243' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235243' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041235243';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235244' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235244' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041235244';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235245' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041235245' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041235245';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041236191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041236191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041236191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041236192' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041236192' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041236192';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226041236193' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226041236193' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226041236193';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0004';
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-00005504','X-00005504','GL OVAL C SLEP TD 52 8K','GR','---','F1E','BELI','BELI001','2548000','2026-07-04','2.990','1','admin','2026-07-04 15:49:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00005504','X-00005504');
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-260704-0005','F226300914361','RHM','1','BELI','BELI001','F1E', 'X-00005504', 'GL OVAL C SLEP TD 52 8K','2.990','2.990','100.00','3185000','2548000','852174','1055000','1','2548000','2548000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.990',berat_beli_asli=berat_beli_asli+'2.990',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.990',berat_akhir_asli=berat_akhir_asli+'2.990',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260704-0005','2026-07-04','2026-07-04','15:49:46','RHM','---','2.990','2548000','2548000','2548000','2548000','2548000','admin','2026-07-04 15:49:47','FB-260704-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260704-0005','DEWI','BABADAN','','','','admin','2026-07-04 15:49:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-04' 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-260704-0056','K','2026-07-04','15:49:46','admin','PEMBELIAN UMUM','FB-260704-0005','11713135000','2548000','11710587000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260704-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260704-0005';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-04';
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-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-04';
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-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-04' 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-260705-0001','D','2026-07-05','16:17:14','SYSTEM','SALDO AWAL','SALDO AWAL','0','11710587000','11710587000');
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-260705-0001','D','2026-07-05','16:17:14','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-260705-0001','D','2026-07-05','16:17:14','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-260705-0001','D','2026-07-05','16:17:14','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-260705-0001','D','2026-07-05','16:17:14','','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-260705-0001','D','2026-07-05','16:17:14','BCA','SALDO AWAL','SALDO AWAL','0','4605150888','4605150888');
UPDATE tp_system SET tgl_system='2026-07-05';