web_server/src/main/java/thyyxxk/webserver/dao/his/datamodify/YzActOrderMapper.java

package thyyxxk.webserver.dao.his.datamodify;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import thyyxxk.webserver.pojo.datamodify.GetDropdownBox;
import thyyxxk.webserver.pojo.datamodify.YzActOrder;

import java.util.ArrayList;


/**
 * <p>
 *  医嘱修改 接口
 * </p>
 *
 * @author 肖蟾
 * @since 2021-03-08
 */
@Mapper
public interface YzActOrderMapper extends BaseMapper<YzActOrder> {

    /**
     * 根据医嘱号修改
     * @param id 医嘱号
     * @return
     * */
    @Select("select act_order_no,rtrim((select name from a_employee_mi where code = physician)) physician_name,physician ,exec_unit, " +
            "order_name,drug_specification,rtrim(frequ_code) frequ_code,supply_code, " +
            "start_time,modifier, " +
            "rtrim((select name from a_employee_mi where code = modifier)) modifier_name,modifier, " +
            "end_time,order_time,parent_no,discription,instruction " +
            "from  yz_act_order a " +
            "where  act_order_no = #{id}")
    YzActOrder query(@Param("id") float id);

    /**
     * 修改医嘱的一些字段
     * @param yzActOrder 里面传入需要字段和条件
     * */
    @Update("update yz_act_order set frequ_code=#{frequCode}, supply_code=#{supplyCode},start_time=#{startTime}, " +
            "end_time=#{endTime},physician = #{physician},exec_unit=#{execUnit}, " +
            "instruction=#{instruction},modifier=#{modifier},order_time=#{orderTime} " +
            "where act_order_no = #{actOrderNo}")
    boolean YzUpdate(YzActOrder yzActOrder);

    /**
     * 获取频次
     * */
    @Select("select rtrim(code) code,rtrim(code) name from yz_order_frequency where isnull(del_flag,0) =0")
    ArrayList<GetDropdownBox> getFrequCode();

    /**
     * 获取给药方式
     * */
    @Select("select code,rtrim(name) name from view_zd_supply_type")
    ArrayList<GetDropdownBox> getSupplyType();

    /**
     * 获取科室
     * */
    @Select("select code,name from zd_unit_code where isnull(del_flag,0) =0")
    ArrayList<GetDropdownBox> getUnitCode();

}