VdsDtctDao.java 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. package com.its.vds.dao.mapper.batch;
  2. import com.its.app.utils.Elapsed;
  3. import com.its.vds.dao.mapper.BatchDaoService;
  4. import com.its.vds.entity.voVdsDtctClct;
  5. import lombok.extern.slf4j.Slf4j;
  6. import org.apache.ibatis.session.SqlSessionFactory;
  7. import org.springframework.stereotype.Repository;
  8. import java.util.ArrayList;
  9. import java.util.HashMap;
  10. import java.util.List;
  11. @Slf4j
  12. @Repository
  13. public class VdsDtctDao extends BatchDaoService {
  14. public VdsDtctDao(SqlSessionFactory sqlSessionFactory) {
  15. super(sqlSessionFactory);
  16. this.serviceName = "VdsDtctDao";
  17. this.mapperName = "";//com.its.vds.dao.mapper.VdsDtctMapper.";
  18. }
  19. public List<HashMap<String, Object>> getClctList(List<voVdsDtctClct> req) {
  20. List<HashMap<String, Object>> lists = new ArrayList<>();
  21. req.forEach(obj -> {
  22. HashMap<String, Object> param = new HashMap<>();
  23. param.put("VDS_DTCT_NMBR", obj.getVDS_DTCT_NMBR());
  24. param.put("CLCT_DT", obj.getCLCT_DT());
  25. param.put("SYST_KIND_DVSN", obj.getSYST_KIND_DVSN());
  26. param.put("TRAF_CLCT_CYCL", obj.getTRAF_CLCT_CYCL());
  27. param.put("TFVL", obj.getTFVL());
  28. param.put("SPED", obj.getSPED());
  29. param.put("AVRG_OCPY_RATE", obj.getAVRG_OCPY_RATE());
  30. param.put("AVRG_LNGT", obj.getAVRG_LNGT());
  31. param.put("HDWY", obj.getHDWY());
  32. param.put("SPCE_OCPY_RATE", obj.getSPCE_OCPY_RATE());
  33. param.put("SPCE_AVRG_SPED", obj.getSPCE_AVRG_SPED());
  34. lists.add(param);
  35. });
  36. return lists;
  37. }
  38. public int updateClct(List<voVdsDtctClct> req, boolean isHistory) {
  39. log.info("{}.updateStts: START. {} EA. History {}", this.serviceName, req.size(), isHistory);
  40. Elapsed elapsed = new Elapsed();
  41. this.mapper = this.mapperName + "batchUpdateVdsDtctClctPnst";
  42. int total = updateBatch(this.mapper, getClctList(req));
  43. log.info("{}.updateStts: ..END. {} EA. {} ms.", this.serviceName, total, elapsed.milliSeconds());
  44. return total;
  45. }
  46. public int insertClct(List<voVdsDtctClct> req) {
  47. log.info("{}.insertStts: START. {} EA.", this.serviceName, req.size());
  48. Elapsed elapsed = new Elapsed();
  49. this.mapper = this.mapperName + "batchInsertVdsDtctClct";
  50. int total = insertBatch(this.mapper, getClctList(req));
  51. log.info("{}.insertStts: ..END. {} EA. {} ms.", this.serviceName, total, elapsed.milliSeconds());
  52. return total;
  53. }
  54. }