_locale_translate_seek
includes/locale.inc, строка 1977
- Версии
- 6
_locale_translate_seek()
Perform a string search and display results in a table
Связанные темы
Код
<?php
function _locale_translate_seek() {
$output = '';
// We have at least one criterion to match
if ($query = _locale_translate_seek_query()) {
$join = "SELECT s.source, s.location, s.lid, s.textgroup, t.translation, t.language FROM {locales_source} s LEFT JOIN {locales_target} t ON s.lid = t.lid ";
$arguments = array();
$limit_language = FALSE;
// Compute LIKE section
switch ($query['translation']) {
case 'translated':
$where = "WHERE (t.translation LIKE '%%%s%%')";
$orderby = "ORDER BY t.translation";
$arguments[] = $query['string'];
break;
case 'untranslated':
$where = "WHERE (s.source LIKE '%%%s%%' AND t.translation IS NULL)";
$orderby = "ORDER BY s.source";
$arguments[] = $query['string'];
break;
case 'all' :
default:
$where = "WHERE (s.source LIKE '%%%s%%' OR t.translation LIKE '%%%s%%')";
$orderby = '';
$arguments[] = $query['string'];
$arguments[] = $query['string'];
break;
}
$grouplimit = '';
if (!empty($query['group']) && $query['group'] != 'all') {
$grouplimit = " AND s.textgroup = '%s'";
$arguments[] = $query['group'];
}
switch ($query['language']) {
// Force search in source strings
case "en":
$sql = $join ." WHERE s.source LIKE '%%%s%%' $grouplimit ORDER BY s.source";
$arguments = array($query['string']); // $where is not used, discard its arguments
if (!empty($grouplimit)) {
$arguments[] = $query['group'];
}
break;
// Search in all languages
case "all":
$sql = "$join $where $grouplimit $orderby";
break;
// Some different language
default:
$sql = "$join AND t.language = '%s' $where $grouplimit $orderby";
array_unshift($arguments, $query['language']);
// Don't show translation flags for other languages, we can't see them with this search.
$limit_language = $query['language'];
}
$result = pager_query($sql, 50, 0, NULL, $arguments);
$groups = module_invoke_all('locale', 'groups');
$header = array(t('Text group'), t('String'), ($limit_language) ? t('Language') : t('Languages'), array('data' => t('Operations'), 'colspan' => '2'));
$arr = array();
while ($locale = db_fetch_object($result)) {
$arr[$locale->lid]['group'] = $groups[$locale->textgroup];
$arr[$locale->lid]['languages'][$locale->language] = $locale->translation;
$arr[$locale->lid]['location'] = $locale->location;
$arr[$locale->lid]['source'] = $locale->source;
}
$rows = array();
foreach ($arr as $lid => $value) {
$rows[] = array(
$value['group'],
array('data' => check_plain(truncate_utf8($value['source'], 150, FALSE, TRUE)) .'<br /><small>'. $value['location'] .'</small>'),
array('data' => _locale_translate_language_list($value['languages'], $limit_language), 'align' => 'center'),
array('data' => l(t('edit'), "admin/build/translate/edit/$lid"), 'class' => 'nowrap'),
array('data' => l(t('delete'), "admin/build/translate/delete/$lid"), 'class' => 'nowrap'),
);
}
if (count($rows)) {
$output .= theme('table', $header, $rows);
if ($pager = theme('pager', NULL, 50)) {
$output .= $pager;
}
}
else {
$output .= t('No strings found for your search.');
}
}
return $output;
}
?>
Войдите или зарегистрируйтесь, чтобы получить возможность отправлять комментарии