VdsDtctDao.java 2.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  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. if (req.size() > 1) {
  40. log.info("{}.updateStts: START. {} EA. History {}", this.serviceName, req.size(), isHistory);
  41. }
  42. Elapsed elapsed = new Elapsed();
  43. this.mapper = this.mapperName + "batchUpdateVdsDtctClctPnst";
  44. int total = updateBatch(this.mapper, getClctList(req));
  45. if (req.size() > 1) {
  46. log.info("{}.updateStts: ..END. {} EA. {} ms.", this.serviceName, total, elapsed.milliSeconds());
  47. }
  48. return total;
  49. }
  50. public int insertClct(List<voVdsDtctClct> req) {
  51. if (req.size() > 1) {
  52. log.info("{}.insertStts: START. {} EA.", this.serviceName, req.size());
  53. }
  54. Elapsed elapsed = new Elapsed();
  55. this.mapper = this.mapperName + "batchInsertVdsDtctClct";
  56. int total = insertBatch(this.mapper, getClctList(req));
  57. if (req.size() > 1) {
  58. log.info("{}.insertStts: ..END. {} EA. {} ms.", this.serviceName, total, elapsed.milliSeconds());
  59. }
  60. return total;
  61. }
  62. }