public function indexAction()
{
$arrayModel = array('funcao', 'escolaridade');
foreach ($arrayModel as $item) {
$model = ucfirst($item) . 'Model';
$model = new $model();
$this->view->{$item} = $model->fetchAll();
}
$model = new VagaModel();
$arrayCols = array('cidade', 'bairro', 'estado_civil', 'area_atuacao');
foreach ($arrayCols as $item) {
$this->view->{$item} = $model->getItens($item);
}
$dicaModel = new DicaModel();
$noticiaModel = new NoticiaModel();
$this->view->dicas = $dicaModel->fetchAll($dicaModel->getDicaHome());
$this->view->noticias = $noticiaModel->fetchAll($noticiaModel->getNoticiaHome());
try {
$twitterBusinnes = new TwitterBusiness();
$this->view->tweets = $twitterBusinnes->getTweets();
} catch (Exception $e) {
}
try {
$this->view->videos = YouTubeBusiness::getVideos();
} catch (Exception $e) {
}
$model = new BlogPostModel();
$select = $model->select()->distinct()->from(array('p1' => 'wp_posts'), array('p1.id', 'p1.post_content', 'p1.post_title', 'p1.post_status', 'p1.post_parent', 'date_format(p1.post_date, \'%d/%m - %H:%i\') as post_date', 'p1.guid', 'p1.post_type'))->joinLeft(array('p2' => 'wp_posts'), 'p2.post_parent = p1.id AND p2.post_type = "attachment"', array('image_url' => 'p2.guid'))->order('p1.post_date DESC')->group('p1.id')->limit(4)->where('p1.post_status != ?', 'trash')->where('p1.post_status != ?', 'auto-draft')->where('p1.post_type = ?', 'post');
$rows = $model->fetchAll($select);
$this->view->post = $rows;
}
public function defaultPost()
{
$data = new BlogPostModel();
$data->setId('');
$data->setTitle('');
$data->setBody('');
$data->setDateCreated(date('Y-m-d H:i:s'));
return $data;
}
/**
* Удаление поста из раздела блога
*/
public function PostDeleteAction()
{
$request = Project::getRequest();
$request_user_id = (int) Project::getUser()->getShowedUser()->id;
$user_id = (int) Project::getUser()->getDbUser()->id;
$post_id = $request->getKeyByNumber(0);
$page_number = $request->getKeyByNumber(1);
// Delete comments
$comment_model = new BlogCommentModel();
$comment_model->deleteByItem($user_id, $post_id);
// Delete posts
$post_model = new BlogPostModel();
$post_model->load($post_id);
$tree_id = $post_model->ub_tree_id;
$post_model->delete($post_id);
Project::getResponse()->redirect($request->createUrl('Blog', 'PostList', array($tree_id, $page_number)));
// TODO:: need to delete warnings?
}
