zhangtiansen
2022-10-19 ca15c814e1ff973986ccb38ff017e1bcdc898770
update
1个文件已修改
31 ■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComSanshuoExpertDao.xml 31 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComSanshuoExpertDao.xml
@@ -71,21 +71,22 @@
                    </if>
                </if>
            </if>
            <if test="range != null and range != ''">
                <if test="range == 3">
                  AND street_id=#{id}
                </if>
                <if test="range == 4">
                  AND community_id=#{id}
                </if>
                <if test="range == 2">
                  AND industry_center_id=#{id}
                </if>
                <if test="range == 1">
                    AND level=1
                </if>
            </if>
           <if test="level == null">
               <if test="range != null and range != ''">
                   <if test="range == 3">
                       AND street_id=#{id}
                   </if>
                   <if test="range == 4">
                       AND community_id=#{id}
                   </if>
                   <if test="range == 2">
                       AND industry_center_id=#{id}
                   </if>
                   <if test="range == 1">
                       AND level=1
                   </if>
               </if>
           </if>
    </select>
    <select id="selectExpertIndustry" resultType="com.panzhihua.common.model.vos.sanshuo.ExpertShowVO">
        select  count(t.id) as 'count',t1.name,t1.id from com_sanshuo_expert t