INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-08 ','10:19:36');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-08 ','10:20:56');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-08','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-07';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-07';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-03-07' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-07';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-07';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-07';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-07';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-08' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-07' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','TBC','SALDO AWAL','SALDO AWAL','0','20853603514','20853603514');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','BCD','SALDO AWAL','SALDO AWAL','0','1355733500','1355733500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260308-0001','D','2026-03-08','10:25:10','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000');
UPDATE tp_system SET tgl_system='2026-03-08';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-08 ','10:57:38');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0001','kasirbip','1',' 700K-95-23','TOKO','BIPPER','PBDG-ZCXC-22-0','CINCIN SILVER 925 ','','1.510','1','100.00','155000','0','0','17000','800000','0','0','0','800000','KUR','00042165','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCXC-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZCXC-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-260308-0001','2026-03-08','1.510','2026-03-08','11:01:35','PLG0009840','800000','800000','0','800000','0','kasirbip','2026-03-08 11:01:35','FJ-260308-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-08','FJ-260308-0001','2026-03-08','11:01:35','KUR','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0001','2026-03-08','2026-03-08 11:01:35','PENJUALAN : FJ-260308-0001','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0002','D','2026-03-08','11:01:35','TBC','PENJUALAN','FJ-260308-0001','20853603514','800000','20854403514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-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-260308-0002','kasirbip','1',' 700K-21-22','TOKO','BIPPER','PBDG-ZBAF-11-0','CINCIN SILVER 925 ','','2.630','1','100.00','269000','0','0','17000','800000','0','0','0','800000','MIA','00041566','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAF-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.630',berat_jual_asli=berat_jual_asli+'2.630',stock_jual='1',berat_akhir=berat_akhir-'2.630',berat_akhir_asli=berat_akhir_asli-'2.630',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBAF-11-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-260308-0002','2026-03-08','2.630','2026-03-08','11:23:27','PLG0009841','800000','800000','0','800000','0','kasirbip','2026-03-08 11:23:27','FJ-260308-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-08','FJ-260308-0002','2026-03-08','11:23:27','MIA','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0002','2026-03-08','2026-03-08 11:23:27','PENJUALAN : FJ-260308-0002','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0003','D','2026-03-08','11:23:27','TBC','PENJUALAN','FJ-260308-0002','20854403514','800000','20855203514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-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-260308-0003','kasirbip',' 1',' 700K-17-23','TOKO','BIPPER','PBDG-ZCXC-30-0','CINCIN SILVER 925 ','','1.880','1','100.00','192000','0','0','17000','800000','0','0','0','800000','MIA','00042173','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCXC-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZCXC-30-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-260308-0003','2026-03-08','1.880','2026-03-08','11:23:27','PLG0009842','800000','800000','0','800000','0','kasirbip','2026-03-08 11:23:27','FJ-260308-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-08','FJ-260308-0003','2026-03-08','11:23:27','MIA','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0003','2026-03-08','2026-03-08 11:23:27','PENJUALAN : FJ-260308-0003','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0004','D','2026-03-08','11:23:27','TBC','PENJUALAN','FJ-260308-0003','20855203514','800000','20856003514','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='1600000' WHERE no_faktur_jual='FJ-260308-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0003';
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-260308-0004','kasirbip','1',' DP-01690BI','TOKO','BIPPSN','PSPLT-ZBAG-33-0','CINCIN PALADIUM ','','2.060','1','17.00','463000','0','0','17000','1518000','0','0','0','1518000','SULIS','00041609','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBAG-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSPLT-ZBAG-33-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-260308-0004','2026-03-08','2.060','2026-03-08','11:57:56','PLG0009843','1518000','1518000','0','1518000','0','kasirbip','2026-03-08 11:57:55','FJ-260308-0004','DP-01690','825000');
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-08','FJ-260308-0004','2026-03-08','11:57:56','SULIS','1518000','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-260308-0004','2026-03-08','2026-03-08 11:57:55','PENJUALAN : FJ-260308-0004','.','TBC','693000','693000','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-260308-0005','D','2026-03-08','11:57:56','TBC','PENJUALAN','FJ-260308-0004','20856003514','693000','20856696514','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='693000' WHERE no_faktur_jual='FJ-260308-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-260308-0005','kasirbip',' 1',' DP-01691BI','TOKO','BIPPSN','PSPLT-ZBAG-26-0','CINCIN PALADIUM ','','2.720','1','17.00','611000','0','0','17000','1516000','0','0','0','1516000','SULIS','00041602','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBAG-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.720',berat_jual_asli=berat_jual_asli+'2.720',stock_jual='1',berat_akhir=berat_akhir-'2.720',berat_akhir_asli=berat_akhir_asli-'2.720',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSPLT-ZBAG-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260308-0005','2026-03-08','2.720','2026-03-08','11:57:56','PLG0009844','1516000','1516000','0','1516000','0','kasirbip','2026-03-08 11:57:55','FJ-260308-0004','DP-01691','725000');
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-08','FJ-260308-0005','2026-03-08','11:57:56','SULIS','1516000','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-260308-0005','2026-03-08','2026-03-08 11:57:55','PENJUALAN : FJ-260308-0005','.','TBC','791000','791000','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-260308-0006','D','2026-03-08','11:57:56','TBC','PENJUALAN','FJ-260308-0005','20856696514','791000','20857487514','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='1484000' WHERE no_faktur_jual='FJ-260308-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-08 ','12:02:37');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-08 ','12:06:51');
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-260308-0006','kasir','1',' 750K-20-79','TOKO','MMPER','PMM-ZBXC-11-0','CINCIN SILVER 925 ','','4.610','1','100.00','471000','0','0','17000','850000','0','0','0','850000','DE','00041305','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBXC-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.610',berat_jual_asli=berat_jual_asli+'4.610',stock_jual='1',berat_akhir=berat_akhir-'4.610',berat_akhir_asli=berat_akhir_asli-'4.610',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PMM-ZBXC-11-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-260308-0006','2026-03-08','4.610','2026-03-08','12:11:45','PLG0009845','850000','850000','0','850000','0','kasir','2026-03-08 12:11:45','FJ-260308-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-08','FJ-260308-0006','2026-03-08','12:11:45','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-260308-0006','2026-03-08','2026-03-08 12:11:45','PENJUALAN : FJ-260308-0006','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0007','D','2026-03-08','12:11:45','TBC','PENJUALAN','FJ-260308-0006','20857487514','850000','20858337514','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-260308-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-260308-0007','kasirbip','1',' 700K-17-23','TOKO','BIPPER','PBDG-ZCXC-29-0','CINCIN SILVER 925 ','','2.770','1','100.00','283000','0','0','17000','800000','0','0','0','800000','GIN','00042172','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCXC-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.770',berat_jual_asli=berat_jual_asli+'2.770',stock_jual='1',berat_akhir=berat_akhir-'2.770',berat_akhir_asli=berat_akhir_asli-'2.770',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZCXC-29-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-260308-0007','2026-03-08','2.770','2026-03-08','12:15:09','PLG0009846','800000','800000','0','800000','0','kasirbip','2026-03-08 12:15:08','FJ-260308-0007','','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-08','FJ-260308-0007','2026-03-08','12:15:09','GIN','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0007','2026-03-08','2026-03-08 12:15:08','PENJUALAN : FJ-260308-0007','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0008','D','2026-03-08','12:15:09','TBC','PENJUALAN','FJ-260308-0007','20858337514','800000','20859137514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-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-260308-0008','kasirbip',' 1',' 800K-13-22','TOKO','BIPPER','PBDG-ZBBG-32-0','CINCIN SILVER 925 ','','1.720','1','100.00','176000','0','0','17000','900000','0','0','0','900000','GIN','00042034','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBBG-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBBG-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-260308-0008','2026-03-08','1.720','2026-03-08','12:15:09','PLG0009847','900000','900000','0','900000','0','kasirbip','2026-03-08 12:15:08','FJ-260308-0007','','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-08','FJ-260308-0008','2026-03-08','12:15:09','GIN','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-260308-0008','2026-03-08','2026-03-08 12:15:08','PENJUALAN : FJ-260308-0008','.','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-260308-0009','D','2026-03-08','12:15:09','TBC','PENJUALAN','FJ-260308-0008','20859137514','900000','20860037514','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-260308-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-260308-0009','kasirbip','1',' 700K-15-21','TOKO','BIPPER','PBDG-ZABA-6-0','CINCIN SILVER 925 ','','4.140','1','100.00','254000','0','0','17000','800000','0','0','0','800000','KUR','00041053','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZABA-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.140',berat_jual_asli=berat_jual_asli+'4.140',stock_jual='1',berat_akhir=berat_akhir-'4.140',berat_akhir_asli=berat_akhir_asli-'4.140',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZABA-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-260308-0009','2026-03-08','4.140','2026-03-08','12:27:19','PLG0009848','800000','800000','0','800000','0','kasirbip','2026-03-08 12:27:19','FJ-260308-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-03-08','FJ-260308-0009','2026-03-08','12:27:19','KUR','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0009','2026-03-08','2026-03-08 12:27:19','PENJUALAN : FJ-260308-0009','','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0010','D','2026-03-08','12:27:19','TBC','PENJUALAN','FJ-260308-0009','20860037514','800000','20860837514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0009' 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-260308-0010','kasirbip',' 1',' 950K-10-21','TOKO','BIPPER','PBDG-ZAXF-10-0','CINCIN SILVER 925 ','','2.850','1','100.00','175000','0','0','17000','1100000','0','0','0','1100000','KUR','00040756','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZAXF-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.850',berat_jual_asli=berat_jual_asli+'2.850',stock_jual='1',berat_akhir=berat_akhir-'2.850',berat_akhir_asli=berat_akhir_asli-'2.850',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZAXF-10-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-260308-0010','2026-03-08','2.850','2026-03-08','12:27:19','PLG0009849','1100000','1100000','0','1100000','0','kasirbip','2026-03-08 12:27:19','FJ-260308-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-03-08','FJ-260308-0010','2026-03-08','12:27:19','KUR','1100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0010','2026-03-08','2026-03-08 12:27:19','PENJUALAN : FJ-260308-0010','','TBC','1100000','1100000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0011','D','2026-03-08','12:27:19','TBC','PENJUALAN','FJ-260308-0010','20860837514','1100000','20861937514','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-260308-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0010';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01871','KUR','1','CC SILVER','BULATAN PUTIH DOFF SEMPROT GRAFIR JANGAN ILANG SZ 22','3.000','1','50000','50000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0011','2026-03-08','2026-03-08 13:46:58','SERVICE : SV-01871','.','TBC','50000','50000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0012','D','2026-03-08','13:46:58','TBC','SERVICE','SV-01871','20861937514','50000','20861987514','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01871','2026-03-08','2026-03-08','13:46:58','PLG0009850','kasirbip','2026-04-06','kasirbip','2026-03-08 13:46:58','3.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01872','SULIS','1','SEPASANG SILVER','SZ CWE 10 PUTIH GLOSY SZ CWO 21 PUTIH DOFF SMPROT FONT BERKSHIRE SWASH','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-01872','2026-03-08','2026-03-08','13:49:30','PLG0009851','kasirbip','2026-03-15','kasirbip','2026-03-08 13:49:30','3.000','0','0','0','0','0','0','0','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-260308-0011','kasirbip','1',' 750K-19-22','TOKO','BIPPER','PBDG-ZBBG-13-0','CINCIN SILVER 925 ','','3.810','1','100.00','389000','0','0','17000','800000','0','0','0','800000','SULIS','00042015','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBBG-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.810',berat_jual_asli=berat_jual_asli+'3.810',stock_jual='1',berat_akhir=berat_akhir-'3.810',berat_akhir_asli=berat_akhir_asli-'3.810',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBBG-13-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-260308-0011','2026-03-08','3.810','2026-03-08','13:51:16','PLG0009852','800000','800000','0','800000','0','kasirbip','2026-03-08 13:51:15','FJ-260308-0011','','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-08','FJ-260308-0011','2026-03-08','13:51:16','SULIS','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0012','2026-03-08','2026-03-08 13:51:15','PENJUALAN : FJ-260308-0011','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0013','D','2026-03-08','13:51:16','TBC','PENJUALAN','FJ-260308-0011','20861987514','800000','20862787514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0011' 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-260308-0012','kasirbip',' 1',' 750K-16-22','TOKO','BIPPER','PBDG-ZBBG-1-0','CINCIN SILVER 925 ','','2.590','1','100.00','265000','0','0','17000','900000','0','0','0','900000','SULIS','00042003','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBBG-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.590',berat_jual_asli=berat_jual_asli+'2.590',stock_jual='1',berat_akhir=berat_akhir-'2.590',berat_akhir_asli=berat_akhir_asli-'2.590',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBBG-1-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-260308-0012','2026-03-08','2.590','2026-03-08','13:51:16','PLG0009853','900000','900000','0','900000','0','kasirbip','2026-03-08 13:51:15','FJ-260308-0011','','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-08','FJ-260308-0012','2026-03-08','13:51:16','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-260308-0013','2026-03-08','2026-03-08 13:51:15','PENJUALAN : FJ-260308-0012','.','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-260308-0014','D','2026-03-08','13:51:16','TBC','PENJUALAN','FJ-260308-0012','20862787514','900000','20863687514','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-260308-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0012';
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-260308-0013','kasir','1',' DP-01728MM','TOKO','MMPSN','PSGT-ZBBF-95-0','CINCIN EMAS ','','2.710','1','83.00','6241000','0','0','17000','7475000','0','0','0','7475000','NISA','00041994','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBBF-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.710',berat_jual_asli=berat_jual_asli+'2.710',stock_jual='1',berat_akhir=berat_akhir-'2.710',berat_akhir_asli=berat_akhir_asli-'2.710',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSGT-ZBBF-95-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-260308-0013','2026-03-08','2.710','2026-03-08','14:06:18','PLG0009854','7475000','7475000','0','7475000','0','kasir','2026-03-08 14:06:18','FJ-260308-0013','DP-01728','5560000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-08','FJ-260308-0013','2026-03-08','14:06:18','NISA','7475000','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-260308-0014','2026-03-08','2026-03-08 14:06:18','PENJUALAN : FJ-260308-0013','.','TBC','1915000','1915000','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-260308-0015','D','2026-03-08','14:06:18','TBC','PENJUALAN','FJ-260308-0013','20863687514','1915000','20865602514','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='1915000' WHERE no_faktur_jual='FJ-260308-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-260308-0014','kasir','1',' DP-01793MM','TOKO','MMPSN','PSPRT-ZCXD-4-0','CINCIN PERAK ','','3.670','1','100.00','375000','0','0','17000','800000','0','0','0','800000','NISA','00042188','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCXD-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.670',berat_jual_asli=berat_jual_asli+'3.670',stock_jual='1',berat_akhir=berat_akhir-'3.670',berat_akhir_asli=berat_akhir_asli-'3.670',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSPRT-ZCXD-4-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-260308-0014','2026-03-08','3.670','2026-03-08','14:28:23','PLG0009855','800000','800000','0','800000','0','kasir','2026-03-08 14:28:23','FJ-260308-0014','DP-01793','800000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-08','FJ-260308-0014','2026-03-08','14:28:23','NISA','800000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260308-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-260308-0015','kasirbip','1',' 700K-175-1','TOKO','BIPPER','PBDG-YKBE-121-0','CINCIN SILVER 925 ','','2.070','1','100.00','127000','0','0','17000','800000','0','0','0','800000','MIA','00039953','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-121-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-YKBE-121-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-260308-0015','2026-03-08','2.070','2026-03-08','14:44:47','PLG0009856','800000','800000','0','800000','0','kasirbip','2026-03-08 14:44:47','FJ-260308-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-03-08','FJ-260308-0015','2026-03-08','14:44:47','MIA','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0015','2026-03-08','2026-03-08 14:44:47','PENJUALAN : FJ-260308-0015','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0016','D','2026-03-08','14:44:47','TBC','PENJUALAN','FJ-260308-0015','20865602514','800000','20866402514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-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-260308-0016','kasirbip',' 1',' 800K-15-23','TOKO','BIPPER','PBDG-ZCXC-32-0','CINCIN SILVER 925 ','','1.700','1','100.00','174000','0','0','17000','950000','0','0','0','950000','MIA','00042175','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCXC-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZCXC-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-260308-0016','2026-03-08','1.700','2026-03-08','14:44:47','PLG0009857','950000','950000','0','950000','0','kasirbip','2026-03-08 14:44:47','FJ-260308-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-03-08','FJ-260308-0016','2026-03-08','14:44:47','MIA','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-260308-0016','2026-03-08','2026-03-08 14:44:47','PENJUALAN : FJ-260308-0016','.','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-260308-0017','D','2026-03-08','14:44:47','TBC','PENJUALAN','FJ-260308-0016','20866402514','950000','20867352514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1750000' WHERE no_faktur_jual='FJ-260308-0016' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0016';
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-260308-0017','kasirbip','1',' 750K-12-22','TOKO','BIPPER','PBDG-ZBBG-3-0','CINCIN SILVER 925 ','','2.450','1','100.00','251000','0','0','17000','850000','0','0','0','850000','GIN','00042005','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBBG-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBBG-3-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-260308-0017','2026-03-08','2.450','2026-03-08','14:53:55','PLG0009858','850000','850000','0','850000','0','kasirbip','2026-03-08 14:53:55','FJ-260308-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-03-08','FJ-260308-0017','2026-03-08','14:53:55','GIN','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-260308-0017','2026-03-08','2026-03-08 14:53:55','PENJUALAN : FJ-260308-0017','.','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-260308-0018','D','2026-03-08','14:53:55','TBC','PENJUALAN','FJ-260308-0017','20867352514','850000','20868202514','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-260308-0017' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0018','kasirbip',' 1',' 500K-22-21','TOKO','BIPPER','PBDG-ZABA-5-0','CINCIN SILVER 925 ','','2.140','1','100.00','132000','0','0','17000','600000','0','0','0','600000','GIN','00041052','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZABA-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZABA-5-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-260308-0018','2026-03-08','2.140','2026-03-08','14:53:55','PLG0009859','600000','600000','0','600000','0','kasirbip','2026-03-08 14:53:55','FJ-260308-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-03-08','FJ-260308-0018','2026-03-08','14:53:55','GIN','600000','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-260308-0018','2026-03-08','2026-03-08 14:53:55','PENJUALAN : FJ-260308-0018','.','TBC','600000','600000','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-260308-0019','D','2026-03-08','14:53:55','TBC','PENJUALAN','FJ-260308-0018','20868202514','600000','20868802514','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='1450000' WHERE no_faktur_jual='FJ-260308-0018' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0018';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01873','MIA','1','SEPASANG SILVER','BERKSHINE SWASH GRF','3.770','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01873','2026-03-08','2026-03-08','14:58:39','PLG0009860','kasirbip','2026-04-09','kasirbip','2026-03-08 14:58:39','3.770','0','0','0','0','0','0','0','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-260308-0019','kasirbip','1',' 700K-18-18','TOKO','BIPPER','PBDG-YKBA-21-0','CINCIN SILVER 925 ','','3.390','1','100.00','208000','0','0','17000','800000','0','0','0','800000','GIN','00039767','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBA-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.390',berat_jual_asli=berat_jual_asli+'3.390',stock_jual='1',berat_akhir=berat_akhir-'3.390',berat_akhir_asli=berat_akhir_asli-'3.390',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-YKBA-21-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-260308-0019','2026-03-08','3.390','2026-03-08','15:35:10','PLG0009861','800000','800000','0','800000','0','kasirbip','2026-03-08 15:35:09','FJ-260308-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-03-08','FJ-260308-0019','2026-03-08','15:35:10','GIN','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0019','2026-03-08','2026-03-08 15:35:09','PENJUALAN : FJ-260308-0019','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0020','D','2026-03-08','15:35:10','TBC','PENJUALAN','FJ-260308-0019','20868802514','800000','20869602514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0019' 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-260308-0020','kasirbip',' 1',' 950K-12-18','TOKO','BIPPER','PBDG-YKBA-18-0','CINCIN SILVER 925 ','','2.180','1','100.00','134000','0','0','17000','1050000','0','0','0','1050000','GIN','00039764','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBA-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-YKBA-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260308-0020','2026-03-08','2.180','2026-03-08','15:35:10','PLG0009862','1050000','1050000','0','1050000','0','kasirbip','2026-03-08 15:35:09','FJ-260308-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-03-08','FJ-260308-0020','2026-03-08','15:35:10','GIN','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-260308-0020','2026-03-08','2026-03-08 15:35:09','PENJUALAN : FJ-260308-0020','.','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-260308-0021','D','2026-03-08','15:35:10','TBC','PENJUALAN','FJ-260308-0020','20869602514','1050000','20870652514','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-260308-0020' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-08 ','15:43:41');
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-260308-0021','kasirbip','1',' 500K-18-64','TOKO','BIPPER','TFPER-YEXE-39-0','CINCIN SILVER 925 ','','4.550','1','100.00','105000','0','0','17000','750000','0','0','0','750000','KUR','00035452','TFPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFPER-YEXE-39-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-08' AND kode_barang='TFPER-YEXE-39-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-260308-0021','2026-03-08','4.550','2026-03-08','16:02:39','PLG0009863','750000','750000','0','750000','0','kasirbip','2026-03-08 16:02:39','FJ-260308-0021','','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-08','FJ-260308-0021','2026-03-08','16:02:39','KUR','750000','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-260308-0021','2026-03-08','2026-03-08 16:02:39','PENJUALAN : FJ-260308-0021','.','TBC','750000','750000','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-260308-0022','D','2026-03-08','16:02:39','TBC','PENJUALAN','FJ-260308-0021','20870652514','750000','20871402514','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='750000' WHERE no_faktur_jual='FJ-260308-0021' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0022','kasirbip',' 1',' 1.0K-12-19','TOKO','BIPPER','PBDG-YKBE-142-0','CINCIN SILVER 925 ','','1.820','1','100.00','112000','0','0','17000','1100000','0','0','0','1100000','KUR','00039974','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-142-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-03-08' AND kode_barang='PBDG-YKBE-142-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-260308-0022','2026-03-08','1.820','2026-03-08','16:02:39','PLG0009864','1100000','1100000','0','1100000','0','kasirbip','2026-03-08 16:02:39','FJ-260308-0021','','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-08','FJ-260308-0022','2026-03-08','16:02:39','KUR','1100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0022','2026-03-08','2026-03-08 16:02:39','PENJUALAN : FJ-260308-0022','.','TBC','1100000','1100000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0023','D','2026-03-08','16:02:39','TBC','PENJUALAN','FJ-260308-0022','20871402514','1100000','20872502514','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-260308-0022' 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-01874','NISA','1','2PC CCN SLV','CEWE GRF M ABDUL AZIS DAN COWO GRF AMIRAH MAULANI RESIZE KE 20 KRUM PUTIH DUA DUANYA','4.430','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01874','2026-03-08','2026-03-08','16:04:37','PLG0009865','kasir','2026-03-09','kasir','2026-03-08 16:04:37','4.430','0','0','0','0','0','0','0','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-260308-0023','kasir','1',' 500K-23-79','TOKO','MMPER','PMM-ZBXC-10-0','CINCIN SILVER 925 ','','2.270','1','100.00','232000','0','0','17000','600000','0','0','0','600000','NISA','00041304','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBXC-10-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-03-08' AND kode_barang='PMM-ZBXC-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-260308-0023','2026-03-08','2.270','2026-03-08','16:06:27','PLG0009866','600000','600000','0','600000','0','kasir','2026-03-08 16:06:26','FJ-260308-0023','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-08','FJ-260308-0023','2026-03-08','16:06:27','NISA','600000','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-260308-0023','2026-03-08','2026-03-08 16:06:26','PENJUALAN : FJ-260308-0023','.','TBC','600000','600000','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-260308-0024','D','2026-03-08','16:06:27','TBC','PENJUALAN','FJ-260308-0023','20872502514','600000','20873102514','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='600000' WHERE no_faktur_jual='FJ-260308-0023' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0024','kasir',' 1',' 800K-9-785','TOKO','MMPER','PMM-ZABF-30-0','CINCIN SILVER 925 ','','2.160','1','100.00','133000','0','0','17000','600000','0','0','0','600000','NISA','00041168','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZABF-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PMM-ZABF-30-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-260308-0024','2026-03-08','2.160','2026-03-08','16:06:27','PLG0009867','600000','600000','0','600000','0','kasir','2026-03-08 16:06:26','FJ-260308-0023','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-08','FJ-260308-0024','2026-03-08','16:06:27','NISA','600000','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-260308-0024','2026-03-08','2026-03-08 16:06:26','PENJUALAN : FJ-260308-0024','.','TBC','600000','600000','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-260308-0025','D','2026-03-08','16:06:27','TBC','PENJUALAN','FJ-260308-0024','20873102514','600000','20873702514','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='1200000' WHERE no_faktur_jual='FJ-260308-0024' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0025','kasirbip','1',' 700K-20-21','TOKO','BIPPER','PBDG-ZAAI-37-0','CINCIN SILVER 925 ','','4.860','1','100.00','298000','0','0','17000','800000','0','0','0','800000','GIN','00041019','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZAAI-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.860',berat_jual_asli=berat_jual_asli+'4.860',stock_jual='1',berat_akhir=berat_akhir-'4.860',berat_akhir_asli=berat_akhir_asli-'4.860',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZAAI-37-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-260308-0025','2026-03-08','4.860','2026-03-08','16:27:00','PLG0009868','800000','800000','0','800000','0','kasirbip','2026-03-08 16:26:59','FJ-260308-0025','','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-08','FJ-260308-0025','2026-03-08','16:27:00','GIN','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0025','2026-03-08','2026-03-08 16:26:59','PENJUALAN : FJ-260308-0025','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0026','D','2026-03-08','16:27:00','TBC','PENJUALAN','FJ-260308-0025','20873702514','800000','20874502514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0025' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0026','kasirbip',' 1',' 700K-65-22','TOKO','BIPPER','PBDG-ZBAF-14-0','CINCIN SILVER 925 ','','2.370','1','100.00','242000','0','0','17000','800000','0','0','0','800000','GIN','00041569','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAF-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.370',berat_jual_asli=berat_jual_asli+'2.370',stock_jual='1',berat_akhir=berat_akhir-'2.370',berat_akhir_asli=berat_akhir_asli-'2.370',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBAF-14-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-260308-0026','2026-03-08','2.370','2026-03-08','16:27:00','PLG0009869','800000','800000','0','800000','0','kasirbip','2026-03-08 16:26:59','FJ-260308-0025','','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-08','FJ-260308-0026','2026-03-08','16:27:00','GIN','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0026','2026-03-08','2026-03-08 16:26:59','PENJUALAN : FJ-260308-0026','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0027','D','2026-03-08','16:27:00','TBC','PENJUALAN','FJ-260308-0026','20874502514','800000','20875302514','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='1600000' WHERE no_faktur_jual='FJ-260308-0026' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0027','kasirbip','1',' 1.050K-15-','TOKO','BIPPER','PBDG-ZBAA-31-0','CINCIN SILVER 925 ','','1.780','1','100.00','182000','0','0','17000','1200000','0','0','0','1200000','MIA','00041520','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAA-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBAA-31-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-260308-0027','2026-03-08','1.780','2026-03-08','16:39:59','PLG0009870','1200000','1200000','0','1200000','0','kasirbip','2026-03-08 16:39:58','FJ-260308-0027','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-08','FJ-260308-0027','2026-03-08','16:39:59','MIA','1200000','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-260308-0027','2026-03-08','2026-03-08 16:39:58','PENJUALAN : FJ-260308-0027','.','TBC','1200000','1200000','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-260308-0028','D','2026-03-08','16:39:59','TBC','PENJUALAN','FJ-260308-0027','20875302514','1200000','20876502514','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='1200000' WHERE no_faktur_jual='FJ-260308-0027' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0027';
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-260308-0028','kasir','1',' DP-01718MM','TOKO','MMPSN','PSPLT-ZCXC-1-0','CINCIN PALADIUM ','','2.800','1','32.00','1184000','0','0','17000','2100000','0','0','0','2100000','DE','00042144','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCXC-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.800',berat_jual_asli=berat_jual_asli+'2.800',stock_jual='1',berat_akhir=berat_akhir-'2.800',berat_akhir_asli=berat_akhir_asli-'2.800',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSPLT-ZCXC-1-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-260308-0028','2026-03-08','2.800','2026-03-08','16:56:16','PLG0009871','2100000','2100000','0','2100000','0','kasir','2026-03-08 16:56:16','FJ-260308-0028','DP-01718','1640000');
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-08','FJ-260308-0028','2026-03-08','16:56:16','DE','2100000','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-260308-0028','2026-03-08','2026-03-08 16:56:16','PENJUALAN : FJ-260308-0028','.','TBC','460000','460000','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-260308-0029','D','2026-03-08','16:56:16','TBC','PENJUALAN','FJ-260308-0028','20876502514','460000','20876962514','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='460000' WHERE no_faktur_jual='FJ-260308-0028' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0029','kasirbip','1',' 700K-14-18','TOKO','BIPPER','PBDG-YKBE-66-0','CINCIN SILVER 925 ','','1.380','1','100.00','85000','0','0','17000','800000','0','0','0','800000','SULIS','00039898','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-66-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.380',berat_jual_asli=berat_jual_asli+'1.380',stock_jual='1',berat_akhir=berat_akhir-'1.380',berat_akhir_asli=berat_akhir_asli-'1.380',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-YKBE-66-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-260308-0029','2026-03-08','1.380','2026-03-08','17:08:22','PLG0009872','800000','800000','0','800000','0','kasirbip','2026-03-08 17:08:22','FJ-260308-0029','','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-08','FJ-260308-0029','2026-03-08','17:08:22','SULIS','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0029','2026-03-08','2026-03-08 17:08:22','PENJUALAN : FJ-260308-0029','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0030','D','2026-03-08','17:08:22','TBC','PENJUALAN','FJ-260308-0029','20876962514','800000','20877762514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0029' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0030','kasirbip',' 1',' 700K-23-22','TOKO','BIPPER','PBDG-ZBAA-24-0','CINCIN SILVER 925 ','','4.280','1','100.00','437000','0','0','17000','850000','0','0','0','850000','SULIS','00041513','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAA-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.280',berat_jual_asli=berat_jual_asli+'4.280',stock_jual='1',berat_akhir=berat_akhir-'4.280',berat_akhir_asli=berat_akhir_asli-'4.280',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBAA-24-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-260308-0030','2026-03-08','4.280','2026-03-08','17:08:22','PLG0009873','850000','850000','0','850000','0','kasirbip','2026-03-08 17:08:22','FJ-260308-0029','','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-08','FJ-260308-0030','2026-03-08','17:08:22','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-260308-0030','2026-03-08','2026-03-08 17:08:22','PENJUALAN : FJ-260308-0030','.','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-260308-0031','D','2026-03-08','17:08:22','TBC','PENJUALAN','FJ-260308-0030','20877762514','850000','20878612514','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='1650000' WHERE no_faktur_jual='FJ-260308-0030' 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-01875','SULIS','1','SEPASANG SILVER','CEWE PUTIH GLOSY SZ 15 COWO PUTIH DOFF SEMPROT FONT BRUSH SCRIPT','5.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01875','2026-03-08','2026-03-08','17:10:30','PLG0009874','kasirbip','2026-04-08','kasirbip','2026-03-08 17:10:30','5.000','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0029';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0030';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-03-08 ','17:33:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-03-08 ','17:35:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-08 ','17:39:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-08 ','18:18:44');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-03-08 ','18:22:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-08 ','18:23:08');
DELETE FROM tm_berlian WHERE kode_barang='PMM-YFBX-136-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PMM-YFBX-136-0','00036577','00036577','CINCIN SILVER 925 ','CINCIN SILVER 925','','','48000','48000',' 150000','150000','Nagatech','2026-03-08 18:23:59');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-11-00124 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PMM-YFBX-136-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-08 ','18:27:16');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260308-0031','kasir','1',' TFGRP75-84','TOKO','TFGLR','TFGRP-YLXD-78-0','THIFA GELANG RANTAI PUTIH ','','2.880','1','84.00','6910000','0','0','17000','7000000','0','0','0','7000000','FIR','00040258','TFGRP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRP-YLXD-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.880',berat_jual_asli=berat_jual_asli+'2.880',stock_jual='1',berat_akhir=berat_akhir-'2.880',berat_akhir_asli=berat_akhir_asli-'2.880',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='TFGRP-YLXD-78-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260308-0031','2026-03-08','2.880','2026-03-08','18:30:55','PLG0009875','7000000','7000000','0','7000000','0','kasir','2026-03-08 18:30:54','FJ-260308-0031','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-08','FJ-260308-0031','2026-03-08','18:30:55','FIR','7000000','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-260308-0031','2026-03-08','2026-03-08 18:30:54','PENJUALAN : FJ-260308-0031','.','TBC','7000000','7000000','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-260308-0032','D','2026-03-08','18:30:55','TBC','PENJUALAN','FJ-260308-0031','20878612514','7000000','20885612514','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='7000000' WHERE no_faktur_jual='FJ-260308-0031' 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-260308-0032','kasir',' 1',' TFCMP75-76','TOKO','TFCINMAS','TFCMP-YAXC-10-0','THIFA CINCIN MAS PUTIH ','','0.900','1','76.00','1954000','0','0','17000','2100000','0','0','0','2100000','FIR','00033190','TFCMP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMP-YAXC-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='TFCMP-YAXC-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260308-0032','2026-03-08','0.900','2026-03-08','18:30:55','PLG0009876','2100000','2100000','0','2100000','0','kasir','2026-03-08 18:30:54','FJ-260308-0031','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-08','FJ-260308-0032','2026-03-08','18:30:55','FIR','2100000','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-260308-0032','2026-03-08','2026-03-08 18:30:54','PENJUALAN : FJ-260308-0032','.','TBC','2100000','2100000','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-260308-0033','D','2026-03-08','18:30:55','TBC','PENJUALAN','FJ-260308-0032','20885612514','2100000','20887712514','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='9100000' WHERE no_faktur_jual='FJ-260308-0032' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-08 ','18:30: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-260308-0033','kasir','1',' 700K-11-00','TOKO','MMPER','PMM-YFBX-136-0','CINCIN SILVER 925','','2.400','1','100.00','56000','0','0','17000','800000','0','0','0','800000','DE','00036577','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-136-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PMM-YFBX-136-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-260308-0033','2026-03-08','2.400','2026-03-08','18:31:56','PLG0009877','800000','800000','0','800000','0','kasir','2026-03-08 18:31:55','FJ-260308-0033','','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-08','FJ-260308-0033','2026-03-08','18:31:56','DE','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0033','2026-03-08','2026-03-08 18:31:55','PENJUALAN : FJ-260308-0033','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0034','D','2026-03-08','18:31:56','TBC','PENJUALAN','FJ-260308-0033','20887712514','800000','20888512514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0033' 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-260308-0034','kasir',' 1',' 700K-22-92','TOKO','MMPER','PMM-ZBBG-21-0','CINCIN SILVER 925 ','','2.270','1','100.00','232000','0','0','17000','800000','0','0','0','800000','DE','00042023','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBBG-21-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-03-08' AND kode_barang='PMM-ZBBG-21-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-260308-0034','2026-03-08','2.270','2026-03-08','18:31:56','PLG0009878','800000','800000','0','800000','0','kasir','2026-03-08 18:31:55','FJ-260308-0033','','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-08','FJ-260308-0034','2026-03-08','18:31:56','DE','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0034','2026-03-08','2026-03-08 18:31:55','PENJUALAN : FJ-260308-0034','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0035','D','2026-03-08','18:31:56','TBC','PENJUALAN','FJ-260308-0034','20888512514','800000','20889312514','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='1600000' WHERE no_faktur_jual='FJ-260308-0034' 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-01876','DE','1','2PC CCN SLV','CEWE GRF SAPNA KRUM DOFF SEMPROT PUTIH DAN COWO GRF RIJAL','4.670','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01876','2026-03-08','2026-03-08','18:37:00','PLG0009879','kasir','2026-03-09','kasir','2026-03-08 18:37:00','4.670','0','0','0','0','0','0','0','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01877','NISA','1','2PC CCN SLV','CEWE RESIZE KE 12 GRF PANIEL DAN COWO RESIZE KE 17 GRF VANI','5.680','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01877','2026-03-08','2026-03-08','18:38:03','PLG0009880','kasir','2026-03-09','kasir','2026-03-08 18:38:03','5.680','0','0','0','0','0','0','0','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-260308-0035','kasirbip','1',' 700K-17-22','TOKO','BIPPER','PBDG-ZBBG-9-0','CINCIN SILVER 925 ','','1.890','1','100.00','193000','0','0','17000','800000','0','0','0','800000','SULIS','00042011','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBBG-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBBG-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-260308-0035','2026-03-08','1.890','2026-03-08','18:41:47','PLG0009881','800000','800000','0','800000','0','kasirbip','2026-03-08 18:41:46','FJ-260308-0035','','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-08','FJ-260308-0035','2026-03-08','18:41:47','SULIS','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0035','2026-03-08','2026-03-08 18:41:46','PENJUALAN : FJ-260308-0035','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0036','D','2026-03-08','18:41:47','TBC','PENJUALAN','FJ-260308-0035','20889312514','800000','20890112514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0035' 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-260308-0036','kasirbip',' 1',' 850K-11-14','TOKO','BIPPER','PBDG-YFAG-25-0','CINCIN SILVER 925 ','','3.370','1','100.00','78000','0','0','17000','950000','0','0','0','950000','SULIS','00036375','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFAG-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.370',berat_jual_asli=berat_jual_asli+'3.370',stock_jual='1',berat_akhir=berat_akhir-'3.370',berat_akhir_asli=berat_akhir_asli-'3.370',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-YFAG-25-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-260308-0036','2026-03-08','3.370','2026-03-08','18:41:47','PLG0009882','950000','950000','0','950000','0','kasirbip','2026-03-08 18:41:46','FJ-260308-0035','','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-08','FJ-260308-0036','2026-03-08','18:41:47','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-260308-0036','2026-03-08','2026-03-08 18:41:46','PENJUALAN : FJ-260308-0036','.','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-260308-0037','D','2026-03-08','18:41:47','TBC','PENJUALAN','FJ-260308-0036','20890112514','950000','20891062514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1750000' WHERE no_faktur_jual='FJ-260308-0036' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0034' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0034' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0034';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0035' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0035' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0035';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0036' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0036' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0036';
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-260308-0037','kasir','1',' 700K-19-00','TOKO','MMPER','PBSD-YGBI-89-0','CINCIN SILVER 925 ','','3.030','1','100.00','63000','0','0','17000','800000','0','0','0','800000','NISA','00037725','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBI-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBSD-YGBI-89-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-260308-0037','2026-03-08','3.030','2026-03-08','18:52:47','PLG0009883','800000','800000','0','800000','0','kasir','2026-03-08 18:52:46','FJ-260308-0037','','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-08','FJ-260308-0037','2026-03-08','18:52:47','NISA','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0037','2026-03-08','2026-03-08 18:52:46','PENJUALAN : FJ-260308-0037','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0038','D','2026-03-08','18:52:47','TBC','PENJUALAN','FJ-260308-0037','20891062514','800000','20891862514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0037' 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-260308-0038','kasir',' 1',' 1.150K-15-','TOKO','MMPER','PMM-ZAXI-49-0','CINCIN SILVER 925 ','','2.650','1','100.00','163000','0','0','17000','1250000','0','0','0','1250000','NISA','00040826','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZAXI-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PMM-ZAXI-49-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-260308-0038','2026-03-08','2.650','2026-03-08','18:52:47','PLG0009884','1250000','1250000','0','1250000','0','kasir','2026-03-08 18:52:46','FJ-260308-0037','','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-08','FJ-260308-0038','2026-03-08','18:52:47','NISA','1250000','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-260308-0038','2026-03-08','2026-03-08 18:52:46','PENJUALAN : FJ-260308-0038','.','TBC','1250000','1250000','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-260308-0039','D','2026-03-08','18:52:47','TBC','PENJUALAN','FJ-260308-0038','20891862514','1250000','20893112514','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-260308-0038' 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-01878','SULIS','1','SEPASANG SILVER','CWE PUTIH GLOSY CWO PUTIH DOFF SEMPROT FONT VINTAGE ROTTER','5.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01878','2026-03-08','2026-03-08','18:53:12','PLG0009885','kasirbip','2026-03-09','kasirbip','2026-03-08 18:53:12','5.000','0','0','0','0','0','0','0','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0037' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0037' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0037';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0038' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0038' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0038';
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-260308-0039','kasirbip','1',' 700K-14-22','TOKO','BIPPER','PBDG-ZBAF-12-0','CINCIN SILVER 925 ','','2.760','1','100.00','282000','0','0','17000','800000','0','0','0','800000','MIA','00041567','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAF-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.760',berat_jual_asli=berat_jual_asli+'2.760',stock_jual='1',berat_akhir=berat_akhir-'2.760',berat_akhir_asli=berat_akhir_asli-'2.760',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBAF-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260308-0039','2026-03-08','2.760','2026-03-08','18:57:20','PLG0009886','800000','800000','0','800000','0','kasirbip','2026-03-08 18:57:20','FJ-260308-0039','','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-08','FJ-260308-0039','2026-03-08','18:57:20','MIA','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0039','2026-03-08','2026-03-08 18:57:20','PENJUALAN : FJ-260308-0039','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0040','D','2026-03-08','18:57:20','TBC','PENJUALAN','FJ-260308-0039','20893112514','800000','20893912514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-260308-0039' 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-260308-0040','kasirbip',' 1',' 700K-195-2','TOKO','BIPPER','PBDG-ZBAF-10-0','CINCIN SILVER 925 ','','2.620','1','100.00','268000','0','0','17000','800000','0','0','0','800000','MIA','00041565','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAF-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZBAF-10-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-260308-0040','2026-03-08','2.620','2026-03-08','18:57:20','PLG0009887','800000','800000','0','800000','0','kasirbip','2026-03-08 18:57:20','FJ-260308-0039','','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-08','FJ-260308-0040','2026-03-08','18:57:20','MIA','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260308-0040','2026-03-08','2026-03-08 18:57:20','PENJUALAN : FJ-260308-0040','.','TBC','800000','800000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260308-0041','D','2026-03-08','18:57:20','TBC','PENJUALAN','FJ-260308-0040','20893912514','800000','20894712514','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='1600000' WHERE no_faktur_jual='FJ-260308-0040' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0039' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0039' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0039';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0040' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0040' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0040';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01879','MIA','1','SEPASANG SILVER','CROM SEPERTI ASAL','4.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01879','2026-03-08','2026-03-08','19:01:40','PLG0009888','kasirbip','2026-03-09','kasirbip','2026-03-08 19:01:40','4.000','0','0','0','0','0','0','0','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-260308-0041','kasirbip','1',' DP-01787BI','TOKO','BIPPSN','PSPRT-ZCXF-10-0','1PS CINCIN PERAK ','','2.760','1','100.00','282000','0','0','17000','850000','0','0','0','850000','SULIS','00042213','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCXF-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.760',berat_jual_asli=berat_jual_asli+'2.760',stock_jual='1',berat_akhir=berat_akhir-'2.760',berat_akhir_asli=berat_akhir_asli-'2.760',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSPRT-ZCXF-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-260308-0041','2026-03-08','2.760','2026-03-08','19:35:04','PLG0009889','850000','850000','0','850000','0','kasirbip','2026-03-08 19:35:04','FJ-260308-0041','DP-01787','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-08','FJ-260308-0041','2026-03-08','19:35:04','SULIS','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260308-0041' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0041';
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-260308-0042','kasirbip','1',' 700K-16-23','TOKO','BIPPER','PBDG-ZCXC-20-0','CINCIN SILVER 925 ','','3.080','1','100.00','315000','0','0','17000','850000','0','0','0','850000','GIN','00042163','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCXC-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PBDG-ZCXC-20-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-260308-0042','2026-03-08','3.080','2026-03-08','19:37:58','PLG0009890','850000','850000','0','850000','0','kasirbip','2026-03-08 19:37:58','FJ-260308-0042','','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-08','FJ-260308-0042','2026-03-08','19:37:58','GIN','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-260308-0041','2026-03-08','2026-03-08 19:37:58','PENJUALAN : FJ-260308-0042','.','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-260308-0042','D','2026-03-08','19:37:58','TBC','PENJUALAN','FJ-260308-0042','20894712514','850000','20895562514','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-260308-0042' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0042';
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-260308-0043','kasirbip','1',' DP-01692BI','TOKO','BIPPSN','PSPRT-ZBAG-27-0','CINCIN PERAK ','','1.890','1','100.00','193000','0','0','17000','939000','0','0','0','939000','SULIS','00041603','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZBAG-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSPRT-ZBAG-27-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-260308-0043','2026-03-08','1.890','2026-03-08','20:08:16','PLG0009891','939000','939000','0','939000','0','kasirbip','2026-03-08 20:08:15','FJ-260308-0043','DP-01692','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-08','FJ-260308-0043','2026-03-08','20:08:16','SULIS','939000','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-260308-0042','2026-03-08','2026-03-08 20:08:15','PENJUALAN : FJ-260308-0043','.','TBC','189000','189000','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-260308-0043','D','2026-03-08','20:08:16','TBC','PENJUALAN','FJ-260308-0043','20895562514','189000','20895751514','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='189000' WHERE no_faktur_jual='FJ-260308-0043' 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-260308-0044','kasirbip',' 1',' DP-01693BI','TOKO','BIPPSN','PSPRT-ZBAF-6-0','CINCIN PERAK ','','2.040','1','100.00','209000','0','0','17000','604000','0','0','0','604000','SULIS','00041561','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZBAF-6-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-08' AND kode_barang='PSPRT-ZBAF-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-260308-0044','2026-03-08','2.040','2026-03-08','20:08:16','PLG0009892','604000','604000','0','604000','0','kasirbip','2026-03-08 20:08:15','FJ-260308-0043','DP-01693','400000');
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-08','FJ-260308-0044','2026-03-08','20:08:16','SULIS','604000','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-260308-0043','2026-03-08','2026-03-08 20:08:15','PENJUALAN : FJ-260308-0044','.','TBC','204000','204000','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-260308-0044','D','2026-03-08','20:08:16','TBC','PENJUALAN','FJ-260308-0044','20895751514','204000','20895955514','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='393000' WHERE no_faktur_jual='FJ-260308-0044' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0043' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0043' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0043';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0044' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0044' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0044';
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-260308-0045','kasirbip','1',' DP-01747BI','TOKO','BIPPSN','PSPLT-ZCXF-13-0','CINCIN PALADIUM ','','2.930','1','17.00','658000','0','0','17000','1659000','0','0','0','1659000','KUR','00042216','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCXF-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.930',berat_jual_asli=berat_jual_asli+'2.930',stock_jual='1',berat_akhir=berat_akhir-'2.930',berat_akhir_asli=berat_akhir_asli-'2.930',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSPLT-ZCXF-13-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-260308-0045','2026-03-08','2.930','2026-03-08','20:29:52','PLG0009893','1659000','1659000','0','1659000','0','kasirbip','2026-03-08 20:29:52','FJ-260308-0045','DP-01747','840000');
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-08','FJ-260308-0045','2026-03-08','20:29:52','KUR','1659000','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-260308-0044','2026-03-08','2026-03-08 20:29:52','PENJUALAN : FJ-260308-0045','.','TBC','1659000','1659000','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-260308-0045','D','2026-03-08','20:29:52','TBC','PENJUALAN','FJ-260308-0045','20895955514','1659000','20897614514','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='1659000' WHERE no_faktur_jual='FJ-260308-0045' 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-260308-0046','kasirbip',' 1',' DP-01748BI','TOKO','BIPPSN','PSPLT-ZCXE-14-0','CINCIN PALADIUM ','','3.690','1','17.00','829000','0','0','17000','1807000','0','0','0','1807000','KUR','00042202','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCXE-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.690',berat_jual_asli=berat_jual_asli+'3.690',stock_jual='1',berat_akhir=berat_akhir-'3.690',berat_akhir_asli=berat_akhir_asli-'3.690',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSPLT-ZCXE-14-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-260308-0046','2026-03-08','3.690','2026-03-08','20:29:52','PLG0009894','1807000','1807000','0','1807000','0','kasirbip','2026-03-08 20:29:52','FJ-260308-0045','DP-01748','875000');
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-08','FJ-260308-0046','2026-03-08','20:29:52','KUR','1807000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1659000' WHERE no_faktur_jual='FJ-260308-0046' 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-260308-0047','kasir','1',' 800K-15-78','TOKO','MMPER','PMM-ZABF-32-0','CINCIN SILVER 925 ','','2.350','1','100.00','144000','0','0','17000','600000','0','0','0','600000','DE','00041170','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZABF-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PMM-ZABF-32-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-260308-0047','2026-03-08','2.350','2026-03-08','20:43:23','PLG0009895','600000','600000','0','600000','0','kasir','2026-03-08 20:43:22','FJ-260308-0047','','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-08','FJ-260308-0047','2026-03-08','20:43:23','DE','600000','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-260308-0045','2026-03-08','2026-03-08 20:43:22','PENJUALAN : FJ-260308-0047','.','TBC','600000','600000','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-260308-0046','D','2026-03-08','20:43:23','TBC','PENJUALAN','FJ-260308-0047','20897614514','600000','20898214514','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='600000' WHERE no_faktur_jual='FJ-260308-0047' 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-260308-0048','kasir',' 1',' 500K-13-55','TOKO','MMPER','PMM-YKAD-39-0','CINCIN SILVER 925 ','','1.630','1','100.00','100000','0','0','17000','600000','0','0','0','600000','DE','00039616','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PMM-YKAD-39-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-260308-0048','2026-03-08','1.630','2026-03-08','20:43:23','PLG0009896','600000','600000','0','600000','0','kasir','2026-03-08 20:43:22','FJ-260308-0047','','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-08','FJ-260308-0048','2026-03-08','20:43:23','DE','600000','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-260308-0046','2026-03-08','2026-03-08 20:43:22','PENJUALAN : FJ-260308-0048','.','TBC','600000','600000','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-260308-0047','D','2026-03-08','20:43:23','TBC','PENJUALAN','FJ-260308-0048','20898214514','600000','20898814514','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='1200000' WHERE no_faktur_jual='FJ-260308-0048' 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-01880','DE','1','2PC CCN SLV','CEWE RESIZE KE 13 GRF ADITYA EKA DAN COWO GRF EKA ADITYA','3.980','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01880','2026-03-08','2026-03-08','20:44:24','PLG0009897','kasir','2026-03-09','kasir','2026-03-08 20:44:24','3.980','0','0','0','0','0','0','0','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-260308-0049','kasirbip','1',' DP-01805BI','TOKO','BIPPSN','PSPRT-ZCXE-9-0','CINCIN PERAK ','','3.180','1','100.00','325000','0','0','17000','850000','0','0','0','850000','SULIS','00042197','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-08', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCXE-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-03-08' AND kode_barang='PSPRT-ZCXE-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260308-0049','2026-03-08','3.180','2026-03-08','20:55:55','PLG0009898','850000','850000','0','850000','0','kasirbip','2026-03-08 20:55:55','FJ-260308-0049','DP-01805','850000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-08','FJ-260308-0049','2026-03-08','20:55:55','SULIS','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260308-0049' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0045' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0045' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0045';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0046' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0046' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0046';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0047' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0047' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0047';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0048' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0048' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0048';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0049' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260308-0049' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260308-0049';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';