Closed

php FRONT END for XML data stored in mysql database

This project was awarded to mrteecee for $1500 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$1500 - $3000 USD
Total Bids
45
Project Description

I am looking for someone who is able to extract DATA from XML files stored in mySQL database.

XML files
the source of the XML offers more than 1 XML type of file. We are interested only in Vypis_OR, you can see an example here [url removed, login to view]
full specification should be available here [url removed, login to view] (again, Vypis_OR is the one i am using)
These XML files hold data about Legal Entities in Czech Republic (companies, people owning them, HQ addresses and so on)

DATABASE
i have [url removed, login to view] XML files stored in mySQL db. You will get sample data.

PARSING
i need to extract information about legal entities and generate webpages for every record = 1 XML should create 1 HTML page
full info is the following :
1/ name of the company
2/ address
3/ type of the company (LTD/SE/...other types)
4/date of registration
5/representatives (position, their name, address, DoB, active from, to)
6/owners/shareholders (same as 5 + their share)
7/ type of business activity
8/ some optional text information

XML files contain data including changes made during the existence of the company. therefore the webpages should also show these changes, where available (example: first owner of the company sold 20% to new coowner 3 years ago.., since then, the company has 2 owners 20/80..and so on

WEBPAGES
there are 3 types of webpages
1/ company profile - showing data from XML
2/ people profile - showing all information about 1 person = what that person controls, owns, where it lives
3/ address profile - who is using this address (more than 1 person or company? how they are connected?)
4/ search page, where you can serach by companyID (xtored in DB or/and XML file) or companyName or personName
all these pages should be connected, so when showing lets say a company XXX, and 1 man is owner of that company, next to him is a link saying something like THIS GUY IS IN 4 OTHER COMPANIES << when you click it, you see type 2 page, and you see info about this guy
address got the same THERE ARE 7 OTHER COMPANIES at this address << you click it, you see other companies, better gmap or something

all the data should be presented with appropriate graphical effects, .. pie chart for shares%/people, gmaps (or other) for addresses, jquery/ajax for usability

+ a few more small requests
* i will be available to answer any your questions regarding this project and the source of the data

every part of the produced code should be well documented in english

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online