source/Core/SystemRequirements.php
protected function fetchBlockRecords()
    {
        $activeThemeId = oxNew(\OxidEsales\Eshop\Core\Theme::class)->getActiveThemeId();
        $config = Registry::getConfig();
        $database = \OxidEsales\Eshop\Core\DatabaseProvider::getDb(\OxidEsales\Eshop\Core\DatabaseProvider::FETCH_MODE_ASSOC);

        $query = "select * from oxtplblocks where oxactive=1 and oxshopid=? and oxtheme in ('', ?)";

        return $database->select($query, [$config->getShopId(), $activeThemeId]);
    }
protected function fetchBlockRecords()
    {
        $activeThemeId = oxNew(\OxidEsales\Eshop\Core\Theme::class)->getActiveThemeId();
        $config = Registry::getConfig();
        $database = \OxidEsales\Eshop\Core\DatabaseProvider::getDb(\OxidEsales\Eshop\Core\DatabaseProvider::FETCH_MODE_ASSOC);

        $query = "select * from oxtplblocks where oxactive=1 and oxshopid=? and oxtheme in ('', ?)";

        return $database->select($query, [$config->getShopId(), $activeThemeId]);
    }
protected function fetchBlockRecords ( ) { $ activeThemeId = oxNew ( \ OxidEsales \ Eshop \ Core \ Theme :: class ) -> getActiveThemeId ( ) ; $ config = Registry :: getConfig ( ) ; $ database = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: FETCH_MODE_ASSOC ) ; $ query = "select * from oxtplblocks where oxactive=1 and oxshopid=? and oxtheme in ('', ?)" ; return $ database -> select ( $ query , [ $ config -> getShopId ( ) , $ activeThemeId ] ) ; }
Fetch the active template blocks for the active shop and the active theme.

@todo extract oxtplblocks query to ModuleTemplateBlockRepository

@return ResultSetInterface The active template blocks for the active shop and the active theme.
Fetch the active template blocks for the active shop and the active theme .