Gecko [ 122.154.134.11 ]

Name	Size	Permission
affair.php	13.31 KB	-rw-r--r--
b_pic.php	5.98 KB	-rw-r--r--
building_building.php	16.72 KB	-rw-r--r--
building_building_report.php	5.4 KB	-rw-r--r--
building_fix.php	15.92 KB	-rw-r--r--
building_fix_report.php	6.52 KB	-rw-r--r--
building_heavy.php	16 KB	-rw-r--r--
building_heavy_report.php	6.55 KB	-rw-r--r--
building_main.php	30.9 KB	-rw-r--r--
category.php	6.52 KB	-rw-r--r--
livesearch_2.php	659 B	-rw-r--r--
livesearch_3.php	667 B	-rw-r--r--
livesearch_4.php	667 B	-rw-r--r--
model.php	15.4 KB	-rw-r--r--
pic_show.php	709 B	-rw-r--r--
report_1.php	13.61 KB	-rw-r--r--
report_1_mobile.php	12.38 KB	-rw-r--r--
report_affair.php	5.02 KB	-rw-r--r--
report_affair_mobile.php	4.87 KB	-rw-r--r--
report_affair_web.php	5.31 KB	-rw-r--r--
return_ajax_cate.php	614 B	-rw-r--r--
return_ajax_type.php	620 B	-rw-r--r--

Code Editor : building_heavy_report.php

<?php
/** ensure this file is being included by a parent file */
defined( '_VALID_' ) or die( 'Direct Access to this location is not allowed.' );
$officer=$_SESSION['login_user_id'];
require_once "modules/building/time_inc.php";

$sql = "select distinct get_year from building_heavy";
$dbquery = mysqli_query($connect,$sql);
$max_year=0;
While ($result = mysqli_fetch_array($dbquery)){
$get_year=$result['get_year'];
		if($get_year>=$max_year){
		$max_year=$get_year;
		}
}
$max_year1=$max_year-4;
$max_year2=$max_year-3;
$max_year3=$max_year-2;
$max_year4=$max_year-1;
$max_year5=$max_year;

//ปีการศึกษา
$sql = "select * from  student_main_edyear  where year_active='1' order by  ed_year desc limit 1";
$dbquery = mysqli_query($connect,$sql);
$year_active_result = mysqli_fetch_array($dbquery);
if($year_active_result['ed_year']==""){
echo "<br />";
echo "<div align='center'>ยังไม่ได้กำหนดทำงานในปีการศึกษาใด ๆ  การรายงานนี้เกี่ยวข้องกับจำนวนนักเรียน ต้องไปดำเนินการในส่วนข้อมูลนักเรียนก่อน</div>";
exit();
}

//ส่วนหัว
echo "<br />";
if(!(($index==1) or ($index==2) or ($index==5))){
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>รายงานงบครุภัณฑ์โรงเรียน</strong></font></td></tr>";
echo "</table>";
}

if($index==7){
$sql = "select school_name from system_school";
$dbquery = mysqli_query($connect,$sql);
$result = mysqli_fetch_array($dbquery);
$school_name=$result['school_name'];

echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='2'><strong>$school_name</strong></font></td></tr>";
echo "</table>";
echo  "<table width='75%' border='0' align='center'>";
echo "<Tr><Td  align='right'><INPUT TYPE='button' name='smb' value='<<กลับหน้าก่อน' onclick='location.href=\"?option=building&task=main/building_heavy_report\"'></Td></Tr>";
echo "</td></Tr></Table>";

echo  "<table width='75%' border='1' align='center' style='border-collapse: collapse'>";
$sql = "select *,building_heavy.id from building_heavy left join system_school on building_heavy.school_code=system_school.school_code 
where building_heavy.school_code='$_GET[school_code]' order by building_heavy.get_year, building_heavy.id";
$dbquery = mysqli_query($connect,$sql);
echo "<Tr bgcolor='#ddd' align='center' height='30' class='subHeader'><Td width='60'>ที่</Td><Td>โรงเรียน</Td><td width='100'>ปีงบประมาณ</td><Td>รายการ</Td><Td width='150'>จำนวนเงิน</Td></Tr>";
$N=1;

While ($result = mysqli_fetch_array($dbquery)){
		$id = $result['id'];
		$school_code= $result['school_code'];
		$school_name= $result['school_name'];
		$get_year= $result['get_year'];
		$budget= $result['budget'];
		$other= $result['other'];
		
		$budget=number_format($budget,2);
	
		if(($N%2) == 0)
		$color="#FFFFC";
		else $color="#FFFFFF";
		
		echo "<Tr bgcolor='$color' align='center' valign='top'><Td >$N</Td><Td align='left'>$school_name</Td><td>$get_year</td><td align='left'>$other</td><td align='right'>$budget</td>"; 
$N++;
	}
echo "</table>";	
}

if($index!=7){
echo "<br>";
echo  "<table width='95%' border='1' align='center' style='border-collapse: collapse'>";

$sql = "select * from system_school where school_type='1' order by school_code";
$dbquery = mysqli_query($connect,$sql);
echo "<Tr bgcolor='#ddd' align='center' height='30' class='subHeader'><Td width='60'>ที่</Td><Td width='70'>รหัส</Td><Td>โรงเรียน</Td><td width='90'>ปี $max_year1</td><td width='90'>ปี $max_year2</td><td width='90'>ปี $max_year3</td><td width='90'>ปี $max_year4</td><td width='90'>ปี $max_year5</td><Td width='80'>จำนวนรายการ</Td><Td width='100'>จำนวนเงิน</Td><Td width='100'>เฉลี่ย/นร</Td><Td width='60'>รายละเอียด</Td></Tr>";

$N=1;
While ($result = mysqli_fetch_array($dbquery))
	{
		$id = $result['id'];
		$school_code= $result['school_code'];
		$school_name= $result['school_name'];
		
		$sql_count= "select student from student_main_num  where school_code='$school_code' and ed_year='$year_active_result[ed_year]'";
		$dbquery_count = mysqli_query($connect,$sql_count);
		$result_count = mysqli_fetch_array($dbquery_count);
		$student_num=$result_count['student']; 
		
					//
					$total_budget=0;
					$total_item=0;
					for ($x = $max_year1; $x <= $max_year5; $x++) {
					$sql_fix1 = "select count(id) as item, sum(budget) as budget from building_heavy where school_code='$school_code' and get_year='$x' ";
					$dbquery_fix1 = mysqli_query($connect,$sql_fix1);
					$result_fix1 = mysqli_fetch_array($dbquery_fix1);
					$budget[$x]=$result_fix1['budget']; 
					$item[$x]=$result_fix1['item']; 
					$total_budget=$total_budget+$budget[$x];
					$total_item=$total_item+$item[$x];
					}	
	
		if(($N%2) == 0)
		$color="#FFFFC";
		else 	$color="#FFFFFF";
		
		echo "<Tr bgcolor='$color' align='center'><Td >$N</Td><td>$school_code</td><Td align='left'>$school_name</Td><td align='right'>";
		if($budget[$max_year1]>0){
		echo number_format($budget[$max_year1],2);
		}
		echo "</td><td align='right'>";
		if($budget[$max_year2]>0){
		echo number_format($budget[$max_year2],2);
		}
		echo "</td><td align='right'>";
		if($budget[$max_year3]>0){
		echo number_format($budget[$max_year3],2);
		}
		echo "</td><td align='right'>";
		if($budget[$max_year4]>0){
		echo number_format($budget[$max_year4],2);
		}
		echo "</td><td align='right'>";
		if($budget[$max_year5]>0){
		echo number_format($budget[$max_year5],2);
		}
		echo "</td><td>";
		if($total_item>0){
		echo $total_item;
		}
		echo "</td><td align='right'>";
		if($total_budget>0){
		echo number_format($total_budget,2);
		}
		echo "</td><td align='right'>";
		if($student_num>0){
				if($total_budget>0){
				$budget_avg=$total_budget/$student_num;
				echo number_format($budget_avg,2);
				}
		}
		echo "</td>";
		echo "<td>";
		if($total_budget>0){
		echo "<a href=?option=building&task=main/building_heavy_report&index=7&school_code=$school_code><img src=./images/browse.png border='0'></a>";
		}
		echo "</td>";
		echo "</Tr>";
$N++;
	}
echo "</table>";	
}
?>

${this.title}

Code Editor : building_heavy_report.php