89 lines
3.2 KiB
PHP
89 lines
3.2 KiB
PHP
<?php
|
|
/**
|
|
* ISC License
|
|
*
|
|
* Copyright (c) 2024 idnovate.com
|
|
* idnovate is a Registered Trademark & Property of idnovate.com, innovación y desarrollo SCP
|
|
*
|
|
* Permission to use, copy, modify, and/or distribute this software for any
|
|
* purpose with or without fee is hereby granted, provided that the above
|
|
* copyright notice and this permission notice appear in all copies.
|
|
*
|
|
* THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES WITH
|
|
* REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
|
|
* AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY SPECIAL, DIRECT,
|
|
* INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
|
|
* LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR
|
|
* OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
|
|
* PERFORMANCE OF THIS SOFTWARE.
|
|
*
|
|
* @author idnovate
|
|
* @copyright 2024 idnovate
|
|
* @license https://www.isc.org/licenses/ https://opensource.org/licenses/ISC ISC License
|
|
*/
|
|
if (!defined('_PS_VERSION_')) {
|
|
exit;
|
|
}
|
|
|
|
class CookiesPlusUserConsent extends ObjectModel
|
|
{
|
|
public $id_cookiesplus_user_consent;
|
|
public $id_shop;
|
|
public $hash;
|
|
public $data;
|
|
public $date;
|
|
public $ip;
|
|
public $date_add;
|
|
|
|
public static $definition = [
|
|
'table' => 'cookiesplus_user_consent',
|
|
'primary' => 'id_cookiesplus_user_consent',
|
|
'fields' => [
|
|
'id_cookiesplus_user_consent' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'copy_post' => false],
|
|
'id_shop' => ['type' => self::TYPE_INT, 'validate' => 'isUnsignedId', 'copy_post' => false],
|
|
'hash' => ['type' => self::TYPE_STRING, 'required' => true],
|
|
'data' => ['type' => self::TYPE_STRING, 'required' => true],
|
|
'date' => ['type' => self::TYPE_STRING, 'required' => true],
|
|
'ip' => ['type' => self::TYPE_STRING, 'required' => true],
|
|
'date_add' => ['type' => self::TYPE_DATE, 'validate' => 'isDate', 'copy_post' => false],
|
|
],
|
|
];
|
|
|
|
public function add($autodate = true, $null_values = false)
|
|
{
|
|
$this->id_shop = ($this->id_shop) ?: Context::getContext()->shop->id;
|
|
|
|
return parent::add($autodate, $null_values);
|
|
}
|
|
|
|
public static function getCookiesPlusUserConsentExpired($shopId)
|
|
{
|
|
if (!Configuration::get('C_P_EXPIRY')) {
|
|
return [];
|
|
}
|
|
|
|
$query = "SHOW TABLES LIKE '" . _DB_PREFIX_ . "cookiesplus_user_consent'";
|
|
|
|
if (Db::getInstance()->executeS($query)) {
|
|
$query = 'SELECT `id_cookiesplus_user_consent`
|
|
FROM ' . _DB_PREFIX_ . 'cookiesplus_user_consent
|
|
WHERE id_shop = ' . (int) $shopId . '
|
|
AND `date_add` < NOW() - INTERVAL ' . Configuration::get('C_P_EXPIRY') * 24 . ' HOUR;'
|
|
;
|
|
|
|
return Db::getInstance()->executeS($query);
|
|
}
|
|
|
|
return [];
|
|
}
|
|
|
|
public static function getCookiesPlusUserConsentDataByHash($hash)
|
|
{
|
|
$query = 'SELECT `data`
|
|
FROM `' . _DB_PREFIX_ . "cookiesplus_user_consent`
|
|
WHERE `hash` = '" . pSQL($hash) . "'";
|
|
|
|
return Db::getInstance()->getValue($query);
|
|
}
|
|
}
|