| 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/sent/ |
Upload File : |
<?
require_once "../config/confiteacher.inc.php";
$teach=$objResult["teachcode"];
?>
<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=tis-620">
<title>ฝ่ายบริหารงานวิชาการ</title>
</head>
<style type="text/css">
body{
font-size:12px;
}
.textAlignVer{
display:block;
filter: flipv fliph;
-webkit-transform: rotate(-80deg);
-moz-transform: rotate(-80deg);
transform: rotate(-80deg);
position:relative;
width:30px;
white-space:nowrap;
font-size:10px;
margin-bottom:10px;
}
</style>
<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 attime FROM timeout where codtime='$_GET[id]' and teachtime='$teach' order by attime DESC";
$result2 = mysql_query($sql2);
while (list($attime) = mysql_fetch_row($result2)) {
$attime1 = $attime;
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b1=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b2=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b3=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b4=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b5=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b5' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b6=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b6' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b7=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b7' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b8=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b8' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b9=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b9' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b10=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b10' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b11=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b11' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b12=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b12' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b13=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b5' and attime>'$b6' and attime>'$b7' and attime>'$b8' and attime>'$b9' and attime>'$b10' and attime>'$b11' and attime>'$b12' and attime>'$b13' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b14=$dcrd[0];
$crsql="SELECT attime FROM timeout join klw on klw.Username=timeout.idstutime where codtime='$_GET[id]' and teachtime='$teach' and attime>'$b1' and attime>'$b2' and attime>'$b3' and attime>'$b4' and attime>'$b5' and attime>'$b6' and attime>'$b7' and attime>'$b8' and attime>'$b9' and attime>'$b10' and attime>'$b11' and attime>'$b12' and attime>'$b13' and attime>'$b14' and dayin='$_GET[dayin]' group by attime order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$b15=$dcrd[0];
$strSQL = "SELECT * FROM transcriptintall JOIN klw ON
klw.Username=transcriptintall.idstin where codin='$_GET[id]' and teachin='$teach' and dayin='$_GET[dayin]' group by Username order by room+1 asc,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 width="198"><a href="regis.php"><font color="#FF0000" size="2">หน้าหลัก</font></a>
</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>วิชา <? echo $_GET[id]; ?></center>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">#</div></th>
<th width="10"> <div align="center"></div></th>
<th width="100"> <div align="center"></div></th>
<th width="10" colspan="15"> <div align="center">วันที่ DATE </div></th>
<th width="10" colspan="4"> <div align="center">6</div></th>
</tr>
<tr bgcolor="#FFFFFF">
<th width="10"> <div align="center">#</div></th>
<th width="10"><font size=1> <div align="center">รหัสนักเรียน</font></div></th>
<th width="100"><font size=1> <div align="center">ชื่อ-นามสกุล</font></div></th>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b1"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b2"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b3"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b4"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b5"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b6"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b7"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b8"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b9"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b10"; ?></span></font></div></td></span></font></div></th>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b11"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b12"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b13"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b14"; ?></span></font></div></td>
<td height="100" <div align="center"><font size=-1><span class="textAlignVer"><? echo "$b15"; ?></span></font></div></td>
<th width="10"> <div align="center"><font size=1>ป่วย</font></div></th>
<th width="10"> <div align="center"><font size=1>ลา</font></div></th>
<th width="10"> <div align="center"><font size=1>ขาด</font></div></th>
<th width="10"> <div align="center"><font size=1>รวม</font></div></th>
</tr>
<?
$i =0;
while($objResult = mysql_fetch_array($objQuery))
{
if($bg == "#EEEEEE") { //ส่วนของการ สลับสี
$bg = "#FFFFFF";
} else {
$bg = "#EEEEEE";
}
$i = $i + 1;
$scor1 =$objResult["k11"];
$scor2 =$objResult["p11"];
$scor3 =$objResult["a11"];
$uni1 =$scor1+$scor2+$scor3;
$scor4 =$objResult["k22"];
$scor5 =$objResult["p22"];
$scor6 =$objResult["a22"];
$uni2 =$scor4+$scor5+$scor6;
$scor7 =$objResult["k33"];
$scor8 =$objResult["p33"];
$scor9 =$objResult["a33"];
$uni3 =$scor7+$scor8+$scor9;
$mid =$objResult["midterm"];
$scor10 =$objResult["k44"];
$scor11 =$objResult["p44"];
$scor12 =$objResult["a44"];
$uni4 =$scor10+$scor11+$scor12;
$scor13 =$objResult["k55"];
$scor14 =$objResult["p55"];
$scor15 =$objResult["a55"];
$uni5 =$scor13+$scor14+$scor15;
$scor16 =$objResult["k66"];
$scor17 =$objResult["p66"];
$scor18 =$objResult["a66"];
$uni6 =$scor16+$scor17+$scor18;
$final=$objResult["final"];
$total=$uni1+$uni2+$uni3+$uni4+$uni5+$uni6+$mid+$final;
$sum1=$uni1+$uni2+$uni3;
$sum2=$uni4+$uni5+$uni6;
$grade=$objResult["grade2"];
$room =$objResult['room'];
$Username =$objResult['Username'];
$codtime =$objResult['codtime'];
$ordinal =$objResult['ordinal'];
$cllass =$objResult['cllass'];
$w1=5;
$w2=500;
$w3=1;
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b1' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb1=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b2' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb2=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b3' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb3=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b4' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb4=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b5' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb5=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b6' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb6=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b7' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb7=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b8' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb8=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b9' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb9=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b10' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb10=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b11' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb11=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b12' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb12=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b13' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb13=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b14' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb14=$dcrd[0];
$crsql="SELECT betime FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and attime='$b15' order by attime ASC";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$bb15=$dcrd[0];
$crsql="SELECT count(idstutime) FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and betime=1";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$numchik=$dcrd[0];
$crsql="SELECT count(idstutime) FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and betime=2";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$numchik2=$dcrd[0];
$crsql="SELECT count(idstutime) FROM timeout where codtime='$_GET[id]' and idstutime='$Username' and betime=3";
$slr=mysql_query($crsql) or die(mysql_error()."<br>".$crsql);
$dcrd = mysql_fetch_array($slr);
$numchik3=$dcrd[0];
$totalxx=$numchik+$numchik2+$numchik3;
?>
<tr bgcolor="<?=$bg?>">
<input type="hidden" name="hdnid<?=$i;?>" size="1" value="<?=$objResult["idin"];?>">
<td width="10"><?=$i?></td>
<td width="10"><font size=1><div align="right"><?=$objResult["Username"];?>
</div></font></td>
<td width="50%"><div align="left"><font size=1><?=$objResult["prefix"];?><?=$objResult["Name"];?> <?=$objResult["surname"];?></font></div></td>
<td width='$w1'><font size=1>
<? if($bb1==1)
{
echo "ป่วย";
}
else if($bb1==2)
{
echo "ลา";
}
else if($bb1==3)
{
echo "ขาด";
}
else
{
echo "";
}
?>
</font></td>
<td width="$w1"><font size=1><? if($bb2==1){ echo "ป่วย";}else if($bb2==2){echo "ลา";}else if($bb2==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb3==1){ echo "ป่วย";}else if($bb3==2){echo "ลา";}else if($bb3==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb4==1){ echo "ป่วย";}else if($bb4==2){echo "ลา";}else if($bb4==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb5==1){ echo "ป่วย";}else if($bb5==2){echo "ลา";}else if($bb5==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb6==1){ echo "ป่วย";}else if($bb6==2){echo "ลา";}else if($bb6==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb7==1){ echo "ป่วย";}else if($bb7==2){echo "ลา";}else if($bb7==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb8==1){ echo "ป่วย";}else if($bb8==2){echo "ลา";}else if($bb8==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb9==1){ echo "ป่วย";}else if($bb9==2){echo "ลา";}else if($bb9==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb10==1){ echo "ป่วย";}else if($bb10==2){echo "ลา";}else if($bb10==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb11==1){ echo "ป่วย";}else if($bb11==2){echo "ลา";}else if($bb5==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb12==1){ echo "ป่วย";}else if($bb12==2){echo "ลา";}else if($bb12==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb13==1){ echo "ป่วย";}else if($bb13==2){echo "ลา";}else if($bb13==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb14==1){ echo "ป่วย";}else if($bb14==2){echo "ลา";}else if($bb14==3){echo "ขาด";}else{
echo "";}?></font></td>
<td width="$w1"><font size=1><? if($bb15==1){ echo "ป่วย";}else if($bb15==2){echo "ลา";}else if($bb5==3){echo "ขาด";}else{
echo "";}?></font></td>
<td><font size=2><? echo "$numchik"; ?></font></td>
<td><font size=2><? echo "$numchik2"; ?></font></td>
<td><font size=2><? echo "$numchik3"; ?></font></td>
<td><font size=2><? echo "$totalxx"; ?></font></td>
</tr>
<?
$i = $i;
}
?>
</table>
</form>
</body>
</html>