85
case 2:
$title="Пользователь";
break;
case 3:
$title="Диспетчер";
break;
case 4:
$title="Исполнитель";
break;
}
echo " <center><table><tr>
<td width='30' class='but1'><b> $a </b></td>
<td width='150' class='tz'> $res_id[6] </td>
<td width='200' class='tz'> $res_id[1] </td>
<td width='100' class='tz'> $title </td>
<td width='100' class='tz'> $res_id[4] </td>
<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'>
<!-- вот здесь вся инфа-->
<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>
86
<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>
<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";
}
?>
</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>
87
</tr>
</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)
{
echo ("Размерфайлапревышает 128 кбайт");
exit;
};
if(copy($_FILES["filename"]["tmp_name"],"C:/WebServers/home/localhost/www/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
{
echo "<p class='log'></p>Не получилось</p>";