コード例 #1
0
ファイル: GroupBook.java プロジェクト: fuhongliang/hr-pure
  /**
   * 通过终止审批
   *
   * @param con
   * @param user
   * @throws Exception
   */
  public void passStop(Connection con, JUser user) throws Exception {
    PreparedStatement pstmt = null;
    String sql = null;

    GroupBook book = GroupBook.getGroupBook(con, this.getGroup_id());
    sql =
        " update t_ym_book set group_status = -1, group_stop_status = 4 "
            + " where group_id = ? and group_stop_status = 2 and group_status >= 4 ";

    pstmt = con.prepareStatement(sql);
    pstmt.setString(1, this.group_id);
    pstmt.executeUpdate();
    pstmt.close();

    String subject =
        book.getGroup_name() + "的" + GroupBasic.getGroupTypeName(this.getGroup_type()) + "终止审批已通过";
    int msgWay = JMessageEnum.SYSTEM_MESSAGE;
    JMessageAdapter.sendMessage(
        msgWay,
        new String[] {book.getZxgw_id()},
        subject,
        subject,
        "-1",
        "/ym/group/groupBookControl.jsp?cmd=update&group_id=" + this.getGroup_id(),
        1);
  }
コード例 #2
0
ファイル: GroupBook.java プロジェクト: fuhongliang/hr-pure
  /**
   * 通过审批
   *
   * @param con
   * @param user
   * @throws Exception
   */
  public void pass(Connection con, JUser user) throws Exception {
    PreparedStatement pstmt = null;
    String sql = null;

    GroupBook book = GroupBook.getGroupBook(con, this.getGroup_id());

    String subject = null;
    if (JUtil.convertNull(book.getGroup_no()).length() == 0) {
      sql = " update t_ym_book set group_no = ? " + " where group_id = ? and group_status < 4 ";

      pstmt = con.prepareStatement(sql);
      pstmt.setString(1, createGroupNO());
      pstmt.setString(2, this.group_id);
      pstmt.executeUpdate();
      pstmt.close();
    }

    subject =
        book.getGroup_name() + "的" + GroupBasic.getGroupTypeName(this.getGroup_type()) + "审批已已通过";
    sql =
        " update t_ym_book set group_status = 4, pass_date = ? "
            + " where group_id = ? and group_status < 4 ";

    pstmt = con.prepareStatement(sql);
    pstmt.setTimestamp(1, new java.sql.Timestamp(System.currentTimeMillis()));
    pstmt.setString(2, this.group_id);
    pstmt.executeUpdate();
    pstmt.close();

    int msgWay = JMessageEnum.SYSTEM_MESSAGE;

    JMessageAdapter.sendMessage(
        msgWay,
        new String[] {book.getZxgw_id()},
        subject,
        subject,
        "-1",
        "/ym/group/groupBookControl.jsp?cmd=update&group_id=" + this.getGroup_id(),
        1);
  }
コード例 #3
0
ファイル: GroupBook.java プロジェクト: fuhongliang/hr-pure
  /**
   * 审批
   *
   * @param user
   * @param jobId
   * @param agree
   * @param suggest
   */
  public void approve(JUser user, String jobId, boolean agree, String suggest) throws Exception {
    GroupBook book = null;
    Connection con = null;
    PreparedStatement pstmt = null;
    String sql = null;
    Job job = null;
    java.util.Map<String, Object> context = new java.util.HashMap<String, Object>();
    StringBuffer contextXML = new StringBuffer();

    context.put("user_id", user.getUserId()); // 当前操作人
    context.put("approveFlag", (agree ? "1" : "0")); // 审批标记
    context.put("suggest", suggest); // 审批意见

    try {
      con = JDatabase.getJDatabase().getConnection();
      con.setAutoCommit(false);
      book = GroupBook.getGroupBook(con, this.getGroup_id());
      job = Job.getJobById(con, jobId);
      contextXML.append("<ContextData>");

      if (agree) {
        contextXML.append("<onlyManager>N</onlyManager>");
        contextXML.append("<Participants>");
        contextXML.append("<Participant type=\"user\"></Participant>");
        contextXML.append("</Participants>");
      }
      contextXML.append("</ContextData>");

      context.put("contextXML", contextXML.toString());
      job.setContext(context);
      job.start(con);

      if (!agree) {
        int msgWay = JMessageEnum.SYSTEM_MESSAGE;
        String subject = null;

        sql = "update t_ym_book set group_status = 3 where group_id = ? ";
        subject =
            book.getGroup_name()
                + "的"
                + GroupBasic.getGroupTypeName(this.getGroup_type())
                + "审批未通过,原因:"
                + suggest;
        pstmt = con.prepareStatement(sql);
        pstmt.setString(1, this.getGroup_id());
        pstmt.executeUpdate();
        pstmt.close();
        JMessageAdapter.sendMessage(
            msgWay,
            new String[] {book.getZxgw_id()},
            subject,
            subject,
            "-1",
            "/ym/group/groupBookControl.jsp?cmd=update&group_id=" + this.getGroup_id(),
            1);
      } else if (job.getActivityId().equals("manager")) {
        this.pass(con, user);
      }

      con.commit();
    } catch (Exception e) {
      throw e;
    } finally {
      if (con != null) con.rollback();
      if (con != null) con.close();
    }
  }
コード例 #4
0
ファイル: GroupBook.java プロジェクト: fuhongliang/hr-pure
  public static GroupBook getGroupBook(Connection con, String group_id) throws Exception {
    GroupBook book = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    String sql = null;

    sql =
        " select group_id, group_no, group_type, contact, contact_phone, contact_handset, contact_fax, "
            + "	countries, countries_name, group_name, inquire_date, memo, company_id, modify_memo,"
            + "	zxgw_id, zxgw_name, take_out, group_status, group_stop_status,creater, createrName,created "
            + "	from t_ym_book where group_id = ? ";
    pstmt = con.prepareStatement(sql);
    pstmt.setString(1, group_id);
    rs = pstmt.executeQuery();
    if (rs.next()) {
      book = new GroupBook();
      book.setGroup_id(group_id);
      book.setGroup_name(rs.getString("group_name"));
      book.setInquire_date(rs.getDate("inquire_date"));
      book.setGroup_type(rs.getInt("group_type"));
      book.setGroup_no(rs.getString("group_no"));
      book.setMemo(rs.getString("memo"));
      book.setContact(rs.getString("contact"));
      book.setContact_handset(rs.getString("contact_handset"));
      book.setContact_phone(rs.getString("contact_phone"));
      book.setContact_fax(rs.getString("contact_fax"));
      book.setCountries(rs.getString("countries"));
      book.setCountries_name(rs.getString("countries_name"));
      book.setModify_memo(rs.getString("modify_memo"));
      book.setCompany_id(rs.getString("company_id"));
      book.setZxgw_id(rs.getString("zxgw_id"));
      book.setZxgw_name(rs.getString("zxgw_name"));
      book.setTake_out(rs.getString("take_out"));
      book.setGroup_status(rs.getInt("group_status"));
      book.setGroup_stop_status(rs.getInt("group_stop_status"));
      book.setCreater(rs.getString("creater"));
      book.setCreaterName(rs.getString("createrName"));
      book.setCreated(rs.getTimestamp("created"));
    }

    rs.close();
    pstmt.close();

    return book;
  }