Changeset 3636 for branches/2.2/filemanager/inc/class.notifications.inc.php

Timestamp:

12/28/10 10:09:59 (13 years ago)

Author:

alexandrecorreia

Message:

Ticket #1468 - Notificacao por email de uploads de arquivos enviados pelo modulo Filemanager

File:

• branches/2.2/filemanager/inc/class.notifications.inc.php (modified) (2 diffs)

branches/2.2/filemanager/inc/class.notifications.inc.php

@@ -130 +130 @@
         {
                 $id     = $_GET['filemanagerId'];               
-                $return = "";
+                $return = "False";
                 
                 if( $this->db )
                 {
                         $query = "DELETE FROM phpgw_filemanager_notification WHERE filemanager_id = '".$id."';";
-                        
-                        if( !$this->db->query($query) )
-                                $return = "False";
-                        else
-                                $return = "True";
+
+                        if( $this->db->query( $query ) )
+                                $return = "True";
                 }
                 
@@ -145 +143 @@
         }
         
-        public function SearchEmail( $pData )
+        public function SearchId( $pData )
         {
-                $query = "SELECT * FROM phpgw_filemanager_notification WHERE email_from like '%".$pData."%';";
+                $query = "SELECT * FROM phpgw_filemanager_notification WHERE filemanager_id ='".$pData."';";
                 
                 if( $this->db )
                 {
                         if( $this->db->query($query) )
+                        {
+                                while( $this->db->next_record())
+                                        $result[] = $this->db->row();                                   
+                        }
+                }
+                
+                return $result;
+        }
+        
+        public function SearchEmail( $pEmail, $pLimit, $pOffset )
+        {
+                $query = "SELECT * FROM phpgw_filemanager_notification WHERE email_from like '%".$pEmail."%' " .
+                                 "ORDER BY email_from OFFSET (".$pOffset."-1)*".$pLimit." LIMIT ".$pLimit.";";
+
+                if( $this->db )
+                {
+                        if( $this->db->query($query, __LINE__, __FILE__, $pOffset) )
                         {
                                 while( $this->db->next_record())