<?php
declare(strict_types=1);
namespace app\index\model;


use app\api\model\GoodsAttribute;
use app\api\model\GoodsBuyNow;
use app\api\model\GoodsConnect;
use app\api\model\GoodsImages;
use app\api\model\GoodsSoftManual;
use think\facade\Env;

/**
 * 商品模型
 * @mixin \think\Model
 */
class Goods extends BaseModel
{
    protected $schema = [
        'id'	        =>'int',
        'platform_id'	=>'int',
        'language_id'	=>'int',
        'site_id'	    =>'int',
        'name'	        =>'string',
        'main_img'	    =>'string',
        'model_number'	=>'string',
        'goods_category_id'	=>'int',
        'price'	        =>'int',
        'is_new'	    =>'int',
        'is_discount'	=>'int',
        'details'	    =>'string',
        'title'	        =>'string',
        'keywords'	    =>'string',
        'description'	=>'string',
        'sort'	        =>'int',
        'status'	    =>'int',
        'create_time'	=>'int',
        'update_time'	=>'int',
    ];

    /**
     * 商品链接关联模型
     */
    public function GoodsBuyNow()
    {
        return $this->hasMany(GoodsBuyNow::class);
    }

    /**
     * 商品关联商品
     */
    public function GoodsConnect()
    {
        return $this->hasMany(GoodsConnect::class);
    }

    /**
     * 商品手册关联模型
     * @return \think\model\relation\HasMany
     */
    public function GoodsSoftManual()
    {
        return $this->hasMany(GoodsSoftManual::class);
    }

    /**
     * 商品主图关联模型
     * @return \think\model\relation\HasMany
     */
    public function GoodsImages()
    {
        return $this->hasMany(GoodsImages::class);
    }

    /**
     * 商品属性关联
     * @return \think\model\relation\HasMany
     */
    public function goodsAttr()
    {
        return $this->hasMany(GoodsAttribute::class);
    }

    /**
     * 获取父级分类
     * @param $data
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getFirstLeveCategory($data)
    {
        return GoodsCategory::where('pid',0)->where('status',0)->where('site_id',1)->order('sort','desc')->select()->toArray();
    }

    /**
     * 获取二级分类
     * @param $data
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getSecondLevelCategory($data)
    {
        return GoodsCategory::where('pid',$data['cate1'])->where('status',0)->where('site_id',1)->order('sort','desc')->select()->toArray();
    }

    /**
     * 获取三级分类
     * @param $data
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getThreeLevelCategory($data)
    {
        return GoodsCategory::where('pid',$data['cate2'])->where('status',0)->where('site_id',1)->order('sort','desc')->select()->toArray();
    }

    /**
     * 获取所有子分类
     * @param $id
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getAllSonCategory($id)
    {
        $arr = GoodsCategory::where('status',0)->where('site_id',1)->order('sort','desc')->select()->toArray();
        $feeds = category_to_all_children_id($arr,$id);
        
        return $feeds;
    }

    /**
     * 获取列表
     * @param array $data 查询条件
     * @return \think\Paginator
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function getGoodsList($data,$qstring)
    {
        $qs = explode('index/goods/index?',$qstring);
        parse_str($qs[1],$out);

        $query = $queryOther =  [];
        $forth = [
            'is_all','is_recommend','is_hot','is_new'
        ];
        foreach ($forth as $f) {
            if (in_array($f,array_keys($data))) {
                $queryOther[$f] = $data[$f];
            }
        }
        // 判断是否选择了分类
        for ($i=1;$i<=3;$i++) {
            if (isset($data['cate'.$i])) {
                // 如果是3级分类
                if ($i === 3 && $data['cate'.$i] != 0) {
                    $query['goods_category_id'] = $data['cate'.$i];
                }
                // 如果是2级分类
                if ($i === 2 && $data['cate'.$i] != 0) {
                    $arr = array_column($this->getThreeLevelCategory(['cate2'=>$data['cate2']]),'id');
                    array_push($arr,(int)$data['cate2']);
                    $query['goods_category_id'] = $arr;
                }
                // 如果是1级分类
                if ($i === 1 && $data['cate'.$i] != 0) {
                    $query['goods_category_id'] = $this->getAllSonCategory($data['cate1']);
                }
            }
        }

        $collection = $this->where('status',0);
        if (isset($data['model_number'])) {
            $collection = $collection->where('model_number','like','%'.$data['model_number'].'%')->whereOr('name','like','%'.$data['model_number'].'%')->whereOr('title','like','%'.$data['model_number'].'%');
        } else {
            //查询
            if (!empty($queryOther) && !isset($queryOther['is_all'])) {
                $collection = $collection->where($queryOther);
            }

            if (!empty($query) && is_array($query['goods_category_id'])) {
                // 表示是非3级分类
                $collection = $collection->whereIn('goods_category_id',$query['goods_category_id']);
            } else {
                $collection = $collection->where($query);
            }
        }

        $pageNum = SystemConfig::where('pos','goods')->where('name','list_num')->find()->toArray();
        $listRow = [
            'query'     => $out, //url额外参数
            'fragment'  => '', //url锚点
            'var_page'  => 'page', //分页变量
            'list_rows' => (int)$pageNum['value']??4, //每页数量
        ];

        //return $collection->order('create_time','desc')->paginate($listRow);
        $resutl =  $collection->order('create_time','desc')->paginate($listRow);
        //dump($this->getLastSql());
        return $resutl;
    }

    /**
     * 通过商品ID，查出所有父级分类
     */
    public function getCategoryToParent($id)
    {
        $goods = $this->where('id',$id)->find()->toArray();
        $data = GoodsCategory::where('status',0)->order('sort','desc')->select()->toArray();
        $arr = category_to_all_pid($data,$goods['goods_category_id']);
        $arr = GoodsCategory::whereIn('id',$arr)->order('sort','desc')->select()->toArray();

        $url = '';
        for ($i=0;$i<=count($arr)-1;$i++) {
            $cate = 'cate'.($i + 1);
            $url .= http_build_query([$cate =>$arr[$i]['id']])."&";
            $arr[$i]['qs'] = rtrim($url,'&');
        }
        $arr[0]['qs'] = 'cate1='.$arr[0]['id'];
        return $arr;
    }

    public function getInfo($data)
    {
        $result = $this->where('status',0)->find($data['id']);
        if ($result) {
            $goodsAttribute = $result->goodsAttr()->select()->toArray();
            $attr = $img = [];
            if ($goodsAttribute) {
                foreach ($goodsAttribute as $item) {
                    $attr[] = array_merge($item,['attribute_name'=>Attribute::where('id',$item['attribute_id'])->value('name')]);
                }
            }
            $images = $result->goodsImages()->select()->toArray();
            $connect = $result->goodsConnect()->select()->toArray();
            if (!empty($connect)) {
                foreach ($connect as $item) {
                    $res = $this->where('status',0)->find($item['connect_good_id']);
                    if ($item['connect_good_id'] != 0 && $item['connect_good_id'] != '' && $res) {
                        $tmp = $this->where('status',0)->find($item['connect_good_id'])->toArray();
                        $tmp['main_img'] = Env::get('QINIU.cdn').$tmp['main_img'];
                        $connectData[] = array_merge($item,$tmp);
                    }
                }
            }
            //处理相关下载
            $relate = $result->GoodsSoftManual()->select()->toArray();
            $newRelate = [];
            foreach ($relate as $item) {
                $soft = SoftManual::where('status',0)->find($item['soft_manual_id']);
                if ($soft) {
                    $btn = SoftManualBtn::where('soft_manual_id',$item['soft_manual_id'])->select()->toArray();
                    $soft = $soft->toArray();
                    $soft['btn'] = $btn;
                    $newRelate[] = array_merge($soft,[]);
                }
            }

            if (!empty($newRelate)) {
                foreach ($newRelate as $key => $item) {
                    $newRelate[$key]['image'] = Env::get('QINIU.cdn').$item['image'];
                    foreach ($item['btn'] as $item1) {
                        $tmp = [
                            'url'   => Env::get('QINIU.cdn').$item1['url'],
                            'name'  => $item1['file_name']
                        ];
                        $arr[$item1['btn_tips']][] = array_merge($tmp,[]);
                    }
                    unset($newRelate[$key]['btn']);
                    $newRelate[$key]['getSoftBtn'] = $arr;
                    $arr = [];
                }
            }
            //处理图片
            $result['main_img'] = Env::get('QINIU.cdn').$result['main_img'];
//            $img[0] = ['image'=>$result['main_img']];
            foreach ($images as $item) {
                $img[] = ['image'=>Env::get('QINIU.cdn').$item['image']];
            }
            //
            $categoryName = GoodsCategory::find($result['goods_category_id']);
            $result['category_name'] = $categoryName['name'];
            //buynow
            $result['buy_now'] = $result->goodsBuyNow()->select()->toArray();
            $result['goods_attribute'] = $attr;
            $result['relate_download'] = $newRelate;
            $result['images'] = empty($img) ? [['image'=>$result['main_img']]] : $img;
            $result['connect'] = empty($connectData) ? [] : $connectData;

            return $result->toArray();
        } else {
            return [];
        }
    }

}