INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-19 ','12:18:22');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260319-0001','kasirbip','1',' TFPER-0003','TOKO','BIPPER','TFPER-XGXH-50-0','CINCIN PERAK TFPER-00038 ','','3.070','1','100.00','244000','150000','0','17000','900000','0','0','0','900000','SULIS','00029710','TFPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFPER-XGXH-50-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-03-19' AND kode_barang='TFPER-XGXH-50-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-260319-0001','2026-03-19','3.070','2026-03-19','12:19:21','PLG0010074','900000','900000','0','900000','0','kasirbip','2026-03-19 12:19:20','FJ-260319-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-19','FJ-260319-0001','2026-03-19','12:19:21','SULIS','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260319-0001','2026-03-19','2026-03-19 12:19:20','PENJUALAN : FJ-260319-0001','.','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-260319-0002','D','2026-03-19','12:19:21','TBC','PENJUALAN','FJ-260319-0001','21083496014','900000','21084396014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-260319-0001' 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-01841','GIN','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','CWE SZ 16 PUTIH GLOSY','CWO SZ 17 PUTIH DOFF AMPLASS','FONT vintage rotter grf cwe Reza cwo Wulan','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260319-0002','2026-03-19','2026-03-19 13:09:57','PESANAN : DP-01841','.','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-260319-0003','D','2026-03-19','13:09:57','TBC','PESANAN','DP-01841','21084396014','850000','21085246014','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-01841','2026-03-19','2026-03-19','13:09:57','PLG0010075','GIN','2026-05-01','kasirbip','2026-03-19 13:09:57','3.000','0','0','0','850000','0','0','850000','850000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260319-0001';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260319-0002','kasirbip','1',' 850K-22-23','TOKO','BIPPER','PBDG-ZCAA-46-0','CINCIN SILVER 925 ','','4.230','1','100.00','432000','0','0','17000','950000','0','0','0','950000','SULIS','00042282','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCAA-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.230',berat_jual_asli=berat_jual_asli+'4.230',stock_jual='1',berat_akhir=berat_akhir-'4.230',berat_akhir_asli=berat_akhir_asli-'4.230',stock_akhir='0' WHERE tanggal='2026-03-19' AND kode_barang='PBDG-ZCAA-46-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-260319-0002','2026-03-19','4.230','2026-03-19','13:28:12','PLG0010076','950000','950000','0','950000','0','kasirbip','2026-03-19 13:28:11','FJ-260319-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-19','FJ-260319-0002','2026-03-19','13:28:12','SULIS','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260319-0003','2026-03-19','2026-03-19 13:28:11','PENJUALAN : FJ-260319-0002','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260319-0004','D','2026-03-19','13:28:12','TBC','PENJUALAN','FJ-260319-0002','21085246014','950000','21086196014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-260319-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-260319-0003','kasirbip',' 1',' 800K-14-00','TOKO','BIPPER','LXPER-ZCXB-49-0','CINCIN SILVER 925 ','','3.120','1','100.00','319000','0','0','17000','950000','0','0','0','950000','SULIS','00042110','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZCXB-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-03-19' AND kode_barang='LXPER-ZCXB-49-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-260319-0003','2026-03-19','3.120','2026-03-19','13:28:12','PLG0010077','950000','950000','0','950000','0','kasirbip','2026-03-19 13:28:11','FJ-260319-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-19','FJ-260319-0003','2026-03-19','13:28:12','SULIS','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260319-0004','2026-03-19','2026-03-19 13:28:11','PENJUALAN : FJ-260319-0003','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260319-0005','D','2026-03-19','13:28:12','TBC','PENJUALAN','FJ-260319-0003','21086196014','950000','21087146014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1900000' WHERE no_faktur_jual='FJ-260319-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260319-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260319-0003';
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-01842','SULIS','1','PLD','WED RING','','','2.500','','10.00','1','1200000','300000','0','700000','1450000','putih doff semprot mosel tanpa permata','sz 15.5','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260319-0005','2026-03-19','2026-03-19 16:00:57','PESANAN : DP-01842','.','TBC','1160000','1160000');
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-260319-0006','D','2026-03-19','16:00:57','TBC','PESANAN','DP-01842','21087146014','1160000','21088306014','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-01842','2026-03-19','2026-03-19','16:00:57','PLG0010078','SULIS','2026-04-30','kasirbip','2026-03-19 16:00:57','2.500','0','0','0','1160000','0','700000','1450000','1450000','290000');
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-01843','SULIS','1','PLD','WED RING','','','2.500','','10.00','1','1200000','300000','0','750000','1500000','13 zircon putih glosy','model spt contoh lebar dan tebal berat menyesuaikan','','130000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260319-0006','2026-03-19','2026-03-19 16:04:50','PESANAN : DP-01843','.','TBC','1304000','1304000');
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-260319-0007','D','2026-03-19','16:04:50','TBC','PESANAN','DP-01843','21088306014','1304000','21089610014','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-01843','2026-03-19','2026-03-19','16:04:50','PLG0010079','SULIS','2026-04-30','kasirbip','2026-03-19 16:04:50','2.500','0','0','0','1304000','0','750000','1630000','1630000','326000');
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-260319-0004','kasirbip','1',' 700K-16-21','TOKO','BIPPER','PBDG-ZABA-9-0','CINCIN SILVER 925 ','','4.550','1','100.00','279000','0','0','17000','900000','0','0','0','900000','MIA','00041056','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZABA-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.550',berat_jual_asli=berat_jual_asli+'4.550',stock_jual='1',berat_akhir=berat_akhir-'4.550',berat_akhir_asli=berat_akhir_asli-'4.550',stock_akhir='0' WHERE tanggal='2026-03-19' AND kode_barang='PBDG-ZABA-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260319-0004','2026-03-19','4.550','2026-03-19','16:08:50','PLG0010080','900000','900000','0','900000','0','kasirbip','2026-03-19 16:08:50','FJ-260319-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-19','FJ-260319-0004','2026-03-19','16:08:50','MIA','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-260319-0007','2026-03-19','2026-03-19 16:08:50','PENJUALAN : FJ-260319-0004','.','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-260319-0008','D','2026-03-19','16:08:50','TBC','PENJUALAN','FJ-260319-0004','21089610014','900000','21090510014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-260319-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-260319-0005','kasirbip',' 1',' 1.050K-16-','TOKO','BIPPER','PBDG-ZBAA-32-0','CINCIN SILVER 925 ','','1.800','1','100.00','184000','0','0','17000','1150000','0','0','0','1150000','MIA','00041521','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAA-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-03-19' AND kode_barang='PBDG-ZBAA-32-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-260319-0005','2026-03-19','1.800','2026-03-19','16:08:50','PLG0010081','1150000','1150000','0','1150000','0','kasirbip','2026-03-19 16:08:50','FJ-260319-0004','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-19','FJ-260319-0005','2026-03-19','16:08:50','MIA','1150000','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-260319-0008','2026-03-19','2026-03-19 16:08:50','PENJUALAN : FJ-260319-0005','.','TBC','1150000','1150000','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-260319-0009','D','2026-03-19','16:08:50','TBC','PENJUALAN','FJ-260319-0005','21090510014','1150000','21091660014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2050000' WHERE no_faktur_jual='FJ-260319-0005' 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-01898','MIA','1','SEPASANG SILVER','SZ CWE 17 SZ CWO 15 FONT BB ANIV GRAFIR','3.000','2','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01898','2026-03-19','2026-03-19','16:11:20','PLG0010082','kasirbip','2026-04-19','kasirbip','2026-03-19 16:11:20','3.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-19 ','16:11:39');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260319-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260319-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-19 ','17:27:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-19 ','17:34:39');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01844','ASRI','1','PLD','WEDDING RING','','','2.500','','10.00','1','1200000','300000','0','950000','1700000','size 12 grf sahlan','zirkon 14 butir','warna kombinasi rosegold','0','130000','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260319-0009','2026-03-19','2026-03-19 17:42:34','PESANAN : DP-01844','.','TBC','1464000','1464000');
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-260319-0010','D','2026-03-19','17:42:34','TBC','PESANAN','DP-01844','21091660014','1464000','21093124014','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-01844','2026-03-19','2026-03-19','17:42:34','PLG0010083','ASRI','2026-04-27','kasir','2026-03-19 17:42:34','2.500','0','0','0','1464000','0','950000','1830000','1830000','366000');
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-01845','ASRI','1','PLD','WEDDING RING','','','4.000','','10.00','1','1200000','300000','0','700000','1900000','size 22.5 grf alsya','crom putih doff semprot setengah','model sesuai contoh','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260319-0010','2026-03-19','2026-03-19 17:46:27','PESANAN : DP-01845','.','TBC','1520000','1520000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260319-0011','D','2026-03-19','17:46:27','TBC','PESANAN','DP-01845','21093124014','1520000','21094644014','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-01845','2026-03-19','2026-03-19','17:46:27','PLG0010084','ASRI','2026-04-27','kasir','2026-03-19 17:46:27','4.000','0','0','0','1520000','0','700000','1900000','1900000','380000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01846','SULIS','1','GOLD','WED RING','','','2.000','','75.00','1','2550000','2400000','0','850000','5650000','9 zirkon putih glosi','sz 7 gfr Demas & Milda','','90000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260319-0011','2026-03-19','2026-03-19 17:50:35','PESANAN : DP-01846','.','TBC','4592000','4592000');
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-260319-0012','D','2026-03-19','17:50:35','TBC','PESANAN','DP-01846','21094644014','4592000','21099236014','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-01846','2026-03-19','2026-03-19','17:50:35','PLG0010085','SULIS','2026-04-30','kasirbip','2026-03-19 17:50:35','2.000','0','0','0','4592000','0','850000','5740000','5740000','1148000');
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-01847','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','300000','0','850000','1750000','1 zirkon kotak','putih doff semprot','sz 17 gfr Demas & Milda','150000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260319-0012','2026-03-19','2026-03-19 17:54:01','PESANAN : DP-01847','.','TBC','1520000','1520000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260319-0013','D','2026-03-19','17:54:01','TBC','PESANAN','DP-01847','21099236014','1520000','21100756014','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-01847','2026-03-19','2026-03-19','17:54:01','PLG0010086','SULIS','2026-04-30','kasirbip','2026-03-19 17:54:01','3.000','0','0','0','1520000','0','850000','1900000','1900000','380000');
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-260319-0006','kasir','1',' PLDMM-0001','TOKO','MMPLD','PLDMM-ZAAE-36-0','CINCIN PALADIUM PLDMM-00016 ','','2.110','1','5.00','288000','0','0','17000','1673000','0','0','0','1673000','DE','00040921','PLDMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZAAE-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-03-19' AND kode_barang='PLDMM-ZAAE-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260319-0006','2026-03-19','2.110','2026-03-19','18:10:10','PLG0010087','1673000','1673000','0','1673000','0','kasir','2026-03-19 18:10:10','FJ-260319-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-03-19','FJ-260319-0006','2026-03-19','18:10:10','DE','1673000','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-260319-0013','2026-03-19','2026-03-19 18:10:10','PENJUALAN : FJ-260319-0006','.','TBC','1673000','1673000','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-260319-0014','D','2026-03-19','18:10:10','TBC','PENJUALAN','FJ-260319-0006','21100756014','1673000','21102429014','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='1673000' WHERE no_faktur_jual='FJ-260319-0006' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260319-0007','kasir',' 1',' 700K-16-61','TOKO','MMPER','PMM-YKBF-6-0','CINCIN SILVER 925 ','','3.200','1','100.00','196000','0','0','17000','850000','0','0','0','850000','DE','00040001','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKBF-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-03-19' AND kode_barang='PMM-YKBF-6-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-260319-0007','2026-03-19','3.200','2026-03-19','18:10:10','PLG0010088','850000','850000','0','850000','0','kasir','2026-03-19 18:10:10','FJ-260319-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-03-19','FJ-260319-0007','2026-03-19','18:10:10','DE','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-260319-0014','2026-03-19','2026-03-19 18:10:10','PENJUALAN : FJ-260319-0007','.','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-260319-0015','D','2026-03-19','18:10:10','TBC','PENJUALAN','FJ-260319-0007','21102429014','850000','21103279014','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='2523000' WHERE no_faktur_jual='FJ-260319-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260319-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260319-0007';
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-01848','MIA','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','cwo putih doff amplas sz 21','cwe putih glosy sz 13.5','font vintage rotter grf cwe Ivan cwo Asri','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260319-0015','2026-03-19','2026-03-19 20:16:31','PESANAN : DP-01848','.','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-260319-0016','D','2026-03-19','20:16:31','TBC','PESANAN','DP-01848','21103279014','850000','21104129014','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-01848','2026-03-19','2026-03-19','20:16:31','PLG0010089','MIA','2026-04-30','kasirbip','2026-03-19 20:16:31','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-260319-0008','kasirbip','1',' DP-01782BI','TOKO','BIPPSN','PSPRT-ZCXD-1-0','CINCIN PERAK ','','2.040','1','100.00','209000','0','0','17000','750000','0','0','0','750000','KUR','00042185','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCXD-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-03-19' AND kode_barang='PSPRT-ZCXD-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260319-0008','2026-03-19','2.040','2026-03-19','20:23:11','PLG0010090','750000','750000','0','750000','0','kasirbip','2026-03-19 20:23:11','FJ-260319-0008','DP-01782','750000');
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-03-19','FJ-260319-0008','2026-03-19','20:23:11','KUR','750000','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-260319-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260319-0009','kasirbip',' 1',' DP-01781BI','TOKO','BIPPSN','PSPRT-ZCAX-10-0','CINCIN PERAK ','','1.610','1','100.00','165000','0','0','17000','950000','0','0','0','950000','KUR','00042234','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCAX-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-03-19' AND kode_barang='PSPRT-ZCAX-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260319-0009','2026-03-19','1.610','2026-03-19','20:23:11','PLG0010091','950000','950000','0','950000','0','kasirbip','2026-03-19 20:23:11','FJ-260319-0008','DP-01781','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-03-19','FJ-260319-0009','2026-03-19','20:23:11','KUR','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260319-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260319-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260319-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260319-0009';