'blog_upddt',
__('Blog name') => 'UPPER(blog_name)',
__('Blog ID') => 'B.blog_id'
);
$order_combo = array(
__('Descending') => 'desc',
__('Ascending') => 'asc'
);
$q = !empty($_GET['q']) ? $_GET['q'] : '';
$sortby = !empty($_GET['sortby']) ? $_GET['sortby'] : 'blog_upddt';
$order = !empty($_GET['order']) ? $_GET['order'] : 'desc';
$page = !empty($_GET['page']) ? $_GET['page'] : 1;
$nb_per_page = 30;
if (!empty($_GET['nb']) && (integer) $_GET['nb'] > 0) {
$nb_per_page = (integer) $_GET['nb'];
}
$show_filters = false;
# - Search filter
if ($q) {
$params['q'] = $q;
$show_filters = true;
}
# - Sortby and order filter
if ($sortby !== '' && in_array($sortby,$sortby_combo)) {
if ($order !== '' && in_array($order,$order_combo)) {
$params['order'] = $sortby.' '.$order;
}
if ($sortby != 'blog_upddt' || $order != 'desc') {
$show_filters = true;
}
}
$params['limit'] = array((($page-1)*$nb_per_page),$nb_per_page);
try {
$counter = $core->getBlogs($params,1);
$rs = $core->getBlogs($params);
$nb_blog = $counter->f(0);
} catch (Exception $e) {
$core->error->add($e->getMessage());
}
/* DISPLAY
-------------------------------------------------------- */
$starting_script = '';
if (!$show_filters) {
$starting_script .= dcPage::jsLoad('js/filter-controls.js');
}
dcPage::open(__('List of blogs'),$starting_script);
if (!empty($_GET['del'])) {
echo ''.__('Blog has been successfully deleted.').'
';
}
echo ''.__('List of blogs').'
';
if (!$core->error->flag())
{
if ($core->auth->isSuperAdmin()) {
echo ''.__('Create a new blog').'
';
}
if (!$show_filters) {
echo ''.__('Filters').'
';
}
echo
'';
# Show blogs
if ($nb_blog == 0)
{
echo ''.__('No blog').'
';
}
else
{
$pager = new pager($page,$nb_blog,$nb_per_page,10);
$pager->var_page = 'page';
echo ''.__('Page(s)').' : '.$pager->getLinks().'
';
echo
''.
'| '.__('Blog name').' | '.
''.__('Last update').' | '.
''.__('Entries').' | '.
''.__('Blog ID').' | '.
' | '.
''.__('Status').' | '.
'
';
while ($rs->fetch()) {
echo blogLine($rs);
}
echo '
';
echo ''.__('Page(s)').' : '.$pager->getLinks().'
';
}
}
dcPage::close();
function blogLine($rs)
{
global $core;
$blog_id = html::escapeHTML($rs->blog_id);
$edit_link = '';
if ($GLOBALS['core']->auth->isSuperAdmin()) {
$edit_link =
''.
__('edit').'';
}
$img_status = $rs->blog_status == 1 ? 'check-on' : 'check-off';
$txt_status = $GLOBALS['core']->getBlogStatus($rs->blog_status);
$img_status = sprintf('
',$img_status,$txt_status);
$offset = dt::getTimeOffset($core->auth->getInfo('user_tz'));
$blog_upddt = dt::str(__('%Y-%m-%d %H:%M'),strtotime($rs->blog_upddt) + $offset);
return
''.
'| '.
html::escapeHTML($rs->blog_name).' | '.
''.$blog_upddt.' | '.
''.$core->countBlogPosts($rs->blog_id).' | '.
''.$blog_id.' | '.
''.$edit_link.' | '.
''.$img_status.' | '.
'
';
}
?>