1<?php
2/* Copyright (C) 2007-2020	Laurent Destailleur	<eldy@users.sourceforge.net>
3 * Copyright (C) 2009-2017	Regis Houssin		<regis.houssin@inodbox.com>
4 * Copyright (C) 2017       Frédéric France     <frederic.france@free.fr>
5 *
6 * This program is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 3 of the License, or
9 * (at your option) any later version.
10 *
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
14 * GNU General Public License for more details.
15 *
16 * You should have received a copy of the GNU General Public License
17 * along with this program. If not, see <https://www.gnu.org/licenses/>.
18 */
19
20/**
21 *       \file       htdocs/admin/translation.php
22 *       \brief      Page to show translation information
23 */
24
25require '../main.inc.php';
26require_once DOL_DOCUMENT_ROOT.'/core/lib/admin.lib.php';
27require_once DOL_DOCUMENT_ROOT.'/core/lib/files.lib.php';
28require_once DOL_DOCUMENT_ROOT.'/core/class/html.formadmin.class.php';
29
30// Load translation files required by the page
31$langs->loadLangs(array("companies", "products", "admin", "sms", "other", "errors"));
32
33if (!$user->admin) accessforbidden();
34
35$id = GETPOST('rowid', 'int');
36$action = GETPOST('action', 'aZ09');
37
38$langcode = GETPOST('langcode', 'alphanohtml');
39$transkey = GETPOST('transkey', 'alphanohtml');
40$transvalue = GETPOST('transvalue', 'restricthtml');
41
42
43$mode = GETPOST('mode', 'aZ09') ?GETPOST('mode', 'aZ09') : 'searchkey';
44
45$limit = GETPOST('limit', 'int') ?GETPOST('limit', 'int') : $conf->liste_limit;
46$sortfield = GETPOST("sortfield", 'alpha');
47$sortorder = GETPOST("sortorder", 'alpha');
48$page = GETPOSTISSET('pageplusone') ? (GETPOST('pageplusone') - 1) : GETPOST("page", 'int');
49if (empty($page) || $page == -1) { $page = 0; }     // If $page is not defined, or '' or -1
50$offset = $limit * $page;
51$pageprev = $page - 1;
52$pagenext = $page + 1;
53if (!$sortfield) $sortfield = 'lang,transkey';
54if (!$sortorder) $sortorder = 'ASC';
55
56// Initialize technical object to manage hooks of page. Note that conf->hooks_modules contains array of hook context
57$hookmanager->initHooks(array('admintranslation', 'globaladmin'));
58
59
60/*
61 * Actions
62 */
63
64if (GETPOST('cancel', 'alpha')) { $action = 'list'; $massaction = ''; }
65if (!GETPOST('confirmmassaction', 'alpha') && $massaction != 'presend' && $massaction != 'confirm_presend') { $massaction = ''; }
66
67$parameters = array('socid'=>$socid);
68$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
69if ($reshook < 0) setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
70
71include DOL_DOCUMENT_ROOT.'/core/actions_changeselectedfields.inc.php';
72
73// Purge search criteria
74if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) // All tests are required to be compatible with all browsers
75{
76	$transkey = '';
77	$transvalue = '';
78	$toselect = '';
79	$search_array_options = array();
80}
81
82if ($action == 'setMAIN_ENABLE_OVERWRITE_TRANSLATION')
83{
84	if (GETPOST('value')) dolibarr_set_const($db, 'MAIN_ENABLE_OVERWRITE_TRANSLATION', 1, 'chaine', 0, '', $conf->entity);
85	else dolibarr_set_const($db, 'MAIN_ENABLE_OVERWRITE_TRANSLATION', 0, 'chaine', 0, '', $conf->entity);
86}
87
88if ($action == 'update')
89{
90	if ($transvalue == '')
91	{
92		setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("NewTranslationStringToShow")), null, 'errors');
93		$error++;
94	}
95	if (!$error)
96	{
97		$db->begin();
98
99		$sql = "UPDATE ".MAIN_DB_PREFIX."overwrite_trans set transvalue = '".$db->escape($transvalue)."' WHERE rowid = ".GETPOST('rowid', 'int');
100		$result = $db->query($sql);
101		if ($result > 0)
102		{
103			$db->commit();
104			setEventMessages($langs->trans("RecordSaved"), null, 'mesgs');
105			$action = "";
106			$transkey = "";
107			$transvalue = "";
108		} else {
109			$db->rollback();
110			if ($db->lasterrno() == 'DB_ERROR_RECORD_ALREADY_EXISTS')
111			{
112				setEventMessages($langs->trans("WarningAnEntryAlreadyExistForTransKey"), null, 'warnings');
113			} else {
114				setEventMessages($db->lasterror(), null, 'errors');
115			}
116			$action = '';
117		}
118	}
119}
120
121if ($action == 'add')
122{
123	$error = 0;
124
125	if (empty($langcode))
126	{
127		setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Language")), null, 'errors');
128		$error++;
129	}
130	if ($transkey == '')
131	{
132		setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Key")), null, 'errors');
133		$error++;
134	}
135	if ($transvalue == '')
136	{
137		setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("NewTranslationStringToShow")), null, 'errors');
138		$error++;
139	}
140	if (!$error)
141	{
142		$db->begin();
143
144		$sql = "INSERT INTO ".MAIN_DB_PREFIX."overwrite_trans(lang, transkey, transvalue, entity) VALUES ('".$db->escape($langcode)."','".$db->escape($transkey)."','".$db->escape($transvalue)."', ".$db->escape($conf->entity).")";
145		$result = $db->query($sql);
146		if ($result > 0)
147		{
148			$db->commit();
149			setEventMessages($langs->trans("RecordSaved"), null, 'mesgs');
150			$action = "";
151			$transkey = "";
152			$transvalue = "";
153		} else {
154			$db->rollback();
155			if ($db->lasterrno() == 'DB_ERROR_RECORD_ALREADY_EXISTS')
156			{
157				setEventMessages($langs->trans("WarningAnEntryAlreadyExistForTransKey"), null, 'warnings');
158			} else {
159				setEventMessages($db->lasterror(), null, 'errors');
160			}
161			$action = '';
162		}
163	}
164}
165
166// Delete line from delete picto
167if ($action == 'delete')
168{
169	$sql = "DELETE FROM ".MAIN_DB_PREFIX."overwrite_trans WHERE rowid = ".$db->escape($id);
170	$result = $db->query($sql);
171	if ($result >= 0)
172	{
173		setEventMessages($langs->trans("RecordDeleted"), null, 'mesgs');
174	} else {
175		dol_print_error($db);
176	}
177}
178
179
180
181
182
183/*
184 * View
185 */
186
187$form = new Form($db);
188$formadmin = new FormAdmin($db);
189
190$wikihelp = 'EN:Setup_Translation|FR:Paramétrage_Traduction|ES:Configuración_Traducción';
191llxHeader('', $langs->trans("Setup"), $wikihelp);
192
193$param = '&mode='.urlencode($mode);
194
195$enabledisablehtml = '';
196$enabledisablehtml .= $langs->trans("EnableOverwriteTranslation").' ';
197if (empty($conf->global->MAIN_ENABLE_OVERWRITE_TRANSLATION))
198{
199	// Button off, click to enable
200	$enabledisablehtml .= '<a class="reposition valignmiddle" href="'.$_SERVER["PHP_SELF"].'?action=setMAIN_ENABLE_OVERWRITE_TRANSLATION&token='.newToken().'&value=1'.$param.'">';
201	$enabledisablehtml .= img_picto($langs->trans("Disabled"), 'switch_off');
202	$enabledisablehtml .= '</a>';
203} else {
204	// Button on, click to disable
205	$enabledisablehtml .= '<a class="reposition valignmiddle" href="'.$_SERVER["PHP_SELF"].'?action=setMAIN_ENABLE_OVERWRITE_TRANSLATION&token='.newToken().'&value=0'.$param.'">';
206	$enabledisablehtml .= img_picto($langs->trans("Activated"), 'switch_on');
207	$enabledisablehtml .= '</a>';
208}
209
210print load_fiche_titre($langs->trans("Translation"), $enabledisablehtml, 'title_setup');
211
212$current_language_code = $langs->defaultlang;
213$s = picto_from_langcode($current_language_code);
214print $form->textwithpicto('<span class="opacitymedium">'.$langs->trans("CurrentUserLanguage").':</span> <strong>'.$s.' '.$current_language_code.'</strong>', $langs->trans("TranslationDesc")).'</span><br>';
215
216print '<br>';
217
218if (!empty($contextpage) && $contextpage != $_SERVER["PHP_SELF"]) $param .= '&contextpage='.urlencode($contextpage);
219if ($limit > 0 && $limit != $conf->liste_limit) $param .= '&limit='.urlencode($limit);
220if ($optioncss != '') $param .= '&optioncss='.urlencode($optioncss);
221if ($langcode)        $param .= '&langcode='.urlencode($langcode);
222if ($transkey)        $param .= '&transkey='.urlencode($transkey);
223if ($transvalue)      $param .= '&transvalue='.urlencode($transvalue);
224
225
226print '<form action="'.$_SERVER["PHP_SELF"].((empty($user->entity) && $debug) ? '?debug=1' : '').'" method="POST">';
227if ($optioncss != '') print '<input type="hidden" name="optioncss" value="'.$optioncss.'">';
228print '<input type="hidden" name="token" value="'.newToken().'">';
229print '<input type="hidden" name="formfilteraction" id="formfilteraction" value="list">';
230print '<input type="hidden" name="sortfield" value="'.$sortfield.'">';
231print '<input type="hidden" name="sortorder" value="'.$sortorder.'">';
232
233$head = translation_prepare_head();
234
235print dol_get_fiche_head($head, $mode, '', -1, '');
236
237if ($mode == 'overwrite')
238{
239	print '<input type="hidden" name="page" value="'.$page.'">';
240
241	$disabled = '';
242	if ($action == 'edit' || empty($conf->global->MAIN_ENABLE_OVERWRITE_TRANSLATION)) $disabled = ' disabled="disabled"';
243	$disablededit = '';
244	if ($action == 'edit' || empty($conf->global->MAIN_ENABLE_OVERWRITE_TRANSLATION)) $disablededit = ' disabled';
245
246	print '<div class="justify"><span class="opacitymedium">';
247	print img_info().' '.$langs->trans("SomeTranslationAreUncomplete");
248	$urlwikitranslatordoc = 'https://wiki.dolibarr.org/index.php/Translator_documentation';
249	print ' ('.str_replace('{s1}', '<a href="'.$urlwikitranslatordoc.'" target="_blank">'.$langs->trans("Here").'</a>', $langs->trans("SeeAlso", '{s1}')).')<br>';
250	print $langs->trans("TranslationOverwriteDesc", $langs->transnoentitiesnoconv("Language"), $langs->transnoentitiesnoconv("Key"), $langs->transnoentitiesnoconv("NewTranslationStringToShow"))."\n";
251	print ' ('.$langs->trans("TranslationOverwriteDesc2").').'."<br>\n";
252	print '</span></div>';
253
254	print '<br>';
255
256
257	print '<input type="hidden" name="action" value="'.($action == 'edit' ? 'update' : 'add').'">';
258	print '<input type="hidden" id="mode" name="mode" value="'.$mode.'">';
259
260	print '<div class="div-table-responsive-no-min">';
261	print '<table class="noborder centpercent">';
262	print '<tr class="liste_titre">';
263	print_liste_field_titre("Language_en_US_es_MX_etc", $_SERVER["PHP_SELF"], 'lang,transkey', '', $param, '', $sortfield, $sortorder);
264	print_liste_field_titre("Key", $_SERVER["PHP_SELF"], 'transkey', '', $param, '', $sortfield, $sortorder);
265	print_liste_field_titre("NewTranslationStringToShow", $_SERVER["PHP_SELF"], 'transvalue', '', $param, '', $sortfield, $sortorder);
266	//if (! empty($conf->multicompany->enabled) && !$user->entity) print_liste_field_titre("Entity", $_SERVER["PHP_SELF"], 'entity,transkey', '', $param, '', $sortfield, $sortorder);
267	print '<td align="center"></td>';
268	print "</tr>\n";
269
270
271	// Line to add new record
272	print "\n";
273
274	print '<tr class="oddeven"><td>';
275	print $formadmin->select_language(GETPOST('langcode'), 'langcode', 0, null, 1, 0, $disablededit ? 1 : 0, 'maxwidthonsmartphone', 1);
276	print '</td>'."\n";
277	print '<td>';
278	print '<input type="text" class="flat maxwidthonsmartphone"'.$disablededit.' name="transkey" id="transkey" value="'.(!empty($transkey) ? $transkey : "").'">';
279	print '</td><td>';
280	print '<input type="text" class="quatrevingtpercent"'.$disablededit.' name="transvalue" id="transvalue" value="'.(!empty($transvalue) ? $transvalue : "").'">';
281	print '</td>';
282	// Limit to superadmin
283	/*if (! empty($conf->multicompany->enabled) && !$user->entity)
284    {
285    	print '<td>';
286    	print '<input type="text" class="flat" size="1" name="entity" value="'.$conf->entity.'">';
287    	print '</td>';
288    	print '<td class="center">';
289    }
290    else
291    {*/
292		print '<td class="center">';
293		print '<input type="hidden" name="entity" value="'.$conf->entity.'">';
294	//}
295	print '<input type="submit" class="button"'.$disabled.' value="'.$langs->trans("Add").'" name="add" title="'.dol_escape_htmltag($langs->trans("YouMustEnabledTranslationOverwriteBefore")).'">';
296	print "</td>\n";
297	print '</tr>';
298
299
300	// Show constants
301	$sql = "SELECT rowid, entity, lang, transkey, transvalue";
302	$sql .= " FROM ".MAIN_DB_PREFIX."overwrite_trans";
303	$sql .= " WHERE 1 = 1";
304	$sql .= " AND entity IN (".getEntity('overwrite_trans').")";
305	$sql .= $db->order($sortfield, $sortorder);
306
307	dol_syslog("translation::select from table", LOG_DEBUG);
308	$result = $db->query($sql);
309	if ($result)
310	{
311		$num = $db->num_rows($result);
312		$i = 0;
313
314		while ($i < $num)
315		{
316			$obj = $db->fetch_object($result);
317
318			print "\n";
319
320			print '<tr class="oddeven">';
321
322			print '<td>'.$obj->lang.'</td>'."\n";
323			print '<td>'.$obj->transkey.'</td>'."\n";
324
325			// Value
326			print '<td>';
327			/*print '<input type="hidden" name="const['.$i.'][rowid]" value="'.$obj->rowid.'">';
328    		print '<input type="hidden" name="const['.$i.'][lang]" value="'.$obj->lang.'">';
329    		print '<input type="hidden" name="const['.$i.'][name]" value="'.$obj->transkey.'">';
330    		print '<input type="text" id="value_'.$i.'" class="flat inputforupdate" size="30" name="const['.$i.'][value]" value="'.dol_escape_htmltag($obj->transvalue).'">';
331    		*/
332			if ($action == 'edit' && $obj->rowid == GETPOST('rowid', 'int'))
333			{
334				print '<input type="text" class="quatrevingtpercent" name="transvalue" value="'.dol_escape_htmltag($obj->transvalue).'">';
335			} else {
336				print dol_escape_htmltag($obj->transvalue);
337			}
338			print '</td>';
339
340			print '<td class="center">';
341			if ($action == 'edit' && $obj->rowid == GETPOST('rowid', 'int')) {
342				print '<input type="hidden" class="button" name="rowid" value="'.$obj->rowid.'">';
343				print '<input type="submit" class="button buttongen button-save" name="save" value="'.dol_escape_htmltag($langs->trans("Save")).'">';
344				print ' &nbsp; ';
345				print '<input type="submit" class="button buttongen button-cancel" name="cancel" value="'.dol_escape_htmltag($langs->trans("Cancel")).'">';
346			} else {
347				print '<a class="reposition editfielda paddingrightonly" href="'.$_SERVER['PHP_SELF'].'?rowid='.$obj->rowid.'&entity='.$obj->entity.'&mode='.urlencode($mode).'&action=edit'.((empty($user->entity) && $debug) ? '&debug=1' : '').'">'.img_edit().'</a>';
348				print ' &nbsp; ';
349				print '<a class="reposition" href="'.$_SERVER['PHP_SELF'].'?rowid='.$obj->rowid.'&entity='.$obj->entity.'&mode='.urlencode($mode).'&action=delete&token='.newToken().((empty($user->entity) && $debug) ? '&debug=1' : '').'">'.img_delete().'</a>';
350			}
351			print '</td>';
352
353			print "</tr>\n";
354			print "\n";
355			$i++;
356		}
357	}
358
359	print '</table>';
360	print '</div>';
361}
362
363if ($mode == 'searchkey')
364{
365	$langcode = GETPOSTISSET('langcode') ? GETPOST('langcode') : $langs->defaultlang;
366
367	$newlang = new Translate('', $conf);
368	$newlang->setDefaultLang($langcode);
369
370	$newlangfileonly = new Translate('', $conf);
371	$newlangfileonly->setDefaultLang($langcode);
372
373	$recordtoshow = array();
374
375	// Search modules dirs
376	$modulesdir = dolGetModulesDirs();
377
378	$nbtotaloffiles = 0;
379	$nbempty = 0;
380	/*var_dump($langcode);
381     var_dump($transkey);
382     var_dump($transvalue);*/
383	if (empty($langcode) || $langcode == '-1') $nbempty++;
384	if (empty($transkey)) $nbempty++;
385	if (empty($transvalue)) $nbempty++;
386	if ($action == 'search' && ($nbempty > 999)) {    // 999 to disable this
387		setEventMessages($langs->trans("WarningAtLeastKeyOrTranslationRequired"), null, 'warnings');
388	} else {
389		// Search into dir of modules (the $modulesdir is already a list that loop on $conf->file->dol_document_root)
390		$i = 0;
391		foreach ($modulesdir as $keydir => $tmpsearchdir)
392		{
393			$searchdir = $tmpsearchdir; // $searchdir can be '.../htdocs/core/modules/' or '.../htdocs/custom/mymodule/core/modules/'
394
395			// Directory of translation files
396			$dir_lang = dirname(dirname($searchdir))."/langs/".$langcode; // The 2 dirname is to go up in dir for 2 levels
397			$dir_lang_osencoded = dol_osencode($dir_lang);
398
399			$filearray = dol_dir_list($dir_lang_osencoded, 'files', 0, '', '', $sortfield, (strtolower($sortorder) == 'asc' ?SORT_ASC:SORT_DESC), 1);
400			foreach ($filearray as $file)
401			{
402				$tmpfile = preg_replace('/.lang/i', '', basename($file['name']));
403				$moduledirname = (basename(dirname(dirname($dir_lang))));
404
405				$langkey = $tmpfile;
406				if ($i > 0) $langkey .= '@'.$moduledirname;
407				//var_dump($i.' - '.$keydir.' - '.$dir_lang_osencoded.' -> '.$moduledirname . ' / ' . $tmpfile.' -> '.$langkey);
408
409				$result = $newlang->load($langkey, 0, 0, '', 0); // Load translation files + database overwrite
410				$result = $newlangfileonly->load($langkey, 0, 0, '', 1); // Load translation files only
411				if ($result < 0) print 'Failed to load language file '.$tmpfile.'<br>'."\n";
412				else $nbtotaloffiles++;
413				//print 'After loading lang '.$langkey.', newlang has '.count($newlang->tab_translate).' records<br>'."\n";
414			}
415			$i++;
416		}
417
418		// Now search into translation array
419		foreach ($newlang->tab_translate as $key => $val)
420		{
421			if ($transkey && !preg_match('/'.preg_quote($transkey, '/').'/i', $key)) continue;
422			if ($transvalue && !preg_match('/'.preg_quote($transvalue, '/').'/i', $val)) continue;
423			$recordtoshow[$key] = $val;
424		}
425	}
426
427	//print '<br>';
428	$nbtotalofrecordswithoutfilters = count($newlang->tab_translate);
429	$nbtotalofrecords = count($recordtoshow);
430	$num = $limit + 1;
431	if (($offset + $num) > $nbtotalofrecords) $num = $limit;
432
433	//print 'param='.$param.' $_SERVER["PHP_SELF"]='.$_SERVER["PHP_SELF"].' num='.$num.' page='.$page.' nbtotalofrecords='.$nbtotalofrecords." sortfield=".$sortfield." sortorder=".$sortorder;
434	$title = $langs->trans("TranslationKeySearch");
435	if ($nbtotalofrecords > 0) $title .= ' <span class="opacitymedium colorblack paddingleft">('.$nbtotalofrecords.' / '.$nbtotalofrecordswithoutfilters.' - '.$nbtotaloffiles.' '.$langs->trans("Files").')</span>';
436	print_barre_liste($title, $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, -1 * $nbtotalofrecords, '', 0, '', '', $limit, 0, 0, 1);
437
438	print '<input type="hidden" id="action" name="action" value="search">';
439	print '<input type="hidden" id="mode" name="mode" value="'.$mode.'">';
440
441	print '<div class="div-table-responsive-no-min">';
442	print '<table class="noborder centpercent">';
443	print '<tr class="liste_titre">';
444	print_liste_field_titre("Language_en_US_es_MX_etc", $_SERVER["PHP_SELF"], 'lang,transkey', '', $param, '', $sortfield, $sortorder);
445	print_liste_field_titre("Key", $_SERVER["PHP_SELF"], 'transkey', '', $param, '', $sortfield, $sortorder);
446	print_liste_field_titre("CurrentTranslationString", $_SERVER["PHP_SELF"], 'transvalue', '', $param, '', $sortfield, $sortorder);
447	//if (! empty($conf->multicompany->enabled) && !$user->entity) print_liste_field_titre("Entity", $_SERVER["PHP_SELF"], 'entity,transkey', '', $param, '', $sortfield, $sortorder);
448	print '<td align="center"></td>';
449	print "</tr>\n";
450
451	// Line to search new record
452	print "\n";
453
454	print '<tr class="oddeven"><td>';
455	//print $formadmin->select_language($langcode,'langcode',0,null,$langs->trans("All"),0,0,'',1);
456	print $formadmin->select_language($langcode, 'langcode', 0, null, 0, 0, 0, 'maxwidthonsmartphone', 1);
457	print '</td>'."\n";
458	print '<td>';
459	print '<input type="text" class="flat maxwidthonsmartphone" name="transkey" value="'.$transkey.'">';
460	print '</td><td>';
461	print '<input type="text" class="quatrevingtpercent" name="transvalue" value="'.$transvalue.'">';
462	// Limit to superadmin
463	/*if (! empty($conf->multicompany->enabled) && !$user->entity)
464    {
465        print '</td><td>';
466        print '<input type="text" class="flat" size="1" name="entitysearch" value="'.$conf->entity.'">';
467    }
468    else
469    {*/
470		print '<input type="hidden" name="entitysearch" value="'.$conf->entity.'">';
471	//}
472	print '</td>';
473	// Action column
474	print '<td class="nowrap right">';
475	$searchpicto = $form->showFilterAndCheckAddButtons($massactionbutton ? 1 : 0, 'checkforselect', 1);
476	print $searchpicto;
477	print '</td>';
478	print '</tr>';
479
480	if ($sortfield == 'transkey' && strtolower($sortorder) == 'asc') ksort($recordtoshow);
481	if ($sortfield == 'transkey' && strtolower($sortorder) == 'desc') krsort($recordtoshow);
482	if ($sortfield == 'transvalue' && strtolower($sortorder) == 'asc') asort($recordtoshow);
483	if ($sortfield == 'transvalue' && strtolower($sortorder) == 'desc') arsort($recordtoshow);
484
485	// Show result
486	$i = 0;
487	foreach ($recordtoshow as $key => $val)
488	{
489		$i++;
490		if ($i <= $offset) continue;
491		if ($i > ($offset + $limit)) break;
492		print '<tr class="oddeven"><td>'.$langcode.'</td><td>'.$key.'</td><td>';
493		print dol_escape_htmltag($val);
494		print '</td><td class="right nowraponall">';
495		if (!empty($newlangfileonly->tab_translate[$key])) {
496			if ($val != $newlangfileonly->tab_translate[$key]) {
497				// retrieve rowid
498				$sql = "SELECT rowid";
499				$sql .= " FROM ".MAIN_DB_PREFIX."overwrite_trans";
500				$sql .= " WHERE transkey = '".$db->escape($key)."'";
501				$sql .= " AND entity IN (".getEntity('overwrite_trans').")";
502				dol_syslog("translation::select from table", LOG_DEBUG);
503				$result = $db->query($sql);
504				if ($result)
505				{
506					$obj = $db->fetch_object($result);
507				}
508				print '<a class="editfielda reposition marginrightonly" href="'.$_SERVER['PHP_SELF'].'?rowid='.$obj->rowid.'&entity='.$conf->entity.'&mode=overwrite&action=edit">'.img_edit().'</a>';
509				print ' ';
510				print '<a class="marginleftonly marginrightonly" href="'.$_SERVER['PHP_SELF'].'?rowid='.$obj->rowid.'&entity='.$conf->entity.'&mode='.urlencode($mode).'&action=delete&mode='.urlencode($mode).'&token='.newToken().'">'.img_delete().'</a>';
511				print '&nbsp;&nbsp;';
512				$htmltext = $langs->trans("OriginalValueWas", '<i>'.$newlangfileonly->tab_translate[$key].'</i>');
513				print $form->textwithpicto('', $htmltext, 1, 'info');
514			} elseif (!empty($conf->global->MAIN_ENABLE_OVERWRITE_TRANSLATION)) {
515				//print $key.'-'.$val;
516				print '<a class="reposition paddingrightonly" href="'.$_SERVER['PHP_SELF'].'?mode=overwrite&langcode='.urlencode($langcode).'&transkey='.urlencode($key).'">'.img_edit_add($langs->trans("Overwrite")).'</a>';
517			}
518
519			if (!empty($conf->global->MAIN_FEATURES_LEVEL))
520			{
521				$transifexlangfile = '$'; // $ means 'All'
522				//$transifexurl = 'https://www.transifex.com/dolibarr-association/dolibarr/translate/#'.$langcode.'/'.$transifexlangfile.'?key='.$key;
523				$transifexurl = 'https://www.transifex.com/dolibarr-association/dolibarr/translate/#'.$langcode.'/'.$transifexlangfile.'?q=key%3A'.$key;
524
525				print ' &nbsp; <a href="'.$transifexurl.'" target="transifex">'.img_picto($langs->trans('FixOnTransifex'), 'globe').'</a>';
526			}
527		} else {
528			$htmltext = $langs->trans("TransKeyWithoutOriginalValue", $key);
529			print $form->textwithpicto('', $htmltext, 1, 'warning');
530		}
531		/*if (! empty($conf->multicompany->enabled) && !$user->entity)
532        {
533            print '<td>'.$val.'</td>';
534        }*/
535		print '</td></tr>'."\n";
536	}
537
538	print '</table>';
539	print '</div>';
540}
541
542print dol_get_fiche_end();
543
544print "</form>\n";
545
546if (!empty($langcode))
547{
548	dol_set_focus('#transvalue');
549}
550
551// End of page
552llxFooter();
553$db->close();
554