INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-11 ','10:21:30'); 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-261011-0001','kasirbip','1',' DP-04031DU','TOKO','DUPSN','PSPLT-ZJXF-17-0','CINCIN PALADIUM ','','1.350','1','17.00','304000','0','0','17800','1452500','0','0','0','1452500','PUT','00047945','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXF-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPLT-ZJXF-17-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-261011-0001','2026-10-11','1.350','2026-10-11','10:22:36','PLG0017204','1452500','1452500','0','1452500','0','kasirbip','2026-10-11 10:22:36','FJ-261011-0001','DP-04031','1344000'); 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-11','FJ-261011-0001','2026-10-11','10:22:36','PUT','1452500','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-261011-0001','2026-10-11','2026-10-11 10:22:36','PENJUALAN : FJ-261011-0001','.','TBC','108500','108500','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-261011-0002','D','2026-10-11','10:22:36','TBC','PENJUALAN','FJ-261011-0001','29177955464','108500','29178063964','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='108500' WHERE no_faktur_jual='FJ-261011-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0001'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-11 ','10:24:31'); 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-04513','ADL','1','PER','WEDDRING','','','4.000','','925.00','2','100000','0','1600000','0','1600000','sz cwo 18 sz cwe 12 5','gf vintage cwe : Yanto... cwo : Tuti...','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0002','2026-10-11','2026-10-11 10:26:59','PESANAN : DP-04513','-','TBC','1600000','1600000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0003','D','2026-10-11','10:26:59','TBC','PESANAN','DP-04513','29178063964','1600000','29179663964','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-04513','2026-10-11','2026-10-11','10:26:59','PLG0017205','ADL','2026-11-02','jogja','2026-10-11 10:26:59','4.000','0','0','0','1600000','0','0','1600000','1600000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-11 ','10:27:10'); 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-04514','MIL ','1','PER','WEDRING PROMO','','','3.000','','925.00','1','100000','0','950000','0','950000','sz cwe 12.5 SR.02 grf Ridwan & Aghni','SZ CWO 19 YL.01 grf Ridwan & Aghni','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-261011-0003','2026-10-11','2026-10-11 10:36:33','PESANAN : DP-04514','.','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-261011-0004','D','2026-10-11','10:36:33','TBC','PESANAN','DP-04514','29179663964','950000','29180613964','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-04514','2026-10-11','2026-10-11','10:36:33','PLG0017206','MIL ','2026-11-07','kasirbip','2026-10-11 10:36:33','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-261011-0002','kasirbip','1',' DP-04019DU','TOKO','DUPSN','PSPRT-ZJXF-9-0','CINCIN PERAK SR03 YL01 ','','3.420','1','100.00','349000','0','0','17800','950000','0','0','0','950000','MIL','00047937','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXF-9-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.420',berat_jual_asli=berat_jual_asli+'3.420',stock_jual='1',berat_akhir=berat_akhir-'3.420',berat_akhir_asli=berat_akhir_asli-'3.420',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPRT-ZJXF-9-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-261011-0002','2026-10-11','3.420','2026-10-11','10:54:33','PLG0017207','950000','950000','0','950000','0','kasirbip','2026-10-11 10:54:32','FJ-261011-0002','DP-04019','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-11','FJ-261011-0002','2026-10-11','10:54:33','MIL','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261011-0002' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-11 ','11:04:08'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-11 ','11:33:00'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-11 ','11:52: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-04515','PUT','1','GOLD','WEDRING','','','2.500','','75.00','1','2300000','2250000','0','950000','6575000','sz cwe 15 crom putih glosy','grf Bayu font yeseva zircon 14','zircon tengah dibikin bulat EXPRESS 200.000','0','140000','150000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0004','2026-10-11','2026-10-11 12:14:22','PESANAN : DP-04515','.','TBC','5492000','5492000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0005','D','2026-10-11','12:14:22','TBC','PESANAN','DP-04515','29180613964','5492000','29186105964','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-04515','2026-10-11','2026-10-11','12:14:22','PLG0017208','PUT','2026-10-15','kasirbip','2026-10-11 12:14:22','2.500','0','0','0','5492000','0','950000','6865000','6865000','1373000'); 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-04516','PUT','1','GOLD','WEDRING','','','2.500','','37.50','1','2300000','1400000','0','500000','4000000','sz cwo 18 YL.01','grf Adelah font Yeseva','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0005','2026-10-11','2026-10-11 12:16:09','PESANAN : DP-04516','.','TBC','3200000','3200000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0006','D','2026-10-11','12:16:09','TBC','PESANAN','DP-04516','29186105964','3200000','29189305964','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-04516','2026-10-11','2026-10-11','12:16:09','PLG0017209','PUT','2026-10-15','kasirbip','2026-10-11 12:16:09','2.500','0','0','0','3200000','0','500000','4000000','4000000','800000'); 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-261011-0003','kasir','1',' DP-04139MM','TOKO','MMPSN','PSPLT-ZJXI-19-0','CINCIN PALADIUM YL10 ','','4.160','1','17.00','934000','0','0','17800','2256000','0','0','0','2256000','ALIKA','00048065','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXI-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.160',berat_jual_asli=berat_jual_asli+'4.160',stock_jual='1',berat_akhir=berat_akhir-'4.160',berat_akhir_asli=berat_akhir_asli-'4.160',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPLT-ZJXI-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0003','2026-10-11','4.160','2026-10-11','12:20:30','PLG0017210','2256000','2256000','0','2256000','0','kasir','2026-10-11 12:20:30','FJ-261011-0003','DP-04139','1900000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0003','2026-10-11','12:20:30','ALIKA','2256000','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-261011-0006','2026-10-11','2026-10-11 12:20:30','PENJUALAN : FJ-261011-0003','0','TBC','356000','356000','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-261011-0007','D','2026-10-11','12:20:30','TBC','PENJUALAN','FJ-261011-0003','29189305964','356000','29189661964','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='356000' WHERE no_faktur_jual='FJ-261011-0003' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261011-0004','kasir',' 1',' DP-04140MM','TOKO','MMPSN','PSGT-ZJXB-15-0','CINCIN EMAS ','','1.810','1','45.00','1911000','0','0','17800','3314000','0','0','0','3314000','ALIKA','00047834','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXB-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSGT-ZJXB-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0004','2026-10-11','1.810','2026-10-11','12:20:30','PLG0017211','3314000','3314000','0','3314000','0','kasir','2026-10-11 12:20:30','FJ-261011-0003','DP-04140','2864000'); 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-11','FJ-261011-0004','2026-10-11','12:20:30','ALIKA','3314000','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-261011-0007','2026-10-11','2026-10-11 12:20:30','PENJUALAN : FJ-261011-0004','0','TBC','450000','450000','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-261011-0008','D','2026-10-11','12:20:30','TBC','PENJUALAN','FJ-261011-0004','29189661964','450000','29190111964','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='806000' WHERE no_faktur_jual='FJ-261011-0004' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04517','PUT','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','900000','1775000','sz cwe 14 crom putih glosy','grf Iffan font Berkshire','zircon 52','0','0','520000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0008','2026-10-11','2026-10-11 12:44:11','PESANAN : DP-04517','.','TBC','1836000','1836000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0009','D','2026-10-11','12:44:11','TBC','PESANAN','DP-04517','29190111964','1836000','29191947964','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-04517','2026-10-11','2026-10-11','12:44:11','PLG0017212','PUT','2026-11-07','kasirbip','2026-10-11 12:44:11','2.500','0','0','0','1836000','0','900000','2295000','2295000','459000'); 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-04518','PUT','1','PER','WEDRING','','','2.500','','925.00','1','100000','0','850000','0','850000','sz cwo 17.5 crom putih doff semprot','grf Vira 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-261011-0009','2026-10-11','2026-10-11 12:46:04','PESANAN : DP-04518','.','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-261011-0010','D','2026-10-11','12:46:04','TBC','PESANAN','DP-04518','29191947964','850000','29192797964','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-04518','2026-10-11','2026-10-11','12:46:04','PLG0017213','PUT','2026-11-07','kasirbip','2026-10-11 12:46:04','2.500','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04519','SULIS','1','GOLD','WED RING','','','2.500','','75.00','1','2300000','2250000','0','850000','6475000','sz 8 putih glossy 11 zirkon','font yeseva one grf Amin','permata dibuat setengah lingkaran disesuaikan saja','110000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0010','2026-10-11','2026-10-11 12:49:19','PESANAN : DP-04519','.','TBC','5268000','5268000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0011','D','2026-10-11','12:49:19','TBC','PESANAN','DP-04519','29192797964','5268000','29198065964','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-04519','2026-10-11','2026-10-11','12:49:19','PLG0017214','SULIS','2026-11-11','kasirbip','2026-10-11 12:49:19','2.500','0','0','0','5268000','0','850000','6585000','6585000','1317000'); 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-04520','SULIS','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','850000','2250000','sz 17 putih glossy 17 zirkon','font yeseva one grf Wulan','','170000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0011','2026-10-11','2026-10-11 12:50:56','PESANAN : DP-04520','.','TBC','1936000','1936000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0012','D','2026-10-11','12:50:56','TBC','PESANAN','DP-04520','29198065964','1936000','29200001964','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-04520','2026-10-11','2026-10-11','12:50:56','PLG0017215','SULIS','2026-11-11','kasirbip','2026-10-11 12:50:56','4.000','0','0','0','1936000','0','850000','2420000','2420000','484000'); 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-261011-0005','jogja','1',' 750K-155-0','TOKO','JOGPER','PJOG-ZHBF-49-0','CINCIN SILVER 925 ','','1.750','1','100.00','179000','0','0','17800','900000','0','0','0','900000','DEW','00046555','PJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZHBF-49-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PJOG-ZHBF-49-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-261011-0005','2026-10-11','1.750','2026-10-11','12:56:38','PLG0017216','900000','900000','0','900000','0','jogja','2026-10-11 12:56:37','FJ-261011-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0005','2026-10-11','12:56:38','DEW','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-261011-0012','2026-10-11','2026-10-11 12:56:37','PENJUALAN : FJ-261011-0005','','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-261011-0013','D','2026-10-11','12:56:38','TBC','PENJUALAN','FJ-261011-0005','29200001964','900000','29200901964','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-261011-0005' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261011-0006','jogja',' 1',' 900K-12 ','TOKO','JOGCCM','CMJOG-ZIXG-46-0','CINCIN MAS ','','1.400','1','45.00','1543000','0','0','17800','2190000','230000','900000','0','3090000','DEW','00047013','CMJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CMJOG-ZIXG-46-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='CMJOG-ZIXG-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGCCM' 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-261011-0006','2026-10-11','1.400','2026-10-11','12:56:38','PLG0017217','2190000','2190000','900000','3090000','0','jogja','2026-10-11 12:56:37','FJ-261011-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0006','2026-10-11','12:56:38','DEW','3090000','900000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261011-0013','2026-10-11','2026-10-11 12:56:37','PENJUALAN : FJ-261011-0006','','TBC','3090000','3090000','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-261011-0014','D','2026-10-11','12:56:38','TBC','PENJUALAN','FJ-261011-0006','29200901964','3090000','29203991964','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='3990000' WHERE no_faktur_jual='FJ-261011-0006' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-11 ','13:03:24'); 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-261011-0007','sby','1',' DP-04098SB','TOKO','SBYPSN','PSPRT-ZJXF-31-0','CINCIN PERAK ','','1.950','1','100.00','199000','0','0','17800','900000','0','0','0','900000','DIL','00047959','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXF-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPRT-ZJXF-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-261011-0007','2026-10-11','1.950','2026-10-11','13:04:14','PLG0017218','900000','900000','0','900000','0','sby','2026-10-11 13:04:14','FJ-261011-0007','DP-04098','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-11','FJ-261011-0007','2026-10-11','13:04:14','DIL','900000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261011-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-04521','MIL','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz cwe 14 crom putih doff semprot','grf Arsyal 22-11-2026','font Berkshire zircon 3','0','0','30000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0014','2026-10-11','2026-10-11 13:07:41','PESANAN : DP-04521','.','TBC','1464000','1464000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0015','D','2026-10-11','13:07:41','TBC','PESANAN','DP-04521','29203991964','1464000','29205455964','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-04521','2026-10-11','2026-10-11','13:07:41','PLG0017219','MIL','2026-11-07','kasirbip','2026-10-11 13:07:41','3.000','0','0','0','1464000','0','750000','1830000','1830000','366000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-11 ','13:07:58'); 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-04522','KUR','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','cwo YL-01 sz 19 grf Rika','cwe SR-01 sz 12.5 grf Ikbal','font keduanya berkshire swash','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0015','2026-10-11','2026-10-11 13:08:59','PESANAN : DP-04522','.','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-261011-0016','D','2026-10-11','13:08:59','TBC','PESANAN','DP-04522','29205455964','950000','29206405964','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-04522','2026-10-11','2026-10-11','13:08:59','PLG0017220','KUR','2026-10-30','kasirbip','2026-10-11 13:08:59','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-04523','MIL','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz cwo 18 crom putih doff semprot','grf Rahma 22-11-2026','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-261011-0016','2026-10-11','2026-10-11 13:10:02','PESANAN : DP-04523','.','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-261011-0017','D','2026-10-11','13:10:02','TBC','PESANAN','DP-04523','29206405964','1440000','29207845964','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-04523','2026-10-11','2026-10-11','13:10:02','PLG0017221','MIL','2026-11-07','kasirbip','2026-10-11 13:10:02','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000'); 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-04524','MIL','1','PER','WEDRING PROMO','','','3.000','','952.00','1','100000','0','850000','0','850000','sz cwe 11 grf Daffa 01-11-26','sz cwo 15 grf Sitdar 01-11-26','font vintage. EXPRESS 100.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0017','2026-10-11','2026-10-11 13:29:44','PESANAN : DP-04524','.','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-261011-0018','D','2026-10-11','13:29:44','TBC','PESANAN','DP-04524','29207845964','850000','29208695964','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-04524','2026-10-11','2026-10-11','13:29:44','PLG0017222','MIL','2026-10-23','kasirbip','2026-10-11 13:29:44','3.000','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04525','PUT','1','GOLD','WEDRING','','','2.000','','50.00','1','2300000','1800000','0','850000','4450000','sz cwe 9 crom putih glosy','grf Ali Akbar font Berkshire','jngn lbih 2gr zircon 14','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-261011-0018','2026-10-11','2026-10-11 13:36:12','PESANAN : DP-04525','.','TBC','3672000','3672000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0019','D','2026-10-11','13:36:12','TBC','PESANAN','DP-04525','29208695964','3672000','29212367964','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-04525','2026-10-11','2026-10-11','13:36:12','PLG0017223','PUT','2026-11-07','kasirbip','2026-10-11 13:36:12','2.000','0','0','0','3672000','0','850000','4590000','4590000','918000'); 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-04526','PUT','1','PLD','WEDRING','','','2.500','','25.00','1','1200000','550000','0','700000','2075000','sz cwo 17 crom putih doff semprot','grf Iis Yuningsih font Berkshire','permata di hilang kan','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-261011-0019','2026-10-11','2026-10-11 13:38:12','PESANAN : DP-04526','.','TBC','1660000','1660000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0020','D','2026-10-11','13:38:12','TBC','PESANAN','DP-04526','29212367964','1660000','29214027964','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-04526','2026-10-11','2026-10-11','13:38:12','PLG0017224','PUT','2026-11-07','kasirbip','2026-10-11 13:38:12','2.500','0','0','0','1660000','0','700000','2075000','2075000','415000'); 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-261011-0008','kasirbip','1',' 750K-165-2','TOKO','BIPPER','PBDG-ZHBH-21-0','CINCIN SILVER 925 ','','1.730','1','100.00','177000','0','0','17800','900000','0','0','0','900000','KUR','00046611','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHBH-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.730',berat_jual_asli=berat_jual_asli+'1.730',stock_jual='1',berat_akhir=berat_akhir-'1.730',berat_akhir_asli=berat_akhir_asli-'1.730',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PBDG-ZHBH-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0008','2026-10-11','1.730','2026-10-11','13:43:42','PLG0017225','900000','900000','0','900000','0','kasirbip','2026-10-11 13:43:41','FJ-261011-0008','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0008','2026-10-11','13:43:42','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-261011-0020','2026-10-11','2026-10-11 13:43:41','PENJUALAN : FJ-261011-0008','.','TBC','900000','900000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0021','D','2026-10-11','13:43:42','TBC','PENJUALAN','FJ-261011-0008','29214027964','900000','29214927964','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-261011-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-261011-0009','kasirbip','1',' DP-04103DU','TOKO','DUPSN','PSPRT-ZJXH-16-0','CINCIN PERAK SR03 YL01 ','','3.200','1','100.00','327000','0','0','17800','950000','0','0','0','950000','PUT','00048038','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXH-16-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPRT-ZJXH-16-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-261011-0009','2026-10-11','3.200','2026-10-11','13:49:39','PLG0017226','950000','950000','0','950000','0','kasirbip','2026-10-11 13:49:38','FJ-261011-0009','DP-04103','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-11','FJ-261011-0009','2026-10-11','13:49:39','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-261011-0009' LIMIT 1; UPDATE tt_service_head SET tgl_selesai='2026-10-11', status ='DONE' WHERE no_service='SV-02266'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02266'; 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-11', status ='CLOS' WHERE no_service='SV-02266'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02266'; 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-261011-0010','kasir','1',' 800K-17-11','TOKO','MMPER','PMM-ZHAB-15-0','CINCIN SILVER 925 ','','3.600','1','100.00','368000','0','0','17800','900000','0','0','0','900000','ELLA','00046064','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZHAB-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.600',berat_jual_asli=berat_jual_asli+'3.600',stock_jual='1',berat_akhir=berat_akhir-'3.600',berat_akhir_asli=berat_akhir_asli-'3.600',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PMM-ZHAB-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0010','2026-10-11','3.600','2026-10-11','14:16:52','PLG0017227','900000','900000','0','900000','0','kasir','2026-10-11 14:16:51','FJ-261011-0010','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0010','2026-10-11','14:16:52','ELLA','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261011-0021','2026-10-11','2026-10-11 14:16:51','PENJUALAN : FJ-261011-0010','0','TBC','900000','900000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0022','D','2026-10-11','14:16:52','TBC','PENJUALAN','FJ-261011-0010','29214927964','900000','29215827964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261011-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-04527','ALIKA','1','GOLD','WEDDING RING','','','2.500','','375.00','1','2300000','1400000','0','700000','4200000','size 13 grf','zircone 1 butir','warna crom putih doff semprot','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0022','2026-10-11','2026-10-11 14:26:53','PESANAN : DP-04527','0','TBC','3360000','3360000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0023','D','2026-10-11','14:26:53','TBC','PESANAN','DP-04527','29215827964','3360000','29219187964','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-04527','2026-10-11','2026-10-11','14:26:53','PLG0017228','ALIKA','2026-11-09','kasir','2026-10-11 14:26:53','2.500','0','0','0','3360000','0','700000','4200000','4200000','840000'); 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-261011-0011','kasirbip','1',' DP-04115BI','TOKO','BIPPSN','PSPLT-ZJXH-12-0','CINCIN PALADIUM ','','2.400','1','17.00','539000','0','0','17800','2750000','0','0','0','2750000','SULIS','00048034','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXH-12-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPLT-ZJXH-12-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-261011-0011','2026-10-11','2.400','2026-10-11','14:28:28','PLG0017229','2750000','2750000','0','2750000','0','kasirbip','2026-10-11 14:28:27','FJ-261011-0011','DP-04115','2228000'); 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-11','FJ-261011-0011','2026-10-11','14:28:28','SULIS','2750000','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-261011-0023','2026-10-11','2026-10-11 14:28:27','PENJUALAN : FJ-261011-0011','.','TMR','522000','522000','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-261011-0002','D','2026-10-11','14:28:28','TMR','PENJUALAN','FJ-261011-0011','31400000','522000','31922000','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='522000' WHERE no_faktur_jual='FJ-261011-0011' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261011-0012','kasirbip',' 1',' DP-04116BI','TOKO','BIPPSN','PSPLT-ZJXH-4-0','CINCIN PALADIUM ','','2.540','1','17.00','571000','0','0','17800','1639000','0','0','0','1639000','SULIS','00048026','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXH-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.540',berat_jual_asli=berat_jual_asli+'2.540',stock_jual='1',berat_akhir=berat_akhir-'2.540',berat_akhir_asli=berat_akhir_asli-'2.540',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPLT-ZJXH-4-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-261011-0012','2026-10-11','2.540','2026-10-11','14:28:28','PLG0017230','1639000','1639000','0','1639000','0','kasirbip','2026-10-11 14:28:27','FJ-261011-0011','DP-04116','1300000'); 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-11','FJ-261011-0012','2026-10-11','14:28:28','SULIS','1639000','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-261011-0024','2026-10-11','2026-10-11 14:28:27','PENJUALAN : FJ-261011-0012','.','TMR','339000','339000','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-261011-0003','D','2026-10-11','14:28:28','TMR','PENJUALAN','FJ-261011-0012','31922000','339000','32261000','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='861000' WHERE no_faktur_jual='FJ-261011-0012' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-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-04528','ALIKA','1','PER','WEDDING RING','','','4.000','','925.00','1','100000','0','0','0','950000','size 21 grf Fanny ?? Ozama','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-261011-0025','2026-10-11','2026-10-11 14:30:14','PESANAN : DP-04528','0','TBC','950000','950000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0024','D','2026-10-11','14:30:14','TBC','PESANAN','DP-04528','29219187964','950000','29220137964','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-04528','2026-10-11','2026-10-11','14:30:14','PLG0017231','ALIKA','2026-11-09','kasir','2026-10-11 14:30:14','4.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02286','SAL','1','CCN SILVER DAN PALADIUM','CWE KROM PUTIH GLOSSY CWO KROM PUTUH DOFF AMPLAS','4.000','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-261011-0026','2026-10-11','2026-10-11 14:32:51','SERVICE : SV-02286','.','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-261011-0025','D','2026-10-11','14:32:51','TBC','SERVICE','SV-02286','29220137964','100000','29220237964','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-02286','2026-10-11','2026-10-11','14:32:51','PLG0017232','kasirbip','2026-10-27','kasirbip','2026-10-11 14:32:51','4.000','0','0','0','100000','0','100000','100000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-11 ','14:33:01'); 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-261011-0013','jogja','1',' DP-04120JO','TOKO','JOGPSN','PSPRT-ZJXF-19-0','CINCIN PERAK CM01 YL01 ','','3.880','1','100.00','396000','0','0','17800','1300000','0','0','0','1300000','ADL','00047947','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXF-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.880',berat_jual_asli=berat_jual_asli+'3.880',stock_jual='1',berat_akhir=berat_akhir-'3.880',berat_akhir_asli=berat_akhir_asli-'3.880',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPRT-ZJXF-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0013','2026-10-11','3.880','2026-10-11','14:35:44','PLG0017233','1300000','1300000','0','1300000','0','jogja','2026-10-11 14:35:44','FJ-261011-0013','DP-04120','1300000'); 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-11','FJ-261011-0013','2026-10-11','14:35:44','ADL','1300000','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-261011-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-261011-0014','kasirbip','1',' DP-04023DU','TOKO','DUPSN','PSGT-ZJXG-43-0','CINCIN EMAS ','','2.550','1','57.00','3411000','0','0','17800','5290000','0','0','0','5290000','PUT','00048004','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXG-43-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-11' AND kode_barang='PSGT-ZJXG-43-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-261011-0014','2026-10-11','2.550','2026-10-11','14:36:52','PLG0017234','5290000','5290000','0','5290000','0','kasirbip','2026-10-11 14:36:51','FJ-261011-0014','DP-04023','4160000'); 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-11','FJ-261011-0014','2026-10-11','14:36:52','PUT','5290000','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-261011-0027','2026-10-11','2026-10-11 14:36:51','PENJUALAN : FJ-261011-0014','.','TBC','1130000','1130000','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-261011-0026','D','2026-10-11','14:36:52','TBC','PENJUALAN','FJ-261011-0014','29220237964','1130000','29221367964','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='1130000' WHERE no_faktur_jual='FJ-261011-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-261011-0015','kasirbip',' 1',' DP-04026DU','TOKO','DUPSN','PSPLT-ZJXF-15-0','CINCIN PALADIUM ','','2.950','1','32.00','1247000','0','0','17800','2322500','0','0','0','2322500','PUT','00047943','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXF-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPLT-ZJXF-15-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-261011-0015','2026-10-11','2.950','2026-10-11','14:36:52','PLG0017235','2322500','2322500','0','2322500','0','kasirbip','2026-10-11 14:36:51','FJ-261011-0014','DP-04026','1880000'); 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-11','FJ-261011-0015','2026-10-11','14:36:52','PUT','2322500','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-261011-0028','2026-10-11','2026-10-11 14:36:51','PENJUALAN : FJ-261011-0015','.','TBC','442500','442500','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-261011-0027','D','2026-10-11','14:36:52','TBC','PENJUALAN','FJ-261011-0015','29221367964','442500','29221810464','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='1572500' WHERE no_faktur_jual='FJ-261011-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0015'; 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-261011-0016','kasirbip','1',' 500K-16-30','TOKO','BIPPER','PBDG-ZJXI-34-0','CINCIN SILVER 925 YL01 ','','1.840','1','100.00','188000','0','0','17800','500000','0','0','0','500000','SAL','00048080','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZJXI-34-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.840',berat_jual_asli=berat_jual_asli+'1.840',stock_jual='1',berat_akhir=berat_akhir-'1.840',berat_akhir_asli=berat_akhir_asli-'1.840',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PBDG-ZJXI-34-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0016','2026-10-11','1.840','2026-10-11','14:51:10','PLG0017236','500000','500000','0','500000','0','kasirbip','2026-10-11 14:51:09','FJ-261011-0016','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0016','2026-10-11','14:51:10','SAL','500000','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-261011-0029','2026-10-11','2026-10-11 14:51:09','PENJUALAN : FJ-261011-0016','.','TBC','500000','500000','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-261011-0028','D','2026-10-11','14:51:10','TBC','PENJUALAN','FJ-261011-0016','29221810464','500000','29222310464','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='500000' WHERE no_faktur_jual='FJ-261011-0016' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261011-0017','kasirbip',' 1',' 750K-11-28','TOKO','BIPPER','PBDG-ZGAF-6-0','CINCIN SILVER 925 SR-04 ','','1.080','1','100.00','111000','0','0','17800','550000','0','0','0','550000','SAL','00045224','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGAF-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PBDG-ZGAF-6-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-261011-0017','2026-10-11','1.080','2026-10-11','14:51:10','PLG0017237','550000','550000','0','550000','0','kasirbip','2026-10-11 14:51:09','FJ-261011-0016','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0017','2026-10-11','14:51:10','SAL','550000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261011-0030','2026-10-11','2026-10-11 14:51:09','PENJUALAN : FJ-261011-0017','.','TBC','550000','550000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0029','D','2026-10-11','14:51:10','TBC','PENJUALAN','FJ-261011-0017','29222310464','550000','29222860464','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-261011-0017' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0017'; 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-04529','KUR','1','GOLD','WED RING','','','1.500','','37.50','1','2300000','1400000','0','700000','2800000','sz 8 putih doff semprot 1 zirkon','font yeseva one grf Firza','model persis seprrti contoh','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0031','2026-10-11','2026-10-11 15:13:50','PESANAN : DP-04529','.','TBC','2240000','2240000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0030','D','2026-10-11','15:13:50','TBC','PESANAN','DP-04529','29222860464','2240000','29225100464','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-04529','2026-10-11','2026-10-11','15:13:50','PLG0017238','KUR','2026-11-10','kasirbip','2026-10-11 15:13:50','1.500','0','0','0','2240000','0','700000','2800000','2800000','560000'); 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-04530','MIL','1','PLD','WEDRING','','','2.500','','25.00','1','1200000','550000','0','900000','2275000','sz cwe 18.5 crom putih glosy','grf Mirza font Vintage','zircon 10 EXPRESS 200.000','0','0','100000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0032','2026-10-11','2026-10-11 15:15:11','PESANAN : DP-04530','.','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-261011-0031','D','2026-10-11','15:15:11','TBC','PESANAN','DP-04530','29225100464','1900000','29227000464','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-04530','2026-10-11','2026-10-11','15:15:11','PLG0017239','MIL','2026-10-16','kasirbip','2026-10-11 15:15:11','2.500','0','0','0','1900000','0','900000','2375000','2375000','475000'); 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-04531','KUR','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','700000','2100000','sz 18.5 putih doff semprot','font yeseva one grf Novi','model dibuat persis seperti contoh lebar dan tebalnya','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0033','2026-10-11','2026-10-11 15:16:10','PESANAN : DP-04531','.','TBC','1680000','1680000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0032','D','2026-10-11','15:16:10','TBC','PESANAN','DP-04531','29227000464','1680000','29228680464','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-04531','2026-10-11','2026-10-11','15:16:10','PLG0017240','KUR','2026-11-10','kasirbip','2026-10-11 15:16:10','4.000','0','0','0','1680000','0','700000','2100000','2100000','420000'); 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-04532','MIL','1','PLD','WEDRING','','','2.500','','25.00','1','1200000','550000','0','750000','2125000','sz cwo 13 crom putih doff semprot','grf Orn font Vintage','EXPRESS 200.000','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0034','2026-10-11','2026-10-11 15:17:34','PESANAN : DP-04532','.','TBC','1700000','1700000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0033','D','2026-10-11','15:17:34','TBC','PESANAN','DP-04532','29228680464','1700000','29230380464','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-04532','2026-10-11','2026-10-11','15:17:34','PLG0017241','MIL','2026-10-16','kasirbip','2026-10-11 15:17:34','2.500','0','0','0','1700000','0','750000','2125000','2125000','425000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-11 ','15:26:28'); 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-261011-0018','sby','1',' 800K-24-00','TOKO','SBYPER','PSBY-ZJXG-25-0','CINCIN SILVER 925 YL10 ','','5.030','1','100.00','514000','0','0','17800','900000','0','0','0','900000','VAN','00047986','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZJXG-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.030',berat_jual_asli=berat_jual_asli+'5.030',stock_jual='1',berat_akhir=berat_akhir-'5.030',berat_akhir_asli=berat_akhir_asli-'5.030',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSBY-ZJXG-25-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-261011-0018','2026-10-11','5.030','2026-10-11','15:31:05','PLG0017242','900000','900000','0','900000','0','sby','2026-10-11 15:31:05','FJ-261011-0018','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0018','2026-10-11','15:31:05','VAN','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-261011-0035','2026-10-11','2026-10-11 15:31:05','PENJUALAN : FJ-261011-0018','','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-261011-0034','D','2026-10-11','15:31:05','TBC','PENJUALAN','FJ-261011-0018','29230380464','900000','29231280464','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-261011-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-04533','ELLA','1','PLD','WEDDING RING','','','5.000','','10.00','1','1200000','350000','0','800000','2550000','size 20 grf Syarif ?? Citra','warna crom putih full glosy','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-261011-0036','2026-10-11','2026-10-11 15:43:04','PESANAN : DP-04533','0','TBC','2040000','2040000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0035','D','2026-10-11','15:43:04','TBC','PESANAN','DP-04533','29231280464','2040000','29233320464','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-04533','2026-10-11','2026-10-11','15:43:04','PLG0017243','ELLA','2026-11-09','kasir','2026-10-11 15:43:04','5.000','0','0','0','2040000','0','800000','2550000','2550000','510000'); 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-04534','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 20 putih doff semprot 1 zirkon','font vintage rotter frd Eva & Nyanyang...','model dibuat persis seprti contoh lebar dan tebalnya','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0037','2026-10-11','2026-10-11 15:43:37','PESANAN : DP-04534','.','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-261011-0036','D','2026-10-11','15:43:37','TBC','PESANAN','DP-04534','29233320464','900000','29234220464','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-04534','2026-10-11','2026-10-11','15:43:37','PLG0017244','SAL','2026-11-08','kasirbip','2026-10-11 15:43:37','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-04535','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1100000','0','1100000','sz 9.5 putih glossy kanan 7 kiri 7 zirkon','font vintage rotter grf Eva & Nyanyang...','permata tengah dibuat 1 zirkon','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0038','2026-10-11','2026-10-11 15:46:20','PESANAN : DP-04535','.','TBC','1100000','1100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0037','D','2026-10-11','15:46:20','TBC','PESANAN','DP-04535','29234220464','1100000','29235320464','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-04535','2026-10-11','2026-10-11','15:46:20','PLG0017245','SAL','2026-11-08','kasirbip','2026-10-11 15:46:20','2.000','0','0','0','1100000','0','0','1100000','1100000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04536','ALIKA','1','PER','WEDDING RING','','','5.000','','925.00','1','100000','0','0','0','900000','size 28 grf Rini Oktaviani','warna crom putih full glosy sesuai model','tanpa permata','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0039','2026-10-11','2026-10-11 15:47:31','PESANAN : DP-04536','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-261011-0038','D','2026-10-11','15:47:31','TBC','PESANAN','DP-04536','29235320464','900000','29236220464','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-04536','2026-10-11','2026-10-11','15:47:31','PLG0017246','ALIKA','2026-11-09','kasir','2026-10-11 15:47:31','5.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-04537','MIL','1','PER','WEDRING','','','3.500','','925.00','1','100000','0','950000','0','950000','sz cwo 16 crom putih glosy','grf Novi 13.12.26 font Vintage','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0040','2026-10-11','2026-10-11 15:48:58','PESANAN : DP-04537','.','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-261011-0039','D','2026-10-11','15:48:58','TBC','PESANAN','DP-04537','29236220464','950000','29237170464','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-04537','2026-10-11','2026-10-11','15:48:58','PLG0017247','MIL','2026-11-07','kasirbip','2026-10-11 15:48:58','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-04538','PUT','1','PER','WEDRING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz cwe 10 crom putih glosy','grf Azis 13.12.26 font Vintage','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0041','2026-10-11','2026-10-11 15:50:23','PESANAN : DP-04538','.','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-261011-0040','D','2026-10-11','15:50:23','TBC','PESANAN','DP-04538','29237170464','850000','29238020464','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-04538','2026-10-11','2026-10-11','15:50:23','PLG0017248','PUT','2026-11-07','kasirbip','2026-10-11 15:50:23','2.000','0','0','0','850000','0','0','850000','850000','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0018'; 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-04539','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','950000','2000000','sz 13.5 putih glosy 18 zircon','font berkshire swash grf Fajar','','180000','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0042','2026-10-11','2026-10-11 16:08:47','PESANAN : DP-04539','.','TBC','1740000','1740000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0041','D','2026-10-11','16:08:47','TBC','PESANAN','DP-04539','29238020464','1740000','29239760464','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-04539','2026-10-11','2026-10-11','16:08:47','PLG0017249','KUR','2026-11-11','kasirbip','2026-10-11 16:08:47','3.000','0','0','0','1740000','0','950000','2180000','2180000','440000'); 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-04540','KUR ','1','PLD','WED RING','','','3.500','','10.00','1','1200000','350000','0','800000','2025000','sz 16 putih glosy tanpa mata','font berkshire swash grf Arimbi','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0043','2026-10-11','2026-10-11 16:10:49','PESANAN : DP-04540','.','TBC','1620000','1620000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0042','D','2026-10-11','16:10:49','TBC','PESANAN','DP-04540','29239760464','1620000','29241380464','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-04540','2026-10-11','2026-10-11','16:10:49','PLG0017250','KUR ','2026-11-11','kasirbip','2026-10-11 16:10:49','3.500','0','0','0','1620000','0','800000','2025000','2025000','405000'); 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-04541','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','650000','0','650000','sz 26 putih doff amplass','font yeseva one grf Chelsea','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0044','2026-10-11','2026-10-11 16:21:37','PESANAN : DP-04541','.','TBC','650000','650000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0043','D','2026-10-11','16:21:37','TBC','PESANAN','DP-04541','29241380464','650000','29242030464','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-04541','2026-10-11','2026-10-11','16:21:37','PLG0017251','SAL','2026-11-10','kasirbip','2026-10-11 16:21:37','2.000','0','0','0','650000','0','0','650000','650000','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-04542','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 11 putih doff semprot 1 zircon','font yeseva one grf Ryan','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0045','2026-10-11','2026-10-11 16:23:17','PESANAN : DP-04542','.','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-261011-0044','D','2026-10-11','16:23:17','TBC','PESANAN','DP-04542','29242030464','850000','29242880464','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-04542','2026-10-11','2026-10-11','16:23:17','PLG0017252','SAL','2026-11-11','kasirbip','2026-10-11 16:23:17','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-261011-0019','kasirbip','1',' DP-03934BI','TOKO','BIPPSN','PSGT-ZJXE-3-0','CINCIN EMAS ','','2.040','1','83.00','3973000','0','0','17800','5560000','0','0','0','5560000','SAL','00047888','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXE-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSGT-ZJXE-3-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-261011-0019','2026-10-11','2.040','2026-10-11','16:31:11','PLG0017253','5560000','5560000','0','5560000','0','kasirbip','2026-10-11 16:31:11','FJ-261011-0019','DP-03934','4376000'); 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-11','FJ-261011-0019','2026-10-11','16:31:11','SAL','5560000','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-261011-0046','2026-10-11','2026-10-11 16:31:11','PENJUALAN : FJ-261011-0019','.','TBC','1184000','1184000','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-261011-0045','D','2026-10-11','16:31:11','TBC','PENJUALAN','FJ-261011-0019','29242880464','1184000','29244064464','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='1184000' WHERE no_faktur_jual='FJ-261011-0019' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261011-0020','kasirbip',' 1',' DP-03933BI','TOKO','BIPPSN','PSPLT-ZJXE-6-0','CINCIN PALADIUM ','','3.470','1','17.00','779000','0','0','17800','2014500','0','0','0','2014500','SAL','00047891','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXE-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.470',berat_jual_asli=berat_jual_asli+'3.470',stock_jual='1',berat_akhir=berat_akhir-'3.470',berat_akhir_asli=berat_akhir_asli-'3.470',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPLT-ZJXE-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-261011-0020','2026-10-11','3.470','2026-10-11','16:31:11','PLG0017254','2014500','2014500','0','2014500','0','kasirbip','2026-10-11 16:31:11','FJ-261011-0019','DP-03933','1620000'); 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-11','FJ-261011-0020','2026-10-11','16:31:11','SAL','2014500','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-261011-0047','2026-10-11','2026-10-11 16:31:11','PENJUALAN : FJ-261011-0020','.','TBC','394500','394500','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-261011-0046','D','2026-10-11','16:31:11','TBC','PENJUALAN','FJ-261011-0020','29244064464','394500','29244458964','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='1578500' WHERE no_faktur_jual='FJ-261011-0020' LIMIT 1; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-11', status ='CLOS' WHERE no_service='SV-02284'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02284'; 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-261011-0021','kasirbip','1',' 500K-135-2','TOKO','BIPPER','PBDG-ZHBF-14-0','CINCIN SILVER 925 YL01 ','','1.750','1','100.00','179000','0','0','17800','550000','0','0','0','550000','SULIS','00046520','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHBF-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PBDG-ZHBF-14-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-261011-0021','2026-10-11','1.750','2026-10-11','17:06:50','PLG0017255','550000','550000','0','550000','0','kasirbip','2026-10-11 17:06:49','FJ-261011-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-11','FJ-261011-0021','2026-10-11','17:06:50','SULIS','550000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261011-0048','2026-10-11','2026-10-11 17:06:49','PENJUALAN : FJ-261011-0021','.','TBC','550000','550000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0047','D','2026-10-11','17:06:50','TBC','PENJUALAN','FJ-261011-0021','29244458964','550000','29245008964','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='550000' WHERE no_faktur_jual='FJ-261011-0021' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261011-0022','kasirbip',' 1',' 700K-135-2','TOKO','BIPPER','PBDG-ZCXC-8-0','CINCIN SILVER 925 ','','1.390','1','100.00','142000','0','0','17800','500000','0','0','0','500000','SULIS','00042151','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZCXC-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PBDG-ZCXC-8-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-261011-0022','2026-10-11','1.390','2026-10-11','17:06:50','PLG0017256','500000','500000','0','500000','0','kasirbip','2026-10-11 17:06:49','FJ-261011-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-11','FJ-261011-0022','2026-10-11','17:06:50','SULIS','500000','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-261011-0049','2026-10-11','2026-10-11 17:06:49','PENJUALAN : FJ-261011-0022','.','TBC','500000','500000','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-261011-0048','D','2026-10-11','17:06:50','TBC','PENJUALAN','FJ-261011-0022','29245008964','500000','29245508964','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-261011-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-261011-0023','jogja','1',' DP-04334JO','TOKO','JOGPSN','PSPRT-ZJXG-61-0','CINCIN PERAK YL01 ','','3.220','1','100.00','329000','0','0','17800','850000','0','0','0','850000','ADL','00048022','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXG-61-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.220',berat_jual_asli=berat_jual_asli+'3.220',stock_jual='1',berat_akhir=berat_akhir-'3.220',berat_akhir_asli=berat_akhir_asli-'3.220',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPRT-ZJXG-61-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0023','2026-10-11','3.220','2026-10-11','17:25:23','PLG0017257','850000','850000','0','850000','0','jogja','2026-10-11 17:25:23','FJ-261011-0023','DP-04334','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-11','FJ-261011-0023','2026-10-11','17:25:23','ADL','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261011-0023' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-11 ','17:26: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-261011-0024','sby','1',' DP-04072SB','TOKO','SBYPSN','PSBRT-ZJXF-23-0','CINCIN BERLIAN ','','2.500','1','83.00','6105000','777500','44','17800','7625000','0','0','0','7625000','DIL','00047951','PSBRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBRT-ZJXF-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSBRT-ZJXF-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0024','2026-10-11','2.500','2026-10-11','17:30:23','PLG0017258','7625000','7625000','0','7625000','0','sby','2026-10-11 17:30:22','FJ-261011-0024','DP-04072','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-11','FJ-261011-0024','2026-10-11','17:30:23','DIL','7625000','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-261011-0050','2026-10-11','2026-10-11 17:30:22','PENJUALAN : FJ-261011-0024','','TBC','2625000','2625000','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-261011-0049','D','2026-10-11','17:30:23','TBC','PENJUALAN BERLIAN','FJ-261011-0024','29245508964','2625000','29248133964','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='2625000' WHERE no_faktur_jual='FJ-261011-0024' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04543','ADL','1','GOLD','WEDDRING','','','3.500','','75.00','1','2300000','2250000','0','950000','8825000','sz cwe 13 lebar 3mm','gf vintage : Ika...Eryan','zircon 10','0','0','100000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0051','2026-10-11','2026-10-11 17:51:36','PESANAN : DP-04543','-','TBC','7140000','7140000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0050','D','2026-10-11','17:51:36','TBC','PESANAN','DP-04543','29248133964','7140000','29255273964','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-04543','2026-10-11','2026-10-11','17:51:36','PLG0017259','ADL','2026-11-02','jogja','2026-10-11 17:51:36','3.500','0','0','0','7140000','0','950000','8925000','8925000','1785000'); 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-04544','ADL','1','PLD','WEDDRING','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','sz cwo 18 lebar 4mm','gf vintage : Eryan...Ika','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0052','2026-10-11','2026-10-11 17:54:38','PESANAN : DP-04544','-','TBC','2400000','2400000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0051','D','2026-10-11','17:54:38','TBC','PESANAN','DP-04544','29255273964','2400000','29257673964','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-04544','2026-10-11','2026-10-11','17:54:38','PLG0017260','ADL','2026-11-02','jogja','2026-10-11 17:54:38','4.000','0','0','0','2400000','0','800000','3000000','3000000','600000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0024'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0023'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0021'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0019'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-11 ','18:33:02'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-11 ','18:34:49'); 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-261011-0025','sby','1',' DP-04025SB','TOKO','SBYPSN','PSPRT-ZJXB-20-0','CINCIN PERAK ','','2.280','1','100.00','234000','0','0','17800','850000','0','0','0','850000','VAN','00047839','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXB-20-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-11' AND kode_barang='PSPRT-ZJXB-20-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-261011-0025','2026-10-11','2.280','2026-10-11','18:35:49','PLG0017261','850000','850000','0','850000','0','sby','2026-10-11 18:35:48','FJ-261011-0025','DP-04025','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-11','FJ-261011-0025','2026-10-11','18:35:49','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-261011-0025' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261011-0026','sby',' 1',' DP-04028SB','TOKO','SBYPSN','PSPRT-ZJXB-62-0','CINCIN PERAK ','','2.060','1','100.00','211000','0','0','17800','1300000','0','0','0','1300000','VAN','00047881','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXB-62-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPRT-ZJXB-62-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-261011-0026','2026-10-11','2.060','2026-10-11','18:35:49','PLG0017262','1300000','1300000','0','1300000','0','sby','2026-10-11 18:35:48','FJ-261011-0025','DP-04028','1300000'); 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-11','FJ-261011-0026','2026-10-11','18:35:49','VAN','1300000','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-261011-0026' 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-04545','MIL','1','PLD','WEDRING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','sz cwo 15 crom putih doff semprot','grf Rini 11-10-2019','font comic','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0053','2026-10-11','2026-10-11 18:41:22','PESANAN : DP-04545','.','TBC','1480000','1480000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0052','D','2026-10-11','18:41:22','TBC','PESANAN','DP-04545','29257673964','1480000','29259153964','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-04545','2026-10-11','2026-10-11','18:41:22','PLG0017263','MIL','2026-10-21','kasirbip','2026-10-11 18:41:22','3.000','0','0','0','1480000','0','800000','1850000','1850000','370000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04546','DIL','1','PER','WEDD RING PRIA','','','3.000','','925.00','1','100000','0','900000','0','900000','PERMATA 1 BUTIR','SIZE 15.5 GRF: 08.11.26 ?? (BERKSHIRE)','PUTIH GLOSSY FULL','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-261011-0054','2026-10-11','2026-10-11 18:42:14','PESANAN : DP-04546','-','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-261011-0053','D','2026-10-11','18:42:14','TBC','PESANAN','DP-04546','29259153964','900000','29260053964','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-04546','2026-10-11','2026-10-11','18:42:14','PLG0017264','DIL','2026-11-03','sby','2026-10-11 18:42:14','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-04547','DIL','1','PER','WEDD RING WANITA','','','2.000','','925.00','1','100000','0','950000','0','950000','PERMATA 9 BUTIR','SIZE 11 GRF: 08.11.26 ?? (BERKSHIRE)','PUTIH GLOSSY FULL','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-261011-0055','2026-10-11','2026-10-11 18:45:37','PESANAN : DP-04547','-','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-261011-0054','D','2026-10-11','18:45:37','TBC','PESANAN','DP-04547','29260053964','950000','29261003964','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-04547','2026-10-11','2026-10-11','18:45:37','PLG0017265','DIL','2026-11-03','sby','2026-10-11 18:45:37','2.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04548','VAN','1','PER','WEDDRING PRIA','','','3.000','','925.00','1','100000','0','950000','0','950000','SIZE: 14','PUTIH DOFF MIX GLOSSY','TANPA UKIR','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-261011-0056','2026-10-11','2026-10-11 18:50:18','PESANAN : DP-04548','-','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-261011-0055','D','2026-10-11','18:50:18','TBC','PESANAN','DP-04548','29261003964','950000','29261953964','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-04548','2026-10-11','2026-10-11','18:50:18','PLG0017266','VAN','2026-11-05','sby','2026-10-11 18:50: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-04549','MIL ','1','GOLD','WEDRING','','','2.500','','37.50','1','2300000','1400000','0','850000','4350000','sz cwe 16 crom putih glosy','grf Ridzki 11-10-2019','EXPRESS 100.000 ZIRCON 9','0','','90000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0057','2026-10-11','2026-10-11 18:53:05','PESANAN : DP-04549','.','TBC','3552000','3552000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0056','D','2026-10-11','18:53:05','TBC','PESANAN','DP-04549','29261953964','3552000','29265505964','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-04549','2026-10-11','2026-10-11','18:53:05','PLG0017267','MIL ','2026-10-21','kasirbip','2026-10-11 18:53:05','2.500','0','0','0','3552000','0','850000','4440000','4440000','888000'); 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-20261011-0001','1','PSGT-ZJXI-29-0','1','5.000','5.000','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJXI-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJXI-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJXI-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXI-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-11 18:55:02' WHERE kode_barang='PSGT-ZJXI-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJXI-29-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-11 18:55:02','TOKO','SBYPSN','PSGT','PSGT-ZJXI-29-0','1','5.000','5.000','1','5.000','5.000','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJXI-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXI-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-11' 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-20261011-0001','1','PSPRT-ZJXI-30-0','1','5.000','5.000','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXI-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXI-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXI-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXI-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-11 18:55:02' WHERE kode_barang='PSPRT-ZJXI-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXI-30-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-11 18:55:02','TOKO','SBYPSN','PSPRT','PSPRT-ZJXI-30-0','1','5.000','5.000','1','5.000','5.000','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-ZJXI-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXI-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-11' 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-20261011-0001','1','PSPRT-ZJXI-31-0','1','1.280','1.280','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXI-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXI-31-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXI-31-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXI-31-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-11 18:55:03' WHERE kode_barang='PSPRT-ZJXI-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXI-31-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-11 18:55:03','TOKO','SBYPSN','PSPRT','PSPRT-ZJXI-31-0','1','1.280','1.280','1','1.280','1.280','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-ZJXI-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXI-31-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-11' 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-20261011-0001','1','PSPRT-ZJXI-32-0','1','3.970','3.970','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXI-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXI-32-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXI-32-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXI-32-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-11 18:55:03' WHERE kode_barang='PSPRT-ZJXI-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXI-32-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-11 18:55:03','TOKO','SBYPSN','PSPRT','PSPRT-ZJXI-32-0','1','3.970','3.970','1','3.970','3.970','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-ZJXI-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXI-32-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-11' 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-20261011-0001','1','PSPRT-ZJXI-33-0','1','4.910','4.910','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXI-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXI-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXI-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXI-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-11 18:55:03' WHERE kode_barang='PSPRT-ZJXI-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXI-33-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-11 18:55:03','TOKO','SBYPSN','PSPRT','PSPRT-ZJXI-33-0','1','4.910','4.910','1','4.910','4.910','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-ZJXI-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXI-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-11' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261011-0001','2026-10-11','18:53','20.160','sby','2026-10-11 18:55:02'); 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-261011-0027','kasir','1',' TFCMR75-84','TOKO','TFCINMAS','TFCMR-ZHBE-129-0','THIFA CINCIN MAS RG ','','1.390','1','84.00','2859000','0','0','17800','2950000','0','0','0','2950000','IQB','00046487','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-ZHBE-129-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.390',berat_jual_asli=berat_jual_asli+'1.390',stock_jual='1',berat_akhir=berat_akhir-'1.390',berat_akhir_asli=berat_akhir_asli-'1.390',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='TFCMR-ZHBE-129-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0027','2026-10-11','1.390','2026-10-11','19:01:16','PLG0017268','2950000','2950000','0','2950000','0','kasir','2026-10-11 19:01:16','FJ-261011-0027','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0027','2026-10-11','19:01:16','IQB','2950000','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-261011-0058','2026-10-11','2026-10-11 19:01:16','PENJUALAN : FJ-261011-0027','.','TBC','2950000','2950000','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-261011-0057','D','2026-10-11','19:01:16','TBC','PENJUALAN','FJ-261011-0027','29265505964','2950000','29268455964','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='2950000' WHERE no_faktur_jual='FJ-261011-0027' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04550','DIL','1','PLD','WEDD RING PRIA','','','4.000','','25.00','1','1200000','550000','0','700000','2900000','LEBAR 4MM','SIZE 17.5 GRF: Nanda ?? Rio (BERKSHIRE)','ROSE GOLD GLOSSY MIX PUTIH 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-261011-0059','2026-10-11','2026-10-11 19:05:32','PESANAN : DP-04550','-','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-261011-0058','D','2026-10-11','19:05:32','TBC','PESANAN','DP-04550','29268455964','2000000','29270455964','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-04550','2026-10-11','2026-10-11','19:05:32','PLG0017269','DIL','2026-11-05','sby','2026-10-11 19:05:32','4.000','0','0','0','2000000','0','700000','2900000','2900000','900000'); 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-261011-0028','kasirbip','1',' DP-03659DU','TOKO','DUPSN','PSGT-ZIBB-28-0','CINCIN EMAS ','','2.240','1','45.00','2365000','0','0','17800','4476000','0','0','0','4476000','PUT','00047461','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIBB-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSGT-ZIBB-28-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-261011-0028','2026-10-11','2.240','2026-10-11','19:06:43','PLG0017270','4476000','4476000','0','4476000','0','kasirbip','2026-10-11 19:06:42','FJ-261011-0028','DP-03659','3872000'); 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-11','FJ-261011-0028','2026-10-11','19:06:43','PUT','4476000','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-261011-0060','2026-10-11','2026-10-11 19:06:42','PENJUALAN : FJ-261011-0028','.','TBC','604000','604000','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-261011-0059','D','2026-10-11','19:06:43','TBC','PENJUALAN','FJ-261011-0028','29270455964','604000','29271059964','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='604000' WHERE no_faktur_jual='FJ-261011-0028' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261011-0029','kasirbip',' 1',' DP-03661DU','TOKO','DUPSN','PSPLT-ZIBB-36-0','CINCIN PALADIUM ','','2.140','1','17.00','481000','0','0','17800','1499000','0','0','0','1499000','PUT','00047469','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBB-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPLT-ZIBB-36-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-261011-0029','2026-10-11','2.140','2026-10-11','19:06:43','PLG0017271','1499000','1499000','0','1499000','0','kasirbip','2026-10-11 19:06:42','FJ-261011-0028','DP-03661','1440000'); 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-11','FJ-261011-0029','2026-10-11','19:06:43','PUT','1499000','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-261011-0061','2026-10-11','2026-10-11 19:06:42','PENJUALAN : FJ-261011-0029','.','TBC','59000','59000','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-261011-0060','D','2026-10-11','19:06:43','TBC','PENJUALAN','FJ-261011-0029','29271059964','59000','29271118964','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='663000' WHERE no_faktur_jual='FJ-261011-0029' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-11 ','19:10:15'); 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-04551','DIL','1','GOLD','WEDD RING WANITA','','','2.500','','50.00','1','2300000','1800000','0','750000','5250000','PERMATA 1 BUTIR','SIZE 23 GRF: Rio ?? Nanda (BERKSHIRE)','EMAS (FINISHING ROSE GOLD)','10000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0062','2026-10-11','2026-10-11 19:10:31','PESANAN : DP-04551','-','TBC','3500000','3500000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0061','D','2026-10-11','19:10:31','TBC','PESANAN','DP-04551','29271118964','3500000','29274618964','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-04551','2026-10-11','2026-10-11','19:10:31','PLG0017272','DIL','2026-10-25','sby','2026-10-11 19:10:31','2.500','0','0','0','3500000','0','750000','5260000','5260000','1760000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0027' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0027' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0027'; 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-261011-0030','kasir','1',' TFGRR75-88','TOKO','TFGLR','TFGRR-XGXH-44-0','THIFA GELANG RANTAI RG ','','2.510','1','88.00','5355000','0','0','17800','5550000','0','0','0','5550000','IQB','00029704','TFGRR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-XGXH-44-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.510',berat_jual_asli=berat_jual_asli+'2.510',stock_jual='1',berat_akhir=berat_akhir-'2.510',berat_akhir_asli=berat_akhir_asli-'2.510',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='TFGRR-XGXH-44-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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-261011-0030','2026-10-11','2.510','2026-10-11','19:15:18','PLG0017273','5550000','5550000','0','5550000','0','kasir','2026-10-11 19:15:17','FJ-261011-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-11','FJ-261011-0030','2026-10-11','19:15:18','IQB','5550000','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-261011-0063','2026-10-11','2026-10-11 19:15:17','PENJUALAN : FJ-261011-0030','.','TBC','5550000','5550000','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-261011-0062','D','2026-10-11','19:15:18','TBC','PENJUALAN','FJ-261011-0030','29274618964','5550000','29280168964','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='5550000' WHERE no_faktur_jual='FJ-261011-0030' 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-04552','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1050000','0','1050000','sz 17 putih glosy font vintage rotter','grf AW 25 10 26','express 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-261011-0064','2026-10-11','2026-10-11 19:16:27','PESANAN : DP-04552','.','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-261011-0063','D','2026-10-11','19:16:27','TBC','PESANAN','DP-04552','29280168964','1050000','29281218964','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-04552','2026-10-11','2026-10-11','19:16:27','PLG0017274','SULIS','2026-10-20','kasirbip','2026-10-11 19:16:27','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-04553','SULIS','1','PER','WED RING','','','3.000','','925.00','1','100000','0','950000','0','950000','sz 24.5 putih glosy','font vintage rotter grf WA 25 10 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-261011-0065','2026-10-11','2026-10-11 19:17:58','PESANAN : DP-04553','.','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-261011-0064','D','2026-10-11','19:17:58','TBC','PESANAN','DP-04553','29281218964','950000','29282168964','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-04553','2026-10-11','2026-10-11','19:17:58','PLG0017275','SULIS','2026-10-20','kasirbip','2026-10-11 19:17:58','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-261011-0031','kasirbip','1',' DP-04069DU','TOKO','DUPSN','PSGT-ZJXI-26-0','CINCIN EMAS ','','1.850','1','45.00','1954000','0','0','17800','3580000','0','0','0','3580000','PUT','00048072','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXI-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSGT-ZJXI-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261011-0031','2026-10-11','1.850','2026-10-11','19:18:28','PLG0017276','3580000','3580000','0','3580000','0','kasirbip','2026-10-11 19:18:28','FJ-261011-0031','DP-04069','3032000'); 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-11','FJ-261011-0031','2026-10-11','19:18:28','PUT','3580000','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-261011-0066','2026-10-11','2026-10-11 19:18:28','PENJUALAN : FJ-261011-0031','.','TBC','548000','548000','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-261011-0065','D','2026-10-11','19:18:28','TBC','PENJUALAN','FJ-261011-0031','29282168964','548000','29282716964','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='548000' WHERE no_faktur_jual='FJ-261011-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-261011-0032','kasirbip',' 1',' DP-04070DU','TOKO','DUPSN','PSPRT-ZJXI-28-0','CINCIN PERAK ','','3.190','1','100.00','326000','0','0','17800','900000','0','0','0','900000','PUT','00048074','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXI-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPRT-ZJXI-28-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-261011-0032','2026-10-11','3.190','2026-10-11','19:18:28','PLG0017277','900000','900000','0','900000','0','kasirbip','2026-10-11 19:18:28','FJ-261011-0031','DP-04070','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-11','FJ-261011-0032','2026-10-11','19:18:28','PUT','900000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='548000' WHERE no_faktur_jual='FJ-261011-0032' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi=''; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0030' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0030' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0030'; 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-04554','PUT','1','GOLD','WEDRING','','','2.000','','37.50','1','2300000','1400000','0','850000','3650000','sz cwe 14.5 crom putih glosy','grf Yoga Suwendo font Berkshire','zircon 9 jngn lbih 2gr','0','0','90000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0067','2026-10-11','2026-10-11 19:38:15','PESANAN : DP-04554','.','TBC','2992000','2992000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0066','D','2026-10-11','19:38:15','TBC','PESANAN','DP-04554','29282716964','2992000','29285708964','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-04554','2026-10-11','2026-10-11','19:38:15','PLG0017278','PUT','2026-11-07','kasirbip','2026-10-11 19:38:15','2.000','0','0','0','2992000','0','850000','3740000','3740000','748000'); 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-04555','PUT','1','PLD','WEDRING','','','3.500','','10.00','1','1200000','350000','0','750000','1975000','sz cwo 20 crom putih doff semprot','grf Rani Amalia font Berkshire','jngn lbih 3.5gr','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-261011-0068','2026-10-11','2026-10-11 19:39:53','PESANAN : DP-04555','.','TBC','1580000','1580000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0067','D','2026-10-11','19:39:53','TBC','PESANAN','DP-04555','29285708964','1580000','29287288964','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-04555','2026-10-11','2026-10-11','19:39:53','PLG0017279','PUT','2026-11-07','kasirbip','2026-10-11 19:39:53','3.500','0','0','0','1580000','0','750000','1975000','1975000','395000'); 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-261011-0033','kasirbip','1',' DP-04024BI','TOKO','BIPPSN','PSPRT-ZJXB-37-0','CINCIN PERAK ','','3.010','1','100.00','308000','0','0','17800','850000','0','0','0','850000','SAL','00047856','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXB-37-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSPRT-ZJXB-37-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-261011-0033','2026-10-11','3.010','2026-10-11','19:53:27','PLG0017280','850000','850000','0','850000','0','kasirbip','2026-10-11 19:53:26','FJ-261011-0033','DP-04024','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-11','FJ-261011-0033','2026-10-11','19:53:27','SAL','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-261011-0069','2026-10-11','2026-10-11 19:53:26','PENJUALAN : FJ-261011-0033','.','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-261011-0068','D','2026-10-11','19:53:27','TBC','PENJUALAN','FJ-261011-0033','29287288964','850000','29288138964','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-261011-0033' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261011-0034','kasirbip',' 1',' DP-04027BI','TOKO','BIPPSN','PSGT-ZJXB-6-0','CINCIN EMAS ','','2.200','1','45.00','2323000','0','0','17800','4000000','0','0','0','4000000','SAL','00047825','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXB-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='PSGT-ZJXB-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-261011-0034','2026-10-11','2.200','2026-10-11','19:53:27','PLG0017281','4000000','4000000','0','4000000','0','kasirbip','2026-10-11 19:53:26','FJ-261011-0033','DP-04027','2976000'); 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-11','FJ-261011-0034','2026-10-11','19:53:27','SAL','4000000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261011-0034' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0025' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0025' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0025'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0026' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0026' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0026'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0028' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0028' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0028'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0029' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0029' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0029'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0032' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0032' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0032'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0033' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0033' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0033'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0034' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0034' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0034'; 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-04556','DIL','1','PER','WEDD RING CUSTOM','','','3.000','','925.00','1','100000','0','950000','0','950000','SIZE 22.5 GRF: Mala ?? Obi (VINTAGE)','PUTIH GLOSSY FULL','','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-261011-0070','2026-10-11','2026-10-11 20:04:28','PESANAN : DP-04556','-','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-261011-0069','D','2026-10-11','20:04:28','TBC','PESANAN','DP-04556','29288138964','950000','29289088964','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-04556','2026-10-11','2026-10-11','20:04:28','PLG0017282','DIL','2026-11-05','sby','2026-10-11 20:04:28','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-261011-0035','kasirbip','1',' 800K-16-00','TOKO','DUPERBDG','LXPER-ZGXC-19-0','CINCIN SILVER 925 YL-10 ','','4.550','1','100.00','465000','0','0','17800','900000','0','0','0','900000','MIL','00044923','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGXC-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.550',berat_jual_asli=berat_jual_asli+'4.550',stock_jual='1',berat_akhir=berat_akhir-'4.550',berat_akhir_asli=berat_akhir_asli-'4.550',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='LXPER-ZGXC-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-261011-0035','2026-10-11','4.550','2026-10-11','20:14:21','PLG0017283','900000','900000','0','900000','0','kasirbip','2026-10-11 20:14:21','FJ-261011-0035','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','FJ-261011-0035','2026-10-11','20:14:21','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-261011-0071','2026-10-11','2026-10-11 20:14:21','PENJUALAN : FJ-261011-0035','.','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-261011-0070','D','2026-10-11','20:14:21','TBC','PENJUALAN','FJ-261011-0035','29289088964','900000','29289988964','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-261011-0035' 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-261011-0036','kasirbip','1',' 700K-9-001','TOKO','DUPERBDG','LXPER-ZCXB-40-0','CINCIN SILVER 925 ','','3.880','1','100.00','396000','0','0','17800','950000','0','0','0','950000','MIL','00042101','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZCXB-40-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.880',berat_jual_asli=berat_jual_asli+'3.880',stock_jual='1',berat_akhir=berat_akhir-'3.880',berat_akhir_asli=berat_akhir_asli-'3.880',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='LXPER-ZCXB-40-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-261011-0036','2026-10-11','3.880','2026-10-11','20:15:50','PLG0017284','950000','950000','0','950000','0','kasirbip','2026-10-11 20:15:49','FJ-261011-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-11','FJ-261011-0036','2026-10-11','20:15:50','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-261011-0072','2026-10-11','2026-10-11 20:15:49','PENJUALAN : FJ-261011-0036','.','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-261011-0071','D','2026-10-11','20:15:50','TBC','PENJUALAN','FJ-261011-0036','29289988964','950000','29290938964','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-261011-0036' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0035' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0035' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0035'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0036' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261011-0036' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261011-0036'; 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-04557','KUR','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1100000','0','1100000','sz 18 putih glosy 10 zirkon','font vintage rotter grf Syauqi','EXPRES 200.000','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261011-0073','2026-10-11','2026-10-11 21:48:17','PESANAN : DP-04557','.','TBC','1100000','1100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261011-0072','D','2026-10-11','21:48:17','TBC','PESANAN','DP-04557','29290938964','1100000','29292038964','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-04557','2026-10-11','2026-10-11','21:48:17','PLG0017285','KUR','2026-10-15','kasirbip','2026-10-11 21:48:17','2.000','0','0','0','1100000','0','0','1100000','1100000','0'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-12','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-11'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-11'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-11'; 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-11' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-11'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-11'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-11'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-11'; 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-12' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-11' 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-261012-0001','D','2026-10-12','21:54:39','TBC','SALDO AWAL','SALDO AWAL','0','29292038964','29292038964'); 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-261012-0001','D','2026-10-12','21:54:39','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261012-0001','D','2026-10-12','21:54:39','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-261012-0001','D','2026-10-12','21:54:39','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-261012-0001','D','2026-10-12','21:54:39','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-261012-0001','D','2026-10-12','21:54:39','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-261012-0001','D','2026-10-12','21:54:39','','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-261012-0001','D','2026-10-12','21:54:39','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-261012-0001','D','2026-10-12','21:54:39','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261012-0001','D','2026-10-12','21:54:39','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-261012-0001','D','2026-10-12','21:54:39','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-261012-0001','D','2026-10-12','21:54:39','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); UPDATE tp_system SET tgl_system='2026-10-12';