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

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.VoyageNavigation;

@HmeMapper
public interface VoyageNavigationMapper extends IHmeMapper<VoyageNavigation> {
	public Pageable navigationWithPage(
			@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,
			@Param("voyage_id") int voyage_id
	);
	
	public Map<String,Object> totalNavigation(@Param("voyage_id") int voyage_id);
	

	public List<Map<String,Object>> listNavigation(@Param("voyage_id") int voyage_id,@Param("ticket_minutes") int ticket_minutes);
}
