<?php

namespace App\Models\Product;

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

/**
 * @method static get()
 */
class Product extends Base
{
    use SoftDeletes;

    //设置关联表名
    protected $table = 'gl_product';
    //连接数据库
    protected $connection = 'custom_mysql';
    const STATUS_DRAFT = 0;
    const STATUS_ON = 1;
    const STATUS_RECYCLE = 2;


    public static function statusMap(){
        return [
            self::STATUS_DRAFT    => '草稿',
            self::STATUS_ON   => '已发布',
            self::STATUS_RECYCLE  => '回收站',
        ];
    }

    /**
     * @var 获取产品类型
     */
    public $productType = [
        1=>'一般产品',
        2=>'推荐产品',
        3=>'热销产品'
    ];


    /**
     * 产品列表
     * @param $map
     * @param $page
     * @param $row
     * @param string $order
     * @param string[] $fields
     * @param string $sort
     * @return array
     * @author zbj
     * @date 2023/10/17
     */
    public function product_lists($map, $page, $row, $order = 'id', $fields = ['*'], $sort = 'desc'): array
    {
        $category_id = $map['category_id'] ?? 0;
        $query = $this->where(function ($query) use ($category_id) {
            if ($category_id) {
                $category_ids = Category::getChildIdsArr($category_id);
                $query->whereIn('id', function ($subQuery) use ($category_ids) {
                    $subQuery->select('product_id')
                        ->from('gl_product_category_related')
                        ->whereIn('cate_id', $category_ids)
                        ->groupBy('product_id');
                });
            }
        });
        unset($map['category_id']);
        $query = $this->formatQuery($map, $query);
        $query = $this->sortOrder($query,$order,$sort);
        $lists = $query->select($fields)->paginate($row, ['*'], 'page', $page);
        if (empty($lists)) {
            return [];
        }
        $lists = $lists->toArray();
        return $lists;
    }


    public function getThumbAttribute($value){
        if(!empty($value)){
            $value =  json_decode($value,true);
            if(!empty($value['url'])){
                $value['url'] = getImageUrl($value['url']);
            }
        }
        return $value;
    }


    public function getGalleryAttribute($value){
        if(!empty($value)){
            $value = Arr::s2a($value);
            foreach ($value as $k => $v){
                if(!empty($v['url'])){
                    $v['url'] = getImageUrl($v['url']);
                }
                $value[$k] = $v;
            }
        }
        return $value;
    }

    /**
     * @remark :图标获取器
     * @name   :getGalleryAttribute
     * @author :lyh
     * @method :post
     * @time   :2023/7/21 11:11
     */
    public function getIconAttribute($value){
        if(!empty($value)){
            $value = Arr::s2a($value);
            foreach ($value as $k => $v){
                $v = getImageUrl($v);
                $value[$k] = $v;
            }
        }
        return $value;
    }


    public function getAttrsAttribute($value){
        return  Arr::s2a($value);
    }

    public function getDescribeAttribute($value){
        return  Arr::s2a($value);
    }



    public function getSeoMateAttribute($value){
        return  Arr::s2a($value);
    }



    public function getCategoryIdAttribute($value){
        return Arr::setToArr(trim($value,','));
    }


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


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


    public function getKeywordIdAttribute($value){
        return Arr::setToArr(trim($value,','));
    }

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

//    public static function getNumByProjectId($project_id){
//        return self::where('project_id', $project_id)->where('status', self::STATUS_ON)->count();
//    }

    public function getSendTimeAttribute($value){
        if(!$value){
            return date('Y-m-d H:i:s', strtotime($this->getAttribute('created_at')));
        }
        return $value;
    }
}