117
<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";
118
}
?>
</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>
119
</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)
{
120
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
121
{
echo "<p class='log'></p>Не получилось</p>";
}
}