package com.rongwei.bscommon.sys.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.rongwei.bsentity.domain.KnowledgebaseCommentsDo;
import com.rongwei.bsentity.enums.KnowledgeInfo;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @author chenguangyu
 * @version 1.0
 * @email chenguangyu@irongwei.com
 * @date 2024/01/11 11:12
 */
@Repository
public interface KnowledgebaseCommentsDao extends BaseMapper<KnowledgebaseCommentsDo> {

    @Select("SELECT CODE FROM sys_user WHERE DELETED = 0 AND ID = #{id}")
    String QueryJobNumber(@Param("id") String commenterid);


    @Select("SELECT AUTHORID,TITLE FROM kb_knowledge_ledger WHERE DELETED = 0 AND ID = #{id}")
    KnowledgeInfo knowledgeInfo(@Param("id") String commenterid);


}
