<?php include('../include/meta.php');?>
<?php include('../include/head.php');?>

 <div class="container_2"> 
    <div class="row">
<?php
$g_page = $_GET['p'];
$limit = ($g_page-1)*8;	
	
	
$search = '';
if($_GET['type']=='men'){ $search = 'AND product.type_id = 1';$num_type = 'ผู้ชาย'; }
if($_GET['type']=='female'){  $search = 'AND product.type_id = 2';$num_type = 'ผู้หญิง'; }
if($_GET['type']=='nun'){  $search = 'AND product.type_id = 3';$num_type = 'แม่ชี'; }
if($_GET['type']=='child'){  $search = 'AND product.type_id = 4';$num_type = 'เด็ก'; }
if($_GET['type']=='another'){ $search = 'AND product.type_id = 5';$num_type = 'อื่น'; }	
if($_GET['pro_cat'] <> ''){ $search = $search . ' AND  product.category_id = "'.$_GET['pro_cat'].'"';  $pro_cat = '&pro_cat='.$_GET['pro_cat'];}
if($_GET['pro_tt'] <> ''){ $search = $search . ' AND  product.texture_id = "'.$_GET['pro_tt'].'"';  $pro_tt = '&pro_tt='.$_GET['pro_tt'];}

	
	$sql_pro = array(
	'table'=>'product,category',
	'count'=>'product.id as id , 
	product.name as name, 
	product.code as code , 
	product.image as image ,
	product.texture_id as texture_id,
	product.sort as sort,
	product.text_sale as text_sale,
	product.type_id as type_id,
	product.shows as shows ',
	'where'=>"product.category_id =  category.id AND product.status = '1' ". $search . "  
	order by  product.shows DESC , category.sort ASC , product.sort DESC LIMIT ".$limit.",8");
	
	$view_pro = $view_db->view($sql_pro);
	$result_pro = $view_db->q_re($view_pro);
	$num_rows = mysql_num_rows($result_pro);
	
	$num = 1;
	$num_all = 1;
	$date_today = date('Y-m-d');
	$sql_pmo4 = array('table'=>'promotion','where'=>"type = 4 AND status = '1'  AND ( from_date <= '".$date_today."' AND to_date >=  '".$date_today."'  ) order by id ASC");
	$view_pmo4 = $view_db->view($sql_pmo4);
	$row_pmo4 = $view_db->q($view_pmo4);
	while($row_pro = $view_db->q_ro($result_pro))
	{
		if($num == 1){ ?> <div class="row"> <?php }
		?>
        
        <div class="col-md-3 col-sm-6 col-xs-6 item" style="height:410px;">
        	<div class="col-md-11">
            	<div class="pro_img"><a href="productdetail.php?id=<?php echo $row_pro['id']?>" style="text-decoration:none;color:#FFF;">
                <img src="../redbag/product/<?php echo $row_pro['image']?>" width="207" class="img_res img_nocopy">
                
                <?php
				if($row_pmo4['id_texture'] == $row_pro['texture_id'])
				{
					$arr_type_promp = explode(',',$row_pmo4['id_type']);
					if (in_array($row_pro['type_id'], $arr_type_promp))
					{
						?>
                         <div class="text_sale">
                            <div style="color:#FFF;"><?php echo $row_pmo4['text_sale'];?></div>
                         </div>
                        <?php
					}
				}
				
                else if($row_pro['text_sale']<>'')
				{
					?>
                     <div class="text_sale">
                        <div style="color:#FFF;"><?php echo $row_pro['text_sale'];?></div>
                     </div>
                    <?php
				}
				else if ($row_pro['shows'] == 2 )
				{?> 
                    <div class="text_sale_new">
                    <div style="color:#FFF;">สินค้าใหม่</div>
                    </div>
				<?php }
				else if ($row_pro['shows'] == 3 )
				{?> 
                    <div class="text_sale_good">
                    <div style="color:#FFF;">สินค้าขายดี</div>
                    </div>
				<?php }
				else if ($row_pro['shows'] == 4 )
				{?> 
                    <div class="text_sale_hi">
                    <div style="color:#FFF;">สินค้าแนะนำ</div>
                    </div>
				<?php }
				?>
                
                </a></div>
                <div class="text_name_pro"><?php echo $row_pro['name'];?></div>
                 <div class="text_name_ty_pro" style="color:#5d81c2;"><div> รหัสสินค้า   <?php echo $row_pro['code']?></div></div>
                <?php
                $sql_tt2 = array('table'=>'texture','where'=>"status = '1' AND id = '".$row_pro['texture_id']."' order by id ASC");
				$view_tt2 = $view_db->view($sql_tt2);
				$row_tt2 = $view_db->q($view_tt2);
				?>
                <div class="text_name_ty_pro" ><?php echo $row_tt2['name']?></div>
            </div>
        </div>
        
        
        <?php
	   if($num == 4 || $num_rows == $num_all){ ?> </div> <?php $num = 0; }
	   $num++;	$num_all++;
	}
	
	?>  
    </div>
</div> 

  

  
  
<script src="../include/infiniteajaxscroll/jquery.min.js"></script>
<script type="text/javascript" src="../include/infiniteajaxscroll/jquery-ias.min.js"></script>

<?php
$list = array('table'=>'product,category','count'=>'product.id as id , product.name as name , product.image as image , product.texture_id as texture_id, product.sort as sort ','where'=>"product.category_id =  category.id AND product.status = '1' ". $search . "  order by  category.sort ASC , product.sort DESC ");	   
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$rowcount = mysql_num_rows($result);
$row_page = $rowcount/8;
$row_page = ceil( $row_page);
?><ul id="pagination" style="color:#000;"><?php
for($i=1;$i<=$row_page;$i++)
{
	if($i==1){?><li><a href="../product/product.php">1</a></li><?php }
	else
	{
		?><li  <?php if($i==$_GET['p']+1){ ?>class="next"<?php }?>><a href="../product/product_load.php?p=<?php echo $i; ?>&type=<?php echo $_GET['type'].$pro_cat.$pro_tt;?>">2</a></li><?php
	}	
}
?>
</ul> 

 <script type="text/javascript">
    var ias = $.ias({
      container: ".container_2",
      item: ".item",
      pagination: "#pagination",
      next: ".next a"
    });

    ias.extension(new IASSpinnerExtension());
    ias.extension(new IASTriggerExtension({offset: 5}));
    ias.extension(new IASNoneLeftExtension({text: ''}));
  </script>    
<?php include('../include/footer_js.php');?>