INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-09-21 ','08:37:22');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-21','105','0','-300050000','105','0','-300050000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-20';
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-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-20';
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-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-20' 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-250921-0001','D','2025-09-21','08:37:30','BCA','SALDO AWAL','SALDO AWAL','0','1342543931','1342543931');
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-250921-0001','D','2025-09-21','08:37:30','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-09-21';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-09-21 ','08:37:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-09-21 ','08:57:40');
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-00008816','X-00008816','AT COR DESI SHB','GR','---','MTAT','BELI','BELI001','817000','2025-09-21','0.670','1','sales','2025-09-21 10:12:59');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00008816','X-00008816');
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-250921-0001','FJ-240408-0007','2106','1','BELI','BELI001','MTAT', 'X-00008816', 'AT COR DESI SHB','0.820','0.670','100.00','750500','817000','1219403','1','817000','817000','RONGSOK');
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-21','BELI','BELI001','MTAT','MTAT','100.00','0.670','0.670','1','0.670','0.670','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-250921-0001','2025-09-21','2025-09-21','10:12:58','2106','---','0.670','817000','817000','817000','817000','817000','sales','2025-09-21 10:12:59','FB-250921-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0001','VIRA','KERTOPATEN 1/3B','','SBY','','sales','2025-09-21 10:12:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0002','K','2025-09-21','10:12:58','sales','PEMBELIAN UMUM','FB-250921-0001','105497798','817000','104680798','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0001';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI25-01561','2106','1','CN SESER RENGGANG MT','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'8500000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'8500000'  WHERE tanggal='2025-09-21'
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI25-01561','2106','2','CN EROPA BT AD PENUH 700 SRT 1 LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'8500000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'8500000'  WHERE tanggal='2025-09-21'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI25-01561','2025-09-21','2025-09-21','11:12:49','PLG0017243','2106','90','2025-12-20','sales','2025-09-21 11:12:48','11.600','8500000','3.00','765000','9265000','0','OPEN','14.58','2','2025-12-20','0','9265000')
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-250921-0003','K','2025-09-21','11:12:49','sales','HUTANG','PI25-01561','104680798','8500000','96180798','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI25-01561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI25-01561';
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-00008817','X-00008817','GL PIPA BT SHB','GR','---','MDGL','BELI','BELI001','2912000','2025-09-21','3.870','1','sales','2025-09-21 11:56:58');
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-00008817','X-00008817');
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-250921-0002','FJ-250808-0002','2404','1','BELI','BELI001','MDGL', 'X-00008817', 'GL PIPA BT SHB','3.870','3.870','100.00','3135000','2912000','752455','1','2912000','2912000','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-21','BELI','BELI001','MDGL','MDGL','100.00','3.870','3.870','1','3.870','3.870','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-250921-0002','2025-09-21','2025-09-21','11:56:57','2404','---','3.870','2912000','2912000','2912000','2912000','2912000','sales','2025-09-21 11:56:58','FB-250921-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0002','SAROPA','PASAR ASEM ROWO','','','','sales','2025-09-21 11:56:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0004','K','2025-09-21','11:56:57','sales','PEMBELIAN UMUM','FB-250921-0002','96180798','2912000','93268798','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-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-00008818','X-00008818','KL FANCY VAR DB 42CM KKT S SHB','GR','---','MTKL','BELI','BELI001','2824500','2025-09-21','2.140','1','sales','2025-09-21 11:59:26');
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-00008818','X-00008818');
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-250921-0003','FJ-250626-0002','2401','1','BELI','BELI001','MTKL', 'X-00008818', 'KL FANCY VAR DB 42CM KKT S SHB','2.140','2.140','100.00','2942500','2824500','1319860','1','2824500','2824500','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-21','BELI','BELI001','MTKL','MTKL','100.00','2.140','2.140','1','2.140','2.140','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-250921-0003','2025-09-21','2025-09-21','11:59:25','2401','---','2.140','2824500','2824500','2824500','2824500','2824500','sales','2025-09-21 11:59:26','FB-250921-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250921-0003','BU HALIMAH','MANYAR SABRANGAN 8B/7','','','','sales','2025-09-21 11:59:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-21' 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-250921-0005','K','2025-09-21','11:59:25','sales','PEMBELIAN UMUM','FB-250921-0003','93268798','2824500','90444298','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250921-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250921-0003';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI25-01562','2103','1','GL BKK KRW MDL BUNGA PK KCG RTS 700 SRT1LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'11000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'11000000'  WHERE tanggal='2025-09-21'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI25-01562','2025-09-21','2025-09-21','14:50:52','PLG0017244','2103','90','2025-12-20','sales','2025-09-21 14:50:52','16.000','11000000','2.50','825000','11825000','0','OPEN','40.65','1','2025-12-20','0','11825000')
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-250921-0006','K','2025-09-21','14:50:52','sales','HUTANG','PI25-01562','90444298','11000000','79444298','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI25-01562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI25-01562';