Software: Apache/2.2.3 (CentOS). PHP/5.1.6 uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44 uid=48(apache) gid=48(apache) groups=48(apache) Safe-mode: OFF (not secure) /var/www/html/manage_22222/teacher/ drwxr-xr-x | |
| Viewing file: Select action/file-type: <?php
session_start();
/** Define Validate Access */
define( '_VALID_ACCESS', 1 );
/** Check Session User Login */
if( !session_is_registered("valid_user") && !session_is_registered("Priority") ) {
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" );
require_once( "../include/Function.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
/** Config Table for This Page */
$myTable1 = "personal_tb";
$myTable2 = "project_type_tb";
/** Table --> personal_tb */
$query00 = " SELECT * FROM $myTable1 WHERE Username='$Username' ";
$result00 = $dbObj->execQuery($query00);
$rs00 = $dbObj->fetchObject($result00);
$Teacher_code = $rs00->Teacher_code;
$query = " SELECT * FROM $myTable2
WHERE Faculty_code='$Faculty_code' AND Budget_Year='$Budget_Year' AND ProjectId='$ProjectId' ";
$result = $dbObj->execQuery($query);
$rs = $dbObj->fetchArray($result);
} # 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" />
<link href="../css/default.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="../js/utilities.js"></script>
<script language="javascript">
function checkData() {
var formObj = document.myForm;
if( (formObj.Training_name.value == "" ) && (formObj.Ind.value == "" ) && (formObj.Budget_use.value == "" ) && (formObj.mYear.value == "" ) ) { alert("กรุณากรอกข้อมูลให้ครบ" ); formObj.Training_name.style.backgroundColor='#F1F9FC'; formObj.Training_name.focus(); return false; }
else if(formObj.Training_name.value == "" ) { alert("กรุณากรอก รายละเอียดของแผนดำเนินการ"); formObj.Training_name.style.backgroundColor='#F1F9FC'; formObj.Training_name.focus(); return false; }
else if(formObj.Ind.value == "" ) { alert("กรุณากรอก ตัวบงชี้ตาม QA"); formObj.Ind.style.backgroundColor='#F1F9FC'; formObj.Ind.focus(); return false; }
else if(formObj.Budget_use.value == "" ) { alert("กรุณากรอก จำนวนเงินที่ใช้"); formObj.Budget_use.style.backgroundColor='#F1F9FC'; formObj.Budget_use.focus(); return false; }
else if(formObj.mYear.value == "" ) { alert("กรุณากรอก วัน/เดือน/ปี ที่ดำเนินการ"); formObj.mYear.style.backgroundColor='#F1F9FC'; formObj.mYear.focus(); return false; }
else return true;
}
</script>
<title>ข้อมูลทั่วไปบุคลากร - ข้อมูลการแผนดำเนินการ - ข้อมูลแผนดำเนินการรายปี</title>
</head>
<body topmargin="0" rightmargin="0" bottommargin="0" leftmargin="0">
<?php
include("../templates/incHeader.php");
?>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="203" align="left" valign="top" style="padding:10px 0px 0px 5px"><?php include("./_incMainMenu.php");?></td>
<td width="800" height="440" align="center" valign="top" style="padding:10px 0px 5px 10px"><fieldset>
<table width="780" border="0" cellspacing="0" cellpadding="0">
<form id="myForm" name="myForm" method="post" action="InsertPlaningIn.php" onSubmit="return checkData();">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="30" background="../images/background/bg-head-topic-w780.gif" class="PADDING-LEFT-10"><strong><a href="index.php">หน้าหลัก</a></strong> <strong>» <a href="Menu_Teach.php">ข้อมูลทั่วไปบุคลากร</a> » <a href="PlaningByYear.php??Teacher_code=<?=$Teacher_code;?>&Faculty_code=<?=$Faculty_code;?>">ข้อมูลการแผนดำเนินการ</a> » <a href="PlanStdList.php?Teacher_code=<?=$Teacher_code;?>&Budget_Year=<?=$Budget_Year;?>&Faculty_code=<?=$Faculty_code;?>">ข้อมูลแผนดำเนินการรายปี</a></strong> <strong>» </strong> <a href="PlaningList.php?Teacher_code=<?=$Teacher_code;?>&Budget_Year=<?=$Budget_Year;?>&Faculty_code=<?=$Faculty_code;?>&Project_code=<?=$Project_code;?>">
<strong><?php
$sql2 = " SELECT * FROM projectstdplan_tb WHERE Project_code='$Project_code' ";
$result2 = $dbObj->execQuery($sql2);
$rs2 = $dbObj->fetchArray($result2);
echo $rs2['Project_plan'];
?></strong></a></td>
</tr>
<tr>
<td align="center">
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
<tr>
<td> <a href="DetailRepPlaning.php?ProjectId=<? echo $rs[ProjectId]?>&Project_code=<? echo $rs[Project_code]?>&Faculty_code=<? echo $rs[Faculty_code]?>&Teacher_code=<? echo $rs1[Teacher_code]?> ">รายงานการใช้เงินตามข้อย่อยแผน</a> » <span class="TEXT-GREEN10">เพิ่มข้อมูลแผน/โครงการดำเนินการ (ข้อย่อย)</span></td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" style=" border:0px solid gray"size="12">
<tr>
<td height="43"><table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bordercolor="#E0E0E0" bgcolor="#E0E0E0" style="border:1px solid #CCCCCC">
<tr bgcolor="#EEEEEE">
<td height="10" colspan="3" bgcolor="#FFFFFF"></td>
</tr>
<tr bgcolor="#EEEEEE">
<td width="26%" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">รหัสหน่วยงาน</font></td>
<td width="1%" bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td width="73%" bordercolor="#006699" bgcolor="#FFFFFF"><font color="#0033CC" size="2" face="Tahoma">
<?php
$Faculty_code = $rs["Faculty_code"];
$sql = " SELECT * FROM faculty_tb WHERE Faculty_code='$Faculty_code' ";
$result1 = mysql_query($sql);
$rss = mysql_fetch_array($result1);
echo "$rss[Faculty_code] - $rss[Faculty_name]";
?>
</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">รหัสแผน</font></td>
<td bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td bordercolor="#006699" bgcolor="#FFFFFF"><font color="#0033CC" size="2" face="Tahoma"><? echo $rs[Orderlist];?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#000066" face="Tahoma">ชื่อแผนงานโครงการ</font></td>
<td bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td bordercolor="#006699" bgcolor="#FFFFFF"><font color="#0033CC" size="2" face="Tahoma"><? echo $rs[Project_plan];?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">วัตถุประสงค์</font></td>
<td bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td bordercolor="#006699" bgcolor="#FFFFFF"><font color="#0033CC" size="2" face="Tahoma"><? echo $rs[Orderlist_2];?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="32" valign="top" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#000066" face="Tahoma">รายละเอียดของแผนดำเนินการ</font> <span class="TEXT-RED10">*</span></td>
<td bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td valign="top" bordercolor="#006699" bgcolor="#FFFFFF"><font color="#0000FF" size="2" face="Tahoma">
<textarea name="Training_name" cols="80" id="Training_name"></textarea>
</font></td>
</tr>
<tr bordercolor="#99CCFF">
<td height="25" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">หลักสูตร</font></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF"><select name="programId" id="programId">
<?php
$strSQL = " SELECT * FROM Program WHERE programStatus ='Y' ";
$result1 = mysql_query($strSQL);
while( $rss = mysql_fetch_array($result1) )
{
echo"<option value=\"$rss[programId]\" ><b>$rss[programName]</b></option>\n";
}
?>
</select>
<font color="#003366" face="Tahoma">ปี <input name="Year" type="text" id="Year" size="5" maxlength="4" style="text-align:center" /></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="30" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">หมวดเงิน</font> <span class="TEXT-RED10">*</span></td>
<td bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td bordercolor="#006699" bgcolor="#FFFFFF"><select name="MoneyS_C" id="MoneyS_C">
<?php
$MoneyS_C = $rs['MoneyS_C'];
$strSQL1 = " SELECT * FROM money_source_tb WHERE MoneyS_C='$MoneyS_C' ";
$result1 = mysql_query($strSQL1);
$strSQL2 = " SELECT * FROM money_source_tb ORDER BY MoneyS_C ";
$result2 = mysql_query($strSQL2);
while( $rs1 = mysql_fetch_array($result1) )
{
echo"<option value=\"$rs1[MoneyS_C]\" ><b>$rs1[MoneyS_M]</b></option>\n";
while( $rs2 = mysql_fetch_array($result2) )
{
echo"<option value=\"$rs2[MoneyS_C]\" ><b>$rs2[MoneyS_M]</b></option>\n";
}
}
?>
</select></td>
</tr>
<tr bgcolor="#EEEEEE">
<td bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">ประเภทหมวดค่าใช้จ่าย</font> <span class="TEXT-RED10">*</span></td>
<td bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td bordercolor="#006699" bgcolor="#FFFFFF"><select name="MoneyId" id="MoneyId">
<?php
//$MoneyId = $rs[MoneyId];
$strSQL2 = " SELECT * FROM money_tb ";
$result2 = mysql_query($strSQL2);
while( $rs2 = mysql_fetch_array($result2) )
{
echo"<option value=\"$rs2[MoneyId]\" ><b>$rs2[MoneyName]</b></option>\n";
}
?>
</select></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="27" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">วันที่เริ่มดำเนินการ</font></td>
<td bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF">วันเริ่มต้น <font color="#0033CC" size="2" face="Tahoma"><?php echo $rs['Date_start'];?></font> วันสิ้นสุด <font color="#0033CC" size="2" face="Tahoma"><?php echo $rs['Date_finish'];?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">ปีงบประมาณ พ.ศ.</font></td>
<td bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td bordercolor="#006699" bgcolor="#FFFFFF"><font color="#0033CC" size="2" face="Tahoma"><? echo $rs['Budget_Year'];?></font></td>
</tr>
<tr bgcolor="#F8F8F8">
<td height="127" valign="top" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">จำนวนเงินที่ตั้งงบประมาณรายเดือน</font></td>
<td> </td>
<td><table width="100%" border="0" align="center" cellpadding="1" cellspacing="0">
<tr>
<th width="120" bgcolor="#F8F8F8" class="TEXT-BLUE10" scope="col">มกราคม</th>
<th width="150" bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['January']?></font></th>
<th width="120" bgcolor="#F8F8F8" scope="col"><font face="Tahoma" class="TEXT-BLUE10">กรฏาคม</font></th>
<th width="153" bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['July']?></font></th>
</tr>
<tr>
<th bgcolor="#F8F8F8" class="TEXT-BLUE10" scope="col">กุมภาพันธ์</th>
<th bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['February']?></font></th>
<th bgcolor="#F8F8F8" scope="col"><font face="Tahoma" class="TEXT-BLUE10">สิงหาคม</font></th>
<th bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['Augus']?></font></th>
</tr>
<tr>
<th bgcolor="#F8F8F8" class="TEXT-BLUE10" scope="col">มีนาคม</th>
<th bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['March']?></font></th>
<th bgcolor="#F8F8F8" scope="col"><font face="Tahoma" class="TEXT-BLUE10">กันยายน</font></th>
<th bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['September']?></font></th>
</tr>
<tr>
<th bgcolor="#F8F8F8" class="TEXT-BLUE10" scope="col">เมษายน</th>
<th bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['April']?></font></th>
<th bgcolor="#F8F8F8" scope="col"><font face="Tahoma" class="TEXT-BLUE10">ตุลาคม</font></th>
<th bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['October']?></font></th>
</tr>
<tr>
<th bgcolor="#F8F8F8" class="TEXT-BLUE10" scope="col">พฤษภาคม</th>
<th bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['May']?></font></th>
<th bgcolor="#F8F8F8" scope="col"><font face="Tahoma" class="TEXT-BLUE10">พฤศจิกายน</font></th>
<th bgcolor="#F8F8F8" scope="col"> <font color="#0033CC" face="Tahoma"><? echo $rs['November']?></font></th>
</tr>
<tr>
<th height="20" bgcolor="#F8F8F8" class="TEXT-BLUE10" scope="col">มิถุนายน</th>
<th bgcolor="#F8F8F8" scope="col"><font color="#0033CC" face="Tahoma"><? echo $rs['June']?></font></th>
<th bgcolor="#F8F8F8" scope="col"><font face="Tahoma" class="TEXT-BLUE10">ธันวาคม</font></th>
<th bgcolor="#F8F8F8" scope="col"><font color="#0033CC" face="Tahoma"><? echo $rs['December']?></font></th>
</tr>
<tr>
<th height="20" colspan="4" align="center" bgcolor="#F8F8F8" scope="col"><font color="#003366" face="Tahoma">ยอดรวมจำนวนเงินทั้งหมด </font> <span align="center"><strong><font color="#0033CC" face="Tahoma"><? echo number_format($rs['Budget_use'],2,'.',','); ?></font> <font color="#003366" face="Tahoma">บาท</font></strong></span></th>
</tr>
</table></td>
</tr>
<tr bgcolor="#eeeeee">
<td height="25" bordercolor="#99CC99" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">ผู้รับใช้เงิน </font> <span class="TEXT-RED10">*</span></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"><select name="Teacher_code" id="Teacher_code">
<?php
$strSQL1 = " SELECT * FROM personal_tb Order by Teacher_name ";
$result1 = mysql_query($strSQL1);
while( $rs1 = mysql_fetch_array($result1) )
{
echo"<option value=\"$rs1[Teacher_code]\" ><b>$rs1[Teacher_name] $rs1[Teacher_lastname]</b></option>\n";
}
?>
</select></td>
</tr>
<tr bgcolor="#eeeeee">
<td height="25" bordercolor="#99CC99" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">ตัวบงชี้ตาม QA ข้อที่ </font> <span class="TEXT-RED10">*</span></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"><strong><font color="#003366" size="2" face="Tahoma">
<input name="Ind" type="text" id="Ind" size="8" maxlength="10" />
</font></strong></td>
</tr>
<tr bgcolor="#eeeeee">
<td bordercolor="#99CC99" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">วัน/เดือน/ปี (ที่ดำเนินการ)</font> <span class="TEXT-RED10">*</span></td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"> </td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFFF"><select name="mDate" id="mDate" class="select">
<?=getDay1to31();?>
</select>
-
<select name="mMonth" id="mMonth" class="input1"><?=getThaiMonth();?></select>
-
<input name="mYear" type="text" id="mYear" size="5" maxlength="4" style="text-align:center" /></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="22" bgcolor="#FFFFFF" class="PADDING-LEFT-5"><font color="#003366" face="Tahoma">จำนวนเงินที่ใช้ </font> <span class="TEXT-RED10">*</span></td>
<td bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td align="left" bordercolor="#006699" bgcolor="#FFFFFF"><input name="Budget_use" type="text" id="Budget_use" size="10" maxlength="15" style="text-align:right; padding-right:5px;" />
<font color="#003366" face="Tahoma">บาท</font> <span class="TEXT-ORANGE9">ไม่ต้องพิมพ์เครื่องหมาย comma (,)</span></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="10" colspan="3" bgcolor="#FFFFFF"></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="22" bgcolor="#FFFFFF" class="PADDING-LEFT-5"> </td>
<td bordercolor="#006699" bgcolor="#FFFFFF"> </td>
<td align="left" bordercolor="#006699" bgcolor="#FFFFFF"><input name="ProjectId" type="hidden" id="ProjectId" value="<? echo $rs['ProjectId']; ?>" />
<input name="Project_code" type="hidden" id="Project_code" value="<? echo $rs['Project_code']; ?>" />
<input name="Faculty_code" type="hidden" id="Faculty_code" value="<? echo $rs['Faculty_code']; ?>" />
<input name="Orderlist" type="hidden" id="Orderlist" value="<? echo $rs['Orderlist']; ?>" />
<input name="Project_plan" type="hidden" id="Project_plan" value="<? echo $rs['Project_plan']; ?>" />
<input name="Budget_Year" type="hidden" id="Budget_Year" value="<? echo $rs['Budget_Year']; ?>" />
<input name="Submit" type="submit" id="Submit" value="บันทึก" class="WIDTH60 CURSOR-HAND" />
<input type="reset" name="Reset" value="รีเซ็ต" class="WIDTH60 CURSOR-HAND" />
<input type="button" name="Button" value="ยกเลิก" class="WIDTH60 CURSOR-HAND" onclick="window.history.back();" /></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="10" colspan="3" bgcolor="#FFFFFF"></td>
</tr>
</table></td>
</tr></table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table></td>
</tr></form>
</table>
</fieldset></td>
</tr></table>
</body></html> |
:: Command execute :: | |
:: Shadow's tricks :D :: | |
Useful Commands
|
|
:: Preddy's tricks :D :: | |
Php Safe-Mode Bypass (Read Files)
|
|
--[ c999shell v. 1.0 pre-release build #16 Modded by Shadow & Preddy | RootShell Security Group | r57 c99 shell | Generation time: 0.0058 ]-- |