controllers/C_PatientFinder.class.php

   1 <?php
   2
   3 class C_PatientFinder extends Controller
   4 {
   5     var $template_mod;
   6
   7     function __construct($template_mod = "general")
   8     {
   9         parent::__construct();
  10         $this->template_mod = $template_mod;
  11         $this->assign("FORM_ACTION", $GLOBALS['webroot'] . "/controller.php?" . attr($_SERVER['QUERY_STRING']));
  12         ///////////////////////////////////
  13         //// What should this be?????
  14         //////////////////////////////////
  15         $this->assign("CURRENT_ACTION", $GLOBALS['webroot'] . "/controller.php?" . "practice_settings&patient_finder&");
  16         /////////////////////////////////
  17         $this->assign("STYLE", $GLOBALS['style']);
  18     }
  19
  20     function default_action($form_id = '', $form_name = '', $pid = '')
  21     {
  22         return $this->find_action($form_id, $form_name, $pid);
  23     }
  24
  25     /**
  26     * Function that will display a patient finder widget, allowing
  27     *   the user to input search parameters to find a patient id.
  28     */
  29     function find_action($form_id, $form_name, $pid = null)
  30     {
  31         $isPid = false;
  32
  33         $this->assign('form_id', $form_id);
  34         $this->assign('form_name', $form_name);
  35         if (!empty($pid)) {
  36             $isPid = true;
  37         }
  38
  39         $this->assign('hidden_ispid', $isPid);
  40
  41         return $this->fetch($GLOBALS['template_dir'] . "patient_finder/" . $this->template_mod . "_find.html");
  42     }
  43
  44     /**
  45     * Function that will take a search string, parse it out and return all patients from the db matching.
  46     * @param string $search_string - String from html form giving us our search parameters
  47     */
  48     function find_action_process()
  49     {
  50
  51         if ($_POST['process'] != "true") {
  52             return;
  53         }
  54
  55         $isPub = false;
  56         $search_string = $_POST['searchstring'];
  57         if (!empty($_POST['pid'])) {
  58             $isPub = !$_POST['pid'];
  59         }
  60
  61         //get the db connection and pass it to the helper functions
  62         $sql = "SELECT CONCAT(lname, ' ', fname, ' ', mname) as name, DOB, pubpid, pid FROM patient_data";
  63         //parse search_string to determine what type of search we have
  64         $pos = strpos($search_string, ',');
  65
  66         // get result set into array and pass to array
  67         $result_array = array();
  68
  69         if ($pos === false) {
  70             //no comma just last name
  71             $result_array = $this->search_by_lName($sql, $search_string);
  72         } elseif ($pos === 0) {
  73             //first name only
  74             $result_array = $this->search_by_fName($sql, $search_string);
  75         } else {
  76             //last and first at least
  77             $result_array = $this->search_by_FullName($sql, $search_string);
  78         }
  79
  80         $this->assign('search_string', $search_string);
  81         $this->assign('result_set', $result_array);
  82         $this->assign('ispub', $isPub);
  83         // we're done
  84         $_POST['process'] = "";
  85     }
  86
  87     /**
  88     *   Function that returns an array containing the
  89     *   Results of a LastName search
  90     *   @-param string $sql base sql query
  91     *   @-param string $search_string parsed for last name
  92     */
  93     function search_by_lName($sql, $search_string)
  94     {
  95         $lName = add_escape_custom($search_string);
  96         $sql .= " WHERE lname LIKE '$lName%' ORDER BY lname, fname";
  97         $results = sqlStatement($sql);
  98
  99         $result_array = [];
 100         while ($result = sqlFetchArray($results)) {
 101             $result_array[] = $result;
 102         }
 103
 104         return $result_array;
 105     }
 106
 107     /**
 108     *   Function that returns an array containing the
 109     *   Results of a FirstName search
 110     *   @param string $sql base sql query
 111     *   @param string $search_string parsed for first name
 112     */
 113     function search_by_fName($sql, $search_string)
 114     {
 115         $name_array = explode(",", $search_string);
 116         $fName = add_escape_custom(trim($name_array[1]));
 117         $sql .= " WHERE fname LIKE '$fName%' ORDER BY lname, fname";
 118         $results = sqlStatement($sql);
 119
 120         $result_array = [];
 121         while ($result = sqlFetchArray($results)) {
 122             $result_array[] = $result;
 123         }
 124
 125         return $result_array;
 126     }
 127
 128     /**
 129     *   Function that returns an array containing the
 130     *   Results of a Full Name search
 131     *   @param string $sql base sql query
 132     *   @param string $search_string parsed for first, last and middle name
 133     */
 134     function search_by_FullName($sql, $search_string)
 135     {
 136         $name_array = explode(",", $search_string);
 137         $lName = add_escape_custom($name_array[0]);
 138         $fName = add_escape_custom(trim($name_array[1]));
 139         $sql .= " WHERE fname LIKE '%$fName%' AND lname LIKE '$lName%' ORDER BY lname, fname";
 140         $results = sqlStatement($sql);
 141
 142         $result_array = [];
 143         while ($result = sqlFetchArray($results)) {
 144             $result_array[] = $result;
 145         }
 146
 147         return $result_array;
 148     }
 149 }