From: Rod Roark <rod@sunsetsystems.com>
Date: Wed, 27 Feb 2013 19:12:34 +0000 (-0800)
Subject: Added a provider filter to Procedures / Electronic Reports.
X-Git-Tag: whats-been-changed~387
X-Git-Url: https://repo.or.cz/w/openemr.git/commitdiff_plain/a10bd8cdb90dcfe3932ea2aca050b01aa1bf35b1

Added a provider filter to Procedures / Electronic Reports.
---

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'";
 }