From 88244b19533163564098057c75952deffc7dc13e Mon Sep 17 00:00:00 2001
From: AndreaChirulescu <andrea.chirulescu@gmail.com>
Date: Sat, 4 Sep 2021 21:36:25 +0200
Subject: Fixed a call to city() method in concert.php It needed ->venue->city

Added order by concert date in concert list
---
 includes/admin/views/giglog_admin_page.php | 2 +-
 includes/concert.php                       | 2 ++
 2 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/includes/admin/views/giglog_admin_page.php b/includes/admin/views/giglog_admin_page.php
index dfea3fd..ce0031c 100644
--- a/includes/admin/views/giglog_admin_page.php
+++ b/includes/admin/views/giglog_admin_page.php
@@ -223,7 +223,7 @@ if ( !class_exists( 'GiglogAdmin_AdminPage' ) ) {
                 $content .= '<tr class="assignitr">';
 
                 if ($lastType != '' && $lastType !=  $concert->venue()->city()) {
-                    $content .= '<td>' . $concert->city() . '</td></tr><tr>';
+                    $content .= '<td>' . $concert->venue()->city() . '</td></tr><tr>';
                 }
 
                 if  ($lastType == '' ) {
diff --git a/includes/concert.php b/includes/concert.php
index a533679..8210b2d 100644
--- a/includes/concert.php
+++ b/includes/concert.php
@@ -85,6 +85,7 @@ if ( !class_exists('GiglogAdmin_Concert') ) {
 
             $query = self::BASE_QUERY
                 . 'WHERE ' . $wpdb->prepare('wpg_concerts.id = %d', $id);
+            $query.= ' ORDER BY wpgconcert_date';
 
             $results  = $wpdb->get_results($query);
 
@@ -219,6 +220,7 @@ if ( !class_exists('GiglogAdmin_Concert') ) {
             if ( ! empty( $where ) ) {
                 $query .= 'WHERE ' . implode(' and ', $where);
             }
+            $query.= ' ORDER BY wpgconcert_date';
 
             $results  = $wpdb->get_results($query);
 
-- 
cgit v1.2.3