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