Viewing file: EditSalarySave.php (4.96 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" );
/** Create Database Object */
$dbObj = new DBConn;
//### รับค่าจาก Form
$Teacher_code = htmlspecialchars(trim($Teacher_code));
$Teacher_id = htmlspecialchars(trim($Teacher_id));
$Salary_1 = htmlspecialchars(trim($Salary_1));
$Salary_2 = htmlspecialchars(trim($Salary_2));
$Salary_3 = htmlspecialchars(trim($Salary_3));
$Costt_1 = htmlspecialchars(trim($Costt_1));
$Costt_2 = htmlspecialchars(trim($Costt_2));
$Costt_3 = htmlspecialchars(trim($Costt_3));
$Costt_4 = htmlspecialchars(trim($Costt_4));
$Costt_5 = htmlspecialchars(trim($Costt_5));
$Costt_6= htmlspecialchars(trim($Costt_6));
$Costt_7 = htmlspecialchars(trim($Costt_7));
$Costt_8 = htmlspecialchars(trim($Costt_8));
$Costt_9 = htmlspecialchars(trim($Costt_9));
$Costt_10 = htmlspecialchars(trim($Costt_10));
$Costt_11 = htmlspecialchars(trim($Costt_11));
$Costt_12 = htmlspecialchars(trim($Costt_12));
$Costt_13 = htmlspecialchars(trim($Costt_13));
$Costt_14 = htmlspecialchars(trim($Costt_14));
$Costt_15 = htmlspecialchars(trim($Costt_15));
$Costt_16 = htmlspecialchars(trim($Costt_16));
$Costt_17 = htmlspecialchars(trim($Costt_17));
$Costt_18 = htmlspecialchars(trim($Costt_18));
$Costt_19 = htmlspecialchars(trim($Costt_19));
$Costt_20 = htmlspecialchars(trim($Costt_20));
$Costt_21 = htmlspecialchars(trim($Costt_21));
$Costt_22 = htmlspecialchars(trim($Costt_22));
$Costt_23 = htmlspecialchars(trim($Costt_23));
$Costt_24 = htmlspecialchars(trim($Costt_24));
$Costt_25 = htmlspecialchars(trim($Costt_25));
$Costt_26 = htmlspecialchars(trim($Costt_26));
$Costt_27 = htmlspecialchars(trim($Costt_27));
$Costt_28 = htmlspecialchars(trim($Costt_28));
$Costt_29 = htmlspecialchars(trim($Costt_29));
$Costt_30 = htmlspecialchars(trim($Costt_30));
$Start_mont = htmlspecialchars(trim($Start_mont));
$Start_year = htmlspecialchars(trim($Start_year));
///---------บวกด้านรายรับ--------------------///
$Costt_salary = $Costt_1+ $Costt_2 + $Costt_3 + $Costt_4 + $Costt_5 + $Costt_6 + $Costt_7 + $Costt_8 + $Costt_9 + $Costt_10 + $Costt_11 + $Costt_12 + $Costt_13 + $Costt_14 + $Costt_15 + $Salary_1 + $Salary_2 + $Salary_3;
/////----------บวกด้านรายจ่าย-------------////
$Costt_to = $Costt_16 + $Costt_17 + $Costt_18 + $Costt_19 + $Costt_20 + $Costt_21 + $Costt_22 + $Costt_23 + $Costt_24 + $Costt_25 + $Costt_26 + $Costt_27 + $Costt_28 + $Costt_29 + $Costt_30 ;
$Costt_total = $Costt_salary - $Costt_to ;
//### user_tb
$query1 = " UPDATE salary_repot_tb SET Start_mont='$Start_mont',Start_year='$Start_year',Salary_1='$Salary_1',Salary_2='$Salary_2',Salary_3='$Salary_3',Costt_1='$Costt_1',Costt_2='$Costt_2',Costt_3='$Costt_3',Costt_4='$Costt_4',Costt_5='$Costt_5',Costt_6='$Costt_6',Costt_7='$Costt_7',Costt_8='$Costt_8',Costt_9='$Costt_9',Costt_10='$Costt_10',Costt_11='$Costt_11',Costt_12='$Costt_12',Costt_13='$Costt_13',Costt_14='$Costt_14',Costt_15='$Costt_15',Costt_16='$Costt_16',Costt_17='$Costt_17',Costt_18='$Costt_18',Costt_19='$Costt_19',Costt_20='$Costt_20',Costt_21='$Costt_21',Costt_22='$Costt_22',Costt_23='$Costt_23',Costt_24='$Costt_24',Costt_25='$Costt_25',Costt_26='$Costt_26' ,Costt_27='$Costt_27' , Costt_28 ='$Costt_28' ,Costt_29='$Costt_29' , Costt_30='$Costt_30' , Costt_salary='$Costt_salary',Costt_to='$Costt_to',Costt_total='$Costt_total' Where Code='$Code' " ;
$result1 = $dbObj->runQuery($query1);
$dbObj->freeresult($result1);
/** 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=AccessList.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>Edit Password</title>
<link href="../css/default.css" rel="stylesheet" type="text/css" />
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
</body>
</html>
|