jayrav13 / cs673-finance Goto Github PK

Currently, our web application uses the cash column in the users table to determine if someone has enough money to buy a stock. This was the wrong way to address this.

Instead, we have to have the depositing / withdrawing of cash move to the portfolios table.

Current cash entity: https://github.com/jayrav13/cs673-finance/blob/master/database/migrations/01_create_users_table.sql#L12

We have to change this migration to include cash: https://github.com/jayrav13/cs673-finance/blob/master/database/migrations/02_create_portfolios_table.sql

The logic for buying a stock starts here: https://github.com/jayrav13/cs673-finance/blob/master/public/portfolio.php#L52

Cost checking in the above file starts here: https://github.com/jayrav13/cs673-finance/blob/master/public/portfolio.php#L111

Depositing / Withdrawing currently take place here - needs to be moved to the portfolios view:

• View: https://github.com/jayrav13/cs673-finance/blob/master/views/settings.php#L22
• Logic: https://github.com/jayrav13/cs673-finance/blob/master/public/settings.php#L29

Potentially create a new file in includes/ called exporter.php or csv.php that has functions which can format a user's portfolio or account data. The file can then be imported here for functions to be used globally:

https://github.com/jayrav13/cs673-finance/blob/master/includes/config.php#L19

I would just go check out the requirements on Moodle and build this EXACTLY according to them!

Check out the below link:

https://github.com/jayrav13/cs673-finance/blob/master/documentation/erdiagram.png

This is an ER Diagram for our proposed application. The task at hand is to create all of the CREATE TABLE scripts and store them in the database/migrations folder.

Note - be sure to start all files with ##_. The files will be executed in order (i.e. 01_, 02_, etc). This will be important when creating foreign keys.

"autoload.php" is not available inside vendor directory.

config.php (Line#20)

require("../vendor/autoload.php");

The current lookup(...) function returns the current stock price of a symbol. Create a second, optional parameter that requests past closing price and returns accordingly.

TO DO: A feature that allows the user to search for symbols and provides the quotes to the user.