Changeset 1830

Timestamp:

12/15/09 09:14:15 (14 years ago)

Author:

amuller

Message:

Ticket #597 - Melhoria do FM, miniatura thumbnail de imagens

File:

• trunk/phpgwapi/inc/class.vfs_sql.inc.php (modified) (1 diff)

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

@@ -1994 +1994 @@
                         return True;
                 }
+                function summary ($data)
+                {
+
+                        if (!$this->acl_check (array(
+                                        'string'        => $data['path'].'/'.$data['string'],
+                                        'relatives'     => array (RELATIVE_NONE),
+                                        'operation'     => PHPGW_ACL_READ
+                                ))
+                        )
+                        {
+                                return False;
+                        }
+
+                        $query = "SELECT summary FROM phpgw_vfs WHERE directory = '"
+                                .$data['path']."' AND name = '".$data['string']."' and mime_type != 'journal' and mime_type != 'journal-deleted' LIMIT 1";
+                        if ($GLOBALS['phpgw']->db->query($query) && $GLOBALS['phpgw']->db->next_record()){
+                                $val = $GLOBALS['phpgw']->db->row();
+                                echo $val['summary'];
+
+                        }
+                        else
+                        {
+                                echo $GLOBALS['phpgw']->db->error;
+                                return false;
+                        }
+                }
+
+                function set_summary($data){
+                        if (!is_array ($data))
+                        {
+                                $data = array ();
+                        }
+
+                        $default_values = array
+                                (
+                                        'relatives'     => array (RELATIVE_CURRENT),
+                                        'attributes'    => array ()
+                                );
+
+                        $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_EDIT
+                                ))
+                        )
+                        {
+                                return False;
+                        }
+                        if (!$this->file_exists (array(
+                                        'string'        => $data['string'],
+                                        'relatives'     => array ($data['relatives'][0])
+                                ))
+                        )
+                        {
+                                return False;
+                        }
+                        $ls_array = $this->ls (array(
+                                        'string'        => $p->fake_full_path,
+                                        'relatives'     => array ($p->mask),
+                                        'checksubdirs'  => False,
+                                        'nofiles'       => True
+                                )
+                        );
+                        $record = $ls_array[0]; 
+                        $data['summary'] = pg_escape_bytea($data['summary']);
+                        $sql = 'UPDATE phpgw_vfs SET summary = \''.$data['summary'].'\'';
+                        $sql .= ' WHERE file_id='.(int) $ls_array[0]['file_id'];
+                        $sql .= $this->extra_sql (array ('query_type' => VFS_SQL_UPDATE));
+                        $query = $GLOBALS['phpgw']->db->query ($sql, __LINE__, __FILE__);
+                }
 
                 /*