| 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[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'>โรงเรียนกันทรลักษ์วิทยา หลักสูตรการศึกษาขั้นพื้นฐาน พุทธศักราช 2551</font></center>
<center>ระดับชั้น ม.<? echo $_GET[id]; ?> ประจำปีการศึกษา <? echo "$xsc_years"; ?>
<?
$crsql="SELECT count(Username) FROM `klw`
WHERE cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$cllass1=$dcrd[0];
$crsql="SELECT count(v2) FROM `klw`
WHERE v2 ='1' and cllass='$_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[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[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/$cllass1)*100;
$p12=($com12/$cllass1)*100;
$p13=($com13/$cllass1)*100;
?>
<?
$crsql="SELECT count(v3) FROM `klw`
WHERE v3 ='1' and cllass='$_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[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[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/$cllass1)*100;
$p22=($com22/$cllass1)*100;
$p23=($com23/$cllass1)*100;
?>
<?
$crsql="SELECT count(v4) FROM `klw`
WHERE v4 ='1' and cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com31=$dcrd[0];
$crsql="SELECT count(v4) FROM `klw`
WHERE v4 ='2' and cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com32=$dcrd[0];
$crsql="SELECT count(v4) FROM `klw`
WHERE v4 ='3' and cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com33=$dcrd[0];
$com3toal=$com31+$com32+$com33;
$p31=($com31/$cllass1)*100;
$p32=($com32/$cllass1)*100;
$p33=($com33/$cllass1)*100;
?>
<?
$crsql="SELECT count(v5) FROM `klw`
WHERE v5 ='1' and cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com41=$dcrd[0];
$crsql="SELECT count(v5) FROM `klw`
WHERE v5 ='2' and cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com42=$dcrd[0];
$crsql="SELECT count(v5) FROM `klw`
WHERE v5 ='3' and cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com43=$dcrd[0];
$com4toal=$com41+$com42+$com43;
$p41=($com41/$cllass1)*100;
$p42=($com42/$cllass1)*100;
$p43=($com43/$cllass1)*100;
?>
<?
$crsql="SELECT count(v6) FROM `klw`
WHERE v6 ='1' and cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com51=$dcrd[0];
$crsql="SELECT count(v6) FROM `klw`
WHERE v6 ='2' and cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com52=$dcrd[0];
$crsql="SELECT count(v6) FROM `klw`
WHERE v6 ='3' and cllass='$_GET[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com53=$dcrd[0];
$com5toal=$com51+$com52+$com53;
$crsql="SELECT count(v7) FROM `klw`
WHERE v7 ='1' and cllass='$_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[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[id]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$com73=$dcrd[0];
$p51=($com51/$cllass1)*100;
$p52=($com52/$cllass1)*100;
$p53=($com53/$cllass1)*100;
$statp71=($com71/$cllass1)*100;
$statp72=($com21/$cllass1)*100;
$statp73=($com71/$cllass1)*100;
?>
</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">นร.</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 "$cllass1"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com11"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p11, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com12"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p12, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com13"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p13, 2);?></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 "$cllass1"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com21"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p21, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com22"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p22, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com23"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p23, 2);?></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 "$cllass1"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com31"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p31, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com32"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p32, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com33"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p33, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com3toal"; ?></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 "$cllass1"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com41"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p41, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com42"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p42, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com43"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p43, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com4toal"; ?></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 "$cllass1"; ?></div></th>
<th width="10"> <div align="center"><? echo "$com51"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p51, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com52"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p52, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com53"; ?></div></th>
<th width="10"> <div align="center"><? echo number_format($p53, 2);?></div></th>
<th width="10"> <div align="center"><? echo "$com5toal"; ?></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 number_format($statp71, 2);?></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"></div><? echo number_format($statp72, 2);?></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 number_format($statp73, 2);?></div></th>
</tr>
</table>
<table>
<br>
<br>
หมายเหตุ 1=ผ่าน 2=ดี 3=ดีเยียม</table>
</body>
</html>