Дипломная работа: Автоматизация приема заявок на ремонт и модернизацию пк в ООО "Гео-свет"

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
138
</table>
<br>
</center>
</td>
</tr>
</table><br>
</body>
</html>
<?php
session_start();
?>
<html>
<title>Бланк наряда на работы</title>
<head bodycolor="000011">
<link rel="stylesheet" type="text/css" href="style.css">
<body >
<br><br>
<center>
<table width="900" align="center" cellspacing="0" cellpadding="0" border="0"
bgcolor="#ffffff" class="rc10">
<tr>
<td>
<br><br>
<center>
<table border="0">
<tr>
<td colspan="3">
<?php
require "dbconnect.php";
$narad=mysql_query("SELECT max(nomnar), max(daten) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
echo "<div> Наряд на работы № $nar_mas[0] </div> <br>
<center> Сформирован <u> $nar_mas[1] </u>";
}
$vidal=mysql_query("SELECT krnamedzap, famzap from szap, dzap where
idszap='{$_SESSION['var']}' and idzap=iddzap");
while($vid_mas=mysql_fetch_row($vidal))
{
echo "<p class='zag'> Выдал $vid_mas[0] $vid_mas[1] </p>
Филиал ООО 'РН-Информ' ЦАП-1-'БН' Барсуковский участок
";
139
}
$narad=mysql_query("SELECT max(nomnar), max(daten) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$ob=mysql_query("SELECT idz, namek, nameinz, prim from narad, zajavka, kust, inz
where nomnar='$nar_mas[0]' and idz=idzn and idkz=idk and idiz=idinz");
echo "<table border='0' cellpadding='50' bgcolor='#ffffff'>\n";
echo " <tr class='table'><th><center>№
заявки</th><th><center>&nbsp;Объект&nbsp;</th>
<th><center>&nbsp;Инцидент&nbsp;</th>
<th><center>&nbsp;&nbsp;&nbsp;Примечание&nbsp;&nbsp;&nbsp;</th>
</tr>\n";
$a=0;
while($ob_mas=mysql_fetch_row($ob))
{
$a=$a+1;
$chet=$a%2;
if ($chet==0)
{
$tab=table1;
}
else {
$tab=table2;
}
echo "<tr class='$tab'><td>&nbsp;&nbsp;&nbsp;$ob_mas[0]&nbsp;&nbsp;&nbsp;</td>
<td>&nbsp;&nbsp;&nbsp;$ob_mas[1]&nbsp;&nbsp;&nbsp;</td>
<td>&nbsp;&nbsp;&nbsp;$ob_mas[2] </td>
<td>&nbsp;&nbsp;&nbsp;$ob_mas[3]&nbsp;&nbsp;&nbsp;</td>
</tr>\n";
}
}
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table>
<tr>
<td >
<?php
require "dbconnect.php";
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
140
$mts1=mysql_query("SELECT namerr from narad, rr where nomnar='$nar_mas[0]' and
idrr=idrrn ");
echo "<table border='0' bgcolor='#ffffff'>";
echo " <tr class='table'><th><center>Мод/Тип РР
</th></tr>";
while($mts11=mysql_fetch_row($mts1) )
{
echo "<tr class='$tab'><td>&nbsp;&nbsp;&nbsp;$mts11[0]&nbsp;&nbsp;&nbsp;</td>
</tr>";
}
}
?>
</td> </tr> </table>
</td>
<td>
<?php
require "dbconnect.php";
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$mts2=mysql_query("SELECT namezu from narad, zu where nomnar='$nar_mas[0]' and
idzu=idzun ");
echo "<table border='0' bgcolor='#ffffff'>\n";
echo " <tr class='table'><th><center>&nbsp;Мод/Тип ЗУ&nbsp;</th>
</tr>\n";
while($mts22=mysql_fetch_row($mts2) )
{
echo "<tr class='$tab'><td>&nbsp;&nbsp;&nbsp;$mts22[0]&nbsp;&nbsp;&nbsp;</td>
</tr>\n";
}
}
?>
</td> </tr> </table>
</td>
<td>
<?php
require "dbconnect.php";
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$mts3=mysql_query("SELECT namegz from narad, gz where nomnar='$nar_mas[0]' and
idgz=idgzn ");
echo "<table border='0' bgcolor='#ffffff'>\n";
echo " <tr class='table'><th><center>&nbsp;Мод/Тип ГЗ&nbsp;</th>
</tr>\n";
while($mts33=mysql_fetch_row($mts3))
{
echo "<tr class='$tab'><td>&nbsp;&nbsp;&nbsp;$mts33[0]</td>
141
</tr>\n";
}
}
?>
</td> </tr> </table>
</td>
</tr>
</table>
<br>
<table>
<tr>
<td>
<?php
require "dbconnect.php";
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$isp=mysql_query("SELECT famzap from narad, szap where nomnar='$nar_mas[0]' and
idszap=idispn ");
echo "Исполнители\n";
while($isp_mas=mysql_fetch_row($isp))
{
echo "<u class='table10'> $isp_mas[0]</u>";
}
}
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$dd=mysql_query("SELECT famd, car, gosnom from narad, drivers where
nomnar='$nar_mas[0]' and idd=iddn ");
while($dd_mas=mysql_fetch_row($dd))
{
echo " <br>
Водитель - <u class='table10'> $dd_mas[0]</u> Машина <u class='table10'>
$dd_mas[1]</u> Госномер -<u class='table10'> $dd_mas[2]</u>";
}
}
?>
</td>
</tr>
</table>
<br>
</center>
142
</td>
</tr>
</table><br>
<table>
<tr>
<td colspan="3"> <center>
<a href="igri.php"> <p class="table10"> Назад </p> </a>
</td>
</tr>
</table>
</body>
</html>
<?php
session_start();
?>
<html>
<title>Поданные заявки</title>
<head bodycolor="000011">
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="jquery.validate.min.js"></script>
<script type="text/javascript" src="rounded-corners-min.js"></script>
<script type="text/javascript" >
$(document).ready(function(){
$ ('#regisrt').validate(
{
rules: {
login: {
required: true,
rangelength:[3,12]
},
parol: {
required: true,
rangelength:[3,12]
}
}
}
);
$(this).corner();
});
</script>
<link rel="stylesheet" type="text/css" href="style.css">
<body >
Источник: https://baza.diplomsite.ru/previewfile/1937