| 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/data/ |
Upload File : |
<?
require_once "../config/confiteacher.inc.php";
$teach=$objResult["teachcode"];
$grupsarat=$objResult["grupsara"];
?>
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=tis-620">
<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 transcripsactivi SET ";
$strSQL .="gradeac = '".$_POST["txtgradeac$i"]."' ";
$strSQL .="WHERE idacti = '".$_POST["hdnid$i"]."' ";
$objQuery = mysql_query($strSQL);
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$sql2="SELECT years,termx FROM config";
$result2 = mysql_query($sql2);
while (list($years,$termx) = mysql_fetch_row($result2)) {
$years1 = $years;
$termx1 = $termx;
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$total=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad=4 and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$g4=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad=3.5 and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$g35=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad=3 and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$g3=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad=2.5 and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$g25=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad=2 and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$g2=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad=1.5 and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$g15=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad=1 and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$g1=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad='0' and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$g0=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad='ร' and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$gi=$dcrd[0];
$crsql="SELECT count( IDstudent ) FROM transcripts join klw on klw.Username=transcripts.IDstudent where code='$_GET[id]' and teach='$teach' and room='$_GET[room]' and grad='มส' and xyy='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$gms=$dcrd[0];
/////ร้อยละ
$p4=($g4/$total)*100;
$p35=($g35/$total)*100;
$p3=($g3/$total)*100;
$p25=($g25/$total)*100;
$p2=($g2/$total)*100;
$p15=($g15/$total)*100;
$p1=($g1/$total)*100;
$p0=($g0/$total)*100;
$pi=($gi/$total)*100;
$pms=($gms/$total)*100;
$crsql="SELECT ( codcod ) FROM registeacher where codeteach='$_GET[id]' and registeach='$teach' and yearsxx='$_GET[xyy]' and codcod!=''";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$namecode=$dcrd[0];
$crsql="SELECT ( roomteach ) FROM registeacher where codeteach='$_GET[id]' and registeach='$teach' and yearsxx='$_GET[xyy]' and codcod!=''";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$class=$dcrd[0];
$crsql="SELECT ( kab ) FROM registeacher where codeteach='$_GET[id]' and registeach='$teach' and yearsxx='$_GET[xyy]' and kab!=''";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$kab=$dcrd[0];
$crsql="SELECT (unit) FROM registeacher where codeteach='$_GET[id]' and registeach='$teach' and yearsxx='$_GET[xyy]' and unit!=''";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$unit=$dcrd[0];
$crsql="SELECT ( name) FROM teacher where teachcode='$teach'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$namet=$dcrd[0];
$crsql="SELECT ( lastname) FROM teacher where teachcode='$teach'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$surnamet=$dcrd[0];
$crsql="SELECT (sara) FROM registeacher where codeteach='$_GET[id]' and registeach='$teach' and yearsxx='$_GET[xyy]' and sara!=''";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$saracode=$dcrd[0];
$crsql="SELECT ( sara_name) FROM sara where sara_id='$saracode'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$namesara=$dcrd[0];
//////////////
$crsql="SELECT (sara) FROM registeacher where codeteach='$_GET[id]' and registeach='$teach' and yearsxx='$_GET[xyy]'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$saracodex=$dcrd[0];
$crsql="SELECT (sara_name) FROM sara where sara_id='$grupsarat'";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$namesarateach=$dcrd[0];
////////////ผ่าน ไม่ผ่าน
$pass=$g4+$g35+$g3+$g25+$g2+$g15+$g1;
$nonpass=$g0+$gi+$gms;
$perpass=($pass/$total)*100;
$pernonpass=($nonpass/$total)*100;
$strSQL = "SELECT * FROM transcripts group by IDstudent";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$i = 1;
}
?>
<form name="frmMain" method="post" action="">
<table width="100%" border="0" bgcolor="#999999">
<center><img src="Card_Logo.jpg" width="100" height="100"></center>
<center><font size=+2>แบบบันทึกผลการเรียน</font></center>
<center><font size=+2>โรงเรียนกันทรลักษ์วิทยา</font></center>
<center><font size=+2>อำเภอกันทรลักษ์ จังหวัดศรีสะเกษ</font></center>
<center><font size=+2>ภาคเรียนที่ <? echo $_GET[term]; ?> ปีการศึกษา <? echo $_GET[xyy]; ?></font></center>
<br>
<center><font size=+1>รหัสวิชา <? echo $_GET[id]; ?>
รายวิชา...<?echo $_GET[cod2];?>.. </font></center>
<br><center>
<font size=+1>กลุ่มสาระการเรียนรู้ <? if($saracodex < 1)
{
echo "$namesarateach";
}
else if($saracodex >= 1)
{
echo "$namesara";
}
?>
</center>
</font>
<br><center>
<font size=+1>ระดับชั้น ม.<? echo $class; ?>../..<? echo $_GET[room]; ?> .... เวลาเรียน <? echo $kab; ?>.... คาบ/สัปดาห์ จำนวนหน่วยกิต ...<? echo $unit; ?>..</font></center>
<br><center>
<font size=+1>ครูประจำวิชา ครู<? echo $namet; ?> <? echo $surnamet; ?></font></center>
<br>
<table width="483" height="215" border="4" align="center">
<tr>
<td width="27" rowspan="2" align="center">จำนวนนักเรียนทั้งหมด</td>
<td colspan="8" align="center">สรุปผลการเรียน</td>
<td colspan="2" align="center" rowspan="2">จำนวนนักเรียนที่มีผลการเรียน</td>
</tr>
<tr>
<td colspan="8" align="center">จำนวนนักเรียนที่มีระดับผลการเรียน</td>
</tr>
<tr>
<td rowspan="2"align="center"><? echo "$total"; ?></td>
<td width="30" align="center">4</td>
<td width="30" align="center">3.5</td>
<td width="30" align="center">3</td>
<td width="30" align="center">2.5</td>
<td width="30" align="center">2</td>
<td width="30" align="center">1.5</td>
<td width="30" align="center">1</td>
<td width="30" align="center">0</td>
<td width="50" align="center">ร</td>
<td width="50" align="center">มส</td>
</tr>
<tr>
<td align="center"><? echo "$g4"; ?></td>
<td align="center"><? echo "$g35"; ?></td>
<td align="center"><? echo "$g3"; ?></td>
<td align="center"><? echo "$g25"; ?></td>
<td align="center"><? echo "$g2"; ?></td>
<td align="center"><? echo "$g15"; ?></td>
<td align="center"><? echo "$g1"; ?></td>
<td align="center"><? echo "$g0"; ?></td>
<td align="center"><? echo "$gi"; ?></td>
<td align="center"><? echo "$gms"; ?></td>
</tr>
<tr>
<td>%</td>
<td align="center"><? echo number_format($p4, 2, '.', ''); ?></td>
<td align="center"><? echo number_format($p35, 2, '.', ''); ?></td>
<td align="center"><? echo number_format($p3, 2, '.', ''); ?></td>
<td align="center"><? echo number_format($p25, 2, '.', ''); ?></td>
<td align="center"><? echo number_format($p2, 2, '.', ''); ?></td>
<td align="center"><? echo number_format($p15, 2, '.', ''); ?></td>
<td align="center"><? echo number_format($p1, 2, '.', ''); ?></td>
<td align="center"><? echo number_format($p0, 2, '.', ''); ?></td>
<td align="center"><? echo number_format($pi, 2, '.', ''); ?></td>
<td align="center"><? echo number_format($pms, 2, '.', ''); ?></td>
</tr>
<tr>
<td colspan="11" align="center">ผ่าน <? echo "$pass"; ?> <? echo number_format($perpass, 2, '.', ''); ?>% ไม่ผ่าน <? echo "$nonpass"; ?> <? echo number_format($pernonpass, 2, '.', ''); ?>%</td>
</tr>
</table>
<table>
<br>
<center><font size=+1>การตัดสินผลการเรียน</font></center>
<br>
<font size=+1> ลงชื่อ......................................................ครูผู้สอน</font>
<br>
<br>
<font size=+1> ลงชื่อ......................................................หัวหน้ากลุ่มสาระ</font>
<br>
<br>
<center><font size=+1>การพิจารณาเห็นชอบ</font></center>
<br>
<br>
<font size=+1> ลงชื่อ......................................................รองผู้อำนวยการโรงเรียน</font>
<br>
<br>
<center><font size=+1>การอนุมัติผลการเรียน</font></center>
<br>
<br>
<font size=+1> ลงชื่อ......................................................ผู้อำนวยการโรงเรียน</font>
<br>
<br>
<font size=+1>.................../............./.................</font>
</table>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
if($bg == "#EEEEEE") { //ส่วนของการ สลับสี
$bg = "#FFFFFF";
} else {
$bg = "#EEEEEE";
}
$i = $i + 1;
?>
</tr>
<?
$i = $i;
}
?>
</table>
</form>
</body>
</html>