/**
* Index action
*/
public function indexAction()
{
$page = $this->request->getQuery('page', 'int', 1);
$limit = $this->request->getQuery('limit', 'int', 5);
$orderBy = $this->request->getQuery('order', 'string', 'id');
$searchName = $this->request->getQuery('q', 'string', null);
$projects = new Projects();
$totalCount = $projects->count();
$qOrderAsc = $this->request->getQuery('asc', 'int', 1);
$orderAsc = $qOrderAsc == 1 ? ' ASC' : ' DESC';
$builder = $this->modelsManager->createBuilder()->columns('*')->from('Projects')->orderBy($orderBy . ' ' . $orderAsc);
if ($searchName !== null) {
$builder->andWhere("name like '%{$searchName}%'")->orWhere("uri like '%{$searchName}%'");
}
$paginator = new PaginatorQueryBuilder(array("builder" => $builder, "limit" => $limit, "page" => $page));
$paginate = $paginator->getPaginate();
if ($page > $paginate->last && $paginate->last > 0) {
$q = $this->request->getQuery();
if ($totalCount > 0 && $limit > $totalCount) {
$q['page'] = $paginate->last;
return $this->response->redirect($this->url->get('', $q));
} elseif ($totalCount > 0) {
return $this->dispatcher->forward(['controller' => 'error', 'action' => 'error404']);
}
}
$this->view->setVar("totalProjects", $totalCount);
$this->view->setVar("projectList", $paginate);
}
/**
* Return number of projects in a specific group
*
* @param ProjectGroup $group
* @return integer
*/
function countByGroup($group)
{
return Projects::count(array('group_id = ? AND type = ?', $group->getId(), PROJECT_TYPE_NORMAL));
}
/**
* Return total number of projects
*
* @access public
* @param void
* @return integer
*/
function countProjects()
{
if ($this->isOwner()) {
return Projects::count();
// all
} else {
return ProjectCompanies::count('`company_id` = ' . DB::escape($this->getId()));
}
// if
}
<b><?php
echo '<a class="internalLink dashboard-link" href="' . get_url('account', 'index') . '">' . lang('new account step update account', $step) . '</a>';
?>
</b><br/>
<?php
echo lang('new account step update account info');
?>
<br/><br/>
<?php
}
// if
$step++;
?>
<?php
if (count(Projects::count('`created_by_id` = ' . logged_user()->getId())) > 0) {
?>
<p><b><?php
echo '<a class="internalLin dashboard-link" href="' . get_url('project', 'add') . '">' . lang('new account step start workspace', $step) . '</a>';
?>
</b><img src="<?php
echo image_url('16x16/complete.png');
?>
"/></p>
<?php
echo lang('new account step start workspace info', '<span class="ico-workspace-add" style="padding: 5px 16px 0 0"> </span>', logged_user()->getPersonalProject()->getName());
?>
<br/><br/>
<?php
} else {
?>
