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

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

Имя файла	BannersLocation.php
Содержимое	<?php namespace app\organizations\banners; use App; class BannersLocation { public static function getLocationsStringArray($bannerId) { $array = []; $items = App::$command ->createCommand(" select banner_razdel2.*, banner_mesto.id_pr as id_pr from banner_mesto, banner_razdel2 where banner_razdel2.id=banner_mesto.id_razdel and id_banner = :banner_id ") ->bindValue(':banner_id', $bannerId) ->queryAll(); foreach ($items as $item) { $name = $item['name']; if ($item['id_pr'] > 0) { $otraslName = App::$command ->createCommand(' select name_otrsl from otrasl where id=:id ') ->bindValue(':id', $item['id_pr']) ->queryOne('name_otrsl', null); if ($otraslName != null) { $name .= ': ' . $otraslName; } } $array[] = $name; } return $array; } }

/app/organizations/banners/

/app/organizations/banners