<?php

namespace App\Models\Product;

use App\Helper\Arr;
use App\Models\Base;
use Illuminate\Database\Eloquent\SoftDeletes;

class Keyword extends Base
{
//    use SoftDeletes;

    //设置关联表名
    protected $table = 'gl_product_keyword';

    //连接数据库
    protected $connection = 'custom_mysql';

    const STATUS_ACTIVE = 1;
    //获取字母对应数字
    public $firstNumWord = [
        0=>"0",
        1=>"a",
        2=>"b",
        3=>"c",
        4=>"d",
        5=>"e",
        6=>"f",
        7=>"g",
        8=>"h",
        9=>"i",
        10=>"j",
        11=>"k",
        12=>"l",
        13=>"m",
        14=>"n",
        15=>"o",
        16=>"p",
        17=>"q",
        18=>"r",
        19=>"s",
        20=>"t",
        21=>"u",
        22=>"v",
        23=>"w",
        24=>"x",
        25=>"y",
        26=>"z",
        27=>"all",
    ];

    /**
     * @remark :视频
     * @name   :getKeywordVideoAttribute
     * @author :lyh
     * @method :post
     * @time   :2023/10/31 11:26
     */
    public function getKeywordVideoAttribute($value){
        if(!empty($value)){
            $value = Arr::s2a($value);
        }
        return $value;
    }

    /**
     * @param $value
     * @return array|mixed
     * @author zbj
     * @date 2023/11/21
     */
    public function getRelatedNewsIdsAttribute($value){
        if(!empty($value)){
            $value = Arr::setToArr($value);
        }
        return $value ?: [];
    }

    /**
     * @param $value
     * @return array|false|mixed|string[]
     * @author zbj
     * @date 2023/11/21
     */
    public function getRelatedBlogIdsAttribute($value){
        if(!empty($value)){
            $value = Arr::setToArr($value);
        }
        return $value ?: [];
    }

    /**
     * 随机获取关键词列表
     */
    public function getProductsKeywordsList($project)
    {
        return Keyword::where("project_id",$project->id)->where("status",1)->inRandomOrder()->take(10)->get();
    }

}