51 lines
1.7 KiB
PHP
51 lines
1.7 KiB
PHP
<?php
|
|
/**
|
|
* NOTICE OF LICENSE
|
|
*
|
|
* This source file is subject to a trade license awarded by
|
|
* Garamo Online L.T.D.
|
|
*
|
|
* Any use, reproduction, modification or distribution
|
|
* of this source file without the written consent of
|
|
* Garamo Online L.T.D It Is prohibited.
|
|
*
|
|
* @author ReactionCode <info@reactioncode.com>
|
|
* @copyright 2015-2020 Garamo Online L.T.D
|
|
* @license Commercial license
|
|
*/
|
|
|
|
class Rc_PgAnalyticsOrderSent extends ObjectModel
|
|
{
|
|
public $id_order;
|
|
public $id_shop;
|
|
public $sent_from;
|
|
public $sent_at;
|
|
|
|
public static $definition = array(
|
|
'table' => 'rc_pganalytics_orders_sent',
|
|
'primary' => 'id_order',
|
|
'fields' => array(
|
|
'id_order' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true),
|
|
'id_shop' => array('type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'required' => true),
|
|
'sent_from' => array('type' => self::TYPE_STRING, 'validate' => 'isGenericName', 'required' => true),
|
|
'sent_at' => array('type' => self::TYPE_DATE, 'validate' => 'isDate', 'required' => true),
|
|
)
|
|
);
|
|
|
|
public static function getOrderReport($id_order, $id_shop)
|
|
{
|
|
$query = 'SELECT * FROM `'._DB_PREFIX_.'rc_pganalytics_orders_sent`
|
|
WHERE id_order = '.(int)$id_order.' AND id_shop = '.(int)$id_shop
|
|
;
|
|
return Db::getInstance()->getRow($query);
|
|
}
|
|
|
|
public static function removeOrder($id_order, $id_shop)
|
|
{
|
|
$query = 'DELETE FROM `'._DB_PREFIX_.'rc_pganalytics_orders_sent`
|
|
WHERE id_order = '.(int)$id_order.' AND id_shop = '.(int)$id_shop
|
|
;
|
|
return Db::getInstance()->execute($query);
|
|
}
|
|
}
|