INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-05 ','08:48:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-05 ','09:18:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-05 ','09:29:53');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-05 ','09:31:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-05 ','10:11:49');
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-04404','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 14.5 putih glosy','font vladimir grf Ittaqi ...','model spt contoh','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0001','2026-10-05','2026-10-05 10:16:05','PESANAN : DP-04404','.','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-261005-0002','D','2026-10-05','10:16:05','TBC','PESANAN','DP-04404','28898694464','900000','28899594464','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-04404','2026-10-05','2026-10-05','10:16:05','PLG0016940','SULIS','2026-10-27','kasirbip','2026-10-05 10:16:05','2.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04405','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 9.5 putih glosy','font vladimir grf Bashir ...','model spt contoh','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0002','2026-10-05','2026-10-05 10:18:40','PESANAN : DP-04405','.','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-261005-0003','D','2026-10-05','10:18:40','TBC','PESANAN','DP-04405','28899594464','900000','28900494464','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-04405','2026-10-05','2026-10-05','10:18:40','PLG0016941','SULIS','2026-10-27','kasirbip','2026-10-05 10:18:40','2.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-05 ','10:22:23');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04406','PUT','1','PER','WEDRING','','','3.500','','925.00','1','100000','0','950000','0','950000','sz cwe 13.5 SR.03 grf Pian .....','sz cwo 21.5 YL.01 grf Rina .....','font Comic sans','0','100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0003','2026-10-05','2026-10-05 10:25:30','PESANAN : DP-04406','.','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-261005-0004','D','2026-10-05','10:25:30','TBC','PESANAN','DP-04406','28900494464','1050000','28901544464','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-04406','2026-10-05','2026-10-05','10:25:30','PLG0016942','PUT','2026-10-23','kasirbip','2026-10-05 10:25:30','3.500','0','0','0','1050000','0','0','1050000','1050000','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-04407','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','850000','0','850000','sz 17 crom putih glosy tanpa list','grf Nanda 07-04-2018','font Brush','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-261005-0004','2026-10-05','2026-10-05 10:42:24','PESANAN : DP-04407','.','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-261005-0005','D','2026-10-05','10:42:24','TBC','PESANAN','DP-04407','28901544464','850000','28902394464','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-04407','2026-10-05','2026-10-05','10:42:24','PLG0016943','PUT','2026-10-25','kasirbip','2026-10-05 10:42:24','4.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-05 ','11:05:08');
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-261005-0001','kasirbip','1',' DP-03946DU','TOKO','DUPSN','PSPLT-ZJXB-17-0','CINCIN PALADIUM ','','3.000','1','17.00','674000','0','0','17800','1800000','0','0','0','1800000','PUT','00047836','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXB-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPLT-ZJXB-17-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-261005-0001','2026-10-05','3.000','2026-10-05','11:11:04','PLG0016944','1800000','1800000','0','1800000','0','kasirbip','2026-10-05 11:11:03','FJ-261005-0001','DP-03946','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-10-05','FJ-261005-0001','2026-10-05','11:11:04','PUT','1800000','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-261005-0005','2026-10-05','2026-10-05 11:11:03','PENJUALAN : FJ-261005-0001','.','TBC','360000','360000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0006','D','2026-10-05','11:11:04','TBC','PENJUALAN','FJ-261005-0001','28902394464','360000','28902754464','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='360000' WHERE no_faktur_jual='FJ-261005-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-261005-0002','kasirbip',' 1',' DP-03945DU','TOKO','DUPSN','PSPLT-ZJXB-61-0','CINCIN PALADIUM ','','1.950','1','17.00','438000','0','0','17800','1382500','0','0','0','1382500','PUT','00047880','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXB-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPLT-ZJXB-61-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-261005-0002','2026-10-05','1.950','2026-10-05','11:11:04','PLG0016945','1382500','1382500','0','1382500','0','kasirbip','2026-10-05 11:11:03','FJ-261005-0001','DP-03945','1160000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-05','FJ-261005-0002','2026-10-05','11:11:04','PUT','1382500','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-261005-0006','2026-10-05','2026-10-05 11:11:03','PENJUALAN : FJ-261005-0002','.','TBC','222500','222500','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-261005-0007','D','2026-10-05','11:11:04','TBC','PENJUALAN','FJ-261005-0002','28902754464','222500','28902976964','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='582500' WHERE no_faktur_jual='FJ-261005-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-05 ','12:24:13');
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-04408','SAL','1','GOLD','WED RING','','','3.000','','75.00','1','2300000','2250000','0','950000','7700000','sz 14 putih glosy 1 mata kotak','14 zircon kecil font vintage rotter','grf Aldy & Marsya','200000','140000','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0007','2026-10-05','2026-10-05 12:41:25','PESANAN : DP-04408','.','TBC','6432000','6432000');
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-261005-0008','D','2026-10-05','12:41:25','TBC','PESANAN','DP-04408','28902976964','6432000','28909408964','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-04408','2026-10-05','2026-10-05','12:41:25','PLG0016946','SAL','2026-11-05','kasirbip','2026-10-05 12:41:25','3.000','0','0','0','6432000','0','950000','8040000','8040000','1608000');
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-04409','SAL','1','PLD','WED RING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','sz 21 putih doff semprot 1 zircon','font vladimir grf Aldy & Marsya','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0008','2026-10-05','2026-10-05 12:45:58','PESANAN : DP-04409','.','TBC','1580000','1580000');
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-261005-0009','D','2026-10-05','12:45:58','TBC','PESANAN','DP-04409','28909408964','1580000','28910988964','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-04409','2026-10-05','2026-10-05','12:45:58','PLG0016947','SAL','2026-11-05','kasirbip','2026-10-05 12:45:58','3.500','0','0','0','1580000','0','750000','1975000','1975000','395000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02280','SAL','1','CC SILVER','PUTIH DOFF SEMPROT','3.000','1','50000','50000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261005-0009','2026-10-05','2026-10-05 12:50:49','SERVICE : SV-02280','.','TBC','50000','50000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0010','D','2026-10-05','12:50:49','TBC','SERVICE','SV-02280','28910988964','50000','28911038964','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-02280','2026-10-05','2026-10-05','12:50:49','PLG0016948','kasirbip','2026-10-20','kasirbip','2026-10-05 12:50:49','3.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-05 ','12:51:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-05 ','12:51: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-04410','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','700000','2900000','SIZE: 18.5','GRF: Alip Dila 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-261005-0010','2026-10-05','2026-10-05 12:54:14','PESANAN : DP-04410','-','TBC','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0011','D','2026-10-05','12:54:14','TBC','PESANAN','DP-04410','28911038964','2000000','28913038964','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-04410','2026-10-05','2026-10-05','12:54:14','PLG0016949','VAN','2026-10-28','sby','2026-10-05 12:54:14','4.000','0','0','0','2000000','0','700000','2900000','2900000','900000');
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-261005-0003','kasirbip','1',' DP-03996BI','TOKO','BIPPSN','PSPRT-ZJXB-10-0','CINCIN PERAK YL01 ','','3.080','1','100.00','315000','0','0','17800','850000','0','0','0','850000','SAL','00047829','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXB-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPRT-ZJXB-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-261005-0003','2026-10-05','3.080','2026-10-05','12:57:47','PLG0016950','850000','850000','0','850000','0','kasirbip','2026-10-05 12:57:46','FJ-261005-0003','DP-03996','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-10-05','FJ-261005-0003','2026-10-05','12:57:47','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-261005-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-261005-0004','jogja','1',' DP-04249JO','TOKO','JOGPSN','PSPLT-ZJXB-22-0','CINCIN PALADIUM ','','2.170','1','32.00','917000','0','0','17800','1193500','0','800000','0','1993500','ADL','00047841','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXB-22-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-10-05' AND kode_barang='PSPLT-ZJXB-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-261005-0004','2026-10-05','2.170','2026-10-05','13:11:02','PLG0016951','1193500','1193500','800000','1993500','0','jogja','2026-10-05 13:11:01','FJ-261005-0004','DP-04249','1520000');
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-10-05','FJ-261005-0004','2026-10-05','13:11:02','ADL','1993500','800000');
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-261005-0011','2026-10-05','2026-10-05 13:11:01','PENJUALAN : FJ-261005-0004','','TBC','473500','473500','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-261005-0012','D','2026-10-05','13:11:02','TBC','PENJUALAN','FJ-261005-0004','28913038964','473500','28913512464','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='473500' WHERE no_faktur_jual='FJ-261005-0004' 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-261005-0005','jogja',' 1',' DP-04251JO','TOKO','JOGPSN','PSPLT-ZJXB-63-0','CINCIN PALADIUM ','','2.410','1','17.00','542000','0','0','17800','843500','0','750000','0','1593500','ADL','00047882','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXB-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPLT-ZJXB-63-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-261005-0005','2026-10-05','2.410','2026-10-05','13:11:02','PLG0016952','843500','843500','750000','1593500','0','jogja','2026-10-05 13:11:01','FJ-261005-0004','DP-04251','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-10-05','FJ-261005-0005','2026-10-05','13:11:02','ADL','1593500','750000');
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-261005-0012','2026-10-05','2026-10-05 13:11:01','PENJUALAN : FJ-261005-0005','','TBC','293500','293500','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-261005-0013','D','2026-10-05','13:11:02','TBC','PENJUALAN','FJ-261005-0005','28913512464','293500','28913805964','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='767000' WHERE no_faktur_jual='FJ-261005-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0005';
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-04411','PUT','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','sz cwe 12.5 ctlg LX-75 jngn lbih 2.5gr','jngan trlalu tebal . zircon 12','grf Nabhan Afif font Vintage','0','120000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0013','2026-10-05','2026-10-05 13:56:32','PESANAN : DP-04411','.','TBC','1396000','1396000');
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-261005-0014','D','2026-10-05','13:56:32','TBC','PESANAN','DP-04411','28913805964','1396000','28915201964','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-04411','2026-10-05','2026-10-05','13:56:32','PLG0016953','PUT','2026-10-25','kasirbip','2026-10-05 13:56:32','2.500','0','0','0','1396000','0','750000','1745000','1745000','349000');
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-04412','PUT','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','sz cwo 16.5 ctlg LX-75 jngn lbih 3gr','jngan terlalu tebal','grf Gina Widyanti font Vintage','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0014','2026-10-05','2026-10-05 13:59:57','PESANAN : DP-04412','.','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-261005-0015','D','2026-10-05','13:59:57','TBC','PESANAN','DP-04412','28915201964','1400000','28916601964','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-04412','2026-10-05','2026-10-05','13:59:57','PLG0016954','PUT','2026-10-25','kasirbip','2026-10-05 13:59:57','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-261005-0006','kasirbip','1',' 700K-15-10','TOKO','BIPPER','PBDG-YDBD-8-0','CINCIN SILVER 925 ','','3.510','1','100.00','82000','0','0','17800','800000','0','0','0','800000','KUR','00035228','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YDBD-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PBDG-YDBD-8-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-261005-0006','2026-10-05','3.510','2026-10-05','14:00:48','PLG0016955','800000','800000','0','800000','0','kasirbip','2026-10-05 14:00:47','FJ-261005-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-05','FJ-261005-0006','2026-10-05','14:00:48','KUR','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261005-0015','2026-10-05','2026-10-05 14:00:47','PENJUALAN : FJ-261005-0006','.','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-261005-0016','D','2026-10-05','14:00:48','TBC','PENJUALAN','FJ-261005-0006','28916601964','800000','28917401964','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-261005-0006' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261005-0007','kasirbip',' 1',' 750K-11-28','TOKO','BIPPER','PBDG-ZGAF-9-0','CINCIN SILVER 925 ','','1.940','1','100.00','198000','0','0','17800','950000','0','0','0','950000','KUR','00045227','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGAF-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PBDG-ZGAF-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261005-0007','2026-10-05','1.940','2026-10-05','14:00:48','PLG0016956','950000','950000','0','950000','0','kasirbip','2026-10-05 14:00:47','FJ-261005-0006','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-05','FJ-261005-0007','2026-10-05','14:00:48','KUR','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-261005-0016','2026-10-05','2026-10-05 14:00:47','PENJUALAN : FJ-261005-0007','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0017','D','2026-10-05','14:00:48','TBC','PENJUALAN','FJ-261005-0007','28917401964','950000','28918351964','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-261005-0007' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02281','KUR','1','1 PS CINCIN SILVER','KROM ULANG DOF SEMPROT GRF FONT BERKSHIRE SWASH','5.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02281','2026-10-05','2026-10-05','14:15:37','PLG0016957','kasirbip','2026-10-14','kasirbip','2026-10-05 14:15:37','5.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261005-0001','1','PSPRT-ZJXE-1-0','1','4.940','4.940','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXE-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXE-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXE-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXE-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-05 14:24:14' WHERE kode_barang='PSPRT-ZJXE-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXE-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-05 14:24:14','TOKO','DUPSN','PSPRT','PSPRT-ZJXE-1-0','1','4.940','4.940','1','4.940','4.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJXE-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXE-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-05' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261005-0001','1','PSPRT-ZJXE-2-0','1','2.180','2.180','TOKO','DUPSN','TOKO','DUPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXE-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXE-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXE-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXE-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-05 14:24:14' WHERE kode_barang='PSPRT-ZJXE-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXE-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-05 14:24:14','TOKO','DUPSN','PSPRT','PSPRT-ZJXE-2-0','1','2.180','2.180','1','2.180','2.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJXE-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXE-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-10-05' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261005-0001','2026-10-05','14:23','7.120','kasirbip','2026-10-05 14:24:13');
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-04413','SAL','1','PLD','WED RING','','','2.000','','25.00','1','1200000','550000','0','850000','1950000','sz 10 putih glosy 1 zircon','font times new roman grf Taufik ...','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0017','2026-10-05','2026-10-05 14:25:05','PESANAN : DP-04413','.','TBC','1560000','1560000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0018','D','2026-10-05','14:25:05','TBC','PESANAN','DP-04413','28918351964','1560000','28919911964','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-04413','2026-10-05','2026-10-05','14:25:05','PLG0016958','SAL','2026-11-03','kasirbip','2026-10-05 14:25:05','2.000','0','0','0','1560000','0','850000','1950000','1950000','390000');
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-04414','SAL','1','PLD','WED RING','','','2.500','','25.00','1','1200000','550000','0','500000','1875000','sz 16 putih doff amplas','font times new roman grf Risa ...','YL-01','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0018','2026-10-05','2026-10-05 14:26:33','PESANAN : DP-04414','.','TBC','1500000','1500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0019','D','2026-10-05','14:26:33','TBC','PESANAN','DP-04414','28919911964','1500000','28921411964','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-04414','2026-10-05','2026-10-05','14:26:33','PLG0016959','SAL','2026-11-03','kasirbip','2026-10-05 14:26:33','2.500','0','0','0','1500000','0','500000','1875000','1875000','375000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-05 ','14:35:18');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-05 ','14:36:53');
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-261005-0008','sby','1',' DP-03954SB','TOKO','SBYPSN','PSPLT-ZIBI-30-0','CINCIN PALADIUM ','','3.360','1','17.00','755000','0','0','17800','1776000','0','0','0','1776000','VAN','00047769','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBI-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.360',berat_jual_asli=berat_jual_asli+'3.360',stock_jual='1',berat_akhir=berat_akhir-'3.360',berat_akhir_asli=berat_akhir_asli-'3.360',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPLT-ZIBI-30-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-261005-0008','2026-10-05','3.360','2026-10-05','14:40:35','PLG0016960','1776000','1776000','0','1776000','0','sby','2026-10-05 14:40:34','FJ-261005-0008','DP-03954','1500000');
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-10-05','FJ-261005-0008','2026-10-05','14:40:35','VAN','1776000','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-261005-0019','2026-10-05','2026-10-05 14:40:34','PENJUALAN : FJ-261005-0008','','TBC','276000','276000','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-261005-0020','D','2026-10-05','14:40:35','TBC','PENJUALAN','FJ-261005-0008','28921411964','276000','28921687964','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='276000' WHERE no_faktur_jual='FJ-261005-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261005-0009','sby',' 1',' DP-03955SB','TOKO','SBYPSN','PSGT-ZICX-19-0','CINCIN EMAS ','','1.850','1','45.00','1954000','0','0','17800','3350000','0','0','0','3350000','VAN','00047805','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZICX-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSGT-ZICX-19-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-261005-0009','2026-10-05','1.850','2026-10-05','14:40:35','PLG0016961','3350000','3350000','0','3350000','0','sby','2026-10-05 14:40:34','FJ-261005-0008','DP-03955','2500000');
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-10-05','FJ-261005-0009','2026-10-05','14:40:35','VAN','3350000','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-261005-0020','2026-10-05','2026-10-05 14:40:34','PENJUALAN : FJ-261005-0009','','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-261005-0021','D','2026-10-05','14:40:35','TBC','PENJUALAN','FJ-261005-0009','28921687964','850000','28922537964','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='1126000' WHERE no_faktur_jual='FJ-261005-0009' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-05 ','15:15:49');
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-261005-0010','sby','1',' DP-04041SB','TOKO','SBYPSN','PSGT-ZJXB-21-0','CINCIN EMAS SR03 ','','2.050','1','57.00','2742000','0','0','17800','4450000','0','0','0','4450000','VAN','00047840','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXB-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSGT-ZJXB-21-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-261005-0010','2026-10-05','2.050','2026-10-05','15:25:30','PLG0016962','4450000','4450000','0','4450000','0','sby','2026-10-05 15:25:30','FJ-261005-0010','DP-04041','3600000');
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-10-05','FJ-261005-0010','2026-10-05','15:25:30','VAN','4450000','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-261005-0021','2026-10-05','2026-10-05 15:25:30','PENJUALAN : FJ-261005-0010','','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-261005-0022','D','2026-10-05','15:25:30','TBC','PENJUALAN','FJ-261005-0010','28922537964','850000','28923387964','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-261005-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-261005-0011','sby',' 1',' DP-04042SB','TOKO','SBYPSN','PSPLT-ZJXB-42-0','CINCIN PALADIUM ','','3.340','1','32.00','1412000','0','0','17800','2637000','0','0','0','2637000','VAN','00047861','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXB-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.340',berat_jual_asli=berat_jual_asli+'3.340',stock_jual='1',berat_akhir=berat_akhir-'3.340',berat_akhir_asli=berat_akhir_asli-'3.340',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPLT-ZJXB-42-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-261005-0011','2026-10-05','3.340','2026-10-05','15:25:30','PLG0016963','2637000','2637000','0','2637000','0','sby','2026-10-05 15:25:30','FJ-261005-0010','DP-04042','2000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-05','FJ-261005-0011','2026-10-05','15:25:30','VAN','2637000','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-261005-0022','2026-10-05','2026-10-05 15:25:30','PENJUALAN : FJ-261005-0011','','TBC','637000','637000','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-261005-0023','D','2026-10-05','15:25:30','TBC','PENJUALAN','FJ-261005-0011','28923387964','637000','28924024964','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='1487000' WHERE no_faktur_jual='FJ-261005-0011' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-05 ','15:44: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-261005-0012','sby','1',' DP-03921SB','TOKO','SBYPSN','PSPRT-ZIBI-45-0','CINCIN PERAK ','','1.520','1','100.00','156000','0','0','17800','1000000','0','0','0','1000000','DIL','00047784','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBI-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPRT-ZIBI-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-261005-0012','2026-10-05','1.520','2026-10-05','15:46:28','PLG0016964','1000000','1000000','0','1000000','0','sby','2026-10-05 15:46:27','FJ-261005-0012','DP-03921','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-10-05','FJ-261005-0012','2026-10-05','15:46:28','DIL','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-261005-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-261005-0013','sby',' 1',' DP-03922SB','TOKO','SBYPSN','PSPRT-ZIBI-44-0','CINCIN PERAK ','','2.000','1','100.00','204000','0','0','17800','800000','0','0','0','800000','DIL','00047783','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIBI-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPRT-ZIBI-44-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-261005-0013','2026-10-05','2.000','2026-10-05','15:46:28','PLG0016965','800000','800000','0','800000','0','sby','2026-10-05 15:46:27','FJ-261005-0012','DP-03922','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-05','FJ-261005-0013','2026-10-05','15:46:28','DIL','800000','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-261005-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-261005-0014','jogja','1',' DP-04029JO','TOKO','JOGPSN','PSGT-ZJXB-65-0','CINCIN EMAS ','','2.900','1','45.00','3062000','0','0','17800','4560000','500000','1500000','0','6060000','ADL','00047884','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXB-65-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSGT-ZJXB-65-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-261005-0014','2026-10-05','2.900','2026-10-05','16:17:56','PLG0016966','4560000','4560000','1500000','6060000','0','jogja','2026-10-05 16:17:55','FJ-261005-0014','DP-04029','4960000');
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-10-05','FJ-261005-0014','2026-10-05','16:17:56','ADL','6060000','1500000');
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-261005-0023','2026-10-05','2026-10-05 16:17:55','PENJUALAN : FJ-261005-0014','','TBC','1100000','1100000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0024','D','2026-10-05','16:17:56','TBC','PENJUALAN','FJ-261005-0014','28924024964','1100000','28925124964','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='1100000' WHERE no_faktur_jual='FJ-261005-0014' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261005-0015','jogja',' 1',' DP-04030JO','TOKO','JOGPSN','PSPLT-ZICX-23-0','CINCIN PALADIUM ','','4.250','1','17.00','955000','0','0','17800','1487500','0','850000','0','2337500','ADL','00047809','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZICX-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.250',berat_jual_asli=berat_jual_asli+'4.250',stock_jual='1',berat_akhir=berat_akhir-'4.250',berat_akhir_asli=berat_akhir_asli-'4.250',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPLT-ZICX-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-261005-0015','2026-10-05','4.250','2026-10-05','16:17:56','PLG0016967','1487500','1487500','850000','2337500','0','jogja','2026-10-05 16:17:55','FJ-261005-0014','DP-04030','1884000');
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-10-05','FJ-261005-0015','2026-10-05','16:17:56','ADL','2337500','850000');
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-261005-0024','2026-10-05','2026-10-05 16:17:55','PENJUALAN : FJ-261005-0015','','TBC','453500','453500','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-261005-0025','D','2026-10-05','16:17:56','TBC','PENJUALAN','FJ-261005-0015','28925124964','453500','28925578464','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='1553500' WHERE no_faktur_jual='FJ-261005-0015' 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-04415','KUR','1','GOLD','WED RING','','','3.000','','37.50','1','2300000','1400000','0','1100000','5300000','sz 15 putih glosy 19 zirkon','font berkshire swash grf Alfu','','190000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0025','2026-10-05','2026-10-05 16:34:01','PESANAN : DP-04415','.','TBC','4390000','4390000');
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-261005-0026','D','2026-10-05','16:34:01','TBC','PESANAN','DP-04415','28925578464','4390000','28929968464','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-04415','2026-10-05','2026-10-05','16:34:01','PLG0016968','KUR','2026-10-26','kasirbip','2026-10-05 16:34:01','3.000','0','0','0','4390000','0','1100000','5490000','5490000','1100000');
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-04416','KUR','1','PLD','WED RING','','','5.000','','10.00','1','1200000','350000','0','800000','2550000','sz 21 putih doff amplas','font berkshireswash grf Triana','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0026','2026-10-05','2026-10-05 16:35:38','PESANAN : DP-04416','.','TBC','2040000','2040000');
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-261005-0027','D','2026-10-05','16:35:38','TBC','PESANAN','DP-04416','28929968464','2040000','28932008464','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-04416','2026-10-05','2026-10-05','16:35:38','PLG0016969','KUR','2026-10-26','kasirbip','2026-10-05 16:35:38','5.000','0','0','0','2040000','0','800000','2550000','2550000','510000');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02282','SULIS','1','SEPASANG SILVER','CWE SZ 16 PUTIH GLOSY CWO SZ 20 PUTIH DOFF SEMPROT TAMBAH BAHAN KEDUAMYA JGN DIBUAT TIPIS FONT VINTAGE ROTTER','4.000','1','250000','250000');
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-261005-0027','2026-10-05','2026-10-05 16:37:42','SERVICE : SV-02282','.','TBC','250000','250000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0028','D','2026-10-05','16:37:42','TBC','SERVICE','SV-02282','28932008464','250000','28932258464','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-02282','2026-10-05','2026-10-05','16:37:42','PLG0016970','kasirbip','2026-10-11','kasirbip','2026-10-05 16:37:42','4.000','0','0','0','250000','0','250000','250000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-05 ','16:38:02');
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-261005-0016','kasirbip','1',' 800K-16-29','TOKO','BIPPER','PBDG-ZIXD-12-0','CINCIN SILVER 925 ','','2.910','1','100.00','297000','0','0','17800','900000','0','0','0','900000','SULIS','00046875','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIXD-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.910',berat_jual_asli=berat_jual_asli+'2.910',stock_jual='1',berat_akhir=berat_akhir-'2.910',berat_akhir_asli=berat_akhir_asli-'2.910',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PBDG-ZIXD-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261005-0016','2026-10-05','2.910','2026-10-05','16:39:32','PLG0016971','900000','900000','0','900000','0','kasirbip','2026-10-05 16:39:32','FJ-261005-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-05','FJ-261005-0016','2026-10-05','16:39:32','SULIS','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261005-0028','2026-10-05','2026-10-05 16:39:32','PENJUALAN : FJ-261005-0016','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0029','D','2026-10-05','16:39:32','TBC','PENJUALAN','FJ-261005-0016','28932258464','900000','28933158464','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261005-0016' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261005-0017','kasirbip',' 1',' 850K-13-29','TOKO','BIPPER','PBDG-ZIXD-15-0','CINCIN SILVER 925 ','','1.290','1','100.00','132000','0','0','17800','950000','0','0','0','950000','SULIS','00046878','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIXD-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.290',berat_jual_asli=berat_jual_asli+'1.290',stock_jual='1',berat_akhir=berat_akhir-'1.290',berat_akhir_asli=berat_akhir_asli-'1.290',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PBDG-ZIXD-15-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-261005-0017','2026-10-05','1.290','2026-10-05','16:39:32','PLG0016972','950000','950000','0','950000','0','kasirbip','2026-10-05 16:39:32','FJ-261005-0016','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-05','FJ-261005-0017','2026-10-05','16:39:32','SULIS','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261005-0029','2026-10-05','2026-10-05 16:39:32','PENJUALAN : FJ-261005-0017','.','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-261005-0030','D','2026-10-05','16:39:32','TBC','PENJUALAN','FJ-261005-0017','28933158464','950000','28934108464','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-261005-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0017';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-05 ','16:40:56');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04417','ALIKA','1','PLD','WEDING RING','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','size 18','grf Dhira','crom bagian doff rosegold luar 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-261005-0030','2026-10-05','2026-10-05 16:56:12','PESANAN : DP-04417','.','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-261005-0031','D','2026-10-05','16:56:12','TBC','PESANAN','DP-04417','28934108464','1720000','28935828464','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-04417','2026-10-05','2026-10-05','16:56:12','PLG0016973','ALIKA','2026-10-30','kasir','2026-10-05 16:56:12','4.000','0','0','0','1720000','0','750000','2150000','2150000','430000');
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-04418','ALIKA','1','GOLD','WEDING RING','','','2.500','','75.00','1','2300000','2250000','0','1150000','6775000','size 9 grf Wahyu','crom kombinasi rosegold putih','zircone 39 btr','0','0','390000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0031','2026-10-05','2026-10-05 17:02:44','PESANAN : DP-04418','.','TBC','5732000','5732000');
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-261005-0032','D','2026-10-05','17:02:44','TBC','PESANAN','DP-04418','28935828464','5732000','28941560464','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-04418','2026-10-05','2026-10-05','17:02:44','PLG0016974','ALIKA','2026-10-30','kasir','2026-10-05 17:02:44','2.500','0','0','0','5732000','0','1150000','7165000','7165000','1433000');
UPDATE tt_service_head SET tgl_selesai='2026-10-05',  status ='DONE' WHERE no_service='SV-02257';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02257';
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-05',  status ='CLOS' WHERE no_service='SV-02257';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02257';
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-04419','PUT','1','PER','WEDRING','','','2.500','','925.00','1','100000','0','850000','0','850000','sz cwe 17 crom hitam glosy','grf Deri ....','font Berkshire','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0032','2026-10-05','2026-10-05 17:46:08','PESANAN : DP-04419','.','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-261005-0033','D','2026-10-05','17:46:08','TBC','PESANAN','DP-04419','28941560464','850000','28942410464','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-04419','2026-10-05','2026-10-05','17:46:08','PLG0016975','PUT','2026-10-27','kasirbip','2026-10-05 17:46:08','2.500','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04420','PUT','1','PER','WEDRING','','','3.500','','925.00','1','100000','0','850000','0','850000','sz cwo 25 crom hitam glosy','grf Dita ....','font Berkshire','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0033','2026-10-05','2026-10-05 17:48:52','PESANAN : DP-04420','.','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-261005-0034','D','2026-10-05','17:48:52','TBC','PESANAN','DP-04420','28942410464','850000','28943260464','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-04420','2026-10-05','2026-10-05','17:48:52','PLG0016976','PUT','2026-10-27','kasirbip','2026-10-05 17:48:52','3.500','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04421','ADL','1','PER','WEDDING RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz cwe 13','gf vintage : -In Aeternum-','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0034','2026-10-05','2026-10-05 17:51:58','PESANAN : DP-04421','-','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-261005-0035','D','2026-10-05','17:51:58','TBC','PESANAN','DP-04421','28943260464','850000','28944110464','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-04421','2026-10-05','2026-10-05','17:51:58','PLG0016977','ADL','2026-10-12','jogja','2026-10-05 17:51:58','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-04422','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','800000','0','800000','SIZE: 19','GRF: Azis(tanda infinity)Nia FONT: VINTAGE ROTTER','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-261005-0035','2026-10-05','2026-10-05 17:55:41','PESANAN : DP-04422','-','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-261005-0036','D','2026-10-05','17:55:41','TBC','PESANAN','DP-04422','28944110464','800000','28944910464','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-04422','2026-10-05','2026-10-05','17:55:41','PLG0016978','VAN','2026-10-15','sby','2026-10-05 17:55:41','3.000','0','0','0','800000','0','0','800000','800000','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-04423','ADL','1','PER','WEDDING RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz cwo 21','gf vintage : -In Aeternum-','warna blackbold','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-261005-0036','2026-10-05','2026-10-05 17:56:22','PESANAN : DP-04423','-','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-261005-0037','D','2026-10-05','17:56:22','TBC','PESANAN','DP-04423','28944910464','900000','28945810464','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-04423','2026-10-05','2026-10-05','17:56:22','PLG0016979','ADL','2026-10-12','jogja','2026-10-05 17:56:22','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-261005-0018','kasirbip','1',' DP-03910BI','TOKO','BIPPSN','PSGT-ZJXB-4-0','CINCIN EMAS ','','2.630','1','57.00','3517000','0','0','17800','5534000','0','0','0','5534000','SAL','00047823','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXB-4-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-10-05' AND kode_barang='PSGT-ZJXB-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261005-0018','2026-10-05','2.630','2026-10-05','18:00:58','PLG0016980','5534000','5534000','0','5534000','0','kasirbip','2026-10-05 18:00:57','FJ-261005-0018','DP-03910','4240000');
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-10-05','FJ-261005-0018','2026-10-05','18:00:58','SAL','5534000','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-261005-0037','2026-10-05','2026-10-05 18:00:57','PENJUALAN : FJ-261005-0018','.','TBC','1294000','1294000','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-261005-0038','D','2026-10-05','18:00:58','TBC','PENJUALAN','FJ-261005-0018','28945810464','1294000','28947104464','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='1294000' WHERE no_faktur_jual='FJ-261005-0018' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261005-0019','kasirbip',' 1',' DP-03908BI','TOKO','BIPPSN','PSPLT-ZJXB-57-0','CINCIN PALADIUM ','','3.490','1','17.00','784000','0','0','17800','1921500','0','0','0','1921500','SAL','00047876','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXB-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.490',berat_jual_asli=berat_jual_asli+'3.490',stock_jual='1',berat_akhir=berat_akhir-'3.490',berat_akhir_asli=berat_akhir_asli-'3.490',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPLT-ZJXB-57-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-261005-0019','2026-10-05','3.490','2026-10-05','18:00:58','PLG0016981','1921500','1921500','0','1921500','0','kasirbip','2026-10-05 18:00:57','FJ-261005-0018','DP-03908','1540000');
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-10-05','FJ-261005-0019','2026-10-05','18:00:58','SAL','1921500','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-261005-0038','2026-10-05','2026-10-05 18:00:57','PENJUALAN : FJ-261005-0019','.','TBC','381500','381500','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-261005-0039','D','2026-10-05','18:00:58','TBC','PENJUALAN','FJ-261005-0019','28947104464','381500','28947485964','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='1675500' WHERE no_faktur_jual='FJ-261005-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-04424','MIL','1','PLD','WEDRING','','','2.000','','10.00','1','1200000','350000','0','900000','1600000','sz cwe 11 crom putih glosy','zircon 14','grf Ilhamdi 21.11.26 font Yeseva','0','140000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0039','2026-10-05','2026-10-05 18:22:05','PESANAN : DP-04424','.','TBC','1392000','1392000');
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-261005-0040','D','2026-10-05','18:22:05','TBC','PESANAN','DP-04424','28947485964','1392000','28948877964','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-04424','2026-10-05','2026-10-05','18:22:05','PLG0016982','MIL','2026-10-27','kasirbip','2026-10-05 18:22:05','2.000','0','0','0','1392000','0','900000','1740000','1740000','348000');
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-04425','MIL','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','900000','1950000','sz cwo 16 crom putih glosy','zircon 10','grf Syafiera 21.11.26 font Yeseva','0','100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0040','2026-10-05','2026-10-05 18:24:10','PESANAN : DP-04425','.','TBC','1640000','1640000');
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-261005-0041','D','2026-10-05','18:24:10','TBC','PESANAN','DP-04425','28948877964','1640000','28950517964','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-04425','2026-10-05','2026-10-05','18:24:10','PLG0016983','MIL','2026-10-27','kasirbip','2026-10-05 18:24:10','3.000','0','0','0','1640000','0','900000','2050000','2050000','410000');
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-04426','PUT','1','GOLD','WEDRING','','','3.500','','50.00','1','2300000','1800000','0','900000','7200000','sz cwe 10.5 crom putih glosy','grf Andrew & Lani font Brush Script','zircon 19. jngn lbih 3.5gr','0','0','190000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261005-0041','2026-10-05','2026-10-05 19:02:58','PESANAN : DP-04426','.','TBC','5912000','5912000');
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-261005-0042','D','2026-10-05','19:02:58','TBC','PESANAN','DP-04426','28950517964','5912000','28956429964','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-04426','2026-10-05','2026-10-05','19:02:58','PLG0016984','PUT','2026-10-27','kasirbip','2026-10-05 19:02:58','3.500','0','0','0','5912000','0','900000','7390000','7390000','1478000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-05 ','19:14:26');
UPDATE tm_credit_card SET nama_customer='-',no_ktp='',alamat1='' ,alamat2='' ,kota= '' ,no_telp='',tgl_valid_until='',tgl_last_gesek='2026-10-05 19:15:46' WHERE id_card = '-';
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-261005-0020','sby','1',' 800K-155-0','TOKO','SBYPER','PSBY-ZIXG-33-0','CINCIN SILVER 925 ','','2.800','1','100.00','286000','0','0','17800','900000','0','0','0','900000','DIL','00047000','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZIXG-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.800',berat_jual_asli=berat_jual_asli+'2.800',stock_jual='1',berat_akhir=berat_akhir-'2.800',berat_akhir_asli=berat_akhir_asli-'2.800',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSBY-ZIXG-33-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-261005-0020','2026-10-05','2.800','2026-10-05','19:15:50','PLG0016985','900000','900000','0','900000','0','sby','2026-10-05 19:15:49','FJ-261005-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-10-05','FJ-261005-0020','2026-10-05','19:15:50','DIL','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-261005-0042','2026-10-05','2026-10-05 19:15:49','PENJUALAN : FJ-261005-0020','','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261005-0043','D','2026-10-05','19:15:50','TBC','PENJUALAN','FJ-261005-0020','28956429964','900000','28957329964','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261005-0020' 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-04427','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cewe 13 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-261005-0043','2026-10-05','2026-10-05 19:25:28','PESANAN : DP-04427','.','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-261005-0044','D','2026-10-05','19:25:28','TBC','PESANAN','DP-04427','28957329964','950000','28958279964','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-04427','2026-10-05','2026-10-05','19:25:28','PLG0016986','MIL','2026-10-27','kasirbip','2026-10-05 19:25:28','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-05 ','19:28:51');
UPDATE tt_service_head SET tgl_selesai='2026-10-05',  status ='DONE' WHERE no_service='SV-02272';
UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02272';
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-04428','MIL','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','950000','0','950000','sz cowo 16 crom putih doff amplas','YL 10','','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-261005-0044','2026-10-05','2026-10-05 19:29:07','PESANAN : DP-04428','.','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-261005-0045','D','2026-10-05','19:29:07','TBC','PESANAN','DP-04428','28958279964','950000','28959229964','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-04428','2026-10-05','2026-10-05','19:29:07','PLG0016987','MIL','2026-10-27','kasirbip','2026-10-05 19:29:07','4.000','0','0','0','950000','0','0','950000','950000','0');
UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-05',  status ='CLOS' WHERE no_service='SV-02272';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0020';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-05 ','20:19:55');
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-261005-0021','sby','1',' DP-04009SB','TOKO','SBYPSN','PSPLT-ZJXB-48-0','CINCIN PALADIUM ','','3.780','1','32.00','1598000','0','0','17800','2879000','0','0','0','2879000','VAN','00047867','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-10-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXB-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.780',berat_jual_asli=berat_jual_asli+'3.780',stock_jual='1',berat_akhir=berat_akhir-'3.780',berat_akhir_asli=berat_akhir_asli-'3.780',stock_akhir='0' WHERE tanggal='2026-10-05' AND kode_barang='PSPLT-ZJXB-48-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-261005-0021','2026-10-05','3.780','2026-10-05','20:22:26','PLG0016988','2879000','2879000','0','2879000','0','sby','2026-10-05 20:22:25','FJ-261005-0021','DP-04009','2000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-05','FJ-261005-0021','2026-10-05','20:22:26','VAN','2879000','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-261005-0045','2026-10-05','2026-10-05 20:22:25','PENJUALAN : FJ-261005-0021','','TBC','879000','879000','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-261005-0046','D','2026-10-05','20:22:26','TBC','PENJUALAN','FJ-261005-0021','28959229964','879000','28960108964','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='879000' WHERE no_faktur_jual='FJ-261005-0021' 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-04429','DIL','1','PER','WEDD RING PRIA','','','4.000','','925.00','1','100000','0','900000','0','900000','SIZE 26 GRF: Z ?? D (YASEVA)','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-261005-0046','2026-10-05','2026-10-05 20:47:45','PESANAN : DP-04429','-','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-261005-0047','D','2026-10-05','20:47:45','TBC','PESANAN','DP-04429','28960108964','900000','28961008964','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-04429','2026-10-05','2026-10-05','20:47:45','PLG0016989','DIL','2026-10-28','sby','2026-10-05 20:47:45','4.000','0','0','0','900000','0','0','900000','900000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261005-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261005-0021';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-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-10-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
UPDATE tt_barang_saldo SET tanggal= '2026-10-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-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-261006-0001','D','2026-10-06','21:10:10','TBC','SALDO AWAL','SALDO AWAL','0','28961008964','28961008964');
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-261006-0001','D','2026-10-06','21:10:10','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-261006-0001','D','2026-10-06','21:10:10','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-261006-0001','D','2026-10-06','21:10:10','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-261006-0001','D','2026-10-06','21:10:10','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-261006-0001','D','2026-10-06','21:10:10','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-261006-0001','D','2026-10-06','21:10:10','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-261006-0001','D','2026-10-06','21:10:10','','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-261006-0001','D','2026-10-06','21:10:10','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-261006-0001','D','2026-10-06','21:10:10','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261006-0001','D','2026-10-06','21:10:10','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000');
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-261006-0001','D','2026-10-06','21:10:10','BCD','SALDO AWAL','SALDO AWAL','0','1465961500','1465961500');
UPDATE tp_system SET tgl_system='2026-10-06';