package com.miniframe.model.mdo.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.poi.ss.formula.functions.T;

import java.util.List;

public interface MdoMapper extends Mapper {
    /**
     *  fsi 输入参数查询 FFD，TACS,ADFLOW
     * @param pid
     * @return
     */
    @Select("select DISTINCT uid from mdo_project_variate where pid =#{pid} and comtype in(2,3,5)")
    public List<String> selectFsiVuids(String pid );
    @Select("select DISTINCT uid from mdo_project_constraint where pid =#{pid} and comtype in(2,3,5)")
    public List<String> selectFsiCuids(String pid );
    @Select("select DISTINCT uid from mdo_project_objfun where pid =#{pid} and comtype in(2,3,5)")
    public List<String> selectFsiOuids(String pid );


    /**
     *  xfoil 输入参数查询 CST,XFOIL
     * @param pid
     * @return
     */
    @Select("select DISTINCT uid from mdo_project_variate where pid =#{pid} and comtype in(0,1)")
    public List<String> selectXfoilVuids(String pid );
    @Select("select DISTINCT uid from mdo_project_constraint where pid =#{pid} and comtype in(0,1)")
    public List<String> selectXfoilCuids(String pid );
    @Select("select DISTINCT uid from mdo_project_objfun where pid =#{pid} and comtype in(0,1)")
    public List<String> selectXfoilOuids(String pid );

    /**
     *  adflow 输入参数查询 FFD,ADFLOW
     * @param pid
     * @return
     */
    @Select("select DISTINCT uid from mdo_project_variate where pid =#{pid} and comtype in(2,3)")
    public List<String> selectAdflowVuids(String pid );
    @Select("select DISTINCT uid from mdo_project_constraint where pid =#{pid} and comtype in(2,3)")
    public List<String> selectAdflowCuids(String pid );
    @Select("select DISTINCT uid from mdo_project_objfun where pid =#{pid} and comtype in(2,3)")
    public List<String> selectAdflowOuids(String pid );

    /**
     * 查询所有 out param
     * @param pid
     * @return
     */
    @Select("select DISTINCT uid from mdo_project_constraint where pid  =#{pid} " +
            "UNION " +
            "select DISTINCT uid from mdo_project_objfun where pid  =#{pid} ")
    public List<String> selectAllOutUid(String pid);



}