4 +--------------------------------------------------------------------+
5 | Copyright CiviCRM LLC. All rights reserved. |
7 | This work is published under the GNU AGPLv3 license with some |
8 | permitted exceptions and without any warranty. For full license |
9 | and copyright information, see https://civicrm.org/licensing |
10 +--------------------------------------------------------------------+
16 * @copyright CiviCRM LLC https://civicrm.org/licensing
18 class CRM_Core_DAO_AllCoreTables
{
20 private static $tables = NULL;
21 private static $daoToClass = NULL;
22 private static $entityTypes = NULL;
29 public static function init($fresh = FALSE) {
31 if ($init && !$fresh) {
34 Civi
::$statics[__CLASS__
] = [];
36 $file = preg_replace('/\.php$/', '.data.php', __FILE__
);
37 $entityTypes = require $file;
38 CRM_Utils_Hook
::entityTypes($entityTypes);
40 self
::$entityTypes = [];
42 self
::$daoToClass = [];
43 foreach ($entityTypes as $entityType) {
44 self
::registerEntityType(
48 $entityType['fields_callback'] ??
NULL,
49 $entityType['links_callback'] ??
NULL
57 * (Quasi-Private) Do not call externally (except for unit-testing)
59 * @param string $daoName
60 * @param string $className
61 * @param string $tableName
62 * @param string $fields_callback
63 * @param string $links_callback
65 public static function registerEntityType($daoName, $className, $tableName, $fields_callback = NULL, $links_callback = NULL) {
66 self
::$daoToClass[$daoName] = $className;
67 self
::$tables[$tableName] = $className;
68 self
::$entityTypes[$className] = [
70 'class' => $className,
71 'table' => $tableName,
72 'fields_callback' => $fields_callback,
73 'links_callback' => $links_callback,
79 * Ex: $result['CRM_Contact_DAO_Contact']['table'] == 'civicrm_contact';
81 public static function get() {
83 return self
::$entityTypes;
88 * List of SQL table names.
90 public static function tables() {
99 public static function indices($localize = TRUE) {
102 foreach (self
::$daoToClass as $class) {
103 if (is_callable([$class, 'indices'])) {
104 $indices[$class::getTableName()] = $class::indices($localize);
111 * Modify indices to account for localization options.
113 * @param string $class DAO class
114 * @param array $originalIndices index definitions before localization
117 * index definitions after localization
119 public static function multilingualize($class, $originalIndices) {
120 $locales = CRM_Core_I18n
::getMultilingual();
122 return $originalIndices;
124 $classFields = $class::fields();
127 foreach ($originalIndices as $index) {
128 if ($index['localizable']) {
129 foreach ($locales as $locale) {
130 $localIndex = $index;
131 $localIndex['name'] .= "_" . $locale;
133 foreach ($localIndex['field'] as $field) {
134 $baseField = explode('(', $field);
135 if ($classFields[$baseField[0]]['localizable']) {
136 // field name may have eg (3) at end for prefix length
137 // last_name => last_name_fr_FR
138 // last_name(3) => last_name_fr_FR(3)
139 $fields[] = preg_replace('/^([^(]+)(\(\d+\)|)$/', '${1}_' . $locale . '${2}', $field);
145 $localIndex['field'] = $fields;
146 $finalIndices[$localIndex['name']] = $localIndex;
150 $finalIndices[$index['name']] = $index;
153 CRM_Core_BAO_SchemaHandler
::addIndexSignature(self
::getTableForClass($class), $finalIndices);
154 return $finalIndices;
159 * Mapping from brief-names to class-names.
160 * Ex: $result['Contact'] == 'CRM_Contact_DAO_Contact'.
162 public static function daoToClass() {
164 return self
::$daoToClass;
169 * Mapping from table-names to class-names.
170 * Ex: $result['civicrm_contact'] == 'CRM_Contact_DAO_Contact'.
172 public static function getCoreTables() {
173 return self
::tables();
177 * Determine whether $tableName is a core table.
179 * @param string $tableName
182 public static function isCoreTable($tableName) {
183 return array_key_exists($tableName, self
::tables());
187 * Get the DAO for a BAO class.
189 * @param string $baoName
191 * @return string|CRM_Core_DAO
193 public static function getCanonicalClassName($baoName) {
194 return str_replace('_BAO_', '_DAO_', $baoName);
198 * Get the BAO for a DAO class.
200 * @param string $daoName
202 * @return string|CRM_Core_DAO
204 public static function getBAOClassName($daoName) {
205 $baoName = str_replace('_DAO_', '_BAO_', $daoName);
206 return class_exists($baoName) ?
$baoName : $daoName;
210 * Convert possibly underscore separated words to camel case with special handling for 'UF'
211 * e.g membership_payment returns MembershipPayment
213 * @param string $name
214 * @param bool $legacyV3
217 public static function convertEntityNameToCamel(string $name, $legacyV3 = FALSE): string {
218 // This map only applies to APIv3
225 if ($legacyV3 && isset($map[$name])) {
229 $fragments = explode('_', $name);
230 foreach ($fragments as & $fragment) {
231 $fragment = ucfirst($fragment);
232 // Special case: UFGroup, UFJoin, UFMatch, UFField (if passed in without underscores)
233 if (strpos($fragment, 'Uf') === 0 && strlen($name) > 2) {
234 $fragment = 'UF' . ucfirst(substr($fragment, 2));
237 // Special case: UFGroup, UFJoin, UFMatch, UFField (if passed in underscore-separated)
238 if ($fragments[0] === 'Uf') {
239 $fragments[0] = 'UF';
241 return implode('', $fragments);
245 * Convert CamelCase to snake_case, with special handling for some entity names.
247 * Eg. Activity returns activity
248 * UFGroup returns uf_group
249 * OptionValue returns option_value
251 * @param string $name
255 public static function convertEntityNameToLower(string $name): string {
256 if ($name === strtolower($name)) {
259 if ($name === 'PCP' ||
$name === 'IM' ||
$name === 'ACL') {
260 return strtolower($name);
262 return strtolower(ltrim(str_replace('U_F',
264 // That's CamelCase, beside an odd UFCamel that is expected as uf_camel
265 preg_replace('/(?=[A-Z])/', '_$0', $name)
270 * Get a list of all DAO classes.
273 * List of class names.
275 public static function getClasses() {
276 return array_values(self
::daoToClass());
280 * Get the classname for the table.
282 * @param string $tableName
283 * @return string|CRM_Core_DAO|NULL
285 public static function getClassForTable($tableName) {
286 //CRM-19677: on multilingual setup, trim locale from $tableName to fetch class name
287 if (CRM_Core_I18n
::isMultilingual()) {
289 $tableName = str_replace($dbLocale, '', $tableName);
291 return CRM_Utils_Array
::value($tableName, self
::tables());
295 * Given a brief-name, determine the full class-name.
297 * @param string $daoName
299 * @return string|CRM_Core_DAO|NULL
300 * Ex: 'CRM_Contact_DAO_Contact'.
302 public static function getFullName($daoName) {
303 return CRM_Utils_Array
::value($daoName, self
::daoToClass());
307 * Given a full class-name, determine the brief-name.
309 * @param string $className
310 * Ex: 'CRM_Contact_DAO_Contact'.
311 * @return string|NULL
314 public static function getBriefName($className) {
315 $className = self
::getCanonicalClassName($className);
316 return array_search($className, self
::daoToClass(), TRUE) ?
: NULL;
320 * @param string $className DAO or BAO name
321 * @return string|FALSE SQL table name
323 public static function getTableForClass($className) {
324 return array_search(self
::getCanonicalClassName($className),
329 * Convert the entity name into a table name.
331 * @param string $entityBriefName
333 * @return FALSE|string
335 public static function getTableForEntityName($entityBriefName) {
336 return self
::getTableForClass(self
::getFullName($entityBriefName));
340 * Reinitialise cache.
344 public static function reinitializeCache($fresh = FALSE) {
349 * (Quasi-Private) Do not call externally. For use by DAOs.
352 * Ex: 'CRM_Core_DAO_Address'.
353 * @param string $labelName
355 * @param bool $prefix
356 * @param array $foreignDAOs
359 public static function getExports($dao, $labelName, $prefix, $foreignDAOs) {
360 // Bug-level compatibility -- or sane behavior?
361 $cacheKey = $dao . ':export';
362 // $cacheKey = $dao . ':' . ($prefix ? 'export-prefix' : 'export');
364 if (!isset(Civi
::$statics[__CLASS__
][$cacheKey])) {
366 $fields = $dao::fields();
368 foreach ($fields as $name => $field) {
369 if (!empty($field['export'])) {
371 $exports[$labelName] = & $fields[$name];
374 $exports[$name] = & $fields[$name];
379 foreach ($foreignDAOs as $foreignDAO) {
380 $exports = array_merge($exports, $foreignDAO::export(TRUE));
383 Civi
::$statics[__CLASS__
][$cacheKey] = $exports;
385 return Civi
::$statics[__CLASS__
][$cacheKey];
389 * (Quasi-Private) Do not call externally. For use by DAOs.
392 * Ex: 'CRM_Core_DAO_Address'.
393 * @param string $labelName
395 * @param bool $prefix
396 * @param array $foreignDAOs
399 public static function getImports($dao, $labelName, $prefix, $foreignDAOs) {
400 // Bug-level compatibility -- or sane behavior?
401 $cacheKey = $dao . ':import';
402 // $cacheKey = $dao . ':' . ($prefix ? 'import-prefix' : 'import');
404 if (!isset(Civi
::$statics[__CLASS__
][$cacheKey])) {
406 $fields = $dao::fields();
408 foreach ($fields as $name => $field) {
409 if (!empty($field['import'])) {
411 $imports[$labelName] = & $fields[$name];
414 $imports[$name] = & $fields[$name];
419 foreach ($foreignDAOs as $foreignDAO) {
420 $imports = array_merge($imports, $foreignDAO::import(TRUE));
423 Civi
::$statics[__CLASS__
][$cacheKey] = $imports;
425 return Civi
::$statics[__CLASS__
][$cacheKey];
429 * (Quasi-Private) Do not call externally. For use by DAOs.
431 * Apply any third-party alterations to the `fields()`.
433 * @param string $className
434 * @param string $event
435 * @param mixed $values
437 public static function invoke($className, $event, &$values) {
439 if (isset(self
::$entityTypes[$className][$event])) {
440 foreach (self
::$entityTypes[$className][$event] as $filter) {
441 $args = [$className, &$values];
442 \Civi\Core\Resolver
::singleton()->call($filter, $args);