| Server IP : 61.19.30.66 / Your IP : 216.73.216.59 Web Server : Apache/2.2.22 (Ubuntu) System : Linux klw 3.11.0-15-generic #25~precise1-Ubuntu SMP Thu Jan 30 17:39:31 UTC 2014 x86_64 User : www-data ( 33) PHP Version : 5.3.10-1ubuntu3.48 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : OFF Directory : /var/www/gpa/homeroom/ |
Upload File : |
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=tis-620">
<title>ฝ่ายบริหารงานวิชาการ</title>
</head>
<body onload="window.print()">
<?
require_once "../config/confiteacher.inc.php";
$ttt=$objResult["teachcode"];
$namet=$objResult["name"];
$lastname=$objResult["lastname"];
$sql2="SELECT namesc,tumbolsc,amps,dissc,years,termx FROM config";
mysql_query("SET character_set_results=tis620");//ตั้งค่าการดึงข้อมูลออกมาให้เป็น tis620
mysql_query("SET character_set_client=tis620");//ตั้งค่าการส่งข้อมุลลงฐานข้อมูลออกมาให้ เป็น tis620
mysql_query("SET character_set_connection=tis620");//ตั้งค่าการติดต่อฐานข้อมูลให้เป็น ti
$result2 = mysql_query($sql2);
while (list($namesc,$tumbolsc,$amps,$dissc,$years,$termx) = mysql_fetch_row($result2)) {
$namesc_sc = $namesc;
$xsc_tumbolsc = $tumbolsc;
$xsc_disc = $dissc;
$xsc_amps = $amps;
$xsc_years = $years;
$xsc_termx = $termx;
}
$crsql="SELECT count(DISTINCT room) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and teach='$ttt' and xyy='$_GET[xyy]' and room>0";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$countroom=$dcrd[0];
?>
<?
$year=date(" Y ")+543;
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
$strSQL = "UPDATE transcripts SET ";
$strSQL .="total = '".$_POST["txttotal$i"]."' ";
$strSQL .="WHERE id = '".$_POST["hdnid$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM transcripts JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and teach='$ttt' and xyy='$_GET[xyy]' and room>0 group by room order by room+1 asc,ordinal+1 asc";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$i = 1;
?>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
<center><img src="images/Logo.jpg" width="80" heigth="80"></center>
<center>แบบสรุปผลการเรียน</center>
</table></td>
<table width="100%" border="0">
<tr>
<td><div align="right" class="style1">โรงเรียนกันทรลักษ์วิยา</div></td>
</tr>
<tr>
<td> <div align="right" class="style1">วันที่.................เดือน.......................พ.ศ.......................</div></td>
</tr>
<tr>
<td><span class="style1">เรื่อง รายงานสรุปผลการเรียน</span></td>
</tr>
<tr>
<td><span class="style1">เรียน ผู้อำนวยการโรงเรียนกันทรลักษ์วิทยา</span></td>
</tr>
<tr>
<td><span class="style1"> ตามที่โรงเรียนได้อนุมัติให้จัดการเรียนการสอนวิชา.......................................................รหัสวิชา <? echo $_GET[id]; ?></span></td>
</tr>
<tr>
<td><span class="style1">จำนวน <? echo "$countroom"; ?> ห้องเรียน ประจำภาคเรียนที่ <? echo "$xsc_termx"; ?> ปีการศึกษา <? echo "$xsc_years "; ?> กลุ่มสาระการเรียนรู้..................................</span></td>
</tr>
<tr>
<td><span class="style1">ได้จัดกิจกรรมการเรียนการสอนและประเมินผลการเรียนเรียบร้อยแล้ว ดังนี้</span></td>
</tr>
</table>
<?
$sql2="SELECT namesc,tumbolsc,amps,dissc,termx,years FROM config";
mysql_query("SET character_set_results=tis620");//ตั้งค่าการดึงข้อมูลออกมาให้เป็น tis620
mysql_query("SET character_set_client=tis620");//ตั้งค่าการส่งข้อมุลลงฐานข้อมูลออกมาให้ เป็น tis620
mysql_query("SET character_set_connection=tis620");//ตั้งค่าการติดต่อฐานข้อมูลให้เป็น ti
$result2 = mysql_query($sql2);
while (list($namesc,$tumbolsc,$amps,$dissc,$termx,$years) = mysql_fetch_row($result2)) {
$xsc_Name = $namesc;
$xsc_tumbolsc = $tumbolsc;
$xsc_disc = $dissc;
$xsc_amps = $amps;
$xsc_years = $years;
$term = $termx;
}
?>
</tr>
</table>
<table width="100%" border="0" bgcolor="#999999">
<tr bgcolor="#ffffff">
<th width="100" colspan="12"> <div align="center">ผลการเรียน</div></th>
</tr>
<tr bgcolor="#ffffff">
<th width="100"> <div align="center">ห้อง</div></th>
<th width="100"> <div align="center">4</div></th>
<th width="100"> <div align="center">3.5</div></th>
<th width="100"> <div align="center">3</div></th>
<th width="100"> <div align="center">2.5</div></th>
<th width="100"> <div align="center">2</div></th>
<th width="100"> <div align="center">1.5</div></th>
<th width="100"> <div align="center">1</div></th>
<th width="100"> <div align="center">0</div></th>
<th width="100"> <div align="center">ร</div></th>
<th width="100"> <div align="center">มส</div></th>
<th width="100"> <div align="center">รวม</div></th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
if($bg == "#FFFFFF") { //ส่วนของการ สลับสี
$bg = "#FFFFFF";
} else {
$bg = "#FFFFFF";
}
$i = $i + 1;
$prefix=$objResult["prefix"];
$surname=$objResult["surname"];
$room=$objResult["room"];
$final2=$objResult["final2"];
$dayin=$objResult["dayin"];
$namete=$objResult["name"];
$nametl=$objResult["lastname"];
$nametp=$objResult["Prefix"];
$cllass=$objResult["cllass"];
$idgrupin=$objResult["idgrupin"];
$mid=$objResult["midterm"];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad=4";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$grade4=$dcrd[0];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad=3.5";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$grade35=$dcrd[0];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad=3";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$grade3=$dcrd[0];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad=2.5";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$grade25=$dcrd[0];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad=2";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$grade2=$dcrd[0];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad=1.5";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$grade15=$dcrd[0];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad=1";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$grade1=$dcrd[0];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad='0'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$grade0=$dcrd[0];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad='ร'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$gradei=$dcrd[0];
$crsql="SELECT count(IDstudent) FROM `transcripts` JOIN klw ON klw.Username=transcripts.IDstudent WHERE code = '$_GET[id]' and room = '$room' and teach='$ttt' and xyy='$_GET[xyy]' and grad='มส'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$gradems=$dcrd[0];
$g4all+=$grade4;
$g35all+=$grade35;
$g3all+=$grade3;
$g25all+=$grade25;
$g2all+=$grade2;
$g15all+=$grade15;
$g1all+=$grade1;
$g0all+=$grade0;
$giall+=$gradei;
$gmsall+=$gradems;
$sumall=$grade4+$grade35+$grade3+$grade25+$grade2+$grade15+$grade1+$grade0+$gradei+$gradems;
$gradeall=$g4all+$g35all+$g3all+$g25all+$g2all+$g15all+$g1all+$g0all+$giall+$gmsall;
$gpax=(($g4all*4)+($g35all*3.5)+($g3all*3)+($g25all*2.5)+($g2all*2)+($g15all*1.5)+($g1all*1))/$gradeall;
$per4=($g4all/$gradeall)*100;
$per35=($g35all/$gradeall)*100;
$per3=($g3all/$gradeall)*100;
$per25=($g25all/$gradeall)*100;
$per2=($g2all/$gradeall)*100;
$per15=($g15all/$gradeall)*100;
$per1=($g1all/$gradeall)*100;
$per0=($g0all/$gradeall)*100;
$peri=($giall/$gradeall)*100;
$perms=($gmsall/$gradeall)*100;
$grade3over=$per4+$per35+$per3;
$gradenonpass=$perms+$peri+$per0;
$gradpass=$g4all+$g35all+$g3all+$g25all+$g2all+$g15all+$g1all;
$sumpass=$g0all+$giall+$gmsall;
?>
<tr bgcolor="<?=$bg?>">
<td><font size='2'><div align="center"><? echo "$room"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$grade4"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$grade35"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$grade3"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$grade25"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$grade2"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$grade15"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$grade1"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$grade0"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$gradei"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$gradems"; ?></font></td>
<td><div align="center"><font size='2'><? echo "$sumall"; ?></font></td>
</tr>
<?
$i = $i;
}
?>
</table>
<table width="100%" border="0" bgcolor="#999999">
<tr bgcolor="#ffffff">
<th width="100"> <div align="center">รวม</div></th>
<th width="100"><font size='2'><? echo "$g4all"; ?></font></th>
<th width="100"><font size='2'><? echo "$g35all"; ?></font></th>
<th width="100"><font size='2'><? echo "$g3all"; ?></font></th>
<th width="100"><font size='2'><? echo "$g25all"; ?></font></th>
<th width="100"><font size='2'><? echo "$g2all"; ?></font></th>
<th width="100"><font size='2'><? echo "$g15all"; ?></font></th>
<th width="100"><font size='2'><? echo "$g1all"; ?></font></th>
<th width="100"><font size='2'><? echo "$g0all"; ?></font></th>
<th width="100"><font size='2'><? echo "$giall"; ?></font></th>
<th width="100"><font size='2'><? echo "$gmsall"; ?></font></th>
<th width="100"><? echo "$gradeall"; ?></th>
</tr>
</table>
<table width="100%" border="0" bgcolor="#999999">
<tr bgcolor="#ffffff">
<th width="100"> <div align="center">%</div></th>
<th width="100"><font size='2'><? echo number_format($per4, 2, '.', ''); ?></font></th>
<th width="100"><font size='2'><? echo number_format($per35, 2, '.', ''); ?></font></th>
<th width="100"><font size='2'><? echo number_format($per3, 2, '.', ''); ?></font></th>
<th width="100"><font size='2'><? echo number_format($per25, 2, '.', ''); ?></font></th>
<th width="100"><font size='2'><? echo number_format($per2, 2, '.', ''); ?></font></th>
<th width="100"><font size='2'><? echo number_format($per15, 2, '.', ''); ?></font></th>
<th width="100"><font size='2'><? echo number_format($per1, 2, '.', ''); ?></font></th>
<th width="100"><font size='2'><? echo number_format($per0, 2, '.', ''); ?></font></th>
<th width="100"><font size='2'><? echo number_format($peri, 2, '.', ''); ?></font></th>
<th width="100"><font size='2'><? echo number_format($perms, 2, '.', ''); ?></font></th>
<th width="100"></th>
</tr>
</table>
<body>
<table width="100%" height="153" border="0" bgcolor="#999999">
<tr bgcolor="#999999">
<td width="32%" rowspan="2" bgcolor="#FFFFFF"><div align="center" class="style1">รายการ</div></td>
<td colspan="3" bgcolor="#FFFFFF"><div align="center" class="style1">ผลการประเมิน</div></td>
<td bgcolor="#FFFFFF"><span class="style1"></span></td>
</tr>
<tr>
<td width="8%" bgcolor="#FFFFFF"><div align="center" class="style1">ค่าตัวเลข</div></td>
<td bgcolor="#FFFFFF"><div align="center" class="style1">ผ่าน</div></td>
<td bgcolor="#FFFFFF"><div align="center" class="style1">ไม่ผ่าน</div></td>
<td width="38%" bgcolor="#FFFFFF"><div align="center" class="style1">เกณฑ์การผ่าน</div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="style1">ผลการเรียนเฉลี่ย (x)</span></td>
<td bgcolor="#FFFFFF"><span class="style1"><? echo number_format($gpax, 2, '.', ''); ?></span></td>
<td width="11%" bgcolor="#FFFFFF"><span class="style1">
<center>
<? if($gpax < 2)
{
echo "";
}
else if($gpax >= 2)
{
echo "ผ่าน";
}
?></center>
</span>
</td>
<td width="11%" bgcolor="#FFFFFF"><span class="style1">
<? if($gpax < 2)
{
echo "ไม่ผ่าน";
}
else if($gpax >= 2)
{
echo "";
}
?>
</span>
</td>
<td bgcolor="#FFFFFF"><span class="style1">x ตั้งแต่ 2.00 ขี้นไป</span></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="style1">ผลการเรียนตั้งแต่ 3 ขึ้นไป ร้อยละ</span></td>
<td bgcolor="#FFFFFF"><span class="style1"><? echo number_format($grade3over, 2, '.', ''); ?></span></td>
<td bgcolor="#FFFFFF"><span class="style1"><center>
<? if($grade3over < 75)
{
echo "";
}
else if($grade3over >= 75)
{
echo "ผ่าน";
}
?></center></span></td>
<td bgcolor="#FFFFFF"><span class="style1"><? if($grade3over < 75)
{
echo "ไม่ผ่าน";
}
else if($grade3over >= 75)
{
echo "";
}
?></span></td>
<td bgcolor="#FFFFFF"><span class="style1">ร้อยละ 75 ขี้นไป</span></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="style1">ผลการเรียนที่มี 0 ร มส ร้อยละ</span></td>
<td bgcolor="#FFFFFF"><span class="style1"><? echo number_format($gradenonpass, 2, '.', ''); ?></span></td>
<td bgcolor="#FFFFFF"><span class="style1">
<center>
<? if($gradenonpass < 5)
{
echo "ผ่าน";
}
else if($gradenonpass >= 5)
{
echo "";
}
?></span></td>
<td bgcolor="#FFFFFF"><span class="style1"><? if($gradenonpass < 5)
{
echo "";
}
else if($gradenonpass >= 5)
{
echo "ไม่ผ่าน";
}
?></center></span></td>
<td bgcolor="#FFFFFF"><span class="style1">ไม่เกินร้อยละ 5</span></td>
</tr>
</table>
<br />
<table width="100%" height="153" border="0" bgcolor="#999999">
<tr bgcolor="#999999">
<td width="19%" rowspan="2" bgcolor="#FFFFFF"><div align="center" class="style1">ครูประจำวิช่า</div></td>
<td width="16%" rowspan="2" bgcolor="#FFFFFF"><span class="style1"><div align="center">จำนวนห้อง</span></td>
<td colspan="3" bgcolor="#FFFFFF"><div align="center" class="style1">จำนวนนักเรียนทั้งหมด</div></td>
<td width="29%" rowspan="2" bgcolor="#FFFFFF"><div align="center" class="style1">ลายมือชื่อครูที่สอน</div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><div align="center" class="style1">ทั้งหมด</div></td>
<td bgcolor="#FFFFFF"><div align="center" class="style1">ผ่าน</div></td>
<td bgcolor="#FFFFFF"><div align="center" class="style1">ไม่ผ่าน</div></td>
</tr>
<tr>
<td bgcolor="#FFFFFF"><span class="style1"><div align="center"><? echo "$namet"; ?></span></td>
<td bgcolor="#FFFFFF"><span class="style1"><div align="center"><? echo "$countroom"; ?></span></td>
<td width="8%" bgcolor="#FFFFFF"><span class="style1"><div align="center"><? echo "$gradeall"; ?></span></td>
<td width="8%" bgcolor="#FFFFFF"><span class="style1"><div align="center"><? echo "$gradpass"; ?></span></td>
<td width="12%" bgcolor="#FFFFFF"><span class="style1"><div align="center"><? echo "$sumpass"; ?></span></td>
<td bgcolor="#FFFFFF"><span class="style1"></span></td>
</tr>
</table>
<table width="100%" border="0">
<tr>
<td><span class="style1">ลงชื่อ.........................................วัดผลกลุ่มสาระ</span></td>
<td><span class="style1">ลงชื่อ....................................หัวหน้ากลุ่มสาระ</span></td>
</tr>
</table>
<table width="100%" border="0">
<tr bgcolor="#666666">
<td height="124" bgcolor="#FFFFFF"><p align="center" class="style1">ความเห็นฝ่ายบริหารงานวิชาการ<br/>
<br>........................................................<br />
<br>
ลงชื่อ..................................<br />
รองผู้อำนวยการฝ่ายบริหารงานวิชาการ<br />
<br />
......../........../..........</p></td>
<td bgcolor="#FFFFFF"><p align="center" class="style1"><br>ความเห็นของผู้อำนวยการโรงเรียน<br />
<br />(..........) อนุมัติ (.........) ไม่อนุมัติ
<br>
<br>ลงชื่อ..................................<br />
ผู้อำนวยการโรงเรียนกันทรลักษ์วิทยา<br />
<br />
......../........../..........</p>
<p> </p></td>
</tr>
</table>
</body>
</html>