<?php
/**
*/
class Mageia_Financial_Report
{
function __construct()
{
}
/**
*/
function build($files)
{
$i = new self;
$i->report_file = $files['report'];
$i->forecast_file = $files['forecast'];
$i->accounts_file = $files['accounts'];
$i->CUR = '<span class="currency">EUR</span>';
return $i;
}
/**
*/
function html_summary()
{
$account2010 = 7523.96;
$this->hAccount2010 = number_format($account2010, 2);
$this->hAccountLeft = number_format($account2010 + $this->balance, 2);
$balanceSign = $this->balance >= 0 ? 'plus' : 'minus';
return <<<S
<table class="fr-table noborder">
<tr>
<td class="labelR">At the end of <a href="../2010/">2010</a> we had</td>
<td class="money">{$this->CUR} {$this->hAccount2010}.</td>
</tr>
<tr>
<td class="labelR">Since then, we received</td>
<td class="money">{$this->CUR} {$this->hInTotal},</td>
<td class="labelR">and spent</td>
<td class="money" style="text-align: left;">{$this->CUR} {$this->hOutTotal}
<span style="font-size: 80%; color: #888;">(<a href="#report">see detailed report</a>)</span>.</td>
</tr>
<tr>
<td class="labelR">Our balance so far is of</td>
<td class="money">{$this->CUR} <span class="{$balanceSign}Sign">{$this->hBalance}</span>,</td>
</tr>
<tr>
<td class="labelR">and we still have</td>
<td class="money">{$this->CUR} {$this->hAccountLeft}:</td>
<td class="money">{$this->CUR} {$this->accounts[0][1]}</td>
<td>in our {$this->accounts[0][0]}</td>
</tr>
<tr>
<td colspan="2"></td>
<td class="money">{$this->CUR} {$this->accounts[1][1]}</td>
<td>in our {$this->accounts[1][0]}</td>
</tr>
<tr>
<td colspan="2"></td>
<td class="money">{$this->CUR} {$this->accounts[2][1]}</td>
<td>in our {$this->accounts[2][0]}</td>
</tr>
</table>
S;
}
/**
*/
function html_report()
{
$f = file($this->report_file);
$hFileMTime = $this->html_source_file($this->report_file);
$inTotal = 0;
$outTotal = 0;
$hLines = '';
$line_tmpl = <<<S
<tr>
<td>%s</td>
<td>%s</td>
<td class="money">%s</td>
<td class="money">%s</td>
</tr>
S;
$cat_tmpl = '<tr><td colspan="4"><em>%s</em></td></tr>';
foreach ($f as $l)
{
$l = str_getcsv($l, ';');
if ('cat' === trim($l[0])) {
$hLines .= sprintf($cat_tmpl, $l[1]);
}
elseif ('' === trim($l[0])) {
$hLines .= sprintf($line_tmpl,
$l[1], $l[2],
$l[3] != '' ? $this->CUR . ' ' . number_format($l[3], 2) : '',
$l[4] != '' ? $this->CUR . ' ' . number_format($l[4], 2) : '');
$inTotal += $l[4];
$outTotal += $l[3];
}
}
$this->balance = $balance = $inTotal - $outTotal;
$this->hInTotal = $hInTotal = number_format($inTotal, 2);
$this->hOutTotal = $hOutTotal = number_format($outTotal, 2);
$this->hBalance = $hBalance = number_format($balance, 2);
$s = <<<S
<table class="fr-table"><thead>
<tr><th>Date</th>
<th>Transaction description</th>
<th>Outgoing</th>
<th>Incoming</th>
</tr>
</thead><tbody>
{$hLines}
<tr>
<td colspan="2">Total</td>
<td class="money">{$this->CUR} {$hOutTotal}</td>
<td class="money">{$this->CUR} {$hInTotal}</td>
</tr>
<tr>
<td colspan="2">Balance</td>
<td class="money" colspan="2" style="text-align: center;">{$this->CUR} {$hBalance}</td>
</tr>
</tbody></table>
{$hFileMTime}
S;
return $s;
}
/**
*/
function html_forecast()
{
$f = file($this->forecast_file);
$hFileMTime = $this->html_source_file($this->forecast_file);
$total = 0;
$doneTotal = 0;
$hLines = '';
$CUR = '<span style="color: #777; font-size: 80%%;">EUR</span>';
$line_tmpl = <<<S
<tr>
<td>%s</td>
<td class="money">{$CUR} %s</td>
<td class="money">%d</td>
<td class="money">%d</td>
<td class="money">{$CUR} %s</td>
<td>%s</td>
</tr>
S;
foreach ($f as $l)
{
$l = str_getcsv($l, ';');
if ('' === trim($l[0])) {
$subtotal = $l[2] * $l[3] * $l[4];
$hLines .= sprintf($line_tmpl,
$l[1], number_format($l[2], 2), $l[3], $l[4], number_format($subtotal, 2), $l[6]);
$total += $subtotal;
if (strtolower($l[6]) != 'pending') {
$doneTotal += $subtotal;
}
}
}
$hTotal = number_format($total, 2);
$hDoneTotal = number_format($doneTotal, 2);
$hProgress = round($doneTotal / $total * 100, 2);
$s = <<<S
<table class="fr-table"><thead>
<tr><th>Description of planned expenditure</th>
<th>Unit Price</th>
<th>Quantity</th>
<th>Recurrence</th>
<th>Total Price</th>
<th>Status</th></tr>
</thead><tbody>
{$hLines}
<tr>
<td colspan="4">Total forecasted</td>
<td class="money">{$CUR} {$hTotal}</td>
<td></td>
</tr>
<tr>
<td colspan="4">Total done</td>
<td class="money">{$CUR} {$hDoneTotal}</td>
<td class="money">{$hProgress}%</td>
</tr>
</tbody></table>
{$hFileMTime}
S;
return $s;
}
/**
*/
function html_accounts()
{
$f = file($this->accounts_file);
$hFileMTime = $this->html_source_file($this->accounts_file);
$total = 0;
$doneTotal = 0;
$hLines = '';
$CUR = '<span style="color: #777; font-size: 80%%;">EUR</span>';
$line_tmpl = <<<S
<tr>
<td>%s</td>
<td class="money">{$CUR} %s</td>
</tr>
S;
$this->accounts = array();
foreach ($f as $l)
{
$l = str_getcsv($l, ';');
if ('' === trim($l[0])) {
$this->accounts[] = array(
str_replace(array('(', ')'), array('<span style="font-size: 80%; color: #888; display: block;">(', ')</span>'), $l[1]),
number_format($l[2], 2)
);
$hLines .= sprintf($line_tmpl,
$l[1], number_format($l[2], 2));
$total += $l[2];
}
}
$hTotal = number_format($total, 2);
$s = <<<S
<table class="fr-table"><thead>
<tr><th>Account</th>
<th>Amount</th>
</thead><tbody>
{$hLines}
<tr>
<td>Total</td>
<td class="money">{$CUR} {$hTotal}</td>
</tr>
</tbody></table>
S;
$s =<<<S
{$hFileMTime}
S;
return $s;
}
/**
*/
function html_source_file($file)
{
return sprintf('<p style="font-size: 80%%; color: #777;">Source: <a href="%s">%s</a> (last updated on %s).</p>',
$file, $file, date('c', filemtime($file)));
}
}