| 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/ |
Upload File : |
<?
require_once "config/confiteacher.inc.php";
//require_once "head.php";
$teach=$objResult["teachcode"];
?>
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=tis-620">
<title>ฝ่ายบริหารงานวิชาการ</title>
<script language="JavaScript" type="text/JavaScript">
function check_key_number() {
use_key=event.keyCode
if (use_key != 13 && (use_key < 48) || (use_key > 57)) {
event.returnValue = false;
}
}
</script>
</head>
<body onLoad="window.print()">
<?
require_once "config/connectdb.php";
$year=date(" Y ")+542;
//*** Update Condition ***//
if($_GET["Action"] == "Save")
{
for($i=1;$i<=$_POST["hdnLine"];$i++)
{
$strSQL = "UPDATE klw SET ";
$strSQL .="v2 = '".$_POST["v2$i"]."' ";
$strSQL .=",v3 = '".$_POST["v3$i"]."' ";
$strSQL .=",v4 = '".$_POST["v4$i"]."' ";
$strSQL .=",v5 = '".$_POST["v5$i"]."' ";
$strSQL .=",v6 = '".$_POST["v6$i"]."' ";
$strSQL .=",comteach =$teach ";
$strSQL .="WHERE UserID = '".$_POST["hdnid$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$sql2="SELECT years FROM config";
$result2 = mysql_query($sql2);
while (list($years) = mysql_fetch_row($result2)) {
$xsc_years = $years;
$strSQL = "SELECT * FROM klw where cllass='$_GET[cllass]' and room= '$_GET[id]' order by ordinal+1 asc";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$i = 1;
}
?>
<table width="773" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
</td>
<td width="575"><table width="100%" border="0" cellspacing="1" cellpadding="1">
</table></td>
</tr>
</table>
<form name="frmMain" method="post" action="">
<table width="100%" border="0" bgcolor="#999999">
<center><font size='3' color='red'>การประเมินสมรรถนะสำคัญของผู้เรียน</font></center>
<center><font size='3' color='red'>โรงเรียนกันทรลักษ์วิทยา ปีการศึกษา <? echo "$xsc_years"; ?></font></center>
<center>ระดับชั้นม.<? echo $_GET[cllass]; ?> ครู.<?=$objResult["name"];?> <?=$objResult["lastname"];?>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">#</div></th>
<th width="10"> <div align="center">รหัสนักเรียน</div></th>
<th width="120"> <div align="center">ชื่อ-นามสกุล</div></th>
<th width="10"> <div align="center">ห้อง/เลขที่</div></th>
<th width="10"> <div align="center">สื่อสาร
</div></th>
<th width="10"> <div align="center">การคิด</div></th>
<th width="10"> <div align="center">การแก้ปัญหา</div></th>
<th width="10"> <div align="center">ทักษะชีวิต</div></th>
<th width="10"> <div align="center">การใช้เทคโนโลยี</div></th>
<th width="10"> <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;
?>
<?
$crsql="SELECT count(v2) FROM `klw`
WHERE v2 ='1' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com11=$dcrd[0];
$crsql="SELECT count(v2) FROM `klw`
WHERE v2 ='2' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com12=$dcrd[0];
$crsql="SELECT count(v2) FROM `klw`
WHERE v2 ='3' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com13=$dcrd[0];
$com1toal=$com11+$com12+$com13;
$p11=($com11/$com1toal)*100;
$p12=($com12/$com1toal)*100;
$p13=($com13/$com1toal)*100;
?>
<?
$crsql="SELECT count(v3) FROM `klw`
WHERE v3 ='1' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com21=$dcrd[0];
$crsql="SELECT count(v3) FROM `klw`
WHERE v3 ='2' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com22=$dcrd[0];
$crsql="SELECT count(v3) FROM `klw`
WHERE v3 ='3' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com23=$dcrd[0];
$com2toal=$com21+$com22+$com23;
$p21=($com21/$com2toal)*100;
$p22=($com22/$com2toal)*100;
$p23=($com23/$com2toal)*100;
?>
<?
$crsql="SELECT count(v4) FROM `klw`
WHERE v4 ='1' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com41=$dcrd[0];
$crsql="SELECT count(v4) FROM `klw`
WHERE v4 ='2' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com42=$dcrd[0];
$crsql="SELECT count(v4) FROM `klw`
WHERE v4 ='3' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com43=$dcrd[0];
$com4toal=$com41+$com42+$com43;
$p31=($com41/$com4toal)*100;
$p32=($com42/$com4toal)*100;
$p33=($com43/$com4toal)*100;
?>
<?
$crsql="SELECT count(v5) FROM `klw`
WHERE v5 ='1' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com51=$dcrd[0];
$crsql="SELECT count(v5) FROM `klw`
WHERE v5 ='2' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com52=$dcrd[0];
$crsql="SELECT count(v5) FROM `klw`
WHERE v5 ='3' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com53=$dcrd[0];
$com5toal=$com51+$com52+$com53;
$p41=($com51/$com5toal)*100;
$p42=($com52/$com5toal)*100;
$p43=($com53/$com5toal)*100;
?>
<?
$crsql="SELECT count(v6) FROM `klw`
WHERE v6 ='1' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com61=$dcrd[0];
$crsql="SELECT count(v6) FROM `klw`
WHERE v6 ='2' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com62=$dcrd[0];
$crsql="SELECT count(v6) FROM `klw`
WHERE v6 ='3' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com63=$dcrd[0];
$com6toal=$com61+$com62+$com63;
$p51=($com61/$com6toal)*100;
$p52=($com62/$com6toal)*100;
$p53=($com63/$com6toal)*100;
$crsql="SELECT count(v7) FROM `klw`
WHERE v7 ='1' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com71=$dcrd[0];
$crsql="SELECT count(v7) FROM `klw`
WHERE v7 ='2' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com72=$dcrd[0];
$crsql="SELECT count(v7) FROM `klw`
WHERE v7 ='3' and cllass='$_GET[cllass]' and room='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com73=$dcrd[0];
?>
<?
$v1=$objResult["v2"];
$v2=$objResult["v3"];
$v3=$objResult["v4"];
$v4=$objResult["v5"];
$v5=$objResult["v6"];
$stat=$v1+$v2+$v3+$v4+$v5;
$stat1=$stat/5;
$statp1=($com71/$com1toal)*100;
$statp2=($com72/$com1toal)*100;
$statp3=($com73/$com1toal)*100;
?>
<tr bgcolor="<?=$bg?>">
<td><?=$i?></td>
<td><?=$objResult["Username"];?></td>
<td><?=$objResult["prefix"];?><?=$objResult["Name"];?> <?=$objResult["surname"];?></td>
<td><?=$objResult["room"];?>/ <?=$objResult["ordinal"];?></td>
<td><?=$objResult["v2"];?></td>
<td><?=$objResult["v3"];?></td>
<td><?=$objResult["v4"];?></td>
<td><?=$objResult["v5"];?></td>
<td><?=$objResult["v6"];?></td>
<td>
<?php
echo round($stat1);
?>
</td>
</tr>
<?
$i = $i;
}
?>
</table>
</form>
</tr>
<table width="100%" border="0" bgcolor="#999999">
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">#</div></th>
<th width="10"> <div align="center">ระดับคุณภาพ</div></th>
<th width="10"> <div align="center">1</div></th>
<th width="10"> <div align="center">%</div></th>
<th width="10"> <div align="center">2</div></th>
<th width="10"> <div align="center">%</div></th>
<th width="10"> <div align="center">3</div></th>
<th width="10"> <div align="center">%</div></th>
<th width="10"> <div align="center">รวม</div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">1</div></th>
<th width="120"> <div align="left">ความสามารถในการสื่อสาร</div></th>
<th width="10"> <div align="center"><? echo "$com11"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p11"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com12"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p12"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com13"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p13"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com1toal"; ?></div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">2</div></th>
<th width="120"> <div align="left">ความสามารถในการคิด</div></th>
<th width="10"> <div align="center"><? echo "$com21"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p21"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com22"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p22"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com23"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p23"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com2toal"; ?></div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">3</div></th>
<th width="120"> <div align="left">ความสามารถในการแก้ปัญหา</div></th>
<th width="10"> <div align="center"><? echo "$com41"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p31"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com42"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p32"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com43"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p33"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com4toal"; ?></div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">4</div></th>
<th width="120"> <div align="left">ความสามารถในการใช้ทักษะชีวิต</div></th>
<th width="10"> <div align="center"><? echo "$com51"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p41"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com52"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p42"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com53"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p43"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com5toal"; ?></div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">5</div></th>
<th width="120"> <div align="left">ความสามารถในการใช้เทคโนโลยี</div></th>
<th width="10"> <div align="center"><? echo "$com61"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p51"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com62"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p52"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com63"; ?></div></th>
<th width="10"> <div align="center"><? echo "$p53"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com6toal"; ?></div></th>
</tr>
</table>
<table width="100%" border="0" bgcolor="#999999">
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">#</div></th>
<th width="10"> <div align="center">สรุประดับคุณภาพ</div></th>
<th width="10"> <div align="center">จำนวนนร.</div></th>
<th width="10"> <div align="center">%</div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">1</div></th>
<th width="120"> <div align="left">ระดับ 1</div></th>
<th width="10"> <div align="center"><? echo "$com71"; ?></div></th>
<th width="10"> <div align="center"><? echo "$statp1"; ?></div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">2</div></th>
<th width="120"> <div align="left">ระดับ2</div></th>
<th width="10"> <div align="center"><? echo "$com72"; ?></div></th>
<th width="10"> <div align="center"><? echo "$statp2"; ?></div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">3</div></th>
<th width="120"> <div align="left">ระดับ3</div></th>
<th width="10"> <div align="center"><? echo "$com73"; ?></div></th>
<th width="10"> <div align="center"><? echo "$statp3"; ?></div></th>
</tr>
</table>
<table>
<br>
<br>
หมายเหตุ 1=ผ่าน 2=ดี 3=ดีเยียม</table>
</body>
</html>