/**
* Carrega uma tabela listando as postagens existentes no sistema
*/
public function listPostsAction()
{
$this->session->start();
if ($this->session->get('user_id') != NULL) {
$vars = $this->getUserLoggedInformation();
$user = Users::findFirstByUser_id($this->session->get('user_id'));
if ($user->user_type_id < 3) {
$posts = Posts::find(array("order" => "post_date_posted DESC"));
} elseif ($user->user_type_id == 3) {
$usr = Users::find(array("conditions" => "user_type_id > :user_type_id: OR user_id = :user_id: ", "bind" => array("user_type_id" => $user->user_type_id, "user_id" => $user->user_id)));
foreach ($usr as $u) {
$arr_id_users[] = $u->user_id;
}
$string_users = implode(",", $arr_id_users);
$posts = Posts::find(array("conditions" => "post_author IN ({$string_users})", "order" => "post_date_posted DESC"));
} else {
$posts = Posts::findByPost_author($user->user_id);
}
$vars['menus'] = $this->getSideBarMenus();
$vars['posts'] = $posts;
$vars['categories'] = $this->getCategoriesByPost($posts);
$this->view->setVars($vars);
$this->view->render("post", "listPosts");
} else {
$this->response->redirect(URL_PROJECT . 'admin');
}
}
