diff options
author | Marek Laane <bald@smail.ee> | 2014-10-12 10:54:11 +0300 |
---|---|---|
committer | Marek Laane <bald@smail.ee> | 2014-10-12 10:54:11 +0300 |
commit | a0b2d09125d7911656fe4cb286f20643c4432281 (patch) | |
tree | 4b825dc642cb6eb9a060e54bf8d69288fbee4904 /en/about/reports | |
parent | e32d8242187534c387106ff344201c42ff6afb44 (diff) | |
download | www-a0b2d09125d7911656fe4cb286f20643c4432281.tar www-a0b2d09125d7911656fe4cb286f20643c4432281.tar.gz www-a0b2d09125d7911656fe4cb286f20643c4432281.tar.bz2 www-a0b2d09125d7911656fe4cb286f20643c4432281.tar.xz www-a0b2d09125d7911656fe4cb286f20643c4432281.zip |
Updated Estonian translation
Diffstat (limited to 'en/about/reports')
19 files changed, 0 insertions, 1115 deletions
diff --git a/en/about/reports/2010/index.php b/en/about/reports/2010/index.php deleted file mode 100644 index e4bddf87d..000000000 --- a/en/about/reports/2010/index.php +++ /dev/null @@ -1,64 +0,0 @@ -<!DOCTYPE html> -<html dir="ltr" lang="en"> -<head> - <meta charset="utf-8" /> - <title>Mageia Financial Report (2010)</title> - <meta name="description" content="Mageia financial activity report for 2010." /> - <meta name="keywords" content="mageia, financial report, 2010" /> - <meta name="author" content="Mageia" /> - <link rel="stylesheet" type="text/css" href="/g/style/all.css" /> - <?php include '../../../../analytics.php'; ?> -</head> -<body class="about"> - <?php include '../../../../langs.php'; ?> - <h1 id="mgnavt"><a href="../">Activity Reports</a> » 2010 Financial Report</h1> - <div id="doc" class="yui-t7"> - <div id="bd" role="main"> - <div class="yui-g"> - <div class="para values"> - <h2>Summary</h2> - <ul> - <li>Amount collected: EUR 8 801.66</li> - <li>Amount spent: EUR 1 277.77</li> - <li>Amount remaining: EUR 7 523.96</li> - </ul> - <h2>Financial Report</h2> - <table id="fr-table"><thead><tr><th>Transaction description</th><th>Income</th><th>Outgoing</th></tr></thead><tbody><tr> - <tr><td colspan=3>Donations and Sales</td></tr> - <tr><td>Donations by Paypal/transfer/check/cash</td><td class="money">EUR 8 801.42</td><td> </td></tr> - <tr><td>Paypal test to validate bank account</td><td class="money">EUR 0.24</td><td> </td></tr> - <tr><td colspan=3>Hardware for servers</td></tr> - <tr><td>HDD for servers (dams)</td><td> </td><td class="money">EUR 921.20</td></tr> - <tr><td>Cables and other stuff for servers (dams)</td><td> </td><td class="money">EUR 17.50</td></tr> - <tr><td colspan=3>Trip to Marseille for hosting at Lost-Oasis</td></tr> - <tr><td>Car rent for going to Marseille (boklm)</td><td> </td><td class="money">EUR 135.00</td></tr> - <tr><td>Gasoline for the car (dams)</td><td> </td><td class="money">EUR 63.00</td></tr> - <tr><td>Croissants for the <em>ielo</em> team (dams)</td><td> </td><td class="money">EUR 12.12</td></tr> - <tr><td>TGV for going back to Paris for 3 people (ennael)</td><td> </td><td class="money">EUR 128.88</td></tr> - <tr><td colspan=3> </td></tr> - <tr><td>Total</td><td class="money">EUR 8 801.66</td><td class="money">EUR 1 277.77</td></tr> - <tr><td>Balance</td><td colspan=2 class="money">EUR 7 523.96</td></tr> - </tbody></table> - <h2>Bank accounts situation</h2> - <ul> - <li>Paypal (non-for-profit organisation account): EUR 63.51</li> - <li>Main account (with checkbook and no credit card): EUR 1 310.24</li> - <li>Savings account (between 2% and 4% of interest): EUR 4 000.00</li> - <li>AUFML account (part to be transfered to Mageia.Org): EUR 2 150.21</li> - </ul> - <h2>Miscellaneous</h2> - <ul> - <li>Donations are mixed as at the beginning they were managed by AUFML. We had a bank transfert with all donations.</li> - <li>You can help Mageia.Org by <a href="/en/donate/" hreflang="en">doing a donation</a>.</li> - <li>You can see the <a href="/en/thank-you" hreflang="en">"thank you" page</a>.</li> - </ul> - <h2>Contact</h2> - Financial report published by Mageia.Org Treasurer on the 2010 Fiscal Year - Damien Lallement).<br> - You can contact us by sending an email to <em>treasurer[at]mageia[dot]org</em>.<br/> - Last update: Mar 18 12:18:53 CET 2011. - </div> - </div> - </div> - </div> -</body> -</html> diff --git a/en/about/reports/2011/index.php b/en/about/reports/2011/index.php deleted file mode 100644 index 0af0ba638..000000000 --- a/en/about/reports/2011/index.php +++ /dev/null @@ -1,30 +0,0 @@ -<?php -/** Mageia.org 2011 fi report. */ - -$year = 2011; -$source_csv = 'mageia-financial-report-2011.csv'; -$page_kw = 'mageia, financial report, 2011, revenues, expenses'; - -$js_options_hAxis = '{title: "2011"}'; -$js_data2_values = <<<S - ['2010', 8801.66, 1277.77], - ['2011', 11154.02, 8327.25] -S; - -$intro = <<<S - <p>Here is our financial report for 2011.</p> - - <ul class="hl"> - <li>Read the <a href="mageia_rapport_financier_2011_fr.pdf" hreflang="fr">French, original report</a> - or the <a href="mageia_financial_report_2011_en.pdf" hreflang="en">English translation</a> - (both are PDF documents).</li> - <li>Get the <a href="mageia-financial-report-2011.csv">raw report data</a> - (CSV document, licensed under <a href="http://opendatacommons.org/licenses/odbl/1.0/">ODbL 1.0</a>). - The rest of this page is built from this data.</li> - </ul> -S; - -$last_known_account_title = sprintf('Account status on December 31<sup>st</sup>, %s', $year); - -include '../template.php'; - diff --git a/en/about/reports/2011/index2.php b/en/about/reports/2011/index2.php deleted file mode 100644 index 67f2a6b67..000000000 --- a/en/about/reports/2011/index2.php +++ /dev/null @@ -1,67 +0,0 @@ -<!DOCTYPE html> -<html dir="ltr" lang="en"> -<head> - <meta charset="utf-8"> - <title>Mageia Financial Report (2011)</title> - <meta name="description" content="Mageia is new community-based Linux distribution."> - <meta name="keywords" content="mageia, financial report, 2011"> - <meta name="author" content="Mageia"> - <link rel="stylesheet" type="text/css" href="/g/style/all.css"> - <?php include '../../../../analytics.php'; ?> -</head> -<body> - <?php include '../../../../langs.php'; ?> - - <div id="doc" class="yui-t7"> - <div id="hd" role="banner"><h1><a id="logo" href="/en/"><span>Mageia</span></a> <span class="lsep">|</span> <span class="subh">Financial Report (2011)</span></h1></div> - <div id="bd" role="main"> - <div class="yui-g"> - <div class="para values"> - <p style="color: #fff; background: red; padding: 0.3em 0.4em 0.4em 0.6em; font-size: 85%;"> - Being redesigned – Take with a grain of salt for now.</p> - <?php - include G_APP_ROOT . '/lib/fi-report.php'; - - $mfr = Mageia_Financial_Report::build(array( - 'accounts' => 'mageia-accounts-2011.csv', - 'report' => 'mageia-report-2011.csv', - 'forecast' => 'mageia-forecast-2011.csv' - )); - - $hReport = $mfr->html_report(); - $hForecast = $mfr->html_forecast(); - $hAccounts = $mfr->html_accounts(); - $hSummary = $mfr->html_summary(); - ?> - <h2>Summary</h2> - <?php echo $hSummary; ?> - <hr> - - <h2>Bank accounts situation</h2> - <?php echo $hAccounts; ?> - <hr> - - <h2>Financial Report</h2> - <?php echo $hReport; ?> - <hr> - - <h2>Forecast for 2011</h2> - <?php echo $hForecast; ?> - <hr> - - <h2>Miscellaneous</h2> - <ul> - <li>You can <a href="#" hreflang="en">download this report</a> as a PDF file.</li> - <li>You can help Mageia.Org by <a href="/en/donate/" hreflang="en">doing a donation</a>.</li> - <li>You can see the <a href="/en/thank-you" hreflang="en">"thank you" page</a>.</li> - </ul> - <hr> - <h2>Contact</h2> - <p>Financial report published by Damien Lallement (Mageia Treasurer on the 2011 Fiscal Year).<br> - You can contact him by sending an email to <em>treasurer[at]mageia[dot]org</em>.</p> - </div> - </div> - </div> - </div> -</body> -</html>
\ No newline at end of file diff --git a/en/about/reports/2011/mageia-accounts-2011.csv b/en/about/reports/2011/mageia-accounts-2011.csv deleted file mode 100644 index 7952e8010..000000000 --- a/en/about/reports/2011/mageia-accounts-2011.csv +++ /dev/null @@ -1,7 +0,0 @@ -head;Bank accounts -head;Current accounts positions -head;http://www.mageia.org/ -head;Account;Amount -;Paypal account (not-for-profit organisation account);308.13 -;Main account (with checkbook, no credit card);292.85 -;Savings account (between 2% and 4% of annual interest rate);8000 diff --git a/en/about/reports/2011/mageia-financial-report-2011.csv b/en/about/reports/2011/mageia-financial-report-2011.csv deleted file mode 100644 index 7a030c948..000000000 --- a/en/about/reports/2011/mageia-financial-report-2011.csv +++ /dev/null @@ -1,95 +0,0 @@ -"# Head",,,,,, -"title","Mageia.org financial report for year 2011",,,,, -"org","mageia.org",,,,, -"owner","mageia.org",,,,, -"manager","mageia.org treasurer",,,,, -"contact","See http://www.mageia.org/en/about/reports/",,,,, -"type","financial report",,,,, -"year",2011,,,,, -"currency","EUR",,,,, -"url","http://www.mageia.org/en/about/reports/",,,,, -"licence","ODbL-1.0","This financial report data is made available under the Open Database License: http://opendatacommons.org/licenses/odbl/1.0/. Any rights in individual contents of the database are licensed under the Database Contents License: http://opendatacommons.org/licenses/dbcl/1.0/",,,, -"last updated",2012/05/11,,,,, -"comment","This is a first attempt to provide open and direct access to Mageia financial data. We will try to improve on it, feel free to suggest improvements in format, detail, presentation.",,,,, -,,,,,, -"",,,,,, -"# Account balance on 2011/12/31",,,,,, -"total","8166,37",,,,, -"main account","413,13",,,,, -"paypal","653,24",,,,, -"savings account",7100,,,,, -,,,,,, -"# Income Statement",,,,,, -,,,,,, -"## Revenues",,,,,, -"Donations","11150,96",,,,, -"Bank interests","3,06",,,,, -"Total of revenues","11154,02",,,,, -,,,,,, -"## Expenses",,,,,, -"Hardware (servers)","5500,45",,,,, -"Events (FOSDEM, Solutions Linux)","2091,39",,,,, -"Trademark registration",280,,,,, -"Transporation & accomodation","166,5",,,,, -"Shipments","126,98",,,,, -"Assoc. Membership",100,,,,, -"Administrative fees",44,,,,, -"Total of expenses","8327,25",,,,, -,,,,,, -"Net Income","2826,77",,,,, -,,,,,, -,,,,,, -"# Balance Sheet (incomplete)",,,,,, -,,,,,, -"## Liabilities",,,,,, -"Donations","11150,96",,,,, -,,,,,, -"## Assets",,,,,, -"Trademark",280,,,,, -"Hardware, servers","TBD",,,,, -"Promotional materials","TBD",,,,, -"Cash","8166,37",,,,, -,,,,,, -,,,,,, -"# Income details",,,,,, -"## Donations monthly summary",,,,,, -"month","count","total amount","check","transfer","paypal","cash" -1,,"161,15",30,50,"81,15",0 -2,,"3907,83",0,"2360,55","687,28",860 -3,,"109,51",0,100,"9,51",0 -4,,"283,73",0,60,"223,73",0 -5,,"549,3",0,0,"549,3",0 -6,,"907,9",80,"234,5","593,4",0 -7,,"435,13",25,6,"404,13",0 -8,,"263,84",0,30,"233,84",0 -9,,"707,96",0,50,"657,96",0 -10,,"1599,94",375,240,"984,94",0 -11,,"1341,34",300,0,"1041,34",0 -12,,"508,33",0,375,"508,33",0 -,,,,,, -,,,,,, -"# Expenses details",,,,,, -,,,,,, -"## More details",,,,,, -"date","category","description","amount", -2010-09-18,"trademark","Mageia, INPI",280, -2010-10-20,"infra:hardware","HDD","242,7", -2010-11-11,"admin","Administrative cost for Mageia.org",44, -2011-01-04,"membership","April.org",100, -2011-02-04,"marketing:promotional","Stickers & Tshirts FOSDEM 2011","1932,14", -2011-02-04,"admin","Money box","17,93", -2011-02-06,"transport/accomodation","FOSDEM 2011, 1 person","166,5", -2011-03-01,"shipments","tshirts for Chemnitzer 2011","54,65", -2011-04-10,"infra:hosting","SSL certificate","215,28", -2011-05-09,"marketing:promotional","Posters, flyers, Solutions Linux 2011","159,25", -2011-05-17,"shipments","tshirts for Solutions Linux 2011","12,3", -2011-05-26,"shipments","tshirts",25, -2011-05-30,"infra:hosting","Gandi hosting, RAM",250, -2011-10-25,"infra:hardware","Dell server","2669,6", -2011-10-26,"infra:hardware","ARM bs boards","294,05", -2011-11-14,"infra:hardware","HDD (backup server)","1149,83", -2011-11-17,"shipments","stickers, flyers","35,03", -2011-11-29,"infra:hardware","buildsystem SSD","678,99", -,,,,,, -,,,,,, -"# That's all folks!",,,,,, diff --git a/en/about/reports/2011/mageia-forecast-2011.csv b/en/about/reports/2011/mageia-forecast-2011.csv deleted file mode 100644 index 224496c27..000000000 --- a/en/about/reports/2011/mageia-forecast-2011.csv +++ /dev/null @@ -1,16 +0,0 @@ -head;2011 Forecast; -head; -head;http://www.mageia.org/ -head;Description of planned expediture;Unit price;Quantity;Recurrence;Total price;Status -;Goodies;4500;1;1;;Pending -;April;100;1;1;;Pending -;Gandi (hosting: +1536MB of RAM);2.39;6;12;;Done (Wed Mar 30) -;Dedibox (build ISO);14.99;1;12;;Pending -;Internet domains;15;7;1;;Pending -;Fiona (backup server);1500;1;1;;Pending -;2 new nodes for BS;2500;2;1;;Pending -;Event box;1500;1;1;;Pending -;Event travel;1000;1;2;;Pending -;HW for spare;3000;1;1;;Pending -;Brand registration;250;1;1;;Pending -;Reserve fund;4000;1;1;;Pending
\ No newline at end of file diff --git a/en/about/reports/2011/mageia-report-2011.csv b/en/about/reports/2011/mageia-report-2011.csv deleted file mode 100644 index 9bd8230a8..000000000 --- a/en/about/reports/2011/mageia-report-2011.csv +++ /dev/null @@ -1,26 +0,0 @@ -head;Financial report -head;Lists transactions that happened on Mageia.Org accounts -head;http://www.mageia.org/ -head;Date;Transaction description;Outgoing;Income -cat;Donations and sales -;;Donations via Paypal/transfer/check;;1920.97; -;;Sale of T-shirts;;1050; -cat;Fees and Administrative costs -;;Administrative costs for the birth of Mageia.Org (JO);44; -;;April (annual fee);100; -;;INPI brand registration for 10 years (rda);250; -;;Annual interest of our savings account;;3.06 -cat;Goodies and accessories -;;Posters and flyers for Solutions Linux (rda);159.25; -;;Stickers and T-shirts for FOSDEM;1932.14; -;;Money box (dams);17.93; -cat;Shipments -;;40 TS to wobo for Chemnitzer Linuxtage;54.65; -;;3 TS to donors in France (dams);12.30; -;;2 TS to saipo for Dijon event in France (dams);25; -cat;Hardware and hosting -;;RAM on Gandi.net hosting (for blog/planet/www);250; -;;SSL for domains on Gandi.net;215.28; -;;HDD for servers (boklm);242.70; -cat;Travel and events -;;Hotel + train for wobo (FOSDEM 2011);166.50;
\ No newline at end of file diff --git a/en/about/reports/2011/mageia_financial_report_2011_en.pdf b/en/about/reports/2011/mageia_financial_report_2011_en.pdf Binary files differdeleted file mode 100644 index e4ffcdb57..000000000 --- a/en/about/reports/2011/mageia_financial_report_2011_en.pdf +++ /dev/null diff --git a/en/about/reports/2011/mageia_rapport_financier_2011_fr.pdf b/en/about/reports/2011/mageia_rapport_financier_2011_fr.pdf Binary files differdeleted file mode 100644 index c86f48eca..000000000 --- a/en/about/reports/2011/mageia_rapport_financier_2011_fr.pdf +++ /dev/null diff --git a/en/about/reports/2012/index.php b/en/about/reports/2012/index.php deleted file mode 100644 index 3cec931eb..000000000 --- a/en/about/reports/2012/index.php +++ /dev/null @@ -1,32 +0,0 @@ -<?php -/** Mageia.org 2012 fi report. */ - -$year = 2012; -$source_csv = 'mageia-financial-report-2012.csv'; -$page_kw = 'mageia, financial report, 2012, revenues, expenses'; - -$js_options_hAxis = '{title: "2012"}'; - -// year, total revenues, total expenses -$js_data2_values = <<<S - ['2010', 8801.66, 1277.77], - ['2011', 11154.02, 8327.25], - ['2012', 10072.08, 10766.69] -S; - -$intro = <<<S - <ul> - <li>Read the <a href="mageia_rapport_financier_2012_fr.pdf" hreflang="fr">French, original report</a> - or the <a href="mageia_financial_report_2012_en.pdf" hreflang="en">English translation</a> - (both are PDF documents).</li> - <li>Get the <a href="mageia-financial-report-2012.csv">raw report data</a> - (CSV document, licensed under <a href="http://opendatacommons.org/licenses/odbl/1.0/">ODbL 1.0</a>). - The rest of this page is built from this data.</li> - <li>You may also want to check out our <a href="https://wiki.mageia.org/en/General_report_2012">general report for 2012</a>.</li> - </ul> -S; - -$last_known_account_title = sprintf('Account status on December 31<sup>st</sup>, %s', $year); - -include '../template.php'; - diff --git a/en/about/reports/2012/mageia-financial-report-2012.csv b/en/about/reports/2012/mageia-financial-report-2012.csv deleted file mode 100644 index c9963799c..000000000 --- a/en/about/reports/2012/mageia-financial-report-2012.csv +++ /dev/null @@ -1,96 +0,0 @@ -# Head -title,Mageia.org financial report for year 2012,,,,, -org,mageia.org,,,,, -owner,mageia.org,,,,, -manager,mageia.org treasurer,,,,, -contact,See http://www.mageia.org/en/about/reports/,,,,, -type,financial report,,,,, -year,2012,,,,, -currency,EUR,,,,, -url,http://www.mageia.org/en/about/reports/,,,,, -licence,ODbL-1.0,This financial report data is made available under the Open Database License: http://opendatacommons.org/licenses/odbl/1.0/. Any rights in individual contents of the database are licensed under the Database Contents License: http://opendatacommons.org/licenses/dbcl/1.0/,,,, -last updated,2013/01/29,,,,, -comment,This is a first attempt to provide open and direct access to Mageia financial data. We will try to improve on it, feel free to suggest improvements in format, detail, presentation.,,,,, -,,,,,, -,,,,,, -# Account balance,,,,,, -total,8423.07,,,,, -main account,2191.13,,,,, -paypal,828.81,,,,, -savings account,5403.13,,,,, -,,,,,, -# Income Statement,,,,,, -,,,,,, -## Revenues,,,,,, -Donations,0,,,,, -Bank interests,0,,,,, -Total of revenues,0,,,,, -,,,,,, -## Expenses,,,,,, -Total of expenses,0,,,,, -,,,,,, -Net Income,0,,,,, -,,,,,, -,,,,,, -# Balance Sheet (incomplete),,,,,, -,,,,,, -## Liabilities,,,,,, -Donations,0,,,,, -,,,,,, -## Assets,,,,,, -Hardware, servers,TBD,,,,, -Promotional materials,TBD,,,,, -Cash,0,,,,, -,,,,,, -,,,,,, -# Income details,,,,,, -## Donations monthly summary,,,,,, -month,count,total amount,check,transfer,paypal,cash -1,19,624.48,0,80.0,544.48,0 -2,15,630.00,0,200.00,430.00,0 -3,9,684.13,0,423.13,261.00,0 -4,10,610.00,0,100.00,510.00,0 -5,25,1374.00,100.00,555.00,719.00,0 -6,14,881.00,135.00,125.00,461.00,160.00 -7,13,692.67,0,430.67,262.00,0 -8,13,497.00,190.00,0,307.00,0 -9,28,1251.80,90.00,450.00,801.80,0 -10,24,1838.00,100.00,810.00,928.00,0 -11,9,257.00,0,0,257.00,0 -12,15,732.00,0,267.00,465.00,0 -,,,,,, -,,,,,, -# Expenses details,,,,,, -,,,,,, -## More details,,,,,, -date,category,description,amount, -2012-01-13,transport,Datacenter: train to Marseille,284.00, -2012-01-13,asso,Cotisation April.org,100.00, -2012-01-28,transport,FOSDEM: plane for Thomas/tmb,347.29, -2012-01-30,infra:hardware,various purchases for ARM BS,129.59, -2012-01-31,bank,Paypal fees,13.87, -2012-02-13,marketing:merchandising,FOSDEM: refund for Patricia/Trish,767.66, -2012-02-29,bank,Paypal fees,10.52, -2012-03-12,bank,Transfer change fees,143.92, -2012-03-31,bank,Paypal fees,6.51, -2012-04-30,bank,Paypal fees,9.94, -2012-05-31,bank,Paypal fees,17.4, -2012-06-05,infra:hardware,2 routers,375.87, -2012-06-31,bank,Paypal fees,9.72, -2012-07-26,infra:hardware,2 servers,7613.14, -2012-07-31,bank,Paypal fees,7.72, -2012-08-01,infra:hosting,Gandi: domain names renewal,30.64, -2012-08-03,transport,Marseille DC: train+hotel for 3 people,370.96, -2012-08-25,transport,Marseille DC: hotel complement,30.00, -2012-08-25,transport,Marseille DC: metro,12.80, -2012-08-25,infra:hardware,wires,40.93, -2012-08-26,infra:hosting,Gandi: hosting provision,100.00, -2012-08-31,bank,Paypal fees,9.24, -2012-09-27,infra:hosting,Online,279.82, -2012-09-30,bank,Paypal fees,18.09, -2012-10-31,bank,Paypal fees,20.21, -2012-11-30,bank,Paypal fees,7.16, -2012-12-31,bank,Paypal fees,9.69 -,,,,,, -,,,,,, -# That's all folks!,,,,,, diff --git a/en/about/reports/2012/mageia_financial_report_2012_en.pdf b/en/about/reports/2012/mageia_financial_report_2012_en.pdf Binary files differdeleted file mode 100644 index 4cbd91982..000000000 --- a/en/about/reports/2012/mageia_financial_report_2012_en.pdf +++ /dev/null diff --git a/en/about/reports/2012/mageia_rapport_financier_2012_fr.pdf b/en/about/reports/2012/mageia_rapport_financier_2012_fr.pdf Binary files differdeleted file mode 100644 index 5216f59f3..000000000 --- a/en/about/reports/2012/mageia_rapport_financier_2012_fr.pdf +++ /dev/null diff --git a/en/about/reports/2013/index.php b/en/about/reports/2013/index.php deleted file mode 100644 index 71046e497..000000000 --- a/en/about/reports/2013/index.php +++ /dev/null @@ -1,30 +0,0 @@ -<?php -/** Mageia.org 2013 fi report. */ - -$year = 2013; -$source_csv = 'mageia-financial-report-2013.csv'; -$page_kw = 'mageia, financial report, 2013, revenues, expenses'; - -$js_options_hAxis = '{title: "2013"}'; - -// year, total revenues, total expenses -$js_data2_values = <<<S - ['2010', 8801.66, 1277.77], - ['2011', 11154.02, 8327.25], - ['2012', 10072.08, 10766.69], - ['2013', 706.07, 2700.12] -S; - -$intro = <<<S - <ul> - <li>Get the <a href="mageia-financial-report-2012.csv">raw report data</a> - (CSV document, licensed under <a href="http://opendatacommons.org/licenses/odbl/1.0/">ODbL 1.0</a>). - The rest of this page is built from this data.</li> - </ul> -S; - -$last_known_account_title = sprintf('Account status on December 31<sup>st</sup>, %s', $year); -$last_known_account_title = sprintf('Account status'); - -include '../template.php'; - diff --git a/en/about/reports/2013/mageia-financial-report-2013.csv b/en/about/reports/2013/mageia-financial-report-2013.csv deleted file mode 100644 index a90ef0aa6..000000000 --- a/en/about/reports/2013/mageia-financial-report-2013.csv +++ /dev/null @@ -1,78 +0,0 @@ -# Head -title,Mageia.org financial report for year 2012,,,,, -org,mageia.org,,,,, -owner,mageia.org,,,,, -manager,mageia.org treasurer,,,,, -contact,See http://www.mageia.org/en/about/reports/,,,,, -type,financial report,,,,, -year,2013,,,,, -currency,EUR,,,,, -url,http://www.mageia.org/en/about/reports/,,,,, -licence,ODbL-1.0,This financial report data is made available under the Open Database License: http://opendatacommons.org/licenses/odbl/1.0/. Any rights in individual contents of the database are licensed under the Database Contents License: http://opendatacommons.org/licenses/dbcl/1.0/,,,, -last updated,2013/01/29,,,,, -comment,This is a first attempt to provide open and direct access to Mageia financial data. We will try to improve on it, feel free to suggest improvements in format, detail, presentation.,,,,, -,,,,,, -,,,,,, -# Account balance,,,,,, -total,8660.87,,,,, -main account,1997.26,,,,, -paypal,1125.12,,,,, -savings account,5538.49,,,,, -,,,,,, -# Income Statement,,,,,, -,,,,,, -## Revenues,,,,,, -Donations,0,,,,, -Bank interests,0,,,,, -Total of revenues,0,,,,, -,,,,,, -## Expenses,,,,,, -Total of expenses,0,,,,, -,,,,,, -Net Income,0,,,,, -,,,,,, -,,,,,, -# Balance Sheet (incomplete),,,,,, -,,,,,, -## Liabilities,,,,,, -Donations,0,,,,, -,,,,,, -## Assets,,,,,, -Hardware, servers,TBD,,,,, -Promotional materials,TBD,,,,, -Cash,0,,,,, -,,,,,, -,,,,,, -# Income details,,,,,, -## Donations monthly summary,,,,,, -month,count,total amount,check,transfer,paypal,cash -1,10,706.07,50.0,350.0,306.07,0, -2,0,0.0,0.0,0.0,0.0,0.0, -3,0,0.0,0.0,0.0,0.0,0.0, -4,0,0.0,0.0,0.0,0.0,0.0, -5,0,0.0,0.0,0.0,0.0,0.0, -6,0,0.0,0.0,0.0,0.0,0.0, -7,0,0.0,0.0,0.0,0.0,0.0, -8,0,0.0,0.0,0.0,0.0,0.0, -9,0,0.0,0.0,0.0,0.0,0.0, -10,0,0.0,0.0,0.0,0.0,0.0, -11,0.0,0.0,0.0,0.0,0.0,0.0, -12,0.0,0.0,0.0,0.0,0.0,0.0, - -## Other revenues -date,description,amount -2013-01-01,2012 saving interests,135.36 - -,,,,,, -,,,,,, -# Expenses details,,,,,, -,,,,,, -## More details,,,,,, -date,category,description,amount, -2013-01-24,infra:hardware,upgrade storage disks,563.87, -2013-01-31,bank,Paypal fees,9.76, -2013-02-01,marketing:tshirts,T-Shirts,2126.49, - -,,,,,, -,,,,,, -# That's all folks!,,,,,, diff --git a/en/about/reports/README.md b/en/about/reports/README.md deleted file mode 100644 index b47918444..000000000 --- a/en/about/reports/README.md +++ /dev/null @@ -1,17 +0,0 @@ - - - - -1) go to bank account - - - note current level - - note all operations in the past months - - count all donations, by chq, cash or transfer - - note names of all donators - -2) go to paypal account - - - note current level - - note all operations in the past months - - count all donations, by paypal or by transfer - - note names of all donators
\ No newline at end of file diff --git a/en/about/reports/index.php b/en/about/reports/index.php deleted file mode 100644 index 406e11ab7..000000000 --- a/en/about/reports/index.php +++ /dev/null @@ -1,38 +0,0 @@ -<?php -define('HLANG', true); -require '../../../langs.php'; -$dictionary = read_translation_file($locale, 'about/reports'); - -?><!DOCTYPE html> -<html dir="ltr" lang="<?php echo $locale; ?>"> -<head> - <meta charset="utf-8"> - <title><?php _g('Mageia activity & financial reports')?></title> - <meta name="description" content="<?php _g('Mageia reports, every year.')?>"> - <meta name="keywords" content="<?php _g('mageia, reports, activity, financial')?>"> - <meta name="author" content="Mageia"> - <link rel="stylesheet" type="text/css" href="/g/style/all.css"> - <?php include '../../../analytics.php'; ?> -</head> -<body class="about"> - <?php echo $hsnav; ?> - <h1 id="mgnavt"><?php _g('Activity Reports')?></h1> - <div id="doc" class="yui-t7"> - <div id="bd" role="main"> - <div class="yui-g"> - <div class="para values"> - <p><?php _g('Here you will find our various activity and financial reports for every year.')?></p> - - <ul> - <li>2014: <?php _g('%sFinancial report</a>%s.', array('<a href="https://treasurer.mageia.org/y_2014.html">', ' ' . _r('(in progress)')));?></li> - <li>2013: <?php _g('%sFinancial report</a>%s.', array('<a href="https://treasurer.mageia.org/y_2013.html">', ''));?></li> - <li>2012: <?php _g('%sFinancial report</a>%s.', array('<a href="2012/">', ''));?></li> - <li>2011: <?php _g('<a href="https://wiki.mageia.org/en/Rapport_moral_2011">Moral report</a> (in French & English), <a href="2011/">financial report</a>.')?></li> - <li>2010: <?php _g('Moral report, <a href="2010/">financial report</a>.')?></li> - </ul> - </div> - </div> - </div> - </div> -</body> -</html> diff --git a/en/about/reports/template.php b/en/about/reports/template.php deleted file mode 100644 index 2cd6e6aeb..000000000 --- a/en/about/reports/template.php +++ /dev/null @@ -1,350 +0,0 @@ -<?php -/** - * Template for financial reports. - * See 201?/index.php scripts including it. - * - * TODO rewrite this properly, of course. Still use a CSV? Use a clean template anyway. -*/ -$_months = array( - 1 => 'January', 2 => 'February', 3 => 'March', - 4 => 'April', 5 => 'May', 6 => 'June', - 7 => 'July', 8 => 'August', 9 => 'September', - 10 => 'October', 11 => 'November', 12 => 'December' -); - -/** - * Format numbers after ISO_31 recommandation, - * using the comma as decimal sep. - * See http://en.wikipedia.org/wiki/ISO_31-0#Numbers - * - * @param float $n decimal number - * @param char $dec_sep - * - * @return string -*/ -function _report_number_format($n, $dec_sep = ',') -{ - return str_replace('#', ' ', number_format($n, 2, $dec_sep, '#')); -} - -$data = file($source_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_fill(1, 12, 0); -$count = array_fill(1, 12, 0); -$tmp = $parsed['# Expenses details > ## More details']; -array_shift($tmp); -foreach ($tmp as $line) { - if (count($line) < 4) - continue; - - $month = date('n', strtotime($line[0])); - $list[$month] += $line[3]; // amount - $count[$month] += 1; -} -$expenses_monthly_summary = array($list, $count); - -$flow = array( - 'expenses' => $list, - 'expenses_op' => $count, - 'revenue' => null, - 'revenue_op' => null -); - -$list = array(); -$count = array(); - -// FIXME take ## Other revenues lines into account. -foreach ($parsed['# Income details > ## Donations monthly summary'] as $line) { - if (count($line) < 3) - continue; - - $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; - -include 'template_lib.php'; - -$R = get_revenues($parsed['# Income details > ## Donations monthly summary'], $_months); -$expenses_total = array_sum($expenses_monthly_summary[0]); - - -?><!DOCTYPE html> -<html dir="ltr" lang="en"> -<head> - <meta charset="utf-8"> - <title>Mageia.org <?php echo $year; ?> Financial Report</title> - <meta name="description" content="Financial report for Mageia.org activity in <?php echo $year?>"> - <meta name="keywords" content="<?php echo $page_kw;?>"> - <meta name="author" content="Mageia.org"> - <link rel="stylesheet" type="text/css" href="/g/style/all.css"> - <?php include '../../../../analytics.php'; ?> - <!--Load the AJAX API--> - <script type="text/javascript" src="https://www.google.com/jsapi"></script> - <script type="text/javascript"> - google.load('visualization', '1', {packages: ['corechart']}); - </script> - <script type="text/javascript"> - function drawVisualization() { - // Some raw data (not necessarily accurate) - var data = google.visualization.arrayToDataTable([ - ['Month', 'Revenues', 'Expenses'], - <?php - $arr = array(); - $qRevenues = 0; - $qExpenses = 0; - $i = 1; - $j = 1; - $qarr = array(); - foreach ($flow['revenue'] as $month => $val) { - - // save monthly data - $arr[] = sprintf("['%s', %s, %s]", $_months[$month], str_replace(',', '.', $val), str_replace(',', '.', $flow['expenses'][$month])); - - // sum quarterly data - $qRevenues += str_replace(',', '.', $val); - $qExpenses += str_replace(',', '.', $flow['expenses'][$month]); - - // save quarterly data - if ($i % 3 == 0) { - $qarr[] = sprintf("['%s', %s, %s]", 'Q' . $j, $qRevenues, $qExpenses); - - $qRevenues = 0; - $qExpenses = 0; - $j += 1; - } - - $i += 1; - } - echo implode(', ', $arr); - ?> - ]); - - var options = { - title : 'Monthly Cash Flow', - vAxis: {title: "Amount (€)"}, - hAxis: {title: "<?php echo $year?>"}, - seriesType: "bars", - }; - - var chart = new google.visualization.ComboChart(document.getElementById('chart_div')); - chart.draw(data, options); - - var data2 = google.visualization.arrayToDataTable([ - ['Year', 'Revenues', 'Expenses'], - <?php echo $js_data2_values; ?> - ]); - var options2 = { - title : 'Yearly Cash Flow', - vAxis: {title: "Amount (€)"}, - hAxis: {title: "Years"}, - seriesType: "bars" - }; - - var chart2 = new google.visualization.ComboChart(document.getElementById('chart2')); - chart2.draw(data2, options2); - - var data3 = google.visualization.arrayToDataTable([ - ['Quarter', 'Revenues', 'Expenses'], - <?php echo implode(', ', $qarr); ?> - ]); - var options3 = { - title : 'Quarterly Cash Flow', - vAxis: {title: "Amount (€)"}, - hAxis: {title: "<?php echo $year?>"}, - seriesType: "bars" - }; - - var chart3 = new google.visualization.ComboChart(document.getElementById('chart3')); - chart3.draw(data3, options3); - } - google.setOnLoadCallback(drawVisualization); - </script> -</head> -<body class="about reports"> - <?php include '../../../../langs.php'; ?> - <header id="mgnavt"> - <h1><a href="../">Activity Reports</a> » <?php echo $year; ?> Financial Report</h1> - <ul> - </ul> - </header> - <style> - #summary { width: 300px; float: left; text-align: left; background: #fff; border-bottom: 1px solid #ddd; } - #report { text-align: left; width: 800px; float: left; border: 1px solid #ddd; border-top: 0; } - #links { width: 150px; float: left; background: #fff; text-align: left; border-right: 1px solid #ddd; border-bottom: 1px solid #ddd; padding: 1em;} - .accounts tr.total { font-weight: 600; } - </style> - <aside id="summary"> - <div class="para"> - <h2><?php echo $last_known_account_title?></h2> - <p>All amounts are in EURO.</p> - <p>Last updated on <?php echo $parsed['# Head']['last updated']; ?>.</p> - <?php - $k = sprintf('# Account balance on %d/12/31', $year); - $k = array_key_exists($k, $parsed) ? $k : '# Account balance'; - $v = $parsed[$k]; - $s = '<table class="fr-table accounts">'; - foreach ($v as $k => $w) { - $s .= sprintf('<tr class="%s"><td>%s</td><td class="money">%s</td></tr>', - str_replace(' ', '-', $k), - $k, - _report_number_format($w)); - } - $s .= '</table>'; - echo $s; - ?> - </div> - <div class="para"> - <?php echo $intro; ?> - <p>Feel free to <a href="/en/contact/">contact us</a> regarding this report.</p> - </div> - </aside> - - <article id="report"> - <section class="para values" id="flow"> - <h2>Cash flow</h2> - <div id="chart_div" style="width: 650px; height: 280px;"></div> - <div id="chart3" style="width: 650px; height: 200px;"></div> - <div id="chart2" style="width: 650px; height: 200px;"></div> - <hr> - </section> - <section class="para values" id="inc-state"> - <h2>Income statement</h2> - <!-- <mark>full income statement. For now, check details below.</mark>--> - <table summary="Income statement" class="fr-table"> - <tbody> - <tr> - <th>Revenues</th> - <td></td> - <td class="money"><?php echo _report_number_format($R['data']['total']);?></td> - </tr> - <tr> - <th>Expenses</th> - <td class="money"><?php echo _report_number_format($expenses_total);?></td> - <td></td> - </tr> - </tbody> - <tfoot> - <tr> - <?php - $result = $R['data']['total'] - $expenses_total; - if ($result > 0): - ?> - <td>Net Income</td> - <td></td> - <td class="money"><?php echo _report_number_format($result); ?></td> - <?php else: ?> - <td>Net Loss</td> - <td class="money"><?php echo _report_number_format(-$result); ?></td> - <td></td> - <?php endif; ?> - </tr> - </tfoot> - </table> - </section> - <hr> - <!-- - <section class="para values" id="balance"> - <h2>Balance sheet</h2> - <table class="fr-table"> - <thead><tr><th colspan="2">Assets</th> - <th colspan="2">Liabilities</th></tr></thead> - <tbody><tr><td colspan="2"> - <table class="fr-table"> - <?php - $s = ''; - foreach ($parsed['# Balance Sheet (incomplete) > ## Assets'] as $k => $v) { - $v = str_replace(',', '.', $v); - $v = is_numeric($v) ? _report_number_format($v) : $v; - $s .= sprintf('<tr><td>%s</td><td class="money">%s</td></tr>', $k, $v); - } - echo $s; - ?> - </table> - </td><td colspan="2"> - <table class="fr-table"> - <?php - $s = ''; - foreach ($parsed['# Balance Sheet (incomplete) > ## Liabilities'] as $k => $v) { - $v = str_replace(',', '.', $v); - $v = is_numeric($v) ? _report_number_format($v) : $v; - $s .= sprintf('<tr><td>%s</td><td class="money">%s</td></tr>', $k, $v); - } - echo $s; - ?> - </table> - </td></tr></tbody> - <tfoot><tr><td>Total Assets</td><td></td> - <td>Total Liabilities</td><td></td></tr></tfoot> - </table> - </section> - <hr> - --> - <section class="para values" id="expenses"> - <h2>Expenses</h2> - <?php $E = get_expenses($parsed['# Expenses details > ## More details']); echo $E['html']; ?> - </section> - <hr> - <section class="para values" id="revenues"> - <h2>Income, donations</h2> - <?php echo $R['html']; ?> - </section> - <p class="para"><a href="#top">Return to top</a></p> - </article> - - <nav id="links"> - <ul class="hl"> - <li><a href="#flow">Cash flow</a></li> - <li><a href="#inc-state">Income statement</a></li> - <li><a href="#balance">Balance sheet</a></li> - <li><a href="#expenses">Expenses</a></li> - <li><a href="#revenues">Revenues</a></li> - </nav> -</body> -</html> diff --git a/en/about/reports/template_lib.php b/en/about/reports/template_lib.php deleted file mode 100644 index 419ff103c..000000000 --- a/en/about/reports/template_lib.php +++ /dev/null @@ -1,169 +0,0 @@ -<?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 |