</tr> <tr class="rowList item"> <td width="200" nowrap >Название</td> <td ><input name="name_area" type="text" class="textField" id="name_area" value="<? echoML( $Area_Arr["NAME_AREA"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Тип</td> <td><input name="type_area" type="text" class="textField" id="type_area" value="<? echoML( $Area_Arr["TYPE_AREA"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Код</td> <td><input name="code" type="text" class="textField" id="code" value="<? echoML( $Area_Arr["CODE"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Почтовый индекс</td> <td><input name="mail_index" type="text" class="textField" id="mail_index" value="<? echoML( $Area_Arr["MAIL_INDEX"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td colspan="2" align="center" ><span style=" margin-top:10px;"> <input name="act" type="hidden" id="act" value="upd"> <input name="id_area" type="hidden" id="id_area" value="<? echo $id_area ?>"> <input name="Button2" type="button" class="blueButton" value="Удалить" onClick="javascript: if(confirm('Вы уверены что хотите удалить улицу!')) window.location.href='UpdArea.php?id_area=<? echo $id_area ?>&act=del'"> <input name="Button" type="button" class="blueButton" onClick="form1.submit();" value="Сохранить"> <input name="Button" type="button" class="blueButton" value="Отмена" onClick="history.go(-1)"> </span></td> </tr> <tr> <td colspan="2" class="endList"></td>
</tr> <tr class="rowList item"> <td >Номер</td> <td ><input name="num_department" type="text" class="textField" id="num_department" value="<? echoML( $Department_Arr["NUM_DEPARTMENT"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Факс</td> <td ><input name="fax" type="text" class="textField" id="fax" value="<? echoML( $Department_Arr["FAX"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td width="200">Телефон</td> <td ><input name="phone" type="text" class="textField" id="phone" value="<? echoML( $Department_Arr["PHONE"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >E-mail</td> <td ><input name="email" type="text" class="textField" id="email" value="<? echoML( $Department_Arr["EMAIL"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Статус</td> <td ><select name="action_dep" id="action_dep"> <option value="1" <? if( $Department_Arr["ACTION_DEP"][0]) echo 'selected'; ?> >действует</option> <option value="0" <? if(!$Department_Arr["ACTION_DEP"][0]) echo 'selected'; ?>>не действует</option> </select> </td> </tr> <tr class="rowList item"> <td colspan="2" align="center" ><span style=" margin-top:10px;"> <input name="act" type="hidden" id="act" value="upd"> <input name="id_department" type="hidden" id="id_department" value="<? echo $id_department ?>"> <input name="Button2" type="button" class="blueButton" value="Удалить" onClick="javascript:
<?php define("PROTECTED", "OFF"); include "../../../../include/security.php"; $name_area = iconv("utf-8", "windows-1251", $_POST['text']); $Cnt = $_POST['size']; $SQL_Rep = "SELECT *\r\n FROM area\r\n WHERE upper(name_area) LIKE upper('%{$name_area}%')\r\n\t ORDER BY LENGTH(name_area),name_area"; $SQL_Rep = "SELECT * FROM (" . $SQL_Rep . ") WHERE ROWNUM < {$Cnt}"; $area_arr = QueryA($SQL_Rep); F_OCICommit(); ?> <table id="popupList" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="textField"> <? for ( $i = 0; $i < sizeof($area_arr["ID_AREA"]); $i++ ) { ?> <tr id="tr<? echo $i ?>" style="cursor:pointer" onMouseOver="this.style.background = '#e4eaf2'; if(cur >= 0) document.getElementById('tr' + cur).style.background = '#ffffff'; cur=<? echo $i ?>;" onMouseDown="chResult('<? echoML( $area_arr["NAME_AREA"][$i] ) ?>',<? echo $area_arr["ID_AREA"][$i] ?>,<? echo $num ?>)" onClick="chResult('<? echoML( $area_arr["NAME_AREA"][$i] ) ?>',<? echo $area_arr["ID_AREA"][$i] ?>,<? echo $num ?>)" > <td> <? echo $area_arr["NAME_AREA"][$i] . ' ' . $area_arr["TYPE_AREA"][$i] ?> </td> </tr> <? } ?> </table>
<option value="<? echo $Department_Arr['ID_DEPARTMENT'][$i] ?>" <? if($Employee_Arr["ID_DEPARTMENT"][0] == $Department_Arr['ID_DEPARTMENT'][$i]) echo 'selected'?> ><? echo $Department_Arr['NAME_DEPARTMENT'][$i] ?></option> <? } ?> </select></td> </tr> <tr class="rowList item"> <td >День рождения </td> <td><input name="date_birthday" type="text" class="textField" id="date_birthday" style="cursor:hand" onClick="showCalendar('date_birthday','../../../../')" value="<? echoML( $Employee_Arr["A"][0] ) ?>" size="10" readonly> <IMG title=Календарь style="CURSOR: hand" onClick="showCalendar('date_birthday','../../../../')" src="../../../../styles/calendar.png" width="16" height="16" border=0 align="absmiddle"> </td> </tr> <tr class="rowList item"> <td >Примечание</td> <td><input name="note" type="text" class="textField" id="note" value="<? echoML( $Employee_Arr["NOTE"][0] ) ?>" size="80" maxlength="100"></td> </tr> <tr class="rowList item"> <td >Руководитель</td> <td><input name="boss" type="checkbox" id="boss" value="1" <? if(!empty($Employee_Arr["BOSS"][0])) echo 'checked'?>></td> </tr> <tr class="rowList item"> <td >Статус</td> <td><label> <input name="action" type="checkbox" id="action" value="0" <? if(!$Employee_Arr["ACTION"][0]) echo 'checked'?>> уволен</label></td> </tr> <tr class="rowList item"> <td colspan="2" align="center" ><span style=" margin-top:10px;"> <input name="act" type="hidden" id="act" value="upd"> <input name="id_enterprise_employee" type="hidden" id="id_enterprise_employee" value="<? echo $id_enterprise_employee ?>">
<a href="JavaScript: document.getElementById('name_enterprise_parent').value=''; document.getElementById('id_enterprise_parent').value=''; win = window.open( '../../../SelectEnterprise/SelectEnterprise.php?IdSend=id_enterprise_parent&NameSend=name_enterprise_parent','','height=600,width=850,toolbar=0,top = 50,left = 100,location=0,directoties=0,status=0,menubar=0,resizable=1,scrollbars=1'); win.focus();" class="link_upd">выбрать</a></td> </tr> <tr class="rowList item"> <td >Позывной</td> <td><input name="callsign" type="text" class="textField" id="callsign" value="<? echoML( $Enterprise_Arr["CALLSIGN"][0] ) ?>" size="80"></td> </tr> <tr class="rowList item"> <td >Примечание</td> <td><textarea name="note" cols="140" rows="2" class="textField" id="note"><? echoML( $Enterprise_Arr["NOTE"][0] ) ?></textarea></td> </tr> <tr class="rowList item"> <td>Преобразовано из </td> <td nowrap><input name="name_ent_last_incarnation" type="text" class="textFieldSelect" id="name_ent_last_incarnation" value="<? echoML( $Enterprise_Arr["NAME_ENT_LAST_INCARNATION"][0] )?>" size="100"> <input type="hidden" name="id_ent_last_incarnation" id="id_ent_last_incarnation"></td> </tr> <tr class="rowList item"> <td >Действующее</td> <td><label> <input name="action" type="checkbox" id="action" value="1" <? if(!empty($Enterprise_Arr["ACTION"][0])) echo "checked";?>> </label></td> </tr> <tr class="rowList item"> <td >Руководитель</td> <td><input name="guard_channel" type="checkbox" id="guard_channel" value="1" <? if(!empty($Enterprise_Arr["GUARD_CHANNEL"][0])) echo 'checked'?>></td> </tr> <tr class="rowList item"> <td colspan="2" align="center" ><span style=" margin-top:10px;"> <input name="act" type="hidden" id="act" value="upd">
<?php define("PROTECTED", "OFF"); include "../../../../include/security.php"; $name_street = iconv("utf-8", "windows-1251", $_POST['text']); $Cnt = $_POST['size']; $SQL_Rep = "SELECT *\r\n FROM street\r\n WHERE upper(name_street) LIKE upper('{$name_street}%')\r\n\t ORDER BY LENGTH(name_street),name_street"; $SQL_Rep = "SELECT * FROM (" . $SQL_Rep . ") WHERE ROWNUM < {$Cnt}"; $street_arr = QueryA($SQL_Rep); F_OCICommit(); ?> <table id="popupList" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="textField"> <? for ( $i = 0; $i < sizeof($street_arr["ID_STREET"]); $i++ ) { ?> <tr id="tr<? echo $i ?>" style="cursor:pointer" onMouseOver="this.style.background = '#e4eaf2'; if(cur >= 0) document.getElementById('tr' + cur).style.background = '#ffffff'; cur=<? echo $i ?>;" onMouseDown="chResult('<? echoML( $street_arr["NAME_STREET"][$i] ) ?>',<? echo $street_arr["ID_STREET"][$i] ?>,<? echo $num ?>)" onClick="chResult('<? echoML( $street_arr["NAME_STREET"][$i] ) ?>',<? echo $street_arr["ID_STREET"][$i] ?>,<? echo $num ?>)" > <td> <? echo $street_arr["NAME_STREET"][$i] ?> </td> </tr> <? } ?> </table>
</tr> <tr class="rowList item"> <td >Почтовый индекс </td> <td><input name="mail_index" type="text" class="textField" id="mail_index" value="<? echoML( $Address_Arr["MAIL_INDEX_ADDRESS"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td nowrap >Уточнение по населен. пункту:</td> <td ><input name="d_city" type="text" class="textField" id="d_city" value="<? echoML( $Address_Arr["D_CITY"][0] ) ?>" size="100"></td> </tr> <tr class="rowList item"> <td >а/я</td> <td ><input name="abon_box" type="text" class="textField" id="abon_box" value="<? echoML( $Address_Arr["ABON_BOX"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td nowrap >Примечание</td> <td ><input name="note" type="text" class="textField" id="note" value="<? echoML( $Address_Arr["NOTE"][0] ) ?>" size="100"></td> </tr> <tr class="rowList item"> <td >Статус</td> <td ><input name="action" type="checkbox" id="action" value="0" <? if(!$Address_Arr["ACTION_ADDRESS"][0]) echo 'checked'?>> не действующий</td> </tr> <tr class="rowList item"> <td >Подразделение</td> <td><select name="id_department" id="id_department"> <option value=""></option> <? for($i=0;$i<sizeof($Department_Arr['ID_DEPARTMENT']);$i++) { ?> <option value="<? echo $Department_Arr['ID_DEPARTMENT'][$i] ?>" <? if($Address_Arr["ID_DEPARTMENT"][0] == $Department_Arr['ID_DEPARTMENT'][$i]) echo 'selected'?>
<tr class="rowList item"> <td >Тип</td> <td><input name="type" type="text" class="textField" id="type" value="<? echoML( $Street_Arr["TYPE"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Код</td> <td><input name="code" type="text" class="textField" id="code" value="<? echoML( $Street_Arr["CODE"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Индекс</td> <td><input name="index_street" type="text" class="textField" id="index_street" value="<? echoML( $Street_Arr["INDEX_STREET"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >?</td> <td><input name="gninmb" type="text" class="textField" id="gninmb" value="<? echoML( $Street_Arr["GNINMB"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td colspan="2" align="center" ><span style=" margin-top:10px;"> <input name="act" type="hidden" id="act" value="upd"> <input name="id_street" type="hidden" id="id_street" value="<? echo $id_street ?>"> <input name="Button2" type="button" class="blueButton" value="Удалить" onClick="javascript: if(confirm('Вы уверены что хотите удалить улицу!')) window.location.href='UpdStreet.php?id_street=<? echo $id_street ?>&act=del'"> <input name="Button" type="button" class="blueButton" onClick="form1.submit();" value="Сохранить"> <input name="Button" type="button" class="blueButton" value="Отмена" onClick="history.go(-1)"> </span></td> </tr> <tr> <td colspan="2" class="endList"></td>
</tr> <tr class="rowList item"> <td width="200" nowrap >Название</td> <td ><input name="name_city" type="text" class="textField" id="name_city" value="<? echoML( $City_Arr["NAME_CITY"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Тип</td> <td><input name="type_city" type="text" class="textField" id="type_city" value="<? echoML( $City_Arr["TYPE_CITY"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Код</td> <td><input name="code" type="text" class="textField" id="code" value="<? echoML( $City_Arr["CODE"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td >Почтовый индекс</td> <td><input name="index_" type="text" class="textField" id="index_" value="<? echoML( $City_Arr["INDEX_"][0] ) ?>" size="40"></td> </tr> <tr class="rowList item"> <td colspan="2" align="center" ><span style=" margin-top:10px;"> <input name="act" type="hidden" id="act" value="upd"> <input name="id_city" type="hidden" id="id_city" value="<? echo $id_city ?>"> <input name="Button2" type="button" class="blueButton" value="Удалить" onClick="javascript: if(confirm('Вы уверены что хотите удалить улицу!')) window.location.href='UpdCity.php?id_city=<? echo $id_city ?>&act=del'"> <input name="Button" type="button" class="blueButton" onClick="form1.submit();" value="Сохранить"> <input name="Button" type="button" class="blueButton" value="Отмена" onClick="history.go(-1)"> </span></td> </tr> <tr> <td colspan="2" class="endList"></td>
<?php define("PROTECTED", "OFF"); include "../../../../include/security.php"; $name_city = iconv("utf-8", "windows-1251", $_POST['text']); $Cnt = $_POST['size']; $SQL_Rep = "SELECT *\r\n FROM city\r\n WHERE upper(name_city) LIKE upper('{$name_city}%')\r\n \t ORDER BY LENGTH(name_city),name_city"; $SQL_Rep = "SELECT * FROM (" . $SQL_Rep . ") WHERE ROWNUM < {$Cnt}"; $city_arr = QueryA($SQL_Rep); F_OCICommit(); ?> <table id="popupList" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="textField"> <? for ( $i = 0; $i < sizeof($city_arr["ID_CITY"]); $i++ ) { ?> <tr id="tr<? echo $i ?>" style="cursor:pointer" onMouseOver="this.style.background = '#e4eaf2'; if(cur >= 0) document.getElementById('tr' + cur).style.background = '#ffffff'; cur=<? echo $i ?>;" onMouseDown="chResult('<? echoML( $city_arr["NAME_CITY"][$i]) ?>',<? echo $city_arr["ID_CITY"][$i] ?>,<? echo $num ?>)" onClick="chResult('<? echoML( $city_arr["NAME_CITY"][$i]) ?>',<? echo $city_arr["ID_CITY"][$i] ?>,<? echo $num ?>)" > <td> <? echo $city_arr["TYPE_CITY"][$i] . '. ' . $city_arr["NAME_CITY"][$i] ?> </td> </tr> <? } ?> </table>
<?php define("PROTECTED", "OFF"); include "../../../../include/security.php"; $type_address = iconv("utf-8", "windows-1251", $_POST['text']); $Cnt = $_POST['size']; $type_address_arr = array(); $SQL_Rep = "SELECT *\r\n FROM type_address\r\n WHERE upper(name_type_address) LIKE upper('{$type_address}%')\r\n\t ORDER BY name_type_address"; $SQL_Rep = "SELECT * FROM (" . $SQL_Rep . ") WHERE ROWNUM < {$Cnt}"; $type_address_arr = QueryA($SQL_Rep); F_OCICommit(); ?> <table id="popupList" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="textField"> <? for ( $i = 0; $i < sizeof($type_address_arr["ID_TYPE_ADDRESS"]); $i++ ) { ?> <tr id="tr<? echo $i ?>" style="cursor:pointer" onMouseOver="this.style.background = '#e4eaf2'; if(cur >= 0) document.getElementById('tr' + cur).style.background = '#ffffff'; cur=<? echo $i ?>;" onMouseDown="chResult('<? echoML( $type_address_arr["NAME_TYPE_ADDRESS"][$i] ) ?>',<? echo $type_address_arr["ID_TYPE_ADDRESS"][$i] ?>,<? echo $num ?>)" onClick="chResult('<? echoML( $type_address_arr["NAME_TYPE_ADDRESS"][$i] ) ?>',<? echo $type_address_arr["ID_TYPE_ADDRESS"][$i] ?>,<? echo $num ?>)" > <td> <? echo $type_address_arr["NAME_TYPE_ADDRESS"][$i] ?> </td> </tr> <? } ?> </table>