public function action_index() { $pagination = \Fuel\Core\Pagination::forge('userprojects', array('pagination_url' => \Fuel\Core\Config::get('pagination.pagination_url', '') . 'user/projects/index/', 'total_items' => Model_Project::count(array('related' => array('customer', 'project_members'), 'where' => array(array('project_members.user_id', $this->current_user->id)))), 'per_page' => \Fuel\Core\Config::get('pagination.per_page', 10), 'num_links' => \Fuel\Core\Config::get('pagination.num_links', 10), 'uri_segment' => \Fuel\Core\Config::get('pagination.uri_segment', 4), 'show_first' => \Fuel\Core\Config::get('pagination.show_first', false), 'show_last' => \Fuel\Core\Config::get('pagination.show_last', false))); $view = Fuel\Core\View::forge('user/projects/index'); $view->set_global('user_is_admin', false); $view->set_global('projects', Model_Project::find('all', array('related' => array('customer', 'project_members'), 'order_by' => array('customer.name' => 'asc', 'name' => 'asc'), 'where' => array(array('project_members.user_id', $this->current_user->id)), 'limit' => $pagination->per_page, 'offset' => $pagination->offset))); $view->set_global('customers', \Fuel\Core\Arr::assoc_to_keyval(Model_Customer::find('all', array('order_by' => array('name' => 'asc'))), 'id', 'name')); $view->set_global('project_statuses', Model_Projectstatus::find('all', array('order_by' => array(array('description', 'asc'))))); $view->set_global('selected_status_id', \Fuel\Core\Config::get('projects.default_status_id', 0)); $view->set_global('user_is_admin', $this->check_user_is_admin()); $view->set_global('project_status_id', 0); $view->set_global('selected_status_id', 0); $view->set_global('pagination', $pagination, false); $view->set_global('admin', false); $this->template->title = 'My Projects'; $this->template->content = $view; }