<div id="direct"><a href="index.php">Trang chủ</a> <span>></span> Tất cả sản phẩm</div>

<div id="collection">
	<div id="leftContent">
		<div>DANH MỤC HÀNG HÓA<img align="center" src="lib/icons/menu.png"></div>
		<div>
			<ul id="category">
				<!-- <li class="category"><a>Thương hiệu</a> <span class="arrow"><img src="lib/icons/down.png" align="center"><img src="lib/icons/up.png" align="center" hidden></span>
					<ul class="subCategory1">
						<?php 
							$stmt=$conn->prepare("SELECT id,name FROM trademark");
							$stmt->execute();
							$trademark=$stmt->fetchAll(PDO::FETCH_ASSOC);
							$stt=1;
							foreach ($trademark as $trademark) { ?>
								<li class="category1"><a><?php echo $stt.". ".$trademark['name'];$stt++ ?></a> <span class="arrow"><img src="lib/icons/down.png" align="center"><img src="lib/icons/up.png" align="center" hidden></span>
								<ul class="subCategory2">
									<?php
										$stmt=$conn->prepare("SELECT type.id as id,type.name as type FROM product JOIN type ON product.type=type.id WHERE trademark='".$trademark['id']."' GROUP BY type");
										$stmt->execute();
										$type=$stmt->fetchAll(PDO::FETCH_ASSOC);
										foreach ($type as $type) { ?>
											<li class="category2"><a href="?type=<?php echo $type['id'] ?>&trademark=<?php echo $trademark['id'] ?>&page=1"><?php echo $type['type'] ?></a></li>
										<?php }
									?>
								</ul></li>
							<?php }
						?>
					</ul>
				</li> -->
				<li class="category"><a>Sản phẩm</a> <span class="arrow"><img src="lib/icons/down.png" align="center"><img src="lib/icons/up.png" align="center" hidden></span>
					<ul class="subCategory1">
						<?php 
						$stmt=$conn->prepare("SELECT type.id as id,type.name as type FROM product JOIN type ON product.type=type.id GROUP BY type ASC"); 
						$stmt->execute();
						$type=$stmt->fetchAll(PDO::FETCH_ASSOC);
						foreach ($type as $type) { ?>
							<li class="category2"><a href="?type=<?php echo $type['id'] ?>&page=1"><?php echo $type['type'] ?></a></li>
						<?php } ?>
					</ul>
				</li>
			</ul>
		</div>
	</div>

	<div id="rightContent">
		<div id="slide">
			<?php
			$stmt=$conn->prepare("SELECT * FROM slide WHERE type=1 ORDER BY image DESC");
			$stmt->execute();
			$slide=$stmt->fetchAll(PDO::FETCH_ASSOC);
			$count=count($slide);
			?>
			<input id="slideAmount" type='text' value='<?php echo $count; ?>' hidden>
			<?php
			foreach($slide as $slide){
			?>
			<img id="slide<?php echo $count;$count--; ?>" class="slide" src="<?php echo $slide['image'] ?>" width="100%">
			<?php } ?>
			
			<!-- <div id="prev"><</div>
			<div id="next">></div> -->
		</div>
		<div id="rightTitle"><?php if(isset($_GET['type'])){
		$stmt=$conn->prepare("SELECT id,name FROM type WHERE id='".$_GET['type']."'");
		$stmt->execute();
		$type=$stmt->fetch(PDO::FETCH_ASSOC);
		echo $type['name'];
		}if(isset($_GET['trademark'])){
		$stmt=$conn->prepare("SELECT id,name FROM trademark WHERE id='".$_GET['trademark']."'");
		$stmt->execute();
		$trademark=$stmt->fetch(PDO::FETCH_ASSOC);
		echo " ".$trademark['name'];
		}if(!isset($_GET['type']) && !isset($_GET['trademark'])){
			echo "Tất cả sản phẩm";
		} ?></div>
		<form id="sortForm">
		<div id="sort">Sắp xếp: <select id="selectSort">
			<option>-Vui lòng chon-</option>
			<option value="0">Mặc định</option>
			<option value="1">Giá tăng dần</option>
			<option value="2">Giá giảm dần</option>
			<option value="3">Từ A-Z</option>
			<option value="4">Từ Z-A</option>
			<option value="5">Mới đến cũ</option>
			<option value="6">Cũ đến mới</option>
		</select></div>
		</form>
		<br>
<?php
if(isset($_GET['keyword'])){
	$wherek=" AND del=0 ";
	$where=" WHERE del=0 ";
}if(!isset($_GET['keyword']) || isset($_GET['type'])){
	$wherek=" WHERE del=0";
	$where=" WHERE del=0";
}
if(isset($_GET['trademark'])){
	$wherek.=" AND trademark='".$_GET['trademark']."'";
	$where.=" AND trademark='".$_GET['trademark']."'";
	if(isset($_GET['type'])){
		$wherek.=" AND type='".$_GET['type']."'";
		$where.=" AND type='".$_GET['type']."'";
	}
}
if(!isset($_GET['trademark'])){
	if(isset($_GET['type'])){
		$wherek=" AND type='".$_GET['type']."'";
		$where=" WHERE type='".$_GET['type']."'";
	}
}else{
	
}

// $stmt=$conn->prepare("SELECT COUNT(id) as count FROM product ");
// $stmt->execute();
// $page=$stmt->fetch(PDO::FETCH_ASSOC);
// echo $page['count'];
if(!isset($_GET['sort'])){
	$sort=0;
}else{
	$sort=$_GET['sort'];
}
if($sort==0){
	$orderby="";
}if($sort==1){
	$orderby=" ORDER BY price ASC";
}if($sort==2){
	$orderby=" ORDER BY price DESC";
}if($sort==3){
	$orderby=" ORDER BY name ASC";
}if($sort==4){
	$orderby=" ORDER BY name DESC";
}if($sort==5){
	$orderby=" ORDER BY name ASC";
}if($sort==6){
	$orderby=" ORDER BY name ASC";
}
if(!isset($_GET['page']) || $_GET['page']==1){
	$limit=" LIMIT 0,12";
}else{
	$_GET['page'];
	$end=$_GET['page']*12;
	$start=$end-12;
	$limit=" LIMIT ".$start.",12";
}
if(isset($_GET['keyword'])){
	$page=$conn->prepare("SELECT COUNT(id) AS count FROM product WHERE name LIKE '%".$_GET['keyword']."%'".$wherek);
	$page->execute();
	$pages=$page->fetch(PDO::FETCH_ASSOC);
	$pages['count'];
	$amountPages=$pages['count']/12;
	$amountPages=floor($amountPages);
	if($pages['count']%12 > 0){
		$amountPages++;
	}
	$stmt=$conn->prepare("SELECT * FROM product WHERE name LIKE '%".$_GET['keyword']."%'".$wherek.$orderby.$limit);
}else{
	$page=$conn->prepare("SELECT COUNT(id) AS count FROM product ".$where);
	$page->execute();
	$pages=$page->fetch(PDO::FETCH_ASSOC);
	$pages['count'];
	$amountPages=$pages['count']/12;
	$amountPages=floor($amountPages);
	if($pages['count']%12 > 0){
		$amountPages++;
	}
	$stmt=$conn->prepare("SELECT * FROM product ".$where.$orderby.$limit);
}
$stmt->execute();
$product=$stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($product as $product) {
	if($product['del']==0){
	if(substr_count($product['image'], ".")>1){
		$endDotHot=stripos($product['image'],".")+4;
	}else{
		$endDotHot=stripos($product['image'],".")+5;
	}
	$linkImageHot=substr($product['image'],0,$endDotHot);
?>		
		<a href="product.php?id=<?php echo $product['id']; ?>&direct=<?php echo $product['name']; ?>">
		<div class="product">
			<div class="detailProduct">
				<div class="hinh"><img src="<?php echo $linkImageHot; ?>" height="100%"></div>			
				<div class="info"><?php if(strlen($product['name'])<60){ echo $product['name']; }else{ echo mb_substr($product['name'],0,50)."...";} ?></div>
				<div class="price">
					<?php if($product['discount']>0){?>
					<span class="discount"><?php } ?>
						<?php if(is_numeric($product['price'])){ echo number_format($product['price'])." đ";} 
							if($product['discount']>0){ echo "
					</span>";$product['price']-=$product['discount'];echo number_format($product['price'])." đ"; 
							}if(!is_numeric($product['price'])){ echo "Liên Hệ"; } ?></div>
			</div>
		</div>
		</a>
<?php }}?>
		<div id="page">
			<?php if(isset($_GET['page'])){
			$startUrl=strrpos($_SERVER['REQUEST_URI'], "/")+1;
			$endUrl=(strrpos($_SERVER['REQUEST_URI'], "=")+1)-$startUrl;
			$url=substr($_SERVER['REQUEST_URI'],$startUrl,$endUrl);
			if($_GET['page']>1){ ?>
			<a href="<?php echo $url.($_GET['page']-1); ?>"><img src="lib/icons/prev.png" align="center"></a>
			<?php } for ($i=$_GET['page']-1; $i <= $_GET['page']+4; $i++) {if($i>0 && $i<=$amountPages){ ?>
					<a class='page' id="p<?php echo $i; ?>" href="<?php echo $url ?><?php echo $i; ?>"><?php echo $i; ?></a>	
			<?php }}if(($i-1)<$amountPages){ ?><a>...</a><?php }if($_GET['page']<$amountPages){ ?>
			<a href="<?php echo $url.($_GET['page']+1); ?>"><img src="lib/icons/next.png" align="center"></a>
			<?php }} ?>
		</div>
	</div>
</div>