<?php  
if(!isset($_SESSION)) session_start();
if(isset($_SESSION['ugroup'])){ 
$user=$_SESSION["loguser"];
$ugroup=$_SESSION["ugroup"];
//ส่งออกรายชื่อนักเรียน 
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
date_default_timezone_set('Asia/Bangkok');
require_once "../../include/config.php";

$u="";
$output = '';
$sql= $mysqli->query("SELECT * FROM log_area ");
 if(mysqli_num_rows($sql) > 0)
 {

  $output .= '
   <table class="table" bordered="1" border="1">  
                    <tr>  
                        <th>ที่</th>  
                        <th>รหัสเขต</th>  
                        <th>ชื่อเขตพื้นที่</th>
						<th>เลขผู้เสียภาษี</th>
						<th>จำนวนโรงเรียน</th>
                    </tr>
  ';
$i = 0;
  while($row = mysqli_fetch_array($sql))
  {
$i++;
$sql1sc= $mysqli->query("SELECT * FROM log_area ");
$total1sc=mysqli_num_rows($sql1sc);
$all=number_format("$total1sc");


   $output .= '<tr>';
   $output .= '<td width=50 align=center>'.$i.'</td>';
   $output .= '<td width=120 align=center>'.$u.'&nbsp;'.$row["username"].'</td> ';
   $output .= '<td width=500>'.$row["fullname"].'</td> ';
   $output .= '<td width=200>'.$row["idpayment"].'</td> ';
		$sqlx= $mysqli->query("SELECT * FROM log_school WHERE areacode='$row[username]'");
		$atotal=mysqli_num_rows($sqlx);   
   $output .= '<td width=100 align=center>'.$atotal.'</td> ';                       
   $output .= '</tr>';
  }
  $output .= '</table>';
 
$file = "สพท_" . date('Y-m-d') . ".xls";
header('Content-Disposition: attachment; filename='.$file);
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header("Content-Transfer-Encoding: BINARY");
echo $output;

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