100
break;
case 4:
$title="Критичный";
$pr="image/ballred.png";
break;
}
if ($res_id[6]!=0)
{
$file="<a href='download/$res_id[6]' >
<img src='image/paperclip.png' TITLE='Скачатьфайл' WIDTH='30'
HEIGHT='30' border='0'>
</a>";
}
else
{
$file="<img src='image/paperclip1.png' TITLE='Нетфайла' WIDTH='30'
HEIGHT='30' border='0'>";
}
echo " <center><table align='center' width='800'><tr>
<td width='30' class='but1'><b> $a </b></td>
<td width='50' class='tz'> $res_id[0] </td>
<td width='50' class='tz'><img src='$logo' title='$status' WIDTH='30'
HEIGHT='30' border='0'></td>
<td width='50' class='tz'><img src='$pr' title='$title' WIDTH='30'
HEIGHT='30' border='0'></td>
<td width='50' class='tz'> $file </td>
<td width='80' class='tz'> $dat </td>
<td width='200' class='tz'> $res_id[1] </td>
<td width='30' class='tz'><div>
<a href='index.htm' onclick='return hs.htmlExpand(this)'>
101
<img src='image/info.png' TITLE='Подробнаяинформацияозаявке'
WIDTH='30' HEIGHT='30' border='0'>
</a>
<div class='highslide-maincontent'>
<h4>Подробные сведения Заявка № $res_id[0]</h4>
<table width='350' border='1' cellspacing='2' cellpadding='2'>
<tr>
<td width='80' class='table'> Описание</td>
<td width='270' class='kvit'>$res_id[3]</td>
</tr>
<tr>
<td class='table'> Кабинет</td>
<td class='kvit'>$res_id[4]</td>
</tr>
<tr>
<td class='table'> Категории</td>
<td class='kvit'>$res_id[5]</td>
</tr>
<tr>
<td class='table'> Комментарий</td>
<td class='kvit'>$res_id[7]</td>
</tr>
</table>
</div>
</div>
</td>
<td width='30' class='tz'> $isp
</td>
<td width='30' class='tz'><div>
<a href='index.htm' onclick='return hs.htmlExpand(this)'>
<img src='image/application-x-trash.png' TITLE='Жизненныйциклзаявки'
WIDTH='30' HEIGHT='30' border='0'>
102
</a>
<div class='highslide-maincontent'>
<h4>Жизненный цикл Заявка № $res_id[0]</h4>
<table width='350' border='1' cellspacing='2' cellpadding='2'>
<tr>
<td width='100' class='table'> Открыта</td>
<td width='150' class='kvit'>$sod1</td>
</tr>
<tr>
<td class='table'> Распределена</td>
<td class='kvit'>$sod2</td>
</tr>
<tr>
<td class='table'> В процессе (принята исполнителем)</td>
<td class='kvit'>$sod3</td>
</tr>
<tr>
<td class='table'> Напроверке</td>
<td class='kvit'>$sod4</td>
</tr>
</table>
</div>
</div>
</td>
<td class='$class' width='50'> $del </td>
</tr></table>\n";
$a=$a+1;
}
103
?>
</div>
</div>
<br>
<br>
</body>
</html>
<body>
<?php include "menuadmin.php"; ?>
<div id='content'>
<div id='content1'>
<!-- вотздесьвсяинфа-->
<br>
<br>
<table width="100%" border="1" cellspacing="5" cellpadding="5">
<tr>
<td valign="top" ><h3> Редактирование списка пользователей
</h3></td><td valign="top">
</td>
</tr>
<tr class="line"> <td colspan="2"> </td> </tr></table>
<?php
require "../dbconnect.php";
$res=mysql_query("SELECT idu, nameuser, iduserotd, status, password, login,
nameo FROM user, otdel where udaluser=0 and iduserotd=ido");
104
$a=1;
while($res_id=mysql_fetch_row($res))
{
switch ($res_id[3]) {
case 1:
$title="Администратор";
break;
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]'>
105
<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'>
<divid='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>
106
</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>
<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());
107
$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>
108
</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>
</table>
</div>
</div>
<br>
<br>
</body>
</html>
109
<?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/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)