admin.php

   1 <?php
   2
   3 /**
   4  *
   5  * Multi Site Administration script.
   6  *
   7  * @package OpenEMR
   8  * @link    https://www.open-emr.org
   9  * @author Rod Roark <rod@sunsetsystems.com>
  10  * @author Ranganath Pathak <pathak@scrs1.org>
  11  * @copyright Copyright (C) 2010 Rod Roark <rod@sunsetsystems.com>
  12  * @copyright Copyright (c) 2019 Ranganath Pathak <pathak@scrs1.org>
  13  * @license https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  14  */
  15
  16 // Checks if the server's PHP version is compatible with OpenEMR:
  17 require_once(dirname(__FILE__) . "/src/Common/Compatibility/Checker.php");
  18 $response = OpenEMR\Common\Compatibility\Checker::checkPhpVersion();
  19 if ($response !== true) {
  20     die(htmlspecialchars($response));
  21 }
  22
  23 require_once "version.php";
  24
  25 $webserver_root = dirname(__FILE__);
  26 if (stripos(PHP_OS, 'WIN') === 0) {
  27     $webserver_root = str_replace("\\", "/", $webserver_root);
  28 }
  29
  30 $OE_SITES_BASE = "$webserver_root/sites";
  31
  32 function sqlQuery($statement, $link)
  33 {
  34     $row = mysqli_fetch_array(mysqli_query($link, $statement), MYSQLI_ASSOC);
  35     return $row;
  36 }
  37 ?>
  38 <html>
  39 <head>
  40     <title>OpenEMR Site Administration</title>
  41     <meta name="viewport" content="width=device-width, initial-scale=1.0">
  42     <link rel="stylesheet" href="public/assets/bootstrap/dist/css/bootstrap.min.css">
  43     <script src="public/assets/jquery/dist/jquery.min.js"></script>
  44     <script src="public/assets/bootstrap/dist/js/bootstrap.bundle.min.js"></script>
  45     <link rel="stylesheet" href="public/assets/@fortawesome/fontawesome-free/css/all.min.css">
  46     <link rel="shortcut icon" href="public/images/favicon.ico" />
  47 </head>
  48 <body>
  49     <div class='container mt-3'>
  50         <div class="row">
  51             <div class="col-12">
  52                 <div class="d-flex justify-content-between align-items-center">
  53                     <h2>OpenEMR Multi Site Administration</h2>
  54                     <a class="text-secondary" data-target="#myModal" data-toggle="modal" href="#" id="help-href" name="help-href">
  55                         <i class="fa fa-question-circle fa-lg" aria-hidden="true" data-toggle="tooltip" data-placement="top" title="Click to view Help"></i>
  56                     </a>
  57                 </div>
  58             </div>
  59         </div>
  60
  61         <div class="row">
  62             <div class="col-sm-12">
  63                 <div class="table-responsive">
  64                     <table class='table table-striped text-center'>
  65                         <tr>
  66                             <th>Site ID</th>
  67                             <th>DB Name</th>
  68                             <th>Site Name</th>
  69                             <th>Version</th>
  70                             <th>Is Current</th>
  71                             <th>Log In</th>
  72                             <th>Patient Portal</th>
  73                         </tr>
  74                         <?php
  75                         $dh = opendir($OE_SITES_BASE);
  76                         if (!$dh) {
  77                             die("Cannot read directory '$OE_SITES_BASE'.");
  78                         }
  79
  80                         $siteslist = array();
  81
  82                         while (false !== ($sfname = readdir($dh))) {
  83                             if (substr($sfname, 0, 1) == '.') {
  84                                 continue;
  85                             }
  86
  87                             if ($sfname == 'CVS') {
  88                                 continue;
  89                             }
  90
  91                             $sitedir = "$OE_SITES_BASE/$sfname";
  92                             if (!is_dir($sitedir)) {
  93                                 continue;
  94                             }
  95
  96                             if (!is_file("$sitedir/sqlconf.php")) {
  97                                 continue;
  98                             }
  99
 100                             $siteslist[$sfname] = $sfname;
 101                         }
 102
 103                         closedir($dh);
 104                         ksort($siteslist);
 105
 106                         $encount = 0;
 107                         foreach ($siteslist as $sfname) {
 108                             $sitedir = "$OE_SITES_BASE/$sfname";
 109                             $errmsg = '';
 110                             ++$encount;
 111
 112                             echo " <tr>\n";
 113
 114                         // Access the site's database.
 115                             include "$sitedir/sqlconf.php";
 116
 117                             if ($config) {
 118                                 $dbh = mysqli_connect("$host", "$login", "$pass", $dbase, $port);
 119                                 if (!$dbh) {
 120                                     $errmsg = "MySQL connect failed";
 121                                 }
 122                             }
 123
 124                             echo "  <td>" . htmlspecialchars($sfname, ENT_NOQUOTES) . "</td>\n";
 125                             echo "  <td>" . htmlspecialchars($dbase, ENT_NOQUOTES) . "</td>\n";
 126
 127                             if (!$config) {
 128                                 echo "  <td colspan='3'><a href='setup.php?site=" . htmlspecialchars(urlencode($sfname), ENT_QUOTES) . "' class='text-decoration-none'>Needs setup, click here to run it</a></td>\n";
 129                             } elseif ($errmsg) {
 130                                 echo "  <td colspan='3' class='text-danger'>" . htmlspecialchars($errmsg, ENT_NOQUOTES) . "</td>\n";
 131                             } else {
 132                                 // Get site name for display.
 133                                 $row = sqlQuery("SELECT gl_value FROM globals WHERE gl_name = 'openemr_name' LIMIT 1", $dbh);
 134                                 $openemr_name = $row ? $row['gl_value'] : '';
 135
 136                                 // Get version indicators from the database.
 137                                 $row = sqlQuery("SHOW TABLES LIKE 'version'", $dbh);
 138                                 if (empty($row)) {
 139                                     $openemr_version = 'Unknown';
 140                                     $database_version = 0;
 141                                 } else {
 142                                     $row = sqlQuery("SELECT * FROM version LIMIT 1", $dbh);
 143                                     $database_patch_txt = "";
 144                                     if (!(empty($row['v_realpatch'])) && $row['v_realpatch'] != 0) {
 145                                         $database_patch_txt = " (" . $row['v_realpatch'] . ")";
 146                                     }
 147
 148                                     $openemr_version = $row['v_major'] . "." . $row['v_minor'] . "." .
 149                                     $row['v_patch'] . $row['v_tag'] . $database_patch_txt;
 150                                     $database_version = 0 + $row['v_database'];
 151                                     $database_acl = 0 + $row['v_acl'];
 152                                     $database_patch = 0 + $row['v_realpatch'];
 153                                 }
 154
 155                                 // Display relevant columns.
 156                                 echo "  <td>" . htmlspecialchars($openemr_name, ENT_NOQUOTES) . "</td>\n";
 157                                 echo "  <td>" . htmlspecialchars($openemr_version, ENT_NOQUOTES) . "</td>\n";
 158                                 if ($v_database != $database_version) {
 159                                     echo "  <td><a href='sql_upgrade.php?site=" . htmlspecialchars(urlencode($sfname), ENT_QUOTES) . "' class='text-decoration-none'>Upgrade Database</a></td>\n";
 160                                 } elseif (($v_acl > $database_acl)) {
 161                                     echo "  <td><a href='acl_upgrade.php?site=" . htmlspecialchars(urlencode($sfname), ENT_QUOTES) . "' class='text-decoration-none'>Upgrade Access Controls</a></td>\n";
 162                                 } elseif (($v_realpatch != $database_patch)) {
 163                                     echo "  <td><a href='sql_patch.php?site=" . htmlspecialchars(urlencode($sfname), ENT_QUOTES) . "' class='text-decoration-none'>Patch Database</a></td>\n";
 164                                 } else {
 165                                     echo "  <td><i class='fa fa-check fa-lg text-success' aria-hidden='true' ></i></a></td>\n";
 166                                 }
 167                                 if (($v_database == $database_version) && ($v_acl <= $database_acl) && ($v_realpatch == $database_patch)) {
 168                                     echo "  <td><a href='interface/login/login.php?site=" . htmlspecialchars(urlencode($sfname), ENT_QUOTES) . "' class='text-decoration-none'><i class='fa fa-sign-in-alt fa-lg' aria-hidden='true' data-toggle='tooltip' data-placement='top' title ='Login to site " . htmlspecialchars($sfname, ENT_QUOTES) . "'></i></a></td>\n";
 169                                     echo "  <td><a href='portal/index.php?site=" . htmlspecialchars(urlencode($sfname), ENT_QUOTES) . "' class='text-decoration-none'><i class='fa fa-sign-in-alt fa-lg' aria-hidden='true' data-toggle='tooltip' data-placement='top' title ='Login to site " . htmlspecialchars($sfname, ENT_QUOTES) . "'></i></a></td>\n";
 170                                 } else {
 171                                     echo "  <td><i class='fa fa-ban fa-lg text-secondary' aria-hidden='true'></i></td>\n";
 172                                     echo "  <td><i class='fa fa-ban fa-lg text-secondary' aria-hidden='true'></i></td>\n";
 173                                 }
 174                             }
 175
 176                             echo " </tr>\n";
 177
 178                             if ($config && $dbh !== false) {
 179                                 mysqli_close($dbh);
 180                             }
 181                         }
 182                         ?>
 183                     </table>
 184                 </div>
 185                 <form method='post' action='setup.php'>
 186                     <button type='submit' class='btn btn-primary font-weight-bold' name='form_submit' value='Add New Site'>Add New Site</button>
 187                 </form>
 188             </div>
 189         </div>
 190     </div><!--end of container div-->
 191
 192     <div class="row">
 193         <div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
 194             <div class="modal-dialog modal-lg">
 195                 <div class="modal-content" style="height:700px">
 196                     <div class="modal-header clearfix">
 197                         <button type="button" class="close" data-dismiss="modal" aria-label="Close">
 198                             <span aria-hidden="true" style="color:var(--black); font-size:1.5em;">×</span>
 199                         </button>
 200                     </div>
 201                         <div class="modal-body" style="height:80%;">
 202                             <iframe src="" id="targetiframe" class="h-100 w-100" style="overflow-x: hidden; border:none"
 203                                 allowtransparency="true"></iframe>
 204                         </div>
 205                     <div class="modal-footer mt-0">
 206                         <button class="btn btn-secondary" data-dismiss="modal" type="button">Close</button>
 207                     </div>
 208                 </div>
 209             </div>
 210         </div>
 211     </div>
 212     <script>
 213         $(function () {
 214             $('#help-href').click (function() {
 215                 document.getElementById('targetiframe').src = "Documentation/help_files/openemr_multisite_admin_help.php";
 216             });
 217         });
 218         $(function () {
 219             $('#print-help-href').click (function(){
 220                 $("#targetiframe").get(0).contentWindow.print();
 221             });
 222         });
 223         $(function () {
 224             $('[data-toggle="tooltip"]').tooltip();
 225         });
 226         // Jquery draggable
 227         $(".modal-dialog").addClass('drag-action');
 228         $(".modal-content").addClass('resize-action');
 229     </script>
 230 </body>
 231 </html>