考试数接口新增

Administrator

2021-07-18 be174051367baa14195dc700f21f6a0a0b23a20d

考试数接口新增

 src/main/java/org/springblade/modules/apply/entity/Apply.java

@@ -142,4 +142,20 @@
    @TableField("fail_reason")
    private String failReason;


    /**
     * 考试id
     */
    @TableField("exam_id")
    private Long examId;


    /**
     * 考试时间
     */
    @TableField("exam_time")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private Date examTime;

}

 src/main/java/org/springblade/modules/apply/mapper/ApplyMapper.xml

@@ -5,9 +5,9 @@
    <!--考试报名分页信息-->
    <select id="selectApplyPage" resultType="org.springblade.modules.apply.vo.ApplyVO">
        SELECT
            *
            sa.*,
        FROM
            sys_apply
            sys_apply sa
        WHERE
            1=1
        <if test="apply.name!=null and  apply.name!=''">

 src/main/java/org/springblade/modules/exam/controller/ExamPaperController.java

@@ -26,6 +26,7 @@
import org.springblade.core.mp.support.Query;
import org.springblade.core.tool.api.R;
import org.springblade.core.tool.utils.Func;
import org.springblade.modules.dispatcher.vo.DispatcherUnitVO;
import org.springblade.modules.exam.entity.ExamPaper;
import org.springblade.modules.exam.service.ExamPaperService;
import org.springblade.modules.exam.vo.ExamPaperSubjectVO;
@@ -36,6 +37,7 @@

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Map;

/**
@@ -150,4 +152,15 @@
        return R.data(sdf.format(date));
    }

    /**
     * 自定义树
     * @param examPaper
     * @return
     */
    @GetMapping("/page-tree")
    public R pageTree(ExamPaper examPaper) {
        List<ExamPaper> pages = examPaperService.selectExamPaperPageTree(examPaper);
        return R.data(pages);
    }

}

 src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java

@@ -37,4 +37,11 @@
    ExamPaperSubjectVO queryPagerSubject(@Param("paper") ExamPaper paper);

    ExamPaperSubjectVO PagerSubject(@Param("paper") ExamPaper paper);

    /**
     * 自定义树
     * @param examPaper 试卷对象
     * @return
     */
    List<ExamPaper> selectExamPaperPageTree(@Param("paper") ExamPaper examPaper);
}

 src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.xml

@@ -72,4 +72,14 @@
        </if>
    </select>

    <!--自定义树-->
    <select id="selectExamPaperPageTree" resultType="org.springblade.modules.exam.entity.ExamPaper">
        select id,exam_name examName from ksxt_exam
        where
        1=1
        <if test="paper.examName!=null and paper.examName!=''">
            and exam_name like concat('%', #{paper.examName},'%')
        </if>
    </select>

</mapper>

 src/main/java/org/springblade/modules/exam/service/ExamPaperService.java

@@ -21,6 +21,8 @@
import org.springblade.modules.exam.vo.ExamPaperSubjectVO;
import org.springblade.modules.exam.vo.ExamPaperVO;

import java.util.List;

/**
 * 服务类
 *
@@ -37,4 +39,10 @@
     */
    ExamPaperSubjectVO PagerSubject(ExamPaper paper);

    /**
     * 自定义树
     * @param examPaper
     * @return
     */
    List<ExamPaper> selectExamPaperPageTree(ExamPaper examPaper);
}

 src/main/java/org/springblade/modules/exam/service/impl/ExamPaperServiceImpl.java

@@ -24,6 +24,8 @@
import org.springblade.modules.exam.vo.ExamPaperVO;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * 服务实现类
 *
@@ -44,4 +46,14 @@
        //查询试卷分类信息
        return baseMapper.PagerSubject(paper);
    }

    /**
     * 自定义树
     * @param examPaper 试卷对象
     * @return
     */
    @Override
    public List<ExamPaper> selectExamPaperPageTree(ExamPaper examPaper) {
        return baseMapper.selectExamPaperPageTree(examPaper);
    }
}