summaryrefslogblamecommitdiffstats
path: root/includes/admin/views/_concerts_table.php
blob: ad7aebcc4ef2b46dd5cbfa40d1ed00851c19a235 (plain) (tree)
1
2
3
4
5
6
7
8





                                                                               

                                                              



                                                      




                                      

                       
 
                                  


                    

                        
 
                                 
                              
 
                                 



                                           
                              
 
                                                


                                                                                       

                                                                                                         


                       

                                                                               
 


                                                                 




                       

                                                                               
 


                                                                 





                                          


                                                                                                                     
                                     
                                                                                 
                                         
                                                                                      




                     
                                                                                         
                                                          
                                                    

                             
                                                       


                                           


                                                                                                                                                    




                                                  
                                                                                           
                                                          
                                                          

                             
                                                       


                                           


                                                                                                                                                          




                                                  
                                                                                          


                                                          
                                       

                    


                                                           






                                                          


                                                                                                                                 
                                                                                                                                                                   
                                                                                                                                   



                                              

                                                                 

                                                              
                                                               
                              
         
 
                                          
                                          
                                                 
         
 
                                                                 
                                                                                
                                                                                                                                                                                                                                                                                                                          
 

                                                                                
 
                                 
                                                                              
                    
                                                                                                                 
                                                            
                                                        
                 
             
 
                                
 

                            
 

                                            
 
                                                                                        
                                                                                    
                         
                                             
             
 
                                                                                       
                           
                                                   
             
 
                                                                                        
                            
                                                 

             
                                                                             
                                                               
             
 

                                                                                                                                                         
                    
                                   
             
         
 
                                                  


                                                                          

                                                                                         

                                                                       

                                                      
 
                                                              


                                   

                                                                  
 
                                                                       

         

                                                                             

         
                                                       



                                                                                
                                       

                            
                                                                        


                                        
                                                                                           




                                                                                  
                                                                                                    



                                                                                                  
                                                              

                            
                                                                                       


                                   
                                                                                               


                                     
 






                            
                                                           
                                              
 
                            
 

                                                            

                                                         
 
                                                                
                                                          
                 
 
                                    
 
                           


                                                                                      
 

                                                                                                             
 
                                                                                      



                                                                                 
 
                                                                                             
 
                                                                
                                                                                                        
                     


                                                                                                                        

                 
                                                                                                                                                   
                                    
                                                       
             
 

                                   
                                                   
 
                                                   
                                            
 


                               
 
                                                    



                                                                                           
                                                


                                                             
 



                                                                            
                                               

                                                               

                                                                                                  
                     

                                
 

                                             
                                                                   
                            
                              

                                                                             
                      


                                                    
             
 
                                                               
                        
                          
                                                                        

                                  


                                             
 
                                   
 

                                                     

                                                                                              


                                                                                 
                                                                                                  




                                                                                         

                                                                                
                                                                                   
                                                                                     

                                                          


                                                                                                                                 










                                                                       
                                                                                    
                                  

                                                                       
                                                              
                    



                          
                                                                                                            
                                       
                                                                                        
 
                                                                   

                                                                              
                                                                                         



                                                                                           
                                                                                   

                                                                                   
                                                                  

                                                                 
                                           
                                                                            
                                                                                         
                                                                                           
                                                                                  







                                                                            
<?php
// SPDX-FileCopyrightText: 2021 Andrea Chirulescu <andrea.chirulescu@gmail.com>
// SPDX-FileCopyrightText: 2021 Harald Eilertsen <haraldei@anduin.net>
//
// SPDX-License-Identifier: AGPL-3.0-or-later

require_once __DIR__ . '/../../view-helpers/select_field.php';

if ( ! class_exists( 'GiglogAdmin_ConcertsTable' ) ) {
    class GiglogAdmin_ConcertsTable {

        const STATUS_LABELS = array(
            '',
            'Accred Requested',
            'Photo Approved',
            'Text Approved',
            'Photo and Text Approved',
            'Rejected',
        );

        const FILTER_KEYS = array(
            'city',
            'venue',
            'month',
            'only_mine',
        );

        private string $username;
        private array $filter;

        private int $page_no = 1;
        private int $total_no_of_pages = 1;
        private int $previous_page = 0;
        private int $next_page = 0;

        private string $nonce;

        public static function update() : void {
            //
            // Check that we get a nonce, and that it is valid to prevent CSRF attacks.
            //
            if ( ! isset( $_POST['nonce'] ) || ! wp_verify_nonce( $_POST['nonce'], 'concerts-table' ) ) {
                wp_die( 'You are not allowed to do that.', 403 );
                exit();
            }

            if ( isset( $_POST['assignitem'] ) ) {
                $concert = GiglogAdmin_Concert::get( intval( $_POST['cid'] ) );

                if ( $concert ) {
                    $role = sanitize_text_field( $_POST['pid'] );
                    self::assignconcert( $role, $concert );
                }

                return;
            }

            if ( isset( $_POST['unassignitem'] ) ) {
                $concert = GiglogAdmin_Concert::get( intval( $_POST['cid'] ) );

                if ( $concert ) {
                    $role = sanitize_text_field( $_POST['pid'] );
                    self::unassignconcert( $role, $concert );
                }

                return;
            }

            // handle the status drop down
            if ( isset( $_POST['selectstatus'] ) && ! empty( $_POST['selectstatus'] ) && ! empty( $_POST['cid'] ) ) {
                if ( $_POST['selectstatus'] > 0 && $_POST['selectstatus'] < count( self::STATUS_LABELS ) ) {
                    $concert = GiglogAdmin_Concert::get( intval( $_POST['cid'] ) );
                    if ( $concert ) {
                        $concert->set_status( intval( $_POST['selectstatus'] ) );
                        $concert->save();
                        self::emailuser( $concert, intval( $_POST['selectstatus'] ) );
                    }
                }
            }
        }

        static function assignconcert( string $p1, GiglogAdmin_Concert $concert ): void {
            $username = wp_get_current_user()->user_login;
            $concert->assign_role( $p1, $username );
            $concert->save();

            $cuser = get_user_by( 'login', 'etadmin' );

            if ( $cuser ) {
                $dest = $cuser->user_email;
                $subject = 'WP-GIGLOG ' . $username . ' has taken ' . $p1 . 'for concert ' . $concert->cname();
                $body = 'WP-GIGLOG ' . $username . ' has taken ' . $p1 . 'for concert ' . $concert->cname() . ', concert with ID ' . $concert->id();
                $headers = array( 'Content-Type: text/html; charset=UTF-8' );

                wp_mail( $dest, $subject, $body );
            }
        }

        static function unassignconcert( string $p1, GiglogAdmin_Concert $concert ): void {
            $username = wp_get_current_user()->user_login;
            $concert->remove_user_from_roles( $username );
            $concert->save();

            $cuser = get_user_by( 'login', 'etadmin' );

            if ( $cuser ) {
                $dest = $cuser->user_email;
                $subject = 'WP-GIGLOG ' . $username . ' has UNASSIGNED  ' . $p1 . 'for concert ' . $concert->cname();
                $body = 'WP-GIGLOG ' . $username . ' has UNASSIGNED  ' . $p1 . 'for concert ' . $concert->cname() . ', concert with ID ' . $concert->id();
                $headers = array( 'Content-Type: text/html; charset=UTF-8' );

                wp_mail( $dest, $subject, $body );
            }
        }

        static function emailuser( GiglogAdmin_Concert $concert, string $cstatus ): void {
            $username = wp_get_current_user()->user_login;
            $useremail = 'live@eternal-terror.com';
            $dest = '';
            $roles = $concert->roles();
            $x = '';

            foreach ( $roles as $role ) {
                if ( $role ) {
                    $cuser = get_user_by( 'login', $role );

                    if ( $cuser ) {
                        $dest .= $cuser->user_email . ',';
                    }
                }
            }

            $subject = 'Message from GIGLOG: Concert ' . $concert->cname() . ' has a new status  ' . $cstatus . '.';
            $body = 'You receive this message because you have assigned one of the roles for Concert ' . $concert->cname() . '.';
            $body .= '\r\n This is to inform you that there is a new status for the acreditation  ' . $cstatus . '.';
            $body .= '\r\n Should you no longer want to receive updates about this concert, please log in to Giglog and remove yourself from the concert. Thanks!';
            $headers = array( 'Content-Type: text/plain; charset=UTF-8' ); // it is text by default so no need for headers actually

            wp_mail( $dest, $subject, $body );
        }

        public function __construct() {
             $this->username = wp_get_current_user()->user_login;

            // Set the nonce we use to check for CSRF attacks.
            $this->nonce = wp_create_nonce( 'concerts-table' );
            $this->get_args();
        }

        public function render(): string {
            return $this->render_filters()
                . $this->render_concerts_table();
        }

        private function render_concert_table_header() : string {
            $content = '<div style="overflow-x:auto;"><table class="assignit">';
            $content .= '<span style="font-size:0.8em;font-style: italic;">Note: the iCal link will download a file with extension .ical which can be used to add the event to your calendar. For convenience, we set all events with start time at 19:00 but please check the actual event for the correct time.</span>';

            $content .= '<tr class="assignithrow">';
            $content .= '<th>CITY</th><th>DATE</th><th>NAME</th><th>VENUE</th>';

            if ( ! is_admin() ) {
                $content .= '<th>EVENT</th><th>TICKETS</th><th>Calendar</th>';
            } else {
                $content .= '<th></th><th>PHOTO1</th><th>PHOTO2</th><th>TEXT1</th><th>TEXT2</th><th>STATUS</th>';
                if ( current_user_can( 'administrator' ) ) {
                    $content .= '<th>AdminOptions</th>';
                }
            }

            $content .= '</tr>';

            return $content;
        }

        private function get_args() : void {
            $this->filter = array();

            // Use the submitted "city" if any. Otherwise, use the default/static value.
            $cty = filter_input( INPUT_GET, 'city', FILTER_SANITIZE_SPECIAL_CHARS );
            if ( $cty ) {
                $this->filter['city'] = $cty;
            }

            $venue = filter_input( INPUT_GET, 'venue', FILTER_SANITIZE_SPECIAL_CHARS );
            if ( $venue ) {
                $this->filter['venue_id'] = $venue;
            }

            $smonth = filter_input( INPUT_GET, 'month', FILTER_SANITIZE_SPECIAL_CHARS );
            if ( $smonth ) {
                $this->filter['month'] = $smonth;
            }

            if ( isset( $_GET['only_mine'] ) && $_GET['only_mone'] == '1' ) {
                $this->filter['currentuser'] = $this->username;
            }

            if ( isset( $_GET['page_no'] ) && $_GET['page_no'] != '' && is_numeric( $_GET['page_no'] ) && isset( $_GET['page_no'] ) == $this->page_no ) {
                $this->page_no = intval( $_GET['page_no'] );
            } else {
                $this->page_no = 1;
            }
        }

        private function get_concerts() : ?array {
            $total_records_per_page = 15;

            $total_concerts = GiglogAdmin_Concert::count( $this->filter );
            $this->total_no_of_pages = ceil( $total_concerts / $total_records_per_page );

            // calculate OFFSET Value and SET other Variables
            $offset = ( $this->page_no - 1 ) * $total_records_per_page;
            $this->previous_page = $this->page_no - 1;
            $this->next_page = $this->page_no + 1;

            if ( $this->page_no > $this->total_no_of_pages ) {
                $this->page_no = 1;
            }

            $this->filter['offset'] = $offset;
            $this->filter['recperpage'] = $total_records_per_page;

            return GiglogAdmin_Concert::find_concerts( $this->filter );
        }

        private function get_filter( string $f ) : ?string {
            return isset( $this->filter[ $f ] ) ? $this->filter[ $f ] : null;
        }

        private function render_pagination() : string {
            $content =
                '<div id="pagtextbox" style="display:flex">'
                . '<span class="alignleft" style="text-align:left;flex:auto;">';

            if ( $this->page_no > 1 ) {
                $content .=
                    '<span>'
                    . '<a href="' . add_query_arg( 'page_no', 1 ) . '">'
                    . 'First Page</a> -'
                    . '</span>'
                    . '<span>'
                    . '<a href="' . add_query_arg( 'page_no', $this->previous_page ) . '">'
                    . ' Previous</a></span>';
            }

            $content .= '</span>'
                . '<span class="aligncenter" style="text-align:center;flex:auto">'
                . '<strong>Page ' . $this->page_no . ' of ' . $this->total_no_of_pages . '</strong>'
                . '</span>';

            $content .= '<span class="alignright" style="text-align:right;flex:auto;float:none">';

            if ( $this->page_no < $this->total_no_of_pages ) {
                $content .=
                    '<span>'
                    . '<a href="' . add_query_arg( 'page_no', $this->next_page ) . '">'
                    . 'Next</a> - '
                    . '</span>'
                    . '<span>'
                    . '<a href="' . add_query_arg( 'page_no', $this->total_no_of_pages ) . '">'
                    . 'Last Page</a>'
                    . '</span>';
            }

            $content .=
                '</span>'
                . '</div>';

            return $content;
        }

        private function render_concerts_table() : string {
            $concerts = $this->get_concerts();

            $last_city = '';

            $content = $this->render_concert_table_header();

            foreach ( $concerts as $concert ) {
                $content .= '<tr class="assignitr"><td>';

                if ( $last_city != $concert->venue()->city() ) {
                    $content .= $concert->venue()->city();
                }

                $content .= '</td>';

                $content .=
                    '<td>' . date( 'd.M.Y', strtotime( $concert->cdate() ) ) . '</td>'
                    . '<td>' . strtoupper( esc_html( $concert->cname() ) ) . '</td>'
                    . '<td>' . esc_html( $concert->venue()->name() ) . '</td>';

                if ( is_admin() ) {
                    $content .= '<td class="publishstatus">' . $this->mark_new_concert( $concert ) . '</td>';

                    foreach ( array( 'photo1', 'photo2', 'rev1', 'rev2' ) as $role ) {
                        $content .= '<td class="assigneduser">'
                            . $this->assign_role_for_user_form( $role, $concert )
                            . '</td>';
                    }

                    $content .= '<td>' . self::STATUS_LABELS[ $concert->status() ] . '</td>';

                    if ( current_user_can( 'administrator' ) ) {
                        $content .= "<td class=\"adminbuttons\">{$this->adminactions( $concert )}</td>";
                    }
                } else {
                    $content .= '<td><a target="_blank" href="' . esc_url( $concert->eventlink() ) . '">Link</a></td>';
                    $content .= '<td><a target="_blank" href="' . esc_url( $concert->tickets() ) . '">Tickets</a></td>';
                }

                $content .= '<td> <a href="' . get_admin_url() . 'admin-ajax.php?action=giglog_export_ical&evid=' . $concert->id() . '">iCal</td>';
                $content .= '</tr>';
                $last_city = $concert->venue()->city();
            }

            $content .= '</table>';

            $content .= $this->render_pagination();

            // from main form that includes filters
            $content .= '</div></form></p>';

            // return the table
            return $content;
        }

        private function render_filters() : string {
            global $wp_locale;

            $select = '<p><form method="GET" action="" class="filterclass">FILTER DATA:  ';

            foreach ( $_GET as $name => $val ) {
                if ( in_array( $name, self::FILTER_KEYS ) ) {
                    continue;
                }

                $select .= '<input type="hidden" name="' . esc_attr( $name )
                    . '" value="' . esc_attr( $val ) . '">';
            }

            $cty = $this->get_filter( 'city' );

            $select .= \EternalTerror\ViewHelpers\select_field(
                'city',
                array_map( fn( $city) => array( $city, $city ), GiglogAdmin_Venue::all_cities() ),
                $cty,
                'Select city...'
            );

            if ( ! empty( $cty ) ) {
                // second drop down for venue
                $select .= \EternalTerror\ViewHelpers\select_field(
                    'venue',
                    array_map(
                        fn( $venue) => array( $venue->id(), $venue->name() ),
                        GiglogAdmin_Venue::venues_in_city( $cty )
                    ),
                    $this->get_filter( 'venue_id' ),
                    'Select venue...'
                );
            }

            $select .= \EternalTerror\ViewHelpers\select_field(
                'month',
                array_map(
                    fn( $m) => array( $m, $wp_locale->get_month( $m ) ),
                    range( 1, 12 )
                ),
                $this->get_filter( 'month' ),
                'Select month...'
            );

            $select .= '</select>';

            if ( is_admin() ) {
                // option to select own concerts only
                $select .= '<input name="only_mine" class="ownconc" type="checkbox" value="1"'
                    . checked( $this->get_filter( 'current_user' ) )
                    . '><label for="ownconcerts">Show own concerts only</label>';

            }
            // NOTE that I remvoed </form></p> and mvoed them up to render_concerts_table function
            $select .= '<input class="applybutton" type="submit" value="Apply Filters">';

            return $select;
        }

        private function adminactions( GiglogAdmin_Concert $concert ) : string {
            return '<form class="adminactions" method="POST" action="">'
                . '<input type="hidden" name="nonce" value="' . $this->nonce . '">'
                . '<input type="hidden" name="cid" value="' . $concert->id() . '" />'
                . \EternalTerror\ViewHelpers\select_field(
                    'selectstatus',
                    array_map( fn( $i) => array( $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>';
            } 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;

            // 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="nonce" value="' . $this->nonce . '">'
                    . '  <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="">'
                    . '  <input type="hidden" name="nonce" value="' . $this->nonce . '">'
                    . '  <input type="hidden" name="cid" value="' . $concert->id() . '" />'
                    . '  <input type="hidden" name="pid" value="' . $role . '" />'
                    . '  <input  type="submit" name="assignitem" value=""/>'
                    . '</form>';
            }

            return $f;
        }
    }
}