Admin Control Panel v2.0

✎ Editing: products.php ← Back

<?php
ob_start();
include('includes/inc.config.php');

$limit = $data->settings('records');
        $page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
        $startpoint = ($page * $limit) - $limit;

$products_results = array();

if(isset($_GET['sku']) && $_GET['sku'] == 'disponible'){
	$stock_filter = 'and sku > 0 ';
}else if(isset($_GET['sku']) && $_GET['sku'] == 'all'){
	$stock_filter = '';
}else{
	$stock_filter = '';
}
if(isset($_GET['c']) && $_GET['c'] != ''){
	if($page){
$products = $database->execute("
SELECT * FROM `products` WHERE cat_id = '".$database->sanitize($_GET['c'])."' and `status` = '1' $stock_filter ORDER BY id ASC LIMIT {$startpoint} , {$limit}
");
	}else{
$products = $database->execute("
SELECT * FROM `products` WHERE cat_id = '".$database->sanitize($_GET['c'])."' and `status` = '1' $stock_filter ORDER BY id ASC limit $limit
");		
	}
$statement = "`products` WHERE cat_id = '".$database->sanitize($_GET['c'])."' and `status` = '1' $stock_filter ";
$url = '?'.($_GET['sku'] ? 'sku='.$_GET['sku'].'&' : '').'page=';
}else if(isset($_POST['search']) && $_POST['search'] != '' || isset($_GET['search']) && $_GET['search'] != ''){
	if($page){
$products = $database->execute("
SELECT * FROM `products` WHERE name LIKE '%".$database->sanitize(($_POST['search'] ? $_POST['search'] : $_GET['search']))."%' and `status` = '1' $stock_filter ORDER BY id ASC LIMIT {$startpoint} , {$limit}
");
	}else{
$products = $database->execute("
SELECT * FROM `products` WHERE name LIKE '%".$database->sanitize(($_POST['search'] ? $_POST['search'] : $_GET['search']))."%' and `status` = '1' $stock_filter ORDER BY id ASC
");		
	}
$statement = "`products` WHERE name LIKE '%".$database->sanitize(($_POST['search'] ? $_POST['search'] : $_GET['search']))."%' and `status` = '1' $stock_filter ";
$url = '?search='.($_POST['search'] ? $_POST['search'] : $_GET['search']).'&'.($_GET['sku'] ? 'sku='.$_GET['sku'].'&' : '').'page=';	
}else{
$products = $database->execute("
SELECT * FROM `products` WHERE `status` = '1' $stock_filter ORDER BY id ASC LIMIT {$startpoint} , {$limit}
");	
$statement = "`products` WHERE `status` = '1' $stock_filter ";
$url = '?'.($_GET['sku'] ? 'sku='.$_GET['sku'].'&' : '').'page=';
}
while($row = $database->fetch($products)){
	 $query = $database->execute("SELECT sum(rating_count) as total_count, sum(rating_points) as total_points FROM prod_rating WHERE prod_id = '".$row['id']."'");
    $ratingRow = $database->assoc($query);
    $row['avg'] = ($ratingRow['total_count'] != 0 ? round($ratingRow['total_points'] / $ratingRow['total_count']) : 0);
    $row['count'] = $ratingRow['total_count'];
    $row['price_eu'] = number_format($row['price'],2);
      $products_results[] = $row;
}

$categories_results = array();
$categories = $database->execute("
SELECT * FROM `categories`
");
while($row = $database->fetch($categories)){
      $categories_results[] = $row;
}
$getBigPrice = $database->execute("SELECT * FROM `products` WHERE `status` = '1' order by price desc limit 1");
while($row = $database->fetch($getBigPrice)){
      $BigPrice = $row['price'];
}
include('header.php');

$pageURL = (@$_SERVER["HTTPS"] == "on" ? "https://" : "http://");
if ($_SERVER["SERVER_PORT"] != "80")
{
    $pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
} 
else 
{
    $pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
}

$smarty->assign("comm_url", $pageURL);
$smarty->assign("BigPrice", $BigPrice);
$smarty->assign("categories", $categories_results);
$smarty->assign("products", $products_results);
$smarty->assign("pagination", $data->pagination($statement,$limit,$page,$url));
$smarty->display('products.tpl');
?>

Cancel