예제 #1
0
 private Criterion findbyOR(String type, String str, Session session) {
   Criterion criterion = null;
   StringBuffer sbSQL = new StringBuffer("select p.pmid from Pms as p where");
   List<String> srch = new ArrayList<String>();
   str = str.replace("|", ",");
   String[] srchAND = str.split(" and ");
   for (int i = 0; i < srchAND.length; i++) {
     String[] srch_ = srchAND[i].split(" ");
     for (int j = 0; j < srch_.length; j++) {
       if (cn.jsprun.utils.FormDataCheck.isValueString(srch_[j])) {
         srch.add(srch_[j]);
       }
     }
   }
   for (int i = 0; i < srch.size(); i++) {
     sbSQL.append(" p." + type + " like '%" + srch.get(i) + "%' or");
   }
   String sql = sbSQL.substring(0, sbSQL.length() - 2);
   try {
     Query query = session.createQuery(sql);
     List<Integer> list = query.list();
     criterion = Expression.in("pmid", list);
     session.flush();
   } catch (HibernateException e) {
     e.printStackTrace();
     criterion = null;
   }
   return criterion;
 }
  /**
   * Gets a list of all calendars available sorted by primary key.
   *
   * @return List of Calendar
   * @throws Exception
   */
  public Set getCalendarList(List roles, List groups, Session session) throws Exception {
    List result = null;

    Query q = session.createQuery("from Calendar calendar order by calendar.id");

    Criteria criteria = session.createCriteria(Calendar.class);
    criteria.createCriteria("owningRoles").add(Expression.in("name", roles.toArray()));
    if (groups.size() > 0)
      criteria.createCriteria("owningGroups").add(Expression.in("name", groups.toArray()));
    criteria.addOrder(Order.asc("name"));

    // result = criteria.list();
    // return result;
    Set set = new LinkedHashSet();
    set.addAll(criteria.list());

    return set;
  }
  public static void main(String[] args) throws Exception {
    Criteria c = HibernateUtil.currentSession().createCriteria(GuiaSimples.class);
    c.add(Expression.ge("dataAtendimento", Utils.parse("21/02/2008")));
    c.add(Expression.le("dataAtendimento", Utils.parse("20/07/2008")));
    c.add(Expression.in("situacao.descricao", situacoes));

    alimentarMapa(c.list());

    processarArquivo();
  }
  /**
   * Gets a list of all calendars not subscribed to sorted by primary key.
   *
   * @return List of Calendar
   * @throws Exception
   */
  public Set getUnsubscribedCalendarList(String email, Session session) throws Exception {
    List result = null;

    Set subscriptions = SubscriptionController.getController().getSubscriberList(email, session);
    List subscriptionsList = new ArrayList();

    Iterator i = subscriptions.iterator();
    while (i.hasNext()) {
      Subscriber subscriber = (Subscriber) i.next();
      subscriptionsList.add(subscriber.getCalendar().getId());
    }

    Criteria criteria = session.createCriteria(Calendar.class);
    if (subscriptionsList.size() > 0)
      criteria.add(Expression.not(Expression.in("id", subscriptionsList.toArray())));
    criteria.addOrder(Order.asc("name"));

    Set set = new LinkedHashSet();
    set.addAll(criteria.list());

    return set;
  }