Changeset 1627 for trunk/phpgwapi

Timestamp:

11/12/09 09:06:56 (14 years ago)

Author:

amuller

Message:

Ticket #597 - Implementações novas, com arquivos restritos, quota, ckeditor

File:

• trunk/phpgwapi/inc/class.vfs_sql.inc.php (modified) (13 diffs)

trunk/phpgwapi/inc/class.vfs_sql.inc.php

@@ -38 +38 @@
                 var $working_id;
                 var $working_lid;
+                var $my_home;
                 var $meta_types;
                 var $now;
@@ -52 +53 @@
                         $this->working_id = $GLOBALS['phpgw_info']['user']['account_id'];
                         $this->working_lid = $GLOBALS['phpgw']->accounts->id2name($this->working_id);
+                        $this->my_home = $this->fakebase.'/'.$this->working_lid;
                         $this->now = date ('Y-m-d H:i:s');
 
@@ -64 +66 @@
                         $this->attributes[] = 'deleteable';
                         $this->attributes[] = 'content';
+                        $this->attributes[] = 'type';
 
                         /*
@@ -612 +615 @@
                 function acl_check ($data)
                 {
+
                         if (!is_array ($data))
                         {
                                 $data = array ();
                         }
+
+                        /* ExpressoLivre principle: In your home you do what you want*/
+                        if (strpos($data['string'],$this->my_home) === 0)
+                                return True;
 
                         $default_values = array
@@ -845 +853 @@
                                 $data = array ();
                         }
+
+                        $path = explode('/',$data['string']);
+                        $quota = $this->get_quota(array('string' => '/'.$path[1].'/'.$path[2]));
+                        if ($quota > 0 && $this->get_size($data) >= $quota * 1024 * 1024)
+                                return false;
+
 
                         $default_values = array
@@ -1082 +1096 @@
                                 $data = array ();
                         }
+                        $path = explode('/',$data['to']);
+                        $quota = $this->get_quota(array('string' => '/'.$path[1].'/'.$path[2]));
+                        $size = $this->get_size(array('string' => $data['to'], 'relatives' => $data['relatives'][1]));
+                        if ($quota > 0 && $size >= $quota * 1024 * 1024)
+                                return false;
 
                         $default_values = array
@@ -1344 +1363 @@
                                 $data = array ();
                         }
+
+                        $path = explode('/',$data['to']);
+                        $quota = $this->get_quota(array('string' => '/'.$path[1].'/'.$path[2]));
+                        $size = $this->get_size(array('string' => $data['to'], 'relatives' => $data['relatives'][1]));
+                        if ($quota > 0 && $size >= $quota * 1024 * 1024)
+                                return false;
+
 
                         $default_values = array
@@ -2325 +2351 @@
                         return $size;
                 }
+                /*
+                 * get the quota defined for the path in sql table
+                 */
+                function get_quota($data){
+                        if (!is_array ($data))
+                        {
+                                $data = array ();
+                        }
+
+                        $default_values = array
+                                (
+                                        'relatives'     => array (RELATIVE_CURRENT)
+                                );
+
+                        $data = array_merge ($this->default_values ($data, $default_values), $data);
+
+                        $p = $this->path_parts (array(
+                                        'string'        => $data['string'],
+                                        'relatives'     => RELATIVE_NONE
+                                )
+                        );
+
+                        if (!$this->acl_check (array(
+                                'string'        => $p->fake_full_path,
+                                'relatives'     => $p->mask,
+                                'operation'     => PHPGW_ACL_READ
+                        ))
+                        )
+                        {
+                                return False;
+                        }
+                        $query = $GLOBALS['phpgw']->db->query ("SELECT quota_size FROM phpgw_vfs_quota WHERE directory = '".$data['string']."' LIMIT 1;", __LINE__,__FILE__);
+
+                        $GLOBALS['phpgw']->db->next_record ();
+                        $record = $GLOBALS['phpgw']->db->Record;
+                        return $record['quota_size'];
+                }
+                function set_quota($data){
+                        if (!is_array ($data))
+                        {
+                                $data = array ();
+                        }
+
+                        $default_values = array
+                                (
+                                        'relatives'     => array (RELATIVE_CURRENT)
+                                );
+
+                        $data = array_merge ($this->default_values ($data, $default_values), $data);
+
+                        $p = $this->path_parts (array(
+                                        'string'        => $data['string'],
+                                        'relatives'     => array ($data['relatives'][0])
+                                )
+                        );
+
+                        if (!$this->acl_check (array(
+                                'string'        => $p->fake_full_path,
+                                'relatives'     => array ($p->mask),
+                                'operation'     => PHPGW_ACL_READ
+                        ))
+                        )
+                        {
+                                return False;
+                        }
+                        // INSERT INTO phpgw_vfs_quota values('/home/amuller',200);
+                        //
+                        return $GLOBALS['phpgw']->db->query("INSERT INTO phpgw_vfs_quota VALUES ('".$data['string']."',".$data['new_quota'].");", __LINE__,__FILE__);
+                }
+
 
                 /*!
@@ -2399 +2495 @@
                         $dir = $p->fake_full_path;
 
+
                         /* If they pass us a file or 'nofiles' is set, return the info for $dir only */
                         if (@$data['file_id']
@@ -2428 +2525 @@
                                 else
                                 {
-                                        $sql .= "directory='".$GLOBALS['phpgw']->db->db_addslashes($p->fake_leading_dirs_clean).
-                                                "' AND name='".$GLOBALS['phpgw']->db->db_addslashes($p->fake_name_clean)."'".
+                                        $sql .= " directory='".$GLOBALS['phpgw']->db->db_addslashes($p->fake_leading_dirs_clean)."' AND".
+                                                " name='".$GLOBALS['phpgw']->db->db_addslashes($p->fake_name_clean)."'".
                                                 $this->extra_sql (array ('query_type' => VFS_SQL_SELECT));
                                 }
@@ -2508 +2605 @@
                         /* SELECT all, the, attributes FROM phpgw_vfs WHERE file=$dir */
                         $sql = 'SELECT ';
+                        if (!$this->acl_check (array (
+                                'string' => $p->fake_full_path,
+                                'relatives' => array ($p->mask),
+                                'operation' => PHPGW_ACL_PRIVATE)
+                        ))
+                        $query_type = " type != 1 AND";
+                        else
+                                $query_type = "";
 
                         foreach($this->attributes as $num => $attribute)
@@ -2520 +2625 @@
 
                         $dir_clean = $this->clean_string (array ('string' => $dir));
-                        $sql .= " FROM phpgw_vfs WHERE directory LIKE '".$GLOBALS['phpgw']->db->db_addslashes($dir_clean)."%'";
+                        $sql .= " FROM phpgw_vfs WHERE ".$query_type." directory LIKE '".$GLOBALS['phpgw']->db->db_addslashes($dir_clean)."%'";
                         $sql .= $this->extra_sql (array ('query_type' => VFS_SQL_SELECT));
 
@@ -2527 +2632 @@
                                 $sql .= " AND mime_type='".$data['mime_type']."'";
                         }
-
-                        $sql .= ' ORDER BY '.$data['orderby'];
-
+                        if (strlen($data['orderby']) > 0)
+                                $sql .= ' ORDER BY '.$data['orderby'];
                         $query = $GLOBALS['phpgw']->db->query ($sql, __LINE__, __FILE__);