44 lines
1.2 KiB
PHP
44 lines
1.2 KiB
PHP
<?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"');
|
|
}
|
|
}
|