/**
* Entry point for the script
*
* @return void
*
* @since 2.5
*/
public function doExecute()
{
JFactory::getApplication('site');
JPluginHelper::importPlugin('redcore');
JPluginHelper::importPlugin('redpayment');
// Set up statuses that are in their final stage
$this->finalStatuses = array(RApiPaymentStatus::getStatusCompleted(), RApiPaymentStatus::getStatusCanceled_Reversal(), RApiPaymentStatus::getStatusDenied(), RApiPaymentStatus::getStatusExpired(), RApiPaymentStatus::getStatusRefunded(), RApiPaymentStatus::getStatusReversed());
$this->out('============================');
$this->out('Check Payments status change');
$this->out('============================');
$payments = $this->getPaymentsForChecking();
$this->out('Number of payments for checking:' . count($payments));
$this->out('============================');
if (!empty($payments)) {
foreach ($payments as $payment) {
// Print out payment info
$this->out('============================');
$this->out(sprintf('Check for order name "%s" for extension "%s" using "%s" payment plugin:', $payment->order_name, $payment->extension_name, $payment->payment_name));
$this->out('============================');
// Preform check
$status = RApiPaymentHelper::checkPayment($payment->id);
// Print out status result
foreach ($status as $statusKey => $message) {
if (is_array($message)) {
foreach ($status as $key => $value) {
$this->out($key . ': ' . $value);
}
} else {
$this->out($statusKey . ': ' . $message);
}
}
// Subtract retry count or reset it
$paymentNew = RApiPaymentHelper::getPaymentById($payment->id);
if (!in_array($paymentNew->status, $this->finalStatuses)) {
// We are still not done, we will subtract retry counter for this payment
$paymentNew->retry_counter -= 1;
RApiPaymentHelper::updatePaymentCounter($paymentNew->id, $paymentNew->retry_counter);
$this->out('Retry checks left: ' . $paymentNew->retry_counter);
}
$this->out('============================');
}
}
$this->out('============================');
$this->out('Done !');
}
/**
* Display method
*
* @param string $tpl The template name
*
* @return void
*/
public function display($tpl = null)
{
$model = $this->getModel();
$this->state = $model->getState();
$this->activeFilters = $model->getActiveFilters();
$this->filterForm = $model->getForm();
$filters = array();
$filters['status'] = RApiPaymentStatus::getStatusCompleted();
if ($filter = $this->state->get('filter.payment_name')) {
$filters['payment_name'] = $filter;
}
if ($filter = $this->state->get('filter.extension_name')) {
$filters['extension_name'] = $filter;
}
if ($startDate = $this->state->get('filter.start_date')) {
$filters['start_date'] = $startDate;
}
if ($endDate = $this->state->get('filter.end_date')) {
$filters['end_date'] = $endDate;
}
$this->viewType = $this->state->get('filter.dashboard_view_type');
$this->chartType = $this->state->get('filter.chart_type');
if (empty($this->viewType)) {
$this->viewType = RBootstrap::getConfig('payment_dashboard_view_type', 'payment_name');
$this->state->set('filter.dashboard_view_type', $this->viewType);
}
if (empty($this->chartType)) {
$this->chartType = RBootstrap::getConfig('payment_chart_type', 'Line');
$this->state->set('filter.chart_type', $this->chartType);
}
if ($this->viewType == 'status') {
unset($filters['status']);
}
$this->paymentData['chart'] = RApiPaymentHelper::getChartData($filters, 7, $this->viewType);
$filters['start_date'] = date('Y-01-01', strtotime('today -1 year'));
$filters['end_date'] = date('Y-m-d', strtotime('today'));
$filters['status'] = RApiPaymentStatus::getStatusCompleted();
$this->paymentData['overall'] = RApiPaymentHelper::getChartData($filters, 7, 'all');
$this->chartData = RApiPaymentHelper::prepareChartData($this->paymentData['chart'], $this->chartType);
parent::display($tpl);
}
/**
* Update payment status
*
* @param int $paymentId Id of the payment
*
* @return mixed
*
* @since 1.5
*/
public static function updatePaymentStatus($paymentId)
{
if (empty($paymentId)) {
return false;
}
$db = JFactory::getDbo();
$query = $db->getQuery(true)->select('pl.*')->from($db->qn('#__redcore_payment_log', 'pl'))->where('pl.payment_id = ' . (int) $paymentId)->order('pl.created_date ASC');
$db->setQuery($query);
$paymentLogs = $db->loadObjectList();
if ($paymentLogs) {
$paymentOriginal = self::getPaymentById($paymentId);
$payment = JArrayHelper::fromObject($paymentOriginal);
$customerNote = array();
$amountPaid = 0;
$currency = '';
$status = RApiPaymentStatus::getStatusCreated();
foreach ($paymentLogs as $paymentLog) {
if ($paymentLog->status == RApiPaymentStatus::getStatusCompleted()) {
if (!empty($currency) && $currency != $paymentLog->currency) {
// We have a problem. Two different confirmed payments but in different currencies.
// We will only set latest payment data
$amountPaid = $paymentLog->amount;
$currency = $paymentLog->currency;
} else {
if ($payment['transaction_id'] != $paymentLog->transaction_id || $amountPaid == 0) {
$amountPaid += $paymentLog->amount;
}
if (!empty($paymentLog->currency)) {
$currency = $paymentLog->currency;
}
}
$payment['coupon_code'] = $paymentLog->coupon_code;
$payment['confirmed_date'] = $paymentLog->created_date;
}
if (!empty($paymentLog->transaction_id)) {
$payment['transaction_id'] = $paymentLog->transaction_id;
}
// We will take customer note from every log but not duplicates
if (!empty($paymentLog->customer_note) && !in_array($paymentLog->customer_note, $customerNote)) {
$customerNote[] = $paymentLog->customer_note;
}
$status = RApiPaymentStatus::changeStatus($status, $paymentLog->status);
// Handle statuses that subtract paid amount
if (in_array($status, array(RApiPaymentStatus::getStatusRefunded(), RApiPaymentStatus::getStatusReversed()))) {
$amountPaid -= $paymentLog->amount;
if ($amountPaid < 0) {
$amountPaid = 0;
}
}
}
$payment['amount_paid'] = $amountPaid;
$payment['customer_note'] = implode("\r\n", $customerNote);
if ($status == RApiPaymentStatus::getStatusCompleted() && $payment['amount_paid'] != $payment['amount_total']) {
$status = RApiPaymentStatus::getStatusPending();
}
$payment['status'] = $status;
if (empty($payment['currency'])) {
$payment['currency'] = $currency;
}
// Currency should not be numeric
if (!empty($payment['currency']) && is_numeric($payment['currency'])) {
$payment['currency'] = RHelperCurrency::getIsoCode($payment['currency']);
}
if (!self::updatePaymentData($payment)) {
return false;
}
// If we changed status we need to call extension helper file to trigger its update method
if ($paymentOriginal->status != $payment['status']) {
$paymentNew = self::getPaymentById($paymentId);
self::triggerExtensionHelperMethod($paymentNew->extension_name, 'paymentStatusChanged', $paymentOriginal, $paymentNew);
}
}
return true;
}
/**
* Handle the reception of notification from the payment gateway
*
* @param string $extensionName Name of the extension
* @param string $ownerName Name of the owner
* @param array $data Data to fill out Payment form
* @param array &$logData Log data for payment api
*
* @return bool paid status
*/
public function handleCallback($extensionName, $ownerName, $data, &$logData)
{
$post = JFactory::getApplication()->input->post->getArray();
$postData = array();
// Read the post from PayPal system and add 'cmd'
$postData[] = 'cmd=_notify-validate';
foreach ($post as $key => $value) {
$value = urlencode(stripslashes($value));
$postData[] = "{$key}={$value}";
}
$request = implode('&', $postData);
$response = $this->getRequestFromGateway($request);
if (strcmp($response, "VERIFIED") == 0) {
/* Check the payment_status is Completed
check that txn_id has not been previously processed
check that receiver_email is your Primary PayPal email
check that payment_amount/payment_currency are correct */
$payment = $this->getPaymentByExtensionOrderData($extensionName, $data);
if ($post['mc_gross'] != $payment->amount_total) {
$statusText = JText::sprintf('LIB_REDCORE_PAYMENT_ERROR_PRICE_MISMATCH', $extensionName, $this->paymentName, $payment->amount_total, $post['mc_gross']);
RApiPaymentHelper::logToFile($this->paymentName, $extensionName, $data, $isValid = false, $statusText);
$logData['status'] = RApiPaymentStatus::getStatusCreated();
$logData['message_text'] = $statusText;
return false;
} elseif ($post['mc_currency'] != $payment->currency) {
$statusText = JText::sprintf('LIB_REDCORE_PAYMENT_ERROR_CURRENCY_MISMATCH', $extensionName, $this->paymentName, $payment->currency, $post['mc_currency']);
RApiPaymentHelper::logToFile($this->paymentName, $extensionName, $data, $isValid = false, $statusText);
$logData['status'] = RApiPaymentStatus::getStatusCreated();
$logData['message_text'] = $statusText;
return false;
}
// We are clear to log successful payment log now
// Paypal have very similar structure of Status response so we can actually get them directly
$logData['status'] = RApiPaymentStatus::getStatus($post['payment_status']);
if ($logData['status'] == RApiPaymentStatus::getStatusCompleted()) {
$statusText = JText::sprintf('LIB_REDCORE_PAYMENT_SUCCESSFUL', $extensionName, $this->paymentName);
} else {
$statusText = JText::sprintf('LIB_REDCORE_PAYMENT_CALLBACK_STATUS', $extensionName, $logData['status'], $this->paymentName);
}
RApiPaymentHelper::logToFile($this->paymentName, $extensionName, $data, $isValid = true, $statusText);
} elseif (strcmp($response, "INVALID") == 0) {
$statusText = JText::sprintf('LIB_REDCORE_PAYMENT_ERROR_IN_PAYMENT_GATEWAY', $extensionName, $this->paymentName, 'INVALID IPN');
RApiPaymentHelper::logToFile($this->paymentName, $extensionName, $data, $isValid = false, $statusText);
$logData['status'] = RApiPaymentStatus::getStatusCreated();
$logData['message_text'] = $statusText;
return false;
} else {
$statusText = JText::sprintf('LIB_REDCORE_PAYMENT_ERROR_IN_PAYMENT_GATEWAY', $extensionName, $this->paymentName, 'HTTP ERROR');
RApiPaymentHelper::logToFile($this->paymentName, $extensionName, $data, $isValid = false, $statusText);
$logData['status'] = RApiPaymentStatus::getStatusCreated();
$logData['message_text'] = $statusText;
return false;
}
$logData['message_text'] = $statusText;
$logData['currency'] = $payment->currency;
$logData['amount'] = $payment->amount_total;
$logData['transaction_id'] = $data['txn_id'];
return true;
}
