order('course_id desc'); if (!empty($course_topic)) { $query->whereLike('course_topic', '%' . $course_topic . '%'); } $list = $query->paginate([ 'page' => $page, 'list_rows' => $pageSize, ]); $data = [ 'list' => $list->items(), 'total' => $list->total(), 'page' => $list->currentPage(), 'pagesize' => $list->listRows(), ]; return app('json')->success($data); } /** * 添加课程 */ public function addCourse() { $data = Request::param(); $courseModel = new CourseModel(); $result = $courseModel->addCourse($data); if ($result) { return json(['code' => 200, 'msg' => '添加成功', 'data' => $result]); } else { return json(['code' => 500, 'msg' => '添加失败', 'data' => '']); } } /** * 删除课程 */ public function deleteCourse() { $course_id = Request::param('course_id'); $courseModel = new CourseModel(); $result = $courseModel->deleteCourse($course_id); if ($result) { return json(['code' => 200, 'msg' => '删除成功', 'data' => $result]); } else { return json(['code' => 500, 'msg' => '删除失败', 'data' => '']); } } /** * 获取课程详细信息 */ public function searchCourse() { $courseId = input('course_id'); $courseModel = new CourseModel(); $courseDetail = $courseModel->getCourseDetail($courseId); if ($courseDetail) { return json(['code' => 200, 'msg' => '查找成功', 'data' => $courseDetail]); } else { return json(['code' => 500, 'msg' => '查找失败', 'data' => '']); } } /** * 编辑课程信息 * @param Request $request * @return mixed */ public function editCourse(Request $request) { $course_id = Request::param('course_id'); $course_cate_id = Request::param('course_cate_id'); $gr_id = Request::param('gr_id'); $sort = Request::param('sort'); $course_topic = Request::param('course_topic'); $course_price = Request::param('course_price'); $course_price2 = Request::param('course_price2'); $course_price3 = Request::param('course_price3'); $deduct = Request::param('deduct'); $course_only_for_employee = Request::param('course_only_for_employee'); $make_code = Request::param('make_code'); $parent_course = Request::param('parent_course'); $ad_pid = Request::param('ad_pid'); $course_cover = Request::param('course_cover'); $course_speaker_intro = Request::param('course_speaker_intro'); $course_play_count = Request::param('course_play_count'); $course_intro = Request::param('course_intro'); $course_audio = Request::param('course_audio'); $course_sp = Request::param('course_sp'); $data = [ 'course_id' => $course_id, 'course_cate_id' => $course_cate_id, 'gr_id' => $gr_id, 'sort' => $sort, 'course_topic' => $course_topic, 'course_price' => $course_price, 'course_price2' => $course_price2, 'course_price3' => $course_price3, 'deduct' => $deduct, 'course_only_for_employee' => $course_only_for_employee, 'make_code' => $make_code, 'parent_course' => $parent_course, 'ad_pid' => $ad_pid, 'course_cover' => $course_cover, 'course_speaker_intro' => $course_speaker_intro, 'course_play_count' => $course_play_count, 'course_intro' => $course_intro, 'course_audio' => $course_audio, 'course_sp' => $course_sp, ]; var_dump($course_speaker_intro); $groupModel = new CourseModel(); $result = $groupModel->updateCourse($course_id, $data); if ($result !== false) { return json(['code' => 200, 'msg' => '保存成功']); } return json(['code' => 1, 'msg' => '保存失败']); } /** * 修改课程状态 */ public function updateCourseStatus() { $course_id = Request::param('course_id'); $course_status = Request::param('course_status'); $courseModel = new CourseModel(); $result = $courseModel->updateCourseStatus($course_id, $course_status); if ($result) { return json(['code' => 200, 'msg' => '修改成功', 'data' => $result]); } else { return json(['code' => 500, 'msg' => '修改失败', 'data' => '']); } } /** * 修改审核状态 * @return mixed */ public function updateCourseAudit() { $course_id = Request::param('course_id'); $course = CourseModel::where('course_id', $course_id)->find(); if (!$course) { return app('json')->fail('课程不存在'); } $course->course_audit = !$course->course_audit; if ($course->save()) { return app('json')->success(); } else { return app('json')->fail(); } } /** * 修改课程信息 */ public function updateCourseInfo() { $course_id = Request::param('course_id'); $data = Request::param(); $courseModel = new CourseModel(); $result = $courseModel->updateCourseInfo($course_id, $data); if ($result) { return json(['code' => 200, 'msg' => '修改成功', 'data' => $result]); } else { return json(['code' => 500, 'msg' => '修改失败', 'data' => '']); } } }