. */ declare(strict_types=1); namespace Fisharebest\Webtrees; use Fisharebest\Webtrees\Services\GedcomService; use Illuminate\Database\Capsule\Manager as DB; use Illuminate\Support\Collection; use stdClass; use function app; use function max; use function min; use function preg_split; /** * Class PlaceLocation */ class PlaceLocation { /** @var string e.g. "Westminster, London, England" */ private $location_name; /** @var Collection|string[] The parts of a location name, e.g. ["Westminster", "London", "England"] */ private $parts; /** * Create a place-location. * * @param string $location_name */ public function __construct(string $location_name) { // Ignore any empty parts in location names such as "Village, , , Country". $this->parts = (new Collection(preg_split(Gedcom::PLACE_SEPARATOR_REGEX, $location_name))) ->filter(); // Rebuild the location name in the correct format. $this->location_name = $this->parts->implode(Gedcom::PLACE_SEPARATOR); } /** * Get the higher level location. * * @return PlaceLocation */ public function parent(): PlaceLocation { return new self($this->parts->slice(1)->implode(Gedcom::PLACE_SEPARATOR)); } /** * The database row that contains this location. * Note that due to database collation, both "Quebec" and "Québec" will share the same row. * * @return int */ public function id(): int { return app('cache.array')->remember('location-' . $this->location_name, function () { // The "top-level" location won't exist in the database. if ($this->parts->isEmpty()) { return 0; } $parent_location_id = $this->parent()->id(); $location_id = (int) DB::table('placelocation') ->where('pl_place', '=', $this->parts->first()) ->where('pl_parent_id', '=', $parent_location_id) ->value('pl_id'); if ($location_id === 0) { $location = $this->parts->first(); $location_id = 1 + (int) DB::table('placelocation')->max('pl_id'); DB::table('placelocation')->insert([ 'pl_id' => $location_id, 'pl_place' => $location, 'pl_parent_id' => $parent_location_id, 'pl_level' => $this->parts->count() - 1, 'pl_lati' => '', 'pl_long' => '', 'pl_icon' => '', 'pl_zoom' => 2, ]); } return $location_id; }); } /** * Does this location exist in the database? Note that calls to PlaceLocation::id() will * create the row, so this function is only meaningful when called before a call to PlaceLocation::id(). * * @return bool */ public function exists(): bool { $location_id = 0; $this->parts->reverse()->each(static function (string $place) use (&$location_id) { if ($location_id !== null) { $location_id = DB::table('placelocation') ->where('pl_parent_id', '=', $location_id) ->where('pl_place', '=', $place) ->value('pl_id'); } }); return $location_id !== null; } /** * @return stdClass */ private function details(): stdClass { return app('cache.array')->remember('location-details-' . $this->id(), function () { // The "top-level" location won't exist in the database. if ($this->parts->isEmpty()) { return (object) [ 'pl_id' => '0', 'pl_parent_id' => '0', 'pl_level' => null, 'pl_place' => '', 'pl_lati' => null, 'pl_long' => null, 'pl_zoom' => null, 'pl_icon' => null, 'pl_media' => null, ]; } return DB::table('placelocation') ->where('pl_id', '=', $this->id()) ->first(); }); } /** * Latitude of the location. * * @return float */ public function latitude(): float { $gedcom_service = new GedcomService(); return $gedcom_service->readLatitude($this->details()->pl_lati ?? ''); } /** * Latitude of the longitude. * * @return float */ public function longitude(): float { $gedcom_service = new GedcomService(); return $gedcom_service->readLongitude($this->details()->pl_long ?? ''); } /** * The icon for the location. * * @return string */ public function icon(): string { return (string) $this->details()->pl_icon; } /** * Zoom level for the location. * * @return int */ public function zoom(): int { return (int) $this->details()->pl_zoom; } /** * @return string */ public function locationName(): string { return (string) $this->parts->first(); } /** * Find a rectangle that (approximately) encloses this place. * * @return array> */ public function boundingRectangle(): array { $latitude = $this->latitude(); $longitude = $this->longitude(); // No co-ordinates for this place? Try the parent place. $tmp = $this; while ($latitude === 0.0 && $longitude === 0.0 && $tmp->id() !== 0) { $tmp = $tmp->parent(); $latitude = $tmp->latitude(); $longitude = $tmp->longitude(); } // Show this number of degrees around the centre. if ($latitude === 0.0 && $longitude === 0.0 || $this->id() === 0) { // World $degrees = 180.0; } elseif ($this->parts->count() === 1) { // Countries $degrees = 10.0; } elseif ($this->parts->count() === 2) { // Regions $degrees = 3.0; } else { // Towns, cities and villages $degrees = 1.0; } return [ [ max($latitude - $degrees, -90.0), max($longitude - $degrees, -180.0), ], [ min($latitude + $degrees, 90.0), min($longitude + $degrees, 180.0), ], ]; } }