TTrainCourseMapper.java 2.85 KB
Newer Older
耿迪迪's avatar
耿迪迪 committed
1 2 3
package com.zehong.system.mapper;

import java.util.List;
耿迪迪's avatar
耿迪迪 committed
4 5

import com.zehong.system.domain.StatisticsTrainCourse;
吴卿华's avatar
吴卿华 committed
6
import com.zehong.system.domain.TNews;
耿迪迪's avatar
耿迪迪 committed
7
import com.zehong.system.domain.TTrainCourse;
吴卿华's avatar
吴卿华 committed
8
import com.zehong.system.domain.form.TStaffForm;
耿迪迪's avatar
耿迪迪 committed
9 10 11 12 13
import com.zehong.system.domain.vo.UserCourseVo;
import org.apache.ibatis.annotations.Param;

/**
 * 培训课程Mapper接口
吴卿华's avatar
吴卿华 committed
14
 *
耿迪迪's avatar
耿迪迪 committed
15 16 17
 * @author zehong
 * @date 2022-09-19
 */
吴卿华's avatar
吴卿华 committed
18
public interface TTrainCourseMapper
耿迪迪's avatar
耿迪迪 committed
19 20 21
{
    /**
     * 查询培训课程
吴卿华's avatar
吴卿华 committed
22
     *
耿迪迪's avatar
耿迪迪 committed
23 24 25 26 27 28 29
     * @param courseId 培训课程ID
     * @return 培训课程
     */
    public TTrainCourse selectTTrainCourseById(Long courseId);

    /**
     * 查询培训课程列表
吴卿华's avatar
吴卿华 committed
30
     *
耿迪迪's avatar
耿迪迪 committed
31 32 33 34 35 36 37
     * @param tTrainCourse 培训课程
     * @return 培训课程集合
     */
    public List<TTrainCourse> selectTTrainCourseList(TTrainCourse tTrainCourse);

    /**
     * 新增培训课程
吴卿华's avatar
吴卿华 committed
38
     *
耿迪迪's avatar
耿迪迪 committed
39 40 41 42 43 44 45
     * @param tTrainCourse 培训课程
     * @return 结果
     */
    public int insertTTrainCourse(TTrainCourse tTrainCourse);

    /**
     * 修改培训课程
吴卿华's avatar
吴卿华 committed
46
     *
耿迪迪's avatar
耿迪迪 committed
47 48 49 50 51 52 53
     * @param tTrainCourse 培训课程
     * @return 结果
     */
    public int updateTTrainCourse(TTrainCourse tTrainCourse);

    /**
     * 删除培训课程
吴卿华's avatar
吴卿华 committed
54
     *
耿迪迪's avatar
耿迪迪 committed
55 56 57 58 59 60 61
     * @param courseId 培训课程ID
     * @return 结果
     */
    public int deleteTTrainCourseById(Long courseId);

    /**
     * 批量删除培训课程
吴卿华's avatar
吴卿华 committed
62
     *
耿迪迪's avatar
耿迪迪 committed
63 64 65 66 67 68 69 70 71 72 73
     * @param courseIds 需要删除的数据ID
     * @return 结果
     */
    public int deleteTTrainCourseByIds(Long[] courseIds);

    /**
     * 批量新增用户课程
     * @param courseId
     * @param userIds
     * @return
     */
74
    public int insertUserCourse(@Param("courseId") Long courseId,@Param("userIds") List<String> userIds,@Param("personnelType")Integer personnelType);
耿迪迪's avatar
耿迪迪 committed
75 76 77 78 79 80

    /**
     * 用户课程表
     * @param userId
     * @return
     */
81
    public List<UserCourseVo> userCourseList(@Param("userId")Long userId,@Param("type") Integer type,@Param("personnelType")Integer personnelType);
耿迪迪's avatar
耿迪迪 committed
82 83 84 85 86 87 88

    /**
     * 考试统计接口
     * @param statisticsTrainCourse 统计实体
     * @return List<StatisticsTrainCourse>
     */
    List<StatisticsTrainCourse> statisticsTrainCourse(StatisticsTrainCourse statisticsTrainCourse);
吴卿华's avatar
吴卿华 committed
89 90

    List<UserCourseVo> userCourseLists(TStaffForm tStaff);
吴卿华's avatar
吴卿华 committed
91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117

    /**
     * 消息添加
     * @param tNews
     */
    void insertNews(TNews tNews);

    /**
     * 手机端  最新消息查询
     * @param recipientId
     * @return
     */
    TNews selectLatestNews(Long recipientId);

    /**
     * 手机端 查询历史消息
     * @param recipientId
     * @return
     */
    List<TNews> historicalMessages(Long recipientId);

    /**
     * 修改消息状态为已读
     * @param newsId
     * @return
     */
    int updateReadStatus(Long newsId);
吴卿华's avatar
吴卿华 committed
118 119 120 121 122

    /**
     * 查询接收人姓名
     */
    String selectRecipient(Long userid);
耿迪迪's avatar
耿迪迪 committed
123
}