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 ('F325020936081','input','1',' MDA1 CM ','TOKO','PM-A','A1D-YIXD-159-0','AT MODEL MATA VAR CM 8K ','','0.910','1','100.00','866000','0','0','15000','865000','0','0','0','865000','AAT','00367916','A1D','0','0','-','1','957000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIXD-159-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='A1D-YIXD-159-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325020936081','2025-10-02','0.910','2025-10-02','09:36:08','PLG0025073','865000','865000','0','865000','865000','input','2025-10-02 09:36:08','F32502093608');
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-02','F325020936081','2025-10-02','09:36:08','AAT','865000','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-251002-0002','D','2025-10-02','09:36:08','input','PENJUALAN','F325020936081','111319000','865000','112184000');
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 ('F325021039551','input','1',' MEE1 OR 20','TOKO','PM-E','E1E-YHAB-109-0','CC VELG POLOS OR 20 8K ','','1.070','1','100.00','1040000','0','0','15000','1030000','0','0','0','1030000','SIN','00365364','E1E','0','0','-','1','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHAB-109-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='E1E-YHAB-109-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021039551','2025-10-02','1.070','2025-10-02','10:39:56','PLG0025074','1030000','1030000','0','1030000','1030000','input','2025-10-02 10:39:55','F32502103955');
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-02','F325021039551','2025-10-02','10:39:56','SIN','1030000','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-251002-0003','D','2025-10-02','10:39:56','input','PENJUALAN','F325021039551','112184000','1030000','113214000');
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 ('F325021041441','input','1',' MEH1 X HW ','TOKO','PM-H','H1E-YHXE-44-0','KL X NORY MATA VAR HW 42 8K ','','3.060','1','100.00','2974000','0','0','15000','2945000','0','0','0','2945000','SIN','00363831','H1E','0','0','-','1','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHXE-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='H1E-YHXE-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021041441','2025-10-02','3.060','2025-10-02','10:41:45','PLG0025075','2945000','2945000','0','2945000','2945000','input','2025-10-02 10:41:44','F32502104144');
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-02','F325021041441','2025-10-02','10:41:45','SIN','2945000','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-251002-0004','D','2025-10-02','10:41:45','input','PENJUALAN','F325021041441','113214000','2945000','116159000');
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 ('F325021056581','input','1',' MFE2 5K LG','TOKO','PM-E','E2F-YGXD-378-0','CC OSROT ANAK BONEKA CAT MATA VAR LG 8K ','','0.450','1','100.00','446000','0','0','15000','447000','0','5000','0','452000','FIT','00359701','E2F','0','0','-','0','992000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-YGXD-378-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='E2F-YGXD-378-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021056581','2025-10-02','0.450','2025-10-02','10:56:58','PLG0025076','447000','447000','5000','452000','452000','input','2025-10-02 10:56:58','F32502105658');
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-02','F325021056581','2025-10-02','10:56:58','FIT','452000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251002-0005','D','2025-10-02','10:56:58','input','PENJUALAN','F325021056581','116159000','452000','116611000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='452000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021056581' 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 ('F325021056582','input',' 1',' MEF3E X UB','TOKO','PM-F','F3E-YCAX-154-0','GL X TIFF MATA VAR SERUT UB 8K ','','1.610','1','100.00','1565000','0','0','15000','1565000','0','0','0','1565000','FIT','00342894','F3E','0','0','-','0','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YCAX-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='F3E-YCAX-154-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021056582','2025-10-02','1.610','2025-10-02','10:56:58','PLG0025077','1565000','1565000','0','1565000','1565000','input','2025-10-02 10:56:58','F32502105658');
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-02','F325021056582','2025-10-02','10:56:58','FIT','1565000','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-251002-0006','D','2025-10-02','10:56:58','input','PENJUALAN','F325021056582','116611000','1565000','118176000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1565000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021056582' 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 ('F325021118141','input','1',' MJH2 XXX K','TOKO','PM-H','H2J-XGXF-59-0','KL XXX MILANO KH 44 9K ','','2.110','1','100.00','2262000','0','0','15000','2260000','0','0','0','2260000','SIN','00306284','H2J','0','0','-','1','1077000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-XGXF-59-0' 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-02' AND kode_barang='H2J-XGXF-59-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021118141','2025-10-02','2.110','2025-10-02','11:18:15','PLG0025078','2260000','2260000','0','2260000','2260000','input','2025-10-02 11:18:14','F32502111814');
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-02','F325021118141','2025-10-02','11:18:15','SIN','2260000','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-251002-0007','D','2025-10-02','11:18:15','input','PENJUALAN','F325021118141','118176000','2260000','120436000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2260000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021118141' 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 ('F325021118142','input',' 1',' MDB1 5K CM','TOKO','PM-B','B1D-YIXD-153-0','GW TUSUK MODEL MATA VAR CM PE 8K ','','0.850','1','100.00','809000','0','0','15000','810000','0','5000','0','815000','SIN','00367910','B1D','0','0','-','0','957000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YIXD-153-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='B1D-YIXD-153-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021118142','2025-10-02','0.850','2025-10-02','11:18:15','PLG0025079','810000','810000','5000','815000','815000','input','2025-10-02 11:18:14','F32502111814');
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-02','F325021118142','2025-10-02','11:18:15','SIN','815000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251002-0008','D','2025-10-02','11:18:15','input','PENJUALAN','F325021118142','120436000','815000','121251000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='815000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021118142' 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 ('F325021118143','input',' 1',' MDD2 CM ','TOKO','PM-D','D2D-YIBB-129-0','LT MODEL MATA VAR CM 8K ','','0.860','1','100.00','819000','0','0','15000','820000','0','0','0','820000','SIN','00370177','D2D','0','0','-','0','957000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YIBB-129-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='D2D-YIBB-129-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021118143','2025-10-02','0.860','2025-10-02','11:18:15','PLG0025080','820000','820000','0','820000','820000','input','2025-10-02 11:18:14','F32502111814');
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-02','F325021118143','2025-10-02','11:18:15','SIN','820000','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-251002-0009','D','2025-10-02','11:18:15','input','PENJUALAN','F325021118143','121251000','820000','122071000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='820000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021118143' 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 ('F325021151111','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-YAAG-221-0','GL X OVAL C SLEP UB 65 8K ','','2.470','1','100.00','2401000','0','0','15000','2400000','0','0','0','2400000','AAT','00334788','F1E','0','0','-','1','977000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YAAG-221-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.470',berat_jual_asli=berat_jual_asli+'2.470',stock_jual='1',berat_akhir=berat_akhir-'2.470',berat_akhir_asli=berat_akhir_asli-'2.470',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='F1E-YAAG-221-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021151111','2025-10-02','2.470','2025-10-02','11:51:12','PLG0025081','2400000','2400000','0','2400000','2400000','input','2025-10-02 11:51:11','F32502115111');
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-02','F325021151111','2025-10-02','11:51:12','AAT','2400000','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-251002-0010','D','2025-10-02','11:51:12','input','PENJUALAN','F325021151111','122071000','2400000','124471000');
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-00017135','X-00017135','KL X MILANO KH 42CM','GR','---','H2J','BELI','BELI001','3820000','2025-10-02','4.980','1','kasir','2025-10-02 12:38:44');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00017135','X-00017135');
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-251002-0001','F322111100111','SIN','1','BELI','BELI001','H2J', 'X-00017135', 'KL X MILANO KH 42CM','4.980','4.980','100.00','2290000','3820000','767068','1077000','1','3820000','3820000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.980',berat_beli_asli=berat_beli_asli+'4.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.980',berat_akhir_asli=berat_akhir_asli+'4.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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-251002-0001','2025-10-02','2025-10-02','12:38:44','SIN','---','4.980','3820000','3820000','3820000','3820000','3820000','kasir','2025-10-02 12:38:44','FB-251002-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251002-0001','SINTYA','TUNGGUR SLOGOHIMO','','','','kasir','2025-10-02 12:38:44');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-02' 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-251002-0011','K','2025-10-02','12:38:44','kasir','PEMBELIAN UMUM','FB-251002-0001','124471000','3820000','120651000');
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 ('F325021240081','kasir','1',' MFD1 X BG ','TOKO','PM-D','D1F-YABE-14-0','LT X SLOBOK HURUF BALOK BG L 8K ','','0.410','1','100.00','407000','0','0','15000','407000','0','0','0','407000','SIN','00336297','D1F','0','0','-','0','992000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YABE-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='D1F-YABE-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021240081','2025-10-02','0.410','2025-10-02','12:40:09','PLG0025082','407000','407000','0','407000','407000','kasir','2025-10-02 12:40:08','F32502124008');
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-02','F325021240081','2025-10-02','12:40:09','SIN','407000','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-251002-0012','D','2025-10-02','12:40:09','kasir','PENJUALAN','F325021240081','120651000','407000','121058000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='407000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021240081' 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 ('F325021240082','kasir',' 1',' MFD1F X BG','TOKO','PM-D','D1F-YHBB-24-0','LT X SLOBOK BALOK HURUF BG A 8K ','','0.360','1','100.00','357000','0','0','15000','358000','0','0','0','358000','SIN','00366637','D1F','0','0','-','0','992000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YHBB-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='D1F-YHBB-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325021240082','2025-10-02','0.360','2025-10-02','12:40:09','PLG0025083','358000','358000','0','358000','358000','kasir','2025-10-02 12:40:08','F32502124008');
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-02','F325021240082','2025-10-02','12:40:09','SIN','358000','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-251002-0013','D','2025-10-02','12:40:09','kasir','PENJUALAN','F325021240082','121058000','358000','121416000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='358000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325021240082' LIMIT 1;
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-00017136','X-00017136','GL X RANTAI HOLLOW P4 SLEP KH 8K','GR','---','F3E','BELI','BELI001','6800000','2025-10-02','9.800','1','kasir','2025-10-02 12:44:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017136','X-00017136');
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-251002-0002','F324011102561','FIT','1','BELI','BELI001','F3E', 'X-00017136', 'GL X RANTAI HOLLOW P4 SLEP KH 8K','9.800','9.800','100.00','5880000','6800000','693878','977000','1','6800000','6800000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'9.800',berat_beli_asli=berat_beli_asli+'9.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'9.800',berat_akhir_asli=berat_akhir_asli+'9.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251002-0002','2025-10-02','2025-10-02','12:44:47','FIT','---','9.800','6800000','6800000','6800000','6800000','6800000','kasir','2025-10-02 12:44:48','FB-251002-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251002-0002','NARMI','SUMBER CONTO BLO','','','','kasir','2025-10-02 12:44:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-02' 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-251002-0014','K','2025-10-02','12:44:47','kasir','PEMBELIAN UMUM','FB-251002-0002','121416000','6800000','114616000');
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-00017137','X-00017137','GL X OVAL C SLEP TD 54 8K','GR','---','F1E','BELI','BELI001','2205000','2025-10-02','3.000','1','kasir','2025-10-02 12:45:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017137','X-00017137');
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-251002-0003','F325231016061','FIT','1','BELI','BELI001','F1E', 'X-00017137', 'GL X OVAL C SLEP TD 54 8K','3.000','3.000','100.00','2535000','2205000','735000','977000','1','2205000','2205000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.000',berat_beli_asli=berat_beli_asli+'3.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.000',berat_akhir_asli=berat_akhir_asli+'3.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-02' 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-251002-0003','2025-10-02','2025-10-02','12:45:36','FIT','---','3.000','2205000','2205000','2205000','2205000','2205000','kasir','2025-10-02 12:45:37','FB-251002-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251002-0003','FARANITA','LEMAHBANG KISMANTORO','','','','kasir','2025-10-02 12:45:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-02' 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-251002-0015','K','2025-10-02','12:45:36','kasir','PEMBELIAN UMUM','FB-251002-0003','114616000','2205000','112411000');
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-00017138','X-00017138','GL MODEL GENIA LT 8K','GR','---','F3E','BELI','BELI001','907000','2025-10-02','1.050','1','kasir','2025-10-02 12:45:56');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017138','X-00017138');
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-251002-0004','F325240841561','AAT','1','BELI','BELI001','F3E', 'X-00017138', 'GL MODEL GENIA LT 8K','1.050','1.050','100.00','988000','907000','863810','977000','1','907000','907000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251002-0004','2025-10-02','2025-10-02','12:45:56','AAT','---','1.050','907000','907000','907000','907000','907000','kasir','2025-10-02 12:45:56','FB-251002-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251002-0004','VIA','BANGSRI','','','','kasir','2025-10-02 12:45:56');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-02' 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-251002-0016','K','2025-10-02','12:45:56','kasir','PEMBELIAN UMUM','FB-251002-0004','112411000','907000','111504000');
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-00017139','X-00017139','CC X MODEL MATA LG 10 8K','GR','---','E2E','BELI','BELI001','325000','2025-10-02','0.510','1','kasir','2025-10-02 12:46:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017139','X-00017139');
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-251002-0005','F325121216361','FIT','1','BELI','BELI001','E2E', 'X-00017139', 'CC X MODEL MATA LG 10 8K','0.510','0.510','100.00','423000','325000','637255','977000','1','325000','325000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-251002-0005','2025-10-02','2025-10-02','12:46:31','FIT','---','0.510','325000','325000','325000','325000','325000','kasir','2025-10-02 12:46:31','FB-251002-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251002-0005','DESTIA','JETAK','','','','kasir','2025-10-02 12:46:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-02' 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-251002-0017','K','2025-10-02','12:46:31','kasir','PEMBELIAN UMUM','FB-251002-0005','111504000','325000','111179000');
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-00017140','X-00017140','GL X VERONICA SLEP LT 8K','GR','---','F3E','BELI','BELI001','895000','2025-10-02','1.020','1','kasir','2025-10-02 12:56:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017140','X-00017140');
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-251002-0006','F325281059071','SIN','1','BELI','BELI001','F3E', 'X-00017140', 'GL X VERONICA SLEP LT 8K','1.020','1.020','100.00','965000','895000','877451','977000','1','895000','895000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251002-0006','2025-10-02','2025-10-02','12:56:56','SIN','---','1.020','895000','895000','895000','895000','895000','kasir','2025-10-02 12:56:57','FB-251002-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251002-0006','BAKTI','NAWANGAN','','','','kasir','2025-10-02 12:56:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-02' 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-251002-0018','K','2025-10-02','12:56:56','kasir','PEMBELIAN UMUM','FB-251002-0006','111179000','895000','110284000');
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 ('F325020120431','kasir','1',' MFB1 LG ','TOKO','PM-B','B1F-YGCX-223-0','GW TOGE MODEL MATA VAR LG 8K ','','0.500','1','100.00','496000','0','0','15000','495000','0','0','0','495000','SIN','00363254','B1F','0','0','-','1','992000');
UPDATE tm_barang SET tgl_last_jual='2025-10-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-YGCX-223-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-02' AND kode_barang='B1F-YGCX-223-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F325020120431','2025-10-02','0.500','2025-10-02','13:20:43','PLG0025084','495000','495000','0','495000','495000','kasir','2025-10-02 13:20:43','F32502012043');
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-02','F325020120431','2025-10-02','13:20:43','SIN','495000','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-251002-0019','D','2025-10-02','13:20:43','kasir','PENJUALAN','F325020120431','110284000','495000','110779000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020120431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020120431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020120431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325020936081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325020936081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325020936081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021039551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021039551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021039551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021041441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021041441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021041441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021056581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021056581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021056581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021056582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021056582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021056582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021118141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021118141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021118141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021118142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021118142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021118142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021118143' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021118143' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021118143';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021151111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021151111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021151111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021240081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021240081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021240081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325021240082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325021240082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325021240082';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251002-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251002-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251002-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251002-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251002-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251002-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251002-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251002-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251002-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251002-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251002-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251002-0006';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-02';
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-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-02';
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-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-02' 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-251003-0001','D','2025-10-03','15:12:51','SYSTEM','SALDO AWAL','SALDO AWAL','0','110779000','110779000');
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-251003-0001','D','2025-10-03','15:12:51','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
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-251003-0001','D','2025-10-03','15:12: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-251003-0001','D','2025-10-03','15:12:51','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-10-03';