INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','11:26:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-05 ','11:43:09');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02777','VAN','1','PLD','WEDDRING WANITA','','','2.500','','10.00','1','1200000','350000','0','850000','1725000','PERMATA 9','SIZE: 14 GRF: Mifta ?? FONT: VINTAGE','PUTIH GLOSSY','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-260705-0001','2026-07-05','2026-07-05 11:47:42','PESANAN : DP-02777','-','TBC','1200000','1200000');
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-260705-0002','D','2026-07-05','11:47:42','TBC','PESANAN','DP-02777','24493969064','1200000','24495169064','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-02777','2026-07-05','2026-07-05','11:47:42','PLG0012816','VAN','2026-07-28','sby','2026-07-05 11:47:42','2.500','0','0','0','1200000','0','850000','1815000','1815000','615000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-05 ','11:48:14');
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-02778','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','SIZE: 21','GRF: Oen ?? FONT: VINTAGE','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-260705-0002','2026-07-05','2026-07-05 11:52:36','PESANAN : DP-02778','-','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-260705-0003','D','2026-07-05','11:52:36','TBC','PESANAN','DP-02778','24495169064','1400000','24496569064','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-02778','2026-07-05','2026-07-05','11:52:36','PLG0012817','VAN','2026-07-28','sby','2026-07-05 11:52:36','4.000','0','0','0','1400000','0','750000','2150000','2150000','750000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','12:12: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-02779','ALIKA','1','PLD','WEDDING RING','','','2.500','','10.00','1','1200000','350000','0','800000','1675000','size 14 grf wahyudi','zirkon 3 butir','crom putih','0','30000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0003','2026-07-05','2026-07-05 12:23:25','PESANAN : DP-02779','.','TBC','1364000','1364000');
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-260705-0004','D','2026-07-05','12:23:25','TBC','PESANAN','DP-02779','24496569064','1364000','24497933064','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-02779','2026-07-05','2026-07-05','12:23:25','PLG0012818','ALIKA','2026-08-01','kasir','2026-07-05 12:23:25','2.500','0','0','0','1364000','0','800000','1705000','1705000','341000');
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-02780','ALIKA','1','PLD','WEDDING RING','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','size 20 grf giska','crom putih doff semprot setengah','zirkon 1 butir','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-260705-0004','2026-07-05','2026-07-05 12:26:47','PESANAN : DP-02780','.','TBC','1720000','1720000');
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-260705-0005','D','2026-07-05','12:26:47','TBC','PESANAN','DP-02780','24497933064','1720000','24499653064','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-02780','2026-07-05','2026-07-05','12:26:47','PLG0012819','ALIKA','2026-08-01','kasir','2026-07-05 12:26:47','4.000','0','0','0','1720000','0','750000','2150000','2150000','430000');
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-260705-0001','kasir','1',' 750K-11-10','TOKO','MMPER','PMM-ZFAG-7-0','CINCIN SILVER 925 ','','1.900','1','100.00','194000','0','0','17800','900000','0','0','0','900000','ALIKA','00044493','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFAG-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PMM-ZFAG-7-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-260705-0001','2026-07-05','1.900','2026-07-05','12:40:40','PLG0012820','900000','900000','0','900000','0','kasir','2026-07-05 12:40:40','FJ-260705-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0001','2026-07-05','12:40:40','ALIKA','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-260705-0005','2026-07-05','2026-07-05 12:40:40','PENJUALAN : FJ-260705-0001','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-260705-0006','D','2026-07-05','12:40:40','TBC','PENJUALAN','FJ-260705-0001','24499653064','900000','24500553064','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='900000' WHERE no_faktur_jual='FJ-260705-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0002','kasir',' 1',' 500K-18-93','TOKO','MMPER','PMM-ZDXG-3-0','CINCIN SILVER 925 ','','2.110','1','100.00','216000','0','0','17800','700000','0','0','0','700000','ALIKA','00042318','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZDXG-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PMM-ZDXG-3-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-260705-0002','2026-07-05','2.110','2026-07-05','12:40:40','PLG0012821','700000','700000','0','700000','0','kasir','2026-07-05 12:40:40','FJ-260705-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0002','2026-07-05','12:40:40','ALIKA','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260705-0006','2026-07-05','2026-07-05 12:40:40','PENJUALAN : FJ-260705-0002','0','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260705-0007','D','2026-07-05','12:40:40','TBC','PENJUALAN','FJ-260705-0002','24500553064','700000','24501253064','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='1600000' WHERE no_faktur_jual='FJ-260705-0002' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02781','ASRI','1','GOLD','WEDDING RING','','','3.000','','75.00','1','2370000','2250000','0','1000000','7750000','size 15 grf imam','zirkon 39 butir','crom putih glosy','0','390000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0007','2026-07-05','2026-07-05 13:25:18','PESANAN : DP-02781','.','TBC','6512000','6512000');
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-260705-0008','D','2026-07-05','13:25:18','TBC','PESANAN','DP-02781','24501253064','6512000','24507765064','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-02781','2026-07-05','2026-07-05','13:25:18','PLG0012822','ASRI','2026-08-01','kasir','2026-07-05 13:25:18','3.000','0','0','0','6512000','0','1000000','8140000','8140000','1628000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','13:25:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-05 ','13:28:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','13:29:08');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02782','ASRI','1','PLD','WEDDING RING','','','4.000','','25.00','1','1200000','550000','0','750000','2950000','size 20 grf imelda','crom putih doff semprot','','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-260705-0008','2026-07-05','2026-07-05 13:31:55','PESANAN : DP-02782','.','TBC','2360000','2360000');
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-260705-0009','D','2026-07-05','13:31:55','TBC','PESANAN','DP-02782','24507765064','2360000','24510125064','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-02782','2026-07-05','2026-07-05','13:31:55','PLG0012823','ASRI','2026-08-01','kasir','2026-07-05 13:31:55','4.000','0','0','0','2360000','0','750000','2950000','2950000','590000');
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-260705-0003','kasirbip','1',' DP-02532DU','TOKO','DUPSN','PSGT-ZGXA-25-0','CINCIN EMAS ','','2.180','1','83.00','4209000','0','0','17800','6172000','0','0','0','6172000','PUT','00044885','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGXA-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSGT-ZGXA-25-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-260705-0003','2026-07-05','2.180','2026-07-05','13:36:55','PLG0012824','6172000','6172000','0','6172000','0','kasirbip','2026-07-05 13:36:55','FJ-260705-0003','DP-02532','4422000');
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-07-05','FJ-260705-0003','2026-07-05','13:36:55','PUT','6172000','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-260705-0009','2026-07-05','2026-07-05 13:36:55','PENJUALAN : FJ-260705-0003','.','TBC','1750000','1750000','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-260705-0010','D','2026-07-05','13:36:55','TBC','PENJUALAN','FJ-260705-0003','24510125064','1750000','24511875064','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-260705-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0004','kasirbip','1',' DP-02531DU','TOKO','DUPSN','PSPRT-ZGXA-4-0','CINCIN PERAK ','','3.630','1','100.00','371000','0','0','17800','850000','0','0','0','850000','PUT','00044864','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXA-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.630',berat_jual_asli=berat_jual_asli+'3.630',stock_jual='1',berat_akhir=berat_akhir-'3.630',berat_akhir_asli=berat_akhir_asli-'3.630',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSPRT-ZGXA-4-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-260705-0004','2026-07-05','3.630','2026-07-05','13:38:28','PLG0012825','850000','850000','0','850000','0','kasirbip','2026-07-05 13:38:28','FJ-260705-0004','DP-02531','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-07-05','FJ-260705-0004','2026-07-05','13:38:28','PUT','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-260705-0004' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-07-05 ','13:42: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-260705-0005','sby','1',' DP-02427SB','TOKO','SBYPSN','PSGT-ZFBF-25-0','CINCIN EMAS','','3.100','1','45.00','3515000','0','0','17800','5570000','0','0','0','5570000','VAN','00044767','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSGT-ZFBF-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260705-0005','2026-07-05','3.100','2026-07-05','13:52:59','PLG0012826','5570000','5570000','0','5570000','0','sby','2026-07-05 13:52:58','FJ-260705-0005','DP-02427','3700000');
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-07-05','FJ-260705-0005','2026-07-05','13:52:59','VAN','5570000','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-260705-0010','2026-07-05','2026-07-05 13:52:58','PENJUALAN : FJ-260705-0005','','TBC','1870000','1870000','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-260705-0011','D','2026-07-05','13:52:59','TBC','PENJUALAN','FJ-260705-0005','24511875064','1870000','24513745064','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='1870000' WHERE no_faktur_jual='FJ-260705-0005' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0006','sby',' 1',' DP-02426SB','TOKO','SBYPSN','PSPLT-ZFBI-46-0','CINCIN PALADIUM ','','3.410','1','17.00','766000','0','0','17800','1954000','0','0','0','1954000','VAN','00044837','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBI-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.410',berat_jual_asli=berat_jual_asli+'3.410',stock_jual='1',berat_akhir=berat_akhir-'3.410',berat_akhir_asli=berat_akhir_asli-'3.410',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSPLT-ZFBI-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260705-0006','2026-07-05','3.410','2026-07-05','13:52:59','PLG0012827','1954000','1954000','0','1954000','0','sby','2026-07-05 13:52:58','FJ-260705-0005','DP-02426','1300000');
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-07-05','FJ-260705-0006','2026-07-05','13:52:59','VAN','1954000','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-260705-0011','2026-07-05','2026-07-05 13:52:58','PENJUALAN : FJ-260705-0006','','TBC','654000','654000','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-260705-0012','D','2026-07-05','13:52:59','TBC','PENJUALAN','FJ-260705-0006','24513745064','654000','24514399064','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='2524000' WHERE no_faktur_jual='FJ-260705-0006' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-05 ','14:00:26');
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-260705-0007','kasirbip','1',' DP-02256BI','TOKO','BIPPSN','PSPRT-ZFBD-10-0','CINCIN PERAK ','','2.170','1','100.00','222000','0','0','17800','850000','0','0','0','850000','SAL','00044665','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSPRT-ZFBD-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260705-0007','2026-07-05','2.170','2026-07-05','14:02:01','PLG0012828','850000','850000','0','850000','0','kasirbip','2026-07-05 14:02:01','FJ-260705-0007','DP-02256','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-07-05','FJ-260705-0007','2026-07-05','14:02:01','SAL','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-260705-0007' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0008','kasirbip',' 1',' DP-02255BI','TOKO','BIPPSN','PSGT-ZFAG-24-0','CINCIN EMAS ','','2.270','1','83.00','4671000','0','0','17800','6398000','0','0','0','6398000','SAL','00044510','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFAG-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSGT-ZFAG-24-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-260705-0008','2026-07-05','2.270','2026-07-05','14:02:01','PLG0012829','6398000','6398000','0','6398000','0','kasirbip','2026-07-05 14:02:01','FJ-260705-0007','DP-02255','5560000');
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-07-05','FJ-260705-0008','2026-07-05','14:02:01','SAL','6398000','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-260705-0012','2026-07-05','2026-07-05 14:02:01','PENJUALAN : FJ-260705-0008','.','TBC','838000','838000','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-260705-0013','D','2026-07-05','14:02:01','TBC','PENJUALAN','FJ-260705-0008','24514399064','838000','24515237064','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='838000' WHERE no_faktur_jual='FJ-260705-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0008';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','14:09:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','14:18:44');
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-02783','ELLA','1','PLD','WEDDING RING','','','3.500','','25.00','1','1200000','550000','0','750000','2675000','size 17.5','warna putih doff semprot sesuai model','','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-260705-0013','2026-07-05','2026-07-05 14:19:57','PESANAN : DP-02783','0','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-260705-0014','D','2026-07-05','14:19:57','TBC','PESANAN','DP-02783','24515237064','2140000','24517377064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02783','2026-07-05','2026-07-05','14:19:57','PLG0012830','ELLA','2026-08-01','kasir','2026-07-05 14:19:57','3.500','0','0','0','2140000','0','750000','2675000','2675000','535000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02157','SULIS','1','SEPASANG SILVER','PUTIH GLOSY KEDUANYA','3.000','1','100000','100000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260705-0014','2026-07-05','2026-07-05 14:20:18','SERVICE : SV-02157','.','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-260705-0015','D','2026-07-05','14:20:18','TBC','SERVICE','SV-02157','24517377064','100000','24517477064','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-02157','2026-07-05','2026-07-05','14:20:18','PLG0012831','kasirbip','2026-07-19','kasirbip','2026-07-05 14:20:18','3.000','0','0','0','100000','0','100000','100000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02784','ELLA','1','GOLD','WEDDING RING','','','1.800','','75.00','1','2370000','2250000','0','700000','4750000','size 11','warna putih glosy sesuai model','zircone 1 butir','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0015','2026-07-05','2026-07-05 14:22:19','PESANAN : DP-02784','0','TBC','3800000','3800000');
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-260705-0016','D','2026-07-05','14:22:19','TBC','PESANAN','DP-02784','24517477064','3800000','24521277064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02784','2026-07-05','2026-07-05','14:22:19','PLG0012832','ELLA','2026-08-01','kasir','2026-07-05 14:22:19','1.800','0','0','0','3800000','0','700000','4750000','4750000','950000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-05 ','14:27:04');
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-02785','DIL','1','GOLD','CINCIN PROMO 9K','','','1.500','','37.50','1','2370000','1400000','500000','750000','3350000','WANITA ; SIZE : 18 GRF : Habib (infinity) font: berkshire','PRIA ; SIZE 30 GRF: Mutia (infinity) font : berkshire','crom putih glossy mix doff','100000','150000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0016','2026-07-05','2026-07-05 14:28:46','PESANAN : DP-02785','-','TBC','3600000','3600000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260705-0017','D','2026-07-05','14:28:46','TBC','PESANAN','DP-02785','24521277064','3600000','24524877064','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-02785','2026-07-05','2026-07-05','14:28:46','PLG0012833','DIL','2026-07-31','sby','2026-07-05 14:28:46','1.500','0','0','0','3600000','0','750000','3600000','3600000','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-02786','ASRI','1','PER','WEDDING RING','','','1.000','','925.00','1','100000','0','0','0','1000000','size 12 grf Ari','zirkon 6 butir','crom putih glosy','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-260705-0017','2026-07-05','2026-07-05 14:30:42','PESANAN : DP-02786','.','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-260705-0018','D','2026-07-05','14:30:42','TBC','PESANAN','DP-02786','24524877064','1000000','24525877064','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-02786','2026-07-05','2026-07-05','14:30:42','PLG0012834','ASRI','2026-08-01','kasir','2026-07-05 14:30:42','1.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-02787','SULIS','1','GOLD','WED RING','','','3.500','','37.50','1','2370000','1400000','0','950000','5850000','18 zircon rosegold glosy sz 18','font comic sans','grf To D - Love','180000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0018','2026-07-05','2026-07-05 14:32:54','PESANAN : DP-02787','.','TBC','4824000','4824000');
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-260705-0019','D','2026-07-05','14:32:54','TBC','PESANAN','DP-02787','24525877064','4824000','24530701064','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-02787','2026-07-05','2026-07-05','14:32:54','PLG0012835','SULIS','2026-07-29','kasirbip','2026-07-05 14:32:54','3.500','0','0','0','4824000','0','950000','6030000','6030000','1206000');
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-02788','ASRI','1','PER','WEDDING RING','','','1.000','','925.00','1','100000','0','0','0','950000','size 33 grf dini','crom putih doff semprot','tanpa mata','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-260705-0019','2026-07-05','2026-07-05 14:34:08','PESANAN : DP-02788','.','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-260705-0020','D','2026-07-05','14:34:08','TBC','PESANAN','DP-02788','24530701064','950000','24531651064','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-02788','2026-07-05','2026-07-05','14:34:08','PLG0012836','ASRI','2026-08-01','kasir','2026-07-05 14:34:08','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-02789','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','sz 17 putih glosy mosel tanpa mata','font comic sans','grf To H - Love','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0020','2026-07-05','2026-07-05 14:35:04','PESANAN : DP-02789','.','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-260705-0021','D','2026-07-05','14:35:04','TBC','PESANAN','DP-02789','24531651064','1400000','24533051064','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-02789','2026-07-05','2026-07-05','14:35:04','PLG0012837','SULIS','2026-07-19','kasirbip','2026-07-05 14:35:04','3.000','0','0','0','1400000','0','700000','1750000','1750000','350000');
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-260705-0009','kasirbip','1',' DP-02587BI','TOKO','BIPPSN','PSPRT-ZGXA-30-0','CINCIN PERAK SR-05 YL-01 ','','2.990','1','100.00','305000','0','0','17800','950000','0','0','0','950000','SAL','00044890','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXA-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.990',berat_jual_asli=berat_jual_asli+'2.990',stock_jual='1',berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSPRT-ZGXA-30-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-260705-0009','2026-07-05','2.990','2026-07-05','14:46:21','PLG0012838','950000','950000','0','950000','0','kasirbip','2026-07-05 14:46:20','FJ-260705-0009','DP-02587','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0009','2026-07-05','14:46:21','SAL','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260705-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0009';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','14:50:46');
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-02790','ELLA','1','GOLD','WEDDING RING','','','2.000','','75.00','1','2370000','2250000','0','900000','5400000','size 10.5 grf S.W','warna putih glosy','zircone 15 butir','0','0','150000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0021','2026-07-05','2026-07-05 14:57:50','PESANAN : DP-02790','0','TBC','4400000','4400000');
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-260705-0022','D','2026-07-05','14:57:50','TBC','PESANAN','DP-02790','24533051064','4400000','24537451064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02790','2026-07-05','2026-07-05','14:57:50','PLG0012839','ELLA','2026-08-01','kasir','2026-07-05 14:57:50','2.000','0','0','0','4400000','0','900000','5550000','5550000','1150000');
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-02791','ELLA','1','PER','WEDDING RING','','','4.000','','925.00','1','100000','0','0','0','900000','size 24 grf S.W','warna putih doff semprot','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0022','2026-07-05','2026-07-05 15:00:50','PESANAN : DP-02791','0','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260705-0023','D','2026-07-05','15:00:50','TBC','PESANAN','DP-02791','24537451064','900000','24538351064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02791','2026-07-05','2026-07-05','15:00:50','PLG0012840','ELLA','2026-08-01','kasir','2026-07-05 15:00:50','4.000','0','0','0','900000','0','0','900000','900000','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-260705-0010','kasir','1',' TFGKR75-85','TOKO','TFGLK','TFGKR-ZBBF-85-0','THIFA GELANG KAKU RG ','','8.500','1','85.00','17466000','0','0','17800','17500000','0','0','0','17500000','RISIANA','00041984','TFGKR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGKR-ZBBF-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.500',berat_jual_asli=berat_jual_asli+'8.500',stock_jual='1',berat_akhir=berat_akhir-'8.500',berat_akhir_asli=berat_akhir_asli-'8.500',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='TFGKR-ZBBF-85-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLK' 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-260705-0010','2026-07-05','8.500','2026-07-05','15:01:33','PLG0012841','17500000','17500000','0','17500000','17500000','kasir','2026-07-05 15:01:32','FJ-260705-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0010','2026-07-05','15:01:33','RISIANA','17500000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260705-0002','D','2026-07-05','15:01:33','kasir','PENJUALAN','FJ-260705-0010','3109200','17500000','20609200','OPEN');
UPDATE tt_jual_head SET dibayar_rp='17500000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260705-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0011','kasir',' 1',' TFCMR75-86','TOKO','TFCINMAS','TFCMR-YLXD-91-0','THIFA CINCIN MAS RG ','','3.660','1','86.00','7610000','0','0','17800','7650000','0','0','0','7650000','RISIANA','00040271','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YLXD-91-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.660',berat_jual_asli=berat_jual_asli+'3.660',stock_jual='1',berat_akhir=berat_akhir-'3.660',berat_akhir_asli=berat_akhir_asli-'3.660',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='TFCMR-YLXD-91-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260705-0011','2026-07-05','3.660','2026-07-05','15:01:33','PLG0012842','7650000','7650000','0','7650000','4000000','kasir','2026-07-05 15:01:32','FJ-260705-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0011','2026-07-05','15:01:33','RISIANA','7650000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260705-0003','D','2026-07-05','15:01:33','kasir','PENJUALAN','FJ-260705-0011','20609200','4000000','24609200','OPEN');
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-260705-0023','2026-07-05','2026-07-05 15:01:32','PENJUALAN : FJ-260705-0011','.','TBC','3650000','3650000','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-260705-0024','D','2026-07-05','15:01:33','TBC','PENJUALAN','FJ-260705-0011','24538351064','3650000','24542001064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='4000000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3650000' WHERE no_faktur_jual='FJ-260705-0011' 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-02792','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz 11.5 putih glosy 19 zircon','font vintage rotter grf Widya . . . Andri','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0024','2026-07-05','2026-07-05 15:08:37','PESANAN : DP-02792','.','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-260705-0025','D','2026-07-05','15:08:37','TBC','PESANAN','DP-02792','24542001064','1000000','24543001064','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-02792','2026-07-05','2026-07-05','15:08:37','PLG0012843','SULIS','2026-07-29','kasirbip','2026-07-05 15:08:37','2.000','0','0','0','1000000','0','0','1000000','1000000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02793','SULIS','1','PER','WEDR ING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 20.5 putih doff semprot','font vintage rotter grf Widya . . . Andri','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0025','2026-07-05','2026-07-05 15:09:44','PESANAN : DP-02793','.','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260705-0026','D','2026-07-05','15:09:44','TBC','PESANAN','DP-02793','24543001064','900000','24543901064','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-02793','2026-07-05','2026-07-05','15:09:44','PLG0012844','SULIS','2026-07-29','kasirbip','2026-07-05 15:09:44','3.000','0','0','0','900000','0','0','900000','900000','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-260705-0012','sby','1',' 750K-18-00','TOKO','SBYPER','PSBY-ZFBB-6-0','CINCIN SILVER 925 ','','3.560','1','100.00','364000','0','0','17800','850000','0','0','0','850000','DIL','00044620','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZFBB-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.560',berat_jual_asli=berat_jual_asli+'3.560',stock_jual='1',berat_akhir=berat_akhir-'3.560',berat_akhir_asli=berat_akhir_asli-'3.560',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSBY-ZFBB-6-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-260705-0012','2026-07-05','3.560','2026-07-05','15:24:36','PLG0012845','850000','850000','0','850000','0','sby','2026-07-05 15:24:35','FJ-260705-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0012','2026-07-05','15:24:36','DIL','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-260705-0026','2026-07-05','2026-07-05 15:24:35','PENJUALAN : FJ-260705-0012','','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260705-0027','D','2026-07-05','15:24:36','TBC','PENJUALAN','FJ-260705-0012','24543901064','850000','24544751064','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-260705-0012' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0013','sby',' 1',' 750K-125-0','TOKO','SBYPER','PSBY-ZFBB-9-0','CINCIN SILVER 925 ','','2.260','1','100.00','232000','0','0','17800','850000','0','0','0','850000','DIL','00044623','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZFBB-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.260',berat_jual_asli=berat_jual_asli+'2.260',stock_jual='1',berat_akhir=berat_akhir-'2.260',berat_akhir_asli=berat_akhir_asli-'2.260',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSBY-ZFBB-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-260705-0013','2026-07-05','2.260','2026-07-05','15:24:36','PLG0012846','850000','850000','0','850000','0','sby','2026-07-05 15:24:35','FJ-260705-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0013','2026-07-05','15:24:36','DIL','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-260705-0027','2026-07-05','2026-07-05 15:24:35','PENJUALAN : FJ-260705-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-260705-0028','D','2026-07-05','15:24:36','TBC','PENJUALAN','FJ-260705-0013','24544751064','850000','24545601064','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='1700000' WHERE no_faktur_jual='FJ-260705-0013' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0014','kasirbip','1',' 1.2K-13-00','TOKO','DUPERBDG','LXPER-ZEBI-40-0','CINCIN SILVER 925 ','','1.730','1','100.00','177000','0','0','17800','1300000','0','0','0','1300000','KUR','00043866','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEBI-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='LXPER-ZEBI-40-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-260705-0014','2026-07-05','1.730','2026-07-05','15:30:57','PLG0012847','1300000','1300000','0','1300000','0','kasirbip','2026-07-05 15:30:56','FJ-260705-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-07-05','FJ-260705-0014','2026-07-05','15:30:57','KUR','1300000','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-260705-0028','2026-07-05','2026-07-05 15:30:56','PENJUALAN : FJ-260705-0014','.','TBC','1300000','1300000','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-260705-0029','D','2026-07-05','15:30:57','TBC','PENJUALAN','FJ-260705-0014','24545601064','1300000','24546901064','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='1300000' WHERE no_faktur_jual='FJ-260705-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0014';
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-260705-0015','kasirbip','1',' 750K-195-0','TOKO','DUPERBDG','LXPER-ZFAB-74-0','CINCIN SILVER 925 ','','2.520','1','100.00','258000','0','0','17800','850000','0','0','0','850000','KUR','00044398','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAB-74-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='LXPER-ZFAB-74-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-260705-0015','2026-07-05','2.520','2026-07-05','15:44:44','PLG0012848','850000','850000','0','850000','0','kasirbip','2026-07-05 15:44:43','FJ-260705-0015','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0015','2026-07-05','15:44:44','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-260705-0029','2026-07-05','2026-07-05 15:44:43','PENJUALAN : FJ-260705-0015','.','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-260705-0030','D','2026-07-05','15:44:44','TBC','PENJUALAN','FJ-260705-0015','24546901064','850000','24547751064','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-260705-0015' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0016','kasirbip',' 1',' 750K-12-00','TOKO','DUPERBDG','LXPER-ZFAB-69-0','CINCIN SILVER 925 ','','1.550','1','100.00','159000','0','0','17800','850000','0','0','0','850000','KUR','00044393','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAB-69-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='LXPER-ZFAB-69-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-260705-0016','2026-07-05','1.550','2026-07-05','15:44:44','PLG0012849','850000','850000','0','850000','0','kasirbip','2026-07-05 15:44:43','FJ-260705-0015','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0016','2026-07-05','15:44:44','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-260705-0030','2026-07-05','2026-07-05 15:44:43','PENJUALAN : FJ-260705-0016','.','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-260705-0031','D','2026-07-05','15:44:44','TBC','PENJUALAN','FJ-260705-0016','24547751064','850000','24548601064','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='1700000' WHERE no_faktur_jual='FJ-260705-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0016';
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-02794','VAN','1','GOLD','WEDDRING WANITA','','','2.500','','37.50','1','2370000','1400000','0','750000','4250000','PERMATA 1','SIZE: 9 GRF: R ?? S FONT: BERKSHIRE','EMAS 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-260705-0031','2026-07-05','2026-07-05 16:04:59','PESANAN : DP-02794','-','TBC','2900000','2900000');
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-260705-0032','D','2026-07-05','16:04:59','TBC','PESANAN','DP-02794','24548601064','2900000','24551501064','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-02794','2026-07-05','2026-07-05','16:04:59','PLG0012850','VAN','2026-07-28','sby','2026-07-05 16:04:59','2.500','0','0','0','2900000','0','750000','4260000','4260000','1360000');
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-02795','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','YL-01 sz 16.5 putih doff amplas','font yeseva one grf R.R','berat akhir jgn lebih dari 3gram','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0032','2026-07-05','2026-07-05 16:21:15','PESANAN : DP-02795','.','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-260705-0033','D','2026-07-05','16:21:15','TBC','PESANAN','DP-02795','24551501064','1400000','24552901064','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-02795','2026-07-05','2026-07-05','16:21:15','PLG0012851','SULIS','2026-07-29','kasirbip','2026-07-05 16:21:15','3.000','0','0','0','1400000','0','700000','1750000','1750000','350000');
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-260705-0017','sby','1',' DP-02301SB','TOKO','SBYPSN','PSPLT-ZFBF-45-0','CINCIN PALADIUM ','','4.320','1','17.00','970000','0','0','17800','2322000','0','0','0','2322000','DIL','00044787','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.320',berat_jual_asli=berat_jual_asli+'4.320',stock_jual='1',berat_akhir=berat_akhir-'4.320',berat_akhir_asli=berat_akhir_asli-'4.320',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSPLT-ZFBF-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260705-0017','2026-07-05','4.320','2026-07-05','16:28:45','PLG0012852','2322000','2322000','0','2322000','0','sby','2026-07-05 16:28:45','FJ-260705-0017','DP-02301','1700000');
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-07-05','FJ-260705-0017','2026-07-05','16:28:45','DIL','2322000','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-260705-0033','2026-07-05','2026-07-05 16:28:45','PENJUALAN : FJ-260705-0017','','TBC','622000','622000','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-260705-0034','D','2026-07-05','16:28:45','TBC','PENJUALAN','FJ-260705-0017','24552901064','622000','24553523064','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='622000' WHERE no_faktur_jual='FJ-260705-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-260705-0018','sby',' 1',' DP-02302SB','TOKO','SBYPSN','PSGT-ZFAH-6-0','CINCIN EMAS ','','1.800','1','45.00','2008000','0','0','17800','3880000','0','0','0','3880000','DIL','00044519','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFAH-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSGT-ZFAH-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' 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-260705-0018','2026-07-05','1.800','2026-07-05','16:28:45','PLG0012853','3880000','3880000','0','3880000','0','sby','2026-07-05 16:28:45','FJ-260705-0017','DP-02302','3400000');
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-07-05','FJ-260705-0018','2026-07-05','16:28:45','DIL','3880000','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-260705-0034','2026-07-05','2026-07-05 16:28:45','PENJUALAN : FJ-260705-0018','','TBC','480000','480000','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-260705-0035','D','2026-07-05','16:28:45','TBC','PENJUALAN','FJ-260705-0018','24553523064','480000','24554003064','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='1102000' WHERE no_faktur_jual='FJ-260705-0018' 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-02796','ALIKA','1','PER','PROMO PAKE CP 10','','','1.000','','925.00','1','100000','0','0','0','1400000','COWO SIZE 18 GRF RANI','CEWE SIZE 10 GRF IRVAN','CROM PUIH GLOSYY KEDUANYA','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-260705-0035','2026-07-05','2026-07-05 16:35:52','PESANAN : DP-02796','.','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-260705-0036','D','2026-07-05','16:35:52','TBC','PESANAN','DP-02796','24554003064','1400000','24555403064','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-02796','2026-07-05','2026-07-05','16:35:52','PLG0012854','ALIKA','2026-08-01','kasir','2026-07-05 16:35:52','1.000','0','0','0','1400000','0','0','1400000','1400000','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-02797','VAN','1','PER','WEDDRING WANITA','','','2.000','','925.00','1','100000','0','0','950000','950000','SIZE: 17.5','GRF: Wahyu FONT: BERKSHIRE','PUTIH GLOSY','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-260705-0036','2026-07-05','2026-07-05 17:10:35','PESANAN : DP-02797','-','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-260705-0037','D','2026-07-05','17:10:35','TBC','PESANAN','DP-02797','24555403064','950000','24556353064','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-02797','2026-07-05','2026-07-05','17:10:35','PLG0012855','VAN','2026-07-28','sby','2026-07-05 17:10:35','2.000','0','0','0','950000','0','950000','950000','950000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','17:10:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-05 ','17:11:21');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0018';
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-260705-0019','kasir','1',' TFGRR75-81','TOKO','TFGLR','TFGRR-YLXC-57-0','THIFA GELANG RANTAI RG ','','1.030','1','81.00','2018000','0','0','17800','2140000','0','0','0','2140000','IQB','00040180','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YLXC-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='TFGRR-YLXC-57-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-260705-0019','2026-07-05','1.030','2026-07-05','17:12:22','PLG0012856','2140000','2140000','0','2140000','0','kasir','2026-07-05 17:12:21','FJ-260705-0019','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0019','2026-07-05','17:12:22','IQB','2140000','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-260705-0037','2026-07-05','2026-07-05 17:12:21','PENJUALAN : FJ-260705-0019','.','TBC','2140000','2140000','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-260705-0038','D','2026-07-05','17:12:22','TBC','PENJUALAN','FJ-260705-0019','24556353064','2140000','24558493064','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='2140000' WHERE no_faktur_jual='FJ-260705-0019' 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-02798','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','800000','0','800000','SIZE: 19','GRF: Ulfah FONT: BERKSHIRE','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-260705-0038','2026-07-05','2026-07-05 17:14:13','PESANAN : DP-02798','-','TBC','800000','800000');
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-260705-0039','D','2026-07-05','17:14:13','TBC','PESANAN','DP-02798','24558493064','800000','24559293064','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-02798','2026-07-05','2026-07-05','17:14:13','PLG0012857','VAN','2026-07-28','sby','2026-07-05 17:14:13','3.000','0','0','0','800000','0','0','800000','800000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0019';
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-260705-0020','sby','1',' 850K-115-0','TOKO','SBYPER','PSBY-ZEXE-49-0','CINCIN SILVER 925 ','','1.490','1','100.00','152000','0','0','17800','950000','0','0','0','950000','DIL','00043245','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-49-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-07-05' AND kode_barang='PSBY-ZEXE-49-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-260705-0020','2026-07-05','1.490','2026-07-05','17:25:27','PLG0012858','950000','950000','0','950000','0','sby','2026-07-05 17:25:27','FJ-260705-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-07-05','FJ-260705-0020','2026-07-05','17:25:27','DIL','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-260705-0039','2026-07-05','2026-07-05 17:25:27','PENJUALAN : FJ-260705-0020','','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-260705-0040','D','2026-07-05','17:25:27','TBC','PENJUALAN','FJ-260705-0020','24559293064','950000','24560243064','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-260705-0020' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','17:25:20');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0020';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-05 ','17:33:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-07-05 ','17:34:45');
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-260705-0021','kasirbip','1',' DP-02287BI','TOKO','BIPPSN','PSPLT-ZFBI-38-0','CINCIN PALADIUM ','','3.580','1','32.00','1513000','0','0','17800','2719000','0','0','0','2719000','SAL','00044829','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBI-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.580',berat_jual_asli=berat_jual_asli+'3.580',stock_jual='1',berat_akhir=berat_akhir-'3.580',berat_akhir_asli=berat_akhir_asli-'3.580',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSPLT-ZFBI-38-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-260705-0021','2026-07-05','3.580','2026-07-05','17:35:59','PLG0012859','2719000','2719000','0','2719000','0','kasirbip','2026-07-05 17:35:59','FJ-260705-0021','DP-02287','2140000');
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-07-05','FJ-260705-0021','2026-07-05','17:35:59','SAL','2719000','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-260705-0040','2026-07-05','2026-07-05 17:35:59','PENJUALAN : FJ-260705-0021','.','TBC','579000','579000','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-260705-0041','D','2026-07-05','17:35:59','TBC','PENJUALAN','FJ-260705-0021','24560243064','579000','24560822064','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='579000' WHERE no_faktur_jual='FJ-260705-0021' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0021';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0022','kasir','1',' TFCMR75-86','TOKO','TFCINMAS','TFCMR-ZFBI-12-0','THIFA CINCIN MAS RG ','','0.800','1','86.00','1664000','0','0','17800','1715000','0','0','0','1715000','IQB','00044803','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZFBI-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='TFCMR-ZFBI-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260705-0022','2026-07-05','0.800','2026-07-05','17:37:18','PLG0012860','1715000','1715000','0','1715000','0','kasir','2026-07-05 17:37:17','FJ-260705-0022','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0022','2026-07-05','17:37:18','IQB','1715000','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-260705-0041','2026-07-05','2026-07-05 17:37:17','PENJUALAN : FJ-260705-0022','.','TBC','1715000','1715000','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-260705-0042','D','2026-07-05','17:37:18','TBC','PENJUALAN','FJ-260705-0022','24560822064','1715000','24562537064','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='1715000' WHERE no_faktur_jual='FJ-260705-0022' LIMIT 1;
UPDATE tm_barang SET stock_on_hand='1' WHERE kode_barang='TFGRR-YLXC-57-0' AND kode_lokasi_toko='TFGLR' LIMIT 1;
UPDATE tt_jual_sales SET jml_jual_rp =jml_jual_rp-'2140000',ongkos_rp=ongkos_rp-'0' WHERE no_faktur_jual ='FJ-260705-0019';
UPDATE tt_jual_head SET status_return = 'CLOS' WHERE no_faktur_jual ='FJ-260705-0019';
UPDATE tt_barang_tukar SET status='CLOS' WHERE no_faktur_group='FJ-260705-0019';
UPDATE tt_voucher_customer SET status='OPEN' WHERE no_voucher='-'
UPDATE tt_barang_saldo SET stock_jual=stock_jual-1, berat_jual = berat_jual-'1.03',berat_jual_asli = berat_jual_asli-'1.03', stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.03',berat_akhir_asli=berat_akhir_asli+'1.03' WHERE tanggal ='2026-07-05' AND kode_lokasi_toko ='TFGLR' AND kode_barang='TFGRR-YLXC-57-0' AND stock_jual*1 > 0 LIMIT 1;
INSERT INTO tt_jual_retur_detail(no_retur_jual,no_urut,no_faktur_jual,kode_barang,nama_barang,berat,harga,ongkos,jml_detail,kode_lokasi_toko,kode_dept,kadar,sales_id,alasan,harga_atribut) VALUES ('BJ-260705-0001','1','FJ-260705-0019','TFGRR-YLXC-57-0','THIFA GELANG RANTAI RG ','1.03','2140000.00','0','2140000','TFGLR','TFGRR','81.00','kasir','SALAH INPUT','0');
DELETE FROM tt_jual_head WHERE no_faktur_jual ='FJ-260705-0019' LIMIT 1;
DELETE FROM tt_jual_detail WHERE no_faktur_jual ='FJ-260705-0019' LIMIT 1;
DELETE FROM tt_jual_sales WHERE no_faktur_jual ='FJ-260705-0019' LIMIT 1;
INSERT INTO tt_jual_retur_head(no_retur_jual,tgl_system,tgl_retur_jual,kode_customer,dpp_netto_rp,jml_retur_rp,input_by,input_date)VALUES('BJ-260705-0001','2026-07-05','2026-07-05','PLG0012856','2140000','2140000','kasir','2026-07-05 17:41:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-05 ','17:43:56');
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-260705-0023','kasir','1',' TFGRR75-81','TOKO','TFGLR','TFGRR-YLXC-57-0','THIFA GELANG RANTAI RG ','','1.030','1','81.00','2018000','0','0','17800','2085000','0','0','0','2085000','IQB','00040180','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YLXC-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='TFGRR-YLXC-57-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-260705-0023','2026-07-05','1.030','2026-07-05','17:45:40','PLG0012861','2085000','2085000','0','2085000','0','kasir','2026-07-05 17:45:39','FJ-260705-0023','','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-07-05','FJ-260705-0023','2026-07-05','17:45:40','IQB','2085000','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-260705-0042','2026-07-05','2026-07-05 17:45:39','PENJUALAN : FJ-260705-0023','.','TBC','2085000','2085000','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-260705-0043','D','2026-07-05','17:45:40','TBC','PENJUALAN','FJ-260705-0023','24562537064','2085000','24564622064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2085000' WHERE no_faktur_jual='FJ-260705-0023' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0023';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0024','sby','1',' 750K-175-0','TOKO','SBYPER','PSBY-ZEXE-19-0','CINCIN SILVER 925 ','','1.670','1','100.00','171000','0','0','17800','850000','0','0','0','850000','VAN','00043215','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.670',berat_jual_asli=berat_jual_asli+'1.670',stock_jual='1',berat_akhir=berat_akhir-'1.670',berat_akhir_asli=berat_akhir_asli-'1.670',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSBY-ZEXE-19-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-260705-0024','2026-07-05','1.670','2026-07-05','17:48:19','PLG0012862','850000','850000','0','850000','0','sby','2026-07-05 17:48:18','FJ-260705-0024','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-05','FJ-260705-0024','2026-07-05','17:48:19','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-260705-0043','2026-07-05','2026-07-05 17:48:18','PENJUALAN : FJ-260705-0024','','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-260705-0044','D','2026-07-05','17:48:19','TBC','PENJUALAN','FJ-260705-0024','24564622064','850000','24565472064','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-260705-0024' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-05 ','17:50:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-05 ','17:58:36');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-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-260705-0025','kasirbip','1',' DP-02557BI','TOKO','BIPPSN','PSPRT-ZGXA-31-0','CINCIN PERAK ','','1.620','1','100.00','166000','0','0','17800','1050000','0','0','0','1050000','SAL','00044891','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXA-31-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-07-05' AND kode_barang='PSPRT-ZGXA-31-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-260705-0025','2026-07-05','1.620','2026-07-05','18:19:38','PLG0012863','1050000','1050000','0','1050000','0','kasirbip','2026-07-05 18:19:37','FJ-260705-0025','DP-02557','1050000');
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-07-05','FJ-260705-0025','2026-07-05','18:19:38','SAL','1050000','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-260705-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-260705-0026','kasirbip',' 1',' DP-02558BI','TOKO','BIPPSN','PSPRT-ZGXC-1-0','CINCIN PERAK ','','2.630','1','100.00','269000','0','0','17800','850000','0','0','0','850000','SAL','00044905','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGXC-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSPRT-ZGXC-1-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-260705-0026','2026-07-05','2.630','2026-07-05','18:19:38','PLG0012864','850000','850000','0','850000','0','kasirbip','2026-07-05 18:19:37','FJ-260705-0025','DP-02558','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-07-05','FJ-260705-0026','2026-07-05','18:19:38','SAL','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-260705-0026' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0026';
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-02799','SULIS','1','DM','WED RING','','','1.500','','50.00','1','2370000','1800000','0','850000','3550000','sz 12 putih glosy 13 zircon','font berkshire swash grf Lingga','express 100.000','130000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0044','2026-07-05','2026-07-05 18:34:39','PESANAN : DP-02799','.','TBC','2944000','2944000');
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-260705-0045','D','2026-07-05','18:34:39','TBC','PESANAN','DP-02799','24565472064','2944000','24568416064','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-02799','2026-07-05','2026-07-05','18:34:39','PLG0012865','SULIS','2026-07-15','kasirbip','2026-07-05 18:34:39','1.500','0','0','0','2944000','0','850000','3680000','3680000','736000');
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-260705-0027','kasirbip','1',' 700K-18-00','TOKO','BIPPER','LXPER-ZBAH-18-0','CINCIN SILVER 925 ','','1.500','1','100.00','153000','0','0','17800','800000','0','0','0','800000','SULIS','00041636','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBAH-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='LXPER-ZBAH-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260705-0027','2026-07-05','1.500','2026-07-05','18:35:28','PLG0012866','800000','800000','0','800000','0','kasirbip','2026-07-05 18:35:27','FJ-260705-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-07-05','FJ-260705-0027','2026-07-05','18:35:28','SULIS','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-260705-0045','2026-07-05','2026-07-05 18:35:27','PENJUALAN : FJ-260705-0027','.','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-260705-0046','D','2026-07-05','18:35:28','TBC','PENJUALAN','FJ-260705-0027','24568416064','800000','24569216064','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-260705-0027' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0027';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02158','SULIS','1','CC SILVER','JANGAN DI CROM ULANG FONT BERKSHITE SWASH','1.500','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-02158','2026-07-05','2026-07-05','18:37:14','PLG0012867','kasirbip','2026-07-14','kasirbip','2026-07-05 18:37:14','1.500','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-05 ','18:37:34');
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-02800','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','cwo YL-01 sz 21 oversize 100.000','cwe SR-03 sz 13.5 oversize 100.000','EXPRESS 100.000 font berkshire swash grf keduanya Rena & Aji','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-260705-0046','2026-07-05','2026-07-05 19:11:21','PESANAN : DP-02800','.','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-260705-0047','D','2026-07-05','19:11:21','TBC','PESANAN','DP-02800','24569216064','950000','24570166064','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-02800','2026-07-05','2026-07-05','19:11:21','PLG0012868','SAL','2026-07-15','kasirbip','2026-07-05 19:11:21','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260705-0028','kasir','1',' PLDMM-0003','TOKO','MMPLD','PLDMM-ZACX-38-0','CINCIN PALADIUM PLDMM-00038 ','','1.510','1','17.00','340000','0','0','17800','1228500','0','0','0','1228500','ELLA','00041252','PLDMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZACX-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PLDMM-ZACX-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260705-0028','2026-07-05','1.510','2026-07-05','19:16:06','PLG0012869','1228500','1228500','0','1228500','0','kasir','2026-07-05 19:16:06','FJ-260705-0028','','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-07-05','FJ-260705-0028','2026-07-05','19:16:06','ELLA','1228500','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-260705-0047','2026-07-05','2026-07-05 19:16:06','PENJUALAN : FJ-260705-0028','0','TBC','1228500','1228500','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-260705-0048','D','2026-07-05','19:16:06','TBC','PENJUALAN','FJ-260705-0028','24570166064','1228500','24571394564','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='1228500' WHERE no_faktur_jual='FJ-260705-0028' 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-260705-0029','kasirbip','1',' DP-02291BI','TOKO','BIPPSN','PSPRT-ZFAX-32-0','CINCIN PERAK YL-10 ','','4.400','1','100.00','450000','0','0','17800','1000000','0','0','0','1000000','SULIS','00044137','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFAX-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.400',berat_jual_asli=berat_jual_asli+'4.400',stock_jual='1',berat_akhir=berat_akhir-'4.400',berat_akhir_asli=berat_akhir_asli-'4.400',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSPRT-ZFAX-32-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-260705-0029','2026-07-05','4.400','2026-07-05','19:16:50','PLG0012870','1000000','1000000','0','1000000','0','kasirbip','2026-07-05 19:16:49','FJ-260705-0029','DP-02291','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-07-05','FJ-260705-0029','2026-07-05','19:16:50','SULIS','1000000','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-260705-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-260705-0030','kasirbip',' 1',' DP-02290BI','TOKO','BIPPSN','PSPLT-ZFBI-49-0','CINCIN PALADIUM ','','2.620','1','17.00','589000','0','0','17800','1667000','0','0','0','1667000','SULIS','00044840','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBI-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PSPLT-ZFBI-49-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-260705-0030','2026-07-05','2.620','2026-07-05','19:16:50','PLG0012871','1667000','1667000','0','1667000','0','kasirbip','2026-07-05 19:16:49','FJ-260705-0029','DP-02290','1440000');
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-07-05','FJ-260705-0030','2026-07-05','19:16:50','SULIS','1667000','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-260705-0048','2026-07-05','2026-07-05 19:16:49','PENJUALAN : FJ-260705-0030','.','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-260705-0049','D','2026-07-05','19:16:50','TBC','PENJUALAN','FJ-260705-0030','24571394564','227000','24571621564','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='227000' WHERE no_faktur_jual='FJ-260705-0030' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0029';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0030';
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-02801','VAN','1','PER','WEDDRING SEPAKET','','','3.000','','925.00','1','100000','0','1600000','0','1600000','SIZE WANITA: 13 SIZE PRIA: 17','GRF WANITA: Alfian GRF PRIA: Intan','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-260705-0049','2026-07-05','2026-07-05 19:24:24','PESANAN : DP-02801','-','TBC','1600000','1600000');
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-260705-0050','D','2026-07-05','19:24:24','TBC','PESANAN','DP-02801','24571621564','1600000','24573221564','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-02801','2026-07-05','2026-07-05','19:24:24','PLG0012872','VAN','2026-07-28','sby','2026-07-05 19:24:24','3.000','0','0','0','1600000','0','0','1600000','1600000','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-02802','SAL','1','GOLD','WED RING','','','2.500','','37.50','1','2370000','1400000','0','900000','4400000','sz 13.5 putih glosy 21 zirkon','font vladimir grf Ivan Apriansyah . . .','model sprt contoh','210000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0050','2026-07-05','2026-07-05 19:41:13','PESANAN : DP-02802','.','TBC','3688000','3688000');
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-260705-0051','D','2026-07-05','19:41:13','TBC','PESANAN','DP-02802','24573221564','3688000','24576909564','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-02802','2026-07-05','2026-07-05','19:41:13','PLG0012873','SAL','2026-08-02','kasirbip','2026-07-05 19:41:13','2.500','0','0','0','3688000','0','900000','4610000','4610000','922000');
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-02803','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','1050000','0','1050000','sz 16.5 putih glosy 20 zirkon','font vladimir grf Teti Rahmawati . .','model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0051','2026-07-05','2026-07-05 19:43:09','PESANAN : DP-02803','.','TBC','1050000','1050000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260705-0052','D','2026-07-05','19:43:09','TBC','PESANAN','DP-02803','24576909564','1050000','24577959564','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-02803','2026-07-05','2026-07-05','19:43:09','PLG0012874','SAL','2026-08-02','kasirbip','2026-07-05 19:43:09','3.000','0','0','0','1050000','0','0','1050000','1050000','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-260705-0031','kasir','1',' 750K-21-10','TOKO','MMPER','PMM-ZFAG-15-0','CINCIN SILVER 925 ','','3.310','1','100.00','338000','0','0','17800','850000','0','0','0','850000','ALIKA','00044501','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFAG-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.310',berat_jual_asli=berat_jual_asli+'3.310',stock_jual='1',berat_akhir=berat_akhir-'3.310',berat_akhir_asli=berat_akhir_asli-'3.310',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PMM-ZFAG-15-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-260705-0031','2026-07-05','3.310','2026-07-05','19:54:32','PLG0012875','850000','850000','0','850000','0','kasir','2026-07-05 19:54:32','FJ-260705-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-07-05','FJ-260705-0031','2026-07-05','19:54:32','ALIKA','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260705-0052','2026-07-05','2026-07-05 19:54:32','PENJUALAN : FJ-260705-0031','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-260705-0053','D','2026-07-05','19:54:32','TBC','PENJUALAN','FJ-260705-0031','24577959564','850000','24578809564','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-260705-0031' 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-02804','DIL','1','PLD','WEDD RING PRIA','','','3.500','','25.00','1','1200000','550000','0','750000','2675000','SIZE 21.5 GRF : Nia ?? Aldo (vintage)','CROM PUTIH GLOSSY MIX DOFF','','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-260705-0053','2026-07-05','2026-07-05 20:18:30','PESANAN : DP-02804','-','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-260705-0054','D','2026-07-05','20:18:30','TBC','PESANAN','DP-02804','24578809564','1800000','24580609564','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-02804','2026-07-05','2026-07-05','20:18:30','PLG0012876','DIL','2026-08-05','sby','2026-07-05 20:18:30','3.500','0','0','0','1800000','0','750000','2675000','2675000','875000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-05 ','20:19:10');
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-260705-0032','kasirbip','1',' 750K-18-27','TOKO','BIPPER','PBDG-ZFAF-19-0','CINCIN SILVER 925 ','','3.260','1','100.00','333000','0','0','17800','850000','0','0','0','850000','SULIS','00044449','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFAF-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.260',berat_jual_asli=berat_jual_asli+'3.260',stock_jual='1',berat_akhir=berat_akhir-'3.260',berat_akhir_asli=berat_akhir_asli-'3.260',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='PBDG-ZFAF-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-260705-0032','2026-07-05','3.260','2026-07-05','20:20:21','PLG0012877','850000','850000','0','850000','0','kasirbip','2026-07-05 20:20:21','FJ-260705-0032','','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-07-05','FJ-260705-0032','2026-07-05','20:20:21','SULIS','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260705-0054','2026-07-05','2026-07-05 20:20:21','PENJUALAN : FJ-260705-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-260705-0055','D','2026-07-05','20:20:21','TBC','PENJUALAN','FJ-260705-0032','24580609564','850000','24581459564','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-260705-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-02805','DIL','1','GOLD','WEDD RING WANITA','','','2.500','','75.00','1','2370000','2250000','0','850000','6475000','PERMATA 22 BUTIR','SIZE 13.5 GRF: Aldo ?? Nia (vintage)','EMAS PUTIH','220000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0055','2026-07-05','2026-07-05 20:20:50','PESANAN : DP-02805','-','TBC','4700000','4700000');
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-260705-0056','D','2026-07-05','20:20:50','TBC','PESANAN','DP-02805','24581459564','4700000','24586159564','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-02805','2026-07-05','2026-07-05','20:20:50','PLG0012878','DIL','2026-08-05','sby','2026-07-05 20:20:50','2.500','0','0','0','4700000','0','850000','6695000','6695000','1995000');
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-02806','SULIS','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','700000','1400000','putih glosy sz 12','font yeseva one','grf IRPAN & RESSY','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0056','2026-07-05','2026-07-05 20:23:27','PESANAN : DP-02806','.','TBC','1120000','1120000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260705-0057','D','2026-07-05','20:23:27','TBC','PESANAN','DP-02806','24586159564','1120000','24587279564','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-02806','2026-07-05','2026-07-05','20:23:27','PLG0012879','SULIS','2026-07-16','kasirbip','2026-07-05 20:23:27','2.000','0','0','0','1120000','0','700000','1400000','1400000','280000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02159','SULIS','1','CC SILVER','SZ 19 PUTIH DOFF SEMPROT FONT YESEVA ONE GRF','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-02159','2026-07-05','2026-07-05','20:25:10','PLG0012880','kasirbip','2026-07-14','kasirbip','2026-07-05 20:25:10','3.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-05 ','20:25:31');
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-02807','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 22 putih doff semprot','font vintage rotter grf Nadhifa','model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0057','2026-07-05','2026-07-05 20:44:23','PESANAN : DP-02807','.','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-260705-0058','D','2026-07-05','20:44:23','TBC','PESANAN','DP-02807','24587279564','850000','24588129564','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-02807','2026-07-05','2026-07-05','20:44:23','PLG0012881','SAL','2026-08-02','kasirbip','2026-07-05 20:44:23','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02808','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 9.5 putih doff amplas 1 zirkon','font vintage rotter grf Marcel','model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260705-0058','2026-07-05','2026-07-05 20:45:55','PESANAN : DP-02808','.','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-260705-0059','D','2026-07-05','20:45:55','TBC','PESANAN','DP-02808','24588129564','850000','24588979564','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-02808','2026-07-05','2026-07-05','20:45:55','PLG0012882','SAL','2026-08-02','kasirbip','2026-07-05 20:45:55','3.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260705-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260705-0032';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-05';
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-07-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-05' 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-260706-0001','D','2026-07-06','21:32:46','TBC','SALDO AWAL','SALDO AWAL','0','24588979564','24588979564');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260706-0001','D','2026-07-06','21:32:46','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260706-0001','D','2026-07-06','21:32:46','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-260706-0001','D','2026-07-06','21:32:46','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-260706-0001','D','2026-07-06','21:32:46','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-260706-0001','D','2026-07-06','21:32:46','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-260706-0001','D','2026-07-06','21:32:46','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-260706-0001','D','2026-07-06','21:32:46','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-260706-0001','D','2026-07-06','21:32:46','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-260706-0001','D','2026-07-06','21:32:46','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-260706-0001','D','2026-07-06','21:32:46','','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-260706-0001','D','2026-07-06','21:32:46','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
UPDATE tp_system SET tgl_system='2026-07-06';