public function getSiteusers($conditions = '', $limit = null, $offset = null)
{
$driver = DataSource::getCurrent();
$sql = 'SELECT
SQL_CALC_FOUND_ROWS
*
FROM
siteuser
WHERE
deleted = 0' . (!empty($conditions) ? " and {$conditions}" : '') . (is_null($limit) ? '' : " limit {$limit}") . (is_null($offset) ? '' : " offset {$offset}");
$driver->query($sql);
return $driver->fetchAssoc();
}
public function getGalleryItems(Gallery $oGallery, $filterConditions = [], $limit = null, $offset = null)
{
$driver = DataSource::getCurrent();
$sql = 'select
SQL_CALC_FOUND_ROWS
id,
name,
description,
path,
position
from
module_gallery_item
where
gallery_id=' . $oGallery->id . ($filterConditions == '' ? '' : " and {$filterConditions}") . (is_null($limit) ? '' : " limit {$limit}") . (is_null($offset) ? '' : " offset {$offset}");
$driver->query($sql);
return $driver->fetchAssoc();
}
public function getCategoriesAndItems($categoryId, $conditions = '', $limit = null, $offset = null)
{
$driver = DataSource::getCurrent();
$sql = 'select
SQL_CALC_FOUND_ROWS
childs.id,
childs.is_category,
childs.name,
childs.description,
case when mcc.name is null then \'Не назначена\' else mcc.name end as category,
childs.thumbnail,
childs.priority,
childs.active,
childs.price,
childs.count
from
((select
id, true is_category, name, description, category_id, thumbnail, priority, active, null as price, \'-\' as count
from
module_catalogue_category
where
deleted = 0
and category_id=' . $categoryId . '
order by
priority)
union
(select
id, false is_category, name, description, category_id, thumbnail, priority, active, price, count
from
module_catalogue_item
where
deleted = 0
and category_id=' . $categoryId . '
order by
priority)
) as childs
left join module_catalogue_category mcc on mcc.id = childs.category_id
' . (!empty($conditions) ? " where {$conditions}" : '') . '
' . (is_null($limit) ? '' : " limit {$limit}") . '
' . (is_null($offset) ? '' : " offset {$offset}");
$driver->query($sql);
return $driver->fetchAssoc();
}
public function getPages($filterConditions = '', $limit = null, $offset = null)
{
$driver = DataSource::getCurrent();
$sql = 'select
SQL_CALC_FOUND_ROWS
id,
name,
description,
active
from
module_pages
where
deleted = 0
' . (!empty($filterConditions) ? " and {$filterConditions}" : '') . '
' . (is_null($limit) ? '' : " limit {$limit}") . '
' . (is_null($offset) ? '' : " offset {$offset}");
$driver->query($sql);
return $driver->fetchAssoc();
}
public function actionIndex()
{
$this->needAuthenticate();
$ModuleInstaller = new ModuleInstaller();
$view = new ViewMain();
/** @var NotificationLog $oNotificationLogs */
$oNotificationLogs = DataSource::factory(NotificationLog::cls());
$oNotificationLogs->builder()->order('date', 'desc')->limit(100);
/** @var NotificationLog[] $aNotificationLogs */
$aNotificationLogs = $oNotificationLogs->findAll();
$Select = new Select();
DataSource::getCurrent()->query($Select->table('notification_log')->field('count(*)', 'count')->build());
$logsCount = DataSource::getCurrent()->fetchAssoc()[0]['count'];
$modulesManifests = $ModuleInstaller->findManifests();
$view->aNotificationLogs = $aNotificationLogs;
$view->modulesManifests = $modulesManifests;
$view->logsCount = $logsCount;
$this->Frame->bindView('content', $view);
$this->Frame->render();
}
public function clearMainFlag()
{
$driver = DataSource::getCurrent();
$query = 'update structure set is_main=0';
$driver->query($query);
}
