summaryrefslogtreecommitdiff
path: root/app/Location.php
diff options
context:
space:
mode:
Diffstat (limited to 'app/Location.php')
-rw-r--r--app/Location.php397
1 files changed, 214 insertions, 183 deletions
diff --git a/app/Location.php b/app/Location.php
index 2d8a229aa5..f5d49e872d 100644
--- a/app/Location.php
+++ b/app/Location.php
@@ -25,200 +25,231 @@ use stdClass;
*
* @package Fisharebest\Webtrees
*/
-class Location {
+class Location
+{
- /**
- * @var stdClass $record
- */
- protected $record;
+ /**
+ * @var stdClass $record
+ */
+ protected $record;
- /**
- * Location constructor.
- *
- * @param string $gedcomName
- * @param array $record
- *
- * @throws Exception
- */
- public function __construct($gedcomName, $record = []) {
- $tmp = $this->getRecordFromName($gedcomName);
- if ($tmp !== null) {
- $this->record = $tmp;
- } elseif (!empty($record)) {
- $this->record = (object) $record;
- } else {
- $this->record = (object) [
- 'fqpn' => '',
- 'pl_id' => 0,
- 'pl_parent_id' => 0,
- 'pl_level' => null,
- 'pl_place' => '',
- 'pl_long' => null,
- 'pl_lati' => null,
- 'pl_zoom' => null,
- 'pl_icon' => null,
- ];
- }
- }
+ /**
+ * Location constructor.
+ *
+ * @param string $gedcomName
+ * @param array $record
+ *
+ * @throws Exception
+ */
+ public function __construct($gedcomName, $record = [])
+ {
+ $tmp = $this->getRecordFromName($gedcomName);
+ if ($tmp !== null) {
+ $this->record = $tmp;
+ } elseif (!empty($record)) {
+ $this->record = (object)$record;
+ } else {
+ $this->record = (object)[
+ 'fqpn' => '',
+ 'pl_id' => 0,
+ 'pl_parent_id' => 0,
+ 'pl_level' => null,
+ 'pl_place' => '',
+ 'pl_long' => null,
+ 'pl_lati' => null,
+ 'pl_zoom' => null,
+ 'pl_icon' => null,
+ ];
+ }
+ }
- /**
- * @return bool
- */
- public function knownLatLon() {
- return ($this->record->pl_lati && $this->record->pl_long);
- }
+ /**
+ * @return bool
+ */
+ public function knownLatLon()
+ {
+ return ($this->record->pl_lati && $this->record->pl_long);
+ }
- /**
- * @param string $format
- *
- * @return string|float
- */
- public function getLat($format = 'signed') {
- switch ($format) {
- case 'signed':
- return $this->record->pl_lati ?
- (float) strtr($this->record->pl_lati, ['N' => '', 'S' => '-', ',' => '.']) :
- $this->record->pl_lati;
- default:
- return $this->record->pl_lati;
- }
- }
+ /**
+ * @param string $format
+ *
+ * @return string|float
+ */
+ public function getLat($format = 'signed')
+ {
+ switch ($format) {
+ case 'signed':
+ return $this->record->pl_lati ?
+ (float)strtr($this->record->pl_lati, [
+ 'N' => '',
+ 'S' => '-',
+ ',' => '.',
+ ]) :
+ $this->record->pl_lati;
+ default:
+ return $this->record->pl_lati;
+ }
+ }
- /**
- * @param string $format
- *
- * @return string|float
- */
- public function getLon($format = 'signed') {
- switch ($format) {
- case 'signed':
- return $this->record->pl_long ?
- (float) strtr($this->record->pl_long, ['E' => '', 'W' => '-', ',' => '.']) :
- $this->record->pl_long;
- default:
- return $this->record->pl_long;
- }
- }
+ /**
+ * @param string $format
+ *
+ * @return string|float
+ */
+ public function getLon($format = 'signed')
+ {
+ switch ($format) {
+ case 'signed':
+ return $this->record->pl_long ?
+ (float)strtr($this->record->pl_long, [
+ 'E' => '',
+ 'W' => '-',
+ ',' => '.',
+ ]) :
+ $this->record->pl_long;
+ default:
+ return $this->record->pl_long;
+ }
+ }
- /**
- * @return array
- */
- public function getLatLonJSArray() {
- return [$this->getLat('signed'), $this->getLon('signed')];
- }
+ /**
+ * @return array
+ */
+ public function getLatLonJSArray()
+ {
+ return [
+ $this->getLat('signed'),
+ $this->getLon('signed'),
+ ];
+ }
- /**
- * GeoJSON requires the parameters to be in the order longitude, latitude
- *
- * @return array
- */
- public function getGeoJsonCoords() {
- return [$this->getLon('signed'), $this->getLat('signed')];
- }
+ /**
+ * GeoJSON requires the parameters to be in the order longitude, latitude
+ *
+ * @return array
+ */
+ public function getGeoJsonCoords()
+ {
+ return [
+ $this->getLon('signed'),
+ $this->getLat('signed'),
+ ];
+ }
- /**
- * @return string
- */
- public function getId() {
- return $this->record->pl_id;
- }
+ /**
+ * @return string
+ */
+ public function getId()
+ {
+ return $this->record->pl_id;
+ }
- /**
- * @return string
- */
- public function getLevel() {
- return $this->record->pl_level;
- }
+ /**
+ * @return string
+ */
+ public function getLevel()
+ {
+ return $this->record->pl_level;
+ }
- /**
- * @return bool
- */
- public function isValid() {
- return $this->record->pl_id !== 0;
- }
+ /**
+ * @return bool
+ */
+ public function isValid()
+ {
+ return $this->record->pl_id !== 0;
+ }
- /**
- * @return string
- */
- public function getPlace() {
- return $this->record->pl_place;
- }
+ /**
+ * @return string
+ */
+ public function getPlace()
+ {
+ return $this->record->pl_place;
+ }
- /**
- * @return string|null
- */
- public function getZoom() {
- return $this->record->pl_zoom;
- }
+ /**
+ * @return string|null
+ */
+ public function getZoom()
+ {
+ return $this->record->pl_zoom;
+ }
- /**
- * @return string|null
- */
- public function getIcon() {
- return $this->record->pl_icon;
- }
+ /**
+ * @return string|null
+ */
+ public function getIcon()
+ {
+ return $this->record->pl_icon;
+ }
- /**
- * @return stdClass
- */
- public function getRecord() {
- return $this->record;
- }
+ /**
+ * @return stdClass
+ */
+ public function getRecord()
+ {
+ return $this->record;
+ }
- /**
- * @throws Exception
- */
- public function add() {
- $this->record->pl_id = Database::prepare("SELECT IFNULL(MAX(pl_id)+1, 1) FROM `##placelocation`")
- ->execute()
- ->fetchOne();
+ /**
+ * @throws Exception
+ */
+ public function add()
+ {
+ $this->record->pl_id = Database::prepare("SELECT IFNULL(MAX(pl_id)+1, 1) FROM `##placelocation`")
+ ->execute()
+ ->fetchOne();
- Database::prepare(
- "INSERT INTO `##placelocation` (pl_id, pl_parent_id, pl_level, pl_place, pl_long, pl_lati, pl_zoom, pl_icon) VALUES(:id, :parent_id, :level, :place, :long, :lati, :zoom, :icon)"
- )->execute(
- [
- 'id' => $this->record->pl_id,
- 'parent_id' => $this->record->pl_parent_id,
- 'level' => $this->record->pl_level,
- 'place' => $this->record->pl_place,
- 'long' => $this->record->pl_long ?? null,
- 'lati' => $this->record->pl_lati ?? null,
- 'zoom' => $this->record->pl_zoom ?? null,
- 'icon' => $this->record->pl_icon ?? null,
- ]
- );
+ Database::prepare(
+ "INSERT INTO `##placelocation` (pl_id, pl_parent_id, pl_level, pl_place, pl_long, pl_lati, pl_zoom, pl_icon) VALUES(:id, :parent_id, :level, :place, :long, :lati, :zoom, :icon)"
+ )->execute(
+ [
+ 'id' => $this->record->pl_id,
+ 'parent_id' => $this->record->pl_parent_id,
+ 'level' => $this->record->pl_level,
+ 'place' => $this->record->pl_place,
+ 'long' => $this->record->pl_long ?? null,
+ 'lati' => $this->record->pl_lati ?? null,
+ 'zoom' => $this->record->pl_zoom ?? null,
+ 'icon' => $this->record->pl_icon ?? null,
+ ]
+ );
- return $this->record->pl_id;
- }
+ return $this->record->pl_id;
+ }
- /**
- * @param stdClass $new_data
- *
- * @throws Exception
- */
- public function update(stdClass $new_data) {
- Database::prepare(
- "UPDATE `##placelocation` SET pl_lati=:lati, pl_long=:long, pl_zoom=:zoom, pl_icon=:icon WHERE pl_id=:id"
- )
- ->execute([
- 'lati' => $new_data->pl_lati ?? $this->record->pl_lati,
- 'long' => $new_data->pl_long ?? $this->record->pl_long,
- 'zoom' => $new_data->pl_zoom ?? $this->record->pl_zoom,
- 'icon' => $new_data->pl_icon ?? $this->record->pl_icon,
- 'id' => $this->record->pl_id,
- ]);
- }
+ /**
+ * @param stdClass $new_data
+ *
+ * @throws Exception
+ */
+ public function update(stdClass $new_data)
+ {
+ Database::prepare(
+ "UPDATE `##placelocation` SET pl_lati=:lati, pl_long=:long, pl_zoom=:zoom, pl_icon=:icon WHERE pl_id=:id"
+ )
+ ->execute([
+ 'lati' => $new_data->pl_lati ?? $this->record->pl_lati,
+ 'long' => $new_data->pl_long ?? $this->record->pl_long,
+ 'zoom' => $new_data->pl_zoom ?? $this->record->pl_zoom,
+ 'icon' => $new_data->pl_icon ?? $this->record->pl_icon,
+ 'id' => $this->record->pl_id,
+ ]);
+ }
- /**
- * @param string $gedcomName
- *
- * @return null|stdClass
- * @throws Exception
- */
- private function getRecordFromName($gedcomName) {
+ /**
+ * @param string $gedcomName
+ *
+ * @return null|stdClass
+ * @throws Exception
+ */
+ private function getRecordFromName($gedcomName)
+ {
- return Database::prepare(
- "
+ return Database::prepare(
+ "
SELECT
CONCAT_WS(:separator, t1.pl_place, t2.pl_place, t3.pl_place, t4.pl_place, t5.pl_place, t6.pl_place, t7.pl_place, t8.pl_place) AS fqpn,
t1.pl_level, t1.pl_place, t1.pl_id, t1.pl_parent_id, t1.pl_lati, t1.pl_long, t1.pl_zoom, t1.pl_icon
@@ -232,13 +263,13 @@ class Location {
LEFT JOIN `##placelocation` AS t8 ON t7.pl_parent_id = t8.pl_id
HAVING fqpn=:gedcomName;
"
- )
- ->execute(
- [
- 'separator' => Place::GEDCOM_SEPARATOR,
- 'gedcomName' => $gedcomName,
- ]
- )
- ->fetchOneRow();
- }
+ )
+ ->execute(
+ [
+ 'separator' => Place::GEDCOM_SEPARATOR,
+ 'gedcomName' => $gedcomName,
+ ]
+ )
+ ->fetchOneRow();
+ }
}
generated by cgit v1.3 (git 2.53.0) at 2026-07-06 09:39:45 +0000