+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
foreach ($this->_columns as $tableName => $table) {
if (array_key_exists('fields', $table)) {
foreach ($table['fields'] as $fieldName => $field) {
foreach ($this->_columns as $tableName => $table) {
if (array_key_exists('fields', $table)) {
foreach ($table['fields'] as $fieldName => $field) {
foreach ($field['statistics'] as $stat => $label) {
$select[] = "{$field['dbAlias']} as {$tableName}_{$fieldName}_{$stat}";
$this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label;
foreach ($field['statistics'] as $stat => $label) {
$select[] = "{$field['dbAlias']} as {$tableName}_{$fieldName}_{$stat}";
$this->_columnHeaders["{$tableName}_{$fieldName}_{$stat}"]['title'] = $label;
$this->_orderBy = " ORDER BY {$this->_aliases['civicrm_contact_organization']}.organization_name, {$this->_aliases['civicrm_relationship']}.$this->orgContact, {$this->_aliases['civicrm_contact']}.sort_name, {$this->_aliases['civicrm_relationship']}.$this->otherContact";
}
$this->_orderBy = " ORDER BY {$this->_aliases['civicrm_contact_organization']}.organization_name, {$this->_aliases['civicrm_relationship']}.$this->orgContact, {$this->_aliases['civicrm_contact']}.sort_name, {$this->_aliases['civicrm_relationship']}.$this->otherContact";
}
$params = array('contact_type_b' => 'Organization', 'version' => 3);
$typesA = &civicrm_api('relationship_type', 'get', $params);
$params = array('contact_type_b' => 'Organization', 'version' => 3);
$typesA = &civicrm_api('relationship_type', 'get', $params);
foreach ($typesA['values'] as $rel) {
$relationTypes[$rel['id']][$rel['id'] . '_b_a'] = $rel['label_b_a'];
}
foreach ($typesA['values'] as $rel) {
$relationTypes[$rel['id']][$rel['id'] . '_b_a'] = $rel['label_b_a'];
}
$params = array('contact_type_a' => 'Organization', 'version' => 3);
$typesB = &civicrm_api('relationship_type', 'get', $params);
$params = array('contact_type_a' => 'Organization', 'version' => 3);
$typesB = &civicrm_api('relationship_type', 'get', $params);
foreach ($typesB['values'] as $rel) {
$relationTypes[$rel['id']][$rel['id'] . '_a_b'] = $rel['label_a_b'];
}
foreach ($typesB['values'] as $rel) {
$relationTypes[$rel['id']][$rel['id'] . '_a_b'] = $rel['label_a_b'];
}
function alterDisplay(&$rows) {
// custom code to alter rows
$type = substr($this->_params['relationship_type_id_value'], -3);
function alterDisplay(&$rows) {
// custom code to alter rows
$type = substr($this->_params['relationship_type_id_value'], -3);
- if (array_key_exists('civicrm_contact_organization_organization_name', $row) &&
- CRM_Utils_Array::value('civicrm_contact_organization_organization_name',
- $rows[$rowNum]
- ) &&
+ if (array_key_exists('civicrm_contact_organization_organization_name', $row) && !empty($rows[$rowNum]
+['civicrm_contact_organization_organization_name']) &&
array_key_exists('civicrm_contact_organization_id', $row)
) {
$url = CRM_Utils_System::url('civicrm/contact/view',
array_key_exists('civicrm_contact_organization_id', $row)
) {
$url = CRM_Utils_System::url('civicrm/contact/view',