INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-16 ','10:50:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-16 ','11:16:58');
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-260816-0001','kasirbip','1',' DP-03090BI','TOKO','BIPPSN','PSPLT-ZHXG-32-0','CINCIN PALADIUM ','','3.110','1','17.00','698000','0','0','17800','1838500','0','0','0','1838500','SAL','00045990','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHXG-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PSPLT-ZHXG-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260816-0001','2026-08-16','3.110','2026-08-16','11:18:00','PLG0014515','1838500','1838500','0','1838500','0','kasirbip','2026-08-16 11:18:00','FJ-260816-0001','DP-03090','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-08-16','FJ-260816-0001','2026-08-16','11:18:00','SAL','1838500','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-260816-0001','2026-08-16','2026-08-16 11:18:00','PENJUALAN : FJ-260816-0001','.','TBC','398500','398500','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-260816-0002','D','2026-08-16','11:18:00','TBC','PENJUALAN','FJ-260816-0001','26286109564','398500','26286508064','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='398500' WHERE no_faktur_jual='FJ-260816-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260816-0002','kasirbip',' 1',' DP-03089BI','TOKO','BIPPSN','PSPLT-ZHAD-6-0','CINCIN PALADIUM ','','3.170','1','17.00','712000','0','0','17800','1859500','0','0','0','1859500','SAL','00046154','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHAD-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PSPLT-ZHAD-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-260816-0002','2026-08-16','3.170','2026-08-16','11:18:00','PLG0014516','1859500','1859500','0','1859500','0','kasirbip','2026-08-16 11:18:00','FJ-260816-0001','DP-03089','1580000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0002','2026-08-16','11:18:00','SAL','1859500','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-260816-0002','2026-08-16','2026-08-16 11:18:00','PENJUALAN : FJ-260816-0002','.','TBC','279500','279500','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-260816-0003','D','2026-08-16','11:18:00','TBC','PENJUALAN','FJ-260816-0002','26286508064','279500','26286787564','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='678000' WHERE no_faktur_jual='FJ-260816-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-16 ','12:02:48');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260816-0003','kasirbip','1',' 800K-215-2','TOKO','BIPPER','PBDG-ZHXD-43-0','CINCIN SILVER 925 ','','3.350','1','100.00','342000','0','0','17800','850000','0','0','0','850000','KUR','00045882','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHXD-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.350',berat_jual_asli=berat_jual_asli+'3.350',stock_jual='1',berat_akhir=berat_akhir-'3.350',berat_akhir_asli=berat_akhir_asli-'3.350',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PBDG-ZHXD-43-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-260816-0003','2026-08-16','3.350','2026-08-16','12:05:18','PLG0014517','850000','850000','0','850000','0','kasirbip','2026-08-16 12:05:17','FJ-260816-0003','','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-08-16','FJ-260816-0003','2026-08-16','12:05:18','KUR','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260816-0003','2026-08-16','2026-08-16 12:05:17','PENJUALAN : FJ-260816-0003','.','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-260816-0004','D','2026-08-16','12:05:18','TBC','PENJUALAN','FJ-260816-0003','26286787564','850000','26287637564','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-260816-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-260816-0004','kasirbip',' 1',' 750K-18-28','TOKO','BIPPER','PBDG-ZHAC-6-0','CINCIN SILVER 925 ','','2.960','1','100.00','302000','0','0','17800','850000','0','0','0','850000','KUR','00046120','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHAC-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PBDG-ZHAC-6-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-260816-0004','2026-08-16','2.960','2026-08-16','12:05:18','PLG0014518','850000','850000','0','850000','0','kasirbip','2026-08-16 12:05:17','FJ-260816-0003','','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-08-16','FJ-260816-0004','2026-08-16','12:05:18','KUR','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260816-0004','2026-08-16','2026-08-16 12:05:17','PENJUALAN : FJ-260816-0004','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260816-0005','D','2026-08-16','12:05:18','TBC','PENJUALAN','FJ-260816-0004','26287637564','850000','26288487564','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-260816-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-16 ','12:11:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-16 ','12:12:12');
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-260816-0005','kasirbip','1',' DP-02987DU','TOKO','DUPSN','PSPLT-ZHAA-14-0','CINCIN PALADIUM ','','3.290','1','32.00','1390000','0','0','17800','2559500','0','0','0','2559500','NAD','00046037','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHAA-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.290',berat_jual_asli=berat_jual_asli+'3.290',stock_jual='1',berat_akhir=berat_akhir-'3.290',berat_akhir_asli=berat_akhir_asli-'3.290',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PSPLT-ZHAA-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260816-0005','2026-08-16','3.290','2026-08-16','12:14:01','PLG0014519','2559500','2559500','0','2559500','0','kasirbip','2026-08-16 12:14:01','FJ-260816-0005','DP-02987','2140000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0005','2026-08-16','12:14:01','NAD','2559500','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-260816-0005','2026-08-16','2026-08-16 12:14:01','PENJUALAN : FJ-260816-0005','.','TBC','419500','419500','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-260816-0006','D','2026-08-16','12:14:01','TBC','PENJUALAN','FJ-260816-0005','26288487564','419500','26288907064','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='419500' WHERE no_faktur_jual='FJ-260816-0005' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260816-0006','kasirbip',' 1',' DP-02989DU','TOKO','DUPSN','PSPLT-ZHXG-18-0','CINCIN PALADIUM ','','1.830','1','32.00','774000','0','0','17800','1936500','0','0','0','1936500','NAD','00045976','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHXG-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PSPLT-ZHXG-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260816-0006','2026-08-16','1.830','2026-08-16','12:14:01','PLG0014520','1936500','1936500','0','1936500','0','kasirbip','2026-08-16 12:14:01','FJ-260816-0005','DP-02989','1624000');
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-08-16','FJ-260816-0006','2026-08-16','12:14:01','NAD','1936500','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-260816-0006','2026-08-16','2026-08-16 12:14:01','PENJUALAN : FJ-260816-0006','.','TBC','312500','312500','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-260816-0007','D','2026-08-16','12:14:01','TBC','PENJUALAN','FJ-260816-0006','26288907064','312500','26289219564','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='732000' WHERE no_faktur_jual='FJ-260816-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0006';
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-260816-0007','kasir','1',' DP-03016MM','TOKO','MMPSN','PSGT-ZHAA-6-0','CINCIN EMAS ','','2.410','1','83.00','4857000','0','0','17800','6592500','0','0','0','6592500','ELLA','00046029','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZHAA-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PSGT-ZHAA-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260816-0007','2026-08-16','2.410','2026-08-16','12:14:19','PLG0014521','6592500','6592500','0','6592500','0','kasir','2026-08-16 12:14:18','FJ-260816-0007','DP-03016','5436000');
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-08-16','FJ-260816-0007','2026-08-16','12:14:19','ELLA','6592500','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-260816-0007','2026-08-16','2026-08-16 12:14:18','PENJUALAN : FJ-260816-0007','0','TBC','1156500','1156500','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-260816-0008','D','2026-08-16','12:14:19','TBC','PENJUALAN','FJ-260816-0007','26289219564','1156500','26290376064','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='1156500' WHERE no_faktur_jual='FJ-260816-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-260816-0008','kasir',' 1',' DP-03019MM','TOKO','MMPSN','PSPRT-ZGCX-9-0','CINCIN PERAK ','','2.870','1','100.00','293000','0','0','17800','900000','0','0','0','900000','ELLA','00045737','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZGCX-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PSPRT-ZGCX-9-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-260816-0008','2026-08-16','2.870','2026-08-16','12:14:19','PLG0014522','900000','900000','0','900000','0','kasir','2026-08-16 12:14:18','FJ-260816-0007','DP-03019','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-08-16','FJ-260816-0008','2026-08-16','12:14:19','ELLA','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1156500' WHERE no_faktur_jual='FJ-260816-0008' 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-08-16',  status ='CLOS' WHERE no_service='SV-02195';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02195';
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-260816-0009','kasirbip','1',' 850K-125 ','TOKO','BIPCMP','BDCM-ZGCX-45-0','CINCIN EMAS 9K ','','1.120','1','45.00','1245000','0','0','17800','2418000','0','0','0','2418000','SULIS','00045773','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZGCX-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='BDCM-ZGCX-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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-260816-0009','2026-08-16','1.120','2026-08-16','12:28:40','PLG0014523','2418000','2418000','0','2418000','0','kasirbip','2026-08-16 12:28:39','FJ-260816-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-08-16','FJ-260816-0009','2026-08-16','12:28:40','SULIS','2418000','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-260816-0008','2026-08-16','2026-08-16 12:28:39','PENJUALAN : FJ-260816-0009','.','TBC','2418000','2418000','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-260816-0009','D','2026-08-16','12:28:40','TBC','PENJUALAN','FJ-260816-0009','26290376064','2418000','26292794064','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='2418000' WHERE no_faktur_jual='FJ-260816-0009' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-16 ','12:34:46');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03437','ADL','1','PER','PROMO COUPLE 950','','','1.000','','925.00','1','100000','0','950000','','950000','SIZE CWO 18 CWE 12 COUPLE PROMO950','UKIR Cincin CWO Dila icon Love Cincin Cwe Dede icon Love','Font Brush Script','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260816-0009','2026-08-16','2026-08-16 12:45:54','PESANAN : DP-03437','0','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-260816-0010','D','2026-08-16','12:45:54','TBC','PESANAN','DP-03437','26292794064','950000','26293744064','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-03437','2026-08-16','2026-08-16','12:45:54','PLG0014524','ADL','2026-09-11','jogja','2026-08-16 12:45:54','1.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03438','PUT','1','PLD','WEDRING','','','2.000','','10.00','1','1200000','350000','0','750000','1450000','EXPRESS 100.000','sz 13 crom putih doff semprot','grf Teguh font Vladimir','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260816-0010','2026-08-16','2026-08-16 12:54:56','PESANAN : DP-03438','.','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-260816-0011','D','2026-08-16','12:54:56','TBC','PESANAN','DP-03438','26293744064','1160000','26294904064','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-03438','2026-08-16','2026-08-16','12:54:56','PLG0014525','PUT','2026-08-26','kasirbip','2026-08-16 12:54:56','2.000','0','0','0','1160000','0','750000','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-03439','PUT','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','EXPRESS 100.000','sz 22.5 crom putih dpff semprot','grf Parisya font Vladimir','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-260816-0011','2026-08-16','2026-08-16 12:56:42','PESANAN : DP-03439','.','TBC','1440000','1440000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260816-0012','D','2026-08-16','12:56:42','TBC','PESANAN','DP-03439','26294904064','1440000','26296344064','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-03439','2026-08-16','2026-08-16','12:56:42','PLG0014526','PUT','2026-08-26','kasirbip','2026-08-16 12:56:42','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03440','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwe 12.5 SR.03 grf Irwan','sz cwo 18.5 YL.01 grf Regina','EXPRESS 100.000 font Berkshire','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260816-0012','2026-08-16','2026-08-16 13:30:43','PESANAN : DP-03440','.','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-260816-0013','D','2026-08-16','13:30:43','TBC','PESANAN','DP-03440','26296344064','950000','26297294064','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-03440','2026-08-16','2026-08-16','13:30:43','PLG0014527','PUT','2026-08-27','kasirbip','2026-08-16 13:30:43','3.000','0','0','0','950000','0','0','950000','950000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0008';
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-260816-0010','kasir','1',' 900K-105-1','TOKO','MMPER','PMM-ZHAB-19-0','CINCIN SILVER 925 ','','1.790','1','100.00','183000','0','0','17800','1000000','0','0','0','1000000','ALIKA','00046068','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHAB-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.790',berat_jual_asli=berat_jual_asli+'1.790',stock_jual='1',berat_akhir=berat_akhir-'1.790',berat_akhir_asli=berat_akhir_asli-'1.790',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PMM-ZHAB-19-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-260816-0010','2026-08-16','1.790','2026-08-16','14:03:28','PLG0014528','1000000','1000000','0','1000000','0','kasir','2026-08-16 14:03:27','FJ-260816-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0010','2026-08-16','14:03:28','ALIKA','1000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260816-0013','2026-08-16','2026-08-16 14:03:27','PENJUALAN : FJ-260816-0010','0','TBC','1000000','1000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260816-0014','D','2026-08-16','14:03:28','TBC','PENJUALAN','FJ-260816-0010','26297294064','1000000','26298294064','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='1000000' WHERE no_faktur_jual='FJ-260816-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-260816-0011','kasir',' 1',' 800K-20-11','TOKO','MMPER','PMM-ZHXD-53-0','CINCIN SILVER 925 ','','4.210','1','100.00','430000','0','0','17800','900000','0','0','0','900000','ALIKA','00045892','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHXD-53-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.210',berat_jual_asli=berat_jual_asli+'4.210',stock_jual='1',berat_akhir=berat_akhir-'4.210',berat_akhir_asli=berat_akhir_asli-'4.210',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PMM-ZHXD-53-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-260816-0011','2026-08-16','4.210','2026-08-16','14:03:28','PLG0014529','900000','900000','0','900000','0','kasir','2026-08-16 14:03:27','FJ-260816-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0011','2026-08-16','14:03:28','ALIKA','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260816-0014','2026-08-16','2026-08-16 14:03:27','PENJUALAN : FJ-260816-0011','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-260816-0015','D','2026-08-16','14:03:28','TBC','PENJUALAN','FJ-260816-0011','26298294064','900000','26299194064','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='1900000' WHERE no_faktur_jual='FJ-260816-0011' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03441','PUT','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','sz 15.5 crom putih gllosy','grf Aditya font Vladimir','','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-260816-0015','2026-08-16','2026-08-16 14:27:26','PESANAN : DP-03441','.','TBC','1480000','1480000');
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-260816-0016','D','2026-08-16','14:27:26','TBC','PESANAN','DP-03441','26299194064','1480000','26300674064','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-03441','2026-08-16','2026-08-16','14:27:26','PLG0014530','PUT','2026-09-14','kasirbip','2026-08-16 14:27:26','3.000','0','0','0','1480000','0','800000','1850000','1850000','370000');
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-03442','PUT','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 21.5 crom mata dihilangkan','grf Rachel font vladimir','','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-260816-0016','2026-08-16','2026-08-16 14:29:07','PESANAN : DP-03442','.','TBC','1440000','1440000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260816-0017','D','2026-08-16','14:29:07','TBC','PESANAN','DP-03442','26300674064','1440000','26302114064','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-03442','2026-08-16','2026-08-16','14:29:07','PLG0014531','PUT','2026-09-14','kasirbip','2026-08-16 14:29:07','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03443','KUR','1','PER','WEDR ING','','','2.000','','925.00','1','100000','0','950000','0','950000','cwe 10 cwo 17 model spt contoh','grf cwe Doni 21.09.2026 grf cwo Revi 27.09.2026','font vintage rotter SR-01 7 YL-01','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260816-0017','2026-08-16','2026-08-16 14:42:16','PESANAN : DP-03443','.','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-260816-0018','D','2026-08-16','14:42:16','TBC','PESANAN','DP-03443','26302114064','950000','26303064064','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-03443','2026-08-16','2026-08-16','14:42:16','PLG0014532','KUR','2026-09-07','kasirbip','2026-08-16 14:42:16','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-260816-0012','kasir','1',' 950K-8-730','TOKO','MMPER','PMM-ZAXG-14-0','CINCIN SILVER 925 ','','1.150','1','100.00','71000','0','0','17800','1050000','0','0','0','1050000','ELLA','00040777','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZAXG-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PMM-ZAXG-14-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-260816-0012','2026-08-16','1.150','2026-08-16','15:14:06','PLG0014533','1050000','1050000','0','1050000','0','kasir','2026-08-16 15:14:06','FJ-260816-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0012','2026-08-16','15:14:06','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-260816-0018','2026-08-16','2026-08-16 15:14:06','PENJUALAN : FJ-260816-0012','0','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-260816-0019','D','2026-08-16','15:14:06','TBC','PENJUALAN','FJ-260816-0012','26303064064','1050000','26304114064','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='1050000' WHERE no_faktur_jual='FJ-260816-0012' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260816-0013','kasir',' 1',' 750K-135-1','TOKO','MMPER','PMM-ZHAB-10-0','CINCIN SILVER 925 ','','1.820','1','100.00','186000','0','0','17800','850000','0','0','0','850000','ELLA','00046059','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHAB-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PMM-ZHAB-10-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-260816-0013','2026-08-16','1.820','2026-08-16','15:14:06','PLG0014534','850000','850000','0','850000','0','kasir','2026-08-16 15:14:06','FJ-260816-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0013','2026-08-16','15:14:06','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-260816-0019','2026-08-16','2026-08-16 15:14:06','PENJUALAN : FJ-260816-0013','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-260816-0020','D','2026-08-16','15:14:06','TBC','PENJUALAN','FJ-260816-0013','26304114064','850000','26304964064','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='1900000' WHERE no_faktur_jual='FJ-260816-0013' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260816-0014','kasir','1',' DP-03346MM','TOKO','MMPSN','PSGT-ZHAD-2-0','CINCIN EMAS SR04 ','','1.020','1','45.00','1134000','0','0','17800','2128000','0','0','0','2128000','ELLA','00046150','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZHAD-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PSGT-ZHAD-2-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-260816-0014','2026-08-16','1.020','2026-08-16','15:16:28','PLG0014535','2128000','2128000','0','2128000','-112000','kasir','2026-08-16 15:16:28','FJ-260816-0014','DP-03346','2240000');
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-08-16','FJ-260816-0014','2026-08-16','15:16:28','ELLA','2128000','0');
UPDATE tt_jual_head SET dibayar_rp='-112000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260816-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-260816-0015','kasirbip','1',' 850K-14-00','TOKO','DUPERBDG','LXPER-ZHAD-14-0','CINCIN SILVER 925 ','','2.210','1','100.00','226000','0','0','17800','950000','0','0','0','950000','PUT','00046162','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHAD-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='LXPER-ZHAD-14-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-260816-0015','2026-08-16','2.210','2026-08-16','15:20:08','PLG0014536','950000','950000','0','950000','0','kasirbip','2026-08-16 15:20:08','FJ-260816-0015','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0015','2026-08-16','15:20:08','PUT','950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260816-0020','2026-08-16','2026-08-16 15:20:08','PENJUALAN : FJ-260816-0015','.','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-260816-0021','D','2026-08-16','15:20:08','TBC','PENJUALAN','FJ-260816-0015','26304964064','950000','26305914064','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-260816-0015' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260816-0016','kasirbip',' 1',' 800K-17-00','TOKO','DUPERBDG','LXPER-ZDAE-43-0','CINCIN SILVER 925 ','','3.590','1','100.00','367000','0','0','17800','900000','0','0','0','900000','PUT','00042587','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDAE-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.590',berat_jual_asli=berat_jual_asli+'3.590',stock_jual='1',berat_akhir=berat_akhir-'3.590',berat_akhir_asli=berat_akhir_asli-'3.590',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='LXPER-ZDAE-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260816-0016','2026-08-16','3.590','2026-08-16','15:20:08','PLG0014537','900000','900000','0','900000','0','kasirbip','2026-08-16 15:20:08','FJ-260816-0015','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0016','2026-08-16','15:20:08','PUT','900000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260816-0021','2026-08-16','2026-08-16 15:20:08','PENJUALAN : FJ-260816-0016','.','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260816-0022','D','2026-08-16','15:20:08','TBC','PENJUALAN','FJ-260816-0016','26305914064','900000','26306814064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-260816-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0016';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03444','SAL','1','GOLD','WED RING','','','2.700','','75.00','1','2420000','2250000','0','1000000','7075000','sz 13.5 putih glossy 28 mata','font berkshire swash grf Setiaji','model sprt cnth','280000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260816-0022','2026-08-16','2026-08-16 15:27:23','PESANAN : DP-03444','.','TBC','5884000','5884000');
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-260816-0023','D','2026-08-16','15:27:23','TBC','PESANAN','DP-03444','26306814064','5884000','26312698064','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-03444','2026-08-16','2026-08-16','15:27:23','PLG0014538','SAL','2026-09-15','kasirbip','2026-08-16 15:27:23','2.700','0','0','0','5884000','0','1000000','7355000','7355000','1471000');
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-03445','SAL','1','GOLD','WED RING','','','3.800','','75.00','1','2420000','2250000','0','800000','9350000','sz 18 putih glossy 9 zirkon','font berkshire swash grf Pratiwi','model sprt contoh','90000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260816-0023','2026-08-16','2026-08-16 15:29:11','PESANAN : DP-03445','.','TBC','7552000','7552000');
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-260816-0024','D','2026-08-16','15:29:11','TBC','PESANAN','DP-03445','26312698064','7552000','26320250064','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-03445','2026-08-16','2026-08-16','15:29:11','PLG0014539','SAL','2026-09-15','kasirbip','2026-08-16 15:29:11','3.800','0','0','0','7552000','0','800000','9440000','9440000','1888000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0014';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260816-0017','kasirbip','1',' 850K-12-27','TOKO','BIPPER','PBDG-ZGXF-58-0','CINCIN SILVER 925 ','','1.440','1','100.00','147000','0','0','17800','950000','0','0','0','950000','SULIS','00044986','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGXF-58-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-08-16' AND kode_barang='PBDG-ZGXF-58-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-260816-0017','2026-08-16','1.440','2026-08-16','15:40:03','PLG0014540','950000','950000','0','950000','0','kasirbip','2026-08-16 15:40:03','FJ-260816-0017','','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-08-16','FJ-260816-0017','2026-08-16','15:40:03','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-260816-0024','2026-08-16','2026-08-16 15:40:03','PENJUALAN : FJ-260816-0017','.','TBC','950000','950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260816-0025','D','2026-08-16','15:40:03','TBC','PENJUALAN','FJ-260816-0017','26320250064','950000','26321200064','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-260816-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0017';
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-08-16',  status ='CLOS' WHERE no_service='SV-02163';
UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02163';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-16 ','16:11:07');
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-03446','PUT','1','GOLD','WEDRING','','','2.000','','37.50','1','2420000','1400000','0','850000','3650000','sz 13.5 crom putih gllosy','grf D ... E font Berkshire','zircon 20','0','0','200000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260816-0025','2026-08-16','2026-08-16 16:12:51','PESANAN : DP-03446','.','TBC','3080000','3080000');
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-260816-0026','D','2026-08-16','16:12:51','TBC','PESANAN','DP-03446','26321200064','3080000','26324280064','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-03446','2026-08-16','2026-08-16','16:12:51','PLG0014541','PUT','2026-09-14','kasirbip','2026-08-16 16:12:51','2.000','0','0','0','3080000','0','850000','3850000','3850000','770000');
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-03447','DIL','1','PLD','WEDD RING PRIA','','','4.000','','25.00','1','1200000','550000','0','750000','2950000','SIZE 16.5 GRF: Herryza (infinity) Eva (VINTAGE)','CROM PUTIH GLOSSY MIX DOFF AMPLAS (DETAIL WA)','REQ YG DEPAN ROSE GOLD JADI PUTIH DOFF DALAM GLOSSY','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260816-0026','2026-08-16','2026-08-16 16:15:04','PESANAN : DP-03447','-','TBC','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260816-0027','D','2026-08-16','16:15:04','TBC','PESANAN','DP-03447','26324280064','2000000','26326280064','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-03447','2026-08-16','2026-08-16','16:15:04','PLG0014542','DIL','2026-09-10','sby','2026-08-16 16:15:04','4.000','0','0','0','2000000','0','750000','2950000','2950000','950000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-16 ','16:18:29');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-16 ','16:26:39');
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-260816-0018','kasirbip','1',' 750K-215-2','TOKO','BIPPER','PBDG-ZGAE-22-0','CINCIN SILVER 925 ','','2.270','1','100.00','232000','0','0','17800','850000','0','0','0','850000','SULIS','00045210','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGAE-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PBDG-ZGAE-22-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-260816-0018','2026-08-16','2.270','2026-08-16','16:27:02','PLG0014543','850000','850000','0','850000','0','kasirbip','2026-08-16 16:27:02','FJ-260816-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0018','2026-08-16','16:27:02','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-260816-0027','2026-08-16','2026-08-16 16:27:02','PENJUALAN : FJ-260816-0018','.','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-260816-0028','D','2026-08-16','16:27:02','TBC','PENJUALAN','FJ-260816-0018','26326280064','850000','26327130064','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-260816-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0018';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260816-0019','sby','1',' 750K-185-0','TOKO','SBYPER','PSBY-ZGCA-10-0','CINCIN SILVER 925 ','','2.230','1','100.00','228000','0','0','17800','850000','0','0','0','850000','VAN','00045825','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGCA-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-08-16' AND kode_barang='PSBY-ZGCA-10-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-260816-0019','2026-08-16','2.230','2026-08-16','16:30:09','PLG0014544','850000','850000','0','850000','0','sby','2026-08-16 16:30:09','FJ-260816-0019','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-16','FJ-260816-0019','2026-08-16','16:30:09','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-260816-0028','2026-08-16','2026-08-16 16:30:09','PENJUALAN : FJ-260816-0019','','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-260816-0029','D','2026-08-16','16:30:09','TBC','PENJUALAN','FJ-260816-0019','26327130064','850000','26327980064','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-260816-0019' LIMIT 1;
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260816-0001','1','PSPRT-ZHAD-31-0','1','1.370','1.370','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHAD-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHAD-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHAD-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHAD-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-08-16 16:53:06' WHERE kode_barang='PSPRT-ZHAD-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHAD-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-16 16:53:06','TOKO','JOGPSN','PSPRT','PSPRT-ZHAD-31-0','1','1.370','','1','1.370','','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZHAD-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHAD-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-16' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260816-0001','1','PSPRT-ZHAD-30-0','1','3.420','3.420','TOKO','JOGPSN','TOKO','JOGPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZHAD-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZHAD-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZHAD-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZHAD-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-08-16 16:53:06' WHERE kode_barang='PSPRT-ZHAD-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZHAD-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-16 16:53:06','TOKO','JOGPSN','PSPRT','PSPRT-ZHAD-30-0','1','3.420','','1','3.420','','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZHAD-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZHAD-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-16' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260816-0001','2026-08-16','16:49','4.790','jogja','2026-08-16 16:53:06');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260816-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260816-0019';
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-03448','ELLA','1','PLD','WEDDING RING','','','4.000','','25.00','1','1200000','550000','','800000','3000000','size 13 grf Frida & Bahtiar','warna putih doff Semprot','expres 200000','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-260816-0029','2026-08-16','2026-08-16 17:11:59','PESANAN : DP-03448','0','TBC','2400000','2400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260816-0030','D','2026-08-16','17:11:59','TBC','PESANAN','DP-03448','26327980064','2400000','26330380064','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-03448','2026-08-16','2026-08-16','17:11:59','PLG0014545','ELLA','2026-08-20','kasir','2026-08-16 17:11:59','4.000','0','0','0','2400000','0','800000','3000000','3000000','600000');