107
</td>
</tr>
<tr class="line"> <td colspan="2"> </td> </tr> </table>
<?php
require "dbconnect.php";
$res1=mysql_query("SELECT idzav, `namezav`, priorzav, desczav, activzav,
katzav, filezav, commzav
FROM `zav`, status where iduzav='$user' and deletz!=1 and flag!=5 and
nomzav=idzav");
$a=1;
while($res_id=mysql_fetch_row($res1))
{
$res=mysql_query("SELECT flag,openz, rasp, idrasp, proz, idproz, test,
idtest, clos, idclos from status where iduopen='$user' and
nomzav='$res_id[0]'");
while($sod=mysql_fetch_row($res))
{
$sod1=$sod[1];
$sod2=$sod[2];
$sod3=$sod[4];
$sod4=$sod[6];
if ($sod[0]==1)
{
$del="<form method='post' name='userpr' action='udal.php'>
<INPUT TYPE='hidden' NAME='userpr' VALUE='$res_id[0]'>
<input type='image' src='image/24-emptytrash.png' TITLE='Удалить заявку'
WIDTH='30' HEIGHT='30' >
</form>";
}
108
else {
$del=" ";
};
switch ($sod[0]) {
case 1:
$status="Открыта";
$dat=$sod[1];
$logo="image/open.png";
break;
case 2:
$status="Распределена";
$dat=$sod[2];
$logo="image/rasp.png";
break;
case 3:
$status="В процессе";
$dat=$sod[4];
$logo="image/proz.png";
break;
case 4:
$status="На проверке";
$dat=$sod[6];
$logo="image/test.png";
break;
}
if ($sod[0]==1 or $sod[0]==2)
{
$isp="<img src='image/infoisp1.png' TITLE='Исполнитель не назначен'
WIDTH='30' HEIGHT='30' border='0'>";
}
else
109
{
$isp="<div>
<a href='index.htm' onclick='return hs.htmlExpand(this)'>
<img src='image/infoisp.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='250' class='but1'> Имя</td>
<td width='100' class='table'>Иванов А. А.</td>
</tr>
<tr>
<td class='but1'> Должность</td>
<td class='table'>Специалист</td>
</tr>
</table>
</div>
</div>";
}
}
switch ($res_id[2]) {
case 1:
$title="Низкий";
$pr="image/ballblue.png";
break;
case 2:
$title="Средний";
$pr="image/ballgreen.png";
110
break;
case 3:
$title="Высокий";
$pr="image/ballyellow.png";
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>
111
<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)'>
<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>
112
<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'>
</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>
113
</tr> </table>\n";
$a=$a+1;
}
?>
</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">
114
</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");
$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>
115
<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'>
116
<!-- вот здесь вся инфа-->
<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>