<?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.jeecg.modules.projectManagement.mapper.FdProjectQuotationDetailMapper">

    <select id="findByPage" resultType="org.jeecg.modules.projectManagement.entity.FdProjectQuotationDetail">
      SELECT
            fpqd.id,
            fpqd.study_type,
            fpqd.subject_number,
            fpqd.period,
            fpqd.samples_period,
            fpqd.samples_time,
            fpqd.opv_period,
            fpqd.cleaning_period,
            fpqd.hospitalization
        FROM
            fd_project_quotation_detail fpqd
        LEFT JOIN fd_project_quotation fpq ON fpqd.quotation_id = fpq.id
             ${ew.customSqlSegment}
    </select>

    <update id="updateDelFlagByQuotationId">
            UPDATE fd_project_quotation_detail SET del_flag='1' WHERE quotation_id=#{quotationId}
    </update>
</mapper>