117
<td width='100' class='tz'> $res_id[5] </td>
<td width='45' class=''><form method='post' name='kab' action='udal.php'>
<INPUT TYPE='hidden' NAME='kab' VALUE='$res_id[0]'>
<input type='image' src='../image/cut.png' TITLE='Редактировать данные
пользователя' WIDTH='30' HEIGHT='30' >
</form>
</td>
<td width='45' class=''><form method='post' name='kab' action='udal.php'>
<INPUT TYPE='hidden' NAME='kab' VALUE='$res_id[0]'>
<input type='image' src='../image/delete.png' TITLE='Удалить пользователя'
WIDTH='30' HEIGHT='30' >
</form>
</td>
</tr> </table>\n";
$a=$a+1;
}
?>
</td>
</div>
</div>
<br>
<br>
</body>
</html>
<?php include "menudisp.php"; ?>
<div id='content'>
<div id='content1'>
118
<!-- вот здесь вся инфа-->
<br>
<table width="100%" border="1" cellspacing="5" cellpadding="5">
<tr>
<th colspan="3" align="left"><h3> Новая заявка </h3></th>
</tr>
<tr class="line">
<th colspan="3" align="left" class="but1"> <br/>Название заявки <span
class="reg">*</span> </th>
</tr>
<tr>
<th colspan="3" align="left"><form action="addzavdisp.php"
method="post" enctype="multipart/form-data" id="signup"> <input type="text"
size="133" name="namezav" class="required" title="Заголовок обязателен!">
</th>
</tr>
<tr>
<th colspan="3" align="left" class="but1">Описание <span
class="reg">*</span></th>
</tr>
<tr>
<td colspan="3"><textarea rows="4" cols="130" name="desczav"
class="required" title="<br>
Поле обязательно к заполнению"></textarea> </td>
</tr>
<tr>
<th align="left" class="but1" >Приоритет <span
class="reg">*</span><select title="" name="priorzav" class="required">
<option value=""></option>
<option value="1">низкий</option>
119
<option value="2">средний</option>
<option value="3" selected="true">высокий</option>
<option value="4">критичный</option>
</select></td>
<th align="left" class="but1">Кабинет
<select name="activzav">
<?php
require "../dbconnect.php";
$res=mysql_query("SELECT ida,nameo, nomkab FROM `activ`, otdel where
dela=0 and idoa=ido")
or die(mysql_error());
$chat=mysql_num_rows($res);
while ($chat=mysql_fetch_row($res))
{
echo "<option value='$chat[0]'>$chat[1]
$chat[2]</option>\n";
}
?>
</select>
</td>
<th align="left" class="but1">Категория
<select name="katzav">
<?php
require "../dbconnect.php";
$res1=mysql_query("SELECT idpr, nameprez FROM `prez` where delprez=0")
or die(mysql_error());
$chat1=mysql_num_rows($res1);
while ($chat1=mysql_fetch_row($res1))
{
echo "<option value='$chat1[0]'>$chat1[1] </option>\n";
120
}
?>
</select>
</td>
</tr>
<tr>
<th align="left" class="but1">Вложить файл </td> <th align="left"
class="tr">(не более 3 мб) </td>
<td > <input type="file" name="filename" size="40" ></td>
</tr>
<tr>
<th colspan="3" align="left" class="but1"> <br/>Добавить комментарий
</th>
</tr>
<tr>
<td colspan="3"><textarea rows="2" cols="130" name="commzav"
class="required" title="<br>
Поле обязательно к заполнению"></textarea> </td>
</tr>
<tr>
<td> </td>
<td align="center" class="but1"><input type="submit" name="zav"
value="Сохранить заявку" > </form></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
121
</table>
</div>
</div>
<br>
<br>
</body>
</html>
<?php
session_start();
?>
<?php
require "../dbconnect.php";
if(isset($_POST['zav']))
{
$user=$_SESSION['disp'];
setlocale (LC_ALL, "ru_RU.CP1251");
$ttt=date("dmyGis", time());
/* echo $_FILES['filename']['name'];*/
if(!empty($_FILES['filename']['name']))
{
if($_FILES["filename"]["size"] > 12800000)
{
122
echo ("Размер файла превышает 128 кбайт");
exit;
};
if(copy($_FILES["filename"]["tmp_name"],"C:/WebServers/home/localhost/w
ww/helpdesk/download/".$ttt.$_FILES["filename"]["name"]))
{
$link=$ttt.$_FILES["filename"]["name"];
}
}
else {
$link=0;
}
$today = date("Y-m-d H:i:s");
$query1="insert into zav (`namezav`, desczav, priorzav, activzav, katzav,
filezav, iduzav, commzav)
values ('".$_POST['namezav']."','".$_POST['desczav']."',
'".$_POST['priorzav']."','".$_POST['activzav']."','".$_POST['katzav']."','$link','$user',
'".$_POST['commzav']."')";
$query2=mysql_query("select max(idzav) from zav");
$zav=mysql_num_rows($query2);
while ($zav=mysql_fetch_row($query2))
{
$numzav=$zav[0];
}
$query3="insert into status (`nomzav`, openz, flag, iduopen)
values ('$numzav'+1,'$today', '1','$user')";
if(mysql_query($query1) and mysql_query($query3))
{
Header ("Location: newzav.php");
}
else
123
{
echo "<p class='log'></p>Не получилось</p>";
}
}