<?php

namespace app\model\api;

use think\facade\Db;
use think\model;

class CourseModel
{

    protected $table = 'table_education_course';

    /**
     * 添加课程
     * @param $data
     * @return mixed
     */
    public function addCourse($data)
    {
        $result = Db::table($this->table)->insert($data);
        return $result;
    }

    /**
     * 删除课程
     * @param $course_id
     * @return mixed
     */
    public function deleteCourse($course_id)
    {
        $result = Db::table($this->table)->where('course_id', $course_id)->delete();
        return $result;
    }

    /**
     * 查找课程
     * @param $keyword
     * @return mixed
     */
    public function searchCourse($keyword)
    {
        $result = Db::table($this->table)->where('title', 'like', '%' . $keyword . '%')->select();
        return $result;
    }


    /**
     * 修改课程状态
     * @param $course_id
     * @param $course_status
     * @return mixed
     */
    public function updateCourseStatus($course_id, $course_status)
    {
        $result = Db::table($this->table)->where('course_id', $course_id)->update(['status' => $course_status]);
        return $result;
    }

    /**
     * 修改课程信息
     * @param $course_id
     * @param $data
     * @return mixed
     */
    public function updateCourseInfo($course_id, $data)
    {
        $result = Db::table($this->table)->where('course_id', $course_id)->update($data);
        return $result;
    }


}