From 1d8da9d9ed2ec66e0ddcbb73d09f05c37eb90eaa Mon Sep 17 00:00:00 2001
From: Divya Jose <divya@divya.(none)>
Date: Tue, 29 Apr 2014 19:49:21 +0530
Subject: [PATCH] --fixes for HR-344,changes to retrieve caseId based on
 case_type

---
 CRM/Case/BAO/Case.php | 9 +++++++--
 1 file changed, 7 insertions(+), 2 deletions(-)

diff --git a/CRM/Case/BAO/Case.php b/CRM/Case/BAO/Case.php
index 9878012efc..9987e59e71 100644
--- a/CRM/Case/BAO/Case.php
+++ b/CRM/Case/BAO/Case.php
@@ -515,13 +515,18 @@ class CRM_Case_BAO_Case extends CRM_Case_DAO_Case {
    * @access public
    *
    */
-  static function retrieveCaseIdsByContactId($contactID, $includeDeleted = FALSE) {
+  static function retrieveCaseIdsByContactId($contactID, $includeDeleted = FALSE, $caseType = NULL) {
     $query = "
 SELECT ca.id as id
 FROM civicrm_case_contact cc
 INNER JOIN civicrm_case ca ON cc.case_id = ca.id
-WHERE cc.contact_id = %1
 ";
+    if (isset($caseType)) {
+      $query .=
+"INNER JOIN civicrm_option_value cov ON (cov.value = ca.case_type_id)
+INNER JOIN civicrm_option_group cog ON (cog.id = cov.option_group_id and cog.name = 'case_type')
+WHERE cc.contact_id = %1 AND cov.name = '{$caseType}'";
+    }
     if (!$includeDeleted) {
       $query .= " AND ca.is_deleted = 0";
     }
-- 
2.25.1