<?php

namespace App\Http\Controllers\Aside\Optimize;

use App\Enums\Common\Code;
use App\Http\Controllers\Aside\BaseController;
use App\Http\Logic\Aside\Optimize\OptimizeLogic;
use App\Models\Ai\AiPrefix;
use App\Models\ASide\APublicModel;
use App\Models\Channel\Channel;
use App\Models\Domain\DomainInfo;
use App\Models\Manage\Manage;
use App\Models\Project\OnlineCheck;
use App\Models\Project\Project;
use App\Models\RankData\RankData;
use App\Models\Task\Task;
use Illuminate\Support\Facades\DB;

/**
 * @remark :优化
 * @name   :OptimizeController
 * @author :lyh
 * @time   :2023/6/20 14:33
 */
class OptimizeController extends BaseController
{
    /**
     * @remark :优化中台列表
     * @name   :middleGroundList
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 10:49
     */
    public function lists(Project $project){
        $query = $project->leftJoin('gl_project_payment', 'gl_project.id', '=', 'gl_project_payment.project_id')
            ->leftJoin('gl_project_deploy_build', 'gl_project.id', '=', 'gl_project_deploy_build.project_id')
            ->leftJoin('gl_project_deploy_optimize', 'gl_project.id', '=', 'gl_project_deploy_optimize.project_id')
            ->leftJoin('gl_project_online_check', 'gl_project.id', '=', 'gl_project_online_check.project_id');
        $query = $this->searchParam($query)->orderBy('gl_project_deploy_optimize.start_date','desc')->orderBy('gl_project_deploy_optimize.id','desc');
        $lists = $query->paginate($this->row, $this->selectParam(), 'page', $this->page)->toArray();
        if(!empty($lists) && !empty($lists['list'])){
            $rankDataModel = new RankData();
            foreach ($lists['list'] as $k => $v){
                $data = $rankDataModel->read(['project_id'=>$v['id'],'lang'=>''],['first_page_num','indexed_pages_num']);
                $v['first_page_num'] = $data['first_page_num'] ?? 0;
                $v['indexed_pages_num'] = $data['indexed_pages_num'] ?? 0;
                $v = $this->handleParam($v);
                $lists['list'][$k] = $v;
            }
        }
        $this->response('success',Code::SUCCESS,$lists);
    }

    /**
     * @remark :参数处理
     * @name   :handleParam
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 14:44
     */
    public function handleParam(&$item){
        if($item['type'] != Project::TYPE_ZERO){
            $data = APublicModel::getNumByProjectId($item['id']);
        }
        $manageModel = new Manage();
        $item['channel'] = Channel::getChannelText($item['channel']['user_id'] ?? 0);
        $item['build_leader'] = $manageModel->getName($item['leader_mid']);
        $item['build_manager'] = $manageModel->getName($item['manager_mid']);
        $item['build_designer'] = $manageModel->getName($item['designer_mid']);
        $item['build_tech'] = $manageModel->getName($item['tech_mid']);
        $item['optimize_manager'] = $manageModel->getName($item['optimize_manager_mid']);
        $item['optimize_optimist'] = $manageModel->getName($item['optimize_optimist_mid']);
        $item['optimize_assist'] = $manageModel->getName($item['optimize_assist_mid']);
        $item['optimize_tech'] = $manageModel->getName($item['optimize_tech_mid']);
        $item['plan'] = Project::planMap()[$item['plan']];
        $item['created_at'] = date('Y年m月d日', strtotime($item['cooperate_date']));
        $item['autologin_code'] = getAutoLoginCode($item['id']);
        $domainModel = new DomainInfo();
        $item['domain'] = !empty($item['domain']) ?  $domainModel->getDomain($item['domain']) : '';
        $item['product_num'] = $data['product'] ?? 0;
        $item['keyword_num'] = $item['key'] ?? 0;
        $item['autologin_code'] = getAutoLoginCode($item['id']);
        return $item;
    }
    /**
     * @remark :查询字段处理
     * @name   :selectParam
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 10:59
     */
    public function selectParam(){
        $select = [
            'gl_project.id AS id',
            'gl_project.title AS title',
            'gl_project.channel AS channel',
            'gl_project.company AS company',
            'gl_project.type AS type',
            'gl_project.created_at AS created_at',
            'gl_project.is_language AS is_language',
            'gl_project.cooperate_date AS cooperate_date',
            'gl_project.finish_remain_day AS finish_remain_day',
            'gl_project.is_remain_today AS is_remain_today',
            'gl_project.remain_day AS remain_day',
            'gl_project_online_check.id AS online_check_id',
            'gl_project_online_check.question AS question',
            'gl_project_online_check.go_question AS go_question',
            'gl_project_online_check.optimist_status AS optimist_status',
            'gl_project_online_check.qa_status AS qa_status',
            'gl_project_payment.amount AS amount',
            'gl_project_deploy_build.dept_id AS dept_id',
            'gl_project_deploy_build.keyword_num AS key',
            'gl_project_deploy_build.service_duration AS day',
            'gl_project_deploy_build.leader_mid AS leader_mid',
            'gl_project_deploy_build.manager_mid AS manager_mid',
            'gl_project_deploy_build.designer_mid AS designer_mid',
            'gl_project_deploy_build.tech_mid AS tech_mid',
            'gl_project_deploy_build.test_domain AS test_domain',
            'gl_project_deploy_build.plan AS plan',
            'gl_project_deploy_optimize.dept_id AS optimize_dept_id',
            'gl_project_deploy_optimize.manager_mid AS optimize_manager_mid',
            'gl_project_deploy_optimize.optimist_mid AS optimize_optimist_mid',
            'gl_project_deploy_optimize.assist_mid AS optimize_assist_mid',
            'gl_project_deploy_optimize.tech_mid AS optimize_tech_mid',
            'gl_project_deploy_optimize.design_mid AS design_mid',
            'gl_project_deploy_optimize.tech_leader AS tech_leader',
            'gl_project_deploy_optimize.domain AS domain',
            'gl_project_deploy_optimize.quality_mid AS quality_mid',
            'gl_project_deploy_optimize.design_mid AS design_mid',
            'gl_project_deploy_optimize.start_date AS start_date',
        ];
        return $select;
    }

    /**
     * @remark :搜索参数处理
     * @name   :searchParam
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 10:58
     */
    public function searchParam(&$query){
        //搜索条件处理
        if(isset($this->map['title']) && !empty($this->map['title'])){
            $query = $query->where('gl_project.title','like','%'.$this->map['title'].'%');
        }
        if(isset($this->map['special']) && !empty($this->map['special'])){
            $query = $query->where('gl_project_deploy_optimize.special','like','%'.$this->map['special'].'%');
        }
        if(isset($this->map['manager_mid']) && !empty($this->map['manager_mid'])){
            $query = $query->where('gl_project_deploy_build.manager_mid','like','%'.$this->map['manager_mid'].'%');
        }
        if(isset($this->map['optimize_manager_mid']) && !empty($this->map['optimize_manager_mid'])){
            $query = $query->where('gl_project_deploy_optimize.manager_mid','like','%'.$this->map['optimize_manager_mid'].'%');
        }
        if(isset($this->map['optimize_tech_mid']) && !empty($this->map['optimize_tech_mid'])){
            $query = $query->where('gl_project_deploy_optimize.tech_mid','like','%'.$this->map['optimize_tech_mid'].'%');
        }
        if(isset($this->map['optimize_optimist_mid']) && !empty($this->map['optimize_optimist_mid'])){
            $query = $query->where('gl_project_deploy_optimize.optimist_mid','like','%'.$this->map['optimize_optimist_mid'].'%');
        }
        if(isset($this->map['optimize_assist_mid']) && !empty($this->map['optimize_assist_mid'])){
            $query = $query->where('gl_project_deploy_optimize.assist_mid','like','%'.$this->map['optimize_assist_mid'].'%');
        }
        if(isset($this->map['channel_id']) && !empty($this->map['channel_id'])){
            $query->where(function ($subQuery) {
                $subQuery->orWhere('gl_project.channel','like','%"zone_id": "'.$this->map['channel_id'].'"%')
                    ->orWhere('gl_project.channel','like','%"zone_id": '.$this->map['channel_id'].'%');
            });
        }
        if(isset($this->map['domain']) && !empty($this->map['domain'])){
            $query = $query->where('gl_project_deploy_optimize.domain','like','%'.$this->map['domain'].'%');
        }
        if(isset($this->map['test_domain']) && !empty($this->map['test_domain'])){
            $query = $query->where('gl_project_deploy_build.test_domain','like','%'.$this->map['test_domain'].'%');
        }
        $query = $query->whereIn('gl_project.type',[2,4]);//TODO::2,4代表优化项目
        return $query;
    }

    /**
     * @remark :获取项目Ai前后缀
     * @name   :getAiPrefix
     * @author :lyh
     * @method :post
     * @time   :2023/9/27 15:20
     */
    public function getAiPrefix(AiPrefix $aiPrefix){
        $info = $aiPrefix->read(['status'=>0]);
        if($info === false){
            $info = [];
        }
        $this->response('success',Code::SUCCESS,$info);
    }

    /**
     * @remark :保存数据
     * @name   :saveAiPrefix
     * @author :lyh
     * @method :post
     * @time   :2023/9/27 15:35
     */
    public function saveAiPrefix(AiPrefix $aiPrefix){
        $this->request->validate([
            'title_prefix'=>'required',
            'description_prefix'=>'required',
            'long_suffix'=>'required',
            'short_suffix'=>'required',
        ],[
            'title_prefix.required' => 'title_prefix不能为空',
            'description_prefix.required' => 'description_prefix不能为空',
            'long_suffix.required' => 'long_suffix不能为空',
            'short_suffix.required' => 'short_suffix不能为空',
        ]);
        $info = $aiPrefix->read(['status'=>0]);
        if($info === false){
            $rs = $aiPrefix->add($this->param);
        }else{
            $rs = $aiPrefix->edit($this->param,['id'=>$info['id']]);
        }
        if($rs === false){
            $this->response('系统错误，请联系管理员',Code::SYSTEM_ERROR);
        }
        $this->response('success');
    }
}