<?php

namespace App\Http\Controllers\Aside\Project;

use App\Enums\Common\Code;
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\Com\City;
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\RankData\RankData;
use App\Models\Task\Task;
use App\Models\Visit\Visit;
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');
        $query = $this->searchParam($query);
        $lists = $query->orderBy('gl_project.id', 'desc')->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);
    }

    /**
     * @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);
        return $query;
    }

    /**
     * @remark :type类型
     * @name   :searchType
     * @author :lyh
     * @method :post
     * @time   :2023/8/30 10:14
     */
    public function searchType(&$query){
        $query->where('gl_project.delete_status',Project::TYPE_ZERO);
        if(!isset($this->map['type'])){
            $this->map['type'] = Project::TYPE_ZERO;
        }
        if($this->map['type'] == Project::TYPE_ZERO){
            $query->where('gl_project.type',Project::TYPE_ZERO);
        }elseif ($this->map['type'] == Project::TYPE_ONE){
            $query->where('gl_project.type',Project::TYPE_ONE);
        }elseif ($this->map['type'] == Project::TYPE_TWO){
            $query->whereIn('gl_project.type', [Project::TYPE_TWO,Project::TYPE_THREE]);
        }else{
            $query->whereIn('gl_project.type', [Project::TYPE_FOUR,Project::TYPE_SIX]);
        }
        return $query;
    }

    /**
     * @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.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_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_payment.amount AS amount',
        ];
        return $select;
    }

    /**
     * @remark :按需搜索
     * @name   :searchDomainTitle
     * @author :lyh
     * @method :post
     * @time   :2023/9/7 18:39
     */
    public function searchContent(&$query){
        if(!empty($this->map['search']) && !empty($this->map['search_type'])){
            //搜索域名
            $query->where(function ($subQuery) {
                $subQuery->orwhere('gl_project_deploy_optimize.domain','like','%'.$this->map['search'].'%')
                         ->orwhere('gl_project.company','like','%'.$this->map['search'].'%')
                         ->orwhere('gl_project.title','like','%'.$this->map['search'].'%');
            });
        }
        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   :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->where('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 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']);
        $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]);
        return $item;
    }

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

    /**
     * @remark :保存数据
     * @name   :save
     * @author :lyh
     * @method :post
     * @time   :2023/8/17 16:42
     */
    public function save(ProjectRequest $request, ProjectLogic $logic)
    {
        $request->validated();
        $logic->projectSave();
        $this->response('success');
    }

    /**
     * 询盘通知设置
     * @param ProjectRequest $request
     * @param ProjectLogic $logic
     * @return \Illuminate\Http\JsonResponse
     * @throws \Psr\Container\ContainerExceptionInterface
     * @throws \Psr\Container\NotFoundExceptionInterface
     * @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);
    }


    /**
     * 数据源
     * @param ProjectLogic $logic
     * @return \Illuminate\Http\JsonResponse
     * @throws \Psr\Container\ContainerExceptionInterface
     * @throws \Psr\Container\NotFoundExceptionInterface
     * @author zbj
     * @date 2023/6/20
     */
    public function data_source(ProjectLogic $logic){
        $data = $logic->dataSource();
        $this->response('success',Code::SUCCESS,$data);
    }

    /**
     * 省市数据源
     * @param ProjectLogic $logic
     * @return \Illuminate\Http\JsonResponse
     * @throws \Psr\Container\ContainerExceptionInterface
     * @throws \Psr\Container\NotFoundExceptionInterface
     * @author zbj
     * @date 2023/6/27
     */
    public function city_source(){
        $data = City::source($this->param['id'] ?? 0);
        $this->response('success',Code::SUCCESS,$data);
    }

    /**
     * 渠道数据源
     * @param ProjectLogic $logic
     * @return \Illuminate\Http\JsonResponse
     * @throws \Psr\Container\ContainerExceptionInterface
     * @throws \Psr\Container\NotFoundExceptionInterface
     * @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() : []);
    }

    /**
     * 提交审核
     * @author zbj
     * @date 2023/6/29
     */
    public function submit_check(Request $request, OnlineCheckLogic $logic){
        $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->param);
        $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();
        $this->map['status'] = $hrManagerModel::STATUS_ONE;
        if(isset($this->map['entry_position']) && is_array($this->map['entry_position'])){
            $this->map['entry_position'] = ['in',$this->map['entry_position']];
        }
        $lists = $hrManagerModel->list($this->map,'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
     */
    public function getServiceConfig(){
        $serviceConfigModel = new ServerConfig();
        $list = $serviceConfigModel->list($this->param,'id',['id','type','title']);
        $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(){
        $source_id = $this->param['channel_id']; //原系统渠道id
        $size = $this->param['page_size'] ?? 20;
        $type = $this->param['type'] ?? '';
        $company = $this->param['company'] ?? '';
        $channel = Channel::where('source_id', $source_id)->first();
        if(!$channel){
            $this->response('渠道不存在',Code::SYSTEM_ERROR);
        }

        $data = Project::with(['deploy_build', 'deploy_optimize', 'online_check'])->where('channel->channel_id', $channel->id)->where(function ($query) use ($type, $company){
            if ($type) {
                $query->where('type', $type);
            }
            if ($company) {
                $query->where('company', 'like', '%' . $company . '%');
            }
        })->orderBy('id', 'desc')->paginate($size)->toArray();
        $list = [];
        foreach ($data['list'] as $item){
            $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" => $item['deploy_optimize']['domain'] ?? '',
                  "test_domain" => $item['deploy_build']['test_domain'] ?? '',
                  "online_time" => $item['online_check']['qa_check_time'] ?? '',
                  "cooperate_date" => $item['cooperate_date'],
            ];
            if ($item['type'] == 3) {
                $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);
    }
}