INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:13:58'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-19','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-16'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-18'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-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='2026-03-18' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-18'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-18'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-18'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-18'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-19' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-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-260319-0001','D','2026-03-19','10:14:12','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); 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-260319-0001','D','2026-03-19','10:14:12','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260319-0001','D','2026-03-19','10:14:12','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260319-0001','D','2026-03-19','10:14:12','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260319-0001','D','2026-03-19','10:14:12','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260319-0001','D','2026-03-19','10:14:12','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260319-0001','D','2026-03-19','10:14:12','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260319-0001','D','2026-03-19','10:14:12','4000000','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-260319-0001','D','2026-03-19','10:14:12','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260319-0001','D','2026-03-19','10:14:12','3450000','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-260319-0001','D','2026-03-19','10:14:12','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260319-0001','D','2026-03-19','10:14:12','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260319-0001','D','2026-03-19','10:14:12','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260319-0001','D','2026-03-19','10:14:12','BCA','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-260319-0001','D','2026-03-19','10:14:12','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260319-0001','D','2026-03-19','10:14:12','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260319-0001','D','2026-03-19','10:14:12','6000000','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-260319-0001','D','2026-03-19','10:14:12','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260319-0001','D','2026-03-19','10:14:12','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260319-0001','D','2026-03-19','10:14:12','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260319-0001','D','2026-03-19','10:14:12','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260319-0001','D','2026-03-19','10:14:12','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260319-0001','D','2026-03-19','10:14:12','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); UPDATE tp_system SET tgl_system='2026-03-19'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:14:23'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-20','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-17'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-19'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-19'; 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='2026-03-19' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-19'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-19'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-19'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-19'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-20' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-19' 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-260320-0001','D','2026-03-20','10:14:32','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); 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-260320-0001','D','2026-03-20','10:14:32','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260320-0001','D','2026-03-20','10:14:32','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260320-0001','D','2026-03-20','10:14:32','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260320-0001','D','2026-03-20','10:14:32','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260320-0001','D','2026-03-20','10:14:32','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260320-0001','D','2026-03-20','10:14:32','6000000','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-260320-0001','D','2026-03-20','10:14:32','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260320-0001','D','2026-03-20','10:14:32','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260320-0001','D','2026-03-20','10:14:32','BCA','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-260320-0001','D','2026-03-20','10:14:32','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260320-0001','D','2026-03-20','10:14:32','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260320-0001','D','2026-03-20','10:14:32','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260320-0001','D','2026-03-20','10:14:32','3450000','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-260320-0001','D','2026-03-20','10:14:32','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260320-0001','D','2026-03-20','10:14:32','4000000','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-260320-0001','D','2026-03-20','10:14:32','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260320-0001','D','2026-03-20','10:14:32','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260320-0001','D','2026-03-20','10:14:32','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260320-0001','D','2026-03-20','10:14:32','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260320-0001','D','2026-03-20','10:14:32','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260320-0001','D','2026-03-20','10:14:32','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260320-0001','D','2026-03-20','10:14:32','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); UPDATE tp_system SET tgl_system='2026-03-20'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:14:42'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-21','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-18'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-20'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-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='2026-03-20' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-20'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-20'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-20'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-20'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-21' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-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-260321-0001','D','2026-03-21','10:14:50','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); 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-260321-0001','D','2026-03-21','10:14:50','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260321-0001','D','2026-03-21','10:14:50','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260321-0001','D','2026-03-21','10:14:50','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260321-0001','D','2026-03-21','10:14:50','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260321-0001','D','2026-03-21','10:14:50','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260321-0001','D','2026-03-21','10:14:50','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260321-0001','D','2026-03-21','10:14:50','4000000','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-260321-0001','D','2026-03-21','10:14:50','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260321-0001','D','2026-03-21','10:14:50','3450000','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-260321-0001','D','2026-03-21','10:14:50','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260321-0001','D','2026-03-21','10:14:50','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260321-0001','D','2026-03-21','10:14:50','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260321-0001','D','2026-03-21','10:14:50','BCA','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-260321-0001','D','2026-03-21','10:14:50','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260321-0001','D','2026-03-21','10:14:50','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260321-0001','D','2026-03-21','10:14:50','6000000','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-260321-0001','D','2026-03-21','10:14:50','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260321-0001','D','2026-03-21','10:14:50','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260321-0001','D','2026-03-21','10:14:50','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260321-0001','D','2026-03-21','10:14:50','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260321-0001','D','2026-03-21','10:14:50','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260321-0001','D','2026-03-21','10:14:50','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); UPDATE tp_system SET tgl_system='2026-03-21'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:15:00'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-22','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-19'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-21'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-21'; 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='2026-03-21' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-21'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-21'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-21'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-21'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-22' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-21' 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-260322-0001','D','2026-03-22','10:15:10','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); 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-260322-0001','D','2026-03-22','10:15:10','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260322-0001','D','2026-03-22','10:15:10','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260322-0001','D','2026-03-22','10:15:10','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260322-0001','D','2026-03-22','10:15:10','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260322-0001','D','2026-03-22','10:15:10','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260322-0001','D','2026-03-22','10:15:10','6000000','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-260322-0001','D','2026-03-22','10:15:10','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260322-0001','D','2026-03-22','10:15:10','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260322-0001','D','2026-03-22','10:15:10','BCA','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-260322-0001','D','2026-03-22','10:15:10','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260322-0001','D','2026-03-22','10:15:10','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260322-0001','D','2026-03-22','10:15:10','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260322-0001','D','2026-03-22','10:15:10','3450000','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-260322-0001','D','2026-03-22','10:15:10','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260322-0001','D','2026-03-22','10:15:10','4000000','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-260322-0001','D','2026-03-22','10:15:10','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260322-0001','D','2026-03-22','10:15:10','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260322-0001','D','2026-03-22','10:15:10','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260322-0001','D','2026-03-22','10:15:10','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260322-0001','D','2026-03-22','10:15:10','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260322-0001','D','2026-03-22','10:15:10','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260322-0001','D','2026-03-22','10:15:10','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); UPDATE tp_system SET tgl_system='2026-03-22'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:15:18'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-23','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-20'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-22'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-22'; 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='2026-03-22' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-22'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-22'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-22'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-22'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-23' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-22' 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-260323-0001','D','2026-03-23','10:15:27','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); 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-260323-0001','D','2026-03-23','10:15:27','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260323-0001','D','2026-03-23','10:15:27','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260323-0001','D','2026-03-23','10:15:27','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260323-0001','D','2026-03-23','10:15:27','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260323-0001','D','2026-03-23','10:15:27','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260323-0001','D','2026-03-23','10:15:27','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260323-0001','D','2026-03-23','10:15:27','4000000','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-260323-0001','D','2026-03-23','10:15:27','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260323-0001','D','2026-03-23','10:15:27','3450000','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-260323-0001','D','2026-03-23','10:15:27','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260323-0001','D','2026-03-23','10:15:27','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260323-0001','D','2026-03-23','10:15:27','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260323-0001','D','2026-03-23','10:15:27','BCA','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-260323-0001','D','2026-03-23','10:15:27','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260323-0001','D','2026-03-23','10:15:27','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260323-0001','D','2026-03-23','10:15:27','6000000','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-260323-0001','D','2026-03-23','10:15:27','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260323-0001','D','2026-03-23','10:15:27','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260323-0001','D','2026-03-23','10:15:27','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260323-0001','D','2026-03-23','10:15:27','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260323-0001','D','2026-03-23','10:15:27','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260323-0001','D','2026-03-23','10:15:27','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); UPDATE tp_system SET tgl_system='2026-03-23'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:15:35'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-24','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-21'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-23'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-23'; 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='2026-03-23' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-23'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-23'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-23'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-23'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-24' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-23' 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-260324-0001','D','2026-03-24','10:15:44','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); 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-260324-0001','D','2026-03-24','10:15:44','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260324-0001','D','2026-03-24','10:15:44','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260324-0001','D','2026-03-24','10:15:44','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260324-0001','D','2026-03-24','10:15:44','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260324-0001','D','2026-03-24','10:15:44','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260324-0001','D','2026-03-24','10:15:44','6000000','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-260324-0001','D','2026-03-24','10:15:44','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260324-0001','D','2026-03-24','10:15:44','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260324-0001','D','2026-03-24','10:15:44','BCA','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-260324-0001','D','2026-03-24','10:15:44','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260324-0001','D','2026-03-24','10:15:44','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260324-0001','D','2026-03-24','10:15:44','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260324-0001','D','2026-03-24','10:15:44','3450000','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-260324-0001','D','2026-03-24','10:15:44','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260324-0001','D','2026-03-24','10:15:44','4000000','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-260324-0001','D','2026-03-24','10:15:44','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260324-0001','D','2026-03-24','10:15:44','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260324-0001','D','2026-03-24','10:15:44','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260324-0001','D','2026-03-24','10:15:44','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260324-0001','D','2026-03-24','10:15:44','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260324-0001','D','2026-03-24','10:15:44','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260324-0001','D','2026-03-24','10:15:44','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); UPDATE tp_system SET tgl_system='2026-03-24'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:15:53'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-25','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-22'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-24'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-24'; 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='2026-03-24' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-24'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-24'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-24'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-24'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-25' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-24' 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-260325-0001','D','2026-03-25','10:16:02','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); 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-260325-0001','D','2026-03-25','10:16:02','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260325-0001','D','2026-03-25','10:16:02','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260325-0001','D','2026-03-25','10:16:02','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260325-0001','D','2026-03-25','10:16:02','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260325-0001','D','2026-03-25','10:16:02','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260325-0001','D','2026-03-25','10:16:02','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260325-0001','D','2026-03-25','10:16:02','4000000','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-260325-0001','D','2026-03-25','10:16:02','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260325-0001','D','2026-03-25','10:16:02','3450000','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-260325-0001','D','2026-03-25','10:16:02','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260325-0001','D','2026-03-25','10:16:02','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260325-0001','D','2026-03-25','10:16:02','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260325-0001','D','2026-03-25','10:16:02','BCA','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-260325-0001','D','2026-03-25','10:16:02','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260325-0001','D','2026-03-25','10:16:02','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260325-0001','D','2026-03-25','10:16:02','6000000','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-260325-0001','D','2026-03-25','10:16:02','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260325-0001','D','2026-03-25','10:16:02','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260325-0001','D','2026-03-25','10:16:02','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260325-0001','D','2026-03-25','10:16:02','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260325-0001','D','2026-03-25','10:16:02','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260325-0001','D','2026-03-25','10:16:02','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); UPDATE tp_system SET tgl_system='2026-03-25'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:16:16'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-26','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-23'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-25'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-25'; 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='2026-03-25' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-25'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-25'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-25'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-25'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-26' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-25' 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-260326-0001','D','2026-03-26','10:16:26','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); 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-260326-0001','D','2026-03-26','10:16:26','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260326-0001','D','2026-03-26','10:16:26','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260326-0001','D','2026-03-26','10:16:26','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260326-0001','D','2026-03-26','10:16:26','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260326-0001','D','2026-03-26','10:16:26','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260326-0001','D','2026-03-26','10:16:26','6000000','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-260326-0001','D','2026-03-26','10:16:26','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260326-0001','D','2026-03-26','10:16:26','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260326-0001','D','2026-03-26','10:16:26','BCA','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-260326-0001','D','2026-03-26','10:16:26','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260326-0001','D','2026-03-26','10:16:26','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260326-0001','D','2026-03-26','10:16:26','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260326-0001','D','2026-03-26','10:16:26','3450000','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-260326-0001','D','2026-03-26','10:16:26','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260326-0001','D','2026-03-26','10:16:26','4000000','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-260326-0001','D','2026-03-26','10:16:26','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260326-0001','D','2026-03-26','10:16:26','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260326-0001','D','2026-03-26','10:16:26','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260326-0001','D','2026-03-26','10:16:26','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260326-0001','D','2026-03-26','10:16:26','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260326-0001','D','2026-03-26','10:16:26','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260326-0001','D','2026-03-26','10:16:26','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); UPDATE tp_system SET tgl_system='2026-03-26'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:16:36'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-27','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-24'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-26'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-26'; 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='2026-03-26' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-26'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-26'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-26'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-26'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-27' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-26' 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-260327-0001','D','2026-03-27','10:16:46','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); 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-260327-0001','D','2026-03-27','10:16:46','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260327-0001','D','2026-03-27','10:16:46','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260327-0001','D','2026-03-27','10:16:46','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260327-0001','D','2026-03-27','10:16:46','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260327-0001','D','2026-03-27','10:16:46','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260327-0001','D','2026-03-27','10:16:46','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260327-0001','D','2026-03-27','10:16:46','4000000','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-260327-0001','D','2026-03-27','10:16:46','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260327-0001','D','2026-03-27','10:16:46','3450000','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-260327-0001','D','2026-03-27','10:16:46','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260327-0001','D','2026-03-27','10:16:46','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260327-0001','D','2026-03-27','10:16:46','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260327-0001','D','2026-03-27','10:16:46','BCA','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-260327-0001','D','2026-03-27','10:16:46','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260327-0001','D','2026-03-27','10:16:46','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260327-0001','D','2026-03-27','10:16:46','6000000','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-260327-0001','D','2026-03-27','10:16:46','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260327-0001','D','2026-03-27','10:16:46','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260327-0001','D','2026-03-27','10:16:46','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260327-0001','D','2026-03-27','10:16:46','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260327-0001','D','2026-03-27','10:16:46','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260327-0001','D','2026-03-27','10:16:46','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); UPDATE tp_system SET tgl_system='2026-03-27'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:17:00'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-28','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-25'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-27'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-27'; 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='2026-03-27' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-27'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-27'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-27'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-27'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-28' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-27' 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-260328-0001','D','2026-03-28','10:17:13','TBC','SALDO AWAL','SALDO AWAL','0','95907986885','95907986885'); 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-260328-0001','D','2026-03-28','10:17:13','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); 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-260328-0001','D','2026-03-28','10:17:13','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260328-0001','D','2026-03-28','10:17:13','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260328-0001','D','2026-03-28','10:17:13','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260328-0001','D','2026-03-28','10:17:13','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260328-0001','D','2026-03-28','10:17:13','6000000','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-260328-0001','D','2026-03-28','10:17:13','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260328-0001','D','2026-03-28','10:17:13','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260328-0001','D','2026-03-28','10:17:13','BCA','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-260328-0001','D','2026-03-28','10:17:13','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260328-0001','D','2026-03-28','10:17:13','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260328-0001','D','2026-03-28','10:17:13','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260328-0001','D','2026-03-28','10:17:13','3450000','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-260328-0001','D','2026-03-28','10:17:13','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260328-0001','D','2026-03-28','10:17:13','4000000','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-260328-0001','D','2026-03-28','10:17:13','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260328-0001','D','2026-03-28','10:17:13','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260328-0001','D','2026-03-28','10:17:13','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260328-0001','D','2026-03-28','10:17:13','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260328-0001','D','2026-03-28','10:17:13','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260328-0001','D','2026-03-28','10:17:13','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260328-0001','D','2026-03-28','10:17:13','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); UPDATE tp_system SET tgl_system='2026-03-28'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','10:17:22'); DELETE FROM tm_berlian WHERE kode_barang='LMP-XLBF-36-0'; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('LMP-XLBF-36-0','00032925','00032925','LIONTIN MAS PUTIH','LIONTIN MAS PUTIH','','','433500','433500',' 0','0','kasir','2026-03-28 11:04:45'); UPDATE tm_barang SET nama_barang='LIONTIN MAS PUTIH' ,nama_atribut='' ,kode_intern='LMPE75-85% ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='75',total_usd_ext='',total_usd='0' WHERE kode_barang='LMP-XLBF-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LMP-XLBF-45-0'; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('LMP-XLBF-45-0','00032934','00032934','LIONTIN MAS PUTIH','LIONTIN MAS PUTIH','','','542000','542000',' 0','0','kasir','2026-03-28 11:05:15'); UPDATE tm_barang SET nama_barang='LIONTIN MAS PUTIH' ,nama_atribut='' ,kode_intern='LMPE75-85% ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='75',total_usd_ext='',total_usd='0' WHERE kode_barang='LMP-XLBF-45-0' 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,potong_rp,keterangan) VALUES ('FE-260328-0001','kasir','1',' LMPE75-85%','TOKO','LMP','LMP-XLBF-36-0','LIONTIN MAS PUTIH','','0.200','1','85.00','438000','0','0','17100','454000','0','0','0','454000','IQB','00032925','LMP','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMP-XLBF-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='LMP-XLBF-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LMP' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0001','2026-03-28','0.200','2026-03-28','11:06:57','PLG0028256','454000','454000','0','454000','0','kasir','2026-03-28 11:06:57','FE-260328-0001','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0001','2026-03-28','11:06:57','IQB','454000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0001','2026-03-28','2026-03-28 11:06:57','PENJUALAN : FE-260328-0001','.','TBC','454000','454000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0002','D','2026-03-28','11:06:57','TBC','PENJUALAN','FE-260328-0001','95907986885','454000','95908440885','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='454000' WHERE no_faktur_jual='FE-260328-0001' 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,potong_rp,keterangan) VALUES ('FE-260328-0002','kasir',' 1',' LMPE75-85%','TOKO','LMP','LMP-XLBF-45-0','LIONTIN MAS PUTIH','','0.250','1','85.00','548000','0','0','17100','566000','0','0','0','566000','IQB','00032934','LMP','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMP-XLBF-45-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='LMP-XLBF-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LMP' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0002','2026-03-28','0.250','2026-03-28','11:06:57','PLG0028257','566000','566000','0','566000','0','kasir','2026-03-28 11:06:57','FE-260328-0001','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0002','2026-03-28','11:06:57','IQB','566000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0002','2026-03-28','2026-03-28 11:06:57','PENJUALAN : FE-260328-0002','.','TBC','566000','566000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0003','D','2026-03-28','11:06:57','TBC','PENJUALAN','FE-260328-0002','95908440885','566000','95909006885','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1020000' WHERE no_faktur_jual='FE-260328-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-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,keterangan) VALUES ('FE-260328-0003','kasir','1',' LBRE-00024','TOKO','LBR','LBRE-ZAAI-11-0','LIONTIN LBRE-00024 ','','1.130','1','75.00','4835000','2233500','131','17100','6400000','0','0','0','6400000','ILU','00040993','LBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LBRE-ZAAI-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='LBRE-ZAAI-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0003','2026-03-28','1.130','2026-03-28','12:16:18','PLG0028258','6400000','6400000','0','6400000','0','kasir','2026-03-28 12:16:18','FE-260328-0003','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0003','2026-03-28','12:16:18','ILU','6400000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0003','2026-03-28','2026-03-28 12:16:18','PENJUALAN : FE-260328-0003','','TBC','6400000','6400000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0004','D','2026-03-28','12:16:18','TBC','PENJUALAN BERLIAN','FE-260328-0003','95909006885','6400000','95915406885','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6400000' WHERE no_faktur_jual='FE-260328-0003' 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,potong_rp,keterangan) VALUES ('FE-260328-0004','kasir',' 1',' KMPE75-85%','TOKO','KMP','KMP-ZBBE-88-0','KALUNG MAS PUTIH ','','1.600','1','85.00','3538000','0','0','17100','3600000','0','0','0','3600000','ILU','00041874','KMP','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='KMP-ZBBE-88-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='2026-03-28' AND kode_barang='KMP-ZBBE-88-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='KMP' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0004','2026-03-28','1.600','2026-03-28','12:16:18','PLG0028259','3600000','3600000','0','3600000','0','kasir','2026-03-28 12:16:18','FE-260328-0003','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0004','2026-03-28','12:16:18','ILU','3600000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0004','2026-03-28','2026-03-28 12:16:18','PENJUALAN : FE-260328-0004','','TBC','3600000','3600000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0005','D','2026-03-28','12:16:18','TBC','PENJUALAN','FE-260328-0004','95915406885','3600000','95919006885','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='10000000' WHERE no_faktur_jual='FE-260328-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-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,keterangan) VALUES ('FE-260328-0005','kasir','1',' GLKPE75-83','TOKO','GLK','GLKP-XLBG-42-0','GELANG KAKU PUTIH ','','2.560','1','83.00','5473000','0','0','17100','5600000','0','0','0','5600000','IQB','00033002','GLKP','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='GLKP-XLBG-42-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.560',berat_jual_asli=berat_jual_asli+'2.560',stock_jual='1',berat_akhir=berat_akhir-'2.560',berat_akhir_asli=berat_akhir_asli-'2.560',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='GLKP-XLBG-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='GLK' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0005','2026-03-28','2.560','2026-03-28','13:41:59','PLG0028260','5600000','5600000','0','5600000','0','kasir','2026-03-28 13:41:59','FE-260328-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0005','2026-03-28','13:41:59','IQB','5600000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0005','2026-03-28','2026-03-28 13:41:59','PENJUALAN : FE-260328-0005','','TBC','5600000','5600000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0006','D','2026-03-28','13:41:59','TBC','PENJUALAN','FE-260328-0005','95919006885','5600000','95924606885','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='5600000' WHERE no_faktur_jual='FE-260328-0005' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0005'; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02967','NANA','1','GOLD','WEDDING RING','','','2.000','','75.00','1','2550000','2450000','0','850000','5750000','size 12 grf E L sesuai contoh luxury 02','permata zirkon 21 butir','crum putih','0','300000',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260328-0006','2026-03-28','2026-03-28 15:15:47','PESANAN : DP-02967','.','TBC','3025000','3025000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0007','D','2026-03-28','15:15:47','TBC','PESANAN','DP-02967','95924606885','3025000','95927631885','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02967','2026-03-28','2026-03-28','15:15:47','PLG0028261','NANA','2026-04-30','kasir','2026-03-28 15:15:47','2.000','0','0','0','3025000','0','850000','6050000','6050000','3025000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02968','NANA','1','PER','WEDDING RING','','','1.000','','92.50','1','100000','0','0','850000','850000','size 24 grf E L','model papan list pakai 1 mata zirkon','crum putih doff amplas','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260328-0007','2026-03-28','2026-03-28 15:18:05','PESANAN : DP-02968','.','TBC','850000','850000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0008','D','2026-03-28','15:18:05','TBC','PESANAN','DP-02968','95927631885','850000','95928481885','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02968','2026-03-28','2026-03-28','15:18:05','PLG0028262','NANA','2026-04-11','kasir','2026-03-28 15:18:05','1.000','0','0','0','850000','0','850000','850000','850000','0'); 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,keterangan) VALUES ('FE-260328-0006','kasir','1',' SYC-00021 ','TOKO','CBR','SYC-XEXG-14-0','CINCIN SYC-00021','','3.240','1','83.00','11488000','3131500','183','17100','13500000','0','0','0','13500000','ILU','00028196','SYC','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='SYC-XEXG-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.240',berat_jual_asli=berat_jual_asli+'3.240',stock_jual='1',berat_akhir=berat_akhir-'3.240',berat_akhir_asli=berat_akhir_asli-'3.240',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='SYC-XEXG-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0006','2026-03-28','3.240','2026-03-28','15:26:31','PLG0028263','13500000','13500000','0','13500000','0','kasir','2026-03-28 15:26:30','FE-260328-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0006','2026-03-28','15:26:31','ILU','13500000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0008','2026-03-28','2026-03-28 15:26:30','PENJUALAN : FE-260328-0006','.','TBC','13500000','13500000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0009','D','2026-03-28','15:26:31','TBC','PENJUALAN BERLIAN','FE-260328-0006','95928481885','13500000','95941981885','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='13500000' WHERE no_faktur_jual='FE-260328-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0006'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08079','ILU','1','SYC00021','RESIZE KE 13 GRF TANTANG CRUM FULL PUTIH','3.240','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-08079','2026-03-28','2026-03-28','15:29:51','PLG0028264','kasir','2026-04-09','kasir','2026-03-28 15:29:51','3.240','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-28 ','15:30:32'); 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-00009141','X-00009141','TFL21022','GR','---','LBR','BELI','BELI001','4062500','2026-03-28','1.690','1','kasir','2026-03-28 15:46:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-LBR'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-LBR','X-00009141','X-00009141'); 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 ('BE-260328-0001','00024262','BARY','1','BELI','BELI001','LBR', 'X-00009141', 'TFL21022','1.690','1.690','75.00','6250000','4062500','2403846','1','4062500','4062500','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.690',berat_beli_asli=berat_beli_asli+'1.690',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.690',berat_akhir_asli=berat_akhir_asli+'1.690',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='LBR' 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,type_bayar) VALUES ('BE-260328-0001','2026-03-28','2026-03-28','15:46:11','BARY','---','1.690','4062500','4062500','4062500','4062500','4062500','kasir','2026-03-28 15:46:11','BE-260328-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260328-0001','-','-','','','','kasir','2026-03-28 15:46:11'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260328-0009','2026-03-28','2026-03-28 15:46:11','PEMBELIAN UMUM : BE-260328-0001','-','TBC','4062500','4062500'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-260328-0010','K','2026-03-28','15:46:11','TBC','PEMBELIAN UMUM','BE-260328-0001','95941981885','4062500','95937919385','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260328-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260328-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,keterangan) VALUES ('FE-260328-0007','kasir','1',' KMKE70-71%','TOKO','KMK','KMK-XAAA-10-0','KALUNG MAS KUNING ','','2.870','1','71.00','5301000','0','0','17100','5600000','0','0','0','5600000','NANA','00025770','KMK','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='KMK-XAAA-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='KMK-XAAA-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='KMK' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0007','2026-03-28','2.870','2026-03-28','16:04:51','PLG0028265','5600000','5600000','0','5600000','0','kasir','2026-03-28 16:04:50','FE-260328-0007','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0007','2026-03-28','16:04:51','NANA','5600000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0010','2026-03-28','2026-03-28 16:04:50','PENJUALAN : FE-260328-0007','','TBC','5600000','5600000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0011','D','2026-03-28','16:04:51','TBC','PENJUALAN','FE-260328-0007','95937919385','5600000','95943519385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='5600000' WHERE no_faktur_jual='FE-260328-0007' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02969','IQB','1','PLD','WEDDING RING','','','2.500','','10.00','1','1200000','300000','0','750000','1500000','size 17 5 grf joseph s','pakai 1 mata zirkon sesuai contoh putih doff semprot','lebar 3mm','0','10000',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260328-0011','2026-03-28','2026-03-28 17:02:30','PESANAN : DP-02969','.','TBC','750000','750000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0012','D','2026-03-28','17:02:30','TBC','PESANAN','DP-02969','95943519385','750000','95944269385','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02969','2026-03-28','2026-03-28','17:02:30','PLG0028266','IQB','2026-04-11','kasir','2026-03-28 17:02:30','2.500','0','0','0','750000','0','750000','1510000','1510000','760000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02970','IQB','1','PLD','WEDDING RING','','','4.000','','10.00','1','1200000','300000','0','750000','1950000','size 20 5n grf Yuni T tanpa mata','lebar 4.5mm sesuai contoh putih doff semprot','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260328-0012','2026-03-28','2026-03-28 17:04:28','PESANAN : DP-02970','.','TBC','750000','750000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0013','D','2026-03-28','17:04:28','TBC','PESANAN','DP-02970','95944269385','750000','95945019385','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02970','2026-03-28','2026-03-28','17:04:28','PLG0028267','IQB','2026-04-30','kasir','2026-03-28 17:04:28','4.000','0','0','0','750000','0','750000','1950000','1950000','1200000'); 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,keterangan) VALUES ('FE-260328-0008','kasir','1',' KLBE-00226','TOKO','KLB','KLBE-YCAX-2-0','KALUNG KLBE-00226','','3.950','1','83.00','13945000','3765000','220','17100','15000000','0','0','0','15000000','BARY','00034659','KLBE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='KLBE-YCAX-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.950',berat_jual_asli=berat_jual_asli+'3.950',stock_jual='1',berat_akhir=berat_akhir-'3.950',berat_akhir_asli=berat_akhir_asli-'3.950',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='KLBE-YCAX-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='KLB' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0008','2026-03-28','3.950','2026-03-28','17:18:08','PLG0028268','15000000','15000000','0','15000000','0','kasir','2026-03-28 17:18:08','FE-260328-0008','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0008','2026-03-28','17:18:08','BARY','15000000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0013','2026-03-28','2026-03-28 17:18:08','PENJUALAN : FE-260328-0008','','TBC','15000000','15000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0014','D','2026-03-28','17:18:08','TBC','PENJUALAN BERLIAN','FE-260328-0008','95945019385','15000000','95960019385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='15000000' WHERE no_faktur_jual='FE-260328-0008' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0008'; 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,keterangan) VALUES ('FE-260328-0009','kasir','1',' CBRE-06625','TOKO','CBR','CBRE-YAXF-5-0','CINCIN CBRE-06625','','3.640','1','103.00','17740000','5865500','343','17100','19040000','0','0','0','19040000','ILU','00033204','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-YAXF-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.640',berat_jual_asli=berat_jual_asli+'3.640',stock_jual='1',berat_akhir=berat_akhir-'3.640',berat_akhir_asli=berat_akhir_asli-'3.640',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='CBRE-YAXF-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0009','2026-03-28','3.640','2026-03-28','18:07:29','PLG0028269','19040000','19040000','0','19040000','19040000','kasir','2026-03-28 18:07:28','FE-260328-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0009','2026-03-28','18:07:29','ILU','19040000','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-260328-0002','D','2026-03-28','18:07:29','kasir','PENJUALAN BERLIAN','FE-260328-0009','343940','19040000','19383940'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0009'; 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,keterangan) VALUES ('FE-260328-0010','kasir','1',' 500K-17-94','TOKO','PERAK','CKPRE-ZBAX-13-0','CINCIN SILVER 925 ','','1.930','1','100.00','197000','0','0','17100','700000','0','0','0','700000','IQB','00041449','CKPRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZBAX-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='CKPRE-ZBAX-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0010','2026-03-28','1.930','2026-03-28','18:43:23','PLG0028270','700000','700000','0','700000','0','kasir','2026-03-28 18:43:22','FE-260328-0010','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0010','2026-03-28','18:43:23','IQB','700000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0014','2026-03-28','2026-03-28 18:43:22','PENJUALAN : FE-260328-0010','.','TBC','700000','700000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0015','D','2026-03-28','18:43:23','TBC','PENJUALAN','FE-260328-0010','95960019385','700000','95960719385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FE-260328-0010' 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,potong_rp,keterangan) VALUES ('FE-260328-0011','kasir',' 1',' 700K-15-95','TOKO','PERAK','CKPRE-ZBAX-23-0','CINCIN SILVER 925 ','','2.020','1','100.00','207000','0','0','17100','900000','0','0','0','900000','IQB','00041459','CKPRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZBAX-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='CKPRE-ZBAX-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0011','2026-03-28','2.020','2026-03-28','18:43:23','PLG0028271','900000','900000','0','900000','0','kasir','2026-03-28 18:43:22','FE-260328-0010','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0011','2026-03-28','18:43:23','IQB','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260328-0015','2026-03-28','2026-03-28 18:43:22','PENJUALAN : FE-260328-0011','.','TBC','900000','900000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260328-0016','D','2026-03-28','18:43:23','TBC','PENJUALAN','FE-260328-0011','95960719385','900000','95961619385','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1600000' WHERE no_faktur_jual='FE-260328-0011' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0011'; 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,keterangan) VALUES ('FE-260328-0012','kasir','1',' CBRE-06966','TOKO','CBR','CBRE-ZABA-31-0','CINCIN CBRE-06966 ','','0.550','1','83.00','1880000','544000','32','17100','2500000','0','0','0','2500000','ILU','00041078','CBRE','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZABA-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-03-28' AND kode_barang='CBRE-ZABA-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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,no_persekot,dp_pesanan) VALUES ('FE-260328-0012','2026-03-28','0.550','2026-03-28','18:53:29','PLG0028272','2500000','2500000','0','2500000','2500000','kasir','2026-03-28 18:53:28','FE-260328-0012','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-28','FE-260328-0012','2026-03-28','18:53:29','ILU','2500000','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-260328-0003','D','2026-03-28','18:53:29','kasir','PENJUALAN BERLIAN','FE-260328-0012','19383940','2500000','21883940'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260328-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260328-0012'; 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-00009142','X-00009142','CINCIN CBRE-02912','GR','---','CBRE','BELI','BELI001','3200000','2026-03-28','0.840','1','kasir','2026-03-28 19:20:10'); DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00009142','X-00009142'); 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 ('BE-260328-0002','FE-260310-0004','FIR','1','BELI','BELI001','CBRE', 'X-00009142', 'CINCIN CBRE-02912','0.950','0.840','75.00','4000000','3200000','3809524','1','3200000','3200000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.840',berat_beli_asli=berat_beli_asli+'0.840',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.840',berat_akhir_asli=berat_akhir_asli+'0.840',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRE' 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,type_bayar) VALUES ('BE-260328-0002','2026-03-28','2026-03-28','19:20:10','FIR','---','0.840','3200000','3200000','3200000','3200000','3200000','kasir','2026-03-28 19:20:10','BE-260328-0002','OPEN','CASH'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260328-0002','YUSUF','JKT','','','0','kasir','2026-03-28 19:20:10'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-28' 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-260328-0004','K','2026-03-28','19:20:10','kasir','PEMBELIAN UMUM','BE-260328-0002','21883940','3200000','18683940','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-00009143','X-00009143','CINCIN CBRE-03821','GR','---','CBRE','BELI','BELI001','15040000','2026-03-28','5.710','1','kasir','2026-03-28 19:23:12'); DELETE FROM tp_barang WHERE kode_dept = 'X-CBRE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRE','X-00009143','X-00009143'); 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 ('BE-260328-0003','FE-230521-0016','ILU','1','BELI','BELI001','CBRE', 'X-00009143', 'CINCIN CBRE-03821','5.710','5.710','75.00','18800000','15040000','2633975','1','15040000','15040000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.710',berat_beli_asli=berat_beli_asli+'5.710',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.710',berat_akhir_asli=berat_akhir_asli+'5.710',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRE' 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,type_bayar) VALUES ('BE-260328-0003','2026-03-28','2026-03-28','19:23:12','ILU','---','5.710','15040000','15040000','15040000','15040000','15040000','kasir','2026-03-28 19:23:12','BE-260328-0003','OPEN','CASH'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-260328-0003','KARTINI','JAKARTA','-','JAKARTA','08119343939','kasir','2026-03-28 19:23:12'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-28' 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-260328-0005','K','2026-03-28','19:23:12','kasir','PEMBELIAN UMUM','BE-260328-0003','18683940','15040000','3643940','OPEN'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260328-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260328-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-260328-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-260328-0003'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-29','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-26'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-28'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-28'; 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='2026-03-28' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-28'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-28'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-28'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-28'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02'; UPDATE tt_barang_saldo SET tanggal= '2026-03-29' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-28' 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-260329-0001','D','2026-03-29','20:15:36','TBC','SALDO AWAL','SALDO AWAL','0','95961619385','95961619385'); 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-260329-0001','D','2026-03-29','20:15:36','BCK','SALDO AWAL','SALDO AWAL','0','16490607978.088','16490607978.088'); 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-260329-0001','D','2026-03-29','20:15:36','BCD','SALDO AWAL','SALDO AWAL','0','14996321700','14996321700'); 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-260329-0001','D','2026-03-29','20:15:36','TMR','SALDO AWAL','SALDO AWAL','0','8562183779','8562183779'); 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-260329-0001','D','2026-03-29','20:15:36','SHO','SALDO AWAL','SALDO AWAL','0','2747005684','2747005684'); 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-260329-0001','D','2026-03-29','20:15:36','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900'); 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-260329-0001','D','2026-03-29','20:15:36','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000'); 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-260329-0001','D','2026-03-29','20:15:36','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000'); 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-260329-0001','D','2026-03-29','20:15:36','4000000','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-260329-0001','D','2026-03-29','20:15:36','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000'); 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-260329-0001','D','2026-03-29','20:15:36','3450000','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-260329-0001','D','2026-03-29','20:15:36','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000'); 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-260329-0001','D','2026-03-29','20:15:36','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000'); 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-260329-0001','D','2026-03-29','20:15:36','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092'); 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-260329-0001','D','2026-03-29','20:15:36','BCA','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-260329-0001','D','2026-03-29','20:15:36','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000'); 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-260329-0001','D','2026-03-29','20:15:36','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000'); 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-260329-0001','D','2026-03-29','20:15:36','6000000','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-260329-0001','D','2026-03-29','20:15:36','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450'); 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-260329-0001','D','2026-03-29','20:15:36','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581'); 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-260329-0001','D','2026-03-29','20:15:36','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250'); 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-260329-0001','D','2026-03-29','20:15:36','','SALDO AWAL','SALDO AWAL','0','16885500','16885500'); 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-260329-0001','D','2026-03-29','20:15:36','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000'); UPDATE tp_system SET tgl_system='2026-03-29';