Files
drmaterac.pl/modules/psgdpr/classes/GDPRConsent.php
2025-01-06 20:47:25 +01:00

139 lines
4.7 KiB
PHP

<?php
/**
* 2007-2018 PrestaShop
*
* NOTICE OF LICENSE
*
* This source file is subject to the Academic Free License (AFL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/afl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to license@prestashop.com so we can send you a copy immediately.
*
* DISCLAIMER
*
* Do not edit or add to this file if you wish to upgrade PrestaShop to newer
* versions in the future. If you wish to customize PrestaShop for your
* needs please refer to http://www.prestashop.com for more information.
*
* @author PrestaShop SA <contact@prestashop.com>
* @copyright 2007-2018 PrestaShop SA
* @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0)
* International Registered Trademark & Property of PrestaShop SA
*/
class GDPRConsent extends ObjectModel
{
public $id;
public $id_module;
public $active;
public $error;
public $error_message;
public $date_add;
public $date_upd;
/**
* @see ObjectModel::$definition
*/
public static $definition = array(
'table' => 'psgdpr_consent',
'primary' => 'id_gdpr_consent',
'multilang' => true,
'multilang_shop' => true,
'fields' => array(
// Config fields
'id_module' => array('type' => self::TYPE_INT, 'validate' => 'isInt', 'required' => true),
'active' => array('type' => self::TYPE_BOOL, 'validate' => 'isBool', 'required' => true),
'error' => array('type' => self::TYPE_BOOL, 'validate' => 'isBool', 'required' => false),
'error_message' => array('type' => self::TYPE_HTML, 'validate' => 'isCleanHtml', 'required' => false),
// Lang fields
'message' => array('type' => self::TYPE_HTML, 'lang' => true, 'validate' => 'isCleanHtml', 'size' => 4000),
'date_add' => array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
'date_upd' => array('type' => self::TYPE_DATE, 'validate' => 'isDate'),
)
);
public function add($autoDate = true, $nullValues = false)
{
$return = parent::add($autoDate, $nullValues);
return $return;
}
/**
* Return the list of all the modules registered on our hook and active
*
* @param int $id_lang language of the shop
*
* @return array who contains id_module, message
*/
public static function getAllRegisteredModules()
{
$sql = 'SELECT psgdpr.id_gdpr_consent, psgdpr.id_module FROM `'._DB_PREFIX_.'psgdpr_consent` psgdpr';
$result = Db::getInstance()->executeS($sql);
return $result;
}
/**
* Return the Consent Message registered for a specificed module in the right language
*
* @param int $id_module id of the specified module
* @param int $id_lang id of the language used
*
* @return string the Consent Message
*/
public static function getConsentMessage($id_module, $id_lang)
{
$sql = 'SELECT psgdprl.message FROM `'._DB_PREFIX_.'psgdpr_consent` psgdpr
LEFT JOIN '._DB_PREFIX_.'psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = '.(int)$id_module.' AND psgdprl.id_lang ='.(int)$id_lang;
$result = Db::getInstance()->getValue($sql);
return $result;
}
/**
* Return the Consent module active
*
* @param int $id_module id of the specified module
*
* @return int if the module consent is enable or not
*/
public static function getConsentActive($id_module)
{
$sql = 'SELECT psgdpr.active FROM `'._DB_PREFIX_.'psgdpr_consent` psgdpr
WHERE psgdpr.id_module = '.(int)$id_module;
$result = (bool) Db::getInstance()->getValue($sql);
return $result;
}
/**
* Allow to know if the module has been already added in the database
*
* @param int $id_module id of the module
* @param int $id_shop id of the current shop
*
* @return bool true if the module already exist or false if not
*/
public static function checkIfExist($id_module, $id_shop)
{
$sql = 'SELECT id_module FROM `'._DB_PREFIX_.'psgdpr_consent` psgdpr
LEFT JOIN '._DB_PREFIX_.'psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = '.(int)$id_module.' AND psgdprl.id_shop ='.(int)$id_shop;
$result = Db::getInstance()->getRow($sql);
if ($result) {
return true;
} else {
return false;
}
}
}