package com.miniframe.model.mdo.dao;

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

import java.util.List;

public interface MdoMapper extends Mapper {
    /**
     * 模版复制 修改 mdo_pro_inout_para fatherid
     */
    @Update("update mdo_pro_inout_para set fatherid=#{ncomId}   where pid =#{pid} and fatherid=#{ocomId} ")
    void updateInOutFatherId(String pid,String ocomId,String ncomId);

    /**
     * 模版复制 修改 mdo_pro_inout_para fcomid
     */
    @Update("update mdo_pro_inout_para set fcomid=#{ncomId}  where pid =#{pid} and fcomid=#{ocomId} ")
    void updateInOutFcomId(String pid,String ocomId,String ncomId);

    /**
     * 模版复制 修改 mdo_project_variate comid
     */
    @Update("update mdo_project_variate set comid=#{ncomId}  where pid =#{pid} and comid=#{ocomId} ")
    void updateVarComId(String pid,String ocomId,String ncomId);

    /**
     * 模版复制 修改 mdo_project_objfun comid
     */
    @Update("update mdo_project_objfun set comid=#{ncomId}  where pid =#{pid} and comid=#{ocomId} ")
    void updateObjComId(String pid,String ocomId,String ncomId);

    /**
     * 模版复制 修改 mdo_project_constraint comid
     */
    @Update("update mdo_project_constraint set comid=#{ncomId}  where pid =#{pid} and comid=#{ocomId} ")
    void updateConComId(String pid,String ocomId,String ncomId);

    /**
     * 模版复制 修改 mdo_project_objfun paraId
     */
    @Update("update mdo_project_objfun set paraid=#{nparaId}  where pid =#{pid} and paraid=#{oparaId} ")
    void updateObjParaId(String pid,String oparaId,String nparaId);

    /**
     * 模版复制 修改 mdo_project_constraint paraId
     */
    @Update("update mdo_project_constraint set paraid=#{nparaId}  where pid =#{pid} and paraid=#{oparaId} ")
    void updateConParaId(String pid,String oparaId,String nparaId);

    /**
     *  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);



}