function createSubscription($request) { //Get product id $productID = $request->param('ProductID'); // Get AttentionWizard member $member = Member::currentUser(); //Get InfusionSoft Api $app = $this->getInfusionSoftApi(); // Get IndusionSoft contact ID $isConID = $member->ISContactID; $product = Product::get()->byID($productID); $credits = $product->Credits; // Get existing credit card ID $creditCard = $this->getCurrentCreditCard($member->ID); if (!$creditCard) { $this->setMessage('Error', 'Sorry,the payment failed,please update your credit card.'); return $this->redirect('/account-settings/#tabs-2'); } $ccID = $creditCard->ISCCID; $subscriptionID = $this->createISSubscription($isConID, $product->ISProductID, $product->RecurringPrice, $ccID, 30); if ($subscriptionID && is_int($subscriptionID)) { if ($productID == 1 && !$this->isCCUsedForTrial($creditCard->CreditCardNumber)) { $orderAmount = $product->TrialPrice; $productName = "30 days 1-dollar Trial"; $isProductID = 38; $trial = 1; $subscriptionCount = 0; } else { $productName = $product->Name; $orderAmount = $product->RecurringPrice; $isProductID = $product->ISInitialProductID; $trial = 0; $subscriptionCount = 1; } // Create an order $order = new Order(); $order->OrderStatus = 'P'; $order->Amount = $orderAmount; $order->MemberID = $member->ID; $order->ProductID = $productID; $order->CreditCardID = $creditCard->ID; $orderID = $order->write(); //get the current date $curdate = $app->infuDate(date('j-n-Y')); //Create an infusionsoft order $config = SiteConfig::current_site_config(); $invoiceId = $app->blankOrder($isConID, $productName, $curdate, 0, 0); $orderItem = $app->addOrderItem($invoiceId, $isProductID, 9, floatval($orderAmount), 1, $productName, $productName); $result = $app->chargeInvoice($invoiceId, $productName, $ccID, $config->MerchantAccount, false); if ($result['Successful']) { // Update order $order->OrderStatus = 'c'; $order->IsTrial = $trial; $order->write(); // Create a Subscription record $nextBillDate = $this->getSubscriptionNextBillDate($subscriptionID); $expireDate = date('Y-m-d H:i:s', strtotime($nextBillDate)); $startDate = date('Y-m-d H:i:s', strtotime($expireDate . "-30 days")); $subscription = new Subscription(); $subscription->SubscriptionID = $subscriptionID; $subscription->StartDate = $startDate; $subscription->ExpireDate = $expireDate; $subscription->Status = 1; $subscription->IsTrial = $trial; $subscription->SubscriptionCount = $subscriptionCount; $subscription->MemberID = $member->ID; $subscription->ProductID = $productID; $subscription->OrderID = $orderID; $subscription->write(); // Create a MemberCredits record $memberCredits = new MemberCredits(); $memberCredits->Credits = $credits; $memberCredits->ExpireDate = $expireDate; $memberCredits->MemberID = $member->ID; $memberCredits->ProductID = $productID; $memberCredits->SubscriptionID = $subscription->ID; $memberCredits->write(); //Get contact custom fields $returnFields = array('_AWofmonths', '_AWstartdate'); $conDat1 = $app->loadCon($isConID, $returnFields); if ($productID == 1 && !$this->isCCUsedForTrial($creditCard->CreditCardNumber)) { // Update Member $member->SignUpTrial = 1; $member->write(); //Add the Trial tag $app->grpAssign($isConID, 2216); //Update the contact $conDat = array('_AttentionWizard' => 'Free', 'ContactType' => 'AW Customer', '_AWcanceldate' => null); if (!isset($conDat1['_AWstartdate'])) { $conDat['_AWstartdate'] = $curdate; } $app->updateCon($isConID, $conDat); // Mark credit card as TrialCreditCard $creditCard->UsedForTrial = 1; $creditCard->write(); } else { if (!isset($conDat1['_AWofmonths'])) { $conDat1['_AWofmonths'] = 0; } // Add the InfusionSoft tag $isTagId = $this->getISTagIdByProduct($productID); $app->grpRemove($isConID, $isTagId); $app->grpAssign($isConID, $isTagId); //Remove trial tag if exists $app->grpRemove($isConID, 2216); //Update the InfusionSoft contact details $conDat = array('_AWofmonths' => $conDat1['_AWofmonths'] + 1, 'ContactType' => 'AW Customer', '_AttentionWizard' => 'Paid and Current', '_AWcanceldate' => null); if (!isset($conDat1['_AWstartdate'])) { $conDat['_AWstartdate'] = $curdate; } $app->updateCon($isConID, $conDat); // Note is added $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Renewed AW subscription", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'UserID' => 1); $conActionID = $app->dsAdd("ContactAction", $conActionDat); //Delete all the previous pending orders //DB::query("DELETE from `Order` where MemberID = $member->ID AND OrderStatus = 'P'"); } // Remove previous cancel tags $app->grpRemove($isConID, 2226); $app->grpRemove($isConID, 2758); $app->grpRemove($isConID, 2682); $app->grpRemove($isConID, 2680); $app->grpRemove($isConID, 2694); $app->grpRemove($isConID, 3019); $app->grpRemove($isConID, 3097); } else { //Set the subscription to Inactive $this->setSubscriptionStatus($subscriptionID, 'Inactive'); if ($productID == 1 && !$this->isCCUsedForTrial($creditCard->CreditCardNumber)) { $aw = 'Unsuccessful trial sign-up'; } else { $aw = 'Unsuccessful paid sign-up'; } $conDat = array('_AttentionWizard' => $aw); $app->updateCon($isConID, $conDat); // Add an AW prospect tag $app->grpAssign($isConID, $this->getISTagIdByPaymentCode($result['Code'])); // Add a note $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Unsuccessful attempt to sign-up for AW", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'UserID' => 1); $conActionID = $app->dsAdd("ContactAction", $conActionDat); $this->setMessage('Error', 'Sorry,the payment failed,please update your credit card.'); return $this->redirect('/account-settings/#tabs-2'); } } else { // Add an AW prospect tag $app->grpAssign($isConID, 3097); //Update InfusionSoft contact if ($productID == 1 && !$this->isCCUsedForTrial($creditCard->CreditCardNumber)) { $aw = 'Unsuccessful trial sign-up'; } else { $aw = 'Unsuccessful paid sign-up'; } $conDat = array('_AttentionWizard' => $aw); $app->updateCon($isConID, $conDat); // Add a note $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Unsuccessful attempt to sign-up for AW", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'UserID' => 1); $conActionID = $app->dsAdd("ContactAction", $conActionDat); $this->setMessage('Error', 'Sorry,the subscription not created due to some reason.please try again.'); return $this->redirect('/account-settings/#tabs-4'); } $this->setMessage('Success', 'The Subscription is created successfully.'); return $this->redirect('/account-settings'); }
function doPrepaidSignup() { $data = $_POST; //Check for existing member email address if ($member = DataObject::get_one("Member", "`Email` = '" . Convert::raw2sql($data['Email']) . "'")) { return "inlineMsg1"; } $currentYear = date('Y'); $currentMonth = date('n'); //Stop sign-up when the credit card is expired if ($data['ExpirationYear'] < $currentYear) { return "inlineMsg6"; } if ($data['ExpirationYear'] == $currentYear) { if ($data['ExpirationMonth'] < $currentMonth) { return "inlineMsg6"; } } //Get InfusionSoft Api $app = $this->getInfusionSoftApi(); // Get country text from code $country = Geoip::countryCode2name($data['Country']); // Create IndusionSoft contact $returnFields = array('Id'); $conInfo = $app->findByEmail($data['Email'], $returnFields); if (count($conInfo)) { $isConID = $conInfo[0]['Id']; } else { $conDat = array('FirstName' => $data['FirstName'], 'LastName' => $data['LastName'], 'Company' => $data['Company'], 'StreetAddress1' => $data['StreetAddress1'], 'StreetAddress2' => $data['StreetAddress2'], 'City' => $data['City'], 'State' => $data['State'], 'PostalCode' => $data['PostalCode'], 'Country' => $country, 'Email' => $data['Email']); $isConID = $app->addCon($conDat); } // Locate existing credit card $ccID = $app->locateCard($isConID, substr($data['CreditCardNumber'], -4, 4)); $creditCardType = $this->getISCreditCardType($data['CreditCardType']); if (!$ccID) { //Validate the credit card $card = array('CardType' => $creditCardType, 'ContactId' => $isConID, 'CardNumber' => $data['CreditCardNumber'], 'ExpirationMonth' => sprintf("%02s", $data['ExpirationMonth']), 'ExpirationYear' => $data['ExpirationYear'], 'CVV2' => $data['CVVCode']); $result = $app->validateCard($card); if ($result['Valid'] == 'false') { return "inlineMsg5"; } $ccData = array('ContactId' => $isConID, 'FirstName' => $data['FirstName'], 'LastName' => $data['LastName'], 'BillAddress1' => $data['StreetAddress1'], 'BillAddress2' => $data['StreetAddress2'], 'BillCity' => $data['City'], 'BillState' => $data['State'], 'BillZip' => $data['PostalCode'], 'BillCountry' => $country, 'CardType' => $creditCardType, 'NameOnCard' => $data['NameOnCard'], 'CardNumber' => $data['CreditCardNumber'], 'CVV2' => $data['CVVCode'], 'ExpirationMonth' => sprintf("%02s", $data['ExpirationMonth']), 'ExpirationYear' => $data['ExpirationYear']); $ccID = $app->dsAdd("CreditCard", $ccData); } // Create AttentionWizard member $member = new Member(); $member->FirstName = $data['FirstName']; $member->Surname = $data['LastName']; $member->Email = $data['Email']; $member->Password = $data['Password']['_Password']; $member->ISContactID = $isConID; $memberID = $member->write(); //Find or create the 'user' group if (!($userGroup = DataObject::get_one('Group', "Code = 'customers'"))) { $userGroup = new Group(); $userGroup->Code = "customers"; $userGroup->Title = "Customers"; $userGroup->Write(); } //Add member to user group $userGroup->Members()->add($member); //Get the current date $curdate = $app->infuDate(date('j-n-Y')); $product = Product::get()->byID(7); // Store credit card info $creditCard = new CreditCard(); $creditCard->CreditCardType = $data['CreditCardType']; $creditCard->CreditCardNumber = $data['CreditCardNumber']; $creditCard->NameOnCard = $data['NameOnCard']; $creditCard->CreditCardCVV = $data['CVVCode']; $creditCard->ExpiryMonth = $data['ExpirationMonth']; $creditCard->ExpiryYear = $data['ExpirationYear']; $creditCard->Company = $data['Company']; $creditCard->StreetAddress1 = $data['StreetAddress1']; $creditCard->StreetAddress2 = $data['StreetAddress2']; $creditCard->City = $data['City']; $creditCard->State = $data['State']; $creditCard->PostalCode = $data['PostalCode']; $creditCard->Country = $data['Country']; $creditCard->Current = 1; $creditCard->ISCCID = $ccID; $creditCard->MemberID = $memberID; $creditCardID = $creditCard->write(); // Create an Infusionsoft order $config = SiteConfig::current_site_config(); $invoiceId = $app->blankOrder($isConID, $product->Name, $curdate, 0, 0); $orderItem = $app->addOrderItem($invoiceId, $this->getNonExpiringIsProductId(7), 3, floatval($data['Price']), intval($data['Quantity']), $product->Name, $product->Name); $result = $app->chargeInvoice($invoiceId, $product->Name, $ccID, $config->MerchantAccount, false); // Create an order $order = new Order(); $order->OrderStatus = 'P'; $order->Amount = $data['Price'] * $data['Quantity']; $order->MemberID = $memberID; $order->ProductID = 7; $order->CreditCardID = $creditCardID; $orderID = $order->write(); $returnFields = array('_AttentionWizard', 'Leadsource'); $conDat1 = $app->loadCon($isConID, $returnFields); if ($result['Successful']) { // Add tag Paid member - prepaid $app->grpAssign($isConID, 2290); $conDat = array('ContactType' => 'AW Customer'); if (!isset($conDat1['_AttentionWizard'])) { $conDat['_AttentionWizard'] = 'Prepaid only - no subscription'; } if (isset($conDat1['_AttentionWizard']) && $conDat1['_AttentionWizard'] != 'Paid and Current' && $conDat1['_AttentionWizard'] != 'Free') { $conDat['_AttentionWizard'] = 'Prepaid only - no subscription'; } if (!isset($conDat1['Leadsource']) || !$conDat1['Leadsource']) { $conDat['Leadsource'] = 'AttentionWizard'; } $conID = $app->updateCon($isConID, $conDat); // Note is added $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Purchased AW Prepaid Credits", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'UserID' => 1); $conActionID = $app->dsAdd("ContactAction", $conActionDat); // Update order $order->OrderStatus = 'c'; $order->write(); // Create a Subscription record $subscription = new Subscription(); $subscription->StartDate = date("Y-m-d H:i:s"); $subscription->MemberID = $memberID; $subscription->ProductID = 7; $subscription->OrderID = $orderID; $subscription->write(); // Create a MemberCredits record $memberCredits = new MemberCredits(); $memberCredits->Credits = $product->Credits * $data['Quantity']; $memberCredits->MemberID = $memberID; $memberCredits->ProductID = 7; $memberCredits->SubscriptionID = $subscription->ID; $memberCredits->write(); $member->logIn(); $this->setMessage('Success', 'Purchased non-expiring heatmaps successfully.'); return 'url1'; } else { //Update Infusionsoft contact $conDat = array('_AttentionWizard' => 'Unsuccessful prepaid sign-up', 'ContactType' => 'AW Prospect'); if (!isset($conDat1['Leadsource'])) { $conDat['Leadsource'] = 'AttentionWizard'; } $app->updateCon($isConID, $conDat); // Add an AW prospect tag $app->grpAssign($isConID, $this->getISTagIdByPaymentCode(strtoupper($result['Code']))); // Add a note $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Unsuccessful attempt to sign-up prepaid plan", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'UserID' => 1); $conActionID = $app->dsAdd("ContactAction", $conActionDat); $member->logIn(); $this->setMessage('Error', 'Sorry,the payment failed due to some reason.please update your credit card.'); return 'url2'; } }
public function moveCreditsFromJoomlaToSS() { die('test3'); error_reporting(E_ALL); ini_set('display_errors', 1); ini_set('max_execution_time', 0); ini_set('memory_limit', '-1'); $mysqli = $this->getDbConnection(); $result = $mysqli->query("SELECT * FROM jos_users u\n\t\tINNER JOIN jos_osemsc_member_credits mc ON u.id = mc.member_id\n\t\tWHERE mc.credits !=0"); $count = 0; while ($obj = $result->fetch_object()) { $ssMember = $this->getSSMember($obj->email); if (!$ssMember) { continue; } $subscription = $this->getSSSubscription($ssMember->ID, $obj->msc_id); $memberCredits = new MemberCredits(); $memberCredits->Credits = $obj->credits; $memberCredits->MemberID = $ssMember->ID; $memberCredits->ProductID = $obj->msc_id; if ($subscription) { $memberCredits->Created = $subscription->Created; $memberCredits->LastEdited = $subscription->LastEdited; $memberCredits->ExpireDate = $subscription->ExpireDate; $memberCredits->SubscriptionID = $subscription->ID; } $memberCredits->write(); $count++; } $mysqli->close(); echo "Total Credits moved: {$count}"; }
function doPurchase($data, $form) { //Get InfusionSoft Api $app = $this->getInfusionSoftApi(); // Get curent date $curdate = $app->infuDate(date('j-n-Y')); $member = Member::currentUser(); $isConID = $member->ISContactID; $product = Product::get()->byID($data['ProductID']); // Get existing credit card ID $creditCard = $this->getCurrentCreditCard($member->ID); // Get the current InfusionSoft credit card ID $ccID = $creditCard->ISCCID; // Create an Infusionsoft order $config = SiteConfig::current_site_config(); $invoiceId = $app->blankOrder($isConID, $product->Name, $curdate, 0, 0); $orderItem = $app->addOrderItem($invoiceId, intval($this->getNonExpiringIsProductId($data['ProductID'])), 3, floatval($product->Price), intval($data['Quantity']), $product->Name, $product->Name); $result = $app->chargeInvoice($invoiceId, $product->Name, $ccID, $config->MerchantAccount, false); // Create an order $order = new Order(); $order->OrderStatus = 'P'; $order->Amount = $product->Price * $data['Quantity']; $order->MemberID = $member->ID; $order->ProductID = $data['ProductID']; $order->CreditCardID = $creditCard->ID; $orderID = $order->write(); if ($result['Successful']) { // Add tag Paid member - prepaid $app->grpAssign($isConID, 2290); $conDat = array('ContactType' => 'AW Customer'); $returnFields = array('_AttentionWizard'); $conDat1 = $app->loadCon($isConID, $returnFields); if ($conDat1['_AttentionWizard'] != 'Paid and Current' && $conDat1['_AttentionWizard'] != 'Free') { $conDat['_AttentionWizard'] = 'Prepaid only - no subscription'; } $conID = $app->updateCon($isConID, $conDat); // Note is added $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Purchased AW Prepaid Credits", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'UserID' => 1); $conActionID = $app->dsAdd("ContactAction", $conActionDat); // Update order $order->OrderStatus = 'c'; $order->write(); // Create a Subscription record $subscription = new Subscription(); $subscription->StartDate = date("Y-m-d H:i:s"); $subscription->MemberID = $member->ID; $subscription->ProductID = $data['ProductID']; $subscription->OrderID = $orderID; $subscription->write(); // Create a MemberCredits record $memberCredits = new MemberCredits(); $memberCredits->Credits = $product->Credits * $data['Quantity']; $memberCredits->MemberID = $member->ID; $memberCredits->ProductID = $product->ID; $memberCredits->SubscriptionID = $subscription->ID; $memberCredits->write(); $this->setMessage('Success', 'Purchased non-expiring heatmaps successfully.'); } else { // Add an AW prospect tag $app->grpAssign($isConID, $this->getISTagIdByPaymentCode(strtoupper($result['Code']))); // Add a note $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Unsuccessful attempt to purchase prepaid plan", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'UserID' => 1); $conActionID = $app->dsAdd("ContactAction", $conActionDat); $this->setMessage('Error', 'Sorry,the payment failed,please update your credit card.'); return $this->redirect('/account-settings/#tabs-2'); } return $this->redirect('/account-settings'); }
public function changeSubscription($data, $form) { //Get the record ID $id = Controller::curr()->request->param('ID'); // Get the subscription $subscription = Subscription::get()->byID($id); //Get the new product ID $newProductID = $data['ProductID']; if ($subscription->ProductID == $newProductID) { $form->sessionMessage("Please select a new subscription.", 'bad'); return $this->edit(Controller::curr()->getRequest()); } // Get the Page controller $Pg_Ctrl = new Page_Controller(); // Get InfusionSoft Api $app = $Pg_Ctrl->getInfusionSoftApi(); // Get AttentionWizard member $member = Member::get()->byID($data['MemberID']); // Get IndusionSoft contact ID $isConID = $member->ISContactID; //Get current date $curdate = $app->infuDate(date('j-n-Y')); //Get old order $oldOrder = $subscription->Order(); //Get new product $product = Product::get()->byID($newProductID); $credits = $product->Credits; $isProductID = $product->ISInitialProductID; // Get the current InfusionSoft credit card ID $creditCard = $Pg_Ctrl->getCurrentCreditCard($member->ID); if (!$creditCard) { $form->sessionMessage("The user does not have a Credit Card on account, please add a credit card.", 'bad'); return $this->edit(Controller::curr()->getRequest()); } $ccID = $creditCard->ISCCID; $subscriptionID = $Pg_Ctrl->createISSubscription($isConID, $product->ISProductID, $product->RecurringPrice, $ccID, 30); if ($subscriptionID && is_int($subscriptionID)) { // Create an order $order = new Order(); $order->OrderStatus = 'P'; $order->Amount = $product->RecurringPrice; $order->MemberID = $member->ID; $order->ProductID = $newProductID; $order->CreditCardID = $creditCard->ID; $orderID = $order->write(); //Create an infusionsoft order $config = SiteConfig::current_site_config(); $invoiceId = $app->blankOrder($isConID, $product->Name, $curdate, 0, 0); $orderItem = $app->addOrderItem($invoiceId, $isProductID, 9, floatval($product->RecurringPrice), 1, $product->Name, $product->Name); $result = $app->chargeInvoice($invoiceId, $product->Name, $ccID, $config->MerchantAccount, false); if ($result['Successful']) { $nextBillDate = $Pg_Ctrl->getSubscriptionNextBillDate($subscriptionID); $expireDate = date('Y-m-d H:i:s', strtotime($nextBillDate)); $startDate = date('Y-m-d H:i:s', strtotime($expireDate . "-30 days")); //Set the current subscription to Inactive $Pg_Ctrl->setSubscriptionStatus($subscription->SubscriptionID, 'Inactive'); //Remove trial tag if exists $app->grpRemove($isConID, 2216); //get old Tag ID if ($Pg_Ctrl->isTrialMember($member->ID)) { $oldISTagID = 2216; } else { $oldISTagID = $Pg_Ctrl->getISTagIdByProduct($oldOrder->ProductID); } //Remove old tag ID $app->grpRemove($isConID, $oldISTagID); $newISTagID = $Pg_Ctrl->getISTagIdByProduct($newProductID); //Add new tag ID $app->grpAssign($isConID, $newISTagID); //Add a note $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Payment made for AW service", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'CreationNotes' => "{$product->Name} Subscription", 'UserID' => 1); $app->dsAdd("ContactAction", $conActionDat); $returnFields = array('_AWofmonths'); $conData = $app->loadCon($isConID, $returnFields); $conDat = array('_AWofmonths' => (isset($conData['_AWofmonths']) ? $conData['_AWofmonths'] : 0) + 1, '_AttentionWizard' => 'Paid and Current'); $app->updateCon($isConID, $conDat); //Create a new Subscription $newSubscription = new Subscription(); $newSubscription->StartDate = $startDate; $newSubscription->ExpireDate = $expireDate; $newSubscription->SubscriptionID = $subscriptionID; $newSubscription->Status = 1; $newSubscription->IsTrial = 0; $newSubscription->SubscriptionCount = 1; $newSubscription->MemberID = $member->ID; $newSubscription->ProductID = $newProductID; $newSubscription->OrderID = $orderID; $newSubscription->write(); // Create a MemberCredits record $memberCredits = new MemberCredits(); $memberCredits->Credits = $credits; $memberCredits->Expire = 1; $memberCredits->ExpireDate = $expireDate; $memberCredits->MemberID = $member->ID; $memberCredits->ProductID = $newProductID; $memberCredits->SubscriptionID = $newSubscription->ID; $memberCredits->write(); // Update order $order->OrderStatus = 'c'; $order->write(); //Update old subscription status $subscription->Status = 0; $subscription->IsTrial = 0; $subscription->write(); } else { //Set the subscription to Inactive $Pg_Ctrl->setSubscriptionStatus($subscriptionID, 'Inactive'); $form->sessionMessage("Sorry,the payment failed due to some reason.please update your credit card", 'bad'); return $this->edit(Controller::curr()->getRequest()); } } else { $form->sessionMessage("Sorry,the subscription failed due to some reason.please try again", 'bad'); return $this->edit(Controller::curr()->getRequest()); } $form->sessionMessage("The Subscription is changed successfully.", 'good'); return Controller::curr()->redirect("admin/manage-data/Subscription/EditForm/field/Subscription/item/{$newSubscription->ID}/edit"); }
function doSignup() { $data = $_POST; //Stop sign-up if the user does not check the chebox if (!isset($data['Agreement'])) { return "inlineMsg5"; } if ($this->isCCUsedForTrial("{$data['CreditCardNumber']}") && $data['SubscriptionType'] == 1) { return "inlineMsg1"; } $currentYear = date('Y'); $currentMonth = date('n'); //Stop sign-up when the credit card is expired if ($data['ExpirationYear'] < $currentYear) { return "inlineMsg4"; } if ($data['ExpirationYear'] == $currentYear) { if ($data['ExpirationMonth'] < $currentMonth) { return "inlineMsg4"; } } //Get InfusionSoft Api $app = $this->getInfusionSoftApi(); //Get current date $curdate = $app->infuDate(date('j-n-Y')); //Get the registration form from session $regFormData = Session::get('RegistrationFormData'); // Get country text from code $country = Geoip::countryCode2name($data['Country']); // Get InfusionSoft Contact ID $returnFields = array('Id', 'Leadsource'); $conInfo = $app->findByEmail($regFormData['Email'], $returnFields); if (empty($conInfo)) { // If IS contact doesn't exist create one $conDat = array('FirstName' => $data['FirstName'], 'LastName' => $data['LastName'], 'Company' => $data['Company'], 'StreetAddress1' => $data['StreetAddress1'], 'StreetAddress2' => $data['StreetAddress2'], 'City' => $data['City'], 'State' => $data['State'], 'PostalCode' => $data['PostalCode'], 'Country' => $country, 'Email' => $regFormData['Email']); if (empty($conInfo)) { $conDat['Leadsource'] = 'AttentionWizard'; } $isConID = $app->addCon($conDat); } else { $isConID = $conInfo[0]['Id']; } // Locate existing credit card $ccID = $app->locateCard($isConID, substr($data['CreditCardNumber'], -4, 4)); $creditCardType = $this->getISCreditCardType($data['CreditCardType']); if (!$ccID) { //Validate the credit card $card = array('CardType' => $creditCardType, 'ContactId' => $isConID, 'CardNumber' => $data['CreditCardNumber'], 'ExpirationMonth' => sprintf("%02s", $data['ExpirationMonth']), 'ExpirationYear' => $data['ExpirationYear'], 'CVV2' => $data['CVVCode']); $result = $app->validateCard($card); if ($result['Valid'] == 'false') { return "inlineMsg3"; } $ccData = array('ContactId' => $isConID, 'FirstName' => $data['FirstName'], 'LastName' => $data['LastName'], 'BillAddress1' => $data['StreetAddress1'], 'BillAddress2' => $data['StreetAddress2'], 'BillCity' => $data['City'], 'BillState' => $data['State'], 'BillZip' => $data['PostalCode'], 'BillCountry' => $country, 'CardType' => $creditCardType, 'NameOnCard' => $data['NameOnCard'], 'CardNumber' => $data['CreditCardNumber'], 'CVV2' => $data['CVVCode'], 'ExpirationMonth' => sprintf("%02s", $data['ExpirationMonth']), 'ExpirationYear' => $data['ExpirationYear']); $ccID = $app->dsAdd("CreditCard", $ccData); } // Create AttentionWizard member $member = new Member(); $member->FirstName = $data['FirstName']; $member->Surname = $data['LastName']; $member->Email = $regFormData['Email']; $member->Password = $regFormData['Password']['_Password']; $member->ISContactID = $isConID; $memberID = $member->write(); //Find or create the 'user' group and add the member to the group if (!($userGroup = DataObject::get_one('Group', "Code = 'customers'"))) { $userGroup = new Group(); $userGroup->Code = "customers"; $userGroup->Title = "Customers"; $userGroup->Write(); $userGroup->Members()->add($member); } else { $userGroup->Members()->add($member); } //Get product details $product = Product::get()->byID($data['SubscriptionType']); $credits = $product->Credits; if ($data['SubscriptionType'] == 1) { $orderAmount = $product->TrialPrice; $productName = "30 days 1-dollar Trial"; $isProductID = 38; } else { $productName = $product->Name; $orderAmount = $product->RecurringPrice; $isProductID = $product->ISInitialProductID; } // Store credit card info $creditCard = new CreditCard(); $creditCard->CreditCardType = $data['CreditCardType']; $creditCard->CreditCardNumber = $data['CreditCardNumber']; $creditCard->NameOnCard = $data['NameOnCard']; $creditCard->CreditCardCVV = $data['CVVCode']; $creditCard->ExpiryMonth = $data['ExpirationMonth']; $creditCard->ExpiryYear = $data['ExpirationYear']; $creditCard->Company = $data['Company']; $creditCard->StreetAddress1 = $data['StreetAddress1']; $creditCard->StreetAddress2 = $data['StreetAddress2']; $creditCard->City = $data['City']; $creditCard->State = $data['State']; $creditCard->PostalCode = $data['PostalCode']; $creditCard->Country = $data['Country']; $creditCard->Current = 1; $creditCard->ISCCID = $ccID; $creditCard->MemberID = $memberID; $creditCardID = $creditCard->write(); // Create an order $order = new Order(); $order->OrderStatus = 'P'; $order->Amount = $orderAmount; $order->MemberID = $memberID; $order->ProductID = $data['SubscriptionType']; $order->CreditCardID = $creditCardID; $orderID = $order->write(); //Create the Infusionsoft subscription $subscriptionID = $this->createISSubscription($isConID, $product->ISProductID, $product->RecurringPrice, $ccID, 30); if ($subscriptionID && is_int($subscriptionID)) { //Create an infusionsoft order $config = SiteConfig::current_site_config(); $invoiceId = $app->blankOrder($isConID, $productName, $curdate, 0, 0); $orderItem = $app->addOrderItem($invoiceId, $isProductID, 9, floatval($orderAmount), 1, $productName, $productName); $result = $app->chargeInvoice($invoiceId, $productName, $ccID, $config->MerchantAccount, false); if ($result['Successful']) { // Create a Subscription record $nextBillDate = $this->getSubscriptionNextBillDate($subscriptionID); $expireDate = date('Y-m-d H:i:s', strtotime($nextBillDate)); $startDate = date('Y-m-d H:i:s', strtotime($expireDate . "-30 days")); $subscription = new Subscription(); $subscription->StartDate = $startDate; $subscription->ExpireDate = $expireDate; $subscription->MemberID = $memberID; $subscription->ProductID = $data['SubscriptionType']; $subscription->OrderID = $orderID; $subscription->Status = 1; $subscription->SubscriptionID = $subscriptionID; $subscription->write(); // Create a MemberCredits record $memberCredits = new MemberCredits(); $memberCredits->Credits = $credits; $memberCredits->ExpireDate = $expireDate; $memberCredits->MemberID = $memberID; $memberCredits->ProductID = $data['SubscriptionType']; $memberCredits->SubscriptionID = $subscription->ID; $memberCredits->write(); // Update order $order->OrderStatus = 'c'; $order->write(); // If product selected is bronze do a trial signup if ($data['SubscriptionType'] == 1) { //Add the InfusionSoft tag $app->grpAssign($isConID, 2216); //Update the InfusionSoft contact details $conDat = array('ContactType' => 'AW Customer', '_AWstartdate' => $curdate, '_AttentionWizard' => 'Free'); $app->updateCon($isConID, $conDat); // Update Subscription $subscription->IsTrial = 1; $subscription->SubscriptionCount = 0; $subscription->write(); // Update Member $member->SignUpTrial = 1; $member->write(); // Update Order $order->IsTrial = 1; $order->write(); // Update credit card $creditCard->UsedForTrial = 1; $creditCard->write(); } else { // Update Subscription $subscription->SubscriptionCount = 1; $subscription->write(); // Add the InfusionSoft tag $isTagId = $this->getISTagIdByProduct($data['SubscriptionType']); $app->grpAssign($isConID, $isTagId); //Update the InfusionSoft contact details $returnFields = array('_AWofmonths'); $conDat1 = $app->loadCon($isConID, $returnFields); if (!isset($conDat1['_AWofmonths'])) { $conDat1['_AWofmonths'] = 0; } $conDat = array('_AWofmonths' => $conDat1['_AWofmonths'] + 1, 'ContactType' => 'AW Customer', '_AttentionWizard' => 'Paid and Current', '_AWstartdate' => $curdate); $app->updateCon($isConID, $conDat); //Add a note $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Payment made for AW service", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'CreationNotes' => "{$product->Name} Subscription", 'UserID' => 1); $app->dsAdd("ContactAction", $conActionDat); } $member->logIn(); $this->setMessage('Success', 'You have signed-up & the Subscription is created successfully'); return 'url1'; } else { //Set the subscription to Inactive $this->setSubscriptionStatus($subscriptionID, 'Inactive'); //Update InfusionSoft contact if ($data['SubscriptionType'] == 1) { $aw = 'Unsuccessful trial sign-up'; } else { $aw = 'Unsuccessful paid sign-up'; } $conDat = array('ContactType' => 'AW Prospect', '_AttentionWizard' => $aw); $app->updateCon($isConID, $conDat); // Add an AW prospect tag //$app->grpAssign($isConID, $this->getISTagIdByPaymentCode(strtoupper($result['Code']))); $app->grpAssign($isConID, $this->getISTagIdByPaymentCode('DECLINED')); // Add a note $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Unsuccessful attempt to sign-up for AW", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'UserID' => 1); $conActionID = $app->dsAdd("ContactAction", $conActionDat); $member->logIn(); $this->setMessage('Error', 'Sorry,the payment failed due to some reason.please update your credit card'); return "url2"; } } else { $member->logIn(); // Add an AW prospect tag $app->grpAssign($isConID, 3097); //Update InfusionSoft contact if ($data['SubscriptionType'] == 1) { $aw = 'Unsuccessful trial sign-up'; } else { $aw = 'Unsuccessful paid sign-up'; } $conDat = array('ContactType' => 'AW Prospect', '_AttentionWizard' => $aw); $app->updateCon($isConID, $conDat); // Add a note $conActionDat = array('ContactId' => $isConID, 'ActionType' => 'UPDATE', 'ActionDescription' => "Unsuccessful attempt to sign-up for AW", 'CreationDate' => $curdate, 'ActionDate' => $curdate, 'CompletionDate' => $curdate, 'UserID' => 1); $conActionID = $app->dsAdd("ContactAction", $conActionDat); $this->setMessage('Error', 'You have signed-up successfully but the Subscription is not created,please try again.'); return "url3"; } }