source: trunk/Modules/Translation/TranslationList.php@ 893

Last change on this file since 893 was 893, checked in by chronos, 2 years ago
  • Fixed: Class types casting for better type checking.
  • Fixed: XML direct export.
  • Modified: User class instance moved from Core class to ModuleUser class.
File size: 25.0 KB
Line 
1<?php
2
3class CompletionState
4{
5 const All = 0;
6 const NotTranslated = 1;
7 const Translated = 2;
8 const NotFinished = 3;
9 const Original = 4;
10 const NotFinishedNotTranslated = 5;
11 const Missing1 = 6;
12 const Missing2 = 7;
13}
14
15class PageTranslationList extends Page
16{
17 function ShowFilter($GroupId = 0)
18 {
19 $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
20 $TranslationTree = ModuleTranslation::Cast($this->System->GetModule('Translation'))->GetTranslationTree();
21
22 $Filter = array('SQL' => '');
23
24 $Output = '<form action="?" method="post">'.
25 '<table class="BaseTable"><tr>'.
26 '<th>'.T('Processing').'</th>'.
27 '<th>'.T('Group').'</th>'.
28 '<th>'.T('Version').'</th>'.
29 '<th>'.T('Language').'</th>'.
30 '<th>'.T('Translator').'</th>'.
31 '<th>'.T('Words').'</th>'.
32 '<th>'.T('Item').'</th>'.
33 '<th></th></tr><tr>';
34
35 // State
36 $Filter['State'] = GetParameter('state', 0, true, true);
37 $Output .= '<td><select name="state">';
38 $StateTypes = array(
39 CompletionState::All => T('All'),
40 CompletionState::NotTranslated => T('Not translated'),
41 CompletionState::Translated => T('Translated'),
42 CompletionState::NotFinished => T('Unfinished'),
43 CompletionState::Original => T('Original'),
44 CompletionState::NotFinishedNotTranslated => T('Unfinished - Not translated'),
45 CompletionState::Missing1 => T('Missing $ ($N,$s..)'),
46 CompletionState::Missing2 => T('Missing $ - Not fixed'),
47 );
48 foreach ($StateTypes as $index => $StateType) {
49 if ($Filter['State'] == $index) $Selected = ' selected="selected"';
50 else $Selected = '';
51 $Output .= '<option value="'.$index.'"'.$Selected.'>'.$StateType.'</option>';
52 }
53 $Output .= '</select></td>';
54
55 // Translation group
56 if ($GroupId == 0)
57 {
58 $Filter['Group'] = GetParameter('group', 0, true, true);
59 if ($Filter['Group'] != 0)
60 {
61 if (isset($TranslationTree[$Filter['Group']]) == false)
62 ErrorMessage('Překladová skupina dle zadaného Id neexistuje.');
63 $Table = $TranslationTree[$Filter['Group']]['TablePrefix'];
64 }
65 } else
66 {
67 $Filter['Group'] = $GroupId;
68 $Table = $TranslationTree[$Filter['Group']]['TablePrefix'];
69 }
70
71 $Output .= '<td><select name="group" style="width: 80px">';
72 if ($Filter['Group'] == 0) $Selected = ' selected="selected"';
73 else $Selected = '';
74 $Output .= '<option value="0"'.$Selected.'>'.T('All').'</option>';
75 $DbResult = $this->Database->query('SELECT `Id`,`Name` FROM `Group`');
76 while ($Group = $DbResult->fetch_assoc())
77 $Groups[T($Group['Name'])] = $Group;
78 ksort($Groups);
79 foreach ($Groups as $Group)
80 {
81 if ($Group['Id'] == $Filter['Group']) $Selected = ' selected="selected"';
82 else $Selected = '';
83 $Output .= '<option value="'.$Group['Id'].'"'.$Selected.'>'.T($Group['Name']).'</option>';
84 }
85 $Output .= '</select></td>';
86
87 if ($User->Licence(LICENCE_USER))
88 $Filter['Version'] = GetParameter('version', $User->PreferredVersion, true, true);
89 else
90 $Filter['Version'] = GetParameter('version', 0, true, true);
91 if ($Filter['Version'] != 0)
92 {
93 $DbResult = $this->Database->query('SELECT `Id`, `BuildNumber`,`Version` FROM `ClientVersion` WHERE (`Imported` = 1) AND (`Id` ='.$Filter['Version'].')');
94 if ($DbResult->num_rows > 0)
95 {
96 $DbRow = $DbResult->fetch_assoc();
97 $Filter['BuildNumber'] = $DbRow['BuildNumber'];
98 } else ErrorMessage('Zadaná verze klienta nenalezena');
99 }
100 $Output .= '<td><select name="version">';
101 if ($Filter['Version'] == 0) $Selected = ' selected="selected"';
102 else $Selected = '';
103 $Output .= '<option value="0"'.$Selected.'>'.T('All').'</option>';
104 $DbResult = $this->Database->query('SELECT `Id`, `BuildNumber`,`Version` FROM `ClientVersion` WHERE `Imported` = 1 ORDER BY `BuildNumber` DESC');
105 while ($Version = $DbResult->fetch_assoc())
106 {
107 if ($Version['Id'] == $Filter['Version']) $Selected = ' selected="selected"';
108 else $Selected = '';
109 $Output .= '<option value="'.$Version['Id'].'"'.$Selected.'>'.$Version['Version'].'</option>';
110 }
111 $Output .= '</select></td>';
112 if ($Filter['Version'] != 0) $VersionFilter = ' AND (`VersionStart` <= '.$Filter['BuildNumber'].') AND (`VersionEnd` >= '.$Filter['BuildNumber'].')';
113 else $VersionFilter = '';
114 //else $Filter['SQL'] .= ' AND '; DISTINCT(Entry)
115
116 // Language
117 $Filter['Language'] = GetParameter('lang', 0, true, true);
118 $Output .= '<td><select name="lang">';
119 if ($Filter['Language'] == 0) $Selected = ' selected="selected"';
120 else $Selected = '';
121 $Output .= '<option value="0"'.$Selected.'>'.T('All').'</option>';
122 $DbResult = $this->Database->query('SELECT `Id`, `Name` FROM `Language` WHERE `Enabled` = 1 ORDER BY `Name`');
123 while ($Language = $DbResult->fetch_assoc())
124 {
125 if ($Language['Id'] == $Filter['Language']) $Selected = ' selected="selected"';
126 else $Selected = '';
127 $Output .= '<option value="'.$Language['Id'].'"'.$Selected.'>'.T($Language['Name']).'</option>';
128 }
129 $Output .= '</select></td>';
130 $LanguageFilter = '';
131 $LanguageFilterSub = '';
132 if ($Filter['Language'] != 0) {
133 $LanguageFilter = ' AND (`T`.`Language` = '.$Filter['Language'].')';
134 $LanguageFilterSub = ' AND (`Sub`.`Language` = '.$Filter['Language'].')';
135 }
136
137 // User
138 $Filter['User'] = GetParameter('user', 0, true, true);
139 $Output .= '<td><select name="user" style="width: 80px">';
140 if ($Filter['User'] == 0) $Selected = ' selected="selected"';
141 else $Selected = '';
142 $Output .= '<option value="0"'.$Selected.'>'.T('All').'</option>';
143 $DbResult = $this->Database->query('SELECT `Id`, `Name` FROM `User` ORDER BY `Name`');
144 while ($User = $DbResult->fetch_assoc())
145 {
146 if ($User['Id'] == $Filter['User']) $Selected = ' selected="selected"';
147 else $Selected = '';
148 $Output .= '<option value="'.$User['Id'].'"'.$Selected.'>'.$User['Name'].'</option>';
149 }
150 $Output .= '</select></td>';
151 if ($Filter['User'] != 0) $UserFilter = ' AND (`User` = '.$Filter['User'].')';
152 else $UserFilter = '';
153
154 // Words
155 $Filter['Text'] = GetParameter('text', '', false, true);
156 $Output .= '<td><input name="text" type="text" style="width: 60px;" value="'.htmlentities($Filter['Text']).'"></td>';
157 if ($Filter['Text'] != '')
158 {
159 $Items = array('(`T`.`ID` LIKE "%'.$Filter['Text'].'%")', '(`T`.`Entry` LIKE "%'.$Filter['Text'].'%")');
160 if ($Filter['Group'] != 0)
161 foreach ($TranslationTree[$Filter['Group']]['Items'] as $GroupItem)
162 if ($GroupItem['Visible'] == 1)
163 $Items[] = '(`T`.`'.$GroupItem['Column'].'` LIKE "%'.$Filter['Text'].'%")';
164 $Filter['SQL'] .= ' AND ('.implode(' OR ', $Items).')';
165 }
166
167 // Entry
168 $Filter['Entry'] = GetParameter('entry', '', false, true);
169 $Output .= '<td><input name="entry" type="text" style="width: 60px;" value="'.htmlentities($Filter['Entry']).'"></td>';
170 if ($Filter['Entry'] != '')
171 {
172 $Filter['SQL'] .= ' AND (`Entry` = "'.$Filter['Entry'].'")';
173 }
174
175 if ($Filter['Group'] != 0)
176 {
177 $WithoutAlter = ' AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE '.
178 '(`Sub`.`Language` <> '.Core::Cast($this->System)->Config['OriginalLanguage'].')'.$LanguageFilterSub.
179 ' AND (`Sub`.`Entry` = `T`.`Entry`) AND (`Sub`.`ID` != `T`.`ID`) AND (`Sub`.`Complete` = 1) AND '.
180 '(`Sub`.`VersionStart` = `T`.`VersionStart`) AND (`Sub`.`VersionEnd` = `T`.`VersionEnd`) LIMIT 1 ) ';
181 foreach ($TranslationTree[$Filter['Group']]['Items'] as $GroupItem)
182 if ($GroupItem['Visible'] == 1) {
183 $ItemsVar[] = 'LENGTH(`T`.`'.$GroupItem['Column'].'`) - LENGTH( REPLACE( `T`.`'.$GroupItem['Column'].'`, \'$\', \'\' ) ) '.
184 ' < ('.
185 'SELECT LENGTH(`Sub`.`'.$GroupItem['Column'].'`) - LENGTH( REPLACE( `Sub`.`'.$GroupItem['Column'].'`, \'$\', \'\' ) ) FROM `'.$Table.'` AS `Sub` WHERE '.
186 ' `Sub`.`Entry` = `T`.`Entry` AND `Sub`.`Language` = '.Core::Cast($this->System)->Config['OriginalLanguage'].' AND '.
187 '`Sub`.`VersionStart` = `T`.`VersionStart` AND `Sub`.`VersionEnd` = `T`.`VersionEnd` LIMIT 1 '.
188 ')';
189 }
190 if ($Filter['State'] == CompletionState::All) {
191 $Filter['SQL'] .= $UserFilter.$VersionFilter;
192 } else
193 if ($Filter['State'] == CompletionState::NotTranslated) {
194 $Filter['SQL'] .= $VersionFilter.' AND (`T`.`Language` = '.Core::Cast($this->System)->Config['OriginalLanguage'].') '.
195 'AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE '.
196 '(`Sub`.`Language` <> '.Core::Cast($this->System)->Config['OriginalLanguage'].') '.$LanguageFilterSub.$UserFilter.
197 ' AND (`Sub`.`Entry` = `T`.`Entry`) AND (`Sub`.`Complete` = 1) AND '.
198 '(`Sub`.`VersionStart` = `T`.`VersionStart`) AND (`Sub`.`VersionEnd` = `T`.`VersionEnd`))';
199 } else
200 if ($Filter['State'] == CompletionState::Translated) {
201 $Filter['SQL'] .= $UserFilter.$LanguageFilter.$VersionFilter.' AND (`T`.`Complete` = 1)';
202 } else
203 if ($Filter['State'] == CompletionState::NotFinished) {
204 $Filter['SQL'] .= $UserFilter.$LanguageFilter.$VersionFilter.' AND (`T`.`Language` != '.Core::Cast($this->System)->Config['OriginalLanguage'].
205 ') AND (`T`.`Complete` = 0)';
206 } else
207 if ($Filter['State'] == CompletionState::Original) {
208 $Filter['SQL'] .= $VersionFilter.' AND (`T`.`Language` = '.Core::Cast($this->System)->Config['OriginalLanguage'].')';
209 } else
210 if ($Filter['State'] == CompletionState::NotFinishedNotTranslated) {
211 $Filter['SQL'] .= $UserFilter.$VersionFilter.$WithoutAlter.
212 ' AND (`T`.`Language` != '.Core::Cast($this->System)->Config['OriginalLanguage'].
213 ') AND (`T`.`Complete` = 0)';
214 } else
215 if ($Filter['State'] == CompletionState::Missing1) {
216 $Filter['SQL'] .= $UserFilter.$VersionFilter.' AND (`T`.`Complete` = 1) AND `T`.`Language` != '.Core::Cast($this->System)->Config['OriginalLanguage'];
217 $Filter['SQL'] .= ' AND ('.implode(' OR ', $ItemsVar).') ';
218 } else
219 if ($Filter['State'] == CompletionState::Missing2) {
220 $Filter['SQL'] .= $UserFilter.$VersionFilter.' AND (`T`.`Complete` = 1) AND `T`.`Language` != '.Core::Cast($this->System)->Config['OriginalLanguage'];
221 $Filter['SQL'] .= ' '. $WithoutAlter;
222 $Filter['SQL'] .= ' AND ('.implode(' OR ', $ItemsVar).') ';
223 }
224 }
225
226 /*
227 // Ownership
228 if (array_key_exists('owner', $_GET) and is_numeric($_GET['owner'])) $Filter['Owner'] = $_GET['owner'];
229 else $Filter['Owner'] = 0;
230 $Output .= ' <td><select name="owner">';
231 if ($Filter['Owner'] == 0) $Selected = ' selected="selected"';
232 else $Selected = '';
233 $Output .= '<option value="0"'.$Selected.'>Všech</option>';
234 if ($Filter['Owner'] == 1) $Selected = ' selected="selected"';
235 else $Selected = '';
236 $Output .= '<option value="1"'.$Selected.'>Překladatelův tým</option>';
237 if ($Filter['Owner'] == 2) $Selected = ' selected="selected"';
238 else $Selected = '';
239 $Output .= '<option value="2"'.$Selected.'>Překladatele</option>';
240 $Output .= '</select></td>';
241 if (($Filter['Owner'] == 2) AND ($Filter['User'] != 0)) $Filter['SQL'] .= ' AND (`User` = '.$Filter['User'].')';
242 */
243
244 $Output .= '<td><input type="submit" value="'.T('Filter').'"/></td>';
245 $Output .= '</tr></table>';
246 $Output .= '</form><br/>';
247 $Filter['Output'] = $Output;
248 return $Filter;
249 }
250
251 function ShowTranslationList($Filter)
252 {
253 $TranslationTree = $this->System->ModuleManager->Modules['Translation']->GetTranslationTree();
254
255 $Output = $Filter['Output'];
256 $Table = $TranslationTree[$Filter['Group']]['TablePrefix'];
257
258 $Query = 'SELECT `T`.`ModifyTime`, `T`.`ID`, `T`.`Entry`, `T`.`VersionStart`, `T`.`VersionEnd`, '.
259 '`T`.`'.$TranslationTree[$Filter['Group']]['Items'][0]['Column'].'`, '.
260 '`User`.`Name` AS `UserName`, `User`.`ID` AS `UserId`, '.
261 '`Language`.`Name` AS `LanguageName`, `TS`.`Version` AS `VersionStartText`, `TE`.`Version` AS `VersionEndText` '.
262 'FROM `'.$Table.'` AS `T` '.
263 'LEFT JOIN `User` ON `User`.`ID` = `T`.`User` '.
264 'LEFT JOIN `Language` ON `Language`.`ID` = `T`.`Language` '.
265 'LEFT JOIN `ClientVersion` AS `TS` ON `TS`.`BuildNumber` = `T`.`VersionStart` '.
266 'LEFT JOIN `ClientVersion` AS `TE` ON `TE`.`BuildNumber` = `T`.`VersionEnd` '.
267 'WHERE 1 '.$Filter['SQL'];
268
269 // Get total item count
270 $DbResult = $this->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS `TT`');
271 $DbRow = $DbResult->fetch_row();
272 $PageList = GetPageList($DbRow[0]);
273
274 $Output .= $PageList['Output'];
275 $TableColumns = array(
276 array('Name' => 'ID', 'Title' => T('Number')),
277 array('Name' => 'Entry', 'Title' => T('Item')),
278 array('Name' => $TranslationTree[$Filter['Group']]['Items'][0]['Column'], 'Title' => T('Name')),
279 array('Name' => 'VersionStart', 'Title' => T('From version')),
280 array('Name' => 'VersionEnd', 'Title' => T('To version')),
281 array('Name' => 'LanguageName', 'Title' => T('Language')),
282 array('Name' => 'UserName', 'Title' => T('Translator')),
283 array('Name' => 'ModifyTime', 'Title' => T('Date')),
284 );
285
286 $Order = GetOrderTableHeader($TableColumns, 'VersionStart', 1);
287 $Output .= '<table class="BaseTable">'.
288 $Order['Output'];
289
290 $DbResult = $this->Database->query($Query.' '.$Order['SQL'].' '.$PageList['SQLLimit']);
291 while ($Line = $DbResult->fetch_assoc())
292 {
293 $Output .= '<tr><td><a href="'.$this->System->Link('/form.php?group='.$Filter['Group'].'&amp;ID='.$Line['ID']).'">'.$Line['ID'].'</a></td>'.
294 '<td>'.$Line['Entry'].'</td>'.
295 '<td>'.htmlspecialchars($Line[$TranslationTree[$Filter['Group']]['Items'][0]['Column']]).'</td>'.
296 '<td><a href="'.$this->System->Link('/client-version/?action=item&amp;id='.
297 GetVersionWOWId($Line['VersionStart'])).'">'.GetVersionWOW($Line['VersionStart']).'</a></td>'.
298 '<td><a href="'.$this->System->Link('/client-version/?action=item&amp;id='.
299 GetVersionWOWId($Line['VersionEnd'])).'">'.GetVersionWOW($Line['VersionEnd']).'</a></td>'.
300 '<td>'.T($Line['LanguageName']).'</td>'.
301 '<td><a href="'.$this->System->Link('/user/?user='.$Line['UserId']).'">'.$Line['UserName'].'</a></td>'.
302 '<td>'.HumanDate($Line['ModifyTime']).'</td>'.
303 '</tr>';
304 }
305 $Output .= '</table>'.
306 $PageList['Output'];
307 return $Output;
308 }
309
310 function ShowGroupList($Filter)
311 {
312 $TranslationTree = $this->System->ModuleManager->Modules['Translation']->GetTranslationTree();
313
314 $Output = $Filter['Output'];
315
316 $Output .= '<table class="BaseTable"><tr><th>'.T('Group').'</th><th>'.T('Count').'</th></tr>';
317 $Total = 0;
318 foreach ($TranslationTree as $Group)
319 if ($Group['TablePrefix'] != '')
320 {
321 $Filter = $this->ShowFilter($Group['Id']);
322 $ID = $this->Database->query('SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` AS `T` WHERE 1 '.$Filter['SQL']);
323 $Line = $ID->fetch_row();
324 if ($Line[0] <> '0')
325 $Output .= '<tr><td><a href="?group='.$Group['Id'].'">'.$Group['Name'].'</td><td>'.$Line[0].'</a></tr>';
326 $Total += $Line[0];
327 }
328 $Output .= '<tr><td><strong>'.T('Total').'</strong></td><td><strong>'.$Total.'</strong></td></tr>'.
329 '</table>';
330 return $Output;
331 }
332
333 function ShowMenu()
334 {
335 $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
336 $TranslationTree = $this->System->ModuleManager->Modules['Translation']->GetTranslationTree();
337
338 $GroupId = GetParameter('group', 0, true);
339 if ($GroupId == 0) $Output = ShowMessage('Skupina nenalezena', MESSAGE_CRITICAL);
340 else {
341 $Table = $TranslationTree[$GroupId]['TablePrefix'];
342
343 $Output = '<h3>'.T('Basic text filtering').'</h3><br/>'.
344 '<table class="BaseTable"><tr><th>'.T('Link').'</th><th>'.T('Description').'</th></tr>'.
345 '<tr><td><a title="'.T('All texts available in group').'" href="?group='.$GroupId.'&amp;state=4">'.T('All').'</a></td>'.
346 '<td>'.T('Show all available original texts in group').'</td></tr>'.
347 '<tr><td><a title="'.T('Translated texts, you can modify them here').'" href="?group='.$GroupId.'&amp;state=2">'.T('Translated').'</a></td>'.
348 '<td>'.T('Show only translated texts').'</td></tr>'.
349 '<tr><td><a title="'.T('Untranslated texts').'" href="?group='.$GroupId.'&amp;state=1">'.T('Untranslated').'</a></td>'.
350 '<td>'.T('Not yet translated texts which need to be translated').'</td></tr>'.
351 '<tr><td><a title="'.T('Unfinished texts').'" href="?group='.$GroupId.'&amp;state=3">'.T('Unfinished').'</a></td>'.
352 '<td>'.T('Texts marked as unfinished').'</td></tr>';
353
354 if ($User->Licence(LICENCE_USER))
355 {
356 $Output .= '<tr><td><a title="'.T('Unfinished texts').'" href="?group='.$GroupId.'&amp;state=3&amp;user='.$User->Id.'">'.T('My unfinished').'</a></td>
357 <td>'.T('Unfinished texts of logged-in user').'</td></tr>
358 <tr><td><a title="'.T('Translated texts of logged-in user').'" href="?group='.$GroupId.'&amp;state=2&amp;user='.$User->Id.'">'.T('My translated').'</a></td>
359 <td>'.T('Translated texts of logged-in user').'</td></tr>';
360 }
361
362 $Output .= '<tr><td><form action="?group='.$GroupId.'&amp;entry=" method="post"><div>'.
363 '<input type="text" name="text" size="8" />'.
364 '<input type="submit" value="'.T('Search').'" />'.
365 '</div></form>'.
366 '</td><td>'.T('Search using text').'</td></tr>';
367
368 $Output .= '<tr><td><form action="?group='.$GroupId.'&amp;text=" method="post"><div>'.
369 '<input type="text" name="entry" size="8" />'.
370 '<input type="submit" value="'.T('Search').'" />'.
371 '</div></form>'.
372 '</td><td>'.T('Show by datbase text ID').'</td></tr>';
373
374 $Output .= '</table>';
375 }
376 return $Output;
377 }
378
379 function Show(): string
380 {
381 $this->Title = T('Translation groups');
382 $Action = GetParameter('action', '');
383 if ($Action == 'filter') $Output = $this->ShowMenu();
384 else
385 {
386 $Filter = $this->ShowFilter();
387 if ($Filter['Group'] > 0) $Output = $this->ShowTranslationList($Filter);
388 else $Output = $this->ShowGroupList($Filter);
389 }
390 return $Output;
391 }
392}
393
394class PageTranslationGroups extends Page
395{
396 function ShowList()
397 {
398 $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
399 $DbResult = $this->Database->query('SELECT COUNT(*) FROM `Group`');
400 $DbRow = $DbResult->fetch_row();
401 $PageList = GetPageList($DbRow[0]);
402 $Output = '<h3>'.T('List of translation groups').'</h3>'.
403 $PageList['Output'];
404
405 $Output .= '<table class="BaseTable">';
406 $TableColumns = array(
407 array('Name' => 'Name', 'Title' => T('Name')),
408 array('Name' => 'SourceType', 'Title' => T('Source type')),
409 array('Name' => '', 'Title' => T('Sources')),
410 array('Name' => 'LastImport', 'Title' => T('Date of last import')),
411 array('Name' => 'LastVersion', 'Title' => T('Version of last import')),
412 );
413 if ($User->Licence(LICENCE_ADMIN))
414 $TableColumns[] = array('Name' => '', 'Title' => T('Actions'));
415
416 $Order = GetOrderTableHeader($TableColumns, 'Name', 0);
417 $Output .= $Order['Output'];
418
419 $DbResult = $this->Database->query('SELECT * FROM `Group`'.$Order['SQL'].$PageList['SQLLimit']);
420 while ($Group = $DbResult->fetch_assoc())
421 {
422 $Output .= '<tr><td><a href="'.$this->System->Link('/TranslationList.php?group='.$Group['Id'].'&amp;action=filter').'">'.T($Group['Name']).'</a></td>'.
423 '<td>'.$Group['SourceType'].'</td><td>';
424 if ($Group['MangosTable'] != '') $Output .= $Group['MangosTable'].'.sql ';
425 if ($Group['DBCFileName'] != '') $Output .= $Group['DBCFileName'].'.dbc ';
426 if ($Group['LuaFileName'] != '') $Output .= $Group['LuaFileName'].'.lua ';
427 $Output .= '</td>';
428 if ($User->Licence(LICENCE_ADMIN))
429 $Output .= '<td><a title="Změny po posledním importu u vybrané překladové skupiny" href="'.$this->System->Link('/log/?group='.
430 $Group['Id'].'&amp;type=11').'">'.HumanDate($Group['LastImport']).'</a></td>';
431 else $Output .= '<td>'.HumanDate($Group['LastImport']).'</td>';
432 $Output .= '<td><a href="'.$this->System->Link('/client-version/?action=item&amp;id='.
433 GetVersionWOWId($Group['LastVersion'])).'">'.GetVersionWOW($Group['LastVersion']).'</a></td>';
434 if ($User->Licence(LICENCE_ADMIN))
435 $Output .= '<td><a href="?action=groupdelete&amp;id='.$Group['Id'].'">'.T('Remove').'</a></td>';
436 $Output .= '</tr>';
437 }
438 $Output .= '</table>'.
439 '<br /><a title="'.T('Changelog of changes after import').'" href="'.$this->System->Link('/log/?type=11').'">'.T('Changelog of text modification during import').'</a><br/>';
440 if ($User->Licence(LICENCE_ADMIN)) $Output .= '<a href="?action=groupadd">'.T('Add translation group').'</a>';
441 return $Output;
442 }
443
444 function ShowGroupAdd()
445 {
446 $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
447 if ($User->Licence(LICENCE_ADMIN))
448 {
449 $Output = '<h3>Vložení nové překladové skupiny</h3>'.
450 '<form action="?action=groupaddfinish" method="post">'.
451 '<table>'.
452 '<tr><td>Název:</td><td><input type="text" name="Name"/></td></tr>'.
453 '<tr><td>Název tabulky v databázi:</td><td>Text<input type="text" name="TablePrefix"/></td></tr>'.
454 '<tr><td colspan="2"><input type="submit" name="add" value="Přidat"/></td></tr>'.
455 '</table></form>';
456 } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
457 return $Output;
458 }
459
460 function ShowGroupAddFinish()
461 {
462 $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
463 if ($User->Licence(LICENCE_ADMIN))
464 {
465 $TableName = 'Text'.$_POST['TablePrefix'];
466 $DbResult = $this->System->Database->select('Group', 'Id', 'TablePrefix="'.$TableName.'"');
467 if ($DbResult->num_rows == 0)
468 {
469
470 $this->System->Database->query('CREATE TABLE IF NOT EXISTS `'.$TableName.'` (
471 `ID` int(11) NOT NULL AUTO_INCREMENT,
472 `Entry` int(11) NOT NULL,
473 `Name` varchar(255) NOT NULL,
474 `Language` int(11) NOT NULL DEFAULT "0",
475 `User` int(11) DEFAULT NULL,
476 `Complete` int(11) NOT NULL,
477 `CompleteParts` int(11) NOT NULL,
478 `Take` int(11) DEFAULT NULL,
479 `VersionStart` int(11) NOT NULL,
480 `VersionEnd` int(11) NOT NULL,
481 `ModifyTime` datetime NOT NULL,
482 PRIMARY KEY (`ID`),
483 KEY `Entry` (`Entry`),
484 KEY `User` (`User`),
485 KEY `Take` (`Take`),
486 KEY `Language` (`Language`),
487 KEY `Complete` (`Complete`),
488 KEY `VersionStart` (`VersionStart`),
489 KEY `VersionEnd` (`VersionEnd`),
490 KEY `ModifyTime` (`ModifyTime`)
491) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
492
493 $this->System->Database->query('ALTER TABLE `'.$TableName.'`
494 ADD CONSTRAINT `'.$TableName.'_ibfk_1` FOREIGN KEY (`Language`) REFERENCES `Language` (`Id`),
495 ADD CONSTRAINT `'.$TableName.'_ibfk_2` FOREIGN KEY (`User`) REFERENCES `User` (`ID`),
496 ADD CONSTRAINT `'.$TableName.'_ibfk_3` FOREIGN KEY (`Take`) REFERENCES `'.$TableName.'` (`ID`);');
497 $DbResult = $this->System->Database->insert('Group', array('Name' => $_POST['Name'],
498 'TablePrefix' => $TableName, 'PrimaryKeyItem' => 'Entry'));
499 $Group = $this->System->Database->insert_id;
500 $this->System->Database->insert('GroupItem', array('Group' => $Group,
501 'Name' => 'Jméno', 'Column' => 'Name', 'Visible' => 1));
502 $Output = ShowMessage('Překladová skupina vytvořena', MESSAGE_INFORMATION);
503 } else $Output = ShowMessage('Překladová skupina '.$TableName.' již existuje', MESSAGE_CRITICAL);
504 $Output .= $this->ShowList();
505 } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
506 return $Output;
507 }
508
509 function ShowGroupDelete()
510 {
511 $User = ModuleUser::Cast($this->System->GetModule('User'))->User;
512 if ($User->Licence(LICENCE_ADMIN))
513 {
514 $DbResult = $this->System->Database->select('Group', '*', '`Id`='.$_GET['id']);
515 if ($DbResult->num_rows == 1)
516 {
517 $Group = $DbResult->fetch_assoc();
518 $this->Database->query('DROP TABLE `'.$Group['TablePrefix'].'`');
519 $this->Database->query('DELETE FROM `GroupItem` WHERE `Group`='.$Group['Id']);
520 $this->Database->query('DELETE FROM `Group` WHERE `Id`='.$Group['Id']);
521 $Output = ShowMessage('Překladová skupina '.$Group['Name'].' smazána', MESSAGE_INFORMATION);
522 } else $Output = ShowMessage('Překladová skupina nenalezena', MESSAGE_CRITICAL);
523 } else $Output = ShowMessage(T('Access denied'), MESSAGE_CRITICAL);
524 $Output .= $this->ShowList();
525 return $Output;
526 }
527
528 function Show(): string
529 {
530 $this->Title = T('Translation groups');
531 $Action = GetParameter('action', '');
532 if ($Action == 'groupadd') $Output = $this->ShowGroupAdd();
533 else if ($Action == 'groupdelete') $Output = $this->ShowGroupDelete();
534 else if ($Action == 'groupaddfinish') $Output = $this->ShowGroupAddFinish();
535 else $Output = $this->ShowList();
536 return $Output;
537 }
538}
Note: See TracBrowser for help on using the repository browser.