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);
  }

}