From bdb4a481d7ab7085a0832a7f1c0f5295596d498c Mon Sep 17 00:00:00 2001
From: wl <173@qq.com>
Date: 星期二, 08 十一月 2022 18:09:23 +0800
Subject: [PATCH] 图片管理和视频管理
---
ycl-generator/src/main/java/com/ycl/entity/message/MessageColumnSet.java | 52 ++++
ycl-platform/src/main/java/com/ycl/vo/casePool/FilesPictureVo.java | 4
ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseImageResourcesMapper.java | 4
ycl-platform/src/main/java/com/ycl/entity/cockpitManage/TeamConstruction.java | 26 +
ycl-platform/src/main/java/com/ycl/vo/resources/MediaVO.java | 35 +++
ycl-platform/src/main/java/com/ycl/entity/resources/ImageResources.java | 10
ycl-generator/src/main/java/com/ycl/mapper/message/MessageColumnSetMapper.java | 16 +
ycl-platform/src/main/resources/mapper/resources/ImageResourcesMapper.xml | 42 +++
ycl-generator/src/main/java/com/ycl/controller/message/MessageColumnSetController.java | 21 +
ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/DisposeRecordServiceImpl.java | 2
ycl-platform/src/main/java/com/ycl/mapper/resources/VideoResourcesMapper.java | 19 +
ycl-platform/src/main/java/com/ycl/controller/resources/VideoResourcesController.java | 69 ++++++
ycl-platform/src/main/java/com/ycl/controller/caseHandler/DispatchHandleController.java | 12
ycl-generator/src/main/resources/mapper/message/MessageColumnSetMapper.xml | 18 +
ycl-platform/src/main/java/com/ycl/controller/resources/ImageResourcesController.java | 70 ++++++
ycl-platform/src/main/java/com/ycl/entity/resources/VideoResources.java | 20
ycl-platform/src/main/java/com/ycl/mapper/resources/ImageResourcesMapper.java | 19 +
ycl-platform/src/main/java/com/ycl/service/resources/IImageResourcesService.java | 19 +
ycl-generator/src/main/java/com/ycl/service/message/impl/MessageColumnSetServiceImpl.java | 20 +
ycl-platform/src/main/java/com/ycl/service/resources/IVideoResourcesService.java | 19 +
/dev/null | 20 -
ycl-platform/src/main/java/com/ycl/service/resources/impl/VideoResourcesServiceImpl.java | 35 +++
ycl-platform/src/main/resources/mapper/resources/VideoResourcesMapper.xml | 42 +++
ycl-generator/src/main/java/com/ycl/service/message/IMessageColumnSetService.java | 16 +
ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java | 8
ycl-platform/src/main/java/com/ycl/service/resources/impl/ImageResourcesServiceImpl.java | 35 +++
26 files changed, 593 insertions(+), 60 deletions(-)
diff --git a/ycl-generator/src/main/java/com/ycl/controller/message/MessageColumnSetController.java b/ycl-generator/src/main/java/com/ycl/controller/message/MessageColumnSetController.java
new file mode 100644
index 0000000..8133eaf
--- /dev/null
+++ b/ycl-generator/src/main/java/com/ycl/controller/message/MessageColumnSetController.java
@@ -0,0 +1,21 @@
+package com.ycl.controller.message;
+
+
+import org.springframework.web.bind.annotation.RequestMapping;
+
+import org.springframework.web.bind.annotation.RestController;
+import com.ycl.base.BaseController;
+
+/**
+ * <p>
+ * 娑堟伅鏍忕洰璁剧疆琛� 鍓嶇鎺у埗鍣�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+@RestController
+@RequestMapping("/message-column-set")
+public class MessageColumnSetController extends BaseController {
+
+}
diff --git a/ycl-generator/src/main/java/com/ycl/entity/message/MessageColumnSet.java b/ycl-generator/src/main/java/com/ycl/entity/message/MessageColumnSet.java
new file mode 100644
index 0000000..273ea5c
--- /dev/null
+++ b/ycl-generator/src/main/java/com/ycl/entity/message/MessageColumnSet.java
@@ -0,0 +1,52 @@
+package com.ycl.entity.message;
+
+import com.baomidou.mybatisplus.annotation.TableName;
+import com.baomidou.mybatisplus.annotation.IdType;
+import com.baomidou.mybatisplus.annotation.Version;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableField;
+import java.io.Serializable;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+/**
+ * <p>
+ * 娑堟伅鏍忕洰璁剧疆琛�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+@Data
+@EqualsAndHashCode(callSuper = false)
+@TableName("ums_message_column_set")
+public class MessageColumnSet implements Serializable {
+
+ private static final long serialVersionUID = 1L;
+
+ /**
+ * 涓婚敭Id
+ */
+ @TableId(value = "id", type = IdType.AUTO)
+ private Integer id;
+
+ /**
+ * 鐢ㄦ埛Id
+ */
+ @TableField("user_id")
+ private Integer userId;
+
+ /**
+ * 鏍忕洰Id
+ */
+ @TableField("message_column_id")
+ private Integer messageColumnId;
+
+ /**
+ * 鏄惁鎺ユ敹0-涓嶆帴鏀�1-鎺ユ敹
+ */
+ @TableField("is_receive")
+ private Integer isReceive;
+
+
+}
diff --git a/ycl-generator/src/main/java/com/ycl/mapper/message/MessageColumnSetMapper.java b/ycl-generator/src/main/java/com/ycl/mapper/message/MessageColumnSetMapper.java
new file mode 100644
index 0000000..aede402
--- /dev/null
+++ b/ycl-generator/src/main/java/com/ycl/mapper/message/MessageColumnSetMapper.java
@@ -0,0 +1,16 @@
+package com.ycl.mapper.message;
+
+import com.ycl.entity.message.MessageColumnSet;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+
+/**
+ * <p>
+ * 娑堟伅鏍忕洰璁剧疆琛� Mapper 鎺ュ彛
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+public interface MessageColumnSetMapper extends BaseMapper<MessageColumnSet> {
+
+}
diff --git a/ycl-generator/src/main/java/com/ycl/service/message/IMessageColumnSetService.java b/ycl-generator/src/main/java/com/ycl/service/message/IMessageColumnSetService.java
new file mode 100644
index 0000000..4c31228
--- /dev/null
+++ b/ycl-generator/src/main/java/com/ycl/service/message/IMessageColumnSetService.java
@@ -0,0 +1,16 @@
+package com.ycl.service.message;
+
+import com.ycl.entity.message.MessageColumnSet;
+import com.baomidou.mybatisplus.extension.service.IService;
+
+/**
+ * <p>
+ * 娑堟伅鏍忕洰璁剧疆琛� 鏈嶅姟绫�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+public interface IMessageColumnSetService extends IService<MessageColumnSet> {
+
+}
diff --git a/ycl-generator/src/main/java/com/ycl/service/message/impl/MessageColumnSetServiceImpl.java b/ycl-generator/src/main/java/com/ycl/service/message/impl/MessageColumnSetServiceImpl.java
new file mode 100644
index 0000000..3b76f3a
--- /dev/null
+++ b/ycl-generator/src/main/java/com/ycl/service/message/impl/MessageColumnSetServiceImpl.java
@@ -0,0 +1,20 @@
+package com.ycl.service.message.impl;
+
+import com.ycl.entity.message.MessageColumnSet;
+import com.ycl.mapper.message.MessageColumnSetMapper;
+import com.ycl.service.message.IMessageColumnSetService;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springframework.stereotype.Service;
+
+/**
+ * <p>
+ * 娑堟伅鏍忕洰璁剧疆琛� 鏈嶅姟瀹炵幇绫�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+@Service
+public class MessageColumnSetServiceImpl extends ServiceImpl<MessageColumnSetMapper, MessageColumnSet> implements IMessageColumnSetService {
+
+}
diff --git a/ycl-generator/src/main/resources/mapper/message/MessageColumnSetMapper.xml b/ycl-generator/src/main/resources/mapper/message/MessageColumnSetMapper.xml
new file mode 100644
index 0000000..56c044b
--- /dev/null
+++ b/ycl-generator/src/main/resources/mapper/message/MessageColumnSetMapper.xml
@@ -0,0 +1,18 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ycl.mapper.message.MessageColumnSetMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="com.ycl.entity.message.MessageColumnSet">
+ <id column="id" property="id" />
+ <result column="user_id" property="userId" />
+ <result column="message_column_id" property="messageColumnId" />
+ <result column="is_receive" property="isReceive" />
+ </resultMap>
+
+ <!-- 閫氱敤鏌ヨ缁撴灉鍒� -->
+ <sql id="Base_Column_List">
+ id, user_id, message_column_id, is_receive
+ </sql>
+
+</mapper>
diff --git a/ycl-platform/src/main/java/com/ycl/controller/caseHandler/DispatchHandleController.java b/ycl-platform/src/main/java/com/ycl/controller/caseHandler/DispatchHandleController.java
index 71dfe4c..78057fc 100644
--- a/ycl-platform/src/main/java/com/ycl/controller/caseHandler/DispatchHandleController.java
+++ b/ycl-platform/src/main/java/com/ycl/controller/caseHandler/DispatchHandleController.java
@@ -1,26 +1,20 @@
package com.ycl.controller.caseHandler;
-import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
import com.ycl.annotation.LogSave;
import com.ycl.api.CommonResult;
import com.ycl.bo.AdminUserDetails;
-import com.ycl.common.constant.BaseCaseStatus;
-import com.ycl.common.constant.StepName;
import com.ycl.dto.caseHandler.DispatchInfoParam;
import com.ycl.dto.dispatch.UploadDisposingResultParam;
-import com.ycl.entity.caseHandler.*;
+import com.ycl.entity.caseHandler.DispatchInfo;
import com.ycl.service.caseHandler.*;
+import com.ycl.service.resources.IImageResourcesService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
-import org.apache.commons.lang3.StringUtils;
-import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.core.context.SecurityContextHolder;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
-
-import java.time.LocalDateTime;
/**
* <p>
@@ -69,7 +63,7 @@
public CommonResult searchDisposeList(@RequestParam Long caseId,
@RequestParam Integer type,
@RequestBody UploadDisposingResultParam uploadDisposingResultParam) {
- iDisposeRecordService.saveUpload(caseId,type,uploadDisposingResultParam);
+ iDisposeRecordService.saveUpload(caseId, type, uploadDisposingResultParam);
return CommonResult.success("add success");
}
}
diff --git a/ycl-platform/src/main/java/com/ycl/controller/resources/ImageResourcesController.java b/ycl-platform/src/main/java/com/ycl/controller/resources/ImageResourcesController.java
new file mode 100644
index 0000000..f5b8966
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/controller/resources/ImageResourcesController.java
@@ -0,0 +1,70 @@
+package com.ycl.controller.resources;
+
+
+import com.ycl.annotation.LogSave;
+import com.ycl.api.CommonResult;
+import com.ycl.controller.BaseController;
+import com.ycl.entity.resources.ImageResources;
+import com.ycl.service.resources.IImageResourcesService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+/**
+ * <p>
+ * 鍓嶇鎺у埗鍣�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+@RestController
+@RequestMapping("/image_resources")
+@Api(tags = "鍥剧墖璧勬簮绠＄悊")
+public class ImageResourcesController extends BaseController {
+
+ @Autowired
+ IImageResourcesService iImageResourcesService;
+
+ @GetMapping("/query")
+ @ApiOperation("鏌ヨ")
+ public CommonResult search(@RequestParam(required = false) Integer type,
+ @RequestParam(required = false) String startTime,
+ @RequestParam(required = false) String endTime,
+ @RequestParam Long size,
+ @RequestParam Long current) {
+ return CommonResult.success(iImageResourcesService.selectImages(type, startTime, endTime, size, current));
+ }
+
+ @PutMapping("modification")
+ @ApiOperation("淇敼鍥剧墖")
+ @LogSave(operationType = "鍥剧墖绠＄悊",contain = "淇敼鍥剧墖")
+ public CommonResult modify(@RequestBody ImageResources imageResources) {
+ return CommonResult.success(iImageResourcesService.updateById(imageResources));
+ }
+
+ @DeleteMapping("deletion")
+ @ApiOperation("鍒犻櫎")
+ @LogSave(operationType = "鍥剧墖绠＄悊",contain = "鍒犻櫎鍥剧墖")
+ public CommonResult delete(@RequestParam Integer id) {
+ return CommonResult.success(iImageResourcesService.removeById(id));
+ }
+
+ @PostMapping("addition")
+ @ApiOperation("娣诲姞")
+ @LogSave(operationType = "鍥剧墖绠＄悊",contain = "娣诲姞鍥剧墖")
+ public CommonResult add(@RequestBody ImageResources imageResources) {
+ return CommonResult.success(iImageResourcesService.save(imageResources));
+ }
+
+ @DeleteMapping("deletion_batch")
+ @ApiOperation("鎵归噺鍒犻櫎")
+ @LogSave(operationType = "鍥剧墖绠＄悊",contain = "鎵归噺鍒犻櫎鍥剧墖")
+ public CommonResult delete(@RequestParam List<Integer> ids) {
+ return CommonResult.success(iImageResourcesService.removeBatchByIds(ids));
+ }
+
+}
diff --git a/ycl-platform/src/main/java/com/ycl/controller/resources/VideoResourcesController.java b/ycl-platform/src/main/java/com/ycl/controller/resources/VideoResourcesController.java
new file mode 100644
index 0000000..8ef0a6f
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/controller/resources/VideoResourcesController.java
@@ -0,0 +1,69 @@
+package com.ycl.controller.resources;
+
+
+import com.ycl.annotation.LogSave;
+import com.ycl.api.CommonResult;
+import com.ycl.controller.BaseController;
+import com.ycl.entity.resources.VideoResources;
+import com.ycl.service.resources.IVideoResourcesService;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.*;
+
+import java.util.List;
+
+/**
+ * <p>
+ * 鍓嶇鎺у埗鍣�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+@RestController
+@RequestMapping("/video_resources")
+@Api(tags = "瑙嗛璧勬簮绠＄悊")
+public class VideoResourcesController extends BaseController {
+
+ @Autowired
+ IVideoResourcesService iVideoResourcesService;
+
+ @GetMapping("/query")
+ @ApiOperation("鏌ヨ")
+ public CommonResult search(@RequestParam(required = false) Integer type,
+ @RequestParam(required = false) String startTime,
+ @RequestParam(required = false) String endTime,
+ @RequestParam Long size,
+ @RequestParam Long current) {
+ return CommonResult.success(iVideoResourcesService.selectImages(type, startTime, endTime, size, current));
+ }
+
+ @PutMapping("modification")
+ @ApiOperation("淇敼瑙嗛")
+ @LogSave(operationType = "瑙嗛绠＄悊", contain = "淇敼瑙嗛")
+ public CommonResult modify(@RequestBody VideoResources videoResources) {
+ return CommonResult.success(iVideoResourcesService.updateById(videoResources));
+ }
+
+ @DeleteMapping("deletion")
+ @ApiOperation("鍒犻櫎")
+ @LogSave(operationType = "瑙嗛绠＄悊", contain = "鍒犻櫎瑙嗛")
+ public CommonResult delete(@RequestParam Integer id) {
+ return CommonResult.success(iVideoResourcesService.removeById(id));
+ }
+
+ @PostMapping("addition")
+ @ApiOperation("娣诲姞")
+ @LogSave(operationType = "瑙嗛绠＄悊", contain = "娣诲姞瑙嗛")
+ public CommonResult add(@RequestBody VideoResources videoResources) {
+ return CommonResult.success(iVideoResourcesService.save(videoResources));
+ }
+
+ @DeleteMapping("deletion_batch")
+ @ApiOperation("鎵归噺鍒犻櫎")
+ @LogSave(operationType = "瑙嗛绠＄悊", contain = "鎵归噺鍒犻櫎瑙嗛")
+ public CommonResult delete(@RequestParam List<Integer> ids) {
+ return CommonResult.success(iVideoResourcesService.removeBatchByIds(ids));
+ }
+}
diff --git a/ycl-platform/src/main/java/com/ycl/entity/cockpitManage/TeamConstruction.java b/ycl-platform/src/main/java/com/ycl/entity/cockpitManage/TeamConstruction.java
index 94f8a7e..18b88a9 100644
--- a/ycl-platform/src/main/java/com/ycl/entity/cockpitManage/TeamConstruction.java
+++ b/ycl-platform/src/main/java/com/ycl/entity/cockpitManage/TeamConstruction.java
@@ -31,6 +31,9 @@
@ExcelIgnore
private Long id;
+ @ExcelIgnore
+ private String regionIds;
+
/**
* 閮ㄩ棬鍚嶇О
*/
@@ -53,59 +56,66 @@
private Integer upUndergraduatePeopleNumber;
/**
+ * 鏈瀛﹀巻鍙婁互涓婁汉鏁�
+ */
+ @TableField("holder_number")
+ @ExcelProperty(value = "鎸佽瘉浜烘暟", index = 3)
+ private Integer holderNumber;
+
+ /**
* 45宀佷互涓嬩汉鏁�
*/
@TableField("under_forty_five_people_number")
- @ExcelProperty(value = "45宀佷互涓嬩汉鏁�", index = 3)
+ @ExcelProperty(value = "45宀佷互涓嬩汉鏁�", index = 4)
private Integer underFortyFivePeopleNumber;
/**
* 娉曞緥鑱屼笟璧勬牸璇佷汉鏁�
*/
@TableField("legal_professional_qualification_certificate_people_number")
- @ExcelProperty(value = "娉曞緥鑱屼笟璧勬牸璇佷汉鏁�", index = 4)
+ @ExcelProperty(value = "娉曞緥鑱屼笟璧勬牸璇佷汉鏁�", index = 5)
private Integer legalProfessionalQualificationCertificatePeopleNumber;
/**
* 閫氭姤鏁伴噺
*/
@TableField("report_number")
- @ExcelProperty(value = "閫氭姤鏁伴噺", index = 5)
+ @ExcelProperty(value = "閫氭姤鏁伴噺", index = 6)
private Integer reportNumber;
/**
* 杩濈邯琛屼负鏁伴噺
*/
@TableField("disciplinary_offence_number")
- @ExcelProperty(value = "杩濈邯琛屼负鏁伴噺", index = 6)
+ @ExcelProperty(value = "杩濈邯琛屼负鏁伴噺", index = 7)
private Integer disciplinaryOffenceNumber;
/**
* 杩濇硶鐘姜琛屼负鏁伴噺
*/
@TableField("criminal_offense_number")
- @ExcelProperty(value = "杩濇硶鐘姜琛屼负鏁伴噺", index = 7)
+ @ExcelProperty(value = "杩濇硶鐘姜琛屼负鏁伴噺", index = 8)
private Integer criminalOffenseNumber;
/**
* 姣忔湀妗堜欢鏁伴噺
*/
@TableField("month_case_number")
- @ExcelProperty(value = "姣忔湀妗堜欢鏁伴噺", index = 8)
+ @ExcelProperty(value = "姣忔湀妗堜欢鏁伴噺", index = 9)
private Integer monthCaseNumber;
/**
* 鏈秴鏃舵浠舵暟閲�
*/
@TableField("no_timeout_case_number")
- @ExcelProperty(value = "鏈秴鏃舵浠舵暟閲�", index = 9)
+ @ExcelProperty(value = "鏈秴鏃舵浠舵暟閲�", index = 10)
private Integer noTimeoutCaseNumber;
/**
* 澶嶈瘔鎴栬瘔璁兼暟閲�
*/
@TableField("review_or_lawsuit_number")
- @ExcelProperty(value = "澶嶈瘔鎴栬瘔璁兼暟閲�", index = 10)
+ @ExcelProperty(value = "澶嶈瘔鎴栬瘔璁兼暟閲�", index = 11)
private Integer reviewOrLawsuitNumber;
/**
diff --git a/ycl-platform/src/main/java/com/ycl/entity/common/ImageResources.java b/ycl-platform/src/main/java/com/ycl/entity/common/ImageResources.java
deleted file mode 100644
index 61f215d..0000000
--- a/ycl-platform/src/main/java/com/ycl/entity/common/ImageResources.java
+++ /dev/null
@@ -1,67 +0,0 @@
-package com.ycl.entity.common;
-
-import com.baomidou.mybatisplus.annotation.IdType;
-import com.baomidou.mybatisplus.annotation.TableField;
-import com.baomidou.mybatisplus.annotation.TableId;
-import com.baomidou.mybatisplus.annotation.TableName;
-import io.swagger.annotations.ApiModel;
-import io.swagger.annotations.ApiModelProperty;
-import lombok.Data;
-import lombok.EqualsAndHashCode;
-
-import java.io.Serializable;
-import java.util.Date;
-
-/**
- * <p>
- * 鍥剧墖璧勬簮
- * </p>
- *
- * @author mg
- * @since 2022-09-29
- */
-@Data
-@EqualsAndHashCode(callSuper = false)
-@TableName("ums_image_resources")
-@ApiModel(value = "鍥剧墖璧勬簮琛�")
-public class ImageResources implements Serializable {
-
- private static final long serialVersionUID = 1L;
- /**
- * id
- */
- @TableId(value = "id", type = IdType.AUTO)
- @ApiModelProperty(value = "id")
- private Long id;
- /**
- * 鎵�灞濱d
- */
- @TableField("belong_to_id")
- @ApiModelProperty(value = "鎵�灞濱d")
- private Long belongToId;
- /**
- * 鍥剧墖绫诲瀷
- */
- @TableField("type")
- @ApiModelProperty(value = "鍥剧墖绫诲瀷")
- private String type;
- /**
- * 璺緞
- */
- @TableField("url")
- @ApiModelProperty(value = "璺緞")
- private String url;
- /**
- * 鍒涘缓浜�
- */
- @TableField("create_user")
- @ApiModelProperty(value = "鍒涘缓浜�")
- private Integer createUser;
- /**
- * 鍒涘缓鏃堕棿
- */
- @TableField("create_time")
- @ApiModelProperty(value = "鍒涘缓鏃堕棿")
- private Date createTime;
-
-}
diff --git a/ycl-platform/src/main/java/com/ycl/entity/caseHandler/ImageResources.java b/ycl-platform/src/main/java/com/ycl/entity/resources/ImageResources.java
similarity index 87%
rename from ycl-platform/src/main/java/com/ycl/entity/caseHandler/ImageResources.java
rename to ycl-platform/src/main/java/com/ycl/entity/resources/ImageResources.java
index e31a2bc..8450c0b 100644
--- a/ycl-platform/src/main/java/com/ycl/entity/caseHandler/ImageResources.java
+++ b/ycl-platform/src/main/java/com/ycl/entity/resources/ImageResources.java
@@ -1,4 +1,4 @@
-package com.ycl.entity.caseHandler;
+package com.ycl.entity.resources;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
@@ -15,8 +15,8 @@
*
* </p>
*
- * @author zhanghua
- * @since 2022-10-21
+ * @author lyq
+ * @since 2022-11-08
*/
@Data
@EqualsAndHashCode(callSuper = false)
@@ -29,7 +29,7 @@
* 涓婚敭Id
*/
@TableId(value = "id", type = IdType.AUTO)
- private Long id;
+ private Integer id;
/**
* 鎵�灞濱d
@@ -38,7 +38,7 @@
private Long belongToId;
/**
- * 鍥剧墖璧勬簮绫诲瀷 01-涓婃姤 02-澶勭疆
+ * 鍥剧墖璧勬簮绫诲瀷 01-涓婃姤 02-澶勭疆 03
*/
@TableField("type")
private String type;
diff --git a/ycl-platform/src/main/java/com/ycl/entity/caseHandler/ImageResources.java b/ycl-platform/src/main/java/com/ycl/entity/resources/VideoResources.java
similarity index 73%
copy from ycl-platform/src/main/java/com/ycl/entity/caseHandler/ImageResources.java
copy to ycl-platform/src/main/java/com/ycl/entity/resources/VideoResources.java
index e31a2bc..7d95cc9 100644
--- a/ycl-platform/src/main/java/com/ycl/entity/caseHandler/ImageResources.java
+++ b/ycl-platform/src/main/java/com/ycl/entity/resources/VideoResources.java
@@ -1,4 +1,4 @@
-package com.ycl.entity.caseHandler;
+package com.ycl.entity.resources;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
@@ -15,13 +15,13 @@
*
* </p>
*
- * @author zhanghua
- * @since 2022-10-21
+ * @author lyq
+ * @since 2022-11-08
*/
@Data
@EqualsAndHashCode(callSuper = false)
-@TableName("ums_image_resources")
-public class ImageResources implements Serializable {
+@TableName("ums_video_resources")
+public class VideoResources implements Serializable {
private static final long serialVersionUID = 1L;
@@ -29,22 +29,22 @@
* 涓婚敭Id
*/
@TableId(value = "id", type = IdType.AUTO)
- private Long id;
+ private Integer id;
/**
* 鎵�灞濱d
*/
@TableField("belong_to_id")
- private Long belongToId;
+ private Integer belongToId;
/**
- * 鍥剧墖璧勬簮绫诲瀷 01-涓婃姤 02-澶勭疆
+ * 瑙嗛璧勬簮绫诲瀷 01-瑙嗛涓婁紶 02-鍗曞叺
*/
@TableField("type")
private String type;
/**
- * 鍥剧墖璺緞
+ * 瑙嗛璺緞
*/
@TableField("url")
private String url;
@@ -53,7 +53,7 @@
* 鍒涘缓浜�
*/
@TableField("create_user")
- private Long createUser;
+ private Integer createUser;
/**
* 鍒涘缓鏃堕棿
diff --git a/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseImageResourcesMapper.java b/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseImageResourcesMapper.java
index d9251f9..8a41641 100644
--- a/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseImageResourcesMapper.java
+++ b/ycl-platform/src/main/java/com/ycl/mapper/caseHandler/BaseImageResourcesMapper.java
@@ -1,11 +1,11 @@
package com.ycl.mapper.caseHandler;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.ycl.entity.caseHandler.ImageResources;
+import com.ycl.entity.resources.ImageResources;
/**
* <p>
- * Mapper 鎺ュ彛
+ * Mapper 鎺ュ彛
* </p>
*
* @author zhanghua
diff --git a/ycl-platform/src/main/java/com/ycl/mapper/common/ImageResourcesMapper.java b/ycl-platform/src/main/java/com/ycl/mapper/common/ImageResourcesMapper.java
deleted file mode 100644
index 9226758..0000000
--- a/ycl-platform/src/main/java/com/ycl/mapper/common/ImageResourcesMapper.java
+++ /dev/null
@@ -1,15 +0,0 @@
-package com.ycl.mapper.common;
-
-import com.baomidou.mybatisplus.core.mapper.BaseMapper;
-import com.ycl.entity.common.ImageResources;
-
-/**
- * <p>
- * 绫昏鏄�
- * </p>
- *
- * @author mg
- * @since 2022-09-29
- */
-public interface ImageResourcesMapper extends BaseMapper<ImageResources> {
-}
diff --git a/ycl-platform/src/main/java/com/ycl/mapper/resources/ImageResourcesMapper.java b/ycl-platform/src/main/java/com/ycl/mapper/resources/ImageResourcesMapper.java
new file mode 100644
index 0000000..f4a2c15
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/mapper/resources/ImageResourcesMapper.java
@@ -0,0 +1,19 @@
+package com.ycl.mapper.resources;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ycl.entity.resources.ImageResources;
+import com.ycl.vo.resources.MediaVO;
+
+/**
+ * <p>
+ * Mapper 鎺ュ彛
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+public interface ImageResourcesMapper extends BaseMapper<ImageResources> {
+
+ Page<MediaVO> selectImagePage(Page<MediaVO> imagesVOPage, Integer type, String startTime, String endTime);
+}
diff --git a/ycl-platform/src/main/java/com/ycl/mapper/resources/VideoResourcesMapper.java b/ycl-platform/src/main/java/com/ycl/mapper/resources/VideoResourcesMapper.java
new file mode 100644
index 0000000..fb242c2
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/mapper/resources/VideoResourcesMapper.java
@@ -0,0 +1,19 @@
+package com.ycl.mapper.resources;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.ycl.entity.resources.VideoResources;
+import com.ycl.vo.resources.MediaVO;
+
+/**
+ * <p>
+ * Mapper 鎺ュ彛
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+public interface VideoResourcesMapper extends BaseMapper<VideoResources> {
+
+ Page<MediaVO> selectImagePage(Page<MediaVO> mediaVOPage, Integer type, String startTime, String endTime);
+}
diff --git a/ycl-platform/src/main/java/com/ycl/service/caseHandler/IImageResourcesService.java b/ycl-platform/src/main/java/com/ycl/service/caseHandler/IImageResourcesService.java
deleted file mode 100644
index 4a0e462..0000000
--- a/ycl-platform/src/main/java/com/ycl/service/caseHandler/IImageResourcesService.java
+++ /dev/null
@@ -1,16 +0,0 @@
-package com.ycl.service.caseHandler;
-
-import com.baomidou.mybatisplus.extension.service.IService;
-import com.ycl.entity.caseHandler.ImageResources;
-
-/**
- * <p>
- * 鏈嶅姟绫�
- * </p>
- *
- * @author zhanghua
- * @since 2022-10-21
- */
-public interface IImageResourcesService extends IService<ImageResources> {
-
-}
diff --git a/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java
index 081416e..7d3c506 100644
--- a/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java
+++ b/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/BaseCaseServiceImpl.java
@@ -14,13 +14,13 @@
import com.ycl.dto.casePool.IllegalBuildingParam;
import com.ycl.dto.casePool.ViolationParam;
import com.ycl.entity.caseHandler.*;
-import com.ycl.entity.common.ImageResources;
import com.ycl.entity.dict.DataDictionary;
+import com.ycl.entity.resources.ImageResources;
import com.ycl.entity.video.VideoAlarmReport;
import com.ycl.exception.ApiException;
import com.ycl.mapper.caseHandler.*;
-import com.ycl.mapper.common.ImageResourcesMapper;
import com.ycl.mapper.dict.DataDictionaryMapper;
+import com.ycl.mapper.resources.ImageResourcesMapper;
import com.ycl.remote.dto.*;
import com.ycl.remote.service.CityPlatformService;
import com.ycl.service.caseHandler.IBaseCaseService;
@@ -287,7 +287,7 @@
//3.鏌ヨ妗堝嵎鍥剧墖淇℃伅
FilesPictureVo filesPictureVo = new FilesPictureVo();
QueryWrapper<ImageResources> wrapperIr = new QueryWrapper<>();
- wrapperIr.lambda().eq(ImageResources::getBelongToId,baseCase.getId());
+ wrapperIr.lambda().eq(ImageResources::getBelongToId, baseCase.getId());
List<ImageResources> irs = imageResourcesMapper.selectList(wrapperIr);
filesPictureVo.setImageResources(irs);
bcd.setFilesPictureVo(filesPictureVo);
@@ -377,6 +377,6 @@
@Override
public List<BaseCase> selectPage(Page<BaseCase> page, String number, Integer communityId, Integer categories, String startTime, String endTime, String site) {
- return baseCaseMapper.selectBaseCasePage(page,number,communityId,categories,startTime,endTime,site);
+ return baseCaseMapper.selectBaseCasePage(page, number, communityId, categories, startTime, endTime, site);
}
}
\ No newline at end of file
diff --git a/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/DisposeRecordServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/DisposeRecordServiceImpl.java
index ac64166..540786d 100644
--- a/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/DisposeRecordServiceImpl.java
+++ b/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/DisposeRecordServiceImpl.java
@@ -9,11 +9,13 @@
import com.ycl.common.constant.StepName;
import com.ycl.dto.dispatch.UploadDisposingResultParam;
import com.ycl.entity.caseHandler.*;
+import com.ycl.entity.resources.ImageResources;
import com.ycl.exception.ApiException;
import com.ycl.mapper.caseHandler.BaseCaseMapper;
import com.ycl.mapper.caseHandler.DisposeRecordMapper;
import com.ycl.mapper.caseHandler.WorkflowConfigStepMapper;
import com.ycl.service.caseHandler.*;
+import com.ycl.service.resources.IImageResourcesService;
import com.ycl.vo.MyBacklogVO;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.BeanUtils;
diff --git a/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/ImageResourcesServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/ImageResourcesServiceImpl.java
deleted file mode 100644
index f15457a..0000000
--- a/ycl-platform/src/main/java/com/ycl/service/caseHandler/impl/ImageResourcesServiceImpl.java
+++ /dev/null
@@ -1,20 +0,0 @@
-package com.ycl.service.caseHandler.impl;
-
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.ycl.entity.caseHandler.ImageResources;
-import com.ycl.mapper.caseHandler.BaseImageResourcesMapper;
-import com.ycl.service.caseHandler.IImageResourcesService;
-import org.springframework.stereotype.Service;
-
-/**
- * <p>
- * 鏈嶅姟瀹炵幇绫�
- * </p>
- *
- * @author zhanghua
- * @since 2022-10-21
- */
-@Service
-public class ImageResourcesServiceImpl extends ServiceImpl<BaseImageResourcesMapper, ImageResources> implements IImageResourcesService {
-
-}
diff --git a/ycl-platform/src/main/java/com/ycl/service/resources/IImageResourcesService.java b/ycl-platform/src/main/java/com/ycl/service/resources/IImageResourcesService.java
new file mode 100644
index 0000000..a138bc9
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/service/resources/IImageResourcesService.java
@@ -0,0 +1,19 @@
+package com.ycl.service.resources;
+
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ycl.entity.resources.ImageResources;
+import com.ycl.vo.resources.MediaVO;
+
+/**
+ * <p>
+ * 鏈嶅姟绫�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+public interface IImageResourcesService extends IService<ImageResources> {
+
+ Page<MediaVO> selectImages(Integer type, String startTime, String endTime, Long size, Long current);
+}
diff --git a/ycl-platform/src/main/java/com/ycl/service/resources/IVideoResourcesService.java b/ycl-platform/src/main/java/com/ycl/service/resources/IVideoResourcesService.java
new file mode 100644
index 0000000..f9d1ce5
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/service/resources/IVideoResourcesService.java
@@ -0,0 +1,19 @@
+package com.ycl.service.resources;
+
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.IService;
+import com.ycl.entity.resources.VideoResources;
+import com.ycl.vo.resources.MediaVO;
+
+/**
+ * <p>
+ * 鏈嶅姟绫�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+public interface IVideoResourcesService extends IService<VideoResources> {
+
+ Page<MediaVO> selectImages(Integer type, String startTime, String endTime, Long size, Long current);
+}
diff --git a/ycl-platform/src/main/java/com/ycl/service/resources/impl/ImageResourcesServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/resources/impl/ImageResourcesServiceImpl.java
new file mode 100644
index 0000000..1e06397
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/service/resources/impl/ImageResourcesServiceImpl.java
@@ -0,0 +1,35 @@
+package com.ycl.service.resources.impl;
+
+
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ycl.entity.resources.ImageResources;
+import com.ycl.mapper.resources.ImageResourcesMapper;
+import com.ycl.service.resources.IImageResourcesService;
+import com.ycl.vo.resources.MediaVO;
+import org.springframework.stereotype.Service;
+
+import javax.annotation.Resource;
+
+/**
+ * <p>
+ * 鏈嶅姟瀹炵幇绫�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+@Service
+public class ImageResourcesServiceImpl extends ServiceImpl<ImageResourcesMapper, ImageResources> implements IImageResourcesService {
+
+ @Resource
+ ImageResourcesMapper imageResourcesMapper;
+
+ @Override
+ public Page<MediaVO> selectImages(Integer type, String startTime, String endTime, Long size, Long current) {
+ Page<MediaVO> imagesVOPage = new Page<>();
+ imagesVOPage.setCurrent(current);
+ imagesVOPage.setSize(size);
+ return imageResourcesMapper.selectImagePage(imagesVOPage,type,startTime,endTime);
+ }
+}
diff --git a/ycl-platform/src/main/java/com/ycl/service/resources/impl/VideoResourcesServiceImpl.java b/ycl-platform/src/main/java/com/ycl/service/resources/impl/VideoResourcesServiceImpl.java
new file mode 100644
index 0000000..2a74441
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/service/resources/impl/VideoResourcesServiceImpl.java
@@ -0,0 +1,35 @@
+package com.ycl.service.resources.impl;
+
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ycl.entity.resources.VideoResources;
+import com.ycl.mapper.resources.VideoResourcesMapper;
+import com.ycl.service.resources.IVideoResourcesService;
+import com.ycl.vo.resources.MediaVO;
+import org.springframework.stereotype.Service;
+
+import javax.annotation.Resource;
+
+/**
+ * <p>
+ * 鏈嶅姟瀹炵幇绫�
+ * </p>
+ *
+ * @author lyq
+ * @since 2022-11-08
+ */
+@Service
+public class VideoResourcesServiceImpl extends ServiceImpl<VideoResourcesMapper, VideoResources> implements IVideoResourcesService {
+
+
+ @Resource
+ VideoResourcesMapper videoResourcesMapper;
+
+ @Override
+ public Page<MediaVO> selectImages(Integer type, String startTime, String endTime, Long size, Long current) {
+ Page<MediaVO> mediaVOPage = new Page<>();
+ mediaVOPage.setCurrent(current);
+ mediaVOPage.setSize(size);
+ return videoResourcesMapper.selectImagePage(mediaVOPage,type,startTime,endTime);
+ }
+}
diff --git a/ycl-platform/src/main/java/com/ycl/vo/casePool/FilesPictureVo.java b/ycl-platform/src/main/java/com/ycl/vo/casePool/FilesPictureVo.java
index 2301d09..4630f46 100644
--- a/ycl-platform/src/main/java/com/ycl/vo/casePool/FilesPictureVo.java
+++ b/ycl-platform/src/main/java/com/ycl/vo/casePool/FilesPictureVo.java
@@ -1,6 +1,6 @@
package com.ycl.vo.casePool;
-import com.ycl.entity.common.ImageResources;
+import com.ycl.entity.resources.ImageResources;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
@@ -9,7 +9,7 @@
/**
* <p>
- * 妗堝嵎鍥剧墖 绫�
+ * 妗堝嵎鍥剧墖 绫�
* </p>
*
* @author mg
diff --git a/ycl-platform/src/main/java/com/ycl/vo/resources/MediaVO.java b/ycl-platform/src/main/java/com/ycl/vo/resources/MediaVO.java
new file mode 100644
index 0000000..756f7eb
--- /dev/null
+++ b/ycl-platform/src/main/java/com/ycl/vo/resources/MediaVO.java
@@ -0,0 +1,35 @@
+package com.ycl.vo.resources;
+
+import com.fasterxml.jackson.annotation.JsonFormat;
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+
+@ApiModel
+@Data
+public class MediaVO {
+
+ @ApiModelProperty(name = "浜嬩欢鏉ユ簮(1-瑙嗛 2-鎵嬪姩鐧昏)")
+ private Integer category;
+
+ @ApiModelProperty(name = "闂绫诲埆锛�1-杩濊 2-杩濆缓锛�")
+ private Integer eventSource;
+
+ @ApiModelProperty(name = "id")
+ private Integer id;
+
+ @ApiModelProperty(name = "妗堜欢id")
+ private Long baseId;
+
+ @ApiModelProperty(name = "绀惧尯")
+ private String regionName;
+
+ @ApiModelProperty(name = "url")
+ private String url;
+
+ @ApiModelProperty(name = "涓婁紶鏃堕棿")
+ @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT")
+ private LocalDateTime createTime;
+}
diff --git a/ycl-platform/src/main/resources/mapper/caseHandler/BaseImageResourcesMapper.xml b/ycl-platform/src/main/resources/mapper/caseHandler/BaseImageResourcesMapper.xml
deleted file mode 100644
index ce8cf38..0000000
--- a/ycl-platform/src/main/resources/mapper/caseHandler/BaseImageResourcesMapper.xml
+++ /dev/null
@@ -1,20 +0,0 @@
-<?xml version="1.0" encoding="UTF-8"?>
-<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
-<mapper namespace="com.ycl.mapper.caseHandler.BaseImageResourcesMapper">
-
- <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
- <resultMap id="BaseResultMap" type="com.ycl.entity.caseHandler.ImageResources">
- <id column="id" property="id" />
- <result column="belong_to_id" property="belongToId" />
- <result column="type" property="type" />
- <result column="url" property="url" />
- <result column="create_user" property="createUser" />
- <result column="create_time" property="createTime" />
- </resultMap>
-
- <!-- 閫氱敤鏌ヨ缁撴灉鍒� -->
- <sql id="Base_Column_List">
- id, belong_to_id, type, url, create_user, create_time
- </sql>
-
-</mapper>
diff --git a/ycl-platform/src/main/resources/mapper/resources/ImageResourcesMapper.xml b/ycl-platform/src/main/resources/mapper/resources/ImageResourcesMapper.xml
new file mode 100644
index 0000000..8eba162
--- /dev/null
+++ b/ycl-platform/src/main/resources/mapper/resources/ImageResourcesMapper.xml
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ycl.mapper.resources.ImageResourcesMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="com.ycl.entity.resources.ImageResources">
+ <id column="id" property="id"/>
+ <result column="belong_to_id" property="belongToId"/>
+ <result column="type" property="type"/>
+ <result column="url" property="url"/>
+ <result column="create_user" property="createUser"/>
+ <result column="create_time" property="createTime"/>
+ </resultMap>
+
+ <!-- 閫氱敤鏌ヨ缁撴灉鍒� -->
+ <sql id="Base_Column_List">
+ id
+ , belong_to_id, type, url, create_user, create_time
+ </sql>
+ <select id="selectImagePage" resultType="com.ycl.vo.resources.MediaVO">
+ SELECT
+ t2.category,
+ t2.event_source,
+ t2.id as baseId,
+ t1.id,
+ t3.region_name,
+ t1.create_time,
+ t1.url
+ FROM
+ ums_image_resources t1
+ LEFT JOIN ums_base_case t2 ON t1.belong_to_id = t2.id
+ LEFT JOIN ums_sccg_region t3 on t3.id=t2.community_id
+ <where>
+ <if test="type != '' and type != null">
+ t1.type=#{type}
+ </if>
+ <if test="startTime != '' and endTime != '' and startTime != null and endTime != null">
+ and t1.create_time between #{startTime} and #{endTime}
+ </if>
+ </where>
+ </select>
+</mapper>
diff --git a/ycl-platform/src/main/resources/mapper/resources/VideoResourcesMapper.xml b/ycl-platform/src/main/resources/mapper/resources/VideoResourcesMapper.xml
new file mode 100644
index 0000000..71aa120
--- /dev/null
+++ b/ycl-platform/src/main/resources/mapper/resources/VideoResourcesMapper.xml
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
+<mapper namespace="com.ycl.mapper.resources.VideoResourcesMapper">
+
+ <!-- 閫氱敤鏌ヨ鏄犲皠缁撴灉 -->
+ <resultMap id="BaseResultMap" type="com.ycl.entity.resources.VideoResources">
+ <id column="id" property="id" />
+ <result column="belong_to_id" property="belongToId" />
+ <result column="type" property="type" />
+ <result column="url" property="url" />
+ <result column="create_user" property="createUser" />
+ <result column="create_time" property="createTime" />
+ </resultMap>
+
+ <!-- 閫氱敤鏌ヨ缁撴灉鍒� -->
+ <sql id="Base_Column_List">
+ id, belong_to_id, type, url, create_user, create_time
+ </sql>
+
+ <select id="selectImagePage" resultType="com.ycl.vo.resources.MediaVO">
+ SELECT
+ t2.category,
+ t2.event_source,
+ t2.id as baseId,
+ t1.id,
+ t3.region_name,
+ t1.create_time,
+ t1.url
+ FROM
+ ums_video_resources t1
+ LEFT JOIN ums_base_case t2 ON t1.belong_to_id = t2.id
+ LEFT JOIN ums_sccg_region t3 on t3.id=t2.community_id
+ <where>
+ <if test="type != '' and type != null">
+ t1.type=#{type}
+ </if>
+ <if test="startTime != '' and endTime != '' and startTime != null and endTime != null">
+ and t1.create_time between #{startTime} and #{endTime}
+ </if>
+ </where>
+ </select>
+</mapper>
--
Gitblit v1.8.0