Changeset 602 for trunk

Timestamp:

Nov 25, 2013, 11:01:32 PM (11 years ago)

Author:

chronos

Message:

• Added: Functionality to add and delete translation group from "Data source" page.

Location:

trunk

Files:

• Modules/Dictionary/Dictionary.php (modified) (1 diff)
• Modules/Translation/TranslationList.php (modified) (5 diffs)
• admin/install.php (modified) (1 diff)
• includes/Version.php (modified) (1 diff)
• includes/system.php (modified) (1 diff)

trunk/Modules/Dictionary/Dictionary.php

@@ -286 +286 @@
     if(!is_numeric($_SESSION['language'])) $Output .= '<td>'.$Line['LangName'].'</td>';
     $Output .= '<td>'.$Line['Description'].'</td>'.
-    '<td><a href="user.php?user='.$Line['UserId'].'">'.$Line['UserName'].'</a></td>';
+    '<td><a href="'.$this->System->Link('/user.php?user='.$Line['UserId']).'">'.$Line['UserName'].'</a></td>';
     if($this->System->User->Licence(LICENCE_USER))
     {

trunk/Modules/Translation/TranslationList.php

@@ -278 +278 @@
                                 array('Name' => '', 'Title' => 'Zdroje'),
                                 array('Name' => 'LastImport', 'Title' => 'Datum posledního importu'),
-                                array('Name' => 'LastVersion', 'Title' => 'Verze posledního importu'),
+                                array('Name' => 'LastVersion', 'Title' => 'Verze posledního importu'),                          
                 );
+                if($this->System->User->Licence(LICENCE_ADMIN))
+                  $TableColumns[] = array('Name' => '', 'Title' => 'Akce'); 
         
                 $Order = GetOrderTableHeader($TableColumns, 'Name', 0);
@@ -292 +294 @@
                         if($Group['LuaFileName'] != '') $Output .= $Group['LuaFileName'].'.lua ';
                         $Output .= '</td><td><a title="Změny po posledním importu u vybrané překladové skupiny" href="log.php?group='.
-                                        $Group['Id'].'&amp;type=11">'.HumanDate($Group['LastImport']).'</a></td><td>'.GetVersionWOW($Group['LastVersion']).'</td></tr>';
+                                $Group['Id'].'&amp;type=11">'.HumanDate($Group['LastImport']).'</a></td><td>'.GetVersionWOW($Group['LastVersion']).'</td>';
+                  if($this->System->User->Licence(LICENCE_ADMIN))
+                    $Output .= '<td><a href="?action=groupdelete&amp;id='.$Group['Id'].'">Smazat</a></td>';
+                  $Output .= '</tr>'; 
+        
                 }
                 $Output .= '</table>'.
@@ -353 +359 @@
                                         '<table>'.
                                         '<tr><td>Název:</td><td><input type="text" name="Name"/></td></tr>'.
-                                        '<tr><td>Název tabulky v databázi:</td><td><input type="text" name="TablePrefix"/></td></tr>'.
-                                        '<tr><td>Typ zdroje:</td><td><input type="text" name="SourceType"/></td></tr>'.
-                                        '<tr><td>Mangos databáze:</td><td><input type="text" name="MangosDatabase"/></td></tr>'.
-                                        '<tr><td>Mangos tabulka:</td><td><input type="text" name="MangosTable"/></td></tr>'.
+                                        '<tr><td>Název tabulky v databázi:</td><td>Text<input type="text" name="TablePrefix"/></td></tr>'.
                                         '<tr><td colspan="2"><input type="submit" name="add" value="Přidat"/></td></tr>'.
                                         '</table></form>';
@@ -367 +370 @@
                 if($this->System->User->Licence(LICENCE_ADMIN))
                 {
-                        // TODO: Add group items manipulation oprations
-                }
-        }
-        
+                        $TableName = 'Text'.$_POST['TablePrefix'];
+                        $DbResult = $this->System->Database->select('Group', 'Id', 'TablePrefix="'.$TableName.'"');
+                        if($DbResult->num_rows == 0)
+                  {
+                        
+                        $this->System->Database->query('CREATE TABLE IF NOT EXISTS `'.$TableName.'` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `Entry` int(11) NOT NULL,
+  `Name` varchar(255) NOT NULL,
+  `Language` int(11) NOT NULL DEFAULT "0",
+  `User` int(11) DEFAULT NULL,
+  `Complete` int(11) NOT NULL,
+  `CompleteParts` int(11) NOT NULL,
+  `Take` int(11) DEFAULT NULL,
+  `VersionStart` int(11) NOT NULL,
+  `VersionEnd` int(11) NOT NULL,
+  `ModifyTime` datetime NOT NULL,
+  PRIMARY KEY (`ID`),
+  KEY `Entry` (`Entry`),
+  KEY `User` (`User`),
+  KEY `Take` (`Take`),
+  KEY `Language` (`Language`),
+  KEY `Complete` (`Complete`),
+  KEY `VersionStart` (`VersionStart`),
+  KEY `VersionEnd` (`VersionEnd`),
+  KEY `ModifyTime` (`ModifyTime`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+    $this->System->Database->query('ALTER TABLE `'.$TableName.'`
+  ADD CONSTRAINT `'.$TableName.'_ibfk_1` FOREIGN KEY (`Language`) REFERENCES `Language` (`Id`),
+  ADD CONSTRAINT `'.$TableName.'_ibfk_2` FOREIGN KEY (`User`) REFERENCES `User` (`ID`),
+  ADD CONSTRAINT `'.$TableName.'_ibfk_3` FOREIGN KEY (`Take`) REFERENCES `'.$TableName.'` (`ID`);');
+                $DbResult = $this->System->Database->insert('Group', array('Name' => $_POST['Name'],
+                  'TablePrefix' => $TableName, 'PrimaryKeyItem' => 'Entry'));
+                $Group = $this->System->Database->insert_id;
+                $this->System->Database->insert('GroupItem', array('Group' => $Group,
+      'Name' => 'Jméno', 'Column' => 'Name', 'Visible' => 1));
+    $Output = ShowMessage('Překladová skupina vytvořena', MESSAGE_INFORMATION);
+                  } else $Output = ShowMessage('Překladová skupina '.$TableName.' již existuje', MESSAGE_CRITICAL);
+      $Output .= $this->ShowGroupTypeList();
+                } else $Output = ShowMessage('Nemáte oprávnění.', MESSAGE_CRITICAL);
+    return($Output);
+        } 
+        
+        function ShowGroupDelete()
+        {
+                if($this->System->User->Licence(LICENCE_ADMIN))
+                {
+                        $DbResult = $this->System->Database->select('Group', '*', 'Id='.$_GET['id']);
+                        if($DbResult->num_rows == 1)
+                  {
+                        $Group = $DbResult->fetch_assoc();
+                    $this->Database->query('DROP TABLE `'.$Group['TablePrefix'].'`');
+                    $this->Database->query('DELETE FROM `GroupItem` WHERE `Group`='.$Group['Id']);
+                    $this->Database->query('DELETE FROM `Group` WHERE `Id`='.$Group['Id']);
+                    $Output = ShowMessage('Překladová skupina '.$Group['Name'].' smazána', MESSAGE_INFORMATION);                    
+                  } else $Output = ShowMessage('Překladová skupina nenalezena', MESSAGE_CRITICAL);
+                } else $Output = ShowMessage('Nemáte oprávnění.', MESSAGE_CRITICAL);
+                $Output .= $this->ShowGroupTypeList();
+                return($Output);
+        }
+
         function Show()
         {
@@ -377 +438 @@
                 else if($Action == 'grouplist') $Output = $this->ShowGroupTypeList();
                 else if($Action == 'groupadd') $Output = $this->ShowGroupAdd();
+                else if($Action == 'groupdelete') $Output = $this->ShowGroupDelete();
                 else if($Action == 'groupaddfinish') $Output = $this->ShowGroupAddFinish();
                 else

trunk/admin/install.php

@@ -126 +126 @@
   'MaxExportPerUser' => 10,
   'AoWoWExportId' => 1,
-        'OriginalLanguage' => 0, 
+        'OriginalLanguage' => 1, 
   'SystemPassword' => '".$Config['SystemPassword']."',
 );";

trunk/includes/Version.php

@@ -6 +6 @@
 // and system will need database update. 
 
-$Revision = 601; // Subversion revision
+$Revision = 602; // Subversion revision
 $DatabaseRevision = 600; // Database structure revision 
 $ReleaseTime = '2013-11-25';

trunk/includes/system.php

@@ -33 +33 @@
     $this->Database->ShowSQLQuery = $this->Config['Web']['ShowSQLQuery'];
     $this->Database->ShowSQLError = $this->Config['Web']['ShowSQLError'];
-    $this->Database->LogSQLQuery = $this->Config['Web']['LogSQLQuery'];
+    //$this->Database->LogSQLQuery = $this->Config['Web']['LogSQLQuery'];
     $this->ModuleManager = new AppModuleManager();