/** * Show edit affiliate form. * @param int $affiliate_id affiliate id */ function affiliates_admin_affiliates_edit($affiliate_id) { global $wpdb; if (!current_user_can(AFFILIATES_ADMINISTER_AFFILIATES)) { wp_die(__('Access denied.', AFFILIATES_PLUGIN_DOMAIN)); } $affiliate = affiliates_get_affiliate(intval($affiliate_id)); if (empty($affiliate)) { wp_die(__('No such affiliate.', AFFILIATES_PLUGIN_DOMAIN)); } $affiliates_users_table = _affiliates_get_tablename('affiliates_users'); $affiliate_user = null; $affiliate_user_edit = ''; $affiliate_user_id = $wpdb->get_var($wpdb->prepare("SELECT user_id FROM {$affiliates_users_table} WHERE affiliate_id = %d", intval($affiliate_id))); if ($affiliate_user_id !== null) { $affiliate_user = get_user_by('id', intval($affiliate_user_id)); if ($affiliate_user) { if (current_user_can('edit_user', $affiliate_user->ID)) { $affiliate_user_edit = sprintf(__('Edit %s', AFFILIATES_PLUGIN_DOMAIN), '<a target="_blank" href="' . esc_url("user-edit.php?user_id={$affiliate_user->ID}") . '">' . $affiliate_user->user_login . '</a>'); } } } $current_url = (is_ssl() ? 'https://' : 'http://') . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $current_url = remove_query_arg('action', $current_url); $current_url = remove_query_arg('affiliate_id', $current_url); $name = isset($_POST['name-field']) ? $_POST['name-field'] : $affiliate['name']; $email = isset($_POST['email-field']) ? $_POST['email-field'] : $affiliate['email']; $user_login = isset($_POST['user-field']) ? $_POST['user-field'] : ($affiliate_user != null ? $affiliate_user->user_login : ''); $from_date = isset($_POST['from-date-field']) ? $_POST['from-date-field'] : $affiliate['from_date']; $thru_date = isset($_POST['thru-date-field']) ? $_POST['thru-date-field'] : $affiliate['thru_date']; $output = '<div class="manage-affiliates">' . '<div>' . '<h2>' . __('Edit an affiliate', AFFILIATES_PLUGIN_DOMAIN) . '</h2>' . '</div>' . '<form id="edit-affiliate" action="' . $current_url . '" method="post">' . '<div class="affiliate edit">' . '<input id="affiliate-id-field" name="affiliate-id-field" type="hidden" value="' . esc_attr(intval($affiliate_id)) . '"/>' . '<div class="field">' . '<label for="name-field" class="field-label first required">' . __('Name', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<input id="name-field" name="name-field" class="namefield" type="text" value="' . esc_attr($name) . '"/>' . '</div>' . '<div class="field">' . '<label for="email-field" class="field-label">' . __('Email', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<input id="email-field" name="email-field" class="emailfield" type="text" value="' . esc_attr($email) . '"/>' . '<span class="description">' . __("If a valid <strong>Username</strong> is specified and no email is given, the user's email address will be used automatically.", AFFILIATES_PLUGIN_DOMAIN) . '</span>' . '</div>' . '<div class="field">' . '<label for="user-field" class="field-label">' . __('Username', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<input id="user-field" name="user-field" class="userfield" type="text" value="' . esc_attr($user_login) . '"/>' . $affiliate_user_edit . '</div>' . '<div class="field">' . '<label for="from-date-field" class="field-label first">' . __('From', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<input id="from-date-field" name="from-date-field" class="datefield" type="text" value="' . esc_attr($from_date) . '"/>' . '</div>' . '<div class="field">' . '<label for="thru-date-field" class="field-label">' . __('Until', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<input id="thru-date-field" name="thru-date-field" class="datefield" type="text" value="' . esc_attr($thru_date) . '"/>' . '</div>' . '<div class="field">' . wp_nonce_field('affiliates-edit', AFFILIATES_ADMIN_AFFILIATES_NONCE, true, false) . '<input class="button" type="submit" value="' . __('Save', AFFILIATES_PLUGIN_DOMAIN) . '"/>' . '<input type="hidden" value="edit" name="action"/>' . '<a class="cancel" href="' . $current_url . '">' . __('Cancel', AFFILIATES_PLUGIN_DOMAIN) . '</a>' . '</div>' . '</div>' . '</form>' . '</div>'; // .manage-affiliates echo $output; affiliates_footer(); }
/** * Show form to remove an affiliate. * @param int $affiliate_id affiliate id */ function affiliates_admin_affiliates_remove($affiliate_id) { global $wpdb; if (!current_user_can(AFFILIATES_ADMINISTER_AFFILIATES)) { wp_die(__('Access denied.', AFFILIATES_PLUGIN_DOMAIN)); } $affiliate = affiliates_get_affiliate(intval($affiliate_id)); if (empty($affiliate)) { wp_die(__('No such affiliate.', AFFILIATES_PLUGIN_DOMAIN)); } $affiliates_users_table = _affiliates_get_tablename('affiliates_users'); $affiliate_user = null; $affiliate_user_edit = ''; $affiliate_user_id = $wpdb->get_var($wpdb->prepare("SELECT user_id FROM {$affiliates_users_table} WHERE affiliate_id = %d", intval($affiliate_id))); if ($affiliate_user_id !== null) { $affiliate_user = get_user_by('id', intval($affiliate_user_id)); if ($affiliate_user) { if (current_user_can('edit_user', $affiliate_user->ID)) { $affiliate_user_edit = sprintf(__('Edit %s', AFFILIATES_PLUGIN_DOMAIN), '<a target="_blank" href="' . esc_url("user-edit.php?user_id={$affiliate_user->ID}") . '">' . $affiliate_user->user_login . '</a>'); } else { $affiliate_user_edit = $affiliate_user->user_login; } } } $current_url = (is_ssl() ? 'https://' : 'http://') . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $current_url = remove_query_arg('action', $current_url); $current_url = remove_query_arg('affiliate_id', $current_url); $output = '<div class="manage-affiliates">' . '<div>' . '<h2>' . __('Remove an affiliate', AFFILIATES_PLUGIN_DOMAIN) . '</h2>' . '</div>' . '<form id="remove-affiliate" action="' . $current_url . '" method="post">' . '<div class="affiliate remove">' . '<input id="affiliate-id-field" name="affiliate-id-field" type="hidden" value="' . esc_attr(intval($affiliate_id)) . '"/>' . '<ul>' . '<li>' . sprintf(__('Name : %s', AFFILIATES_PLUGIN_DOMAIN), wp_filter_kses($affiliate['name'])) . '</li>' . '<li>' . sprintf(__('Email : %s', AFFILIATES_PLUGIN_DOMAIN), wp_filter_kses($affiliate['email'])) . '</li>' . '<li>' . sprintf(__('Username : %s', AFFILIATES_PLUGIN_DOMAIN), wp_filter_kses($affiliate_user_edit)) . '</li>' . '<li>' . sprintf(__('From : %s', AFFILIATES_PLUGIN_DOMAIN), wp_filter_kses($affiliate['from_date'])) . '</li>' . '<li>' . sprintf(__('Until : %s', AFFILIATES_PLUGIN_DOMAIN), wp_filter_kses($affiliate['from_date'])) . '</li>' . '</ul> ' . wp_nonce_field('affiliates-remove', AFFILIATES_ADMIN_AFFILIATES_NONCE, true, false) . '<input class="button" type="submit" value="' . __('Remove', AFFILIATES_PLUGIN_DOMAIN) . '"/>' . '<input type="hidden" value="remove" name="action"/>' . '<a class="cancel" href="' . $current_url . '">' . __('Cancel', AFFILIATES_PLUGIN_DOMAIN) . '</a>' . '</div>' . '</div>' . '</form>' . '</div>'; // .manage-affiliates echo $output; affiliates_footer(); }
/** * Performs coupon checks after checkout validation. * * @param array $posted posted form data */ public static function woocommerce_after_checkout_validation($posted) { global $woocommerce; if (isset($woocommerce->cart)) { $cart = $woocommerce->cart; if (!empty($cart->applied_coupons)) { if (method_exists('Affiliates_Attributes_WordPress', 'get_affiliate_for_coupon')) { $valid = true; $emails = array($posted['billing_email']); if (is_user_logged_in()) { $current_user = wp_get_current_user(); $emails[] = $current_user->user_email; } $emails = array_map('sanitize_email', array_map('strtolower', $emails)); self::remove_filters(); foreach ($cart->applied_coupons as $key => $code) { $coupon = new WC_Coupon($code); if (!is_wp_error($coupon->is_valid())) { if ($affiliate_id = Affiliates_Attributes_WordPress::get_affiliate_for_coupon($coupon->code)) { if ($user_id = get_current_user_id()) { if ($affiliate_ids = affiliates_get_user_affiliate($user_id)) { if (in_array($affiliate_id, $affiliate_ids)) { $valid = false; break; } } } if ($affiliate = affiliates_get_affiliate($affiliate_id)) { if (isset($affiliate['email']) && in_array(strtolower($affiliate['email']), $emails)) { $valid = false; break; } } } } } self::add_filters(); if (!$valid) { $coupon->add_coupon_message(WC_Coupon::E_WC_COUPON_INVALID_REMOVED); unset($cart->applied_coupons[$key]); $woocommerce->session->coupon_codes = $cart->applied_coupons; $woocommerce->session->refresh_totals = true; } } } } }
function affiliates_admin_hits_affiliate() { global $wpdb, $affiliates_options; $output = ''; if (!current_user_can(AFFILIATES_ACCESS_AFFILIATES)) { wp_die(__('Access denied.', AFFILIATES_PLUGIN_DOMAIN)); } if (isset($_POST['from_date']) || isset($_POST['thru_date']) || isset($_POST['clear_filters']) || isset($_POST['affiliate_id']) || isset($_POST['expanded']) || isset($_POST['expanded_hits']) || isset($_POST['expanded_referrals']) || isset($_POST['show_inoperative'])) { if (!wp_verify_nonce($_POST[AFFILIATES_ADMIN_HITS_AFF_FILTER_NONCE], 'admin')) { wp_die(__('Access denied.', AFFILIATES_PLUGIN_DOMAIN)); } } // filters $from_date = $affiliates_options->get_option('hits_affiliate_from_date', null); $thru_date = $affiliates_options->get_option('hits_affiliate_thru_date', null); $affiliate_id = $affiliates_options->get_option('hits_affiliate_affiliate_id', null); $expanded = $affiliates_options->get_option('hits_affiliate_expanded', null); // @todo input ist not shown, eventually remove unless ... $expanded_referrals = $affiliates_options->get_option('hits_affiliate_expanded_referrals', null); $expanded_hits = $affiliates_options->get_option('hits_affiliate_expanded_hits', null); $show_inoperative = $affiliates_options->get_option('hits_affiliate_show_inoperative', null); if (isset($_POST['clear_filters'])) { $affiliates_options->delete_option('hits_affiliate_from_date'); $affiliates_options->delete_option('hits_affiliate_thru_date'); $affiliates_options->delete_option('hits_affiliate_affiliate_id'); $affiliates_options->delete_option('hits_affiliate_expanded'); $affiliates_options->delete_option('hits_affiliate_expanded_referrals'); $affiliates_options->delete_option('hits_affiliate_expanded_hits'); $affiliates_options->delete_option('hits_affiliate_show_inoperative'); $from_date = null; $thru_date = null; $affiliate_id = null; $expanded = null; $expanded_hits = null; $expanded_referrals = null; $show_inoperative = null; } else { if (isset($_POST['submitted'])) { // filter by date(s) if (!empty($_POST['from_date'])) { $from_date = date('Y-m-d', strtotime($_POST['from_date'])); $affiliates_options->update_option('hits_affiliate_from_date', $from_date); } else { $from_date = null; $affiliates_options->delete_option('hits_affiliate_from_date'); } if (!empty($_POST['thru_date'])) { $thru_date = date('Y-m-d', strtotime($_POST['thru_date'])); $affiliates_options->update_option('hits_affiliate_thru_date', $thru_date); } else { $thru_date = null; $affiliates_options->delete_option('hits_affiliate_thru_date'); } if ($from_date && $thru_date) { if (strtotime($from_date) > strtotime($thru_date)) { $thru_date = null; $affiliates_options->delete_option('hits_affiliate_thru_date'); } } // filter by affiliate id if (!empty($_POST['affiliate_id'])) { $affiliate_id = affiliates_check_affiliate_id($_POST['affiliate_id']); if ($affiliate_id) { $affiliates_options->update_option('hits_affiliate_affiliate_id', $affiliate_id); } } else { if (isset($_POST['affiliate_id'])) { // empty && isset => '' => all $affiliate_id = null; $affiliates_options->delete_option('hits_affiliate_affiliate_id'); } } // expanded details? if (!empty($_POST['expanded'])) { $expanded = true; $affiliates_options->update_option('hits_affiliate_expanded', true); } else { $expanded = false; $affiliates_options->delete_option('hits_affiliate_expanded'); } if (!empty($_POST['expanded_hits'])) { $expanded_hits = true; $affiliates_options->update_option('hits_affiliate_expanded_hits', true); } else { $expanded_hits = false; $affiliates_options->delete_option('hits_affiliate_expanded_hits'); } if (!empty($_POST['expanded_referrals'])) { $expanded_referrals = true; $affiliates_options->update_option('hits_affiliate_expanded_referrals', true); } else { $expanded_referrals = false; $affiliates_options->delete_option('hits_affiliate_expanded_referrals'); } if (!empty($_POST['show_inoperative'])) { $show_inoperative = true; $affiliates_options->update_option('hits_affiliate_show_inoperative', true); } else { $show_inoperative = false; $affiliates_options->delete_option('hits_affiliate_show_inoperative'); } } } if (isset($_POST['row_count'])) { if (!wp_verify_nonce($_POST[AFFILIATES_ADMIN_HITS_AFF_NONCE_1], 'admin')) { wp_die(__('Access denied.', AFFILIATES_PLUGIN_DOMAIN)); } } if (isset($_POST['paged'])) { if (!wp_verify_nonce($_POST[AFFILIATES_ADMIN_HITS_AFF_NONCE_2], 'admin')) { wp_die(__('Access denied.', AFFILIATES_PLUGIN_DOMAIN)); } } $current_url = (is_ssl() ? 'https://' : 'http://') . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $current_url = remove_query_arg('paged', $current_url); $affiliates_table = _affiliates_get_tablename('affiliates'); $referrals_table = _affiliates_get_tablename('referrals'); $hits_table = _affiliates_get_tablename('hits'); $output .= '<div>' . '<h2>' . __('Affiliates & Referrals', AFFILIATES_PLUGIN_DOMAIN) . '</h2>' . '</div>'; $row_count = isset($_POST['row_count']) ? intval($_POST['row_count']) : 0; if ($row_count <= 0) { $row_count = $affiliates_options->get_option('hits_affiliate_per_page', AFFILIATES_HITS_AFFILIATE_PER_PAGE); } else { $affiliates_options->update_option('hits_affiliate_per_page', $row_count); } $offset = isset($_GET['offset']) ? intval($_GET['offset']) : 0; if ($offset < 0) { $offset = 0; } $paged = isset($_GET['paged']) ? intval($_GET['paged']) : 0; if ($paged < 0) { $paged = 0; } $orderby = isset($_GET['orderby']) ? $_GET['orderby'] : null; switch ($orderby) { case 'date': case 'visits': case 'hits': case 'referrals': case 'ratio': case 'name': 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'; } if ($from_date || $thru_date || $affiliate_id) { $filters = " WHERE "; } else { $filters = ''; } $filter_params = array(); // We now 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_date && $thru_date) { $filters .= " datetime >= %s AND datetime < %s "; $filter_params[] = $from_datetime; $filter_params[] = $thru_datetime; } else { if ($from_date) { $filters .= " datetime >= %s "; $filter_params[] = $from_datetime; } else { if ($thru_date) { $filters .= " datetime < %s "; $filter_params[] = $thru_datetime; } } } if ($affiliate_id) { if ($from_date || $thru_date) { $filters .= " AND "; } $filters .= " h.affiliate_id = %d "; $filter_params[] = $affiliate_id; } // how many are there ? $count_query = $wpdb->prepare("SELECT affiliate_id FROM {$hits_table} h\n\t\t{$filters}\n\t\tGROUP BY affiliate_id\n\t\t", $filter_params); $wpdb->query($count_query); $count = $wpdb->num_rows; 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; } // Get the summarized results, these are grouped by date. // Note: Referrals on dates without a hit will not be included. // @see notes about this in affiliates_admin_hits() $date_condition = ""; if ($from_date && $thru_date) { $date_condition = " AND datetime >= '" . $from_datetime . "' AND datetime < '" . $thru_datetime . "' "; } else { if ($from_date) { $date_condition = " AND datetime >= '" . $from_datetime . "' "; } else { if ($thru_date) { $date_condition = " AND datetime < '" . $thru_datetime . "' "; } } } $query = $wpdb->prepare("\n\t\t\tSELECT\n\t\t\t\t*,\n\t\t\t\tcount(distinct ip) visits,\n\t\t\t\tsum(count) hits,\n\t\t\t\t(select count(*) from {$referrals_table} where affiliate_id = h.affiliate_id {$date_condition} ) referrals,\n\t\t\t\t((select count(*) from {$referrals_table} where affiliate_id = h.affiliate_id {$date_condition} )/count(distinct ip)) ratio\n\t\t\tFROM {$hits_table} h\n\t\t\tLEFT JOIN {$affiliates_table} a ON h.affiliate_id = a.affiliate_id\n\t\t\t{$filters}\n\t\t\tGROUP BY h.affiliate_id\n\t\t\tORDER BY {$orderby} {$order}\n\t\t\tLIMIT {$row_count} OFFSET {$offset}\n\t\t\t", $filter_params); $results = $wpdb->get_results($query, OBJECT); $column_display_names = array('name' => __('Affiliate', AFFILIATES_PLUGIN_DOMAIN), 'visits' => __('Visitors', AFFILIATES_PLUGIN_DOMAIN), 'hits' => __('Hits', AFFILIATES_PLUGIN_DOMAIN), 'referrals' => __('Referrals', AFFILIATES_PLUGIN_DOMAIN), 'ratio' => __('Ratio', AFFILIATES_PLUGIN_DOMAIN)); $output .= '<div id="" class="hits-affiliates-overview">'; $affiliates = affiliates_get_affiliates(true, !$show_inoperative); $affiliates_select = ''; if (!empty($affiliates)) { $affiliates_select .= '<label class="affiliate-id-filter" for="affiliate_id">' . __('Affiliate', AFFILIATES_PLUGIN_DOMAIN) . '</label>'; $affiliates_select .= '<select class="affiliate-id-filter" name="affiliate_id">'; $affiliates_select .= '<option value="">--</option>'; foreach ($affiliates as $affiliate) { if ($affiliate_id == $affiliate['affiliate_id']) { $selected = ' selected="selected" '; } else { $selected = ''; } $affiliates_select .= '<option ' . $selected . ' value="' . esc_attr($affiliate['affiliate_id']) . '">' . esc_attr(stripslashes($affiliate['name'])) . '</option>'; } $affiliates_select .= '</select>'; } $output .= '<div class="filters">' . '<label class="description" for="setfilters">' . __('Filters', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<form id="setfilters" action="" method="post">' . '<p>' . $affiliates_select . '</p> <p>' . '<label class="from-date-filter" for="from_date">' . __('From', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<input class="datefield from-date-filter" name="from_date" type="text" value="' . esc_attr($from_date) . '"/>' . '<label class="thru-date-filter" for="thru_date">' . __('Until', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<input class="datefield thru-date-filter" name="thru_date" type="text" class="datefield" value="' . esc_attr($thru_date) . '"/>' . '</p> <p>' . wp_nonce_field('admin', AFFILIATES_ADMIN_HITS_AFF_FILTER_NONCE, true, false) . '<input class="button" type="submit" value="' . __('Apply', AFFILIATES_PLUGIN_DOMAIN) . '"/>' . '<label class="expanded-filter">' . '<input class="expanded-filter" name="expanded_referrals" type="checkbox" ' . ($expanded_referrals ? 'checked="checked"' : '') . '/>' . ' ' . __('Expand referrals', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<label class="expanded-filter">' . '<input class="expanded-filter" name="expanded_hits" type="checkbox" ' . ($expanded_hits ? 'checked="checked"' : '') . '/>' . ' ' . __('Expand hits', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<label class="show-inoperative-filter">' . '<input class="show-inoperative-filter" name="show_inoperative" type="checkbox" ' . ($show_inoperative ? 'checked="checked"' : '') . '/>' . ' ' . __('Include inoperative affiliates', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<input class="button" type="submit" name="clear_filters" value="' . __('Clear', AFFILIATES_PLUGIN_DOMAIN) . '"/>' . '<input type="hidden" value="submitted" name="submitted"/>' . '</p>' . '</form>' . '</div>'; $output .= ' <div class="page-options"> <form id="setrowcount" action="" method="post"> <div> <label for="row_count">' . __('Results per page', AFFILIATES_PLUGIN_DOMAIN) . '</label>' . '<input name="row_count" type="text" size="2" value="' . esc_attr($row_count) . '" /> ' . wp_nonce_field('admin', AFFILIATES_ADMIN_HITS_AFF_NONCE_1, true, false) . ' <input class="button" type="submit" value="' . __('Apply', AFFILIATES_PLUGIN_DOMAIN) . '"/> </div> </form> </div> '; if ($paginate) { require_once AFFILIATES_CORE_LIB . '/class-affiliates-pagination.php'; $pagination = new Affiliates_Pagination($count, null, $row_count); $output .= '<form id="posts-filter" method="post" action="">'; $output .= '<div>'; $output .= wp_nonce_field('admin', AFFILIATES_ADMIN_HITS_AFF_NONCE_2, true, false); $output .= '</div>'; $output .= '<div class="tablenav top">'; $output .= $pagination->pagination('top'); $output .= '</div>'; $output .= '</form>'; } $output .= ' <table id="" class="wp-list-table widefat fixed" cellspacing="0"> <thead> <tr> '; foreach ($column_display_names as $key => $column_display_name) { $options = array('orderby' => $key, 'order' => $switch_order); $class = ""; if (strcmp($key, $orderby) == 0) { $lorder = strtolower($order); $class = "{$key} manage-column sorted {$lorder}"; } else { $class = "{$key} manage-column sortable"; } $column_display_name = '<a href="' . esc_url(add_query_arg($options, $current_url)) . '"><span>' . $column_display_name . '</span><span class="sorting-indicator"></span></a>'; $output .= "<th scope='col' class='{$class}'>{$column_display_name}</th>"; } $output .= '</tr> </thead> <tbody> '; if (count($results) > 0) { for ($i = 0; $i < count($results); $i++) { $result = $results[$i]; $output .= '<tr class=" ' . ($i % 2 == 0 ? 'even' : 'odd') . '">'; $affiliate = affiliates_get_affiliate($result->affiliate_id); $output .= "<td class='affiliate-name'>" . stripslashes(wp_filter_nohtml_kses($affiliate['name'])) . "</td>"; $output .= "<td class='visits'>{$result->visits}</td>"; $output .= "<td class='hits'>{$result->hits}</td>"; $output .= "<td class='referrals'>{$result->referrals}</td>"; $output .= "<td class='ratio'>{$result->ratio}</td>"; $output .= '</tr>'; if ($expanded || $expanded_referrals || $expanded_hits) { // // expanded : referrals ---------------------------------------- // if ($expanded_referrals) { // get the detailed results for referrals $referrals_filters = " WHERE r.affiliate_id = %d "; $referrals_filter_params = array($result->affiliate_id); if ($from_date && $thru_date) { $referrals_filters .= " AND datetime >= %s AND datetime < %s "; $referrals_filter_params[] = $from_datetime; $referrals_filter_params[] = $thru_datetime; } else { if ($from_date) { $referrals_filters .= " AND datetime >= %s "; $referrals_filter_params[] = $from_datetime; } else { if ($thru_date) { $referrals_filters .= " datetime < %s "; $referrals_filter_params[] = $thru_datetime; } } } $referrals_orderby = "datetime {$order}"; $referrals_query = $wpdb->prepare("SELECT *\n\t\t\t\t\t\tFROM {$referrals_table} r\n\t\t\t\t\t\tLEFT JOIN {$affiliates_table} a ON r.affiliate_id = a.affiliate_id\n\t\t\t\t\t\t{$referrals_filters}\n\t\t\t\t\t\tORDER BY {$referrals_orderby}\n\t\t\t\t\t\t", $referrals_filter_params); $referrals = $wpdb->get_results($referrals_query, OBJECT); if (count($referrals) > 0) { $output .= '<tr class=" ' . ($i % 2 == 0 ? 'even' : 'odd') . '">'; $output .= '<td colspan="5">'; $output .= '<div class="details-referrals">'; $output .= '<p class="description">' . __('Referrals', AFFILIATES_PLUGIN_DOMAIN) . '</p>'; $output .= ' <table id="details-referrals-' . esc_attr($result->date) . '" class="details-referrals" cellspacing="0"> <thead> <tr> <th scope="col" class="datetime">' . __('Time', AFFILIATES_PLUGIN_DOMAIN) . '</th> <th scope="col" class="post-id">' . __('Post', AFFILIATES_PLUGIN_DOMAIN) . '</th> <th scope="col" class="affiliate-id">' . __('Affiliate', AFFILIATES_PLUGIN_DOMAIN) . '</th> </tr> </thead> <tbody> '; foreach ($referrals as $referral) { $output .= '<tr class="details-referrals ' . ($i % 2 == 0 ? 'even' : 'odd') . '">'; $output .= "<td class='datetime'>" . DateHelper::s2u($referral->datetime) . "</td>"; $link = get_permalink($referral->post_id); $title = get_the_title($referral->post_id); $output .= '<td class="post-id"><a href="' . esc_attr($link) . '" target="_blank">' . stripslashes(wp_filter_nohtml_kses($title)) . '</a></td>'; $output .= "<td class='affiliate-id'>" . stripslashes(wp_filter_nohtml_kses($referral->name)) . "</td>"; $output .= '</tr>'; } $output .= '</tbody></table>'; $output .= '</div>'; // .details-referrals $output .= '</td></tr>'; } } // if $expanded_referrals // // expanded : hits ---------------------------------------- // if ($expanded_hits) { // get the detailed results for hits $details_orderby = "date {$order}, time {$order}"; $details_filters = " WHERE h.affiliate_id = %d "; $details_filter_params = array($result->affiliate_id); if ($from_date && $thru_date) { $details_filters .= " AND datetime >= %s AND datetime < %s "; $details_filter_params[] = $from_datetime; $details_filter_params[] = $thru_datetime; } else { if ($from_date) { $details_filters .= " AND datetime >= %s "; $details_filter_params[] = $from_datetime; } else { if ($thru_date) { $details_filters .= " datetime < %s "; $details_filter_params[] = $thru_datetime; } } } $details_query = $wpdb->prepare("SELECT *\n\t\t\t\t\t\tFROM {$hits_table} h\n\t\t\t\t\t\tLEFT JOIN {$affiliates_table} a ON h.affiliate_id = a.affiliate_id\n\t\t\t\t\t\t{$details_filters}\n\t\t\t\t\t\tORDER BY {$details_orderby}\n\t\t\t\t\t\t", $details_filter_params); $hits = $wpdb->get_results($details_query, OBJECT); $output .= '<tr class=" ' . ($i % 2 == 0 ? 'even' : 'odd') . '">'; $output .= '<td colspan="5">'; $output .= '<div class="details-hits">'; $output .= '<p class="description">' . __('Hits', AFFILIATES_PLUGIN_DOMAIN) . '</p>'; $output .= ' <table id="details-hits-' . esc_attr($result->date) . '" class="details-hits" cellspacing="0"> <thead> <tr> <th scope="col" class="date">' . __('Date', AFFILIATES_PLUGIN_DOMAIN) . '</th> <th scope="col" class="time">' . __('Time', AFFILIATES_PLUGIN_DOMAIN) . '</th> <th scope="col" class="ip">' . __('IP', AFFILIATES_PLUGIN_DOMAIN) . '</th> <th scope="col" class="count">' . __('Count', AFFILIATES_PLUGIN_DOMAIN) . '</th> <th scope="col" class="affiliate-id">' . __('Affiliate', AFFILIATES_PLUGIN_DOMAIN) . '</th> </tr> </thead> <tbody> '; foreach ($hits as $hit) { $output .= '<tr class="details ' . ($i % 2 == 0 ? 'even' : 'odd') . '">'; // $output .= "<td class='date'>$hit->date</td>"; $output .= '<td class="date">' . DateHelper::formatDate(DateHelper::s2u($hit->datetime)) . '</td>'; // $output .= "<td class='time'>$hit->time</td>"; $output .= '<td class="time">' . DateHelper::formatTime(DateHelper::s2u($hit->datetime)) . '</td>'; $output .= "<td class='ip'>" . long2ip($hit->ip) . "</td>"; $output .= "<td class='count'>{$hit->count}</td>"; $output .= "<td class='affiliate-id'>" . stripslashes(wp_filter_nohtml_kses($hit->name)) . "</td>"; $output .= '</tr>'; } $output .= '</tbody></table>'; $output .= '</div>'; // .details-hits $output .= '</td></tr>'; } // if $expanded_hits } // expanded } } else { $output .= '<tr><td colspan="5">' . __('There are no results.', AFFILIATES_PLUGIN_DOMAIN) . '</td></tr>'; } $output .= '</tbody>'; $output .= '</table>'; if ($paginate) { require_once AFFILIATES_CORE_LIB . '/class-affiliates-pagination.php'; $pagination = new Affiliates_Pagination($count, null, $row_count); $output .= '<div class="tablenav bottom">'; $output .= $pagination->pagination('bottom'); $output .= '</div>'; } $output .= '</div>'; // .visits-overview echo $output; affiliates_footer(); }
/** * Delete a referral. */ function affiliates_admin_referral_remove($referral_id = null) { global $wpdb; $output = ''; if (!current_user_can(AFFILIATES_ADMINISTER_AFFILIATES)) { wp_die(__('Access denied.', AFFILIATES_PLUGIN_DOMAIN)); } $current_url = (is_ssl() ? 'https://' : 'http://') . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $cancel_url = remove_query_arg('referral_id', remove_query_arg('action', $current_url)); $current_url = remove_query_arg('paged', $current_url); $output .= '<div class="referral remove">'; $output .= '<h2>'; $output .= __('Remove a Referral', AFFILIATES_PLUGIN_DOMAIN); $output .= '</h2>'; if (isset($_POST['submit'])) { if (!wp_verify_nonce($_POST['referral-nonce'], 'remove')) { wp_die(__('Access denied.', AFFILIATES_PLUGIN_DOMAIN)); } else { if (!empty($_POST['referral_id'])) { // remove the referral $referrals_table = _affiliates_get_tablename('referrals'); if ($wpdb->query($wpdb->prepare("DELETE FROM {$referrals_table} WHERE referral_id = %d", intval($_POST['referral_id'])))) { $output .= '<br/>'; $output .= '<div class="info">'; $output .= __('The referral has been removed.', AFFILIATES_PLUGIN_DOMAIN); $output .= ' '; $output .= sprintf('<a href="%s">%s</a>', $cancel_url, __('Return', AFFILIATES_PLUGIN_DOMAIN)); $output .= '</div>'; $output .= '<br/>'; } else { $output .= '<div class="error">' . __('I do not know how to delete what does not exist.', AFFILIATES_PLUGIN_DOMAIN) . '</div>'; } } } } else { if ($referral_id !== null) { $referrals_table = _affiliates_get_tablename('referrals'); if ($referrals = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$referrals_table} WHERE referral_id = %d", $referral_id))) { if (count($referrals) > 0) { $referral = $referrals[0]; $affiliate_id = $referral->affiliate_id; $datetime = $referral->datetime; $description = wp_strip_all_tags($referral->description); $amount = $referral->amount; $currency_id = $referral->currency_id; $status = $referral->status; $reference = wp_strip_all_tags($referral->reference); $output .= '<form id="referral" action="' . $current_url . '" method="post">'; $output .= '<div>'; $output .= sprintf('<input type="hidden" name="referral_id" value="%d" />', intval($referral_id)); $output .= '<input type="hidden" name="action" value="edit" />'; $output .= '<p>'; $output .= '<span class="title">' . __('Affiliate', AFFILIATES_PLUGIN_DOMAIN) . '</span>'; $output .= ' '; $affiliate = affiliates_get_affiliate($affiliate_id); $output .= stripslashes($affiliate['name']); $output .= '</p>'; $output .= '<p>'; $output .= '<span class="title">' . __('Date & Time', AFFILIATES_PLUGIN_DOMAIN) . '</span>'; $output .= ' '; $output .= $datetime; $output .= '</p>'; $output .= '<p>'; $output .= '<span class="title">' . __('Description', AFFILIATES_PLUGIN_DOMAIN) . '</span>'; $output .= ' '; $output .= $description; $output .= '</p>'; $output .= '<p>'; $output .= '<span class="title">' . __('Amount', AFFILIATES_PLUGIN_DOMAIN) . '</span>'; $output .= ' '; $output .= $amount; $output .= '</p>'; $output .= '<p>'; $output .= '<span class="title">' . __('Currency ID', AFFILIATES_PLUGIN_DOMAIN) . '</span>'; $output .= ' '; $output .= $currency_id; $output .= '</p>'; $status_descriptions = array(AFFILIATES_REFERRAL_STATUS_ACCEPTED => __('Accepted', AFFILIATES_PLUGIN_DOMAIN), AFFILIATES_REFERRAL_STATUS_CLOSED => __('Closed', AFFILIATES_PLUGIN_DOMAIN), AFFILIATES_REFERRAL_STATUS_PENDING => __('Pending', AFFILIATES_PLUGIN_DOMAIN), AFFILIATES_REFERRAL_STATUS_REJECTED => __('Rejected', AFFILIATES_PLUGIN_DOMAIN)); $output .= '<p>'; $output .= '<span class="title">' . __('Status', AFFILIATES_PLUGIN_DOMAIN) . '</span>'; $output .= ' '; $output .= $status_descriptions[$status]; $output .= '</p>'; $output .= '<p>'; $output .= '<span class="title">' . __('Reference', AFFILIATES_PLUGIN_DOMAIN) . '</span>'; $output .= ' '; $output .= $reference; $output .= '</p>'; $output .= wp_nonce_field('remove', 'referral-nonce', true, false); $output .= '<p class="description">'; $output .= __('Remove this referral? This action can not be undone.', AFFILIATES_PLUGIN_DOMAIN); $output .= '</p>'; $output .= sprintf('<input class="button" type="submit" name="submit" value="%s"/>', __('Remove', AFFILIATES_PLUGIN_DOMAIN)); $output .= ' '; $output .= sprintf('<a class="cancel" href="%s">%s</a>', $cancel_url, __('Cancel', AFFILIATES_PLUGIN_DOMAIN)); $output .= '</div>'; $output .= '</form>'; } else { $output .= '<div class="error">' . __('This referral does not exist.', AFFILIATES_PLUGIN_DOMAIN) . '</div>'; } } else { $output .= '<div class="error">' . __('This referral does not exist.', AFFILIATES_PLUGIN_DOMAIN) . '</div>'; } } else { $output .= '<div class="error">' . __('Pretty pointless ...', AFFILIATES_PLUGIN_DOMAIN) . '</div>'; } } $output .= '</div>'; echo $output; affiliates_footer(); }
/** * Renders the contact form. * Remember NOT to use any form input elements named 'name', 'year', ... * @static */ static function render_form($widget_id = '', $amount = null, $currency_id = null) { $method = 'post'; $action = ""; if (!empty($widget_id)) { $ext = '-' . $widget_id; } else { $ext = ''; } $submit_name = 'affiliates-contact-submit'; $nonce = 'affiliates-contact-nonce'; $nonce_action = 'affiliates-contact'; $send = false; $sender_class = ''; $email_class = ''; $message_class = ''; $captcha = ''; $error = false; if (!empty($_POST[$submit_name])) { if (!wp_verify_nonce($_POST[$nonce], $nonce_action)) { $error = true; // fail but don't give clues } $captcha = $_POST[Affiliates_Contact::$captcha_field_id]; if (!Affiliates_Contact::captcha_validates($captcha)) { $error = true; // dumbot } $sender = Affiliates_Contact::filter($_POST['sender']); $email = Affiliates_Contact::filter($_POST['email']); $message = Affiliates_Contact::filter($_POST['message']); if (empty($sender)) { $sender_class .= ' class="missing" '; $error = true; } if (empty($email) || !is_email($email)) { $email_class .= ' class="missing" '; $error = true; } if (empty($message)) { $message_class .= ' class="missing" '; $error = true; } if (!$error) { $send = true; $description = __('Affiliates contact form submission', AFFILIATES_PLUGIN_DOMAIN); $data = array('name' => array('title' => 'Name', 'domain' => AFFILIATES_PLUGIN_DOMAIN, 'value' => $sender), 'email' => array('title' => 'Email', 'domain' => AFFILIATES_PLUGIN_DOMAIN, 'value' => $email), 'message' => array('title' => 'Message', 'domain' => AFFILIATES_PLUGIN_DOMAIN, 'value' => $message)); // request a referral $affiliate = null; if (function_exists('affiliates_suggest_referral')) { $post_id = get_the_ID(); $affiliate_id = affiliates_suggest_referral($post_id, $description, $data, $amount, $currency_id, null, null, 'ACF' . md5(time())); if ($affiliate_id) { $affiliate = affiliates_get_affiliate($affiliate_id); // Now you could send an email to the affiliate ... } } } } else { $sender = ''; $email = ''; $message = ''; } if (!$send) { echo '<div class="affiliates-contact" id="affiliates-contact' . $ext . '">'; echo '<img id="affiliates-contact-throbber' . $ext . '" src="' . AFFILIATES_PLUGIN_URL . 'images/affiliates-throbber.gif" style="display:none" />'; echo '<form id="affiliates-contact-form' . $ext . '" action="' . $action . '" method="' . $method . '">'; echo '<div>'; echo '<label ' . $sender_class . ' id="affiliates-contact-form' . $ext . '-sender-label" for="sender">' . __('Name', AFFILIATES_PLUGIN_DOMAIN) . '</label>'; echo '<input id="affiliates-contact-form' . $ext . '-sender" name="sender" type="text" value="' . esc_attr($sender) . '"/>'; echo '<label ' . $email_class . ' id="affiliates-contact-form' . $ext . '-email-label" for="email">' . __('Email', AFFILIATES_PLUGIN_DOMAIN) . '</label>'; echo '<input id="affiliates-contact-form' . $ext . '-email" name="email" type="text" value="' . esc_attr($email) . '"/>'; echo '<label ' . $message_class . 'id="affiliates-contact-form' . $ext . '-message-label" for="message">' . __('Message', AFFILIATES_PLUGIN_DOMAIN) . '</label>'; echo '<textarea id="affiliates-contact-form' . $ext . '-message" name="message">' . $message . '</textarea>'; echo Affiliates_Contact::captcha_get($captcha); echo wp_nonce_field($nonce_action, $nonce, true, false); echo '<input type="submit" name="' . $submit_name . '" value="' . __('Send', AFFILIATES_PLUGIN_DOMAIN) . '" />'; echo '</div>'; echo '</form>'; echo '</div>'; } else { echo '<p>' . __('Thanks!', AFFILIATES_PLUGIN_DOMAIN) . '</p>'; } }
/** * Show edit affiliate form. * @param int $affiliate_id affiliate id */ function affiliates_admin_affiliates_edit($affiliate_id) { global $wpdb; if (!current_user_can(AFFILIATES_ADMINISTER_AFFILIATES)) { wp_die(__('Access denied.', AFFILIATES_PLUGIN_DOMAIN)); } $affiliate = affiliates_get_affiliate(intval($affiliate_id)); if (empty($affiliate)) { wp_die(__('No such affiliate.', AFFILIATES_PLUGIN_DOMAIN)); } $affiliates_users_table = _affiliates_get_tablename('affiliates_users'); $affiliate_user = null; $affiliate_user_edit = ''; $affiliate_user_fields = ''; $affiliate_user_id = $wpdb->get_var($wpdb->prepare("SELECT user_id FROM {$affiliates_users_table} WHERE affiliate_id = %d", intval($affiliate_id))); if ($affiliate_user_id !== null) { $affiliate_user = get_user_by('id', intval($affiliate_user_id)); if ($affiliate_user) { // user edit link if (current_user_can('edit_user', $affiliate_user->ID)) { $affiliate_user_edit = sprintf(__('Edit %s', AFFILIATES_PLUGIN_DOMAIN), '<a target="_blank" href="' . esc_url("user-edit.php?user_id={$affiliate_user->ID}") . '">' . $affiliate_user->user_login . '</a>'); } // user meta fields require_once AFFILIATES_CORE_LIB . '/class-affiliates-settings.php'; require_once AFFILIATES_CORE_LIB . '/class-affiliates-settings-registration.php'; $registration_fields = Affiliates_Settings_Registration::get_fields(); // remove fields not stored as user meta foreach (Affiliates_Registration::get_skip_meta_fields() as $key) { unset($registration_fields[$key]); } // render user meta foreach ($registration_fields as $name => $field) { if ($field['enabled']) { $affiliate_user_fields .= '<div class="field">'; $affiliate_user_fields .= '<label>'; $affiliate_user_fields .= esc_html(stripslashes($field['label'])); // @todo i18n $affiliate_user_fields .= ' '; $type = isset($field['type']) ? $field['type'] : 'text'; $value = get_user_meta($affiliate_user->ID, $name, true); $affiliate_user_fields .= sprintf('<input type="text" value="%s" readonly="readonly" />', esc_attr(stripslashes($value))); $affiliate_user_fields .= '</label>'; $affiliate_user_fields .= '</div>'; } } } } $current_url = (is_ssl() ? 'https://' : 'http://') . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; $current_url = remove_query_arg('action', $current_url); $current_url = remove_query_arg('affiliate_id', $current_url); $name = isset($_POST['name-field']) ? $_POST['name-field'] : $affiliate['name']; $email = isset($_POST['email-field']) ? $_POST['email-field'] : $affiliate['email']; $user_login = isset($_POST['user-field']) ? $_POST['user-field'] : ($affiliate_user != null ? $affiliate_user->user_login : ''); $from_date = isset($_POST['from-date-field']) ? $_POST['from-date-field'] : $affiliate['from_date']; $thru_date = isset($_POST['thru-date-field']) ? $_POST['thru-date-field'] : $affiliate['thru_date']; $output = '<div class="manage-affiliates">' . '<div>' . '<h1>' . __('Edit an affiliate', AFFILIATES_PLUGIN_DOMAIN) . '</h1>' . '</div>' . '<form id="edit-affiliate" action="' . esc_url($current_url) . '" method="post">' . '<div class="affiliate edit">' . '<input id="affiliate-id-field" name="affiliate-id-field" type="hidden" value="' . esc_attr(intval($affiliate_id)) . '"/>' . '<div class="field">' . '<label class="field-label first required">' . '<span class="label">' . __('Name', AFFILIATES_PLUGIN_DOMAIN) . '</span>' . ' ' . '<input id="name-field" name="name-field" class="namefield" type="text" value="' . esc_attr(stripslashes($name)) . '"/>' . '</label>' . '</div>' . '<div class="field">' . '<label class="field-label">' . '<span class="label">' . __('Email', AFFILIATES_PLUGIN_DOMAIN) . '</span>' . ' ' . '<input id="email-field" name="email-field" class="emailfield" type="text" value="' . esc_attr($email) . '"/>' . '</label>' . ' ' . '<span class="description">' . __("If a valid <strong>Username</strong> is specified and no email is given, the user's email address will be used automatically.", AFFILIATES_PLUGIN_DOMAIN) . '</span>' . '</div>' . '<div class="field">' . '<label class="field-label">' . '<span class="label">' . __('Username', AFFILIATES_PLUGIN_DOMAIN) . '</span>' . ' ' . '<input id="user-field" name="user-field" class="userfield" type="text" autocomplete="off" value="' . esc_attr(stripslashes($user_login)) . '"/>' . '</label>' . ' ' . $affiliate_user_edit . '</div>' . $affiliate_user_fields . '<div class="field">' . '<label class="field-label">' . '<span class="label">' . __('From', AFFILIATES_PLUGIN_DOMAIN) . '</span>' . ' ' . '<input id="from-date-field" name="from-date-field" class="datefield" type="text" value="' . esc_attr($from_date) . '"/>' . '</label>' . '</div>' . '<div class="field">' . '<label class="field-label">' . '<span class="label">' . __('Until', AFFILIATES_PLUGIN_DOMAIN) . '</span>' . ' ' . '<input id="thru-date-field" name="thru-date-field" class="datefield" type="text" value="' . esc_attr($thru_date) . '"/>' . '</label>' . '</div>'; $output .= '<div class="field">' . wp_nonce_field('affiliates-edit', AFFILIATES_ADMIN_AFFILIATES_NONCE, true, false) . '<input class="button button-primary" type="submit" value="' . __('Save', AFFILIATES_PLUGIN_DOMAIN) . '"/>' . '<input type="hidden" value="edit" name="action"/>' . ' ' . '<a class="cancel button" href="' . esc_url($current_url) . '">' . __('Cancel', AFFILIATES_PLUGIN_DOMAIN) . '</a>' . '</div>' . '</div>' . '</form>' . '</div>'; // .manage-affiliates echo $output; affiliates_footer(); }