INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-24 ','10:21:29'); 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','11:31:07','BCD','SALDO AWAL','SALDO AWAL','0','1355733500','1355733500'); INSERT 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','11:31:07','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000'); INSERT 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','11:31:07','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650'); INSERT 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','11:31:07','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); INSERT 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','11:31:07','DPE','SALDO AWAL','SALDO AWAL','0','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) VALUES ('KM-260322-0001','D','2026-03-22','11:31:07','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); INSERT 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','11:31:07','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); INSERT 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','11:31:07','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); INSERT 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','11:31:07','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); INSERT 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','11:31:07','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000'); INSERT 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','11:31:07','TBC','SALDO AWAL','SALDO AWAL','0','21116661014','21116661014'); UPDATE tp_system SET tgl_system='2026-03-22'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-24 ','11:31:24'); 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','11:31:33','TBC','SALDO AWAL','SALDO AWAL','0','21116661014','21116661014'); INSERT 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','11:31:33','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000'); INSERT 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','11:31:33','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); INSERT 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','11:31:33','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); INSERT 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','11:31:33','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); INSERT 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','11:31:33','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); INSERT 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','11:31:33','DPE','SALDO AWAL','SALDO AWAL','0','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) VALUES ('KM-260323-0001','D','2026-03-23','11:31:33','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); INSERT 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','11:31:33','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650'); INSERT 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','11:31:33','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000'); INSERT 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','11:31:33','BCD','SALDO AWAL','SALDO AWAL','0','1355733500','1355733500'); UPDATE tp_system SET tgl_system='2026-03-23'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-24 ','11:31:46'); 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','11:31:56','BCD','SALDO AWAL','SALDO AWAL','0','1355733500','1355733500'); INSERT 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','11:31:56','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000'); INSERT 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','11:31:56','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650'); INSERT 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','11:31:56','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); INSERT 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','11:31:56','DPE','SALDO AWAL','SALDO AWAL','0','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) VALUES ('KM-260324-0001','D','2026-03-24','11:31:56','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); INSERT 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','11:31:56','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); INSERT 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','11:31:56','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); INSERT 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','11:31:56','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); INSERT 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','11:31:56','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000'); INSERT 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','11:31:56','TBC','SALDO AWAL','SALDO AWAL','0','21116661014','21116661014'); UPDATE tp_system SET tgl_system='2026-03-24'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-24 ','11:32:07'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-24 ','11:38:23'); 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 ('FJ-260324-0001','kasirbip','1',' 500K-15-00','TOKO','BIPPER','PBSD-YGBI-7-0','CINCIN SILVER 925 ','','1.360','1','100.00','29000','0','0','17000','600000','0','0','0','600000','MIA','00037643','PBSD','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBI-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBSD-YGBI-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0001','2026-03-24','1.360','2026-03-24','11:42:44','PLG0010100','600000','600000','0','600000','0','kasirbip','2026-03-24 11:42:43','FJ-260324-0001','','850000'); 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-24','FJ-260324-0001','2026-03-24','11:42:44','MIA','600000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260324-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 ('FJ-260324-0002','kasirbip',' 1',' 1.0K-7-221','TOKO','BIPPER','PBDG-ZBXF-36-0','CINCIN SILVER 925 ','','1.340','1','100.00','137000','0','0','17000','1100000','0','0','0','1100000','MIA','00041388','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBXF-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-ZBXF-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0002','2026-03-24','1.340','2026-03-24','11:42:44','PLG0010101','1100000','1100000','0','1100000','0','kasirbip','2026-03-24 11:42:43','FJ-260324-0001','','850000'); 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-24','FJ-260324-0002','2026-03-24','11:42:44','MIA','1100000','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-260324-0001','2026-03-24','2026-03-24 11:42:43','PENJUALAN : FJ-260324-0002','','','250000','250000','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-260324-0001','D','2026-03-24','11:42:44','','PENJUALAN','FJ-260324-0002','0','250000','250000','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='250000' WHERE no_faktur_jual='FJ-260324-0002' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-24 ','11:52:43'); 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 ('FJ-260324-0003','kasirbip','1',' DP-01780BI','TOKO','BIPPSN','PSPLT-ZCAB-11-0','CINCIN PALADIUM ','','4.280','1','17.00','961000','0','0','17000','2034000','0','0','0','2034000','KUR','00042306','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCAB-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.280',berat_jual_asli=berat_jual_asli+'4.280',stock_jual='1',berat_akhir=berat_akhir-'4.280',berat_akhir_asli=berat_akhir_asli-'4.280',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PSPLT-ZCAB-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-260324-0003','2026-03-24','4.280','2026-03-24','11:53:29','PLG0010102','2034000','2034000','0','2034000','0','kasirbip','2026-03-24 11:53:28','FJ-260324-0003','DP-01780','850000'); 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-24','FJ-260324-0003','2026-03-24','11:53:29','KUR','2034000','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-260324-0002','2026-03-24','2026-03-24 11:53:28','PENJUALAN : FJ-260324-0003','.','TBC','1184000','1184000','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-260324-0002','D','2026-03-24','11:53:29','TBC','PENJUALAN','FJ-260324-0003','21116661014','1184000','21117845014','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='1184000' WHERE no_faktur_jual='FJ-260324-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 ('FJ-260324-0004','kasirbip',' 1',' DP-01779BI','TOKO','BIPPSN','PSPLT-ZCAB-2-0','CINCIN PALADIUM ','','2.100','1','17.00','472000','0','0','17000','1510000','0','0','0','1510000','KUR','00042297','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCAB-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PSPLT-ZCAB-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-260324-0004','2026-03-24','2.100','2026-03-24','11:53:29','PLG0010103','1510000','1510000','0','1510000','0','kasirbip','2026-03-24 11:53:28','FJ-260324-0003','DP-01779','850000'); 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-24','FJ-260324-0004','2026-03-24','11:53:29','KUR','1510000','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-260324-0003','2026-03-24','2026-03-24 11:53:28','PENJUALAN : FJ-260324-0004','.','TBC','660000','660000','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-260324-0003','D','2026-03-24','11:53:29','TBC','PENJUALAN','FJ-260324-0004','21117845014','660000','21118505014','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='1844000' WHERE no_faktur_jual='FJ-260324-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-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 ('FJ-260324-0005','kasirbip','1',' 950K-115-2','TOKO','BIPPER','PBDG-ZCAA-50-0','CINCIN SILVER 925 ','','1.390','1','100.00','142000','0','0','17000','1050000','0','0','0','1050000','MIA','00042286','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCAA-50-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-ZCAA-50-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0005','2026-03-24','1.390','2026-03-24','12:16:07','PLG0010104','1050000','1050000','0','1050000','0','kasirbip','2026-03-24 12:16:07','FJ-260324-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-24','FJ-260324-0005','2026-03-24','12:16:07','MIA','1050000','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-260324-0004','2026-03-24','2026-03-24 12:16:07','PENJUALAN : FJ-260324-0005','.','TBC','1050000','1050000','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-260324-0004','D','2026-03-24','12:16:07','TBC','PENJUALAN','FJ-260324-0005','21118505014','1050000','21119555014','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='1050000' WHERE no_faktur_jual='FJ-260324-0005' 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 ('FJ-260324-0006','kasirbip',' 1',' 700K-18-15','TOKO','BIPPER','PBDG-YGBH-38-0','CINCIN SILVER 925 ','','4.440','1','100.00','91000','0','0','17000','900000','0','0','0','900000','MIA','00037620','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YGBH-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.440',berat_jual_asli=berat_jual_asli+'4.440',stock_jual='1',berat_akhir=berat_akhir-'4.440',berat_akhir_asli=berat_akhir_asli-'4.440',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-YGBH-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0006','2026-03-24','4.440','2026-03-24','12:16:07','PLG0010105','900000','900000','0','900000','0','kasirbip','2026-03-24 12:16:07','FJ-260324-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-24','FJ-260324-0006','2026-03-24','12:16:07','MIA','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-260324-0005','2026-03-24','2026-03-24 12:16:07','PENJUALAN : FJ-260324-0006','.','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-260324-0005','D','2026-03-24','12:16:07','TBC','PENJUALAN','FJ-260324-0006','21119555014','900000','21120455014','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='1950000' WHERE no_faktur_jual='FJ-260324-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0006'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01901','MIA','1','SEPASANG SILVER','CEWE PUTIH GLOSY SZ 10 5 COWO DOFT AMPELAS SZ 18 5 FONT VINTAGE ROTTER GRF','5.000','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-01901','2026-03-24','2026-03-24','12:27:19','PLG0010106','kasirbip','2026-04-19','kasirbip','2026-03-24 12:27:19','5.000','0','0','0','0','0','0','0','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 ('FJ-260324-0007','kasirbip','1',' 700K-18-19','TOKO','BIPPER','PBDG-YKBE-123-0','CINCIN SILVER 925 ','','2.100','1','100.00','129000','0','0','17000','850000','0','0','0','850000','SULIS','00039955','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-123-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-YKBE-123-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0007','2026-03-24','2.100','2026-03-24','12:32:13','PLG0010107','850000','850000','0','850000','0','kasirbip','2026-03-24 12:32:12','FJ-260324-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-24','FJ-260324-0007','2026-03-24','12:32:13','SULIS','850000','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-260324-0006','2026-03-24','2026-03-24 12:32:12','PENJUALAN : FJ-260324-0007','.','TBC','850000','850000','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-260324-0006','D','2026-03-24','12:32:13','TBC','PENJUALAN','FJ-260324-0007','21120455014','850000','21121305014','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='850000' WHERE no_faktur_jual='FJ-260324-0007' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0007'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01902','GIN','1','CINCIN SILVER','CROM PUTIH GLOSY RESIZE 18 FONT VLADIMIR GRF','1.500','1','200000','200000'); 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-260324-0007','2026-03-24','2026-03-24 12:36:10','SERVICE : SV-01902','.','TBC','200000','200000','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-260324-0007','D','2026-03-24','12:36:10','TBC','SERVICE','SV-01902','21121305014','200000','21121505014','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); 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-01902','2026-03-24','2026-03-24','12:36:10','PLG0010108','kasirbip','2026-04-30','kasirbip','2026-03-24 12:36:10','1.500','0','0','0','200000','0','200000','200000','0'); 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-01851','GIN','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','1 zirkon putih glosy','sz 10 font vladimir','grafir Zul','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260324-0008','2026-03-24','2026-03-24 12:49:12','PESANAN : DP-01851','.','TBC','900000','900000'); 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-260324-0008','D','2026-03-24','12:49:12','TBC','PESANAN','DP-01851','21121505014','900000','21122405014','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-01851','2026-03-24','2026-03-24','12:49:12','PLG0010109','GIN','2026-05-01','kasirbip','2026-03-24 12:49:12','2.000','0','0','0','900000','0','0','900000','900000','0'); 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-01852','GIN','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','1 zirkon putih glosy comb doff semprot','sz 20 font vladimir','grafir Santi','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-260324-0009','2026-03-24','2026-03-24 12:51:23','PESANAN : DP-01852','.','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-260324-0009','D','2026-03-24','12:51:23','TBC','PESANAN','DP-01852','21122405014','850000','21123255014','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-01852','2026-03-24','2026-03-24','12:51:23','PLG0010110','GIN','2026-05-01','kasirbip','2026-03-24 12:51:23','3.000','0','0','0','850000','0','0','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 ('FJ-260324-0008','kasirbip','1',' DP-01647BI','TOKO','BIPPSN','PSGT-ZBBC-75-0','CINCIN EMAS ','','5.770','1','83.00','13190000','0','0','17000','14986500','0','0','0','14986500','SULIS','00041736','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBBC-75-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.770',berat_jual_asli=berat_jual_asli+'5.770',stock_jual='1',berat_akhir=berat_akhir-'5.770',berat_akhir_asli=berat_akhir_asli-'5.770',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PSGT-ZBBC-75-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-260324-0008','2026-03-24','5.770','2026-03-24','13:07:37','PLG0010111','14986500','14986500','0','14986500','0','kasirbip','2026-03-24 13:07:37','FJ-260324-0008','DP-01647','7000000'); 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-24','FJ-260324-0008','2026-03-24','13:07:37','SULIS','14986500','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-260324-0010','2026-03-24','2026-03-24 13:07:37','PENJUALAN : FJ-260324-0008','.','TBC','7986500','7986500','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-260324-0010','D','2026-03-24','13:07:37','TBC','PENJUALAN','FJ-260324-0008','21123255014','7986500','21131241514','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='7986500' WHERE no_faktur_jual='FJ-260324-0008' 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 ('FJ-260324-0009','kasirbip',' 1',' DP-01648BI','TOKO','BIPPSN','PSPLT-ZBBC-81-0','CINCIN PALADIUM ','','7.510','1','32.00','3173000','0','0','17000','4605000','0','0','0','4605000','SULIS','00041742','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBBC-81-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.510',berat_jual_asli=berat_jual_asli+'7.510',stock_jual='1',berat_akhir=berat_akhir-'7.510',berat_akhir_asli=berat_akhir_asli-'7.510',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PSPLT-ZBBC-81-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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 ('FJ-260324-0009','2026-03-24','7.510','2026-03-24','13:07:37','PLG0010112','4605000','4605000','0','4605000','0','kasirbip','2026-03-24 13:07:37','FJ-260324-0008','DP-01648','2000000'); 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-24','FJ-260324-0009','2026-03-24','13:07:37','SULIS','4605000','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-260324-0011','2026-03-24','2026-03-24 13:07:37','PENJUALAN : FJ-260324-0009','.','TBC','2605000','2605000','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-260324-0011','D','2026-03-24','13:07:37','TBC','PENJUALAN','FJ-260324-0009','21131241514','2605000','21133846514','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='10591500' WHERE no_faktur_jual='FJ-260324-0009' 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-01853','MIA','1','GOLD','WED RING','','','2.000','','37.50','1','2550000','1500000','0','700000','3700000','1 zirkon putih glossy','sz 11.5 font brush script','grf S&F','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260324-0012','2026-03-24','2026-03-24 13:41:57','PESANAN : DP-01853','.','TBC','2960000','2960000'); 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-260324-0012','D','2026-03-24','13:41:57','TBC','PESANAN','DP-01853','21133846514','2960000','21136806514','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-01853','2026-03-24','2026-03-24','13:41:57','PLG0010113','MIA','2026-05-01','kasirbip','2026-03-24 13:41:57','2.000','0','0','0','2960000','0','700000','3700000','3700000','740000'); 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-01854','MIA','1','PER','WED RING','','','3.000','','925.00','1','100000','0','600000','0','600000','putih doff amplas','sz 15 font brush script','grafir S&F','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260324-0013','2026-03-24','2026-03-24 13:44:24','PESANAN : DP-01854','.','TBC','600000','600000'); 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-260324-0013','D','2026-03-24','13:44:24','TBC','PESANAN','DP-01854','21136806514','600000','21137406514','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-01854','2026-03-24','2026-03-24','13:44:24','PLG0010114','MIA','2026-05-01','kasirbip','2026-03-24 13:44:24','3.000','0','0','0','600000','0','0','600000','600000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0009'; 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-01855','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 18 putih glosy','model spt contoh','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260324-0014','2026-03-24','2026-03-24 14:08:14','PESANAN : DP-01855','.','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-260324-0014','D','2026-03-24','14:08:14','TBC','PESANAN','DP-01855','21137406514','850000','21138256514','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-01855','2026-03-24','2026-03-24','14:08:14','PLG0010115','SULIS','2026-05-02','kasirbip','2026-03-24 14:08:14','2.000','0','0','0','850000','0','0','850000','850000','0'); 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-01856','SULIS','1','PLD','WED RING','','','2.000','','10.00','1','1200000','300000','0','1200000','1800000','11 zircon (permata di sesuaikan butirannnya)','sz 2.5 putih kombinasi rosegold glosy','model spt contoh','110000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260324-0015','2026-03-24','2026-03-24 14:10:11','PESANAN : DP-01856','.','TBC','1528000','1528000'); 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-260324-0015','D','2026-03-24','14:10:11','TBC','PESANAN','DP-01856','21138256514','1528000','21139784514','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-01856','2026-03-24','2026-03-24','14:10:11','PLG0010116','SULIS','2026-05-02','kasirbip','2026-03-24 14:10:11','2.000','0','0','0','1528000','0','1200000','1910000','1910000','382000'); 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 ('FJ-260324-0010','kasirbip','1',' TFPER-0004','TOKO','BIPPER','TFPER-YBXD-25-0','CINCIN PERAK TFPER-00044 ','','4.620','1','100.00','279000','150000','0','17000','900000','0','0','0','900000','SULIS','00033904','TFPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFPER-YBXD-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.620',berat_jual_asli=berat_jual_asli+'4.620',stock_jual='1',berat_akhir=berat_akhir-'4.620',berat_akhir_asli=berat_akhir_asli-'4.620',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='TFPER-YBXD-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0010','2026-03-24','4.620','2026-03-24','14:32:18','PLG0010117','900000','900000','0','900000','0','kasirbip','2026-03-24 14:32:17','FJ-260324-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-24','FJ-260324-0010','2026-03-24','14:32:18','SULIS','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-260324-0016','2026-03-24','2026-03-24 14:32:17','PENJUALAN : FJ-260324-0010','.','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-260324-0016','D','2026-03-24','14:32:18','TBC','PENJUALAN','FJ-260324-0010','21139784514','900000','21140684514','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='900000' WHERE no_faktur_jual='FJ-260324-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 ('FJ-260324-0011','kasirbip','1',' 700K-17-19','TOKO','BIPPER','PBDG-YKBE-160-0','CINCIN SILVER 925 ','','2.600','1','100.00','160000','0','0','17000','850000','0','0','0','850000','SULIS','00039992','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-160-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-YKBE-160-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0011','2026-03-24','2.600','2026-03-24','14:50:06','PLG0010118','850000','850000','0','850000','0','kasirbip','2026-03-24 14:50:05','FJ-260324-0011','','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-24','FJ-260324-0011','2026-03-24','14:50:06','SULIS','850000','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-260324-0017','2026-03-24','2026-03-24 14:50:05','PENJUALAN : FJ-260324-0011','.','TBC','850000','850000','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-260324-0017','D','2026-03-24','14:50:06','TBC','PENJUALAN','FJ-260324-0011','21140684514','850000','21141534514','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='850000' WHERE no_faktur_jual='FJ-260324-0011' 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 ('FJ-260324-0012','kasirbip',' 1',' 1.0K-105-0','TOKO','BIPPER','LXPER-ZBBD-23-0','CINCIN SILVER 925 ','','1.340','1','100.00','137000','0','0','17000','1150000','0','0','0','1150000','SULIS','00041769','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBD-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='LXPER-ZBBD-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0012','2026-03-24','1.340','2026-03-24','14:50:06','PLG0010119','1150000','1150000','0','1150000','0','kasirbip','2026-03-24 14:50:05','FJ-260324-0011','','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-24','FJ-260324-0012','2026-03-24','14:50:06','SULIS','1150000','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-260324-0018','2026-03-24','2026-03-24 14:50:05','PENJUALAN : FJ-260324-0012','.','TBC','1150000','1150000','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-260324-0018','D','2026-03-24','14:50:06','TBC','PENJUALAN','FJ-260324-0012','21141534514','1150000','21142684514','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='2000000' WHERE no_faktur_jual='FJ-260324-0012' 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 ('FJ-260324-0013','kasirbip','1',' PLBDG-0011','TOKO','BIPPLD','PLBDG-YLBD-9-0','CINCIN PALADIUM PLBDG-00119 ','','1.590','1','6.00','249000','0','0','17000','1227000','0','0','0','1227000','SULIS','00040673','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-YLBD-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.590',berat_jual_asli=berat_jual_asli+'1.590',stock_jual='1',berat_akhir=berat_akhir-'1.590',berat_akhir_asli=berat_akhir_asli-'1.590',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PLBDG-YLBD-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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 ('FJ-260324-0013','2026-03-24','1.590','2026-03-24','14:52:53','PLG0010120','1227000','1227000','0','1227000','0','kasirbip','2026-03-24 14:52:52','FJ-260324-0013','','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-24','FJ-260324-0013','2026-03-24','14:52:53','SULIS','1227000','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-260324-0019','2026-03-24','2026-03-24 14:52:52','PENJUALAN : FJ-260324-0013','.','TBC','1227000','1227000','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-260324-0019','D','2026-03-24','14:52:53','TBC','PENJUALAN','FJ-260324-0013','21142684514','1227000','21143911514','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='1227000' WHERE no_faktur_jual='FJ-260324-0013' 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 ('FJ-260324-0014','kasirbip',' 1',' PLBDG-0010','TOKO','BIPPLD','PLBDG-YKBA-10-0','CINCIN PALADIUM PLBDG-00105 ','','4.990','1','6.00','725000','0','0','17000','1997000','0','0','0','1997000','SULIS','00039756','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-YKBA-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.990',berat_jual_asli=berat_jual_asli+'4.990',stock_jual='1',berat_akhir=berat_akhir-'4.990',berat_akhir_asli=berat_akhir_asli-'4.990',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PLBDG-YKBA-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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 ('FJ-260324-0014','2026-03-24','4.990','2026-03-24','14:52:53','PLG0010121','1997000','1997000','0','1997000','0','kasirbip','2026-03-24 14:52:52','FJ-260324-0013','','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-24','FJ-260324-0014','2026-03-24','14:52:53','SULIS','1997000','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-260324-0020','2026-03-24','2026-03-24 14:52:52','PENJUALAN : FJ-260324-0014','.','TBC','1997000','1997000','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-260324-0020','D','2026-03-24','14:52:53','TBC','PENJUALAN','FJ-260324-0014','21143911514','1997000','21145908514','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='3224000' WHERE no_faktur_jual='FJ-260324-0014' LIMIT 1; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01903','SULIS','1','SEPASANG PLD','CWE 13 5 PUTIH GLOSY CWO 16 5 PUTIGH DOFF AMPLASS FONT BERKSHIRE SWASH','6.000','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-01903','2026-03-24','2026-03-24','14:55:59','PLG0010122','kasirbip','2026-04-19','kasirbip','2026-03-24 14:55:59','6.000','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-24 ','14:56:24'); 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 ('FJ-260324-0015','kasirbip','1',' PLBDG-0013','TOKO','BIPPLD','PLBDG-ZACX-22-0','CINCIN PALADIUM PLBDG-00135 ','','2.450','1','17.00','550000','0','0','17000','1485000','0','0','0','1485000','MIA','00041236','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZACX-22-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PLBDG-ZACX-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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 ('FJ-260324-0015','2026-03-24','2.450','2026-03-24','16:19:28','PLG0010123','1485000','1485000','0','1485000','0','kasirbip','2026-03-24 16:19:27','FJ-260324-0015','','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-24','FJ-260324-0015','2026-03-24','16:19:28','MIA','1485000','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-260324-0021','2026-03-24','2026-03-24 16:19:27','PENJUALAN : FJ-260324-0015','.','TBC','1485000','1485000','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-260324-0021','D','2026-03-24','16:19:28','TBC','PENJUALAN','FJ-260324-0015','21145908514','1485000','21147393514','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='1485000' WHERE no_faktur_jual='FJ-260324-0015' 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 ('FJ-260324-0016','kasirbip',' 1',' 500K-225-2','TOKO','BIPPER','PBDG-YLCA-13-0','CINCIN SILVER 925 ','','2.100','1','100.00','129000','0','0','17000','600000','0','0','0','600000','MIA','00040732','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLCA-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-YLCA-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0016','2026-03-24','2.100','2026-03-24','16:19:28','PLG0010124','600000','600000','0','600000','0','kasirbip','2026-03-24 16:19:27','FJ-260324-0015','','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-24','FJ-260324-0016','2026-03-24','16:19:28','MIA','600000','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-260324-0022','2026-03-24','2026-03-24 16:19:27','PENJUALAN : FJ-260324-0016','.','TBC','600000','600000','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-260324-0022','D','2026-03-24','16:19:28','TBC','PENJUALAN','FJ-260324-0016','21147393514','600000','21147993514','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='2085000' WHERE no_faktur_jual='FJ-260324-0016' 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 ('FJ-260324-0017','kasirbip','1',' 700K-16-23','TOKO','BIPPER','PBDG-ZCAA-26-0','CINCIN SILVER 925 ','','2.420','1','100.00','247000','0','0','17000','850000','0','0','0','850000','GIN','00042262','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCAA-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.420',berat_jual_asli=berat_jual_asli+'2.420',stock_jual='1',berat_akhir=berat_akhir-'2.420',berat_akhir_asli=berat_akhir_asli-'2.420',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-ZCAA-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0017','2026-03-24','2.420','2026-03-24','16:21:26','PLG0010125','850000','850000','0','850000','0','kasirbip','2026-03-24 16:21:26','FJ-260324-0017','','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-24','FJ-260324-0017','2026-03-24','16:21:26','GIN','850000','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-260324-0023','2026-03-24','2026-03-24 16:21:26','PENJUALAN : FJ-260324-0017','.','TBC','850000','850000','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-260324-0023','D','2026-03-24','16:21:26','TBC','PENJUALAN','FJ-260324-0017','21147993514','850000','21148843514','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='850000' WHERE no_faktur_jual='FJ-260324-0017' 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 ('FJ-260324-0018','kasirbip',' 1',' PLBDG-0012','TOKO','BIPPLD','PLBDG-ZAAE-23-0','CINCIN PALADIUM PLBDG-00123 ','','2.530','1','5.00','345000','0','0','17000','1509000','0','0','0','1509000','GIN','00040908','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZAAE-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PLBDG-ZAAE-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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 ('FJ-260324-0018','2026-03-24','2.530','2026-03-24','16:21:26','PLG0010126','1509000','1509000','0','1509000','0','kasirbip','2026-03-24 16:21:26','FJ-260324-0017','','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-24','FJ-260324-0018','2026-03-24','16:21:26','GIN','1509000','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-260324-0024','2026-03-24','2026-03-24 16:21:26','PENJUALAN : FJ-260324-0018','.','TBC','1509000','1509000','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-260324-0024','D','2026-03-24','16:21:26','TBC','PENJUALAN','FJ-260324-0018','21148843514','1509000','21150352514','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='2359000' WHERE no_faktur_jual='FJ-260324-0018' 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 ('FJ-260324-0019','kasirbip','1',' 800K-7-208','TOKO','BIPPER','PBDG-YLAA-14-0','CINCIN SILVER 925 ','','2.290','1','100.00','141000','0','0','17000','900000','0','0','0','900000','GIN','00040549','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLAA-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.290',berat_jual_asli=berat_jual_asli+'2.290',stock_jual='1',berat_akhir=berat_akhir-'2.290',berat_akhir_asli=berat_akhir_asli-'2.290',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-YLAA-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0019','2026-03-24','2.290','2026-03-24','16:28:27','PLG0010127','900000','900000','0','900000','0','kasirbip','2026-03-24 16:28:26','FJ-260324-0019','','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-24','FJ-260324-0019','2026-03-24','16:28:27','GIN','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-260324-0025','2026-03-24','2026-03-24 16:28:26','PENJUALAN : FJ-260324-0019','.','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-260324-0025','D','2026-03-24','16:28:27','TBC','PENJUALAN','FJ-260324-0019','21150352514','900000','21151252514','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='900000' WHERE no_faktur_jual='FJ-260324-0019' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0019'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-24 ','17:31:25'); 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 ('FJ-260324-0020','kasirbip','1',' 700K-16-65','TOKO','BIPPER','TFPER-YFCX-20-0','CINCIN SILVER 925 ','','4.440','1','100.00','103000','0','0','17000','900000','0','0','0','900000','MIA','00036821','TFPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFPER-YFCX-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.440',berat_jual_asli=berat_jual_asli+'4.440',stock_jual='1',berat_akhir=berat_akhir-'4.440',berat_akhir_asli=berat_akhir_asli-'4.440',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='TFPER-YFCX-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0020','2026-03-24','4.440','2026-03-24','17:32:27','PLG0010128','900000','900000','0','900000','0','kasirbip','2026-03-24 17:32:26','FJ-260324-0020','','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-24','FJ-260324-0020','2026-03-24','17:32:27','MIA','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-260324-0026','2026-03-24','2026-03-24 17:32:26','PENJUALAN : FJ-260324-0020','.','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-260324-0026','D','2026-03-24','17:32:27','TBC','PENJUALAN','FJ-260324-0020','21151252514','900000','21152152514','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='900000' WHERE no_faktur_jual='FJ-260324-0020' 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 ('FJ-260324-0021','kasirbip',' 1',' 800K-95-20','TOKO','BIPPER','PBDG-YLAA-22-0','CINCIN SILVER 925 ','','2.300','1','100.00','141000','0','0','17000','950000','0','0','0','950000','MIA','00040557','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLAA-22-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-YLAA-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0021','2026-03-24','2.300','2026-03-24','17:32:27','PLG0010129','950000','950000','0','950000','0','kasirbip','2026-03-24 17:32:26','FJ-260324-0020','','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-24','FJ-260324-0021','2026-03-24','17:32:27','MIA','950000','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-260324-0027','2026-03-24','2026-03-24 17:32:26','PENJUALAN : FJ-260324-0021','.','TBC','950000','950000','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-260324-0027','D','2026-03-24','17:32:27','TBC','PENJUALAN','FJ-260324-0021','21152152514','950000','21153102514','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='1850000' WHERE no_faktur_jual='FJ-260324-0021' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0021'; 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 ('FJ-260324-0022','kasirbip','1',' 700K-21-21','TOKO','BIPPER','PBDG-YLCA-9-0','CINCIN SILVER 925 ','','4.800','1','100.00','294000','0','0','17000','900000','0','0','0','900000','SULIS','00040728','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLCA-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.800',berat_jual_asli=berat_jual_asli+'4.800',stock_jual='1',berat_akhir=berat_akhir-'4.800',berat_akhir_asli=berat_akhir_asli-'4.800',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='PBDG-YLCA-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0022','2026-03-24','4.800','2026-03-24','17:56:15','PLG0010130','900000','900000','0','900000','0','kasirbip','2026-03-24 17:56:14','FJ-260324-0022','','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-24','FJ-260324-0022','2026-03-24','17:56:15','SULIS','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-260324-0028','2026-03-24','2026-03-24 17:56:14','PENJUALAN : FJ-260324-0022','.','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-260324-0028','D','2026-03-24','17:56:15','TBC','PENJUALAN','FJ-260324-0022','21153102514','900000','21154002514','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='900000' WHERE no_faktur_jual='FJ-260324-0022' 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 ('FJ-260324-0023','kasirbip',' 1',' 1.0K-14-00','TOKO','BIPPER','LXPER-ZBBC-18-0','CINCIN SILVER 925 ','','1.260','1','100.00','129000','0','0','17000','1150000','0','0','0','1150000','SULIS','00041679','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBC-18-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='LXPER-ZBBC-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0023','2026-03-24','1.260','2026-03-24','17:56:15','PLG0010131','1150000','1150000','0','1150000','0','kasirbip','2026-03-24 17:56:14','FJ-260324-0022','','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-24','FJ-260324-0023','2026-03-24','17:56:15','SULIS','1150000','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-260324-0029','2026-03-24','2026-03-24 17:56:14','PENJUALAN : FJ-260324-0023','.','TBC','1150000','1150000','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-260324-0029','D','2026-03-24','17:56:15','TBC','PENJUALAN','FJ-260324-0023','21154002514','1150000','21155152514','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='2050000' WHERE no_faktur_jual='FJ-260324-0023' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0023'; 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 ('FJ-260324-0024','kasirbip','1',' 800K-27-00','TOKO','BIPPER','LXPER-ZCXB-5-0','CINCIN SILVER 925 ','','5.950','1','100.00','607000','0','0','17000','1000000','0','0','0','1000000','GIN','00042066','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-03-24', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZCXB-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.950',berat_jual_asli=berat_jual_asli+'5.950',stock_jual='1',berat_akhir=berat_akhir-'5.950',berat_akhir_asli=berat_akhir_asli-'5.950',stock_akhir='0' WHERE tanggal='2026-03-24' AND kode_barang='LXPER-ZCXB-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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 ('FJ-260324-0024','2026-03-24','5.950','2026-03-24','20:07:52','PLG0010132','1000000','1000000','0','1000000','0','kasirbip','2026-03-24 20:07:52','FJ-260324-0024','','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-24','FJ-260324-0024','2026-03-24','20:07:52','GIN','1000000','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-260324-0030','2026-03-24','2026-03-24 20:07:52','PENJUALAN : FJ-260324-0024','.','TBC','1000000','1000000','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-260324-0030','D','2026-03-24','20:07:52','TBC','PENJUALAN','FJ-260324-0024','21155152514','1000000','21156152514','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='1000000' WHERE no_faktur_jual='FJ-260324-0024' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260324-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260324-0024'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-24 ','21:20:05'); 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','21:20:15','TBC','SALDO AWAL','SALDO AWAL','0','21156152514','21156152514'); INSERT 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','21:20:15','','SALDO AWAL','SALDO AWAL','0','250000','250000'); INSERT 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','21:20:15','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000'); INSERT 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','21:20:15','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); INSERT 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','21:20:15','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); INSERT 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','21:20:15','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); INSERT 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','21:20:15','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); INSERT 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','21:20:15','DPE','SALDO AWAL','SALDO AWAL','0','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) VALUES ('KM-260325-0001','D','2026-03-25','21:20:15','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); INSERT 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','21:20:15','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650'); INSERT 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','21:20:15','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000'); INSERT 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','21:20:15','BCD','SALDO AWAL','SALDO AWAL','0','1355733500','1355733500'); UPDATE tp_system SET tgl_system='2026-03-25';