package com.java110.report.dao.impl; import com.alibaba.fastjson.JSONObject; import com.java110.core.base.dao.BaseServiceDao; import com.java110.core.log.LoggerFactory; import com.java110.report.dao.IReportInoutStatisticsServiceDao; import com.java110.report.dao.IReportOrderStatisticsServiceDao; import com.java110.utils.util.ListUtil; import org.slf4j.Logger; import org.springframework.stereotype.Service; import java.util.List; import java.util.Map; /** * @ClassName ReportCommunityServiceDaoImpl * @Description TODO * @Author wuxw * @Date 2020/10/15 22:15 * @Version 1.0 * add by wuxw 2020/10/15 **/ @Service("reportInoutStatisticsServiceDaoImpl") public class ReportInoutStatisticsServiceDaoImpl extends BaseServiceDao implements IReportInoutStatisticsServiceDao { private static Logger logger = LoggerFactory.getLogger(ReportInoutStatisticsServiceDaoImpl.class); @Override public long getCarInCount(Map info) { logger.debug("查询 getCarInCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.getCarInCount", info); if (ListUtil.isNull(infos)) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } @Override public long getCarOutCount(Map info) { logger.debug("查询 getCarOutCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.getCarOutCount", info); if (infos == null || infos.size() < 1) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } @Override public long getPersonInCount(Map info) { logger.debug("查询 getPersonInCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.getPersonInCount", info); if (infos == null || infos.size() < 1) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } @Override public long getPersonFaceToMachineCount(Map info) { logger.debug("查询 getPersonFaceToMachineCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.getPersonFaceToMachineCount", info); if (infos == null || infos.size() < 1) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } @Override public long purchaseInCount(Map info) { logger.debug("查询 purchaseInCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.purchaseInCount", info); if (infos == null || infos.size() < 1) { return 0; } Number num = Float.parseFloat(infos.get(0).get("count").toString()); long value = Long.valueOf(num.intValue()); return value; } @Override public long purchaseOutCount(Map info) { logger.debug("查询 purchaseOutCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.purchaseOutCount", info); if (infos == null || infos.size() < 1) { return 0; } Number num = Float.parseFloat(infos.get(0).get("count").toString()); long value = Long.valueOf(num.intValue()); return value; } @Override public double purchaseInAmount(Map info) { logger.debug("查询 purchaseInAmount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.purchaseInAmount", info); if (infos == null || infos.size() < 1) { return 0; } return Double.parseDouble(infos.get(0).get("amount").toString()); } @Override public double purchaseOutAmount(Map info) { logger.debug("查询 purchaseOutAmount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.purchaseOutAmount", info); if (infos == null || infos.size() < 1) { return 0; } return Double.parseDouble(infos.get(0).get("amount").toString()); } @Override public long allocationCount(Map info) { logger.debug("查询 allocationCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.allocationCount", info); if (infos == null || infos.size() < 1) { return 0; } Number num = Float.parseFloat(infos.get(0).get("count").toString()); long value = Long.valueOf(num.intValue()); return value; } @Override public long roomRenovationCount(Map info) { logger.debug("查询 roomRenovationCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.roomRenovationCount", info); if (infos == null || infos.size() < 1) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } @Override public long itemReleaseCount(Map info) { logger.debug("查询 itemReleaseCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.itemReleaseCount", info); if (infos == null || infos.size() < 1) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } @Override public long roomInCount(Map info) { logger.debug("查询 roomInCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.roomInCount", info); if (infos == null || infos.size() < 1) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } @Override public long roomOutCount(Map info) { logger.debug("查询 roomOutCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.roomOutCount", info); if (infos == null || infos.size() < 1) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } @Override public long ownerRegisterCount(Map info) { logger.debug("查询 ownerRegisterCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.ownerRegisterCount", info); if (infos == null || infos.size() < 1) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } @Override public long noAttendanceCount(Map info) { logger.debug("查询 noAttendanceCount 入参 info : {}", JSONObject.toJSONString(info)); List infos = sqlSessionTemplate.selectList("reportInoutStatisticsServiceDaoImpl.noAttendanceCount", info); if (infos == null || infos.size() < 1) { return 0; } return Long.parseLong(infos.get(0).get("count").toString()); } }