Defined (1)

The class is defined in the following location(s).

/classes/class.memberorder.php  

class MemberOrder 
{ 
    /** 
     * Constructor 
     */ 
    function __construct($id = NULL) 
    { 
        //set up the gateway 
        $this->setGateway(pmpro_getOption("gateway")); 
 
        //get data if an id was passed 
        if($id) 
        { 
            if(is_numeric($id)) 
                return $this->getMemberOrderByID($id); 
            else 
                return $this->getMemberOrderByCode($id); 
        } 
        else 
            return $this->getEmptyMemberOrder();    //blank constructor 
    } 
 
    /** 
     * Returns an empty (but complete) order object. 
     * 
     * @return stdClass $order - a 'clean' order object 
     * 
     * @since: 1.8.6.8 
     */ 
    function getEmptyMemberOrder() 
    { 
 
        //defaults 
        $order = new stdClass(); 
        $order->code = $this->getRandomCode(); 
        $order->user_id = ""; 
        $order->membership_id = ""; 
        $order->subtotal = ""; 
        $order->tax = ""; 
        $order->couponamount = ""; 
        $order->total = ""; 
        $order->payment_type = ""; 
        $order->cardtype = ""; 
        $order->accountnumber = ""; 
        $order->expirationmonth = ""; 
        $order->expirationyear = ""; 
        $order->status = "success"; 
        $order->gateway = pmpro_getOption("gateway"); 
        $order->gateway_environment = pmpro_getOption("gateway_environment"); 
        $order->payment_transaction_id = ""; 
        $order->subscription_transaction_id = ""; 
        $order->affiliate_id = ""; 
        $order->affiliate_subid = ""; 
        $order->notes = ""; 
        $order->checkout_id = 0; 
 
        $order->billing = new stdClass(); 
        $order->billing->name = ""; 
        $order->billing->street = ""; 
        $order->billing->city = ""; 
        $order->billing->state = ""; 
        $order->billing->zip = ""; 
        $order->billing->country = ""; 
        $order->billing->phone = ""; 
 
        return $order; 
    } 
 
    /** 
     * Retrieve a member order from the DB by ID 
     */ 
    function getMemberOrderByID($id) 
    { 
        global $wpdb; 
 
        if(!$id) 
            return false; 
 
        $gmt_offset = get_option('gmt_offset'); 
        $dbobj = $wpdb->get_row("SELECT *, UNIX_TIMESTAMP(timestamp) + " . ($gmt_offset * 3600) . "  as timestamp FROM $wpdb->pmpro_membership_orders WHERE id = '$id' LIMIT 1"); 
 
        if($dbobj) 
        { 
            $this->id = $dbobj->id; 
            $this->code = $dbobj->code; 
            $this->session_id = $dbobj->session_id; 
            $this->user_id = $dbobj->user_id; 
            $this->membership_id = $dbobj->membership_id; 
            $this->paypal_token = $dbobj->paypal_token; 
            $this->billing = new stdClass(); 
            $this->billing->name = $dbobj->billing_name; 
            $this->billing->street = $dbobj->billing_street; 
            $this->billing->city = $dbobj->billing_city; 
            $this->billing->state = $dbobj->billing_state; 
            $this->billing->zip = $dbobj->billing_zip; 
            $this->billing->country = $dbobj->billing_country; 
            $this->billing->phone = $dbobj->billing_phone; 
 
            //split up some values 
            $nameparts = pnp_split_full_name($this->billing->name); 
 
            if(!empty($nameparts['fname'])) 
                $this->FirstName = $nameparts['fname']; 
            else 
                $this->FirstName = ""; 
            if(!empty($nameparts['lname'])) 
                $this->LastName = $nameparts['lname']; 
            else 
                $this->LastName = ""; 
 
            $this->Address1 = $this->billing->street; 
 
            //get email from user_id 
            $this->Email = $wpdb->get_var("SELECT user_email FROM $wpdb->users WHERE ID = '" . $this->user_id . "' LIMIT 1"); 
 
            $this->subtotal = $dbobj->subtotal; 
            $this->tax = $dbobj->tax; 
            $this->couponamount = $dbobj->couponamount; 
            $this->certificate_id = $dbobj->certificate_id; 
            $this->certificateamount = $dbobj->certificateamount; 
            $this->total = $dbobj->total; 
            $this->payment_type = $dbobj->payment_type; 
            $this->cardtype = $dbobj->cardtype; 
            $this->accountnumber = trim($dbobj->accountnumber); 
            $this->expirationmonth = $dbobj->expirationmonth; 
            $this->expirationyear = $dbobj->expirationyear; 
 
            //date formats sometimes useful 
            $this->ExpirationDate = $this->expirationmonth . $this->expirationyear; 
            $this->ExpirationDate_YdashM = $this->expirationyear . "-" . $this->expirationmonth; 
 
            $this->status = $dbobj->status; 
            $this->gateway = $dbobj->gateway; 
            $this->gateway_environment = $dbobj->gateway_environment; 
            $this->payment_transaction_id = $dbobj->payment_transaction_id; 
            $this->subscription_transaction_id = $dbobj->subscription_transaction_id; 
            $this->timestamp = $dbobj->timestamp; 
            $this->affiliate_id = $dbobj->affiliate_id; 
            $this->affiliate_subid = $dbobj->affiliate_subid; 
 
            $this->notes = $dbobj->notes; 
            $this->checkout_id = $dbobj->checkout_id; 
 
            //reset the gateway 
            if(empty($this->nogateway)) 
                $this->setGateway(); 
 
            return $this->id; 
        } 
        else 
            return false;    //didn't find it in the DB 
    } 
 
    /** 
     * Set up the Gateway class to use with this order. 
     * 
     * @param string $gateway Name/label for the gateway to set. 
     * 
     */ 
    function setGateway($gateway = NULL) { 
        //set the gateway property 
        if(isset($gateway)) { 
            $this->gateway = $gateway; 
        } 
 
        //which one to load? 
        $classname = "PMProGateway";    //default test gateway 
        if(!empty($this->gateway) && $this->gateway != "free") { 
            $classname .= "_" . $this->gateway;    //adding the gateway suffix 
        } 
 
        if(class_exists($classname) && isset($this->gateway)) { 
            $this->Gateway = new $classname($this->gateway); 
        } else { 
            $this->Gateway = null;    //null out any current gateway 
            $error = new WP_Error("PMPro1001", "Could not locate the gateway class file with class name = " . $classname . "."); 
        } 
 
        if(!empty($this->Gateway)) { 
            return $this->Gateway; 
        } else { 
            //gateway wasn't setup 
            return false; 
        } 
    } 
 
    /** 
     * Get the most recent order for a user. 
     * 
     * @param int $user_id ID of user to find order for. 
     * @param string $status Limit search to only orders with this status. Defaults to "success". 
     * @param int $membership_id Limit search to only orders for this membership level. Defaults to NULL to find orders for any level. 
     * 
     * @return MemberOrder 
     */ 
    function getLastMemberOrder($user_id = NULL, $status = 'success', $membership_id = NULL, $gateway = NULL, $gateway_environment = NULL) 
    { 
        global $current_user, $wpdb; 
        if(!$user_id) 
            $user_id = $current_user->ID; 
 
        if(!$user_id) 
            return false; 
 
        //build query 
        $this->sqlQuery = "SELECT id FROM $wpdb->pmpro_membership_orders WHERE user_id = '" . $user_id . "' "; 
        if(!empty($status) && is_array($status)) 
            $this->sqlQuery .= "AND status IN('" . implode("', '", $status) . "') "; 
        elseif(!empty($status)) 
            $this->sqlQuery .= "AND status = '" . esc_sql($status) . "' "; 
 
        if(!empty($membership_id)) 
            $this->sqlQuery .= "AND membership_id = '" . $membership_id . "' "; 
 
        if(!empty($gateway)) 
            $this->sqlQuery .= "AND gateway = '" . esc_sql($gateway) . "' "; 
 
        if(!empty($gateway_environment)) 
            $this->sqlQuery .= "AND gateway_environment = '" . esc_sql($gateway_environment) . "' "; 
 
        $this->sqlQuery .= "ORDER BY timestamp DESC LIMIT 1"; 
 
        //get id 
        $id = $wpdb->get_var($this->sqlQuery); 
 
        return $this->getMemberOrderByID($id); 
    } 
 
    /** 
        Returns the order using the given order code. 
    */ 
    function getMemberOrderByCode($code) 
    { 
        global $wpdb; 
        $id = $wpdb->get_var("SELECT id FROM $wpdb->pmpro_membership_orders WHERE code = '" . $code . "' LIMIT 1"); 
        if($id) 
            return $this->getMemberOrderByID($id); 
        else 
            return false; 
    } 
 
    /** 
        Returns the last order using the given payment_transaction_id. 
    */ 
    function getMemberOrderByPaymentTransactionID($payment_transaction_id) 
    { 
        //did they pass a trans id? 
        if(empty($payment_transaction_id)) 
            return false; 
 
        global $wpdb; 
        $id = $wpdb->get_var("SELECT id FROM $wpdb->pmpro_membership_orders WHERE payment_transaction_id = '" . esc_sql($payment_transaction_id) . "' LIMIT 1"); 
        if($id) 
            return $this->getMemberOrderByID($id); 
        else 
            return false; 
    } 
 
    /** 
     * Returns the last order using the given subscription_transaction_id. 
     */ 
    function getLastMemberOrderBySubscriptionTransactionID($subscription_transaction_id) 
    { 
        //did they pass a sub id? 
        if(empty($subscription_transaction_id)) 
            return false; 
 
        global $wpdb; 
        $id = $wpdb->get_var("SELECT id FROM $wpdb->pmpro_membership_orders WHERE subscription_transaction_id = '" . esc_sql($subscription_transaction_id) . "' ORDER BY id DESC LIMIT 1"); 
 
        if($id) 
            return $this->getMemberOrderByID($id); 
        else 
            return false; 
    } 
 
    /** 
     * Returns the last order using the given paypal token. 
     */ 
    function getMemberOrderByPayPalToken($token) 
    { 
        global $wpdb; 
        $id = $wpdb->get_var("SELECT id FROM $wpdb->pmpro_membership_orders WHERE paypal_token = '" . $token . "' LIMIT 1"); 
        if($id) 
            return $this->getMemberOrderByID($id); 
        else 
            return false; 
    } 
 
    /** 
     * Get a discount code object for the code used in this order. 
     * 
     * @param bool $force If true, it will query the database again. 
     * 
     */ 
    function getDiscountCode($force = false) 
    { 
        if(!empty($this->discount_code) && !$force) 
            return $this->discount_code; 
 
        global $wpdb; 
        $this->discount_code = $wpdb->get_row("SELECT dc.* FROM $wpdb->pmpro_discount_codes dc LEFT JOIN $wpdb->pmpro_discount_codes_uses dcu ON dc.id = dcu.code_id WHERE dcu.order_id = '" . $this->id . "' LIMIT 1"); 
 
        //filter @since v1.7.14 
        $this->discount_code = apply_filters("pmpro_order_discount_code", $this->discount_code, $this); 
 
        return $this->discount_code; 
    } 
 
    /** 
     * Get a user object for the user associated with this order. 
     */ 
    function getUser() 
    { 
        global $wpdb; 
 
        if(!empty($this->user)) 
            return $this->user; 
 
        $gmt_offset = get_option('gmt_offset'); 
        $this->user = $wpdb->get_row("SELECT *, UNIX_TIMESTAMP(user_registered) + " . ($gmt_offset * 3600) . "  as user_registered FROM $wpdb->users WHERE ID = '" . $this->user_id . "' LIMIT 1"); 
        return $this->user; 
    } 
 
    /** 
     * Get a membership level object for the level associated with this order. 
     * 
     * @param bool $force If true, it will query the database again. 
     * 
     */ 
    function getMembershipLevel($force = false) 
    { 
        global $wpdb; 
 
        if(!empty($this->membership_level) && empty($force)) 
            return $this->membership_level; 
 
        //check if there is an entry in memberships_users first 
        if(!empty($this->user_id)) 
        { 
            $this->membership_level = $wpdb->get_row("SELECT l.id as level_id, l.name, l.description, l.allow_signups, l.expiration_number, l.expiration_period, mu.*, UNIX_TIMESTAMP(mu.startdate) as startdate, UNIX_TIMESTAMP(mu.enddate) as enddate, l.name, l.description, l.allow_signups FROM $wpdb->pmpro_membership_levels l LEFT JOIN $wpdb->pmpro_memberships_users mu ON l.id = mu.membership_id WHERE mu.status = 'active' AND l.id = '" . $this->membership_id . "' AND mu.user_id = '" . $this->user_id . "' LIMIT 1"); 
 
            //fix the membership level id 
            if(!empty($this->membership_level->level_id)) 
                $this->membership_level->id = $this->membership_level->level_id; 
        } 
 
        //okay, do I have a discount code to check? (if there is no membership_level->membership_id value, that means there was no entry in memberships_users) 
        if(!empty($this->discount_code) && empty($this->membership_level->membership_id)) 
        { 
            if(!empty($this->discount_code->code)) 
                $discount_code = $this->discount_code->code; 
            else 
                $discount_code = $this->discount_code; 
 
            $sqlQuery = "SELECT l.id, cl.*, l.name, l.description, l.allow_signups FROM $wpdb->pmpro_discount_codes_levels cl LEFT JOIN $wpdb->pmpro_membership_levels l ON cl.level_id = l.id LEFT JOIN $wpdb->pmpro_discount_codes dc ON dc.id = cl.code_id WHERE dc.code = '" . $discount_code . "' AND cl.level_id = '" . $this->membership_id . "' LIMIT 1"; 
 
            $this->membership_level = $wpdb->get_row($sqlQuery); 
        } 
 
        //just get the info from the membership table    (sigh, I really need to standardize the column names for membership_id/level_id) but we're checking if we got the information already or not 
        if(empty($this->membership_level->membership_id) && empty($this->membership_level->level_id)) 
        { 
            $this->membership_level = $wpdb->get_row("SELECT l.* FROM $wpdb->pmpro_membership_levels l WHERE l.id = '" . $this->membership_id . "' LIMIT 1"); 
        } 
 
        return $this->membership_level; 
    } 
 
    /** 
     * Apply tax rules for the price given. 
     */ 
    function getTaxForPrice($price) 
    { 
        //get options 
        $tax_state = pmpro_getOption("tax_state"); 
        $tax_rate = pmpro_getOption("tax_rate"); 
 
        //default 
        $tax = 0; 
 
        //calculate tax 
        if($tax_state && $tax_rate) 
        { 
            //we have values, is this order in the tax state? 
            if(!empty($this->billing) && trim(strtoupper($this->billing->state)) == trim(strtoupper($tax_state))) 
            { 
                //return value, pass through filter 
                $tax = round((float)$price * (float)$tax_rate, 2); 
            } 
        } 
 
        //set values array for filter 
        $values = array("price" => $price, "tax_state" => $tax_state, "tax_rate" => $tax_rate); 
        if(!empty($this->billing->state)) 
            $values['billing_state'] = $this->billing->state; 
        if(!empty($this->billing->city)) 
            $values['billing_city'] = $this->billing->city; 
        if(!empty($this->billing->zip)) 
            $values['billing_zip'] = $this->billing->zip; 
        if(!empty($this->billing->country)) 
            $values['billing_country'] = $this->billing->country; 
 
        //filter 
        $tax = apply_filters("pmpro_tax", $tax, $values, $this); 
        return $tax; 
    } 
 
    /** 
     * Get the tax amount for this order. 
     */ 
    function getTax($force = false) 
    { 
        if(!empty($this->tax) && !$force) 
            return $this->tax; 
 
        //reset 
        $this->tax = $this->getTaxForPrice($this->subtotal); 
 
        return $this->tax; 
    } 
 
    /** 
     * Change the timestamp of an order by passing in year, month, day, time 
     */ 
    function updateTimestamp($year, $month, $day, $time = NULL) 
    { 
        if(empty($this->id)) 
            return false;        //need a saved order 
 
        if(empty($time)) 
            $time = "00:00:00"; 
 
        $date = $year . "-" . $month . "-" . $day . " " . $time; 
 
        global $wpdb; 
        $this->sqlQuery = "UPDATE $wpdb->pmpro_membership_orders SET timestamp = '" . $date . "' WHERE id = '" . $this->id . "' LIMIT 1"; 
 
        if($wpdb->query($this->sqlQuery) !== "false") 
            return $this->getMemberOrderByID($this->id); 
        else 
            return false; 
    } 
 
    /** 
     * Save/update the values of the order in the database. 
     */ 
    function saveOrder() 
    { 
        global $current_user, $wpdb, $pmpro_checkout_id; 
 
        //get a random code to use for the public ID 
        if(empty($this->code)) 
            $this->code = $this->getRandomCode(); 
 
        //figure out how much we charged 
        if(!empty($this->InitialPayment)) 
            $amount = $this->InitialPayment; 
        elseif(!empty($this->subtotal)) 
            $amount = $this->subtotal; 
        else 
            $amount = 0; 
 
        //Todo: Tax?!, Coupons, Certificates, affiliates 
        if(empty($this->subtotal)) 
            $this->subtotal = $amount; 
        if(isset($this->tax)) 
            $tax = $this->tax; 
        else 
            $tax = $this->getTax(true); 
        $this->certificate_id = ""; 
        $this->certificateamount = ""; 
 
        //calculate total 
        if(!empty($this->total)) 
            $total = $this->total; 
        else { 
            $total = (float)$amount + (float)$tax; 
            $this->total = $total; 
        } 
 
        //these fix some warnings/notices 
        if(empty($this->billing)) 
        { 
            $this->billing = new stdClass(); 
            $this->billing->name = $this->billing->street = $this->billing->city = $this->billing->state = $this->billing->zip = $this->billing->country = $this->billing->phone = ""; 
        } 
        if(empty($this->user_id)) 
            $this->user_id = 0; 
        if(empty($this->paypal_token)) 
            $this->paypal_token = ""; 
        if(empty($this->couponamount)) 
            $this->couponamount = ""; 
        if(empty($this->payment_type)) 
            $this->payment_type = ""; 
        if(empty($this->payment_transaction_id)) 
            $this->payment_transaction_id = ""; 
        if(empty($this->subscription_transaction_id)) 
            $this->subscription_transaction_id = ""; 
        if(empty($this->affiliate_id)) 
            $this->affiliate_id = ""; 
        if(empty($this->affiliate_subid)) 
            $this->affiliate_subid = ""; 
        if(empty($this->session_id)) 
            $this->session_id = ""; 
        if(empty($this->accountnumber)) 
            $this->accountnumber = ""; 
        if(empty($this->cardtype)) 
            $this->cardtype = ""; 
        if(empty($this->ExpirationDate)) 
            $this->ExpirationDate = ""; 
        if (empty($this->status)) 
            $this->status = ""; 
 
        if(empty($this->gateway)) 
            $this->gateway = pmpro_getOption("gateway"); 
        if(empty($this->gateway_environment)) 
            $this->gateway_environment = pmpro_getOption("gateway_environment"); 
 
        if(empty($this->datetime) && empty($this->timestamp)) 
            $this->datetime = date_i18n("Y-m-d H:i:s", current_time("timestamp"));        //use current time 
        elseif(empty($this->datetime) && !empty($this->timestamp) && is_numeric($this->timestamp)) 
            $this->datetime = date_i18n("Y-m-d H:i:s", $this->timestamp);    //get datetime from timestamp 
        elseif(empty($this->datetime) && !empty($this->timestamp)) 
            $this->datetime = $this->timestamp;        //must have a datetime in it 
 
        if(empty($this->notes)) 
            $this->notes = ""; 
 
        if(empty($this->checkout_id) || intval($this->checkout_id)<1) { 
            $highestval = $wpdb->get_var("SELECT MAX(checkout_id) FROM $wpdb->pmpro_membership_orders"); 
            $this->checkout_id = intval($highestval)+1; 
            $pmpro_checkout_id = $this->checkout_id; 
        } 
 
        //build query 
        if(!empty($this->id)) 
        { 
            //set up actions 
            $before_action = "pmpro_update_order"; 
            $after_action = "pmpro_updated_order"; 
            //update 
            $this->sqlQuery = "UPDATE $wpdb->pmpro_membership_orders 
                                SET `code` = '" . $this->code . "',  
                                `session_id` = '" . $this->session_id . "',  
                                `user_id` = " . intval($this->user_id) . ",  
                                `membership_id` = " . intval($this->membership_id) . ",  
                                `paypal_token` = '" . $this->paypal_token . "',  
                                `billing_name` = '" . esc_sql($this->billing->name) . "',  
                                `billing_street` = '" . esc_sql($this->billing->street) . "',  
                                `billing_city` = '" . esc_sql($this->billing->city) . "',  
                                `billing_state` = '" . esc_sql($this->billing->state) . "',  
                                `billing_zip` = '" . esc_sql($this->billing->zip) . "',  
                                `billing_country` = '" . esc_sql($this->billing->country) . "',  
                                `billing_phone` = '" . esc_sql($this->billing->phone) . "',  
                                `subtotal` = '" . $this->subtotal . "',  
                                `tax` = '" . $this->tax . "',  
                                `couponamount` = '" . $this->couponamount . "',  
                                `certificate_id` = " . intval($this->certificate_id) . ",  
                                `certificateamount` = '" . $this->certificateamount . "',  
                                `total` = '" . $this->total . "',  
                                `payment_type` = '" . $this->payment_type . "',  
                                `cardtype` = '" . $this->cardtype . "',  
                                `accountnumber` = '" . $this->accountnumber . "',  
                                `expirationmonth` = '" . $this->expirationmonth . "',  
                                `expirationyear` = '" . $this->expirationyear . "',  
                                `status` = '" . esc_sql($this->status) . "',  
                                `gateway` = '" . $this->gateway . "',  
                                `gateway_environment` = '" . $this->gateway_environment . "',  
                                `payment_transaction_id` = '" . esc_sql($this->payment_transaction_id) . "',  
                                `subscription_transaction_id` = '" . esc_sql($this->subscription_transaction_id) . "',  
                                `timestamp` = '" . esc_sql($this->datetime) . "',  
                                `affiliate_id` = '" . esc_sql($this->affiliate_id) . "',  
                                `affiliate_subid` = '" . esc_sql($this->affiliate_subid) . "',  
                                `notes` = '" . esc_sql($this->notes) . "',  
                                `checkout_id` = " . intval($this->checkout_id) . " 
                                WHERE id = '" . $this->id . "' 
                                LIMIT 1"; 
        } 
        else 
        { 
            //set up actions 
            $before_action = "pmpro_add_order"; 
            $after_action = "pmpro_added_order"; 
            //insert 
            $this->sqlQuery = "INSERT INTO $wpdb->pmpro_membership_orders 
                            (`code`, `session_id`, `user_id`, `membership_id`, `paypal_token`, `billing_name`, `billing_street`, `billing_city`, `billing_state`, `billing_zip`, `billing_country`, `billing_phone`, `subtotal`, `tax`, `couponamount`, `certificate_id`, `certificateamount`, `total`, `payment_type`, `cardtype`, `accountnumber`, `expirationmonth`, `expirationyear`, `status`, `gateway`, `gateway_environment`, `payment_transaction_id`, `subscription_transaction_id`, `timestamp`, `affiliate_id`, `affiliate_subid`, `notes`, `checkout_id`) 
                            VALUES('" . $this->code . "',  
                                   '" . session_id() . "',  
                                   " . intval($this->user_id) . ",  
                                   " . intval($this->membership_id) . ",  
                                   '" . $this->paypal_token . "',  
                                   '" . esc_sql(trim($this->billing->name)) . "',  
                                   '" . esc_sql(trim($this->billing->street)) . "',  
                                   '" . esc_sql($this->billing->city) . "',  
                                   '" . esc_sql($this->billing->state) . "',  
                                   '" . esc_sql($this->billing->zip) . "',  
                                   '" . esc_sql($this->billing->country) . "',  
                                   '" . cleanPhone($this->billing->phone) . "',  
                                   '" . $this->subtotal . "',  
                                   '" . $tax . "',  
                                   '" . $this->couponamount. "',  
                                   " . intval($this->certificate_id) . ",  
                                   '" . $this->certificateamount . "',  
                                   '" . $total . "',  
                                   '" . $this->payment_type . "',  
                                   '" . $this->cardtype . "',  
                                   '" . hideCardNumber($this->accountnumber, false) . "',  
                                   '" . substr($this->ExpirationDate, 0, 2) . "',  
                                   '" . substr($this->ExpirationDate, 2, 4) . "',  
                                   '" . esc_sql($this->status) . "',  
                                   '" . $this->gateway . "',  
                                   '" . $this->gateway_environment . "',  
                                   '" . esc_sql($this->payment_transaction_id) . "',  
                                   '" . esc_sql($this->subscription_transaction_id) . "',  
                                   '" . esc_sql($this->datetime) . "',  
                                   '" . esc_sql($this->affiliate_id) . "',  
                                   '" . esc_sql($this->affiliate_subid) . "',  
                                    '" . esc_sql($this->notes) . "',  
                                    " . intval($this->checkout_id) . " 
 )"; 
        } 
 
        do_action($before_action, $this); 
        if($wpdb->query($this->sqlQuery) !== false) 
        { 
            if(empty($this->id)) 
                $this->id = $wpdb->insert_id; 
            do_action($after_action, $this); 
            return $this->getMemberOrderByID($this->id); 
        } 
        else 
        { 
            return false; 
        } 
    } 
 
    /** 
     * Get a random code to use as the order code. 
     */ 
    function getRandomCode() 
    { 
        global $wpdb; 
 
        while(empty($code)) 
        { 
 
            $scramble = md5(AUTH_KEY . current_time('timestamp') . SECURE_AUTH_KEY); 
            $code = substr($scramble, 0, 10); 
            $code = apply_filters("pmpro_random_code", $code, $this);    //filter 
            $check = $wpdb->get_var("SELECT id FROM $wpdb->pmpro_membership_orders WHERE code = '$code' LIMIT 1"); 
            if($check || is_numeric($code)) 
                $code = NULL; 
        } 
 
        return strtoupper($code); 
    } 
 
    /** 
     * Update the status of the order in the database. 
     */ 
    function updateStatus($newstatus) 
    { 
        global $wpdb; 
 
        if(empty($this->id)) 
            return false; 
 
        $this->status = $newstatus; 
        $this->sqlQuery = "UPDATE $wpdb->pmpro_membership_orders SET status = '" . esc_sql($newstatus) . "' WHERE id = '" . $this->id . "' LIMIT 1"; 
        if($wpdb->query($this->sqlQuery) !== false) 
            return true; 
        else 
            return false; 
    } 
 
    /** 
     * Call the process step of the gateway class. 
     */ 
    function process() 
    { 
        if (is_object($this->Gateway)) { 
            return $this->Gateway->process($this); 
        } 
    } 
 
    /** 
     * For offsite gateways with a confirm step. 
     * 
     * @since 1.8 
     */ 
    function confirm() 
    { 
        if (is_object($this->Gateway)) { 
            return $this->Gateway->confirm($this); 
        } 
    } 
 
    /** 
     * Cancel an order and call the cancel step of the gateway class if needed. 
     */ 
    function cancel() 
    { 
        //only need to cancel on the gateway if there is a subscription id 
        if(empty($this->subscription_transaction_id)) 
        { 
            //just mark as cancelled 
            $this->updateStatus("cancelled"); 
            return true; 
        } 
        else 
        { 
            //cancel the gateway subscription first 
            if (is_object($this->Gateway)) { 
                $result = $this->Gateway->cancel( $this ); 
            } else { 
                $result = false; 
            } 
 
            if($result == false) 
            { 
                //there was an error, but cancel the order no matter what 
                $this->updateStatus("cancelled"); 
 
                //we should probably notify the admin 
                $pmproemail = new PMProEmail(); 
                $pmproemail->template = "subscription_cancel_error"; 
                $pmproemail->data = array("body"=>"<p>" . sprintf(__("There was an error canceling the subscription for user with ID=%s. You will want to check your payment gateway to see if their subscription is still active.", 'paid-memberships-pro' ), strval($this->user_id)) . "</p><p>Error: " . $this->error . "</p>"); 
                $pmproemail->data["body"] .= "<p>Associated Order:<br />" . nl2br(var_export($this, true)) . "</p>"; 
                $pmproemail->sendEmail(get_bloginfo("admin_email")); 
 
                return false; 
            } 
            else 
            { 
                //Note: status would have been set to cancelled by the gateway class. So we don't have to update it here. 
 
                //remove billing numbers in pmpro_memberships_users if the membership is still active 
                global $wpdb; 
                $sqlQuery = "UPDATE $wpdb->pmpro_memberships_users SET initial_payment = 0, billing_amount = 0, cycle_number = 0 WHERE user_id = '" . $this->user_id . "' AND membership_id = '" . $this->membership_id . "' AND status = 'active'"; 
                $wpdb->query($sqlQuery); 
 
                return $result; 
            } 
        } 
    } 
 
    /** 
     * Call the update method of the gateway class. 
     */ 
    function updateBilling() 
    { 
        if (is_object($this->Gateway)) { 
            return $this->Gateway->update( $this ); 
        } 
    } 
 
    /** 
     * Call the getSubscriptionStatus method of the gateway class. 
     */ 
    function getGatewaySubscriptionStatus() 
    { 
        if (is_object($this->Gateway)) { 
            return $this->Gateway->getSubscriptionStatus( $this ); 
        } 
    } 
 
    /** 
     * Call the getTransactionStatus method of the gateway class. 
     */ 
    function getGatewayTransactionStatus() 
    { 
        if (is_object($this->Gateway)) { 
            return $this->Gateway->getTransactionStatus( $this ); 
        } 
    } 
 
    /** 
     * Delete an order and associated data. 
     */ 
    function deleteMe() 
    { 
        if(empty($this->id)) 
            return false; 
 
        global $wpdb; 
        $this->sqlQuery = "DELETE FROM $wpdb->pmpro_membership_orders WHERE id = '" . $this->id . "' LIMIT 1"; 
        if($wpdb->query($this->sqlQuery) !== false) 
        { 
            do_action("pmpro_delete_order", $this->id, $this); 
            return true; 
        } 
        else 
            return false; 
    } 
}