summaryrefslogtreecommitdiffstats
path: root/includes/venue.php
diff options
context:
space:
mode:
authorAndreaChirulescu <andrea.chirulescu@gmail.com>2021-04-09 16:53:04 +0200
committerAndreaChirulescu <andrea.chirulescu@gmail.com>2021-04-09 16:53:04 +0200
commiteb7e2ac02d652ac1ec9c842b14e1efbc27e852fc (patch)
treef1cb187d07f00f2ebbf12c7d900fb3d7a4c91157 /includes/venue.php
parent7dfafd9381435df08b1467b18f27fb4b2e7251e0 (diff)
downloadgigologadmin-eb7e2ac02d652ac1ec9c842b14e1efbc27e852fc.tar.gz
gigologadmin-eb7e2ac02d652ac1ec9c842b14e1efbc27e852fc.tar.bz2
gigologadmin-eb7e2ac02d652ac1ec9c842b14e1efbc27e852fc.zip
Beuatified files after using editconfig with notepad++
Diffstat (limited to 'includes/venue.php')
-rw-r--r--includes/venue.php144
1 files changed, 72 insertions, 72 deletions
diff --git a/includes/venue.php b/includes/venue.php
index b742a17..4951d6b 100644
--- a/includes/venue.php
+++ b/includes/venue.php
@@ -1,72 +1,72 @@
-<?php
-/*
- * Copyright (C) 2021 Harald Eilertsen, Andrea Chirulescu
- *
- * This program is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Affero General Public License as
- * published by the Free Software Foundation, either version 3 of the
- * License, or (at your option) any later version.
- *
- * This program is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- * GNU Affero General Public License for more details.
- *
- * You should have received a copy of the GNU Affero General Public License
- * along with this program. If not, see <http://www.gnu.org/licenses/>.
- */
-
-if ( !class_exists('GiglogAdmin_Venue') ) {
- class GiglogAdmin_Venue
- {
- static function create($name)
- {
- global $wpdb;
-
- $wpdb->insert('wpg_venues', array(
- 'id' => '',
- 'wpgvenue_name' => $name
- ));
-
- return $wpdb->insert_id;
- }
-
- static function find_or_create($name)
- {
- global $wpdb;
-
- $venuesql = 'SELECT id FROM wpg_venues WHERE upper(wpgvenue_name)="' . $name . '"';
- $results = $wpdb->get_results($venuesql);
-
- return $results ? $results[0]->id : GiglogAdmin_Venue::create($name);
- }
-
- static function all_cities()
- {
- global $wpdb;
- $results = $wpdb->get_results('select distinct wpgvenue_city from wpg_venues');
-
- return array_map(function ($r) { return $r->wpgvenue_city; }, $results);
- }
-
- static function all_venues()
- {
- global $wpdb;
-
- $results = $wpdb->get_results("select id, CONCAT( IFNULL(wpgvenue_name,''),'-',IFNULL(wpgvenue_city,'')) as vname from wpg_venues");
-
- return ($results);
- }
-
-
- static function venues_in_city($city)
- {
- global $wpdb;
- $q = $wpdb->prepare(
- "select id, wpgvenue_name from wpg_venues where wpgvenue_city=?", $city);
- $results = $wpdb->get_results($q);
-
- return array_map(function ($r) { return [$r->id, $r->wpgvenue_name]; }, $results);
- }
- }
-}
+<?php
+/*
+ * Copyright (C) 2021 Harald Eilertsen, Andrea Chirulescu
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as
+ * published by the Free Software Foundation, either version 3 of the
+ * License, or (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with this program. If not, see <http://www.gnu.org/licenses/>.
+ */
+
+if ( !class_exists('GiglogAdmin_Venue') ) {
+ class GiglogAdmin_Venue
+ {
+ static function create($name)
+ {
+ global $wpdb;
+
+ $wpdb->insert('wpg_venues', array(
+ 'id' => '',
+ 'wpgvenue_name' => $name
+ ));
+
+ return $wpdb->insert_id;
+ }
+
+ static function find_or_create($name)
+ {
+ global $wpdb;
+
+ $venuesql = 'SELECT id FROM wpg_venues WHERE upper(wpgvenue_name)="' . $name . '"';
+ $results = $wpdb->get_results($venuesql);
+
+ return $results ? $results[0]->id : GiglogAdmin_Venue::create($name);
+ }
+
+ static function all_cities()
+ {
+ global $wpdb;
+ $results = $wpdb->get_results('select distinct wpgvenue_city from wpg_venues');
+
+ return array_map(function ($r) { return $r->wpgvenue_city; }, $results);
+ }
+
+ static function all_venues()
+ {
+ global $wpdb;
+
+ $results = $wpdb->get_results("select id, CONCAT( IFNULL(wpgvenue_name,''),'-',IFNULL(wpgvenue_city,'')) as vname from wpg_venues");
+
+ return ($results);
+ }
+
+
+ static function venues_in_city($city)
+ {
+ global $wpdb;
+ $q = $wpdb->prepare(
+ "select id, wpgvenue_name from wpg_venues where wpgvenue_city=?", $city);
+ $results = $wpdb->get_results($q);
+
+ return array_map(function ($r) { return [$r->id, $r->wpgvenue_name]; }, $results);
+ }
+ }
+}