#

LSH

2023-12-01 09ee5added9d59e90310a2586e846137ea597b19

#

 src/main/java/com/zy/crm/manager/controller/DashboardController.java

@@ -133,7 +133,7 @@
        map.put("successCount", successCount);

        //获取待处理任务数量
        int planPendingTaskCount = planService.selectCount(new EntityWrapper<Plan>().eq("director", getUserId()).lt("settle",4));
        int planPendingTaskCount = planService.selectPendingTaskCount(getUserId());
        map.put("planPendingTaskCount", planPendingTaskCount);
        int priOnlinePendingTaskCount = priOnline2Service.selectCount(new EntityWrapper<PriOnline2>().eq("member_id", getUserId()).lt("settle",2));
        map.put("priOnlinePendingTaskCount", priOnlinePendingTaskCount);

 src/main/java/com/zy/crm/manager/mapper/PlanMapper.java

@@ -14,6 +14,7 @@
public interface PlanMapper extends BaseMapper<Plan> {

    Plan selectByUuid(@Param("hostId") Long hostId, @Param("uuid") String uuid);
    Integer selectPendingTaskCount(@Param("director") Long director);

    Plan selectPlanByNewestUuid(@Param("hostId") Long hostId);


 src/main/java/com/zy/crm/manager/service/PlanService.java

@@ -9,6 +9,7 @@
public interface PlanService extends IService<Plan> {

    Plan selectByUuid(Long hostId, String uuid);
    Integer selectPendingTaskCount(Long director);

    String getUuid(Long hostId);


 src/main/java/com/zy/crm/manager/service/impl/PlanServiceImpl.java

@@ -20,6 +20,11 @@
    }

    @Override
    public Integer selectPendingTaskCount(Long director) {
        return this.baseMapper.selectPendingTaskCount(director);
    }

    @Override
    public String getUuid(Long hostId) {
        String uuid = null;
        int times = 0;

 src/main/resources/mapper/PlanMapper.xml

@@ -121,4 +121,11 @@
        ORDER BY mp.update_time DESC,mp.create_time DESC
    </select>

    <select id="selectPendingTaskCount" resultType="java.lang.Integer">
        select count(1) from man_plan
        where 1=1
        and director = #{director}
        and settle &lt; settle_size
    </select>

</mapper>