<?php
/**
 * @remark :
 * @name   :KeywordVideoController.php
 * @author :lyh
 * @method :post
 * @time   :2024/2/26 9:23
 */

namespace App\Http\Controllers\Aside\Com;

use App\Enums\Common\Code;
use App\Http\Controllers\Aside\BaseController;
use App\Models\Com\KeywordVideoTask;
use App\Models\Domain\DomainInfo;
use App\Models\Project\Project;

class KeywordVideoController extends BaseController
{
    /**
     * @remark :任务列表
     * @name   :lists
     * @author :lyh
     * @method :post
     * @time   :2024/2/26 11:36
     */
    public function lists(){
        $keywordModel  = new KeywordVideoTask();
        $query = $keywordModel->leftJoin('gl_project', 'gl_keyword_video_task.project_id', '=', 'gl_project.id');
        $query = $this->searchParam($query);
        $query = $this->orderByList($query);
        $lists = $query->paginate($this->row, $this->selectParam(), 'page', $this->page)->toArray();
        $this->response('success',Code::SUCCESS,$lists);
    }
    /**
     * 需要查询的字段
     * @return array
     */
    public function selectParam(){
        $select = [
            'gl_keyword_video_task.id AS id',
            'gl_keyword_video_task.project_id AS project_id',
            'gl_keyword_video_task.number AS number',
            'gl_keyword_video_task.status AS status',
            'gl_keyword_video_task.sort AS sort',
            'gl_keyword_video_task.created_at AS created_at',
            'gl_keyword_video_task.updated_at AS updated_at',
            'gl_project.title AS title',
            'gl_project.company AS company',
        ];
        return $select;
    }
    /**
     * @remark :搜索参数处理
     * @name   :searchParam
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 10:58
     */
    public function searchParam(&$query){
        if(isset($this->map['project_name']) && is_array($this->map['project_name'])){
            $query->where('gl_project.title','like','%'.$this->map['project_name'].'%');
        }
        return $query;
    }

    /**
     * @remark :排序
     * @name   :orderByList
     * @author :lyh
     * @method :post
     * @time   :2023/12/29 17:14
     */
    public function orderByList(&$query){
        $query = $query->orderBy('gl_keyword_video_task.sort', 'desc')->orderBy('gl_keyword_video_task.id', 'desc');
        return $query;
    }

    /**
     * @remark :创建关键字任务池子
     * @name   :saveKeyword
     * @author :lyh
     * @method :post
     * @time   :2024/2/26 9:24
     */
    public function createKeywordTask(){
        $this->request->validate([
            'project_id'=>'required',
            'number'=>'required'
        ], [
            'project_id.required' => '项目唯一标识不为空',
            'number.required' => 'number不为空',
        ]);
        //查看当前项目是否有正式域名
        $domainModel = new DomainInfo();
        $info = $domainModel->read(['project_id'=>$this->param['project_id']]);
        if($info === false){
            $this->response('请先设置域名',Code::SYSTEM_ERROR);
        }
        $keywordModel  = new KeywordVideoTask();
        $rs = $keywordModel->add($this->param);
        if($rs === false){
            $this->response('添加失败',Code::SYSTEM_ERROR);
        }
        $this->response('success');
    }

    /**
     * @remark :修改项目
     * @name   :editSort
     * @author :lyh
     * @method :post
     * @time   :2024/2/26 11:35
     */
    public function edit(){
        $this->request->validate([
            'id'=>'required'
        ], [
            'id.required' => '主键标识不为空',
        ]);
        $keywordModel  = new KeywordVideoTask();
        $rs = $keywordModel->edit(['sort'=>$this->param['sort']],['id'=>$this->param['id']]);
        if($rs === false){
            $this->response('编辑失败',Code::SYSTEM_ERROR);
        }
        $this->response('success');
    }
}