<?php
/**
 * NOTICE OF LICENSE.
 *
 * Copyright 2022 Kosmonaft.dev
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
 * documentation files (the "Software"), to deal in the Software without restriction, including without limitation the
 * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to
 * permit persons to whom the Software is furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all copies or substantial portions of the
 * Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
 * WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
 * COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR
 * OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 *
 *  @author    Alexandre DEBUSSCHÈRE <alexandre@kosmonaft.dev>
 *  @copyright 2022 - 2023 Kosmonaft.dev
 *  @license   MIT
 */

if (!defined('_PS_VERSION_')) {
    exit;
}

/**
 * Class MRMaxTracking
 */
class MRMaxTracking extends ObjectModel
{

    /** @var int */
    public $id_order;

    /** @var int */
    public $id_step;

    /** @var string */
    public $label_short;

    /** @var string */
    public $label_long;

    /** @var string */
    public $status;

    /** @var string */
    public $code;

    /** @var string */
    public $date;

    /** @var string */
    public $date_add;

    /** @var string */
    public $date_upd;

    /** @var array */
    public static $definition = [
        'table' => 'mrmax_tracking',
        'primary' => 'id_mrmax_tracking',
        'multilang' => false,
        'multilang_shop' => false,
        'fields' => [
            'id_order' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'],
            'id_step' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedInt'],
            'label_short' => ['type' => self::TYPE_STRING],
            'label_long' => ['type' => self::TYPE_STRING],
            'status' => ['type' => self::TYPE_STRING],
            'code' => ['type' => self::TYPE_STRING],
            'date' => ['type' => self::TYPE_STRING],
            'date_add' => ['type' => self::TYPE_DATE, 'validate' => 'isDate'],
            'date_upd' => ['type' => self::TYPE_DATE, 'validate' => 'isDate']
        ]
    ];

    /**
     * @param int $id_order
     * @return MRMaxTracking
     * @throws PrestaShopDatabaseException
     * @throws PrestaShopException
     */
    public static function getByIdOrder($id_order)
    {
        $id_mrmax_tracking = (int)Db::getInstance()->getValue(
            (new DbQuery())
                ->select('id_mrmax_tracking')
                ->from(self::$definition['table'])
                ->where('`id_order` = '.(int)$id_order)
        );

        return new self($id_mrmax_tracking);
    }

    /**
     * @param int $limit
     * @param int $offset
     * @return array|bool|mysqli_result|PDOStatement|resource|null
     * @throws PrestaShopDatabaseException
     */
    public static function getPaginatedTrackings($limit = 0, $offset = 25)
    {
        $query = 'SELECT
                rmt.`id_mrmax_tracking`,
                rmt.`id_order`,
                rmt.`label_short`,
                rmt.`label_long`,
                rmt.`code`,
                rmt.`date`,
                rmt.`id_step`
            FROM `'._DB_PREFIX_.'mrmax_tracking` rmt
            INNER JOIN (
                SELECT `id_order`, MAX(`date`) `date`
                FROM `'._DB_PREFIX_.'mrmax_tracking`
                GROUP BY `id_order`
            ) a ON rmt.`id_order` = a.`id_order` and rmt.`date` = a.`date`
            ORDER BY rmt.`date` DESC
            LIMIT '.(int)$limit.', '.(int)$offset;

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