<?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="org.dromara.system.mapper.StudentInfoOldMapper">

    <resultMap type="org.dromara.system.domain.vo.StudentInfoOldVo" id="StudentInfoOldResult">
        <result property="oldId"    column="old_id"    />
        <result property="studentId"    column="student_id"    />
        <result property="name"    column="name"    />
        <result property="sex"    column="sex"    />
        <result property="age"    column="age"    />
        <result property="school"    column="school"    />
        <result property="studentNumber"    column="student_number"    />
        <result property="idCard"    column="id_card"    />
        <result property="isNearsightedness"    column="is_nearsightedness"    />
        <result property="degreeMyopia"    column="degree_myopia"    />
        <result property="height"    column="height"    />
        <result property="weight"    column="weight"    />
        <result property="bloodType"    column="blood_type"    />
        <result property="politicalStatus"    column="political_status"    />
        <result property="health"    column="health"    />
        <result property="identificationPhoto"    column="identification_photo"    />
        <result property="mind"    column="mind"    />
        <result property="entrancePermit"    column="entrance_permit"    />
        <result property="fatherName"    column="father_name"    />
        <result property="fatherTelephone"    column="father_telephone"    />
        <result property="motherName"    column="mother_name"    />
        <result property="motherTelephone"    column="mother_telephone"    />
        <result property="address"    column="address"    />
        <result property="longitude"    column="longitude"    />
        <result property="latitude"    column="latitude"    />
        <result property="remark"    column="remark"    />

        <result property="isMedicalHistory"    column="is_medical_history"    />
        <result property="medicalDescription"    column="medical_description"    />
        <result property="psychologicalDescription"    column="psychological_description"    />

        <result property="isLset"    column="is_lset"    />
        <result property="isPoverty"    column="is_poverty"    />

        <result property="emergencyContact"    column="emergency_contact"    />
        <result property="emergencyContactTelephone"    column="emergency_contact_telephone"    />

        <result property="familyName"    column="family_name"    />
        <result property="isFarsightedness"    column="is_farsightedness"    />
        <result property="farsightedness"    column="farsightedness"    />
    </resultMap>

    <sql id="selectStudentInfoOldVo">
        select old_id, student_id, name, sex, age, school, student_number, id_card, is_nearsightedness, degree_myopia, height, weight, blood_type, political_status,
               health, identification_photo, mind, entrance_permit, father_name, father_telephone, mother_name, mother_telephone, address, longitude, latitude,
               create_by, create_time, update_by, update_time, remark,is_medical_history,medical_description,psychological_description,is_lset,is_poverty,
               emergency_contact,emergency_contact_telephone,family_name,is_farsightedness,farsightedness from student_info_old
    </sql>

    <select id="selectVoMapperPage" resultMap="StudentInfoOldResult">
        <include refid="selectStudentInfoOldVo"/>
        ${ew.getCustomSqlSegment}
    </select>

    <select id="selectVoMapperList" resultMap="StudentInfoOldResult">
        <include refid="selectStudentInfoOldVo"/>
        ${ew.getCustomSqlSegment}
    </select>
</mapper>
