<?php
if(isset($ugroup)){
	
?>
	<div class="row">
		<div class="col-xl-12">
			<div class="breadcrumb-holder">
				<h1 class="main-title float-left"><i class="fa fa-university"></i> โรงเรียน<?=$fullname;?></h1>
					<ol class="breadcrumb float-right">
					<li class="breadcrumb-item">Home</li>
					<li class="breadcrumb-item active"><?=$ugroup;?></li>
                    </ol>
                    <div class="clearfix"></div>
            </div>
		</div>
	</div>
	<?php		
		if ($msg =='error_name')
				echo '<div class="alert alert-danger" role="alert">Error! พบข้อมูลซ้ำในระบบ ไม่สามารถเพิ่มข้อมูลได้</div>';	
		if ($msg =='error_username')
				echo '<div class="alert alert-danger" role="alert">Error! Input valid username</div>';	
		if ($msg =='error_duplicate_username')
				echo '<div class="alert alert-danger" role="alert">Error! There is another user with this username address</div>';	
		if ($msg =='edit_ok')
				echo '<div class="alert alert-success" role="alert">User updated</div>';	
		if ($msg =='add_ok')
				echo '<div class="alert alert-success" role="alert">เพิ่มข้อมูลเรียบร้อย</div>';	
		if ($msg =='delete_ok')
				echo '<div class="alert alert-success" role="alert">User deleted</div>';	
		if ($msg =='error_delete_protected')
				echo '<div class="alert alert-danger" role="alert">Error! This user can not be deleted</div>';	
	?>	
    <!-- end row -->
	<link rel="stylesheet" type="text/css" href="<?php echo ADMIN_URL;?>/assets/plugins/datatables/dataTables.bootstrap4.min.css"/>
	<script type="text/javascript" src="<?php echo ADMIN_URL;?>/assets/plugins/datatables/jquery.dataTables.min.js"></script>
	<script type="text/javascript" src="<?php echo ADMIN_URL;?>/assets/plugins/datatables/dataTables.bootstrap4.min.js"></script>
	<link rel="stylesheet" href="<?php echo ADMIN_URL;?>/assets/css/bootstrap-select.css">
	<script src="<?php echo ADMIN_URL;?>/assets/js/bootstrap-select.js"></script>
	<script>
	// START CODE FOR BASIC DATA TABLE 
	$(document).ready(function() {
		$('#example1').DataTable();
	} );
	$(document).ready(function() {
		$('#table1').DataTable();
	} );	
	// END CODE FOR BASIC DATA TABLE 	
	 	
	</script>
<style type="text/css">
table.dataTable tbody th, table.dataTable tbody td {
    padding: 3px 2px;
}
</style>		
	<div class="row">
			
        <div class="col-xs-12 col-sm-12 col-md-12 col-lg-6 col-xl-12">						
			<div class="card mb-3">
				<div class="card-header">
				<span class="pull-right">
				<a href="Export/Export_student.php"><button class="btn btn-success m-l-5 btn-sm"><i class="fa fa-file-excel-o" aria-hidden="true"></i> ส่งออก</button></a>
				<a href="account.php?page=studentreport&op4=1"><button class="btn btn-secondary m-l-5 btn-sm"><i class="fa fa-print" aria-hidden="true"></i> พิมพ์ข้อมูล</button></a>
				<a href="account.php?page=student_regis&op4=1"><button class="btn btn-primary btn-sm"><i class="fa fa-user-plus" aria-hidden="true"></i> เพิ่มข้อมูล</button></a>
				</span>							
				<h3><i class="fa fa-table"></i> ข้อมูลบุคลากร </h3> ข้อมูล API จาก Big data
				</div>
							
					<div class="card-body">
	
						<!-- ส่วนของฟอร์มข้อมูล-->

<table id="example1" data-page-length="25" class="table table-bordered table-hover display" cellspacing="0" width="100%">
<thead>
	<tr>
		<th width="15">ที่</th>
		<th width="90">เลขประชาชน</th>
		<th>ชื่อ-นามสกุล</th>
		<th width="80">อายุ</th>		
		<th>ตำแหน่ง</th>
		<th>วิทยฐานะ</th>
		<th>ที่อยู่</th>
	</tr>
</thead>
<tbody>
	<?php

	$url = ''.$api_url.'/api/teacher.php?csid='.$user;

	$data = file_get_contents($url);

	$data = json_decode($data);
$i=0;
	foreach($data as $member){
$i++
	?>
	<tr>
		<td align="center"><?php echo $i; ?></td>
		<td align="center"><?php echo $member->personId ?></td>
		<td><?php echo $member->prefixName ?> <?php echo $member->firstName ?> <?php echo $member->lastName ?></td>
		<td align="center">
<?php
//คำนวณอายุ  1985-06-25
    $birthday = ($member->birthdate) ;
	
    $date = str_replace('/', '-', $birthday);
    $bdate = date('Y-m-d', strtotime($date));

	$bday = new DateTime($bdate); // Your date of birth
	$birthday = new Datetime(date('y-m-d'));
	$diff = $birthday->diff($bday);
	printf('%dปี %dเดือน %dวัน', $diff->y, $diff->m, $diff->d);	
	
	//echo "$birthday";
?>
		
		</td>
		<td><?php echo $member->positionName ?></td>
		<td><?php echo $member->academicStandingName ?></td>
		<td><?php echo $member->currentHouseNumber ?> <?php echo $member->currentVillageNumber ?> <?php echo $member->currentStreet ?> <?php echo $member->currentSoi ?> <?php echo $member->currentTrok ?>
		<?php echo $member->subdistrictName ?> <?php echo $member->districtName ?> <?php echo $member->provinceName ?>
		</td>		
	</tr>
<?php
 }
 ?>
</tbody>
</table>


						<!-- สจบ่วนของฟอร์มข้อมูล-->
					
								
					</div>														
			</div><!-- end card-->					
        </div>
					


	</div>
<?php }else{
header("Location: ../index.php?msg=error");
exit;	
} ?>