NN2025081602/app/Services/Common/VideosCoursesService.php

<?php
namespace App\Services\Common;

use App\Models\VideoCoursesModel;
use App\Models\VideosCoursesModel;
use App\Services\BaseService;
use Illuminate\Support\Facades\DB;

/**
 * 
 * @author laravel开发员
 * @since 2020/11/11
 * Class VideosCoursesService
 * @package App\Services\Common
 */
class VideosCoursesService extends BaseService
{
    public static $instance = null;

    /**
     * 构造函数
     * @author laravel开发员
     * @since 2020/11/11
     * VideosCoursesService constructor.
     */
    public function __construct()
    {
        $this->model = new VideoCoursesModel();
    }

    /**
     * 静态入口
     */
    public static function make()
    {
        if (!self::$instance) {
            self::$instance = new static();
        }
        return self::$instance;
    }

    /**
     * 获取课程数据列表
     */
    public function getDataList($params, $pageSize = 15)
    {
        $where = ['a.mark' => 1];  // Filter for non-deleted records.

        // Status filtering
        $status = isset($params['status']) ? (int) $params['status'] : 0;
        if ($status > 0) {
            $where['a.status'] = $status;
        }

        // Query with JOIN for video details, using course name to filter videos
        $query = $this->model->from('videos_courses as a')
            ->leftJoin('videos as v', 'a.video_id', '=', 'v.id')  // Join with lev_videos table
            ->where($where)
            ->where(function ($query) use ($params) {
                $keyword = isset($params['keyword']) ? trim($params['keyword']) : '';
                if ($keyword) {
                    $query->where('a.course_name', 'like', "%{$keyword}%");
                }
            })
            ->where(function ($query) use ($params) {
                $videoId = isset($params['video_id']) ? (int) $params['video_id'] : 0;
                if ($videoId) {
                    $query->where('a.video_id', $videoId);
                }
            })
            // Filtering based on video_name (course set name)
            ->where(function ($query) use ($params) {
                $videoName = isset($params['video_name']) ? trim($params['video_name']) : '';
                if ($videoName) {
                    $query->where('v.video_name', 'like', "%{$videoName}%");
                }
            })
            ->select([
                'a.id',
                'a.course_name',
                'a.course_url',
                'a.video_id',
                'a.fee',
                'a.poster',
                'a.description',
                'a.sort',
                'a.create_time',
                'a.update_time',
                'a.status',
                'v.video_name as video_name', // Selecting video_name from lev_videos
                'v.poster as video_poster'   // Selecting video poster from lev_videos
            ])
            ->orderBy('a.sort', 'desc')
            ->orderBy('a.create_time', 'desc');

        // Paginate results
        $list = $query->paginate($pageSize > 0 ? $pageSize : 9999999)->toArray();

        // Format
        if (!empty($list['data'])) {
            foreach ($list['data'] as &$item) {
                $item['create_time'] = $item['create_time'] ? datetime($item['create_time'], 'Y-m-d H:i:s') : '';
                $item['update_time'] = $item['update_time'] ? datetime($item['update_time'], 'Y-m-d H:i:s') : '';
                $item['poster'] = $item['poster'] ? get_image_url($item['poster']) : '';
                $item['video_poster'] = $item['video_poster'] ? get_image_url($item['video_poster']) : '';  // Formatting video poster URL
            }
        }

        return [
            'pageSize' => $pageSize,
            'total' => $list['total'] ?? 0,
            'list' => $list['data'] ?? []
        ];
    }

    /**
     * 编辑课程信息
     */
    public function edit()
    {
        $data = request()->all();

        // Handle video cover (poster)
        if (!empty($data['poster'])) {
            $data['poster'] = get_image_path(trim($data['poster']));
        }

        $id = $data['id'] ?? 0;

        // Check if course name already exists
        $courseName = trim($data['course_name'] ?? '');
        $checkId = $this->model->where(['course_name' => $courseName, 'mark' => 1])->value('id');
        if ($checkId && $id != $checkId) {
            return message('课程名称已存在', false);
        }

        // Default fields
        $data['update_time'] = time();
        if (!$id) {
            $data['create_time'] = time();
        }

        return parent::edit($data); // Call BaseService's edit method
    }

    /**
     * 获取课程详细信息
     */
    public function info()
    {
        // Record ID
        $id = request()->input("id", 0);
        $info = [];
        if ($id) {
            $info = $this->model->getInfo($id);
        }
        $info['poster'] = $info['poster'] ? get_image_url($info['poster']) : '';
        return message(MESSAGE_OK, true, $info);
    }
}