<?php
if(isset($ugroup)){
	
?>

	<div class="row">
		<div class="col-xl-12">
			<div class="breadcrumb-holder">
				<h1 class="main-title float-left"><?php if($ugroup=="donate"){ echo ""; }?><?=$fullname?></h1>
					<ol class="breadcrumb float-right">
					<li class="breadcrumb-item">Home</li>
					<li class="breadcrumb-item active"></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="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="table1" 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>
      </tr>
    </thead>
    <tbody>
<?php

function get_full_name($table,$id){
	global $mysqli;
	 $sql = "SELECT * FROM $table WHERE username='$id'";
	$sqls = $mysqli->query($sql); 
	if(mysqli_num_rows($sqls)>=1){
		$rows = mysqli_fetch_array($sqls);
		return $rows ['fullname'];
	}
	else return "";
}
function get_school_name($id){
	$ret = get_full_name("log_obec",$id);
	if($ret <> "") return $ret;
	$ret = get_full_name("log_area",$id);
	if($ret <> "") return $ret;
	$ret = get_full_name("log_school",$id);
	if($ret <> "") return $ret;
	return "";
}

$sqlx= $mysqli->query("SELECT
  *
FROM
  `tb_donated`
  INNER JOIN `tb_category_detail` ON `tb_donated`.`u_type` =
`tb_category_detail`.`Did`
WHERE
  `tb_donated`.`u_donate` = '$user' ");



/*$sqlx= $mysqli->query("SELECT
  *
FROM
  `tb_donated`
  INNER JOIN `tb_category_detail` ON `tb_donated`.`u_type` =
`tb_category_detail`.`Did`
WHERE
  `tb_donated`.`u_donate` = '$user' "); */

$i = 0;
while($rowx=mysqli_fetch_array($sqlx)) {
$i++;

?>	
      <tr>
        <td align="center" width="10"><?php echo "$i"; ?></td>
		<td align="center"><?=$rowx['u_date'] ."/". $rowx['u_month'] ."/". $rowx['u_year']; ?></td>
	
				<td width="200">	<? 
				echo get_school_name( $rowx['u_scid'] );
	?></td>
		<td><?=$rowx['d_title'];?></td>
		<td align="center" width="70"><?=$rowx['u_max'];?></td>
		<td align="center" width="70"><?=number_format($rowx['u_sarary'],2);?></td>

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



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

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

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