pns_name_table_ref_map["show_string_kg"]["id"]."' AND status='active' AND gl_id='".$CFG->gls_digramma_map[$CFG->gl]["id"]."' AND table_ref_id=a.id LIMIT 1) AS show_string ";
$c["order"] = array(array("field"=>"seira","type"=>"ASC"),array("field"=>"id","type"=>"ASC"));
$kgs_adress = get_etetradio_kgs($c,false);
$katigories = array();
//$CFG->ftexts("idx_radiostations")->just_draw(true) = Radiostathmoi
$katigories["attikis"] = array("id"=>204,"cildren"=>array_merge(get_kg_descendants($kgs_adress["data"],"204"),array("204")),"num_of_rs"=>0,"titlos"=>"Αττικής");
$katigories["salonikis"] = array("id"=>205,"cildren"=>array_merge(get_kg_descendants($kgs_adress["data"],"205"),array("205")),"num_of_rs"=>0,"titlos"=>"Θεσσαλονίκης");
$katigories["rest"] = array("id"=>196,"cildren"=>array_merge(array_diff(get_kg_descendants($kgs_adress["data"],"196"),$katigories["attikis"]["cildren"],$katigories["salonikis"]["cildren"]),array("196")),"num_of_rs"=>0,"titlos"=>"υπόλοιπης Ελλάδος");
$katigories["webradio"] = array("id"=>0,"cildren"=>array("0"),"num_of_rs"=>0,"titlos"=>$CFG->ftexts("idx_radiostations_webradios")->just_draw(true));
$meros = (isset($_REQUEST["therest"]) and isset($katigories[$_REQUEST["therest"]]))?$_REQUEST["therest"]:"attikis"; //default is Attiki
$query = "SELECT count(*) AS num, a.perioxi_kg_id FROM etetradio.rs AS a, pr_int AS p2, ar AS a1, pr AS p3 , pr_int AS p4 WHERE p2.value=a.id AND p2.pn_id='44' AND p2.table_ref_id=a1.id AND p2.status='active' AND a1.status='active' AND TRIM(p3.value)!='' AND p3.pn_id='1' AND p3.table_ref_id=a1.id AND p3.status='active' AND p3.gl_id=1 AND p4.value IN (231) AND p4.pn_id='4' AND p4.table_ref_id=a1.id AND p4.status='active' AND a.status IN ('active') GROUP BY a.perioxi_kg_id";
if($result=execute_query($query,__FILE__." ".__LINE__.":")){
foreach($result AS $value){
foreach($katigories AS $key=>$tmp){
if(in_array($value["perioxi_kg_id"],$tmp["cildren"])){
$katigories[$key]["num_of_rs"] += $value["num"];
}
}
}
}
$creterea = array();//radiostations
$creterea["statuses"] = "'active'";
$creterea["from"] .= ", pr_int AS p2, ar AS a1 ";
$creterea["where"] .= (($creterea["where"]!="")?" AND":"")." p2.value=a.id AND p2.pn_id='".$CFG->pns_name_table_ref_map["rs_id_ar"]["id"]."' AND p2.table_ref_id=a1.id AND p2.status='active' AND a1.status='active'";
$creterea["from"] .= ", pr AS p3 ";
$creterea["where"] .= (($creterea["where"]!="")?" AND":"")." TRIM(p3.value)!='' AND p3.pn_id='".$CFG->pns_name_table_ref_map["periexomeno_ar"]["id"]."' AND p3.table_ref_id=a1.id AND p3.status='active' AND p3.gl_id=".$CFG->gls_digramma_map[$CFG->gl]["id"];
$creterea["from"] .= ", pr_int AS p4 ";
$tmp = get_kg_descendants($kgs["data"],231); //programm
$tmp[] = 231;
$creterea["where"] .= (($creterea["where"]!="")?" AND":"")." p4.value IN (".join(",",$tmp).") AND p4.pn_id='".$CFG->pns_name_table_ref_map["kg_id_ar"]["id"]."' AND p4.table_ref_id=a1.id AND p4.status='active' ";
$creterea["where"] .= (($creterea["where"]!="")?" AND":"")." a.perioxi_kg_id IN (".join(",",$katigories[$meros]["cildren"]).") ";
$creterea["order"] = array("field"=>"syxnotita","type"=>"ASC");
//$creterea["limit1"] = 0;
//$creterea["limit2"] = 1;
$radiostations = get_radiostations($creterea,false);
$radiostations = $radiostations["data"];
$tmp_toret = "";
$tmp_toret .= "
".toupper((($meros!="webradio")?$CFG->ftexts("idx_radiostations")->just_draw(true)." ":"").$katigories[$meros]["titlos"])."
";
$tmp = array();
foreach ($katigories AS $key=>$value){
if($key!=$meros and $value["num_of_rs"]>0){
$tmp[] = "
".$value["titlos"]."";
}
}
$tmp_toret .= "
";
if(count($tmp)>0){
$tmp_toret .= "
Εμφάνιση ραδιοσταθμών: ".implode(",",$tmp)."
";
$tmp_toret .= "
";
}
if(is_array($radiostations) and count($radiostations)>0){
$tmp_toret .= "
";
$cl = "";
foreach($radiostations AS $value){
$myrs = new myrs_index();
$myrs->loaded = true;
$myrs->load_from_array($value);
$myrs->load_pr();
$url =get_link($myrs->get_id(),$CFG->gl,$myrs->get_titlos(),"rsp");
$title = strtr($CFG->ftexts("goto_{rs_title}_programm")->just_draw(),array("{rs_title}"=>strtr($myrs->get_titlos(),array("'"=>" "))));
$cl = ($cl=="bg_grey")?"bg_lightgrey":"bg_grey";
$tmp_toret .= "";
$tmp_toret .= " | ";
if(trim($myrs->get_logo_ei_id())!=""){
$tmp_toret .= " get_logo_ei_id()."_61_46^.jpg');background-repeat: norepeat;background-position: center; width: 61px; height: 46px;max-width: 61px; max-height: 46px;"> ";
}
$tmp_toret .= " | ";
$tmp_toret .= " " "))."' onclick="open('".$url."','_self','')">".$myrs->get_titlos()." | ";
$tmp_toret .= "
";
}
$tmp_toret .= "
";
}
?>
