INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-23 ','10:53:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-23 ','10:56:20');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-23 ','11:02:13');
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-260823-0001','kasirbip','1',' DP-03097DU','TOKO','DUPSN','PSPLT-ZHBA-12-0','CINCIN PALADIUM ','','2.580','1','32.00','1091000','0','0','17800','2359000','0','0','0','2359000','PUT','00046298','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBA-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.580',berat_jual_asli=berat_jual_asli+'2.580',stock_jual='1',berat_akhir=berat_akhir-'2.580',berat_akhir_asli=berat_akhir_asli-'2.580',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPLT-ZHBA-12-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-260823-0001','2026-08-23','2.580','2026-08-23','11:49:25','PLG0014772','2359000','2359000','0','2359000','0','kasirbip','2026-08-23 11:49:25','FJ-260823-0001','DP-03097','1852000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0001','2026-08-23','11:49:25','PUT','2359000','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-260823-0001','2026-08-23','2026-08-23 11:49:25','PENJUALAN : FJ-260823-0001','.','TBC','507000','507000','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-260823-0002','D','2026-08-23','11:49:25','TBC','PENJUALAN','FJ-260823-0001','26607638064','507000','26608145064','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='507000' WHERE no_faktur_jual='FJ-260823-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-260823-0002','kasirbip',' 1',' DP-03096DU','TOKO','DUPSN','PSPRT-ZHAA-12-0','CINCIN PERAK YL01 ','','2.030','1','100.00','208000','0','0','17800','700000','0','0','0','700000','PUT','00046035','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHAA-12-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-08-23' AND kode_barang='PSPRT-ZHAA-12-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-260823-0002','2026-08-23','2.030','2026-08-23','11:49:25','PLG0014773','700000','700000','0','700000','0','kasirbip','2026-08-23 11:49:25','FJ-260823-0001','DP-03096','700000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0002','2026-08-23','11:49:25','PUT','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='507000' WHERE no_faktur_jual='FJ-260823-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-23 ','12:03:39');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03558','DIL','1','PER','WEDD RING PRIA YL10','','','4.000','','925.00','1','100000','0','800000','0','800000','SIZE 26 GRF: Tiyas ?? (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-260823-0002','2026-08-23','2026-08-23 12:29:39','PESANAN : DP-03558','-','TBC','800000','800000');
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-260823-0003','D','2026-08-23','12:29:39','TBC','PESANAN','DP-03558','26608145064','800000','26608945064','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-03558','2026-08-23','2026-08-23','12:29:39','PLG0014774','DIL','2026-09-16','sby','2026-08-23 12:29:39','4.000','0','0','0','800000','0','0','800000','800000','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-260823-0003','kasirbip','1',' DP-03182BI','TOKO','BIPPSN','PSGT-ZHBA-7-0','CINCIN EMAS ','','1.640','1','83.00','3361000','0','0','17800','4440000','0','0','0','4440000','SULIS','00046293','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZHBA-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSGT-ZHBA-7-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-260823-0003','2026-08-23','1.640','2026-08-23','12:30:42','PLG0014775','4440000','4440000','0','4440000','0','kasirbip','2026-08-23 12:30:42','FJ-260823-0003','DP-03182','3300000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0003','2026-08-23','12:30:42','SULIS','4440000','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-260823-0003','2026-08-23','2026-08-23 12:30:42','PENJUALAN : FJ-260823-0003','.','TBC','1140000','1140000','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-260823-0004','D','2026-08-23','12:30:42','TBC','PENJUALAN','FJ-260823-0003','26608945064','1140000','26610085064','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='1140000' WHERE no_faktur_jual='FJ-260823-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260823-0004','kasirbip',' 1',' DP-03183BI','TOKO','BIPPSN','PSPLT-ZHBA-1-0','CINCIN PALADIUM YL01 ','','2.120','1','17.00','477000','0','0','17800','1242000','0','0','0','1242000','SULIS','00046287','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBA-1-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-08-23' AND kode_barang='PSPLT-ZHBA-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0004','2026-08-23','2.120','2026-08-23','12:30:42','PLG0014776','1242000','1242000','0','1242000','0','kasirbip','2026-08-23 12:30:42','FJ-260823-0003','DP-03183','960000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0004','2026-08-23','12:30:42','SULIS','1242000','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-260823-0004','2026-08-23','2026-08-23 12:30:42','PENJUALAN : FJ-260823-0004','.','TBC','282000','282000','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-260823-0005','D','2026-08-23','12:30:42','TBC','PENJUALAN','FJ-260823-0004','26610085064','282000','26610367064','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='1422000' WHERE no_faktur_jual='FJ-260823-0004' 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-03559','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','850000','0','850000','PERMATA 1 BUTIR','SIZE 11 GRF: Firman ?? (VINTAGE)','CROM PUTIH GLOSSY','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-260823-0005','2026-08-23','2026-08-23 12:32:09','PESANAN : DP-03559','-','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-260823-0006','D','2026-08-23','12:32:09','TBC','PESANAN','DP-03559','26610367064','850000','26611217064','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-03559','2026-08-23','2026-08-23','12:32:09','PLG0014777','DIL','2026-09-16','sby','2026-08-23 12:32:09','2.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-03560','SAL','1','PLD','WED RING','','','4.500','','25.00','1','1200000','550000','0','700000','3175000','sz 19 rosegold glossy rosegold doff semprot','1 zirkon font berskhire swash','grf Fasya . . . model dibuat persis sprt contoh','','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0006','2026-08-23','2026-08-23 12:33:28','PESANAN : DP-03560','.','TBC','2540000','2540000');
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-260823-0007','D','2026-08-23','12:33:28','TBC','PESANAN','DP-03560','26611217064','2540000','26613757064','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-03560','2026-08-23','2026-08-23','12:33:28','PLG0014778','SAL','2026-09-21','kasirbip','2026-08-23 12:33:28','4.500','0','0','0','2540000','0','700000','3175000','3175000','635000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-23 ','12:38:35');
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-260823-0005','sby','1',' DP-03165SB','TOKO','SBYPSN','PSPLT-ZHBA-16-0','CINCIN PALADIUM ','','1.480','1','17.00','333000','0','0','17800','2178000','0','0','0','2178000','DIL','00046302','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBA-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPLT-ZHBA-16-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-260823-0005','2026-08-23','1.480','2026-08-23','12:41:05','PLG0014779','2178000','2178000','0','2178000','0','sby','2026-08-23 12:41:05','FJ-260823-0005','DP-03165','1500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0005','2026-08-23','12:41:05','DIL','2178000','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-260823-0007','2026-08-23','2026-08-23 12:41:05','PENJUALAN : FJ-260823-0005','','TBC','678000','678000','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-260823-0008','D','2026-08-23','12:41:05','TBC','PENJUALAN','FJ-260823-0005','26613757064','678000','26614435064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='678000' WHERE no_faktur_jual='FJ-260823-0005' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260823-0006','sby','1',' DP-03217SB','TOKO','SBYPSN','PSPRT-ZHBA-30-0','CINCIN PERAK ','','4.030','1','100.00','412000','0','0','17800','800000','0','0','0','800000','DIL','00046316','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBA-30-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-08-23' AND kode_barang='PSPRT-ZHBA-30-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-260823-0006','2026-08-23','4.030','2026-08-23','12:55:07','PLG0014780','800000','800000','0','800000','0','sby','2026-08-23 12:55:06','FJ-260823-0006','DP-03217','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-08-23','FJ-260823-0006','2026-08-23','12:55:07','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-260823-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-260823-0007','sby',' 1',' DP-03218SB','TOKO','SBYPSN','PSPLT-ZHBA-17-0','CINCIN PALADIUM ','','1.980','1','17.00','445000','0','0','17800','1543000','0','0','0','1543000','DIL','00046303','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBA-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPLT-ZHBA-17-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-260823-0007','2026-08-23','1.980','2026-08-23','12:55:07','PLG0014781','1543000','1543000','0','1543000','0','sby','2026-08-23 12:55:06','FJ-260823-0006','DP-03218','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-08-23','FJ-260823-0007','2026-08-23','12:55:07','DIL','1543000','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-260823-0008','2026-08-23','2026-08-23 12:55:06','PENJUALAN : FJ-260823-0007','','TBC','743000','743000','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-260823-0009','D','2026-08-23','12:55:07','TBC','PENJUALAN','FJ-260823-0007','26614435064','743000','26615178064','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='743000' WHERE no_faktur_jual='FJ-260823-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0007';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-23 ','13:16:22');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02218','KUR','1','PLDC 10','CROM PUTIH DOFF AMPLASS','4.000','1','50000','50000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260823-0009','2026-08-23','2026-08-23 13:37:12','SERVICE : SV-02218','.','TBC','50000','50000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260823-0010','D','2026-08-23','13:37:12','TBC','SERVICE','SV-02218','26615178064','50000','26615228064','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-02218','2026-08-23','2026-08-23','13:37:12','PLG0014782','kasirbip','2026-09-09','kasirbip','2026-08-23 13:37:12','4.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-23 ','13:37:33');
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-03561','SULIS','1','GOLD','WED RING','','','2.500','','75.00','1','2420000','2250000','0','1000000','6625000','52 zircon putih glosy sz 12.5','font times new roman grf Rayhan','','520000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0010','2026-08-23','2026-08-23 14:16:03','PESANAN : DP-03561','.','TBC','5716000','5716000');
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-260823-0011','D','2026-08-23','14:16:03','TBC','PESANAN','DP-03561','26615228064','5716000','26620944064','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-03561','2026-08-23','2026-08-23','14:16:03','PLG0014783','SULIS','2026-09-17','kasirbip','2026-08-23 14:16:03','2.500','0','0','0','5716000','0','1000000','7145000','7145000','1429000');
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-03562','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','sz 25 putih doff semprot 1 zircon','font times new roman grf Meiza','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0011','2026-08-23','2026-08-23 14:17:31','PESANAN : DP-03562','.','TBC','1400000','1400000');
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-260823-0012','D','2026-08-23','14:17:31','TBC','PESANAN','DP-03562','26620944064','1400000','26622344064','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-03562','2026-08-23','2026-08-23','14:17:31','PLG0014784','SULIS','2026-09-17','kasirbip','2026-08-23 14:17:31','3.000','0','0','0','1400000','0','700000','1750000','1750000','350000');
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-260823-0008','kasirbip','1',' DP-03186BI','TOKO','BIPPSN','PSPRT-ZHBA-6-0','CINCIN PERAK ','','2.240','1','100.00','229000','0','0','17800','850000','0','0','0','850000','SULIS','00046292','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBA-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPRT-ZHBA-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0008','2026-08-23','2.240','2026-08-23','14:22:04','PLG0014785','850000','850000','0','850000','0','kasirbip','2026-08-23 14:22:03','FJ-260823-0008','DP-03186','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-08-23','FJ-260823-0008','2026-08-23','14:22:04','SULIS','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260823-0008' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260823-0009','kasirbip',' 1',' DP-03185BI','TOKO','BIPPSN','PSPRT-ZHAB-57-0','CINCIN PERAK ','','3.460','1','100.00','353000','0','0','17800','850000','0','0','0','850000','SULIS','00046106','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHAB-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.460',berat_jual_asli=berat_jual_asli+'3.460',stock_jual='1',berat_akhir=berat_akhir-'3.460',berat_akhir_asli=berat_akhir_asli-'3.460',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPRT-ZHAB-57-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-260823-0009','2026-08-23','3.460','2026-08-23','14:22:04','PLG0014786','850000','850000','0','850000','0','kasirbip','2026-08-23 14:22:03','FJ-260823-0008','DP-03185','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-08-23','FJ-260823-0009','2026-08-23','14:22:04','SULIS','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260823-0009' 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-03563','NAD','1','GOLD','WEDRING','','','2.000','','75.00','1','2420000','2250000','0','750000','5250000','size 7.5 crom putih glossy','17 zircon Font Berkshire','Grf Cici ..... Firman 06 . 12 . 26','0','170000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0012','2026-08-23','2026-08-23 14:24:49','PESANAN : DP-03563','.','TBC','4336000','4336000');
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-260823-0013','D','2026-08-23','14:24:49','TBC','PESANAN','DP-03563','26622344064','4336000','26626680064','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-03563','2026-08-23','2026-08-23','14:24:49','PLG0014787','NAD','2026-09-21','kasirbip','2026-08-23 14:24:49','2.000','0','0','0','4336000','0','750000','5420000','5420000','1084000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-23 ','14:27:02');
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-03564','NAD','1','PLD','WEDRING','','','3.500','','10.00','1','1200000','350000','0','700000','1925000','size 16 crom putih doff amplas','Grf Cici .... Firman 06 . 12 . 26','Font Berkshire','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0013','2026-08-23','2026-08-23 14:28:21','PESANAN : DP-03564','.','TBC','1540000','1540000');
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-260823-0014','D','2026-08-23','14:28:21','TBC','PESANAN','DP-03564','26626680064','1540000','26628220064','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-03564','2026-08-23','2026-08-23','14:28:21','PLG0014788','NAD','2026-09-21','kasirbip','2026-08-23 14:28:21','3.500','0','0','0','1540000','0','700000','1925000','1925000','385000');
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-260823-0010','kasir','1',' PLDMM-0004','TOKO','MMPLD','PLDMM-ZDBI-30-0','CINCIN PALADIUM PLDMM-00043 ','','1.740','1','17.00','391000','0','0','17800','1899000','0','0','0','1899000','ALIKA','00042928','PLDMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZDBI-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PLDMM-ZDBI-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0010','2026-08-23','1.740','2026-08-23','14:28:53','PLG0014789','1899000','1899000','0','1899000','0','kasir','2026-08-23 14:28:53','FJ-260823-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0010','2026-08-23','14:28:53','ALIKA','1899000','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-260823-0014','2026-08-23','2026-08-23 14:28:53','PENJUALAN : FJ-260823-0010','.','TBC','1899000','1899000','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-260823-0015','D','2026-08-23','14:28:53','TBC','PENJUALAN','FJ-260823-0010','26628220064','1899000','26630119064','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='1899000' WHERE no_faktur_jual='FJ-260823-0010' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260823-0011','kasir',' 1',' 700K-16-00','TOKO','MMPER','PMM-YIXH-45-0','CINCIN SILVER 925 ','','3.100','1','100.00','80000','0','0','17800','850000','0','0','0','850000','ALIKA','00038639','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YIXH-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PMM-YIXH-45-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-260823-0011','2026-08-23','3.100','2026-08-23','14:28:53','PLG0014790','850000','850000','0','850000','0','kasir','2026-08-23 14:28:53','FJ-260823-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0011','2026-08-23','14:28:53','ALIKA','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-260823-0015','2026-08-23','2026-08-23 14:28:53','PENJUALAN : FJ-260823-0011','.','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-260823-0016','D','2026-08-23','14:28:53','TBC','PENJUALAN','FJ-260823-0011','26630119064','850000','26630969064','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='2749000' WHERE no_faktur_jual='FJ-260823-0011' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03565','PUT','1','GOLD','WEDRING','','','2.000','','50.00','1','2420000','1800000','0','900000','4500000','zircon 36 crom putih gllosy','sz 12.5 grf Arief 10.10.26','font Vintage','360000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0016','2026-08-23','2026-08-23 14:40:55','PESANAN : DP-03565','.','TBC','3888000','3888000');
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-260823-0017','D','2026-08-23','14:40:55','TBC','PESANAN','DP-03565','26630969064','3888000','26634857064','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-03565','2026-08-23','2026-08-23','14:40:55','PLG0014791','PUT','2026-09-20','kasirbip','2026-08-23 14:40:55','2.000','0','0','0','3888000','0','900000','4860000','4860000','972000');
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-03566','PUT','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','sz 21.5 crom putih gllosy','grf Asysyifa 10.10.26','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-260823-0017','2026-08-23','2026-08-23 14:43:00','PESANAN : DP-03566','.','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-260823-0018','D','2026-08-23','14:43:00','TBC','PESANAN','DP-03566','26634857064','1300000','26636157064','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-03566','2026-08-23','2026-08-23','14:43:00','PLG0014792','PUT','2026-09-20','kasirbip','2026-08-23 14:43:00','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-03567','KUR','1','PER','CINCIN KAWIN','','','2.000','','925.00','1','100000','0','1000000','0','1000000','size 15 grf Riyan','putih kilat sirkon 6','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-260823-0018','2026-08-23','2026-08-23 14:53:54','PESANAN : DP-03567','.','TBC','1000000','1000000');
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-260823-0019','D','2026-08-23','14:53:54','TBC','PESANAN','DP-03567','26636157064','1000000','26637157064','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-03567','2026-08-23','2026-08-23','14:53:54','PLG0014793','KUR','2026-09-13','kasirbip','2026-08-23 14:53:54','2.000','0','0','0','1000000','0','0','1000000','1000000','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-03568','KUR','1','PER','CINCIN KAWIN','','','3.000','','925.00','1','100000','0','900000','0','900000','size 14.5 grf Andiani','putih kilat dof sepinggang sebelah 1 sirkon','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-260823-0019','2026-08-23','2026-08-23 14:59:29','PESANAN : DP-03568','.','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-260823-0020','D','2026-08-23','14:59:29','TBC','PESANAN','DP-03568','26637157064','900000','26638057064','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-03568','2026-08-23','2026-08-23','14:59:29','PLG0014794','KUR','2026-09-13','kasirbip','2026-08-23 14:59:29','3.000','0','0','0','900000','0','0','900000','900000','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-260823-0012','kasir','1',' 750K-16-11','TOKO','MMPER','PMM-ZHAB-2-0','CINCIN SILVER 925 ','','2.140','1','100.00','219000','0','0','17800','850000','0','0','0','850000','ELLA','00046051','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHAB-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PMM-ZHAB-2-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-260823-0012','2026-08-23','2.140','2026-08-23','15:01:42','PLG0014795','850000','850000','0','850000','0','kasir','2026-08-23 15:01:42','FJ-260823-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0012','2026-08-23','15:01:42','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-260823-0020','2026-08-23','2026-08-23 15:01:42','PENJUALAN : FJ-260823-0012','0','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260823-0021','D','2026-08-23','15:01:42','TBC','PENJUALAN','FJ-260823-0012','26638057064','850000','26638907064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260823-0012' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260823-0013','kasir',' 1',' 750K-9-103','TOKO','MMPER','PMM-ZFAG-9-0','CINCIN SILVER 925 ','','1.660','1','100.00','170000','0','0','17800','850000','0','0','0','850000','ELLA','00044495','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFAG-9-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-08-23' AND kode_barang='PMM-ZFAG-9-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-260823-0013','2026-08-23','1.660','2026-08-23','15:01:42','PLG0014796','850000','850000','0','850000','0','kasir','2026-08-23 15:01:42','FJ-260823-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0013','2026-08-23','15:01:42','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-260823-0021','2026-08-23','2026-08-23 15:01:42','PENJUALAN : FJ-260823-0013','0','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260823-0022','D','2026-08-23','15:01:42','TBC','PENJUALAN','FJ-260823-0013','26638907064','850000','26639757064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-260823-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-260823-0014','kasir','1',' DP-03086MM','TOKO','MMPSN','PSPLT-ZHBA-4-0','CINCIN PALADIUM ','','2.450','1','32.00','1036000','0','0','17800','2047000','0','0','0','2047000','ALIKA','00046290','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBA-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPLT-ZHBA-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0014','2026-08-23','2.450','2026-08-23','15:11:58','PLG0014797','2047000','2047000','0','2047000','0','kasir','2026-08-23 15:11:58','FJ-260823-0014','DP-03086','1660000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0014','2026-08-23','15:11:58','ALIKA','2047000','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-260823-0022','2026-08-23','2026-08-23 15:11:58','PENJUALAN : FJ-260823-0014','0','TBC','387000','387000','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-260823-0023','D','2026-08-23','15:11:58','TBC','PENJUALAN','FJ-260823-0014','26639757064','387000','26640144064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='387000' WHERE no_faktur_jual='FJ-260823-0014' LIMIT 1;
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03569','SAL','1','PLD','WED RING','','','2.000','','25.00','1','1200000','550000','0','900000','2000000','sz 10 putih glossy 14 zirkon','font vintage rotter grf Dilfan . . .','model sprt contoh','140000','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0023','2026-08-23','2026-08-23 15:11:56','PESANAN : DP-03569','.','TBC','1712000','1712000');
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-260823-0024','D','2026-08-23','15:11:56','TBC','PESANAN','DP-03569','26640144064','1712000','26641856064','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-03569','2026-08-23','2026-08-23','15:11:56','PLG0014798','SAL','2026-09-20','kasirbip','2026-08-23 15:11:56','2.000','0','0','0','1712000','0','900000','2140000','2140000','428000');
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-260823-0015','kasir',' 1',' DP-03087MM','TOKO','MMPSN','PSPLT-ZHBA-3-0','CINCIN PALADIUM YL10 ','','4.140','1','32.00','1749000','0','0','17800','3127000','0','0','0','3127000','ALIKA','00046289','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHBA-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.140',berat_jual_asli=berat_jual_asli+'4.140',stock_jual='1',berat_akhir=berat_akhir-'4.140',berat_akhir_asli=berat_akhir_asli-'4.140',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPLT-ZHBA-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0015','2026-08-23','4.140','2026-08-23','15:11:58','PLG0014799','3127000','3127000','0','3127000','0','kasir','2026-08-23 15:11:58','FJ-260823-0014','DP-03087','2440000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0015','2026-08-23','15:11:58','ALIKA','3127000','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-260823-0024','2026-08-23','2026-08-23 15:11:58','PENJUALAN : FJ-260823-0015','0','TBC','687000','687000','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-260823-0025','D','2026-08-23','15:11:58','TBC','PENJUALAN','FJ-260823-0015','26641856064','687000','26642543064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1074000' WHERE no_faktur_jual='FJ-260823-0015' 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-03570','SSAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 16 putoh doff semprot','font vintage rotter grf Desi . . .','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-260823-0025','2026-08-23','2026-08-23 15:13:15','PESANAN : DP-03570','.','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-260823-0026','D','2026-08-23','15:13:15','TBC','PESANAN','DP-03570','26642543064','900000','26643443064','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-03570','2026-08-23','2026-08-23','15:13:15','PLG0014800','SSAL','2026-09-20','kasirbip','2026-08-23 15:13:15','3.000','0','0','0','900000','0','0','900000','900000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-23 ','15:13:32');
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-03571','NAD','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','850000','0','850000','sze cwe 14 sz cwo 15','Grf cwo Elsa ..... Indra Font Vintage','Grf cwe Indra .... Elsa 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-260823-0026','2026-08-23','2026-08-23 15:22:45','PESANAN : DP-03571','.','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-260823-0027','D','2026-08-23','15:22:45','TBC','PESANAN','DP-03571','26643443064','850000','26644293064','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-03571','2026-08-23','2026-08-23','15:22:45','PLG0014801','NAD','2026-09-14','kasirbip','2026-08-23 15:22:45','4.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-03572','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 16 putih doff semprot','font vintage rotter grf Desi . . .','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-260823-0027','2026-08-23','2026-08-23 15:24:51','PESANAN : DP-03572','.','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-260823-0028','D','2026-08-23','15:24:51','TBC','PESANAN','DP-03572','26644293064','900000','26645193064','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-03572','2026-08-23','2026-08-23','15:24:51','PLG0014802','SAL','2026-09-20','kasirbip','2026-08-23 15:24:51','3.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-03573','VAN','1','GOLD','WEDDRING WANITA','','','3.500','','50.00','1','2420000','1800000','0','1000000','7300000','PERMATA 41','SIZE: 13 GRF: Raka??','FONT: BERKSHIRE PUTIH MIX ROSE GOLD','410000','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0028','2026-08-23','2026-08-23 15:55:47','PESANAN : DP-03573','-','TBC','5000000','5000000');
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-260823-0029','D','2026-08-23','15:55:47','TBC','PESANAN','DP-03573','26645193064','5000000','26650193064','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-03573','2026-08-23','2026-08-23','15:55:47','PLG0014803','VAN','2026-09-17','sby','2026-08-23 15:55:47','3.500','0','0','0','5000000','0','1000000','7710000','7710000','2710000');
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-03574','VAN','1','PLD','WEDDRING PRIA','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','SIZE: 19','GRF: Atrik?? FONT:BERKSHIRE','PUTIH MIX ROSE GOLD','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-260823-0029','2026-08-23','2026-08-23 16:05:26','PESANAN : DP-03574','-','TBC','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260823-0030','D','2026-08-23','16:05:26','TBC','PESANAN','DP-03574','26650193064','2000000','26652193064','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-03574','2026-08-23','2026-08-23','16:05:26','PLG0014804','VAN','2026-09-17','sby','2026-08-23 16:05:26','4.000','0','0','0','2000000','0','800000','3000000','3000000','1000000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-23 ','16:06:57');
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-260823-0016','kasirbip','1',' DP-03224BI','TOKO','BIPPSN','PSGT-ZHAI-51-0','CINCIN EMAS ','','1.500','1','83.00','3074000','0','0','17800','4495000','0','0','0','4495000','SAL','00046255','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZHAI-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSGT-ZHAI-51-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-260823-0016','2026-08-23','1.500','2026-08-23','16:09:12','PLG0014805','4495000','4495000','0','4495000','0','kasirbip','2026-08-23 16:09:12','FJ-260823-0016','DP-03224','3596000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0016','2026-08-23','16:09:12','SAL','4495000','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-260823-0030','2026-08-23','2026-08-23 16:09:12','PENJUALAN : FJ-260823-0016','.','TBC','899000','899000','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-260823-0031','D','2026-08-23','16:09:12','TBC','PENJUALAN','FJ-260823-0016','26652193064','899000','26653092064','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='899000' WHERE no_faktur_jual='FJ-260823-0016' 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-260823-0017','kasirbip',' 1',' DP-03225BI','TOKO','BIPPSN','PSPRT-ZHBX-6-0','CINCIN PERAK ','','2.720','1','100.00','278000','0','0','17800','850000','0','0','0','850000','SAL','00046264','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBX-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.720',berat_jual_asli=berat_jual_asli+'2.720',stock_jual='1',berat_akhir=berat_akhir-'2.720',berat_akhir_asli=berat_akhir_asli-'2.720',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPRT-ZHBX-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0017','2026-08-23','2.720','2026-08-23','16:09:12','PLG0014806','850000','850000','0','850000','0','kasirbip','2026-08-23 16:09:12','FJ-260823-0016','DP-03225','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-08-23','FJ-260823-0017','2026-08-23','16:09:12','SAL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='899000' WHERE no_faktur_jual='FJ-260823-0017' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-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-260823-0018','sby','1',' 750K-18-00','TOKO','SBYPER','PSBY-ZGXG-6-0','CINCIN SILVER 925 ','','3.170','1','100.00','324000','0','0','17800','850000','0','0','0','850000','DIL','00045019','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGXG-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSBY-ZGXG-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0018','2026-08-23','3.170','2026-08-23','16:17:29','PLG0014807','850000','850000','0','850000','0','sby','2026-08-23 16:17:29','FJ-260823-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0018','2026-08-23','16:17:29','DIL','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-260823-0031','2026-08-23','2026-08-23 16:17:29','PENJUALAN : FJ-260823-0018','','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260823-0032','D','2026-08-23','16:17:29','TBC','PENJUALAN','FJ-260823-0018','26653092064','850000','26653942064','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-260823-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-260823-0019','sby',' 1',' 1.0K-14-00','TOKO','SBYPER','PSBY-ZDCX-64-0','CINCIN SILVER 925 ','','1.230','1','100.00','126000','0','0','17800','1100000','0','0','0','1100000','DIL','00043021','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZDCX-64-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSBY-ZDCX-64-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0019','2026-08-23','1.230','2026-08-23','16:17:29','PLG0014808','1100000','1100000','0','1100000','0','sby','2026-08-23 16:17:29','FJ-260823-0018','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0019','2026-08-23','16:17:29','DIL','1100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260823-0032','2026-08-23','2026-08-23 16:17:29','PENJUALAN : FJ-260823-0019','','TBC','1100000','1100000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260823-0033','D','2026-08-23','16:17:29','TBC','PENJUALAN','FJ-260823-0019','26653942064','1100000','26655042064','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='1950000' WHERE no_faktur_jual='FJ-260823-0019' LIMIT 1;
INSERT INTO tt_persekot_batal_detail SELECT * FROM tt_persekot_detail WHERE no_persekot='DP-03570';
INSERT INTO tt_persekot_batal_head SELECT * FROM tt_persekot_head WHERE no_persekot='DP-03570';
UPDATE tt_persekot_head SET status ='CANC' WHERE no_persekot ='DP-03570';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260823-0002','K','2026-08-23','16:25:41','kasirbip','PESANAN BATAL','DP-03570','16875300','0','16875300');
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-260823-0020','sby','1',' 750K-18-00','TOKO','SBYPER','PSBY-ZGBB-32-0','CINCIN SILVER 925 ','','2.830','1','100.00','289000','0','0','17800','850000','0','0','0','850000','VAN','00045523','PSBY','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGBB-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.830',berat_jual_asli=berat_jual_asli+'2.830',stock_jual='1',berat_akhir=berat_akhir-'2.830',berat_akhir_asli=berat_akhir_asli-'2.830',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSBY-ZGBB-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0020','2026-08-23','2.830','2026-08-23','16:32:23','PLG0014809','850000','850000','0','850000','0','sby','2026-08-23 16:32:23','FJ-260823-0020','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0020','2026-08-23','16:32:23','VAN','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260823-0033','2026-08-23','2026-08-23 16:32:23','PENJUALAN : FJ-260823-0020','','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-260823-0034','D','2026-08-23','16:32:23','TBC','PENJUALAN','FJ-260823-0020','26655042064','850000','26655892064','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-260823-0020' 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-03575','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 15 putih doff semprot','font berkshire swash grf Rara','','0','','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0034','2026-08-23','2026-08-23 16:47:21','PESANAN : DP-03575','..','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-260823-0035','D','2026-08-23','16:47:21','TBC','PESANAN','DP-03575','26655892064','1450000','26657342064','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-03575','2026-08-23','2026-08-23','16:47:21','PLG0014810','SULIS','2026-09-06','kasirbip','2026-08-23 16:47:21','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-03576','SULIS','1','GOLD','WED RING','','','3.000','','75.00','1','2420000','2250000','0','750000','7500000','1 zircon size 8.5 rosegold glosy','font berkshire swash grf Hary','berat jangan lebih dr 3 kalau bisa pas','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0035','2026-08-23','2026-08-23 16:49:00','PESANAN : DP-03576','.','TBC','6000000','6000000');
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-260823-0036','D','2026-08-23','16:49:00','TBC','PESANAN','DP-03576','26657342064','6000000','26663342064','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-03576','2026-08-23','2026-08-23','16:49:00','PLG0014811','SULIS','2026-09-06','kasirbip','2026-08-23 16:49:00','3.000','0','0','0','6000000','0','750000','7500000','7500000','1500000');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-08-23 ','16:57:40');
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-03577','NAD','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','950000','0','950000','sze cwe 11.5 sz cwo 18.5','Grf cwe Deden...Siti Grf cwo Siti...Deden','font Berkshire mata dibikin tanam EXPRESS 200.000','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-260823-0036','2026-08-23','2026-08-23 17:02:23','PESANAN : DP-03577','.','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-260823-0037','D','2026-08-23','17:02:23','TBC','PESANAN','DP-03577','26663342064','950000','26664292064','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-03577','2026-08-23','2026-08-23','17:02:23','PLG0014812','NAD','2026-08-28','kasirbip','2026-08-23 17:02:23','4.000','0','0','0','950000','0','0','950000','950000','0');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0019' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0019' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0019';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0020' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0020' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0020';
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-03578','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','1500000','0','1500000','sz cwe 10 CP.05 grf 26.09.26','sz cwo 12.5 CP.05 grf 26.09.26','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-260823-0037','2026-08-23','2026-08-23 17:30:19','PESANAN : DP-03578','.','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-260823-0038','D','2026-08-23','17:30:19','TBC','PESANAN','DP-03578','26664292064','1500000','26665792064','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-03578','2026-08-23','2026-08-23','17:30:19','PLG0014813','PUT','2026-09-20','kasirbip','2026-08-23 17:30:19','4.000','0','0','0','1500000','0','0','1500000','1500000','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-260823-0021','kasirbip','1',' 800K-18-00','TOKO','DUPERBDG','LXPER-ZFAH-32-0','CINCIN SILVER 925 ','','3.570','1','100.00','365000','0','0','17800','900000','0','0','0','900000','NAD','00044545','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAH-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.570',berat_jual_asli=berat_jual_asli+'3.570',stock_jual='1',berat_akhir=berat_akhir-'3.570',berat_akhir_asli=berat_akhir_asli-'3.570',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='LXPER-ZFAH-32-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-260823-0021','2026-08-23','3.570','2026-08-23','17:44:47','PLG0014814','900000','900000','0','900000','0','kasirbip','2026-08-23 17:44:47','FJ-260823-0021','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0021','2026-08-23','17:44:47','NAD','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-260823-0038','2026-08-23','2026-08-23 17:44:47','PENJUALAN : FJ-260823-0021','.','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-260823-0039','D','2026-08-23','17:44:47','TBC','PENJUALAN','FJ-260823-0021','26665792064','900000','26666692064','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-260823-0021' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260823-0022','kasirbip',' 1',' 800K-135-0','TOKO','DUPERBDG','LXPER-ZHAD-12-0','CINCIN SILVER 925 ','','2.310','1','100.00','236000','0','0','17800','900000','0','0','0','900000','NAD','00046160','LXPER','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHAD-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='LXPER-ZHAD-12-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-260823-0022','2026-08-23','2.310','2026-08-23','17:44:47','PLG0014815','900000','900000','0','900000','0','kasirbip','2026-08-23 17:44:47','FJ-260823-0021','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0022','2026-08-23','17:44:47','NAD','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-260823-0039','2026-08-23','2026-08-23 17:44:47','PENJUALAN : FJ-260823-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-260823-0040','D','2026-08-23','17:44:47','TBC','PENJUALAN','FJ-260823-0022','26666692064','900000','26667592064','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='1800000' WHERE no_faktur_jual='FJ-260823-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-260823-0023','kasirbip','1',' DP-03149BI','TOKO','BIPPSN','PSPRT-ZHBX-8-0','1PS CINCIN PERAK ','','4.530','1','100.00','463000','0','0','17800','1500000','0','0','0','1500000','SAL','00046266','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZHBX-8-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.530',berat_jual_asli=berat_jual_asli+'4.530',stock_jual='1',berat_akhir=berat_akhir-'4.530',berat_akhir_asli=berat_akhir_asli-'4.530',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPRT-ZHBX-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0023','2026-08-23','4.530','2026-08-23','17:55:06','PLG0014816','1500000','1500000','0','1500000','0','kasirbip','2026-08-23 17:55:05','FJ-260823-0023','DP-03149','1500000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0023','2026-08-23','17:55:06','SAL','1500000','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-260823-0023' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0023';
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-260823-0024','sby','1',' DP-03109SB','TOKO','SBYPSN','PSPLT-ZHAH-7-0','CINCIN PALADIUM YL10 ','','4.060','1','32.00','1716000','0','0','17800','2933000','0','0','0','2933000','VAN','00046199','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZHAH-7-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.060',berat_jual_asli=berat_jual_asli+'4.060',stock_jual='1',berat_akhir=berat_akhir-'4.060',berat_akhir_asli=berat_akhir_asli-'4.060',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPLT-ZHAH-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-260823-0024','2026-08-23','4.060','2026-08-23','18:22:22','PLG0014817','2933000','2933000','0','2933000','0','sby','2026-08-23 18:22:21','FJ-260823-0024','DP-03109','2400000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0024','2026-08-23','18:22:22','VAN','2933000','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-260823-0040','2026-08-23','2026-08-23 18:22:21','PENJUALAN : FJ-260823-0024','','TBC','533000','533000','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-260823-0041','D','2026-08-23','18:22:22','TBC','PENJUALAN','FJ-260823-0024','26667592064','533000','26668125064','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='533000' WHERE no_faktur_jual='FJ-260823-0024' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0024';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-23 ','18:23:44');
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-260823-0025','kasirbip','1',' 800K-19-28','TOKO','BIPPER','PBDG-ZHXD-34-0','CINCIN SILVER 925 ','','4.120','1','100.00','421000','0','0','17800','900000','0','0','0','900000','KUR','00045873','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHXD-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.120',berat_jual_asli=berat_jual_asli+'4.120',stock_jual='1',berat_akhir=berat_akhir-'4.120',berat_akhir_asli=berat_akhir_asli-'4.120',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PBDG-ZHXD-34-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-260823-0025','2026-08-23','4.120','2026-08-23','18:25:05','PLG0014818','900000','900000','0','900000','0','kasirbip','2026-08-23 18:25:05','FJ-260823-0025','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0025','2026-08-23','18:25:05','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-260823-0041','2026-08-23','2026-08-23 18:25:05','PENJUALAN : FJ-260823-0025','.','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-260823-0042','D','2026-08-23','18:25:05','TBC','PENJUALAN','FJ-260823-0025','26668125064','900000','26669025064','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-260823-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-260823-0026','kasirbip',' 1',' 750K-135 ','TOKO','BIPCMP','BDCM-ZGCX-44-0','CINCIN EMAS 9K ','','1.890','1','45.00','2083000','0','0','17800','3400000','0','0','0','3400000','KUR','00045772','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZGCX-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='BDCM-ZGCX-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260823-0026','2026-08-23','1.890','2026-08-23','18:25:05','PLG0014819','3400000','3400000','0','3400000','0','kasirbip','2026-08-23 18:25:05','FJ-260823-0025','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0026','2026-08-23','18:25:05','KUR','3400000','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-260823-0042','2026-08-23','2026-08-23 18:25:05','PENJUALAN : FJ-260823-0026','.','TBC','3400000','3400000','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-260823-0043','D','2026-08-23','18:25:05','TBC','PENJUALAN','FJ-260823-0026','26669025064','3400000','26672425064','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='4300000' WHERE no_faktur_jual='FJ-260823-0026' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0026';
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-260823-0027','kasir','1',' 800K-20-11','TOKO','MMPER','PMM-ZHXD-69-0','CINCIN SILVER 925 ','','3.450','1','100.00','352000','0','0','17800','900000','0','0','0','900000','ELLA','00045908','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHXD-69-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.450',berat_jual_asli=berat_jual_asli+'3.450',stock_jual='1',berat_akhir=berat_akhir-'3.450',berat_akhir_asli=berat_akhir_asli-'3.450',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PMM-ZHXD-69-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-260823-0027','2026-08-23','3.450','2026-08-23','18:37:20','PLG0014820','900000','900000','0','900000','0','kasir','2026-08-23 18:37:19','FJ-260823-0027','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0027','2026-08-23','18:37:20','ELLA','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-260823-0043','2026-08-23','2026-08-23 18:37:19','PENJUALAN : FJ-260823-0027','0','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260823-0044','D','2026-08-23','18:37:20','TBC','PENJUALAN','FJ-260823-0027','26672425064','900000','26673325064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-260823-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-260823-0028','kasir',' 1',' 800K-19-11','TOKO','MMPER','PMM-ZHXD-70-0','CINCIN SILVER 925 ','','3.460','1','100.00','353000','0','0','17800','900000','0','0','0','900000','ELLA','00045909','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHXD-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.460',berat_jual_asli=berat_jual_asli+'3.460',stock_jual='1',berat_akhir=berat_akhir-'3.460',berat_akhir_asli=berat_akhir_asli-'3.460',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PMM-ZHXD-70-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-260823-0028','2026-08-23','3.460','2026-08-23','18:37:20','PLG0014821','900000','900000','0','900000','0','kasir','2026-08-23 18:37:19','FJ-260823-0027','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0028','2026-08-23','18:37:20','ELLA','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-260823-0044','2026-08-23','2026-08-23 18:37:19','PENJUALAN : FJ-260823-0028','0','TBC','900000','900000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260823-0045','D','2026-08-23','18:37:20','TBC','PENJUALAN','FJ-260823-0028','26673325064','900000','26674225064','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1800000' WHERE no_faktur_jual='FJ-260823-0028' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0027' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0027' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0027';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0028' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0028' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0028';
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-03579','NAD','1','GOLD','WEDRING','','','3.100','','75.00','1','2420000','2250000','0','700000','7675000','size 11 crom putih rose gold glossy','jangan kurang dari 3 gram 17 zircon','dibikin tebal dan lebar max 4 mili','0','170000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0045','2026-08-23','2026-08-23 19:13:45','PESANAN : DP-03579','.','TBC','6276000','6276000');
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-260823-0046','D','2026-08-23','19:13:45','TBC','PESANAN','DP-03579','26674225064','6276000','26680501064','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-03579','2026-08-23','2026-08-23','19:13:45','PLG0014822','NAD','2026-09-20','kasirbip','2026-08-23 19:13:45','3.100','0','0','0','6276000','0','700000','7845000','7845000','1569000');
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-260823-0029','kasirbip','1',' 800K-21-28','TOKO','BIPPER','PBDG-ZHXD-35-0','CINCIN SILVER 925 ','','3.670','1','100.00','375000','0','0','17800','850000','0','0','0','850000','SULIS','00045874','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHXD-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.670',berat_jual_asli=berat_jual_asli+'3.670',stock_jual='1',berat_akhir=berat_akhir-'3.670',berat_akhir_asli=berat_akhir_asli-'3.670',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PBDG-ZHXD-35-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-260823-0029','2026-08-23','3.670','2026-08-23','19:42:14','PLG0014823','850000','850000','0','850000','0','kasirbip','2026-08-23 19:42:14','FJ-260823-0029','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0029','2026-08-23','19:42:14','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-260823-0046','2026-08-23','2026-08-23 19:42:14','PENJUALAN : FJ-260823-0029','.','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-260823-0047','D','2026-08-23','19:42:14','TBC','PENJUALAN','FJ-260823-0029','26680501064','850000','26681351064','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-260823-0029' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-23 ','19:46:00');
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-260823-0030','kasir','1',' DP-03194MM','TOKO','MMPSN','PSGT-ZHBX-22-0','CINCIN EMAS ','','2.700','1','83.00','5532000','0','0','17800','7185000','0','0','0','7185000','ELLA','00046280','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZHBX-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.700',berat_jual_asli=berat_jual_asli+'2.700',stock_jual='1',berat_akhir=berat_akhir-'2.700',berat_akhir_asli=berat_akhir_asli-'2.700',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSGT-ZHBX-22-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-260823-0030','2026-08-23','2.700','2026-08-23','19:47:20','PLG0014824','7185000','7185000','0','7185000','0','kasir','2026-08-23 19:47:19','FJ-260823-0030','DP-03194','5388000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0030','2026-08-23','19:47:20','ELLA','7185000','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-260823-0047','2026-08-23','2026-08-23 19:47:19','PENJUALAN : FJ-260823-0030','.','TBC','1797000','1797000','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-260823-0048','D','2026-08-23','19:47:20','TBC','PENJUALAN','FJ-260823-0030','26681351064','1797000','26683148064','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='1797000' WHERE no_faktur_jual='FJ-260823-0030' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0029' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0029' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0029';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0030' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0030' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0030';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-08-23 ','19:52:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-08-23 ','20:12:50');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260823-0031','sby','1',' DP-02495SB','TOKO','SBYPSN','PSPLT-ZGXH-21-0','CINCIN PALADIUM ','','2.620','1','57.00','1972000','0','0','17800','3470000','0','0','0','3470000','DIL','00045066','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZGXH-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='PSPLT-ZGXH-21-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-260823-0031','2026-08-23','2.620','2026-08-23','20:41:15','PLG0014825','3470000','3470000','0','3470000','0','sby','2026-08-23 20:41:14','FJ-260823-0031','DP-02495','2300000');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-23','FJ-260823-0031','2026-08-23','20:41:15','DIL','3470000','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-260823-0048','2026-08-23','2026-08-23 20:41:14','PENJUALAN : FJ-260823-0031','','TBC','1170000','1170000','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-260823-0049','D','2026-08-23','20:41:15','TBC','PENJUALAN','FJ-260823-0031','26683148064','1170000','26684318064','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='1170000' WHERE no_faktur_jual='FJ-260823-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-260823-0032','sby',' 1',' DP-02494SB','TOKO','SBYPSN','PSPRT-ZFBI-35-0','CINCIN PERAK ','','4.030','1','100.00','412000','0','0','17800','850000','0','0','0','850000','DIL','00044826','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZFBI-35-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-08-23' AND kode_barang='PSPRT-ZFBI-35-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-260823-0032','2026-08-23','4.030','2026-08-23','20:41:15','PLG0014826','850000','850000','0','850000','0','sby','2026-08-23 20:41:14','FJ-260823-0031','DP-02494','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-08-23','FJ-260823-0032','2026-08-23','20:41:15','DIL','850000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1170000' WHERE no_faktur_jual='FJ-260823-0032' 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-03580','ALIKA','1','GOLD','WEDING RING','','','2.000','','75.00','1','2420000','2250000','0','700000','5200000','size 9 grf Restu AP','crom kuning glosy','zircone 3 btr','0','0','30000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0049','2026-08-23','2026-08-23 20:43:18','PESANAN : DP-03580','0','TBC','4184000','4184000');
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-260823-0050','D','2026-08-23','20:43:18','TBC','PESANAN','DP-03580','26684318064','4184000','26688502064','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-03580','2026-08-23','2026-08-23','20:43:18','PLG0014827','ALIKA','2026-09-22','kasir','2026-08-23 20:43:18','2.000','0','0','0','4184000','0','700000','5230000','5230000','1046000');
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-03581','ALIKA','1','PLD','WEDING RING','','','4.500','','25.00','1','1200000','550000','0','850000','3325000','size 19 zircone 1 btr','grf NJ Apriliyani','crom putih doff amplas','0','0','');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260823-0050','2026-08-23','2026-08-23 20:48:02','PESANAN : DP-03581','0','TBC','2660000','2660000');
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-260823-0051','D','2026-08-23','20:48:02','TBC','PESANAN','DP-03581','26688502064','2660000','26691162064','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-03581','2026-08-23','2026-08-23','20:48:02','PLG0014828','ALIKA','2026-09-22','kasir','2026-08-23 20:48:02','4.500','0','0','0','2660000','0','850000','3325000','3325000','665000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260823-0032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260823-0032';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-23';
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-08-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-23';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-23' 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-260824-0001','D','2026-08-24','21:09:09','TBC','SALDO AWAL','SALDO AWAL','0','26691162064','26691162064');
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-260824-0001','D','2026-08-24','21:09:09','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-260824-0001','D','2026-08-24','21:09:09','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-260824-0001','D','2026-08-24','21:09:09','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-260824-0001','D','2026-08-24','21:09:09','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-260824-0001','D','2026-08-24','21:09:09','','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-260824-0001','D','2026-08-24','21:09:09','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-260824-0001','D','2026-08-24','21:09:09','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-260824-0001','D','2026-08-24','21:09:09','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-260824-0001','D','2026-08-24','21:09:09','BCD','SALDO AWAL','SALDO AWAL','0','1452669500','1452669500');
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-260824-0001','D','2026-08-24','21:09:09','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-260824-0001','D','2026-08-24','21:09:09','BCK','SALDO AWAL','SALDO AWAL','0','2007408000','2007408000');
UPDATE tp_system SET tgl_system='2026-08-24';