Commit | Line | Data |
---|---|---|
6a488035 | 1 | <?php |
6a488035 TO |
2 | /* |
3 | +--------------------------------------------------------------------+ | |
a30c801b | 4 | | Copyright CiviCRM LLC. All rights reserved. | |
6a488035 | 5 | | | |
a30c801b TO |
6 | | This work is published under the GNU AGPLv3 license with some | |
7 | | permitted exceptions and without any warranty. For full license | | |
8 | | and copyright information, see https://civicrm.org/licensing | | |
6a488035 TO |
9 | +--------------------------------------------------------------------+ |
10 | */ | |
11 | ||
12 | /** | |
c28e1768 | 13 | * This api exposes CiviCRM custom field. |
6a488035 TO |
14 | * |
15 | * @package CiviCRM_APIv3 | |
6a488035 TO |
16 | */ |
17 | ||
6a488035 TO |
18 | /** |
19 | * Create a 'custom field' within a custom field group. | |
2e66abf8 | 20 | * |
6a488035 TO |
21 | * We also empty the static var in the getfields |
22 | * function after deletion so that the field is available for us (getfields manages date conversion | |
23 | * among other things | |
24 | * | |
16b10e64 | 25 | * @param array $params |
2e66abf8 | 26 | * Array per getfields metadata. |
6a488035 | 27 | * |
d60f50a8 CW |
28 | * @return array |
29 | * API success array | |
6a488035 TO |
30 | */ |
31 | function civicrm_api3_custom_field_create($params) { | |
32 | ||
1fd57e91 | 33 | // Legacy handling for old way of naming serialized fields |
a7bcb32d CW |
34 | if (!empty($params['html_type'])) { |
35 | if ($params['html_type'] == 'CheckBox' || strpos($params['html_type'], 'Multi-') === 0) { | |
36 | $params['serialize'] = 1; | |
37 | } | |
38 | $params['html_type'] = str_replace(['Multi-Select', 'Select Country', 'Select State/Province'], 'Select', $params['html_type']); | |
1fd57e91 CW |
39 | } |
40 | ||
2e66abf8 | 41 | // Array created for passing options in params. |
6a488035 | 42 | if (isset($params['option_values']) && is_array($params['option_values'])) { |
58eaa092 | 43 | $weight = 0; |
6a488035 | 44 | foreach ($params['option_values'] as $key => $value) { |
58eaa092 CW |
45 | // Translate simple key/value pairs into full-blown option values |
46 | if (!is_array($value)) { | |
cf8f0fff | 47 | $value = [ |
58eaa092 CW |
48 | 'label' => $value, |
49 | 'value' => $key, | |
50 | 'is_active' => 1, | |
51 | 'weight' => $weight, | |
cf8f0fff | 52 | ]; |
58eaa092 CW |
53 | $key = $weight++; |
54 | } | |
6a488035 TO |
55 | $params['option_label'][$key] = $value['label']; |
56 | $params['option_value'][$key] = $value['value']; | |
57 | $params['option_status'][$key] = $value['is_active']; | |
58 | $params['option_weight'][$key] = $value['weight']; | |
59 | } | |
60 | } | |
cf8f0fff | 61 | $values = []; |
6a488035 | 62 | $customField = CRM_Core_BAO_CustomField::create($params); |
6a488035 | 63 | _civicrm_api3_object_to_array_unique_fields($customField, $values[$customField->id]); |
d674c5f8 | 64 | _civicrm_api3_custom_field_flush_static_caches(); |
244bbdd8 | 65 | return civicrm_api3_create_success($values, $params, 'CustomField', $customField); |
6a488035 | 66 | } |
11e09c59 | 67 | |
d674c5f8 | 68 | /** |
2e66abf8 | 69 | * Flush static caches in functions that might have stored available custom fields. |
d674c5f8 | 70 | */ |
9b873358 | 71 | function _civicrm_api3_custom_field_flush_static_caches() { |
65d27ad8 | 72 | if (isset(\Civi::$statics['CRM_Core_BAO_OptionGroup']['titles_by_name'])) { |
73 | unset(\Civi::$statics['CRM_Core_BAO_OptionGroup']['titles_by_name']); | |
74 | } | |
cf8f0fff | 75 | civicrm_api('CustomField', 'getfields', ['version' => 3, 'cache_clear' => 1]); |
d674c5f8 E |
76 | CRM_Core_BAO_UFField::getAvailableFieldsFlat(TRUE); |
77 | } | |
d60f50a8 | 78 | |
11e09c59 | 79 | /** |
0aa0303c | 80 | * Adjust Metadata for Create action. |
1c88e578 | 81 | * |
cf470720 | 82 | * @param array $params |
b081365f | 83 | * Array of parameters determined by getfields. |
6a488035 TO |
84 | */ |
85 | function _civicrm_api3_custom_field_create_spec(&$params) { | |
86 | $params['label']['api.required'] = 1; | |
87 | $params['custom_group_id']['api.required'] = 1; | |
d5841dff | 88 | $params['is_active']['api.default'] = 1; |
cf8f0fff | 89 | $params['option_values'] = [ |
58eaa092 CW |
90 | 'title' => 'Option Values', |
91 | 'description' => "Pass an array of options (value => label) to create this field's option values", | |
cf8f0fff | 92 | ]; |
33533dfe | 93 | $params['data_type']['api.default'] = 'String'; |
4b307b2f | 94 | $params['is_active']['api.default'] = 1; |
6a488035 TO |
95 | } |
96 | ||
97 | /** | |
c28e1768 | 98 | * Use this API to delete an existing custom field. |
6a488035 | 99 | * |
16b10e64 | 100 | * @param array $params |
cf470720 | 101 | * Array id of the field to be deleted. |
77b97be7 EM |
102 | * |
103 | * @return array | |
c23f45d3 | 104 | */ |
6a488035 | 105 | function civicrm_api3_custom_field_delete($params) { |
6a488035 TO |
106 | $field = new CRM_Core_BAO_CustomField(); |
107 | $field->id = $params['id']; | |
108 | $field->find(TRUE); | |
109 | $customFieldDelete = CRM_Core_BAO_CustomField::deleteField($field); | |
cf8f0fff | 110 | civicrm_api('CustomField', 'getfields', ['version' => 3, 'cache_clear' => 1]); |
6a488035 TO |
111 | return $customFieldDelete ? civicrm_api3_create_error('Error while deleting custom field') : civicrm_api3_create_success(); |
112 | } | |
113 | ||
114 | /** | |
115 | * Use this API to get existing custom fields. | |
116 | * | |
cf470720 TO |
117 | * @param array $params |
118 | * Array to search on. | |
77b97be7 EM |
119 | * |
120 | * @return array | |
c23f45d3 | 121 | */ |
6a488035 | 122 | function civicrm_api3_custom_field_get($params) { |
49df88a8 CW |
123 | // Legacy handling for serialize property |
124 | $handleLegacy = (($params['legacy_html_type'] ?? !isset($params['serialize'])) && CRM_Core_BAO_Domain::isDBVersionAtLeast('5.27.alpha1')); | |
125 | if ($handleLegacy && !empty($params['return'])) { | |
126 | if (!is_array($params['return'])) { | |
127 | $params['return'] = explode(',', str_replace(' ', '', $params['return'])); | |
128 | } | |
129 | if (!in_array('serialize', $params['return'])) { | |
1fd57e91 CW |
130 | $params['return'][] = 'serialize'; |
131 | } | |
a7bcb32d CW |
132 | if (!in_array('data_type', $params['return'])) { |
133 | $params['return'][] = 'data_type'; | |
134 | } | |
49df88a8 | 135 | } |
a7bcb32d CW |
136 | $legacyDataTypes = [ |
137 | 'Select State/Province' => 'StateProvince', | |
138 | 'Select Country' => 'Country', | |
139 | ]; | |
49df88a8 CW |
140 | if ($handleLegacy && !empty($params['html_type'])) { |
141 | $serializedTypes = ['CheckBox', 'Multi-Select', 'Multi-Select Country', 'Multi-Select State/Province']; | |
142 | if (is_string($params['html_type'])) { | |
143 | if (strpos($params['html_type'], 'Multi-Select') === 0) { | |
144 | $params['html_type'] = str_replace('Multi-Select', 'Select', $params['html_type']); | |
145 | $params['serialize'] = 1; | |
146 | } | |
147 | elseif (!in_array($params['html_type'], $serializedTypes)) { | |
148 | $params['serialize'] = 0; | |
149 | } | |
a7bcb32d CW |
150 | if (isset($legacyDataTypes[$params['html_type']])) { |
151 | $params['data_type'] = $legacyDataTypes[$params['html_type']]; | |
152 | unset($params['html_type']); | |
153 | } | |
49df88a8 CW |
154 | } |
155 | elseif (is_array($params['html_type']) && !empty($params['html_type']['IN'])) { | |
156 | $excludeNonSerialized = !array_diff($params['html_type']['IN'], $serializedTypes); | |
157 | $onlyNonSerialized = !array_intersect($params['html_type']['IN'], $serializedTypes); | |
158 | $params['html_type']['IN'] = array_map(function($val) { | |
a7bcb32d | 159 | return str_replace(['Multi-Select', 'Select Country', 'Select State/Province'], 'Select', $val); |
49df88a8 CW |
160 | }, $params['html_type']['IN']); |
161 | if ($excludeNonSerialized) { | |
162 | $params['serialize'] = 1; | |
163 | } | |
164 | if ($onlyNonSerialized) { | |
165 | $params['serialize'] = 0; | |
166 | } | |
1fd57e91 CW |
167 | } |
168 | } | |
169 | ||
170 | $results = _civicrm_api3_basic_get(_civicrm_api3_get_BAO(__FUNCTION__), $params); | |
171 | ||
a7bcb32d CW |
172 | if ($handleLegacy && !empty($results['values']) && is_array($results['values'])) { |
173 | foreach ($results['values'] as $id => &$result) { | |
174 | if (!empty($result['html_type'])) { | |
175 | if (in_array($result['data_type'], $legacyDataTypes)) { | |
176 | $result['html_type'] = array_search($result['data_type'], $legacyDataTypes); | |
177 | } | |
f0725b60 | 178 | if (!empty($result['serialize']) && $result['html_type'] !== 'Autocomplete-Select') { |
a7bcb32d CW |
179 | $result['html_type'] = str_replace('Select', 'Multi-Select', $result['html_type']); |
180 | } | |
1fd57e91 CW |
181 | } |
182 | } | |
183 | } | |
184 | ||
185 | return $results; | |
6a488035 TO |
186 | } |
187 | ||
11e09c59 | 188 | /** |
2e66abf8 EM |
189 | * Helper function to validate custom field value. |
190 | * | |
c490a46a | 191 | * @deprecated |
1c88e578 | 192 | * |
cf470720 TO |
193 | * @param string $fieldName |
194 | * Custom field name (eg: custom_8 ). | |
195 | * @param mixed $value | |
196 | * Field value to be validate. | |
197 | * @param array $fieldDetails | |
198 | * Field Details. | |
199 | * @param array $errors | |
200 | * Collect validation errors. | |
77b97be7 | 201 | * |
795492f3 | 202 | * @return array|NULL |
d60f50a8 | 203 | * Validation errors |
6a488035 TO |
204 | * @todo remove this function - not in use but need to review functionality before |
205 | * removing as it might be useful in wrapper layer | |
206 | */ | |
cf8f0fff | 207 | function _civicrm_api3_custom_field_validate_field($fieldName, $value, $fieldDetails, &$errors = []) { |
795492f3 | 208 | return NULL; |
35671d00 | 209 | //see comment block |
6a488035 TO |
210 | if (!$value) { |
211 | return $errors; | |
212 | } | |
213 | ||
214 | $dataType = $fieldDetails['data_type']; | |
215 | $htmlType = $fieldDetails['html_type']; | |
216 | ||
217 | switch ($dataType) { | |
218 | case 'Int': | |
219 | if (!CRM_Utils_Rule::integer($value)) { | |
220 | $errors[$fieldName] = 'Invalid integer value for ' . $fieldName; | |
221 | } | |
222 | break; | |
223 | ||
224 | case 'Float': | |
225 | if (!CRM_Utils_Rule::numeric($value)) { | |
226 | $errors[$fieldName] = 'Invalid numeric value for ' . $fieldName; | |
227 | } | |
228 | break; | |
229 | ||
230 | case 'Money': | |
231 | if (!CRM_Utils_Rule::money($value)) { | |
232 | $errors[$fieldName] = 'Invalid numeric value for ' . $fieldName; | |
233 | } | |
234 | break; | |
235 | ||
236 | case 'Link': | |
237 | if (!CRM_Utils_Rule::url($value)) { | |
238 | $errors[$fieldName] = 'Invalid link for ' . $fieldName; | |
239 | } | |
240 | break; | |
241 | ||
242 | case 'Boolean': | |
243 | if ($value != '1' && $value != '0') { | |
244 | $errors[$fieldName] = 'Invalid boolean (use 1 or 0) value for ' . $fieldName; | |
245 | } | |
246 | break; | |
247 | ||
248 | case 'Country': | |
249 | if (empty($value)) { | |
250 | break; | |
251 | } | |
252 | if ($htmlType != 'Multi-Select Country' && is_array($value)) { | |
253 | $errors[$fieldName] = 'Invalid country for ' . $fieldName; | |
254 | break; | |
255 | } | |
256 | ||
257 | if (!is_array($value)) { | |
cf8f0fff | 258 | $value = [$value]; |
6a488035 TO |
259 | } |
260 | ||
261 | $query = "SELECT count(*) FROM civicrm_country WHERE id IN (" . implode(',', $value) . ")"; | |
262 | if (CRM_Core_DAO::singleValueQuery($query) < count($value)) { | |
263 | $errors[$fieldName] = 'Invalid country(s) for ' . $fieldName; | |
264 | } | |
265 | break; | |
266 | ||
267 | case 'StateProvince': | |
268 | if (empty($value)) { | |
269 | break; | |
270 | } | |
271 | ||
272 | if ($htmlType != 'Multi-Select State/Province' && is_array($value)) { | |
273 | $errors[$fieldName] = 'Invalid State/Province for ' . $fieldName; | |
274 | break; | |
275 | } | |
276 | ||
277 | if (!is_array($value)) { | |
cf8f0fff | 278 | $value = [$value]; |
6a488035 TO |
279 | } |
280 | ||
281 | $query = " | |
1c88e578 | 282 | SELECT count(*) |
6a488035 TO |
283 | FROM civicrm_state_province |
284 | WHERE id IN ('" . implode("','", $value) . "')"; | |
285 | if (CRM_Core_DAO::singleValueQuery($query) < count($value)) { | |
286 | $errors[$fieldName] = 'Invalid State/Province for ' . $fieldName; | |
287 | } | |
288 | break; | |
289 | ||
290 | case 'ContactReference': | |
291 | //FIX ME | |
292 | break; | |
293 | } | |
294 | ||
7c31ae57 SL |
295 | if (in_array($htmlType, ['Select', 'Multi-Select', 'CheckBox', 'Radio']) |
296 | && !isset($errors[$fieldName]) | |
6a488035 | 297 | ) { |
6a488035 TO |
298 | $options = CRM_Core_OptionGroup::valuesByID($fieldDetails['option_group_id']); |
299 | if (!is_array($value)) { | |
cf8f0fff | 300 | $value = [$value]; |
6a488035 TO |
301 | } |
302 | ||
303 | $invalidOptions = array_diff($value, array_keys($options)); | |
304 | if (!empty($invalidOptions)) { | |
305 | $errors[$fieldName] = "Invalid option(s) for field '{$fieldName}': " . implode(',', $invalidOptions); | |
306 | } | |
307 | } | |
308 | ||
309 | return $errors; | |
310 | } | |
311 | ||
5322ae12 | 312 | /** |
2e66abf8 EM |
313 | * CRM-15191 - Hack to ensure the cache gets cleared after updating a custom field. |
314 | * | |
d0997921 | 315 | * @param array $params |
2e66abf8 EM |
316 | * Array per getfields metadata. |
317 | * | |
645ee340 | 318 | * @return array |
5322ae12 CW |
319 | */ |
320 | function civicrm_api3_custom_field_setvalue($params) { | |
321 | require_once 'api/v3/Generic/Setvalue.php'; | |
cf8f0fff | 322 | $result = civicrm_api3_generic_setValue(["entity" => 'CustomField', 'params' => $params]); |
5322ae12 CW |
323 | if (empty($result['is_error'])) { |
324 | CRM_Utils_System::flushCache(); | |
325 | } | |
326 | return $result; | |
327 | } |