/** * 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 { ?>