INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-30 ','10:15:04'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-30','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-29'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-29'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-29'; 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-05-29' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-29'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-29'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-29'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-29'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04'; UPDATE tt_barang_saldo SET tanggal= '2026-05-30' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-29' 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-260530-0001','D','2026-05-30','10:20:16','TBC','SALDO AWAL','SALDO AWAL','0','22970322514','22970322514'); 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-260530-0001','D','2026-05-30','10:20:16','BCD','SALDO AWAL','SALDO AWAL','0','1389903500','1389903500'); 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-260530-0001','D','2026-05-30','10:20:16','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-260530-0001','D','2026-05-30','10:20:16','','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-260530-0001','D','2026-05-30','10:20:16','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-260530-0001','D','2026-05-30','10:20:16','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-260530-0001','D','2026-05-30','10:20:16','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-260530-0001','D','2026-05-30','10:20:16','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260530-0001','D','2026-05-30','10:20:16','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-260530-0001','D','2026-05-30','10:20:16','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-260530-0001','D','2026-05-30','10:20:16','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000'); 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-260530-0001','D','2026-05-30','10:20:16','SHO','SALDO AWAL','SALDO AWAL','0','144585650','144585650'); UPDATE tp_system SET tgl_system='2026-05-30'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-30 ','10:42:45'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-30 ','11:31:12'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0001','kasir','1',' TFCMR75-81','TOKO','TFCINMAS','TFCMR-YLXC-35-0','THIFA CINCIN MAS RG ','','1.100','1','81.00','2200000','0','0','17800','2300000','0','0','0','2300000','IQB','00040158','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YLXC-35-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='TFCMR-YLXC-35-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0001','2026-05-30','1.100','2026-05-30','12:10:41','PLG0011507','2300000','2300000','0','2300000','0','kasir','2026-05-30 12:10:40','FJ-260530-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-05-30','FJ-260530-0001','2026-05-30','12:10:41','IQB','2300000','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-260530-0001','2026-05-30','2026-05-30 12:10:40','PENJUALAN : FJ-260530-0001','.','TBC','2300000','2300000','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-260530-0002','D','2026-05-30','12:10:41','TBC','PENJUALAN','FJ-260530-0001','22970322514','2300000','22972622514','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='2300000' WHERE no_faktur_jual='FJ-260530-0001' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-30 ','12:16:37'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-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-260530-0002','kasirbip','1',' 800K-225-2','TOKO','BIPPER','PBDG-ZEAE-21-0','CINCIN SILVER 925 YL-10','','4.900','1','100.00','501000','0','0','17800','1000000','0','0','0','1000000','GIN','00043588','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEAE-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.900',berat_jual_asli=berat_jual_asli+'4.900',stock_jual='1',berat_akhir=berat_akhir-'4.900',berat_akhir_asli=berat_akhir_asli-'4.900',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PBDG-ZEAE-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0002','2026-05-30','4.900','2026-05-30','12:19:20','PLG0011508','1000000','1000000','0','1000000','0','kasirbip','2026-05-30 12:19:20','FJ-260530-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-05-30','FJ-260530-0002','2026-05-30','12:19:20','GIN','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-260530-0002','2026-05-30','2026-05-30 12:19:20','PENJUALAN : FJ-260530-0002','.','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-260530-0003','D','2026-05-30','12:19:20','TBC','PENJUALAN BERLIAN','FJ-260530-0002','22972622514','1000000','22973622514','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-260530-0002' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0003','kasirbip',' 1',' 850K-13 ','TOKO','BIPCMP','BDCM-YJAX-24-0','BANDUNG CINCIN EMAS ','','1.550','1','83.00','3176000','0','0','17800','4570000','0','0','0','4570000','GIN','00039170','BDCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YJAX-24-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='BDCM-YJAX-24-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0003','2026-05-30','1.550','2026-05-30','12:19:20','PLG0011509','4570000','4570000','0','4570000','0','kasirbip','2026-05-30 12:19:20','FJ-260530-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-05-30','FJ-260530-0003','2026-05-30','12:19:20','GIN','4570000','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-260530-0003','2026-05-30','2026-05-30 12:19:20','PENJUALAN : FJ-260530-0003','.','TBC','4570000','4570000','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-260530-0004','D','2026-05-30','12:19:20','TBC','PENJUALAN','FJ-260530-0003','22973622514','4570000','22978192514','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='5570000' WHERE no_faktur_jual='FJ-260530-0003' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-30 ','12:23:16'); 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-02267','SULIS','1','PLD','WED RING','','','2.000','','10.00','1','1200000','350000','0','750000','1450000','1 zircon putih dof semprot sz 9','font vladimir grf Maulana','esxpres bayar di akhir','0','0','200000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0004','2026-05-30','2026-05-30 12:38:00','PESANAN : DP-02267','.','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-260530-0005','D','2026-05-30','12:38:00','TBC','PESANAN','DP-02267','22978192514','1100000','22979292514','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-02267','2026-05-30','2026-05-30','12:38:00','PLG0011510','SULIS','2026-06-10','kasirbip','2026-05-30 12:38:00','2.000','0','0','0','1100000','0','750000','1650000','1650000','550000'); UPDATE tt_service_head SET tgl_selesai='2026-05-30', status ='DONE' WHERE no_service='SV-02082'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02082'; 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-05-30', status ='CLOS' WHERE no_service='SV-02082'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02082'; 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-02268','SULIS','1','PLD','WED RING','','','2.500','','10.00','1','1200000','350000','0','750000','1625000','1 zircon putih dof semprot sz 18','font vladimir grf Dian','ecpres bayar di akhir','0','','200000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0005','2026-05-30','2026-05-30 12:41:30','PESANAN : DP-02268','.','TBC','1300000','1300000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0006','D','2026-05-30','12:41:30','TBC','PESANAN','DP-02268','22979292514','1300000','22980592514','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-02268','2026-05-30','2026-05-30','12:41:30','PLG0011511','SULIS','2026-06-10','kasirbip','2026-05-30 12:41:30','2.500','0','0','0','1300000','0','750000','1825000','1825000','525000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0002'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-30 ','13:29:37'); 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-02269','SAL ','1','PER','WED RING','','','2.000','','925.00','1','100000','0','1250000','0','1250000','putih glosy 39 zirkon','sz 14 font vladimir','grf Ridwan . . .','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0006','2026-05-30','2026-05-30 13:30:05','PESANAN : DP-02269','.','TBC','1250000','1250000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0007','D','2026-05-30','13:30:05','TBC','PESANAN','DP-02269','22980592514','1250000','22981842514','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-02269','2026-05-30','2026-05-30','13:30:05','PLG0011512','SAL ','2026-06-30','kasirbip','2026-05-30 13:30:05','2.000','0','0','0','1250000','0','0','1250000','1250000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-30 ','13:31:34'); 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-02270','SAL','1','PER','WED RING','','','3.000','','925.00','1','100000','0','850000','0','850000','1 zirkon putih doff semprot','sz 14.5 font vladimir','grf Wdya . . .','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0007','2026-05-30','2026-05-30 13:32:47','PESANAN : DP-02270','.','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-260530-0008','D','2026-05-30','13:32:47','TBC','PESANAN','DP-02270','22981842514','850000','22982692514','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-02270','2026-05-30','2026-05-30','13:32:47','PLG0011513','SAL','2026-06-30','kasirbip','2026-05-30 13:32:47','3.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-260530-0004','sby','1',' 500K-19-00','TOKO','SBYPER','PSBY-ZEXA-66-0','CINCIN SILVER 925 YL-01 ','','1.810','1','100.00','185000','0','0','17800','600000','0','0','0','600000','DIL','00043088','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-66-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSBY-ZEXA-66-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0004','2026-05-30','1.810','2026-05-30','13:33:06','PLG0011514','600000','600000','0','600000','0','sby','2026-05-30 13:33:06','FJ-260530-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-05-30','FJ-260530-0004','2026-05-30','13:33:06','DIL','600000','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-260530-0008','2026-05-30','2026-05-30 13:33:06','PENJUALAN : FJ-260530-0004','','TBC','600000','600000','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-260530-0009','D','2026-05-30','13:33:06','TBC','PENJUALAN BERLIAN','FJ-260530-0004','22982692514','600000','22983292514','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='600000' WHERE no_faktur_jual='FJ-260530-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0004'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0005','kasirbip','1',' 700K-19-00','TOKO','DUPERBDG','LXPER-ZEXF-43-0','CINCIN SILVER 925 ','','1.860','1','100.00','190000','0','0','17800','800000','0','0','0','800000','KUR','00043337','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEXF-43-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.860',berat_jual_asli=berat_jual_asli+'1.860',stock_jual='1',berat_akhir=berat_akhir-'1.860',berat_akhir_asli=berat_akhir_asli-'1.860',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='LXPER-ZEXF-43-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-260530-0005','2026-05-30','1.860','2026-05-30','13:39:04','PLG0011515','800000','800000','0','800000','0','kasirbip','2026-05-30 13:39:03','FJ-260530-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0005','2026-05-30','13:39:04','KUR','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-260530-0009','2026-05-30','2026-05-30 13:39:03','PENJUALAN : FJ-260530-0005','.','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-260530-0010','D','2026-05-30','13:39:04','TBC','PENJUALAN BERLIAN','FJ-260530-0005','22983292514','800000','22984092514','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-260530-0005' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0005'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0006','kasirbip','1',' 750K-115-2','TOKO','BIPPER','PBDG-ZEBB-32-0','CINCIN SILVER 925 ','','1.340','1','100.00','137000','0','0','17800','850000','0','0','0','850000','GIN','00043744','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEBB-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PBDG-ZEBB-32-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-260530-0006','2026-05-30','1.340','2026-05-30','14:14:54','PLG0011516','850000','850000','0','850000','0','kasirbip','2026-05-30 14:14:54','FJ-260530-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-05-30','FJ-260530-0006','2026-05-30','14:14:54','GIN','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-260530-0010','2026-05-30','2026-05-30 14:14:54','PENJUALAN : FJ-260530-0006','.','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-260530-0011','D','2026-05-30','14:14:54','TBC','PENJUALAN BERLIAN','FJ-260530-0006','22984092514','850000','22984942514','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-260530-0006' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0006'; 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-02271','PUT','1','PER','WEDD RING','','','2.000','','925.00','1','100000','0','800000','0','800000','sz 21.5 crom putih gllosy','grf Ruslan font Vintage','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0011','2026-05-30','2026-05-30 14:18:29','PESANAN : DP-02271','.','TBC','800000','800000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0012','D','2026-05-30','14:18:29','TBC','PESANAN','DP-02271','22984942514','800000','22985742514','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-02271','2026-05-30','2026-05-30','14:18:29','PLG0011517','PUT','2026-06-19','kasirbip','2026-05-30 14:18:29','2.000','0','0','0','800000','0','0','800000','800000','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-02272','PUT','1','PLD','WEDD RING','','','3.000','','10.00','1','1200000','350000','0','700000','1750000','YL 01 jangan lebih dari 3gram','sz 18 grf Ruslan font vintage','','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0012','2026-05-30','2026-05-30 14:22:39','PESANAN : DP-02272','.','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-260530-0013','D','2026-05-30','14:22:39','TBC','PESANAN','DP-02272','22985742514','1400000','22987142514','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-02272','2026-05-30','2026-05-30','14:22:39','PLG0011518','PUT','2026-06-19','kasirbip','2026-05-30 14:22:39','3.000','0','0','0','1400000','0','700000','1750000','1750000','350000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-30 ','15:23:52'); 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-260530-0007','kasirbip','1',' DP-01969BI','TOKO','BIPPSN','PSGT-ZEXH-4-0','CINCIN EMAS ','','3.060','1','83.00','6348000','0','0','17800','8124000','0','0','0','8124000','KUR','00043378','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZEXH-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSGT-ZEXH-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0007','2026-05-30','3.060','2026-05-30','15:24:53','PLG0011519','8124000','8124000','0','8124000','0','kasirbip','2026-05-30 15:24:52','FJ-260530-0007','DP-01969','6000000'); 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-05-30','FJ-260530-0007','2026-05-30','15:24:53','KUR','8124000','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-260530-0013','2026-05-30','2026-05-30 15:24:52','PENJUALAN : FJ-260530-0007','.','TBC','2124000','2124000','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-260530-0014','D','2026-05-30','15:24:53','TBC','PENJUALAN','FJ-260530-0007','22987142514','2124000','22989266514','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='2124000' WHERE no_faktur_jual='FJ-260530-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-260530-0008','kasirbip','1',' DP-01970BI','TOKO','BIPPSN','PSPLT-ZEXF-7-0','CINCIN PALADIUM ','','2.770','1','17.00','623000','0','0','17800','1581000','0','0','0','1581000','KUR','00043301','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEXF-7-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.770',berat_jual_asli=berat_jual_asli+'2.770',stock_jual='1',berat_akhir=berat_akhir-'2.770',berat_akhir_asli=berat_akhir_asli-'2.770',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPLT-ZEXF-7-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-260530-0008','2026-05-30','2.770','2026-05-30','15:25:51','PLG0011520','1581000','1581000','0','1581000','0','kasirbip','2026-05-30 15:25:50','FJ-260530-0008','DP-01970','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-05-30','FJ-260530-0008','2026-05-30','15:25:51','KUR','1581000','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-260530-0014','2026-05-30','2026-05-30 15:25:50','PENJUALAN : FJ-260530-0008','.','TBC','581000','581000','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-260530-0015','D','2026-05-30','15:25:51','TBC','PENJUALAN','FJ-260530-0008','22989266514','581000','22989847514','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='581000' WHERE no_faktur_jual='FJ-260530-0008' LIMIT 1; UPDATE tt_service_head SET tgl_selesai='2026-05-30', status ='DONE' WHERE no_service='SV-02068'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02068'; 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-05-30', status ='CLOS' WHERE no_service='SV-02068'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02068'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-30 ','15:52:11'); 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-260530-0009','kasir','1',' TFCMR75-85','TOKO','TFCINMAS','TFCMR-YIXA-72-0','THIFA CINCIN MAS RG ','','1.180','1','85.00','2477000','0','0','17800','2550000','0','0','0','2550000','FAISAL','00038442','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YIXA-72-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='TFCMR-YIXA-72-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0009','2026-05-30','1.180','2026-05-30','15:58:11','PLG0011521','2550000','2550000','0','2550000','0','kasir','2026-05-30 15:58:10','FJ-260530-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-05-30','FJ-260530-0009','2026-05-30','15:58:11','FAISAL','2550000','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-260530-0015','2026-05-30','2026-05-30 15:58:10','PENJUALAN : FJ-260530-0009','.','TBC','2550000','2550000','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-260530-0016','D','2026-05-30','15:58:11','TBC','PENJUALAN','FJ-260530-0009','22989847514','2550000','22992397514','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='2550000' WHERE no_faktur_jual='FJ-260530-0009' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0008'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-30 ','16:15: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-260530-0010','kasirbip','1',' 750K-175-2','TOKO','BIPPER','PBDG-ZEBB-29-0','CINCIN SILVER 925 ','','2.110','1','100.00','216000','0','0','17800','850000','0','0','0','850000','SULIS','00043741','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEBB-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PBDG-ZEBB-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0010','2026-05-30','2.110','2026-05-30','16:16:34','PLG0011522','850000','850000','0','850000','0','kasirbip','2026-05-30 16:16:33','FJ-260530-0010','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0010','2026-05-30','16:16:34','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-260530-0016','2026-05-30','2026-05-30 16:16:33','PENJUALAN : FJ-260530-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-260530-0017','D','2026-05-30','16:16:34','TBC','PENJUALAN BERLIAN','FJ-260530-0010','22992397514','850000','22993247514','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-260530-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-260530-0011','kasirbip',' 1',' 750K-125-2','TOKO','BIPPER','PBDG-ZDAX-16-0','CINCIN SILVER 925 ','','1.430','1','100.00','146000','0','0','17800','850000','0','0','0','850000','SULIS','00042453','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAX-16-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.430',berat_jual_asli=berat_jual_asli+'1.430',stock_jual='1',berat_akhir=berat_akhir-'1.430',berat_akhir_asli=berat_akhir_asli-'1.430',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PBDG-ZDAX-16-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-260530-0011','2026-05-30','1.430','2026-05-30','16:16:34','PLG0011523','850000','850000','0','850000','0','kasirbip','2026-05-30 16:16:33','FJ-260530-0010','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0011','2026-05-30','16:16:34','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-260530-0017','2026-05-30','2026-05-30 16:16:33','PENJUALAN : FJ-260530-0011','.','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-260530-0018','D','2026-05-30','16:16:34','TBC','PENJUALAN BERLIAN','FJ-260530-0011','22993247514','850000','22994097514','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-260530-0011' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0011'; UPDATE tt_service_head SET tgl_selesai='2026-05-30', status ='DONE' WHERE no_service='SV-02078'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02078'; 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-05-30', status ='CLOS' WHERE no_service='SV-02078'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02078'; 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-02273','SAL','1','GOLD','WED RING','','','3.000','','37.50','1','2420000','1500000','0','900000','5400000','putih glosy 14 zirkon','sz 18 font vladimir','grf Anbiya','140000','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0018','2026-05-30','2026-05-30 16:50:01','PESANAN : DP-02273','.','TBC','4432000','4432000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0019','D','2026-05-30','16:50:01','TBC','PESANAN','DP-02273','22994097514','4432000','22998529514','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-02273','2026-05-30','2026-05-30','16:50:01','PLG0011524','SAL','2026-06-30','kasirbip','2026-05-30 16:50:01','3.000','0','0','0','4432000','0','900000','5540000','5540000','1108000'); 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-02274','SAL','1','PLD','WED RING','','','3.000','','10.00','1','1200000','350000','0','800000','1850000','putih glosy comb putih doff semprot 3 zirkon','sz 16 font vladimir','grf Nurul','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0019','2026-05-30','2026-05-30 16:53:56','PESANAN : DP-02274','.','TBC','1480000','1480000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0020','D','2026-05-30','16:53:56','TBC','PESANAN','DP-02274','22998529514','1480000','23000009514','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-02274','2026-05-30','2026-05-30','16:53:56','PLG0011525','SAL','2026-06-30','kasirbip','2026-05-30 16:53:56','3.000','0','0','0','1480000','0','800000','1850000','1850000','370000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-30 ','17:01:13'); 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-260530-0012','kasir','1',' DP-02044MM','TOKO','MMPSN','PSPLT-ZEAA-2-0','CINCIN PALADIUM YL-10 ','','4.500','1','17.00','1011000','0','0','17800','2100000','0','0','0','2100000','ELLA','00043394','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEAA-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.500',berat_jual_asli=berat_jual_asli+'4.500',stock_jual='1',berat_akhir=berat_akhir-'4.500',berat_akhir_asli=berat_akhir_asli-'4.500',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPLT-ZEAA-2-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-260530-0012','2026-05-30','4.500','2026-05-30','17:08:10','PLG0011526','2100000','2100000','0','2100000','0','kasir','2026-05-30 17:08:10','FJ-260530-0012','DP-02044','1680000'); 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-05-30','FJ-260530-0012','2026-05-30','17:08:10','ELLA','2100000','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-260530-0020','2026-05-30','2026-05-30 17:08:10','PENJUALAN : FJ-260530-0012','0','TBC','420000','420000','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-260530-0021','D','2026-05-30','17:08:10','TBC','PENJUALAN','FJ-260530-0012','23000009514','420000','23000429514','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='420000' WHERE no_faktur_jual='FJ-260530-0012' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0013','kasir','1',' 1.0K-11-98','TOKO','MMPER','PMM-ZEBA-31-0','CINCIN SILVER 925 ','','2.210','1','100.00','226000','0','0','17800','1100000','0','0','0','1100000','ELLA','00043710','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZEBA-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PMM-ZEBA-31-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-260530-0013','2026-05-30','2.210','2026-05-30','17:20:52','PLG0011527','1100000','1100000','0','1100000','0','kasir','2026-05-30 17:20:51','FJ-260530-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-05-30','FJ-260530-0013','2026-05-30','17:20:52','ELLA','1100000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260530-0021','2026-05-30','2026-05-30 17:20:51','PENJUALAN : FJ-260530-0013','0','TBC','1100000','1100000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0022','D','2026-05-30','17:20:52','TBC','PENJUALAN BERLIAN','FJ-260530-0013','23000429514','1100000','23001529514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1100000' WHERE no_faktur_jual='FJ-260530-0013' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-30 ','17:25:18'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-05-30 ','17:27:07'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-30 ','17:27:41'); DELETE FROM tm_berlian WHERE kode_barang='PMM-YFBX-102-0'; INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('PMM-YFBX-102-0','','','','','',''); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('','','','','','','') 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 ('PMM-YFBX-102-0','00036543','00036543','CINCIN SILVER 925 ','CINCIN SILVER 925','','','53000','53000',' 150000','150000','Nagatech','2026-05-30 17:27:48'); UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-185-00090 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='PMM-YFBX-102-0' 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-260530-0014','Nagatech','1',' 700K-185-0','TOKO','MMPER','PMM-YFBX-102-0','CINCIN SILVER 925','','2.640','1','100.00','61000','0','0','17800','800000','0','0','0','800000','ELLA','00036543','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YFBX-102-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-05-30' AND kode_barang='PMM-YFBX-102-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-260530-0014','2026-05-30','2.640','2026-05-30','17:29:25','PLG0011528','800000','800000','0','800000','0','Nagatech','2026-05-30 17:29:25','FJ-260530-0014','','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-05-30','FJ-260530-0014','2026-05-30','17:29:25','ELLA','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-260530-0022','2026-05-30','2026-05-30 17:29:25','PENJUALAN : FJ-260530-0014','0','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-260530-0023','D','2026-05-30','17:29:25','TBC','PENJUALAN BERLIAN','FJ-260530-0014','23001529514','800000','23002329514','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='800000' WHERE no_faktur_jual='FJ-260530-0014' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0015','sby','1',' 850K-115-0','TOKO','SBYPER','PSBY-ZEXA-80-0','CINCIN SILVER 925 ','','2.030','1','100.00','208000','0','0','17800','950000','0','0','0','950000','DIL','00043102','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXA-80-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSBY-ZEXA-80-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0015','2026-05-30','2.030','2026-05-30','17:29:29','PLG0011529','950000','950000','0','950000','0','sby','2026-05-30 17:29:29','FJ-260530-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-05-30','FJ-260530-0015','2026-05-30','17:29:29','DIL','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-260530-0023','2026-05-30','2026-05-30 17:29:29','PENJUALAN : FJ-260530-0015','','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-260530-0024','D','2026-05-30','17:29:29','TBC','PENJUALAN BERLIAN','FJ-260530-0015','23002329514','950000','23003279514','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-260530-0015' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0016','sby',' 1',' 750K-15-00','TOKO','SBYPER','PSBY-ZEXD-33-0','CINCIN SILVER 925 ','','2.490','1','100.00','255000','0','0','17800','850000','0','0','0','850000','DIL','00043165','PSBY','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSBY-ZEXD-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.490',berat_jual_asli=berat_jual_asli+'2.490',stock_jual='1',berat_akhir=berat_akhir-'2.490',berat_akhir_asli=berat_akhir_asli-'2.490',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSBY-ZEXD-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0016','2026-05-30','2.490','2026-05-30','17:29:29','PLG0011530','850000','850000','0','850000','0','sby','2026-05-30 17:29:29','FJ-260530-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-05-30','FJ-260530-0016','2026-05-30','17:29:29','DIL','850000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260530-0024','2026-05-30','2026-05-30 17:29:29','PENJUALAN : FJ-260530-0016','','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-260530-0025','D','2026-05-30','17:29:29','TBC','PENJUALAN BERLIAN','FJ-260530-0016','23003279514','850000','23004129514','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-260530-0016' LIMIT 1; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02090','KUR','1','CINCIN PALADIUM','REPARASI DIBULATKAN LAGI SIZE 21 5 PLUS CROM ULANG SEPERTI SEMULA PUTIH DOFF AMPLAS SEPINGGANG GRF 131225','3.850','1','100000','100000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260530-0025','2026-05-30','2026-05-30 17:37:31','SERVICE : SV-02090','.','TBC','100000','100000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0026','D','2026-05-30','17:37:31','TBC','SERVICE','SV-02090','23004129514','100000','23004229514','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02090','2026-05-30','2026-05-30','17:37:31','PLG0011531','kasirbip','2026-05-17','kasirbip','2026-05-30 17:37:31','3.850','0','0','0','100000','0','100000','100000','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-30 ','17:38:01'); INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02091','ELLA','1','WEDDING RING','GRF CWE FIRMAN GRF CWO PENTI CROM ULANG SESUAI WARNA','4.850','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02091','2026-05-30','2026-05-30','17:39:11','PLG0011532','Nagatech','2026-06-03','Nagatech','2026-05-30 17:39:11','4.850','0','0','0','0','0','0','0','0'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0015'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0016'; 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-260530-0017','Nagatech','1',' 750K-20-95','TOKO','MMPER','PMM-ZDBI-45-0','CINCIN SILVER 925 ','','2.380','1','100.00','243000','0','0','17800','850000','0','0','0','850000','ALIKA','00042943','PMM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-ZDBI-45-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.380',berat_jual_asli=berat_jual_asli+'2.380',stock_jual='1',berat_akhir=berat_akhir-'2.380',berat_akhir_asli=berat_akhir_asli-'2.380',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PMM-ZDBI-45-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-260530-0017','2026-05-30','2.380','2026-05-30','17:43:09','PLG0011533','850000','850000','0','850000','0','Nagatech','2026-05-30 17:43:08','FJ-260530-0017','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0017','2026-05-30','17:43:09','ALIKA','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-260530-0026','2026-05-30','2026-05-30 17:43:08','PENJUALAN : FJ-260530-0017','0','TBC','850000','850000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0027','D','2026-05-30','17:43:09','TBC','PENJUALAN BERLIAN','FJ-260530-0017','23004229514','850000','23005079514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('0','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-260530-0017' LIMIT 1; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02092','RIRIN','1','WEDDING RING','CWE RESIZE 12 5 CWO PASANG 1 MATA ZIRCON CROM ULANG SESUAI MODEL','4.000','2','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02092','2026-05-30','2026-05-30','17:50:27','PLG0011534','Nagatech','2026-06-03','Nagatech','2026-05-30 17:50:27','4.000','0','0','0','0','0','0','0','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-260530-0018','kasirbip','1',' DP-02160BI','TOKO','BIPPSN','PSPLT-ZEBB-17-0','CINCIN PALADIUM YL-10 ','','5.580','1','32.00','2358000','0','0','17800','3290000','0','0','0','3290000','SULIS','00043729','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBB-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.580',berat_jual_asli=berat_jual_asli+'5.580',stock_jual='1',berat_akhir=berat_akhir-'5.580',berat_akhir_asli=berat_akhir_asli-'5.580',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPLT-ZEBB-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0018','2026-05-30','5.580','2026-05-30','18:07:57','PLG0011535','3290000','3290000','0','3290000','0','kasirbip','2026-05-30 18:07:57','FJ-260530-0018','DP-02160','2700000'); 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-05-30','FJ-260530-0018','2026-05-30','18:07:57','SULIS','3290000','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-260530-0027','2026-05-30','2026-05-30 18:07:57','PENJUALAN : FJ-260530-0018','.','TBC','590000','590000','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-260530-0028','D','2026-05-30','18:07:57','TBC','PENJUALAN','FJ-260530-0018','23005079514','590000','23005669514','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='590000' WHERE no_faktur_jual='FJ-260530-0018' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0017'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0018'; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02093','SULIS','1','SEPASANG SILVER','PUTIH GLOSY KEDUANYA FONT VINTAGE ROTTER','4.000','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02093','2026-05-30','2026-05-30','18:18:15','PLG0011536','kasirbip','2026-06-16','kasirbip','2026-05-30 18:18:15','4.000','0','0','0','0','0','0','0','0'); UPDATE tt_service_head SET tgl_selesai='2026-05-30', status ='DONE' WHERE no_service='SV-02080'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02080'; 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-05-30', status ='CLOS' WHERE no_service='SV-02080'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02080'; 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-260530-0019','kasirbip','1',' 800K-17-24','TOKO','BIPPER','PBDG-ZDAX-25-0','CINCIN SILVER 925 ','','3.550','1','100.00','363000','0','0','17800','950000','0','0','0','950000','GIN','00042462','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDAX-25-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.550',berat_jual_asli=berat_jual_asli+'3.550',stock_jual='1',berat_akhir=berat_akhir-'3.550',berat_akhir_asli=berat_akhir_asli-'3.550',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PBDG-ZDAX-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-260530-0019','2026-05-30','3.550','2026-05-30','18:35:14','PLG0011537','950000','950000','0','950000','0','kasirbip','2026-05-30 18:35:14','FJ-260530-0019','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0019','2026-05-30','18:35:14','GIN','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-260530-0028','2026-05-30','2026-05-30 18:35:14','PENJUALAN : FJ-260530-0019','.','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-260530-0029','D','2026-05-30','18:35:14','TBC','PENJUALAN BERLIAN','FJ-260530-0019','23005669514','950000','23006619514','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-260530-0019' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0020','kasirbip',' 1',' 950K-105-2','TOKO','BIPPER','PBDG-ZEXF-26-0','CINCIN SILVER 925 ','','1.540','1','100.00','158000','0','0','17800','1100000','0','0','0','1100000','GIN','00043320','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEXF-26-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-05-30' AND kode_barang='PBDG-ZEXF-26-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-260530-0020','2026-05-30','1.540','2026-05-30','18:35:14','PLG0011538','1100000','1100000','0','1100000','0','kasirbip','2026-05-30 18:35:14','FJ-260530-0019','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0020','2026-05-30','18:35:14','GIN','1100000','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260530-0029','2026-05-30','2026-05-30 18:35:14','PENJUALAN : FJ-260530-0020','.','TBC','1100000','1100000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0030','D','2026-05-30','18:35:14','TBC','PENJUALAN BERLIAN','FJ-260530-0020','23006619514','1100000','23007719514','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2050000' WHERE no_faktur_jual='FJ-260530-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-260530-0021','kasirbip','1',' DP-02148BI','TOKO','BIPPSN','PSPRT-ZEBF-4-0','CINCIN PERAK SR-04 YL-01 ','','2.970','1','100.00','303000','0','0','17800','950000','0','0','0','950000','SULIS','00043794','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBF-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPRT-ZEBF-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0021','2026-05-30','2.970','2026-05-30','18:38:53','PLG0011539','950000','950000','0','950000','0','kasirbip','2026-05-30 18:38:52','FJ-260530-0021','DP-02148','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-05-30','FJ-260530-0021','2026-05-30','18:38:53','SULIS','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-260530-0021' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0020'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0021'; 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-20260530-0001','1','PSGT-ZEBI-7-0','1','2.320','2.320','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBI-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBI-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBI-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-30 18:45:31' WHERE kode_barang='PSGT-ZEBI-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBI-7-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-05-30 18:45:31','TOKO','DUPSN','PSGT','PSGT-ZEBI-7-0','1','2.320','2.320','1','2.320','2.320','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZEBI-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0001','1','PSPRT-ZEBI-8-0','1','3.140','3.140','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBI-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBI-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBI-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-30 18:45:31' WHERE kode_barang='PSPRT-ZEBI-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBI-8-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-05-30 18:45:31','TOKO','DUPSN','PSPRT','PSPRT-ZEBI-8-0','1','3.140','3.140','1','3.140','3.140','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-ZEBI-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0001','1','PSPRT-ZEBI-47-0','1','3.030','3.030','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBI-47-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-47-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBI-47-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBI-47-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-30 18:45:31' WHERE kode_barang='PSPRT-ZEBI-47-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBI-47-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-05-30 18:45:31','TOKO','DUPSN','PSPRT','PSPRT-ZEBI-47-0','1','3.030','3.030','1','3.030','3.030','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-ZEBI-47-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-47-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0001','1','PSPLT-ZEBI-48-0','1','1.780','1.780','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBI-48-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-48-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBI-48-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBI-48-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-30 18:45:31' WHERE kode_barang='PSPLT-ZEBI-48-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBI-48-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-05-30 18:45:31','TOKO','DUPSN','PSPLT','PSPLT-ZEBI-48-0','1','1.780','1.780','1','1.780','1.780','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZEBI-48-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-48-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0001','1','PSPLT-ZEBI-49-0','1','4.520','4.520','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBI-49-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-49-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBI-49-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBI-49-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-30 18:45:31' WHERE kode_barang='PSPLT-ZEBI-49-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBI-49-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-05-30 18:45:31','TOKO','DUPSN','PSPLT','PSPLT-ZEBI-49-0','1','4.520','4.520','1','4.520','4.520','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZEBI-49-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-49-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0001','1','PSPRT-ZEBI-50-0','1','1.910','1.910','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBI-50-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-50-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBI-50-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBI-50-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-30 18:45:31' WHERE kode_barang='PSPRT-ZEBI-50-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBI-50-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-05-30 18:45:31','TOKO','DUPSN','PSPRT','PSPRT-ZEBI-50-0','1','1.910','1.910','1','1.910','1.910','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZEBI-50-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-50-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0001','1','PSPRT-ZEBI-51-0','1','3.910','3.910','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBI-51-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-51-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBI-51-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBI-51-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-30 18:45:31' WHERE kode_barang='PSPRT-ZEBI-51-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBI-51-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-05-30 18:45:31','TOKO','DUPSN','PSPRT','PSPRT-ZEBI-51-0','1','3.910','3.910','1','3.910','3.910','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZEBI-51-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-51-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0001','1','PSPLT-ZEBI-52-0','1','3.550','3.550','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBI-52-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-52-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBI-52-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBI-52-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-05-30 18:45:31' WHERE kode_barang='PSPLT-ZEBI-52-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBI-52-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-05-30 18:45:31','TOKO','DUPSN','PSPLT','PSPLT-ZEBI-52-0','1','3.550','3.550','1','3.550','3.550','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZEBI-52-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-52-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260530-0001','2026-05-30','18:44','24.160','kasirbip','2026-05-30 18:45:31'); 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-20260530-0002','1','LXPER-ZEBI-31-0','1','1.310','1.310','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-31-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-31-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-31-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-31-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-31-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-31-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-31-0','1','1.310','1.310','1','1.310','1.310','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-31-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-31-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0002','1','LXPER-ZEBI-32-0','1','1.700','1.700','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-32-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-32-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-32-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-32-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-32-0','1','1.700','1.700','1','1.700','1.700','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-32-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0002','1','LXPER-ZEBI-33-0','1','1.400','1.400','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-33-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-33-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-33-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-33-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-33-0','1','1.400','1.400','1','1.400','1.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-33-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0002','1','LXPER-ZEBI-34-0','1','1.630','1.630','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-34-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-34-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-34-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-34-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-34-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-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-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-34-0','1','1.630','1.630','1','1.630','1.630','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-34-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-34-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0002','1','LXPER-ZEBI-35-0','1','1.320','1.320','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-35-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-35-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-35-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-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-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-35-0','1','1.320','1.320','1','1.320','1.320','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-35-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0002','1','LXPER-ZEBI-36-0','1','1.180','1.180','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-36-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-36-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-36-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-36-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-36-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-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-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-36-0','1','1.180','1.180','1','1.180','1.180','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-36-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-36-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0002','1','LXPER-ZEBI-37-0','1','1.820','1.820','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-37-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-37-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-37-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-37-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-37-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-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-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-37-0','1','1.820','1.820','1','1.820','1.820','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-37-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-37-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0002','1','LXPER-ZEBI-38-0','1','1.250','1.250','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-38-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-38-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-38-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-38-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-38-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-38-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-38-0','1','1.250','1.250','1','1.250','1.250','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-38-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-38-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0002','1','LXPER-ZEBI-39-0','1','1.810','1.810','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-39-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-39-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-39-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-39-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-39-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-39-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-39-0','1','1.810','1.810','1','1.810','1.810','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-39-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-39-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0002','1','LXPER-ZEBI-40-0','1','1.730','1.730','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZEBI-40-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-40-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZEBI-40-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZEBI-40-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-05-30 18:46:25' WHERE kode_barang='LXPER-ZEBI-40-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZEBI-40-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:46:25','TOKO','DUPERBDG','LXPER','LXPER-ZEBI-40-0','1','1.730','1.730','1','1.730','1.730','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' 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='LXPER-ZEBI-40-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZEBI-40-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260530-0002','2026-05-30','18:45','15.150','kasirbip','2026-05-30 18:46:25'); 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-20260530-0003','1','PBDG-ZEBI-11-0','1','1.240','1.240','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-11-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-11-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-11-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-11-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-11-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-11-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-11-0','1','1.240','1.240','1','1.240','1.240','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-ZEBI-11-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-11-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-12-0','1','2.670','2.670','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-12-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-12-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-12-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-12-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-12-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-12-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-12-0','1','2.670','2.670','1','2.670','2.670','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-ZEBI-12-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-12-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-13-0','1','1.540','1.540','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-13-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-13-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-13-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-13-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-13-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-13-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-13-0','1','1.540','1.540','1','1.540','1.540','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-ZEBI-13-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-13-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-14-0','1','1.280','1.280','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-14-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-14-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-14-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-14-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-14-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-14-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-14-0','1','1.280','1.280','1','1.280','1.280','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-ZEBI-14-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-14-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-15-0','1','2.780','2.780','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-15-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-15-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-15-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-15-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-15-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-15-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-15-0','1','2.780','2.780','1','2.780','2.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-ZEBI-15-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-15-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-16-0','1','3.420','3.420','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-16-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-16-0','1','3.420','3.420','1','3.420','3.420','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-ZEBI-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-17-0','1','3.360','3.360','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-17-0','1','3.360','3.360','1','3.360','3.360','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-ZEBI-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-18-0','1','2.140','2.140','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-18-0','1','2.140','2.140','1','2.140','2.140','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-ZEBI-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-19-0','1','3.380','3.380','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-19-0','1','3.380','3.380','1','3.380','3.380','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-ZEBI-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-20-0','1','1.160','1.160','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-20-0','1','1.160','1.160','1','1.160','1.160','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-ZEBI-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-21-0','1','1.790','1.790','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-21-0','1','1.790','1.790','1','1.790','1.790','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-ZEBI-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-22-0','1','1.260','1.260','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-22-0','1','1.260','1.260','1','1.260','1.260','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-ZEBI-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-23-0','1','1.220','1.220','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-23-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-23-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-23-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-23-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-23-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-23-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-23-0','1','1.220','1.220','1','1.220','1.220','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-ZEBI-23-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-23-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-24-0','1','1.230','1.230','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-24-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-24-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-24-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-24-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-24-0','1','1.230','1.230','1','1.230','1.230','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-ZEBI-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-24-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-25-0','1','2.200','2.200','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-25-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-25-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-25-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-25-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-25-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-25-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-25-0','1','2.200','2.200','1','2.200','2.200','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-ZEBI-25-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-25-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-26-0','1','2.460','2.460','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-26-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-26-0','1','2.460','2.460','1','2.460','2.460','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-ZEBI-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-27-0','1','1.560','1.560','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-27-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-27-0','1','1.560','1.560','1','1.560','1.560','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-ZEBI-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-28-0','1','1.480','1.480','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-28-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-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-28-0','1','1.480','1.480','1','1.480','1.480','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-ZEBI-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-29-0','1','1.780','1.780','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-29-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-29-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-29-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-29-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-29-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-29-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-29-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-ZEBI-29-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-29-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0003','1','PBDG-ZEBI-30-0','1','2.350','2.350','TOKO','PBDG','TOKO','BIPPER'); DELETE FROM tm_barang WHERE kode_barang='PBDG-ZEBI-30-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-30-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZEBI-30-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZEBI-30-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-05-30 18:51:51' WHERE kode_barang='PBDG-ZEBI-30-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZEBI-30-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:51:51','TOKO','BIPPER','PBDG','PBDG-ZEBI-30-0','1','2.350','2.350','1','2.350','2.350','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-ZEBI-30-0'; DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZEBI-30-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260530-0003','2026-05-30','18:51','40.300','kasirbip','2026-05-30 18:51:51'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-30 ','18:51:32'); 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-260530-0022','Nagatech','1',' DP-02161MM','TOKO','MMPSN','PSPRT-ZEBI-2-0','CINCIN PERAK SR-03 YL-01 ','','3.510','1','100.00','359000','0','0','17800','950000','0','0','0','950000','RIRIN','00043828','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBI-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPRT-ZEBI-2-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-260530-0022','2026-05-30','3.510','2026-05-30','18:56:36','PLG0011540','950000','950000','0','950000','0','Nagatech','2026-05-30 18:56:35','FJ-260530-0022','DP-02161','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-05-30','FJ-260530-0022','2026-05-30','18:56:36','RIRIN','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-260530-0022' 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-20260530-0004','1','PSPLT-ZEBI-4-0','1','1.490','1.490','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZEBI-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-4-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZEBI-4-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZEBI-4-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-30 18:57:14' WHERE kode_barang='PSPLT-ZEBI-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZEBI-4-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-05-30 18:57:14','TOKO','BIPPSN','PSPLT','PSPLT-ZEBI-4-0','1','1.490','1.490','1','1.490','1.490','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZEBI-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZEBI-4-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0004','1','PSPRT-ZEBI-5-0','1','1.590','1.590','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBI-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBI-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBI-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-30 18:57:14' WHERE kode_barang='PSPRT-ZEBI-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBI-5-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-05-30 18:57:14','TOKO','BIPPSN','PSPRT','PSPRT-ZEBI-5-0','1','1.590','1.590','1','1.590','1.590','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-ZEBI-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0004','1','PSGT-ZEBI-6-0','1','1.170','1.170','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZEBI-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZEBI-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZEBI-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-30 18:57:14' WHERE kode_barang='PSGT-ZEBI-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZEBI-6-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-05-30 18:57:14','TOKO','BIPPSN','PSGT','PSGT-ZEBI-6-0','1','1.170','1.170','1','1.170','1.170','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZEBI-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZEBI-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0004','1','PSPRT-ZEBI-45-0','1','3.070','3.070','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBI-45-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-45-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBI-45-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBI-45-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-30 18:57:14' WHERE kode_barang='PSPRT-ZEBI-45-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBI-45-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:57:14','TOKO','BIPPSN','PSPRT','PSPRT-ZEBI-45-0','1','3.070','3.070','1','3.070','3.070','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-ZEBI-45-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-45-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' 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-20260530-0004','1','PSPRT-ZEBI-46-0','1','3.110','3.110','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZEBI-46-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-46-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZEBI-46-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZEBI-46-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-05-30 18:57:14' WHERE kode_barang='PSPRT-ZEBI-46-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZEBI-46-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-05-30 18:57:14','TOKO','BIPPSN','PSPRT','PSPRT-ZEBI-46-0','1','3.110','3.110','1','3.110','3.110','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-ZEBI-46-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZEBI-46-0'; UPDATE tt_beli_detail SET tgl_terima='2026-05-30' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260530-0004','2026-05-30','18:56','10.430','kasirbip','2026-05-30 18:57:14'); UPDATE tt_service_head SET tgl_selesai='2026-05-30', status ='DONE' WHERE no_service='SV-02075'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02075'; UPDATE tt_service_head SET tgl_selesai='2026-05-30', status ='DONE' WHERE no_service='SV-02079'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02079'; UPDATE tt_service_head SET tgl_selesai='2026-05-30', status ='DONE' WHERE no_service='SV-02057'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02057'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-05-30 ','19:03:35'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0023','kasirbip','1',' DP-02198BI','TOKO','BIPPSN','PSPRT-ZEBI-45-0','CINCIN PERAK ','','3.070','1','100.00','314000','0','0','17800','1050000','0','0','0','1050000','SULIS','00043871','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBI-45-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPRT-ZEBI-45-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-260530-0023','2026-05-30','3.070','2026-05-30','19:14:12','PLG0011541','1050000','1050000','0','1050000','0','kasirbip','2026-05-30 19:14:12','FJ-260530-0023','DP-02198','1050000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0023','2026-05-30','19:14:12','SULIS','1050000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260530-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-260530-0024','kasirbip',' 1',' DP-02199BI','TOKO','BIPPSN','PSPRT-ZEBI-46-0','CINCIN PERAK ','','3.110','1','100.00','318000','0','0','17800','1050000','0','0','0','1050000','SULIS','00043872','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBI-46-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.110',berat_jual_asli=berat_jual_asli+'3.110',stock_jual='1',berat_akhir=berat_akhir-'3.110',berat_akhir_asli=berat_akhir_asli-'3.110',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPRT-ZEBI-46-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-260530-0024','2026-05-30','3.110','2026-05-30','19:14:12','PLG0011542','1050000','1050000','0','1050000','0','kasirbip','2026-05-30 19:14:12','FJ-260530-0023','DP-02199','1050000'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0024','2026-05-30','19:14:12','SULIS','1050000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260530-0024' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0023' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0023' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0023'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0024' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0024' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0024'; 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-260530-0025','kasirbip','1',' DP-02049BI','TOKO','BIPPSN','PSPRT-ZEBX-4-0','CINCIN PERAK ','','1.460','1','100.00','149000','0','0','17800','850000','0','0','0','850000','SULIS','00043649','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBX-4-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPRT-ZEBX-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0025','2026-05-30','1.460','2026-05-30','19:30:33','PLG0011543','850000','850000','0','850000','0','kasirbip','2026-05-30 19:30:33','FJ-260530-0025','DP-02049','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-05-30','FJ-260530-0025','2026-05-30','19:30:33','SULIS','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-260530-0025' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0025' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0025' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0025'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0026','kasir','1',' TFA-21053 ','TOKO','TFABR','TFA-WIAI-12-0','ANTING TFA-21053','','2.030','1','83.00','7343000','2307000','130','17800','9000000','0','0','0','9000000','FIR','00024082','TFA','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFA-WIAI-12-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='TFA-WIAI-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFABR' 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-260530-0026','2026-05-30','2.030','2026-05-30','19:35:43','PLG0011544','9000000','9000000','0','9000000','0','kasir','2026-05-30 19:35:43','FJ-260530-0026','','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-05-30','FJ-260530-0026','2026-05-30','19:35:43','FIR','9000000','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-260530-0030','2026-05-30','2026-05-30 19:35:43','PENJUALAN : FJ-260530-0026','.','TBC','9000000','9000000','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-260530-0031','D','2026-05-30','19:35:43','TBC','PENJUALAN BERLIAN','FJ-260530-0026','23007719514','9000000','23016719514','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='9000000' WHERE no_faktur_jual='FJ-260530-0026' LIMIT 1; INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-02094','SULIS','1','SEPASNG SILVER','CWE DARI SIZE 16 JADI SIZE 13 PUTIH GLOSY KEDUANYA FONT VINTAGE ROTTER','6.000','1','0','0'); INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-02094','2026-05-30','2026-05-30','19:37:59','PLG0011545','kasirbip','2026-06-14','kasirbip','2026-05-30 19:37:59','6.000','0','0','0','0','0','0','0','0'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-30 ','19:37:25'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0026' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0026' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0026'; 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-02275','KUR','1','GOLD','CICIN KAWIN','','','2.700','','37.50','1','2420000','1500000','0','750000','4800000','size 18 grf RIENZY 20.06.26','font berkshire swash putih DOF SEMPROT MODEL SR 01','EXPRES 100.000 bikin jangan lebih dari 27gr kurang gpp','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-260530-0031','2026-05-30','2026-05-30 19:40:40','PESANAN : DP-02275','.','TBC','3800000','3800000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0032','D','2026-05-30','19:40:40','TBC','PESANAN','DP-02275','23016719514','3800000','23020519514','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-02275','2026-05-30','2026-05-30','19:40:40','PLG0011546','KUR','2026-06-10','kasirbip','2026-05-30 19:40:40','2.700','0','0','0','3800000','0','750000','4800000','4800000','1000000'); 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-260530-0027','kasirbip','1',' 850K-17-25','TOKO','BIPPER','PBDG-ZEAB-49-0','CINCIN SILVER 925 ','','3.190','1','100.00','326000','0','0','17800','950000','0','0','0','950000','GIN','00043516','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZEAB-49-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.190',berat_jual_asli=berat_jual_asli+'3.190',stock_jual='1',berat_akhir=berat_akhir-'3.190',berat_akhir_asli=berat_akhir_asli-'3.190',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PBDG-ZEAB-49-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-260530-0027','2026-05-30','3.190','2026-05-30','19:40:56','PLG0011547','950000','950000','0','950000','0','kasirbip','2026-05-30 19:40:55','FJ-260530-0027','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0027','2026-05-30','19:40:56','GIN','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-260530-0032','2026-05-30','2026-05-30 19:40:55','PENJUALAN : FJ-260530-0027','.','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-260530-0033','D','2026-05-30','19:40:56','TBC','PENJUALAN','FJ-260530-0027','23020519514','950000','23021469514','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-260530-0027' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0028','kasirbip',' 1',' 800K-16-24','TOKO','BIPPER','PBDG-ZDXI-20-0','CINCIN SILVER 925 ','','3.170','1','100.00','324000','0','0','17800','900000','0','0','0','900000','GIN','00042414','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZDXI-20-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PBDG-ZDXI-20-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-260530-0028','2026-05-30','3.170','2026-05-30','19:40:56','PLG0011548','900000','900000','0','900000','0','kasirbip','2026-05-30 19:40:55','FJ-260530-0027','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0028','2026-05-30','19:40:56','GIN','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-260530-0033','2026-05-30','2026-05-30 19:40:55','PENJUALAN : FJ-260530-0028','.','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-260530-0034','D','2026-05-30','19:40:56','TBC','PENJUALAN','FJ-260530-0028','23021469514','900000','23022369514','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-260530-0028' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0029','kasirbip','1',' DP-02229DU','TOKO','DUPSN','PSPRT-ZEBI-50-0','CINCIN PERAK ','','1.910','1','100.00','195000','0','0','17800','1200000','0','0','0','1200000','PUT','00043876','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBI-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-05-30' AND kode_barang='PSPRT-ZEBI-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-260530-0029','2026-05-30','1.910','2026-05-30','19:42:14','PLG0011549','1200000','1200000','0','1200000','0','kasirbip','2026-05-30 19:42:14','FJ-260530-0029','DP-02229','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-05-30','FJ-260530-0029','2026-05-30','19:42:14','PUT','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-260530-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-260530-0030','kasirbip',' 1',' DP-02230DU','TOKO','DUPSN','PSPRT-ZEBI-51-0','CINCIN PERAK ','','3.910','1','100.00','399000','0','0','17800','950000','0','0','0','950000','PUT','00043877','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZEBI-51-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.910',berat_jual_asli=berat_jual_asli+'3.910',stock_jual='1',berat_akhir=berat_akhir-'3.910',berat_akhir_asli=berat_akhir_asli-'3.910',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPRT-ZEBI-51-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-260530-0030','2026-05-30','3.910','2026-05-30','19:42:14','PLG0011550','950000','950000','0','950000','0','kasirbip','2026-05-30 19:42:14','FJ-260530-0029','DP-02230','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-05-30','FJ-260530-0030','2026-05-30','19:42:14','PUT','950000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260530-0030' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0027' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0027' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0027'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0028' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0028' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0028'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0029' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0029' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0029'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0030' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0030' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0030'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0031','kasir','1',' TFGKR75-85','TOKO','TFGLK','TFGKR-ZBBF-88-0','THIFA GELANG KAKU RG ','','4.340','1','85.00','9107000','0','0','17800','9250000','0','0','0','9250000','IQB','00041987','TFGKR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGKR-ZBBF-88-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.340',berat_jual_asli=berat_jual_asli+'4.340',stock_jual='1',berat_akhir=berat_akhir-'4.340',berat_akhir_asli=berat_akhir_asli-'4.340',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='TFGKR-ZBBF-88-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLK' 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-260530-0031','2026-05-30','4.340','2026-05-30','19:45:49','PLG0011551','9250000','9250000','0','9250000','0','kasir','2026-05-30 19:45:48','FJ-260530-0031','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0031','2026-05-30','19:45:49','IQB','9250000','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-260530-0034','2026-05-30','2026-05-30 19:45:48','PENJUALAN : FJ-260530-0031','.','TBC','9250000','9250000','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-260530-0035','D','2026-05-30','19:45:49','TBC','PENJUALAN','FJ-260530-0031','23022369514','9250000','23031619514','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='9250000' WHERE no_faktur_jual='FJ-260530-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-260530-0032','kasirbip','1',' DP-02110BI','TOKO','BIPPSN','PSPLT-ZEBB-15-0','CINCIN PALADIUM YL-01 ','','2.540','1','17.00','571000','0','0','17800','1262000','0','0','0','1262000','SAL','00043727','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBB-15-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-05-30' AND kode_barang='PSPLT-ZEBB-15-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-260530-0032','2026-05-30','2.540','2026-05-30','19:47:17','PLG0011552','1262000','1262000','0','1262000','0','kasirbip','2026-05-30 19:47:16','FJ-260530-0032','DP-02110','1120000'); 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-05-30','FJ-260530-0032','2026-05-30','19:47:17','SAL','1262000','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-260530-0035','2026-05-30','2026-05-30 19:47:16','PENJUALAN : FJ-260530-0032','.','TBC','142000','142000','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-260530-0036','D','2026-05-30','19:47:17','TBC','PENJUALAN','FJ-260530-0032','23031619514','142000','23031761514','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='142000' WHERE no_faktur_jual='FJ-260530-0032' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0033','kasirbip',' 1',' DP-02109BI','TOKO','BIPPSN','PSPLT-ZEBF-3-0','CINCIN PALADIUM ','','2.370','1','17.00','533000','0','0','17800','1461000','0','0','0','1461000','SAL','00043793','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZEBF-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.370',berat_jual_asli=berat_jual_asli+'2.370',stock_jual='1',berat_akhir=berat_akhir-'2.370',berat_akhir_asli=berat_akhir_asli-'2.370',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='PSPLT-ZEBF-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260530-0033','2026-05-30','2.370','2026-05-30','19:47:17','PLG0011553','1461000','1461000','0','1461000','0','kasirbip','2026-05-30 19:47:16','FJ-260530-0032','DP-02109','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-05-30','FJ-260530-0033','2026-05-30','19:47:17','SAL','1461000','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-260530-0036','2026-05-30','2026-05-30 19:47:16','PENJUALAN : FJ-260530-0033','.','TBC','261000','261000','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-260530-0037','D','2026-05-30','19:47:17','TBC','PENJUALAN','FJ-260530-0033','23031761514','261000','23032022514','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='403000' WHERE no_faktur_jual='FJ-260530-0033' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0032' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0032' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0032'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0033' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0033' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0033'; 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-02276','KUR','1','PLD','CINCIN KAWIN','','','4.200','','10.00','1','1200000','350000','0','750000','2220000','size18 grf IRENE 20.06.26','font barkshire swash dof amplas keliling model yl10','expres 100.000 jangan lebih dari 4.2 bikin 4gr','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-260530-0037','2026-05-30','2026-05-30 19:51:19','PESANAN : DP-02276','.','TBC','1700000','1700000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0038','D','2026-05-30','19:51:19','TBC','PESANAN','DP-02276','23032022514','1700000','23033722514','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-02276','2026-05-30','2026-05-30','19:51:19','PLG0011554','KUR','2026-06-10','kasirbip','2026-05-30 19:51:19','4.200','0','0','0','1700000','0','750000','2220000','2220000','520000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-30 ','19:53:39'); 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-02277','PUT','1','PER','WEDD RING PROMO 850','','','3.000','','925.00','1','100000','0','850000','0','850000','sz cewe 125 grf Wildan','sz cowo 17 grf Rinda','font vintage','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0038','2026-05-30','2026-05-30 19:56:34','PESANAN : DP-02277','.','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-260530-0039','D','2026-05-30','19:56:34','TBC','PESANAN','DP-02277','23033722514','850000','23034572514','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-02277','2026-05-30','2026-05-30','19:56:34','PLG0011555','PUT','2026-06-20','kasirbip','2026-05-30 19:56:34','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-02278','RIRIN','1','PER','CINCIN SR01 SILVER','','','1.000','','925.00','1','100000','950000','0','0','950000','cewe size 11.5 grf 31-07-26','cowo size 24 grf 31-07-26 upsize 100k','warna putih doff sesuai model','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260530-0039','2026-05-30','2026-05-30 19:58:26','PESANAN : DP-02278','0','TBC','950000','950000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0040','D','2026-05-30','19:58:26','TBC','PESANAN','DP-02278','23034572514','950000','23035522514','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-02278','2026-05-30','2026-05-30','19:58:26','PLG0011556','RIRIN','2026-06-26','kasir','2026-05-30 19:58:26','1.000','0','0','0','950000','0','0','950000','950000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0034','kasirbip','1',' 900K-115-0','TOKO','DUPERBDG','LXPER-ZEAA-66-0','CINCIN SILVER 925 ','','1.280','1','100.00','131000','0','0','17800','1000000','0','0','0','1000000','KUR','00043458','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZEAA-66-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='LXPER-ZEAA-66-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-260530-0034','2026-05-30','1.280','2026-05-30','21:09:00','PLG0011557','1000000','1000000','0','1000000','0','kasirbip','2026-05-30 21:08:59','FJ-260530-0034','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0034','2026-05-30','21:09:00','KUR','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-260530-0040','2026-05-30','2026-05-30 21:08:59','PENJUALAN : FJ-260530-0034','.','TBC','1000000','1000000','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260530-0041','D','2026-05-30','21:09:00','TBC','PENJUALAN','FJ-260530-0034','23035522514','1000000','23036522514','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-260530-0034' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260530-0035','kasirbip',' 1',' 700K-185-0','TOKO','DUPERBDG','LXPER-ZDXI-32-0','CINCIN SILVER 925 ','','2.460','1','100.00','251000','0','0','17800','800000','0','0','0','800000','KUR','00042426','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-05-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDXI-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.460',berat_jual_asli=berat_jual_asli+'2.460',stock_jual='1',berat_akhir=berat_akhir-'2.460',berat_akhir_asli=berat_akhir_asli-'2.460',stock_akhir='0' WHERE tanggal='2026-05-30' AND kode_barang='LXPER-ZDXI-32-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-260530-0035','2026-05-30','2.460','2026-05-30','21:09:00','PLG0011558','800000','800000','0','800000','0','kasirbip','2026-05-30 21:08:59','FJ-260530-0034','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-30','FJ-260530-0035','2026-05-30','21:09:00','KUR','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-260530-0041','2026-05-30','2026-05-30 21:08:59','PENJUALAN : FJ-260530-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-260530-0042','D','2026-05-30','21:09:00','TBC','PENJUALAN','FJ-260530-0035','23036522514','800000','23037322514','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-260530-0035' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0034' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0034' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0034'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0035' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260530-0035' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260530-0035'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-05-30 ','21:57:44');