diff options
Diffstat (limited to 'en/about/reports/template_lib.php')
| -rw-r--r-- | en/about/reports/template_lib.php | 169 |
1 files changed, 169 insertions, 0 deletions
diff --git a/en/about/reports/template_lib.php b/en/about/reports/template_lib.php new file mode 100644 index 000000000..419ff103c --- /dev/null +++ b/en/about/reports/template_lib.php @@ -0,0 +1,169 @@ +<?php + + +function get_expenses($v) +{ + $html = '<div id="expenses-cats-pie"></div>'; + $html .= '<table class="fr-table">'; + + $line = array_shift($v); + $sums = array(); + + $html .= sprintf('<thead><tr><th>%s</th><th>%s</th><th>%s</th><th class="money">%s</th></tr></thead><tbody>', + $line[0], $line[1], + $line[2], $line[3], + $line[4], + $line[5]); + + foreach ($v as $line) { + if (count($line) < 2) + continue; + + $html .= sprintf('<tr><td>%s</td><td>%s</td><td>%s</td><td class="money">%s</td></tr>', + date('Y-M-d', strtotime($line[0])), $line[1], + $line[2], + _report_number_format($line[3])); + + $cat = explode(':', $line[1]); + $sums[$cat[0]] += $line[3]; + $sums['total'] += $line[3]; + } + + $html .= '</tbody> + <tfoot><tr> + <td colspan="3">Total:</td> + <td class="money">' . _report_number_format($sums['total']) . '</td> + </tr></tfoot> +</table>'; + + unset($sums['total']); + arsort($sums); + foreach ($sums as $k => $v) + $sums[$k] = "['{$k}', $v]"; + + $values = implode(', ', $sums); + $html .= <<<H +<script type="text/javascript"> + google.setOnLoadCallback(drawChartExpenses); + function drawChartExpenses() { + var data = new google.visualization.DataTable(); + data.addColumn('string', 'Source'); + data.addColumn('number', 'Amount'); + data.addRows([{$values}]); + var options = {'title':'Expenses by category', + 'width':400, + 'height':300}; + + var chart = new google.visualization.PieChart(document.getElementById('expenses-cats-pie')); + chart.draw(data, options); + } +</script> +H; + + return array('html' => $html); +} + +/** + * @param string $v + * + * @return array('html' => string, 'data' => mixed) +*/ +function get_revenues($v, $_months) +{ + $html = '<div id="income-pie"></div>'; + $html .= '<table class="fr-table">'; + + $line = array_shift($v); + $html .= sprintf('<thead><tr><th>%s</th><th>%s</th> + <th>%s</th><th>%s</th><th>%s</th><th>%s</th> + <th>%s</th><th>average</th></tr></thead>', + $line[0], $line[1], $line[2], + $line[3], + $line[4], + $line[5], $line[6]); + + $html .= '<tbody>'; + + $sums = array( + 'count' => 0, + 'total' => 0, + 'check' => 0, + 'xfer' => 0, + 'paypal' => 0, + 'cash' => 0 + ); + + foreach ($v as $line) { + if (count($line) < 2) + continue; + + $html .= sprintf('<tr><td>%s</td><td>%s</td> + <td class="money">%s</td> + <td class="money">%s</td> + <td class="money">%s</td> + <td class="money">%s</td> + <td class="money">%s</td> + <td class="money">%s</td></tr>', + $_months[$line[0]], + $line[1], + _report_number_format($line[2]), + _report_number_format($line[3]), + _report_number_format($line[4]), + _report_number_format($line[5]), + _report_number_format($line[6]), + $line[1] > 0 ? _report_number_format($line[2] / $line[1]) : '' + ); + + $sums['count'] += $line[1]; + $sums['total'] += $line[2]; + $sums['check'] += $line[3]; + $sums['xfer'] += $line[4]; + $sums['paypal'] += $line[5]; + $sums['cash'] += $line[6]; + } + $html .= '</tbody><tfoot>'; + $html .= sprintf('<tr><th>Total</th> + <td class="money">%s</td> + <td class="money">%s</td> + <td class="money">%s</td> + <td class="money">%s</td> + <td class="money">%s</td> + <td class="money">%s</td> + <td class="money">%s</td></tr>', + $sums['count'], + _report_number_format($sums['total']), + _report_number_format($sums['check']), + _report_number_format($sums['xfer']), + _report_number_format($sums['paypal']), + _report_number_format($sums['cash']), + $sums['count'] > 0 ? _report_number_format($sums['total'] / $sums['count']) : '' + ); + $total_revenues = $sums['total']; + $html .= '</tfoot></table>'; + + $html .= <<<S + <script type="text/javascript"> + google.setOnLoadCallback(drawChart); + function drawChart() { + var data = new google.visualization.DataTable(); + data.addColumn('string', 'Source'); + data.addColumn('number', 'Amount'); + data.addRows([ + ['Paypal', {$sums['paypal']}], + ['Bank transfer', {$sums['xfer']}], + ['Check', {$sums['check']}], + ['Cash', {$sums['cash']}], + ]); + + var options = {'title':'Donations by source', + 'width':400, + 'height':300}; + + var chart = new google.visualization.PieChart(document.getElementById('income-pie')); + chart.draw(data, options); + } + </script> +S; + + return array('html' => $html, 'data' => array('total' => $total_revenues)); +}
\ No newline at end of file |