summaryrefslogtreecommitdiffstats
path: root/apps/contacts/lib/addressbook.php
diff options
context:
space:
mode:
Diffstat (limited to 'apps/contacts/lib/addressbook.php')
-rw-r--r--apps/contacts/lib/addressbook.php344
1 files changed, 16 insertions, 328 deletions
diff --git a/apps/contacts/lib/addressbook.php b/apps/contacts/lib/addressbook.php
index 06857e52418..2e869d7de3b 100644
--- a/apps/contacts/lib/addressbook.php
+++ b/apps/contacts/lib/addressbook.php
@@ -33,16 +33,7 @@
* ctag INT(11) UNSIGNED NOT NULL DEFAULT '1'
* );
*
- * CREATE TABLE contacts_cards (
- * id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
- * addressbookid INT(11) UNSIGNED NOT NULL,
- * fullname VARCHAR(255),
- * carddata TEXT,
- * uri VARCHAR(100),
- * lastmodified INT(11) UNSIGNED
- * );
*/
-
/**
* This class manages our addressbooks.
*/
@@ -52,7 +43,7 @@ class OC_Contacts_Addressbook{
* @param string $uid
* @return array
*/
- public static function allAddressbooks($uid){
+ public static function all($uid){
$stmt = OC_DB::prepare( 'SELECT * FROM *PREFIX*contacts_addressbooks WHERE userid = ?' );
$result = $stmt->execute(array($uid));
@@ -69,9 +60,9 @@ class OC_Contacts_Addressbook{
* @param string $principaluri
* @return array
*/
- public static function allAddressbooksWherePrincipalURIIs($principaluri){
+ public static function allWherePrincipalURIIs($principaluri){
$uid = self::extractUserID($principaluri);
- return self::allAddressbooks($uid);
+ return self::all($uid);
}
/**
@@ -79,7 +70,7 @@ class OC_Contacts_Addressbook{
* @param integer $id
* @return associative array
*/
- public static function findAddressbook($id){
+ public static function find($id){
$stmt = OC_DB::prepare( 'SELECT * FROM *PREFIX*contacts_addressbooks WHERE id = ?' );
$result = $stmt->execute(array($id));
@@ -93,8 +84,8 @@ class OC_Contacts_Addressbook{
* @param string $description
* @return insertid
*/
- public static function addAddressbook($userid,$name,$description){
- $all = self::allAddressbooks($userid);
+ public static function add($userid,$name,$description){
+ $all = self::all($userid);
$uris = array();
foreach($all as $i){
$uris[] = $i['uri'];
@@ -116,7 +107,7 @@ class OC_Contacts_Addressbook{
* @param string $description
* @return insertid
*/
- public static function addAddressbookFromDAVData($principaluri,$uri,$name,$description){
+ public static function addFromDAVData($principaluri,$uri,$name,$description){
$userid = self::extractUserID($principaluri);
$stmt = OC_DB::prepare( 'INSERT INTO *PREFIX*contacts_addressbooks (userid,displayname,uri,description,ctag) VALUES(?,?,?,?,?)' );
@@ -132,7 +123,7 @@ class OC_Contacts_Addressbook{
* @param string $description
* @return boolean
*/
- public static function editAddressbook($id,$name,$description){
+ public static function edit($id,$name,$description){
// Need these ones for checking uri
$addressbook = self::find($id);
@@ -150,226 +141,35 @@ class OC_Contacts_Addressbook{
}
/**
- * @brief Updates ctag for addressbook
- * @param integer $id
- * @return boolean
- */
- public static function touchAddressbook($id){
- $stmt = OC_DB::prepare( 'UPDATE *PREFIX*contacts_addressbooks SET ctag = ctag + 1 WHERE id = ?' );
- $stmt->execute(array($id));
-
- return true;
- }
-
- /**
* @brief removes an address book
* @param integer $id
* @return boolean
*/
- public static function deleteAddressbook($id){
+ public static function delete($id){
$stmt = OC_DB::prepare( 'DELETE FROM *PREFIX*contacts_addressbooks WHERE id = ?' );
$stmt->execute(array($id));
- $stmt = OC_DB::prepare( 'DELETE FROM *PREFIX*contacts_cards WHERE addressbookid = ?' );
- $stmt->execute(array($id));
-
- return true;
- }
-
- /**
- * @brief Returns all cards of an address book
- * @param integer $id
- * @return array
- *
- * The cards are associative arrays. You'll find the original vCard in
- * ['carddata']
- */
- public static function allCards($id){
- $stmt = OC_DB::prepare( 'SELECT * FROM *PREFIX*contacts_cards WHERE addressbookid = ?' );
- $result = $stmt->execute(array($id));
-
- $addressbooks = array();
- while( $row = $result->fetchRow()){
- $addressbooks[] = $row;
- }
-
- return $addressbooks;
- }
-
- /**
- * @brief Returns a card
- * @param integer $id
- * @return associative array
- */
- public static function findCard($id){
- $stmt = OC_DB::prepare( 'SELECT * FROM *PREFIX*contacts_cards WHERE id = ?' );
- $result = $stmt->execute(array($id));
-
- return $result->fetchRow();
- }
-
- /**
- * @brief finds a card by its DAV Data
- * @param integer $aid Addressbook id
- * @param string $uri the uri ('filename')
- * @return associative array
- */
- public static function findCardWhereDAVDataIs($aid,$uri){
- $stmt = OC_DB::prepare( 'SELECT * FROM *PREFIX*contacts_cards WHERE addressbookid = ? AND uri = ?' );
- $result = $stmt->execute(array($aid,$uri));
-
- return $result->fetchRow();
- }
-
- /**
- * @brief Adds a card
- * @param integer $id Addressbook id
- * @param string $data vCard file
- * @return insertid
- */
- public static function addCard($id,$data){
- $fn = null;
- $uri = null;
-
- $card = self::parse($data);
- if(!is_null($card)){
- foreach($card->children as $property){
- if($property->name == 'FN'){
- $fn = $property->value;
- }
- elseif(is_null($uri) && $property->name == 'UID' ){
- $uri = $property->value.'.vcf';
- }
- }
- if(is_null($uri)){
- $uid = self::createUID();
- $uri = $uid.'.vcf';
- $card->add(new Sabre_VObject_Property('UID',$uid));
- $data = $card->serialize();
- };
- }
- else{
- // that's hard. Creating a UID and not saving it
- $uid = self::createUID();
- $uri = $uid.'.vcf';
- };
-
- $stmt = OC_DB::prepare( 'INSERT INTO *PREFIX*contacts_cards (addressbookid,fullname,carddata,uri,lastmodified) VALUES(?,?,?,?,?)' );
- $result = $stmt->execute(array($id,$fn,$data,$uri,time()));
-
- self::touchAddressbook($id);
-
- return OC_DB::insertid();
- }
-
- /**
- * @brief Adds a card with the data provided by sabredav
- * @param integer $id Addressbook id
- * @param string $uri the uri the card will have
- * @param string $data vCard file
- * @return insertid
- */
- public static function addCardFromDAVData($id,$uri,$data){
- $fn = null;
- $card = self::parse($data);
- if(!is_null($card)){
- foreach($card->children as $property){
- if($property->name == 'FN'){
- $fn = $property->value;
- }
- }
- }
-
- $stmt = OC_DB::prepare( 'INSERT INTO *PREFIX*contacts_cards (addressbookid,fullname,carddata,uri,lastmodified) VALUES(?,?,?,?,?)' );
- $result = $stmt->execute(array($id,$fn,$data,$uri,time()));
-
- self::touchAddressbook($id);
-
- return OC_DB::insertid();
- }
-
- /**
- * @brief edits a card
- * @param integer $id id of card
- * @param string $data vCard file
- * @return boolean
- */
- public static function editCard($id, $data){
- $oldcard = self::findCard($id);
- $fn = null;
-
- $card = self::parse($data);
- if(!is_null($card)){
- foreach($card->children as $property){
- if($property->name == 'FN'){
- $fn = $property->value;
- }
- }
+ $cards = OC_Contacts_VCard::all($id);
+ foreach($cards as $card){
+ OC_Contacts_VCard::delete($card['id']);
}
- $stmt = OC_DB::prepare( 'UPDATE *PREFIX*contacts_cards SET fullname = ?,carddata = ?, lastmodified = ? WHERE id = ?' );
- $result = $stmt->execute(array($fn,$data,time(),$id));
-
- self::touchAddressbook($oldcard['addressbookid']);
-
return true;
}
/**
- * @brief edits a card with the data provided by sabredav
- * @param integer $id Addressbook id
- * @param string $uri the uri of the card
- * @param string $data vCard file
- * @return boolean
- */
- public static function editCardFromDAVData($aid,$uri,$data){
- $oldcard = self::findCardWhereDAVDataIs($aid,$uri);
-
- $fn = null;
- $card = self::parse($data);
- if(!is_null($card)){
- $card = Sabre_VObject_Reader::read($data);
- foreach($card->children as $property){
- if($property->name == 'FN'){
- $fn = $property->value;
- }
- }
- }
-
- $stmt = OC_DB::prepare( 'UPDATE *PREFIX*contacts_cards SET fullname = ?,carddata = ?, lastmodified = ? WHERE id = ?' );
- $result = $stmt->execute(array($fn,$data,time(),$oldcard['id']));
-
- self::touchAddressbook($oldcard['addressbookid']);
-
- return true;
- }
-
- /**
- * @brief deletes a card
- * @param integer $id id of card
+ * @brief Updates ctag for addressbook
+ * @param integer $id
* @return boolean
*/
- public static function deleteCard($id){
- $stmt = OC_DB::prepare( 'DELETE FROM *PREFIX*contacts_cards WHERE id = ?' );
+ public static function touch($id){
+ $stmt = OC_DB::prepare( 'UPDATE *PREFIX*contacts_addressbooks SET ctag = ctag + 1 WHERE id = ?' );
$stmt->execute(array($id));
return true;
}
/**
- * @brief deletes a card with the data provided by sabredav
- * @param integer $aid Addressbook id
- * @param string $uri the uri of the card
- * @return boolean
- */
- public static function deleteCardFromDAVData($aid,$uri){
- $stmt = OC_DB::prepare( 'DELETE FROM *PREFIX*contacts_cards WHERE addressbookid = ? AND uri=?' );
- $stmt->execute(array($aid,$uri));
-
- return true;
- }
-
- /**
* @brief Creates a URI for Addressbook
* @param string $name name of the addressbook
* @param array $existing existing addressbook URIs
@@ -387,14 +187,6 @@ class OC_Contacts_Addressbook{
}
/**
- * @brief Creates a UID
- * @return string
- */
- public static function createUID(){
- return substr(md5(rand().time()),0,10);
- }
-
- /**
* @brief gets the userid from a principal path
* @return string
*/
@@ -402,108 +194,4 @@ class OC_Contacts_Addressbook{
list($prefix,$userid) = Sabre_DAV_URLUtil::splitPath($principaluri);
return $userid;
}
-
- /**
- * @brief Escapes semicolons
- * @param string $value
- * @return string
- */
- public static function escapeSemicolons($value){
- foreach($value as &$i ){
- $i = implode("\\\\;", explode(';', $i));
- } unset($i);
- return implode(';',$value);
- }
-
- /**
- * @brief Creates an array out of a multivalue property
- * @param string $value
- * @return array
- */
- public static function unescapeSemicolons($value){
- $array = explode(';',$value);
- for($i=0;$i<count($array);$i++){
- if(substr($array[$i],-2,2)=="\\\\"){
- if(isset($array[$i+1])){
- $array[$i] = substr($array[$i],0,count($array[$i])-2).';'.$array[$i+1];
- unset($array[$i+1]);
- }
- else{
- $array[$i] = substr($array[$i],0,count($array[$i])-2).';';
- }
- $i = $i - 1;
- }
- }
- return $array;
- }
-
- /**
- * @brief Data structure of vCard
- * @param object $property
- * @return associative array
- *
- * look at code ...
- */
- public static function structureContact($object){
- $details = array();
- foreach($object->children as $property){
- $temp = self::structureProperty($property);
- if(array_key_exists($property->name,$details)){
- $details[$property->name][] = $temp;
- }
- else{
- $details[$property->name] = array($temp);
- }
- }
- return $details;
- }
-
- /**
- * @brief Data structure of properties
- * @param object $property
- * @return associative array
- *
- * returns an associative array with
- * ['name'] name of property
- * ['value'] htmlspecialchars escaped value of property
- * ['parameters'] associative array name=>value
- * ['checksum'] checksum of whole property
- */
- public static function structureProperty($property){
- $value = $property->value;
- $value = htmlspecialchars($value);
- if($property->name == 'ADR' || $property->name == 'N'){
- $value = self::unescapeSemicolons($value);
- }
- $temp = array(
- 'name' => $property->name,
- 'value' => $value,
- 'parameters' => array(),
- 'checksum' => md5($property->serialize()));
- foreach($property->parameters as $parameter){
- // Faulty entries by kaddressbook
- if($parameter->name == 'TYPE' && $parameter->value == 'PREF'){
- $parameter->name = 'PREF';
- $parameter->value = '1';
- }
- $temp['parameters'][$parameter->name] = $parameter->value;
- }
- return $temp;
- }
-
- /**
- * @brief Parses a vcard file
- * @param string vCard
- * @return Sabre_VObject or null
- *
- * Will retun the vobject if sabre DAV is able to parse the file.
- */
- public static function parse($data){
- try {
- $card = Sabre_VObject_Reader::read($data);
- return $card;
- } catch (Exception $e) {
- return null;
- }
- }
}
generated by cgit v1.2.3 (git 2.39.1) at 2025-02-04 05:52:52 +0000