Viewing file:  EditProduct.php (5.19 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
";
echo "
กรุณาทำการ Login ก่อน
";
echo "";
exit();
}
else {
/** Configuration */
require_once( "../configuration.php" );
require_once( $_Config_absolute_path . "/includes/framework.php" );
require_once( "../include/Function.php" );
require_once( "../include/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
/** Receive values */
$Date_start = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate']; // วัน/เดือน/ปีที่เริ่ม
$Date_finish = $_POST['mYear2']."-".$_POST['mMonth2']."-".$_POST['mDate2']; // ปีที่แล้วเสร็จ
$Term = $mYear2;
//ปีการศีกษา
if ($_POST[mMonth2] <= 5 and $_POST[mMonth2] != 0) $academic_year_finish = $_POST[mYear2]-1 ;
if ($_POST[mMonth2] >= 6 and $_POST[mMonth2] != 0) $academic_year_finish = $_POST[mYear2];
//บวกจำนวนเงินที่ใช้จริง
$FundUse = $FundIn - $FundOut ;
if( $_FILES['Filetex']['name'] != "" ) {
//ลบไฟล์เอกสารเดิม
$query1 = "select Filetex from edu_product_tb Where Prod_code ='$Prod_code' ";
$result1 = mysql_query($query1);
$rs = mysql_fetch_array($result1);
if(!empty($rs["Filetex"])) unlink($ResearchPicPath.$rs["Filetex"]);
$dbObj->freeresult($result1);
//Upload ไฟล์เอกสารใหม่
$Filetex = date('YmdHis').strrchr($_FILES['Filetex']['name'], ".");
@copy( $_FILES['Filetex']['tmp_name'] , $ResearchPicPath.$Filetex );
@unlink( $_FILES['Filetex']['tmp_name'] );
$query1 = "UPDATE edu_product_tb SET Product_name='$Product_name',Date_start='$Date_start',Date_finish='$Date_finish',Term='$Term',Year_prop='$Year_prop',Product_type='$Product_type',name1='$name1',name2='$name2',name3='$name3',name4='$name4',name5='$name5',name6='$name6',name7='$name7',Filetex='$Filetex',Fund_resource='$Fund_resource',Fund='$Fund',Propagate='$Propagate',Benefit='$Benefit',Use_ref='$Use_ref' ,Filetex='$Filetex' WHERE Prod_code ='$Prod_code' ";
}
else {
$query1 = " UPDATE edu_product_tb SET Product_name='$Product_name',Date_start='$Date_start',Date_finish='$Date_finish',Term='$Term',Year_prop='$Year_prop',Product_type='$Product_type',name1='$name1',name2='$name2',name3='$name3',name4='$name4',name5='$name5',name6='$name6',name7='$name7',Fund_resource='$Fund_resource',Fund='$Fund',Propagate='$Propagate',Benefit='$Benefit',Use_ref='$Use_ref' WHERE Prod_code ='$Prod_code' ";
}
$result1 = $dbObj->runQuery($query1);
$dbObj->freeresult($result1);
} # else
?>
ข้อมูลทั่วไปบุคลากร - ข้อมูลแผนการสอน - แก้ไขประวัติผลงานวิจัย
freeresult($result1);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?>
bool(false)
|