Awight has uploaded a new change for review.
https://gerrit.wikimedia.org/r/171979
Change subject: support cross-database references
......................................................................
support cross-database references
Automatically generated aliases would include illegal "."
Change-Id: Ie7479b2fc888c12f7089955457bc83ba7fac5c38
---
M CRM/Report/Form.php
1 file changed, 4 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/wikimedia/fundraising/crm/civicrm
refs/changes/79/171979/1
diff --git a/CRM/Report/Form.php b/CRM/Report/Form.php
index e044a2b..e52dc9f 100644
--- a/CRM/Report/Form.php
+++ b/CRM/Report/Form.php
@@ -387,6 +387,7 @@
else {
$this->_columns[$tableName]['alias'] = $table['alias'] . '_civireport';
}
+ $this->_columns[$tableName]['alias'] = str_replace('.', '_',
$this->_columns[$tableName]['alias']);
$this->_aliases[$tableName] = $this->_columns[$tableName]['alias'];
@@ -448,6 +449,7 @@
$alias = isset($field['alias']) ? $field['alias'] :
(isset($this->_columns[$tableName]['alias']) ?
$this->_columns[$tableName]['alias'] : $tableName
);
+ $alias = str_replace('.', '_', $alias);
$this->_columns[$tableName][$fieldGrp][$fieldName]['alias'] =
$alias;
// set name = fieldName, unless already set
@@ -1654,6 +1656,7 @@
if (CRM_Utils_Array::value('statistics', $field)) {
foreach ($field['statistics'] as $stat => $label) {
$alias = "{$tableName}_{$fieldName}_{$stat}";
+ $alias = str_replace('.', '_', $alias);
switch (strtolower($stat)) {
case 'max':
case 'sum':
@@ -1684,6 +1687,7 @@
}
else {
$alias = "{$tableName}_{$fieldName}";
+ $alias = str_replace('.', '_', $alias);
$select[] = "{$field['dbAlias']} as $alias";
$this->_columnHeaders["{$tableName}_{$fieldName}"]['title'] =
CRM_Utils_Array::value('title', $field);
$this->_columnHeaders["{$tableName}_{$fieldName}"]['type'] =
CRM_Utils_Array::value('type', $field);
--
To view, visit https://gerrit.wikimedia.org/r/171979
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ie7479b2fc888c12f7089955457bc83ba7fac5c38
Gerrit-PatchSet: 1
Gerrit-Project: wikimedia/fundraising/crm/civicrm
Gerrit-Branch: master
Gerrit-Owner: Awight <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
