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

package thyyxxk.webserver.dao.his.datamodify;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import thyyxxk.webserver.entity.datamodify.GetDropdownBox;
import thyyxxk.webserver.entity.datamodify.YzTemperature;

import java.util.List;

/**
 * <p>
 * 描述
 * </p>
 *
 * @author xc
 * @date 2021-04-12 17:43
 */
@Mapper
public interface YzTemperatureMapper {


    /**
     * 查询住院 护理记录单
     * @param param 住院号 住院次数,能查询出这个人的全部护理记录单 在根据日期，时间就能查询出 某一条的护理记录单
     * @return 返回这个人一条的护理记录单
     * */
    @Select("select patientName=(select rtrim(name) name from a_patient_mi where a_patient_mi.inpatient_no= yz_temperature.inpatient_no), " +
            "inpatient_no,rec_date,rec_time,temperature_1,pulse_1,breathe_1,pressure_1_am,pressure_1_pm," +
            "spo2,mind,skin,tubes_name,tubes_status,other_info,ward,admiss_times,detail_no, " +
            "userid=(select rtrim(name) name from a_employee_mi where code = userid) " +
            "from yz_temperature " +
            "where inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes} and scd_flag='0' " +
            "and rec_date=#{toStringRecDate} and rec_time=#{toStringRecTime} " +
            "order by detail_no"
           )
    List<YzTemperature> queryDetails(YzTemperature param);

    /**
     * 获取病区
     * @return 科室 code 和 名字
     * */
    @Select("select code,rtrim(name) name from zy_ward_code")
    List<GetDropdownBox> getWard();

    /**
     * 更新重要的数据
     * @param param 根据 住院号 住院次数 日期 时间
     *              现在能修改的字段有 体温：temperature1 脉搏：pulse1 呼吸：breathe1
     *              血压am： pressure1Am， 血压pm：pressure1Pm  spo2：spo2 意识：mind 皮肤：skin
     *              管道名称：tubesName 管道状态：tubesStatus  病区：ward
     * @return 返回状态
     * */
    @Update("<script>" +
            "update yz_temperature set " +
            "modify_userid=#{modifyUserid},modify_time=#{modifyTime}  " +
            "<if test=\"temperature1!=null\">" +
            ",temperature_1=#{temperature1}" +
            "</if>" +
            "<if test=\"pulse1!=null\">" +
            ",pulse_1=#{pulse1}" +
            "</if>" +
            "<if test=\"breathe1!=null\">" +
            ",breathe_1=#{breathe1}" +
            "</if>" +
            "<if test=\"pressure1Am!=null\">" +
            ",pressure_1_am=#{pressure1Am}" +
            "</if>" +
            "<if test=\"pressure1Pm!=null\">" +
            ",pressure_1_pm=#{pressure1Pm}" +
            "</if>" +
            "<if test=\"spo2!=null\">" +
            ",spo2=#{spo2}" +
            "</if>" +
            "<if test=\"mind!=null\">" +
            ",mind=#{mind}" +
            "</if>" +
            "<if test=\"skin!=null\">" +
            ",skin=#{skin}" +
            "</if>" +
            "<if test=\"tubesName!=null\">" +
            ",tubes_name=#{tubesName}" +
            "</if>" +
            "<if test=\"tubesStatus!=null\">" +
            ",tubes_status=#{tubesStatus}" +
            "</if>" +
            "<if test=\"ward!=null\">" +
            ",ward=#{ward}" +
            "</if>" +
            "where " +
            "inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes} and scd_flag='0' " +
            "and rec_date=#{toStringRecDate} and rec_time=#{toStringRecTime} and detail_no=#{detailNo}" +
            "</script>")
    Boolean teperatureHead(YzTemperature param);

    /**
     * 更新 剩下的地方 主要是更新 病室和 修改人 修改时间
     * */
    @Update("<script>" +
            "update yz_temperature set modify_userid=#{modifyUserid},modify_time=#{modifyTime}" +
            "<if test=\"ward!=null\">" +
            ",ward=#{ward}" +
            "</if>" +
            "where " +
            "inpatient_no=#{inpatientNo} and admiss_times=#{admissTimes} and scd_flag='0' " +
            "and rec_date=#{toStringRecDate} and rec_time=#{toStringRecTime} and detail_no=#{detailNo}" +
            "</script>")
    Boolean teperatureBody(YzTemperature param);


}