pxfzhkryfa / ofxparser
简单的OFX文件解析器
1.2.2
2018-10-29 10:10 UTC
Requires
- php: ~5.6|~7.0
Requires (Dev)
- phpunit/phpunit: ~5.5
- squizlabs/php_codesniffer: ~2.6
README
OFX解析器是一个PHP库,旨在将金融机构下载的OFX文件解析为简单的PHP对象。
它支持多个银行账户、所需的“登录”响应,并识别OFX时间戳。
安装
使用 Composer 简单地引入该包
$ composer require asgrim/ofxparser
使用方法
您可以通过以下方式访问OFX文件中的节点
$ofxParser = new \OfxParser\Parser(); $ofx = $ofxParser->loadFromFile('/path/to/your/bankstatement.ofx'); $bankAccount = reset($ofx->bankAccounts); // Get the statement start and end dates $startDate = $bankAccount->statement->startDate; $endDate = $bankAccount->statement->endDate; // Get the statement transactions for the account $transactions = $bankAccount->statement->transactions;
最常见的节点是支持。如果在OFX文件中遇到无法访问的节点,请提交一个pull request!
投资支持
投资看起来与银行/信用卡交易大不相同。该版本根据作者/者的即时需求,支持OFX 2.0.3规范中的节点子集。如果您选择实现此库,可能需要参考OFX文档。特别是,目前不处理投资头寸(INVPOSLIST)或引用的证券定义(SECINFO)。
这不是字面意义上的字段透传,例如Python中的此实现:csingley/ofxtools。此包包含偶尔“翻译”过的字段,使其对不太熟悉OFX投资规范的用户更加友好。
从Quicken(QFX)文件或Microsoft Money(OFX / XML)文件加载投资
// You'll probably want to alias the namespace: use OfxParser\Entities\Investment as InvEntities; // Load the OFX file $ofxParser = new \OfxParser\Parsers\Investment(); $ofx = $ofxParser->loadFromFile('/path/to/your/investments_file.ofx'); // Loop over investment accounts (named bankAccounts from base lib) foreach ($ofx->bankAccounts as $accountData) { // Loop over transactions foreach ($accountData->statement->transactions as $ofxEntity) { // Keep in mind... not all properties are inherited for all transaction types... // Maybe you'll want to do something based on the transaction properties: $nodeName = $ofxEntity->nodeName; if ($nodeName == 'BUYSTOCK') { // @see OfxParser\Entities\Investment\Transaction... $amount = abs($ofxEntity->total); $cusip = $ofxEntity->securityId; // ... } // Maybe you'll want to do something based on the entity: if ($ofxEntity instanceof InvEntities\Transaction\BuyStock) { // ... } } }
分支 & 致谢
这是由grimfor/ofxparser分支出来,为了使其不依赖于框架。源存储库是为Symfony 2框架设计的,因此应给予应有的赞誉!由Oliver Lowe大力重构,并松散地基于Andrew A. Smith的Rubyofx-parser。