Viewing file:  Frmstate_bk.php (11.55 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
if (session_is_registered("valid_user")&&session_is_registered("Priority") )
{
$Username = $valid_user;
$Password = $password;
include("../include/FunctionDB.php");
include("../include/Function.php");
include("admin_menu.php");
include("../source/myFunc.php");
ConnectDB();
$Username = $valid_user;
$sql1 = "SELECT * FROM state_tb Where State='$State' and stateId='$stateId' ";
$result1 = mysql_query($sql1) ;
$rs = mysql_fetch_array($result1);
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<script language="javascript" src="js/calendarDateInput2.js"></script>
<table width="822" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="822"><br>
<fieldset>
<legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="index.php" >หน้าหลัก</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle"><a href="Addstate.php">เพิ่มข้อมูล</a> <img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="EditStateList.php?State=<? echo $rss[State] ?>">แก้ไขข้อมูล</a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /><a href="StateList.php?State=1">แสดงรายงานงบประมาณ</a><img src="../picture/ico3.gif" width="10" height="10" border="0" align="absmiddle" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>">แสดงรายการงบบุคลากร</font></legend>
<label><div align="center">
<form id="form1" name="form1" method="get" action="EditFrmState.php">
<table width="70%" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#006699" style="border:1px solid gray">
<tr bgcolor="#D6ECF3" >
<td colspan="3"><div align="center"><strong><font color="#000000" size="3" face="Tahoma">เพิ่มข้อมูลรายการ</font></strong></div></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="28" colspan="3" bgcolor="#eeeeee"><label>
<div align="center">
<input name="State" type="radio" <?php if (!(strcmp("$rs[State]","1"))){echo "checked";} ?> value="1" />
งบดำเนินการ
<input name="State" type="radio" <?php if (!(strcmp("$rs[State]","2"))){echo "checked";} ?> value="2" />
งบครุภัณฑ์
<input name="State" type="radio" <?php if (!(strcmp("$rs[State]","3"))){echo "checked";} ?> value="3" />
งบ พตส.
<input name="State" type="radio" <?php if (!(strcmp("$rs[State]","4"))){echo "checked";} ?> value="3" />
งบ อุดหนุน </div>
</label></td>
</tr>
<tr bgcolor="#99CCFF">
<td width="22%" bgcolor="#eeeeee"><div align="center"><font size="2">ปีงบประมาณ</font></div></td>
<td width="2%" bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font color="#FF0000" size="4" face="Tahoma"><strong>*</strong></font></div></td>
<td width="76%" bordercolor="#CCCCCC" bgcolor="#eeeeee"><label>
<select name="Year_State" id="Year_State">
<option value="2549" <?php if (!(strcmp("$rs[Year_State]","2549"))){echo "selected";} ?> >2549</option>
<option value="2550" <?php if (!(strcmp("$rs[Year_State]","2550"))){echo "selected";} ?> >2550</option>
<option value="2551" <?php if (!(strcmp("$rs[Year_State]","2551"))){echo "selected";} ?>>2551</option>
<option value="2552" <?php if (!(strcmp("$rs[Year_State]","2552"))){echo "selected";} ?>>2552</option>
<option value="2553" <?php if (!(strcmp("$rs[Year_State]","2553"))){echo "selected";} ?>>2553</option>
</select>
</label></td>
</tr>
<tr bgcolor="#99CCFF">
<td bgcolor="#eeeeee"><div align="center"><font color="#000000" size="2" face="Tahoma">วัน/เดือน/ปี</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">*</font></font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><!--<font color="#000000" size="2" face="Tahoma">
<select name="mDate" id="mDate" class="select" >
<?php/*
$Date_note = $rs[Date_note];
$yearthai = explode("-",$Date_note);
$mDate = intval($yearthai[2]);
$mMonth = intval($yearthai[1]);
$mYear = intval($yearthai[0]);
for($i=0;$i<=31;$i++)
{
if( $i == 0)
echo"\n\t<option value=\"$mDate\" selected>$mDate</option>\n ";
else
echo"\n\t<option value=\"$i\">$i</option>\n ";
}
// getDay1to31();*/
?>
</select>
<select name="mMonth" id="select3" class="select" >
<?php/*
$Date_note = $rs[Date_note];
$yearthai = explode("-",$Date_note);
$mDate= intval($yearthai[2]);
$Month = intval($yearthai[1]);
$mYear = intval($yearthai[0]);
$mMonth = $Month;
$CMonth = TxtThaiMonth($Month);
for($i=-1;$i<=11;$i++)
{
$a = $i+1;
if( $a == 0)
echo"\n\t<option value=\"$mMonth\" selected>$CMonth</option>\n ";
else
echo"\n\t<option value=\"$a\">$ThaiMonth[$i]</option>\n ";
}
// getThaiMonth();*/
?>
</select>
<input name="mYear" type="text" class="input" id="mYear" value="<? //echo $mYear ?>" size="5" maxlength="4" />
</font><font size="2" face="Tahoma"> </font>--><script>DateInput('date', true, 'DD/MM/YYYY','<?php echo ymdT2dmyE($rs['Date_note']);?>');</script> </td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">เลขที่เอกสาร<br />
</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">*</font></font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><input name="No" type="text" id="No" value="<? echo $rs[No]?>" size="20" /></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">รายการ<br />
</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">*</font></font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><input name="Disciption" type="text" id="Disciption" value="<? echo $rs[Disciption]?>" size="50" /></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">รายรับ งปม<br />
</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font color="#FF0000" size="2" face="Tahoma">+</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><input name="Cost1" type="text" id="Cost1" value="<? echo $rs[Cost1]?>" size="10" />
<font size="2" face="Tahoma">บาท <font color="#FF0000">*ไม่ต้องพิมพ์เครื่องหมาย
comma (,)</font></font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">รับคืนเงินยืม<br />
</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">+</font></font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><input name="Cost5" type="text" id="Cost5" value="<? echo $rs['Cost5']?>" size="10" />
<font size="2" face="Tahoma">บาท</font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">เงินยืม<br />
</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">-</font></font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><input name="Cost2" type="text" id="Cost2" value="<? echo $rs[Cost2]?>" size="10" />
<font size="2" face="Tahoma">บาท </font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">เงินกันเบิก<br />
</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">-</font></font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><input name="Cost3" type="text" id="Cost3" value="<? echo $rs[Cost3]?>" size="10" />
<font size="2" face="Tahoma">บาท </font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">รายการเบิก</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">-</font></font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><input name="Cost4" type="text" id="Cost4" value="<? echo $rs[Cost4]?>" size="10" /> <font size="2" face="Tahoma">บาท </font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22" bgcolor="#eeeeee"><div align="center"><font size="2" face="Tahoma">คงเหลือ<br />
</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><div align="center"><font color="#FF0000" size="2" face="Tahoma">=</font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#eeeeee"><input name="CostSum" type="text" id="CostSum" value="<? echo $rs[CostSum]?>" size="10" disabled="true"/>
<font size="2" face="Tahoma">บาท </font></td>
</tr>
<tr bgcolor="#D6ECF3" >
<td colspan="3"><div align="center">
<input name="Submit" type="submit" id="Submit" value=" แก้ไขข้อมูล" />
<input name="stateId" type="hidden" id="stateId" value="<? echo $rs[stateId]?>" />
</div></td>
</tr>
</table>
</form>
</div>
</label>
</fieldset><br>
<font color="<?php echo $GLOBALS["COLOR_FONT_3"];?>" size="2"><b>หมายเหตุ :</b> ใช้เมาส์คลิกที่ชื่อ<br>
</font></td>
</tr>
</table>
<?php
}
else
{
echo"<meta http-equiv=\"refresh\" content=\"3;URL=../login.php\">\n";
echo"Please Login ";
}
?>
|