package com.steerinfo.dil.mapper;

import com.steerinfo.dil.model.TmsshipLoadShipResult;
import com.steerinfo.dil.model.TmsshipShipLocation;
import com.steerinfo.framework.mapper.IBaseMapper;
import java.math.*;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface TmsshipLoadShipResultMapper extends IBaseMapper<TmsshipLoadShipResult, BigDecimal> {
    // 查询最大id
    BigDecimal selectMaxId();

    // 插入
    int insert(TmsshipLoadShipResult tmsshipLoadShipResult);

    // 根据主键删除
    int deleteByPrimaryKey(BigDecimal resultId);


    //根据主键查看详细
    TmsshipLoadShipResult selectByPrimaryKey(BigDecimal resultId);


    // 根据主键修改
    int updateByPrimaryKeySelective(TmsshipLoadShipResult tmsshipLoadShipResult);


    /**
     * 查询所有装船
     * @return
     */
    List<Map<String,Object>> selectLoadShipList(Map<String,Object> mapVal);

    // 查询总重量
    BigDecimal selectAllWeight(BigDecimal instructionsId);

    /**
     * 查询装船表单
     * @return
     */
    List<Map<String,Object>> selectLoadShip(BigDecimal resultId);

    // 根据外轮船名和物资名称得到批次id
    BigDecimal getBatchId(Map<String,Object> mapVal);

    @Override
    List<TmsshipLoadShipResult> selectByParameters(Map<String, Object> totalId);

    @Select("select seq_TMSSHIP_LOAD.nextval from dual")
    BigDecimal selectLoadId();

    // 得到码头和港口
    Map<String, Object> getPortAndPier(BigDecimal batchId);

    //根据港口名称获得港存库主键id
   Map<String,Object> selectGmIdByPortId(Map<String,Object> idMap);
}