array( 'referrals' => _affiliates_get_tablename( 'referrals' ), 'affiliates' => _affiliates_get_tablename( 'affiliates' ), 'affiliates_users' => _affiliates_get_tablename( 'affiliates_users' ), 'users' => $wpdb->users, ) ); $params = array_merge( $_GET, $params ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended echo self::update_status( AFFILIATES_REFERRAL_STATUS_CLOSED, $params ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped die(); break; } } $from_date = $affiliates_options->get_option( 'totals_from_date', null ); $from_datetime = null; $thru_date = $affiliates_options->get_option( 'totals_thru_date', null ); $thru_datetime = null; $affiliate_status = $affiliates_options->get_option( 'totals_affiliate_status', null ); $referral_status = $affiliates_options->get_option( 'totals_referral_status', null ); $currency_id = $affiliates_options->get_option( 'totals_currency_id', null ); if ( isset( $_POST['clear_filters'] ) || isset( $_POST['submitted'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing if ( !affiliates_verify_post_nonce( self::NONCE, self::SET_FILTERS ) ) { wp_die( esc_html__( 'Access denied.', 'affiliates' ) ); } } if ( isset( $_POST['clear_filters'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing $affiliates_options->delete_option( 'totals_from_date' ); $affiliates_options->delete_option( 'totals_thru_date' ); $affiliates_options->delete_option( 'totals_affiliate_status' ); $affiliates_options->delete_option( 'totals_referral_status' ); $affiliates_options->delete_option( 'totals_currency_id' ); $from_date = null; $from_datetime = null; $thru_date = null; $thru_datetime = null; $affiliate_status = null; $referral_status = null; $currency_id = null; } else if ( isset( $_POST['submitted'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing if ( !empty( $_POST['from_date'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing $from_date = date( 'Y-m-d', strtotime( affiliates_sanitize_post( 'from_date' ) ) ); // phpcs:ignore WordPress.DateTime.RestrictedFunctions.date_date $affiliates_options->update_option( 'totals_from_date', $from_date ); } else { $from_date = null; $affiliates_options->delete_option( 'totals_from_date' ); } if ( !empty( $_POST['thru_date'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing $thru_date = date( 'Y-m-d', strtotime( affiliates_sanitize_post( 'thru_date' ) ) ); // phpcs:ignore WordPress.DateTime.RestrictedFunctions.date_date $affiliates_options->update_option( 'totals_thru_date', $thru_date ); } else { $thru_date = null; $affiliates_options->delete_option( 'totals_thru_date' ); } if ( $from_date && $thru_date ) { if ( strtotime( $from_date ) > strtotime( $thru_date ) ) { $thru_date = null; $affiliates_options->delete_option( 'totals_thru_date' ); } } if ( !empty( $_POST['affiliate_status'] ) && ( $affiliate_status = Affiliates_Utility::verify_affiliate_status( affiliates_sanitize_post( 'affiliate_status' ) ) ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing $affiliates_options->update_option( 'totals_affiliate_status', $affiliate_status ); } else { $affiliate_status = null; $affiliates_options->delete_option( 'totals_affiliate_status' ); } if ( !empty( $_POST['referral_status'] ) && ( $referral_status = Affiliates_Utility::verify_referral_status_transition( affiliates_sanitize_post( 'referral_status' ), affiliates_sanitize_post( 'referral_status' ) ) ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing $affiliates_options->update_option( 'totals_referral_status', $referral_status ); } else { $referral_status = null; $affiliates_options->delete_option( 'totals_referral_status' ); } if ( !empty( $_POST['currency_id'] ) && ( $currency_id = Affiliates_Utility::verify_currency_id( affiliates_sanitize_post( 'currency_id' ) ) ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing $affiliates_options->update_option( 'totals_currency_id', $currency_id ); } else { $currency_id = null; $affiliates_options->delete_option( 'totals_currency_id' ); } } if ( isset( $_POST['row_count'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing if ( !affiliates_verify_post_nonce( self::NONCE_1, self::SET_RPP ) ) { wp_die( esc_html__( 'Access denied.', 'affiliates' ) ); } } if ( isset( $_POST['paged'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification.Missing if ( !affiliates_verify_post_nonce( self::NONCE_2, self::SET_PAGE ) ) { wp_die( esc_html__( 'Access denied.', 'affiliates' ) ); } } $current_url = affiliates_get_current_url(); $current_url = remove_query_arg( 'paged', $current_url ); $current_url = remove_query_arg( 'action', $current_url ); $current_url = remove_query_arg( 'affiliate_id', $current_url ); $referrals_table = _affiliates_get_tablename( 'referrals' ); $affiliates_table = _affiliates_get_tablename( 'affiliates' ); $affiliates_users_table = _affiliates_get_tablename( 'affiliates_users' ); $output .= '
'; $output .= '

'; $output .= esc_html__( 'Totals', 'affiliates' ); $output .= '

'; $row_count = intval( affiliates_sanitize_post( 'row_count' ) ?? 0 ); if ( $row_count <= 0 ) { $row_count = $affiliates_options->get_option( 'totals_per_page', self::TOTALS_PER_PAGE ); } else { $affiliates_options->update_option( 'totals_per_page', $row_count ); } $offset = intval( affiliates_sanitize_get( 'offset' ) ?? 0 ); if ( $offset < 0 ) { $offset = 0; } $paged = intval( affiliates_sanitize_request( 'paged' ) ?? 0 ); if ( $paged < 0 ) { $paged = 0; } $orderby = affiliates_sanitize_get( 'orderby' ); switch ( $orderby ) { case 'affiliate_id' : case 'name' : case 'user_login' : case 'email' : case 'total' : case 'currency_id' : break; default: $orderby = 'name'; } $order = affiliates_sanitize_get( 'order' ); switch ( $order ) { case 'asc' : case 'ASC' : $switch_order = 'DESC'; break; case 'desc' : case 'DESC' : $switch_order = 'ASC'; break; default: $order = 'ASC'; $switch_order = 'DESC'; } $filters = array( " 1=%d " ); $filter_params = array( 1 ); // We have the desired dates from the user's point of view, i.e. in her timezone. // If supported, adjust the dates for the site's timezone: if ( $from_date ) { $from_datetime = DateHelper::u2s( $from_date ); } if ( $thru_date ) { $thru_datetime = DateHelper::u2s( $thru_date, 24*3600 ); } if ( $from_datetime && $thru_datetime ) { $filters[] = " r.datetime >= %s AND r.datetime < %s "; $filter_params[] = $from_datetime; $filter_params[] = $thru_datetime; } else if ( $from_datetime ) { $filters[] = " r.datetime >= %s "; $filter_params[] = $from_datetime; } else if ( $thru_datetime ) { $filters[] = " r.datetime < %s "; $filter_params[] = $thru_datetime; } if ( $affiliate_status ) { $filters[] = " a.status = %s "; $filter_params[] = $affiliate_status; } if ( $referral_status ) { $filters[] = " r.status = %s "; $filter_params[] = $referral_status; } if ( $currency_id ) { $filters[] = " r.currency_id = %s "; $filter_params[] = $currency_id; } if ( !empty( $filters ) ) { $filters = " WHERE " . implode( " AND ", $filters ); } else { $filters = ''; } $having = ''; // note double select to obtain number of rows (otherwise group counts are obtained) $count = $wpdb->get_var( $wpdb->prepare( " SELECT COUNT(*) FROM ( SELECT r.affiliate_id FROM $referrals_table r LEFT JOIN $affiliates_table a ON r.affiliate_id = a.affiliate_id LEFT JOIN $affiliates_users_table au ON a.affiliate_id = au.affiliate_id LEFT JOIN $wpdb->users u on au.user_id = u.ID $filters GROUP BY r.affiliate_id, r.currency_id $having ) tmp ", $filter_params ) ); if ( $count > $row_count ) { $paginate = true; } else { $paginate = false; } $pages = ceil ( $count / $row_count ); if ( $paged > $pages ) { $paged = $pages; } if ( $paged != 0 ) { $offset = ( $paged - 1 ) * $row_count; } $results = $wpdb->get_results( $wpdb->prepare( " SELECT a.*, u.user_login, SUM(r.amount) as total, r.currency_id FROM $referrals_table r LEFT JOIN $affiliates_table a ON r.affiliate_id = a.affiliate_id LEFT JOIN $affiliates_users_table au ON a.affiliate_id = au.affiliate_id LEFT JOIN $wpdb->users u on au.user_id = u.ID $filters GROUP BY r.affiliate_id, r.currency_id $having ORDER BY $orderby $order LIMIT $row_count OFFSET $offset ", $filter_params ) ); $column_display_names = array( 'affiliate_id' => __( 'Id', 'affiliates' ), 'name' => __( 'Affiliate', 'affiliates' ), 'email' => __( 'Email', 'affiliates' ), 'user_login' => __( 'Username', 'affiliates' ), 'total' => __( 'Total', 'affiliates' ), 'currency_id' => __( 'Currency', 'affiliates' ) ); $output .= '
'; $mp_params = ''; if ( !empty( $from_date ) ) { $mp_params .= '&from_date=' . urlencode( $from_date ); } if ( !empty( $thru_date ) ) { $mp_params .= '&thru_date=' . urlencode( $thru_date ); } if ( !empty( $affiliate_status ) ) { $mp_params .= '&affiliate_status=' . urlencode( $affiliate_status ); } if ( !empty( $referral_status ) ) { $mp_params .= '&referral_status=' . urlencode( $referral_status ); } if ( !empty( $currency_id ) ) { $mp_params .= '¤cy_id=' . urlencode( $currency_id ); } if ( !empty( $orderby ) ) { $mp_params .= '&orderby=' . urlencode( $orderby ); } if ( !empty( $order ) ) { $mp_params .= '&order=' . urlencode( $order ); } $output .= ''; $output .= '
'; $output .= '

'; $output .= sprintf( '' . '%3$s' . '%5$s' . '', esc_attr__( 'Click to close these referrals', 'affiliates' ), esc_url( $current_url . '&action=close_referrals' . $mp_params ), esc_attr__( 'Close referrals', 'affiliates' ), AFFILIATES_PLUGIN_URL . 'images/closed.png', esc_html__( 'Close Referrals', 'affiliates' ) ); $output .= '

'; $output .= '
'; $affiliate_status_descriptions = array( AFFILIATES_AFFILIATE_STATUS_ACTIVE => __( 'Active', 'affiliates' ), AFFILIATES_AFFILIATE_STATUS_PENDING => __( 'Pending', 'affiliates' ), AFFILIATES_AFFILIATE_STATUS_DELETED => __( 'Deleted', 'affiliates' ), ); $affiliate_status_select = ''; $status_descriptions = array( AFFILIATES_REFERRAL_STATUS_ACCEPTED => __( 'Accepted', 'affiliates' ), AFFILIATES_REFERRAL_STATUS_CLOSED => __( 'Closed', 'affiliates' ), AFFILIATES_REFERRAL_STATUS_PENDING => __( 'Pending', 'affiliates' ), AFFILIATES_REFERRAL_STATUS_REJECTED => __( 'Rejected', 'affiliates' ), ); $status_select = ''; $currencies = $wpdb->get_results( "SELECT DISTINCT(currency_id) FROM $referrals_table WHERE currency_id IS NOT NULL" ); $currency_select = ''; $output .= '
'; $output .= ''; $output .= '
'; $output .= '
'; $output .= $status_select; $output .= ' '; $output .= $currency_select; $output .= ' '; $output .= $affiliate_status_select; $output .= '
'; $output .= '
'; $output .= ''; $output .= ''; $output .= '
'; $output .= '
'; $output .= wp_nonce_field( self::SET_FILTERS, self::NONCE, true, false ); $output .= ''; $output .= ''; $output .= ''; $output .= '
'; $output .= '
'; $output .= '
'; $output .= '
'; $output .= '
'; $output .= '
'; $output .= ''; $output .= ''; $output .= wp_nonce_field( self::SET_RPP, self::NONCE_1, true, false ); $output .= ''; $output .= '
'; $output .= '
'; $output .= '
'; if ( $paginate ) { require_once( AFFILIATES_CORE_LIB . '/class-affiliates-pagination.php' ); $pagination = new Affiliates_Pagination( $count, null, $row_count ); $output .= '
'; $output .= '
'; $output .= wp_nonce_field( self::SET_PAGE, self::NONCE_2, true, false ); $output .= '
'; $output .= '
'; $output .= $pagination->pagination( 'top' ); $output .= '
'; $output .= '
'; } $output .= ''; $output .= ''; $output .= ''; foreach ( $column_display_names as $key => $column_display_name ) { $options = array( 'orderby' => $key, 'order' => $switch_order ); $class = $key; if ( !in_array($key, array( 'edit', 'remove', 'links' ) ) ) { if ( strcmp( $key, $orderby ) == 0 ) { $lorder = strtolower( $order ); $class = "$key manage-column sorted $lorder"; } else { $class = "$key manage-column sortable"; } $column_display_name = sprintf( '%2$s' . '' . ''. ''. '' . '', esc_url( add_query_arg( $options, $current_url ) ), esc_html( $column_display_name ) ); } $output .= sprintf( '', esc_attr( $class ), $column_display_name // phpcs:ignore ); } $output .= ''; $output .= ''; $output .= ''; if ( count( $results ) > 0 ) { for ( $i = 0; $i < count( $results ); $i++ ) { $result = $results[$i]; $name_suffix = ''; $class_deleted = ''; if ( $is_deleted = ( $result->status !== null && strcmp( $result->status, 'deleted' ) == 0 ) ) { $class_deleted = ' deleted '; $name_suffix .= ' ' . __( '(removed)', 'affiliates' ); } $class_inoperative = ''; if ( $is_inoperative = ! ( ( $result->from_date <= $today ) && ( $result->thru_date == null || $result->thru_date >= $today ) ) ) { $class_inoperative = ' inoperative '; $name_suffix .= " " . __( '(inoperative)', 'affiliates' ); } $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= ''; $output .= sprintf( '', esc_html( affiliates_format_referral_amount( $result->total, 'display' ) ) ); $output .= ''; $output .= ''; } } else { $output .= ''; $output .= ''; $output .= ''; } $output .= ''; $output .= '
%2$s
'; if ( affiliates_encode_affiliate_id( $result->affiliate_id ) != $result->affiliate_id ) { $output .= '' . esc_html( $result->affiliate_id ) . ''; } else { $output .= esc_html( $result->affiliate_id ); } $output .= '' . stripslashes( wp_filter_nohtml_kses( $result->name ) ) . esc_html( $name_suffix ) . '' . esc_html( $result->email ) . '%s' . esc_html( $result->currency_id ) . '
'; $output .= esc_html__( 'There are no results.', 'affiliates' ); $output .= '
'; if ( $paginate ) { $pagination = new Affiliates_Pagination($count, null, $row_count); $output .= '
'; $output .= $pagination->pagination( 'bottom' ); $output .= '
'; } $output .= '
'; // .totals-overview $output .= '
'; // .totals echo $output; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped affiliates_footer(); } public static function update_status( $new_status, $params = null ) { global $wpdb; $output = ''; $from_date = isset( $params['from_date'] ) ? $params['from_date'] : null; $from_datetime = $from_date ? DateHelper::u2s( $from_date ) : null; $thru_date = isset( $params['thru_date'] ) ? $params['thru_date'] : null; $thru_datetime = $thru_date ? DateHelper::u2s( $thru_date, 24*3600 ) : null; $affiliate_status = isset( $params['affiliate_status'] ) ? Affiliates_Utility::verify_affiliate_status( $params['affiliate_status'] ) : null; $referral_status = isset( $params['referral_status'] ) ? Affiliates_Utility::verify_referral_status_transition( $params['referral_status'], $params['referral_status'] ) : null; $currency_id = isset( $params['currency_id'] ) ? Affiliates_Utility::verify_currency_id( $params['currency_id'] ) : null; $orderby = isset( $params['orderby'] ) ? $params['orderby'] : null; $order = isset( $params['order'] ) ? $params['order'] : null; switch ( $orderby ) { case 'affiliate_id' : case 'name' : case 'email' : $orderby = 'a.' . $orderby; break; case 'user_login' : $orderby = 'au.' . $orderby; break; case 'currency_id' : $orderby = 'r.' . $orderby; break; default: $orderby = 'a.name'; } switch ( $order ) { case 'asc' : case 'ASC' : case 'desc' : case 'DESC' : break; default: $order = 'ASC'; } if ( isset( $params['tables'] ) ) { $output .= '

' . esc_html__( "Closing referrals", 'affiliates' ) . '

'; $output .= '
'; $affiliates_table = $params['tables']['affiliates']; $affiliates_users_table = $params['tables']['affiliates_users']; $referrals_table = $params['tables']['referrals']; $users_table = $params['tables']['users']; $filters = array( " 1=%d " ); $filter_params = array( 1 ); if ( $from_datetime && $thru_datetime ) { $filters[] = " r.datetime >= %s AND r.datetime < %s "; $filter_params[] = $from_datetime; $filter_params[] = $thru_datetime; } else if ( $from_datetime ) { $filters[] = " r.datetime >= %s "; $filter_params[] = $from_datetime; } else if ( $thru_datetime ) { $filters[] = " r.datetime < %s "; $filter_params[] = $thru_datetime; } if ( $affiliate_status ) { $filters[] = " a.status = %s "; $filter_params[] = $affiliate_status; } if ( $referral_status ) { $filters[] = " r.status = %s "; $filter_params[] = $referral_status; } if ( $currency_id ) { $filters[] = " r.currency_id = %s "; $filter_params[] = $currency_id; } if ( !empty( $filters ) ) { $filters = " WHERE " . implode( " AND ", $filters ); } else { $filters = ''; } $order_by = ''; if ( $orderby && $order ) { $order_by .= " ORDER BY $orderby $order "; } $step = isset( $params['step'] ) ? intval( $params['step'] ) : 1; switch ( $step ) { case 1 : $results = $wpdb->get_results( $wpdb->prepare( " SELECT a.*, r.*, u.user_login FROM $referrals_table r LEFT JOIN $affiliates_table a ON r.affiliate_id = a.affiliate_id LEFT JOIN $affiliates_users_table au ON a.affiliate_id = au.affiliate_id LEFT JOIN $users_table u on au.user_id = u.ID $filters $order_by ", $filter_params ) ); $output .= '
'; $output .= '
'; $output .= '

'; $output .= ''; $output .= esc_html__( 'Please review the list of referrals that will be closed.', 'affiliates' ); $output .= ''; $output .= '

'; $output .= '
'; // .warning $output .= '

'; $output .= esc_html__( 'Usually only referrals that are accepted and have been paid out should be closed. If there are unwanted or too many referrals shown, restrict your filter settings.', 'affiliates' ); $output .= '

'; $output .= '

'; $output .= esc_html__( 'If these referrals can be closed, click the confirmation button below.', 'affiliates' ); $output .= '

'; $output .= '
'; $output .= '
'; $output .= self::render_results( $results ); $output .= '
'; // .referrals-overview if ( count( $results ) > 0 ) { $mp_params = ""; if ( !empty( $from_date ) ) { $mp_params .= "&from_date=" . urlencode( $from_date ); } if ( !empty( $thru_date ) ) { $mp_params .= "&thru_date=" . urlencode( $thru_date ); } if ( !empty( $affiliate_status ) ) { $mp_params .= "&affiliate_status=" . urlencode( $affiliate_status ); } if ( !empty( $referral_status ) ) { $mp_params .= "&referral_status=" . urlencode( $referral_status ); } if ( !empty( $currency_id ) ) { $mp_params .= "¤cy_id=" . urlencode( $currency_id ); } if ( !empty( $orderby ) ) { $mp_params .= "&orderby=" . urlencode( $orderby ); } if ( !empty( $order ) ) { $mp_params .= "&order=" . urlencode( $order ); } $output .= '
'; $current_url = affiliates_get_current_url(); $current_url = remove_query_arg( 'paged', $current_url ); $current_url = remove_query_arg( 'action', $current_url ); $current_url = remove_query_arg( 'affiliate_id', $current_url ); $output .= ''; $output .= '

'; $output .= esc_html__( 'Close these referrals by clicking:', 'affiliates' ); $output .= '

'; $output .= sprintf( '', esc_attr__( 'Click to close these referrals', 'affiliates' ), esc_url( $current_url . "&action=close_referrals&step=2" . $mp_params ) ); $output .= sprintf( '%1$s', esc_attr__( 'Close referrals', 'affiliates' ), AFFILIATES_PLUGIN_URL . 'images/closed.png' ); $output .= ''; $output .= esc_html__( 'Close Referrals', 'affiliates' ); $output .= ''; $output .= ''; $output .= '
'; $output .= '

'; $output .= ''; $output .= esc_html__( 'This action can not be undone.', 'affiliates' ) . ' *'; $output .= ''; $output .= '

'; $output .= '

'; $output .= ''; $output .= '* ' . esc_html__( 'To undo, each referral would have to be set to the desired status individually.', 'affiliates' ); $output .= ''; $output .= '

'; $output .= '
'; // .warning $output .= '
'; // .manage.confirm } break; // step 1 - ask for confirmation confirmation case 2 : // try to make the changes $results = $wpdb->get_results( $wpdb->prepare( " SELECT a.*, r.*, u.user_login FROM $referrals_table r LEFT JOIN $affiliates_table a ON r.affiliate_id = a.affiliate_id LEFT JOIN $affiliates_users_table au ON a.affiliate_id = au.affiliate_id LEFT JOIN $users_table u on au.user_id = u.ID $filters $order_by ", $filter_params ) ); $updated = array(); $omitted = array(); $failed = array(); foreach ( $results as $result ) { if ( $s = Affiliates_Utility::verify_referral_status_transition( $result->status, $new_status ) ) { if ( $wpdb->query( $wpdb->prepare( "UPDATE $referrals_table SET status = %s WHERE affiliate_id = %d AND post_id = %d AND datetime = %s ", $s, $result->affiliate_id, $result->post_id, $result->datetime ) ) ) { $result->status = $s; $updated[] = $result; } else { $failed[] = $result; } } else { $omitted[] = $result; } } // always show at least the updated table because this will // also give information if no results have been updated $status_descriptions = array( AFFILIATES_REFERRAL_STATUS_ACCEPTED => __( 'Accepted', 'affiliates' ), AFFILIATES_REFERRAL_STATUS_CLOSED => __( 'Closed', 'affiliates' ), AFFILIATES_REFERRAL_STATUS_PENDING => __( 'Pending', 'affiliates' ), AFFILIATES_REFERRAL_STATUS_REJECTED => __( 'Rejected', 'affiliates' ), ); $output .= '

' . esc_html__( 'Updated', 'affiliates' ) . '

'; $output .= '

'; $output .= sprintf( /* translators: status */ esc_html__( 'These referrals have been updated to %s.', 'affiliates' ), '' . ( isset( $status_descriptions[$new_status] ) ? $status_descriptions[$new_status] : $new_status ) . '' ); $output .= '

'; $output .= self::render_results( $updated ); if ( count( $omitted ) > 0 ) { $output .= '

' . esc_html__( 'Omitted', 'affiliates' ) . '

'; $output .= '

'; $output .= sprintf( /* translators: status */ esc_html__( 'These referrals have been omitted because their status must not be changed to %s.', 'affiliates' ), '' . ( isset( $status_descriptions[$new_status] ) ? $status_descriptions[$new_status] : $new_status ) . '' ); $output .= '

'; $output .= self::render_results( $omitted ); } if ( count( $failed ) > 0 ) { $output .= '

' . esc_html__( 'Failed', 'affiliates' ) . '

'; $output .= '

'; $output .= sprintf( /* translators: status */ esc_html__( 'These referrals could not be updated to %s.', 'affiliates' ), '' . ( isset( $status_descriptions[$new_status] ) ? $status_descriptions[$new_status] : $new_status ) . '' ); $output .= '

'; $output .= self::render_results( $failed ); } break; // step 2 -commit changes } $output .= '
';// .closing-referrals-overview } return $output; } public static function render_results( $results ) { $output = ""; $column_display_names = array( 'datetime' => __( 'Date', 'affiliates' ), 'post_title' => __( 'Post', 'affiliates' ), 'name' => __( 'Affiliate', 'affiliates' ), 'amount' => __( 'Amount', 'affiliates' ), 'currency_id' => __( 'Currency', 'affiliates' ), 'status' => __( 'Status', 'affiliates' ) ); $status_descriptions = array( AFFILIATES_REFERRAL_STATUS_ACCEPTED => __( 'Accepted', 'affiliates' ), AFFILIATES_REFERRAL_STATUS_CLOSED => __( 'Closed', 'affiliates' ), AFFILIATES_REFERRAL_STATUS_PENDING => __( 'Pending', 'affiliates' ), AFFILIATES_REFERRAL_STATUS_REJECTED => __( 'Rejected', 'affiliates' ), ); $status_icons = array( AFFILIATES_REFERRAL_STATUS_ACCEPTED => "" . __( ", AFFILIATES_REFERRAL_STATUS_CLOSED => "" . __( ", AFFILIATES_REFERRAL_STATUS_PENDING => "" . __( ", AFFILIATES_REFERRAL_STATUS_REJECTED => "" . __( ", ); $output .= ''; $output .= ''; $output .= ''; foreach ( $column_display_names as $key => $column_display_name ) { $output .= sprintf( '', esc_html( $column_display_name ) ); } $output .= ''; $output .= ''; $output .= ''; if ( count( $results ) > 0 ) { for ( $i = 0; $i < count( $results ); $i++ ) { $result = $results[$i]; $output .= ''; $output .= ''; $title = get_the_title( $result->post_id ); $output .= sprintf( '', esc_html( $title ) ); $output .= sprintf( '', stripslashes( wp_filter_nohtml_kses( $result->name ) ) ); $output .= sprintf( '', stripslashes( wp_filter_nohtml_kses( affiliates_format_referral_amount( $result->amount, 'display' ) ) ) ); $output .= sprintf( '', stripslashes( wp_filter_nohtml_kses( $result->currency_id ) ) ); $output .= ''; $output .= ''; } } else { $output .= sprintf( '', count( $column_display_names ), esc_html__( 'There are no results.', 'affiliates' ) ); } $output .= ''; $output .= '
%s
' . DateHelper::s2u( $result->datetime ) . '%s%s%s%s'; $output .= isset( $status_icons[$result->status] ) ? $status_icons[$result->status] : ''; $output .= isset( $status_descriptions[$result->status] ) ? $status_descriptions[$result->status] : ''; $output .= '
%s
'; return $output; } } } // if