<?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="cn.cecep.talroad.mapper.analysis.SRaActionReportsAuditFactoryInfoMapper">


    <select id="selectUnAuditFactory" resultType="cn.cecep.talroad.domain.vo.AuditRecordLIstVO">
        select
            factoryInfo.id,
            factory.factory_name ,
            report.report_time ,
            factory.city_name ,
            factory.country_name,
            industry.indus_name as industryName,
            factory.license_man_type,
            factoryInfo.commit_time ,
            factory.poll_dis_license_code

        from s_ra_action_reports_audit_factory_info factoryInfo
                 left join pc_factory factory on factoryinfo.factory_id  = factory.id
                 left join s_ra_action_reports_audit report on factoryInfo.report_id = report.id
                 left join pc_industry industry on factory.industry_category = industry.indus_code
        where factoryInfo.audit_status  = 0 and report.id = #{reportId}

    </select>
</mapper>
