<?php
include('../include/header.php');
include('../themes/menu.php');

$sql_s = 'status = "1" AND status_op = "1" AND activate = "1"';

$max_rows = 10; // แสดงจำนวนแถวต่อหน้า
$page_number = 0;
if(isset($_GET['page_number']))
{
	 $page_number = $_GET['page_number'];
}

$all_array =  array('table'=>'shop','where'=>$sql_s);
$start_row = $page_number * $max_rows;
$all_sql = $view_db->view($all_array);
$all_result = $view_db->q_re($all_sql);
$total_rows = $view_db->q_nr($all_result);
$total_rows_num = mysql_num_rows($all_result);
$total_pages = ceil($total_rows/$max_rows)-1;
////////////////////////////////////////
$list = array('table'=>'shop','where'=>$sql_s, 'limit'=> "$start_row,$max_rows",'order'=> "ORDER BY id DESC");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$num_tr = 1;
$num = 1+($page_number*$max_rows);
?>
<div class="container mt-3">
	<div class="row">
	  <div class="col-md-12  justify-content-between d-flex align-items-baseline" style="margin-bottom:5px;">
	    <p class="HeadTextL  text-spacing-md fw-bold"> ร้านค้าแนะนำ </p>
	  </div>
	</div>
</div>
<div class="container ">
	<div class="row">
		<?php
		while($row_shi = $view_db->q_ro($result))
		{
			?>
			<?php	$urlshop =  $util_class->ck_expired_shop($row_shi['id']);	?>
			<?php
			if($row_shi['image_profile']){ $url_imgpro =  $row_shi['image_profile']; }else{ $url_imgpro = '';}
			if($row_shi['image_cover']){ $url_imgcover =  '../redbag/file_manage/'.$row_shi['image_cover']; }else{ $url_imgcover = '../images/bannertop.jpg';}
			?>
			<div class="col-md-6 ">
			<div class="BoxRecom rounded-sim border-danger-sim"	style="border-width:2px;">
				<div class="row" style="min-height: 260px;">
					<div class="col-12">
						<div class="position-relative  text-spacing-md fw-bold">
							<a href="<?php echo $urlshop; ?>" style="color:#F60;">
								<img src="<?php echo $url_imgcover; ?>" alt="" class="img-fluid position-absolute" height="200">
								<?php echo imgprofile_square($url_imgpro,'100','profile_square'); ?>

							</a>

						</div>
					</div>

				</div>
				<div class="row ps-3">
					<div class="col-12 position-relative  text-spacing-md fw-bold">
						<div class="col-xs-12 BerDedToday-price">
							<a href="<?php echo $urlshop; ?>" class="text-danger-sim fs-5 fw-bold text-decoration-none">
								<?php echo $row_shi['nameShop']?>
							</a>
						</div>
						<div class="col-xs-12" style="color:#000;font-size:16px;height:44px;"> <?php echo $util_class->sub_str($row_shi['detail'],100)?></div>

					</div>
				</div>

			</div>
			</div>
			<?php
		}
		?>


	</div>
	<div class="row mb-3" align="center" style="margin-top:5px;">
    <div class="col-md-12 d-flex justify-content-center text-spacing-md fw-bold">
  	  <?php
      if($total_rows_num > 0)
      {
  		 page_ajax2($page_number,$total_pages);
      }
      ?>
    </div>
  </div>
</div>
<!--/.container-->


<?php
include('../themes/footer.php');
include('../include/footer_js.php');
?>