package com.ruoyi.bussiness.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ruoyi.bussiness.domain.PlacementBatchHousehold;
|
import com.ruoyi.bussiness.object.request.report.DetailExportsRequest;
|
import com.ruoyi.bussiness.object.request.report.DetailPageRequest;
|
import com.ruoyi.bussiness.object.request.report.ReportPageRequest;
|
import com.ruoyi.bussiness.object.request.report.ReportRequest;
|
import com.ruoyi.bussiness.object.response.placement.GetHouseHistoryRequest;
|
import com.ruoyi.bussiness.object.response.report.DetailResponse;
|
import com.ruoyi.bussiness.object.response.report.ReportResponse;
|
import com.ruoyi.bussiness.object.response.report.ReportSumResponse;
|
import com.ruoyi.bussiness.object.response.screen.*;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
import java.util.Map;
|
|
@Mapper
|
public interface PlacementBatchHouseholdMapper extends BaseMapper<PlacementBatchHousehold> {
|
|
/**
|
* 汇总
|
*
|
* @param street
|
* @return
|
*/
|
ReportSumResponse reportPlacementHouseholdSum(@Param("street") String street);
|
|
|
/**
|
* 分页统计
|
* @param page
|
* @param request
|
* @return
|
*/
|
Page<Map<String,Object>> reportPage(IPage<Map<String,Object>> page, @Param("request") ReportPageRequest request);
|
|
|
/**
|
* 导出
|
* @return
|
*/
|
List<Map<String,Object>> reportExportsList(@Param("request") DetailExportsRequest request);
|
|
/**
|
* 详情分页
|
* @param page
|
* @param request
|
* @return
|
*/
|
Page<DetailResponse> detailPage(IPage<DetailResponse> page, @Param("request") DetailPageRequest request);
|
|
|
|
//统计
|
BigDecimal sumCurrentMonth(@Param("month") String month);
|
|
|
//统计
|
BigDecimal countCurrentPerson();
|
|
//街镇参与人数统计（审核通过）
|
List<StreetResponse> getStreetResponse();
|
|
//错误数据统计
|
List<ImportErrorResponse> getImportErrorResponse();
|
|
//地图数据统计
|
List<MapResponse> getMapResponse();
|
|
//季度款进度
|
List<QuarterProcessResponse> getQuarterProcessResponse(@Param("request") ReportRequest request);
|
|
//房屋类型占比
|
List<PlacementTypeResponse> getPlacementTypeResponse();
|
|
//本月补偿金额统计
|
List<MonthCompensationResponse> getMonthCompensationResponse(@Param("month") String month);
|
|
//未来4季度支付款项金额
|
List<Map<String, Object>> getQuarterPayResponse(@Param("quarters") List<String> quarters);
|
|
//某季度应支付
|
BigDecimal getPayMoneyByQuarter(@Param("quarter") String quarter);
|
|
|
List<PlacementBatchHousehold> getPlacementByIdCards(@Param("idCards") List<String> idCards);
|
|
|
List<PlacementBatchHousehold> getHouseHistory(@Param("request") GetHouseHistoryRequest request);
|
|
}
|
