<?

	$inc='article';
	

	require("../inc/global.php");	
	//require("../inc/article.class.php");
	require("../inc/top.php");
	
	$action='';
	if (@$pst[0]=='rub') { $action='rub'; }
	elseif (intval(@$pst[0])>0) { $action='show'; }
	
	//обратная навигация
	$mas_back_nav=array();
	$mas_back_nav[]=array('name'=>'Автообзоры','link'=>'/article/');
	
	$pagenamb=(@$_GET['page']);
	
	// ---------- Выводим производителей --------------- //
	$smarty->assign('mas_vendors',list_vendors());
	
	// -------- Экспорт новостей -------- //	
	$smarty->assign('mas_news_block',get_sibnet_articles(4));
	
switch ($action)
{

	  // ---------------------------------------------------------------------------------------------- //
	 // --------------------------- Список статей из каждой рубрики ------------------------------- //
	// ---------------------------------------------------------------------------------------------- //

	default:
	
		$param=array();
		$page_name='Отзывы';
		$qr_str='/article/';
		$vendorid=0;
		$modelid=0;	
		
		//если запрашивают отзывы по модели
		if ($pst[0]=='model')
		{
			$qm="SELECT car_model.id AS modelid,car_model.name AS model,
						vendors.id AS vendorid,vendors.name AS vendor FROM car_model
					INNER JOIN vendors ON (vendors.id=car_model.vendorid)
					 WHERE car_model.id=".intval($pst[1])." LIMIT 1";
			$resm=$DB->query($qm);
			$rowm=$DB->nextRow($resm);
			
			$modelid=$rowm['modelid'];
			
			if ($rowm['modelid']>0)
			{
				$param=array('modelid'=>array($rowm['modelid']));
				$page_name='Отзывы '.$rowm['vendor'].' '.$rowm['model'].' ';
			}
			
			//для сортировки
			$qr_str='/article/model/'.$rowm['modelid'].'/';
			
			//обратная навигация
			$mas_back_nav[]=array('name'=>$rowm['vendor'],'link'=>'/article/vendor/'.$rowm['vendorid'].'/');
			$mas_back_nav[]=array('name'=>$rowm['model'],'link'=>'');
			$smarty->assign('mas_back_nav',$mas_back_nav);
		}		
		//если запрашивают отзывы по производителю
		if ($pst[0]=='vendor')
		{ 
			$qm="SELECT	vendors.id AS vendorid,vendors.name AS vendor FROM vendors WHERE id=".intval($pst[1])." LIMIT 1";
			$resm=$DB->query($qm);
			$rowm=$DB->nextRow($resm);
			
			$vendorid=$rowm['vendorid'];
			
			if ($rowm['vendorid']>0)
			{
				$param=array('vendorid'=>array($rowm['vendorid']));
				$page_name='Отзывы '.$rowm['vendor'];
			}
			//для сортировки
			$qr_str='/article/vendor/'.$rowm['vendorid'].'/';
		
			//обратная навигация
			$mas_back_nav[]=array('name'=>$rowm['vendor'],'link'=>'');
			$smarty->assign('mas_back_nav',$mas_back_nav);
		}
	
	
		$cache_name = 'article_list_'.$pagenamb.'_'.$vendorid.'_'.$modelid;
		$cache_class->cache_name = $cache_name;
		$cache_class->cache_time = 300;
		if ($content = $cache_class->read_cache())
		{
			$maspage = $content['maspage'];
			$mas_article = $content['mas_article'];
		}
		else
		{
			$mas_article=array();		
		
		
			// ------- постраничная ------------------ //
			$qt="SELECT COUNT(*) AS total FROM article WHERE article.date<".time()." AND article.publ=1 LIMIT 1";
			$maspage=pagebegin($qt,10,$pagenamb,'/article/&');
			$pagesqllim=$maspage['pagelim'];
					
			//брем статьи
			$q="SELECT article.id,article.date,article.name,article.anons,article.img,article.ctview,article.ctcomments FROM article
				WHERE article.publ=1	
				ORDER BY article.date DESC ".$pagesqllim;
			$res=$DB->query($q);
			while ($row=$DB->nextRow($res))
			{
				
				$mas_article[]=$row;
			}
			
			$content=array('maspage'=>$maspage,'mas_article'=>$mas_article);			
						
			//пишем в кеш
			$cache_class->write_cache($content);
		}
		
		$smarty->assign('pagenav',$maspage["maspage"]);
		$smarty->assign('mas_article',$mas_article);
		$smarty->display('article/article_main.tpl');	
		
	break;


	  // ---------------------------------------------------------------------------------------------- //
	 // --------------------------- Смотрим статью  -------------------------------------------------- //
	// ---------------------------------------------------------------------------------------------- //	
	case 'show':
	
		$id=intval(@$pst[0]);
		$smarty->assign('selimg',intval(@$_GET['img']));
	
		$q="SELECT * FROM article WHERE id=".$id." AND publ=1 LIMIT 1";
		$res=$DB->query($q);
		$row=$DB->nextRow($res);
	
		if ($row['id']>0)
		{
			//выводим фотки
			$mas_img=array();
			$qimg="SELECT * FROM article_img WHERE recid=".$row['id']." ORDER BY sort ASC";
			$resimg=$DB->query($qimg);
			while ($rowimg=$DB->nextRow($resimg))
			{
				$mas_sizes=unserialize($rowimg['sizes']);
				unset($rowimg['sizes']);
				$rowimg['w_big']=$mas_sizes[0]['w'];
				$rowimg['h_big']=$mas_sizes[0]['h'];
				$mas_img[]=$rowimg;
			}
			
			$smarty->assign('mas_foto',$mas_img);
		
			$sql='';
			$mas_model=array();
			$mas_cat_car=array();
			$mas_cars=array();
			$ct=0;
			//выводим модели к которым привязана статья
			$q_link_model="SELECT vendors.id AS vendorid,vendors.name AS vendor,vendors.link AS vendor_link,
					car_model.id AS modelid,car_model.name AS model,car_model.link AS model_link,car_model.img,car_model.archiv
					FROM article_link
					INNER JOIN car_model ON (car_model.id=article_link.modelid)
					INNER JOIN vendors ON (vendors.id=car_model.vendorid)
					 WHERE articleid=".intval($row['id']);
			$res_link_model=$DB->query($q_link_model);
			while ($rowlink=$DB->nextRow($res_link_model))
			{
				$mas_model[$rowlink['modelid']]=$rowlink;
				
				if ($ct>0) { $sql.=','; }
				$sql.=$rowlink['modelid'];
				$ct++;
			}
			
			if ($ct>0) 
			{			
				$i=0;
				//беру модели из каталолга к которым привязана статья
				$qm="SELECT modelid,MAX(car.cost) AS cost_to,MIN(car.cost) AS cost_from,car.kuzov
						FROM car_cat AS car WHERE car.modelid IN (".$sql.") GROUP BY car.modelid LIMIT 5";
				$resm=$DB->query($qm);
				while ($rowm=$DB->nextRow($resm))
				{
					$mas_cat_car[$i]=$mas_model[$rowm['modelid']];
					$mas_cat_car[$i]['cost_from']=$rowm['cost_from'];
					$mas_cat_car[$i]['cost_to']=$rowm['cost_to'];
					$mas_cat_car[$i]['kuzov']=$rowm['kuzov'];
					$i++;
				}		
				
				$i=0;
				//беру авто из доски к которым привязана статья
				$qm="SELECT id,modelid,kuzov,cost,img,cityid FROM car_sale WHERE modelid IN (".$sql.") ORDER BY id DESC LIMIT 5";
				$resm=$DB->query($qm);
				while ($rowm=$DB->nextRow($resm))
				{					
					$mas_cars[$i]=$mas_model[$rowm['modelid']];
					$mas_cars[$i]['id']=$rowm['id'];
					$mas_cars[$i]['cost']=$rowm['cost'];
					$mas_cars[$i]['img']=$rowm['img'];
					$mas_cars[$i]['kuzov']=$rowm['kuzov'];
					$mas_cars[$i]['cityid']=$rowm['cityid'];
					$i++;
				}		
			}
			
			$smarty->assign('mas_models_block',$mas_cat_car);	
			$smarty->assign('mas_cars_block',$mas_cars);
			
			
			//выводим последнии статьи
			$mas_articles=get_articles(10);
			$smarty->assign('mas_articles_block',$mas_articles);	
			

			//метатеги
			if ($row['tit']=='') { $row['tit']=$row['name']; }
			if ($row['tit']<>'') { $smarty->assign('toptitle',$row['tit']); }
			if ($row['des']<>'') { $smarty->assign('des',$row['des']); }
			if ($row['keyw']<>'') { $smarty->assign('keyw',$row['keyw']); }
			
			
			$selimg=intval(@$_GET['img']);
			$smarty->assign('img',$selimg);	
			
			$smarty->assign('rowtit',$row);
			
			
			//комментарии с постраничной
			$pagenamb=@$_GET['page'];
			$smarty->assign('pagenamb',$pagenamb);			
			$mas_comments=show_comments($row['commentsid'],$row['ctcomments'],10,$pagenamb,'/article/'.$row['id'].'/&');
			$smarty->assign('pagenav',$mas_comments["maspage"]);			
			$smarty->assign('mas_comments',$mas_comments['comments']);
			
			//$obj_favorite=array('name'=>'article','objectid'=>$id,'yourfavorite'=>intval(check_user_favorite_article($id)));
			//$smarty->assign('obj_favorite',$obj_favorite);
			
			$mas_back_nav[]=array('name'=>$row['name'],'link'=>'');
			
			$smarty->assign('mas_back_nav',$mas_back_nav);
			
			$smarty->display('article/article_show.tpl');
			
			add_one_views('article',$row['id']);
		}
		
	
	break;
	
}


	require("../inc/bottom.php");
?>