From 37d57abd8bc8aa69a2518f693a2c971de8a08859 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Mon, 25 Sep 2023 19:26:43 +0800
Subject: [PATCH] 任务查询报错修改
---
src/main/java/org/springblade/modules/taskqd/mapper/TaskqdMapper.java | 43 ++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 42 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/taskqd/mapper/TaskqdMapper.java b/src/main/java/org/springblade/modules/taskqd/mapper/TaskqdMapper.java
index 54be1dd..09fc749 100644
--- a/src/main/java/org/springblade/modules/taskqd/mapper/TaskqdMapper.java
+++ b/src/main/java/org/springblade/modules/taskqd/mapper/TaskqdMapper.java
@@ -18,12 +18,15 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
+import org.apache.ibatis.annotations.Param;
import org.bytedeco.javacpp.presets.opencv_core;
import org.springblade.modules.task.entity.Task;
import org.springblade.modules.task.vo.TaskVO;
import org.springblade.modules.taskqd.entity.Taskqd;
+import org.springblade.modules.taskqd.excel.TaskExcel;
import org.springblade.modules.taskqd.vo.TaskqdVO;
+import java.util.Date;
import java.util.List;
import java.util.Map;
@@ -37,9 +40,47 @@
//抢单任务
void updatet(Integer id, Integer num, String serid,String captain,String team);
void updateRtype(String type,String rid);
+ boolean updateSerid(String rid,String serid,String newteam,int newnum);
List<Taskqd> selectList(Integer id);
List<Map<String, Object>> queryReceiver(String serid);
- List<TaskqdVO> selectLi(String type, String serid,String jurisdiction);
+ List<Map<String, Object>> taskCount(String id,String type);
+ List<Map<String, Object>> allTask();
+ List<TaskqdVO> getlist(String id,String type);
+
+ /**
+ * 任务查询
+ * @param type 任务状态 0：未开始 1：正在进行 2：已完成
+ * @param serid 用户id
+ * @param jurisdiction 辖区id
+ * @param workjurisdiction 工作辖区
+ * @param tasktype 任务状态
+ * @return
+ */
+ List<TaskqdVO> selectLi(@Param("type") Integer type,
+ @Param("serid")String serid,
+ @Param("jurisdiction")String jurisdiction,
+ @Param("workjurisdiction")String workjurisdiction,
+ @Param("tasktype")String tasktype);
+
List<Map<String, Object>> selectNum(String serid,String jurisdiction,String workjurisdiction);
String querySerid(String rid);
+
+ List<Taskqd> countTaskByJur(@Param("jurisdiction") String jurisdiction, @Param("startTime") String startTime,@Param("period") String period);
+
+ int getRealTime(String hdid);
+
+ /**
+ * 自定义分页查询
+ * @param page
+ * @param taskqd
+ * @return
+ */
+ List<TaskqdVO> selectTaskQdPage(@Param("page")IPage<TaskqdVO> page,@Param("taskqd") TaskqdVO taskqd);
+
+ /**
+ * 导出任务数据
+ * @param task
+ * @return
+ */
+ List<TaskExcel> selectTaskList(@Param("task")TaskqdVO task);
}
--
Gitblit v1.9.3