pagantis::getOrders() - Code Metrics - Inspection of "Int 370" - pagantis/oscommerce - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Pull Request — master (#4)

by Raúl
created 2019-04-12 07:01 UTC
pagantis::getOrders() A

↳ Parent: pagantis
Complexity

Conditions	3
Paths	2
Size

Total Lines	21
Code Lines	14
Duplication

Lines	0
Ratio	0 %
Importance

Changes	1
Bugs	0	Features	0
Metric	Value
cc	3
eloc	14
nc	2
nop	0
dl	0
loc	21
rs	9.7998
c	1
b	0
f	0
<?php

use Pagantis\ModuleUtils\Exception\OrderNotFoundException;
use Pagantis\OrdersApiClient\Model\Order\User\Address;
use Pagantis\ModuleUtils\Exception\UnknownException;

define('TABLE_PAGANTIS_LOG', 'pagantis_log');
define('TABLE_PAGANTIS_CONFIG', 'pagantis_config');
define('TABLE_PAGANTIS_ORDERS', 'pagantis_order');
define('TABLE_PAGANTIS_CONCURRENCY', 'pagantis_concurrency');
define('__ROOT__', dirname(dirname(__FILE__)));

class pagantis
{
    /** @var  String $is_guest */
    public $is_guest;

    /** @var Array $extraConfig */
    public $extraConfig;

    /** @var String $form_action_url */
    public $form_action_url;

    /** @var String $base_url */
    public $base_url;

    /** @var String $os_order_reference */
    public $os_order_reference;

    /** @var notifyController $pgNotify */
    public $pgNotify;

    public $defaultConfigs = array(
        'PAGANTIS_TITLE'=>'Instant Financing',
        'PAGANTIS_SIMULATOR_DISPLAY_TYPE'=>'pgSDK.simulator.types.SIMPLE',
        'PAGANTIS_SIMULATOR_DISPLAY_SKIN'=>'pgSDK.simulator.skins.BLUE',
        'PAGANTIS_SIMULATOR_DISPLAY_POSITION'=>'hookDisplayProductButtons',
        'PAGANTIS_SIMULATOR_START_INSTALLMENTS'=>3,
        'PAGANTIS_SIMULATOR_MAX_INSTALLMENTS'=>12,
        'PAGANTIS_SIMULATOR_CSS_POSITION_SELECTOR'=>'default',
        'PAGANTIS_SIMULATOR_DISPLAY_CSS_POSITION'=>'pgSDK.simulator.positions.INNER',
        'PAGANTIS_SIMULATOR_CSS_PRICE_SELECTOR'=>'default',
        'PAGANTIS_SIMULATOR_CSS_QUANTITY_SELECTOR'=>'default',
        'PAGANTIS_FORM_DISPLAY_TYPE'=>0,
        'PAGANTIS_DISPLAY_MIN_AMOUNT'=>1,
        'PAGANTIS_URL_OK'=>'',
        'PAGANTIS_URL_KO'=>'',
        'PAGANTIS_TITLE_EXTRA' => 'Paga hasta en 12 cómodas cuotas con Paga+Tarde. Solicitud totalmente online y sin papeleos,¡y la respuesta es inmediata!'
    );

    /**
    * Constructor
    */
    public function __construct()
    {
        $this->version = '8.0.0';

        $this->code = 'pagantis';

        $this->sort_order = 0;


        if (strpos($_SERVER[REQUEST_URI], "checkout_payment.php") <= 0) {

            $this->title = MODULE_PAYMENT_PAGANTIS_TEXT_ADMIN_TITLE; // Payment module title in Admin

        } else {
            $this->title = MODULE_PAYMENT_PAGANTIS_TEXT_CATALOG_TITLE; // Payment module title in Catalog
        }

        $this->enabled = ((MODULE_PAYMENT_PAGANTIS_STATUS == 'True') ? true : false);


        $this->extraConfig = $this->getExtraConfig();
        
        $this->base_url = dirname(
            sprintf(
                "%s://%s%s%s",
                isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] != 'off' ? 'https' : 'http',
                $_SERVER['SERVER_NAME'],
                isset($_SERVER['SERVER_PORT']) ? ":".$_SERVER['SERVER_PORT'] : '',
                $_SERVER['REQUEST_URI']
            )
        );

        $this->form_action_url = $this->base_url . '/ext/modules/payment/pagantis/bypass.php';
    }

    /***************
     *
     * CLASS METHODS
     *
     **************/
    /**
    * Here you can implement using payment zones (refer to standard PayPal module as reference)
    */
    public function update_status()
    {

    }

    /*
    * Here you may define client side javascript that will verify any input fields you use in the payment method
    * selection page. Refer to standard cc module as reference (cc.php).
    */
    public function javascript_validation()
    {
        return false;
    }

    /*
    * Llamada cuando el usuario esta en la pantalla de eleccion de tipo de pago
     * This function outputs the payment method title/text and if required, the input fields.
    *
    * Si hay un pedido generado previamente y no confirmado, se borra
    * Caso de uso:
    * - el usuario llega a la pantalla de confirmacion
    * - se genera el pedido (pero no se genera entrada en orders_status_history)
    * - el usuario decide realizar algun cambio en su compra antes de pasar a pagantis
    * - entra de nuevo en la pantalla de seleccion de tipo de pago (puede elegir otra forma de pago)
    * - se comprueba que no exista el pedido generado anteriormente
    * - se borra el pedido que se habia generado inicialmente. Ya no es valido
    *
    */
    public function selection()
    {
        return array('id' => $this->code, 'module' => $this->title);
    }

    /*
    * Use this function implement any checks of any conditions after payment method has been selected. You most probably
    *  don't need to implement anything here.
    */
    public function pre_confirmation_check()
    {
        return false;
    }

    /*
     * Implement any checks or processing on the order information before proceeding to payment confirmation. You most
    probably don't need to implement anything here.
    * Llamada cuando el usuario entra en la pantalla de confirmacion
    *
    * Se genera el pedido:
    * - con el estado predefinido para el modulo pagantis
    * - sin notificacion a cliente ni administrador
    * - no se borra el carrito asociado al pedido
    *
    */
    public function confirmation()
    {
        return false;
    }

    /**
     * Build the data and actions to process when the "Submit" button is pressed on the order-confirmation screen.
     * This sends the data to the payment gateway for processing.
     * (These are hidden fields on the checkout confirmation page)
     */
    public function process_button()
    {
        try {
            include_once('./ext/modules/payment/pagantis/vendor/autoload.php');
            global $order, $customer_id, $sendto, $billto, $cart, $languages_id, $currency, $currencies, $shipping, $payment, $comments, $customer_default_address_id, $cartID;
            $global_vars = array();
            $global_vars['customer_id'] = serialize($customer_id);
            $global_vars['sendTo'] = serialize($sendto);
            $global_vars['billTo'] = serialize($billto);
            $global_vars['cart'] = serialize($cart);
            $global_vars['languages_id'] = serialize($languages_id);
            $global_vars['currency'] = serialize($currency);
            $global_vars['currencies'] = serialize($currencies);
            $global_vars['shipping'] = serialize($shipping);
            $global_vars['payment'] = serialize($payment);
            $global_vars['comments'] = serialize($comments);
            $global_vars['$customer_default_address_id'] = serialize($customer_default_address_id);
            $global_vars['cartID'] = serialize($cartID);
            $global_vars['sessiontoken'] = serialize($_SESSION['sessiontoken']);

            if (!isset($order)) {
                throw new UnknownException("Order not found");
            }

            $id_hash = time().serialize($order->products).''.serialize($order->customer).''.serialize($order->delivery);
            $this->os_order_reference = md5($id_hash);
            $_SESSION['order_id'] = $this->os_order_reference;

            $userAddress = new Address();
            $userAddress
                ->setZipCode($order->billing['postcode'])
                ->setFullName($order->billing['firstname'].' '.$order->billing['lastname'])
                ->setCountryCode('ES')
                ->setCity($order->billing['city'])
                ->setAddress($order->billing['street_address'])
                ->setFixPhone($order->customer['telephone'])
                ->setMobilePhone($order->customer['telephone']);

            $orderBillingAddress = $userAddress;

            $orderShippingAddress = new Address();
            $orderShippingAddress
                ->setZipCode($order->delivery['postcode'])
                ->setFullName($order->billing['firstname'].' '.$order->billing['lastname'])
                ->setCountryCode('ES')
                ->setCity($order->delivery['city'])
                ->setAddress($order->delivery['street_address'])
                ->setFixPhone($order->customer['telephone'])
                ->setMobilePhone($order->customer['telephone']);

            $orderUser = new \Pagantis\OrdersApiClient\Model\Order\User();
            $orderUser
                ->setAddress($userAddress)
                ->setFullName($order->billing['firstname'].' '.$order->billing['lastname'])
                ->setBillingAddress($orderBillingAddress)
                ->setEmail($order->customer['email_address'])
                ->setFixPhone($order->customer['telephone'])
                ->setMobilePhone($order->customer['telephone'])
                ->setShippingAddress($orderShippingAddress);

            $previousOrders = $this->getOrders();
            foreach ((array)$previousOrders as $k => $previousOrder) {
                $orderHistory = new \Pagantis\OrdersApiClient\Model\Order\User\OrderHistory();
                $orderHistory
                    ->setAmount(intval(100 * $previousOrder['value']))
                    ->setDate(new \DateTime($previousOrder['date_purchased']))
                    ->setDate(/** @scrutinizer ignore-type */ new \DateTime($previousOrder['date_purchased']))
                ;
                $orderUser->addOrderHistory($orderHistory);
            }

            $details      = new \Pagantis\OrdersApiClient\Model\Order\ShoppingCart\Details();
            $shippingCost = number_format($order->info['shipping_cost'], 2, '.', '');
            $details->setShippingCost(intval(strval(100 * $shippingCost)));
            foreach ($order->products as $item) {
                $product = new \Pagantis\OrdersApiClient\Model\Order\ShoppingCart\Details\Product();
                $product
                    ->setAmount(intval(100 * number_format(($item['final_price'] * $item['qty']), 2)))
                    ->setQuantity(intval($item['qty']))
                    ->setDescription($item['name']);
                $details->addProduct($product);
            }

            $orderShoppingCart = new \Pagantis\OrdersApiClient\Model\Order\ShoppingCart();
            $orderShoppingCart
                ->setDetails($details)
                ->setOrderReference($this->os_order_reference)
                ->setPromotedAmount(0)
                ->setTotalAmount(intval($order->info['total'] * 100));

            $callback_url = $this->base_url.'/ext/modules/payment/pagantis/notify.php';
            $checkoutProcessUrl = htmlspecialchars_decode(
                tep_href_link(FILENAME_CHECKOUT_PROCESS, "order_id=$this->os_order_reference&from=order", 'SSL', true, false)
                tep_href_link(FILENAME_CHECKOUT_PROCESS, "order_id=$this->os_order_reference&from=order", 'SSL', true, false)
            );
            $cancelUrl              = trim(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL', false));

            $orderConfigurationUrls = new \Pagantis\OrdersApiClient\Model\Order\Configuration\Urls();
            $orderConfigurationUrls
                ->setCancel($cancelUrl)
                ->setKo($cancelUrl)
                ->setAuthorizedNotificationCallback($callback_url)
                ->setRejectedNotificationCallback($callback_url)
                ->setOk($checkoutProcessUrl);


            $orderChannel = new \Pagantis\OrdersApiClient\Model\Order\Configuration\Channel();
            $orderChannel
                ->setAssistedSale(false)
                ->setType(\Pagantis\OrdersApiClient\Model\Order\Configuration\Channel::ONLINE);
            $orderConfiguration = new \Pagantis\OrdersApiClient\Model\Order\Configuration();
            $orderConfiguration
                ->setChannel($orderChannel)
                ->setUrls($orderConfigurationUrls);

            $metadataOrder = new \Pagantis\OrdersApiClient\Model\Order\Metadata();
            $metadata      = array(
                'oscommerce' => PROJECT_VERSION,

                'pagantis'   => $this->version,
                'php'        => phpversion()
            );
            foreach ($metadata as $key => $metadatum) {
                $metadataOrder->addMetadata($key, $metadatum);
            }
            $orderApiClient = new \Pagantis\OrdersApiClient\Model\Order();
            $orderApiClient
                ->setConfiguration($orderConfiguration)
                ->setMetadata($metadataOrder)
                ->setShoppingCart($orderShoppingCart)
                ->setUser($orderUser);

            $publicKey     = trim(MODULE_PAYMENT_PAGANTIS_PK);

            $secretKey     = trim(MODULE_PAYMENT_PAGANTIS_SK);

            $orderClient   = new \Pagantis\OrdersApiClient\Client($publicKey, $secretKey);
            $pagantisOrder = $orderClient->createOrder($orderApiClient);
            if ($pagantisOrder instanceof \Pagantis\OrdersApiClient\Model\Order) {

                $url = $pagantisOrder->getActionUrls()->getForm();
                $this->insertRow($this->os_order_reference, $pagantisOrder->getId(), serialize($global_vars));
            } else {
                throw new OrderNotFoundException();
            }

            if ($url == "") {
                throw new UnknownException(_("No ha sido posible obtener una respuesta de Pagantis"));
            } else { //if ($this->extraConfig['PAGANTIS_FORM_DISPLAY_TYPE'] == '0') {
                $output = "\n";
                $output.= tep_draw_hidden_field("formUrl", $url) . "\n";
                $output.= /** @scrutinizer ignore-call */ tep_draw_hidden_field("formUrl", $url) . "\n";
                $output.= tep_draw_hidden_field("cancelUrl", $cancelUrl) . "\n";
                return $output;

            } //TODO IFRAME
        } catch (\Exception $exception) {
            tep_redirect($cancelUrl);
            tep_redirect($cancelUrl);
            return;
        }
    }

    /**
     *
     */
    public function before_process()
    {
        include_once('./ext/modules/payment/pagantis/notifyController.php');
        $this->pgNotify = new notifyController();
        $this->pgNotify->setOscommerceOrderId($_GET['order_id']);
        $this->pgNotify->setOrigin(isset($_GET['from']) ? ($_GET['from']) : 'order');
        $this->pgNotify->processInformation();
    }

    /**
    * Post-processing activities
    *
    * @return boolean
    */
    public function after_process()
    {
        $this->pgNotify->confirmInformation();
    }

    public function output_error()
    {
        return false;
    }

    public function check()
    {
        if (!isset($this->_check)) {
            $check_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_PAGANTIS_STATUS'");
            $check_query = /** @scrutinizer ignore-call */ tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_PAYMENT_PAGANTIS_STATUS'");
            $this->_check = tep_db_num_rows($check_query);
            $this->_check = /** @scrutinizer ignore-call */ tep_db_num_rows($check_query);
        }
        $this->installPagantisTables();
        return $this->_check;
    }

    /*
     * This is where you define module's configurations (displayed in admin).
     */
    public function install()
    {
        global $messageStack;

        if (defined('MODULE_PAYMENT_PAGANTIS_STATUS')) {
            tep_redirect(tep_href_link(FILENAME_MODULES, 'set=payment&module=pagantis', 'NONSSL'));
            tep_redirect(tep_href_link(FILENAME_MODULES, 'set=payment&module=pagantis', 'NONSSL'));
            return 'failed';
        }
        tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Pagantis module', 'MODULE_PAYMENT_PAGANTIS_STATUS', 'True', '', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
        tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Pagantis module', 'MODULE_PAYMENT_PAGANTIS_STATUS', 'True', '', '6', '0', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
        tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Public Key', 'MODULE_PAYMENT_PAGANTIS_PK', '', 'MANDATORY. You can get in your pagantis profile', '6', '0', now())");
        tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Secret Key', 'MODULE_PAYMENT_PAGANTIS_SK', '', 'MANDATORY. You can get in your pagantis profile', '6', '0', now())");

        $this->installPagantisTables();
    }

    /**
     * Create the neccesary tables for the module
     */
    private function installPagantisTables()
    {
        $sql = "CREATE TABLE IF NOT EXISTS " . TABLE_PAGANTIS_LOG . " ( 
                          id int NOT NULL AUTO_INCREMENT, 
                          log text NOT NULL, 
                          createdAt timestamp DEFAULT CURRENT_TIMESTAMP, 
                          UNIQUE KEY id (id))";
        tep_db_query($sql);
        tep_db_query($sql);

        $sql = "CREATE TABLE IF NOT EXISTS " . TABLE_PAGANTIS_CONFIG . " (
                            id int NOT NULL AUTO_INCREMENT, 
                            config varchar(60) NOT NULL, 
                            value varchar(200) NOT NULL, 
                            UNIQUE KEY id(id))";
        tep_db_query($sql);

        // check if table has records
        $check_query = tep_db_query("select value from " . TABLE_PAGANTIS_CONFIG);
        if(tep_db_num_rows($check_query) === 0) {
        if(/** @scrutinizer ignore-call */ tep_db_num_rows($check_query) === 0) {
            foreach ((array)$this->defaultConfigs as $configKey => $configValue) {
                $query = "INSERT INTO " . TABLE_PAGANTIS_CONFIG . " (config, value) values ('$configKey', '$configValue')";
                tep_db_query($query);
            }
        }

        $sql = "CREATE TABLE IF NOT EXISTS " . TABLE_PAGANTIS_ORDERS . " (
                            id int NOT NULL AUTO_INCREMENT, 
                            os_order_id varchar(50), 
                            os_order_reference varchar(50) NOT NULL,
                            pagantis_order_id varchar(50) NOT NULL, 
                            globals text,
                            UNIQUE KEY id(id))";
        tep_db_query($sql);

        $sql = "CREATE TABLE IF NOT EXISTS " . TABLE_PAGANTIS_CONCURRENCY . " (
                            id varchar(50) NOT NULL,
                            `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
                            UNIQUE KEY id(id))";
        tep_db_query($sql);
    }

    /*
     * Standard functionality to uninstall the module.
     */
    public function remove()
    {
        $checkTable = tep_db_query("SHOW TABLES LIKE '".TABLE_PAGANTIS_LOG."'");
        $checkTable = /** @scrutinizer ignore-call */ tep_db_query("SHOW TABLES LIKE '".TABLE_PAGANTIS_LOG."'");
        if (tep_db_num_rows($checkTable) > 0) {
        if (/** @scrutinizer ignore-call */ tep_db_num_rows($checkTable) > 0) {
            tep_db_query("drop table " . TABLE_PAGANTIS_LOG);
        }

        $checkTable = tep_db_query("SHOW TABLES LIKE '".TABLE_PAGANTIS_CONFIG."'");
        if (tep_db_num_rows($checkTable) > 0) {
            tep_db_query("drop table " . TABLE_PAGANTIS_CONFIG);
        }

        $checkTable = tep_db_query("SHOW TABLES LIKE '".TABLE_PAGANTIS_ORDERS."'");
        if (tep_db_num_rows($checkTable) > 0) {
            tep_db_query("drop table " . TABLE_PAGANTIS_ORDERS);
        }

        $checkTable = tep_db_query("SHOW TABLES LIKE '".TABLE_PAGANTIS_CONCURRENCY."'");
        if (tep_db_num_rows($checkTable) > 0) {
            tep_db_query("drop table " . TABLE_PAGANTIS_CONCURRENCY);
        }

        $query = "delete from ".TABLE_ORDERS_STATUS." where orders_status_id='6'";

        tep_db_query($query);
    }

    /**
    * Internal list of configuration keys used for configuration of the module
    *
    * @return array
    */
    public function keys()
    {
        return array('MODULE_PAYMENT_PAGANTIS_STATUS',
           'MODULE_PAYMENT_PAGANTIS_PK',
           'MODULE_PAYMENT_PAGANTIS_SK'
           );
    }

    /**
     * @return array
     */
    private function getOrders()
    {
        $this->is_guest = 'true';
        if (trim($_SESSION['customer_id']) != '') {
            $this->is_guest = 'false';
            $query = sprintf(
                "select orders_total.value, orders.date_purchased from orders 
JOIN orders_status_history ON orders.orders_id=orders_status_history.orders_id 
JOIN orders_total ON orders.orders_id=orders_total.orders_id 
where orders.customers_id='%s' and orders_status_history.orders_status_id in ('2','3') and orders_total.class='ot_total'",
                $_SESSION['customer_id']
            );

            $response = array();
            $resultsSelect = tep_db_query($query);
            $resultsSelect = /** @scrutinizer ignore-call */ tep_db_query($query);
            while ($orderRow = tep_db_fetch_array($resultsSelect)) {
            while ($orderRow = /** @scrutinizer ignore-call */ tep_db_fetch_array($resultsSelect)) {
                $response[] = $orderRow;
            }
        }

        return $response;

    }

    /**
     * @param $orderId
     * @param $pagantisOrderId
     * @param $globalVars
     */
    private function insertRow($orderId, $pagantisOrderId, $globalVars)
    {
        $query = "select * from ". TABLE_PAGANTIS_ORDERS ." where os_order_reference='$orderId'";
        $resultsSelect = tep_db_query($query);
        $resultsSelect = /** @scrutinizer ignore-call */ tep_db_query($query);
        $countResults = tep_db_num_rows($resultsSelect);
        $countResults = /** @scrutinizer ignore-call */ tep_db_num_rows($resultsSelect);
        if ($countResults == 0) {
            $query = "INSERT INTO ". TABLE_PAGANTIS_ORDERS ."(os_order_reference, pagantis_order_id, globals) values ('$orderId', '$pagantisOrderId','$globalVars')";
        } else {
            $query = "UPDATE " . TABLE_PAGANTIS_ORDERS . " set pagantis_order_id='$pagantisOrderId' where os_order_reference='$orderId'";
        }
        tep_db_query($query);
    }

    /**
     * @return array
     */
    private function getExtraConfig()
    {
        $checkTable = tep_db_query("SHOW TABLES LIKE '".TABLE_PAGANTIS."'");
        $checkTable = /** @scrutinizer ignore-call */ tep_db_query("SHOW TABLES LIKE '".TABLE_PAGANTIS."'");
        $response = array();
        if (tep_db_num_rows($checkTable) > 0) {
        if (/** @scrutinizer ignore-call */ tep_db_num_rows($checkTable) > 0) {
            $query       = "select * from ".TABLE_PAGANTIS_CONFIG;
            $result      = tep_db_query($query);
            $resultArray = tep_db_fetch_array($result);
            $resultArray = /** @scrutinizer ignore-call */ tep_db_fetch_array($result);
            $response    = array();
            foreach ((array)$resultArray as $key => $value) {
                $response[$key] = $value;
            }
        }

        return $response;
    }
}

pagantis / oscommerce

Pull Request — master (#4)

pagantis::getOrders() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
