EasyUI+JavaWeb奖助学金管理系统[19]-奖助学金审批功能开发

<table id="mainTable" title="待审批申请列表" class="easyui-datagrid" url="CoreServlet?method=getAuditPage" pagination="true"
     singleSelect="true" fitColumns="true">
      <thead>
        <tr>
          <th data-options="field:'id',width:50">申请序号</th>
          <th data-options="field:'studentName',width:50">申请人</th>
          <th data-options="field:'projectName',width:50">申请项目名称</th>
          <th data-options="field:'content',width:100">申请说明</th>
          <th data-options="field:'classAdvice',width:100">班主任审核意见</th>
          <th data-options="field:'collegeAdvice',width:100">学院审核意见</th>
          <th data-options="field:'schoolAdvice',width:100">学校审核意见</th>
          <th data-options="field:'currentNode',width:100" formatter="formatCurrentNode">进度</th>
        </tr>
      </thead>
    </table>
然后开发对应的后端方法：
    // 获取待审批记录
    else if (method.equals("getAuditPage")) {
      FlowDao flowDao = new FlowDao();
      total = flowDao.getCountByCurrentUserId(loginUser.getId());
      result.setTotal(total);
      result.setRows(flowDao.getPageByCurrentUserId(page, rows, loginUser.getId()));
    }
最后完成FlowDao数据操作类的开发：
/**
   * 获取数量
   */
  public int getCountByCurrentUserId(String userId) throws Exception {
    Connection conn = ConnectionUtils.getConnection();
    String sql = "select count(id) from flow where currentUserId=?";
    QueryRunner runner = new QueryRunner();
    Object[] params = { userId };
    Number number = (Number) runner.query(conn, sql, new ScalarHandler(), params);
    int value = number.intValue();
    ConnectionUtils.releaseConnection(conn);
    return value;
  }
  /**
   * 分页查询
   */
  public List<Flow> getPageByCurrentUserId(int page, int rows, String userId) throws Exception {
    Connection conn = ConnectionUtils.getConnection();
    String sql = "select * from flow where currentUserId=? limit ?,?";
    QueryRunner runner = new QueryRunner();
    Object[] params = { userId, (page - 1) * rows, rows };
    List<Flow> flows = runner.query(conn, sql, new BeanListHandler<Flow>(Flow.class), params);
    ConnectionUtils.releaseConnection(conn);
    return flows;
  }
3. 审批功能的开发
当管理员选择一条待审批记录后，可以点击审批按钮，此时弹窗显示申请信息，管理员填入审批意见后可以选择通过或者驳回申请。如果是通过申请，则修改currentUserId为下一个审批人的id，currentNode修改为对应的审批节点标志。
好的，先添加审批按钮：
    <div class="tool-box">
      <a id="btn" onclick="btnEditClick()" href="#" class="easyui-linkbutton" data-options="iconCls:'icon-add'">审批</a>
    </div>
1
2
3
点击按钮后弹窗：
      // 开始审批
      function btnEditClick() {
        // 获取当前选中行
        var row = $('#mainTable').datagrid('getSelected');
        if (row == null) {
          alert("请选择要审批的申请");
          return;
        }
        // 将选中行信息设置到弹窗 
        $("#edit-id").textbox("setValue", row.id);
        $("#edit-content").textbox("setValue", row.content);
        $('#dialog-edit').dialog('open');
      }
点击提交按钮后，将数据提交给后端方法：
      // 审批
      function btnAudit(state) {
        var param = {
          id: $("#edit-id").val(),
          state: state,
          advice: $("#edit-advice").val(),
        }
        $.ajax({
          url: "CoreServlet?method=audit",
          type: "post",
          dataType: "json",
          data: param,
          success: function(res) {
            console.log(res);
            if (res.code == 0) { //成功则刷新表格
              $('#mainTable').datagrid('reload');
              $('#dialog-edit').dialog('close');
            } else { //提示错误信息
              alert(res.msg);
            }
          },
        });
后端收到后进行处理，注意要根据当前登录人的信息，来修改当前申请对应的currentUserId和currentNode值。
  // 审批
    else if (method.equals("audit")) {
      FlowDao flowDao = new FlowDao();
      String flowId = request.getParameter("id");
      String state = request.getParameter("state");
      String advice = request.getParameter("advice");
      Flow flow = flowDao.getById(flowId);
      // 填入意见
      if (loginUser.getRole().equals("classmaster")) {
        flow.setClassAdvice(advice);
      } else if (loginUser.getRole().equals("collegemaster")) {
        flow.setCollegeAdvice(advice);
      } else if (loginUser.getRole().equals("schoolmaster")) {
        flow.setSchoolAdvice(advice);
      }
      // 失败
      if (state.equals("fail")) {
        flow.setCurrentUserId(flow.getStudentId());
        flow.setCurrentNode("fail");
      } else {
        if (loginUser.getRole().equals("classmaster")) {
          flow.setCurrentUserId(flow.getCollegeUserId());
          flow.setCurrentNode("college");
        } else if (loginUser.getRole().equals("collegemaster")) {
          flow.setCurrentUserId(flow.getSchoolUserId());
          flow.setCurrentNode("school");
        } else if (loginUser.getRole().equals("schoolmaster")) {
          flow.setCurrentUserId(flow.getStudentId());
          flow.setCurrentNode("success");
        }
      }
      flowDao.update(flow);
      result.setCode(0);
      result.setMsg("操作成功");
    }
4. 总结
至此我们开发完成了本系统的所有功能，非常华丽！