NodeLinkDao.java 3.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374
  1. package com.its.bis.dao.mapper.batch;
  2. import com.its.app.utils.Elapsed;
  3. import com.its.bis.dao.mapper.BatchDaoService;
  4. import com.its.bis.entity.TbVmsCtlrStts;
  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 NodeLinkDao extends BatchDaoService {
  14. public NodeLinkDao(SqlSessionFactory sqlSessionFactory) {
  15. super(sqlSessionFactory);
  16. this.serviceName = "NodeLinkDao";//this.getClass().getName();
  17. }
  18. public List<HashMap<String, Object>> getSttsList(List<TbVmsCtlrStts> req) {
  19. List<HashMap<String, Object>> lists = new ArrayList<>();
  20. req.forEach(obj -> {
  21. HashMap<String, Object> param = new HashMap<>();
  22. param.put("vmsCtlrNmbr", obj.getVmsCtlrNmbr());
  23. param.put("updtDt", obj.getUpdtDt());
  24. param.put("cmncSttsCd", obj.getCmncSttsCd());
  25. param.put("pwerSttsCd", obj.getPwerSttsCd());
  26. param.put("modlSttsCd", obj.getModlSttsCd());
  27. param.put("cboxDoorSttsCd", obj.getCboxDoorSttsCd());
  28. param.put("fanSttsCd", obj.getFanSttsCd());
  29. param.put("hetrSttsCd", obj.getHetrSttsCd());
  30. param.put("cboxTmpr", obj.getCboxTmpr());
  31. param.put("brghVal", obj.getBrghVal());
  32. param.put("commSttsCd", obj.getCommSttsCd());
  33. param.put("modlStts", obj.getModlStts());
  34. param.put("pwerStts", obj.getPwerStts());
  35. param.put("cboxHum", obj.getCboxHum());
  36. param.put("cboxFanSttsCd", obj.getCboxFanSttsCd());
  37. param.put("cboxHetrSttsCd", obj.getCboxHetrSttsCd());
  38. param.put("tmpr", obj.getTmpr());
  39. param.put("hum", obj.getHum());
  40. param.put("doorSttsCd", obj.getDoorSttsCd());
  41. param.put("brghMode", obj.getBrghMode());
  42. param.put("brghCurr", obj.getBrghCurr());
  43. param.put("brghWeek", obj.getBrghWeek());
  44. param.put("brghNght", obj.getBrghNght());
  45. param.put("pwerOnOffCd", obj.getPwerOnOffCd());
  46. lists.add(param);
  47. });
  48. return lists;
  49. }
  50. public int updateStts(List<TbVmsCtlrStts> req, boolean isHistory) {
  51. log.info("{}.updateStts: START. {} EA. History {}", this.serviceName, req.size(), isHistory);
  52. Elapsed elapsed = new Elapsed();
  53. int total = updateBatch("batchUpdateCtlrStts", getSttsList(req));
  54. log.info("{}.updateStts: ..END. {} EA. {} ms.", this.serviceName, total, elapsed.milliSeconds());
  55. return total;
  56. }
  57. public int insertStts(List<TbVmsCtlrStts> req) {
  58. log.info("{}.insertStts: START. {} EA.", this.serviceName, req.size());
  59. Elapsed elapsed = new Elapsed();
  60. int total = insertBatch("batchInsertCtlrSttsHs", getSttsList(req));
  61. log.info("{}.insertStts: ..END. {} EA. {} ms.", this.serviceName, total, elapsed.milliSeconds());
  62. return total;
  63. }
  64. }