From 61c48191a8e9ab757be4bf845072f4cfdbf9075f Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Sun, 9 May 2021 22:12:21 +0200 Subject: Method to find concerts at given venue --- includes/concert.php | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'includes/concert.php') diff --git a/includes/concert.php b/includes/concert.php index c773c12..050c924 100644 --- a/includes/concert.php +++ b/includes/concert.php @@ -185,6 +185,20 @@ if ( !class_exists('GiglogAdmin_Concert') ) { return array_map(function($c) { return new GiglogAdmin_Concert($c); }, $results); } + public static function find_concerts_at(GiglogAdmin_Venue $venue) : array + { + global $wpdb; + + $query = 'SELECT wpg_concerts.*, wpg_venues.wpgvenue_name, wpg_venues.wpgvenue_city ' + . 'FROM wpg_concerts ' + . 'INNER JOIN wpg_venues ON wpg_concerts.venue = wpg_venues.id ' + . 'WHERE wpg_concerts.venue = ' . $wpdb->prepare('%d', $venue->id()); + + $results = $wpdb->get_results($query); + + return array_map(function($c) { return new GiglogAdmin_Concert($c); }, $results); + } + public function save(): void { global $wpdb; -- cgit v1.2.3