<?php

namespace common\models\backend;


use common\enums\StatusEnum;
use Yii;

/**
 * This is the model class for table "{{%system_version_log}}".
 *
 * @property int $id
 * @property string $mian_version 当前主商城版本
 * @property string|null $addons_version 当前插件版本
 * @property string $upgrade_mian_version 升级主商城版本
 * @property string|null $upgrade_addons_version 升级插件版本
 * @property string|null $upgrade_params mq传输的参数
 * @property int $status 状态：0-更新中，1-更新完成，-1-更新失败
 * @property int $created_at
 * @property int $updated_at
 */
class SystemVersionLog extends \common\models\base\BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%system_version_log}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['addons_version', 'upgrade_addons_version', 'upgrade_params'], 'string'],
            [['status', 'created_at', 'updated_at'], 'integer'],
            [['mian_version', 'upgrade_mian_version'], 'string', 'max' => 32],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mian_version' => 'Mian Version',
            'addons_version' => 'Addons Version',
            'upgrade_mian_version' => 'Upgrade Mian Version',
            'upgrade_addons_version' => 'Upgrade Addons Version',
            'upgrade_params' => 'Upgrade Params',
            'status' => 'Status',
            'created_at' => 'Created At',
            'updated_at' => 'Updated At',
        ];
    }

    /**
     * 保存数据
     * @param array $params
     * @return bool|Menu
     */
    public static function setData(array $params)
    {
        try {
            if (!empty($params['id'])) {
                $model = self::findOne(['id' => $params['id']]);
                if (empty($model)) throw new \Exception('记录不存在或已删除');
            } else {
                $model = new self();
                $model->loadDefaultValues();
            }

            if (!$model->load($params, '') || !$model->save()) throw new \Exception($model->getErrorMessage());
            return $model;
        } catch (\Exception $e) {
            self::$static_error = $e->getMessage();
            return false;
        }
    }

    /**
     * 系统超过3个月未更新警告提示
     * @Author: lun
     * @DateTime: 2023/6/8 0008 18:22
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @return string
     */
    public static function getUpgradeAlert()
    {
        $alert = '';// 提示内容
        $last_time = self::find()->select('created_at')->where(['status' => 1])->orderBy('id desc')->scalar();
        if ($last_time) {
            // 上次更新时间大于3个月则返回提示
            if((time() - $last_time) / 86400 > 90) {
                $alert = '经检测，系统已经超过三个月未进行更新，建议联系技术进行手动更新！';
            }
        }
        return $alert;
    }
}