From 19e733e45a9b8e38b57afa36c9df1333253908d9 Mon Sep 17 00:00:00 2001
From: Sherwin Gaddis <sherwingaddis@gmail.com>
Date: Fri, 23 Dec 2016 10:19:12 -0500
Subject: [PATCH] Auto suggest for lot number in the immunization form

Signed-off-by: Sherwin Gaddis <sherwingaddis@gmail.com>
---
 interface/patient_file/summary/immunizations.php | 18 ++++++--
 library/ajax/imm_autocomplete/search.php         | 54 ++++++++++++++++++++++++
 2 files changed, 68 insertions(+), 4 deletions(-)
 create mode 100644 library/ajax/imm_autocomplete/search.php

diff --git a/interface/patient_file/summary/immunizations.php b/interface/patient_file/summary/immunizations.php
index 37cef9056..45e0ec34d 100644
--- a/interface/patient_file/summary/immunizations.php
+++ b/interface/patient_file/summary/immunizations.php
@@ -308,14 +308,14 @@ function saveImmunizationObservationResults($id,$immunizationdata)
 <?php html_header_show();?>
 
 <!-- supporting javascript code -->
-<script type="text/javascript" src="<?php echo $GLOBALS['assets_static_relative']; ?>/jquery-min-1-2-1/index.js"></script>
 <script type="text/javascript" src="<?php echo $GLOBALS['webroot'] ?>/library/textformat.js"></script>
 <script type="text/javascript" src="<?php echo $GLOBALS['webroot'] ?>/library/dialog.js?v=<?php echo $v_js_includes; ?>"></script>
-
+<script type="text/javascript" src="<?php echo $GLOBALS['assets_static_relative']; ?>/jquery-min-1-9-1/index.js"></script>
+<script type="text/javascript" src="<?php echo $GLOBALS['assets_static_relative']; ?>/jquery-ui-1-10-4/ui/jquery-ui.js"></script>
 
 <!-- page styles -->
 <link rel="stylesheet" href="<?php echo $css_header;?>" type="text/css">
-
+<link rel="stylesheet" href="<?php echo $GLOBALS['assets_static_relative']; ?>/jquery-ui-1-10-4/themes/base/jquery-ui.min.css" type="text/css" />
 <style>
 .highlight {
   color: green;
@@ -429,7 +429,7 @@ var mypcc = '<?php echo htmlspecialchars( $GLOBALS['phone_country_code'], ENT_QU
             <span class=text>
               <?php echo htmlspecialchars( xl('Immunization Lot Number'), ENT_NOQUOTES); ?>            </span>          </td>
           <td>
-            <input class='text' type='text' name="lot_number" size="25" value="<?php echo htmlspecialchars( $lot_number, ENT_QUOTES); ?>">          </td>
+            <input class='text auto' type='text' name="lot_number" size="25" value="<?php echo htmlspecialchars( $lot_number, ENT_QUOTES); ?>">          </td>
         </tr>
         <tr>
           <td align="right">
@@ -1141,6 +1141,16 @@ function sel_code(id)
     $('#clickId').val(checkId);
     dlgopen('<?php echo $GLOBALS['webroot'] . "/interface/patient_file/encounter/" ?>find_code_popup.php', '_blank', 700, 400);
 }
+
+$(function() {
+  
+  //autocomplete
+  $(".auto").autocomplete({
+    source: "../../../library/ajax/imm_autocomplete/search.php",
+    minLength: 1
+  });       
+
+});
 </script>
 
 </html>
diff --git a/library/ajax/imm_autocomplete/search.php b/library/ajax/imm_autocomplete/search.php
new file mode 100644
index 000000000..385043e64
--- /dev/null
+++ b/library/ajax/imm_autocomplete/search.php
@@ -0,0 +1,54 @@
+<?php
+
+/** Copyright (C) 2016 Sherwin Gaddis <sherwingaddis@gmail.com>
+ *
+ * LICENSE: This program is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU General Public License
+ * as published by the Free Software Foundation; either version 2
+ * of the License, or (at your option) any later version.
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ * You should have received a copy of the GNU General Public License
+ * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
+ *
+ * @package OpenEMR
+ * Sherwin Gaddis <sherwingaddis@gmail.com>
+ * @link    http://www.open-emr.org
+ */
+
+//SANITIZE ALL ESCAPES
+$sanitize_all_escapes=true;
+//
+
+//STOP FAKE REGISTER GLOBALS
+$fake_register_globals=false;
+//
+require_once('../../../interface/globals.php');
+
+
+if (isset($_GET['term'])){
+    $term = $_GET['term'];
+	$return_arr = array();
+
+	try {
+		$sql = "SELECT DISTINCT lot_number FROM immunizations WHERE lot_number LIKE ? ";
+
+		$res = sqlstatement($sql,"%".$term."%");
+		while($row = sqlFetchArray($res)){
+			$return_arr[] =  $row['lot_number'] ;
+		}
+
+	
+catch(Excption $e) {
+	    echo 'ERROR: ' . $e->getMessage(), "\n";
+	}
+
+
+    /* Toss back results as json encoded array. */
+    echo json_encode($return_arr);
+}
+
+
+?>
\ No newline at end of file
-- 
2.11.4.GIT