flower_city/src/main/java/com/dg/core/controller/GuideDoController.java
@@ -4,6 +4,7 @@ import com.dg.core.ResultData; import com.dg.core.annotation.Authorization; import com.dg.core.db.gen.entity.SysUser; import com.dg.core.service.IGuideRepairOrderService; import com.dg.core.service.ISysUserService; import com.dg.core.util.Snowflake; import com.dg.core.util.TableDataInfo; @@ -28,6 +29,9 @@ @Autowired ISysUserService IUserService; @Autowired IGuideRepairOrderService iGuideRepairOrderService; /** * 查询列表 @@ -143,6 +147,13 @@ { return error("userId不能为空"); } int a=iGuideRepairOrderService.countUser(userId,"2"); if(a>0) { return error("该人员有工单未处理完不能删除"); } return toAjax(IUserService.deleteConfigById(userId)); } flower_city/src/main/java/com/dg/core/db/gen/mapper/GuideRepairOrderMapper.java
@@ -62,6 +62,12 @@ /** * 很具用户id查询是否有对应工单 * @return */ int countUser(@Param("userId") String userId,@Param("state") String state); /** * 统计工单用 1 今天 2昨天 3本月 4本年度 * @return */ flower_city/src/main/java/com/dg/core/service/IGuideRepairOrderService.java
@@ -49,6 +49,13 @@ */ int countConfigList(String matterName,List<String> ids); /** * 很具用户id查询是否有对应工单 * @return */ int countUser(String userId,String state); /** * 根据进展类修改用户代办数量 * @param order flower_city/src/main/java/com/dg/core/service/impl/GuideRepairOrderServiceImpl.java
@@ -175,6 +175,11 @@ } @Override public int countUser(String userId, String state) { return baseMapper.countUser(userId,state); } @Override public int updateSysUserOrderNum(GuideEvolveEntity order) { if(order.getState().equals("13")){ SysUser sysUser = sysUserMapper.selectOne(new QueryWrapper<SysUser>().lambda().eq(SysUser::getUserId, order.getToUserId())); flower_city/src/main/resources/mapper/GuideRepairOrderMapper.xml
@@ -148,6 +148,20 @@ select count(id) from automessage_guide_repair_order </select> <select id="countUser" resultType="integer"> select count(id) from automessage_guide_repair_order <where> <if test="userId != null and userId != ''"> AND guide_user_id=#{userId} </if> <if test="state != null and state != ''"> AND automessage_guide_repair_order.state = #{state} </if> </where> </select> <!-- 首页统计 勿动 --> <select id="countStatisticsNum" parameterType="string" resultType="integer"> select count(id) from automessage_guide_repair_order @@ -202,10 +216,10 @@ </if> </where> GROUP BY date_format(create_time,'%y%m%d') date_format(create_time,'%y%m%d') ORDER BY create_time DESC LIMIT #{time} create_time DESC LIMIT #{time} </select> </mapper>