eventespresso / event-espresso-core

admin_pages/registrations/EE_Registrations_List_Table.class.php

Indentation +1031 added lines, -1031 removed lines

@@ -15,1065 +15,1065 @@
 {
 
 
-    /**
-     * @var Registrations_Admin_Page
-     */
-    protected $_admin_page;
-
-    /**
-     * @var array
-     */
-    private $_status;
-
-    /**
-     * An array of transaction details for the related transaction to the registration being processed.
-     * This is set via the _set_related_details method.
-     *
-     * @var array
-     */
-    protected $_transaction_details = [];
-
-    /**
-     * An array of event details for the related event to the registration being processed.
-     * This is set via the _set_related_details method.
-     *
-     * @var array
-     */
-    protected $_event_details = [];
-
-
-    /**
-     * @param Registrations_Admin_Page $admin_page
-     */
-    public function __construct(Registrations_Admin_Page $admin_page)
-    {
-        $req_data = $admin_page->get_request_data();
-        if (! empty($req_data['event_id'])) {
-            $extra_query_args = [];
-            foreach ($admin_page->get_views() as $view_details) {
-                $extra_query_args[ $view_details['slug'] ] = ['event_id' => $req_data['event_id']];
-            }
-            $this->_views = $admin_page->get_list_table_view_RLs($extra_query_args);
-        }
-        parent::__construct($admin_page);
-        $this->_status = $this->_admin_page->get_registration_status_array();
-    }
-
-
-    /**
-     * @return void
-     * @throws EE_Error
-     */
-    protected function _setup_data()
-    {
-        $this->_data           = $this->_admin_page->get_registrations($this->_per_page);
-        $this->_all_data_count = $this->_admin_page->get_registrations($this->_per_page, true);
-    }
-
-
-    /**
-     * @return void
-     */
-    protected function _set_properties()
-    {
-        $return_url          = $this->getReturnUrl();
-        $this->_wp_list_args = [
-            'singular' => esc_html__('registration', 'event_espresso'),
-            'plural'   => esc_html__('registrations', 'event_espresso'),
-            'ajax'     => true,
-            'screen'   => $this->_admin_page->get_current_screen()->id,
-        ];
-        $ID_column_name      = esc_html__('ID', 'event_espresso');
-        $ID_column_name      .= ' : <span class="show-on-mobile-view-only" style="float:none">';
-        $ID_column_name      .= esc_html__('Registrant Name', 'event_espresso');
-        $ID_column_name      .= '</span> ';
-        $req_data            = $this->_admin_page->get_request_data();
-        if (isset($req_data['event_id'])) {
-            $this->_columns        = [
-                'cb'               => '<input type="checkbox" />', // Render a checkbox instead of text
-                '_REG_ID'          => $ID_column_name,
-                'ATT_fname'        => esc_html__('Name', 'event_espresso'),
-                'ATT_email'        => esc_html__('Email', 'event_espresso'),
-                '_REG_date'        => esc_html__('Reg Date', 'event_espresso'),
-                'PRC_amount'       => esc_html__('TKT Price', 'event_espresso'),
-                '_REG_final_price' => esc_html__('Final Price', 'event_espresso'),
-                'TXN_total'        => esc_html__('Total Txn', 'event_espresso'),
-                'TXN_paid'         => esc_html__('Paid', 'event_espresso'),
-                'actions'          => esc_html__('Actions', 'event_espresso'),
-            ];
-            $this->_bottom_buttons = [
-                'report' => [
-                    'route'         => 'registrations_report',
-                    'extra_request' => [
-                        'EVT_ID'     => isset($this->_req_data['event_id'])
-                            ? $this->_req_data['event_id']
-                            : null,
-                        'return_url' => $return_url,
-                        'incude_checkins' => true,
-                    ],
-                ],
-            ];
-        } else {
-            $this->_columns        = [
-                'cb'               => '<input type="checkbox" />', // Render a checkbox instead of text
-                '_REG_ID'          => $ID_column_name,
-                'ATT_fname'        => esc_html__('Name', 'event_espresso'),
-                '_REG_date'        => esc_html__('TXN Date', 'event_espresso'),
-                'event_name'       => esc_html__('Event', 'event_espresso'),
-                'DTT_EVT_start'    => esc_html__('Event Date', 'event_espresso'),
-                '_REG_final_price' => esc_html__('Price', 'event_espresso'),
-                '_REG_paid'        => esc_html__('Paid', 'event_espresso'),
-                'actions'          => esc_html__('Actions', 'event_espresso'),
-            ];
-            $this->_bottom_buttons = [
-                'report_all' => [
-                    'route'         => 'registrations_report',
-                    'extra_request' => [
-                        'return_url' => $return_url,
-                    ],
-                ],
-            ];
-        }
-        $this->_bottom_buttons['report_filtered'] = [
-            'route'         => 'registrations_report',
-            'extra_request' => [
-                'use_filters' => true,
-                'incude_checkins' => isset($req_data['event_id']) ? true : false,
-                'return_url'  => $return_url,
-            ],
-        ];
-        $filters                                  = array_diff_key(
-            $this->_req_data,
-            array_flip(
-                [
-                    'page',
-                    'action',
-                    'default_nonce',
-                ]
-            )
-        );
-        if (! empty($filters)) {
-            $this->_bottom_buttons['report_filtered']['extra_request']['filters'] = $filters;
-        }
-        $this->_primary_column   = '_REG_ID';
-        $this->_sortable_columns = [
-            '_REG_date'     => ['_REG_date' => true],   // true means its already sorted
-            /**
-             * Allows users to change the default sort if they wish.
-             * Returning a falsey on this filter will result in the default sort to be by firstname rather than last
-             * name.
-             */
-            'ATT_fname'     => [
-                'FHEE__EE_Registrations_List_Table___set_properties__default_sort_by_registration_last_name',
-                true,
-                $this,
-            ]
-                ? ['ATT_lname' => false]
-                : ['ATT_fname' => false],
-            'event_name'    => ['event_name' => false],
-            'DTT_EVT_start' => ['DTT_EVT_start' => false],
-            '_REG_ID'       => ['_REG_ID' => false],
-        ];
-        $this->_hidden_columns   = [];
-    }
-
-
-    /**
-     * This simply sets up the row class for the table rows.
-     * Allows for easier overriding of child methods for setting up sorting.
-     *
-     * @param EE_Registration $item the current item
-     * @return string
-     */
-    protected function _get_row_class($item)
-    {
-        $class = parent::_get_row_class($item);
-        // add status class
-        $class .= ' ee-status-strip reg-status-' . $item->status_ID();
-        if ($this->_has_checkbox_column) {
-            $class .= ' has-checkbox-column';
-        }
-        return $class;
-    }
-
-
-    /**
-     * Set the $_transaction_details property if not set yet.
-     *
-     * @param EE_Registration $registration
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws ReflectionException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     */
-    protected function _set_related_details(EE_Registration $registration)
-    {
-        $transaction                = $registration->get_first_related('Transaction');
-        $status                     = $transaction instanceof EE_Transaction
-            ? $transaction->status_ID()
-            : EEM_Transaction::failed_status_code;
-        $this->_transaction_details = [
-            'transaction' => $transaction,
-            'status'      => $status,
-            'id'          => $transaction instanceof EE_Transaction
-                ? $transaction->ID()
-                : 0,
-            'title_attr'  => sprintf(
-                esc_html__('View Transaction Details (%s)', 'event_espresso'),
-                EEH_Template::pretty_status($status, false, 'sentence')
-            ),
-        ];
-        try {
-            $event = $registration->event();
-        } catch (EntityNotFoundException $e) {
-            $event = null;
-        }
-        $status               = $event instanceof EE_Event
-            ? $event->get_active_status()
-            : EE_Datetime::inactive;
-        $this->_event_details = [
-            'event'      => $event,
-            'status'     => $status,
-            'id'         => $event instanceof EE_Event
-                ? $event->ID()
-                : 0,
-            'title_attr' => sprintf(
-                esc_html__('Edit Event (%s)', 'event_espresso'),
-                EEH_Template::pretty_status($status, false, 'sentence')
-            ),
-        ];
-    }
-
-
-    /**
-     *    _get_table_filters
-     *
-     * @return array
-     */
-    protected function _get_table_filters()
-    {
-        $filters = [];
-        // todo we're currently using old functions here. We need to move things into the Events_Admin_Page() class as
-        // methods.
-        $cur_date     = isset($this->_req_data['month_range'])
-            ? $this->_req_data['month_range']
-            : '';
-        $cur_category = isset($this->_req_data['EVT_CAT'])
-            ? $this->_req_data['EVT_CAT']
-            : -1;
-        $reg_status   = isset($this->_req_data['_reg_status'])
-            ? $this->_req_data['_reg_status']
-            : '';
-        $filters[]    = EEH_Form_Fields::generate_registration_months_dropdown($cur_date, $reg_status, $cur_category);
-        $filters[]    = EEH_Form_Fields::generate_event_category_dropdown($cur_category);
-        $status       = [];
-        $status[]     = ['id' => 0, 'text' => esc_html__('Select Status', 'event_espresso')];
-        foreach ($this->_status as $key => $value) {
-            $status[] = ['id' => $key, 'text' => $value];
-        }
-        if ($this->_view !== 'incomplete') {
-            $filters[] = EEH_Form_Fields::select_input(
-                '_reg_status',
-                $status,
-                isset($this->_req_data['_reg_status'])
-                    ? strtoupper(sanitize_key($this->_req_data['_reg_status']))
-                    : ''
-            );
-        }
-        if (isset($this->_req_data['event_id'])) {
-            $filters[] = EEH_Form_Fields::hidden_input('event_id', $this->_req_data['event_id'], 'reg_event_id');
-        }
-        return $filters;
-    }
-
-
-    /**
-     * @return void
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     */
-    protected function _add_view_counts()
-    {
-        $this->_views['all']['count']   = $this->_total_registrations();
-        $this->_views['month']['count'] = $this->_total_registrations_this_month();
-        $this->_views['today']['count'] = $this->_total_registrations_today();
-        if (
-            EE_Registry::instance()->CAP->current_user_can(
-                'ee_delete_registrations',
-                'espresso_registrations_trash_registrations'
-            )
-        ) {
-            $this->_views['incomplete']['count'] = $this->_total_registrations('incomplete');
-            $this->_views['trash']['count']      = $this->_total_registrations('trash');
-        }
-    }
-
-
-    /**
-     * @param string $view
-     * @return int
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     */
-    protected function _total_registrations($view = '')
-    {
-        $_where = [];
-        $EVT_ID = isset($this->_req_data['event_id'])
-            ? absint($this->_req_data['event_id'])
-            : false;
-        if ($EVT_ID) {
-            $_where['EVT_ID'] = $EVT_ID;
-        }
-        switch ($view) {
-            case 'trash':
-                return EEM_Registration::instance()->count_deleted([$_where]);
-            case 'incomplete':
-                $_where['STS_ID'] = EEM_Registration::status_id_incomplete;
-                break;
-            default:
-                $_where['STS_ID'] = ['!=', EEM_Registration::status_id_incomplete];
-        }
-        return EEM_Registration::instance()->count([$_where]);
-    }
-
-
-    /**
-     * @return int
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     */
-    protected function _total_registrations_this_month()
-    {
-        $EVT_ID          = isset($this->_req_data['event_id'])
-            ? absint($this->_req_data['event_id'])
-            : false;
-        $_where          = $EVT_ID
-            ? ['EVT_ID' => $EVT_ID]
-            : [];
-        $this_year_r     = date('Y', current_time('timestamp'));
-        $time_start      = ' 00:00:00';
-        $time_end        = ' 23:59:59';
-        $this_month_r    = date('m', current_time('timestamp'));
-        $days_this_month = date('t', current_time('timestamp'));
-        // setup date query.
-        $beginning_string   = EEM_Registration::instance()->convert_datetime_for_query(
-            'REG_date',
-            $this_year_r . '-' . $this_month_r . '-01' . ' ' . $time_start,
-            'Y-m-d H:i:s'
-        );
-        $end_string         = EEM_Registration::instance()->convert_datetime_for_query(
-            'REG_date',
-            $this_year_r . '-' . $this_month_r . '-' . $days_this_month . ' ' . $time_end,
-            'Y-m-d H:i:s'
-        );
-        $_where['REG_date'] = [
-            'BETWEEN',
-            [
-                $beginning_string,
-                $end_string,
-            ],
-        ];
-        $_where['STS_ID']   = ['!=', EEM_Registration::status_id_incomplete];
-        return EEM_Registration::instance()->count([$_where]);
-    }
-
-
-    /**
-     * @return int
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     */
-    protected function _total_registrations_today()
-    {
-        $EVT_ID             = isset($this->_req_data['event_id'])
-            ? absint($this->_req_data['event_id'])
-            : false;
-        $_where             = $EVT_ID
-            ? ['EVT_ID' => $EVT_ID]
-            : [];
-        $current_date       = date('Y-m-d', current_time('timestamp'));
-        $time_start         = ' 00:00:00';
-        $time_end           = ' 23:59:59';
-        $_where['REG_date'] = [
-            'BETWEEN',
-            [
-                EEM_Registration::instance()->convert_datetime_for_query(
-                    'REG_date',
-                    $current_date . $time_start,
-                    'Y-m-d H:i:s'
-                ),
-                EEM_Registration::instance()->convert_datetime_for_query(
-                    'REG_date',
-                    $current_date . $time_end,
-                    'Y-m-d H:i:s'
-                ),
-            ],
-        ];
-        $_where['STS_ID']   = ['!=', EEM_Registration::status_id_incomplete];
-        return EEM_Registration::instance()->count([$_where]);
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column_cb($item)
-    {
-        /** checkbox/lock **/
-        $transaction   = $item->get_first_related('Transaction');
-        $payment_count = $transaction instanceof EE_Transaction
-            ? $transaction->count_related('Payment')
-            : 0;
-        return $payment_count > 0 || ! EE_Registry::instance()->CAP->current_user_can(
-            'ee_edit_registration',
-            'registration_list_table_checkbox_input',
-            $item->ID()
-        )
-            ? sprintf('<input type="checkbox" name="_REG_ID[]" value="%1$d" />', $item->ID())
-              . '<span class="ee-lock-icon"></span>'
-            : sprintf('<input type="checkbox" name="_REG_ID[]" value="%1$d" />', $item->ID());
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column__REG_ID(EE_Registration $item)
-    {
-        $attendee = $item->attendee();
-        $content  = $item->ID();
-        $content  .= '<div class="show-on-mobile-view-only">';
-        $content  .= '<br>';
-        $content  .= $attendee instanceof EE_Attendee
-            ? $attendee->full_name()
-            : '';
-        $content  .= '&nbsp;';
-        $content  .= sprintf(
-            esc_html__('(%1$s / %2$s)', 'event_espresso'),
-            $item->count(),
-            $item->group_size()
-        );
-        $content  .= '<br>';
-        $content  .= sprintf(esc_html__('Reg Code: %s', 'event_espresso'), $item->get('REG_code'));
-        $content  .= '</div>';
-        return $content;
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column__REG_date(EE_Registration $item)
-    {
-        $this->_set_related_details($item);
-        // Build row actions
-        $view_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
-            [
-                'action' => 'view_transaction',
-                'TXN_ID' => $this->_transaction_details['id'],
-            ],
-            TXN_ADMIN_URL
-        );
-        $view_link    = EE_Registry::instance()->CAP->current_user_can(
-            'ee_read_transaction',
-            'espresso_transactions_view_transaction'
-        )
-            ? '<a class="ee-status-color-'
-              . $this->_transaction_details['status']
-              . '" href="'
-              . $view_lnk_url
-              . '" title="'
-              . esc_attr($this->_transaction_details['title_attr'])
-              . '">'
-              . $item->get_i18n_datetime('REG_date')
-              . '</a>'
-            : $item->get_i18n_datetime('REG_date');
-        $view_link    .= '<br><span class="ee-status-text-small">'
-                         . EEH_Template::pretty_status($this->_transaction_details['status'], false, 'sentence')
-                         . '</span>';
-        return $view_link;
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column_event_name(EE_Registration $item)
-    {
-        $this->_set_related_details($item);
-        // page=espresso_events&action=edit_event&EVT_ID=2&edit_event_nonce=cf3a7e5b62
-        $EVT_ID     = $item->event_ID();
-        $event_name = $item->event_name();
-        $event_name =
-            $event_name
-                ?: esc_html__("No Associated Event", 'event_espresso');
-        $event_name = wp_trim_words($event_name, 30, '...');
-        if ($EVT_ID) {
-            $edit_event_url          = EE_Admin_Page::add_query_args_and_nonce(
-                ['action' => 'edit', 'post' => $EVT_ID],
-                EVENTS_ADMIN_URL
-            );
-            $edit_event              =
-                EE_Registry::instance()->CAP->current_user_can('ee_edit_event', 'edit_event', $EVT_ID)
-                    ? '<a class="ee-status-color-'
-                      . $this->_event_details['status']
-                      . '" href="'
-                      . $edit_event_url
-                      . '" title="'
-                      . esc_attr($this->_event_details['title_attr'])
-                      . '">'
-                      . $event_name
-                      . '</a>'
-                    : $event_name;
-            $edit_event_url          = EE_Admin_Page::add_query_args_and_nonce(['event_id' => $EVT_ID], REG_ADMIN_URL);
-            $actions['event_filter'] = '<a href="' . $edit_event_url . '" title="';
-            $actions['event_filter'] .= sprintf(
-                esc_attr__('Filter this list to only show registrations for %s', 'event_espresso'),
-                $event_name
-            );
-            $actions['event_filter'] .= '">' . esc_html__('View Registrations', 'event_espresso') . '</a>';
-        } else {
-            $edit_event              = $event_name;
-            $actions['event_filter'] = '';
-        }
-        return sprintf('%1$s %2$s', $edit_event, $this->row_actions($actions));
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column_DTT_EVT_start(EE_Registration $item)
-    {
-        $datetime_strings = [];
-        $ticket           = $item->ticket();
-        if ($ticket instanceof EE_Ticket) {
-            $remove_defaults = ['default_where_conditions' => 'none'];
-            $datetimes       = $ticket->datetimes($remove_defaults);
-            foreach ($datetimes as $datetime) {
-                $datetime_strings[] = $datetime->get_i18n_datetime('DTT_EVT_start');
-            }
-            return $this->generateDisplayForDatetimes($datetime_strings);
-        }
-        return esc_html__('There is no ticket on this registration', 'event_espresso');
-    }
-
-
-    /**
-     * Receives an array of datetime strings to display and converts them to the html container for the column.
-     *
-     * @param array $datetime_strings
-     * @return string
-     */
-    public function generateDisplayForDateTimes(array $datetime_strings)
-    {
-        $content       = '<div class="ee-registration-event-datetimes-container">';
-        $expand_toggle = count($datetime_strings) > 1
-            ? ' <span title="' . esc_attr__('Click to view all dates', 'event_espresso')
-              . '" class="ee-js ee-more-datetimes-toggle dashicons dashicons-plus"></span>'
-            : '';
-        // get first item for initial visibility
-        $content .= '<div class="left">' . array_shift($datetime_strings) . '</div>';
-        $content .= $expand_toggle;
-        if ($datetime_strings) {
-            $content .= '<div style="clear:both"></div>';
-            $content .= '<div class="ee-registration-event-datetimes-container more-items hidden">';
-            $content .= implode("<br />", $datetime_strings);
-            $content .= '</div>';
-        }
-        $content .= '</div>';
-        return $content;
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column_ATT_fname(EE_Registration $item)
-    {
-        $attendee      = $item->attendee();
-        $edit_lnk_url  = EE_Admin_Page::add_query_args_and_nonce(
-            [
-                'action'  => 'view_registration',
-                '_REG_ID' => $item->ID(),
-            ],
-            REG_ADMIN_URL
-        );
-        $attendee_name = $attendee instanceof EE_Attendee
-            ? $attendee->full_name()
-            : '';
-        $link          = EE_Registry::instance()->CAP->current_user_can(
-            'ee_read_registration',
-            'espresso_registrations_view_registration',
-            $item->ID()
-        )
-            ? '<a href="'
-              . $edit_lnk_url
-              . '" title="'
-              . esc_attr__('View Registration Details', 'event_espresso')
-              . '">'
-              . $attendee_name
-              . '</a>'
-            : $attendee_name;
-        $link          .= $item->count() === 1
-            ? '&nbsp;<sup><div class="dashicons dashicons-star-filled lt-blue-icon ee-icon-size-8"></div></sup>'
-            : '';
-        $t             = $item->get_first_related('Transaction');
-        $payment_count = $t instanceof EE_Transaction
-            ? $t->count_related('Payment')
-            : 0;
-        // append group count to name
-        $link .= '&nbsp;' . sprintf(esc_html__('(%1$s / %2$s)', 'event_espresso'), $item->count(), $item->group_size());
-        // append reg_code
-        $link .= '<br>' . sprintf(esc_html__('Reg Code: %s', 'event_espresso'), $item->get('REG_code'));
-        // reg status text for accessibility
-        $link   .= '<br><span class="ee-status-text-small">'
-                   . EEH_Template::pretty_status($item->status_ID(), false, 'sentence')
-                   . '</span>';
-        $action = ['_REG_ID' => $item->ID()];
-        if (isset($this->_req_data['event_id'])) {
-            $action['event_id'] = $item->event_ID();
-        }
-        // trash/restore/delete actions
-        $actions = [];
-        if (
-            $this->_view !== 'trash'
-            && $payment_count === 0
-            && EE_Registry::instance()->CAP->current_user_can(
-                'ee_delete_registration',
-                'espresso_registrations_trash_registrations',
-                $item->ID()
-            )
-        ) {
-            $action['action'] = 'trash_registrations';
-            $trash_lnk_url    = EE_Admin_Page::add_query_args_and_nonce(
-                $action,
-                REG_ADMIN_URL
-            );
-            $actions['trash'] = '<a href="'
-                                . $trash_lnk_url
-                                . '" title="'
-                                . esc_attr__('Trash Registration', 'event_espresso')
-                                . '">' . esc_html__('Trash', 'event_espresso') . '</a>';
-        } elseif ($this->_view === 'trash') {
-            // restore registration link
-            if (
-                EE_Registry::instance()->CAP->current_user_can(
-                    'ee_delete_registration',
-                    'espresso_registrations_restore_registrations',
-                    $item->ID()
-                )
-            ) {
-                $action['action']   = 'restore_registrations';
-                $restore_lnk_url    = EE_Admin_Page::add_query_args_and_nonce(
-                    $action,
-                    REG_ADMIN_URL
-                );
-                $actions['restore'] = '<a href="'
-                                      . $restore_lnk_url
-                                      . '" title="'
-                                      . esc_attr__('Restore Registration', 'event_espresso') . '">'
-                                      . esc_html__('Restore', 'event_espresso') . '</a>';
-            }
-            if (
-                EE_Registry::instance()->CAP->current_user_can(
-                    'ee_delete_registration',
-                    'espresso_registrations_ee_delete_registrations',
-                    $item->ID()
-                )
-            ) {
-                $action['action']  = 'delete_registrations';
-                $delete_lnk_url    = EE_Admin_Page::add_query_args_and_nonce(
-                    $action,
-                    REG_ADMIN_URL
-                );
-                $actions['delete'] = '<a href="'
-                                     . $delete_lnk_url
-                                     . '" title="'
-                                     . esc_attr__('Delete Registration Permanently', 'event_espresso')
-                                     . '">'
-                                     . esc_html__('Delete', 'event_espresso')
-                                     . '</a>';
-            }
-        }
-        return sprintf('%1$s %2$s', $link, $this->row_actions($actions));
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column_ATT_email(EE_Registration $item)
-    {
-        $attendee = $item->get_first_related('Attendee');
-        return ! $attendee instanceof EE_Attendee
-            ? esc_html__('No attached contact record.', 'event_espresso')
-            : $attendee->email();
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     */
-    public function column__REG_count(EE_Registration $item)
-    {
-        return sprintf(esc_html__('%1$s / %2$s', 'event_espresso'), $item->count(), $item->group_size());
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws ReflectionException
-     */
-    public function column_PRC_amount(EE_Registration $item)
-    {
-        $ticket   = $item->ticket();
-        $req_data = $this->_admin_page->get_request_data();
-        $content  = isset($req_data['event_id']) && $ticket instanceof EE_Ticket
-            ? '<span class="TKT_name">' . $ticket->name() . '</span><br />'
-            : '';
-        if ($item->final_price() > 0) {
-            $content .= '<span class="reg-pad-rght">' . $item->pretty_final_price() . '</span>';
-        } else {
-            // free event
-            $content .= '<span class="reg-overview-free-event-spn reg-pad-rght">'
-                        . esc_html__('free', 'event_espresso')
-                        . '</span>';
-        }
-        return $content;
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws ReflectionException
-     */
-    public function column__REG_final_price(EE_Registration $item)
-    {
-        $ticket   = $item->ticket();
-        $req_data = $this->_admin_page->get_request_data();
-        $content  = isset($req_data['event_id']) || ! $ticket instanceof EE_Ticket
-            ? ''
-            : '<span class="TKT_name">' . $ticket->name() . '</span><br />';
-        $content  .= '<span class="reg-pad-rght">' . $item->pretty_final_price() . '</span>';
-        return $content;
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     */
-    public function column__REG_paid(EE_Registration $item)
-    {
-        $payment_method      = $item->payment_method();
-        $payment_method_name = $payment_method instanceof EE_Payment_Method
-            ? $payment_method->admin_name()
-            : esc_html__('Unknown', 'event_espresso');
-        $content             = '<span class="reg-pad-rght">' . $item->pretty_paid() . '</span>';
-        if ($item->paid() > 0) {
-            $content .= '<br><span class="ee-status-text-small">'
-                        . sprintf(
-                            esc_html__('...via %s', 'event_espresso'),
-                            $payment_method_name
-                        )
-                        . '</span>';
-        }
-        return $content;
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws EntityNotFoundException
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column_TXN_total(EE_Registration $item)
-    {
-        if ($item->transaction()) {
-            $view_txn_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
-                [
-                    'action' => 'view_transaction',
-                    'TXN_ID' => $item->transaction_ID(),
-                ],
-                TXN_ADMIN_URL
-            );
-            return EE_Registry::instance()->CAP->current_user_can(
-                'ee_read_transaction',
-                'espresso_transactions_view_transaction',
-                $item->transaction_ID()
-            )
-                ? '<span class="reg-pad-rght"><a class="status-'
-                  . $item->transaction()->status_ID()
-                  . '" href="'
-                  . $view_txn_lnk_url
-                  . '"  title="'
-                  . esc_attr__('View Transaction', 'event_espresso')
-                  . '">'
-                  . $item->transaction()->pretty_total()
-                  . '</a></span>'
-                : '<span class="reg-pad-rght">' . $item->transaction()->pretty_total() . '</span>';
-        } else {
-            return esc_html__("None", "event_espresso");
-        }
-    }
-
-
-    /**
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws EntityNotFoundException
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column_TXN_paid(EE_Registration $item)
-    {
-        if ($item->count() === 1) {
-            $transaction = $item->transaction()
-                ? $item->transaction()
-                : EE_Transaction::new_instance();
-            if ($transaction->paid() >= $transaction->total()) {
-                return '<span class="reg-pad-rght"><div class="dashicons dashicons-yes green-icon"></div></span>';
-            } else {
-                $view_txn_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
-                    [
-                        'action' => 'view_transaction',
-                        'TXN_ID' => $item->transaction_ID(),
-                    ],
-                    TXN_ADMIN_URL
-                );
-                return EE_Registry::instance()->CAP->current_user_can(
-                    'ee_read_transaction',
-                    'espresso_transactions_view_transaction',
-                    $item->transaction_ID()
-                )
-                    ? '<span class="reg-pad-rght"><a class="status-'
-                      . $transaction->status_ID()
-                      . '" href="'
-                      . $view_txn_lnk_url
-                      . '"  title="'
-                      . esc_attr__('View Transaction', 'event_espresso')
-                      . '">'
-                      . $item->transaction()->pretty_paid()
-                      . '</a><span>'
-                    : '<span class="reg-pad-rght">' . $item->transaction()->pretty_paid() . '</span>';
-            }
-        }
-        return '&nbsp;';
-    }
-
-
-    /**
-     * column_actions
-     *
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     * @throws ReflectionException
-     */
-    public function column_actions(EE_Registration $item)
-    {
-        $actions  = [];
-        $attendee = $item->attendee();
-        $this->_set_related_details($item);
-
-        // Build row actions
-        if (
-            EE_Registry::instance()->CAP->current_user_can(
-                'ee_read_registration',
-                'espresso_registrations_view_registration',
-                $item->ID()
-            )
-        ) {
-            $view_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
-                [
-                    'action'  => 'view_registration',
-                    '_REG_ID' => $item->ID(),
-                ],
-                REG_ADMIN_URL
-            );
-            $actions['view_lnk'] = '
+	/**
+	 * @var Registrations_Admin_Page
+	 */
+	protected $_admin_page;
+
+	/**
+	 * @var array
+	 */
+	private $_status;
+
+	/**
+	 * An array of transaction details for the related transaction to the registration being processed.
+	 * This is set via the _set_related_details method.
+	 *
+	 * @var array
+	 */
+	protected $_transaction_details = [];
+
+	/**
+	 * An array of event details for the related event to the registration being processed.
+	 * This is set via the _set_related_details method.
+	 *
+	 * @var array
+	 */
+	protected $_event_details = [];
+
+
+	/**
+	 * @param Registrations_Admin_Page $admin_page
+	 */
+	public function __construct(Registrations_Admin_Page $admin_page)
+	{
+		$req_data = $admin_page->get_request_data();
+		if (! empty($req_data['event_id'])) {
+			$extra_query_args = [];
+			foreach ($admin_page->get_views() as $view_details) {
+				$extra_query_args[ $view_details['slug'] ] = ['event_id' => $req_data['event_id']];
+			}
+			$this->_views = $admin_page->get_list_table_view_RLs($extra_query_args);
+		}
+		parent::__construct($admin_page);
+		$this->_status = $this->_admin_page->get_registration_status_array();
+	}
+
+
+	/**
+	 * @return void
+	 * @throws EE_Error
+	 */
+	protected function _setup_data()
+	{
+		$this->_data           = $this->_admin_page->get_registrations($this->_per_page);
+		$this->_all_data_count = $this->_admin_page->get_registrations($this->_per_page, true);
+	}
+
+
+	/**
+	 * @return void
+	 */
+	protected function _set_properties()
+	{
+		$return_url          = $this->getReturnUrl();
+		$this->_wp_list_args = [
+			'singular' => esc_html__('registration', 'event_espresso'),
+			'plural'   => esc_html__('registrations', 'event_espresso'),
+			'ajax'     => true,
+			'screen'   => $this->_admin_page->get_current_screen()->id,
+		];
+		$ID_column_name      = esc_html__('ID', 'event_espresso');
+		$ID_column_name      .= ' : <span class="show-on-mobile-view-only" style="float:none">';
+		$ID_column_name      .= esc_html__('Registrant Name', 'event_espresso');
+		$ID_column_name      .= '</span> ';
+		$req_data            = $this->_admin_page->get_request_data();
+		if (isset($req_data['event_id'])) {
+			$this->_columns        = [
+				'cb'               => '<input type="checkbox" />', // Render a checkbox instead of text
+				'_REG_ID'          => $ID_column_name,
+				'ATT_fname'        => esc_html__('Name', 'event_espresso'),
+				'ATT_email'        => esc_html__('Email', 'event_espresso'),
+				'_REG_date'        => esc_html__('Reg Date', 'event_espresso'),
+				'PRC_amount'       => esc_html__('TKT Price', 'event_espresso'),
+				'_REG_final_price' => esc_html__('Final Price', 'event_espresso'),
+				'TXN_total'        => esc_html__('Total Txn', 'event_espresso'),
+				'TXN_paid'         => esc_html__('Paid', 'event_espresso'),
+				'actions'          => esc_html__('Actions', 'event_espresso'),
+			];
+			$this->_bottom_buttons = [
+				'report' => [
+					'route'         => 'registrations_report',
+					'extra_request' => [
+						'EVT_ID'     => isset($this->_req_data['event_id'])
+							? $this->_req_data['event_id']
+							: null,
+						'return_url' => $return_url,
+						'incude_checkins' => true,
+					],
+				],
+			];
+		} else {
+			$this->_columns        = [
+				'cb'               => '<input type="checkbox" />', // Render a checkbox instead of text
+				'_REG_ID'          => $ID_column_name,
+				'ATT_fname'        => esc_html__('Name', 'event_espresso'),
+				'_REG_date'        => esc_html__('TXN Date', 'event_espresso'),
+				'event_name'       => esc_html__('Event', 'event_espresso'),
+				'DTT_EVT_start'    => esc_html__('Event Date', 'event_espresso'),
+				'_REG_final_price' => esc_html__('Price', 'event_espresso'),
+				'_REG_paid'        => esc_html__('Paid', 'event_espresso'),
+				'actions'          => esc_html__('Actions', 'event_espresso'),
+			];
+			$this->_bottom_buttons = [
+				'report_all' => [
+					'route'         => 'registrations_report',
+					'extra_request' => [
+						'return_url' => $return_url,
+					],
+				],
+			];
+		}
+		$this->_bottom_buttons['report_filtered'] = [
+			'route'         => 'registrations_report',
+			'extra_request' => [
+				'use_filters' => true,
+				'incude_checkins' => isset($req_data['event_id']) ? true : false,
+				'return_url'  => $return_url,
+			],
+		];
+		$filters                                  = array_diff_key(
+			$this->_req_data,
+			array_flip(
+				[
+					'page',
+					'action',
+					'default_nonce',
+				]
+			)
+		);
+		if (! empty($filters)) {
+			$this->_bottom_buttons['report_filtered']['extra_request']['filters'] = $filters;
+		}
+		$this->_primary_column   = '_REG_ID';
+		$this->_sortable_columns = [
+			'_REG_date'     => ['_REG_date' => true],   // true means its already sorted
+			/**
+			 * Allows users to change the default sort if they wish.
+			 * Returning a falsey on this filter will result in the default sort to be by firstname rather than last
+			 * name.
+			 */
+			'ATT_fname'     => [
+				'FHEE__EE_Registrations_List_Table___set_properties__default_sort_by_registration_last_name',
+				true,
+				$this,
+			]
+				? ['ATT_lname' => false]
+				: ['ATT_fname' => false],
+			'event_name'    => ['event_name' => false],
+			'DTT_EVT_start' => ['DTT_EVT_start' => false],
+			'_REG_ID'       => ['_REG_ID' => false],
+		];
+		$this->_hidden_columns   = [];
+	}
+
+
+	/**
+	 * This simply sets up the row class for the table rows.
+	 * Allows for easier overriding of child methods for setting up sorting.
+	 *
+	 * @param EE_Registration $item the current item
+	 * @return string
+	 */
+	protected function _get_row_class($item)
+	{
+		$class = parent::_get_row_class($item);
+		// add status class
+		$class .= ' ee-status-strip reg-status-' . $item->status_ID();
+		if ($this->_has_checkbox_column) {
+			$class .= ' has-checkbox-column';
+		}
+		return $class;
+	}
+
+
+	/**
+	 * Set the $_transaction_details property if not set yet.
+	 *
+	 * @param EE_Registration $registration
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws ReflectionException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 */
+	protected function _set_related_details(EE_Registration $registration)
+	{
+		$transaction                = $registration->get_first_related('Transaction');
+		$status                     = $transaction instanceof EE_Transaction
+			? $transaction->status_ID()
+			: EEM_Transaction::failed_status_code;
+		$this->_transaction_details = [
+			'transaction' => $transaction,
+			'status'      => $status,
+			'id'          => $transaction instanceof EE_Transaction
+				? $transaction->ID()
+				: 0,
+			'title_attr'  => sprintf(
+				esc_html__('View Transaction Details (%s)', 'event_espresso'),
+				EEH_Template::pretty_status($status, false, 'sentence')
+			),
+		];
+		try {
+			$event = $registration->event();
+		} catch (EntityNotFoundException $e) {
+			$event = null;
+		}
+		$status               = $event instanceof EE_Event
+			? $event->get_active_status()
+			: EE_Datetime::inactive;
+		$this->_event_details = [
+			'event'      => $event,
+			'status'     => $status,
+			'id'         => $event instanceof EE_Event
+				? $event->ID()
+				: 0,
+			'title_attr' => sprintf(
+				esc_html__('Edit Event (%s)', 'event_espresso'),
+				EEH_Template::pretty_status($status, false, 'sentence')
+			),
+		];
+	}
+
+
+	/**
+	 *    _get_table_filters
+	 *
+	 * @return array
+	 */
+	protected function _get_table_filters()
+	{
+		$filters = [];
+		// todo we're currently using old functions here. We need to move things into the Events_Admin_Page() class as
+		// methods.
+		$cur_date     = isset($this->_req_data['month_range'])
+			? $this->_req_data['month_range']
+			: '';
+		$cur_category = isset($this->_req_data['EVT_CAT'])
+			? $this->_req_data['EVT_CAT']
+			: -1;
+		$reg_status   = isset($this->_req_data['_reg_status'])
+			? $this->_req_data['_reg_status']
+			: '';
+		$filters[]    = EEH_Form_Fields::generate_registration_months_dropdown($cur_date, $reg_status, $cur_category);
+		$filters[]    = EEH_Form_Fields::generate_event_category_dropdown($cur_category);
+		$status       = [];
+		$status[]     = ['id' => 0, 'text' => esc_html__('Select Status', 'event_espresso')];
+		foreach ($this->_status as $key => $value) {
+			$status[] = ['id' => $key, 'text' => $value];
+		}
+		if ($this->_view !== 'incomplete') {
+			$filters[] = EEH_Form_Fields::select_input(
+				'_reg_status',
+				$status,
+				isset($this->_req_data['_reg_status'])
+					? strtoupper(sanitize_key($this->_req_data['_reg_status']))
+					: ''
+			);
+		}
+		if (isset($this->_req_data['event_id'])) {
+			$filters[] = EEH_Form_Fields::hidden_input('event_id', $this->_req_data['event_id'], 'reg_event_id');
+		}
+		return $filters;
+	}
+
+
+	/**
+	 * @return void
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 */
+	protected function _add_view_counts()
+	{
+		$this->_views['all']['count']   = $this->_total_registrations();
+		$this->_views['month']['count'] = $this->_total_registrations_this_month();
+		$this->_views['today']['count'] = $this->_total_registrations_today();
+		if (
+			EE_Registry::instance()->CAP->current_user_can(
+				'ee_delete_registrations',
+				'espresso_registrations_trash_registrations'
+			)
+		) {
+			$this->_views['incomplete']['count'] = $this->_total_registrations('incomplete');
+			$this->_views['trash']['count']      = $this->_total_registrations('trash');
+		}
+	}
+
+
+	/**
+	 * @param string $view
+	 * @return int
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 */
+	protected function _total_registrations($view = '')
+	{
+		$_where = [];
+		$EVT_ID = isset($this->_req_data['event_id'])
+			? absint($this->_req_data['event_id'])
+			: false;
+		if ($EVT_ID) {
+			$_where['EVT_ID'] = $EVT_ID;
+		}
+		switch ($view) {
+			case 'trash':
+				return EEM_Registration::instance()->count_deleted([$_where]);
+			case 'incomplete':
+				$_where['STS_ID'] = EEM_Registration::status_id_incomplete;
+				break;
+			default:
+				$_where['STS_ID'] = ['!=', EEM_Registration::status_id_incomplete];
+		}
+		return EEM_Registration::instance()->count([$_where]);
+	}
+
+
+	/**
+	 * @return int
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 */
+	protected function _total_registrations_this_month()
+	{
+		$EVT_ID          = isset($this->_req_data['event_id'])
+			? absint($this->_req_data['event_id'])
+			: false;
+		$_where          = $EVT_ID
+			? ['EVT_ID' => $EVT_ID]
+			: [];
+		$this_year_r     = date('Y', current_time('timestamp'));
+		$time_start      = ' 00:00:00';
+		$time_end        = ' 23:59:59';
+		$this_month_r    = date('m', current_time('timestamp'));
+		$days_this_month = date('t', current_time('timestamp'));
+		// setup date query.
+		$beginning_string   = EEM_Registration::instance()->convert_datetime_for_query(
+			'REG_date',
+			$this_year_r . '-' . $this_month_r . '-01' . ' ' . $time_start,
+			'Y-m-d H:i:s'
+		);
+		$end_string         = EEM_Registration::instance()->convert_datetime_for_query(
+			'REG_date',
+			$this_year_r . '-' . $this_month_r . '-' . $days_this_month . ' ' . $time_end,
+			'Y-m-d H:i:s'
+		);
+		$_where['REG_date'] = [
+			'BETWEEN',
+			[
+				$beginning_string,
+				$end_string,
+			],
+		];
+		$_where['STS_ID']   = ['!=', EEM_Registration::status_id_incomplete];
+		return EEM_Registration::instance()->count([$_where]);
+	}
+
+
+	/**
+	 * @return int
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 */
+	protected function _total_registrations_today()
+	{
+		$EVT_ID             = isset($this->_req_data['event_id'])
+			? absint($this->_req_data['event_id'])
+			: false;
+		$_where             = $EVT_ID
+			? ['EVT_ID' => $EVT_ID]
+			: [];
+		$current_date       = date('Y-m-d', current_time('timestamp'));
+		$time_start         = ' 00:00:00';
+		$time_end           = ' 23:59:59';
+		$_where['REG_date'] = [
+			'BETWEEN',
+			[
+				EEM_Registration::instance()->convert_datetime_for_query(
+					'REG_date',
+					$current_date . $time_start,
+					'Y-m-d H:i:s'
+				),
+				EEM_Registration::instance()->convert_datetime_for_query(
+					'REG_date',
+					$current_date . $time_end,
+					'Y-m-d H:i:s'
+				),
+			],
+		];
+		$_where['STS_ID']   = ['!=', EEM_Registration::status_id_incomplete];
+		return EEM_Registration::instance()->count([$_where]);
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column_cb($item)
+	{
+		/** checkbox/lock **/
+		$transaction   = $item->get_first_related('Transaction');
+		$payment_count = $transaction instanceof EE_Transaction
+			? $transaction->count_related('Payment')
+			: 0;
+		return $payment_count > 0 || ! EE_Registry::instance()->CAP->current_user_can(
+			'ee_edit_registration',
+			'registration_list_table_checkbox_input',
+			$item->ID()
+		)
+			? sprintf('<input type="checkbox" name="_REG_ID[]" value="%1$d" />', $item->ID())
+			  . '<span class="ee-lock-icon"></span>'
+			: sprintf('<input type="checkbox" name="_REG_ID[]" value="%1$d" />', $item->ID());
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column__REG_ID(EE_Registration $item)
+	{
+		$attendee = $item->attendee();
+		$content  = $item->ID();
+		$content  .= '<div class="show-on-mobile-view-only">';
+		$content  .= '<br>';
+		$content  .= $attendee instanceof EE_Attendee
+			? $attendee->full_name()
+			: '';
+		$content  .= '&nbsp;';
+		$content  .= sprintf(
+			esc_html__('(%1$s / %2$s)', 'event_espresso'),
+			$item->count(),
+			$item->group_size()
+		);
+		$content  .= '<br>';
+		$content  .= sprintf(esc_html__('Reg Code: %s', 'event_espresso'), $item->get('REG_code'));
+		$content  .= '</div>';
+		return $content;
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column__REG_date(EE_Registration $item)
+	{
+		$this->_set_related_details($item);
+		// Build row actions
+		$view_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
+			[
+				'action' => 'view_transaction',
+				'TXN_ID' => $this->_transaction_details['id'],
+			],
+			TXN_ADMIN_URL
+		);
+		$view_link    = EE_Registry::instance()->CAP->current_user_can(
+			'ee_read_transaction',
+			'espresso_transactions_view_transaction'
+		)
+			? '<a class="ee-status-color-'
+			  . $this->_transaction_details['status']
+			  . '" href="'
+			  . $view_lnk_url
+			  . '" title="'
+			  . esc_attr($this->_transaction_details['title_attr'])
+			  . '">'
+			  . $item->get_i18n_datetime('REG_date')
+			  . '</a>'
+			: $item->get_i18n_datetime('REG_date');
+		$view_link    .= '<br><span class="ee-status-text-small">'
+						 . EEH_Template::pretty_status($this->_transaction_details['status'], false, 'sentence')
+						 . '</span>';
+		return $view_link;
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column_event_name(EE_Registration $item)
+	{
+		$this->_set_related_details($item);
+		// page=espresso_events&action=edit_event&EVT_ID=2&edit_event_nonce=cf3a7e5b62
+		$EVT_ID     = $item->event_ID();
+		$event_name = $item->event_name();
+		$event_name =
+			$event_name
+				?: esc_html__("No Associated Event", 'event_espresso');
+		$event_name = wp_trim_words($event_name, 30, '...');
+		if ($EVT_ID) {
+			$edit_event_url          = EE_Admin_Page::add_query_args_and_nonce(
+				['action' => 'edit', 'post' => $EVT_ID],
+				EVENTS_ADMIN_URL
+			);
+			$edit_event              =
+				EE_Registry::instance()->CAP->current_user_can('ee_edit_event', 'edit_event', $EVT_ID)
+					? '<a class="ee-status-color-'
+					  . $this->_event_details['status']
+					  . '" href="'
+					  . $edit_event_url
+					  . '" title="'
+					  . esc_attr($this->_event_details['title_attr'])
+					  . '">'
+					  . $event_name
+					  . '</a>'
+					: $event_name;
+			$edit_event_url          = EE_Admin_Page::add_query_args_and_nonce(['event_id' => $EVT_ID], REG_ADMIN_URL);
+			$actions['event_filter'] = '<a href="' . $edit_event_url . '" title="';
+			$actions['event_filter'] .= sprintf(
+				esc_attr__('Filter this list to only show registrations for %s', 'event_espresso'),
+				$event_name
+			);
+			$actions['event_filter'] .= '">' . esc_html__('View Registrations', 'event_espresso') . '</a>';
+		} else {
+			$edit_event              = $event_name;
+			$actions['event_filter'] = '';
+		}
+		return sprintf('%1$s %2$s', $edit_event, $this->row_actions($actions));
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column_DTT_EVT_start(EE_Registration $item)
+	{
+		$datetime_strings = [];
+		$ticket           = $item->ticket();
+		if ($ticket instanceof EE_Ticket) {
+			$remove_defaults = ['default_where_conditions' => 'none'];
+			$datetimes       = $ticket->datetimes($remove_defaults);
+			foreach ($datetimes as $datetime) {
+				$datetime_strings[] = $datetime->get_i18n_datetime('DTT_EVT_start');
+			}
+			return $this->generateDisplayForDatetimes($datetime_strings);
+		}
+		return esc_html__('There is no ticket on this registration', 'event_espresso');
+	}
+
+
+	/**
+	 * Receives an array of datetime strings to display and converts them to the html container for the column.
+	 *
+	 * @param array $datetime_strings
+	 * @return string
+	 */
+	public function generateDisplayForDateTimes(array $datetime_strings)
+	{
+		$content       = '<div class="ee-registration-event-datetimes-container">';
+		$expand_toggle = count($datetime_strings) > 1
+			? ' <span title="' . esc_attr__('Click to view all dates', 'event_espresso')
+			  . '" class="ee-js ee-more-datetimes-toggle dashicons dashicons-plus"></span>'
+			: '';
+		// get first item for initial visibility
+		$content .= '<div class="left">' . array_shift($datetime_strings) . '</div>';
+		$content .= $expand_toggle;
+		if ($datetime_strings) {
+			$content .= '<div style="clear:both"></div>';
+			$content .= '<div class="ee-registration-event-datetimes-container more-items hidden">';
+			$content .= implode("<br />", $datetime_strings);
+			$content .= '</div>';
+		}
+		$content .= '</div>';
+		return $content;
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column_ATT_fname(EE_Registration $item)
+	{
+		$attendee      = $item->attendee();
+		$edit_lnk_url  = EE_Admin_Page::add_query_args_and_nonce(
+			[
+				'action'  => 'view_registration',
+				'_REG_ID' => $item->ID(),
+			],
+			REG_ADMIN_URL
+		);
+		$attendee_name = $attendee instanceof EE_Attendee
+			? $attendee->full_name()
+			: '';
+		$link          = EE_Registry::instance()->CAP->current_user_can(
+			'ee_read_registration',
+			'espresso_registrations_view_registration',
+			$item->ID()
+		)
+			? '<a href="'
+			  . $edit_lnk_url
+			  . '" title="'
+			  . esc_attr__('View Registration Details', 'event_espresso')
+			  . '">'
+			  . $attendee_name
+			  . '</a>'
+			: $attendee_name;
+		$link          .= $item->count() === 1
+			? '&nbsp;<sup><div class="dashicons dashicons-star-filled lt-blue-icon ee-icon-size-8"></div></sup>'
+			: '';
+		$t             = $item->get_first_related('Transaction');
+		$payment_count = $t instanceof EE_Transaction
+			? $t->count_related('Payment')
+			: 0;
+		// append group count to name
+		$link .= '&nbsp;' . sprintf(esc_html__('(%1$s / %2$s)', 'event_espresso'), $item->count(), $item->group_size());
+		// append reg_code
+		$link .= '<br>' . sprintf(esc_html__('Reg Code: %s', 'event_espresso'), $item->get('REG_code'));
+		// reg status text for accessibility
+		$link   .= '<br><span class="ee-status-text-small">'
+				   . EEH_Template::pretty_status($item->status_ID(), false, 'sentence')
+				   . '</span>';
+		$action = ['_REG_ID' => $item->ID()];
+		if (isset($this->_req_data['event_id'])) {
+			$action['event_id'] = $item->event_ID();
+		}
+		// trash/restore/delete actions
+		$actions = [];
+		if (
+			$this->_view !== 'trash'
+			&& $payment_count === 0
+			&& EE_Registry::instance()->CAP->current_user_can(
+				'ee_delete_registration',
+				'espresso_registrations_trash_registrations',
+				$item->ID()
+			)
+		) {
+			$action['action'] = 'trash_registrations';
+			$trash_lnk_url    = EE_Admin_Page::add_query_args_and_nonce(
+				$action,
+				REG_ADMIN_URL
+			);
+			$actions['trash'] = '<a href="'
+								. $trash_lnk_url
+								. '" title="'
+								. esc_attr__('Trash Registration', 'event_espresso')
+								. '">' . esc_html__('Trash', 'event_espresso') . '</a>';
+		} elseif ($this->_view === 'trash') {
+			// restore registration link
+			if (
+				EE_Registry::instance()->CAP->current_user_can(
+					'ee_delete_registration',
+					'espresso_registrations_restore_registrations',
+					$item->ID()
+				)
+			) {
+				$action['action']   = 'restore_registrations';
+				$restore_lnk_url    = EE_Admin_Page::add_query_args_and_nonce(
+					$action,
+					REG_ADMIN_URL
+				);
+				$actions['restore'] = '<a href="'
+									  . $restore_lnk_url
+									  . '" title="'
+									  . esc_attr__('Restore Registration', 'event_espresso') . '">'
+									  . esc_html__('Restore', 'event_espresso') . '</a>';
+			}
+			if (
+				EE_Registry::instance()->CAP->current_user_can(
+					'ee_delete_registration',
+					'espresso_registrations_ee_delete_registrations',
+					$item->ID()
+				)
+			) {
+				$action['action']  = 'delete_registrations';
+				$delete_lnk_url    = EE_Admin_Page::add_query_args_and_nonce(
+					$action,
+					REG_ADMIN_URL
+				);
+				$actions['delete'] = '<a href="'
+									 . $delete_lnk_url
+									 . '" title="'
+									 . esc_attr__('Delete Registration Permanently', 'event_espresso')
+									 . '">'
+									 . esc_html__('Delete', 'event_espresso')
+									 . '</a>';
+			}
+		}
+		return sprintf('%1$s %2$s', $link, $this->row_actions($actions));
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column_ATT_email(EE_Registration $item)
+	{
+		$attendee = $item->get_first_related('Attendee');
+		return ! $attendee instanceof EE_Attendee
+			? esc_html__('No attached contact record.', 'event_espresso')
+			: $attendee->email();
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 */
+	public function column__REG_count(EE_Registration $item)
+	{
+		return sprintf(esc_html__('%1$s / %2$s', 'event_espresso'), $item->count(), $item->group_size());
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws ReflectionException
+	 */
+	public function column_PRC_amount(EE_Registration $item)
+	{
+		$ticket   = $item->ticket();
+		$req_data = $this->_admin_page->get_request_data();
+		$content  = isset($req_data['event_id']) && $ticket instanceof EE_Ticket
+			? '<span class="TKT_name">' . $ticket->name() . '</span><br />'
+			: '';
+		if ($item->final_price() > 0) {
+			$content .= '<span class="reg-pad-rght">' . $item->pretty_final_price() . '</span>';
+		} else {
+			// free event
+			$content .= '<span class="reg-overview-free-event-spn reg-pad-rght">'
+						. esc_html__('free', 'event_espresso')
+						. '</span>';
+		}
+		return $content;
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws ReflectionException
+	 */
+	public function column__REG_final_price(EE_Registration $item)
+	{
+		$ticket   = $item->ticket();
+		$req_data = $this->_admin_page->get_request_data();
+		$content  = isset($req_data['event_id']) || ! $ticket instanceof EE_Ticket
+			? ''
+			: '<span class="TKT_name">' . $ticket->name() . '</span><br />';
+		$content  .= '<span class="reg-pad-rght">' . $item->pretty_final_price() . '</span>';
+		return $content;
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 */
+	public function column__REG_paid(EE_Registration $item)
+	{
+		$payment_method      = $item->payment_method();
+		$payment_method_name = $payment_method instanceof EE_Payment_Method
+			? $payment_method->admin_name()
+			: esc_html__('Unknown', 'event_espresso');
+		$content             = '<span class="reg-pad-rght">' . $item->pretty_paid() . '</span>';
+		if ($item->paid() > 0) {
+			$content .= '<br><span class="ee-status-text-small">'
+						. sprintf(
+							esc_html__('...via %s', 'event_espresso'),
+							$payment_method_name
+						)
+						. '</span>';
+		}
+		return $content;
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws EntityNotFoundException
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column_TXN_total(EE_Registration $item)
+	{
+		if ($item->transaction()) {
+			$view_txn_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
+				[
+					'action' => 'view_transaction',
+					'TXN_ID' => $item->transaction_ID(),
+				],
+				TXN_ADMIN_URL
+			);
+			return EE_Registry::instance()->CAP->current_user_can(
+				'ee_read_transaction',
+				'espresso_transactions_view_transaction',
+				$item->transaction_ID()
+			)
+				? '<span class="reg-pad-rght"><a class="status-'
+				  . $item->transaction()->status_ID()
+				  . '" href="'
+				  . $view_txn_lnk_url
+				  . '"  title="'
+				  . esc_attr__('View Transaction', 'event_espresso')
+				  . '">'
+				  . $item->transaction()->pretty_total()
+				  . '</a></span>'
+				: '<span class="reg-pad-rght">' . $item->transaction()->pretty_total() . '</span>';
+		} else {
+			return esc_html__("None", "event_espresso");
+		}
+	}
+
+
+	/**
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws EntityNotFoundException
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column_TXN_paid(EE_Registration $item)
+	{
+		if ($item->count() === 1) {
+			$transaction = $item->transaction()
+				? $item->transaction()
+				: EE_Transaction::new_instance();
+			if ($transaction->paid() >= $transaction->total()) {
+				return '<span class="reg-pad-rght"><div class="dashicons dashicons-yes green-icon"></div></span>';
+			} else {
+				$view_txn_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
+					[
+						'action' => 'view_transaction',
+						'TXN_ID' => $item->transaction_ID(),
+					],
+					TXN_ADMIN_URL
+				);
+				return EE_Registry::instance()->CAP->current_user_can(
+					'ee_read_transaction',
+					'espresso_transactions_view_transaction',
+					$item->transaction_ID()
+				)
+					? '<span class="reg-pad-rght"><a class="status-'
+					  . $transaction->status_ID()
+					  . '" href="'
+					  . $view_txn_lnk_url
+					  . '"  title="'
+					  . esc_attr__('View Transaction', 'event_espresso')
+					  . '">'
+					  . $item->transaction()->pretty_paid()
+					  . '</a><span>'
+					: '<span class="reg-pad-rght">' . $item->transaction()->pretty_paid() . '</span>';
+			}
+		}
+		return '&nbsp;';
+	}
+
+
+	/**
+	 * column_actions
+	 *
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 * @throws ReflectionException
+	 */
+	public function column_actions(EE_Registration $item)
+	{
+		$actions  = [];
+		$attendee = $item->attendee();
+		$this->_set_related_details($item);
+
+		// Build row actions
+		if (
+			EE_Registry::instance()->CAP->current_user_can(
+				'ee_read_registration',
+				'espresso_registrations_view_registration',
+				$item->ID()
+			)
+		) {
+			$view_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
+				[
+					'action'  => 'view_registration',
+					'_REG_ID' => $item->ID(),
+				],
+				REG_ADMIN_URL
+			);
+			$actions['view_lnk'] = '
             <li>
                 <a href="' . $view_lnk_url . '" title="'
-                . esc_attr__('View Registration Details', 'event_espresso')
-                . '" class="tiny-text">
+				. esc_attr__('View Registration Details', 'event_espresso')
+				. '" class="tiny-text">
 				    <div class="dashicons dashicons-clipboard"></div>
 			    </a>
 			</li>';
-        }
-
-        if (
-            $attendee instanceof EE_Attendee
-            && EE_Registry::instance()->CAP->current_user_can(
-                'ee_edit_contacts',
-                'espresso_registrations_edit_attendee'
-            )
-        ) {
-            $edit_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
-                [
-                    'action' => 'edit_attendee',
-                    'post'   => $item->attendee_ID(),
-                ],
-                REG_ADMIN_URL
-            );
-            $actions['edit_lnk'] = '
+		}
+
+		if (
+			$attendee instanceof EE_Attendee
+			&& EE_Registry::instance()->CAP->current_user_can(
+				'ee_edit_contacts',
+				'espresso_registrations_edit_attendee'
+			)
+		) {
+			$edit_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
+				[
+					'action' => 'edit_attendee',
+					'post'   => $item->attendee_ID(),
+				],
+				REG_ADMIN_URL
+			);
+			$actions['edit_lnk'] = '
 			<li>
                 <a href="' . $edit_lnk_url . '" title="'
-                . esc_attr__('Edit Contact Details', 'event_espresso')
-                . '" class="tiny-text">
+				. esc_attr__('Edit Contact Details', 'event_espresso')
+				. '" class="tiny-text">
                     <div class="ee-icon ee-icon-user-edit ee-icon-size-16"></div>
                 </a>
 			</li>';
-        }
-
-        if (
-            $attendee instanceof EE_Attendee
-            && EE_Registry::instance()->CAP->current_user_can(
-                'ee_send_message',
-                'espresso_registrations_resend_registration',
-                $item->ID()
-            )
-        ) {
-            $resend_reg_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
-                [
-                    'action'  => 'resend_registration',
-                    '_REG_ID' => $item->ID(),
-                ],
-                REG_ADMIN_URL,
-                true
-            );
-            $actions['resend_reg_lnk'] = '
+		}
+
+		if (
+			$attendee instanceof EE_Attendee
+			&& EE_Registry::instance()->CAP->current_user_can(
+				'ee_send_message',
+				'espresso_registrations_resend_registration',
+				$item->ID()
+			)
+		) {
+			$resend_reg_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
+				[
+					'action'  => 'resend_registration',
+					'_REG_ID' => $item->ID(),
+				],
+				REG_ADMIN_URL,
+				true
+			);
+			$actions['resend_reg_lnk'] = '
 			<li>
 			    <a href="' . $resend_reg_lnk_url . '" title="'
-                . esc_attr__('Resend Registration Details', 'event_espresso')
-                . '" class="tiny-text">
+				. esc_attr__('Resend Registration Details', 'event_espresso')
+				. '" class="tiny-text">
 			        <div class="dashicons dashicons-email-alt"></div>
 			    </a>
             </li>';
-        }
-
-        if (
-            EE_Registry::instance()->CAP->current_user_can(
-                'ee_read_transaction',
-                'espresso_transactions_view_transaction',
-                $this->_transaction_details['id']
-            )
-        ) {
-            $view_txn_lnk_url        = EE_Admin_Page::add_query_args_and_nonce(
-                [
-                    'action' => 'view_transaction',
-                    'TXN_ID' => $this->_transaction_details['id'],
-                ],
-                TXN_ADMIN_URL
-            );
-            $actions['view_txn_lnk'] = '
+		}
+
+		if (
+			EE_Registry::instance()->CAP->current_user_can(
+				'ee_read_transaction',
+				'espresso_transactions_view_transaction',
+				$this->_transaction_details['id']
+			)
+		) {
+			$view_txn_lnk_url        = EE_Admin_Page::add_query_args_and_nonce(
+				[
+					'action' => 'view_transaction',
+					'TXN_ID' => $this->_transaction_details['id'],
+				],
+				TXN_ADMIN_URL
+			);
+			$actions['view_txn_lnk'] = '
 			<li>
                 <a class="ee-status-color-' . $this->_transaction_details['status']
-                . ' tiny-text" href="' . $view_txn_lnk_url
-                . '"  title="' . $this->_transaction_details['title_attr'] . '">
+				. ' tiny-text" href="' . $view_txn_lnk_url
+				. '"  title="' . $this->_transaction_details['title_attr'] . '">
                     <div class="dashicons dashicons-cart"></div>
                 </a>
 			</li>';
-        }
-
-        // only show invoice link if message type is active.
-        if (
-            $attendee instanceof EE_Attendee
-            && $item->is_primary_registrant()
-            && EEH_MSG_Template::is_mt_active('invoice')
-        ) {
-            $actions['dl_invoice_lnk'] = '
+		}
+
+		// only show invoice link if message type is active.
+		if (
+			$attendee instanceof EE_Attendee
+			&& $item->is_primary_registrant()
+			&& EEH_MSG_Template::is_mt_active('invoice')
+		) {
+			$actions['dl_invoice_lnk'] = '
             <li>
                 <a title="' . esc_attr__('View Transaction Invoice', 'event_espresso')
-                . '" target="_blank" href="' . $item->invoice_url() . '" class="tiny-text">
+				. '" target="_blank" href="' . $item->invoice_url() . '" class="tiny-text">
                     <span class="dashicons dashicons-media-spreadsheet ee-icon-size-18"></span>
                 </a>
             </li>';
-        }
+		}
 
-        // message list table link (filtered by REG_ID
-        if (
-            EE_Registry::instance()->CAP->current_user_can('ee_read_global_messages', 'view_filtered_messages')
-        ) {
-            $actions['filtered_messages_link'] = '
+		// message list table link (filtered by REG_ID
+		if (
+			EE_Registry::instance()->CAP->current_user_can('ee_read_global_messages', 'view_filtered_messages')
+		) {
+			$actions['filtered_messages_link'] = '
             <li>
                 ' . EEH_MSG_Template::get_message_action_link(
-                'see_notifications_for',
-                null,
-                ['_REG_ID' => $item->ID()]
-            ) . '
+				'see_notifications_for',
+				null,
+				['_REG_ID' => $item->ID()]
+			) . '
             </li>';
-        }
+		}
 
-        $actions = apply_filters('FHEE__EE_Registrations_List_Table__column_actions__actions', $actions, $item, $this);
-        return $this->_action_string(implode('', $actions), $item, 'ul', 'reg-overview-actions-ul');
-    }
+		$actions = apply_filters('FHEE__EE_Registrations_List_Table__column_actions__actions', $actions, $item, $this);
+		return $this->_action_string(implode('', $actions), $item, 'ul', 'reg-overview-actions-ul');
+	}
 }

caffeinated/admin/extend/registrations/EE_Event_Registrations_List_Table.class.php

Indentation +563 added lines, -563 removed lines

@@ -12,572 +12,572 @@
 class EE_Event_Registrations_List_Table extends EE_Admin_List_Table
 {
 
-    /**
-     * This property will hold the related Datetimes on an event IF the event id is included in the request.
-     *
-     * @var EE_Datetime[]
-     */
-    protected $_dtts_for_event = array();
-
-
-    /**
-     * The event if one is specified in the request
-     *
-     * @var EE_Event
-     */
-    protected $_evt = null;
-
-
-    /**
-     * The DTT_ID if the current view has a specified datetime.
-     *
-     * @var int $_cur_dtt_id
-     */
-    protected $_cur_dtt_id = 0;
-
-
-    /**
-     * EE_Event_Registrations_List_Table constructor.
-     *
-     * @param \Registrations_Admin_Page $admin_page
-     */
-    public function __construct($admin_page)
-    {
-        parent::__construct($admin_page);
-        $this->_status = $this->_admin_page->get_registration_status_array();
-    }
-
-
-    protected function _setup_data()
-    {
-        $this->_data = $this->_view !== 'trash' ? $this->_admin_page->get_event_attendees($this->_per_page)
-            : $this->_admin_page->get_event_attendees($this->_per_page, false, true);
-        $this->_all_data_count = $this->_view !== 'trash' ? $this->_admin_page->get_event_attendees(
-            $this->_per_page,
-            true
-        ) : $this->_admin_page->get_event_attendees($this->_per_page, true, true);
-    }
-
-
-    protected function _set_properties()
-    {
-        $return_url = $this->getReturnUrl();
-
-        $evt_id = isset($this->_req_data['event_id']) ? $this->_req_data['event_id'] : null;
-        $this->_wp_list_args = array(
-            'singular' => esc_html__('registrant', 'event_espresso'),
-            'plural'   => esc_html__('registrants', 'event_espresso'),
-            'ajax'     => true,
-            'screen'   => $this->_admin_page->get_current_screen()->id,
-        );
-        $columns = array();
-        // $columns['_Reg_Status'] = '';
-        $this->_columns = array(
-            '_REG_att_checked_in' => '<span class="dashicons dashicons-yes ee-icon-size-18"></span>',
-            'ATT_name'            => esc_html__('Registrant', 'event_espresso'),
-            'ATT_email'           => esc_html__('Email Address', 'event_espresso'),
-            'Event'               => esc_html__('Event', 'event_espresso'),
-            'PRC_name'            => esc_html__('TKT Option', 'event_espresso'),
-            '_REG_final_price'    => esc_html__('Price', 'event_espresso'),
-            'TXN_paid'            => esc_html__('Paid', 'event_espresso'),
-            'TXN_total'           => esc_html__('Total', 'event_espresso'),
-        );
-        // Add/remove columns when an event has been selected
-        if (! empty($evt_id)) {
-            // Render a checkbox column
-            $columns['cb'] = '<input type="checkbox" />';
-            $this->_has_checkbox_column = true;
-            // Remove the 'Event' column
-            unset($this->_columns['Event']);
-        }
-        $this->_columns = array_merge($columns, $this->_columns);
-        $this->_primary_column = '_REG_att_checked_in';
-        if (
-            ! empty($evt_id)
-            && EE_Registry::instance()->CAP->current_user_can(
-                'ee_read_registrations',
-                'espresso_registrations_registrations_reports',
-                $evt_id
-            )
-        ) {
-            $this->_bottom_buttons = array(
-                'report' => array(
-                    'route'         => 'registrations_report',
-                    'extra_request' =>
-                        array(
-                            'EVT_ID'     => $evt_id,
-                            'return_url' => $return_url,
-                            'incude_checkins' => true,
-                        ),
-                ),
-            );
-        }
-        $this->_bottom_buttons['report_filtered'] = array(
-            'route'         => 'registrations_checkin_report',
-            'extra_request' => array(
-                'use_filters' => true,
-                'incude_checkins' => $evt_id ? true : false,
-                'filters'     => array_merge(
-                    array(
-                        'EVT_ID' => $evt_id,
-                    ),
-                    array_diff_key(
-                        $this->_req_data,
-                        array_flip(
-                            array(
-                                'page',
-                                'action',
-                                'default_nonce',
-                            )
-                        )
-                    )
-                ),
-                'return_url'  => $return_url,
-            ),
-        );
-        $this->_sortable_columns = array(
-            /**
-             * Allows users to change the default sort if they wish.
-             * Returning a falsey on this filter will result in the default sort to be by firstname rather than last name.
-             *
-             * Note: usual naming conventions for filters aren't followed here so that just one filter can be used to
-             * change the sorts on any list table involving registration contacts.  If you want to only change the filter
-             * for a specific list table you can use the provided reference to this object instance.
-             */
-            'ATT_name' => array(
-                'FHEE__EE_Registrations_List_Table___set_properties__default_sort_by_registration_last_name',
-                true,
-                $this,
-            )
-                ? array('ATT_lname' => true)
-                : array('ATT_fname' => true),
-            'Event'    => array('Event.EVT_name' => false),
-        );
-        $this->_hidden_columns = array();
-        $this->_evt = EEM_Event::instance()->get_one_by_ID($evt_id);
-        $this->_dtts_for_event = $this->_evt instanceof EE_Event ? $this->_evt->datetimes_ordered() : array();
-    }
-
-
-    /**
-     * @param \EE_Registration $item
-     * @return string
-     */
-    protected function _get_row_class($item)
-    {
-        $class = parent::_get_row_class($item);
-        // add status class
-        $class .= ' ee-status-strip reg-status-' . $item->status_ID();
-        if ($this->_has_checkbox_column) {
-            $class .= ' has-checkbox-column';
-        }
-        return $class;
-    }
-
-
-    /**
-     * @return array
-     * @throws \EE_Error
-     */
-    protected function _get_table_filters()
-    {
-        $filters = $where = array();
-        $current_EVT_ID = isset($this->_req_data['event_id']) ? (int) $this->_req_data['event_id'] : 0;
-        if (empty($this->_dtts_for_event) || count($this->_dtts_for_event) === 1) {
-            // this means we don't have an event so let's setup a filter dropdown for all the events to select
-            // note possible capability restrictions
-            if (! EE_Registry::instance()->CAP->current_user_can('ee_read_private_events', 'get_events')) {
-                $where['status**'] = array('!=', 'private');
-            }
-            if (! EE_Registry::instance()->CAP->current_user_can('ee_read_others_events', 'get_events')) {
-                $where['EVT_wp_user'] = get_current_user_id();
-            }
-            $events = EEM_Event::instance()->get_all(
-                array(
-                    $where,
-                    'order_by' => array('Datetime.DTT_EVT_start' => 'DESC'),
-                )
-            );
-            $evts[] = array(
-                'id'   => 0,
-                'text' => esc_html__('To toggle Check-in status, select an event', 'event_espresso'),
-            );
-            $checked = 'checked';
-            /** @var EE_Event $evt */
-            foreach ($events as $evt) {
-                // any registrations for this event?
-                if (! $evt->get_count_of_all_registrations()) {
-                    continue;
-                }
-                $evts[] = array(
-                    'id'    => $evt->ID(),
-                    'text'  => apply_filters(
-                        'FHEE__EE_Event_Registrations___get_table_filters__event_name',
-                        $evt->get('EVT_name'),
-                        $evt
-                    ),
-                    'class' => $evt->is_expired() ? 'ee-expired-event' : '',
-                );
-                if ($evt->ID() === $current_EVT_ID && $evt->is_expired()) {
-                    $checked = '';
-                }
-            }
-            $event_filter = '<div class="ee-event-filter">';
-            $event_filter .= EEH_Form_Fields::select_input('event_id', $evts, $current_EVT_ID);
-            $event_filter .= '<span class="ee-event-filter-toggle">';
-            $event_filter .= '<input type="checkbox" id="js-ee-hide-expired-events" ' . $checked . '> ';
-            $event_filter .= esc_html__('Hide Expired Events', 'event_espresso');
-            $event_filter .= '</span>';
-            $event_filter .= '</div>';
-            $filters[] = $event_filter;
-        }
-        if (! empty($this->_dtts_for_event)) {
-            // DTT datetimes filter
-            $this->_cur_dtt_id = isset($this->_req_data['DTT_ID']) ? $this->_req_data['DTT_ID'] : 0;
-            if (count($this->_dtts_for_event) > 1) {
-                $dtts[0] = esc_html__('To toggle check-in status, select a datetime.', 'event_espresso');
-                foreach ($this->_dtts_for_event as $dtt) {
-                    $datetime_string = $dtt->name();
-                    $datetime_string = ! empty($datetime_string) ? ' (' . $datetime_string . ')' : '';
-                    $datetime_string = $dtt->start_date_and_time() . ' - ' . $dtt->end_date_and_time() . $datetime_string;
-                    $dtts[ $dtt->ID() ] = $datetime_string;
-                }
-                $input = new EE_Select_Input(
-                    $dtts,
-                    array(
-                        'html_name' => 'DTT_ID',
-                        'html_id'   => 'DTT_ID',
-                        'default'   => $this->_cur_dtt_id,
-                    )
-                );
-                $filters[] = $input->get_html_for_input();
-                $filters[] = '<input type="hidden" name="event_id" value="' . $current_EVT_ID . '">';
-            }
-        }
-        return $filters;
-    }
-
-
-    protected function _add_view_counts()
-    {
-        $this->_views['all']['count'] = $this->_get_total_event_attendees();
-    }
-
-
-    /**
-     * @return int
-     * @throws \EE_Error
-     */
-    protected function _get_total_event_attendees()
-    {
-        $EVT_ID = isset($this->_req_data['event_id']) ? absint($this->_req_data['event_id']) : false;
-        $DTT_ID = $this->_cur_dtt_id;
-        $query_params = array();
-        if ($EVT_ID) {
-            $query_params[0]['EVT_ID'] = $EVT_ID;
-        }
-        // if DTT is included we only show for that datetime.  Otherwise we're showing for all datetimes (the event).
-        if ($DTT_ID) {
-            $query_params[0]['Ticket.Datetime.DTT_ID'] = $DTT_ID;
-        }
-        $status_ids_array = apply_filters(
-            'FHEE__Extend_Registrations_Admin_Page__get_event_attendees__status_ids_array',
-            array(EEM_Registration::status_id_pending_payment, EEM_Registration::status_id_approved)
-        );
-        $query_params[0]['STS_ID'] = array('IN', $status_ids_array);
-        return EEM_Registration::instance()->count($query_params);
-    }
-
-
-    /**
-     * @param \EE_Registration $item
-     * @return string
-     */
-    public function column__Reg_Status(EE_Registration $item)
-    {
-        return '<span class="ee-status-strip ee-status-strip-td reg-status-' . $item->status_ID() . '"></span>';
-    }
-
-
-    /**
-     * @param \EE_Registration $item
-     * @return string
-     * @throws \EE_Error
-     */
-    public function column_cb($item)
-    {
-        return sprintf('<input type="checkbox" name="checkbox[%1$s]" value="%1$s" />', $item->ID());
-    }
-
-
-    /**
-     * column_REG_att_checked_in
-     *
-     * @param EE_Registration $item
-     * @return string
-     * @throws EE_Error
-     * @throws InvalidArgumentException
-     * @throws InvalidDataTypeException
-     * @throws InvalidInterfaceException
-     */
-    public function column__REG_att_checked_in(EE_Registration $item)
-    {
-        $attendee = $item->attendee();
-        $attendee_name = $attendee instanceof EE_Attendee ? $attendee->full_name() : '';
-
-        if ($this->_cur_dtt_id === 0 && count($this->_dtts_for_event) === 1) {
-            $latest_related_datetime = $item->get_latest_related_datetime();
-            if ($latest_related_datetime instanceof EE_Datetime) {
-                $this->_cur_dtt_id = $latest_related_datetime->ID();
-            }
-        }
-        $checkin_status_dashicon = CheckinStatusDashicon::fromRegistrationAndDatetimeId(
-            $item,
-            $this->_cur_dtt_id
-        );
-        $nonce = wp_create_nonce('checkin_nonce');
-        $toggle_active = ! empty($this->_cur_dtt_id)
-                         && EE_Registry::instance()->CAP->current_user_can(
-                             'ee_edit_checkin',
-                             'espresso_registrations_toggle_checkin_status',
-                             $item->ID()
-                         )
-            ? ' clickable trigger-checkin'
-            : '';
-        $mobile_view_content = ' <span class="show-on-mobile-view-only">' . $attendee_name . '</span>';
-        return '<span class="' . $checkin_status_dashicon->cssClasses() . $toggle_active . '"'
-               . ' data-_regid="' . $item->ID() . '"'
-               . ' data-dttid="' . $this->_cur_dtt_id . '"'
-               . ' data-nonce="' . $nonce . '">'
-               . '</span>'
-               . $mobile_view_content;
-    }
-
-
-    /**
-     * @param \EE_Registration $item
-     * @return mixed|string|void
-     * @throws \EE_Error
-     */
-    public function column_ATT_name(EE_Registration $item)
-    {
-        $attendee = $item->attendee();
-        if (! $attendee instanceof EE_Attendee) {
-            return esc_html__('No contact record for this registration.', 'event_espresso');
-        }
-        // edit attendee link
-        $edit_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
-            array('action' => 'view_registration', '_REG_ID' => $item->ID()),
-            REG_ADMIN_URL
-        );
-        $name_link = EE_Registry::instance()->CAP->current_user_can(
-            'ee_edit_contacts',
-            'espresso_registrations_edit_attendee'
-        )
-            ? '<a href="' . $edit_lnk_url . '" title="' . esc_attr__('View Registration Details', 'event_espresso') . '">'
-              . $item->attendee()->full_name()
-              . '</a>'
-            : $item->attendee()->full_name();
-        $name_link .= $item->count() === 1
-            ? '&nbsp;<sup><div class="dashicons dashicons-star-filled lt-blue-icon ee-icon-size-8"></div></sup>	'
-            : '';
-        // add group details
-        $name_link .= '&nbsp;' . sprintf(esc_html__('(%s of %s)', 'event_espresso'), $item->count(), $item->group_size());
-        // add regcode
-        $link = EE_Admin_Page::add_query_args_and_nonce(
-            array('action' => 'view_registration', '_REG_ID' => $item->ID()),
-            REG_ADMIN_URL
-        );
-        $name_link .= '<br>';
-        $name_link .= EE_Registry::instance()->instance()->CAP->current_user_can(
-            'ee_read_registration',
-            'view_registration',
-            $item->ID()
-        )
-            ? '<a href="' . $link . '" title="' . esc_attr__('View Registration Details', 'event_espresso') . '">'
-              . $item->reg_code()
-              . '</a>'
-            : $item->reg_code();
-        // status
-        $name_link .= '<br><span class="ee-status-text-small">';
-        $name_link .= EEH_Template::pretty_status($item->status_ID(), false, 'sentence');
-        $name_link .= '</span>';
-        $actions = array();
-        $DTT_ID = $this->_cur_dtt_id;
-        $latest_related_datetime = empty($DTT_ID) && ! empty($this->_req_data['event_id']) && $item instanceof EE_Registration
-            ? $item->get_latest_related_datetime()
-            : null;
-        $DTT_ID = $latest_related_datetime instanceof EE_Datetime
-            ? $latest_related_datetime->ID()
-            : $DTT_ID;
-        if (
-            ! empty($DTT_ID)
-            && EE_Registry::instance()->CAP->current_user_can(
-                'ee_read_checkins',
-                'espresso_registrations_registration_checkins'
-            )
-        ) {
-            $checkin_list_url = EE_Admin_Page::add_query_args_and_nonce(
-                array('action' => 'registration_checkins', '_REG_ID' => $item->ID(), 'DTT_ID' => $DTT_ID),
-                REG_ADMIN_URL
-            );
-            // get the timestamps for this registration's checkins, related to the selected datetime
-            $timestamps = $item->get_many_related('Checkin', array(array('DTT_ID' => $DTT_ID)));
-            if (! empty($timestamps)) {
-                // get the last timestamp
-                $last_timestamp = end($timestamps);
-                // checked in or checked out?
-                $checkin_status = $last_timestamp->get('CHK_in')
-                    ? esc_html__('Checked In', 'event_espresso')
-                    : esc_html__('Checked Out', 'event_espresso');
-                // get timestamp string
-                $timestamp_string = $last_timestamp->get_datetime('CHK_timestamp');
-                $actions['checkin'] = '<a href="' . $checkin_list_url . '" title="'
-                                      . esc_attr__(
-                                          'View this registrant\'s check-ins/checkouts for the datetime',
-                                          'event_espresso'
-                                      ) . '">' . $checkin_status . ': ' . $timestamp_string . '</a>';
-            }
-        }
-        return (! empty($DTT_ID) && ! empty($timestamps))
-            ? sprintf('%1$s %2$s', $name_link, $this->row_actions($actions, true))
-            : $name_link;
-    }
-
-
-    /**
-     * @param \EE_Registration $item
-     * @return string
-     */
-    public function column_ATT_email(EE_Registration $item)
-    {
-        $attendee = $item->attendee();
-        return $attendee instanceof EE_Attendee ? $attendee->email() : '';
-    }
-
-
-    /**
-     * @param \EE_Registration $item
-     * @return bool|string
-     * @throws \EE_Error
-     */
-    public function column_Event(EE_Registration $item)
-    {
-        try {
-            $event = $this->_evt instanceof EE_Event ? $this->_evt : $item->event();
-            $chkin_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
-                array('action' => 'event_registrations', 'event_id' => $event->ID()),
-                REG_ADMIN_URL
-            );
-            $event_label = EE_Registry::instance()->CAP->current_user_can(
-                'ee_read_checkins',
-                'espresso_registrations_registration_checkins'
-            ) ? '<a href="' . $chkin_lnk_url . '" title="'
-                . esc_attr__(
-                    'View Checkins for this Event',
-                    'event_espresso'
-                ) . '">' . $event->name() . '</a>' : $event->name();
-        } catch (\EventEspresso\core\exceptions\EntityNotFoundException $e) {
-            $event_label = esc_html__('Unknown', 'event_espresso');
-        }
-        return $event_label;
-    }
-
-
-    /**
-     * @param \EE_Registration $item
-     * @return mixed|string|void
-     */
-    public function column_PRC_name(EE_Registration $item)
-    {
-        return $item->ticket() instanceof EE_Ticket ? $item->ticket()->name() : esc_html__("Unknown", "event_espresso");
-    }
-
-
-    /**
-     * column_REG_final_price
-     *
-     * @param \EE_Registration $item
-     * @return string
-     */
-    public function column__REG_final_price(EE_Registration $item)
-    {
-        return '<span class="reg-pad-rght">' . ' ' . $item->pretty_final_price() . '</span>';
-    }
-
-
-    /**
-     * column_TXN_paid
-     *
-     * @param \EE_Registration $item
-     * @return string
-     * @throws \EE_Error
-     */
-    public function column_TXN_paid(EE_Registration $item)
-    {
-        if ($item->count() === 1) {
-            if ($item->transaction()->paid() >= $item->transaction()->total()) {
-                return '<span class="reg-pad-rght"><div class="dashicons dashicons-yes green-icon"></div></span>';
-            } else {
-                $view_txn_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
-                    array('action' => 'view_transaction', 'TXN_ID' => $item->transaction_ID()),
-                    TXN_ADMIN_URL
-                );
-                return EE_Registry::instance()->CAP->current_user_can(
-                    'ee_read_transaction',
-                    'espresso_transactions_view_transaction'
-                ) ? '
+	/**
+	 * This property will hold the related Datetimes on an event IF the event id is included in the request.
+	 *
+	 * @var EE_Datetime[]
+	 */
+	protected $_dtts_for_event = array();
+
+
+	/**
+	 * The event if one is specified in the request
+	 *
+	 * @var EE_Event
+	 */
+	protected $_evt = null;
+
+
+	/**
+	 * The DTT_ID if the current view has a specified datetime.
+	 *
+	 * @var int $_cur_dtt_id
+	 */
+	protected $_cur_dtt_id = 0;
+
+
+	/**
+	 * EE_Event_Registrations_List_Table constructor.
+	 *
+	 * @param \Registrations_Admin_Page $admin_page
+	 */
+	public function __construct($admin_page)
+	{
+		parent::__construct($admin_page);
+		$this->_status = $this->_admin_page->get_registration_status_array();
+	}
+
+
+	protected function _setup_data()
+	{
+		$this->_data = $this->_view !== 'trash' ? $this->_admin_page->get_event_attendees($this->_per_page)
+			: $this->_admin_page->get_event_attendees($this->_per_page, false, true);
+		$this->_all_data_count = $this->_view !== 'trash' ? $this->_admin_page->get_event_attendees(
+			$this->_per_page,
+			true
+		) : $this->_admin_page->get_event_attendees($this->_per_page, true, true);
+	}
+
+
+	protected function _set_properties()
+	{
+		$return_url = $this->getReturnUrl();
+
+		$evt_id = isset($this->_req_data['event_id']) ? $this->_req_data['event_id'] : null;
+		$this->_wp_list_args = array(
+			'singular' => esc_html__('registrant', 'event_espresso'),
+			'plural'   => esc_html__('registrants', 'event_espresso'),
+			'ajax'     => true,
+			'screen'   => $this->_admin_page->get_current_screen()->id,
+		);
+		$columns = array();
+		// $columns['_Reg_Status'] = '';
+		$this->_columns = array(
+			'_REG_att_checked_in' => '<span class="dashicons dashicons-yes ee-icon-size-18"></span>',
+			'ATT_name'            => esc_html__('Registrant', 'event_espresso'),
+			'ATT_email'           => esc_html__('Email Address', 'event_espresso'),
+			'Event'               => esc_html__('Event', 'event_espresso'),
+			'PRC_name'            => esc_html__('TKT Option', 'event_espresso'),
+			'_REG_final_price'    => esc_html__('Price', 'event_espresso'),
+			'TXN_paid'            => esc_html__('Paid', 'event_espresso'),
+			'TXN_total'           => esc_html__('Total', 'event_espresso'),
+		);
+		// Add/remove columns when an event has been selected
+		if (! empty($evt_id)) {
+			// Render a checkbox column
+			$columns['cb'] = '<input type="checkbox" />';
+			$this->_has_checkbox_column = true;
+			// Remove the 'Event' column
+			unset($this->_columns['Event']);
+		}
+		$this->_columns = array_merge($columns, $this->_columns);
+		$this->_primary_column = '_REG_att_checked_in';
+		if (
+			! empty($evt_id)
+			&& EE_Registry::instance()->CAP->current_user_can(
+				'ee_read_registrations',
+				'espresso_registrations_registrations_reports',
+				$evt_id
+			)
+		) {
+			$this->_bottom_buttons = array(
+				'report' => array(
+					'route'         => 'registrations_report',
+					'extra_request' =>
+						array(
+							'EVT_ID'     => $evt_id,
+							'return_url' => $return_url,
+							'incude_checkins' => true,
+						),
+				),
+			);
+		}
+		$this->_bottom_buttons['report_filtered'] = array(
+			'route'         => 'registrations_checkin_report',
+			'extra_request' => array(
+				'use_filters' => true,
+				'incude_checkins' => $evt_id ? true : false,
+				'filters'     => array_merge(
+					array(
+						'EVT_ID' => $evt_id,
+					),
+					array_diff_key(
+						$this->_req_data,
+						array_flip(
+							array(
+								'page',
+								'action',
+								'default_nonce',
+							)
+						)
+					)
+				),
+				'return_url'  => $return_url,
+			),
+		);
+		$this->_sortable_columns = array(
+			/**
+			 * Allows users to change the default sort if they wish.
+			 * Returning a falsey on this filter will result in the default sort to be by firstname rather than last name.
+			 *
+			 * Note: usual naming conventions for filters aren't followed here so that just one filter can be used to
+			 * change the sorts on any list table involving registration contacts.  If you want to only change the filter
+			 * for a specific list table you can use the provided reference to this object instance.
+			 */
+			'ATT_name' => array(
+				'FHEE__EE_Registrations_List_Table___set_properties__default_sort_by_registration_last_name',
+				true,
+				$this,
+			)
+				? array('ATT_lname' => true)
+				: array('ATT_fname' => true),
+			'Event'    => array('Event.EVT_name' => false),
+		);
+		$this->_hidden_columns = array();
+		$this->_evt = EEM_Event::instance()->get_one_by_ID($evt_id);
+		$this->_dtts_for_event = $this->_evt instanceof EE_Event ? $this->_evt->datetimes_ordered() : array();
+	}
+
+
+	/**
+	 * @param \EE_Registration $item
+	 * @return string
+	 */
+	protected function _get_row_class($item)
+	{
+		$class = parent::_get_row_class($item);
+		// add status class
+		$class .= ' ee-status-strip reg-status-' . $item->status_ID();
+		if ($this->_has_checkbox_column) {
+			$class .= ' has-checkbox-column';
+		}
+		return $class;
+	}
+
+
+	/**
+	 * @return array
+	 * @throws \EE_Error
+	 */
+	protected function _get_table_filters()
+	{
+		$filters = $where = array();
+		$current_EVT_ID = isset($this->_req_data['event_id']) ? (int) $this->_req_data['event_id'] : 0;
+		if (empty($this->_dtts_for_event) || count($this->_dtts_for_event) === 1) {
+			// this means we don't have an event so let's setup a filter dropdown for all the events to select
+			// note possible capability restrictions
+			if (! EE_Registry::instance()->CAP->current_user_can('ee_read_private_events', 'get_events')) {
+				$where['status**'] = array('!=', 'private');
+			}
+			if (! EE_Registry::instance()->CAP->current_user_can('ee_read_others_events', 'get_events')) {
+				$where['EVT_wp_user'] = get_current_user_id();
+			}
+			$events = EEM_Event::instance()->get_all(
+				array(
+					$where,
+					'order_by' => array('Datetime.DTT_EVT_start' => 'DESC'),
+				)
+			);
+			$evts[] = array(
+				'id'   => 0,
+				'text' => esc_html__('To toggle Check-in status, select an event', 'event_espresso'),
+			);
+			$checked = 'checked';
+			/** @var EE_Event $evt */
+			foreach ($events as $evt) {
+				// any registrations for this event?
+				if (! $evt->get_count_of_all_registrations()) {
+					continue;
+				}
+				$evts[] = array(
+					'id'    => $evt->ID(),
+					'text'  => apply_filters(
+						'FHEE__EE_Event_Registrations___get_table_filters__event_name',
+						$evt->get('EVT_name'),
+						$evt
+					),
+					'class' => $evt->is_expired() ? 'ee-expired-event' : '',
+				);
+				if ($evt->ID() === $current_EVT_ID && $evt->is_expired()) {
+					$checked = '';
+				}
+			}
+			$event_filter = '<div class="ee-event-filter">';
+			$event_filter .= EEH_Form_Fields::select_input('event_id', $evts, $current_EVT_ID);
+			$event_filter .= '<span class="ee-event-filter-toggle">';
+			$event_filter .= '<input type="checkbox" id="js-ee-hide-expired-events" ' . $checked . '> ';
+			$event_filter .= esc_html__('Hide Expired Events', 'event_espresso');
+			$event_filter .= '</span>';
+			$event_filter .= '</div>';
+			$filters[] = $event_filter;
+		}
+		if (! empty($this->_dtts_for_event)) {
+			// DTT datetimes filter
+			$this->_cur_dtt_id = isset($this->_req_data['DTT_ID']) ? $this->_req_data['DTT_ID'] : 0;
+			if (count($this->_dtts_for_event) > 1) {
+				$dtts[0] = esc_html__('To toggle check-in status, select a datetime.', 'event_espresso');
+				foreach ($this->_dtts_for_event as $dtt) {
+					$datetime_string = $dtt->name();
+					$datetime_string = ! empty($datetime_string) ? ' (' . $datetime_string . ')' : '';
+					$datetime_string = $dtt->start_date_and_time() . ' - ' . $dtt->end_date_and_time() . $datetime_string;
+					$dtts[ $dtt->ID() ] = $datetime_string;
+				}
+				$input = new EE_Select_Input(
+					$dtts,
+					array(
+						'html_name' => 'DTT_ID',
+						'html_id'   => 'DTT_ID',
+						'default'   => $this->_cur_dtt_id,
+					)
+				);
+				$filters[] = $input->get_html_for_input();
+				$filters[] = '<input type="hidden" name="event_id" value="' . $current_EVT_ID . '">';
+			}
+		}
+		return $filters;
+	}
+
+
+	protected function _add_view_counts()
+	{
+		$this->_views['all']['count'] = $this->_get_total_event_attendees();
+	}
+
+
+	/**
+	 * @return int
+	 * @throws \EE_Error
+	 */
+	protected function _get_total_event_attendees()
+	{
+		$EVT_ID = isset($this->_req_data['event_id']) ? absint($this->_req_data['event_id']) : false;
+		$DTT_ID = $this->_cur_dtt_id;
+		$query_params = array();
+		if ($EVT_ID) {
+			$query_params[0]['EVT_ID'] = $EVT_ID;
+		}
+		// if DTT is included we only show for that datetime.  Otherwise we're showing for all datetimes (the event).
+		if ($DTT_ID) {
+			$query_params[0]['Ticket.Datetime.DTT_ID'] = $DTT_ID;
+		}
+		$status_ids_array = apply_filters(
+			'FHEE__Extend_Registrations_Admin_Page__get_event_attendees__status_ids_array',
+			array(EEM_Registration::status_id_pending_payment, EEM_Registration::status_id_approved)
+		);
+		$query_params[0]['STS_ID'] = array('IN', $status_ids_array);
+		return EEM_Registration::instance()->count($query_params);
+	}
+
+
+	/**
+	 * @param \EE_Registration $item
+	 * @return string
+	 */
+	public function column__Reg_Status(EE_Registration $item)
+	{
+		return '<span class="ee-status-strip ee-status-strip-td reg-status-' . $item->status_ID() . '"></span>';
+	}
+
+
+	/**
+	 * @param \EE_Registration $item
+	 * @return string
+	 * @throws \EE_Error
+	 */
+	public function column_cb($item)
+	{
+		return sprintf('<input type="checkbox" name="checkbox[%1$s]" value="%1$s" />', $item->ID());
+	}
+
+
+	/**
+	 * column_REG_att_checked_in
+	 *
+	 * @param EE_Registration $item
+	 * @return string
+	 * @throws EE_Error
+	 * @throws InvalidArgumentException
+	 * @throws InvalidDataTypeException
+	 * @throws InvalidInterfaceException
+	 */
+	public function column__REG_att_checked_in(EE_Registration $item)
+	{
+		$attendee = $item->attendee();
+		$attendee_name = $attendee instanceof EE_Attendee ? $attendee->full_name() : '';
+
+		if ($this->_cur_dtt_id === 0 && count($this->_dtts_for_event) === 1) {
+			$latest_related_datetime = $item->get_latest_related_datetime();
+			if ($latest_related_datetime instanceof EE_Datetime) {
+				$this->_cur_dtt_id = $latest_related_datetime->ID();
+			}
+		}
+		$checkin_status_dashicon = CheckinStatusDashicon::fromRegistrationAndDatetimeId(
+			$item,
+			$this->_cur_dtt_id
+		);
+		$nonce = wp_create_nonce('checkin_nonce');
+		$toggle_active = ! empty($this->_cur_dtt_id)
+						 && EE_Registry::instance()->CAP->current_user_can(
+							 'ee_edit_checkin',
+							 'espresso_registrations_toggle_checkin_status',
+							 $item->ID()
+						 )
+			? ' clickable trigger-checkin'
+			: '';
+		$mobile_view_content = ' <span class="show-on-mobile-view-only">' . $attendee_name . '</span>';
+		return '<span class="' . $checkin_status_dashicon->cssClasses() . $toggle_active . '"'
+			   . ' data-_regid="' . $item->ID() . '"'
+			   . ' data-dttid="' . $this->_cur_dtt_id . '"'
+			   . ' data-nonce="' . $nonce . '">'
+			   . '</span>'
+			   . $mobile_view_content;
+	}
+
+
+	/**
+	 * @param \EE_Registration $item
+	 * @return mixed|string|void
+	 * @throws \EE_Error
+	 */
+	public function column_ATT_name(EE_Registration $item)
+	{
+		$attendee = $item->attendee();
+		if (! $attendee instanceof EE_Attendee) {
+			return esc_html__('No contact record for this registration.', 'event_espresso');
+		}
+		// edit attendee link
+		$edit_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
+			array('action' => 'view_registration', '_REG_ID' => $item->ID()),
+			REG_ADMIN_URL
+		);
+		$name_link = EE_Registry::instance()->CAP->current_user_can(
+			'ee_edit_contacts',
+			'espresso_registrations_edit_attendee'
+		)
+			? '<a href="' . $edit_lnk_url . '" title="' . esc_attr__('View Registration Details', 'event_espresso') . '">'
+			  . $item->attendee()->full_name()
+			  . '</a>'
+			: $item->attendee()->full_name();
+		$name_link .= $item->count() === 1
+			? '&nbsp;<sup><div class="dashicons dashicons-star-filled lt-blue-icon ee-icon-size-8"></div></sup>	'
+			: '';
+		// add group details
+		$name_link .= '&nbsp;' . sprintf(esc_html__('(%s of %s)', 'event_espresso'), $item->count(), $item->group_size());
+		// add regcode
+		$link = EE_Admin_Page::add_query_args_and_nonce(
+			array('action' => 'view_registration', '_REG_ID' => $item->ID()),
+			REG_ADMIN_URL
+		);
+		$name_link .= '<br>';
+		$name_link .= EE_Registry::instance()->instance()->CAP->current_user_can(
+			'ee_read_registration',
+			'view_registration',
+			$item->ID()
+		)
+			? '<a href="' . $link . '" title="' . esc_attr__('View Registration Details', 'event_espresso') . '">'
+			  . $item->reg_code()
+			  . '</a>'
+			: $item->reg_code();
+		// status
+		$name_link .= '<br><span class="ee-status-text-small">';
+		$name_link .= EEH_Template::pretty_status($item->status_ID(), false, 'sentence');
+		$name_link .= '</span>';
+		$actions = array();
+		$DTT_ID = $this->_cur_dtt_id;
+		$latest_related_datetime = empty($DTT_ID) && ! empty($this->_req_data['event_id']) && $item instanceof EE_Registration
+			? $item->get_latest_related_datetime()
+			: null;
+		$DTT_ID = $latest_related_datetime instanceof EE_Datetime
+			? $latest_related_datetime->ID()
+			: $DTT_ID;
+		if (
+			! empty($DTT_ID)
+			&& EE_Registry::instance()->CAP->current_user_can(
+				'ee_read_checkins',
+				'espresso_registrations_registration_checkins'
+			)
+		) {
+			$checkin_list_url = EE_Admin_Page::add_query_args_and_nonce(
+				array('action' => 'registration_checkins', '_REG_ID' => $item->ID(), 'DTT_ID' => $DTT_ID),
+				REG_ADMIN_URL
+			);
+			// get the timestamps for this registration's checkins, related to the selected datetime
+			$timestamps = $item->get_many_related('Checkin', array(array('DTT_ID' => $DTT_ID)));
+			if (! empty($timestamps)) {
+				// get the last timestamp
+				$last_timestamp = end($timestamps);
+				// checked in or checked out?
+				$checkin_status = $last_timestamp->get('CHK_in')
+					? esc_html__('Checked In', 'event_espresso')
+					: esc_html__('Checked Out', 'event_espresso');
+				// get timestamp string
+				$timestamp_string = $last_timestamp->get_datetime('CHK_timestamp');
+				$actions['checkin'] = '<a href="' . $checkin_list_url . '" title="'
+									  . esc_attr__(
+										  'View this registrant\'s check-ins/checkouts for the datetime',
+										  'event_espresso'
+									  ) . '">' . $checkin_status . ': ' . $timestamp_string . '</a>';
+			}
+		}
+		return (! empty($DTT_ID) && ! empty($timestamps))
+			? sprintf('%1$s %2$s', $name_link, $this->row_actions($actions, true))
+			: $name_link;
+	}
+
+
+	/**
+	 * @param \EE_Registration $item
+	 * @return string
+	 */
+	public function column_ATT_email(EE_Registration $item)
+	{
+		$attendee = $item->attendee();
+		return $attendee instanceof EE_Attendee ? $attendee->email() : '';
+	}
+
+
+	/**
+	 * @param \EE_Registration $item
+	 * @return bool|string
+	 * @throws \EE_Error
+	 */
+	public function column_Event(EE_Registration $item)
+	{
+		try {
+			$event = $this->_evt instanceof EE_Event ? $this->_evt : $item->event();
+			$chkin_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
+				array('action' => 'event_registrations', 'event_id' => $event->ID()),
+				REG_ADMIN_URL
+			);
+			$event_label = EE_Registry::instance()->CAP->current_user_can(
+				'ee_read_checkins',
+				'espresso_registrations_registration_checkins'
+			) ? '<a href="' . $chkin_lnk_url . '" title="'
+				. esc_attr__(
+					'View Checkins for this Event',
+					'event_espresso'
+				) . '">' . $event->name() . '</a>' : $event->name();
+		} catch (\EventEspresso\core\exceptions\EntityNotFoundException $e) {
+			$event_label = esc_html__('Unknown', 'event_espresso');
+		}
+		return $event_label;
+	}
+
+
+	/**
+	 * @param \EE_Registration $item
+	 * @return mixed|string|void
+	 */
+	public function column_PRC_name(EE_Registration $item)
+	{
+		return $item->ticket() instanceof EE_Ticket ? $item->ticket()->name() : esc_html__("Unknown", "event_espresso");
+	}
+
+
+	/**
+	 * column_REG_final_price
+	 *
+	 * @param \EE_Registration $item
+	 * @return string
+	 */
+	public function column__REG_final_price(EE_Registration $item)
+	{
+		return '<span class="reg-pad-rght">' . ' ' . $item->pretty_final_price() . '</span>';
+	}
+
+
+	/**
+	 * column_TXN_paid
+	 *
+	 * @param \EE_Registration $item
+	 * @return string
+	 * @throws \EE_Error
+	 */
+	public function column_TXN_paid(EE_Registration $item)
+	{
+		if ($item->count() === 1) {
+			if ($item->transaction()->paid() >= $item->transaction()->total()) {
+				return '<span class="reg-pad-rght"><div class="dashicons dashicons-yes green-icon"></div></span>';
+			} else {
+				$view_txn_lnk_url = EE_Admin_Page::add_query_args_and_nonce(
+					array('action' => 'view_transaction', 'TXN_ID' => $item->transaction_ID()),
+					TXN_ADMIN_URL
+				);
+				return EE_Registry::instance()->CAP->current_user_can(
+					'ee_read_transaction',
+					'espresso_transactions_view_transaction'
+				) ? '
 				<span class="reg-pad-rght">
 					<a class="status-'
-                    . $item->transaction()->status_ID()
-                    . '" href="'
-                    . $view_txn_lnk_url
-                    . '"  title="'
-                    . esc_attr__('View Transaction', 'event_espresso')
-                    . '">
+					. $item->transaction()->status_ID()
+					. '" href="'
+					. $view_txn_lnk_url
+					. '"  title="'
+					. esc_attr__('View Transaction', 'event_espresso')
+					. '">
 						'
-                    . $item->transaction()->pretty_paid()
-                    . '
+					. $item->transaction()->pretty_paid()
+					. '
 					</a>
 				<span>' : '<span class="reg-pad-rght">' . $item->transaction()->pretty_paid() . '</span>';
-            }
-        } else {
-            return '<span class="reg-pad-rght"></span>';
-        }
-    }
-
-
-    /**
-     *        column_TXN_total
-     *
-     * @param \EE_Registration $item
-     * @return string
-     * @throws \EE_Error
-     */
-    public function column_TXN_total(EE_Registration $item)
-    {
-        $txn = $item->transaction();
-        $view_txn_url = add_query_arg(array('action' => 'view_transaction', 'TXN_ID' => $txn->ID()), TXN_ADMIN_URL);
-        if ($item->get('REG_count') === 1) {
-            $line_total_obj = $txn->total_line_item();
-            $txn_total = $line_total_obj instanceof EE_Line_Item
-                ? $line_total_obj->get_pretty('LIN_total')
-                : esc_html__(
-                    'View Transaction',
-                    'event_espresso'
-                );
-            return EE_Registry::instance()->CAP->current_user_can(
-                'ee_read_transaction',
-                'espresso_transactions_view_transaction'
-            ) ? '<a href="'
-                . $view_txn_url
-                . '" title="'
-                . esc_attr__('View Transaction', 'event_espresso')
-                . '"><span class="reg-pad-rght">'
-                . $txn_total
-                . '</span></a>' : '<span class="reg-pad-rght">' . $txn_total . '</span>';
-        } else {
-            return '<span class="reg-pad-rght"></span>';
-        }
-    }
+			}
+		} else {
+			return '<span class="reg-pad-rght"></span>';
+		}
+	}
+
+
+	/**
+	 *        column_TXN_total
+	 *
+	 * @param \EE_Registration $item
+	 * @return string
+	 * @throws \EE_Error
+	 */
+	public function column_TXN_total(EE_Registration $item)
+	{
+		$txn = $item->transaction();
+		$view_txn_url = add_query_arg(array('action' => 'view_transaction', 'TXN_ID' => $txn->ID()), TXN_ADMIN_URL);
+		if ($item->get('REG_count') === 1) {
+			$line_total_obj = $txn->total_line_item();
+			$txn_total = $line_total_obj instanceof EE_Line_Item
+				? $line_total_obj->get_pretty('LIN_total')
+				: esc_html__(
+					'View Transaction',
+					'event_espresso'
+				);
+			return EE_Registry::instance()->CAP->current_user_can(
+				'ee_read_transaction',
+				'espresso_transactions_view_transaction'
+			) ? '<a href="'
+				. $view_txn_url
+				. '" title="'
+				. esc_attr__('View Transaction', 'event_espresso')
+				. '"><span class="reg-pad-rght">'
+				. $txn_total
+				. '</span></a>' : '<span class="reg-pad-rght">' . $txn_total . '</span>';
+		} else {
+			return '<span class="reg-pad-rght"></span>';
+		}
+	}
 }

core/libraries/batch/JobHandlers/RegistrationsReport.php

Indentation +587 added lines, -587 removed lines

@@ -33,606 +33,606 @@
  */
 class RegistrationsReport extends JobHandlerFile
 {
-    // phpcs:disable PSR1.Methods.CamelCapsMethodName.NotCamelCaps
-    // phpcs:disable PSR2.Methods.MethodDeclaration.Underscore
-    /**
-     * Performs any necessary setup for starting the job. This is also a good
-     * place to setup the $job_arguments which will be used for subsequent HTTP requests
-     * when continue_job will be called
-     *
-     * @param JobParameters $job_parameters
-     * @throws BatchRequestException
-     * @return JobStepResponse
-     */
-    public function create_job(JobParameters $job_parameters)
-    {
-        $event_id = intval($job_parameters->request_datum('EVT_ID', '0'));
-        if (! \EE_Capabilities::instance()->current_user_can('ee_read_registrations', 'generating_report')) {
-            throw new BatchRequestException(esc_html__('You do not have permission to view registrations', 'event_espresso'));
-        }
-        $filepath = $this->create_file_from_job_with_name(
-            $job_parameters->job_id(),
-            $this->get_filename($event_id)
-        );
-        $job_parameters->add_extra_data('filepath', $filepath);
-        if ($job_parameters->request_datum('use_filters', false)) {
-            $query_params = maybe_unserialize($job_parameters->request_datum('filters', array()));
-        } else {
-            $query_params = apply_filters('FHEE__EE_Export__report_registration_for_event', array(
-                array(
-                    'OR'                 => array(
-                        // don't include registrations from failed or abandoned transactions...
-                        'Transaction.STS_ID' => array(
-                            'NOT IN',
-                            array(
-                                EEM_Transaction::failed_status_code,
-                                EEM_Transaction::abandoned_status_code,
-                            ),
-                        ),
-                        // unless the registration is approved, in which case include it regardless of transaction status
-                        'STS_ID'             => \EEM_Registration::status_id_approved,
-                    ),
-                    'Ticket.TKT_deleted' => array('IN', array(true, false)),
-                ),
-                'order_by'   => array('Transaction.TXN_ID' => 'asc', 'REG_count' => 'asc'),
-                'force_join' => array('Transaction', 'Ticket', 'Attendee'),
-                'caps'       => \EEM_Base::caps_read_admin,
-            ), $event_id);
-            if ($event_id) {
-                $query_params[0]['EVT_ID'] = $event_id;
-            } else {
-                $query_params['force_join'][] = 'Event';
-            }
-        }
-        if (! isset($query_params['force_join'])) {
-            $query_params['force_join'] = array('Event', 'Transaction', 'Ticket', 'Attendee');
-        }
-        $job_parameters->add_extra_data('query_params', $query_params);
-        $question_labels = $this->_get_question_labels($query_params);
-        $job_parameters->add_extra_data('question_labels', $question_labels);
-        $job_parameters->set_job_size(
-            \EEM_Registration::instance()->count(
-                array_diff_key(
-                    $query_params,
-                    array_flip(
-                        array('limit')
-                    )
-                )
-            )
-        );
-        // Include check-in, check-out data
-        $incude_checkins = (bool) $job_parameters->request_datum('incude_checkins', 0);
-        // we should also set the header columns
-        $csv_data_for_row = $this->get_csv_data_for(
-            $event_id,
-            0,
-            1,
-            $job_parameters->extra_datum('question_labels'),
-            $job_parameters->extra_datum('query_params'),
-            $incude_checkins
-        );
-        EEH_Export::write_data_array_to_csv($filepath, $csv_data_for_row, true);
-        // if we actually processed a row there, record it
-        if ($job_parameters->job_size()) {
-            $job_parameters->mark_processed(1);
-        }
-        return new JobStepResponse(
-            $job_parameters,
-            esc_html__('Registrations report started successfully...', 'event_espresso')
-        );
-    }
+	// phpcs:disable PSR1.Methods.CamelCapsMethodName.NotCamelCaps
+	// phpcs:disable PSR2.Methods.MethodDeclaration.Underscore
+	/**
+	 * Performs any necessary setup for starting the job. This is also a good
+	 * place to setup the $job_arguments which will be used for subsequent HTTP requests
+	 * when continue_job will be called
+	 *
+	 * @param JobParameters $job_parameters
+	 * @throws BatchRequestException
+	 * @return JobStepResponse
+	 */
+	public function create_job(JobParameters $job_parameters)
+	{
+		$event_id = intval($job_parameters->request_datum('EVT_ID', '0'));
+		if (! \EE_Capabilities::instance()->current_user_can('ee_read_registrations', 'generating_report')) {
+			throw new BatchRequestException(esc_html__('You do not have permission to view registrations', 'event_espresso'));
+		}
+		$filepath = $this->create_file_from_job_with_name(
+			$job_parameters->job_id(),
+			$this->get_filename($event_id)
+		);
+		$job_parameters->add_extra_data('filepath', $filepath);
+		if ($job_parameters->request_datum('use_filters', false)) {
+			$query_params = maybe_unserialize($job_parameters->request_datum('filters', array()));
+		} else {
+			$query_params = apply_filters('FHEE__EE_Export__report_registration_for_event', array(
+				array(
+					'OR'                 => array(
+						// don't include registrations from failed or abandoned transactions...
+						'Transaction.STS_ID' => array(
+							'NOT IN',
+							array(
+								EEM_Transaction::failed_status_code,
+								EEM_Transaction::abandoned_status_code,
+							),
+						),
+						// unless the registration is approved, in which case include it regardless of transaction status
+						'STS_ID'             => \EEM_Registration::status_id_approved,
+					),
+					'Ticket.TKT_deleted' => array('IN', array(true, false)),
+				),
+				'order_by'   => array('Transaction.TXN_ID' => 'asc', 'REG_count' => 'asc'),
+				'force_join' => array('Transaction', 'Ticket', 'Attendee'),
+				'caps'       => \EEM_Base::caps_read_admin,
+			), $event_id);
+			if ($event_id) {
+				$query_params[0]['EVT_ID'] = $event_id;
+			} else {
+				$query_params['force_join'][] = 'Event';
+			}
+		}
+		if (! isset($query_params['force_join'])) {
+			$query_params['force_join'] = array('Event', 'Transaction', 'Ticket', 'Attendee');
+		}
+		$job_parameters->add_extra_data('query_params', $query_params);
+		$question_labels = $this->_get_question_labels($query_params);
+		$job_parameters->add_extra_data('question_labels', $question_labels);
+		$job_parameters->set_job_size(
+			\EEM_Registration::instance()->count(
+				array_diff_key(
+					$query_params,
+					array_flip(
+						array('limit')
+					)
+				)
+			)
+		);
+		// Include check-in, check-out data
+		$incude_checkins = (bool) $job_parameters->request_datum('incude_checkins', 0);
+		// we should also set the header columns
+		$csv_data_for_row = $this->get_csv_data_for(
+			$event_id,
+			0,
+			1,
+			$job_parameters->extra_datum('question_labels'),
+			$job_parameters->extra_datum('query_params'),
+			$incude_checkins
+		);
+		EEH_Export::write_data_array_to_csv($filepath, $csv_data_for_row, true);
+		// if we actually processed a row there, record it
+		if ($job_parameters->job_size()) {
+			$job_parameters->mark_processed(1);
+		}
+		return new JobStepResponse(
+			$job_parameters,
+			esc_html__('Registrations report started successfully...', 'event_espresso')
+		);
+	}
 
 
-    /**
-     * Gets the filename
-     *
-     * @return string
-     */
-    protected function get_filename()
-    {
-        return apply_filters(
-            'FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__get_filename',
-            sprintf(
-                "event-espresso-registrations-%s.csv",
-                str_replace(array(':', ' '), '-', current_time('mysql'))
-            )
-        );
-    }
+	/**
+	 * Gets the filename
+	 *
+	 * @return string
+	 */
+	protected function get_filename()
+	{
+		return apply_filters(
+			'FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__get_filename',
+			sprintf(
+				"event-espresso-registrations-%s.csv",
+				str_replace(array(':', ' '), '-', current_time('mysql'))
+			)
+		);
+	}
 
 
-    /**
-     * Gets the questions which are to be used for this report, so they
-     * can be remembered for later
-     *
-     * @param array $registration_query_params
-     * @return array question admin labels to be used for this report
-     */
-    protected function _get_question_labels($registration_query_params)
-    {
-        $where = isset($registration_query_params[0]) ? $registration_query_params[0] : null;
-        $question_query_params = array();
-        if ($where !== null) {
-            $question_query_params = array(
-                $this->_change_registration_where_params_to_question_where_params($registration_query_params[0]),
-            );
-        }
-        // Make sure it's not a system question
-        $question_query_params[0]['OR*not-system-questions'] = [
-            'QST_system' => '',
-            'QST_system*null' => ['IS_NULL']
-        ];
-        if (
-            apply_filters(
-                'FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport___get_question_labels__only_include_answered_questions',
-                false,
-                $registration_query_params
-            )
-        ) {
-            $question_query_params[0]['Answer.ANS_ID'] = array('IS_NOT_NULL');
-        }
-        $question_query_params['group_by'] = array('QST_ID');
-        return array_unique(EEM_Question::instance()->get_col($question_query_params, 'QST_admin_label'));
-    }
+	/**
+	 * Gets the questions which are to be used for this report, so they
+	 * can be remembered for later
+	 *
+	 * @param array $registration_query_params
+	 * @return array question admin labels to be used for this report
+	 */
+	protected function _get_question_labels($registration_query_params)
+	{
+		$where = isset($registration_query_params[0]) ? $registration_query_params[0] : null;
+		$question_query_params = array();
+		if ($where !== null) {
+			$question_query_params = array(
+				$this->_change_registration_where_params_to_question_where_params($registration_query_params[0]),
+			);
+		}
+		// Make sure it's not a system question
+		$question_query_params[0]['OR*not-system-questions'] = [
+			'QST_system' => '',
+			'QST_system*null' => ['IS_NULL']
+		];
+		if (
+			apply_filters(
+				'FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport___get_question_labels__only_include_answered_questions',
+				false,
+				$registration_query_params
+			)
+		) {
+			$question_query_params[0]['Answer.ANS_ID'] = array('IS_NOT_NULL');
+		}
+		$question_query_params['group_by'] = array('QST_ID');
+		return array_unique(EEM_Question::instance()->get_col($question_query_params, 'QST_admin_label'));
+	}
 
 
-    /**
-     * Takes where params meant for registrations and changes them to work for questions
-     *
-     * @param array $reg_where_params
-     * @return array
-     */
-    protected function _change_registration_where_params_to_question_where_params($reg_where_params)
-    {
-        $question_where_params = array();
-        foreach ($reg_where_params as $key => $val) {
-            if (\EEM_Registration::instance()->is_logic_query_param_key($key)) {
-                $question_where_params[ $key ] = $this->_change_registration_where_params_to_question_where_params($val);
-            } else {
-                // it's a normal where condition
-                $question_where_params[ 'Question_Group.Event.Registration.' . $key ] = $val;
-            }
-        }
-        return $question_where_params;
-    }
+	/**
+	 * Takes where params meant for registrations and changes them to work for questions
+	 *
+	 * @param array $reg_where_params
+	 * @return array
+	 */
+	protected function _change_registration_where_params_to_question_where_params($reg_where_params)
+	{
+		$question_where_params = array();
+		foreach ($reg_where_params as $key => $val) {
+			if (\EEM_Registration::instance()->is_logic_query_param_key($key)) {
+				$question_where_params[ $key ] = $this->_change_registration_where_params_to_question_where_params($val);
+			} else {
+				// it's a normal where condition
+				$question_where_params[ 'Question_Group.Event.Registration.' . $key ] = $val;
+			}
+		}
+		return $question_where_params;
+	}
 
 
-    /**
-     * Performs another step of the job
-     *
-     * @param JobParameters $job_parameters
-     * @param int           $batch_size
-     * @return JobStepResponse
-     * @throws \EE_Error
-     */
-    public function continue_job(JobParameters $job_parameters, $batch_size = 50)
-    {
-        if ($job_parameters->units_processed() < $job_parameters->job_size()) {
-            // Include check-in, check-out data
-            $incude_checkins = (bool) $job_parameters->request_datum('incude_checkins', 0);
-            $csv_data = $this->get_csv_data_for(
-                $job_parameters->request_datum('EVT_ID', '0'),
-                $job_parameters->units_processed(),
-                $batch_size,
-                $job_parameters->extra_datum('question_labels'),
-                $job_parameters->extra_datum('query_params'),
-                $incude_checkins
-            );
-            EEH_Export::write_data_array_to_csv($job_parameters->extra_datum('filepath'), $csv_data, false);
-            $units_processed = count($csv_data);
-        } else {
-            $csv_data = array();
-            $units_processed = 0;
-        }
-        $job_parameters->mark_processed($units_processed);
-        $extra_response_data = array(
-            'file_url' => '',
-        );
-        if ($units_processed < $batch_size) {
-            $job_parameters->set_status(JobParameters::status_complete);
-            $extra_response_data['file_url'] = $this->get_url_to_file($job_parameters->extra_datum('filepath'));
-        }
+	/**
+	 * Performs another step of the job
+	 *
+	 * @param JobParameters $job_parameters
+	 * @param int           $batch_size
+	 * @return JobStepResponse
+	 * @throws \EE_Error
+	 */
+	public function continue_job(JobParameters $job_parameters, $batch_size = 50)
+	{
+		if ($job_parameters->units_processed() < $job_parameters->job_size()) {
+			// Include check-in, check-out data
+			$incude_checkins = (bool) $job_parameters->request_datum('incude_checkins', 0);
+			$csv_data = $this->get_csv_data_for(
+				$job_parameters->request_datum('EVT_ID', '0'),
+				$job_parameters->units_processed(),
+				$batch_size,
+				$job_parameters->extra_datum('question_labels'),
+				$job_parameters->extra_datum('query_params'),
+				$incude_checkins
+			);
+			EEH_Export::write_data_array_to_csv($job_parameters->extra_datum('filepath'), $csv_data, false);
+			$units_processed = count($csv_data);
+		} else {
+			$csv_data = array();
+			$units_processed = 0;
+		}
+		$job_parameters->mark_processed($units_processed);
+		$extra_response_data = array(
+			'file_url' => '',
+		);
+		if ($units_processed < $batch_size) {
+			$job_parameters->set_status(JobParameters::status_complete);
+			$extra_response_data['file_url'] = $this->get_url_to_file($job_parameters->extra_datum('filepath'));
+		}
 
-        return new JobStepResponse(
-            $job_parameters,
-            sprintf(esc_html__('Wrote %1$s rows to report CSV file...', 'event_espresso'), count((array) $csv_data)),
-            $extra_response_data
-        );
-    }
+		return new JobStepResponse(
+			$job_parameters,
+			sprintf(esc_html__('Wrote %1$s rows to report CSV file...', 'event_espresso'), count((array) $csv_data)),
+			$extra_response_data
+		);
+	}
 
 
-    /**
-     * Gets the csv data for a batch of registrations
-     *
-     * @param int|null $event_id
-     * @param int $offset
-     * @param int $limit
-     * @param array $question_labels the IDs for all the questions which were answered by someone in this selection
-     * @param array $query_params for using where querying the model
-     * @param bool $incude_checkins
-     * @return array top-level keys are numeric, next-level keys are column headers
-     * @throws \EE_Error
-     * @throws \ReflectionException
-     */
-    public function get_csv_data_for($event_id, $offset, $limit, $question_labels, $query_params, $incude_checkins = false)
-    {
-        $reg_fields_to_include = [
-            'TXN_ID',
-            'ATT_ID',
-            'REG_ID',
-            'REG_date',
-            'REG_code',
-            'REG_count',
-            'REG_final_price',
-        ];
-        $att_fields_to_include = [
-            'ATT_fname',
-            'ATT_lname',
-            'ATT_email',
-            'ATT_address',
-            'ATT_address2',
-            'ATT_city',
-            'STA_ID',
-            'CNT_ISO',
-            'ATT_zip',
-            'ATT_phone',
-        ];
-        $registrations_csv_ready_array = [];
-        $reg_model = EE_Registry::instance()->load_model('Registration');
-        $query_params['limit'] = [$offset, $limit];
-        $registration_rows = $reg_model->get_all_wpdb_results($query_params);
-        foreach ($registration_rows as $reg_row) {
-            if (!is_array($reg_row)) {
-                continue;
-            }
-            $reg_csv_array = [];
-            if (! $event_id) {
-                // get the event's name and Id
-                $reg_csv_array[ (string) esc_html__('Event', 'event_espresso') ] = sprintf(
-                    /* translators: 1: event name, 2: event ID */
-                    esc_html__('%1$s (%2$s)', 'event_espresso'),
-                    EEH_Export::prepare_value_from_db_for_display(
-                        EEM_Event::instance(),
-                        'EVT_name',
-                        $reg_row['Event_CPT.post_title']
-                    ),
-                    $reg_row['Event_CPT.ID']
-                );
-            }
-            $is_primary_reg = $reg_row['Registration.REG_count'] == '1' ? true : false;
-            /*@var $reg_row EE_Registration */
-            foreach ($reg_fields_to_include as $field_name) {
-                $field = $reg_model->field_settings_for($field_name);
-                if ($field_name == 'REG_final_price') {
-                    $value = EEH_Export::prepare_value_from_db_for_display(
-                        $reg_model,
-                        $field_name,
-                        $reg_row['Registration.REG_final_price'],
-                        'localized_float'
-                    );
-                } elseif ($field_name == 'REG_count') {
-                    $value = sprintf(
-                        /* translators: 1: number of registration in group (REG_count), 2: registration group size (REG_group_size) */
-                        esc_html__('%1$s of %2$s', 'event_espresso'),
-                        EEH_Export::prepare_value_from_db_for_display(
-                            $reg_model,
-                            'REG_count',
-                            $reg_row['Registration.REG_count']
-                        ),
-                        EEH_Export::prepare_value_from_db_for_display(
-                            $reg_model,
-                            'REG_group_size',
-                            $reg_row['Registration.REG_group_size']
-                        )
-                    );
-                } elseif ($field_name == 'REG_date') {
-                    $value = EEH_Export::prepare_value_from_db_for_display(
-                        $reg_model,
-                        $field_name,
-                        $reg_row['Registration.REG_date'],
-                        'no_html'
-                    );
-                } else {
-                    $value = EEH_Export::prepare_value_from_db_for_display(
-                        $reg_model,
-                        $field_name,
-                        $reg_row[ $field->get_qualified_column() ]
-                    );
-                }
-                $reg_csv_array[ EEH_Export::get_column_name_for_field($field) ] = $value;
-                if ($field_name == 'REG_final_price') {
-                    // add a column named Currency after the final price
-                    $reg_csv_array[ (string) esc_html__("Currency", "event_espresso") ] = \EE_Config::instance()->currency->code;
-                }
-            }
-            // get pretty status
-            $stati = EEM_Status::instance()->localized_status(
-                [
-                    $reg_row['Registration.STS_ID']     => esc_html__('unknown', 'event_espresso'),
-                    $reg_row['TransactionTable.STS_ID'] => esc_html__('unknown', 'event_espresso'),
-                ],
-                false,
-                'sentence'
-            );
-            $reg_csv_array[ (string) esc_html__("Registration Status", 'event_espresso') ] = $stati[ $reg_row['Registration.STS_ID'] ];
-            // get pretty transaction status
-            $reg_csv_array[ (string) esc_html__("Transaction Status", 'event_espresso') ] = $stati[ $reg_row['TransactionTable.STS_ID'] ];
-            $reg_csv_array[ (string) esc_html__('Transaction Amount Due', 'event_espresso') ] = $is_primary_reg
-                ? EEH_Export::prepare_value_from_db_for_display(
-                    EEM_Transaction::instance(),
-                    'TXN_total',
-                    $reg_row['TransactionTable.TXN_total'],
-                    'localized_float'
-                ) : '0.00';
-            $reg_csv_array[ (string) esc_html__('Amount Paid', 'event_espresso') ] = $is_primary_reg
-                ? EEH_Export::prepare_value_from_db_for_display(
-                    EEM_Transaction::instance(),
-                    'TXN_paid',
-                    $reg_row['TransactionTable.TXN_paid'],
-                    'localized_float'
-                ) : '0.00';
-            $payment_methods = [];
-            $gateway_txn_ids_etc = [];
-            $payment_times = [];
-            if ($is_primary_reg && $reg_row['TransactionTable.TXN_ID']) {
-                $payments_info = EEM_Payment::instance()->get_all_wpdb_results(
-                    [
-                        [
-                            'TXN_ID' => $reg_row['TransactionTable.TXN_ID'],
-                            'STS_ID' => EEM_Payment::status_id_approved,
-                        ],
-                        'force_join' => ['Payment_Method'],
-                    ],
-                    ARRAY_A,
-                    'Payment_Method.PMD_admin_name as name, Payment.PAY_txn_id_chq_nmbr as gateway_txn_id, Payment.PAY_timestamp as payment_time'
-                );
-                foreach ($payments_info as $payment_method_and_gateway_txn_id) {
-                    $payment_methods[] = isset($payment_method_and_gateway_txn_id['name'])
-                        ? $payment_method_and_gateway_txn_id['name'] : esc_html__('Unknown', 'event_espresso');
-                    $gateway_txn_ids_etc[] = isset($payment_method_and_gateway_txn_id['gateway_txn_id'])
-                        ? $payment_method_and_gateway_txn_id['gateway_txn_id'] : '';
-                    $payment_times[] = isset($payment_method_and_gateway_txn_id['payment_time'])
-                        ? $payment_method_and_gateway_txn_id['payment_time'] : '';
-                }
-            }
-            $reg_csv_array[ (string) esc_html__('Payment Date(s)', 'event_espresso') ] = implode(',', $payment_times);
-            $reg_csv_array[ (string) esc_html__('Payment Method(s)', 'event_espresso') ] = implode(",", $payment_methods);
-            $reg_csv_array[ (string) esc_html__('Gateway Transaction ID(s)', 'event_espresso') ] = implode(
-                ',',
-                $gateway_txn_ids_etc
-            );
-            // get whether or not the user has checked in
-            $reg_csv_array[ (string) esc_html__('Check-Ins', 'event_espresso') ] = $reg_model->count_related(
-                $reg_row['Registration.REG_ID'],
-                'Checkin'
-            );
-            // get ticket of registration and its price
-            $ticket_model = EE_Registry::instance()->load_model('Ticket');
-            if ($reg_row['Ticket.TKT_ID']) {
-                $ticket_name = EEH_Export::prepare_value_from_db_for_display(
-                    $ticket_model,
-                    'TKT_name',
-                    $reg_row['Ticket.TKT_name']
-                );
-                $datetimes_strings = [];
-                foreach (
-                    EEM_Datetime::instance()->get_all_wpdb_results(
-                        [
-                            ['Ticket.TKT_ID' => $reg_row['Ticket.TKT_ID']],
-                            'order_by' => ['DTT_EVT_start' => 'ASC'],
-                            'default_where_conditions' => 'none',
-                        ]
-                    ) as $datetime
-                ) {
-                    $datetimes_strings[] = EEH_Export::prepare_value_from_db_for_display(
-                        EEM_Datetime::instance(),
-                        'DTT_EVT_start',
-                        $datetime['Datetime.DTT_EVT_start']
-                    );
-                }
-            } else {
-                $ticket_name = esc_html__('Unknown', 'event_espresso');
-                $datetimes_strings = [esc_html__('Unknown', 'event_espresso')];
-            }
-            $reg_csv_array[ (string) $ticket_model->field_settings_for('TKT_name')->get_nicename() ] = $ticket_name;
-            $reg_csv_array[ (string) esc_html__("Datetimes of Ticket", "event_espresso") ] = implode(", ", $datetimes_strings);
-            // get datetime(s) of registration
-            // add attendee columns
-            foreach ($att_fields_to_include as $att_field_name) {
-                $field_obj = EEM_Attendee::instance()->field_settings_for($att_field_name);
-                if ($reg_row['Attendee_CPT.ID']) {
-                    if ($att_field_name == 'STA_ID') {
-                        $value = EEM_State::instance()->get_var(
-                            [
-                                ['STA_ID' => $reg_row['Attendee_Meta.STA_ID']]
-                            ],
-                            'STA_name'
-                        );
-                    } elseif ($att_field_name == 'CNT_ISO') {
-                        $value = EEM_Country::instance()->get_var(
-                            [
-                                ['CNT_ISO' => $reg_row['Attendee_Meta.CNT_ISO']]
-                            ],
-                            'CNT_name'
-                        );
-                    } else {
-                        $value = EEH_Export::prepare_value_from_db_for_display(
-                            EEM_Attendee::instance(),
-                            $att_field_name,
-                            $reg_row[ $field_obj->get_qualified_column() ]
-                        );
-                    }
-                } else {
-                    $value = '';
-                }
-                $reg_csv_array[ EEH_Export::get_column_name_for_field($field_obj) ] = $value;
-            }
-            // make sure each registration has the same questions in the same order
-            foreach ($question_labels as $question_label) {
-                if (! isset($reg_csv_array[ $question_label ])) {
-                    $reg_csv_array[ $question_label ] = null;
-                }
-            }
-            $answers = EEM_Answer::instance()->get_all_wpdb_results([
-                ['REG_ID' => $reg_row['Registration.REG_ID']],
-                'force_join' => ['Question'],
-            ]);
-            // now fill out the questions THEY answered
-            foreach ($answers as $answer_row) {
-                if ($answer_row['Question.QST_system']) {
-                    // it's an answer to a system question. That was already displayed as part of the attendee
-                    // fields, so don't write it out again thanks.
-                    continue;
-                }
-                if ($answer_row['Question.QST_ID']) {
-                    $question_label = EEH_Export::prepare_value_from_db_for_display(
-                        EEM_Question::instance(),
-                        'QST_admin_label',
-                        $answer_row['Question.QST_admin_label']
-                    );
-                } else {
-                    $question_label = sprintf(esc_html__('Question $s', 'event_espresso'), $answer_row['Answer.QST_ID']);
-                }
-                if (
-                    isset($answer_row['Question.QST_type'])
-                    && $answer_row['Question.QST_type'] == EEM_Question::QST_type_state
-                ) {
-                    $reg_csv_array[ $question_label ] = EEM_State::instance()->get_state_name_by_ID(
-                        $answer_row['Answer.ANS_value']
-                    );
-                } else {
-                    // this isn't for html, so don't show html entities
-                    $reg_csv_array[ $question_label ] = html_entity_decode(
-                        EEH_Export::prepare_value_from_db_for_display(
-                            EEM_Answer::instance(),
-                            'ANS_value',
-                            $answer_row['Answer.ANS_value']
-                        )
-                    );
-                }
-            }
-            // Include check-in data
-            if ($incude_checkins) {
-                $datetimes = EEM_Datetime::instance()->get_all_wpdb_results(
-                    [
-                        [
-                            'Ticket.TKT_ID' => $reg_row['Ticket.TKT_ID']
-                        ],
-                        'order_by' => ['DTT_EVT_start' => 'ASC'],
-                        'default_where_conditions' => 'none',
-                    ]
-                );
-                foreach ($datetimes as $datetime) {
-                    $checkin_row = EEM_Checkin::instance()->get_one(
-                        [
-                            [
-                                'REG_ID' => $reg_row['Registration.REG_ID'],
-                                'DTT_ID' => $datetime['Datetime.DTT_ID'],
-                            ],
-                            'limit' => 1,
-                            'order_by' => [
-                                'CHK_ID' => 'DESC'
-                            ]
-                        ]
-                    );
-                    if (trim($datetime['Datetime.DTT_name'])) {
-                        /* translators: 1: datetime name, 2: datetime ID */
-                        $datetime_name = sprintf(
-                            esc_html__('%1$s - ID: %2$s', 'event_espresso'),
-                            esc_html($datetime['Datetime.DTT_name']),
-                            esc_html($datetime['Datetime.DTT_ID'])
-                        );
-                    } else {
-                        /* translators: %s: datetime ID */
-                        $datetime_name = sprintf(
-                            esc_html__('ID: %1$s', 'event_espresso'),
-                            esc_html($datetime['Datetime.DTT_ID'])
-                        );
-                    }
-                    $checkin_value = '';
-                    if ($checkin_row instanceof EE_Checkin && $checkin_row->get('CHK_in') === true) {
-                        /* translators: 1: check-in status, 2: check-in timestamp */
-                        $checkin_value = sprintf(
-                            esc_html__('%1$s - %2$s', 'event_espresso'),
-                            esc_html__('IN', 'event_espresso'),
-                            date('Y-m-d H:i:s', $checkin_row->get_raw('CHK_timestamp'))
-                        );
-                    } elseif ($checkin_row instanceof EE_Checkin && $checkin_row->get('CHK_in') === false) {
-                        /* translators: 1: check-in status, 2: check-in timestamp */
-                        $checkin_value = sprintf(
-                            esc_html__('%1$s - %2$s', 'event_espresso'),
-                            esc_html__('OUT', 'event_espresso'),
-                            date('Y-m-d H:i:s', $checkin_row->get_raw('CHK_timestamp'))
-                        );
-                    }
-                    $reg_csv_array[ (string) $datetime_name ] = $checkin_value;
-                }
-            }
-            /**
-             * Filter to change the contents of each row of the registrations report CSV file.
-             * This can be used to add or remote columns from the CSV file, or change their values.
-             * Note when using: all rows in the CSV should have the same columns.
-             * @param array $reg_csv_array keys are the column names, values are their cell values
-             * @param array $reg_row one entry from EEM_Registration::get_all_wpdb_results()
-             */
-            $registrations_csv_ready_array[] = apply_filters(
-                'FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array',
-                $reg_csv_array,
-                $reg_row
-            );
-        }
-        // if we couldn't export anything, we want to at least show the column headers
-        if (empty($registrations_csv_ready_array)) {
-            $reg_csv_array = [];
-            $model_and_fields_to_include = [
-                'Registration' => $reg_fields_to_include,
-                'Attendee'     => $att_fields_to_include,
-            ];
-            foreach ($model_and_fields_to_include as $model_name => $field_list) {
-                $model = EE_Registry::instance()->load_model($model_name);
-                foreach ($field_list as $field_name) {
-                    $field = $model->field_settings_for($field_name);
-                    $reg_csv_array[ EEH_Export::get_column_name_for_field($field) ] = null;
-                }
-            }
-            $registrations_csv_ready_array[] = $reg_csv_array;
-        }
-        return $registrations_csv_ready_array;
-    }
+	/**
+	 * Gets the csv data for a batch of registrations
+	 *
+	 * @param int|null $event_id
+	 * @param int $offset
+	 * @param int $limit
+	 * @param array $question_labels the IDs for all the questions which were answered by someone in this selection
+	 * @param array $query_params for using where querying the model
+	 * @param bool $incude_checkins
+	 * @return array top-level keys are numeric, next-level keys are column headers
+	 * @throws \EE_Error
+	 * @throws \ReflectionException
+	 */
+	public function get_csv_data_for($event_id, $offset, $limit, $question_labels, $query_params, $incude_checkins = false)
+	{
+		$reg_fields_to_include = [
+			'TXN_ID',
+			'ATT_ID',
+			'REG_ID',
+			'REG_date',
+			'REG_code',
+			'REG_count',
+			'REG_final_price',
+		];
+		$att_fields_to_include = [
+			'ATT_fname',
+			'ATT_lname',
+			'ATT_email',
+			'ATT_address',
+			'ATT_address2',
+			'ATT_city',
+			'STA_ID',
+			'CNT_ISO',
+			'ATT_zip',
+			'ATT_phone',
+		];
+		$registrations_csv_ready_array = [];
+		$reg_model = EE_Registry::instance()->load_model('Registration');
+		$query_params['limit'] = [$offset, $limit];
+		$registration_rows = $reg_model->get_all_wpdb_results($query_params);
+		foreach ($registration_rows as $reg_row) {
+			if (!is_array($reg_row)) {
+				continue;
+			}
+			$reg_csv_array = [];
+			if (! $event_id) {
+				// get the event's name and Id
+				$reg_csv_array[ (string) esc_html__('Event', 'event_espresso') ] = sprintf(
+					/* translators: 1: event name, 2: event ID */
+					esc_html__('%1$s (%2$s)', 'event_espresso'),
+					EEH_Export::prepare_value_from_db_for_display(
+						EEM_Event::instance(),
+						'EVT_name',
+						$reg_row['Event_CPT.post_title']
+					),
+					$reg_row['Event_CPT.ID']
+				);
+			}
+			$is_primary_reg = $reg_row['Registration.REG_count'] == '1' ? true : false;
+			/*@var $reg_row EE_Registration */
+			foreach ($reg_fields_to_include as $field_name) {
+				$field = $reg_model->field_settings_for($field_name);
+				if ($field_name == 'REG_final_price') {
+					$value = EEH_Export::prepare_value_from_db_for_display(
+						$reg_model,
+						$field_name,
+						$reg_row['Registration.REG_final_price'],
+						'localized_float'
+					);
+				} elseif ($field_name == 'REG_count') {
+					$value = sprintf(
+						/* translators: 1: number of registration in group (REG_count), 2: registration group size (REG_group_size) */
+						esc_html__('%1$s of %2$s', 'event_espresso'),
+						EEH_Export::prepare_value_from_db_for_display(
+							$reg_model,
+							'REG_count',
+							$reg_row['Registration.REG_count']
+						),
+						EEH_Export::prepare_value_from_db_for_display(
+							$reg_model,
+							'REG_group_size',
+							$reg_row['Registration.REG_group_size']
+						)
+					);
+				} elseif ($field_name == 'REG_date') {
+					$value = EEH_Export::prepare_value_from_db_for_display(
+						$reg_model,
+						$field_name,
+						$reg_row['Registration.REG_date'],
+						'no_html'
+					);
+				} else {
+					$value = EEH_Export::prepare_value_from_db_for_display(
+						$reg_model,
+						$field_name,
+						$reg_row[ $field->get_qualified_column() ]
+					);
+				}
+				$reg_csv_array[ EEH_Export::get_column_name_for_field($field) ] = $value;
+				if ($field_name == 'REG_final_price') {
+					// add a column named Currency after the final price
+					$reg_csv_array[ (string) esc_html__("Currency", "event_espresso") ] = \EE_Config::instance()->currency->code;
+				}
+			}
+			// get pretty status
+			$stati = EEM_Status::instance()->localized_status(
+				[
+					$reg_row['Registration.STS_ID']     => esc_html__('unknown', 'event_espresso'),
+					$reg_row['TransactionTable.STS_ID'] => esc_html__('unknown', 'event_espresso'),
+				],
+				false,
+				'sentence'
+			);
+			$reg_csv_array[ (string) esc_html__("Registration Status", 'event_espresso') ] = $stati[ $reg_row['Registration.STS_ID'] ];
+			// get pretty transaction status
+			$reg_csv_array[ (string) esc_html__("Transaction Status", 'event_espresso') ] = $stati[ $reg_row['TransactionTable.STS_ID'] ];
+			$reg_csv_array[ (string) esc_html__('Transaction Amount Due', 'event_espresso') ] = $is_primary_reg
+				? EEH_Export::prepare_value_from_db_for_display(
+					EEM_Transaction::instance(),
+					'TXN_total',
+					$reg_row['TransactionTable.TXN_total'],
+					'localized_float'
+				) : '0.00';
+			$reg_csv_array[ (string) esc_html__('Amount Paid', 'event_espresso') ] = $is_primary_reg
+				? EEH_Export::prepare_value_from_db_for_display(
+					EEM_Transaction::instance(),
+					'TXN_paid',
+					$reg_row['TransactionTable.TXN_paid'],
+					'localized_float'
+				) : '0.00';
+			$payment_methods = [];
+			$gateway_txn_ids_etc = [];
+			$payment_times = [];
+			if ($is_primary_reg && $reg_row['TransactionTable.TXN_ID']) {
+				$payments_info = EEM_Payment::instance()->get_all_wpdb_results(
+					[
+						[
+							'TXN_ID' => $reg_row['TransactionTable.TXN_ID'],
+							'STS_ID' => EEM_Payment::status_id_approved,
+						],
+						'force_join' => ['Payment_Method'],
+					],
+					ARRAY_A,
+					'Payment_Method.PMD_admin_name as name, Payment.PAY_txn_id_chq_nmbr as gateway_txn_id, Payment.PAY_timestamp as payment_time'
+				);
+				foreach ($payments_info as $payment_method_and_gateway_txn_id) {
+					$payment_methods[] = isset($payment_method_and_gateway_txn_id['name'])
+						? $payment_method_and_gateway_txn_id['name'] : esc_html__('Unknown', 'event_espresso');
+					$gateway_txn_ids_etc[] = isset($payment_method_and_gateway_txn_id['gateway_txn_id'])
+						? $payment_method_and_gateway_txn_id['gateway_txn_id'] : '';
+					$payment_times[] = isset($payment_method_and_gateway_txn_id['payment_time'])
+						? $payment_method_and_gateway_txn_id['payment_time'] : '';
+				}
+			}
+			$reg_csv_array[ (string) esc_html__('Payment Date(s)', 'event_espresso') ] = implode(',', $payment_times);
+			$reg_csv_array[ (string) esc_html__('Payment Method(s)', 'event_espresso') ] = implode(",", $payment_methods);
+			$reg_csv_array[ (string) esc_html__('Gateway Transaction ID(s)', 'event_espresso') ] = implode(
+				',',
+				$gateway_txn_ids_etc
+			);
+			// get whether or not the user has checked in
+			$reg_csv_array[ (string) esc_html__('Check-Ins', 'event_espresso') ] = $reg_model->count_related(
+				$reg_row['Registration.REG_ID'],
+				'Checkin'
+			);
+			// get ticket of registration and its price
+			$ticket_model = EE_Registry::instance()->load_model('Ticket');
+			if ($reg_row['Ticket.TKT_ID']) {
+				$ticket_name = EEH_Export::prepare_value_from_db_for_display(
+					$ticket_model,
+					'TKT_name',
+					$reg_row['Ticket.TKT_name']
+				);
+				$datetimes_strings = [];
+				foreach (
+					EEM_Datetime::instance()->get_all_wpdb_results(
+						[
+							['Ticket.TKT_ID' => $reg_row['Ticket.TKT_ID']],
+							'order_by' => ['DTT_EVT_start' => 'ASC'],
+							'default_where_conditions' => 'none',
+						]
+					) as $datetime
+				) {
+					$datetimes_strings[] = EEH_Export::prepare_value_from_db_for_display(
+						EEM_Datetime::instance(),
+						'DTT_EVT_start',
+						$datetime['Datetime.DTT_EVT_start']
+					);
+				}
+			} else {
+				$ticket_name = esc_html__('Unknown', 'event_espresso');
+				$datetimes_strings = [esc_html__('Unknown', 'event_espresso')];
+			}
+			$reg_csv_array[ (string) $ticket_model->field_settings_for('TKT_name')->get_nicename() ] = $ticket_name;
+			$reg_csv_array[ (string) esc_html__("Datetimes of Ticket", "event_espresso") ] = implode(", ", $datetimes_strings);
+			// get datetime(s) of registration
+			// add attendee columns
+			foreach ($att_fields_to_include as $att_field_name) {
+				$field_obj = EEM_Attendee::instance()->field_settings_for($att_field_name);
+				if ($reg_row['Attendee_CPT.ID']) {
+					if ($att_field_name == 'STA_ID') {
+						$value = EEM_State::instance()->get_var(
+							[
+								['STA_ID' => $reg_row['Attendee_Meta.STA_ID']]
+							],
+							'STA_name'
+						);
+					} elseif ($att_field_name == 'CNT_ISO') {
+						$value = EEM_Country::instance()->get_var(
+							[
+								['CNT_ISO' => $reg_row['Attendee_Meta.CNT_ISO']]
+							],
+							'CNT_name'
+						);
+					} else {
+						$value = EEH_Export::prepare_value_from_db_for_display(
+							EEM_Attendee::instance(),
+							$att_field_name,
+							$reg_row[ $field_obj->get_qualified_column() ]
+						);
+					}
+				} else {
+					$value = '';
+				}
+				$reg_csv_array[ EEH_Export::get_column_name_for_field($field_obj) ] = $value;
+			}
+			// make sure each registration has the same questions in the same order
+			foreach ($question_labels as $question_label) {
+				if (! isset($reg_csv_array[ $question_label ])) {
+					$reg_csv_array[ $question_label ] = null;
+				}
+			}
+			$answers = EEM_Answer::instance()->get_all_wpdb_results([
+				['REG_ID' => $reg_row['Registration.REG_ID']],
+				'force_join' => ['Question'],
+			]);
+			// now fill out the questions THEY answered
+			foreach ($answers as $answer_row) {
+				if ($answer_row['Question.QST_system']) {
+					// it's an answer to a system question. That was already displayed as part of the attendee
+					// fields, so don't write it out again thanks.
+					continue;
+				}
+				if ($answer_row['Question.QST_ID']) {
+					$question_label = EEH_Export::prepare_value_from_db_for_display(
+						EEM_Question::instance(),
+						'QST_admin_label',
+						$answer_row['Question.QST_admin_label']
+					);
+				} else {
+					$question_label = sprintf(esc_html__('Question $s', 'event_espresso'), $answer_row['Answer.QST_ID']);
+				}
+				if (
+					isset($answer_row['Question.QST_type'])
+					&& $answer_row['Question.QST_type'] == EEM_Question::QST_type_state
+				) {
+					$reg_csv_array[ $question_label ] = EEM_State::instance()->get_state_name_by_ID(
+						$answer_row['Answer.ANS_value']
+					);
+				} else {
+					// this isn't for html, so don't show html entities
+					$reg_csv_array[ $question_label ] = html_entity_decode(
+						EEH_Export::prepare_value_from_db_for_display(
+							EEM_Answer::instance(),
+							'ANS_value',
+							$answer_row['Answer.ANS_value']
+						)
+					);
+				}
+			}
+			// Include check-in data
+			if ($incude_checkins) {
+				$datetimes = EEM_Datetime::instance()->get_all_wpdb_results(
+					[
+						[
+							'Ticket.TKT_ID' => $reg_row['Ticket.TKT_ID']
+						],
+						'order_by' => ['DTT_EVT_start' => 'ASC'],
+						'default_where_conditions' => 'none',
+					]
+				);
+				foreach ($datetimes as $datetime) {
+					$checkin_row = EEM_Checkin::instance()->get_one(
+						[
+							[
+								'REG_ID' => $reg_row['Registration.REG_ID'],
+								'DTT_ID' => $datetime['Datetime.DTT_ID'],
+							],
+							'limit' => 1,
+							'order_by' => [
+								'CHK_ID' => 'DESC'
+							]
+						]
+					);
+					if (trim($datetime['Datetime.DTT_name'])) {
+						/* translators: 1: datetime name, 2: datetime ID */
+						$datetime_name = sprintf(
+							esc_html__('%1$s - ID: %2$s', 'event_espresso'),
+							esc_html($datetime['Datetime.DTT_name']),
+							esc_html($datetime['Datetime.DTT_ID'])
+						);
+					} else {
+						/* translators: %s: datetime ID */
+						$datetime_name = sprintf(
+							esc_html__('ID: %1$s', 'event_espresso'),
+							esc_html($datetime['Datetime.DTT_ID'])
+						);
+					}
+					$checkin_value = '';
+					if ($checkin_row instanceof EE_Checkin && $checkin_row->get('CHK_in') === true) {
+						/* translators: 1: check-in status, 2: check-in timestamp */
+						$checkin_value = sprintf(
+							esc_html__('%1$s - %2$s', 'event_espresso'),
+							esc_html__('IN', 'event_espresso'),
+							date('Y-m-d H:i:s', $checkin_row->get_raw('CHK_timestamp'))
+						);
+					} elseif ($checkin_row instanceof EE_Checkin && $checkin_row->get('CHK_in') === false) {
+						/* translators: 1: check-in status, 2: check-in timestamp */
+						$checkin_value = sprintf(
+							esc_html__('%1$s - %2$s', 'event_espresso'),
+							esc_html__('OUT', 'event_espresso'),
+							date('Y-m-d H:i:s', $checkin_row->get_raw('CHK_timestamp'))
+						);
+					}
+					$reg_csv_array[ (string) $datetime_name ] = $checkin_value;
+				}
+			}
+			/**
+			 * Filter to change the contents of each row of the registrations report CSV file.
+			 * This can be used to add or remote columns from the CSV file, or change their values.
+			 * Note when using: all rows in the CSV should have the same columns.
+			 * @param array $reg_csv_array keys are the column names, values are their cell values
+			 * @param array $reg_row one entry from EEM_Registration::get_all_wpdb_results()
+			 */
+			$registrations_csv_ready_array[] = apply_filters(
+				'FHEE__EventEspressoBatchRequest__JobHandlers__RegistrationsReport__reg_csv_array',
+				$reg_csv_array,
+				$reg_row
+			);
+		}
+		// if we couldn't export anything, we want to at least show the column headers
+		if (empty($registrations_csv_ready_array)) {
+			$reg_csv_array = [];
+			$model_and_fields_to_include = [
+				'Registration' => $reg_fields_to_include,
+				'Attendee'     => $att_fields_to_include,
+			];
+			foreach ($model_and_fields_to_include as $model_name => $field_list) {
+				$model = EE_Registry::instance()->load_model($model_name);
+				foreach ($field_list as $field_name) {
+					$field = $model->field_settings_for($field_name);
+					$reg_csv_array[ EEH_Export::get_column_name_for_field($field) ] = null;
+				}
+			}
+			$registrations_csv_ready_array[] = $reg_csv_array;
+		}
+		return $registrations_csv_ready_array;
+	}
 
 
-    /**
-     * Counts total unit to process
-     *
-     * @deprecated since 4.9.19
-     * @param int|array $event_id
-     * @return int
-     */
-    public function count_units_to_process($event_id)
-    {
-        // use the legacy filter
-        if ($event_id) {
-            $query_params[0]['EVT_ID'] = $event_id;
-        } else {
-            $query_params['force_join'][] = 'Event';
-        }
-        return \EEM_Registration::instance()->count($query_params);
-    }
+	/**
+	 * Counts total unit to process
+	 *
+	 * @deprecated since 4.9.19
+	 * @param int|array $event_id
+	 * @return int
+	 */
+	public function count_units_to_process($event_id)
+	{
+		// use the legacy filter
+		if ($event_id) {
+			$query_params[0]['EVT_ID'] = $event_id;
+		} else {
+			$query_params['force_join'][] = 'Event';
+		}
+		return \EEM_Registration::instance()->count($query_params);
+	}
 
 
-    /**
-     * Performs any clean-up logic when we know the job is completed.
-     * In this case, we delete the temporary file
-     *
-     * @param JobParameters $job_parameters
-     * @return boolean
-     */
-    public function cleanup_job(JobParameters $job_parameters)
-    {
-        $this->_file_helper->delete(
-            \EEH_File::remove_filename_from_filepath($job_parameters->extra_datum('filepath')),
-            true,
-            'd'
-        );
-        return new JobStepResponse($job_parameters, esc_html__('Cleaned up temporary file', 'event_espresso'));
-    }
+	/**
+	 * Performs any clean-up logic when we know the job is completed.
+	 * In this case, we delete the temporary file
+	 *
+	 * @param JobParameters $job_parameters
+	 * @return boolean
+	 */
+	public function cleanup_job(JobParameters $job_parameters)
+	{
+		$this->_file_helper->delete(
+			\EEH_File::remove_filename_from_filepath($job_parameters->extra_datum('filepath')),
+			true,
+			'd'
+		);
+		return new JobStepResponse($job_parameters, esc_html__('Cleaned up temporary file', 'event_espresso'));
+	}
 }

Spacing +28 added lines, -28 removed lines

@@ -47,7 +47,7 @@ 
     public function create_job(JobParameters $job_parameters)
     {
         $event_id = intval($job_parameters->request_datum('EVT_ID', '0'));
-        if (! \EE_Capabilities::instance()->current_user_can('ee_read_registrations', 'generating_report')) {
+        if ( ! \EE_Capabilities::instance()->current_user_can('ee_read_registrations', 'generating_report')) {
             throw new BatchRequestException(esc_html__('You do not have permission to view registrations', 'event_espresso'));
         }
         $filepath = $this->create_file_from_job_with_name(
@@ -84,7 +84,7 @@ 
                 $query_params['force_join'][] = 'Event';
             }
         }
-        if (! isset($query_params['force_join'])) {
+        if ( ! isset($query_params['force_join'])) {
             $query_params['force_join'] = array('Event', 'Transaction', 'Ticket', 'Attendee');
         }
         $job_parameters->add_extra_data('query_params', $query_params);
@@ -186,10 +186,10 @@ 
         $question_where_params = array();
         foreach ($reg_where_params as $key => $val) {
             if (\EEM_Registration::instance()->is_logic_query_param_key($key)) {
-                $question_where_params[ $key ] = $this->_change_registration_where_params_to_question_where_params($val);
+                $question_where_params[$key] = $this->_change_registration_where_params_to_question_where_params($val);
             } else {
                 // it's a normal where condition
-                $question_where_params[ 'Question_Group.Event.Registration.' . $key ] = $val;
+                $question_where_params['Question_Group.Event.Registration.'.$key] = $val;
             }
         }
         return $question_where_params;
@@ -281,13 +281,13 @@ 
         $query_params['limit'] = [$offset, $limit];
         $registration_rows = $reg_model->get_all_wpdb_results($query_params);
         foreach ($registration_rows as $reg_row) {
-            if (!is_array($reg_row)) {
+            if ( ! is_array($reg_row)) {
                 continue;
             }
             $reg_csv_array = [];
-            if (! $event_id) {
+            if ( ! $event_id) {
                 // get the event's name and Id
-                $reg_csv_array[ (string) esc_html__('Event', 'event_espresso') ] = sprintf(
+                $reg_csv_array[(string) esc_html__('Event', 'event_espresso')] = sprintf(
                     /* translators: 1: event name, 2: event ID */
                     esc_html__('%1$s (%2$s)', 'event_espresso'),
                     EEH_Export::prepare_value_from_db_for_display(
@@ -335,13 +335,13 @@ 
                     $value = EEH_Export::prepare_value_from_db_for_display(
                         $reg_model,
                         $field_name,
-                        $reg_row[ $field->get_qualified_column() ]
+                        $reg_row[$field->get_qualified_column()]
                     );
                 }
-                $reg_csv_array[ EEH_Export::get_column_name_for_field($field) ] = $value;
+                $reg_csv_array[EEH_Export::get_column_name_for_field($field)] = $value;
                 if ($field_name == 'REG_final_price') {
                     // add a column named Currency after the final price
-                    $reg_csv_array[ (string) esc_html__("Currency", "event_espresso") ] = \EE_Config::instance()->currency->code;
+                    $reg_csv_array[(string) esc_html__("Currency", "event_espresso")] = \EE_Config::instance()->currency->code;
                 }
             }
             // get pretty status
@@ -353,17 +353,17 @@ 
                 false,
                 'sentence'
             );
-            $reg_csv_array[ (string) esc_html__("Registration Status", 'event_espresso') ] = $stati[ $reg_row['Registration.STS_ID'] ];
+            $reg_csv_array[(string) esc_html__("Registration Status", 'event_espresso')] = $stati[$reg_row['Registration.STS_ID']];
             // get pretty transaction status
-            $reg_csv_array[ (string) esc_html__("Transaction Status", 'event_espresso') ] = $stati[ $reg_row['TransactionTable.STS_ID'] ];
-            $reg_csv_array[ (string) esc_html__('Transaction Amount Due', 'event_espresso') ] = $is_primary_reg
+            $reg_csv_array[(string) esc_html__("Transaction Status", 'event_espresso')] = $stati[$reg_row['TransactionTable.STS_ID']];
+            $reg_csv_array[(string) esc_html__('Transaction Amount Due', 'event_espresso')] = $is_primary_reg
                 ? EEH_Export::prepare_value_from_db_for_display(
                     EEM_Transaction::instance(),
                     'TXN_total',
                     $reg_row['TransactionTable.TXN_total'],
                     'localized_float'
                 ) : '0.00';
-            $reg_csv_array[ (string) esc_html__('Amount Paid', 'event_espresso') ] = $is_primary_reg
+            $reg_csv_array[(string) esc_html__('Amount Paid', 'event_espresso')] = $is_primary_reg
                 ? EEH_Export::prepare_value_from_db_for_display(
                     EEM_Transaction::instance(),
                     'TXN_paid',
@@ -394,14 +394,14 @@ 
                         ? $payment_method_and_gateway_txn_id['payment_time'] : '';
                 }
             }
-            $reg_csv_array[ (string) esc_html__('Payment Date(s)', 'event_espresso') ] = implode(',', $payment_times);
-            $reg_csv_array[ (string) esc_html__('Payment Method(s)', 'event_espresso') ] = implode(",", $payment_methods);
-            $reg_csv_array[ (string) esc_html__('Gateway Transaction ID(s)', 'event_espresso') ] = implode(
+            $reg_csv_array[(string) esc_html__('Payment Date(s)', 'event_espresso')] = implode(',', $payment_times);
+            $reg_csv_array[(string) esc_html__('Payment Method(s)', 'event_espresso')] = implode(",", $payment_methods);
+            $reg_csv_array[(string) esc_html__('Gateway Transaction ID(s)', 'event_espresso')] = implode(
                 ',',
                 $gateway_txn_ids_etc
             );
             // get whether or not the user has checked in
-            $reg_csv_array[ (string) esc_html__('Check-Ins', 'event_espresso') ] = $reg_model->count_related(
+            $reg_csv_array[(string) esc_html__('Check-Ins', 'event_espresso')] = $reg_model->count_related(
                 $reg_row['Registration.REG_ID'],
                 'Checkin'
             );
@@ -433,8 +433,8 @@ 
                 $ticket_name = esc_html__('Unknown', 'event_espresso');
                 $datetimes_strings = [esc_html__('Unknown', 'event_espresso')];
             }
-            $reg_csv_array[ (string) $ticket_model->field_settings_for('TKT_name')->get_nicename() ] = $ticket_name;
-            $reg_csv_array[ (string) esc_html__("Datetimes of Ticket", "event_espresso") ] = implode(", ", $datetimes_strings);
+            $reg_csv_array[(string) $ticket_model->field_settings_for('TKT_name')->get_nicename()] = $ticket_name;
+            $reg_csv_array[(string) esc_html__("Datetimes of Ticket", "event_espresso")] = implode(", ", $datetimes_strings);
             // get datetime(s) of registration
             // add attendee columns
             foreach ($att_fields_to_include as $att_field_name) {
@@ -458,18 +458,18 @@ 
                         $value = EEH_Export::prepare_value_from_db_for_display(
                             EEM_Attendee::instance(),
                             $att_field_name,
-                            $reg_row[ $field_obj->get_qualified_column() ]
+                            $reg_row[$field_obj->get_qualified_column()]
                         );
                     }
                 } else {
                     $value = '';
                 }
-                $reg_csv_array[ EEH_Export::get_column_name_for_field($field_obj) ] = $value;
+                $reg_csv_array[EEH_Export::get_column_name_for_field($field_obj)] = $value;
             }
             // make sure each registration has the same questions in the same order
             foreach ($question_labels as $question_label) {
-                if (! isset($reg_csv_array[ $question_label ])) {
-                    $reg_csv_array[ $question_label ] = null;
+                if ( ! isset($reg_csv_array[$question_label])) {
+                    $reg_csv_array[$question_label] = null;
                 }
             }
             $answers = EEM_Answer::instance()->get_all_wpdb_results([
@@ -496,12 +496,12 @@ 
                     isset($answer_row['Question.QST_type'])
                     && $answer_row['Question.QST_type'] == EEM_Question::QST_type_state
                 ) {
-                    $reg_csv_array[ $question_label ] = EEM_State::instance()->get_state_name_by_ID(
+                    $reg_csv_array[$question_label] = EEM_State::instance()->get_state_name_by_ID(
                         $answer_row['Answer.ANS_value']
                     );
                 } else {
                     // this isn't for html, so don't show html entities
-                    $reg_csv_array[ $question_label ] = html_entity_decode(
+                    $reg_csv_array[$question_label] = html_entity_decode(
                         EEH_Export::prepare_value_from_db_for_display(
                             EEM_Answer::instance(),
                             'ANS_value',
@@ -564,7 +564,7 @@ 
                             date('Y-m-d H:i:s', $checkin_row->get_raw('CHK_timestamp'))
                         );
                     }
-                    $reg_csv_array[ (string) $datetime_name ] = $checkin_value;
+                    $reg_csv_array[(string) $datetime_name] = $checkin_value;
                 }
             }
             /**
@@ -591,7 +591,7 @@ 
                 $model = EE_Registry::instance()->load_model($model_name);
                 foreach ($field_list as $field_name) {
                     $field = $model->field_settings_for($field_name);
-                    $reg_csv_array[ EEH_Export::get_column_name_for_field($field) ] = null;
+                    $reg_csv_array[EEH_Export::get_column_name_for_field($field)] = null;
                 }
             }
             $registrations_csv_ready_array[] = $reg_csv_array;