118
}
else
{
echo "Не получилось";
}
}
}
?>
</td>
</tr>
</table>
<table>
<tr>
<td colspan="3">
<form method="post" id="regisrt">
<p class="date1">Исполнители<br></p>
</td>
</tr>
<tr>
<td >
<p class="log">
<select name="isp1">
<?php
while ($isp=mysql_fetch_row($res2))
{
echo "<option value='$isp[0]'>$isp[1]</option>\n";
}
?>
</select></p><br>
</td>
<td valign="top">
<input type="submit" name="isp" value=" Добавить в
наряд ">
</form>
</td>
<td valign="top" >
<?php
require "dbconnect.php";
if(isset($_POST['isp']))
{
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$query1="insert into narad (idispn, nomnar) values ('".$_POST['isp1']."','$nar_mas[0]')";
if(mysql_query($query1))
{
echo "Добавлено";
}
else
{
echo "Не получилось";
}
}
119
}
?>
</td>
</tr>
</table>
<table>
<tr>
<td colspan="3">
<form method="post" id="regisrt">
<p class="date1">ГЗ<br></p>
</td>
</tr>
<tr>
<td >
<p class="log">
<select name="gz1">
<?php
while ($gz=mysql_fetch_row($res4))
{
echo "<option value='$gz[0]'>$gz[1]</option>\n";
}
?>
</select></p><br>
</td>
<td valign="top">
<input type="submit" name="gz" value=" Добавить в
наряд ">
</form>
</td>
<td valign="top" >
<?php
require "dbconnect.php";
if(isset($_POST['gz']))
{
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$query1="insert into narad (idgzn, nomnar) values ('".$_POST['gz1']."','$nar_mas[0]')";
$up1="update gz set nalgz=nalgz-1 where idgz='".$_POST['gz1']."'";
if(mysql_query($query1) and mysql_query($up1) )
{
echo "Добавлено";
}
else
{
echo "Не получилось";
}
}
}
?>
</td>
</tr>
</table>
120
<table>
<tr>
<td colspan="3">
<form method="post" id="regisrt">
<p class="date1">PP<br></p>
</td>
</tr>
<tr>
<td >
<p class="log">
<select name="rr1">
<?php
while ($rr=mysql_fetch_row($res5))
{
echo "<option value='$rr[0]'>$rr[1]</option>\n";
}
?>
</select></p><br>
</td>
<td valign="top">
<input type="submit" name="rr" value=" Добавить в
наряд ">
</form>
</td>
<td valign="top" >
<?php
require "dbconnect.php";
if(isset($_POST['rr']))
{
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$query1="insert into narad (idrrn, nomnar) values ('".$_POST['rr1']."','$nar_mas[0]')";
$up2="update rr set nalrr=nalrr-1 where idrr='".$_POST['rr1']."'";
if(mysql_query($query1) and mysql_query($up2))
{
echo "Добавлено";
}
else
{
echo "Не получилось";
}
}
}
?>
</td>
</tr>
</table>
<table>
<tr>
<td colspan="3">
<form method="post" id="regisrt">
<p class="date1">ЗУ<br></p>
121
</td>
</tr>
<tr>
<td >
<p class="log">
<select name="zu1">
<?php
while ($zu=mysql_fetch_row($res6))
{
echo "<option value='$zu[0]'>$zu[1]</option>\n";
}
?>
</select></p><br>
</td>
<td valign="top">
<input type="submit" name="zu" value=" Добавить в
наряд ">
</form>
</td>
<td valign="top" >
<?php
require "dbconnect.php";
if(isset($_POST['zu']))
{
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$query1="insert into narad (idzun, nomnar) values ('".$_POST['zu1']."','$nar_mas[0]')";
$up3="update zu set nalzu=nalzu-1 where idzu='".$_POST['zu1']."'";
if(mysql_query($query1) and mysql_query($up3))
{
echo "Добавлено";
}
else
{
echo "Не получилось";
}
}
}
?>
</td>
</tr>
<tr>
<td colspan="3"> <center>
<a href="blank.php"> <p class="table10"> Сформировать бланк наряда </p> </a>
</td>
</table>
<br>
</center>
</td>
</tr>
</table><br>
122
</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>
";
}
$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> Объект </th>
<th><center> Инцидент </th>
<th><center> Примечание </th>
</tr>\n";
$a=0;
while($ob_mas=mysql_fetch_row($ob))
{
123
$a=$a+1;
$chet=$a%2;
if ($chet==0)
{
$tab=table1;
}
else {
$tab=table2;
}
echo "<tr class='$tab'><td> $ob_mas[0] </td>
<td> $ob_mas[1] </td>
<td> $ob_mas[2] </td>
<td> $ob_mas[3] </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))
{
$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> $mts11[0] </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
");
124
echo "<table border='0' bgcolor='#ffffff'>\n";
echo " <tr class='table'><th><center> Мод/Тип ЗУ </th>
</tr>\n";
while($mts22=mysql_fetch_row($mts2) )
{
echo "<tr class='$tab'><td> $mts22[0] </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> Мод/Тип ГЗ </th>
</tr>\n";
while($mts33=mysql_fetch_row($mts3))
{
echo "<tr class='$tab'><td> $mts33[0]</td>
</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))
125
{
$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>
</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,
126
rangelength:[3,12]
},
parol: {
required: true,
rangelength:[3,12]
}
}
}
);
$(this).corner();
});
</script>
<link rel="stylesheet" type="text/css" href="style.css">
<body >
<br><br>
<?php
include "verch.php";
?>
<br><br><br>
<center>
<table align="center" cellspacing="0" cellpadding="0" border="0" >
<tr>
<td colspan="2" align="center">
<ul class="tab">
<li ><a href="reg.php"><span>Учет заявок </span></a></li>
<li ><a href="prosmotr.php"><span>Заявки</span></a></li>
<li ><a href="igri.php"><span>Наряд</span></a></li>
<li class="active"><a href="res.php"><span>Архив заявок</span></a></li>
<li ><a href="zajavka.php"><span>Отчеты</span></a></li>
<li ><a href="history.php"><span>МТС</span></a></li>
<li ><a href="dannie.php"><span>Мои данные</span></a></li>
<li><a href="loginman.php"><span>Выход</span></a></li>
</td>
</tr>
</table>
<table width="900" align="center" cellspacing="0" cellpadding="0" border="0" bgcolor="#ffffff"
class="rc10">
<tr>
<td>
<br>
<center>
<table align="center" cellspacing="2" cellpadding="2" border="0" bgcolor="white" width="250">
<tr>
<td align="center"> <form method="post" id="regisrt">
<p class="pp">Просмотр заявок за</p><br><p class="log">Дата в формате ГГГГ-ММ-ДД <br>
<input type="text" name="nomerP" class="required" title="<br>
Введите число"></p><br>
<center>
</td>
<td >
</tr>
<tr> <td colspan="3">
127
<center>
<input type="submit" name="limit" value=" Смотреть
">
</form>
</td>
</tr>
</table>
<?php
require "dbconnect.php";
if(isset($_POST['limit']))
{
$l1=$_POST['nomerP'];
echo "<div> Заявки на $l1 </div> ";
echo "<table border='0' cellpadding='50' bgcolor='#ffffff'>\n";
echo " <tr class='table'><th><center>Номер</th><th><center> Дата и время </th>
<th><center> Объект </th>
<th><center> Инцидент </th>
<th><center> Подробнее </th>
</tr>\n";
$l1=$_POST['nomerP'];
$limit1=mysql_query("select datez from zajavka where datez like '%$l1%'");
while($lim1_mas=mysql_fetch_row($limit1))
{
$res_id=mysql_query("SELECT `idz`, `datez`, namek, nameinz from zajavka, inz, kust where
`idkz`=idk and `idiz`=idinz and otm=1 and datez='$lim1_mas[0]'");
$a=1;
while($prise_mas=mysql_fetch_row($res_id))
{
$a=$a+1;
$chet=$a%2;
$ttt=date("Y-m-d", time());
$rest = substr("$ttt", 8,2);
$rest1 = substr("$prise_mas[1]", 8,2);
if ($rest1==$rest)
{
if ($chet==0)
{
$tab=table1;
}
else {
$tab=table2;
}
}
else
{
$tab=table3;
}
echo "<tr class='$tab'>
<td> $prise_mas[0] </td>
<td> $prise_mas[1] </td>
<td> $prise_mas[2]</td>
<td> $prise_mas[3] </td>
<td><form method='post' name='match' action='matchs1.php'>