<?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.trs.ggzyexchange.mapper.ZcPurchaseBulletinMapper">

    <select id="queryZcPurchaseBulletinAllList" resultType="com.trs.ggzyexchange.entity.TenderDetailsVo">


        select
            zpb.SOURCE_DATA_KEY sourceDataKey,
            zp.PROJECT_CODE projectCode,
            zp.PURCHASE_PROJECT_NAME projectName,
            zpb.PURCHASE_PROJECT_CODE tenderProjectCode,
            zpb.BULLETIN_TITLE noticeName,
            zpb.BULLETIN_CONTENT noticeContent,
            zpb.BULLETIN_START_TIME noticeSendTime,
            zp.region_Code regionCode,
            zpb.PLATFORM_CODE platformCode,
            zpb.BULLETIN_MEDIA bulletinDuty,
            zpb.DATA_SOURCE_CODE dataSourceCode,
            zpb.DOC_GET_START_TIME docGetStartTime,
            zpb.DOC_GET_END_TIME docGetEndTime,
            zpb.BID_CLOSING_TIME bidDocReferEndTime,
            zpb.BID_OPEN_TIME bidOpenTime

        from

            ZC_PURCHASE_BULLETIN zpb

                left join ZC_PROJECT zp

                          on zpb.PURCHASE_PROJECT_CODE = zp.PURCHASE_PROJECT_CODE


    </select>
</mapper>
