| 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);
include("dbconfig.php");
include( "function.php" );
if (isset($_GET['chk'])) $chk = $_GET['chk'];
else $chk ='';
if (isset($_GET['no'])) $no = $_GET['no'];
else $no ='';
if (isset($_POST['cmdSubmit'])){
$cmdSubmit = $_POST['cmdSubmit'];
if (isset($_POST['car_id'])) $car_id = $_POST['car_id'];
else $car_id='';
if (isset($_POST['comment'])) $comment = $_POST['comment'];
else $comment='';
if (isset($_POST['driver'])) $driver = $_POST['driver'];
else $driver='';
if (isset($_POST['chk'])) $chk = $_POST['chk'];
else $chk='';
if (isset($_POST['no'])) $no = $_POST['no'];
else $no='';
if (isset($_POST['approv'])) $approv = $_POST['approv'];
else $approv='';
}
if ( $cmdSubmit == "บันทึกพนักงานขับรถยนต์" ){
if ( empty( $driver ) ) {
echo "<script language='JavaScript'>";
echo "alert('ไม่ได้เลือกชื่อพนักงานขับ');";
echo "history.back(1);";
echo "</script>";
break;
}
if ( empty( $car_id ) ) {
echo "<script language='JavaScript'>";
echo "alert('ไม่ได้เลือกรถ');";
echo "history.back(1);";
echo "</script>";
break;
}
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$usql="update tran set car_id = '$car_id',comment = '$comment',driver = '$driver',approv='$approv' ,chk = '$chk' where no ='$no' ";
//echo $usql.'<br>';
$uresult = mysql_query($usql ) or die(msql_error()) ;
//echo $uresult;
if (uresult) {
// $date = FormatDateshow($date) ;
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
$plquery="select id,name from user where id = '$driver' ";
$plresult=mysql_query($plquery);
while ($plobject = mysql_fetch_object($plresult)) {
$driver=$plobject ->name ;
}
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
$plquery1="select id,name from user where id = '$boss' ";
$plresult1=mysql_query($plquery1);
while ($plobject1 = mysql_fetch_object($plresult1)) {
$boss=$plobject1 ->name ;
}
$date1 = FormatDateshow($date1) ;
$date2 = FormatDateshow($date2) ;
echo "<p> </p>" ;
echo "<p align='center'><a href='print_rq.php?no=$no&date=$date&name=$name&target=$target&reason=$reason&date1=$date1&date2=$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=$boss&comment=$comment&time=$time target='_self'>
ต้องการพิมพ์ใบขออนุญาต</a></p> ";
echo "<p align='center'><a href='rq_chk1.php'>ไม่ต้องการพิมพ์</a></p>";
echo "<p align='center'> </p>";
exit() ;
}
}
?>
<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>
<div align="center">
<STYLE type=text/css>A.no_de:hover {
TEXT-DECORATION: none
}
</STYLE>
<?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;
$res_id = $object ->res_id;
$boss = $object ->boss;
$date = $object ->date ;
$date1 = $object ->date1;
$time1 = $object ->time1;
$date2 = $object ->date2 ;
$time2 = $object ->time2;
$approv = $object ->approv;
$time = $object ->time;
$comment =$object ->comment;
}
$nameboss='........................................';
if (strlen($boss) > 2) {
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
$sqll="select id,name from user where id = '$boss' limit 1";
$lresult=mysql_query($sqll);
while ($objectl = mysql_fetch_object($lresult)) {
$nameboss = $objectl->name;
}
mysql_free_result($lresult);
}
?>
<strong><font color="#0066CC" size="5" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ใบขอใช้รถยนต์ส่วนกลาง
</font></strong><font color="#0066CC" size="5" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
</font></div>
<form name="form1" method="post" action="head_car.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%" 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="21%" height="25"><strong><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">เลขที่ใบขอรถ</font></strong>
<input name="no" type="hidden" value="<? echo $no ; ?>" size="5" maxlength="5" readonly="yes">
<? echo $no ; ?></td>
<td width="79%"> <div align="right">วันที่ กรอกใบขอรถ
<input name="date" type="hidden" id="date" value="<? echo $date ; ?>" size="5" maxlength="5" readonly="yes">
<?
$y=substr($date ,0,4)+543;
$m=substr($date ,5,2);
$d=substr($date ,8,2);
$dateN= $y.'-'.$m.'-'.$d;
echo FormatDateshow($dateN);?>
<input name="time" type="hidden" id="time" value="<? echo $time ; ?>" size="5" maxlength="5" readonly="yes">.
<? echo " เวลา :".$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 name="name" type="hidden" id="name" value="<? echo $name ; ?>">
<? echo $name ; ?> <font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
</font></td>
</tr>
<tr>
<td height="20" 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 ; ?>" >
<? echo $target ; ?></td>
</tr>
<tr>
<td height="31" colspan="2"><strong><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">เพื่อ</font></strong>
<?php
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$sqlr="select * from c_reason where res_id = '".$res_id."' ";
$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>';
//echo 'k'. $reason2.'<br>';
}
?>
<input name="res_id" type="hidden" id="res_id" size="90" value="<? echo $res_id ;?>">
<strong> <? echo $reason2 ;?></strong>
<input name="reason" type="hidden" id="code22" size="90" value="<? echo $reason ;?>">
<? echo $reason ;?> <strong>มีคนนั่ง</strong> <input name="person" type="hidden" id="person" size="3" maxlength="3" value="<? echo $person ;?>"> <? echo $person ;?> <strong> คน </strong></td>
</tr>
<tr>
<td height="31" colspan="2"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>ขอใช้รถในวันที่</strong></font>
<input name="date1" type="hidden" id="date22" value="<? echo $date1 ; ?>" size="12" maxlength="12">
<?
$y1=substr($date1 ,0,4)+543;
$m1=substr($date1 ,5,2);
$d1=substr($date1 ,8,2);
$dateS = $y1.'-'.$m1.'-'.$d1;
echo formatDateshow($dateS) ; ?> <strong>เวลา</strong>
<input name="time1" type="hidden" id="time1" size="6" value="<? echo $time1 ;?>">
<? echo $time1 ;?> <strong> ถึงวันที่</strong> <input name="date2" type="hidden" id="date32" value="<? echo $date2 ; ?>"
size="12" maxlength="12"> <?
$y2=substr($date2 ,0,4)+543;
$m2=substr($date2 ,5,2);
$d2=substr($date2 ,8,2);
$dateE= $y2.'-'.$m2.'-'.$d2;
echo formatDateshow($dateE) ; ?>
<strong> เวลา</strong> <input name="time2" type="hidden" id="time2" size="6" value="<? echo $time2 ;?>">
<? echo $time2 ;?></td>
</tr>
<tr>
<td height="31" colspan="2"><div align="right">ผู้ขออนุญาต
<input name="approv" type="hidden" id="approv" value="<? echo $name ;?>" readonly="yes">
<? if($approv!="0") echo "................................";
else echo $name ;
?> </div></td>
</tr>
<tr>
<td height="31" colspan="2"> <div align="right">ผู้มีอำนาจลงนามสั่งใช้รถ
<input name="boss" type="hidden" id="boss" value="<? echo $boss ;?>" readonly="yes">
<? echo $nameboss ;?> </div></td>
</tr>
<tr>
<td height="20"><strong>รายชื่อผู้นั่ง</strong></td>
<td> 1.
<input name="u1" type="hidden" id="u1" value="<? echo $u1 ;?>">
<? echo $u1 ;?> 2.
<input name="u2" type="hidden" id="u2" value="<? echo $u2 ;?>">
<? echo $u2 ;?> 3.
<input name="u3" type="hidden" id="u3" value="<? echo $u3 ;?>" >
<? echo $u3 ;?></td>
</tr>
<tr>
<td height="20"> </td>
<td>4.
<input name="u4" type="hidden" id="u42" value="<? echo $u4 ;?>">
<? echo $u4 ;?> 5.
<input name="u5" type="hidden" id="u52" value="<? echo $u5 ;?>">
<? echo $u5 ;?></td>
</tr>
<tr>
<td height="22"><strong><font color="#FF0000" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">หมายเหตุ</font></strong></td>
<td><strong><font color="#FF0000" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
ไม่สามารถจัดรถตามคำขอได้เนื่องจาก</font><font face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<input name="comment" type="text" id="comment" size="50" value="<?php echo $comment;?>">
</font></strong></td>
</tr>
<tr>
<td height="23">พนักงานขับรถ</td>
<td> <font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
<select name="driver" id="driver">
<option value=""> เลือกชื่อพนักงานขับรถยนต์ </option>
<?
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
$plquery="select id,name from user where position = 'พนักงานขับรถยนต์' and status= '1' ";
$plresult=mysql_query($plquery);
while ($plobject = mysql_fetch_object($plresult)) {
echo "<OPTION VALUE =".$plobject ->id.">" .$plobject ->name."</Option>" ;
}
?>
</select>
</font>ทะเบียนรถยนต์
<select name="car_id" id="car_id">
<option>เลือกทะเบียนรถยนต์</option>
<?
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
$cplquery="select * from car where status ='1' ";
$cplresult=mysql_query($cplquery);
while ($cplobject = mysql_fetch_object($cplresult)){
echo "<OPTION VALUE =".$cplobject ->regist.">" .$cplobject ->regist."</Option>" ;
}
?>
</select>
</td>
</tr>
<tr>
<td height="39"> </td>
<td> <div align="right"> เลือก ชื่อพนักงานขับรถ และรถ
แล้วคลิ๊กปุ่มนี้ >>
<input name="cmdSubmit" type="submit" id="cmdSubmit" value="บันทึกพนักงานขับรถยนต์">
</div></td>
</tr>
</table>
</DIV></TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
</TBODY>
</TABLE>
</form>
</body>
</html>