INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-17 ','09:53:08'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-17','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-16'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-16'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-16'; 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-16' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-16'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-16'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-16'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-16'; 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-17' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-16' 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-260517-0001','D','2026-05-17','10:07:33','TBC','SALDO AWAL','SALDO AWAL','0','22523338514','22523338514'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','10:07:33','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-260517-0001','D','2026-05-17','10:07:33','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','10:07:33','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','10:07:33','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','10:07:33','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','10:07:33','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','10:07:33','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','10:07:33','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260517-0001','D','2026-05-17','10:07:33','','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-260517-0001','D','2026-05-17','10:07:33','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-260517-0001','D','2026-05-17','10:07:33','BCD','SALDO AWAL','SALDO AWAL','0','1389488500','1389488500'); UPDATE tp_system SET tgl_system='2026-05-17'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-17 ','10:12:48'); 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-17', status ='CLOS' WHERE no_service='SV-02043'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02043'; 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-17', status ='CLOS' WHERE no_service='SV-02007'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02007'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-17 ','10:30:24'); 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-02162','KUR','1','PER','WEDD RING','','','1.100','','925.00','1','100000','0','850000','0','850000','sz 14 crom putih gllosy','grf Reza font Brush script','1 pasang exspress','0','0','200000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0001','2026-05-17','2026-05-17 10:40:49','PESANAN : DP-02162','.','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-260517-0002','D','2026-05-17','10:40:49','TBC','PESANAN','DP-02162','22523338514','1050000','22524388514','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-02162','2026-05-17','2026-05-17','10:40:49','PLG0011177','KUR','2026-05-22','kasirbip','2026-05-17 10:40:49','1.100','0','0','0','1050000','0','0','1050000','1050000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-17 ','10:41:08'); 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-02163','KUR','1','PER','WEDD RING','','','2.000','','925.00','1','100000','0','650000','0','650000','sz 24.5 crom doff amplas YL01','grf Eva','font brush script','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-260517-0002','2026-05-17','2026-05-17 10:45:10','PESANAN : DP-02163','.','TBC','650000','650000'); 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-260517-0003','D','2026-05-17','10:45:10','TBC','PESANAN','DP-02163','22524388514','650000','22525038514','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-02163','2026-05-17','2026-05-17','10:45:10','PLG0011178','KUR','2026-05-22','kasirbip','2026-05-17 10:45:10','2.000','0','0','0','650000','0','0','650000','650000','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-02164','KUR','1','PER','WEDD RING','','','2.000','','925.00','1','100000','0','650000','0','650000','sz 24.5 crom doff amplas YL01','grf Eva','font brush script','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-260517-0003','2026-05-17','2026-05-17 10:45:10','PESANAN : DP-02164','.','TBC','650000','650000'); 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-260517-0004','D','2026-05-17','10:45:10','TBC','PESANAN','DP-02164','22525038514','650000','22525688514','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-02164','2026-05-17','2026-05-17','10:45:10','PLG0011179','KUR','2026-05-22','kasirbip','2026-05-17 10:45:10','2.000','0','0','0','650000','0','0','650000','650000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-17 ','10:45:42'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-17 ','10:50:35'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-17 ','10:57:01'); UPDATE tm_user SET nama_lkp='b',pass_key='d',type='OWN' WHERE user_id='b'; INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-02163'; INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-02163'; UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-02163'; 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-260517-0002','K','2026-05-17','10:57:52','Nagatech','PESANAN BATAL','DP-02163','278100','0','278100'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-17 ','10:58:09'); 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-02165','PUT','1','PER','WEDD RING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 24 Catalog LX-75','grf Anastasia 27-06','font berkshire','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-260517-0004','2026-05-17','2026-05-17 12:06:17','PESANAN : DP-02165','.','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-260517-0005','D','2026-05-17','12:06:17','TBC','PESANAN','DP-02165','22525688514','850000','22526538514','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-02165','2026-05-17','2026-05-17','12:06:17','PLG0011180','PUT','2026-06-13','kasirbip','2026-05-17 12:06:17','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-02166','PUT','1','PLD','WEDD RING','','','3.000','','25.00','1','1200000','500000','0','800000','2300000','sirkon 14','sz 21 catalog LX-75','grf Kevin 27-06 font berkshire','140000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0005','2026-05-17','2026-05-17 12:11:41','PESANAN : DP-02166','.','TBC','1952000','1952000'); 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-260517-0006','D','2026-05-17','12:11:41','TBC','PESANAN','DP-02166','22526538514','1952000','22528490514','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-02166','2026-05-17','2026-05-17','12:11:41','PLG0011181','PUT','2026-06-13','kasirbip','2026-05-17 12:11:41','3.000','0','0','0','1952000','0','800000','2440000','2440000','488000'); 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-260517-0001','kasirbip','1',' DP-02095DU','TOKO','DUPSN','PSPRT-ZEAE-44-0','CINCIN PERAK SR-04 YL-01 ','','3.100','1','100.00','317000','0','0','17500','950000','0','0','0','950000','PUT','00043611','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEAE-44-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PSPRT-ZEAE-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260517-0001','2026-05-17','3.100','2026-05-17','12:38:55','PLG0011182','950000','950000','0','950000','0','kasirbip','2026-05-17 12:38:55','FJ-260517-0001','DP-02095','950000'); 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-17','FJ-260517-0001','2026-05-17','12:38:55','PUT','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260517-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0001'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260517-0002','kasirbip','1',' 800K-18-24','TOKO','BIPPER','PBDG-ZDBA-12-0','CINCIN SILVER 925 ','','3.370','1','100.00','344000','0','0','17500','900000','0','0','0','900000','SAL','00042685','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDBA-12-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.370',berat_jual_asli=berat_jual_asli+'3.370',stock_jual='1',berat_akhir=berat_akhir-'3.370',berat_akhir_asli=berat_akhir_asli-'3.370',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PBDG-ZDBA-12-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-260517-0002','2026-05-17','3.370','2026-05-17','13:24:57','PLG0011183','900000','900000','0','900000','0','kasirbip','2026-05-17 13:24:57','FJ-260517-0002','','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-17','FJ-260517-0002','2026-05-17','13:24:57','SAL','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-260517-0006','2026-05-17','2026-05-17 13:24:57','PENJUALAN : FJ-260517-0002','.','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-260517-0007','D','2026-05-17','13:24:57','TBC','PENJUALAN','FJ-260517-0002','22528490514','900000','22529390514','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-260517-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0002'; 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-02167','KUR','1','PLD','CINCIN KAWIN','','','2.000','','10.00','1','1200000','300000','0','1000000','1600000','size 12.5','putih kilat sirkon 14','bikin seperti contoh','0','140000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0007','2026-05-17','2026-05-17 13:58:46','PESANAN : DP-02167','.','TBC','1390000','1390000'); 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-260517-0008','D','2026-05-17','13:58:46','TBC','PESANAN','DP-02167','22529390514','1390000','22530780514','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-02167','2026-05-17','2026-05-17','13:58:46','PLG0011184','KUR','2026-06-07','kasirbip','2026-05-17 13:58:46','2.000','0','0','0','1390000','0','1000000','1740000','1740000','350000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-17 ','14:15:39'); 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-02168','ELLA','1','GOLD','WEDDING RING','','','2.000','','12.00','1','2450000','2000000','0','950000','4950000','size 12 grf iman love melani','warna rosegold','zircon 17','0','0','170000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0008','2026-05-17','2026-05-17 14:26:19','PESANAN : DP-02168','0','TBC','4096000','4096000'); 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-260517-0009','D','2026-05-17','14:26:19','TBC','PESANAN','DP-02168','22530780514','4096000','22534876514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-02168','2026-05-17','2026-05-17','14:26:19','PLG0011185','ELLA','2026-06-08','kasir','2026-05-17 14:26:19','2.000','0','0','0','4096000','0','950000','5120000','5120000','1024000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-17 ','14:26:56'); 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-02169','ELLA','1','PLD','WEDDING RING','','','6.500','','10.00','1','1200000','300000','0','850000','2800000','size 28 grf melani love iman','warna rosegold doff doff amplas sesuai model','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0009','2026-05-17','2026-05-17 14:32:39','PESANAN : DP-02169','0','TBC','2240000','2240000'); 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-260517-0010','D','2026-05-17','14:32:39','TBC','PESANAN','DP-02169','22534876514','2240000','22537116514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-02169','2026-05-17','2026-05-17','14:32:39','PLG0011186','ELLA','2026-06-08','kasir','2026-05-17 14:32:39','6.500','0','0','0','2240000','0','850000','2800000','2800000','560000'); 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-260517-0003','kasirbip','1',' 700K-11-22','TOKO','BIPPER','PBDG-ZBAX-47-0','CINCIN SILVER 925 ','','2.480','1','100.00','253000','0','0','17500','800000','0','0','0','800000','SAL','00041483','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAX-47-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.480',berat_jual_asli=berat_jual_asli+'2.480',stock_jual='1',berat_akhir=berat_akhir-'2.480',berat_akhir_asli=berat_akhir_asli-'2.480',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PBDG-ZBAX-47-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-260517-0003','2026-05-17','2.480','2026-05-17','14:47:36','PLG0011187','800000','800000','0','800000','0','kasirbip','2026-05-17 14:47:36','FJ-260517-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-17','FJ-260517-0003','2026-05-17','14:47:36','SAL','800000','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-260517-0010','2026-05-17','2026-05-17 14:47:36','PENJUALAN : FJ-260517-0003','.','TBC','800000','800000','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-260517-0011','D','2026-05-17','14:47:36','TBC','PENJUALAN','FJ-260517-0003','22537116514','800000','22537916514','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='800000' WHERE no_faktur_jual='FJ-260517-0003' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260517-0004','kasirbip',' 1',' 700K-185-2','TOKO','BIPPER','PBDG-ZDXG-29-0','CINCIN SILVER 925 ','','2.300','1','100.00','236000','0','0','17500','800000','0','0','0','800000','SAL','00042344','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXG-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PBDG-ZDXG-29-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-260517-0004','2026-05-17','2.300','2026-05-17','14:47:36','PLG0011188','800000','800000','0','800000','0','kasirbip','2026-05-17 14:47:36','FJ-260517-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-17','FJ-260517-0004','2026-05-17','14:47:36','SAL','800000','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-260517-0011','2026-05-17','2026-05-17 14:47:36','PENJUALAN : FJ-260517-0004','.','TBC','800000','800000','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-260517-0012','D','2026-05-17','14:47:36','TBC','PENJUALAN','FJ-260517-0004','22537916514','800000','22538716514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1600000' WHERE no_faktur_jual='FJ-260517-0004' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-17 ','15:06:52'); 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-02170','GIN','1','GOLD','WED RING','','','2.500','','37.50','1','2450000','1500000','0','1000000','4750000','rose gold glosy 28 zirkon','sz 15 front vintage rotter','grf Wadif & Dena','280000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0012','2026-05-17','2026-05-17 15:08:03','PESANAN : DP-02170','.','TBC','4024000','4024000'); 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-260517-0013','D','2026-05-17','15:08:03','TBC','PESANAN','DP-02170','22538716514','4024000','22542740514','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-02170','2026-05-17','2026-05-17','15:08:03','PLG0011189','GIN','2026-06-17','kasirbip','2026-05-17 15:08:03','2.500','0','0','0','4024000','0','1000000','5030000','5030000','1006000'); 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-02171','ALIKA','1','GOLD','WEDING RING','','','2.500','','37.50','1','2450000','1500000','0','950000','4700000','size 17 grf ilham love mira','warna kuning silver','zircone 14','0','0','140000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0013','2026-05-17','2026-05-17 15:16:35','PESANAN : DP-02171','0','TBC','3872000','3872000'); 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-260517-0014','D','2026-05-17','15:16:35','TBC','PESANAN','DP-02171','22542740514','3872000','22546612514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-02171','2026-05-17','2026-05-17','15:16:35','PLG0011190','ALIKA','2026-06-07','kasir','2026-05-17 15:16:35','2.500','0','0','0','3872000','0','950000','4840000','4840000','968000'); 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-260517-0005','kasir','1',' 700K-15-00','TOKO','MMPER','PBSD-YGBD-40-0','CINCIN SILVER 925 ','','4.330','1','100.00','89000','0','0','17500','850000','0','0','0','850000','ALIKA','00037502','PBSD','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBD-40-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.330',berat_jual_asli=berat_jual_asli+'4.330',stock_jual='1',berat_akhir=berat_akhir-'4.330',berat_akhir_asli=berat_akhir_asli-'4.330',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PBSD-YGBD-40-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-260517-0005','2026-05-17','4.330','2026-05-17','15:19:23','PLG0011191','850000','850000','0','850000','0','kasir','2026-05-17 15:19:23','FJ-260517-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-17','FJ-260517-0005','2026-05-17','15:19:23','ALIKA','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-260517-0014','2026-05-17','2026-05-17 15:19:23','PENJUALAN : FJ-260517-0005','0','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-260517-0015','D','2026-05-17','15:19:23','TBC','PENJUALAN','FJ-260517-0005','22546612514','850000','22547462514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); 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-260517-0005' 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-02172','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1100000','0','1100000','sz 13.5 putih glosy','font yeseva one','grf Miftah . . . Risa','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0015','2026-05-17','2026-05-17 15:22:37','PESANAN : DP-02172','.','TBC','1100000','1100000'); 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-260517-0016','D','2026-05-17','15:22:37','TBC','PESANAN','DP-02172','22547462514','1100000','22548562514','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-02172','2026-05-17','2026-05-17','15:22:37','PLG0011192','SAL','2026-06-17','kasirbip','2026-05-17 15:22:37','2.000','0','0','0','1100000','0','0','1100000','1100000','0'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02056','ALIKA','1','SILVER','RESIZE 19 GRF MIRA LOVE ILHAM CROM ULANG PUTIH DOFF AMPLAS','4.330','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-02056','2026-05-17','2026-05-17','15:23:29','PLG0011193','kasir','2026-05-20','kasir','2026-05-17 15:23:29','4.330','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-17 ','15:23:54'); 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-02173','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','700000','0','700000','YL-01 sz 21','putih doff amplass font yeseva one','grf Miftah . . . Risa','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0016','2026-05-17','2026-05-17 15:23:58','PESANAN : DP-02173','.','TBC','700000','700000'); 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-260517-0017','D','2026-05-17','15:23:58','TBC','PESANAN','DP-02173','22548562514','700000','22549262514','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-02173','2026-05-17','2026-05-17','15:23:58','PLG0011194','SAL','2026-06-17','kasirbip','2026-05-17 15:23:58','2.000','0','0','0','700000','0','0','700000','700000','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-260517-0006','kasirbip','1',' DP-01938BI','TOKO','BIPPSN','PSGT-ZDBH-80-0','CINCIN EMAS ','','2.670','1','83.00','5652000','0','0','17500','7108000','0','0','0','7108000','GIN','00042896','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZDBH-80-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.670',berat_jual_asli=berat_jual_asli+'2.670',stock_jual='1',berat_akhir=berat_akhir-'2.670',berat_akhir_asli=berat_akhir_asli-'2.670',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PSGT-ZDBH-80-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-260517-0006','2026-05-17','2.670','2026-05-17','15:26:02','PLG0011195','7108000','7108000','0','7108000','0','kasirbip','2026-05-17 15:26:01','FJ-260517-0006','DP-01938','5360000'); 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-17','FJ-260517-0006','2026-05-17','15:26:02','GIN','7108000','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-260517-0017','2026-05-17','2026-05-17 15:26:01','PENJUALAN : FJ-260517-0006','.','TBC','1748000','1748000','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-260517-0018','D','2026-05-17','15:26:02','TBC','PENJUALAN','FJ-260517-0006','22549262514','1748000','22551010514','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='1748000' WHERE no_faktur_jual='FJ-260517-0006' 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-260517-0007','kasirbip',' 1',' DP-01939BI','TOKO','BIPPSN','PSPLT-ZEAE-37-0','CINCIN PALADIUM ','','4.080','1','32.00','1724000','0','0','17500','2740000','0','0','0','2740000','GIN','00043604','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEAE-37-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.080',berat_jual_asli=berat_jual_asli+'4.080',stock_jual='1',berat_akhir=berat_akhir-'4.080',berat_akhir_asli=berat_akhir_asli-'4.080',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PSPLT-ZEAE-37-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-260517-0007','2026-05-17','4.080','2026-05-17','15:26:02','PLG0011196','2740000','2740000','0','2740000','0','kasirbip','2026-05-17 15:26:01','FJ-260517-0006','DP-01939','2160000'); 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-17','FJ-260517-0007','2026-05-17','15:26:02','GIN','2740000','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-260517-0018','2026-05-17','2026-05-17 15:26:01','PENJUALAN : FJ-260517-0007','.','TBC','580000','580000','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-260517-0019','D','2026-05-17','15:26:02','TBC','PENJUALAN','FJ-260517-0007','22551010514','580000','22551590514','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='2328000' WHERE no_faktur_jual='FJ-260517-0007' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0007'; UPDATE tp_curr SET rp= '17600.00' WHERE curr = 'USD' LIMIT 1; INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '17600.00', 'kasir','2026-05-17 15:56:09'); 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-260517-0008','kasir','1',' TFGRR75-81','TOKO','TFGLR','TFGRR-YLXC-45-0','THIFA GELANG RANTAI RG ','','2.430','1','81.00','4919000','0','0','17600','5100000','0','0','0','5100000','FIR','00040168','TFGRR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YLXC-45-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-17' AND kode_barang='TFGRR-YLXC-45-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-260517-0008','2026-05-17','2.430','2026-05-17','15:59:47','PLG0011197','5100000','5100000','0','5100000','0','kasir','2026-05-17 15:59:46','FJ-260517-0008','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-17','FJ-260517-0008','2026-05-17','15:59:47','FIR','5100000','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-260517-0019','2026-05-17','2026-05-17 15:59:46','PENJUALAN : FJ-260517-0008','','TBC','5100000','5100000','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-260517-0020','D','2026-05-17','15:59:47','TBC','PENJUALAN','FJ-260517-0008','22551590514','5100000','22556690514','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='5100000' WHERE no_faktur_jual='FJ-260517-0008' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260517-0009','kasir',' 1',' TFKMR75-85','TOKO','TFKMP','TFKMR-YFBF-28-0','THIFA KALUNG MAS RG ','','2.980','1','85.00','6827000','0','0','17600','6450000','0','0','0','6450000','FIR','00036767','TFKMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFKMR-YFBF-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='TFKMR-YFBF-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFKMP' 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-260517-0009','2026-05-17','2.980','2026-05-17','15:59:47','PLG0011198','6450000','6450000','0','6450000','0','kasir','2026-05-17 15:59:46','FJ-260517-0008','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-17','FJ-260517-0009','2026-05-17','15:59:47','FIR','6450000','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-260517-0020','2026-05-17','2026-05-17 15:59:46','PENJUALAN : FJ-260517-0009','','TBC','6450000','6450000','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-260517-0021','D','2026-05-17','15:59:47','TBC','PENJUALAN','FJ-260517-0009','22556690514','6450000','22563140514','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='11550000' WHERE no_faktur_jual='FJ-260517-0009' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0009'; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02174','GIN','1','PLD','WED RING','','','4.500','','10.00','1','1200000','300000','0','700000','2050000','sz 18 crom rosegold glosy komb doff semprot putih','permata dibuat lebih kecil dan jangan timbul. express','grf','0','200000',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0021','2026-05-17','2026-05-17 16:24:48','PESANAN : DP-02174','.','TBC','1840000','1840000'); 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-260517-0022','D','2026-05-17','16:24:48','TBC','PESANAN','DP-02174','22563140514','1840000','22564980514','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-02174','2026-05-17','2026-05-17','16:24:48','PLG0011199','GIN','2026-05-23','kasirbip','2026-05-17 16:24:48','4.500','0','0','0','1840000','0','700000','2250000','2250000','410000'); 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-260517-0010','kasir','1',' 700K-17-00','TOKO','MMPER','PMM-YGXC-28-0','CINCIN SILVER 925 ','','3.020','1','100.00','70000','0','0','17600','850000','0','0','0','850000','ELLA','00036946','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXC-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PMM-YGXC-28-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-260517-0010','2026-05-17','3.020','2026-05-17','16:28:56','PLG0011200','850000','850000','0','850000','0','kasir','2026-05-17 16:28:55','FJ-260517-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-17','FJ-260517-0010','2026-05-17','16:28:56','ELLA','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-260517-0022','2026-05-17','2026-05-17 16:28:55','PENJUALAN : FJ-260517-0010','0','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-260517-0023','D','2026-05-17','16:28:56','TBC','PENJUALAN','FJ-260517-0010','22564980514','850000','22565830514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); 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-260517-0010' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260517-0011','kasirbip','1',' DP-01978BI','TOKO','BIPPSN','PSPLT-ZEAD-6-0','CINCIN PALADIUM ','','2.930','1','17.00','658000','0','0','17600','1629000','0','0','0','1629000','KUR','00043564','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEAD-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.930',berat_jual_asli=berat_jual_asli+'2.930',stock_jual='1',berat_akhir=berat_akhir-'2.930',berat_akhir_asli=berat_akhir_asli-'2.930',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PSPLT-ZEAD-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-260517-0011','2026-05-17','2.930','2026-05-17','16:53:15','PLG0011201','1629000','1629000','0','1629000','0','kasirbip','2026-05-17 16:53:14','FJ-260517-0011','DP-01978','1560000'); 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-17','FJ-260517-0011','2026-05-17','16:53:15','KUR','1629000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260517-0011' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260517-0012','kasirbip',' 1',' DP-01977BI','TOKO','BIPPSN','PSPLT-ZEAD-5-0','CINCIN PALADIUM ','','1.560','1','17.00','351000','0','0','17600','1218000','0','0','0','1218000','KUR','00043563','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEAD-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PSPLT-ZEAD-5-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-260517-0012','2026-05-17','1.560','2026-05-17','16:53:15','PLG0011202','1218000','1218000','0','1218000','-33000','kasirbip','2026-05-17 16:53:14','FJ-260517-0011','DP-01977','1320000'); 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-17','FJ-260517-0012','2026-05-17','16:53:15','KUR','1218000','0'); UPDATE tt_jual_head SET dibayar_rp='-33000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260517-0012' LIMIT 1; UPDATE tt_service_head SET tgl_selesai='2026-05-17', status ='DONE' WHERE no_service='SV-02032'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02032'; UPDATE tt_service_head SET tgl_selesai='2026-05-17', status ='DONE' WHERE no_service='SV-02033'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02033'; 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-17', status ='CLOS' WHERE no_service='SV-02032'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02032'; 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-17', status ='CLOS' WHERE no_service='SV-02033'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02033'; 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-17', status ='CLOS' WHERE no_service='SV-02015'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0012'; 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-02175','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','300000','0','700000','1600000','sz 18 putih doff amplas','font vintage rotter grf Ashri . Jae','','','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0023','2026-05-17','2026-05-17 17:29:20','PESANAN : DP-02175','.','TBC','1280000','1280000'); 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-260517-0024','D','2026-05-17','17:29:20','TBC','PESANAN','DP-02175','22565830514','1280000','22567110514','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-02175','2026-05-17','2026-05-17','17:29:20','PLG0011203','SULIS','2026-06-17','kasirbip','2026-05-17 17:29:20','3.000','0','0','0','1280000','0','700000','1600000','1600000','320000'); 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-02176','ADMIN','1','GOLD','WED RING','','','1.500','','37.50','1','2450000','1500000','0','750000','3000000','sz 12.5 putih glossy 1 zirkon','font vintage rotter grf Ashri . Jae','','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-260517-0024','2026-05-17','2026-05-17 17:32:16','PESANAN : DP-02176','.','TBC','2400000','2400000'); 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-260517-0025','D','2026-05-17','17:32:16','TBC','PESANAN','DP-02176','22567110514','2400000','22569510514','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-02176','2026-05-17','2026-05-17','17:32:16','PLG0011204','ADMIN','2026-06-17','kasirbip','2026-05-17 17:32:16','1.500','0','0','0','2400000','0','750000','3000000','3000000','600000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-17 ','17:41:35'); 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-260517-0013','kasirbip','1',' DP-02124DU','TOKO','DUPSN','PSPLT-ZEAE-29-0','CINCIN PALADIUM YL-10 ','','4.050','1','17.00','910000','0','0','17600','2015000','0','0','0','2015000','PUT','00043596','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEAE-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.050',berat_jual_asli=berat_jual_asli+'4.050',stock_jual='1',berat_akhir=berat_akhir-'4.050',berat_akhir_asli=berat_akhir_asli-'4.050',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PSPLT-ZEAE-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260517-0013','2026-05-17','4.050','2026-05-17','17:44:24','PLG0011205','2015000','2015000','0','2015000','0','kasirbip','2026-05-17 17:44:23','FJ-260517-0013','DP-02124','1600000'); 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-17','FJ-260517-0013','2026-05-17','17:44:24','PUT','2015000','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-260517-0025','2026-05-17','2026-05-17 17:44:23','PENJUALAN : FJ-260517-0013','.','BCD','415000','415000','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-260517-0002','D','2026-05-17','17:44:24','BCD','PENJUALAN','FJ-260517-0013','1389488500','415000','1389903500','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='415000' WHERE no_faktur_jual='FJ-260517-0013' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260517-0014','kasirbip','1',' DP-02122DU','TOKO','DUPSN','PSPLT-ZEAE-42-0','CINCIN PALADIUM ','','2.420','1','32.00','1023000','0','0','17600','2350000','0','0','0','2350000','PUT','00043609','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEAE-42-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.420',berat_jual_asli=berat_jual_asli+'2.420',stock_jual='1',berat_akhir=berat_akhir-'2.420',berat_akhir_asli=berat_akhir_asli-'2.420',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PSPLT-ZEAE-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260517-0014','2026-05-17','2.420','2026-05-17','17:46:35','PLG0011206','2350000','2350000','0','2350000','0','kasirbip','2026-05-17 17:46:34','FJ-260517-0014','DP-02122','1712000'); 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-17','FJ-260517-0014','2026-05-17','17:46:35','PUT','2350000','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-260517-0026','2026-05-17','2026-05-17 17:46:34','PENJUALAN : FJ-260517-0014','.','TBC','638000','638000','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-260517-0026','D','2026-05-17','17:46:35','TBC','PENJUALAN','FJ-260517-0014','22569510514','638000','22570148514','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='638000' WHERE no_faktur_jual='FJ-260517-0014' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0014'; 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-02177','PUT','1','PER','WEDD RING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 18 crom sama kan seperti contoh','grf Arri 18.07.26','font Vladimir','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-260517-0027','2026-05-17','2026-05-17 18:01:03','PESANAN : DP-02177','.','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-260517-0027','D','2026-05-17','18:01:03','TBC','PESANAN','DP-02177','22570148514','850000','22570998514','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-02177','2026-05-17','2026-05-17','18:01:03','PLG0011207','PUT','2026-06-13','kasirbip','2026-05-17 18:01:03','3.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-17 ','18:01:15'); 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-02178','PUT','1','PER','WEDD RING','','','2.000','','925.00','1','100000','0','950000','0','950000','sz 13.5 crom putih gllosy','grf Adit 18.07.26','font vladimir','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-260517-0028','2026-05-17','2026-05-17 18:04:45','PESANAN : DP-02178','.','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-260517-0028','D','2026-05-17','18:04:45','TBC','PESANAN','DP-02178','22570998514','950000','22571948514','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-02178','2026-05-17','2026-05-17','18:04:45','PLG0011208','PUT','2026-06-13','kasirbip','2026-05-17 18:04:45','2.000','0','0','0','950000','0','0','950000','950000','0'); 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='100000',sld_akhir_rp=sld_akhir_rp-'100000', tgl_ambil='2026-05-17', status ='CLOS' WHERE no_service='SV-02046'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02046'; 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-260517-0029','2026-05-17','2026-05-17 18:12:26','AMBIL SERVICE : SV-02046','.','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-260517-0029','D','2026-05-17','18:12:26','TBC','AMBIL SERVICE','SV-02046','22571948514','100000','22572048514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); 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-260517-0015','kasirbip','1',' DP-02080BI','TOKO','BIPPSN','PSPRT-ZEAE-35-0','CINCIN PERAK SR-01 YL-01 ','','2.790','1','100.00','285000','0','0','17600','950000','0','0','0','950000','KUR','00043602','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEAE-35-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.790',berat_jual_asli=berat_jual_asli+'2.790',stock_jual='1',berat_akhir=berat_akhir-'2.790',berat_akhir_asli=berat_akhir_asli-'2.790',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PSPRT-ZEAE-35-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-260517-0015','2026-05-17','2.790','2026-05-17','18:47:18','PLG0011209','950000','950000','0','950000','0','kasirbip','2026-05-17 18:47:17','FJ-260517-0015','DP-02080','950000'); 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-17','FJ-260517-0015','2026-05-17','18:47:18','KUR','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260517-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0015'; 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-17', status ='CLOS' WHERE no_service='SV-02016'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02016'; 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-02179','RIRIN','1','GOLD','CINCIN SR9K03 EMAS','','','1.400','','375.00','1','2450000','1500000','0','750000','2850000','size 16 grf dani','zircon 1 butir','warna putih glosy sesuai 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-260517-0030','2026-05-17','2026-05-17 19:10:20','PESANAN : DP-02179','0','TBC','2280000','2280000'); 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-260517-0030','D','2026-05-17','19:10:20','TBC','PESANAN','DP-02179','22572048514','2280000','22574328514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-02179','2026-05-17','2026-05-17','19:10:20','PLG0011210','RIRIN','2026-06-07','kasir','2026-05-17 19:10:20','1.400','0','0','0','2280000','0','750000','2850000','2850000','570000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-17 ','19:13:24'); 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-02180','RIRIN','1','PER','CINCIN YL01 SILVER','','','1.000','','925.00','1','100000','500000','0','0','500000','size 20 grf tina','warna putih doff amplas','up size','0','0','100000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260517-0031','2026-05-17','2026-05-17 19:19:24','PESANAN : DP-02180','0','TBC','600000','600000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260517-0031','D','2026-05-17','19:19:24','TBC','PESANAN','DP-02180','22574328514','600000','22574928514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','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-02180','2026-05-17','2026-05-17','19:19:24','PLG0011211','RIRIN','2026-06-07','kasir','2026-05-17 19:19:24','1.000','0','0','0','600000','0','0','600000','600000','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-260517-0016','kasirbip','1',' 800K-18-24','TOKO','BIPPER','PBDG-ZDBA-6-0','CINCIN SILVER 925 ','','2.410','1','100.00','246000','0','0','17600','900000','0','0','0','900000','SAL','00042679','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDBA-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PBDG-ZDBA-6-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-260517-0016','2026-05-17','2.410','2026-05-17','19:36:41','PLG0011212','900000','900000','0','900000','0','kasirbip','2026-05-17 19:36:41','FJ-260517-0016','','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-17','FJ-260517-0016','2026-05-17','19:36:41','SAL','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-260517-0032','2026-05-17','2026-05-17 19:36:41','PENJUALAN : FJ-260517-0016','.','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-260517-0032','D','2026-05-17','19:36:41','TBC','PENJUALAN','FJ-260517-0016','22574928514','900000','22575828514','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-260517-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-260517-0017','kasirbip',' 1',' 950K-13-25','TOKO','BIPPER','PBDG-ZEAB-61-0','CINCIN SILVER 925 ','','1.880','1','100.00','192000','0','0','17600','1050000','0','0','0','1050000','SAL','00043528','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEAB-61-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PBDG-ZEAB-61-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-260517-0017','2026-05-17','1.880','2026-05-17','19:36:41','PLG0011213','1050000','1050000','0','1050000','0','kasirbip','2026-05-17 19:36:41','FJ-260517-0016','','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-17','FJ-260517-0017','2026-05-17','19:36:41','SAL','1050000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260517-0033','2026-05-17','2026-05-17 19:36:41','PENJUALAN : FJ-260517-0017','.','TBC','1050000','1050000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260517-0033','D','2026-05-17','19:36:41','TBC','PENJUALAN','FJ-260517-0017','22575828514','1050000','22576878514','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-260517-0017' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260517-0018','kasirbip','1',' DP-02084DU','TOKO','DUPSN','PSPRT-ZEAE-39-0','CINCIN PERAK SR-05 YL-01 ','','3.150','1','100.00','322000','0','0','17600','950000','0','0','0','950000','PUT','00043606','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEAE-39-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-05-17' AND kode_barang='PSPRT-ZEAE-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' 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-260517-0018','2026-05-17','3.150','2026-05-17','19:56:47','PLG0011214','950000','950000','0','950000','0','kasirbip','2026-05-17 19:56:47','FJ-260517-0018','DP-02084','950000'); 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-17','FJ-260517-0018','2026-05-17','19:56:47','PUT','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260517-0018' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260517-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260517-0018'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-17 ','20:01:21'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-17 ','20:10:05');