<?php
/**
 * Created by PhpStorm.
 * User: ZCY
 * Date: 2018/11/2
 * Time: 11:14
 */

namespace common\models\psources;

use common\core\BaseActiveRecord;
use Yii;

class CoinApplicateRank extends BaseActiveRecord
{
    public static function getDb()
    {
        return Yii::$app->get('p_sources');
    }

    public static function tableName()
    {
        return '{{%coin_applicate_rank}}';
    }

    public function getApplication()
    {
        return $this->hasOne(CoinApplication::class, ['id' => 'relate_id']);
    }

    public static function getApplicateList($type)
    {
        $applicate_rank_model = self::find();
        $data = $applicate_rank_model->JoinWith(['application'], false)
            ->select('relate_id as id,sort,name,'.self::tableName().".type")
            ->orderBy(self::tableName().'.sort asc')->where([self::tableName().'.type' => $type])->asArray()->all();
        return $data;
    }

    public static function getApplicate($relate_id,$type)
    {
        return self::find()->where(['relate_id' => $relate_id,'type' => $type])->one();
    }

    public static function getAppList($type)
    {
        $applicate_rank_model = self::find();
        $data = $applicate_rank_model->JoinWith(['application'], false)
            ->select('relate_id as id,sort,name,icon,advertise,'.self::tableName().".type")
            ->orderBy(self::tableName().'.sort asc')->where([self::tableName().'.type' => $type])->asArray()->all();
        return $data;
    }


}