コード例 #1
0
ファイル: FacturaAlmacenDao.java プロジェクト: nujev/mateo-1
  public Map<String, Object> lista(Map<String, Object> params) {
    log.debug("Buscando lista de facturas con params {}", params);
    if (params == null) {
      params = new HashMap<>();
    }

    if (!params.containsKey("max")) {
      params.put("max", 10);
    } else {
      params.put("max", Math.min((Integer) params.get("max"), 100));
    }

    if (params.containsKey("pagina")) {
      Long pagina = (Long) params.get("pagina");
      Long offset = (pagina - 1) * (Integer) params.get("max");
      params.put("offset", offset.intValue());
    }

    if (!params.containsKey("offset")) {
      params.put("offset", 0);
    }
    Criteria criteria = currentSession().createCriteria(FacturaAlmacen.class);
    Criteria countCriteria = currentSession().createCriteria(FacturaAlmacen.class);

    if (params.containsKey("almacen")) {
      criteria.createCriteria("almacen").add(Restrictions.idEq(params.get("almacen")));
      countCriteria.createCriteria("almacen").add(Restrictions.idEq(params.get("almacen")));
    }

    if (params.containsKey("filtro")) {
      String filtro = (String) params.get("filtro");
      Disjunction propiedades = Restrictions.disjunction();
      propiedades.add(Restrictions.ilike("folio", filtro, MatchMode.ANYWHERE));
      criteria.add(propiedades);
      countCriteria.add(propiedades);
    }

    if (params.containsKey("order")) {
      String campo = (String) params.get("order");
      if (params.get("sort").equals("desc")) {
        criteria.addOrder(Order.desc(campo));
      } else {
        criteria.addOrder(Order.asc(campo));
      }
    } else {
      criteria.createCriteria("estatus").addOrder(Order.asc("prioridad"));
    }
    criteria.addOrder(Order.desc("fechaModificacion"));

    if (!params.containsKey("reporte")) {
      criteria.setFirstResult((Integer) params.get("offset"));
      criteria.setMaxResults((Integer) params.get("max"));
    }
    params.put("facturas", criteria.list());

    countCriteria.setProjection(Projections.rowCount());
    params.put("cantidad", (Long) countCriteria.list().get(0));

    return params;
  }
コード例 #2
0
 private T orderDirection(boolean ascending) {
   int i = ensureOrderIndex();
   Order order = this.orderEntries.get(i);
   if (order.isAscending() != ascending) { // only swap out the Order statement if it is different:
     String name = order.getPropertyName();
     Order newOrder = ascending ? Order.asc(name) : Order.desc(name);
     this.orderEntries.set(i, newOrder);
   }
   return (T) this;
 }
コード例 #3
0
ファイル: QueryUserDomain.java プロジェクト: peemzas/src
 public List<User> getUserValidate(String piority, Integer page) {
   Criteria criteria = getSession().createCriteria(User.class);
   criteria.add(Restrictions.eq("validateStu", 0));
   criteria.add(Restrictions.like("piority", "%" + piority + "%"));
   criteria.addOrder(Order.asc("dateCreate"));
   page = (page - 1) * 10;
   criteria.setFirstResult(page);
   criteria.setMaxResults(10);
   List<User> list = (List<User>) criteria.list();
   closeSession();
   return list;
 }
コード例 #4
0
ファイル: PlantelDAO.java プロジェクト: gomezhyuuga/SiRASS
 public Plantel getPlantelById() {
   Session session = HibernateUtil.getSessionFactory().openSession();
   Plantel plantel = null;
   ProjectionList plist = Projections.projectionList();
   plist.add(Projections.property("p.nombre").as("nombre"));
   Criteria criteria =
       session
           .createCriteria(Plantel.class, "p")
           .setProjection(plist)
           .setResultTransformer(new AliasToBeanResultTransformer(Plantel.class))
           .addOrder(Order.asc("nombre"));
   plantel = (Plantel) criteria.uniqueResult();
   session.close();
   return plantel;
 }
コード例 #5
0
  @SuppressWarnings("unchecked")
  @Override
  public List<Lancamento> listar(Conta conta, Date dataInicio, Date dataFim) {
    Criteria criteria = this.session.createCriteria(Lancamento.class);

    if (dataInicio != null && dataFim != null) {
      criteria.add(Restrictions.between("data", dataInicio, dataFim));
    } else if (dataInicio != null) {
      criteria.add(Restrictions.ge("data", dataInicio));
    } else if (dataFim != null) {
      criteria.add(Restrictions.le("data", dataFim));
    }

    criteria.add(Restrictions.eq("conta", conta));
    criteria.addOrder(Order.asc("data"));
    return criteria.list();
  }
コード例 #6
0
  /**
   * 设置分页参数到Criteria对象,辅助函数.
   *
   * @param c Hibernate Criteria
   * @param pageRequest 分页请求参数
   * @return {@link org.hibernate.Criteria}
   */
  protected Criteria setPageRequestToCriteria(Criteria c, PageRequest pageRequest) {
    Assert.isTrue(pageRequest.getPageSize() > 0, "分页大小必须大于0");

    c.setFirstResult(pageRequest.getOffset());
    c.setMaxResults(pageRequest.getPageSize());

    if (pageRequest.isOrderBySetted()) {
      for (PageRequest.Sort sort : pageRequest.getSort()) {
        Order order = null;
        if (sort.getDir().equals(PageRequest.Sort.ASC)) {
          order = Order.asc(sort.getProperty());
        } else {
          order = Order.desc(sort.getProperty());
        }
        c.addOrder(order);
      }
    }

    return c;
  }
コード例 #7
0
ファイル: QueryUserDomain.java プロジェクト: peemzas/src
  public static Integer findPiority(String pior, Integer status) {
    Integer sizePioruty = 0;
    StringBuffer piorityBuffer = new StringBuffer();
    Criteria criteria = getSession().createCriteria(User.class);
    criteria.add(Restrictions.like("piority", pior + "%"));
    criteria.add(Restrictions.eq("status", status));
    criteria.add(new LengthExpression("piority", pior.length() + 3));
    criteria.addOrder(Order.asc("piority"));
    List<User> list = (List<User>) criteria.list();
    sizePioruty = list.size();

    if ((list.size() > 0 && status == 3) || (status == 2 && list.size() > 0)) {
      piorityBuffer.append(
          list.get(list.size() - 1)
                  .getPiority()
                  .charAt(list.get(list.size() - 1).getPiority().length() - 3)
              + "");
      piorityBuffer.append(
          list.get(list.size() - 1)
                  .getPiority()
                  .charAt(list.get(list.size() - 1).getPiority().length() - 2)
              + "");
      piorityBuffer.append(
          list.get(list.size() - 1)
                  .getPiority()
                  .charAt(list.get(list.size() - 1).getPiority().length() - 1)
              + "");
      sizePioruty = Integer.parseInt(piorityBuffer.toString()) + 1;
    }
    if (list.size() <= 0 && status == 2) {
      sizePioruty++;
    }
    if (list.size() <= 0 && status == 3) {

      sizePioruty++;
    }
    return sizePioruty;
  }
コード例 #8
0
ファイル: Field.java プロジェクト: hansisommer/squidb
 /** @return an {@link Order} that sorts ascending by this field's value */
 public Order asc() {
   return Order.asc(this);
 }
コード例 #9
0
 public T orderBy(Property property) {
   Order order =
       Order.asc(
           property.getName()); // ascending by default - they can call descending() to reverse
   return add(order);
 }
コード例 #10
0
ファイル: AsociadoDao.java プロジェクト: condor17/colportaje
  public Map<String, Object> lista(Map<String, Object> params) {
    log.debug("Buscando lista de asociado con params {}", params);
    if (params == null) {
      params = new HashMap<>();
    }

    if (!params.containsKey("max")) {
      params.put("max", 10);
    } else {
      params.put("max", Math.min((Integer) params.get("max"), 100));
    }

    if (params.containsKey("pagina")) {
      Long pagina = (Long) params.get("pagina");
      Long offset = (pagina - 1) * (Integer) params.get("max");
      params.put("offset", offset.intValue());
    }

    if (!params.containsKey("offset")) {
      params.put("offset", 0);
    }

    if (!params.containsKey("asociacion")) {
      params.put("asociados", new ArrayList());
      params.put("cantidad", 0L);

      return params;
    }

    Criteria criteria = currentSession().createCriteria(Asociado.class);
    Criteria countCriteria = currentSession().createCriteria(Asociado.class);

    if (params.containsKey("asociacion")) {
      log.debug("valor de asociacion" + params.get("asociacion"));
      criteria
          .createCriteria("asociacion")
          .add(Restrictions.eq("id", ((Asociacion) params.get("asociacion")).getId()));
      countCriteria
          .createCriteria("asociacion")
          .add(Restrictions.eq("id", ((Asociacion) params.get("asociacion")).getId()));
    }

    if (params.containsKey("filtro")) {
      String filtro = (String) params.get("filtro");
      Disjunction propiedades = Restrictions.disjunction();
      propiedades.add(Restrictions.ilike("username", filtro, MatchMode.ANYWHERE));
      propiedades.add(Restrictions.ilike("nombre", filtro, MatchMode.ANYWHERE));
      propiedades.add(Restrictions.ilike("apellido", filtro, MatchMode.ANYWHERE));
      criteria.add(propiedades);
      countCriteria.add(propiedades);
    }

    if (params.containsKey("order")) {
      String campo = (String) params.get("order");
      if (params.get("sort").equals("desc")) {
        criteria.addOrder(Order.desc(campo));
      } else {
        criteria.addOrder(Order.asc(campo));
      }
    }

    if (!params.containsKey("reporte")) {
      criteria.setFirstResult((Integer) params.get("offset"));
      criteria.setMaxResults((Integer) params.get("max"));
    }
    params.put("asociados", criteria.list());

    countCriteria.setProjection(Projections.rowCount());
    params.put("cantidad", (Long) countCriteria.list().get(0));

    return params;
  }