Blame view

src/main/java/com/objecteye/service/impl/VehicleDbServiceImpl.java 5.95 KB
c83b5b39   Liu Haoyu   项目创建, 集成spring-se...
1
2
3
  package com.objecteye.service.impl;
  
  import cn.hutool.core.date.DateUtil;
c83b5b39   Liu Haoyu   项目创建, 集成spring-se...
4
5
  import com.objecteye.entity.PageResult;
  import com.objecteye.entity.SyVehicleDb;
c83b5b39   Liu Haoyu   项目创建, 集成spring-se...
6
  import com.objecteye.entity.UploadVehicleDbResult;
c83b5b39   Liu Haoyu   项目创建, 集成spring-se...
7
8
9
10
11
12
  import com.objecteye.service.DeployService;
  import com.objecteye.service.VehicleDbService;
  import org.springframework.beans.factory.annotation.Autowired;
  import org.springframework.data.mongodb.core.MongoTemplate;
  import org.springframework.data.mongodb.core.query.Criteria;
  import org.springframework.data.mongodb.core.query.Query;
68a67f36   Liu Haoyu   接口问题处理;
13
  import org.springframework.data.mongodb.core.query.Update;
c83b5b39   Liu Haoyu   项目创建, 集成spring-se...
14
15
16
  import org.springframework.data.redis.core.RedisTemplate;
  import org.springframework.stereotype.Service;
  
68a67f36   Liu Haoyu   接口问题处理;
17
  import java.util.*;
c83b5b39   Liu Haoyu   项目创建, 集成spring-se...
18
19
20
21
22
23
24
25
26
  
  /**
   * 服务实现层
   *
   * @author Administrator
   */
  @Service
  public class VehicleDbServiceImpl implements VehicleDbService {
  
40c853a1   Liu Haoyu   去掉MySQL相关内容, 去掉my...
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
      @Autowired
      private MongoTemplate mongoTemplate;
      @Autowired
      private RedisTemplate redisTemplate;
      @Autowired
      private DeployService deployService;
  
      /**
       * 查询全部
       */
      @Override
      public List<SyVehicleDb> findAll() {
          return mongoTemplate.find(Query.query(Criteria.where("isDelete").is(0)), SyVehicleDb.class);
      }
  
      /**
       * 按分页查询
       */
      @Override
      public PageResult findPage(int pageNum, int pageSize) {
          List<SyVehicleDb> result = mongoTemplate.find(Query.query(Criteria.where("isDelete").is(0))
                  .limit(pageSize).skip((pageNum - 1) * pageSize), SyVehicleDb.class);
          long count = mongoTemplate.count(Query.query(Criteria.where("isDelete").is(0)), SyVehicleDb.class);
          return new PageResult<>((long) Math.ceil((double) count / pageSize), result);
      }
  
      /**
       * 增加
       *
       * @return
       */
      @Override
      public String add(SyVehicleDb vehicleDb) {
          String strDate = DateUtil.now();
          vehicleDb.setCount(0);
          vehicleDb.setCreateDate(strDate);
          vehicleDb.setUpdateDate(strDate);
          vehicleDb.setIsDelete(0);
          vehicleDb = mongoTemplate.insert(vehicleDb);
          return vehicleDb.getId();
      }
  
      /**
       * 修改
       */
      @Override
      public void update(SyVehicleDb vehicleDb) {
          String now = DateUtil.now();
          vehicleDb.setUpdateDate(now);
          mongoTemplate.save(vehicleDb);
      }
  
      /**
       * 根据ID获取实体
       *
       * @param id
       * @return
       */
      @Override
      public SyVehicleDb findOne(String id) {
          return mongoTemplate.findOne(Query.query(Criteria.where("id").is(id)), SyVehicleDb.class);
      }
  
      /**
       * 批量删除
       *
       * @param ids
       */
      @Override
68a67f36   Liu Haoyu   接口问题处理;
96
      public void delete(List<String> ids) {
40c853a1   Liu Haoyu   去掉MySQL相关内容, 去掉my...
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
          for (String id : ids) {
              List<String> deployList = deployService.getDeployListByLibAndDeployType(id, 2);
              UploadVehicleDbResult uploadVehicleDbResult = mongoTemplate.findOne(Query.query(new Criteria("id").is(id)), UploadVehicleDbResult.class);
              if (uploadVehicleDbResult != null) {
                  String id1 = uploadVehicleDbResult.getId();
                  String plateNum = uploadVehicleDbResult.getPlateNum();
                  float plateScore = uploadVehicleDbResult.getPlateScore();
                  if (plateScore > 0.9) {
                      redisTemplate.opsForHash().delete("vehicleId", plateNum);
                  }
                  redisTemplate.opsForHash().delete("vehicleId", id1);
                  redisTemplate.opsForHash().delete("vehicleUrl", id1);
                  mongoTemplate.remove(uploadVehicleDbResult);
                  if (deployList != null && deployList.size() > 0) {
                      int size = deployList.size();
                      for (int i = 0; i < size; i++) {
                          String deployId = deployList.get(i);
                          String[] deploy = {deployId};
68a67f36   Liu Haoyu   接口问题处理;
115
                          deployService.delete(Arrays.asList(deploy));
40c853a1   Liu Haoyu   去掉MySQL相关内容, 去掉my...
116
117
118
                      }
                  }
              }
68a67f36   Liu Haoyu   接口问题处理;
119
              mongoTemplate.updateMulti(Query.query(Criteria.where("id").is(id)), Update.update("isDelete", 1), SyVehicleDb.class);
40c853a1   Liu Haoyu   去掉MySQL相关内容, 去掉my...
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
          }
      }
  
  
      @Override
      public PageResult findPage(SyVehicleDb vehicleDb, int pageNum, int pageSize) {
          Criteria criteria = new Criteria();
          if (vehicleDb != null) {
              if (vehicleDb.getVehicleName() != null && vehicleDb.getVehicleName().length() > 0) {
                  criteria.and("vehicleName").regex(".*" + vehicleDb.getVehicleName() + ".*");
              }
              if (vehicleDb.getCreateDate() != null && vehicleDb.getCreateDate().length() > 0) {
                  criteria.and("createDate").regex(".*" + vehicleDb.getCreateDate() + ".*");
              }
              if (vehicleDb.getUpdateDate() != null && vehicleDb.getUpdateDate().length() > 0) {
                  criteria.and("updateDate").regex(".*" + vehicleDb.getUpdateDate() + ".*");
              }
              if (vehicleDb.getDescription() != null && vehicleDb.getDescription().length() > 0) {
                  criteria.and("description").regex(".*" + vehicleDb.getDescription() + ".*");
              }
          }
          List<SyVehicleDb> resultList = mongoTemplate.find(Query.query(criteria)
                  .limit(pageSize).skip((pageNum - 1) * pageSize), SyVehicleDb.class);
          long count = mongoTemplate.count(Query.query(criteria), SyVehicleDb.class);
          return new PageResult<>((long) Math.ceil((double) count / pageSize), resultList);
      }
  
      @Override
      public void updateCountById(SyVehicleDb feature) {
          mongoTemplate.save(feature);
      }
  
      @Override
      public List<Map<String, String>> findAllName() {
          List<Map<String, String>> list = new ArrayList<>();
          List<SyVehicleDb> syVehicleDbs = findAll();
          for (SyVehicleDb vehicleDb : syVehicleDbs) {
              Map<String, String> map = new HashMap<>(16);
              String name = vehicleDb.getVehicleName();
              String id = vehicleDb.getId();
              map.put("value", id + "");
              map.put("name", name);
              list.add(map);
          }
          return list;
      }
c83b5b39   Liu Haoyu   项目创建, 集成spring-se...
166
167
  
  }