Viewing file:  EditReport.php (2.43 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;
//=== SESSION
$Username = $valid_user;
//### Upload Image File
/*
if( $_FILES['Filename']['name'] != "" ) {
$Filename = $_FILES['Filename']['name'];
@copy( $_FILES['Filename']['tmp_name'] , $Path."/".$Filename );
@unlink( $_FILES['Filename']['tmp_name'] );
*/
if( $_FILES['Filename']['name'] != "" ) {
//ลบไฟล์เอกสารเดิม
$query1 = "select Filename from project_report_tb Where proRpId='$proRpId' ";
$result1 = mysql_query($query1);
$rs = mysql_fetch_array($result1);
if(!empty($rs["Filename"])) unlink($QAPicPath.$rs["Filename"]);
$dbObj->freeresult($result1);
//Upload ไฟล์เอกสารใหม่
//$Filetex = $_FILES['Filetex']['name'];
$Filename = date('YmdHis').strrchr($_FILES['Filename']['name'], ".");
@copy( $_FILES['Filename']['tmp_name'] , $QAPicPath.$Filename );
@unlink( $_FILES['Filename']['tmp_name'] );
$strSQL ="UPDATE project_report_tb SET codeNo='$codeNo', Report_name='$Report_name', Filename='$Filename' WHERE proRpId='$proRpId' ";
}
else {
$strSQL ="UPDATE project_report_tb SET codeNo='$codeNo', Report_name='$Report_name' WHERE proRpId='$proRpId' ";
}
$result = $dbObj->runQuery($strSQL);
$dbObj->freeresult($result);
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-874\" />";
echo "<script>alert('บันทึกข้อมูลเรียบร้อยแล้ว');</script>";
echo "<script>window.opener.document.all.myForm; window.opener.location.reload(); window.close();</script>";
exit();
} # else
?>
|