4 +--------------------------------------------------------------------+
5 | CiviCRM version 4.3 |
6 +--------------------------------------------------------------------+
7 | Copyright CiviCRM LLC (c) 2004-2013 |
8 +--------------------------------------------------------------------+
9 | This file is a part of CiviCRM. |
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. |
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. |
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 +--------------------------------------------------------------------+
30 * File for the CiviCRM APIv3 relationship functions
32 * @package CiviCRM_APIv3
33 * @subpackage API_Relationship
35 * @copyright CiviCRM LLC (c) 2004-2013
36 * @version $Id: Relationship.php 30486 2010-11-02 16:12:09Z shot $
41 * Add or update a relationship
43 * @param array $params input parameters
45 * @example RelationshipCreate.php Std Create example
47 * @return array API Result Array
48 * {@getfields relationship_create}
53 function civicrm_api3_relationship_create($params) {
56 _civicrm_api3_relationship_format_params($params, $values);
59 if (CRM_Utils_Array
::value('id', $params)) {
60 $ids['contactTarget'] = $values['contact_id_b'];
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']);
67 if(!empty($values['contact_id_a'])){
68 $ids['contact'] = $values['contact_id_a'];
70 $relationshipBAO = CRM_Contact_BAO_Relationship
::create($values, $ids);
72 if ($relationshipBAO[1]) {
73 throw new API_Exception('Relationship is not valid');
75 elseif ($relationshipBAO[2]) {
76 throw new API_Exception('Relationship already exists');
78 $id = $relationshipBAO[4][0];
80 _civicrm_api3_object_to_array($relationshipBAO[5][$id], $values[$id]);
81 return civicrm_api3_create_success($values, $params, 'relationship', 'create');
85 * Adjust Metadata for Create action
87 * @param array $params array or parameters determined by getfields
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;
97 * Delete a relationship
99 * @param array $params
101 * @return array API Result Array
102 * {@getfields relationship_delete}
103 * @example RelationshipDelete.php Delete Example
108 function civicrm_api3_relationship_delete($params) {
110 if (!CRM_Utils_Rule
::integer($params['id'])) {
111 return civicrm_api3_create_error('Invalid value for relationship ID');
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');
120 $relationBAO->del($params['id']);
121 return civicrm_api3_create_success('Deleted relationship successfully');
126 * Function to get the relationship
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)
133 * @return Array API Result Array
134 * {@getfields relationship_get}
135 * @example RelationshipGet.php
138 function civicrm_api3_relationship_get($params) {
139 $options = _civicrm_api3_get_options_from_params($params);
141 if (!CRM_Utils_Array
::value('contact_id', $params)) {
142 if(!empty($params['membership_type_id']) && empty($params['relationship_type_id'])) {
143 CRM_Contact_BAO_Relationship
::membershipTypeToRelationshipTypes($params);
145 $relationships = _civicrm_api3_basic_get(_civicrm_api3_get_BAO(__FUNCTION__
), $params, FALSE);
148 $relationships = array();
149 $relationships = CRM_Contact_BAO_Relationship
::getRelationship($params['contact_id'],
150 CRM_Utils_Array
::value('status_id', $params),
152 CRM_Utils_Array
::value('is_count', $options),
153 CRM_Utils_Array
::value('id', $params),
160 //perhaps we should add a 'getcount' but at this stage lets just handle getcount output
161 if($options['is_count']) {
162 return array('count' => $relationships);
164 foreach ($relationships as $relationshipId => $values) {
165 _civicrm_api3_custom_data_get($relationships[$relationshipId], 'Relationship', $relationshipId, NULL, CRM_Utils_Array
::value('relationship_type_id',$values));
167 return civicrm_api3_create_success($relationships, $params);
171 * take the input parameter list as specified in the data model and
172 * convert it into the same format that we use in QF and BAO object
174 * @param array $params Associative array of property name/value
175 * pairs to insert in new contact.
176 * @param array $values The reformatted properties that we can use internally
179 * @return array|CRM_Error
182 function _civicrm_api3_relationship_format_params($params, &$values) {
183 // copy all the relationship fields as is
185 $fields = CRM_Contact_DAO_Relationship
::fields();
186 _civicrm_api3_store_values($fields, $params, $values);
188 $relationTypes = CRM_Core_PseudoConstant
::relationshipType('name');
189 if (CRM_Utils_Array
::value('id', $params)) {
190 $relation = new CRM_Contact_BAO_Relationship();
191 $relation->id
= $params['id'];
192 if (!$relation->find(TRUE)) {
193 throw new Exception('Relationship id is not valid');
196 if ((isset($params['contact_id_a']) && $params['contact_id_a'] != $relation->contact_id_a
) ||
197 (isset($params['contact_id_b']) && $params['contact_id_b'] != $relation->contact_id_b
)
199 throw new Exception('Cannot change the contacts once relationship has been created');
202 // since the BAO function is not std & won't accept just 'id' (aargh) let's
203 // at least return our BAO here
205 _civicrm_api3_object_to_array($relation, $values);
206 $values = array_merge($values, $params);
207 // and we need to reformat our date fields....
208 $dateFields = array('start_date', 'end_date');
209 foreach ($dateFields as $dateField){
210 $values[$dateField] = CRM_Utils_Date
::processDate($values[$dateField]);
216 foreach ($params as $key => $value) {
217 // ignore empty values or empty arrays etc
218 if (CRM_Utils_System
::isNull($value)) {
225 if (!CRM_Utils_Rule
::integer($value)) {
226 throw new Exception("contact_id not valid: $value");
228 $dao = new CRM_Core_DAO();
230 $svq = $dao->singleValueQuery("SELECT id FROM civicrm_contact WHERE id = $value",
234 throw new Exception("Invalid Contact ID: There is no contact record with contact_id = $value.");
238 case 'relationship_type':
239 foreach ($relationTypes as $relTypId => $relValue) {
240 if (CRM_Utils_Array
::key(ucfirst($value), $relValue)) {
241 $relationshipTypeId = $relTypId;
246 if ($relationshipTypeId) {
247 if (CRM_Utils_Array
::value('relationship_type_id', $values) &&
248 $relationshipTypeId != $values['relationship_type_id']
250 throw new Exception('Mismatched Relationship Type and Relationship Type Id');
252 $values['relationship_type_id'] = $params['relationship_type_id'] = $relationshipTypeId;
255 throw new Exception('Invalid Relationship Type');
257 case 'relationship_type_id':
258 if ($key == 'relationship_type_id' && !array_key_exists($value, $relationTypes)) {
259 throw new Exception("$key not a valid: $value");
262 // execute for both relationship_type and relationship_type_id
263 $relation = $relationTypes[$params['relationship_type_id']];
264 if (!empty($params['contact_id_a']) && $relation['contact_type_a'] &&
265 $relation['contact_type_a'] != CRM_Contact_BAO_Contact
::getContactType($params['contact_id_a'])
267 throw new Exception("Contact ID :{$params['contact_id_a']} is not of contact type {$relation['contact_type_a']}");
269 if (!empty($params['contact_id_b']) && $relation['contact_type_b'] &&
270 $relation['contact_type_b'] != CRM_Contact_BAO_Contact
::getContactType($params['contact_id_b'])
272 throw new Exception("Contact ID :{$params['contact_id_b']} is not of contact type {$relation['contact_type_b']}");
281 if (array_key_exists('note', $params)) {
282 $values['note'] = $params['note'];
284 _civicrm_api3_custom_format_params($params, $values, 'Relationship');