| 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);
include("dbconfig.php");
include( "function.php" );
$dd =date("d") ;
$mm = date("m") ;
$yy = date("Y")+543 ;
$yy2 = date("Y")+543 ;
$ndd=$dd+5 ;
if (!checkdate($mm,$ndd,$yy) or ($ndd < $dd) ) {
$ndd=4;
$mm=$mm+1;
if ($mm==13) {
$yy=$yy+1;
$mm=1;
}
}
$date_e = $yy."-".$mm."-".$ndd ;
//$date_e = $yy."-".$mm."-".$dd ;
$date_s =(date("Y")+543).date("-m-").(date("d")-1);
//$date_s = formatDateDB($date_start);
//$date_e = formatDateDB($date_end);
$date_end= ($ndd-1)."-$mm-$yy" ;
$date_start = (date("d")-1).date("-m-").(date("Y")+543) ;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>ระบบขออนุมัติซ่อมบำรุงพัสดุ</title>
<link rel="shortcut icon" type="image/x-icon" href="/images/favicon.ico"> <!-- Icon web address bar -->
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<style>
a:link{text-decoration:none;font-family:ms sans serif;}
a:visited{text-decoration:none;font-family:ms sans serif;}
a:hover{color:red;text-decoration:none;font-family:ms sans serif;}
td{font-size:10pt;font-family:ms sans serif;}
.style2 {font-size: 18px}
.style3 {
font-weight: bold;
color: #3399FF;
font-size: 20px;
}
.style4 {color: #0099FF}
.style9 {font-size: 16px}
</style>
<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>
</head>
<body>
<TABLE height=79 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD style="BACKGROUND-COLOR: #f0f7ff" colSpan=2></TD>
</TR>
<TR bgColor=#c7d2e7>
<TD width="88%" height=28 bgcolor="#FFFFFF" class=thwbold><div align="center" class="style2">
<p><span class="style2"><img src="icon_maintenance.gif" width="30" height="30"> <span class="style3">
<font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ระบบขออนุมัติซ่อมพัสดุ โรงพยาบาลสัตหีบ</font></span></span><br>
<br></p></div>
</TD>
<TD width="12%" height=28 align=right vAlign=center bgColor=#FFFFFF class=thsans><div align="right"></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 height=21 colSpan=2 bgcolor="#00CCCC" class=thwbold>
<TABLE height="95%" cellSpacing=0 cellPadding=1 width="99%" align=center border=0>
<TBODY>
<TR>
<TD width="3%" height="27" align=middle bgcolor="#00CCCC"> </TD>
<TD width="23%" align=middle bgcolor="#00CCCC"><a href="follow.php" target="_parent" class="style2"><font color="#FFFFFF" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"> </font></a></TD>
<TD width="9%" align=middle bgcolor="#00CCCC"><a href="donotapprov.php" target="_blank"></a></TD>
<TD width="23%" align=middle bgcolor="#00CCCC"><a href="follow.php" target="_parent" class="style2"><font color="#FFFFFF" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ติดตามการขอซ่อม</font></a></TD>
<TD width="23%" align=middle bgcolor="#00CCCC"><span class="style2"><a href="rep_driver3.php" target="_parent"><font color="#FFFFFF" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ดูผลการประเมินและรายงาน</font></a></span></TD>
<TD width="1%" align=middle bgcolor="#00CCCC"><span class="style2"></span></TD>
<TD width="19%" align=middle bgcolor="#00CCCC" class=thtahomasmall><a href="logout.php" class="style2"><font color="#FFFFFF" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">Logout ออกจากระบบ</font></a></TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
<TR>
<TD colSpan=2 bgcolor="#0099FF" style="heigth: 1"></TD>
</TR>
</TBODY>
</TABLE>
<table width="94%" height="163" border="0" align="center" cellpadding="0" cellspacing="2"><br>
<tr>
<td height="30"><div align="center" class="style2">1</div></td>
<td width="80%"><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="car_request.php" class="style4">ผู้ขอซ่อม ยื่นขออนุมัติส่งซ่อม</a> </font></span></td>
<td width="3%"> </td>
<td width="11%"><div align="left"></div></td>
<td width="0%"> </td>
</tr>
<tr>
<td height="30"><div align="center" class="style2">2</div></td>
<td><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">หัวหน้าช่างมอบหมายช่างผู้ดำเนินการซ่อม</font> <a href="rq_chk1.php" target="_blank" class="style4">ใบขออนุมัติซ่อม</a></font></span></td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height="30"><div align="center" class="style2">3</div></td>
<td><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="rq_chknotend.php" target="_blank" class="style4">งานที่รอดำเนินการ</a></font></font></span></td>
<td rowspan="5"> </td>
<td rowspan="5"> </td>
<td rowspan="5"> </td>
</tr>
<tr>
<td height="30"><div align="center" class="style2">4</div></td>
<td><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="rq_chking.php" target="_blank" class="style4">งานที่กำลังดำเนินการ</a> </font></span></td>
</td>
</tr>
<tr>
<td height="30"><div align="center"><span class="style2">5</span></div></td>
<td><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="rq_chkend.php" target="_blank" class="style4">งานซ่อมเสร็จแล้ว</a> </font></span></td>
<td>
</tr>
<tr>
<td height="30"><div align="center"><div align="center">6</div></td>
<td><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ผู้รับบริการซ่อม <a href="assetment.php" target="_blank" class="style4">ประเมินการให้บริการ</a> </font></span></td>
<td> </td>
</tr>
<tr>
<td height="30"><div align="center" class="style2">7</div></td>
<td><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="followcom.php" target="_blank" class="style4">งานซ่อมของศูนย์คอมพิวเตอร์</a> </font></span></td>
<td><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="followcom.php" target="_blank" class="style4"></a> </font></span></td></td>
</tr>
<tr>
<td height="30"><div align="center" class="style2">8</div></td>
<td><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="follow3.php" target="_blank" class="style4">สรุปรายงานบันทึกขอซ่อม</a> </font></span></td>
<td><span class="style2"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="follow3.php" target="_blank" class="style4"></a> </font></span></td></td>
</tr>
<tr> </tr>
</table>
<p> </p>
<div align="center"><font size="4" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><br>
ตารางแสดงการขอซ่อมระหว่างวันที่
<? echo $date_start ; ?> ถึง <? echo $date_end ; ?> </font></div>
<table width="100%" height="115" border="1" align="center" bordercolor="#CC99CC">
<tr background="Background6.jpg">
<td width="6%" height="74" background="Background2.jpg"><div align="center" class="style9"><div align="center"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">วันที่</font></div></td>
<td width="4%" background="Background2.jpg"><div align="center" class="style9"><div align="center"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">เวลา</font></div></td>
<td width="18%" background="Background2.jpg"><div align="center" class="style9"><strong>พัสดุที่ต้องการซ่อม </strong></div></td>
<td width="17%" background="Background2.jpg"><div align="center" class="style9"><strong>หมายเลขครุภัณฑ์</strong></div></td>
<td width="16%" background="Background2.jpg"><div align="center" class="style9"><strong>รุ่น / ยี่ห้อ / อายุการใช้งาน</strong></div></td>
<td width="8%" background="Background2.jpg"><div align="center" class="style9"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ผู้ขอ</font></div></td>
<td width="10%" background="Background2.jpg"><div align="center" class="style9"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ช่างผู้ดำเนินงาน</font></div></td>
<td width="11%" background="Background2.jpg"><div align="center" class="style9"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">คาดว่าจะแล้วเสร็จใน</font></div></td>
<td width="10%" background="Background2.jpg"><div align="center" class="style9"><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">สถานะ</font></div></td>
</tr>
<?php
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
//$sql="select * from tran where boss is not null and date1 between '$date_s' and '$date_e' order by date1";
//$sql="select * from tran where car_id <> '0' and date1 between '$date_s' and '$date_e' ";
$sql="select * from tran where car_id >= '0' and date1 between '$date_s' and '$date_e' and status<>'N' order by date1 desc ";
$result=mysql_query($sql) ;
$num_rows = mysql_num_rows($result);
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;
$car_id = $object -> car_id;
$comment = $object ->comment;
$name = $object ->user_id;
$car_id2 = $object ->car_id2;
$assetno = $object -> assetno;
$brand = $object -> brand;
$complete = $object -> complete;
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;
}
if ($date1 < (date("Y")+543).date("-m-d") ){
$bgcolor = "#ffffff" ;
$mover = "this.style.background='white'" ;
$mout = "this.style.background='#ffffff'" ;
$img = " " ;
} else {
$bgcolor = "#ffff99" ;
$mover = "this.style.background='ccccff' " ;
$mout = "this.style.background='#ffff99' " ;
$img = "<img src='../../images/gear.gif' width='22' height='22' > " ;
}?>
<tr>
<td height="33"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<? echo $img ;?> <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">
<?
if (empty($driver)) {
if (!empty($comment)) {
echo $comment ;
$car_id= " " ;
} else echo "กำลังจัดพนักงาน:ซ่อมบำรุง" ;
} else echo "<font color=\"#1A02FF\"> $driver </font>";
?></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="yes" >
<? echo "<font color=\"#1A02FF\"> $car_id2 </font>"; ?></font></div></td>
<td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><? echo $complete ;?></font></div></td>
</tr>
<?php
}
// mysql_free_result($result);
?>
<? if($num_rows == "0") echo "<center><img src='../../images/gear.gif' width='25' height='22' ><font size='5' face='Microsoft Sans Serif, MS Sans Serif, sans-serif'>ยังไม่มีใบขออนุมัติซ่อม</font></center>" ;?>
<blockquote>
<p align="left"> </p>
</blockquote>
</body>
</html>