$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;
}
?>
Главная >
# |
Субсидия |
Кол-во договоров |
Сумма |
Кол-во исполненых договоров |
Кол-во не исполненых договоров |
Кол-во договоров исполненых частично |
$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 = "";
}
?>
$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 , subsid, SUM( summa ) as summa
FROM `vtk_main`
GROUP BY subsid";
$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?> |
">=$row["subsid"]?> |
=$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` WHERE subsid = $row[subsid]
AND cod_pokaz_id = ".$row3[code];
$r4 = mysql_query($q4);
$num_rows = mysql_num_rows($r4);
?>
=$num_rows?> |
}
?>
}
?>