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