api/v3/Relationship.php

   1 <?php
   2
   3 /*
   4  +--------------------------------------------------------------------+
   5  | CiviCRM version 4.3                                                |
   6  +--------------------------------------------------------------------+
   7  | Copyright CiviCRM LLC (c) 2004-2013                                |
   8  +--------------------------------------------------------------------+
   9  | This file is a part of CiviCRM.                                    |
  10  |                                                                    |
  11  | CiviCRM is free software; you can copy, modify, and distribute it  |
  12  | under the terms of the GNU Affero General Public License           |
  13  | Version 3, 19 November 2007 and the CiviCRM Licensing Exception.   |
  14  |                                                                    |
  15  | CiviCRM is distributed in the hope that it will be useful, but     |
  16  | WITHOUT ANY WARRANTY; without even the implied warranty of         |
  17  | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
  18  | See the GNU Affero General Public License for more details.        |
  19  |                                                                    |
  20  | You should have received a copy of the GNU Affero General Public   |
  21  | License and the CiviCRM Licensing Exception along                  |
  22  | with this program; if not, contact CiviCRM LLC                     |
  23  | at info[AT]civicrm[DOT]org. If you have questions about the        |
  24  | GNU Affero General Public License or the licensing of CiviCRM,     |
  25  | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
  26  +--------------------------------------------------------------------+
  27 */
  28
  29 /**
  30  * File for the CiviCRM APIv3 relationship functions
  31  *
  32  * @package CiviCRM_APIv3
  33  * @subpackage API_Relationship
  34  *
  35  * @copyright CiviCRM LLC (c) 2004-2013
  36  * @version $Id: Relationship.php 30486 2010-11-02 16:12:09Z shot $
  37  *
  38  */
  39
  40 /**
  41  * Add or update a relationship
  42  *
  43  * @param  array   $params  input parameters
  44  *
  45  * @example RelationshipCreate.php Std Create example
  46  *
  47  * @return array API Result Array
  48  * {@getfields relationship_create}
  49  * @static void
  50  * @access public
  51  *
  52  */
  53 function civicrm_api3_relationship_create($params) {
  54
  55   $values = array();
  56   _civicrm_api3_relationship_format_params($params, $values);
  57   $ids = array();
  58
  59   if (CRM_Utils_Array::value('id', $params)) {
  60     $ids['contactTarget'] = $values['contact_id_b'];
  61   }
  62
  63   $values['relationship_type_id'] = $values['relationship_type_id'] . '_a_b';
  64   if(!empty($params['contact_id_b'])){
  65     $values['contact_check'] = array($params['contact_id_b'] => $params['contact_id_b']);
  66   }
  67   if(!empty($values['contact_id_a'])){
  68     $ids['contact'] = $values['contact_id_a'];
  69   }
  70   $relationshipBAO = CRM_Contact_BAO_Relationship::create($values, $ids);
  71
  72   if ($relationshipBAO[1]) {
  73     throw new API_Exception('Relationship is not valid');
  74   }
  75   elseif ($relationshipBAO[2]) {
  76     throw new API_Exception('Relationship already exists');
  77   }
  78   $id = $relationshipBAO[4][0];
  79   $values = array();
  80   _civicrm_api3_object_to_array($relationshipBAO[5][$id], $values[$id]);
  81   return civicrm_api3_create_success($values, $params, 'relationship', 'create');
  82 }
  83
  84 /**
  85  * Adjust Metadata for Create action
  86  *
  87  * @param array $params array or parameters determined by getfields
  88  */
  89 function _civicrm_api3_relationship_create_spec(&$params) {
  90   $params['contact_id_a']['api.required'] = 1;
  91   $params['contact_id_b']['api.required'] = 1;
  92   $params['relationship_type_id']['api.required'] = 1;
  93   $params['is_active']['api.default'] = 1;
  94 }
  95
  96 /**
  97  * Delete a relationship
  98  *
  99  * @param  array $params
 100  *
 101  * @return array API Result Array
 102  * {@getfields relationship_delete}
 103  * @example RelationshipDelete.php Delete Example
 104  *
 105  * @static void
 106  * @access public
 107  */
 108 function civicrm_api3_relationship_delete($params) {
 109
 110   if (!CRM_Utils_Rule::integer($params['id'])) {
 111     return civicrm_api3_create_error('Invalid value for relationship ID');
 112   }
 113
 114   $relationBAO = new CRM_Contact_BAO_Relationship();
 115   $relationBAO->id = $params['id'];
 116   if (!$relationBAO->find(TRUE)) {
 117     return civicrm_api3_create_error('Relationship id is not valid');
 118   }
 119   else {
 120     $relationBAO->del($params['id']);
 121     return civicrm_api3_create_success('Deleted relationship successfully');
 122   }
 123 }
 124
 125 /**
 126  * Function to get the relationship
 127  *
 128  * @param array   $params input parameters.
 129  * @todo  Result is inconsistent depending on whether contact_id is passed in :
 130  * -  if you pass in contact_id - it just returns all relationships for 'contact_id'
 131  * -  if you don't pass in contact_id then it does a filter on the relationship table (DAO based search)
 132  *
 133  * @return  Array API Result Array
 134  * {@getfields relationship_get}
 135  * @example RelationshipGet.php
 136  * @access  public
 137  */
 138 function civicrm_api3_relationship_get($params) {
 139   $options = _civicrm_api3_get_options_from_params($params);
 140   if (!CRM_Utils_Array::value('contact_id', $params)) {
 141     $relationships = _civicrm_api3_basic_get(_civicrm_api3_get_BAO(__FUNCTION__), $params, FALSE);
 142   }
 143   else {
 144     $relationships = array();
 145     $relationships = CRM_Contact_BAO_Relationship::getRelationship($params['contact_id'],
 146       CRM_Utils_Array::value('status_id', $params),
 147       0,
 148       CRM_Utils_Array::value('is_count', $options),
 149       CRM_Utils_Array::value('id', $params),
 150       NULL,
 151       NULL,
 152       FALSE,
 153       $params
 154     );
 155   }
 156   //perhaps we should add a 'getcount' but at this stage lets just handle getcount output
 157   if($options['is_count']) {
 158     return array('count' => $relationships);
 159   }
 160   foreach ($relationships as $relationshipId => $values) {
 161     _civicrm_api3_custom_data_get($relationships[$relationshipId], 'Relationship', $relationshipId, NULL, CRM_Utils_Array::value('relationship_type_id',$values));
 162   }
 163   return civicrm_api3_create_success($relationships, $params);
 164 }
 165
 166 /**
 167  * take the input parameter list as specified in the data model and
 168  * convert it into the same format that we use in QF and BAO object
 169  *
 170  * @param array  $params       Associative array of property name/value
 171  *                             pairs to insert in new contact.
 172  * @param array  $values       The reformatted properties that we can use internally
 173  *                            '
 174  *
 175  * @return array|CRM_Error
 176  * @access public
 177  */
 178 function _civicrm_api3_relationship_format_params($params, &$values) {
 179   // copy all the relationship fields as is
 180
 181   $fields = CRM_Contact_DAO_Relationship::fields();
 182   _civicrm_api3_store_values($fields, $params, $values);
 183
 184   $relationTypes = CRM_Core_PseudoConstant::relationshipType('name');
 185   if (CRM_Utils_Array::value('id', $params)) {
 186     $relation = new CRM_Contact_BAO_Relationship();
 187     $relation->id = $params['id'];
 188     if (!$relation->find(TRUE)) {
 189       throw new Exception('Relationship id is not valid');
 190     }
 191     else {
 192       if ((isset($params['contact_id_a']) && $params['contact_id_a'] != $relation->contact_id_a) ||
 193         (isset($params['contact_id_b']) && $params['contact_id_b'] != $relation->contact_id_b)
 194       ) {
 195         throw new Exception('Cannot change the contacts once relationship has been created');
 196       }
 197       else {
 198         // since the BAO function is not std & won't accept just 'id' (aargh) let's
 199         // at least return our BAO here
 200         $values = array();
 201         _civicrm_api3_object_to_array($relation, $values);
 202         $values = array_merge($values, $params);
 203         // and we need to reformat our date fields....
 204         $dateFields = array('start_date', 'end_date');
 205         foreach ($dateFields as $dateField){
 206           $values[$dateField] = CRM_Utils_Date::processDate($values[$dateField]);
 207         }
 208       }
 209     }
 210   }
 211
 212   foreach ($params as $key => $value) {
 213     // ignore empty values or empty arrays etc
 214     if (CRM_Utils_System::isNull($value)) {
 215       continue;
 216     }
 217
 218     switch ($key) {
 219       case 'contact_id_a':
 220       case 'contact_id_b':
 221         if (!CRM_Utils_Rule::integer($value)) {
 222           throw new Exception("contact_id not valid: $value");
 223         }
 224         $dao     = new CRM_Core_DAO();
 225         $qParams = array();
 226         $svq     = $dao->singleValueQuery("SELECT id FROM civicrm_contact WHERE id = $value",
 227           $qParams
 228         );
 229         if (!$svq) {
 230           throw new Exception("Invalid Contact ID: There is no contact record with contact_id = $value.");
 231         }
 232         break;
 233
 234       case 'relationship_type':
 235         foreach ($relationTypes as $relTypId => $relValue) {
 236           if (CRM_Utils_Array::key(ucfirst($value), $relValue)) {
 237             $relationshipTypeId = $relTypId;
 238             break;
 239           }
 240         }
 241
 242         if ($relationshipTypeId) {
 243           if (CRM_Utils_Array::value('relationship_type_id', $values) &&
 244             $relationshipTypeId != $values['relationship_type_id']
 245           ) {
 246             throw new Exception('Mismatched Relationship Type and Relationship Type Id');
 247           }
 248           $values['relationship_type_id'] = $params['relationship_type_id'] = $relationshipTypeId;
 249         }
 250         else {
 251           throw new Exception('Invalid Relationship Type');
 252         }
 253       case 'relationship_type_id':
 254         if ($key == 'relationship_type_id' && !array_key_exists($value, $relationTypes)) {
 255           throw new Exception("$key not a valid: $value");
 256         }
 257
 258         // execute for both relationship_type and relationship_type_id
 259         $relation = $relationTypes[$params['relationship_type_id']];
 260         if (!empty($params['contact_id_a']) && $relation['contact_type_a'] &&
 261           $relation['contact_type_a'] != CRM_Contact_BAO_Contact::getContactType($params['contact_id_a'])
 262         ) {
 263           throw new Exception("Contact ID :{$params['contact_id_a']} is not of contact type {$relation['contact_type_a']}");
 264         }
 265         if (!empty($params['contact_id_b']) && $relation['contact_type_b'] &&
 266           $relation['contact_type_b'] != CRM_Contact_BAO_Contact::getContactType($params['contact_id_b'])
 267         ) {
 268           throw new Exception("Contact ID :{$params['contact_id_b']} is not of contact type {$relation['contact_type_b']}");
 269         }
 270         break;
 271
 272       default:
 273         break;
 274     }
 275   }
 276
 277   if (array_key_exists('note', $params)) {
 278     $values['note'] = $params['note'];
 279   }
 280   _civicrm_api3_custom_format_params($params, $values, 'Relationship');
 281
 282   return array();
 283 }