<?php
/**
 * Created by PhpStorm.
 * User: ZCY
 * Date: 2018/12/18
 * Time: 16:56
 */
namespace common\models\psources;

use common\core\BaseActiveRecord;
use Yii;

class CoinBannerItem extends BaseActiveRecord
{
    //定义场景
    const SCENARIOS_CREATE = 'create';
    const SCENARIOS_UPDATE = 'update';

    public static function getDb()
    {
        return Yii::$app->get('p_sources');
    }

    public static function tableName()
    {
        return '{{coin_banner_item}}';
    }

    public function rules()
    {
        return [
            [['image_url', 'platform_id'], 'required'],
            [['banner_url', 'title'], 'safe'],
            [['banner_url', 'image_url'], 'url']
        ];
    }

    public function scenarios()
    {
        $scenarios = [
            self:: SCENARIOS_CREATE => ['image_url', 'banner_url', 'title', 'platform_id'],
            self:: SCENARIOS_UPDATE => ['id', 'image_url', 'banner_url', 'title', 'platform_id'],
        ];
        return array_merge(parent:: scenarios(), $scenarios);
    }


    public static function getItems($condition = [])
    {
        return self::find()->joinWith('platform')->where($condition)->asArray()->all();
    }

    public static function getBanner($id)
    {
        return self::find()->where(['id' => $id])->one();
    }

    public function getPlatform()
    {
        return $this->hasOne(CoinPlatform::className(), ['id'=>'platform_id']);
    }
}