<?php

namespace app\common\model\branch;

use app\common\library\helper;
use app\common\model\BaseModel;
use app\common\model\product\Product as ProductModel;
use app\shop\service\ProductService;

/**
 * 参与活动的商品价格模型
 * @property int $id
 * @property int $activity_id 活动id
 * @property int $product_id 产品id
 * @property int $product_sku_id 产品的属性id
 * @property float $product_price 产品的价格
 * @property int $app_id 小程序id
 * @property int $shop_supplier_id 商户id
 * @property string $create_time 创建时间
 * @property string $update_time 更新时间
 * @property int $is_delete 是否删除
 */
class ActivityProduct extends BaseModel
{
    protected $name = 'branch_activity_product';
    protected $pk = 'activity_product_id';

    protected $type = [
        'can_user_ids'=>'json'
    ];

    /**
     * 关联商品规格表
     */
    public function sku()
    {
        return $this->hasMany('app\\common\\model\\product\\ProductSku')->order(['product_sku_id' => 'asc']);
    }

    /**
     * 关联商品规格关系表
     */
    public function specRel()
    {
        return $this->belongsToMany('app\\common\\model\\product\\SpecValue', 'ProductSpecRel', '')->order(['id' => 'asc']);
    }

    /**
     * 关联商品图片表
     */
    public function image()
    {
        return $this->hasMany('app\\common\\model\\product\\ProductImage')->where('image_type', '=', 0)->order(['id' => 'asc']);
    }

    /**
    读取活动设置的商品列表
     **/
    public function getProductPricelist($id=''){
        $model = new static();
        $list = $model
            ->where('is_delete','=',0)
            ->where(['activity_id'=>$id])
            ->hidden(['create_time','is_delete','update_time','activity_id','app_id','shop_supplier_id'])
            ->select()->toArray();
        if(empty($list)){
            return [];
        }
        foreach ($list as &$item){
            $model = ProductModel::detail($item['product_id']);
            $item['product_name'] = $model['product_name'];
            $item['image'] = $model['image'][0]['file_path'] ?? 0;
            $specData = ProductService::getSpecData($model);
            $specList = [];
            if(!empty($specData)){
               $specList = $this->transSpecData($specData);
                foreach ($specList as $otem){
                    if($item['product_sku_id']==$otem['product_sku_id']){
                        $item['product_sku_name'] = $otem['spec_name'];
                    }
                }
            }else{
                $item['product_sku_name'] = '单规格';
            }
        }
        unset($item);
        return $list;
    }

    /**
    读取某个活动的所有商品
     **/
    public function getProductlist($activity_id=''){
        $model = new static();
        $list = $model
            ->where('is_delete','=',0)
            ->where(['activity_id'=>$activity_id])
            ->field('*,MIN(product_new_price) as min_price')
            ->hidden(['create_time','is_delete','update_time','activity_id','app_id'])
            ->group('product_id') // 按product_id分组
            ->select();
        if(empty($list)){
            return [];
        }
        $back_column =  $model->where('is_delete','=',0)->where(['activity_id'=>$activity_id])->column('product_sku_id','spec_sku_id');
        $spec_sku_id_arr = array_keys($back_column);
        $spec_sku_id = [];
        foreach ($spec_sku_id_arr as $key=> $dd){
            if($dd!=0){
               $new_arr =  explode('_',$dd);
                $spec_sku_id[] = $new_arr[0];
            }
        }
        $product_sku_id = array_values($back_column);
        $new_list = [];
        foreach ($list as &$item){
            $products = $this->detailBySalesActivity($item['product_id'],$product_sku_id);
            if(!$products){
               continue;
            }
            // 整理商品数据并返回
            $item = $this->setProductListData($products, false,$item);
            $item['select_spec'] = [];
            // 多规格商品sku信息
            $item['specData'] = $item['spec_type'] == 20 ? $this->getManySpecData($item['spec_rel'], $item['sku'],$spec_sku_id,$activity_id,$item['product_id']) : null;
            //获取商品最大价格
            $productPrice = helper::getArrayColumn($item['sku'], 'product_price');
            rsort($productPrice);
            $item['product_max_price'] = isset($productPrice[0]) ? $productPrice[0] : 0;
            $new_list[] = $item;
        }
        unset($item);
        return $new_list;
    }

    /**
     * 获取商品详情
     */
    public  function detailBySalesActivity($product_id,$product_sku_id)
    {
        $infos = (new ProductModel())->with([
            'image.file',
            'sku.image'=>function($query) use($product_sku_id){
            $query->where(['product_sku_id'=>$product_sku_id]);
            },
            'spec_rel.spec',
        ])->where('product_id', '=', $product_id)
            ->where('product_status','=',10)
            ->find();
        if($infos){
           return  $infos->toArray();
        }
        return $infos;
    }

    /**
     * 商品多规格信息
     */
    public function getManySpecData($specRel, $skuData,$spec_sku_id,$activity_id=0,$product_id)
    {
        $price_model = new static();
        // spec_attr
        $specAttrData = [];
        foreach ($specRel as $key=>$item) {
            if($key==0 && !in_array($item['spec_id'],$spec_sku_id)){
                continue;
            }
            if (!isset($specAttrData[$item['spec_id']])) {
                $specAttrData[$item['spec_id']] = [
                    'group_id' => $item['spec']['spec_id'],
                    'group_name' => $item['spec']['spec_name'],
                    'spec_items' => [],
                ];
            }
            $specAttrData[$item['spec_id']]['spec_items'][] = [
                'item_id' => $item['spec_value_id'],
                'spec_value' => $item['spec_value'],
            ];
        }
        // spec_list
        $specListData = [];
        foreach ($skuData as $item) {
            $image = (isset($item['image']) && !empty($item['image'])) ? $item['image'] : ['file_id' => 0, 'file_path' => ''];
            $product_price = $price_model->where(['spec_sku_id'=>$item['spec_sku_id'],'product_id'=>$product_id,'activity_id'=>$activity_id,'is_delete'=>0])->value('product_new_price');
            $specListData[] = [
                'product_sku_id' => $item['product_sku_id'],
                'spec_sku_id' => $item['spec_sku_id'],
                'rows' => [],
                'spec_form' => [
                    'image_id' => $image['file_id'],
                    'image_path' => $image['file_path'],
                    'product_no' => $item['product_no'],
                    'product_price' => $product_price,
                    'product_weight' => $item['product_weight'],
                    'line_price' => $item['line_price'],
                    'stock_num' => $item['stock_num']
                ],
            ];
        }
        return ['spec_attr' => array_values($specAttrData), 'spec_list' => $specListData];
    }

    /**
     * 设置商品展示的数据
     */
    protected function setProductListData($data, $isMultiple = true, $product_price=[])
    {

        if (!$isMultiple) $dataSource = [&$data]; else $dataSource = &$data;
        // 整理商品列表数据
        foreach ($dataSource as &$product) {
            // 商品主图
            $product['product_image'] = $product['image'][0]['file_path'];
            // 商品默认规格
            $product['product_sku'] = $this->getShowSku($product,$product_price);
            // 可核销门店ids by yj
            if(!is_array($product['verify_store_ids'])){
                if($product['verify_store_ids'] != ''){
                    $product['verify_store_ids'] = explode(',', $product['verify_store_ids']);
                } else {
                    $product['verify_store_ids'] = [];
                }
            }
            // 核销有效时间段
            if($product['verify_type'] == 20){
                $product['verify_time'] = [date('Y-m-d H:i:s', $product['verify_start_time']), date('Y-m-d H:i:s', $product['verify_end_time'])];
            }
        }
        return $data;
    }

    /**
     * 显示的sku，目前取最低价
     */
    protected  function getShowSku($product,$product_price=[])
    {
        //如果是单规格
        if($product['spec_type'] == 10){
            if(empty($product['sku'])){
                $product['sku'] = [
                    ['product_price'=>$product_price['product_new_price'],'line_price'=>$product['line_price']]
                ];
            }else{
                $product['sku'][0]['product_price'] = $product_price['product_new_price'];
            }
            return $product['sku'][0];
        }else{
            if(empty($product['sku'])){
                $product['sku'] = [
                    ['product_price'=>$product_price['product_new_price'],'line_price'=>$product['line_price']]
                ];
            }else{
                $product['sku'][0]['product_price'] = $product_price['product_new_price'];
            }
        }
        // 兼容历史数据，如果找不到返回第一个
        return isset($product['sku'][0]) ? $product['sku'][0]: $product['sku'];
    }


    /**
     * 组装前端用的数据
     */
    private function transSpecData($specData){
        $specList = [];
        foreach($specData['spec_list'] as $spec){
            $specIds = explode('_',$spec['spec_sku_id']);
            $spec['spec_name'] = '';
            foreach ($specIds as $specId){
                $spec['spec_name'] .= $this->searchSpecItem($specData['spec_attr'], $specId) . ';';
            }
            array_push($specList, $spec);
        }
        return $specList;
    }

    /**
     * 规格值
     */
    private function searchSpecItem($spec_attr, $item_id){
        $specValue = '';
        foreach ($spec_attr as $attr){
            foreach ($attr['spec_items'] as $item){
                if($item['item_id'] == $item_id){
                    $specValue = $attr['group_name'] . ',' . $item['spec_value'];
                    break 2;
                }
            }
        }
        return $specValue;
    }

    /**
     * 立即购买：获取订单商品列表
     */
    public static function getOrderProductListByNow($params)
    {
        $price_model = new static();
        // 商品详情
        $product = \app\api\model\product\Product::detail($params['product_id']);
        // 商品sku信息
        $product['product_sku'] = ProductModel::getProductSku($product, $params['product_sku_id']);
        // 自定义表单数据id，直接读取最新的那条记录 by lyzflash
        $product['table_record_id'] = 0;
        // 商品列表
        $productList = [$product->hidden(['category', 'content', 'image', 'sku'])];
        foreach ($productList as $key=> &$item) {
            $item['spec_sku_id'] = $item['product_sku']['spec_sku_id'];
            //获取规格的图片 by yj 2024.1.16
            if(!empty($product['product_sku']) && !empty($product['product_sku']["image"])){
                $item['product_image'] = $product['product_sku']["image"]["file_path"];
            }
            $product_price = $price_model->where(['spec_sku_id'=>$item['spec_sku_id'],'product_id'=>$item['product_id'],'activity_id'=>$params['activity_id'],'is_delete'=>0])->find();
            if(!$product_price){
                unset($productList[$key]);
            }

            // 商品单价
            $item['product_price'] =  $product_price['product_new_price'];
            //商品服务费
            if(!empty($item["product_service"]) && isset($params["service_index"])){
                $product_service = $item["product_service"][$params["service_index"]];
                $item['service_name'] = $product_service["service_name"];
                $item['service_price'] = $product_service["price"];
            }
            // 商品购买数量
            $item['total_num'] = $params['product_num'];
            // 商品购买总金额
            $item['total_price'] = helper::bcmul($item['product_price'], $params['product_num']);
        }
        $supplierData[] = [
            'shop_supplier_id' => $product['shop_supplier_id'],
            'supplier' => $product['supplier'],
            'productList' => $productList
        ];
        unset($product['supplier']);
        return $supplierData;
    }

}