项目实训——第四周第三次日志

前期完成了对学生成果维护功能的收尾工作，开始了毕业板块的编码工作，共包含毕业申请、毕业论文申请、外审论文申请三个板块。
1）查看外审论文申请：
接口：localhost:8081//student//findEReviewPapers
controller层：

/**
     * 查找学生的外审申请
     * @param request
     * @return
     */
    @RequestMapping(value = "/findEReviewPapers")
    @ResponseBody
    @Transactional(rollbackFor = {RuntimeException.class, Error.class})
    public Result findEReviewPapers(HttpServletRequest request) {
        int stu_id = Integer.parseInt(request.getParameter("stu_id"));
        List<EReviewPapers> list = StuService.findEReviewPapers(stu_id);
        if (list.size() == 0) {
            return Result.fail("查询失败", list);
        } else {
            return Result.succ(200, "查询成功", list);
        }
    }

service层：

 public List<EReviewPapers> findEReviewPapers(int stu_id) {
        return eReviewPapersDao.findEReviewPapers(stu_id);
    }

dao层：

  List<EReviewPapers> findEReviewPapers(int stu_id);

mapper：

  <select id="findEReviewPapers" resultMap="BaseResultMap" parameterType="java.lang.Integer" >
    select
      *
    from e_review_papers
    where  stu_id = #{stuId,jdbcType=INTEGER}

  </select>

postman测试：

2）增加外审论文申请：
接口：localhost:8081//student//saveEReviewPapers
controller层：

 /**
     * 增加一条外审申请
     * @param request
     * @return
     * @throws ParseException
     */
    @RequestMapping(value = "/saveEReviewPapers")
    @ResponseBody
    @Transactional(rollbackFor = {RuntimeException.class, Error.class})
    public Result saveEReviewPapers(HttpServletRequest request) throws ParseException {
        Result r=findGraduate(Integer.parseInt(request.getParameter("stu_id")),3);

        int i=0;
        int j=0;
        if(r.getMsg().equals("查询失败")){
            EReviewPapers g = new EReviewPapers();
            g.setStuId(Integer.parseInt(request.getParameter("stu_id")));
            g.setPaperTitle(request.getParameter("paper_title"));
            g.setAbstractText(request.getParameter("abstract_text"));
            g.setChineseKeywords(request.getParameter("chinese_keywords"));
            g.setAdditionPath(request.getParameter("addition_path"));
            g.setState("未提交");
            i=StuService.insertEReviewPapers(g);
            GraduateRelationship gr =new GraduateRelationship();
            gr.setStuId(Integer.parseInt(request.getParameter("stu_id")));
            gr.setState("外审申请未提交");
            gr.setOutAuditApplyId(g.getOutAuditApplyId()+1);
            j=StuService.grUpdate2(gr);
        }

        if(r.getMsg().equals("查询成功")){
            EReviewPapers g = new EReviewPapers();
            g.setStuId(Integer.parseInt(request.getParameter("stu_id")));
            g.setPaperTitle(request.getParameter("paper_title"));
            g.setAbstractText(request.getParameter("abstract_text"));
            g.setChineseKeywords(request.getParameter("chinese_keywords"));
            g.setAdditionPath(request.getParameter("addition_path"));
            j=1;
            i=StuService.updateEReviewPapers(g);
        }


        if (i + j == 2) {
            i = 1;
        } else {
            i = 0;
        }
        if (i == 0) {
            return Result.fail("操作失败", 0);
        } else {
            return Result.succ(1);
        }

    }

service层：

    public int insertEReviewPapers(EReviewPapers g) {
        return eReviewPapersDao.insertEReviewPapers(g);
    } public int grUpdate2(GraduateRelationship gr) {
        return graduateRelationshipDao.grUpdate2(gr);
    }
    public int updateEReviewPapers(EReviewPapers g) {
        return eReviewPapersDao.updateEReviewPapers(g);
    }

dao层：

    int insertEReviewPapers(EReviewPapers g);
    int grUpdate2(GraduateRelationship gr);
      public int updateEReviewPapers(EReviewPapers g) {
        return eReviewPapersDao.updateEReviewPapers(g);
    }

mapper：

<insert id="insertEReviewPapers" parameterType="com.sdu.postgraduate.entity.EReviewPapers" >


    <selectKey keyProperty="outAuditApplyId" order="BEFORE" resultType="java.lang.Integer">
      select out_audit_apply_id from e_review_papers order by out_audit_apply_id desc limit 1
    </selectKey>
    insert into e_review_papers (out_audit_apply_id, paper_title, abstract_text,
    chinese_keywords, stu_id, tea_id,
    addition_path,state)
    values (#{outAuditApplyId,jdbcType=INTEGER}+1, #{paperTitle,jdbcType=VARCHAR}, #{abstractText,jdbcType=VARCHAR},
    #{chineseKeywords,jdbcType=VARCHAR}, #{stuId,jdbcType=INTEGER}, (select tea_id from student where student.stu_id=#{stuId,jdbcType=INTEGER}),
    #{additionPath,jdbcType=VARCHAR},#{state,jdbcType=VARCHAR})
  </insert>
   <update id="updateEReviewPapers" parameterType="com.sdu.postgraduate.entity.EReviewPapers" >
    update e_review_papers
    set paper_title = #{paperTitle,jdbcType=VARCHAR},
        abstract_text = #{abstractText,jdbcType=VARCHAR},
        chinese_keywords = #{chineseKeywords,jdbcType=VARCHAR},
        addition_path = #{additionPath,jdbcType=VARCHAR}
    where stu_id = #{stuId,jdbcType=INTEGER}
  </update>
 

3）提交外审论文申请：
接口：localhost:8081//student//commitEReviewPapers
controller层：

 /**
     * 提交一个外审申请
     *
     * @param request
     * @return
     */
    @RequestMapping(value = "/commitEReviewPapers")
    @ResponseBody
    @Transactional(rollbackFor = {RuntimeException.class, Error.class})
    public Result commitEReviewPapersRequest(HttpServletRequest request) {
        EReviewPapers ra = new EReviewPapers();
        ra.setOutAuditApplyId(Integer.parseInt(request.getParameter("out_audit_apply_id")));
        int i = StuService.commitEReviewPapers(ra);

        GraduateRelationship gr =new GraduateRelationship();
        gr.setOutAuditApplyId(ra.getOutAuditApplyId());
        gr.setState("外审申请审核中");
        int j = StuService.grUpdate3(gr);
        if (i + j == 2) {
            i = 1;
        } else {
            i = 0;
        }
        if (i == 0) {
            return Result.fail("操作失败", 0);
        } else {

            return Result.succ(1);
        }
    }

service层：

public int commitEReviewPapers(EReviewPapers ra) {
        return eReviewPapersDao.commitEReviewPapers(ra);
    }

dao层：

int commitEReviewPapers(EReviewPapers ra);

mapper：

 <update id="commitEReviewPapers" parameterType="com.sdu.postgraduate.entity.EReviewPapers" >
    update e_review_papers
    set state ="审核中"
    where out_audit_apply_id = #{outAuditApplyId,jdbcType=INTEGER}
  </update>