128
<INPUT TYPE='hidden' NAME='match' VALUE='$prise_mas[0]'>
<input type='submit' value='Подробнее'> </form></td>
</tr>\n";
}
}
}
?>
<br>
<br>
</td>
</tr>
</table><br>
</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 >
<br><br>
<?php
include "verch.php";
?>
<br><br><br>
<center>
129
<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><br>
<center>
<?php
require "dbconnect.php";
if(isset($_POST['match']))
{
$l1=$_POST['match'];
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>
<th><center> Подал </th>
<th><center> Прим. </th>
</tr>\n";
$res_id=mysql_query("SELECT idz,`datez`, krnamedzap, famzap, namek, nameinz, krnamedzdng,
famzdng, prim from zajavka, szap, inz, kust , szdng, dzap, dzdng where idpod=idszdng and
`idprin`=idszap and `idkz`=idk and `idiz`=idinz and iddzap=idzap and iddzdng=idzdng and otm=1 and
idz='$l1'");
$a=1;
while($prise_mas=mysql_fetch_row($res_id))
{
echo "<tr class='table1'><td> $prise_mas[0] </td>
<td> $prise_mas[1] </td>
<td> $prise_mas[2] <br>
$prise_mas[3] </td>
<td> $prise_mas[4] </td>
<td> $prise_mas[5] </td>
<td> $prise_mas[6] <br> $prise_mas[7]
</td>
<td> $prise_mas[8] </td>
</tr>\n";
}
130
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>
<th><center> Прим </th>
</tr>\n";
$res=mysql_query("SELECT dateisp, timeisp, krnamedzap, famzap, nomnar, krnamerab, primisp
from zajavka, szap, dzap, narad, rabot where idzap=iddzap and `idszapz`=idszap
and idzn='$l1' and idz='$l1' and idr=idrabz");
while($prise=mysql_fetch_row($res))
{
echo "<tr class='table1'><td> $prise[0] </td>
<td> $prise[1] </td>
<td> $prise[2] <br>
$prise[3] </td>
<td> $prise[4] </td>
<td> $prise[5] </td>
<td> $prise[6] <br> $prise_mas[7]
</td>
</tr>\n";
}
}
?>
<br>
</center>
</td>
</tr>
</table><br>
</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,
131
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 ><a href="res.php"><span>Архив заявок</span></a></li>
<li class="active"><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>
<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>
132
<tr> <td colspan="3">
<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>
<th><center>Номер наряда</th>
<th><center> Работа </th>
</tr>\n";
$res1=mysql_query("SELECT idz from zajavka where otm=1 and datez like '%$l1%'");
while($prise1=mysql_fetch_row($res1))
{
$res2=mysql_query("SELECT nomnar from narad where idzn=$prise1[0]");
$res3=mysql_query("SELECT datez, namek, nameinz, dateisp, KRnameRab from zajavka, inz, kust ,
rabot where idz=$prise1[0] and idkz=idk and idiz=idinz and idr=idrabz");
while($prise3=mysql_fetch_row($res3) and $prise2=mysql_fetch_row($res2))
{
echo "<tr class='table1'><td> $prise1[0] </td>
<td> $prise3[0] </td>
<td> $prise3[1] </td>
<td> $prise3[2] </td>
<td> $prise3[3] </td>
<td> $prise2[0] </td>
<td> $prise3[4] </td>
</tr>\n";
}
}
}
?>
</td>
</tr>
</table><br>
</body>
</html>
<?php
133
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]
}
}
}
);
$ ('#regisrt1').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 >
<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">
134
<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 ><a href="res.php"><span>Архив заявок</span></a></li>
<li ><a href="zajavka.php"><span>Отчеты</span></a></li>
<li class="active"><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>
<?php
require "dbconnect.php";
echo "<table border='0' cellpadding='50' bgcolor='#ffffff' width='800'>\n";
echo " <tr class='table'><th> Код
РР </th><th> Кр. наименование
РР </th>
<th> Описание РР </th><th> В
наличии </th></tr>\n";
$res_id=mysql_query("SELECT `idRR`, `nameRR`, `opisRR`, `nalRR` from rr where ourr=0 order
by idrr");
$a=1;
while($prise_mas=mysql_fetch_row($res_id))
{
$a=$a+1;
$chet=$a%2;
if ($prise_mas[3]==0)
{
$tab=table3;
}
else {
if ($chet==0)
{
$tab=table1;
}
else {
$tab=table2;
}
}
echo "<tr
class='$tab'><td> $prise_mas[0] </td><td> &
nbsp;$prise_mas[1] </td>
<td> $prise_mas[2] </td><td> $prise
_mas[3] </td>
</tr>\n";
}
?>
135
<br>
<center>
<?php
require "dbconnect.php";
echo "<table border='0' cellpadding='50' bgcolor='#ffffff' width='800'>\n";
echo " <tr class='table'><th> Код
ГЗ </th><th> Кр. наименование
ГЗ </th>
<th> Завод-изготовитель
ГЗ </th><th> В
наличии </th></tr>\n";
$res_id=mysql_query("SELECT `idgz`, `namegz`, `zavod`, `nalgz` from gz where ougz=0 order by
idgz");
$a=1;
while($prise_mas=mysql_fetch_row($res_id))
{
$a=$a+1;
$chet=$a%2;
if ($prise_mas[3]==0)
{
$tab=table3;
}
else {
if ($chet==0)
{
$tab=table1;
}
else {
$tab=table2;
}
}
echo "<tr
class='$tab'><td> $prise_mas[0] </td><td> &
nbsp;$prise_mas[1] </td>
<td> $prise_mas[2] </td><td> $prise
_mas[3] </td>
</tr>\n";
}
echo "<br>
";
?>
<center>
<?php
require "dbconnect.php";
echo "<table border='0' cellpadding='50' bgcolor='#ffffff' width='800'>\n";
echo " <tr class='table'><th> Код
ЗУ </th><th> Тип ЗУ </th>
<th> Наименование ЗУ </th><th> В
наличии </th></tr>\n";
$res_id=mysql_query("SELECT `idzu`, `tipzu`, `namezu`, `nalzu` from zu where ouzu=0 order by
idzu");
$a=1;
136
while($prise_mas=mysql_fetch_row($res_id))
{
$a=$a+1;
$chet=$a%2;
if ($prise_mas[3]==0)
{
$tab=table3;
}
else {
if ($chet==0)
{
$tab=table1;
}
else {
$tab=table2;
}
}
echo "<tr
class='$tab'><td> $prise_mas[0] </td><td> &
nbsp;$prise_mas[1] </td>
<td> $prise_mas[2] </td><td> $prise
_mas[3] </td>
</tr>\n";
}
?>
<br>
</td>
</tr>
</table><br>
</body>
</html>
<?php
session_start();
?>
<html>
<head>
<title>Мои данные</title>
</head>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="rounded-corners-min.js">
$(document).ready(function(){
$(this).corner();
});
</script>
<body>
<link rel="stylesheet" type="text/css" href="style.css">
<br><br>
<?php
include "verch.php";
137
?>
<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 ><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 class="active"><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>
<center>
<br><br>
<?php
require "dbconnect.php";
$res=mysql_query("SELECT namedzap, famzap, namezap, tabnom, razzap, login, pass
FROM szap, dzap where idszap='{$_SESSION['var']}' and idzap=iddzap ");
while($pla=mysql_fetch_row($res))
{
if ($pla[4]==1)
{
$amplua='Основной';
}
else
{
$amplua='Дополнительный';
};
echo
"<table>
<tr>
<td>
<table>
<tr>
<td class='table0' width='150'> Должность</td>
<td class='table1' width='350'>$pla[0]</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>