library/classes/OFX.class.php

   1 <?php
   2
   3 require_once $GLOBALS['OE_SITE_DIR'] . "/config.php";
   4
   5 /**
   6  * class OFX
   7  *
   8  */
   9 class OFX
  10 {
  11
  12     var $billing_array;
  13     var $config;
  14     /**
  15      * Constructor sets all OFX attributes to their default value
  16      */
  17     function __construct($ba = array())
  18     {
  19         $this->billing_array = $ba;
  20         $this->config = $GLOBALS['oer_config']['ofx'];
  21     }
  22
  23     function get_OFX()
  24     {
  25         $string = $this->_ofx_header() . "\n";
  26         $trns = array();
  27         $sum = 0.00;
  28         $date_start = date("YmdHis", strtotime($this->billing_array[0]['bill_date']));
  29         $date_end = date("YmdHis", strtotime($this->billing_array[0]['bill_date']));
  30         foreach ($this->billing_array as $bill) {
  31             $key = $bill['pid'] . "-" . $bill['encounter'];
  32             if ($bill['code_type'] != "ICD9" && $bill['code_type'] != "COPAY") {
  33                 $trns[$key]['amount'] += $bill['fee'];
  34                 $trns[$key]['date'] = $bill['bill_date'];
  35                 $trns[$key]['memo'] .= $bill['code'] . " ";
  36                 $trns[$key]['payeeid'] = $bill['pid'];
  37                 $trns[$key]['name'] = $bill['name'];
  38                 if ($date_start > date("YmdHis", strtotime($trns[$key]['date']))) {
  39                     //echo "\nsd: $date_start < " . date("YmdHis",strtotime($trn[$key]['date'])) . "\n";
  40                     $date_start = date("YmdHis", strtotime($trns[$key]['date']));
  41                 }
  42
  43                 if ($date_end < date("YmdHis", strtotime($trns[$key]['date']))) {
  44                     //echo "\ned: $date_end < " . date("YmdHis",strtotime($trn[$key]['date'])) . "\n";
  45                     $date_end = date("YmdHis", strtotime($trns[$key]['date']));
  46                 }
  47             }
  48         }
  49
  50         if (!empty($date_start) && !empty($date_end)) {
  51             $string .= "<DTSTART>" . $date_start . "\n";
  52             $string .= "<DTEND>" . $date_end . "\n";
  53         }
  54
  55         foreach ($trns as $key => $trn) {
  56             $string .= "<STMTTRN>\n";
  57             $string .= "<TRNTYPE>CREDIT\n";
  58             $string .= "<DTPOSTED>" . date("YmdHis", strtotime($trn['date'])) . "\n";
  59             $string .= "<TRNAMT>" . sprintf("%0.2f", $trn['amount']) . "\n";
  60             $string .= "<FITID>" . $key . "\n";
  61             $string .= "<NAME>" . $trn['name'] . "\n";
  62             $string .= "<CHECKNUM>" . $key . "\n";
  63             $string .= "<PAYEEID>" . $trn['payeeid'] . "\n";
  64             $string .= "<MEMO>" . trim($trn['memo']) . "\n";
  65             $string .= "</STMTTRN>\n";
  66             $sum += $trn['amount'];
  67         }
  68
  69         $string .= $this->_ofx_footer($sum);
  70         return $string;
  71     }
  72
  73     function _ofx_header()
  74     {
  75         $string .= "OFXHEADER:100\n";
  76         $string .= "DATA:OFXSGML\n";
  77         $string .= "VERSION:102\n";
  78         $string .= "SECURITY:NONE\n";
  79         $string .= "ENCODING:USASCII\n";
  80         $string .= "CHARSET:1252\n";
  81         $string .= "COMPRESSION:NONE\n";
  82         $string .= "OLDFILEUID:NONE\n";
  83         $string .= "NEWFILEUID:NONE\n\n";
  84         $string .= "<OFX>\n";
  85         $string .= "<SIGNONMSGSRSV1>\n";
  86         $string .= "<SONRS>\n";
  87         $string .= "<STATUS>\n";
  88         $string .= "<CODE>0\n";
  89         $string .= "<SEVERITY>INFO\n";
  90         $string .= "</STATUS>\n";
  91         $string .= "<DTSERVER>" . date("YmdHis") . "\n";
  92         $string .= "<LANGUAGE>ENG\n";
  93
  94         //OpenEMR doesn't have a good grasp of timezone so we will need to revisit this later if it causes problems for transaction timestamping
  95         $string .= "<DTACCTUP>" . date("YmdHis") . ".000[-8:PST]\n";
  96
  97         //intuit programs requires the fields below or it won't accept our ofx transactions
  98         $string .= "<FI>\n";
  99         $string .= "<ORG>Bank of America\n";
 100         $string .= "<FID>5959\n";
 101         $string .= "</FI>\n";
 102         $string .= "<INTU.BID>6526\n";
 103         $string .= "<INTU.USERID>111111111\n";
 104         //end intuit specific fields
 105
 106         $string .= "</SONRS>\n";
 107         $string .= "</SIGNONMSGSRSV1>\n";
 108
 109         $string .= "<BANKMSGSRSV1>\n";
 110         $string .= "<STMTTRNRS>\n";
 111         $string .= "<TRNUID>0\n";
 112         $string .= "<STATUS>\n";
 113         $string .= "<CODE>0\n";
 114         $string .= "<SEVERITY>INFO\n";
 115         $string .= "</STATUS>\n";
 116         $string .= "<STMTRS>\n";
 117         $string .= "<CURDEF>USD\n";
 118         $string .= "<BANKACCTFROM>\n";
 119         $string .= "<BANKID>" . $this->config['bankid'] . "\n";
 120         $string .= "<ACCTID>" . $this->config['acctid'] . "\n";
 121         $string .= "<ACCTTYPE>CHECKING";
 122         $string .= "</BANKACCTFROM>\n";
 123         $string .= "<BANKTRANLIST>\n";
 124         return $string;
 125     }
 126
 127     function _ofx_footer($sum)
 128     {
 129         $string = "</BANKTRANLIST>\n";
 130         $string .= "<LEDGERBAL>\n";
 131         $string .= "<BALAMT>" . sprintf("%0.2f", $sum) . "\n";
 132         $string .= "<DTASOF>" . date("YmdHis"). "\n";
 133         $string .= "</LEDGERBAL>\n";
 134         $string .= "</STMTRS>\n";
 135         $string .= "</STMTTRNRS>\n";
 136         $string .= "</BANKMSGSRSV1>\n";
 137         $string .= "</OFX>\n";
 138         return $string;
 139     }
 140 }