/**
* Parse transaction-data form TSV-file
*
* @param $value
* @param int $skipHeaderLines
* @param Data\Company $company
* @return Data\Company
*/
public function parseTransactions($value, Data\Company $company, $skipHeaderLines = 1)
{
// parse text
$rows = $this->getTabularData($value);
// kill header lines
for ($i = 0; $i < $skipHeaderLines; $i++) {
array_shift($rows);
}
// fix ordering
usort($rows, array($this, 'tabularDataCompareRows'));
// add a verification series and two dimensions
$verificationSeries = new Data\VerificationSeries();
$company->addVerificationSeries($verificationSeries)->addDimension(new Data\Dimension(Data\Dimension::DIMENSION_COST_CENTRE))->addDimension(new Data\Dimension(Data\Dimension::DIMENSION_PROJECT));
$last_verification_id = null;
foreach ($rows as $row) {
/* -- Our columns --
* 0: Verification number
* 1: Transaction / verification date
* 3: Account number
* 4: Account name
* 5: Result unit
* 6: Project
* 13: Verification name
* 14: Verification row number
* 15: Transaction name
* 18: Transaction amount
*/
$data = array('ver_no' => $row[0], 'date' => $row[1], 'account_no' => $row[3], 'account_name' => $row[4], 'result_unit' => $row[5], 'project' => $row[6], 'ver_name' => $row[13], 'ver_row' => $row[14], 'trans_text' => $row[15], 'trans_amount' => (double) str_replace(array('.', ','), array('', '.'), $row[18]));
// verification
if ($last_verification_id !== $data['ver_no']) {
$verification = (new Data\Verification($data['ver_no']))->setDate($data['date'])->setText($data['ver_name']);
$verificationSeries->addVerification($verification);
}
// account
$account = $company->getAccount($row[3]);
if ($account === null) {
$account = (new Data\Account($data['account_no']))->setName($data['account_name']);
$company->addAccount($account);
}
// transaction
$transaction = (new Data\Transaction())->setAccount($account)->setAmount($data['trans_amount'])->setText($data['trans_text']);
$verification->addTransaction($transaction);
// dimension - result unit
if ($data['result_unit']) {
// find dimension (pre-defined)
$dim = $company->getDimension(Data\Dimension::DIMENSION_COST_CENTRE);
// find / create object
$object = $dim->getObject($data['result_unit']);
if ($object === null) {
$object = (new Data\Object($data['result_unit']))->setDimension($dim)->setName('Resultatenhet ' . $data['result_unit']);
//We don't have this data, so just set it
$dim->addObject($object);
}
// add to transaction
$transaction->addObject($object);
}
// dimension - project
if ($data['project']) {
// find dimension (pre-defined)
$dim = $company->getDimension(Data\Dimension::DIMENSION_PROJECT);
// find / create object
$object = $dim->getObject($data['project']);
if ($object === null) {
$object = (new Data\Object($data['project']))->setDimension($dim)->setName('Projekt ' . $data['project']);
//We don't have this data, so just set it
$dim->addObject($object);
}
// add to transaction
$transaction->addObject($object);
}
$last_verification_id = $verification->getId();
}
}
