' . esc_html__( 'Manage Affiliates', 'affiliates' ) . '
'; $output .= $notice; $show_filters = $affiliates_options->get_option( 'show_filters', true ); $output .= '';
$output .= "![" . esc_html__(](". AFFILIATES_PLUGIN_URL ."images/add.png)
" . esc_html__( 'New Affiliate', 'affiliates') . "";
$output .= '
'; // .manage
$row_count = isset( $_POST['row_count'] ) ? intval( $_POST['row_count'] ) : 0;
if ( $row_count <= 0 ) {
$row_count = $affiliates_options->get_option( 'affiliates_per_page', AFFILIATES_AFFILIATES_PER_PAGE );
} else {
$affiliates_options->update_option('affiliates_per_page', $row_count );
}
// current page
$paged = isset( $_REQUEST['paged'] ) ? intval( $_REQUEST['paged'] ) : 1;
if ( $paged < 1 ) {
$paged = 1;
}
$orderby = isset( $_GET['orderby'] ) ? $_GET['orderby'] : null;
switch ( $orderby ) {
case 'from_date' :
case 'thru_date' :
case 'email' :
case 'affiliate_id' :
case 'name' :
case 'user_login' :
case 'status' :
break;
default :
$orderby = 'name';
}
$order = isset( $_GET['order'] ) ? $_GET['order'] : null;
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 );
if ( $affiliate_id ) {
$filters[] = " $affiliates_table.affiliate_id = %d ";
$filter_params[] = $affiliate_id;
}
if ( $affiliate_name ) {
$filters[] = " $affiliates_table.name LIKE '%%%s%%' ";
$filter_params[] = $affiliate_name;
}
if ( $affiliate_email ) {
$filters[] = " $affiliates_table.email LIKE '%%%s%%' ";
$filter_params[] = $affiliate_email;
}
if ( $affiliate_user_login ) {
$filters[] = " $wpdb->users.user_login LIKE '%%%s%%' ";
$filter_params[] = $affiliate_user_login;
}
$statuses = array( '' ); // need at least one entry for the IN clause
if ( $show_active ) {
$statuses[] = 'active';
}
if ( $show_pending ) {
$statuses[] = 'pending';
}
if ( $show_deleted ) {
$statuses[] = 'deleted';
}
$filters[] = sprintf( " $affiliates_table.status IN (%s) ", !empty( $statuses ) ? "'" . implode( "','", $statuses ) . "'" : '' );
if ( !$show_inoperative ) {
$filters[] = " $affiliates_table.from_date <= %s AND ( $affiliates_table.thru_date IS NULL OR $affiliates_table.thru_date >= %s ) ";
$filter_params[] = $today;
$filter_params[] = $today;
}
if ( $from_datetime && $thru_datetime ) {
$filters[] = " $affiliates_table.from_date >= %s AND ( $affiliates_table.thru_date IS NULL OR $affiliates_table.thru_date < %s ) ";
$filter_params[] = $from_datetime;
$filter_params[] = $thru_datetime;
} else if ( $from_datetime ) {
$filters[] = " $affiliates_table.from_date >= %s ";
$filter_params[] = $from_datetime;
} else if ( $thru_datetime ) {
$filters[] = " $affiliates_table.thru_date < %s ";
$filter_params[] = $thru_datetime;
}
if ( !empty( $filters ) ) {
$filters = " WHERE " . implode( " AND ", $filters );
} else {
$filters = '';
}
do {
$repeat = false;
$offset = ( $paged - 1 ) * $row_count;
$query = $wpdb->prepare(
"SELECT SQL_CALC_FOUND_ROWS " .
"$affiliates_table.*, " .
"$wpdb->users.* " .
"FROM $affiliates_table " .
"LEFT JOIN $affiliates_users_table ON $affiliates_table.affiliate_id = $affiliates_users_table.affiliate_id " .
"LEFT JOIN $wpdb->users on $affiliates_users_table.user_id = $wpdb->users.ID $filters " .
"ORDER BY $orderby $order " .
"LIMIT $row_count OFFSET $offset",
$filter_params
);
$results = $wpdb->get_results( $query, OBJECT );
$count = intval( $wpdb->get_var( "SELECT FOUND_ROWS()" ) );
if ( $count > $row_count ) {
$paginate = true;
} else {
$paginate = false;
}
$pages = max( array( 1, ceil( $count / $row_count ) ) );
if ( $paged > $pages ) {
$paged = $pages;
$repeat = true;
}
} while ( $repeat );
$column_display_names = array(
'affiliate_id' => __( 'Id', 'affiliates' ),
'name' => __( 'Affiliate', 'affiliates' ),
'email' => __( 'Email', 'affiliates' ),
'user_login' => __( 'Username', 'affiliates' ),
'from_date' => __( 'From', 'affiliates' ),
'thru_date' => __( 'Until', 'affiliates' ),
'status' => __( 'Status', 'affiliates' ),
'edit' => __( 'Edit', 'affiliates' ),
'remove' => __( 'Remove', 'affiliates' ),
'links' => __( 'Links', 'affiliates' ),
);
$output .= '" . esc_html__( 'New Affiliate', 'affiliates') . "";
$output .= '';
$output .= sprintf( ''; // #filters-toggle
$output .= '
'; // floating right
$output .= '';
$output .= sprintf( '
'; // .affiliates-overview
$output .= '', $show_filters ? '' : 'display:none' );
$output .=
'' .
'' .
'
';
$output .= '
';
if ( $paginate ) {
require_once AFFILIATES_CORE_LIB . '/class-affiliates-pagination.php';
$pagination = new Affiliates_Pagination( $count, null, $row_count );
$output .= '';
}
$output .= ''; // #affiliates-action
if ( $paginate ) {
require_once AFFILIATES_CORE_LIB . '/class-affiliates-pagination.php';
$pagination = new Affiliates_Pagination( $count, null, $row_count );
$output .= '';
$output .= $pagination->pagination( 'bottom' );
$output .= '
';
}
$output .= '