INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-15 ','09:46:36');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-14';
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-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-14';
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-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-14' 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-260315-0001','D','2026-03-15','09:52:12','TBC','SALDO AWAL','SALDO AWAL','0','21015836014','21015836014');
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-260315-0001','D','2026-03-15','09:52:12','BCK','SALDO AWAL','SALDO AWAL','0','1967608000','1967608000');
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-260315-0001','D','2026-03-15','09:52:12','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-260315-0001','D','2026-03-15','09:52:12','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-260315-0001','D','2026-03-15','09:52:12','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-260315-0001','D','2026-03-15','09:52:12','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-260315-0001','D','2026-03-15','09:52:12','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-260315-0001','D','2026-03-15','09:52:12','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-260315-0001','D','2026-03-15','09:52:12','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-260315-0001','D','2026-03-15','09:52:12','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-260315-0001','D','2026-03-15','09:52:12','BCD','SALDO AWAL','SALDO AWAL','0','1355733500','1355733500');
UPDATE tp_system SET tgl_system='2026-03-15';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-15 ','10:22:40');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-15 ','10:22:43');
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-260315-0001','kasirbip','1',' DP-01790BI','TOKO','BIPPSN','PSPRT-ZCAB-1-0','CINCIN PERAK ','','4.020','1','100.00','411000','0','0','17000','850000','0','0','0','850000','GIN','00042296','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCAB-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PSPRT-ZCAB-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260315-0001','2026-03-15','4.020','2026-03-15','10:23:24','PLG0010004','850000','850000','0','850000','0','kasirbip','2026-03-15 10:23:23','FJ-260315-0001','DP-01790','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-15','FJ-260315-0001','2026-03-15','10:23:24','GIN','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-260315-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260315-0002','kasirbip','1',' DP-01809BI','TOKO','BIPPSN','PSPRT-ZCXD-3-0','CINCIN PERAK ','','3.790','1','100.00','387000','0','0','17000','800000','0','0','0','800000','SULIS','00042187','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCXD-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.790',berat_jual_asli=berat_jual_asli+'3.790',stock_jual='1',berat_akhir=berat_akhir-'3.790',berat_akhir_asli=berat_akhir_asli-'3.790',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PSPRT-ZCXD-3-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-260315-0002','2026-03-15','3.790','2026-03-15','10:26:27','PLG0010005','800000','800000','0','800000','0','kasirbip','2026-03-15 10:26:27','FJ-260315-0002','DP-01809','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-15','FJ-260315-0002','2026-03-15','10:26:27','SULIS','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-260315-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-260315-0003','kasirbip',' 1',' DP-01808BI','TOKO','BIPPSN','PSPRT-ZCXF-15-0','CINCIN PERAK ','','1.820','1','100.00','186000','0','0','17000','1000000','0','0','0','1000000','SULIS','00042218','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCXF-15-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-15' AND kode_barang='PSPRT-ZCXF-15-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-260315-0003','2026-03-15','1.820','2026-03-15','10:26:27','PLG0010006','1000000','1000000','0','1000000','0','kasirbip','2026-03-15 10:26:27','FJ-260315-0002','DP-01808','1000000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-15','FJ-260315-0003','2026-03-15','10:26:27','SULIS','1000000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260315-0003' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-15 ','11:17:50');
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-260315-0004','kasir','1',' DP-01699MM','TOKO','MMPSN','PSGT-ZBAH-1-0','CINCIN EMAS ','','2.580','1','83.00','5865000','0','0','17000','7260000','0','0','0','7260000','NISA','00041619','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBAH-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.580',berat_jual_asli=berat_jual_asli+'2.580',stock_jual='1',berat_akhir=berat_akhir-'2.580',berat_akhir_asli=berat_akhir_asli-'2.580',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PSGT-ZBAH-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-260315-0004','2026-03-15','2.580','2026-03-15','11:34:05','PLG0010007','7260000','7260000','0','7260000','0','kasir','2026-03-15 11:34:04','FJ-260315-0004','DP-01699','5888000');
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-15','FJ-260315-0004','2026-03-15','11:34:05','NISA','7260000','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-260315-0001','2026-03-15','2026-03-15 11:34:04','PENJUALAN : FJ-260315-0004','.','TBC','1372000','1372000','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-260315-0002','D','2026-03-15','11:34:05','TBC','PENJUALAN','FJ-260315-0004','21015836014','1372000','21017208014','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='1372000' WHERE no_faktur_jual='FJ-260315-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-260315-0005','kasir',' 1',' DP-01698MM','TOKO','MMPSN','PSPLT-ZBBC-3-0','CINCIN PALADIUM ','','3.590','1','32.00','1517000','0','0','17000','2495000','0','0','0','2495000','NISA','00041664','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBBC-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.590',berat_jual_asli=berat_jual_asli+'3.590',stock_jual='1',berat_akhir=berat_akhir-'3.590',berat_akhir_asli=berat_akhir_asli-'3.590',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PSPLT-ZBBC-3-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-260315-0005','2026-03-15','3.590','2026-03-15','11:34:05','PLG0010008','2495000','2495000','0','2495000','0','kasir','2026-03-15 11:34:04','FJ-260315-0004','DP-01698','1960000');
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-15','FJ-260315-0005','2026-03-15','11:34:05','NISA','2495000','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-260315-0002','2026-03-15','2026-03-15 11:34:04','PENJUALAN : FJ-260315-0005','.','TBC','535000','535000','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-260315-0003','D','2026-03-15','11:34:05','TBC','PENJUALAN','FJ-260315-0005','21017208014','535000','21017743014','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='1907000' WHERE no_faktur_jual='FJ-260315-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0005';
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-260315-0006','kasirbip','1',' 750K-13-14','TOKO','BIPPER','PBDG-YFAG-32-0','CINCIN SILVER 925 ','','3.200','1','100.00','74000','0','0','17000','900000','0','0','0','900000','GIN','00036382','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFAG-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PBDG-YFAG-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-260315-0006','2026-03-15','3.200','2026-03-15','12:06:34','PLG0010009','900000','900000','0','900000','0','kasirbip','2026-03-15 12:06:34','FJ-260315-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-15','FJ-260315-0006','2026-03-15','12:06:34','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-260315-0003','2026-03-15','2026-03-15 12:06:34','PENJUALAN : FJ-260315-0006','.','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-260315-0004','D','2026-03-15','12:06:34','TBC','PENJUALAN','FJ-260315-0006','21017743014','900000','21018643014','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-260315-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-260315-0007','kasirbip','1',' 800K-13-22','TOKO','BIPPER','PBDG-ZBBG-31-0','CINCIN SILVER 925 ','','2.110','1','100.00','216000','0','0','17000','1000000','0','0','0','1000000','MIA','00042033','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBBG-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PBDG-ZBBG-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-260315-0007','2026-03-15','2.110','2026-03-15','13:51:12','PLG0010010','1000000','1000000','0','1000000','0','kasirbip','2026-03-15 13:51:12','FJ-260315-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-15','FJ-260315-0007','2026-03-15','13:51:12','MIA','1000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260315-0004','2026-03-15','2026-03-15 13:51:12','PENJUALAN : FJ-260315-0007','.','TBC','1000000','1000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260315-0005','D','2026-03-15','13:51:12','TBC','PENJUALAN','FJ-260315-0007','21018643014','1000000','21019643014','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='1000000' WHERE no_faktur_jual='FJ-260315-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-260315-0008','kasirbip',' 1',' 900K-15-00','TOKO','BIPPER','LXPER-ZBBC-62-0','CINCIN SILVER 925 ','','1.800','1','100.00','184000','0','0','17000','1050000','0','0','0','1050000','MIA','00041723','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBC-62-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='LXPER-ZBBC-62-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-260315-0008','2026-03-15','1.800','2026-03-15','13:51:12','PLG0010011','1050000','1050000','0','1050000','0','kasirbip','2026-03-15 13:51:12','FJ-260315-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-15','FJ-260315-0008','2026-03-15','13:51:12','MIA','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-260315-0005','2026-03-15','2026-03-15 13:51:12','PENJUALAN : FJ-260315-0008','.','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-260315-0006','D','2026-03-15','13:51:12','TBC','PENJUALAN','FJ-260315-0008','21019643014','1050000','21020693014','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-260315-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-260315-0009','kasirbip','1',' 700K-105-2','TOKO','BIPPER','PBDG-ZBAF-13-0','CINCIN SILVER 925 ','','2.450','1','100.00','251000','0','0','17000','800000','0','0','0','800000','SULIS','00041568','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBAF-13-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-15' AND kode_barang='PBDG-ZBAF-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-260315-0009','2026-03-15','2.450','2026-03-15','14:59:44','PLG0010012','800000','800000','0','800000','0','kasirbip','2026-03-15 14:59:44','FJ-260315-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-15','FJ-260315-0009','2026-03-15','14:59:44','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-260315-0006','2026-03-15','2026-03-15 14:59:44','PENJUALAN : FJ-260315-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-260315-0007','D','2026-03-15','14:59:44','TBC','PENJUALAN','FJ-260315-0009','21020693014','800000','21021493014','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-260315-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-260315-0010','kasirbip',' 1',' 700K-125-2','TOKO','BIPPER','PBDG-YLXD-142-0','CINCIN SILVER 925 ','','1.750','1','100.00','108000','0','0','17000','800000','0','0','0','800000','SULIS','00040322','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YLXD-142-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PBDG-YLXD-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-260315-0010','2026-03-15','1.750','2026-03-15','14:59:44','PLG0010013','800000','800000','0','800000','0','kasirbip','2026-03-15 14:59:44','FJ-260315-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-15','FJ-260315-0010','2026-03-15','14:59:44','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-260315-0007','2026-03-15','2026-03-15 14:59:44','PENJUALAN : FJ-260315-0010','.','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-260315-0008','D','2026-03-15','14:59:44','TBC','PENJUALAN','FJ-260315-0010','21021493014','800000','21022293014','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-260315-0010' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0010';
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-260315-0011','kasirbip','1',' DP-01794BI','TOKO','BIPPSN','PSPLT-ZCAB-5-0','CINCIN PALADIUM ','','1.320','1','17.00','297000','0','0','17000','1236000','0','0','0','1236000','GIN','00042300','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCAB-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PSPLT-ZCAB-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260315-0011','2026-03-15','1.320','2026-03-15','15:50:26','PLG0010014','1236000','1236000','0','1236000','0','kasirbip','2026-03-15 15:50:25','FJ-260315-0011','DP-01794','700000');
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-15','FJ-260315-0011','2026-03-15','15:50:26','GIN','1236000','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-260315-0008','2026-03-15','2026-03-15 15:50:25','PENJUALAN : FJ-260315-0011','.','TBC','1236000','1236000','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-260315-0009','D','2026-03-15','15:50:26','TBC','PENJUALAN','FJ-260315-0011','21022293014','1236000','21023529014','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='1236000' WHERE no_faktur_jual='FJ-260315-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-260315-0012','kasirbip',' 1',' DP-01795BI','TOKO','BIPPSN','PSPLT-ZCAB-4-0','CINCIN PALADIUM ','','2.720','1','17.00','611000','0','0','17000','1576000','0','0','0','1576000','GIN','00042299','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCAB-4-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-15' AND kode_barang='PSPLT-ZCAB-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260315-0012','2026-03-15','2.720','2026-03-15','15:50:26','PLG0010015','1576000','1576000','0','1576000','0','kasirbip','2026-03-15 15:50:25','FJ-260315-0011','DP-01795','700000');
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-15','FJ-260315-0012','2026-03-15','15:50:26','GIN','1576000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1236000' WHERE no_faktur_jual='FJ-260315-0012' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260315-0013','kasirbip','1',' DP-01729BI','TOKO','BIPPSN','PSPRT-ZCXE-8-0','1PS CINCIN PERAK ','','4.110','1','100.00','420000','0','0','17000','1700000','0','0','0','1700000','KUR','00042196','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCXE-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.110',berat_jual_asli=berat_jual_asli+'4.110',stock_jual='1',berat_akhir=berat_akhir-'4.110',berat_akhir_asli=berat_akhir_asli-'4.110',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PSPRT-ZCXE-8-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-260315-0013','2026-03-15','4.110','2026-03-15','16:57:07','PLG0010016','1700000','1700000','0','1700000','0','kasirbip','2026-03-15 16:57:07','FJ-260315-0013','DP-01729','1700000');
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-15','FJ-260315-0013','2026-03-15','16:57:07','KUR','1700000','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-260315-0013' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-03-15 ','17:05:21');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01835','MIA','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','doft ampelas grf','font vintage rotter','sz 27','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260315-0009','2026-03-15','2026-03-15 17:06:33','PESANAN : DP-01835','.','TBC','900000','900000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260315-0010','D','2026-03-15','17:06:33','TBC','PESANAN','DP-01835','21023529014','900000','21024429014','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01835','2026-03-15','2026-03-15','17:06:33','PLG0010017','MIA','2026-04-28','kasirbip','2026-03-15 17:06:33','3.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01892','ASRI','1','PLD 25','RESIZE NAIK KE SIZE 22 CROM PUTIH DOFF AMPAS SETENGAH','2.700','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-01892','2026-03-15','2026-03-15','17:07:20','PLG0010018','kasir','2026-04-10','kasir','2026-03-15 17:07:20','2.700','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-260315-0014','kasirbip','1',' 850K-24-23','TOKO','BIPPER','PBDG-ZCAA-44-0','CINCIN SILVER 925 ','','4.300','1','100.00','439000','0','0','17000','1000000','0','0','0','1000000','GIN','00042280','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCAA-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.300',berat_jual_asli=berat_jual_asli+'4.300',stock_jual='1',berat_akhir=berat_akhir-'4.300',berat_akhir_asli=berat_akhir_asli-'4.300',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PBDG-ZCAA-44-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-260315-0014','2026-03-15','4.300','2026-03-15','17:08:01','PLG0010019','1000000','1000000','0','1000000','0','kasirbip','2026-03-15 17:08:00','FJ-260315-0014','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-15','FJ-260315-0014','2026-03-15','17:08:01','GIN','1000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260315-0010','2026-03-15','2026-03-15 17:08:00','PENJUALAN : FJ-260315-0014','.','TBC','1000000','1000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260315-0011','D','2026-03-15','17:08:01','TBC','PENJUALAN','FJ-260315-0014','21024429014','1000000','21025429014','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='1000000' WHERE no_faktur_jual='FJ-260315-0014' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-01836','MIA','1','PER','WED RING','','','1.300','','925.00','1','100000','0','1100000','0','1100000','putih glosy grf','font vintage rotter','sz 15','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260315-0011','2026-03-15','2026-03-15 17:11:27','PESANAN : DP-01836','.','TBC','1100000','1100000');
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-260315-0012','D','2026-03-15','17:11:27','TBC','PESANAN','DP-01836','21025429014','1100000','21026529014','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-01836','2026-03-15','2026-03-15','17:11:27','PLG0010020','MIA','2026-04-28','kasirbip','2026-03-15 17:11:27','1.300','0','0','0','1100000','0','0','1100000','1100000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0014';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260315-0015','kasirbip','1',' DP-01823BI','TOKO','BIPPSN','PSPLT-ZCAB-15-0','CINCIN PALADIUM ','','2.480','1','17.00','557000','0','0','17000','1454000','0','0','0','1454000','GIN','00042310','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCAB-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.480',berat_jual_asli=berat_jual_asli+'2.480',stock_jual='1',berat_akhir=berat_akhir-'2.480',berat_akhir_asli=berat_akhir_asli-'2.480',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PSPLT-ZCAB-15-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-260315-0015','2026-03-15','2.480','2026-03-15','18:15:42','PLG0010021','1454000','1454000','0','1454000','0','kasirbip','2026-03-15 18:15:41','FJ-260315-0015','DP-01823','950000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-03-15','FJ-260315-0015','2026-03-15','18:15:42','GIN','1454000','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-260315-0012','2026-03-15','2026-03-15 18:15:41','PENJUALAN : FJ-260315-0015','.','TBC','504000','504000','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-260315-0013','D','2026-03-15','18:15:42','TBC','PENJUALAN','FJ-260315-0015','21026529014','504000','21027033014','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='504000' WHERE no_faktur_jual='FJ-260315-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-260315-0016','kasirbip',' 1',' DP-01822BI','TOKO','BIPPSN','PSPRT-ZCAB-14-0','CINCIN PERAK ','','3.810','1','100.00','389000','0','0','17000','800000','0','0','0','800000','GIN','00042309','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZCAB-14-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-15' AND kode_barang='PSPRT-ZCAB-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-260315-0016','2026-03-15','3.810','2026-03-15','18:15:42','PLG0010022','800000','800000','0','800000','0','kasirbip','2026-03-15 18:15:41','FJ-260315-0015','DP-01822','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-15','FJ-260315-0016','2026-03-15','18:15:42','GIN','800000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='504000' WHERE no_faktur_jual='FJ-260315-0016' 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-01893','GIN','1','CC SILVER','KECILIN SIZE MENJADI 22 GFR JANGAN HILANG','2.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-01893','2026-03-15','2026-03-15','18:32:25','PLG0010023','kasirbip','2026-04-16','kasirbip','2026-03-15 18:32:25','2.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-15 ','18:32:53');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-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-260315-0017','kasirbip','1',' BDCM850K-7','TOKO','BIPCMP','BDCM-YFCX-7-0','BANDUNG CINCIN EMAS ','','1.850','1','83.00','4308000','0','0','17000','5190000','0','0','0','5190000','SULIS','00036808','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YFCX-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='BDCM-YFCX-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260315-0017','2026-03-15','1.850','2026-03-15','19:17:29','PLG0010024','5190000','5190000','0','5190000','0','kasirbip','2026-03-15 19:17:28','FJ-260315-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-15','FJ-260315-0017','2026-03-15','19:17:29','SULIS','5190000','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-260315-0013','2026-03-15','2026-03-15 19:17:28','PENJUALAN : FJ-260315-0017','.','TBC','5190000','5190000','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-260315-0014','D','2026-03-15','19:17:29','TBC','PENJUALAN','FJ-260315-0017','21027033014','5190000','21032223014','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='5190000' WHERE no_faktur_jual='FJ-260315-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0017';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260315-0018','kasir','1',' DP-01726MM','TOKO','MMPSN','PSPLT-ZCXC-2-0','CINCIN PALADIUM ','','2.250','1','32.00','951000','0','0','17000','2245000','0','0','0','2245000','DE','00042145','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZCXC-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PSPLT-ZCXC-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260315-0018','2026-03-15','2.250','2026-03-15','20:27:07','PLG0010025','2245000','2245000','0','2245000','0','kasir','2026-03-15 20:27:06','FJ-260315-0018','DP-01726','1776000');
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-15','FJ-260315-0018','2026-03-15','20:27:07','DE','2245000','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-260315-0014','2026-03-15','2026-03-15 20:27:06','PENJUALAN : FJ-260315-0018','.','TBC','469000','469000','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-260315-0015','D','2026-03-15','20:27:07','TBC','PENJUALAN','FJ-260315-0018','21032223014','469000','21032692014','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='469000' WHERE no_faktur_jual='FJ-260315-0018' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260315-0019','kasir',' 1',' DP-01727MM','TOKO','MMPSN','PSPLT-ZBBG-54-0','CINCIN PALADIUM ','','2.970','1','32.00','1256000','0','0','17000','2185000','0','0','0','2185000','DE','00042056','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-03-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZBBG-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-03-15' AND kode_barang='PSPLT-ZBBG-54-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-260315-0019','2026-03-15','2.970','2026-03-15','20:27:07','PLG0010026','2185000','2185000','0','2185000','0','kasir','2026-03-15 20:27:06','FJ-260315-0018','DP-01727','1720000');
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-15','FJ-260315-0019','2026-03-15','20:27:07','DE','2185000','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-260315-0015','2026-03-15','2026-03-15 20:27:06','PENJUALAN : FJ-260315-0019','.','TBC','465000','465000','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-260315-0016','D','2026-03-15','20:27:07','TBC','PENJUALAN','FJ-260315-0019','21032692014','465000','21033157014','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='934000' WHERE no_faktur_jual='FJ-260315-0019' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260315-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260315-0019';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-03-15 ','21:43:03');