Gecko [ 122.154.134.11 ]

Name	Size	Permission
detail.php	3.16 KB	-rw-r--r--
indicator.php	30.6 KB	-rw-r--r--
livesearch1.php	795 B	-rw-r--r--
livesearch2.php	1.03 KB	-rw-r--r--
livesearch3.php	787 B	-rw-r--r--
livesearch4.php	1.02 KB	-rw-r--r--
livesearch_101.php	17.73 KB	-rw-r--r--
permission.php	11.16 KB	-rw-r--r--
report_1.php	31.11 KB	-rw-r--r--
report_2.php	29.43 KB	-rw-r--r--
report_3.php	21.18 KB	-rw-r--r--
report_4.php	5.9 KB	-rw-r--r--
report_5.php	4.04 KB	-rw-r--r--
sp1.php	62.26 KB	-rw-r--r--
sp1_mobile.php	50.04 KB	-rw-r--r--
sp2.php	6.59 KB	-rw-r--r--
sp3.php	5.75 KB	-rw-r--r--
sp4.php	5.23 KB	-rw-r--r--
standard.php	7.89 KB	-rw-r--r--
std_detail.php	8.18 KB	-rw-r--r--
std_detail2.php	9.22 KB	-rw-r--r--
supervision_activity.php	11.1 KB	-rw-r--r--
supervision_activity_number.ph...	10.05 KB	-rw-r--r--
supervision_activity_rate.php	5.49 KB	-rw-r--r--
supervision_item.php	11.3 KB	-rw-r--r--
supervision_year.php	11.12 KB	-rw-r--r--
teach_table.php	13.48 KB	-rw-r--r--

Code Editor : report_4.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/supervision/time_inc.php";

if($_SESSION['user_os'] =="mobile"){
 $width_1="97%";
 }
 else{
  $width_1="75%";
 }

$sql_item = "select id,item from supervision_item where item_active='1'";
$dbquery_item = mysqli_query($connect,$sql_item);
if($result_item = mysqli_fetch_array($dbquery_item)){
$supervision_item=$result_item['id'];
$item_name=$result_item['item'];
}
else{
$sql_item = "select id,item from supervision_item order by id desc";
$dbquery_item = mysqli_query($connect,$sql_item);
$result_item = mysqli_fetch_array($dbquery_item);
$supervision_item=$result_item['id'];
$item_name=$result_item['item'];
}

echo "<br />";
echo "<table width='50%' border='0' align='center'>";
echo "<tr align='center'><td><font color='#006666' size='3'><strong>ติดตามการนิเทศตนเอง</strong></font></td></tr>";
echo "<tr align='center'><td><font color='#006666' size='2'><strong>$item_name</strong></font></td></tr>";
echo "</table>";

$sql = "select * from system_school_group order by id";
$dbquery = mysqli_query($connect,$sql);
echo "<br>";
echo "<table border='1' style='border-collapse: collapse' width='$width_1' align='center'>";
echo "<Tr bgcolor='#E6E6E6' align='center'><Td width='50'>กลุ่มที่</Td><Td>ชื่อกลุ่ม</Td><Td>โรงเรียนที่</Td><Td>รหัสโรงเรียน</Td><Td>ชื่อโรงเรียน</Td><Td>จำนวนบุคลากร<br>(ผู้อำนวยการและครู)</Td><td>ประเมินตนเองแล้ว</Td><td>%</Td><td>แนบไฟล์ด้วย(คน)</Td><td width='50'>รายละเอียด</Td></Tr>";
$N=1; 
$XX=0;  //จำนวนบุคลากรทั้งหมด
$do_total=0; //จำนวนผู้นิเทศตนเองทั้งหมด
$do_total_percent=0;
$file_num_total=0;

While ($result = mysqli_fetch_array($dbquery)){
$group_code = $result['code'];
$group_name= $result['name'];

//กลุ่ม
$group_person=0;
$do_group=0;
$file_group=0;
$do_group_percent=0;

echo "<Tr align='center' bgcolor='#CECEF6'><Td>$N</Td> <Td align='left' colspan='9'>&nbsp;&nbsp;$group_name</Td></tr>";

$sql2 = "select * from system_school  where school_group='$group_code' order by school_code";
			$dbquery2 = mysqli_query($connect,$sql2);
			$M=1;
			While ($result2 = mysqli_fetch_array($dbquery2)){
			$school_code = $result2['school_code'];
			$school_name = $result2['school_name'];
			if(($M%2) == 0)
			$color="#FFFFC";
			else  $color="#FFFFFF";
			
			$sql3 = "select person_id from person_sch_main  where school_code='$school_code' and (position_code='1' or position_code='2' or position_code='3' or position_code='4' or position_code='11' or position_code='12' or position_code='31' or position_code='35') and status='0' ";
			$dbquery3 = mysqli_query($connect,$sql3);
			
			$X=0; // จำนวนบุคลากรในโรงเรียน
			$do_num=0;
			$do_percent=0;
			$file_num=0;
			
			While ($result3 = mysqli_fetch_array($dbquery3)){
			$person_id = $result3['person_id'];
			
			$sql4 = "select  id,ref_id from supervision_main where person_id='$person_id' and school_id='$school_code' and level='1' and item='$supervision_item' ";
			$dbquery4 = mysqli_query($connect,$sql4);
			$result4 = mysqli_fetch_array($dbquery4);
			$ref_id=$result4['ref_id']; 
					if($result4){
					$do_num++;
					$do_group++;
					$do_total++;
					}
		
			$sql5 = "select  id from supervision_file where ref_id='$ref_id' ";
			$dbquery5 = mysqli_query($connect,$sql5);
			$result5 = mysqli_fetch_array($dbquery5);
					if($result5){
					$file_num++;
					$file_group++;
					$file_num_total++;
					}

$X++;
			$XX++;
			$group_person++;
			}
			
			if($X>0){
			$do_percent=$do_num/$X*100;
			$do_percent=number_format($do_percent,2);
			}
			
			echo "<Tr align='center' bgcolor='$color'><Td colspan='2'></Td><Td align='center'>$M</Td><Td align='center'>$school_code </Td><Td align='left'>$school_name</Td><Td align='ceter'>";
			if($X>0){
			echo $X;
			}
			echo "</Td><Td align='ceter'>";
			if($do_num>0){
			echo $do_num;
			}
			echo "</Td><Td align='ceter'>";
			if($do_num>0){
			echo $do_percent;
			}
			echo "</Td><Td align='ceter'>";
			if($do_num>0){
			echo $file_num;
			}
			echo "</Td>";
			
?>
<td><A HREF="javascript:void(0)"
onclick="window.open('modules/supervision/main/report_5.php?school_code=<?php echo $school_code?>',
'test_item','width=800,height=500,scrollbars')" title="นิเทศ"><span style="text-decoration: none">คลิก</span></A></td>
<?php
			
			echo "</tr>";
				$M++;
			 }

if($group_person>0){		
$do_group_percent=$do_group/$group_person*100;
$do_group_percent=number_format($do_group_percent,2);	
}

$file_group=number_format($file_group,0);

echo "<Tr align='center' bgcolor='#F6CECE'><Td colspan='5'>รวม ($group_name)</Td><Td align='ceter'>$group_person</Td><Td align='ceter'>$do_group</Td><Td align='ceter'>$do_group_percent</Td><Td align='ceter'>$file_group</Td><td></td></tr>";
$N++;  //*เกี่ยวข้องกับการแยกหน้า
	}
	
			if($XX>0){
			$do_total_percent=$do_total/$XX*100;
			$do_total_percent=number_format($do_total_percent,2);
			}
			$XX=number_format($XX,0);
			$do_total=number_format($do_total,0);
			
			$file_num_total=number_format($file_num_total,0);
			
			echo "<Tr align='center' bgcolor='#E6E6E6'><Td colspan='5'>รวม (ทั้งหมด)</Td><Td align='ceter'>$XX</Td><Td align='ceter'>$do_total</Td><Td align='ceter'>$do_total_percent</Td><Td align='ceter'>$file_num_total</Td><td></td></tr>";

${this.title}

Code Editor : report_4.php