Viewing file:  AddFormPerson.php (19.6 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" );
require_once( "../include/FunctionDB.php" );
/** Create Database Object */
$dbObj = new DBConn;
//=== SESSION
$Username = $valid_user;
/** Personal Data **/
$query = "SELECT * FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId LEFT JOIN faculty_tb ON personal_tb.Faculty_code = faculty_tb.Faculty_code WHERE Teacher_code = '".$_REQUEST["Teacher_code"]."'";
$result = $dbObj->execQuery($query);
$rs1 = $dbObj->fetchArray($result);
/** Personal Data(Faculty Head) **/
$query = "SELECT * FROM personal_tb LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId LEFT JOIN position_tb ON personal_tb.PositionId = position_tb.PositionId LEFT JOIN faculty_tb ON personal_tb.Faculty_code = faculty_tb.Faculty_code WHERE personal_tb.Faculty_code = '".$rs1["Faculty_code"]."' AND TeacherId = '1'";
$result = $dbObj->execQuery($query);
$rs3 = $dbObj->fetchArray($result);
/** College Data **/
$sql = "Select * From college Where collegeStatus ='1'";
$result = mysql_query($sql) or die("Error".mysql_error());
$rs4 = mysql_fetch_array($result);
$collegeName = $rs4["collegeName"];
} # 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=tis-620" />
<link href="../css/default.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="../js/utilities.js"></script>
<script type="text/javascript" src="../js/ajaxScript.js"></script>
<script type="text/javascript" src="../js/calendarDateInput2.js"></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="left" valign="top" style="padding:10px 0px 5px 10px"><fieldset><legend><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="index.php">Л№йТЛЕСЎ</a></font><img src="../picture/ico3.gif" width="10" height="10" align="absmiddle" border="0" /></font><font size="2" color="<?php echo $GLOBALS["COLOR_FONT_3"]; ?>"><a href="RepFormAList.php?Flag=<?=$Teacher_code;?>">ўйНБЩЕЎТГўНН№ШБСµФд»ГТЄЎТГ(ГЗБ¤іР)</a></font></font><img src="../picture/ico3.gif" width="10" height="10" align="absmiddle" border="0" /></font><span class="NOTE">бєєїНГмБўНН№ШБСµФЎТГаґФ№·Т§д»ГТЄЎТГ</a></font></span></legend>
<form id="form1" name="form1" method="post" action="InsertFormPerson.php">
<table width="780" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
<tr>
<td><span class="PADDING-TOP-10"><img src="../images/icons/arrow-circle-225-left.png" width="16" height="16" border="0" align="absmiddle" /> <a href="javascript:;" onclick="window.history.back();"><strong>‹ ВйН№ЎЕСє</strong></a></span></td>
</tr>
<tr>
<td align="center">
<?php
?>
<table width="750" cellpadding="0" cellspacing="0" border="0">
<tr height="31">
<td height="31" colspan="6" align="center" class="PATRON11">єС№·ЦЎўйН¤ЗТБ</td>
</tr>
<tr height="29">
<td height="29" colspan="6">КиЗ№ГТЄЎТГ <?=$collegeName;?></td>
</tr>
<tr>
<td height="29" colspan="2" align="left">
·Хи
<input name="maNo" type="text" id="maNo" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" value="<?=$docNo."....";?>" onblur="this.readOnly=true;" size="15" readonly/>
</td>
<td width="80" height="29" align="left">
<input name="Flag" type="hidden" id="Flag" value="<?=$rs2["Flag"]?>"/>
</td>
<td height="29" align="left"> </td>
<td height="29" align="right">ЗС№·Хи </td>
<td height="29" width="200" align="left">
<script>DateInput('Date', true,'DD/MM/YYYY','<?=date("d/m/Y");?>');</script>
</td>
</tr>
<tr height="29">
<td height="29" colspan="3" align="left">
аГЧиН§ ўНН№ШБСµФаґФ№·Т§д»ГТЄЎТГ
<input name="Detail" type="hidden" id="Detail" value="ўНН№ШБСµФаґФ№·Т§д»ГТЄЎТГ"/>
</td>
<td width="35"> </td>
<td width="202"> </td>
<td width="200"> </td>
</tr>
<tr height="29">
<td height="29" colspan="5" align="left">аГХВ№ јЩйНУ№ЗВЎТГ <?=$collegeName;?></td>
<td> </td>
</tr>
<tr height="29">
<td width="125" height="25"> </td>
<td colspan="5" align="left" nowrap>
ўйТѕаЁйТ<input name="Name" type="text" id="Name" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed ; text-align:center" size="38" value="<?=$rs1["prefixName"]." ".$rs1["Teacher_name"]." ".$rs1["Teacher_lastname"];?>" readonly/>
µУбЛ№и§<input name="Name2" type="text" id="Name2" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="38" value="<?=$rs1["Position_name"];?>" readonly/>
</td>
</tr>
<tr height="29" nowrap>
<td height="29" colspan="6" align="left">
КС§ЎСґ<input name="Name3" type="text" id="Name3" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="20" value="<?=$rs1["Faculty_name"];?>" readonly/>
<input name="Name4" type="text" id="Name4" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="65" value="<?=$collegeName;?>" readonly/>К¶ТєС№ѕГРєГБГТЄЄ№Ў
</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left" nowrap>
ўНН№ШБСµФаґФ№·Т§д»ГТЄЎТГ аГЧиН§ *
<input name="Training_name" type="text" id="Training_name" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="84"/>
</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left" nowrap>
аґФ№·Т§вґВ
<input type="checkbox" name="Travel" value="1" <?=(trim($rs2["Travel"])=="1")?"checked":"";?>/>вґВö¹µмўН§·Т§ГТЄЎТГ
<input type="checkbox" name="Travel1" value="2" <?=(trim($rs2["Travel1"])=="2")?"checked":"";?>/>ö¹µм»ГСєНТЎТИ
<input type="checkbox" name="Travel2" value="3" <?=(trim($rs2["Travel2"])=="3")?"checked":"";?>/>Г¶дї
<input type="checkbox" name="Travel3" value="4" <?=(trim($rs2["Travel3"])=="4")?"checked":"";?>/>а¤ГЧиН§єФ№
<input type="checkbox" name="Travel4" value="5" <?=(trim($rs2["Travel4"])=="5")?"checked":"";?>/>ö¹µмКиЗ№µСЗ
<input type="checkbox" name="Travel5" value="6" <?=(trim($rs2["Travel5"])=="6")?"checked":"";?>/>Г¶ГСєЁйТ§ </td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left" nowrap>
НйТ§µТБЛ№С§КЧНГТЄЎТГаЕў·Хи *
<input name="No_in" type="text" id="No_in" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center;" size="15"/>
аГЧиН§
<input name="Status" type="text" id="Status" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" size="65"/>
</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left" nowrap>
<table>
<tr>
<td align="right">µСй§бµи ЗС№·Хи</td>
<td align="left">
<script>DateInput('dateStart', true,'DD/MM/YYYY','<?=date("d/m/Y");?>');</script>
</td>
<td align="right">¶Ц§ЗС№·Хи</td>
<td align="left">
<script>DateInput('dateFinish', true,'DD/MM/YYYY','<?=date("d/m/Y");?>');</script>
</td>
<td>
БХЎУЛ№ґ
<input name="Day" type="text" id="Day" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="2" maxlength="3"/>
ЗС№
</td>
</tr>
<tr>
<td colspan="5"><span id="budgetOver"></span></td>
</tr>
</table>
</td>
</tr>
<tr height="31">
<td height="31" colspan="6" nowrap>вґВўНаєФЎ¤иТгЄйЁиТВг№ЎТГаґФ№·Т§д»ГТЄЎТГбЕРг№ГРЛЗиТ§ЎТГаґФ№·Т§д»ГТЄЎТГ</td>
</tr>
<tr height="31">
<td height="31" colspan="6" nowrap>
ўйТѕаЁйТўНБНєЛБТВг№Л№йТ·Хи
<input name="assignMent" type="text" id="assignMent" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="20"/>
гЛй
<input name="assignmentName" type="text" id="Name7" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="46" />
јЩйГСє»ЇФєСµФ§Т№б·№
</td>
</tr>
<tr height="31">
<td height="31" colspan="6">ѕГйНБґйЗВјЩйГиЗБаґФ№·Т§д»ГТЄЎТГ ґС§№Хй</td>
</tr>
<tr>
<td height="31" colspan="6" align="center">
<table id="addPerson">
<tr>
<td><input name="removePerson" type="checkbox"/></td>
<td>1. </td>
<td>
<select name="personList[]"/>
<option value=""> ----- аЕЧНЎ ----- </option>
<?php
$strSQL5 = "SELECT * FROM personal_tb Where StatusId ='1' and Teacher_code != '".$_REQUEST["Teacher_code"]."' ORDER BY Teacher_name";
$result5 = mysql_query($strSQL5);
while($rs5 = mysql_fetch_array($result5)){
echo"<option value=\"$rs5[Teacher_code]\" >$rs5[Teacher_name] $rs5[Teacher_lastname]</option>\n";
}
?>
</select>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="6" height="51" align="center">
<input type="button" name="add" value="аѕФиБјЩйГиЗБаґФ№·Т§" style="cursor:pointer" onclick="addRow('addPerson')" title="¤ЕФкЎ·Хи№ХиаѕЧиНаѕФиБјЩйГиЗБаґФ№·Т§">
<input type="button" name="del" value="ЕєјЩйГиЗБаґФ№·Т§" style="cursor:pointer" onclick="deleteRow('addPerson')" title="¤ЕФкЎ·Хи№ХиаѕЧиНЕєјЩйГиЗБаґФ№·Т§·ХиаЕЧНЎ">
</td>
</tr>
<tr height="31">
<td height="31" colspan="6">»ГРЗСµФЎТГѕСІ№Тµ№аН§</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left">ЗСµ¶Ш»ГРК§¤маѕЧиН
<input type="radio" name="Training_type" value="1"/>ЎТГНєГБ
<input type="radio" name="Training_type" value="2"/>ЎТГИЦЎЙТґЩ§Т№
<input type="radio" name="Training_type" value="3"/>»ГРЄШБ
<input type="radio" name="Training_type" value="4"/>КСББ№Т
<input type="radio" name="Training_type" value="5"/>№Фа·И§Т№
<input type="radio" name="Training_type" value="7"/>ЎТГа»з№ЗФ·ВТЎГ
</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left"><input name="Training_type" type="radio"<?php if (!(strcmp("$rs3[Training_type]","8"))){echo "checked";} ?> value="8" />
ЎГГБЎТГЗФЄТЎТГ/ЗФЄТЄХѕ
<input name="Training_type" type="radio" <?php if (!(strcmp("$rs3[Training_type]","9"))){echo "checked";} ?> value="9" />
·Хи»ГЦЎЙТ§Т№ЗФЁСВЛГЧНЗФ·ВТ№Фѕ№ём
<input name="Training_type" type="radio" <?php if (!(strcmp("$rs3[Training_type]","10"))){echo "checked";} ?> value="10" />
јЩй·Г§¤ШіЗШІФ/аЄХиВЗЄТµГЗЁа¤ГЧиН§БЧН
<input name="Training_type" type="radio" <?php if (!(strcmp("$rs3[Training_type]","11"))){echo "checked";} ?> value="11" />
НЧи№ж</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left">
»ГРаА·ўН§ЎТГѕСІ№Т
<input name="Training_std" type="radio" value="Y"/>ѕСІ№ТµТБКТВ§Т№
<input name="Training_std" type="radio" value="N"/>ѕСІ№Тµ№аН§
<input name="Training_std" type="radio" value="1" <?=($rs2["Training_std"]=="1")?"checked":"";?> checked="checked" />
НЧи№ж</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left">
ЁУ№З№ЄСиЗвБ§<input name="Total_hour" type="text" id="Total_hour" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="4"/>
бЛЕи§а§Ф№К№СєК№Ш№<input name="Fund_resource" type="text" id="Fund_resource" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="50"/>
</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left">
Л№иЗВ§Т№·ХиЁСґ<input name="Organiz" type="text" id="Organiz" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="50"/>
</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left">
К¶Т№·ХиЁСґ<input name="CNEU" type="text" id="CNEU" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed; text-align:center" size="50"/>
ЁС§ЛЗСґ
<select name="provinceId" id="provinceId" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" <?=(isset($rs2))?"disabled":"";?>>
<?php
$query = " SELECT * FROM province";
$result = mysql_query($query);
while($rs4 = mysql_fetch_array($result)){
?>
<option value="<?=$rs4['provinceId'];?>"><?=$rs4['provinceName'];?></option>
<?php
} # while
?>
</select>
</td>
</tr>
<tr height="31">
<td height="31" colspan="3" align="left"> </td>
<td colspan="2"> </td>
<td> </td>
</tr>
<tr height="31">
<td height="31" colspan="3" align="left"> </td>
<td colspan="2" align="center">Е§ЄЧиН ..............................................</td>
<td> </td>
</tr>
<tr height="29">
<td height="29" colspan="3"> </td>
<td colspan="2" align="center">
( <?=$rs1["prefixName"]." ".$rs1["Teacher_name"]." ".$rs1["Teacher_lastname"];?> )
<input name="Faculty_code" type="hidden" id="Faculty_code" value="<? echo $rs1["Faculty_code"]?>"/>
</td>
<td> </td>
</tr>
<tr height="29">
<td height="29" colspan="3" align="left"> </td>
<td colspan="2" align="center">
µУбЛ№и§<input name="Name5" type="text" id="Name5" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: none; text-align:center" size="20" value="<?=$rs1["Position_name"];?>"/>
</td>
<td> </td>
</tr>
<tr height="29">
<td colspan="5">
<input name="Flag1" type="checkbox" id="Flag1" value="1" disabled="disabled" /> Н№ШТµ
<input name="Flag1" type="checkbox" id="Flag1" value="2" disabled="disabled" /> дБиН№ШТµ
<!--<div align="right">*
<select name="Teacher_code" id="Teacher_code" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: black 1px dashed" >
<?php
$query = " SELECT * FROM personal_tb LEFT JOIN prefix ON personal_tb.prefixId = prefix.prefixId Where StatusId = '1' Or Teacher_name= 'ѕўГ' Order By Teacher_name ASC";
$result = mysql_query($query);
while($rs4 = mysql_fetch_array($result)){
?>
<option value="<?=$rs4['Teacher_code'];?>" <?=($rs4['Teacher_code']==$rs1['Teacher_code'])?"selected":"";?>>
<?=$rs4['prefixName']." ".$rs4['Teacher_name']." ".$rs4['Teacher_lastname'];?>
</option>
<?php
} # while
?>
</select></div>-->
</td>
</tr>
<tr height="29">
<td height="29" colspan="6" align="left">Е§ЄЧиН.........................................ЛСЗЛ№йТАТ¤/ЅиТВ.</td>
</tr>
<tr height="29">
<td height="29" colspan="3" align="center">
( <?=$rs3['prefixName']." ".$rs3['Teacher_name']." ".$rs3['Teacher_lastname'];?> )
<input name="TeacherId" type="hidden" id="TeacherId" value="<?=$rs3["TeacherId"]?>"/>
</td>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr height="29">
<td height="29" colspan="3" align="center">
µУбЛ№и§<input name="Name6" type="text" id="Name6" style="BORDER-RIGHT: 0px; BORDER-TOP: 0px; BORDER-LEFT: 0px; BORDER-BOTTOM: none; text-align:center" size="25" value="<?=$rs3["Position_name"];?>"/>
</td>
<td align="left"> </td>
<td colspan="2" align="left"> </td>
</tr>
<tr height="29">
<td height="29" colspan="2" align="left"> </td>
<td align="left"> </td>
<td colspan="2" align="left"> </td>
</tr>
<tr height="29">
<td height="28" colspan="2" align="left"> </td>
<td align="left"> </td>
<td colspan="2" align="center">Е§ЄЧиН.............................................</td>
</tr>
<tr height="29">
<td height="29" colspan="2" align="left"> </td>
<td align="left"> </td>
<td colspan="2" align="center"> ЗС№·Хи........аґЧН№..............ѕ.И.........</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align="center"> <BR><BR></td>
</tr>
<tr>
<td align="center">
<input type="hidden" name="codeId" value="<?=$_REQUEST["codeId"];?>"/>
<input type="hidden" name="Teacher_code" value="<?=$_REQUEST["Teacher_code"];?>"/>
<input type="hidden" name="Training_code" value="<?=$_REQUEST["Training_code"];?>"/>
<input type="submit" name="Submit" value="єС№·ЦЎ" style="cursor:pointer" class="WIDTH60 CURSOR-HAND"/>
<input type="reset" name="Reset" value="ГХа«зµ" style="cursor:pointer" class="WIDTH60 CURSOR-HAND"/>
<input type="button" name="Button" value="ВЎаЕФЎ" style="cursor:pointer" class="WIDTH60 CURSOR-HAND" onclick="location.href='RepFormAList.php?Teacher_code=<?=$_REQUEST["Teacher_code"];?>'"/>
</td>
</tr>
</table>
</form>
</fieldset>
</td>
</tr>
</table>
<?php include("../templates/incFooter.php"); ?>
</body>
</html>
<?php
/** Free Resource */
$dbObj->freeresult($result);
/** Close the Database */
$dbObj->disconn();
/** Unset Class */
unset($dbObj);
?>
|