java/zhihuishenqu.git

			@@ -87,13 +87,13 @@
			expert.setCreateTime(new Date());
			if (expert.getLevel()==2){
			expert.setIndustryCenterId(Long.parseLong(expert.getUnitId()));
			expert.setUnit(comSanshuoIndustryCenterDao.selectById(expert.getUnitId()).getName()+"调解站");
			expert.setUnit(comSanshuoIndustryCenterDao.selectById(expert.getUnitId()).getName());
			}else if(expert.getLevel()==3){
			expert.setStreetId(Long.parseLong(expert.getUnitId()));
			expert.setUnit(comStreetDAO.selectById(expert.getUnitId()).getName()+"调解站");
			}else if(expert.getLevel()==4){
			expert.setCommunityId(Long.parseLong(expert.getUnitId()));
			expert.setUnit(comActDAO.selectById(expert.getUnitId()).getName()+"调解站");
			expert.setUnit(comActDAO.selectById(expert.getUnitId()).getName()+"调解室");
			}else{
			expert.setUnit("区三说会堂");
			}
			@@ -177,12 +177,13 @@
			id=loginUserInfo.getStreetId();
			}
			}
			}log.info("==================="+loginUserInfo);
			}
			if (loginUserInfo.getAccount().equals("admin")){
			//三说会堂查看所有专家
			id=null;
			range=1;
			}
			log.info("");
			IPage<ComSanshuoExpertVO> comSanshuoExpertVOIPage = comSanshuoExpertDao.expertPage(new Page(page, size), keyWord, range, id, level);
			for (ComSanshuoExpertVO record : comSanshuoExpertVOIPage.getRecords()) {
			//获取调解次数和成功率

			@@ -97,13 +97,13 @@


			<select id="selectExpertStreet" resultType="com.panzhihua.common.model.vos.sanshuo.ExpertShowVO">
			select count(t.id) as 'count',t1.name,t1.street_id,t.level as id from com_sanshuo_expert t
			select count(t.id) as 'count',t1.name,t1.street_id as id,t.level from com_sanshuo_expert t
			left join com_street t1 on t.street_id=t1.street_id
			where t.level=3 and t.status=1 and t.del_flag=1
			group by t1.name
			</select>
			<select id="selectExpertCommunity" resultType="com.panzhihua.common.model.vos.sanshuo.ExpertShowVO">
			select count(t.id) as 'count',t1.name,t1.community_id,t.level as id from com_sanshuo_expert t
			select count(t.id) as 'count',t1.name,t1.community_id as id,t.level from com_sanshuo_expert t
			left join com_act t1 on t.community_id=t1.community_id
			where t.level=4 and t.status=1 and t.del_flag=1
			group by t1.name

	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComSanShuoExpertServiceImpl.java	7 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComSanshuoExpertDao.xml	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史