<?php

namespace App\Models\Project;

use App\Helper\Arr;
use App\Helper\Translate;
use App\Models\Base;
use App\Models\Devops\ServerConfig;
use App\Models\Optimize\Process;
use App\Services\Facades\Upload;
use Illuminate\Support\Facades\Cache;
use App\Models\Domain\DomainInfo as DomainInfoModel;
use Illuminate\Support\Str;

class Project extends Base
{
    //设置关联表名
    protected $table = 'gl_project';

    const DATABASE_NAME_FIX = 'gl_data_';
    const CUSTOMIZED_ONE = 1;//定制项目
    const DEMO_PROJECT_ID = 1;
    const STATUS_ONE = 1;//审核通过
    const TYPE_ZERO = 0;//初始导入项目
    const TYPE_ONE = 1;//建站中
    const TYPE_TWO = 2;//建站完成（推广）
    const TYPE_THREE = 3;//建站完成
    const TYPE_FOUR = 4;//推广续费
    const TYPE_FIVE = 5;//未续费网站
    const TYPE_SIX = 6;//特殊推广项目
    const TYPE_SEVEN = 7;//错误单
    const TYPE_CLOSE = 8;//关闭项目
    const MYSQL_ID = 2;//默认数据库id
    const IS_UPGRADE_FALSE = 0;
    const IS_UPGRADE_TRUE = 1;

    const IS_DEL_FALSE = 0;
    const IS_DEL_TRUE = 1;

    const PROJECT_TYPE_SEO = 1;//白帽seo项目


    //版本信息
    const VERSION_ZERO = 0;//普通版本
    const VERSION_SIX = 6;//6.0版本
    const VERSION_SEVEN = 7;//7.0版本
    /**
     * 星级客户
     * @return string[]
     * @author zbj
     * @date 2023/4/25
     */
    public static function levelMap()
    {
        return [
//            1 => '★★★Ads-Customer',
            2 => '暂停优化',
            3 => '告知书一',
            4 => '告知书二',
            5 => 'Q告知书二',
            6 => 'KA',
            7 => 'CKA',
        ];
    }

    /**
     * @remark :aiBlog发布频率
     * @name   :typeBlogFrequency
     * @author :lyh
     * @method :post
     * @time   :2025/3/15 10:29
     */
    public static function typeBlogFrequency($val = 0){
        $arr = [
            1=>'1-2',
            2=>'2-3',
            3=>'2-4',
            4=>'3-5',
            5=>'5-7',
        ];
        if($val){
            return $arr[$val] ?? '';
        }
        return $arr;
    }


    /**
     * 项目类型
     * @return string[]
     * @author zbj
     * @date 2023/4/26
     * @remark project表中（extend_type + type）的属性值
     */
    public static function typeMap()
    {
        return [
            1 => '建站进程中',
            2 => '已完成–推广进程中',
            3 => '已完成-建站用户',
            4 => '推广续网站',
            5 => '未续费项目',
            6 => '特殊推广项目',
            7 => '提单错误转续费',
            8 => '关闭项目',
        ];
    }

    /**
     * 项目版本
     * @return array
     */
    public static function planMap()
    {
        return [
            1 => '标准版',
            2 => '商务版',
            3 => '旗舰版',
            4 => '【PLUS】尊贵版',
            5 => '【PLUS】至尊版',
            6 => '自主建站（定制器）',
            7 => '定制建站（PS订制）',
            8 => '星链网站（1年版）',
            9 => '星链网站（2年版）',
            10 => '专业版',
            11 => '俄语标准版',
            12 => '俄语商务版',
            14 => '俄语旗舰版',
            13 => '体验版',
            15 => 'CKA方案半托管',
            16 => 'CKA方案全托管',
            17 => '多语言版',
        ];
    }

    public static function seoMap()
    {
        return [
            1 => '白帽SEO方案'
        ];
    }
    /**
     * @remark :优化搜索参数
     * @name   :specialMap
     * @author :lyh
     * @method :post
     * @time   :2024/6/21 16:23
     */
    public static function specialMap()
    {
        return [
            1 => '自建站项目',
            2 => '重点跟进',
            3 => '经典案例',
            4 => '全球搜案例库',
            5 => '设计师精美网站',
            18 => '多语言案例',
            6 => '可登陆后台',
            7 => 'T项目',
            8 => '特殊前后缀',
            9 => '推广续费',
            10 => '案例渠道',
            11 => 'Ads',
            12 => 'AI',
            13 => 'AI站群',
            14 => '未达标',
            15 => 'AI案例',
            16 => '6.0广告',
            17 => '超哥监控项目',
            19 => '商城案例',
        ];
    }

    /**
     * @remark :新增搜索
     * @name   :searchParam
     * @author :lyh
     * @method :post
     * @time   :2024/6/21 16:23
     */
    public static function searchParam(){
        return [
            1 => 'AI视频',
        ];
    }

    /**
     * 项目部署服务器信息
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function serverConfig()
    {
        return self::hasOne(ServerConfig::class, 'id', 'serve_id');
    }

    /**
     * 项目部署mysql数据库信息
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function mysqlConfig()
    {
        return self::hasOne(ServerConfig::class, 'id', 'mysql_id');
    }

    /**
     * 项目使用Redis服务器信息， 如果没有即使用默认配置
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     */
    public function redisConfig()
    {
        return self::hasOne(ServerConfig::class, 'id', 'redis_id');
    }

    /**
     * 获取项目对应数据库名称
     * 初始化数据库、数据表迭代等功能使用
     * TODO 如果前缀变更，请使用该方法进行处理
     * @return string
     */
    public function databaseName()
    {
        //TODO::上线打开
//        return self::DATABASE_NAME_FIX . 1;
        return self::DATABASE_NAME_FIX . $this->id;
    }

    /**
     * 付款续费信息
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     * @author zbj
     * @date 2023/4/26
     */
    public function payment()
    {
        return self::hasOne(Payment::class, 'project_id', 'id');
    }

    /**
     * @remark :上线审核
     * @name   :process
     * @author :lyh
     * @method :post
     * @time   :2023/7/20 14:25
     */
    public function online_check()
    {
        return self::hasOne(OnlineCheck::class, 'project_id', 'id');
    }

    /**
     * 建站部署信息
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     * @author zbj
     * @date 2023/4/26
     */
    public function deploy_build()
    {
        return self::hasOne(DeployBuild::class, 'project_id', 'id');
    }

    /**
     * 建站部署信息
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     * @author zbj
     * @date 2023/4/26
     */
    public function deploy_optimize()
    {
        return self::hasOne(DeployOptimize::class, 'project_id', 'id');
    }

    /**
     * @remark :转售后
     * @name   :after
     * @author :lyh
     * @method :post
     * @time   :2023/8/17 16:24
     */
    public function project_after()
    {
        return self::hasOne(After::class, 'project_id', 'id');
    }

    /**
     * @remark :项目关键字
     * @name   :project_keyword
     * @author :lyh
     * @method :post
     * @time   :2024/7/22 11:38
     */
    public function project_keyword()
    {
        return self::hasOne(ProjectKeyword::class, 'project_id', 'id');
    }
    /**
     * 询盘过滤配置
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     * @author zbj
     * @date 2024/1/19
     */
    public function inquiry_filter_config()
    {
        return self::hasOne(InquiryFilterConfig::class, 'project_id', 'id');
    }

    /**
     * 引流配置
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     * @author zbj
     * @date 2024/3/29
     */
    public function web_traffic_config()
    {
        return self::hasOne(WebTrafficConfig::class, 'project_id', 'id');
    }

    /**
     * 域名
     * @return \Illuminate\Database\Eloquent\Relations\HasOne
     * @author zbj
     */
    public function domainInfo()
    {
        return self::hasOne(\App\Models\Domain\DomainInfo::class, 'project_id', 'id')->select('project_id', 'domain');
    }


    public function setLevelAttribute($value)
    {
        $this->attributes['level'] = Arr::arrToSet($value);
    }

    public function getLevelAttribute($value)
    {
        return Arr::setToArr($value);
    }

    public function setChannelAttribute($value)
    {
        $this->attributes['channel'] = Arr::a2s($value);
    }

    public function getChannelAttribute($value)
    {
        $value = Arr::s2a($value);
        foreach ($value as $k => $v){
            $v = (string)$v;
            $value[$k] = $v;
        }
        return $value;
    }

    public function setNoticeFileAttribute($value)
    {
        foreach ($value as &$v) {
            $v['url'] = str_replace_url($v['url']);
        }
        $this->attributes['notice_file'] = Arr::a2s($value);
    }

    public function getNoticeFileAttribute($value)
    {
        if(!empty($value)) {
            $value = Arr::s2a($value);
            foreach ($value as &$v) {
                if(!empty($v['url'])){
                    $v['url'] = getFileUrl($v['url']);
                }
            }
        }
        return $value;
    }

    public function setConfirmFileAttribute($value)
    {
        foreach ($value as &$v) {
            $v['url'] = str_replace_url($v['url']);
        }
        $this->attributes['confirm_file'] = Arr::a2s($value);
    }

    public function getConfirmFileAttribute($value)
    {
        if(!empty($value)) {
            $value = Arr::s2a($value);
            foreach ($value as &$v) {
                if(!empty($v['url'])){
                    $v['url'] = getFileUrl($v['url']);
                }
            }
        }
        return $value;
    }

    public function getUploadConfigAttribute($value)
    {
        if($value){
           $value = Arr::s2a($value);
        }
        return $value;
    }

    public function getWebTrafficConfigAttribute($value)
    {
        if($value){
            $value = Arr::s2a($value);
        }
        return $value;
    }

    /**
     * 根据域名获取项目信息
     * @author zbj
     * @date 2023/5/5
     */
    public static function getProjectByDomain($domain)
    {
        $cache_key = 'getProjectByDomain_' . $domain;
        $project = Cache::get($cache_key);
        if(!$project){
            $domain_parse = parse_url($domain);
            $domain = $domain_parse['host'] ?? $domain;
            //是否测试域名
            $project_id = DeployBuild::where('test_domain', 'https://' . $domain . '/')->value('project_id');
            //是否正式域名
            if (!$project_id) {
                $domainModel = new DomainInfoModel();

                //M站特殊域名处理
                if($domain == 'm.sinophorus.com'){
                    $domain = 'en.sinophorus.com';
                }

                $project_id = $domainModel->formatQuery(['domain'=>$domain,'status'=>1])->value('project_id');
                if (empty($project_id)) {
                    //是否小语种域名或amp站域名
                    $domainPrefix = explode(".",$domain);
                    if (!empty($domainPrefix)){
                        if($domainPrefix[0] == 'm'){
                            $domain = "www.".$domainPrefix[1].".".$domainPrefix[2];
                        }else{
                            $isLang = Translate::getTls($domainPrefix[0]);
                            if ($isLang) {
                                $domain = "www.".$domainPrefix[1].".".$domainPrefix[2];
                            }
                        }
                    }
                    if(!Str::startsWith($domain, 'www')){
                        $domain = 'www.' . $domain;
                    }
                    $project_id = $domainModel->formatQuery(['domain'=>$domain,'status'=>1])->value('project_id');
                }
            }
            $project = self::find($project_id ?: 0);
            if($project){
                Cache::put($cache_key, $project, 3600);
            }
        }
        return $project;
    }

    /**
     * @remark :获取项目名称
     * @name   :getProjectName
     * @author :lyh
     * @method :post
     * @time   :2023/9/19 10:35
     */
    public function getProjectName($id){
        $title = '';
        if(!empty($id)){
            $info = $this->read(['id'=>$id],['title']);
            if($info !== false){
                $title = $info['title'];
            }
        }
        return $title;
    }
}