public function getItem($pk = null) { $id = $pk ? $pk : $this->getState($this->getName() . '.id'); // $item = parent::getItem($id); // if transaction is made and user is not created $transaction = JTable::getInstance('Transaction', 'RSMembershipTable'); $transaction->load($id); /// get the user data $data = $transaction->user_data ? (object) unserialize($transaction->user_data) : (object) array(); if (!$transaction->user_id) { $user = (object) array('id' => 0, 'username' => isset($data->username) && !empty($data->username) ? $data->username : JText::_('COM_RSMEMBERSHIP_SUBSCRIBERNAME_EMPTY'), 'name' => isset($data->name) ? $data->name : '', 'email' => $transaction->user_email); } else { $user = JFactory::getUser($transaction->user_id); } $params = RSMembershipHelper::parseParams($transaction->params); $membership_id = 0; if (isset($params['membership_id'])) { $membership_id = $params['membership_id']; } if (isset($params['to_id'])) { $membership_id = $params['to_id']; } $membership_info = array(); if ($membership_id) { if ($membership_fields = RSMembership::getCustomMembershipFields($membership_id)) { $selected = isset($data->membership_fields) ? $data->membership_fields : array(); foreach ($membership_fields as $field) { $membership_info[] = RSMembershipHelper::showCustomField($field, $selected, false, false, 'membership'); } } } $item = (object) array('user_id' => $user->id, 'username' => $user->username, 'email' => $user->email, 'name' => $user->name, 'transaction' => $id, 'transaction_data' => $transaction, 'membership_info' => $membership_info); return $item; }
<td align="center"><a class="delete-item" onclick="return confirm('<?php echo JText::_('COM_RSMEMBERSHIP_CONFIRM_DELETE'); ?> ')" href="<?php echo JRoute::_('index.php?option=com_rsmembership&task=transactions.remove&cid[]=' . $row->id . '&' . JSession::getFormToken() . '=1&tabposition=2&user_id=' . $this->item->user_id); ?> "><?php echo JHTML::_('image', 'administrator/components/com_rsmembership/assets/images/remove.png', JText::_('Delete')); ?> </a></td> <td><?php echo JText::_('COM_RSMEMBERSHIP_TRANSACTION_' . strtoupper($row->type)); ?> </td> <td><?php $params = RSMembershipHelper::parseParams($row->params); switch ($row->type) { case 'new': if (!empty($params['membership_id'])) { echo $this->cache->memberships[$params['membership_id']]; } if (!empty($params['extras'])) { foreach ($params['extras'] as $extra) { if (!empty($extra)) { echo '<br />- ' . $this->cache->extra_values[$extra]; } } } break; case 'upgrade': if (!empty($params['from_id']) && !empty($params['to_id'])) {
protected function getMembershipId($params, $type) { $params = RSMembershipHelper::parseParams($params); switch ($type) { case 'new': case 'renew': $membership_id = $params['membership_id']; break; case 'addextra': JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_rsmembership/tables'); // Verify if the subscription still exists $current = JTable::getInstance('Membership_Subscriber', 'RSMembershipTable'); if (!$current->load($params['id'])) { return false; } // Check if this membership still exists $membership = JTable::getInstance('Membership', 'RSMembershipTable'); if (!$membership->load($current->membership_id)) { return false; } $membership_id = $current->membership_id; break; case 'upgrade': JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_rsmembership/tables'); $membership = JTable::getInstance('Membership', 'RSMembershipTable'); if (!$membership->load($params['to_id'])) { return false; } $membership_id = $membership->membership_id; break; } return $membership_id; }
function onAfterRoute() { $app =& JFactory::getApplication(); if ($app->isAdmin()) { return; } if (JRequest::getVar('authorizepayment')) { return $this->onPaymentNotification(); } $option = JRequest::getVar('option'); $task = JRequest::getCmd('plugin_task'); $membership_id = JRequest::getInt('membership_id'); if ($option == 'com_rsmembership' && $task == 'authorize') { @ob_end_clean(); $db =& JFactory::getDBO(); $db->setQuery("SELECT * FROM #__rsmembership_memberships WHERE `id`='" . $membership_id . "'"); $membership = $db->loadObject(); JTable::addIncludePath(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_rsmembership' . DS . 'tables'); $row =& JTable::getInstance('RSMembership_Transactions', 'Table'); $transaction = $this->getDelayedTransaction(); if (empty($transaction)) { $app->enqueueMessage('RSM_SESSION_EXPIRED', 'error'); echo 'RSM_SESSION_END'; die; } $row->bind($transaction); $row->store(); $row->price += $this->_getTax($row->price); $row->price = $this->_convertNumber($row->price); $transaction['id'] = $row->id; $this->delayTransactionStoring($transaction); $description = $this->_params->get('message_type') ? $membership->name : JText::sprintf('RSM_MEMBERSHIP_PURCHASE_ON', date(RSMembershipHelper::getConfig('date_format'), $row->date)); $post_url = $this->_params->get('mode') ? "https://secure.authorize.net/gateway/transact.dll" : "https://test.authorize.net/gateway/transact.dll"; $is_recurring = $membership->recurring && $membership->period > 0 && $row->type == 'new'; $cc_number = JRequest::getCmd('cc_number', '', 'post'); $cc_expiration = substr(JRequest::getCmd('cc_exp_mm', '', 'post'), 0, 2) . '-' . JRequest::getInt('cc_exp_yy', 0, 'post'); $cc_fname = JRequest::getVar('cc_fname', '', 'post'); $cc_lname = JRequest::getVar('cc_lname', '', 'post'); $post_values = array("x_login" => $this->_params->get('x_login'), "x_tran_key" => $this->_params->get('x_tran_key'), "x_version" => "3.1", "x_delim_data" => "TRUE", "x_delim_char" => "|", "x_relay_response" => "FALSE", "x_type" => "AUTH_CAPTURE", "x_method" => "CC", "x_card_num" => $cc_number, "x_exp_date" => $cc_expiration, "x_card_code" => JRequest::getVar('csc_number', '', 'post'), "x_amount" => $row->price, "x_currency_code" => RSMembershipHelper::getConfig('currency'), "x_invoice_num" => md5($row->id . ' ' . $this->_params->get('x_login') . ' ' . $this->_params->get('x_tran_key')), "x_description" => $description, "x_first_name" => $cc_fname, "x_last_name" => $cc_lname, "x_email" => $row->get('user_email'), "x_address" => '', "x_state" => '', "x_zip" => ''); $string = ''; foreach ($post_values as $key => $value) { $string .= "{$key}=" . urlencode($value) . "&"; } $string = rtrim($string, "& "); unset($post_values); if (!function_exists('curl_init')) { echo JHTML::image('plugins/system/' . $this->joomla16prefix . 'rsmembershipauthorize/images/error.png', 'Error', array('id' => 'rsm_warning')) . ' ' . JText::_('RSM_AUTHORIZE_CURL_ERROR'); } else { $request = curl_init($post_url); curl_setopt($request, CURLOPT_HEADER, 0); curl_setopt($request, CURLOPT_RETURNTRANSFER, 1); curl_setopt($request, CURLOPT_POSTFIELDS, $string); curl_setopt($request, CURLOPT_SSL_VERIFYPEER, FALSE); $response = curl_exec($request); curl_close($request); // close curl object // This line takes the response and breaks it into an array using the specified delimiting character $response = explode('|', $response); if ($response[0] == 1) { if (!$is_recurring) { $this->emptyDelayedTransaction(); $row->hash = $response[6]; $row->store(); RSMembership::finalize($row->get('id')); RSMembership::approve($row->get('id')); } else { list($length, $unit) = $this->_getAuthorizeLength($membership); $date =& JFactory::getDate(); $startDate = date('Y-m-d', strtotime("+{$length} {$unit}", $date->toUnix())); $extra_total = 0; $params = RSMembershipHelper::parseParams($row->params); if (!empty($params['extras'])) { $db->setQuery("SELECT SUM(`price`) FROM #__rsmembership_extra_values WHERE `id` IN (" . implode(',', $params['extras']) . ")"); $extra_total = $db->loadResult(); } $amount = $membership->use_renewal_price ? $membership->renewal_price : $membership->price; $amount += $extra_total; $amount += $this->_getTax($amount); $trialOccurrences = $membership->use_trial_period ? 1 : 0; $trialAmount = $membership->use_trial_period ? $membership->trial_price : 0; $trialAmount += $extra_total; $trialAmount += $this->_getTax($trialAmount); $content = "<?xml version=\"1.0\" encoding=\"utf-8\"?>" . "<ARBCreateSubscriptionRequest xmlns=\"AnetApi/xml/v1/schema/AnetApiSchema.xsd\">" . "<merchantAuthentication>" . "<name>" . $this->_params->get('x_login') . "</name>" . "<transactionKey>" . $this->_params->get('x_tran_key') . "</transactionKey>" . "</merchantAuthentication>" . "<refId>" . $row->id . "</refId>" . "<subscription>" . "<name>" . htmlentities($description, ENT_COMPAT, 'UTF-8') . "</name>" . "<paymentSchedule>" . "<interval>" . "<length>" . $length . "</length>" . "<unit>" . $unit . "</unit>" . "</interval>" . "<startDate>" . $startDate . "</startDate>" . "<totalOccurrences>9999</totalOccurrences>" . "<trialOccurrences>" . $trialOccurrences . "</trialOccurrences>" . "</paymentSchedule>" . "<amount>" . $amount . "</amount>" . "<trialAmount>" . $trialAmount . "</trialAmount>" . "<payment>" . "<creditCard>" . "<cardNumber>" . $cc_number . "</cardNumber>" . "<expirationDate>" . $cc_expiration . "</expirationDate>" . "</creditCard>" . "</payment>" . "<billTo>" . "<firstName>" . $cc_fname . "</firstName>" . "<lastName>" . $cc_lname . "</lastName>" . "</billTo>" . "</subscription>" . "</ARBCreateSubscriptionRequest>"; $post_url = $this->_params->get('mode') ? "https://api.authorize.net/xml/v1/request.api" : "https://apitest.authorize.net/xml/v1/request.api"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $post_url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: text/xml")); curl_setopt($ch, CURLOPT_HEADER, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $content); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); $response = curl_exec($ch); if ($response) { list($refId, $resultCode, $code, $text, $subscriptionId) = $this->_parseReturn($response); if ($resultCode == 1) { $this->emptyDelayedTransaction(); $row->custom = $subscriptionId; $row->store(); RSMembership::finalize($row->get('id')); RSMembership::approve($row->get('id')); } else { $image = $resultCode == 4 ? 'warning' : 'error'; if (!$text) { $text = explode("\r\n\r\n", $response, 2); $text = strip_tags($text[1]); } echo JHTML::image('plugins/system/' . $this->joomla16prefix . 'rsmembershipauthorize/images/' . $image . '.png', 'Information', array('id' => 'rsm_warning')) . ' ' . htmlentities($text, ENT_COMPAT, 'UTF-8'); die; } } else { echo JHTML::image('plugins/system/' . $this->joomla16prefix . 'rsmembershipauthorize/images/error.png', 'Error') . ' ' . JText::_('RSM_AUTHORIZE_GENERAL_ERROR'); die; } } echo 'RSM_AUTHORIZE_OK'; } else { $image = $response[0] == 4 ? 'warning' : 'error'; echo JHTML::image('plugins/system/' . $this->joomla16prefix . 'rsmembershipauthorize/images/' . $image . '.png', 'Information', array('id' => 'rsm_warning')) . ' ' . htmlentities($response[3], ENT_COMPAT, 'UTF-8'); } } die; } }
echo JText::_('COM_RSMEMBERSHIP_TYPE'); ?> </td> <td><?php echo JText::_('COM_RSMEMBERSHIP_TRANSACTION_' . strtoupper($this->item->transaction_data->type)); ?> </td> </tr> <tr> <td width="200"><?php echo JText::_('COM_RSMEMBERSHIP_DETAILS'); ?> </td> <td> <?php $params = RSMembershipHelper::parseParams($this->item->transaction_data->params); switch ($this->item->transaction_data->type) { case 'new': if (!empty($params['membership_id'])) { echo isset($this->cache->memberships[$params['membership_id']]) ? $this->cache->memberships[$params['membership_id']] : JText::_('COM_RSMEMBERSHIP_COULD_NOT_FIND_MEMBERSHIP'); } if (!empty($params['extras'])) { foreach ($params['extras'] as $extra) { if (!empty($extra)) { echo '<br />- ' . $this->cache->extra_values[$extra]; } } } break; case 'upgrade': if (!empty($params['from_id']) && !empty($params['to_id'])) {
public static function deny($transaction_id, $force = false) { JTable::addIncludePath(JPATH_ADMINISTRATOR . '/components/com_rsmembership/tables'); $db = JFactory::getDBO(); $query = $db->getQuery(true); // Load the transaction $query->select($db->qn('id'))->from($db->qn('#__rsmembership_transactions'))->where($db->qn('id') . '=' . $db->q($transaction_id)); if (!$force) { $query->where($db->qn('status') . ' != ' . $db->q('denied')); } $db->setQuery($query); if ($id = $db->loadResult()) { $transaction = JTable::getInstance('Transaction', 'RSMembershipTable'); $transaction->load($id); } else { return false; } // Set the transaction to 'denied' $updateTransaction = JTable::getInstance('Transaction', 'RSMembershipTable'); $updateTransaction->save(array('id' => $transaction->id, 'status' => 'denied')); $params = RSMembershipHelper::parseParams($transaction->params); $membership_id = false; switch ($transaction->type) { case 'renew': case 'new': if (!empty($params['membership_id'])) { $membership_id = $params['membership_id']; } break; case 'upgrade': if (!empty($params['to_id'])) { $membership_id = $params['to_id']; } break; case 'addextra': if (!empty($params['id'])) { $query->clear(); $query->select($db->qn('membership_id'))->from($db->qn('#__rsmembership_membership_subscribers'))->where($db->qn('id') . ' = ' . $db->q((int) $params['id'])); $db->setQuery($query); $membership_id = $db->loadResult(); } break; } // start sending emails if ($membership_id) { $query->clear(); $query->select('*')->from($db->qn('#__rsmembership_memberships'))->where($db->qn('id') . ' = ' . $db->q((int) $membership_id) . ' AND ( ' . $db->qn('user_email_denied_subject') . ' != ' . $db->q('') . ' OR ' . $db->qn('admin_email_denied_subject') . ' != ' . $db->q('') . ' )'); $db->setQuery($query); if ($membership = $db->loadObject()) { $jconfig = JFactory::getConfig(); $membership->user_email_from_addr = $membership->user_email_use_global ? $jconfig->get('mailfrom') : $membership->user_email_from_addr; $membership->user_email_from = $membership->user_email_use_global ? $jconfig->get('fromname') : $membership->user_email_from; $userEmail = array('from' => '', 'fromName' => '', 'recipient' => '', 'subject' => '', 'body' => '', 'mode' => '', 'cc' => '', 'bcc' => '', 'attachments' => '', 'replyto' => '', 'replytoname' => ''); $adminEmail = array('from' => '', 'fromName' => '', 'recipient' => '', 'subject' => '', 'body' => '', 'mode' => '', 'cc' => '', 'bcc' => '', 'attachments' => '', 'replyto' => '', 'replytoname' => ''); // placeholders $user_data = unserialize($transaction->user_data); $user_email = $transaction->user_email; $replacements = array('{membership}' => $membership->name, '{email}' => $user_email, '{name}' => $user_data->name, '{username}' => isset($user_data->username) ? $user_data->username : '', '{price}' => RSMembershipHelper::getPriceFormat($transaction->price), '{coupon}' => $transaction->coupon, '{payment}' => $transaction->gateway, '{transaction_id}' => $transaction->id); $replace = array_keys($replacements); $with = array_values($replacements); $fields = RSMembership::getCustomFields(); $membership_fields = RSMembership::getCustomMembershipFields($membership_id); $all_fields = array_merge($fields, $membership_fields); foreach ($all_fields as $field) { $name = $field->name; $replace[] = '{' . $name . '}'; $object = isset($user_data->fields[$name]) ? 'fields' : 'membership_fields'; if (isset($user_data->fields[$name]) || isset($user_data->membership_fields[$name])) { $with[] = is_array($user_data->{$object}[$name]) ? implode("\n", $user_data->{$object}[$name]) : $user_data->{$object}[$name]; } else { $with[] = ''; } } // user emails if (!empty($membership->user_email_from_addr) && $membership->user_email_denied_subject != '') { // start sending emails // from address $userEmail['from'] = $membership->user_email_from_addr; // from name $userEmail['fromName'] = $membership->user_email_from; // recipient $userEmail['recipient'] = $user_email; // user email // subject $userEmail['subject'] = str_replace($replace, $with, $membership->user_email_denied_subject); // body $userEmail['body'] = str_replace($replace, $with, $membership->user_email_denied_text); // mode $userEmail['mode'] = $membership->user_email_mode; // cc $userEmail['cc'] = null; // bcc $userEmail['bcc'] = null; // attachments $userEmail['attachments'] = null; // reply to $userEmail['replyto'] = $userEmail['from']; // reply to name $userEmail['replytoname'] = $userEmail['fromName']; } // admin emails if (!empty($membership->admin_email_to_addr) && $membership->admin_email_denied_subject != '') { // from address $adminEmail['from'] = trim($membership->admin_email_from_addr) != '' ? $membership->admin_email_from_addr : $user_email; // from name $adminEmail['fromName'] = $user_data->name; // recipient $adminEmail['recipient'] = $membership->admin_email_to_addr; // subject $adminEmail['subject'] = str_replace($replace, $with, $membership->admin_email_denied_subject); // body $adminEmail['body'] = str_replace($replace, $with, $membership->admin_email_denied_text); // mode $adminEmail['mode'] = $membership->admin_email_mode; // cc $adminEmail['cc'] = null; // bcc $adminEmail['bcc'] = null; // attachments $adminEmail['attachments'] = null; // reply to $adminEmail['replyto'] = $adminEmail['from']; // reply to name $adminEmail['replytoname'] = $adminEmail['fromName']; } // send to user if (!empty($membership->user_email_from_addr) && $membership->user_email_denied_subject != '') { RSMembershipHelper::sendMail($userEmail['from'], $userEmail['fromName'], $userEmail['recipient'], $userEmail['subject'], $userEmail['body'], $userEmail['mode'], $userEmail['cc'], $userEmail['bcc'], $userEmail['attachments'], $userEmail['replyto'], $userEmail['replytoname']); } // send to admin if (!empty($membership->admin_email_to_addr) && !empty($membership->admin_email_denied_subject)) { RSMembershipHelper::sendMail($adminEmail['from'], $adminEmail['fromName'], $adminEmail['recipient'], $adminEmail['subject'], $adminEmail['body'], $adminEmail['mode'], $adminEmail['cc'], $adminEmail['bcc'], $adminEmail['attachments'], $adminEmail['replyto'], $adminEmail['replytoname']); } } } return true; }
function approve($transaction_id, $force = false) { $db =& JFactory::getDBO(); $db->setQuery("SELECT * FROM #__rsmembership_transactions WHERE `id`='" . (int) $transaction_id . "'" . ($force ? "" : " AND `status`!='completed'")); $transaction = $db->loadObject(); if (empty($transaction->id)) { return false; } $params = RSMembershipHelper::parseParams($transaction->params); JTable::addIncludePath(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_rsmembership' . DS . 'tables'); $row =& JTable::getInstance('RSMembership_Membership_Users', 'Table'); $row->user_id = $transaction->user_id; if (!RSMembershipHelper::getConfig('create_user_instantly') || $row->user_id == 0) { $row->user_id = RSMembership::createUser($transaction->user_email, unserialize($transaction->user_data)); $db->setQuery("UPDATE #__rsmembership_transactions SET `user_id`='" . $row->user_id . "' WHERE `id`='" . $transaction->id . "'"); $db->query(); } $row->price = $transaction->price; $row->currency = $transaction->currency; $idev_enabled = RSMembershipHelper::getConfig('idev_enable'); $idev_track_renewals = RSMembershipHelper::getConfig('idev_track_renewals'); $update_gid = false; $update_user = false; $update_idev = false; $update_rsmail = false; $date = JFactory::getDate(); switch ($transaction->type) { case 'new': $row->membership_id = $params['membership_id']; $db->setQuery("SELECT * FROM #__rsmembership_memberships WHERE `id`='" . (int) $row->membership_id . "'"); $membership = $db->loadObject(); if (empty($membership)) { JError::raiseWarning(500, JText::_('RSM_COULD_NOT_APPROVE_TRANSACTION')); return false; } if ($membership->gid_enable) { $update_gid = true; } if ($membership->disable_expired_account) { $update_user = true; } $row->membership_start = $date->toUnix(); if ($membership->use_trial_period) { $membership->period = $membership->trial_period; $membership->period_type = $membership->trial_period_type; } if ($membership->fixed_expiry) { $row->membership_end = RSMembershipHelper::calculateFixedDate($membership); } else { if ($membership->period > 0) { switch ($membership->period_type) { case 'h': $offset = $membership->period * 3600; break; case 'd': $offset = $membership->period * 86400; break; case 'm': $offset = strtotime('+' . $membership->period . ' months', $row->membership_start) - $row->membership_start; break; case 'y': $offset = strtotime('+' . $membership->period . ' years', $row->membership_start) - $row->membership_start; break; } $row->membership_end = $date->toUnix() + $offset; } else { $row->membership_end = 0; } } if (!empty($params['extras'])) { $row->extras = implode(',', $params['extras']); } $row->status = 0; $row->from_transaction_id = $transaction->id; $row->last_transaction_id = $transaction->id; $row->store(); $return = $row->id; // iDev Integration if ($idev_enabled) { $update_idev = true; } $update_rsmail = $membership->id; break; case 'addextra': $db->setQuery("SELECT `extras` FROM #__rsmembership_membership_users WHERE `id`='" . (int) $params['id'] . "'"); $extras = $db->loadResult(); $extras = explode(',', $extras); if (empty($extras[0])) { $extras = $params['extras']; } else { $extras = array_merge($extras, $params['extras']); } $db->setQuery("UPDATE #__rsmembership_membership_users SET `extras`='" . implode(',', $extras) . "' WHERE `id`='" . (int) $params['id'] . "'"); $db->query(); $return = $params['id']; break; case 'upgrade': // Get the upgraded membership $db->setQuery("SELECT * FROM #__rsmembership_memberships WHERE `id`='" . (int) $params['to_id'] . "'"); $membership = $db->loadObject(); // Get the current membership $db->setQuery("SELECT * FROM #__rsmembership_membership_users WHERE `id`='" . (int) $params['id'] . "'"); $current = $db->loadObject(); $db->setQuery("SELECT * FROM #__rsmembership_memberships WHERE `id`='" . $current->membership_id . "'"); $old_membership = $db->loadObject(); $db->setQuery("UPDATE #__rsmembership_membership_users SET `membership_id`='" . (int) $params['to_id'] . "' WHERE `id`='" . (int) $params['id'] . "'"); $db->query(); $new_price = ''; $db->setQuery("SELECT price FROM #__rsmembership_membership_upgrades WHERE `membership_from_id`='" . (int) $old_membership->id . "' AND `membership_to_id`='" . (int) $membership->id . "' AND `published`='1'"); $upgrade = $db->loadResult(); if ($upgrade) { $new_price = ", `price`='" . $db->getEscaped($current->price + $upgrade) . "'"; } if ($membership->fixed_expiry) { $membership_end = RSMembershipHelper::calculateFixedDate($membership); $status = ''; if ($membership_end > $date->toUnix()) { $status = ", `status`='0', `notified`='0'"; } $db->setQuery("UPDATE #__rsmembership_membership_users SET membership_end = '" . $membership_end . "' {$status} {$new_price} WHERE `id`='" . (int) $params['id'] . "'"); $db->query(); } else { if ($membership->period == 0) { $db->setQuery("UPDATE #__rsmembership_membership_users SET `membership_end`='0', `status`='0', `notified`='0' {$new_price} WHERE `id`='" . (int) $params['id'] . "'"); $db->query(); } elseif ($membership->period > 0) { switch ($membership->period_type) { case 'h': $offset = $membership->period * 3600; break; case 'd': $offset = $membership->period * 86400; break; case 'm': $offset = strtotime('+' . $membership->period . ' months', $current->membership_start) - $current->membership_start; break; case 'y': $offset = strtotime('+' . $membership->period . ' years', $current->membership_start) - $current->membership_start; break; } // $membership_end = $current->membership_start + $offset; // FDS replaced the above line with the one below. This sets the membership expiration date to now + offset. $membership_end = $date->toUnix() + $offset; $status = ''; if ($membership_end > $date->toUnix()) { $status = ", `status`='0', `notified`='0'"; } $db->setQuery("UPDATE #__rsmembership_membership_users SET membership_end = '" . $membership_end . "' {$status} {$new_price} WHERE `id`='" . (int) $params['id'] . "'"); $db->query(); } } // the last transaction $db->setQuery("UPDATE #__rsmembership_membership_users SET `last_transaction_id`='" . $transaction->id . "' WHERE `id`='" . (int) $params['id'] . "'"); $db->query(); if ($membership->gid_enable) { $update_gid = true; } if ($membership->disable_expired_account) { $update_user = true; } $update_rsmail = $membership->id; $return = $params['id']; break; case 'renew': $row->membership_id = $params['membership_id']; $db->setQuery("SELECT * FROM #__rsmembership_memberships WHERE `id`='" . (int) $row->membership_id . "'"); $membership = $db->loadObject(); $membership_start = $date->toUnix(); if ($membership->fixed_expiry) { $membership_end = RSMembershipHelper::calculateFixedDate($membership); } else { // Renew when not expired ? $db->setQuery("SELECT * FROM #__rsmembership_membership_users WHERE `id`='" . (int) $params['id'] . "'"); $current = $db->loadObject(); if ($current->status == 0) { $membership_start = $current->membership_end; } if ($membership->period > 0) { switch ($membership->period_type) { case 'h': $offset = $membership->period * 3600; break; case 'd': $offset = $membership->period * 86400; break; case 'm': $offset = strtotime('+' . $membership->period . ' months', $membership_start) - $membership_start; break; case 'y': $offset = strtotime('+' . $membership->period . ' years', $membership_start) - $membership_start; break; } $membership_end = $membership_start + $offset; } else { $membership_end = 0; } if ($current->status == 0) { $membership_start = $current->membership_start; } } $db->setQuery("UPDATE #__rsmembership_membership_users SET `membership_start`='" . $membership_start . "', `membership_end`='" . $membership_end . "',`price`='" . $db->getEscaped($row->price) . "', `status`='0', `notified`='0' WHERE `id`='" . (int) $params['id'] . "'"); $db->query(); // the last transaction $db->setQuery("UPDATE #__rsmembership_membership_users SET `last_transaction_id`='" . $transaction->id . "' WHERE `id`='" . (int) $params['id'] . "'"); $db->query(); if ($membership->gid_enable) { $update_gid = true; } if ($membership->disable_expired_account) { $update_user = true; } $return = $params['id']; // iDev Integration if ($idev_enabled && $idev_track_renewals) { $update_idev = true; } break; } if ($update_gid) { RSMembership::updateGid($row->user_id, $membership->gid_subscribe, true); } if ($update_user) { RSMembership::enableUser($row->user_id); } $db->setQuery("UPDATE #__rsmembership_transactions SET `status`='completed' WHERE `id`='" . $transaction->id . "'"); $db->query(); $user_data = unserialize($transaction->user_data); $user_email = $transaction->user_email; $replace = array('{membership}', '{email}', '{username}', '{name}'); $with = array($membership->name, $user_email, isset($user_data->username) ? $user_data->username : '', $user_data->name); $db->setQuery("SELECT * FROM #__rsmembership_fields WHERE published='1'"); $fields = $db->loadObjectList(); foreach ($fields as $field) { $name = $field->name; $replace[] = '{' . $name . '}'; if (isset($user_data->fields[$name])) { $with[] = is_array($user_data->fields[$name]) ? implode("\n", $user_data->fields[$name]) : $user_data->fields[$name]; } else { $with[] = ''; } } if ($update_rsmail) { RSMembership::addToRSMail($update_rsmail, $row->user_id, $user_email, $user_data); } $userEmail = array('from' => '', 'fromName' => '', 'recipient' => '', 'subject' => '', 'body' => '', 'mode' => '', 'cc' => '', 'bcc' => '', 'attachments' => '', 'replyto' => '', 'replytoname' => ''); $adminEmail = array('from' => '', 'fromName' => '', 'recipient' => '', 'subject' => '', 'body' => '', 'mode' => '', 'cc' => '', 'bcc' => '', 'attachments' => '', 'replyto' => '', 'replytoname' => ''); $jconfig = JFactory::getConfig(); $membership->user_email_from_addr = $membership->user_email_use_global ? $jconfig->getValue('config.mailfrom') : $membership->user_email_from_addr; $membership->user_email_from = $membership->user_email_use_global ? $jconfig->getValue('config.fromname') : $membership->user_email_from; if (!empty($membership->user_email_from_addr) && $membership->user_email_approved_subject != '') { // start sending emails // from address $userEmail['from'] = $membership->user_email_from_addr; // from name $userEmail['fromName'] = $membership->user_email_from; // recipient $userEmail['recipient'] = $user_email; // user email // subject $userEmail['subject'] = str_replace($replace, $with, $membership->user_email_approved_subject); // body $userEmail['body'] = str_replace($replace, $with, $membership->user_email_approved_text); // mode $userEmail['mode'] = $membership->user_email_mode; // cc $userEmail['cc'] = null; // bcc $userEmail['bcc'] = null; // attachments $db->setQuery("SELECT `path` FROM #__rsmembership_membership_attachments WHERE `membership_id`='" . $membership->id . "' AND `email_type`='user_email_approved' AND `published`='1' ORDER BY `ordering`"); $userEmail['attachments'] = $db->loadResultArray(); // reply to $userEmail['replyto'] = $userEmail['from']; // reply to name $userEmail['replytoname'] = $userEmail['fromName']; } // admin emails if (!empty($membership->admin_email_to_addr) && $membership->admin_email_approved_subject != '') { // from address $adminEmail['from'] = $user_email; // from name $adminEmail['fromName'] = $user_data->name; // recipient $adminEmail['recipient'] = $membership->admin_email_to_addr; // subject $adminEmail['subject'] = str_replace($replace, $with, $membership->admin_email_approved_subject); // body $adminEmail['body'] = str_replace($replace, $with, $membership->admin_email_approved_text); // mode $adminEmail['mode'] = $membership->admin_email_mode; // cc $adminEmail['cc'] = null; // bcc $adminEmail['bcc'] = null; // attachments $adminEmail['attachments'] = null; // reply to $adminEmail['replyto'] = $adminEmail['from']; // reply to name $adminEmail['replytoname'] = $adminEmail['fromName']; } // run php code eval($membership->custom_code_transaction); // send to user if (!empty($membership->user_email_from_addr) && $membership->user_email_approved_subject != '') { RSMembershipHelper::sendMail($userEmail['from'], $userEmail['fromName'], $userEmail['recipient'], $userEmail['subject'], $userEmail['body'], $userEmail['mode'], $userEmail['cc'], $userEmail['bcc'], $userEmail['attachments'], $userEmail['replyto'], $userEmail['replytoname']); } // send to admin if (!empty($membership->admin_email_to_addr) && !empty($membership->admin_email_approved_subject)) { RSMembershipHelper::sendMail($adminEmail['from'], $adminEmail['fromName'], $adminEmail['recipient'], $adminEmail['subject'], $adminEmail['body'], $adminEmail['mode'], $adminEmail['cc'], $adminEmail['bcc'], $adminEmail['attachments'], $adminEmail['replyto'], $adminEmail['replytoname']); } // process stock if ($membership->stock > 0) { // decrease stock if ($membership->stock > 1) { $db->setQuery("UPDATE #__rsmembership_memberships SET `stock`=`stock`-1 WHERE `id`='" . $membership->id . "'"); } else { $db->setQuery("UPDATE #__rsmembership_memberships SET `stock`='-1' WHERE `id`='" . $membership->id . "'"); } $db->query(); } if ($update_idev) { RSMembership::updateIdev(array('idev_saleamt' => $transaction->price, 'idev_ordernum' => $transaction->id, 'ip_address' => $transaction->ip)); } // should return the newly created/updated membership id return $return; }