Viewing file:  InsertPidicator.php (3.85 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;
$num = count($piId);
for( $i=0; $i<$num; $i++ ) {
$query = " SELECT * FROM qa_result_tb WHERE indId = '$indId' and ProjectId = '$ProjectId' and piId ='$piId[$i]' ";
$result = mysql_query($query);
$rs = mysql_fetch_array($result);
$checkData = mysql_num_rows($result);
if($checkData) UpdatePidicator($rs['result_code'],$AcademicYear, $indId ,$ProjectId, $No, $elemId, $piId[$i], $_REQUEST["qaSuccess".$piId[$i]]);
else InsertPidicator($AcademicYear, $indId ,$ProjectId, $No, $elemId, $piId[$i], $_REQUEST["qaSuccess".$piId[$i]]);
}
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();
//### รับค่าจาก Form
//$stanCriteriaPI = htmlspecialchars(trim($_POST['stanCriteriaPI']));
//### user_tb
/*$checkid = 0;
$sql11 = " Select * From qa_result_tb Where indId='$indId' and projectId='$ProjectId' ";
$result11 = mysql_query($sql11);
while ($rs11 = mysql_fetch_array($result11)){
if ($rs11["projectId"] == $StrateId){
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{
$checkid = 1;
}
}
if ($check == 0){
InsertPidicator($AcademicYear, $indId ,$ProjectId, $No, $elemId, $piId, $qaSuccess) ;
$dbObj->disconn();
unset($dbObj);
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();
//}
//InsertSalaryType($SalaryId,$Detail,$SalaryStatus,$Flag);
/** Close the Database */
//$dbObj->disconn();
/** Unset Class */
//unset($dbObj);
/** Output */
//if( $result1 ) {
//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>";
//echo "<meta http-equiv='refresh' content='0; URL=DecorPersonalList.php'>";
exit();
*/
//}
} # 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" />
<title>-</title>
<link href="../css/default.css" rel="stylesheet" type="text/css" />
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
</body>
</html>
|