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/index.php | 3 +- en/about/reports/2011/index.php | 379 +++++++++++++++++++++++++++++++-------- en/about/reports/2011/index3.php | 76 -------- en/about/reports/index.php | 41 ++++- 4 files changed, 346 insertions(+), 153 deletions(-) delete mode 100644 en/about/reports/2011/index3.php (limited to 'en/about') diff --git a/en/about/index.php b/en/about/index.php index 422f9d9fe..01ca6f244 100644 --- a/en/about/index.php +++ b/en/about/index.php @@ -34,8 +34,7 @@
  • Values
  • Code of conduct
  • Policies
    • -
  • Financial reports: 2010, - 2011
    • +
  • Financial reports
  • Thanks!
  • Privacy policy
  • Logo, CD covers files, media files.
    • 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.

    -
    -
    -
    -
    - - diff --git a/en/about/reports/index.php b/en/about/reports/index.php index 734f690aa..58de0a20c 100644 --- a/en/about/reports/index.php +++ b/en/about/reports/index.php @@ -1 +1,40 @@ - + + + + Mageia activity & financial reports + + + + + + + + + +
    + +
    +
    +
    +

    Here you will find our various activity and financial reports for every year.

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