<?php
if($_SESSION["simDed_type"] == 'member')
{
	$sql_s = 'mem_id = "'.$_SESSION["simDed_id"].'"';
}
if($_SESSION["simDed_type"] == 'shop')
{
	$sql_s = 'shop_id = "'.$_SESSION["simDed_id"].'"';
}
if($_SESSION["simDed_type"] == 'professor')
{
	$sql_s = 'pro_id = "'.$_SESSION["simDed_id"].'"';
}


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

$all_array =  array('table'=>'favorites','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 = mysqli_num_rows($all_result);
$total_pages = ceil($total_rows/$max_rows)-1;
////////////////////////////////////////
$list = array('table'=>'favorites','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-12 text-center">
			<p class="HeadTextXL text-light">เบอร์โปรด</p>
		</div>
	</div>
</div>
<div class="container mb-5">
	<div class="row p-2 border-color-sim rounded-pill-end rounded-pill-start text-light text-center">
		<div class="col-1 bg-color-sim border-color-sim rounded-pill-start2 text-center">
			<div class="my-4">
				<input type="checkbox" name="" value="" id="checkAll" class="form-check-input pt-2 checkall">

			</div>
		</div>
		<div class="col-3 bg-color-sim border-color-sim">
			<p class="my-4">เบอร์ / ราคา / ผลรวม </p>
		</div>
		<div class="col-2 bg-color-sim border-color-sim">
			<p class="my-4">ผู้ขาย</p>
		</div>
		<div class="col-2 bg-color-sim border-color-sim">
			<p class="my-4">คำอธิบาย</p>
		</div>
		<div class="col-2 bg-color-sim border-color-sim">
			<p class="my-4">ส่วนลด</p>
		</div>
		<div class="col-2 bg-color-sim border-color-sim rounded-pill-end2">
			<p class="my-4">เครือข่าย</p>
		</div>
	</div>
	<?php if($total_rows_num == 0){ ?>
		<div class="row px-2 pt-2 pb-0 border-color-sim border-top-0 rounded-bottom-sim" style="margin-top: -20px;">
			<div class="col-12 mt-2-box">
				<div class="my-4 text-center">
					<p>ไม่พบข้อมูล</p>
				</div>
			</div>
		</div>
	<?php } ?>

    <form id="fmfavorite" name="fmfavorite" method="post" action="ajax_cart_favorite.php">
        <?php
        $i = 0;
        while($row = $view_db->q_ro($result)){
            $list_p = array('table'=>'phonenumber','where'=>'id = "'.$row['phonenumber_id'].'"');
            $view_p = $view_db->view($list_p);
            $row_p = $view_db->q($view_p);
            
            $list_s = array('table'=>'shop','where'=>'id = "'.$row_p['id_shop'].'"');
            $view_s = $view_db->view($list_s);
            $row_s = $view_db->q($view_s);

            $phonenumber = $Phone_class->format_phonenumber($row_p['phonenumber'],$row_p['format']);
            $txt_phonenumber =  $Phone_class->phonecomma($row_p['phonenumber']);
            $count_n=$total_rows_num-1;

            $row_totalnumber = $actiondata_db->q_one('totalnumber','number = "'.$row_p['total'].'"','title');

        ?>
        <div class="row px-2 <?php echo ($i==0)?'pt-2':''; ?> pb-0 border-color-sim border-top-0 <?php echo ($i==$count_n)?'rounded-bottom-sim':''; ?> text-center text-light" style="<?php echo ($i==0)?'margin-top: -20px;':''; ?>">
            <div class="col-1 <?php echo ($i==0)?'mt-2-box':''; ?> border-end-sim-box text-center">
                <div class="my-4">
                    <input type="checkbox" name="chk[]" id="chk"  class="child" value="<?php echo $row['id'];?>" >
                </div>
            </div>
            <div class="col-3 <?php echo ($i==0)?'mt-2-box':''; ?> border-end-sim-box align-items-center d-flex justify-content-center">
                <span class="pe-2"><?php echo $phonenumber; ?></span>
                <span class="pe-2">[<?php echo number_format($row_p['price'])?>]</span>
                <span class="pe-2">[<?php echo $row_p['total']?>]</span>
            </div>
            <div class="col-2 <?php echo ($i==0)?'mt-2-box':''; ?> border-end-sim-box align-items-center d-flex justify-content-center">
                <?php echo imgprofile_shop($image_profile,'34'); ?>
                <a href="<?php echo $Url_shop.$row_s['codeshop']?>" class="text-decoration-none ps-2 text-light">
                    <?php echo $row_s['nameShop'];?>
                </a>
            </div>
            <div class="col-2 <?php echo ($i==0)?'mt-2-box':''; ?> border-end-sim-box">
                <p class="my-4"><?php echo ($row_totalnumber==2)?'':$row_totalnumber; ?></p>
                <?php echo $util_class->sub_str($row_p['detail'],'90');?>
            </div>
            <div class="col-2 <?php echo ($i==0)?'mt-2-box':''; ?> border-end-sim-box d-flex align-items-center">
                
            </div>
            <div class="col-2 <?php echo ($i==0)?'mt-2-box':''; ?> d-grid align-items-center justify-content-center">
                <?php
                $sql_nw = array('table'=>'mobilenetwork','where'=>"id = '".$row_p['mobilenetwork']."'");
                $view_nw = $view_db->view($sql_nw);
                $row_nw = $view_db->q($view_nw);
                ?>
                <img src="<?php echo $upload ?>mobilenetwork/<?php echo $row_nw['image']; ?>" class="img-fluid" width="50">
            </div>
        </div>
        <?php $i++; } ?>

		<!--
		<div class="row">
				<div class="col-md-12 BerDedToday-page">
						 <?php
						if($total_rows_num > 0)
						{
								page_news($page_number,$total_pages,'index.php','');
						}
						?>
				</div>
		</div>

		--->

		<div class="row mt-3">
			<div class="col-6">
				<button type="button" onclick="favoriteDelete()" class="btn btn-danger-sim px-4">ลบ</button>
			</div>
			<div class="col-6 text-end">
				<button type="submit" class="btn btn-primary-sim px-4">เพิ่มไปยังตะกร้า</button>

			</div>
		</div>
	</form>
</div>