| 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/CAR - Copy/bk/ |
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;}
</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>
<STYLE type=text/css>A.no_de:hover {
TEXT-DECORATION: none
}
</STYLE>
<TABLE height=85 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD style="BACKGROUND-COLOR: #f0f7ff" colSpan=2></TD>
</TR>
<TR bgColor=#c7d2e7>
<TD class=thwbold width="90%" height=28><div align="center"><a
href=""><font color=#000000> เปรียบเทียบผลการประเมินของพนักงานขับรถยนต์</font></a></div></TD>
<TD width="10%" height=28 align=right vAlign=center bgColor=#c7d1e7 class=thsans><div align="right">
<A href=""></A> <A href=""></A>
<A href=""></A> </div></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 class=thwbold colSpan=2 height=21> <TABLE height="95%" cellSpacing=0 cellPadding=1 width="99%" align=center
border=0>
<TBODY>
<TR>
<TD width="7%" height="22"
align=middle><SPAN class=thsans2
id=n1><a href="index.php"><font color="#FFFFFF">หน้าแรก</font></a></SPAN></TD>
<TD
align=middle width="11%"> </TD>
<TD
align=middle width="31%"><font color="#FFFFFF">สรุปเปรียบเทียบพนักงานขับรถ</font></TD>
<TD width="5%"
align=middle><font color="#FFFFFF"> </font></TD>
<TD
align=middle width="13%"><font color="#FFFFFF"><SPAN
class=thsans2 id=n5></SPAN></font></TD>
<TD
align=middle width="18%"><font color="#FFFFFF"><SPAN
class=thsans2 id=n5><a href="rep_driver1.php">ดูปริมาณการใช้รถ</a></SPAN></font></TD>
<TD class=thtahomasmall
align=middle width="15%"><div align="center"><a href="logout.php">ออกจากโปรแกรม</a></div></TD>
</TR>
</TBODY>
</TABLE></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=#c7d2e7
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=#c7d2ff width="13%"><div align="center">ชื่อพนักงานขับรถ</div></td>
<td width="7%" class=thtahomasmall bgColor=#c7d2ff> <div align="center">ครั้ง</div></td>
<td width="5%" class=thtahomasmall bgColor=#c7d2ff><div align="center">รวม</div></td>
<td width="10%" class=thtahomasmall bgColor=#c7d2ff><div align="center">ตรงเวลา</div></td>
<td width="13%" class=thtahomasmall bgColor=#c7d2ff><div align="center">ความพร้อมของรถ</div></td>
<td width="11%" class=thtahomasmall bgColor=#c7d2ff><div align="center">ความมีน้ำใจ</div></td>
<td width="14%" class=thtahomasmall bgColor=#c7d2ff><div align="center">ปฏิบัติตามกฏจราจร</div></td>
<td width="13%" class=thtahomasmall bgColor=#c7d2ff><div align="center">พฤติกรรมบริการ</div></td>
<td width="14%" class=thtahomasmall bgColor=#c7d2ff>พฤติกรรมการขับรถ</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"><img src="print.gif" width="70" height="30"><br><a href="print_rep_driver3.php">
PRINT THIS PAGE</a></div>
</body>
</html>