From d63bc15119288fea0fd818212e25af0bdb5bdbd6 Mon Sep 17 00:00:00 2001 From: Romain d'Alverny Date: Thu, 1 Mar 2012 18:07:59 +0000 Subject: 2011 report update (did I mention this code is an abomination? well, it is) --- en/about/reports/2011/index.php | 379 +++++++++++++++++++++++++++++++-------- en/about/reports/2011/index3.php | 76 -------- 2 files changed, 305 insertions(+), 150 deletions(-) delete mode 100644 en/about/reports/2011/index3.php (limited to 'en/about/reports/2011') diff --git a/en/about/reports/2011/index.php b/en/about/reports/2011/index.php index 581fab48f..144687024 100644 --- a/en/about/reports/2011/index.php +++ b/en/about/reports/2011/index.php @@ -1,87 +1,318 @@ - + 'January', 2 => 'February', 3 => 'March', + 4 => 'April', 5 => 'May', 6 => 'June', + 7 => 'July', 8 => 'August', 9 => 'September', + 10 => 'October', 11 => 'November', 12 => 'December' +); + +$data = file('mageia-financial-report-2011.csv'); +$parsed = array(); +foreach ($data as $l) { + if (trim($l) == ',,,,,,') + continue; + + $l = str_getcsv(str_replace(array(',,,', ",\n"), '', $l)); + if (substr($l[0], 0, 2) == '# ') { + $tag = $l[0]; + $parent = $tag; + } elseif (substr($l[0], 0, 2) == '##') { + $tag = $parent . ' > ' . $l[0]; + } else { + $parsed[$tag][] = $l; + } +} + +foreach ($parsed as $tag => $values) { + $val2 = array(); + $tag2 = strtolower($tag); + $teststr = strlen($tag) > 12 ? substr($tag2, 0, 13) : null; + foreach ($values as $v) { + if ($tag2 == "# head" + || $teststr == "# account bal" + || $teststr == "# income stat" + || $teststr == "# balance she" + || $tag2 == '## expenses' + || $tag2 == '## revenues' + || $tag2 == '## liabilities' + || $tag2 == '## assets') { + $val2[$v[0]] = $v[1]; + } else { + $val2[] = $v; + } + } + + $parsed[$tag] = $val2; +} +$flow = array(); + +$list = array(); +$count = array(); +foreach ($parsed['# Expenses details > ## Monthly summary'] as $line) { + $list[] = $line[2]; + $count[] = $line[1]; +} +unset($list[0]); +unset($list[13]); +unset($count[0]); +unset($count[13]); + +$flow = array( + 'expenses' => $list, + 'expenses_op' => $count, + 'revenue' => null, + 'revenue_op' => null +); + +$list = array(); +$count = array(); +foreach ($parsed['# Income details > ## Donations monthly summary'] as $line) { + $list[] = $line[2]; + $count[] = $line[1]; +} +unset($list[0]); +unset($list[13]); +unset($count[0]); +unset($count[13]); + +$flow['revenue'] = $list; +$flow['revenue_op'] = $count; + + +?> - - Mageia Financial Report (2011) - - - - + + Mageia 2011 Financial Report + + + + + + + + -
- +
+
-

Summary

-
    -
  • Outstanding amount of 2010: EUR 7 523.96
    • -
  • Amount collected: EUR 3 379.86
    • -
  • Amount spent: EUR 3 469.75
    • -
  • Amount remaining:
    • -
-

Financial Report

- - - - - - - - - - - - - - - - - - - - - - - - - - -
Transaction descriptionIncomeOutgoing
Donations and Sales
Donations by Paypal/transfer/checkEUR 1 920.97 
Sale of Tee-ShirtsEUR 1 050.00 
Fees and Administration Costs
Administrative cost for the birth of Mageia.Org (JO) EUR 44.00
April (annual fee) EUR 100.00
INPI brand registration for 10 years (rda) EUR 250.00
Annual interest of our savings accountEUR 3.06 
Goodies and accessories
Posters + flyers for Solutions Linux (rda) EUR 159.25
Stickers + Tee-Shirts (fosdem) EUR 1 932.14
Money box (dams) EUR 17.93
Shipments
40 TS to wobo for the Chemnitzer Linuxtage EUR 54.65
3 TS to donors in France (dams) EUR 12.30
2 TS to saipo for an event in France (dams) EUR 25.00
Hardware or hosting
RAM on Gandi hosting (for blog/planet/www) EUR 250.00
SSL for domains on Gandi.net EUR 215.28
HDD for servers (boklm) EUR 242.70
Travels and events
Hotel + train for wobo (fosdem 2011) EUR 166.50
 
TotalEUR EUR 3 469.75
BalanceEUR 
-

Bank accounts situation

-
    -
  • Paypal (non-for-profit organisation account): EUR 898.42
    • -
  • Main account (with checkbook and no credit card): EUR 511.13
    • -
  • Savings account (between 2% and 4% of interest): EUR 7 218.72
    • -
-

Forecast for 2011

- - - - - - - - - - - - - - -
Description of planned expenditureUnit PriceQuantityRecurrenceTotal PriceStatus
GoodiesEUR 4 500.0011EUR 4 500.00pending
AprilEUR 100.0011EUR 100.00pending
Gandi (hosting: +1536 MB of RAM)EUR 2.39612EUR 172.08done (Wed Mar 30)
Internet domainsEUR 15.0071EUR 105.00pending
HDD for Fiona (backup server)EUR 205.0041EUR 820.00pending
1 new server for BS (QA & packagers)EUR 2 669.6011EUR 2 669.60done (Fri Oct 21)
Event boxEUR 1500.0011EUR 1 500.00pending
Event travelEUR 1 000.0012EUR 2 000.00pending
HW for spareEUR 3 000.0011EUR 3 000.00pending
Brand registrationEUR 280.0011EUR 280.00pending
Reserve fundEUR 4 000.0011EUR 4 000.00pending
 
TotalEUR 19 146.68pending
-

Miscellaneous

- -

Contact

- Financial report published by Damien Lallement (Mageia.Org Treasurer on the 2011 Fiscal Year).
You can contact him by sending an email to treasurer[at]mageia[dot]org.
Last update: Tue Jan 10 16:12:13 CET 2012. +

Here is our financial report for 2011.

+ + + +

Last updated on .

+ +
+

Account status on December 31st, 2011

+ '; + foreach ($v as $k => $w) { + $s .= sprintf('%sEUR %s', $k, $w); + } + $s .= ''; + echo $s; + ?> + +
+ +

Cash flow

+
+
+
+
+ +

Income statement

+ + + +
RevenuesExpenses
+ + ## Revenues'] as $k => $v) + $s .= sprintf('', $k, $v); + + echo $s; + ?> +
%sEUR %s
+ 		+ + ## Expenses'] as $k => $v) + $s .= sprintf('', $k, $v); + + echo $s; + ?> +
%sEUR %s
+
+ +
+ +

Balance sheet

+ + + +
RevenuesExpenses
+ + ## Assets'] as $k => $v) + $s .= sprintf('', $k, $v); + + echo $s; + ?> +
%s%s
+ 		+ + ## Liabilities'] as $k => $v) + $s .= sprintf('', $k, $v); + + echo $s; + ?> +
%s%s
+
+
+ +

Expenses

+ + ## Monthly summary']; + echo ''; + foreach ($v as $line) { + echo sprintf('', + $_months[$line[0]], $line[1], $line[2]); + } + echo '
%s%sEUR %s
'; + ?> + +

Details

+ + + ## More details']; + foreach ($v as $line) { + echo sprintf('', + $line[0], $line[1], + $line[2], $line[3], + $line[4], + $line[5]); + } + ?> +
%s%s%s%s%sEUR %s
+
+

Income, donations

+ ## Donations monthly summary']; + echo ''; + foreach ($v as $line) { + echo sprintf(' + + + + + ', + $_months[$line[0]], $line[1], $line[2], + $line[3], + $line[4], + $line[5], $line[6]); + } + echo '
%s%sEUR %sEUR %sEUR %sEUR %sEUR %s
'; + ?> + +
+

Feel free to contact us regarding this report.

diff --git a/en/about/reports/2011/index3.php b/en/about/reports/2011/index3.php deleted file mode 100644 index dab32dcee..000000000 --- a/en/about/reports/2011/index3.php +++ /dev/null @@ -1,76 +0,0 @@ -', print_r($parsed, true), ''; - -?> - - - - Mageia 2011 Financial Report - - - - - - - - - -
- -
-
-
-

- Being redesigned – Take with a grain of salt for now.

- - - -

Account status

- TODO -
- -

Cash flow

- TODO -
- -

Income statement

- TODO -
- -

Balance sheet

- TODO -
- -

2012 Forecast

- TODO - -
-

Contact

-

Financial report published by Damien Lallement (Mageia Treasurer on the 2011 Fiscal Year).
- You can contact him by sending an email to treasurer[at]mageia[dot]org.

-
-
-
-
- - -- cgit v1.2.1