<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.template.mapper.SmartSectionMapper">
    <resultMap type="com.template.model.vo.SmartSectionPageVo" id="smartSectionPageMap">
        <result property="id" column="id"/>
        <result property="gradeId" column="grade_id"/>
        <result property="gradeName" column="grade_name"/>
        <result property="termId" column="term_id"/>
        <result property="termName" column="term_name"/>
        <result property="examType" column="exam_type"/>
        <result property="passLine" column="pass_line"/>
        <result property="goodLine" column="good_line"/>
        <result property="excellentLine" column="excellent_line"/>
        <result property="createTime" column="create_time"/>
    </resultMap>
    <select id="querySmartSectionPages" resultType="com.template.model.vo.SmartSectionPageVo" resultMap="smartSectionPageMap">
        select ss.id,ss.grade_id, sg.name as grade_name,ss.term_id, se.name as term_name,
        ss.exam_type,ss.pass_line,ss.good_line,ss.excellent_line,ss.create_time
        from smart_section ss
        left join smart_grade sg on sg.deleted = 0 and sg.id = ss.grade_id
        left join smart_semester se on se.deleted = 0 and se.id = ss.term_id
        where ss.deleted = 0
    </select>
</mapper>
