Дипломная работа: Автоматизация приема и обработки заявок отделом техподдержки ООО "РУСЭЛПРОМ-СЭЗ"

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
121
$res=mysql_query("SELECT idu, nameuser, iduserotd, status, password, login, nameo,
namepk FROM user, otdel, pk where udaluser=0 and iduserotd=ido and idpkuser=idpk and
iduserotd like ('%".$_POST['otdel']."%')
and status like ('%".$_POST['status']."%') and nameuser like ('%".$_POST['fio']."%')");
}
$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[7] </td>
</tr> </table>\n";
$a=$a+1;
}
122
}
else
{
$res=mysql_query("SELECT idu, nameuser, iduserotd, status, password, login, nameo,
namepk FROM user, otdel, pk where udaluser=0 and iduserotd=ido and idpkuser=idpk");
$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[7] </td>
</tr> </table>\n";
$a=$a+1;
}
123
}
?>
</td>
<br><br>
</div>
</div>
<br>
<br>
</body>
</html>
adduser.php
<?php session_start();
?>
<head>
<meta http-equiv='content-type' content='text/html; charset=windows-1251' />
<title><?php include "../name.php";
echo $title;
?>
</title>
<link rel="stylesheet" type="text/css" href="../style.css">
<link rel="stylesheet" type="text/css" href="../css/style.css">
<script type="text/javascript">
hs.graphicsDir = '../js/highslide/graphics/';
hs.outlineType = 'rounded-white';
hs.wrapperClassName = 'draggable-header';
</script>
</head>
124
<body>
<?php include "menuadmin.php"; ?>
<div id='content'>
<div id='content1'>
<br>
<br>
<table width="100%" border="1" cellspacing="5" cellpadding="5">
<tr align="center">
<td valign="top" ><h3> Добавление сотрудников </h3></td> <td
valign="top">
</td>
</tr>
<tr class="line"> <td colspan="2">&nbsp; </td> </tr> </table>
<?php
require "../dbconnect.php";
$res_id1=mysql_query("SELECT ido, nameo FROM `otdel` where delo=0")
or die(mysql_error());
$res_id2=mysql_query("SELECT idpk, namepk FROM `pk` where udalpk=0")
or die(mysql_error());
?>
<table align="center" cellspacing="2" cellpadding="2" border="0" bgcolor="white"
width="910">
<tr>
<td><center> </td>
<td bgcolor="ffffff" valign="top" >
125
<center> <table align="center" cellspacing="2" cellpadding="2"
border="0" bgcolor="ffffff">
<tr>
<form method="post" id="signup">
<td class="but1">Фамилия, имя и отчество</td>
<td class=" "> <input type="text" size="40" name="nameuser" value=""
class="required"
title="<p class=' '>Только русский алфавит</p>"></td>
<td class="tr">Русские буквы</td>
</tr>
<tr>
<td class="but1">Отдел</td>
<td class=" ">
<select name="iduserotd"><center>
<?php
while ($tip=mysql_fetch_row($res_id1))
{
echo "<option value='$tip[0]'>$tip[1]</option>\n";
}
?>
</select>
</td>
<td class="tr">Выбор отдела</td>
</tr>
<tr>
<td class="but1">Статус в системе</td>
<td class=" ">
<select name="status"><center>
<option value="2">Пользователь</option>
Источник: https://baza.diplomsite.ru/previewfile/1983