interface/forms/eye_mag/new.php

   1 <?php
   2
   3 /**
   4  * forms/eye_mag/new.php
   5  *
   6  * The page shown when the user requests a new form
   7  *
   8  * @package   OpenEMR
   9  * @link      https://www.open-emr.org
  10  * @author    Ray Magauran <magauran@MedFetch.com>
  11  * @copyright Copyright (c) 2016 Raymond Magauran <magauran@MedFetch.com>
  12  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  13  */
  14
  15 require_once("../../globals.php");
  16 require_once("$srcdir/api.inc.php");
  17
  18 use OpenEMR\Common\Session\SessionUtil;
  19
  20 $form_name = "Eye Exam";
  21 $table_name = "form_eye_base";
  22 $form_folder = "eye_mag";
  23 include_once("../../forms/" . $form_folder . "/php/" . $form_folder . "_functions.php");
  24 formHeader("Form: " . $form_name);
  25 $returnurl = 'encounter_top.php';
  26
  27 $pid = $_REQUEST['pid'] ?? null;
  28
  29 if (!$pid) {
  30     $pid = $_SESSION['pid'];
  31 } else {
  32     SessionUtil::setSession('pid', $pid);
  33 }
  34
  35 if (empty($user)) {
  36     $user = $_SESSION['authUser'];
  37 }
  38
  39 if (empty($group)) {
  40     $group = $_SESSION['authProvider'];
  41 }
  42
  43 if (!$_SESSION['encounter']) {
  44     $encounter = date("Ymd");
  45 } else {
  46     $encounter = $_SESSION['encounter'];
  47 }
  48
  49 $query = "select * from form_encounter where pid =? and encounter= ?";
  50 $encounter_data = sqlQuery($query, array($pid,$encounter));
  51 $encounter_date = $encounter_data['date'];
  52
  53 $query = "SELECT * " .
  54     "FROM form_encounter AS fe, forms AS f WHERE " .
  55     "fe.pid = ? AND fe.date = ? AND " .
  56     "f.formdir = ? AND f.encounter = fe.encounter AND f.encounter=? AND f.deleted = 0";
  57 $erow = sqlQuery($query, array($pid, $encounter_date, $form_folder, $encounter));
  58
  59 if (!empty($erow['form_id']) && ($erow['form_id'] > '0')) {
  60     formHeader("Redirecting....");
  61     formJump('./view_form.php?formname=' . $form_folder . '&id=' . attr($erow['form_id']) . '&pid=' . attr($pid));
  62     formFooter();
  63     exit;
  64 } else {
  65     $id = (!empty($erow2['count'])) ? $erow2['count']++ : null; //erow2['count'] is not defined and formSubmit doesn't use it since we are inserting...
  66     $providerid = findProvider(attr($pid), $encounter);
  67     $newid = formSubmit($table_name, $_POST, $id, $providerid);
  68     $tables = array('form_eye_hpi','form_eye_ros','form_eye_vitals',
  69         'form_eye_acuity','form_eye_refraction','form_eye_biometrics',
  70         'form_eye_external', 'form_eye_antseg','form_eye_postseg',
  71         'form_eye_neuro','form_eye_locking');
  72     foreach ($tables as $table) {
  73         $sql = "INSERT INTO " . $table . " set id=?, pid=?";
  74         sqlStatement($sql, array($newid, $pid));
  75     }
  76     $sql = "insert into forms (date, encounter, form_name, form_id, pid, " .
  77             "user, groupname, authorized, formdir) values (NOW(),?,?,?,?,?,?,?,?)";
  78     $answer = sqlInsert($sql, array($encounter,$form_name,$newid,$pid,$user,$group,$providerid,$form_folder));
  79 }
  80
  81     formHeader("Redirecting....");
  82     formJump('./view_form.php?formname=' . $form_folder . '&id=' . attr($newid) . '&pid=' . attr($pid));
  83     formFooter();
  84     exit;