INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-10 ','10:58:07'); 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-20261010-0001','1','PSPRT-ZJXH-17-0','1','5.160','5.160','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXH-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXH-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXH-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-10 10:59:03' WHERE kode_barang='PSPRT-ZJXH-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXH-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-10 10:59:03','TOKO','JOGPSN','PSPRT','PSPRT-ZJXH-17-0','1','5.160','','1','5.160','','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-ZJXH-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' 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-20261010-0001','1','PSPRT-ZJXH-22-0','1','1.400','1.400','TOKO','JOGPSN','TOKO','JOGPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXH-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXH-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXH-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='JOGPSN',tgl_last_beli='2026-10-10 10:59:03' WHERE kode_barang='PSPRT-ZJXH-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXH-22-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-10 10:59:03','TOKO','JOGPSN','PSPRT','PSPRT-ZJXH-22-0','1','1.400','','1','1.400','','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-ZJXH-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261010-0001','2026-10-10','10:58','6.560','jogja','2026-10-10 10:59:03'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-10 ','11:10:51'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-10 ','11:26:36'); 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-261010-0001','kasirbip','1',' PLBDG-0016','TOKO','BIPPLD','PLBDG-ZJXB-29-0','CINCIN PALADIUM PLBDG-00167 ','','4.020','1','17.00','903000','0','0','17800','2200000','0','0','0','2200000','KUR','00047848','PLBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PLBDG-ZJXB-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PLBDG-ZJXB-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPLD' 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-261010-0001','2026-10-10','4.020','2026-10-10','11:27:35','PLG0017129','2200000','2200000','0','2200000','0','kasirbip','2026-10-10 11:27:35','FJ-261010-0001','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0001','2026-10-10','11:27:35','KUR','2200000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0001','2026-10-10','2026-10-10 11:27:35','PENJUALAN : FJ-261010-0001','.','TBC','2200000','2200000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0002','D','2026-10-10','11:27:35','TBC','PENJUALAN','FJ-261010-0001','29102067964','2200000','29104267964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2200000' WHERE no_faktur_jual='FJ-261010-0001' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0001'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0002','kasirbip','1',' 750K-13-29','TOKO','BIPPER','PBDG-ZIAF-27-0','CINCIN SILVER 925 ','','1.190','1','100.00','122000','0','0','17800','850000','0','0','0','850000','SULIS','00047259','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIAF-27-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.190',berat_jual_asli=berat_jual_asli+'1.190',stock_jual='1',berat_akhir=berat_akhir-'1.190',berat_akhir_asli=berat_akhir_asli-'1.190',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PBDG-ZIAF-27-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-261010-0002','2026-10-10','1.190','2026-10-10','12:10:48','PLG0017130','850000','850000','0','850000','0','kasirbip','2026-10-10 12:10:47','FJ-261010-0002','','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-10','FJ-261010-0002','2026-10-10','12:10:48','SULIS','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0002','2026-10-10','2026-10-10 12:10:47','PENJUALAN : FJ-261010-0002','.','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-261010-0003','D','2026-10-10','12:10:48','TBC','PENJUALAN','FJ-261010-0002','29104267964','850000','29105117964','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-261010-0002' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04480','SULIS','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 18.5 putih doff semprot','font vintage rotter EXPRESS 100.000','grf suaminya ade ...','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0003','2026-10-10','2026-10-10 12:47:58','PESANAN : DP-04480','.','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-261010-0004','D','2026-10-10','12:47:58','TBC','PESANAN','DP-04480','29105117964','900000','29106017964','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-04480','2026-10-10','2026-10-10','12:47:58','PLG0017131','SULIS','2026-10-20','kasirbip','2026-10-10 12:47:58','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00000390','X-00000390','CINCIN BDC-00108','GR','---','BDC','BELI','BELI001','4800000','2026-10-10','1.110','1','kasir','2026-10-10 12:54:36'); DELETE FROM tp_barang WHERE kode_dept = 'X-BDC'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-BDC','X-00000390','X-00000390'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261010-0001','FJ-260405-0012','FIR','1','BELI','BELI001','BDC', 'X-00000390', 'CINCIN BDC-00108','1.110','1.110','83.00','6000000','4800000','4324324','1','4800000','4800000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.110',berat_beli_asli=berat_beli_asli+'1.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.110',berat_akhir_asli=berat_akhir_asli+'1.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-10' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='BDC' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-261010-0001','2026-10-10','2026-10-10','12:54:35','FIR','---','1.110','4800000','4800000','4800000','4800000','4800000','kasir','2026-10-10 12:54:36','FB-261010-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261010-0001','NADIAH','JKT','','','08990981560','kasir','2026-10-10 12:54:36'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0004','2026-10-10','2026-10-10 12:54:36','PEMBELIAN UMUM : FB-261010-0001','.','TBC','4800000','4800000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-261010-0005','K','2026-10-10','12:54:35','TBC','PEMBELIAN UMUM','FB-261010-0001','29106017964','4800000','29101217964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261010-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261010-0001'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-10 ','13:01:33'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0002'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-10 ','13:24:08'); 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-04481','VAN','1','PLD','WEDDRING WANITA','','','4.000','','25.00','1','1200000','550000','0','800000','3000000','SIZE: 14','GRF: Rolista ?? Arengga Font: BERKSHIRE','PUTIH DOFF MIX GLOSSY','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0005','2026-10-10','2026-10-10 13:27:22','PESANAN : DP-04481','-','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-261010-0006','D','2026-10-10','13:27:22','TBC','PESANAN','DP-04481','29101217964','2000000','29103217964','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-04481','2026-10-10','2026-10-10','13:27:22','PLG0017132','VAN','2026-11-01','sby','2026-10-10 13:27:22','4.000','0','0','0','2000000','0','800000','3000000','3000000','1000000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-10 ','13:33:21'); 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-04482','PUT','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','sz cwe 8 crom putih glosy','grf AS .... SA font Berkshire','zircon 9','0','0','90000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0006','2026-10-10','2026-10-10 13:38:34','PESANAN : DP-04482','.','TBC','1372000','1372000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0007','D','2026-10-10','13:38:34','TBC','PESANAN','DP-04482','29103217964','1372000','29104589964','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-04482','2026-10-10','2026-10-10','13:38:34','PLG0017133','PUT','2026-11-09','kasirbip','2026-10-10 13:38:34','2.500','0','0','0','1372000','0','750000','1715000','1715000','343000'); 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-261010-0003','jogja','1',' 900K-13-00','TOKO','JOGPER','PJOG-ZFAA-32-0','CINCIN SILVER 925 ','','2.790','1','100.00','285000','0','0','17800','1000000','0','0','0','1000000','ADL','00044231','PJOG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PJOG-ZFAA-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.790',berat_jual_asli=berat_jual_asli+'2.790',stock_jual='1',berat_akhir=berat_akhir-'2.790',berat_akhir_asli=berat_akhir_asli-'2.790',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PJOG-ZFAA-32-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-261010-0003','2026-10-10','2.790','2026-10-10','13:38:58','PLG0017134','1000000','1000000','0','1000000','0','jogja','2026-10-10 13:38:57','FJ-261010-0003','','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-10','FJ-261010-0003','2026-10-10','13:38:58','ADL','1000000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0007','2026-10-10','2026-10-10 13:38:57','PENJUALAN : FJ-261010-0003','','TBC','1000000','1000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0008','D','2026-10-10','13:38:58','TBC','PENJUALAN','FJ-261010-0003','29104589964','1000000','29105589964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-261010-0003' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-10 ','13:39:58'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-10 ','13:40:44'); 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-04483','PUT','1','PLD','WEDRING','','','2.500','','10.00','1','1200000','350000','0','500000','1375000','sz cwo 16.5 YL.01','grf AS .... SA','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-261010-0008','2026-10-10','2026-10-10 13:42:38','PESANAN : DP-04483','.','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-261010-0009','D','2026-10-10','13:42:38','TBC','PESANAN','DP-04483','29105589964','1100000','29106689964','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-04483','2026-10-10','2026-10-10','13:42:38','PLG0017135','PUT','2026-11-09','kasirbip','2026-10-10 13:42:38','2.500','0','0','0','1100000','0','500000','1375000','1375000','275000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-10 ','13:45:29'); 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-261010-0004','kasirbip','1',' 850K-95-29','TOKO','BIPPER','PBDG-ZHBH-25-0','CINCIN SILVER 925 ','','1.270','1','100.00','130000','0','0','17800','950000','0','0','0','950000','KUR','00046615','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZHBH-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PBDG-ZHBH-25-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261010-0004','2026-10-10','1.270','2026-10-10','13:46:11','PLG0017136','950000','950000','0','950000','0','kasirbip','2026-10-10 13:46:11','FJ-261010-0004','','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-10','FJ-261010-0004','2026-10-10','13:46:11','KUR','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-261010-0009','2026-10-10','2026-10-10 13:46:11','PENJUALAN : FJ-261010-0004','.','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-261010-0010','D','2026-10-10','13:46:11','TBC','PENJUALAN','FJ-261010-0004','29106689964','950000','29107639964','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-261010-0004' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0005','kasirbip',' 1',' 800K-155-3','TOKO','BIPPER','PBDG-ZJXE-23-0','CINCIN SILVER 925 ','','3.640','1','100.00','372000','0','0','17800','900000','0','0','0','900000','KUR','00047908','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZJXE-23-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.640',berat_jual_asli=berat_jual_asli+'3.640',stock_jual='1',berat_akhir=berat_akhir-'3.640',berat_akhir_asli=berat_akhir_asli-'3.640',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PBDG-ZJXE-23-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-261010-0005','2026-10-10','3.640','2026-10-10','13:46:11','PLG0017137','900000','900000','0','900000','0','kasirbip','2026-10-10 13:46:11','FJ-261010-0004','','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-10','FJ-261010-0005','2026-10-10','13:46:11','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-261010-0010','2026-10-10','2026-10-10 13:46:11','PENJUALAN : FJ-261010-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-261010-0011','D','2026-10-10','13:46:11','TBC','PENJUALAN','FJ-261010-0005','29107639964','900000','29108539964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1850000' WHERE no_faktur_jual='FJ-261010-0005' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04484','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1000000','0','1000000','sz 11 putih glossy 19 zirkon','font berkshire swash grf Fauzan 12.12.26','model persis sprt 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-261010-0011','2026-10-10','2026-10-10 13:57:12','PESANAN : DP-04484','.','TBC','1000000','1000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0012','D','2026-10-10','13:57:12','TBC','PESANAN','DP-04484','29108539964','1000000','29109539964','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-04484','2026-10-10','2026-10-10','13:57:12','PLG0017138','SAL','2026-11-08','kasirbip','2026-10-10 13:57:12','2.000','0','0','0','1000000','0','0','1000000','1000000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04485','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','900000','0','900000','sz 13 putih doff semprot','font berkshire swash grf Rani 12.12.26','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0012','2026-10-10','2026-10-10 13:58:17','PESANAN : DP-04485','.','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-261010-0013','D','2026-10-10','13:58:17','TBC','PESANAN','DP-04485','29109539964','900000','29110439964','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-04485','2026-10-10','2026-10-10','13:58:17','PLG0017139','SAL','2026-11-08','kasirbip','2026-10-10 13:58:17','3.000','0','0','0','900000','0','0','900000','900000','0'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-10', status ='CLOS' WHERE no_service='SV-02253'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02253'; 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-04486','SULIS','1','PER','WED RING','','','2.000','','925.00','1','100000','0','850000','0','850000','sz 17.5 putih doff semprot 1 zircon','font yeseva one grf Gyna ... Krisna','express 100.000 permata jgn dibuat timbul','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0013','2026-10-10','2026-10-10 14:16:24','PESANAN : DP-04486','.','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-261010-0014','D','2026-10-10','14:16:24','TBC','PESANAN','DP-04486','29110439964','850000','29111289964','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-04486','2026-10-10','2026-10-10','14:16:24','PLG0017140','SULIS','2026-10-20','kasirbip','2026-10-10 14:16:24','2.000','0','0','0','850000','0','0','850000','850000','0'); UPDATE th_user_login SET tgl_logout = '2026-10-10', jam_logout = '14:30:34' WHERE user_id = 'kasirbip' AND tgl_login = '2026-10-10' AND jam_login= '11:26:36'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-10-10 ','14:31:04'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0004'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0005'; DELETE FROM tm_berlian WHERE kode_barang='PBDG-YFBD-51-0'; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('PBDG-YFBD-51-0','00036714','00036714','CINCIN SILVER 925 ','CINCIN SILVER 925','','','45000','45000',' 150000','150000','Nagatech','2026-10-10 14:36:11'); UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-11-1431 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PBDG-YFBD-51-0' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-10 ','14:36: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-261010-0006','kasirbip','1',' 700K-11-14','TOKO','BIPPER','PBDG-YFBD-51-0','CINCIN SILVER 925','','2.230','1','100.00','52000','0','0','17800','800000','0','0','0','800000','SAL','00036714','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YFBD-51-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.230',berat_jual_asli=berat_jual_asli+'2.230',stock_jual='1',berat_akhir=berat_akhir-'2.230',berat_akhir_asli=berat_akhir_asli-'2.230',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PBDG-YFBD-51-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-261010-0006','2026-10-10','2.230','2026-10-10','14:37:22','PLG0017141','800000','800000','0','800000','0','kasirbip','2026-10-10 14:37:21','FJ-261010-0006','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0006','2026-10-10','14:37:22','SAL','800000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0014','2026-10-10','2026-10-10 14:37:21','PENJUALAN : FJ-261010-0006','.','TBC','800000','800000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0015','D','2026-10-10','14:37:22','TBC','PENJUALAN','FJ-261010-0006','29111289964','800000','29112089964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-261010-0006' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0007','kasirbip','1',' DP-04134BI','TOKO','BIPPSN','PSPRT-ZJXB-36-0','CINCIN PERAK ','','2.160','1','100.00','221000','0','0','17800','900000','0','0','0','900000','KUR','00047855','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXB-36-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXB-36-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-261010-0007','2026-10-10','2.160','2026-10-10','14:45:41','PLG0017142','900000','900000','0','900000','0','kasirbip','2026-10-10 14:45:40','FJ-261010-0007','DP-04134','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-10','FJ-261010-0007','2026-10-10','14:45:41','KUR','900000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261010-0007' 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-261010-0008','kasirbip',' 1',' DP-04133BI','TOKO','BIPPSN','PSPRT-ZJXG-6-0','CINCIN PERAK ','','1.790','1','100.00','183000','0','0','17800','1200000','0','0','0','1200000','KUR','00047967','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXG-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.790',berat_jual_asli=berat_jual_asli+'1.790',stock_jual='1',berat_akhir=berat_akhir-'1.790',berat_akhir_asli=berat_akhir_asli-'1.790',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXG-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-261010-0008','2026-10-10','1.790','2026-10-10','14:45:41','PLG0017143','1200000','1200000','0','1200000','0','kasirbip','2026-10-10 14:45:40','FJ-261010-0007','DP-04133','1200000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0008','2026-10-10','14:45:41','KUR','1200000','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-261010-0008' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0008'; 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-261010-0009','kasirbip','1',' 800K-185-0','TOKO','DUPERBDG','LXPER-ZHAX-7-0','CINCIN SILVER 925 ','','3.040','1','100.00','311000','0','0','17800','950000','0','0','0','950000','MIL','00046010','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZHAX-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.040',berat_jual_asli=berat_jual_asli+'3.040',stock_jual='1',berat_akhir=berat_akhir-'3.040',berat_akhir_asli=berat_akhir_asli-'3.040',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='LXPER-ZHAX-7-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-261010-0009','2026-10-10','3.040','2026-10-10','15:00:12','PLG0017144','950000','950000','0','950000','0','kasirbip','2026-10-10 15:00:11','FJ-261010-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0009','2026-10-10','15:00:12','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-261010-0015','2026-10-10','2026-10-10 15:00:11','PENJUALAN : FJ-261010-0009','.','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-261010-0016','D','2026-10-10','15:00:12','TBC','PENJUALAN','FJ-261010-0009','29112089964','950000','29113039964','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-261010-0009' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0010','kasirbip',' 1',' 750K-17-00','TOKO','DUPERBDG','LXPER-ZFAF-44-0','CINCIN SILVER 925 ','','2.470','1','100.00','253000','0','0','17800','850000','0','0','0','850000','MIL','00044474','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAF-44-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.470',berat_jual_asli=berat_jual_asli+'2.470',stock_jual='1',berat_akhir=berat_akhir-'2.470',berat_akhir_asli=berat_akhir_asli-'2.470',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='LXPER-ZFAF-44-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-261010-0010','2026-10-10','2.470','2026-10-10','15:00:12','PLG0017145','850000','850000','0','850000','0','kasirbip','2026-10-10 15:00:11','FJ-261010-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0010','2026-10-10','15:00:12','MIL','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-261010-0016','2026-10-10','2026-10-10 15:00:11','PENJUALAN : FJ-261010-0010','.','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-261010-0017','D','2026-10-10','15:00:12','TBC','PENJUALAN','FJ-261010-0010','29113039964','850000','29113889964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1800000' WHERE no_faktur_jual='FJ-261010-0010' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0011','kasirbip','1',' DP-03999DU','TOKO','DUPSN','PSPRT-ZJXH-14-0','CINCIN PERAK ','','1.540','1','100.00','158000','0','0','17800','850000','0','0','0','850000','PUT','00048036','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXH-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXH-14-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-261010-0011','2026-10-10','1.540','2026-10-10','15:02:37','PLG0017146','850000','850000','0','850000','0','kasirbip','2026-10-10 15:02:36','FJ-261010-0011','DP-03999','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-10','FJ-261010-0011','2026-10-10','15:02:37','PUT','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261010-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-261010-0012','kasirbip',' 1',' DP-04000DU','TOKO','DUPSN','PSPRT-ZJXG-50-0','CINCIN PERAK ','','1.910','1','100.00','195000','0','0','17800','850000','0','0','0','850000','PUT','00048011','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXG-50-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXG-50-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-261010-0012','2026-10-10','1.910','2026-10-10','15:02:37','PLG0017147','850000','850000','0','850000','0','kasirbip','2026-10-10 15:02:36','FJ-261010-0011','DP-04000','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-10','FJ-261010-0012','2026-10-10','15:02:37','PUT','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261010-0012' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-10 ','15:20:40'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0013','kasir','1',' 800K-24-12','TOKO','MMPER','PMM-ZIAH-12-0','CINCIN SILVER 925 YL10 ','','4.790','1','100.00','489000','0','0','17800','900000','0','0','0','900000','ELLA','00047341','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZIAH-12-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.790',berat_jual_asli=berat_jual_asli+'4.790',stock_jual='1',berat_akhir=berat_akhir-'4.790',berat_akhir_asli=berat_akhir_asli-'4.790',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PMM-ZIAH-12-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-261010-0013','2026-10-10','4.790','2026-10-10','15:21:46','PLG0017148','900000','900000','0','900000','0','kasir','2026-10-10 15:21:45','FJ-261010-0013','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0013','2026-10-10','15:21:46','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-261010-0017','2026-10-10','2026-10-10 15:21:45','PENJUALAN : FJ-261010-0013','.','SHO','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-261010-0002','D','2026-10-10','15:21:46','SHO','PENJUALAN','FJ-261010-0013','144585650','900000','145485650','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-261010-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-261010-0014','kasir','1',' DP-04273MM','TOKO','MMPSN','PSPRT-ZJXI-21-0','CINCIN PERAK YL01 ','','3.250','1','100.00','332000','0','0','17800','850000','0','0','0','850000','ELLA','00048067','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXI-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXI-21-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-261010-0014','2026-10-10','3.250','2026-10-10','15:22:59','PLG0017149','850000','850000','0','850000','0','kasir','2026-10-10 15:22:58','FJ-261010-0014','DP-04273','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-10','FJ-261010-0014','2026-10-10','15:22:59','ELLA','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-261010-0014' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0014'; 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-261010-0015','kasir','1',' 800K-20-13','TOKO','MMPER','PMM-ZJXG-37-0','CINCIN SILVER 925 YL10 ','','4.520','1','100.00','462000','0','0','17800','900000','0','0','0','900000','ALIKA','00047998','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZJXG-37-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.520',berat_jual_asli=berat_jual_asli+'4.520',stock_jual='1',berat_akhir=berat_akhir-'4.520',berat_akhir_asli=berat_akhir_asli-'4.520',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PMM-ZJXG-37-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-261010-0015','2026-10-10','4.520','2026-10-10','15:27:36','PLG0017150','900000','900000','0','900000','0','kasir','2026-10-10 15:27:35','FJ-261010-0015','','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-10','FJ-261010-0015','2026-10-10','15:27:36','ALIKA','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0018','2026-10-10','2026-10-10 15:27:35','PENJUALAN : FJ-261010-0015','.','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-261010-0018','D','2026-10-10','15:27:36','TBC','PENJUALAN','FJ-261010-0015','29113889964','900000','29114789964','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-261010-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0015'; 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-04487','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','model tanpa mata putih glosy sz 14.5','font yeseva one grf Jazeeras','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0019','2026-10-10','2026-10-10 15:42:45','PESANAN : DP-04487','.','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-261010-0019','D','2026-10-10','15:42:45','TBC','PESANAN','DP-04487','29114789964','900000','29115689964','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-04487','2026-10-10','2026-10-10','15:42:45','PLG0017151','SAL','2026-11-10','kasirbip','2026-10-10 15:42:45','2.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0016','kasirbip','1',' DP-04051DU','TOKO','DUPSN','PSPLT-ZJXH-24-0','CINCIN PALADIUM YL01 ','','1.800','1','32.00','761000','0','0','17800','1490000','0','0','0','1490000','PUT','00048046','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXH-24-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.800',berat_jual_asli=berat_jual_asli+'1.800',stock_jual='1',berat_akhir=berat_akhir-'1.800',berat_akhir_asli=berat_akhir_asli-'1.800',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPLT-ZJXH-24-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-261010-0016','2026-10-10','1.800','2026-10-10','16:28:35','PLG0017152','1490000','1490000','0','1490000','0','kasirbip','2026-10-10 16:28:35','FJ-261010-0016','DP-04051','1280000'); 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-10','FJ-261010-0016','2026-10-10','16:28:35','PUT','1490000','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-261010-0020','2026-10-10','2026-10-10 16:28:35','PENJUALAN : FJ-261010-0016','.','TBC','210000','210000','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-261010-0020','D','2026-10-10','16:28:35','TBC','PENJUALAN','FJ-261010-0016','29115689964','210000','29115899964','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='210000' WHERE no_faktur_jual='FJ-261010-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-261010-0017','kasirbip',' 1',' DP-04050DU','TOKO','DUPSN','PSGT-ZJXG-49-0','CINCIN EMAS ','','2.020','1','83.00','3934000','0','0','17800','5335000','0','0','0','5335000','PUT','00048010','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXG-49-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSGT-ZJXG-49-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-261010-0017','2026-10-10','2.020','2026-10-10','16:28:35','PLG0017153','5335000','5335000','0','5335000','0','kasirbip','2026-10-10 16:28:35','FJ-261010-0016','DP-04050','4232000'); 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-10','FJ-261010-0017','2026-10-10','16:28:35','PUT','5335000','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-261010-0021','2026-10-10','2026-10-10 16:28:35','PENJUALAN : FJ-261010-0017','.','TBC','1103000','1103000','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-261010-0021','D','2026-10-10','16:28:35','TBC','PENJUALAN','FJ-261010-0017','29115899964','1103000','29117002964','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='1313000' WHERE no_faktur_jual='FJ-261010-0017' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0018','kasirbip','1',' 800K-23-30','TOKO','BIPPER','PBDG-ZIBI-13-0','CINCIN SILVER 925 YL10 ','','5.120','1','100.00','523000','0','0','17800','900000','0','0','0','900000','SAL','00047752','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIBI-13-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.120',berat_jual_asli=berat_jual_asli+'5.120',stock_jual='1',berat_akhir=berat_akhir-'5.120',berat_akhir_asli=berat_akhir_asli-'5.120',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PBDG-ZIBI-13-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-261010-0018','2026-10-10','5.120','2026-10-10','16:30:12','PLG0017154','900000','900000','0','900000','0','kasirbip','2026-10-10 16:30:11','FJ-261010-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-10','FJ-261010-0018','2026-10-10','16:30:12','SAL','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0022','2026-10-10','2026-10-10 16:30:11','PENJUALAN : FJ-261010-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-261010-0022','D','2026-10-10','16:30:12','TBC','PENJUALAN','FJ-261010-0018','29117002964','900000','29117902964','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-261010-0018' LIMIT 1; 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-20261010-0002','1','PSPRT-ZJXH-9-0','1','2.230','2.230','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXH-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXH-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXH-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-10 16:30:44' WHERE kode_barang='PSPRT-ZJXH-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXH-9-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-10 16:30:44','TOKO','SBYPSN','PSPRT','PSPRT-ZJXH-9-0','1','2.230','2.230','1','2.230','2.230','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-ZJXH-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' 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-20261010-0002','1','PSPRT-ZJXH-19-0','1','3.020','3.020','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXH-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXH-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXH-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-10 16:30:44' WHERE kode_barang='PSPRT-ZJXH-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXH-19-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-10 16:30:44','TOKO','SBYPSN','PSPRT','PSPRT-ZJXH-19-0','1','3.020','3.020','1','3.020','3.020','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-ZJXH-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' 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-20261010-0002','1','PSPRT-ZJXH-20-0','1','1.770','1.770','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXH-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXH-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXH-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-10 16:30:44' WHERE kode_barang='PSPRT-ZJXH-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXH-20-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-10 16:30:44','TOKO','SBYPSN','PSPRT','PSPRT-ZJXH-20-0','1','1.770','1.770','1','1.770','1.770','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-ZJXH-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' 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-20261010-0002','1','PSPRT-ZJXH-21-0','1','3.420','3.420','TOKO','SBYPSN','TOKO','SBYPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJXH-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJXH-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXH-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SBYPSN',tgl_last_beli='2026-10-10 16:30:44' WHERE kode_barang='PSPRT-ZJXH-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJXH-21-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-10 16:30:44','TOKO','SBYPSN','PSPRT','PSPRT-ZJXH-21-0','1','3.420','3.420','1','3.420','3.420','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-ZJXH-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261010-0002','2026-10-10','16:29','10.440','sby','2026-10-10 16:30: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-04488','KUR','1','PLD','CINCIN KAWIN','','','3.500','','25.00','1','1200000','550000','0','700000','2625000','size 10.5 grf Arief','putih dof semprot 1 sirkon','font berkshire swash','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0023','2026-10-10','2026-10-10 16:43:21','PESANAN : DP-04488','.','TBC','2100000','2100000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0023','D','2026-10-10','16:43:21','TBC','PESANAN','DP-04488','29117902964','2100000','29120002964','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-04488','2026-10-10','2026-10-10','16:43:21','PLG0017155','KUR','2026-11-10','kasirbip','2026-10-10 16:43:21','3.500','0','0','0','2100000','0','700000','2625000','2625000','525000'); 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-261010-0019','kasirbip','1',' DP-04298DU','TOKO','DUPSN','PSGT-ZJXG-42-0','CINCIN EMAS ','','2.300','1','45.00','2429000','0','0','17800','4110000','0','0','0','4110000','MIL','00048003','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXG-42-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSGT-ZJXG-42-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-261010-0019','2026-10-10','2.300','2026-10-10','16:44:58','PLG0017156','4110000','4110000','0','4110000','0','kasirbip','2026-10-10 16:44:57','FJ-261010-0019','DP-04298','3288000'); 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-10','FJ-261010-0019','2026-10-10','16:44:58','MIL','4110000','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-261010-0024','2026-10-10','2026-10-10 16:44:57','PENJUALAN : FJ-261010-0019','.','TBC','822000','822000','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-261010-0024','D','2026-10-10','16:44:58','TBC','PENJUALAN','FJ-261010-0019','29120002964','822000','29120824964','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='822000' WHERE no_faktur_jual='FJ-261010-0019' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04489','KUR','1','PLD','CINCIN KAWIN','','','3.500','','25.00','1','1200000','550000','0','800000','2725000','size 16.5 grf Aghnia','putih dof semprot 1 sirkon','font berkshire swash','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0025','2026-10-10','2026-10-10 16:47:22','PESANAN : DP-04489','.','TBC','2180000','2180000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0025','D','2026-10-10','16:47:22','TBC','PESANAN','DP-04489','29120824964','2180000','29123004964','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-04489','2026-10-10','2026-10-10','16:47:22','PLG0017157','KUR','2026-11-10','kasirbip','2026-10-10 16:47:22','3.500','0','0','0','2180000','0','800000','2725000','2725000','545000'); 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-261010-0020','kasirbip','1',' DP-03959BI','TOKO','BIPPSN','PSPRT-ZJXE-5-0','CINCIN PERAK ','','2.710','1','100.00','277000','0','0','17800','1800000','0','0','0','1800000','SULIS','00047890','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXE-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.710',berat_jual_asli=berat_jual_asli+'2.710',stock_jual='1',berat_akhir=berat_akhir-'2.710',berat_akhir_asli=berat_akhir_asli-'2.710',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXE-5-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-261010-0020','2026-10-10','2.710','2026-10-10','16:48:48','PLG0017158','1800000','1800000','0','1800000','0','kasirbip','2026-10-10 16:48:47','FJ-261010-0020','DP-03959','1800000'); 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-10','FJ-261010-0020','2026-10-10','16:48:48','SULIS','1800000','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-261010-0020' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0021','kasirbip',' 1',' DP-03960BI','TOKO','BIPPSN','PSPRT-ZJXH-6-0','CINCIN PERAK ','','4.060','1','100.00','415000','0','0','17800','900000','0','0','0','900000','SULIS','00048028','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXH-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.060',berat_jual_asli=berat_jual_asli+'4.060',stock_jual='1',berat_akhir=berat_akhir-'4.060',berat_akhir_asli=berat_akhir_asli-'4.060',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXH-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-261010-0021','2026-10-10','4.060','2026-10-10','16:48:48','PLG0017159','900000','900000','0','900000','0','kasirbip','2026-10-10 16:48:47','FJ-261010-0020','DP-03960','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-10','FJ-261010-0021','2026-10-10','16:48:48','SULIS','900000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261010-0021' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04490','PUT','1','GOLD','WEDRING','','','2.000','','75.00','1','2300000','2250000','0','850000','5350000','sz cwe 10.5 crom putih glosy','grf Iman font Berkshire','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-261010-0026','2026-10-10','2026-10-10 16:54:57','PESANAN : DP-04490','.','TBC','4360000','4360000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0026','D','2026-10-10','16:54:57','TBC','PESANAN','DP-04490','29123004964','4360000','29127364964','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-04490','2026-10-10','2026-10-10','16:54:57','PLG0017160','PUT','2026-11-09','kasirbip','2026-10-10 16:54:57','2.000','0','0','0','4360000','0','850000','5450000','5450000','1090000'); 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-04491','PUT','1','PLD','WEDRING','','','6.000','','10.00','1','1200000','350000','0','850000','2950000','sz cwo 21 YL.10','grf Gina 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-261010-0027','2026-10-10','2026-10-10 16:57:36','PESANAN : DP-04491','.','TBC','2360000','2360000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0027','D','2026-10-10','16:57:36','TBC','PESANAN','DP-04491','29127364964','2360000','29129724964','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-04491','2026-10-10','2026-10-10','16:57:36','PLG0017161','PUT','2026-11-09','kasirbip','2026-10-10 16:57:36','6.000','0','0','0','2360000','0','850000','2950000','2950000','590000'); 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-04492','SAL','1','PLD','WED RING','','','2.000','','50.00','1','1200000','1000000','0','500000','2500000','sz 16.5 hitam glossy hitam doff amplas','font vintage rotter grf Nia ...','model 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-261010-0028','2026-10-10','2026-10-10 17:14:39','PESANAN : DP-04492','.','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-261010-0028','D','2026-10-10','17:14:39','TBC','PESANAN','DP-04492','29129724964','2000000','29131724964','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-04492','2026-10-10','2026-10-10','17:14:39','PLG0017162','SAL','2026-11-10','kasirbip','2026-10-10 17:14:39','2.000','0','0','0','2000000','0','500000','2500000','2500000','500000'); 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-04493','SAL','1','GOLD','WED RING','','','3.500','','75.00','1','2300000','2250000','0','700000','8575000','sz 10.5 putih doff semprot 1 zirkon','font vintage rotter grf Gilar ...','model 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-261010-0029','2026-10-10','2026-10-10 17:16:37','PESANAN : DP-04493','.','TBC','6860000','6860000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0029','D','2026-10-10','17:16:37','TBC','PESANAN','DP-04493','29131724964','6860000','29138584964','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-04493','2026-10-10','2026-10-10','17:16:37','PLG0017163','SAL','2026-11-10','kasirbip','2026-10-10 17:16:37','3.500','0','0','0','6860000','0','700000','8575000','8575000','1715000'); 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-261010-0022','jogja','1',' DP-04421JO','TOKO','JOGPSN','PSPRT-ZJXH-22-0','CINCIN PERAK ','','1.400','1','100.00','143000','0','0','17800','850000','0','0','0','850000','ADL','00048044','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXH-22-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-10' AND kode_barang='PSPRT-ZJXH-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='JOGPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261010-0022','2026-10-10','1.400','2026-10-10','17:17:32','PLG0017164','850000','850000','0','850000','0','jogja','2026-10-10 17:17:32','FJ-261010-0022','DP-04421','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-10','FJ-261010-0022','2026-10-10','17:17:32','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-261010-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-261010-0023','jogja',' 1',' DP-04423JO','TOKO','JOGPSN','PSPRT-ZJXH-17-0','CINCIN PERAK ','','5.160','1','100.00','527000','0','0','17800','900000','0','0','0','900000','ADL','00048039','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXH-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.160',berat_jual_asli=berat_jual_asli+'5.160',stock_jual='1',berat_akhir=berat_akhir-'5.160',berat_akhir_asli=berat_akhir_asli-'5.160',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXH-17-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-261010-0023','2026-10-10','5.160','2026-10-10','17:17:32','PLG0017165','900000','900000','0','900000','0','jogja','2026-10-10 17:17:32','FJ-261010-0022','DP-04423','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-10','FJ-261010-0023','2026-10-10','17:17:32','ADL','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-261010-0023' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0024','kasirbip','1',' 800K-18-30','TOKO','BIPPER','PBDG-ZIBE-14-0','CINCIN SILVER 925 ','','3.250','1','100.00','332000','0','0','17800','900000','0','0','0','900000','SULIS','00047594','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIBE-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PBDG-ZIBE-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-261010-0024','2026-10-10','3.250','2026-10-10','17:20:14','PLG0017166','900000','900000','0','900000','0','kasirbip','2026-10-10 17:20:14','FJ-261010-0024','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0024','2026-10-10','17:20:14','SULIS','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0030','2026-10-10','2026-10-10 17:20:14','PENJUALAN : FJ-261010-0024','.','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-261010-0030','D','2026-10-10','17:20:14','TBC','PENJUALAN','FJ-261010-0024','29138584964','900000','29139484964','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-261010-0024' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0025','kasirbip',' 1',' 1.2K-18-29','TOKO','BIPPER','PBDG-ZIAF-38-0','CINCIN SILVER 925 ','','2.640','1','100.00','270000','0','0','17800','1300000','0','0','0','1300000','SULIS','00047270','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIAF-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PBDG-ZIAF-38-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-261010-0025','2026-10-10','2.640','2026-10-10','17:20:14','PLG0017167','1300000','1300000','0','1300000','0','kasirbip','2026-10-10 17:20:14','FJ-261010-0024','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0025','2026-10-10','17:20:14','SULIS','1300000','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-261010-0031','2026-10-10','2026-10-10 17:20:14','PENJUALAN : FJ-261010-0025','.','TBC','1300000','1300000','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-261010-0031','D','2026-10-10','17:20:14','TBC','PENJUALAN','FJ-261010-0025','29139484964','1300000','29140784964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2200000' WHERE no_faktur_jual='FJ-261010-0025' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0018'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0021'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0023'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0024'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0025' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0025' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0025'; 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-04494','DEW','1','PLD','WEDDING RING','','','3.000','','10.00','1','1200000','350000','0','1250000','2300000','sz cwe 12','gf vintage : Yogi','zircon 25','0','0','250000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0032','2026-10-10','2026-10-10 17:29:33','PESANAN : DP-04494','-','TBC','2180000','2180000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0032','D','2026-10-10','17:29:33','TBC','PESANAN','DP-04494','29140784964','2180000','29142964964','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-04494','2026-10-10','2026-10-10','17:29:33','PLG0017168','DEW','2026-11-01','jogja','2026-10-10 17:29:33','3.000','0','0','0','2180000','0','1250000','2550000','2550000','370000'); 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-261010-0026','sby','1',' DP-03542SB','TOKO','SBYPSN','PSPLT-ZIAD-31-0','CINCIN PALADIUM ','','2.190','1','32.00','926000','0','0','17800','2245000','0','0','0','2245000','DIL','00047197','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIAD-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPLT-ZIAD-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-261010-0026','2026-10-10','2.190','2026-10-10','17:30:07','PLG0017169','2245000','2245000','0','2245000','0','sby','2026-10-10 17:30:06','FJ-261010-0026','DP-03542','1800000'); 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-10','FJ-261010-0026','2026-10-10','17:30:07','DIL','2245000','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-261010-0033','2026-10-10','2026-10-10 17:30:06','PENJUALAN : FJ-261010-0026','','TBC','445000','445000','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-261010-0033','D','2026-10-10','17:30:07','TBC','PENJUALAN','FJ-261010-0026','29142964964','445000','29143409964','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='445000' WHERE no_faktur_jual='FJ-261010-0026' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0027','sby',' 1',' DP-03541SB','TOKO','SBYPSN','PSPLT-ZIAA-48-0','CINCIN PALADIUM ','','3.880','1','32.00','1639000','0','0','17800','2884000','0','0','0','2884000','DIL','00047158','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIAA-48-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-10' AND kode_barang='PSPLT-ZIAA-48-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-261010-0027','2026-10-10','3.880','2026-10-10','17:30:07','PLG0017170','2884000','2884000','0','2884000','0','sby','2026-10-10 17:30:06','FJ-261010-0026','DP-03541','2000000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0027','2026-10-10','17:30:07','DIL','2884000','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-261010-0034','2026-10-10','2026-10-10 17:30:06','PENJUALAN : FJ-261010-0027','','TBC','884000','884000','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-261010-0034','D','2026-10-10','17:30:07','TBC','PENJUALAN','FJ-261010-0027','29143409964','884000','29144293964','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='1329000' WHERE no_faktur_jual='FJ-261010-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-04495','DEW','1','PLD','WEDDING RING','','','3.500','','10.00','1','1200000','350000','0','800000','2025000','sz cwo 20','gf vintage : Alifia','','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0035','2026-10-10','2026-10-10 17:32:35','PESANAN : DP-04495','-','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-261010-0035','D','2026-10-10','17:32:35','TBC','PESANAN','DP-04495','29144293964','1620000','29145913964','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-04495','2026-10-10','2026-10-10','17:32:35','PLG0017171','DEW','2026-11-01','jogja','2026-10-10 17:32:35','3.500','0','0','0','1620000','0','800000','2025000','2025000','405000'); 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-261010-0028','kasirbip','1',' 850K-13-00','TOKO','DUPERBDG','LXPER-ZIXG-28-0','CINCIN SILVER 925 ','','1.890','1','100.00','193000','0','0','17800','950000','0','0','0','950000','MIL','00046995','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZIXG-28-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='LXPER-ZIXG-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261010-0028','2026-10-10','1.890','2026-10-10','17:51:54','PLG0017172','950000','950000','0','950000','0','kasirbip','2026-10-10 17:51:54','FJ-261010-0028','','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-10','FJ-261010-0028','2026-10-10','17:51:54','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-261010-0036','2026-10-10','2026-10-10 17:51:54','PENJUALAN : FJ-261010-0028','.','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-261010-0036','D','2026-10-10','17:51:54','TBC','PENJUALAN','FJ-261010-0028','29145913964','950000','29146863964','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-261010-0028' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04496','PUT','1','PER','WEDRING PROMO','','','4.000','','925.00','1','100000','0','850000','0','850000','sz cwe 9 grf Ryan','sz cwo 18 grf Utari','font Comic','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-261010-0037','2026-10-10','2026-10-10 17:54:43','PESANAN : DP-04496','.','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-261010-0037','D','2026-10-10','17:54:43','TBC','PESANAN','DP-04496','29146863964','850000','29147713964','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-04496','2026-10-10','2026-10-10','17:54:43','PLG0017173','PUT','2026-11-07','kasirbip','2026-10-10 17:54:43','4.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-261010-0029','kasirbip','1',' DP-03992DU','TOKO','DUPSN','PSPLT-ZJXH-15-0','CINCIN PALADIUM ','','2.360','1','17.00','530000','0','0','17800','1526000','0','0','0','1526000','PUT','00048037','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXH-15-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPLT-ZJXH-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-261010-0029','2026-10-10','2.360','2026-10-10','18:03:48','PLG0017174','1526000','1526000','0','1526000','0','kasirbip','2026-10-10 18:03:47','FJ-261010-0029','DP-03992','1260000'); 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-10','FJ-261010-0029','2026-10-10','18:03:48','PUT','1526000','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-261010-0038','2026-10-10','2026-10-10 18:03:47','PENJUALAN : FJ-261010-0029','.','TBC','266000','266000','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-261010-0038','D','2026-10-10','18:03:48','TBC','PENJUALAN','FJ-261010-0029','29147713964','266000','29147979964','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='266000' WHERE no_faktur_jual='FJ-261010-0029' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0030','kasirbip',' 1',' DP-03993DU','TOKO','DUPSN','PSPRT-ZJXF-27-0','CINCIN PERAK ','','2.650','1','100.00','271000','0','0','17800','850000','0','0','0','850000','PUT','00047955','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXF-27-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXF-27-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-261010-0030','2026-10-10','2.650','2026-10-10','18:03:48','PLG0017175','850000','850000','0','850000','0','kasirbip','2026-10-10 18:03:47','FJ-261010-0029','DP-03993','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-10','FJ-261010-0030','2026-10-10','18:03:48','PUT','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='266000' WHERE no_faktur_jual='FJ-261010-0030' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0026' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0026' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0026'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0027' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0027' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0027'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0028' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0028' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0028'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0029' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0029' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0029'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0030' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0030' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-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-04497','DIL','1','PLD','WEDD RING PRIA','','','4.000','','10.00','1','1200000','350000','0','800000','2200000','SIZE 21 GRF: Adel (INFINITY) FONT: BERKSHIRE','PUTIH GLOSSY MIX DOFF','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0039','2026-10-10','2026-10-10 18:32:51','PESANAN : DP-04497','-','TBC','1500000','1500000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0039','D','2026-10-10','18:32:51','TBC','PESANAN','DP-04497','29147979964','1500000','29149479964','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-04497','2026-10-10','2026-10-10','18:32:51','PLG0017176','DIL','2026-11-04','sby','2026-10-10 18:32:51','4.000','0','0','0','1500000','0','800000','2200000','2200000','700000'); 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-04498','DIL','1','PLD','WEDD RING WANITA','','','3.500','','10.00','1','1200000','350000','0','850000','2075000','PERMATA 15 BUTIR','SIZE 19 GRF: Adam (INFINITY) FONT: BERKSHIRE','PUTIH GLOSSY','150000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0040','2026-10-10','2026-10-10 18:34:52','PESANAN : DP-04498','-','TBC','1500000','1500000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0040','D','2026-10-10','18:34:52','TBC','PESANAN','DP-04498','29149479964','1500000','29150979964','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-04498','2026-10-10','2026-10-10','18:34:52','PLG0017177','DIL','2026-11-04','sby','2026-10-10 18:34:52','3.500','0','0','0','1500000','0','850000','2225000','2225000','725000'); 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-261010-0031','kasirbip','1',' DP-03967DU','TOKO','DUPSN','PSPLT-ZJXF-20-0','CINCIN PALADIUM ','','2.530','1','32.00','1070000','0','0','17800','2091500','0','0','0','2091500','PUT','00047948','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXF-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPLT-ZJXF-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261010-0031','2026-10-10','2.530','2026-10-10','18:38:23','PLG0017178','2091500','2091500','0','2091500','0','kasirbip','2026-10-10 18:38:22','FJ-261010-0031','DP-03967','1660000'); 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-10','FJ-261010-0031','2026-10-10','18:38:23','PUT','2091500','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-261010-0041','2026-10-10','2026-10-10 18:38:22','PENJUALAN : FJ-261010-0031','.','TBC','431500','431500','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-261010-0041','D','2026-10-10','18:38:23','TBC','PENJUALAN','FJ-261010-0031','29150979964','431500','29151411464','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='431500' WHERE no_faktur_jual='FJ-261010-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-261010-0032','kasirbip',' 1',' DP-03968DU','TOKO','DUPSN','PSPLT-ZJXF-29-0','CINCIN PALADIUM ','','3.680','1','32.00','1555000','0','0','17800','2724000','0','0','0','2724000','PUT','00047957','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXF-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.680',berat_jual_asli=berat_jual_asli+'3.680',stock_jual='1',berat_akhir=berat_akhir-'3.680',berat_akhir_asli=berat_akhir_asli-'3.680',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPLT-ZJXF-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261010-0032','2026-10-10','3.680','2026-10-10','18:38:23','PLG0017179','2724000','2724000','0','2724000','0','kasirbip','2026-10-10 18:38:22','FJ-261010-0031','DP-03968','2320000'); 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-10','FJ-261010-0032','2026-10-10','18:38:23','PUT','2724000','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-261010-0042','2026-10-10','2026-10-10 18:38:22','PENJUALAN : FJ-261010-0032','.','TBC','404000','404000','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-261010-0042','D','2026-10-10','18:38:23','TBC','PENJUALAN','FJ-261010-0032','29151411464','404000','29151815464','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='835500' WHERE no_faktur_jual='FJ-261010-0032' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-10 ','18:45:53'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0033','sby','1',' DP-04055SB','TOKO','SBYPSN','PSPRT-ZJXH-19-0','CINCIN PERAK ','','3.020','1','100.00','309000','0','0','17800','850000','0','0','0','850000','DIL','00048041','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXH-19-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXH-19-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-261010-0033','2026-10-10','3.020','2026-10-10','18:46:51','PLG0017180','850000','850000','0','850000','0','sby','2026-10-10 18:46:50','FJ-261010-0033','DP-04055','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-10','FJ-261010-0033','2026-10-10','18:46:51','DIL','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-261010-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-261010-0034','sby',' 1',' DP-04056SB','TOKO','SBYPSN','PSPRT-ZJXH-20-0','CINCIN PERAK ','','1.770','1','100.00','181000','0','0','17800','1000000','0','0','0','1000000','DIL','00048042','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXH-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.770',berat_jual_asli=berat_jual_asli+'1.770',stock_jual='1',berat_akhir=berat_akhir-'1.770',berat_akhir_asli=berat_akhir_asli-'1.770',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXH-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-261010-0034','2026-10-10','1.770','2026-10-10','18:46:51','PLG0017181','1000000','1000000','0','1000000','0','sby','2026-10-10 18:46:50','FJ-261010-0033','DP-04056','1000000'); 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-10','FJ-261010-0034','2026-10-10','18:46:51','DIL','1000000','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-261010-0034' 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-04499','VAN','1','GOLD','WEDDRING WANITA','','','2.500','','37.50','1','2300000','1400000','0','850000','4350000','Permata 9','SIZE: 21 GRF: Jannah??','FONT: VINTAGE EMAS PUTIH','90000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0043','2026-10-10','2026-10-10 18:55:33','PESANAN : DP-04499','-','TBC','3000000','3000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0043','D','2026-10-10','18:55:33','TBC','PESANAN','DP-04499','29151815464','3000000','29154815464','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-04499','2026-10-10','2026-10-10','18:55:33','PLG0017182','VAN','2026-11-04','sby','2026-10-10 18:55:33','2.500','0','0','0','3000000','0','850000','4440000','4440000','1440000'); 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-04500','VAN','1','GOLD','WEDDRING WANITA','','','2.500','','37.50','1','2300000','1400000','0','850000','4350000','PERMATA 9','SIZE: 10.5 GRF: Dayat??','FONT: VINTAGE EMAS PUTIH','90000','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0044','2026-10-10','2026-10-10 19:00:40','PESANAN : DP-04500','-','TBC','3000000','3000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0044','D','2026-10-10','19:00:40','TBC','PESANAN','DP-04500','29154815464','3000000','29157815464','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-04500','2026-10-10','2026-10-10','19:00:40','PLG0017183','VAN','2026-11-04','sby','2026-10-10 19:00:40','2.500','0','0','0','3000000','0','850000','4440000','4440000','1440000'); 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-04501','VAN','1','PER','WEDDRING PRIA','','','4.000','','925.00','1','100000','0','900000','0','900000','SIZE: 21','GRF: Jannah?? FONT: VINTAGE','PUTIH','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0045','2026-10-10','2026-10-10 19:03:05','PESANAN : DP-04501','-','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-261010-0045','D','2026-10-10','19:03:05','TBC','PESANAN','DP-04501','29157815464','900000','29158715464','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-04501','2026-10-10','2026-10-10','19:03:05','PLG0017184','VAN','2026-11-04','sby','2026-10-10 19:03:05','4.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04502','KUR','1','GOLD','CINCIN KAWIN','','','2.500','','37.50','1','2300000','1400000','0','900000','4400000','size 13 grf Irvan & Kiki','putih glosi sirkon 17','font berkshire swash','0','170000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0046','2026-10-10','2026-10-10 19:07:09','PESANAN : DP-04502','.','TBC','3600000','3600000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0046','D','2026-10-10','19:07:09','TBC','PESANAN','DP-04502','29158715464','3600000','29162315464','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-04502','2026-10-10','2026-10-10','19:07:09','PLG0017185','KUR','2026-11-10','kasirbip','2026-10-10 19:07:09','2.500','0','0','0','3600000','0','900000','4570000','4570000','970000'); 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-04503','KUR','1','PLD','CINCIN KAWIN','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','size 16 grf Kiki & Irvan','putih kilat sirkon 1','font berkshire swash','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0047','2026-10-10','2026-10-10 19:12:13','PESANAN : DP-04503','.','TBC','1400000','1400000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0047','D','2026-10-10','19:12:13','TBC','PESANAN','DP-04503','29162315464','1400000','29163715464','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-04503','2026-10-10','2026-10-10','19:12:13','PLG0017186','KUR','2026-11-10','kasirbip','2026-10-10 19:12:13','3.000','0','0','0','1400000','0','800000','1850000','1850000','450000'); 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-261010-0035','kasirbip','1',' 700K-18-23','TOKO','BIPPER','PBDG-ZDXG-38-0','CINCIN SILVER 925 ','','1.980','1','100.00','202000','0','0','17800','800000','0','0','0','800000','SAL','00042353','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXG-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PBDG-ZDXG-38-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-261010-0035','2026-10-10','1.980','2026-10-10','19:19:19','PLG0017187','800000','800000','0','800000','0','kasirbip','2026-10-10 19:19:18','FJ-261010-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-10','FJ-261010-0035','2026-10-10','19:19:19','SAL','800000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0048','2026-10-10','2026-10-10 19:19:18','PENJUALAN : FJ-261010-0035','.','TBC','800000','800000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0048','D','2026-10-10','19:19:19','TBC','PENJUALAN','FJ-261010-0035','29163715464','800000','29164515464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='800000' WHERE no_faktur_jual='FJ-261010-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-261010-0036','kasirbip',' 1',' 800K-115-2','TOKO','BIPPER','PBDG-ZEBB-36-0','CINCIN SILVER 925 ','','1.850','1','100.00','189000','0','0','17800','900000','0','0','0','900000','SAL','00043748','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEBB-36-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-10' AND kode_barang='PBDG-ZEBB-36-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-261010-0036','2026-10-10','1.850','2026-10-10','19:19:19','PLG0017188','900000','900000','0','900000','0','kasirbip','2026-10-10 19:19:18','FJ-261010-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-10','FJ-261010-0036','2026-10-10','19:19:19','SAL','900000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-261010-0049','2026-10-10','2026-10-10 19:19:18','PENJUALAN : FJ-261010-0036','.','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-261010-0049','D','2026-10-10','19:19:19','TBC','PENJUALAN','FJ-261010-0036','29164515464','900000','29165415464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-261010-0036' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04504','ELLA','1','PER','CINCIN PROMO 850','','','3.000','','925.00','1','100000','0','0','0','850000','cwe size 16 grf Rahul ?? Inay crom full rosegold','cwo size 15 grf Inay ?? Rahul crom kombinasi rosegold doff','upsize 100k','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0050','2026-10-10','2026-10-10 19:21:16','PESANAN : DP-04504','0','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-261010-0050','D','2026-10-10','19:21:16','TBC','PESANAN','DP-04504','29165415464','850000','29166265464','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-04504','2026-10-10','2026-10-10','19:21:16','PLG0017189','ELLA','2026-11-06','kasir','2026-10-10 19:21:16','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-04505','VAN','1','PER','WEDDRING PRIA','','','3.500','','925.00','1','100000','0','850000','0','850000','SIZE: 18','GRF: A&B FONT: BRUSH SCRIPT','PUTIH DOFF MIX GLOSSY','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0051','2026-10-10','2026-10-10 19:30:47','PESANAN : DP-04505','-','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-261010-0051','D','2026-10-10','19:30:47','TBC','PESANAN','DP-04505','29166265464','850000','29167115464','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-04505','2026-10-10','2026-10-10','19:30:47','PLG0017190','VAN','2026-11-04','sby','2026-10-10 19:30:47','3.500','0','0','0','850000','0','0','850000','850000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0037','kasir','1',' DP-04034MM','TOKO','MMPSN','PSPRT-ZJXG-1-0','CINCIN PERAK ','','2.320','1','100.00','238000','0','0','17800','1100000','0','0','0','1100000','ELLA','00047962','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXG-1-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXG-1-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-261010-0037','2026-10-10','2.320','2026-10-10','19:34:43','PLG0017191','1100000','1100000','0','1100000','0','kasir','2026-10-10 19:34:43','FJ-261010-0037','DP-04034','1100000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0037','2026-10-10','19:34:43','ELLA','1100000','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-261010-0037' 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-261010-0038','kasir',' 1',' DP-04035MM','TOKO','MMPSN','PSPRT-ZJXF-1-0','CINCIN PERAK ','','4.110','1','100.00','420000','0','0','17800','950000','0','0','0','950000','ELLA','00047929','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXF-1-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.110',berat_jual_asli=berat_jual_asli+'4.110',stock_jual='1',berat_akhir=berat_akhir-'4.110',berat_akhir_asli=berat_akhir_asli-'4.110',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPRT-ZJXF-1-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-261010-0038','2026-10-10','4.110','2026-10-10','19:34:43','PLG0017192','950000','950000','0','950000','0','kasir','2026-10-10 19:34:43','FJ-261010-0037','DP-04035','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-10','FJ-261010-0038','2026-10-10','19:34:43','ELLA','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-261010-0038' 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-04506','SULIS','1','PLD','WED RING','','','1.500','','10.00','1','1200000','350000','0','750000','1275000','1 zircon putih doff semprot sz 13','font vintage rotter grf Ardan','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0052','2026-10-10','2026-10-10 19:41:01','PESANAN : DP-04506','.','TBC','1000000','1000000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0052','D','2026-10-10','19:41:01','TBC','PESANAN','DP-04506','29167115464','1000000','29168115464','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-04506','2026-10-10','2026-10-10','19:41:01','PLG0017193','SULIS','2026-10-20','kasirbip','2026-10-10 19:41:01','1.500','0','0','0','1000000','0','750000','1275000','1275000','275000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0039','kasirbip','1',' DP-03694DU','TOKO','DUPSN','PSGT-ZIBE-55-0','CINCIN EMAS ','','1.780','1','57.00','2381000','0','0','17800','4234000','0','0','0','4234000','PUT','00047635','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZIBE-55-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSGT-ZIBE-55-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-261010-0039','2026-10-10','1.780','2026-10-10','19:42:33','PLG0017194','4234000','4234000','0','4234000','0','kasirbip','2026-10-10 19:42:32','FJ-261010-0039','DP-03694','3704000'); 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-10','FJ-261010-0039','2026-10-10','19:42:33','PUT','4234000','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-261010-0053','2026-10-10','2026-10-10 19:42:32','PENJUALAN : FJ-261010-0039','.','TBC','530000','530000','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-261010-0053','D','2026-10-10','19:42:33','TBC','PENJUALAN','FJ-261010-0039','29168115464','530000','29168645464','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='530000' WHERE no_faktur_jual='FJ-261010-0039' 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-261010-0040','kasirbip',' 1',' DP-03695DU','TOKO','DUPSN','PSPLT-ZIBE-24-0','CINCIN PALADIUM ','','2.180','1','32.00','922000','0','0','17800','1949000','0','0','0','1949000','PUT','00047604','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZIBE-24-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSPLT-ZIBE-24-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-261010-0040','2026-10-10','2.180','2026-10-10','19:42:33','PLG0017195','1949000','1949000','0','1949000','0','kasirbip','2026-10-10 19:42:32','FJ-261010-0039','DP-03695','1480000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-10','FJ-261010-0040','2026-10-10','19:42:33','PUT','1949000','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-261010-0054','2026-10-10','2026-10-10 19:42:32','PENJUALAN : FJ-261010-0040','.','TBC','469000','469000','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-261010-0054','D','2026-10-10','19:42:33','TBC','PENJUALAN','FJ-261010-0040','29168645464','469000','29169114464','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='999000' WHERE no_faktur_jual='FJ-261010-0040' 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-04507','SULIS','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','750000','1800000','sz 14.5 putih doff semprot','font vintage rotter grf Cica','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-261010-0055','2026-10-10','2026-10-10 19:42:33','PESANAN : DP-04507','.','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-261010-0055','D','2026-10-10','19:42:33','TBC','PESANAN','DP-04507','29169114464','1440000','29170554464','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-04507','2026-10-10','2026-10-10','19:42:33','PLG0017196','SULIS','2026-10-20','kasirbip','2026-10-10 19:42:33','3.000','0','0','0','1440000','0','750000','1800000','1800000','360000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0032' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0032' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0032'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0033' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0033' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0033'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0034' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0034' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0034'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0035' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0035' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0035'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0036' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0036' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0036'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0037' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0037' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0037'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0038' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0038' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0038'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0039' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0039' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0039'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0040' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0040' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0040'; 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-20261010-0003','1','PBDG-ZJXI-34-0','1','1.840','1.840','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJXI-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJXI-34-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJXI-34-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJXI-34-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-10 20:08:17' WHERE kode_barang='PBDG-ZJXI-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJXI-34-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-10 20:08:17','TOKO','BIPPER','PBDG','PBDG-ZJXI-34-0','1','1.840','1.840','1','1.840','1.840','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJXI-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJXI-34-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' 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-20261010-0003','1','PBDG-ZJXI-35-0','1','1.780','1.780','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJXI-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJXI-35-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJXI-35-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJXI-35-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-10 20:08:17' WHERE kode_barang='PBDG-ZJXI-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJXI-35-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-10 20:08:17','TOKO','BIPPER','PBDG','PBDG-ZJXI-35-0','1','1.780','1.780','1','1.780','1.780','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJXI-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJXI-35-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' 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-20261010-0003','1','PBDG-ZJXI-36-0','1','1.880','1.880','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJXI-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJXI-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJXI-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJXI-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-10 20:08:17' WHERE kode_barang='PBDG-ZJXI-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJXI-36-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-10 20:08:17','TOKO','BIPPER','PBDG','PBDG-ZJXI-36-0','1','1.880','1.880','1','1.880','1.880','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJXI-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJXI-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' 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-20261010-0003','1','PBDG-ZJXI-37-0','1','1.880','1.880','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZJXI-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZJXI-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZJXI-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZJXI-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-10-10 20:08:17' WHERE kode_barang='PBDG-ZJXI-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZJXI-37-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-10 20:08:17','TOKO','BIPPER','PBDG','PBDG-ZJXI-37-0','1','1.880','1.880','1','1.880','1.880','100.00'); DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZJXI-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZJXI-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261010-0003','2026-10-10','20:07','7.380','kasirbip','2026-10-10 20:08:17'); 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-20261010-0004','1','BDCM-ZJXI-18-0','1','1.000','1.000','TOKO','CMBD','TOKO','BIPCMP'); DELETE FROM tm_barang WHERE kode_barang='BDCM-ZJXI-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='BDCM-ZJXI-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='BDCM-ZJXI-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='BDCM-ZJXI-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPCMP',tgl_last_beli='2026-10-10 20:08:50' WHERE kode_barang='BDCM-ZJXI-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='BDCM-ZJXI-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-10 20:08:50','TOKO','BIPCMP','BDCM','BDCM-ZJXI-18-0','1','1.000','1.000','1','1.000','1.000','76.00'); DELETE FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM tm_group WHERE kode_group='GOLD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='GOLD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='BDCM-ZJXI-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='BDCM-ZJXI-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-10' WHERE no_faktur_beli='FB-260930-0001'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261010-0004','2026-10-10','20:08','1.000','kasirbip','2026-10-10 20:08:50'); UPDATE tt_service_head SET tgl_selesai='2026-10-10', status ='DONE' WHERE no_service='SV-02283'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02283'; UPDATE tt_service_head SET tgl_selesai='2026-10-10', status ='DONE' WHERE no_service='SV-02284'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02284'; UPDATE tt_service_head SET tgl_selesai='2026-10-10', status ='DONE' WHERE no_service='SV-02282'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02282'; UPDATE tt_service_head SET tgl_selesai='2026-10-10', status ='DONE' WHERE no_service='SV-02274'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02274'; UPDATE tt_service_head SET tgl_selesai='2026-10-10', status ='DONE' WHERE no_service='SV-02281'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02281'; UPDATE tt_service_head SET tgl_selesai='2026-10-10', status ='DONE' WHERE no_service='SV-02278'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02278'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261010-0041','kasir','1',' DP-03914MM','TOKO','MMPSN','PSGT-ZJXB-51-0','CINCIN EMAS ','','1.780','1','45.00','1880000','0','0','17800','3242000','0','0','0','3242000','ALIKA','00047870','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXB-51-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-10-10' AND kode_barang='PSGT-ZJXB-51-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-261010-0041','2026-10-10','1.780','2026-10-10','20:17:25','PLG0017197','3242000','3242000','0','3242000','0','kasir','2026-10-10 20:17:24','FJ-261010-0041','DP-03914','2840000'); 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-10','FJ-261010-0041','2026-10-10','20:17:25','ALIKA','3242000','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-261010-0056','2026-10-10','2026-10-10 20:17:24','PENJUALAN : FJ-261010-0041','0','TBC','402000','402000','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-261010-0056','D','2026-10-10','20:17:25','TBC','PENJUALAN','FJ-261010-0041','29170554464','402000','29170956464','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='402000' WHERE no_faktur_jual='FJ-261010-0041' 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-261010-0042','kasir',' 1',' DP-03915MM','TOKO','MMPSN','PSPLT-ZJXB-53-0','CINCIN PALADIUM ','','2.540','1','17.00','571000','0','0','17800','1639000','0','0','0','1639000','ALIKA','00047872','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXB-53-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-10' AND kode_barang='PSPLT-ZJXB-53-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-261010-0042','2026-10-10','2.540','2026-10-10','20:17:25','PLG0017198','1639000','1639000','0','1639000','0','kasir','2026-10-10 20:17:24','FJ-261010-0041','DP-03915','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-10','FJ-261010-0042','2026-10-10','20:17:25','ALIKA','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-261010-0057','2026-10-10','2026-10-10 20:17:24','PENJUALAN : FJ-261010-0042','0','TBC','199000','199000','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-261010-0057','D','2026-10-10','20:17:25','TBC','PENJUALAN','FJ-261010-0042','29170956464','199000','29171155464','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='601000' WHERE no_faktur_jual='FJ-261010-0042' 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-04508','SULIS','1','PLD','WE RING','','','3.000','','10.00','1','1200000','350000','0','1000000','2050000','1 zircon putih glosy','lebar atas 4mm lebar bawah 3.mm','font vladimir grf Prisa & Hakim','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0058','2026-10-10','2026-10-10 20:29:27','PESANAN : DP-04508','.','TBC','1640000','1640000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0058','D','2026-10-10','20:29:27','TBC','PESANAN','DP-04508','29171155464','1640000','29172795464','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-04508','2026-10-10','2026-10-10','20:29:27','PLG0017199','SULIS','2026-11-10','kasirbip','2026-10-10 20:29:27','3.000','0','0','0','1640000','0','1000000','2050000','2050000','410000'); 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-04509','SULIS','1','PLD','WED RING','','','3.500','','10.00','1','1200000','350000','0','1000000','2225000','sz 19 putih glosy tanpa mata','font vladimir grf Prisa & Hakim','lebar atas 4.mm lebar bawah 3.mm','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0059','2026-10-10','2026-10-10 20:31:08','PESANAN : DP-04509','.','TBC','1780000','1780000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0059','D','2026-10-10','20:31:08','TBC','PESANAN','DP-04509','29172795464','1780000','29174575464','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-04509','2026-10-10','2026-10-10','20:31:08','PLG0017200','SULIS','2026-10-24','kasirbip','2026-10-10 20:31:08','3.500','0','0','0','1780000','0','1000000','2225000','2225000','445000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0041' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0041' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0041'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0042' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261010-0042' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261010-0042'; 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-04510','KUR','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','850000','1900000','18 zircon putih glosy sz 18','font arial grf YUSTIZA R S','','180000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0060','2026-10-10','2026-10-10 21:01:01','PESANAN : DP-04510','.','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-261010-0060','D','2026-10-10','21:01:01','TBC','PESANAN','DP-04510','29174575464','1660000','29176235464','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-04510','2026-10-10','2026-10-10','21:01:01','PLG0017201','KUR','2026-10-24','kasirbip','2026-10-10 21:01:01','3.000','0','0','0','1660000','0','850000','2080000','2080000','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-04511','KUR','1','PLD','WED RING','','','4.000','','10.00','1','1200000','350000','0','750000','2150000','1 zircon putih doff semprot sz 21','font arial grf DINDA A','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261010-0061','2026-10-10','2026-10-10 21:03:07','PESANAN : DP-04511','.','TBC','1720000','1720000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-261010-0061','D','2026-10-10','21:03:07','TBC','PESANAN','DP-04511','29176235464','1720000','29177955464','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-04511','2026-10-10','2026-10-10','21:03:07','PLG0017202','KUR','2026-11-10','kasirbip','2026-10-10 21:03:07','4.000','0','0','0','1720000','0','750000','2150000','2150000','430000'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-11','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-10'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-10'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-10'; 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-10' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-10'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-10'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-10'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-10'; 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-11' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-10' 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-261011-0001','D','2026-10-11','21:18:24','TBC','SALDO AWAL','SALDO AWAL','0','29177955464','29177955464'); 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-261011-0001','D','2026-10-11','21:18:24','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261011-0001','D','2026-10-11','21:18:24','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-261011-0001','D','2026-10-11','21:18:24','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-261011-0001','D','2026-10-11','21:18:24','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-261011-0001','D','2026-10-11','21:18:24','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-261011-0001','D','2026-10-11','21:18:24','','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-261011-0001','D','2026-10-11','21:18:24','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-261011-0001','D','2026-10-11','21:18:24','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000'); 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-261011-0001','D','2026-10-11','21:18:24','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-261011-0001','D','2026-10-11','21:18:24','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-261011-0001','D','2026-10-11','21:18:24','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); UPDATE tp_system SET tgl_system='2026-10-11'; 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-04512','DIL','1','PER','WEDD RING CUSTOM','','','3.000','','925.00','1','100000','0','950000','0','950000','LEBAR 4MM','SIZE 18.5 GRF: Rissa & DImas (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-261010-0062','2026-10-10','2026-10-10 21:52:34','PESANAN : DP-04512','-','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-261010-0001','D','2026-10-10','21:52:34','TBC','PESANAN','DP-04512','0','950000','950000','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-04512','2026-10-10','2026-10-10','21:52:34','PLG0017203','DIL','2026-11-05','sby','2026-10-10 21:52:34','3.000','0','0','0','950000','0','0','950000','950000','0');