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