interface/code_systems/list_installed.php

   1 <?php
   2
   3 /**
   4  * This file implements the main jquery interface for loading external
   5  * database files into openEMR
   6  *
   7  * Copyright (C) 2012 Patient Healthcare Analytics, Inc.
   8  * Copyright (C) 2011 Phyaura, LLC <info@phyaura.com>
   9  *
  10  * LICENSE: This program is free software; you can redistribute it and/or
  11  * modify it under the terms of the GNU General Public License
  12  * as published by the Free Software Foundation; either version 2
  13  * of the License, or (at your option) any later version.
  14  * This program is distributed in the hope that it will be useful,
  15  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  16  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  17  * GNU General Public License for more details.
  18  * You should have received a copy of the GNU General Public License
  19  * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
  20  *
  21  * @package OpenEMR
  22  * @author  (Mac) Kevin McAloon <mcaloon@patienthealthcareanalytics.com>
  23  * @author  Rohit Kumar <pandit.rohit@netsity.com>
  24  * @author  Brady Miller <brady.g.miller@gmail.com>
  25  * @link    http://www.open-emr.org
  26  */
  27
  28 require_once("../../interface/globals.php");
  29
  30 use OpenEMR\Common\Acl\AclMain;
  31
  32 // Control access
  33 if (!AclMain::aclCheckCore('admin', 'super')) {
  34     echo xlt('Not Authorized');
  35     exit;
  36 }
  37
  38 $db = isset($_GET['db']) ? $_GET['db'] : '0';
  39
  40 // Ordering by the imported_date with tiebreaker being the revision_date
  41 $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 `imported_date` DESC, `revision_date` DESC", array($db));
  42 for ($iter = 0; $row = sqlFetchArray($rez); $iter++) {
  43     $sqlReturn[$iter] = $row;
  44 }
  45
  46 if (empty($sqlReturn)) {
  47     ?>
  48     <div class="stg"><?php echo xlt("Not installed"); ?></div>
  49     <?php
  50 } else {
  51     if ($sqlReturn[0]['name'] == 'SNOMED' && $sqlReturn[0]['revision_version'] == 'US Extension') {
  52         // If using the SNOMED US Extension package, then show the preceding SNOMED International Package information first
  53         ?>
  54         <div class="atr"><?php echo xlt("Name") . ": " . text($sqlReturn[1]['name']); ?> </div>
  55         <div class="atr"><?php echo xlt("Revision") . ": " . text($sqlReturn[1]['revision_version']); ?> </div>
  56         <div class="atr"><?php echo xlt("Release Date") . ": " . text($sqlReturn[1]['revision_date']); ?> </div>
  57         <br />
  58         <?php
  59     }
  60
  61     // Always show the first item of query results
  62     ?>
  63     <div class="atr"><?php echo xlt("Name") . ": " . text($sqlReturn[0]['name']); ?> </div>
  64     <div class="atr"><?php echo xlt("Revision") . ": " . text($sqlReturn[0]['revision_version']); ?> </div>
  65     <div class="atr"><?php echo xlt("Release Date") . ": " . text($sqlReturn[0]['revision_date']); ?> </div>
  66     <?php
  67 }
  68 ?>