| 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/ |
Upload File : |
<?php
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
?>
<?php
include("dbconfig.php");
include( "function.php" );
if(empty($dd1))
{
$dd1 = date("d") ;
$mm1 = date("m") ;
$yy1 = date("Y") ;
$dd2 = date("d") ;
$mm2 = date("m") ;
$yy2 = date("Y") ;
}
$date_start = "$dd1/$mm1/$yy1";
$date_end = "$dd2/$mm2/$yy2";
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>สรุปรายงานการใช้รถ</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<script language="JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<SCRIPT language=Javascript>
var text = "Sattahip Car Reserv system :: : ยินดีต้อนรับเข้าสู่ระบบ : ::"
var speed = 120
var x = 0
function U() {
var a = text.substring(0,x)
var b = text.substring(x,x+1).toUpperCase()
var c = text.substring(x+1,text.length)
window.status = a + b + c
if (x == text.length) {
x = 0
}
else {
x++
}
setTimeout("U()",speed)
}
U();
--->
</SCRIPT>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
</head>
<body>
<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="88%" height=28><div align="center"> <font size="5" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>
แสดงการใช้รถทั้งหมด </strong></font></div></TD>
<TD width="12%" height=28 align=right vAlign=center bgColor=#c7d1e7 class=thsans><div align="right">
<A
href=""></A> <img src="../images/q.gif" width="18" height="18"><img src="../images/youraccount.gif" width="18" height="18"><img src="../images/cart.gif" width="18" height="18">
<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="6%" height="22" align=middle><font color="#FFFFFF" size="4" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="index.php" target="_parent"><font size="2">
</font><font color="#FFFFFF" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">หน้าแรก</font></a></font></TD>
<TD align=middle width="15%"><font color="#FFFFFF"> </font></TD>
<TD align=middle width="14%"><font color="#FFFFFF"> </font></TD>
<TD width="22%"
align=middle><font color="#FFFFFF"> </font></TD>
<TD
align=middle width="18%"><font color="#FFFFFF" size="4" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="rep_driver3.php" target="_parent"><font color="#FFFFFF" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ดูผลการประเมินและรายงาน</font></a></font><font color="#FFFFFF"><SPAN
class=thsans2 id=n5></SPAN></font></TD>
<TD
align=middle width="2%"><font color="#FFFFFF"> </font></TD>
<TD class=thtahomasmall
align=middle width="23%"><a href="logout.php"><font color="#FFFFFF" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">Logout
ออกจากระบบ</font></a></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" action="report.php">
<div align="center">
<table width="55%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ระหว่างวันที่</font> </td>
<td><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<select name="dd1" id="select">
<option value=<? echo $dd1 ;?>><? echo $dd1 ;?></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="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 $yy1; ?>" size="4" maxlength="4">
</font> ถึง
<font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<select name="dd2" id="select2">
<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="select3">
<option value=<? echo $mm2 ;?>><? echo th_month($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="yy2" value="<? echo $yy2; ?>" size="4" maxlength="4">
<input type="submit" name="Submit" value="ดูรายงาน">
</font><br></td><br>
</tr>
</table>
</div>
<p align="center"><font color="#000066" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>แสดงการยื่นใบขอรถยนต์ตั้งแต่วันที่
<? echo $dd1."-".$mm1."-".$yy1 ; ;?> ถึงวันที่ <? echo $dd2."-".$mm2."-".$yy2 ; ; ?></font></p>
<table width="50%" border="1" align="center" bordercolor="#CC99CC">
<tr background="Background6.jpg">
<td width="69%" height="30" background="Background2.jpg">
<div align="center" class="style1"><font size="3" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">รายการ</font></div>
</td>
<td width="31%" height="30" background="Background2.jpg">
<div align="center" class="style1"><font size="3" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">จำนวน</font></div>
</td>
</tr>
<?php
/*mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sqlr="select * from c_reason ";
$resultr=mysql_query($sqlr);
// echo 't'. $sqlr.'<br>';
// echo 't'. $resultr.'<br>';
while ($objectlr = mysql_fetch_object($resultr)) {
$reason2 = $objectlr->reason2 ;
// echo 'k'. $reason2.'<br>';*/
?>
<tr>
<td align="center">
ประชุม/อบรม
<?php //echo $reason2.'<br>';?>
</td>
<td align="center">
<?php
$sumRes=0;
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where res_id='1' and date between '$begin' and '$end' ";
$result=mysql_query($sql);
//echo 'h'.$resutl ;
while ($object = mysql_fetch_object($result))
$sumRes=$sumRes +1;
{
echo $sumRes;
}
?>
</td>
</tr>
<tr>
<td align="center">EMS</td>
<td align="center">
<?php
$sumRes=0;
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where res_id='2' and date between '$begin' and '$end' ";
$result=mysql_query($sql);
//echo 'h'.$resutl ;
while ($object = mysql_fetch_object($result))
$sumRes=$sumRes +1;
{
echo $sumRes;
}
?>
</td>
</tr>
<tr>
<td align="center">Refer</td>
<td align="center">
<?php
$sumRes=0;
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where res_id='3' and date between '$begin' and '$end' ";
$result=mysql_query($sql);
//echo 'h'.$resutl ;
while ($object = mysql_fetch_object($result))
$sumRes=$sumRes +1;
{
echo $sumRes;
}
?>
</td>
</tr>
<tr>
<td align="center">ชุมชน</td>
<td align="center">
<?php
$sumRes=0;
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where res_id='4' and date between '$begin' and '$end' ";
$result=mysql_query($sql);
//echo 'h'.$resutl ;
while ($object = mysql_fetch_object($result))
$sumRes=$sumRes +1;
{
echo $sumRes;
}
?>
</td>
</tr>
<tr>
<td align="center">เบิกยา</td>
<td align="center">
<?php
$sumRes=0;
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where res_id='5' and date between '$begin' and '$end' ";
$result=mysql_query($sql);
//echo 'h'.$resutl ;
while ($object = mysql_fetch_object($result))
$sumRes=$sumRes +1;
{
echo $sumRes;
}
?>
</td>
</tr>
<tr>
<td align="center">ธนาคาร</td>
<td align="center">
<?php
$sumRes=0;
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where res_id='6' and date between '$begin' and '$end' ";
$result=mysql_query($sql);
//echo 'h'.$resutl ;
while ($object = mysql_fetch_object($result))
$sumRes=$sumRes +1;
{
echo $sumRes;
}
?>
</td>
</tr>
<tr>
<td align="center">ส่งเอกสารราชการ</td>
<td align="center">
<?php
$sumRes=0;
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where res_id='7' and date between '$begin' and '$end' ";
$result=mysql_query($sql);
//echo 'h'.$resutl ;
while ($object = mysql_fetch_object($result))
$sumRes=$sumRes +1;
{
echo $sumRes;
}
?>
</td>
</tr>
<tr>
<td align="center">อื่นๆ</td>
<td align="center">
<?php
$sumRes=0;
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where res_id='8' and date between '$begin' and '$end' ";
$result=mysql_query($sql);
//echo 'h'.$resutl ;
while ($object = mysql_fetch_object($result))
$sumRes=$sumRes +1;
{
echo $sumRes;
}
?>
</td>
</tr>
</table>
<br><br>
<!--เก่า-->
<!-- <table width="100%" border="1" align="center" bordercolor="#CC99CC">
<tr background="Background6.jpg">
<td width="26%" height="30" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">วันที่</font></div></td>
<td width="15%" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">เวลา</font></div></td>
<td width="27%" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">สถานที่ไป</font></div></td>
<td width="16%" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ผู้ขอ</font></div></td>
<td width="16%" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ขั้นตอนดำเนินการ</font></div></td>
</tr>
<?php /*
$begin = $yy1."-".$mm1."-".$dd1 ;
$end = $yy2."-".$mm2."-".$dd2 ;
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where date1 between '$begin' and '$end' ";
$result=mysql_query($sql);
while ($object = mysql_fetch_object($result))
{
$date1 = $object ->date1 ;
$date2 = $object ->date2 ;
$target = $object -> target ;
$time1 = $object -> time1 ;
$time2 = $object -> time2 ;
$user_id = $object ->user_id;
$driver = $object ->driver;
$boss = $object ->boss;
$no = $object ->no;
$comment = $object ->comment;
$approve = $object -> approve ;
$nRecords = $object ->items ;
if (strlen($driver) < 2 ){
$step = "รอการจัดรถ" ;
}
if (strlen($ิappove) < 2 ){
$step = "รอหัวหน้าฝ่าย" ;
}
if (strlen($ิboss) < 4 ){
$step = "รอผู้สั่งใช้รถลงนาม" ;
}
if (strlen($driver) > 1 ) {
$step = "จัดเรียบร้อยแล้ว" ;
}
if (strlen($comment) > 3 ) {
$step = "ไม่สามารถจัดรถ" ;
}
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
$sqll="select id,name from user where id = '$user_id'";
$lresult=mysql_query($sqll);
while ($objectl = mysql_fetch_object($lresult))
{
$name = $objectl->name;
}
if (strlen($boss) > 4 )
{
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
$bsql="select id,name from user where id = '$boss'";
$bresult=mysql_query($bsql) or die(mysql_error());
while ($bobject = mysql_fetch_object($bresult))
{
$nameboss = $bobject->name;
}
}
$sqll="select id,name from user where id = '$driver'";
$lresult=mysql_query($sqll);
while ($objectl = mysql_fetch_object($lresult))
{
$driver = $objectl->name;
}
*/
?>
<tr>
<td><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<img src="../images/freeshipping_small.gif" width="19" height="12"> <a href="reserv_sit.php?no=<? echo $no; ?>&name=<? echo $name ;?>&boss=<? echo $nameboss ;?>">
<? //echo formatDateshow($date1)." ถึง ".formatDateshow($date2) ;?></a>
</font></td>
<td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $time1." - ".$time2."น." ;?></font></div></td>
<td><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $target ;?></font></td>
<td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $name ;?></font></div></td>
<td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $step ;?></font></div></td>
</tr>
<?php
// }
// mysql_free_result($result);
?>
</table>-->
</form>
<p align="center"> </p>
</body>
</html>