From 364e3c19214f46cfb567a809f64c52213ccdd4eb Mon Sep 17 00:00:00 2001
From: Sudarshan Phule <sudarshanthecoder@gmail.com>
Date: Fri, 29 Jul 2011 18:17:51 +0530
Subject: [PATCH] =?utf8?q?Committed=20referrals=5Freport.php=20for=20bug?=
 =?utf8?q?=20where=20"Refer=20to"=20provider's=20name=20is=20not=20display?=
 =?utf8?q?ing=20in=20the=20Report=20=E2=80=93=20Referrals.=20Summary:?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 interface/reports/referrals_report.php | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

diff --git a/interface/reports/referrals_report.php b/interface/reports/referrals_report.php
index 4b9624d4c..c14982385 100644
--- a/interface/reports/referrals_report.php
+++ b/interface/reports/referrals_report.php
@@ -174,6 +174,7 @@
   $query = "SELECT t.id, t.refer_date, t.reply_date, t.body, " .
     "ut.organization, uf.facility_id, p.pubpid, " .
     "CONCAT(uf.fname,' ', uf.lname) AS referer_name, " .
+    "CONCAT(ut.fname,' ', ut.lname) AS referer_to, " .
     "CONCAT(p.fname,' ', p.lname) AS patient_name " .
     "FROM transactions AS t " .
     "LEFT OUTER JOIN patient_data AS p ON p.pid = t.pid " .
@@ -196,10 +197,18 @@
         if (!empty($row['facility_id'])) continue;
       }
     }
+    
 ?>
  <tr>
   <td>
-   <?php echo $row['organization'] ?>
+   <?php if($row['organization']!=NULL || $row['organization']!='') {
+   			echo $row['organization'];
+   		}
+   		else {
+   				echo $row['referer_to'];
+   		}	 
+   			
+   	?>
   </td>
   <td>
    <a href='#' onclick="return show_referral(<?php echo $row['id']; ?>)">
-- 
2.11.4.GIT