<?php

namespace Common\Business;

use Api\Controller\InventoryController;
use Common\Model\ImageGalleryModel;
use Common\Model\RetailSkuAttrModel;
use Common\Model\RetailSkuGoodsModel;
use Common\Model\RetailSkuListModel;
use Common\Model\RetailStoreModel;
use Common\Model\SaleMGoodsModel;
use Common\Model\SkuMGoodsModel;

//[1.8.50]

/**
 * 商品规格类
 * Class SkuAttribute
 * [
 * 门店商品-根据规格sku_id_list获取该规格下面的所有规格名称集合  basisSkuIdListSkuNameArr
 * 根据规格id获取该规格下面的所有规格名称 basisSkuIdGetSkuName
 * 获取规格值名称 getSkuListName
 * 根据规格值列表ID，处理规格属性列表 handleSkuList
 * 获取门店指定商品的规格列表、规格属性信息 getStoreGoodsSkuInfo
 * 商品规格属性的添加 skuAttributeAdd
 * 商品规格名称添加 skuNameAdd
 * 新增/编辑商品处获取规格供选择 getSkuAttr
 * ]
 * @package Common\Business
 */
class SkuAttribute
{
    /**
     * 根据商品id获取规格属性名称
     * @param $param
     * [
     * user_type 3商户  4门店
     * goods_id
     * ]
     * @return mixed
     */
    public function basisGoodsIdGetName($param)
    {
        $where = [
            'state' => 0,
        ];
        switch ($param['user_type']) {
            case 3:
                //商户
                $where['mgoods_id'] = $param['goods_id'];
                $SkuModel = new SkuMGoodsModel();
                break;
            case 4:
                //门店
                $where['goods_id'] = $param['goods_id'];
                $SkuModel = new RetailSkuGoodsModel();
                break;
        }
        $list = $SkuModel->getFindField($where, 'sku_id_list');
        $list = explode(',', $list);
        $name = [];
        $SkuAttrModel = new RetailSkuAttrModel();
        foreach ($list as $key => &$val) {
            $name[$key] = $SkuAttrModel->getAttrName($val);
        }
        return $name;
    }


    /**
     * 门店商品-根据规格id获取该规格下面的所有规格名称
     * @param $user_type 3商户 4门店
     * @param $sku_id
     * @return mixed
     */
    public function basisSkuIdGetSkuName($user_type, $sku_id)
    {
        try {
            switch ($user_type) {
                case 3:
                    $SkuGoodsModel = new SkuMGoodsModel();
                    break;
                case 4:
                    $SkuGoodsModel = new RetailSkuGoodsModel();
                    break;
            }
            $SkuListModel = new RetailSkuListModel();
            $list = $SkuGoodsModel->getFindField(['id' => $sku_id], "sku_id_list");
            $sku_name = $SkuListModel->getFindField(['id' => ['in', $list]], "name", true);
            $sku_name = implode(',', $sku_name);
            return $sku_name;
        } catch (\Exception $e) {
            return '';
        }
    }


    /**
     * 门店商品-根据规格sku_id_list获取该规格下面的所有规格名称集合
     * @param $sku_id_list
     * @return mixed
     */
    public function basisSkuIdListSkuNameArr($sku_id_list)
    {
        try {
            $SkuListModel = new RetailSkuListModel();
            $sku_name = $SkuListModel->getFindField(['id' => ['in', $sku_id_list]], "name", true);
            return $sku_name;
        } catch (\Exception $e) {
            return [];
        }
    }


    /**
     * 商品规格属性的添加
     * @param $parameter
     * [
     * merchant_id
     * store_id
     * name 规格属性名称
     * ]
     * @return array
     *[
     * status
     * message
     * data=>[
     *  skuAttributeId 规格属性id
     *  ]
     * ]
     */
    public function skuAttributeAdd($parameter)
    {
        $merchant_id = $parameter['merchant_id'];
        $store_id = $parameter['store_id'] ? $parameter['store_id'] : 0;
        $name = $parameter['name'];
        $skuAttrModel = new RetailSkuAttrModel();
        $skuAttributeId = $skuAttrModel->getFindField([
            'merchantid' => $merchant_id,
            'state' => 0,
            'status' => 1,
            'name' => $name
        ], 'id'); //规格属性信息
        if (empty($skuAttributeId)) {
            $content = [
                'merchantid' => $merchant_id,
                'storeid' => $store_id,
                'name' => $name,
                'addtime' => time()
            ];
            $skuAttributeId = $skuAttrModel->addOrder($content);
            if (empty($skuAttributeId)) {
                return ['status' => 0, 'message' => '添加失败'];
            }
        }
        return ['status' => 1, 'message' => '查询成功', 'data' => ['skuAttributeId' => $skuAttributeId]];
    }


    /**
     * 商品规格名称添加
     * @param $parameter
     * [
     * merchant_id
     * store_id
     * name 规格名称
     * attributeId 规格属性Id
     * ]
     * @return array
     * [
     * status
     * msg
     * data=>[
     *  skuNameId 规格名称ID
     *  ]
     * ]
     */
    public function skuNameAdd($parameter)
    {
        $merchant_id = $parameter['merchant_id'];
        $store_id = $parameter['store_id'];
        $name = $parameter['name'];
        $attributeId = $parameter['attributeId'];
        if (empty($merchant_id) || empty($store_id) || empty($name) || empty($attributeId)) {
            return ['status' => 0, 'message' => '参数缺失'];
        }
        $skuListModel = new RetailSkuListModel();
        $skuNameId = $skuListModel->getFindField([
            'merchant_id' => $merchant_id,
            'state' => 0,
            'name' => $name,
            'attr_id' => $attributeId
        ], 'id');
        if (empty($skuNameId)) {
            $content = [
                'attr_id' => $attributeId,
                'merchant_id' => $merchant_id,
                'store_id' => $store_id,
                'name' => $name,
                'addt_ime' => time(),
            ];
            $skuNameId = $skuListModel->addOrder($content);
            if (empty($skuNameId)) {
                return ['status' => 0, 'message' => '新规格名称添加失败'];
            }
        }
        return ['status' => 1, 'message' => '添加成功', 'data' => ['skuNameId' => $skuNameId]];
    }

    /**
     * 获取门店指定商品的规格列表、规格属性信息
     * @param $param
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function getStoreGoodsSkuInfo($param)
    {
        $user_type = $param['user_type']; //3商户  4门店
        $platform_type = $param['platform_type']; //商户平台类型 1默认系统  2微礼平台
        $merchant_id = $param['merchant_id'];
        $store_id = $param['store_id'];
        $goods_id = $param['goods_id'];
        if (empty($merchant_id) || empty($store_id) || empty($goods_id)) {
            return callBack(statusCode()['error'], '缺少必要参数，详情请见data', array(
                'store_id' => $store_id,
                'merchant_id' => $merchant_id,
                'goods_id' => $goods_id,
            ));
        }
        $skuAttr = array();
        $skuCodeList = array(0 => 0);//记录规格条码，用于返回给前台进行自动编号
        $skuNumberList = array(0 => 0);//记录规格货号，用于返回给前台进行自动编号
        $SkuGoodsModel = new RetailSkuGoodsModel();
        $map = array(
            'goods_id' => $goods_id,
            'store_id' => $store_id,
            'state' => 0
        );
        $skuList = $SkuGoodsModel->getSelect($map);
        if (!empty($skuList)) {
            $sku_id_list = [];//临时存储规格值ID、为展示默认选中值使用
            $sku_name = [];
            $ImageGalleryModel = new ImageGalleryModel();
            $InventoryApi = new InventoryController();

            //处理商品规格列表
            if ($user_type == 4 && $platform_type == 2) {
                $code_arr = [];
            }
            foreach ($skuList as &$value) {
                //临时记录旧ID，给后面赋值使用
                $sku_id = $value['id'];

                $sku_id_list = array_merge($sku_id_list, explode(',', $value['sku_id_list']));

                //临时设置旧ID，给前端做数据处理
                $value['old_id'] = $value['id'];

                //处理ID为数组、获取规格值名称
                $id = explode(',', $value['sku_id_list']);
                foreach ($id as &$v) {
                    $value['name'][] = $this->getSkuListName(intval($v), $sku_name);
                }

                //处理自动递增的条码
                if (!empty($value['sku_code'])) {
                    $tempArr = explode('-', $value['sku_code']);
                    if (count($tempArr) > 1) {
                        if (is_numeric($tempArr[count($tempArr) - 1])) {
                            $skuCodeList[] = (int)$tempArr[count($tempArr) - 1];
                        }
                    }
                }

                //处理自动递增的货号
                if (!empty($value['sku_goods_number'])) {
                    $tempArr = explode('-', $value['sku_goods_number']);
                    if (count($tempArr) > 1) {
                        if (is_numeric($tempArr[count($tempArr) - 1])) {
                            $skuNumberList[] = (int)$tempArr[count($tempArr) - 1];
                        }
                    }
                }

                $value['more_num'] = round($value['more_num'], 3);
                $value['less_num'] = round($value['less_num'], 3);
                $value['purchase_price'] = floatval($value['purchase_price']) ? floatval($value['purchase_price']) : '';
                $value['online_price'] = floatval($value['online_price']) ? floatval($value['online_price']) : '';
                $value['retail_price'] = floatval($value['retail_price']) ? floatval($value['retail_price']) : '';
                $value['shop_mem_price'] = floatval($value['shop_mem_price']) ? floatval($value['shop_mem_price']) : '';
                $value['store_mem_price'] = floatval($value['store_mem_price']) ? floatval($value['store_mem_price']) : '';
                $value['plus_price'] = floatval($value['plus_price']) ? floatval($value['plus_price']) : '';
                $value['guide_royalty_price'] = floatval($value['guide_royalty_price']) ? floatval($value['guide_royalty_price']) : '';
                $value['guide_royalty_online_price'] = floatval($value['guide_royalty_online_price']) ? floatval($value['guide_royalty_online_price']) : '';
                $value['id'] = $id;
                $value['sku_code'] = $value['sku_code'] ? $value['sku_code'] : '';
                $value['weight_value'] = $value['weight_value'] ? round($value['weight_value'], 3) : '';

                //获取规格图片
                $value['goods_img'] = '';
                if (!empty($value['goods_img_id'])) {
                    $value['goods_img'] = $ImageGalleryModel->getFieldPath(array('id' => $value['goods_img_id']));
                }

                //获取规格库存
                if ($user_type == 4 && $platform_type == 2) {
                    $code_arr[$sku_id] = $value['third_goods_code'];
                    $value['goods_num'] = 0;
                } else {
                    $value['goods_num'] = $InventoryApi->goods_num(1, $store_id, $goods_id, $sku_id);
                }
            }
            if ($user_type == 4 && $platform_type == 2 && !empty($code_arr)) {
                //Q3库存
                $StoreModel = new RetailStoreModel();
                $Customer_Codes = $StoreModel->getFindField([
                    'id'=>$store_id
                ],'third_code');
                $GoodsClass = new \LittleGift\Business\Goods();
                $thirdResult = $GoodsClass->goodsNumQuery([
                    'merchant_id'=>$merchant_id,
                    'type'=>2,
                    'code_arr'=>$code_arr,
                    'Customer_Codes'=>$Customer_Codes
                ]);
                if($thirdResult['status'] == 1){
                     $stock = $thirdResult['data'];
                     foreach ($skuList as &$val){
                         $val['goods_num'] = floatval($stock[$val['old_id']]);
                     }
                }
            }

            //获取规格属性列表，保证规格属性顺序
            $skuAttr = $this->handleSkuList($skuList[0]['id'], $sku_id_list);
        }
        $data['skuNumberList'] = $skuNumberList;
        $data['skuCodeList'] = $skuCodeList;
        $data['attr'] = $skuAttr;
        $data['list'] = $skuList;
        return callBack(statusCode()['success'], '获取成功', $data);
    }

    /**
     * 获取商户指定商品的规格列表、规格属性信息
     * @param $param
     * @return mixed
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function getMerGoodsSkuInfo($param)
    {
        $merchant_id = $param['merchant_id'];
        $goods_id = $param['goods_id'];
        if (empty($merchant_id) || empty($goods_id)) {
            return callBack(statusCode()['error'], '缺少必要参数，详情请见data', array(
                'merchant_id' => $merchant_id,
                'goods_id' => $goods_id,
            ));
        }
        $skuAttr = array();
        $skuCodeList = array(0 => 0);//记录规格条码，用于返回给前台进行自动编号
        $skuNumberList = array(0 => 0);//记录规格货号，用于返回给前台进行自动编号
        $SkuMGoodsModel = new SkuMGoodsModel();
        $map = array(
            'merchantid' => $merchant_id,
            'mgoods_id' => $goods_id,
            'state' => 0
        );
        $skuList = $SkuMGoodsModel->getSelect($map);
        if (!empty($skuList)) {
            $sku_id_list = [];//临时存储规格值ID、为展示默认选中值使用
            $sku_name = [];
            $ImageGalleryModel = new ImageGalleryModel();
            $SaleMGoodsModel = new SaleMGoodsModel();
            //处理商品规格列表
            foreach ($skuList as &$value) {
                //临时记录旧ID，给后面赋值使用
                $sku_id = $value['id'];

                $sku_id_list = array_merge($sku_id_list, explode(',', $value['sku_id_list']));

                //临时设置旧ID，给前端做数据处理
                $value['old_id'] = $value['id'];

                //处理ID为数组、获取规格值名称
                $id = explode(',', $value['sku_id_list']);
                foreach ($id as &$v) {
                    $value['name'][] = $this->getSkuListName(intval($v), $sku_name);
                }

                //处理自动递增的条码
                if (!empty($value['sku_code'])) {
                    $tempArr = explode('-', $value['sku_code']);
                    if (count($tempArr) > 1) {
                        if (is_numeric($tempArr[count($tempArr) - 1])) {
                            $skuCodeList[] = (int)$tempArr[count($tempArr) - 1];
                        }
                    }
                }

                //处理自动递增的货号
                if (!empty($value['sku_goods_number'])) {
                    $tempArr = explode('-', $value['sku_goods_number']);
                    if (count($tempArr) > 1) {
                        if (is_numeric($tempArr[count($tempArr) - 1])) {
                            $skuNumberList[] = (int)$tempArr[count($tempArr) - 1];
                        }
                    }
                }

                $value['more_num'] = round($value['more_num'], 3);
                $value['less_num'] = round($value['less_num'], 3);
                $value['purch_price'] = floatval($value['purch_price']) ? floatval($value['purch_price']) : '';
                $value['online_price'] = floatval($value['online_price']) ? floatval($value['online_price']) : '';
                $value['retail_price'] = floatval($value['retail_price']) ? floatval($value['retail_price']) : '';
                $value['shop_mem_price'] = floatval($value['shop_mem_price']) ? floatval($value['shop_mem_price']) : '';
                $value['store_mem_price'] = floatval($value['store_mem_price']) ? floatval($value['store_mem_price']) : '';
                $value['plus_price'] = floatval($value['plus_price']) ? floatval($value['plus_price']) : '';
                $value['id'] = $id;
                $value['sku_code'] = $value['sku_code'] ? $value['sku_code'] : '';
                $value['weight_value'] = $value['weight_value'] ? round($value['weight_value'], 3) : '';

                //获取规格图片
                $value['goods_img'] = '';
                if (!empty($value['goods_img_id'])) {
                    $value['goods_img'] = $ImageGalleryModel->getFieldPath(array('id' => $value['goods_img_id']));
                }
                //获取规格库存
                $where = array(
                    'merchant_id' => $merchant_id,
                    'goods_id' => $goods_id,
                    'sku_id' => $sku_id,
                    'status' => array('in', '0,1'),
                );
                $goods_num = $SaleMGoodsModel->getFindField($where, 'goods_num');
                $value['goods_num'] = $goods_num ? $goods_num : 0;
            }

            //获取规格属性列表，保证规格属性顺序
            $skuAttr = $this->handleSkuList($skuList[0]['id'], $sku_id_list);
        }
        $data['skuNumberList'] = $skuNumberList;
        $data['skuCodeList'] = $skuCodeList;
        $data['attr'] = $skuAttr;
        $data['list'] = $skuList;
        return callBack(statusCode()['success'], '获取成功', $data);
    }

    /**
     * 根据规格值列表ID，处理规格属性列表
     * @param array $ids 规格值列表ID
     * @param array $sku_id_list 所有被选中的规格值ID
     * @return array
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function handleSkuList($ids = array(), $sku_id_list = array())
    {
        $skuAttr = array();
        $SkuListModel = new RetailSkuListModel();
        foreach ($ids as $val) {
            $item = $SkuListModel->getAttrInfo($val);
            $item['list'] = $SkuListModel->getSelect(array('attr_id' => $item['id'], 'state' => 0), 'id,name');
            foreach ($item['list'] as &$v) {
                if (in_array($v['id'], $sku_id_list)) {
                    $v['checked'] = true;
                } else {
                    $v['checked'] = false;
                }
            }
            $skuAttr[] = $item;
        }
        return $skuAttr;
    }

    /**
     * 获取规格值名称
     * @param null $list_id 规格值ID
     * @param array $sku_name 规格值数组
     * @return mixed
     */
    public function getSkuListName($list_id = null, &$sku_name = array())
    {
        if (!$list_id) {
            return '';
        }
        if (!isset($sku_name[$list_id])) {
            $SkuListModel = new RetailSkuListModel();
            $sku_name[$list_id] = $SkuListModel->getFindField(array('id' => $list_id), 'name');
        }
        return $sku_name[$list_id];
    }


    /**
     * 新增/编辑商品处获取规格供选择
     * @param $merchant_id
     * @return mixed
     */
    public function getSkuAttr($merchant_id)
    {
        $RetailSkuAttrModel = new RetailSkuAttrModel();
        $RetailSkuListModel = new RetailSkuListModel();
        $map = [
            'merchantid' => $merchant_id,
            'status' => 1,
            'state' => 0,
        ];
        $skuList = $RetailSkuAttrModel->getSelect($map, 'id,name');
        foreach ($skuList as &$val) {
            $list_map = ['attr_id' => $val['id'], 'status' => 1, 'state' => 0];
            $list = $RetailSkuListModel->getSelect($list_map, 'id,name');
            foreach ($list as &$v) {
                $v['checked'] = false;
            }
            $val['list'] = $list;
        }
        return callBack(statusCode()['success'], '查询成功', $skuList ? $skuList : []);
    }
}