| 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/ |
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">
<br>
<table width="50%" border="0" align="center" cellpadding="2" cellspacing="0">
<tr>
<td class=thtahomasmall bgColor=#c7d2ff width="13%"><div>วัตถุประสงค์การขอใช้รถ</div></td>
<td width="7%" class=thtahomasmall bgColor=#c7d2ff> <div align="center">ครั้ง</div></td>
</tr>
<?php
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
if($Submit2 =="เรียกดู")
{
$sql="select sum(a1) as sa1,sum(a2) as sa2,sum(a3) as sa3,sum(a4) as sa4,sum(a5) as sa5,sum(a6) as sa6,count(driver) as cc ,driver
from auditnew where date between '$begin' and '$end' group by driver";
}
else
{
$sql="select sum(a1) as sa1,sum(a2) as sa2,sum(a3) as sa3,sum(a4) as sa4,sum(a5) as sa5,sum(a6) as sa6,count(driver) as cc,driver
from auditnew group by driver ";
}
//echo $sql.'<br>';
$result=mysql_query($sql);
/*echo $result.'<br>';
echo $sql.'<br>'; */
while ($object = mysql_fetch_object($result))
{
$driver = $object ->driver;
// echo $driver.'<br>';
$a1 = $object ->sa1 ;
$a2 =$object ->sa2 ;
$a3 = $object ->sa3 ;
$a4 = $object ->sa4 ;
$a5 = $object ->sa5 ;
$a6 = $object ->sa6 ;
$scc = $object ->cc ;
$sum = $a1+$a2+$a3+$a4+$a5+$a6 ;
/*echo $a1.'<br>';
echo $a2.'<br>';
echo $a3.'<br>';
echo $a4.'<br>'; */
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sqll="select * from c_reason ";
$lresult=mysql_query($sqll);
while ($objectl = mysql_fetch_object($lresult))
{
$_SESSION['res'] = $objectl->res_id;
$reason = $objectl->reason;
?>
<tr>
<td height="22"><? echo $reason ; ?></td>
<?
}
/* mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sqlll="select res_id from tran where res_id='".$_SESSION['res']."' ";
$lresultt=mysql_query($sqlll);
while ($objectll = mysql_fetch_object($lresultt))
{
$res= $objectll->res_id;*/
?>
<td> <div align="center"><font color="#CC0000"><? //echo ?></font>
</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>