<?php $id = mysqli_real_escape_string($obj_con,$_GET['id']); ?>

<div class="col-md-8" id="box_r">
  <ol class="breadcrumb">
    <li><a href="#"><i class="fas fa-home"></i> หน้าหลัก</a></li>
    <li class="active"><?php echo groups_file($id);?></li>
  </ol>
  <h3 class="title-box-2">ดาวน์โหลด : <?php echo groups_file($id);?></h3>
  <table class="table table-bordered">
  <thead style="background: #ddd;">
    <tr>
      <th class="div-th-title-d"><i class="fas fa-align-right"></i> <?php echo groups_file($id);?></th>
      <th class="div-th-date"><i class="fas fa-calendar-alt"></i> วันที่</th>
      <th class="div-th-download"><i class="fas fa-cloud-download-alt"></i> ดาวน์โหลด</th>
    </tr>
  </thead>
  <tbody>
    <?php
          if(!empty($id)){
            $sql_all_for = "SELECT * FROM tb_text_file WHERE tf_groups = $id";
          }else{
            $sql_all_for = "SELECT * FROM tb_text_file";
          }
          $query_all_for = $obj_con->query($sql_all_for);
          $num_all_for = mysqli_num_rows($query_all_for);

          $Per_Page = 30;   // Per Page

          $Page = $_GET["Page"];
          if(!$_GET["Page"])
          {
            $Page=1;
          }

          $Prev_Page = $Page-1;
          $Next_Page = $Page+1;

          $Page_Start = (($Per_Page*$Page)-$Per_Page);
          if($num_all_for<=$Per_Page)
          {
            $Num_Pages =1;
          }
          else if(($num_all_for % $Per_Page)==0)
          {
            $Num_Pages =($num_all_for/$Per_Page) ;
          }
          else
          {
            $Num_Pages =($num_all_for/$Per_Page)+1;
            $Num_Pages = (int)$Num_Pages;
          }

          $sql_all_for .=" ORDER BY tf_id DESC LIMIT $Page_Start , $Per_Page";
          $query_all_for = $obj_con->query($sql_all_for);

          $intRows = 0;

          if($num_all_for != 0){

          while($row_file_bg = $query_all_for->fetch_assoc()){
            $intRows++;
      ?>
    <tr>
      <td class="a-link-news">
        <i class="fas fa-angle-double-right"></i> <?php echo $row_file_bg['tf_name'];?> (<?php echo number_format($row_file_bg['tf_view']);?>)
        <div class="cat_all">- <?php echo groups_file($row_file_bg['tf_groups']);?></div>
      </td>
      <td class="div-text-v"><?php echo thai_date_short(strtotime($row_file_bg['tf_date']));?></td>
      <td class="div-text-v"><a href="num_file.php?id=<?php echo $row_file_bg['tf_id'];?>" target="_blank"><i class="fas fa-download"></i> download</a></td>
    </tr>
    <?php } }else{ ?>
      <tr>
        <td colspan="4">
          <div class="not_date"><i class="fas fa-exclamation-triangle"></i> ไม่พบข้อมูล!</div>
        </td>
      </tr>
    <?php } ?>
  </tbody>
</table>

<div style="text-align: right;">
  <nav class="bt_center">
    <ul class="pagination">
      <?php if($Prev_Page)
        {
            echo "<li><a href='index.php?home=file&id=$id&Page=$Prev_Page' aria-label='Previous'><span aria-hidden='true'>«</span></a></li>  ";
        }
        for($i=1; $i<=$Num_Pages; $i++){
          if($i != $Page)
          {
              echo "<li><a href='index.php?home=file&id=$id&Page=$i'>$i</a></li>";
          }else{
              echo "<li class='active'><a href='index.php?home=file&id=$id&Page=$i'>$i <span class='sr-only'>(current)</span></a></li>";
          }
        }if($Page!=$Num_Pages){
              echo "<li><a href='index.php?home=file&id=$id&Page=$Next_Page' aria-label='Next'><span aria-hidden='true'>»</span></a></li>";
        }
    ?>
    </ul>
  </nav>
</div>
</div>