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 ('F225190752551','kasir','1',' MEE1 X LG ','TOKO','SMBK-E','E1E-XHAD-90-0','CC X POLOS LG 16 8K ','','2.180','1','100.00','2001000','0','0','15000','1964000','0','0','0','1964000','RHM','00312108','E1E','0','0','-','1','918000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-XHAD-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='E1E-XHAD-90-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225190752551','2025-09-19','2.180','2025-09-19','07:52:56','PLG0072777','1964000','1964000','0','1964000','1964000','kasir','2025-09-19 07:52:55','F22519075255');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190752551','2025-09-19','07:52:56','RHM','1964000','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-250919-0002','D','2025-09-19','07:52:56','kasir','PENJUALAN','F225190752551','427949000','1964000','429913000');
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 ('F225190928501','kasir','1',' MDE2 CM 14','TOKO','SMBK-E','E2D-YEBX-43-T','CC MODEL MATA VAR CM 14 8K ','','1.120','1','100.00','1009000','0','0','15000','1010000','0','0','0','1010000','RTA','T0069415','E2D','0','0','-','0','901000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEBX-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='E2D-YEBX-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225190928501','2025-09-19','1.120','2025-09-19','09:28:51','PLG0072778','1010000','1010000','0','1010000','1010000','kasir','2025-09-19 09:28:50','F22519092850');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190928501','2025-09-19','09:28:51','RTA','1010000','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-250919-0003','D','2025-09-19','09:28:51','kasir','PENJUALAN','F225190928501','429913000','1010000','430923000');
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 ('F225190929321','kasir','1',' MFA1 HW ','TOKO','SMBK-A','A1F-YHAC-143-T','AT MODEL ITALY PANJANG VAR HW 8K ','','0.810','1','100.00','757000','0','0','15000','757000','0','0','0','757000','RTA','T0072283','A1F','0','0','-','0','935000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YHAC-143-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='A1F-YHAC-143-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 ('F225190929321','2025-09-19','0.810','2025-09-19','09:29:33','PLG0072779','757000','757000','0','757000','0','kasir','2025-09-19 09:29:32','F22519092932');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190929321','2025-09-19','09:29:33','RTA','757000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-250919-0001','2025-09-19','2025-09-19 09:29:32','PENJUALAN : F225190929321','92384792384579','BCA','757000','757000','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-250919-0002','D','2025-09-19','09:29:33','BCA','PENJUALAN','F225190929321','3991490888','757000','3992247888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('92384792384579','FRISKA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='757000' WHERE no_faktur_jual='F225190929321' 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 ('F225191041251','kasir','1',' MEE2 10K U','TOKO','SMBK-E','E2E-YFAB-8-T','CC MODEL BONEKA CAT MATA VAR UB 18 8K ','','0.960','1','100.00','881000','0','0','15000','882000','0','10000','0','892000','TJ','T0069947','E2E','0','0','-','0','918000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YFAB-8-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='2025-09-19' AND kode_barang='E2E-YFAB-8-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 ('F225191041251','2025-09-19','0.960','2025-09-19','10:41:26','PLG0072780','882000','882000','10000','892000','892000','kasir','2025-09-19 10:41:25','F22519104125');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225191041251','2025-09-19','10:41:26','TJ','892000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250919-0004','D','2025-09-19','10:41:26','kasir','PENJUALAN','F225191041251','430923000','892000','431815000');
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 ('F225191101301','kasir','1',' TDE1 UB 13','TOKO','TBK-E','E1TD-YHBG-8-T','CC MODEL DAUN SLEP VAR UB 13 17K ','','1.180','1','100.00','1886000','0','0','15000','1886000','0','0','0','1886000','TIN','T0072600','E1TD','0','0','-','0','1598000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YHBG-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='E1TD-YHBG-8-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 ('F225191101301','2025-09-19','1.180','2025-09-19','11:01:30','PLG0072781','1886000','1886000','0','1886000','1886000','kasir','2025-09-19 11:01:30','F22519110130');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225191101301','2025-09-19','11:01:30','TIN','1886000','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-250919-0005','D','2025-09-19','11:01:30','kasir','PENJUALAN','F225191101301','431815000','1886000','433701000');
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 ('F225191117371','kasir','1',' MEH1 X HW ','TOKO','SMBK-H','H1E-YIAE-313-0','KL X SANTA AUREL MATA HW 42 8K ','OL','2.300','1','100.00','2111000','0','0','15000','2120000','0','15000','0','2135000','NS','00369764','H1E','0','0','-','0','918000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIAE-313-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='H1E-YIAE-313-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 ('F225191117371','2025-09-19','2.300','2025-09-19','11:17:38','PLG0072782','2120000','2120000','15000','2135000','2135000','kasir','2025-09-19 11:17:37','F22519111737');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225191117371','2025-09-19','11:17:38','NS','2135000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250919-0006','D','2025-09-19','11:17:38','kasir','PENJUALAN','F225191117371','433701000','2135000','435836000');
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 ('F225191155091','kasir','1',' MEE1 6K CM','TOKO','SMBK-E','E1E-YIAB-287-0','CC MODEL KRAWANG RIBBON SLEP CM 11 8K ','OL','0.680','1','100.00','624000','0','0','15000','634000','0','6000','0','640000','TJ','00369064','E1E','0','0','-','0','918000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YIAB-287-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='E1E-YIAB-287-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 ('F225191155091','2025-09-19','0.680','2025-09-19','11:55:10','PLG0072783','634000','634000','6000','640000','640000','kasir','2025-09-19 11:55:09','F22519115509');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225191155091','2025-09-19','11:55:10','TJ','640000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250919-0007','D','2025-09-19','11:55:10','kasir','PENJUALAN','F225191155091','435836000','640000','436476000');
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 ('F225191155321','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YGBD-51-T','CC PIPA MODEL MATA VAR HTM 14 8K ','OL','0.500','1','100.00','459000','0','0','15000','467000','0','5000','0','472000','TJ','T0071479','E2E','0','0','-','0','918000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YGBD-51-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='2025-09-19' AND kode_barang='E2E-YGBD-51-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 ('F225191155321','2025-09-19','0.500','2025-09-19','11:55:32','PLG0072784','467000','467000','5000','472000','472000','kasir','2025-09-19 11:55:32','F22519115532');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225191155321','2025-09-19','11:55:32','TJ','472000','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-250919-0008','D','2025-09-19','11:55:32','kasir','PENJUALAN','F225191155321','436476000','472000','436948000');
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 ('F225190204021','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-YFAD-298-0','GL X SANTA AUREL MATA SERUT HW 8K ','OL','2.290','1','100.00','2102000','0','0','15000','2114000','0','11000','0','2125000','RTA','00357578','F3E','0','0','-','0','918000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFAD-298-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.290',berat_jual_asli=berat_jual_asli+'2.290',stock_jual='1',berat_akhir=berat_akhir-'2.290',berat_akhir_asli=berat_akhir_asli-'2.290',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='F3E-YFAD-298-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 ('F225190204021','2025-09-19','2.290','2025-09-19','14:04:02','PLG0072785','2114000','2114000','11000','2125000','2125000','kasir','2025-09-19 14:04:02','F22519020402');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190204021','2025-09-19','14:04:02','RTA','2125000','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-250919-0009','D','2025-09-19','14:04:02','kasir','PENJUALAN','F225190204021','436948000','2125000','439073000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2125000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225190204021' 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 ('F225190204022','kasir',' 1',' MEH1 X HW ','TOKO','SMBK-H','H1E-YHAC-118-0','KL X SANTA AUREL MATA HW 42 8K ','OL','2.190','1','100.00','2010000','0','0','15000','2021000','0','11000','0','2032000','RTA','00365488','H1E','0','0','-','0','918000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHAC-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='H1E-YHAC-118-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 ('F225190204022','2025-09-19','2.190','2025-09-19','14:04:02','PLG0072786','2021000','2021000','11000','2032000','2032000','kasir','2025-09-19 14:04:02','F22519020402');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190204022','2025-09-19','14:04:02','RTA','2032000','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-250919-0010','D','2025-09-19','14:04:02','kasir','PENJUALAN','F225190204022','439073000','2032000','441105000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2032000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225190204022' 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 ('F225190204023','kasir',' 1',' MFA1 HW ','TOKO','SMBK-A','A1F-YGAH-1-T','AT MODEL ITALY PANJANG VAR HW 8K ','OL','1.130','1','100.00','1057000','0','0','15000','1062000','0','6000','0','1068000','RTA','T0071032','A1F','0','0','-','0','935000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YGAH-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='A1F-YGAH-1-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225190204023','2025-09-19','1.130','2025-09-19','14:04:02','PLG0072787','1062000','1062000','6000','1068000','1068000','kasir','2025-09-19 14:04:02','F22519020402');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190204023','2025-09-19','14:04:02','RTA','1068000','6000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250919-0011','D','2025-09-19','14:04:02','kasir','PENJUALAN','F225190204023','441105000','1068000','442173000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1068000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225190204023' 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 ('F225190231281','kasir','1',' TEF1 X YT ','TOKO','TBK-F','F1TE-XGAC-30-T','GL X OVAL MODEL C YT D58 17K ','OL','8.480','1','100.00','13695000','0','0','15000','13783000','0','40000','0','13823000','NS','T0059310','F1TE','0','0','-','0','1615000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-XGAC-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.480',berat_jual_asli=berat_jual_asli+'8.480',stock_jual='1',berat_akhir=berat_akhir-'8.480',berat_akhir_asli=berat_akhir_asli-'8.480',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='F1TE-XGAC-30-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 ('F225190231281','2025-09-19','8.480','2025-09-19','14:31:28','PLG0072788','13783000','13783000','40000','13823000','13823000','kasir','2025-09-19 14:31:28','F22519023128');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190231281','2025-09-19','14:31:28','NS','13823000','40000');
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-250919-0012','D','2025-09-19','14:31:28','kasir','PENJUALAN','F225190231281','442173000','13823000','455996000');
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 ('F225190307031','kasir','1',' TDE2 X CM ','TOKO','TBK-E','E2TD-YIXD-67-T','CC X MODEL MATA VAR CM 14 17K ','','1.850','1','100.00','2956000','0','0','15000','2966000','0','10000','0','2976000','TIN','T0072919','E2TD','0','0','-','0','1598000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YIXD-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='E2TD-YIXD-67-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 ('F225190307031','2025-09-19','1.850','2025-09-19','15:07:04','PLG0072789','2966000','2966000','10000','2976000','2976000','kasir','2025-09-19 15:07:03','F22519030703');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190307031','2025-09-19','15:07:04','TIN','2976000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250919-0013','D','2025-09-19','15:07:04','kasir','PENJUALAN','F225190307031','455996000','2976000','458972000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2976000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225190307031' 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 ('F225190307032','kasir',' 1',' TEF3 UB ','TOKO','TBK-F','F3TE-YDAA-10-T','GL RANTAI HOLLOW PLAT UB 17K ','','2.040','1','100.00','3295000','0','0','15000','3305000','0','0','0','3305000','TIN','T0068619','F3TE','0','0','-','0','1615000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YDAA-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='F3TE-YDAA-10-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 ('F225190307032','2025-09-19','2.040','2025-09-19','15:07:04','PLG0072790','3305000','3305000','0','3305000','3305000','kasir','2025-09-19 15:07:03','F22519030703');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190307032','2025-09-19','15:07:04','TIN','3305000','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-250919-0014','D','2025-09-19','15:07:04','kasir','PENJUALAN','F225190307032','458972000','3305000','462277000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3305000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225190307032' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190204021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190204021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190204021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190204022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190204022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190204022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190204023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190204023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190204023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190231281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190231281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190231281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190307031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190307031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190307031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190307032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190307032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190307032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190752551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190752551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190752551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190928501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190928501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190928501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190929321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190929321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190929321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225191041251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225191041251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225191041251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225191101301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225191101301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225191101301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225191117371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225191117371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225191117371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225191155091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225191155091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225191155091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225191155321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225191155321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225191155321';
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-00004649','X-00004649','CC WEDDING MATA CM 10 8K','GR','---','E2D','BELI','BELI001','1217000','2025-09-19','2.010','1','kasir','2025-09-19 15:18:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004649','X-00004649');
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-250919-0001','F225031003411','NS','1','BELI','BELI001','E2D', 'X-00004649', 'CC WEDDING MATA CM 10 8K','2.010','2.010','100.00','1323000','1217000','605473','901000','1','1217000','1217000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.010',berat_beli_asli=berat_beli_asli+'2.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.010',berat_akhir_asli=berat_akhir_asli+'2.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-19' 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-250919-0001','2025-09-19','2025-09-19','15:18:09','NS','---','2.010','1217000','1217000','1217000','1217000','1217000','kasir','2025-09-19 15:18:09','FB-250919-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250919-0001','MEI NURUL Q','30/8 KRADINAN DOLOPO','','','085732191017','kasir','2025-09-19 15:18:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-19' 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-250919-0015','K','2025-09-19','15:18:09','kasir','PEMBELIAN UMUM','FB-250919-0001','462277000','1217000','461060000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250919-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250919-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 ('F225190327221','kasir','1',' MDE1 CM 22','TOKO','SMBK-E','E1D-YHBE-11-T','CC VELG POLOS CM 22 8K ','','1.550','1','100.00','1397000','0','0','15000','1397000','0','0','0','1397000','TIN','T0072496','E1D','0','0','-','0','901000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YHBE-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='E1D-YHBE-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225190327221','2025-09-19','1.550','2025-09-19','15:27:22','PLG0072791','1397000','1397000','0','1397000','1397000','kasir','2025-09-19 15:27:22','F22519032722');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190327221','2025-09-19','15:27:22','TIN','1397000','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-250919-0016','D','2025-09-19','15:27:22','kasir','PENJUALAN','F225190327221','461060000','1397000','462457000');
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 ('F225190355351','kasir','1',' MEE2 LG 11','TOKO','SMBK-E','E2E-YIXH-36-T','CC MODEL MATA VAR LG 11 8K ','','0.550','1','100.00','505000','0','0','15000','505000','0','0','0','505000','RTA','T0073045','E2E','0','0','-','0','918000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIXH-36-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='2025-09-19' AND kode_barang='E2E-YIXH-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225190355351','2025-09-19','0.550','2025-09-19','15:55:36','PLG0072792','505000','505000','0','505000','505000','kasir','2025-09-19 15:55:35','F22519035535');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190355351','2025-09-19','15:55:36','RTA','505000','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-250919-0017','D','2025-09-19','15:55:36','kasir','PENJUALAN','F225190355351','462457000','505000','462962000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190327221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190327221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190327221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190355351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190355351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190355351';
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 ('F225190414371','kasir','1',' TEF3 UB ','TOKO','TBK-F','F3TE-YGBI-129-T','GL RANTAI HOLLOW SIRIP VAR UB 17K ','OLS 5R4J','1.450','1','100.00','2342000','0','0','15000','2342000','0','110000','0','2452000','RHM','T0071662','F3TE','0','0','-','0','1615000');
UPDATE tm_barang SET tgl_last_jual='2025-09-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-YGBI-129-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2025-09-19' AND kode_barang='F3TE-YGBI-129-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 ('F225190414371','2025-09-19','1.450','2025-09-19','16:14:37','PLG0072793','2342000','2342000','110000','2452000','2452000','kasir','2025-09-19 16:14:37','F22519041437');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-19','F225190414371','2025-09-19','16:14:37','RHM','2452000','110000');
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-250919-0018','D','2025-09-19','16:14:37','kasir','PENJUALAN','F225190414371','462962000','2452000','465414000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225190414371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225190414371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225190414371';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-19';
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='2025-09-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-19' 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-250920-0001','D','2025-09-20','16:22:51','SYSTEM','SALDO AWAL','SALDO AWAL','0','465414000','465414000');
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-250920-0001','D','2025-09-20','16:22:51','BCA','SALDO AWAL','SALDO AWAL','0','3992247888','3992247888');
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-250920-0001','D','2025-09-20','16:22:51','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250920-0001','D','2025-09-20','16:22:51','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250920-0001','D','2025-09-20','16:22:51','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-250920-0001','D','2025-09-20','16:22:51','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-09-20';