INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-03 ','09:09:56'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-03 ','10:03:43'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-03 ','10:05:52'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-03','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-02'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-02'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-02'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-05-02' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-02'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-02'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-02'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-02'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04'; UPDATE tt_barang_saldo SET tanggal= '2026-05-03' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-02' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260503-0001','D','2026-05-03','10:11:30','TBC','SALDO AWAL','SALDO AWAL','0','22081407514','22081407514'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260503-0001','D','2026-05-03','10:11:30','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260503-0001','D','2026-05-03','10:11:30','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-260503-0001','D','2026-05-03','10:11:30','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-260503-0001','D','2026-05-03','10:11:30','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-260503-0001','D','2026-05-03','10:11:30','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-260503-0001','D','2026-05-03','10:11:30','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-260503-0001','D','2026-05-03','10:11:30','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-260503-0001','D','2026-05-03','10:11:30','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-260503-0001','D','2026-05-03','10:11:30','','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-260503-0001','D','2026-05-03','10:11:30','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260503-0001','D','2026-05-03','10:11:30','BCD','SALDO AWAL','SALDO AWAL','0','1361288500','1361288500'); UPDATE tp_system SET tgl_system='2026-05-03'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-03 ','10:29:18'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-03 ','10:37:02'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-03 ','10:47:58'); 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-02045','PUT','1','PER','WEDD RING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz 10','grf Febri font berkshire','crom putih gllosy','0','0','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-02045','PUT','2','PER','WEDD RING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 19','grf Nita font berkshire','crom doff amplas sama kan seperti contoh','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260503-0001','2026-05-03','2026-05-03 10:52:07','PESANAN : DP-02045','.','TBC','1850000','1850000'); 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-260503-0002','D','2026-05-03','10:52:07','TBC','PESANAN','DP-02045','22081407514','1850000','22083257514','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-02045','2026-05-03','2026-05-03','10:52:07','PLG0010801','PUT','2026-05-20','kasirbip','2026-05-03 10:52:07','5.000','0','0','0','1850000','0','0','1850000','1850000','0'); INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02045'; INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02045'; UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02045'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260503-0002','K','2026-05-03','11:00:12','kasirbip','PESANAN BATAL','DP-02045','13981100','0','13981100'); 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-02046','PUT','1','PER','WEDD RING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz 10','grf Febri font berkshire','crom putih gllosy','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-260503-0002','2026-05-03','2026-05-03 11:07:19','PESANAN : DP-02046','.','TBC','1000000','1000000'); 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-260503-0003','D','2026-05-03','11:07:19','TBC','PESANAN','DP-02046','22083257514','1000000','22084257514','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-02046','2026-05-03','2026-05-03','11:07:19','PLG0010802','PUT','2026-05-20','kasirbip','2026-05-03 11:07:19','2.000','0','0','0','1000000','0','0','1000000','1000000','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-02047','PUT','1','PER','WEDD RING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 19','grf Nita font berkshire','crom doff amplas sama kan seperti contoh','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260503-0003','2026-05-03','2026-05-03 11:09:23','PESANAN : DP-02047','.','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-260503-0004','D','2026-05-03','11:09:23','TBC','PESANAN','DP-02047','22084257514','850000','22085107514','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-02047','2026-05-03','2026-05-03','11:09:23','PLG0010803','PUT','2026-05-20','kasirbip','2026-05-03 11:09:23','3.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-02048','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','1 zircon cwe sz 13 putih glosy grf Deri','cwo putih glosy sz 14.5 grf Risa','MODEL SR 03 font B Swash','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260503-0004','2026-05-03','2026-05-03 11:19:08','PESANAN : DP-02048','.','TBC','950000','950000'); 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-260503-0005','D','2026-05-03','11:19:08','TBC','PESANAN','DP-02048','22085107514','950000','22086057514','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-02048','2026-05-03','2026-05-03','11:19:08','PLG0010804','KUR','2026-05-19','kasirbip','2026-05-03 11:19:08','3.000','0','0','0','950000','0','0','950000','950000','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-260503-0001','kasirbip','1',' DP-01904BI','TOKO','BIPPSN','PSPLT-ZDBG-39-0','CINCIN PALADIUM ','','2.120','1','17.00','477000','0','0','17000','1656000','0','0','0','1656000','GIN','00042814','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZDBG-39-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PSPLT-ZDBG-39-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-260503-0001','2026-05-03','2.120','2026-05-03','11:21:22','PLG0010805','1656000','1656000','0','1656000','0','kasirbip','2026-05-03 11:21:21','FJ-260503-0001','DP-01904','1296000'); 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-05-03','FJ-260503-0001','2026-05-03','11:21:22','GIN','1656000','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-260503-0005','2026-05-03','2026-05-03 11:21:21','PENJUALAN : FJ-260503-0001','.','TBC','360000','360000','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-260503-0006','D','2026-05-03','11:21:22','TBC','PENJUALAN','FJ-260503-0001','22086057514','360000','22086417514','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='360000' WHERE no_faktur_jual='FJ-260503-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-260503-0002','kasirbip',' 1',' DP-01905BI','TOKO','BIPPSN','PSPLT-ZDAG-9-0','CINCIN PALADIUM ','','2.650','1','17.00','596000','0','0','17000','1495000','0','0','0','1495000','GIN','00042660','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZDAG-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PSPLT-ZDAG-9-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-260503-0002','2026-05-03','2.650','2026-05-03','11:21:22','PLG0010806','1495000','1495000','0','1495000','0','kasirbip','2026-05-03 11:21:21','FJ-260503-0001','DP-01905','1160000'); 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-05-03','FJ-260503-0002','2026-05-03','11:21:22','GIN','1495000','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-260503-0006','2026-05-03','2026-05-03 11:21:21','PENJUALAN : FJ-260503-0002','.','TBC','335000','335000','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-260503-0007','D','2026-05-03','11:21:22','TBC','PENJUALAN','FJ-260503-0002','22086417514','335000','22086752514','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='695000' WHERE no_faktur_jual='FJ-260503-0002' 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-02049','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','ROSE GOLD GLOSSY 3 ZIRKON','SZ 13','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260503-0007','2026-05-03','2026-05-03 12:16:30','PESANAN : DP-02049','.','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-260503-0008','D','2026-05-03','12:16:30','TBC','PESANAN','DP-02049','22086752514','850000','22087602514','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-02049','2026-05-03','2026-05-03','12:16:30','PLG0010807','SULIS','2026-06-03','kasirbip','2026-05-03 12:16:30','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-02050','PUT','1','PLD','WEDD RING','','','4.000','','10.00','1','1200000','300000','0','750000','1950000','sz 18','grf Ms.Glo','crom doff semprot sama kan seperti contoh','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260503-0008','2026-05-03','2026-05-03 12:49:37','PESANAN : DP-02050','.','TBC','1950000','1950000'); 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-260503-0009','D','2026-05-03','12:49:37','TBC','PESANAN','DP-02050','22087602514','1950000','22089552514','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-02050','2026-05-03','2026-05-03','12:49:37','PLG0010808','PUT','2026-05-20','kasirbip','2026-05-03 12:49:37','4.000','0','0','0','1950000','0','750000','1950000','1950000','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-02051','PUT','1','GOLD','WEDD RING','','','2.500','','37.50','1','2500000','1500000','0','900000','4650000','mata sirkon 18 putih gllosy','sz 13 grf Irwan','font yeseva','180000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260503-0009','2026-05-03','2026-05-03 13:08:18','PESANAN : DP-02051','.','TBC','3864000','3864000'); 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-260503-0010','D','2026-05-03','13:08:18','TBC','PESANAN','DP-02051','22089552514','3864000','22093416514','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-02051','2026-05-03','2026-05-03','13:08:18','PLG0010809','PUT','2026-05-20','kasirbip','2026-05-03 13:08:18','2.500','0','0','0','3864000','0','900000','4830000','4830000','966000'); INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02050'; INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02050'; UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02050'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260503-0003','K','2026-05-03','13:13:49','kasirbip','PESANAN BATAL','DP-02050','13981100','0','13981100'); 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-02052','PUT','1','PLD','WEDD RING','','','4.000','','10.00','1','1200000','300000','0','750000','1950000','sz 18 crom doff semprot sama kan seperti contoh','grf Ms.Glo','font yeseva','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-260503-0010','2026-05-03','2026-05-03 13:21:52','PESANAN : DP-02052','.','TBC','1560000','1560000'); 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-260503-0011','D','2026-05-03','13:21:52','TBC','PESANAN','DP-02052','22093416514','1560000','22094976514','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-02052','2026-05-03','2026-05-03','13:21:52','PLG0010810','PUT','2026-05-20','kasirbip','2026-05-03 13:21:52','4.000','0','0','0','1560000','0','750000','1950000','1950000','390000'); UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01947'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01947'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01947'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01947'; 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-02053','GIN','1','GOLD','WED RING','','','2.500','','37.50','1','2500000','1500000','0','750000','4500000','PUTIH GLOSY COMB PUTIH DOFF SEMPROT 1 ZIRKON','SZ 19 FONT YESEVA','GRF BARA 12-07-2026','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260503-0011','2026-05-03','2026-05-03 13:49:37','PESANAN : DP-02053','.','TBC','3600000','3600000'); 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-260503-0012','D','2026-05-03','13:49:37','TBC','PESANAN','DP-02053','22094976514','3600000','22098576514','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-02053','2026-05-03','2026-05-03','13:49:37','PLG0010811','GIN','2026-06-03','kasirbip','2026-05-03 13:49:37','2.500','0','0','0','3600000','0','750000','4500000','4500000','900000'); 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-02054','GIN ','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1000000','0','1000000','1 ZIRKON PUTIH GLOSY COMB DOFF SEMPROT','SZ 23 FONT YESEVA','GRF BARA 12-07-2026','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260503-0012','2026-05-03','2026-05-03 13:51:30','PESANAN : DP-02054','.','TBC','1000000','1000000'); 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-260503-0013','D','2026-05-03','13:51:30','TBC','PESANAN','DP-02054','22098576514','1000000','22099576514','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-02054','2026-05-03','2026-05-03','13:51:30','PLG0010812','GIN ','2026-06-03','kasirbip','2026-05-03 13:51:30','3.000','0','0','0','1000000','0','0','1000000','1000000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-03 ','14:04:27'); 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-260503-0003','kasirbip','1',' 950K-12 ','TOKO','BIPCMP','BDCM-YLXH-4-0','CINCIN EMAS ','','2.090','1','83.00','4336000','0','0','17000','5966000','0','0','0','5966000','SULIS','00040371','BDCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YLXH-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='BDCM-YLXH-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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-260503-0003','2026-05-03','2.090','2026-05-03','14:40:12','PLG0010813','5966000','5966000','0','5966000','0','kasirbip','2026-05-03 14:40:12','FJ-260503-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-05-03','FJ-260503-0003','2026-05-03','14:40:12','SULIS','5966000','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-260503-0013','2026-05-03','2026-05-03 14:40:12','PENJUALAN : FJ-260503-0003','.','TBC','5966000','5966000','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-260503-0014','D','2026-05-03','14:40:12','TBC','PENJUALAN','FJ-260503-0003','22099576514','5966000','22105542514','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='5966000' WHERE no_faktur_jual='FJ-260503-0003' 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-02014','SULIS','1','SEPASANG PLD','CROM PUTIH DOFF SEMPROT KEDUANYA CCN PROA PERMATANYA DI KENCENGIN','3.000','1','100000','100000'); 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-260503-0014','2026-05-03','2026-05-03 14:50:39','SERVICE : SV-02014','.','TBC','100000','100000','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-260503-0015','D','2026-05-03','14:50:39','TBC','SERVICE','SV-02014','22105542514','100000','22105642514','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-02014','2026-05-03','2026-05-03','14:50:39','PLG0010814','kasirbip','2026-05-19','kasirbip','2026-05-03 14:50:39','3.000','0','0','0','100000','0','100000','100000','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-02055','PUT','1','PER','WEDD RING','','','3.300','','925.00','1','100000','0','0','950000','950000','sz 12 crom doff semprot samakan seperti contoh','grf Atika','font vintage','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-260503-0015','2026-05-03','2026-05-03 15:03:25','PESANAN : DP-02055','.','TBC','950000','950000'); 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-260503-0016','D','2026-05-03','15:03:25','TBC','PESANAN','DP-02055','22105642514','950000','22106592514','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-02055','2026-05-03','2026-05-03','15:03:25','PLG0010815','PUT','2026-05-20','kasirbip','2026-05-03 15:03:25','3.300','0','0','0','950000','0','950000','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-03 ','15:03:45'); 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-02056','PUT','1','PER','WEDD RING','','','2.000','','925.00','1','100000','0','0','1050000','1050000','sz 12 crom putih gllosy','grf Gefy','font vintage','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-260503-0016','2026-05-03','2026-05-03 15:06:45','PESANAN : DP-02056','.','TBC','1050000','1050000'); 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-260503-0017','D','2026-05-03','15:06:45','TBC','PESANAN','DP-02056','22106592514','1050000','22107642514','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-02056','2026-05-03','2026-05-03','15:06:45','PLG0010816','PUT','2026-05-20','kasirbip','2026-05-03 15:06:45','2.000','0','0','0','1050000','0','1050000','1050000','1050000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-03 ','15:07:00'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02015','SULIS','1','PLD DAN PER','CWE PUTIH GLOSY CWO HITAM DOFF SEMPROT FONT YESEVA ONE','2.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-02015','2026-05-03','2026-05-03','15:11:43','PLG0010817','kasirbip','2026-05-19','kasirbip','2026-05-03 15:11:43','2.000','0','0','0','0','0','0','0','0'); UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01867'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01867'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01871'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01871'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01901'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01901'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01894'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01894'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01897'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01897'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01898'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01898'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01899'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01899'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01900'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01900'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01906'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01906'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01871'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01871'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01873'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01873'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01879'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01879'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01886'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01886'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01887'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01887'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01891'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01891'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01893'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01893'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01908'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01908'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01908'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01908'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01913'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01913'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01916'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01916'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01917'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01917'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01923'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01923'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01925'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01925'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0003'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01891'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01891'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01893'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01893'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01894'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01894'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01897'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01897'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01898'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01898'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01908'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01908'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01913'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01913'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01915'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01915'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01952'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01952'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01954'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01954'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01941'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01941'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01967'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01967'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01942'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01942'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01964'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01964'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01984'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01984'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01965'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01965'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01972'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01972'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01973'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01973'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01982'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01982'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01983'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01983'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01994'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01994'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01928'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01928'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01932'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01932'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01933'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01933'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01935'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01935'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01945'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01945'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01940'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01940'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01952'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01952'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01954'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01954'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01964'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01964'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01965'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01965'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-03 ','15:42:08'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01967'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01967'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01972'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01972'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01969'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01969'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01970'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01970'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01971'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01971'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01975'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01975'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01890'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01890'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01910'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01910'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01934'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01934'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01931'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01931'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01929'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01929'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01927'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01927'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01946'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01946'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01948'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01948'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01963'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01963'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01974'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01974'; 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-260503-0004','kasirbip','1',' DP-01926BI','TOKO','BIPPSN','PSGT-ZDBH-79-0','CINCIN EMAS ','','1.580','1','83.00','3345000','0','0','17000','4612000','0','0','0','4612000','SULIS','00042895','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZDBH-79-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PSGT-ZDBH-79-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-260503-0004','2026-05-03','1.580','2026-05-03','16:06:47','PLG0010818','4612000','4612000','0','4612000','0','kasirbip','2026-05-03 16:06:46','FJ-260503-0004','DP-01926','3536000'); 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-05-03','FJ-260503-0004','2026-05-03','16:06:47','SULIS','4612000','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-260503-0017','2026-05-03','2026-05-03 16:06:46','PENJUALAN : FJ-260503-0004','.','TBC','1076000','1076000','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-260503-0018','D','2026-05-03','16:06:47','TBC','PENJUALAN','FJ-260503-0004','22107642514','1076000','22108718514','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='1076000' WHERE no_faktur_jual='FJ-260503-0004' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-03 ','16:07:15'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01975'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01975'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01963'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01963'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-03 ','16:12:34'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01969'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01969'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01970'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01970'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01976'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01976'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01978'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01978'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01980'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01980'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01981'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01981'; UPDATE tt_service_head SET tgl_selesai='2026-05-03', status ='DONE' WHERE no_service='SV-01990'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-01990'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02016','SULIS','1','1 CINICN SILVER','CROM ULANG PUTIH GLOSSY FONT VINTAGE ROTTER GRF','3.000','1','50000','50000'); 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-260503-0018','2026-05-03','2026-05-03 16:21:18','SERVICE : SV-02016','.','TBC','50000','50000','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-260503-0019','D','2026-05-03','16:21:18','TBC','SERVICE','SV-02016','22108718514','50000','22108768514','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-02016','2026-05-03','2026-05-03','16:21:18','PLG0010819','kasirbip','2026-05-19','kasirbip','2026-05-03 16:21:18','3.000','0','0','0','50000','0','50000','50000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-03 ','16:28:36'); 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-260503-0005','kasir','1',' DP-02013MM','TOKO','MMPSN','PSGT-ZDBI-54-0','CINCIN EMAS ','','1.940','1','45.00','2227000','0','0','17000','4562000','0','0','0','4562000','ELLA','00042952','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZDBI-54-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PSGT-ZDBI-54-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-260503-0005','2026-05-03','1.940','2026-05-03','16:32:28','PLG0010820','4562000','4562000','0','4562000','-614000','kasir','2026-05-03 16:32:27','FJ-260503-0005','DP-02013','5176000'); 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-05-03','FJ-260503-0005','2026-05-03','16:32:28','ELLA','4562000','0'); UPDATE tt_jual_head SET dibayar_rp='-614000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260503-0005' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0005'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260503-0006','kasir','1',' PLDMM-0004','TOKO','MMPLD','PLDMM-ZDBI-28-0','CINCIN PALADIUM PLDMM-00041 ','','4.340','1','17.00','975000','0','0','17000','2152000','0','0','0','2152000','ELLA','00042926','PLDMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZDBI-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.340',berat_jual_asli=berat_jual_asli+'4.340',stock_jual='1',berat_akhir=berat_akhir-'4.340',berat_akhir_asli=berat_akhir_asli-'4.340',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PLDMM-ZDBI-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' 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-260503-0006','2026-05-03','4.340','2026-05-03','16:40:49','PLG0010821','2152000','2152000','0','2152000','0','kasir','2026-05-03 16:40:49','FJ-260503-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-05-03','FJ-260503-0006','2026-05-03','16:40:49','ELLA','2152000','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-260503-0019','2026-05-03','2026-05-03 16:40:49','PENJUALAN : FJ-260503-0006','.','TBC','2152000','2152000','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-260503-0020','D','2026-05-03','16:40:49','TBC','PENJUALAN','FJ-260503-0006','22108768514','2152000','22110920514','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='2152000' WHERE no_faktur_jual='FJ-260503-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0006'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02017','ELLA','1','PLD10','GRF TITIS & TEGAR CROM PUTIH DOFF AMPLAS','4.340','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-02017','2026-05-03','2026-05-03','16:45:29','PLG0010822','kasir','2026-05-06','kasir','2026-05-03 16:45:29','4.340','0','0','0','0','0','0','0','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-02057','ALIKA','1','PLD','WEDDING RING','','','3.000','','10.00','1','1200000','300000','0','500000','1400000','size 20 grf nurul & bayu','crom putih doff amplas','model papan list tipis sr01','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-260503-0020','2026-05-03','2026-05-03 17:07:29','PESANAN : DP-02057','.','TBC','1120000','1120000'); 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-260503-0021','D','2026-05-03','17:07:29','TBC','PESANAN','DP-02057','22110920514','1120000','22112040514','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-02057','2026-05-03','2026-05-03','17:07:29','PLG0010823','ALIKA','2026-05-24','kasir','2026-05-03 17:07:29','3.000','0','0','0','1120000','0','500000','1400000','1400000','280000'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01917'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01917'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01923'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01923'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01925'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01925'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01929'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01929'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01931'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01931'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01941'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01941'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01942'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01942'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01934'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01934'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-05-03', status ='CLOS' WHERE no_service='SV-01927'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-01927'; 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-260503-0007','kasirbip','1',' 800K-15-23','TOKO','BIPPER','PBDG-ZDXG-14-0','CINCIN SILVER 925 ','','4.430','1','100.00','452000','0','0','17000','900000','0','0','0','900000','KUR','00042329','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXG-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.430',berat_jual_asli=berat_jual_asli+'4.430',stock_jual='1',berat_akhir=berat_akhir-'4.430',berat_akhir_asli=berat_akhir_asli-'4.430',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PBDG-ZDXG-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-260503-0007','2026-05-03','4.430','2026-05-03','17:21:36','PLG0010824','900000','900000','0','900000','0','kasirbip','2026-05-03 17:21:36','FJ-260503-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-05-03','FJ-260503-0007','2026-05-03','17:21:36','KUR','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-260503-0021','2026-05-03','2026-05-03 17:21:36','PENJUALAN : FJ-260503-0007','.','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-260503-0022','D','2026-05-03','17:21:36','TBC','PENJUALAN','FJ-260503-0007','22112040514','900000','22112940514','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-260503-0007' 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-260503-0008','kasirbip',' 1',' PLBDG-0015','TOKO','BIPPLD','PLBDG-ZDBH-66-0','CINCIN PALADIUM PLBDG-00157 ','','1.710','1','17.00','384000','0','0','17000','1575000','0','0','0','1575000','KUR','00042882','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZDBH-66-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PLBDG-ZDBH-66-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-260503-0008','2026-05-03','1.710','2026-05-03','17:21:36','PLG0010825','1575000','1575000','0','1575000','0','kasirbip','2026-05-03 17:21:36','FJ-260503-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-05-03','FJ-260503-0008','2026-05-03','17:21:36','KUR','1575000','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-260503-0022','2026-05-03','2026-05-03 17:21:36','PENJUALAN : FJ-260503-0008','.','TBC','1575000','1575000','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-260503-0023','D','2026-05-03','17:21:36','TBC','PENJUALAN','FJ-260503-0008','22112940514','1575000','22114515514','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='2475000' WHERE no_faktur_jual='FJ-260503-0008' 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-02018','KUR','1','PLD SILVER','CROM SPT ASAL FONT VLADIMIR','3.000','925','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-02018','2026-05-03','2026-05-03','17:23:04','PLG0010826','kasirbip','2026-05-19','kasirbip','2026-05-03 17:23:04','3.000','0','0','0','0','0','0','0','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0008'; 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-02058','SULIS ','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','cwe sz 10.5 putih glossy grf ARIP 1 zirkon','cwo sz 20 putih doff amplas grf RATNA','font yeseva','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260503-0023','2026-05-03','2026-05-03 17:45:31','PESANAN : DP-02058','.','TBC','950000','950000'); 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-260503-0024','D','2026-05-03','17:45:31','TBC','PESANAN','DP-02058','22114515514','950000','22115465514','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-02058','2026-05-03','2026-05-03','17:45:31','PLG0010827','SULIS ','2026-05-30','kasirbip','2026-05-03 17:45:31','3.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-03 ','17:46:28'); INSERT INTO tm_user_deleted(user_id,pass_key,nama_lkp,type,input_by,input_date,edit_by,edit_date,deleted_by,deleted_date) VALUES ('a','c','a','OWN','Nagatech','2025-08-11 11:36:58','','','Nagatech','2026-05-03 17:47:21'); 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-260503-0009','kasir','1',' BDC-00122 ','TOKO','TFCBR','BDC-YJAC-1-0','CINCIN BDC-00122','','1.710','1','83.00','4888000','965500','57','17000','7000000','0','0','0','7000000','BARY','00039178','BDC','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDC-YJAC-1-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='BDC-YJAC-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCBR' 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-260503-0009','2026-05-03','1.710','2026-05-03','17:52:35','PLG0010828','7000000','7000000','0','7000000','0','kasir','2026-05-03 17:52:34','FJ-260503-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-05-03','FJ-260503-0009','2026-05-03','17:52:35','BARY','7000000','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-260503-0024','2026-05-03','2026-05-03 17:52:34','PENJUALAN : FJ-260503-0009','.','TBC','7000000','7000000','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-260503-0025','D','2026-05-03','17:52:35','TBC','PENJUALAN BERLIAN','FJ-260503-0009','22115465514','7000000','22122465514','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='7000000' WHERE no_faktur_jual='FJ-260503-0009' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0009'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-03 ','17:55:09'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-03 ','18:03:17'); 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-260503-0010','kasir','1',' TFCMR75-84','TOKO','TFCINMAS','TFCMR-ZBBF-42-0','THIFA CINCIN MAS RG ','','1.340','1','84.00','2814000','0','0','17000','2900000','0','0','0','2900000','FIR','00041941','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZBBF-42-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-05-03' AND kode_barang='TFCMR-ZBBF-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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-260503-0010','2026-05-03','1.340','2026-05-03','18:03:48','PLG0010829','2900000','2900000','0','2900000','0','kasir','2026-05-03 18:03:48','FJ-260503-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-05-03','FJ-260503-0010','2026-05-03','18:03:48','FIR','2900000','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-260503-0025','2026-05-03','2026-05-03 18:03:48','PENJUALAN : FJ-260503-0010','.','TBC','2900000','2900000','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-260503-0026','D','2026-05-03','18:03:48','TBC','PENJUALAN','FJ-260503-0010','22122465514','2900000','22125365514','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='2900000' WHERE no_faktur_jual='FJ-260503-0010' LIMIT 1; UPDATE tm_user SET nama_lkp='nsi1',pass_key='mqA4oA8A6A7A7||',type='MGR' WHERE user_id='nsi1'; UPDATE tm_user SET nama_lkp='nsi1',pass_key='mqA4oA8A6A7A7||',type='MGR' WHERE user_id='nsi1'; INSERT INTO tm_user_deleted(user_id,pass_key,nama_lkp,type,input_by,input_date,edit_by,edit_date,deleted_by,deleted_date) VALUES ('nsi1','mqA4oA8A6A7A7||','nsi1','MGR','Nagatech','2026-05-03 17:48:43','','','Nagatech','2026-05-03 18:05:11'); INSERT INTO tm_user_deleted(user_id,pass_key,nama_lkp,type,input_by,input_date,edit_by,edit_date,deleted_by,deleted_date) VALUES ('nsi1','mqA4oA8A6A7A7||','nsi1','MGR','Nagatech','2026-05-03 18:05:25','','','Nagatech','2026-05-03 18:05:35'); UPDATE tm_user SET nama_lkp='spv nagatech',pass_key=':326BDFH',type='MGR' WHERE user_id='spvnsi'; 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-260503-0011','kasir','1',' TFGRR75-84','TOKO','TFGLR','TFGRR-YLXD-60-0','THIFA GELANG RANTAI RG ','','2.020','1','84.00','4241000','0','0','17000','4300000','0','0','0','4300000','FIR','00040240','TFGRR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YLXD-60-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-05-03' AND kode_barang='TFGRR-YLXD-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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-260503-0011','2026-05-03','2.020','2026-05-03','18:06:58','PLG0010830','4300000','4300000','0','4300000','0','kasir','2026-05-03 18:06:58','FJ-260503-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-05-03','FJ-260503-0011','2026-05-03','18:06:58','FIR','4300000','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-260503-0026','2026-05-03','2026-05-03 18:06:58','PENJUALAN : FJ-260503-0011','.','TBC','4300000','4300000','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-260503-0027','D','2026-05-03','18:06:58','TBC','PENJUALAN','FJ-260503-0011','22125365514','4300000','22129665514','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='4300000' WHERE no_faktur_jual='FJ-260503-0011' LIMIT 1; UPDATE tm_user SET nama_lkp='spv nagatech',pass_key='ptA8r…ƒ‰‰A4A4IKM',type='OWN' WHERE user_id='spvnsi'; UPDATE tm_user SET nama_lkp='spv nagatech',pass_key='ptA8r…ƒ‰‰A4A4IKM',type='OWN' WHERE user_id='spvnsi'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0011'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-03 ','18:11:41'); DELETE FROM tm_berlian WHERE kode_barang='PMM-YFBX-142-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 ('PMM-YFBX-142-0','00036583','00036583','CINCIN SILVER 925 ','CINCIN SILVER 925','','','47000','47000',' 150000','150000','Nagatech','2026-05-03 18:12:04'); UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-12-00130 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PMM-YFBX-142-0' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-03 ','18:12:40'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-03 ','18:13:28'); 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-260503-0012','kasir','1',' 700K-12-00','TOKO','MMPER','PMM-YFBX-142-0','CINCIN SILVER 925','','2.350','1','100.00','55000','0','0','17000','850000','0','0','0','850000','RIRIN','00036583','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-142-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PMM-YFBX-142-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-260503-0012','2026-05-03','2.350','2026-05-03','18:13:44','PLG0010831','850000','850000','0','850000','0','kasir','2026-05-03 18:13:43','FJ-260503-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-05-03','FJ-260503-0012','2026-05-03','18:13:44','RIRIN','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-260503-0027','2026-05-03','2026-05-03 18:13:43','PENJUALAN : FJ-260503-0012','.','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-260503-0028','D','2026-05-03','18:13:44','TBC','PENJUALAN','FJ-260503-0012','22129665514','850000','22130515514','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-260503-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-260503-0013','kasir',' 1',' 950K-14-55','TOKO','MMPER','PMM-YKAD-44-0','CINCIN SILVER 925 ','','1.550','1','100.00','95000','0','0','17000','1100000','0','0','0','1100000','RIRIN','00039621','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-44-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PMM-YKAD-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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-260503-0013','2026-05-03','1.550','2026-05-03','18:13:44','PLG0010832','1100000','1100000','0','1100000','0','kasir','2026-05-03 18:13:43','FJ-260503-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-05-03','FJ-260503-0013','2026-05-03','18:13:44','RIRIN','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-260503-0028','2026-05-03','2026-05-03 18:13:43','PENJUALAN : FJ-260503-0013','.','TBC','1100000','1100000','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-260503-0029','D','2026-05-03','18:13:44','TBC','PENJUALAN','FJ-260503-0013','22130515514','1100000','22131615514','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-260503-0013' 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-02019','RIRIN','1','SLV','COWOK RESIZE 17 GRF ANGGITA CAHYA CROM PUTIH GLOSY CEWEK RESIZE KE 16 GRF EGY PERMANA CROM PUTIH GLOSY FON VINTAGE ROTTER','3.900','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-02019','2026-05-03','2026-05-03','18:16:58','PLG0010833','kasir','2026-05-06','kasir','2026-05-03 18:16:58','3.900','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-260503-0014','kasirbip','1',' DP-01912BI','TOKO','BIPPSN','PSGT-ZDBI-43-0','CINCIN EMAS ','','1.440','1','83.00','3048000','0','0','17000','4306000','0','0','0','4306000','SULIS','00042941','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZDBI-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PSGT-ZDBI-43-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-260503-0014','2026-05-03','1.440','2026-05-03','18:57:38','PLG0000001','4306000','4306000','0','4306000','0','kasirbip','2026-05-03 18:57:37','FJ-260503-0014','DP-01912','3560000'); 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-05-03','FJ-260503-0014','2026-05-03','18:57:38','SULIS','4306000','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-260503-0029','2026-05-03','2026-05-03 18:57:37','PENJUALAN : FJ-260503-0014','.','TBC','746000','746000','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-260503-0030','D','2026-05-03','18:57:38','TBC','PENJUALAN','FJ-260503-0014','22131615514','746000','22132361514','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='746000' WHERE no_faktur_jual='FJ-260503-0014' 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-260503-0015','kasirbip',' 1',' DP-01913BI','TOKO','BIPPSN','PSPLT-ZDAG-10-0','CINCIN PALADIUM ','','2.430','1','17.00','546000','0','0','17000','1429000','0','0','0','1429000','SULIS','00042661','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZDAG-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PSPLT-ZDAG-10-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-260503-0015','2026-05-03','2.430','2026-05-03','18:57:38','PLG0000001','1429000','1429000','0','1429000','0','kasirbip','2026-05-03 18:57:37','FJ-260503-0014','DP-01913','1160000'); 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-05-03','FJ-260503-0015','2026-05-03','18:57:38','SULIS','1429000','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-260503-0030','2026-05-03','2026-05-03 18:57:37','PENJUALAN : FJ-260503-0015','.','TBC','269000','269000','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-260503-0031','D','2026-05-03','18:57:38','TBC','PENJUALAN','FJ-260503-0015','22132361514','269000','22132630514','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='1015000' WHERE no_faktur_jual='FJ-260503-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0015'; 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-260503-0016','kasirbip','1',' DP-01818BI','TOKO','BIPPSN','PSPLT-ZDBX-6-0','CINCIN PALADIUM ','','1.900','1','17.00','427000','0','0','17000','1530000','0','0','0','1530000','SULIS','00042667','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZDBX-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PSPLT-ZDBX-6-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-260503-0016','2026-05-03','1.900','2026-05-03','19:56:20','PLG0010834','1530000','1530000','0','1530000','0','kasirbip','2026-05-03 19:56:20','FJ-260503-0016','DP-01818','1250000'); 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-05-03','FJ-260503-0016','2026-05-03','19:56:20','SULIS','1530000','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-260503-0031','2026-05-03','2026-05-03 19:56:20','PENJUALAN : FJ-260503-0016','.','TBC','280000','280000','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-260503-0032','D','2026-05-03','19:56:20','TBC','PENJUALAN','FJ-260503-0016','22132630514','280000','22132910514','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='280000' WHERE no_faktur_jual='FJ-260503-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-260503-0017','kasirbip',' 1',' DP-01817BI','TOKO','BIPPSN','PSPRT-ZDXH-3-0','CINCIN PERAK ','','3.380','1','100.00','345000','0','0','17000','800000','0','0','0','800000','SULIS','00042394','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZDXH-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.380',berat_jual_asli=berat_jual_asli+'3.380',stock_jual='1',berat_akhir=berat_akhir-'3.380',berat_akhir_asli=berat_akhir_asli-'3.380',stock_akhir='0' WHERE tanggal='2026-05-03' AND kode_barang='PSPRT-ZDXH-3-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-260503-0017','2026-05-03','3.380','2026-05-03','19:56:20','PLG0010835','800000','800000','0','800000','0','kasirbip','2026-05-03 19:56:20','FJ-260503-0016','DP-01817','800000'); 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-05-03','FJ-260503-0017','2026-05-03','19:56:20','SULIS','800000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='280000' WHERE no_faktur_jual='FJ-260503-0017' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260503-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260503-0017';