interface/weno/drugPaidInsert.php

   1 <?php
   2 /**
   3  * weno drug paid insert
   4  *
   5  * @package OpenEMR
   6  * @link    http://www.open-emr.org
   7  * @author  Sherwin Gaddis <sherwingaddis@gmail.com>
   8  * @author    Brady Miller <brady.g.miller@gmail.com>
   9  * @copyright Copyright (c) 2016-2017 Sherwin Gaddis <sherwingaddis@gmail.com>
  10  * @copyright Copyright (c) 2018 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
  15 require_once('../globals.php');
  16
  17 if (!verifyCsrfToken($_GET["csrf_token_form"])) {
  18     csrfNotVerified();
  19 }
  20
  21 $drugs = file_get_contents('../../contrib/weno/drugspaidinsert.sql');
  22 $drugsArray = explode(";\n", $drugs);
  23
  24 // Settings to drastically speed up import with InnoDB
  25 sqlStatementNoLog("SET autocommit=0");
  26 sqlStatementNoLog("START TRANSACTION");
  27
  28 foreach ($drugsArray as $drug) {
  29     if (empty($drug)) {
  30         continue;
  31     }
  32     sqlStatementNoLog($drug);
  33 }
  34
  35 // Settings to drastically speed up import with InnoDB
  36 sqlStatementNoLog("COMMIT");
  37 sqlStatementNoLog("SET autocommit=1");
  38
  39 header('Location: ' . $_SERVER['HTTP_REFERER']);
  40 exit;