<?php


namespace app\controllers;


use app\extensions\XLSXReader;
use app\models\settlement\Ekatte;
use app\models\settlement\Oblast;
use app\models\settlement\Obstina;
use yii\base\BaseObject;

class SettlementsController extends BaseController
{

    public function actionGetData()
    {
        if (!empty($_GET['q'])) {
            $ekatte = Ekatte::find()->where(['LIKE', 'name', $_GET['q'] . '%', false])->limit(20)->all();
            $data = [];
            foreach ($ekatte as $row) {
                $data[] = [
                    'settlement_id' => $row->id,
                    'name' => $row->name. ', обл.' . $row->relOblast->name . ' общ. ' . $row->relObstina->name
                ];
            }
            return $this->asJson($data);
        }
        if (!empty($_GET['settlement_id'])) {
            $row = Ekatte::findOne($_GET['settlement_id']);

            if ($row)
                return $this->asJson([
                    'settlement_id' => $row->id,
                    'name' => $row->name. ', обл.' . $row->relOblast->name . ' общ. ' . $row->relObstina->name
                ]);

            die('Wrong settlement_id');

        }
        die('Missing get parameter "q" or "settlement_id"');
    }
}