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: AddPlanIn.php (21.31 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) | <?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.0049 ]-- |