if (!$testonly) { $result = mysql_query($sql, $cnn_cs) or dieLog(mysql_errno() . ": " . mysql_error() . "<br>Cannot execute query"); } $nextRecurCharge = $transactionInfo['chargeAmount']; $suboutput .= "Old Transaction Rebilling Disabled.\n\r"; $newTransId = $response['transactionId']; $suboutput .= "New Transaction (ID={$newTransId}) Created Successfully.\n\r"; $suboutput .= "Customer Charged successfully.\n\r"; } else { $try_again_date = date("Y-m-d", time() + 1 * 60 * 60 * 24); $newTransId = $response['transactionId']; $sql = "UPDATE `cs_transactiondetails` SET `td_recur_next_date` = '{$try_again_date}', `td_recur_processed` = '0', `td_recur_attempts` = `td_recur_attempts`+1 WHERE `transactionId` = '{$oldTransId}' LIMIT 1"; if (!$testonly) { $result = mysql_query($sql, $cnn_cs) or dieLog(mysql_errno() . ": " . mysql_error() . "<br>Cannot execute query"); } $suboutput .= "Transaction Declined (ID={$newTransId}), Error: " . $response['errormsg']; if (intval($transaction['td_recur_attempts']) >= $attempts_max) { $suboutput .= "No more rebilling attempts. Attempt #" . intval($transaction['td_recur_attempts']) . " >= {$attempts_max}.\n\r"; sendTransactionEmail($newTransId, "customer_rebill_decline_confirmation", $testonly); } else { $suboutput .= "Will try billing again on {$try_again_date}. Attempt #" . intval($transaction['td_recur_attempts']) . "\n\r"; } } //die($sql); // Charge customer here. } } toLog('rebill', 'system', $suboutput, $newTransId); $output .= $suboutput; } print nl2br($output);
<?php die; include 'includes/sessioncheckuser.php'; require_once "includes/dbconnection.php"; $headerInclude = "transactions"; include 'includes/header.php'; require_once 'includes/function.php'; beginTable(); ?> <table border="1" cellspacing="0" width="100%" class="report" cellpadding="3"> <?php $sessionlogin = isset($HTTP_SESSION_VARS["sessionlogin"]) ? $HTTP_SESSION_VARS["sessionlogin"] : ""; if ($_POST['action'] && $_POST['refid']) { echo "<tr><td align='center' colspan='2'>"; $res = sendTransactionEmail($_POST['refid'], $_POST['action'], $_POST['testmode'], 'reference_number'); echo "<h3>E-Mail Sent To:</h3><table>"; foreach ($res as $email) { echo "<tr><td>" . $email['email'] . "</td><td> </td><td>" . $email['copy'] . "</td></tr>"; } echo "</table>"; } ?> <tr> <td width="50%"><b>Enter Transaction Reference ID: </b></input></td> <td width="50%"><input type=text name="refid"></td> </tr> <tr> <td width="50%"> <b>Select Notification: </b></td>