日期取取2位进行匹配

最新推荐文章于 2024-09-24 08:39:48 发布

qq_27327261

最新推荐文章于 2024-09-24 08:39:48 发布

阅读量132

点赞数

分类专栏：博客文章标签： java

本文链接：https://blog.csdn.net/qq_27327261/article/details/107731990

版权

博客专栏收录该内容

449 篇文章 6 订阅

订阅专栏

<select id="getRiverLog" resultType="com.wochanye.riverAdmin.vo.OutfallLogEnterpriseVo" parameterType="map">
    SELECT
    a.*,
    b.`name`,
    b.country,
    b.type as intoRiverMode
    FROM water_ecology_outfall_log AS a LEFT JOIN water_ecology_outfall_river AS b ON  a.object_id = b.id
    where  a.type = 2
    <if test="yearMonth != null" >
        and DATE_FORMAT(log_time, '%Y-%m')  =  #{yearMonth}
    </if>
    and a.`status` = 1
    and b.`status` = 1
    <if test="country != null" >
        and b.country = #{country}
    </if>
    <if test="intoRiverMode != null" >
        and b.type = #{intoRiverMode}
    </if>
    order by a.log_time desc
</select>