source: admin/blogs.php @ 2002:a0de6679a058

<?php
# -- BEGIN LICENSE BLOCK ---------------------------------------
#
# This file is part of Dotclear 2.
#
# Copyright (c) 2003-2013 Olivier Meunier & Association Dotclear
# Licensed under the GPL version 2.0 license.
# See LICENSE file or
# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
#
# -- END LICENSE BLOCK -----------------------------------------

require dirname(__FILE__).'/../inc/admin/prepend.php';

dcPage::check('usage,contentadmin');

# Filters
$sortby_combo = array(
__('Last update') => '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']) ? max(1,(integer) $_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,
     dcPage::breadcrumb(
          array(
               __('System') => '',
               '<span class="page-title">'.__('List of blogs').'</span>' => ''
          ))
);

if (!empty($_GET['del'])) {
     dcPage::success(__('Blog has been successfully deleted.'));
}

if (!$core->error->flag())
{
     if ($core->auth->isSuperAdmin()) {
          echo '<p class="top-add"><a class="button add" href="blog.php">'.__('Create a new blog').'</a></p>';
     }
     
     if (!$show_filters) {
          echo '<p><a id="filter-control" class="form-control" href="#">'.__('Filter blogs list').'</a></p>';
     }
     
     echo
     '<form action="blogs.php" method="get" id="filters-form">'.
     '<h3 class="hidden">'.__('Filter blogs list').'</h3>'.
     
     '<div class="table">'.
     '<div class="cell">'.
     '<h4>'.__('Filters').'</h4>'.
     '<p><label for="q" class="ib">'.__('Search:').'</label> '.
     form::field('q',20,255,html::escapeHTML($q)).'</p>'.
     '</div>'.
     
     '<div class="cell filters-options">'.
     '<h4>'.__('Display options').'</h4>'.
     '<p><label for="sortby" class="ib">'.__('Order by:').'</label> '.
     form::combo('sortby',$sortby_combo,html::escapeHTML($sortby)).'</p>'.
     '<p><label for="order" class="ib">'.__('Sort:').'</label> '.
     form::combo('order',$order_combo,html::escapeHTML($order)).'</p>'.
     '<p><span class="label ib">'.__('Show').'</span> <label for="nb" class="classic">'.  
     form::field('nb',3,3,$nb_per_page).' '.__('blogs per page').'</label></p>'.
     '</div>'.
     '</div>'.

     '<p><input type="submit" value="'.__('Apply filters and display options').'" />'.
     '<br class="clear" /></p>'. //Opera sucks
     '</form>';
     
     # Show blogs
     if ($nb_blog == 0)
     {
          echo '<p><strong>'.__('No blog').'</strong></p>';
     }
     else
     {
          $pager = new dcPager($page,$nb_blog,$nb_per_page,10);
          
          echo $pager->getLinks();
          
          echo
          '<div class="table-outer">'.
          '<table class="clear"><caption class="hidden">'.__('Blogs list').'</caption><tr>'.
          '<th scope="col" class="nowrap">'.__('Blog id').'</th>'.
          '<th scope="col">'.__('Blog name').'</th>'.
          '<th scope="col" class="nowrap">'.__('Entries (all types)').'</th>'.
          '<th scope="col" class="nowrap">'.__('Last update').'</th>'.
          '<th scope="col" class="nowrap">'.__('Status').'</th>'.
          '</tr>';
          
          while ($rs->fetch()) {
               echo blogLine($rs);
          }
          
          echo '</table></div>';
          
          echo $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 = 
          '<a href="blog.php?id='.$blog_id.'"  title="'.sprintf(__('Edit blog settings for %s'),$blog_id).'">'.
          '<img src="images/edit-mini.png" alt="'.__('Edit blog settings').'" /> '.$blog_id.'</a> ';
     }
     
     $img_status = $rs->blog_status == 1 ? 'check-on' : 'check-off';
     $txt_status = $GLOBALS['core']->getBlogStatus($rs->blog_status);
     $img_status = sprintf('<img src="images/%1$s.png" alt="%2$s" title="%2$s" />',$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
     '<tr class="line">'.
     '<td class="nowrap">'.$edit_link.'</td>'.
     '<td class="maximal"><a href="index.php?switchblog='.$rs->blog_id.'" '.
     'title="'.sprintf(__('Switch to blog %s'),$rs->blog_id).'">'.
     html::escapeHTML($rs->blog_name).'</a></td>'.
     '<td class="nowrap count">'.$core->countBlogPosts($rs->blog_id).'</td>'.
     '<td class="nowrap count">'.$blog_upddt.'</td>'.
     '<td class="status">'.$img_status.'</td>'.
     '</tr>';
}
?>