| | |
| | | private Date createTime; |
| | | |
| | | private String base64Img; |
| | | private String imgName; |
| | | |
| | | } |
| | |
| | | |
| | | |
| | | import com.ld.igds.phone35.dto.*; |
| | | import com.ld.igds.phone35.param.Phone35CommonParam; |
| | | import com.ld.igds.phone35.param.Phone35DepotCommonParam; |
| | | import com.ld.igds.phone35.param.Phone35PatrolCommonParam; |
| | | import com.ld.igds.phone35.param.Phone35WarnCommonParam; |
| | | import com.ld.igds.phone35.param.*; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | |
| | | List<DtoPatrol> getPatrol(@Param("param") Phone35PatrolCommonParam param); |
| | | |
| | | /** |
| | | * çµåæå¡ |
| | | * |
| | | * @param param |
| | | */ |
| | | void addPatrolRecord(@Param("param") Phone35PatrolCommonParam param); |
| | | |
| | | /** |
| | | * çæ§è®¾å¤å表 |
| | | * |
| | | * @param param |
| | | * @return |
| | | */ |
| | | List<DtoVideo> getCamera(@Param("param") Phone35CommonParam param); |
| | | List<DtoVideo> getCamera(@Param("param") Phone35VideoCommonParam param); |
| | | } |
| | |
| | | @Data |
| | | public class Phone35PatrolCommonParam extends Phone35CommonParam { |
| | | |
| | | private String id; |
| | | private String longitude; |
| | | private String latitude; |
| | | private String imgName; |
| | | private Date createTime; |
| | | private String userName; |
| | | |
| | | |
| | | private String dateTime; |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | package com.ld.igds.phone35.param; |
| | | |
| | | import lombok.Data; |
| | | |
| | | /** |
| | | * @Author:YAN |
| | | */ |
| | | @Data |
| | | public class Phone35VideoCommonParam extends Phone35CommonParam { |
| | | private String id; |
| | | private String playType; |
| | | } |
| | |
| | | package com.ld.igds.phone35.service.impl; |
| | | |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.ld.igds.constant.RespCodeEnum; |
| | | import com.ld.igds.phone35.constant.Phone35Constant; |
| | | import com.ld.igds.phone35.dto.Phone35AuthUser; |
| | | import com.ld.igds.phone35.dto.PhoneResponse; |
| | | import com.ld.igds.phone35.mapper.Phone35Mapper; |
| | | import com.ld.igds.phone35.param.Phone35PatrolCommonParam; |
| | | import com.ld.igds.phone35.param.Phone35Request; |
| | | import com.ld.igds.phone35.service.Phone35Service; |
| | | import com.ld.igds.phone35.util.PhoneRespUtil; |
| | | import com.ld.igds.util.ContextUtil; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.Date; |
| | | |
| | | /** |
| | | * çµåå·¡æ´æå¡ |
| | |
| | | */ |
| | | @Service |
| | | public class Phone35ServiceImpl5602 implements Phone35Service { |
| | | @Autowired |
| | | private Phone35Mapper phone35Mapper; |
| | | |
| | | @Override |
| | | public String getInterfaceId() { |
| | | return Phone35Constant.API_PHONE_5602; |
| | |
| | | |
| | | @Override |
| | | public PhoneResponse<Object> execute(Phone35Request<JSONObject> req, Phone35AuthUser phone35AuthUser) throws Exception { |
| | | return null; |
| | | //转å对象 |
| | | Phone35PatrolCommonParam param = JSONObject.parseObject(req.getData().toString(), Phone35PatrolCommonParam.class); |
| | | if (null == param) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | | //åæ°éªè¯ |
| | | if (StringUtils.isEmpty(param.getDeptId())) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | | //åæ°éªè¯ |
| | | if (StringUtils.isEmpty(param.getLongitude())) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | | //åæ°éªè¯ |
| | | if (StringUtils.isEmpty(param.getLatitude())) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | | //åæ°éªè¯ |
| | | if (StringUtils.isEmpty(param.getUserName())) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | | |
| | | param.setCreateTime(new Date()); |
| | | param.setId(ContextUtil.getUUID()); |
| | | param.setCompanyId(phone35AuthUser.getCompanyId()); |
| | | phone35Mapper.addPatrolRecord(param); |
| | | return PhoneRespUtil.success(null, req); |
| | | } |
| | | } |
| | |
| | | package com.ld.igds.phone35.service.impl; |
| | | |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.ld.igds.constant.RespCodeEnum; |
| | | import com.ld.igds.file.CoreFileService; |
| | | import com.ld.igds.phone35.constant.Phone35Constant; |
| | | import com.ld.igds.phone35.dto.DtoPatrol; |
| | | import com.ld.igds.phone35.dto.Phone35AuthUser; |
| | | import com.ld.igds.phone35.dto.PhoneResponse; |
| | | import com.ld.igds.phone35.mapper.Phone35Mapper; |
| | | import com.ld.igds.phone35.param.Phone35PatrolCommonParam; |
| | | import com.ld.igds.phone35.param.Phone35Request; |
| | | import com.ld.igds.phone35.service.Phone35Service; |
| | | import com.ld.igds.phone35.util.PhoneRespUtil; |
| | | import com.ld.igds.util.FfmpegUtil; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * å·¡æ´ç
§çæ¥ç |
| | |
| | | */ |
| | | @Service |
| | | public class Phone35ServiceImpl5603 implements Phone35Service { |
| | | |
| | | @Autowired |
| | | private Phone35Mapper phone35Mapper; |
| | | @Autowired |
| | | private CoreFileService fileService; |
| | | |
| | | @Override |
| | | public String getInterfaceId() { |
| | | return Phone35Constant.API_PHONE_5603; |
| | |
| | | |
| | | @Override |
| | | public PhoneResponse<Object> execute(Phone35Request<JSONObject> req, Phone35AuthUser phone35AuthUser) throws Exception { |
| | | return null; |
| | | //转å对象 |
| | | Phone35PatrolCommonParam param = JSONObject.parseObject(req.getData().toString(), Phone35PatrolCommonParam.class); |
| | | if (null == param) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | | //åæ°éªè¯ |
| | | if (StringUtils.isEmpty(param.getId())) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | | param.setCompanyId(phone35AuthUser.getCompanyId()); |
| | | List<DtoPatrol> list = phone35Mapper.getPatrol(param); |
| | | DtoPatrol patrol = list.get(0); |
| | | if (StringUtils.isNotEmpty(patrol.getImgName())) { |
| | | String bathPath = fileService.getInoutFilePath(patrol.getCreateTime()); |
| | | String imgData = FfmpegUtil.getImgStr(bathPath + patrol.getImgName()); |
| | | patrol.setBase64Img(imgData); |
| | | } |
| | | return PhoneRespUtil.success(patrol, req); |
| | | } |
| | | } |
| | |
| | | import com.ld.igds.phone35.param.Phone35CommonParam; |
| | | import com.ld.igds.phone35.param.Phone35DepotCommonParam; |
| | | import com.ld.igds.phone35.param.Phone35Request; |
| | | import com.ld.igds.phone35.param.Phone35VideoCommonParam; |
| | | import com.ld.igds.phone35.service.Phone35Service; |
| | | import com.ld.igds.phone35.util.PhoneRespUtil; |
| | | import org.apache.commons.lang3.StringUtils; |
| | |
| | | public PhoneResponse<Object> execute(Phone35Request<JSONObject> req, Phone35AuthUser phone35AuthUser) throws Exception { |
| | | |
| | | //转å对象 |
| | | Phone35CommonParam param = JSONObject.parseObject(req.getData().toString(), Phone35CommonParam.class); |
| | | Phone35VideoCommonParam param = JSONObject.parseObject(req.getData().toString(), Phone35VideoCommonParam.class); |
| | | if (null == param) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | |
| | | package com.ld.igds.phone35.service.impl; |
| | | |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.ld.igds.camera.CameraUtil; |
| | | import com.ld.igds.constant.RespCodeEnum; |
| | | import com.ld.igds.phone35.constant.Phone35Constant; |
| | | import com.ld.igds.phone35.dto.Phone35AuthUser; |
| | | import com.ld.igds.phone35.dto.PhoneResponse; |
| | | import com.ld.igds.phone35.param.Phone35Request; |
| | | import com.ld.igds.phone35.param.Phone35VideoCommonParam; |
| | | import com.ld.igds.phone35.service.Phone35Service; |
| | | import com.ld.igds.phone35.util.PhoneRespUtil; |
| | | import com.ld.igds.sec.dto.SecCameraDto; |
| | | import com.ld.igds.sec.manager.SecManager; |
| | | import org.apache.commons.lang3.StringUtils; |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Service |
| | | public class Phone35ServiceImpl5605 implements Phone35Service { |
| | | @Autowired |
| | | private SecManager securityManager; |
| | | |
| | | @Override |
| | | public String getInterfaceId() { |
| | | return Phone35Constant.API_PHONE_5605; |
| | |
| | | |
| | | @Override |
| | | public PhoneResponse<Object> execute(Phone35Request<JSONObject> req, Phone35AuthUser phone35AuthUser) throws Exception { |
| | | return null; |
| | | //转å对象 |
| | | Phone35VideoCommonParam param = JSONObject.parseObject(req.getData().toString(), Phone35VideoCommonParam.class); |
| | | if (null == param) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | | //åæ°éªè¯ |
| | | if (StringUtils.isEmpty(param.getId())) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1111, "åæ°æè¯¯ï¼è¯·éè¯ï¼ï¼"); |
| | | } |
| | | //åæ°éªè¯ |
| | | if (CameraUtil.PLAY_TYPE_DEFAULT.equals(param.getPlayType())) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1007, "ç³»ç»æªé
ç½®å½åæåå¤´ææ¾æ¹å¼ï¼ä¸æ§è¡é¢è§"); |
| | | } |
| | | |
| | | SecCameraDto cameraParam = new SecCameraDto(); |
| | | cameraParam.setId(param.getId()); |
| | | cameraParam.setCompanyId(phone35AuthUser.getCompanyId()); |
| | | cameraParam.setCompanyId(phone35AuthUser.getCompanyId()); |
| | | SecCameraDto camera = securityManager.getPlayAddr(cameraParam); |
| | | |
| | | if (camera == null) { |
| | | return PhoneRespUtil.error(RespCodeEnum.CODE_1007, "æªæ¥è¯¢å°ç¸å
³è®¾å¤ï¼"); |
| | | } |
| | | |
| | | |
| | | return PhoneRespUtil.success(camera, req); |
| | | } |
| | | } |
| | |
| | | UPDATE_TIME_ AS updateTime |
| | | FROM D_ENERGY |
| | | <where> |
| | | <if test="param.companyId != null">AND COMPANY_ID_ = #{param.companyId}</if> |
| | | <if test="param.companyId != null and param.companyId != ''">AND COMPANY_ID_ = #{param.companyId}</if> |
| | | <if test="param.startTime != null and param.endTime != null">AND UPDATE_TIME_ between #{param.startTime} |
| | | and |
| | | #{param.endTime} |
| | |
| | | UPDATE_TIME_ AS updateTime |
| | | FROM D_ENERGY |
| | | <where> |
| | | <if test="param.companyId != null">AND COMPANY_ID_ = #{param.companyId}</if> |
| | | <if test="param.companyId != null and param.companyId != ''">AND COMPANY_ID_ = #{param.companyId}</if> |
| | | <if test="param.depotId != null and param.depotId != ''">AND DEPOT_ID_ = #{param.depotId}</if> |
| | | <if test="param.startTime != null">AND |
| | | UPDATE_TIME_ <![CDATA[ > ]]>#{param.startTime,jdbcType=TIMESTAMP} |
| | |
| | | USER_NAME_ AS userName, |
| | | LONGITUDE_ As longitude, |
| | | LATITUDE_ AS latitude, |
| | | IMG_NAME_ AS base64Img, |
| | | IMG_NAME_ AS imgName, |
| | | CREATE_TIME_ AS createTime |
| | | FROM D_SEC_PATROL_RECORD |
| | | <where> |
| | | <if test="param.companyId != null and companyId != ''">AND COMPANY_ID_ = #{param.companyId}</if> |
| | | <if test="param.id != null and param.id != ''">AND ID_ = #{param.id}</if> |
| | | <if test="param.companyId != null and param.companyId != ''">AND COMPANY_ID_ = #{param.companyId}</if> |
| | | <if test="param.deptId != null and param.deptId != ''">AND DEPT_ID_ = #{param.deptId}</if> |
| | | <if test="param.startTime != null and param.endTime != null">AND CREATE_TIME_ between #{param.startTime} |
| | | and #{param.endTime} |
| | | </if> |
| | | </where> |
| | | </select> |
| | | |
| | | <insert id="addPatrolRecord"> |
| | | INSERT INTO D_SEC_PATROL_RECORD |
| | | (ID_, |
| | | COMPANY_ID_, |
| | | DEPT_ID_, |
| | | USER_NAME_, |
| | | CREATE_TIME_, |
| | | LONGITUDE_, |
| | | LATITUDE_, |
| | | IMG_NAME_) |
| | | VALUES (#{param.id}, |
| | | #{param.companyId}, |
| | | #{param.deptId}, |
| | | #{param.userName}, |
| | | #{param.createTime}, |
| | | #{param.longitude}, |
| | | #{param.latitude}, |
| | | #{param.imgName}) |
| | | </insert> |
| | | <!-- çæ§è®¾å¤å表--> |
| | | <select id="getCamera" resultType="com.ld.igds.phone35.dto.DtoVideo"> |
| | | |