<?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> <?php if($ugroup=="school"){ echo "โรงเรียน";} ?><?=$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 
// Msg แจ้งเตือนการทำงาน
if(isset($_GET['msg'])){ ?>
<script type="text/javascript">
    $(window).on('load',function(){
        $('#msgAlert').modal('show');
    });
</script>
<?php } else {} ?>	
<?php  include ("pages/modals/modal_msg.php");?>



    <!-- 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-lg-12">						
			<div class="card mb-3">
				<div class="card-header">
				<span class="pull-right">
				<a href="account.php?page=add_donate_detail&op31=1"><button class="btn btn-primary btn-sm"><i class="fa fa-user-plus" aria-hidden="true"></i> เพิ่มข้อมูล</button></a>				
				<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>
				</span>							
				<h3><i class="fa fa-table"></i> ได้รับบริจาค</h3>
				</div>
								
					<div class="card-body">
						<!-- ส่วนของฟอร์มข้อมูล-->
<?php 
//เผื่อไว้แสดงข้อมูลปีปัจจุบัน
$setyear=date("Y")+543; 

?>					
<table id="example1" data-page-length="10" class="table table-bordered table-hover display" cellspacing="0" width="100%">
    <thead>
      <tr>
        <th><center>ที่</center></th>
        <th><center>รายการ</center></th>
        <th><center>จำนวน</center></th>
		<th><center>งบประมาณ</center></th>
		<th><center>ผู้บริจาค</center></th>
		<th><center>วันที่รับบริจาค</center></th>
		<th><center>ดำเนินการ</center></th>
      </tr>
    </thead>
    <tbody>
<?php
$table ="requirements";
$sql= $mysqli->query("SELECT
  *
FROM
  `tb_donated`
  INNER JOIN `tb_category_detail` ON `tb_donated`.`u_type` =
`tb_category_detail`.`Did` where u_del = 0 and u_scid= '$user'
");

$i = 0;
while($row=mysqli_fetch_array($sql)) {
$i++;

?>	
      <tr>
        <td align="center" width="10"><?php echo "$i"; ?></td>
        <td>&nbsp;<?=$row['d_title'];?>  <font color="#608FFE"><?=$row['u_datail'];?></font></td>
        <td align="center"><?=$row['u_max'];?></td>
		<td align="right" width="110"><?=number_format($row['u_sarary'],2);?></td>
		<td align="left" width="160"><?=$row['u_name'];?></td>
		<td align="center"><?=$row['u_date'] ."/". $row['u_month'] ."/". $row['u_year']; ?></td>
		
		<td align="center">
	
    <a href="#" data-toggle="modal" data-target="#modal_delete<?=$row['ido'];?>">
    <font color="red"><i class="fa fa-trash-o" aria-hidden="true"></i></font></a>

    <?php
debug_backtrace() || die ("Direct access not permitted"); 
require_once "../include/PasswordHash.php";
?>
<!-- Jquery filer css -->

<div class="modal fade custom-modal" tabindex="-1" role="dialog" aria-labelledby="modal_delete<?=$row['ido'];?>" aria-hidden="true" id="modal_delete<?=$row['ido'];?>">
	<div class="modal-dialog">
    	<div class="modal-content">
        	
			<form action="core/delete_donate_detail.php?id=<?=$row['ido'];?>&dstatus=<?=$table;?>" method="post" enctype="multipart/form-data">

							
            <div class="modal-header">
          	<h5 class="modal-title"><i class="fa fa-trash-o" aria-hidden="true"></i> ลบข้อมูล</h5>
			<button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>          	
			</div>
				
			<div class="modal-body">                
				                			
				<div class="row">
					<div class="col-lg-12">

	<h5>คุณต้องการลบข้อมูลหรือไม่ ?   </h5>						

					</div>  
				</div>
				
            </div>             
			
			<div class="modal-footer">
				<button type="button" class="btn btn-secondary" data-dismiss="modal">ยกเลิก</button>
				<button type="submit"  name="importtea" class="btn btn-primary">ตกลง</button>
			</div>
				
			</form>	
			
        </div>
	</div>
</div>

    
		</td>
      </tr>
<?php } ?>
    </tbody>
  </table>



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

								
					</div>														
			</div><!-- end card-->					
        </div>
<!---------------------------------------------------------------------------------------->

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

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