'form', // Singular name of the listed records. 'plural' => 'forms', // Plural name of the listed records. 'ajax' => false, // Does this table support ajax? ] ); $this->process_bulk_action(); $this->get_payment_counts(); $this->base_url = admin_url( 'edit.php?post_type=give_forms&page=give-payment-history' ); } /** * Add donation search filter. * * @return void */ public function advanced_filters() { $start_date = isset( $_GET['start-date'] ) ? strtotime( give_clean( $_GET['start-date'] ) ) : ''; $end_date = isset( $_GET['end-date'] ) ? strtotime( give_clean( $_GET['end-date'] ) ) : ''; $status = isset( $_GET['status'] ) ? give_clean( $_GET['status'] ) : ''; $donor = isset( $_GET['donor'] ) ? absint( $_GET['donor'] ) : ''; $search = isset( $_GET['s'] ) ? give_clean( $_GET['s'] ) : ''; $form_id = ! empty( $_GET['form_id'] ) ? absint( $_GET['form_id'] ) : 0; ?>
search_box( __( 'Search', 'give' ), 'give-payments' ); ?>
html->forms_dropdown( [ 'name' => 'form_id', 'id' => 'give-donation-forms-filter', 'class' => 'give-donation-forms-filter', 'selected' => $form_id, // Make sure to have $form_id set to 0, if there is no selection. 'chosen' => true, 'number' => 30, ] ); ?>
', esc_attr( $status ) ); } if ( ! empty( $donor ) ) { echo sprintf( '', absint( $donor ) ); } ?>
'; } if ( ! empty( $_REQUEST['order'] ) ) { echo ''; } ?> [ 'total_count', __( 'All', 'give' ), ], 'publish' => [ 'complete_count', __( 'Completed', 'give' ), ], 'pending' => [ 'pending_count', __( 'Pending', 'give' ), ], 'processing' => [ 'processing_count', __( 'Processing', 'give' ), ], 'refunded' => [ 'refunded_count', __( 'Refunded', 'give' ), ], 'revoked' => [ 'revoked_count', __( 'Revoked', 'give' ), ], 'failed' => [ 'failed_count', __( 'Failed', 'give' ), ], 'cancelled' => [ 'cancelled_count', __( 'Cancelled', 'give' ), ], 'abandoned' => [ 'abandoned_count', __( 'Abandoned', 'give' ), ], 'preapproval' => [ 'preapproval_count', __( 'Preapproval Pending', 'give' ), ], ]; /** * Remove Query from Args of the URL that are being pass to Donation Status. * * @since 1.8.18 */ $args = (array) apply_filters( 'give_payments_table_status_remove_query_arg', [ 'paged', '_wpnonce', '_wp_http_referer' ] ); // Build URL. $staus_url = remove_query_arg( $args ); foreach ( $tabs as $key => $tab ) { $count_key = $tab[0]; $name = $tab[1]; $count = $this->$count_key; /** * Filter can be used to show all the status inside the donation tabs. * * Filter can be used to show all the status inside the donation submenu tabs return true to show all the tab. * * @param string $key Current view tab value. * @param int $count Number of donation inside the tab. * * @since 1.8.12 */ if ( 'all' === $key || $key === $current || apply_filters( 'give_payments_table_show_all_status', 0 < $count, $key, $count ) ) { $staus_url = 'all' === $key ? add_query_arg( [ 'status' => false ], $staus_url ) : add_query_arg( [ 'status' => $key ], $staus_url ); $views[ $key ] = sprintf( '%s (%s)', esc_url( $staus_url ), ( ( 'all' === $key && empty( $current ) ) ) ? ' class="current"' : ( $current == $key ? 'class="current"' : '' ), $name, $count ); } } /** * Filter the donation listing page views. * * @since 1.0 * * @param array $views * @param Give_Payment_History_Table */ return apply_filters( 'give_payments_table_views', $views, $this ); } /** * Retrieve the table columns * * @access public * @since 1.0 * @since 4.3.0 change donation form to campaign * * @return array $columns Array of all the list table columns */ public function get_columns() { $columns = [ 'cb' => '', // Render a checkbox instead of text. 'donation' => __( 'Donation', 'give' ), 'campaign' => __( 'Campaign', 'give' ), 'status' => __( 'Status', 'give' ), 'date' => __( 'Date', 'give' ), 'amount' => __( 'Amount', 'give' ), ]; if ( current_user_can( 'view_give_payments' ) ) { $columns['details'] = __( 'Details', 'give' ); } return apply_filters( 'give_payments_table_columns', $columns ); } /** * Retrieve the table's sortable columns * * @access public * @since 1.0 * * @return array Array of all the sortable columns */ public function get_sortable_columns() { $columns = [ 'donation' => [ 'ID', true ], 'campaign ' => [ 'campaign', false ], 'status' => [ 'status', false ], 'amount' => [ 'amount', false ], 'date' => [ 'date', false ], ]; return apply_filters( 'give_payments_table_sortable_columns', $columns ); } /** * Gets the name of the primary column. * * @since 1.5 * @access protected * * @return string Name of the primary column. */ protected function get_primary_column_name() { return 'donation'; } /** * This function renders most of the columns in the list table. * * @param Give_Payment $payment Payment ID. * @param string $column_name The name of the column. * * @access public * @since 1.0 * @since 4.3.0 show campaign name instead of the form name * * @return string Column Name */ public function column_default( $payment, $column_name ) { $single_donation_url = esc_url( add_query_arg( 'id', $payment->ID, admin_url( 'edit.php?post_type=give_forms&page=give-payment-history&view=view-payment-details' ) ) ); $row_actions = $this->get_row_actions( $payment ); $value = ''; switch ( $column_name ) { case 'donation': $serial_code = Give()->seq_donation_number->get_serial_code( $payment ); if ( current_user_can( 'view_give_payments' ) ) { $value = Give()->tooltips->render_link( [ 'label' => sprintf( __( 'View Donation %s', 'give' ), $serial_code ), 'tag_content' => $serial_code, 'link' => $single_donation_url, ] ); } else { $value = $serial_code; } $value .= sprintf( ' %1$s %2$s
', __( 'by', 'give' ), $this->get_donor( $payment ) ); $value .= $this->get_donor_email( $payment ); $value .= $this->row_actions( $row_actions ); break; case 'amount': $value = give_donation_amount( $payment, true ); $value .= sprintf( '
%1$s %2$s', __( 'via', 'give' ), give_get_gateway_admin_label( $payment->gateway ) ); break; case 'campaign': $donation = Donation::find($payment->ID); $value = '' . $donation->campaign->title . ''; break; case 'date': $date = strtotime( $payment->date ); $value = date_i18n( give_date_format(), $date ); break; case 'status': $value = $this->get_payment_status( $payment ); break; case 'details': if ( current_user_can( 'view_give_payments' ) ) { $value = Give()->tooltips->render_link( [ 'label' => sprintf( __( 'View Donation #%s', 'give' ), $payment->ID ), 'tag_content' => '', 'link' => $single_donation_url, 'attributes' => [ 'class' => 'give-payment-details-link button button-small', ], ] ); $value = "
{$value}
"; } break; default: $value = isset( $payment->$column_name ) ? $payment->$column_name : ''; break; }// End switch(). return apply_filters( 'give_payments_table_column', $value, $payment->ID, $column_name ); } /** * Get donor email html. * * @param object $payment Contains all the data of the payment. * * @access public * @since 1.0 * * @return string Data shown in the Email column */ public function get_donor_email( $payment ) { $email = give_get_payment_user_email( $payment->ID ); if ( empty( $email ) ) { $email = __( '(unknown)', 'give' ); } $value = Give()->tooltips->render_link( [ 'link' => "mailto:{$email}", 'label' => __( 'Email donor', 'give' ), 'tag_content' => $email, ] ); return apply_filters( 'give_payments_table_column', $value, $payment->ID, 'email' ); } /** * Get Row Actions * * @param object $payment Payment Data. * * @since 1.6 * * @return array $actions */ function get_row_actions( $payment ) { $actions = []; $email = give_get_payment_user_email( $payment->ID ); // Add search term string back to base URL. $search_terms = ( isset( $_GET['s'] ) ? trim( $_GET['s'] ) : '' ); if ( ! empty( $search_terms ) ) { $this->base_url = add_query_arg( 's', $search_terms, $this->base_url ); } if ( give_is_payment_complete( $payment->ID ) && ! empty( $email ) ) { $actions['email_links'] = sprintf( '%3$s', esc_url( wp_nonce_url( add_query_arg( [ 'give-action' => 'email_links', 'purchase_id' => $payment->ID, ], $this->base_url ), 'give_payment_nonce' ) ), sprintf( __( 'Resend Donation %s Receipt', 'give' ), $payment->ID ), __( 'Resend Receipt', 'give' ) ); } if ( current_user_can( 'view_give_payments' ) ) { $actions['delete'] = sprintf( '%3$s', esc_url( wp_nonce_url( add_query_arg( [ 'give-action' => 'delete_payment', 'purchase_id' => $payment->ID, ], $this->base_url ), 'give_donation_nonce' ) ), sprintf( __( 'Delete Donation %s', 'give' ), $payment->ID ), __( 'Delete', 'give' ) ); } return apply_filters( 'give_payment_row_actions', $actions, $payment ); } /** * Get payment status html. * * @since 1.0 * @access public * * @param Give_Payment $payment Contains all the data of the payment. * * @return string Data shown in the Email column */ function get_payment_status( $payment ) { $value = sprintf( '
 %2$s
', $payment->status, give_get_payment_status( $payment, true ) ); if ( $payment->mode == 'test' ) { $value .= Give()->tooltips->render_span( [ 'label' => __( 'This donation was made in test mode.', 'give' ), 'tag_content' => __( 'Test', 'give' ), 'attributes' => [ 'class' => 'give-item-label give-item-label-orange give-test-mode-transactions-label', ], ] ); } if ( true === $payment->import && true === (bool) apply_filters( 'give_payment_show_importer_label', false ) ) { $value .= sprintf( ' %2$s', __( 'This donation was imported.', 'give' ), __( 'Import', 'give' ) ); } return $value; } /** * Get checkbox html. * * @param object $payment Contains all the data for the checkbox column. * * @access public * @since 1.0 * * @return string Displays a checkbox. */ public function column_cb( $payment ) { return sprintf( '', 'payment', $payment->ID ); } /** * Get payment ID html. * * @param object $payment Contains all the data for the checkbox column. * * @access public * @since 1.0 * * @return string Displays a checkbox. */ public function get_payment_id( $payment ) { return '' . give_get_payment_number( $payment->ID ) . ''; } /** * Get donor html. * * @param object $payment Contains all the data of the payment. * * @access public * @since 1.0 * * @return string Data shown in the User column */ public function get_donor( $payment ) { $donor_id = give_get_payment_donor_id( $payment->ID ); $donor_billing_name = give_get_donor_name_by( $payment->ID, 'donation' ); $donor_name = give_get_donor_name_by( $donor_id, 'donor' ); $value = ''; if ( ! empty( $donor_id ) ) { // Check whether the donor name and WP_User name is same or not. if ( sanitize_title( $donor_billing_name ) !== sanitize_title( $donor_name ) ) { $value .= $donor_billing_name . ' ('; } $value .= '' . $donor_name . ''; // Check whether the donor name and WP_User name is same or not. if ( sanitize_title( $donor_billing_name ) != sanitize_title( $donor_name ) ) { $value .= ')'; } } else { $email = give_get_payment_user_email( $payment->ID ); $value .= sprintf( '%2$s (%3$s)', esc_url( admin_url( "edit.php?post_type=give_forms&page=give-payment-history&s=$email" ) ), give_get_donor_name_by( $payment->ID, 'donation' ), esc_html__( 'donor missing', 'give' ) ); } return apply_filters( 'give_payments_table_column', $value, $payment->ID, 'donor' ); } /** * Retrieve the bulk actions * * @access public * @since 1.0 * * @return array $actions Array of the bulk actions */ public function get_bulk_actions() { $actions = [ 'delete' => __( 'Delete', 'give' ), 'set-status-publish' => __( 'Set To Completed', 'give' ), 'set-status-pending' => __( 'Set To Pending', 'give' ), 'set-status-processing' => __( 'Set To Processing', 'give' ), 'set-status-refunded' => __( 'Set To Refunded', 'give' ), 'set-status-revoked' => __( 'Set To Revoked', 'give' ), 'set-status-failed' => __( 'Set To Failed', 'give' ), 'set-status-cancelled' => __( 'Set To Cancelled', 'give' ), 'set-status-abandoned' => __( 'Set To Abandoned', 'give' ), 'set-status-preapproval' => __( 'Set To Preapproval', 'give' ), 'resend-receipt' => __( 'Resend Email Receipts', 'give' ), ]; return apply_filters( 'give_payments_table_bulk_actions', $actions ); } /** * Process the bulk actions * * @since 2.25.2 Add nonce check for bulk action. * @since 1.0 * * @access public * * @return void */ public function process_bulk_action() { $ids = isset($_GET['payment']) ? $_GET['payment'] : false; $action = $this->current_action(); if ( ! is_array($ids)) { $ids = [$ids]; } if ( empty($action) || ! current_user_can('edit_give_payments') ) { return; } give_validate_nonce($_GET['_wpnonce'] ?? '', 'bulk-forms'); foreach ($ids as $id) { // Detect when a bulk action is being triggered. switch ( $this->current_action() ) { case 'delete': if ( ! current_user_can( 'delete_give_payments' ) ) { return; } give_delete_donation( $id ); break; case 'set-status-publish': give_update_payment_status( $id, 'publish' ); break; case 'set-status-pending': give_update_payment_status( $id, 'pending' ); break; case 'set-status-processing': give_update_payment_status( $id, 'processing' ); break; case 'set-status-refunded': give_update_payment_status( $id, 'refunded' ); break; case 'set-status-revoked': give_update_payment_status( $id, 'revoked' ); break; case 'set-status-failed': give_update_payment_status( $id, 'failed' ); break; case 'set-status-cancelled': give_update_payment_status( $id, 'cancelled' ); break; case 'set-status-abandoned': give_update_payment_status( $id, 'abandoned' ); break; case 'set-status-preapproval': give_update_payment_status( $id, 'preapproval' ); break; case 'resend-receipt': /** * Fire the action * * @since 2.0 */ do_action( 'give_donation-receipt_email_notification', $id ); break; }// End switch(). /** * Fires after triggering bulk action on payments table. * * @param int $id The ID of the payment. * @param string $current_action The action that is being triggered. * * @since 1.7 */ do_action( 'give_payments_table_do_bulk_action', $id, $this->current_action() ); }// End foreach(). } /** * Retrieve the payment counts * * @access public * @since 1.0 * * @return object */ public function get_payment_counts() { $args = []; if ( isset( $_GET['user'] ) ) { $args['user'] = urldecode( $_GET['user'] ); } elseif ( isset( $_GET['donor'] ) ) { $args['donor'] = absint( $_GET['donor'] ); } elseif ( isset( $_GET['s'] ) ) { $is_user = strpos( $_GET['s'], strtolower( 'user:' ) ) !== false; if ( $is_user ) { $args['user'] = absint( trim( str_replace( 'user:', '', strtolower( $_GET['s'] ) ) ) ); unset( $args['s'] ); } else { $args['s'] = sanitize_text_field( $_GET['s'] ); } } if ( ! empty( $_GET['start-date'] ) ) { $args['start-date'] = urldecode( $_GET['start-date'] ); } if ( ! empty( $_GET['end-date'] ) ) { $args['end-date'] = urldecode( $_GET['end-date'] ); } $args['form_id'] = ! empty( $_GET['form_id'] ) ? absint( $_GET['form_id'] ) : null; $args['gateway'] = ! empty( $_GET['gateway'] ) ? give_clean( $_GET['gateway'] ) : null; $payment_count = give_count_payments( $args ); $this->complete_count = $payment_count->publish; $this->pending_count = $payment_count->pending; $this->processing_count = $payment_count->processing; $this->refunded_count = $payment_count->refunded; $this->failed_count = $payment_count->failed; $this->revoked_count = $payment_count->revoked; $this->cancelled_count = $payment_count->cancelled; $this->abandoned_count = $payment_count->abandoned; $this->preapproval_count = $payment_count->preapproval; foreach ( $payment_count as $count ) { $this->total_count += $count; } return $payment_count; } /** * Retrieve all the data for all the payments. * * @access public * @since 1.0 * * @return array objects in array containing all the data for the payments */ public function payments_data() { $per_page = $this->per_page; $orderby = isset( $_GET['orderby'] ) ? urldecode( $_GET['orderby'] ) : 'ID'; $order = isset( $_GET['order'] ) ? give_clean( $_GET['order'] ) : 'DESC'; $user = isset( $_GET['user'] ) ? absint( $_GET['user'] ) : null; $donor = isset( $_GET['donor'] ) ? absint( $_GET['donor'] ) : null; $status = isset( $_GET['status'] ) ? give_clean( $_GET['status'] ) : give_get_payment_status_keys(); $meta_key = isset( $_GET['meta_key'] ) ? give_clean( $_GET['meta_key'] ) : null; $year = isset( $_GET['year'] ) ? give_clean( $_GET['year'] ) : null; $month = isset( $_GET['m'] ) ? give_clean( $_GET['m'] ) : null; $day = isset( $_GET['day'] ) ? give_clean( $_GET['day'] ) : null; $search = isset( $_GET['s'] ) ? sanitize_text_field( $_GET['s'] ) : null; $start_date = ! empty( $_GET['start-date'] ) ? give_clean( $_GET['start-date'] ) : date( 'Y-m-d', 0 ); $end_date = ! empty( $_GET['end-date'] ) ? give_clean( $_GET['end-date'] ) : date( 'Y-m-d', current_time( 'timestamp' ) ); $form_id = ! empty( $_GET['form_id'] ) ? absint( $_GET['form_id'] ) : null; $gateway = ! empty( $_GET['gateway'] ) ? give_clean( $_GET['gateway'] ) : null; $args = [ 'output' => 'payments', 'number' => $per_page, 'page' => isset( $_GET['paged'] ) ? $_GET['paged'] : null, 'orderby' => $orderby, 'order' => $order, 'user' => $user, 'donor' => $donor, 'status' => $status, 'meta_key' => $meta_key, 'year' => $year, 'month' => $month, 'day' => $day, 's' => $search, 'start_date' => $start_date, 'gateway' => $gateway, 'end_date' => $end_date, 'give_forms' => $form_id, ]; if ( is_string( $search ) && false !== strpos( $search, 'txn:' ) ) { $args['search_in_notes'] = true; $args['s'] = trim( str_replace( 'txn:', '', $args['s'] ) ); } /** * Filter to modify payment table argument. * * @since 1.8.18 */ $args = (array) apply_filters( 'give_payment_table_payments_query', $args ); $p_query = new Give_Payments_Query( $args ); return $p_query->get_payments(); } /** * Setup the final data for the table * * @access public * @since 1.0 * @uses Give_Payment_History_Table::get_columns() * @uses Give_Payment_History_Table::get_sortable_columns() * @uses Give_Payment_History_Table::payments_data() * @uses WP_List_Table::get_pagenum() * @uses WP_List_Table::set_pagination_args() * * @return void */ public function prepare_items() { wp_reset_vars( [ 'action', 'payment', 'orderby', 'order', 's' ] ); $columns = $this->get_columns(); $hidden = []; // No hidden columns. $sortable = $this->get_sortable_columns(); $data = $this->payments_data(); $status = isset( $_GET['status'] ) ? $_GET['status'] : 'any'; $this->_column_headers = [ $columns, $hidden, $sortable ]; switch ( $status ) { case 'publish': $total_items = $this->complete_count; break; case 'pending': $total_items = $this->pending_count; break; case 'processing': $total_items = $this->processing_count; break; case 'refunded': $total_items = $this->refunded_count; break; case 'failed': $total_items = $this->failed_count; break; case 'revoked': $total_items = $this->revoked_count; break; case 'cancelled': $total_items = $this->cancelled_count; break; case 'abandoned': $total_items = $this->abandoned_count; break; case 'preapproval': $total_items = $this->preapproval_count; break; case 'any': $total_items = $this->total_count; break; default: // Retrieve the count of the non-default-Give status. $count = wp_count_posts( 'give_payment' ); $total_items = isset( $count->{$status} ) ? $count->{$status} : 0; break; } $this->items = $data; /** * Filter to modify total count of the pagination. * * @since 1.8.19 */ $total_items = (int) apply_filters( 'give_payment_table_pagination_total_count', $total_items, $this ); $this->set_pagination_args( [ 'total_items' => $total_items, // We have to calculate the total number of items. 'per_page' => $this->per_page, // We have to determine how many items to show on a page. 'total_pages' => ceil( $total_items / $this->per_page ), // We have to calculate the total number of pages. ] ); } }