Em Andamento

Foreclosure tracking system(repost)

Design a web database (PHP/MySQL) structure for tracking foreclosures given an initial Excel spreadsheet. Allow a user to go to an individual property record to modify particular fields. Be able to generate a report of property records that were sold at auction but have not shown up on the MLS.

## Deliverables

All columns from the example spreadsheet will be imported except "cb" and "ncb". When uploading, allow user to specify "Auction Date" and "County" which will be populated for each record imported. User will be able to select previously used Counties.

1. Data maniuplation pages

Give a user ability to update an individual property record to show a property was "REO" or "found on MLS".

- Sold type is either "REO" or not (from the "L or 3rd" column; "L" means "REO")

- Checkbox for "MLS"

- Checkbox for MLS enables a "MLS Date" date field and a "MLS #" numeric field

- Add checkbox field "Viewed" (for when property has been physically inspected)

- Add a "Notes" field to each record, max allowable character limit

- Add "Hide" checkbox field for those that we don't want showing up in reports any more

- Create an array of MLS numbers of properties found in MLS, per report, to be copied and pasted (123456,234567,456789...) from the bottom of the page

2. Report pages (hiding records designated as "Hide", sortable by each column)

Report #1a, b, & c: Show all records that have not been found on MLS, and went through the auction process but not to a 3rd party ("auctioned but no bidders") on a specific interval (less than 60, 60-89, 90-119, 120+ days)

Report #2: Show all records designated as "MLS", ordered by "MLS Date"

3. Home page

- Links to reports of properties that have had no activity within the last 60/90/120+ days (showing the # of properties that meet that criteria). No activity means "MLS" checkbox is not checked since the record was entered

- Link to reports of properties with "MLS" checkbox checked.

- Link to import data page

Notes:

- Multiple counties will be tracked

- "L or 3rd" designates "REO" or "3rd Party"... when field = "3rd", that is "3rd party"

- Data manipulation pages setup and usability is a moving target. A small trial and error period should be afforded for this part

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: the mls, example of array data structure, data structure in c notes, data structure in array, data structure array, array manipulation in c, array in data structure, array data structure, CHARACTER SETUP, generate reports excel, database design php mysql report, spreadsheet manipulation, php sortable, activity tracking, setup database excel, spreadsheet tracking, import data web page, mysql update checkbox, activity spreadsheet, import excel array, counties excel, mysql web spreadsheet, php excel database report, import database excel mysql, excel array

Acerca do Empregador:
( 30 comentários ) United States

ID do Projeto: #2958045

Premiar a:

coderspace2

See private message.

$187 USD em 24 dias
(10 Avaliações)
4.1

10 freelancers estão ofertando em média $448 para este trabalho

skylane

See private message.

$510 USD in 24 dias
(277 Comentários)
7.7
asselsolutionsvw

See private message.

$425 USD in 24 dias
(65 Comentários)
7.1
zeesol

See private message.

$467.5 USD in 24 dias
(22 Comentários)
5.9
mrjrm

See private message.

$127.5 USD in 24 dias
(12 Comentários)
3.7
jeffreykrvw

See private message.

$488.75 USD in 24 dias
(2 Comentários)
3.6
jlgdeveloper

See private message.

$408 USD in 24 dias
(2 Comentários)
3.1
thecloudkernel

See private message.

$1530 USD in 24 dias
(3 Comentários)
0.9
bristolsoft369

See private message.

$85 USD in 24 dias
(0 Comentários)
0.0
rabogan

See private message.

$255 USD in 24 dias
(0 Comentários)
0.0