87
or die(mysql_error());
$res_id23=mysql_query("SELECT idgild, nameG FROM `gild`")
or die(mysql_error());
$res_id2=mysql_query("SELECT idprod, nameprod, art,edizmpr FROM
`prod`")
or die(mysql_error());
?>
<p class="pp">
Анализ потребности<br>
</p>
<!-- начало основной таблицы -->
<?php
require "dbconnect.php";
$res_id13=mysql_query("SELECT distinct idgild, nameG FROM `gild`, chet
where sklad=idgild and status=0");
while($nomer_mas11=mysql_fetch_row($res_id13) )
{
$sklad=$nomer_mas11[0];
$skladname=$nomer_mas11[1];
echo " <br> <p class='tarivold'> Потребность в продукции на $skladname
</p>";
$nomer=mysql_query("SELECT nomer FROM chet where status=0 and
sklad=$sklad");
while($nomerdok=mysql_fetch_row($nomer) )
{
echo "<table border='0' align='center' width='890'>\n";
echo "<tr class='tr'><th width='200'> Наименование
</th>
<th width='100'> Артикул </th>
88
<th width='100'> Единица
измерения </th>
<th width='100'> В наличии </th>
<th width='100'> Требуется </th>
<th width='100'> Разница </th>
<th width='100'> № накл. <form
method='post' name='spis' action='an.php'>
<INPUT TYPE='hidden' NAME='spis' VALUE='$nomerdok[0]'>
<input type='image' src='image/close.png' TITLE='Закрыть накладную'
WIDTH='20' HEIGHT='20' >
</form> </th>
</tr>";
$nomerdok1=$nomerdok[0];
$res=mysql_query("SELECT `nameprod`,`art`,`edizmpr`,kolvonal, kolvochet,
kolvonal-kolvochet FROM `prod`, nal, chet where udalPr=0 and
idprodnal=idprod and idskladnal=$sklad and nomer=$nomerdok1 and
idprod=idprodchet");
while($res_id=mysql_fetch_row($res) )
{
if ($res_id[5]>0)
{
$class=tz;
}
else
{
$class=table3;
}
if ($res_id[5]==0)
{
$class=log;
89
}
echo " <center> <tr>
<td width='200' class='$class'> $res_id[0] </td>
<td width='100' class='$class'> $res_id[1] </td>
<td width='100' class='$class'> $res_id[2] </td>
<td width='100' class='$class'> $res_id[3] </td>
<td width='100' class='$class'> $res_id[4] </td>
<td width='100' class='$class'> $res_id[5] </td>
<td width='100' class='$class'> $nomerdok1 </td>
</tr>
";
}
echo "</table>";
}
}
?>
<br>
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr >
<td width="30"> </td>
<td width="320" class="date1" >Выберите склад -поставщик</td>
<td width="30"> </td>
<td width="320" class="date1" >Выберите склад- приемщик </td>
<td width="30"> </td>
</tr>
<tr>
<td width="30"> </td>
90
<td width="320" class="log">
<form method="post" id="signup" action='an.php'>
<select name="sklad1"><center>
<?php
while ($gild=mysql_fetch_row($res_id3))
{
echo "<center><option value='$gild[0]'>$gild[1]</option>\n";
}
?>
</select>
</td>
<td width="30"> </td>
<td width="320" class="log">
<select name="sklad2"><center>
<?php
while ($gild1=mysql_fetch_row($res_id23))
{
echo "<center><option value='$gild1[0]'>$gild1[1]</option>\n";
}
?>
</select>
</td>
<td width="30"> </td>
</tr>
<tr>
<td colspan="5"> </td>
</tr>
91
<tr >
<td width="30"> </td>
<td width="320" class="date1" >Выберите продукцию</td>
<td width="30"> </td>
<td width="320" class="date1" >Введите количество продукции</td>
<td width="30"> </td>
</tr>
<tr>
<td width="30"> </td>
<td width="320" class="log">
<select name="prod"><center>
<option> </option>
<?php
while ($prod=mysql_fetch_row($res_id2))
{
echo "<option value='$prod[0]'>$prod[1] $prod[2] $prod[3]</option>\n";
}
?>
</select></td>
<td width="30"> </td>
<td width="320" class="log">
<input type="text" size="20" value="0" onFocus="doClear(this)"
onBlur="doDefault(this)" name="kolvoprod" class="required"
title="<br>
Поле обязательно к заполнению">
</td>
<td width="30"> </td>
</tr>
<tr>
92
<td colspan="5"> </td>
</tr>
<tr>
<td colspan="5" class="pp"><input type="submit" name="post"
value="Учесть" >
</form></td>
</tr>
<tr>
<td colspan="7"> </td>
</tr>
<tr>
<td colspan="7">
</td>
</tr>
</table>
<div>
</div>
</div>
<!--echo "<tr> <td colspan='6'> Итого </td> <td width='100' class='tr'>
$opt</td>
<td width='100' class='tr'> $ros </td> <tr> </table>\n";
93
$sumall=mysql_query("SELECT sum(kolvonal*optst), sum(kolvonal*rozst)
FROM `prod`, nal where udalPr=0 and idprodnal=idprod ");
while($summasall=mysql_fetch_row($sumall))
{
echo "<table> <tr> <td colspan='6'> Итого за все склады</td> <td width='100'
class='tr'> $summasall[0] рублей</td>
<td width='100' class='tr'> $summasall[1] рублей</td> <tr> </table>\n";
}
$sum=mysql_query("SELECT sum(kolvonal*optst), sum(kolvonal*rozst)
FROM `prod`, nal where udalPr=0 and idprodnal=idprod and
idskladnal=$sklad");
while($summas=mysql_fetch_row($sum))
{
$opt=$summas[0];
$ros=$summas[1];
}
while($res_id=mysql_fetch_row($res))
{
if ($res_id[7]>0)
{
$class=tz;
}
else
{
$class=table3;
} -->
<!-- конец фоновой таблицы -->
</body>
</html>
94
<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Strict//EN'
'http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd'>
<html xmlns='http://www.w3.org/1999/xhtml'>
<head>
<meta http-equiv='content-type' content='text/html; charset=windows-1251' />
<title></title>
<link rel='stylesheet' type='text/css' href='css/index.css' />
<link rel="stylesheet" type="text/css" href="js/jquery-ui-
1.7.2.custom.css">
<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="js/jquery-ui-
1.7.2.custom.min.js"></script>
<script type="text/javascript" src="js/ui.datepicker-
uk.js"></script>
<script type="text/javascript" src="js/jquery.validate.min.js"></script>
<script type="text/javascript" src="js/rounded-corners-min.js"></script>
<link rel="stylesheet" type="text/css" href="style.css">
<script type="text/javascript" >
$(document).ready(function(){
$('#datepicker1').datepicker({
changeMonth:true,
changeYear:true,
yearRange:"1950:2000",
dateFormat:"yy-mm-dd",
}
);
95
$('#datepicker2').datepicker({
changeMonth:true,
changeYear:true,
yearRange:"1950:2010",
dateFormat:"yy-mm-dd",
}
);
$('#datepicker').datepicker({
changeMonth:true,
changeYear:true,
yearRange:"1995:2010",
dateFormat:"yy-mm-dd",
}
);
$.validator.addMethod('validName', function (value) {
var result = true;
var iChars = "!@#$%^&*()+=-
[]\\\';,/{}|\":<>?"+"йцукенгшщзхъфывапролджэячсмитьбюЙЦУКЕНГШЩЗ
ХЪФЫВАПРОЛДЖЭЯЧСМИТЬБЮ";
for (var i = 0; i < value.length; i++) {
if (iChars.indexOf(value.charAt(i)) != -1) {
return false;
}
}
return result;
}, '');
$.validator.addMethod('validNamer', function (value) {
var result = true;
96
var iChars = "!@#$%^&*()+=-
[]\\\';,./{}|\":<>?012789"+"qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDF
GHJKLZXCVBNM"+" ";
for (var i = 0; i < value.length; i++) {
if (iChars.indexOf(value.charAt(i)) != -1) {
return false;
}
}
return result;
}, '');
$ ('#signup').validate({
rules:{
login: {
minlength:6,
validName: true,
},
pass: {
minlength:6,
validName: true,
},
conpass: {
equalTo:'#pass'
}
},
messages:{
login:{minlength:"Не менее шести символов",
validName: "Только латинский алфавит и цифры",
},