INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-31 ','10:03:31');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-31','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-30';
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-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-30';
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-31' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-30' 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-260531-0001','D','2026-05-31','10:11:17','TBC','SALDO AWAL','SALDO AWAL','0','23037322514','23037322514');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260531-0001','D','2026-05-31','10:11:17','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260531-0001','D','2026-05-31','10:11:17','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-260531-0001','D','2026-05-31','10:11:17','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-260531-0001','D','2026-05-31','10:11:17','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-260531-0001','D','2026-05-31','10:11:17','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-260531-0001','D','2026-05-31','10:11:17','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-260531-0001','D','2026-05-31','10:11:17','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-260531-0001','D','2026-05-31','10:11:17','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-260531-0001','D','2026-05-31','10:11:17','','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-260531-0001','D','2026-05-31','10:11:17','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-260531-0001','D','2026-05-31','10:11:17','BCD','SALDO AWAL','SALDO AWAL','0','1389903500','1389903500');
UPDATE tp_system SET tgl_system='2026-05-31';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-31 ','10:35:21');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-31 ','10:51:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-31 ','11:15:11');
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-260531-0001','kasirbip','1',' DP-02239DU','TOKO','DUPSN','PSPLT-ZEBI-52-0','CINCIN PALADIUM ','','3.550','1','17.00','797000','0','0','17800','1992500','0','0','0','1992500','PUT','00043878','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBI-52-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.550',berat_jual_asli=berat_jual_asli+'3.550',stock_jual='1',berat_akhir=berat_akhir-'3.550',berat_akhir_asli=berat_akhir_asli-'3.550',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSPLT-ZEBI-52-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-260531-0001','2026-05-31','3.550','2026-05-31','11:16:22','PLG0011559','1992500','1992500','0','1992500','0','kasirbip','2026-05-31 11:16:22','FJ-260531-0001','DP-02239','1580000');
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-31','FJ-260531-0001','2026-05-31','11:16:22','PUT','1992500','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-260531-0001','2026-05-31','2026-05-31 11:16:22','PENJUALAN : FJ-260531-0001','.','TBC','412500','412500','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-260531-0002','D','2026-05-31','11:16:22','TBC','PENJUALAN','FJ-260531-0001','23037322514','412500','23037735014','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='412500' WHERE no_faktur_jual='FJ-260531-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0001';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02095','PUT','1','','RESIZE CEWE SIZE 8 COWO SIZE 20','3.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-02095','2026-05-31','2026-05-31','11:28:27','PLG0011560','kasirbip','2026-06-01','kasirbip','2026-05-31 11:28:27','3.000','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-02279','SAL ','1','GOLD','WED RING','','','2.000','','37.50','1','2420000','1500000','0','950000','3950000','23 zirkon putih glosy','sz 10.5 font brush script','grf Matheus','230000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0002','2026-05-31','2026-05-31 11:36:38','PESANAN : DP-02279','.','TBC','3344000','3344000');
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-260531-0003','D','2026-05-31','11:36:38','TBC','PESANAN','DP-02279','23037735014','3344000','23041079014','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-02279','2026-05-31','2026-05-31','11:36:38','PLG0011561','SAL ','2026-07-01','kasirbip','2026-05-31 11:36:38','2.000','0','0','0','3344000','0','950000','4180000','4180000','836000');
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-02280','SAL ','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','putih glossy comb putih doff semprot 1 zirkon','sz 21 font brush script','grf Vanesa','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0003','2026-05-31','2026-05-31 11:38:36','PESANAN : DP-02280','.','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-260531-0004','D','2026-05-31','11:38:36','TBC','PESANAN','DP-02280','23041079014','850000','23041929014','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-02280','2026-05-31','2026-05-31','11:38:36','PLG0011562','SAL ','2026-07-01','kasirbip','2026-05-31 11:38:36','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-31 ','12:18:24');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02096','ELLA','1','WEDING RING','RESIZE 16','2.380','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-02096','2026-05-31','2026-05-31','12:20:35','PLG0011563','kasir','2026-06-03','kasir','2026-05-31 12:20:35','2.380','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-02281','KUR','1','PER','CINCIN KAWIN SILVER','','','2.000','','925.00','1','100000','0','950000','0','950000','size 15 grf Ahmad Hamzah','font vintage rotter sirkon 10','putih kilat','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-260531-0004','2026-05-31','2026-05-31 13:20:52','PESANAN : DP-02281','.','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-260531-0005','D','2026-05-31','13:20:52','TBC','PESANAN','DP-02281','23041929014','950000','23042879014','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-02281','2026-05-31','2026-05-31','13:20:52','PLG0011564','KUR','2026-06-21','kasirbip','2026-05-31 13:20:52','2.000','0','0','0','950000','0','0','950000','950000','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-02282','KUR','1','PER','CINCIN KAWIN SILVER','','','2.500','','925.00','1','100000','0','850000','0','850000','size 16.5 grf Puhena Srinaeni','font vintage roter','putih kilat dof semprot sesuai contoh','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-260531-0005','2026-05-31','2026-05-31 13:27:47','PESANAN : DP-02282','.','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-260531-0006','D','2026-05-31','13:27:47','TBC','PESANAN','DP-02282','23042879014','850000','23043729014','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-02282','2026-05-31','2026-05-31','13:27:47','PLG0011565','KUR','2026-06-21','kasirbip','2026-05-31 13:27:47','2.500','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-02283','SAL','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','850000','1900000','stngh putih glossy setngh comb doff semprot 3 zircon','sz 15.5 font arial','grf M I R','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-260531-0006','2026-05-31','2026-05-31 13:32:42','PESANAN : DP-02283','.','TBC','1520000','1520000');
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-260531-0007','D','2026-05-31','13:32:42','TBC','PESANAN','DP-02283','23043729014','1520000','23045249014','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-02283','2026-05-31','2026-05-31','13:32:42','PLG0011566','SAL','2026-07-01','kasirbip','2026-05-31 13:32:42','3.000','0','0','0','1520000','0','850000','1900000','1900000','380000');
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-02284','SAL','1','PLD','WED RING','','','3.500','','10.00','1','1200000','350000','0','850000','2075000','stngh putih glossy stngh comb doff semprot','dibuat tanpa permata','font arial grf A R','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-260531-0007','2026-05-31','2026-05-31 13:34:49','PESANAN : DP-02284','.','TBC','1660000','1660000');
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-260531-0008','D','2026-05-31','13:34:49','TBC','PESANAN','DP-02284','23045249014','1660000','23046909014','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-02284','2026-05-31','2026-05-31','13:34:49','PLG0011567','SAL','2026-07-01','kasirbip','2026-05-31 13:34:49','3.500','0','0','0','1660000','0','850000','2075000','2075000','415000');
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-02285','SULIS','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','1000000','1700000','putih glossy 14 zircon','sz 8 font vintage rotter grf Melani . . . Riva','express','140000','0','200000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0008','2026-05-31','2026-05-31 13:57:57','PESANAN : DP-02285','.','TBC','1672000','1672000');
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-260531-0009','D','2026-05-31','13:57:57','TBC','PESANAN','DP-02285','23046909014','1672000','23048581014','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-02285','2026-05-31','2026-05-31','13:57:57','PLG0011568','SULIS','2026-06-10','kasirbip','2026-05-31 13:57:57','2.000','0','0','0','1672000','0','1000000','2040000','2040000','368000');
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-02286','SULIS','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','800000','2200000','putih glossy comb doff semprot 1 zircon','sz 19 font vintage rotter grf Melani . . . Riva','express','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-260531-0009','2026-05-31','2026-05-31 14:00:28','PESANAN : DP-02286','.','TBC','1960000','1960000');
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-260531-0010','D','2026-05-31','14:00:28','TBC','PESANAN','DP-02286','23048581014','1960000','23050541014','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-02286','2026-05-31','2026-05-31','14:00:28','PLG0011569','SULIS','2026-06-10','kasirbip','2026-05-31 14:00:28','4.000','0','0','0','1960000','0','800000','2400000','2400000','440000');
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-260531-0002','kasirbip','1',' DP-02158DU','TOKO','DUPSN','PSGT-ZEBI-7-0','CINCIN EMAS ','','2.320','1','45.00','2610000','0','0','17800','4470000','0','0','0','4470000','KUR','00043833','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZEBI-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSGT-ZEBI-7-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-260531-0002','2026-05-31','2.320','2026-05-31','14:05:48','PLG0011570','4470000','4470000','0','4470000','0','kasirbip','2026-05-31 14:05:47','FJ-260531-0002','DP-02158','4390000');
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-31','FJ-260531-0002','2026-05-31','14:05:48','KUR','4470000','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-260531-0010','2026-05-31','2026-05-31 14:05:47','PENJUALAN : FJ-260531-0002','.','TBC','80000','80000','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-260531-0011','D','2026-05-31','14:05:48','TBC','PENJUALAN','FJ-260531-0002','23050541014','80000','23050621014','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='80000' WHERE no_faktur_jual='FJ-260531-0002' 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-260531-0003','kasirbip','1',' DP-02159DU','TOKO','DUPSN','PSPLT-ZEBE-28-0','CINCIN PALADIUM ','','1.990','1','17.00','447000','0','0','17800','1347000','0','0','0','1347000','KUR','00043789','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBE-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSPLT-ZEBE-28-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-260531-0003','2026-05-31','1.990','2026-05-31','14:06:47','PLG0011571','1347000','1347000','0','1347000','0','kasirbip','2026-05-31 14:06:46','FJ-260531-0003','DP-02159','1310000');
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-31','FJ-260531-0003','2026-05-31','14:06:47','KUR','1347000','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-260531-0011','2026-05-31','2026-05-31 14:06:46','PENJUALAN : FJ-260531-0003','.','TBC','37000','37000','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-260531-0012','D','2026-05-31','14:06:47','TBC','PENJUALAN','FJ-260531-0003','23050621014','37000','23050658014','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='37000' WHERE no_faktur_jual='FJ-260531-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','14:10:42');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','14:15:48');
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-260531-0004','sby','1',' 750K-17-00','TOKO','SBYPER','PSBY-ZEXE-64-0','CINCIN SILVER 925 ','','2.430','1','100.00','249000','0','0','17800','850000','0','0','0','850000','VAN','00043260','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-64-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-31' AND kode_barang='PSBY-ZEXE-64-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260531-0004','2026-05-31','2.430','2026-05-31','14:17:38','PLG0011572','850000','850000','0','850000','0','sby','2026-05-31 14:17:38','FJ-260531-0004','','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-31','FJ-260531-0004','2026-05-31','14:17:38','VAN','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-260531-0012','2026-05-31','2026-05-31 14:17:38','PENJUALAN : FJ-260531-0004','','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-260531-0013','D','2026-05-31','14:17:38','TBC','PENJUALAN','FJ-260531-0004','23050658014','850000','23051508014','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-260531-0004' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','14:19:03');
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-260531-0005','sby','1',' 800K-13-00','TOKO','SBYPER','PSBY-ZEXA-9-0','CINCIN SILVER 925 ','','2.050','1','100.00','210000','0','0','17800','900000','0','0','0','900000','VAN','00043031','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSBY-ZEXA-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' 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-260531-0005','2026-05-31','2.050','2026-05-31','14:28:20','PLG0011573','900000','900000','0','900000','0','sby','2026-05-31 14:28:20','FJ-260531-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-31','FJ-260531-0005','2026-05-31','14:28:20','VAN','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-260531-0013','2026-05-31','2026-05-31 14:28:20','PENJUALAN : FJ-260531-0005','','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-260531-0014','D','2026-05-31','14:28:20','TBC','PENJUALAN','FJ-260531-0005','23051508014','900000','23052408014','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-260531-0005' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','14:29:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','14:33:25');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260531-0006','kasirbip','1',' 800K-105-0','TOKO','DUPERBDG','LXPER-ZEBA-21-0','CINCIN SILVER 925 ','','1.420','1','100.00','145000','0','0','17800','900000','0','0','0','900000','PUT','00043700','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEBA-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='LXPER-ZEBA-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260531-0006','2026-05-31','1.420','2026-05-31','14:34:45','PLG0011574','900000','900000','0','900000','0','kasirbip','2026-05-31 14:34:45','FJ-260531-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-31','FJ-260531-0006','2026-05-31','14:34:45','PUT','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-260531-0014','2026-05-31','2026-05-31 14:34:45','PENJUALAN : FJ-260531-0006','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260531-0015','D','2026-05-31','14:34:45','TBC','PENJUALAN','FJ-260531-0006','23052408014','900000','23053308014','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-260531-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-260531-0007','kasirbip',' 1',' 800K-155-0','TOKO','DUPERBDG','LXPER-ZDXI-43-0','CINCIN SILVER 925 ','','3.320','1','100.00','339000','0','0','17800','950000','0','0','0','950000','PUT','00042437','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDXI-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.320',berat_jual_asli=berat_jual_asli+'3.320',stock_jual='1',berat_akhir=berat_akhir-'3.320',berat_akhir_asli=berat_akhir_asli-'3.320',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='LXPER-ZDXI-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260531-0007','2026-05-31','3.320','2026-05-31','14:34:45','PLG0011575','950000','950000','0','950000','0','kasirbip','2026-05-31 14:34:45','FJ-260531-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-31','FJ-260531-0007','2026-05-31','14:34:45','PUT','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260531-0015','2026-05-31','2026-05-31 14:34:45','PENJUALAN : FJ-260531-0007','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260531-0016','D','2026-05-31','14:34:45','TBC','PENJUALAN','FJ-260531-0007','23053308014','950000','23054258014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-260531-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-31 ','14:41:35');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0005';
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YFCX-14-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 ('PBDG-YFCX-14-0','00036815','00036815','CINCIN SILVER 925 ','CINCIN SILVER 925','','','87000','87000',' 150000','150000','Nagatech','2026-05-31 14:45:29');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-14-1466 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PBDG-YFCX-14-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-31 ','14:46:18');
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-260531-0008','kasirbip','1',' 700K-14-14','TOKO','BIPPER','PBDG-YFCX-14-0','CINCIN SILVER 925','','4.350','1','100.00','101000','0','0','17800','900000','0','0','0','900000','GIN','00036815','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFCX-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.350',berat_jual_asli=berat_jual_asli+'4.350',stock_jual='1',berat_akhir=berat_akhir-'4.350',berat_akhir_asli=berat_akhir_asli-'4.350',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PBDG-YFCX-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-260531-0008','2026-05-31','4.350','2026-05-31','14:47:22','PLG0011576','900000','900000','0','900000','0','kasirbip','2026-05-31 14:47:21','FJ-260531-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-31','FJ-260531-0008','2026-05-31','14:47:22','GIN','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260531-0016','2026-05-31','2026-05-31 14:47:21','PENJUALAN : FJ-260531-0008','.','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-260531-0017','D','2026-05-31','14:47:22','TBC','PENJUALAN','FJ-260531-0008','23054258014','900000','23055158014','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-260531-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-260531-0009','kasirbip','1',' PBDG-00628','TOKO','BIPPER','PBDG-XLBE-24-0','CINCIN PERAK PBDG-00628 ','','2.470','1','100.00','230000','150000','0','17800','950000','0','0','0','950000','SULIS','00032876','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-XLBE-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.470',berat_jual_asli=berat_jual_asli+'2.470',stock_jual='1',berat_akhir=berat_akhir-'2.470',berat_akhir_asli=berat_akhir_asli-'2.470',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PBDG-XLBE-24-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-260531-0009','2026-05-31','2.470','2026-05-31','14:57:01','PLG0011577','950000','950000','0','950000','0','kasirbip','2026-05-31 14:57:00','FJ-260531-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-31','FJ-260531-0009','2026-05-31','14:57:01','SULIS','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260531-0017','2026-05-31','2026-05-31 14:57:00','PENJUALAN : FJ-260531-0009','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260531-0018','D','2026-05-31','14:57:01','TBC','PENJUALAN','FJ-260531-0009','23055158014','950000','23056108014','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='950000' WHERE no_faktur_jual='FJ-260531-0009' 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-260531-0010','kasirbip',' 1',' 1.1K-9-253','TOKO','BIPPER','PBDG-ZDBH-24-0','CINCIN SILVER 925 ','','1.940','1','100.00','198000','0','0','17800','1100000','0','0','0','1100000','SULIS','00042840','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDBH-24-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-31' AND kode_barang='PBDG-ZDBH-24-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-260531-0010','2026-05-31','1.940','2026-05-31','14:57:01','PLG0011578','1100000','1100000','0','1100000','0','kasirbip','2026-05-31 14:57:00','FJ-260531-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-31','FJ-260531-0010','2026-05-31','14:57:01','SULIS','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-260531-0018','2026-05-31','2026-05-31 14:57:00','PENJUALAN : FJ-260531-0010','.','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-260531-0019','D','2026-05-31','14:57:01','TBC','PENJUALAN','FJ-260531-0010','23056108014','1100000','23057208014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2050000' WHERE no_faktur_jual='FJ-260531-0010' 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-02097','SULIS','1','SEPASANG SILVER','CWE PUTIH GLOSY CWO PUTIH DOFF AMPLASS FONT BRUSH CSRIPT','4.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-02097','2026-05-31','2026-05-31','14:59:21','PLG0011579','kasirbip','2026-06-15','kasirbip','2026-05-31 14:59:21','4.000','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0010';
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-02287','GIN','1','PLD','WED RING','','','3.500','','25.00','1','1200000','550000','0','750000','2675000','putih glosy dibuat pake permata 1 zirkon','sz 18.5 font vintage rotter','(di buat jangan kopong) grf Calila','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0019','2026-05-31','2026-05-31 15:22:43','PESANAN : DP-02287','.','TBC','2140000','2140000');
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-260531-0020','D','2026-05-31','15:22:43','TBC','PESANAN','DP-02287','23057208014','2140000','23059348014','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-02287','2026-05-31','2026-05-31','15:22:43','PLG0011580','GIN','2026-07-01','kasirbip','2026-05-31 15:22:43','3.500','0','0','0','2140000','0','750000','2675000','2675000','535000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-31 ','15:24:18');
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-260531-0011','kasirbip','1',' DP-02139BI','TOKO','BIPPSN','PSPLT-ZEBF-12-0','CINCIN PALADIUM ','','2.580','1','17.00','580000','0','0','17800','1624000','0','0','0','1624000','SAL','00043802','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBF-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.580',berat_jual_asli=berat_jual_asli+'2.580',stock_jual='1',berat_akhir=berat_akhir-'2.580',berat_akhir_asli=berat_akhir_asli-'2.580',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSPLT-ZEBF-12-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-260531-0011','2026-05-31','2.580','2026-05-31','15:32:10','PLG0011581','1624000','1624000','0','1624000','0','kasirbip','2026-05-31 15:32:10','FJ-260531-0011','DP-02139','1420000');
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-31','FJ-260531-0011','2026-05-31','15:32:10','SAL','1624000','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-260531-0020','2026-05-31','2026-05-31 15:32:10','PENJUALAN : FJ-260531-0011','.','TBC','204000','204000','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-260531-0021','D','2026-05-31','15:32:10','TBC','PENJUALAN','FJ-260531-0011','23059348014','204000','23059552014','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='204000' WHERE no_faktur_jual='FJ-260531-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-260531-0012','kasirbip',' 1',' DP-02140BI','TOKO','BIPPSN','PSPLT-ZEBI-4-0','CINCIN PALADIUM ','','1.490','1','17.00','335000','0','0','17800','1247000','0','0','0','1247000','SAL','00043830','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBI-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.490',berat_jual_asli=berat_jual_asli+'1.490',stock_jual='1',berat_akhir=berat_akhir-'1.490',berat_akhir_asli=berat_akhir_asli-'1.490',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSPLT-ZEBI-4-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-260531-0012','2026-05-31','1.490','2026-05-31','15:32:10','PLG0011582','1247000','1247000','0','1247000','0','kasirbip','2026-05-31 15:32:10','FJ-260531-0011','DP-02140','1020000');
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-31','FJ-260531-0012','2026-05-31','15:32:10','SAL','1247000','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-260531-0021','2026-05-31','2026-05-31 15:32:10','PENJUALAN : FJ-260531-0012','.','TBC','227000','227000','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-260531-0022','D','2026-05-31','15:32:10','TBC','PENJUALAN','FJ-260531-0012','23059552014','227000','23059779014','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='431000' WHERE no_faktur_jual='FJ-260531-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0012';
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-260531-0013','kasirbip','1',' 750K-8-233','TOKO','BIPPER','PBDG-ZCAA-28-0','CINCIN SILVER 925 ','','1.870','1','100.00','191000','0','0','17800','850000','0','0','0','850000','GIN','00042264','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCAA-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PBDG-ZCAA-28-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-260531-0013','2026-05-31','1.870','2026-05-31','15:38:27','PLG0011583','850000','850000','0','850000','0','kasirbip','2026-05-31 15:38:27','FJ-260531-0013','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-31','FJ-260531-0013','2026-05-31','15:38:27','GIN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260531-0022','2026-05-31','2026-05-31 15:38:27','PENJUALAN : FJ-260531-0013','.','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-260531-0023','D','2026-05-31','15:38:27','TBC','PENJUALAN','FJ-260531-0013','23059779014','850000','23060629014','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-260531-0013' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','15:38:59');
DELETE FROM tm_berlian WHERE kode_barang='PBSD-YGBH-8-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 ('PBSD-YGBH-8-0','00037590','00037590','CINCIN SILVER 925 ','CINCIN SILVER 925','','','92000','92000',' 150000','150000','kasir','2026-05-31 15:39:46');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-20-00053 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PBSD-YGBH-8-0' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260531-0014','kasir','1',' 700K-20-00','TOKO','MMPER','PBSD-YGBH-8-0','CINCIN SILVER 925','','4.580','1','100.00','94000','0','0','17800','800000','0','0','0','800000','ELLA','00037590','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBH-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.580',berat_jual_asli=berat_jual_asli+'4.580',stock_jual='1',berat_akhir=berat_akhir-'4.580',berat_akhir_asli=berat_akhir_asli-'4.580',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PBSD-YGBH-8-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-260531-0014','2026-05-31','4.580','2026-05-31','15:42:28','PLG0011584','800000','800000','0','800000','0','kasir','2026-05-31 15:42:27','FJ-260531-0014','','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-31','FJ-260531-0014','2026-05-31','15:42:28','ELLA','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-260531-0023','2026-05-31','2026-05-31 15:42:27','PENJUALAN : FJ-260531-0014','0','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-260531-0024','D','2026-05-31','15:42:28','TBC','PENJUALAN','FJ-260531-0014','23060629014','800000','23061429014','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='800000' WHERE no_faktur_jual='FJ-260531-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-260531-0015','kasir',' 1',' 800K-14-00','TOKO','MMPER','PBSD-YGCX-28-0','CINCIN SILVER 925 ','','1.870','1','100.00','39000','0','0','17800','900000','0','0','0','900000','ELLA','00037767','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGCX-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PBSD-YGCX-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-260531-0015','2026-05-31','1.870','2026-05-31','15:42:28','PLG0011585','900000','900000','0','900000','0','kasir','2026-05-31 15:42:27','FJ-260531-0014','','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-31','FJ-260531-0015','2026-05-31','15:42:28','ELLA','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-260531-0024','2026-05-31','2026-05-31 15:42:27','PENJUALAN : FJ-260531-0015','0','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-260531-0025','D','2026-05-31','15:42:28','TBC','PENJUALAN','FJ-260531-0015','23061429014','900000','23062329014','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='1700000' WHERE no_faktur_jual='FJ-260531-0015' 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-02098','ELLA','1','WEDDING RING','CWE 18 GRF ILHAM CWO 24 GRF VINA CROM ULANG PUTIH YANG CWO HAPUS GRAFIR LUAR','6.450','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-02098','2026-05-31','2026-05-31','15:45:33','PLG0011586','kasir','2026-06-03','kasir','2026-05-31 15:45:33','6.450','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-02288','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1050000','0','1050000','putih glossy 27 zirkon','sz 12.5 font vladimir grf Dendi . . .','express','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-260531-0025','2026-05-31','2026-05-31 15:47:32','PESANAN : DP-02288','.','TBC','1150000','1150000');
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-260531-0026','D','2026-05-31','15:47:32','TBC','PESANAN','DP-02288','23062329014','1150000','23063479014','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-02288','2026-05-31','2026-05-31','15:47:32','PLG0011587','SAL','2026-06-17','kasirbip','2026-05-31 15:47:32','2.000','0','0','0','1150000','0','0','1150000','1150000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02099','ASRI','1','PLD','RESIZE NAIK 1 NOMER CROM ULANG PUTIH DOFF SEMPROT BAGIAN SILANGNYA','4.180','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-02099','2026-05-31','2026-05-31','15:47:49','PLG0011588','kasir','2026-06-03','kasir','2026-05-31 15:47:49','4.180','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-02289','SAL','1','PER','WEDE RING','','','2.000','','925.00','1','100000','0','900000','0','900000','putih glosy doff semprot 1 zirkon','sz 15 font vladimir grf Annisa . . .','expres','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-260531-0026','2026-05-31','2026-05-31 15:49:20','PESANAN : DP-02289','.','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-260531-0027','D','2026-05-31','15:49:20','TBC','PESANAN','DP-02289','23063479014','1000000','23064479014','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-02289','2026-05-31','2026-05-31','15:49:20','PLG0011589','SAL','2026-06-17','kasirbip','2026-05-31 15:49:20','2.000','0','0','0','1000000','0','0','1000000','1000000','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-260531-0016','kasirbip','1',' DP-02066BI','TOKO','BIPPSN','PSPLT-ZEBX-29-0','CINCIN PALADIUM ','','2.970','1','17.00','667000','0','0','17800','1591000','0','0','0','1591000','SULIS','00043674','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBX-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSPLT-ZEBX-29-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-260531-0016','2026-05-31','2.970','2026-05-31','15:51:18','PLG0011590','1591000','1591000','0','1591000','0','kasirbip','2026-05-31 15:51:17','FJ-260531-0016','DP-02066','1280000');
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-31','FJ-260531-0016','2026-05-31','15:51:18','SULIS','1591000','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-260531-0027','2026-05-31','2026-05-31 15:51:17','PENJUALAN : FJ-260531-0016','.','TBC','311000','311000','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-260531-0028','D','2026-05-31','15:51:18','TBC','PENJUALAN','FJ-260531-0016','23064479014','311000','23064790014','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='311000' WHERE no_faktur_jual='FJ-260531-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-260531-0017','kasirbip',' 1',' DP-02065BI','TOKO','BIPPSN','PSPLT-ZEBF-5-0','CINCIN PALADIUM ','','2.390','1','17.00','537000','0','0','17800','1417000','0','0','0','1417000','SULIS','00043795','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBF-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSPLT-ZEBF-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-260531-0017','2026-05-31','2.390','2026-05-31','15:51:18','PLG0011591','1417000','1417000','0','1417000','0','kasirbip','2026-05-31 15:51:17','FJ-260531-0016','DP-02065','1040000');
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-31','FJ-260531-0017','2026-05-31','15:51:18','SULIS','1417000','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-260531-0028','2026-05-31','2026-05-31 15:51:17','PENJUALAN : FJ-260531-0017','.','TBC','377000','377000','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-260531-0029','D','2026-05-31','15:51:18','TBC','PENJUALAN','FJ-260531-0017','23064790014','377000','23065167014','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='688000' WHERE no_faktur_jual='FJ-260531-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-260531-0018','kasirbip','1',' 700K-17-00','TOKO','DUPERBDG','LXPER-ZBBC-11-0','CINCIN SILVER 925 ','','1.820','1','100.00','186000','0','0','17800','800000','0','0','0','800000','KUR','00041672','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBC-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='LXPER-ZBBC-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260531-0018','2026-05-31','1.820','2026-05-31','16:25:13','PLG0011592','800000','800000','0','800000','0','kasirbip','2026-05-31 16:25:12','FJ-260531-0018','','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-31','FJ-260531-0018','2026-05-31','16:25:13','KUR','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-260531-0029','2026-05-31','2026-05-31 16:25:12','PENJUALAN : FJ-260531-0018','.','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-260531-0030','D','2026-05-31','16:25:13','TBC','PENJUALAN','FJ-260531-0018','23065167014','800000','23065967014','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-260531-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0017';
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-02290','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','rose gold glosy comb doff semprot glosy 2 zircon','sz 20.5 font vintage rotter','grf Andi','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0030','2026-05-31','2026-05-31 17:16:39','PESANAN : DP-02290','.','TBC','1440000','1440000');
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-260531-0031','D','2026-05-31','17:16:39','TBC','PESANAN','DP-02290','23065967014','1440000','23067407014','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-02290','2026-05-31','2026-05-31','17:16:39','PLG0011593','SULIS','2026-07-01','kasirbip','2026-05-31 17:16:39','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
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-02291','SULIS','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1000000','0','1000000','putih doff amplas comb rosegold glosy','sz 22 font vintage rotter','(dibuat pake permata) grf Eka','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0031','2026-05-31','2026-05-31 17:20:21','PESANAN : DP-02291','.','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-260531-0032','D','2026-05-31','17:20:21','TBC','PESANAN','DP-02291','23067407014','1000000','23068407014','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-02291','2026-05-31','2026-05-31','17:20:21','PLG0011594','SULIS','2026-07-01','kasirbip','2026-05-31 17:20:21','3.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-02292','SAL','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','800000','2200000','putih glossy comb doff amplas sz 17','font vintage rotter grf Revanissa','express','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-260531-0032','2026-05-31','2026-05-31 17:23:57','PESANAN : DP-02292','.','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-260531-0033','D','2026-05-31','17:23:57','TBC','PESANAN','DP-02292','23068407014','1840000','23070247014','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-02292','2026-05-31','2026-05-31','17:23:57','PLG0011595','SAL','2026-06-17','kasirbip','2026-05-31 17:23:57','4.000','0','0','0','1840000','0','800000','2300000','2300000','460000');
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-02293','SAL','1','GOLD','WED RING','','','2.500','','75.00','1','2420000','2400000','0','950000','6950000','putih glossy 23 zirkon sz 14','font vintage rotter grf Willy','express','230000','0','100000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0033','2026-05-31','2026-05-31 17:26:54','PESANAN : DP-02293','.','TBC','5824000','5824000');
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-260531-0034','D','2026-05-31','17:26:54','TBC','PESANAN','DP-02293','23070247014','5824000','23076071014','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-02293','2026-05-31','2026-05-31','17:26:54','PLG0011596','SAL','2026-06-17','kasirbip','2026-05-31 17:26:54','2.500','0','0','0','5824000','0','950000','7280000','7280000','1456000');
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-260531-0019','kasir','1',' DP-02137MM','TOKO','MMPSN','PSGT-ZEBH-1-0','CINCIN EMAS ','','3.200','1','83.00','6638000','0','0','17800','8060000','0','0','0','8060000','ALIKA','00043806','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZEBH-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSGT-ZEBH-1-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-260531-0019','2026-05-31','3.200','2026-05-31','17:27:07','PLG0011597','8060000','8060000','0','8060000','0','kasir','2026-05-31 17:27:07','FJ-260531-0019','DP-02137','6080000');
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-31','FJ-260531-0019','2026-05-31','17:27:07','ALIKA','8060000','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-260531-0034','2026-05-31','2026-05-31 17:27:07','PENJUALAN : FJ-260531-0019','0','TBC','1980000','1980000','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-260531-0035','D','2026-05-31','17:27:07','TBC','PENJUALAN','FJ-260531-0019','23076071014','1980000','23078051014','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='1980000' WHERE no_faktur_jual='FJ-260531-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0019';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02100','KUR','1','WEDD RING','CWE CROM ULANG GRF HARI SUKMALA COWO CROM ULANG DEA AMORITA RESIZE 19 FONT LOVELO KAPITAL','4.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-260531-0035','2026-05-31','2026-05-31 17:34:45','SERVICE : SV-02100','.','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-260531-0036','D','2026-05-31','17:34:45','TBC','SERVICE','SV-02100','23078051014','100000','23078151014','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-02100','2026-05-31','2026-05-31','17:34:45','PLG0011598','kasirbip','2026-06-15','kasirbip','2026-05-31 17:34:45','4.000','0','0','0','100000','0','100000','100000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-31 ','17:35:05');
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-260531-0020','kasir','1',' TFGRR75-87','TOKO','TFGLR','TFGRR-YJXH-24-0','THIFA GELANG RANTAI RG ','','3.200','1','87.00','6873000','0','0','17800','7000000','0','0','0','7000000','FIR','00039113','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YJXH-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='TFGRR-YJXH-24-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-260531-0020','2026-05-31','3.200','2026-05-31','17:40:48','PLG0011599','7000000','7000000','0','7000000','0','kasir','2026-05-31 17:40:48','FJ-260531-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-31','FJ-260531-0020','2026-05-31','17:40:48','FIR','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-260531-0036','2026-05-31','2026-05-31 17:40:48','PENJUALAN : FJ-260531-0020','.','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-260531-0037','D','2026-05-31','17:40:48','TBC','PENJUALAN','FJ-260531-0020','23078151014','7000000','23085151014','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-260531-0020' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260531-0021','kasir',' 1',' TFGRR75-81','TOKO','TFGLR','TFGRR-YLXC-49-0','THIFA GELANG RANTAI RG ','','6.640','1','81.00','13277000','0','0','17800','13950000','0','0','0','13950000','FIR','00040172','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YLXC-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.640',berat_jual_asli=berat_jual_asli+'6.640',stock_jual='1',berat_akhir=berat_akhir-'6.640',berat_akhir_asli=berat_akhir_asli-'6.640',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='TFGRR-YLXC-49-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-260531-0021','2026-05-31','6.640','2026-05-31','17:40:48','PLG0011600','13950000','13950000','0','13950000','0','kasir','2026-05-31 17:40:48','FJ-260531-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-31','FJ-260531-0021','2026-05-31','17:40:48','FIR','13950000','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-260531-0037','2026-05-31','2026-05-31 17:40:48','PENJUALAN : FJ-260531-0021','.','TBC','13950000','13950000','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-260531-0038','D','2026-05-31','17:40:48','TBC','PENJUALAN','FJ-260531-0021','23085151014','13950000','23099101014','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='20950000' WHERE no_faktur_jual='FJ-260531-0021' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0021';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02101','SAL','1','SEPASANG SILVER','CWE PUTIH GLOSSY CWO PUTIH GLOSSY COMB DOFF SEMPROT FONT','3.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-02101','2026-05-31','2026-05-31','17:41:04','PLG0011601','kasirbip','2026-06-17','kasirbip','2026-05-31 17:41:04','3.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-31 ','17:41:23');
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-02294','PUT','1','PER','WEDD RING PROMO','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cewe 8 SR 02 grf Ricky love Naila','sz cwo 18 YL 01 grf Naila love Ricky','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-260531-0038','2026-05-31','2026-05-31 18:09:05','PESANAN : DP-02294','.','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-260531-0039','D','2026-05-31','18:09:05','TBC','PESANAN','DP-02294','23099101014','950000','23100051014','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-02294','2026-05-31','2026-05-31','18:09:05','PLG0011602','PUT','2026-06-20','kasirbip','2026-05-31 18:09:05','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','18:49:26');
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-02295','DIL','1','PLD','WEDD RING','','','2.500','','10.00','1','1200000','350000','0','900000','1775000','PERMATA ZIRCON 9 BUTIR','SIZE 12 . GRF: Milzam ?? 10.10.26','crom rose gold','90000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0039','2026-05-31','2026-05-31 18:54:07','PESANAN : DP-02295','-','TBC','1300000','1300000');
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-260531-0040','D','2026-05-31','18:54:07','TBC','PESANAN','DP-02295','23100051014','1300000','23101351014','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-02295','2026-05-31','2026-05-31','18:54:07','PLG0011603','DIL','2026-06-28','sby','2026-05-31 18:54:07','2.500','0','0','0','1300000','0','900000','1865000','1865000','565000');
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-02296','DIL','1','PLD','WEDD RING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','SIZE 28.5 GRF: Luluk ?? 10.10.26','crom putih doff mix rose gold','','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-260531-0040','2026-05-31','2026-05-31 18:58:49','PESANAN : DP-02296','-','TBC','1300000','1300000');
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-260531-0041','D','2026-05-31','18:58:49','TBC','PESANAN','DP-02296','23101351014','1300000','23102651014','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-02296','2026-05-31','2026-05-31','18:58:49','PLG0011604','DIL','2026-06-28','sby','2026-05-31 18:58:49','3.500','0','0','0','1300000','0','750000','1975000','1975000','675000');
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-260531-0022','kasir','1',' DP-02192MM','TOKO','MMPSN','PSPRT-ZEBI-3-0','CINCIN PERAK YL-01 ','','3.140','1','100.00','321000','0','0','17800','850000','0','0','0','850000','GLA','00043829','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBI-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.140',berat_jual_asli=berat_jual_asli+'3.140',stock_jual='1',berat_akhir=berat_akhir-'3.140',berat_akhir_asli=berat_akhir_asli-'3.140',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSPRT-ZEBI-3-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-260531-0022','2026-05-31','3.140','2026-05-31','19:03:05','PLG0011605','850000','850000','0','850000','0','kasir','2026-05-31 19:03:04','FJ-260531-0022','DP-02192','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-31','FJ-260531-0022','2026-05-31','19:03:05','GLA','850000','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-260531-0022' 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-02102','GLA','1','WEDING RING','CWE SIZE 10 CWO SIZE 21 GRF JGN HILANG','1.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-02102','2026-05-31','2026-05-31','19:09:59','PLG0011606','kasir','2026-07-03','kasir','2026-05-31 19:09:59','1.000','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0022';
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-02297','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','1 zircon crom putih glosy komb gold glosy','sz 14.5','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0041','2026-05-31','2026-05-31 19:21:35','PESANAN : DP-02297','.','TBC','1400000','1400000');
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-260531-0042','D','2026-05-31','19:21:35','TBC','PESANAN','DP-02297','23102651014','1400000','23104051014','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-02297','2026-05-31','2026-05-31','19:21:35','PLG0011607','SULIS','2026-06-30','kasirbip','2026-05-31 19:21:35','3.000','0','0','0','1400000','0','700000','1750000','1750000','350000');
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-02298','DIL','1','PLD','WEDD RING','','','5.000','','10.00','1','1200000','350000','0','800000','2550000','PERMATA ZIRCON 3 BUTIR','SIZE 17 GRF: T & Y (TIMES NEW ROMAN)','CROM PUTIH DOFF MIX ROSE GOLD DALAM DAN PINGGIR','30000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0042','2026-05-31','2026-05-31 19:25:58','PESANAN : DP-02298','-','TBC','1800000','1800000');
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-260531-0043','D','2026-05-31','19:25:58','TBC','PESANAN','DP-02298','23104051014','1800000','23105851014','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-02298','2026-05-31','2026-05-31','19:25:58','PLG0011608','DIL','2026-06-28','sby','2026-05-31 19:25:58','5.000','0','0','0','1800000','0','800000','2580000','2580000','780000');
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-02299','DIL','1','PLD','WEDD RING','','','2.500','','10.00','1','1200000','350000','0','1200000','2075000','PERMATA ZIRCON 14 BUTIR','SIZE 7.5 GRF : Y & T (TIMES NEW ROMAN)','CROM ROSE GOLD','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-260531-0043','2026-05-31','2026-05-31 19:29:35','PESANAN : DP-02299','-','TBC','1500000','1500000');
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-260531-0044','D','2026-05-31','19:29:35','TBC','PESANAN','DP-02299','23105851014','1500000','23107351014','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-02299','2026-05-31','2026-05-31','19:29:35','PLG0011609','DIL','2026-06-28','sby','2026-05-31 19:29:35','2.500','0','0','0','1500000','0','1200000','2215000','2215000','715000');
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-02300','DIL','1','PER','SEPAKET 950K','','','1.000','','925.00','1','100000','0','950000','0','950000','SIZE WANITA 10.5 GRF : Levil ?? Finer (vintage)','SIZE PRIA 18 GRF : Finer ?? Levil (vintage)','crom putih doff mix glossy','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-260531-0044','2026-05-31','2026-05-31 19:37:10','PESANAN : DP-02300','-','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-260531-0045','D','2026-05-31','19:37:10','TBC','PESANAN','DP-02300','23107351014','950000','23108301014','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-02300','2026-05-31','2026-05-31','19:37:10','PLG0011610','DIL','2026-06-22','sby','2026-05-31 19:37:10','1.000','0','0','0','950000','0','0','950000','950000','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-02301','DIL','1','PLD','WEDD RING','','','5.000','','10.00','1','1200000','350000','0','800000','2550000','PERMATA 1 BUTIR','SIZE 23.5 GRF: Ekha April ?? (vintage)','crom putih doff mix glossy','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0045','2026-05-31','2026-05-31 19:53:24','PESANAN : DP-02301','-','TBC','1700000','1700000');
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-260531-0046','D','2026-05-31','19:53:24','TBC','PESANAN','DP-02301','23108301014','1700000','23110001014','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-02301','2026-05-31','2026-05-31','19:53:24','PLG0011611','DIL','2026-06-30','sby','2026-05-31 19:53:24','5.000','0','0','0','1700000','0','800000','2560000','2560000','860000');
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-02302','DIL','1','GOLD','WEDD RING','','','2.500','','37.50','1','2420000','1500000','0','950000','4700000','PERMATA ZIRCON 23 BUTIR','SIZE 13.5 GRF : Wahyudi ?? (vintage)','gold','230000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0046','2026-05-31','2026-05-31 19:57:25','PESANAN : DP-02302','-','TBC','3400000','3400000');
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-260531-0047','D','2026-05-31','19:57:25','TBC','PESANAN','DP-02302','23110001014','3400000','23113401014','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-02302','2026-05-31','2026-05-31','19:57:25','PLG0011612','DIL','2026-06-30','sby','2026-05-31 19:57:25','2.500','0','0','0','3400000','0','950000','4930000','4930000','1530000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','19:59:22');
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-260531-0023','kasir','1',' DP-02102MM','TOKO','MMPSN','PSPLT-ZEBA-6-0','CINCIN PALADIUM YL-10 ','','3.350','1','17.00','752000','0','0','17800','1705000','0','0','0','1705000','ALIKA','00043685','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBA-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.350',berat_jual_asli=berat_jual_asli+'3.350',stock_jual='1',berat_akhir=berat_akhir-'3.350',berat_akhir_asli=berat_akhir_asli-'3.350',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSPLT-ZEBA-6-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-260531-0023','2026-05-31','3.350','2026-05-31','20:07:50','PLG0011613','1705000','1705000','0','1705000','0','kasir','2026-05-31 20:07:49','FJ-260531-0023','DP-02102','1000000');
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-31','FJ-260531-0023','2026-05-31','20:07:50','ALIKA','1705000','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-260531-0047','2026-05-31','2026-05-31 20:07:49','PENJUALAN : FJ-260531-0023','.','TBC','1705000','1705000','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-260531-0048','D','2026-05-31','20:07:50','TBC','PENJUALAN','FJ-260531-0023','23113401014','1705000','23115106014','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='1705000' WHERE no_faktur_jual='FJ-260531-0023' 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-260531-0024','kasir',' 1',' DP-02103MM','TOKO','MMPSN','PSGT-ZEBI-43-0','CINCIN EMAS ','','2.600','1','57.00','3704000','0','0','17800','6150000','0','0','0','6150000','ALIKA','00043869','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZEBI-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PSGT-ZEBI-43-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-260531-0024','2026-05-31','2.600','2026-05-31','20:07:50','PLG0011614','6150000','6150000','0','6150000','0','kasir','2026-05-31 20:07:49','FJ-260531-0023','DP-02103','3000000');
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-31','FJ-260531-0024','2026-05-31','20:07:50','ALIKA','6150000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1705000' WHERE no_faktur_jual='FJ-260531-0024' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','20:08:00');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0024';
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-260531-0025','kasir','1',' 900K-16-75','TOKO','MMPER','PMM-ZAXI-44-0','CINCIN SILVER 925 ','','1.940','1','100.00','119000','0','0','17800','1000000','0','0','0','1000000','ALIKA','00040821','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZAXI-44-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-31' AND kode_barang='PMM-ZAXI-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-260531-0025','2026-05-31','1.940','2026-05-31','20:18:10','PLG0011615','1000000','1000000','0','1000000','0','kasir','2026-05-31 20:18:09','FJ-260531-0025','','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-31','FJ-260531-0025','2026-05-31','20:18:10','ALIKA','1000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260531-0048','2026-05-31','2026-05-31 20:18:09','PENJUALAN : FJ-260531-0025','.','TBC','1000000','1000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260531-0049','D','2026-05-31','20:18:10','TBC','PENJUALAN','FJ-260531-0025','23115106014','1000000','23116106014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-260531-0025' 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-260531-0026','kasir',' 1',' 700K-18-00','TOKO','MMPER','PBSD-YGBI-74-0','CINCIN SILVER 925 ','','2.770','1','100.00','57000','0','0','17800','800000','0','0','0','800000','ALIKA','00037710','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBI-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.770',berat_jual_asli=berat_jual_asli+'2.770',stock_jual='1',berat_akhir=berat_akhir-'2.770',berat_akhir_asli=berat_akhir_asli-'2.770',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PBSD-YGBI-74-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-260531-0026','2026-05-31','2.770','2026-05-31','20:18:10','PLG0011616','800000','800000','0','800000','0','kasir','2026-05-31 20:18:09','FJ-260531-0025','','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-31','FJ-260531-0026','2026-05-31','20:18:10','ALIKA','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-260531-0049','2026-05-31','2026-05-31 20:18:09','PENJUALAN : FJ-260531-0026','.','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-260531-0050','D','2026-05-31','20:18:10','TBC','PENJUALAN','FJ-260531-0026','23116106014','800000','23116906014','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='1800000' WHERE no_faktur_jual='FJ-260531-0026' 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-260531-0027','kasirbip','1',' 950K-9-254','TOKO','BIPPER','PBDG-ZEXF-28-0','CINCIN SILVER 925 ','','1.440','1','100.00','147000','0','0','17800','1050000','0','0','0','1050000','GIN','00043322','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEXF-28-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-31' AND kode_barang='PBDG-ZEXF-28-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-260531-0027','2026-05-31','1.440','2026-05-31','20:25:46','PLG0011617','1050000','1050000','0','1050000','0','kasirbip','2026-05-31 20:25:45','FJ-260531-0027','','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-31','FJ-260531-0027','2026-05-31','20:25:46','GIN','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-260531-0050','2026-05-31','2026-05-31 20:25:45','PENJUALAN : FJ-260531-0027','.','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-260531-0051','D','2026-05-31','20:25:46','TBC','PENJUALAN','FJ-260531-0027','23116906014','1050000','23117956014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1050000' WHERE no_faktur_jual='FJ-260531-0027' 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-260531-0028','kasirbip',' 1',' 750K-16-24','TOKO','BIPPER','PBDG-ZDAX-19-0','CINCIN SILVER 925 ','','1.620','1','100.00','166000','0','0','17800','850000','0','0','0','850000','GIN','00042456','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAX-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PBDG-ZDAX-19-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-260531-0028','2026-05-31','1.620','2026-05-31','20:25:46','PLG0011618','850000','850000','0','850000','0','kasirbip','2026-05-31 20:25:45','FJ-260531-0027','','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-31','FJ-260531-0028','2026-05-31','20:25:46','GIN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260531-0051','2026-05-31','2026-05-31 20:25:45','PENJUALAN : FJ-260531-0028','.','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-260531-0052','D','2026-05-31','20:25:46','TBC','PENJUALAN','FJ-260531-0028','23117956014','850000','23118806014','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='1900000' WHERE no_faktur_jual='FJ-260531-0028' 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-02303','VAN','1','PER','CINCIN SEPAKET 850K','','','1.000','','925.00','1','100000','0','850000','0','850000','PERMATA ZIRCON 1 BUTIR','(SIZE MENYUSUL) CROM PUTIH','GRF WANITA : Zidan . Pria : Queen (times new roman)','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-260531-0052','2026-05-31','2026-05-31 20:26:14','PESANAN : DP-02303','-','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-260531-0053','D','2026-05-31','20:26:14','TBC','PESANAN','DP-02303','23118806014','850000','23119656014','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-02303','2026-05-31','2026-05-31','20:26:14','PLG0011619','VAN','2026-06-26','sby','2026-05-31 20:26:14','1.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0027';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02103','RIRIN','1','WEDDING RING','SIZE CWE 12 5 GRF AJIE SIZE CWO 17 5 GRF OVIE CWE CROM PUTIH CWO CROM PUTIH DOFF SEMPROT HITAM','2.860','2','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-02103','2026-05-31','2026-05-31','20:35:28','PLG0011620','kasir','2026-06-03','kasir','2026-05-31 20:35:28','2.860','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-260531-0029','kasir','1',' 700K-14-70','TOKO','MMPER','PMM-YLAX-132-0','CINCIN SILVER 925 ','','1.620','1','100.00','100000','0','0','17800','850000','0','0','0','850000','RIRIN','00040534','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YLAX-132-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PMM-YLAX-132-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-260531-0029','2026-05-31','1.620','2026-05-31','20:38:13','PLG0011621','850000','850000','0','850000','0','kasir','2026-05-31 20:38:13','FJ-260531-0029','','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-31','FJ-260531-0029','2026-05-31','20:38:13','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-260531-0053','2026-05-31','2026-05-31 20:38:13','PENJUALAN : FJ-260531-0029','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-260531-0054','D','2026-05-31','20:38:13','TBC','PENJUALAN','FJ-260531-0029','23119656014','850000','23120506014','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-260531-0029' 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-260531-0030','kasir',' 1',' 800K-145-0','TOKO','MMPER','LXPER-ZCXB-30-0','CINCIN SILVER 925 ','','1.240','1','100.00','127000','0','0','17800','950000','0','0','0','950000','RIRIN','00042091','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZCXB-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.240',berat_jual_asli=berat_jual_asli+'1.240',stock_jual='1',berat_akhir=berat_akhir-'1.240',berat_akhir_asli=berat_akhir_asli-'1.240',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='LXPER-ZCXB-30-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-260531-0030','2026-05-31','1.240','2026-05-31','20:38:13','PLG0011622','950000','950000','0','950000','0','kasir','2026-05-31 20:38:13','FJ-260531-0029','','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-31','FJ-260531-0030','2026-05-31','20:38:13','RIRIN','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260531-0054','2026-05-31','2026-05-31 20:38:13','PENJUALAN : FJ-260531-0030','0','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260531-0055','D','2026-05-31','20:38:13','TBC','PENJUALAN','FJ-260531-0030','23120506014','950000','23121456014','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='1800000' WHERE no_faktur_jual='FJ-260531-0030' 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-260531-0031','kasirbip','1',' 800K-12-00','TOKO','DUPERBDG','LXPER-ZCXB-45-0','CINCIN SILVER 925 ','','1.120','1','100.00','115000','0','0','17800','900000','0','0','0','900000','KUR','00042106','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZCXB-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='LXPER-ZCXB-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260531-0031','2026-05-31','1.120','2026-05-31','20:39:28','PLG0011623','900000','900000','0','900000','0','kasirbip','2026-05-31 20:39:27','FJ-260531-0031','','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-31','FJ-260531-0031','2026-05-31','20:39:28','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-260531-0055','2026-05-31','2026-05-31 20:39:27','PENJUALAN : FJ-260531-0031','.','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-260531-0056','D','2026-05-31','20:39:28','TBC','PENJUALAN','FJ-260531-0031','23121456014','900000','23122356014','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-260531-0031' 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-260531-0032','kasirbip',' 1',' 750K-14-00','TOKO','DUPERBDG','LXPER-ZDAE-17-0','CINCIN SILVER 925 ','','2.490','1','100.00','255000','0','0','17800','850000','0','0','0','850000','KUR','00042561','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDAE-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='LXPER-ZDAE-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' 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-260531-0032','2026-05-31','2.490','2026-05-31','20:39:28','PLG0011624','850000','850000','0','850000','0','kasirbip','2026-05-31 20:39:27','FJ-260531-0031','','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-31','FJ-260531-0032','2026-05-31','20:39:28','KUR','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-260531-0056','2026-05-31','2026-05-31 20:39:27','PENJUALAN : FJ-260531-0032','.','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-260531-0057','D','2026-05-31','20:39:28','TBC','PENJUALAN','FJ-260531-0032','23122356014','850000','23123206014','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='1750000' WHERE no_faktur_jual='FJ-260531-0032' 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-02304','DIL','1','PLD','WEDD RING','','','4.000','','25.00','1','1200000','550000','0','750000','2950000','PERMATA ZIRCON 1 BUTIR','SIZE 21 . GRF : Tiara (love full) Dimas (berkshire)','crom putih doff mix gold glossy','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0057','2026-05-31','2026-05-31 20:39:58','PESANAN : DP-02304','-','TBC','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260531-0058','D','2026-05-31','20:39:58','TBC','PESANAN','DP-02304','23123206014','2000000','23125206014','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-02304','2026-05-31','2026-05-31','20:39:58','PLG0011625','DIL','2026-06-28','sby','2026-05-31 20:39:58','4.000','0','0','0','2000000','0','750000','2960000','2960000','960000');
UPDATE tt_service_head SET tgl_selesai='2026-05-31',  status ='DONE' WHERE no_service='SV-02070';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02070';
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-31',  status ='CLOS' WHERE no_service='SV-02070';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02070';
UPDATE tt_service_head SET tgl_selesai='2026-05-31',  status ='DONE' WHERE no_service='SV-02052';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02052';
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-31',  status ='CLOS' WHERE no_service='SV-02052';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0029';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0030';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0032';
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-260531-0033','kasirbip','1',' 750K-175-2','TOKO','BIPPER','PBDG-ZDXI-10-0','CINCIN SILVER 925 ','','1.980','1','100.00','202000','0','0','17800','850000','0','0','0','850000','GIN','00042404','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXI-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-05-31' AND kode_barang='PBDG-ZDXI-10-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-260531-0033','2026-05-31','1.980','2026-05-31','20:44:51','PLG0011626','850000','850000','0','850000','0','kasirbip','2026-05-31 20:44:50','FJ-260531-0033','','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-31','FJ-260531-0033','2026-05-31','20:44:51','GIN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260531-0058','2026-05-31','2026-05-31 20:44:50','PENJUALAN : FJ-260531-0033','.','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-260531-0059','D','2026-05-31','20:44:51','TBC','PENJUALAN','FJ-260531-0033','23125206014','850000','23126056014','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-260531-0033' 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-260531-0034','kasirbip',' 1',' 750K-14-26','TOKO','BIPPER','PBDG-ZEBB-27-0','CINCIN SILVER 925 ','','1.940','1','100.00','198000','0','0','17800','900000','0','0','0','900000','GIN','00043739','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-31', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEBB-27-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-31' AND kode_barang='PBDG-ZEBB-27-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-260531-0034','2026-05-31','1.940','2026-05-31','20:44:51','PLG0011627','900000','900000','0','900000','0','kasirbip','2026-05-31 20:44:50','FJ-260531-0033','','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-31','FJ-260531-0034','2026-05-31','20:44:51','GIN','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260531-0059','2026-05-31','2026-05-31 20:44:50','PENJUALAN : FJ-260531-0034','.','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-260531-0060','D','2026-05-31','20:44:51','TBC','PENJUALAN','FJ-260531-0034','23126056014','900000','23126956014','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='1750000' WHERE no_faktur_jual='FJ-260531-0034' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0034' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260531-0034' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260531-0034';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','21:17:41');
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-02305','VAN','1','PLD','WEDDING RING','','','3.000','','25.00','1','1200000','550000','0','900000','2550000','permata 15','size:125 Grf:Shafi ?? (love full) font: Berkshire','putih','150000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0060','2026-05-31','2026-05-31 21:24:20','PESANAN : DP-02305','-','TBC','2700000','2700000');
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-260531-0061','D','2026-05-31','21:24:20','TBC','PESANAN','DP-02305','23126956014','2700000','23129656014','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-02305','2026-05-31','2026-05-31','21:24:20','PLG0011628','VAN','2026-06-26','sby','2026-05-31 21:24:20','3.000','0','0','0','2700000','0','900000','2700000','2700000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','21:27:28');
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-02306','VAN','1','PER','WEDDING RING','','','5.000','','10.00','1','100000','350000','0','750000','2500000','Permata zirkon 1','Size:175 GRF:fianda ??(love full) font:berkshire','Putih','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0061','2026-05-31','2026-05-31 21:33:19','PESANAN : DP-02306','-','TBC','1700000','1700000');
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-260531-0062','D','2026-05-31','21:33:19','TBC','PESANAN','DP-02306','23129656014','1700000','23131356014','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-02306','2026-05-31','2026-05-31','21:33:19','PLG0011629','VAN','2026-06-26','sby','2026-05-31 21:33:19','5.000','0','0','0','1700000','0','750000','2510000','2510000','810000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-31 ','21:35:06');
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-02307','VAN','1','PER','WEDDING RING','','','5.000','','25.00','1','100000','550000','0','750000','3500000','permata 1','size:19 Grf: ROZAAN & NEIL Font: Arial','lebar cc req 5 mm finishing:putih','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0062','2026-05-31','2026-05-31 21:41:32','PESANAN : DP-02307','-','BCD','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-260531-0002','D','2026-05-31','21:41:32','BCD','PESANAN','DP-02307','1389903500','2400000','1392303500','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-02307','2026-05-31','2026-05-31','21:41:32','PLG0011630','VAN','2026-06-26','sby','2026-05-31 21:41:32','5.000','0','0','0','2400000','0','750000','3510000','3510000','1110000');
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-02308','DIL','1','PLD','WEDD RING','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','SIZE 22 . GRF : BY WA','CROM PUTIH','','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-260531-0063','2026-05-31','2026-05-31 21:47:09','PESANAN : DP-02308','-','TBC','1500000','1500000');
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-260531-0063','D','2026-05-31','21:47:09','TBC','PESANAN','DP-02308','23131356014','1500000','23132856014','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-02308','2026-05-31','2026-05-31','21:47:09','PLG0011631','DIL','2026-06-26','sby','2026-05-31 21:47:09','4.000','0','0','0','1500000','0','750000','2150000','2150000','650000');
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-02309','DIL','1','GOLD','WEDD RING','','','2.500','','37.50','1','2420000','1500000','0','950000','4700000','PERMATA ZIRCON 25 BUTIR','SIZE 18 . GRF : BY WA','PUTIH (EMAS PUTIH)','250000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260531-0064','2026-05-31','2026-05-31 21:50:32','PESANAN : DP-02309','-','TBC','3500000','3500000');
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-260531-0064','D','2026-05-31','21:50:32','TBC','PESANAN','DP-02309','23132856014','3500000','23136356014','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-02309','2026-05-31','2026-05-31','21:50:32','PLG0011632','DIL','2026-06-26','sby','2026-05-31 21:50:32','2.500','0','0','0','3500000','0','950000','4950000','4950000','1450000');
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-02310','DIL','1','PER','CINCIN SEPAKET 950K','','','1.000','','925.00','1','100000','0','950000','0','950000','WANITA SIZE 11 GRF: Y ?? G (TIMES NEW)','PRIA SIZE 19.5 GRF: G ?? Y (TIMES NEW)','CROM PUTIH DOFF MIX GLOSSY','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-260531-0065','2026-05-31','2026-05-31 21:54:44','PESANAN : DP-02310','-','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-260531-0065','D','2026-05-31','21:54:44','TBC','PESANAN','DP-02310','23136356014','950000','23137306014','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-02310','2026-05-31','2026-05-31','21:54:44','PLG0011633','DIL','2026-06-22','sby','2026-05-31 21:54:44','1.000','0','0','0','950000','0','0','950000','950000','0');