/**
* @param $table
* @param $field
*/
public static function convertTranslationField($table, $field)
{
$backup = $field . '_backup';
$objDatabase = \Database::getInstance();
// Backup the original column and then change the column type
if (!$objDatabase->fieldExists($backup, $table, true)) {
$objDatabase->query("ALTER TABLE `{$table}` ADD `{$backup}` text NULL");
$objDatabase->query("UPDATE `{$table}` SET `{$backup}`=`{$field}`");
$objDatabase->query("ALTER TABLE `{$table}` CHANGE `{$field}` `{$field}` int(10) unsigned NOT NULL default '0'");
$objDatabase->query("UPDATE `{$table}` SET `{$field}`='0'");
}
$objRow = $objDatabase->query("SELECT id, {$backup} FROM {$table} WHERE {$backup}!=''");
while ($objRow->next()) {
if (is_numeric($objRow->{$backup})) {
$intFid = $objRow->{$backup};
} else {
if (strlen($objRow->{$backup}) > 0) {
$intFid = \TranslationFieldsWidgetHelper::saveValuesAndReturnFid(\TranslationFieldsWidgetHelper::addValueToAllLanguages($objRow->{$backup}));
} else {
$intFid = 0;
}
}
$objDatabase->prepare("UPDATE {$table} SET {$field}=? WHERE id=?")->execute($intFid, $objRow->id);
}
}
/**
* @param $strField
*/
protected function addTranslationContentToField($strField)
{
if ($this->Config->get($strField) === null) {
$arrValues = array();
\System::loadLanguageFile('tl_email', 'de', true);
$arrValues['de'] = $GLOBALS['TL_LANG']['tl_email']['defaultContents'][$strField];
\System::loadLanguageFile('tl_email', 'en', true);
$arrValues['en'] = $GLOBALS['TL_LANG']['tl_email']['defaultContents'][$strField];
// Load translation file by current language
\System::loadLanguageFile('tl_email', null, true);
$this->Config->persist($strField, \TranslationFieldsWidgetHelper::saveValuesAndReturnFid($arrValues));
}
}
/**
* @return string
*/
public function generate()
{
$type = $this->hideInput ? 'password' : 'text';
// Get post array
$arrPost = \Input::post($this->strName);
// Get languages array with values
$this->varValue = \TranslationFieldsWidgetHelper::getTranslationsByFid($this->varValue);
// Generate langauge fields
$arrLngInputs = \TranslationFieldsWidgetHelper::getInputTranslationLanguages($this->varValue);
$arrFields = array();
$i = 0;
foreach ($arrLngInputs as $value) {
$arrFields[] = sprintf('<div class="tf_field_wrap tf_field_wrap_%s%s"><input type="%s" name="%s[%s]" id="ctrl_%s" class="tf_field tl_text" value="%s"%s onfocus="Backend.getScrollOffset()"></div>', $value, $i > 0 ? ' hide' : '', $type, $this->strName, $value, $this->strId . '_' . $value, specialchars($arrPost[$value] !== null ? $arrPost[$value] : @$this->varValue[$value]), $this->getAttributes());
$i++;
}
// Get language button
$strLngButton = \TranslationFieldsWidgetHelper::getCurrentTranslationLanguageButton();
// Get language list
$strLngList = \TranslationFieldsWidgetHelper::getTranslationLanguagesList($this->varValue);
return sprintf('<div id="ctrl_%s" class="tf_wrap tf_text_wrap%s">%s%s%s</div>%s', $this->strId, $this->strClass != '' ? ' ' . $this->strClass : '', implode(' ', $arrFields), $strLngButton, $strLngList, $this->wizard);
}
/**
* @return string
* @throws \Exception
*/
public function generate()
{
// Get post array
$arrPost = \Input::post($this->strName);
// Get languages array with values
$this->varValue = \TranslationFieldsWidgetHelper::getTranslationsByFid($this->varValue);
// Generate langauge fields
$arrLngInputs = \TranslationFieldsWidgetHelper::getInputTranslationLanguages($this->varValue);
$arrFields = array();
for ($i = 0; $i < count($arrLngInputs); $i++) {
$value = $arrLngInputs[$i];
$strRte = $GLOBALS['TL_DCA'][$this->strTable]['fields'][$this->strField]['eval']['rte'];
$key = 'ctrl_' . $this->strId . '_' . $value;
$strScript = $this->getRteScriptByTranslatedField($strRte, $key);
$arrFields[] = sprintf('<div class="tf_field_wrap tf_field_wrap_%s%s"><textarea name="%s[%s]" id="%s" class="tf_field tl_textarea" rows="%s" cols="%s"%s onfocus="Backend.getScrollOffset()">%s</textarea>%s</div>', $value, $i > 0 ? ' hide' : '', $this->strName, $value, $key, $this->intRows, $this->intCols, $this->getAttributes(), specialchars($arrPost[$value] !== null ? $arrPost[$value] : @$this->varValue[$value]), $strScript);
}
// Get language button
$strLngButton = \TranslationFieldsWidgetHelper::getCurrentTranslationLanguageButton();
// Get language list
$strLngList = \TranslationFieldsWidgetHelper::getTranslationLanguagesList($this->varValue);
return sprintf('<div id="ctrl_%s_tf" class="tf_wrap tf_textarea_wrap%s%s">%s%s%s</div>%s', $this->strId, $this->strClass != '' ? ' ' . $this->strClass : '', !empty($this->rte) ? ' rte' : '', implode(' ', $arrFields), $strLngButton, $strLngList, $this->wizard);
}
/**
* @return string
*/
public function generate()
{
$arrUnits = array();
foreach ($this->arrUnits as $arrUnit) {
$arrUnits[] = sprintf('<option value="%s"%s>%s</option>', specialchars($arrUnit['value']), $this->isSelected($arrUnit), $arrUnit['label']);
}
if (!is_array($this->varValue)) {
$this->varValue = array('value' => $this->varValue);
}
// Get languages array with values
$this->varValue['value'] = \TranslationFieldsWidgetHelper::getTranslationsByFid($this->varValue['value']);
// Generate langauge fields
$arrLngInputs = \TranslationFieldsWidgetHelper::getInputTranslationLanguages($this->varValue['value']);
$arrFields = array();
$i = 0;
foreach ($arrLngInputs as $value) {
$arrFields[] = sprintf('<div class="tf_field_wrap tf_field_wrap_%s%s"><input type="text" name="%s[value][%s]" id="ctrl_%s" class="tf_field tl_text_unit" value="%s"%s onfocus="Backend.getScrollOffset()"></div>', $value, $i > 0 ? ' hide' : '', $this->strName, $value, $this->strId . '_' . $value, specialchars(@$this->varValue['value'][$value]), $this->getAttributes());
$i++;
}
$strUnit = sprintf('<select name="%s[unit]" class="tl_select_unit" onfocus="Backend.getScrollOffset()">%s</select>', $this->strName, implode('', $arrUnits));
// Get language button
$strLngButton = \TranslationFieldsWidgetHelper::getCurrentTranslationLanguageButton();
// Get language list
$strLngList = \TranslationFieldsWidgetHelper::getTranslationLanguagesList($this->varValue);
return sprintf('<div id="ctrl_%s" class="tf_wrap tf_text_unit_wrap%s">%s %s%s%s</div>%s', $this->strId, $this->strClass != '' ? ' ' . $this->strClass : '', implode(' ', $arrFields), $strUnit, $strLngButton, $strLngList, $this->wizard);
}