INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-18 ','10:36:05'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0001','kasirbip','1',' 800K-165-2','TOKO','BIPPER','PBDG-ZIXG-24-0','CINCIN SILVER 925 ','','2.690','1','100.00','275000','0','0','17800','900000','0','0','0','900000','KUR','00046991','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIXG-24-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.690',berat_jual_asli=berat_jual_asli+'2.690',stock_jual='1',berat_akhir=berat_akhir-'2.690',berat_akhir_asli=berat_akhir_asli-'2.690',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PBDG-ZIXG-24-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-261018-0001','2026-10-18','2.690','2026-10-18','10:48:30','PLG0017550','900000','900000','0','900000','0','kasirbip','2026-10-18 10:48:30','FJ-261018-0001','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0001','2026-10-18','10:48:30','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-261018-0003','2026-10-18','2026-10-18 10:48:30','PENJUALAN : FJ-261018-0001','.','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-261018-0004','D','2026-10-18','10:48:30','TBC','PENJUALAN','FJ-261018-0001','29567893464','900000','29568793464','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-261018-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0001'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0002','kasirbip','1',' DP-04432BI','TOKO','BIPPSN','PSPLT-ZJAF-2-0','CINCIN PALADIUM ','','3.000','1','17.00','674000','0','0','17800','1850000','0','0','0','1850000','KUR','00048199','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAF-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPLT-ZJAF-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261018-0002','2026-10-18','3.000','2026-10-18','11:02:57','PLG0017551','1850000','1850000','0','1850000','0','kasirbip','2026-10-18 11:02:57','FJ-261018-0002','DP-04432','1480000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0002','2026-10-18','11:02:57','KUR','1850000','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-261018-0004','2026-10-18','2026-10-18 11:02:57','PENJUALAN : FJ-261018-0002','.','TBC','370000','370000','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-261018-0005','D','2026-10-18','11:02:57','TBC','PENJUALAN','FJ-261018-0002','29568793464','370000','29569163464','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='370000' WHERE no_faktur_jual='FJ-261018-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-261018-0003','kasirbip',' 1',' DP-04431BI','TOKO','BIPPSN','PSGT-ZJAF-44-0','CINCIN EMAS ','','2.640','1','45.00','2788000','0','0','17800','4876000','0','0','0','4876000','KUR','00048241','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAF-44-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-10-18' AND kode_barang='PSGT-ZJAF-44-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-261018-0003','2026-10-18','2.640','2026-10-18','11:02:57','PLG0017552','4876000','4876000','0','4876000','0','kasirbip','2026-10-18 11:02:57','FJ-261018-0002','DP-04431','4860000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0003','2026-10-18','11:02:57','KUR','4876000','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-261018-0005','2026-10-18','2026-10-18 11:02:57','PENJUALAN : FJ-261018-0003','.','TBC','16000','16000','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-261018-0006','D','2026-10-18','11:02:57','TBC','PENJUALAN','FJ-261018-0003','29569163464','16000','29569179464','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='386000' WHERE no_faktur_jual='FJ-261018-0003' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0003'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-18 ','11:16:56'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-18 ','11:17:56'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0004','kasirbip','1',' DP-04130DU','TOKO','DUPSN','PSPLT-ZJAC-10-0','CINCIN PALADIUM ','','2.680','1','17.00','602000','0','0','17800','1638000','0','0','0','1638000','MIL','00048123','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAC-10-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.680',berat_jual_asli=berat_jual_asli+'2.680',stock_jual='1',berat_akhir=berat_akhir-'2.680',berat_akhir_asli=berat_akhir_asli-'2.680',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPLT-ZJAC-10-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-261018-0004','2026-10-18','2.680','2026-10-18','11:22:26','PLG0017553','1638000','1638000','0','1638000','0','kasirbip','2026-10-18 11:22:26','FJ-261018-0004','DP-04130','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-10-18','FJ-261018-0004','2026-10-18','11:22:26','MIL','1638000','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-261018-0006','2026-10-18','2026-10-18 11:22:26','PENJUALAN : FJ-261018-0004','.','TBC','238000','238000','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-261018-0007','D','2026-10-18','11:22:26','TBC','PENJUALAN','FJ-261018-0004','29569179464','238000','29569417464','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='238000' WHERE no_faktur_jual='FJ-261018-0004' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0005','kasirbip',' 1',' DP-04129DU','TOKO','DUPSN','PSPLT-ZJAB-21-0','CINCIN PALADIUM YL10 ','','4.290','1','17.00','964000','0','0','17800','2101500','0','0','0','2101500','MIL','00048104','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAB-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.290',berat_jual_asli=berat_jual_asli+'4.290',stock_jual='1',berat_akhir=berat_akhir-'4.290',berat_akhir_asli=berat_akhir_asli-'4.290',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPLT-ZJAB-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261018-0005','2026-10-18','4.290','2026-10-18','11:22:26','PLG0017554','2101500','2101500','0','2101500','0','kasirbip','2026-10-18 11:22:26','FJ-261018-0004','DP-04129','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-10-18','FJ-261018-0005','2026-10-18','11:22:26','MIL','2101500','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-261018-0007','2026-10-18','2026-10-18 11:22:26','PENJUALAN : FJ-261018-0005','.','TBC','501500','501500','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-261018-0008','D','2026-10-18','11:22:26','TBC','PENJUALAN','FJ-261018-0005','29569417464','501500','29569918964','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='739500' WHERE no_faktur_jual='FJ-261018-0005' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-18 ','11:24:58'); 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-261018-0006','sby','1',' PLSBY-0000','TOKO','SBYPLD','PLSBY-ZJXB-32-0','CINCIN PALADIUM PLSBY-00008 ','','3.500','1','17.00','786000','0','0','17800','1925000','0','0','0','1925000','DIL','00047851','PLSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLSBY-ZJXB-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.500',berat_jual_asli=berat_jual_asli+'3.500',stock_jual='1',berat_akhir=berat_akhir-'3.500',berat_akhir_asli=berat_akhir_asli-'3.500',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PLSBY-ZJXB-32-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-261018-0006','2026-10-18','3.500','2026-10-18','11:27:04','PLG0017555','1925000','1925000','0','1925000','0','sby','2026-10-18 11:27:04','FJ-261018-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0006','2026-10-18','11:27:04','DIL','1925000','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-261018-0008','2026-10-18','2026-10-18 11:27:04','PENJUALAN : FJ-261018-0006','','TBC','1925000','1925000','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-261018-0009','D','2026-10-18','11:27:04','TBC','PENJUALAN','FJ-261018-0006','29569918964','1925000','29571843964','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='1925000' WHERE no_faktur_jual='FJ-261018-0006' 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-04659','DIL','1','PLD','WEDD RING PRIA','','','4.000','','25.00','1','1200000','550000','0','700000','2900000','LEBAR 4MM','SIZE 22.5 GRF: Lala (INFINITY) Bayu (VINTAGE)','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-261018-0009','2026-10-18','2026-10-18 11:55:28','PESANAN : DP-04659','-','TBC','2000000','2000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0010','D','2026-10-18','11:55:28','TBC','PESANAN','DP-04659','29571843964','2000000','29573843964','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-04659','2026-10-18','2026-10-18','11:55:28','PLG0017556','DIL','2026-11-15','sby','2026-10-18 11:55:28','4.000','0','0','0','2000000','0','700000','2900000','2900000','900000'); 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-04660','DIL','1','GOLD','WEDD RING WANITA','','','3.000','','75.00','1','2300000','2250000','0','800000','7550000','PERMATA 3 BUTIR','SIZE 10.5 GRF: Bayu (INFINITY) Lala (VINTAGE)','EMAS PUTIH (REQ MAKSIMAIL 3 GRAM)','30000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0010','2026-10-18','2026-10-18 11:58:52','PESANAN : DP-04660','-','TBC','5000000','5000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0011','D','2026-10-18','11:58:52','TBC','PESANAN','DP-04660','29573843964','5000000','29578843964','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-04660','2026-10-18','2026-10-18','11:58:52','PLG0017557','DIL','2026-11-15','sby','2026-10-18 11:58:52','3.000','0','0','0','5000000','0','800000','7580000','7580000','2580000'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-18', status ='CLOS' WHERE no_service='SV-02278'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02278'; 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-261018-0007','sby','1',' DP-04226SB','TOKO','SBYPSN','PSPRT-ZJAF-43-0','CINCIN PERAK SR04 YL01 ','','3.270','1','100.00','334000','0','0','17800','950000','0','0','0','950000','DIL','00048240','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAF-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.270',berat_jual_asli=berat_jual_asli+'3.270',stock_jual='1',berat_akhir=berat_akhir-'3.270',berat_akhir_asli=berat_akhir_asli-'3.270',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPRT-ZJAF-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261018-0007','2026-10-18','3.270','2026-10-18','12:11:21','PLG0017558','950000','950000','0','950000','0','sby','2026-10-18 12:11:20','FJ-261018-0007','DP-04226','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0007','2026-10-18','12:11:21','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-261018-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-04661','MIL','1','PER','WEDRING PROMO','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cwe 12 grf Gilang','sz cwo 23 grf Rina','font Comic sans','0','100000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0011','2026-10-18','2026-10-18 12:20:07','PESANAN : DP-04661','.','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-261018-0012','D','2026-10-18','12:20:07','TBC','PESANAN','DP-04661','29578843964','950000','29579793964','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-04661','2026-10-18','2026-10-18','12:20:07','PLG0017559','MIL','2026-11-23','kasirbip','2026-10-18 12:20:07','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-04662','DIL','1','PER','WEDD RING CM03','','','3.000','','925.00','1','100000','0','1200000','0','1200000','WANITA: SIZE 12.5 GRF: Panji (BRUSH SCRIPT)','PRIA: SIZE 14.5 GRF: Nadila (BRUSH SCRIPT)','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-261018-0012','2026-10-18','2026-10-18 12:37:42','PESANAN : DP-04662','-','TBC','1200000','1200000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0013','D','2026-10-18','12:37:42','TBC','PESANAN','DP-04662','29579793964','1200000','29580993964','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-04662','2026-10-18','2026-10-18','12:37:42','PLG0017560','DIL','2026-11-15','sby','2026-10-18 12:37:42','3.000','0','0','0','1200000','0','0','1200000','1200000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-18 ','13:22: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-04663','DEW','1','PER','WEDRING','','','3.500','','925.00','1','100000','0','950000','0','950000','sz cwo 17 5','','','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-261018-0013','2026-10-18','2026-10-18 13:25:33','PESANAN : DP-04663','-','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-261018-0014','D','2026-10-18','13:25:33','TBC','PESANAN','DP-04663','29580993964','950000','29581943964','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-04663','2026-10-18','2026-10-18','13:25:33','PLG0017561','DEW','2026-11-09','jogja','2026-10-18 13:25:33','3.500','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04664','MIL','1','PER','WEDRING','','','4.500','','925.00','1','100000','0','950000','0','950000','sz cwo 25.5 crom putih glosy doff semprot','grf Resty.....','font brush','.','.','.'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0014','2026-10-18','2026-10-18 13:32:40','PESANAN : DP-04664','.','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-261018-0015','D','2026-10-18','13:32:40','TBC','PESANAN','DP-04664','29581943964','950000','29582893964','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-04664','2026-10-18','2026-10-18','13:32:40','PLG0017562','MIL','2026-12-23','kasirbip','2026-10-18 13:32:40','4.500','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-00000396','X-00000396','TFC-21451 GIA 7481252994','GR','---','TFC','BELI','BELI001','11200000','2026-10-18','2.440','1','kasir','2026-10-18 13:35:46'); DELETE FROM tp_barang WHERE kode_dept = 'X-TFC'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFC','X-00000396','X-00000396'); 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-261018-0001','FJ-250212-0001','ADL','1','BELI','BELI001','TFC', 'X-00000396', 'TFC-21451 GIA 7481252994','2.440','2.440','75.00','14000000','11200000','4590164','1','11200000','11200000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.440',berat_beli_asli=berat_beli_asli+'2.440',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.440',berat_akhir_asli=berat_akhir_asli+'2.440',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFC' 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-261018-0001','2026-10-18','2026-10-18','13:35:46','ADL','---','2.440','11200000','11200000','11200000','11200000','11200000','kasir','2026-10-18 13:35:46','FB-261018-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0001','RITA ANGGRENI','-','','','2','kasir','2026-10-18 13:35:46'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0015','2026-10-18','2026-10-18 13:35:46','PEMBELIAN UMUM : FB-261018-0001','-','TBC','11200000','11200000'); INSERT INTO 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-261018-0016','K','2026-10-18','13:35:46','TBC','PEMBELIAN UMUM','FB-261018-0001','29582893964','11200000','29571693964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-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-04665','MIL','1','PER','WEDRING','','','1.500','','925.00','1','100000','0','1050000','0','1050000','sz cwe 8 putih glosy','grf Ipnu.....','font brush','.','.','.'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0016','2026-10-18','2026-10-18 13:37:03','PESANAN : DP-04665','.','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-261018-0017','D','2026-10-18','13:37:03','TBC','PESANAN','DP-04665','29571693964','1050000','29572743964','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-04665','2026-10-18','2026-10-18','13:37:03','PLG0017563','MIL','2026-11-23','kasirbip','2026-10-18 13:37:03','1.500','0','0','0','1050000','0','0','1050000','1050000','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-261018-0008','kasirbip','1',' DP-04128BI','TOKO','BIPPSN','PSPLT-ZJAF-28-0','CINCIN PALADIUM ','','3.070','1','17.00','690000','0','0','17800','1824500','0','0','0','1824500','SULIS','00048225','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAF-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPLT-ZJAF-28-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-261018-0008','2026-10-18','3.070','2026-10-18','13:40:14','PLG0017564','1824500','1824500','0','1824500','0','kasirbip','2026-10-18 13:40:13','FJ-261018-0008','DP-04128','1580000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0008','2026-10-18','13:40:14','SULIS','1824500','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-261018-0017','2026-10-18','2026-10-18 13:40:13','PENJUALAN : FJ-261018-0008','.','TBC','244500','244500','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-261018-0018','D','2026-10-18','13:40:14','TBC','PENJUALAN','FJ-261018-0008','29572743964','244500','29572988464','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='244500' WHERE no_faktur_jual='FJ-261018-0008' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0009','kasirbip','1',' 800K-12-00','TOKO','DUPERBDG','LXPER-ZCXB-37-0','CINCIN SILVER 925 ','','1.490','1','100.00','152000','0','0','17800','900000','0','0','0','900000','PUT','00042098','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZCXB-37-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.490',berat_jual_asli=berat_jual_asli+'1.490',stock_jual='1',berat_akhir=berat_akhir-'1.490',berat_akhir_asli=berat_akhir_asli-'1.490',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='LXPER-ZCXB-37-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-261018-0009','2026-10-18','1.490','2026-10-18','14:01:47','PLG0017565','900000','900000','0','900000','0','kasirbip','2026-10-18 14:01:47','FJ-261018-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-10-18','FJ-261018-0009','2026-10-18','14:01:47','PUT','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-261018-0018','2026-10-18','2026-10-18 14:01:47','PENJUALAN : FJ-261018-0009','.','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-261018-0019','D','2026-10-18','14:01:47','TBC','PENJUALAN','FJ-261018-0009','29572988464','900000','29573888464','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-261018-0009' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0010','kasirbip',' 1',' 750K-16-00','TOKO','DUPERBDG','LXPER-ZGBA-63-0','CINCIN SILVER 925 ','','3.520','1','100.00','360000','0','0','17800','900000','0','0','0','900000','PUT','00045456','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGBA-63-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.520',berat_jual_asli=berat_jual_asli+'3.520',stock_jual='1',berat_akhir=berat_akhir-'3.520',berat_akhir_asli=berat_akhir_asli-'3.520',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='LXPER-ZGBA-63-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-261018-0010','2026-10-18','3.520','2026-10-18','14:01:47','PLG0017566','900000','900000','0','900000','0','kasirbip','2026-10-18 14:01:47','FJ-261018-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-10-18','FJ-261018-0010','2026-10-18','14:01:47','PUT','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-261018-0019','2026-10-18','2026-10-18 14:01:47','PENJUALAN : FJ-261018-0010','.','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-261018-0020','D','2026-10-18','14:01:47','TBC','PENJUALAN','FJ-261018-0010','29573888464','900000','29574788464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1800000' WHERE no_faktur_jual='FJ-261018-0010' 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-04666','ARA','1','PER','WEDDING WANITA','','','2.500','','92.50','1','100000','0','950000','0','950000','size : 20.5','font : comic sans GRF: WJS 5.12.26','Finishing : putih gloxy 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-261018-0020','2026-10-18','2026-10-18 14:12:38','PESANAN : DP-04666','-','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-261018-0021','D','2026-10-18','14:12:38','TBC','PESANAN','DP-04666','29574788464','950000','29575738464','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-04666','2026-10-18','2026-10-18','14:12:38','PLG0017567','ARA','2026-11-13','sby','2026-10-18 14:12:38','2.500','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-18 ','14:15:45'); 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-261018-0011','kasir','1',' PLDMM-0004','TOKO','MMPLD','PLDMM-ZJXB-26-0','CINCIN PALADIUM PLDMM-00049 ','','2.430','1','17.00','546000','0','0','17800','1350500','0','0','0','1350500','ALIKA','00047845','PLDMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZJXB-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PLDMM-ZJXB-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261018-0011','2026-10-18','2.430','2026-10-18','14:17:31','PLG0017568','1350500','1350500','0','1350500','0','kasir','2026-10-18 14:17:31','FJ-261018-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-10-18','FJ-261018-0011','2026-10-18','14:17:31','ALIKA','1350500','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-261018-0021','2026-10-18','2026-10-18 14:17:31','PENJUALAN : FJ-261018-0011','.','TBC','1350500','1350500','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-261018-0022','D','2026-10-18','14:17:31','TBC','PENJUALAN','FJ-261018-0011','29575738464','1350500','29577088964','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='1350500' WHERE no_faktur_jual='FJ-261018-0011' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04667','KUR','1','PLD','WED RING','','','2.000','','25.00','1','1200000','550000','0','700000','1800000','sz 16 putih doff amplass','font berkshire swash grf Ayu','YL-01','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0022','2026-10-18','2026-10-18 14:28:37','PESANAN : DP-04667','.','TBC','1500000','1500000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0023','D','2026-10-18','14:28:37','TBC','PESANAN','DP-04667','29577088964','1500000','29578588964','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-04667','2026-10-18','2026-10-18','14:28:37','PLG0017569','KUR','2026-10-28','kasirbip','2026-10-18 14:28:37','2.000','0','0','0','1500000','0','700000','1800000','1800000','300000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-18 ','14:29:05'); 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-04668','ELLA','1','PLD','WEDING RING','','','3.500','','10.00','1','1200000','350000','0','950000','2175000','size 13 grf Elsi ?? Saddam','warna crom putih glosy','zircone 21 butir','0','0','210000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0023','2026-10-18','2026-10-18 14:37:03','PESANAN : DP-04668','0','TBC','1908000','1908000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0024','D','2026-10-18','14:37:03','TBC','PESANAN','DP-04668','29578588964','1908000','29580496964','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-04668','2026-10-18','2026-10-18','14:37:03','PLG0017570','ELLA','2026-11-13','kasir','2026-10-18 14:37:03','3.500','0','0','0','1908000','0','950000','2385000','2385000','477000'); 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-04669','ELLA','1','PLD','WEDDING RING','','','4.500','','10.00','1','1200000','350000','0','750000','2325000','size 18 grf Saddam ?? Elsi','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-261018-0024','2026-10-18','2026-10-18 14:39:54','PESANAN : DP-04669','0','TBC','1860000','1860000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0025','D','2026-10-18','14:39:54','TBC','PESANAN','DP-04669','29580496964','1860000','29582356964','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-04669','2026-10-18','2026-10-18','14:39:54','PLG0017571','ELLA','2026-11-13','kasir','2026-10-18 14:39:54','4.500','0','0','0','1860000','0','750000','2325000','2325000','465000'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-18', status ='CLOS' WHERE no_service='SV-02286'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02286'; 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-261018-0012','kasirbip','1',' 750K-13-00','TOKO','DUPERBDG','LXPER-ZEBI-34-0','CINCIN SILVER 925 ','','1.630','1','100.00','167000','0','0','17800','850000','0','0','0','850000','PUT','00043860','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEBI-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='LXPER-ZEBI-34-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-261018-0012','2026-10-18','1.630','2026-10-18','15:12:23','PLG0017572','850000','850000','0','850000','0','kasirbip','2026-10-18 15:12:23','FJ-261018-0012','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0012','2026-10-18','15:12:23','PUT','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261018-0025','2026-10-18','2026-10-18 15:12:23','PENJUALAN : FJ-261018-0012','.','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0026','D','2026-10-18','15:12:23','TBC','PENJUALAN','FJ-261018-0012','29582356964','850000','29583206964','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-261018-0012' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0013','kasirbip','1',' 800K-10-00','TOKO','DUPERBDG','LXPER-ZEAB-27-0','CINCIN SILVER 925 ','','2.550','1','100.00','261000','0','0','17800','900000','0','0','0','900000','MIL','00043494','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEAB-27-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='LXPER-ZEAB-27-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-261018-0013','2026-10-18','2.550','2026-10-18','15:26:20','PLG0017573','900000','900000','0','900000','0','kasirbip','2026-10-18 15:26:19','FJ-261018-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-10-18','FJ-261018-0013','2026-10-18','15:26:20','MIL','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-261018-0026','2026-10-18','2026-10-18 15:26:19','PENJUALAN : FJ-261018-0013','.','TBC','900000','900000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0027','D','2026-10-18','15:26:20','TBC','PENJUALAN','FJ-261018-0013','29583206964','900000','29584106964','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-261018-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-261018-0014','kasirbip',' 1',' 700K-115-0','TOKO','DUPERBDG','LXPER-ZBBC-9-0','CINCIN SILVER 925 ','','1.580','1','100.00','162000','0','0','17800','800000','0','0','0','800000','MIL','00041670','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZBBC-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.580',berat_jual_asli=berat_jual_asli+'1.580',stock_jual='1',berat_akhir=berat_akhir-'1.580',berat_akhir_asli=berat_akhir_asli-'1.580',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='LXPER-ZBBC-9-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-261018-0014','2026-10-18','1.580','2026-10-18','15:26:20','PLG0017574','800000','800000','0','800000','0','kasirbip','2026-10-18 15:26:19','FJ-261018-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-10-18','FJ-261018-0014','2026-10-18','15:26:20','MIL','800000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261018-0027','2026-10-18','2026-10-18 15:26:19','PENJUALAN : FJ-261018-0014','.','TBC','800000','800000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0028','D','2026-10-18','15:26:20','TBC','PENJUALAN','FJ-261018-0014','29584106964','800000','29584906964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-261018-0014' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0015','kasirbip','1',' DP-04155BI','TOKO','BIPPSN','PSPLT-ZJAF-17-0','CINCIN PALADIUM ','','2.100','1','17.00','472000','0','0','17800','1485000','0','0','0','1485000','SULIS','00048214','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAF-17-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-10-18' AND kode_barang='PSPLT-ZJAF-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261018-0015','2026-10-18','2.100','2026-10-18','15:34:03','PLG0017575','1485000','1485000','0','1485000','0','kasirbip','2026-10-18 15:34:02','FJ-261018-0015','DP-04155','1200000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0015','2026-10-18','15:34:03','SULIS','1485000','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-261018-0028','2026-10-18','2026-10-18 15:34:02','PENJUALAN : FJ-261018-0015','.','TBC','285000','285000','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-261018-0029','D','2026-10-18','15:34:03','TBC','PENJUALAN','FJ-261018-0015','29584906964','285000','29585191964','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='285000' WHERE no_faktur_jual='FJ-261018-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-261018-0016','kasirbip',' 1',' DP-04156BI','TOKO','BIPPSN','PSPLT-ZJAE-6-0','CINCIN PALADIUM YL01 ','','2.170','1','17.00','488000','0','0','17800','1259500','0','0','0','1259500','SULIS','00048187','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAE-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.170',berat_jual_asli=berat_jual_asli+'2.170',stock_jual='1',berat_akhir=berat_akhir-'2.170',berat_akhir_asli=berat_akhir_asli-'2.170',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPLT-ZJAE-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-261018-0016','2026-10-18','2.170','2026-10-18','15:34:03','PLG0017576','1259500','1259500','0','1259500','0','kasirbip','2026-10-18 15:34:02','FJ-261018-0015','DP-04156','1100000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0016','2026-10-18','15:34:03','SULIS','1259500','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-261018-0029','2026-10-18','2026-10-18 15:34:02','PENJUALAN : FJ-261018-0016','.','TBC','159500','159500','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-261018-0030','D','2026-10-18','15:34:03','TBC','PENJUALAN','FJ-261018-0016','29585191964','159500','29585351464','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='444500' WHERE no_faktur_jual='FJ-261018-0016' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0016'; 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-04670','ADL','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','850000','0','850000','sz cwe 13 sz cwo 18','gf Vintage : Rais&Diah','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0030','2026-10-18','2026-10-18 15:44:05','PESANAN : DP-04670','-','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-261018-0031','D','2026-10-18','15:44:05','TBC','PESANAN','DP-04670','29585351464','850000','29586201464','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-04670','2026-10-18','2026-10-18','15:44:05','PLG0017577','ADL','2026-11-09','jogja','2026-10-18 15:44:05','4.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04671','PUT','1','PER','WEDRING','','','2.500','','925.00','1','100000','0','1050000','0','1050000','sz cwe 12 catalog LX-79','grf Risman 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-261018-0031','2026-10-18','2026-10-18 15:46:50','PESANAN : DP-04671','.','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-261018-0032','D','2026-10-18','15:46:50','TBC','PESANAN','DP-04671','29586201464','1050000','29587251464','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-04671','2026-10-18','2026-10-18','15:46:50','PLG0017578','PUT','2026-11-20','kasirbip','2026-10-18 15:46:50','2.500','0','0','0','1050000','0','0','1050000','1050000','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-04672','PUT','1','PER','WEDRING','','','4.000','','925.00','1','100000','0','900000','0','900000','sz cwo 19 catalog LX-63','grf Iis 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-261018-0032','2026-10-18','2026-10-18 15:48:27','PESANAN : DP-04672','.','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-261018-0033','D','2026-10-18','15:48:27','TBC','PESANAN','DP-04672','29587251464','900000','29588151464','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-04672','2026-10-18','2026-10-18','15:48:27','PLG0017579','PUT','2026-11-20','kasirbip','2026-10-18 15:48:27','4.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-04673','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','size cewe 13 grf Raka SR-05','size cowo 14 grf Sarrah YL-01','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-261018-0033','2026-10-18','2026-10-18 15:55:35','PESANAN : DP-04673','.','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-261018-0034','D','2026-10-18','15:55:35','TBC','PESANAN','DP-04673','29588151464','950000','29589101464','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-04673','2026-10-18','2026-10-18','15:55:35','PLG0017580','KUR','2026-11-08','kasirbip','2026-10-18 15:55:35','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-261018-0017','kasirbip','1',' 800K-22-00','TOKO','DUPERBDG','LXPER-ZIAA-28-0','CINCIN SILVER 925 YL10 ','','4.950','1','100.00','505000','0','0','17800','1000000','0','0','0','1000000','MIL','00047138','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZIAA-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.950',berat_jual_asli=berat_jual_asli+'4.950',stock_jual='1',berat_akhir=berat_akhir-'4.950',berat_akhir_asli=berat_akhir_asli-'4.950',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='LXPER-ZIAA-28-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-261018-0017','2026-10-18','4.950','2026-10-18','16:00:35','PLG0017581','1000000','1000000','0','1000000','0','kasirbip','2026-10-18 16:00:35','FJ-261018-0017','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0017','2026-10-18','16:00:35','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-261018-0034','2026-10-18','2026-10-18 16:00:35','PENJUALAN : FJ-261018-0017','.','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-261018-0035','D','2026-10-18','16:00:35','TBC','PENJUALAN','FJ-261018-0017','29589101464','1000000','29590101464','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-261018-0017' 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-261018-0018','kasirbip',' 1',' 850K-11-00','TOKO','DUPERBDG','LXPER-ZFAH-34-0','CINCIN SILVER 925 ','','2.030','1','100.00','208000','0','0','17800','950000','0','0','0','950000','MIL','00044547','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAH-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='LXPER-ZFAH-34-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-261018-0018','2026-10-18','2.030','2026-10-18','16:00:35','PLG0017582','950000','950000','0','950000','0','kasirbip','2026-10-18 16:00:35','FJ-261018-0017','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0018','2026-10-18','16:00:35','MIL','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-261018-0035','2026-10-18','2026-10-18 16:00:35','PENJUALAN : FJ-261018-0018','.','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-261018-0036','D','2026-10-18','16:00:35','TBC','PENJUALAN','FJ-261018-0018','29590101464','950000','29591051464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1950000' WHERE no_faktur_jual='FJ-261018-0018' 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-04674','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','1 zircon putih doff semprot sz 19','font Brush script grf Diksan 06.11.26','express 100.000','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0036','2026-10-18','2026-10-18 16:03:28','PESANAN : DP-04674','.','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-261018-0037','D','2026-10-18','16:03:28','TBC','PESANAN','DP-04674','29591051464','950000','29592001464','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-04674','2026-10-18','2026-10-18','16:03:28','PLG0017583','SULIS','2026-10-30','kasirbip','2026-10-18 16:03:28','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-261018-0019','jogja','1',' 900K-135-0','TOKO','JOGPER','PJOG-ZHBH-57-0','CINCIN SILVER 925 ','','1.480','1','100.00','151000','0','0','17800','1000000','0','0','0','1000000','ADL','00046647','PJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZHBH-57-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PJOG-ZHBH-57-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPER' 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-261018-0019','2026-10-18','1.480','2026-10-18','16:23:41','PLG0017584','1000000','1000000','0','1000000','0','jogja','2026-10-18 16:23:40','FJ-261018-0019','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0019','2026-10-18','16:23:41','ADL','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-261018-0037','2026-10-18','2026-10-18 16:23:40','PENJUALAN : FJ-261018-0019','','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-261018-0038','D','2026-10-18','16:23:41','TBC','PENJUALAN','FJ-261018-0019','29592001464','1000000','29593001464','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-261018-0019' 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-04675','ELLA','1','GOLD','WEDDING RING','','','2.500','','50.00','1','2300000','1800000','0','1000000','5500000','size 8','crom kombinasi rosegold bagian atas putih bagian V','zircone 14 butir','0','0','140000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0038','2026-10-18','2026-10-18 16:28:08','PESANAN : DP-04675','0','TBC','4512000','4512000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0039','D','2026-10-18','16:28:08','TBC','PESANAN','DP-04675','29593001464','4512000','29597513464','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-04675','2026-10-18','2026-10-18','16:28:08','PLG0017585','ELLA','2026-10-30','kasir','2026-10-18 16:28:08','2.500','0','0','0','4512000','0','1000000','5640000','5640000','1128000'); 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-04676','ELLA','1','PLD','WEDDING RING','','','4.500','','10.00','1','1200000','350000','0','800000','2375000','size 14','warna crom full hitam doff amplas (bagian doff juga hitam)','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-261018-0039','2026-10-18','2026-10-18 16:32:05','PESANAN : DP-04676','0','TBC','1900000','1900000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0040','D','2026-10-18','16:32:05','TBC','PESANAN','DP-04676','29597513464','1900000','29599413464','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-04676','2026-10-18','2026-10-18','16:32:05','PLG0017586','ELLA','2026-10-30','kasir','2026-10-18 16:32:05','4.500','0','0','0','1900000','0','800000','2375000','2375000','475000'); 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-20261018-0001','1','PJOG-ZJAD-36-0','1','4.400','4.400','TOKO','JOGPER','PST','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZJAD-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZJAD-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZJAD-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZJAD-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-10-18 16:32:59' WHERE kode_barang='PJOG-ZJAD-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZJAD-36-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-10-18 16:32:59','PST','JOGPER','PJOG','PJOG-ZJAD-36-0','1','4.400','','1','4.400','','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-ZJAD-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZJAD-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-18' 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-20261018-0001','1','PJOG-ZJAD-35-0','1','2.060','2.060','TOKO','JOGPER','PST','JOGPER'); DELETE FROM tm_barang WHERE kode_barang='PJOG-ZJAD-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PJOG-ZJAD-35-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PJOG-ZJAD-35-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PJOG-ZJAD-35-0'; UPDATE tm_barang SET kode_lokasi_gudang='PST',kode_lokasi_toko='JOGPER',tgl_last_beli='2026-10-18 16:32:59' WHERE kode_barang='PJOG-ZJAD-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PJOG-ZJAD-35-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-10-18 16:32:59','PST','JOGPER','PJOG','PJOG-ZJAD-35-0','1','2.060','','1','2.060','','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-ZJAD-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='PJOG-ZJAD-35-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-18' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261018-0001','2026-10-18','16:32','6.460','jogja','2026-10-18 16:32:58'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-18 ','16:33: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-20261018-0002','1','PSGT-ZJAF-27-0','1','4.110','4.110','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJAF-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJAF-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJAF-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAF-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-18 16:39:44' WHERE kode_barang='PSGT-ZJAF-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJAF-27-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-10-18 16:39:44','TOKO','JOGPSN','PSGT','PSGT-ZJAF-27-0','1','4.110','','1','4.110','','83.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-ZJAF-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAF-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-18' 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-20261018-0002','1','PSGT-ZJAF-26-0','1','2.230','2.230','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJAF-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJAF-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJAF-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAF-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-18 16:39:44' WHERE kode_barang='PSGT-ZJAF-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJAF-26-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-10-18 16:39:44','TOKO','JOGPSN','PSGT','PSGT-ZJAF-26-0','1','2.230','','1','2.230','','57.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-ZJAF-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAF-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-18' 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-20261018-0002','1','PSPLT-ZJAF-25-0','1','2.530','2.530','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAF-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAF-25-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAF-25-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAF-25-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-18 16:39:44' WHERE kode_barang='PSPLT-ZJAF-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAF-25-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-10-18 16:39:44','TOKO','JOGPSN','PSPLT','PSPLT-ZJAF-25-0','1','2.530','','1','2.530','','17.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-ZJAF-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAF-25-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-18' 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-20261018-0002','1','PSPLT-ZJAF-38-0','1','4.000','4.000','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAF-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAF-38-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAF-38-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAF-38-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-18 16:39:44' WHERE kode_barang='PSPLT-ZJAF-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAF-38-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-10-18 16:39:44','TOKO','JOGPSN','PSPLT','PSPLT-ZJAF-38-0','1','4.000','','1','4.000','','17.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-ZJAF-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAF-38-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-18' 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-20261018-0002','1','PSPRT-ZJAF-40-0','1','3.750','3.750','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAF-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAF-40-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAF-40-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAF-40-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-18 16:39:44' WHERE kode_barang='PSPRT-ZJAF-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAF-40-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-10-18 16:39:44','TOKO','JOGPSN','PSPRT','PSPRT-ZJAF-40-0','1','3.750','','1','3.750','','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-ZJAF-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAF-40-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-18' 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-20261018-0002','1','PSPRT-ZJAF-39-0','1','3.100','3.100','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAF-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAF-39-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAF-39-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAF-39-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-18 16:39:44' WHERE kode_barang='PSPRT-ZJAF-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAF-39-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-10-18 16:39:44','TOKO','JOGPSN','PSPRT','PSPRT-ZJAF-39-0','1','3.100','','1','3.100','','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-ZJAF-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAF-39-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-18' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261018-0002','2026-10-18','16:33','19.720','jogja','2026-10-18 16:39:43'); 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-04677','PUT','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','800000','1675000','sz cwe 15.5 crom putih glosy','grf Kolose 3:4 font Times new roman','zircon 12','0','0','120000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0040','2026-10-18','2026-10-18 16:58:02','PESANAN : DP-04677','.','TBC','1436000','1436000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0041','D','2026-10-18','16:58:02','TBC','PESANAN','DP-04677','29599413464','1436000','29600849464','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-04677','2026-10-18','2026-10-18','16:58:02','PLG0017587','PUT','2026-11-20','kasirbip','2026-10-18 16:58:02','2.500','0','0','0','1436000','0','800000','1795000','1795000','359000'); 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-04678','PUT','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz cwo 15.5 crom putih doff semprot','grf Kolose 3:4','font times new roman','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-261018-0041','2026-10-18','2026-10-18 16:59:56','PESANAN : DP-04678','.','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-261018-0042','D','2026-10-18','16:59:56','TBC','PESANAN','DP-04678','29600849464','1440000','29602289464','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-04678','2026-10-18','2026-10-18','16:59:56','PLG0017588','PUT','2026-11-20','kasirbip','2026-10-18 16:59:56','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0020','kasirbip','1',' 850K-14-29','TOKO','BIPPER','PBDG-ZIXG-25-0','CINCIN SILVER 925 ','','1.210','1','100.00','124000','0','0','17800','950000','0','0','0','950000','SULIS','00046992','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIXG-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PBDG-ZIXG-25-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-261018-0020','2026-10-18','1.210','2026-10-18','17:08:46','PLG0017589','950000','950000','0','950000','0','kasirbip','2026-10-18 17:08:46','FJ-261018-0020','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0020','2026-10-18','17:08:46','SULIS','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-261018-0042','2026-10-18','2026-10-18 17:08:46','PENJUALAN : FJ-261018-0020','.','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-261018-0043','D','2026-10-18','17:08:46','TBC','PENJUALAN','FJ-261018-0020','29602289464','950000','29603239464','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='950000' WHERE no_faktur_jual='FJ-261018-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-261018-0021','kasirbip','1',' 700K-14-00','TOKO','BIPPER','PBSD-YGBI-85-0','CINCIN SILVER 925 ','','1.450','1','100.00','30000','0','0','17800','800000','0','0','0','800000','SAL','00037721','PBSD','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGBI-85-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-10-18' AND kode_barang='PBSD-YGBI-85-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-261018-0021','2026-10-18','1.450','2026-10-18','17:09:33','PLG0017590','800000','800000','0','800000','0','kasirbip','2026-10-18 17:09:32','FJ-261018-0021','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0021','2026-10-18','17:09:33','SAL','800000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261018-0043','2026-10-18','2026-10-18 17:09:32','PENJUALAN : FJ-261018-0021','.','TBC','800000','800000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0044','D','2026-10-18','17:09:33','TBC','PENJUALAN','FJ-261018-0021','29603239464','800000','29604039464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-261018-0021' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0021'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0022','kasirbip','1',' DP-04147DU','TOKO','DUPSN','PSGT-ZJAD-45-0','CINCIN EMAS ','','2.550','1','83.00','4966000','0','0','17800','6937500','0','0','0','6937500','PUT','00048172','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAD-45-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSGT-ZJAD-45-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-261018-0022','2026-10-18','2.550','2026-10-18','17:15:40','PLG0017591','6937500','6937500','0','6937500','0','kasirbip','2026-10-18 17:15:39','FJ-261018-0022','DP-04147','5460000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0022','2026-10-18','17:15:40','PUT','6937500','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-261018-0044','2026-10-18','2026-10-18 17:15:39','PENJUALAN : FJ-261018-0022','.','TBC','1477500','1477500','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-261018-0045','D','2026-10-18','17:15:40','TBC','PENJUALAN','FJ-261018-0022','29604039464','1477500','29605516964','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='1477500' WHERE no_faktur_jual='FJ-261018-0022' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0023','kasirbip',' 1',' DP-04148DU','TOKO','DUPSN','PSPLT-ZJAF-3-0','CINCIN PALADIUM ','','4.330','1','32.00','1830000','0','0','17800','3331500','0','0','0','3331500','PUT','00048200','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAF-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.330',berat_jual_asli=berat_jual_asli+'4.330',stock_jual='1',berat_akhir=berat_akhir-'4.330',berat_akhir_asli=berat_akhir_asli-'4.330',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPLT-ZJAF-3-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-261018-0023','2026-10-18','4.330','2026-10-18','17:15:40','PLG0017592','3331500','3331500','0','3331500','0','kasirbip','2026-10-18 17:15:39','FJ-261018-0022','DP-04148','2740000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0023','2026-10-18','17:15:40','PUT','3331500','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-261018-0045','2026-10-18','2026-10-18 17:15:39','PENJUALAN : FJ-261018-0023','.','TBC','591500','591500','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-261018-0046','D','2026-10-18','17:15:40','TBC','PENJUALAN','FJ-261018-0023','29605516964','591500','29606108464','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='2069000' WHERE no_faktur_jual='FJ-261018-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-261018-0024','sby','1',' DP-04125SB','TOKO','SBYPSN','PSGT-ZJAB-25-0','CINCIN EMAS ','','3.170','1','57.00','4240000','0','0','17800','6796000','0','0','0','6796000','DIL','00048108','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJAB-25-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-10-18' AND kode_barang='PSGT-ZJAB-25-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-261018-0024','2026-10-18','3.170','2026-10-18','17:30:13','PLG0017593','6796000','6796000','0','6796000','0','sby','2026-10-18 17:30:12','FJ-261018-0024','DP-04125','5000000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0024','2026-10-18','17:30:13','DIL','6796000','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-261018-0046','2026-10-18','2026-10-18 17:30:12','PENJUALAN : FJ-261018-0024','','TBC','1796000','1796000','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-261018-0047','D','2026-10-18','17:30:13','TBC','PENJUALAN','FJ-261018-0024','29606108464','1796000','29607904464','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='1796000' WHERE no_faktur_jual='FJ-261018-0024' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0025','sby',' 1',' DP-04124SB','TOKO','SBYPSN','PSPLT-ZJAC-11-0','CINCIN PALADIUM ','','5.500','1','32.00','2324000','0','0','17800','4655000','0','0','0','4655000','DIL','00048124','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAC-11-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.500',berat_jual_asli=berat_jual_asli+'5.500',stock_jual='1',berat_akhir=berat_akhir-'5.500',berat_akhir_asli=berat_akhir_asli-'5.500',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPLT-ZJAC-11-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-261018-0025','2026-10-18','5.500','2026-10-18','17:30:13','PLG0017594','4655000','4655000','0','4655000','0','sby','2026-10-18 17:30:12','FJ-261018-0024','DP-04124','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-10-18','FJ-261018-0025','2026-10-18','17:30:13','DIL','4655000','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-261018-0047','2026-10-18','2026-10-18 17:30:12','PENJUALAN : FJ-261018-0025','','TBC','1655000','1655000','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-261018-0048','D','2026-10-18','17:30:13','TBC','PENJUALAN','FJ-261018-0025','29607904464','1655000','29609559464','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='3451000' WHERE no_faktur_jual='FJ-261018-0025' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0023'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0024'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0025' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0025' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0025'; 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-261018-0026','sby','1',' DP-03978SB','TOKO','SBYPSN','PSGT-ZJXB-46-0','CINCIN EMAS ','','1.560','1','45.00','1648000','0','0','17800','3224000','0','0','0','3224000','VAN','00047865','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXB-46-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSGT-ZJXB-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261018-0026','2026-10-18','1.560','2026-10-18','17:40:38','PLG0017595','3224000','3224000','0','3224000','0','sby','2026-10-18 17:40:38','FJ-261018-0026','DP-03978','2600000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0026','2026-10-18','17:40:38','VAN','3224000','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-261018-0048','2026-10-18','2026-10-18 17:40:38','PENJUALAN : FJ-261018-0026','','TBC','624000','624000','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-261018-0049','D','2026-10-18','17:40:38','TBC','PENJUALAN','FJ-261018-0026','29609559464','624000','29610183464','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='624000' WHERE no_faktur_jual='FJ-261018-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-261018-0027','sby','1',' DP-04102SB','TOKO','SBYPSN','PSPRT-ZJXI-31-0','CINCIN PERAK ','','1.280','1','100.00','131000','0','0','17800','1050000','0','0','0','1050000','DIL','00048077','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXI-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPRT-ZJXI-31-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-261018-0027','2026-10-18','1.280','2026-10-18','17:46:35','PLG0017596','1050000','1050000','0','1050000','0','sby','2026-10-18 17:46:35','FJ-261018-0027','DP-04102','1050000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0027','2026-10-18','17:46:35','DIL','1050000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261018-0027' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0028','sby',' 1',' DP-04101SB','TOKO','SBYPSN','PSPRT-ZJXH-9-0','CINCIN PERAK ','','2.230','1','100.00','228000','0','0','17800','800000','0','0','0','800000','DIL','00048031','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXH-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPRT-ZJXH-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-261018-0028','2026-10-18','2.230','2026-10-18','17:46:35','PLG0017597','800000','800000','0','800000','0','sby','2026-10-18 17:46:35','FJ-261018-0027','DP-04101','800000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0028','2026-10-18','17:46:35','DIL','800000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261018-0028' 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-04679','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','950000','0','950000','cwo YL-01 sz 23 grf Asti','cwe SR-04 sz 7 grf Rian','font keduanya berkshire swash UPSIZE 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-261018-0049','2026-10-18','2026-10-18 18:09:50','PESANAN : DP-04679','.','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-261018-0050','D','2026-10-18','18:09:50','TBC','PESANAN','DP-04679','29610183464','950000','29611133464','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-04679','2026-10-18','2026-10-18','18:09:50','PLG0017598','KUR','2026-11-10','kasirbip','2026-10-18 18:09:50','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-261018-0029','kasir','1',' PLDMM-0002','TOKO','MMPLD','PLDMM-ZACX-15-0','CINCIN PALADIUM PLDMM-00029 ','','5.350','1','17.00','1201000','0','0','17800','2672500','0','0','0','2672500','ELLA','00041229','PLDMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLDMM-ZACX-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.350',berat_jual_asli=berat_jual_asli+'5.350',stock_jual='1',berat_akhir=berat_akhir-'5.350',berat_akhir_asli=berat_akhir_asli-'5.350',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PLDMM-ZACX-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPLD' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261018-0029','2026-10-18','5.350','2026-10-18','18:11:46','PLG0017599','2672500','2672500','0','2672500','0','kasir','2026-10-18 18:11:45','FJ-261018-0029','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0029','2026-10-18','18:11:46','ELLA','2672500','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-261018-0050','2026-10-18','2026-10-18 18:11:45','PENJUALAN : FJ-261018-0029','0','TBC','2672500','2672500','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-261018-0051','D','2026-10-18','18:11:46','TBC','PENJUALAN','FJ-261018-0029','29611133464','2672500','29613805964','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='2672500' WHERE no_faktur_jual='FJ-261018-0029' LIMIT 1; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000397','X-00000397','CINCIN CBRT-00620','GR','---','CBRT','BELI','BELI001','11200000','2026-10-18','10.530','1','kasir','2026-10-18 18:16:36'); DELETE FROM tp_barang WHERE kode_dept = 'X-CBRT'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBRT','X-00000397','X-00000397'); 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-261018-0002','FJ-231020-0001','FAISAL','1','BELI','BELI001','CBRT', 'X-00000397', 'CINCIN CBRT-00620','10.530','10.530','75.00','14000000','11200000','1063628','1','11200000','11200000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'10.530',berat_beli_asli=berat_beli_asli+'10.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'10.530',berat_akhir_asli=berat_akhir_asli+'10.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-18' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBRT' 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-261018-0002','2026-10-18','2026-10-18','18:16:36','FAISAL','---','10.530','11200000','11200000','11200000','11200000','11200000','kasir','2026-10-18 18:16:36','FB-261018-0002','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261018-0002','FAIRUZ','-','','','-','kasir','2026-10-18 18:16:36'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0051','2026-10-18','2026-10-18 18:16:36','PEMBELIAN UMUM : FB-261018-0002','.','TBC','11200000','11200000'); INSERT INTO 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-261018-0052','K','2026-10-18','18:16:36','TBC','PEMBELIAN UMUM','FB-261018-0002','29613805964','11200000','29602605964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261018-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261018-0002'; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04680','PUT','1','PLD','WEDRING','','','2.500','','25.00','1','1200000','550000','0','950000','2325000','sz cwe 14 crom putih glosy zircon 36','grf Agung font Berkshire','zircon tngah jngn terlalu timbul','360000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0052','2026-10-18','2026-10-18 18:25:56','PESANAN : DP-04680','.','TBC','2148000','2148000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0053','D','2026-10-18','18:25:56','TBC','PESANAN','DP-04680','29602605964','2148000','29604753964','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-04680','2026-10-18','2026-10-18','18:25:56','PLG0017600','PUT','2026-11-20','kasirbip','2026-10-18 18:25:56','2.500','0','0','0','2148000','0','950000','2685000','2685000','537000'); 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-04681','PUT','1','PER','WEDRING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwo 19','grf Ara 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-261018-0053','2026-10-18','2026-10-18 18:29:30','PESANAN : DP-04681','.','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-261018-0054','D','2026-10-18','18:29:30','TBC','PESANAN','DP-04681','29604753964','950000','29605703964','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-04681','2026-10-18','2026-10-18','18:29:30','PLG0017601','PUT','2026-11-20','kasirbip','2026-10-18 18:29:30','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-04682','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1050000','0','1050000','sz 15.5 putih doff semprot','font vintage rotter grf Alif 10.01.26','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0054','2026-10-18','2026-10-18 18:40:38','PESANAN : DP-04682','.','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-261018-0055','D','2026-10-18','18:40:38','TBC','PESANAN','DP-04682','29605703964','1050000','29606753964','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-04682','2026-10-18','2026-10-18','18:40:38','PLG0017602','SULIS','2026-11-18','kasirbip','2026-10-18 18:40:38','2.000','0','0','0','1050000','0','0','1050000','1050000','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-04683','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','1 zircon putih doff semprot setengah lingkaran','sz 22.5 font vintage rotter grf Ardella 10.01.26','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0055','2026-10-18','2026-10-18 18:42:05','PESANAN : DP-04683','.','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-261018-0056','D','2026-10-18','18:42:05','TBC','PESANAN','DP-04683','29606753964','850000','29607603964','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-04683','2026-10-18','2026-10-18','18:42:05','PLG0017603','SULIS','2026-11-01','kasirbip','2026-10-18 18:42:05','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-261018-0030','kasirbip','1',' 950K-145-0','TOKO','DUPERBDG','LXPER-ZJXE-42-0','CINCIN SILVER 925 ','','1.980','1','100.00','202000','0','0','17800','1050000','0','0','0','1050000','MIL','00047927','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJXE-42-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='LXPER-ZJXE-42-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-261018-0030','2026-10-18','1.980','2026-10-18','18:43:38','PLG0017604','1050000','1050000','0','1050000','0','kasirbip','2026-10-18 18:43:38','FJ-261018-0030','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0030','2026-10-18','18:43:38','MIL','1050000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261018-0056','2026-10-18','2026-10-18 18:43:38','PENJUALAN : FJ-261018-0030','.','TBC','1050000','1050000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0057','D','2026-10-18','18:43:38','TBC','PENJUALAN','FJ-261018-0030','29607603964','1050000','29608653964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1050000' WHERE no_faktur_jual='FJ-261018-0030' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0031','kasirbip',' 1',' 800K-20-00','TOKO','DUPERBDG','LXPER-ZJXG-19-0','CINCIN SILVER 925 YL10 ','','4.750','1','100.00','485000','0','0','17800','1000000','0','0','0','1000000','MIL','00047980','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJXG-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.750',berat_jual_asli=berat_jual_asli+'4.750',stock_jual='1',berat_akhir=berat_akhir-'4.750',berat_akhir_asli=berat_akhir_asli-'4.750',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='LXPER-ZJXG-19-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-261018-0031','2026-10-18','4.750','2026-10-18','18:43:38','PLG0017605','1000000','1000000','0','1000000','0','kasirbip','2026-10-18 18:43:38','FJ-261018-0030','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0031','2026-10-18','18:43:38','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-261018-0057','2026-10-18','2026-10-18 18:43:38','PENJUALAN : FJ-261018-0031','.','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-261018-0058','D','2026-10-18','18:43:38','TBC','PENJUALAN','FJ-261018-0031','29608653964','1000000','29609653964','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='2050000' WHERE no_faktur_jual='FJ-261018-0031' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0032','kasirbip','1',' DP-04309DU','TOKO','DUPSN','PSPRT-ZJAF-33-0','CINCIN PERAK YL01 ','','3.060','1','100.00','313000','0','0','17800','950000','0','0','0','950000','PUT','00048230','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAF-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPRT-ZJAF-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261018-0032','2026-10-18','3.060','2026-10-18','19:00:17','PLG0017606','950000','950000','0','950000','0','kasirbip','2026-10-18 19:00:17','FJ-261018-0032','DP-04309','950000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0032','2026-10-18','19:00:17','PUT','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261018-0032' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0026' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0026' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0026'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0027' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0027' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0027'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0028' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0028' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0028'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0029' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0029' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0029'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0030' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0030' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0030'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0032' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0032' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0032'; 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-04684','VAN','1','PER','WEDDRING WANITA','','','3.000','','925.00','1','100000','0','1050000','0','1050000','SIZE: 10','GRF: A&A 26.12.26 FONT: BERKSHIRE','FINISHING: PUTIH MIX ROSE GOLD','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261018-0058','2026-10-18','2026-10-18 19:03:30','PESANAN : DP-04684','-','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-261018-0059','D','2026-10-18','19:03:30','TBC','PESANAN','DP-04684','29609653964','1050000','29610703964','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-04684','2026-10-18','2026-10-18','19:03:30','PLG0017607','VAN','2026-11-12','sby','2026-10-18 19:03:30','3.000','0','0','0','1050000','0','0','1050000','1050000','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-04685','ALIKA','1','PER','WEDDING RING','','','2.000','','925.00','1','100000','0','0','0','900000','size 10 grf Bagas Satyadi','warna crom putih doff semprot sesuai model','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-261018-0059','2026-10-18','2026-10-18 19:06:06','PESANAN : DP-04685','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-261018-0060','D','2026-10-18','19:06:06','TBC','PESANAN','DP-04685','29610703964','900000','29611603964','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-04685','2026-10-18','2026-10-18','19:06:06','PLG0017608','ALIKA','2026-11-13','kasir','2026-10-18 19:06: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-04686','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','SIZE: 22','GRF: A&A 26.12.26 FONT: BERKSHIRE','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-261018-0060','2026-10-18','2026-10-18 19:06:25','PESANAN : DP-04686','-','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-261018-0061','D','2026-10-18','19:06:25','TBC','PESANAN','DP-04686','29611603964','900000','29612503964','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-04686','2026-10-18','2026-10-18','19:06:25','PLG0017609','VAN','2026-11-12','sby','2026-10-18 19:06:25','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-04687','ALIKA','1','PER','WEDDING RING','','','2.000','','925.00','1','100000','0','0','0','900000','size 17 grf Novia Rivalda','warna crom putih glosy','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-261018-0061','2026-10-18','2026-10-18 19:10:16','PESANAN : DP-04687','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-261018-0062','D','2026-10-18','19:10:16','TBC','PESANAN','DP-04687','29612503964','900000','29613403964','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-04687','2026-10-18','2026-10-18','19:10:16','PLG0017610','ALIKA','2026-11-13','kasir','2026-10-18 19:10:16','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-261018-0033','sby','1',' DP-04403SB','TOKO','SBYPSN','PSPRT-ZJAB-29-0','CINCIN PERAK YL01 ','','2.050','1','100.00','210000','0','0','17800','600000','0','0','0','600000','ARA','00048112','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAB-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPRT-ZJAB-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261018-0033','2026-10-18','2.050','2026-10-18','19:17:29','PLG0017611','600000','600000','0','600000','0','sby','2026-10-18 19:17:29','FJ-261018-0033','DP-04403','600000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0033','2026-10-18','19:17:29','ARA','600000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261018-0033' 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-04688','VAN','1','PER','WEDDRING SEPAKET','','','3.000','','925.00','1','100000','0','850000','0','850000','SIZE WANITA: 18 SIZE PRIA: 16','GRF WANITA: Firman?? GRF PRIA: Nadila??','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-261018-0062','2026-10-18','2026-10-18 19:28:18','PESANAN : DP-04688','-','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-261018-0063','D','2026-10-18','19:28:18','TBC','PESANAN','DP-04688','29613403964','950000','29614353964','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-04688','2026-10-18','2026-10-18','19:28:18','PLG0017612','VAN','2026-11-28','sby','2026-10-18 19:28:18','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-04689','ADL','1','PER','WEDRING','','','4.000','','925.00','2','100000','0','1500000','0','1500000','sz cwo 16 sz cwe 10','gf Vintage : Rahmat & Rahma','','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-261018-0063','2026-10-18','2026-10-18 19:43:36','PESANAN : DP-04689','-','TBC','1500000','1500000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0064','D','2026-10-18','19:43:36','TBC','PESANAN','DP-04689','29614353964','1500000','29615853964','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-04689','2026-10-18','2026-10-18','19:43:36','PLG0017613','ADL','2026-11-09','jogja','2026-10-18 19:43:36','4.000','0','0','0','1500000','0','0','1500000','1500000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0034','sby','1',' 750K-14-00','TOKO','SBYPER','PSBY-ZEXE-7-0','CINCIN SILVER 925','','2.570','1','100.00','263000','0','0','17800','850000','0','0','0','850000','DIL','00043203','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.570',berat_jual_asli=berat_jual_asli+'2.570',stock_jual='1',berat_akhir=berat_akhir-'2.570',berat_akhir_asli=berat_akhir_asli-'2.570',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSBY-ZEXE-7-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-261018-0034','2026-10-18','2.570','2026-10-18','19:52:08','PLG0017614','850000','850000','0','850000','0','sby','2026-10-18 19:52:07','FJ-261018-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-10-18','FJ-261018-0034','2026-10-18','19:52:08','DIL','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261018-0064','2026-10-18','2026-10-18 19:52:07','PENJUALAN : FJ-261018-0034','','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-261018-0065','D','2026-10-18','19:52:08','TBC','PENJUALAN','FJ-261018-0034','29615853964','850000','29616703964','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-261018-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-261018-0035','sby',' 1',' 900K-12-00','TOKO','SBYPER','PSBY-ZIXA-16-0','CINCIN SILVER 925 ','','1.550','1','100.00','159000','0','0','17800','1000000','0','0','0','1000000','DIL','00046786','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZIXA-16-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSBY-ZIXA-16-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-261018-0035','2026-10-18','1.550','2026-10-18','19:52:08','PLG0017615','1000000','1000000','0','1000000','0','sby','2026-10-18 19:52:07','FJ-261018-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-10-18','FJ-261018-0035','2026-10-18','19:52:08','DIL','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-261018-0065','2026-10-18','2026-10-18 19:52:07','PENJUALAN : FJ-261018-0035','','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-261018-0066','D','2026-10-18','19:52:08','TBC','PENJUALAN','FJ-261018-0035','29616703964','1000000','29617703964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-261018-0035' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-18 ','19:53:15'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0033' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0033' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0033'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0034' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0034' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0034'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0035' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0035' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-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-04690','ARA','1','PER','WEDDING RING CP10','','','3.000','','92.50','1','100000','0','1400000','0','1400000','WANITA: SIZE 18 GRF: ANA & IRON (BERKSHIRE)','PRIA: SIZE 17 GRF : IRON & ANA (BERKSHIRE)','FINISHING : PUTIH GLOSY MIX DOFF','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-261018-0066','2026-10-18','2026-10-18 20:09:19','PESANAN : DP-04690','-','TBC','1500000','1500000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0067','D','2026-10-18','20:09:19','TBC','PESANAN','DP-04690','29617703964','1500000','29619203964','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-04690','2026-10-18','2026-10-18','20:09:19','PLG0017616','ARA','2026-11-13','sby','2026-10-18 20:09:19','3.000','0','0','0','1500000','0','0','1500000','1500000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0036','kasirbip','1',' 850K-11-26','TOKO','BIPPER','PBDG-ZFXD-29-0','CINCIN SILVER 925 ','','1.130','1','100.00','116000','0','0','17800','1000000','0','0','0','1000000','SULIS','00043971','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZFXD-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PBDG-ZFXD-29-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-261018-0036','2026-10-18','1.130','2026-10-18','20:21:27','PLG0017617','1000000','1000000','0','1000000','0','kasirbip','2026-10-18 20:21:27','FJ-261018-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-10-18','FJ-261018-0036','2026-10-18','20:21:27','SULIS','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-261018-0067','2026-10-18','2026-10-18 20:21:27','PENJUALAN : FJ-261018-0036','.','TBC','1000000','1000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0068','D','2026-10-18','20:21:27','TBC','PENJUALAN','FJ-261018-0036','29619203964','1000000','29620203964','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-261018-0036' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0037','kasirbip',' 1',' 700K-175-2','TOKO','BIPPER','PBDG-ZIXD-58-0','CINCIN SILVER 925 ','','1.420','1','100.00','145000','0','0','17800','850000','0','0','0','850000','SULIS','00046921','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIXD-58-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.420',berat_jual_asli=berat_jual_asli+'1.420',stock_jual='1',berat_akhir=berat_akhir-'1.420',berat_akhir_asli=berat_akhir_asli-'1.420',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PBDG-ZIXD-58-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-261018-0037','2026-10-18','1.420','2026-10-18','20:21:27','PLG0017618','850000','850000','0','850000','0','kasirbip','2026-10-18 20:21:27','FJ-261018-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-10-18','FJ-261018-0037','2026-10-18','20:21:27','SULIS','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261018-0068','2026-10-18','2026-10-18 20:21:27','PENJUALAN : FJ-261018-0037','.','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0069','D','2026-10-18','20:21:27','TBC','PENJUALAN','FJ-261018-0037','29620203964','850000','29621053964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-261018-0037' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0036' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0036' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0036'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0037' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0037' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0037'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02292','SULIS','1','SEPASANG SILVER','TAMBAH BAHAN JGN DIBUAT TIPIS CWE SZ 11 5 PUTIH GLOSY CWO 18 5 PUTIH DOFF SEMPROT FONT BERKSHIRE SWASH','2.500','1','100000','100000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261018-0069','2026-10-18','2026-10-18 20:23:51','SERVICE : SV-02292','.','TBC','100000','100000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261018-0070','D','2026-10-18','20:23:51','TBC','SERVICE','SV-02292','29621053964','100000','29621153964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02292','2026-10-18','2026-10-18','20:23:51','PLG0017619','kasirbip','2026-10-29','kasirbip','2026-10-18 20:23:51','2.500','0','0','0','100000','0','100000','100000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-18 ','20:24:09'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-18 ','20:25: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-261018-0038','sby','1',' DP-04280SB','TOKO','SBYPSN','PSPRT-ZJAF-36-0','CINCIN PERAK ','','4.250','1','100.00','434000','0','0','17800','850000','0','0','0','850000','VAN','00048233','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAF-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.250',berat_jual_asli=berat_jual_asli+'4.250',stock_jual='1',berat_akhir=berat_akhir-'4.250',berat_akhir_asli=berat_akhir_asli-'4.250',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPRT-ZJAF-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-261018-0038','2026-10-18','4.250','2026-10-18','20:52:50','PLG0017620','850000','850000','0','850000','0','sby','2026-10-18 20:52:50','FJ-261018-0038','DP-04280','850000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0038','2026-10-18','20:52:50','VAN','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261018-0038' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0039','sby',' 1',' DP-04279SB','TOKO','SBYPSN','PSPRT-ZJAF-35-0','CINCIN PERAK ','','1.880','1','100.00','192000','0','0','17800','900000','0','0','0','900000','VAN','00048232','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJAF-35-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.880',berat_jual_asli=berat_jual_asli+'1.880',stock_jual='1',berat_akhir=berat_akhir-'1.880',berat_akhir_asli=berat_akhir_asli-'1.880',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSPRT-ZJAF-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-261018-0039','2026-10-18','1.880','2026-10-18','20:52:50','PLG0017621','900000','900000','0','900000','0','sby','2026-10-18 20:52:50','FJ-261018-0038','DP-04279','900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0039','2026-10-18','20:52:50','VAN','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-261018-0039' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0038' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0038' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0038'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0039' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0039' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0039'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-18 ','20:59:50'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0040','sby','1',' 900K-14-00','TOKO','SBYPER','PSBY-ZGBB-43-0','CINCIN SILVER 925 ','','2.020','1','100.00','207000','0','0','17800','1000000','0','0','0','1000000','ARA','00045534','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZGBB-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSBY-ZGBB-43-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-261018-0040','2026-10-18','2.020','2026-10-18','21:01:24','PLG0017622','1000000','1000000','0','1000000','0','sby','2026-10-18 21:01:24','FJ-261018-0040','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0040','2026-10-18','21:01:24','ARA','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-261018-0070','2026-10-18','2026-10-18 21:01:24','PENJUALAN : FJ-261018-0040','','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-261018-0071','D','2026-10-18','21:01:24','TBC','PENJUALAN','FJ-261018-0040','29621153964','1000000','29622153964','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-261018-0040' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261018-0041','sby','1',' 800K-18-00','TOKO','SBYPER','PSBY-ZEXE-42-0','CINCIN SILVER 925 ','','2.280','1','100.00','234000','0','0','17800','900000','0','0','0','900000','ARA','00043238','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-18', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXE-42-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.280',berat_jual_asli=berat_jual_asli+'2.280',stock_jual='1',berat_akhir=berat_akhir-'2.280',berat_akhir_asli=berat_akhir_asli-'2.280',stock_akhir='0' WHERE tanggal='2026-10-18' AND kode_barang='PSBY-ZEXE-42-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-261018-0041','2026-10-18','2.280','2026-10-18','21:03:16','PLG0017623','900000','900000','0','900000','0','sby','2026-10-18 21:03:15','FJ-261018-0041','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-18','FJ-261018-0041','2026-10-18','21:03:16','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-261018-0071','2026-10-18','2026-10-18 21:03:15','PENJUALAN : FJ-261018-0041','','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-261018-0072','D','2026-10-18','21:03:16','TBC','PENJUALAN','FJ-261018-0041','29622153964','900000','29623053964','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-261018-0041' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0040' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0040' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0040'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0041' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261018-0041' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261018-0041'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-19','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-18'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-18'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-18'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-18' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-18'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-18'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-18'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-18'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-19' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-18' 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-261019-0001','D','2026-10-19','21:08:11','TBC','SALDO AWAL','SALDO AWAL','0','29623053964','29623053964'); 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-261019-0001','D','2026-10-19','21:08:11','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-261019-0001','D','2026-10-19','21:08:11','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-261019-0001','D','2026-10-19','21:08:11','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-261019-0001','D','2026-10-19','21:08:11','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-261019-0001','D','2026-10-19','21:08:11','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-261019-0001','D','2026-10-19','21:08:11','','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-261019-0001','D','2026-10-19','21:08:11','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-261019-0001','D','2026-10-19','21:08:11','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-261019-0001','D','2026-10-19','21:08:11','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-261019-0001','D','2026-10-19','21:08:11','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-261019-0001','D','2026-10-19','21:08:11','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); UPDATE tp_system SET tgl_system='2026-10-19';