package cn.com.countrygarden.bi.main.dao.investment;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import cn.com.countrygarden.bi.main.core.Mapper;
import cn.com.countrygarden.bi.main.dto.investment.InvestProjectExcelVO;
import cn.com.countrygarden.bi.main.dto.investment.InvestRegionInvestmentVO;
import cn.com.countrygarden.bi.main.dto.investment.InvestProjectAppVO;
import cn.com.countrygarden.bi.main.model.investment.InvestProjectInvestment;
import cn.com.countrygarden.bi.main.model.investment.InvestRegionInvestment;

/**
 * 个人区域投资-数据层
 *
 * @author 汤婷
 * @email www.justintoforest@gamail.com
 * @url
 * @date 2018-08-20
 */
public interface InvestRegionInvestmentMapper extends Mapper<InvestRegionInvestment> {
	/**
	 * @param regionIds
	 *            区域id数组
	 * @param investRegionInvestment
	 *            个人区域投资id
	 * @return
	 */
	
	
	List<InvestProjectExcelVO> selectInvestAppInfo(@Param(value = "organCode") String organCode,
			@Param(value = "regionIds") String[] regionIds,
			@Param(value = "investRegionInvestment") Integer investRegionInvestment);
	List<InvestProjectExcelVO> selectInvestExcelVO(@Param(value = "organCode") String organCode,
			@Param(value = "regionIds") String[] regionIds,
			@Param(value = "investRegionInvestment") Integer investRegionInvestment);

	InvestProjectAppVO findApp(@Param(value = "bipUserAccount") String bipUserAccount);

	List<InvestRegionInvestment> selectInvestRegionInvestmentlist(@Param(value = "regionId") String regionId,
			@Param(value = "projectId") String projectId, @Param(value = "userName") String userName,
			@Param(value = "organCode") String organCode);

	InvestRegionInvestmentVO selectInvestExcelVOSum(@Param(value = "regionIds") String[] regionIds,
			@Param(value = "personInvestmentId") String personInvestmentId);

	InvestProjectExcelVO selectInvestExcelVOTotal(@Param(value = "organCode") String organCode,
			@Param(value = "regionIds") String[] regionIds);

	List<InvestRegionInvestment> findRegionInvestmentInfo(@Param(value = "regionId") String regionId,
			@Param(value = "projectName") String projectName);

}