namespace Civi\Search;
+use CRM_Search_ExtensionUtil as E;
+
/**
* Class Admin
* @package Civi\Search
'joins' => self::getJoins(array_column($schema, NULL, 'name')),
'operators' => \CRM_Utils_Array::makeNonAssociative(self::getOperators()),
'functions' => \CRM_Api4_Page_Api4Explorer::getSqlFunctions(),
- 'displayTypes' => Display::getDisplayTypes(['name', 'label', 'description', 'icon']),
+ 'displayTypes' => Display::getDisplayTypes(['id', 'name', 'label', 'description', 'icon']),
+ 'styles' => \CRM_Utils_Array::makeNonAssociative(self::getStyles()),
+ 'afformEnabled' => (bool) \CRM_Utils_Array::findAll(
+ \CRM_Extension_System::singleton()->getMapper()->getActiveModuleFiles(),
+ ['fullName' => 'org.civicrm.afform']
+ ),
+ 'afformAdminEnabled' => (bool) \CRM_Utils_Array::findAll(
+ \CRM_Extension_System::singleton()->getMapper()->getActiveModuleFiles(),
+ ['fullName' => 'org.civicrm.afform_admin']
+ ),
];
}
'<' => '<',
'>=' => '≥',
'<=' => '≤',
- 'CONTAINS' => ts('Contains'),
- 'IN' => ts('Is One Of'),
- 'NOT IN' => ts('Not One Of'),
- 'LIKE' => ts('Is Like'),
- 'NOT LIKE' => ts('Not Like'),
- 'BETWEEN' => ts('Is Between'),
- 'NOT BETWEEN' => ts('Not Between'),
- 'IS NULL' => ts('Is Null'),
- 'IS NOT NULL' => ts('Not Null'),
+ 'CONTAINS' => E::ts('Contains'),
+ 'IN' => E::ts('Is One Of'),
+ 'NOT IN' => E::ts('Not One Of'),
+ 'LIKE' => E::ts('Is Like'),
+ 'NOT LIKE' => E::ts('Not Like'),
+ 'BETWEEN' => E::ts('Is Between'),
+ 'NOT BETWEEN' => E::ts('Not Between'),
+ 'IS EMPTY' => E::ts('Is Empty'),
+ 'IS NOT EMPTY' => E::ts('Not Empty'),
+ ];
+ }
+
+ /**
+ * @return string[]
+ */
+ public static function getStyles():array {
+ return [
+ 'default' => E::ts('Default'),
+ 'primary' => E::ts('Primary'),
+ 'success' => E::ts('Success'),
+ 'info' => E::ts('Info'),
+ 'warning' => E::ts('Warning'),
+ 'danger' => E::ts('Danger'),
];
}
public static function getSchema() {
$schema = [];
$entities = \Civi\Api4\Entity::get()
- ->addSelect('name', 'title', 'type', 'title_plural', 'description', 'icon', 'paths', 'dao', 'bridge', 'ui_join_filters')
+ ->addSelect('name', 'title', 'type', 'title_plural', 'description', 'label_field', 'icon', 'paths', 'dao', 'bridge', 'ui_join_filters')
->addWhere('searchable', '=', TRUE)
->addOrderBy('title_plural')
->setChain([
'get' => ['$name', 'getActions', ['where' => [['name', '=', 'get']]], ['params']],
])->execute();
- $getFields = ['name', 'label', 'description', 'options', 'input_type', 'input_attrs', 'data_type', 'serialize', 'fk_entity'];
+ $getFields = ['name', 'title', 'label', 'description', 'options', 'input_type', 'input_attrs', 'data_type', 'serialize', 'entity', 'fk_entity'];
foreach ($entities as $entity) {
// Skip if entity doesn't have a 'get' action or the user doesn't have permission to use get
if ($entity['get']) {
unset($entity['paths'][$action]);
switch ($action) {
case 'view':
- $title = ts('View %1', [1 => $entity['title']]);
+ $title = E::ts('View %1', [1 => $entity['title']]);
break;
case 'update':
- $title = ts('Edit %1', [1 => $entity['title']]);
+ $title = E::ts('Edit %1', [1 => $entity['title']]);
break;
case 'delete':
- $title = ts('Delete %1', [1 => $entity['title']]);
+ $title = E::ts('Delete %1', [1 => $entity['title']]);
break;
default:
if (!array_diff(['select', 'where', 'orderBy', 'limit', 'offset'], array_keys($params))) {
\CRM_Utils_Array::remove($params, 'checkPermissions', 'debug', 'chain', 'language', 'select', 'where', 'orderBy', 'limit', 'offset');
unset($entity['get']);
- $schema[] = ['params' => array_keys($params)] + array_filter($entity);
+ $schema[$entity['name']] = ['params' => array_keys($params)] + array_filter($entity);
+ }
+ }
+ }
+ // Add in FK fields for implicit joins
+ // For example, add a `campaign.title` field to the Contribution entity
+ foreach ($schema as &$entity) {
+ foreach (array_reverse($entity['fields'], TRUE) as $index => $field) {
+ if (!empty($field['fk_entity']) && !$field['options'] && !empty($schema[$field['fk_entity']]['label_field'])) {
+ // The original field will get title instead of label since it represents the id (title usually ends in ID but label does not)
+ $entity['fields'][$index]['label'] = $field['title'];
+ // Add the label field from the other entity to this entity's list of fields
+ $newField = \CRM_Utils_Array::findAll($schema[$field['fk_entity']]['fields'], ['name' => $schema[$field['fk_entity']]['label_field']])[0];
+ $newField['name'] = str_replace('_id', '', $field['name']) . '.' . $schema[$field['fk_entity']]['label_field'];
+ $newField['label'] = $field['label'] . ' ' . $newField['label'];
+ array_splice($entity['fields'], $index, 0, [$newField]);
}
}
}
- return $schema;
+ return array_values($schema);
}
/**
public static function getJoins(array $allowedEntities) {
$joins = [];
foreach ($allowedEntities as $entity) {
- if (!empty($entity['dao'])) {
+ // Multi-record custom field groups (to-date only the contact entity supports these)
+ if (in_array('CustomValue', $entity['type'])) {
+ $targetEntity = $allowedEntities['Contact'];
+ // Join from Custom group to Contact (n-1)
+ $alias = $entity['name'] . '_Contact_entity_id';
+ $joins[$entity['name']][] = [
+ 'label' => $entity['title'] . ' ' . $targetEntity['title'],
+ 'description' => '',
+ 'entity' => 'Contact',
+ 'conditions' => self::getJoinConditions('entity_id', $alias . '.id'),
+ 'defaults' => self::getJoinDefaults($alias, $targetEntity),
+ 'alias' => $alias,
+ 'multi' => FALSE,
+ ];
+ // Join from Contact to Custom group (n-n)
+ $alias = 'Contact_' . $entity['name'] . '_entity_id';
+ $joins['Contact'][] = [
+ 'label' => $entity['title_plural'],
+ 'description' => '',
+ 'entity' => $entity['name'],
+ 'conditions' => self::getJoinConditions('id', $alias . '.entity_id'),
+ 'defaults' => self::getJoinDefaults($alias, $entity),
+ 'alias' => $alias,
+ 'multi' => TRUE,
+ ];
+ }
+ // Non-custom DAO entities
+ elseif (!empty($entity['dao'])) {
/* @var \CRM_Core_DAO $daoClass */
$daoClass = $entity['dao'];
$references = $daoClass::getReferenceColumns();
) {
continue;
}
+ // Dynamic references use a column like "entity_table" (for normal joins this value will be null)
+ $dynamicCol = $reference->getTypeColumn();
// For dynamic references getTargetEntities will return multiple targets; for normal joins this loop will only run once
foreach ($reference->getTargetEntities() as $targetTable => $targetEntityName) {
if (!isset($allowedEntities[$targetEntityName]) || $targetEntityName === $entity['name']) {
continue;
}
$targetEntity = $allowedEntities[$targetEntityName];
- // Dynamic references use a column like "entity_table"
- $dynamicCol = $reference->getTypeColumn();
// Non-bridge joins directly between 2 entities
if (!$bridge) {
// Add the straight 1-1 join
$alias = $baseEntity['name'] . "_{$bridge}_" . $targetEntityName;
$joins[$baseEntity['name']][] = [
'label' => $baseEntity['title'] . ' ' . $targetsTitle,
- 'description' => ts('Multiple %1 per %2', [1 => $targetsTitle, 2 => $baseEntity['title']]),
+ 'description' => E::ts('Multiple %1 per %2', [1 => $targetsTitle, 2 => $baseEntity['title']]),
'entity' => $targetEntityName,
'conditions' => array_merge(
[$bridge],
$alias = $targetEntityName . "_{$bridge}_" . $baseEntity['name'];
$joins[$targetEntityName][] = [
'label' => $targetEntity['title'] . ' ' . $baseEntity['title_plural'],
- 'description' => ts('Multiple %1 per %2', [1 => $baseEntity['title_plural'], 2 => $targetEntity['title']]),
+ 'description' => E::ts('Multiple %1 per %2', [1 => $baseEntity['title_plural'], 2 => $targetEntity['title']]),
'entity' => $baseEntity['name'],
'conditions' => array_merge(
[$bridge],
* @param string|null $dynamicCol
* @return array[]
*/
- private static function getJoinConditions($nearCol, $farCol, $targetTable, $dynamicCol) {
+ private static function getJoinConditions($nearCol, $farCol, $targetTable = NULL, $dynamicCol = NULL) {
$conditions = [
[
$nearCol,
projects / civicrm-core.git / blobdiff