From a10bd8cdb90dcfe3932ea2aca050b01aa1bf35b1 Mon Sep 17 00:00:00 2001
From: Rod Roark <rod@sunsetsystems.com>
Date: Wed, 27 Feb 2013 11:12:34 -0800
Subject: [PATCH] Added a provider filter to Procedures / Electronic Reports.

---
 interface/orders/list_reports.php | 19 +++++++++++++++++--
 1 file changed, 17 insertions(+), 2 deletions(-)

diff --git a/interface/orders/list_reports.php b/interface/orders/list_reports.php
index b61e19fed..b44c0952c 100644
--- a/interface/orders/list_reports.php
+++ b/interface/orders/list_reports.php
@@ -133,11 +133,13 @@ $form_to_date = empty($_POST['form_to_date']) ? '' : trim($_POST['form_to_date']
 $form_reviewed = empty($_POST['form_reviewed']) ? 3 : intval($_POST['form_reviewed']);
 
 $form_patient = !empty($_POST['form_patient']);
+
+$form_provider = empty($_POST['form_provider']) ? 0 : intval($_POST['form_provider']);
 ?>
 
-<table>
+<table width='100%'>
  <tr>
-  <td class='text'>
+  <td class='text' align='center'>
    &nbsp;<?php echo xlt('From'); ?>:
    <input type='text' size='8' name='form_from_date' id='form_from_date'
     value='<?php echo attr($form_from_date); ?>'
@@ -169,6 +171,14 @@ foreach (array('1' => xl('All'), '2' => xl('Reviewed'), '3' => xl('Unreviewed'),
    </select>
 
    &nbsp;
+<?php
+ generate_form_field(array('data_type' => 10, 'field_id' => 'provider',
+   'empty_title' => '-- All Providers --'), $form_provider);
+?>
+  </td>
+ </tr>
+ <tr>
+  <td class='text' align='center'>
    <input type='checkbox' name='form_patient' value='1'
     <?php if ($form_patient) echo 'checked '; ?>/>Current Patient Only
 
@@ -237,6 +247,11 @@ if ($form_patient) {
   $sqlBindArray[] = $pid;
 }
 
+if ($form_provider) {
+  $where .= " AND po.provider_id = ?";
+  $sqlBindArray[] = $form_provider;
+}
+
 if ($form_reviewed == 2) {
   $where .= " AND pr.procedure_report_id IS NOT NULL AND pr.review_status = 'reviewed'";
 }
-- 
2.11.4.GIT