<?php
include('../include72/class.php');
?>
<?php
//$sql_s = 'status = "1"';

$sql_s = 'shop.id = phonenumber.id_shop AND shop.status = 1 AND shop.status_op = 1 AND shop.activate = 1 AND phonenumber.status = "1" ';

$max_rows = 18; // แสดงจำนวนแถวต่อหน้า
$page_number = $_GET['page_number'];

$all_array =  array('table'=>'phonenumber,shop','where'=>$sql_s);
//$all_array =  array('table'=>'phonenumber','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'=>'phonenumber','where'=>$sql_s, 'limit'=> "$start_row,$max_rows",'order'=> "ORDER BY id DESC");
$list = array('table'=>'phonenumber,shop','where'=>$sql_s, 'limit'=> "$start_row,$max_rows",'order'=> "ORDER BY phonenumber.id DESC");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$num_tr = 1;
$num = 1+($page_number*$max_rows);

?>

<?php
while($row = $view_db->q_ro($result))
{
   $phonenumber = $Phone_class->format_phonenumber($row['phonenumber'],$row['format']);
   $row_mobilenetwork = $actiondata_db->q_one('mobilenetwork','id = "'.$row['mobilenetwork'].'"','image');

   $row_totalnumber = $actiondata_db->q_one('totalnumber','number = "'.$row['total'].'"','title');
	if($row_totalnumber==2){$row_totalnumber = '';}


	$list_shr = array('table'=>'shop','where'=>'id = "'.$row['id_shop'].'" ');
	$view_shr = $view_db->view($list_shr);
	$row_shr = $view_db->q($view_shr);

	$countber =  $util_class->countber($row_shr['id']);
	$txt_phonenumber =  $Phone_class->phonecomma($row_shr['phone']);

    if($row_shr['image_profile']){ $image_profile = $row_shr['image_profile']; }
    else { $image_profile = '';  }

    $phonenumber = $Phone_class->format_phonenumber($row['phonenumber'],$row['format']);
	$price = $row['price']-1;
	?>
  <div class="col-12 col-md-4">
    <div class="BoxRecom rounded-sim2 box-s">
      <div class="pt-3 d-flex justify-content-center" align="center" style="cursor:pointer"
      onclick="like(<?php echo $_SESSION["simDed_login"];?>,<?php echo $row['id'] ;?>)">
      <span id="hidefavorite"></span>
      <i class="fa fa-heart" style="font-size:24px;color:gray; "></i>
      <span class="text-danger-sim ps-2">เบอร์โปรด</span>
    </div>
    <div class="" align="center">
      <a href="../cart/?p=<?php echo $row['phonenumber'];?>" class="text-decoration-none">
        <span class="BerDedToday-ber fs-2"><?php echo $phonenumber; ?></span></a>
      </div>
      <div class="px-0"><div class="borber-bottom-sim "></div></div>
      <div class="row align-items-center">
        <?php $css_size=''; if(strlen($row_totalnumber)>= 60){$css_size = 'font-size: 13px;';} ?>
          <div class="col-8 ps-4 text-start">
            <div class="col-xs-12 BerDedToday-sum fw-bold text-success-sim"> ผลรวม <?php echo $row['total']?> </div>
            <div class="col-xs-12 BerDedToday-price fw-bold text-primary-sim" style="<?php echo $css_size; ?>">  <?php echo $row_totalnumber;?> </div>

          </div>
          <div class="col-4">
            <img src="<?php echo $upload ?>mobilenetwork/<?php echo $row_mobilenetwork ?>" width="auto" class="img-fluid">
          </div>
        </div>
        <div class="px-0"><div class="borber-bottom-sim "></div></div>
        <div class="" align="center">
          <div class="col-12 fw-bold fs-3 "> ราคา <?php echo number_format($row['price'])?> บาท </div>
        </div>
        <div class="row justify-content-center">
          <div class="col-12 col-md-6 mb-3">
            <a href="../cart/index.php?p=<?php echo $row['phonenumber'] ;?>"
              class="btn btn-danger-sim fs-5 fw-bold rounded-sim w-100 box-sim1 lh-sim">สั่งซื้อเบอร์</a>
            </div>

          </div>

        </div>

  </div>
	<?php
}
?>
<div class="row" align="center" style="margin-top:5px;">
    <div class="col-md-12 BerDedToday-page">
	<?php
    if($total_rows_num > 0)
    {
        page_ajax2($page_number,$total_pages,'ajax_berrecom.php','berdedrecom');
    }
    ?>
  </div>
</div>