baseXX/application/admin/model/store/StoreProductAttr.php

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------

namespace app\admin\model\store;

use basic\ModelBasic;
use traits\ModelTrait;

class StoreProductAttr extends ModelBasic
{
    use ModelTrait;

    protected function setAttrValuesAttr($value)
    {
        return is_array($value) ? implode(',',$value) : $value;
    }

    protected function getAttrValuesAttr($value)
    {
        return explode(',',$value);
    }


    public static function createProductAttr($attrList,$valueList,$productId)
    {
        $result = ['attr'=>$attrList,'value'=>$valueList];
        $attrValueList = [];
        $attrNameList = [];
        foreach ($attrList as $index=>$attr){
            if(!isset($attr['value'])) return self::setErrorInfo('请输入规则名称!');
            $attr['value'] = trim($attr['value']);
            if(!isset($attr['value'])) return self::setErrorInfo('请输入规则名称!!');
            if(!isset($attr['detail']) || !count($attr['detail'])) return self::setErrorInfo('请输入属性名称!');
            foreach ($attr['detail'] as $k=>$attrValue){
                $attrValue = trim($attrValue);
                if(empty($attrValue)) return self::setErrorInfo('请输入正确的属性');
                $attr['detail'][$k] = $attrValue;
                $attrValueList[] = $attrValue;
                $attr['detail'][$k] = $attrValue;
            }
            $attrNameList[] = $attr['value'];
            $attrList[$index] = $attr;
        }
        $attrCount = count($attrList);
        foreach ($valueList as $index=>$value){
            if(!isset($value['detail']) || count($value['detail']) != $attrCount) return self::setErrorInfo('请填写正确的商品信息');
            if(!isset($value['price']) || !is_numeric($value['price']) || floatval($value['price']) != $value['price'])
                return self::setErrorInfo('请填写正确的商品价格');
            if(!isset($value['sales']) || !is_numeric($value['sales']) || intval($value['sales']) != $value['sales'])
                return self::setErrorInfo('请填写正确的商品库存');
            if(!isset($value['cost']) || !is_numeric($value['cost']) || floatval($value['cost']) != $value['cost'])
                return self::setErrorInfo('请填写正确的商品成本价格');
            if(!isset($value['pic']) || empty($value['pic']))
                return self::setErrorInfo('请上传商品图片');
            foreach ($value['detail'] as $attrName=>$attrValue){
                $attrName = trim($attrName);
                $attrValue = trim($attrValue);
                if(!in_array($attrName,$attrNameList,true)) return self::setErrorInfo($attrName.'规则不存在');
                if(!in_array($attrValue,$attrValueList,true)) return self::setErrorInfo($attrName.'属性不存在');
                if(empty($attrName)) return self::setErrorInfo('请输入正确的属性');
                $value['detail'][$attrName] = $attrValue;
            }
            $valueList[$index] = $value;
        }
        $attrGroup = [];
        $valueGroup = [];
        foreach ($attrList as $k=>$value){
            $attrGroup[] = [
                'product_id'=>$productId,
                'attr_name'=>$value['value'],
                'attr_values'=>$value['detail']
            ];
        }
        foreach ($valueList as $k=>$value){
            ksort($value['detail'],SORT_STRING);
            $suk = implode(',',$value['detail']);
            $valueGroup[$suk] = [
                'product_id'=>$productId,
                'suk'=>$suk,
                'price'=>$value['price'],
                'vip_price'=>$value['vip_price'],
                'cost'=>$value['cost'],
                'stock'=>$value['sales'],
                'image'=>$value['pic']
            ];
        }
        if(!count($attrGroup) || !count($valueGroup)) return self::setErrorInfo('请设置至少一个属性!');
        $attrModel = new self;
        $attrValueModel = new StoreProductAttrValue;
        self::beginTrans();
        if(!self::clearProductAttr($productId)) return false;
        $res = false !== $attrModel->saveAll($attrGroup)
            && false !== $attrValueModel->saveAll($valueGroup)
        && false !== StoreProductAttrResult::setResult($result,$productId);
        self::checkTrans($res);
        if($res)
            return true;
        else
            return self::setErrorInfo('编辑商品属性失败!');
    }

    public static function clearProductAttr($productId)
    {
        if (empty($productId) && $productId != 0) return self::setErrorInfo('商品不存在!');
        $res = false !== self::where('product_id',$productId)->delete()
            && false !== StoreProductAttrValue::clearProductAttrValue($productId);
        if(!$res)
            return self::setErrorInfo('编辑属性失败,清除旧属性失败!');
        else
            return true;
    }

}