Viewing file: EditMoney.php (5.5 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/Function.php" );
require_once( "../includes/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
/** Config Table for This Page */
$myTable1 = "personal_tb";
$myTable2 = " formofficemoney";
$myTable2PK = "proId";
$Teacher_code = $_POST['Teacher_code'];
$With = $_POST['With'];
$maNo = trim( $_POST['maNo'] );
//$Date = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate'];
$Date = dmyE2ymdT($_REQUEST['mDate']);
$Date_start = dmyE2ymdT($_REQUEST['mDate1']);
$Date_finish = dmyE2ymdT($_REQUEST['mDate2']);
$Training_name = trim( $_POST['Training_name'] ); //ขออนุมัติ
$Year_std = trim( $_POST['Year_std'] ); //
/*-----------------*/
$Budget_use = $Smtotal + $STtotal + $Vehicletotal +$Crgestotal ;
$sql = "SELECT * FROM formofficemoney Where maNo='$maNo' and monId='$monId' and Flag='$Flag' ";
$result1 = mysql_query($sql);
$num_rows = mysql_num_rows($result1);
if($num_rows){
if($Filetex){
$query1 = " UPDATE formofficemoney SET codeId='$codeId', Training_code='$Training_code' , WithMon='$WithMon' , Training_name='$Training_name' , Date='$Date' , Date_start='$Date_start' , Date_finish='$Date_finish' , Day ='$Day', MOut='$MOut' , MInput='$MInput' , Time_start='$Time_start' , Time_finish='$Time_finish' , Hour='$Hour' , Minute='$Minute' , SMDay='$SMDay', Smtotal='$Smtotal' , ST='$ST' , STDay='$STDay' , STtotal='$STtotal' , Vehicle1='$Vehicle1' , Vehicle2='$Vehicle2' , Vehicle3='$Vehicle3' , Vehicle4='$Vehicle4' ,Vehicle5='$Vehicle5' , Vehicletotal='$Vehicletotal' , Crges1='$Crges1' ,Crges2='$Crges2', Crges3='$Crges3', Crgestotal ='$Crgestotal' , Budget_use='$Budget_use' ,Document='$Document' , provinceId='$provinceId' , Filetext='$Filetext' , Year_std ='$Year_std' Where maNo='$maNo' and monId='$monId' and Flag='$Flag' ";
}
else{
$query1 = " UPDATE formofficemoney SET codeId='$codeId', Training_code='$Training_code' , WithMon='$WithMon' , Matter='$Matter', Training_name='$Training_name' , Date='$Date' , Date_start='$Date_start' , Date_finish='$Date_finish' , Day='$Day', MOut='$MOut' , MInput='$MInput' , Time_start='$Time_start' , Time_finish='$Time_finish' , Hour='$Hour' , Minute='$Minute' , SMDay='$SMDay', Smtotal='$Smtotal' , ST='$ST' , STDay ='$STDay' , STtotal='$STtotal' , Vehicle1='$Vehicle1' , Vehicle2='$Vehicle2' , Vehicle3='$Vehicle3' , Vehicle4='$Vehicle4' ,Vehicle5='$Vehicle5' , Vehicletotal='$Vehicletotal' , Crges1='$Crges1' ,Crges2='$Crges2', Crges3='$Crges3', Crgestotal ='$Crgestotal' , Budget_use='$Budget_use' ,Document='$Document' , provinceId='$provinceId' , Year_std ='$Year_std' Where maNo='$maNo' and monId='$monId' and Flag='$Flag' ";
}
$result1 = $dbObj->runQuery($query1);
$dbObj->freeresult($result1);
}
} # else
?>
MIS -- Teacher
freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?> |