diff options
Diffstat (limited to 'includes/venue.php')
| -rw-r--r-- | includes/venue.php | 139 |
1 files changed, 74 insertions, 65 deletions
diff --git a/includes/venue.php b/includes/venue.php index 3cbf884..b6f9956 100644 --- a/includes/venue.php +++ b/includes/venue.php @@ -4,9 +4,9 @@ // // SPDX-License-Identifier: AGPL-3.0-or-later -if ( !class_exists('GiglogAdmin_Venue') ) { - class GiglogAdmin_Venue - { +if ( ! class_exists( 'GiglogAdmin_Venue' ) ) { + class GiglogAdmin_Venue { + private ?int $id; /** @@ -27,21 +27,19 @@ if ( !class_exists('GiglogAdmin_Venue') ) { * so this constructor can be used to construct the object * directly from the database row. */ - public function __construct(object $attrs) - { - $this->id = isset($attrs->id) ? $attrs->id : NULL; + public function __construct( object $attrs ) { + $this->id = isset( $attrs->id ) ? $attrs->id : null; - if (isset($attrs->wpgvenue_name, $attrs->wpgvenue_city)) { + if ( isset( $attrs->wpgvenue_name, $attrs->wpgvenue_city ) ) { $this->name = $attrs->wpgvenue_name; $this->city = $attrs->wpgvenue_city; - } - else { - error_log('Trying to construct a Venue without a name or a city'); + } else { + error_log( 'Trying to construct a Venue without a name or a city' ); wp_die(); } - $this->address = isset($attrs->wpgvenue_address) ? $attrs->wpgvenue_address : NULL; - $this->webpage = isset($attrs->wpgvenue_webpage) ? $attrs->wpgvenue_webpage : NULL; + $this->address = isset( $attrs->wpgvenue_address ) ? $attrs->wpgvenue_address : null; + $this->webpage = isset( $attrs->wpgvenue_webpage ) ? $attrs->wpgvenue_webpage : null; } /** @@ -50,50 +48,53 @@ if ( !class_exists('GiglogAdmin_Venue') ) { * @param int $id * @return null|self */ - static function get(int $id) : ?self - { + static function get( int $id ) : ?self { global $wpdb; - $query = $wpdb->prepare("SELECT * from {$wpdb->prefix}giglogadmin_venues WHERE id = %d", $id); - $results = $wpdb->get_results($query); + $query = $wpdb->prepare( "SELECT * from {$wpdb->prefix}giglogadmin_venues WHERE id = %d", $id ); + $results = $wpdb->get_results( $query ); - return $results ? new GiglogAdmin_Venue($results[0]) : NULL; + return $results ? new GiglogAdmin_Venue( $results[0] ) : null; } - static function create(string $name, string $city = 'Oslo'): self - { - $venue = new GiglogAdmin_Venue((object) [ - 'wpgvenue_name' => $name, - 'wpgvenue_city' => $city, - ]); + static function create( string $name, string $city = 'Oslo' ): self { + $venue = new GiglogAdmin_Venue( + (object) array( + 'wpgvenue_name' => $name, + 'wpgvenue_city' => $city, + ) + ); $venue->save(); return $venue; } - static function find_or_create(string $name, string $city = 'Oslo'): self - { + static function find_or_create( string $name, string $city = 'Oslo' ): self { global $wpdb; $venuesql = "SELECT * FROM {$wpdb->prefix}giglogadmin_venues " - . $wpdb->prepare("WHERE upper(wpgvenue_name)=upper(%s) and upper(wpgvenue_city)=upper(%s)", $name, $city); + . $wpdb->prepare( 'WHERE upper(wpgvenue_name)=upper(%s) and upper(wpgvenue_city)=upper(%s)', $name, $city ); - $results = $wpdb->get_results($venuesql); + $results = $wpdb->get_results( $venuesql ); - if ($results) { - return new GiglogAdmin_Venue($results[0]); - } - else { - return GiglogAdmin_Venue::create($name, $city); + if ( $results ) { + return new GiglogAdmin_Venue( $results[0] ); + } else { + return self::create( $name, $city ); } } - static function all_cities(): array - { + static function all_cities(): array { global $wpdb; $results = $wpdb->get_results( - "select distinct wpgvenue_city from {$wpdb->prefix}giglogadmin_venues"); - - return array_map(function ($r) { return $r->wpgvenue_city; }, $results); + "select distinct wpgvenue_city from {$wpdb->prefix}giglogadmin_venues" + ); + + return array_map( + function ( $r ) { + return $r->wpgvenue_city; + }, + $results + ); } /** @@ -101,14 +102,19 @@ if ( !class_exists('GiglogAdmin_Venue') ) { * * @psalm-return array<array-key, self> */ - static function all_venues(): array - { + static function all_venues(): array { global $wpdb; $results = $wpdb->get_results( - "select * from {$wpdb->prefix}giglogadmin_venues ORDER BY wpgvenue_name"); - - return array_map(function ($r) { return new GiglogAdmin_Venue($r); }, $results); + "select * from {$wpdb->prefix}giglogadmin_venues ORDER BY wpgvenue_name" + ); + + return array_map( + function ( $r ) { + return new GiglogAdmin_Venue( $r ); + }, + $results + ); } @@ -117,42 +123,45 @@ if ( !class_exists('GiglogAdmin_Venue') ) { * * @psalm-return array<array-key, self> */ - static function venues_in_city(string $city): array - { + static function venues_in_city( string $city ): array { global $wpdb; - $q = $wpdb->prepare("select * from {$wpdb->prefix}giglogadmin_venues where wpgvenue_city=%s", $city) - . " ORDER BY wpgvenue_name"; - $results = $wpdb->get_results($q); - - return array_map(function ($r) { return new GiglogAdmin_Venue($r); }, $results); + $q = $wpdb->prepare( "select * from {$wpdb->prefix}giglogadmin_venues where wpgvenue_city=%s", $city ) + . ' ORDER BY wpgvenue_name'; + $results = $wpdb->get_results( $q ); + + return array_map( + function ( $r ) { + return new GiglogAdmin_Venue( $r ); + }, + $results + ); } - public function save(): void - { + public function save(): void { global $wpdb; - $wpdb->insert($wpdb->prefix . 'giglogadmin_venues', array( - 'id' => '', - 'wpgvenue_name' => $this->name, - 'wpgvenue_city' => $this->city, - )); + $wpdb->insert( + $wpdb->prefix . 'giglogadmin_venues', + array( + 'id' => '', + 'wpgvenue_name' => $this->name, + 'wpgvenue_city' => $this->city, + ) + ); $this->id = $wpdb->insert_id; } - public function id() - { - return $this->id; + public function id() { + return $this->id; } - public function name() - { - return $this->name; + public function name() { + return $this->name; } - public function city() - { - return $this->city; + public function city() { + return $this->city; } } } |