Website MySql queries, etc.

Closed

Description

For each of the 4 tabs in the attached excel file I need the information to be populated from the created database and be able to be downloaded into excel.

It is important that a user has the option of running the reports by assignment date in which case the website will check the as of date and subtract the number of days that have elapsed from the report date from the as of date. A user could want to run the report from the discharge date then the website will calculate the difference between the discharge dates and the report date in forming the calculations for the tabs.

Files will contain variousFC's and Pt Types. We should have a mechanism to consolidate the many financial classes into a couple with a mapping tool. For example, if a,b,c,d,e,f,g,h,i,j financial classes appeared in a file, we need a way that says for every file applied to project 1 if accounts are received with a financial class a or b or c map to financial class 1. If d,e,f,g,h are received map to 2. Similarily for the pt type. If we receive multiple we need to be able to map to specific fc's.

Skills: MySQL, PHP, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: j software, h website, mysql report, database queries, d mapping, architecture f, report mysql php database, excel file mysql, mysql subtract, running reports mysql database, mysql specific, queries database, php excel database report, database forming, assignment financial project, reports mysql , financial case, mysql date days, consolidate excel files, php calculate date, mysql project assignment, assignment website, php report tool, reports mysql database, mysql financial website

Project ID: #2742330

Awarded to:

rkgroups

See private message.

$68 USD in 21 days
(92 Reviews)
5.4

4 freelancers are bidding on average $60 for this job

israrkhansoft

See private message.

$60.35 USD in 21 days
(9 Reviews)
2.7
waleedlutfi

See private message.

$42.5 USD in 21 days
(3 Reviews)
2.5
lethanhnamvw

See private message.

$68 USD in 21 days
(0 Reviews)
0.0