@PersistenceUnit(unitName = "ERP3PRODUCCION")
private EntityManagerFactory emf;
EntityManager em;

@EJB CatestatusFacade st;
@EJB CatdepartamentosFacade deptos;

//PrimerTrackingBulk tracking;
@EJB EjbPrimerTracking tracking;

public void pasarNvProd(String fac) {
    try {
        em = emf.createEntityManager();
        Object ob="1";
        Catestatus estado=st.find(ob);
        Object ob2=10;
        Catdepartamentos depto=deptos.find(ob2);
        Query query=em.createQuery("Update Jobs u SET u.idestatus=:estado, u.ubicfis=:depto where u.idestatus.idestatus='0' and u.jobsPl.factura.factura=:fac and u.habilitado=true");
        query.setParameter("fac", fac);
        query.setParameter("estado", estado);
        query.setParameter("depto", depto);
        query.executeUpdate();
        Query q2=em.createQuery("Update FacturasImportacion u SET u.enproduccion=true where u.factura=:fac").setParameter("fac", fac);
        q2.executeUpdate();
        tracking.primerMovTracking(fac, em);
        em.close();
    } catch (Exception ex) {
        Logger.getLogger(EjbPasarNv.class.getName()).log(Level.SEVERE, null, ex);
        JsfUtil.addErrorMessage("Ocurrio un error y no se completo la transacción");


    }finally{

    }

}

@Inject
private LoginBean loginBean;
private static final Logger LOG = Logger.getLogger(EjbPrimerTracking.class.getName());


public void primerMovTracking(String fac, EntityManager em) throws Exception {
    try {


        Query q = em.createQuery("select u from Jobs u join fetch u.ubicfis where u.jobsPl.factura.factura=:fac").setParameter("fac", fac);
        List<Jobs> jobs = q.getResultList();
        Date fecha = new Date();

        for (Jobs j : jobs) {
            Tracking track;
            track = new Tracking(fecha, loginBean.getIdemp(), "AUTO", "AUTO");
            track.setComputadora(loginBean.getHost());
            track.setIp(loginBean.getIp());
            track.setUbicfis(j.getUbicfis());
            track.setJobs(j);
            track.setTerminado(Boolean.TRUE);
            //LOG.info("Antes de Guardar Tracking");
            em.persist(track);
            j.setUltimo(track);
            LOG.info("**************************************************************************");
            j.setFuturo(Boolean.TRUE);
            j.setCuadre(j.getUbicfis().getEntraCuadre());
            LOG.info("antes merge");
            em.merge(j);
        }





    } catch (Exception ex) {
        Logger.getLogger(EjbPrimerTracking.class.getName()).log(Level.SEVERE, null, ex);

        throw ex;
    } finally{
        //em.close();
    }

}