<?php
class ControllerPaymentPPExpress extends Controller {
	private $error = array();

	public function index() {
		$this->load->language('payment/pp_express');

		$this->document->setTitle($this->language->get('heading_title'));

		$this->load->model('setting/setting');
    $this->load->model('setting/extension');
    $this->load->model('payment/pp_express');

    $this->document->addScript(array(
      'view/javascript/ckeditor/ckeditor.js'
    ));

    $this->document->addTypesForJs(array(
      Type_ImageUpload::getTypeForJs(),
    ));

    $this->data['config_adm_ssl'] = $this->config->get('config_adm_ssl');

    $this->data['Type_DisplayModuleOption'] = $this->load->typeForTwig('Type_DisplayModuleOption');

    $this->data['ftr_geral'] = new ftr_geral();

    $this->error = array();

		if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validate()) {
            unset($this->request->post['pp_express_module']);

			$this->model_setting_setting->editSetting('pp_express', $this->request->post);

			$this->session->data['success'] = $this->language->get('text_success');

			$this->redirect($this->url->linkAnchor('extension/module', 'token=' . $this->session->data['token'], 'tab-info=' . $this->request->get['type'], 'SSL'));
		} else {
            $this->data['error'] = @$this->error;
        }

		$this->data['heading_title'] = $this->language->get('heading_title');

        $this->data['text_image_manager'] = $this->language->get('text_image_manager');

		$this->data['text_enabled'] = $this->language->get('text_enabled');
		$this->data['text_disabled'] = $this->language->get('text_disabled');
		$this->data['text_all_zones'] = $this->language->get('text_all_zones');
		$this->data['text_yes'] = $this->language->get('text_yes');
		$this->data['text_no'] = $this->language->get('text_no');
		$this->data['text_authorization'] = $this->language->get('text_authorization');
		$this->data['text_sale'] = $this->language->get('text_sale');
		$this->data['text_clear'] = $this->language->get('text_clear');
    $this->data['text_browse'] = $this->language->get('text_browse');

    $this->data['text_module_info'] = $this->language->get('text_module_info');
    $this->data['text_module_sub_info'] = $this->language->get('text_module_sub_info');

		$this->data['entry_username'] = $this->language->get('entry_username');
		$this->data['entry_password'] = $this->language->get('entry_password');
		$this->data['entry_signature'] = $this->language->get('entry_signature');
		$this->data['entry_test'] = $this->language->get('entry_test');
		$this->data['entry_debug'] = $this->language->get('entry_debug');
		$this->data['entry_method'] = $this->language->get('entry_method');
    $this->data['entry_total'] = $this->language->get('entry_total');
    $this->data['entry_total_obs'] = $this->language->get('entry_total_obs');
		$this->data['entry_geo_zone'] = $this->language->get('entry_geo_zone');
		$this->data['entry_status'] = $this->language->get('entry_status');
		$this->data['entry_sort_order'] = $this->language->get('entry_sort_order');
		$this->data['entry_icon_sort_order'] = $this->language->get('entry_icon_sort_order');
        $this->data['entry_display'] = $this->language->get('entry_display');
        $this->data['entry_title'] = $this->language->get('entry_title');

        $this->data['entry_canceled_reversal_status'] = $this->language->get('entry_canceled_reversal_status');
        $this->data['entry_completed_status'] = $this->language->get('entry_completed_status');
        $this->data['entry_denied_status'] = $this->language->get('entry_denied_status');
        $this->data['entry_expired_status'] = $this->language->get('entry_expired_status');
        $this->data['entry_failed_status'] = $this->language->get('entry_failed_status');
        $this->data['entry_pending_status'] = $this->language->get('entry_pending_status');
        $this->data['entry_processed_status'] = $this->language->get('entry_processed_status');
        $this->data['entry_refunded_status'] = $this->language->get('entry_refunded_status');
        $this->data['entry_refunded_partially_status'] = $this->language->get('entry_refunded_partially_status');
        $this->data['entry_reversed_status'] = $this->language->get('entry_reversed_status');
        $this->data['entry_voided_status'] = $this->language->get('entry_voided_status');

        $this->data['tab_general'] = $this->language->get('tab_general');
        $this->data['tab_order_status'] = $this->language->get('tab_order_status');
        $this->data['tab_api_details'] = $this->language->get('tab_api_details');
        $this->data['tab_customise'] = $this->language->get('tab_customise');

        $this->data['entry_display_checkout'] = $this->language->get('entry_display_checkout');
        $this->data['entry_logo'] = $this->language->get('entry_logo');
        $this->data['entry_logo_obs'] = $this->language->get('entry_logo_obs');

        $this->data['help_encryption'] = $this->language->get('help_encryption');

		$this->data['button_save'] = $this->language->get('button_save');
    $this->data['button_cancel'] = $this->language->get('button_cancel');
    $this->data['button_help'] = $this->language->get('button_help');

    $this->data['text_ipn'] = $this->language->get('text_ipn');
    $this->data['text_ipn_obs'] = $this->language->get('text_ipn_obs');
		$this->data['text_ipn_url'] = $this->config->get('config_ssl').'index.php?route=payment/pp_express/ipn';

		$this->data['breadcrumbs'] = array();

   		$this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('text_home'),
            'href'      => $this->url->link('common/home', 'token=' . $this->session->data['token'], 'SSL'),
            'separator' => false
   		);

   		$this->data['breadcrumbs'][] = array(
       		'text'      => $this->language->get('text_payment'),
			'href'      => $this->url->linkAnchor('extension/module', 'token=' . $this->session->data['token'], 'tab-info=' . $this->request->get['type'], 'SSL'),
      		'separator' => ' :: '
   		);

   		$this->data['breadcrumbs'][] = array(
       		'text'      => $this->language->get('heading_title'),
			'href'      => $this->url->link('payment/pp_express', 'token=' . $this->session->data['token'] . '&type=' . $this->request->get['type'], 'SSL'),
      		'separator' => ' :: '
   		);

        //button actions
		$this->data['action'] = $this->url->link('payment/pp_express', 'token=' . $this->session->data['token'] . '&type=' . $this->request->get['type'], 'SSL');
		$this->data['cancel'] = $this->url->linkAnchor('extension/module', 'token=' . $this->session->data['token'], 'tab-info=' . $this->request->get['type'], 'SSL');

        if (isset($this->request->post['pp_express_username'])) {
			$this->data['pp_express_username'] = $this->request->post['pp_express_username'];
		} else {
			$this->data['pp_express_username'] = $this->config->get('pp_express_username');
		}

		if (isset($this->request->post['pp_express_password'])) {
			$this->data['pp_express_password'] = $this->request->post['pp_express_password'];
		} else {
			$this->data['pp_express_password'] = $this->config->get('pp_express_password');
		}

		if (isset($this->request->post['pp_express_signature'])) {
			$this->data['pp_express_signature'] = $this->request->post['pp_express_signature'];
		} else {
			$this->data['pp_express_signature'] = $this->config->get('pp_express_signature');
        }

		if (isset($this->request->post['pp_express_title'])) {
			$this->data['pp_express_title'] = $this->request->post['pp_express_title'];
		} else {
			$this->data['pp_express_title'] = $this->config->get('pp_express_title');
		}

		if (isset($this->request->post['pp_express_test'])) {
			$this->data['pp_express_test'] = $this->request->post['pp_express_test'];
		} else {
			$this->data['pp_express_test'] = $this->config->get('pp_express_test');
		}

		if (isset($this->request->post['pp_express_method'])) {
			$this->data['pp_express_method'] = $this->request->post['pp_express_method'];
		} else {
			$this->data['pp_express_method'] = $this->config->get('pp_express_method');
		}

		if (isset($this->request->post['pp_express_total'])) {
			$this->data['pp_express_total'] = $this->request->post['pp_express_total'];
		} else {
			$this->data['pp_express_total'] = $this->config->get('pp_express_total');
		}

        if (isset($this->request->post['pp_express_debug'])) {
            $this->data['pp_express_debug'] = $this->request->post['pp_express_debug'];
        } else {
            $this->data['pp_express_debug'] = $this->config->get('pp_express_debug');
        }

        $this->data['currency_codes'] = $this->model_payment_pp_express->currencyCodes();

        $this->load->model('localisation/order_status');

        $this->data['order_statuses'] = $this->model_localisation_order_status->getOrderStatuses();

        if (isset($this->request->post['pp_express_canceled_reversal_status_id'])) {
            $this->data['pp_express_canceled_reversal_status_id'] = $this->request->post['pp_express_canceled_reversal_status_id'];
        } else {
            $this->data['pp_express_canceled_reversal_status_id'] = $this->config->get('pp_express_canceled_reversal_status_id');
        }

        if (isset($this->request->post['pp_express_completed_status_id'])) {
            $this->data['pp_express_completed_status_id'] = $this->request->post['pp_express_completed_status_id'];
        } else {
            $this->data['pp_express_completed_status_id'] = $this->config->get('pp_express_completed_status_id');
        }

        if (isset($this->request->post['pp_express_denied_status_id'])) {
            $this->data['pp_express_denied_status_id'] = $this->request->post['pp_express_denied_status_id'];
        } else {
            $this->data['pp_express_denied_status_id'] = $this->config->get('pp_express_denied_status_id');
        }

        if (isset($this->request->post['pp_express_expired_status_id'])) {
            $this->data['pp_express_expired_status_id'] = $this->request->post['pp_express_expired_status_id'];
        } else {
            $this->data['pp_express_expired_status_id'] = $this->config->get('pp_express_expired_status_id');
        }

        if (isset($this->request->post['pp_express_failed_status_id'])) {
            $this->data['pp_express_failed_status_id'] = $this->request->post['pp_express_failed_status_id'];
        } else {
            $this->data['pp_express_failed_status_id'] = $this->config->get('pp_express_failed_status_id');
        }

        if (isset($this->request->post['pp_express_pending_status_id'])) {
            $this->data['pp_express_pending_status_id'] = $this->request->post['pp_express_pending_status_id'];
        } else {
            $this->data['pp_express_pending_status_id'] = $this->config->get('pp_express_pending_status_id');
        }

        if (isset($this->request->post['pp_express_processed_status_id'])) {
            $this->data['pp_express_processed_status_id'] = $this->request->post['pp_express_processed_status_id'];
        } else {
            $this->data['pp_express_processed_status_id'] = $this->config->get('pp_express_processed_status_id');
        }

        if (isset($this->request->post['pp_express_refunded_status_id'])) {
            $this->data['pp_express_refunded_status_id'] = $this->request->post['pp_express_refunded_status_id'];
        } else {
            $this->data['pp_express_refunded_status_id'] = $this->config->get('pp_express_refunded_status_id');
        }

        if (isset($this->request->post['pp_express_refunded_partially_status_id'])) {
            $this->data['pp_express_refunded_partially_status_id'] = $this->request->post['pp_express_refunded_partially_status_id'];
        } else {
            $this->data['pp_express_refunded_partially_status_id'] = $this->config->get('pp_express_refunded_partially_status_id');
        }

        if (isset($this->request->post['pp_express_reversed_status_id'])) {
            $this->data['pp_express_reversed_status_id'] = $this->request->post['pp_express_reversed_status_id'];
        } else {
            $this->data['pp_express_reversed_status_id'] = $this->config->get('pp_express_reversed_status_id');
        }

        if (isset($this->request->post['pp_express_voided_status_id'])) {
            $this->data['pp_express_voided_status_id'] = $this->request->post['pp_express_voided_status_id'];
        } else {
            $this->data['pp_express_voided_status_id'] = $this->config->get('pp_express_voided_status_id');
        }

        if (isset($this->request->post['pp_express_logo'])) {
            $this->data['pp_express_logo'] = $this->request->post['pp_express_logo'];
        } else {
            $this->data['pp_express_logo'] = $this->config->get('pp_express_logo');
        }

				if (isset($this->request->post['pp_express_display'])) {
					$this->data['pp_express_display'] = $this->request->post['pp_express_display'];
				} else {
					$this->data['pp_express_display'] = $this->config->get('pp_express_display');
				}

        $this->load->dmodel('tool/image');

        $logo = $this->config->get('pp_express_logo');

        if (isset($this->request->post['pp_express_logo']) && file_exists(DIR_IMAGE . $this->request->post['pp_express_logo'])) {
            $this->data['thumb'] = $this->dmodel_tool_image->resize($this->request->post['pp_express_logo'], 100, 100);
        }elseif(($logo != '') && file_exists(DIR_IMAGE . $logo)) {
            $this->data['thumb'] = $this->dmodel_tool_image->resize($logo, 100, 100);
        } else {
            $this->data['thumb'] = $this->dmodel_tool_image->resize('no_image.jpg', 100, 100);
        }

        $this->data['no_image'] = $this->dmodel_tool_image->resize('no_image.jpg', 100, 100);

        if (isset($this->request->post['pp_express_geo_zone_id'])) {
			$this->data['pp_express_geo_zone_id'] = $this->request->post['pp_express_geo_zone_id'];
		} else {
			$this->data['pp_express_geo_zone_id'] = $this->config->get('pp_express_geo_zone_id');
		}

		$this->load->model('localisation/geo_zone');

		$this->data['geo_zones'] = $this->model_localisation_geo_zone->getGeoZones();

		if (isset($this->request->post['pp_express_status'])) {
			$this->data['pp_express_status'] = $this->request->post['pp_express_status'];
		} else {
			$this->data['pp_express_status'] = $this->config->get('pp_express_status');
		}

		if (isset($this->request->post['pp_express_sort_order'])) {
			$this->data['pp_express_sort_order'] = $this->request->post['pp_express_sort_order'];
		} else {
			$this->data['pp_express_sort_order'] = $this->config->get('pp_express_sort_order');
		}

        $this->data['token'] = $this->session->data['token'];

		$this->children = array(
			'common/header',
			'common/footer'
		);
		$this->response->setOutput($this->render('payment/pp_express'));
	}

    public function imageLogo() {
        $this->load->dmodel('tool/image');

        if (isset($this->request->get['image'])) {
            $this->response->setOutput($this->dmodel_tool_image->resize(html_entity_decode($this->request->get['image'], ENT_QUOTES, 'UTF-8'), 750, 90));
        }
    }

	protected function validate() {
		if (!$this->user->hasPermission('modify', 'payment/pp_express')) {
			$this->error['warning'] = $this->language->get('error_permission');
		}

		if (empty($this->request->post['pp_express_username'])) {
			$this->error['username'] = $this->language->get('error_username');
		}

		if (empty($this->request->post['pp_express_password'])) {
			$this->error['password'] = $this->language->get('error_password');
		}

        if (empty($this->request->post['pp_express_signature'])) {
            $this->error['signature'] = $this->language->get('error_signature');
        }

		if (!$this->error) {
			return true;
		} else {
			return false;
		}
	}

    public function resend() {
            $this->load->model('payment/pp_express');
            $this->load->language('payment/pp_express');

            $json = array();

            if (isset($this->request->get['paypal_order_transaction_id'])) {
                $transaction = $this->model_payment_pp_express->getFailedTransaction($this->request->get['paypal_order_transaction_id']);

                if ($transaction) {
                    $call_data = unserialize($transaction['call_data']);

                    $result = $this->model_payment_pp_express->call($call_data);

                    if ($result) {

                        $parent_transaction = $this->model_payment_pp_express->getLocalTransaction($transaction['parent_transaction_id']);

                        if ($parent_transaction['amount'] == abs($transaction['amount'])) {
                            $this->db->query("UPDATE `" . DB_PREFIX . "paypal_order_transaction` SET `payment_status` = 'Refunded' WHERE `transaction_id` = '" . $this->db->escape($transaction['parent_transaction_id']) . "' LIMIT 1");
                        } else {
                            $this->db->query("UPDATE `" . DB_PREFIX . "paypal_order_transaction` SET `payment_status` = 'Partially-Refunded' WHERE `transaction_id` = '" . $this->db->escape($transaction['parent_transaction_id']) . "' LIMIT 1");
                        }

                        if (isset($result['REFUNDTRANSACTIONID'])) {
                            $transaction['transaction_id'] = $result['REFUNDTRANSACTIONID'];
                        } else {
                            $transaction['transaction_id'] = $result['TRANSACTIONID'];
                        }

                        if (isset($result['PAYMENTTYPE'])) {
                            $transaction['payment_type'] = $result['PAYMENTTYPE'];
                        } else {
                            $transaction['payment_type'] = $result['REFUNDSTATUS'];
                        }

                        if (isset($result['PAYMENTSTATUS'])) {
                            $transaction['payment_status'] = $result['PAYMENTSTATUS'];
                        } else {
                            $transaction['payment_status'] = 'Refunded';
                        }

                        if (isset($result['AMT'])) {
                            $transaction['amount'] = $result['AMT'];
                        } else {
                            $transaction['amount'] = $transaction['amount'];
                        }

                        $transaction['pending_reason'] = (isset($result['PENDINGREASON']) ? $result['PENDINGREASON'] : '');

                        $this->model_payment_pp_express->updateTransaction($transaction);

                        $json['success'] = $this->language->get('success_transaction_resent');
                    } else {
                        $json['error'] = $this->language->get('error_timeout');
                    }
                } else {
                    $json['error'] = $this->language->get('error_transaction_missing');
                }
            } else {
                $json['error'] = $this->language->get('error_data');
            }

            $this->response->setOutput(json_encode($json));
        }

    public function capture() {
        $this->load->language('payment/pp_express');
        /**
         * used to capture authorised payments
         *
         * capture can be full or partial amounts
         */
        if(isset($this->request->post['order_id']) && $this->request->post['amount'] > 0 && isset($this->request->post['order_id']) && isset($this->request->post['complete'])) {

            $this->load->model('payment/pp_express');

            $paypal_order = $this->model_payment_pp_express->getOrder($this->request->post['order_id']);

            if($this->request->post['complete'] == 1) {
                $complete = 'Complete';
            } else {
                $complete = 'NotComplete';
            }

            $call_data = array();
            $call_data['METHOD'] = 'DoCapture';
            $call_data['AUTHORIZATIONID'] = $paypal_order['authorization_id'];
            $call_data['AMT'] = number_format($this->request->post['amount'], 2);
            $call_data['CURRENCYCODE'] = $paypal_order['currency_code'];
            $call_data['COMPLETETYPE'] = $complete;
            $call_data['MSGSUBID'] = uniqid(mt_rand(), true);

            $result = $this->model_payment_pp_express->call($call_data);

            $transaction = array(
                'paypal_order_id' => $paypal_order['paypal_order_id'],
                'transaction_id' => '',
                'parent_transaction_id' => $paypal_order['authorization_id'],
                'note' => '',
                'msgsubid' => $call_data['MSGSUBID'],
                'receipt_id' => '',
                'payment_type' => '',
                'payment_status' => '',
                'pending_reason' => '',
                'transaction_entity' => 'payment',
                'amount' => '',
                'debug_data' => json_encode($result),
            );

            if ($result == false) {
                $transaction['amount'] = number_format($this->request->post['amount'], 2);
                $paypal_order_transaction_id = $this->model_payment_pp_express->addTransaction($transaction, $call_data);

                $json['error'] = true;

                $json['failed_transaction']['paypal_order_transaction_id'] = $paypal_order_transaction_id;
                $json['failed_transaction']['amount'] = $transaction['amount'];
                $json['failed_transaction']['created'] = date("Y-m-d H:i:s");

                $json['msg'] = $this->language->get('error_timeout');
            } else if(isset($result['ACK']) && $result['ACK'] != 'Failure' && $result['ACK'] != 'FailureWithWarning') {
                $transaction['transaction_id'] = $result['TRANSACTIONID'];
                $transaction['payment_type'] = $result['PAYMENTTYPE'];
                $transaction['payment_status'] = $result['PAYMENTSTATUS'];
                $transaction['pending_reason'] = (isset($result['PENDINGREASON']) ? $result['PENDINGREASON'] : '');
                $transaction['amount'] = $result['AMT'];

                $this->model_payment_pp_express->addTransaction($transaction);

                unset($transaction['debug_data']);
                $transaction['created'] = date("Y-m-d H:i:s");

                $captured = number_format($this->model_payment_pp_express->totalCaptured($paypal_order['paypal_order_id']), 2);
                $refunded = number_format($this->model_payment_pp_express->totalRefundedOrder($paypal_order['paypal_order_id']), 2);

                $transaction['captured'] = $captured;
                $transaction['refunded'] = $refunded;
                $transaction['remaining'] = number_format($paypal_order['total'] - $captured, 2);

                $transaction['status'] = 0;
                if($transaction['remaining'] == 0.00) {
                    $transaction['status'] = 1;
                    $this->model_payment_pp_express->updateOrder('Complete', $this->request->post['order_id']);
                }

                $transaction['void'] = '';

                if($this->request->post['complete'] == 1 && $transaction['remaining'] > 0) {
                    $transaction['void'] = array(
                        'paypal_order_id' => $paypal_order['paypal_order_id'],
                        'transaction_id' => '',
                        'parent_transaction_id' => $paypal_order['authorization_id'],
                        'note' => '',
                        'msgsubid' => '',
                        'receipt_id' => '',
                        'payment_type' => '',
                        'payment_status' => 'Void',
                        'pending_reason' => '',
                        'amount' => '',
                        'debug_data' => 'Voided after capture',
                        'transaction_entity' => 'auth',
                    );

                    $this->model_payment_pp_express->addTransaction($transaction['void']);
                    $this->model_payment_pp_express->updateOrder('Complete', $this->request->post['order_id']);
                    $transaction['void']['created'] = date("Y-m-d H:i:s");
                    $transaction['status'] = 1;
                }

                $json['data'] = $transaction;
                $json['error'] = false;
                $json['msg'] = 'Ok';
            } else {
                $json['error'] = true;
                $json['msg'] = (isset($result['L_SHORTMESSAGE0']) ? $result['L_SHORTMESSAGE0'] : 'There was an error');
            }
        } else {
            $json['error'] = true;
            $json['msg'] = 'Missing data';
        }

        $this->response->setOutput(json_encode($json));
    }

    public function void() {
        /**
         * used to void an authorised payment
         */
        if(isset($this->request->post['order_id']) && $this->request->post['order_id'] != '') {
            $this->load->model('payment/pp_express');

            $paypal_order = $this->model_payment_pp_express->getOrder($this->request->post['order_id']);

            $call_data = array();
            $call_data['METHOD'] = 'DoVoid';
            $call_data['AUTHORIZATIONID'] = $paypal_order['authorization_id'];

            $result = $this->model_payment_pp_express->call($call_data);

            if($result['ACK'] != 'Failure' && $result['ACK'] != 'FailureWithWarning') {
                $transaction = array(
                    'paypal_order_id' => $paypal_order['paypal_order_id'],
                    'transaction_id' => '',
                    'parent_transaction_id' => $paypal_order['authorization_id'],
                    'note' => '',
                    'msgsubid' => '',
                    'receipt_id' => '',
                    'payment_type' => 'void',
                    'payment_status' => 'Void',
                    'pending_reason' => '',
                    'transaction_entity' => 'auth',
                    'amount' => '',
                    'debug_data' => json_encode($result),
                );

                $this->model_payment_pp_express->addTransaction($transaction);
                $this->model_payment_pp_express->updateOrder('Complete', $this->request->post['order_id']);

                unset($transaction['debug_data']);
                $transaction['created'] = date("Y-m-d H:i:s");

                $json['data'] = $transaction;
                $json['error'] = false;
                $json['msg'] = 'Transaction void';
            } else {
                $json['error'] = true;
                $json['msg'] = (isset($result['L_SHORTMESSAGE0']) ? $result['L_SHORTMESSAGE0'] : 'There was an error');
            }
        } else {
            $json['error'] = true;
            $json['msg'] = 'Missing data';
        }

        $this->response->setOutput(json_encode($json));
    }

    public function refund() {

        $this->load->language('payment/pp_express_refund');

        $this->document->addScript(array(
          'view/javascript/payment-pp-express-refund.js'
        ));

        $this->document->setTitle($this->language->get('heading_title'));

        $this->data['heading_title'] = $this->language->get('heading_title');
        $this->data['btn_cancel'] = $this->language->get('btn_cancel');
        $this->data['entry_transaction_id'] = $this->language->get('entry_transaction_id');
        $this->data['entry_full_refund'] = $this->language->get('entry_full_refund');
        $this->data['entry_amount'] = $this->language->get('entry_amount');
        $this->data['entry_message'] = $this->language->get('entry_message');
        $this->data['btn_refund'] = $this->language->get('btn_refund');

        if(isset($this->request->get['order_id'])){
            $getOrderId = '&order_id='.$this->request->get['order_id'].'&tabs=tab-payment';
        }else{
            $getOrderId = '';
        }

        $this->data['breadcrumbs'] = array();

        $this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('text_home'),
            'href'      => $this->url->link('common/home', 'token=' . $this->session->data['token'], 'SSL'),
            'separator' => false
        );

        $this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('text_order'),
            'href'      => $this->url->link('sale/order/info', 'token='.$this->session->data['token'].$getOrderId, 'SSL'),
            'separator' => ' :: '
        );

        $this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('heading_title'),
            'href'      => $this->url->link('payment/pp_express/refund', 'token='.$this->session->data['token'].$getOrderId.'&type='.$this->request->get['type'].'&transaction_id='.$this->request->get['transaction_id'], 'SSL'),
            'separator' => ' :: '
        );

        //button actions
        $this->data['action'] = $this->url->link('payment/pp_express/doRefund', 'token='.$this->session->data['token'].'&type='.$this->request->get['type'].$getOrderId , 'SSL');
        $this->data['cancel'] = $this->url->link('sale/order/info', 'token='.$this->session->data['token'].$getOrderId, 'SSL');

        $this->data['transaction_id'] = $this->request->get['transaction_id'];

        $this->load->model('payment/pp_express');
        $pp_transaction = $this->model_payment_pp_express->getTransaction($this->request->get['transaction_id']);

        $this->data['amount_original'] = $pp_transaction['AMT'];
        $this->data['currency_code'] = $pp_transaction['CURRENCYCODE'];

        $refunded = number_format($this->model_payment_pp_express->totalRefundedTransaction($this->request->get['transaction_id']), 2);

        if($refunded != 0.00) {
            $this->data['refund_available'] = number_format($this->data['amount_original'] + $refunded, 2);
            $this->data['attention'] = $this->language->get('text_current_refunds').': '.$this->data['refund_available'];
        } else {
            $this->data['refund_available'] = '';
            $this->data['attention'] = '';
        }

        $this->data['token'] = $this->session->data['token'];

        if(isset($this->session->data['error'])) {
            $this->data['error'] = $this->session->data['error'];
            unset($this->session->data['error']);
        } else {
            $this->data['error'] = '';
        }

        $this->children = array(
            'common/header',
            'common/footer'
        );
        $this->response->setOutput($this->render('payment/pp_express_refund'));
    }

    public function doRefund() {
        /**
         * used to issue a refund for a captured payment
         *
         * refund can be full or partial
         */
        if(isset($this->request->post['transaction_id']) && isset($this->request->post['refund_full'])) {

            if(isset($this->request->get['order_id'])){
                $getOrderId = '&order_id='.$this->request->get['order_id'].'&tabs=tab-payment';
            }else{
                $getOrderId = '';
            }

            $this->load->model('payment/pp_express');
            $this->load->language('payment/pp_express_refund');
            $this->load->model('sale/order');
            $this->load->dmodel('checkout/order');

            if($this->request->post['refund_full'] == 0 && str_replace(',','.', $this->request->post['amount']) == 0) {
                $this->session->data['error'] = $this->language->get('error_partial_amt');
                $this->redirect($this->url->link('payment/pp_express/refund', 'token=' . $this->session->data['token'] . '&transaction_id=' . $this->request->post['transaction_id'].'&type='.$this->request->get['type'], 'SSL'));
            } else {
                $order_id = $this->model_payment_pp_express->getOrderId($this->request->post['transaction_id']);
                $paypal_order = $this->model_payment_pp_express->getOrder($order_id);

                if ($paypal_order) {
                    $call_data = array();
                    $call_data['METHOD'] = 'RefundTransaction';
                    $call_data['TRANSACTIONID'] = $this->request->post['transaction_id'];
                    $call_data['NOTE'] = urlencode($this->request->post['refund_message']);
                    $call_data['MSGSUBID'] = uniqid(mt_rand(), true);

                    $current_transaction = $this->model_payment_pp_express->getLocalTransaction($this->request->post['transaction_id']);

                    if ($this->request->post['refund_full'] == 1) {
                        $call_data['REFUNDTYPE'] = 'Full';
                        $status_refund = $this->config->get('pp_express_refunded_status_id');
                    } else {
                        $call_data['REFUNDTYPE'] = 'Partial';
                        $call_data['AMT'] = number_format(str_replace(',', '.', preg_replace('/[();:|!"#$%&\/\=?~^><ªº-]/', '', $this->request->post['amount'])), 2);
                        $call_data['CURRENCYCODE'] = 'BRL';
                        $status_refund = $this->config->get('pp_express_refunded_partially_status_id');
                    }

                    $result = $this->model_payment_pp_express->call($call_data);

                    $transaction = array(
                        'paypal_order_id' => $paypal_order['paypal_order_id'],
                        'transaction_id' => '',
                        'parent_transaction_id' => $this->request->post['transaction_id'],
                        'note' => $this->request->post['refund_message'],
                        'msgsubid' => $call_data['MSGSUBID'],
                        'receipt_id' => '',
                        'payment_type' => '',
                        'payment_status' => 'Refunded',
                        'transaction_entity' => 'payment',
                        'pending_reason' => '',
                        'amount' => '-' . (isset($call_data['AMT']) ? $call_data['AMT'] : $current_transaction['amount']),
                        'debug_data' => json_encode($result),
                    );

                    if ($result == false) {
                        $transaction['payment_status'] = 'Failed';
                        $this->model_payment_pp_express->addTransaction($transaction, $call_data);
                        $this->redirect($this->url->link('sale/order/info', 'token=' . $this->session->data['token'].'&order_id='.$paypal_order['order_id'].'&tabs=tab-payment', 'SSL'));
                    } else if ($result['ACK'] != 'Failure' && $result['ACK'] != 'FailureWithWarning') {

                        $transaction['transaction_id'] = $result['REFUNDTRANSACTIONID'];
                        $transaction['payment_type'] = $result['REFUNDSTATUS'];
                        $transaction['pending_reason'] = $result['PENDINGREASON'];
                        $transaction['amount'] = '-' . $result['GROSSREFUNDAMT'];

                        $this->model_payment_pp_express->addTransaction($transaction);

                        //update transaction to refunded status
                        if ($result['TOTALREFUNDEDAMOUNT'] == $this->request->post['amount_original']) {
                            $this->db->query("UPDATE `" . DB_PREFIX . "paypal_order_transaction` SET `payment_status` = 'Refunded' WHERE `transaction_id` = '" . $this->db->escape($this->request->post['transaction_id']) . "' LIMIT 1");
                        } else {
                            $this->db->query("UPDATE `" . DB_PREFIX . "paypal_order_transaction` SET `payment_status` = 'Partially-Refunded' WHERE `transaction_id` = '" . $this->db->escape($this->request->post['transaction_id']) . "' LIMIT 1");
                        }

                        $data = array(
                            'order_status_id' => $status_refund,
                            'cometario_html'  => false,
                            'comment'         => $this->request->post['refund_message']
                        );

                        $this->dmodel_checkout_order->addOrderHistory($order_id, $data);

                        //redirect back to the order
                        $this->redirect($this->url->link('sale/order/info', 'token=' . $this->session->data['token'].'&order_id='.$paypal_order['order_id'].'&tabs=tab-payment', 'SSL'));
                    } else {
                        $result = $this->model_payment_pp_express->translateError($result);
                        $this->model_payment_pp_express->log(json_encode($result));
                        $this->session->data['error'] = (isset($result['L_SHORTMESSAGE0']) ? $result['L_SHORTMESSAGE0'] : 'There was an error') . (isset($result['L_LONGMESSAGE0']) ? '<br />' . $result['L_LONGMESSAGE0'] : '');
                    }
                } else {
                    $this->session->data['error'] = $this->language->get('error_data_missing');
                }
                $this->redirect($this->url->link('payment/pp_express/refund', 'token=' . $this->session->data['token'] . '&transaction_id=' . $this->request->post['transaction_id'].'&type='.$this->request->get['type'].$getOrderId, 'SSL'));
            }
        } else {
            $this->session->data['error'] = $this->language->get('error_data');
            $this->redirect($this->url->link('payment/pp_express/refund', 'token=' . $this->session->data['token'] . '&transaction_id=' . $this->request->post['transaction_id'].'&type='.$this->request->get['type'], 'SSL'));
        }
    }

    public function install() {
        $this->load->model('payment/pp_express');
        $this->model_payment_pp_express->install();
    }


    public function orderAction() {
        if ($this->config->get('pp_express_status')) {
            $this->load->model('payment/pp_express');
            $this->load->type('tipocomum');
            $this->load->language('payment/pp_express_order');

            $this->document->addScript(array(
              'view/javascript/payment-pp-express-order.js'
            ));

            $this->data['Type_PaypalPaymentStatus'] = $this->load->typeForTwig('Type_PaypalPaymentStatus');

            $paypal_order = $this->model_payment_pp_express->getOrder($this->request->get['order_id']);

            if ($paypal_order) {
                $this->data['text_payment_info'] = $this->language->get('text_payment_info');
                $this->data['text_capture_status'] = $this->language->get('text_capture_status');
                $this->data['text_amount_auth'] = $this->language->get('text_amount_auth');
                $this->data['btn_void'] = $this->language->get('btn_void');
                $this->data['btn_capture'] = $this->language->get('btn_capture');
                $this->data['text_amount_captured'] = $this->language->get('text_amount_captured');
                $this->data['text_amount_refunded'] = $this->language->get('text_amount_refunded');
                $this->data['text_capture_amount'] = $this->language->get('text_capture_amount');
                $this->data['text_complete_capture'] = $this->language->get('text_complete_capture');
                $this->data['text_transactions'] = $this->language->get('text_transactions');
                $this->data['text_complete'] = $this->language->get('text_complete');
                $this->data['text_confirm_void'] = $this->language->get('text_confirm_void');
                $this->data['error_capture_amt'] = $this->language->get('error_capture_amt');
                $this->data['text_view'] = $this->language->get('text_view');
                $this->data['text_refund'] = $this->language->get('text_refund');
                $this->data['text_resend'] = $this->language->get('text_resend');
                $this->data['column_trans_id'] = $this->language->get('column_trans_id');
                $this->data['column_amount'] = $this->language->get('column_amount');
                $this->data['column_type'] = $this->language->get('column_type');
                $this->data['column_status'] = $this->language->get('column_status');
                $this->data['column_pend_reason'] = $this->language->get('column_pend_reason');
                $this->data['column_created'] = $this->language->get('column_created');
                $this->data['column_action'] = $this->language->get('column_action');

                $this->data['paypal_order'] = $paypal_order;
                $this->data['order_id'] = $this->request->get['order_id'];
                $this->data['token'] = $this->session->data['token'];

                $captured = number_format($this->model_payment_pp_express->totalCaptured($this->data['paypal_order']['paypal_order_id']), 2);
                $refunded = number_format($this->model_payment_pp_express->totalRefundedOrder($this->data['paypal_order']['paypal_order_id']), 2);

                $this->data['paypal_order']['captured'] = $captured;
                $this->data['paypal_order']['refunded'] = $refunded;
                $this->data['paypal_order']['remaining'] = number_format($this->data['paypal_order']['total'] - $captured, 2);

                if ($paypal_order) {
                    $captured = number_format($this->model_payment_pp_express->totalCaptured($paypal_order['paypal_order_id']), 2);
                    $refunded = number_format($this->model_payment_pp_express->totalRefundedOrder($paypal_order['paypal_order_id']), 2);

                    $this->data['paypal_order'] = $paypal_order;

                    $this->data['paypal_order']['captured'] = $captured;
                    $this->data['paypal_order']['refunded'] = $refunded;
                    $this->data['paypal_order']['remaining'] = number_format($paypal_order['total'] - $captured, 2);
                }

                $this->data['refund_link'] = $this->url->link('payment/pp_express/refund', 'token=' . $this->session->data['token'].'&type='.Type_TitleModules::Tp_Pagamento.'&order_id='.$this->request->get['order_id'], 'SSL');
                $this->data['view_link'] = $this->url->link('payment/pp_express/viewTransaction', 'token=' . $this->session->data['token'].'&order_id='.$this->request->get['order_id'].'&type='.Type_TitleModules::Tp_Pagamento, 'SSL');
                $this->data['resend_link'] = $this->url->link('payment/pp_express/resend', 'token=' . $this->session->data['token'].'&type='.Type_TitleModules::Tp_Pagamento, 'SSL');

                $this->response->setOutput($this->render('payment/pp_express_order'));
            }
        }
    }

    public function search() {

        $this->load->language('payment/pp_express_search');
        $this->load->model('payment/pp_express');

        $this->document->setTitle($this->language->get('heading_title'));

        $this->data['heading_title'] = $this->language->get('heading_title');
        $this->data['btn_search'] = $this->language->get('btn_search');
        $this->data['btn_edit_search'] = $this->language->get('btn_edit_search');
        $this->data['entry_date'] = $this->language->get('entry_date');
        $this->data['entry_date_start'] = $this->language->get('entry_date_start');
        $this->data['entry_date_end'] = $this->language->get('entry_date_end');
        $this->data['entry_date_to'] = $this->language->get('entry_date_to');
        $this->data['entry_transaction'] = $this->language->get('entry_transaction');
        $this->data['entry_transaction_type'] = $this->language->get('entry_transaction_type');
        $this->data['entry_transaction_status'] = $this->language->get('entry_transaction_status');
        $this->data['entry_email'] = $this->language->get('entry_email');
        $this->data['entry_email_buyer'] = $this->language->get('entry_email_buyer');
        $this->data['entry_email_merchant'] = $this->language->get('entry_email_merchant');
        $this->data['entry_receipt'] = $this->language->get('entry_receipt');
        $this->data['entry_transaction_id'] = $this->language->get('entry_transaction_id');
        $this->data['entry_auction'] = $this->language->get('entry_auction');
        $this->data['entry_amount'] = $this->language->get('entry_amount');
        $this->data['entry_profile_id'] = $this->language->get('entry_profile_id');
        $this->data['text_buyer_info'] = $this->language->get('text_buyer_info');
        $this->data['entry_salutation'] = $this->language->get('entry_salutation');
        $this->data['text_name'] = $this->language->get('text_name');
        $this->data['entry_firstname'] = $this->language->get('entry_firstname');
        $this->data['entry_middlename'] = $this->language->get('entry_middlename');
        $this->data['entry_lastname'] = $this->language->get('entry_lastname');
        $this->data['entry_suffix'] = $this->language->get('entry_suffix');
        $this->data['text_searching'] = $this->language->get('text_searching');
        $this->data['text_view'] = $this->language->get('text_view');

        $this->data['entry_status_all'] = $this->language->get('entry_status_all');
        $this->data['entry_status_pending'] = $this->language->get('entry_status_pending');
        $this->data['entry_status_processing'] = $this->language->get('entry_status_processing');
        $this->data['entry_status_success'] = $this->language->get('entry_status_success');
        $this->data['entry_status_denied'] = $this->language->get('entry_status_denied');
        $this->data['entry_status_reversed'] = $this->language->get('entry_status_reversed');

        $this->data['entry_trans_all'] = $this->language->get('entry_trans_all');
        $this->data['entry_trans_sent'] = $this->language->get('entry_trans_sent');
        $this->data['entry_trans_received'] = $this->language->get('entry_trans_received');
        $this->data['entry_trans_masspay'] = $this->language->get('entry_trans_masspay');
        $this->data['entry_trans_money_req'] = $this->language->get('entry_trans_money_req');
        $this->data['entry_trans_funds_add'] = $this->language->get('entry_trans_funds_add');
        $this->data['entry_trans_funds_with'] = $this->language->get('entry_trans_funds_with');
        $this->data['entry_trans_referral'] = $this->language->get('entry_trans_referral');
        $this->data['entry_trans_fee'] = $this->language->get('entry_trans_fee');
        $this->data['entry_trans_subscription'] = $this->language->get('entry_trans_subscription');
        $this->data['entry_trans_dividend'] = $this->language->get('entry_trans_dividend');
        $this->data['entry_trans_billpay'] = $this->language->get('entry_trans_billpay');
        $this->data['entry_trans_refund'] = $this->language->get('entry_trans_refund');
        $this->data['entry_trans_conv'] = $this->language->get('entry_trans_conv');
        $this->data['entry_trans_bal_trans'] = $this->language->get('entry_trans_bal_trans');
        $this->data['entry_trans_reversal'] = $this->language->get('entry_trans_reversal');
        $this->data['entry_trans_shipping'] = $this->language->get('entry_trans_shipping');
        $this->data['entry_trans_bal_affect'] = $this->language->get('entry_trans_bal_affect');
        $this->data['entry_trans_echeque'] = $this->language->get('entry_trans_echeque');

        $this->data['tbl_column_date'] = $this->language->get('tbl_column_date');
        $this->data['tbl_column_type'] = $this->language->get('tbl_column_type');
        $this->data['tbl_column_email'] = $this->language->get('tbl_column_email');
        $this->data['tbl_column_name'] = $this->language->get('tbl_column_name');
        $this->data['tbl_column_transid'] = $this->language->get('tbl_column_transid');
        $this->data['tbl_column_status'] = $this->language->get('tbl_column_status');
        $this->data['tbl_column_currency'] = $this->language->get('tbl_column_currency');
        $this->data['tbl_column_amount'] = $this->language->get('tbl_column_amount');
        $this->data['tbl_column_fee'] = $this->language->get('tbl_column_fee');
        $this->data['tbl_column_netamt'] = $this->language->get('tbl_column_netamt');
        $this->data['tbl_column_action'] = $this->language->get('tbl_column_action');

        $this->data['breadcrumbs'] = array();

        $this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('text_home'),
            'href'      => $this->url->link('common/home', 'token=' . $this->session->data['token'], 'SSL'),
            'separator' => false
        );

        $this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('text_pp_express'),
            'href'      => $this->url->link('payment/pp_express', 'token=' . $this->session->data['token'] . '&type=' . $this->request->get['type'], 'SSL'),
            'separator' => ' :: '
        );

        $this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('heading_title'),
            'href'      => $this->url->link('payment/pp_express/search', 'token=' . $this->session->data['token'] . '&type=' . $this->request->get['type'], 'SSL'),
            'separator' => ' :: '
        );


        $this->data['token'] = $this->session->data['token'];
        $this->data['date_start'] = date("d/m/Y", strtotime('-30 days'));
        $this->data['view_link'] = $this->url->link('payment/pp_express/viewTransaction', 'token=' . $this->session->data['token'], 'SSL');

        $this->children = array(
            'common/header',
            'common/footer'
        );
        $this->response->setOutput($this->render('payment/pp_express_search'));
    }

    public function doSearch() {
        /**
         * used to search for transactions from a user account
         */

        if(isset($this->request->post['date_start'])) {

						$this->load->helper('ftr_geral');

            $this->load->model('payment/pp_express');

            $call_data = array();
            $call_data['METHOD'] = 'TransactionSearch';
            $call_data['STARTDATE'] = gmdate(ftr_geral::formatDate($this->request->post['date_start'],'EN')."\TH:i:s\Z");

            if(!empty($this->request->post['date_end'])) {
                $call_data['ENDDATE'] = gmdate(ftr_geral::formatDate($this->request->post['date_end'], 'EN')."\TH:i:s\Z");
            }

            if(!empty($this->request->post['transaction_class'])) {
                $call_data['TRANSACTIONCLASS'] = $this->request->post['transaction_class'];
            }

            if(!empty($this->request->post['status'])) {
                $call_data['STATUS'] = $this->request->post['status'];
            }

            if(!empty($this->request->post['buyer_email'])) {
                $call_data['EMAIL'] = $this->request->post['buyer_email'];
            }

            if(!empty($this->request->post['merchant_email'])) {
                $call_data['RECEIVER'] = $this->request->post['merchant_email'];
            }

            if(!empty($this->request->post['receipt_id'])) {
                $call_data['RECEIPTID'] = $this->request->post['receipt_id'];
            }

            if(!empty($this->request->post['transaction_id'])) {
                $call_data['TRANSACTIONID'] = $this->request->post['transaction_id'];
            }

            if(!empty($this->request->post['invoice_number'])) {
                $call_data['INVNUM'] = $this->request->post['invoice_number'];
            }

            if(!empty($this->request->post['auction_item_number'])) {
                $call_data['AUCTIONITEMNUMBER'] = $this->request->post['auction_item_number'];
            }

            if(!empty($this->request->post['amount'])) {
                $call_data['AMT'] = number_format($this->request->post['amount'], 2);
                $call_data['CURRENCYCODE'] = 'BRL';
            }

            if(!empty($this->request->post['profile_id'])) {
                $call_data['PROFILEID'] = $this->request->post['profile_id'];
            }

            if(!empty($this->request->post['name_salutation'])) {
                $call_data['SALUTATION'] = $this->request->post['name_salutation'];
            }

            if(!empty($this->request->post['name_first'])) {
                $call_data['FIRSTNAME'] = $this->request->post['name_first'];
            }

            if(!empty($this->request->post['name_middle'])) {
                $call_data['MIDDLENAME'] = $this->request->post['name_middle'];
            }

            if(!empty($this->request->post['name_last'])) {
                $call_data['LASTNAME'] = $this->request->post['name_last'];
            }

            if(!empty($this->request->post['name_suffix'])) {
                $call_data['SUFFIX'] = $this->request->post['name_suffix'];
            }

            $result = $this->model_payment_pp_express->call($call_data);

            if($result['ACK'] != 'Failure' && $result['ACK'] != 'FailureWithWarning') {
                $response['error'] = false;
                $response['result'] = $this->formatRows($result);
                $this->response->setOutput(json_encode($response));
            } else {
                $response['error'] = true;
                $response['error_msg'] = $result['L_LONGMESSAGE0'];
            }

            $this->response->setOutput(json_encode($response));
        } else {
            $response['error'] = true;
            $response['error_msg'] = 'Enter a start date';
            $this->response->setOutput(json_encode($response));
        }
    }

    public function viewTransaction() {
        $this->load->model('payment/pp_express');
        $this->load->language('payment/pp_express_view');

        if(isset($this->request->get['order_id'])){
            $getOrderId = '&order_id='.$this->request->get['order_id'].'&tabs=tab-payment';
        }else{
            $getOrderId = '';
        }

        $this->data['transaction'] = $this->model_payment_pp_express->getTransaction($this->request->get['transaction_id']);
        $this->data['lines'] = $this->formatRows($this->data['transaction']);
        $this->data['view_link'] = $this->url->link('payment/pp_express/viewTransaction', 'token=' . $this->session->data['token'].$getOrderId, 'SSL');
        $this->data['token'] = $this->session->data['token'];
        if($getOrderId!=""){
            $this->data['back_link'] = $this->url->link('sale/order/info', 'token=' . $this->session->data['token'].$getOrderId, 'SSL');
        }else{
            $this->data['back_link'] = $this->url->link('payment/pp_express/search', 'token='.$this->session->data['token'].'&type='.$this->request->get['type'], 'SSL');
        }
        $this->data['button_back'] = $this->language->get('button_back');
        $this->document->setTitle($this->language->get('heading_title'));

        $this->data['heading_title'] = $this->language->get('heading_title');
        $this->data['text_product_lines'] = $this->language->get('text_product_lines');
        $this->data['text_ebay_txn_id'] = $this->language->get('text_ebay_txn_id');
        $this->data['text_name'] = $this->language->get('text_name');
        $this->data['text_qty'] = $this->language->get('text_qty');
        $this->data['text_price'] = $this->language->get('text_price');
        $this->data['text_number'] = $this->language->get('text_number');
        $this->data['text_coupon_id'] = $this->language->get('text_coupon_id');
        $this->data['text_coupon_amount'] = $this->language->get('text_coupon_amount');
        $this->data['text_coupon_currency'] = $this->language->get('text_coupon_currency');
        $this->data['text_loyalty_currency'] = $this->language->get('text_loyalty_currency');
        $this->data['text_loyalty_disc_amt'] = $this->language->get('text_loyalty_disc_amt');
        $this->data['text_options_name'] = $this->language->get('text_options_name');
        $this->data['text_tax_amt'] = $this->language->get('text_tax_amt');
        $this->data['text_currency_code'] = $this->language->get('text_currency_code');
        $this->data['text_amount'] = $this->language->get('text_amount');
        $this->data['text_gift_msg'] = $this->language->get('text_gift_msg');
        $this->data['text_gift_receipt'] = $this->language->get('text_gift_receipt');
        $this->data['text_gift_wrap_name'] = $this->language->get('text_gift_wrap_name');
        $this->data['text_gift_wrap_amt'] = $this->language->get('text_gift_wrap_amt');
        $this->data['text_buyer_email_market'] = $this->language->get('text_buyer_email_market');
        $this->data['text_survey_question'] = $this->language->get('text_survey_question');
        $this->data['text_survey_chosen'] = $this->language->get('text_survey_chosen');
        $this->data['text_receiver_business'] = $this->language->get('text_receiver_business');
        $this->data['text_receiver_email'] = $this->language->get('text_receiver_email');
        $this->data['text_receiver_id'] = $this->language->get('text_receiver_id');
        $this->data['text_buyer_email'] = $this->language->get('text_buyer_email');
        $this->data['text_payer_id'] = $this->language->get('text_payer_id');
        $this->data['text_payer_status'] = $this->language->get('text_payer_status');
        $this->data['text_country_code'] = $this->language->get('text_country_code');
        $this->data['text_payer_business'] = $this->language->get('text_payer_business');
        $this->data['text_payer_salute'] = $this->language->get('text_payer_salute');
        $this->data['text_payer_firstname'] = $this->language->get('text_payer_firstname');
        $this->data['text_payer_middlename'] = $this->language->get('text_payer_middlename');
        $this->data['text_payer_lastname'] = $this->language->get('text_payer_lastname');
        $this->data['text_payer_suffix'] = $this->language->get('text_payer_suffix');
        $this->data['text_address_owner'] = $this->language->get('text_address_owner');
        $this->data['text_address_status'] = $this->language->get('text_address_status');
        $this->data['text_ship_sec_name'] = $this->language->get('text_ship_sec_name');
        $this->data['text_ship_name'] = $this->language->get('text_ship_name');
        $this->data['text_ship_street1'] = $this->language->get('text_ship_street1');
        $this->data['text_ship_street2'] = $this->language->get('text_ship_street2');
        $this->data['text_ship_city'] = $this->language->get('text_ship_city');
        $this->data['text_ship_state'] = $this->language->get('text_ship_state');
        $this->data['text_ship_zip'] = $this->language->get('text_ship_zip');
        $this->data['text_ship_country'] = $this->language->get('text_ship_country');
        $this->data['text_ship_phone'] = $this->language->get('text_ship_phone');
        $this->data['text_ship_sec_add1'] = $this->language->get('text_ship_sec_add1');
        $this->data['text_ship_sec_add2'] = $this->language->get('text_ship_sec_add2');
        $this->data['text_ship_sec_city'] = $this->language->get('text_ship_sec_city');
        $this->data['text_ship_sec_state'] = $this->language->get('text_ship_sec_state');
        $this->data['text_ship_sec_zip'] = $this->language->get('text_ship_sec_zip');
        $this->data['text_ship_sec_country'] = $this->language->get('text_ship_sec_country');
        $this->data['text_ship_sec_phone'] = $this->language->get('text_ship_sec_phone');
        $this->data['text_trans_id'] = $this->language->get('text_trans_id');
        $this->data['text_receipt_id'] = $this->language->get('text_receipt_id');
        $this->data['text_parent_trans_id'] = $this->language->get('text_parent_trans_id');
        $this->data['text_trans_type'] = $this->language->get('text_trans_type');
        $this->data['text_payment_type'] = $this->language->get('text_payment_type');
        $this->data['text_order_time'] = $this->language->get('text_order_time');
        $this->data['text_fee_amount'] = $this->language->get('text_fee_amount');
        $this->data['text_settle_amount'] = $this->language->get('text_settle_amount');
        $this->data['text_tax_amount'] = $this->language->get('text_tax_amount');
        $this->data['text_exchange'] = $this->language->get('text_exchange');
        $this->data['text_payment_status'] = $this->language->get('text_payment_status');
        $this->data['text_pending_reason'] = $this->language->get('text_pending_reason');
        $this->data['text_reason_code'] = $this->language->get('text_reason_code');
        $this->data['text_protect_elig'] = $this->language->get('text_protect_elig');
        $this->data['text_protect_elig_type'] = $this->language->get('text_protect_elig_type');
        $this->data['text_store_id'] = $this->language->get('text_store_id');
        $this->data['text_terminal_id'] = $this->language->get('text_terminal_id');
        $this->data['text_invoice_number'] = $this->language->get('text_invoice_number');
        $this->data['text_custom'] = $this->language->get('text_custom');
        $this->data['text_note'] = $this->language->get('text_note');
        $this->data['text_sales_tax'] = $this->language->get('text_sales_tax');
        $this->data['text_buyer_id'] = $this->language->get('text_buyer_id');
        $this->data['text_close_date'] = $this->language->get('text_close_date');
        $this->data['text_multi_item'] = $this->language->get('text_multi_item');
        $this->data['text_sub_amt'] = $this->language->get('text_sub_amt');
        $this->data['text_sub_period'] = $this->language->get('text_sub_period');

        $this->data['breadcrumbs'] = array();

        $this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('text_home'),
            'href'      => $this->url->link('common/home', 'token=' . $this->session->data['token'], 'SSL'),
            'separator' => false
        );

        $this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('order_text'),
            'href'      => $this->url->link('sale/order/info', 'token=' . $this->session->data['token'].$getOrderId, 'SSL'),
            'separator' => ' :: '
        );

        $this->data['breadcrumbs'][] = array(
            'text'      => $this->language->get('heading_title'),
            'href'      => $this->url->link('payment/pp_express/viewTransaction', 'token=' . $this->session->data['token'] . '&transaction_id=' . $this->request->get['transaction_id'] . '&type=' . $this->request->get['type'].$getOrderId, 'SSL'),
            'separator' => ' :: '
        );

        $this->children = array(
            'common/header',
            'common/footer'
        );
        $this->response->setOutput($this->render('payment/pp_express_view'));
    }

    private function formatRows($data) {
        $return = array();

        foreach($data as $k=>$v) {
            $elements = preg_split("/(\d+)/", $k, -1, PREG_SPLIT_NO_EMPTY | PREG_SPLIT_DELIM_CAPTURE);
            if(isset($elements[1]) && isset($elements[0])) {
                if($elements[0] == 'L_TIMESTAMP') {
                    $v = str_replace('T', ' ', $v);
                    $v = str_replace('Z', '', $v);
                }
                $return[$elements[1]][$elements[0]] = $v;
            }
        }

        return $return;
    }

    public function recurringCancel() {
        //cancel an active profile

        $this->load->model('sale/recurring');
        $this->load->model('payment/pp_express');
        $this->language->load('sale/recurring');

        $profile = $this->model_sale_recurring->getProfile($this->request->get['order_recurring_id']);

        if($profile && !empty($profile['profile_reference'])) {

            $result = $this->model_payment_pp_express->recurringCancel($profile['profile_reference']);

            if(isset($result['PROFILEID'])) {
                $this->db->query("INSERT INTO `" . DB_PREFIX . "order_recurring_transaction` SET `order_recurring_id` = '" . (int)$profile['order_recurring_id'] . "', `created` = NOW(), `type` = '5'");
                $this->db->query("UPDATE `" . DB_PREFIX . "order_recurring` SET `status` = 4 WHERE `order_recurring_id` = '" . (int)$profile['order_recurring_id'] . "' LIMIT 1");

                $this->session->data['success'] = $this->language->get('success_cancelled');
            } else {
                $this->session->data['error'] = sprintf($this->language->get('error_not_cancelled'), $result['L_LONGMESSAGE0']);
            }
        } else {
            $this->session->data['error'] = $this->language->get('error_not_found');
        }

        $this->redirect($this->url->link('sale/recurring/info', 'order_recurring_id=' . $this->request->get['order_recurring_id'].'&token='.$this->request->get['token'], 'SSL'));
    }
}
