128
<li class="active"><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 ><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']))
{
$_SESSION['match']=$_POST['match'];
}
?>
<?php
require "dbconnect.php";
$res1=mysql_query("SELECT * FROM `szap` where idzap!=14 and idzap!=18")
or die(mysql_error());
$rol=mysql_num_rows($res1);
?>
<?php
require "dbconnect.php";
$res2=mysql_query("SELECT * FROM `rabot`")
or die(mysql_error());
$rab=mysql_num_rows($res2);
?>
<table >
<tr>
<td align="center" cellspacing="30" cellpadding="20">
<form method="post" id="regisrt"><p class="date1">
Заявку выполнил<br></p><p class="log">
<select name="pod">
<?php
while ($rol=mysql_fetch_row($res1))
{
echo "<option value='$rol[0]'>$rol[1]</option>\n";
}
?>
129
</select>
</p><br>
</td>
<td align="center" cellspacing="30" cellpadding="20">
<p class="date1">Дата исполнения<br></p><p class="log">
<input type="text" size="20" value="" name="date" class="required"
title="<br>
Поле обязательно к заполнению"></p><br>
</td>
<td align="center" cellspacing="30" cellpadding="20">
<p class="date1">Время исполнения<br></p><p class="log">
<input type="text" size="20" value="" name="time" class="required" title="<br>
Поле обязательно к заполнению"></p><br>
</td>
</tr>
<tr >
<td colspan="3">
<p class="date1">
Наименование работы<br></p><p class="log">
<select name="rab">
<?php
while ($rab=mysql_fetch_row($res2))
{
echo "<option value='$rab[0]'>$rab[1]</option>\n";
}
?>
</select>
</p><br>
</tr>
<tr >
<tr >
<td colspan="3">
<p class="date1">Примечание<br></p><p class="log">
<textarea rows="2" cols="50" name="prim"></textarea>
</p><br>
</tr>
<tr >
<td colspan="3"> <center>
<input type="submit" name="zakr" value="Закрыть">
</form>
<br>
</td>
</td></tr>
</table>
130
<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,
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>
131
<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 class="active"><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 ><a href="dannie.php"><span>Мои данные</span></a></li>
<li><a href="loginman.php"><span>Выход</span></a></li>
</td>
</tr>
</table>
<?php
require "dbconnect.php";
$res1=mysql_query("SELECT * FROM `drivers`")
or die(mysql_error());
$dr=mysql_num_rows($res1);
$res2=mysql_query("SELECT * FROM `szap` where otmudal=0");
$isp=mysql_num_rows($res2);
$res3=mysql_query("SELECT idz FROM `zajavka`")
or die(mysql_error());
$zzz=mysql_num_rows($res3);
$res4=mysql_query("SELECT * FROM `gz` where nalgz>0 and ougz=0")
or die(mysql_error());
$gz=mysql_num_rows($res4);
$res5=mysql_query("SELECT * FROM `rr` where nalrr>0 and ourr=0")
or die(mysql_error());
$rr=mysql_num_rows($res5);
$res6=mysql_query("SELECT * FROM `zu` where nalzu>0 and ouzu=0")
or die(mysql_error());
$zu=mysql_num_rows($res6);
?>
<table width="900" align="center" cellspacing="0" cellpadding="0" border="0"
bgcolor="#ffffff" class="rc10">
<tr>
<td>
<br><br>
<center>
<table>
<tr>
<td colspan="3">
<form method="post" id="regisrt">
<p class="date1">Водитель<br></p>
132
</td>
</tr>
<tr>
<td >
<p class="log">
<select name="kom1">
<?php
while ($dr=mysql_fetch_row($res1))
{
echo "<option value='$dr[0]'>$dr[1]</option>\n";
}
?>
</select></p><br>
</td>
<td valign="top">
<input type="submit" name="dr"
value=" Добавить в
наряд ">
</form>
</td>
<td valign="top" >
<?php
require "dbconnect.php";
if(isset($_POST['dr']))
{
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$narad1=$nar_mas[0]+1;
$query1="insert into narad (iddn, nomnar) values ('".$_POST['kom1']."','$narad1')";
if(mysql_query($query1))
{
echo "Добавлено";
}
else
{
echo "Не получилось";
}
}
}
?>
</td>
</tr>
</table>
<table>
<tr>
<td colspan="3">
133
<form method="post" id="regisrt">
<p class="date1">Введите номер заявки<br></p>
</td>
</tr>
<tr>
<td >
<p class="log">
<input type="text" size="20" value="" name="zzz1" class="required" title="<br>
Поле обязательно к заполнению"></p><br>
</td>
<td valign="top">
<input type="submit" name="zzz"
value=" Добавить в
наряд ">
</form>
</td>
<td valign="top" >
<?php
require "dbconnect.php";
if(isset($_POST['zzz']))
{
$narad=mysql_query("SELECT max(nomnar) from narad");
while($nar_mas=mysql_fetch_row($narad))
{
$query1="insert into narad (idzn, nomnar) values ('".$_POST['zzz1']."','$nar_mas[0]')";
if(mysql_query($query1))
{
echo "Добавлено";
}
else
{
echo "Не получилось";
}
}
}
?>
</td>
</tr>
</table>
<table>
<tr>
<td colspan="3">
<form method="post" id="regisrt">
<p class="date1">Исполнители<br></p>
</td>
</tr>
<tr>
134
<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 "Не получилось";
}
}
}
?>
</td>
</tr>
</table>
<table>
<tr>
<td colspan="3">
<form method="post" id="regisrt">
<p class="date1">ГЗ<br></p>
</td>
</tr>
135
<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>
<table>
<tr>
<td colspan="3">
<form method="post" id="regisrt">
<p class="date1">PP<br></p>
136
</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">
137
<p class="date1">ЗУ<br></p>
</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>