From 1ceb9d3a96534f327fa59694c463c258040fe7fe Mon Sep 17 00:00:00 2001
From: AndreaChirulescu <andrea.chirulescu@gmail.com>
Date: Wed, 9 Feb 2022 19:55:39 +0100
Subject: css small fixed for table display added pagination to concert list

---
 includes/admin/views/_concerts_table.php    | 188 +++++++++++++++++-----------
 includes/admin/views/_edit_concert_form.php |   3 +-
 includes/concert.php                        |  21 +++-
 includes/css/main.css                       |   7 --
 4 files changed, 133 insertions(+), 86 deletions(-)

diff --git a/includes/admin/views/_concerts_table.php b/includes/admin/views/_concerts_table.php
index a7d9074..2c72cf2 100644
--- a/includes/admin/views/_concerts_table.php
+++ b/includes/admin/views/_concerts_table.php
@@ -26,7 +26,7 @@ if (!class_exists("GiglogAdmin_ConcertsTable"))
         public function render(): string
         {
             return $this->render_filters()
-                . $this->render_concerts_table();
+            . $this->render_concerts_table();
         }
 
         private function render_concerts_table() : string
@@ -47,6 +47,20 @@ if (!class_exists("GiglogAdmin_ConcertsTable"))
             }
             $content .= '</tr>';
 
+            //pagination. Change value as needed
+            $total_records_per_page = 10;
+
+            if (isset($_GET['page_no']) && $_GET['page_no']!="") {
+                $page_no = $_GET['page_no'];
+            } else {
+                $page_no = 1;
+            }
+            //calculate OFFSET Value and SET other Variables
+            $offset = ($page_no-1) * $total_records_per_page;
+            $previous_page = $page_no - 1;
+            $next_page = $page_no + 1;
+            $adjacents = "2";
+
             $filter = [];
 
             // Use the submitted "city" if any. Otherwise, use the default/static value.
@@ -66,9 +80,20 @@ if (!class_exists("GiglogAdmin_ConcertsTable"))
 
             $concerts = GiglogAdmin_Concert::find_concerts($filter);
 
+            //get number of pages for pagination
+            $total_records = count($concerts);
+            $total_no_of_pages = ceil($total_records / $total_records_per_page);
+            $second_last = $total_no_of_pages - 1; // total pages minus 1
+
+            $filter['offset'] =  $offset;
+            $filter['recperpage'] =  $total_records_per_page;
+
+            $concertsp = GiglogAdmin_Concert::find_concerts($filter);
+
+
             $lastType = '';
 
-            foreach ( $concerts AS $concert ) {
+            foreach ( $concertsp AS $concert ) {
                 $content .= '<tr class="assignitr">';
 
                 if ($lastType != '' && $lastType !=  $concert->venue()->city()) {
@@ -106,24 +131,39 @@ if (!class_exists("GiglogAdmin_ConcertsTable"))
 
                     if (current_user_can('administrator')) {
                         $content .= '<td  class="adminbuttons">'
-                            . $this->adminactions($concert)
-                            . '</td>';
+                        . $this->adminactions($concert)
+                        . '</td>';
                     }
                 }
                 $content .= '</tr>';
                 $lastType = $concert->venue()->city();
             }
             $content .= '</table></div>';
+            //  $content .='<div style="padding: 10px 20px 0px; border-top: dotted 1px #CCC;"><strong>Page '.$page_no.' of '.$total_no_of_pages.'</strong></div>';
+
+            $content .=' <ul class="cpagination">';
+            if($page_no > 1){ $content.= "<span><a href='?page_no=1'>First Page - </a></span>"; }
+            $content .="<span "; if($page_no <= 1){ $content .="class='disabled'"; }
+            $content.=">  ";
+            if($page_no > 1){$content.= " <a href='?page_no=".$previous_page."' >Previous - </a></span>";}
+            $content .= "<span";
+            if($page_no >= $total_no_of_pages){ $content .="class='disabled'";}
+            $content.="> ";
+            if($page_no < $total_no_of_pages) { $content .= ' <a href="?page_no='.$next_page.'"> Next - </a>  ';}
+            $content .= "</span>";
+            if($page_no < $total_no_of_pages){
+                $content .= "<span><a href='?page_no=".$total_no_of_pages."'>Last Page </a></span>";}
+                $content .="</ul>";
+
+                // return the table
+                return $content;
+            }
 
-            // return the table
-            return $content;
-        }
-
-        private function render_filters() : string
-        {
-            $cty = filter_input(INPUT_POST, 'selectcity', FILTER_SANITIZE_SPECIAL_CHARS);
+            private function render_filters() : string
+            {
+                $cty = filter_input(INPUT_POST, 'selectcity', FILTER_SANITIZE_SPECIAL_CHARS);
 
-            $select = '<p><form method="POST" action="" class="filterclass">FILTER DATA:'
+                $select = '<p><form method="POST" action="" class="filterclass">FILTER DATA:  '
                 . \EternalTerror\ViewHelpers\select_field(
                     "selectcity",
                     array_map(fn($city) => [$city, $city], GiglogAdmin_Venue::all_cities()),
@@ -131,90 +171,90 @@ if (!class_exists("GiglogAdmin_ConcertsTable"))
                     "Select city...");
 
 
-                if ( !empty($cty) ) {
-                    //second drop down for venue
-                    $select .= \EternalTerror\ViewHelpers\select_field(
-                        "selectvenue",
-                        array_map(
-                            fn($venue) => [$venue->id(), $venue->name()],
-                            GiglogAdmin_Venue::venues_in_city($cty)
-                        ),
-                        filter_input(INPUT_POST, 'selectvenue', FILTER_SANITIZE_SPECIAL_CHARS),
-                        "Select venue...");
-                    }
-                    if(is_admin()) {
-                        //option to select own concerts only
-                        $select .= '<input name="ownconcerts" class="ownconc" type="checkbox" value="1"'
+                    if ( !empty($cty) ) {
+                        //second drop down for venue
+                        $select .= \EternalTerror\ViewHelpers\select_field(
+                            "selectvenue",
+                            array_map(
+                                fn($venue) => [$venue->id(), $venue->name()],
+                                GiglogAdmin_Venue::venues_in_city($cty)
+                            ),
+                            filter_input(INPUT_POST, 'selectvenue', FILTER_SANITIZE_SPECIAL_CHARS),
+                            "Select venue...");
+                        }
+                        if(is_admin()) {
+                            //option to select own concerts only
+                            $select .= '<input name="ownconcerts" class="ownconc" type="checkbox" value="1"'
                             . checked(isset($_POST['ownconcerts']) ? $_POST['ownconcerts'] : false)
                             . '><label for="ownconcerts">Show own concerts only</label>';
-                    }
-                    $select .= '<input class="applybutton" type="submit" value="Apply Filters"></form></p>';
+                        }
+                        $select .= '<input class="applybutton" type="submit" value="Apply Filters"></form></p>';
 
-                    return $select;
-                }
+                        return $select;
+                    }
 
-                private function adminactions( GiglogAdmin_Concert $concert ) : string
-                {
-                    return
+                    private function adminactions( GiglogAdmin_Concert $concert ) : string
+                    {
+                        return
                         '<form class="adminactions" method="POST" action="">'
                         . '<input type="hidden" name="cid" value="' . $concert->id() .  '" />'
                         . \EternalTerror\ViewHelpers\select_field(
                             'selectstatus',
                             array_map(fn($i) => [ $i, self::STATUS_LABELS[$i] ], range(1, count(self::STATUS_LABELS) - 1)),
                             $concert->status())
-                        . '<input type="submit" value="SetStatus">'
-                        . '<input type="submit" name ="edit" value="EDIT">'
-                        . '</form>';
-                    }
-
-                    /**
-                    * Display a mark on the concert if it is new.
-                    * I.e. imported/created within the last ten days.
-                    *
-                    * @return null|string
-                    */
-                    private function mark_new_concert(GiglogAdmin_Concert $concert) : string
-                    {
-                        $now = new DateTime();
-                        $new_entry = $now->diff($concert->created())->days <= 10;
-                        if ($new_entry) {
-                            return '<span style="color:green">NEW</span>';
+                            . '<input type="submit" value="SetStatus">'
+                            . '<input type="submit" name ="edit" value="EDIT">'
+                            . '</form>';
                         }
-                        else {
-                            return '';
+
+                        /**
+                        * Display a mark on the concert if it is new.
+                        * I.e. imported/created within the last ten days.
+                        *
+                        * @return null|string
+                        */
+                        private function mark_new_concert(GiglogAdmin_Concert $concert) : string
+                        {
+                            $now = new DateTime();
+                            $new_entry = $now->diff($concert->created())->days <= 10;
+                            if ($new_entry) {
+                                return '<span style="color:green">NEW</span>';
+                            }
+                            else {
+                                return '';
+                            }
                         }
-                    }
 
-                    private function assign_role_for_user_form(string $role, GiglogAdmin_Concert $concert) : ?string
-                    {
-                        $roles = $concert->roles();
-                        $assigned_user = array_key_exists($role, $roles) ? $roles[$role] : NULL;
+                        private function assign_role_for_user_form(string $role, GiglogAdmin_Concert $concert) : ?string
+                        {
+                            $roles = $concert->roles();
+                            $assigned_user = array_key_exists($role, $roles) ? $roles[$role] : NULL;
 
-                        //first check if current slot is taken by current user
-                        if ( $assigned_user == $this->username ) {
-                            $f = '<form class="unassign_concert" method="POST" action="">'
+                            //first check if current slot is taken by current user
+                            if ( $assigned_user == $this->username ) {
+                                $f = '<form class="unassign_concert" method="POST" action="">'
                                 . '  <input type="hidden" name="cid" value="' . $concert->id() . '" />'
                                 . '  <input type="hidden" name="pid" value="' . $role . '" />'
                                 . '  <input type="submit" name="unassignitem" value=""/>'
                                 . '</form>';
-                        }
-                        elseif ( $assigned_user ) { //check if slot is taken by another user
-                            $f = '<span class="takenby">Taken</span>'
-                            . '<div class="takenby">Taken by ' . $assigned_user . '</div>';
-                        }
-                        elseif ( array_search($this->username, $roles) ) {
-                            // other slots for this concert are taken by user
-                            $f = '<span class="taken_by_self">-</span>';
-                        }
-                        else { //not taken by anyone
-                            $f = '<form class="assign_concert" method="POST" action="">'
+                            }
+                            elseif ( $assigned_user ) { //check if slot is taken by another user
+                                $f = '<span class="takenby">Taken</span>'
+                                . '<div class="takenby">Taken by ' . $assigned_user . '</div>';
+                            }
+                            elseif ( array_search($this->username, $roles) ) {
+                                // other slots for this concert are taken by user
+                                $f = '<span class="taken_by_self">-</span>';
+                            }
+                            else { //not taken by anyone
+                                $f = '<form class="assign_concert" method="POST" action="">'
                                 . '  <input type="hidden" name="cid" value="' . $concert->id() . '" />'
                                 . '  <input type="hidden" name="pid" value="' . $role. '" />'
                                 . '  <input  type="submit" name="assignitem" value=""/>'
                                 . '</form>';
-                        }
+                            }
 
-                        return $f;
+                            return $f;
+                        }
                     }
                 }
-            }
diff --git a/includes/admin/views/_edit_concert_form.php b/includes/admin/views/_edit_concert_form.php
index 7b0164e..6e4f5e5 100644
--- a/includes/admin/views/_edit_concert_form.php
+++ b/includes/admin/views/_edit_concert_form.php
@@ -52,7 +52,8 @@ if (!class_exists("GiglogAdmin_EditConcertForm"))
                 .'<input type="hidden" name="pid" value="' .$c->id(). '" />'
                 .'<label for="cname">Concert Name:</label><textarea id="cname" name="cname" value="'.$c->cname().'">'.$c->cname().'</textarea><br>'
                 .'<label for="venue">Venue:</label>' . $this->get_venue_selector($c->venue()) . '<br>'
-                .'<label for="cdate">Date:</label><input type="date" id="cdate" name="cdate" value="'.$c->cdate().'"><br>'
+                //date has to be formatted else it is not red in the date field of html form
+                .'<label for="cdate">Date:</label><input type="date" id="cdate" name="cdate" value="'.strftime('%d/%m/%Y',strtotime($c->cdate())).'"><br>'
                 .'<label for="ticket">Tickets:</label><input type="text" id="ticket" name="ticket" value="'.$c->tickets().'"><br>'
                     .'<label for="eventurl">Event link:</label><input type="text" id="eventurl" name="eventurl" value="'.$c->eventlink().'"><br>'
                 .'</fieldset>';
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);
diff --git a/includes/css/main.css b/includes/css/main.css
index 9bb7098..0f166c0 100644
--- a/includes/css/main.css
+++ b/includes/css/main.css
@@ -81,13 +81,6 @@ span.takenbyself
     line-height: 2.5em;
 }
 
-table.assignit
-
-{
-      white-space: nowrap;
-      overflow: hidden;
-      border-collapse:collapse;
-}
 
 input[name="unassignitem"]
 
-- 
cgit v1.2.3