function mod_whoonline($module_id, $cfg)
{
$inDB = cmsDatabase::getInstance();
if (!isset($cfg['color_admin'])) {
$cfg['color_admin'] = '#FF0000';
}
if (!isset($cfg['color_editor'])) {
$cfg['color_editor'] = '#009900';
}
$online_count = cmsUser::getOnlineCount();
$users = array();
$today_users = array();
if ($online_count['users']) {
$sql = "SELECT\n o.user_id as id,\n u.login,\n u.nickname,\n p.gender as gender\n FROM cms_online o\n LEFT JOIN cms_users u ON u.id = o.user_id\n LEFT JOIN cms_user_profiles p ON p.user_id = u.id\n WHERE u.is_locked = 0 AND u.is_deleted = 0\n GROUP BY o.user_id";
$result = $inDB->query($sql);
$users = getUsersArray($result, $cfg, $inDB);
}
if ($cfg['show_today']) {
$today = date("Y-m-d");
$sql = "SELECT u.id as id, u.nickname as nickname, u.login as login, p.gender as gender\n FROM cms_users u\n LEFT JOIN cms_user_profiles p ON p.user_id = u.id\n WHERE u.is_locked = 0 AND u.is_deleted = 0 AND DATE_FORMAT(u.logdate, '%Y-%m-%d')='{$today}'\n ORDER BY u.logdate DESC";
$result = $inDB->query($sql);
if ($inDB->num_rows($result)) {
$today_users = getUsersArray($result, $cfg, $inDB);
}
}
cmsPage::initTemplate('modules', 'mod_whoonline')->assign('cfg', $cfg)->assign('users', $users)->assign('guests', $online_count['guests'])->assign('today_users', $today_users)->display('mod_whoonline.tpl');
return true;
}
function mod_user_stats($module_id, $cfg)
{
$inDB = cmsDatabase::getInstance();
cmsCore::loadLanguage('components/users');
global $_LANG;
if (!isset($cfg['show_total'])) {
$cfg['show_total'] = 1;
}
if (!isset($cfg['show_online'])) {
$cfg['show_online'] = 1;
}
if (!isset($cfg['show_gender'])) {
$cfg['show_gender'] = 1;
}
if (!isset($cfg['show_city'])) {
$cfg['show_city'] = 1;
}
$total_usr = cmsUser::getCountAllUsers();
if ($cfg['show_gender']) {
$gender_stats = array();
//male
$gender_stats['male'] = $inDB->rows_count('cms_users u INNER JOIN cms_user_profiles p ON p.user_id = u.id', "u.is_locked = 0 AND u.is_deleted = 0 AND p.gender = 'm'");
//female
$gender_stats['female'] = $inDB->rows_count('cms_users u INNER JOIN cms_user_profiles p ON p.user_id = u.id', "u.is_locked = 0 AND u.is_deleted = 0 AND p.gender = 'f'");
//unknown
$gender_stats['unknown'] = $total_usr - $gender_stats['male'] - $gender_stats['female'];
}
if ($cfg['show_city']) {
$sql = "SELECT IF (p.city != '', p.city, '{$_LANG['NOT_DECIDE']}') city, COUNT( p.user_id ) count\n FROM cms_users u\n LEFT JOIN cms_user_profiles p ON p.user_id = u.id\n WHERE u.is_locked =0 AND u.is_deleted =0\n GROUP BY p.city";
$rs = $inDB->query($sql);
$city_stats = array();
if ($inDB->num_rows($rs)) {
while ($row = $inDB->fetch_assoc($rs)) {
if ($row['city'] != $_LANG['NOT_DECIDE']) {
$row['href'] = '/users/city/' . urlencode($row['city']);
} else {
$row['href'] = '';
}
$row['city'] = icms_ucfirst(mb_strtolower($row['city']));
$city_stats[] = $row;
}
}
}
if ($cfg['show_online']) {
$people = cmsUser::getOnlineCount();
}
if ($cfg['show_bday']) {
$bday = cmsUser::getBirthdayUsers();
}
cmsPage::initTemplate('modules', 'mod_user_stats')->assign('cfg', $cfg)->assign('total_usr', $total_usr)->assign('gender_stats', $gender_stats)->assign('city_stats', $city_stats)->assign('usr_online', cmsUser::sessionGet('usr_online'))->assign('people', $people)->assign('bday', $bday)->display('mod_user_stats.tpl');
return true;
}
function mod_whoonline($mod, $cfg) {
$cfg = array_merge(array(
'color_admin' => '#FF0000',
'color_editor' => '#009900'
), $cfg);
$online_count = cmsUser::getOnlineCount();
$users = array();
$today_users = array();
if ($online_count['users']) {
$sql = "SELECT
o.user_id as id,
u.login,
u.nickname,
p.gender as gender
FROM cms_online o
LEFT JOIN cms_users u ON u.id = o.user_id
LEFT JOIN cms_user_profiles p ON p.user_id = u.id
WHERE u.is_locked = 0 AND u.is_deleted = 0
GROUP BY o.user_id";
$result = cmsCore::c('db')->query($sql);
$users = getUsersArray($result, $cfg);
}
if ($cfg['show_today']) {
$sql = "SELECT u.id as id, u.nickname as nickname, u.login as login, p.gender as gender
FROM cms_users u
LEFT JOIN cms_user_profiles p ON p.user_id = u.id
WHERE u.is_locked = 0 AND u.is_deleted = 0 AND DATE_FORMAT(u.logdate, '%Y-%m-%d')='". date('Y-m-d') ."'
ORDER BY u.logdate DESC";
$result = cmsCore::c('db')->query($sql);
if (cmsCore::c('db')->num_rows($result)) {
$today_users = getUsersArray($result, $cfg);
}
}
cmsPage::initTemplate('modules', $cfg['tpl'])->
assign('cfg', $cfg)->
assign('users', $users)->
assign('guests', $online_count['guests'])->
assign('today_users', $today_users)->
display();
return true;
}
function cpWhoOnline()
{
global $_LANG;
$people = cmsUser::getOnlineCount();
$html .= '<div>';
$html .= '<table width="100%" cellpadding="2" cellspacing="2"><tr>';
$html .= '<td width="24" valign="top">';
$html .= '<img src="images/user.gif"/>';
$html .= '</td>';
$html .= '<td width="" valign="top">';
$html .= '<div><strong>' . $_LANG['AD_FROM_USERS'] . ': </strong>' . $people['users'] . '</div>';
$html .= '<div><strong>' . $_LANG['AD_FROM_GUESTS'] . ': </strong>' . $people['guests'] . '</div>';
$html .= '</td>';
$html .= '</tr></table>';
$html .= '</div>';
return $html;
}
function applet_main()
{
$inCore = cmsCore::getInstance();
global $_LANG;
cmsCore::c('page')->setTitle($_LANG['PATH_HOME']);
$new = array();
$tpl = cmsCore::c('page')->initTemplate('applets', 'main')->assign('users_count', cmsCore::c('db')->rows_count('cms_users', 'is_deleted=0'))->assign('today_users_count', (int) cmsCore::c('db')->get_field('cms_users', "DATE_FORMAT(regdate, '%d-%m-%Y') = DATE_FORMAT(NOW(), '%d-%m-%Y') AND is_deleted = 0", 'COUNT(id)'))->assign('week_users_count', (int) cmsCore::c('db')->get_field('cms_users', "regdate >= DATE_SUB(NOW(), INTERVAL 7 DAY)", 'COUNT(id)'))->assign('month_users_count', (int) cmsCore::c('db')->get_field('cms_users', "regdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)", 'COUNT(id)'))->assign('people', cmsUser::getOnlineCount());
if ($inCore->isComponentEnable('content')) {
$tpl->assign('content_enable', true);
$new['content'] = (int) newContent('cms_content');
}
if ($inCore->isComponentEnable('photos')) {
$tpl->assign('photos_enable', true);
$new['photos'] = (int) newContent('cms_photo_files');
}
if ($inCore->isComponentEnable('video')) {
$tpl->assign('video_enable', true);
$new['video'] = (int) newContent('cms_video_movie');
}
if ($inCore->isComponentEnable('maps')) {
$tpl->assign('maps_enable', true);
$new['maps'] = (int) newContent('cms_map_items');
}
if ($inCore->isComponentEnable('faq')) {
$tpl->assign('faq_enable', true);
$new['faq'] = (int) newContent('cms_faq_quests');
}
if ($inCore->isComponentEnable('board')) {
$tpl->assign('board_enable', true);
$new['board'] = (int) newContent('cms_board_items');
}
if ($inCore->isComponentEnable('catalog')) {
$tpl->assign('catalog_enable', true);
$new['catalog'] = (int) newContent('cms_uc_items');
}
if ($inCore->isComponentEnable('forum')) {
$tpl->assign('forum_enable', true);
$new['forum'] = (int) newContent('cms_forum_posts');
}
cmsCore::c('actions')->showTargets(true);
$total = cmsCore::c('actions')->getCountActions();
cmsCore::c('db')->limitPage(1, 10);
$actions_html = cmsCore::c('page')->initTemplate('components', 'actions_list')->assign('actions', cmsCore::c('actions')->getActionsLog())->assign('pagebar', cmsPage::getPagebar($total, 1, 10, '#" onclick="$.post(\'/admin/ajax/getActions.php\', \'page=%page%\', function(m){ $(\'#actions\').html(m); }); return false'))->fetch();
$tpl->assign('new', $new)->assign('rssfeed_installed', $inCore->isComponentInstalled('rssfeed'))->assign('actions_html', $actions_html)->assign('new_quests', cmsCore::c('db')->rows_count('cms_faq_quests', 'published = 0'))->assign('new_content', cmsCore::c('db')->rows_count('cms_content', 'published = 0 AND is_arhive = 0'))->assign('new_catalog', cmsCore::c('db')->rows_count('cms_uc_items', 'on_moderate = 1'))->display();
}
function applet_main() {
$inCore = cmsCore::getInstance();
global $_LANG;
cmsCore::c('page')->setTitle($_LANG['PATH_HOME']);
?>
<table class="table-condensed" width="100%">
<tr>
<td width="275" valign="top" style="padding-left:0px;">
<div class="panel panel-default">
<div class="panel-heading"><?php echo $_LANG['AD_SITE_CONTENT']; ?></div>
<ul class="list-group">
<?php if($inCore->isComponentEnable('content')) {
$new['content'] = (int)newContent('cms_content'); ?>
<li class="list-group-item">
<a href="index.php?view=tree"><?php echo $_LANG['AD_ARTICLES']; ?></a> <?php if($new['content']) { ?><span class="new_content">+<?php echo $new['content']?></span><?php } ?>
<a class="fa fa-plus right" href="index.php?view=content&do=add" title="<?php echo $_LANG['AD_CREATE_ARTICLE']; ?>"></a>
<a class="fa fa-plus-square right" href="index.php?view=cats&do=add" title="<?php echo $_LANG['AD_CREATE_SECTION']; ?>"></a>
</li>
<?php } ?>
<?php if($inCore->isComponentEnable('photos')) {
$new['photos'] = (int)newContent('cms_photo_files'); ?>
<li class="list-group-item">
<a href="index.php?view=components&do=config&link=photos"><?php echo $_LANG['AD_PHOTOGALLERY']; ?></a> <?php if($new['photos']) { ?><span class="new_content">+<?php echo $new['photos']?></span><?php } ?>
<a class="fa fa-plus-square right" href="index.php?view=components&do=config&link=photos&opt=add_album" title="<?php echo $_LANG['AD_CREATE_ALBUM']; ?>"></a>
</li>
<?php } ?>
<?php if($inCore->isComponentEnable('video')) {
$new['video'] = (int)newContent('cms_video_movie'); ?>
<li class="list-group-item">
<a href="index.php?view=components&do=config&link=video"><?php echo $_LANG['AD_VIDEOGALLERY']; ?></a> <?php if($new['video']) { ?><span class="new_content">+<?php echo $new['video']?></span><?php } ?>
<a class="fa fa-plus-square right" href="index.php?view=components&do=config&link=video&opt=add_cat" title="<?php echo $_LANG['AD_CREATE_CATEGORY']; ?>"></a>
</li>
<?php } ?>
<?php if($inCore->isComponentEnable('maps')) {
$new['maps'] = (int)newContent('cms_map_items'); ?>
<li class="list-group-item">
<a href="index.php?view=components&do=config&link=maps"><?php echo $_LANG['AD_GEO_CATALOG']; ?></a> <?php if($new['maps']) { ?><span class="new_content">+<?php echo $new['maps']?></span><?php } ?>
<a class="fa fa-plus right" href="index.php?view=components&do=config&link=maps&opt=add_item" title="<?php echo $_LANG['AD_ADD_OBJECT']; ?>"></a>
<a class="fa fa-plus-square right" href="index.php?view=components&do=config&link=maps&opt=add_cat" title="<?php echo $_LANG['AD_CREATE_CATEGORY']; ?>"></a>
</li>
<?php } ?>
<?php if($inCore->isComponentEnable('faq')) {
$new['faq'] = (int)newContent('cms_faq_quests'); ?>
<li class="list-group-item">
<a href="index.php?view=components&do=config&link=faq"><?php echo $_LANG['AD_A&Q']; ?></a> <?php if($new['faq']) { ?><span class="new_content">+<?php echo $new['faq']?></span><?php } ?>
<a class="fa fa-plus right" href="index.php?view=components&do=config&link=faq&opt=add_item" title="<?php echo $_LANG['AD_CREATE_QUESTION']; ?>"></a>
<a class="fa fa-plus-square right" href="index.php?view=components&do=config&link=faq&opt=add_cat" title="<?php echo $_LANG['AD_CREATE_CATEGORY']; ?>"></a>
</li>
<?php } ?>
<?php if($inCore->isComponentEnable('board')) {
$new['board'] = (int)newContent('cms_board_items'); ?>
<li class="list-group-item">
<a href="index.php?view=components&do=config&link=board"><?php echo $_LANG['AD_BOARD']; ?></a> <?php if($new['board']) { ?><span class="new_content">+<?php echo $new['board']?></span><?php } ?>
<a class="fa fa-plus right" href="index.php?view=components&do=config&link=board&opt=add_item" title="<?php echo $_LANG['AD_CREATE_ADVERT']; ?>"></a>
<a class="fa fa-plus-square right" href="index.php?view=components&do=config&link=board&opt=add_cat" title="<?php echo $_LANG['AD_CREATE_RUBRIC']; ?>"></a>
</li>
<?php } ?>
<?php if($inCore->isComponentEnable('catalog')) {
$new['catalog'] = (int)newContent('cms_uc_items'); ?>
<li class="list-group-item">
<a href="index.php?view=components&do=config&link=catalog"><?php echo $_LANG['AD_CATALOG']; ?></a> <?php if($new['catalog']) { ?><span class="new_content">+<?php echo $new['catalog']?></span><?php } ?>
<a class="fa fa-plus right" href="index.php?view=components&do=config&link=catalog&opt=add_item" title="<?php echo $_LANG['AD_CREATE_ITEM'];?>"></a>
<a class="fa fa-plus-square right" href="index.php?view=components&do=config&link=catalog&opt=add_cat" title="<?php echo $_LANG['AD_CREATE_RUBRIC'];?>"></a>
</li>
<?php } ?>
<?php if($inCore->isComponentEnable('forum')) {
$new['forum'] = (int)newContent('cms_forum_posts'); ?>
<li class="list-group-item">
<a href="index.php?view=components&do=config&link=forum&opt=list_forums"><?php echo $_LANG['AD_FORUMS']; ?></a> <?php if($new['forum']) { ?><span class="new_content">+<?php echo $new['forum']?></span><?php } ?>
<a class="fa fa-plus right" href="index.php?view=components&do=config&link=forum&opt=add_forum" title="<?php echo $_LANG['AD_CREATE_FORUM']; ?>"></a>
<a class="fa fa-plus-square right" href="index.php?view=components&do=config&link=forum&opt=add_cat" title="<?php echo $_LANG['AD_CREATE_CATEGORY']; ?>"></a>
</li>
<?php } ?>
</ul>
</div>
<div class="panel panel-default">
<div class="panel-heading"><?php echo $_LANG['AD_USERS']; ?></div>
<ul class="list-group">
<li class="list-group-item fa fa-users">
<a href="index.php?view=users"><?php echo $_LANG['AD_FROM_USERS']; ?></a> — <?php echo cmsCore::c('db')->rows_count('cms_users', 'is_deleted=0'); ?>
</li>
<li class="list-group-item fa fa-users">
<?php echo $_LANG['AD_NEW_USERS_TODAY']; ?> — <?php echo (int)cmsCore::c('db')->get_field('cms_users', "DATE_FORMAT(regdate, '%d-%m-%Y') = DATE_FORMAT(NOW(), '%d-%m-%Y') AND is_deleted = 0", 'COUNT(id)'); ?>
</li>
<li class="list-group-item fa fa-users">
<?php echo $_LANG['AD_NEW_USERS_THEES_WEEK']; ?> — <?php echo (int)cmsCore::c('db')->get_field('cms_users', "regdate >= DATE_SUB(NOW(), INTERVAL 7 DAY)", 'COUNT(id)'); ?>
</li>
<li class="list-group-item fa fa-users">
<?php echo $_LANG['AD_NEW_USERS_THEES_MONTH']; ?> — <?php echo (int)cmsCore::c('db')->get_field('cms_users', "regdate >= DATE_SUB(NOW(), INTERVAL 1 MONTH)", 'COUNT(id)'); ?>
</li>
</ul>
</div>
<div class="panel panel-default">
<div class="panel-heading"><?php echo $_LANG['AD_USERS_ONLINE']; ?></div>
<?php $people = cmsUser::getOnlineCount(); ?>
<ul class="list-group">
<li class="list-group-item fa fa-user">
<?php echo $_LANG['AD_FROM_USERS'] .': '. $people['users']; ?>
</li>
<li class="list-group-item">
<?php echo $_LANG['AD_FROM_GUESTS'] .': '. $people['guests']; ?>
</li>
</ul>
</div>
</td>
<td width="" valign="top" style="">
<div class="panel panel-default">
<div class="panel-heading"><?php echo $_LANG['AD_LATEST_EVENTS']; ?></div>
<div class="panel-body" id="actions_box">
<div id="actions">
<?php
cmsCore::c('actions')->showTargets(true);
$total = cmsCore::c('actions')->getCountActions();
cmsCore::c('db')->limitPage(1, 10);
$actions = cmsCore::c('actions')->getActionsLog();
$pagebar = cmsPage::getPagebar($total, 1, 10, '#" onclick="$.post(\'/admin/ajax/getActions.php\', \'page=%page%\', function(m){ $(\'#actions\').html(m); }); return false');
$tpl_file = 'admin/actions.php';
$tpl_dir = file_exists(TEMPLATE_DIR . $tpl_file) ? TEMPLATE_DIR : DEFAULT_TEMPLATE_DIR;
include($tpl_dir . $tpl_file);
?>
</div>
</div>
</div>
</td>
<td width="325" valign="top" style="">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="100" valign="top">
<?php
$new_quests = cmsCore::c('db')->rows_count('cms_faq_quests', 'published = 0');
$new_content = cmsCore::c('db')->rows_count('cms_content', 'published = 0 AND is_arhive = 0');
$new_catalog = cmsCore::c('db')->rows_count('cms_uc_items', 'on_moderate = 1');
?>
<?php if ($new_quests || $new_content || $new_catalog){ ?>
<div class="panel panel-default">
<div class="panel-heading"><?php echo $_LANG['AD_FROM_MODERATION']; ?></div>
<ul class="list-group">
<?php if ($new_content){ ?>
<li class="list-group-item fa fa-file-o">
<a href="index.php?view=tree&orderby=pubdate&orderto=desc&only_hidden=1"><?php echo $_LANG['AD_ARTICLES']; ?></a> (<?php echo $new_content; ?>)
</li>
<?php } ?>
<?php if ($new_quests){ ?>
<li class="list-group-item fa fa-question-circle">
<a href="index.php?view=components&do=config&link=faq&opt=list_items"><?php echo $_LANG['AD_QUESTIONS']; ?></a> (<?php echo $new_quests; ?>)
</li>
<?php } ?>
<?php if ($new_catalog){ ?>
<li class="list-group-item fa fa-folder">
<a href="index.php?view=components&do=config&link=catalog&opt=list_items&on_moderate=1"><?php echo $_LANG['AD_CATALOG_ITEMS']; ?></a> (<?php echo $new_catalog; ?>)
</li>
<?php } ?>
</ul>
</div>
<?php } ?>
<?php if ($inCore->isComponentInstalled('rssfeed')){ ?>
<div class="panel panel-default">
<div class="panel-heading"><?php echo $_LANG['AD_RSS']; ?></div>
<ul class="list-group">
<li class="list-group-item fa fa-rss">
<a href="/rss/comments/all/feed.rss" id="rss_link"><?php echo $_LANG['AD_RSS_COMENT']; ?> </a>
</li>
<li class="list-group-item fa fa-rss">
<a href="/rss/blogs/all/feed.rss" id="rss_link"><?php echo $_LANG['AD_RSS_BLOGS']; ?></a>
</li>
<li class="list-group-item fa fa-rss">
<a href="/rss/forum/all/feed.rss" id="rss_link"><?php echo $_LANG['AD_RSS_FORUM']; ?></a>
</li>
<li class="list-group-item fa fa-rss">
<a href="/rss/catalog/all/feed.rss" id="rss_link"><?php echo $_LANG['AD_RSS_CATALOG']; ?></a>
</li>
<li class="list-group-item fa fa-rss">
<a href="/rss/content/all/feed.rss" id="rss_link"><?php echo $_LANG['AD_RSS_CONTENT']; ?></a>
</li>
<li class="list-group-item fa fa-rss">
<a href="/rss/board/all/feed.rss" id="rss_link"><?php echo $_LANG['AD_RSS_ADVERTS']; ?></a>
</li>
<li class="list-group-item fa fa-cog">
<a href="index.php?view=components&do=config&id=<?php echo cmsCore::c('db')->get_field('cms_components', "link='rssfeed'", 'id'); ?>" id="rss_link"><?php echo $_LANG['AD_RSS_TUNING']; ?></a>
</li>
</ul>
</div>
<?php } ?>
<div class="panel panel-default">
<div class="panel-heading"><?php echo $_LANG['AD_ICMS_RAVE']; ?></div>
<ul class="list-group">
<li class="list-group-item fa fa-external-link">
<a href="http://cmsrudi.ru/"><?php echo $_LANG['AD_CMSRD_OFFICIAL']; ?></a>
</li>
<li class="list-group-item fa fa-external-link">
<a href="http://cmsrudi.ru/docs"><?php echo $_LANG['AD_CMSRD_DOCUMENTATION']; ?></a>
</li>
<li class="list-group-item fa fa-external-link">
<a href="http://www.instantcms.ru/forum"><?php echo $_LANG['AD_ICMS_FORUM']; ?></a>
</li>
</ul>
</div>
<div class="panel panel-default">
<div class="panel-heading"><?php echo $_LANG['AD_PREMIUM']; ?></div>
<ul class="list-group">
<li class="list-group-item fa fa-usd">
<a href="http://www.instantcms.ru/billing/about.html"><strong><?php echo $_LANG['AD_BILLING']; ?></strong></a> — <?php echo $_LANG['AD_GAIN']; ?>
</li>
<li class="list-group-item fa fa-map-marker">
<a href="http://www.instantmaps.ru/"><strong>InstantMaps</strong></a> — <?php echo $_LANG['AD_OBJECT_TO_MAP']; ?>
</li>
<li class="list-group-item fa fa-shopping-cart">
<a href="http://www.instantcms.ru/blogs/InstantSoft/professionalnyi-magazin-dlja-InstantCMS.html"><strong>InstantShop</strong></a> — <?php echo $_LANG['AD_SHOP']; ?>
</li>
<li class="list-group-item fa fa-film">
<a href="http://www.instantvideo.ru/"><strong>InstantVideo</strong></a> — <?php echo $_LANG['AD_VIDEO_GALERY']; ?>
</li>
</ul>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<?php
return true;
}
