<div class="container">
    <div class="row">
        <div class="col-md-12"> <?php include('../../../control/backend/themes/nav.php');?></div>
    </div>
</div>

<?php include('../../../control/backend/themes/alert.php');?>
<?php
$sql_s = 'id_shop = "'.$id_shop.'"' . $sql_d . $sql_tr .$sql_ph; 

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

$all_array =  array('table'=>'email','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'=>'email','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="DivBody">
   <div class="container">
   <div class="row">
          <div class="col-md-12" style="margin-top:15px;">
                <div class="row">
                <div class="col-md-12">
                    <div class="DivBgSub">
                    <span id="txtHint1"></span>
                        <p>ทั้งหมด :  <?php echo number_format($total_rows_num)?> ฉบับ</p>
                        <table width="100%" border="1" class="table TbBar" >
                          <thead> 
                              <tr>
                                <th>หัวข้อ</th>
                                <th width="15%">วันที่ส่ง</th>
                                <th width="7%">เครื่องมือ</th>
                              </tr>
                           </thead>
                           <tbody>
                           <?php
						   if($total_rows_num == 0)
						   {
								 ?>
								   <tr>
									<td colspan="3" class="DataNot" align="center">ไม่พบข้อมูล</td>
								  </tr>
								 <?php
						  }
                           while($row = $view_db->q_ro($result))
                           {
                            ?>
                                <tr>
                                    <td><a href="view.php?id=<?php echo $row['id'];?>" style="color:#333;"><?php echo $row['title']?></a></td>
                                    <td><?php echo $util_class->day_dmy_ti($row['createdate']); ?></td>
                                    <td><button type="button"class="btn btn-danger btn-delete"  onclick="delete_email(<?php echo $row['id'];?>)">ลบ</button></td>
                                </tr>
                            <?php
                           }
                           ?> 
                          </tbody>
                        </table>
                            <div class="BerDedToday-page">
                                <?php
                                if($total_rows_num > 0)
                                {
                                    ?>
                                    <nav aria-label="Page navigation">
                                  <ul class="pagination">
                                    <li <?php  if($page_number == 0){?>class="active"<?php }?>><a href="index.php?page_number=0">1</a></li><?php
                                    if($total_pages >= 7)
                                    {
                                        $n = $page_number-1;
                                        if($n < 0){$n = 0;}
                                        ?><li><a href="index.php?page_number=<?php echo $n ?>"> << </a></li><?php	
                                    }
                                    if($total_pages >= 7)
                                    {
                                        $p_end = $total_pages - 3;
                                        if($page_number > 3 && $page_number >=  $p_end)
                                        { 
                                            $lop_p = $total_pages-1;
                                            $start_p = $p_end-1; 
                                        }else{
                                            if($page_number == 0){
                                                $start_p = 1; 
                                                $lop_p = 4;
                                            }
                                            else{
                                                $start_p = $page_number; 
                                                $lop_p = $page_number+3;
                                            }
                                        }
                                    }else{ $lop_p = $total_pages - 1; $start_p = 1;}
                                    for($a=$start_p;$a<=$lop_p;++$a)
                                    {
                                        $b = $a + 1 ;
                                        if($a==$page_number)
                                        {
                                            ?><li class="active"><a href="index.php?page_number=<?php echo $a?>" ><?php echo $b; ?></a></li><?php
                                        }
                                        else
                                        {
                                            ?><li><a href="index.php?page_number=<?php echo $a?>" ><?php echo $b; ?></a></li><?php	
                                        }
                                    }
                                    if($total_pages >= 7)
                                    {
                                        $p = $page_number+1;
                                        if($p >= $total_pages){$p = $total_pages;}
                                        ?><li><a href="index.php?page_number=<?php echo $p ?>"> >> </a></li><?php	
                                    }
                                    if($total_pages > 0)
                                    {
                                        ?><li <?php  if($page_number == $total_pages){?>class="active"<?php }?>><a href="index.php?page_number=<?php echo $total_pages ?>"><?php echo  $total_pages+1 ?></a></li><?php
                                    }
                                    ?>
                                    </ul>
                                  
                                </nav>
                                    <?php	
                                }
                                ?>
                            </div>
                    </div>
                </div>
              </div>
          </div>
       </div>   
   </div>
</div>