From b077cff98a3f4688f024454e09699106e934a2ba Mon Sep 17 00:00:00 2001
From: Jamie McClelland <jm@mayfirst.org>
Date: Wed, 29 Jul 2015 12:22:53 -0400
Subject: [PATCH] CRM-16930 - enable custom case fields on case report.

---
 CRM/Case/XMLProcessor/Report.php    | 16 ++++++++++++++++
 templates/CRM/Case/Audit/Report.tpl | 12 ++++++++++++
 2 files changed, 28 insertions(+)

diff --git a/CRM/Case/XMLProcessor/Report.php b/CRM/Case/XMLProcessor/Report.php
index cdbe24399e..d3396432d6 100644
--- a/CRM/Case/XMLProcessor/Report.php
+++ b/CRM/Case/XMLProcessor/Report.php
@@ -974,11 +974,27 @@ LIMIT  1
       }
     }
 
+    // Retrieve custom values for cases.
+    $customValues = CRM_Core_BAO_CustomValueTable::getEntityValues($caseID, 'Case');
+    $extends = array('case');
+    $groupTree = CRM_Core_BAO_CustomGroup::getGroupDetail(NULL, NULL, $extends);
+    $caseCustomFields = array();
+    while(list($id, $group_values) = each($groupTree)) {
+      while(list($id, $field_values) = each($group_values['fields'])) {
+        if(array_key_exists($id, $customValues)) {
+          $caseCustomFields[$id] = array(
+            'label' => $field_values['label'],
+            'value' => $customValues[$id],
+          );
+        }
+      }
+    }
     $template->assign('caseRelationships', $caseRelationships);
     $template->assign('caseRoles', $caseRoles);
     $template->assign('otherRelationships', $otherRelationships);
     $template->assign('globalRelationships', $relGlobal);
     $template->assign('globalGroupInfo', $globalGroupInfo);
+    $template->assign('caseCustomFields', $caseCustomFields);
     $contents = self::getCaseReport($clientID,
       $caseID,
       $activitySetName,
diff --git a/templates/CRM/Case/Audit/Report.tpl b/templates/CRM/Case/Audit/Report.tpl
index a2beff3a23..5dd29686c4 100644
--- a/templates/CRM/Case/Audit/Report.tpl
+++ b/templates/CRM/Case/Audit/Report.tpl
@@ -126,6 +126,18 @@
     </table>
 {/if}
 
+{if $caseCustomFields}
+<h2>{ts}Case Custom Fields{/ts}</h2>
+    <table class ="report-layout">
+      {foreach from=$caseCustomFields item=row}
+        <tr>
+          <th class="label">{$row.label}</td>
+          <td class="crm-case-report-custom-field">{$row.value}</td>
+        </tr>
+      {/foreach}
+    </table>
+{/if}
+
 <h2>{ts}Case Activities{/ts}</h2>
 {foreach from=$activities item=activity key=key}
   <table  class ="report-layout">
-- 
2.25.1