Управление сайтом

Файловый менеджер

Имя файла	Categories.php
Содержимое	<?php namespace app\organizations\regions; use app\core\models\Command; class Categories { private $_command; public function __construct(Command $command) { $this->_command = $command; return $this; } public function getCategories() { return $this->_command ->createCommand(' select oblast_otrasl., COUNT(oblast_firma.id) as firm_total from oblast_otrasl left join oblast_firma ON oblast_firma.id_otrasl = oblast_otrasl.id where id_parent=0 GROUP BY oblast_otrasl.id having firm_total > 0 order by name_otrasl ') ->queryAll(); } public function getCategory($categoryId) { return $this->_command ->createCommand(' SELECT FROM oblast_otrasl WHERE id = :id ') ->bindValue(':id', $categoryId) ->queryOne(); } }

/app/organizations/regions/

/app/organizations/regions