Esempio n. 1
0
  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;
  }
 public float saldo(Conta conta, Date data) {
   StringBuffer sql = new StringBuffer();
   sql.append("select sum(l.valor * c.fator)");
   sql.append(" from LANCAMENTO l,");
   sql.append("   CATEGORIA c");
   sql.append(" where l.categoria = c.codigo");
   sql.append("  and l.conta = :conta");
   sql.append("  and l.data <= :data");
   SQLQuery query = this.session.createSQLQuery(sql.toString());
   query.setParameter("conta", conta.getConta());
   query.setParameter("data", data);
   BigDecimal saldo = (BigDecimal) query.uniqueResult();
   if (saldo != null) {
     return saldo.floatValue();
   }
   return 0f;
 }
Esempio n. 3
0
  public List insertUser(User user, String piority, String usernameInsert, boolean isPM) {
    //        user.setId(1);
    Integer countPiority = 0;
    StringBuffer newPiority = new StringBuffer();
    DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy", Locale.US);

    Date date = new Date();
    String dateStr = dateFormat.format(date);
    HibernateUtil.beginTransaction();
    if (user.getStatus() == 3) {
      user.setValidateStu(0);
      user.setViewEav(0);
    } else {
      user.setValidateStu(1);
    }
    user.setUserCreate(usernameInsert);
    user.setDateCreate(dateStr);

    if (isPM) {
      countPiority = 0;
    } else {
      countPiority = findPiority(piority, user.getStatus());
    }

    if (countPiority > 0) {

      if (countPiority < 10) {
        newPiority.append("00" + countPiority);
      } else if (countPiority < 100) {
        newPiority.append("0" + countPiority);
      } else {
        newPiority.append(countPiority);
      }
    } else {
      newPiority.append("");
    }
    user.setPiority(piority + newPiority.toString());
    getSession().save(user);
    HibernateUtil.commitTransaction();
    closeSession();

    Criteria criteria = getSession().createCriteria(User.class);
    criteria.add(Restrictions.eq("userName", user.getUserName()));
    List<User> list = criteria.list();
    closeSession();
    return list;
  }
Esempio n. 4
0
  public void editProfileStaff(User user, String pioruty) {
    User user1 = getUserDatas(user.getUserId());

    DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy", Locale.US);

    Date date = new Date();
    String dateStr = dateFormat.format(date);
    user.setUserUpdate(user.getUserName());
    user.setDateUpdate(dateStr);
    user.setPassword(user1.getPassword());
    user.setValidateStu(user1.getValidateStu());
    user.setStatus(user1.getStatus());
    user.setUserCreate(user1.getUserCreate());
    user.setDateCreate(user1.getDateCreate());
    user.setImange(user1.getImange());

    if (user.getTeamId().toString().equals(user1.getTeamId().toString())) { // No change team
      user.setPiority(user1.getPiority());
    } else { // Chang teame
      if (pioruty.length() <= 0) { // Not PM
        StringBuffer newPiority = new StringBuffer();
        Integer countPiority = findPiority(user.getPiority(), 2);
        if (countPiority > 0) {
          if (countPiority < 10) {
            newPiority.append("00" + countPiority);
          } else if (countPiority < 100) {
            newPiority.append("0" + countPiority);
          } else {
            newPiority.append(countPiority);
          }
        } else {
          newPiority.append("");
        }
        user.setPiority(user.getPiority() + newPiority.toString());
      } else { // PM of new team
        user.setPiority(pioruty);
        // edit team and section
      }
    }

    HibernateUtil.beginTransaction();
    getSession().merge(user);
    HibernateUtil.commitTransaction();
  }
Esempio n. 5
0
  public void EditProfile(User user) {
    User user1 = getUserDatas(user.getUserId());

    DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy", Locale.US);

    Date date = new Date();
    String dateStr = dateFormat.format(date);
    user.setViewEav(user1.getViewEav());
    user.setUserUpdate(user.getUserName());
    user.setDateUpdate(dateStr);
    user.setPassword(user1.getPassword());
    user.setValidateStu(user1.getValidateStu());
    user.setStatus(user1.getStatus());
    user.setUserCreate(user1.getUserCreate());
    user.setDateCreate(user1.getDateCreate());
    user.setPiority(user1.getPiority());
    user.setImange(user1.getImange());
    if (!user.getStaffId().equals(user1.getStaffId())) {
      StringBuffer newPiority = new StringBuffer();
      User userBuffer = getUserDatas(user.getStaffId());
      Integer countPiority = findPiority(userBuffer.getPiority(), 3);
      if (countPiority > 0) {
        if (countPiority < 10) {
          newPiority.append("00" + countPiority);
        } else if (countPiority < 100) {
          newPiority.append("0" + countPiority);
        } else {
          newPiority.append(countPiority);
        }
      } else {
        newPiority.append("");
      }
      user.setPiority(userBuffer.getPiority() + newPiority.toString());
    }

    HibernateUtil.beginTransaction();
    getSession().merge(user);
    HibernateUtil.commitTransaction();
  }