css small fixed for table display

added pagination to concert list

1 files changed, 17 insertions, 4 deletions

diff --git a/includes/concert.php b/includes/concert.php
index 8609694..a67364f 100644
--- a/includes/concert.php
+++ b/includes/concert.php
@@ -208,6 +208,7 @@ if ( !class_exists('GiglogAdmin_Concert') ) {
             ];
 
             $where = [];
+            $lmt=[];
             foreach( $filter as $key => $value ) {
                 switch ($key) {
                     case 'name':
@@ -219,12 +220,20 @@ if ( !class_exists('GiglogAdmin_Concert') ) {
 
                     case 'id':
                     case 'venue_id':
-                        array_push($where, $wpdb->prepare($keymap[$key] . '=%d', $value));
-                        break;
+                    array_push($where, $wpdb->prepare($keymap[$key] . '=%d', $value));
+                    break;
 
                     case 'currentuser':
-                        array_push($where , $wpdb->prepare($keymap[$key] . ' like "%%%s%%"', $value));
-                        break;
+                    array_push($where , $wpdb->prepare($keymap[$key] . ' like "%%%s%%"', $value));
+                    break;
+
+                    case 'offset':
+                    array_push($lmt ,  $value);
+                    break;
+
+                    case 'recperpage':
+                    array_push($lmt ,  $value);
+                    break;
                 }
             }
 
@@ -234,6 +243,10 @@ if ( !class_exists('GiglogAdmin_Concert') ) {
 
             $query.= ' ORDER BY wpgconcert_date';
 
+            if ( ! empty( $lmt ) ) {
+                $query .= ' LIMIT ' . implode(',  ', $lmt);
+            }
+
             $results  = $wpdb->get_results($query);
 
             return array_map(function($c) { return new GiglogAdmin_Concert($c); }, $results);