summaryrefslogtreecommitdiffstats
path: root/includes/venue.php
diff options
context:
space:
mode:
authorHarald Eilertsen <haraldei@stigmata.localdomain>2021-03-08 21:32:37 +0100
committerHarald Eilertsen <haraldei@stigmata.localdomain>2021-03-08 21:32:37 +0100
commit3fdbe3e2bcdfb2fa94db65fdd302ae4a143702bd (patch)
tree0fbcbc0b7667b8a8779195fe04f43d0d25dd8a2c /includes/venue.php
parent782e7aea5ad3d866f5b1e93ca202649a527e361b (diff)
downloadgigologadmin-3fdbe3e2bcdfb2fa94db65fdd302ae4a143702bd.tar.gz
gigologadmin-3fdbe3e2bcdfb2fa94db65fdd302ae4a143702bd.tar.bz2
gigologadmin-3fdbe3e2bcdfb2fa94db65fdd302ae4a143702bd.zip
Refactor processing uploads.
Moves all database operations to separate classes for each type of object, bands, venues and concerts. This makes the logic cleaner, and concentrates the db related code to logically distinct parts of the code. This means we no longer need the global access to the $wpdb object from the processing code.
Diffstat (limited to 'includes/venue.php')
-rw-r--r--includes/venue.php52
1 files changed, 52 insertions, 0 deletions
diff --git a/includes/venue.php b/includes/venue.php
new file mode 100644
index 0000000..8edb136
--- /dev/null
+++ b/includes/venue.php
@@ -0,0 +1,52 @@
+<?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);
+ }
+ }
+}