class Block

class Block extends DrupalSqlBase {
    
    /**
     * The default theme name.
     *
     * @var string
     */
    protected $defaultTheme;
    
    /**
     * The admin theme name.
     *
     * @var string
     */
    protected $adminTheme;
    
    /**
     * Table containing block configuration.
     *
     * @var string
     */
    protected $blockTable;
    
    /**
     * Table mapping blocks to user roles.
     *
     * @var string
     */
    protected $blockRoleTable;
    
    /**
     * Table listing user roles.
     *
     * @var string
     */
    protected $userRoleTable;
    
    /**
     * {@inheritdoc}
     */
    public function query() {
        if ($this->getModuleSchemaVersion('system') >= 7000) {
            $this->blockTable = 'block';
            $this->blockRoleTable = 'block_role';
        }
        else {
            $this->blockTable = 'blocks';
            $this->blockRoleTable = 'blocks_roles';
        }
        // Drupal 6 & 7 both use the same name for the user roles table.
        $this->userRoleTable = 'role';
        return $this->select($this->blockTable, 'b')
            ->fields('b');
    }
    
    /**
     * {@inheritdoc}
     */
    protected function initializeIterator() {
        $this->defaultTheme = $this->variableGet('theme_default', 'Garland');
        $this->adminTheme = $this->variableGet('admin_theme', NULL);
        return parent::initializeIterator();
    }
    
    /**
     * {@inheritdoc}
     */
    public function fields() {
        return [
            'bid' => $this->t('The block numeric identifier.'),
            'module' => $this->t('The module providing the block.'),
            'delta' => $this->t("The block's delta."),
            'theme' => $this->t('Which theme the block is placed in.'),
            'status' => $this->t('Whether or not the block is enabled.'),
            'weight' => $this->t('Weight of the block for ordering within regions.'),
            'region' => $this->t('Region the block is placed in.'),
            'visibility' => $this->t('Visibility expression.'),
            'pages' => $this->t('Pages list.'),
            'title' => $this->t('Block title.'),
            'cache' => $this->t('Cache rule.'),
        ];
    }
    
    /**
     * {@inheritdoc}
     */
    public function getIds() {
        $ids['module']['type'] = 'string';
        $ids['delta']['type'] = 'string';
        $ids['theme']['type'] = 'string';
        return $ids;
    }
    
    /**
     * {@inheritdoc}
     */
    public function prepareRow(Row $row) {
        $row->setSourceProperty('default_theme', $this->defaultTheme);
        $row->setSourceProperty('admin_theme', $this->adminTheme);
        $module = $row->getSourceProperty('module');
        $delta = $row->getSourceProperty('delta');
        $query = $this->select($this->blockRoleTable, 'br')
            ->fields('br', [
            'rid',
        ])
            ->condition('module', $module)
            ->condition('delta', $delta);
        $query->join($this->userRoleTable, 'ur', '[br].[rid] = [ur].[rid]');
        $roles = $query->execute()
            ->fetchCol();
        $row->setSourceProperty('roles', $roles);
        $settings = [];
        switch ($module) {
            case 'aggregator':
                [
                    $type,
                    $id,
                ] = explode('-', $delta);
                if ($type == 'feed') {
                    $item_count = $this->select('aggregator_feed', 'af')
                        ->fields('af', [
                        'block',
                    ])
                        ->condition('fid', $id)
                        ->execute()
                        ->fetchField();
                }
                else {
                    $item_count = $this->select('aggregator_category', 'ac')
                        ->fields('ac', [
                        'block',
                    ])
                        ->condition('cid', $id)
                        ->execute()
                        ->fetchField();
                }
                $settings['aggregator']['item_count'] = $item_count;
                break;
            case 'book':
                $settings['book']['block_mode'] = $this->variableGet('book_block_mode', 'all pages');
                break;
            case 'forum':
                $settings['forum']['block_num'] = $this->variableGet('forum_block_num_' . $delta, 5);
                break;
            case 'statistics':
                foreach ([
                    'statistics_block_top_day_num',
                    'statistics_block_top_all_num',
                    'statistics_block_top_last_num',
                ] as $name) {
                    $settings['statistics'][$name] = $this->variableGet($name, 0);
                }
                break;
            case 'user':
                switch ($delta) {
                    case 2:
                    case 'new':
                        $settings['user']['block_whois_new_count'] = $this->variableGet('user_block_whois_new_count', 5);
                        break;
                    case 3:
                    case 'online':
                        $settings['user']['block_seconds_online'] = $this->variableGet('user_block_seconds_online', 900);
                        $settings['user']['max_list_count'] = $this->variableGet('user_block_max_list_count', 10);
                        break;
                }
                break;
        }
        $row->setSourceProperty('settings', $settings);
        return parent::prepareRow($row);
    }

}