<?

	$inc='dealers';	

	require("../inc/global.php");		
	require("../inc/top.php");
	include("../inc/users.class.php");
	require("../inc/Dealers.class.php");
	
	$action=@$_GET['action'];	
	if (@$pst[0]<>'') { $action=$pst[0]; }
	if (isset($_POST['action'])) { $action=$_POST['action']; }
	
	$pageurl='/dealers/';
	$smarty->assign('pageurl',$pageurl);
	
	$pagenamb=intval(@$_GET['page']);
	$smarty->assign('pagenamb',$pagenamb);
	
	$dealer= new Dealers();
	
	$cmurl='';
	if (isset($_GET['cityid'])) {
		$cityid=intval($_GET['cityid']);
		$smarty->assign('sel_regionid',intval(@$_GET['regionid']));
		$smarty->assign('sel_city_name',$mas_city_by_id[$cityid]);
		$cmurl.='&cityid='.$cityid;
	}
	else {
		$cityid=1;
		//$smarty->assign('sel_regionid',0);
		$smarty->assign('sel_city_name','Новосибирск');	
	}
	if ($cityid==0) $sql_city='AND usr.cityid>0';
		else $sql_city='AND usr.cityid='.$cityid;
		
	$smarty->assign('sel_cityid',$cityid);
	
	if (@$_GET['markid']) {
		$markid=intval($_GET['markid']);
		$cmurl.='&markid='.$markid;
		}
	else {
		$markid=0;
	}
	
	// ----------- Выводим акции ------------- //
	$mas_share=get_share(1);
	$smarty->assign('share',$mas_share);
	
	$smarty->assign('mas_dealer_cities',$dealer->get_rel_cities());
	$smarty->assign('cmurl',$cmurl);
	
	if ($cityid>0) {
		$smarty->assign('toptitle','Автосалоны в '.$mas_city_by_pname[$cityid]);
		$smarty->assign('topdes','Автосалоны в '.$mas_city_by_pname[$cityid].'. Продажа автомобилей. Новые и аукционные автомобили в автосалонах города '.$mas_city_by_id[$cityid].'.');
	}
	else {
		$smarty->assign('toptitle','Автосалоны');
		$smarty->assign('topdes','Автосалоны. Продажа автомобилей. Новые и аукционные автомобили в автосалонах.');
	}
	
	$pagenamb=intval(@$_GET['page']);
	$sort=@$_GET['sort'];
	$asc=intval(@$_GET['asc']);
	
	$user = new users_class();
	$smarty->assign('bit',$user->load());
	$smarty->assign('mas_user_settings',$user->mas_user_settings);
		
switch ($action)
{
	default:
	
		// ------- постраничная ------------------ //
		if ($markid==0) $sql_mark='';
			else $sql_mark=" INNER JOIN rel_dealer_vendor AS rel ON (rel.dealerid=usr.id AND rel.vendorid=".$markid.")  ";
		$qt="SELECT COUNT(*) AS total FROM users AS usr ".$sql_mark." WHERE (status=3 OR status=4) ".$sql_city." LIMIT 1";
		$maspage=pagebegin($qt,20,$pagenamb,$pageurl.$cmurl.'&');
		$pagesqllim=$maspage['pagelim'];
		$smarty->assign('pagenav',$maspage["maspage"]);
		$smarty->assign('total',$maspage["total"]);
		
		
		$smarty->assign('mas_dealers',$dealer->dealers_lst($pagesqllim,0,$sql_city,$markid));
		
		$smarty->display('dealers/dealers.tpl');
		
	break;

	case 'showdealer':
	
		$dealerid=intval($pst[1]);
		
		// Определяем общее количество объявлений автосалона				
		
		$qt="SELECT sum( adet ) AS total
			FROM (
			
			SELECT count( * ) AS adet
			FROM (
			
			SELECT *
			FROM car_sale
			WHERE userid =".$dealerid." 
			) AS a1
			UNION
			SELECT count( * ) AS adet
			FROM (
			
			SELECT *
			FROM bus_sale
			WHERE userid =".$dealerid."
			) AS a2
			UNION
			SELECT count( * ) AS adet
			FROM (
			
			SELECT *
			FROM moto_sale
			WHERE userid =".$dealerid."
			) AS a3
			UNION
			SELECT count( * ) AS adet
			FROM (
			
			SELECT *
			FROM spec_sale
			WHERE userid =".$dealerid."
			) AS a4
			UNION
			SELECT count( * ) AS adet
			FROM (
			
			SELECT *
			FROM truck_sale
			WHERE userid =".$dealerid."
			) AS a5
			UNION
			SELECT count( * ) AS adet
			FROM (
			
			SELECT *
			FROM water_sale
			WHERE userid =".$dealerid."
			) AS a6
			) AS a7";
			
			
			// получаем полную информацию автосалона 
			$q_d="SELECT * FROM users WHERE id=".$dealerid." LIMIT 1";
			$res_d=$DB->query($q_d);
			$row_d=$DB->nextRow($res_d);
			
			if ($row_d['status']<3) {
				$smarty->display('dealers/dealer_error.tpl');
				break;
			}
			
			$q_ven="SELECT rdv.vendorid,vendors.name,vendors.link FROM rel_dealer_vendor AS rdv " .
				   " INNER JOIN vendors ON (vendors.id=rdv.vendorid) " .
				   " WHERE rdv.dealerid=".$dealerid;
			$res_ven=$DB->query($q_ven);
			$mas_dealer_vendors=array();
			while ($row_ven=$DB->nextRow($res_ven)){
				$mas_dealer_vendors[]=$row_ven;
			}
			$row_d['vendors']=$mas_dealer_vendors;

			$smarty->assign('toptitle',$row_d['surname'].' - объявления о продаже автомобилей на '._SHOT_TOP_DESC_);
			$smarty->assign('dealerinfo',$row_d);

			$mas_back_nav=array();
			$mas_back_nav[]=array('name'=>'Дилеры','link'=>'/dealers/');
			$mas_back_nav[]=array('name'=>$mas_city_by_id[$row_d['cityid']],'link'=>'');
			$smarty->assign('mas_back_nav',$mas_back_nav);
	
	
			// устанавливаем параметры сортировки
			if ($sort=='') { $sort='date'; }
			if ($asc==1) { $q_asc=" ASC "; } else { $q_asc=" DESC "; }
			$q_sort='';
			if ($sort=='date') 				{ $q_sort=" ORDER BY 3 ".$q_asc; }
			elseif ($sort=='name') 			{ $q_sort=" ORDER BY 11 ".$q_asc.",12 ".$q_asc; }
			elseif ($sort=='god')			{ $q_sort=" ORDER BY 5 ".$q_asc; }
			elseif ($sort=='probeg')		{ $q_sort=" ORDER BY 7 ".$q_asc; }
			elseif ($sort=='cityid')		{ $q_sort=" ORDER BY 10 ".$q_asc; }
			elseif ($sort=='cost')			{ $q_sort=" ORDER BY 8 ".$q_asc; }
	
			$qr_str_forpage='&sort='.$sort.'&asc='.$asc.'&';
			$maspage=pagebegin($qt,20,$pagenamb,$qr_str_forpage);
			$pagesqllim=$maspage['pagelim'];
			
			$smarty->assign('sort',$sort);
			$smarty->assign('asc',$asc);
			$smarty->assign('total',$maspage["total"]);
		
			//выборка всех объявлений по таблицам ХХХ_sale
			$q="SELECT car_sale.id,car_sale.publ,car_sale.date,car_sale.img,car_sale.god, car_sale.ctview,				
					car_sale.probeg,car_sale.cost,car_sale.color, car_sale.cityid, vendors.name AS vendor, 
					car_model.name AS model, aum.msg, car_sale.export, (@link:='car') AS link FROM car_sale AS car_sale
									INNER JOIN vendors ON (vendors.id=car_sale.vendorid)
									INNER JOIN car_model ON (car_model.id=car_sale.modelid)
									LEFT JOIN admin_user_messages AS aum ON (aum.recid=car_sale.id AND aum.type=1)
									WHERE car_sale.userid=".$dealerid."
					UNION
					SELECT car_sale.id,car_sale.publ,car_sale.date,car_sale.img,car_sale.god, car_sale.ctview,				
					car_sale.probeg,car_sale.cost,car_sale.color, car_sale.cityid, bus_vendors.name AS vendor,
					bus_model.name AS model, aum.msg, car_sale.export, (@link:='bus') AS link FROM bus_sale AS car_sale
									INNER JOIN bus_vendors ON (bus_vendors.id=car_sale.vendorid)
									INNER JOIN bus_model ON (bus_model.id=car_sale.modelid)
									LEFT JOIN admin_user_messages AS aum ON (aum.recid=car_sale.id AND aum.type=5)
									WHERE car_sale.userid=".$dealerid."
					UNION
					SELECT car_sale.id,car_sale.publ,car_sale.date,car_sale.img,car_sale.god, car_sale.ctview,				
					car_sale.probeg,car_sale.cost,car_sale.color, car_sale.cityid, spec_vendors.name AS vendor,
					spec_model.name AS model, aum.msg, car_sale.export, (@link:='spec') AS link FROM spec_sale AS car_sale
									INNER JOIN spec_vendors ON (spec_vendors.id=car_sale.vendorid)
									INNER JOIN spec_model ON (spec_model.id=car_sale.modelid)
									LEFT JOIN admin_user_messages AS aum ON (aum.recid=car_sale.id AND aum.type=7)
									WHERE car_sale.userid=".$dealerid."
					UNION
					SELECT car_sale.id,car_sale.publ,car_sale.date,car_sale.img,car_sale.god, car_sale.ctview,				
					car_sale.probeg,car_sale.cost,car_sale.color, car_sale.cityid, truck_vendors.name AS vendor,
					truck_model.name AS model, aum.msg, car_sale.export, (@link:='truck') AS link FROM truck_sale AS car_sale
									INNER JOIN truck_vendors ON (truck_vendors.id=car_sale.vendorid)
									INNER JOIN truck_model ON (truck_model.id=car_sale.modelid)
									LEFT JOIN admin_user_messages AS aum ON (aum.recid=car_sale.id AND aum.type=4)
									WHERE car_sale.userid=".$dealerid."
					UNION
					SELECT car_sale.id,car_sale.publ,car_sale.date,car_sale.img,car_sale.god, car_sale.ctview,				
					car_sale.probeg,car_sale.cost,car_sale.color, car_sale.cityid, moto_vendors.name AS vendor,
					moto_model.name AS model, aum.msg, car_sale.export, (@link:='moto') AS link FROM moto_sale AS car_sale
									INNER JOIN moto_vendors ON (moto_vendors.id=car_sale.vendorid)
									INNER JOIN moto_model ON (moto_model.id=car_sale.modelid)
									LEFT JOIN admin_user_messages AS aum ON (aum.recid=car_sale.id AND aum.type=6)
									WHERE car_sale.userid=".$dealerid."
					UNION
					SELECT car_sale.id,car_sale.publ,car_sale.date,car_sale.img,car_sale.god, car_sale.ctview,				
					car_sale.probeg,car_sale.cost,car_sale.color, car_sale.cityid, water_vendors.name AS vendor,
					water_model.name AS model, aum.msg, car_sale.export, (@link:='water') AS link FROM water_sale AS car_sale
									INNER JOIN water_vendors ON (water_vendors.id=car_sale.vendorid)
									INNER JOIN water_model ON (water_model.id=car_sale.modelid)
									LEFT JOIN admin_user_messages AS aum ON (aum.recid=car_sale.id AND aum.type=8)
									WHERE car_sale.userid=".$dealerid." ".$q_sort." ".$pagesqllim;

		$res=$DB->query($q);
		
		$mas_cars=array();
		$i=0;

		while ($row=$DB->nextRow($res))
		{
	
			$mas_cars[$i]=$row;
			$mas_cars[$i]['days_left']=intval((60*60*24*61-time()+$row['date'])/(60*60*24));
			$i++;
		}
	
	$smarty->assign('mas_cars',$mas_cars);
	$smarty->assign('pagenav',$maspage["maspage"]);
	$smarty->assign('total',$maspage["total"]);
	$smarty->display('dealers/dealers.tpl');
	
	break;
	
	case 'salon':
	
		// ------- постраничная ------------------ //
		if ($markid==0) $sql_mark='';
			else $sql_mark=" INNER JOIN rel_dealer_vendor AS rel ON (rel.dealerid=usr.id AND rel.vendorid=".$markid.")  ";
		$qt="SELECT COUNT(*) AS total FROM users AS usr ".$sql_mark." WHERE status=4 ".$sql_city." LIMIT 1";
		$maspage=pagebegin($qt,20,$pagenamb,'/dealers/salon/'.$cmurl.'&');
		$pagesqllim=$maspage['pagelim'];
		$smarty->assign('pagenav',$maspage["maspage"]);
		$smarty->assign('total',$maspage["total"]);
		
		$smarty->assign('mas_dealer_vendors',$dealer->vendors());
		$smarty->assign('mas_dealers',$dealer->dealers_lst($pagesqllim,4,$sql_city,$markid));
		$smarty->assign('status',4);
		$smarty->assign('sel_mark',$dealer->get_vendorid_by_name($markid));
		
		$smarty->display('dealers/dealers.tpl');
		
	break;
	
	case 'salon_mark':
		
		// ------- постраничная ------------------ //
		//$qt="SELECT COUNT(*) AS total FROM users WHERE status=4 ".$sql_city." LIMIT 1";
		if ($markid==0) $sql_mark='';
			else $sql_mark=" AND vendors.id=".$markid;
		$qt="SELECT COUNT(usr.id) AS total FROM rel_dealer_vendor AS rel ".
			" INNER JOIN vendors ON (vendors.id=rel.vendorid ".$sql_mark.")" .
			" INNER JOIN users AS usr ON (usr.id=rel.dealerid AND usr.status=4)" .
			" WHERE 1 ".$sql_city." LIMIT 1";
		$maspage=pagebegin($qt,20,$pagenamb,'/dealers/salon_mark/'.$cmurl.'&');
		$pagesqllim=$maspage['pagelim'];
		$smarty->assign('pagenav',$maspage["maspage"]);
		$smarty->assign('total',$maspage["total"]);
		
		$smarty->assign('mas_dealer_vendors',$dealer->vendors());
		$smarty->assign('mas_dealers',$dealer->dealers_lst_by_mark($pagesqllim,4,$sql_city,$markid));
		$smarty->assign('status',4);
		$smarty->assign('sel_mark',$dealer->get_vendorid_by_name($markid));
		
		$smarty->display('dealers/dealers_mark.tpl');
		
	break;
	
	case 'auction':
	
		// ------- постраничная ------------------ //
		if ($markid==0) $sql_mark='';
			else $sql_mark=" INNER JOIN rel_dealer_vendor AS rel ON (rel.dealerid=usr.id AND rel.vendorid=".$markid.")  ";
		$qt="SELECT COUNT(*) AS total FROM users AS usr ".$sql_mark." WHERE status=3 ".$sql_city." LIMIT 1";
		$maspage=pagebegin($qt,20,$pagenamb,'/dealers/auction/'.$cmurl.'&');
		$pagesqllim=$maspage['pagelim'];
		$smarty->assign('pagenav',$maspage["maspage"]);
		$smarty->assign('total',$maspage["total"]);
		
		$smarty->assign('mas_dealers',$dealer->dealers_lst($pagesqllim,3,$sql_city,$markid));
		$smarty->assign('status',3);
		
		$smarty->display('dealers/dealers.tpl');
		
	break;
	
	case 'city':
	
		$cityid=intval($_POST['cityid']);
		//$regionid=intval($_POST['regionid']);
		$qr_str=$_SERVER['HTTP_REFERER'];
		$s=array("/&cityid=[0-9]*/");
		$r=array();
		$qr_str=preg_replace($s,$r,$qr_str);
		header('Location:'.$qr_str.'&cityid='.$cityid);
		exit;
		
	break;
	
	case 'region': //for noscript city selection
	
		if (isset($_SERVER['HTTP_REFERER']) and preg_match("/auto.sibnet.ru\/dealers/", $_SERVER['HTTP_REFERER'])){
			$qr_str=$_SERVER['HTTP_REFERER'];
			$s=array("/&cityid=[0-9]*/");
			$r=array();
			$qr_str=preg_replace($s,$r,$qr_str);
		}
		else $qr_str='/dealers/';
		$smarty->assign('ref',$qr_str);
		$smarty->assign('toptitle','Автосалоны: выберите город');
		$smarty->display('dealers/noscript_city.tpl');
		
	break;
	
	case 'mark':
	
		$markid=intval($_POST['markid']);
		$qr_str=$_SERVER['HTTP_REFERER'];
		$s=array("/&markid=[0-9]*/");
		$r=array();
		$qr_str=preg_replace($s,$r,$qr_str);
		header('Location:'.$qr_str.'&markid='.$markid);
		exit;
		
	break;
	
/*	case 'show':
		
		$dealerid=intval($pst[1]);
		
		$user = new users_class();
		$smarty->assign('bit',$user->load());
		$smarty->assign('mas_user_settings',$user->mas_user_settings);
		
		$q="SELECT vendors.name AS vendor,car_model.name AS model,car.id,car.vendorid,car.modelid,car.date,car.img,car.god,car.engine_volume,car.transmission,car.probeg,car.color,car.cost,car.kuzov,car.cityid,car.power,car.drive_type,car.wheel,car.fuel_type,car.climate,car.userid FROM car_sale AS car 
			INNER JOIN vendors ON (vendors.id=car.vendorid)
			INNER JOIN car_model ON (car_model.id=car.modelid)
			WHERE publ>0 AND userid=".$dealerid." ORDER BY id DESC LIMIT 5";	
		$res=$DB->query($q);
		
		$mas_cars=array();
				
		while ($row=$DB->nextRow($res)){
			$mas_cars[]=$row;
		}
		
		$smarty->assign('mas_cars',$mas_cars);
		
		$mas_dealers=array();
		
		$q="SELECT id,surname,cityid,email,site,address,tel,login,description FROM users WHERE id=".$dealerid." LIMIT 1";
		$res=$DB->query($q);
		$row=$DB->nextRow($res);
		
		$mas_back_nav[]=array('name'=>'Дилеры','link'=>$pageurl);
		$mas_back_nav[]=array('name'=>$row['surname'],'link'=>'');
		$smarty->assign('mas_back_nav',$mas_back_nav);	
			
		//$cityname=$mas_city_by_id[$row['cityid']];
		
		$smarty->assign('dealer',$row);
		
		$smarty->display('dealers/show_dealer.tpl');
		
		
	break;	*/
	
}
	
	require("../inc/bottom.php");
?>