Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/old/vendor/colissimo/module-shipping/Model/ResourceModel/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
/**
 * Colissimo Shipping Module
 *
 * @author    Magentix
 * @copyright Copyright © 2019 Magentix. All rights reserved.
 * @license   https://www.magentix.fr/en/licence.html Magentix Software Licence
 * @link      https://colissimo.magentix.fr/
 */
namespace Colissimo\Shipping\Model\ResourceModel;

use Colissimo\Shipping\Api\Data\ShippingDataInterface;
use Magento\Framework\Exception\LocalizedException;
use Magento\Framework\Model\ResourceModel\Db\AbstractDb;
use Magento\Sales\Api\Data\OrderAddressInterface;
use Magento\Sales\Model\Order\Address;

class Pickup extends AbstractDb
{
    /**
     * Prefix for resources that will be used in this resource model
     *
     * @var string
     */
    protected $connectionName = 'checkout';

    /**
     * Model initialization
     *
     * @return void
     * @phpcs:disable
     */
    protected function _construct()
    {
        $this->_init('quote_colissimo_pickup', 'quote_id');
    }

    /**
     * Save pickup data for quote
     *
     * @param string   $cartId
     * @param string   $pickupId
     * @param string   $networkCode
     * @param string   $telephone
     * @param string[] $address
     *
     * @return bool
     * @throws LocalizedException
     */
    public function savePickup($cartId, $pickupId, $networkCode, $telephone, $address)
    {
        $connection = $this->getConnection();

        $data = [
            'quote_id'     => $cartId,
            'pickup_id'    => $pickupId,
            'network_code' => $networkCode,
            'telephone'    => $telephone,
        ];

        $data = array_merge($address, $data);

        $connection->insertOnDuplicate(
            $this->getMainTable(),
            $data,
            array_keys($data)
        );

        return true;
    }

    /**
     * Retrieve current pickup for quote
     *
     * @param string|int $cartId
     *
     * @return string[]|false
     * @throws LocalizedException
     */
    public function currentPickup($cartId)
    {
        $connection = $this->getConnection();

        return $connection->fetchRow(
            $connection->select()
                ->from(
                    $this->getMainTable(),
                    [
                        'pickup_id',
                        'network_code',
                        'pickup_type',
                        'telephone',
                        'company',
                        'street',
                        'postcode',
                        'city',
                        'country_id'
                    ]
                )
                ->where('quote_id = ?', $cartId)
                ->limit(1)
        );
    }

    /**
     * Reset pickup data for quote
     *
     * @param string $cartId
     * @return bool
     * @throws LocalizedException
     */
    public function resetPickup($cartId)
    {
        $connection = $this->getConnection();

        $connection->delete(
            $this->getMainTable(),
            [
                'quote_id = ?' => $cartId
            ]
        );

        return true;
    }

    /**
     * Retrieve shipping data for order
     *
     * @param int $orderId
     * @return array
     */
    public function shippingData($orderId)
    {
        $connection = $this->getConnection();

        $data = $connection->fetchRow(
            $connection->select()
                ->from(
                    $this->getTable('sales_order_address'),
                    [
                        ShippingDataInterface::COLISSIMO_PRODUCT_CODE,
                        ShippingDataInterface::COLISSIMO_PICKUP_ID,
                        ShippingDataInterface::COLISSIMO_NETWORK_CODE
                    ]
                )
                ->where(OrderAddressInterface::PARENT_ID . ' = ?', $orderId)
                ->where(OrderAddressInterface::ADDRESS_TYPE . ' = ?', Address::TYPE_SHIPPING)
                ->limit(1)
        );

        return $data;
    }
}