qimall/console/models/Mall.php

<?php

namespace console\models;

use yii\db\ActiveRecord;

/**
 * Class Mall
 * @package console\models
 */
class Mall extends ActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%mall}}';
    }

    /**
     * 获取有期限的商城
     *
     * @return array|static[]
     */
    public static function getTimeLimitMall()
    {
        $condition = [
            'and',
            ['>', 'expired_at', time()],
            ['=', 'status', '1'],
        ];

        return static::find()->where($condition)->asArray()->all();
    }
}