public static function cancel($params) { $db = oseDB::instance(); $result = array(); $result['success'] = true; if (empty($params['allow_work'])) { $result['success'] = false; $result['title'] = 'Error'; $result['content'] = JText::_("Error"); return $result; } unset($params['allow_work']); if (empty($params['master'])) { $result['success'] = true; $result['title'] = 'Error'; $result['content'] = JText::_("Error"); return $result; } unset($params['allow_work']); $tmpl_var_instant = true; $msc_id = $db->Quote($params['msc_id']); $member_id = $db->Quote($params['member_id']); if ($tmpl_var_instant) { $query = " UPDATE `#__osemsc_member` " . " SET expired_date = " . $db->Quote(oseHtml::getDateTime()) . " WHERE msc_id = {$msc_id} AND member_id = {$member_id}"; $db->setQuery($query); if (!oseDB::query()) { $result['success'] = false; $result['title'] = 'Error'; $result['content'] = JText::_("Cancel Msc Error"); } } return $result; }
function AuthorizeARBCreateProfile($orderInfo, $credit_info, $params = array()) { ini_set('max_execution_time', '180'); // Test if the User's credit card has enough funding, if so, void the order; $result = self::AuthorizeAIMPay($orderInfo, $credit_info, $params, $TransactionType = 'AUTH_ONLY'); if ($result['isApproved'] == true) { $voidResult = self::AuthorizeAIMVoid($result['TransactionID']); if ($voidResult['isApproved'] == false) { return self::getErrorMessage('cc', '0000', $voidResult['ResponseText']); } } else { return self::getErrorMessage('cc', '0000', $result['content']); } // Now proceed the Recurring payment plan creation; $db = oseDB::instance(); $result = array(); $user_id = $orderInfo->user_id; $msc_id = $orderInfo->entry_id; $order_id = $orderInfo->order_id; $order_number = $orderInfo->order_number; $orderInfoParams = oseJson::decode($orderInfo->params); // Get User billing information; $desc = $this->generateDesc($order_id); //$node= oseRegistry :: call('msc')->getInfo($msc_id, 'obj'); $billingInfo = $this->getBillingInfo($orderInfo->user_id); // Payments /* $payment= oseMscAddon :: getExtInfo($orderInfo->entry_id, 'payment', 'obj'); if(isset($params['msc_option'])) { $msc_option = $params['msc_option']; unset($params['msc_option']); } $payment = oseObject::getValue($payment,$msc_option); */ $taxRate = isset($orderInfoParams->tax_rate) ? $orderInfoParams->tax_rate : 0; // Reference ID; $refID = substr($order_number, 0, 19) . "A"; $invoice = substr($order_number, 0, 19) . "A"; $name = "MEM{$msc_id}UID{$user_id}_" . date("Ymdhis"); $taxRate = $payment->tax_rate; // Credit Card Informaiton; $creditcard = $credit_info["creditcard_number"]; $cardCode = $credit_info["creditcard_cvv"]; $expiration = $credit_info["creditcard_expirationdate"]; $expiration = strval($expiration); // Recurring payment setting; $msc = oseRegistry::call('msc'); $ext = $orderInfoParams; //msc->getExtInfo($msc_id, 'payment', 'obj'); $mscRegRecurrence = $this->AuthorizeAPITransInterval($orderInfoParams->t3, $orderInfoParams->p3); $total = $orderInfoParams->next_total; //round($orderInfoParams->a3 * (1+$taxRate), 2); $totalOccurrences = 9999; // Check if Price is set correctly; if (empty($total)) { return self::getErrorMessage('cc', '0002'); } // Trial payment setting; $trialOccurrences = !empty($orderInfoParams->next_price) ? "1" : "0"; if ($ext->has_trial) { $mscTrialRecurrence = $this->AuthorizeAPITransInterval($orderInfoParams->t1, $orderInfoParams->p1); if ($ext->total > 0) { $result = self::AuthorizeAIMPay($orderInfo, $credit_info, $params, $TransactionType = 'AUTH_CAPTURE', true); if ($result['isApproved'] == false) { return self::getErrorMessage('cc', '0000', $result['content']); } } $startDate = date("Y-m-d", strtotime("+ {$mscTrialRecurrence['length']} {$mscTrialRecurrence['unit']}")); } else { jimport('joomla.utilities.date'); $curDate = date_create(oseHtml::getDateTime()); $startDate = date_format($curDate, "Y-m-d"); } //oseExit($startDate); require_once JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_osemsc' . DS . 'libraries' . DS . 'AuthnetARB.class.php'; $config = oseMscConfig::getConfig('payment', 'obj'); $test_mode = $config->cc_testmode; $arbsubdomain = $test_mode ? 'apitest' : 'api'; $arb = new AuthnetARB(); $arb->url = $arbsubdomain . ".authorize.net"; $arb->setParameter('startDate', $startDate); $arb->setParameter('interval_length', $mscRegRecurrence['length']); $arb->setParameter('interval_unit', $mscRegRecurrence['unit']); $arb->setParameter('totalOccurrences', 9999); $arb->setParameter('amount', $total); $arb->setParameter('trialOccurrences', 0); $arb->setParameter('trialAmount', 0.0); $arb->setParameter('orderInvoiceNumber', $refID); $arb->setParameter('orderDescription', $desc); $arb->setParameter('customerId', $user_id); $arb->setParameter('customerEmail', $billingInfo->email); $arb->setParameter('customerPhoneNumber', substr($billingInfo->telephone, 0, 25)); $arb->setParameter('customerFaxNumber', substr($billingInfo->fax, 0, 25)); $arb->setParameter('refID', $refID); $arb->setParameter('cardNumber', $creditcard); $arb->setParameter('expirationDate', $expiration); $arb->setParameter('cardCode', $cardCode); $arb->setParameter('firstName', substr($billingInfo->firstname, 0, 50)); $arb->setParameter('lastName', substr($billingInfo->lastname, 0, 50)); $arb->setParameter('address', substr($billingInfo->addr1, 0, 60)); $arb->setParameter('city', substr($billingInfo->city, 0, 60)); $arb->setParameter('state', substr($billingInfo->state, 0, 40)); $arb->setParameter('zip', substr($billingInfo->postcode, 0, 20)); $arb->setParameter('email', $billingInfo->email); $arb->setParameter('subscrName', $name); // Assgin login credentials $arb->setParameter('login', $config->an_loginid); $arb->setParameter('transkey', $config->an_transkey); $arb->setParameter('refID', $refID); $arb->setParameter('subscrId', $order_number); // Create the recurring billing subscription $arb->createAccount(); $return = array(); if ($arb->isSuccessful() == true) { $params['payment_serial_number'] = $arb->getSubscriberID(); $return = self::confirmOrder($order_id, $params, $msc_id, $user_id, 'authorize'); } else { return self::getErrorMessage('cc', '0000', $arb->getResponse()); } return $return; }
protected function addOrderInfoFix($order_id) { $result = array(); $db = oseDB::instance(); $query = " SELECT * FROM `#__osemsc_order_fix`" . " WHERE `order_id` = '{$order_id}'"; $db->setQuery($query); $item = oseDB::loadItem('obj'); if (empty($item)) { $query = " SELECT b.*,a.entry_id,a.order_item_id" . " FROM `#__osemsc_order_item` AS a" . " INNER JOIN `#__osemsc_order` AS b ON b.order_id = a.order_id" . " WHERE a.`order_id` = '{$order_id}'"; $db->setQuery($query); $oInfo = oseDB::loadItem('obj'); $query = " SELECT * FROM `#__osemsc_member`" . " WHERE `msc_id` = '{$oInfo->entry_id}' AND `member_id`='{$oInfo->user_id}'"; $db->setQuery($query); $mItem = oseDB::loadItem('obj'); if (!empty($mItem)) { // update the order paypal status $ofVals = array(); $ofVals['order_id'] = $oInfo->order_id; $ofVals['order_item_id'] = $oInfo->order_item_id; $ofVals['member_id'] = $mItem->id; $ofVals['msc_id'] = $mItem->msc_id; $ofVals['user_id'] = $mItem->member_id; $ofVals['hasParams'] = 1; $ofVals['payment_method'] = $oInfo->payment_method; $ofVals['payment_mode'] = 'a'; $ofVals['status'] = 'updated'; $ofVals['create_date'] = oseHtml::getDateTime(); $ofVals['params'] = $oInfo->params; $user = JFactory::getUser($mItem->member_id); $ofVals['email'] = $user->email; oseDB::insert("#__osemsc_order_fix", $ofVals); } } }
private function searchMembers($intervaldays,$field) { //$intervaldays++; $db= JFactory :: getDBO(); $date = oseHTML::getDateTime(); $query= " SELECT mem.msc_id, mem.member_id, mem.params,mem.expired_date, mem.notified,muv.* FROM `#__osemsc_member` AS mem " . " INNER JOIN `#__osemsc_userinfo_view` AS muv ON muv.user_id = mem.member_id " . " WHERE DATEDIFF( mem.expired_date, '{$date}' ) BETWEEN {$intervaldays} AND {$intervaldays}+1 AND (mem.{$field} <> 1 OR mem.{$field} IS NULL) AND mem.status = 1 AND muv.primary_contact = 1"; $db->setQuery($query); $member_ids= $db->loadObjectList(); if(!empty($member_ids)) { foreach($member_ids as $k => $member) { $memParams = oseJson::decode($member->params); if(oseObject::getValue($memParams,'payment_mode','m') == 'm') { $dDiff = strtotime($member->expired_date) - strtotime(oseHtml::getDateTime()); if( $dDiff >= ($intervaldays * 86400) && $dDiff < ($intervaldays * 86400+86400)) { continue; } else { unset($member_ids[$k]); } } else { $dDiff = strtotime($member->expired_date) - strtotime(oseHtml::getDateTime()); if( $dDiff >= ($intervaldays * 86400+86400) && $dDiff < ($intervaldays * 86400+86400*2)) { continue; } else { unset($member_ids[$k]); } } } } return $member_ids; }
function updateMemRecurrence() { $result = array(); $db = oseDB::instance(); $msc_member_id = JRequest::getInt('msc_member_id', 0); $startDate = JRequest::getString('start_date', 0); $startTime = JRequest::getString('start_time', 0); $expDate = JRequest::getString('exp_date', 0); $expTime = JRequest::getString('exp_time', 0); $start_date = date_create($startDate . $startTime); $expired_date = date_create($expDate . $expTime); $start_date = date_format($start_date, 'Y-m-d H:i:s'); $expired_date = date_format($expired_date, 'Y-m-d H:i:s'); $now = date_create(oseHtml::getDateTime()); $now = date_format($now, 'Y-m-d H:i:s'); $vals = array(); if ($now > $expired_date) { $vals['status'] = 0; $query = "SELECT * FROM `#__osemsc_member` WHERE `id` = " . $msc_member_id; $db->setQuery($query); $obj = oseDB::loadItem('obj'); $msc_id = $obj->msc_id; $member_id = $obj->member_id; $member = oseRegistry::call('member'); $member->instance($member_id); $userInfo = $member->getUserInfo('obj'); $params = $member->getAddonParams($msc_id, $member_id, 0, $params = array()); $list = oseMscAddon::getAddonList('join', true, 1, 'obj'); foreach ($list as $addon) { $result = oseMscAddon::runAction('join.' . $addon->name . '.cancel', $params); if (!$result['success']) { return $result; } } $msc = oseRegistry::call('msc'); $ext = $msc->getExtInfo($msc_id, 'msc', 'obj'); if (!empty($ext->exp_email)) { $order_id = $params['order_id']; $email = $member->getInstance('email'); $emailTempDetail = $email->getDoc($ext->exp_email, 'obj'); $variables = $email->getEmailVariablesExpire($member_id, $msc_id); $emailParams = $email->buildEmailParams($emailTempDetail->type); $emailDetail = $email->transEmail($emailTempDetail, $variables, $emailParams); $email->sendEmail($emailDetail, $userInfo->email); $emailConfig = oseMscConfig::getConfig('email', 'obj'); if ($emailConfig->sendExp2Admin) { $email->sendToAdminGroup($emailDetail, $emailConfig->admin_group); } } } else { $vals['status'] = 1; } $db = oseDB::instance(); $vals['start_date'] = $start_date; $vals['expired_date'] = $expired_date; $vals['id'] = $msc_member_id; /*$query = " UPDATE `#__osemsc_member`" ." SET start_date = {$start_date}, expired_date = {$expired_date}" ." WHERE id = {$msc_member_id}" ; $db->setQuery($query);*/ //if(oseDB::query()) if (oseDB::update('#__osemsc_member', 'id', $vals)) { $result['success'] = true; $result['title'] = JText::_('DONE'); $result['content'] = JText::_('UPDATED'); } else { $result['success'] = false; $result['title'] = JText::_('ERROR'); $result['content'] = JText::_('FAIL_UPDATING'); } return $result; }