interface/drugs/add_edit_drug.php

   1 <?php
   2  // Copyright (C) 2006 Rod Roark <rod@sunsetsystems.com>
   3  //
   4  // This program is free software; you can redistribute it and/or
   5  // modify it under the terms of the GNU General Public License
   6  // as published by the Free Software Foundation; either version 2
   7  // of the License, or (at your option) any later version.
   8
   9  require_once("../globals.php");
  10  require_once("$srcdir/acl.inc");
  11  require_once("drugs.inc.php");
  12
  13  $drug_id = $_REQUEST['drug'];
  14  $info_msg = "";
  15
  16  if (!acl_check('admin', 'drugs')) die("Not authorized!");
  17 ?>
  18 <html>
  19 <head>
  20 <title><? echo $drug_id ? "Edit" : "Add New" ?> Drug</title>
  21 <link rel=stylesheet href='<? echo $css_header ?>' type='text/css'>
  22
  23 <style>
  24 td { font-size:10pt; }
  25 </style>
  26
  27 <script language="JavaScript">
  28 </script>
  29
  30 </head>
  31
  32 <body <?echo $top_bg_line;?>>
  33 <?php
  34  // If we are saving, then save and close the window.
  35  //
  36  if ($_POST['form_save'] || $_POST['form_delete']) {
  37   if ($drug_id) {
  38    if ($_POST['form_save']) {
  39     sqlStatement("UPDATE drugs SET " .
  40      "selector = '"      . $_POST['form_selector']      . "', " .
  41      "name = '"          . $_POST['form_name']          . "', " .
  42      "ndc_number = '"    . $_POST['form_ndc_number']    . "', " .
  43      "on_order = '"      . $_POST['form_on_order']      . "', " .
  44      "reorder_point = '" . $_POST['form_reorder_point'] . "', " .
  45 //   "reactions = '"     . $_POST['form_reactions']     . "', " .
  46      "form = '"          . $_POST['form_form']          . "', " .
  47      "dosage = '"        . $_POST['form_dosage']        . "', " .
  48      "size = '"          . $_POST['form_size']          . "', " .
  49      "unit = '"          . $_POST['form_unit']          . "', " .
  50      "route = '"         . $_POST['form_route']         . "', " .
  51      "period = '"        . $_POST['form_period']        . "', " .
  52 //   "substitute = '"    . $_POST['form_substitute']    . "', " .
  53      "quantity = '"      . $_POST['form_quantity']      . "' "  .
  54 //   "refills = '"       . $_POST['form_refills']       . "', " .
  55 //   "per_refill = '"    . $_POST['form_per_refill']    . "' "  .
  56      "WHERE drug_id = '$drug_id'");
  57    } else {
  58     sqlStatement("DELETE FROM drug_inventory WHERE drug_id = '$drug_id'");
  59     sqlStatement("DELETE FROM drugs WHERE drug_id = '$drug_id'");
  60    }
  61   } else {
  62    $drug_id = sqlInsert("INSERT INTO drugs ( " .
  63     "selector, name, ndc_number, on_order, reorder_point, form, dosage, " .
  64     "size, unit, route, period, quantity " .
  65     ") VALUES ( " .
  66     "'" . $_POST['form_selector']      . "', " .
  67     "'" . $_POST['form_name']          . "', " .
  68     "'" . $_POST['form_ndc_number']    . "', " .
  69     "'" . $_POST['form_on_order']      . "', " .
  70     "'" . $_POST['form_reorder_point'] . "', " .
  71 //  "'" . $_POST['form_reactions']     . "', " .
  72     "'" . $_POST['form_form']          . "', " .
  73     "'" . $_POST['form_dosage']        . "', " .
  74     "'" . $_POST['form_size']          . "', " .
  75     "'" . $_POST['form_unit']          . "', " .
  76     "'" . $_POST['form_route']         . "', " .
  77     "'" . $_POST['form_period']        . "', " .
  78 //  "'" . $_POST['form_substitute']    . "', " .
  79     "'" . $_POST['form_quantity']      . "' "  .
  80 //  "'" . $_POST['form_refills']       . "', " .
  81 //  "'" . $_POST['form_per_refill']    . "' "  .
  82    ")");
  83   }
  84
  85   // Close this window and redisplay the updated list of drugs.
  86   //
  87   echo "<script language='JavaScript'>\n";
  88   if ($info_msg) echo " alert('$info_msg');\n";
  89   echo " window.close();\n";
  90   echo " if (opener.refreshme) opener.refreshme();\n";
  91   echo "</script></body></html>\n";
  92   exit();
  93  }
  94
  95  if ($drug_id) {
  96   $row = sqlQuery("SELECT * FROM drugs WHERE drug_id = $drug_id");
  97  }
  98 ?>
  99
 100 <form method='post' name='theform' action='add_edit_drug.php?drug=<? echo $drug_id ?>'>
 101 <center>
 102
 103 <table border='0' width='100%'>
 104
 105  <tr>
 106   <td valign='top' width='1%' nowrap><b><? xl('Identifier','e'); ?>:</b></td>
 107   <td>
 108    <input type='text' size='40' name='form_selector' maxlength='80' value='<? echo $row['selector'] ?>' style='width:100%' />
 109   </td>
 110  </tr>
 111
 112  <tr>
 113   <td valign='top' nowrap><b><? xl('Name','e'); ?>:</b></td>
 114   <td>
 115    <input type='text' size='40' name='form_name' maxlength='80' value='<? echo $row['name'] ?>' style='width:100%' />
 116   </td>
 117  </tr>
 118
 119  <tr>
 120   <td valign='top' nowrap><b><? xl('NDC Number','e'); ?>:</b></td>
 121   <td>
 122    <input type='text' size='40' name='form_ndc_number' maxlength='20' value='<? echo $row['ndc_number'] ?>' style='width:100%' />
 123   </td>
 124  </tr>
 125
 126  <tr>
 127   <td valign='top' nowrap><b><? xl('On Order','e'); ?>:</b></td>
 128   <td>
 129    <input type='text' size='5' name='form_on_order' maxlength='7' value='<? echo $row['on_order'] ?>' />
 130   </td>
 131  </tr>
 132
 133  <tr>
 134   <td valign='top' nowrap><b><? xl('Reorder At','e'); ?>:</b></td>
 135   <td>
 136    <input type='text' size='5' name='form_reorder_point' maxlength='7' value='<? echo $row['reorder_point'] ?>' />
 137   </td>
 138  </tr>
 139
 140  <!--
 141  <tr>
 142   <td valign='top' nowrap><b><? xl('Reactions','e'); ?>:</b></td>
 143   <td>
 144    <input type='text' size='40' name='form_reactions' maxlength='250' value='<? echo $row['reactions'] ?>' style='width:100%' />
 145   </td>
 146  </tr>
 147  -->
 148
 149  <tr>
 150   <td valign='top' nowrap><b><? xl('Form','e'); ?>:</b></td>
 151   <td>
 152    <select name='form_form'>
 153 <?php
 154  foreach ($form_array as $key => $value) {
 155   echo "   <option value='$key'";
 156   if ($key == $row['form']) echo " selected";
 157   echo ">$value\n";
 158  }
 159 ?>
 160    </select>
 161   </td>
 162  </tr>
 163
 164  <tr>
 165   <td valign='top' nowrap><b><? xl('Schedule','e'); ?>:</b></td>
 166   <td>
 167    <input type='text' size='10' name='form_dosage' maxlength='10' value='<? echo $row['dosage'] ?>' />
 168   </td>
 169  </tr>
 170
 171  <tr>
 172   <td valign='top' nowrap><b><? xl('Pill Size','e'); ?>:</b></td>
 173   <td>
 174    <input type='text' size='5' name='form_size' maxlength='7' value='<? echo $row['size'] ?>' />
 175   </td>
 176  </tr>
 177
 178  <tr>
 179   <td valign='top' nowrap><b><? xl('Units','e'); ?>:</b></td>
 180   <td>
 181    <select name='form_unit'>
 182 <?php
 183  foreach ($unit_array as $key => $value) {
 184   echo "   <option value='$key'";
 185   if ($key == $row['unit']) echo " selected";
 186   echo ">$value\n";
 187  }
 188 ?>
 189    </select>
 190   </td>
 191  </tr>
 192
 193  <tr>
 194   <td valign='top' nowrap><b><? xl('Route','e'); ?>:</b></td>
 195   <td>
 196    <select name='form_route'>
 197 <?php
 198  foreach ($route_array as $key => $value) {
 199   echo "   <option value='$key'";
 200   if ($key == $row['route']) echo " selected";
 201   echo ">$value\n";
 202  }
 203 ?>
 204    </select>
 205   </td>
 206  </tr>
 207
 208  <tr>
 209   <td valign='top' nowrap><b><? xl('Interval','e'); ?>:</b></td>
 210   <td>
 211    <select name='form_period'>
 212 <?php
 213  foreach ($interval_array as $key => $value) {
 214   echo "   <option value='$key'";
 215   if ($key == $row['period']) echo " selected";
 216   echo ">$value\n";
 217  }
 218 ?>
 219    </select>
 220   </td>
 221  </tr>
 222
 223  <!--
 224  <tr>
 225   <td valign='top' nowrap><b><? xl('Substitution','e'); ?>:</b></td>
 226   <td>
 227    <select name='form_substitute'>
 228 <?php
 229  foreach ($substitute_array as $key => $value) {
 230   echo "   <option value='$key'";
 231   if ($key == $row['substitute']) echo " selected";
 232   echo ">$value\n";
 233  }
 234 ?>
 235    </select>
 236   </td>
 237  </tr>
 238  -->
 239
 240  <tr>
 241   <td valign='top' nowrap><b><? xl('Quantity','e'); ?>:</b></td>
 242   <td>
 243    <input type='text' size='5' name='form_quantity' maxlength='7' value='<? echo $row['quantity'] ?>' />
 244   </td>
 245  </tr>
 246
 247  <!--
 248  <tr>
 249   <td valign='top' nowrap><b><? xl('Refills','e'); ?>:</b></td>
 250   <td>
 251    <input type='text' size='5' name='form_refills' maxlength='7' value='<? echo $row['refills'] ?>' />
 252   </td>
 253  </tr>
 254  <tr>
 255   <td valign='top' nowrap><b><? xl('Per Refill','e'); ?>:</b></td>
 256   <td>
 257    <input type='text' size='5' name='form_per_refill' maxlength='7' value='<? echo $row['per_refill'] ?>' />
 258   </td>
 259  </tr>
 260  -->
 261
 262 </table>
 263
 264 <p>
 265 <input type='submit' name='form_save' value='Save' />
 266
 267 &nbsp;
 268 <input type='submit' name='form_delete' value='Delete' style='color:red' />
 269
 270 &nbsp;
 271 <input type='button' value='Cancel' onclick='window.close()' />
 272 </p>
 273
 274 </center>
 275 </form>
 276 </body>
 277 </html>