Viewing file:  InsertSalaryN.php (5.82 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
if (session_is_registered("valid_user"))
{
$Username = $valid_user;
include("../include/FunctionDB.php");
include("../include/Function.php");
ConnectDB();
$Flag = true;
$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_salary = htmlspecialchars(trim($Costt_salary));
//$Costt_to = htmlspecialchars(trim($Costt_to));
$Start_mont = htmlspecialchars(trim($Start_mont));
$Start_year = htmlspecialchars(trim($Start_year));
//$Start_date = $_POST['mYear']."-".$_POST['mMonth']."-".$_POST['mDate'];
$Costt_1_temp1 = $Costt_1;
$Costt_2_temp2 = $Costt_2;
$Costt_3_temp3 = $Costt_3;
$Costt_4_temp4 = $Costt_4;
$Costt_5_temp5 = $Costt_5;
$Costt_6_temp6 = $Costt_6;
$Costt_7_temp7 = $Costt_7;
$Salary_1_temp8 = $Salary_1;
$Salary_2_temp9 = $Salary_2;
$Salary_3_temp10 = $Salary_3;
$Costt_salary = $Costt_1_temp1+ $Costt_2_temp2 + $Costt_3_temp3 + $Costt_4_temp4 + $Costt_5_temp5 + $Costt_6_temp6 + $Costt_7_temp7 + $Salary_1_temp8 + $Salary_2_temp9 + $Salary_3_temp10;
/////insert
$Costt_8_temp8 = $Costt_8;
$Costt_9_temp9 = $Costt_9;
$Costt_10_temp10 = $Costt_10;
$Costt_11_temp11 = $Costt_11;
$Costt_12_temp12 = $Costt_12;
$Costt_13_temp13 = $Costt_13;
$Costt_14_temp14 = $Costt_14;
$Costt_15_temp15 = $Costt_15;
$Costt_16_temp16= $Costt_16;
$Costt_17_temp17 = $Costt_17;
$Costt_18_temp18 = $Costt_18;
$Costt_19_temp19 = $Costt_19;
$Costt_to = $Costt_8_temp8 + $Costt_9_temp9 + $Costt_10_temp10 + $Costt_11_temp11 + $Costt_12_temp12 + $Costt_13_temp13 + $Costt_14_temp14 + $Costt_15_temp15 + $Costt_16_temp16 + $Costt_17_temp17 + $Costt_18_temp18 + $Costt_19_temp19;
///// Costt - Coo
$Costt_salary_temp1 = $Costt_salary;
$Costt_to_temp2 = $Costt_to;
$Costt_total = $Costt_salary_temp1 - $Costt_to_temp2;
///////////////////// check name
//if ($ =="")
//{
//$msg .="<li>กรุณากรอก ชั้นเครื่องราช";
//$button ="<input type=\"button\" value=\"Back to Edit\" onclick=\"history.back();\" style=\"font-weight:bold;color:#FFF;background-color:#036;border-style:outset;border-color:#69F;font-family:Tohoma;\">";
//$Flag = false;
//}
/////////////////////// Check Address//////
if( $Flag)
{
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_salary,$Costt_to,$Costt_total,$Flag);
$msg.="<li>ระบบจัดเก็บข้อมูลเรียบร้อยแล้ว";
// echo"<meta http-equiv=\"refresh\" content=\"2;URL=AddMony.php?Teacher_code=$Teacher_code\">\n";
echo"<center>";
// echo"<center><font face=\"Tahoma\"size=\"6\" color=\"#FF0000\">ระบบจัดเก็บข้อมูลเรียบร้อยแล้ว</font></center>";
echo "<br><font face=\"Tahoma\" Size=\"2\" color=\"#FF0000\">กรุณา refresh หน้ารายการอีกครั้ง</font>";
echo "<br><input type=\"reset\" value=\"Close Windows\" onclick=\"javascript:parent.close();\" style=\"font-weight:bold;color:font-family:Tohoma;\">";
echo"</center>";
}
CloseDB();
?>
<html>
<head>
<title>ระบบข้อมูลการเงิน</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link href="../css/style1.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0"marginwidth="0"marginheight="0">
<form>
<br>
<table width="68%" border="0" cellspacing="0"cellpadding="2"align="center">
<tr>
<td> </td>
</tr>
<tr>
<td>
<table width="74%" border="1" cellspacing="0"cellpadding="2"align="center"bordercolor="#999999" class="table">
<tr>
<td bgcolor="#F3D6F2">
<div align="center"><b><font color="#CC0000" size="4" face="Tahoma">ระบบแจ้งการทำงาน</font></b></div></td>
</tr>
<tr>
<td bgcolor="#000000">
<table width="90%" border="0" cellspacing="0"cellpadding="2"align="center">
<tr>
<td><span><b><font color="#FFFFFF"><?php echo $msg;?></font></b></span></td>
</tr>
</table>
</td>
</tr>
<tr>
<td bgcolor="#F3D6F2">
<div align="center"><b><font color="#CCFF00"><?php echo $button;?></font></b></div></td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<br>
</form>
</body>
</html>
<?php
}
else
{
echo"<body bgcolor=\"#CCCCCC\">";
echo"<meta http-equiv=\"refresh\" content=\"3;URL=../logout.php\" target=\"mainFrame\">\n";
echo"<center>";
echo"<br><br><br><b><font face=\"Tahoma\" size=\"4\" color=\"#FF0000\">Please Login</font> </b><br>";
echo"<br><br><font face=\"Tahoma\" size=\"10\" color=\"#000000\"> ERROR 404 PERMISION DENY</font><br>";
echo"<br><font face=\"Tahoma\" size=\"4\" color=\"#000000\"> คุณไม่มสิทธ์ใช้งาน</font>";
echo"</center>";
echo"</body>";
}
?>
|