<?php

class BlogController extends Controller
{
public function filters()
{
    return array(
        array(
            'COutputCache + show, cat',
            'duration'=>60*10,
            'varyByParam'=>array('id', 'url', 'page', 'order', 'mess'),
	    'requestTypes'=>array('GET')
	    
        ),
    );
}

public function actionTemp()
{
    
    $users = Yii::app()->db->createCommand("DELETE
    FROM  `hmb_togo_click` click
    LEFT JOIN hmb_blog user_blog ON user_blog.user_id = click.user_id
    WHERE click.blog_id = user_blog.id
    ")->execute();
    
}


	public function actionEdit()
	{
	if(!Yii::app()->user->id) $this->redirect(array('user/login'));

	$model=Blog::model()->findByPk($_GET['id']);
	
	$manys=array('cats');
	foreach($manys as $name)
		{
		$var_name=$name.'Ids';
		$model->$name=$_POST['Blog'][$var_name];
		}
	
	if($_POST['Blog'])
		{
		$model->attributes=$_POST['Blog'];
		if($_POST['to_moder']==1) $model->moderated=2;
		
		if($model->save())
			$success=1;
		else 
			$success=2;
		}
		
	Stat::write('blog_edit', $model->id);
	$this->render('edit', array('model'=>$model, 'success'=>$success));
	}
	
	public function actionNew()
	{
	if(!Yii::app()->user->id) $this->redirect(array('user/login'));
	$user_blog=Blog::model()->findByAttributes(array('user_id'=>Yii::app()->user->id));
	if($user_blog) $this->redirect(array('blog/edit', 'id'=>$user_blog->id));
	
	
	$model=new Blog;
	
	$manys=array('cats');
	foreach($manys as $name)
		{
		$var_name=$name.'Ids';
		$model->$name=$_POST['Blog'][$var_name];
		}
	
	
	if($_POST['Blog'])
		{
		$model->attributes=$_POST['Blog'];
		$model->user_id=Yii::app()->user->id;
		$model->moderated=0;
		if($model->save())
			{
			Stat::write('blog_new', $model->id);
			$success=1;
			}
		else 
			$success=2;
		
		}
	$this->render('new', array('model'=>$model, 'success'=>$success));
	}
	
	public function actionIndex()
	{
	$this->pageTitle=Yii::app()->name.': '.' сервис взаимопомощи блоггерам!';
	
	$dependency = new CDbCacheDependency('SELECT MAX(id) FROM hmb_service WHERE name="garant"');
	if(isset(Yii::app()->user->id) AND isset(User::model()->findByPk(Yii::app()->user->id)->blogs->id))
			    {
			    $userBlogCats=User::model()->findByPk(Yii::app()->user->id)->blogs->cats;
			    $userTxtCat='';
			    foreach($userBlogCats as $cat)
				    $userTxtCat.=','.$cat->id;
			    $userTxtCat=substr($userTxtCat,1);
			    
		
		$models = Blog::model()
		->cache(60*10, $dependency)
		->with(
		    array('user',
			  'user.services'=>
			    array('alias'=>'service'),
			  'user.blogs.cats'=>
			    array('alias'=>'cats'),
			  )
		      )
		->together(true)
		->findAll(
		    array(
			  //'select'=>'t.*',
			  'condition'=>
			    'service.name="garant" AND service.val>0 AND t.moderated=1',
			  'order'=>//'service.id DESC'
			    '(cats.id IN ('.$userTxtCat.')) DESC, service.id DESC'
			));
		
			    }
		    else
		{
		
			    $models = Blog::model()->cache(60*10, $dependency)->with(array('user', 'user.services'=>array
	    ('alias'=>'service')
	    ))->findAll(array('condition'=>'service.name="garant" AND service.val>0 AND t.moderated=1', 'order'=>'service.id DESC'));
		}
            
    
 
	$this->render('garant', array('blogs'=>$models));
    
	Stat::write('main', $_GET['page']);
	//$this->render('garant', array('blogs'=>$models, 'pages'=>$pages));
	}
	
	public function actionShow($id)
	{
	$blog=Blog::model()->findByPk($id);
	if($blog->moderated!=1) throw new CHttpException(403,'Этот блог еще не прошел модерацию');

	$user=$blog->user;
	
	if($_POST['Comment'])
		{
		$comment=new Comment;
		$comment->attributes=$_POST['Comment'];
		$comment->moderated=1;
		$comment->user_id=Yii::app()->user->id;
		$comment->date=date("Y-m-d H:i:s");
		if($comment->save())
			{
			$mess=1;
			Stat::write('comment_send', $comment->id);
			}
		elseif($comment->parent_id==0)
			{$captcha_error='Неверный ввод капчи';}
		else
			$this->redirect(array('blog/show', 'id'=>$blog->id, 'mess'=>$mess));
		}
	
	Stat::write('blog_show', $blog->id);
	$this->render('show', array('blog'=>$blog, 'user'=>$user, 'mess'=>$mess, 'captcha_error'=>$captcha_error));
	}
	
	public function actionCat()
	{
	$cat=Cat::model()->findByAttributes(array('url'=>$_GET['url']));
	//$blogs=Blog::model()->with(array('cats'=>array('alias'=>'catz')))->findAll(array('condition'=>'catz.url="'.$_GET['url'].'"'));
	
	switch($_GET['order'])
		{
		case 'helpasc':
		$order='helpcount ASC';
		break;
		case 'helpdesc':
		$order='helpcount DESC';
		break;
		
		default:
		$order='t.id DESC';
		}
        
	for($i=1; $i<4;$i++)
	{
	if(Service::model()->count('name="top'.$i.'" AND val>'.time().' AND act_id="'.$cat->id.'"')==0)
		{
		$service_to_del=Service::model()->findAll('name="top'.$i.'" AND val<'.time().' AND val>1 AND act_id="'.$cat->id.'"');
		foreach($service_to_del as $mod)
			$mod->delete();
			
		if($new_service=Service::model()->find(array(
			'condition'=>'name="top'.$i.'" AND val=1 AND act_id="'.$cat->id.'"',
			'order'=>'id ASC',
			'limit'=>1
												 )
											))
			{
			$new_service->val=time()+60*60*Service::TOP_TIME;
			$new_service->save();
			}
		}
	}
        
	$criteria = new CDbCriteria();
	$criteria->with=array('user', 'user.services'=>array('alias'=>'service'));
	$criteria->together=true;
	$criteria->condition='(service.name="top1" OR service.name="top2" OR service.name="top3") AND service.val>'.time().' AND service.act_id='.$cat->id;
	$criteria->order='service.name ASC';
	$top_blogs=Blog::model()->findAll($criteria);
	
	
	$criteria = new CDbCriteria();
	$criteria->select='t.*, IFNULL( count(help.id), 0) as helpcount, (SELECT cat_id FROM hmb_blog_cat cc WHERE  cc.blog_id=t.id ORDER BY cat_id ASC Limit 1) as first_cat';
	$criteria->join="LEFT JOIN hmb_blog_cat bc ON t.id=bc.blog_id
					 LEFT JOIN hmb_cat c ON bc.cat_id=c.id
					 LEFT JOIN hmb_togo_click help ON help.blog_id=t.id

					 ";
	
	$criteria->condition='c.url="'.$_GET['url'].'" AND t.moderated=1';
	$criteria->group='t.id';
	$criteria->order=$order;
	//$criteria->limit=100;
    $count=Blog::model()->count($criteria);
 
    $pages=new CPagination($count);
    
    $pages->pageSize=10;
    $pages->applyLimit($criteria);
 
    $models = Blog::model()->findAll($criteria);
 
	Stat::write('cat', $cat->id);
	$this->render('cat', array('cat'=>$cat, 'blogs'=>$models, 'top_blogs'=>$top_blogs, 'pages'=>$pages));
	}
	
	public function actionGarant()
	{
	
     $models = Blog::model()->with(array('user', 'user.services'=>array
													('alias'=>'service')
							))->findAll(array('condition'=>'service.name="garant" AND service.val>0', 'order'=>'service.id DESC'));
 
	$this->render('garant', array('blogs'=>$models));
	}
	
	public function commentBlock($id)
	{
	$comments=Comment::model()->findAll(array(
								'condition'=>'blog_id="'.$id.'" AND parent_id=0 AND moderated=1',
								'order'=>'id DESC'
								));
	if(count($comments>0)) foreach($comments as $comment)
		$this->commentBlockOne($comment, 1);
	}
	
	public function commentBlockOne($comment, $depth)
	{
	$this->renderPartial('commentBlock', array('comment'=>$comment, 'depth'=>$depth));
	$comments=Comment::model()->findAll(array(
								'condition'=>'blog_id="'.$comment->blog->id.'" AND parent_id="'.$comment->id.'" AND moderated=1',
								'order'=>'id DESC'
								));
								
	if(count($comments>0)) foreach($comments as $comment)
		$this->commentBlockOne($comment, $depth+1);
		
	}
	public function renderUserBlock($blog='')
    {
    $blog=Blog::model()->findbyPk($_GET['id']);
     return $this->renderPartial('userBlock', array('blog'=>$blog), true);   
        
    }
public function actionTogo($blog_id, $user_id=0, $post_id=0)
	{
    if(strcmp(intval($blog_id),$blog_id)==0)
        {
        $blog=Blog::model()->cache(60)->findByPk($blog_id);
        }
    else
        {            
        $blog=User::model()->cache(60)->find('login="'.$blog_id.'"')->blogs;
        }
       
	if($blog)
		{
	    TogoClick::addClick($blog, $user_id, $post_id);
        
        //Stat::write('togo', $blog->id);
        
		if($post_id==0)
			$this->redirect($blog->url);
		else
			$this->redirect(BlogPost::model()->find('post_id="'.$post_id.'" AND blog_id="'.$blog->id.'"')->url);
		}
	else
		throw new CHttpException(404,'Нет такого блога');
	}
}