<?php

namespace App\Http\Controllers\Aside\Project;

use App\Enums\Common\Code;
use App\Helper\Arr;
use App\Helper\Country;
use App\Helper\QuanqiusouApi;
use App\Http\Controllers\Aside\BaseController;
use App\Http\Logic\Aside\Manage\ManageLogic;
use App\Http\Logic\Aside\Project\OnlineCheckLogic;
use App\Http\Logic\Aside\Project\ProcessRecordsLogic;
use App\Http\Logic\Aside\Project\ProjectLogic;
use App\Http\Requests\Aside\Project\ProcessRecordsRequest;
use App\Http\Requests\Aside\Project\ProjectRequest;
use App\Models\ASide\APublicModel;
use App\Models\Channel\Channel;
use App\Models\Channel\User;
use App\Models\Channel\Zone;
use App\Models\Com\City;
use App\Models\Com\UpdateLog;
use App\Models\Devops\ServerConfig;
use App\Models\Domain\DomainInfo;
use App\Models\HomeCount\Count;
use App\Models\Inquiry\InquirySet;
use App\Models\Manage\BelongingGroup;
use App\Models\Manage\Manage;
use App\Models\Manage\ManageHr;
use App\Models\Project\DeployBuild;
use App\Models\Project\DeployOptimize;
use App\Models\Project\Payment;
use App\Models\Project\Project;
use App\Models\Project\ProjectUpdateTdk;
use App\Models\Project\RenewLog;
use App\Models\RankData\RankData;
use App\Models\Task\Task;
use App\Models\Visit\Visit;
use App\Models\WebSetting\WebLanguage;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;


/**
 * 项目管理
 * Class ProjectController
 * @package App\Http\Controllers\Aside\Project
 * @author zbj
 * @date 2023/4/25
 */
class ProjectController extends BaseController
{

    /**
     * @remark :项目列表
     * @name   :lists
     * @author :lyh
     * @method :post
     * @time   :2023/8/30 10:11
     */
    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')
            ->leftJoin('gl_web_setting_template', 'gl_project.id', '=', 'gl_web_setting_template.project_id')
            ->where('gl_project.delete_status',Project::TYPE_ZERO);
        $query = $this->searchParam($query);
        $query = $this->orderByList($query);
        $lists = $query->paginate($this->row, $this->selectParam(), 'page', $this->page)->toArray();
        if(!empty($lists) && !empty($lists['list'])){
            foreach ($lists['list'] as $k => $v){
                $v = $this->handleParam($v);
                $lists['list'][$k] = $v;
            }
        }
        $this->response('success',Code::SUCCESS,$lists);
    }

    /**
     * 需要查询的字段
     * @return array
     */
    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.extend_type AS extend_type',
            'gl_project.uptime AS uptime',
            'gl_project.is_upgrade AS is_upgrade',
            'gl_project.created_at AS created_at',
            'gl_project.cooperate_date AS cooperate_date',
            'gl_project_online_check.id AS online_check_id',
            'gl_project_online_check.question AS 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_build.is_participle AS is_participle',
            '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.api_no AS api_no',
            'gl_web_setting_template.template_id AS template_id',
        ];
        return $select;
    }

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

    /**
     * @remark :搜索参数处理
     * @name   :searchParam
     * @author :lyh
     * @method :post
     * @time   :2023/8/18 10:58
     */
    public function searchParam(&$query){
        //参数type
        $query = $this->searchType($query);
        //根据查看权限获取项目搜索条件（必带）
        $query = $this->getManagerRole($query);
        //搜索技术组
        $query = $this->searchDept($query);
        //搜索技术人员
        $query = $this->searchManager($query);
        //按类型搜索
        $query = $this->searchContent($query);
        //搜索升级项目
        $query = $this->searchUpgrade($query);
        //搜索战队
        $query = $this->searchChannel($query);
        //其他搜索
        $query = $this->searchTechMid($query);
        return $query;
    }

    /**
     * 搜索项目状态
     * @param $query
     * @return mixed
     */
    public function searchType(&$query){
        if(isset($this->map['type'])){
            $query->where('gl_project.extend_type', '!=' ,5);
            if (in_array($this->map['type'], [Project::TYPE_ZERO, Project::TYPE_ONE, Project::TYPE_TWO, Project::TYPE_THREE]))
                $query->where('gl_project.type', $this->map['type']);
            else{
                $query->whereIn('gl_project.type', [Project::TYPE_FOUR,Project::TYPE_SIX]);
            }
        }
        if(isset($this->map['uptime']) && is_array($this->map['uptime'])){
            $query->whereBetween('gl_project.uptime', $this->map['uptime']);
        }
        return $query;
    }

    /**
     * @remark :搜索升级项目
     * @name   :searchUpgrade
     * @author :lyh
     * @method :post
     * @time   :2023/11/6 16:27
     */
    public function searchUpgrade(&$query){
        if(isset($this->map['is_upgrade'])){
            $query->where('gl_project.is_upgrade', $this->map['is_upgrade']);
        }
        return $query;
    }

    /**
     * 搜索框
     * @param $query
     * @return mixed
     */
    public function searchContent(&$query){
        if(!empty($this->map['search']) && !empty($this->map['search_type'])){
            $query->where(function ($subQuery) {
                // 搜索域名
                if ($this->map['search_type'] == 'domain') {
                    $parsedUrl = parse_url($this->map['search']);
                    $this->map['search'] = $parsedUrl['host'] ?? $this->map['search'];
                    $ids = DomainInfo::where('domain', 'like', '%'.$this->map['search'].'%')->pluck('id')->toArray();
                    $subQuery->whereIn('gl_project_deploy_optimize.domain', $ids);
                } else if($this->map['search_type'] == 'test_domain'){
                    $subQuery->where('gl_project_deploy_build.test_domain','like','%'.$this->map['search'].'%');
                } else {
                    // 搜索名称
                    $subQuery->orwhere('gl_project.company','like','%'.$this->map['search'].'%')
                        ->orwhere('gl_project.title','like','%'.$this->map['search'].'%');
                }
            });
        }
        return $query;
    }

    /**
     * @remark :搜索战队
     * @name   :searchChannel
     * @author :lyh
     * @method :post
     * @time   :2023/11/9 10:16
     */
    public function searchChannel(&$query){
        if(isset($this->map['zone_id']) && !empty($this->map['zone_id'])){
            $query->where('gl_project.channel','like','%"zone_id": "'.$this->map['zone_id'].'"%');
        }
        if(isset($this->map['channel_id']) && !empty($this->map['channel_id'])){
            $query->where('gl_project.channel','like','%"channel_id": "'.$this->map['channel_id'].'"%');
        }
        if(isset($this->map['user_id']) && !empty($this->map['user_id'])){
            $query->where('gl_project.channel','like','%"user_id": "'.$this->map['user_id'].'"%');
        }
        return $query;
    }

    /**
     * @remark :搜索技术组
     * @name   :searchDept
     * @author :lyh
     * @method :post
     * @time   :2023/9/7 18:40
     */
    public function searchDept(&$query){
        if(!empty($this->map['dept_id'])){
            $query->where(function ($subQuery) {
                $subQuery->orwhere('gl_project_deploy_build.dept_id',$this->map['dept_id'])
                    ->orwhere('gl_project_deploy_optimize.dept_id',$this->map['dept_id']);
            });
        }
        return $query;
    }

    /**
     * @remark :搜索售后技术
     * @name   :searchTechMid
     * @author :lyh
     * @method :post
     * @time   :2024/3/4 14:58
     */
    public function searchTechMid(&$query){
        if(isset($this->map['tech_mid'])){
            $query = $query->where('gl_project_deploy_optimize.tech_mid',$this->map['tech_mid']);
        }
        if(isset($this->map['optimize_optimist_mid'])){
            $query = $query->where('gl_project_deploy_optimize.optimist_mid',$this->map['optimize_optimist_mid']);
        }
        return $query;
    }

    /**
     * @remark :访问权限
     * @name   :getManagerRole
     * @author :lyh
     * @method :post
     * @time   :2023/9/7 17:28
     */
    public function getManagerRole(&$query){
        if(($this->manage['role'] != 1)){//1代表查看所有
            //获取用户所在组
            $managerHr = new ManageHr();
            $info = $managerHr->read(['manage_id'=>$this->manage['id']]);
            //获取当前用户自己的项目
            $query->where(function ($subQuery) use ($info) {
                $subQuery->whereIn('gl_project.id',[1])//项目1+项目3默认显示
                    ->orWhere('gl_project_deploy_build.leader_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_build.manager_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_build.designer_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_build.tech_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_optimize.manager_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_optimize.optimist_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_optimize.assist_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_optimize.tech_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_optimize.tech_leader', $this->manage['id'])
                    ->orWhere('gl_project_deploy_optimize.quality_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_optimize.design_mid', $this->manage['id'])
                    ->orWhere('gl_project_deploy_build.dept_id', $info['belong_group'])
                    ->orWhere('gl_project_deploy_optimize.dept_id', $info['belong_group']);
            });
        }
        return $query;
    }

    /**
     * @remark :搜索技术人员
     * @name   :searchManager
     * @author :lyh
     * @method :post
     * @time   :2023/9/7 17:16
     */
    public function searchManager(&$query)
    {
        if (!empty($this->map['manage_id'])) {
            $query->where(function ($subQuery) {
                $subQuery->orWhere('gl_project_deploy_build.leader_mid', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_build.manager_mid', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_build.designer_mid', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_build.tech_mid', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_optimize.manager_mid', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_optimize.optimist_mid', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_optimize.assist_mid', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_optimize.tech_mid', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_optimize.tech_leader', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_optimize.quality_mid', $this->map['manage_id'])
                    ->orWhere('gl_project_deploy_optimize.design_mid', $this->map['manage_id']);
            });
        }
        return $query;
    }

    /**
     * @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 ManageHr();
        $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['quality_mid_name'] = $manageModel->getName($item['quality_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'] = $data['key'] ?? 0;
        $item['autologin_code'] = getAutoLoginCode($item['id']);
        $item['article_num'] = ($data['blog'] ?? 0) + ($data['news'] ?? 0);
        $item['task_finish_num'] = Task::getNumByProjectId($item['id'], Task::STATUS_DOWN);
        $item['task_pending_num'] = Task::getNumByProjectId($item['id'], [Task::STATUS_DONGING, Task::STATUS_WAIT]);
        $item['collect_time'] = $item['is_upgrade'] ? UpdateLog::getProjectUpdate($item['id']) : '';
        return $item;
    }

    /**
     * @remark :获取数据详情
     * @name   :info
     * @author :lyh
     * @method :post
     * @time   :2023/8/17 16:42
     */
    public function info(ProjectLogic $logic){
        $this->request->validate([
            'id'=>'required'
        ],[
            'id.required' => 'ID不能为空'
        ]);
        $data = $logic->getProjectInfo($this->param['id']);
        $this->response('success',Code::SUCCESS,$data);
    }

    /**
     * @remark :逻辑删除
     * @name   :deleteMinorLanguages
     * @author :lyh
     * @method :post
     * @time   :2024/6/18 11:53
     */
    public function deleteMinorLanguages(ProjectLogic $logic){
        $this->request->validate([
            'id'=>'required'
        ],[
            'id.required' => 'ID不能为空'
        ]);
        $data = $logic->deleteMinorLanguages();
        $this->response('success',Code::SUCCESS,$data);
    }

    /**
     * @remark :保存数据
     * @name   :save
     * @author :lyh
     * @method :post
     * @time   :2023/8/17 16:42
     */
    public function save(ProjectLogic $logic)
    {
        $this->request->validate([
            'type'=>'required'
        ],[
            'type.required' => '类型不能为空'
        ]);
        $logic->projectSave();
        $this->response('success');
    }

    /**
     * 询盘通知设置
     * @author zbj
     * @date 2023/5/17
     */
    public function inquiry_set(Request $request, ProjectLogic $logic){
        $request->validate([
            'project_id'=>'required'
        ],[
            'project_id.required' => '项目ID不能为空'
        ]);
        if($request->isMethod('get')){
            $data = InquirySet::where('project_id', $request->project_id)->first();
            if(!$data){
                $data = ['emails' => '', 'phones' => ''];
            }else{
                $data = $data->toArray();
            }
            $this->response('success',Code::SUCCESS,$data);
        }
        $data = $logic->saveInquirySet($this->param);
        $this->response('success',Code::SUCCESS,$data);
    }


    /**
     * @remark :项目相关数据
     * @name   :data_source
     * @author :lyh
     * @method :post
     * @time   :2023/12/7 10:41
     */
    public function data_source(ProjectLogic $logic){
        $data = $logic->dataSource();
        $this->response('success',Code::SUCCESS,$data);
    }

    /**
     * 省市数据源
     * @author zbj
     * @date 2023/6/27
     */
    public function city_source(){
        $data = City::source($this->param['id'] ?? 0);
        $this->response('success',Code::SUCCESS,$data);
    }

    /**
     * 渠道数据源
     * @author zbj
     * @date 2023/6/27
     */
    public function channel_source(ProjectLogic $logic){
        $data = $logic->channelSource($this->param);
        $this->response('success',Code::SUCCESS,$data);
    }

    /**
     * 进程记录
     * @author zbj
     * @date 2023/6/25
     */
    public function get_process_records(Request $request, ProcessRecordsLogic $logic){
        $request->validate([
            'project_id'=>'required'
        ],[
            'project_id.required' => '项目ID不能为空'
        ]);
        $data = $logic->getInfo($this->param['project_id']);
        $this->response('success',Code::SUCCESS,$data);
    }

    /**
     * 保存进程记录
     * @author zbj
     * @date 2023/6/25
     */
    public function save_process_records(ProcessRecordsRequest $request, ProcessRecordsLogic $logic){
        $request->validated();
        $logic->recordSave();
        $this->response('success');
    }

    /**
     * 获取合同票据
     * @author zbj
     * @date 2023/6/27
     */
    public function get_contract_bill(Request $request){
        $request->validate([
            'id'=>'required'
        ],[
            'id.required' => 'ID不能为空'
        ]);
        $payment = Payment::where('project_id', $this->param['id'])->select(['contract', 'bill'])->first();
        $data = $payment->makeVisible(['contract', 'bill']);
        $this->response('success',Code::SUCCESS,$data ? $data->toArray() : []);
    }

    /**
     * @remark :提交审核
     * @name   :submit_check
     * @author :lyh
     * @method :post
     * @time   :2023/12/2 9:59
     */
    public function submit_check(OnlineCheckLogic $logic){
        $this->request->validate([
            'id'=>'required'
        ],[
            'id.required' => 'ID不能为空'
        ]);
        $logic->saveOnlineCheck();
        $this->response('success');
    }

    /**
     * @remark :上线审核
     * @name   :online_check
     * @author :lyh
     * @method :post
     * @time   :2023/8/30 19:01
     */
    public function online_check(OnlineCheckLogic $logic){
        $this->request->validate([
            'id'=>'required',
            'type'=>'required|in:optimist,qa',
            'status'=>'required|in:0,1'
        ],[
            'id.required' => 'ID不能为空',
            'type.required' => '请选择审核类型',
            'type.in' => '审核类型值无效',
            'status.required' => '请选择审核状态',
            'status.in' => '审核状态值无效',
        ]);
        $logic->onlineCheck();
        $this->response('success');
    }

    /**
     * @remark :获取组
     * @name   :getBelongingGroup
     * @author :lyh
     * @method :post
     * @time   :2023/8/4 16:27
     */
    public function getBelongingGroup(){
        $this->request->validate([
            'type'=>'required',
        ],[
            'type.required' => '请选择审核类型'
        ]);
        $belongGroupModel = new BelongingGroup();
        $lists = $belongGroupModel->list($this->map,'name',['id','name','type'],'asc');
        $this->response('success',Code::SUCCESS,$lists);
    }

    /**
     * @remark :根据用户组获取成员
     * @name   :getManager
     * @author :lyh
     * @method :post
     * @time   :2023/8/8 10:29
     */
    public function getManagerList(){
        $hrManagerModel = new ManageHr();
        if(!isset($this->param['name']) || empty($this->param['name'])){
            $this->map['status'] = $hrManagerModel::STATUS_ONE;
        }
        if(isset($this->map['entry_position']) && !empty($this->map['entry_position'])){
            $this->map['entry_position'] = ['in',$this->map['entry_position']];
        }
        $lists = $hrManagerModel->list($this->map,['sort','id'],['id','manage_id','name','entry_position','is_leader']);
        $this->response('success',Code::SUCCESS,$lists);
    }

    /**
     * @remark :获取项目服务器与数据库列表
     * @name   :getServiceConfig
     * @author :lyh
     * @method :post
     * @time   :2023/8/14 10:23 todo::后面删除
     */
    public function getServiceConfig(){
        $serviceConfigModel = new ServerConfig();
        $list = $serviceConfigModel->list($this->param,'id',['id','type','title','count','init_domain','service_type']);
        $this->response('success',Code::SUCCESS,$list);
    }

    /**
     * @remark :获取域名列表
     * @name   :getDomain
     * @author :lyh
     * @method :post
     * @time   :2023/8/14 10:29
     */
    public function getDomain(){
        $this->request->validate([
            'project_id'=>'required',
        ],[
            'project_id.required' => 'project_id不能为空',
        ]);
        $domainModel = new DomainInfo();
        $list = $domainModel->list(['status'=>0,'project_id'=>['or',$this->param['project_id']]]);
        $this->response('success',Code::SUCCESS,$list);
    }

    /**
     * 通过企业名称查询项目是否在服务中， 有项目并且在服务中的返回1， 其他的返回0
     * @author zbj
     * @date 2023/9/4
     */
    public function getProjectInService(){
        $company = $this->param['company'];
        if(!$company){
            $this->response('企业名称必传',Code::SYSTEM_ERROR);
        }
        $project = Project::where('company', $company)->first();
        if($project && ($project['remain_day'] > 0 || in_array($project['type'], [0, 1,6]))){
            $in_service = 1;
        }else{
            $in_service = 0;
        }
        $this->response('success',Code::SUCCESS, ['in_service' => $in_service]);
    }

    /**
     * @remark :逻辑删除项目
     * @name   :del
     * @author :lyh
     * @method :post
     * @time   :2023/9/8 15:21
     */
    public function del(ProjectLogic $logic){
        $this->request->validate([
            'id'=>'required',
        ],[
            'id.required' => 'id不能为空',
        ]);
        $logic->projectDel();
        $this->response('success');
    }

    /**
     * 根据渠道商查询项目
     * @author zbj
     * @date 2023/9/11
     */
    public function getProjectByChannel(){
        $id = $this->param['id'] ?? '';
        $notice_order_id = $this->param['notice_order_id'] ?? '';
        $source_id = $this->param['channel_id'] ?? 0; //原系统渠道id
        $size = $this->param['page_size'] ?? 20;
        $type = $this->param['type'] ?? '';
        $company = $this->param['company'] ?? '';

        if(!$source_id && !$id){
            $this->response('参数异常',Code::SYSTEM_ERROR);
        }
        $channel_id = 0;
        if($source_id){
            $channel = Channel::where('source_id', $source_id)->first();
            if(!$channel){
                $this->response('渠道不存在',Code::SYSTEM_ERROR);
            }
            $channel_id = $channel->id;
        }

        if ($id){
            if(!is_array($id)){
                $id = explode(',', $id);
            }
        }
        if ($notice_order_id){
            if(!is_array($notice_order_id)){
                $notice_order_id = explode(',', $notice_order_id);
            }
        }

        $data = Project::with(['deploy_build', 'deploy_optimize', 'online_check'])
            ->where('delete_status', 0)
            ->where(function ($query) use ($channel_id, $type, $company, $id, $notice_order_id){
            if ($channel_id) {
                $query->where('channel->channel_id', $channel_id);
            }
            if ($type) {
                $query->where('type', $type);
            }
            if ($company) {
                $query->where('company', 'like', '%' . $company . '%');
            }
            if ($id) {
                $query->whereIn('id', $id);
            }
            if ($notice_order_id) {
                $query->whereIn('notice_order_id', $notice_order_id);
            }
        })->orderBy('id', 'desc')->paginate($size)->toArray();
        $list = [];
        foreach ($data['list'] as $item){
            $domain = '';
            if ($item['deploy_optimize']['domain']) {
                $domain_pro = DomainInfo::where('id', $item['deploy_optimize']['domain'])->first();
                $domain_array = parse_url($domain_pro ? $domain_pro->domain : '');
                $domain = $domain_array['host'] ?? $domain_array['path'];
            }
            $manage = new Manage();
            $param = [
                  "id" => $item['id'],
                  "title" => $item['title'],
                  "company" => $item['company'],
                  "type" => $item['type'],
                  "type_text" => Project::typeMap()[$item['type']] ?? '',
                  "channel" => $item['channel'],
                  "created_at" => $item['created_at'],
                  "updated_at" => $item['updated_at'],
                  "post_id" => $item['post_id'],
                  "from_order_id" =>  $item['from_order_id'],
                  "remain_day" => $item['remain_day'],
                  "last_inquiry_time" => $item['last_inquiry_time'],
                  "plan" => $item['deploy_build']['plan'] ?: 0,
                  "plan_text" => Project::planMap()[$item['deploy_build']['plan']] ?? '',
                  "start_date" => $item['deploy_optimize']['start_date'] ?? '',
                  "domain" => $domain ? 'https://' . $domain : $domain,
                  "test_domain" => $item['deploy_build']['test_domain'] ?? '',
//                  "online_time" => $item['online_check']['qa_check_time'] ?? '',
                  "online_time" => $item['uptime'] ?? '',
                  "cooperate_date" => $item['cooperate_date'],
                  "project_manager_name" => $manage->getName($item['deploy_build']['manager_mid']), //项目经理
                  "after_sales_manager_name" => $manage->getName($item['deploy_optimize']['manager_mid']), //售后服务经理
                  "leader_name" => $manage->getName($item['deploy_build']['leader_mid']), //组长
            ];
            if ($item['type'] == Project::TYPE_TWO) {
                $param['is_compliance'] = RankData::where('project_id', $item['id'])->where('lang', '')->value('is_compliance') ?: 0;
            } else {
                $param['is_compliance'] = 1;
            }
            $yesterday_count = Count::where('project_id', $item['id'])->where('date', date('Y-m-d', strtotime('-1 day')))->first();
            $today_count = Count::where('project_id', $item['id'])->where('date', date('Y-m-d'))->first();
            $param['yesterday_ip_count'] = $yesterday_count['ip_num'] ?? 0;
            $param['today_ip_count'] = $today_count['ip_num'] ?? 0;
            $param['inquiry_num'] = $today_count['inquiry_num'] ?? 0;

            $list[] = $param;
        }
        $data['list'] = $list;
        $this->response('success',Code::SUCCESS, $data);
    }

    /**
     * @remark :获取已续费的续费单日志
     * @name   :getRenewLog
     * @author :lyh
     * @method :post
     * @time   :2023/9/28 9:09
     */
    public function getRenewLog(RenewLog $renewLog){
        $lists = $renewLog->lists($this->map,$this->page,$this->row,$this->order);
        $this->response('success',Code::SUCCESS,$lists);
    }

    /**
     * @remark :tdk更新记录
     * @name   :tdkList
     * @author :lyh
     * @method :post
     * @time   :2023/11/8 11:17
     */
    public function tdkList(){
        $this->request->validate([
            'project_id'=>'required',
        ],[
            'project_id.required' => '项目ID不能为空',
        ]);
        $tdkModel = new ProjectUpdateTdk();
        $list = $tdkModel->list(['project_id'=>$this->map['project_id']],'id',['*'],'desc',5);
        if(!empty($list)){
            foreach ($list as $k => $v){
                $list[$k] = $this->handleTdk($v);
            }
        }
        $this->response('success',Code::SUCCESS,$list);
    }

    /**
     * @remark :处理tdk
     * @name   :handleTdk
     * @author :lyh
     * @method :post
     * @time   :2023/12/29 11:16
     */
    public function handleTdk($item){
        $data = [
            'gl_product'=>'产品',
            'gl_product_category'=>'产品分类',
            'gl_product_keyword'=>'产品关键字',
            'gl_news'=>'新闻',
            'gl_news_category'=>'新闻分类',
            'gl_blog'=>'博客',
            'gl_blog_category'=>'博客分类',
            'gl_web_custom_template'=>'自定义页面',
        ];
        foreach ($data as $k => $v){
            if(isset($item[$k])){
                $data = Arr::s2a($item[$k]);
                //{"des": 3500, "title": 0, "keyword": 3501, "total_page": 8458, "keyword_title": 3500, "keyword_content": 3500}
                $item[$k] = $v.'总条数：'.$data['total_page'].
                    ', title更新数：'.$data['title'].
                    ',keyword更新数：'.$data['keyword'].
                    ',des更新数：'.$data['des'];
                if($k == 'gl_product_keyword'){
                    $item[$k] .= ',keyword_title更新数：'.($data['keyword_title']??0);
                    $item[$k] .= ',keyword_content更新数：'.($data['keyword_content']??0);
                }
            }

        }
        return $item;
    }

    /**
     * @remark :复制项目
     * @name   :copyProject
     * @author :lyh
     * @method :post
     * @time   :2023/11/8 14:17
     */
    public function copyProject(ProjectLogic $logic){
        $this->request->validate([
            'project_id'=>'required',
        ],[
            'project_id.required' => 'project_id不能为空',
        ]);
        $data = $logic->copyProject();
        $this->response('success',Code::SUCCESS,$data);
    }

    /**
     * AICC采集数据接口token
     * @author zbj
     * @date 2023/11/10
     */
    public function site_token(Request $request, ProjectLogic $logic){
        $this->request->validate([
            'project_id'=>'required',
        ],[
            'project_id.required' => 'project_id不能为空',
        ]);
        $token = $logic->getSiteToken($this->map);
        $this->response('success',Code::SUCCESS,['site_token' => $token]);
    }

    /**
     * @remark :单独保存其他项目配置
     * @name   :saveOtherProject
     * @author :lyh
     * @method :post
     * @time   :2023/11/17 15:23
     */
    public function saveOtherProject(ProjectLogic $logic){
        $this->request->validate([
            'id'=>'required',
            'aicc'=>'required',
            'hagro'=>'required',
            'exclusive_aicc_day'=>'required',
            'exclusive_hagro_day'=>'required',
        ],[
            'id.required' => 'id不能为空',
            'aicc.required' => 'aicc是否开启不能为空',
            'hagro.required' => 'hagro是否开启不能为空',
            'exclusive_aicc_day.required' => '服务天数不能为空',
            'exclusive_hagro_day.required' => '服务天数不能为空',
        ]);
        $logic->saveOtherProject();
        $this->response('success');
    }

    /**
     * @remark :获取其他项目配置
     * @name   :getOtherProject
     * @author :lyh
     * @method :post
     * @time   :2023/11/17 15:23
     */
    public function getOtherProject(ProjectLogic $logic){
        $this->request->validate([
            'id'=>'required',
        ],[
            'id.required' => 'id不能为空',
        ]);
        $info = $logic->getOtherProject();
        $this->response('success',Code::SUCCESS,$info);
    }

    /**
     * @remark :获取渠道信息
     * @name   :getChannel
     * @author :lyh
     * @method :post
     * @time   :2023/11/17 16:08
     */
    public function getChannel(){
        $zoneModel = new Zone();
        $zone_list = $zoneModel->list();
        $channelModel = new Channel();
        $channelUserModel = new User();
        foreach ($zone_list as $k => $v){
            $channel_list = $channelModel->list(['zone_id'=>$v['id']]);
            foreach ($channel_list as $k1 => $v1){
                $user_list = $channelUserModel->list(['channel_id'=>$v1['id']]);
                $channel_list[$k1]['sub'] = $user_list;
            }
            $zone_list[$k]['sub'] = $channel_list;
        }
        $this->response('success',Code::SUCCESS,$zone_list);
    }

    /**
     * @remark :获取小语种列表
     * @name   :lists
     * @author :lyh
     * @method :post
     * @time   :2023/11/30 10:59
     */
    public function languageLists(){
        $webLanguageModel = new WebLanguage();
        $lists = $webLanguageModel->list();
        $this->response('success',Code::SUCCESS,$lists);
    }

    /**
     * 获取国家地区列表
     * @author zbj
     * @date 2024/1/19
     */
    public function countryLists(){
        $this->response('success',Code::SUCCESS, Country::getCountryList());
    }

    /**
     * 保存询盘过滤配置
     * @author zbj
     * @date 2024/1/19
     */
    public function saveInquiryFilterConfig(ProjectLogic $logic){
        $this->request->validate([
            'project_id'=>'required',
        ],[
            'project_id.required' => '项目id不能为空',
        ]);
        $logic->saveInquiryFilterConfig($this->param);
        $this->response('success');
    }

    /**
     * 保存引流设置
     * @author zbj
     * @date 2024/3/29
     */
    public function saveWebTrafficConfig(ProjectLogic $logic){
        $this->request->validate([
            'project_id'=>'required',
        ],[
            'project_id.required' => '项目id不能为空',
        ]);
        $logic->saveWebTrafficConfig($this->param);
        $this->response('success');
    }

    /**
     * @remark :更新项目的管理员
     * @name   :updateProjectManager
     * @author :lyh
     * @method :post
     * @time   :2024/4/7 10:41
     */
    public function updateProjectManager(ProjectLogic $logic){
        $this->request->validate([
            'old_id'=>'required',
            'new_id'=>'required'
        ],[
            'old_id.required' => '参数不能为空',
            'new_id.required' => '参数不能为空',
        ]);
        //查看当前用户是否存在
        $hrModel = new ManageHr();
        $oldHrInfo = $hrModel->read(['id'=>$this->param['old_id']]);
        if($oldHrInfo === false){
            $this->response('当前用户不存在',Code::SYSTEM_ERROR);
        }
        $newHrInfo = $hrModel->read(['id'=>$this->param['new_id'],'status'=>1]);
        if($newHrInfo === false){
            $this->response('变更的用户不存在',Code::SYSTEM_ERROR);
        }
        if($oldHrInfo['entry_position'] != $newHrInfo['entry_position']){
            $this->response('不同岗位不允许变更',Code::SYSTEM_ERROR);
        }
        $logic->getManagerFiled($newHrInfo['entry_position'],$this->param['old_id'],$this->param['new_id'],$this->param['project_id'] ?? []);
        $this->response('success');
    }

    /**
     * @remark :开启与关闭分词搜索
     * @name   :setIsParticiple
     * @author :lyh
     * @method :post
     * @time   :2024/6/19 10:07
     */
    public function setIsParticiple(){
        $this->request->validate([
            'project_id'=>'required',
            'is_participle'=>'required'
        ],[
            'project_id.required' => '项目id不能为空',
            'is_participle.required' => '项目id不能为空',
        ]);
        $deployBuildModel = new DeployBuild();
        $deployBuildModel->edit(['is_participle'=>$this->param['is_participle']],['project_id'=>$this->param['project_id']]);
        $this->response('success');
    }
}