-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmmaccbalperiods.php
87 lines (72 loc) · 2.59 KB
/
mmaccbalperiods.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
<?php // mmaccbalperiods.php
use mondrakeNG\mm\classes\AXAccountPeriodBalance;
use mondrakeNG\mm\classes\AXAccount;
require_once 'mmheader.php';
if (!isset($_GET['acc']))
die("Missing parameter.");
$acc = $_GET['acc'];
$period_type_id = $_GET['period_type'];
$account = new AXAccount;
$account->read($acc);
$obj = new AXAccountPeriodBalance;
$colDets = $obj->getColumnProperties();
$objs = $obj->readMulti("account_id = $acc and period_type_id = $period_type_id", "period_year desc, period desc");
echo <<<_END
<!-- The HTML section -->
<table>
<td>$account->account_short - $account->account_desc</td>
<tr/><tr/><tr/>
</table>
<style>.signup { border: 1px solid #999999;
font: normal 10px verdana; color:#444444; }</style>
<style>.vertical
{
/* IE-only DX filter */
writing-mode: tb-rl;
filter: flipv fliph;
/* Safari/Chrome function */
-webkit-transform: rotate(270deg);
-moz-transform: rotate(270deg);
}
</style>
</head><body>
<table class="signup" border="1" cellpadding="2"
cellspacing="0" bgcolor="#eeeeee">
_END;
echo "<tr>";
echo "<td>Year</td>";
echo "<td>Period</td>";
echo "<td align=right>Opening</td>";
echo "<td align=right>+</td>";
echo "<td align=right>-</td>";
echo "<td align=right><b>Period</b></td>";
echo "<td align=right><b>Current</b></td>";
echo "<td align=right>uv Opening</td>";
echo "<td align=right>uv +</td>";
echo "<td align=right>uv -</td>";
echo "<td align=right><b>uv Period</b></td>";
echo "<td align=right><b>uv Current</b></td>";
echo "<td align=right>Period avg</td>";
echo "</tr>";
foreach ($objs as $a => $b) {
echo "<tr>";
echo "<td>$b->period_year</td>";
echo "<td>$b->period</td>";
echo "<td align=right>";echo(round($b->period_opening_balance,2));echo"</td>";
echo "<td align=right>";echo(round($b->period_dt_amount,2));echo"</td>";
echo "<td align=right>";echo(round($b->period_ct_amount,2));echo"</td>";
echo "<td align=right><b>";echo(round($b->period_balance,2));echo"</b></td>";
echo "<td align=right><b>";echo(round($b->period_closing_balance,2));echo"</b></td>";
echo "<td align=right>";echo(round($b->period_uv_opening_balance,2));echo"</td>";
echo "<td align=right>";echo(round($b->period_uv_dt_amount,2));echo"</td>";
echo "<td align=right>";echo(round($b->period_uv_ct_amount,2));echo"</td>";
echo "<td align=right><b>";echo(round($b->period_uv_balance,2));echo"</b></td>";
echo "<td align=right><b>";echo(round($b->period_uv_closing_balance,2));echo"</b></td>";
if ($account->accountClass->is_daily_balance_req) {
echo "<td align=right>";echo(round($b->period_avg_balance,2));echo"</td>";
}
else
echo "<td/>";
echo "</tr>";
}
?>