package cn.com.lzt.contractreports.dao;

import java.util.List;
import java.util.Map;

import org.jeecgframework.minidao.annotation.MiniDao;
import org.jeecgframework.minidao.annotation.Param;
import org.springframework.stereotype.Repository;

import cn.com.lzt.contract.entity.ContractEntity;
import cn.com.lzt.contractreports.dto.Contract4FinanceRptDto;
import cn.com.lzt.contractreports.dto.Contract4PurchaseRptDto;
import cn.com.lzt.contractreports.dto.PropertyFeeLiveDTO;
@Repository
@MiniDao
public interface ContractRptMiniDao {
	/**
	 * 按项目统计已收、已开等数据，其他为查询出来数据后续代码处理
	 * */
	List<PropertyFeeLiveDTO> getSaleLiveData(@Param("projectid") String projectid,@Param("curentyYear") String curentyYear,
			@Param("lastYear") String lastYear,@Param("nextYear") String nextYear,@Param("projectname") String projectname);
	/**
	 * 查询合同本年度应收金额数据
	 * */
	List<Map<String,Object>> getSaleContractAmount(@Param("projectid") String projectid,@Param("curentyYear") String curentyYear);
	/**
	 * 查询上年未开完发票的合同数据
	 * */
	List<Map<String,Object>> getLastYearNoInvoice(@Param("projectid") String projectid,@Param("lastYear") String lastYear);
	/**
	 * 查询上年开上年开票、收款数据
	 * */
	List<Map<String,Object>> getSaleLastYearInvoiceIncome(@Param("projectid") String projectid,@Param("curentyYear") String curentyYear,@Param("lastYear") String lastYear);
	
	/**
	 * 查询上年开上年开票、收款数据
	 * */
	List<Map<String,Object>> getSaleNoIncomeLastYear(@Param("projectid") String projectid,@Param("curentyYear") String curentyYear,@Param("lastYear") String lastYear);
	/**
	 * 查询项目维保合同，可按类型过滤
	 * */
	List<Contract4PurchaseRptDto> getProjectContract(@Param("projectid") String projectid,@Param("curdate") String curdate,@Param("servicetypedetail") String servicetypedetail);

	List<Contract4FinanceRptDto> getProjectContract4Finance(@Param("projectid") String projectid,@Param("curyear") String curyear,@Param("lastyear") String lastyear,@Param("period") String period);
	/**
	 * 按按照统计已收、已开等数据，其他为查询出来数据后续代码处理
	 * */
	List<PropertyFeeLiveDTO> getSaleLiveDataByContract(@Param("projectid") String projectid,@Param("curentyYear") String curentyYear,
			@Param("lastYear") String lastYear,@Param("nextYear") String nextYear);
}