| 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);
include("dbconfig.php");
include( "function.php" );
if (isset($_GET['no'])) $no = $_GET['no'];
else $no ='';
if (isset($_GET['name'])) $name = $_GET['name'];
else $name ='';
if ( $cmdSubmit == "Submit" ) {
if ( empty( $approv ) ) {
echo "<script language='JavaScript'>";
echo "alert('ไม่ได้ลงชื่อผู้อนุญาต')";
echo "history.back(1)";
echo "</script>";
}
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$datedb = formatDateDB($date);
$usql="update tran set audit_id = '$no' where no ='$no' ";
$uresult = mysql_query($usql );
$isql = "insert into audit (audit_id,date,t1,t2,t3,t4,t5,t6,audit_name) values
('$no','$datedb','$checkbox1','$checkbox2','$checkbox3','$checkbox4','$checkbox5','$checkbox6','$audit_name')";
$iresult = mysql_query($isql ) or die(mysql_error());
if (!$iresult) {
echo "<script language='JavaScript'>";
echo "alert('เก็บเข้าฐานข้อมูลไม่ได้')";
echo "</script>";
exit;
} else {
echo "<script language='JavaScript'>";
echo "alert('บันทึกข้อมูลเรียบร้อยแล้ว')";
echo "</script>";
}
echo "<script language='JavaScript'>";
echo "alert('อนุญาตเรียบร้อยแล้ว')";
echo "window.close();";
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:white;text-decoration:none;font-family:ms sans serif;}
a:visited{color:white;text-decoration:none;font-family:ms sans serif;}
a:hover{color:yellow;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=54 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="35%" height=28> </TD>
<TD class=thsans vAlign=center align=right bgColor=#c7d1e7 height=28><A
href=""><IMG height=18
alt="" src="picture/youraccount.gif" width=18
align=absMiddle border=0></A> <A
href=""></A> <A
href=""><IMG height=18 alt=Help!
src="picture/q.gif" width=18 align=absMiddle border=0></A>
<A href=""></A> <IMG height=18
alt="" hspace=3 src="picture/cart.gif" width=18
align=absMiddle border=0><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 class=thwbold colSpan=2 height=20> </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;
$u1 = $object ->u1;
$u2 = $object ->u2;
$u3 = $object ->u3;
$u4 = $object ->u4;
$u5 = $object ->u5;
$reason = $object ->reason;
$date = $object ->date ;
$date1 = $object ->date1;
$time1 = $object ->time1;
$date2 = $object ->date2 ;
$time2 = $object ->time2;
$approv = $object ->approv;
$car_id = $object ->car_id;
$driver = $object ->driver;
$boss = $object ->boss;
}
if (empty($u1)) $pu1='........................................';
else $pu1= $u1;
if (empty($u2)) $pu2='........................................';
else $pu2= $u2;
if (empty($u3)) $pu3='........................................';
else $pu3= $u3;
if (empty($u4)) $pu4='........................................';
else $pu4= $u4;
if (empty($u5)) $pu5='........................................';
else $pu5= $u5;
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
$sq="select * from user where id = '$driver' ";
$lre=mysql_query($sq);
while ($obje = mysql_fetch_object($lre)){
$driver = $obje->name;
}
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
$bsq="select * from user where id = '$boss' ";
$blre=mysql_query($bsq);
while ($bobje = mysql_fetch_object($blre)){
$nameboss = $bobje->name;
}
?>
<form name="form1" method="post" action="audit.php">
<TABLE cellSpacing=0 cellPadding=3 width="100%" align=center border=0>
<TBODY>
<TR>
<TD height="126" vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width="100%" height="354" 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="5%" height="25"> เลขที่ <input name="no" type="hidden" id="no" size="6" value="<? echo $no ;?>" readonly="yes" ></td>
<td colspan="2" align="left"><? echo $no ;?></td>
<td width="29%"> <div align="right">วันที่<input name="date" type="hidden" id="date" value="<? echo FormatDateshow($date); ?>"
size="12" maxlength="12" ><? echo FormatDateshow($date) ; ?> </div>
</td>
</tr>
<tr>
<td height="23" colspan="4"><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 $name ; ?> <font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
</font>
</td>
</tr>
<tr>
<td height="20" colspan="4"><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 $target ; ?>
</td>
</tr>
<tr>
<td height="31" colspan="4"><strong><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">เพื่อ
<input name="reason" type="hidden" id="code22" size="90" value="<? echo formatDateshow($reason) ;?>" readonly="yes">
<? echo formatDateshow($reason) ;?>มีคนนั่ง<input name="person" type="hidden" id="person" size="3" maxlength="3"
value="<? echo $person ;?>"><? echo $person ;?> คน </font></strong>
</td>
</tr>
<tr>
<td height="31" colspan="4"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>ในวันที่</strong></font>
<input name="date1" type="hidden" id="date22" value="<? formatDateshow($date) ; ?>" size="12" maxlength="12" readonly="yes">
<? echo formatDateshow($date) ; ?> <strong>เวลา</strong>
<input name="time1" type="hidden" id="time1" size="6" value="<? echo $time1 ;?>" readonly="yes">
<? echo $time1 ;?> <strong> ถึงวันที่</strong>
<input name="date2" type="hidden" id="date32" value="<? echo formatDateshow($date2) ; ?>" size="12" maxlength="12" readonly="yes">
<? echo formatDateshow($date2) ; ?> <strong> เวลา</strong>
<input name="time2" type="hidden" id="time2" size="6" value="<? echo $time2 ;?>">
<? echo $time2 ;?>
</td>
</tr>
<tr>
<td height="25" colspan="4"><div align="right">ผู้ขออนุญาต
<input name="approv" type="hidden" id="approv" value="<? echo $approv ;?>" readonly="yes">
<? echo $approv ;?> </div>
</td>
</tr>
<tr>
<td height="31" colspan="4"> <div align="right">ผู้มีอำนาจสั่งใช้รถ
<input name="boss" type="hidden" id="approv2" value="<? echo $nameboss ;?>" readonly="yes">
<? echo $nameboss;?> </div></td>
</tr>
<tr>
<td height="20"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>รายชื่อผู้นั่ง</strong></font></td>
<td width="22%"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
1.<input name="u1" type="hidden" id="u1" value="<? echo $u1 ;?>" readonly="yes"><? echo " ".$pu1 ;?></font>
</td>
<td width="22%"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
2.<input name="u2" type="hidden" id="u2" value="<? echo $u2 ;?>" readonly="yes"><? echo " ".$pu2 ;?></font>
</td>
<td width="22%"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
3.<input name="u3" type="hidden" id="u3" value="<? echo $u3 ;?>" readonly="yes"><? echo " ".$pu3 ;?></font>
</td>
</tr>
<tr>
<td height="20"><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">
4.<input name="u4" type="hidden" id="u4" value="<? echo $u4 ;?>" readonly="yes"><? echo " ".$pu4 ;?></font>
</td>
<td><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
5.<input name="u5" type="hidden" id="u5" value="<? echo $u5 ;?>" readonly="yes"><? echo " ".$pu5 ;?></font>
</td>
</tr>
<tr>
<td height="22"><strong></strong></td>
<td><strong><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
</font></strong></td>
</tr>
<tr>
<td colspan="2" height="23"><font color="#336600" size="3" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<strong>พนักงานขับรถ</strong></font></td>
<td colspan="2"> <font color="#336600" size="3" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<input name="driver" type="hidden" readonly="yes" id="driver" value="<? echo $driver ;?>">
<? echo $driver ;?> <strong>ทะเบียนรถยนต์</strong>
<input name="car_id" type="hidden" id="car_id" value="<? echo $car_id ;?>" readonly="yes">
<? echo $car_id ;?></font></td>
</tr>
<tr>
<td height="20"> </td>
<td colspan="3"><div align="right"> <a href="print_rq.php?no=<? echo $no."&date=".FormatDateshow($date).
"&name=" .$name."&target=".$target."&reason=".$reason."&date1=".FormatDateshow($date1).
"&date2=".FormatDateshow($date2)."&approv=".$approv."&u1=".$u1."&u2=".$u2."&u3=".$u3.
"&u4=".$u4."&u5=".$u5."&driver=".$driver."&car_id=".$car_id."&person=".$person."&time1=".$time1.
"&time2=".$time2."&nameboss=".$nameboss ; ?>%20">
<img src="print.gif" width="70" height="30" border="0"></a></div>
</td>
</tr>
<tr>
<td height="16" colspan="4"> <div align="center"> </div></td>
</tr>
</table>
</DIV></TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
</TBODY>
</TABLE>
</form>
</body>
</html>