INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-19 ','10:22: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-260719-0001','kasirbip','1',' DP-02763BI','TOKO','BIPPSN','PSPRT-ZGAF-29-0','CINCIN PERAK ','','3.000','1','100.00','306000','0','0','17800','900000','0','0','0','900000','SAL','00045247','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAF-29-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-07-19' AND kode_barang='PSPRT-ZGAF-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0001','2026-07-19','3.000','2026-07-19','10:24:09','PLG0013345','900000','900000','0','900000','0','kasirbip','2026-07-19 10:24:09','FJ-260719-0001','DP-02763','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0001','2026-07-19','10:24:09','SAL','900000','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-260719-0001' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-19 ','10:51:40');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-19 ','11:02:27');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0002','sby','1',' DP-02585SB','TOKO','SBYPSN','PSPRT-ZGAD-48-0','CINCIN PERAK ','','3.180','1','100.00','325000','0','0','17800','850000','0','0','0','850000','VAN','00045185','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPRT-ZGAD-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-260719-0002','2026-07-19','3.180','2026-07-19','11:04:00','PLG0013346','850000','850000','0','850000','0','sby','2026-07-19 11:04:00','FJ-260719-0002','DP-02585','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0002','2026-07-19','11:04:00','VAN','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-260719-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0003','sby',' 1',' DP-02584SB','TOKO','SBYPSN','PSPRT-ZGAD-7-0','CINCIN PERAK ','','2.140','1','100.00','219000','0','0','17800','950000','0','0','0','950000','VAN','00045144','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPRT-ZGAD-7-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-260719-0003','2026-07-19','2.140','2026-07-19','11:04:00','PLG0013347','950000','950000','0','950000','0','sby','2026-07-19 11:04:00','FJ-260719-0002','DP-02584','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0003','2026-07-19','11:04:00','VAN','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260719-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-260719-0004','kasirbip','1',' DP-02669BI','TOKO','BIPPSN','PSPRT-ZGAX-6-0','CINCIN PERAK ','','3.080','1','100.00','315000','0','0','17800','900000','0','0','0','900000','SULIS','00045086','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAX-6-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-07-19' AND kode_barang='PSPRT-ZGAX-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0004','2026-07-19','3.080','2026-07-19','11:29:39','PLG0013348','900000','900000','0','900000','0','kasirbip','2026-07-19 11:29:39','FJ-260719-0004','DP-02669','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0004','2026-07-19','11:29:39','SULIS','900000','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-260719-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-260719-0005','kasirbip',' 1',' DP-02668BI','TOKO','BIPPSN','PSPRT-ZGAC-2-0','CINCIN PERAK ','','2.420','1','100.00','247000','0','0','17800','1100000','0','0','0','1100000','SULIS','00045112','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAC-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.420',berat_jual_asli=berat_jual_asli+'2.420',stock_jual='1',berat_akhir=berat_akhir-'2.420',berat_akhir_asli=berat_akhir_asli-'2.420',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPRT-ZGAC-2-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-260719-0005','2026-07-19','2.420','2026-07-19','11:29:39','PLG0013349','1100000','1100000','0','1100000','0','kasirbip','2026-07-19 11:29:39','FJ-260719-0004','DP-02668','1100000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0005','2026-07-19','11:29:39','SULIS','1100000','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-260719-0005' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03011','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','600000','0','600000','YL - 01 Putih glosy sz 14','font vladimir grf Arisya Syahlan','express 100.000','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0001','2026-07-19','2026-07-19 11:33:04','PESANAN : DP-03011','.','TBC','600000','600000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0002','D','2026-07-19','11:33:04','TBC','PESANAN','DP-03011','25115254064','600000','25115854064','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-03011','2026-07-19','2026-07-19','11:33:04','PLG0013350','SULIS','2026-08-29','kasirbip','2026-07-19 11:33:04','2.000','0','0','0','600000','0','0','600000','600000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0006','kasirbip','1',' 750K-105-2','TOKO','BIPPER','PBDG-ZGXF-47-0','CINCIN SILVER 925 ','','1.090','1','100.00','112000','0','0','17800','850000','0','0','0','850000','SULIS','00044975','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGXF-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PBDG-ZGXF-47-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0006','2026-07-19','1.090','2026-07-19','11:34:21','PLG0013351','850000','850000','0','850000','0','kasirbip','2026-07-19 11:34:21','FJ-260719-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-07-19','FJ-260719-0006','2026-07-19','11:34:21','SULIS','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0002','2026-07-19','2026-07-19 11:34:21','PENJUALAN : FJ-260719-0006','.','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-260719-0003','D','2026-07-19','11:34:21','TBC','PENJUALAN','FJ-260719-0006','25115854064','850000','25116704064','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-260719-0006' 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-02178','SULIS','1','CC SILVER','SZ 8 PUTIH GLOSY FONT VLADIMIR','1.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02178','2026-07-19','2026-07-19','11:36:13','PLG0013352','kasirbip','2026-07-28','kasirbip','2026-07-19 11:36:13','1.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-19 ','11:36:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-19 ','11:41:38');
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-260719-0007','kasirbip','1',' DP-02537BI','TOKO','BIPPSN','PSPLT-ZGAD-20-0','CINCIN PALADIUM ','','2.920','1','17.00','656000','0','0','17800','3372000','0','0','0','3372000','SAL','00045157','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAD-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.920',berat_jual_asli=berat_jual_asli+'2.920',stock_jual='1',berat_akhir=berat_akhir-'2.920',berat_akhir_asli=berat_akhir_asli-'2.920',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPLT-ZGAD-20-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-260719-0007','2026-07-19','2.920','2026-07-19','11:54:10','PLG0013353','3372000','3372000','0','3372000','0','kasirbip','2026-07-19 11:54:09','FJ-260719-0007','DP-02537','2860000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0007','2026-07-19','11:54:10','SAL','3372000','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-260719-0007' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0008','kasirbip',' 1',' DP-02538BI','TOKO','BIPPSN','PSPLT-ZGXB-5-0','CINCIN PALADIUM ','','2.290','1','17.00','515000','0','0','17800','1881500','0','0','0','1881500','SAL','00044896','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXB-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.290',berat_jual_asli=berat_jual_asli+'2.290',stock_jual='1',berat_akhir=berat_akhir-'2.290',berat_akhir_asli=berat_akhir_asli-'2.290',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPLT-ZGXB-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0008','2026-07-19','2.290','2026-07-19','11:54:10','PLG0013354','1881500','1881500','0','1881500','0','kasirbip','2026-07-19 11:54:09','FJ-260719-0007','DP-02538','1984000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0008','2026-07-19','11:54:10','SAL','1881500','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-260719-0008' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-19 ','11:58:51');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-19 ','12:02:04');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03012','ALIKA','1','PER','CINCIN PROMO 850K SLV','','','2.000','','925.00','1','100000','0','0','0','850000','cwe size 13 grf Dimas zircone 1 btr','cwo size 21 grf Rika UP SIZE 100K','Crom putih sesuai model','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0003','2026-07-19','2026-07-19 12:07:28','PESANAN : DP-03012','0','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-260719-0004','D','2026-07-19','12:07:28','TBC','PESANAN','DP-03012','25116704064','850000','25117554064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03012','2026-07-19','2026-07-19','12:07:28','PLG0013355','ALIKA','2026-08-17','kasir','2026-07-19 12:07:28','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-19 ','13:00:44');
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-260719-0009','kasir','1',' 950K-16-80','TOKO','MMPER','PMM-ZBAA-3-0','CINCIN SILVER 925 ','','2.000','1','100.00','204000','0','0','17800','1050000','0','0','0','1050000','ELLA','00041492','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBAA-3-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-07-19' AND kode_barang='PMM-ZBAA-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0009','2026-07-19','2.000','2026-07-19','13:00:55','PLG0013356','1050000','1050000','0','1050000','0','kasir','2026-07-19 13:00:55','FJ-260719-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0009','2026-07-19','13:00:55','ELLA','1050000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0004','2026-07-19','2026-07-19 13:00:55','PENJUALAN : FJ-260719-0009','.','TBC','1050000','1050000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0005','D','2026-07-19','13:00:55','TBC','PENJUALAN','FJ-260719-0009','25117554064','1050000','25118604064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1050000' WHERE no_faktur_jual='FJ-260719-0009' 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-03013','DIL','1','PLD','WEDD RING PRIA','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','SIZE 20.5 GRF: RG (YASEVA)','CROM PUTIH GLOSSY MIX DOFF','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0005','2026-07-19','2026-07-19 13:02:47','PESANAN : DP-03013','-','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-260719-0006','D','2026-07-19','13:02:47','TBC','PESANAN','DP-03013','25118604064','1500000','25120104064','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-03013','2026-07-19','2026-07-19','13:02:47','PLG0013357','DIL','2026-08-12','sby','2026-07-19 13:02:47','4.000','0','0','0','1500000','0','750000','2150000','2150000','650000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03014','DIL','1','PLD','WEDD RING WANITA','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','PERMATA 1 BUTIR','SIZE 11.5 GRF: YPZ (YASEVA)','CROM PUTIH GLOSSY MIX DOFF','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0006','2026-07-19','2026-07-19 13:06:40','PESANAN : DP-03014','-','TBC','1200000','1200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0007','D','2026-07-19','13:06:40','TBC','PESANAN','DP-03014','25120104064','1200000','25121304064','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-03014','2026-07-19','2026-07-19','13:06:40','PLG0013358','DIL','2026-08-12','sby','2026-07-19 13:06:40','3.000','0','0','0','1200000','0','750000','1810000','1810000','610000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0009';
UPDATE tm_sales SET nama_sales ='CAB JOGJA',edit_by='jogja',edit_date='2026-07-19 13:20:16' WHERE sales_id ='ADEL';
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-260719-0010','kasirbip','1',' DP-02673BI','TOKO','BIPPSN','PSPLT-ZGAG-41-0','CINCIN PALADIUM YL-01 ','','1.570','1','17.00','353000','0','0','17800','1299500','0','0','0','1299500','KUR','00045308','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPLT-ZGAG-41-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-260719-0010','2026-07-19','1.570','2026-07-19','13:48:43','PLG0013359','1299500','1299500','0','1299500','0','kasirbip','2026-07-19 13:48:42','FJ-260719-0010','DP-02673','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-07-19','FJ-260719-0010','2026-07-19','13:48:43','KUR','1299500','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-260719-0007','2026-07-19','2026-07-19 13:48:42','PENJUALAN : FJ-260719-0010','.','TBC','139500','139500','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-260719-0008','D','2026-07-19','13:48:43','TBC','PENJUALAN','FJ-260719-0010','25121304064','139500','25121443564','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='139500' WHERE no_faktur_jual='FJ-260719-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-260719-0011','kasirbip',' 1',' DP-02672BI','TOKO','BIPPSN','PSPLT-ZGAC-9-0','CINCIN PALADIUM ','','1.410','1','17.00','317000','0','0','17800','1603500','0','0','0','1603500','KUR','00045119','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAC-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPLT-ZGAC-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0011','2026-07-19','1.410','2026-07-19','13:48:43','PLG0013360','1603500','1603500','0','1603500','0','kasirbip','2026-07-19 13:48:42','FJ-260719-0010','DP-02672','1440000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0011','2026-07-19','13:48:43','KUR','1603500','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-260719-0008','2026-07-19','2026-07-19 13:48:42','PENJUALAN : FJ-260719-0011','.','TBC','163500','163500','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-260719-0009','D','2026-07-19','13:48:43','TBC','PENJUALAN','FJ-260719-0011','25121443564','163500','25121607064','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='303000' WHERE no_faktur_jual='FJ-260719-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0011';
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-260719-0012','kasir','1',' DP-02589MM','TOKO','MMPSN','PSPRT-ZGAD-18-0','CINCIN PERAK YL-01 ','','3.730','1','100.00','381000','0','0','17800','1200000','0','0','0','1200000','ALIKA','00045155','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.730',berat_jual_asli=berat_jual_asli+'3.730',stock_jual='1',berat_akhir=berat_akhir-'3.730',berat_akhir_asli=berat_akhir_asli-'3.730',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPRT-ZGAD-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0012','2026-07-19','3.730','2026-07-19','13:51:11','PLG0013361','1200000','1200000','0','1200000','0','kasir','2026-07-19 13:51:11','FJ-260719-0012','DP-02589','1200000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0012','2026-07-19','13:51:11','ALIKA','1200000','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-260719-0012' 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-03015','SAL','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','1000000','1700000','sz 14 putih glossy 27 zirkon','font comic sans grf Andika','model sprt contoh','270000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0009','2026-07-19','2026-07-19 14:38:42','PESANAN : DP-03015','.','TBC','1576000','1576000');
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-260719-0010','D','2026-07-19','14:38:42','TBC','PESANAN','DP-03015','25121607064','1576000','25123183064','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-03015','2026-07-19','2026-07-19','14:38:42','PLG0013362','SAL','2026-08-16','kasirbip','2026-07-19 14:38:42','2.000','0','0','0','1576000','0','1000000','1970000','1970000','394000');
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-03016','ELLA','1','GOLD','WEDDING RING','','','2.500','','75.00','1','2280000','2250000','0','950000','6575000','size 12 grf maya & bagus','warna crom putih glosy','zircone 22 butir','0','0','220000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0010','2026-07-19','2026-07-19 14:39:29','PESANAN : DP-03016','0','TBC','5436000','5436000');
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-260719-0011','D','2026-07-19','14:39:29','TBC','PESANAN','DP-03016','25123183064','5436000','25128619064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03016','2026-07-19','2026-07-19','14:39:29','PLG0013363','ELLA','2026-08-17','kasir','2026-07-19 14:39:29','2.500','0','0','0','5436000','0','950000','6795000','6795000','1359000');
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-03017','ELLA','1','GOLD','WEDDING RING','','','2.500','','75.00','1','2280000','2250000','0','950000','6575000','size 12 grf maya & bagus','warna crom putih glosy','zircone 22 butir','0','0','220000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0011','2026-07-19','2026-07-19 14:39:32','PESANAN : DP-03017','0','TBC','5436000','5436000');
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-260719-0012','D','2026-07-19','14:39:32','TBC','PESANAN','DP-03017','25128619064','5436000','25134055064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03017','2026-07-19','2026-07-19','14:39:32','PLG0013364','ELLA','2026-08-17','kasir','2026-07-19 14:39:32','2.500','0','0','0','5436000','0','950000','6795000','6795000','1359000');
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-03018','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz 22 putih doff smprot','font comic sans grf Lestari','model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0012','2026-07-19','2026-07-19 14:40:52','PESANAN : DP-03018','.','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-260719-0013','D','2026-07-19','14:40:52','TBC','PESANAN','DP-03018','25134055064','850000','25134905064','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-03018','2026-07-19','2026-07-19','14:40:52','PLG0013365','SAL','2026-08-16','kasirbip','2026-07-19 14:40:52','3.000','0','0','0','850000','0','0','850000','850000','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-260719-0013','kasirbip','1',' DP-02744BI','TOKO','BIPPSN','PSPRT-ZGAC-11-0','CINCIN PERAK SR-03 YL-01 ','','3.480','1','100.00','355000','0','0','17800','950000','0','0','0','950000','SAL','00045121','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAC-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.480',berat_jual_asli=berat_jual_asli+'3.480',stock_jual='1',berat_akhir=berat_akhir-'3.480',berat_akhir_asli=berat_akhir_asli-'3.480',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPRT-ZGAC-11-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-260719-0013','2026-07-19','3.480','2026-07-19','14:41:25','PLG0013366','950000','950000','0','950000','0','kasirbip','2026-07-19 14:41:25','FJ-260719-0013','DP-02744','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0013','2026-07-19','14:41:25','SAL','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260719-0013' 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-03019','ELLA','1','PER','WEDDING RING','','','4.000','','925.00','1','100000','0','0','0','900000','size 16.5 grf maya & bagus','tanpa permata','warna crom putih doff semprot sesuai model','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0013','2026-07-19','2026-07-19 14:43:48','PESANAN : DP-03019','0','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0014','D','2026-07-19','14:43:48','TBC','PESANAN','DP-03019','25134905064','900000','25135805064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03019','2026-07-19','2026-07-19','14:43:48','PLG0013367','ELLA','2026-08-17','kasir','2026-07-19 14:43:48','4.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-03020','ELLA','1','PER','WEDDING RING','','','4.000','','925.00','1','100000','0','0','0','900000','size 16.5 grf maya & bagus','tanpa permata','warna crom putih doff semprot sesuai model','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0014','2026-07-19','2026-07-19 14:43:50','PESANAN : DP-03020','0','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0015','D','2026-07-19','14:43:50','TBC','PESANAN','DP-03020','25135805064','900000','25136705064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03020','2026-07-19','2026-07-19','14:43:50','PLG0013368','ELLA','2026-08-17','kasir','2026-07-19 14:43:50','4.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-19 ','14:45:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-19 ','14:47:59');
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-03021','KUR','1','PLD','CIN CIN KAWIN','','','2.000','','10.00','1','1200000','350000','0','750000','1450000','size 8','putih kilat sirkon 1','bikin seperti contoh','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0015','2026-07-19','2026-07-19 14:54:47','PESANAN : DP-03021','.','TBC','1120000','1120000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0016','D','2026-07-19','14:54:47','TBC','PESANAN','DP-03021','25136705064','1120000','25137825064','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-03021','2026-07-19','2026-07-19','14:54:47','PLG0013369','KUR','2026-08-09','kasirbip','2026-07-19 14:54:47','2.000','0','0','0','1120000','0','750000','1450000','1450000','330000');
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-03022','KUR','1','PLD','CINCIN KAWIN','','','2.000','','10.00','1','1200000','350000','0','700000','1400000','size 10.5','model YL-01','buat seperti contoh','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0016','2026-07-19','2026-07-19 14:58:24','PESANAN : DP-03022','.','TBC','1120000','1120000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0017','D','2026-07-19','14:58:24','TBC','PESANAN','DP-03022','25137825064','1120000','25138945064','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-03022','2026-07-19','2026-07-19','14:58:24','PLG0013370','KUR','2026-08-09','kasirbip','2026-07-19 14:58:24','2.000','0','0','0','1120000','0','700000','1400000','1400000','280000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0013';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-19 ','15:08:08');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-19 ','15:55:23');
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-07-19',  status ='CLOS' WHERE no_service='SV-02164';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02164';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-19 ','16:08:24');
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-260719-0014','sby','1',' 750K-125-0','TOKO','SBYPER','PSBY-ZEXA-34-0','CINCIN SILVER 925 ','','1.840','1','100.00','188000','0','0','17800','850000','0','0','0','850000','VAN','00043056','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.840',berat_jual_asli=berat_jual_asli+'1.840',stock_jual='1',berat_akhir=berat_akhir-'1.840',berat_akhir_asli=berat_akhir_asli-'1.840',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSBY-ZEXA-34-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-260719-0014','2026-07-19','1.840','2026-07-19','16:10:39','PLG0013371','850000','850000','0','850000','0','sby','2026-07-19 16:10:39','FJ-260719-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0014','2026-07-19','16:10:39','VAN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0017','2026-07-19','2026-07-19 16:10:39','PENJUALAN : FJ-260719-0014','','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-260719-0018','D','2026-07-19','16:10:39','TBC','PENJUALAN','FJ-260719-0014','25138945064','850000','25139795064','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-260719-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-260719-0015','sby',' 1',' 750K-145-0','TOKO','SBYPER','PSBY-ZEXE-18-0','CINCIN SILVER 925 ','','1.920','1','100.00','196000','0','0','17800','850000','0','0','0','850000','VAN','00043214','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSBY-ZEXE-18-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-260719-0015','2026-07-19','1.920','2026-07-19','16:10:39','PLG0013372','850000','850000','0','850000','0','sby','2026-07-19 16:10:39','FJ-260719-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0015','2026-07-19','16:10:39','VAN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0018','2026-07-19','2026-07-19 16:10:39','PENJUALAN : FJ-260719-0015','','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0019','D','2026-07-19','16:10:39','TBC','PENJUALAN','FJ-260719-0015','25139795064','850000','25140645064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-260719-0015' LIMIT 1;
UPDATE th_user_login SET tgl_logout = '2026-07-19', jam_logout = '16:20:41' WHERE user_id = 'kasir' AND tgl_login = '2026-07-19' AND jam_login= '14:47:59';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('b','2026-07-19 ','16:20:52');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03017';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03017';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03017';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260719-0002','K','2026-07-19','16:21:35','b','PESANAN BATAL','DP-03017','16963300','0','16963300');
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03020';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03020';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03020';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260719-0003','K','2026-07-19','16:22:03','b','PESANAN BATAL','DP-03020','16963300','0','16963300');
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-260719-0016','kasirbip','1',' DP-02723BI','TOKO','BIPPSN','PSGT-ZGAG-46-0','CINCIN EMAS ','','2.490','1','57.00','3302000','0','0','17800','5472000','0','0','0','5472000','SAL','00045313','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZGAG-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSGT-ZGAG-46-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-260719-0016','2026-07-19','2.490','2026-07-19','16:24:00','PLG0013373','5472000','5472000','0','5472000','0','kasirbip','2026-07-19 16:23:59','FJ-260719-0016','DP-02723','4392000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0016','2026-07-19','16:24:00','SAL','5472000','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-260719-0019','2026-07-19','2026-07-19 16:23:59','PENJUALAN : FJ-260719-0016','.','TBC','1080000','1080000','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-260719-0020','D','2026-07-19','16:24:00','TBC','PENJUALAN','FJ-260719-0016','25140645064','1080000','25141725064','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='1080000' WHERE no_faktur_jual='FJ-260719-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-260719-0017','kasirbip',' 1',' DP-02724BI','TOKO','BIPPSN','PSPLT-ZGAF-26-0','CINCIN PALADIUM ','','1.390','1','17.00','313000','0','0','17800','1186500','0','0','0','1186500','SAL','00045244','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAF-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPLT-ZGAF-26-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-260719-0017','2026-07-19','1.390','2026-07-19','16:24:00','PLG0013374','1186500','1186500','0','1186500','0','kasirbip','2026-07-19 16:23:59','FJ-260719-0016','DP-02724','1120000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0017','2026-07-19','16:24:00','SAL','1186500','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-260719-0020','2026-07-19','2026-07-19 16:23:59','PENJUALAN : FJ-260719-0017','.','TBC','66500','66500','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-260719-0021','D','2026-07-19','16:24:00','TBC','PENJUALAN','FJ-260719-0017','25141725064','66500','25141791564','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='1146500' WHERE no_faktur_jual='FJ-260719-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0017';
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-260719-0018','sby','1',' DP-02829SB','TOKO','SBYPSN','PSPRT-ZGAD-49-0','1PS CINCIN PERAK ','','6.460','1','100.00','659000','0','0','17800','1500000','0','0','0','1500000','VAN','00045186','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.460',berat_jual_asli=berat_jual_asli+'6.460',stock_jual='1',berat_akhir=berat_akhir-'6.460',berat_akhir_asli=berat_akhir_asli-'6.460',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPRT-ZGAD-49-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-260719-0018','2026-07-19','6.460','2026-07-19','16:36:19','PLG0013375','1500000','1500000','0','1500000','0','sby','2026-07-19 16:36:18','FJ-260719-0018','DP-02829','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-07-19','FJ-260719-0018','2026-07-19','16:36:19','VAN','1500000','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-260719-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-260719-0019','kasirbip','1',' DP-02623BI','TOKO','BIPPSN','PSPRT-ZGAG-18-0','CINCIN PERAK ','','1.220','1','100.00','125000','0','0','17800','1000000','0','0','0','1000000','SULIS','00045285','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAG-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.220',berat_jual_asli=berat_jual_asli+'1.220',stock_jual='1',berat_akhir=berat_akhir-'1.220',berat_akhir_asli=berat_akhir_asli-'1.220',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPRT-ZGAG-18-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-260719-0019','2026-07-19','1.220','2026-07-19','16:43:48','PLG0013376','1000000','1000000','0','1000000','0','kasirbip','2026-07-19 16:43:47','FJ-260719-0019','DP-02623','1000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0019','2026-07-19','16:43:48','SULIS','1000000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260719-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0019';
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-07-19',  status ='CLOS' WHERE no_service='SV-02140';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02140';
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-07-19',  status ='CLOS' WHERE no_service='SV-02126';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02126';
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-07-19',  status ='CLOS' WHERE no_service='SV-02109';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02109';
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-07-19',  status ='CLOS' WHERE no_service='SV-02142';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02142';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-19 ','16:51:25');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0020','b','1',' 500K-175-1','TOKO','MMPER','PMM-ZGXF-1-0','CINCIN SILVER 925 YL-01 ','','2.070','1','100.00','212000','0','0','17800','700000','0','0','0','700000','ALIKA','00044929','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGXF-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PMM-ZGXF-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0020','2026-07-19','2.070','2026-07-19','17:04:51','PLG0013377','700000','700000','0','700000','0','b','2026-07-19 17:04:50','FJ-260719-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0020','2026-07-19','17:04:51','ALIKA','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0021','2026-07-19','2026-07-19 17:04:50','PENJUALAN : FJ-260719-0020','0','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0022','D','2026-07-19','17:04:51','TBC','PENJUALAN','FJ-260719-0020','25141791564','700000','25142491564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-260719-0020' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0021','b',' 1',' 700K-13-00','TOKO','MMPER','LXPER-ZBBC-16-0','CINCIN SILVER 925 ','','1.090','1','100.00','112000','0','0','17800','850000','0','0','0','850000','ALIKA','00041677','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBC-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.090',berat_jual_asli=berat_jual_asli+'1.090',stock_jual='1',berat_akhir=berat_akhir-'1.090',berat_akhir_asli=berat_akhir_asli-'1.090',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='LXPER-ZBBC-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0021','2026-07-19','1.090','2026-07-19','17:04:51','PLG0013378','850000','850000','0','850000','0','b','2026-07-19 17:04:50','FJ-260719-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0021','2026-07-19','17:04:51','ALIKA','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0022','2026-07-19','2026-07-19 17:04:50','PENJUALAN : FJ-260719-0021','0','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0023','D','2026-07-19','17:04:51','TBC','PENJUALAN','FJ-260719-0021','25142491564','850000','25143341564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1550000' WHERE no_faktur_jual='FJ-260719-0021' 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-260719-0022','b','1',' 800K-13-00','TOKO','MMPER','PMM-YGAF-25-0','CINCIN SILVER 925 ','','2.680','1','100.00','56000','0','0','17800','900000','0','0','0','900000','ELLA','00037244','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGAF-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.680',berat_jual_asli=berat_jual_asli+'2.680',stock_jual='1',berat_akhir=berat_akhir-'2.680',berat_akhir_asli=berat_akhir_asli-'2.680',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PMM-YGAF-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0022','2026-07-19','2.680','2026-07-19','17:07:59','PLG0013379','900000','900000','0','900000','0','b','2026-07-19 17:07:59','FJ-260719-0022','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0022','2026-07-19','17:07:59','ELLA','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0023','2026-07-19','2026-07-19 17:07:59','PENJUALAN : FJ-260719-0022','0','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0024','D','2026-07-19','17:07:59','TBC','PENJUALAN','FJ-260719-0022','25143341564','900000','25144241564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-260719-0022' 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-260719-0023','b',' 1',' 750K-20-10','TOKO','MMPER','PMM-ZGAD-27-0','CINCIN SILVER 925 ','','2.170','1','100.00','222000','0','0','17800','850000','0','0','0','850000','ELLA','00045164','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGAD-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PMM-ZGAD-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0023','2026-07-19','2.170','2026-07-19','17:07:59','PLG0013380','850000','850000','0','850000','0','b','2026-07-19 17:07:59','FJ-260719-0022','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0023','2026-07-19','17:07:59','ELLA','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0024','2026-07-19','2026-07-19 17:07:59','PENJUALAN : FJ-260719-0023','0','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0025','D','2026-07-19','17:07:59','TBC','PENJUALAN','FJ-260719-0023','25144241564','850000','25145091564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1750000' WHERE no_faktur_jual='FJ-260719-0023' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0024','b','1',' 500K-19-96','TOKO','MMPER','PMM-ZEXA-97-0','CINCIN SILVER 925 YL-01 ','','2.150','1','100.00','220000','0','0','17800','700000','0','0','0','700000','ALIKA','00043119','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZEXA-97-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PMM-ZEXA-97-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0024','2026-07-19','2.150','2026-07-19','17:12:24','PLG0013381','700000','700000','0','700000','0','b','2026-07-19 17:12:23','FJ-260719-0024','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0024','2026-07-19','17:12:24','ALIKA','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0025','2026-07-19','2026-07-19 17:12:23','PENJUALAN : FJ-260719-0024','0','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0026','D','2026-07-19','17:12:24','TBC','PENJUALAN','FJ-260719-0024','25145091564','700000','25145791564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-260719-0024' 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-260719-0025','b',' 1',' 950K-105-1','TOKO','MMPER','PMM-ZFXA-13-0','CINCIN SILVER 925 ','','1.660','1','100.00','170000','0','0','17800','1100000','0','0','0','1100000','ALIKA','00043893','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFXA-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PMM-ZFXA-13-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0025','2026-07-19','1.660','2026-07-19','17:12:24','PLG0013382','1100000','1100000','0','1100000','0','b','2026-07-19 17:12:23','FJ-260719-0024','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0025','2026-07-19','17:12:24','ALIKA','1100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0026','2026-07-19','2026-07-19 17:12:23','PENJUALAN : FJ-260719-0025','0','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-260719-0027','D','2026-07-19','17:12:24','TBC','PENJUALAN','FJ-260719-0025','25145791564','1100000','25146891564','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1800000' WHERE no_faktur_jual='FJ-260719-0025' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0022';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03023','ELLA','1','PER','WEDDING RING','','','3.000','','925.00','1','100000','0','0','0','850000','PRIA SIZE 20 GRF CHASANAH','WARNA ROSE GOLD FULL GLOSY','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0027','2026-07-19','2026-07-19 17:56:44','PESANAN : DP-03023','0','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-260719-0028','D','2026-07-19','17:56:44','TBC','PESANAN','DP-03023','25146891564','850000','25147741564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03023','2026-07-19','2026-07-19','17:56:44','PLG0013383','ELLA','2026-08-17','b','2026-07-19 17:56:44','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-19 ','17:57:33');
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-03024','PUT','1','PLD','WEDRING','','','2.500','','25.00','1','1200000','550000','0','800000','2175000','EXPRESS 100.000 zircon 10','grf 29.11.26 font Vintage','','100000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0028','2026-07-19','2026-07-19 18:01:53','PESANAN : DP-03024','.','TBC','1820000','1820000');
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-260719-0029','D','2026-07-19','18:01:53','TBC','PESANAN','DP-03024','25147741564','1820000','25149561564','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-03024','2026-07-19','2026-07-19','18:01:53','PLG0013384','PUT','2026-08-29','kasirbip','2026-07-19 18:01:53','2.500','0','0','0','1820000','0','800000','2275000','2275000','455000');
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-03025','ELLA','1','PER','WEDDING RING','','','3.000','','925.00','1','100000','0','0','0','900000','CWE SIZE 10 GRF TAUFIK','WARNA ROSE GOLD FULL GLOSY','ZIRCONE 10 BUTIR','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0029','2026-07-19','2026-07-19 18:02:17','PESANAN : DP-03025','0','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0030','D','2026-07-19','18:02:17','TBC','PESANAN','DP-03025','25149561564','900000','25150461564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03025','2026-07-19','2026-07-19','18:02:17','PLG0013385','ELLA','2026-08-17','kasir','2026-07-19 18:02:17','3.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-03026','ELLA','1','PER','WEDDING RING','','','3.000','','925.00','1','100000','0','0','0','900000','CWE SIZE 10 GRF TAUFIK','WARNA ROSE GOLD FULL GLOSY','ZIRCONE 10 BUTIR','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0030','2026-07-19','2026-07-19 18:02:21','PESANAN : DP-03026','0','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0031','D','2026-07-19','18:02:21','TBC','PESANAN','DP-03026','25150461564','900000','25151361564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03026','2026-07-19','2026-07-19','18:02:21','PLG0013386','ELLA','2026-08-17','kasir','2026-07-19 18:02:21','3.000','0','0','0','900000','0','0','900000','900000','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-07-19',  status ='CLOS' WHERE no_service='SV-02161';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02161';
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-03027','PUT','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','EXPRESS 200.000','Grf 29.11.26 font vintage','YL-01','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-260719-0031','2026-07-19','2026-07-19 18:04:39','PESANAN : DP-03027','.','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-260719-0032','D','2026-07-19','18:04:39','TBC','PESANAN','DP-03027','25151361564','1400000','25152761564','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-03027','2026-07-19','2026-07-19','18:04:39','PLG0013387','PUT','2026-07-29','kasirbip','2026-07-19 18:04:39','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-260719-0026','kasirbip','1',' 1.0K-13-00','TOKO','DUPERBDG','LXPER-ZEAB-19-0','CINCIN SILVER 925 ','','2.250','1','100.00','230000','0','0','17800','1100000','0','0','0','1100000','NAD','00043486','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEAB-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='LXPER-ZEAB-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0026','2026-07-19','2.250','2026-07-19','18:13:52','PLG0013388','1100000','1100000','0','1100000','0','kasirbip','2026-07-19 18:13:51','FJ-260719-0026','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0026','2026-07-19','18:13:52','NAD','1100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0032','2026-07-19','2026-07-19 18:13:51','PENJUALAN : FJ-260719-0026','.','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-260719-0033','D','2026-07-19','18:13:52','TBC','PENJUALAN','FJ-260719-0026','25152761564','1100000','25153861564','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-260719-0026' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0027','kasirbip','1',' 750K-18-00','TOKO','DUPERBDG','LXPER-ZDAE-33-0','CINCIN SILVER 925 ','','2.000','1','100.00','204000','0','0','17800','850000','0','0','0','850000','NAD','00042577','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDAE-33-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-07-19' AND kode_barang='LXPER-ZDAE-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0027','2026-07-19','2.000','2026-07-19','18:14:49','PLG0013389','850000','850000','0','850000','0','kasirbip','2026-07-19 18:14:48','FJ-260719-0027','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0027','2026-07-19','18:14:49','NAD','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260719-0033','2026-07-19','2026-07-19 18:14:48','PENJUALAN : FJ-260719-0027','.','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-260719-0034','D','2026-07-19','18:14:49','TBC','PENJUALAN','FJ-260719-0027','25153861564','850000','25154711564','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-260719-0027' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0027';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-07-19 ','18:21:42');
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-260719-0028','kasir','1',' TFCMR75-81','TOKO','TFCINMAS','TFCMR-YLXC-17-0','THIFA CINCIN MAS RG ','','0.920','1','81.00','1734000','0','0','17800','1800000','0','0','0','1800000','RISIANA','00040140','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YLXC-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='TFCMR-YLXC-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0028','2026-07-19','0.920','2026-07-19','18:28:49','PLG0013390','1800000','1800000','0','1800000','1800000','kasir','2026-07-19 18:28:49','FJ-260719-0028','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0028','2026-07-19','18:28:49','RISIANA','1800000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260719-0004','D','2026-07-19','18:28:49','kasir','PENJUALAN','FJ-260719-0028','16963300','1800000','18763300');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0028';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-07-19 ','18:32:00');
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-03028','ALIKA','1','PER','WEDING RING','','','4.000','','925.00','1','100000','0','0','0','900000','SIZE 19.5','CROM PUTIH DOFF SEMPROT','ZIRCONE 1 BUTIR','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0034','2026-07-19','2026-07-19 18:34:04','PESANAN : DP-03028','0','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0035','D','2026-07-19','18:34:04','TBC','PESANAN','DP-03028','25154711564','900000','25155611564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03028','2026-07-19','2026-07-19','18:34:04','PLG0013391','ALIKA','2026-08-17','kasir','2026-07-19 18:34:04','4.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-03029','ALIKA','1','PER','WEDING RING','','','4.000','','925.00','1','100000','0','0','0','900000','SIZE 19.5','CROM PUTIH DOFF SEMPROT','ZIRCONE 1 BUTIR','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0035','2026-07-19','2026-07-19 18:34:06','PESANAN : DP-03029','0','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0036','D','2026-07-19','18:34:06','TBC','PESANAN','DP-03029','25155611564','900000','25156511564','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03029','2026-07-19','2026-07-19','18:34:06','PLG0013392','ALIKA','2026-08-17','kasir','2026-07-19 18:34:06','4.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-03030','DIL','1','PER','WEDD RING PRIA','','','3.000','','925.00','1','100000','0','800000','0','800000','SIZE 22 GRF: Wenny (INFINITY) 26.09.26 (BERKSHIRE)','CROM ROSE GOLD GLOSSY MIX PUTIH DOFF (DETAIL WA)','','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-260719-0036','2026-07-19','2026-07-19 18:52:28','PESANAN : DP-03030','-','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-260719-0037','D','2026-07-19','18:52:28','TBC','PESANAN','DP-03030','25156511564','800000','25157311564','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-03030','2026-07-19','2026-07-19','18:52:28','PLG0013393','DIL','2026-08-12','sby','2026-07-19 18:52:28','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-03031','DIL','1','PER','WEDD RING WANITA','','','3.000','','925.00','1','100000','0','950000','0','950000','PERMATA 7 BUTIR','SIZE 15 GRF: Rendra (INFINITY) 26.09.26 (BERKSHIRE)','CROM ROSE GOLD GLOSSY MIX PUTIH DOFF (DETAIL WA)','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-260719-0037','2026-07-19','2026-07-19 18:55:26','PESANAN : DP-03031','-','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-260719-0038','D','2026-07-19','18:55:26','TBC','PESANAN','DP-03031','25157311564','950000','25158261564','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-03031','2026-07-19','2026-07-19','18:55:26','PLG0013394','DIL','2026-08-12','sby','2026-07-19 18:55:26','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0029','kasir','1',' DP-02776MM','TOKO','MMPSN','PSPLT-ZGAG-12-0','CINCIN PALADIUM ','','1.140','1','17.00','257000','0','0','17800','1129000','0','0','0','1129000','ELLA','00045279','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAG-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.140',berat_jual_asli=berat_jual_asli+'1.140',stock_jual='1',berat_akhir=berat_akhir-'1.140',berat_akhir_asli=berat_akhir_asli-'1.140',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPLT-ZGAG-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260719-0029','2026-07-19','1.140','2026-07-19','19:12:35','PLG0013395','1129000','1129000','0','1129000','0','kasir','2026-07-19 19:12:34','FJ-260719-0029','DP-02776','1120000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0029','2026-07-19','19:12:35','ELLA','1129000','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-260719-0038','2026-07-19','2026-07-19 19:12:34','PENJUALAN : FJ-260719-0029','.','TBC','9000','9000','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-260719-0039','D','2026-07-19','19:12:35','TBC','PENJUALAN','FJ-260719-0029','25158261564','9000','25158270564','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='9000' WHERE no_faktur_jual='FJ-260719-0029' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0029';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-07-19 ','19:16:16');
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-260719-0030','sby','1',' DP-02597SB','TOKO','SBYPSN','PSPRT-ZGAD-10-0','CINCIN PERAK ','','2.190','1','100.00','224000','0','0','17800','850000','0','0','0','850000','VAN','00045147','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPRT-ZGAD-10-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-260719-0030','2026-07-19','2.190','2026-07-19','19:17:46','PLG0013396','850000','850000','0','850000','0','sby','2026-07-19 19:17:46','FJ-260719-0030','DP-02597','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0030','2026-07-19','19:17:46','VAN','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-260719-0030' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0031','sby',' 1',' DP-02599SB','TOKO','SBYPSN','PSPRT-ZGAD-8-0','CINCIN PERAK ','','1.380','1','100.00','141000','0','0','17800','950000','0','0','0','950000','VAN','00045145','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGAD-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPRT-ZGAD-8-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-260719-0031','2026-07-19','1.380','2026-07-19','19:17:46','PLG0013397','950000','950000','0','950000','0','sby','2026-07-19 19:17:46','FJ-260719-0030','DP-02599','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0031','2026-07-19','19:17:46','VAN','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260719-0031' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03032','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','cwe sz 19 putih doff semprot grf Gilang','cwe sz 22 putih dof amplas grf Dedes','oversize cwe & cwo 200.000 font vintage rotter','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0039','2026-07-19','2026-07-19 19:22:27','PESANAN : DP-03032','.','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-260719-0040','D','2026-07-19','19:22:27','TBC','PESANAN','DP-03032','25158270564','950000','25159220564','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-03032','2026-07-19','2026-07-19','19:22:27','PLG0013398','SULIS','2026-08-30','kasirbip','2026-07-19 19:22:27','2.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260719-0032','kasirbip','1',' DP-02806BI','TOKO','BIPPSN','PSPLT-ZGAC-20-0','CINCIN PALADIUM ','','1.440','1','17.00','324000','0','0','17800','1204000','0','0','0','1204000','SULIS','00045130','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-07-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGAC-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-07-19' AND kode_barang='PSPLT-ZGAC-20-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-260719-0032','2026-07-19','1.440','2026-07-19','19:24:26','PLG0013399','1204000','1204000','0','1204000','0','kasirbip','2026-07-19 19:24:25','FJ-260719-0032','DP-02806','1120000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-19','FJ-260719-0032','2026-07-19','19:24:26','SULIS','1204000','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-260719-0040','2026-07-19','2026-07-19 19:24:25','PENJUALAN : FJ-260719-0032','.','TBC','84000','84000','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-260719-0041','D','2026-07-19','19:24:26','TBC','PENJUALAN','FJ-260719-0032','25159220564','84000','25159304564','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='84000' WHERE no_faktur_jual='FJ-260719-0032' LIMIT 1;
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-07-19',  status ='CLOS' WHERE no_service='SV-02159';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02159';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0030';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260719-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260719-0032';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-07-19 ','20:49:17');
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-03033','ADEL','1','PLD','SILVER','','','4.100','','925.00','1','1200000','1000000','0','0','1000000','GRAF : Ardha & Novi : Vintage Rotter','SIZE : 20 MODEL LX-93','','','','');
INSERT INTO tm_barang_contoh(no_persekot,no_urut,kode_barang,nama_barang,berat,tgl_titip,status) VALUES ('DP-03033','1','LX-93','MODEL SEPERTI DI GAMBAR CINCIN COWOK','','2026-07-19 21:04:32','OPEN');
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-03033','2026-07-19','2026-07-19','21:04:32','PLG0013400','ADEL','2026-08-19','jogja','2026-07-19 21:04:32','4.100','1000000','0','0','0','0','0','1000000','1000000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260719-0005','D','2026-07-19','21:04:32','jogja','PESANAN','DP-03033','18763300','1000000','19763300');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-19';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-19' 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-260720-0001','D','2026-07-20','21:06:25','TBC','SALDO AWAL','SALDO AWAL','0','25159304564','25159304564');
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-260720-0001','D','2026-07-20','21:06:25','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260720-0001','D','2026-07-20','21:06:25','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-260720-0001','D','2026-07-20','21:06:25','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260720-0001','D','2026-07-20','21:06:25','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-260720-0001','D','2026-07-20','21:06:25','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-260720-0001','D','2026-07-20','21:06:25','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-260720-0001','D','2026-07-20','21:06:25','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-260720-0001','D','2026-07-20','21:06:25','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-260720-0001','D','2026-07-20','21:06:25','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-260720-0001','D','2026-07-20','21:06:25','','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-260720-0001','D','2026-07-20','21:06:25','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
UPDATE tp_system SET tgl_system='2026-07-20';
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-03034','ADEL','1','PER','SILVER 1 COWOK','','','4.100','','925.00','1','100000','0','','','1000000','GRAF : Ardha & Novi : Vintage Rotter','SIZE 20 MODEL COWOK LX-93','','','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260719-0041','2026-07-19','2026-07-19 21:20:15','PESANAN : DP-03034','3461837156','TBC','1000000','1000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260719-0001','D','2026-07-19','21:20:15','TBC','PESANAN','DP-03034','0','1000000','1000000','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('3461837156','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-03034','2026-07-19','2026-07-19','21:20:15','PLG0013401','ADEL','2026-08-19','jogja','2026-07-19 21:20:15','4.100','0','0','0','1000000','0','0','1000000','1000000','0');