package cn.tsy.data.idsse.dsds.mapper.voyage;

import java.time.LocalDate;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import cn.hme.framework.jdbc.annotation.HmeMapper;
import cn.hme.framework.jdbc.constant.SqlProviderConstant;
import cn.hme.framework.jdbc.mapper.IHmeMapper;
import cn.hme.framework.jdbc.provider.page.Pageable;
import cn.tsy.data.idsse.dsds.model.voyage.VoyageReg;

@HmeMapper
public interface VoyageRegMapper extends IHmeMapper<VoyageReg> {

	public Pageable voyageWithPage(
			@Param(SqlProviderConstant.SQL_PAGE_GROUP) Integer group, 
			@Param(SqlProviderConstant.SQL_PAGE_START) Integer start, 
			@Param(SqlProviderConstant.SQL_PAGE_LIMIT) Integer limit, 
			@Param(SqlProviderConstant.SQL_PAGE_QUERY) String query, 
			@Param(SqlProviderConstant.SQL_PAGE_ORDER) String order, 
			@Param(SqlProviderConstant.SQL_PAGE_TYPE) String type
	);
	
	public List<Map<String,Object>> totalVoyage(@Param("start_date") LocalDate start_date,@Param("end_date") LocalDate end_date);
}
