Viewing file: AddConAcc.php (5.45 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") ) {
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/FunctionDB.php");
/** Create Database Object */
$dbObj = new DBConn;
$msg = " ";
$reload = "";
if ( !empty($NameCont_y ) )
{
$sell_name = ereg_replace ("\"",""" ,"$NameCont_y");
$query = "SELECT * FROM accessories_cont WHERE accContId ='$accContId' ";
$result1 = $dbObj->execQuery($query);
$rs = $dbObj->fetchArray($result1);
$num_rows = mysql_num_rows($result1);
if($num_rows){
$query1 = " UPDATE accessories_cont SET NameCont_y ='$NameCont_y' , NameCont_n ='$NameCont_n' , Acc_type_code ='$Acc_type_code' WHERE accContId='$accContId' ";
$result1 = $dbObj->runQuery($query1);
$dbObj->freeresult($result1);
}
else{
InsertAccCont ( $Acc_type_code, $NameCont_y, $NameCont_n ) ;
}
$msg = "<font color=\"#FF0000\"><strong> เพิ่มข้อมูลผู้ขายหรือบริจาค '<font color=\#0000FF\"> $sell_name </font>' COMPLETE</Strong></font> ";
$reload = "<script language=\"JavaScript\">\n";
$reload = $reload."parent.frames.nav.location.reload();\n";
$reload = $reload."</script>";
echo "<script>window.opener.document.all.form1; window.opener.location.reload(); window.close();</script>";
//echo "<meta http-equiv=\"refresh\"content=\"2;URL=AddSource.php\">\n";
}
else {
$msg = "<font color=\"#FF0000\"><strong>ยังไม่ได้กรอกข้อมูลประเภทห้อง </Strong></font> ";
}
$query = " SELECT * FROM accessories_cont WHERE accContId='$accContId' ";
$result = $dbObj->execQuery($query);
$rs = $dbObj->fetchArray($result);
} #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><?=$_Config_sitename;?></title>
</script>
<script language ="javascript">
function check()
{
if(document.form1.NameCont_y.value == "")
{
alert('กรุณากรอกหมวดวัสดุ');
document.form1.NameCont_y.focus();
return false;
}
if(document.form1.NameCont_n.value == "")
{
alert('กรุณากรอกหมวดครุภัณฑ์');
document.form1.NameCont_n.focus();
return false;
//}
//if(isNaN(document.form1.sell_tel.value))
//{
// alert("กรุณากรอกเบอร์โทรศัพท์เป็นตัวเลขเท่านั้น!!");
// document.form1.Phone.focus();
return false;
}
else
{
document.form1.submit();
}
}
</script>
<table width="524" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="524" height="126">
<form id="form1" name="form1" method="post" action="<? echo $PHP_SELF; ?>">
<table width="98%" border="0" align="center" cellpadding="1" cellspacing="1" style="background-color:#eeeeee; border:0px solid gray; font-size: 14px;"size="12">
<tr bgcolor="#F3F3F3">
<td height="21" colspan="2" align="center" bordercolor="#CCCCCC" bgcolor="#FFFFFF" valign="middle"><h3><b>บันทึกหมวดวัสดุครุภัณฑ์</b></h3></td>
</tr>
<tr bgcolor="#F3F3F3">
<td width="27%" height="22" align="right" bgcolor="#FFFFFF" class="style2">รายการหมวดวัสดุ : </td>
<td width="73%" bordercolor="#FFFFCC" bgcolor="#FFFFFF"><input name="NameCont_y" type="text" size="50" value="<?=$rs['NameCont_y'];?>" id="NameCont_y" /> *</td>
</tr>
<tr bgcolor="#F3F3F3">
<td align="right" height="22" bgcolor="#FFFFFF" class="style2">รายการหมวดครุภัณฑ์ : </td>
<td width="73%" bordercolor="#FFFFCC" bgcolor="#FFFFFF">
<input name="NameCont_n" type="text" id="NameCont_n" value="<?=$rs['NameCont_n'];?>" size="50"> *</td>
</tr>
<tr bgcolor="#F3F3F3">
<td height="19" colspan="2" bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
</tr>
<tr bgcolor="#F3D6F2">
<td colspan="2" align="center" bgcolor="#FFFFFF">
<input name="Submit" type="submit" class="WIDTH60" id="Submit" value="บันทึก" onclick="return(check())" />
<input name="Reset" type="reset" class="WIDTH60" id="Reset" value="Reset" />
<input type="button" name="Submit" value="ปิดหน้าต่าง" onclick="javascript:parent.close();" class="CURSOR-HAND" id="Submit" />
<input name="accContId" type="hidden" id="accContId" value="<?=$rs['accContId'];?>" />
<input name="Acc_type_code" type="hidden" id="Acc_type_code" value="<?=$Acc_type_code ;?>" /></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
|