java110-db/src/main/resources/mapper/report/ReportFeeMonthStatisticsServiceDaoImplMapper.xml
@@ -225,4 +225,73 @@ </select> <!-- 查询费用月统计信息 add by wuxw 2018-07-03 --> <select id="queryReportFeeSummary" parameterType="Map" resultType="Map"> select t.receivable_amount,t.receivable_amount receivableAmount,t.statistics_id,t.statistics_id statisticsId,t.update_time,t.update_time updateTime,t.remark,t.status_cd,t.status_cd statusCd,t.obj_name,t.obj_name objName,t.received_amount,t.received_amount receivedAmount,t.fee_year,t.fee_year feeYear,t.fee_month,t.fee_month feeMonth,t.fee_id,t.fee_id feeId,t.config_id,t.config_id configId,t.obj_id,t.obj_id objId,t.fee_name,t.fee_name feeName,t.owe_amount,t.owe_amount oweAmount,t.community_id,t.community_id communityId,t.fee_create_time,t.fee_create_time feeCreateTime,t.obj_type,t.obj_type objType from report_fee_month_statistics t where 1 =1 <if test="receivableAmount !=null and receivableAmount != ''"> and t.receivable_amount= #{receivableAmount} </if> <if test="statisticsId !=null and statisticsId != ''"> and t.statistics_id= #{statisticsId} </if> <if test="updateTime !=null and updateTime != ''"> and t.update_time= #{updateTime} </if> <if test="remark !=null and remark != ''"> and t.remark= #{remark} </if> <if test="statusCd !=null and statusCd != ''"> and t.status_cd= #{statusCd} </if> <if test="objName !=null and objName != ''"> and t.obj_name= #{objName} </if> <if test="receivedAmount !=null and receivedAmount != ''"> and t.received_amount= #{receivedAmount} </if> <if test="feeYear !=null and feeYear != ''"> and t.fee_year= #{feeYear} </if> <if test="feeMonth !=null and feeMonth != ''"> and t.fee_month= #{feeMonth} </if> <if test="feeId !=null and feeId != ''"> and t.fee_id= #{feeId} </if> <if test="configId !=null and configId != ''"> and t.config_id= #{configId} </if> <if test="objId !=null and objId != ''"> and t.obj_id= #{objId} </if> <if test="feeName !=null and feeName != ''"> and t.fee_name= #{feeName} </if> <if test="oweAmount !=null and oweAmount != ''"> and t.owe_amount= #{oweAmount} </if> <if test="communityId !=null and communityId != ''"> and t.community_id= #{communityId} </if> <if test="feeCreateTime !=null and feeCreateTime != ''"> and t.fee_create_time= #{feeCreateTime} </if> <if test="objType !=null and objType != ''"> and t.obj_type= #{objType} </if> order by t.create_time desc <if test="page != -1 and page != null "> limit #{page}, #{row} </if> </select> </mapper> java110-interface/src/main/java/com/java110/intf/report/IReportFeeMonthStatisticsInnerServiceSMO.java
@@ -50,4 +50,19 @@ */ @RequestMapping(value = "/queryReportFeeMonthStatisticssCount", method = RequestMethod.POST) int queryReportFeeMonthStatisticssCount(@RequestBody ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto); /** * 查询费用汇总表个数 * @param reportFeeMonthStatisticsDto * @return */ int queryReportFeeSummaryCount(@RequestBody ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto); /** * 查询费用汇总表 * @param reportFeeMonthStatisticsDto * @return */ List<ReportFeeMonthStatisticsDto> queryReportFeeSummary(@RequestBody ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto); } service-report/src/main/java/com/java110/report/dao/IReportFeeMonthStatisticsServiceDao.java
@@ -1,13 +1,7 @@ package com.java110.report.dao; import com.java110.dto.RoomDto; import com.java110.utils.exception.DAOException; import com.java110.entity.merchant.BoMerchant; import com.java110.entity.merchant.BoMerchantAttr; import com.java110.entity.merchant.Merchant; import com.java110.entity.merchant.MerchantAttr; import java.util.List; import java.util.Map; @@ -16,7 +10,7 @@ * 费用月统计组件内部之间使用，没有给外围系统提供服务能力 * 费用月统计服务接口类，要求全部以字符串传输，方便微服务化 * 新建客户，修改客户，删除客户，查询客户等功能 * * <p> * Created by wuxw on 2016/12/27. */ public interface IReportFeeMonthStatisticsServiceDao { @@ -24,17 +18,17 @@ /** * 保存 费用月统计信息 * * @param info * @throws DAOException DAO异常 */ void saveReportFeeMonthStatisticsInfo(Map info) throws DAOException; /** * 查询费用月统计信息（instance过程） * 根据bId 查询费用月统计信息 * * @param info bId 信息 * @return 费用月统计信息 * @throws DAOException DAO异常 @@ -42,18 +36,18 @@ List<Map> getReportFeeMonthStatisticsInfo(Map info) throws DAOException; /** * 修改费用月统计信息 * * @param info 修改信息 * @throws DAOException DAO异常 */ void updateReportFeeMonthStatisticsInfo(Map info) throws DAOException; /** * 修改费用月统计信息 * * @param info 修改信息 * @throws DAOException DAO异常 */ @@ -68,4 +62,24 @@ */ int queryReportFeeMonthStatisticssCount(Map info); /** * 查询费用月统计总数 * * @param info 费用月统计信息 * @return 费用月统计数量 */ int queryReportFeeSummaryCount(Map info); /** * 查询费用月统计信息（instance过程） * 根据bId 查询费用月统计信息 * * @param info bId 信息 * @return 费用月统计信息 * @throws DAOException DAO异常 */ List<Map> queryReportFeeSummary(Map info) throws DAOException; } service-report/src/main/java/com/java110/report/dao/impl/ReportFeeMonthStatisticsServiceDaoImpl.java
@@ -108,5 +108,26 @@ return Integer.parseInt(businessReportFeeMonthStatisticsInfos.get(0).get("count").toString()); } @Override public int queryReportFeeSummaryCount(Map info) { logger.debug("查询费用月统计数据 入参 info : {}", info); List<Map> businessReportFeeMonthStatisticsInfos = sqlSessionTemplate.selectList("reportFeeMonthStatisticsServiceDaoImpl.queryReportFeeSummaryCount", info); if (businessReportFeeMonthStatisticsInfos.size() < 1) { return 0; } return Integer.parseInt(businessReportFeeMonthStatisticsInfos.get(0).get("count").toString()); } @Override public List<Map> queryReportFeeSummary(Map info) throws DAOException { logger.debug("查询费用月统计信息 入参 info : {}", info); List<Map> businessReportFeeMonthStatisticsInfos = sqlSessionTemplate.selectList("reportFeeMonthStatisticsServiceDaoImpl.queryReportFeeSummary", info); return businessReportFeeMonthStatisticsInfos; } } service-report/src/main/java/com/java110/report/smo/impl/ReportFeeMonthStatisticsInnerServiceSMOImpl.java
@@ -73,6 +73,26 @@ return reportFeeMonthStatisticsServiceDaoImpl.queryReportFeeMonthStatisticssCount(BeanConvertUtil.beanCovertMap(reportFeeMonthStatisticsDto)); } @Override public int queryReportFeeSummaryCount(@RequestBody ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) { return reportFeeMonthStatisticsServiceDaoImpl.queryReportFeeSummaryCount(BeanConvertUtil.beanCovertMap(reportFeeMonthStatisticsDto)); } @Override public List<ReportFeeMonthStatisticsDto> queryReportFeeSummary(@RequestBody ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto) { //校验是否传了 分页信息 int page = reportFeeMonthStatisticsDto.getPage(); if (page != PageDto.DEFAULT_PAGE) { reportFeeMonthStatisticsDto.setPage((page - 1) * reportFeeMonthStatisticsDto.getRow()); } List<ReportFeeMonthStatisticsDto> reportFeeMonthStatisticss = BeanConvertUtil.covertBeanList(reportFeeMonthStatisticsServiceDaoImpl.getReportFeeMonthStatisticsInfo(BeanConvertUtil.beanCovertMap(reportFeeMonthStatisticsDto)), ReportFeeMonthStatisticsDto.class); return reportFeeMonthStatisticss; } public IReportFeeMonthStatisticsServiceDao getReportFeeMonthStatisticsServiceDaoImpl() { return reportFeeMonthStatisticsServiceDaoImpl; }
