Viewing file: FrmMobile.php (15.31 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
session_start();
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Check Session User Login */
if (! session_is_registered("valid_user") &&session_is_registered("Priority") ) {
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<p style=padding-top:115px><p align=center><br /><font color=red><strong>กรุณาทำการ Login ก่อน</strong></font></p></p>";
echo "<meta http-equiv=\"refresh\" content=\"1; URL=../login.php\" />";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once("../includes/Function.php");
require_once("../includes/FunctionDB.php");
/** Create Database Object */
$dbObj = new DBConn;
/** Config Table for This Page */
$myTable1 = "automobile_tb";
$myTableFK = "CarmoId";
$query1 = " SELECT * FROM $myTable1 WHERE CarmoId ='$CarmoId' ";
$result1 = $dbObj->execQuery($query1);
$rs = $dbObj->fetchObject($result1);
} # else
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<link href="../css/default.css" rel="stylesheet" type="text/css" />
<title>MIS -- Administrator</title>
<script type="text/javascript" src="../js/utilities.js"></script>
<script language="JavaScript" type="text/JavaScript">
function browse()
{
myform.Img1.src = myform.Img1.value;
}
</script>
<style type="text/css">
<!--
.style1 {
color: royalblue;
font-weight: bold;
}
.style2 {color: royalblue}
.style11 {font-size: 14px}
-->
</style>
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
include("../templates/incHeader.php");
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="203" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>
<td width="800" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="2"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form id="myForm" name="myForm" method="post" enctype="multipart/form-data" action="EditMobile.php" onSubmit="return checkData();">
<tr>
<td width="73%" height="30" align="left" background="../images/background/bg-head-topic.gif" class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>» <a href="MobileList.php">รายการรถยนต์</a> » <span class="NOTE">บันทึกข้อมูลรถยนต์</span></strong></td>
<td width="27%" align="right" class="PADDING-LEFT-10 PADDING-RIGHT-15"> </td>
</tr>
<tr>
<td height="385" colspan="2" align="center" valign="top">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="10"></td>
</tr>
<tr>
<td height="10"><span class="PADDING-TOP-10"><img src="../images/icons/arrow-circle-225-left.png" width="16" height="16" border="0" align="absmiddle" /> <a href="javascript:;" onclick="window.history.back();"><strong>‹ ย้อนกลับ</strong></a></span></td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="right" style="padding:5px 0px 5px 0px"> </td>
</tr>
</table>
<table width="81%" border="0" align="center" cellpadding="1" cellspacing="3" style=" border:1px solid gray"size="12">
<tr>
<td height="34" colspan="2"> </td>
</tr>
<tr >
<td width="30%" align="right" bordercolor="#CCCCCC"><font face="Tahoma">เลขที่ครุภัณฑ์ </font></td>
<td width="68%" bordercolor="#FFFFCC"><font color="#0000FF" size="2" face="Tahoma">
<input name="Acc_code" type="text" id="Acc_code" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$rs->Acc_code;?>" size="30" />
</font></td>
</tr>
<tr >
<td align="right" bordercolor="#CCCCCC"><font face="Tahoma">ประเภทรถยนต์ </font></td>
<td bordercolor="#FFFFCC"><select name="Acc_name" id="Acc_name">
<option value="รถตู้ปรับอากาศ" <?php if($rs->Acc_name=="รถตู้ปรับอากาศ"){ echo "selected" ; } ?> >รถตู้ปรับอากาศ </option>
<option value="รถบัสปรับอากาศ" <?php if($rs->Acc_name=="รถบัสปรับอากาศ"){ echo "selected" ; } ?> >รถบัสปรับอากาศ</option>
<option value="รถบัสพัดลม" <?php if($rs->Acc_name=="รถบัสพัดลม"){ echo "selected" ; } ?> >รถบัสพัดลม</option>
<option value="รถบรรทุก" <?php if($rs->Acc_name=="รถบรรทุก"){ echo "selected" ; } ?> >รถบรรทุก </option>
<option value="รถเก๋งส่วนบุคคล" <?php if($rs->Acc_name=="รถเก๋งส่วนบุคคล"){ echo "selected" ; } ?> >รถเก๋งส่วนบุคคล</option>
<option value="รถมอเตอร์ไซด์" <?php if($rs->Acc_name=="รถมอเตอร์ไซด์"){ echo "selected" ; } ?> >รถมอเตอร์ไซด์</option>
<option value="รถเก๋งสองตอน" <?php if($rs->Acc_name=="รถเก๋งสองตอน"){ echo "selected" ; } ?> >รถเก๋งสองตอน</option>
<option value="รถปิคอัพ" <?php if($rs->Acc_name=="รถปิคอัพ"){ echo "selected" ; } ?> >รถปิคอัพ</option>
</select></td>
</tr>
<tr>
<td align="right" bordercolor="#CCCCCC"><font face="Tahoma">ยี่ห้อรถยนต์ </font></td>
<td bordercolor="#FFFFCC"><label>
<select name="Kind" id="Kind">
<option value="TOYOTA" <?php if($rs->Kind=="TOYOTA"){ echo "selected" ; } ?> >TOYOTA</option>
<option value="HONDA" <?php if($rs->Kind=="HONDA"){ echo "selected" ; } ?> >HONDA</option>
<option value="ISUZU" <?php if($rs->Kind=="ISUZU"){ echo "selected" ; } ?> >ISUZU</option>
<option value="FORD" <?php if($rs->Kind=="FORD"){ echo "selected" ; } ?> >FORD</option>
<option value="NISSAN" <?php if($rs->Kind=="NISSAN"){ echo "selected" ; } ?> >NISSAN</option>
<option value="DAEWOO" <?php if($rs->Kind=="DAEWOO"){ echo "selected" ; } ?> >DAEWOO</option>
<option value="HYUNDAI" <?php if($rs->Kind=="HYUNDAI"){ echo "selected" ; } ?> >HYUNDAI</option>
<option value="FIAT" <?php if($rs->Kind=="FIAT"){ echo "selected" ; } ?> >FIAT</option>
<option value="MITSUBISHI" <?php if($rs->Kind=="MITSUBISHI"){ echo "selected" ; } ?> >MITSUBISHI</option>
<option value="MAZDA" <?php if($rs->Kind=="MAZDA"){ echo "selected" ; } ?> >MAZDA</option>
<option value="CHEVLROLET" <?php if($rs->Kind=="CHEVLROLET"){ echo "selected" ; } ?> >CHEVLROLET</option>
</select>
</label></td>
</tr>
<tr >
<td height="30" align="right" bordercolor="#CCCCCC"><font face="Tahoma">รุ่น </font></td>
<td bordercolor="#FFFFCC"><font color="#0000FF" size="2" face="Tahoma">
<input name="Band_name" type="text" id="Band_name" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$rs->Band_name;?>" size="10" />
</font></td>
</tr>
<tr >
<td align="right" bordercolor="#CCCCCC">ปีที่ผลิต </td>
<td bordercolor="#FFFFCC"><font color="#0000FF" size="2" face="Tahoma">
<input name="Year" type="text" id="Year" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$rs->Year;?>" size="10" />
</font></td>
</tr>
<tr >
<td align="right" bordercolor="#CCCCCC">เลขทะเบียนรถยนต์ </td>
<td bordercolor="#FFFFCC"><font color="#0000FF" size="2" face="Tahoma">
<input name="CodeNo" type="text" id="CodeNo" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$rs->CodeNo;?>" size="10" />
</font></td>
</tr>
<tr>
<td align="right" bordercolor="#CCCCCC"><font face="Tahoma">ความจุผู้โดยสาร </font></td>
<td bordercolor="#FFFFCC"><input name="Word" type="text" id="Word" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$rs->Word;?>" size="10" />
<font face="Tahoma">คน</font></td>
</tr>
<tr>
<td height="20" align="right" bordercolor="#CCCCCC">ปีงบประมาณที่จัดซื้อ </td>
<td bordercolor="#FFFFCC"><font color="#0000FF" size="2" face="Tahoma">
<input name="Budget_year" type="text" id="Budget_year" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$rs->Budget_year;?>" size="3" />
</font></td>
</tr>
<tr>
<td align="right" bordercolor="#CCCCCC"><font face="Tahoma">วันที่ซื้อ </font></td>
<td bordercolor="#FFFFCC"><select name="mDate" id="mDate" class="select" >
<?php
$Date = $rs->Date_start;
$yearthai = explode("-",$Date);
$mDate = intval($yearthai[2]);
$mMonth = intval($yearthai[1]);
$mYear = intval($yearthai[0]);
for($i=0;$i<=31;$i++)
{
if( $i == 0)
echo"\n\t<option value=\"$mDate\" selected>$mDate</option>\n ";
else
echo"\n\t<option value=\"$i\">$i</option>\n ";
}
// getDay1to31();
?>
</select>
เดือน
<select name="mMonth" id="mMonth" class="select" >
<?php
$Date = $rs->Date_start;
$yearthai = explode("-",$Date);
$mDate= intval($yearthai[2]);
$Month = intval($yearthai[1]);
$mYear = intval($yearthai[0]);
$mMonth = $Month;
$CMonth = TxtThaiMonth($Month);
for($i=-1;$i<=11;$i++)
{
$a = $i+1;
if( $a == 0)
echo"\n\t<option value=\"$mMonth\" selected>$CMonth</option>\n ";
else
echo"\n\t<option value=\"$a\">$ThaiMonth[$i]</option>\n ";
}
// getThaiMonth();
?>
</select>
</font><font color="#0000FF" size="2" face="Tahoma"> </font><font color="#000000" size="2" face="Tahoma">ปี พ.ศ.</font><font color="#0000FF" size="2" face="Tahoma">
<input name="mYear" type="text" id="mYear" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<? echo $mYear ?>" size="4" maxlength="4" />
</font></td>
</tr>
<tr>
<td height="20" align="right" bordercolor="#CCCCCC"><font face="Tahoma">ราคา/หน่วย </font></td>
<td bordercolor="#FFFFCC"><font color="#0000FF" size="2" face="Tahoma">
<input name="Price" type="text" id="Price" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$rs->Price;?>" size="10" />
</font><font size="2" face="Tahoma">บาท</font></td>
</tr>
<tr >
<td height="20" align="right" bordercolor="#CCCCCC"><font face="Tahoma">แหล่งเงิน </font></td>
<td bordercolor="#FFFFCC" ><font size="2" face="Tahoma"><strong><font color="#003366" size="2" face="Tahoma">
<select name="MoneyS_C" id="MoneyS_C">
<?php
$strSQL3 = " SELECT * FROM money_source_tb ";
$result3 = mysql_query($strSQL3);
while( $rss = mysql_fetch_array($result3) ) {
?>
<option value="<?=$rss['[MoneyS_C'];?>" <?php if( $rss['[MoneyS_C']==$rs->MoneyS_C ) echo 'selected'; ?> >
<?=$rss['MoneyS_M'];?>
</option>
<?php
} # while
?>
</select>
</font></strong></font></td>
</tr>
<tr>
<td height="83" align="right" bordercolor="#CCCCCC"><font face="Tahoma">รายละเอียด </font></td>
<td bordercolor="#FFFFCC"><textarea name="Description" cols="50" rows="5" id="Description" class="input1"><?=$rs->Description;?>
</textarea></td>
</tr>
<tr >
<td align="right" ><font face="Tahoma">อัปโหลดรูปภาพ </font></td>
<td ><table width="88%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="73%" height="100"><div align="center">
<input name="Img1" type="file" id="Img1" onchange="browse()" />
</div></td>
<td width="27%"><div align="center"><img src=" " name="Img1" width="100" height="100" id="Img1" /></div></td>
</tr>
</table></td>
</tr>
<tr >
<td align="right" > </td>
<td > </td>
</tr>
<tr >
<td align="right" > </td>
<td ><input name="Submit" type="submit" class="button" id="Submit" value="บันทึกข้อมูล" />
<input name="Submit" type="reset" class="button" id="Submit" value="เคลียร์ข้อมูล" />
<input name="CarmoId" type="hidden" id="CarmoId" value="<?=$rs->CarmoId; ?>" /></td>
</tr>
<tr >
<td align="right" ><p> </p></td>
<td ><p> </p></td>
</tr>
</table>
<p> </p>
<table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
</tr>
</table>
<br /></td></tr>
</form>
</table>
</fieldset></td>
</tr>
</table>
<?php include("../templates/incFooter.php"); ?>
</body>
</html>
<?php
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?>
|