CameraServiceImpl.java 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374
  1. package com.fdkankan.manage.service.impl;
  2. import com.alibaba.nacos.shaded.org.checkerframework.checker.units.qual.A;
  3. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  4. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  5. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  6. import com.fdkankan.common.constant.Constant;
  7. import com.fdkankan.common.constant.ErrorCode;
  8. import com.fdkankan.common.exception.BusinessException;
  9. import com.fdkankan.common.response.PageInfo;
  10. import com.fdkankan.common.util.DateUtil;
  11. import com.fdkankan.manage.common.CameraTypeEnum;
  12. import com.fdkankan.manage.constant.CameraConstant;
  13. import com.fdkankan.manage.entity.Camera;
  14. import com.fdkankan.manage.entity.CameraDetail;
  15. import com.fdkankan.manage.entity.Company;
  16. import com.fdkankan.manage.mapper.ICameraMapper;
  17. import com.fdkankan.manage.service.*;
  18. import com.fdkankan.manage.util.Dateutils;
  19. import com.fdkankan.manage.vo.request.CameraInOutParam;
  20. import com.fdkankan.manage.vo.request.CameraParam;
  21. import com.fdkankan.manage.vo.response.CameraDetailVo;
  22. import org.apache.commons.lang3.StringUtils;
  23. import org.springframework.beans.factory.annotation.Autowired;
  24. import org.springframework.beans.factory.annotation.Value;
  25. import org.springframework.stereotype.Service;
  26. import java.util.*;
  27. import java.util.stream.Collectors;
  28. /**
  29. * <p>
  30. * 相机主表 服务实现类
  31. * </p>
  32. *
  33. * @author
  34. * @since 2022-06-16
  35. */
  36. @Service
  37. public class CameraServiceImpl extends ServiceImpl<ICameraMapper, Camera> implements ICameraService {
  38. @Autowired
  39. ICameraDetailService cameraDetailService;
  40. @Autowired
  41. ISceneService sceneService;
  42. @Autowired
  43. ISceneProService sceneProService;
  44. @Autowired
  45. IUserIncrementService userIncrementService;
  46. @Autowired
  47. ISceneResourceCameraService sceneResourceCameraService;
  48. @Autowired
  49. IScenePlusService scenePlusService;
  50. @Autowired
  51. ICompanyService companyService;
  52. @Value("${upload.type}")
  53. private String ossType;
  54. @Override
  55. public List<Camera> getListByCameraIdList(List<Long> cameraIdList) {
  56. LambdaQueryWrapper<Camera> wrapper = new LambdaQueryWrapper<>();
  57. wrapper.in(Camera::getId,cameraIdList);
  58. return this.list(wrapper);
  59. }
  60. @Override
  61. public Camera getBySnCode(String snCode) {
  62. LambdaQueryWrapper<Camera> wrapper = new LambdaQueryWrapper<>();
  63. wrapper.eq(Camera::getSnCode,snCode);
  64. List<Camera> list = this.list(wrapper);
  65. if(list == null || list.size() <=0 ){
  66. return null;
  67. }
  68. return list.get(0);
  69. }
  70. private List<Camera> getBySnCodes(List<String> snCodeList) {
  71. LambdaQueryWrapper<Camera> wrapper = new LambdaQueryWrapper<>();
  72. wrapper.in(Camera::getSnCode,snCodeList);
  73. return this.list(wrapper);
  74. }
  75. @Override
  76. public void unbindCamera(Long cameraId) {
  77. cameraDetailService.unbindCamera(cameraId); //取消相机用户关联
  78. userIncrementService.unbindCamera(cameraId); //取消关联用户权益
  79. sceneService.unbindCamera(cameraId); //取消关联场景
  80. sceneProService.unbindCamera(cameraId); //取消关联场景
  81. scenePlusService.unbindCamera(cameraId); //取消关联场景
  82. sceneResourceCameraService.unbindCamera(cameraId); //删除协作相机
  83. }
  84. @Override
  85. public PageInfo pageList(CameraParam param) {
  86. Page<CameraDetailVo> voPage = this.getBaseMapper().pageList(new Page<>(param.getPageNum(),param.getPageSize()),param);
  87. return PageInfo.PageInfo(voPage);
  88. }
  89. @Override
  90. public void in(String wifiName) {
  91. if(StringUtils.isEmpty(wifiName) ){
  92. throw new BusinessException(ErrorCode.MISSING_REQUIRED_PARAMETERS);
  93. }
  94. if( !wifiName.contains("_") || !wifiName.contains("4D")){
  95. throw new BusinessException(-1,"wifi名称格式错误");
  96. }
  97. LambdaQueryWrapper<Camera> wrapper = new LambdaQueryWrapper<>();
  98. wrapper.eq(Camera::getWifiName,wifiName);
  99. long count = this.count(wrapper);
  100. if(count > 0){
  101. throw new BusinessException(-1,"设备wifi名称重复");
  102. }
  103. saveBatchCamera(Collections.singletonList(wifiName));
  104. }
  105. private Integer saveBatchCamera(List<String> wifiNameList){
  106. HashSet<String> wifiNameSet = new HashSet<>(wifiNameList);
  107. List<Camera> cameraList = new ArrayList<>();
  108. for (String wifiName : wifiNameSet) {
  109. String[] res = wifiName.split("_");
  110. Camera camera = new Camera();
  111. camera.setWifiName(wifiName);
  112. camera.setSnCode(res[1]);
  113. camera.setChildName(res[1]);
  114. camera.setWifiPassword(CameraConstant.WIFI_PASSWORD_VALUE);
  115. camera.setChildPassword(CameraConstant.CHILD_PASSWORD_VALUE);
  116. camera.setActivatedTime(DateUtil.date2String(new Date(),DateUtil.DEFAULT_DATE_FORMAT));
  117. cameraList.add(camera);
  118. }
  119. this.saveBatch(cameraList);
  120. List<CameraDetail> cameraDetailList = new ArrayList<>();
  121. for (Camera camera : cameraList) {
  122. String wifiName = camera.getWifiName();
  123. Integer type = CameraTypeEnum.getTypeByWifiNamePrefix(wifiName.substring(0,wifiName.lastIndexOf("_") +1));
  124. if(type == null){
  125. throw new BusinessException(-1,"wifi名称前缀错误!");
  126. }
  127. CameraDetail cameraDetail = new CameraDetail();
  128. cameraDetail.setAgency(CameraConstant.DEFAULT_AGENT);
  129. cameraDetail.setCameraId(camera.getId());
  130. cameraDetail.setCountry(0);//默认中国
  131. if("aws".equals(ossType)){
  132. cameraDetail.setCountry(1);//1-国外
  133. }
  134. cameraDetail.setType(type);
  135. if (1 == cameraDetail.getType() || 9 == cameraDetail.getType() || 10 == cameraDetail.getType()){
  136. cameraDetail.setTotalSpace(Long.valueOf(Constant.CAMERA_BASE_SPACE_VALUE));
  137. cameraDetail.setUsedSpace(0L);
  138. }
  139. if(type != 9 && type != 10){
  140. type = type == 0 ? 1: 4;
  141. }
  142. cameraDetail.setGoodsId(Long.valueOf(type));
  143. cameraDetailList.add(cameraDetail);
  144. }
  145. return cameraDetailService.saveBatch(cameraDetailList) ? cameraList.size() : 0;
  146. }
  147. @Override
  148. public Integer ins(List<String> wifiNameList){
  149. List<Integer> errorRow = getErrorRow(wifiNameList, null);
  150. getResultIn(errorRow);
  151. LambdaQueryWrapper<Camera> wrapper = new LambdaQueryWrapper<>();
  152. wrapper.in(Camera::getWifiName,wifiNameList);
  153. List<Camera> list = this.list(wrapper);
  154. if(list.size() >0){
  155. List<String> newList = list.parallelStream().map(Camera::getWifiName).collect(Collectors.toList());
  156. List<Integer> errorRow2 = getErrorRow(wifiNameList, newList);
  157. getResultIn(errorRow2);
  158. }
  159. return saveBatchCamera(wifiNameList);
  160. }
  161. private void getResultIn(List<Integer> errorList){
  162. if(errorList.size() <=0){
  163. return;
  164. }
  165. StringBuilder res = new StringBuilder("第");
  166. for (Integer index : errorList) {
  167. res.append(index).append(",");
  168. }
  169. res.deleteCharAt(res.lastIndexOf(","));
  170. res.append("行存在错误");
  171. throw new BusinessException(-1, res.toString());
  172. }
  173. private List<Integer> getErrorRow(List<String> wifiNameList, List<String> newList){
  174. List<Integer> errorIndexList = new ArrayList<>();
  175. boolean bo = false;
  176. if(newList == null){
  177. newList = wifiNameList;
  178. bo = true;
  179. }
  180. for (String wifiName : newList) {
  181. int index = wifiNameList.indexOf(wifiName) + 3;
  182. if(bo){
  183. if( !wifiName.contains("_") || !wifiName.contains("4D")
  184. || !CameraTypeEnum.typePrefixMap.containsKey(wifiName.split("_")[0])){
  185. errorIndexList.add(index);
  186. }
  187. }else {
  188. errorIndexList.add(index);
  189. }
  190. }
  191. return errorIndexList;
  192. }
  193. @Override
  194. public void out(CameraInOutParam param) {
  195. if(param.getOutType() == null || param.getCompanyName() == null || param.getId() == null){
  196. throw new BusinessException(ErrorCode.MISSING_REQUIRED_PARAMETERS);
  197. }
  198. Company company = companyService.getCompanyByName(param.getCompanyName());
  199. if(company == null){
  200. throw new BusinessException(-1,"客户名称不存在");
  201. }
  202. param.setCompanyId(company.getId());
  203. Camera camera = this.getById(param.getId());
  204. if(camera == null){
  205. throw new BusinessException(-1,"相机不存在");
  206. }
  207. CameraDetail detail = cameraDetailService.getByCameraId(camera.getId());
  208. if(detail ==null){
  209. throw new BusinessException(-1,"该相机未入库");
  210. }
  211. HashMap<String,CameraDetail> detailMap = new HashMap<>();
  212. detailMap.put(detail.getCameraId().toString(),detail);
  213. this.saveBatchDetail(detailMap, Collections.singletonList(param));
  214. }
  215. @Override
  216. public Integer outs(List<CameraInOutParam> params){
  217. setCompanyIdByDb(params);
  218. HashMap<String, Object> resultMap = getResultMap(params);
  219. HashMap<String,CameraDetail> detailMap = (HashMap<String, CameraDetail>) resultMap.get("detailMap");
  220. return this.saveBatchDetail(detailMap,params);
  221. }
  222. private Integer saveBatchDetail(HashMap<String, CameraDetail> detailMap, List<CameraInOutParam> params){
  223. List<CameraDetail> cameraDetails = new ArrayList<>();
  224. for (CameraInOutParam param : params) {
  225. CameraDetail cameraDetail = detailMap.get(param.getId().toString());
  226. cameraDetail.setOrderSn(param.getOrderSn());
  227. cameraDetail.setOwn(param.getOutType());
  228. cameraDetail.setCompanyId(param.getCompanyId());
  229. cameraDetail.setOutTime(Dateutils.getDate(new Date()));
  230. cameraDetails.add(cameraDetail);
  231. }
  232. return cameraDetailService.saveOrUpdateBatch(cameraDetails) ? cameraDetails.size() : 0;
  233. }
  234. private void checkSnCode(List<String> snCodeList) {
  235. HashMap<String,Integer> map = new HashMap<>();
  236. for (String snCode : snCodeList) {
  237. if(map.get(snCode) == null){
  238. map.put(snCode,1);
  239. }else {
  240. map.put(snCode,2);
  241. }
  242. }
  243. List<String> errorSnCode = new ArrayList<>();
  244. for (String snCode : map.keySet()) {
  245. if(map.get(snCode) > 1){
  246. errorSnCode.add(snCode);
  247. }
  248. }
  249. if(errorSnCode.size() >0){
  250. throw new BusinessException(-1,"存在重复的snCode:"+errorSnCode);
  251. }
  252. }
  253. @Override
  254. public void updateCamera(CameraInOutParam param) {
  255. if(param.getId() == null|| param.getOutType() == null){
  256. throw new BusinessException(ErrorCode.MISSING_REQUIRED_PARAMETERS);
  257. }
  258. CameraDetail cameraDetail = cameraDetailService.getByCameraId(param.getId());
  259. if(cameraDetail == null){
  260. throw new BusinessException(ErrorCode.MISSING_REQUIRED_PARAMETERS);
  261. }
  262. if(StringUtils.isNotBlank(param.getCompanyName())){
  263. Company company = companyService.getCompanyByName(param.getCompanyName());
  264. if(company !=null){
  265. cameraDetail.setCompanyId(company.getId());
  266. }
  267. }
  268. cameraDetail.setOwn(param.getOutType());
  269. cameraDetail.setOrderSn(param.getOrderSn());
  270. cameraDetailService.updateById(cameraDetail);
  271. }
  272. @Override
  273. public void deleteCamera(Long id) {
  274. if(id == null){
  275. throw new BusinessException(ErrorCode.MISSING_REQUIRED_PARAMETERS);
  276. }
  277. CameraDetail cameraDetail = cameraDetailService.getByCameraId(id);
  278. if(cameraDetail !=null && cameraDetail.getUserId()!=null){
  279. throw new BusinessException(-1,"相机已绑定,请先解绑后删除");
  280. }
  281. this.removeById(id);
  282. cameraDetailService.deleteByCameraId(id);
  283. }
  284. @Override
  285. public Integer updateCompany(List<CameraInOutParam> companyParams) {
  286. setCompanyIdByDb(companyParams);
  287. HashMap<String, Object> resultMap = getResultMap(companyParams);
  288. HashMap<Long, CameraDetail> detailMap = (HashMap<Long, CameraDetail>) resultMap.get("detailMap");
  289. HashMap<String, Camera> snCodeMap = (HashMap<String, Camera>) resultMap.get("snCodeMap");
  290. List<CameraDetail> updateDetailList = new ArrayList<>();
  291. for (CameraInOutParam companyParam : companyParams) {
  292. Camera camera = snCodeMap.get(companyParam.getSnCode());
  293. CameraDetail cameraDetail = detailMap.get(camera.getId());
  294. cameraDetail.setCompanyId(companyParam.getCompanyId());
  295. updateDetailList.add(cameraDetail);
  296. }
  297. return cameraDetailService.updateBatchById(updateDetailList) ? updateDetailList.size() : 0;
  298. }
  299. private void setCompanyIdByDb(List<CameraInOutParam> companyParams){
  300. List<String> companyNames = companyParams.parallelStream().map(CameraInOutParam::getCompanyName).collect(Collectors.toList());
  301. List<Company> companyList = companyService.getCompanyByNames(companyNames);
  302. List<String> dbCompanyNames = companyList.parallelStream().map(Company::getCompanyName).collect(Collectors.toList());
  303. List<Integer> errorRow = this.getErrorRow(companyNames, dbCompanyNames);
  304. getResultIn(errorRow);
  305. HashMap<String,Long> companyNameMap = new HashMap<>();
  306. for (Company company : companyList) {
  307. companyNameMap.put(company.getCompanyName(),company.getId());
  308. }
  309. for (CameraInOutParam companyParam : companyParams) {
  310. companyParam.setCompanyId(companyNameMap.get(companyParam.getCompanyName()));
  311. }
  312. }
  313. private HashMap<String, Object> getResultMap(List<CameraInOutParam> params){
  314. HashMap<String,Object> resultMap = new HashMap<>();
  315. List<String> snCodeList = params.parallelStream().map(CameraInOutParam::getSnCode).collect(Collectors.toList());
  316. checkSnCode(snCodeList);
  317. List<Camera> cameraList = this.getBySnCodes(snCodeList);
  318. List<Long> cameraIds = cameraList.parallelStream().map(Camera::getId).collect(Collectors.toList());
  319. List<CameraDetail> cameraDetails = cameraDetailService.getByCameraIds(cameraIds);
  320. HashMap<Long,CameraDetail> detailMap = new HashMap<>();
  321. for (CameraDetail cameraDetail : cameraDetails) {
  322. detailMap.put(cameraDetail.getCameraId(),cameraDetail);
  323. }
  324. HashMap<String,Camera> snCodeMap = new HashMap<>();
  325. for (Camera camera : cameraList) {
  326. snCodeMap.put(camera.getSnCode(),camera);
  327. }
  328. List<Integer> errorList = new ArrayList<>();
  329. for (String snCode : snCodeList) {
  330. Camera camera = snCodeMap.get(snCode);
  331. if(camera == null || detailMap.get(camera.getId()) ==null){
  332. errorList.add(snCodeList.indexOf(snCode) +3);
  333. }
  334. }
  335. getResultIn(errorList);
  336. resultMap.put("detailMap",detailMap);
  337. resultMap.put("snCodeMap",snCodeMap);
  338. return resultMap;
  339. }
  340. }