Viewing file: InsertSalary.php (4.94 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 = trim( $Teacher_code );
$Teacher_id = trim( $Teacher_id );
$Salary_1 = trim( $Salary_1 );
$Salary_2 = trim( $Salary_2 );
$Salary_3 = trim( $Salary_3 );
$Costt_1 = trim( $Costt_1 );
$Costt_2 = trim( $Costt_2 );
$Costt_3 = trim( $Costt_3 );
$Costt_4 = trim( $Costt_4 );
$Costt_5 = trim( $Costt_5 );
$Costt_6= trim( $Costt_6 );
$Costt_7 = trim( $Costt_7 );
$Costt_8 = trim( $Costt_8 );
$Costt_9 = trim( $Costt_9 );
$Costt_10 = trim( $Costt_10 );
$Costt_11 = trim( $Costt_11 );
$Costt_12 = trim( $Costt_12 );
$Costt_13 = trim( $Costt_13 );
$Costt_14 = trim( $Costt_14 );
$Costt_15 = trim( $Costt_15 );
$Costt_16 = trim( $Costt_16 );
$Costt_17 = trim( $Costt_17 );
$Costt_18 = trim( $Costt_18 );
$Costt_19 = trim( $Costt_19 );
$Start_mont = trim( $Start_mont );
$Start_year = trim( $Start_year );
///---------บวกด้านรายรับ--------------------///
$Costt_salary = $Costt_1+ $Costt_2 + $Costt_3 + $Costt_4 + $Costt_5 + $Costt_6 + $Costt_7 + $Costt_8 + $Costt_9 + $Costt10 + $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 ;
//### Select ข้อมูลมาก่อน เพื่อเปรียบเทียบว่ามีข้อมูลอยู่แล้วหรือไม่
$sql = "Select * From salary_repot_tb Where Teacher_code='$Teacher_code' AND Start_mont='$Start_mont' AND Start_year='$Start_year' ";
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
if( $numrows == 0 ) {
//echo "Insert";
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_26 , $Costt_27, $Costt_28, $Costt_29, $Costt_30, $Costt_salary , $Costt_to , $Costt_total , $Flag );
echo "";
echo "";
} else {
//echo "Update";
echo "";
echo "";
}
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
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();
}
*/
} // end.. else
//} # else
?>
Insert Salary
|