Changeset 7855 for sandbox/webservice/api/rest/catalog/ContactPictureResource.php

Timestamp:

02/05/13 15:03:49 (11 years ago)

Author:

alexandrecorreia

Message:

Ticket #2507 - Correções dentro da API do webservice do expresso

File:

• sandbox/webservice/api/rest/catalog/ContactPictureResource.php (modified) (1 diff)

sandbox/webservice/api/rest/catalog/ContactPictureResource.php

@@ -10 +10 @@
                         $contact = array();
                         $contactID = $this->getParam('contactID');
+
                         // User Contact
-                        if($this->getParam('contactType') == 1 && $contactID != null){
-                                $query = 'select A.id_contact, A.photo from phpgw_cc_contact A where A.id_contact='.$contactID.' and A.id_owner='.$this -> getUserId();
-                                if (!$this->getDb()->query($query))
-                                        return false;
-                                if($this->getDb()->next_record()) {
-                                        $row = $this->getDb()->row();
-                                        if($row['photo'] != null) {
-                                                $contact[] = array(
-                                                                'contactID'             => $row['id_contact'],
-                                                                'contactImagePicture'   => ($row['photo'] != null ? base64_encode($row['photo']) : "")
-                                                );
-                                        }
-                                }
-                        }
+            if($this->getParam('contactType') == 1 && $contactID != null){
+
+                $query = "select A.id_contact, A.photo from phpgw_cc_contact A where A.id_contact= ? and A.id_owner = ? ";
+
+                $result = $this->getDb()->Link_ID->query($query, array($contactID,$this->getUserId()));
+
+                if ($result) {
+
+                    while($row = $result->fetchRow()) {
+                        if($row['photo'] != null) {
+                            $contact[] = array(
+                                'contactID'     => $row['id_contact'],
+                                'contactImagePicture'   => ($row['photo'] != null ? base64_encode($row['photo']) : "")
+                            );
+                        }
+                    }
+   
+                }
+            }
+
                         // Global Catalog
                         elseif($this->getParam('contactType') == 2){