Changeset 646 for trunk/Modules/Export/Export.php

Timestamp:

Dec 14, 2013, 12:51:59 PM (11 years ago)

Author:

maron

Message:

• Added: Options export from all users

File:

• trunk/Modules/Export/Export.php (modified) (1 diff)

trunk/Modules/Export/Export.php

@@ -22 +22 @@
     $this->SourceDirRelative = $this->Config['Web']['SourceFolder'];
     if(!file_exists($this->SourceDir)) mkdir($this->SourceDir, 0777, true);
+    $this->SaveAllUsers();
+  }
+  
+  function SaveAllUsers() {
+                $DbResult = $this->System->Database->query('SELECT * FROM `Export` WHERE `Id`='.$this->Id);
+                $Export = $DbResult->fetch_assoc();
+                if ($Export['AllUsers']) {
+                        $DbResult2 = $this->System->Database->query('SELECT ID FROM `User` WHERE `ID` NOT IN(SELECT `User` FROM `ExportUser` WHERE `Export`='.$this->Id.')');
+                        while($UserLine = $DbResult2->fetch_assoc())
+                        {
+                                                $Condition = ' WHERE `Export`='.$this->Id.' AND `User`='.$UserLine['ID'];
+                                                $DbResult = $this->System->Database->query('SELECT * FROM `ExportUser` '.$Condition); //,MAX(`Sequence`) as MaxSequence
+                                                if($DbResult->num_rows > 0)
+                                                {
+                                                //      $this->System->Database->query('UPDATE `ExportUser` SET `Sequence`='.$Value.$Condition);
+                                                } else
+                                                {
+              $this->System->Database->query('INSERT INTO `ExportUser` (`Export`, `User`, `Sequence`) VALUES ('.$this->Id.', '.$UserLine['ID'].', 0)');
+                                                }
+                        }
+                        
+      $this->System->Database->query('SET @I = 0');
+                        $this->System->Database->query('UPDATE `ExportUser` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$this->Id.' ORDER BY `Sequence`;');
+                }
   }