'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'; $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; } # - 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 -------------------------------------------------------- */ $form_filter_title = __('Show filters and display options'); $starting_script = dcPage::jsLoad('js/filter-controls.js'); $starting_script .= '"; dcPage::open(__('List of blogs'),$starting_script, 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 '

'.__('Create a new blog').'

'; } echo '
'. ''. '
'. '
'. '

'.__('Filters').'

'. '

'. form::field('q',20,255,html::escapeHTML($q)).'

'. '
'. '
'. '

'.__('Display options').'

'. '

'. form::combo('sortby',$sortby_combo,html::escapeHTML($sortby)).'

'. '

'. form::combo('order',$order_combo,html::escapeHTML($order)).'

'. '

'.__('Show').'

'. '
'. '
'. '

'. '

'. //Opera sucks '
'; # Show blogs if ($nb_blog == 0) { if( $show_filters ) { echo '

'.__('No blog matches the filter').'

'; } else { echo '

'.__('No blog').'

'; } } else { $pager = new dcPager($page,$nb_blog,$nb_per_page,10); echo $pager->getLinks(); echo '
'. ''; if( $show_filters ) { echo ''; } else { echo ''; } echo ''. ''. ''. ''. ''. ''. ''. ''; while ($rsStatic->fetch()) { echo blogLine($rsStatic); } echo '
'.sprintf(__('%d blog matches the filter.','%d blogs match the filter.',$nb_blog),$nb_blog).'
'.__('Blog id').''.__('Blog name').''.__('URL').''.__('Entries (all types)').''.__('Last update').''.__('Status').'
'; 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 = ' $blog_id)).'" title="'.sprintf(__('Edit blog settings for %s'),$blog_id).'">'. ''.__('Edit blog settings').' '.$blog_id.' '; } 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('%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 ''. ''.$edit_link.''. ' $rs->blog_id)).'" '. 'title="'.sprintf(__('Switch to blog %s'),$rs->blog_id).'">'. html::escapeHTML($rs->blog_name).''. ''.html::escapeHTML($rs->blog_url). ' '. ''.$core->countBlogPosts($rs->blog_id).''. ''.$blog_upddt.''. ''.$img_status.''. ''; }