项目管理修改

101captain

2022-01-24 b9ebfc491ced283660f3b569e570987eaecb50d3

项目管理修改

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComActSocialProjectMapper.xml

@@ -23,25 +23,25 @@
        left join com_act_column t2 on t.second_column_id = t2.id
        <where>
            1=1
            <if test="commonPage.communityId !=0 and commonPage.communityId ！=null">
            <if test="commonPage.communityId !=0 and commonPage.communityId !=null">
                and t.community_id =#{commmonPage.communityId}
            </if>
            <if test="commonPage.streetId !=0 and commonPage.streetId ！=null">
            <if test="commonPage.streetId !=0 and commonPage.streetId !=null">
                and t.street_id =#{commmonPage.streetId}
            </if>
            <if test="commonPage.status ！=null">
            <if test="commonPage.status !=null">
                and t.status =#{commmonPage.status}
            </if>
            <if test="commonPage.type ！=null">
            <if test="commonPage.type !=null">
                and t.type =#{commmonPage.type}
            </if>
            <if test="commonPage.keyword ！=null and commonPage.keyword !=''">
            <if test="commonPage.keyword !=null and commonPage.keyword !=''">
                and (t.name like concat('%',#{commmonPage.keyword},'%')  or responsibility like concat('%',#{commmonPage.keyword},'%') )
            </if>
            <if test="commonPage.beginTime ！=null">
            <if test="commonPage.beginTime !=null">
                and t.create_time >= #{commonPage.beginTime}
            </if>
            <if test="commonPage.endTime ！=null">
            <if test="commonPage.endTime !=null">
                and #{commonPage.endTime} >= t.create_time
            </if>
            <if test="commonPage.paramId !=null">