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.IReportFeeStatisticsServiceDao;
import com.java110.report.dao.IReportOrderStatisticsServiceDao;
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("reportOrderStatisticsServiceDaoImpl")
public class ReportOrderStatisticsServiceDaoImpl extends BaseServiceDao implements IReportOrderStatisticsServiceDao {

    private static Logger logger = LoggerFactory.getLogger(ReportOrderStatisticsServiceDaoImpl.class);

    /**
     * 查询投诉工单数
     *
     * @param info
     * @return
     */
    @Override
    public double getComplaintOrderCount(Map info) {
        logger.debug("查询 getComplaintOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getComplaintOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("complaintCount").toString());
    }

    @Override
    public double getUndoComplaintOrderCount(Map info) {
        logger.debug("查询 getUndoComplaintOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getUndoComplaintOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("complaintCount").toString());
    }

    @Override
    public double getFinishComplaintOrderCount(Map info) {
        logger.debug("查询 getFinishComplaintOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getFinishComplaintOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("complaintCount").toString());
    }

    @Override
    public double getRepairOrderCount(Map info) {
        logger.debug("查询 getRepairOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getRepairOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("repairCount").toString());
    }

    @Override
    public double getUndoRepairOrderCount(Map info) {
        logger.debug("查询 getUndoRepairOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getUndoRepairOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("repairCount").toString());
    }

    @Override
    public double getFinishRepairOrderCount(Map info) {
        logger.debug("查询 getFinishRepairOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getFinishRepairOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("repairCount").toString());
    }

    @Override
    public double getInspectionOrderCount(Map info) {
        logger.debug("查询 getInspectionOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getInspectionOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("inspectionCount").toString());
    }

    @Override
    public double getUndoInspectionOrderCount(Map info) {
        logger.debug("查询 getUndoInspectionOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getUndoInspectionOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("inspectionCount").toString());
    }

    @Override
    public double getFinishInspectionOrderCount(Map info) {
        logger.debug("查询 getFinishInspectionOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getFinishInspectionOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("inspectionCount").toString());
    }

    @Override
    public double getMaintainanceOrderCount(Map info) {
        logger.debug("查询 getMaintainanceOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getMaintainanceOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("maintainanceCount").toString());
    }

    @Override
    public double getUndoMaintainanceOrderCount(Map info) {
        logger.debug("查询 getUndoMaintainanceOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getUndoMaintainanceOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("maintainanceCount").toString());
    }

    @Override
    public double getFinishMaintainanceOrderCount(Map info) {
        logger.debug("查询 getFinishMaintainanceOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getFinishMaintainanceOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("maintainanceCount").toString());
    }

    @Override
    public double getNotepadOrderCount(Map info) {
        logger.debug("查询 getNotepadOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getNotepadOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("notepadCount").toString());
    }

    @Override
    public double getChargeMachineOrderCount(Map info) {
        logger.debug("查询 getChargeMachineOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getChargeMachineOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("chargeMachineCount").toString());
    }

    @Override
    public double getChargeMonthOrderCount(Map info) {
        logger.debug("查询 getChargeMonthOrderCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getChargeMonthOrderCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Double.parseDouble(infos.get(0).get("chargeMonthMoney").toString());
    }

    @Override
    public int getOwnerReserveGoodsCount(Map info) {
        logger.debug("查询 getOwnerReserveGoodsCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getOwnerReserveGoodsCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Integer.parseInt(infos.get(0).get("count").toString());
    }

    @Override
    public List<Map> getOwnerReserveGoods(Map info) {
        logger.debug("查询 getOwnerReserveGoods 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getOwnerReserveGoods", info);

        return infos;
    }

    @Override
    public int getOwnerDiningCount(Map info) {
        logger.debug("查询 getOwnerDiningCount 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getOwnerDiningCount", info);

        if (infos == null || infos.size() < 1) {
            return 0;
        }

        return Integer.parseInt(infos.get(0).get("count").toString());
    }

    @Override
    public List<Map> getOwnerDinings(Map info) {
        logger.debug("查询 getOwnerDinings 入参 info : {}", JSONObject.toJSONString(info));

        List<Map> infos = sqlSessionTemplate.selectList("reportOrderStatisticsServiceDaoImpl.getOwnerDinings", info);

        return infos;
    }

}