INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-26 ','08:14:36'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-26 ','10:36:40'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-26 ','11:03:13'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-26 ','11:05:27'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-26 ','11:06:39'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-26 ','11:37:53'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-26 ','11:46:49'); 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-04820','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz 15 crom putih doff amplas','grf Sonjaya font Vladimir','lebar dibikin 3 mili garis di bikin 2 garis','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-261026-0001','2026-10-26','2026-10-26 11:46:58','PESANAN : DP-04820','.','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-261026-0002','D','2026-10-26','11:46:58','TBC','PESANAN','DP-04820','29992578964','950000','29993528964','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-04820','2026-10-26','2026-10-26','11:46:58','PLG0017966','PUT','2026-11-30','kasirbip','2026-10-26 11:46:58','3.000','0','0','0','950000','0','0','950000','950000','0'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-26', status ='CLOS' WHERE no_service='SV-02274'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02274'; 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-261026-0001','kasirbip','1',' DP-04427DU','TOKO','DUPSN','PSPRT-ZJBC-23-0','CINCIN PERAK ','','1.990','1','100.00','203000','0','0','17800','950000','0','0','0','950000','PUT','00048543','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBC-23-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-261026-0001','2026-10-26','1.990','2026-10-26','12:25:23','PLG0017967','950000','950000','0','950000','0','kasirbip','2026-10-26 12:25:22','FJ-261026-0001','DP-04427','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0001','2026-10-26','12:25:23','PUT','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261026-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-261026-0002','kasirbip',' 1',' DP-04428DU','TOKO','DUPSN','PSPRT-ZJBC-7-0','CINCIN PERAK YL10 ','','4.330','1','100.00','442000','0','0','17800','950000','0','0','0','950000','PUT','00048527','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.330',berat_jual_asli=berat_jual_asli+'4.330',stock_jual='1',berat_akhir=berat_akhir-'4.330',berat_akhir_asli=berat_akhir_asli-'4.330',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBC-7-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-261026-0002','2026-10-26','4.330','2026-10-26','12:25:23','PLG0017968','950000','950000','0','950000','0','kasirbip','2026-10-26 12:25:22','FJ-261026-0001','DP-04428','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0002','2026-10-26','12:25:23','PUT','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261026-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0002'; 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-04821','PUT','1','PER','WEDRING','','','3.500','','925.00','1','100000','0','850000','0','850000','sz cwe 8 grf Eca','sz cwo 16 grf Ghazi','font Brush script','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0002','2026-10-26','2026-10-26 12:34:32','PESANAN : DP-04821','.','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-261026-0003','D','2026-10-26','12:34:32','TBC','PESANAN','DP-04821','29993528964','850000','29994378964','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-04821','2026-10-26','2026-10-26','12:34:32','PLG0017969','PUT','2026-11-30','kasirbip','2026-10-26 12:34:32','3.500','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0003','kasirbip','1',' DP-04447DU','TOKO','DUPSN','PSPRT-ZJBD-31-0','CINCIN PERAK SR02 YL01 ','','3.080','1','100.00','315000','0','0','17800','950000','0','0','0','950000','MIL','00048606','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBD-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.080',berat_jual_asli=berat_jual_asli+'3.080',stock_jual='1',berat_akhir=berat_akhir-'3.080',berat_akhir_asli=berat_akhir_asli-'3.080',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBD-31-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-261026-0003','2026-10-26','3.080','2026-10-26','13:18:43','PLG0017970','950000','950000','0','950000','0','kasirbip','2026-10-26 13:18:42','FJ-261026-0003','DP-04447','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0003','2026-10-26','13:18:43','MIL','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261026-0003' 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-04822','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','cwo sz 12 putih doff amplas EXPRESS 250.000','cwe sz 14 putih glossy 1 zirkon UPSIZE 100.000','grf keduanya 1.11.26 font yeseva one','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0003','2026-10-26','2026-10-26 13:21:15','PESANAN : DP-04822','.','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-261026-0004','D','2026-10-26','13:21:15','TBC','PESANAN','DP-04822','29994378964','850000','29995228964','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-04822','2026-10-26','2026-10-26','13:21:15','PLG0017971','SULIS','2026-10-29','kasirbip','2026-10-26 13:21:15','2.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-26 ','13:22:22'); 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-261026-0004','kasirbip','1',' DP-04419DU','TOKO','DUPSN','PSPRT-ZJBD-21-0','CINCIN PERAK ','','3.180','1','100.00','325000','0','0','17800','850000','0','0','0','850000','PUT','00048596','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBD-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBD-21-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-261026-0004','2026-10-26','3.180','2026-10-26','13:52:19','PLG0017972','850000','850000','0','850000','0','kasirbip','2026-10-26 13:52:19','FJ-261026-0004','DP-04419','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-10-26','FJ-261026-0004','2026-10-26','13:52:19','PUT','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261026-0004' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0005','kasirbip',' 1',' DP-04420DU','TOKO','DUPSN','PSPRT-ZJBD-20-0','CINCIN PERAK ','','3.800','1','100.00','388000','0','0','17800','850000','0','0','0','850000','PUT','00048595','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBD-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.800',berat_jual_asli=berat_jual_asli+'3.800',stock_jual='1',berat_akhir=berat_akhir-'3.800',berat_akhir_asli=berat_akhir_asli-'3.800',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBD-20-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-261026-0005','2026-10-26','3.800','2026-10-26','13:52:19','PLG0017973','850000','850000','0','850000','0','kasirbip','2026-10-26 13:52:19','FJ-261026-0004','DP-04420','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-10-26','FJ-261026-0005','2026-10-26','13:52:19','PUT','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261026-0005' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0005'; 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-04823','SAL','1','GOLD','WED RING','','','2.500','','50.00','1','2300000','1800000','0','850000','5350000','8 zircon rosegold glosy sz 13','font vladimir grf Mulky','','80000','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0004','2026-10-26','2026-10-26 14:08:48','PESANAN : DP-04823','.','TBC','4344000','4344000'); 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-261026-0005','D','2026-10-26','14:08:48','TBC','PESANAN','DP-04823','29995228964','4344000','29999572964','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-04823','2026-10-26','2026-10-26','14:08:48','PLG0017974','SAL','2026-11-26','kasirbip','2026-10-26 14:08:48','2.500','0','0','0','4344000','0','850000','5430000','5430000','1086000'); 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-04824','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 17 putih doff amplas','font vladimir grf Hana','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0005','2026-10-26','2026-10-26 14:11:12','PESANAN : DP-04824','.','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-261026-0006','D','2026-10-26','14:11:12','TBC','PESANAN','DP-04824','29999572964','900000','30000472964','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-04824','2026-10-26','2026-10-26','14:11:12','PLG0017975','SAL','2026-11-26','kasirbip','2026-10-26 14:11:12','2.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-04825','PUT','1','PLD','WEDRING','','','3.500','','10.00','1','1200000','350000','750000','0','1975000','sz cowo 23 catalog LX-2551','grf Elsa font Vladimir','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0006','2026-10-26','2026-10-26 14:17:33','PESANAN : DP-04825','.','TBC','1580000','1580000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261026-0007','D','2026-10-26','14:17:33','TBC','PESANAN','DP-04825','30000472964','1580000','30002052964','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-04825','2026-10-26','2026-10-26','14:17:33','PLG0017976','PUT','2026-11-30','kasirbip','2026-10-26 14:17:33','3.500','0','0','0','1580000','0','0','1975000','1975000','395000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04826','PUT','1','PLD','WEDRING','','','2.000','','10.00','1','1200000','350000','0','800000','1500000','sz cwe 8 catalog LX-2551','grf Elsa font Vladimir','zircon 20','0','0','200000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0007','2026-10-26','2026-10-26 14:20:54','PESANAN : DP-04826','.','TBC','1360000','1360000'); 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-261026-0008','D','2026-10-26','14:20:54','TBC','PESANAN','DP-04826','30002052964','1360000','30003412964','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-04826','2026-10-26','2026-10-26','14:20:54','PLG0017977','PUT','2026-11-30','kasirbip','2026-10-26 14:20:54','2.000','0','0','0','1360000','0','800000','1700000','1700000','340000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-26 ','14:31:10'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-26 ','14:57:15'); 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-261026-0006','kasir','1',' 800K-19-13','TOKO','MMPER','PMM-ZJAI-47-0','CINCIN SILVER 925 ','','3.110','1','100.00','318000','0','0','17800','900000','0','0','0','900000','ELLA','00048291','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZJAI-47-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PMM-ZJAI-47-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-261026-0006','2026-10-26','3.110','2026-10-26','14:59:32','PLG0017978','900000','900000','0','900000','0','kasir','2026-10-26 14:59:32','FJ-261026-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0006','2026-10-26','14:59:32','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-261026-0008','2026-10-26','2026-10-26 14:59:32','PENJUALAN : FJ-261026-0006','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-261026-0009','D','2026-10-26','14:59:32','TBC','PENJUALAN','FJ-261026-0006','30003412964','900000','30004312964','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-261026-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-261026-0007','kasir',' 1',' 800K-9-917','TOKO','MMPER','PMM-ZBBG-17-0','CINCIN SILVER 925 ','','2.340','1','100.00','239000','0','0','17800','900000','0','0','0','900000','ELLA','00042019','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZBBG-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.340',berat_jual_asli=berat_jual_asli+'2.340',stock_jual='1',berat_akhir=berat_akhir-'2.340',berat_akhir_asli=berat_akhir_asli-'2.340',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PMM-ZBBG-17-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-261026-0007','2026-10-26','2.340','2026-10-26','14:59:32','PLG0017979','900000','900000','0','900000','0','kasir','2026-10-26 14:59:32','FJ-261026-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0007','2026-10-26','14:59:32','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-261026-0009','2026-10-26','2026-10-26 14:59:32','PENJUALAN : FJ-261026-0007','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-261026-0010','D','2026-10-26','14:59:32','TBC','PENJUALAN','FJ-261026-0007','30004312964','900000','30005212964','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-261026-0007' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-26 ','15:07: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-261026-0008','kasirbip','1',' DP-04312BI','TOKO','BIPPSN','PSPRT-ZJBX-61-0','CINCIN PERAK ','','2.000','1','100.00','204000','0','0','17800','1050000','0','0','0','1050000','SAL','00048394','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-61-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBX-61-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-261026-0008','2026-10-26','2.000','2026-10-26','15:12:49','PLG0017980','1050000','1050000','0','1050000','0','kasirbip','2026-10-26 15:12:49','FJ-261026-0008','DP-04312','1050000'); 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-10-26','FJ-261026-0008','2026-10-26','15:12:49','SAL','1050000','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-261026-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-261026-0009','kasirbip',' 1',' DP-04313BI','TOKO','BIPPSN','PSPRT-ZJAB-2-0','CINCIN PERAK ','','4.160','1','100.00','425000','0','0','17800','900000','0','0','0','900000','SAL','00048085','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAB-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.160',berat_jual_asli=berat_jual_asli+'4.160',stock_jual='1',berat_akhir=berat_akhir-'4.160',berat_akhir_asli=berat_akhir_asli-'4.160',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJAB-2-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-261026-0009','2026-10-26','4.160','2026-10-26','15:12:49','PLG0017981','900000','900000','0','900000','0','kasirbip','2026-10-26 15:12:49','FJ-261026-0008','DP-04313','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0009','2026-10-26','15:12:49','SAL','900000','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-261026-0009' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0009'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02299','SAL','1','CC SILVER','PUTIH DOFF SEMPROT SZ 22 FONT YESEVA ONE','3.000','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02299','2026-10-26','2026-10-26','15:23:02','PLG0017982','kasirbip','2026-11-11','kasirbip','2026-10-26 15:23:02','3.000','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-26 ','15:23:22'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-26 ','15:31:57'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-26 ','15:42:58'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-10-26 ','16:02:51'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-26 ','16:03:03'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-26 ','16:25:42'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-26 ','16:26: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-04827','DIL','1','PER','WEDD RING CM01','','','3.000','','925.00','1','100000','0','1200000','0','1200000','WANITA: SIZE 13 GRF: Greska (INFI) FONT: BERKSHIRE','PRIA: SIZE 13.5 GRF: Lulu (NITY) FONT: BERKSHIRE','CROM SESUAI FOTO','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-261026-0010','2026-10-26','2026-10-26 16:28:37','PESANAN : DP-04827','-','TBC','1200000','1200000'); 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-261026-0011','D','2026-10-26','16:28:37','TBC','PESANAN','DP-04827','30005212964','1200000','30006412964','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-04827','2026-10-26','2026-10-26','16:28:37','PLG0017983','DIL','2026-11-20','sby','2026-10-26 16:28:37','3.000','0','0','0','1200000','0','0','1200000','1200000','0'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000400','X-00000400','THIFA GELANG RANTAI PUTIH','GR','---','TFGRP','BELI','BELI001','4464000','2026-10-26','2.880','1','kasir','2026-10-26 16:54:00'); DELETE FROM tp_barang WHERE kode_dept = 'X-TFGRP'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFGRP','X-00000400','X-00000400'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261026-0001','-','FIR','1','BELI','BELI001','TFGRP', 'X-00000400', 'THIFA GELANG RANTAI PUTIH','2.880','2.880','75.00','7000000','4464000','1550000','1','4464000','4464000','CUCI'); INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-10-26','BELI','BELI001','TFGRP','TFGRP','75.00','2.880','2.880','1','2.880','2.880','1'); INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-261026-0001','2026-10-26','2026-10-26','16:54:00','FIR','---','2.880','4464000','4464000','4464000','4464000','4464000','kasir','2026-10-26 16:54:00','FB-261026-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0001','YANI','JKT','','JKT','','kasir','2026-10-26 16:54:00'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0011','2026-10-26','2026-10-26 16:54:00','PEMBELIAN UMUM : FB-261026-0001','.','TBC','4464000','4464000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-261026-0012','K','2026-10-26','16:54:00','TBC','PEMBELIAN UMUM','FB-261026-0001','30006412964','4464000','30001948964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.',''); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000401','X-00000401','THIFA CINCIN MAS PUTIH','GR','---','TFCMP','BELI','BELI001','1395000','2026-10-26','0.900','1','kasir','2026-10-26 16:54:00'); DELETE FROM tp_barang WHERE kode_dept = 'X-TFCMP'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFCMP','X-00000401','X-00000401'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261026-0002','-','FIR','2','BELI','BELI001','TFCMP', 'X-00000401', 'THIFA CINCIN MAS PUTIH','0.900','0.900','75.00','2100000','1395000','1550000','1','1395000','1395000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFCMP' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-261026-0002','2026-10-26','2026-10-26','16:54:00','FIR','---','0.900','1395000','1395000','1395000','1395000','1395000','kasir','2026-10-26 16:54:00','FB-261026-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0002','YANI','JKT','','JKT','','kasir','2026-10-26 16:54:00'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0012','2026-10-26','2026-10-26 16:54:00','PEMBELIAN UMUM : FB-261026-0002','.','TBC','1395000','1395000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-261026-0013','K','2026-10-26','16:54:00','TBC','PEMBELIAN UMUM','FB-261026-0002','30001948964','1395000','30000553964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0002'; 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-261026-0010','kasirbip','1',' DP-04346DU','TOKO','DUPSN','PSPRT-ZJBB-26-0','CINCIN PERAK ','','4.260','1','100.00','435000','0','0','17800','900000','0','0','0','900000','KUR','00048499','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBB-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.260',berat_jual_asli=berat_jual_asli+'4.260',stock_jual='1',berat_akhir=berat_akhir-'4.260',berat_akhir_asli=berat_akhir_asli-'4.260',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBB-26-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-261026-0010','2026-10-26','4.260','2026-10-26','17:05:11','PLG0017984','900000','900000','0','900000','0','kasirbip','2026-10-26 17:05:10','FJ-261026-0010','DP-04346','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0010','2026-10-26','17:05:11','KUR','900000','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-261026-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-261026-0011','kasirbip',' 1',' DP-04347DU','TOKO','DUPSN','PSPRT-ZJBC-47-0','CINCIN PERAK ','','3.500','1','100.00','357000','0','0','17800','900000','0','0','0','900000','KUR','00048567','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-47-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBC-47-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-261026-0011','2026-10-26','3.500','2026-10-26','17:05:11','PLG0017985','900000','900000','0','900000','0','kasirbip','2026-10-26 17:05:10','FJ-261026-0010','DP-04347','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0011','2026-10-26','17:05:11','KUR','900000','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-261026-0011' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0011'; 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-261026-0012','kasir','1',' 750K-15-10','TOKO','MMPER','PMM-ZGXF-8-0','CINCIN SILVER 925 ','','1.700','1','100.00','174000','0','0','17800','850000','0','0','0','850000','ALIKA','00044936','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZGXF-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PMM-ZGXF-8-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-261026-0012','2026-10-26','1.700','2026-10-26','17:36:13','PLG0017986','850000','850000','0','850000','0','kasir','2026-10-26 17:36:13','FJ-261026-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-10-26','FJ-261026-0012','2026-10-26','17:36:13','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-261026-0013','2026-10-26','2026-10-26 17:36:13','PENJUALAN : FJ-261026-0012','.','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-261026-0014','D','2026-10-26','17:36:13','TBC','PENJUALAN','FJ-261026-0012','30000553964','850000','30001403964','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-261026-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-261026-0013','kasir',' 1',' 800K-26-13','TOKO','MMPER','PMM-ZJBA-6-0','CINCIN SILVER 925 ','','3.490','1','100.00','356000','0','0','17800','900000','0','0','0','900000','ALIKA','00048436','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZJBA-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.490',berat_jual_asli=berat_jual_asli+'3.490',stock_jual='1',berat_akhir=berat_akhir-'3.490',berat_akhir_asli=berat_akhir_asli-'3.490',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PMM-ZJBA-6-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-261026-0013','2026-10-26','3.490','2026-10-26','17:36:13','PLG0017987','900000','900000','0','900000','0','kasir','2026-10-26 17:36:13','FJ-261026-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-10-26','FJ-261026-0013','2026-10-26','17:36:13','ALIKA','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261026-0014','2026-10-26','2026-10-26 17:36:13','PENJUALAN : FJ-261026-0013','.','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-261026-0015','D','2026-10-26','17:36:13','TBC','PENJUALAN','FJ-261026-0013','30001403964','900000','30002303964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1750000' WHERE no_faktur_jual='FJ-261026-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-261026-0014','sby','1',' 750K-18-00','TOKO','SBYPER','PSBY-ZJAI-73-0','CINCIN SILVER 925 ','','2.140','1','100.00','219000','0','0','17800','850000','0','0','0','850000','VAN','00048317','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJAI-73-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-10-26' AND kode_barang='PSBY-ZJAI-73-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-261026-0014','2026-10-26','2.140','2026-10-26','17:36:21','PLG0017988','850000','850000','0','850000','0','sby','2026-10-26 17:36:20','FJ-261026-0014','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0014','2026-10-26','17:36:21','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-261026-0015','2026-10-26','2026-10-26 17:36:20','PENJUALAN : FJ-261026-0014','','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-261026-0016','D','2026-10-26','17:36:21','TBC','PENJUALAN','FJ-261026-0014','30002303964','850000','30003153964','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-261026-0014' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0015','sby',' 1',' 750K-105-0','TOKO','SBYPER','PSBY-ZEXE-6-0','CINCIN SILVER 925 SR-03 ','','1.350','1','100.00','138000','0','0','17800','850000','0','0','0','850000','VAN','00043202','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSBY-ZEXE-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-261026-0015','2026-10-26','1.350','2026-10-26','17:36:21','PLG0017989','850000','850000','0','850000','0','sby','2026-10-26 17:36:20','FJ-261026-0014','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0015','2026-10-26','17:36:21','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-261026-0016','2026-10-26','2026-10-26 17:36:20','PENJUALAN : FJ-261026-0015','','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-261026-0017','D','2026-10-26','17:36:21','TBC','PENJUALAN','FJ-261026-0015','30003153964','850000','30004003964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-261026-0015' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0016','kasirbip','1',' DP-04245DU','TOKO','DUPSN','PSPRT-ZJBC-6-0','CINCIN PERAK YL01 ','','1.920','1','100.00','196000','0','0','17800','600000','0','0','0','600000','KUR','00048526','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBC-6-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-261026-0016','2026-10-26','1.920','2026-10-26','17:36:45','PLG0017990','600000','600000','0','600000','0','kasirbip','2026-10-26 17:36:45','FJ-261026-0016','DP-04245','600000'); 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-10-26','FJ-261026-0016','2026-10-26','17:36:45','KUR','600000','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-261026-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-261026-0017','kasirbip',' 1',' DP-04244DU','TOKO','DUPSN','PSPRT-ZJBC-35-0','CINCIN PERAK ','','2.320','1','100.00','238000','0','0','17800','900000','0','0','0','900000','KUR','00048555','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-35-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBC-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261026-0017','2026-10-26','2.320','2026-10-26','17:36:45','PLG0017991','900000','900000','0','900000','0','kasirbip','2026-10-26 17:36:45','FJ-261026-0016','DP-04244','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0017','2026-10-26','17:36:45','KUR','900000','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-261026-0017' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-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-261026-0018','kasirbip','1',' 950K-10-29','TOKO','BIPPER','PBDG-ZIBC-21-0','CINCIN SILVER 925 ','','2.400','1','100.00','245000','0','0','17800','1050000','0','0','0','1050000','SAL','00047500','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIBC-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PBDG-ZIBC-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261026-0018','2026-10-26','2.400','2026-10-26','17:40:13','PLG0017992','1050000','1050000','0','1050000','0','kasirbip','2026-10-26 17:40:13','FJ-261026-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-10-26','FJ-261026-0018','2026-10-26','17:40:13','SAL','1050000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261026-0017','2026-10-26','2026-10-26 17:40:13','PENJUALAN : FJ-261026-0018','.','TBC','1050000','1050000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261026-0018','D','2026-10-26','17:40:13','TBC','PENJUALAN','FJ-261026-0018','30004003964','1050000','30005053964','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='1050000' WHERE no_faktur_jual='FJ-261026-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-261026-0019','kasirbip','1',' 750K-19-30','TOKO','BIPPER','PBDG-ZJAI-66-0','CINCIN SILVER 925 ','','2.130','1','100.00','218000','0','0','17800','850000','0','0','0','850000','SULIS','00048310','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZJAI-66-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PBDG-ZJAI-66-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261026-0019','2026-10-26','2.130','2026-10-26','17:40:40','PLG0017993','850000','850000','0','850000','0','kasirbip','2026-10-26 17:40:39','FJ-261026-0019','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0019','2026-10-26','17:40:40','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-261026-0018','2026-10-26','2026-10-26 17:40:39','PENJUALAN : FJ-261026-0019','.','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261026-0019','D','2026-10-26','17:40:40','TBC','PENJUALAN','FJ-261026-0019','30005053964','850000','30005903964','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-261026-0019' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0020','kasir','1',' 800K-225-1','TOKO','MMPER','PMM-ZIBE-11-0','CINCIN SILVER 925','','3.270','1','100.00','334000','0','0','17800','800000','0','0','0','800000','ALIKA','00047591','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZIBE-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.270',berat_jual_asli=berat_jual_asli+'3.270',stock_jual='1',berat_akhir=berat_akhir-'3.270',berat_akhir_asli=berat_akhir_asli-'3.270',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PMM-ZIBE-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261026-0020','2026-10-26','3.270','2026-10-26','17:42:40','PLG0017994','800000','800000','0','800000','0','kasir','2026-10-26 17:42:40','FJ-261026-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-10-26','FJ-261026-0020','2026-10-26','17:42:40','ALIKA','800000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261026-0019','2026-10-26','2026-10-26 17:42:40','PENJUALAN : FJ-261026-0020','.','TBC','800000','800000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261026-0020','D','2026-10-26','17:42:40','TBC','PENJUALAN','FJ-261026-0020','30005903964','800000','30006703964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-261026-0020' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0021','kasirbip','1',' 950K-11-00','TOKO','DUPERBDG','LXPER-ZEAB-30-0','CINCIN SILVER 925 ','','3.190','1','100.00','326000','0','0','17800','1050000','0','0','0','1050000','PUT','00043497','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEAB-30-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='LXPER-ZEAB-30-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-261026-0021','2026-10-26','3.190','2026-10-26','17:59:30','PLG0017995','1050000','1050000','0','1050000','0','kasirbip','2026-10-26 17:59:29','FJ-261026-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-10-26','FJ-261026-0021','2026-10-26','17:59:30','PUT','1050000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261026-0020','2026-10-26','2026-10-26 17:59:29','PENJUALAN : FJ-261026-0021','.','TBC','1050000','1050000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261026-0021','D','2026-10-26','17:59:30','TBC','PENJUALAN','FJ-261026-0021','30006703964','1050000','30007753964','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='1050000' WHERE no_faktur_jual='FJ-261026-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-261026-0022','kasirbip',' 1',' 800K-225-0','TOKO','DUPERBDG','LXPER-ZJBA-15-0','CINCIN SILVER 925 ','','3.800','1','100.00','388000','0','0','17800','950000','0','0','0','950000','PUT','00048445','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJBA-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.800',berat_jual_asli=berat_jual_asli+'3.800',stock_jual='1',berat_akhir=berat_akhir-'3.800',berat_akhir_asli=berat_akhir_asli-'3.800',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='LXPER-ZJBA-15-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-261026-0022','2026-10-26','3.800','2026-10-26','17:59:30','PLG0017996','950000','950000','0','950000','0','kasirbip','2026-10-26 17:59:29','FJ-261026-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-10-26','FJ-261026-0022','2026-10-26','17:59:30','PUT','950000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261026-0021','2026-10-26','2026-10-26 17:59:29','PENJUALAN : FJ-261026-0022','.','TBC','950000','950000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261026-0022','D','2026-10-26','17:59:30','TBC','PENJUALAN','FJ-261026-0022','30007753964','950000','30008703964','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='2000000' WHERE no_faktur_jual='FJ-261026-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-261026-0023','kasirbip','1',' 800K-11-00','TOKO','DUPERBDG','LXPER-ZFAH-31-0','CINCIN SILVER 925 ','','2.390','1','100.00','244000','0','0','17800','850000','0','0','0','850000','KUR','00044544','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAH-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='LXPER-ZFAH-31-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-261026-0023','2026-10-26','2.390','2026-10-26','18:00:42','PLG0017997','850000','850000','0','850000','0','kasirbip','2026-10-26 18:00:41','FJ-261026-0023','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0023','2026-10-26','18:00:42','KUR','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261026-0022','2026-10-26','2026-10-26 18:00:41','PENJUALAN : FJ-261026-0023','.','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-261026-0023','D','2026-10-26','18:00:42','TBC','PENJUALAN','FJ-261026-0023','30008703964','850000','30009553964','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-261026-0023' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0024','kasirbip',' 1',' 500K-255-0','TOKO','DUPERBDG','LXPER-ZJAI-11-0','CINCIN SILVER 925 ','','2.290','1','100.00','234000','0','0','17800','550000','0','0','0','550000','KUR','00048255','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJAI-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.290',berat_jual_asli=berat_jual_asli+'2.290',stock_jual='1',berat_akhir=berat_akhir-'2.290',berat_akhir_asli=berat_akhir_asli-'2.290',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='LXPER-ZJAI-11-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-261026-0024','2026-10-26','2.290','2026-10-26','18:00:42','PLG0017998','550000','550000','0','550000','0','kasirbip','2026-10-26 18:00:41','FJ-261026-0023','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0024','2026-10-26','18:00:42','KUR','550000','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-261026-0023','2026-10-26','2026-10-26 18:00:41','PENJUALAN : FJ-261026-0024','.','TBC','550000','550000','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-261026-0024','D','2026-10-26','18:00:42','TBC','PENJUALAN','FJ-261026-0024','30009553964','550000','30010103964','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='1400000' WHERE no_faktur_jual='FJ-261026-0024' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0025','kasirbip','1',' DP-04272BI','TOKO','BIPPSN','PSPRT-ZJAF-11-0','CINCIN PERAK YL01 ','','1.960','1','100.00','200000','0','0','17800','600000','0','0','0','600000','SULIS','00048208','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAF-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJAF-11-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-261026-0025','2026-10-26','1.960','2026-10-26','18:04:35','PLG0017999','600000','600000','0','600000','0','kasirbip','2026-10-26 18:04:34','FJ-261026-0025','DP-04272','600000'); 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-10-26','FJ-261026-0025','2026-10-26','18:04:35','SULIS','600000','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-261026-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-261026-0026','kasirbip',' 1',' DP-04271BI','TOKO','BIPPSN','PSPRT-ZJBC-29-0','CINCIN PERAK ','','2.080','1','100.00','213000','0','0','17800','950000','0','0','0','950000','SULIS','00048549','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBC-29-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-261026-0026','2026-10-26','2.080','2026-10-26','18:04:35','PLG0018000','950000','950000','0','950000','0','kasirbip','2026-10-26 18:04:34','FJ-261026-0025','DP-04271','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0026','2026-10-26','18:04:35','SULIS','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261026-0026' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0021'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0023'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0024'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0025' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0025' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0025'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0026' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0026' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0026'; 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-04828','ADL','1','PER','WEDDINGRING','','','4.000','','925.00','2','100000','0','1400000','0','1400000','sz cwe 12 sz cwo 17','gf Berksbire : Syarif...Esa 25.12.26','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0024','2026-10-26','2026-10-26 18:40:29','PESANAN : DP-04828','-','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-261026-0025','D','2026-10-26','18:40:29','TBC','PESANAN','DP-04828','30010103964','1400000','30011503964','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-04828','2026-10-26','2026-10-26','18:40:29','PLG0018001','ADL','2026-11-17','jogja','2026-10-26 18:40:29','4.000','0','0','0','1400000','0','0','1400000','1400000','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-261026-0027','kasir','1',' DP-04276MM','TOKO','MMPSN','PSGT-ZJAC-5-0','CINCIN EMAS ','','2.160','1','57.00','2889000','0','0','17800','4878000','0','0','0','4878000','ALIKA','00048118','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAC-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSGT-ZJAC-5-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-261026-0027','2026-10-26','2.160','2026-10-26','18:50:17','PLG0018002','4878000','4878000','0','4878000','0','kasir','2026-10-26 18:50:17','FJ-261026-0027','DP-04276','3960000'); 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-10-26','FJ-261026-0027','2026-10-26','18:50:17','ALIKA','4878000','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-261026-0025','2026-10-26','2026-10-26 18:50:17','PENJUALAN : FJ-261026-0027','.','TBC','918000','918000','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-261026-0026','D','2026-10-26','18:50:17','TBC','PENJUALAN','FJ-261026-0027','30011503964','918000','30012421964','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='918000' WHERE no_faktur_jual='FJ-261026-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-261026-0028','sby','1',' DP-04399SB','TOKO','SBYPSN','PSPRT-ZJBC-43-0','CINCIN PERAK ','','1.800','1','100.00','184000','0','0','17800','900000','0','0','0','900000','ARA','00048563','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBC-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBC-43-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-261026-0028','2026-10-26','1.800','2026-10-26','18:55:28','PLG0018003','900000','900000','0','900000','0','sby','2026-10-26 18:55:27','FJ-261026-0028','DP-04399','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0028','2026-10-26','18:55:28','ARA','900000','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-261026-0028' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0029','sby',' 1',' DP-04400SB','TOKO','SBYPSN','PSPRT-ZJBD-23-0','CINCIN PERAK ','','3.320','1','100.00','339000','0','0','17800','800000','0','0','0','800000','ARA','00048598','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBD-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.320',berat_jual_asli=berat_jual_asli+'3.320',stock_jual='1',berat_akhir=berat_akhir-'3.320',berat_akhir_asli=berat_akhir_asli-'3.320',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBD-23-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-261026-0029','2026-10-26','3.320','2026-10-26','18:55:28','PLG0018004','800000','800000','0','800000','0','sby','2026-10-26 18:55:27','FJ-261026-0028','DP-04400','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-10-26','FJ-261026-0029','2026-10-26','18:55:28','ARA','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-261026-0029' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0030','sby','1',' DP-04295SB','TOKO','SBYPSN','PSPRT-ZJBA-26-0','CINCIN PERAK ','','2.840','1','100.00','290000','0','0','17800','850000','0','0','0','850000','ARA','00048456','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBA-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.840',berat_jual_asli=berat_jual_asli+'2.840',stock_jual='1',berat_akhir=berat_akhir-'2.840',berat_akhir_asli=berat_akhir_asli-'2.840',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBA-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261026-0030','2026-10-26','2.840','2026-10-26','18:58:31','PLG0018005','850000','850000','0','850000','0','sby','2026-10-26 18:58:31','FJ-261026-0030','DP-04295','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-10-26','FJ-261026-0030','2026-10-26','18:58:31','ARA','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-261026-0030' 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-261026-0031','sby',' 1',' DP-04296SB','TOKO','SBYPSN','PSPRT-ZJBX-82-0','CINCIN PERAK ','','4.850','1','100.00','496000','0','0','17800','900000','0','0','0','900000','ARA','00048415','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBX-82-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.850',berat_jual_asli=berat_jual_asli+'4.850',stock_jual='1',berat_akhir=berat_akhir-'4.850',berat_akhir_asli=berat_akhir_asli-'4.850',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSPRT-ZJBX-82-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-261026-0031','2026-10-26','4.850','2026-10-26','18:58:31','PLG0018006','900000','900000','0','900000','0','sby','2026-10-26 18:58:31','FJ-261026-0030','DP-04296','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0031','2026-10-26','18:58:31','ARA','900000','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-261026-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-261026-0032','kasirbip','1',' DP-04426DU','TOKO','DUPSN','PSGT-ZJBC-34-0','CINCIN EMAS ','','2.720','1','57.00','3638000','0','0','17800','5986000','0','0','0','5986000','PUT','00048554','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBC-34-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-10-26' AND kode_barang='PSGT-ZJBC-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261026-0032','2026-10-26','2.720','2026-10-26','19:11:59','PLG0018007','5986000','5986000','0','5986000','0','kasirbip','2026-10-26 19:11:58','FJ-261026-0032','DP-04426','5912000'); 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-10-26','FJ-261026-0032','2026-10-26','19:11:59','PUT','5986000','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-261026-0026','2026-10-26','2026-10-26 19:11:58','PENJUALAN : FJ-261026-0032','.','TBC','74000','74000','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-261026-0027','D','2026-10-26','19:11:59','TBC','PENJUALAN','FJ-261026-0032','30012421964','74000','30012495964','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='74000' WHERE no_faktur_jual='FJ-261026-0032' LIMIT 1; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-26', status ='CLOS' WHERE no_service='SV-02291'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02291'; 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-04829','KUR','1','PER','CINCIN KAWIN','','','3.000','','925.00','1','100000','0','850000','0','850000','cewe 12 grf Sandi sirkon 1','cowo 18 grf Zia YL-01','font brush script','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0027','2026-10-26','2026-10-26 19:25:26','PESANAN : DP-04829','.','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-261026-0028','D','2026-10-26','19:25:26','TBC','PESANAN','DP-04829','30012495964','850000','30013345964','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-04829','2026-10-26','2026-10-26','19:25:26','PLG0018008','KUR','2026-11-17','kasirbip','2026-10-26 19:25:26','3.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04830','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','1500000','0','1500000','sz cwe 12.5 grf Ayah . A.R ....','sz cwo 21 grf Bunda . AST','font Berkshire CP.04 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-261026-0028','2026-10-26','2026-10-26 19:33:07','PESANAN : DP-04830','.','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-261026-0029','D','2026-10-26','19:33:07','TBC','PESANAN','DP-04830','30013345964','1500000','30014845964','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-04830','2026-10-26','2026-10-26','19:33:07','PLG0018009','PUT','2026-11-03','kasirbip','2026-10-26 19:33:07','4.000','0','0','0','1500000','0','0','1500000','1500000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-26 ','19:36:54'); 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-04831','KUR','1','PER','WEDRING','','','3.500','','925.00','1','100000','0','950000','0','950000','sz cwe 10 crom putih doff semprot','grf Noval font Berkshire','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261026-0029','2026-10-26','2026-10-26 19:48:43','PESANAN : DP-04831','.','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-261026-0030','D','2026-10-26','19:48:43','TBC','PESANAN','DP-04831','30014845964','950000','30015795964','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-04831','2026-10-26','2026-10-26','19:48:43','PLG0018010','KUR','2026-11-20','kasirbip','2026-10-26 19:48:43','3.500','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04832','KUR','1','PER','WEDRING','','','3.500','','925.00','1','100000','0','950000','0','950000','sz cwo 15.5 crom putih doff semprot','grf Aprilia font Berkshire','mata di hilangkan','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-261026-0030','2026-10-26','2026-10-26 19:50:22','PESANAN : DP-04832','.','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-261026-0031','D','2026-10-26','19:50:22','TBC','PESANAN','DP-04832','30015795964','950000','30016745964','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-04832','2026-10-26','2026-10-26','19:50:22','PLG0018011','KUR','2026-11-20','kasirbip','2026-10-26 19:50:22','3.500','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0033','kasir','1',' 750K-85 ','TOKO','MMCM','CMMM-ZJBD-4-0','CINCIN MAS SR02 ','','1.610','1','45.00','1700000','0','0','17800','3004000','0','0','0','3004000','ALIKA','00048579','CMMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMMM-ZJBD-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='CMMM-ZJBD-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMCM' 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-261026-0033','2026-10-26','1.610','2026-10-26','20:02:02','PLG0018012','3004000','3004000','0','3004000','0','kasir','2026-10-26 20:02:02','FJ-261026-0033','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-26','FJ-261026-0033','2026-10-26','20:02:02','ALIKA','3004000','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-261026-0031','2026-10-26','2026-10-26 20:02:02','PENJUALAN : FJ-261026-0033','.','TBC','3004000','3004000','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-261026-0032','D','2026-10-26','20:02:02','TBC','PENJUALAN','FJ-261026-0033','30016745964','3004000','30019749964','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='3004000' WHERE no_faktur_jual='FJ-261026-0033' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0034','sby','1',' DP-04468SB','TOKO','SBYPSN','PSGT-ZJBC-39-0','CINCIN EMAS ','','3.800','1','45.00','4012000','0','0','17800','6130000','0','0','0','6130000','DIL','00048559','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBC-39-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.800',berat_jual_asli=berat_jual_asli+'3.800',stock_jual='1',berat_akhir=berat_akhir-'3.800',berat_akhir_asli=berat_akhir_asli-'3.800',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSGT-ZJBC-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261026-0034','2026-10-26','3.800','2026-10-26','20:39:45','PLG0018013','6130000','6130000','0','6130000','0','sby','2026-10-26 20:39:45','FJ-261026-0034','DP-04468','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-10-26','FJ-261026-0034','2026-10-26','20:39:45','DIL','6130000','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-261026-0032','2026-10-26','2026-10-26 20:39:45','PENJUALAN : FJ-261026-0034','','TBC','2830000','2830000','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-261026-0033','D','2026-10-26','20:39:45','TBC','PENJUALAN','FJ-261026-0034','30019749964','2830000','30022579964','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='2830000' WHERE no_faktur_jual='FJ-261026-0034' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261026-0035','sby',' 1',' DP-04469SB','TOKO','SBYPSN','PSGT-ZJBC-40-0','CINCIN EMAS ','','3.120','1','45.00','3295000','0','0','17800','5588000','0','0','0','5588000','DIL','00048560','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBC-40-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='PSGT-ZJBC-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261026-0035','2026-10-26','3.120','2026-10-26','20:39:45','PLG0018014','5588000','5588000','0','5588000','0','sby','2026-10-26 20:39:45','FJ-261026-0034','DP-04469','2700000'); 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-10-26','FJ-261026-0035','2026-10-26','20:39:45','DIL','5588000','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-261026-0033','2026-10-26','2026-10-26 20:39:45','PENJUALAN : FJ-261026-0035','','TBC','2888000','2888000','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-261026-0034','D','2026-10-26','20:39:45','TBC','PENJUALAN','FJ-261026-0035','30022579964','2888000','30025467964','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='5718000' WHERE no_faktur_jual='FJ-261026-0035' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0027' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0027' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0027'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0028' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0028' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0028'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0029' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0029' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0029'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0030' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0030' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0030'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0032' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0032' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0032'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0033' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0033' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0033'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0034' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0034' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0034'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0035' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261026-0035' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261026-0035'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-27','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-26'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-26'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-26'; 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-10-26' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-26'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-26'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-26'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-26'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-27' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-26' 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-261027-0001','D','2026-10-27','21:10:18','TBC','SALDO AWAL','SALDO AWAL','0','30025467964','30025467964'); 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-261027-0001','D','2026-10-27','21:10:18','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); 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-261027-0001','D','2026-10-27','21:10:18','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); 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-261027-0001','D','2026-10-27','21:10:18','BCD','SALDO AWAL','SALDO AWAL','0','1465961500','1465961500'); 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-261027-0001','D','2026-10-27','21:10:18','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000'); 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-261027-0001','D','2026-10-27','21:10:18','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-261027-0001','D','2026-10-27','21:10:18','','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-261027-0001','D','2026-10-27','21:10:18','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-261027-0001','D','2026-10-27','21:10:18','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-261027-0001','D','2026-10-27','21:10:18','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-261027-0001','D','2026-10-27','21:10:18','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-261027-0001','D','2026-10-27','21:10:18','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); UPDATE tp_system SET tgl_system='2026-10-27';