source: admin/blogs.php @ 3400:765789715255

<?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
$status_combo = array_merge(
     array('-' => ''),
     dcAdminCombos::getBlogStatusesCombo()
);

$sortby_combo = array(
__('Last update') => 'blog_upddt',
__('Blog name') => 'UPPER(blog_name)',
__('Blog ID') => 'B.blog_id',
__('Status') => 'blog_status'
);

$order_combo = array(
__('Descending') => 'desc',
__('Ascending') => 'asc'
);

$q = !empty($_GET['q']) ? $_GET['q'] : '';
$status = isset($_GET['status']) ? $_GET['status'] : '';
$sortby = !empty($_GET['sortby']) ? $_GET['sortby'] : 'blog_upddt';
$order = !empty($_GET['order']) ? $_GET['order'] : 'desc';

$show_filters = false;

$page = !empty($_GET['page']) ? max(1,(integer) $_GET['page']) : 1;
$nb_per_page =  30;

if (!empty($_GET['nb']) && (integer) $_GET['nb'] > 0) {
     if ($nb_per_page != $_GET['nb']) {
          $show_filters = true;
     }
     $nb_per_page = (integer) $_GET['nb'];
}

# - Search filter
if ($q) {
     $params['q'] = $q;
     $show_filters = true;
}

# - Status filter
if ($status !== '' && in_array($status,$status_combo)) {
     $params['blog_status'] = $status;
     $show_filters = true;
} else {
     $status='';
}

# - 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);
     $rsStatic = $rs->toStatic();
     if ($sortby != 'blog_upddt') {
          // Sort blog list using lexical order if necessary
          $rsStatic->extend('rsExtUser');
          $rsStatic = $rsStatic->toExtStatic();
          $rsStatic->lexicalSort(($sortby == 'UPPER(blog_name)' ? 'blog_name' : 'blog_id'),$order);
     }
} catch (Exception $e) {
     $core->error->add($e->getMessage());
}

/* DISPLAY
-------------------------------------------------------- */

dcPage::open(__('List of blogs'),
     dcPage::jsFilterControl($show_filters),
     dcPage::breadcrumb(
          array(
               __('System') => '',
               __('List of blogs') => ''
          ))
);

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="'.$core->adminurl->get("admin.blog").'">'.__('Create a new blog').'</a></p>';
     }

     echo
     '<form action="'.$core->adminurl->get("admin.blogs").'" method="get" id="filters-form">'.
     '<h3 class="out-of-screen-if-js">'.__('Show filters and display options').'</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>'.
     '<p><label for="status" class="ib">'.__('Status:').'</label> '.
     form::combo('status',$status_combo,$status).'</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)
     {
          if( $show_filters ) {
               echo '<p><strong>'.__('No blog matches the filter').'</strong></p>';
          } else {
               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">';

          if( $show_filters ) {
               echo '<caption>'.sprintf(__('%d blog matches the filter.','%d blogs match the filter.',$nb_blog),$nb_blog).'</caption>';
          } else {
               echo '<caption class="hidden">'.__('Blogs list').'</caption>';
          }

          echo
          '<tr>'.
          '<th scope="col" class="nowrap">'.__('Blog id').'</th>'.
          '<th scope="col">'.__('Blog name').'</th>'.
          '<th scope="col" class="nowrap">'.__('URL').'</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 ($rsStatic->fetch()) {
               echo blogLine($rsStatic);
          }

          echo '</table></div>';

          echo $pager->getLinks();
     }
}
dcPage::helpBlock('core_blogs');
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="'.$core->adminurl->get("admin.blog",array('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> ';
     } else {
          $edit_link = $blog_id;
     }

     $img_status = $rs->blog_status == 1 ? 'check-on' : ($rs->blog_status == 0 ? 'check-off' : 'check-wrn');
     $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="'.$core->adminurl->get("admin.home",array('switchblog' => $rs->blog_id)).'" '.
     'title="'.sprintf(__('Switch to blog %s'),$rs->blog_id).'">'.
     html::escapeHTML($rs->blog_name).'</a></td>'.
     '<td class="nowrap"><a class="outgoing" href="'.html::escapeHTML($rs->blog_url).'">'.html::escapeHTML($rs->blog_url).
     ' <img src="images/outgoing-blue.png" alt="" /></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>';
}