Add feature to PHP code.

IN PROGRESS
Bids
6
Avg Bid (USD)
$241
Project Budget (USD)
$30 - $250

Project Description:
We have created a solution to do bank reconciliation here: http://images.open-org.com/OO-developers/PhotoAccounting/Reconciliation.php

The solution is half-finished and has several bugs/limitations. In order to speed up the development, I want another developer on the project. The starting point is the new feature described here in this project.

To read some background about what a bank reconciliation is and hence the purpose of the software, have a look at the document I have written here: https://docs.google.com/document/d/1NgfB4qXVUPjvmdNbOoS2km7kWv3UbSbaSV_V4c1orUs/edit?usp=sharing

At http://images.open-org.com/OO-developers/PhotoAccounting/Reconciliation.php the left table shows receipts we have typed, and the right column shows the transactions found in the bank.

A limitation of the current solution is that sometimes a receipt will be in a non-danish-currency amount (short form DKK) (like for example dollars). In these cases, the http://images.open-org.com/OO-developers/PhotoAccounting/typer.php interface will set an amount in the amount_original_currency column in the database in the receipt table, but leave the "amount" column empty. The database can be inspected here: http://images.open-org.com/phpPgAdmin/display.php?server=ec2-23-21-91-85.compute-1.amazonaws.com%3A5432%3Aallow&database=d5vaere0kead0i&schema=public&table=receipts&subject=table&return=table

The change I need is that when a row in the database has a row with an empty value in the "amount" column at the point when the reconciliation.php is accessed, then the amount should get converted to DKK so that this converted amount is presented in the "amount" column in the left table in http://images.open-org.com/OO-developers/PhotoAccounting/Reconciliation.php. The amount in the table should be red to indicate that it may not be the exactly correct amount (the exchange rate might be slightly off).

When the record is matched with a column in the right table in reconciliation.php, the amount should get updated to the amount from the bank (but it should stay red, in the case where the match was wrong and should be redone). Basically it means that all receipts that have a currency set to something else than DKK, should be in red.

We have already developed a solution to convert currencies at historical rates, created as a part of this project: https://www.freelancer.com/projects/PHP-Javascript/Create-PHP-module-convert-currencies.4289750.html It can be seen in action here: http://developers.mrnepal.com/mansa/currency.php. That solution utilizes xe.com to download historical rates. I will provide the source code shortly.

Please read the requirements/getting started guide here before starting on this task. https://docs.google.com/document/d/1biEViRLFwlG7GnO_NHYa6m_U0YiUKU9oNpRoCcO4xak/edit

Clarifications will be added to this document so please read this before asking questions

Skills required:
CakePHP, Java, Javascript, PHP, Symfony PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 245
in 12 days
Hire sat12
$ 252
in 5 days
Hire farhaoui
$ 315
in 3 days
$ 257
in 7 days
$ 133
in 3 days
$ 257
in 15 days
$ 300
in 15 days