<?php

namespace console\models;

use Yii;

/**
 * This is the model class for table "source".
 *
 * @property integer $ID
 * @property string $Source
 */
class Source extends \yii\db\ActiveRecord
{
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'source';
    }

    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['Source'], 'string', 'max' => 255]
        ];
    }

    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'ID' => 'ID',
            'Source' => 'Source',
        ];
    }

    // Найти имя сайта по id;
    public static function getSiteName($id){
        $model = self::find()->where(['ID'=> $id])->one();
        if($model){
            return $model->Source;
        }else{
            echo PHP_EOL,"Sorry,no such site Name in Parser's list yet! Try ID from this list:", PHP_EOL,PHP_EOL;
            $modelAll = self::find()->all();
            if($modelAll) {
                foreach ($modelAll as $site) {
                    echo 'ID: "' . $site->ID . '", Site Name: "' . $site->Source .'"', PHP_EOL;
                }
            }
            exit;
        }
    }
}