From: bradymiller <bradymiller@users.sourceforge.net>
Date: Thu, 13 Dec 2012 01:19:45 +0000 (-0800)
Subject: Bug fix to show correct name of encounter author on custom report.
X-Git-Tag: whats-been-changed~478
X-Git-Url: https://repo.or.cz/w/openemr.git/commitdiff_plain/c0c2dabbac04f23d1513496b7e18913cd4010056

Bug fix to show correct name of encounter author on custom report.

 -Shows provider rather than any user that first opens the encounter.
---

diff --git a/interface/patient_file/report/custom_report.php b/interface/patient_file/report/custom_report.php
index df09a9f2f..64f002ef9 100644
--- a/interface/patient_file/report/custom_report.php
+++ b/interface/patient_file/report/custom_report.php
@@ -540,14 +540,7 @@ foreach ($ar as $key => $val) {
                 echo "(" . oeFormatSDFT(strtotime($dateres["date"])) . ") ";
                 if ($res[1] == 'newpatient') {
                     // display the provider info
-                    $tmp = sqlQuery("SELECT u.title, u.fname, u.mname, u.lname " .
-                                    "FROM forms AS f, users AS u WHERE " .
-                                    "f.pid = '$pid' AND f.encounter = '$form_encounter' AND " .
-                                    "f.formdir = 'newpatient' AND u.username = f.user " .
-                                    " AND f.deleted=0 ". //--JRM--
-                                    "ORDER BY f.id LIMIT 1");
-                    echo ' '. xl('Provider') . ': ' . $tmp['title'] . ' ' .
-                        $tmp['fname'] . ' ' . $tmp['mname'] . ' ' . $tmp['lname'];
+                    echo ' '. xl('Provider') . ': ' . text(getProviderName(getProviderIdOfEncounter($form_encounter)));
                 }
                 echo "<br>\n";