<?

include(dirname(__FILE__). '/../../config/config.inc.php');
include(dirname(__FILE__). '/../../init.php');

$productCode = isset($_GET['productCode']) ? $_GET['productCode'] : '';
$category = isset($_GET['Cat']) ? $_GET['Cat'] : '';

if(!strlen($productCode))
	$productCode = $_GET['ProductCode'];
if(!strlen($productCode))
	$productCode = $_GET['productcode'];

$productCode = trim($productCode);
$productCode = str_replace('%20','',$productCode);

if($productCode)
	redirectProductCode($productCode);
else if($category)
	redirectCat($category);
else
	header( 'Location: /' ) ;


function redirectProductCode($productCode){

	$db = Db::getInstance();
	$sql = "Select id_product from ps_product where reference = '".$productCode."'";
	
	$product = $db->getRow($sql);
	$id = $product['id_product'];
	
	if($id){
		$sql = "Select link_rewrite from ps_product_lang where id_product = " . $id;
		$productlang = $db->getRow($sql);
		$link = $productlang['link_rewrite'];
		$redirect = '/products/' . $id . '-' . strtolower($productCode) . '-' . $link . '.html';
		
		header( 'Location: ' . $redirect);
	}
	else{
		header( 'Location: /' ) ;
	}
}

function redirectCat($category){
	if(!is_int($category))
		header( 'Location: /' ) ;
	
	$db = Db::getInstance();
	$sql = "Select * from ps_category_lang where id_category = " . $category;
	
	$cat = $db->getRow($sql);
	$id = $cat['id_category'];
	$link =  $cat['link_rewrite'];
	
	if($id){
		$redirect = '/' . $id . '-' . $link;
		
		header( 'Location: ' . $redirect);
	}
	else{
		header( 'Location: /' ) ;
	}
}


?>