<?php
/**
 * Refer to LICENSE.txt distributed with the Temando Shipping module for notice of license
 */
namespace Temando\Shipping\Model\ResourceModel\Order;

use Magento\Framework\Model\ResourceModel\Db\VersionControl\AbstractDb;
use Temando\Shipping\Api\Data\Order\OrderReferenceInterface;
use Temando\Shipping\Setup\SetupSchema;

/**
 * Temando Order Reference Resource Model
 *
 * @package Temando\Shipping\Model
 * @author  Christoph Aßmann <christoph.assmann@netresearch.de>
 * @license https://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
 * @link    https://www.temando.com/
 */
class OrderReference extends AbstractDb
{
    /**
     * Init main table and primary key.
     *
     * @return void
     */
    protected function _construct()
    {
        $this->_init(SetupSchema::TABLE_ORDER, OrderReferenceInterface::ENTITY_ID);
    }

    /**
     * Read entity id by using sales order id.
     *
     * @param int $orderId
     * @return int|null
     */
    public function getIdByOrderId($orderId)
    {
        try {
            $connection = $this->getConnection();
            $tableName  = $this->getMainTable();
            $table      = $this->getTable($tableName);

            $select = $connection->select()
                ->from($table, OrderReferenceInterface::ENTITY_ID)
                ->where('order_id = :order_id');

            $bind  = [':order_id' => (string)$orderId];
            $entityId = $connection->fetchOne($select, $bind);

            return $entityId ? (int) $entityId : null;
        } catch (\Exception $exception) {
            return null;
        }
    }

    /**
     * Read entity id by using platform order id.
     *
     * @param string $extOrderId
     * @return int|null
     */
    public function getIdByExtOrderId($extOrderId)
    {
        try {
            $connection = $this->getConnection();
            $tableName  = $this->getMainTable();
            $table      = $this->getTable($tableName);

            $select = $connection->select()
                ->from($table, OrderReferenceInterface::ENTITY_ID)
                ->where('ext_order_id = :ext_order_id');

            $bind  = [':ext_order_id' => (string)$extOrderId];
            $entityId = $connection->fetchOne($select, $bind);

            return $entityId ? (int) $entityId : null;
        } catch (\Exception $exception) {
            return null;
        }
    }

    /**
     * Read sales order id by using platform order id.
     *
     * @param string $extOrderId
     * @return int|null
     */
    public function getOrderIdByExtOrderId($extOrderId)
    {
        try {
            $connection = $this->getConnection();
            $tableName  = $this->getMainTable();
            $table      = $this->getTable($tableName);

            $select = $connection->select()
                ->from($table, OrderReferenceInterface::ORDER_ID)
                ->where('ext_order_id = :ext_order_id');

            $bind  = [':ext_order_id' => (string)$extOrderId];
            $entityId = $connection->fetchOne($select, $bind);

            return $entityId ? (int) $entityId : null;
        } catch (\Exception $exception) {
            return null;
        }
    }

    /**
     * Read platform order id by using sales order id.
     *
     * @param string $orderId
     * @return string|null
     */
    public function getExtOrderIdByOrderId($orderId)
    {
        try {
            $connection = $this->getConnection();
            $tableName  = $this->getMainTable();
            $table      = $this->getTable($tableName);

            $select = $connection->select()
                ->from($table, OrderReferenceInterface::EXT_ORDER_ID)
                ->where('order_id = :order_id');

            $bind  = [':order_id' => (string)$orderId];
            $extOrderId = $connection->fetchOne($select, $bind);

            return $extOrderId ? (string) $extOrderId : null;
        } catch (\Exception $exception) {
            return null;
        }
    }
}