public function run($args) { if (count($args) == 0) { die("./yii recalc_ort2ba [Orts-ID|alle]\n"); } if ($args[0] == "alle") { /** @var OrtGeo[] $orte */ $orte = OrtGeo::model()->findAll(["order" => "id"]); } else { /** @var OrtGeo[] $orte */ $orte = OrtGeo::model()->findAll(["condition" => "id = " . IntVal($args[0])]); } /** @var Bezirksausschuss[] $bas */ $bas = Bezirksausschuss::model()->findAll(); foreach ($orte as $ort) { $found_ba = null; foreach ($bas as $ba) { if ($ba->pointInBA($ort->lon, $ort->lat)) { echo $ort->id . " - " . $ort->ort . ": " . $ba->ba_nr . "\n"; $found_ba = $ba->ba_nr; } } if ($found_ba) { $ort->ba_nr = $found_ba; $ort->save(); } } }
/** * @param float $lat * @param float $lng * @param float $radius * @param int $seite */ public function actionAntraegeAjaxGeo($lat, $lng, $radius, $seite = 0) { $krits = new RISSucheKrits(); $krits->addGeoKrit($lng, $lat, $radius); $solr = RISSolrHelper::getSolrClient("ris"); $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(); }
/** * @param float $lng * @param float $lat * @return OrtGeo */ public static function findClosest($lng, $lat) { // SQRT(POW(69.1 * (fld_lat - ( $lat )), 2) + POW(69.1 * (($lon) - fld_lon) * COS(fld_lat / 57.3 ), 2 )) AS distance $lat = FloatVal($lat); $lng = FloatVal($lng); $result = Yii::app()->db->createCommand("SELECT *, SQRT(POW(69.1 * (lat - ( " . $lat . ")), 2) + POW(69.1 * (({$lng}) - lon) * COS(lat / 57.3 ), 2 )) AS distance FROM orte_geo ORDER BY distance ASC LIMIT 0,1")->queryAll(); $res = new OrtGeo(); $res->setAttributes($result[0]); return $res; }
/** * @throws Exception */ public function geo_extract() { $text = $this->text_ocr_corrected . $this->text_pdf; $strassen_gefunden = RISGeo::suche_strassen($text); /** @var array|AntragOrt[] $bisherige */ $bisherige = AntragOrt::model()->findAllByAttributes(["dokument_id" => $this->id]); $bisherige_ids = []; foreach ($bisherige as $i) { $bisherige_ids[] = $i->ort_id; } $neue_ids = []; $indexed = []; foreach ($strassen_gefunden as $strasse_name) { if (!in_array($strasse_name, $indexed)) { $indexed[] = $strasse_name; $geo = OrtGeo::getOrCreate($strasse_name); if (is_null($geo)) { continue; } $neue_ids[] = $geo->id; if (!in_array($geo->id, $bisherige_ids)) { $antragort = new AntragOrt(); $antragort->antrag_id = $this->antrag_id; $antragort->termin_id = $this->termin_id; $antragort->rathausumschau_id = $this->rathausumschau_id; $antragort->dokument_id = $this->id; $antragort->ort_name = $strasse_name; $antragort->ort_id = $geo->id; $antragort->source = "text_parse"; $antragort->datum = date("Y-m-d H:i:s"); try { if (!$antragort->save()) { RISTools::send_email(Yii::app()->params['adminEmail'], "Dokument:geo_extract Error", print_r($antragort->getErrors(), true), null, "system"); throw new Exception("Fehler beim Speichern: geo_extract"); } } catch (Exception $e) { var_dump($antragort->getAttributes()); die; } } } } foreach ($bisherige_ids as $id) { if (!in_array($id, $neue_ids)) { AntragOrt::model()->deleteAllByAttributes(["dokument_id" => $this->id, "ort_id" => $id]); } } $this->orte = AntragOrt::model()->findAllByAttributes(["dokument_id" => $this->id]); }
/** * @param Dokument|null $dokument * @return string */ public function getTitle($dokument = null) { if (count($this->krits) == 1) { switch ($this->krits[0]["typ"]) { case "betreff": $such = $this->krits[0]["suchbegriff"]; if ($such[0] == "\"" && $such[strlen($such) - 1] == "\"") { return "Dokumente mit " . $this->krits[0]["suchbegriff"] . " im Betreff"; } return "Dokumente mit \"" . $such . "\" im Betreff"; case "antrag_typ": return "Dokumente des Typs \"" . Dokument::$TYPEN_ALLE[$this->krits[0]["suchbegriff"]] . "\""; case "volltext": $such = $this->krits[0]["suchbegriff"]; if ($such[0] == "\"" && $such[strlen($such) - 1] == "\"") { return "Volltextsuche nach " . $this->krits[0]["suchbegriff"]; } return "Volltextsuche nach \"" . $such . "\""; case "ba": /** @var Bezirksausschuss $ba */ $ba = Bezirksausschuss::model()->findByAttributes(["ba_nr" => $this->krits[0]["ba_nr"]]); return "Bezirksausschuss " . $ba->ba_nr . ": " . $ba->name; case "geo": $ort = OrtGeo::findClosest($this->krits[0]["lng"], $this->krits[0]["lat"]); $title = "Dokumente mit Ortsbezug (ungefähr: " . IntVal($this->krits[0]["radius"]) . "m um \"" . $ort->ort . "\")"; if ($dokument) { /** @var OrtGeo[] $gefundene_orte */ $gefundene_orte = []; foreach ($dokument->orte as $dok_ort_ort) { $dok_ort = $dok_ort_ort->ort; $distance = RISGeo::getDistance($dok_ort->lat, $dok_ort->lon, $this->krits[0]["lat"], $this->krits[0]["lng"]); if ($distance * 1000 <= $this->krits[0]["radius"]) { $gefundene_orte[] = $dok_ort; } } if (count($gefundene_orte) > 0) { $namen = []; foreach ($gefundene_orte as $gef_ort) { $namen[] = $gef_ort->ort; } $title .= ": " . implode(", ", $namen); } } return $title; case "referat": /** @var Referat $ref */ $ref = Referat::model()->findByPk($this->krits[0]["referat_id"]); return $ref->name; break; case "antrag_wahlperiode": return "Dokumente der Wahlperiode " . $this->krits[0]["suchbegriff"]; case "antrag_nr": return "Antrag Nr. " . str_replace("*", " ", $this->krits[0]["suchbegriff"]); } } if (count($this->krits) > 1) { $krits = []; foreach ($this->krits as $cr) { switch ($cr["typ"]) { case "betreff": $krits[] = "mit \"" . $cr["suchbegriff"] . "\" im Betreff"; break; case "antrag_typ": $krits[] = "vom Typ \"" . Dokument::$TYPEN_ALLE[$cr["suchbegriff"]] . "\""; break; case "volltext": $krits[] = "mit dem Suchausdruck \"" . $cr["suchbegriff"] . "\""; break; case "ba": /** @var Bezirksausschuss $ba */ $ba = Bezirksausschuss::model()->findByAttributes(["ba_nr" => $cr["ba_nr"]]); $krits[] = "aus dem Bezirksausschuss " . $ba->ba_nr . ": " . $ba->name; break; case "geo": $ort = OrtGeo::findClosest($cr["lng"], $cr["lat"]); $krits[] = "mit einem Ortsbezug (ungefähr: " . IntVal($cr["radius"]) . "m um \"" . $ort->ort . "\")"; break; case "antrag_nr": $krits[] = "zum Antrag Nr. " . $cr["suchbegriff"]; break; case "referat": /** @var Referat $ref */ $ref = Referat::model()->findByPk($cr["referat_id"]); $krits[] = "im Zuständigkeitsbereich des " . $ref->name; break; case "antrag_wahlperiode": $krits[] = "aus der Wahlperiode " . CHtml::encode($cr["suchbegriff"]); break; default: $krits[] = json_encode($cr); } } $text = "Dokumente "; for ($i = 0; $i < count($krits) - 1; $i++) { $text .= $krits[$i]; if ($i < count($krits) - 2) { $text .= ", "; } } $text .= " und " . $krits[count($krits) - 1]; return $text; } return json_encode($this->krits); }
/** * @return OrtGeo[] */ public function get_geo() { $return = []; $strassen_gefunden = RISGeo::suche_strassen($this->top_betreff); $indexed = []; foreach ($strassen_gefunden as $strasse_name) { if (!in_array($strasse_name, $indexed)) { $indexed[] = $strasse_name; $geo = OrtGeo::getOrCreate($strasse_name); if (is_null($geo)) { continue; } $return[] = $geo; } } return $return; }