101captain
2022-03-11 9e59f7f938568c013959903d86d3d2ff83b09123
党建bug提交
1个文件已修改
3 ■■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbMemberMapper.xml 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbMemberMapper.xml
@@ -249,6 +249,9 @@
                    cpo.`name` like concat (#{dto.keyWord},'%')
                    )
                </if>
                <if test="dto.month !=null and dto.month !=''">
                    and (cpm.create_at >= DATE_FORMAT(  CONCAT(#{dto.month},'-00-00'), '%Y-00-00 00:00:00') and DATE_FORMAT(  CONCAT(#{dto.month},'-12-31'), '%Y-12-31 23:59:59') >= cpm.create_at)
                </if>
            </where>
            order by cpm.create_at desc
    </select>