Viewing file: InsertSalary.php (4.47 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/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
//### รับค่าจาก Form
//$BuildD_Yr = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate'];
$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));
$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 + $Costt10 + $Salary_1 + $Salary_2 + $Salary_3;
/////----------บวกด้านรายจ่าย-------------////
$Costt_to = $Costt_11 + $Costt_12 + $Costt_13 + $Costt_14 + $Costt_15 + $Costt_16 + $Costt_17 + $Costt_18 + $Costt_19 + $Costt_20 + $Costt_21 + $Costt_22 + $Costt_23 + $Costt_24 + $Costt_25 ;
$Costt_total = $Costt_salary - $Costt_to ;
/** Table --> */
Insert_Salary_repot ($Teacher_code,$Teacher_id,$StatusId,$Faculty_code,$Person_type,$Start_mont,$Start_year,$Salary_1,$Salary_2,$Salary_3,$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, $Costt_16,$Costt_17,$Costt_18,$Costt_19,$Costt_20,$Costt_21,$Costt_22,$Costt_23,$Costt_24,$Costt_25,$Costt_salary,$Costt_to,$Costt_total,$Flag);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
echo "";
echo "";
echo "";
exit();
//InsertSalaryType($SalaryId,$Detail,$SalaryStatus,$Flag);
/** Close the Database */
//$dbObj->disconn();
/** Unset Class */
//unset($dbObj);
/** Output */
//if( $result1 ) {
//echo "";
/*echo "";
echo "";
//echo "";
exit();
*/
}
//} # else
?>
Edit Password
|