One Hat Cyber Team

Your IP: 216.73.216.1
Server IP: 185.238.29.86
Server: Linux server2 6.8.12-6-pve #1 SMP PREEMPT_DYNAMIC PMX 6.8.12-6 (2024-12-19T19:05Z) x86_64
Server Software: nginx/1.18.0
PHP Version: 8.1.31
Buat File | Buat Folder

Dir : ~/var/www/olasjoys/modules/ps_checkout/classes/

Edit File: OrderMatrice.php

<?php
/**
 * Copyright since 2007 PrestaShop SA and Contributors
 * PrestaShop is an International Registered Trademark & Property of PrestaShop SA
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Academic Free License version 3.0
 * that is bundled with this package in the file LICENSE.md.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/AFL-3.0
 * 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.
 *
 * @author    PrestaShop SA and Contributors <contact@prestashop.com>
 * @copyright Since 2007 PrestaShop SA and Contributors
 * @license   https://opensource.org/licenses/AFL-3.0 Academic Free License version 3.0
 */

/**
 * Makes a matrice between Prestashop Order and Paypal Order
 */
class OrderMatrice extends \ObjectModel
{
    public $id_order_prestashop;
    public $id_order_paypal;

/**
     * @see ObjectModel::$definition
     */
    public static $definition = [
        'table' => 'pscheckout_order_matrice',
        'primary' => 'id_order_matrice',
        'fields' => [
            'id_order_prestashop' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt', 'required' => true],
            'id_order_paypal' => ['type' => self::TYPE_STRING, 'validate' => 'isString', 'required' => true],
        ],
    ];

/**
     * Get the Prestashop Order Id from Paypal Order Id
     *
     * @param string $orderPaypal
     *
     * @return int
     */
    public function getOrderPrestashopFromPaypal($orderPaypal)
    {
        $query = new \DbQuery();
        $query->select('id_order_prestashop');
        $query->from('pscheckout_order_matrice');
        $query->where('id_order_paypal = "' . pSQL($orderPaypal) . '"');
        $query->orderBy('id_order_matrice DESC');

return (int) \Db::getInstance()->getValue($query);
    }

/**
     * Get the Paypal Order Id from the Prestashop Order Id
     *
     * @param int $orderPrestashop
     *
     * @return string|false
     */
    public function getOrderPaypalFromPrestashop($orderPrestashop)
    {
        $query = new \DbQuery();
        $query->select('id_order_paypal');
        $query->from('pscheckout_order_matrice');
        $query->where('id_order_prestashop = ' . (int) $orderPrestashop);
        $query->orderBy('id_order_matrice DESC');

return \Db::getInstance()->getValue($query);
    }

/**
     * Check if this order has multiple entries associated due to bug before 1.2.11
     *
     * @param int $orderId
     *
     * @return bool
     */
    public static function hasInconsistencies($orderId)
    {
        // Before 1.2.11 id_order_prestashop field was limited to 255
        if ((int) $orderId !== 255) {
            return false;
        }

// If more than one order found, there are inconsistencies for this order
        $query = new \DbQuery();
        $query->select('COUNT(*)');
        $query->from('pscheckout_order_matrice');
        $query->where('id_order_prestashop = ' . (int) $orderId);

return (bool) \Db::getInstance()->getValue($query);
    }
}