diff options
| author | AndreaChirulescu <andrea.chirulescu@gmail.com> | 2021-04-08 23:13:42 +0200 |
|---|---|---|
| committer | AndreaChirulescu <andrea.chirulescu@gmail.com> | 2021-04-08 23:13:42 +0200 |
| commit | 7dfafd9381435df08b1467b18f27fb4b2e7251e0 (patch) | |
| tree | a27ff6a99326c22e4ff2d87384192ad1206baf3e /includes/venue.php | |
| parent | b6cdf32a16c06219628defb680ff3c4ffc7fc88c (diff) | |
| download | gigologadmin-7dfafd9381435df08b1467b18f27fb4b2e7251e0.tar.gz gigologadmin-7dfafd9381435df08b1467b18f27fb4b2e7251e0.tar.bz2 gigologadmin-7dfafd9381435df08b1467b18f27fb4b2e7251e0.zip | |
Beginning of a very rudimentary form for adding/editing concerts
Diffstat (limited to 'includes/venue.php')
| -rw-r--r-- | includes/venue.php | 134 |
1 files changed, 72 insertions, 62 deletions
diff --git a/includes/venue.php b/includes/venue.php index de144fd..b742a17 100644 --- a/includes/venue.php +++ b/includes/venue.php @@ -1,62 +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 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);
+ }
+ }
+}
|