| Server IP : 182.53.201.61 / Your IP : 216.73.217.175 Web Server : Apache/2.2.15 (Fedora) System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686 User : apache ( 48) PHP Version : 5.3.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/reportservice/3/ |
Upload File : |
<?php
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
?>
<?php
include("dbconfig.php");
include( "function.php" );
$yy2= date("Y")+543;
if(date("M") < 10) $yy1= $yy2-1;
else $yy1= $yy2 ;
$mm1= "10";
$dd1= "01";
$mm2 =date("m" );
$dd2= date("d");
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
?>
<html>
<head>
<title> รายงานผลการประเมิน</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<LINK href="style.css" rel=stylesheet>
<STYLE type=text/css>
a:link{color:red;text-decoration:none;font-family:ms sans serif;}
a:visited{color:pink;text-decoration:none;font-family:ms sans serif;}
a:hover{color:black;text-decoration:none;font-family:ms sans serif;}
td{font-size:10pt;font-family:ms sans serif;}
.style16 {font-size: 16pt; color: #FFFFFF; font-family: Verdana, Arial, Helvetica, sans-serif; }
.style4 {font-size: 16pt;
color: #3399FF;
}
.style5 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style6 {font-size: 16pt;
color: #FFFFFF;
}
</STYLE>
<script language="JavaScript1.2">
<!--
/*
Auto Maximize Window Script- By Nick Lowe (nicklowe@ukonline.co.uk)
*/
top.window.moveTo(0,0);
if (document.all) {
top.window.resizeTo(screen.availWidth,screen.availHeight);
}
else if (document.layersdocument.getElementById) {
if (top.window.outerHeight<screen.availHeighttop.window.outerWidth<screen.availWidth){
top.window.outerHeight = screen.availHeight;
top.window.outerWidth = screen.availWidth;
}
}
//-->
</script>
</head>
<body>
<p>
<STYLE type=text/css>
A.no_de:hover {
TEXT-DECORATION: none
}
</STYLE>
</p>
<TABLE height=47 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD style="BACKGROUND-COLOR: #f0f7ff" colSpan=2></TD>
</TR>
<TR bgColor=#c7d2e7>
<TD width="8%" height=21 bgcolor="#FFFFFF" class=thwbold><div align="center"><img src="../img/service_icon.jpg" width="102" height="111"></div></TD>
<TD width="92%" height=21 align=right vAlign=center bgColor=#FFFFFF class=thsans><A
href=""></A>
<table width="41%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"><span class="style4">เปรียบเทียบผลการประเมินของพนักงานซ่อมบำรุง</span></div></td>
</tr>
</table>
<A href=""></A> <A
href=""></A> </TD>
</TR>
<TR>
<TD style="BACKGROUND-COLOR: black" colSpan=2></TD>
</TR>
<TR>
<TD style="BACKGROUND-COLOR: #f0f8ff" colSpan=2></TD>
</TR>
<TR vAlign=center bgColor=#216289>
<TD height=20 colSpan=2 bgcolor="#00CCCC" class=thwbold><a href="index.php" target="_parent"> <span class="style5"><font color="#FFFFFF">หน้าแรก</font></span></a><span class="style5"><span class="style6"> </span></span><span class="style5"></font></span><font color="#FFFFFF"><SPAN
class=style16 id=n5>|| </span> <a href="logout.php" class="style5"><font color="#FFFFFF">Logout
ออกจากระบบ</font></a></TD>
</TD>
</TR>
<TR>
<TD style="BACKGROUND-COLOR: black; heigth: 1"
colSpan=2></TD>
</TR>
</TBODY>
</TABLE>
<form name="form1" method="post" >
<TABLE cellSpacing=0 cellPadding=3 width="98%" align=center border=0>
<TBODY>
<TR>
<TD height="126" vAlign=top><BR>
<TABLE cellSpacing=0 cellPadding=3 width="100%" border=0>
<TBODY>
<TR>
<TD class=thtahomasmall bgColor=#99FF99
height=5><div align="center"><SPAN
class=thsans2 id=n5><font color="#000000" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ระหว่างวันที่
<select name="dd1" id="select">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
เดือน
<select name="mm1" id="select6">
<option value=<? echo $mm1 ;?>><? echo th_month($mm1) ; ?></option>
<option value="01">มกราคม</option>
<option value="02">กุมภาพันธ์</option>
<option value="03">มีนาคม</option>
<option value="04">เมษายน</option>
<option value="05">พฤษภาคม</option>
<option value="06">มิถุนายน</option>
<option value="07">กรกฎาคม</option>
<option value="08">สิงหาคม</option>
<option value="09">กันยายน</option>
<option value="10">ตุลาคม</option>
<option value="11">พฤศจิกายน</option>
<option value="12">ธันวาคม</option>
</select>
พ.ศ.
<input name="yy1" type="text" id="yy1" value="<? echo trim($yy1) ;?>" size="4" maxlength="4">
- </font> <font color="#000000" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<select name="dd2" id="select7">
<option value=<? echo $dd2 ;?>><? echo $dd2 ;?></option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
เดือน
<select name="mm2" id="select8">
<option value=<? echo $mm2 ;?>><? echo th_month(date($mm2)) ; ?></option>
<option value="01">มกราคม</option>
<option value="02">กุมภาพันธ์</option>
<option value="03">มีนาคม</option>
<option value="04">เมษายน</option>
<option value="05">พฤษภาคม</option>
<option value="06">มิถุนายน</option>
<option value="07">กรกฎาคม</option>
<option value="08">สิงหาคม</option>
<option value="09">กันยายน</option>
<option value="10">ตุลาคม</option>
<option value="11">พฤศจิกายน</option>
<option value="12">ธันวาคม</option>
</select>
พ.ศ.
<input name="yy2" type="text" id="yy3" value="<? echo $yy2 ; ?>" size="4" maxlength="4">
</font><font color="#FFFFFF" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<input type="submit" name="Submit2" value="เรียกดู">
</font></SPAN></div></TD>
</TR>
<TR>
<TD height="46"
bgColor=#f0f8ff class=thtahomasmall
style="BORDER-RIGHT: #c7d2e7 1px solid; BORDER-TOP: #c7d2e7 1px solid; BORDER-LEFT: #c7d2e7 1px solid; BORDER-BOTTOM: #c7d2e7 1px solid"><table width="98%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td class=thtahomasmall bgColor=#99FF99 width="13%"><div align="center">ชื่อพนักงานซ่อมบำรุง</div></td>
<td width="7%" class=thtahomasmall bgColor=#99FF99> <div align="center">ครั้ง</div></td>
<td width="5%" class=thtahomasmall bgColor=#99FF99><div align="center">รวม</div></td>
<td width="10%" class=thtahomasmall bgColor=#99FF99><div align="center">ตรงเวลา</div></td>
<td width="13%" class=thtahomasmall bgColor=#99FF99><div align="center">อำนวยความสะดวกแก่ผู้รับบริการ</div></td>
<td width="11%" class=thtahomasmall bgColor=#99FF99><div align="center">มารยาท</div></td>
<td width="14%" class=thtahomasmall bgColor=#99FF99><div align="center">พฤติกรรมการให้บริการ</div></td>
<td width="13%" class=thtahomasmall bgColor=#99FF99><div align="center">ความรับผิดชอบ</div></td>
<td width="14%" class=thtahomasmall bgColor=#99FF99><div align="center">มนุษยสัมพันธ์</div></td>
</tr>
<?php
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
if($Submit2 =="เรียกดู")
{
$sql="select sum(t1) as st1,sum(t2) as st2,sum(t3) as st3,sum(t4) as st4,sum(t5) as st5,sum(t6) as st6,count(driver) as cc,driver,audit.audit_id,tran.audit_id from audit,tran where (audit.audit_id = tran.audit_id) and tran.date between '$begin' and '$end' group by driver ";
}
else
{
$sql="select sum(t1) as st1,sum(t2) as st2,sum(t3) as st3,sum(t4) as st4,sum(t5) as st5,sum(t6) as st6,count(driver) as cc,driver,audit.audit_id,tran.audit_id from audit,tran where (audit.audit_id = tran.audit_id) group by driver ";
}
$result=mysql_query($sql);
while ($object = mysql_fetch_object($result))
{
$driver = $object ->driver;
$t1 = $object ->st1 ;
$t2 =$object ->st2 ;
$t3 = $object ->st3 ;
$t4 = $object ->st4 ;
$t5 = $object ->st5 ;
$t6 = $object ->st6 ;
$scc = $object ->cc ;
$sum = $t1+$t2+$t3+$t4+$t5+$t6 ;
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
$sqll="select id,name from user where id = '$driver'";
$lresult=mysql_query($sqll);
while ($objectl = mysql_fetch_object($lresult))
{
$name = $objectl->name;
}
?>
<tr>
<td height="22"><? echo $name ; ?></td>
<td> <div align="center"><font color="#CC0000"><? echo $scc ; ?></font>
</div></td>
<td> <div align="center"><font color="#CC0000"><? echo $ssum+$sum ; ?></font></div></td>
<td> <div align="center"><? echo $tt1+$t1 ; ?></div></td>
<td> <div align="center"><? echo $tt2+$t2; ?></div></td>
<td> <div align="center"><? echo $tt3+$t3; ?></div></td>
<td><div align="center"><? echo $tt4+$t4; ?> </div></td>
<td><div align="center"><? echo $tt5+$t5; ?> </div></td>
<td> <div align="center"><? echo $tt6+$t6; ?>
</div></td>
</tr>
<?php
}
?>
</table></TD>
</TR>
</TBODY>
</TABLE> </TD>
</TR>
</TBODY>
</TABLE>
</form>
<div align="center"></div>
</body>
</html>