interface/code_systems/list_installed.php

   1 <?php
   2 /**
   3  * This file implements the main jquery interface for loading external
   4  * database files into openEMR
   5  *
   6  * Copyright (C) 2012 Patient Healthcare Analytics, Inc.
   7  * Copyright (C) 2011 Phyaura, LLC <info@phyaura.com>
   8  *
   9  * LICENSE: This program is free software; you can redistribute it and/or
  10  * modify it under the terms of the GNU General Public License
  11  * as published by the Free Software Foundation; either version 2
  12  * of the License, or (at your option) any later version.
  13  * This program is distributed in the hope that it will be useful,
  14  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  15  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  16  * GNU General Public License for more details.
  17  * You should have received a copy of the GNU General Public License
  18  * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
  19  *
  20  * @package OpenEMR
  21  * @author  (Mac) Kevin McAloon <mcaloon@patienthealthcareanalytics.com>
  22  * @author  Rohit Kumar <pandit.rohit@netsity.com>
  23  * @author  Brady Miller <brady@sparmy.com>
  24  * @link    http://www.open-emr.org
  25  */
  26
  27
  28 //SANITIZE ALL ESCAPES
  29 $sanitize_all_escapes=true;
  30 //
  31
  32 //STOP FAKE REGISTER GLOBALS
  33 $fake_register_globals=false;
  34 //
  35
  36 require_once("../../interface/globals.php");
  37 require_once("$srcdir/acl.inc");
  38
  39 // Control access
  40 if (!acl_check('admin', 'super')) {
  41     echo xlt('Not Authorized');
  42     exit;
  43 }
  44
  45 $db = isset($_GET['db']) ? $_GET['db'] : '0';
  46
  47 // For now, only order by the revision_date. When have different formats of a code type (such as WHO vs CMS for ICD10 or different languages for SNOMED, then will incorporate this field)
  48 $rez = sqlStatement("SELECT DATE_FORMAT(`revision_date`,'%Y-%m-%d') as `revision_date`, `revision_version`, `name` FROM `standardized_tables_track` WHERE upper(`name`) = ? ORDER BY `revision_date` DESC", array($db) );
  49 for($iter=0; $row=sqlFetchArray($rez); $iter++) {
  50     $sqlReturn[$iter]=$row;
  51 }
  52
  53 if (empty($sqlReturn)) {
  54 ?>
  55     <div class="stg"><?php echo xlt("Not installed"); ?></div>
  56 <?php
  57 } else {
  58     if ($sqlReturn[0]['name'] == 'SNOMED' && $sqlReturn[0]['revision_version'] == 'US Extension') {
  59         // If using the SNOMED US Extension package, then show the preceding SNOMED International Package information first
  60 ?>
  61         <div class="atr"><?php echo xlt("Name") . ": " . text($sqlReturn[1]['name']); ?> </div>
  62         <div class="atr"><?php echo xlt("Revision") . ": " . text($sqlReturn[1]['revision_version']); ?> </div>
  63         <div class="atr"><?php echo xlt("Release Date") . ": " . text($sqlReturn[1]['revision_date']); ?> </div>
  64         <br>
  65 <?php
  66     }
  67     // Always show the first item of query results
  68 ?>
  69     <div class="atr"><?php echo xlt("Name") . ": " . text($sqlReturn[0]['name']); ?> </div>
  70     <div class="atr"><?php echo xlt("Revision") . ": " . text($sqlReturn[0]['revision_version']); ?> </div>
  71     <div class="atr"><?php echo xlt("Release Date") . ": " . text($sqlReturn[0]['revision_date']); ?> </div>
  72 <?php
  73 }
  74 ?>