任务添加水库

guoshilong

2023-03-30 544b477d53bfd6cddf904b214fb8d6e23fe122d4

任务添加水库

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/entity/PatrolTask.java

@@ -59,4 +59,8 @@
    /**任务类型*/
    @ApiModelProperty(value = "任务类型")
    private String taskType;

    /**任务类型*/
    @ApiModelProperty(value = "任务类型")
    private String projectId;
}

 skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/patrol/mapper/PatrolTaskMapper.xml

@@ -4,7 +4,7 @@


    <select id="selectPatrolTask" resultType="cn.gistack.sm.patrol.entity.PatrolTask">
        SELECT id,title,start_time,end_time,content,to_user_id,route_id,state,source,task_type
        SELECT id,title,start_time,end_time,content,to_user_id,route_id,state,source,task_type,project_id
        FROM sm_patrol_task
        WHERE is_deleted = 0
        <if test="patrolTask.title !=null and patrolTask.title!=''">
@@ -16,5 +16,8 @@
        <if test="patrolTask.endTime !=null and patrolTask.endTime !=''">
            AND DATE_FORMAT(end_time,'%Y-%m-%d') &lt;= #{patrolTask.endTime}
        </if>
        <if test="patrolTask.projectId !=null and patrolTask.projectId !='' ">
            AND project_id = #{patrolTask.projectId}
        </if>
    </select>
</mapper>