informaciniai-pranesimai-rss.htm

title = "Informaciniai pranešimai RSS"
url = "/informaciniai-pranesimai-rss"
is_hidden = 0
contentType = "rss"
==
<?php
function onStart()
{
    $filter=array();
    $filterVals=array();
    
    if(isset($_GET['filter']) && is_array($_GET['filter']))
        foreach($_GET['filter'] as $k=>$f){
            if(!empty($f))
            switch($k){
                case 'address':
                    /*$filterVals[$k]='%'.$f.'%';
                    $filter[]=" (address LIKE :".$k." OR address2 LIKE :".$k.") ";
                    break;*/
                case 'receiver':
                case 'planned_work':
                case 'county':
                    $this[$k]=$f;
                    $filterVals[$k]='%'.$f.'%';
                    $filter[]=$k." LIKE :".$k;
                    break;
                default:
                    break;
            }
        }
    
    
    if(isset($_GET['county'])){
        $filterVals['county']=intval($_GET['county']);
        $this['notifications'] = Db::select('SELECT n.*, c.title AS county FROM notification n LEFT JOIN county c ON n.county=c.id
        WHERE n.county=:county 
        AND ('.((count($filter)>0)?implode(" AND ", $filter):'1=1').')
        ORDER BY date DESC LIMIT 50', $filterVals);
        $county=Db::select('SELECT * FROM county c WHERE c.id=:county', ['county' => intval($_GET['county'])]);
        $this['county'] = $county[0];
    }
    else{
        $this['all']=true;
        $this['notifications'] = Db::select('SELECT n.*, c.title AS county FROM notification n LEFT JOIN county c ON n.county=c.id
        WHERE ('.((count($filter)>0)?implode(" AND ", $filter):'1=1').')
        ORDER BY date DESC LIMIT 50');
    }
    echo '<?xml version="1.0" encoding="utf-8"?>';
}
?>
==
{{ xml }}
<rss version="2.0">
  <channel>
              
    {% if all %}
        <title>Informaciniai pranešimai</title>
    {% else %}
        <title>{{ county.title }} - Informaciniai pranešimai</title>
    {% endif %}
    <description>Informacija apie įvairius dalykus vykstančius mieste.</description>
    
    {% if all %}
    <link>http://atviras.vilnius.lt/informaciniai-pranesimai-rss</link>
    {% else %}
    <link>http://atviras.vilnius.lt/informaciniai-pranesimai-rss?county={{ county.id }}</link>
    {% endif %}
    
    <category domain="atviras.vilnius.lt">Miestiečių informavimas</category>
    
    <language>lt-lt</language>
    <lastBuildDate>{{ lastUpdate | date("D, d M Y h:i:s O") }}</lastBuildDate>
    <managingEditor>povilas.poderskis@vilnius.lt</managingEditor>
    <pubDate>Sat, 22 Oct 2017 13:38:55 +0300</pubDate>
    <webMaster>atviras@vilnius.lt</webMaster>
    <generator>Atviras Vilnius</generator>
    <image>
      <url>http://atviras.vilnius.lt/themes/responsiv-flat/assets/images/logo.png</url>
      <title>Atviras Vilnius</title>
      <link>http://atviras.vilnius.lt</link>
      <description>Atviras Vilnius</description>
    </image>
    
    {% for n in notifications %}
    <item>
      <title>{{ n.county }}, {{ n.address }}, {{ n.address2 }}</title>
      <description>{{ n.content }} {{ n.planned_work|raw }}</description>
      <link>http://atviras.vilnius.lt/pranesimas/{{ n.id }}</link>
      <category domain="atviras.vilnius.lt">{{ n.type }}</category>
      <comments>http://www.feedforall.com/forum</comments>
      <pubDate>{{ n.date | date("D, d M Y h:i:s O") }}</pubDate>
      <author>{{ n.receiver }}</author>
    </item>
    {% endfor %}
    
  </channel>
</rss>