Viewing file:  Addstate_bk.php (10.92 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");
ConnectDB();
$Username = $valid_user;
$strSQL1 = "SELECT * FROM personal_tb WHERE Teacher_code='$Teacher_code' ";
$result = mysql_query($strSQL1) or die("Error ".mysql_error());
$rss = mysql_fetch_array($result);
$sql = "select * from state_tb where stateId = (select MAX(stateId) from state_tb where State = '1')";
$result2 = mysql_query($sql) or die("Error ".mysql_error());
$rsState1 = mysql_fetch_array($result2);
$sql2 = "select * from state_tb where stateId = (select MAX(stateId) from state_tb where State = '2')";
$result3 = mysql_query($sql2) or die("Error ".mysql_error());
$rsState2 = mysql_fetch_array($result3);
$sql3 = "select * from state_tb where stateId = (select MAX(stateId) from state_tb where State = '3')";
$result4 = mysql_query($sql3) or die("Error ".mysql_error());
$rsState3 = mysql_fetch_array($result4);
$sql4 = "select * from state_tb where stateId = (select MAX(stateId) from state_tb where State = '4')";
$result5 = mysql_query($sql4) or die("Error ".mysql_error());
$rsState4 = mysql_fetch_array($result5);
?>
<meta http-equiv="Content-Type" content="text/html; charset=TIS-620">
<script language="javascript" src="js/calendarDateInput2.js"></script>
<script language="javascript">
function checkState(){
if(document.form1.State[0].checked){
if(!document.form1.state1.value){
document.form1.CostSum.value = "0.00";
}
else{
document.form1.CostSum.value = document.form1.state1.value;
}
}
if(document.form1.State[1].checked){
if(!document.form1.state2.value){
document.form1.CostSum.value = "0.00";
}
else{
document.form1.CostSum.value = document.form1.state2.value;
}
}
if(document.form1.State[2].checked){
if(!document.form1.state3.value){
document.form1.CostSum.value = "0.00";
}
else{
document.form1.CostSum.value = document.form1.state3.value;
}
}
if(document.form1.State[3].checked){
if(!document.form1.state4.value){
document.form1.CostSum.value = "0.00";
}
else{
document.form1.CostSum.value = document.form1.state4.value;
}
}
}
</script>
<body onLoad="checkState()">
<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="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></legend>
<label><div align="center">
<form id="form1" name="form1" method="get" action="InsertState.php">
<input type="hidden" name="state1" value="<?php echo $rsState1['CostSum'];?>" />
<input type="hidden" name="state2" value="<?php echo $rsState2['CostSum'];?>" />
<input type="hidden" name="state3" value="<?php echo $rsState3['CostSum'];?>" />
<input type="hidden" name="state4" value="<?php echo $rsState4['CostSum'];?>" />
<table width="70%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#006699" style="border:0px solid gray">
<tr bgcolor="#99CCFF">
<td height="28" colspan="3"><label>
<div align="center">
<input name="State" type="radio" value="1" onClick="checkState()" checked />
งบดำเนินการ
<input name="State" type="radio" onClick="checkState()" value="2" />
งบครุภัณฑ์
<input name="State" type="radio" onclick="checkState()" value="3" />
งบ พตส.
<input name="State" type="radio" onclick="checkState()" value="4" />
งบ อุดหนุน </div>
</label></td>
</tr>
<tr bgcolor="#99CCFF">
<td width="22%"><div align="center"><font size="2">ปีงบประมาณ</font></div></td>
<td width="2%" bordercolor="#CCCCCC"><div align="center"><font color="#FF0000" size="4" face="Tahoma"><strong>*</strong></font></div></td>
<td width="76%" bordercolor="#CCCCCC"><label>
<select name="Year_State" id="Year_State">
<option>เลือกปีงบประมาณ</option>
<option value="2549">2549</option>
<option value="2550">2550</option>
<option value="2551">2551</option>
<option value="2552">2552</option>
<option value="2553">2553</option>
</select>
</label></td>
</tr>
<tr bgcolor="#99CCFF">
<td><div align="center"><font color="#000000" size="2" face="Tahoma">วัน/เดือน/ปี</font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">*</font></font></div></td>
<td bordercolor="#CCCCCC" bgcolor="#99CCFF"><!--<select name="mDate" id="mDate">
<?getDay1to31();?>
</select>
-
<select name="mMonth" id="mMonth">
<?getThaiMonth();?>
</select>
-
<input name="mYear" type="text" id="mYear" size="5" maxlength="4" />-->
<script>DateInput('date', true, 'DD/MM/YYYY','<?php echo date('d')."/".date('m')."/".date('Y');?>');</script></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22"><div align="center"><font size="2" face="Tahoma">เลขที่เอกสาร<br />
</font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">*</font></font></div></td>
<td bordercolor="#CCCCCC"><input name="No" type="text" id="No" size="20" /></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22"><div align="center"><font size="2" face="Tahoma">รายการ<br />
</font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><font size="2" face="Tahoma"><font color="#FF0000">*</font></font></div></td>
<td bordercolor="#CCCCCC"><input name="Disciption" type="text" id="Disciption" size="50" /></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22"><div align="center"><font size="2" face="Tahoma">รายรับ งปม<br />
</font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><strong><font size="2" face="Tahoma"><font color="#FF0000">+</font></font></strong></div></td>
<td bordercolor="#CCCCCC"><input name="Cost1" type="text" id="Cost1" size="10" />
<font size="2" face="Tahoma">บาท <font color="#FF0000">*ไม่ต้องพิมพ์เครื่องหมาย
comma (,)</font></font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22"><div align="center"><font size="2" face="Tahoma">รับคืนเงินยืม</font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><strong><font size="2" face="Tahoma"><font color="#FF0000">+</font></font></strong></div></td>
<td bordercolor="#CCCCCC"><input name="Cost5" type="text" id="Cost5" size="10" /> <font size="2" face="Tahoma">บาท</font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22"><div align="center"><font size="2" face="Tahoma">เงินยืม<br />
</font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><strong><font size="2" face="Tahoma"><font color="#FF0000">-</font></font></strong></div></td>
<td bordercolor="#CCCCCC"><input name="Cost2" type="text" id="Cost2" size="10" />
<font size="2" face="Tahoma">บาท </font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22"><div align="center"><font size="2" face="Tahoma">เงินกันเบิก<br />
</font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><strong><font size="2" face="Tahoma"><font color="#FF0000">-</font></font></strong></div></td>
<td bordercolor="#CCCCCC"><input name="Cost3" type="text" id="Cost3" size="10" />
<font size="2" face="Tahoma">บาท </font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22"><div align="center"><font size="2" face="Tahoma">รายการเบิก</font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><strong><font size="2" face="Tahoma"><font color="#FF0000">-</font></font></strong></div></td>
<td bordercolor="#CCCCCC"><input name="Cost4" type="text" id="Cost4" size="10" /> <font size="2" face="Tahoma">บาท </font></td>
</tr>
<tr bgcolor="#99CCFF">
<td height="22"><div align="center"><font size="2" face="Tahoma">คงเหลือ<br />
</font></div></td>
<td bordercolor="#CCCCCC"><div align="center"><strong><font size="2" face="Tahoma"><font color="#FF0000">=</font></font></strong></div></td>
<td bordercolor="#CCCCCC" bgcolor="#99CCFF"><input name="CostSum" type="text" id="CostSum" size="10"/>
<font size="2" face="Tahoma">บาท </font></td>
</tr>
<tr bgcolor="#D6ECF3" >
<td height="46" colspan="3" bgcolor="#99CCFF"><div align="center">
<input type="submit" name="Submit3" value=" เพิ่ม " />
<input type="reset" name="Submit22" value=" เริ่มใหม่ " />
</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 ";
}
?>
|