src/Services/FormService.php

   1 <?php
   2
   3 /**
   4  * FormService refactored getFormByEncounter
   5  *
   6  * @package   OpenEMR
   7  * @link      http://www.open-emr.org
   8  * @author    <Unknown> Authorship was not listed in encounter.inc.php
   9  * @author    Stephen Nielson <stephen@nielson.org>
  10  * @copyright Copyright (c) 2021 Stephen Nielson <stephen@nielson.org>
  11  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  12  */
  13
  14 namespace OpenEMR\Services;
  15
  16 class FormService
  17 {
  18     public function getFormByEncounter(
  19         $attendant_id,
  20         $encounter,
  21         $cols = "form_id, form_name",
  22         $name = "",
  23         $orderby = "FIND_IN_SET(formdir,'vitals') DESC, date DESC"
  24     ) {
  25
  26         global $attendant_type;
  27         $arraySqlBind = array();
  28         $sql = "select " . escape_sql_column_name(process_cols_escape($cols), array('forms')) . " from forms where encounter = ? and deleted = 0 ";
  29         array_push($arraySqlBind, $encounter);
  30         if (!empty($name)) {
  31             $sql .= "and form_name=? ";
  32             array_push($arraySqlBind, $name);
  33         }
  34
  35         if ($attendant_type == 'pid') {
  36             $sql .= " and pid=? and therapy_group_id IS NULL ";
  37         } else {
  38             $sql .= " and therapy_group_id = ? and pid IS NULL ";
  39         }
  40
  41         array_push($arraySqlBind, $attendant_id);
  42
  43         // Default $orderby puts vitals first in the list, and newpatient last:
  44         $sql .= "ORDER BY $orderby";
  45
  46         $res = sqlStatement($sql, $arraySqlBind);
  47
  48         for ($iter = 0; $row = sqlFetchArray($res); $iter++) {
  49             $all[$iter] = $row;
  50         }
  51
  52         return $all;
  53     }
  54 }