| 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 - Copy/3/ |
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")-10 ;
$mm1 = date("m") ;
$yy1 = date("Y")+543 ;
$dd2 = date("d") ;
$mm2 = date("m") ;
$yy2 = date("Y")+543 ;
if ($dd1 < 1)
{
$dd1 = date("d") ;
$mm1=$mm1-1;
}
}
$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 = "ยินดีต้อนรับเข้าสู่ระบบ : ::"
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">
<!--
.style4 {font-size: 16pt;
color: #3399FF;
}
.style5 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style6 {font-size: 16pt;
color: #FFFFFF;
}
.style16 {font-size: 16pt; color: #FFFFFF; font-family: Verdana, Arial, Helvetica, sans-serif; }
.style18 {font-size: 16pt; color: #FF0000; }
.style19 {color: #E3C682}
-->
</style>
</head>
<body>
<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"><span class="style5"><a href="rep_driver3.php" target="_parent"><font color="#FFFFFF">ดูผลการประเมินและรายงาน</font></a></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><br><br>
<form name="form1" method="post" action="assetment.php">
<div align="center">
<table width="419" height="86" border="1" bordercolor="#FF0000">
<tr>
<td><table width="92%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="26%"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ระหว่างวันที่</font></td>
<td width="74%"><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></td>
</tr>
<tr>
<td height="21"><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="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">
</font></td>
</tr>
</table></td>
</tr>
</table>
<font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<input type="submit" name="Submit" value="ดูรายงาน">
</font><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
</font>
</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 ; ; ?></strong></font></p>
<table width="100%" border="1" align="center" bordercolor="#CC99CC">
<tr background="Background6.jpg">
<td width="9%" 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="6%" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">เวลา</font></div></td>
<td width="29%" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">พัสดุที่ต้องการซ่อม / หมายเลขครุภัณฑ์</font></div></td>
<td width="11%" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"> หมายเลขครุภัณฑ์</font></div></td>
<td width="17%" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><font size="2">รุ่น / ยี่ห้อ / อายุการใช้งาน </font> </font></div></td>
<td width="9%" background="Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ผู้ขอ</font></div></td>
<td width="9%" background="Background2.jpg"><div align="center">
<div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">คาดว่าจะแล้วเสร็จใน</font></div>
</div></td>
<td width="10%" background="Background2.jpg"><div align="center">
<div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ประเมิน</font></div>
</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' and complete IN ('งานซ่อมเสร็จแล้ว') order by no DESC";
$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 ;
$name = $object ->user_id;
$car_id = $object ->car_id;
$car_id2 = $object ->car_id2;
$assetno = $object -> assetno;
$brand = $object -> brand;
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><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<img src="../../images/gear.gif" width="20" height="20"> <a href="reserv_sit.php?no=<? echo $no; ?>&name=<? echo $name ;?>&boss=<? echo $nameboss ;?>">
<? echo formatDateshow($date1) ;?></a>
</font></div></td>
<td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $time1 ;?></font></div></td>
<td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $target ;?></font></div></td>
<td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $assetno ;?></font></div></td>
<td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $brand ;?></font></div></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">
<input name="car_id2" type="hidden" id="car_id2" value="<? echo $car_id2 ;?>">
<input type="hidden" name="textfield2" value="<? echo $car_id2 ; ?>" readonly >
<? echo "<font color=\"#1A02FF\"> $car_id2 </font>"; ?></font></div></td>
<td><div align="center" class="style18"><a href="audit.php?no=<? echo $object ->no."&name=".$name ; ?>" target="_blank" class="style80 style81" style="text-decoration: none;" >
<font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">คลิ๊ก</font></a></div></td>
</tr>
<?php
}
// mysql_free_result($result);
?>
</table>
</form>
<p align="center"> </p>
</body>
</html>