Build a web application

Status: Closed
Prize: $900
Entries Received: 4
Winner: tuanpht

Winner

Contest Brief

Wyndham City Council has previously developed a range of mobile apps used by internal staff to undertake a range of tasks such as building site reviews, vacant land audits and asset inspections.

Typically these mobile applications send data to an internal server, which is then used by administration staff for further processing. This project involves the development of a reporting tool for the data collected using our new Open Space Inspection app. The coding language to be used is PHP (Laravel framework preferred), HTML5, Javascript/JQUERY (Bootstrap mandatory). A database snippet will be provided in SQL Server.

The site will have two pages. Note all statistics will be easily generated using provided SQL queries/stored procedures.

Icons and logos will be provided. Design should be included for the application.

BASE REQUIREMENTS:

* PHP / MSSQL
* Bootstrap for the front end.
* Must be responsive.
* Simple and clean design preferred.
* Application should be hosted temporarily on your end and a URL should be provided for testing before acceptance.

REFER TO DOCUMENTS ATTACHED FOR FURTHER DETAILS:

Attachment Details:

Project Document Brief.pdf - This document outlines the project requirements in full detail.

Data_Specification_Document_V2.pdf - This document outlines the steps required to create the database schema and populate it with sample data.

OS_Schema_sql.txt - This file contains the T-Script for MSSQL to create the database schema.

OS_Data_260516.xls - This file contains sample data for the above schema.

OS_Schema_Assets_sql.txt - This file contains the T-Script for MSSQL to create additional tables.

OS_Assets_Groups300516.xlsx - This file contains sample data for the additional tables

CalculateOpenSpaceInspectionScore_ProcedureV2_sql.txt - This file contains the T-Script for MSSQL to create a stored procedure.

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“Great Work. We would definitely hire you again for other work. ”

wyndev, Australia.

Public Clarification Board

tarik128
- 7 years ago
Hi, it is concerning your Wyn-Log contest, by the time I have been working on it and came back you have deleted it, if you are still searching someone for the project let me know here (didn't find a better way to contact you) so I can show you a demo of what I did...
- 7 years ago
tarik128
- 7 years ago
You quickly chose the winner, though tuanpht did a good work...
- 7 years ago
surendrajop
- 7 years ago
Hi, have you viewed my entry? #5
- 7 years ago
tarik128
- 7 years ago
It seems that the daily breakdown queries #7 and #8 are wrong, should use a GROUP BY clause on Inspection date rather than a WHERE clause on an exact date?
- 7 years ago
tauqirpervez
- 7 years ago
Is using PHP mandatory? Or can the same be coded using ASP.NET and SQL Server?
- 7 years ago
surendrajop
- 7 years ago
Hi Wyndham City Council!, We went though all the documents, screenshots upload//ed by you in detail and we really liked the project details and architecture done by you. It's commendable to see public institutions embracing technology wholeheartedly. We have decided to go ahead and participate in this project; and show you some progress on your project real soon - it would be a showcase of our speed and quality of work. Kind Regards, Abhay & Surendra
- 7 years ago
View 1 more message
1. surendrajop
  - 7 years ago
  Done Pls Check :) . Let me know if you want the list of our large cleints as reference.
  - 7 years ago
2. surendrajop
  - 7 years ago
  Done Pls Check :) . Let me know if you want the list of our large cleints as reference.
  - 7 years ago
tuanpht
- 7 years ago
Hi, have you viewed my entry?
- 7 years ago
actdesigners
- 7 years ago
working on it i will upload soon.
- 7 years ago
1. Contest Holder
  - 7 years ago
  Thanks..
  - 7 years ago
tayyabshahzad143
- 7 years ago
Inbox me
- 7 years ago
tuanpht
- 7 years ago
I am working on project, but I don't see table "OS_GroupTypes" in schema and sample data. Do you forget including it?
- 7 years ago
1. Contest Holder
  - 7 years ago
  We have uploaded two additional files "OS_Schema_Assets_sql.txt" and "OS_Assets_Groups300516.xlsx" for the schema and data. Please see the updated data specification document regarding these. Thanks.
  - 7 years ago
2. tuanpht
  - 7 years ago
  Ok, thanks, database is now ok.
  - 7 years ago
tarik128
- 7 years ago
Hi, could you provide us with an SQL Server testing machine that we can access remotely?
- 7 years ago
View 3 more messages
1. Contest Holder
  - 7 years ago
  Yes.. You could modify the queries to a minimum (ex- order by , union etc) and facilitate the end result through PHP.. Just be mindful of not having any performance issues and also the final query should still run in MSSQL for production..
  - 7 years ago
2. Contest Holder
  - 7 years ago
  Also, SQL server express version is free if you'd like to give that a try.. https://www.microsoft.com/en-au/server-cloud/products/sql-server-editions/sql-server-express.aspx
  - 7 years ago
Kreaterz
- 7 years ago
Thanks for your invitation. Will look at the requirements and come back to you. Thank you!
- 7 years ago
1. Contest Holder
  - 7 years ago
  Appreciate it.. Ta..
  - 7 years ago
zekiel218
- 7 years ago
This gonna be fun, Laravel with a MSSQL database :)
- 7 years ago
1. Contest Holder
  - 7 years ago
  Framework such as Laravel / Codeigniter is preferred but not mandatory.. As long as the code is structured, even vanilla PHP will be considered..
  - 7 years ago
joaquntoraljr
- 7 years ago
Will do this once done with personal stuffs.
- 7 years ago
sharjeelimtiaz93
- 7 years ago
I am interested in this contest, however it would have been better if you posted this as a project
- 7 years ago
1. Contest Holder
  - 7 years ago
  Understandable. The contest will be awarded if and when capabilities are assured..
  - 7 years ago