111
{
echo "<tr><tdclass='tr'>Постатье<b>
$nameobрасходовнезафиксировано</td></tr> ";
}
}
}
$all=mysql_query("SELECT sum(prise*kolvochet) FROM `chetfakt`, obor, prod
where idprodchet=idprod and ido=idtz and nomer=$nommm ");
while($all_stat=mysql_fetch_row($all))
{
echo "<tr><td class='tarivnew'>Весьбюджет - $all_stat[0] рублей</td></tr> ";
}
echo "</table>\n";
}
?>
<?php
require "conf/dbconnect.php";
if(isset($_POST['chetfaktfakt']))
{
echo "<span class='pp'>Анализбюджета</span>";
$chetfakt=$_POST['idtz'];
$sod1=mysql_query("SELECT nomer, datechet, idklientchet
FROM chetfakt
WHERE idchet=$chetfakt");
while($sod_mas1=mysql_fetch_row($sod1))
{
$_SESSION['nommm']=$sod_mas1[0];
}
echo "<table>
<tr>
<td class='' width='550' ><b><span class=''>Статья</span></td><td class=''
width='100'>Факт</td><td class='' width='100'>План</td><td class=''
width='100'>Экономия/<br>Перерасход</td></b>
</tr>
";
$obor=mysql_query("SELECT ido, nameob FROM obor ");
while($obormas=mysql_fetch_row($obor))
{
$obortip=$obormas[0];
$nameob=$obormas[1];
$nommm=$_SESSION['nommm'];
$stat=mysql_query("SELECT COUNT(idchet)
112
FROM chetfakt, obor, prod WHERE idprod=idprodchet AND ido=idtz AND
idtz=$obortip AND nomer=$nommm");
while($statmas=mysql_fetch_row($stat))
{
if ($statmas[0]!=0)
{
$vsego=mysql_query("SELECT sum(prise*kolvochet) FROM `chetfakt`, obor, prod
where idprodchet=idprod and ido=idtz and nomer=$nommm and ido=$obortip");
while($vsego_stat=mysql_fetch_row($vsego))
{
if ($vsego_stat[0]>0)
{
$roz=$vsego_stat[0];
}
else
{
$roz=0;
}
}
$vsegoplan=mysql_query("SELECT sum(prise*kolvochet) FROM `chet`, obor, prod
where idprodchet=idprod and ido=idtz and nomer=$nommm and ido=$obortip");
while($vsegoplan_stat=mysql_fetch_row($vsegoplan))
{
$rozplan=$vsegoplan_stat[0];
if ($vsegoplan_stat[0]>0)
{
$rozplan=$vsegoplan_stat[0];
}
else
{
$rozplan=0;
}
}
$razn=$roz-$rozplan;
if ($razn>0)
{
$cvet=table3;
}
else
{
$cvet=table4;
}
echo " <center><tr>
113
<td class='tr' width='550' ><b><span class='but2'>Итогозастатью</span>
$nameob</td><td class='tarivold' width='100'> $rozруб. </td><td class='tarivold'
width='100'> $rozplanруб. </td><td class='$cvet' width='100'> $raznруб. </td></b>
</tr> ";
}
}
}
$all=mysql_query("SELECT sum(prise*kolvochet) FROM `chetfakt`, obor, prod
where idprodchet=idprod and ido=idtz and nomer=$nommm ");
while($all_stat=mysql_fetch_row($all))
{
$allfakt=$all_stat[0];
}
$all1=mysql_query("SELECT sum(prise*kolvochet) FROM `chet`, obor, prod where
idprodchet=idprod and ido=idtz and nomer=$nommm ");
while($all_stat1=mysql_fetch_row($all1))
{
$allplan=$all_stat1[0];
$allb=$allfakt-$allplan;
if ($allb>0)
{
$cvet1=table3;
$cvet2="Перерасход";
}
else
{
$cvet1=table4;
$cvet2="Экономия";
}
echo "<tr><td class='tarivnew'>Весьбюджет</td><td class='tarivold'>факт -
$allfaktруб.</td><td class='tarivold'>план - $allplanруб. </td><td class='$cvet1'>
$cvet2 <br> $allb</td></tr> ";
}
echo "</table>\n";
}
?>
</div>
<br>
<br>
</body>
</html>