function lists() { global $wpdb; // pager $pager = new mgm_pager(); // data $data = array(); // search fields $data['search_fields'] = array('' => __('Select', 'mgm'), 'id' => __('ID', 'mgm'), 'title' => __('Title', 'mgm'), 'filename' => __('Filename', 'mgm'), 'post_date' => __('Posted', 'mgm'), 'expire_dt' => __('Expires', 'mgm')); // sort fields $data['sort_fields'] = array('id' => __('ID', 'mgm'), 'title' => __('Title', 'mgm'), 'post_date' => __('Posted', 'mgm'), 'expire_dt' => __('Expires', 'mgm')); // filter $sql_filter = $data['search_field_name'] = $data['search_field_value'] = ''; // check if (isset($_POST['search_field_name'])) { // issue#: 219 $search_field_name = $_POST['search_field_name']; // for sql $search_field_value = mgm_escape($_POST['search_field_value']); // for sql // view data $data['search_field_name'] = $_POST['search_field_name']; //issue #1281 $data['search_field_value'] = htmlentities($_POST['search_field_value'], ENT_QUOTES, "UTF-8"); // for display // by field switch ($search_field_name) { case 'id': $sql_filter = " AND `id` = '" . (int) $search_field_value . "'"; break; case 'title': $sql_filter = " AND `title` LIKE '%{$search_field_value}%'"; break; case 'filename': $sql_filter = " AND (`filename` LIKE '%{$search_field_value}%' OR `real_filename` LIKE '%{$search_field_value}%')"; break; case 'post_date': // convert $search_field_value = mgm_format_inputdate_to_mysql($search_field_value); // set filter $sql_filter = " AND DATE_FORMAT(`post_date`,'%Y-%m-%d') = '{$search_field_value}'"; break; case 'expire_dt': // convert $search_field_value = mgm_format_inputdate_to_mysql($search_field_value); // set filter $sql_filter = " AND DATE_FORMAT(`expire_dt`,'%Y-%m-%d') = '{$search_field_value}'"; break; } } // default $sort_field = 'post_date'; // type $sort_type = 'DESC'; // sort field if (isset($_POST['sort_field'])) { $sort_field = $_POST['sort_field']; } // sort type if (isset($_POST['sort_type'])) { $sort_type = $_POST['sort_type']; } // set $data['sort_field'] = $sort_field; // set $data['sort_type'] = $sort_type; // set $sql_order_by = "ORDER BY `{$sort_field}` {$sort_type}"; // page limit $data['page_limit'] = isset($_REQUEST['page_limit']) ? (int) $_REQUEST['page_limit'] : 10; // 10 // page no $data['page_no'] = isset($_REQUEST['page_no']) ? (int) $_REQUEST['page_no'] : 1; // limit $sql_limit = $pager->get_query_limit($data['page_limit']); //sql $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM `" . TBL_MGM_DOWNLOAD . "` WHERE 1 {$sql_filter} {$sql_order_by} {$sql_limit}"; // downloads $data['downloads'] = $wpdb->get_results($sql); // log // mgm_log($wpdb->last_query, __FUNCTION__); // page url $data['page_url'] = 'admin-ajax.php?action=mgm_admin_ajax_action&page=mgm/admin/downloads&method=lists'; // get page links $data['page_links'] = $pager->get_pager_links($data['page_url']); // total pages $data['page_count'] = $pager->get_page_count(); // total rows/results $data['row_count'] = $pager->get_row_count(); // search term $search_term = ''; // search provided if (!empty($data['search_field_value'])) { $search_term = sprintf('where <b>%s</b> is <b>%s</b>', isset($data['search_fields'][$search_field_name]) ? $data['search_fields'][$search_field_name] : '', $data['search_field_value']); } // message $data['message'] = sprintf(__('%d %s matched %s', 'mgm'), $data['row_count'], $data['row_count'] > 1 ? __('downloads', 'mgm') : __('download', 'mgm'), $search_term); // load view $this->load->template('downloads/lists', array('data' => $data)); }
/** * generate members list - short code content */ function mgm_generate_member_list($args = array()) { global $wpdb, $post; //issue #1327 $show_level = isset($args['show_level']) ? $args['show_level'] : null; $show_level_members = array(); if (!empty($show_level) && $show_level != null) { $show_level = explode(',', $show_level); $show_level_count = count($show_level); for ($i = 0; $i < $show_level_count; $i++) { $level_match_members = mgm_get_members_with('membership_type', $show_level[$i]); if (!empty($level_match_members)) { $show_level_members = array_merge($show_level_members, $level_match_members); } } if (!empty($show_level_members)) { $show_level_members = array_unique($show_level_members); } } // current url $current_url = get_permalink($post->ID); // append ? why? // if( !strpos($current_url,'?') !== false) $current_url = ($current_url . '?'); // echo $current_url; // init pager $pager = new mgm_pager(); // init data $data = $custom_search_fields = $custom_sort_fields = $custom_user_list = $user_list = array(); // css group $css_group = mgm_get_css_group(); // html $html = ''; // check if ($css_group != 'none') { // expand this if needed $css_link_format = '<link rel="stylesheet" href="%s" type="text/css" media="all" />'; $css_file = MGM_ASSETS_URL . 'css/' . $css_group . '/mgm.pages.css'; $html .= sprintf($css_link_format, $css_file); } // search fields $data['search_fields'] = array('' => __('Select', 'mgm'), 'username' => __('Username', 'mgm'), 'id' => __('User ID', 'mgm'), 'email' => __('User Email', 'mgm'), 'first_name' => __('First Name', 'mgm'), 'last_name' => __('Last Name', 'mgm'), 'membership_type' => __('Membership Type', 'mgm'), 'reg_date' => __('Registration Date', 'mgm'), 'last_payment' => __('Last Payment', 'mgm'), 'expire_date' => __('Expiration Date', 'mgm'), 'fee' => __('Fee', 'mgm'), 'status' => __('Status', 'mgm')); // sort fields $data['sort_fields'] = array('id' => __('User ID', 'mgm'), 'username' => __('Username', 'mgm'), 'email' => __('User Email', 'mgm'), 'reg_date' => __('Registration Date', 'mgm')); // order fields $data['order_fields'] = array('desc' => __('DESC', 'mgm'), 'asc' => __('ASC', 'mgm')); // custom_fields $custom_fields = mgm_get_class('member_custom_fields'); // getting custom fileds and skip the search fields if allready exists. foreach ($custom_fields->custom_fields as $custom_field) { if (!array_key_exists($custom_field['name'], $data['search_fields'])) { $custom_search_fields[$custom_field['name']] = $custom_field['label']; } } // getting custom fileds and skip the sort fields if allready exists. foreach ($custom_fields->custom_fields as $custom_field) { if (!array_key_exists($custom_field['name'], $data['sort_fields'])) { if ($custom_field['name'] != 'status') { $custom_sort_fields[$custom_field['name']] = $custom_field['label']; } } } // filter $sql_filter = $data['search_field_name'] = $data['search_field_value'] = ''; // field value if (isset($_REQUEST['query'])) { $search_field_value = $_REQUEST['query']; } else { $search_field_value = ''; } // field name if (isset($_REQUEST['by'])) { $search_field_name = $_REQUEST['by']; } else { $search_field_name = ''; } // sort field if (isset($_REQUEST['sort_field'])) { $sort_field_name = $_REQUEST['sort_field']; } else { $sort_field_name = ''; } // sort order type //order_type if (isset($_REQUEST['sort_order'])) { $sort_order_type = $_REQUEST['sort_order']; } else { $sort_order_type = ''; } // members $active_members = mgm_get_members_with('status', MGM_STATUS_ACTIVE); // wrongly called,use constant // check if (!empty($search_field_name)) { // clean $search_field_value = mgm_escape($search_field_value); // for sql $search_field_name = mgm_escape($search_field_name); // for sql // view data $data['search_field_name'] = $search_field_name; $data['search_field_value'] = trim($search_field_value); // current date $curr_date = mgm_get_current_datetime(); $current_date = $curr_date['timestamp']; // check if (array_key_exists($search_field_name, $custom_search_fields)) { // members $members = mgm_get_members_with_customfiled($search_field_name, $search_field_value); //issue #1327 if (!empty($show_level_members)) { $members = array_intersect($show_level_members, $members); } //check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; } else { // by field switch ($search_field_name) { case 'username': // issue#: 347(LIKE SEARCH) $filter = " AND `user_login` LIKE '%{$search_field_value}%'"; // matched $matched_members = mgm_get_members_with_sql_filter($filter); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'id': // filter $filter = " AND `ID` = '" . (int) $search_field_value . "'"; // match $matched_members = mgm_get_members_with_sql_filter($filter); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'email': // issue#: 347(LIKE SEARCH) $filter = " AND `user_email` LIKE '%{$search_field_value}%'"; // match $matched_members = mgm_get_members_with_sql_filter($filter); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'membership_type': // match $matched_members = mgm_get_members_with('membership_type', $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'reg_date': // check if (empty($search_field_value)) { $search_field_value = date('Y-m-d', $current_date); } // convert $search_field_value = mgm_format_inputdate_to_mysql($search_field_value); // set filter $filter = " AND DATE_FORMAT(`user_registered`,'%Y-%m-%d') = '{$search_field_value}'"; // match $matched_members = mgm_get_members_with_sql_filter($filter); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'last_payment': // check if (empty($search_field_value)) { $search_field_value = date('Y-m-d', $current_date); } // convert $search_field_value = mgm_format_inputdate_to_mysql($search_field_value); // match $matched_members = mgm_get_members_with('last_pay_date', $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'expire_date': // check if (empty($search_field_value)) { $search_field_value = date('Y-m-d', $current_date); } // convert $search_field_value = mgm_format_inputdate_to_mysql($search_field_value); // match $matched_members = mgm_get_members_with('expire_date', $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'fee': // match $matched_members = mgm_get_members_with('amount', $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; /* case 'status': // members $members = mgm_get_members_with('status', $search_field_value); // check $members_in = (count($members)==0) ? 0 : (implode(',', $members)); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; */ /* case 'status': // members $members = mgm_get_members_with('status', $search_field_value); // check $members_in = (count($members)==0) ? 0 : (implode(',', $members)); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; */ case 'first_name': case 'last_name': // members $matched_members = mgm_get_members_with($search_field_name, $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; } } } // filters via shortcode args $use_field = isset($args['use_field']) ? $args['use_field'] : null; $use_filter = isset($args['use_filter']) ? $args['use_filter'] : ''; $sort_by = isset($args['sort_by']) ? $args['sort_by'] : null; $sort_type = isset($args['sort_type']) ? $args['sort_type'] : null; // use shortcode field if (!empty($use_field)) { $use_field = explode(',', $use_field); } // use shortcode flter if (!empty($use_filter)) { $use_filter = explode(',', $use_filter); } // use shortcode sort if (!empty($sort_by)) { $sort_by = explode(',', $sort_by); } // use shortcode sort order if (!empty($sort_type)) { $sort_type = explode(',', $sort_type); } //setting up the default list fiedls if (empty($use_field)) { $use_field = array('image', 'first_name', 'last_name', 'email'); } // check length $use_field_len = count($use_field); //getting user fillter options from short code. $arr_filter_search = array(); if (!empty($use_filter)) { $use_filter_len = count($use_filter); for ($k = 0; $k < $use_filter_len; $k++) { if (array_key_exists($use_filter[$k], $data['search_fields'])) { $arr_filter_search[$use_filter[$k]] = $data['search_fields'][$use_filter[$k]]; } elseif (array_key_exists($use_filter[$k], $custom_search_fields)) { $arr_filter_search[$use_filter[$k]] = $custom_search_fields[$use_filter[$k]]; } } $data['search_fields'] = $arr_filter_search; } //getting sort by options from short code. $arr_sort_search = array(); if (!empty($sort_by)) { $use_sort_len = count($sort_by); for ($k = 0; $k < $use_sort_len; $k++) { if (array_key_exists($sort_by[$k], $data['sort_fields'])) { $arr_sort_search[$sort_by[$k]] = $data['sort_fields'][$sort_by[$k]]; } elseif (array_key_exists($sort_by[$k], $custom_sort_fields)) { $arr_sort_search[$sort_by[$k]] = $custom_sort_fields[$sort_by[$k]]; } } $data['sort_fields'] = $arr_sort_search; } //getting sort type options from short code. $arr_sort_type = array(); if (!empty($sort_type)) { $use_sort_type_len = count($sort_by); for ($k = 0; $k < $use_sort_type_len; $k++) { if (array_key_exists($sort_type[$k], $data['order_fields'])) { $arr_sort_type[$sort_type[$k]] = $data['order_fields'][$sort_type[$k]]; } } $data['order_fields'] = $arr_sort_type; } //issue #1301 //setting default sort order field as sort fields first value if (empty($sort_field_name)) { $sort_field_name = array_shift(array_keys($data['sort_fields'])); } //setting default sort order type as sort order fields first value if (empty($sort_order_type)) { $sort_order_type = array_shift(array_keys($data['order_fields'])); } //setting page limit $page_limit = isset($args['page_limit']) ? (int) $args['page_limit'] : 20; // page limit $data['page_limit'] = isset($_REQUEST['page_limit']) ? (int) $_REQUEST['page_limit'] : $page_limit; // page no $data['page_no'] = isset($_REQUEST['page_no']) ? (int) $_REQUEST['page_no'] : 1; // limit $sql_limit = $pager->get_query_limit($data['page_limit']); // order $sql_order = $data['sort_field'] = $data['sort_type'] = ''; // sort $sort_field_name = mgm_escape($sort_field_name); // for sql $sort_order_type = mgm_escape($sort_order_type); // for sql // check if (isset($sort_field_name)) { // set $data['sort_field'] = $sort_field_name; $data['sort_type'] = $sort_order_type; // init $custom_sort = false; // check if (array_key_exists($sort_field_name, $custom_sort_fields)) { $show_level_member = array_intersect($active_members, $show_level_members); // members $sql_order_by = mgm_userlist_customfield_sort($sort_field_name, $sort_order_type, $sql_filter, $show_level_member); // limit $lim = str_replace('LIMIT', '', $sql_limit); $lim = explode(',', $lim); // init $temp_array = array(); // loop for ($i = trim($lim[0]); $i < $lim[0] + $lim[1]; $i++) { if (!empty($sql_order_by[$i])) { $temp_array[] = $sql_order_by[$i]; } } //check for active members //$temp_array = array_intersect ($active_members,$temp_array); $in_order = count($temp_array) == 0 ? 0 : implode(',', $temp_array); // order //$in_order = implode(',',$temp_array); if (!empty($temp_array)) { // set $sql_order = " ORDER BY FIELD( ID, {$in_order} ) "; } else { $sql_order = ''; } // sql $sql = "SELECT * FROM `{$wpdb->users}` WHERE ID != 1 AND `ID` IN ({$in_order}) {$sql_order}"; // list $custom_user_list = $wpdb->get_results($sql); // flag $custom_sort = true; } else { // by name switch ($sort_field_name) { case 'username': $sql_order_by = "user_login"; break; case 'id': $sql_order_by = "ID"; break; case 'email': $sql_order_by = "user_email"; break; case 'membership_type': break; case 'reg_date': $sql_order_by = "user_registered"; break; } // set if (isset($sql_order_by)) { $sql_order = " ORDER BY {$sql_order_by} {$sort_order_type}"; } } } // default if (!isset($sql_order_by)) { $sql_order = " ORDER BY ID desc"; } //default active members ids if (empty($sql_filter)) { //issue #1327 if (!empty($show_level_members)) { // common $members = array_intersect($active_members, $show_level_members); $members_in = count($members) == 0 ? 0 : implode(',', $members); } else { $members_in = count($active_members) == 0 ? 0 : implode(',', $active_members); } // set filter $sql_filter = " AND `ID` IN ({$members_in})"; } // get members $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM `{$wpdb->users}` WHERE ID != 1 {$sql_filter} {$sql_order} {$sql_limit}"; // users $user_list = $wpdb->get_results($sql); // echo $wpdb->last_query; // set if ($custom_sort) { $data['users'] = $custom_user_list; } else { $data['users'] = $user_list; } // page url $data['page_url'] = add_query_arg(array('query' => $search_field_value, 'by' => $search_field_name, 'sort_field' => $sort_field_name, 'sort_order' => $sort_order_type), $current_url); //$url.'query='.$search_field_value.'&by='.$search_field_name.'&sort_field='.$sort_field_name.'&order_type='.$order_type; // get page links $data['page_links'] = $pager->get_pager_links($data['page_url']); // total pages $data['page_count'] = $pager->get_page_count(); // total rows/results $data['row_count'] = $pager->get_row_count(); //sort by filed $sort_field_html = sprintf('<select id="sort_field" name="sort_field" class="width100px">%s</select>', mgm_make_combo_options($data['sort_fields'], $data['sort_field'], MGM_KEY_VALUE)); //order by asc/desc $sort_order_html = sprintf('<select id="sort_order" name="sort_order" class="width100px">%s</select>', mgm_make_combo_options($data['order_fields'], $data['sort_type'], MGM_KEY_VALUE)); //search by $search_by_html = sprintf('<select id="by" name="by" class="width100px">%s</select>', mgm_make_combo_options($data['search_fields'], $data['search_field_name'], MGM_KEY_VALUE)); //search box $html = '<div> <form method="get" action="' . $current_url . '"> <h5>' . __('Search Our Members', 'mgm') . ':</h5> <input type="text" id="query" name="query" value="' . $data['search_field_value'] . '" /> ' . __('in', 'mgm') . ' ' . $search_by_html . ' ' . __('sort by', 'mgm') . ' ' . $sort_field_html . ' ' . $sort_order_html . ' <input class="button" type="submit" id="submit" value="' . __('Submit', 'mgm') . '" /> <input type="hidden" name="search" id="search" value="search" /> </form> </div>'; $html .= '<div><table><tr>'; for ($i = 0; $i < $use_field_len; $i++) { $html .= sprintf('<th class="th_div mgm_text_align_left mgm_column_%s" id="mgm_column_%s"><label><b>%s</b></label></th>', $use_field[$i], $use_field[$i], ucwords(str_replace('_', ' ', $use_field[$i]))); } $html .= '</tr>'; $enable_public_profile = mgm_get_class('system')->get_setting('enable_public_profile'); if (!empty($data['users'])) { foreach ($data['users'] as $user) { // user object $user = get_userdata($user->ID); // mgm member object $member = mgm_get_member($user->ID); $html .= '<tr>'; for ($i = 0; $i < $use_field_len; $i++) { $app_user_filed = 'user_' . $use_field[$i]; if (isset($member->custom_fields->{$use_field}[$i]) || isset($user->{$use_field}[$i]) || isset($user->{$app_user_filed}) || $use_field[$i] == 'image') { if ($use_field[$i] == 'image') { //is_multisite,network_home_url $html .= sprintf('<td align="left" valign="top" class="mgm_%s_value">', $use_field[$i]); if (bool_from_yn($enable_public_profile)) { //$profile_url = add_query_arg(array('username'=>$user->user_login), site_url('userprofile')); $profile_url = network_site_url() . '/userprofile/?username='******'<a class="tern_wp_member_gravatar" href="%s">%s</a>', $profile_url, get_avatar($user->ID, 60)); } else { $html .= sprintf('<a href="javascript://">%s</a>', get_avatar($user->ID, 60)); } $html .= '</td>'; } else { //getting data from user object if (isset($user->{$use_field}[$i])) { $member->custom_fields->{$use_field}[$i] = $user->{$use_field}[$i]; } //getting data from user object if ($use_field[$i] == 'email') { $member->custom_fields->{$use_field}[$i] = $user->{$app_user_filed}; } // val unserialize $val = maybe_unserialize($member->custom_fields->{$use_field}[$i]); // array to string if (is_array($val)) { $val = implode(', ', $val); } // set $html .= sprintf('<td align="left" valign="top" class="mgm_%s_value"><b>%s</b></td>', $use_field[$i], $val); } } } $html .= '</tr>'; } } else { $html .= '<tr><td colspan="' . $use_field_len . '" align="center">' . __('No members found', 'mgm') . ' ...! </td></tr>'; } $html .= '</table></div><br/>'; $html .= '<div class="mgm_page_links_div">'; if ($data['page_links']) { $html .= '<div class="pager-wrap">' . $data['page_links'] . '</div><div class="clearfix"></div>'; } $html .= '</div><br/>'; //issue #1635 $users_list_html = '<div class="mgm_user_list_container">' . $html . '</div>'; return $users_list_html; }
function payment_history_export() { global $wpdb; // data $data = array(); // filter $sql_filter = $payment_type = ''; // check if (isset($_POST['search_field_name'])) { // issue#: 219 $search_field_name = $_POST['search_field_name']; // for sql $search_field_value = mgm_escape($_POST['search_field_value']); // for sql $search_field_value = trim($search_field_value); // by field switch ($search_field_name) { case 'username': // issue#: 347(LIKE SEARCH) $sql_filter = " AND user.user_login LIKE '%{$search_field_value}%'"; break; case 'id': $sql_filter = " AND user.ID = '" . (int) $search_field_value . "'"; break; case 'email': // issue#: 347(LIKE SEARCH) $sql_filter = " AND user.user_email LIKE '%{$search_field_value}%'"; break; case 'membership_type': // members $members = mgm_get_members_with('membership_type', $search_field_value); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND user.ID IN ({$members_in})"; break; case 'payment_type': $payment_type = $search_field_value; break; case 'first_name': case 'last_name': // members $members = mgm_get_members_with($search_field_name, $search_field_value); //check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND user.ID IN ({$members_in})"; break; } } if (!empty($payment_type)) { $con = " AND transaction.payment_type = '" . $payment_type . "' "; } else { $con = ''; } //payment success check $pay_succ = " AND transaction.status_text = 'Last payment was successful'"; $transaction_sql = "SELECT SQL_CALC_FOUND_ROWS * FROM " . TBL_MGM_TRANSACTION . " transaction LEFT JOIN {$wpdb->users} user ON transaction.user_id = user.ID "; $transaction_sql .= "WHERE transaction.module IS NOT NULL"; $transaction_sql .= $pay_succ; $transaction_sql .= $con; $transaction_sql .= $sql_filter; $transaction_sql .= " ORDER BY transaction.transaction_dt DESC {$sql_limit}"; $data['transactions'] = $wpdb->get_results($transaction_sql); $export_transactions = array(); if (count($data['transactions']) > 0) { foreach ($data['transactions'] as $tran_log) { $json_decoded = json_decode($tran_log->data); $user_obj = get_userdata($json_decoded->user_id); //empty obj $row = new stdClass(); if (!empty($user_obj)) { //export fields $row->id = $user_obj->ID; $row->username = $user_obj->user_login; $row->firstname = $user_obj->first_name; $row->lastname = $user_obj->last_name; $row->email = $user_obj->user_email; $row->payment_type = ucwords(str_replace('_', ' ', $tran_log->payment_type)); $row->module = ucwords($tran_log->module); $row->amount = $json_decoded->trial_on ? $json_decoded->trial_cost : $json_decoded->cost; $row->transaction_date = date(MGM_DATE_FORMAT_SHORT, strtotime($tran_log->transaction_dt)); } // cache $export_transactions[] = $row; // unset unset($row); } } // message $message = __('Error while exporting transactions. Could not find any transaction with requested search parameters.', 'mgm'); // default response $response = array('status' => 'error', 'message' => $message); // check if (count($export_transactions) > 0) { // success $success = count($export_transactions); // create if (mgm_post_var('export_format') == 'csv') { $filename = mgm_create_csv_file($export_transactions, 'export_transactions'); } else { $filename = mgm_create_xls_file($export_transactions, 'export_transactions'); } // src $file_src = MGM_FILES_EXPORT_URL . $filename; // message $response['message'] = sprintf(__('Successfully exported %d %s.', 'mgm'), $success, $success > 1 ? 'transactions' : 'transaction'); $response['status'] = 'success'; $response['src'] = $file_src; } // return response echo json_encode($response); exit; }
private function _members_check_rebill_status() { global $current_user, $wpdb; // extract extract($_POST); // init $message = __('Member rebill status check failed', 'mgm'); $status = 'error'; // check if (isset($current_user->ID) && $current_user->ID != 0 && is_numeric($current_user->ID)) { // users check if (isset($members) && !empty($members)) { // define if (!defined('DOING_QUERY_REBILL_STATUS')) { define('DOING_QUERY_REBILL_STATUS', 'manual'); } // ctr $updated = 0; // loop users foreach ($members as $uid) { //delete user $uid = mgm_escape($uid); // check if ((int) $uid > 0) { // get user $user = new WP_User($uid); // check if (isset($user->ID) && (int) $user->ID > 0) { // member data $member = mgm_get_member($user->ID); // reset disabled, force recheck $member->last_payment_check = ''; // check if (apply_filters('mgm_module_rebill_status', $user->ID, $member)) { // update $updated++; } // update mgm_update_payment_check_state($user->ID, 'manual'); } // unset unset($user, $member); } } // message $item = $updated > 1 ? 'members' : 'member'; // set if (!$updated) { $message = sprintf(__('Error while updating %s rebill status.', 'mgm'), $item); } elseif ($updated && count($members) != $updated) { $message = sprintf(__('Partially updated rebill status of %d %s .', 'mgm'), $updated, $item); } else { $message = sprintf(__('Successfully updated rebill status of %d %s.', 'mgm'), $updated, $item); $status = 'success'; } } } // return return array('status' => $status, 'message' => $message); }