<?php

namespace App\Models\RouteMap;

use App\Helper\Translate;
use App\Http\Logic\Aside\Project\ProjectLogic;
use App\Models\Base;
use App\Models\Project\Project;
use App\Models\Template\BTemplate;

/**
 * 路由映射表
 * Class RouteMap
 * @package App\Http\Models
 * @author zbj
 * @date 2023/4/17
 */
class RouteMap extends Base
{
    //设置关联表名
    protected $table = 'gl_route_map';
    //连接数据库
    protected $connection = 'custom_mysql';
    //路由类型
    const SOURCE_PRODUCT = 'product';
    const SOURCE_PRODUCT_CATE = 'product_category';
    const SOURCE_PRODUCT_KEYWORD = 'product_keyword';
    const SOURCE_PAGE = 'page';  //单页面
    const SOURCE_INDEX = 'index';  //单页面
    const SOURCE_BLOG = 'blog';
    const SOURCE_BLOG_CATE = 'blog_category';
    const SOURCE_NEWS = 'news';
    const SOURCE_NEWS_CATE = 'news_category';
    //自定义模块
    const SOURCE_MODULE = 'module';
    const SOURCE_AI_BLOG = 'ai_blog';
    const SOURCE_AI_VIDEO = 'ai_video';
    const SOURCE_AI_BLOG_AUTHOR = 'ai_blog_author';//ai博客作者
    const SOURCE_AI_BLOG_LIST = 'ai_blog_list';
    //自定义模块分类
    const SOURCE_MODULE_CATE = 'module_category';

    //路由二级目录
    const PATH_NEWS_CATE = 'news_catalog';
    const PATH_BLOG_CATE = 'blog_catalog';
    const PATH_MODULE_CATE = 'module_category_route';//扩展模块

    const SOURCE_NAV = 'nav';
    /**
     * 生成路由标识
     * @param $title
     * @param $source
     * @param $source_id
     * @param $project_id
     * @return string
     * @author zbj
     * @date 2023/4/17
     */
    public static function generateRoute($title, $source, $source_id, $project_id){
        if(preg_match('/[\x{4e00}-\x{9fa5}]/u', $title)){
            $title = Translate::tran($title, 'en');
        }
        if(contains_russian($title)){
            $title = Translate::tran($title, 'en');
        }
        $i=1;
        $sign = generateRoute($title);
        $info = self::where(['project_id' => $project_id, 'source' => $source, 'source_id'=>$source_id])->first();
        $suffix = '';
        if(empty($info)){
            if($source == self::SOURCE_PRODUCT){
                $suffix = '-product';
            }
        }
        $route = $sign.$suffix;
        while(self::isExist($route, $source_id, $project_id)){
            $route = $sign .'-'.$i.$suffix;
            $i++;
        }
        return $route;
    }

    /**
     * 路由是否存在
     * @param $route
     * @param $source
     * @param $source_id
     * @param $project_id
     * @return bool
     * @author zbj
     * @date 2023/4/17
     */
    protected static function isExist($route, $source_id, $project_id){
        $fixed = ['api']; //固定的路由
        if(in_array($route, $fixed)){
            return true;
        }
        $where = [
            'project_id' => $project_id, 'route' => $route,
        ];
        $route = self::where($where)->first();
        if($route){
            if($route->source_id == $source_id){
                return false;
            }
            return true;
        }
        return false;
    }

    /**
     * @param $title
     * @param $source
     * @param $source_id
     * @param int $project_id
     * @return bool
     * @throws \Exception
     * @author zbj
     * @date 2023/4/17
     */
    public static function setRoute($title, $source, $source_id, $project_id = 0){
        $route = self::generateRoute($title, $source, $source_id, $project_id);
        if(!$route){
            throw new \Exception('路由生成失败');
        }
        try {
            $route_map = self::where('project_id', $project_id)->where('source_id', $source_id)->where('source', $source)->first();
            if(!$route_map){
                $route_map = new self();
                $route_map->source = $source;
                $route_map->source_id = $source_id;
                $route_map->project_id = $project_id;
            }
            if($source == self::SOURCE_NEWS){
                $route_map->path = self::SOURCE_NEWS;
            }elseif ($source == self::SOURCE_BLOG){
                $route_map->path = self::SOURCE_BLOG.'s';
            }elseif($source == self::SOURCE_MODULE){
                $route_map->path = self::PATH_MODULE_CATE;
            }
            $route_map->route = $route;
            $route_map->save();
        }catch (\Exception $e){
            throw new \Exception('路由映射失败');
        }
       return $route;
    }

    /**
     * @param $route
     * @param $project_id
     * @return mixed
     * @author zbj
     * @date 2023/4/17
     */
    public function getRouteInfo($route, $project_id){
        return self::where('project_id',$project_id)->where('route', $route)->get();
    }

    /**
     * @param $source
     * @param $source_id
     * @param $project_id
     * @return mixed
     * @author zbj
     * @date 2023/4/17
     */
    public static function getRoute($source, $source_id, $project_id){
        return self::where('project_id', $project_id)->where('source', $source)->where('source_id', $source_id)->value('route');
    }

    /**
     * @param $route
     * @param $source
     * @param int $project_id
     * @return mixed
     * @author zbj
     * @date 2023/4/17
     */
    public static function getSourceId($route, $source, $project_id){
        return self::where('project_id', $project_id)->where('source', $source)->where('route', $route)->value('source_id');
    }


    /**
     * @param $source
     * @param $source_id
     * @param $project_id
     * @return mixed
     * @author zbj
     * @date 2023/4/17
     */
    public static function delRoute($source, $source_id, $project_id){
        return self::where('project_id', $project_id)->where('source', $source)->where('source_id', $source_id)->delete();
    }
}