package com.ltkj.hosp.mapper; import java.util.List; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ltkj.hosp.domain.TjOrderRemark; import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; /** * 医生备注Mapper接口 * * @author 赵佳豪 * @date 2022-12-02 */ @Mapper public interface TjOrderRemarkMapper extends BaseMapper { @Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND type IN(0,3) AND deleted='0'") List getTjOrderRemarkListByYjNum(String tjNumber); @Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND deleted='0'") List getTjOrderRemarkListByTjNum(String tjNumber); @Select("SELECT * FROM tj_order_remark WHERE tj_number=#{tjNumber} AND pro_id=#{proParentId} AND deleted='0'") TjOrderRemark getTjOrderRemarkByTjNumAndProParentId(@Param("tjNumber") String tjNumber,@Param("proParentId") String proParentId); @Select("SELECT COUNT(*) a FROM tj_order_remark WHERE tj_number=#{tjNumber} AND type=3 AND deleted=0") int getTjYqOrderRemarkByTjNum(String tjNumber); @Delete("DELETE FROM tj_order_remark WHERE tj_number=#{tjNumber}") void deletedOrderRemarkByTjNum(String tjNumber); // @Select({"" }) // List getTjOrderRemarkListByksproList(@Param("ksproList")List ksproList,@Param("type")Integer type); // // @Select({"" }) // List getTjOrderRemarkListByksproLists(@Param("ksproList")List ksproList); @Select("SELECT GROUP_CONCAT(pro_id ORDER BY pro_id) AS names FROM tj_order_remark WHERE tj_number=#{tjNumber} AND type=3 AND deleted='0' ") String getTjOrderRemarkProIdList(String tjNumber); }