Приложение Б (1203265), страница 3

Просмтор этого файла доступен только зарегистрированным пользователям. Но у нас супер быстрая регистрация: достаточно только электронной почты!

Текст из файла (страница 3)

$row4 = mysql_fetch_array($result4);

echo "<option class='form-control' value='".$row4['Id_category']."'>".$row4['Name_category']."</OPTION>";

}?>

</select><br>

<br> Подкатегория <select class='form-control' name='subcateg_req' ID="Subcateg">

<option value=''></OPTION>

</select>

<br>

<br> <input class="btn btn-danger" type='submit' name='Add' value = 'Добавить заявку'><br></form></CENTER>

<?php

require 'footer.php';

Config.php

<?php

$dblocation = "localhost";

$dbuser = "root";

$dbpasswd = "";

$dbname = "servicedesk";

$dbcnx = @mysql_connect($dblocation, $dbuser, $dbpasswd);

if(!$dbcnx)

{ echo "<h1>Сервер баз данных недоступен</h1>"; exit(); }

if(!@mysql_select_db($dbname, $dbcnx))

{ echo "<h1>База данных на сервере не доступна</h1>"; exit(); }

?>

Requests.php

<?php

require 'header.php';

?>

<table align="center">

<td>

<table align="center" class="tables table-bordered">

<?if ( $_GET['param']=='1'){?>

<CENTER><h2>Таблица открытых заявок</h2></CENTER><?}?>

<?if ( $_GET['param']=='2'){?>

<CENTER><h2>Таблица обрабатываемых заявок</h2></CENTER><?}?>

<?if ( $_GET['param']=='3'){?>

<CENTER><h2>Таблица заявок в паузе</h2></CENTER><?}?>

<?if ( $_GET['param']=='4'){?>

<CENTER><h2>Таблица решенных заявок</h2></CENTER><?}?>

<?if ( $_GET['param']=='5'){?>

<CENTER><h2>Таблица заявок</h2></CENTER><?}?>

<?if ( $_GET['param']=='6'){?>

<CENTER><h2>Таблица всех открытых заявок</h2></CENTER><?}?>

<?if ( $_GET['param']=='7'){?>

<CENTER><h2>Таблица всех обрабатываемых заявок</h2></CENTER><?}?>

<?if ( $_GET['param']=='8'){?>

<CENTER><h2>Таблица всех заявок в паузе</h2></CENTER><?}?>

<?if ( $_GET['param']=='9'){?>

<CENTER><h2>Таблица всех выполненных заявок</h2></CENTER><?}?>

<tr>

<td> Номер заявки: </td>

<td> Тема заявки: </td>

<td> Категория: </td>

<td> Подкатегория: </td>

<td> Статус заявки: </td>

<td> Специалист: </td>

</tr>

<tr>

<?php

$query4="select * from `Category`";

$result4=mysql_query($query4);

$num_results4=mysql_num_rows($result4);

$Cat_id=[];

for($i=0; $i<$num_results4; $i++)

{

$row4 = mysql_fetch_array($result4);

$Cat_id[$row4['Id_category']]=$row4['Name_category'];

}

//сопоставление ID_с наименованием

$query3="select * from `Subcategory`";

$result3=mysql_query($query3);

$num_results3=mysql_num_rows($result3);

for($i=0; $i<$num_results3; $i++)

{

$row3 = mysql_fetch_array($result3);

$Subcat_id[$row3['Id_subcategory']]=$row3['Name_subcategory'];

}

//сопоставление ID_с наименованием 2

if ( $_GET['param']=='1'){

$fio=$_SESSION['ID_U'];

$query="SELECT * FROM `request` where `status_request`='Открыта'&&(`Id_user`='$fio'||`technician_request`='$fio')";

$result=mysql_query($query);

$num_results=mysql_num_rows($result);

if($num_results>0)

{

for($i=0; $i<$num_results; $i++)

{

$row = mysql_fetch_array($result);

echo '<tr>';

$temp=$row['Id_request'];

$sp_n=$row['technician_request'];

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['Id_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['topic_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$Cat_id[$row['Id_category']],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$Subcat_id[$row['Id_subcategory']],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['status_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['technician_request'],'</a></td>';

echo '</tr>';

}

}}

elseif($_GET['param']=='2')

{

$fio=$_SESSION['ID_U'];

$query="SELECT * FROM `request` where `status_request`='Обработка'&&(`Id_user`='$fio'||`technician_request`='$fio')";

$result=mysql_query($query);

$num_results=mysql_num_rows($result);

if($num_results>0)

{

for($i=0; $i<$num_results; $i++)

{

$row = mysql_fetch_array($result);

echo '<tr>';

$temp=$row['Id_request'];

$sp_n=$row['technician_request'];

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['Id_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['topic_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$Cat_id[$row['Id_category']],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$Subcat_id[$row['Id_subcategory']],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['status_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['technician_request'],'</a></td>';

echo '</tr>';

}

}

}

elseif($_GET['param']=='3')

{

$fio=$_SESSION['ID_U'];

$query="SELECT * FROM `request` where `status_request`='Пауза'&&(`Id_user`='$fio'||`technician_request`='$fio')";

$result=mysql_query($query);

$num_results=mysql_num_rows($result);

if($num_results>0)

{

for($i=0; $i<$num_results; $i++)

{

$row = mysql_fetch_array($result);

echo '<tr>';

$temp=$row['Id_request'];

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['Id_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['topic_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$Cat_id[$row['Id_category']],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$Subcat_id[$row['Id_subcategory']],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['status_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['technician_request'],'</a></td>';

echo '</tr>';

}

}

}

elseif($_GET['param']=='4')

{

$fio=$_SESSION['ID_U'];

$query="SELECT * FROM `request` where `status_request`='Решено'&&(`Id_user`='$fio'||`technician_request`='$fio')";

$result=mysql_query($query);

$num_results=mysql_num_rows($result);

if($num_results>0)

{

for($i=0; $i<$num_results; $i++)

{

$row = mysql_fetch_array($result);

echo '<tr>';

$temp=$row['Id_request'];

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['Id_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['topic_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$Cat_id[$row['Id_category']],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$Subcat_id[$row['Id_subcategory']],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['status_request'],'</a></td>';

echo "<td><a href='requestOpen.php?param=$temp&name=$sp_n' target='windowName' onclick=\"window.open(this.href,this.target,'width=1200,height=500');

return false;\">",$row['technician_request'],'</a></td>';

echo '</tr>';

}

}

}

elseif($_GET['param']=='5')

{

$fio=$_SESSION['ID_U'];

$query="SELECT * FROM `request` ";

$result=mysql_query($query);

$num_results=mysql_num_rows($result);

if($num_results>0)

{

for($i=0; $i<$num_results; $i++)

Характеристики

Список файлов ВКР