<?php
/**
 *  2007-2022 PayPal
 *
 *  NOTICE OF LICENSE
 *
 *  This source file is subject to the Academic Free License (AFL 3.0)
 *  that is bundled with this package in the file LICENSE.txt.
 *  It is also available through the world-wide-web at this URL:
 *  http://opensource.org/licenses/afl-3.0.php
 *  If you did not receive a copy of the license and are unable to
 *  obtain it through the world-wide-web, please send an email
 *  to license@prestashop.com so we can send you a copy immediately.
 *
 *  DISCLAIMER
 *
 *  Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 *  versions in the future. If you wish to customize PrestaShop for your
 *  needs please refer to http://www.prestashop.com for more information.
 *
 *  @author 2007-2022 PayPal
 *  @author 202 ecommerce <tech@202-ecommerce.com>
 *  @copyright PayPal
 *  @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
 */
if (!defined('_PS_VERSION_')) {
    exit;
}

/*
 * PayPal notification fields
 */
define('ID_INVOICE', 'invoice');
define('ID_PAYER', 'payer_id');
define('ID_TRANSACTION', 'txn_id');
define('CURRENCY', 'mc_currency');
define('PAYER_EMAIL', 'payer_email');
define('PAYMENT_DATE', 'payment_date');
define('TOTAL_PAID', 'mc_gross');
define('SHIPPING', 'shipping');
define('VERIFY_SIGN', 'verify_sign');

class PayPalOrder
{
    /*
     * Get PayPal order data
     * - ID Order
     * - ID Transaction
     * - ID Invoice
     * - Currency (ISO)
     * - Total paid
     * - Shipping
     * - Capture (bool)
     * - Payment date
     * - Payment method (int)
     * - Payment status
     */

    public static function getTransactionDetails($ppec = false, $payment_status = false)
    {
        if ($ppec && $payment_status) {
            $transaction_id = pSQL($ppec->result['PAYMENTINFO_0_TRANSACTIONID']);

            return [
                'currency' => pSQL($ppec->result['PAYMENTINFO_0_CURRENCYCODE']),
                'id_invoice' => null,
                'id_transaction' => $transaction_id,
                'transaction_id' => $transaction_id,
                'total_paid' => (float) $ppec->result['PAYMENTINFO_0_AMT'],
                'shipping' => (float) $ppec->result['PAYMENTREQUEST_0_SHIPPINGAMT'],
                'payment_date' => pSQL($ppec->result['PAYMENTINFO_0_ORDERTIME']),
                'payment_status' => pSQL($payment_status),
            ];
        } else {
            $transaction_id = pSQL(Tools::getValue(ID_TRANSACTION));

            return [
                'currency' => pSQL(Tools::getValue(CURRENCY)),
                'id_invoice' => pSQL(Tools::getValue(ID_INVOICE)),
                'id_transaction' => $transaction_id,
                'transaction_id' => $transaction_id,
                'total_paid' => (float) Tools::getValue(TOTAL_PAID),
                'shipping' => (float) Tools::getValue(SHIPPING),
                'payment_date' => pSQL(Tools::getValue(PAYMENT_DATE)),
                'payment_status' => pSQL($payment_status),
            ];
        }
    }

    public static function getOrderById($id_order)
    {
        return Db::getInstance()->getRow(
            'SELECT * FROM `' . _DB_PREFIX_ . 'paypal_order`
			WHERE `id_order` = ' . (int) $id_order
        );
    }

    public static function getIdOrderByTransactionId($id_transaction)
    {
        $sql = 'SELECT `id_order`
			FROM `' . _DB_PREFIX_ . 'paypal_order`
			WHERE `id_transaction` = \'' . pSQL($id_transaction) . '\'';

        $result = Db::getInstance()->getRow($sql);

        if ($result != false) {
            return (int) $result['id_order'];
        }

        return 0;
    }

    public static function saveOrder($id_order, $transaction)
    {
        $order = new Order((int) $id_order);
        $total_paid = (float) $transaction['total_paid'];

        if (!isset($transaction['payment_status']) || !$transaction['payment_status']) {
            $transaction['payment_status'] = 'NULL';
        }

        Db::getInstance()->Execute(
            'INSERT INTO `' . _DB_PREFIX_ . 'paypal_order`
			(`id_order`, `id_transaction`, `id_invoice`, `currency`, `total_paid`, `shipping`, `capture`, `payment_date`, `payment_method`, `payment_status`)
			VALUES (' . (int) $id_order . ', \'' . pSQL($transaction['id_transaction']) . '\', \'' . pSQL($transaction['id_invoice']) . '\',
				\'' . pSQL($transaction['currency']) . '\',
				\'' . $total_paid . '\',
				\'' . (float) $transaction['shipping'] . '\',
				\'' . (int) Configuration::get('PAYPAL_CAPTURE') . '\',
				\'' . pSQL($transaction['payment_date']) . '\',
				\'' . (int) Configuration::get('PAYPAL_PAYMENT_METHOD') . '\',
				\'' . pSQL($transaction['payment_status']) . '\')'
        );
    }

    public static function updateOrder($id_order, $transaction)
    {
        $total_paid = (float) $transaction['total_paid'];

        if (!isset($transaction['payment_status']) || !$transaction['payment_status']) {
            $transaction['payment_status'] = 'NULL';
        }

        $sql = 'UPDATE `' . _DB_PREFIX_ . 'paypal_order`
			SET `payment_status` = \'' . pSQL($transaction['payment_status']) . '\'
			WHERE `id_order` = \'' . (int) $id_order . '\'
				AND `id_transaction` = \'' . pSQL($transaction['id_transaction']) . '\'
				AND `currency` = \'' . pSQL($transaction['currency']) . '\'';
        if ((int) Configuration::get('PAYPAL_SANDBOX') != 1) {
            $sql .= 'AND `total_paid` = \'' . pSQL($transaction['total_paid']) . '\'
				AND `shipping` = \'' . (float) $transaction['shipping'] . '\';';
        }

        Db::getInstance()->Execute($sql);
    }
}