1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
<?php
/*
* Provides some helpful functions to deal with the transactions
*/
class SwpmTransactions {
static function save_txn_record($ipn_data, $items = array()) {
global $wpdb;
$current_date = date("Y-m-d");
$custom_var = SwpmTransactions::parse_custom_var($ipn_data['custom']);
$txn_data = array();
$txn_data['email'] = $ipn_data['payer_email'];
$txn_data['first_name'] = $ipn_data['first_name'];
$txn_data['last_name'] = $ipn_data['last_name'];
$txn_data['ip_address'] = $ipn_data['ip'];
$txn_data['member_id'] = $custom_var['swpm_id'];
$txn_data['membership_level'] = $custom_var['subsc_ref'];
$txn_data['txn_date'] = $current_date;
$txn_data['txn_id'] = $ipn_data['txn_id'];
$txn_data['subscr_id'] = $ipn_data['subscr_id'];
$txn_data['reference'] = isset($custom_var['reference'])? $custom_var['reference'] : '';
$txn_data['payment_amount'] = $ipn_data['mc_gross'];
$txn_data['gateway'] = $ipn_data['gateway'];
$txn_data['status'] = $ipn_data['status'];
$txn_data = array_filter($txn_data);//Remove any null values.
$wpdb->insert($wpdb->prefix . "swpm_payments_tbl", $txn_data);
}
static function parse_custom_var($custom) {
$delimiter = "&";
$customvariables = array();
$namevaluecombos = explode($delimiter, $custom);
foreach ($namevaluecombos as $keyval_unparsed) {
$equalsignposition = strpos($keyval_unparsed, '=');
if ($equalsignposition === false) {
$customvariables[$keyval_unparsed] = '';
continue;
}
$key = substr($keyval_unparsed, 0, $equalsignposition);
$value = substr($keyval_unparsed, $equalsignposition + 1);
$customvariables[$key] = $value;
}
return $customvariables;
}
}
|