ssp_web/src/main/java/com/cloudcross/ssp/service/IAdReportService.java

package com.cloudcross.ssp.service;

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

import com.cloudcross.ssp.base.service.IGenericService;
import com.cloudcross.ssp.common.utils.Pager;
import com.cloudcross.ssp.model.DeliverAnalysis;

/**
 * 报表服务
 * @author chenyou
 *
 */
public interface IAdReportService extends IGenericService<DeliverAnalysis>{
	
    int findCountForDeliverEffectAnalysisAdvertiser(Map<String, Object> paramMap);
    int findCountForDeliverEffectAnalysisOperator(Map<String, Object> paramMap);
    int findCountForDeliverEffectAnalysisBack(Map<String, Object> paramMap);
    
    int findCountForDeliverEffectAnalysis2(Map<String, Object> paramMap);
	
	int findCountForLocationAdvertiser(Map<String, Object> paramMap);
	int findCountForLocationBack(Map<String, Object> paramMap);
	
	int findCountForOs(Map<String, Object> paramMap);
	
	int findCountForScene(Map<String, Object> paramMap);
	

	
	List<DeliverAnalysis> findByTotalReportAdvertiser(Map<String, Object> paramMap, Pager pager);
	List<DeliverAnalysis> findByTotalReportBack(Map<String, Object> paramMap, Pager pager);
	
	
	List<DeliverAnalysis> findByTotalReport2(Map<String, Object> paramMap, Pager pager);
	
	
    List<DeliverAnalysis> findByPlaceName(Map<String, Object> paramMap, Pager pager);
    List<DeliverAnalysis> findByLocationAdvertiser(Map<String, Object> paramMap, Pager pager);
    List<DeliverAnalysis> findByLocationBack(Map<String, Object> paramMap, Pager pager);
    
    List<DeliverAnalysis> findByOs(Map<String, Object> paramMap, Pager pager);

	
	//首页顶部统计数据查询
	Map<String,Object> findCompare(Map<String, Object> paramMap);
	
	//查询首页图表
	List<HashMap<String, Object>> findChart(String startDate, String endDate, Long advertiserId);
	
	int findCountForChart(String startDate, String endDate, Long advertiserId);
	
	List<HashMap<String, Object>> findChart(String startDate, String endDate, Long advertiserId, Pager pager);
	/**
	 * 根据广告主id和时间查询它的总的曝光数和点击数
	 */
	HashMap<String, Object> findTotalImpressionAndClickByAdvertiserId(Map<String, Object> paramMap);
	
	/**
	 * 根据代理商id查询该代理商下的所有广告主的曝光数和点击数的总和
	 */
	HashMap<String, Object> findTotalImpressionAndClickByAgentId(Map<String, Object> paramMap);
	
	/**
	 * 导出excel报表
	 */
	List<DeliverAnalysis> findByTotalForExcelAdvertiser(Map<String, Object> paramMap);
	List<DeliverAnalysis> findByTotalForExcelBack(Map<String, Object> paramMap);
	List<DeliverAnalysis> findByTotalForExcelOperator(Map<String, Object> paramMap);
	
    List<DeliverAnalysis> findByPlaceName(Map<String, Object> paramMap);
    
    List<DeliverAnalysis> findByLocation(Map<String, Object> paramMap);
    
    List<DeliverAnalysis> findByOs(Map<String, Object> paramMap);
    
    List<DeliverAnalysis> findDeliverEffectAnalysisOperator(
			Map<String, Object> paramMap, Pager pager);
	List<DeliverAnalysis> findDeliverEffectAnalysisOperator(
			Map<String, Object> paramMap);
	
	int countBySizeOperator(Map<String, Object> paramMap);
	List<DeliverAnalysis> findBySizeOperator(
			Map<String, Object> paramMap, Pager pager);
	List<DeliverAnalysis> findBySizeOperator(
			Map<String, Object> paramMap);
	
	List<DeliverAnalysis> findByPositionOperator(
			Map<String, Object> paramMap);
	
	int countBySystemOperator(Map<String, Object> paramMap);
	
	List<DeliverAnalysis> findBySystemOperator(
			Map<String, Object> paramMap, Pager pager);
	
	List<DeliverAnalysis> findBySystemOperator(
			Map<String, Object> paramMap);
	
	List<DeliverAnalysis> findByDeviceOperator(
			Map<String, Object> paramMap);
	
	List<DeliverAnalysis> findByArealCityOperator(
			Map<String, Object> paramMap);
	
	List<DeliverAnalysis> findByArealOperator(
			Map<String, Object> paramMap);
	
	int countByPlaceOperator(Map<String, Object> paramMap);
	
	List<DeliverAnalysis> findByPlaceOperator(
			Map<String, Object> paramMap, Pager pager);
	
	List<DeliverAnalysis> findByPlaceOperator(
			Map<String, Object> paramMap);
	
	int countByApmacOperator(Map<String, Object> paramMap);
	
	List<DeliverAnalysis> findByApmacOperator(
			Map<String, Object> paramMap, Pager pager);
	
	List<DeliverAnalysis> findByApmacOperator(
			Map<String, Object> paramMap);
	
	int countByAllArealOperator(Map<String, Object> paramMap);
	
	List<DeliverAnalysis> findByAllArealOperator(
			Map<String, Object> paramMap, Pager pager);
	
	 //根据查询条件查询总的pv，uv，曝光数等等
    DeliverAnalysis findSumOperator(Map<String, Object> paramMap);
    
    List<DeliverAnalysis> findAllAreaOperator(Map<String, Object> paramMap);
}