live_product_api/app/model/system/ProductAttrResult.php

<?php

namespace app\model\system;

use library\basic\BaseModel;
use library\traits\ModelTrait;

class ProductAttrResult extends BaseModel
{

    /**
     * 模型名称
     * @var string
     */
    protected $name = 'product_attr_result';

    use ModelTrait;

    protected $insert = ['change_time'];

    protected static function setChangeTimeAttr($value)
    {
        return time();
    }

    protected static function setResultAttr($value)
    {
        return is_array($value) ? json_encode($value) : $value;
    }

    public static function setResult($result, $product_id, $type = 0)
    {
        $result = self::setResultAttr($result);
        $change_time = self::setChangeTimeAttr(0);
        $count = self::where('product_id', $product_id)->where('type', $type)->count();
        $res = true;
        if ($count) $res = self::where('product_id', $product_id)->where('type', $type)->delete();
        if ($res) return self::insert(compact('product_id', 'result', 'change_time', 'type'), true);
        return $res;
    }

    public static function getResult($productId, int $type = 0)
    {
        return json_decode(self::where('product_id', $productId)->where('type', $type)->value('result'), true) ?: ['value' => []];
    }

    public static function clearResult($productId)
    {
        return self::where('product_id', $productId)->delete();
    }

}