function subscription_cancel($sub_id, $user_id, $sub_notes = "", $sub_status_text = "") { requre_once('../transaction.class.php'); $trans = new transaction_class(false); $trans->pull_subscription($sub_id, 'ss.ss_subscription_id'); $status = $trans->process_cancel_request(array("actor" => 'System', 'notes' => $sub_notes, 'verifyuserId' => $user_id)); if (!$status) { return false; } return $status['ss_cancel_id']; }
$assoc = array(); $data = explode('|', $data1); foreach ($keys as $row => $key) { $assoc[trim($key)] = trim($data[$row]); } } print_r($assoc); die; require_once "../includes/subFunctions/banks.ipaygate.php"; $processor = new iPayGate_Client($bankInfo); $sql = "SELECT ss_ID\r\nFROM cs_subscription where ss_billing_type in ('Check');\r\n"; $cnt = 0; $result = mysql_query($sql) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>"); while ($cs_subscription = mysql_fetch_assoc($result)) { $subs = new transaction_class(false); $subs->pull_subscription($cs_subscription['ss_ID']); $transInfo['ss_billing_check_routing'] = $subs->etelDecSalted($subs->row['subscriptionTable']['ss_billing_check_routing']); $transInfo['ss_billing_check_account'] = $subs->etelDecSalted($subs->row['subscriptionTable']['ss_billing_check_account']); if (!is_numeric($transInfo['ss_billing_check_routing'])) { $transInfo['ss_billing_check_routing'] = etelDec($subs->row['transactionTable']['bankroutingcode']); if (is_numeric($transInfo['ss_billing_check_routing'])) { echo "update cs_subscription set ss_billing_check_routing = '" . $subs->etelEncSalted($transInfo['ss_billing_check_routing']) . "' \r\n\t\t\t\r\n\t\t\twhere ss_ID = '" . $cs_subscription['ss_ID'] . "';<br>"; } else { echo $cs_subscription['ss_ID'] . ' PROBLEM ' . $transInfo['ss_billing_check_account'] . '<BR>'; } } else { } flush(); } die($sqlchange); $sql = "select * from `cs_subscription` left join cs_transactiondetails on ss_transaction_id = transactionId where ss_bank_id in (15,28,29)";
function rebill_subscriptions($sub_ids) { dieLog('Not using this anymore.'); $count = array(); $logged = "<table>"; $processor = new transaction_class(false); foreach ($sub_ids as $sub_id) { $processor->pull_subscription($sub_id); if (!isset($count[$sub_id])) { $count[$sub_id] = 1; $res = $processor->processRebill(); $logged .= "\n\t\t\t\t\t<tr>\n\t\t\t\t\t<td>{$id}</td><td></td>\n\t\t\t\t\t<td>" . $count[$sub_id] . "</td><td></td>\n\t\t\t\t\t<td>" . $res['success'] . "</td><td></td>\n\t\t\t\t\t<td>" . $res['errormsg'] . "</td><td></td>\n\t\t\t\t\t<td>" . $res['status'] . "</td><td></td>\n\t\t\t\t\t<td>" . $res['transactionId'] . "</td><td></td>\n\t\t\t\t\t</tr>\n\t\t\t\t"; } } return $logged . "</table>"; }
function angel_cancel_subscription() { foreach ($this->page_map as $index => $value) { ${$value} = $index; } $this->cancel_reason = $this->working_vars['cancel_reason']; switch ($cancel_reason) { case 1: $cancel_reason_decoded = "Cant get in touch with Merchant (Angel cancel)"; break; case 2: $cancel_reason_decoded = "Changed Mind (Angel cancel)"; break; default: $cancel_reason_decoded = "Angel Cancel"; break; } $lookup = new lookup_class(); $trans = $this->working_vars['transactions']; $curr = $this->working_vars['current_trans'] - 1; if (!isset($trans[$curr])) { return $this->angel_404("error message: 1000"); } $etel_debug_mode = 1; if ($trans[$curr]['ss_subscription_ID'] == 0) { return $this->angel_process_transaction(); } $ss_subscription_ID = $trans[$curr]['ss_subscription_ID']; $trans = new transaction_class(false); $trans->pull_subscription($ss_subscription_ID, 'ss_subscription_ID'); $refinfo = $trans->process_cancel_request(array("actor" => 'Angel', 'notes' => $cancel_reason_decoded)); $refid = $refinfo['ss_cancel_id']; if (!$refinfo) { //angel_transfer_callcenter return "\n\t\t<ANGELXML>\n\t\t\t<MESSAGE>\n\t\t\t\t<PLAY>\n\t\t\t\t\t<PROMPT type=\"text\">\n\t\t\t\t\t\tThere was an error cancelling your subscription. It may have already been canceled.\n\t\t\t\t\t</PROMPT>\n\t\t\t\t</PLAY>\n\t\t\t\t<GOTO destination=\"/{$angel_transfer_callcenter}\" />\n\t\t\t</MESSAGE>\n\t\t</ANGELXML>\n\t\t\t"; } $temp = ""; $m = strlen($refid); for ($j = 0; $j < $m; $j++) { $temp .= $refid[$j] . ", "; } $refid = $temp; return "\n\t\t<ANGELXML>\n\t\t\t<MESSAGE>\n\t\t\t\t<PLAY>\n\t\t\t\t\t<PROMPT type=\"text\">\n\t\t\t\t\t\tYour subscription has been cancelled. \n\t\t\t\t\t\t\n\t\t\t\t\t\tThe cancelation reference number, for this cancellation, is, {$refid}\n\t\t\t\t\t\t\n\t\t\t\t\t\tAgain, that reference number is, {$refid}\n\t\t\t\t\t\t\n\t\t\t\t\t\tThank you for calling " . $this->template[$this->template_sel]['name'] . " support.\n\t\t\t\t\t</PROMPT>\n\t\t\t\t</PLAY>\n\t\t\t\t\t<ACTION type=\"hangup\"/>\n\t\t\t</MESSAGE>\n\t\t</ANGELXML>\t\t\n\t\t"; }
require_once "includes/calendar.class.php"; require_once "includes/rebill.class.php"; $sessionlogin = $companyInfo['userId']; $companyId = $companyInfo['userId']; /************** Define functions to process form **************/ $rebills = new rebill_class(); $rebills->set_user($sessionlogin); /**************** Process Form ****************/ if ($_POST['frm_cancel_rebills'] == "1") { foreach ($_POST['frm_cancel_ids'] as $id) { $trans = new transaction_class(false); $trans->pull_subscription($id, 'ss_subscription_id'); $status = $trans->process_cancel_request(array("actor" => 'Merchant', 'verifyuserId' => $companyInfo['userId'])); } unset($_REQUEST['frm_cancel_ids']); unset($_REQUEST['frm_cancel_rebills']); //$params = $rebills->request_params("frm_"); //header("Location: rebillSummary_smart.php?$params"); //exit(); } $rebill_info = $rebills->get_rebill_info(); /************** Define pairs **************/ $my_sql['pairs']['SubAccounts'] = array(); $my_sql['pairs']['SubAccounts'][] = array("display" => "All", "value" => ""); foreach ($rebill_info as $info) {
$row = 2; $access['Data']['Breakdown']['RowDisplay'] = 'Wide'; $access['Data']['Breakdown']['Input'] = ''; $access['Data']['Breakdown']['disable'] = true; $smarty->assign("Profit", $profit); $access['Data']['Breakdown']['AddHtml'] = $smarty->fetch('cp_profitreport.tpl'); if ($_POST['submit_access'] == 'Submit') { $result = processAccessForm(&$access); if ($result) { $msg .= "Company Updated Successfully (" . $result['cnt'] . " Field(s))<BR>"; } else { $msg .= "No Updates Detected<BR>"; } if ($_POST['update_manager']) { $subscription = new transaction_class(false); $subscription->pull_subscription($ss_subscription_ID, 'ss.ss_subscription_ID'); $res = $subscription->update_account_status(); $submsg = ''; if ($res[0]['succeeded']) { $submsg .= " postNotify:" . htmlentities(substr($res[0]['response']['body'], 0, 20)); } if ($res[1]['succeeded']) { $submsg .= " htaccess:" . htmlentities(substr($res[1]['response']['body'], 0, 20)); } if ($res) { $msg .= "Account Status Updated Successfully ( {$submsg})<BR>"; } $access['Data']['ss_account_status']['Value'] = $subscription->row['subscriptionTable']['ss_account_status']; $access['Data']['ss_account_notes']['Value'] = $subscription->row['subscriptionTable']['ss_account_notes']; } }
} if (sizeof($query) < 2) { beginTable(); echo "Insufficient Information. Please try again."; endTable('Insufficient Information', "lookup.php?{$link_info}", false, true); die; } $access = getAccessInfo("\nss_ID,\n\n'Account Information' as access_header,\n\tss_subscription_ID as Subscription_ID,\n\tDate_Format(ss_account_start_date,'%W %b %D %Y %H:%i:%s') as Account_Started,\n\tss_productdescription,\n\tss_cust_username,\n\tss_cust_password,\n\tss_account_status,\n\tss_account_expire_date,\n\tcs.cs_name as Website,\n\tcs.cs_member_url as WebsiteURL,\n\t\n'Customer Information' as access_header,\n\tCONCAT(ss_billing_lastname,', ',ss_billing_mi,' ',ss_billing_firstname) as Full_Name,\n\tss_cust_email as Email,\n\t\n'Billing Information' as access_header,\n\tss_billing_type,\n\tss_billing_card,\n\tss_billing_check_account, \t \n\tss_billing_check_routing,\n\tDate_Format(ss_rebill_next_date,'%W %b %D %Y %H:%i:%s') as Next_Rebill_Date,\n\tss_rebill_amount,\n\tss_rebill_status,\n\tDate_Format(ss_last_rebill,'%W %b %D %Y %H:%i:%s') as Last_Rebill_Date,\n\treference_number as Last_Transaction,\n\t\n\n'Account Notes' as access_header,\n\tss_account_notes,\n\n'Cancel Subscription' as access_header,\n\tss_cancel_id,\n\t'' as cancel_subscription_select,\n\t'' as cancel_subscription_reason,\n\t'' as cancel_subscription\n", "cs_subscription\nleft join cs_transactiondetails on transactionID = ss_transaction_id\nleft join cs_rebillingdetails as rd on rd_subaccount = ss_rebill_ID\nleft join cs_company_sites as cs on cs_ID = ss_site_ID\n", "{$sql_where}", array('disable' => true, 'HideIfEmpty' => true)); if ($access == -1) { beginTable(); echo "Transaction Information was not found. Please try again."; endTable('Transaction Not Found', "lookup.php?{$link_info}", false, true); die; } $subscription = new transaction_class(false); $subscription->pull_subscription($access['Data']['ss_ID']['Value']); $access['Data']['ss_rebill_amount']['Value'] = '$' . formatMoney($access['Data']['ss_rebill_amount']['Value']); $access['Data']['ss_rebill_amount']['DisplayName'] = 'Next Rebill Amount'; if ($_POST['cancel_rebill'] && $access['Data']['ss_rebill_status']['Value'] == 'active') { if ($_POST['ss_rebill_status_text']) { $notes = quote_smart($_POST['ss_rebill_status_text'] . " - " . $_POST['cancel_subscription_reason']); $status = $subscription->process_cancel_request(array("actor" => '.NET', 'notes' => $notes)); if ($status) { $msg = "Subscription ID " . $subscription->row['subscriptionTable']['ss_subscription_ID'] . " cancelled (Ref ID: " . $status['ss_cancel_id'] . ")"; } else { $msg = "Subscription ID " . $subscription->row['subscriptionTable']['ss_subscription_ID'] . " failed to cancel."; } $access['Data']['ss_rebill_status']['Value'] = $subscription->row['subscriptionTable']['ss_rebill_status']; $access['Data']['ss_account_notes']['Value'] = $subscription->row['subscriptionTable']['ss_account_notes']; $access['Data']['ss_cancel_id']['Value'] = $subscription->row['subscriptionTable']['ss_cancel_id']; } else {