<commit_before><?php

class IndexController extends RISBaseController
{
    public static $BA_DOKUMENTE_TAGE_PRO_SEITE = 14;

    /**
     * @param int $width
     * @param int $zoom
     * @param int $x
     * @param int $y
     */
    public function actionTileCache($width, $zoom, $x, $y)
    {

        if ($width == 256) {
            $boundaries = [
                3  => [2, 2, 6, 3],
                4  => [6, 4, 11, 6],
                5  => [14, 10, 19, 11],
                6  => [31, 21, 36, 22],
                7  => [66, 43, 70, 45],
                8  => [134, 88, 138, 89],
                9  => [270, 176, 274, 178],
                10 => [542, 354, 547, 356],
                11 => [1086, 708, 1091, 712],
            ];
            if (isset($boundaries[$zoom])) {
                $bound       = $boundaries[$zoom];
                $outofbounds = false;
                if ($x < $bound[0] || $y < $bound[1] || $x > $bound[2] || $y > $bound[3]) $outofbounds = true;

                if ($outofbounds) {
                    Header("Location: /images/HereBeDragons256.png");
                    Yii::app()->end();
                }
            }
        }

        if ($width == 256) {
            $array = ["1", "2", "3"];
            $key   = $array[array_rand($array)] . "-" . Yii::app()->params['skobblerKey'];
            $url   = "http://tiles" . $key . ".skobblermaps.com/TileService/tiles/2.0/00022210100/0/${zoom}/${x}/${y}.png";
        } else {
            $array = ["1", "2", "3"];
            $key   = $array[array_rand($array)] . "-" . Yii::app()->params['skobblerKey'];
            $url   = "http://tiles" . $key . ".skobblermaps.com/TileService/tiles/2.0/00022210100/0/${zoom}/${x}/${y}.png@2x";
        }

        $fp = fopen("/tmp/tiles.log", "a");
        fwrite($fp, $url . "\n");
        fclose($fp);


        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
        curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 10);
        curl_setopt($ch, CURLOPT_USERAGENT, RISTools::STD_USER_AGENT);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
        $string = curl_exec($ch);
        $status = curl_getinfo($ch, CURLINFO_HTTP_CODE);

        if ($status == 200 && $string != "") {
            if (!file_exists(TILE_CACHE_DIR . "$width")) @mkdir(TILE_CACHE_DIR . "$width", 0775);
            if (!file_exists(TILE_CACHE_DIR . "$width/$zoom")) @mkdir(TILE_CACHE_DIR . "$width/$zoom", 0775);
            if (!file_exists(TILE_CACHE_DIR . "$width/$zoom/$x")) @mkdir(TILE_CACHE_DIR . "$width/$zoom/$x", 0775);
            file_put_contents(TILE_CACHE_DIR . "$width/$zoom/$x/$y.png", $string);
            Header("Content-Type: image/png");
            echo $string;
        } else {
            Header("Content-Type: text/plain");
            echo $status;
            var_dump($ch);
        }
        Yii::app()->end();
    }

    public function actionFeed()
    {
        if (isset($_REQUEST["krit_typ"])) {
            $krits = RISSucheKrits::createFromUrl($_REQUEST);
            $titel = Yii::app()->params['projectTitle'] . ': ' . $krits->getBeschreibungDerSuche();

            $solr   = RISSolrHelper::getSolrClient();
            $select = $solr->createSelect();

            $krits->addKritsToSolr($select);

            $select->setRows(100);
            $select->addSort('sort_datum', $select::SORT_DESC);

            /** @var Solarium\QueryType\Select\Query\Component\Highlighting\Highlighting $hl */
            $hl = $select->getHighlighting();
            $hl->setFields('text, text_ocr, antrag_betreff');
            $hl->setSimplePrefix('<b>');
            $hl->setSimplePostfix('</b>');

            $ergebnisse = $solr->execute($select);

            $data = RISSolrHelper::ergebnisse2FeedData($ergebnisse);
        } else {
            $data = [];
            /** @var array|RISAenderung[] $aenderungen */
            $aenderungen = RISAenderung::model()->findAll(["order" => "id DESC", "limit" => 100]);
            foreach ($aenderungen as $aenderung) $data[] = $aenderung->toFeedData();
            $titel = Yii::app()->params['projectTitle'] . ' Änderungen';
        }

        $this->render("feed", [
            "feed_title"       => $titel,
            "feed_description" => $titel,
            "data"             => $data,
        ]);
    }

    /**
     * @param RISSucheKrits $curr_krits
     * @param string $code
     * @return array
     */
    protected function sucheBenachrichtigungenAnmelden($curr_krits, $code)
    {
        $user = Yii::app()->getUser();

        $correct_person      = null;
        $wird_benachrichtigt = false;

        $do_benachrichtigung_add = AntiXSS::isTokenSet("benachrichtigung_add"); // Token ändert sich möglicherweise beim Login
        $do_benachrichtigung_del = AntiXSS::isTokenSet("benachrichtigung_del");

        $this->performLoginActions();

        if (!$user->isGuest) {
            /** @var BenutzerIn $ich */
            $ich = BenutzerIn::model()->findByAttributes(["email" => Yii::app()->user->id]);

            if ($do_benachrichtigung_add) {
                $ich->addBenachrichtigung($curr_krits);
                $this->msg_ok .= 'Die Benachrichtigung wurde hinzugefügt.';
            }
            if ($do_benachrichtigung_del) {
                $deleted = $ich->delBenachrichtigung($curr_krits);
                if ($deleted) {
                    $this->msg_ok = "Die Benachrichtigung wurde entfernt.";
                } else {
                    $this->msg_err = "Fehler: Die Benachrichtigung konnte nicht entfernt werden.";
                }
            }

            $wird_benachrichtigt = $ich->wirdBenachrichtigt($curr_krits);
        }


        if ($user->isGuest) {
            $ich              = null;
            $eingeloggt       = false;
            $email_angegeben  = false;
            $email_bestaetigt = false;
        } else {
            $eingeloggt = true;
            /** @var BenutzerIn $ich */
            if (!$ich) $ich = BenutzerIn::model()->findByAttributes(["email" => Yii::app()->user->id]);
            if ($ich->email == "") {
                $email_angegeben  = false;
                $email_bestaetigt = false;
            } elseif ($ich->email_bestaetigt) {
                $email_angegeben  = true;
                $email_bestaetigt = true;
            } else {
                $email_angegeben  = true;
                $email_bestaetigt = false;
            }
        }

        return [
            "eingeloggt"          => $eingeloggt,
            "email_angegeben"     => $email_angegeben,
            "email_bestaetigt"    => $email_bestaetigt,
            "wird_benachrichtigt" => $wird_benachrichtigt,
            "ich"                 => $ich,
        ];
    }

    /**
     * @param Dokument[] $dokumente
     * @param null|RISSucheKrits $filter_krits
     * @return array
     */
    protected function dokumente2geodata(&$dokumente, $filter_krits = null)
    {
        $geodata = [];
        foreach ($dokumente as $dokument) {
            if ($dokument->antrag) {
                $link = $dokument->antrag->getLink();
                $name = $dokument->antrag->getName();
            } elseif ($dokument->termin) {
                $link = $dokument->termin->getLink();
                $name = $dokument->termin->getName();
            } else {
                $link = $name = "";
            }
            if (strlen($name) > 150) $name = mb_substr($name, 0, 148) . "...";
            if ($link != "") $link = "<div class='antraglink'>" . CHtml::link($name, $link) . "</div>";
            foreach ($dokument->orte as $ort) if ($ort->ort->to_hide == 0 && ($filter_krits === null || $filter_krits->filterGeo($ort->ort))) {
                $str = $link;
                $str .= "<div class='ort_dokument'>";
                $str .= "<div class='ort'>" . CHtml::encode($ort->ort->ort) . "</div>";
                $str .= "<div class='dokument'>" . CHtml::link($dokument->name, $this->createUrl("index/dokument", ["id" => $dokument->id])) . "</div>";
                $str .= "</div>";
                $geodata[] = [
                    FloatVal($ort->ort->lat),
                    FloatVal($ort->ort->lon),
                    $str
                ];
            }
        }
        return $geodata;
    }

    /**
     * @param RISSucheKrits $krits
     * @param \Solarium\QueryType\Select\Result\Result $ergebnisse
     * @return array
     */
    protected function getJSGeodata($krits, $ergebnisse)
    {
        $geo = $krits->getGeoKrit();
        /** @var RISSolrDocument[] $solr_dokumente */
        $solr_dokumente = $ergebnisse->getDocuments();
        $dokument_ids   = [];
        foreach ($solr_dokumente as $dokument) {
            $x              = explode(":", $dokument->id);
            $dokument_ids[] = IntVal($x[1]);
        }
        $geodata = [];
        if (count($dokument_ids) > 0) {
            $lat        = FloatVal($geo["lat"]);
            $lng        = FloatVal($geo["lng"]);
            $dist_field = "(((acos(sin(($lat*pi()/180)) * sin((lat*pi()/180))+cos(($lat*pi()/180)) * cos((lat*pi()/180)) * cos((($lng- lon)*pi()/180))))*180/pi())*60*1.1515*1.609344) <= " . FloatVal($geo["radius"] / 1000);
            $SQL        = "select a.dokument_id, b.* FROM antraege_orte a JOIN orte_geo b ON a.ort_id = b.id WHERE a.dokument_id IN (" . implode(", ", $dokument_ids) . ") AND b.to_hide = 0 AND $dist_field";
            $result     = Yii::app()->db->createCommand($SQL)->queryAll();
            foreach ($result as $geo) {
                /** @var Dokument $dokument */
                $dokument = Dokument::model()->findByPk($geo["dokument_id"]);

                if ($dokument->antrag) {
                    $link = $dokument->antrag->getLink();
                    $name = $dokument->antrag->getName();
                } elseif ($dokument->termin) {
                    $link = $dokument->termin->getLink();
                    $name = $dokument->termin->getName();
                } else {
                    $link = $name = "";
                }
                if (strlen($name) > 150) $name = mb_substr($name, 0, 148) . "...";
                if ($link != "") $link = "<div class='antraglink'>" . CHtml::link($name, $link) . "</div>";
                $str = $link;
                $str .= "<div class='ort_dokument'>";
                $str .= "<div class='ort'>" . CHtml::encode($geo["ort"]) . "</div>";
                $str .= "<div class='dokument'>" . CHtml::link($dokument->name, $this->createUrl("index/dokument", ["id" => $dokument->id])) . "</div>";
                $str .= "</div>";
                $geodata[] = [
                    FloatVal($geo["lat"]),
                    FloatVal($geo["lon"]),
                    $str
                ];
            }

        }
        return $geodata;
    }


    /**
     * @param Antrag[] $antraege
     * @param int $typ
     * @return array
     */
    protected function antraege2geodata(&$antraege, $typ = 0)
    {
        $geodata          = $geodata_overflow = [];
        $geodata_nach_dok = [];
        foreach ($antraege as $ant) {
            foreach ($ant->dokumente as $dokument) {
                foreach ($dokument->orte as $ort) if ($ort->ort->to_hide == 0) {
                    $name = $ant->getName();
                    if (strlen($name) > 150) $name = mb_substr($name, 0, 148) . "...";
                    $str = "<div class='antraglink'>" . CHtml::link($name, $ant->getLink()) . "</div>";
                    $str .= "<div class='ort_dokument'>";
                    $str .= "<div class='ort'>" . CHtml::encode($ort->ort->ort) . "</div>";
                    $str .= "<div class='dokument'>" . CHtml::link($dokument->getName(), $dokument->getLink()) . "</div>";
                    $str .= "</div>";
                    $str = mb_convert_encoding($str, 'UTF-8', 'UTF-8');

                    if (!isset($geodata_nach_dok[$dokument->id])) $geodata_nach_dok[$dokument->id] = [];
                    $geodata_nach_dok[$dokument->id][] = [
                        FloatVal($ort->ort->lat),
                        FloatVal($ort->ort->lon),
                        $str,
                        $typ
                    ];
                }
            }
        }
        foreach ($geodata_nach_dok as $dok_geo) if (count($dok_geo) >= 10) {
            $geodata_overflow[] = $dok_geo;
        } else {
            foreach ($dok_geo as $d) $geodata[] = $d;
        }

        return [$geodata, $geodata_overflow];
    }

    /**
     * @param float $lat
     * @param float $lng
     */
    public function actionGeo2Address($lat, $lng)
    {
        Header("Content-Type: application/json; charset=UTF-8");
        $naechster_ort = OrtGeo::findClosest($lng, $lat);
        echo json_encode([
            "ort_name" => $naechster_ort->ort,
        ]);
        Yii::app()->end();
    }


    /**
     * @param float $lat
     * @param float $lng
     * @param float $radius
     * @param int $seite
     */
    public function actionAntraegeAjaxGeo($lat, $lng, $radius, $seite = 0)
    {
        $krits = new RISSucheKrits();
        $krits->addKrit('geo', $lng . '-' . $lat . '-' . $radius);

        $solr   = RISSolrHelper::getSolrClient();
        $select = $solr->createSelect();

        $krits->addKritsToSolr($select);

        $select->setStart(30 * $seite);
        $select->setRows(30);
        $select->addSort('sort_datum', $select::SORT_DESC);

        $ergebnisse = $solr->select($select);

        /** @var Antrag[] $antraege */
        $antraege = [];
        /** @var RISSolrDocument[] $solr_dokumente */
        $solr_dokumente = $ergebnisse->getDocuments();
        $dokument_ids   = [];
        foreach ($solr_dokumente as $dokument) {
            $x              = explode(":", $dokument->id);
            $dokument_ids[] = IntVal($x[1]);
        }
        foreach ($dokument_ids as $dok_id) {
            /** @var Dokument $ant */
            $ant = Dokument::model()->with([
                "antrag"           => [],
                "antrag.dokumente" => [
                    "alias"     => "dokumente_2",
                    "condition" => "dokumente_2.id IN (" . implode(", ", $dokument_ids) . ")"
                ]
            ])->findByPk($dok_id);
            if ($ant && $ant->antrag) {
                $antraege[$ant->antrag_id] = $ant->antrag;
            }
        }

        $geodata       = $this->getJSGeodata($krits, $ergebnisse);
        $naechster_ort = OrtGeo::findClosest($lng, $lat);
        ob_start();

        $this->renderPartial('index_antraege_liste', [
            "aeltere_url_ajax"  => $this->createUrl("index/antraegeAjaxGeo", ["lat" => $lat, "lng" => $lng, "radius" => $radius, "seite" => ($seite + 1)]),
            "aeltere_url_std"   => $this->createUrl("index/antraegeStdGeo", ["lat" => $lat, "lng" => $lng, "radius" => $radius, "seite" => ($seite + 1)]),
            "neuere_url_ajax"   => null,
            "neuere_url_std"    => null,
            "antraege"          => $antraege,
            "geo_lng"           => $lng,
            "geo_lat"           => $lat,
            "radius"            => $radius,
            "naechster_ort"     => $naechster_ort,
            "weiter_links_oben" => true,
            "zeige_jahr"        => true,
        ]);

        Header("Content-Type: application/json; charset=UTF-8");
        echo json_encode([
            "datum"         => date("Y-m-d"),
            "html"          => ob_get_clean(),
            "geodata"       => $geodata,
            "krit_str"      => $krits->getJson(),
            "naechster_ort" => $naechster_ort->ort
        ]);
        Yii::app()->end();
    }

    /**
     * Extrahiert die möglichen Filteroptionen in Gruppen mit Titel, URL und Anzahl der Dokumente
     *
     * @param \Solarium\QueryType\Select\Result\Result $ergebnisse
     * @param RISSucheKrits $krits
     * @param array $facet_field_names
     * @return array
     * @throws Exception
     */
    private function extractAvailalbleFacets($ergebnisse, $krits, $facet_field_names) {
        $availalbe_facets = [];
        $used_factes      = [];

        foreach ($facet_field_names as $facet_field_name) {
            // Gewählte Option ausnehmen, um Duplikate zu vermeiden
            $krit_used = $krits->hasKrit($facet_field_name[1]);
            $krits_without_used = $krits;
            $krit_alone = null;

            if ($krit_used) {
                $krits_without_used = new RISSucheKrits();
                foreach ($krits->krits as $i) {
                    if ($i["typ"] != $facet_field_name[1]) {
                        $krits_without_used->krits[] = $i;
                    } else {
                        $krit_alone = $i;
                    }
                }
            }

            $facet_group = [];
            $facet = $ergebnisse->getFacetSet()->getFacet($facet_field_name[0]);

            foreach ($facet as $value => $count) if ($count > 0) {
                if (in_array($value, array("", "?"))) continue;

                $facet_option = [];
                $facet_option['url'] = RISTools::bracketEscape(CHtml::encode($krits_without_used->cloneKrits()->addKrit($facet_field_name[1], $value)->getUrl()));
                $facet_option['count'] = $count;

                if ($facet_field_name[0] == 'antrag_typ') {
                    if (isset(Antrag::$TYPEN_ALLE[$value])) $facet_option['name'] = explode("|", Antrag::$TYPEN_ALLE[$value])[1];
                    else if ($value == "stadtrat_termin") $facet_option['name'] = 'Stadtrats-Termin';
                    else if ($value == "ba_termin") $facet_option['name'] = 'BA-Termin';
                    else $facet_option['name'] = $value;
                } else if ($facet_field_name[0] == 'antrag_wahlperiode') {
                    $facet_option['name'] = $value;
                } else if ($facet_field_name[0] == 'dokument_bas') {
                    $facet_option['name'] = $value . ": " . Bezirksausschuss::model()->findByPk($value)->name;
                } else if ($facet_field_name[0] == 'referat_id') {
                    $facet_option['name'] = Referat::model()->findByPk($value)->name;
                } else {
                    throw new Exception("unknown facet");
                }

                $facet_group[] = $facet_option;
            }

            $to_add = [
                "name" => $facet_field_name[2],
                "typ" => $facet_field_name[1],
                "group" => $facet_group,
                "krits_without_used" => $krits_without_used,
                "krit_alone" => $krit_alone,
            ];


            if ($krit_used) {
                // Ẃir brauchen mindestens 2, weil die erste Möglichkeit die bereits gewählte ist
                if (count($facet_group) >= 2) {
                    $used_factes[] = $to_add;
                }
            } else {
                if (count($facet_group) >= 1) {
                    $availalbe_facets[] = $to_add;
                }
            }
        }

        return [$availalbe_facets, $used_factes];
    }


    /**
     * @param string $code
     */
    public function actionSuche($code = "")
    {
        if (AntiXSS::isTokenSet("search_form")) {
            $krits = new RISSucheKrits();
            if (trim($_REQUEST["volltext"]) != "")  $krits->addKrit('volltext',   $_REQUEST["volltext"]);
            if (trim($_REQUEST["antrag_nr"]) != "") $krits->addKrit('antrag_nr',  $_REQUEST["antrag_nr"]);
            if ($_REQUEST["typ"] != "")             $krits->addKrit('antrag_typ', $_REQUEST["typ"]);
            if ($_REQUEST["referat"] > 0)           $krits->addKrit('referat',    $_REQUEST["referat"]);

            /*
             * @TODO: Setzt voraus: offizielles Datum eines Dokuments ermitteln
            $datum_von = $datum_bis = null;
            if ($_REQUEST["datum_von"] != "") {
                $x = explode(".", $_REQUEST["datum_von"]);
                if (count($x) == 3) $datum_von = $x[2] . "-" . $x[1] . "-" . $x[0] . " 00:00:00";
            }
            if ($_REQUEST["datum_bis"] != "") {
                $x = explode(".", $_REQUEST["datum_bis"]);
                if (count($x) == 3) $datum_bis = $x[2] . "-" . $x[1] . "-" . $x[0] . " 23:59:59";
            }
            if ($datum_von || $datum_bis) $krits->addDatumKrit($datum_von, $datum_bis);
            */

        } else if (isset($_REQUEST["suchbegriff"]) && $_REQUEST["suchbegriff"] != "") {
            $suchbegriff = $_REQUEST["suchbegriff"];
            if ($_SERVER["REQUEST_METHOD"] == 'POST') $this->redirect($this->createUrl("index/suche", ["suchbegriff" => $suchbegriff]));
            $this->suche_pre = $suchbegriff;
            $krits           = new RISSucheKrits();
            $krits->addKrit('volltext', $suchbegriff);
        } else {
            $krits = RISSucheKrits::createFromUrl($_REQUEST);
        }

        if ($krits->getKritsCount() > 0) {
            $benachrichtigungen_optionen = $this->sucheBenachrichtigungenAnmelden($krits, $code);

            $solr = RISSolrHelper::getSolrClient();
            $select = $solr->createSelect();

            $krits->addKritsToSolr($select);

            $select->setRows(50);
            $select->addSort('sort_datum', $select::SORT_DESC);

            // Tag hinzufügen, der den Namen entspricht
            foreach ($select->getFilterQueries() as $filter_query) {
                $filter_query->addTag($filter_query->getKey());
            }

            /** @var Solarium\QueryType\Select\Query\Component\Highlighting\Highlighting $hl */
            $hl = $select->getHighlighting();
            $hl->setFields('text, text_ocr, antrag_betreff');
            $hl->setSimplePrefix('<b>');
            $hl->setSimplePostfix('</b>');

            $facet_field_namess = [
                ['antrag_typ', 'antrag_typ', 'Dokumenttypen'],
                ['antrag_wahlperiode', 'antrag_wahlperiode', 'Wahlperiode'],
                ['dokument_bas', 'ba', 'Bezirksauschüsse'],
                ['referat_id', 'referat', 'Referat'],
            ];

            $facetSet = $select->getFacetSet();
            foreach ($facet_field_namess as $facet_field_names) {
                $facetSet
                    ->createFacetField($facet_field_names[0])
                    ->setField($facet_field_names[0])
                    ->setExcludes([$facet_field_names[0]]);
            }

            try {
                $ergebnisse = $solr->select($select);
            } catch (Exception $e) {
                $this->render('error', ["code" => 500, "message" => "Ein Fehler bei der Suche ist aufgetreten"]);
                Yii::app()->end(500);
            }

            $x = $this->extractAvailalbleFacets($ergebnisse, $krits, $facet_field_namess);
            $available_facets = $x[0];
            $used_factes = $x[1];

            if ($krits->isGeoKrit()) $geodata = $this->getJSGeodata($krits, $ergebnisse);
            else $geodata = null;

            $this->render("suchergebnisse", array_merge([
                "krits"            => $krits,
                "ergebnisse"       => $ergebnisse,
                "geodata"          => $geodata,
                "geodata_overflow" => [], // Reicht für diesen Fall
                "available_facets" => $available_facets,
                "used_facets"      => $used_factes,
            ], $benachrichtigungen_optionen));
        } else {
            $this->render("suche");
        }
    }

    /**
     * @param int $id
     */
    public function actionDocumentProxy($id)
    {
        $dokument = Dokument::getCachedByID($id);
        if ($dokument === null) {
            header("HTTP/1.0 404 Not Found");
            Yii::app()->end();
        }

        $content = $dokument->getDateiInhalt();
        if ($content === null){
            header("HTTP/1.0 404 Not Found");
            Yii::app()->end();
        }

        echo $content;
        Yii::app()->end();
    }

    /**
     * @param int $ba_nr
     * @param string $datum_max
     * @param int|null $tage
     * @return array
     */
    private function ba_dokumente_nach_datum($ba_nr, $datum_max, $tage = null)
    {
        if ($tage === null) $tage = static::$BA_DOKUMENTE_TAGE_PRO_SEITE;

        if (preg_match("/^[0-9]{4}\-[0-9]{2}\-[0-9]{2}$/siu", $datum_max)) {
            if ($datum_max < 2013) {
                return []; // Überlastung des Servers verhindertn
            }
            $datum_bis = $datum_max;
            $datum_von = date("Y-m-d", RISTools::date_iso2timestamp($datum_max) - $tage * 24 * 3600);
        } else {
            $datum_bis = date("Y-m-d");
            $datum_von = date("Y-m-d", time() - $tage * 24 * 3600);
        }

        /** @var array|Antrag[] $antraege1 */
        $antraege1 = Antrag::model()->neueste_stadtratsantragsdokumente($ba_nr, $datum_von . " 00:00:00", $datum_bis . " 23:59:59")->findAll();
        /** @var array|Antrag[] $antraege2 */
        $antraege2 = Antrag::model()->neueste_stadtratsantragsdokumente_geo($ba_nr, $datum_von . " 00:00:00", $datum_bis . " 23:59:59")->findAll();

        $antraege = $antraege1;
        $a_ids    = [];
        foreach ($antraege1 as $a) $a_ids[] = $a->id;
        foreach ($antraege2 as $a) if (!in_array($a->id, $a_ids)) $antraege[] = $a;
        usort($antraege, function ($a1, $a2) {
            /** @var Antrag $a1 */
            /** @var Antrag $a2 */
            $ts1 = $a1->neuestes_dokument_ts();
            $ts2 = $a2->neuestes_dokument_ts();
            if ($ts1 > $ts2) return -1;
            if ($ts1 < $ts2) return 1;
            return 0;
        });

        list($geodata1, $geodata_overflow1) = $this->antraege2geodata($antraege1);
        list($geodata2, $geodata_overflow2) = $this->antraege2geodata($antraege2, 1);
        $geodata          = array_merge($geodata1, $geodata2);
        $geodata_overflow = array_merge($geodata_overflow1, $geodata_overflow2);

        $aeltere_url_std  = $this->createUrl("index/baDokumente", ["ba_nr" => $ba_nr, "datum_max" => date("Y-m-d", RISTools::date_iso2timestamp($datum_bis) - $tage * 24 * 3600)]);
        $neuere_url_std   = (str_replace("-", "", $datum_bis) < date("Ymd") ? $this->createUrl("index/baDokumente", ["ba_nr" => $ba_nr, "datum_max" => date("Y-m-d", RISTools::date_iso2timestamp($datum_bis) + $tage * 24 * 3600)]) : null);
        return [
            "datum_von"        => $datum_von,
            "datum_bis"        => $datum_bis,
            "aeltere_url_std"  => $aeltere_url_std,
            "neuere_url_std"   => $neuere_url_std,
            "antraege"         => $antraege,
            "geodata"          => $geodata,
            "geodata_overflow" => $geodata_overflow,
        ];
    }

    /**
     * @param int $ba_nr
     * @param string $datum_max
     */
    public function actionBaAntraegeAjaxDatum($ba_nr, $datum_max)
    {
        $data = $this->ba_dokumente_nach_datum($ba_nr, $datum_max);

        ob_start();
        $this->renderPartial('index_antraege_liste', array_merge([
            "weiter_links_oben" => true,
        ], $data));

        Header("Content-Type: application/json; charset=UTF-8");
        echo json_encode([
            "datum_von"        => $data["datum_von"],
            "datum_bis"        => $data["datum_bis"],
            "html"             => ob_get_clean(),
            "geodata"          => $data["geodata"],
            "geodata_overflow" => $data["geodata_overflow"],
        ]);
        Yii::app()->end();
    }


    /**
     * @param int $ba_nr
     * @param string $datum_max
     */
    public function actionBa($ba_nr, $datum_max = "")
    {
        $this->top_menu = "ba";

        $tage_zukunft       = 60;
        $tage_vergangenheit = 60;

        $antraege_data = $this->ba_dokumente_nach_datum($ba_nr, $datum_max);

        $termine          = Termin::model()->termine_stadtrat_zeitraum($ba_nr, date("Y-m-d 00:00:00", time() - $tage_vergangenheit * 24 * 3600), date("Y-m-d 00:00:00", time() + $tage_zukunft * 24 * 3600), true)->findAll(['order' => 'termin DESC']);
        $termin_dokumente = Termin::model()->neueste_ba_dokumente($ba_nr, date("Y-m-d 00:00:00", time() - $tage_vergangenheit * 24 * 3600), date("Y-m-d H:i:s", time()), false)->findAll();
        $termine          = Termin::groupAppointments($termine);

        /** @var Termin[] $bvs */
        $bvs     = Termin::model()->findAllByAttributes(["ba_nr" => $ba_nr, "typ" => Termin::$TYP_BUERGERVERSAMMLUNG], ["order" => "termin DESC", "condition" => "termin > NOW()"]);
        $bvs_arr = [];
        foreach ($bvs as $bv) $bvs_arr[] = $bv->toArr();


        /** @var Bezirksausschuss $ba */
        $ba      = Bezirksausschuss::model()->findByPk($ba_nr);
        $gremien = $ba->gremien;

        $this->render("ba_startseite", array_merge([
            "ba"                           => $ba,
            "gremien"                      => $gremien,
            "termine"                      => $termine,
            "termin_dokumente"             => $termin_dokumente,
            "bvs"                          => $bvs_arr,
            "tage_vergangenheit"           => $tage_vergangenheit,
            "tage_zukunft"                 => $tage_zukunft,
            "tage_vergangenheit_dokumente" => static::$BA_DOKUMENTE_TAGE_PRO_SEITE,
            "fraktionen"                   => StadtraetIn::getGroupedByFraktion(date("Y-m-d"), $ba_nr),
            "explizites_datum"             => ($datum_max != ""),
        ], $antraege_data));
    }

    /**<commit_msg>BA-Fraktionen nicht als Gremium anzeigen<commit_after><?php

class IndexController extends RISBaseController
{
    public static $BA_DOKUMENTE_TAGE_PRO_SEITE = 14;

    /**
     * @param int $width
     * @param int $zoom
     * @param int $x
     * @param int $y
     */
    public function actionTileCache($width, $zoom, $x, $y)
    {

        if ($width == 256) {
            $boundaries = [
                3  => [2, 2, 6, 3],
                4  => [6, 4, 11, 6],
                5  => [14, 10, 19, 11],
                6  => [31, 21, 36, 22],
                7  => [66, 43, 70, 45],
                8  => [134, 88, 138, 89],
                9  => [270, 176, 274, 178],
                10 => [542, 354, 547, 356],
                11 => [1086, 708, 1091, 712],
            ];
            if (isset($boundaries[$zoom])) {
                $bound       = $boundaries[$zoom];
                $outofbounds = false;
                if ($x < $bound[0] || $y < $bound[1] || $x > $bound[2] || $y > $bound[3]) $outofbounds = true;

                if ($outofbounds) {
                    Header("Location: /images/HereBeDragons256.png");
                    Yii::app()->end();
                }
            }
        }

        if ($width == 256) {
            $array = ["1", "2", "3"];
            $key   = $array[array_rand($array)] . "-" . Yii::app()->params['skobblerKey'];
            $url   = "http://tiles" . $key . ".skobblermaps.com/TileService/tiles/2.0/00022210100/0/${zoom}/${x}/${y}.png";
        } else {
            $array = ["1", "2", "3"];
            $key   = $array[array_rand($array)] . "-" . Yii::app()->params['skobblerKey'];
            $url   = "http://tiles" . $key . ".skobblermaps.com/TileService/tiles/2.0/00022210100/0/${zoom}/${x}/${y}.png@2x";
        }

        $fp = fopen("/tmp/tiles.log", "a");
        fwrite($fp, $url . "\n");
        fclose($fp);


        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL, $url);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
        curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 10);
        curl_setopt($ch, CURLOPT_USERAGENT, RISTools::STD_USER_AGENT);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
        $string = curl_exec($ch);
        $status = curl_getinfo($ch, CURLINFO_HTTP_CODE);

        if ($status == 200 && $string != "") {
            if (!file_exists(TILE_CACHE_DIR . "$width")) @mkdir(TILE_CACHE_DIR . "$width", 0775);
            if (!file_exists(TILE_CACHE_DIR . "$width/$zoom")) @mkdir(TILE_CACHE_DIR . "$width/$zoom", 0775);
            if (!file_exists(TILE_CACHE_DIR . "$width/$zoom/$x")) @mkdir(TILE_CACHE_DIR . "$width/$zoom/$x", 0775);
            file_put_contents(TILE_CACHE_DIR . "$width/$zoom/$x/$y.png", $string);
            Header("Content-Type: image/png");
            echo $string;
        } else {
            Header("Content-Type: text/plain");
            echo $status;
            var_dump($ch);
        }
        Yii::app()->end();
    }

    public function actionFeed()
    {
        if (isset($_REQUEST["krit_typ"])) {
            $krits = RISSucheKrits::createFromUrl($_REQUEST);
            $titel = Yii::app()->params['projectTitle'] . ': ' . $krits->getBeschreibungDerSuche();

            $solr   = RISSolrHelper::getSolrClient();
            $select = $solr->createSelect();

            $krits->addKritsToSolr($select);

            $select->setRows(100);
            $select->addSort('sort_datum', $select::SORT_DESC);

            /** @var Solarium\QueryType\Select\Query\Component\Highlighting\Highlighting $hl */
            $hl = $select->getHighlighting();
            $hl->setFields(['text', 'text_ocr', 'antrag_betreff']);
            $hl->setSimplePrefix('<b>');
            $hl->setSimplePostfix('</b>');

            $ergebnisse = $solr->execute($select);

            $data = RISSolrHelper::ergebnisse2FeedData($ergebnisse);
        } else {
            $data = [];
            /** @var array|RISAenderung[] $aenderungen */
            $aenderungen = RISAenderung::model()->findAll(["order" => "id DESC", "limit" => 100]);
            foreach ($aenderungen as $aenderung) $data[] = $aenderung->toFeedData();
            $titel = Yii::app()->params['projectTitle'] . ' Änderungen';
        }

        $this->render("feed", [
            "feed_title"       => $titel,
            "feed_description" => $titel,
            "data"             => $data,
        ]);
    }

    /**
     * @param RISSucheKrits $curr_krits
     * @param string $code
     * @return array
     */
    protected function sucheBenachrichtigungenAnmelden($curr_krits, $code)
    {
        $user = Yii::app()->getUser();

        $correct_person      = null;
        $wird_benachrichtigt = false;

        $do_benachrichtigung_add = AntiXSS::isTokenSet("benachrichtigung_add"); // Token ändert sich möglicherweise beim Login
        $do_benachrichtigung_del = AntiXSS::isTokenSet("benachrichtigung_del");

        $this->performLoginActions();

        if (!$user->isGuest) {
            /** @var BenutzerIn $ich */
            $ich = BenutzerIn::model()->findByAttributes(["email" => Yii::app()->user->id]);

            if ($do_benachrichtigung_add) {
                $ich->addBenachrichtigung($curr_krits);
                $this->msg_ok .= 'Die Benachrichtigung wurde hinzugefügt.';
            }
            if ($do_benachrichtigung_del) {
                $deleted = $ich->delBenachrichtigung($curr_krits);
                if ($deleted) {
                    $this->msg_ok = "Die Benachrichtigung wurde entfernt.";
                } else {
                    $this->msg_err = "Fehler: Die Benachrichtigung konnte nicht entfernt werden.";
                }
            }

            $wird_benachrichtigt = $ich->wirdBenachrichtigt($curr_krits);
        }


        if ($user->isGuest) {
            $ich              = null;
            $eingeloggt       = false;
            $email_angegeben  = false;
            $email_bestaetigt = false;
        } else {
            $eingeloggt = true;
            /** @var BenutzerIn $ich */
            if (!$ich) $ich = BenutzerIn::model()->findByAttributes(["email" => Yii::app()->user->id]);
            if ($ich->email == "") {
                $email_angegeben  = false;
                $email_bestaetigt = false;
            } elseif ($ich->email_bestaetigt) {
                $email_angegeben  = true;
                $email_bestaetigt = true;
            } else {
                $email_angegeben  = true;
                $email_bestaetigt = false;
            }
        }

        return [
            "eingeloggt"          => $eingeloggt,
            "email_angegeben"     => $email_angegeben,
            "email_bestaetigt"    => $email_bestaetigt,
            "wird_benachrichtigt" => $wird_benachrichtigt,
            "ich"                 => $ich,
        ];
    }

    /**
     * @param Dokument[] $dokumente
     * @param null|RISSucheKrits $filter_krits
     * @return array
     */
    protected function dokumente2geodata(&$dokumente, $filter_krits = null)
    {
        $geodata = [];
        foreach ($dokumente as $dokument) {
            if ($dokument->antrag) {
                $link = $dokument->antrag->getLink();
                $name = $dokument->antrag->getName();
            } elseif ($dokument->termin) {
                $link = $dokument->termin->getLink();
                $name = $dokument->termin->getName();
            } else {
                $link = $name = "";
            }
            if (strlen($name) > 150) $name = mb_substr($name, 0, 148) . "...";
            if ($link != "") $link = "<div class='antraglink'>" . CHtml::link($name, $link) . "</div>";
            foreach ($dokument->orte as $ort) if ($ort->ort->to_hide == 0 && ($filter_krits === null || $filter_krits->filterGeo($ort->ort))) {
                $str = $link;
                $str .= "<div class='ort_dokument'>";
                $str .= "<div class='ort'>" . CHtml::encode($ort->ort->ort) . "</div>";
                $str .= "<div class='dokument'>" . CHtml::link($dokument->name, $this->createUrl("index/dokument", ["id" => $dokument->id])) . "</div>";
                $str .= "</div>";
                $geodata[] = [
                    FloatVal($ort->ort->lat),
                    FloatVal($ort->ort->lon),
                    $str
                ];
            }
        }
        return $geodata;
    }

    /**
     * @param RISSucheKrits $krits
     * @param \Solarium\QueryType\Select\Result\Result $ergebnisse
     * @return array
     */
    protected function getJSGeodata($krits, $ergebnisse)
    {
        $geo = $krits->getGeoKrit();
        /** @var RISSolrDocument[] $solr_dokumente */
        $solr_dokumente = $ergebnisse->getDocuments();
        $dokument_ids   = [];
        foreach ($solr_dokumente as $dokument) {
            $x              = explode(":", $dokument->id);
            $dokument_ids[] = IntVal($x[1]);
        }
        $geodata = [];
        if (count($dokument_ids) > 0) {
            $lat        = FloatVal($geo["lat"]);
            $lng        = FloatVal($geo["lng"]);
            $dist_field = "(((acos(sin(($lat*pi()/180)) * sin((lat*pi()/180))+cos(($lat*pi()/180)) * cos((lat*pi()/180)) * cos((($lng- lon)*pi()/180))))*180/pi())*60*1.1515*1.609344) <= " . FloatVal($geo["radius"] / 1000);
            $SQL        = "select a.dokument_id, b.* FROM antraege_orte a JOIN orte_geo b ON a.ort_id = b.id WHERE a.dokument_id IN (" . implode(", ", $dokument_ids) . ") AND b.to_hide = 0 AND $dist_field";
            $result     = Yii::app()->db->createCommand($SQL)->queryAll();
            foreach ($result as $geo) {
                /** @var Dokument $dokument */
                $dokument = Dokument::model()->findByPk($geo["dokument_id"]);

                if ($dokument->antrag) {
                    $link = $dokument->antrag->getLink();
                    $name = $dokument->antrag->getName();
                } elseif ($dokument->termin) {
                    $link = $dokument->termin->getLink();
                    $name = $dokument->termin->getName();
                } else {
                    $link = $name = "";
                }
                if (strlen($name) > 150) $name = mb_substr($name, 0, 148) . "...";
                if ($link != "") $link = "<div class='antraglink'>" . CHtml::link($name, $link) . "</div>";
                $str = $link;
                $str .= "<div class='ort_dokument'>";
                $str .= "<div class='ort'>" . CHtml::encode($geo["ort"]) . "</div>";
                $str .= "<div class='dokument'>" . CHtml::link($dokument->name, $this->createUrl("index/dokument", ["id" => $dokument->id])) . "</div>";
                $str .= "</div>";
                $geodata[] = [
                    FloatVal($geo["lat"]),
                    FloatVal($geo["lon"]),
                    $str
                ];
            }

        }
        return $geodata;
    }


    /**
     * @param Antrag[] $antraege
     * @param int $typ
     * @return array
     */
    protected function antraege2geodata(&$antraege, $typ = 0)
    {
        $geodata          = $geodata_overflow = [];
        $geodata_nach_dok = [];
        foreach ($antraege as $ant) {
            foreach ($ant->dokumente as $dokument) {
                foreach ($dokument->orte as $ort) if ($ort->ort->to_hide == 0) {
                    $name = $ant->getName();
                    if (strlen($name) > 150) $name = mb_substr($name, 0, 148) . "...";
                    $str = "<div class='antraglink'>" . CHtml::link($name, $ant->getLink()) . "</div>";
                    $str .= "<div class='ort_dokument'>";
                    $str .= "<div class='ort'>" . CHtml::encode($ort->ort->ort) . "</div>";
                    $str .= "<div class='dokument'>" . CHtml::link($dokument->getName(), $dokument->getLink()) . "</div>";
                    $str .= "</div>";
                    $str = mb_convert_encoding($str, 'UTF-8', 'UTF-8');

                    if (!isset($geodata_nach_dok[$dokument->id])) $geodata_nach_dok[$dokument->id] = [];
                    $geodata_nach_dok[$dokument->id][] = [
                        FloatVal($ort->ort->lat),
                        FloatVal($ort->ort->lon),
                        $str,
                        $typ
                    ];
                }
            }
        }
        foreach ($geodata_nach_dok as $dok_geo) if (count($dok_geo) >= 10) {
            $geodata_overflow[] = $dok_geo;
        } else {
            foreach ($dok_geo as $d) $geodata[] = $d;
        }

        return [$geodata, $geodata_overflow];
    }

    /**
     * @param float $lat
     * @param float $lng
     */
    public function actionGeo2Address($lat, $lng)
    {
        Header("Content-Type: application/json; charset=UTF-8");
        $naechster_ort = OrtGeo::findClosest($lng, $lat);
        echo json_encode([
            "ort_name" => $naechster_ort->ort,
        ]);
        Yii::app()->end();
    }


    /**
     * @param float $lat
     * @param float $lng
     * @param float $radius
     * @param int $seite
     */
    public function actionAntraegeAjaxGeo($lat, $lng, $radius, $seite = 0)
    {
        $krits = new RISSucheKrits();
        $krits->addKrit('geo', $lng . '-' . $lat . '-' . $radius);

        $solr   = RISSolrHelper::getSolrClient();
        $select = $solr->createSelect();

        $krits->addKritsToSolr($select);

        $select->setStart(30 * $seite);
        $select->setRows(30);
        $select->addSort('sort_datum', $select::SORT_DESC);

        $ergebnisse = $solr->select($select);

        /** @var Antrag[] $antraege */
        $antraege = [];
        /** @var RISSolrDocument[] $solr_dokumente */
        $solr_dokumente = $ergebnisse->getDocuments();
        $dokument_ids   = [];
        foreach ($solr_dokumente as $dokument) {
            $x              = explode(":", $dokument->id);
            $dokument_ids[] = IntVal($x[1]);
        }
        foreach ($dokument_ids as $dok_id) {
            /** @var Dokument $ant */
            $ant = Dokument::model()->with([
                "antrag"           => [],
                "antrag.dokumente" => [
                    "alias"     => "dokumente_2",
                    "condition" => "dokumente_2.id IN (" . implode(", ", $dokument_ids) . ")"
                ]
            ])->findByPk($dok_id);
            if ($ant && $ant->antrag) {
                $antraege[$ant->antrag_id] = $ant->antrag;
            }
        }

        $geodata       = $this->getJSGeodata($krits, $ergebnisse);
        $naechster_ort = OrtGeo::findClosest($lng, $lat);
        ob_start();

        $this->renderPartial('index_antraege_liste', [
            "aeltere_url_ajax"  => $this->createUrl("index/antraegeAjaxGeo", ["lat" => $lat, "lng" => $lng, "radius" => $radius, "seite" => ($seite + 1)]),
            "aeltere_url_std"   => $this->createUrl("index/antraegeStdGeo", ["lat" => $lat, "lng" => $lng, "radius" => $radius, "seite" => ($seite + 1)]),
            "neuere_url_ajax"   => null,
            "neuere_url_std"    => null,
            "antraege"          => $antraege,
            "geo_lng"           => $lng,
            "geo_lat"           => $lat,
            "radius"            => $radius,
            "naechster_ort"     => $naechster_ort,
            "weiter_links_oben" => true,
            "zeige_jahr"        => true,
        ]);

        Header("Content-Type: application/json; charset=UTF-8");
        echo json_encode([
            "datum"         => date("Y-m-d"),
            "html"          => ob_get_clean(),
            "geodata"       => $geodata,
            "krit_str"      => $krits->getJson(),
            "naechster_ort" => $naechster_ort->ort
        ]);
        Yii::app()->end();
    }

    /**
     * Extrahiert die möglichen Filteroptionen in Gruppen mit Titel, URL und Anzahl der Dokumente
     *
     * @param \Solarium\QueryType\Select\Result\Result $ergebnisse
     * @param RISSucheKrits $krits
     * @param array $facet_field_names
     * @return array
     * @throws Exception
     */
    private function extractAvailalbleFacets($ergebnisse, $krits, $facet_field_names) {
        $availalbe_facets = [];
        $used_factes      = [];

        foreach ($facet_field_names as $facet_field_name) {
            // Gewählte Option ausnehmen, um Duplikate zu vermeiden
            $krit_used = $krits->hasKrit($facet_field_name[1]);
            $krits_without_used = $krits;
            $krit_alone = null;

            if ($krit_used) {
                $krits_without_used = new RISSucheKrits();
                foreach ($krits->krits as $i) {
                    if ($i["typ"] != $facet_field_name[1]) {
                        $krits_without_used->krits[] = $i;
                    } else {
                        $krit_alone = $i;
                    }
                }
            }

            $facet_group = [];
            $facet = $ergebnisse->getFacetSet()->getFacet($facet_field_name[0]);

            foreach ($facet as $value => $count) if ($count > 0) {
                if (in_array($value, array("", "?"))) continue;

                $facet_option = [];
                $facet_option['url'] = RISTools::bracketEscape(CHtml::encode($krits_without_used->cloneKrits()->addKrit($facet_field_name[1], $value)->getUrl()));
                $facet_option['count'] = $count;

                if ($facet_field_name[0] == 'antrag_typ') {
                    if (isset(Antrag::$TYPEN_ALLE[$value])) $facet_option['name'] = explode("|", Antrag::$TYPEN_ALLE[$value])[1];
                    else if ($value == "stadtrat_termin") $facet_option['name'] = 'Stadtrats-Termin';
                    else if ($value == "ba_termin") $facet_option['name'] = 'BA-Termin';
                    else $facet_option['name'] = $value;
                } else if ($facet_field_name[0] == 'antrag_wahlperiode') {
                    $facet_option['name'] = $value;
                } else if ($facet_field_name[0] == 'dokument_bas') {
                    $facet_option['name'] = $value . ": " . Bezirksausschuss::model()->findByPk($value)->name;
                } else if ($facet_field_name[0] == 'referat_id') {
                    $facet_option['name'] = Referat::model()->findByPk($value)->name;
                } else {
                    throw new Exception("unknown facet");
                }

                $facet_group[] = $facet_option;
            }

            $to_add = [
                "name" => $facet_field_name[2],
                "typ" => $facet_field_name[1],
                "group" => $facet_group,
                "krits_without_used" => $krits_without_used,
                "krit_alone" => $krit_alone,
            ];


            if ($krit_used) {
                // Ẃir brauchen mindestens 2, weil die erste Möglichkeit die bereits gewählte ist
                if (count($facet_group) >= 2) {
                    $used_factes[] = $to_add;
                }
            } else {
                if (count($facet_group) >= 1) {
                    $availalbe_facets[] = $to_add;
                }
            }
        }

        return [$availalbe_facets, $used_factes];
    }


    /**
     * @param string $code
     */
    public function actionSuche($code = "")
    {
        if (AntiXSS::isTokenSet("search_form")) {
            $krits = new RISSucheKrits();
            if (trim($_REQUEST["volltext"]) != "")  $krits->addKrit('volltext',   $_REQUEST["volltext"]);
            if (trim($_REQUEST["antrag_nr"]) != "") $krits->addKrit('antrag_nr',  $_REQUEST["antrag_nr"]);
            if ($_REQUEST["typ"] != "")             $krits->addKrit('antrag_typ', $_REQUEST["typ"]);
            if ($_REQUEST["referat"] > 0)           $krits->addKrit('referat',    $_REQUEST["referat"]);

            /*
             * @TODO: Setzt voraus: offizielles Datum eines Dokuments ermitteln
            $datum_von = $datum_bis = null;
            if ($_REQUEST["datum_von"] != "") {
                $x = explode(".", $_REQUEST["datum_von"]);
                if (count($x) == 3) $datum_von = $x[2] . "-" . $x[1] . "-" . $x[0] . " 00:00:00";
            }
            if ($_REQUEST["datum_bis"] != "") {
                $x = explode(".", $_REQUEST["datum_bis"]);
                if (count($x) == 3) $datum_bis = $x[2] . "-" . $x[1] . "-" . $x[0] . " 23:59:59";
            }
            if ($datum_von || $datum_bis) $krits->addDatumKrit($datum_von, $datum_bis);
            */

        } else if (isset($_REQUEST["suchbegriff"]) && $_REQUEST["suchbegriff"] != "") {
            $suchbegriff = $_REQUEST["suchbegriff"];
            if ($_SERVER["REQUEST_METHOD"] == 'POST') $this->redirect($this->createUrl("index/suche", ["suchbegriff" => $suchbegriff]));
            $this->suche_pre = $suchbegriff;
            $krits           = new RISSucheKrits();
            $krits->addKrit('volltext', $suchbegriff);
        } else {
            $krits = RISSucheKrits::createFromUrl($_REQUEST);
        }

        if ($krits->getKritsCount() > 0) {
            $benachrichtigungen_optionen = $this->sucheBenachrichtigungenAnmelden($krits, $code);

            $solr = RISSolrHelper::getSolrClient();
            $select = $solr->createSelect();

            $krits->addKritsToSolr($select);

            $select->setRows(50);
            $select->addSort('sort_datum', $select::SORT_DESC);

            // Tag hinzufügen, der den Namen entspricht
            foreach ($select->getFilterQueries() as $filter_query) {
                $filter_query->addTag($filter_query->getKey());
            }

            /** @var Solarium\QueryType\Select\Query\Component\Highlighting\Highlighting $hl */
            $hl = $select->getHighlighting();
            $hl->setFields(['text', 'text_ocr', 'antrag_betreff']);
            $hl->setSimplePrefix('<b>');
            $hl->setSimplePostfix('</b>');

            $facet_field_namess = [
                ['antrag_typ', 'antrag_typ', 'Dokumenttypen'],
                ['antrag_wahlperiode', 'antrag_wahlperiode', 'Wahlperiode'],
                ['dokument_bas', 'ba', 'Bezirksauschüsse'],
                ['referat_id', 'referat', 'Referat'],
            ];

            $facetSet = $select->getFacetSet();
            foreach ($facet_field_namess as $facet_field_names) {
                $facetSet
                    ->createFacetField($facet_field_names[0])
                    ->setField($facet_field_names[0])
                    ->setExcludes([$facet_field_names[0]]);
            }

            try {
                $ergebnisse = $solr->select($select);
            } catch (Exception $e) {
                $this->render('error', ["code" => 500, "message" => "Ein Fehler bei der Suche ist aufgetreten"]);
                Yii::app()->end(500);
            }

            $x = $this->extractAvailalbleFacets($ergebnisse, $krits, $facet_field_namess);
            $available_facets = $x[0];
            $used_factes = $x[1];

            if ($krits->isGeoKrit()) $geodata = $this->getJSGeodata($krits, $ergebnisse);
            else $geodata = null;

            $this->render("suchergebnisse", array_merge([
                "krits"            => $krits,
                "ergebnisse"       => $ergebnisse,
                "geodata"          => $geodata,
                "geodata_overflow" => [], // Reicht für diesen Fall
                "available_facets" => $available_facets,
                "used_facets"      => $used_factes,
            ], $benachrichtigungen_optionen));
        } else {
            $this->render("suche");
        }
    }

    /**
     * @param int $id
     */
    public function actionDocumentProxy($id)
    {
        $dokument = Dokument::getCachedByID($id);
        if ($dokument === null) {
            header("HTTP/1.0 404 Not Found");
            Yii::app()->end();
        }

        $content = $dokument->getDateiInhalt();
        if ($content === null){
            header("HTTP/1.0 404 Not Found");
            Yii::app()->end();
        }

        echo $content;
        Yii::app()->end();
    }

    /**
     * @param int $ba_nr
     * @param string $datum_max
     * @param int|null $tage
     * @return array
     */
    private function ba_dokumente_nach_datum($ba_nr, $datum_max, $tage = null)
    {
        if ($tage === null) $tage = static::$BA_DOKUMENTE_TAGE_PRO_SEITE;

        if (preg_match("/^[0-9]{4}\-[0-9]{2}\-[0-9]{2}$/siu", $datum_max)) {
            if ($datum_max < 2013) {
                return []; // Überlastung des Servers verhindertn
            }
            $datum_bis = $datum_max;
            $datum_von = date("Y-m-d", RISTools::date_iso2timestamp($datum_max) - $tage * 24 * 3600);
        } else {
            $datum_bis = date("Y-m-d");
            $datum_von = date("Y-m-d", time() - $tage * 24 * 3600);
        }

        /** @var array|Antrag[] $antraege1 */
        $antraege1 = Antrag::model()->neueste_stadtratsantragsdokumente($ba_nr, $datum_von . " 00:00:00", $datum_bis . " 23:59:59")->findAll();
        /** @var array|Antrag[] $antraege2 */
        $antraege2 = Antrag::model()->neueste_stadtratsantragsdokumente_geo($ba_nr, $datum_von . " 00:00:00", $datum_bis . " 23:59:59")->findAll();

        $antraege = $antraege1;
        $a_ids    = [];
        foreach ($antraege1 as $a) $a_ids[] = $a->id;
        foreach ($antraege2 as $a) if (!in_array($a->id, $a_ids)) $antraege[] = $a;
        usort($antraege, function ($a1, $a2) {
            /** @var Antrag $a1 */
            /** @var Antrag $a2 */
            $ts1 = $a1->neuestes_dokument_ts();
            $ts2 = $a2->neuestes_dokument_ts();
            if ($ts1 > $ts2) return -1;
            if ($ts1 < $ts2) return 1;
            return 0;
        });

        list($geodata1, $geodata_overflow1) = $this->antraege2geodata($antraege1);
        list($geodata2, $geodata_overflow2) = $this->antraege2geodata($antraege2, 1);
        $geodata          = array_merge($geodata1, $geodata2);
        $geodata_overflow = array_merge($geodata_overflow1, $geodata_overflow2);

        $aeltere_url_std  = $this->createUrl("index/baDokumente", ["ba_nr" => $ba_nr, "datum_max" => date("Y-m-d", RISTools::date_iso2timestamp($datum_bis) - $tage * 24 * 3600)]);
        $neuere_url_std   = (str_replace("-", "", $datum_bis) < date("Ymd") ? $this->createUrl("index/baDokumente", ["ba_nr" => $ba_nr, "datum_max" => date("Y-m-d", RISTools::date_iso2timestamp($datum_bis) + $tage * 24 * 3600)]) : null);
        return [
            "datum_von"        => $datum_von,
            "datum_bis"        => $datum_bis,
            "aeltere_url_std"  => $aeltere_url_std,
            "neuere_url_std"   => $neuere_url_std,
            "antraege"         => $antraege,
            "geodata"          => $geodata,
            "geodata_overflow" => $geodata_overflow,
        ];
    }

    /**
     * @param int $ba_nr
     * @param string $datum_max
     */
    public function actionBaAntraegeAjaxDatum($ba_nr, $datum_max)
    {
        $data = $this->ba_dokumente_nach_datum($ba_nr, $datum_max);

        ob_start();
        $this->renderPartial('index_antraege_liste', array_merge([
            "weiter_links_oben" => true,
        ], $data));

        Header("Content-Type: application/json; charset=UTF-8");
        echo json_encode([
            "datum_von"        => $data["datum_von"],
            "datum_bis"        => $data["datum_bis"],
            "html"             => ob_get_clean(),
            "geodata"          => $data["geodata"],
            "geodata_overflow" => $data["geodata_overflow"],
        ]);
        Yii::app()->end();
    }


    /**
     * @param int $ba_nr
     * @param string $datum_max
     */
    public function actionBa($ba_nr, $datum_max = "")
    {
        $this->top_menu = "ba";

        $tage_zukunft       = 60;
        $tage_vergangenheit = 60;

        $antraege_data = $this->ba_dokumente_nach_datum($ba_nr, $datum_max);

        $termine          = Termin::model()->termine_stadtrat_zeitraum($ba_nr, date("Y-m-d 00:00:00", time() - $tage_vergangenheit * 24 * 3600), date("Y-m-d 00:00:00", time() + $tage_zukunft * 24 * 3600), true)->findAll(['order' => 'termin DESC']);
        $termin_dokumente = Termin::model()->neueste_ba_dokumente($ba_nr, date("Y-m-d 00:00:00", time() - $tage_vergangenheit * 24 * 3600), date("Y-m-d H:i:s", time()), false)->findAll();
        $termine          = Termin::groupAppointments($termine);

        /** @var Termin[] $bvs */
        $bvs     = Termin::model()->findAllByAttributes(["ba_nr" => $ba_nr, "typ" => Termin::$TYP_BUERGERVERSAMMLUNG], ["order" => "termin DESC", "condition" => "termin > NOW()"]);
        $bvs_arr = [];
        foreach ($bvs as $bv) $bvs_arr[] = $bv->toArr();


        /** @var Bezirksausschuss $ba */
        $ba      = Bezirksausschuss::model()->findByPk($ba_nr);
        $gremien = array_filter($ba->gremien, function (Gremium $gremium) {
            return $gremium->gremientyp !== 'BA-Fraktion';
        });

        $this->render("ba_startseite", array_merge([
            "ba"                           => $ba,
            "gremien"                      => $gremien,
            "termine"                      => $termine,
            "termin_dokumente"             => $termin_dokumente,
            "bvs"                          => $bvs_arr,
            "tage_vergangenheit"           => $tage_vergangenheit,
            "tage_zukunft"                 => $tage_zukunft,
            "tage_vergangenheit_dokumente" => static::$BA_DOKUMENTE_TAGE_PRO_SEITE,
            "fraktionen"                   => StadtraetIn::getGroupedByFraktion(date("Y-m-d"), $ba_nr),
            "explizites_datum"             => ($datum_max != ""),
        ], $antraege_data));
    }

    /**
{'fraction_non_alphanumeric': 0.17203669847872394, 'fraction_numerical': 0.015095352308750273, 'mean_word_length': 1.7919456801685787, 'pattern_counts': {'":': 6, '<': 73, '<?xml version=': 0, '>': 680, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6528383', 'n_tokens_mistral': 20942, 'n_tokens_neox': 19698, 'n_words': 3132}