From 1bab3489472f07c8f78d16290b00a522eb6d9b46 Mon Sep 17 00:00:00 2001
From: andres_paglayan <andres_paglayan>
Date: Fri, 21 Oct 2005 22:30:19 +0000
Subject: [PATCH] batchom support

---
 interface/patient_file/report/full_report.php | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

diff --git a/interface/patient_file/report/full_report.php b/interface/patient_file/report/full_report.php
index 9f7c98397..00c8f1fe7 100644
--- a/interface/patient_file/report/full_report.php
+++ b/interface/patient_file/report/full_report.php
@@ -95,7 +95,16 @@ while ($row=sqlFetchArray($result)){
 }
 ?></td></tr></table>
 <hr>
-
+<font class=bold>Patient Comunication Sent:</font><br>
+<table><tr><td><?
+	   $sql="SELECT concat( 'Messsage Type: ', batchcom.msg_type, ', Message Subject: ', batchcom.msg_subject, ', Sent on:', batchcom.msg_date_sent ) AS batchcom_data, batchcom.msg_text, concat( users.fname, users.lname ) AS user_name FROM `batchcom` JOIN `users` ON users.id = batchcom.sent_by WHERE batchcom.patient_id='$pid'";
+	   // echo $sql;
+	   $result = sqlStatement($sql);
+	   while ($row=sqlFetchArray($result)) {
+			 echo "<tr><td><span class=text>".$row{'batchcom_data'}.", By: ".$row{'user_name'}."</td></tr><tr><td>Text:<br> ".$row{'msg_txt'}."</span></td></tr>\n";
+	    }
+?></td></tr></table>
+<hr>
 <font class=bold>Patient Notes:</font><br>
 <table><tr><td><?
 printPatientNotes($pid);
-- 
2.11.4.GIT