| 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);
?>
<?php
include("dbconfig.php");
include( "function.php" );
?>
<?
if ( $cmdSubmit == "บันทึก" )
{
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$date3=$_POST['date3'];
$datedb1 = formatDateDB($date1);
$datedb2 = formatDateDB($date2);
$usql="update tran set complete = '$complete',date3= '$date3',time='$time' where no ='$no' ";
$uresult = mysql_query($usql );
echo "<script language='JavaScript'>";
echo "alert('บันทึกเรียบร้อยแล้ว');";
echo "location='index.php';";
echo "</script>";
}
?>
<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:black;text-decoration:none;font-family:ms sans serif;}
a:visited{color:black;text-decoration:none;font-family:ms sans serif;}
a:hover{color:blue;text-decoration:none;font-family:ms sans serif;}
td{font-size:10pt;font-family:ms sans serif;}
.style4 { font-size: 16pt;
color: #3399FF;
}
.style5 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style6 {
font-size: 16pt;
color: #FFFFFF;
}
</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=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><br>(งานที่รอดำเนินการ)</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" size="4">หน้าแรก</font></span></a><span class="style5"><span class="style6"> ||</span></span></TD></TD>
</TR>
<TR>
<TD style="BACKGROUND-COLOR: black; heigth: 1"
colSpan=2></TD>
</TR>
</TBODY>
</TABLE>
<?php
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sql="select * from tran where no = '$no' ";
$result=mysql_query($sql);
while ($object = mysql_fetch_object($result))
{
$user_id = $object ->user_id;
$target = $object ->target;
$person = $object ->person;
$reason = $object ->reason;
$length = $object -> length ;
$date = $object ->date ;
$date1 = $object ->date1;
$time = $object ->time;
$time1 = $object ->time1;
$date2 = $object ->date2 ;
$idjob = $object -> idjob;
$time2 = $object ->time2;
$approv = $object ->approv;
$car_id = $object ->car_id;
$driver = $object ->driver;
$comment = $object ->comment;
$dept_h_full_name = $object ->dept_h_full_name;
$name = $object ->user_id;
$car_id2 = $object ->car_id2;
$dept_name = $object -> dept_name;
$station = $object -> station;
$stationno = $object -> stationno;
$assetno = $object -> assetno;
$brand = $object -> brand;
$complete = $object -> complete;
$material = $object ->material;
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;
}
}
?>
<form name="form1" method="post" action="reserv_sit4.php">
<table cellspacing=0 cellpadding=0 width="100%" border=0>
<tbody>
<tr>
<td width="100%" height="334" colspan=2> <table width="100%" border=0>
<tbody>
<tr>
<td
style="BACKGROUND-IMAGE: url(pointsmall.gif); BACKGROUND-REPEAT: repeat-x"></td>
</tr>
</tbody>
</table>
<div class=thtahomasmall
style="PADDING-RIGHT: 2px; PADDING-LEFT: 2px; PADDING-BOTTOM: 2px; PADDING-TOP: 2px"
align=right> </div>
<div id=news_newyear
style="BORDER-RIGHT: #c7d2e7 1px solid; PADDING-RIGHT: 3px; BORDER-TOP: #c7d2e7 1px solid; PADDING-LEFT: 3px; MARGIN-BOTTOM: 3px; PADDING-BOTTOM: 3px; BORDER-LEFT: #c7d2e7 1px solid; PADDING-TOP: 3px; BORDER-BOTTOM: #c7d2e7 1px solid; BACKGROUND-COLOR: #f0f8ff">
<table width="95%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="12%" height="25"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<strong>เลขที่ </strong></font>
<input name="no" type="hidden" id="no" size="6" value="<? echo $no ;?>" readonly="yes">
<? echo "<font color=\"#F94000\"> $no </font><br>"; ?>
</td>
<td width="88%"> <div align="right"> วันที่ <? echo FormatDateshow($date) ." เวลา : ".$time ; ?> </div>
</td>
</tr>
<tr>
<td height="23" colspan="2"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>ชื่อผู้อนุมัติส่งซ่อม</strong></font>
<input type="hidden" name="textfield" value="<? echo $name ; ?>" readonly="yes" >
<? echo "<font color=\"#247BFF\"> $name </font><br>"; ?>
<font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"> <br>
<font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>แผนก </strong></font>
<input type="hidden" name="textfield" value="<? echo $dept_name; ?>" readonly="yes" >
<? echo "<font color=\"#247BFF\"> $dept_name </font><br>"; ?>
<br>
<font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>ชื่อหัวหน้าแผนก </strong></font>
<input type="hidden" name="textfield" value="<? echo $dept_h_full_name ; ?>" readonly="yes" >
<? echo "<font color=\"#247BFF\"> $dept_h_full_name </font><br>"; ?>
<br></font>
</td>
</tr>
<tr>
<td height="3" colspan="2"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>พัสดุที่ต้องการซ่อม </strong></font>
<input name="target" type="hidden" id="target" size="80" value="<? echo $target ; ?>" readonly="yes">
<? echo "<font color=\"#247BFF\"> $target </font>"; ?>
ประเภท
<?
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$cquery="select * from TpyeJob where idjob = '$idjob' "; //not sure it's work
//echo 'ตัว'.$cquery.'<br>';
$cresult=mysql_query($cquery);
//echo 'ตัว'.$cresult.'<br>';
$rs = mysql_fetch_array($cresult);
$job = $rs["job"];
?>
<? echo "<font color=\"#247BFF\"> $job </font><br>"; ?>
<br>
</td>
</tr>
<tr>
<td height="4" colspan="2"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>หมายเลขครุภัณฑ์</strong></font>
<input name="assetno" type="hidden" id="asetno" size="80" value="<? echo $assetno ; ?>" readonly="yes">
<? echo "<font color=\"#247BFF\"> $assetno </font><br>"; ?><br>
</td>
</tr>
<tr>
<td height="9" colspan="2"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<strong>รุ่น / ยี่ห้อ / อายุการใช้งาน </strong></font>
<input name="reason2" type="hidden" id="reason" size="90" value="<? echo $reason ;?>" readonly="yes">
<? echo "<font color=\"#247BFF\"> $brand </font><br>"; ?><br>
</td>
</tr>
<tr>
<td height="31" colspan="2"><strong><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">อาการที่ชำรุด </font></strong>
<input name="reason" type="hidden" id="code22" size="90" value="<? echo $reason ;?>" readonly="yes">
<? echo "<font color=\"#247BFF\"> $reason </font><br>"; ?><br>
</td>
</tr>
<tr>
<td height="31" colspan="2"><p><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>แจ้งซ่อมวันที่</strong></font>
<input name="date1" type="text" id="date22" value="<? echo formatDateshow1($date1) ; ?>" size="7" readonly="yes">
<strong>เวลา</strong>
<input name="time1" type="text" id="time1" size="2" value="<? echo $time1 ;?>" readonly="yes"><br><br></p>
</td>
</tr>
<tr>
<td height="25" colspan="2"><div align="left"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong><br>
ช่างผู้ดำเนินงาน </strong></font>
<?
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))
{
$driver = $objectl->name;
}
?>
<?
if(($car_id2=="0") || ($car_id2 =="เลือกท"))
echo " ยังไม่ได้จัดช่าง";
?>
<? echo "<font color=\"#247BFF\"> $driver</font>"; ?>
</strong></font></div>
<div align="left"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>
ระยะเวลาในการซ่อม </strong></font>
<input name="length" type="hidden" id="length" value="<? echo $length ;?>">
<? echo "<font color=\"#247BFF\"> $length วัน</font>"; ?></div><br>
<div align="left"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>
ประมาณระยะเวลาในการซ่อมแล้วเสร็จวันที่ </strong></font>
<input name="car_id" type="hidden" id="u5" value="<? echo $car_id ;?>">
<input type="hidden" name="textfield" value="<? echo $car_id ; ?>" readonly="yes" >
<input name="car_id2" type="hidden" id="car_id2" value="<? echo $car_id2 ;?>">
<input type="hidden" name="textfield2" value="<? echo $car_id2 ; ?>" readonly="yes" >
<? $car_id2 = FormatDateshow($car_id2); ?>
<? echo "<font color=\"#247BFF\"> $car_id2 </font>"; ?>
</p></div>
</td>
</tr>
<tr>
<td> <p><strong><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
วัสดุอุปกรณ์ที่ใช้</font></strong></p>
</td>
<td><br>
<textarea name="material" id="material" cols="45" rows="5"></textarea></font></strong>
</td>
</tr>
<tr>
<td height="25" colspan="2"><br><div align="right">
<p align="left">
<font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<? echo "<font color=\"#FF0000\"> $complete </font>"; ?><br>
<select name="complete" id="complete">
<option> </option>
<?
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
//$cplquery= select * fromcomplete where status='".$_POST['id']."'
$cplquery="select * from complete where id <>'1' order by id";
$cplresult=mysql_query($cplquery);
while ($cplobject = mysql_fetch_object($cplresult))
{
echo "<OPTION VALUE =".$cplobject ->status.">" .$cplobject ->status."</Option>" ;
}
?>
</select>
</font>
<? $datesreal = FormatDateshow($datesreal); ?>
<INPUT id= "date3" value= เลือกวันที่ประมาณการซ่อม type=date name="date3">
<strong>เวลา</strong>
<input name="time" type="text" id="time" size="6">
</p> </div>
</td>
</tr>
<tr>
<td height="20"> </td>
<td align="left"><br><? echo "<a href='audit_p.php?no=$no&driver=$driver&date=$date&name=$name&target=$target&reason=$reason&date1=".formatDateshow1($date1)."&date2=".formatDateshow1($date2)."&approv=$approv&u1=$u1&u2=$u2&u3=$u3&u4=$u4&u5=$u5&car_id=$car_id&person=$person&time1=$time1&time2=$time2&nameboss=$boss&dept_name=$dept_name&comment=$comment&inputtime=$time&station=$station&stationno=$stationno&assetno=$assetno&brand=$brand&material=$material 'target='_self'>แบบประเมิน</a>" ?>
</td>
</tr>
<tr>
<td height="20"> <input name="cmdSubmit" type="submit" id="cmdSubmit" value="บันทึก"></td>
<td> </td>
</tr>
<tr>
<td height="23"><br>
<strong><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">สำหรับงานซ่อมทั่วไป
</font></strong> <br>
<? echo "<a href='prq1.php?no=$no&driver=$driver&date=$date&name=$name&target=$target&reason=$reason&date1=".formatDateshow1($date1)."&date2=".formatDateshow1($date2)."&approv=$approv&car_id=$car_id&person=$person&time1=$time1&time2=$time2&nameboss=$boss&dept_name=$dept_name&comment=$comment&inputtime=$time&station=$station&stationno=$stationno&assetno=$assetno&brand=$brand&material=$material 'target='_self'><img src='../../img/logo/ปริ้น.png' width='46' height='46'></a>" ;
?>
<br><br>
<strong><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">สำหรับเครื่องมือแพทย์
</font></strong> <br>
<?php echo "<a href='prq2.php?no=$no&driver=$driver&date=$date&name=$name&target=$target&reason=$reason&date1=".formatDateshow1($date1)."&date2=".formatDateshow1($date2)."&approv=$approv&u1=$u1&u2=$u2&u3=$u3&u4=$u4&u5=$u5&car_id=$car_id&person=$person&time1=$time1&time2=$time2&nameboss=$boss&dept_name=$dept_name&comment=$comment&inputtime=$time&station=$station&stationno=$stationno&assetno=$assetno&brand=$brand&material=$material target='_parent'><img src='../../img/logo/ปริ้น.png' width='46' height='46'></a>" ;
?><br>
</td>
<td> </td>
</tr>
</table>
</div></td>
</tr>
</tbody>
</table>
<TABLE cellSpacing=0 cellPadding=3 width="100%" align=center border=0>
<TBODY>
<TR>
<TD height="126" vAlign=top> </TD>
</TR>
</TBODY>
</TABLE>
</form>
</body>
</html>