source/Core/Module/ModuleTemplateBlockRepository.php
public function getBlocksCount($modulesId, $shopId)
    {
        $db = \OxidEsales\Eshop\Core\DatabaseProvider::getDb(\OxidEsales\Eshop\Core\DatabaseProvider::FETCH_MODE_ASSOC);
        $modulesIdQuery = implode(", ", \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quoteArray($modulesId));
        $sql = "select COUNT(*)
                            from oxtplblocks
                            where oxactive=1
                                and oxshopid = ?
                                and oxmodule in ( " . $modulesIdQuery . " )";

        return $db->getOne($sql, [$shopId]);
    }
public function getBlocksCount($modulesId, $shopId)
    {
        $db = \OxidEsales\Eshop\Core\DatabaseProvider::getDb(\OxidEsales\Eshop\Core\DatabaseProvider::FETCH_MODE_ASSOC);
        $modulesIdQuery = implode(", ", \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->quoteArray($modulesId));
        $sql = "select COUNT(*)
                            from oxtplblocks
                            where oxactive=1
                                and oxshopid = ?
                                and oxmodule in ( " . $modulesIdQuery . " )";

        return $db->getOne($sql, [$shopId]);
    }
public function getBlocksCount ( $ modulesId , $ shopId ) { $ db = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: FETCH_MODE_ASSOC ) ; $ modulesIdQuery = implode ( ", " , \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) -> quoteArray ( $ modulesId ) ) ; $ sql = "select COUNT(*)
                            from oxtplblocks
                            where oxactive=1
                                and oxshopid = ?
                                and oxmodule in ( " . $ modulesIdQuery . " )" ; return $ db -> getOne ( $ sql , [ $ shopId ] ) ; }
Return how many blocks of provided module overrides any template for active shop.

@param array  $modulesId list of modules to check if their template blocks overrides some shop block.
@param string $shopId    shop id to check if some module block overrides some template blocks in this Shop.

@return string count of blocks for Shop=$shopId from modules=$modulesId.
Return how many blocks of provided module overrides any template for active shop .