w Łodzi
Stopka
ul. Lipowa 16, 90-743 Łódź
tel.: 42 633-33-43
fax: 42 633-33-33
e-mail: sekretariat@wios.lodz.pl
Katarzyna Trojak-Danych
tel: 721 810 164
e-mail: rzecznik@wios.lodz.pl
include("/_xcms/classes/class/plot.inc");
$tmpl->set_file('blocks2','news.html');
$tmpl->set_block('blocks2','main_station');
$tmpl->set_block('blocks2','main_station_no_photo');
$tmpl->set_block('blocks2','main_station_idd');
$tmpl->set_block('blocks2','main_station_idd_par');
$tmpl->set_block('blocks2','main_station_apar');
$tmpl->set_block('blocks2','photogallery');
$tmpl->set_block('blocks2','main_station_back');
$tmpl->set_block('blocks2','main_station_list');
$tmpl->set_block('blocks2','legend');
$tmpl->set_block('blocks2','main_station_pm10');
$tmpl->set_block('blocks','modul');
$tmpl->set_block('blocks','table_photo');
$tmpl->set_block('blocks','more');
$tmpl->set_block('blocks','back');
$tmpl->set_block('blocks','scale');
$tmpl->set_block('blocks','table_th');
$tmpl->set_block('blocks','table_td');
$tmpl->set_block('blocks','table_tr');
$tmpl->set_block('blocks','table_table');
$tmpl->set_block('blocks','back');
$tmpl->set_file('blocks3','form.html');
$tmpl->set_block('blocks3','form_comment');
$iff = 0;
$photo_vert = 1;
$table = "photo";
$tmpl->set_var('adds_', "");
$tmpl->set_var("date_label", "Wybierz zakres:");
$tmpl->set_var('photo_w', PHOTO_M_W);
$tmpl->set_var('photo_h', PHOTO_M_H);
$tmpl->set_var('GOOGLE_KEY', GOOGLE_KEY);
$tmpl->set_var('photo_margin','');
if(!isset($_GET["str"]))
$_GET["str"] = null;
if(!isset($_GET["idd"]))
$_GET["idd"] = null;
$tmpl->set_var('photo_margin', "");
$tmpl->set_var('modul_', "");
$tmpl->set_var('main_station_pm10_', "");
if($_GET["str"] == "photo")
{
///////////////////photo
$db2 = new DB__("select photo.id, photo.photo_m, photo.photo_b, photo_lang.text, stations_multi_lang.name, stations_multi.date_ from photo
left join photo_lang on photo_lang.id_photo=photo.id
left join stations_multi on stations_multi.id='".$_GET["idd"]."'
left join stations_multi_lang on stations_multi_lang.id_station=stations_multi.id and stations_multi_lang.id_lang='".$_SESSION["id_language"]."'
where photo.idd='".$_GET['idd']."' and photo.id_template=
(select id_template from template_menu where template_menu.id_menu='".$_GET["id"]."')
and photo.active='1' and stations_multi_lang.name != '' and stations_multi.active='1' and photo.photo_m != ''
group by photo.id
order by photo.ord");
if($db2->nf())
{
$site_name_idd = ", ".$db2->f('name');
while($db2->next_record())
{
$site_name_idd = ", ".$db2->f('name');
$tmpl->set_var('n_href', File::make_mode_rew($db2->f('name'), $_GET["id"], $_GET["idd"]));
$tmpl->set_var('n_date', File::date_from_to($db2->f('date_')));
$tmpl->set_var('n_name', $db2->f('name'));
if(!$db2->f('photo_b'))
{
$tmpl->set_var('n_photo', PATH_IMG.$db2->f('photo_m'));
$tmpl->set_var('n_onclick', "");
$tmpl->set_var('n_onmouseover', "");
}
else
{
$img_size = getImageSize(PATH_IMG.$db2->f('photo_b'));
$img_h = $img_size[1];
$tmpl->set_var('n_photo', PATH_IMG.$db2->f('photo_m'));
$tmpl->set_var('n_onclick', "javascript:show_photo('../pl/ajax_photo.php', 'path=".PATH_IMG."&photo=".$db2->f('photo_b')."&id=".$db2->f('id')."&table=photo', 'war_foto', event, '".$img_size[0]."', '".$img_h."','".PATH_IMG.$db2->f('photo_b')."');void(0);");
$tmpl->set_var('n_onmouseover',"this.style.cursor='pointer';");
}
$tmpl->parse('photo_', 'table_photo2', true);
}
$tmpl->parse('modul_', 'table_photogallery');
$tmpl->parse('modul_', 'back', true);
}
else
$tmpl->set_var('modul_', "");
$modul = $tmpl->subst('modul');
}
else if(isset($_GET["idd"]))
{
$db2 = new DB__("select stations_multi.*, stations_multi_lang.* from stations_multi
left join stations_multi_lang on stations_multi_lang.id_station=stations_multi.id and stations_multi_lang.id_lang='".$_SESSION["id_language"]."'
where stations_multi_lang.name != '' and stations_multi.active='1' and stations_multi.id='".$_GET["idd"]."'");
if($db2->next_record())
{
$site_name_idd = $db2->f('name')." - ";
$tmpl->set_var('n_href2', "index.php?id=".$_GET["id"]."&idd=".$db2->f('id')."&str=photo");
$tmpl->set_var('n_href', File::make_mode_rew("Stacje", $_GET["id"]));
$tmpl->set_var('n_date', File::date_from_to($db2->f('date_')));
$tmpl->set_var('n_name', $db2->f('name'));
$tmpl->set_var('n_subtext', $db2->f('subtext'));
$tmpl->set_var('n_text', $db2->f('text'));
//aparatura
$db3 = new DB__("select aparatura.*, aparatura_temp.id_station from aparatura, aparatura_temp
WHERE aparatura_temp.id_aparatura=aparatura.id and aparatura_temp.id_station='".$_GET["idd"]."'
order by aparatura.name");
if($db3->nf())
{
$next = 0;
while($db3->next_record())
{
$tmpl->set_var('ap_name', $db3->f('name'));
$tmpl->set_var('ap_year', $db3->f('year_'));
$tmpl->set_var('ap_text', $db3->f('text'));
$tmpl->parse('main_station_apar_', 'main_station_apar', true);
}
}
if($db2->f('code'))
$tmpl->set_var('s_code', $db2->f('code'));
else
$tmpl->set_var('s_code', "");
if($db2->f('code_m'))
$tmpl->set_var('s_code_m', $db2->f('code_m'));
else
$tmpl->set_var('s_code_m', "");
if($db2->f('commune'))
$tmpl->set_var('s_commune', $db2->f('commune'));
else
$tmpl->set_var('s_commune', "");
if($db2->f('city'))
$tmpl->set_var('s_city', $db2->f('city'));
else
$tmpl->set_var('s_city', "");
if($db2->f('address'))
$tmpl->set_var('s_address', $db2->f('address'));
else
$tmpl->set_var('s_address', "");
if($db2->f('zone'))
$tmpl->set_var('s_zone', $db2->f('zone'));
else
$tmpl->set_var('s_zone', "");
if($db2->f('code_s'))
$tmpl->set_var('s_code_s', $db2->f('code_s'));
else
$tmpl->set_var('s_code_s', "");
if($_GET["id"] == 211)
{
$tmpl->set_var('s_time_us', "1-godzinny");
$tmpl->set_var('s_type_pom', "automatyczny");
}
else
{
$tmpl->set_var('s_time_us', "24-godzinny");
$tmpl->set_var('s_type_pom', "manualny");
}
if($db2->f('x_s'))
$tmpl->set_var('s_x_s', $db2->f('x_s'));
else
$tmpl->set_var('s_x_s', "");
if($db2->f('y_s'))
$tmpl->set_var('s_y_s', $db2->f('y_s'));
else
$tmpl->set_var('s_y_s', "");
if($db2->f('npm'))
$tmpl->set_var('s_npm', $db2->f('npm'));
else
$tmpl->set_var('s_npm', "");
if($db2->f('npm'))
$tmpl->set_var('s_npm', $db2->f('npm'));
else
$tmpl->set_var('s_npm', "");
if($db2->f('date_u'))
$tmpl->set_var('s_date_u', $db2->f('date_u'));
else
$tmpl->set_var('s_date_u', "");
if($db2->f('kind_s'))
$tmpl->set_var('s_kind_s', $db2->f('kind_s'));
else
$tmpl->set_var('s_kind_s', "");
if($db2->f('type_s'))
$tmpl->set_var('s_type_s', $db2->f('type_s'));
else
$tmpl->set_var('s_type_s', "");
if($db2->f('type_o'))
$tmpl->set_var('s_type_o', $db2->f('type_o'));
else
$tmpl->set_var('s_type_o', "");
if($db2->f('type_u'))
$tmpl->set_var('s_type_u', $db2->f('type_u'));
else
$tmpl->set_var('s_type_u', "");
if($db2->f('sources'))
$tmpl->set_var('s_sources', $db2->f('sources'));
else
$tmpl->set_var('s_sources', "");
if($db2->f('jpoat'))
$tmpl->set_var('s_jpoat', $db2->f('jpoat'));
else
$tmpl->set_var('s_jpoat', "");
if($db2->f('area'))
$tmpl->set_var('s_area', $db2->f('area'));
else
$tmpl->set_var('s_area', "");
if($db2->f('amount_p'))
$tmpl->set_var('s_amount_p', $db2->f('amount_p'));
else
$tmpl->set_var('s_amount_p', "");
if($db2->f('env_n'))
$tmpl->set_var('s_env_n', $db2->f('env_n'));
else
$tmpl->set_var('s_env_n', "");
if($db2->f('env_e'))
$tmpl->set_var('s_env_e', $db2->f('env_e'));
else
$tmpl->set_var('s_env_e', "");
if($db2->f('env_s'))
$tmpl->set_var('s_env_s', $db2->f('env_s'));
else
$tmpl->set_var('s_env_s', "");
if($db2->f('env_w'))
$tmpl->set_var('s_env_w', $db2->f('env_w'));
else
$tmpl->set_var('s_env_w', "");
//////////fotki///////////////
$photo = "";
$db3 = new DB__("select photo.* from photo
where photo.idd='".$db2->f('id')."' and photo.id_template=(select id_template from template_menu where template_menu.id_menu='".$_GET["id"]."') and photo.active='1' and photo.photo_m != ''
order by photo.ord");
if($db3->nf())
{
$next = 0;
while($db3->next_record())
{
$next++;
$photo = $db3->f('photo_m');
if(!$db3->f('photo_b'))
{
$tmpl->set_var('n_photo', PATH_IMG.$db3->f('photo_m'));
$tmpl->set_var('n_onclick', "");
$tmpl->set_var('n_onmouseover', "");
}
else
{
$img_size = getImageSize(PATH_IMG.$db3->f('photo_b'));
$img_h = $img_size[1];
$tmpl->set_var('n_photo', PATH_IMG.$db3->f('photo_m'));
$tmpl->set_var('n_onclick', "javascript:show_photo('../pl/ajax_photo.php', 'path=".PATH_IMG."&photo=".$db3->f('photo_b')."&id=".$db3->f('id')."&table=photo', 'war_foto', event, '".$img_size[0]."', '".$img_h."','".PATH_IMG.$db3->f('photo_b')."');void(0);");
$tmpl->set_var('n_onmouseover',"this.style.cursor='pointer';");
}
$tmpl->parse('photo_', 'table_photo', true);
if($photo_vert < $next)
{
$tmpl->parse('photo_', 'table_clear', true);
$tmpl->parse('photo_', 'photogallery', true);
break;
}
}
}
//mapa
//google
$g = new Google_map;
$g->g_width = 688;
$g->g_height = 400;
$max_x = 0;
$min_x = 1000;
$max_y = 0;
$min_y = 1000;
$show = 0;//ukryj obiekty
$max_x = $db2->f('x');
$min_x = $db2->f('x');
$max_y = $db2->f('y');
$min_y = $db2->f('y');
//wersja z przeladowaniem
$link = "f('name'), $_GET["id"], $db2->f('id'))."';\">[więcej ››]";
$g->google_add_point($db2->f('x'), $db2->f('y'), $db2->f('id'), $db2->f('name'), $g->google_make_description($db2->f('address'), "", "", "", "", "", "", "", $link), $photo, "", 1, $show, "");
//google
$tmpl->set_var('min_lat', $min_y);
$tmpl->set_var('max_lat', $max_y);
$tmpl->set_var('min_long', $min_x);
$tmpl->set_var('max_long', $max_x);
$tmpl->set_var('s_map_', $g->create_google_map());
//parametry
$db3 = new DB__("select stations_multi_params.* from stations_multi_params, stations_multi_temp
where stations_multi_temp.id_param=stations_multi_params.id and stations_multi_temp.id_station='".$_GET["idd"]."'
order by stations_multi_temp.id_station desc, stations_multi_params.id");
if($db3->nf())
{
while($db3->next_record())
{
$tmpl->set_var('par_href_d', "index.php?id=213&id_station[]=".$db2->f('id')."&type=1h&id_param=".$db3->f('id'));
$tmpl->set_var('par_href_d2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."1h.csv");
$tmpl->set_var('par_href_t', "index.php?id=213&id_station[]=".$db2->f('id')."&type=week&id_param=".$db3->f('id'));
$tmpl->set_var('par_href_t2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."_tydz_1h.csv");
$tmpl->set_var('par_href_m', "index.php?id=213&id_station[]=".$db2->f('id')."&type=month&id_param=".$db3->f('id'));
$tmpl->set_var('par_href_m2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."_30dni_1h.csv");
$tmpl->set_var('par_href_y', "index.php?id=213&id_station[]=".$db2->f('id')."&type=all&id_param=".$db3->f('id'));
$tmpl->set_var('par_href_y2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."_doTeraz_1h.csv");
$tmpl->set_var('par_name', $db3->f('name'));
$tmpl->parse('main_station_idd_par_', 'main_station_idd_par', true);
}
}
//pobierz plik
$tmpl->set_var('par_href_d2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."1h.csv");
$tmpl->set_var('par_href_t2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."_tydz_1h.csv");
$tmpl->set_var('par_href_m2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."_30dni_1h.csv");
$tmpl->set_var('par_href_y2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."_doTeraz_1h.csv");
$pl = new Plot($tmpl, "1h", $_GET["idd"]);
$tmpl->set_var('main_station_idd_table_1h_', $pl->draw_table());
$pl = new Plot($tmpl, "week", $_GET["idd"]);
$tmpl->set_var('main_station_idd_table_week_', $pl->draw_table());
//pm10
if($db2->f('export_pm10') == 1)
{
$tmpl->set_var('par_pm_href_t', "index.php?id=261&id_station[]=".$db2->f('id')."&type=pm_week&id_param=10");
$tmpl->set_var('par_pm_href_t2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."_PM10_tydz.csv");
$tmpl->set_var('par_pm_href_m', "index.php?id=261&id_station[]=".$db2->f('id')."&type=pm_month&id_param=10");
$tmpl->set_var('par_pm_href_m2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."_PM10_30dni.csv");
$tmpl->set_var('par_pm_href_y', "index.php?id=261&id_station[]=".$db2->f('id')."&type=pm_all&id_param=10");
$tmpl->set_var('par_pm_href_y2', "/export_cs/".$db2->f('export_cs')."/".$db2->f('export_cs')."_PM10_doTeraz.csv");
$pl = new Plot($tmpl, "pm_week", $_GET["idd"]);
$tmpl->set_var('pm_main_station_idd_table_week_', $pl->draw_table());
$pl = new Plot($tmpl, "pm_month", $_GET["idd"]);
$tmpl->set_var('pm_main_station_idd_table_month_', $pl->draw_table());
$tmpl->parse('main_station_pm10_', 'main_station_pm10', true);
}
$tmpl->parse('modul_', 'main_station_idd', true);
//wybór wyniku dla stacji
$dbx = new DB__("select stations_multi.*, stations_multi_lang.* from stations_multi
left join stations_multi_lang on stations_multi_lang.id_station=stations_multi.id and stations_multi_lang.id_lang='".$_SESSION["id_language"]."'
where stations_multi.id_menu='".$_GET["id"]."' and stations_multi.id!='".$_GET["idd"]."' and stations_multi_lang.name != '' and stations_multi.active='1'
group by stations_multi.id
order by stations_multi.date_ desc, stations_multi.id desc");
if($dbx->nf())
{
while($dbx->next_record())
{
$tmpl->set_var("option_selected", "");
$tmpl->set_var("option_value", $dbx->f('id'));
$tmpl->set_var("option_", $dbx->f('name'));
$tmpl->parse("id_station_", 'table_option' ,true);
}
$tmpl->parse('modul_', 'main_station_list', true);
}
$tmpl->parse('modul_', 'main_station_back', true);
}
$modul = $tmpl->subst('modul');
}
else
{
//patrzymy jaki okres (IV - IX) i ktore parametry bierzemy pod uwagę
$now_month = date("m-d");
$arr_month = array();
if($now_month >= O3_FROM && $now_month <= O3_TO)
$arr_month[] = "6";
else
{
$arr_month[] = "10";
$arr_month[] = "11";
}
$db2 = new DB__("select stations_multi.*, stations_multi_lang.* from stations_multi
left join stations_multi_lang on stations_multi_lang.id_station=stations_multi.id and stations_multi_lang.id_lang='".$_SESSION["id_language"]."'
where stations_multi.id_menu='".$_GET["id"]."' and stations_multi_lang.name != '' and stations_multi.active='1'
group by stations_multi.id
order by stations_multi.date_ desc, stations_multi.id desc");
if($db2->nf())
{
//google
$g = new Google_map;
$g->g_width = 688;
$g->g_height = 400;
$max_x = 0;
$min_x = 1000;
$max_y = 0;
$min_y = 1000;
$show = 0;//ukryj obiekty
$arr_ind = array();
while($db2->next_record())
{
//google
$show = 1;
if($db2->f('x') > $max_x) $max_x = $db2->f('x');
if($db2->f('x') < $min_x) $min_x = $db2->f('x');
if($db2->f('y') > $max_y) $max_y = $db2->f('y');
if($db2->f('y') < $min_y) $min_y = $db2->f('y');
$iff++;
$tmpl->set_var('main_news_div_', "");
$tmpl->set_var('photo_', "");
$tmpl->set_var('n_href', File::make_mode_rew($db2->f('name'), $_GET["id"], $db2->f('id')));
$tmpl->set_var('n_date', File::date_from_to($db2->f('date_u')));
$tmpl->set_var('n_title', $db2->f('name'));
$tmpl->set_var('n_address', $db2->f('address'));
$tmpl->set_var('n_wsp', "dł.: ".$db2->f('x_s').", szer.: ".$db2->f('y_s'));
$tmpl->set_var('n_id', $db2->f('id'));
//////////fotki///////////////
$photo = "";
$db3 = new DB__("select photo.* from photo
where photo.idd='".$db2->f('id')."' and photo.id_template=(select id_template from template_menu where template_menu.id_menu='".$_GET["id"]."') and photo.active='1' and photo.photo_m != '' and photo.ord=1");
if($db3->next_record())
{
$photo = $db3->f('photo_m');
if(!$db3->f('photo_b'))
{
$tmpl->set_var('n_photo', PATH_IMG.$db3->f('photo_m'));
$tmpl->set_var('n_onclick', "");
$tmpl->set_var('n_onmouseover', "");
}
else
{
$img_size = getImageSize(PATH_IMG.$db3->f('photo_b'));
$img_h = $img_size[1];
$tmpl->set_var('n_photo', PATH_IMG.$db3->f('photo_m'));
$tmpl->set_var('n_onclick', "javascript:show_photo('../pl/ajax_photo.php', 'path=".PATH_IMG."&photo=".$db3->f('photo_b')."&id=".$db3->f('id')."&table=photo', 'war_foto', event, '".$img_size[0]."', '".$img_h."','".PATH_IMG.$db3->f('photo_b')."');void(0);");
$tmpl->set_var('n_onmouseover',"this.style.cursor='pointer';");
}
$tmpl->parse('photo_', 'photo2', true);
$tmpl->parse('modul_temp', 'main_station', true);
}
else
$tmpl->parse('modul_temp', 'main_station_no_photo', true);
//google
//wersja z przeladowaniem
$link = "f('name'), $_GET["id"], $db2->f('id'))."';\" class=\"col_text\">[informacje o stacji ››]";
//indeks - wyliczanie wartosci param.
//$arr_ind[id_stacji][param][name/stan (1-6)/wartosc]
//parametry
$db4 = new DB__("select stations_multi_params.* from stations_multi_params, stations_multi_temp
where stations_multi_temp.id_param=stations_multi_params.id and stations_multi_temp.id_station='".$db2->f('id')."' and stations_multi_params.ind='1'
order by stations_multi_temp.id_station desc, stations_multi_params.id");
if($db4->nf())
{
$max_state_all = 0;
$max_state = 0;
$info_ind = "Zanieczyszczenia:
";
while($db4->next_record())
{
$pl = new Plot($tmpl, "1h", array($db2->f('id')), $db4->f('id'));
$val = $pl->do_ind_arr();
$val = floatval(trim($val));
$arr_ind[$db2->f('id')][$db4->f('id')]["name"] = $db4->f('name');
$arr_ind[$db2->f('id')][$db4->f('id')]["val"] = $val;
//if($db2->f('id') == 6)
// echo $val."
";
//sprawdzamy wartosc z tabela
if($val == "")
$state = "0";
else if($val >= 0 && $val <= $db4->f('ind1'))
$state = "1";
else if($val > $db4->f('ind1') && $val <= $db4->f('ind2'))
$state = "2";
else if($val > $db4->f('ind2') && $val <= $db4->f('ind3'))
$state = "3";
else if($val > $db4->f('ind3') && $val <= $db4->f('ind4'))
$state = "4";
else if($val > $db4->f('ind4') && $val <= $db4->f('ind5'))
$state = "5";
else if($val > $db4->f('ind5'))
$state = "6";
if($val != "")
$info_ind .= "".$db4->f('name').": ".$val."µg/m3
";
else
$info_ind .= "".$db4->f('name').": "."brak danych
";
$arr_ind[$db2->f('id')][$db4->f('id')]["state"] = $state;
if(in_array($db4->f('id'), $arr_month))
$max_state = max($max_state, $state);
$max_state_all = max($max_state_all, $state);
}
$arr_ind[$db2->f('id')]["ind"] = $max_state;
}
//echo $db2->f('name').$max_state."
";
if($max_state_all == 0)//awaria stacji
$max_state = -1;
$g->google_add_point($db2->f('x'), $db2->f('y'), $db2->f('id'), $db2->f('name'), $g->google_make_description($db2->f('address'), "Polski indeks jakości powietrza: ".$arr_index[$max_state]."
".$info_ind, "", "", "", "", "", "", $link), $photo, "", 1, $show, "ind$max_state.png");
}
//echo "
".print_r($arr_ind[6]).""; //mapa $tmpl->set_var('min_lat', $min_y); $tmpl->set_var('max_lat', $max_y); $tmpl->set_var('min_long', $min_x); $tmpl->set_var('max_long', $max_x); $tmpl->set_var('modul_gm', $g->create_google_map()); $tmpl->parse('modul_', 'modul_gm', true); $tmpl->parse('modul_', 'legend', true); $tmpl->parse('modul_', 'modul_temp', true); } } $modul = $tmpl->subst('modul'); ?>