Gecko [ 122.154.134.11 ]

Name	Size	Permission
building_show.php	4.58 KB	-rw-r--r--
livesearch1.php	787 B	-rw-r--r--
livesearch_202.php	5.82 KB	-rw-r--r--
livesearch_2021.php	4.86 KB	-rw-r--r--
livesearch_204.php	11.9 KB	-rw-r--r--
livesearch_2041.php	9.97 KB	-rw-r--r--
livesearch_2044.php	11.8 KB	-rw-r--r--
livesearch_20441.php	9.83 KB	-rw-r--r--
livesearch_206.php	11.79 KB	-rw-r--r--
livesearch_2061.php	9.79 KB	-rw-r--r--
livesearch_301.php	3.16 KB	-rw-r--r--
livesearch_302.php	3.36 KB	-rw-r--r--
livesearch_ach.php	7.15 KB	-rw-r--r--
livesearch_ach_2.php	7.85 KB	-rw-r--r--
livesearch_allperson.php	1.59 KB	-rw-r--r--
livesearch_amphoe_school.php	1.53 KB	-rw-r--r--
livesearch_budget.php	10.99 KB	-rw-r--r--
livesearch_building.php	3.14 KB	-rw-r--r--
livesearch_chart2.php	625 B	-rw-r--r--
livesearch_chart3.php	872 B	-rw-r--r--
livesearch_chart3_2.php	987 B	-rw-r--r--
livesearch_chart3_3.php	1.37 KB	-rw-r--r--
livesearch_chart3_4.php	847 B	-rw-r--r--
livesearch_chart3_5.php	883 B	-rw-r--r--
livesearch_chart3_6.php	879 B	-rw-r--r--
livesearch_chart3_7.php	922 B	-rw-r--r--
livesearch_chart4.php	607 B	-rw-r--r--
livesearch_chart4_2.php	1.05 KB	-rw-r--r--
livesearch_computer.php	4.46 KB	-rw-r--r--
livesearch_g_ach_2.php	8.67 KB	-rw-r--r--
livesearch_health1.php	9.7 KB	-rw-r--r--
livesearch_health2.php	8.81 KB	-rw-r--r--
livesearch_khetopportunity.php	3.74 KB	-rw-r--r--
livesearch_khetopportunity2.ph...	3.8 KB	-rw-r--r--
livesearch_khetopportunity3.ph...	3.74 KB	-rw-r--r--
livesearch_khetperson.php	1.44 KB	-rw-r--r--
livesearch_nt.php	2.68 KB	-rw-r--r--
livesearch_nt2.php	3.05 KB	-rw-r--r--
livesearch_nt3.php	5.26 KB	-rw-r--r--
livesearch_opportunity.php	8 KB	-rw-r--r--
livesearch_opportunity2.php	8 KB	-rw-r--r--
livesearch_opportunity3.php	8.01 KB	-rw-r--r--
livesearch_plan.php	4.3 KB	-rw-r--r--
livesearch_plc.php	5.71 KB	-rw-r--r--
livesearch_plc2.php	3.15 KB	-rw-r--r--
livesearch_read.php	7.91 KB	-rw-r--r--
livesearch_sch_person.php	1.51 KB	-rw-r--r--
livesearch_school.php	2.19 KB	-rw-r--r--
livesearch_school_group.php	2.64 KB	-rw-r--r--
livesearch_school_group2.php	2.3 KB	-rw-r--r--
livesearch_small_school.php	1.95 KB	-rw-r--r--
livesearch_smss_std.php	5.28 KB	-rw-r--r--
livesearch_std.php	11.24 KB	-rw-r--r--
livesearch_std2.php	11.05 KB	-rw-r--r--
livesearch_std3.php	7.02 KB	-rw-r--r--
livesearch_std4.php	6.91 KB	-rw-r--r--
livesearch_std_check.php	3.31 KB	-rw-r--r--
livesearch_std_check2.php	3.28 KB	-rw-r--r--
livesearch_student.php	3.96 KB	-rw-r--r--
livesearch_student2.php	4.17 KB	-rw-r--r--
livesearch_student3.php	10.44 KB	-rw-r--r--
livesearch_student_list.php	5.22 KB	-rw-r--r--
livesearch_supervision.php	13.24 KB	-rw-r--r--
permission.php	11.13 KB	-rw-r--r--
school_report_1.php	52.88 KB	-rw-r--r--
school_report_2.php	36.59 KB	-rw-r--r--

Code Editor : livesearch_health1.php

<?php
session_start();
if(!(isset($_SESSION['login_user_id']))){
exit();
}
error_reporting(0);

require_once("../../../amssplus_connect.php");
require_once("../../../mainfile.php");

$q=$_GET["q"];

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

$requester_server_id = $_SERVER["SERVER_ADDR"]; 
$sql_sync = "select * from  system_sync_smss_2 where office_code='$q'";
$dbquery_sync = mysqli_query($connect,$sql_sync);
$result_sync = mysqli_fetch_array($dbquery_sync);
$school_code = $result_sync['office_code'];
$smss_url=$result_sync['smss_url'];
$sync_code=$result_sync['sync_code']; 
$url ="$smss_url"."export/xml.php?username=amssplus&password=$sync_code&requester_server_id=$requester_server_id&order=health&index=1";

$xmlDoc = new DOMDocument();
$xmlDoc->load($url);
$announce = $xmlDoc->getElementsByTagName('item');
$announce2 = $xmlDoc->getElementsByTagName('item2');
$warning=base64_decode($xmlDoc->getElementsByTagName('warning')->item(0)->nodeValue);  
$ed_year=base64_decode($xmlDoc->getElementsByTagName('ed_year')->item(0)->nodeValue);  
$tm=base64_decode($xmlDoc->getElementsByTagName('tm')->item(0)->nodeValue);  
$ck=base64_decode($xmlDoc->getElementsByTagName('ck')->item(0)->nodeValue);

if($warning==1){
$i=1;
echo "<br>";
echo "<div align='center'><font><b>รายงานน้ำหนักตามเกณฑ์ส่วนสูง  เกณฑ์กรมอนามัย กระทรวงสาธารณสุข</b></font></div>";
echo "<div align='center'><font><b>ปีการศึกษา $ed_year ภาคเรียนที่ $tm ครั้งที่ $ck</b></font></div>";
 
echo "<table border='1' style='border-collapse: collapse' width='$width_1' align='center'>";
  ?>
  <tr>
        <td rowspan="2" align="center" valign="middle" bgcolor="#76CEEB">ระดับชั้น</td>
        <td width="56" rowspan="2" align="center" valign="middle" bgcolor="#76CEEB">จำนวน<br> 
          นักเรียน         </td>
        <td width="64" rowspan="2" align="center" valign="middle" bgcolor="#76CEEB">ตรวจแล้ว</td>
        <td width="70" rowspan="2" align="center" valign="middle" bgcolor="#76CEEB">ยังไม่ตรวจ</td>
        <td colspan="6" align="center" valign="middle" bgcolor="#76CEEB">เทียบเกณฑ์มาตรฐาน<br>
          น้ำหนักกับส่วนสูง(กรมอนามัย)</td>
        <td colspan="2" align="center" valign="middle" bgcolor="#76CEEB">สุขภาพฟัน</td>
        <td colspan="2" align="center" valign="middle" bgcolor="#76CEEB">สุขภาพเหงือก</td>
        <td colspan="2" align="center" valign="middle" bgcolor="#76CEEB">ไอโอดีน</td>
        <td rowspan="2" align="center" valign="middle" bgcolor="#76CEEB">ร้อยละ<br />สุขภาพดี</td>
      </tr>
      <tr>
		<td width="51" align="center" valign="middle" bgcolor="#FE2E2E">อ้วน</td>
        <td width="52" align="center" valign="middle" bgcolor="#F3F781">เริ่มอ้วน</td>
 		<td width="52" align="center" valign="middle" bgcolor="#81F7F3">ท้วม</td>
        <td width="51" align="center" valign="middle" bgcolor="#81F781">สมส่วน</td>
        <td width="52" align="center" valign="middle" bgcolor="#F3F781">ค่อนข้าง<br>ผอม</td>
 		<td width="52" align="center" valign="middle" bgcolor="#FE2E2E">ผอม</td>
       
        <td width="38" align="center" valign="middle" bgcolor="#76CEEB">ไม่ผุ</td>
        <td width="38" align="center" valign="middle" bgcolor="#76CEEB">ผุ</td>
        <td width="44" align="center" valign="middle" bgcolor="#76CEEB">ดี</td>
        <td width="44" align="center" valign="middle" bgcolor="#76CEEB">ไม่ดี</td>
        <td width="50" align="center" valign="middle" bgcolor="#76CEEB">ปกติ</td>
        <td width="50" align="center" valign="middle" bgcolor="#76CEEB">ผิดปกติ</td>
      </tr>
	  <?php
	  $total_student=0;
	  $total_nocheckT=0; 	//ยังไม่ได้เช็ค
		foreach ($announce as $ann)
		{
				if(($i%2) == 0){
				$color="#FFFFC";
				}
				else {
				 $color="#FFFFFF";
				 }
		$class_name=base64_decode($ann->getElementsByTagName('class_name')->item(0)->nodeValue);		 
		$std_num=base64_decode($ann->getElementsByTagName('std_num')->item(0)->nodeValue);
		$total_student=$total_student+$std_num;
		$total_student=number_format($total_student);
		$std_checked_num=base64_decode($ann->getElementsByTagName('std_checked_num')->item(0)->nodeValue);
		$H6=base64_decode($ann->getElementsByTagName('H6')->item(0)->nodeValue);
		$H5=base64_decode($ann->getElementsByTagName('H5')->item(0)->nodeValue);
		$H4=base64_decode($ann->getElementsByTagName('H4')->item(0)->nodeValue);
		$H3=base64_decode($ann->getElementsByTagName('H3')->item(0)->nodeValue);
		$H2=base64_decode($ann->getElementsByTagName('H2')->item(0)->nodeValue);
		$H1=base64_decode($ann->getElementsByTagName('H1')->item(0)->nodeValue);
		
		$sum_gum_good=base64_decode($ann->getElementsByTagName('sum_gum_good')->item(0)->nodeValue);
		$sum_gum_no=base64_decode($ann->getElementsByTagName('sum_gum_no')->item(0)->nodeValue);
		$sum_tooth_good=base64_decode($ann->getElementsByTagName('sum_tooth_good')->item(0)->nodeValue);
		$sum_tooth_no=base64_decode($ann->getElementsByTagName('sum_tooth_no')->item(0)->nodeValue);
		$sum_iodine_good=base64_decode($ann->getElementsByTagName('sum_iodine_good')->item(0)->nodeValue);
		$sum_iodine_no=base64_decode($ann->getElementsByTagName('sum_iodine_no')->item(0)->nodeValue);
		$percent_sum_good=base64_decode($ann->getElementsByTagName('percent_sum_good')->item(0)->nodeValue);
		
		echo "<tr bgcolor=$color align='center'>";
		echo "<td align='center'>$class_name</td>";
		echo "<td align='center'>$std_num</td>";
		echo "<td align='center'>$std_checked_num</td>";
		$diferrent=$std_num-$std_checked_num;
		$total_nocheckT=$total_nocheckT+$diferrent;
		echo "<td align='center'>$diferrent</td>";
		echo "<td align='center'>";
		if($H6>0){ echo $H6;}
		echo "</td>";
		echo "<td align='center'>";
		if($H5>0){ echo $H5;}
		echo "</td>";
		echo "<td align='center'>";
		if($H4>0){ echo $H4;}
		echo "</td>";
		echo "<td align='center'>";
		if($H3>0){ echo $H3;}
		echo "</td>";
		echo "<td align='center'>";
		if($H2>0){ echo $H2;}
		echo "</td>";
		echo "<td align='center'>";
		if($H1>0){ echo $H1;}
		echo "</td>";
		
		echo "<td align='center'>";
		if($sum_gum_good>0){ echo $sum_gum_good;}
		echo "</td>";
		echo "<td align='center'>";
		if($sum_gum_no>0){ echo $sum_gum_no;}
		echo "</td>";
		echo "<td align='center'>";
		if($sum_tooth_good>0){ echo $sum_tooth_good;}
		echo "</td>";
		echo "<td align='center'>";
		if($sum_tooth_no>0){ echo $sum_tooth_no;}
		echo "</td>";
		echo "<td align='center'>";
		if($sum_iodine_good>0){ echo $sum_iodine_good;}
		echo "</td>";
		echo "<td align='center'>";
		if($sum_iodine_no>0){ echo $sum_iodine_no;}
		echo "</td>";
		echo "<td align='center'>";
		if($percent_sum_good>0){ echo number_format($percent_sum_good,2) ;}
		echo "</td>";

$i++;
		echo "</tr>";
		}
		
		foreach ($announce2 as $ann2)
		{
		$total_H6=base64_decode($ann2->getElementsByTagName('total_H6')->item(0)->nodeValue);
		$total_H5=base64_decode($ann2->getElementsByTagName('total_H5')->item(0)->nodeValue);
		$total_H4=base64_decode($ann2->getElementsByTagName('total_H4')->item(0)->nodeValue);
		$total_H3=base64_decode($ann2->getElementsByTagName('total_H3')->item(0)->nodeValue);
		$total_H2=base64_decode($ann2->getElementsByTagName('total_H2')->item(0)->nodeValue);
		$total_H1=base64_decode($ann2->getElementsByTagName('total_H1')->item(0)->nodeValue);
		
		$total_sum_gum_good=base64_decode($ann2->getElementsByTagName('total_sum_gum_good')->item(0)->nodeValue);
		$total_sum_gum_no=base64_decode($ann2->getElementsByTagName('total_sum_gum_no')->item(0)->nodeValue);
		$total_sum_tooth_good=base64_decode($ann2->getElementsByTagName('total_sum_tooth_good')->item(0)->nodeValue);
		$total_sum_tooth_no=base64_decode($ann2->getElementsByTagName('total_sum_tooth_no')->item(0)->nodeValue);
		$total_sum_iodine_good=base64_decode($ann2->getElementsByTagName('total_sum_iodine_good')->item(0)->nodeValue);
		$total_sum_iodine_no=base64_decode($ann2->getElementsByTagName('total_sum_iodine_no')->item(0)->nodeValue);
		
		$total_checked_student=base64_decode($ann2->getElementsByTagName('total_checked_student')->item(0)->nodeValue);	
		$percent_total_checked_student=base64_decode($ann2->getElementsByTagName('percent_total_checked_student')->item(0)->nodeValue);
		
		echo "<tr align='center' bgcolor='#76CEEB'><td></td><td>$total_student</td><td>$total_checked_student</td><td>$total_nocheckT</td><td bgcolor='#FE2E2E'>$total_H6</td><td bgcolor='#F3F781'>$total_H5</td><td bgcolor='#81F7F3'>$total_H4</td><td bgcolor='#81F781'>$total_H3</td><td bgcolor='#F3F781'>$total_H2</td><td bgcolor='#FE2E2E'>$total_H1</td><td>$total_sum_gum_good</td><td>$total_sum_gum_no</td><td>$total_sum_tooth_good</td><td>$total_sum_tooth_no</td><td>$total_sum_iodine_good</td><td>$total_sum_iodine_no</td><td>$percent_total_checked_student</td></tr>";
		}
echo "</table>";
echo "<div align='center'><b>หมายเหตุ</b> สุขภาพดี หมายถึง ไม่ผอม ไม่อ้วน ฟันไม่ผุ สุขภาพเหงือกดี และไอโอดีนปกติ</div>";
}
else{
echo "<div align='center'><font color='#FF0000'><b>ไม่สามารถเรียกข้อมูลได้</b></div>";
}

${this.title}

Code Editor : livesearch_health1.php