function BlockCustomTranslation::query

Overrides SqlBase::query

File

core/modules/block_content/src/Plugin/migrate/source/d7/BlockCustomTranslation.php, line 35

Class

BlockCustomTranslation

Drupal 7 i18n custom block translations source from database.

Namespace

Code

public function query() {
    // Build a query based on blockCustomTable table where each row has the
    // translation for only one property, either title or description. The
    // method prepareRow() is then used to obtain the translation for the
    // other property.
    $query = $this->select(static::CUSTOM_BLOCK_TABLE, 'b')
        ->fields('b', [
        'bid',
        'format',
        'body',
    ])
        ->fields('i18n', [
        'property',
    ])
        ->fields('lt', [
        'lid',
        'translation',
        'language',
    ])
        ->orderBy('b.bid');
    // Use 'title' for the info field to match the property name in
    // i18nStringTable.
    $query->addField('b', 'info', 'title');
    // Add in the property, which is either title or body. Cast the bid to text
    // so PostgreSQL can make the join.
    $query->leftJoin(static::I18N_STRING_TABLE, 'i18n', '[i18n].[objectid] = CAST([b].[bid] AS CHAR(255))');
    $query->condition('i18n.type', 'block');
    // Add in the translation for the property.
    $query->innerJoin('locales_target', 'lt', '[lt].[lid] = [i18n].[lid]');
    return $query;
}