| | |
| | | </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 |