package com.ltkj.hosp.mapper;

import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.DictZhengzhuang;
import com.ltkj.hosp.domain.TjAskMedicalHistory;
import com.ltkj.hosp.domain.TjAskHistorys;
import com.ltkj.hosp.domain.TjCatering;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * 问诊Mapper接口
 *
 * @author ltkj_赵佳豪&李格
 * @date 2023-04-11
 */
@Mapper
public interface TjAskMedicalHistoryMapper extends BaseMapper<TjAskMedicalHistory> {
    /**
     * 查询问诊
     *
     * @param askId 问诊主键
     * @return 问诊
     */
    public TjAskMedicalHistory selectTjAskMedicalHistoryByAskId(Long askId);

    /**
     * 查询问诊列表
     *
     * @param tjAskMedicalHistory 问诊
     * @return 问诊集合
     */
    public List<TjAskMedicalHistory> selectTjAskMedicalHistoryList(TjAskMedicalHistory tjAskMedicalHistory);

    /**
     * 新增问诊
     *
     * @param tjAskMedicalHistory 问诊
     * @return 结果
     */
    public int insertTjAskMedicalHistory(TjAskMedicalHistory tjAskMedicalHistory);

    /**
     * 修改问诊
     *
     * @param tjAskMedicalHistory 问诊
     * @return 结果
     */
    public int updateTjAskMedicalHistory(TjAskMedicalHistory tjAskMedicalHistory);

    /**
     * 删除问诊
     *
     * @param askId 问诊主键
     * @return 结果
     */
    public int deleteTjAskMedicalHistoryByAskId(Long askId);

    /**
     * 批量删除问诊
     *
     * @param askIds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteTjAskMedicalHistoryByAskIds(Long[] askIds);

        /**
         * 批量删除${subTable.functionName}
         *
         * @param askIds 需要删除的数据主键集合
         * @return 结果
         */
        public int deleteTjAskHistorysByAskIds(Long[] askIds);

        /**
         * 批量新增${subTable.functionName}
         *
         * @param tjAskHistorysList ${subTable.functionName}列表
         * @return 结果
         */
        public int batchTjAskHistorys(List<TjAskHistorys> tjAskHistorysList);


        /**
         * 通过问诊主键删除${subTable.functionName}信息
         *
         * @param askId 问诊ID
         * @return 结果
         */
        public int deleteTjAskHistorysByAskId(Long askId);

    @Update("UPDATE tj_ask_medical_history a SET \n" +
            "\n" +
            "a.tj_num=#{tjNum},\n" +
            "a.update_time=SYSDATE(),\n" +
            "a.update_by=#{userName},\n" +
            "a.update_id=#{userId}\n" +

            "WHERE" +

            " a.cus_id=#{cusId} \n" +
            "AND ISNULL(a.tj_num)")
    boolean updateTjAskMedicalHistoryByCusId(@Param("tjNum") String tjNum,@Param("userName") String userName,@Param("userId") String userId,@Param("cusId") String cusId);



    @Select("SELECT * FROM dict_zhengzhuang")
    List<DictZhengzhuang> getZhengZhuang();



//    @Select("SELECT * FROM tj_ask_medical_history a WHERE a.deleted=0 AND a.tj_num=#{tjNum}")
    TjAskMedicalHistory selectTjAskMedicalHistoryByTjNum(String tjNum);

}