ngds/common/models/FreeTemplate.php

<?php

namespace common\models;

use common\helpers\Cache;
use Yii;

/**
 * This is the model class for table "{{%FREE_TEMPLATE}}".
 *
 * @property int id
 * @property string country_id 国家ID
 * @property double freight 运费
 * @property double free_shipping 免运费阈值
 * @property int currency_id 币种ID
 * @property int created_at 订单创建时间
 * @property int updated_at 订单创建人
 */
class FreeTemplate extends \common\components\ActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%FREE_TEMPLATE}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['country_id',  'freight', 'free_shipping', 'currency_id'], 'required'],
            [['freight', 'free_shipping', 'currency_id'], 'number'],
            [['SN'], 'unique'],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'country_id' => '国家ID',
            'freight' => '运费',
            'free_shipping' => '免运费阈值',
            'currency_id' => '币种ID',
            'created_at' => '创建时间',
            'updated_at' => '更新时间',
        ];
    }

    public function country()
    {
        return $this->hasOne(Countries::class, ['ID' => 'country_id']);
    }

    public function currency()
    {
        return $this->hasOne(Currency::class, ['ID' => 'currency_id']);
    }

    /**
     * 从缓存获取信息
     * @return array|mixed|\yii\db\ActiveRecord[]
     */
    public static function getFromCache()
    {
        $data = Yii::$app->cache->get(Cache::FREE_TEMPLATE_KEY);
        if (!$data) {
            // 获取信息
            $data = static::find()->orderBy('id ASC')->indexBy('id')->asArray()->all();
            Yii::$app->cache->set(Cache::FREE_TEMPLATE_KEY, $data);
        }

        return $data;
    }

    /**
     * @return array|\yii\db\ActiveRecord[]
     */
    public static function getAllData()
    {
        return static::find()->indexBy('id')->orderBy('id ASC')->asArray()->all();
    }

    /**
     *  更新缓存
     * @return array|\yii\db\ActiveRecord[]
     */
    public static function updateToCache()
    {
        // 获取配置
        $data = static::find()->orderBy('id ASC')->asArray()->indexBy('id')->all();
        Yii::$app->cache->set(Cache::FREE_TEMPLATE_KEY, $data);
        return $data;
    }

    /**
     * 通过$countryId获取
     * @param string $countryId
     * @return array|null
     */
    public static function getByCountryId(string $countryId): ?array
    {
        return self::findOneAsArray('country_id=:country_id', [':country_id' => $countryId]);
    }
}