87 lines
2.6 KiB
PHP
87 lines
2.6 KiB
PHP
<?php
|
|
|
|
|
|
class EmpikOrder extends ObjectModel
|
|
{
|
|
public $id_order;
|
|
public $empik_order_reference;
|
|
public $empik_order_carrier;
|
|
public $empik_payment;
|
|
public $empik_carrier;
|
|
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_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);
|
|
}
|
|
} |