openrat-cms

commit cb6ce6697ceafc82aea9b06fc17a2a9a701b658d
parent 9802d15619886cf323dc8a7f0ef57b8783562cc1
Author: dankert <devnull@localhost>
Date:   Thu,  1 Jun 2006 22:58:11 +0200

Projektwartung: Suche nach verlorenen Dateien.

Diffstat:
objectClasses/Project.class.php
 | 
35
++++++++++++++++++++++++++++++++++-

1 file changed, 34 insertions(+), 1 deletion(-)
diff --git a/objectClasses/Project.class.php b/objectClasses/Project.class.php
@@ -20,7 +20,10 @@
 // Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 // ---------------------------------------------------------------------------
 // $Log$
-// Revision 1.8  2004-12-29 20:18:20  dankert
+// Revision 1.9  2006-06-01 20:58:11  dankert
+// Projektwartung: Suche nach verlorenen Dateien.
+//
+// Revision 1.8  2004/12/29 20:18:20  dankert
 // Konstruktor geaendert
 //
 // Revision 1.7  2004/12/19 15:23:56  dankert
@@ -346,6 +349,36 @@ class Project
 		
 		return $db->getOne( $sql->query );
 	}
+	
+	
+	function checkLostFiles()
+	{
+		$db = &Session::getDatabase();
+		
+		$sql = new Sql( <<<EOF
+SELECT thistab.id FROM {t_object} AS thistab
+ LEFT JOIN {t_object} AS parenttab
+        ON parenttab.id = thistab.parentid
+  WHERE thistab.projectid={projectid} AND thistab.parentid IS NOT NULL AND parenttab.id IS NULL
+EOF
+);
+		$sql->setInt('projectid',$this->projectid);
+
+		$lostAndFoundFolder = new Folder();
+		$lostAndFoundFolder->projectid = $this->projectid;
+		$lostAndFoundFolder->languageid = $this->getDefaultLanguageId();
+		$lostAndFoundFolder->filename = "lostandfound";
+		$lostAndFoundFolder->name     = 'Lost+found';
+		$lostAndFoundFolder->parentid = $this->getRootObjectId();
+		$lostAndFoundFolder->add();
+
+		foreach( $db->getCol($sql->query) as $id )
+		{
+			echo 'Lost file! moving '.$id.' to lost+found.';
+			$obj = new Object( $id );
+			$obj->setParentId( $lostAndFoundFolder->objectid );
+		}
+	}
 }
 
 ?> 
\ No newline at end of file