We've just upgraded our back office software to a new version. We had several reports generated and presented through end customer web services on our website that need to be rebuilt.
Specific queries involving the retrieval of archived information of end users transactions from our DHW need to be reconstructed.
Looking for someone that is an expert in developing DB queries et al; and can achieve this very quickly.
See below data tables required to be used. More details will be provided once job is assign.
Job specific instruction will be provided by our head programmer.
Here is detailed job description provided by our developer:
We have a PHP/MySQL system that needs to connect to a reports server and obtain data for reports. You need to have appropriate design and code for:
a) connectivity and authentication of the client with server
b) getting report data (all reports supported by the server) in a standard format
c) displaying this report data in a formatted XML document.
Sample code in C# is given - GetAllLoadings for example, would be a report in our client.
Note that some reports will be parameterized.
The PHP team will provide access to current pages for display formatting. Currently data from another server is being used for these reports, so it is expected that these PHP pages can continued to be used for displaying reports with minor modifications, as advised by you. You will need to work independently on this task, but shall have access to both the application developers (for PHP based UI development) and the server team (for access management, data structure related questions).
You will also ensure data accuracy and privacy in reports - users should see only data they are authorized to.
[also attach samplecode.pdf for reference ]
Skill sets: Web Services, XML, SQL, basic understanding of .net and PHP frameworks
PS: have removed the cron job alert, as it is no longer useful. We should have a cron summary (the new server does not send on its own - we need to program) report from tomorrow night onwards.