If you have some better layout/design ideas, I would be very happy to hear them.
Need two pages created on existing development site:
• Search Results
All function and layout as specified in attached documents.
• Page layout most efficiently and user friendly.
• 6 buttons in on top right to invoke popup with various results.
• Alert when data entered and user leaving page before saving/updating ETA, Tech, State, and New Notes.
• Update WorkOrder Button will save ETA, Tech, State, and New Notes IF NOT NULL.
• Dropdown boxes for Tech and State must be searchable and scrollable
• ETA calendar must validate date, only provide dates >= today. Allow time to be selected as well in increments of 30 minutes. Function must be quick and easy to use.
• Tech Notes are text boxes that are saved separately from ‘Update WorkOrder’.
• Ability to download saved files from Microsoft SQL Server Database/Table as provided in [login to view URL] (freelancer to create table on their MsSQL server with data provided in CSV and test functionality)
• Ability to upload files via drag/drop or browse button to MsSQL server keeping method as existing files in VPAttachment.csv. This is a must because these binary files are also read by our accounting software
• Notes: Display six lines of data. If more than 6 lines display ‘more…’ and allow popup with scroll bar to read all notes available.
• Search magnifying glass should slide open to allow user to enter search criteria
• Create 4 temp tables with temp data in Mysql on the dev server
• Search from WorkOrder page and results should query 4 tables and display results 4 separate instances on one page. Each instance should be paginated and limited to 5 entries by default.
There is an existing MySQL DB on the server you can use to test search, notes, and other functions of the pages.
IMPORTANT NOTE: Upload, Download, and View document must be designed and test on a Microsoft SQL Server | Database | Table, provided by freelancer, using sample data provided in VPAttachment.csv. This data was dumped from our current production accounting SQL server and all Uploaded documents must maintain the same method used in sample documents so they are retrievable in our accounting software.
I will provide access to dev site to complete the project to the awarded freelancer. I will require freelancers .pub key for ssh access.
Carefully read scope and ask questions before accepting project.