优化报表功能

java110

2022-07-21 c6b944ae631e1d37d8f6bacfa1f5c7e855f0dab8

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
package com.java110.report.dao.impl;
 
import com.alibaba.fastjson.JSONObject;
import com.java110.core.base.dao.BaseServiceDao;
import com.java110.dto.community.CommunityDto;
import com.java110.dto.report.ReportCarDto;
import com.java110.dto.report.ReportRoomDto;
import com.java110.report.dao.IReportCommunityServiceDao;
import org.slf4j.Logger;
import com.java110.core.log.LoggerFactory;
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("reportCommunityServiceDaoImpl")
public class ReportCommunityServiceDaoImpl extends BaseServiceDao implements IReportCommunityServiceDao {
 
    private static Logger logger = LoggerFactory.getLogger(ReportCommunityServiceDaoImpl.class);
 
    @Override
    public int getRoomCount(ReportRoomDto reportRoomDto) {
        logger.debug("查询费用月统计数据 入参 info : {}", JSONObject.toJSONString(reportRoomDto));
 
        List<Map> businessReportFeeMonthStatisticsInfos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.getRoomCount", reportRoomDto);
        if (businessReportFeeMonthStatisticsInfos.size() < 1) {
            return 0;
        }
 
        return Integer.parseInt(businessReportFeeMonthStatisticsInfos.get(0).get("count").toString());
    }
 
    @Override
    public List<ReportRoomDto> getRoomFloorUnitAndOwner(ReportRoomDto reportRoomDto) {
        logger.debug("查询房屋信息 入参 info : {}", JSONObject.toJSONString(reportRoomDto));
 
        List<ReportRoomDto> roomDtos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.getRoomFloorUnitAndOwner", reportRoomDto);
 
        return roomDtos;
    }
 
    /**
     * 统计车辆
     *
     * @param reportCarDto
     * @return
     */
    @Override
    public int getCarCount(ReportCarDto reportCarDto) {
        logger.debug("查询费用月统计数据 入参 info : {}", JSONObject.toJSONString(reportCarDto));
 
        List<Map> businessReportFeeMonthStatisticsInfos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.getCarCount", reportCarDto);
        if (businessReportFeeMonthStatisticsInfos.size() < 1) {
            return 0;
        }
 
        return Integer.parseInt(businessReportFeeMonthStatisticsInfos.get(0).get("count").toString());
    }
 
    @Override
    public List<ReportCarDto> getCarParkingSpace(ReportCarDto reportCarDto) {
        logger.debug("查询房屋信息 入参 info : {}", JSONObject.toJSONString(reportCarDto));
 
        List<ReportCarDto> carDtos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.getCarParkingSpace", reportCarDto);
 
        return carDtos;
    }
 
    @Override
    public List<Map> getCommunitys(Map communityDto) {
        logger.debug("查询getCommunitys信息 入参 info : {}", JSONObject.toJSONString(communityDto));
 
        List<Map> communityDtos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.getCommunitys", communityDto);
 
        return communityDtos;
    }
 
    @Override
    public List<Map> queryRoomStructures(Map info) {
        logger.debug("查询queryRoomStructures信息 入参 info : {}", JSONObject.toJSONString(info));
 
        List<Map> communityDtos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryRoomStructures", info);
 
        return communityDtos;
    }
 
    @Override
    public List<Map> queryCarStructures(Map info) {
        logger.debug("查询queryCarStructures信息 入参 info : {}", JSONObject.toJSONString(info));
 
        List<Map> communityDtos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryCarStructures", info);
 
        return communityDtos;
    }
 
    public int deleteInvalidFee(Map info){
        logger.debug("deleteInvalidFee 入参 info : {}", info);
 
        int saveFlag = sqlSessionTemplate.update("reportCommunityServiceDaoImpl.deleteInvalidFee", info);
 
        return saveFlag;
    }
 
    @Override
    public List<Map> queryInvalidFeeMonthStatistics(Map info) {
        logger.debug("查询押金退费总金额信息 入参 info : {}", info);
 
        List<Map> deposits = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryInvalidFeeMonthStatistics", info);
 
        return deposits;
    }
 
 
    @Override
    public List<Map> queryRoomsTree(Map info) {
        logger.debug("查询queryRoomsTree信息 入参 info : {}", JSONObject.toJSONString(info));
 
        List<Map> communityDtos = sqlSessionTemplate.selectList("reportCommunityServiceDaoImpl.queryRoomsTree", info);
 
        return communityDtos;
    }
}