Changeset 695 for trunk/Modules/Export/Page.php

Timestamp:

Jan 3, 2014, 11:09:37 AM (11 years ago)

Author:

maron

Message:

• Added: selection groupitems in export

File:

• trunk/Modules/Export/Page.php (modified) (4 diffs)

trunk/Modules/Export/Page.php

@@ -430 +430 @@
                                 $Output .= ShowMessage('Výběr uložen.');
                         }
+          //items
+      foreach($TranslationTree as $Group) 
+                {
+                //  echo $Group['Id'].' ';
+        foreach($TranslationTree[$Group['Id']]['Items'] as $Column) {
+          if(array_key_exists('item'.$Column['Id'], $_POST)) $Selected = true;
+          else $Selected = false;
+          //we will save only forbitten collums and need to be visible
+          $Selected = !$Selected;
+          if (!$Column['Visible']) $Selected = false;  
+
+                                                $Condition = ' WHERE `Export`='.$_GET['ExportId'].' AND `GroupItem`='.$Column['Id'];
+                                                $DbResult = $this->System->Database->query('SELECT * FROM `ExportGroupItem` '.$Condition);
+                                                if($DbResult->num_rows > 0)
+                                                {
+                                                        if(!$Selected) $this->System->Database->query('DELETE FROM `ExportGroupItem` '.$Condition);
+                                                } else
+                                                {
+                                                        if($Selected) $this->System->Database->query('INSERT INTO `ExportGroupItem` (`Export`, `GroupItem`) VALUES ('.$_GET['ExportId'].', '.$Column['Id'].')');
+                                                }
+
+        }
+      }
                 }
         
@@ -439 +462 @@
         
                 $TableColumns = array(
+                                array('Name' => '', 'Title' => 'Výběr'),
                                 array('Name' => 'Name', 'Title' => 'Jméno'),
-                                array('Name' => 'MangosTable', 'Title' => 'Tabulka MaNGOSu'),
-                                array('Name' => 'DBCFileName', 'Title' => 'DBC soubor'),
-                                array('Name' => 'LuaFileName', 'Title' => 'Lua soubor'),
-                                array('Name' => '', 'Title' => 'Výběr'),
+                                array('Name' => 'MangosTable', 'Title' => 'Mangos/DBC/Lua'),
+                //              array('Name' => 'DBCFileName', 'Title' => 'DBC soubor'),
+                //              array('Name' => 'LuaFileName', 'Title' => 'Lua soubor'),
+                                array('Name' => '', 'Title' => 'Položky překladu'),
                 );
                 $Order = GetOrderTableHeader($TableColumns, 'Name');
@@ -460 +484 @@
                 '<table class="BaseTable">'.
                 $Order['Output'];
+
+          $DbResultItem = $this->System->Database->query('SELECT * FROM `ExportGroupItem` WHERE `Export`='.$_GET['ExportId']);
+                while($GroupItem = $DbResultItem->fetch_assoc())
+                {
+                  $GroupItems[$GroupItem['GroupItem']] = 1;
+    }
         
                 $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
@@ -465 +495 @@
                 while($Group = $DbResult->fetch_assoc())
                 {
+      $Columns = '';
+      foreach($TranslationTree[$Group['Id']]['Items'] as $Column) {
+        if ($Column['Visible'])  $Columns .= CheckBox('item'.$Column['Id'], !isset($GroupItems[$Column['Id']]), '', 'CheckBox', !$Editable).' '.$Column['Name'].' <br />';
+      }
                         $Checked = $Group['ExportGroupId'] != '';
                         $Selection = CheckBox('sel'.$Group['Id'], $Checked, '', 'CheckBox', !$Editable);
                         $Output .= '<tr>'.
-                                        '<td>'.$Group['Name'].'</td>'.
-                                        '<td>'.$Group['MangosTable'].'</td>'.
-                                        '<td>'.$Group['DBCFileName'].'</td>'.
-                                        '<td>'.$Group['LuaFileName'].'</td>'.
-                                        '<td>'.$Selection.'<input type="hidden" name="seq'.$Group['Id'].'"/></td></tr>';
+                                        '<td>'.$Selection.'<input type="hidden" name="seq'.$Group['Id'].'"/></td>'.
+                                        '<td>'.$Group['Name'].'</td><td>';
+                                        if ($Group['MangosTable'] <> '')
+                                          $Output .= $Group['MangosTable'].'.sql ';
+                                        if ($Group['LuaFileName'] <> '')
+                                          $Output .= $Group['LuaFileName'].'.lua ';
+                                        if ($Group['DBCFileName'] <> '')
+                                          $Output .= $Group['DBCFileName'].'.dbc ';
+      
+      $Output .=                '</td><td>';
+      $Output .=        $Columns.       '</td>';
+      $Output .=     '</tr>';
                 }
                 $Output .= '</table>'.