diff options
Diffstat (limited to 'includes')
| -rw-r--r-- | includes/class-giglogadmin-concert.php | 26 | ||||
| -rw-r--r-- | includes/giglogadmin-shortcodes.php | 20 | ||||
| -rw-r--r-- | includes/templates/giglogadmin-concerts-table.php | 95 |
3 files changed, 98 insertions, 43 deletions
diff --git a/includes/class-giglogadmin-concert.php b/includes/class-giglogadmin-concert.php index a470617..c6223cb 100644 --- a/includes/class-giglogadmin-concert.php +++ b/includes/class-giglogadmin-concert.php @@ -211,6 +211,8 @@ if ( ! class_exists( 'GiglogAdmin_Concert' ) ) { $where = array(); $offset = 0; $limit = 15; + $page = null; + foreach ( $filter as $key => $value ) { switch ( $key ) { case 'name': @@ -230,6 +232,10 @@ if ( ! class_exists( 'GiglogAdmin_Concert' ) ) { array_push( $where, $keymap[ $key ] . $wpdb->prepare( ' like %s', esc_like( $value ) ) ); break; + case 'page': + $page = intval( $value ); + break; + case 'offset': $offset = intval( $value ); break; @@ -244,6 +250,10 @@ if ( ! class_exists( 'GiglogAdmin_Concert' ) ) { $query .= ' AND ' . implode( ' and ', $where ); } + if ( $page !== null ) { + $offset = ( $page - 1 ) * $limit; + } + $query .= ' ORDER BY wpgconcert_date'; $query .= " LIMIT {$offset},{$limit}"; @@ -290,6 +300,22 @@ if ( ! class_exists( 'GiglogAdmin_Concert' ) ) { } /** + * Return number of pages with the limit of concerts/page + * specified in the filter. + * + * @param array<string, mixed> $filter The filter to use for the query. + * @return number of pages. + */ + public static function count_pages( array $filter = array() ) : int { + if ( ! isset( $filter['limit'] ) ) { + $filter['limit'] = 15; + } + + $num_concerts = self::count( $filter ); + return ( intval( $num_concerts / $filter['limit'] ) ) + 1; + } + + /** * Save concert to database. */ public function save() : void { diff --git a/includes/giglogadmin-shortcodes.php b/includes/giglogadmin-shortcodes.php index 5a3d70d..1fba82e 100644 --- a/includes/giglogadmin-shortcodes.php +++ b/includes/giglogadmin-shortcodes.php @@ -22,15 +22,27 @@ if ( ! function_exists( 'giglogadmin_shortcode_public' ) ) { * This shortcode does not have any attributes. */ function giglogadmin_shortcode_public() : string { - $filters = array( - 'offset' => 0, - 'limit' => 15, - ); + $filters = array(); if ( isset( $_GET['city'] ) && ! empty( $_GET['city'] ) ) { $filters['city'] = sanitize_text_field( wp_unslash( $_GET['city'] ) ); } + $pages = GiglogAdmin_Concert::count_pages( $filters ); + $page = 1; + + if ( isset( $_GET['pg'] ) && ! empty( $_GET['pg'] ) ) { + $page = intval( wp_unslash( $_GET['pg'] ) ); + + if ( $page < 1 || $page > $pages ) { + // Just silently redirect to first page if we're outside + // the acceptable range. + wp_redirect( get_page_link() ); + } + } + + $filters['page'] = $page; + $concerts = GiglogAdmin_Concert::find_concerts( $filters ); ob_start(); diff --git a/includes/templates/giglogadmin-concerts-table.php b/includes/templates/giglogadmin-concerts-table.php index f38db3d..3f394c9 100644 --- a/includes/templates/giglogadmin-concerts-table.php +++ b/includes/templates/giglogadmin-concerts-table.php @@ -7,6 +7,9 @@ ?> <style> +.giglogadmin-concerts-filter { + margin-bottom: 0.5em; +} .giglogadmin-concert { margin-bottom: 1em; } @@ -43,45 +46,59 @@ <a href="<?php echo esc_url( site_url( get_page_uri() ) ); ?>">Clear filters</a> </form> </div> -<?php foreach ( $concerts as $concert ) { ?> - <div class="giglogadmin-concert"> - <div class="giglogadmin-concert-title-row"> - <time datetime="<?php echo esc_attr( $concert->cdate()->format( 'c' ) ); ?>"> - <?php echo esc_html( $concert->cdate()->format( 'd.m.Y' ) ); ?> - </time> - — - <span class="giglogadmin-concert-title"> - <?php echo esc_html( $concert->cname() ); ?> - </span> - — - <span class="giglogadmin-concert-city"> - <?php echo esc_html( $concert->venue()->city() ); ?> - </span> - </div> - <div class="giglogadmin-concert-meta-row"> - <span class="giglogadmin-concert-venue"> - <?php echo esc_html( $concert->venue()->name() ); ?> - </span> - </div> - <div class="giglogadmin-concert-links"> - <span class="giglogadmin-event-link"> - <a href="<?php echo esc_url( $concert->eventlink() ); ?>"> - Event - </a> - </span> - | - <span class="giglogadmin-concert-ticket-link"> - <a href="<?php echo esc_url( $concert->tickets() ); ?>"> - Tickets - </a> - </span> - | - <span class="giglogadmin-concert-ical-link"> - <a href=""> - Add to calendar - </a> - </span> + <div class="giglogadmin-concerts-table-list"> + <?php foreach ( $concerts as $concert ) { ?> + <div class="giglogadmin-concert"> + <div class="giglogadmin-concert-title-row"> + <time datetime="<?php echo esc_attr( $concert->cdate()->format( 'c' ) ); ?>"> + <?php echo esc_html( $concert->cdate()->format( 'd.m.Y' ) ); ?> + </time> + — + <span class="giglogadmin-concert-title"> + <?php echo esc_html( $concert->cname() ); ?> + </span> + — + <span class="giglogadmin-concert-city"> + <?php echo esc_html( $concert->venue()->city() ); ?> + </span> + </div> + <div class="giglogadmin-concert-meta-row"> + <span class="giglogadmin-concert-venue"> + <?php echo esc_html( $concert->venue()->name() ); ?> + </span> + </div> + <div class="giglogadmin-concert-links"> + <span class="giglogadmin-event-link"> + <a href="<?php echo esc_url( $concert->eventlink() ); ?>"> + Event + </a> + </span> + | + <span class="giglogadmin-concert-ticket-link"> + <a href="<?php echo esc_url( $concert->tickets() ); ?>"> + Tickets + </a> + </span> + | + <span class="giglogadmin-concert-ical-link"> + <a href=""> + Add to calendar + </a> + </span> + </div> </div> + <?php } ?> + </div> + <div class="giglogadmin-concerts-table-pagination"> + <?php + echo paginate_links( + array( + 'base' => site_url( get_page_uri() ) . '%_%', + 'total' => $pages, + 'current' => $page, + 'format' => '?pg=%#%', + ) + ); + ?> </div> -<?php } ?> </div> |