$conn = mysql_connect("localhost", "dpr", "9ahaKE3a");
if (!$conn) {
echo "Unable to connect to DB: " . mysql_error();
exit;
}
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $conn);
if (!mysql_select_db("dpr1")) {
echo "Unable to select svfu: " . mysql_error();
exit;
}
?>
Главная >
Субсидия =$_REQUEST["year"]?> >
# |
Субсидия |
Кол-во договоров |
Сумма |
Кол-во исполненых договоров |
Кол-во не исполненых договоров |
Кол-во договоров исполненых частично |
$q = "SELECT * FROM cod_pokazatel";
$r = mysql_query($q);
while ($row = mysql_fetch_assoc($r))
{
$name = $row["name"];
$words = explode(" ", $row["name"]);
foreach($words as $value){
$sok = $sok . mb_substr($value,0,1);
}
?>
=mb_strtoupper($sok)?> |
$sok = "";
}
?>
$year = $_REQUEST["year"];
$q = "SELECT COUNT( * ) AS kolvo , Count(CASE WHEN sost=2 THEN 1 ELSE NULL END) AS sost_off , Count(CASE WHEN sost=1 THEN 1 ELSE NULL END) AS sost_оn ,
Count(CASE WHEN sost=3 THEN 1 ELSE NULL END) AS sost_оnoff , SUM( summa ) as summa, naprav_id
FROM `vtk_main`
WHERE subsid = $year
GROUP BY naprav_id
";
$r = mysql_query($q);
$r4 = mysql_query($q4);
$num_rows1 = mysql_num_rows($r);
while ($row = mysql_fetch_assoc($r))
{
$q2 = "SELECT * FROM napravlenie WHERE id = '". $row["naprav_id"] . "'";
$r2 = mysql_query($q2);
$row2 = mysql_fetch_assoc($r2);
$i++;
?>
=$i?> |
">=$row2["name"]?> |
=$row["kolvo"]?> |
=$row["summa"]?> |
=$row["sost_оn"]?> |
=$row["sost_off"]?> |
=$row["sost_оnoff"]?> |
$q3 = "SELECT * FROM cod_pokazatel";
$r3 = mysql_query($q3);
while ($row3 = mysql_fetch_assoc($r3))
{
?>
$q4 = "SELECT *
FROM `rez_vtk` AS R
LEFT JOIN vtk_main AS M ON M.contract_number = R.dogovor_number
WHERE M.naprav_id = $row[naprav_id]
AND cod_pokaz_id = ".$row3[code]."
AND R.subsid = $year
";
$r4 = mysql_query($q4);
$num_rows = mysql_num_rows($r4);
?>
=$num_rows?> |
}
?>
}
?>