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