Commit | Line | Data |
---|---|---|
6a488035 | 1 | <?php |
6a488035 TO |
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(); | |
6a488035 TO |
58 | |
59 | if (CRM_Utils_Array::value('id', $params)) { | |
6a488035 | 60 | $ids['contactTarget'] = $values['contact_id_b']; |
6a488035 TO |
61 | } |
62 | ||
63 | $values['relationship_type_id'] = $values['relationship_type_id'] . '_a_b'; | |
26dcc9eb | 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 | } | |
6a488035 TO |
70 | $relationshipBAO = CRM_Contact_BAO_Relationship::create($values, $ids); |
71 | ||
72 | if ($relationshipBAO[1]) { | |
26dcc9eb | 73 | throw new API_Exception('Relationship is not valid'); |
6a488035 TO |
74 | } |
75 | elseif ($relationshipBAO[2]) { | |
26dcc9eb | 76 | throw new API_Exception('Relationship already exists'); |
6a488035 | 77 | } |
26dcc9eb | 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'); | |
6a488035 | 82 | } |
11e09c59 TO |
83 | |
84 | /** | |
6a488035 TO |
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 | ||
6a488035 TO |
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) { | |
75638074 | 139 | $options = _civicrm_api3_get_options_from_params($params); |
6a488035 TO |
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, | |
75638074 | 148 | CRM_Utils_Array::value('is_count', $options), |
149 | CRM_Utils_Array::value('id', $params), | |
150 | NULL, | |
151 | NULL, | |
152 | FALSE, | |
153 | $params | |
6a488035 TO |
154 | ); |
155 | } | |
75638074 | 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 | } | |
6a488035 TO |
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 | } | |
6a488035 TO |
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 | |
6a488035 TO |
214 | if (CRM_Utils_System::isNull($value)) { |
215 | continue; | |
216 | } | |
217 | ||
218 | switch ($key) { | |
219 | case 'contact_id_a': | |
220 | case 'contact_id_b': | |
6a488035 TO |
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 | } |