/** * @deprecated */ function _fetch_merchant_txn_id_old(&$member, $force = false) { if (!isset($member->payment_info->txn_id) || empty($member->payment_info->txn_id)) { // check from transaction table $authorizenet_transaction_id = mgm_get_transaction_option($member->transaction_id, 'authorizenet_transaction_id'); if ((int) $authorizenet_transaction_id > 0) { // set $member->payment_info->txn_id = $authorizenet_transaction_id; // log // mgm_log('fetch from transaction option: '. $member->payment_info->txn_id, __FUNCTION__); // save return $member->save(); } else { // // fetch from batch, @todo test before running $authorizenet_transaction_id = mgm_fetch_authorizenet_missing_txn_id($this, $member->id); if ((int) $authorizenet_transaction_id > 0) { // set $member->payment_info->txn_id = $authorizenet_transaction_id; // log // mgm_log('fetch from refetch using batch api: '. $member->payment_info->txn_id, __FUNCTION__); // save return $member->save(); } } } }
/** * update transactions missing data */ function mgm_update_transaction_data() { // db global $wpdb; // // sql $sql = "SELECT id,user_id,module,data,transaction_dt FROM `" . TBL_MGM_TRANSACTION . "` \r\r\n\t WHERE 1 AND (`user_id` IS NULL OR `user_id` = 0) AND module IS NOT NULL LIMIT 0, 50"; // check missing user_id if ($transactions = $wpdb->get_results($sql)) { // log // mgm_log($transactions, __FUNCTION__); // loop foreach ($transactions as $transaction) { // pack $pack = json_decode($transaction->data, true); // check if (isset($pack['user_id']) && (int) $pack['user_id'] > 0) { // id $user_id = $pack['user_id']; // update $wpdb->update(TBL_MGM_TRANSACTION, array('user_id' => $user_id), array('id' => $transaction->id)); // log mgm_log($wpdb->last_query, __FUNCTION__); } } } // authorizenet module $authorizenet = mgm_get_module('authorizenet', 'payment'); // if active if ($authorizenet->is_enabled()) { // fetch module transactions // mgm_log('Enabled', __FUNCTION__); // 1699,1700,1711,1712,1714,1716,1718,1721,1725,1734,1735,1724,1722 mgm_fetch_authorizenet_missing_txn_id($authorizenet); } }