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 ('F226030848541','kasir','1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZFCX-310-0','AT X HUGGIES ARESO VAR UB 8K ','OL','1.070','1','100.00','1113000','0','0','15000','1151000','0','5000','0','1156000','TIN','00411517','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFCX-310-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='A1D-ZFCX-310-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 ('F226030848541','2026-07-03','1.070','2026-07-03','08:48:54','PLG0081763','1151000','1151000','5000','1156000','1156000','kasir','2026-07-03 08:48:54','F22603084854');
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-03','F226030848541','2026-07-03','08:48:54','TIN','1156000','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-260703-0002','D','2026-07-03','08:48:54','kasir','PENJUALAN','F226030848541','11583209000','1156000','11584365000');
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 ('F226030921581','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZCBF-18-T','LT SLOBOK BULAT HURUF BG R 8K ','','0.670','1','100.00','727000','0','0','15000','740000','0','5000','0','745000','LUS','T0078303','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZCBF-18-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-03' AND kode_barang='D1F-ZCBF-18-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 ('F226030921581','2026-07-03','0.670','2026-07-03','09:21:59','PLG0081764','740000','740000','5000','745000','745000','kasir','2026-07-03 09:21:58','F22603092158');
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-03','F226030921581','2026-07-03','09:21:59','LUS','745000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260703-0003','D','2026-07-03','09:21:59','kasir','PENJUALAN','F226030921581','11584365000','745000','11585110000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='745000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030921581' 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 ('F226030921582','kasir',' 1',' MDB1 X IB ','TOKO','SMBK-B','B1D-ZFXH-83-0','GW X DAISY MATA IB PE 8K ','','1.080','1','100.00','1129000','0','0','15000','1150000','0','0','0','1150000','LUS','00407944','B1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZFXH-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='B1D-ZFXH-83-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 ('F226030921582','2026-07-03','1.080','2026-07-03','09:21:59','PLG0081765','1150000','1150000','0','1150000','1150000','kasir','2026-07-03 09:21:58','F22603092158');
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-03','F226030921582','2026-07-03','09:21:59','LUS','1150000','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-260703-0004','D','2026-07-03','09:21:59','kasir','PENJUALAN','F226030921582','11585110000','1150000','11586260000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1150000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030921582' 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 ('F226030924461','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBH-25-T','CC MODEL ISYANA SLEP LG 12 8K ','','0.450','1','100.00','479000','0','0','15000','488000','0','0','0','488000','LUS','T0079966','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1E-ZEBH-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030924461','2026-07-03','0.450','2026-07-03','09:24:46','PLG0081766','488000','488000','0','488000','488000','kasir','2026-07-03 09:24:46','F22603092446');
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-03','F226030924461','2026-07-03','09:24:46','LUS','488000','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-260703-0005','D','2026-07-03','09:24:46','kasir','PENJUALAN','F226030924461','11586260000','488000','11586748000');
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 ('F226031002021','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZGXB-103-T','GL MODEL LADY GAGA SLEP UB 8K ','OL','2.710','1','100.00','2859000','0','0','15000','2953000','0','14000','0','2967000','LUS','T0080931','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXB-103-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.710',berat_jual_asli=berat_jual_asli+'2.710',stock_jual='1',berat_akhir=berat_akhir-'2.710',berat_akhir_asli=berat_akhir_asli-'2.710',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='F3E-ZGXB-103-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 ('F226031002021','2026-07-03','2.710','2026-07-03','10:02:03','PLG0081767','2953000','2953000','14000','2967000','2967000','kasir','2026-07-03 10:02:02','F22603100202');
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-03','F226031002021','2026-07-03','10:02:03','LUS','2967000','14000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260703-0006','D','2026-07-03','10:02:03','kasir','PENJUALAN','F226031002021','11586748000','2967000','11589715000');
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 ('F226031010481','kasir','1',' MDA1D UB ','TOKO','SMBK-A','A1D-ZFAI-76-T','AT HUGGIES HATI MATA SLEP UB 8K ','','1.200','1','100.00','1254000','0','0','15000','1278000','0','0','0','1278000','TIN','T0080576','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFAI-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='A1D-ZFAI-76-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 ('F226031010481','2026-07-03','1.200','2026-07-03','10:10:49','PLG0081768','1278000','1278000','0','1278000','1278000','kasir','2026-07-03 10:10:48','F22603101048');
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-03','F226031010481','2026-07-03','10:10:49','TIN','1278000','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-260703-0007','D','2026-07-03','10:10:49','kasir','PENJUALAN','F226031010481','11589715000','1278000','11590993000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1278000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031010481' 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 ('F226031010482','kasir',' 1',' MEH1 X HW ','TOKO','SMBK-H','H1E-ZFBI-212-0','KL X SANTA MATA VAR HW 42 8K ','','2.000','1','100.00','2130000','0','0','15000','2170000','0','0','0','2170000','TIN','00411204','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFBI-212-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='H1E-ZFBI-212-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 ('F226031010482','2026-07-03','2.000','2026-07-03','10:10:49','PLG0081769','2170000','2170000','0','2170000','2170000','kasir','2026-07-03 10:10:48','F22603101048');
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-03','F226031010482','2026-07-03','10:10:49','TIN','2170000','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-260703-0008','D','2026-07-03','10:10:49','kasir','PENJUALAN','F226031010482','11590993000','2170000','11593163000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2170000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031010482' 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 ('F226031039081','kasir','1',' MDD1 CM ','TOKO','SMBK-D','D1D-ZABA-37-T','LT LETTERA BULAT CM 8K ','','0.960','1','100.00','1003000','0','0','15000','1022000','0','0','0','1022000','TIN','T0076810','D1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZABA-37-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-03' AND kode_barang='D1D-ZABA-37-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 ('F226031039081','2026-07-03','0.960','2026-07-03','10:39:08','PLG0081770','1022000','1022000','0','1022000','1022000','kasir','2026-07-03 10:39:08','F22603103908');
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-03','F226031039081','2026-07-03','10:39:08','TIN','1022000','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-260703-0009','D','2026-07-03','10:39:08','kasir','PENJUALAN','F226031039081','11593163000','1022000','11594185000');
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 ('F226031050311','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGXB-111-T','KL LONG LING SLEP UB 44 8K ','','1.970','1','100.00','2078000','0','0','15000','2137000','0','0','0','2137000','TIN','T0080939','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXB-111-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='H1E-ZGXB-111-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 ('F226031050311','2026-07-03','1.970','2026-07-03','10:50:31','PLG0081771','2137000','2137000','0','2137000','2137000','kasir','2026-07-03 10:50:31','F22603105031');
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-03','F226031050311','2026-07-03','10:50:31','TIN','2137000','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-260703-0010','D','2026-07-03','10:50:31','kasir','PENJUALAN','F226031050311','11594185000','2137000','11596322000');
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 ('F226031055241','kasir','1',' MEF3E KH ','TOKO','SMBK-F','F3E-ZFXD-50-T','GL RANTAI HOLLOW VAR SLEP KH 8K ','OL','3.060','1','100.00','3259000','0','0','15000','3336000','0','15000','0','3351000','TIN','T0080215','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='F3E-ZFXD-50-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 ('F226031055241','2026-07-03','3.060','2026-07-03','10:55:25','PLG0081772','3336000','3336000','15000','3351000','3351000','kasir','2026-07-03 10:55:24','F22603105524');
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-03','F226031055241','2026-07-03','10:55:25','TIN','3351000','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-260703-0011','D','2026-07-03','10:55:25','kasir','PENJUALAN','F226031055241','11596322000','3351000','11599673000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3351000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031055241' 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 ('F226031055242','kasir',' 1',' MFD1F 8K B','TOKO','SMBK-D','D1F-ZGXB-46-T','LT MODEL FISH SLEP BG 8K ','OL','1.470','1','100.00','1588000','0','0','15000','1632000','0','7000','0','1639000','TIN','T0080874','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGXB-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='D1F-ZGXB-46-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 ('F226031055242','2026-07-03','1.470','2026-07-03','10:55:25','PLG0081773','1632000','1632000','7000','1639000','1639000','kasir','2026-07-03 10:55:24','F22603105524');
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-03','F226031055242','2026-07-03','10:55:25','TIN','1639000','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-260703-0012','D','2026-07-03','10:55:25','kasir','PENJUALAN','F226031055242','11599673000','1639000','11601312000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1639000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031055242' 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 ('F226031057581','kasir','1',' MEF3E MT ','TOKO','SMBK-F','F3E-ZFBC-34-T','GL KREPYAK HARLEY SLEP MT 8K ','OL','4.290','1','100.00','4569000','0','0','15000','4677000','0','21000','0','4698000','LUS','T0080643','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFBC-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.290',berat_jual_asli=berat_jual_asli+'4.290',stock_jual='1',berat_akhir=berat_akhir-'4.290',berat_akhir_asli=berat_akhir_asli-'4.290',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='F3E-ZFBC-34-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 ('F226031057581','2026-07-03','4.290','2026-07-03','10:57:59','PLG0081774','4677000','4677000','21000','4698000','4698000','kasir','2026-07-03 10:57:58','F22603105758');
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-03','F226031057581','2026-07-03','10:57:59','LUS','4698000','21000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260703-0013','D','2026-07-03','10:57:59','kasir','PENJUALAN','F226031057581','11601312000','4698000','11606010000');
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 ('F226031105401','kasir','1',' MEE2 X HW ','TOKO','SMBK-E','E2E-ZGXA-119-0','CC X MODEL MATA HW 17 8K ','OL','0.500','1','100.00','527000','0','0','15000','548000','0','5000','0','553000','TIN','00411643','E2E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXA-119-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E2E-ZGXA-119-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 ('F226031105401','2026-07-03','0.500','2026-07-03','11:05:41','PLG0081775','548000','548000','5000','553000','553000','kasir','2026-07-03 11:05:40','F22603110540');
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-03','F226031105401','2026-07-03','11:05:41','TIN','553000','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-260703-0014','D','2026-07-03','11:05:41','kasir','PENJUALAN','F226031105401','11606010000','553000','11606563000');
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 ('F226031124311','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-ZFAG-5-0','AT X TIFF ARESO MATA VAR LG 8K ','OL','1.000','1','100.00','1045000','0','0','15000','1070000','0','5000','0','1075000','TIN','00408828','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFAG-5-0' 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-03' AND kode_barang='A1D-ZFAG-5-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 ('F226031124311','2026-07-03','1.000','2026-07-03','11:24:31','PLG0081776','1070000','1070000','5000','1075000','0','kasir','2026-07-03 11:24:31','F22603112431');
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-03','F226031124311','2026-07-03','11:24:31','TIN','1075000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260703-0001','2026-07-03','2026-07-03 11:24:31','PENJUALAN : F226031124311','3765635665','BCA','1075000','1075000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260703-0002','D','2026-07-03','11:24:31','BCA','PENJUALAN','F226031124311','4604075888','1075000','4605150888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('3765635665','FARHAN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1075000' WHERE no_faktur_jual='F226031124311' 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 ('F226031125081','kasir','1',' MEB1E BW ','TOKO','SMBK-B','B1E-ZGXB-28-T','GW MODEL KUPU SLEP BW 8K ','OL','0.520','1','100.00','549000','0','0','15000','569000','0','5000','0','574000','TIN','T0080856','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXB-28-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-03' AND kode_barang='B1E-ZGXB-28-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 ('F226031125081','2026-07-03','0.520','2026-07-03','11:25:09','PLG0081777','569000','569000','5000','574000','574000','kasir','2026-07-03 11:25:08','F22603112508');
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-03','F226031125081','2026-07-03','11:25:09','TIN','574000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260703-0015','D','2026-07-03','11:25:09','kasir','PENJUALAN','F226031125081','11606563000','574000','11607137000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='574000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031125081' 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 ('F226031125082','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZGXB-66-T','CC MDOEL ISYANA SLEP LG 14 8K ','OL','0.460','1','100.00','485000','0','0','15000','504000','0','5000','0','509000','TIN','T0080894','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-66-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-03' AND kode_barang='E1E-ZGXB-66-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 ('F226031125082','2026-07-03','0.460','2026-07-03','11:25:09','PLG0081778','504000','504000','5000','509000','509000','kasir','2026-07-03 11:25:08','F22603112508');
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-03','F226031125082','2026-07-03','11:25:09','TIN','509000','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-260703-0016','D','2026-07-03','11:25:09','kasir','PENJUALAN','F226031125082','11607137000','509000','11607646000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='509000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031125082' 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 ('F226031126151','kasir','1',' MFD1F HW ','TOKO','SMBK-D','D1F-ZFBE-80-T','LT MODEL PITA SLEP HW 8K ','OL','0.310','1','100.00','336000','0','0','15000','346000','0','5000','0','351000','TIN','T0080822','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFBE-80-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='D1F-ZFBE-80-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 ('F226031126151','2026-07-03','0.310','2026-07-03','11:26:15','PLG0081779','346000','346000','5000','351000','351000','kasir','2026-07-03 11:26:15','F22603112615');
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-03','F226031126151','2026-07-03','11:26:15','TIN','351000','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-260703-0017','D','2026-07-03','11:26:15','kasir','PENJUALAN','F226031126151','11607646000','351000','11607997000');
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 ('F226031126351','kasir','1',' MEH1 X UB ','TOKO','SMBK-H','H1E-ZFBI-208-0','KL X KOREA UB 42 8K ','OL','1.350','1','100.00','1438000','0','0','15000','1471000','0','7000','0','1478000','TIN','00411200','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFBI-208-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='H1E-ZFBI-208-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 ('F226031126351','2026-07-03','1.350','2026-07-03','11:26:36','PLG0081780','1471000','1471000','7000','1478000','1478000','kasir','2026-07-03 11:26:35','F22603112635');
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-03','F226031126351','2026-07-03','11:26:36','TIN','1478000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260703-0018','D','2026-07-03','11:26:36','kasir','PENJUALAN','F226031126351','11607997000','1478000','11609475000');
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 ('F226031127221','kasir','1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZGXB-22-T','GW MODEL APEL CAT HITAM SLEP LG PE 8K ','OL','0.480','1','100.00','506000','0','0','15000','526000','0','5000','0','531000','TIN','T0080850','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXB-22-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-03' AND kode_barang='B1E-ZGXB-22-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 ('F226031127221','2026-07-03','0.480','2026-07-03','11:27:22','PLG0081781','526000','526000','5000','531000','531000','kasir','2026-07-03 11:27:22','F22603112722');
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-03','F226031127221','2026-07-03','11:27:22','TIN','531000','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-260703-0019','D','2026-07-03','11:27:22','kasir','PENJUALAN','F226031127221','11609475000','531000','11610006000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='531000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031127221' 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 ('F226031127222','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFAI-33-T','CC MODEL DAUN SLEP LG 14 8K ','OL','0.500','1','100.00','532000','0','0','15000','548000','0','5000','0','553000','TIN','T0080533','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-33-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-03' AND kode_barang='E1E-ZFAI-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226031127222','2026-07-03','0.500','2026-07-03','11:27:22','PLG0081782','548000','548000','5000','553000','553000','kasir','2026-07-03 11:27:22','F22603112722');
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-03','F226031127222','2026-07-03','11:27:22','TIN','553000','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-260703-0020','D','2026-07-03','11:27:22','kasir','PENJUALAN','F226031127222','11610006000','553000','11610559000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='553000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031127222' 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 ('F226031127481','kasir','1',' MEE1E LG 2','TOKO','SMBK-E','E1E-ZGXB-56-T','CC MODEL DAUN SLEP LG 20 8K ','OL','0.550','1','100.00','580000','0','0','15000','602000','0','5000','0','607000','TIN','T0080884','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXB-56-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-03' AND kode_barang='E1E-ZGXB-56-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 ('F226031127481','2026-07-03','0.550','2026-07-03','11:27:48','PLG0081783','602000','602000','5000','607000','607000','kasir','2026-07-03 11:27:48','F22603112748');
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-03','F226031127481','2026-07-03','11:27:48','TIN','607000','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-260703-0021','D','2026-07-03','11:27:48','kasir','PENJUALAN','F226031127481','11610559000','607000','11611166000');
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 ('F226031150211','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZDBB-53-T','LT SLOBOK BALOK HURUF BG R 8K ','OL','0.600','1','100.00','651000','0','0','15000','670000','0','5000','0','675000','LUS','T0078843','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDBB-53-T' 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-03' AND kode_barang='D1F-ZDBB-53-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 ('F226031150211','2026-07-03','0.600','2026-07-03','11:50:21','PLG0081784','670000','670000','5000','675000','675000','kasir','2026-07-03 11:50:21','F22603115021');
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-03','F226031150211','2026-07-03','11:50:21','LUS','675000','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-260703-0022','D','2026-07-03','11:50:21','kasir','PENJUALAN','F226031150211','11611166000','675000','11611841000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='675000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031150211' 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 ('F226031150212','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZDAF-44-T','LT SLOBOK BALOK HURUF BG S 8K ','OL','0.630','1','100.00','684000','0','0','15000','702000','0','5000','0','707000','LUS','T0078710','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDAF-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='D1F-ZDAF-44-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 ('F226031150212','2026-07-03','0.630','2026-07-03','11:50:21','PLG0081785','702000','702000','5000','707000','707000','kasir','2026-07-03 11:50:21','F22603115021');
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-03','F226031150212','2026-07-03','11:50:21','LUS','707000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260703-0023','D','2026-07-03','11:50:21','kasir','PENJUALAN','F226031150212','11611841000','707000','11612548000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='707000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031150212' 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 ('F226031150213','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZEXA-28-T','LT SLOBOK BULAT HURUF BG A 8K ','OL','0.650','1','100.00','705000','0','0','15000','725000','0','5000','0','730000','LUS','T0079140','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEXA-28-T' 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-03' AND kode_barang='D1F-ZEXA-28-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 ('F226031150213','2026-07-03','0.650','2026-07-03','11:50:21','PLG0081786','725000','725000','5000','730000','730000','kasir','2026-07-03 11:50:21','F22603115021');
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-03','F226031150213','2026-07-03','11:50:21','LUS','730000','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-260703-0024','D','2026-07-03','11:50:21','kasir','PENJUALAN','F226031150213','11612548000','730000','11613278000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='730000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031150213' 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 ('F226031150591','kasir','1',' TEB1 X HK ','TOKO','TBK-B','B1TE-ZDXD-112-T','GW X TOGE MODEL MATA VAR HK 17K ','OL','0.500','1','100.00','995000','0','0','15000','995000','0','7000','0','1002000','LUS','T0078399','B1TE','0','0','-','0','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-ZDXD-112-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-03' AND kode_barang='B1TE-ZDXD-112-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226031150591','2026-07-03','0.500','2026-07-03','11:51:00','PLG0081787','995000','995000','7000','1002000','1002000','kasir','2026-07-03 11:50:59','F22603115059');
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-03','F226031150591','2026-07-03','11:51:00','LUS','1002000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260703-0025','D','2026-07-03','11:51:00','kasir','PENJUALAN','F226031150591','11613278000','1002000','11614280000');
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 ('F226031201351','kasir','1',' MEE1 X HT ','TOKO','SMBK-E','E1E-ZFBI-115-0','CC X PIPA MATA HT 12 8K ','OL','0.500','1','100.00','532000','0','0','15000','550000','0','5000','0','555000','TIN','00411107','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBI-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1E-ZFBI-115-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 ('F226031201351','2026-07-03','0.500','2026-07-03','12:01:36','PLG0081788','550000','550000','5000','555000','555000','kasir','2026-07-03 12:01:35','F22603120135');
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-03','F226031201351','2026-07-03','12:01:36','TIN','555000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260703-0026','D','2026-07-03','12:01:36','kasir','PENJUALAN','F226031201351','11614280000','555000','11614835000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031201351' 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 ('F226031201352','kasir',' 1',' MDE1 CM 18','TOKO','SMBK-E','E1D-ZFBG-65-0','CC WEDDING C SLEP CM 18 8K ','OL','1.050','1','100.00','1108000','0','0','15000','1129000','0','5000','0','1134000','TIN','00410675','E1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFBG-65-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1D-ZFBG-65-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 ('F226031201352','2026-07-03','1.050','2026-07-03','12:01:36','PLG0081789','1129000','1129000','5000','1134000','1134000','kasir','2026-07-03 12:01:35','F22603120135');
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-03','F226031201352','2026-07-03','12:01:36','TIN','1134000','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-260703-0027','D','2026-07-03','12:01:36','kasir','PENJUALAN','F226031201352','11614835000','1134000','11615969000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1134000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031201352' 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 ('F226031201353','kasir',' 1',' MFD1F X BG','TOKO','SMBK-D','D1F-ZFBI-40-0','LT X MODEL BUNGA SLEP BG 8K ','OL','0.650','1','100.00','712000','0','0','15000','728000','0','5000','0','733000','TIN','00411032','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFBI-40-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-03' AND kode_barang='D1F-ZFBI-40-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 ('F226031201353','2026-07-03','0.650','2026-07-03','12:01:36','PLG0081790','728000','728000','5000','733000','733000','kasir','2026-07-03 12:01:35','F22603120135');
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-03','F226031201353','2026-07-03','12:01:36','TIN','733000','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-260703-0028','D','2026-07-03','12:01:36','kasir','PENJUALAN','F226031201353','11615969000','733000','11616702000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='733000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031201353' 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 ('F226031236461','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZFAF-13-T','GL MODEL SIEM SLEP UB 8K ','OL','0.580','1','100.00','618000','0','0','15000','626000','0','5000','0','631000','TIN','T0080448','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAF-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='F3E-ZFAF-13-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 ('F226031236461','2026-07-03','0.580','2026-07-03','12:36:46','PLG0081791','626000','626000','5000','631000','631000','kasir','2026-07-03 12:36:46','F22603123646');
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-03','F226031236461','2026-07-03','12:36:46','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) VALUES ('KM-260703-0029','D','2026-07-03','12:36:46','kasir','PENJUALAN','F226031236461','11616702000','631000','11617333000');
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 ('F226031237221','kasir','1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFBD-22-T','GW TUSUK MATA SLEP CM 8K ','OL','0.230','1','100.00','254000','0','0','15000','258000','0','5000','0','263000','TIN','T0080710','B1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFBD-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.230',berat_jual_asli=berat_jual_asli+'0.230',stock_jual='1',berat_akhir=berat_akhir-'0.230',berat_akhir_asli=berat_akhir_asli-'0.230',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='B1G-ZFBD-22-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 ('F226031237221','2026-07-03','0.230','2026-07-03','12:37:23','PLG0081792','258000','258000','5000','263000','263000','kasir','2026-07-03 12:37:22','F22603123722');
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-03','F226031237221','2026-07-03','12:37:23','TIN','263000','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-260703-0030','D','2026-07-03','12:37:23','kasir','PENJUALAN','F226031237221','11617333000','263000','11617596000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='263000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031237221' 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 ('F226031237222','kasir',' 1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFBD-27-T','GW TUSUK MATA SLEP CM 8K ','OL','0.230','1','100.00','254000','0','0','15000','258000','0','5000','0','263000','TIN','T0080715','B1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFBD-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.230',berat_jual_asli=berat_jual_asli+'0.230',stock_jual='1',berat_akhir=berat_akhir-'0.230',berat_akhir_asli=berat_akhir_asli-'0.230',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='B1G-ZFBD-27-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 ('F226031237222','2026-07-03','0.230','2026-07-03','12:37:23','PLG0081793','258000','258000','5000','263000','263000','kasir','2026-07-03 12:37:22','F22603123722');
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-03','F226031237222','2026-07-03','12:37:23','TIN','263000','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-260703-0031','D','2026-07-03','12:37:23','kasir','PENJUALAN','F226031237222','11617596000','263000','11617859000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='263000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031237222' 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 ('F226031237223','kasir',' 1',' MEB1E BW ','TOKO','SMBK-B','B1E-ZGXB-34-T','GW MODEL KUPU SLEP BW 8K ','OL','0.500','1','100.00','527000','0','0','15000','540000','0','5000','0','545000','TIN','T0080862','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXB-34-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-03' AND kode_barang='B1E-ZGXB-34-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 ('F226031237223','2026-07-03','0.500','2026-07-03','12:37:23','PLG0081794','540000','540000','5000','545000','545000','kasir','2026-07-03 12:37:22','F22603123722');
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-03','F226031237223','2026-07-03','12:37:23','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-260703-0032','D','2026-07-03','12:37:23','kasir','PENJUALAN','F226031237223','11617859000','545000','11618404000','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='F226031237223' 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 ('F226031238061','kasir','1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZFBD-23-T','GW TUSUK MATA SLEP CM 8K ','OL','0.220','1','100.00','243000','0','0','15000','246000','0','5000','0','251000','TIN','T0080711','B1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFBD-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.220',berat_jual_asli=berat_jual_asli+'0.220',stock_jual='1',berat_akhir=berat_akhir-'0.220',berat_akhir_asli=berat_akhir_asli-'0.220',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='B1G-ZFBD-23-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226031238061','2026-07-03','0.220','2026-07-03','12:38:06','PLG0081795','246000','246000','5000','251000','251000','kasir','2026-07-03 12:38:06','F22603123806');
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-03','F226031238061','2026-07-03','12:38:06','TIN','251000','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-260703-0033','D','2026-07-03','12:38:06','kasir','PENJUALAN','F226031238061','11618404000','251000','11618655000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='251000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031238061' 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 ('F226031238062','kasir',' 1',' MFD1F 8K B','TOKO','SMBK-D','D1F-ZGXB-48-T','LT MODEL FISH SLEP BG 8K ','OL','1.500','1','100.00','1620000','0','0','15000','1642000','0','8000','0','1650000','TIN','T0080876','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGXB-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='D1F-ZGXB-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226031238062','2026-07-03','1.500','2026-07-03','12:38:06','PLG0081796','1642000','1642000','8000','1650000','1650000','kasir','2026-07-03 12:38:06','F22603123806');
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-03','F226031238062','2026-07-03','12:38:06','TIN','1650000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260703-0034','D','2026-07-03','12:38:06','kasir','PENJUALAN','F226031238062','11618655000','1650000','11620305000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226031238062' 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 ('F226030127501','kasir','1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZGXB-24-T','GW MODEL APEL CAT HITAM SLEP LG PE 8K ','OL','0.470','1','100.00','496000','0','0','15000','508000','0','5000','0','513000','LUS','T0080852','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXB-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='B1E-ZGXB-24-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 ('F226030127501','2026-07-03','0.470','2026-07-03','13:27:50','PLG0081797','508000','508000','5000','513000','513000','kasir','2026-07-03 13:27:50','F22603012750');
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-03','F226030127501','2026-07-03','13:27:50','LUS','513000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260703-0035','D','2026-07-03','13:27:50','kasir','PENJUALAN','F226030127501','11620305000','513000','11620818000');
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 ('F226030128411','kasir','1',' MJF4J X UB','TOKO','SMBK-F','F4J-XKXB-243-0','GL X GUCCI UB 9K ','OL','0.900','1','100.00','1066000','0','0','15000','1062000','0','5000','0','1067000','LUS','00324839','F4J','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4J-XKXB-243-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='F4J-XKXB-243-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 ('F226030128411','2026-07-03','0.900','2026-07-03','13:28:41','PLG0081798','1062000','1062000','5000','1067000','1067000','kasir','2026-07-03 13:28:41','F22603012841');
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-03','F226030128411','2026-07-03','13:28:41','LUS','1067000','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-260703-0036','D','2026-07-03','13:28:41','kasir','PENJUALAN','F226030128411','11620818000','1067000','11621885000');
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 ('F226030129501','kasir','1',' MFE1 X BW ','TOKO','SMBK-E','E1F-ZEBH-416-0','CC X MODEL SLEP BW 12 8K ','OL','0.400','1','100.00','434000','0','0','15000','432000','0','5000','0','437000','LUS','00405634','E1F','0','0','-','1','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZEBH-416-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1F-ZEBH-416-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 ('F226030129501','2026-07-03','0.400','2026-07-03','13:29:51','PLG0081799','432000','432000','5000','437000','437000','kasir','2026-07-03 13:29:50','F22603012950');
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-03','F226030129501','2026-07-03','13:29:51','LUS','437000','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-260703-0037','D','2026-07-03','13:29:51','kasir','PENJUALAN','F226030129501','11621885000','437000','11622322000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='437000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030129501' 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 ('F226030129502','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBH-89-T','CC MODEL ISYANA SLEP LG 12 8K ','OL','0.420','1','100.00','447000','0','0','15000','455000','0','5000','0','460000','LUS','T0080030','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-89-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1E-ZEBH-89-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 ('F226030129502','2026-07-03','0.420','2026-07-03','13:29:51','PLG0081800','455000','455000','5000','460000','460000','kasir','2026-07-03 13:29:50','F22603012950');
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-03','F226030129502','2026-07-03','13:29:51','LUS','460000','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-260703-0038','D','2026-07-03','13:29:51','kasir','PENJUALAN','F226030129502','11622322000','460000','11622782000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='460000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030129502' 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 ('F226030130271','kasir','1',' MEE1 5K BM','TOKO','SMBK-E','E1E-ZFAI-3-T','CC MODEL CAT SLEP BM 12 8K ','OL','0.520','1','100.00','554000','0','0','15000','562000','0','5000','0','567000','LUS','T0080503','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-3-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-03' AND kode_barang='E1E-ZFAI-3-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 ('F226030130271','2026-07-03','0.520','2026-07-03','13:30:28','PLG0081801','562000','562000','5000','567000','567000','kasir','2026-07-03 13:30:27','F22603013027');
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-03','F226030130271','2026-07-03','13:30:28','LUS','567000','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-260703-0039','D','2026-07-03','13:30:28','kasir','PENJUALAN','F226030130271','11622782000','567000','11623349000');
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 ('F226030151581','kasir','1',' TDE1 X CM ','TOKO','TBK-E','E1TD-YLAA-45-T','CC COR VELG POLOS 20 CM 17K','','2.000','1','100.00','3940000','0','0','15000','3880000','0','0','0','3880000','TIN','T0075703','E1TD','0','0','-','1','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YLAA-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1TD-YLAA-45-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 ('F226030151581','2026-07-03','2.000','2026-07-03','13:51:59','PLG0081802','3880000','3880000','0','3880000','3880000','kasir','2026-07-03 13:51:58','F22603015158');
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-03','F226030151581','2026-07-03','13:51:59','TIN','3880000','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-260703-0040','D','2026-07-03','13:51:59','kasir','PENJUALAN','F226030151581','11623349000','3880000','11627229000');
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 ('F226030202231','kasir','1',' MEE1 X MJ ','TOKO','SMBK-E','E1E-ZGXA-126-0','CC X MODEL SLEP MJ 16 8K ','OL','0.740','1','100.00','781000','0','0','15000','799000','0','5000','0','804000','TIN','00411650','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-126-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.740',berat_jual_asli=berat_jual_asli+'0.740',stock_jual='1',berat_akhir=berat_akhir-'0.740',berat_akhir_asli=berat_akhir_asli-'0.740',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1E-ZGXA-126-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 ('F226030202231','2026-07-03','0.740','2026-07-03','14:02:24','PLG0081803','799000','799000','5000','804000','804000','kasir','2026-07-03 14:02:23','F22603020223');
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-03','F226030202231','2026-07-03','14:02:24','TIN','804000','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-260703-0041','D','2026-07-03','14:02:24','kasir','PENJUALAN','F226030202231','11627229000','804000','11628033000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='804000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030202231' 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 ('F226030202232','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZECX-60-T','GL JEDAR UB 8K ','OL','0.530','1','100.00','564000','0','0','15000','572000','0','5000','0','577000','TIN','T0080126','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZECX-60-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='F3E-ZECX-60-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 ('F226030202232','2026-07-03','0.530','2026-07-03','14:02:24','PLG0081804','572000','572000','5000','577000','577000','kasir','2026-07-03 14:02:23','F22603020223');
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-03','F226030202232','2026-07-03','14:02:24','TIN','577000','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-260703-0042','D','2026-07-03','14:02:24','kasir','PENJUALAN','F226030202232','11628033000','577000','11628610000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='577000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030202232' 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 ('F226030203341','kasir','1',' MEB1E HW ','TOKO','SMBK-B','B1E-ZEBF-5-T','GW ITALY PANJANG MATA VAR HW 8K ','OL','0.530','1','100.00','564000','0','0','15000','572000','0','5000','0','577000','TIN','T0079888','B1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBF-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='B1E-ZEBF-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030203341','2026-07-03','0.530','2026-07-03','14:03:34','PLG0081805','572000','572000','5000','577000','577000','kasir','2026-07-03 14:03:34','F22603020334');
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-03','F226030203341','2026-07-03','14:03:34','TIN','577000','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-260703-0043','D','2026-07-03','14:03:34','kasir','PENJUALAN','F226030203341','11628610000','577000','11629187000');
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 ('F226030205041','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZFBI-169-0','GL X TIFF SPECTRA SERUT VAR UB 8K ','OL','1.600','1','100.00','1704000','0','0','15000','1720000','0','8000','0','1728000','TIN','00411161','F3E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFBI-169-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='F3E-ZFBI-169-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 ('F226030205041','2026-07-03','1.600','2026-07-03','14:05:05','PLG0081806','1720000','1720000','8000','1728000','1728000','kasir','2026-07-03 14:05:04','F22603020504');
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-03','F226030205041','2026-07-03','14:05:05','TIN','1728000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260703-0044','D','2026-07-03','14:05:05','kasir','PENJUALAN','F226030205041','11629187000','1728000','11630915000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1728000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030205041' 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 ('F226030205042','kasir',' 1',' MDA1D UB ','TOKO','SMBK-A','A1D-ZGXB-15-T','AT MODEL ITALY VAR SLEP UB 8K ','OL','0.910','1','100.00','942000','0','0','15000','965000','0','5000','0','970000','TIN','T0080843','A1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZGXB-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='A1D-ZGXB-15-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 ('F226030205042','2026-07-03','0.910','2026-07-03','14:05:05','PLG0081807','965000','965000','5000','970000','970000','kasir','2026-07-03 14:05:04','F22603020504');
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-03','F226030205042','2026-07-03','14:05:05','TIN','970000','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-260703-0045','D','2026-07-03','14:05:05','kasir','PENJUALAN','F226030205042','11630915000','970000','11631885000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='970000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030205042' 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 ('F226030206531','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZEBH-27-T','CC MODEL ISYANA SLEP LG 12 8K ','OL','0.450','1','100.00','479000','0','0','15000','486000','0','5000','0','491000','TIN','T0079968','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1E-ZEBH-27-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 ('F226030206531','2026-07-03','0.450','2026-07-03','14:06:53','PLG0081808','486000','486000','5000','491000','491000','kasir','2026-07-03 14:06:53','F22603020653');
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-03','F226030206531','2026-07-03','14:06:53','TIN','491000','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-260703-0046','D','2026-07-03','14:06:53','kasir','PENJUALAN','F226030206531','11631885000','491000','11632376000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='491000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030206531' 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 ('F226030206532','kasir',' 1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZGXB-123-T','KL KOREA UB 46 8K ','OL','0.960','1','100.00','1013000','0','0','15000','1037000','0','5000','0','1042000','TIN','T0080951','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXB-123-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-03' AND kode_barang='H1E-ZGXB-123-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 ('F226030206532','2026-07-03','0.960','2026-07-03','14:06:53','PLG0081809','1037000','1037000','5000','1042000','1042000','kasir','2026-07-03 14:06:53','F22603020653');
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-03','F226030206532','2026-07-03','14:06:53','TIN','1042000','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-260703-0047','D','2026-07-03','14:06:53','kasir','PENJUALAN','F226030206532','11632376000','1042000','11633418000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1042000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030206532' 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 ('F226030240221','kasir','1',' MEH1E HW 4','TOKO','SMBK-H','H1E-ZFBD-52-T','KL SANTA HATI MATA SLEP HW 42 8K ','OL','2.110','1','100.00','2247000','0','0','15000','2268000','0','11000','0','2279000','TIN','T0080740','H1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFBD-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='H1E-ZFBD-52-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 ('F226030240221','2026-07-03','2.110','2026-07-03','14:40:23','PLG0081810','2268000','2268000','11000','2279000','2279000','kasir','2026-07-03 14:40:22','F22603024022');
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-03','F226030240221','2026-07-03','14:40:23','TIN','2279000','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-260703-0048','D','2026-07-03','14:40:23','kasir','PENJUALAN','F226030240221','11633418000','2279000','11635697000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030240221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030240221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030240221';
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 ('F226030247211','kasir','1',' MFE1F KH 1','TOKO','SMBK-E','E1F-ZGXB-81-T','CC MODEL KUPU SLEP KH 14 8K ','OL','0.350','1','100.00','378000','0','0','15000','385000','0','5000','0','390000','LUS','T0080909','E1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGXB-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1F-ZGXB-81-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 ('F226030247211','2026-07-03','0.350','2026-07-03','14:47:21','PLG0081811','385000','385000','5000','390000','390000','kasir','2026-07-03 14:47:21','F22603024721');
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-03','F226030247211','2026-07-03','14:47:21','LUS','390000','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-260703-0049','D','2026-07-03','14:47:21','kasir','PENJUALAN','F226030247211','11635697000','390000','11636087000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='390000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030247211' 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 ('F226030247212','kasir',' 1',' MEF1E YT 5','TOKO','SMBK-F','F1E-ZGXB-98-T','GL OVAL C SLEP YT 56 8K ','OL','2.200','1','100.00','2321000','0','0','15000','2365000','0','11000','0','2376000','LUS','T0080926','F1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGXB-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='F1E-ZGXB-98-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 ('F226030247212','2026-07-03','2.200','2026-07-03','14:47:21','PLG0081812','2365000','2365000','11000','2376000','2376000','kasir','2026-07-03 14:47:21','F22603024721');
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-03','F226030247212','2026-07-03','14:47:21','LUS','2376000','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-260703-0050','D','2026-07-03','14:47:21','kasir','PENJUALAN','F226030247212','11636087000','2376000','11638463000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2376000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226030247212' 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 ('F226030251211','kasir','1',' TGS1 X UB ','TOKO','TBK-S','S1TG-ZDXD-174-T','AS X EXTENSION UB 17K ','OLS BHBYN','0.400','1','100.00','812000','0','0','15000','831000','0','55000','0','886000','TIN','T0078461','S1TG','0','0','-','0','2030000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1TG-ZDXD-174-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='S1TG-ZDXD-174-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226030251211','2026-07-03','0.400','2026-07-03','14:51:22','PLG0081813','831000','831000','55000','886000','886000','kasir','2026-07-03 14:51:21','F22603025121');
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-03','F226030251211','2026-07-03','14:51:22','TIN','886000','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-260703-0051','D','2026-07-03','14:51:22','kasir','PENJUALAN','F226030251211','11638463000','886000','11639349000');
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 ('F226030303181','kasir','1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFXE-23-T','CC MDOEL ISYANA SLEP LG 14 8K ','OL','0.420','1','100.00','447000','0','0','15000','455000','0','5000','0','460000','LUS','T0080325','E1E','0','0','-','0','1055000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXE-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1E-ZFXE-23-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 ('F226030303181','2026-07-03','0.420','2026-07-03','15:03:18','PLG0081814','455000','455000','5000','460000','460000','kasir','2026-07-03 15:03:18','F22603030318');
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-03','F226030303181','2026-07-03','15:03:18','LUS','460000','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-260703-0052','D','2026-07-03','15:03:18','kasir','PENJUALAN','F226030303181','11639349000','460000','11639809000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030127501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030127501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030127501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030128411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030128411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030128411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030129501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030129501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030129501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030129502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030129502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030129502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030130271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030130271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030130271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030151581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030151581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030151581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030202231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030202231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030202231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030202232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030202232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030202232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030203341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030203341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030203341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030205041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030205041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030205041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030205042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030205042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030205042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030206531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030206531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030206531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030206532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030206532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030206532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030848541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030848541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030848541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030921581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030921581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030921581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030921582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030921582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030921582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030924461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030924461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030924461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031002021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031002021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031002021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031010481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031010481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031010481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031010482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031010482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031010482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031039081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031039081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031039081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031050311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031050311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031050311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031055241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031055241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031055241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031055242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031055242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031055242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031057581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031057581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031057581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031105401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031105401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031105401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031124311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031124311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031124311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031125081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031125081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031125081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031125082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031125082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031125082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031126151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031126151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031126151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031126351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031126351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031126351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031127221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031127221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031127221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031127222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031127222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031127222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031127481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031127481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031127481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031150211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031150211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031150211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031150212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031150212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031150212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031150213' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031150213' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031150213';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031150591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031150591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031150591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031201351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031201351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031201351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031201352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031201352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031201352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031201353' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031201353' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031201353';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031236461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031236461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031236461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031237221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031237221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031237221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031237222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031237222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031237222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031237223' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031237223' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031237223';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031238061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031238061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031238061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226031238062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226031238062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226031238062';
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-00005498','X-00005498','AT X MODEL HATI MATA VAR LG 17K','GR','---','A1TE','BELI','BELI001','1140000','2026-07-03','0.640','1','admin','2026-07-03 15:13:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00005498','X-00005498');
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-260703-0001','F226070124201','TIN','1','BELI','BELI001','A1TE', 'X-00005498', 'AT X MODEL HATI MATA VAR LG 17K','0.650','0.640','100.00','1326000','1140000','1781250','1990000','1','1140000','1140000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.640',berat_beli_asli=berat_beli_asli+'0.640',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.640',berat_akhir_asli=berat_akhir_asli+'0.640',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TE' 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-260703-0001','2026-07-03','2026-07-03','15:13:31','TIN','---','0.640','1140000','1140000','1140000','1140000','1140000','admin','2026-07-03 15:13:32','FB-260703-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260703-0001','FAUS','PARINGAN JENANGAN','','','081235121500','admin','2026-07-03 15:13:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-03' 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-260703-0053','K','2026-07-03','15:13:31','admin','PEMBELIAN UMUM','FB-260703-0001','11639809000','1140000','11638669000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030247211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030247211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030247211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030247212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030247212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030247212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030251211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030251211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030251211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030303181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030303181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030303181';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260703-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260703-0001';
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 ('F270010700001','+85294418985','1',' TEF3 X HW ','TOKO','TBK-F','F3TE-ZEBB-66-T','GL X HERLEY DOBEL SLEP HW 17K ','','3.010','1','100.00','5990000','0','0','15000','5900000','0','0','0','5900000','LUS','T0079829','F3TE','0','0','','1','1990000');
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 ('F226030353371','kasir','1',' TEF3 X HW ','TOKO','TBK-F','F3TE-ZEBB-66-T','GL X HERLEY DOBEL SLEP HW 17K ','','3.010','1','100.00','5990000','0','0','15000','5900000','0','0','0','5900000','LUS','T0079829','F3TE','0','0','-','1','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZEBB-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='F3TE-ZEBB-66-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226030353371','2026-07-03','3.010','2026-07-03','15:53:37','PLG0081816','5900000','5900000','0','5900000','5900000','kasir','2026-07-03 15:53:37','F22603035337');
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-03','F226030353371','2026-07-03','15:53:37','LUS','5900000','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-260703-0054','D','2026-07-03','15:53:37','kasir','PENJUALAN','F226030353371','11638669000','5900000','11644569000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030353371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030353371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030353371';
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 ('F226030413401','kasir','1',' MDE1D HW 1','TOKO','SMBK-E','E1D-ZFAI-4-T','CC MODEL SLEP HW 13 8K ','','1.030','1','100.00','1076000','0','0','15000','1082000','0','0','0','1082000','LUS','T0080504','E1D','0','0','-','0','1035000');
UPDATE tm_barang SET tgl_last_jual='2026-07-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZFAI-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-07-03' AND kode_barang='E1D-ZFAI-4-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 ('F226030413401','2026-07-03','1.030','2026-07-03','16:13:40','PLG0081817','1082000','1082000','0','1082000','1082000','kasir','2026-07-03 16:13:40','F22603041340');
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-03','F226030413401','2026-07-03','16:13:40','LUS','1082000','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-260703-0055','D','2026-07-03','16:13:40','kasir','PENJUALAN','F226030413401','11644569000','1082000','11645651000');
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-00005499','X-00005499','CC WEDDING MATA 16 CM 8K','GR','---','E2D','BELI','BELI001','822000','2026-07-03','0.870','1','kasir','2026-07-03 16:16:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005499','X-00005499');
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-260703-0002','F226180402321','LUS','1','BELI','BELI001','E2D', 'X-00005499', 'CC WEDDING MATA 16 CM 8K','0.870','0.870','100.00','953000','822000','944828','1035000','1','822000','822000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.870',berat_beli_asli=berat_beli_asli+'0.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.870',berat_akhir_asli=berat_akhir_asli+'0.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-260703-0002','2026-07-03','2026-07-03','16:16:26','LUS','---','0.870','822000','822000','822000','822000','822000','kasir','2026-07-03 16:16:26','FB-260703-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260703-0002','SUSI','PONDOK BABATAN','','','081335445965','kasir','2026-07-03 16:16:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-03' 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-260703-0056','K','2026-07-03','16:16:26','kasir','PEMBELIAN UMUM','FB-260703-0002','11645651000','822000','11644829000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226030413401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226030413401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226030413401';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260703-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260703-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-03';
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-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-03';
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-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-03' 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-260704-0001','D','2026-07-04','16:19:25','SYSTEM','SALDO AWAL','SALDO AWAL','0','11644829000','11644829000');
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-260704-0001','D','2026-07-04','16:19:25','BCA','SALDO AWAL','SALDO AWAL','0','4605150888','4605150888');
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-260704-0001','D','2026-07-04','16:19:25','','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-260704-0001','D','2026-07-04','16:19:25','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-260704-0001','D','2026-07-04','16:19:25','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260704-0001','D','2026-07-04','16:19:25','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-04';