INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-02 ','07:53:17'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-02 ','07:56:27'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-02 ','08:22:08'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-02 ','09:38:16'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-11-02 ','10:47:01'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-02 ','11:02:48'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-02 ','11:06:17'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-11-02 ','11:06:45'); 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-20261102-0001','1','PSPLT-ZKXB-1-0','1','4.140','4.140','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZKXB-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-1-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZKXB-1-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKXB-1-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-11-02 11:08:37' WHERE kode_barang='PSPLT-ZKXB-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZKXB-1-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-02 11:08:37','TOKO','JOGPSN','PSPLT','PSPLT-ZKXB-1-0','1','4.140','','1','4.140','','32.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZKXB-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKXB-1-0'; UPDATE tt_beli_detail SET tgl_terima='2026-11-02' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261102-0001','2026-11-02','11:07','4.140','jogja','2026-11-02 11:08:36'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-02 ','11:34:26'); 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-261102-0001','sby','1',' DP-04579SB','TOKO','SBYPSN','PSPRT-ZJCX-42-0','CINCIN PERAK ','','3.540','1','100.00','362000','0','0','17800','900000','0','0','0','900000','DIL','00048806','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJCX-42-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.540',berat_jual_asli=berat_jual_asli+'3.540',stock_jual='1',berat_akhir=berat_akhir-'3.540',berat_akhir_asli=berat_akhir_asli-'3.540',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='PSPRT-ZJCX-42-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-261102-0001','2026-11-02','3.540','2026-11-02','11:35:25','PLG0018346','900000','900000','0','900000','0','sby','2026-11-02 11:35:24','FJ-261102-0001','DP-04579','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-02','FJ-261102-0001','2026-11-02','11:35:25','DIL','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-261102-0001' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261102-0002','sby','1',' DP-04463SB','TOKO','SBYPSN','PSPRT-ZJBH-9-0','CINCIN PERAK ','','2.710','1','100.00','277000','0','0','17800','950000','0','0','0','950000','DIL','00048710','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJBH-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.710',berat_jual_asli=berat_jual_asli+'2.710',stock_jual='1',berat_akhir=berat_akhir-'2.710',berat_akhir_asli=berat_akhir_asli-'2.710',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='PSPRT-ZJBH-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261102-0002','2026-11-02','2.710','2026-11-02','11:41:12','PLG0018347','950000','950000','0','950000','0','sby','2026-11-02 11:41:12','FJ-261102-0002','DP-04463','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-02','FJ-261102-0002','2026-11-02','11:41:12','DIL','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-261102-0002' 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-04978','VAN','1','PER','WEDDRING WANITA','','','2.500','','925.00','1','100000','0','950000','0','950000','SIZE: 16','GRF: Andrew & Amanda FONT: VINTAGE','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-261102-0001','2026-11-02','2026-11-02 12:56:47','PESANAN : DP-04978','-','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-261102-0002','D','2026-11-02','12:56:47','TBC','PESANAN','DP-04978','30350207964','950000','30351157964','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-04978','2026-11-02','2026-11-02','12:56:47','PLG0018348','VAN','2026-11-24','sby','2026-11-02 12:56:47','2.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-261102-0003','kasirbip','1',' DP-04821DU','TOKO','DUPSN','PSPRT-ZJCX-52-0','CINCIN PERAK YL01 ','','3.180','1','100.00','325000','0','0','17800','850000','0','0','0','850000','PUT','00048816','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJCX-52-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.180',berat_jual_asli=berat_jual_asli+'3.180',stock_jual='1',berat_akhir=berat_akhir-'3.180',berat_akhir_asli=berat_akhir_asli-'3.180',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='PSPRT-ZJCX-52-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-261102-0003','2026-11-02','3.180','2026-11-02','13:34:37','PLG0018349','850000','850000','0','850000','0','kasirbip','2026-11-02 13:34:36','FJ-261102-0003','DP-04821','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-02','FJ-261102-0003','2026-11-02','13:34:37','PUT','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261102-0003' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-02 ','13:38:10'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-02 ','13:38:48'); 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-04979','SULIS','1','GOLD','WED RING','','','1.500','','37.50','1','2270000','1300000','0','850000','2800000','23 zirkon sz 11 putih glossy','font berkshire swash Agus','berat akhir jgn lebih dari estimasi awal','230000','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0002','2026-11-02','2026-11-02 13:41:42','PESANAN : DP-04979','.','TBC','2424000','2424000'); 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-261102-0003','D','2026-11-02','13:41:42','TBC','PESANAN','DP-04979','30351157964','2424000','30353581964','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-04979','2026-11-02','2026-11-02','13:41:42','PLG0018350','SULIS','2026-11-27','kasirbip','2026-11-02 13:41:42','1.500','0','0','0','2424000','0','850000','3030000','3030000','606000'); 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-04980','SULIS','1','PLD','WED RING','','','2.500','','10.00','1','1200000','350000','0','500000','1375000','sz 23.5 putih doff amplas YL-01','font berkshire swash grf Nurfi','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0003','2026-11-02','2026-11-02 13:43:21','PESANAN : DP-04980','.','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-261102-0004','D','2026-11-02','13:43:21','TBC','PESANAN','DP-04980','30353581964','1100000','30354681964','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-04980','2026-11-02','2026-11-02','13:43:21','PLG0018351','SULIS','2026-11-27','kasirbip','2026-11-02 13:43:21','2.500','0','0','0','1100000','0','500000','1375000','1375000','275000'); 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-261102-0004','jogja','1',' DP-04605JO','TOKO','JOGPSN','PSGT-ZJCX-46-0','CINCIN EMAS ','','2.510','1','45.00','2616000','0','0','17800','3664000','150000','900000','0','4564000','DEW','00048810','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJCX-46-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-02' AND kode_barang='PSGT-ZJCX-46-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-261102-0004','2026-11-02','2.510','2026-11-02','13:49:53','PLG0018352','3664000','3664000','900000','4564000','0','jogja','2026-11-02 13:49:53','FJ-261102-0004','DP-04605','3640000'); 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-02','FJ-261102-0004','2026-11-02','13:49:53','DEW','4564000','900000'); 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-261102-0004','2026-11-02','2026-11-02 13:49:53','PENJUALAN : FJ-261102-0004','','TBC','924000','924000','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-261102-0005','D','2026-11-02','13:49:53','TBC','PENJUALAN','FJ-261102-0004','30354681964','924000','30355605964','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='924000' WHERE no_faktur_jual='FJ-261102-0004' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04981','DEW','1','PLD','WEDRING','','','5.000','','50.00','1','1200000','1000000','0','850000','5850000','sz cwo 19.5 zircon 5 butir','gf vintage : San...Vin/16.01.2027','mix white & gold','50000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0005','2026-11-02','2026-11-02 14:46:24','PESANAN : DP-04981','-','TBC','4730000','4730000'); 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-261102-0006','D','2026-11-02','14:46:24','TBC','PESANAN','DP-04981','30355605964','4730000','30360335964','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-04981','2026-11-02','2026-11-02','14:46:24','PLG0018353','DEW','2026-11-27','jogja','2026-11-02 14:46:24','5.000','0','0','0','4730000','0','850000','5900000','5900000','1170000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-02 ','15:07:47'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-02 ','15:12:35'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261102-0005','kasirbip','1',' 900K-125 ','TOKO','BIPCMP','BDCM-ZJBD-9-0','CINCIN EMAS ','','1.450','1','45.00','1498000','0','0','17800','2785000','0','0','0','2785000','SULIS','00048584','BDCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-ZJBD-9-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-02' AND kode_barang='BDCM-ZJBD-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261102-0005','2026-11-02','1.450','2026-11-02','15:14:15','PLG0018354','2785000','2785000','0','2785000','0','kasirbip','2026-11-02 15:14:14','FJ-261102-0005','','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-02','FJ-261102-0005','2026-11-02','15:14:15','SULIS','2785000','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-261102-0006','2026-11-02','2026-11-02 15:14:14','PENJUALAN : FJ-261102-0005','.','TBC','2785000','2785000','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-261102-0007','D','2026-11-02','15:14:15','TBC','PENJUALAN','FJ-261102-0005','30360335964','2785000','30363120964','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='2785000' WHERE no_faktur_jual='FJ-261102-0005' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261102-0006','kasirbip',' 1',' 800K-17-29','TOKO','BIPPER','PBDG-ZIAF-28-0','CINCIN SILVER 925 ','','2.700','1','100.00','276000','0','0','17800','900000','0','0','0','900000','SULIS','00047260','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIAF-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.700',berat_jual_asli=berat_jual_asli+'2.700',stock_jual='1',berat_akhir=berat_akhir-'2.700',berat_akhir_asli=berat_akhir_asli-'2.700',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='PBDG-ZIAF-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261102-0006','2026-11-02','2.700','2026-11-02','15:14:15','PLG0018355','900000','900000','0','900000','0','kasirbip','2026-11-02 15:14:14','FJ-261102-0005','','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-02','FJ-261102-0006','2026-11-02','15:14:15','SULIS','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-261102-0007','2026-11-02','2026-11-02 15:14:14','PENJUALAN : FJ-261102-0006','.','TBC','900000','900000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261102-0008','D','2026-11-02','15:14:15','TBC','PENJUALAN','FJ-261102-0006','30363120964','900000','30364020964','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='3685000' WHERE no_faktur_jual='FJ-261102-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0004'; 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-261102-0007','kasirbip','1',' 800K-18-28','TOKO','BIPPER','PBDG-ZHXD-30-0','CINCIN SILVER 925 YL10 ','','4.080','1','100.00','417000','0','0','17800','900000','0','0','0','900000','SAL','00045869','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHXD-30-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.080',berat_jual_asli=berat_jual_asli+'4.080',stock_jual='1',berat_akhir=berat_akhir-'4.080',berat_akhir_asli=berat_akhir_asli-'4.080',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='PBDG-ZHXD-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261102-0007','2026-11-02','4.080','2026-11-02','15:24:03','PLG0018356','900000','900000','0','900000','0','kasirbip','2026-11-02 15:24:02','FJ-261102-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-02','FJ-261102-0007','2026-11-02','15:24:03','SAL','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261102-0008','2026-11-02','2026-11-02 15:24:02','PENJUALAN : FJ-261102-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-261102-0009','D','2026-11-02','15:24:03','TBC','PENJUALAN','FJ-261102-0007','30364020964','900000','30364920964','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-261102-0007' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-11-02 ','15:38:19'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-11-02 ','15:44:16'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-02 ','15:45:19'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-02 ','15:46:49'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04982','SULIS','1','PER','WED RING','','','1.000','','925.00','1','100000','0','1400000','0','1400000','crom putih glosy','express 100.000','grf Pandy','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0009','2026-11-02','2026-11-02 15:47:58','PESANAN : DP-04982','.','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-261102-0010','D','2026-11-02','15:47:58','TBC','PESANAN','DP-04982','30364920964','1400000','30366320964','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-04982','2026-11-02','2026-11-02','15:47:58','PLG0018357','SULIS','2026-11-12','kasirbip','2026-11-02 15:47:58','1.000','0','0','0','1400000','0','0','1400000','1400000','0'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02309','SULIS','1','CC SILVER','FONT VLADIMIR CROM PUTIH GLOSY','2.000','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02309','2026-11-02','2026-11-02','15:50:58','PLG0018358','kasirbip','2026-11-11','kasirbip','2026-11-02 15:50:58','2.000','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-11-02 ','15:51:30'); 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-04983','ALIKA','1','GOLD','WEDDING RING','','','3.000','','50.00','1','2270000','1600000','0','1200000','6000000','size 14 grf Fachriza','warna crom putih glosy','zircone 15 btr','0','0','150000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0010','2026-11-02','2026-11-02 16:06:38','PESANAN : DP-04983','0','TBC','4920000','4920000'); 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-261102-0011','D','2026-11-02','16:06:38','TBC','PESANAN','DP-04983','30366320964','4920000','30371240964','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-04983','2026-11-02','2026-11-02','16:06:38','PLG0018359','ALIKA','2026-11-27','kasir','2026-11-02 16:06:38','3.000','0','0','0','4920000','0','1200000','6150000','6150000','1230000'); 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-04984','ALIKA','1','PLD','WEDDING RING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','size 18 grf Anindita','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-261102-0011','2026-11-02','2026-11-02 16:10:43','PESANAN : DP-04984','0','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-261102-0012','D','2026-11-02','16:10:43','TBC','PESANAN','DP-04984','30371240964','1400000','30372640964','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-04984','2026-11-02','2026-11-02','16:10:43','PLG0018360','ALIKA','2026-11-27','kasir','2026-11-02 16:10:43','3.000','0','0','0','1400000','0','700000','1750000','1750000','350000'); UPDATE tm_barang SET stock_on_hand='1' WHERE kode_barang='BDCM-ZJBD-9-0' AND kode_lokasi_toko='BIPCMP' LIMIT 1; UPDATE tt_jual_sales SET jml_jual_rp =jml_jual_rp-'2785000',ongkos_rp=ongkos_rp-'0' WHERE no_faktur_jual ='FJ-261102-0005'; UPDATE tt_jual_head SET status_return = 'CLOS' WHERE no_faktur_jual ='FJ-261102-0005'; UPDATE tt_barang_tukar SET status='CLOS' WHERE no_faktur_group='FJ-261102-0005'; UPDATE tt_voucher_customer SET status='OPEN' WHERE no_voucher='-' UPDATE tt_barang_saldo SET stock_jual=stock_jual-1, berat_jual = berat_jual-'1.45',berat_jual_asli = berat_jual_asli-'1.45', stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.45',berat_akhir_asli=berat_akhir_asli+'1.45' WHERE tanggal ='2026-11-02' AND kode_lokasi_toko ='BIPCMP' AND kode_barang='BDCM-ZJBD-9-0' AND stock_jual*1 > 0 LIMIT 1; INSERT INTO tt_jual_retur_detail(no_retur_jual,no_urut,no_faktur_jual,kode_barang,nama_barang,berat,harga,ongkos,jml_detail,kode_lokasi_toko,kode_dept,kadar,sales_id,alasan,harga_atribut) VALUES ('BJ-261102-0001','1','FJ-261102-0005','BDCM-ZJBD-9-0','CINCIN EMAS ','1.45','2785000.00','0','2785000','BIPCMP','BDCM','45.00','kasirbip','COBA COBA','0'); DELETE FROM tt_jual_head WHERE no_faktur_jual ='FJ-261102-0005' LIMIT 1; DELETE FROM tt_jual_detail WHERE no_faktur_jual ='FJ-261102-0005' LIMIT 1; DELETE FROM tt_jual_sales WHERE no_faktur_jual ='FJ-261102-0005' LIMIT 1; INSERT INTO tt_jual_retur_head(no_retur_jual,tgl_system,tgl_retur_jual,kode_customer,dpp_netto_rp,jml_retur_rp,input_by,input_date)VALUES('BJ-261102-0001','2026-11-02','2026-11-02','PLG0018354','2785000','2785000','kasirbip','2026-11-02 16:33:40'); 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-261102-0008','kasir','1',' 800K-12-00','TOKO','MMPER','PMM-YGXC-27-0','CINCIN SILVER 925 ','','1.900','1','100.00','44000','0','0','17800','900000','0','0','0','900000','ELLA','00036945','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YGXC-27-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-02' AND kode_barang='PMM-YGXC-27-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-261102-0008','2026-11-02','1.900','2026-11-02','16:41:17','PLG0018361','900000','900000','0','900000','0','kasir','2026-11-02 16:41:17','FJ-261102-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-02','FJ-261102-0008','2026-11-02','16:41:17','ELLA','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261102-0012','2026-11-02','2026-11-02 16:41:17','PENJUALAN : FJ-261102-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-261102-0013','D','2026-11-02','16:41:17','TBC','PENJUALAN','FJ-261102-0008','30372640964','900000','30373540964','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-261102-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-04985','DEW','1','PLD','WEDRING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','sz cwo 19','gf vintage : Yansa...Meri','express 200.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0013','2026-11-02','2026-11-02 17:39:54','PESANAN : DP-04985','-','TBC','1580000','1580000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261102-0014','D','2026-11-02','17:39:54','TBC','PESANAN','DP-04985','30373540964','1580000','30375120964','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-04985','2026-11-02','2026-11-02','17:39:54','PLG0018362','DEW','2026-11-11','jogja','2026-11-02 17:39:54','3.500','0','0','0','1580000','0','750000','1975000','1975000','395000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04986','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 20.5 putih doff amplass','fomy berkshire swash grf Elminda 02.12.26','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0014','2026-11-02','2026-11-02 17:59:22','PESANAN : DP-04986','.','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-261102-0015','D','2026-11-02','17:59:22','TBC','PESANAN','DP-04986','30375120964','900000','30376020964','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-04986','2026-11-02','2026-11-02','17:59:22','PLG0018363','SAL','2026-11-27','kasirbip','2026-11-02 17:59:22','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-261102-0009','jogja','1',' DP-04599JO','TOKO','JOGPSN','PSPRT-ZJCX-45-0','CINCIN PERAK ','','2.840','1','100.00','290000','0','0','17800','950000','0','0','0','950000','DEW','00048809','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJCX-45-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.840',berat_jual_asli=berat_jual_asli+'2.840',stock_jual='1',berat_akhir=berat_akhir-'2.840',berat_akhir_asli=berat_akhir_asli-'2.840',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='PSPRT-ZJCX-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-261102-0009','2026-11-02','2.840','2026-11-02','18:00:39','PLG0018364','950000','950000','0','950000','0','jogja','2026-11-02 18:00:38','FJ-261102-0009','DP-04599','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-02','FJ-261102-0009','2026-11-02','18:00:39','DEW','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-261102-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-04987','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','1 zircon putih doff semprot','font berkshire swash grf Rhama','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0015','2026-11-02','2026-11-02 18:01:28','PESANAN : DP-04987','.','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-261102-0016','D','2026-11-02','18:01:28','TBC','PESANAN','DP-04987','30376020964','900000','30376920964','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-04987','2026-11-02','2026-11-02','18:01:28','PLG0018365','SAL','2026-11-27','kasirbip','2026-11-02 18:01:28','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-261102-0010','kasirbip','1',' 500K-175-0','TOKO','DUPERBDG','LXPER-ZEXA-103-0','CINCIN SILVER 925 YL-01 ','','2.100','1','100.00','215000','0','0','17800','650000','0','0','0','650000','KUR','00043125','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEXA-103-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='LXPER-ZEXA-103-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-261102-0010','2026-11-02','2.100','2026-11-02','18:04:17','PLG0018366','650000','650000','0','650000','0','kasirbip','2026-11-02 18:04:17','FJ-261102-0010','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-02','FJ-261102-0010','2026-11-02','18:04:17','KUR','650000','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-261102-0016','2026-11-02','2026-11-02 18:04:17','PENJUALAN : FJ-261102-0010','.','TBC','650000','650000','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-261102-0017','D','2026-11-02','18:04:17','TBC','PENJUALAN','FJ-261102-0010','30376920964','650000','30377570964','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='650000' WHERE no_faktur_jual='FJ-261102-0010' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0010'; 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-04988','MIL','1','GOLD','WEDRING','','','2.000','','37.50','1','2270000','1300000','0','850000','3450000','sz 10.5 crom sesuai dengan di catalogue','zircon 15','','0','150000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0017','2026-11-02','2026-11-02 18:20:09','PESANAN : DP-04988','.','TBC','2880000','2880000'); 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-261102-0018','D','2026-11-02','18:20:09','TBC','PESANAN','DP-04988','30377570964','2880000','30380450964','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-04988','2026-11-02','2026-11-02','18:20:09','PLG0018367','MIL','2026-12-03','kasirbip','2026-11-02 18:20:09','2.000','0','0','0','2880000','0','850000','3600000','3600000','720000'); 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-04989','MIL','1','PER','WEDRING PROMO','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwo 17 YL-01 grf Natasyah','sz cwe 12 grf Ridwan fony yeseva','EXSPRESS 100.000','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0018','2026-11-02','2026-11-02 18:41:36','PESANAN : DP-04989','.','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-261102-0019','D','2026-11-02','18:41:36','TBC','PESANAN','DP-04989','30380450964','950000','30381400964','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-04989','2026-11-02','2026-11-02','18:41:36','PLG0018368','MIL','2026-11-10','kasirbip','2026-11-02 18:41:36','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-261102-0011','kasir','1',' TFCMR75-87','TOKO','TFCINMAS','TFCMR-ZJBX-44-0','THIFA CINCIN MAS RG ','','0.560','1','87.00','1119000','0','0','17800','1120000','0','0','0','1120000','ILUNG','00048377','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZJBX-44-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='TFCMR-ZJBX-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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-261102-0011','2026-11-02','0.560','2026-11-02','18:56:05','PLG0018369','1120000','1120000','0','1120000','0','kasir','2026-11-02 18:56:05','FJ-261102-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-02','FJ-261102-0011','2026-11-02','18:56:05','ILUNG','1120000','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-261102-0019','2026-11-02','2026-11-02 18:56:05','PENJUALAN : FJ-261102-0011','.','TBC','1120000','1120000','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-261102-0020','D','2026-11-02','18:56:05','TBC','PENJUALAN','FJ-261102-0011','30381400964','1120000','30382520964','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='1120000' WHERE no_faktur_jual='FJ-261102-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-261102-0012','kasirbip','1',' 750K-125-0','TOKO','DUPERBDG','LXPER-ZDXG-54-0','CINCIN SILVER 925 ','','2.640','1','100.00','270000','0','0','17800','900000','0','0','0','900000','KUR','00042369','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDXG-54-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='LXPER-ZDXG-54-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-261102-0012','2026-11-02','2.640','2026-11-02','18:58:17','PLG0018370','900000','900000','0','900000','0','kasirbip','2026-11-02 18:58:17','FJ-261102-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-02','FJ-261102-0012','2026-11-02','18:58:17','KUR','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261102-0020','2026-11-02','2026-11-02 18:58:17','PENJUALAN : FJ-261102-0012','.','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-261102-0021','D','2026-11-02','18:58:17','TBC','PENJUALAN','FJ-261102-0012','30382520964','900000','30383420964','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-261102-0012' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0011'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261102-0013','kasir','1',' 850K-11-00','TOKO','MMPER','PMM-YFBX-40-0','CINCIN SILVER 925 ','','1.700','1','100.00','40000','0','0','17800','950000','0','0','0','950000','ALIKA','00036481','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-40-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='PMM-YFBX-40-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-261102-0013','2026-11-02','1.700','2026-11-02','19:37:39','PLG0018371','950000','950000','0','950000','0','kasir','2026-11-02 19:37:39','FJ-261102-0013','','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-02','FJ-261102-0013','2026-11-02','19:37:39','ALIKA','950000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261102-0021','2026-11-02','2026-11-02 19:37:39','PENJUALAN : FJ-261102-0013','0','TBC','950000','950000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261102-0022','D','2026-11-02','19:37:39','TBC','PENJUALAN','FJ-261102-0013','30383420964','950000','30384370964','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='950000' WHERE no_faktur_jual='FJ-261102-0013' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261102-0014','kasir',' 1',' 800K-185-1','TOKO','MMPER','PMM-ZHBG-4-0','CINCIN SILVER 925 ','','2.890','1','100.00','295000','0','0','17800','900000','0','0','0','900000','ALIKA','00046580','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHBG-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.890',berat_jual_asli=berat_jual_asli+'2.890',stock_jual='1',berat_akhir=berat_akhir-'2.890',berat_akhir_asli=berat_akhir_asli-'2.890',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='PMM-ZHBG-4-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-261102-0014','2026-11-02','2.890','2026-11-02','19:37:39','PLG0018372','900000','900000','0','900000','0','kasir','2026-11-02 19:37:39','FJ-261102-0013','','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-02','FJ-261102-0014','2026-11-02','19:37:39','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-261102-0022','2026-11-02','2026-11-02 19:37:39','PENJUALAN : FJ-261102-0014','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-261102-0023','D','2026-11-02','19:37:39','TBC','PENJUALAN','FJ-261102-0014','30384370964','900000','30385270964','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='1850000' WHERE no_faktur_jual='FJ-261102-0014' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-02 ','19:42:59'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-11-02 ','19:44:08'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0014'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-11-02 ','21:06:42'); 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-261102-0015','sby','1',' DP-04217SB','TOKO','SBYPSN','PSGT-ZJAF-24-0','CINCIN EMAS ','','3.170','1','45.00','3347000','0','0','17800','5198000','0','0','0','5198000','VAN','00048221','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAF-24-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-02' AND kode_barang='PSGT-ZJAF-24-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-261102-0015','2026-11-02','3.170','2026-11-02','21:10:45','PLG0018373','5198000','5198000','0','5198000','0','sby','2026-11-02 21:10:45','FJ-261102-0015','DP-04217','4900000'); 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-02','FJ-261102-0015','2026-11-02','21:10:45','VAN','5198000','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-261102-0023','2026-11-02','2026-11-02 21:10:45','PENJUALAN : FJ-261102-0015','','TBC','298000','298000','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-261102-0024','D','2026-11-02','21:10:45','TBC','PENJUALAN','FJ-261102-0015','30385270964','298000','30385568964','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='298000' WHERE no_faktur_jual='FJ-261102-0015' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261102-0016','sby',' 1',' DP-04218SB','TOKO','SBYPSN','PSGT-ZJAF-42-0','CINCIN EMAS ','','2.250','1','45.00','2376000','0','0','17800','4200000','0','0','0','4200000','VAN','00048239','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAF-42-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='PSGT-ZJAF-42-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-261102-0016','2026-11-02','2.250','2026-11-02','21:10:45','PLG0018374','4200000','4200000','0','4200000','0','sby','2026-11-02 21:10:45','FJ-261102-0015','DP-04218','3100000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-11-02','FJ-261102-0016','2026-11-02','21:10:45','VAN','4200000','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-261102-0024','2026-11-02','2026-11-02 21:10:45','PENJUALAN : FJ-261102-0016','','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-261102-0025','D','2026-11-02','21:10:45','TBC','PENJUALAN','FJ-261102-0016','30385568964','1100000','30386668964','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='1398000' WHERE no_faktur_jual='FJ-261102-0016' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261102-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261102-0016'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-03','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-03'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-02'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-02'; 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-02' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-02'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-02'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-02'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-02'; 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-03' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-02' 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-261103-0001','D','2026-11-03','21:19:59','TBC','SALDO AWAL','SALDO AWAL','0','30386668964','30386668964'); 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-261103-0001','D','2026-11-03','21:19:59','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); 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-261103-0001','D','2026-11-03','21:19:59','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-261103-0001','D','2026-11-03','21:19:59','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-261103-0001','D','2026-11-03','21:19:59','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-261103-0001','D','2026-11-03','21:19:59','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-261103-0001','D','2026-11-03','21:19:59','','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-261103-0001','D','2026-11-03','21:19:59','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-261103-0001','D','2026-11-03','21:19:59','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-261103-0001','D','2026-11-03','21:19:59','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-261103-0001','D','2026-11-03','21:19:59','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-261103-0001','D','2026-11-03','21:19:59','KET','SALDO AWAL','SALDO AWAL','0','148641000','148641000'); UPDATE tp_system SET tgl_system='2026-11-03'; 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-04990','ARA','1','GOLD','WEDDING RING WANITA','','','2.500','','75.00','1','2270000','2200000','0','950000','6450000','Permata 17','Size 11 GRF : Mey ?? Hajri','Font : swash Finishing : Putih Glosy','170000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261102-0025','2026-11-02','2026-11-02 21:38:28','PESANAN : DP-04990','-','TBC','4600000','4600000'); 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-261102-0001','D','2026-11-02','21:38:28','TBC','PESANAN','DP-04990','0','4600000','4600000','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-04990','2026-11-02','2026-11-02','21:38:28','PLG0018375','ARA','2026-11-25','sby','2026-11-02 21:38:28','2.500','0','0','0','4600000','0','950000','6620000','6620000','2020000'); 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-04991','ARA','1','PLD','WEDDING RING PRIA','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','Size 17.5','GRF : Hajri ?? Mey','Font : Swash 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-261102-0026','2026-11-02','2026-11-02 21:42:23','PESANAN : DP-04991','-','TBC','2100000','2100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261102-0002','D','2026-11-02','21:42:23','TBC','PESANAN','DP-04991','4600000','2100000','6700000','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-04991','2026-11-02','2026-11-02','21:42:23','PLG0018376','ARA','2026-11-25','sby','2026-11-02 21:42:23','4.000','0','0','0','2100000','0','800000','3000000','3000000','900000');