globallink_locale_mapping.inc in GlobalLink Connect for Drupal 7.6

globallink_locale_mapping.inc is a file that contains most functions needed on the Locale Mapping UI.

File

globallink_locale_mapping.inc

<?php

/**
 * @file
 * globallink_locale_mapping.inc is a file that contains most functions
 * needed on the Locale Mapping UI.
 */

/**
 * Returns form for globallink_locale page.
 */
function globallink_locale_page() {
  return drupal_get_form('globallink_locale');
}

/**
 * Renders form for globallink_locale.
 */
function globallink_locale() {
  $form = array();
  $languages = language_list('language', TRUE);
  $mapped_languages = globallink_get_mapped_locale_codes();
  if (sizeof($mapped_languages) > 0) {
    foreach ($mapped_languages as $mlang) {
      foreach ($languages as $language) {
        if ($language->language == $mlang) {
          unset($languages[$mlang]);
          break;
        }
      }
    }
  }
  $drupal_list = array();
  foreach ($languages as $language) {
    if ($language->enabled == 1) {
      $drupal_list[$language->language . '|' . $language->name] = $language->name;
    }
  }
  $tpt_list = globallink_get_tpt_list();
  $header = array(
    'drupal_locale_code' => array(
      'field' => 'tl.drupal_locale_desc',
      'data' => t('Drupal Site Locales'),
    ),
    'locale_code' => array(
      'field' => 'tl.locale_desc',
      'data' => t('GlobalLink Locales'),
    ),
  );
  $query = db_select('globallink_locale', 'tl')
    ->isNotNull('drupal_locale_code')
    ->fields('tl')
    ->extend('PagerDefault')
    ->limit(TPT_PAGER_LIMIT)
    ->extend('TableSort')
    ->orderByHeader($header);
  $results = $query
    ->execute();
  $count = 0;
  $rows = array();
  foreach ($results as $item) {
    $count++;
    $rows[$item->locale_code] = array(
      'drupal_locale_code' => $item->drupal_locale_desc,
      'locale_code' => $item->locale_desc,
    );
  }
  $form['table'] = array(
    '#type' => 'tableselect',
    '#header' => $header,
    '#options' => $rows,
    '#empty' => t('No items available'),
  );
  $form['pager'] = array(
    '#markup' => theme('pager'),
  );
  if ($count > 0) {
    $form['submit_locale_delete'] = array(
      '#type' => 'submit',
      '#value' => t('Delete'),
    );
  }
  $form['locale_mapping'] = array(
    '#title' => t('Locale Mapping'),
    '#type' => 'fieldset',
    '#description' => t('Map the Drupal locales with GlobalLink locales'),
    '#collapsible' => TRUE,
    '#collapsed' => FALSE,
  );
  if (sizeof($drupal_list) > 0) {
    $form['locale_mapping']['drupal_locale_list'] = array(
      '#title' => t('Drupal Locale'),
      '#type' => 'select',
      '#options' => $drupal_list,
    );
    $form['locale_mapping']['tpt_locale_list'] = array(
      '#title' => t('GlobalLink Locale'),
      '#type' => 'select',
      '#options' => $tpt_list,
    );
    $form['locale_mapping']['submit_locale_add'] = array(
      '#type' => 'submit',
      '#value' => t('Add'),
    );
  }
  else {
    $form['locale_mapping']['no_mapping'] = array(
      '#type' => 'markup',
      '#prefix' => '<br/><b><i>',
      '#markup' => t('Nothing to Map'),
      '#suffix' => '</i></b>',
    );
  }
  return $form;
}

/**
 * Handles validation of globallink_locale form.
 */
function globallink_locale_validate($form, &$form_state) {
  $op = isset($form_state['values']['op']) ? $form_state['values']['op'] : '';
  if ($form_state['triggering_element'] != 'globallink_locale_mapping_submit') {
    return;
  }
  $rids = array_filter($form_state['values']['table']);
  if (count($rids) == 0) {
    form_set_error('', t('No items selected.'));
  }
}

/**
 * Handles submission of globallink_locale form.
 */
function globallink_locale_submit($form, &$form_state) {
  module_load_include('inc', 'globallink', 'globallink');
  $op = isset($form_state['values']['op']) ? $form_state['values']['op'] : '';
  if ($op == t('Add')) {
    $drupal_seleced_locale = $form_state['values']['drupal_locale_list'];
    $drupal_locale = explode('|', $drupal_seleced_locale);
    $locale_code = $form_state['values']['tpt_locale_list'];
    globallink_add_locale_mapping($drupal_locale[0], $drupal_locale[1], $locale_code);
    drupal_set_message(t('Mapping added successfully.'));
  }
  else {
    $locales_arr = array_filter($form_state['values']['table']);
    foreach ($locales_arr as $locale) {
      $locale_name = globallink_get_drupal_locale_name($locale);
      if (globallink_check_pending_submission($locale)) {
        globallink_delete_locale_mapping($locale);
        drupal_set_message(t('@locale mapping deleted successfully.', array(
          '@locale' => check_plain($locale_name),
        )));
      }
      else {
        form_set_error('', t('@locale mapping cannot be deleted because there is a pending submission.', array(
          '@locale' => check_plain($locale_name),
        )));
      }
    }
  }
}

/**
 * Checks pending submission by locale.
 *
 * @param string $locale
 *   The locale.
 *
 * @return bool
 *   TRUE if the submission has not yet been sent.  FALSE otherwise.
 */
function globallink_check_pending_submission($locale) {
  $query1 = db_select('globallink_core', 'tc')
    ->fields('tc', array(
    'rid',
  ))
    ->condition('tc.status', array(
    'Sent for Translations',
    'Error',
  ), 'IN')
    ->condition(db_or()
    ->condition('tc.source', $locale)
    ->condition('tc.target', $locale));
  $table_arr = array(
    'tce' => 'globallink_core_entity',
    'tcb' => 'globallink_core_block',
    'tci' => 'globallink_core_interface',
    'tcm' => 'globallink_core_menu',
    'tct' => 'globallink_core_taxonomy',
    'tcw' => 'globallink_core_webform',
  );
  foreach ($table_arr as $key => $table) {
    if (db_table_exists($table)) {
      $query2 = db_select($table, $key)
        ->fields($key, array(
        'rid',
      ))
        ->condition($key . '.status', array(
        'Sent for Translations',
        'Error',
      ), 'IN')
        ->condition(db_or()
        ->condition($key . '.source', $locale)
        ->condition($key . '.target', $locale));
      $query1
        ->union($query2, 'UNION ALL');
    }
  }
  $result = $query1
    ->execute();
  foreach ($result as $row) {
    if (isset($row)) {
      return FALSE;
    }
  }
  return TRUE;
}

/**
 * Adds locale mapping for Drupal locales.
 *
 * @param string $drupal_locale
 *   The Drupal locale.
 * @param string $drupal_locale_desc
 *   The Drupal locale description.
 * @param string $locale_code
 *   The locale code.
 */
function globallink_add_locale_mapping($drupal_locale, $drupal_locale_desc, $locale_code) {
  db_update('globallink_locale')
    ->fields(array(
    'drupal_locale_code' => $drupal_locale,
    'drupal_locale_desc' => $drupal_locale_desc,
  ))
    ->condition('locale_code', $locale_code, '=')
    ->execute();
}

/**
 * Deletes locale mapping.
 *
 * @param string $locale_code
 *   The code for the locale to delete.
 */
function globallink_delete_locale_mapping($locale_code) {
  db_update('globallink_locale')
    ->fields(array(
    'drupal_locale_code' => NULL,
  ))
    ->condition('locale_code', $locale_code, '=')
    ->execute();
}

/**
 * Gets locale list.
 *
 * @return array
 *   Associative array of locales.
 */
function globallink_get_tpt_list() {
  $languages = array();
  $result = db_select('globallink_locale', 'tl')
    ->fields('tl')
    ->isNull('drupal_locale_code')
    ->orderBy('locale_desc', 'ASC')
    ->execute();
  foreach ($result as $row) {
    $languages[$row->locale_code] = $row->locale_desc;
  }
  return $languages;
}

/**
 * Gets mapped locale codes.
 *
 * @return array
 *   Associative array of mapped locale codes.
 */
function globallink_get_mapped_locale_codes() {
  $languages = array();
  $result = db_select('globallink_locale', 'tl')
    ->fields('tl')
    ->isNotNull('drupal_locale_code')
    ->orderBy('locale_desc', 'ASC')
    ->execute();
  foreach ($result as $row) {
    $languages[$row->locale_code] = $row->drupal_locale_code;
  }
  return $languages;
}

Functions

Name	Description
globallink_add_locale_mapping	Adds locale mapping for Drupal locales.
globallink_check_pending_submission	Checks pending submission by locale.
globallink_delete_locale_mapping	Deletes locale mapping.
globallink_get_mapped_locale_codes	Gets mapped locale codes.
globallink_get_tpt_list	Gets locale list.
globallink_locale	Renders form for globallink_locale.
globallink_locale_page	Returns form for globallink_locale page.
globallink_locale_submit	Handles submission of globallink_locale form.
globallink_locale_validate	Handles validation of globallink_locale form.