package com.yeejoin.amos.patrol.business.dao.mapper;

import org.apache.ibatis.annotations.Param;

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

public interface TaskReportMapper extends BaseMapper{

	List<Map> queryWithPoint(@Param("summation")String summation,@Param("startDate") String startDate, @Param("endDate")String endDate, @Param("planId")Integer planId, @Param("routeId")Integer routeId,@Param("orgCode")String orgCode);

	List<Map> queryWithRoute(@Param("summation")String summation,@Param("startDate") String startDate, @Param("endDate")String endDate, @Param("planId")Integer planId, @Param("routeId")Integer routeId,@Param("orgCode")String orgCode);

	List<Map> queryWithDept(@Param("summation")String summation,@Param("startDate") String startDate, @Param("endDate")String endDate, @Param("planId")Integer planId, @Param("routeId")Integer routeId,@Param("orgCode")String orgCode);

	List<Map> queryWithUser(@Param("summation")String summation,@Param("startDate") String startDate, @Param("endDate")String endDate, @Param("planId")Integer planId, @Param("routeId")Integer routeId,@Param("orgCode")String orgCode);

	List<Map> queryWithPlan(@Param("summation")String summation,@Param("startDate") String startDate, @Param("endDate")String endDate, @Param("planId")Integer planId, @Param("routeId")Integer routeId,@Param("orgCode")String orgCode);

	List<Map> comprehensiveStatisticalForUser(@Param("summation")String summation,@Param("startTime")String startTime,@Param("endTime")String endTime);

}
