/home/sharedstore/.trash/modules/cz_navcmsblock/classes
Edit: /home/sharedstore/.trash/modules/cz_navcmsblock/classes/NavCmsBlock.php (2461B)
* @copyright Since 2007 PrestaShop SA and Contributors
* @license https://opensource.org/licenses/AFL-3.0 Academic Free License 3.0 (AFL-3.0)
*/
class NavCmsBlock extends ObjectModel
{
/**
* Identifier of NavCmsBlock
*
* @var int
*/
public $id_cznavcmsblockinfo;
/**
* HTML format of NavCmsBlock values
*
* @var array
*/
public $text;
/**
* @see ObjectModel::$definition
*/
public static $definition = [
'table' => 'cznavcmsblockinfo',
'primary' => 'id_cznavcmsblockinfo',
'multilang' => true,
'multilang_shop' => true,
'fields' => [
'id_cznavcmsblockinfo' => ['type' => self::TYPE_NOTHING, 'validate' => 'isUnsignedId'],
// Lang fields
'text' => ['type' => self::TYPE_HTML, 'lang' => true, 'validate' => 'isCleanHtml', 'required' => true],
],
];
/**
* Return the NavCmsBlock ID By shop ID
*
* @param int $shopId
*
* @return bool|int
*/
public static function getNavCmsBlockIdByShop($shopId)
{
$sql = 'SELECT i.`id_cznavcmsblockinfo` FROM `' . _DB_PREFIX_ . 'cznavcmsblockinfo` i
LEFT JOIN `' . _DB_PREFIX_ . 'cznavcmsblockinfo_shop` ish ON ish.`id_cznavcmsblockinfo` = i.`id_cznavcmsblockinfo`
WHERE ish.`id_shop` = ' . (int) $shopId;
if ($result = Db::getInstance()->executeS($sql)) {
return (int) reset($result)['id_cznavcmsblockinfo'];
}
return false;
}
}