<?php
include 'include/controllerAc.php';
$YearCount=$_GET['YearCount'];
$id=$_GET['id'];
$case=$_GET['case'];
$no=1;
//จำนวนชั่วโมงวิชาการ(พัฒนาภายใน)
if($case==1){
$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_in<>0 ";
$result1 = $conn->query($query1);
$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_in<>0 ";
$result3 = $conn->query($query3);
while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}
//จำนวนชั่วโมงวิชาชีพ(พัฒนาภายใน)
if($case==2){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_in<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_in<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}
//จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายใน)
if($case==3){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_in<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_in<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}
//จำนวนชั่วโมงวิชาการ(พัฒนาภายนอก) ใช้งบ
if($case==4){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_outbudget<>0  AND ac_money<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_outbudget<>0  AND ac_money<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}
//จำนวนชั่วโมงวิชาชีพ(พัฒนาภายนอก) ใช้งบ
if($case==5){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_outbudget<>0  AND pr_money<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_outbudget<>0  AND pr_money<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}

//จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายนอก) ใช้งบ
if($case==6){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_outbudget<>0 AND  moral_money<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_outbudget<>0 AND  moral_money<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
}

//จำนวนชั่วโมงวิชาการ(พัฒนาภายนอกไม่ใช้งบ)
if($case==7){
	$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_out<>0 ";
	$result1 = $conn->query($query1);
	$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
	FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND ac_hour_out<>0 ";
	$result3 = $conn->query($query3);
	while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
	}
//จำนวนชั่วโมงวิชาชีพ(พัฒนาภายนอกไม่ใช้งบ)
	if($case==8){
		$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_out<>0 ";
		$result1 = $conn->query($query1);
		$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
		FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND pr_hour_out<>0 ";
		$result3 = $conn->query($query3);
		while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
	}
//จำนวนชั่วโมงคุณธรรมจริยธรรม(พัฒนาภายนอกไม่ใช้งบ)
	if($case==9){
		$query1 = "SELECT * FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_out<>0 ";
		$result1 = $conn->query($query1);
		$query3 = "SELECT SUM(ac_hour_in) AS to1,SUM(ac_hour_outbudget) AS to2,SUM(ac_hour_out) AS to3,SUM(pr_hour_in) AS to4,SUM(pr_hour_outbudget) AS to5,SUM(pr_hour_out) AS to6,SUM(moral_hour_in) AS to7,SUM(moral_hour_outbudget) AS to8,SUM(moral_hour_out) AS to9
		FROM v_report  WHERE fiyear='$YearCount' AND personCode=$id AND moral_hour_out<>0 ";
		$result3 = $conn->query($query3);
		while($values1 = $result3->fetch_assoc()){$sumAll=($values1['to1']+$values1['to2']+$values1['to3']+$values1['to4']+$values1['to5']+$values1['to6']+$values1['to7']+$values1['to8']+$values1['to9']);}
	}

$query2 = "SELECT * FROM persontb  WHERE personCode=$id ";
$result2 = $conn->query($query2);
while($values = $result2->fetch_assoc()){$name=$values['name']." ".$values['surName'];}



?>
<!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="preconnect" href="https://fonts.gstatic.com">
    <link href="https://fonts.googleapis.com/css2?family=Niramit&display=swap" rel="stylesheet">
    <style>
      body {
        font-family: 'Niramit', sans-serif;
        font-size: 12px;
      }
    </style>
</head>
<body>
<table class="table table-striped">
		  <thead class="thead-dark">
			<tr>
				<th colspan="13"><center>ข้อมูลจำนวนชั่วโมงวิชาการวิชาชีพและคุณธรรมจริยธรรม จำแนกตามปีการศึกษา  <?=$YearCount?> ของ <?=$name?></center></th>
			</tr>
			<tr>
			  <th class="text-center" width="5%">ครั้งที่</th>
			  <th class="text-left" width="30%">ชื่อโครงการที่เข้าร่วม</th>
			  <th class="text-center">เริ่มต้น</th>
			  <th class="text-center">สิ้นสุด</th>
			  <th class="text-center">ชม.วก.</th>
			  <th class="text-center">ชม.วช.</th>
			  <th class="text-center">ชม.คธ.</th>
			  <th class="text-right">เงิน วก.</th>
			  <th class="text-right">เงิน วช.</th>
			  <th class="text-right">เงิน คธ.</th>
			  <th class="text-right">รวมเงิน</th>
			  <th class="text-center">รวมชั่วโมง</th>
			  <th class="text-center">% รายโครงการ</th>
			  </tr>
		  </thead>
		  <tbody>
			  <?php
			  $no=1;
			  $sumary1=0;
			  $sumary2=0;
			  $sumary3=0;
			  $sumary4=0;
			  $sumary5=0;
			  $sumary6=0;
			  $sumary7=0;
			  $sumary8=0;
			  while($res1 = $result1->fetch_assoc()){
				
			  ?>
			  <tr>
		 	  <td class="text-center"><?=$no?></td>
			  <td class="text-left"><?=$res1['projectName']?></td>
			  <td class="text-center"><?=DateThai($res1['start'])?></td>
			  <td class="text-center"><?=DateThai($res1['end'])?></td>
			  <td class="text-center"><?=number_format($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out'])?></td>
			  <td class="text-center"><?=number_format($res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out'])?></td>
			  <td class="text-center"><?=number_format($res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out'])?></td>
			  <td class="text-right"><?=number_format($res1['ac_money'])?></td>
			  <td class="text-right"><?=number_format($res1['pr_money'])?></td>
			  <td class="text-right"><?=number_format($res1['moral_money'])?></td>
			  <td class="text-right"><?=number_format(($res1['ac_money']+$res1['pr_money']+$res1['moral_money']),2)?></td>
			  <td class="text-center"><?=number_format(($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out']+$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out']+$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out']),2)?></td>
			  <td class="text-center"><?=number_format((($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out']+$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out']+$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out'])/$sumAll)*100,2)?>%</td>
			  </tr>
			  <?php
			  
			  $no++;
			  $sumary1+=$res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out'];
			  $sumary2+=$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out'];
			  $sumary3+=$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out'];
			  $sumary4+=$res1['ac_money'];
			  $sumary5+=$res1['pr_money'];
			  $sumary6+=$res1['moral_money'];
			  $sumary7+=($res1['ac_money']+$res1['pr_money']+$res1['moral_money']);
			  $sumary8+=($res1['ac_hour_in']+$res1['ac_hour_outbudget']+$res1['ac_hour_out']+$res1['pr_hour_in']+$res1['pr_hour_outbudget']+$res1['pr_hour_out']+$res1['moral_hour_in']+$res1['moral_hour_outbudget']+$res1['moral_hour_out']);
			  }
			  ?>
			  <tr>
			  <td class="text-right" colspan="4"><b>รวมทั้งหมด</b></td>
			  <td class="text-center"><?=number_format($sumary1,2)?></td>
			  <td class="text-right"><?=number_format($sumary2,2)?></td>
			  <td class="text-right"><?=number_format($sumary3,2)?></td>
			  <td class="text-right"><?=number_format($sumary4,2)?></td>
			  <td class="text-right"><?=number_format($sumary5,2)?></td>
			  <td class="text-right"><?=number_format($sumary6,2)?></td>
			  <td class="text-right"><?=number_format($sumary7,2)?></td>
			  <td class="text-center"><?=number_format($sumary8,2)?></td>
			  <td class="text-center"></td>
			  </tr>
		  </tbody>
</table>
</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";
}
?>