EVOLUTION-MANAGER

Edit File: sql_patch.php

<?php
// Copyright (C) 2008-2010 Rod Roark <rod@sunsetsystems.com>
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This may be run after an upgraded OpenEMR has been installed.
// Its purpose is to upgrade the MySQL OpenEMR database as needed
// for the new release.

// Checks if the server's PHP version is compatible with OpenEMR:
require_once(dirname(__FILE__) . "/common/compatibility/Checker.php");

use OpenEMR\Common\Checker;

$response = Checker::checkPhpVersion();
if ($response !== true) {
    die($response);
}

// Disable PHP timeout.  This will not work in safe mode.
ini_set('max_execution_time', '0');

$ignoreAuth = true; // no login required

require_once('interface/globals.php');
require_once('library/sql_upgrade_fx.php');

use OpenEMR\Services\VersionService;

$versionService = new VersionService();

// Fetching current version because it was updated by the sql_upgrade_fx
// script and this script will further modify it.
$currentVersion = $versionService->fetch();

$desiredVersion = $currentVersion;
$desiredVersion->setDatabase($v_database);
$desiredVersion->setTag($v_tag);
$desiredVersion->setRealPatch($v_realpatch);
$desiredVersion->setPatch($v_patch);
$desiredVersion->setMinor($v_minor);
$desiredVersion->setMajor($v_major);

// Force logging off
$GLOBALS["enable_auditlog"]=0;

$EMRversion = trim(preg_replace('/\s*$[^)]*$/', '', $GLOBALS['openemr_version']));
?>

<html>
<head>
<title>OpenEMR <?php echo attr($EMRversion) ?> <?php echo xlt('Database Patch'); ?></title>
<link rel='STYLESHEET' href='interface/themes/style_blue.css'>
<link rel="shortcut icon" href="public/images/favicon.ico" />
</head>
<body style="color:green;">

OpenEMR <?php echo text($EMRversion),' ',xlt('Database Patch'),' ',text($desiredVersion->getRealPatch()) ?>
 <?php echo xlt('Applying Patch to site'),' : ',text($_SESSION['site_id']) ?>

<?php
 upgradeFromSqlFile('patch.sql');
 flush();

echo '',xlt('Updating global configuration defaults'),'...';
 require_once("library/globals.inc.php");
 foreach ($GLOBALS_METADATA as $grpname => $grparr) {
 foreach ($grparr as $fldid => $fldarr) {
 list($fldname, $fldtype, $flddef, $flddesc) = $fldarr;
 if (is_array($fldtype) || (substr($fldtype, 0, 2) !== 'm_')) {
 $row = sqlQuery("SELECT count(*) AS count FROM globals WHERE gl_name = '$fldid'");
 if (empty($row['count'])) {
 sqlStatement("INSERT INTO globals ( gl_name, gl_index, gl_value ) " .
 "VALUES ( '$fldid', '0', '$flddef' )");
 }
 }
 }
 }

$canRealPatchBeApplied = $versionService->canRealPatchBeApplied($desiredVersion);
 if ($canRealPatchBeApplied) {
 echo '',xlt('Updating version indicators'),'...';
 $result = $versionService->update($desiredVersion);

if (!$result) {
 echo '',xlt('Unable insert version information into database'),'...';
 }
 }

echo '',xlt('Database Patch'),' ',text($desiredVersion->getRealPatch()),' ',xlt('finished'),'.';

echo 'OpenEMR ',xlt('Version'),' = ',text($EMRversion.'('.$desiredVersion->getRealPatch().')'),'.';

echo '<a style="border-radius: 10px; padding:5px; width:200px; margin:0 auto; background-color:green; color:white; font-weight:bold; display:block; text-align:center;" href="index.php?site=',attr($_SESSION['site_id']).'">',xlt('Log in'),'</a>';

if (isset($_SERVER['HTTP_REFERER'])) {
 $split = preg_split('/\//', $_SERVER['HTTP_REFERER']);
 if ($split[count($split) - 1] == 'admin.php') {
 echo '<a style="border-radius: 10px; padding:5px; width:200px; margin:0 auto; background-color:green; color:white; font-weight:bold; display:block; text-align:center;" href="admin.php">',xlt('Back to Admin Page'),'</a>';
 }
 }

?>
</div>
</body>
</html>