Merge pull request #14266 from seamuslee001/dev_core_369
[civicrm-core.git] / CRM / Core / CodeGen / Specification.php
1 <?php
2
3 /**
4 * Read the schema specification and parse into internal data structures
5 */
6 class CRM_Core_CodeGen_Specification {
7 public $tables;
8 public $database;
9
10 protected $classNames;
11
12 /**
13 * Read and parse.
14 *
15 * @param $schemaPath
16 * @param string $buildVersion
17 * Which version of the schema to build.
18 * @param bool $verbose
19 */
20 public function parse($schemaPath, $buildVersion, $verbose = TRUE) {
21 $this->buildVersion = $buildVersion;
22
23 if ($verbose) {
24 echo "Parsing schema description " . $schemaPath . "\n";
25 }
26 $dbXML = CRM_Core_CodeGen_Util_Xml::parse($schemaPath);
27
28 if ($verbose) {
29 echo "Extracting database information\n";
30 }
31 $this->database = &$this->getDatabase($dbXML);
32
33 $this->classNames = [];
34
35 # TODO: peel DAO-specific stuff out of getTables, and spec reading into its own class
36 if ($verbose) {
37 echo "Extracting table information\n";
38 }
39 $this->tables = $this->getTables($dbXML, $this->database);
40
41 $this->resolveForeignKeys($this->tables, $this->classNames);
42 $this->tables = $this->orderTables($this->tables);
43
44 // add archive tables here
45 foreach ($this->tables as $name => $table) {
46 if ($table['archive'] == 'true') {
47 $name = 'archive_' . $table['name'];
48 $table['name'] = $name;
49 $table['archive'] = 'false';
50 if (isset($table['foreignKey'])) {
51 foreach ($table['foreignKey'] as $fkName => $fkValue) {
52 if ($this->tables[$fkValue['table']]['archive'] == 'true') {
53 $table['foreignKey'][$fkName]['table'] = 'archive_' . $table['foreignKey'][$fkName]['table'];
54 $table['foreignKey'][$fkName]['uniqName']
55 = str_replace('FK_', 'FK_archive_', $table['foreignKey'][$fkName]['uniqName']);
56 }
57 }
58 $archiveTables[$name] = $table;
59 }
60 }
61 }
62 }
63
64 /**
65 * @param $dbXML
66 *
67 * @return array
68 */
69 public function &getDatabase(&$dbXML) {
70 $database = ['name' => trim((string ) $dbXML->name)];
71
72 $attributes = '';
73 $this->checkAndAppend($attributes, $dbXML, 'character_set', 'DEFAULT CHARACTER SET ', '');
74 $this->checkAndAppend($attributes, $dbXML, 'collate', 'COLLATE ', '');
75 $database['attributes'] = $attributes;
76
77 $tableAttributes_modern = $tableAttributes_simple = '';
78 $this->checkAndAppend($tableAttributes_modern, $dbXML, 'table_type', 'ENGINE=', '');
79 $this->checkAndAppend($tableAttributes_simple, $dbXML, 'table_type', 'TYPE=', '');
80 $database['tableAttributes_modern'] = trim($tableAttributes_modern . ' ' . $attributes);
81 $database['tableAttributes_simple'] = trim($tableAttributes_simple);
82
83 $database['comment'] = $this->value('comment', $dbXML, '');
84
85 return $database;
86 }
87
88 /**
89 * @param $dbXML
90 * @param $database
91 *
92 * @return array
93 */
94 public function getTables($dbXML, &$database) {
95 $tables = [];
96 foreach ($dbXML->tables as $tablesXML) {
97 foreach ($tablesXML->table as $tableXML) {
98 if ($this->value('drop', $tableXML, 0) > 0 && version_compare($this->value('drop', $tableXML, 0), $this->buildVersion, '<=')) {
99 continue;
100 }
101
102 if (version_compare($this->value('add', $tableXML, 0), $this->buildVersion, '<=')) {
103 $this->getTable($tableXML, $database, $tables);
104 }
105 }
106 }
107
108 return $tables;
109 }
110
111 /**
112 * @param $tables
113 * @param string $classNames
114 */
115 public function resolveForeignKeys(&$tables, &$classNames) {
116 foreach (array_keys($tables) as $name) {
117 $this->resolveForeignKey($tables, $classNames, $name);
118 }
119 }
120
121 /**
122 * @param $tables
123 * @param string $classNames
124 * @param string $name
125 */
126 public function resolveForeignKey(&$tables, &$classNames, $name) {
127 if (!array_key_exists('foreignKey', $tables[$name])) {
128 return;
129 }
130
131 foreach (array_keys($tables[$name]['foreignKey']) as $fkey) {
132 $ftable = $tables[$name]['foreignKey'][$fkey]['table'];
133 if (!array_key_exists($ftable, $classNames)) {
134 echo "$ftable is not a valid foreign key table in $name\n";
135 continue;
136 }
137 $tables[$name]['foreignKey'][$fkey]['className'] = $classNames[$ftable];
138 $tables[$name]['foreignKey'][$fkey]['fileName'] = str_replace('_', '/', $classNames[$ftable]) . '.php';
139 $tables[$name]['fields'][$fkey]['FKClassName'] = $classNames[$ftable];
140 }
141 }
142
143 /**
144 * @param $tables
145 *
146 * @return array
147 */
148 public function orderTables(&$tables) {
149 $ordered = [];
150
151 while (!empty($tables)) {
152 foreach (array_keys($tables) as $name) {
153 if ($this->validTable($tables, $ordered, $name)) {
154 $ordered[$name] = $tables[$name];
155 unset($tables[$name]);
156 }
157 }
158 }
159 return $ordered;
160 }
161
162 /**
163 * @param $tables
164 * @param int $valid
165 * @param string $name
166 *
167 * @return bool
168 */
169 public function validTable(&$tables, &$valid, $name) {
170 if (!array_key_exists('foreignKey', $tables[$name])) {
171 return TRUE;
172 }
173
174 foreach (array_keys($tables[$name]['foreignKey']) as $fkey) {
175 $ftable = $tables[$name]['foreignKey'][$fkey]['table'];
176 if (!array_key_exists($ftable, $valid) && $ftable !== $name) {
177 return FALSE;
178 }
179 }
180 return TRUE;
181 }
182
183 /**
184 * @param $tableXML
185 * @param $database
186 * @param $tables
187 */
188 public function getTable($tableXML, &$database, &$tables) {
189 $name = trim((string ) $tableXML->name);
190 $klass = trim((string ) $tableXML->class);
191 $base = $this->value('base', $tableXML);
192 $sourceFile = "xml/schema/{$base}/{$klass}.xml";
193 $daoPath = "{$base}/DAO/";
194 $baoPath = __DIR__ . '/../../../' . str_replace(' ', '', "{$base}/BAO/");
195 $pre = str_replace('/', '_', $daoPath);
196 $this->classNames[$name] = $pre . $klass;
197
198 $localizable = FALSE;
199 foreach ($tableXML->field as $fieldXML) {
200 if ($fieldXML->localizable) {
201 $localizable = TRUE;
202 break;
203 }
204 }
205
206 $table = [
207 'name' => $name,
208 'base' => $daoPath,
209 'sourceFile' => $sourceFile,
210 'fileName' => $klass . '.php',
211 'objectName' => $klass,
212 'labelName' => substr($name, 8),
213 'className' => $this->classNames[$name],
214 'bao' => (file_exists($baoPath . $klass . '.php') ? str_replace('DAO', 'BAO', $this->classNames[$name]) : $this->classNames[$name]),
215 'entity' => $klass,
216 'attributes_simple' => trim($database['tableAttributes_simple']),
217 'attributes_modern' => trim($database['tableAttributes_modern']),
218 'comment' => $this->value('comment', $tableXML),
219 'localizable' => $localizable,
220 'log' => $this->value('log', $tableXML, 'false'),
221 'archive' => $this->value('archive', $tableXML, 'false'),
222 ];
223
224 $fields = [];
225 foreach ($tableXML->field as $fieldXML) {
226 if ($this->value('drop', $fieldXML, 0) > 0 && version_compare($this->value('drop', $fieldXML, 0), $this->buildVersion, '<=')) {
227 continue;
228 }
229
230 if (version_compare($this->value('add', $fieldXML, 0), $this->buildVersion, '<=')) {
231 $this->getField($fieldXML, $fields);
232 }
233 }
234
235 $table['fields'] = &$fields;
236
237 if ($this->value('primaryKey', $tableXML)) {
238 $this->getPrimaryKey($tableXML->primaryKey, $fields, $table);
239 }
240
241 if ($this->value('index', $tableXML)) {
242 $index = [];
243 foreach ($tableXML->index as $indexXML) {
244 if ($this->value('drop', $indexXML, 0) > 0 && version_compare($this->value('drop', $indexXML, 0), $this->buildVersion, '<=')) {
245 continue;
246 }
247
248 $this->getIndex($indexXML, $fields, $index);
249 }
250 CRM_Core_BAO_SchemaHandler::addIndexSignature($name, $index);
251 $table['index'] = &$index;
252 }
253
254 if ($this->value('foreignKey', $tableXML)) {
255 $foreign = [];
256 foreach ($tableXML->foreignKey as $foreignXML) {
257
258 if ($this->value('drop', $foreignXML, 0) > 0 && version_compare($this->value('drop', $foreignXML, 0), $this->buildVersion, '<=')) {
259 continue;
260 }
261 if (version_compare($this->value('add', $foreignXML, 0), $this->buildVersion, '<=')) {
262 $this->getForeignKey($foreignXML, $fields, $foreign, $name);
263 }
264 }
265 $table['foreignKey'] = &$foreign;
266 }
267
268 if ($this->value('dynamicForeignKey', $tableXML)) {
269 $dynamicForeign = [];
270 foreach ($tableXML->dynamicForeignKey as $foreignXML) {
271 if ($this->value('drop', $foreignXML, 0) > 0 && version_compare($this->value('drop', $foreignXML, 0), $this->buildVersion, '<=')) {
272 continue;
273 }
274 if (version_compare($this->value('add', $foreignXML, 0), $this->buildVersion, '<=')) {
275 $this->getDynamicForeignKey($foreignXML, $dynamicForeign, $name);
276 }
277 }
278 $table['dynamicForeignKey'] = $dynamicForeign;
279 }
280
281 $tables[$name] = &$table;
282 }
283
284 /**
285 * @param $fieldXML
286 * @param $fields
287 */
288 public function getField(&$fieldXML, &$fields) {
289 $name = trim((string ) $fieldXML->name);
290 $field = ['name' => $name, 'localizable' => ((bool) $fieldXML->localizable) ? 1 : 0];
291 $type = (string ) $fieldXML->type;
292 switch ($type) {
293 case 'varchar':
294 case 'char':
295 $field['length'] = (int) $fieldXML->length;
296 $field['sqlType'] = "$type({$field['length']})";
297 $field['phpType'] = 'string';
298 $field['crmType'] = 'CRM_Utils_Type::T_STRING';
299 $field['size'] = $this->getSize($fieldXML);
300 break;
301
302 case 'text':
303 $field['sqlType'] = $field['phpType'] = $type;
304 $field['crmType'] = 'CRM_Utils_Type::T_' . strtoupper($type);
305 // CRM-13497 see fixme below
306 $field['rows'] = isset($fieldXML->html) ? $this->value('rows', $fieldXML->html) : NULL;
307 $field['cols'] = isset($fieldXML->html) ? $this->value('cols', $fieldXML->html) : NULL;
308 break;
309
310 break;
311
312 case 'datetime':
313 $field['sqlType'] = $field['phpType'] = $type;
314 $field['crmType'] = 'CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME';
315 break;
316
317 case 'boolean':
318 // need this case since some versions of mysql do not have boolean as a valid column type and hence it
319 // is changed to tinyint. hopefully after 2 yrs this case can be removed.
320 $field['sqlType'] = 'tinyint';
321 $field['phpType'] = $type;
322 $field['crmType'] = 'CRM_Utils_Type::T_' . strtoupper($type);
323 break;
324
325 case 'decimal':
326 $length = $fieldXML->length ? $fieldXML->length : '20,2';
327 $field['sqlType'] = 'decimal(' . $length . ')';
328 $field['phpType'] = 'float';
329 $field['crmType'] = 'CRM_Utils_Type::T_MONEY';
330 $field['precision'] = $length;
331 break;
332
333 case 'float':
334 $field['sqlType'] = 'double';
335 $field['phpType'] = 'float';
336 $field['crmType'] = 'CRM_Utils_Type::T_FLOAT';
337 break;
338
339 default:
340 $field['phpType'] = $this->value('phpType', $fieldXML, $type);
341 $field['sqlType'] = $type;
342 if ($type == 'int unsigned') {
343 $field['crmType'] = 'CRM_Utils_Type::T_INT';
344 }
345 else {
346 $field['crmType'] = $this->value('crmType', $fieldXML, 'CRM_Utils_Type::T_' . strtoupper($type));
347 }
348 break;
349 }
350
351 $field['required'] = $this->value('required', $fieldXML);
352 $field['collate'] = $this->value('collate', $fieldXML);
353 $field['comment'] = $this->value('comment', $fieldXML);
354 $field['default'] = $this->value('default', $fieldXML);
355 $field['import'] = $this->value('import', $fieldXML);
356 if ($this->value('export', $fieldXML)) {
357 $field['export'] = $this->value('export', $fieldXML);
358 }
359 else {
360 $field['export'] = $this->value('import', $fieldXML);
361 }
362 $field['rule'] = $this->value('rule', $fieldXML);
363 $field['title'] = $this->value('title', $fieldXML);
364 if (!$field['title']) {
365 $field['title'] = $this->composeTitle($name);
366 }
367 $field['headerPattern'] = $this->value('headerPattern', $fieldXML);
368 $field['dataPattern'] = $this->value('dataPattern', $fieldXML);
369 $field['uniqueName'] = $this->value('uniqueName', $fieldXML);
370 $field['serialize'] = $this->value('serialize', $fieldXML);
371 $field['html'] = $this->value('html', $fieldXML);
372 if (!empty($field['html'])) {
373 $validOptions = [
374 'type',
375 'formatType',
376 'label',
377 /* Fixme: prior to CRM-13497 these were in a flat structure
378 // CRM-13497 moved them to be nested within 'html' but there's no point
379 // making that change in the DAOs right now since we are in the process of
380 // moving to docrtine anyway.
381 // So translating from nested xml back to flat structure for now.
382 'rows',
383 'cols',
384 'size', */
385 ];
386 $field['html'] = [];
387 foreach ($validOptions as $htmlOption) {
388 if (!empty($fieldXML->html->$htmlOption)) {
389 $field['html'][$htmlOption] = $this->value($htmlOption, $fieldXML->html);
390 }
391 }
392 }
393
394 // in multilingual context popup, we need extra information to create appropriate widget
395 if ($fieldXML->localizable) {
396 if (isset($fieldXML->html)) {
397 $field['widget'] = (array) $fieldXML->html;
398 }
399 else {
400 // default
401 $field['widget'] = ['type' => 'Text'];
402 }
403 if (isset($fieldXML->required)) {
404 $field['widget']['required'] = $this->value('required', $fieldXML);
405 }
406 }
407 if (isset($fieldXML->localize_context)) {
408 $field['localize_context'] = $fieldXML->localize_context;
409 }
410 $field['pseudoconstant'] = $this->value('pseudoconstant', $fieldXML);
411 if (!empty($field['pseudoconstant'])) {
412 //ok this is a bit long-winded but it gets there & is consistent with above approach
413 $field['pseudoconstant'] = [];
414 $validOptions = [
415 // Fields can specify EITHER optionGroupName OR table, not both
416 // (since declaring optionGroupName means we are using the civicrm_option_value table)
417 'optionGroupName',
418 'table',
419 // If table is specified, keyColumn and labelColumn are also required
420 'keyColumn',
421 'labelColumn',
422 // Non-translated machine name for programmatic lookup. Defaults to 'name' if that column exists
423 'nameColumn',
424 // Where clause snippet (will be joined to the rest of the query with AND operator)
425 'condition',
426 // callback function incase of static arrays
427 'callback',
428 // Path to options edit form
429 'optionEditPath',
430 ];
431 foreach ($validOptions as $pseudoOption) {
432 if (!empty($fieldXML->pseudoconstant->$pseudoOption)) {
433 $field['pseudoconstant'][$pseudoOption] = $this->value($pseudoOption, $fieldXML->pseudoconstant);
434 }
435 }
436 if (!isset($field['pseudoconstant']['optionEditPath']) && !empty($field['pseudoconstant']['optionGroupName'])) {
437 $field['pseudoconstant']['optionEditPath'] = 'civicrm/admin/options/' . $field['pseudoconstant']['optionGroupName'];
438 }
439 // For now, fields that have option lists that are not in the db can simply
440 // declare an empty pseudoconstant tag and we'll add this placeholder.
441 // That field's BAO::buildOptions fn will need to be responsible for generating the option list
442 if (empty($field['pseudoconstant'])) {
443 $field['pseudoconstant'] = 'not in database';
444 }
445 }
446 $fields[$name] = &$field;
447 }
448
449 /**
450 * @param string $name
451 *
452 * @return string
453 */
454 public function composeTitle($name) {
455 $names = explode('_', strtolower($name));
456 $title = '';
457 for ($i = 0; $i < count($names); $i++) {
458 if ($names[$i] === 'id' || $names[$i] === 'is') {
459 // id's do not get titles
460 return NULL;
461 }
462
463 if ($names[$i] === 'im') {
464 $names[$i] = 'IM';
465 }
466 else {
467 $names[$i] = ucfirst(trim($names[$i]));
468 }
469
470 $title = $title . ' ' . $names[$i];
471 }
472 return trim($title);
473 }
474
475 /**
476 * @param object $primaryXML
477 * @param array $fields
478 * @param array $table
479 */
480 public function getPrimaryKey(&$primaryXML, &$fields, &$table) {
481 $name = trim((string ) $primaryXML->name);
482
483 // set the autoincrement property of the field
484 $auto = $this->value('autoincrement', $primaryXML);
485 if (isset($fields[$name])) {
486 $fields[$name]['autoincrement'] = $auto;
487 }
488 $fields[$name]['autoincrement'] = $auto;
489 $primaryKey = [
490 'name' => $name,
491 'autoincrement' => $auto,
492 ];
493
494 // populate fields
495 foreach ($primaryXML->fieldName as $v) {
496 $fieldName = (string) ($v);
497 $length = (string) ($v['length']);
498 if (strlen($length) > 0) {
499 $fieldName = "$fieldName($length)";
500 }
501 $primaryKey['field'][] = $fieldName;
502 }
503
504 // when field array is empty set it to the name of the primary key.
505 if (empty($primaryKey['field'])) {
506 $primaryKey['field'][] = $name;
507 }
508
509 // all fieldnames have to be defined and should exist in schema.
510 foreach ($primaryKey['field'] as $fieldName) {
511 if (!$fieldName) {
512 echo "Invalid field defination for index $name\n";
513 return;
514 }
515 $parenOffset = strpos($fieldName, '(');
516 if ($parenOffset > 0) {
517 $fieldName = substr($fieldName, 0, $parenOffset);
518 }
519 if (!array_key_exists($fieldName, $fields)) {
520 echo "Table does not contain $fieldName\n";
521 print_r($fields);
522 exit();
523 }
524 }
525
526 $table['primaryKey'] = &$primaryKey;
527 }
528
529 /**
530 * @param $indexXML
531 * @param $fields
532 * @param $indices
533 */
534 public function getIndex(&$indexXML, &$fields, &$indices) {
535 //echo "\n\n*******************************************************\n";
536 //echo "entering getIndex\n";
537
538 $index = [];
539 // empty index name is fine
540 $indexName = trim((string) $indexXML->name);
541 $index['name'] = $indexName;
542 $index['field'] = [];
543
544 // populate fields
545 foreach ($indexXML->fieldName as $v) {
546 $fieldName = (string) ($v);
547 $length = (string) ($v['length']);
548 if (strlen($length) > 0) {
549 $fieldName = "$fieldName($length)";
550 }
551 $index['field'][] = $fieldName;
552 }
553
554 $index['localizable'] = FALSE;
555 foreach ($index['field'] as $fieldName) {
556 if (isset($fields[$fieldName]) and $fields[$fieldName]['localizable']) {
557 $index['localizable'] = TRUE;
558 break;
559 }
560 }
561
562 // check for unique index
563 if ($this->value('unique', $indexXML)) {
564 $index['unique'] = TRUE;
565 }
566
567 // field array cannot be empty
568 if (empty($index['field'])) {
569 echo "No fields defined for index $indexName\n";
570 return;
571 }
572
573 // all fieldnames have to be defined and should exist in schema.
574 foreach ($index['field'] as $fieldName) {
575 if (!$fieldName) {
576 echo "Invalid field defination for index $indexName\n";
577 return;
578 }
579 $parenOffset = strpos($fieldName, '(');
580 if ($parenOffset > 0) {
581 $fieldName = substr($fieldName, 0, $parenOffset);
582 }
583 if (!array_key_exists($fieldName, $fields)) {
584 echo "Table does not contain $fieldName\n";
585 print_r($fields);
586 exit();
587 }
588 }
589 $indices[$indexName] = &$index;
590 }
591
592 /**
593 * @param $foreignXML
594 * @param $fields
595 * @param $foreignKeys
596 * @param string $currentTableName
597 */
598 public function getForeignKey(&$foreignXML, &$fields, &$foreignKeys, &$currentTableName) {
599 $name = trim((string ) $foreignXML->name);
600
601 /** need to make sure there is a field of type name */
602 if (!array_key_exists($name, $fields)) {
603 echo "foreign $name in $currentTableName does not have a field definition, ignoring\n";
604 return;
605 }
606
607 /** need to check for existence of table and key **/
608 $table = trim($this->value('table', $foreignXML));
609 $foreignKey = [
610 'name' => $name,
611 'table' => $table,
612 'uniqName' => "FK_{$currentTableName}_{$name}",
613 'key' => trim($this->value('key', $foreignXML)),
614 'import' => $this->value('import', $foreignXML, FALSE),
615 'export' => $this->value('import', $foreignXML, FALSE),
616 // we do this matching in a separate phase (resolveForeignKeys)
617 'className' => NULL,
618 'onDelete' => $this->value('onDelete', $foreignXML, FALSE),
619 ];
620 $foreignKeys[$name] = &$foreignKey;
621 }
622
623 /**
624 * @param $foreignXML
625 * @param $dynamicForeignKeys
626 */
627 public function getDynamicForeignKey(&$foreignXML, &$dynamicForeignKeys) {
628 $foreignKey = [
629 'idColumn' => trim($foreignXML->idColumn),
630 'typeColumn' => trim($foreignXML->typeColumn),
631 'key' => trim($this->value('key', $foreignXML)),
632 ];
633 $dynamicForeignKeys[] = $foreignKey;
634 }
635
636 /**
637 * @param $key
638 * @param $object
639 * @param null $default
640 *
641 * @return null|string
642 */
643 protected function value($key, &$object, $default = NULL) {
644 if (isset($object->$key)) {
645 return (string ) $object->$key;
646 }
647 return $default;
648 }
649
650 /**
651 * @param $attributes
652 * @param $object
653 * @param string $name
654 * @param null $pre
655 * @param null $post
656 */
657 protected function checkAndAppend(&$attributes, &$object, $name, $pre = NULL, $post = NULL) {
658 if (!isset($object->$name)) {
659 return;
660 }
661
662 $value = $pre . trim($object->$name) . $post;
663 $this->append($attributes, ' ', trim($value));
664 }
665
666 /**
667 * @param $str
668 * @param $delim
669 * @param $name
670 */
671 protected function append(&$str, $delim, $name) {
672 if (empty($name)) {
673 return;
674 }
675
676 if (is_array($name)) {
677 foreach ($name as $n) {
678 if (empty($n)) {
679 continue;
680 }
681 if (empty($str)) {
682 $str = $n;
683 }
684 else {
685 $str .= $delim . $n;
686 }
687 }
688 }
689 else {
690 if (empty($str)) {
691 $str = $name;
692 }
693 else {
694 $str .= $delim . $name;
695 }
696 }
697 }
698
699 /**
700 * Sets the size property of a textfield.
701 *
702 * @param string $fieldXML
703 *
704 * @return null|string
705 */
706 protected function getSize($fieldXML) {
707 // Extract from <size> tag if supplied
708 if (!empty($fieldXML->html) && $this->value('size', $fieldXML->html)) {
709 return $this->value('size', $fieldXML->html);
710 }
711 // Infer from <length> tag if <size> was not explicitly set or was invalid
712 // This map is slightly different from CRM_Core_Form_Renderer::$_sizeMapper
713 // Because we usually want fields to render as smaller than their maxlength
714 $sizes = [
715 2 => 'TWO',
716 4 => 'FOUR',
717 6 => 'SIX',
718 8 => 'EIGHT',
719 16 => 'TWELVE',
720 32 => 'MEDIUM',
721 64 => 'BIG',
722 ];
723 foreach ($sizes as $length => $name) {
724 if ($fieldXML->length <= $length) {
725 return "CRM_Utils_Type::$name";
726 }
727 }
728 return 'CRM_Utils_Type::HUGE';
729 }
730
731 }