/**
  * Get the Export Data
  *
  * @access public
  * @since 1.5
  * @global object $wpdb Used to query the database using the WordPress
  *   Database API
  * @return array $data The data for the CSV file
  */
 public function get_data()
 {
     $args = array('number' => $this->per_step, 'offset' => $this->per_step * ($this->step - 1), 'orderby' => 'id', 'order' => 'DESC');
     $customers = Give()->customers->get_customers($args);
     if ($customers) {
         $allowed_payment_status = apply_filters('give_recount_customer_payment_statuses', give_get_payment_status_keys());
         foreach ($customers as $customer) {
             $attached_payment_ids = explode(',', $customer->payment_ids);
             $attached_args = array('post__in' => $attached_payment_ids, 'number' => -1, 'status' => $allowed_payment_status);
             $attached_payments = (array) give_get_payments($attached_args);
             $unattached_args = array('post__not_in' => $attached_payment_ids, 'number' => -1, 'status' => $allowed_payment_status, 'meta_query' => array(array('key' => '_give_payment_user_email', 'value' => $customer->email, 'compare' => '=')));
             $unattached_payments = give_get_payments($unattached_args);
             $payments = array_merge($attached_payments, $unattached_payments);
             $purchase_value = 0.0;
             $purchase_count = 0;
             $payment_ids = array();
             if ($payments) {
                 foreach ($payments as $payment) {
                     $should_process_payment = 'publish' == $payment->post_status ? true : false;
                     $should_process_payment = apply_filters('give_customer_recount_should_process_payment', $should_process_payment, $payment);
                     if (true === $should_process_payment) {
                         if (apply_filters('give_customer_recount_should_increase_value', true, $payment)) {
                             $purchase_value += give_get_payment_amount($payment->ID);
                         }
                         if (apply_filters('give_customer_recount_should_increase_count', true, $payment)) {
                             $purchase_count++;
                         }
                     }
                     $payment_ids[] = $payment->ID;
                 }
             }
             $payment_ids = implode(',', $payment_ids);
             $customer_update_data = array('purchase_count' => $purchase_count, 'purchase_value' => $purchase_value, 'payment_ids' => $payment_ids);
             $customer_instance = new Give_Customer($customer->id);
             $customer_instance->update($customer_update_data);
         }
         return true;
     }
     return false;
 }
 /**
  * Zero out the data on step one
  *
  * @access public
  * @since 1.5
  * @return void
  */
 public function pre_fetch()
 {
     if ($this->step === 1) {
         $allowed_payment_status = apply_filters('give_recount_customer_payment_statuses', give_get_payment_status_keys());
         // Before we start, let's zero out the customer's data
         $customer = new Give_Customer($this->customer_id);
         $customer->update(array('purchase_value' => give_format_amount(0), 'purchase_count' => 0));
         $attached_payment_ids = explode(',', $customer->payment_ids);
         $attached_args = array('post__in' => $attached_payment_ids, 'number' => -1, 'status' => $allowed_payment_status);
         $attached_payments = give_get_payments($attached_args);
         $unattached_args = array('post__not_in' => $attached_payment_ids, 'number' => -1, 'status' => $allowed_payment_status, 'meta_query' => array(array('key' => '_give_payment_user_email', 'value' => $customer->email)));
         $unattached_payments = give_get_payments($unattached_args);
         $payments = array_merge($attached_payments, $unattached_payments);
         $this->store_data('give_recount_customer_payments_' . $customer->id, $payments);
     }
 }
예제 #3
0
 /**
  * Retrieve all the data for all the payments
  *
  * @access public
  * @since  1.0
  * @return array $payment_data Array of all the data for the payments
  */
 public function payments_data()
 {
     $per_page = $this->per_page;
     $orderby = isset($_GET['orderby']) ? urldecode($_GET['orderby']) : 'ID';
     $order = isset($_GET['order']) ? $_GET['order'] : 'DESC';
     $user = isset($_GET['user']) ? $_GET['user'] : null;
     $status = isset($_GET['status']) ? $_GET['status'] : give_get_payment_status_keys();
     $meta_key = isset($_GET['meta_key']) ? $_GET['meta_key'] : null;
     $year = isset($_GET['year']) ? $_GET['year'] : null;
     $month = isset($_GET['m']) ? $_GET['m'] : null;
     $day = isset($_GET['day']) ? $_GET['day'] : null;
     $search = isset($_GET['s']) ? sanitize_text_field($_GET['s']) : null;
     $start_date = isset($_GET['start-date']) ? sanitize_text_field($_GET['start-date']) : null;
     $end_date = isset($_GET['end-date']) ? sanitize_text_field($_GET['end-date']) : $start_date;
     if (!empty($search)) {
         $status = 'any';
         // Force all payment statuses when searching
     }
     $args = array('output' => 'payments', 'number' => $per_page, 'page' => isset($_GET['paged']) ? $_GET['paged'] : null, 'orderby' => $orderby, 'order' => $order, 'user' => $user, 'status' => $status, 'meta_key' => $meta_key, 'year' => $year, 'month' => $month, 'day' => $day, 's' => $search, 'start_date' => $start_date, 'end_date' => $end_date);
     if (is_string($search) && false !== strpos($search, 'txn:')) {
         $args['search_in_notes'] = true;
         $args['s'] = trim(str_replace('txn:', '', $args['s']));
     }
     $p_query = new Give_Payments_Query($args);
     return $p_query->get_payments();
 }
예제 #4
0
 /**
  * Default query arguments.
  *
  * Not all of these are valid arguments that can be passed to WP_Query. The ones that are not, are modified before
  * the query is run to convert them to the proper syntax.
  *
  * @since  1.0
  * @access public
  *
  * @param  $args array The array of arguments that can be passed in and used for setting up this payment query.
  */
 public function __construct($args = array())
 {
     $defaults = array('output' => 'payments', 'post_type' => array('give_payment'), 'start_date' => false, 'end_date' => false, 'number' => 20, 'page' => null, 'orderby' => 'ID', 'order' => 'DESC', 'user' => null, 'status' => give_get_payment_status_keys(), 'meta_key' => null, 'year' => null, 'month' => null, 'day' => null, 's' => null, 'search_in_notes' => false, 'children' => false, 'fields' => null, 'give_forms' => null);
     $this->args = wp_parse_args($args, $defaults);
     $this->init();
 }