library/ADODB_mysqli_log.php

   1 <?php
   2
   3 /**
   4  * ADODB custom wrapper class to support auditing engine in main.
   5  *
   6  * @package   OpenEMR
   7  * @link      https://www.open-emr.org
   8  * @author    Kevin Yeh <kevin.y@integralemr.com>
   9  * @author    Brady Miller <brady.g.miller@gmail.com>
  10  * @copyright Copyright (c) 2017 Brady Miller <brady.g.miller@gmail.com>
  11  * @license   https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  12  */
  13
  14 use OpenEMR\Common\Logging\EventAuditLogger;
  15
  16 class ADODB_mysqli_log extends ADODB_mysqli
  17 {
  18     /**
  19      * ADODB Execute function wrapper to ensure proper auditing in OpenEMR.
  20      *
  21      * @param  string  $sql         query
  22      * @param  array   $inputarr    binded variables array (optional)
  23      * @return boolean              returns false if error
  24      */
  25     function Execute($sql, $inputarr = false, $insertNeedReturn = false)
  26     {
  27         $retval = parent::Execute($sql, $inputarr);
  28         if ($retval === false) {
  29             $outcome = false;
  30             // Stash the error into last_mysql_error so it doesn't get clobbered when
  31             // we insert into the audit log.
  32             $GLOBALS['last_mysql_error'] = $this->ErrorMsg();
  33
  34             // Last error no
  35             $GLOBALS['last_mysql_error_no'] = $this->ErrorNo();
  36         } else {
  37             $outcome = true;
  38         }
  39
  40         // Stash the insert ID into lastidado so it doesn't get clobbered when
  41         // we insert into the audit log.
  42         if ($insertNeedReturn) {
  43             $GLOBALS['lastidado'] = $this->Insert_ID();
  44         }
  45         EventAuditLogger::instance()->auditSQLEvent($sql, $outcome, $inputarr);
  46         return $retval;
  47     }
  48
  49     /**
  50      * ADODB Execute function wrapper to skip auditing in OpenEMR.
  51      *
  52      * Bypasses the OpenEMR auditing engine.
  53      *
  54      * @param  string  $sql         query
  55      * @param  array   $inputarr    binded variables array (optional)
  56      * @return boolean              returns false if error
  57      */
  58     function ExecuteNoLog($sql, $inputarr = false)
  59     {
  60         return parent::Execute($sql, $inputarr);
  61     }
  62 }