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 ('F225080941311','kasir','1',' TDE2 CM 18','TOKO','TBK-E','E2TD-YJXC-4-T','CC MODEL MATA VAR CM 18 17K ','OL','1.910','1','100.00','3100000','0','0','15000','3415000','0','13000','0','3428000','RTA','T0073725','E2TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YJXC-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='E2TD-YJXC-4-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 ('F225080941311','2025-10-08','1.910','2025-10-08','09:41:31','PLG0073455','3415000','3415000','13000','3428000','3428000','kasir','2025-10-08 09:41:31','F22508094131');
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-10-08','F225080941311','2025-10-08','09:41:31','RTA','3428000','13000');
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-251008-0002','D','2025-10-08','09:41:31','kasir','PENJUALAN','F225080941311','1224890000','3428000','1228318000');
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 ('F225080952001','kasir','1',' MFE1 X BG ','TOKO','SMBK-E','E1F-YHBB-45-0','CC X MODEL SLEP BG 16 8K ','','1.340','1','100.00','1265000','0','0','15000','1375000','0','0','0','1375000','TJ','00366658','E1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YHBB-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='E1F-YHBB-45-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 ('F225080952001','2025-10-08','1.340','2025-10-08','09:52:01','PLG0073456','1375000','1375000','0','1375000','1375000','kasir','2025-10-08 09:52:00','F22508095200');
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-10-08','F225080952001','2025-10-08','09:52:01','TJ','1375000','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-251008-0003','D','2025-10-08','09:52:01','kasir','PENJUALAN','F225080952001','1228318000','1375000','1229693000');
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 ('F225081027021','kasir','1',' MEF1 UB D5','TOKO','SMBK-F','F1E-YIXD-7-T','GL OVAL MODEL C UB D52 8K ','OL','2.180','1','100.00','2021000','0','0','15000','2202000','0','11000','0','2213000','TJ','T0072859','F1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YIXD-7-T' 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-10-08' AND kode_barang='F1E-YIXD-7-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 ('F225081027021','2025-10-08','2.180','2025-10-08','10:27:03','PLG0073457','2202000','2202000','11000','2213000','0','kasir','2025-10-08 10:27:02','F22508102702');
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-10-08','F225081027021','2025-10-08','10:27:03','TJ','2213000','11000');
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-251008-0001','2025-10-08','2025-10-08 10:27:02','PENJUALAN : F225081027021','762498347049','BCA','2213000','2213000','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-251008-0002','D','2025-10-08','10:27:03','BCA','PENJUALAN','F225081027021','4035027888','2213000','4037240888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('762498347049','DHITA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2213000' WHERE no_faktur_jual='F225081027021' 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 ('F225081027022','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-YIBX-24-T','GL OVAL MODEL C UB D54 8K ','OL','2.140','1','100.00','1984000','0','0','15000','2161000','0','11000','0','2172000','TJ','T0073122','F1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YIBX-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='F1E-YIBX-24-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 ('F225081027022','2025-10-08','2.140','2025-10-08','10:27:03','PLG0073458','2161000','2161000','11000','2172000','0','kasir','2025-10-08 10:27:02','F22508102702');
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-10-08','F225081027022','2025-10-08','10:27:03','TJ','2172000','11000');
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-251008-0002','2025-10-08','2025-10-08 10:27:02','PENJUALAN : F225081027022','762498347049','BCA','2172000','2172000','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-251008-0003','D','2025-10-08','10:27:03','BCA','PENJUALAN','F225081027022','4037240888','2172000','4039412888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('762498347049','DHITA');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081027021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081027021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081027021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081027022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081027022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081027022';
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 ('F225081046191','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YIBI-86-T','LT SLOBOK BALOK HURUF BG A 8K ','OL','0.550','1','100.00','529000','0','0','15000','583000','0','5000','0','588000','RTA','T0073399','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIBI-86-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-10-08' AND kode_barang='D1G-YIBI-86-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 ('F225081046191','2025-10-08','0.550','2025-10-08','10:46:20','PLG0073459','583000','583000','5000','588000','588000','kasir','2025-10-08 10:46:19','F22508104619');
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-10-08','F225081046191','2025-10-08','10:46:20','RTA','588000','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-251008-0004','D','2025-10-08','10:46:20','kasir','PENJUALAN','F225081046191','1229693000','588000','1230281000');
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 ('F225081047401','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJXB-84-T','LT SLOBOK BALOK HURUF BG S 8K ','OL','0.600','1','100.00','610000','0','0','15000','636000','0','5000','0','641000','RTA','T0073664','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXB-84-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='2025-10-08' AND kode_barang='D1G-YJXB-84-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 ('F225081047401','2025-10-08','0.600','2025-10-08','10:47:41','PLG0073460','636000','636000','5000','641000','641000','kasir','2025-10-08 10:47:40','F22508104740');
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-10-08','F225081047401','2025-10-08','10:47:41','RTA','641000','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-251008-0005','D','2025-10-08','10:47:41','kasir','PENJUALAN','F225081047401','1230281000','641000','1230922000');
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 ('F225081053291','kasir','1',' TGPE CM 16','TOKO','TBK-P','PETG-XAXF-14-T','CC WG POLOS CM 16 17K ','','1.510','1','100.00','2528000','0','0','15000','2756000','0','5000','0','2761000','TJ','T0052976','PETG','0','0','-','0','1674000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PETG-XAXF-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='PETG-XAXF-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-P' 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 ('F225081053291','2025-10-08','1.510','2025-10-08','10:53:30','PLG0073461','2756000','2756000','5000','2761000','2761000','kasir','2025-10-08 10:53:29','F22508105329');
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-10-08','F225081053291','2025-10-08','10:53:30','TJ','2761000','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-251008-0006','D','2025-10-08','10:53:30','kasir','PENJUALAN','F225081053291','1230922000','2761000','1233683000');
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 ('F225081119281','kasir','1',' TDE2 X CM ','TOKO','TBK-E','E2TD-YDBC-61-T','CC X MODEL MATA VAR CM 16 17K ','','1.600','1','100.00','2597000','0','0','15000','2832000','0','0','0','2832000','RTA','T0068875','E2TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YDBC-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='E2TD-YDBC-61-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 ('F225081119281','2025-10-08','1.600','2025-10-08','11:19:28','PLG0073462','2832000','2832000','0','2832000','2832000','kasir','2025-10-08 11:19:28','F22508111928');
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-10-08','F225081119281','2025-10-08','11:19:28','RTA','2832000','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-251008-0007','D','2025-10-08','11:19:28','kasir','PENJUALAN','F225081119281','1233683000','2832000','1236515000');
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 ('F225081120411','kasir','1',' MEF3 PM ','TOKO','SMBK-F','F3E-YJXF-66-T','GL MODEL DAUN VAR PM 8K ','','3.140','1','100.00','3068000','0','0','15000','3156000','0','0','0','3156000','RTA','T0073964','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXF-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.140',berat_jual_asli=berat_jual_asli+'3.140',stock_jual='1',berat_akhir=berat_akhir-'3.140',berat_akhir_asli=berat_akhir_asli-'3.140',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='F3E-YJXF-66-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 ('F225081120411','2025-10-08','3.140','2025-10-08','11:20:42','PLG0073463','3156000','3156000','0','3156000','3156000','kasir','2025-10-08 11:20:41','F22508112041');
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-10-08','F225081120411','2025-10-08','11:20:42','RTA','3156000','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-251008-0008','D','2025-10-08','11:20:42','kasir','PENJUALAN','F225081120411','1236515000','3156000','1239671000');
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 ('F225081121281','kasir','1',' MEH1 10K H','TOKO','SMBK-H','H1E-YJXC-63-T','KL SANTA MODEL HATI PASIR HW 8K ','','1.960','1','100.00','1911000','0','0','15000','1970000','0','10000','0','1980000','RTA','T0073784','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXC-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='H1E-YJXC-63-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 ('F225081121281','2025-10-08','1.960','2025-10-08','11:21:28','PLG0073464','1970000','1970000','10000','1980000','1980000','kasir','2025-10-08 11:21:28','F22508112128');
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-10-08','F225081121281','2025-10-08','11:21:28','RTA','1980000','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-251008-0009','D','2025-10-08','11:21:28','kasir','PENJUALAN','F225081121281','1239671000','1980000','1241651000');
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 ('F225081122071','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YIAC-330-0','CC X MODEL MATA CM 18 8K ','','1.800','1','100.00','1638000','0','0','15000','1773000','0','10000','0','1783000','RTA','00369414','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-330-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='E2D-YIAC-330-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 ('F225081122071','2025-10-08','1.800','2025-10-08','11:22:08','PLG0073465','1773000','1773000','10000','1783000','1783000','kasir','2025-10-08 11:22:07','F22508112207');
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-10-08','F225081122071','2025-10-08','11:22:08','RTA','1783000','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-251008-0010','D','2025-10-08','11:22:08','kasir','PENJUALAN','F225081122071','1241651000','1783000','1243434000');
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 ('F225081122421','kasir','1',' MEH1 UB ','TOKO','SMBK-H','H1E-YICX-2-T','KL SANTA MODEL MATA VAR UB 8K ','','2.110','1','100.00','2000000','0','0','15000','2121000','0','0','0','2121000','RTA','T0073414','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YICX-2-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='2025-10-08' AND kode_barang='H1E-YICX-2-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 ('F225081122421','2025-10-08','2.110','2025-10-08','11:22:43','PLG0073466','2121000','2121000','0','2121000','2121000','kasir','2025-10-08 11:22:42','F22508112242');
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-10-08','F225081122421','2025-10-08','11:22:43','RTA','2121000','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-251008-0011','D','2025-10-08','11:22:43','kasir','PENJUALAN','F225081122421','1243434000','2121000','1245555000');
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 ('F225081211341','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YGAG-253-0','CC X SOLITAIRE MATA CM 18 8K ','OLH','1.010','1','100.00','919000','0','0','15000','1020000','0','10000','0','1030000','TJ','00361338','E2D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGAG-253-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='E2D-YGAG-253-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 ('F225081211341','2025-10-08','1.010','2025-10-08','12:11:35','PLG0073467','1020000','1020000','10000','1030000','1030000','kasir','2025-10-08 12:11:34','F22508121134');
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-10-08','F225081211341','2025-10-08','12:11:35','TJ','1030000','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-251008-0012','D','2025-10-08','12:11:35','kasir','PENJUALAN','F225081211341','1245555000','1030000','1246585000');
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 ('F225081212401','kasir','1',' MEA1 CM ','TOKO','SMBK-A','A1E-YJXB-59-T','AT JERSY SLEP CM 8K ','OLH','0.550','1','100.00','537000','0','0','15000','561000','0','8000','0','569000','TJ','T0073639','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXB-59-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-10-08' AND kode_barang='A1E-YJXB-59-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 ('F225081212401','2025-10-08','0.550','2025-10-08','12:12:40','PLG0073468','561000','561000','8000','569000','569000','kasir','2025-10-08 12:12:40','F22508121240');
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-10-08','F225081212401','2025-10-08','12:12:40','TJ','569000','8000');
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-251008-0013','D','2025-10-08','12:12:40','kasir','PENJUALAN','F225081212401','1246585000','569000','1247154000');
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 ('F225081213341','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YHBH-214-T','LT SLOBOK BULAT HURUF BG A 8K ','OLH','0.470','1','100.00','452000','0','0','15000','498000','0','8000','0','506000','TJ','T0072710','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YHBH-214-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='2025-10-08' AND kode_barang='D1G-YHBH-214-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 ('F225081213341','2025-10-08','0.470','2025-10-08','12:13:35','PLG0073469','498000','498000','8000','506000','506000','kasir','2025-10-08 12:13:34','F22508121334');
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-10-08','F225081213341','2025-10-08','12:13:35','TJ','506000','8000');
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-251008-0014','D','2025-10-08','12:13:35','kasir','PENJUALAN','F225081213341','1247154000','506000','1247660000');
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 ('F225081253511','kasir','1',' MEE1 X LG ','TOKO','SMBK-E','E1E-YHBI-120-0','CC X MODEL SLEP LG 12 8K ','OLH','0.530','1','100.00','491000','0','0','15000','544000','0','8000','0','552000','TJ','00367361','E1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHBI-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='E1E-YHBI-120-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 ('F225081253511','2025-10-08','0.530','2025-10-08','12:53:52','PLG0073470','544000','544000','8000','552000','552000','kasir','2025-10-08 12:53:51','F22508125351');
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-10-08','F225081253511','2025-10-08','12:53:52','TJ','552000','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-251008-0015','D','2025-10-08','12:53:52','kasir','PENJUALAN','F225081253511','1247660000','552000','1248212000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='552000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225081253511' 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 ('F225081253512','kasir',' 1',' MGE2 AY 13','TOKO','SMBK-E','E2G-YICX-49-T','CC MODEL MATA VAR AY 13 8K ','OLH','0.350','1','100.00','349000','0','0','15000','373000','0','8000','0','381000','TJ','T0073461','E2G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2G-YICX-49-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='2025-10-08' AND kode_barang='E2G-YICX-49-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 ('F225081253512','2025-10-08','0.350','2025-10-08','12:53:52','PLG0073471','373000','373000','8000','381000','381000','kasir','2025-10-08 12:53:51','F22508125351');
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-10-08','F225081253512','2025-10-08','12:53:52','TJ','381000','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-251008-0016','D','2025-10-08','12:53:52','kasir','PENJUALAN','F225081253512','1248212000','381000','1248593000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='381000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225081253512' 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 ('F225081253513','kasir',' 1',' MEE1 5K HW','TOKO','SMBK-E','E1E-YHAE-52-T','CC LISTRING GELOMBANG CAT HW 13 8K ','OLH','0.600','1','100.00','556000','0','0','15000','615000','0','8000','0','623000','TJ','T0072352','E1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHAE-52-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='2025-10-08' AND kode_barang='E1E-YHAE-52-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 ('F225081253513','2025-10-08','0.600','2025-10-08','12:53:52','PLG0073472','615000','615000','8000','623000','623000','kasir','2025-10-08 12:53:51','F22508125351');
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-10-08','F225081253513','2025-10-08','12:53:52','TJ','623000','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-251008-0017','D','2025-10-08','12:53:52','kasir','PENJUALAN','F225081253513','1248593000','623000','1249216000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='623000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225081253513' 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 ('F225081253514','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJXB-83-T','LT SLOBOK BALOK HURUF BG S 8K ','OLH','0.500','1','100.00','508000','0','0','15000','533000','0','8000','0','541000','TJ','T0073663','D1G','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXB-83-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-10-08' AND kode_barang='D1G-YJXB-83-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225081253514','2025-10-08','0.500','2025-10-08','12:53:52','PLG0073473','533000','533000','8000','541000','541000','kasir','2025-10-08 12:53:51','F22508125351');
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-10-08','F225081253514','2025-10-08','12:53:52','TJ','541000','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-251008-0018','D','2025-10-08','12:53:52','kasir','PENJUALAN','F225081253514','1249216000','541000','1249757000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='541000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225081253514' 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 ('F225081253515','kasir',' 1',' MED2 X LG ','TOKO','SMBK-D','D2E-YDCX-323-0','LT X MODEL HURUF MATA LG Z 8K ','OLH','0.420','1','100.00','389000','0','0','15000','431000','0','8000','0','439000','TJ','00351575','D2E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YDCX-323-0' 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='2025-10-08' AND kode_barang='D2E-YDCX-323-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 ('F225081253515','2025-10-08','0.420','2025-10-08','12:53:52','PLG0073474','431000','431000','8000','439000','439000','kasir','2025-10-08 12:53:51','F22508125351');
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-10-08','F225081253515','2025-10-08','12:53:52','TJ','439000','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-251008-0019','D','2025-10-08','12:53:52','kasir','PENJUALAN','F225081253515','1249757000','439000','1250196000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='439000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225081253515' 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 ('F225081253516','kasir',' 1',' MEH1 UB 42','TOKO','SMBK-H','H1E-YJXF-51-T','KL RANTAI HOLLOW UB 42CM 8K ','OLH','0.780','1','100.00','762000','0','0','15000','800000','0','8000','0','808000','TJ','T0073949','H1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXF-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='H1E-YJXF-51-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 ('F225081253516','2025-10-08','0.780','2025-10-08','12:53:52','PLG0073475','800000','800000','8000','808000','808000','kasir','2025-10-08 12:53:51','F22508125351');
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-10-08','F225081253516','2025-10-08','12:53:52','TJ','808000','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-251008-0020','D','2025-10-08','12:53:52','kasir','PENJUALAN','F225081253516','1250196000','808000','1251004000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='808000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225081253516' 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 ('F225080201461','kasir','1',' MEB1 CM ','TOKO','SMBK-B','B1E-YJXD-81-T','GW SUMPING MODEL DAUN VAR CM 8K ','','0.660','1','100.00','643000','0','0','15000','677000','0','5000','0','682000','TJ','T0073895','B1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-81-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='B1E-YJXD-81-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 ('F225080201461','2025-10-08','0.660','2025-10-08','14:01:46','PLG0073476','677000','677000','5000','682000','682000','kasir','2025-10-08 14:01:46','F22508020146');
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-10-08','F225080201461','2025-10-08','14:01:46','TJ','682000','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-251008-0021','D','2025-10-08','14:01:46','kasir','PENJUALAN','F225080201461','1251004000','682000','1251686000');
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 ('F225080228371','kasir','1',' TDE2 10K C','TOKO','TBK-E','E2TD-YJXC-10-T','CC WEDDING MATA CM 14 17K ','','2.020','1','100.00','3278000','0','0','15000','3596000','0','10000','0','3606000','TJ','T0073731','E2TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YJXC-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='E2TD-YJXC-10-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 ('F225080228371','2025-10-08','2.020','2025-10-08','14:28:38','PLG0073477','3596000','3596000','10000','3606000','0','kasir','2025-10-08 14:28:37','F22508022837');
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-10-08','F225080228371','2025-10-08','14:28:38','TJ','3606000','10000');
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-251008-0003','2025-10-08','2025-10-08 14:28:37','PENJUALAN : F225080228371','7389370498049','BCA','3606000','3606000','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-251008-0004','D','2025-10-08','14:28:38','BCA','PENJUALAN','F225080228371','4039412888','3606000','4043018888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('7389370498049','GHAFUR');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3606000' WHERE no_faktur_jual='F225080228371' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225080228371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225080228371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225080228371';
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 ('F225080233401','kasir','1',' MDE1 PM 16','TOKO','SMBK-E','E1D-YJXD-37-T','CC MODEL DAUN VAR PM 16 8K ','OL','1.010','1','100.00','965000','0','0','15000','1030000','0','5000','0','1035000','RHM','T0073851','E1D','0','0','-','0','960000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJXD-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-10-08' AND kode_barang='E1D-YJXD-37-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 ('F225080233401','2025-10-08','1.010','2025-10-08','14:33:41','PLG0073478','1030000','1030000','5000','1035000','1035000','kasir','2025-10-08 14:33:40','F22508023340');
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-10-08','F225080233401','2025-10-08','14:33:41','RHM','1035000','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-251008-0022','D','2025-10-08','14:33:41','kasir','PENJUALAN','F225080233401','1251686000','1035000','1252721000');
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 ('F225080234111','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YJXD-15-T','AT KLIP BANGKOK SLEP LG 8K ','OL','0.600','1','100.00','585000','0','0','15000','615000','0','5000','0','620000','RHM','T0073829','A1E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-15-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='2025-10-08' AND kode_barang='A1E-YJXD-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 ('F225080234111','2025-10-08','0.600','2025-10-08','14:34:11','PLG0073479','615000','615000','5000','620000','620000','kasir','2025-10-08 14:34:11','F22508023411');
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-10-08','F225080234111','2025-10-08','14:34:11','RHM','620000','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-251008-0023','D','2025-10-08','14:34:11','kasir','PENJUALAN','F225080234111','1252721000','620000','1253341000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225080201461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225080201461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225080201461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225080233401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225080233401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225080233401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225080234111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225080234111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225080234111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225080941311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225080941311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225080941311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225080952001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225080952001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225080952001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081046191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081046191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081046191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081047401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081047401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081047401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081053291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081053291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081053291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081119281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081119281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081119281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081120411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081120411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081120411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081121281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081121281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081121281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081122071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081122071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081122071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081122421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081122421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081122421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081211341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081211341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081211341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081212401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081212401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081212401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081213341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081213341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081213341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081253511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081253512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253513' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253513' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081253513';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253514' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253514' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081253514';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253515' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253515' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081253515';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253516' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225081253516' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225081253516';
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-00004724','X-00004724','CC MODEL HOLLOW SIRIP PASIR CM 16 8K','GR','---','E1D','BELI','BELI001','1540000','2025-10-08','2.110','1','kasir','2025-10-08 15:23:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00004724','X-00004724');
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-251008-0001','F225071151161','RHM','1','BELI','BELI001','E1D', 'X-00004724', 'CC MODEL HOLLOW SIRIP PASIR CM 16 8K','2.110','2.110','100.00','1710000','1540000','729858','960000','1','1540000','1540000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.110',berat_beli_asli=berat_beli_asli+'2.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.110',berat_akhir_asli=berat_akhir_asli+'2.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-251008-0001','2025-10-08','2025-10-08','15:23:35','RHM','---','2.110','1540000','1540000','1540000','1540000','1540000','kasir','2025-10-08 15:23:35','FB-251008-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251008-0001','SRI ENDANG LESTARI','JL PUNTODEWO','','','','kasir','2025-10-08 15:23:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-08' 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-251008-0024','K','2025-10-08','15:23:35','kasir','PEMBELIAN UMUM','FB-251008-0001','1253341000','1540000','1251801000');
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-00004725','X-00004725','LT X SLOBOK BOLA SLEP BG 8K','GR','---','D1F','BELI','BELI001','411000','2025-10-08','0.520','1','kasir','2025-10-08 15:25:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00004725','X-00004725');
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-251008-0002','F225101139562','TJ','1','BELI','BELI001','D1F', 'X-00004725', 'LT X SLOBOK BOLA SLEP BG 8K','0.520','0.520','100.00','447000','411000','790385','1005000','1','411000','411000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251008-0002','2025-10-08','2025-10-08','15:25:08','TJ','---','0.520','411000','411000','411000','411000','411000','kasir','2025-10-08 15:25:09','FB-251008-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251008-0002','MM','','','','','kasir','2025-10-08 15:25:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-08' 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-251008-0025','K','2025-10-08','15:25:08','kasir','PEMBELIAN UMUM','FB-251008-0002','1251801000','411000','1251390000');
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-00004726','X-00004726','GL X OVAL SLEP LT 54 8K','GR','---','F1E','BELI','BELI001','1576000','2025-10-08','2.000','1','kasir','2025-10-08 15:25:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00004726','X-00004726');
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-251008-0003','F225171210443','TJ','2','BELI','BELI001','F1E', 'X-00004726', 'GL X OVAL SLEP LT 54 8K','2.000','2.000','100.00','1714000','1576000','788000','977000','1','1576000','1576000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251008-0003','2025-10-08','2025-10-08','15:25:08','TJ','---','2.000','1576000','1576000','1576000','1576000','1576000','kasir','2025-10-08 15:25:09','FB-251008-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251008-0003','MM','','','','','kasir','2025-10-08 15:25:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-08' 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-251008-0026','K','2025-10-08','15:25:08','kasir','PEMBELIAN UMUM','FB-251008-0003','1251390000','1576000','1249814000');
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-00004727','X-00004727','AT X HUGGIES ARESO VAR UB 8K','GR','---','A1F','BELI','BELI001','943000','2025-10-08','1.300','1','kasir','2025-10-08 15:25:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00004727','X-00004727');
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-251008-0004','F225101146162','TJ','3','BELI','BELI001','A1F', 'X-00004727', 'AT X HUGGIES ARESO VAR UB 8K','1.300','1.300','100.00','1110000','943000','725385','1005000','1','943000','943000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.300',berat_beli_asli=berat_beli_asli+'1.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.300',berat_akhir_asli=berat_akhir_asli+'1.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-08' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-251008-0004','2025-10-08','2025-10-08','15:25:08','TJ','---','1.300','943000','943000','943000','943000','943000','kasir','2025-10-08 15:25:09','FB-251008-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251008-0004','IDA SURYA','','','','','kasir','2025-10-08 15:25:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-08' 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-251008-0027','K','2025-10-08','15:25:08','kasir','PEMBELIAN UMUM','FB-251008-0004','1249814000','943000','1248871000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251008-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251008-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251008-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251008-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251008-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251008-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251008-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251008-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-09','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-08';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-08';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-08';
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-10-08' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-08';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-08';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-08';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-08';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-09' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-08' 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-251009-0001','D','2025-10-09','16:05:06','SYSTEM','SALDO AWAL','SALDO AWAL','0','1248871000','1248871000');
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-251009-0001','D','2025-10-09','16:05:06','BCA','SALDO AWAL','SALDO AWAL','0','4043018888','4043018888');
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-251009-0001','D','2025-10-09','16:05:06','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-251009-0001','D','2025-10-09','16:05:06','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-251009-0001','D','2025-10-09','16:05:06','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-251009-0001','D','2025-10-09','16:05:06','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-10-09';