<?php   
include_once("classes/Crud.php");
$crud = new Crud();
$studentYear=$_GET['studentYear'];
$curName=$_GET['curName'];
$curId=$_GET['curId'];
?>
<!DOCTYPE HTML>
<html>
<head>  
<meta charset="UTF-8">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<link rel="stylesheet"
          href="https://fonts.googleapis.com/css?family=Tangerine">
    <style>
      body {
        font-family: 'Kanit', sans-serif;
        font-size: 8 px;
      }
    </style>
<link rel="stylesheet" type="text/css" href="app-assets/vendors/css/tables/datatable/datatables.min.css">
</head>
<body>
<?php
include("header.php");
?>
<br>
<center>นักศึกษาใหม่ จำแนกตามปีการศึกษาของแต่ละหลักสูตรที่เปิดสอน ปีการศึกษา <?=$studentYear?> <?=$curName?></center>


<div class="row">
  <div class="col-sm-12 text-center">
    <div class="card">
      <div class="card-body">
<table class="table table-bordered">
  <thead>
    <tr>
    <th>ลำดับที่</th>
      <th class="text-left">ชื่อ</th>
    <th class="text-left">นามสกุล</th>
    <th class="text-left">ระบบการรับสมัคร</th>
      <th class="text-left">โควต้า</th>
    <th class="text-left">จังหวัด</th>
    </tr>
  </thead>
  <tbody>
      <?php
      $no=1;
      $student= "SELECT * FROM rg_RealStudentAd WHERE app_year='$studentYear' AND curId='$curId' ";
      $result = $crud->getData($student);
      foreach($result as $key => $data){
      ?>
    <tr>
      <td><?=$no?></td>
      <td class="text-left"><?=$data['pf_name']?><?=$data['app_name']?></td>
      <td class="text-left"><?=$data['app_lname']?></td>
        <td class="text-left"><?=$data['at_name']?></td>
        <td class="text-left"><?=$data['qt_name']?></td>
      <td class="text-left"><?=$data['itv_prv_name']?></td>
    </tr>
    <?php
    $no++;
    }
    ?>
  </tbody>
</table>
</div>
    </div>
  </div>
  
</div>
    <script src="app-assets/vendors/js/tables/datatable/datatables.min.js"></script>
    <script src="app-assets/vendors/js/tables/datatable/datatables.buttons.min.js"></script>
    <script src="app-assets/vendors/js/tables/datatable/datatables.bootstrap4.min.js"></script>
    <script src="app-assets/js/scripts/datatables/datatable.js"></script>
    <script src="canvasjs.min.js"></script>
</body>
</html>
<?php
function DateThai($strDate)
{
    $strYear = date("Y",strtotime($strDate))+543;
    $strMonth= date("n",strtotime($strDate));
    $strDay= date("j",strtotime($strDate));
    $strHour= date("H",strtotime($strDate));
    $strMinute= date("i",strtotime($strDate));
    $strSeconds= date("s",strtotime($strDate));
    $strMonthCut = Array("","ม.ค.","ก.พ.","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
    $strMonthThai=$strMonthCut[$strMonth];
    return "$strDay $strMonthThai $strYear";
}
?>