Information

0
Story Points

Technologies

Decompiled Java File
package mx.com.bcm.banamex.ae.persistencia.dao.impl;

import java.util.List;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.TypedQuery;
import mx.com.bcm.banamex.ae.persistencia.common.GlobalJpaDaoBean;
import mx.com.bcm.banamex.ae.persistencia.dao.CajaDeTurnoDAOBeanLocal;
import mx.com.bcm.banamex.ae.persistencia.modelo.CajasDeTurno;

@Stateless
public class CajaDeTurnoDAOImplBeanLocal extends GlobalJpaDaoBean implements CajaDeTurnoDAOBeanLocal {
   @PersistenceContext
   private EntityManager em;

   public List buscarCajasDeTurnoPorCaja(int cajaId) {
      StringBuilder query = new StringBuilder();
      query.append(" SELECT c FROM CajasDeTurno c ");
      query.append(" JOIN FETCH c.turno ");
      query.append(" WHERE c.caja.cajaIdn = :cajaIdn");
      query.append(" and c.cajaxturnoBajaLogica = :status");
      TypedQuery criteria = this.em.createQuery(query.toString(), CajasDeTurno.class);
      criteria.setParameter("cajaIdn", Integer.valueOf(cajaId));
      criteria.setParameter("status", "01");
      return criteria.getResultList();
   }

   public CajasDeTurno buscarCajasDeTurnoPorCajaYTurno(short cajaId, String turnoId) {
      StringBuilder query = new StringBuilder();
      query.append(" SELECT c FROM CajasDeTurno c ");
      query.append(" WHERE c.caja.cajaIdn = :cajaIdn");
      query.append(" and c.turno.turnoId = :turnoIdn");
      TypedQuery criteria = this.em.createQuery(query.toString(), CajasDeTurno.class);
      criteria.setParameter("cajaIdn", Short.valueOf(cajaId));
      criteria.setParameter("turnoIdn", turnoId.toString());
      new CajasDeTurno();
      List listaCajasDeTurno = criteria.getResultList();
      if(!listaCajasDeTurno.isEmpty()) {
         CajasDeTurno cajasDeTurno = (CajasDeTurno)listaCajasDeTurno.get(0);
         return cajasDeTurno;
      } else {
         return null;
      }
   }
}
Page generated: Oct 19, 2017 2:35:21 PM