interface/drugs/drug_inventory.php

   1 <?php
   2  // Copyright (C) 2006-2016 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  $sanitize_all_escapes  = true;
  10  $fake_register_globals = false;
  11
  12  require_once("../globals.php");
  13  require_once("$srcdir/acl.inc");
  14  require_once("drugs.inc.php");
  15  require_once("$srcdir/options.inc.php");
  16  require_once("$srcdir/formatting.inc.php");
  17
  18  // Check authorization.
  19  $thisauth = acl_check('admin', 'drugs');
  20  if (!$thisauth) die(xlt('Not authorized'));
  21
  22 // For each sorting option, specify the ORDER BY argument.
  23 //
  24 $ORDERHASH = array(
  25   'prod' => 'd.name, d.drug_id, di.expiration, di.lot_number',
  26   'ndc'  => 'd.ndc_number, d.name, d.drug_id, di.expiration, di.lot_number',
  27   'form' => 'lof.title, d.name, d.drug_id, di.expiration, di.lot_number',
  28   'lot'  => 'di.lot_number, d.name, d.drug_id, di.expiration',
  29   'wh'   => 'lo.title, d.name, d.drug_id, di.expiration, di.lot_number',
  30   'qoh'  => 'di.on_hand, d.name, d.drug_id, di.expiration, di.lot_number',
  31   'exp'  => 'di.expiration, d.name, d.drug_id, di.lot_number',
  32 );
  33
  34 // Get the order hash array value and key for this request.
  35 $form_orderby = $ORDERHASH[$_REQUEST['form_orderby']] ? $_REQUEST['form_orderby'] : 'prod';
  36 $orderby = $ORDERHASH[$form_orderby];
  37
  38  // get drugs
  39  $res = sqlStatement("SELECT d.*, " .
  40   "di.inventory_id, di.lot_number, di.expiration, di.manufacturer, " .
  41   "di.on_hand, lo.title " .
  42   "FROM drugs AS d " .
  43   "LEFT JOIN drug_inventory AS di ON di.drug_id = d.drug_id " .
  44   "AND di.destroy_date IS NULL " .
  45   "LEFT JOIN list_options AS lo ON lo.list_id = 'warehouse' AND " .
  46   "lo.option_id = di.warehouse_id AND lo.activity = 1 " .
  47   "LEFT JOIN list_options AS lof ON lof.list_id = 'drug_form' AND " .
  48   "lof.option_id = d.form AND lof.activity = 1 " .
  49   "ORDER BY $orderby");
  50 ?>
  51 <html>
  52
  53 <head>
  54 <?php html_header_show();?>
  55
  56 <link rel="stylesheet" href='<?php  echo $css_header ?>' type='text/css'>
  57 <title><?php echo xlt('Drug Inventory'); ?></title>
  58
  59 <style>
  60 tr.head   { font-size:10pt; background-color:#cccccc; text-align:center; }
  61 tr.detail { font-size:10pt; }
  62 a, a:visited, a:hover { color:#0000cc; }
  63
  64 table.mymaintable, table.mymaintable td {
  65  border: 1px solid #aaaaaa;
  66  border-collapse: collapse;
  67 }
  68 table.mymaintable td {
  69  padding: 1pt 4pt 1pt 4pt;
  70 }
  71 </style>
  72
  73 <script type="text/javascript" src="../../library/dialog.js?v=<?php echo $v_js_includes; ?>"></script>
  74 <script type="text/javascript" src="<?php echo $GLOBALS['assets_static_relative']; ?>/jquery-min-1-9-1/index.js"></script>
  75 <script type="text/javascript" src="../../library/js/report_helper.js?v=<?php echo $v_js_includes; ?>"></script>
  76
  77 <script language="JavaScript">
  78
  79 // callback from add_edit_drug.php or add_edit_drug_inventory.php:
  80 function refreshme() {
  81  location.reload();
  82 }
  83
  84 // Process click on drug title.
  85 function dodclick(id) {
  86  dlgopen('add_edit_drug.php?drug=' + id, '_blank', 725, 475);
  87 }
  88
  89 // Process click on drug QOO or lot.
  90 function doiclick(id, lot) {
  91  dlgopen('add_edit_lot.php?drug=' + id + '&lot=' + lot, '_blank', 600, 475);
  92 }
  93
  94 // Process click on a column header for sorting.
  95 function dosort(orderby) {
  96  var f = document.forms[0];
  97  f.form_orderby.value = orderby;
  98  top.restoreSession();
  99  f.submit();
 100  return false;
 101 }
 102
 103 $(document).ready(function() {
 104   oeFixedHeaderSetup(document.getElementById('mymaintable'));
 105 });
 106
 107 </script>
 108
 109 </head>
 110
 111 <body class="body_top">
 112 <form method='post' action='drug_inventory.php'>
 113
 114 <table width='100%' id='mymaintable' class='mymaintable'>
 115  <thead>
 116  <tr class='head'>
 117   <td title='<?php echo xla('Click to edit'); ?>'>
 118    <a href="#" onclick="return dosort('prod')"
 119    <?php if ($form_orderby == "prod") echo " style=\"color:#00cc00\""; ?>>
 120    <?php echo xlt('Name'); ?> </a>
 121   </td>
 122   <td>
 123    <?php echo xlt('Act'); ?>
 124   </td>
 125   <td>
 126    <a href="#" onclick="return dosort('ndc')"
 127    <?php if ($form_orderby == "ndc") echo " style=\"color:#00cc00\""; ?>>
 128    <?php echo xlt('NDC'); ?> </a>
 129   </td>
 130   <td>
 131    <a href="#" onclick="return dosort('form')"
 132    <?php if ($form_orderby == "form") echo " style=\"color:#00cc00\""; ?>>
 133    <?php echo xlt('Form'); ?> </a>
 134   </td>
 135   <td>
 136    <?php echo xlt('Size'); ?>
 137   </td>
 138   <td>
 139    <?php echo xlt('Unit'); ?>
 140   </td>
 141   <td title='<?php echo xla('Click to receive (add) new lot'); ?>'>
 142    <?php echo xlt('New'); ?>
 143   </td>
 144   <td title='<?php echo xla('Click to edit'); ?>'>
 145    <a href="#" onclick="return dosort('lot')"
 146    <?php if ($form_orderby == "lot") echo " style=\"color:#00cc00\""; ?>>
 147    <?php echo xlt('Lot'); ?> </a>
 148   </td>
 149   <td>
 150    <a href="#" onclick="return dosort('wh')"
 151    <?php if ($form_orderby == "wh") echo " style=\"color:#00cc00\""; ?>>
 152    <?php echo xlt('Warehouse'); ?> </a>
 153   </td>
 154   <td>
 155    <a href="#" onclick="return dosort('qoh')"
 156    <?php if ($form_orderby == "qoh") echo " style=\"color:#00cc00\""; ?>>
 157    <?php echo xlt('QOH'); ?> </a>
 158   </td>
 159   <td>
 160    <a href="#" onclick="return dosort('exp')"
 161    <?php if ($form_orderby == "exp") echo " style=\"color:#00cc00\""; ?>>
 162    <?php echo xlt('Expires'); ?> </a>
 163   </td>
 164  </tr>
 165  </thead>
 166  <tbody>
 167 <?php
 168  $lastid = "";
 169  $encount = 0;
 170  while ($row = sqlFetchArray($res)) {
 171   if ($lastid != $row['drug_id']) {
 172    ++$encount;
 173    $bgcolor = "#" . (($encount & 1) ? "ddddff" : "ffdddd");
 174    $lastid = $row['drug_id'];
 175    echo " <tr class='detail' bgcolor='$bgcolor'>\n";
 176    echo "  <td onclick='dodclick(".attr($lastid).")'>" .
 177     "<a href='' onclick='return false'>" .
 178     text($row['name']) . "</a></td>\n";
 179    echo "  <td>" . ($row['active'] ? xlt('Yes') : xlt('No')) . "</td>\n";
 180    echo "  <td>" . text($row['ndc_number']) . "</td>\n";
 181    echo "  <td>" .
 182         generate_display_field(array('data_type'=>'1','list_id'=>'drug_form'), $row['form']) .
 183         "</td>\n";
 184    echo "  <td>" . text($row['size']) . "</td>\n";
 185    echo "  <td>" .
 186         generate_display_field(array('data_type'=>'1','list_id'=>'drug_units'), $row['unit']) .
 187         "</td>\n";
 188    echo "  <td onclick='doiclick(".attr($lastid).",0)' title='" . xla('Add new lot and transaction') . "'>" .
 189     "<a href='' onclick='return false'>" . xlt('New') . "</a></td>\n";
 190   } else {
 191    echo " <tr class='detail' bgcolor='$bgcolor'>\n";
 192    echo "  <td colspan='7'>&nbsp;</td>\n";
 193   }
 194   if (!empty($row['inventory_id'])) {
 195    echo "  <td onclick='doiclick(" . attr($lastid) . "," . attr($row['inventory_id']) . ")'>" .
 196     "<a href='' onclick='return false'>" . text($row['lot_number']) . "</a></td>\n";
 197    echo "  <td>" . text($row['title']) . "</td>\n";
 198    echo "  <td>" . text($row['on_hand']) . "</td>\n";
 199    echo "  <td>" . text(oeFormatShortDate($row['expiration'])) . "</td>\n";
 200   } else {
 201    echo "  <td colspan='4'>&nbsp;</td>\n";
 202   }
 203   echo " </tr>\n";
 204  } // end while
 205 ?>
 206  </tbody>
 207 </table>
 208
 209 <center><p>
 210  <input type='button' value='<?php echo xla('Add Drug'); ?>' onclick='dodclick(0)' />
 211 </p></center>
 212
 213 <input type="hidden" name="form_orderby" value="<?php echo attr($form_orderby) ?>" />
 214
 215 </form>
 216 </body>
 217 </html>