INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-28 ','09:44:39');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260628-0001','kasirbip','1',' DP-02613DU','TOKO','DUPSN','PSPRT-ZFBF-33-0','CINCIN PERAK YL-10 ','','5.190','1','100.00','530000','0','0','17800','850000','0','0','0','850000','PUT','00044775','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBF-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.190',berat_jual_asli=berat_jual_asli+'5.190',stock_jual='1',berat_akhir=berat_akhir-'5.190',berat_akhir_asli=berat_akhir_asli-'5.190',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBF-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0001','2026-06-28','5.190','2026-06-28','09:46:39','PLG0012530','850000','850000','0','850000','0','kasirbip','2026-06-28 09:46:39','FJ-260628-0001','DP-02613','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-06-28','FJ-260628-0001','2026-06-28','09:46:39','PUT','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-260628-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-260628-0002','kasirbip',' 1',' DP-02612DU','TOKO','DUPSN','PSPRT-ZFBF-36-0','CINCIN PERAK ','','3.870','1','100.00','395000','0','0','17800','950000','0','0','0','950000','PUT','00044778','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBF-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.870',berat_jual_asli=berat_jual_asli+'3.870',stock_jual='1',berat_akhir=berat_akhir-'3.870',berat_akhir_asli=berat_akhir_asli-'3.870',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBF-36-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0002','2026-06-28','3.870','2026-06-28','09:46:39','PLG0012531','950000','950000','0','950000','0','kasirbip','2026-06-28 09:46:39','FJ-260628-0001','DP-02612','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-06-28','FJ-260628-0002','2026-06-28','09:46:39','PUT','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260628-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-28 ','10:32:48');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260628-0003','kasirbip','1',' DP-02466BI','TOKO','BIPPSN','PSPRT-ZFBD-47-0','CINCIN PERAK SR-03 YL-01 ','','3.550','1','100.00','363000','0','0','17800','1200000','0','0','0','1200000','SAL','00044702','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.550',berat_jual_asli=berat_jual_asli+'3.550',stock_jual='1',berat_akhir=berat_akhir-'3.550',berat_akhir_asli=berat_akhir_asli-'3.550',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBD-47-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-260628-0003','2026-06-28','3.550','2026-06-28','10:33:14','PLG0012532','1200000','1200000','0','1200000','0','kasirbip','2026-06-28 10:33:14','FJ-260628-0003','DP-02466','1200000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-28','FJ-260628-0003','2026-06-28','10:33:14','SAL','1200000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260628-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-28 ','10:44:05');
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-260628-0004','sby','1',' DP-02306SB','TOKO','SBYPSN','PSPLT-ZFBB-39-0','CINCIN PALADIUM ','','4.630','1','17.00','1040000','0','0','17800','2381000','0','0','0','2381000','DIL','00044653','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBB-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.630',berat_jual_asli=berat_jual_asli+'4.630',stock_jual='1',berat_akhir=berat_akhir-'4.630',berat_akhir_asli=berat_akhir_asli-'4.630',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBB-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0004','2026-06-28','4.630','2026-06-28','10:48:25','PLG0012533','2381000','2381000','0','2381000','0','sby','2026-06-28 10:48:25','FJ-260628-0004','DP-02306','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-06-28','FJ-260628-0004','2026-06-28','10:48:25','DIL','2381000','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-260628-0001','2026-06-28','2026-06-28 10:48:25','PENJUALAN : FJ-260628-0004','','TBC','681000','681000','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-260628-0002','D','2026-06-28','10:48:25','TBC','PENJUALAN','FJ-260628-0004','24197962564','681000','24198643564','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='681000' WHERE no_faktur_jual='FJ-260628-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-260628-0005','sby',' 1',' DP-02327SB','TOKO','SBYPSN','PSPLT-ZFBD-53-0','CINCIN PALADIUM ','','2.750','1','32.00','1162000','0','0','17800','2563000','0','0','0','2563000','DIL','00044708','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBD-53-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.750',berat_jual_asli=berat_jual_asli+'2.750',stock_jual='1',berat_akhir=berat_akhir-'2.750',berat_akhir_asli=berat_akhir_asli-'2.750',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBD-53-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0005','2026-06-28','2.750','2026-06-28','10:48:25','PLG0012534','2563000','2563000','0','2563000','0','sby','2026-06-28 10:48:25','FJ-260628-0004','DP-02327','1800000');
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-06-28','FJ-260628-0005','2026-06-28','10:48:25','DIL','2563000','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-260628-0002','2026-06-28','2026-06-28 10:48:25','PENJUALAN : FJ-260628-0005','','TBC','763000','763000','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-260628-0003','D','2026-06-28','10:48:25','TBC','PENJUALAN','FJ-260628-0005','24198643564','763000','24199406564','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='1444000' WHERE no_faktur_jual='FJ-260628-0005' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-28 ','10:49:54');
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-260628-0006','kasirbip','1',' DP-02473DU','TOKO','DUPSN','PSGT-ZFBE-2-0','CINCIN EMAS ','','2.600','1','45.00','2948000','0','0','17800','4940000','0','0','0','4940000','PUT','00044716','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBE-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFBE-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0006','2026-06-28','2.600','2026-06-28','10:53:41','PLG0012535','4940000','4940000','0','4940000','0','kasirbip','2026-06-28 10:53:40','FJ-260628-0006','DP-02473','3832000');
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-06-28','FJ-260628-0006','2026-06-28','10:53:41','PUT','4940000','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-260628-0003','2026-06-28','2026-06-28 10:53:40','PENJUALAN : FJ-260628-0006','.','TBC','1108000','1108000','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-260628-0004','D','2026-06-28','10:53:41','TBC','PENJUALAN','FJ-260628-0006','24199406564','1108000','24200514564','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='1108000' WHERE no_faktur_jual='FJ-260628-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-260628-0007','kasirbip',' 1',' DP-02475DU','TOKO','DUPSN','PSGT-ZFBF-35-0','CINCIN EMAS ','','1.810','1','45.00','2053000','0','0','17800','4025000','0','0','0','4025000','PUT','00044777','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFBF-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0007','2026-06-28','1.810','2026-06-28','10:53:41','PLG0012536','4025000','4025000','0','4025000','0','kasirbip','2026-06-28 10:53:40','FJ-260628-0006','DP-02475','4048000');
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-06-28','FJ-260628-0007','2026-06-28','10:53:41','PUT','4025000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1108000' WHERE no_faktur_jual='FJ-260628-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-260628-0008','kasirbip',' 1',' DP-02476DU','TOKO','DUPSN','PSPLT-ZFBF-11-0','CINCIN PALADIUM YL-01 ','','2.030','1','17.00','456000','0','0','17800','1510500','0','0','0','1510500','PUT','00044753','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBF-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0008','2026-06-28','2.030','2026-06-28','10:53:41','PLG0012537','1510500','1510500','0','1510500','0','kasirbip','2026-06-28 10:53:40','FJ-260628-0006','DP-02476','1480000');
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-06-28','FJ-260628-0008','2026-06-28','10:53:41','PUT','1510500','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-260628-0004','2026-06-28','2026-06-28 10:53:40','PENJUALAN : FJ-260628-0008','.','TBC','30500','30500','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-260628-0005','D','2026-06-28','10:53:41','TBC','PENJUALAN','FJ-260628-0008','24200514564','30500','24200545064','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='1138500' WHERE no_faktur_jual='FJ-260628-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0008';
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-02672','KUR','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','900000','1600000','sz 9 putih glossy 21 zirkon','font vintage rotter grf Ihsan','','210000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0005','2026-06-28','2026-06-28 10:57:41','PESANAN : DP-02672','.','TBC','1440000','1440000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0006','D','2026-06-28','10:57:41','TBC','PESANAN','DP-02672','24200545064','1440000','24201985064','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-02672','2026-06-28','2026-06-28','10:57:41','PLG0012538','KUR','2026-07-21','kasirbip','2026-06-28 10:57:41','2.000','0','0','0','1440000','0','900000','1810000','1810000','370000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02673','KUR','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','750000','1450000','sz 14 YL-01 putih doff amplas','font vintage rotter grf Chindera','model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0006','2026-06-28','2026-06-28 10:59:36','PESANAN : DP-02673','.','TBC','1160000','1160000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0007','D','2026-06-28','10:59:36','TBC','PESANAN','DP-02673','24201985064','1160000','24203145064','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-02673','2026-06-28','2026-06-28','10:59:36','PLG0012539','KUR','2026-07-21','kasirbip','2026-06-28 10:59:36','2.000','0','0','0','1160000','0','750000','1450000','1450000','290000');
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-260628-0009','kasirbip','1',' DP-02280BI','TOKO','BIPPSN','PSPRT-ZFBF-15-0','CINCIN PERAK ','','3.090','1','100.00','316000','0','0','17800','850000','0','0','0','850000','SAL','00044757','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBF-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.090',berat_jual_asli=berat_jual_asli+'3.090',stock_jual='1',berat_akhir=berat_akhir-'3.090',berat_akhir_asli=berat_akhir_asli-'3.090',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBF-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-260628-0009','2026-06-28','3.090','2026-06-28','11:01:50','PLG0012540','850000','850000','0','850000','0','kasirbip','2026-06-28 11:01:49','FJ-260628-0009','DP-02280','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-06-28','FJ-260628-0009','2026-06-28','11:01:50','SAL','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-260628-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-260628-0010','kasirbip',' 1',' DP-02279BI','TOKO','BIPPSN','PSGT-ZFAB-14-0','CINCIN EMAS ','','1.970','1','45.00','2153000','0','0','17800','4135000','0','0','0','4135000','SAL','00044338','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFAB-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFAB-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-260628-0010','2026-06-28','1.970','2026-06-28','11:01:50','PLG0012541','4135000','4135000','0','4135000','0','kasirbip','2026-06-28 11:01:49','FJ-260628-0009','DP-02279','3344000');
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-06-28','FJ-260628-0010','2026-06-28','11:01:50','SAL','4135000','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-260628-0007','2026-06-28','2026-06-28 11:01:49','PENJUALAN : FJ-260628-0010','.','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-260628-0008','D','2026-06-28','11:01:50','TBC','PENJUALAN','FJ-260628-0010','24203145064','791000','24203936064','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='791000' WHERE no_faktur_jual='FJ-260628-0010' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-28 ','11:08:31');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-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-260628-0011','kasirbip','1',' DP-02619DU','TOKO','DUPSN','PSPLT-ZFBF-37-0','CINCIN PALADIUM ','','2.420','1','17.00','544000','0','0','17800','1597000','0','0','0','1597000','PUT','00044779','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.420',berat_jual_asli=berat_jual_asli+'2.420',stock_jual='1',berat_akhir=berat_akhir-'2.420',berat_akhir_asli=berat_akhir_asli-'2.420',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBF-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0011','2026-06-28','2.420','2026-06-28','11:09:43','PLG0012542','1597000','1597000','0','1597000','0','kasirbip','2026-06-28 11:09:43','FJ-260628-0011','DP-02619','1440000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-28','FJ-260628-0011','2026-06-28','11:09:43','PUT','1597000','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-260628-0008','2026-06-28','2026-06-28 11:09:43','PENJUALAN : FJ-260628-0011','.','TBC','157000','157000','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-260628-0009','D','2026-06-28','11:09:43','TBC','PENJUALAN','FJ-260628-0011','24203936064','157000','24204093064','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='157000' WHERE no_faktur_jual='FJ-260628-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-260628-0012','kasirbip',' 1',' DP-02618DU','TOKO','DUPSN','PSPLT-ZFBF-34-0','CINCIN PALADIUM ','','1.660','1','17.00','373000','0','0','17800','1571000','0','0','0','1571000','PUT','00044776','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBF-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0012','2026-06-28','1.660','2026-06-28','11:09:43','PLG0012543','1571000','1571000','0','1571000','0','kasirbip','2026-06-28 11:09:43','FJ-260628-0011','DP-02618','1492000');
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-06-28','FJ-260628-0012','2026-06-28','11:09:43','PUT','1571000','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-260628-0009','2026-06-28','2026-06-28 11:09:43','PENJUALAN : FJ-260628-0012','.','TBC','79000','79000','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-260628-0010','D','2026-06-28','11:09:43','TBC','PENJUALAN','FJ-260628-0012','24204093064','79000','24204172064','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='236000' WHERE no_faktur_jual='FJ-260628-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0012';
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-02674','PUT','1','PLD','WED RING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','sz 13.5 putih doff semprot','font berkshire swash grf Alipiyani','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0010','2026-06-28','2026-06-28 11:36:44','PESANAN : DP-02674','.','TBC','1580000','1580000');
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-260628-0011','D','2026-06-28','11:36:44','TBC','PESANAN','DP-02674','24204172064','1580000','24205752064','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-02674','2026-06-28','2026-06-28','11:36:44','PLG0012544','PUT','2026-07-27','kasirbip','2026-06-28 11:36:44','3.500','0','0','0','1580000','0','750000','1975000','1975000','395000');
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-02675','PUT','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','900000','1600000','24 zircon utih glosy sz 15','font berkshire swash grf Fayyad','','240000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0011','2026-06-28','2026-06-28 11:39:35','PESANAN : DP-02675','.','TBC','1472000','1472000');
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-260628-0012','D','2026-06-28','11:39:35','TBC','PESANAN','DP-02675','24205752064','1472000','24207224064','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-02675','2026-06-28','2026-06-28','11:39:35','PLG0012545','PUT','2026-07-27','kasirbip','2026-06-28 11:39:35','2.000','0','0','0','1472000','0','900000','1840000','1840000','368000');
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-260628-0013','kasirbip','1',' DP-02457BI','TOKO','BIPPSN','PSPRT-ZFBD-13-0','CINCIN PERAK ','','3.200','1','100.00','327000','0','0','17800','950000','0','0','0','950000','SAL','00044668','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-13-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-06-28' AND kode_barang='PSPRT-ZFBD-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-260628-0013','2026-06-28','3.200','2026-06-28','12:01:53','PLG0012546','950000','950000','0','950000','0','kasirbip','2026-06-28 12:01:53','FJ-260628-0013','DP-02457','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-06-28','FJ-260628-0013','2026-06-28','12:01:53','SAL','950000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260628-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-260628-0014','kasirbip',' 1',' DP-02456BI','TOKO','BIPPSN','PSGT-ZFBF-20-0','CINCIN EMAS ','','1.350','1','45.00','1532000','0','0','17800','2955000','0','0','0','2955000','SAL','00044762','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFBF-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0014','2026-06-28','1.350','2026-06-28','12:01:53','PLG0012547','2955000','2955000','0','2955000','-189000','kasirbip','2026-06-28 12:01:53','FJ-260628-0013','DP-02456','3144000');
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-06-28','FJ-260628-0014','2026-06-28','12:01:53','SAL','2955000','0');
UPDATE tt_jual_head SET dibayar_rp='-189000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260628-0014' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0014';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-06-28 ','12:10:42');
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-02676','KUR','1','GOLD','CINCIN KAWIN','','','2.000','','37.50','1','2330000','1500000','0','750000','3750000','size 9.5 grf Fauzi','putih dof semprot sepinggang sirkon 1','font vladimir','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0012','2026-06-28','2026-06-28 12:18:32','PESANAN : DP-02676','.','TBC','3000000','3000000');
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-260628-0013','D','2026-06-28','12:18:32','TBC','PESANAN','DP-02676','24207224064','3000000','24210224064','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-02676','2026-06-28','2026-06-28','12:18:32','PLG0012548','KUR','2026-07-20','kasirbip','2026-06-28 12:18:32','2.000','0','0','0','3000000','0','750000','3750000','3750000','750000');
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-02677','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 19 putih glossy doff semprot','font vladimir grf Imelda','model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0013','2026-06-28','2026-06-28 12:21:52','PESANAN : DP-02677','.','TBC','1450000','1450000');
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-260628-0014','D','2026-06-28','12:21:52','TBC','PESANAN','DP-02677','24210224064','1450000','24211674064','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-02677','2026-06-28','2026-06-28','12:21:52','PLG0012549','KUR','2026-07-20','kasirbip','2026-06-28 12:21:52','3.000','0','0','0','1450000','0','750000','1800000','1800000','350000');
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-02678','DIL','1','PLD','WEDD RING PRIA','','','3.500','','25.00','1','1200000','550000','0','750000','2675000','SIZE 12 GRF: (INFI) DSAYN (NITY) FONT: BERKSHIRE','CROM PUTIH GLOSSY','TANPA PERMATA','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0014','2026-06-28','2026-06-28 12:47:13','PESANAN : DP-02678','-','TBC','1800000','1800000');
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-260628-0015','D','2026-06-28','12:47:13','TBC','PESANAN','DP-02678','24211674064','1800000','24213474064','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-02678','2026-06-28','2026-06-28','12:47:13','PLG0012550','DIL','2026-07-20','sby','2026-06-28 12:47:13','3.500','0','0','0','1800000','0','750000','2675000','2675000','875000');
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-02679','DIL','1','PLD','WEDD RING WANITA','','','3.000','','25.00','1','1200000','550000','0','800000','2450000','PERMATA 3 BUTIR','SIZE 18 GRF : (INFI) DSAYN (NITY) FONT: BERKSHIRE','CROM PUTIH GLOSSY','30000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0015','2026-06-28','2026-06-28 12:49:33','PESANAN : DP-02679','-','TBC','1700000','1700000');
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-260628-0016','D','2026-06-28','12:49:33','TBC','PESANAN','DP-02679','24213474064','1700000','24215174064','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-02679','2026-06-28','2026-06-28','12:49:33','PLG0012551','DIL','2026-07-20','sby','2026-06-28 12:49:33','3.000','0','0','0','1700000','0','800000','2480000','2480000','780000');
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-02680','ELLA','1','GOLD','WEDDING RING','','','1.500','','75.00','1','2330000','2400000','0','1000000','4600000','size 18','warna kuning','zircone 1 butir','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0016','2026-06-28','2026-06-28 12:53:00','PESANAN : DP-02680','0','TBC','3680000','3680000');
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-260628-0017','D','2026-06-28','12:53:00','TBC','PESANAN','DP-02680','24215174064','3680000','24218854064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02680','2026-06-28','2026-06-28','12:53:00','PLG0012552','ELLA','2026-07-27','kasir','2026-06-28 12:53:00','1.500','0','0','0','3680000','0','1000000','4600000','4600000','920000');
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-02681','SAL','1','GOLD','WED RING','','','2.200','','75.00','1','2330000','2400000','0','950000','6230000','sz 10.5 rosegold glossy 17 zirkon','model sprt contoh','','170000','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0017','2026-06-28','2026-06-28 12:59:22','PESANAN : DP-02681','.','TBC','5120000','5120000');
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-260628-0018','D','2026-06-28','12:59:22','TBC','PESANAN','DP-02681','24218854064','5120000','24223974064','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-02681','2026-06-28','2026-06-28','12:59:22','PLG0012553','SAL','2026-07-26','kasirbip','2026-06-28 12:59:22','2.200','0','0','0','5120000','0','950000','6400000','6400000','1280000');
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-02682','KUR','1','GOLD','WED RING','','','2.000','','37.50','1','2330000','1500000','0','750000','3750000','sz 13.5 putih doff semprot 1 zirkon','font arial grf BAYU 26092026','model sprt contoh','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0018','2026-06-28','2026-06-28 13:05:56','PESANAN : DP-02682','.','TBC','3000000','3000000');
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-260628-0019','D','2026-06-28','13:05:56','TBC','PESANAN','DP-02682','24223974064','3000000','24226974064','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-02682','2026-06-28','2026-06-28','13:05:56','PLG0012554','KUR','2026-07-23','kasirbip','2026-06-28 13:05:56','2.000','0','0','0','3000000','0','750000','3750000','3750000','750000');
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-02683','KUR','1','PLD','WED RING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','sz 16 YL-01 putoh doff amplas','font arial SAFHIRDA 26092026','model sprt contoh','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0019','2026-06-28','2026-06-28 13:07:36','PESANAN : DP-02683','.','TBC','1300000','1300000');
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-260628-0020','D','2026-06-28','13:07:36','TBC','PESANAN','DP-02683','24226974064','1300000','24228274064','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-02683','2026-06-28','2026-06-28','13:07:36','PLG0012555','KUR','2026-07-23','kasirbip','2026-06-28 13:07:36','2.500','0','0','0','1300000','0','750000','1625000','1625000','325000');
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-02684','ALIKA','1','PER','WEDDING RING','','','1.000','','925.00','1','100000','0','0','0','1100000','size 17 5 grf fajar','crom putih glosy','zirkon 7 butir','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0020','2026-06-28','2026-06-28 13:55:20','PESANAN : DP-02684','.','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-260628-0021','D','2026-06-28','13:55:20','TBC','PESANAN','DP-02684','24228274064','1100000','24229374064','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-02684','2026-06-28','2026-06-28','13:55:20','PLG0012556','ALIKA','2026-07-27','kasir','2026-06-28 13:55:20','1.000','0','0','0','1100000','0','0','1100000','1100000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02685','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cwe 15.5 grf Badri','sz cwo 21 grf Sheila','font Vintage','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0021','2026-06-28','2026-06-28 13:55:49','PESANAN : DP-02685','.','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0022','D','2026-06-28','13:55:49','TBC','PESANAN','DP-02685','24229374064','850000','24230224064','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-02685','2026-06-28','2026-06-28','13:55:49','PLG0012557','PUT','2026-07-27','kasirbip','2026-06-28 13:55:49','3.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02686','ALIKA','1','PER','WEDDING RING','','','1.000','','925.00','1','100000','0','0','0','900000','size17 5 grf ninda','crom putih doff semprot','model sesuai contoh','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0022','2026-06-28','2026-06-28 13:58:00','PESANAN : DP-02686','.','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-260628-0023','D','2026-06-28','13:58:00','TBC','PESANAN','DP-02686','24230224064','900000','24231124064','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-02686','2026-06-28','2026-06-28','13:58:00','PLG0012558','ALIKA','2026-07-27','kasir','2026-06-28 13:58:00','1.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02687','DIL','1','PLD','WEDD RING PRIA','','','5.000','','10.00','1','1200000','350000','0','700000','2450000','SIZE 16 GRF: Vanda (vintage)','crom putih glossy mix doff','','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0023','2026-06-28','2026-06-28 13:58:21','PESANAN : DP-02687','-','TBC','1700000','1700000');
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-260628-0024','D','2026-06-28','13:58:21','TBC','PESANAN','DP-02687','24231124064','1700000','24232824064','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-02687','2026-06-28','2026-06-28','13:58:21','PLG0012559','DIL','2026-07-25','sby','2026-06-28 13:58:21','5.000','0','0','0','1700000','0','700000','2450000','2450000','750000');
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-02688','KUR','1','PER','CINCIN KAWIN','','','3.000','','925.00','1','100000','0','950000','0','950000','cewe 10 grf Athif model SR-02 SIKON 1','COWO 17.5 grf Anisa model YL-01','font vladimir','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0024','2026-06-28','2026-06-28 13:59:43','PESANAN : DP-02688','.','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0025','D','2026-06-28','13:59:43','TBC','PESANAN','DP-02688','24232824064','950000','24233774064','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-02688','2026-06-28','2026-06-28','13:59:43','PLG0012560','KUR','2026-07-20','kasirbip','2026-06-28 13:59:43','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02689','DIL','1','GOLD','WEDD RING WANITA','','','2.500','','37.50','1','2330000','1500000','0','900000','4650000','PERMATA 19 BUTIR','SIZE 10 GRF: Vanda (vintage)','emas putih','190000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0025','2026-06-28','2026-06-28 14:00:49','PESANAN : DP-02689','-','TBC','3300000','3300000');
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-260628-0026','D','2026-06-28','14:00:49','TBC','PESANAN','DP-02689','24233774064','3300000','24237074064','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-02689','2026-06-28','2026-06-28','14:00:49','PLG0012561','DIL','2026-07-25','sby','2026-06-28 14:00:49','2.500','0','0','0','3300000','0','900000','4840000','4840000','1540000');
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-260628-0015','kasirbip','1',' 500K-18-27','TOKO','BIPPER','PBDG-ZFAF-18-0','CINCIN SILVER 925 YL-01 ','','2.030','1','100.00','208000','0','0','17800','600000','0','0','0','600000','SULIS','00044448','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFAF-18-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PBDG-ZFAF-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-260628-0015','2026-06-28','2.030','2026-06-28','14:10:40','PLG0012562','600000','600000','0','600000','0','kasirbip','2026-06-28 14:10:39','FJ-260628-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-06-28','FJ-260628-0015','2026-06-28','14:10:40','SULIS','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-260628-0026','2026-06-28','2026-06-28 14:10:39','PENJUALAN : FJ-260628-0015','.','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-260628-0027','D','2026-06-28','14:10:40','TBC','PENJUALAN','FJ-260628-0015','24237074064','600000','24237674064','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-260628-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-260628-0016','kasirbip','1',' DP-01637BI','TOKO','BIPPSN','PSGT-ZBXI-20-0','CINCIN EMAS ','','1.870','1','83.00','4323000','0','0','17800','5338000','0','0','0','5338000','SULIS','00041431','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZBXI-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZBXI-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0016','2026-06-28','1.870','2026-06-28','14:12:16','PLG0012563','5338000','5338000','0','5338000','0','kasirbip','2026-06-28 14:12:16','FJ-260628-0016','DP-01637','4000000');
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-06-28','FJ-260628-0016','2026-06-28','14:12:16','SULIS','5338000','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-260628-0027','2026-06-28','2026-06-28 14:12:16','PENJUALAN : FJ-260628-0016','.','TBC','1338000','1338000','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-260628-0028','D','2026-06-28','14:12:16','TBC','PENJUALAN','FJ-260628-0016','24237674064','1338000','24239012064','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='1338000' WHERE no_faktur_jual='FJ-260628-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-02143','SAL','1','SEPASANG PERAK DAN EMAS','CWO RESIZE 18 5 FONT ARIAL','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-02143','2026-06-28','2026-06-28','14:17:03','PLG0012564','kasirbip','2026-06-29','kasirbip','2026-06-28 14:17:03','4.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-28 ','14:17:24');
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-02690','KUR','1','PER','CINCIN KAWIN','','','5.000','','925.00','1','100000','0','950000','','950000','size 23 grf Firda','putih dof amplas model YL-10','FONT BRUSH SCRIPT','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0028','2026-06-28','2026-06-28 14:55:24','PESANAN : DP-02690','.','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0029','D','2026-06-28','14:55:24','TBC','PESANAN','DP-02690','24239012064','950000','24239962064','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-02690','2026-06-28','2026-06-28','14:55:24','PLG0012565','KUR','2026-07-12','kasirbip','2026-06-28 14:55:24','5.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02691','KUR','1','PER','CINCIN KAWIN','','','3.000','','925.00','1','100000','0','950000','0','950000','SIZE 9 GRF Haris','putih dof semprot sirkon 1','font brush sript','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0029','2026-06-28','2026-06-28 15:01:00','PESANAN : DP-02691','.','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0030','D','2026-06-28','15:01:00','TBC','PESANAN','DP-02691','24239962064','950000','24240912064','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-02691','2026-06-28','2026-06-28','15:01:00','PLG0012566','KUR','2026-07-20','kasirbip','2026-06-28 15:01:00','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02144','SULIS','1','PLD DAN SILVER','CWE PASANG MATA PUTIH DOFF SEMPROT CWO PUTIH DOFF AMPLASS','2.000','1','100000','100000');
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-260628-0030','2026-06-28','2026-06-28 15:03:30','SERVICE : SV-02144','.','TBC','100000','100000','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-260628-0031','D','2026-06-28','15:03:30','TBC','SERVICE','SV-02144','24240912064','100000','24241012064','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-02144','2026-06-28','2026-06-28','15:03:30','PLG0012567','kasirbip','2026-07-13','kasirbip','2026-06-28 15:03:30','2.000','0','0','0','100000','0','100000','100000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-28 ','15:03:56');
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-260628-0017','kasirbip','1',' DP-02297BI','TOKO','BIPPSN','PSPLT-ZFBF-31-0','CINCIN PALADIUM ','','2.120','1','17.00','477000','0','0','17800','1442000','0','0','0','1442000','SULIS','00044773','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBF-31-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-260628-0017','2026-06-28','2.120','2026-06-28','15:06:57','PLG0012568','1442000','1442000','0','1442000','0','kasirbip','2026-06-28 15:06:57','FJ-260628-0017','DP-02297','1400000');
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-06-28','FJ-260628-0017','2026-06-28','15:06:57','SULIS','1442000','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-260628-0031','2026-06-28','2026-06-28 15:06:57','PENJUALAN : FJ-260628-0017','.','TBC','42000','42000','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-260628-0032','D','2026-06-28','15:06:57','TBC','PENJUALAN','FJ-260628-0017','24241012064','42000','24241054064','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='42000' WHERE no_faktur_jual='FJ-260628-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-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-260628-0018','sby','1',' DP-02398SB','TOKO','SBYPSN','PSPLT-ZFBE-3-0','CINCIN PALADIUM ','','3.220','1','32.00','1361000','0','0','17800','2531000','0','0','0','2531000','DIL','00044717','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBE-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.220',berat_jual_asli=berat_jual_asli+'3.220',stock_jual='1',berat_akhir=berat_akhir-'3.220',berat_akhir_asli=berat_akhir_asli-'3.220',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBE-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0018','2026-06-28','3.220','2026-06-28','15:19:59','PLG0012569','2531000','2531000','0','2531000','0','sby','2026-06-28 15:19:58','FJ-260628-0018','DP-02398','1800000');
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-06-28','FJ-260628-0018','2026-06-28','15:19:59','DIL','2531000','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-260628-0032','2026-06-28','2026-06-28 15:19:58','PENJUALAN : FJ-260628-0018','','TBC','731000','731000','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-260628-0033','D','2026-06-28','15:19:59','TBC','PENJUALAN','FJ-260628-0018','24241054064','731000','24241785064','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='731000' WHERE no_faktur_jual='FJ-260628-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-260628-0019','sby',' 1',' DP-02399SB','TOKO','SBYPSN','PSPLT-ZFBF-40-0','CINCIN PALADIUM ','','1.820','1','32.00','769000','0','0','17800','2031000','0','0','0','2031000','DIL','00044782','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-40-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-06-28' AND kode_barang='PSPLT-ZFBF-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0019','2026-06-28','1.820','2026-06-28','15:19:59','PLG0012570','2031000','2031000','0','2031000','0','sby','2026-06-28 15:19:58','FJ-260628-0018','DP-02399','1600000');
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-06-28','FJ-260628-0019','2026-06-28','15:19:59','DIL','2031000','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-260628-0033','2026-06-28','2026-06-28 15:19:58','PENJUALAN : FJ-260628-0019','','TBC','431000','431000','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-260628-0034','D','2026-06-28','15:19:59','TBC','PENJUALAN','FJ-260628-0019','24241785064','431000','24242216064','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='1162000' WHERE no_faktur_jual='FJ-260628-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-260628-0020','sby','1',' DP-02431SB','TOKO','SBYPSN','PSPLT-ZFBF-4-0','CINCIN PALADIUM ','','3.490','1','17.00','784000','0','0','17800','1971500','0','0','0','1971500','VAN','00044746','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.490',berat_jual_asli=berat_jual_asli+'3.490',stock_jual='1',berat_akhir=berat_akhir-'3.490',berat_akhir_asli=berat_akhir_asli-'3.490',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBF-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0020','2026-06-28','3.490','2026-06-28','15:39:34','PLG0012571','1971500','1971500','0','1971500','0','sby','2026-06-28 15:39:33','FJ-260628-0020','DP-02431','1300000');
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-06-28','FJ-260628-0020','2026-06-28','15:39:34','VAN','1971500','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-260628-0034','2026-06-28','2026-06-28 15:39:33','PENJUALAN : FJ-260628-0020','','TBC','671500','671500','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-260628-0035','D','2026-06-28','15:39:34','TBC','PENJUALAN','FJ-260628-0020','24242216064','671500','24242887564','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='671500' WHERE no_faktur_jual='FJ-260628-0020' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260628-0021','sby','1',' DP-02359SB','TOKO','SBYPSN','PSPRT-ZFBB-40-0','CINCIN PERAK YL-10 ','','4.380','1','100.00','447000','0','0','17800','800000','0','0','0','800000','VAN','00044654','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBB-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.380',berat_jual_asli=berat_jual_asli+'4.380',stock_jual='1',berat_akhir=berat_akhir-'4.380',berat_akhir_asli=berat_akhir_asli-'4.380',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBB-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0021','2026-06-28','4.380','2026-06-28','15:47:46','PLG0012572','800000','800000','0','800000','0','sby','2026-06-28 15:47:46','FJ-260628-0021','DP-02359','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-06-28','FJ-260628-0021','2026-06-28','15:47:46','VAN','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-260628-0021' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0020';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0021';
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-260628-0022','kasirbip','1',' DP-02463BI','TOKO','BIPPSN','PSPRT-ZFBD-14-0','CINCIN PERAK YL-10 ','','4.920','1','100.00','502000','0','0','17800','900000','0','0','0','900000','KUR','00044669','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.920',berat_jual_asli=berat_jual_asli+'4.920',stock_jual='1',berat_akhir=berat_akhir-'4.920',berat_akhir_asli=berat_akhir_asli-'4.920',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBD-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-260628-0022','2026-06-28','4.920','2026-06-28','16:08:26','PLG0012573','900000','900000','0','900000','0','kasirbip','2026-06-28 16:08:25','FJ-260628-0022','DP-02463','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-28','FJ-260628-0022','2026-06-28','16:08:26','KUR','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-260628-0035','2026-06-28','2026-06-28 16:08:25','PENJUALAN : FJ-260628-0022','.','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-260628-0036','D','2026-06-28','16:08:26','TBC','PENJUALAN','FJ-260628-0022','24242887564','900000','24243787564','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-260628-0022' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260628-0023','kasirbip',' 1',' DP-02462BI','TOKO','BIPPSN','PSGT-ZFBF-17-0','CINCIN EMAS ','','2.690','1','45.00','3050000','0','0','17800','4785000','0','0','0','4785000','KUR','00044759','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.690',berat_jual_asli=berat_jual_asli+'2.690',stock_jual='1',berat_akhir=berat_akhir-'2.690',berat_akhir_asli=berat_akhir_asli-'2.690',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFBF-17-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-260628-0023','2026-06-28','2.690','2026-06-28','16:08:26','PLG0012574','4785000','4785000','0','4785000','0','kasirbip','2026-06-28 16:08:25','FJ-260628-0022','DP-02462','3600000');
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-06-28','FJ-260628-0023','2026-06-28','16:08:26','KUR','4785000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-260628-0023' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0023';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-28 ','16:20:56');
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-260628-0024','sby','1',' DP-02407SB','TOKO','SBYPSN','PSPRT-ZFBB-38-0','CINCIN PERAK ','','5.820','1','100.00','594000','0','0','17800','800000','0','0','0','800000','VAN','00044652','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBB-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.820',berat_jual_asli=berat_jual_asli+'5.820',stock_jual='1',berat_akhir=berat_akhir-'5.820',berat_akhir_asli=berat_akhir_asli-'5.820',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBB-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0024','2026-06-28','5.820','2026-06-28','16:21:53','PLG0012575','800000','800000','0','800000','0','sby','2026-06-28 16:21:52','FJ-260628-0024','DP-02407','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-06-28','FJ-260628-0024','2026-06-28','16:21:53','VAN','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-260628-0024' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-28 ','16:23:03');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0024';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-28 ','16:24:27');
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-02692','VAN','1','PER','WEDDRING 950K SEPAKET','','','3.000','','925.00','1','100000','0','950000','0','950000','SIZE WANITA: 18 SIZE PRIA: 18','GRF WANITA: Sabil ?? GRF PRIA: Putri??','PUTIH FONT: VINTAGE ROTTER','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0036','2026-06-28','2026-06-28 16:29:18','PESANAN : DP-02692','-','TBC','950000','950000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0037','D','2026-06-28','16:29:18','TBC','PESANAN','DP-02692','24243787564','950000','24244737564','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-02692','2026-06-28','2026-06-28','16:29:18','PLG0012576','VAN','2026-07-23','sby','2026-06-28 16:29:18','3.000','0','0','0','950000','0','0','950000','950000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260628-0025','sby','1',' DP-02393SB','TOKO','SBYPSN','PSPRT-ZFBD-26-0','CINCIN PERAK ','','2.190','1','100.00','224000','0','0','17800','850000','0','0','0','850000','VAN','00044681','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBD-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0025','2026-06-28','2.190','2026-06-28','16:34:15','PLG0012577','850000','850000','0','850000','0','sby','2026-06-28 16:34:14','FJ-260628-0025','DP-02393','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-06-28','FJ-260628-0025','2026-06-28','16:34:15','VAN','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260628-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-260628-0026','sby','1',' DP-02320SB','TOKO','SBYPSN','PSGT-ZFBF-6-0','CINCIN EMAS YL-10 ','','5.080','1','45.00','5760000','0','0','17800','8320000','0','0','0','8320000','DIL','00044748','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.080',berat_jual_asli=berat_jual_asli+'5.080',stock_jual='1',berat_akhir=berat_akhir-'5.080',berat_akhir_asli=berat_akhir_asli-'5.080',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFBF-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0026','2026-06-28','5.080','2026-06-28','17:05:36','PLG0012578','8320000','8320000','0','8320000','0','sby','2026-06-28 17:05:36','FJ-260628-0026','DP-02320','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-06-28','FJ-260628-0026','2026-06-28','17:05:36','DIL','8320000','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-260628-0037','2026-06-28','2026-06-28 17:05:36','PENJUALAN : FJ-260628-0026','','TBC','6620000','6620000','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-260628-0038','D','2026-06-28','17:05:36','TBC','PENJUALAN','FJ-260628-0026','24244737564','6620000','24251357564','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='6620000' WHERE no_faktur_jual='FJ-260628-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-260628-0027','sby',' 1',' DP-02321SB','TOKO','SBYPSN','PSGT-ZFBF-46-0','CINCIN EMAS ','','2.440','1','57.00','3505000','0','0','17800','5930000','0','0','0','5930000','DIL','00044788','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.440',berat_jual_asli=berat_jual_asli+'2.440',stock_jual='1',berat_akhir=berat_akhir-'2.440',berat_akhir_asli=berat_akhir_asli-'2.440',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFBF-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0027','2026-06-28','2.440','2026-06-28','17:05:36','PLG0012579','5930000','5930000','0','5930000','0','sby','2026-06-28 17:05:36','FJ-260628-0026','DP-02321','4300000');
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-06-28','FJ-260628-0027','2026-06-28','17:05:36','DIL','5930000','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-260628-0038','2026-06-28','2026-06-28 17:05:36','PENJUALAN : FJ-260628-0027','','TBC','1630000','1630000','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-260628-0039','D','2026-06-28','17:05:36','TBC','PENJUALAN','FJ-260628-0027','24251357564','1630000','24252987564','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='8250000' WHERE no_faktur_jual='FJ-260628-0027' 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-260628-0028','sby','1',' DP-02397SB','TOKO','SBYPSN','PSPRT-ZFBD-27-0','CINCIN PERAK ','','1.590','1','100.00','163000','0','0','17800','800000','0','0','0','800000','DIL','00044682','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.590',berat_jual_asli=berat_jual_asli+'1.590',stock_jual='1',berat_akhir=berat_akhir-'1.590',berat_akhir_asli=berat_akhir_asli-'1.590',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBD-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0028','2026-06-28','1.590','2026-06-28','17:09:11','PLG0012580','800000','800000','0','800000','0','sby','2026-06-28 17:09:11','FJ-260628-0028','DP-02397','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-06-28','FJ-260628-0028','2026-06-28','17:09:11','DIL','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-260628-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-260628-0029','kasirbip','1',' DP-02424BI','TOKO','BIPPSN','PSGT-ZFBD-12-0','CINCIN EMAS ','','1.850','1','45.00','2098000','0','0','17800','3695000','0','0','0','3695000','KUR','00044667','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBD-12-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-06-28' AND kode_barang='PSGT-ZFBD-12-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-260628-0029','2026-06-28','1.850','2026-06-28','17:15:54','PLG0012581','3695000','3695000','0','3695000','0','kasirbip','2026-06-28 17:15:53','FJ-260628-0029','DP-02424','3735000');
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-06-28','FJ-260628-0029','2026-06-28','17:15:54','KUR','3695000','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-260628-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-260628-0030','kasirbip',' 1',' DP-02425BI','TOKO','BIPPSN','PSPLT-ZFBD-46-0','CINCIN PALADIUM ','','4.030','1','17.00','905000','0','0','17800','2210500','0','0','0','2210500','KUR','00044701','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBD-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBD-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0030','2026-06-28','4.030','2026-06-28','17:15:54','PLG0012582','2210500','2210500','0','2210500','0','kasirbip','2026-06-28 17:15:53','FJ-260628-0029','DP-02425','1760000');
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-06-28','FJ-260628-0030','2026-06-28','17:15:54','KUR','2210500','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-260628-0039','2026-06-28','2026-06-28 17:15:53','PENJUALAN : FJ-260628-0030','.','TBC','450500','450500','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-260628-0040','D','2026-06-28','17:15:54','TBC','PENJUALAN','FJ-260628-0030','24252987564','450500','24253438064','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='450500' WHERE no_faktur_jual='FJ-260628-0030' 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-02693','ALIKA','1','GOLD','WEDDING RING','','','2.000','','50.00','1','2330000','2100000','0','900000','5100000','size 10 grf fahmi','warna putih glosy','zircone 15 butir','0','0','150000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0040','2026-06-28','2026-06-28 17:21:25','PESANAN : DP-02693','0','TBC','4200000','4200000');
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-260628-0041','D','2026-06-28','17:21:25','TBC','PESANAN','DP-02693','24253438064','4200000','24257638064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02693','2026-06-28','2026-06-28','17:21:25','PLG0012583','ALIKA','2026-07-27','kasir','2026-06-28 17:21:25','2.000','0','0','0','4200000','0','900000','5250000','5250000','1050000');
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-02694','ALIKA','1','PER','WEDDING RING','','','2.000','','925.00','1','100000','0','0','0','850000','size 15 grf lestari','warna putih glosy','','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0041','2026-06-28','2026-06-28 17:24:03','PESANAN : DP-02694','0','TBC','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0042','D','2026-06-28','17:24:03','TBC','PESANAN','DP-02694','24257638064','850000','24258488064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-02694','2026-06-28','2026-06-28','17:24:03','PLG0012584','ALIKA','2026-07-27','kasir','2026-06-28 17:24:03','2.000','0','0','0','850000','0','0','850000','850000','0');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260628-0031','sby','1',' DP-02351SB','TOKO','SBYPSN','PSPLT-ZFBF-7-0','CINCIN PALADIUM YL-01 ','','1.700','1','17.00','382000','0','0','17800','1295000','0','0','0','1295000','DIL','00044749','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-7-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-06-28' AND kode_barang='PSPLT-ZFBF-7-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0031','2026-06-28','1.700','2026-06-28','17:25:05','PLG0012585','1295000','1295000','0','1295000','0','sby','2026-06-28 17:25:05','FJ-260628-0031','DP-02351','1300000');
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-06-28','FJ-260628-0031','2026-06-28','17:25:05','DIL','1295000','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-260628-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-260628-0032','sby',' 1',' DP-02352SB','TOKO','SBYPSN','PSGT-ZFBF-10-0','CINCIN EMAS ','','1.760','1','45.00','1996000','0','0','17800','3370000','0','0','0','3370000','DIL','00044752','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFBF-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0032','2026-06-28','1.760','2026-06-28','17:25:05','PLG0012586','3370000','3370000','0','3370000','0','sby','2026-06-28 17:25:05','FJ-260628-0031','DP-02352','3100000');
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-06-28','FJ-260628-0032','2026-06-28','17:25:05','DIL','3370000','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-260628-0042','2026-06-28','2026-06-28 17:25:05','PENJUALAN : FJ-260628-0032','','TBC','270000','270000','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-260628-0043','D','2026-06-28','17:25:05','TBC','PENJUALAN','FJ-260628-0032','24258488064','270000','24258758064','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='270000' WHERE no_faktur_jual='FJ-260628-0032' 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-260628-0033','kasirbip','1',' DP-02472BI','TOKO','BIPPSN','PSGT-ZFBF-32-0','CINCIN EMAS ','','3.350','1','83.00','7006000','0','0','17800','9250000','0','0','0','9250000','KUR','00044774','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBF-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.350',berat_jual_asli=berat_jual_asli+'3.350',stock_jual='1',berat_akhir=berat_akhir-'3.350',berat_akhir_asli=berat_akhir_asli-'3.350',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFBF-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0033','2026-06-28','3.350','2026-06-28','17:29:43','PLG0012587','9250000','9250000','0','9250000','0','kasirbip','2026-06-28 17:29:43','FJ-260628-0033','DP-02472','7112000');
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-06-28','FJ-260628-0033','2026-06-28','17:29:43','KUR','9250000','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-260628-0043','2026-06-28','2026-06-28 17:29:43','PENJUALAN : FJ-260628-0033','.','TBC','2138000','2138000','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-260628-0044','D','2026-06-28','17:29:43','TBC','PENJUALAN','FJ-260628-0033','24258758064','2138000','24260896064','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='2138000' WHERE no_faktur_jual='FJ-260628-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-260628-0034','kasirbip',' 1',' DP-02471BI','TOKO','BIPPSN','PSPRT-ZFBD-15-0','CINCIN PERAK YL-10 ','','4.290','1','100.00','438000','0','0','17800','900000','0','0','0','900000','KUR','00044670','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBD-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.290',berat_jual_asli=berat_jual_asli+'4.290',stock_jual='1',berat_akhir=berat_akhir-'4.290',berat_akhir_asli=berat_akhir_asli-'4.290',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPRT-ZFBD-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-260628-0034','2026-06-28','4.290','2026-06-28','17:29:43','PLG0012588','900000','900000','0','900000','0','kasirbip','2026-06-28 17:29:43','FJ-260628-0033','DP-02471','900000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-06-28','FJ-260628-0034','2026-06-28','17:29:43','KUR','900000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2138000' WHERE no_faktur_jual='FJ-260628-0034' 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-260628-0035','sby','1',' DP-02479SB','TOKO','SBYPSN','PSPRT-ZFBE-4-0','CINCIN PERAK ','','3.810','1','100.00','389000','0','0','17800','1600000','0','0','0','1600000','DIL','00044718','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBE-4-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-06-28' AND kode_barang='PSPRT-ZFBE-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0035','2026-06-28','3.810','2026-06-28','17:36:59','PLG0012589','1600000','1600000','0','1600000','0','sby','2026-06-28 17:36:59','FJ-260628-0035','DP-02479','1600000');
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-06-28','FJ-260628-0035','2026-06-28','17:36:59','DIL','1600000','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-260628-0035' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000357','X-00000357','GL KERONCONG','GR','---','GLK','BELI','BELI001','11377000','2026-06-28','7.340','1','kasir','2026-06-28 17:40:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-GLK';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-GLK','X-00000357','X-00000357');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260628-0001','-','FIR','1','BELI','BELI001','GLK', 'X-00000357', 'GL KERONCONG','7.340','7.340','75.00','14650000','11377000','1550000','1','11377000','11377000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'7.340',berat_beli_asli=berat_beli_asli+'7.340',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'7.340',berat_akhir_asli=berat_akhir_asli+'7.340',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='GLK' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-260628-0001','2026-06-28','2026-06-28','17:40:42','FIR','---','7.340','11377000','11377000','11377000','11377000','11377000','kasir','2026-06-28 17:40:43','FB-260628-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260628-0001','MIA','JKT','','JKY','','kasir','2026-06-28 17:40:43');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0044','2026-06-28','2026-06-28 17:40:43','PEMBELIAN UMUM : FB-260628-0001','.','TBC','11377000','11377000');
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 ('KK-260628-0045','K','2026-06-28','17:40:42','TBC','PEMBELIAN UMUM','FB-260628-0001','24260896064','11377000','24249519064','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260628-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260628-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-260628-0036','kasirbip','1',' 900K-115-0','TOKO','DUPERBDG','LXPER-ZEBI-38-0','CINCIN SILVER 925 ','','1.250','1','100.00','128000','0','0','17800','1000000','0','0','0','1000000','PUT','00043864','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEBI-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='LXPER-ZEBI-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0036','2026-06-28','1.250','2026-06-28','17:44:42','PLG0012590','1000000','1000000','0','1000000','0','kasirbip','2026-06-28 17:44:41','FJ-260628-0036','','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-06-28','FJ-260628-0036','2026-06-28','17:44:42','PUT','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-260628-0045','2026-06-28','2026-06-28 17:44:41','PENJUALAN : FJ-260628-0036','.','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-260628-0046','D','2026-06-28','17:44:42','TBC','PENJUALAN','FJ-260628-0036','24249519064','1000000','24250519064','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-260628-0036' 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-260628-0037','kasirbip',' 1',' 750K-185-0','TOKO','DUPERBDG','LXPER-ZFAF-49-0','CINCIN SILVER 925 ','','2.990','1','100.00','305000','0','0','17800','850000','0','0','0','850000','PUT','00044479','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAF-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.990',berat_jual_asli=berat_jual_asli+'2.990',stock_jual='1',berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='LXPER-ZFAF-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0037','2026-06-28','2.990','2026-06-28','17:44:42','PLG0012591','850000','850000','0','850000','0','kasirbip','2026-06-28 17:44:41','FJ-260628-0036','','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-06-28','FJ-260628-0037','2026-06-28','17:44:42','PUT','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-260628-0046','2026-06-28','2026-06-28 17:44:41','PENJUALAN : FJ-260628-0037','.','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-260628-0047','D','2026-06-28','17:44:42','TBC','PENJUALAN','FJ-260628-0037','24250519064','850000','24251369064','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-260628-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-260628-0038','kasir','1',' LMT1-125% ','TOKO','TFLM','LMT1-ZDCX-33-0','LM ANTAM 1 GR K75952935 ','','1.000','1','125.00','2913000','0','0','17800','2850000','0','0','0','2850000','FIR','00042990','LMT1','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMT1-ZDCX-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='LMT1-ZDCX-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFLM' 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-260628-0038','2026-06-28','1.000','2026-06-28','17:45:03','PLG0012592','2850000','2850000','0','2850000','0','kasir','2026-06-28 17:45:03','FJ-260628-0038','','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-06-28','FJ-260628-0038','2026-06-28','17:45:03','FIR','2850000','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-260628-0047','2026-06-28','2026-06-28 17:45:03','PENJUALAN : FJ-260628-0038','.','TBC','2850000','2850000','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-260628-0048','D','2026-06-28','17:45:03','TBC','PENJUALAN','FJ-260628-0038','24251369064','2850000','24254219064','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='2850000' WHERE no_faktur_jual='FJ-260628-0038' 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-260628-0039','kasir',' 1',' LMT1-125% ','TOKO','TFLM','LMT1-ZDCX-32-0','LM ANTAM 1 GR K75801539 ','','1.000','1','125.00','2913000','0','0','17800','2850000','0','0','0','2850000','FIR','00042989','LMT1','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMT1-ZDCX-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='LMT1-ZDCX-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFLM' 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-260628-0039','2026-06-28','1.000','2026-06-28','17:45:03','PLG0012593','2850000','2850000','0','2850000','0','kasir','2026-06-28 17:45:03','FJ-260628-0038','','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-06-28','FJ-260628-0039','2026-06-28','17:45:03','FIR','2850000','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-260628-0048','2026-06-28','2026-06-28 17:45:03','PENJUALAN : FJ-260628-0039','.','TBC','2850000','2850000','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-260628-0049','D','2026-06-28','17:45:03','TBC','PENJUALAN','FJ-260628-0039','24254219064','2850000','24257069064','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='5700000' WHERE no_faktur_jual='FJ-260628-0039' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0027';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0028';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0029';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0030';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0033' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0033' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0033';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0034' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0034' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0034';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0035' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0035' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0035';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0036' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0036' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0036';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0037' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0037' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0037';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0038' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0038' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0038';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0039' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0039' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0039';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0036' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0036' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0036';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0037' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0037' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0037';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-28 ','17:48:28');
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-02695','VAN','1','GOLD','WEDDRING WANITA','','','2.500','','37.50','1','2330000','1500000','0','750000','4500000','PERMATA 1','SIZE: 10.5 GRF: I & Z FONT: YESEVA ONE','GOLD KUNING','10000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0049','2026-06-28','2026-06-28 17:52:01','PESANAN : DP-02695','-','TBC','2500000','2500000');
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-260628-0050','D','2026-06-28','17:52:01','TBC','PESANAN','DP-02695','24257069064','2500000','24259569064','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-02695','2026-06-28','2026-06-28','17:52:01','PLG0012594','VAN','2026-07-08','sby','2026-06-28 17:52:01','2.500','0','0','0','2500000','0','750000','4510000','4510000','2010000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-28 ','17:52:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-06-28 ','18:01:04');
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-260628-0040','sby','1',' DP-02304SB','TOKO','SBYPSN','PSPLT-ZFBF-49-0','CINCIN PALADIUM ','','4.050','1','32.00','1712000','0','0','17800','2987500','0','0','0','2987500','VAN','00044791','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.050',berat_jual_asli=berat_jual_asli+'4.050',stock_jual='1',berat_akhir=berat_akhir-'4.050',berat_akhir_asli=berat_akhir_asli-'4.050',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBF-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0040','2026-06-28','4.050','2026-06-28','18:05:20','PLG0012595','2987500','2987500','0','2987500','0','sby','2026-06-28 18:05:19','FJ-260628-0040','DP-02304','2000000');
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-06-28','FJ-260628-0040','2026-06-28','18:05:20','VAN','2987500','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-260628-0050','2026-06-28','2026-06-28 18:05:19','PENJUALAN : FJ-260628-0040','','TBC','987500','987500','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-260628-0051','D','2026-06-28','18:05:20','TBC','PENJUALAN','FJ-260628-0040','24259569064','987500','24260556564','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='987500' WHERE no_faktur_jual='FJ-260628-0040' 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-260628-0041','sby','1',' DP-02337SB','TOKO','SBYPSN','PSPLT-ZFBF-9-0','CINCIN PALADIUM ','','3.980','1','32.00','1682000','0','0','17800','2949000','0','0','0','2949000','DIL','00044751','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.980',berat_jual_asli=berat_jual_asli+'3.980',stock_jual='1',berat_akhir=berat_akhir-'3.980',berat_akhir_asli=berat_akhir_asli-'3.980',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSPLT-ZFBF-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0041','2026-06-28','3.980','2026-06-28','18:16:05','PLG0012596','2949000','2949000','0','2949000','0','sby','2026-06-28 18:16:05','FJ-260628-0041','DP-02337','2000000');
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-06-28','FJ-260628-0041','2026-06-28','18:16:05','DIL','2949000','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-260628-0051','2026-06-28','2026-06-28 18:16:05','PENJUALAN : FJ-260628-0041','','TBC','949000','949000','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-260628-0052','D','2026-06-28','18:16:05','TBC','PENJUALAN','FJ-260628-0041','24260556564','949000','24261505564','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='949000' WHERE no_faktur_jual='FJ-260628-0041' 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-02696','PUT','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','850000','0','850000','batu moisonaite 1ct','sz 15 crom putih gllosy','grf Menyusul','1250000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0052','2026-06-28','2026-06-28 18:23:27','PESANAN : DP-02696','.','TBC','2100000','2100000');
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-260628-0053','D','2026-06-28','18:23:27','TBC','PESANAN','DP-02696','24261505564','2100000','24263605564','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-02696','2026-06-28','2026-06-28','18:23:27','PLG0012597','PUT','2026-07-18','kasirbip','2026-06-28 18:23:27','2.000','0','0','0','2100000','0','0','2100000','2100000','0');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-02697','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 20.5','crom putih gllosy tidak pakai mata polos lbar cncn samakan','grf menyusul','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0053','2026-06-28','2026-06-28 18:26:30','PESANAN : DP-02697','.','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-260628-0054','D','2026-06-28','18:26:30','TBC','PESANAN','DP-02697','24263605564','900000','24264505564','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-02697','2026-06-28','2026-06-28','18:26:30','PLG0012598','PUT','2026-07-25','kasirbip','2026-06-28 18:26:30','3.000','0','0','0','900000','0','0','900000','900000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0040' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0040' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0040';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-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-260628-0042','kasirbip','1',' 800K-19-27','TOKO','BIPPER','PBDG-ZFAH-43-0','CINCIN SILVER 925 ','','4.770','1','100.00','488000','0','0','17800','900000','0','0','0','900000','SAL','00044556','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFAH-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.770',berat_jual_asli=berat_jual_asli+'4.770',stock_jual='1',berat_akhir=berat_akhir-'4.770',berat_akhir_asli=berat_akhir_asli-'4.770',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PBDG-ZFAH-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0042','2026-06-28','4.770','2026-06-28','18:53:30','PLG0012599','900000','900000','0','900000','0','kasirbip','2026-06-28 18:53:29','FJ-260628-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-06-28','FJ-260628-0042','2026-06-28','18:53:30','SAL','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-260628-0054','2026-06-28','2026-06-28 18:53:29','PENJUALAN : FJ-260628-0042','.','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-260628-0055','D','2026-06-28','18:53:30','TBC','PENJUALAN','FJ-260628-0042','24264505564','900000','24265405564','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-260628-0042' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0042';
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-02698','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','3 zircon putih doff semprot sz 15','font vintage rotter','grf Diki . . . Nurlita','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0055','2026-06-28','2026-06-28 18:57:44','PESANAN : DP-02698','.','TBC','1440000','1440000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0056','D','2026-06-28','18:57:44','TBC','PESANAN','DP-02698','24265405564','1440000','24266845564','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-02698','2026-06-28','2026-06-28','18:57:44','PLG0012600','SULIS','2026-07-26','kasirbip','2026-06-28 18:57:44','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000');
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-260628-0043','kasirbip','1',' 500K-18-00','TOKO','DUPERBDG','LXPER-ZFAH-17-0','CINCIN SILVER 925 YL-01 ','','1.910','1','100.00','195000','0','0','17800','600000','0','0','0','600000','PUT','00044530','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAH-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='LXPER-ZFAH-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0043','2026-06-28','1.910','2026-06-28','19:00:21','PLG0012601','600000','600000','0','600000','0','kasirbip','2026-06-28 19:00:21','FJ-260628-0043','','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-06-28','FJ-260628-0043','2026-06-28','19:00:21','PUT','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-260628-0056','2026-06-28','2026-06-28 19:00:21','PENJUALAN : FJ-260628-0043','.','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-260628-0057','D','2026-06-28','19:00:21','TBC','PENJUALAN','FJ-260628-0043','24266845564','600000','24267445564','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-260628-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-260628-0044','kasirbip',' 1',' 750K-135-0','TOKO','DUPERBDG','LXPER-ZFAB-68-0','CINCIN SILVER 925 ','','1.880','1','100.00','192000','0','0','17800','850000','0','0','0','850000','PUT','00044392','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAB-68-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-06-28' AND kode_barang='LXPER-ZFAB-68-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0044','2026-06-28','1.880','2026-06-28','19:00:21','PLG0012602','850000','850000','0','850000','0','kasirbip','2026-06-28 19:00:21','FJ-260628-0043','','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-06-28','FJ-260628-0044','2026-06-28','19:00:21','PUT','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-260628-0057','2026-06-28','2026-06-28 19:00:21','PENJUALAN : FJ-260628-0044','.','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-260628-0058','D','2026-06-28','19:00:21','TBC','PENJUALAN','FJ-260628-0044','24267445564','850000','24268295564','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-260628-0044' 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-02699','SULIS','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','1 zircon putih doff semprot sz 21.5','berat akhit jgn lbh dari estimasi font vintage rotter','grf Diki . . . Nurlita','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0058','2026-06-28','2026-06-28 19:00:42','PESANAN : DP-02699','.','TBC','1720000','1720000');
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-260628-0059','D','2026-06-28','19:00:42','TBC','PESANAN','DP-02699','24268295564','1720000','24270015564','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-02699','2026-06-28','2026-06-28','19:00:42','PLG0012603','SULIS','2026-07-26','kasirbip','2026-06-28 19:00:42','4.000','0','0','0','1720000','0','750000','2150000','2150000','430000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0043' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0043' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0043';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0044' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0044' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-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-260628-0045','sby','1',' DP-02409SB','TOKO','SBYPSN','PSPLT-ZFBF-41-0','CINCIN PALADIUM ','','2.970','1','32.00','1256000','0','0','17800','2393500','0','0','0','2393500','VAN','00044783','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-41-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-06-28' AND kode_barang='PSPLT-ZFBF-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0045','2026-06-28','2.970','2026-06-28','19:13:11','PLG0012604','2393500','2393500','0','2393500','0','sby','2026-06-28 19:13:10','FJ-260628-0045','DP-02409','1800000');
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-06-28','FJ-260628-0045','2026-06-28','19:13:11','VAN','2393500','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-260628-0059','2026-06-28','2026-06-28 19:13:10','PENJUALAN : FJ-260628-0045','','TBC','593500','593500','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-260628-0060','D','2026-06-28','19:13:11','TBC','PENJUALAN','FJ-260628-0045','24270015564','593500','24270609064','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='593500' WHERE no_faktur_jual='FJ-260628-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-260628-0046','sby',' 1',' DP-02410SB','TOKO','SBYPSN','PSGT-ZFBD-29-0','CINCIN EMAS ','','2.000','1','83.00','4183000','0','0','17800','5560000','0','0','0','5560000','VAN','00044684','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZFBD-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PSGT-ZFBD-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260628-0046','2026-06-28','2.000','2026-06-28','19:13:11','PLG0012605','5560000','5560000','0','5560000','0','sby','2026-06-28 19:13:10','FJ-260628-0045','DP-02410','4200000');
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-06-28','FJ-260628-0046','2026-06-28','19:13:11','VAN','5560000','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-260628-0060','2026-06-28','2026-06-28 19:13:10','PENJUALAN : FJ-260628-0046','','TBC','1360000','1360000','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-260628-0061','D','2026-06-28','19:13:11','TBC','PENJUALAN','FJ-260628-0046','24270609064','1360000','24271969064','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='1953500' WHERE no_faktur_jual='FJ-260628-0046' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0045' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0045' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0045';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0046' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0046' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0046';
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-260628-0047','kasir','1',' 750K-19-10','TOKO','MMPER','PMM-ZFBD-32-0','CINCIN SILVER 925 ','','2.270','1','100.00','232000','0','0','17800','850000','0','0','0','850000','ELLA','00044687','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFBD-32-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-06-28' AND kode_barang='PMM-ZFBD-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-260628-0047','2026-06-28','2.270','2026-06-28','19:26:54','PLG0012606','850000','850000','0','850000','0','kasir','2026-06-28 19:26:54','FJ-260628-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-06-28','FJ-260628-0047','2026-06-28','19:26:54','ELLA','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260628-0061','2026-06-28','2026-06-28 19:26:54','PENJUALAN : FJ-260628-0047','.','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-260628-0062','D','2026-06-28','19:26:54','TBC','PENJUALAN','FJ-260628-0047','24271969064','850000','24272819064','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-260628-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-260628-0048','kasir',' 1',' 750K-135-1','TOKO','MMPER','PMM-ZFBD-31-0','CINCIN SILVER 925 ','','2.320','1','100.00','238000','0','0','17800','850000','0','0','0','850000','ELLA','00044686','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFBD-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PMM-ZFBD-31-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-260628-0048','2026-06-28','2.320','2026-06-28','19:26:54','PLG0012607','850000','850000','0','850000','0','kasir','2026-06-28 19:26:54','FJ-260628-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-06-28','FJ-260628-0048','2026-06-28','19:26:54','ELLA','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260628-0062','2026-06-28','2026-06-28 19:26:54','PENJUALAN : FJ-260628-0048','.','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-260628-0063','D','2026-06-28','19:26:54','TBC','PENJUALAN','FJ-260628-0048','24272819064','850000','24273669064','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-260628-0048' 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-260628-0049','kasirbip','1',' 750K-19-26','TOKO','BIPPER','PBDG-ZFAB-37-0','CINCIN SILVER 925 ','','1.940','1','100.00','198000','0','0','17800','850000','0','0','0','850000','SULIS','00044361','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFAB-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-06-28' AND kode_barang='PBDG-ZFAB-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-260628-0049','2026-06-28','1.940','2026-06-28','19:27:49','PLG0012608','850000','850000','0','850000','0','kasirbip','2026-06-28 19:27:48','FJ-260628-0049','','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-06-28','FJ-260628-0049','2026-06-28','19:27:49','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-260628-0063','2026-06-28','2026-06-28 19:27:48','PENJUALAN : FJ-260628-0049','.','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-260628-0064','D','2026-06-28','19:27:49','TBC','PENJUALAN','FJ-260628-0049','24273669064','850000','24274519064','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-260628-0049' 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-02700','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1100000','0','1100000','sz 15 putih glosy model spt contoh','font yeseva one','grf Wal & Mey','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0064','2026-06-28','2026-06-28 19:30:04','PESANAN : DP-02700','.','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-260628-0065','D','2026-06-28','19:30:04','TBC','PESANAN','DP-02700','24274519064','1100000','24275619064','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-02700','2026-06-28','2026-06-28','19:30:04','PLG0012609','SAL','2026-07-25','kasirbip','2026-06-28 19:30:04','2.000','0','0','0','1100000','0','0','1100000','1100000','0');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02145','SULIS','1','CC SILVER','PUTIH DOFF SEMPROT FONT YESEVA ONE','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-02145','2026-06-28','2026-06-28','19:32:11','PLG0012610','kasirbip','2026-07-16','kasirbip','2026-06-28 19:32:11','2.000','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-06-28 ','19:33:40');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0047' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0047' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0047';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0048' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0048' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0048';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0049' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0049' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0049';
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-260628-0050','kasir','1',' DP-02524MM','TOKO','MMPSN','PSPLT-ZFBF-23-0','CINCIN PALADIUM ','','2.630','1','17.00','591000','0','0','17800','1770000','0','0','0','1770000','ALIKA','00044765','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-06-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZFBF-23-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-06-28' AND kode_barang='PSPLT-ZFBF-23-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-260628-0050','2026-06-28','2.630','2026-06-28','20:31:34','PLG0012611','1770000','1770000','0','1770000','-30000','kasir','2026-06-28 20:31:34','FJ-260628-0050','DP-02524','1800000');
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-06-28','FJ-260628-0050','2026-06-28','20:31:34','ALIKA','1770000','0');
UPDATE tt_jual_head SET dibayar_rp='-30000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260628-0050' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0050' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260628-0050' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260628-0050';
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='';
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-02701','PUT','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','1000000','1875000','express 100.000 crom kuning gllosy lbar 5mm','sidik jari lengkung ke dalam finger nyusul','grf Fajri font Vintage','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0065','2026-06-28','2026-06-28 20:34:41','PESANAN : DP-02701','.','TBC','1500000','1500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260628-0066','D','2026-06-28','20:34:41','TBC','PESANAN','DP-02701','24275619064','1500000','24277119064','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-02701','2026-06-28','2026-06-28','20:34:41','PLG0012612','PUT','2026-07-10','kasirbip','2026-06-28 20:34:41','2.500','0','0','0','1500000','0','1000000','1875000','1875000','375000');
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-02702','PUT','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','1000000','2050000','express 100.000 crom putih gllosy lebar 5mm','sz 19 finger lengkung ke dalm smkn sprti cntoh finger nysul','grf Poppy font Vintage','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260628-0066','2026-06-28','2026-06-28 20:40:23','PESANAN : DP-02702','.','TBC','1640000','1640000');
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-260628-0067','D','2026-06-28','20:40:23','TBC','PESANAN','DP-02702','24277119064','1640000','24278759064','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-02702','2026-06-28','2026-06-28','20:40:23','PLG0012613','PUT','2026-07-10','kasirbip','2026-06-28 20:40:23','3.000','0','0','0','1640000','0','1000000','2050000','2050000','410000');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-28';
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-06-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-28' 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-260629-0001','D','2026-06-29','21:30:49','TBC','SALDO AWAL','SALDO AWAL','0','24278759064','24278759064');
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-260629-0001','D','2026-06-29','21:30:49','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000');
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-260629-0001','D','2026-06-29','21:30:49','','SALDO AWAL','SALDO AWAL','0','250000','250000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260629-0001','D','2026-06-29','21:30:49','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-260629-0001','D','2026-06-29','21:30:49','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-260629-0001','D','2026-06-29','21:30:49','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-260629-0001','D','2026-06-29','21:30:49','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-260629-0001','D','2026-06-29','21:30:49','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-260629-0001','D','2026-06-29','21:30:49','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-260629-0001','D','2026-06-29','21:30:49','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260629-0001','D','2026-06-29','21:30:49','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260629-0001','D','2026-06-29','21:30:49','BCD','SALDO AWAL','SALDO AWAL','0','1396753500','1396753500');
UPDATE tp_system SET tgl_system='2026-06-29';