INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-09-15 ','08:32:30');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-15','99','0','-302650000','99','0','-302650000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-15';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-14';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-09-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-14' 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-250915-0001','D','2025-09-15','08:32:39','BCA','SALDO AWAL','SALDO AWAL','0','1338084931','1338084931');
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-250915-0001','D','2025-09-15','08:32:39','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-09-15';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-09-15 ','08:33:17');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-09-15 ','08:35:26');
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-250915-0001','sales','1',' ','TOKO','BTKLMD','MDKL-XCAI-45-0','KL ITALY ST BTR BT DSC 42CM KKT PER BLT SHB ','','2.950','1','100.00','2537000','0','0','0','2537000','0','0','0','2537000','2105','00019442','MDKL','120500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-09-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDKL-XCAI-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2025-09-15' AND kode_barang='MDKL-XCAI-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMD' 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-250915-0001','2025-09-15','2.950','2025-09-15','08:51:07','PLG0017216','2537000','2537000','0','2537000','2537000','sales','2025-09-15 08:51:06','FJ-250915-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-09-15','FJ-250915-0001','2025-09-15','08:51:07','2105','2537000','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-250915-0002','D','2025-09-15','08:51:07','sales','PENJUALAN','FJ-250915-0001','72941680','2537000','75478680');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250915-0001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-250915-0002','sales','1',' EX ','TOKO','BTCNMD','MDCN-YFAI-113-0','CN COR TDK BT MK ','','1.950','1','100.00','1677000','0','0','0','1677000','0','0','0','1677000','2402','00025386','MDCN','120500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-09-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-YFAI-113-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2025-09-15' AND kode_barang='MDCN-YFAI-113-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-250915-0002','2025-09-15','1.950','2025-09-15','09:51:34','PLG0017217','1677000','1677000','0','1677000','1677000','sales','2025-09-15 09:51:33','FJ-250915-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-09-15','FJ-250915-0002','2025-09-15','09:51:34','2402','1677000','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-250915-0003','D','2025-09-15','09:51:34','sales','PENJUALAN','FJ-250915-0002','75478680','1677000','77155680');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250915-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-250915-0003','sales','1',' EX ','TOKO','BTATMD','MDAT-YHBH-2-0','AT BABY ARESO MN HT UBS','','0.650','1','100.00','559000','0','0','0','559000','0','0','0','559000','2501','00025916','MDAT','120500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-09-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-YHBH-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-09-15' AND kode_barang='MDAT-YHBH-2-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-250915-0003','2025-09-15','0.650','2025-09-15','11:22:33','PLG0017218','559000','559000','0','559000','559000','sales','2025-09-15 11:22:33','FJ-250915-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-09-15','FJ-250915-0003','2025-09-15','11:22:33','2501','559000','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-250915-0004','D','2025-09-15','11:22:33','sales','PENJUALAN','FJ-250915-0003','77155680','559000','77714680');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250915-0003';
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-00008799','X-00008799','CN PLINTIR SHB','GR','---','MTCN','BELI','BELI001','1940000','2025-09-15','1.500','1','sales','2025-09-15 12:38:15');
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-00008799','X-00008799');
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-250915-0001','FJ-250426-0012','2402','1','BELI','BELI001','MTCN', 'X-00008799', 'CN PLINTIR SHB','1.500','1.500','100.00','2122500','1940000','1293333','1','1940000','1940000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-15' 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-250915-0001','2025-09-15','2025-09-15','12:38:14','2402','---','1.500','1940000','1940000','1940000','1940000','1940000','sales','2025-09-15 12:38:15','FB-250915-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250915-0001','WIWIN','SIMOLAWANG 1/76C','','','08819009596','sales','2025-09-15 12:38:15');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-15' 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-250915-0005','K','2025-09-15','12:38:14','sales','PEMBELIAN UMUM','FB-250915-0001','77714680','1940000','75774680','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250915-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250915-0001';
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-00008800','X-00008800','GL ITALY ST SRT BTR BL PSR BL SLP 18CM KKT PER SHB','GR','---','MDGL','BELI','BELI001','1700500','2025-09-15','2.300','1','sales','2025-09-15 13:09:50');
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-00008800','X-00008800');
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-250915-0002','FJ-250909-0004','2503','1','BELI','BELI001','MDGL', 'X-00008800', 'GL ITALY ST SRT BTR BL PSR BL SLP 18CM KKT PER SHB','2.300','2.300','100.00','1943500','1700500','739348','1','1700500','1700500','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-09-15','BELI','BELI001','MDGL','MDGL','100.00','2.300','2.300','1','2.300','2.300','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-250915-0002','2025-09-15','2025-09-15','13:09:49','2503','---','2.300','1700500','1700500','1700500','1700500','1700500','sales','2025-09-15 13:09:50','FB-250915-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250915-0002','SAODAH','ARIMBI GG BUNTU NO.4','','','','sales','2025-09-15 13:09:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-15' 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-250915-0006','K','2025-09-15','13:09:49','sales','PEMBELIAN UMUM','FB-250915-0002','75774680','1700500','74074180','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250915-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250915-0002';
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-250915-0007','K','2025-09-15','14:24:04','cashier1','PENGELUARAN','BELI AIR CLEO UNTUK GELAS ETALASE ','74074180','4500','74069680');
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-250915-0008','K','2025-09-15','14:24:22','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB ','74069680','51000','74018680');
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-250915-0004','sales','1',' ','TOKO','BTATMT','MTAT-XKBH-52-0','AT ITALY BT SHB ','','1.000','1','100.00','1470000','0','0','0','1470000','0','0','0','1470000','2404','00022248','MTAT','176500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-09-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-XKBH-52-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-09-15' AND kode_barang='MTAT-XKBH-52-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-250915-0004','2025-09-15','1.000','2025-09-15','14:56:54','PLG0017219','1470000','1470000','0','1470000','1470000','sales','2025-09-15 14:56:54','FJ-250915-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-09-15','FJ-250915-0004','2025-09-15','14:56:54','2404','1470000','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-250915-0009','D','2025-09-15','14:56:54','sales','PENJUALAN','FJ-250915-0004','74018680','1470000','75488680');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250915-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-250915-0005','sales','1',' EX ','TOKO','BTGLMT','MTGL-XCBA-103-0','GL VIGARO VC 17CM KKT PER MK ','','3.380','1','100.00','4969000','0','0','0','5003000','34000','0','0','5003000','2402','00019671','MTGL','176500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-09-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTGL-XCBA-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2025-09-15' AND kode_barang='MTGL-XCBA-103-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMT' 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-250915-0005','2025-09-15','3.380','2025-09-15','15:15:40','PLG0017220','5003000','5003000','0','5003000','5003000','sales','2025-09-15 15:15:39','FJ-250915-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-09-15','FJ-250915-0005','2025-09-15','15:15:40','2402','5003000','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-250915-0010','D','2025-09-15','15:15:40','sales','PENJUALAN','FJ-250915-0005','75488680','5003000','80491680');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250915-0005';
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-250915-0006','sales','1',' ','TOKO','BTATMT','MTAT-YBBG-36-0','AT TINDIK MN PLAT MK ','','0.730','1','100.00','1073500','0','0','0','1073500','0','0','0','1073500','2103','00023311','MTAT','176500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2025-09-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-YBBG-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2025-09-15' AND kode_barang='MTAT-YBBG-36-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-250915-0006','2025-09-15','0.730','2025-09-15','15:40:28','PLG0017221','1073500','1073500','0','1073500','1073500','sales','2025-09-15 15:40:27','FJ-250915-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-09-15','FJ-250915-0006','2025-09-15','15:40:28','2103','1073500','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-250915-0011','D','2025-09-15','15:40:28','sales','PENJUALAN','FJ-250915-0006','80491680','1073500','81565180');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-250915-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-250915-0006';