<?php

/**
 * News
 * 
 * This class has been auto-generated by the Doctrine ORM Framework
 * 
 * @package    mgl
 * @subpackage model
 * @author     Your name here
 * @version    SVN: $Id: Builder.php 7490 2010-03-29 19:53:27Z jwage $
 */
class News extends BaseNews
{
    	public function getSlug()
    {
        return posts::slugify($this->getTitle());
    }
    	public function __toString()
    {
        return $this->getTitle();
    }

        public function getOptions()
    {
        $ids = NewsStatTable::getInstance()->find($this->getId());
        
        return $ids;
    }
	
	
	
	  public function RelatedPost($category_id){
        // $posts = NewsTable::getInstance()->find($this->getId());
        $q = NewsTable::getInstance()->createQuery('a');
		
		$q->innerJoin('a.NewsCategory nc');
		
        $q->andWhere('nc.category_id=?',$category_id);
		
        $q->orderBy('RAND()');
        
		$q->andWhereNotIn('a.id', $this->getId());
        
		$q->limit(8);

        return $q->execute();
    }

    public function GetPhotos(){
        
    	$q = NewsPhotoTable::getInstance()->createQuery('a');
    	$q->where('a.news_id='.$this->getId());

    	return $q->execute();
    }

    public function CurrentCategory(){
    	$q = CategoryTable::getInstance()->find($this->getCategoryId());
    	return $q->getEnname();
    }



    public function HandleType()
    {
        if($this->getType()==1){
            $type = 'Фото';
        }
        elseif($this->getType()==2){
            $type = 'Видео';
        }
        else{
            $type = 'Mэдээ';
        }
        return $type;
    }
    
    public function UpdatePostView(){
            $q = Doctrine_Query::create()
            ->update('NewsStat')
            ->set('nb_view', 'nb_view + 1')
            ->where('news_id = ?', $this->getId())
            ->execute();
    }

      public function save(Doctrine_Connection $conn = null)
  {
    if ($this->isNew()){
      $this->setCreatedAt(date('Y-m-d H:i:s'));
	  $this->setIsPublished(1);	  
    }
   
    return parent::save($conn);
  }
    static protected $choices = array(
        '0' => 'Үйл явдлын мэдээ',
        '1'     => 'Ярилцлага',
        '2'     => 'СЗХ хуралдааны шийдвэр',
		'3'     => 'Сургалт сурчилгаа',
		'4'     => 'Санхүүгийн боловсрол',
		'5'     => 'Шуурхай зар',
		'6'     => 'Үйл явдлын цагалбар',
		'7'     => 'Мультимедиа',
		'8'     => 'Судалгаа шинжилгээ'
    );

    static public function getStatusChoices()
    {
        return self::$choices;
    }
	
}