interface/weno/drugDataInsert.php

   1 <?php
   2
   3 /**
   4  * weno drug paid insert
   5  *
   6  * @package OpenEMR
   7  * @link    http://www.open-emr.org
   8  * @author  Sherwin Gaddis <sherwingaddis@gmail.com>
   9  * @author    Brady Miller <brady.g.miller@gmail.com>
  10  * @copyright Copyright (c) 2016-2017 Sherwin Gaddis <sherwingaddis@gmail.com>
  11  * @copyright Copyright (c) 2018 Brady Miller <brady.g.miller@gmail.com>
  12  * @license https://github.com/openemr/openemr/blob/master/LICENSE GNU General Public License 3
  13  */
  14
  15 require_once('../globals.php');
  16
  17 use OpenEMR\Common\Acl\AclMain;
  18 use OpenEMR\Common\Csrf\CsrfUtils;
  19
  20 if (!CsrfUtils::verifyCsrfToken($_GET["csrf_token_form"])) {
  21     CsrfUtils::csrfNotVerified();
  22 }
  23 // check to make sure only administrators access this page.
  24 if (!AclMain::aclCheckCore('admin', 'super')) {
  25     die(xlt("You are not authorized!"));
  26 }
  27
  28 function insertDrugData()
  29 {
  30     $drugs = file_get_contents('../../contrib/weno/erx_weno_drugs.sql');
  31     $drugsArray = explode(";\n", $drugs);
  32
  33     // Settings to drastically speed up import with InnoDB
  34     sqlStatementNoLog("SET autocommit=0");
  35     sqlStatementNoLog("START TRANSACTION");
  36
  37     foreach ($drugsArray as $drug) {
  38         if (empty($drug)) {
  39             continue;
  40         }
  41         sqlStatementNoLog($drug);
  42     }
  43
  44     // Settings to drastically speed up import with InnoDB
  45     sqlStatementNoLog("COMMIT");
  46     sqlStatementNoLog("SET autocommit=1");
  47 }
  48
  49 insertDrugData();
  50
  51 header('Location: ' . $_SERVER['HTTP_REFERER']);
  52 exit;