INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-08-03 ','08:31:17');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-03','89','0','-260650000','89','0','-260650000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-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-08-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-02';
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-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-02' 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-250803-0001','D','2025-08-03','08:31:27','','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-250803-0001','D','2025-08-03','08:31:27','BCA','SALDO AWAL','SALDO AWAL','0','1261929418','1261929418');
UPDATE tp_system SET tgl_system='2025-08-03';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2025-08-03 ','08:31:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2025-08-03 ','08:37:45');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI25-01522','2401','1','GL KRC PELINTIR 700BG3','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'2000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'2000000'  WHERE tanggal='2025-08-03'
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-01522','2025-08-03','2025-08-03','09:42:53','PLG0017018','2401','90','2025-11-01','sales','2025-08-03 09:42:52','4.090','2000000','3.00','180000','2180000','0','OPEN','5.24','1','2025-11-01','0','2180000')
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-250803-0002','K','2025-08-03','09:42:53','sales','HUTANG','PI25-01522','62552121','2000000','60552121','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI25-01522' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI25-01522';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI25-01523','2502','1','KL KOREA KKT S 700HWT','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'2700000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'2700000'  WHERE tanggal='2025-08-03'
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI25-01523','2502','2','LT HRF D BT AD 5BJ 700 SRT 2LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'2700000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'2700000'  WHERE tanggal='2025-08-03'
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-01523','2025-08-03','2025-08-03','10:29:27','PLG0017019','2502','90','2025-11-01','sales','2025-08-03 10:29:26','4.090','2700000','3.00','243000','2943000','0','OPEN','8.47','2','2025-11-01','0','2943000')
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-250803-0003','K','2025-08-03','10:29:27','sales','HUTANG','PI25-01523','60552121','2700000','57852121','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI25-01523' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI25-01523';
UPDATE tt_hutang_head SET byr_harus_rp='2000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'2006000',tgl_lunas='2025-08-03',status='CLOS',total_lunas='2006000' WHERE no_hutang='PI25-01520';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'2000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'2000000'  WHERE tanggal='2025-08-03';
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-250803-0004','D','2025-08-03','10:30:29','cashier1','HUTANG LUNAS','PI25-01520','57852121','2006000','59858121');
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-00008645','X-00008645','CN COR TDK BT SMBR PTH LC2','GR','---','MDCN','BELI','BELI001','1911000','2025-08-03','2.760','1','sales','2025-08-03 12:06:08');
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-00008645','X-00008645');
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-250803-0001','FJ-250223-0006','2107','1','BELI','BELI001','MDCN', 'X-00008645', 'CN COR TDK BT SMBR PTH LC2','2.760','2.760','100.00','1980500','1911000','692391','1','1911000','1911000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.760',berat_beli_asli=berat_beli_asli+'2.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.760',berat_akhir_asli=berat_akhir_asli+'2.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-08-03' 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-250803-0001','2025-08-03','2025-08-03','12:06:08','2107','---','2.760','1911000','1911000','1911000','1911000','1911000','sales','2025-08-03 12:06:08','FB-250803-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250803-0001','ASMADIN','BULAK JAYA G8/12','','','083857980950','sales','2025-08-03 12:06:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-08-03' 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-250803-0005','K','2025-08-03','12:06:08','sales','PEMBELIAN UMUM','FB-250803-0001','59858121','1911000','57947121','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250803-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250803-0001';