INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-11-01 ','09:41:55'); 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-261101-0001','jogja','1',' DP-04513JO','TOKO','JOGPSN','PSPRT-ZJBH-22-0','CINCIN PERAK CP08 ','','3.290','1','100.00','336000','0','0','17800','1600000','0','0','0','1600000','ADL','00048723','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBH-22-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.290',berat_jual_asli=berat_jual_asli+'3.290',stock_jual='1',berat_akhir=berat_akhir-'3.290',berat_akhir_asli=berat_akhir_asli-'3.290',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJBH-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-261101-0001','2026-11-01','3.290','2026-11-01','09:42:43','PLG0018248','1600000','1600000','0','1600000','0','jogja','2026-11-01 09:42:42','FJ-261101-0001','DP-04513','1600000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0001','2026-11-01','09:42:43','ADL','1600000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261101-0001' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-01 ','10:04:52'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-01 ','10:15:53'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-01 ','10:51:12'); 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-261101-0002','sby','1',' DP-04478SB','TOKO','SBYPSN','PSPRT-ZJBI-13-0','CINCIN PERAK ','','1.450','1','100.00','148000','0','0','17800','950000','0','0','0','950000','ARA','00048739','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBI-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJBI-13-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-261101-0002','2026-11-01','1.450','2026-11-01','10:53:21','PLG0018249','950000','950000','0','950000','0','sby','2026-11-01 10:53:20','FJ-261101-0002','DP-04478','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-11-01','FJ-261101-0002','2026-11-01','10:53:21','ARA','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-261101-0002' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0003','sby',' 1',' DP-04479SB','TOKO','SBYPSN','PSPRT-ZJBG-41-0','CINCIN PERAK ','','3.280','1','100.00','335000','0','0','17800','900000','0','0','0','900000','ARA','00048695','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-41-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.280',berat_jual_asli=berat_jual_asli+'3.280',stock_jual='1',berat_akhir=berat_akhir-'3.280',berat_akhir_asli=berat_akhir_asli-'3.280',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJBG-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261101-0003','2026-11-01','3.280','2026-11-01','10:53:21','PLG0018250','900000','900000','0','900000','0','sby','2026-11-01 10:53:20','FJ-261101-0002','DP-04479','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-11-01','FJ-261101-0003','2026-11-01','10:53:21','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-261101-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-04916','PUT','1','PER','WEDDRING','','','3.500','','925.00','1','100000','0','950000','0','950000','sz cwe 12.5 SR.03 grf Andre ....','sz cwo 13 YL.01 grf Fitri ....','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-261101-0001','2026-11-01','2026-11-01 10:55:55','PESANAN : DP-04916','.','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-261101-0002','D','2026-11-01','10:55:55','TBC','PESANAN','DP-04916','30244028464','950000','30244978464','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-04916','2026-11-01','2026-11-01','10:55:55','PLG0018251','PUT','2026-11-27','kasirbip','2026-11-01 10:55:55','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-261101-0004','sby','1',' DP-04364SB','TOKO','SBYPSN','PSGT-ZJBH-12-0','CINCIN EMAS ','','3.300','1','57.00','4356000','0','0','17800','7970000','0','0','0','7970000','ARA','00048713','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBH-12-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.300',berat_jual_asli=berat_jual_asli+'3.300',stock_jual='1',berat_akhir=berat_akhir-'3.300',berat_akhir_asli=berat_akhir_asli-'3.300',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSGT-ZJBH-12-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-261101-0004','2026-11-01','3.300','2026-11-01','11:08:10','PLG0018252','7970000','7970000','0','7970000','0','sby','2026-11-01 11:08:09','FJ-261101-0004','DP-04364','5800000'); 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-11-01','FJ-261101-0004','2026-11-01','11:08:10','ARA','7970000','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-261101-0002','2026-11-01','2026-11-01 11:08:09','PENJUALAN : FJ-261101-0004','','TBC','2170000','2170000','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-261101-0003','D','2026-11-01','11:08:10','TBC','PENJUALAN','FJ-261101-0004','30244978464','2170000','30247148464','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='2170000' WHERE no_faktur_jual='FJ-261101-0004' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-01 ','11:11:19'); 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-261101-0005','kasirbip','1',' DP-04615BI','TOKO','BIPPSN','PSPRT-ZJBG-34-0','CINCIN PERAK ','','2.210','1','100.00','226000','0','0','17800','950000','0','0','0','950000','SAL','00048688','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJBG-34-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-261101-0005','2026-11-01','2.210','2026-11-01','11:22:23','PLG0018253','950000','950000','0','950000','0','kasirbip','2026-11-01 11:22:22','FJ-261101-0005','DP-04615','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-11-01','FJ-261101-0005','2026-11-01','11:22:23','SAL','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261101-0005' 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-04917','ARA','1','PER','WEDDING RING PRIA','','','3.000','','92.50','1','100000','0','900000','0','900000','Size 15','Font : Brush GRf : Sulis ??','Finishing : Putih glosy mix doff','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0003','2026-11-01','2026-11-01 11:28:53','PESANAN : DP-04917','-','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-261101-0004','D','2026-11-01','11:28:53','TBC','PESANAN','DP-04917','30247148464','900000','30248048464','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-04917','2026-11-01','2026-11-01','11:28:53','PLG0018254','ARA','2026-11-24','sby','2026-11-01 11:28:53','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04918','ARA','1','PER','WEDDING RING WANITA','','','3.000','','92.50','1','100000','0','900000','0','900000','Size 15','Font : Brush GRF: Asrul ??','Finishing : Putih glosy','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-261101-0004','2026-11-01','2026-11-01 11:32:56','PESANAN : DP-04918','-','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-261101-0005','D','2026-11-01','11:32:56','TBC','PESANAN','DP-04918','30248048464','900000','30248948464','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-04918','2026-11-01','2026-11-01','11:32:56','PLG0018255','ARA','2026-11-24','sby','2026-11-01 11:32:56','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04919','PUT','1','PER','WEDDRING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz cwe 13 crom putih glosy','grf Rudi font Brush','','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-261101-0005','2026-11-01','2026-11-01 11:33:48','PESANAN : DP-04919','.','TBC','1000000','1000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0006','D','2026-11-01','11:33:48','TBC','PESANAN','DP-04919','30248948464','1000000','30249948464','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-04919','2026-11-01','2026-11-01','11:33:48','PLG0018256','PUT','2026-12-03','kasirbip','2026-11-01 11:33:48','2.000','0','0','0','1000000','0','0','1000000','1000000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04920','PUT','1','PER','WEDDRING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz cwo 19 crom putih doff semprot','grf Yayuk font Brush','lebar di buat 4 mili','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-261101-0006','2026-11-01','2026-11-01 11:36:15','PESANAN : DP-04920','.','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-261101-0007','D','2026-11-01','11:36:15','TBC','PESANAN','DP-04920','30249948464','900000','30250848464','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-04920','2026-11-01','2026-11-01','11:36:15','PLG0018257','PUT','2026-12-03','kasirbip','2026-11-01 11:36:15','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04921','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwe 18 crom putih glosy','grf Rizki Azis font vintage','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0007','2026-11-01','2026-11-01 11:42:20','PESANAN : DP-04921','.','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-261101-0008','D','2026-11-01','11:42:20','TBC','PESANAN','DP-04921','30250848464','950000','30251798464','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-04921','2026-11-01','2026-11-01','11:42:20','PLG0018258','MIL','2026-12-03','kasirbip','2026-11-01 11:42:20','3.000','0','0','0','950000','0','0','950000','950000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0005'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0006','jogja','1',' DP-04475JO','TOKO','JOGPSN','PSPRT-ZJBG-45-0','CINCIN PERAK YL01 ','','3.370','1','100.00','344000','0','0','17800','850000','0','0','0','850000','ADL','00048699','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-45-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.370',berat_jual_asli=berat_jual_asli+'3.370',stock_jual='1',berat_akhir=berat_akhir-'3.370',berat_akhir_asli=berat_akhir_asli-'3.370',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJBG-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' 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-261101-0006','2026-11-01','3.370','2026-11-01','11:43:05','PLG0018259','850000','850000','0','850000','0','jogja','2026-11-01 11:43:04','FJ-261101-0006','DP-04475','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-11-01','FJ-261101-0006','2026-11-01','11:43:05','ADL','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-261101-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-261101-0007','sby','1',' 800K-20-00','TOKO','SBYPER','PSBY-ZJCX-14-0','CINCIN SILVER 925 ','','3.800','1','100.00','388000','0','0','17800','900000','0','0','0','900000','ARA','00048778','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJCX-14-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-11-01' AND kode_barang='PSBY-ZJCX-14-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-261101-0007','2026-11-01','3.800','2026-11-01','11:45:38','PLG0018260','900000','900000','0','900000','0','sby','2026-11-01 11:45:37','FJ-261101-0007','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0007','2026-11-01','11:45:38','ARA','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-261101-0008','2026-11-01','2026-11-01 11:45:37','PENJUALAN : FJ-261101-0007','','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-261101-0009','D','2026-11-01','11:45:38','TBC','PENJUALAN','FJ-261101-0007','30251798464','900000','30252698464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261101-0007' 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-04922','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cwo 17 putih glosy','grf Anggi Tria S','','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-261101-0009','2026-11-01','2026-11-01 11:45:47','PESANAN : DP-04922','.','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-261101-0010','D','2026-11-01','11:45:47','TBC','PESANAN','DP-04922','30252698464','850000','30253548464','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-04922','2026-11-01','2026-11-01','11:45:47','PLG0018261','MIL','2026-12-03','kasirbip','2026-11-01 11:45:47','3.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-01 ','11:45: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-04923','KUR','1','PLD','WED RING','','','5.000','','25.00','1','1200000','550000','0','800000','3550000','sz 13.5 putih doff amplas','font berkshire swash grf Eka Kurniawati','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0010','2026-11-01','2026-11-01 12:10:33','PESANAN : DP-04923','.','TBC','2840000','2840000'); 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-261101-0011','D','2026-11-01','12:10:33','TBC','PESANAN','DP-04923','30253548464','2840000','30256388464','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-04923','2026-11-01','2026-11-01','12:10:33','PLG0018262','KUR','2026-11-25','kasirbip','2026-11-01 12:10:33','5.000','0','0','0','2840000','0','800000','3550000','3550000','710000'); 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-04924','KUR','1','PLD','WED RING','','','2.500','','25.00','1','1200000','550000','0','900000','2275000','sz 11 putih glossy','21 zirkon','font berkshire swash grf Ronny D. S','0','210000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0011','2026-11-01','2026-11-01 12:12:16','PESANAN : DP-04924','.','TBC','1980000','1980000'); 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-261101-0012','D','2026-11-01','12:12:16','TBC','PESANAN','DP-04924','30256388464','1980000','30258368464','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-04924','2026-11-01','2026-11-01','12:12:16','PLG0018263','KUR','2026-12-25','kasirbip','2026-11-01 12:12:16','2.500','0','0','0','1980000','0','900000','2485000','2485000','505000'); 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-261101-0008','sby','1',' 800K-13-00','TOKO','SBYPER','PSBY-ZEXE-83-0','CINCIN SILVER 925 ','','2.780','1','100.00','284000','0','0','17800','900000','0','0','0','900000','ARA','00043279','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-83-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSBY-ZEXE-83-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-261101-0008','2026-11-01','2.780','2026-11-01','12:16:26','PLG0018264','900000','900000','0','900000','0','sby','2026-11-01 12:16:26','FJ-261101-0008','','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-11-01','FJ-261101-0008','2026-11-01','12:16:26','ARA','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-261101-0012','2026-11-01','2026-11-01 12:16:26','PENJUALAN : FJ-261101-0008','','TBC','900000','900000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0013','D','2026-11-01','12:16:26','TBC','PENJUALAN','FJ-261101-0008','30258368464','900000','30259268464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261101-0008' 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-04925','PUT','1','PER','WEDRING','','','4.500','','925.00','1','100000','0','950000','0','950000','sz 26 crom putih doff semprot','grf 26.12.26 font Yeseva','lebar ring di buat 6 mili','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-261101-0013','2026-11-01','2026-11-01 12:42:51','PESANAN : DP-04925','.','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-261101-0014','D','2026-11-01','12:42:51','TBC','PESANAN','DP-04925','30259268464','950000','30260218464','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-04925','2026-11-01','2026-11-01','12:42:51','PLG0018265','PUT','2026-12-03','kasirbip','2026-11-01 12:42:51','4.500','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-01 ','12:50:00'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0009','kasir','1',' 1.0K-12-10','TOKO','MMPER','PMM-ZFXH-63-0','CINCIN SILVER 925 ','','2.510','1','100.00','257000','0','0','17800','1150000','0','0','0','1150000','ALIKA','00044076','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZFXH-63-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.510',berat_jual_asli=berat_jual_asli+'2.510',stock_jual='1',berat_akhir=berat_akhir-'2.510',berat_akhir_asli=berat_akhir_asli-'2.510',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PMM-ZFXH-63-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-261101-0009','2026-11-01','2.510','2026-11-01','12:52:11','PLG0018266','1150000','1150000','0','1150000','0','kasir','2026-11-01 12:52:10','FJ-261101-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0009','2026-11-01','12:52:11','ALIKA','1150000','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-261101-0014','2026-11-01','2026-11-01 12:52:10','PENJUALAN : FJ-261101-0009','0','TBC','1150000','1150000','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-261101-0015','D','2026-11-01','12:52:11','TBC','PENJUALAN','FJ-261101-0009','30260218464','1150000','30261368464','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='1150000' WHERE no_faktur_jual='FJ-261101-0009' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04926','MIL','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','sz cwo 18 crom putih glosy doff semprot','grf 15.05.2027 font arial','','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-261101-0015','2026-11-01','2026-11-01 12:52:26','PESANAN : DP-04926','.','TBC','1480000','1480000'); 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-261101-0016','D','2026-11-01','12:52:26','TBC','PESANAN','DP-04926','30261368464','1480000','30262848464','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-04926','2026-11-01','2026-11-01','12:52:26','PLG0018267','MIL','2026-12-03','kasirbip','2026-11-01 12:52:26','3.000','0','0','0','1480000','0','800000','1850000','1850000','370000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04927','ALIKA','1','PER','WEDDING RING','','','3.000','','925.00','1','100000','0','0','0','900000','size 17 grf Salsa','warna crom putih doff semprot sesuai model','tanpa permata','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0016','2026-11-01','2026-11-01 12:55:31','PESANAN : DP-04927','0','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-261101-0017','D','2026-11-01','12:55:31','TBC','PESANAN','DP-04927','30262848464','900000','30263748464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04927','2026-11-01','2026-11-01','12:55:31','PLG0018268','ALIKA','2026-11-26','kasir','2026-11-01 12:55:31','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04928','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz 10 putih glossy 23 zirkon','font vintage rotter grf Rafli','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0017','2026-11-01','2026-11-01 12:55:46','PESANAN : DP-04928','.','TBC','1000000','1000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0018','D','2026-11-01','12:55:46','TBC','PESANAN','DP-04928','30263748464','1000000','30264748464','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-04928','2026-11-01','2026-11-01','12:55:46','PLG0018269','SAL','2026-11-25','kasirbip','2026-11-01 12:55:46','2.000','0','0','0','1000000','0','0','1000000','1000000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04929','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 27.5 putih doff amplas','font vintage rotter grf Rizkya','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0018','2026-11-01','2026-11-01 12:56:52','PESANAN : DP-04929','.','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-261101-0019','D','2026-11-01','12:56:52','TBC','PESANAN','DP-04929','30264748464','900000','30265648464','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-04929','2026-11-01','2026-11-01','12:56:52','PLG0018270','SAL','2026-11-25','kasirbip','2026-11-01 12:56:52','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04930','MIL','1','PLD','WEDRING','','','2.500','','25.00','1','1200000','550000','0','850000','2225000','sz cwe 14.5','grf 15.05.2027 font arial','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-261101-0019','2026-11-01','2026-11-01 12:58:41','PESANAN : DP-04930','.','TBC','1940000','1940000'); 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-261101-0020','D','2026-11-01','12:58:41','TBC','PESANAN','DP-04930','30265648464','1940000','30267588464','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-04930','2026-11-01','2026-11-01','12:58:41','PLG0018271','MIL','2026-12-03','kasirbip','2026-11-01 12:58:41','2.500','0','0','0','1940000','0','850000','2425000','2425000','485000'); 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-04931','DEW','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','1600000','0','1600000','sz cwe 11 sz cwo 18','Gf vintage : cwe Surya..Shafira cwe : Shafira..Surya','','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-261101-0020','2026-11-01','2026-11-01 13:09:07','PESANAN : DP-04931','-','TBC','1600000','1600000'); 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-261101-0021','D','2026-11-01','13:09:07','TBC','PESANAN','DP-04931','30267588464','1600000','30269188464','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-04931','2026-11-01','2026-11-01','13:09:07','PLG0018272','DEW','2026-11-25','jogja','2026-11-01 13:09:07','4.000','0','0','0','1600000','0','0','1600000','1600000','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-04932','KUR','1','PLD','WED RING','','','2.500','','10.00','1','1200000','350000','0','850000','1725000','sz 12 putih glossy 14 zirkon','font berkshire swash grf Fajar','','140000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0021','2026-11-01','2026-11-01 13:11:12','PESANAN : DP-04932','.','TBC','1490000','1490000'); 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-261101-0022','D','2026-11-01','13:11:12','TBC','PESANAN','DP-04932','30269188464','1490000','30270678464','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-04932','2026-11-01','2026-11-01','13:11:12','PLG0018273','KUR','2026-11-30','kasirbip','2026-11-01 13:11:12','2.500','0','0','0','1490000','0','850000','1865000','1865000','375000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-01 ','13:18:12'); 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-261101-0010','sby','1',' DP-04410SB','TOKO','SBYPSN','PSPLT-ZJBF-21-0','CINCIN PALADIUM ','','3.710','1','32.00','1568000','0','0','17800','2740000','0','0','0','2740000','VAN','00048631','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBF-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.710',berat_jual_asli=berat_jual_asli+'3.710',stock_jual='1',berat_akhir=berat_akhir-'3.710',berat_akhir_asli=berat_akhir_asli-'3.710',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPLT-ZJBF-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261101-0010','2026-11-01','3.710','2026-11-01','13:18:20','PLG0018274','2740000','2740000','0','2740000','0','sby','2026-11-01 13:18:20','FJ-261101-0010','DP-04410','2000000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0010','2026-11-01','13:18:20','VAN','2740000','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-261101-0022','2026-11-01','2026-11-01 13:18:20','PENJUALAN : FJ-261101-0010','','TBC','740000','740000','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-261101-0023','D','2026-11-01','13:18:20','TBC','PENJUALAN','FJ-261101-0010','30270678464','740000','30271418464','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='740000' WHERE no_faktur_jual='FJ-261101-0010' 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-11-01', status ='CLOS' WHERE no_service='SV-02298'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02298'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-01 ','13:21:53'); 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-261101-0011','kasir','1',' TFAMR75-82','TOKO','TFAMP','TFAMR-ZJBX-35-0','THIFA ANTING MAS RG ','','1.110','1','82.00','2089000','0','0','17800','2200000','0','0','0','2200000','IQB','00048368','TFAMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFAMR-ZJBX-35-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='TFAMR-ZJBX-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFAMP' 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-261101-0011','2026-11-01','1.110','2026-11-01','13:22:56','PLG0018275','2200000','2200000','0','2200000','0','kasir','2026-11-01 13:22:56','FJ-261101-0011','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0011','2026-11-01','13:22:56','IQB','2200000','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-261101-0023','2026-11-01','2026-11-01 13:22:56','PENJUALAN : FJ-261101-0011','.','TBC','2200000','2200000','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-261101-0024','D','2026-11-01','13:22:56','TBC','PENJUALAN','FJ-261101-0011','30271418464','2200000','30273618464','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='2200000' WHERE no_faktur_jual='FJ-261101-0011' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0012','kasir','1',' TFAMP75-83','TOKO','TFAMP','TFAMP-YLXD-33-0','THIFA ANTING MAS PUTIH ','','0.580','1','83.00','1106000','0','0','17800','1150000','0','0','0','1150000','IQB','00040213','TFAMP','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFAMP-YLXD-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='TFAMP-YLXD-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFAMP' 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-261101-0012','2026-11-01','0.580','2026-11-01','13:24:20','PLG0018276','1150000','1150000','0','1150000','0','kasir','2026-11-01 13:24:19','FJ-261101-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-11-01','FJ-261101-0012','2026-11-01','13:24:20','IQB','1150000','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-261101-0024','2026-11-01','2026-11-01 13:24:19','PENJUALAN : FJ-261101-0012','.','TBC','1150000','1150000','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-261101-0025','D','2026-11-01','13:24:20','TBC','PENJUALAN','FJ-261101-0012','30273618464','1150000','30274768464','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='1150000' WHERE no_faktur_jual='FJ-261101-0012' 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-04933','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 17 putih glosy 1 zircon','font vintage rotter grf Sujadi','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0025','2026-11-01','2026-11-01 13:26:33','PESANAN : DP-04933','.','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-261101-0026','D','2026-11-01','13:26:33','TBC','PESANAN','DP-04933','30274768464','850000','30275618464','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-04933','2026-11-01','2026-11-01','13:26:33','PLG0018277','SULIS','2026-11-25','kasirbip','2026-11-01 13:26:33','2.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0013','kasir','1',' DP-04250MM','TOKO','MMPSN','PSPRT-ZJBD-27-0','CINCIN PERAK CP11 ','','3.990','1','100.00','407000','0','0','17800','1600000','0','0','0','1600000','ELLA','00048602','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBD-27-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.990',berat_jual_asli=berat_jual_asli+'3.990',stock_jual='1',berat_akhir=berat_akhir-'3.990',berat_akhir_asli=berat_akhir_asli-'3.990',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJBD-27-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-261101-0013','2026-11-01','3.990','2026-11-01','13:26:56','PLG0018278','1600000','1600000','0','1600000','0','kasir','2026-11-01 13:26:55','FJ-261101-0013','DP-04250','1600000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0013','2026-11-01','13:26:56','ELLA','1600000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261101-0013' 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-04934','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 18.5 putih doff semprot','font vintage rotter','grf Heny Rahmawati','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0026','2026-11-01','2026-11-01 13:28:25','PESANAN : DP-04934','.','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-261101-0027','D','2026-11-01','13:28:25','TBC','PESANAN','DP-04934','30275618464','850000','30276468464','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-04934','2026-11-01','2026-11-01','13:28:25','PLG0018279','SULIS','2026-11-25','kasirbip','2026-11-01 13:28:25','2.000','0','0','0','850000','0','0','850000','850000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0012'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0014','sby','1',' DP-04402SB','TOKO','SBYPSN','PSPLT-ZJBD-35-0','CINCIN PALADIUM ','','3.670','1','32.00','1551000','0','0','17800','2719000','0','0','0','2719000','ARA','00048610','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBD-35-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.670',berat_jual_asli=berat_jual_asli+'3.670',stock_jual='1',berat_akhir=berat_akhir-'3.670',berat_akhir_asli=berat_akhir_asli-'3.670',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPLT-ZJBD-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261101-0014','2026-11-01','3.670','2026-11-01','13:42:38','PLG0018280','2719000','2719000','0','2719000','0','sby','2026-11-01 13:42:38','FJ-261101-0014','DP-04402','2000000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0014','2026-11-01','13:42:38','ARA','2719000','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-261101-0027','2026-11-01','2026-11-01 13:42:38','PENJUALAN : FJ-261101-0014','','TBC','719000','719000','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-261101-0028','D','2026-11-01','13:42:38','TBC','PENJUALAN','FJ-261101-0014','30276468464','719000','30277187464','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='719000' WHERE no_faktur_jual='FJ-261101-0014' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04935','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','1 zircon putih doff semprot sz 22','font berkshire swash grf Novizal .... Silvi','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0028','2026-11-01','2026-11-01 13:45:15','PESANAN : DP-04935','.','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-261101-0029','D','2026-11-01','13:45:15','TBC','PESANAN','DP-04935','30277187464','900000','30278087464','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-04935','2026-11-01','2026-11-01','13:45:15','PLG0018281','SAL','2026-11-30','kasirbip','2026-11-01 13:45:15','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-04936','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','sz 13 putih glosy','font berkshire swash grf Novizal .... Silvi','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0029','2026-11-01','2026-11-01 13:47:14','PESANAN : DP-04936','.','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-261101-0030','D','2026-11-01','13:47:14','TBC','PESANAN','DP-04936','30278087464','950000','30279037464','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-04936','2026-11-01','2026-11-01','13:47:14','PLG0018282','SAL','2026-11-30','kasirbip','2026-11-01 13:47:14','2.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0015','kasirbip','1',' DP-04700DU','TOKO','DUPSN','PSPRT-ZJBG-29-0','CINCIN PERAK ','','2.820','1','100.00','288000','0','0','17800','950000','0','0','0','950000','MIL','00048683','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBG-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.820',berat_jual_asli=berat_jual_asli+'2.820',stock_jual='1',berat_akhir=berat_akhir-'2.820',berat_akhir_asli=berat_akhir_asli-'2.820',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJBG-29-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-261101-0015','2026-11-01','2.820','2026-11-01','13:52:21','PLG0018283','950000','950000','0','950000','0','kasirbip','2026-11-01 13:52:21','FJ-261101-0015','DP-04700','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-11-01','FJ-261101-0015','2026-11-01','13:52:21','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-261101-0015' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-01 ','14:02:45'); 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-04937','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','cwo YL-01 sz 13.5 grf mei .... dwiki','cwe SR-01 sz 9 grf dwiki .... mei','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0030','2026-11-01','2026-11-01 14:09:52','PESANAN : DP-04937','.','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-261101-0031','D','2026-11-01','14:09:52','TBC','PESANAN','DP-04937','30279037464','950000','30279987464','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-04937','2026-11-01','2026-11-01','14:09:52','PLG0018284','SULIS','2026-11-19','kasirbip','2026-11-01 14:09:52','2.000','0','0','0','950000','0','0','950000','950000','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-00000402','X-00000402','ANTING TFA-21015','GR','---','TFA','BELI','BELI001','9440000','2026-11-01','3.100','1','kasir','2026-11-01 14:18:57'); DELETE FROM tp_barang WHERE kode_dept = 'X-TFA'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFA','X-00000402','X-00000402'); 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-261101-0001','FJ-231116-0001','IQB','1','BELI','BELI001','TFA', 'X-00000402', 'ANTING TFA-21015','3.100','3.100','75.00','11800000','9440000','3045161','1','9440000','9440000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.100',berat_beli_asli=berat_beli_asli+'3.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.100',berat_akhir_asli=berat_akhir_asli+'3.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFA' 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-261101-0001','2026-11-01','2026-11-01','14:18:57','IQB','---','3.100','9440000','9440000','9440000','9440000','9440000','kasir','2026-11-01 14:18:57','FB-261101-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261101-0001','PUTU','-','','','-','kasir','2026-11-01 14:18:57'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0031','2026-11-01','2026-11-01 14:18:57','PEMBELIAN UMUM : FB-261101-0001','-','TBC','9440000','9440000'); 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-261101-0032','K','2026-11-01','14:18:57','TBC','PEMBELIAN UMUM','FB-261101-0001','30279987464','9440000','30270547464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261101-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261101-0001'; 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-04938','ELLA','1','PER','CINCIN PROMO SR03','','','3.000','','925.00','1','100000','0','0','0','950000','cwe size 17 grf Alfiyah zircone 1 butir','cwo size 28 grf Robby','warna crom putih keduanya sesuai model upsize 250k exp 100k','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-261101-0032','2026-11-01','2026-11-01 14:27:19','PESANAN : DP-04938','0','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-261101-0033','D','2026-11-01','14:27:19','TBC','PESANAN','DP-04938','30270547464','950000','30271497464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04938','2026-11-01','2026-11-01','14:27:19','PLG0018285','ELLA','2026-11-17','kasir','2026-11-01 14:27:19','3.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0016','kasir','1',' 800K-235-1','TOKO','MMPER','PMM-ZJAI-48-0','CINCIN SILVER 925 ','','2.880','1','100.00','294000','0','0','17800','900000','0','0','0','900000','ALIKA','00048292','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZJAI-48-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.880',berat_jual_asli=berat_jual_asli+'2.880',stock_jual='1',berat_akhir=berat_akhir-'2.880',berat_akhir_asli=berat_akhir_asli-'2.880',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PMM-ZJAI-48-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-261101-0016','2026-11-01','2.880','2026-11-01','14:51:16','PLG0018286','900000','900000','0','900000','0','kasir','2026-11-01 14:51:16','FJ-261101-0016','','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-11-01','FJ-261101-0016','2026-11-01','14:51:16','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-261101-0033','2026-11-01','2026-11-01 14:51:16','PENJUALAN : FJ-261101-0016','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-261101-0034','D','2026-11-01','14:51:16','TBC','PENJUALAN','FJ-261101-0016','30271497464','900000','30272397464','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-261101-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-261101-0017','kasir',' 1',' 900K-135-1','TOKO','MMPER','PMM-ZIBH-72-0','CINCIN SILVER 925 ','','2.500','1','100.00','255000','0','0','17800','1000000','0','0','0','1000000','ALIKA','00047736','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZIBH-72-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PMM-ZIBH-72-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-261101-0017','2026-11-01','2.500','2026-11-01','14:51:16','PLG0018287','1000000','1000000','0','1000000','0','kasir','2026-11-01 14:51:16','FJ-261101-0016','','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-11-01','FJ-261101-0017','2026-11-01','14:51:16','ALIKA','1000000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261101-0034','2026-11-01','2026-11-01 14:51:16','PENJUALAN : FJ-261101-0017','0','TBC','1000000','1000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0035','D','2026-11-01','14:51:16','TBC','PENJUALAN','FJ-261101-0017','30272397464','1000000','30273397464','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='1900000' WHERE no_faktur_jual='FJ-261101-0017' 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-04939','PUT','1','PER','WEDDRING','','','2.000','','925.00','1','100000','0','950000','0','950000','sz cwe 11 crom putih glosy','grf Fauzi font Brush','','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-261101-0035','2026-11-01','2026-11-01 14:56:45','PESANAN : DP-04939','.','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-261101-0036','D','2026-11-01','14:56:45','TBC','PESANAN','DP-04939','30273397464','950000','30274347464','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-04939','2026-11-01','2026-11-01','14:56:45','PLG0018288','PUT','2026-11-15','kasirbip','2026-11-01 14:56:45','2.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0018','sby','1',' DP-04444SB','TOKO','SBYPSN','PSPLT-ZJBF-36-0','CINCIN PALADIUM ','','3.600','1','17.00','808000','0','0','17800','1960000','0','0','0','1960000','DIL','00048646','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBF-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.600',berat_jual_asli=berat_jual_asli+'3.600',stock_jual='1',berat_akhir=berat_akhir-'3.600',berat_akhir_asli=berat_akhir_asli-'3.600',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPLT-ZJBF-36-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-261101-0018','2026-11-01','3.600','2026-11-01','14:56:45','PLG0018289','1960000','1960000','0','1960000','0','sby','2026-11-01 14:56:44','FJ-261101-0018','DP-04444','1400000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0018','2026-11-01','14:56:45','DIL','1960000','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-261101-0036','2026-11-01','2026-11-01 14:56:44','PENJUALAN : FJ-261101-0018','','TBC','1960000','1960000','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-261101-0037','D','2026-11-01','14:56:45','TBC','PENJUALAN','FJ-261101-0018','30274347464','1960000','30276307464','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='1960000' WHERE no_faktur_jual='FJ-261101-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-261101-0019','sby',' 1',' DP-04443SB','TOKO','SBYPSN','PSGT-ZJBH-6-0','CINCIN EMAS ','','2.530','1','45.00','2637000','0','0','17800','4492000','0','0','0','4492000','DIL','00048707','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBH-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSGT-ZJBH-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261101-0019','2026-11-01','2.530','2026-11-01','14:56:45','PLG0018290','4492000','4492000','0','4492000','0','sby','2026-11-01 14:56:44','FJ-261101-0018','DP-04443','3000000'); 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-11-01','FJ-261101-0019','2026-11-01','14:56:45','DIL','4492000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1960000' WHERE no_faktur_jual='FJ-261101-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-261101-0020','kasir','1',' DP-04675MM','TOKO','MMPSN','PSGT-ZJBI-28-0','CINCIN EMAS ','','1.710','1','57.00','2258000','0','0','17800','4218000','0','0','0','4218000','ELLA','00048754','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBI-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSGT-ZJBI-28-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-261101-0020','2026-11-01','1.710','2026-11-01','14:57:13','PLG0018291','4218000','4218000','0','4218000','-36000','kasir','2026-11-01 14:57:13','FJ-261101-0020','DP-04675','4512000'); 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-11-01','FJ-261101-0020','2026-11-01','14:57:13','ELLA','4218000','0'); UPDATE tt_jual_head SET dibayar_rp='-36000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261101-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-261101-0021','kasir',' 1',' DP-04676MM','TOKO','MMPSN','PSPLT-ZJBH-4-0','CINCIN PALADIUM YL10 ','','3.880','1','17.00','872000','0','0','17800','2158000','0','0','0','2158000','ELLA','00048705','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBH-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.880',berat_jual_asli=berat_jual_asli+'3.880',stock_jual='1',berat_akhir=berat_akhir-'3.880',berat_akhir_asli=berat_akhir_asli-'3.880',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPLT-ZJBH-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261101-0021','2026-11-01','3.880','2026-11-01','14:57:13','PLG0018292','2158000','2158000','0','2158000','0','kasir','2026-11-01 14:57:13','FJ-261101-0020','DP-04676','1900000'); 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-11-01','FJ-261101-0021','2026-11-01','14:57:13','ELLA','2158000','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-261101-0037','2026-11-01','2026-11-01 14:57:13','PENJUALAN : FJ-261101-0021','0','TBC','258000','258000','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-261101-0038','D','2026-11-01','14:57:13','TBC','PENJUALAN','FJ-261101-0021','30276307464','258000','30276565464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='258000' WHERE no_faktur_jual='FJ-261101-0021' 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-04940','PUT','1','PER','WEDDRING','','','2.500','','925.00','1','100000','0','850000','0','850000','sz cwo 25.5 crom putih glosy','grf Amalia font Brush','','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-261101-0038','2026-11-01','2026-11-01 14:58:15','PESANAN : DP-04940','.','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-261101-0039','D','2026-11-01','14:58:15','TBC','PESANAN','DP-04940','30276565464','850000','30277415464','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-04940','2026-11-01','2026-11-01','14:58:15','PLG0018293','PUT','2026-12-03','kasirbip','2026-11-01 14:58:15','2.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-261101-0022','sby','1',' DP-04373SB','TOKO','SBYPSN','PSPRT-ZJBF-38-0','CINCIN PERAK CP01 ','','5.080','1','100.00','519000','0','0','17800','1400000','0','0','0','1400000','DIL','00048648','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBF-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.080',berat_jual_asli=berat_jual_asli+'5.080',stock_jual='1',berat_akhir=berat_akhir-'5.080',berat_akhir_asli=berat_akhir_asli-'5.080',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJBF-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261101-0022','2026-11-01','5.080','2026-11-01','15:25:39','PLG0018294','1400000','1400000','0','1400000','0','sby','2026-11-01 15:25:39','FJ-261101-0022','DP-04373','1400000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0022','2026-11-01','15:25:39','DIL','1400000','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-261101-0022' 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-04941','DEW','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','sz cwe 14','gf berkshbire :Dian..Nano','','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-261101-0039','2026-11-01','2026-11-01 15:39:12','PESANAN : DP-04941','-','TBC','812500','812500'); 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-261101-0040','D','2026-11-01','15:39:12','TBC','PESANAN','DP-04941','30277415464','812500','30278227964','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-04941','2026-11-01','2026-11-01','15:39:12','PLG0018295','DEW','2026-11-25','jogja','2026-11-01 15:39:12','2.500','0','0','0','812500','0','750000','1625000','1625000','812500'); 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-04942','DEW','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','sz cwo 15','gf berkshbire : Dian..Nano','','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-261101-0040','2026-11-01','2026-11-01 15:45:52','PESANAN : DP-04942','-','TBC','812500','812500'); 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-261101-0041','D','2026-11-01','15:45:52','TBC','PESANAN','DP-04942','30278227964','812500','30279040464','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-04942','2026-11-01','2026-11-01','15:45:52','PLG0018296','DEW','2026-11-25','jogja','2026-11-01 15:45:52','2.500','0','0','0','812500','0','750000','1625000','1625000','812500'); 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-04943','SULIS','1','GOLD','WED RING','','','2.500','','50.00','1','2270000','1600000','0','800000','4800000','3 zircon kuning glosy sz 11','font times new roman grf Ricky 29.11.26','berat akhir jgn lbh dr estimasi bag bawah cc dibuat lurus','30000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0041','2026-11-01','2026-11-01 15:47:43','PESANAN : DP-04943','..','TBC','3864000','3864000'); 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-261101-0042','D','2026-11-01','15:47:43','TBC','PESANAN','DP-04943','30279040464','3864000','30282904464','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-04943','2026-11-01','2026-11-01','15:47:43','PLG0018297','SULIS','2026-11-14','kasirbip','2026-11-01 15:47:43','2.500','0','0','0','3864000','0','800000','4830000','4830000','966000'); 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-04944','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','putih glosy sz 23 font times new roman','grf Sofi 29.11.26','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0042','2026-11-01','2026-11-01 15:49:48','PESANAN : DP-04944','.','TBC','1480000','1480000'); 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-261101-0043','D','2026-11-01','15:49:48','TBC','PESANAN','DP-04944','30282904464','1480000','30284384464','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-04944','2026-11-01','2026-11-01','15:49:48','PLG0018298','SULIS','2026-11-14','kasirbip','2026-11-01 15:49:48','3.000','0','0','0','1480000','0','800000','1850000','1850000','370000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04945','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 19.5 putih doff semprot dibuat tanpa mata','font yeseva one grf RENO ... PUTRI','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0043','2026-11-01','2026-11-01 15:52:06','PESANAN : DP-04945','.','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-261101-0044','D','2026-11-01','15:52:06','TBC','PESANAN','DP-04945','30284384464','900000','30285284464','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-04945','2026-11-01','2026-11-01','15:52:06','PLG0018299','SAL','2026-12-01','kasirbip','2026-11-01 15:52:06','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-04946','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz 17.5 putih glossy 7 zirkon','font yeseva one grf RENO ... PUTRI','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0044','2026-11-01','2026-11-01 15:53:49','PESANAN : DP-04946','.','TBC','1000000','1000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0045','D','2026-11-01','15:53:49','TBC','PESANAN','DP-04946','30285284464','1000000','30286284464','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-04946','2026-11-01','2026-11-01','15:53:49','PLG0018300','SAL','2026-12-01','kasirbip','2026-11-01 15:53:49','2.000','0','0','0','1000000','0','0','1000000','1000000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04947','MIL','1','GOLD','WEDRING','','','3.000','','37.50','1','2270000','1300000','0','950000','4850000','sz 18 crom putih glosy','grf 07-11-16 R&Y','zircon 18 EXSPRESS 200.000','0','0','180000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0045','2026-11-01','2026-11-01 15:54:53','PESANAN : DP-04947','.','TBC','4024000','4024000'); 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-261101-0046','D','2026-11-01','15:54:53','TBC','PESANAN','DP-04947','30286284464','4024000','30290308464','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-04947','2026-11-01','2026-11-01','15:54:53','PLG0018301','MIL','2026-11-05','kasirbip','2026-11-01 15:54:53','3.000','0','0','0','4024000','0','950000','5030000','5030000','1006000'); 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-04948','PUT','1','GOLD','WEDDRING','','','2.000','','37.50','1','2270000','1300000','0','900000','3500000','sz cwe 9 crom putih glosy zircon 23','grf Regi font Berkshire','','230000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0046','2026-11-01','2026-11-01 16:00:33','PESANAN : DP-04948','.','TBC','2984000','2984000'); 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-261101-0047','D','2026-11-01','16:00:33','TBC','PESANAN','DP-04948','30290308464','2984000','30293292464','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-04948','2026-11-01','2026-11-01','16:00:33','PLG0018302','PUT','2026-12-03','kasirbip','2026-11-01 16:00:33','2.000','0','0','0','2984000','0','900000','3730000','3730000','746000'); 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-04949','PUT','1','PLD','WEDDRING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz cwo 17.5 crom putih doff semprot','grf Indah 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-261101-0047','2026-11-01','2026-11-01 16:03:18','PESANAN : DP-04949','.','TBC','1440000','1440000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0048','D','2026-11-01','16:03:18','TBC','PESANAN','DP-04949','30293292464','1440000','30294732464','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-04949','2026-11-01','2026-11-01','16:03:18','PLG0018303','PUT','2026-12-03','kasirbip','2026-11-01 16:03:18','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261101-0001','1','PSPRT-ZJCX-45-0','1','2.840','2.840','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJCX-45-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJCX-45-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJCX-45-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJCX-45-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-01 16:14:19' WHERE kode_barang='PSPRT-ZJCX-45-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJCX-45-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-01 16:14:19','TOKO','JOGPSN','PSPRT','PSPRT-ZJCX-45-0','1','2.840','','1','2.840','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJCX-45-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJCX-45-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-01' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261101-0001','1','PSGT-ZJCX-46-0','1','2.510','2.510','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJCX-46-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJCX-46-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJCX-46-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJCX-46-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-01 16:14:19' WHERE kode_barang='PSGT-ZJCX-46-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJCX-46-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-01 16:14:19','TOKO','JOGPSN','PSGT','PSGT-ZJCX-46-0','1','2.510','','1','2.510','','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJCX-46-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJCX-46-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-01' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261101-0001','2026-11-01','16:07','5.350','jogja','2026-11-01 16:14:19'); 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-04950','PUT','1','PER','WEDDRING','','','3.500','','925.00','1','100000','0','950000','0','950000','sz cwe 15 SR.03 grf Aldi','sz cwo 15.5 YL.01 gr Izzati','font Yeseva','100000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0048','2026-11-01','2026-11-01 16:17:51','PESANAN : DP-04950','.','TBC','1050000','1050000'); 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-261101-0049','D','2026-11-01','16:17:51','TBC','PESANAN','DP-04950','30294732464','1050000','30295782464','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-04950','2026-11-01','2026-11-01','16:17:51','PLG0018304','PUT','2026-11-30','kasirbip','2026-11-01 16:17:51','3.500','0','0','0','1050000','0','0','1050000','1050000','0'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261101-0002','1','PJOG-ZJCX-20-0','1','1.750','1.750','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZJCX-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZJCX-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZJCX-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZJCX-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-11-01 16:20:59' WHERE kode_barang='PJOG-ZJCX-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZJCX-20-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-01 16:20:59','TOKO','JOGPER','PJOG','PJOG-ZJCX-20-0','1','1.750','','1','1.750','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PJOG-ZJCX-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZJCX-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-01' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261101-0002','1','PJOG-ZJCX-19-0','1','2.380','2.380','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZJCX-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZJCX-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZJCX-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZJCX-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-11-01 16:20:59' WHERE kode_barang='PJOG-ZJCX-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZJCX-19-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-01 16:20:59','TOKO','JOGPER','PJOG','PJOG-ZJCX-19-0','1','2.380','','1','2.380','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PJOG-ZJCX-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZJCX-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-01' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261101-0002','1','PJOG-ZJCX-18-0','1','1.660','1.660','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZJCX-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZJCX-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZJCX-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZJCX-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-11-01 16:20:59' WHERE kode_barang='PJOG-ZJCX-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZJCX-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-01 16:20:59','TOKO','JOGPER','PJOG','PJOG-ZJCX-18-0','1','1.660','','1','1.660','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PJOG-ZJCX-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZJCX-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-01' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261101-0002','1','PJOG-ZJCX-17-0','1','1.620','1.620','TOKO','JOGPER','TOKO','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZJCX-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZJCX-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZJCX-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZJCX-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-11-01 16:20:59' WHERE kode_barang='PJOG-ZJCX-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZJCX-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-01 16:20:59','TOKO','JOGPER','PJOG','PJOG-ZJCX-17-0','1','1.620','','1','1.620','','100.00'); DELETE FROM tm_dept WHERE kode_dept='PJOG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PJOG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PJOG-ZJCX-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZJCX-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-01' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261101-0002','2026-11-01','16:19','7.410','jogja','2026-11-01 16:20:59'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-01 ','16:25:20'); 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-261101-0023','kasir','1',' DP-04533MM','TOKO','MMPSN','PSPLT-ZJBI-31-0','CINCIN PALADIUM YL10 ','','4.570','1','17.00','1026000','0','0','17800','2399500','0','0','0','2399500','ELLA','00048757','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBI-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.570',berat_jual_asli=berat_jual_asli+'4.570',stock_jual='1',berat_akhir=berat_akhir-'4.570',berat_akhir_asli=berat_akhir_asli-'4.570',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPLT-ZJBI-31-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-261101-0023','2026-11-01','4.570','2026-11-01','16:25:50','PLG0018305','2399500','2399500','0','2399500','-2040000','kasir','2026-11-01 16:25:49','FJ-261101-0023','DP-04533','2040000'); 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-11-01','FJ-261101-0023','2026-11-01','16:25:50','ELLA','2399500','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-261101-0049','2026-11-01','2026-11-01 16:25:49','PENJUALAN : FJ-261101-0023','.','TBC','2399500','2399500','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-261101-0050','D','2026-11-01','16:25:50','TBC','PENJUALAN','FJ-261101-0023','30295782464','2399500','30298181964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='-2040000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2399500' WHERE no_faktur_jual='FJ-261101-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-261101-0024','sby','1',' PLSBY-0001','TOKO','SBYPLD','PLSBY-ZJBX-75-0','CINCIN PALADIUM PLSBY-00011 ','','3.020','1','17.00','679000','0','0','17800','1757000','0','0','0','1757000','DIL','00048408','PLSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLSBY-ZJBX-75-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PLSBY-ZJBX-75-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPLD' 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-261101-0024','2026-11-01','3.020','2026-11-01','16:27:17','PLG0018306','1757000','1757000','0','1757000','0','sby','2026-11-01 16:27:16','FJ-261101-0024','','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-11-01','FJ-261101-0024','2026-11-01','16:27:17','DIL','1757000','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-261101-0050','2026-11-01','2026-11-01 16:27:16','PENJUALAN : FJ-261101-0024','','TBC','1757000','1757000','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-261101-0051','D','2026-11-01','16:27:17','TBC','PENJUALAN','FJ-261101-0024','30298181964','1757000','30299938964','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='1757000' WHERE no_faktur_jual='FJ-261101-0024' 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-04951','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwe 15.5 crom putih glosy','','','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-261101-0051','2026-11-01','2026-11-01 16:32:49','PESANAN : DP-04951','.','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-261101-0052','D','2026-11-01','16:32:49','TBC','PESANAN','DP-04951','30299938964','950000','30300888964','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-04951','2026-11-01','2026-11-01','16:32:49','PLG0018307','MIL','2026-12-03','kasirbip','2026-11-01 16:32:49','3.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04952','MIL','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwo 22.5 crom putih glosy doff semprot','','','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-261101-0052','2026-11-01','2026-11-01 16:35:31','PESANAN : DP-04952','.','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-261101-0053','D','2026-11-01','16:35:31','TBC','PESANAN','DP-04952','30300888964','950000','30301838964','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-04952','2026-11-01','2026-11-01','16:35:31','PLG0018308','MIL','2026-12-03','kasirbip','2026-11-01 16:35:31','3.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04953','KUR','1','GOLD','WED RING','','','2.500','','37.50','1','2270000','1300000','0','900000','4150000','sz 12.5 putih glossy 23 zirkon','font brush script grf Zhentra','','230000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0053','2026-11-01','2026-11-01 16:37:17','PESANAN : DP-04953','.','TBC','3500000','3500000'); 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-261101-0054','D','2026-11-01','16:37:17','TBC','PESANAN','DP-04953','30301838964','3500000','30305338964','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-04953','2026-11-01','2026-11-01','16:37:17','PLG0018309','KUR','2026-12-01','kasirbip','2026-11-01 16:37:17','2.500','0','0','0','3500000','0','900000','4380000','4380000','880000'); 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-261101-0025','kasirbip','1',' DP-04728DU','TOKO','DUPSN','PSPRT-ZJCX-53-0','CINCIN PERAK SR02 YL01 ','','3.550','1','100.00','363000','0','0','17800','950000','0','0','0','950000','MIL','00048817','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJCX-53-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.550',berat_jual_asli=berat_jual_asli+'3.550',stock_jual='1',berat_akhir=berat_akhir-'3.550',berat_akhir_asli=berat_akhir_asli-'3.550',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJCX-53-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-261101-0025','2026-11-01','3.550','2026-11-01','16:40:20','PLG0018310','950000','950000','0','950000','0','kasirbip','2026-11-01 16:40:19','FJ-261101-0025','DP-04728','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-11-01','FJ-261101-0025','2026-11-01','16:40:20','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-261101-0025' 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-04954','KUR','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','800000','2200000','sz 17 putih doff amplas','font brush script grf Dea','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0054','2026-11-01','2026-11-01 16:40:17','PESANAN : DP-04954','.','TBC','1440000','1440000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0055','D','2026-11-01','16:40:17','TBC','PESANAN','DP-04954','30305338964','1440000','30306778964','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-04954','2026-11-01','2026-11-01','16:40:17','PLG0018311','KUR','2026-12-01','kasirbip','2026-11-01 16:40:17','4.000','0','0','0','1440000','0','800000','2200000','2200000','760000'); 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-261101-0026','sby','1',' DP-04348SB','TOKO','SBYPSN','PSPLT-ZJBD-32-0','CINCIN PALADIUM ','','3.850','1','32.00','1627000','0','0','17800','2818000','0','0','0','2818000','DIL','00048607','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBD-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.850',berat_jual_asli=berat_jual_asli+'3.850',stock_jual='1',berat_akhir=berat_akhir-'3.850',berat_akhir_asli=berat_akhir_asli-'3.850',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPLT-ZJBD-32-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-261101-0026','2026-11-01','3.850','2026-11-01','16:42:09','PLG0018312','2818000','2818000','0','2818000','0','sby','2026-11-01 16:42:09','FJ-261101-0026','DP-04348','2000000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0026','2026-11-01','16:42:09','DIL','2818000','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-261101-0055','2026-11-01','2026-11-01 16:42:09','PENJUALAN : FJ-261101-0026','','TBC','818000','818000','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-261101-0056','D','2026-11-01','16:42:09','TBC','PENJUALAN','FJ-261101-0026','30306778964','818000','30307596964','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='818000' WHERE no_faktur_jual='FJ-261101-0026' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0027','sby',' 1',' DP-04349SB','TOKO','SBYPSN','PSPLT-ZJBD-22-0','CINCIN PALADIUM ','','1.900','1','32.00','803000','0','0','17800','1985000','0','0','0','1985000','DIL','00048597','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJBD-22-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPLT-ZJBD-22-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-261101-0027','2026-11-01','1.900','2026-11-01','16:42:09','PLG0018313','1985000','1985000','0','1985000','0','sby','2026-11-01 16:42:09','FJ-261101-0026','DP-04349','1500000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0027','2026-11-01','16:42:09','DIL','1985000','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-261101-0056','2026-11-01','2026-11-01 16:42:09','PENJUALAN : FJ-261101-0027','','TBC','485000','485000','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-261101-0057','D','2026-11-01','16:42:09','TBC','PENJUALAN','FJ-261101-0027','30307596964','485000','30308081964','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='1303000' WHERE no_faktur_jual='FJ-261101-0027' 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-04955','PUT','1','PER','WEDDRING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 20 crom putih glosy','grf Dewi Novianti font Vladimir','EXPRESS 100.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-261101-0057','2026-11-01','2026-11-01 16:47:09','PESANAN : DP-04955','.','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-261101-0058','D','2026-11-01','16:47:09','TBC','PESANAN','DP-04955','30308081964','900000','30308981964','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-04955','2026-11-01','2026-11-01','16:47:09','PLG0018314','PUT','2026-11-13','kasirbip','2026-11-01 16:47:09','2.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0028','kasirbip','1',' DP-04451BI','TOKO','BIPPSN','PSPRT-ZJBI-6-0','CINCIN PERAK ','','3.170','1','100.00','324000','0','0','17800','900000','0','0','0','900000','SULIS','00048732','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBI-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSPRT-ZJBI-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261101-0028','2026-11-01','3.170','2026-11-01','16:53:59','PLG0018315','900000','900000','0','900000','0','kasirbip','2026-11-01 16:53:59','FJ-261101-0028','DP-04451','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-11-01','FJ-261101-0028','2026-11-01','16:53:59','SULIS','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-261101-0028' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0021'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0023'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0024'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0025' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0025' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0025'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0026' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0026' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0026'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0027' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0027' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0027'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0028' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0028' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0028'; 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-261101-0029','kasir','1',' DP-04375MM','TOKO','MMPSN','PSPRT-ZJBH-5-0','CINCIN PERAK ','','2.000','1','100.00','204000','0','0','17800','900000','0','0','0','900000','ALIKA','00048706','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBH-5-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-11-01' AND kode_barang='PSPRT-ZJBH-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-261101-0029','2026-11-01','2.000','2026-11-01','17:11:47','PLG0018316','900000','900000','0','900000','0','kasir','2026-11-01 17:11:46','FJ-261101-0029','DP-04375','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-11-01','FJ-261101-0029','2026-11-01','17:11:47','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-261101-0058','2026-11-01','2026-11-01 17:11:46','PENJUALAN : FJ-261101-0029','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-261101-0059','D','2026-11-01','17:11:47','TBC','PENJUALAN','FJ-261101-0029','30308981964','900000','30309881964','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-261101-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-261101-0030','kasir',' 1',' DP-04374MM','TOKO','MMPSN','PSGT-ZJBD-25-0','CINCIN EMAS ','','2.380','1','57.00','3183000','0','0','17800','5034000','0','0','0','5034000','ALIKA','00048600','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJBD-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.380',berat_jual_asli=berat_jual_asli+'2.380',stock_jual='1',berat_akhir=berat_akhir-'2.380',berat_akhir_asli=berat_akhir_asli-'2.380',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSGT-ZJBD-25-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-261101-0030','2026-11-01','2.380','2026-11-01','17:11:47','PLG0018317','5034000','5034000','0','5034000','0','kasir','2026-11-01 17:11:46','FJ-261101-0029','DP-04374','3912000'); 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-11-01','FJ-261101-0030','2026-11-01','17:11:47','ALIKA','5034000','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-261101-0030' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0029' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0029' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0029'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0030' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0030' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0030'; 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-261101-0031','kasir','1',' 750K-17-12','TOKO','MMPER','PMM-ZHBH-70-0','CINCIN SILVER 925 ','','2.180','1','100.00','223000','0','0','17800','850000','0','0','0','850000','ELLA','00046660','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHBH-70-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PMM-ZHBH-70-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261101-0031','2026-11-01','2.180','2026-11-01','17:15:16','PLG0018318','850000','850000','0','850000','0','kasir','2026-11-01 17:15:15','FJ-261101-0031','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0031','2026-11-01','17:15:16','ELLA','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261101-0059','2026-11-01','2026-11-01 17:15:15','PENJUALAN : FJ-261101-0031','0','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0060','D','2026-11-01','17:15:16','TBC','PENJUALAN','FJ-261101-0031','30309881964','850000','30310731964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261101-0031' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-01 ','17:19:26'); 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-04956','ELLA','1','GOLD','WEDDING RING','','','1.700','','375.00','1','2270000','1300000','0','700000','2910000','size 16 grf Roy ?? Nita','warna crom kuning','zircone 1 butir','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0060','2026-11-01','2026-11-01 17:28:55','PESANAN : DP-04956','0','TBC','2328000','2328000'); 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-261101-0061','D','2026-11-01','17:28:55','TBC','PESANAN','DP-04956','30310731964','2328000','30313059964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04956','2026-11-01','2026-11-01','17:28:55','PLG0018319','ELLA','2026-11-26','kasir','2026-11-01 17:28:55','1.700','0','0','0','2328000','0','700000','2910000','2910000','582000'); 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-04957','VAN','1','PER','WEDDRING SEPAKET CM01','','','3.000','','925.00','1','100000','0','1200000','0','1200000','SIZE PRIA: 20 GRF: Febby Threesia','SIZE WANITA: 13 GRF: Tezar Emiral','FONT: VINTAGE FINISHING: PUTIH','100000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0061','2026-11-01','2026-11-01 17:48:08','PESANAN : DP-04957','-','TBC','1300000','1300000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0062','D','2026-11-01','17:48:08','TBC','PESANAN','DP-04957','30313059964','1300000','30314359964','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-04957','2026-11-01','2026-11-01','17:48:08','PLG0018320','VAN','2027-04-26','sby','2026-11-01 17:48:08','3.000','0','0','0','1300000','0','0','1300000','1300000','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-04958','PUT','1','GOLD','WEDDRING','','','2.000','','37.50','1','2270000','1300000','0','800000','3400000','sz cwe 10 crom hitam glosy','grf Giordano font Brush','zircon 9','0','0','90000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0062','2026-11-01','2026-11-01 17:48:29','PESANAN : DP-04958','.','TBC','2792000','2792000'); 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-261101-0063','D','2026-11-01','17:48:29','TBC','PESANAN','DP-04958','30314359964','2792000','30317151964','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-04958','2026-11-01','2026-11-01','17:48:29','PLG0018321','PUT','2026-12-03','kasirbip','2026-11-01 17:48:29','2.000','0','0','0','2792000','0','800000','3490000','3490000','698000'); 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-04959','PUT','1','PLD','WEDDRING','','','3.000','','25.00','1','1200000','550000','0','750000','2400000','sz cwo 18.5 crom hitam glosy doff semprot','grf Anti Azizah font Brush','','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-261101-0063','2026-11-01','2026-11-01 17:51:03','PESANAN : DP-04959','.','TBC','1920000','1920000'); 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-261101-0064','D','2026-11-01','17:51:03','TBC','PESANAN','DP-04959','30317151964','1920000','30319071964','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-04959','2026-11-01','2026-11-01','17:51:03','PLG0018322','PUT','2026-12-03','kasirbip','2026-11-01 17:51:03','3.000','0','0','0','1920000','0','750000','2400000','2400000','480000'); 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-04960','KUR','1','GOLD','CINCIN KAWIN','','','3.500','','37.50','1','2270000','1300000','0','800000','5350000','size 20 grf F&N','putih glosy sirkon2','font berkshire swash','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-261101-0064','2026-11-01','2026-11-01 17:57:48','PESANAN : DP-04960','.','TBC','4280000','4280000'); 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-261101-0065','D','2026-11-01','17:57:48','TBC','PESANAN','DP-04960','30319071964','4280000','30323351964','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-04960','2026-11-01','2026-11-01','17:57:48','PLG0018323','KUR','2026-11-25','kasirbip','2026-11-01 17:57:48','3.500','0','0','0','4280000','0','800000','5350000','5350000','1070000'); 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-04961','KUR','1','GOLD','CINCIN KAWIN','','','4.000','','37.50','1','2270000','1300000','0','750000','5950000','size 21 grf F&N','putih dof semprot tanpa mata','font berkshire swash','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-261101-0065','2026-11-01','2026-11-01 18:02:18','PESANAN : DP-04961','.','TBC','4760000','4760000'); 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-261101-0066','D','2026-11-01','18:02:18','TBC','PESANAN','DP-04961','30323351964','4760000','30328111964','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-04961','2026-11-01','2026-11-01','18:02:18','PLG0018324','KUR','2026-11-25','kasirbip','2026-11-01 18:02:18','4.000','0','0','0','4760000','0','750000','5950000','5950000','1190000'); 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-04962','ARA','1','PER','WEDDING RING WANITA','','','3.000','','92.50','1','100000','0','950000','0','950000','Permata 7 (request lebar 2 ml)','Size 12 GRF: Naufal ?? Tasya','Font : Berkshire Finishing : Putih Glosy','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-261101-0066','2026-11-01','2026-11-01 18:20:37','PESANAN : DP-04962','-','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-261101-0067','D','2026-11-01','18:20:37','TBC','PESANAN','DP-04962','30328111964','950000','30329061964','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-04962','2026-11-01','2026-11-01','18:20:37','PLG0018325','ARA','2026-11-25','sby','2026-11-01 18:20:37','3.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04963','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 22.5 putih doff amplas','','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0067','2026-11-01','2026-11-01 18:22:36','PESANAN : DP-04963','.','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-261101-0068','D','2026-11-01','18:22:36','TBC','PESANAN','DP-04963','30329061964','900000','30329961964','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-04963','2026-11-01','2026-11-01','18:22:36','PLG0018326','SAL','2026-11-27','kasirbip','2026-11-01 18:22:36','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04964','ARA','1','PER','WEDDING RING PRIA','','','3.000','','92.50','1','100000','0','850000','0','850000','Permata 1','Size 16 GRF: Tasya ?? Naufal','Font : Berkshire Finishing : Putih glosy mix doff','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0068','2026-11-01','2026-11-01 18:24:47','PESANAN : DP-04964','-','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-261101-0069','D','2026-11-01','18:24:47','TBC','PESANAN','DP-04964','30329961964','850000','30330811964','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-04964','2026-11-01','2026-11-01','18:24:47','PLG0018327','ARA','2026-11-25','sby','2026-11-01 18:24:47','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-04965','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','cwe sz 15 up size 100.000','cwo sz 12.5 font vintage rotter express 200.000','grf keduanya Alqan .... Silvia','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0069','2026-11-01','2026-11-01 18:26:24','PESANAN : DP-04965','.','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-261101-0070','D','2026-11-01','18:26:24','TBC','PESANAN','DP-04965','30330811964','950000','30331761964','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-04965','2026-11-01','2026-11-01','18:26:24','PLG0018328','SULIS','2026-11-05','kasirbip','2026-11-01 18:26:24','2.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0032','kasir','1',' 1.0K-135-1','TOKO','MMPER','PMM-ZHBG-10-0','CINCIN SILVER 925 ','','1.840','1','100.00','188000','0','0','17800','1100000','0','0','0','1100000','ALIKA','00046586','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHBG-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.840',berat_jual_asli=berat_jual_asli+'1.840',stock_jual='1',berat_akhir=berat_akhir-'1.840',berat_akhir_asli=berat_akhir_asli-'1.840',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PMM-ZHBG-10-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261101-0032','2026-11-01','1.840','2026-11-01','18:33:08','PLG0018329','1100000','1100000','0','1100000','0','kasir','2026-11-01 18:33:08','FJ-261101-0032','','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-11-01','FJ-261101-0032','2026-11-01','18:33:08','ALIKA','1100000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261101-0070','2026-11-01','2026-11-01 18:33:08','PENJUALAN : FJ-261101-0032','0','TBC','1100000','1100000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0071','D','2026-11-01','18:33:08','TBC','PENJUALAN','FJ-261101-0032','30331761964','1100000','30332861964','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='1100000' WHERE no_faktur_jual='FJ-261101-0032' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0033','kasir',' 1',' 800K-175-1','TOKO','MMPER','PMM-ZJCX-34-0','CINCIN SILVER 925 ','','3.610','1','100.00','369000','0','0','17800','900000','0','0','0','900000','ALIKA','00048798','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZJCX-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.610',berat_jual_asli=berat_jual_asli+'3.610',stock_jual='1',berat_akhir=berat_akhir-'3.610',berat_akhir_asli=berat_akhir_asli-'3.610',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PMM-ZJCX-34-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-261101-0033','2026-11-01','3.610','2026-11-01','18:33:08','PLG0018330','900000','900000','0','900000','0','kasir','2026-11-01 18:33:08','FJ-261101-0032','','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-11-01','FJ-261101-0033','2026-11-01','18:33:08','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-261101-0071','2026-11-01','2026-11-01 18:33:08','PENJUALAN : FJ-261101-0033','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-261101-0072','D','2026-11-01','18:33:08','TBC','PENJUALAN','FJ-261101-0033','30332861964','900000','30333761964','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='2000000' WHERE no_faktur_jual='FJ-261101-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-261101-0034','kasirbip','1',' 900K-14-00','TOKO','DUPERBDG','LXPER-ZJCX-11-0','CINCIN SILVER 925 ','','1.440','1','100.00','147000','0','0','17800','1000000','0','0','0','1000000','MIL','00048775','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJCX-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='LXPER-ZJCX-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-261101-0034','2026-11-01','1.440','2026-11-01','18:52:21','PLG0018331','1000000','1000000','0','1000000','0','kasirbip','2026-11-01 18:52:20','FJ-261101-0034','','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-11-01','FJ-261101-0034','2026-11-01','18:52:21','MIL','1000000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261101-0072','2026-11-01','2026-11-01 18:52:20','PENJUALAN : FJ-261101-0034','.','TBC','1000000','1000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0073','D','2026-11-01','18:52:21','TBC','PENJUALAN','FJ-261101-0034','30333761964','1000000','30334761964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-261101-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-261101-0035','sby','1',' 750K-125-0','TOKO','SBYPER','PSBY-ZGBB-31-0','CINCIN SILVER 925 ','','1.680','1','100.00','172000','0','0','17800','850000','0','0','0','850000','VAN','00045522','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGBB-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PSBY-ZGBB-31-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-261101-0035','2026-11-01','1.680','2026-11-01','19:00:13','PLG0018332','850000','850000','0','850000','0','sby','2026-11-01 19:00:13','FJ-261101-0035','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0035','2026-11-01','19:00:13','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-261101-0073','2026-11-01','2026-11-01 19:00:13','PENJUALAN : FJ-261101-0035','','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-261101-0074','D','2026-11-01','19:00:13','TBC','PENJUALAN','FJ-261101-0035','30334761964','850000','30335611964','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-261101-0035' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0032' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0032' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0032'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0033' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0033' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0033'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0034' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0034' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0034'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0035' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0035' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0035'; 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-04966','DIL','1','PER','WEDD RING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','SIZE 16 GRF: Alfina ?? 14.12.26 (BERKSHIRE)','PUTIH GLOSSY MIX DOFF','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0074','2026-11-01','2026-11-01 19:16:23','PESANAN : DP-04966','-','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-261101-0075','D','2026-11-01','19:16:23','TBC','PESANAN','DP-04966','30335611964','900000','30336511964','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-04966','2026-11-01','2026-11-01','19:16:23','PLG0018333','DIL','2026-11-24','sby','2026-11-01 19:16:23','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04967','ELLA','1','PER','WEDDING RING','','','3.500','','925.00','1','100000','0','0','0','1100000','size 17 grf E & N 27.12.26','warna cromo kombinasi rosegold bagian batiknya','zircone 1 butir','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0075','2026-11-01','2026-11-01 19:17:24','PESANAN : DP-04967','0','TBC','1100000','1100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0076','D','2026-11-01','19:17:24','TBC','PESANAN','DP-04967','30336511964','1100000','30337611964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04967','2026-11-01','2026-11-01','19:17:24','PLG0018334','ELLA','2026-11-26','kasir','2026-11-01 19:17:24','3.500','0','0','0','1100000','0','0','1100000','1100000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04968','PUT','1','PER','WEDDRING','','','2.000','','925.00','1','100000','0','950000','0','950000','sz cwe 11 crom putih glosy','grf Arya Indrata','font Yeseva','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-261101-0076','2026-11-01','2026-11-01 19:22:43','PESANAN : DP-04968','.','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-261101-0077','D','2026-11-01','19:22:43','TBC','PESANAN','DP-04968','30337611964','950000','30338561964','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-04968','2026-11-01','2026-11-01','19:22:43','PLG0018335','PUT','2026-11-26','kasirbip','2026-11-01 19:22:43','2.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04969','PUT','1','PER','WEDDRING','','','2.500','','925.00','1','100000','0','850000','0','850000','sz cwo 15 crom putih doff semprot','grf Tita Rosita','font Yeseva','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-261101-0077','2026-11-01','2026-11-01 19:24:48','PESANAN : DP-04969','.','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-261101-0078','D','2026-11-01','19:24:48','TBC','PESANAN','DP-04969','30338561964','850000','30339411964','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-04969','2026-11-01','2026-11-01','19:24:48','PLG0018336','PUT','2026-11-26','kasirbip','2026-11-01 19:24:48','2.500','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-04970','ELLA','1','PER','WEDDING RING','','','3.500','','925.00','1','100000','0','0','0','1100000','size 17grf N & E 27.12.26','warna crome kombinasi rosegold bagian batik','zircone 1 butir','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0078','2026-11-01','2026-11-01 19:28:11','PESANAN : DP-04970','0','TBC','1100000','1100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0079','D','2026-11-01','19:28:11','TBC','PESANAN','DP-04970','30339411964','1100000','30340511964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04970','2026-11-01','2026-11-01','19:28:11','PLG0018337','ELLA','2026-11-26','kasir','2026-11-01 19:28:11','3.500','0','0','0','1100000','0','0','1100000','1100000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-01 ','19:40:41'); 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-04971','VAN','1','PLD','WEDDRING PRIA','','','4.000','','10.00','1','1200000','350000','0','700000','2100000','SIZE: 22.5','GRF: Vio & Arina FONT: BERKSHIRE','FINISHING: PUTIH DOFF MIX GLOSSY','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0079','2026-11-01','2026-11-01 19:44:31','PESANAN : DP-04971','-','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-261101-0080','D','2026-11-01','19:44:31','TBC','PESANAN','DP-04971','30340511964','1400000','30341911964','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-04971','2026-11-01','2026-11-01','19:44:31','PLG0018338','VAN','2026-12-31','sby','2026-11-01 19:44:31','4.000','0','0','0','1400000','0','700000','2100000','2100000','700000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-11-01 ','19:49:18'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-01 ','19:50:26'); 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-11-01', status ='CLOS' WHERE no_service='SV-02296'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02296'; 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-04972','VAN','1','PER','WEDDRING WANITA','','','2.000','','925.00','1','100000','0','950000','0','950000','SIZE: 12.5','GRF: Tyo FONT:VINTAGE','FINISHING: PUTIH GLOSSY','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0080','2026-11-01','2026-11-01 20:11:09','PESANAN : DP-04972','-','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-261101-0081','D','2026-11-01','20:11:09','TBC','PESANAN','DP-04972','30341911964','950000','30342861964','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-04972','2026-11-01','2026-11-01','20:11:09','PLG0018339','VAN','2026-11-21','sby','2026-11-01 20:11:09','2.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04973','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','SIZE: 19','GRF: Echa FONT: VINTAGE','FINISHING: PUTIH DOFF MIX GLOSSY','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0081','2026-11-01','2026-11-01 20:14:03','PESANAN : DP-04973','-','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-261101-0082','D','2026-11-01','20:14:03','TBC','PESANAN','DP-04973','30342861964','900000','30343761964','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-04973','2026-11-01','2026-11-01','20:14:03','PLG0018340','VAN','2026-11-21','sby','2026-11-01 20:14:03','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04974','ALIKA','1','PER','WEDDING RING','','','2.500','','925.00','1','100000','0','0','0','850000','size cwe 13 grf Salsa crom rose gold','size cwo 16 grf Lal crom putih','zircone 1 btr','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0082','2026-11-01','2026-11-01 20:14:51','PESANAN : DP-04974','.','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-261101-0083','D','2026-11-01','20:14:51','TBC','PESANAN','DP-04974','30343761964','850000','30344611964','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-04974','2026-11-01','2026-11-01','20:14:51','PLG0018341','ALIKA','2026-11-26','kasir','2026-11-01 20:14:51','2.500','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-04975','ELLA','1','GOLD','WEDDING RING','','','1.500','','375.00','1','2270000','1300000','0','700000','2650000','size 10 grf Arom ?? Yuni','warna crom putih','zircone 1 butir','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0083','2026-11-01','2026-11-01 20:23:58','PESANAN : DP-04975','0','TBC','2120000','2120000'); 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-261101-0084','D','2026-11-01','20:23:58','TBC','PESANAN','DP-04975','30344611964','2120000','30346731964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04975','2026-11-01','2026-11-01','20:23:58','PLG0018342','ELLA','2026-11-26','kasir','2026-11-01 20:23:58','1.500','0','0','0','2120000','0','700000','2650000','2650000','530000'); 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-04976','ELLA','1','PLD','WEDDING RING','','','2.500','','10.00','1','1200000','350000','0','500000','1375000','size 20 grf Arom ?? Yuni','warna crom putih doff amplas','tanpa permata','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261101-0084','2026-11-01','2026-11-01 20:27:57','PESANAN : DP-04976','0','TBC','1100000','1100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261101-0085','D','2026-11-01','20:27:57','TBC','PESANAN','DP-04976','30346731964','1100000','30347831964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04976','2026-11-01','2026-11-01','20:27:57','PLG0018343','ELLA','2026-11-26','kasir','2026-11-01 20:27:57','2.500','0','0','0','1100000','0','500000','1375000','1375000','275000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-01 ','20:28:16'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261101-0036','sby','1',' PLSBY-0001','TOKO','SBYPLD','PLSBY-ZJBX-74-0','CINCIN PALADIUM YL01 PLSBY-00010 ','','2.360','1','17.00','530000','0','0','17800','1426000','0','0','0','1426000','DIL','00048407','PLSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLSBY-ZJBX-74-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2026-11-01' AND kode_barang='PLSBY-ZJBX-74-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPLD' 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-261101-0036','2026-11-01','2.360','2026-11-01','21:07:58','PLG0018344','1426000','1426000','0','1426000','0','sby','2026-11-01 21:07:57','FJ-261101-0036','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-01','FJ-261101-0036','2026-11-01','21:07:58','DIL','1426000','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-261101-0085','2026-11-01','2026-11-01 21:07:57','PENJUALAN : FJ-261101-0036','','TBC','1426000','1426000','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-261101-0086','D','2026-11-01','21:07:58','TBC','PENJUALAN','FJ-261101-0036','30347831964','1426000','30349257964','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='1426000' WHERE no_faktur_jual='FJ-261101-0036' 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-04977','VAN','1','PER','WEDDRING SEPAKET 01','','','3.000','','925.00','1','100000','0','950000','0','950000','SIZE WANITA: 13 GRF: Bagus??','SIZE PRIA: 15 GRF: Fidah??','FONT: VINTAGE FINISHING: PUTIH','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-261101-0086','2026-11-01','2026-11-01 21:18:11','PESANAN : DP-04977','-','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-261101-0087','D','2026-11-01','21:18:11','TBC','PESANAN','DP-04977','30349257964','950000','30350207964','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-04977','2026-11-01','2026-11-01','21:18:11','PLG0018345','VAN','2026-11-24','sby','2026-11-01 21:18:11','3.000','0','0','0','950000','0','0','950000','950000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0036' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261101-0036' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261101-0036'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-02','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-02'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-01'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-01'; 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-11-01' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-01'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-01'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-01'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-01'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-02' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-01' 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-261102-0001','D','2026-11-02','21:26:05','TBC','SALDO AWAL','SALDO AWAL','0','30350207964','30350207964'); 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-261102-0001','D','2026-11-02','21:26:05','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-261102-0001','D','2026-11-02','21:26:05','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-261102-0001','D','2026-11-02','21:26:05','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-261102-0001','D','2026-11-02','21:26:05','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-261102-0001','D','2026-11-02','21:26:05','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-261102-0001','D','2026-11-02','21:26:05','','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-261102-0001','D','2026-11-02','21:26:05','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-261102-0001','D','2026-11-02','21:26:05','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-261102-0001','D','2026-11-02','21:26:05','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-261102-0001','D','2026-11-02','21:26:05','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-261102-0001','D','2026-11-02','21:26:05','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); UPDATE tp_system SET tgl_system='2026-11-02';