<?php


class EmpikOrder extends ObjectModel
{
    public $id_order;
    public $empik_order_reference;
    public $empik_order_carrier;
    public $empik_payment;
    public $empik_carrier;
    public $empik_tracking_number;
    public $empik_pickup_point;
    public $empik_vat_number;
    public $date_add;

    public static $definition = [
        'table' => 'empik_orders',
        'primary' => 'id_empik_order',
        'fields' => [
            'id_order' => [
                'type' => self::TYPE_INT,
                'validate' => 'isUnsignedInt',
                'required' => true,
            ],
            'empik_order_reference' => [
                'type' => self::TYPE_STRING,
                'validate' => 'isCleanHtml',
            ],
            'empik_order_carrier' => [
                'type' => self::TYPE_STRING,
                'validate' => 'isCleanHtml',
            ],
            'empik_payment' => [
                'type' => self::TYPE_STRING,
                'validate' => 'isCleanHtml',
                'required' => true,
            ],
            'empik_carrier' => [
                'type' => self::TYPE_STRING,
                'validate' => 'isCleanHtml',
                'required' => true,
            ],
            'empik_tracking_number' => [
                'type' => self::TYPE_STRING,
                'validate' => 'isTrackingNumber',
            ],
            'empik_pickup_point' => [
                'type' => self::TYPE_STRING,
                'validate' => 'isCleanHtml',
            ],
            'empik_vat_number' => [
                'type' => self::TYPE_STRING,
                'validate' => 'isCleanHtml',
            ],
            'date_add' => [
                'type' => self::TYPE_DATE,
                'validate' => 'isDate',
                'required' => false,
            ],
        ],
    ];

    public static function getEmpikOrderByOrderId($orderId)
    {
        $query = (new DbQuery())
            ->select('eo.*')
            ->from('empik_orders', 'eo')
            ->where('eo.id_order = "'.pSQL($orderId).'"');

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

    public static function getEmpikOrderReferenceByOrderId($orderId)
    {
        $query = (new DbQuery())
            ->select('eo.empik_order_reference')
            ->from('empik_orders', 'eo')
            ->where('eo.id_order = "'.pSQL($orderId).'"');

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

    public static function getOrderIdByEmpikOrderReference($empikOrderReference)
    {
        $query = (new DbQuery())
            ->select('eo.id_order')
            ->from('empik_orders', 'eo')
            ->where('eo.empik_order_reference = "'.pSQL($empikOrderReference).'"');

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