source: trunk/Modules/Export/Page.php@ 569

Last change on this file since 569 was 569, checked in by chronos, 12 years ago
  • Modified: Changed some pages names to without .php names.
File size: 32.2 KB
Line 
1<?php
2
3include_once('ExportOutput.php');
4
5class PageExport extends Page
6{
7 function ExportList()
8 {
9 global $User;
10
11 $Output = '<a href="?Action=ViewList">Všechny</a>';
12 if($User->Licence(LICENCE_USER))
13 {
14 $Output .= ' <a href="?Action=ViewList&amp;Filter=Others">Ostatních</a>'.
15 ' <a href="?Action=ViewList&amp;Filter=My">Moje</a>';
16 }
17
18 if($User->Licence(LICENCE_USER))
19 $Output .= '<br/><div style="text-align: center;"><a href="?Action=Create">Vytvořit nový export</a></div><br/>';
20
21 $Filter = '';
22 if(array_key_exists('Filter', $_GET))
23 {
24 if($_GET['Filter'] == 'My') $Filter = ' WHERE `Export`.`User` = '.$User->Id;
25 if($_GET['Filter'] == 'Others') $Filter = ' WHERE `Export`.`User` != '.$User->Id;
26 }
27
28 $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` '.$Filter);
29 $DbRow = $DbResult->fetch_row();
30 $PageList = GetPageList($DbRow[0]);
31
32 $Output .= '<h3>Seznam exportů</h3>'.
33 $PageList['Output'];
34
35 $TableColumns = array(
36 array('Name' => 'TimeCreate', 'Title' => 'Čas vytvoření'),
37 array('Name' => 'UserName', 'Title' => 'Překladatel'),
38 array('Name' => 'Title', 'Title' => 'Označení'),
39 // array('Name' => 'UserCount', 'Title' => 'Vybraných překladatelů'),
40 // array('Name' => 'GroupCount', 'Title' => 'Překladových skupin'),
41 array('Name' => 'OutputType', 'Title' => 'Typ výstupu'),
42 array('Name' => 'ClientVersion', 'Title' => 'Verze klienta'),
43 array('Name' => 'UsedCount', 'Title' => 'Prohlédnutí výstupu'),
44 array('Name' => '', 'Title' => 'Akce'),
45 );
46 $Order = GetOrderTableHeader($TableColumns, 'TimeCreate', 1);
47 $Output .= '<table class="BaseTable">'.
48 $Order['Output'];
49
50 $DbResult = $this->System->Database->query('SELECT `User`.`Name` AS `UserName`, `Export`.`Id`, `Export`.`TimeCreate`, `Export`.`Title`, `Export`.`User`, `Export`.`UsedCount`, (SELECT Version FROM `ClientVersion` WHERE `ClientVersion`.`Id`=`Export`.`ClientVersion`) AS `ClientVersion`,(SELECT Name FROM `ExportOutputType` WHERE `ExportOutputType`.`Id`=`Export`.`OutputType`) AS `OutputType`, (SELECT COUNT(*) FROM `ExportGroup` WHERE `ExportGroup`.`Export`=`Export`.`Id`) AS `GroupCount`, (SELECT COUNT(*) FROM `ExportUser` WHERE `ExportUser`.`Export`=`Export`.`Id`) AS `UserCount` FROM `Export` LEFT JOIN `User` ON `User`.`ID`=`Export`.`User` '.$Filter.$Order['SQL'].$PageList['SQLLimit']);
51 while($Export = $DbResult->fetch_assoc())
52 {
53 $Action = '<a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=0">Zobrazit</a> <a href="?Action=View&amp;ExportId='.$Export['Id'].'&amp;Tab=7">Exportovat</a>';
54 if($Export['User'] == $User->Id) $Action .= ' <a href="?Action=Delete&amp;ExportId='.$Export['Id'].'" onclick="return confirmAction(\'Opravdu smazat položku?\');">Smazat</a>';
55 $Output .= '<tr><td>'.HumanDate($Export['TimeCreate']).'</td>'.
56 '<td><a href="'.$this->System->Link('/user.php?user='.$Export['User']).'">'.$Export['UserName'].'</a></td>'.
57 '<td>'.$Export['Title'].'</td>'.
58 '<td>'.$Export['OutputType'].'</td>'.
59 '<td>'.$Export['ClientVersion'].'</td>'.
60 '<td>'.$Export['UsedCount'].'</td>'.
61 '<td>'.$Action.'</td></tr>';
62 }
63 $Output .= '</table>'.
64 $PageList['Output'];
65
66 return($Output);
67 }
68
69 function ExportCreate()
70 {
71 global $User;
72
73 if($User->Licence(LICENCE_USER))
74 {
75 $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` WHERE `User`='.$User->Id);
76 $DbRow = $DbResult->fetch_row();
77 if($DbRow[0] < $this->System->Config['MaxExportPerUser'])
78 {
79 $Output = '<form action="?Action=CreateFinish" method="post">'.
80 '<fieldset><legend>Vytvoření nového exportu</legend>'.
81 '<table><tr><td>Označení:</td><td><input type="text" name="Title" /></td></tr>'.
82 '<tr><td>Popis:</td><td><textarea name="Description" cols="54" rows="10"></textarea></td></tr>'.
83 '<tr><td colspan="2"><input type="submit" value="Vytvořit" /></td></tr>'.
84 '</table></fieldset></form>';
85 } else $Output = ShowMessage('Nemůžete vytvářet další export. Max. počet na uživatele je '.$this->System->Config['MaxExportPerUser'].'.', MESSAGE_CRITICAL);
86 } else $Output = ShowMessage('Nemáte oprávnění.', MESSAGE_CRITICAL);
87 return($Output);
88 }
89
90 function ExportCreateFinish()
91 {
92 global $User;
93
94 if($User->Licence(LICENCE_USER))
95 {
96 if(array_key_exists('Title', $_POST) and array_key_exists('Description', $_POST))
97 {
98 $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `Export` WHERE `User`='.$User->Id);
99 $DbRow = $DbResult->fetch_row();
100 if($DbRow[0] < $this->System->Config['MaxExportPerUser'])
101 {
102 $this->System->Database->query('INSERT INTO `Export` (`Title`, `User`, `TimeCreate`, `WithDiacritic`, `Description`) VALUES ("'.$_POST['Title'].'", '.$User->Id.', NOW(), 1, "'.$_POST['Description'].'")');
103 $ExportId = $this->System->Database->insert_id;
104 $Output = ShowMessage('Nový export vytvořen.<br/>Přímý odkaz na tento export: <a href="?Action=View&amp;ExportId='.$ExportId.'">zde</a>');
105 WriteLog('Vytvořen nový export <a href="'.$this->System->Link('/export/?Action=View&amp;ExportId='.$ExportId).'">'.$ExportId.'</a>.', LOG_TYPE_EXPORT);
106 $_GET['Filter'] = 'my';
107 $this->ExportList();
108 } else $Output = ShowMessage('Nemůžete vytvářet další export. Max. počet na uživatele je '.$this->System->Config['MaxExportPerUser'].'.', MESSAGE_CRITICAL);
109 } else $Output = ShowMessage('Chybí údaje formuláře.', MESSAGE_CRITICAL);
110 } else $Output = ShowMessage('Nemáte oprávnění.', MESSAGE_CRITICAL);
111 return($Output);
112 }
113
114 function ExportDelete()
115 {
116 global $User;
117
118 if($User->Licence(LICENCE_USER))
119 {
120 $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE (`Id`='.($_GET['ExportId'] * 1).') AND (`User`='.$User->Id.')');
121 if($DbResult->num_rows > 0)
122 {
123 $this->System->Database->query('DELETE FROM `ExportGroup` WHERE `Export`='.$_GET['ExportId']);
124 $this->System->Database->query('DELETE FROM `ExportLanguage` WHERE `Export`='.$_GET['ExportId']);
125 $this->System->Database->query('DELETE FROM `ExportTask` WHERE `Export`='.$_GET['ExportId']);
126 $this->System->Database->query('DELETE FROM `ExportUser` WHERE `Export`='.$_GET['ExportId']);
127 $this->System->Database->query('DELETE FROM `Export` WHERE `Id`='.$_GET['ExportId']);
128 DeleteDirectory('../tmp/Export/'.$_GET['ExportId'].'/');
129 $Output = ShowMessage('Export smazán.');
130 $_GET['Filter'] = 'my';
131 WriteLog('Smazán export '.$_GET['ExportId'], LOG_TYPE_EXPORT);
132 $Output .= $this->ExportList();
133 } else $Output = ShowMessage('Export nenalezen.', MESSAGE_CRITICAL);
134 } else $Output = ShowMessage('Nemáte oprávnění.', MESSAGE_CRITICAL);
135 return($Output);
136 }
137
138 function ExportViewTranslators()
139 {
140 global $TranslationTree, $User;
141
142 $Output = '';
143 $DisabledInput = array(false => ' disabled="disabled"', true => '');
144 $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
145 $Export = $DbResult->fetch_assoc();
146 if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true;
147 else $Editable = false;
148
149 if(array_key_exists('Operation', $_POST))
150 {
151 if($_POST['Operation'] == 'Save')
152 {
153 //print_r($_POST);
154 // Update user selection page
155 foreach($_POST as $Index => $Value)
156 {
157 if(substr($Index, 0, 3) == 'seq')
158 {
159 $UserId = substr($Index, 3) * 1;
160 if(array_key_exists('sel'.$UserId, $_POST)) $Selected = true;
161 else $Selected = false;
162 $Condition = ' WHERE `Export`='.$_GET['ExportId'].' AND `User`='.$UserId;
163 $DbResult = $this->System->Database->query('SELECT * FROM `ExportUser` '.$Condition);
164 if($DbResult->num_rows > 0)
165 {
166 if(!$Selected) $this->System->Database->query('DELETE FROM `ExportUser` '.$Condition);
167 else $this->System->Database->query('UPDATE `ExportUser` SET `Sequence`='.$Value.$Condition);
168 } else
169 {
170 if($Selected) $this->System->Database->query('INSERT INTO `ExportUser` (`Export`, `User`, `Sequence`) VALUES ('.$_GET['ExportId'].', '.$UserId.', '.$Value.')');
171 }
172 }
173 }
174
175 // Recalculate sequence number
176 $this->System->Database->query('SET @I = 0');
177 $this->System->Database->query('UPDATE `ExportUser` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$_GET['ExportId'].' ORDER BY `Sequence`;');
178 $Output .= ShowMessage('Výběr uložen.');
179 }
180 }
181
182 $TableColumns = array(
183 array('Name' => 'Name', 'Title' => 'Jméno'),
184 array('Name' => 'TranslatedCount', 'Title' => 'Překladů'),
185 array('Name' => 'XP', 'Title' => 'Úroveň'),
186 array('Name' => 'XP', 'Title' => 'Zkušenost'),
187 array('Name' => '', 'Title' => 'Výběr'),
188 array('Name' => 'Sequence2', 'Title' => 'Pořadí'),
189 );
190 $Order = GetOrderTableHeader($TableColumns, 'TranslatedCount', 1);
191 if($Order['Column'] != 'Sequence2') $InitialOrder = ', '.substr($Order['SQL'], 10);
192 else $InitialOrder = '';
193
194 $Query = 'SELECT (@I := @I + 1) AS `Sequence2`, `TT`.* FROM (SELECT `ExportUser`.`Sequence`, `T`.`ID`, `T`.`TranslatedCount`, `T`.`Name`, `T`.`XP` FROM (SELECT `User`.`ID`, `User`.`Name`, `User`.`XP`, `TranslatedCount` FROM `User`) AS T';
195 $Query .=' LEFT JOIN `ExportUser` ON `ExportUser`.`Export` = '.$_GET['ExportId'].' AND `ExportUser`.`User`=`T`.`ID`';
196 $Query .=' WHERE `T`.`TranslatedCount` > 0 ORDER BY COALESCE(`ExportUser`.`Sequence`, 100000000)'.$InitialOrder.') AS `TT`';
197
198 $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS `X`');
199 $DbRow = $DbResult->fetch_row();
200 $PageList = GetPageList($DbRow[0]);
201
202 $Output .= '<form name="Translators" action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
203 '<h3>Překladatelé</h3>';
204 if($Editable)
205 {
206 $Output .= '<input type="submit" value="Uložit" '.$DisabledInput[$Editable].'/>'.
207 '<input type="hidden" name="Operation" value="Save"/>'.
208 ' <span onclick="CheckAllCheckbox();">'.CheckBox('CheckAll', False, 'CheckAll').' Zatrhnout vše</span> '.
209 '<br />'.
210 'Zvolte ze seznamu uživatele, od kterých chcete načítat překlady a upravte jejich pořadí.<br />'.
211 'Pořadí řádků je dáno číselnou hodnotou, kterou lze změnit na požadované pořadí. Řádky se stejným pořadovým číslem budou přečíslovány vzestupně.';
212 }
213
214 $Output .= $PageList['Output'].
215 '<table class="BaseTable">'.
216 $Order['Output'];
217
218 $Query = 'SELECT * FROM ('.$Query.') AS `TX` '.$Order['SQL'].$PageList['SQLLimit'];
219 $this->System->Database->query('SET @I = 0');
220 $DbResult = $this->System->Database->query($Query);
221 while($UserLine = $DbResult->fetch_assoc())
222 {
223 $XP = GetLevelMinMax($UserLine['XP']);
224 $Checked = $UserLine['Sequence'] != '';
225 $Selection = CheckBox('sel'.$UserLine['ID'], $Checked, '', 'CheckBox', !$Editable);
226 $Sequence = '<input type="text" name="seq'.$UserLine['ID'].'" style="text-align: center; width: 40px;" value="'.$UserLine['Sequence2'].'"'.$DisabledInput[$Editable].'/>';
227 $Output .= '<tr>'.
228 '<td><a href="'.$this->System->Link('/TranslationList.php?user='.$UserLine['ID'].'&amp;state=2&amp;group=0').'" title="Zobrazit všechny jeho přeložené texty">'.$UserLine['Name'].'</a></td>'.
229 '<td>'.$UserLine['TranslatedCount'].'</td>'.
230 '<td>'.$XP['Level'].'</td>'.
231 '<td>'.ProgressBar(150, round($XP['XP'] / $XP['MaxXP'] * 100, 2), $XP['XP'].' / '.$XP['MaxXP']).'</td>'.
232 '<td>'.$Selection.'</td><td>'.$Sequence.'</td></tr>';
233 }
234 $Output .= '</table>'.
235 '</form>'.
236 $PageList['Output'];
237 return($Output);
238 }
239
240 function ExportViewGeneral()
241 {
242 global $User;
243
244 $DisabledInput = array(false => ' disabled="disabled"', true => '');
245 $DisabledTextArea = array(false => ' readonly="yes"', true => '');
246 $Output = '<h3>Obecná nastavení</h3>';
247 $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
248 $Export = $DbRows->fetch_assoc();
249 if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true;
250 else $Editable = false;
251
252 if(array_key_exists('Operation', $_POST))
253 if($_POST['Operation'] == 'Save') if($Editable and array_key_exists('Title', $_POST) and array_key_exists('Description', $_POST))
254 {
255 if(array_key_exists('WithDiacritic', $_POST)) $WithDiacritic = 1;
256 else $WithDiacritic = 0;
257 $this->System->Database->query('UPDATE `Export` SET `Title`="'.$_POST['Title'].'", `Description`="'.$_POST['Description'].'", `WithDiacritic`='.$WithDiacritic.' WHERE Id='.$Export['Id']);
258 $Export['Title'] = $_POST['Title'];
259 $Export['Description'] = $_POST['Description'];
260 $Export['WithDiacritic'] = $WithDiacritic;
261 $Output .= ShowMessage('Nastavení uloženo.');
262 }
263
264 if($Export['WithDiacritic'] == 1) $WithDiacritic = ' checked="checked"';
265 else $WithDiacritic = '';
266 $Output .= '<form action="?Action=View&amp;Tab=0&amp;ExportId='.$Export['Id'].'" method="post">'.
267 '<table>';
268 if($Editable)
269 {
270 $Output .= '<input type="hidden" name="Operation" value="Save"/>'.
271 '<tr><td colspan="2"><input type="submit" value="Uložit" '.$DisabledInput[$Editable].'/></td></tr>';
272 }
273 $Output .= '<tr><td>Označení:</td><td><input type="text" style="width: 400px" name="Title" value="'.$Export['Title'].'"'.$DisabledInput[$Editable].'/></td></tr>'.
274 '<tr><td>Popis:</td><td><textarea name="Description" cols="54" rows="10"'.$DisabledTextArea[$Editable].'>'.$Export['Description'].'</textarea></td></tr>'.
275 '<tr><td>Včetně háčků a čárek</td><td><input type="checkbox" name="WithDiacritic" '.$WithDiacritic.''.$DisabledInput[$Editable].'/></td></tr>'.
276 '</table></form>';
277 return($Output);
278 }
279
280 function ExportViewLanguages()
281 {
282 global $TranslationTree, $User;
283
284 $Output = '';
285 $DisabledInput = array(false => ' disabled="disabled"', true => '');
286 $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
287 $Export = $DbRows->fetch_assoc();
288 if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true;
289 else $Editable = false;
290
291 if(array_key_exists('Operation', $_POST))
292 {
293 if($_POST['Operation'] == 'Save')
294 {
295 //print_r($_POST);
296 // Update user selection page
297 foreach($_POST as $Index => $Value)
298 {
299 if(substr($Index, 0, 3) == 'seq')
300 {
301 $LanguageId = substr($Index, 3) * 1;
302 if(array_key_exists('sel'.$LanguageId, $_POST)) $Selected = true;
303 else $Selected = false;
304 $Condition = ' WHERE Export='.$_GET['ExportId'].' AND `Language`='.$LanguageId;
305 $DbResult = $this->System->Database->query('SELECT * FROM `ExportLanguage` '.$Condition);
306 if($DbResult->num_rows > 0)
307 {
308 if(!$Selected) $this->System->Database->query('DELETE FROM `ExportLanguage` '.$Condition);
309 else $this->System->Database->query('UPDATE `ExportLanguage` SET `Sequence`='.$Value.$Condition);
310 } else
311 {
312 if($Selected) $this->System->Database->query('INSERT INTO `ExportLanguage` (`Export`, `Language`, `Sequence`) VALUES ('.$_GET['ExportId'].', '.$LanguageId.', '.$Value.')');
313 }
314 }
315 }
316
317 // Recalculate sequence number
318 $this->System->Database->query('SET @I = 0');
319 $this->System->Database->query('UPDATE `ExportLanguage` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$_GET['ExportId'].' ORDER BY `Sequence`;');
320 $Output .= ShowMessage('Výběr uložen.');
321 }
322 }
323
324 $Query = 'SELECT (@I := @I + 1) AS `Sequence2`, `Sequence`, `Language`.`Id`, `Name` FROM `Language`';
325 $Query .=' LEFT JOIN `ExportLanguage` ON `ExportLanguage`.`Export` = '.$_GET['ExportId'].' AND `ExportLanguage`.`Language`=`Language`.`Id`';
326 $Query .=' WHERE `Language`.`Enabled` = 1 ORDER BY COALESCE(`Sequence`, 100)';
327
328 $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS X');
329 $DbRow = $DbResult->fetch_row();
330 $PageList = GetPageList($DbRow[0]);
331
332 $TableColumns = array(
333 array('Name' => 'Name', 'Title' => 'Název'),
334 array('Name' => '', 'Title' => 'Výběr'),
335 array('Name' => 'Sequence2', 'Title' => 'Pořadí'),
336 );
337 $Order = GetOrderTableHeader($TableColumns, 'Sequence2');
338 $Output .= '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
339 '<h3>Jazyky</h3>';
340 if($Editable)
341 {
342 $Output .= '<input type="submit" value="Uložit" '.$DisabledInput[$Editable].'/>'.
343 '<input type="hidden" name="Operation" value="Save"/>'.
344 '<br />'.
345 'Zvolte ze seznamu dostupných jazyků, ze kterých chcete sestavit překlady a upravte jejich pořadí.<br />'.
346 'Pořadí řádků je dáno číselnou hodnotou, kterou lze změnit na požadované pořadí. Řádky se stejným pořadovým číslem budou přečíslovány vzestupně.';
347 }
348
349 $Output .= $PageList['Output'].
350 '<table class="BaseTable">'.
351 $Order['Output'];
352
353 $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
354 $this->System->Database->query('SET @I = 0');
355 $DbResult = $this->System->Database->query($Query);
356 while($Langugage = $DbResult->fetch_assoc())
357 {
358 $Checked = $Langugage['Sequence'] != '';
359 $Selection = CheckBox('sel'.$Langugage['Id'], $Checked, '', 'CheckBox', !$Editable);
360 $Sequence = '<input type="text" name="seq'.$Langugage['Id'].'" style="text-align: center; width: 40px;" value="'.$Langugage['Sequence2'].'"'.$DisabledInput[$Editable].'/>';
361 $Output .= '<tr>
362 <td>'.$Langugage['Name'].'</a></td>
363 <td>'.$Selection.'</td><td>'.$Sequence.'</td></tr>';
364 }
365 $Output .= '</table>'.
366 '</form>'.
367 $PageList['Output'];
368 return($Output);
369 }
370
371 function ExportViewGroups()
372 {
373 global $TranslationTree, $User;
374
375 $Output = '';
376 $DisabledInput = array(false => ' disabled="disabled"', true => '');
377 $DbRows = $this->System->Database->query('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
378 $Export = $DbRows->fetch_assoc();
379 if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true;
380 else $Editable = false;
381
382 if(array_key_exists('Operation', $_POST))
383 {
384 if($_POST['Operation'] == 'Save')
385 {
386 //print_r($_POST);
387 // Update user selection page
388 foreach($_POST as $Index => $Value)
389 {
390 if(substr($Index, 0, 3) == 'seq')
391 {
392 $GroupId = substr($Index, 3) * 1;
393 if(array_key_exists('sel'.$GroupId, $_POST)) $Selected = true;
394 else $Selected = false;
395 $Condition = ' WHERE `Export`='.$_GET['ExportId'].' AND `Group`='.$GroupId;
396 $DbResult = $this->System->Database->query('SELECT * FROM `ExportGroup` '.$Condition);
397 if($DbResult->num_rows > 0)
398 {
399 if(!$Selected) $this->System->Database->query('DELETE FROM `ExportGroup` '.$Condition);
400 } else
401 {
402 if($Selected) $this->System->Database->query('INSERT INTO `ExportGroup` (`Export`, `Group`) VALUES ('.$_GET['ExportId'].', '.$GroupId.')');
403 }
404 }
405 }
406 $Output .= ShowMessage('Výběr uložen.');
407 }
408 }
409
410 $Query = 'SELECT `Group`.*, `ExportGroup`.`Id` AS `ExportGroupId` FROM `Group` LEFT JOIN `ExportGroup` ON `ExportGroup`.`Export`='.$_GET['ExportId'].' AND `Group`=`Group`.`Id`';
411
412 $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS X');
413 $DbRow = $DbResult->fetch_row();
414 $PageList = GetPageList($DbRow[0]);
415
416 $TableColumns = array(
417 array('Name' => 'Name', 'Title' => 'Jméno'),
418 array('Name' => 'MangosTable', 'Title' => 'Tabulka MaNGOSu'),
419 array('Name' => 'DBCFileName', 'Title' => 'DBC soubor'),
420 array('Name' => 'LuaFileName', 'Title' => 'Lua soubor'),
421 array('Name' => '', 'Title' => 'Výběr'),
422 );
423 $Order = GetOrderTableHeader($TableColumns, 'Name');
424 $Output .= '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
425 '<h3>Překladové skupiny</h3>';
426 if($Editable)
427 {
428 $Output .= '<input type="submit" value="Uložit" '.$DisabledInput[$Editable].'/>'.
429 '<input type="hidden" name="Operation" value="Save"/>'.
430 ' <span onclick="CheckAllCheckbox();">'.CheckBox('CheckAll', False, 'CheckAll').' Zatrhnout vše</span> '.
431 '<br />'.
432 'Zvolte ze překladových skupin, ze kterých chcete načítat překlady.<br />';
433 }
434
435 $Output .= $PageList['Output'].
436 '<table class="BaseTable">'.
437 $Order['Output'];
438
439 $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
440 $DbResult = $this->System->Database->query($Query);
441 while($Group = $DbResult->fetch_assoc())
442 {
443 $Checked = $Group['ExportGroupId'] != '';
444 $Selection = CheckBox('sel'.$Group['Id'], $Checked, '', 'CheckBox', !$Editable);
445 $Output .= '<tr>'.
446 '<td>'.$Group['Name'].'</td>'.
447 '<td>'.$Group['MangosTable'].'</td>'.
448 '<td>'.$Group['DBCFileName'].'</td>'.
449 '<td>'.$Group['LuaFileName'].'</td>'.
450 '<td>'.$Selection.'<input type="hidden" name="seq'.$Group['Id'].'"/></td></tr>';
451 }
452 $Output .= '</table>'.
453 '</form>'.
454 $PageList['Output'];
455 return($Output);
456 }
457
458 function ExportViewOutputFormat()
459 {
460 global $User;
461
462 $Output = '';
463 $DisabledInput = array(false => ' disabled="disabled"', true => '');
464 if(array_key_exists('ExportId', $_GET))
465 {
466 $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
467 if($DbRows->num_rows > 0)
468 {
469 $Export = $DbRows->fetch_assoc();
470 if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true;
471 else $Editable = false;
472
473 if(array_key_exists('Operation', $_POST))
474 if($_POST['Operation'] == 'Save')
475 {
476 $this->System->Database->query('UPDATE Export SET OutputType='.$_POST['OutputType'].' WHERE Id='.$_GET['ExportId']);
477 $Output .= ShowMessage('Výběr uložen.');
478 }
479
480 $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
481 $Export = $DbResult->fetch_assoc();
482
483 $Output .= '<h3>Formát generovaného výstupu</h3>'.
484 '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">';
485 if($Editable)
486 {
487 $Output .= '<input type="submit" value="Uložit" '.$DisabledInput[$Editable].'/>'.
488 '<input type="hidden" name="Operation" value="Save"/>'.
489 '<br />';
490 }
491 $DbResult = $this->System->Database->query('SELECT * FROM `ExportOutputType` ORDER BY `Name`');
492 while($ExportFormat = $DbResult->fetch_assoc())
493 {
494 $Output .= RadioButton('OutputType', $ExportFormat['Id'], $Export['OutputType'] == $ExportFormat['Id'], '', !$Editable).' '.$ExportFormat['Name'].'<br/>';
495 }
496 $Output .= '</form>';
497 } else $Output .= ShowMessage('Položka nenalezena.', MESSAGE_CRITICAL);
498 } else $Output .= ShowMessage('Nebylo zadáno Id.', MESSAGE_CRITICAL);
499 return($Output);
500 }
501
502 function ExportViewVersion()
503 {
504 global $User;
505
506 $Output = '';
507 $DisabledInput = array(false => ' disabled="disabled"', true => '');
508 $DbRows = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
509 $Export = $DbRows->fetch_assoc();
510 if($User->Licence(LICENCE_USER) and ($User->Id == $Export['User'])) $Editable = true;
511 else $Editable = false;
512
513 if(array_key_exists('Operation', $_POST))
514 if(($_POST['Operation'] == 'Save') and (array_key_exists('ClientVersion', $_POST)))
515 {
516 $this->System->Database->query('UPDATE `Export` SET `ClientVersion`='.$_POST['ClientVersion'].' WHERE `Id`='.$_GET['ExportId']);
517 $Output .= ShowMessage('Výběr uložen.');
518 }
519
520 $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
521 $Export = $DbResult->fetch_assoc();
522
523 if($Export['OutputType'] == '') $Output .= ShowMessage('Nevybrán typ exportu', MESSAGE_CRITICAL);
524 else {
525 $Query = 'SELECT `ClientVersion`.* FROM `ExportVersion` LEFT JOIN `ClientVersion` ON `ClientVersion`.`Id`=`ExportVersion`.`ClientVersion` WHERE `ExportType`='.$Export['OutputType'];
526
527 $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$Query.') AS `X`');
528 $DbRow = $DbResult->fetch_row();
529 $PageList = GetPageList($DbRow[0]);
530
531 $TableColumns = array(
532 array('Name' => 'Version', 'Title' => 'Verze'),
533 array('Name' => 'BuildNumber', 'Title' => 'Sestavení'),
534 array('Name' => 'ReleaseDate', 'Title' => 'Datum uvolnění'),
535 array('Name' => 'Title', 'Title' => 'Titutek'),
536 array('Name' => '', 'Title' => 'Výběr'),
537 );
538 $Order = GetOrderTableHeader($TableColumns, 'BuildNumber', 1);
539 $Output .= '<form action="?Action=View&amp;ExportId='.$_GET['ExportId'].'" method="post">'.
540 '<h3>Verze klienta</h3>';
541
542 if($Editable)
543 {
544 $Output .= '<input type="submit" value="Uložit" '.$DisabledInput[$Editable].'/>'.
545 '<input type="hidden" name="Operation" value="Save"/>'.
546 '<br />'.
547 'Vyberte pro jakou verzi herního klienta se budou texty exportovat.<br />';
548 }
549 $Output .= $PageList['Output'].
550 '<table class="BaseTable">'.
551 $Order['Output'];
552
553 $Query = 'SELECT * FROM ('.$Query.') AS `TX` '.$Order['SQL'].$PageList['SQLLimit'];
554 $DbResult = $this->System->Database->query($Query);
555 while($Version = $DbResult->fetch_assoc())
556 {
557 $Output .= '<tr><td><a href="http://www.wowwiki.com/Patch_'.$Version['Version'].'">'.
558 $Version['Version'].'</a></td><td>'.$Version['BuildNumber'].'</td><td>'.
559 HumanDate($Version['ReleaseDate']).'</td><td>'.$Version['Title'].'</td><td>'.
560 RadioButton('ClientVersion', $Version['Id'], $Export['ClientVersion'] == $Version['Id'], '', !$Editable
561 ).'</td></tr>';
562
563 }
564 $Output .= '</table>'.
565 '</form>'.
566 $PageList['Output'];
567 }
568 return($Output);
569 }
570
571 function ExportViewOutput()
572 {
573 $Output = '';
574 $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
575 $Export = $DbResult->fetch_assoc();
576 if($Export['OutputType'] == '') $Output .= ShowMessage('Nevybrán typ exportu', MESSAGE_CRITICAL);
577 else if($Export['ClientVersion'] == '') $Output .= ShowMessage('Export nemá vybránu verzi klienta', MESSAGE_CRITICAL);
578 else {
579 $DbResult = $this->System->Database->query('SELECT * FROM `ExportOutputType` WHERE `Id`='.$Export['OutputType']);
580 if($DbResult->num_rows > 0)
581 {
582 $DbResult = $this->System->Database->query('SELECT * FROM `ExportVersion` WHERE (`ExportType`='.$Export['OutputType'].') AND (`ClientVersion`='.$Export['ClientVersion'].')');
583 if($DbResult->num_rows > 0)
584 {
585 $this->System->Database->query('UPDATE `Export` SET `UsedCount` = `UsedCount` + 1 WHERE `Id`='.$Export['Id']);
586 $Output = ExportOutput($Export['Id'], $Export['OutputType']);
587 } else $Output = ShowMessage('Nebyla vybrána požadovaná verze klienta.', MESSAGE_CRITICAL);
588 } else $Output = ShowMessage('Nebyl vybrán formát výstupu.', MESSAGE_CRITICAL);
589 }
590 return($Output);
591 }
592
593 function ExportViewStat()
594 {
595 $Export = new Export($this->System);
596 $Export->Id = $_GET['ExportId'];
597 $Export->Init();
598 $Export->LoadFilters();
599
600 if(($Export->Export['ClientVersion'] == '') or ($Export->ClientVersion['BuildNumber'] == ''))
601 $Output = ShowMessage('Nebyla vybrána verze klienta', MESSAGE_CRITICAL);
602 else {
603 $GroupListQuery = 'SELECT `Group`.* FROM `Group` '.
604 ' JOIN `ExportGroup` ON (`ExportGroup`.`Export`='.$Export->Id.') AND (`ExportGroup`.`Group`=`Group`.`Id`)';
605 $Query = '';
606 $UnionItems = array();
607 $DbResult = $this->System->Database->query($GroupListQuery);
608 while($DbRow = $DbResult->fetch_assoc())
609 {
610 $UnionItems[] = 'SELECT (SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
611 ' SELECT `T`.* FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
612 ' JOIN `ExportUser` ON (`ExportUser`.`User`=`T`.`User`) AND (`ExportUser`.`Export`='.$Export->Id.') '.
613 ' JOIN `ExportLanguage` ON (`ExportLanguage`.`Export`='.$Export->Id.')'.
614 ' WHERE (`Complete` = 1) AND (`VersionStart` <= '.$Export->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$Export->ClientVersion['BuildNumber'].')'.
615 ') AS `C1`) AS `Translated`, '.
616 '(SELECT COUNT(DISTINCT(`Entry`)) FROM ('.
617 ' SELECT `T`.* FROM `'.$DbRow['TablePrefix'].'` AS `T`'.
618 ' WHERE (`Language` = '.$this->System->Config['OriginalLanguage'].') AND (`VersionStart` <= '.$Export->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$Export->ClientVersion['BuildNumber'].')'.
619 ') AS `C2`) AS `Total`, "'.$DbRow['Name'].'" AS `Name`';
620 }
621 $Query = substr($Query, 0, - 6);
622
623 $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM ('.$GroupListQuery.') AS `T`');
624 $DbRow = $DbResult->fetch_row();
625 $PageList = GetPageList($DbRow[0]);
626 $Output = '<h3>Statistika dokončení vybraných skupin</h3>'.
627 $PageList['Output'];
628
629 $Output .= '<table class="BaseTable">';
630 $TableColumns = array(
631 array('Name' => 'Name', 'Title' => 'Jméno'),
632 array('Name' => 'Translated', 'Title' => 'Přeložených'),
633 array('Name' => 'Total', 'Title' => 'Anglických'),
634 array('Name' => 'Percent', 'Title' => 'Procenta'),
635 );
636
637 $Order = GetOrderTableHeader($TableColumns, 'Name', 0);
638 $Output .= $Order['Output'];
639
640 $Translated = 0;
641 $Total = 0;
642 if(count($UnionItems) > 0)
643 {
644 $ID = $this->System->Database->query('SELECT *, ROUND(`Translated` / `Total` * 100, 2) AS `Percent` FROM ('.implode(' UNION ALL ', $UnionItems).') AS `C3` '.$Order['SQL'].$PageList['SQLLimit']);
645 while($Group = $ID->fetch_assoc())
646 {
647 $Output .= '<tr><td>'.$Group['Name'].'</td><td>'.$Group['Translated'].'</td><td>'.$Group['Total'].'</td><td>'.ProgressBar(150, $Group['Percent']).'</td></tr>';
648 $Translated += $Group['Translated'];
649 $Total += $Group['Total'];
650 }
651 }
652 if($Total > 0) $Percent = $Translated / $Total * 100;
653 else $Percent = 100;
654
655 $Output .= '<tr><td><strong>Celkem</strong></td><td><strong>'.$Translated.'</strong></td><td><strong>'.$Total.'</strong></td><td><strong>'.ProgressBar(150, round($Percent, 2)).'</strong></td></tr>';
656 $Output .= '</table>';
657 }
658 return($Output);
659 }
660
661 function ExportView()
662 {
663 $Output = '';
664 if(array_key_exists('ExportId', $_GET) and is_numeric($_GET['ExportId']))
665 {
666 $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
667 if($DbResult->num_rows > 0)
668 {
669 $Export = $DbResult->fetch_assoc();
670
671 $DbResult = $this->System->Database->query('SELECT * FROM `User` WHERE `ID`='.$Export['User']);
672 $UserLine = $DbResult->fetch_assoc();
673 $Output .= 'Export <strong><a href="?Action=View&amp;Tab=6&amp;ExportId='.$Export['Id'].'">'.$_GET['ExportId'].'</a></strong> překladatele <strong>'.$UserLine['Name'].'</strong> s označením <strong>'.$Export['Title'].'</strong>';
674 $Output .= ShowTabs(array('Obecné', 'Překladatelé', 'Překlady', 'Jazyky', 'Formát', 'Verze', 'Statistika', 'Výstup'));
675 $Output .= '<div id="content">';
676 if($_SESSION['Tab'] == 0) $Output .= $this->ExportViewGeneral();
677 else if($_SESSION['Tab'] == 1) $Output .= $this->ExportViewTranslators();
678 else if($_SESSION['Tab'] == 2) $Output .= $this->ExportViewGroups();
679 else if($_SESSION['Tab'] == 3) $Output .= $this->ExportViewLanguages();
680 else if($_SESSION['Tab'] == 4) $Output .= $this->ExportViewOutputFormat();
681 else if($_SESSION['Tab'] == 5) $Output .= $this->ExportViewVersion();
682 else if($_SESSION['Tab'] == 6) $Output .= $this->ExportViewStat();
683 else if($_SESSION['Tab'] == 7) $Output .= $this->ExportViewOutput();
684 else $Output .= $this->ExportViewGeneral();
685
686 $Output .= '</div>';
687 } else $Output .= ShowMessage('Export nenalezen.', MESSAGE_CRITICAL);
688 } else $Output .= ShowMessage('Nebylo zadáno Id.', MESSAGE_CRITICAL);
689 return($Output);
690 }
691
692 function Show()
693 {
694 if(array_key_exists('Action', $_GET))
695 {
696 if($_GET['Action'] == 'Create') $Output = $this->ExportCreate();
697 else if($_GET['Action'] == 'CreateFinish') $Output = $this->ExportCreateFinish();
698 else if($_GET['Action'] == 'View') $Output = $this->ExportView();
699 else if($_GET['Action'] == 'Delete') $Output = $this->ExportDelete();
700 else $Output = $this->ExportList();
701 } else $Output = $this->ExportList();
702 return($Output);
703 }
704}
Note: See TracBrowser for help on using the repository browser.