hasadna/openpension-website

Open Pension Project Website

OpenPension-website

OpenPension Website is the Web interface for the OpenPension Project
aimed at revealing the secrets behind the pension market.

Our stack

[NodeJS] 1
[ExpressJS] 2
[Marionette] 3
[Handlebars] 4
[Squel] 5
[PostgreSQL] 6
[Memcached] 7
[Elastic] 11

Also used

[Tabletop] 8

Getting Started

1. Clone the repo

   >git clone ...
   >git checkout marionette
   

2. Update submodules

   >git submodule init 
   >git submodule update
   

3. Install [NodeJS] 1

4. Install packages

   >npm install
   >npm install bower -g
   >bower install
   >npm install grunt -g
   >grunt
   

5. Update db connection string in server/config.json (ask somebody if you dont have it)

6. Run the server (default port is 3000)

   >node server/app.js 
   

7. To run the server in dev mode:

   Install node-dev (globally)

   >npm install node-dev -g
   

   Run the server

   >node-dev server/app.js
   

Additional Requirements

For compiling the packages on windows
you might need to install Microsoft Visual Studio
You can get the Express version which is free to download [here] 9

Online version

Visit: [http://www.openpension.org.il] 10

openpension-website's Issues

Admin panel

explore data base visulaisations

Our data base reflects how the pension savings of the public are invested.
We need to consult with developers who have good knowledge of the different graph visualisation we can use,
We also need designers who are willing to consult us regarding site design.

Show Loading spinner on Ajax requests

Pagination of results in Instruments view

Fix overlay in homepage

Breadcrumbs

In my recent commit bcc758c I tried to convert the breadcrumbs you wrote into Bootstrap's component - http://getbootstrap.com/components/#breadcrumbs, but I got lost halfway through. I think it'll prove more efficient.

Issuer view

Public API and documentation

Fix loading of dictionary from Google docs

Pension terminology page

Pages should scroll back to top after loading new data

Steps to reproduce:

1. Click on an investment towards the end of a portfolio page or a modal table.
2. When the new filtered page loads up, it's in the same y-axis position.

Expected result:

Page loads at the top, where the user can see the page's header.

db hint

About your implementation of exports.streamQuery, pg-promise has embedded support for the same type of data streams, only better, more flexible, and consistent with the rest of the library. See Streaming.

Section headings in "Further reading"

There are h4 section headings in the "Further reading" part. I've added a placeholder ("קופות של מגדל") in portfolio.jade and styled it, but you need to replace this with dynamic content.

Ghost funds?

some weird empty lines in funds list

http://www.openpension.org.il/#/portfolio?managing_body=harel&report_year=2015&report_qurater=3

add precentege indication to bars

Quarter select dropdown style

Quarter select dropdown css is broken.
should be 😄

now it is 😢

No results for investment

No results for investment with values in previous quarters
but no rows on current quarter.
(because of how the SQL query is built in portfolio page)

Should be solved when we have a dedicated page for single investment.

[http://www.openpension.org.il/#/portfolio?report_year=2015&report_qurater=3&instrument_name=קרנות מור נדלן בכורה B
](http://www.openpension.org.il/#/portfolio?report_year=2015&report_qurater=3&instrument_name=קרנות מור נדלן בכורה B)

Error when click on fund that has '%' sign

http://www.openpension.org.il/#/portfolio?managing_body=migdal&report_year=2015&report_qurater=3

encode URL - or use fund ID instead of fund name (better 👍 )

Title broken when viewing fund

Title name missing in report-title

Check --> TitleGenerator::createTitle

http://www.openpension.org.il/#portfolio?managing_body=migdal&report_qurater=3&report_year=2015&fund_name=יוזמה

Single investment view

Add google analytics.

Use existing .less files for generating css