From 74a80855c7194d23453e20f18b35b9d35dacc8bb Mon Sep 17 00:00:00 2001
From: sunsetsystems <sunsetsystems>
Date: Mon, 17 Oct 2005 17:10:31 +0000
Subject: [PATCH] added ucsmc codes for uk sports medicine; allow selection of
 providers not in the calendar

---
 interface/forms/fee_sheet/new.php  | 18 +++++++++++++-----
 interface/forms/fee_sheet/view.php | 18 +++++++++++++-----
 2 files changed, 26 insertions(+), 10 deletions(-)

diff --git a/interface/forms/fee_sheet/new.php b/interface/forms/fee_sheet/new.php
index 6d7d7b193..4243f675e 100644
--- a/interface/forms/fee_sheet/new.php
+++ b/interface/forms/fee_sheet/new.php
@@ -337,10 +337,13 @@ if ($_POST['newcode']) {
 <span class="billcell">PROVIDER:</span>
 
 <?
-// Build a drop-down list of providers.
+// Build a drop-down list of providers.  This includes users who
+// have the word "provider" anywhere in their "additional info"
+// field, so that we can define providers (for billing purposes)
+// who do not appear in the calendar.
 //
-$query = "select id, lname, fname from users where " .
-	"authorized = 1 order by lname, fname";
+$query = "SELECT id, lname, fname FROM users WHERE " .
+	"authorized = 1 OR info LIKE '%provider%' ORDER BY lname, fname";
 $res = sqlStatement($query);
 
 echo "   <select name='ProviderID'>\n";
@@ -364,13 +367,18 @@ echo "   </select>\n";
 &nbsp;
 <input type='button' value='Cancel' onclick="location='<? echo "$rootdir/patient_file/encounter/patient_encounter.php" ?>'" />
 
+<?php if ($code_types['UCSMC']) { ?>
+<p style='font-family:sans-serif;font-size:8pt;color:#666666;'>
+&nbsp;<br>
+UCSMC codes provided by the University of Calgary Sports Medicine Centre
+</p>
+<? } ?>
+
 </center>
 
 </form>
 <?php
-
 // TBD: If $alertmsg, display it with a JavaScript alert().
-
 ?>
 </body>
 </html>
diff --git a/interface/forms/fee_sheet/view.php b/interface/forms/fee_sheet/view.php
index 6d7d7b193..4243f675e 100644
--- a/interface/forms/fee_sheet/view.php
+++ b/interface/forms/fee_sheet/view.php
@@ -337,10 +337,13 @@ if ($_POST['newcode']) {
 <span class="billcell">PROVIDER:</span>
 
 <?
-// Build a drop-down list of providers.
+// Build a drop-down list of providers.  This includes users who
+// have the word "provider" anywhere in their "additional info"
+// field, so that we can define providers (for billing purposes)
+// who do not appear in the calendar.
 //
-$query = "select id, lname, fname from users where " .
-	"authorized = 1 order by lname, fname";
+$query = "SELECT id, lname, fname FROM users WHERE " .
+	"authorized = 1 OR info LIKE '%provider%' ORDER BY lname, fname";
 $res = sqlStatement($query);
 
 echo "   <select name='ProviderID'>\n";
@@ -364,13 +367,18 @@ echo "   </select>\n";
 &nbsp;
 <input type='button' value='Cancel' onclick="location='<? echo "$rootdir/patient_file/encounter/patient_encounter.php" ?>'" />
 
+<?php if ($code_types['UCSMC']) { ?>
+<p style='font-family:sans-serif;font-size:8pt;color:#666666;'>
+&nbsp;<br>
+UCSMC codes provided by the University of Calgary Sports Medicine Centre
+</p>
+<? } ?>
+
 </center>
 
 </form>
 <?php
-
 // TBD: If $alertmsg, display it with a JavaScript alert().
-
 ?>
 </body>
 </html>
-- 
2.11.4.GIT