INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-08-19 ','08:31:45');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-19','96','0','-308700000','96','0','-308700000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-18';
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-08-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-18' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-250819-0001','D','2025-08-19','08:31:55','BCA','SALDO AWAL','SALDO AWAL','0','1284678931','1284678931');
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-250819-0001','D','2025-08-19','08:31:55','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-08-19';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-08-19 ','08:32:16');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-08-19 ','08:38:12');
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,potong_rp) VALUES ('FJ-250819-0001','sales','1',' ','TOKO','BTATMD','MDAT-YFAI-9-0','AT TINDIK MN MAS 1 MK ','','0.540','1','100.00','435000','0','0','0','435000','0','0','0','435000','2106','00025282','MDAT','112500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-YFAI-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2025-08-19' AND kode_barang='MDAT-YFAI-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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 ('FJ-250819-0001','2025-08-19','0.540','2025-08-19','09:22:08','PLG0017097','435000','435000','0','435000','435000','sales','2025-08-19 09:22:07','FJ-250819-0001');
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-08-19','FJ-250819-0001','2025-08-19','09:22:08','2106','435000','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-250819-0002','D','2025-08-19','09:22:08','sales','PENJUALAN','FJ-250819-0001','199849427','435000','200284427');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250819-0001';
UPDATE tt_hutang_head SET byr_harus_rp='500000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'540000',tgl_lunas='2025-08-19',status='CLOS',total_lunas='540000' WHERE no_hutang='PI25-01418';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'500000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'500000'  WHERE tanggal='2025-08-19';
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-250819-0003','D','2025-08-19','09:29:56','cashier1','HUTANG LUNAS','PI25-01418','200284427','540000','200824427');
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-00008694','X-00008694','KL FANCY 45CM KKT PER BLT SHB','GR','---','MTKL','BELI','BELI001','2241500','2025-08-19','1.880','1','sales','2025-08-19 09:55:55');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTKL','X-00008694','X-00008694');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250819-0001','FJ-250713-0004','2105','1','BELI','BELI001','MTKL', 'X-00008694', 'KL FANCY 45CM KKT PER BLT SHB','1.880','1.880','100.00','2547500','2241500','1192287','1','2241500','2241500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-08-19','BELI','BELI001','MTKL','MTKL','100.00','1.880','1.880','1','1.880','1.880','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,status_valid) VALUES ('FB-250819-0001','2025-08-19','2025-08-19','09:55:55','2105','---','1.880','2241500','2241500','2241500','2241500','2241500','sales','2025-08-19 09:55:55','FB-250819-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250819-0001','MONA','BANGKALAN','','','082338786488','sales','2025-08-19 09:55:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-19' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-250819-0004','K','2025-08-19','09:55:55','sales','PEMBELIAN UMUM','FB-250819-0001','200824427','2241500','198582927','OPEN');
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-00008695','X-00008695','LT COR BT MK','GR','---','MTLT','BELI','BELI001','1192500','2025-08-19','1.000','1','sales','2025-08-19 09:55:55');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTLT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTLT','X-00008695','X-00008695');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250819-0002','FJ-250713-0002','2105','2','BELI','BELI001','MTLT', 'X-00008695', 'LT COR BT MK','1.000','1.000','100.00','1355000','1192500','1192500','1','1192500','1192500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-08-19','BELI','BELI001','MTLT','MTLT','100.00','1.000','1.000','1','1.000','1.000','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,status_valid) VALUES ('FB-250819-0002','2025-08-19','2025-08-19','09:55:55','2105','---','1.000','1192500','1192500','1192500','1192500','1192500','sales','2025-08-19 09:55:55','FB-250819-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250819-0002','MONA','BANGKALAN','','','082338786488','sales','2025-08-19 09:55:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-19' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-250819-0005','K','2025-08-19','09:55:55','sales','PEMBELIAN UMUM','FB-250819-0002','198582927','1192500','197390427','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250819-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250819-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250819-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250819-0002';
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-00008696','X-00008696','CN PIPA SUSUN BT MK','GR','---','MDCN','BELI','BELI001','1558000','2025-08-19','2.250','1','sales','2025-08-19 10:20:38');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00008696','X-00008696');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250819-0003','FJ-250725-0003','2503','1','BELI','BELI001','MDCN', 'X-00008696', 'CN PIPA SUSUN BT MK','2.250','2.250','100.00','1822500','1558000','692444','1','1558000','1558000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.250',berat_beli_asli=berat_beli_asli+'2.250',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.250',berat_akhir_asli=berat_akhir_asli+'2.250',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDCN' 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,status_valid) VALUES ('FB-250819-0003','2025-08-19','2025-08-19','10:20:37','2503','---','2.250','1558000','1558000','1558000','1558000','1558000','sales','2025-08-19 10:20:38','FB-250819-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250819-0003','IBU SITI HAWA','SUTOREJO SEMERU 212','','','083122710371','sales','2025-08-19 10:20:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-19' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-250819-0006','K','2025-08-19','10:20:37','sales','PEMBELIAN UMUM','FB-250819-0003','197390427','1558000','195832427','OPEN');
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-00008697','X-00008697','CN KAWIN COR BT SHB','GR','---','MTCN','BELI','BELI001','3195500','2025-08-19','2.680','1','sales','2025-08-19 10:21:28');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00008697','X-00008697');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250819-0004','FJ-230204-0004','2403','1','BELI','BELI001','MTCN', 'X-00008697', 'CN KAWIN COR BT SHB','2.800','2.680','100.00','2002000','3195500','1192351','1','3195500','3195500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-08-19','BELI','BELI001','MTCN','MTCN','100.00','2.680','2.680','1','2.680','2.680','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,status_valid) VALUES ('FB-250819-0004','2025-08-19','2025-08-19','10:21:28','2403','---','2.680','3195500','3195500','3195500','3195500','3195500','sales','2025-08-19 10:21:28','FB-250819-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250819-0004','FIRA','TMBK WEDI KMPLEK KMS 2','','','','sales','2025-08-19 10:21:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-19' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-250819-0007','K','2025-08-19','10:21:28','sales','PEMBELIAN UMUM','FB-250819-0004','195832427','3195500','192636927','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250819-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250819-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250819-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250819-0004';
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,potong_rp) VALUES ('FJ-250819-0002','sales','1',' EX ','TOKO','BTCNMD','MDCN-YEXE-29-0','CN BRILLIANT SHB','','1.450','1','100.00','1167500','0','0','0','1167500','0','0','0','1167500','2503','00024857','MDCN','112500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YEXE-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2025-08-19' AND kode_barang='MDCN-YEXE-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-250819-0002','2025-08-19','1.450','2025-08-19','10:23:51','PLG0017098','1167500','1167500','0','1167500','1167500','sales','2025-08-19 10:23:51','FJ-250819-0002');
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-08-19','FJ-250819-0002','2025-08-19','10:23:51','2503','1167500','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-250819-0008','D','2025-08-19','10:23:51','sales','PENJUALAN','FJ-250819-0002','192636927','1167500','193804427');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250819-0002';
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,potong_rp) VALUES ('FJ-250819-0003','sales','1',' ','TOKO','BTATMT','MTAT-YDCX-18-0','AT COR KLP BT SHB ','','1.180','1','100.00','1599000','0','0','0','1599000','0','0','0','1599000','2402','00024507','MTAT','162500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YDCX-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2025-08-19' AND kode_barang='MTAT-YDCX-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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 ('FJ-250819-0003','2025-08-19','1.180','2025-08-19','10:26:12','PLG0017099','1599000','1599000','0','1599000','1599000','sales','2025-08-19 10:26:11','FJ-250819-0003');
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-08-19','FJ-250819-0003','2025-08-19','10:26:12','2402','1599000','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-250819-0009','D','2025-08-19','10:26:12','sales','PENJUALAN','FJ-250819-0003','193804427','1599000','195403427');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250819-0003';
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,potong_rp) VALUES ('FJ-250819-0004','sales','1',' ','TOKO','BTCNMD','MDCN-YDBD-1-0','CN COR BT BTG ','','2.220','1','100.00','1787500','0','0','0','1787500','0','0','0','1787500','2503','00024487','MDCN','112500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YDBD-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2025-08-19' AND kode_barang='MDCN-YDBD-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-250819-0004','2025-08-19','2.220','2025-08-19','10:31:07','PLG0017100','1787500','1787500','0','1787500','1787500','sales','2025-08-19 10:31:06','FJ-250819-0004');
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-08-19','FJ-250819-0004','2025-08-19','10:31:07','2503','1787500','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-250819-0010','D','2025-08-19','10:31:07','sales','PENJUALAN','FJ-250819-0004','195403427','1787500','197190927');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250819-0004';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008698','X-00008698','CN CAP TDK BT SHB','GR','---','MTCN','BELI','BELI001','1395000','2025-08-19','1.170','1','sales','2025-08-19 10:56:00');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00008698','X-00008698');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250819-0005','FJ-250616-0005','2404','1','BELI','BELI001','MTCN', 'X-00008698', 'CN CAP TDK BT SHB','1.170','1.170','100.00','1609000','1395000','1192308','1','1395000','1395000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.170',berat_beli_asli=berat_beli_asli+'1.170',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.170',berat_akhir_asli=berat_akhir_asli+'1.170',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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,status_valid) VALUES ('FB-250819-0005','2025-08-19','2025-08-19','10:55:59','2404','---','1.170','1395000','1395000','1395000','1395000','1395000','sales','2025-08-19 10:56:00','FB-250819-0005','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250819-0005','IBU MAIDEH','WONOKUSUMO LOR 40','','','','sales','2025-08-19 10:56:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-19' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-250819-0011','K','2025-08-19','10:55:59','sales','PEMBELIAN UMUM','FB-250819-0005','197190927','1395000','195795927','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250819-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250819-0005';
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-00008699','X-00008699','GL PIPA BT HWT','GR','---','MDGL','BELI','BELI001','1744000','2025-08-19','2.930','1','sales','2025-08-19 12:25:47');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00008699','X-00008699');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250819-0006','FJ-250203-0005','2103','1','BELI','BELI001','MDGL', 'X-00008699', 'GL PIPA BT HWT','2.980','2.930','100.00','2034000','1744000','595222','1','1744000','1744000','RUSAK BIASA');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.930',berat_beli_asli=berat_beli_asli+'2.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.930',berat_akhir_asli=berat_akhir_asli+'2.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MDGL' 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,status_valid) VALUES ('FB-250819-0006','2025-08-19','2025-08-19','12:25:47','2103','---','2.930','1744000','1744000','1744000','1744000','1744000','sales','2025-08-19 12:25:47','FB-250819-0006','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250819-0006','AISYAH','JL SIDODADI 189','','','','sales','2025-08-19 12:25:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-19' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-250819-0012','K','2025-08-19','12:25:47','sales','PEMBELIAN UMUM','FB-250819-0006','195795927','1744000','194051927','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250819-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250819-0006';
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,potong_rp) VALUES ('FJ-250819-0005','sales','1',' EX ','TOKO','BTKLMT','MTKL-WHAE-122-0','KL FANCY 47CM KKT PER SHB ','','19.950','1','100.00','27032500','0','0','0','27032500','0','0','0','27032500','2402','00017349','MTKL','162500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-WHAE-122-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'19.950',berat_jual_asli=berat_jual_asli+'19.950',stock_jual='1',berat_akhir=berat_akhir-'19.950',berat_akhir_asli=berat_akhir_asli-'19.950',stock_akhir='0' WHERE tanggal='2025-08-19' AND kode_barang='MTKL-WHAE-122-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMT' 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 ('FJ-250819-0005','2025-08-19','19.950','2025-08-19','12:38:50','PLG0017101','27032500','27032500','0','27032500','27032500','sales','2025-08-19 12:38:49','FJ-250819-0005');
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-08-19','FJ-250819-0005','2025-08-19','12:38:50','2402','27032500','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-250819-0013','D','2025-08-19','12:38:50','sales','PENJUALAN','FJ-250819-0005','194051927','27032500','221084427');
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-00008700','X-00008700','CN COR BANGKOK LBG SHB','GR','---','MTCN','BELI','BELI001','1299500','2025-08-19','1.090','1','sales','2025-08-19 12:41:51');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00008700','X-00008700');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250819-0007','FJ-250605-0004','2404','1','BELI','BELI001','MTCN', 'X-00008700', 'CN COR BANGKOK LBG SHB','1.090','1.090','100.00','1455500','1299500','1192202','1','1299500','1299500','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.090',berat_beli_asli=berat_beli_asli+'1.090',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.090',berat_akhir_asli=berat_akhir_asli+'1.090',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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,status_valid) VALUES ('FB-250819-0007','2025-08-19','2025-08-19','12:41:51','2404','---','1.090','1299500','1299500','1299500','1299500','1299500','sales','2025-08-19 12:41:51','FB-250819-0007','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250819-0007','HOSNIA','JL. SUMBO 52','','','083849571771','sales','2025-08-19 12:41:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-19' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-250819-0014','K','2025-08-19','12:41:51','sales','PEMBELIAN UMUM','FB-250819-0007','221084427','1299500','219784927','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250819-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250819-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-08-19 ','12:51:55');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250819-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-08-19 ','12:52:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-08-19 ','13:14:56');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-08-19 ','13:21:36');
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-00008701','X-00008701','CN CAP TDK BT SHB','GR','---','MTCN','BELI','BELI001','1359000','2025-08-19','1.140','1','sales','2025-08-19 14:22:38');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00008701','X-00008701');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250819-0008','FJ-250805-0005','2105','1','BELI','BELI001','MTCN', 'X-00008701', 'CN CAP TDK BT SHB','1.140','1.140','100.00','1545000','1359000','1192105','1','1359000','1359000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.140',berat_beli_asli=berat_beli_asli+'1.140',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.140',berat_akhir_asli=berat_akhir_asli+'1.140',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTCN' 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,status_valid) VALUES ('FB-250819-0008','2025-08-19','2025-08-19','14:22:38','2105','---','1.140','1359000','1359000','1359000','1359000','1359000','sales','2025-08-19 14:22:38','FB-250819-0008','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250819-0008','BUSIYA','BLK RKM BRU INDH 3/4','','','','sales','2025-08-19 14:22:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-19' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-250819-0015','K','2025-08-19','14:22:38','sales','PEMBELIAN UMUM','FB-250819-0008','219784927','1359000','218425927','OPEN');
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,potong_rp) VALUES ('FJ-250819-0006','sales','1',' EX ','TOKO','BTCNMD','MDCN-YFAI-117-0','CN COR TDK BT LC2 ','','1.600','1','100.00','1288000','0','0','0','1288000','0','0','0','1288000','2105','00025390','MDCN','112500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-08-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YFAI-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2025-08-19' AND kode_barang='MDCN-YFAI-117-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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 ('FJ-250819-0006','2025-08-19','1.600','2025-08-19','14:25:39','PLG0017102','1288000','1288000','0','1288000','1288000','sales','2025-08-19 14:25:39','FJ-250819-0006');
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-08-19','FJ-250819-0006','2025-08-19','14:25:39','2105','1288000','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-250819-0016','D','2025-08-19','14:25:39','sales','PENJUALAN','FJ-250819-0006','218425927','1288000','219713927');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250819-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250819-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250819-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250819-0006';
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-250819-0017','K','2025-08-19','14:28:51','cashier1','PENGELUARAN','BELI AIR MINUM 3GALON CLUB ','219713927','51000','219662927');