Build a web application

Estado: Closed
Premio: $900
Propuestas recibidas: 4
Ganador: tuanpht

Winner

Resumen del concurso

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.

Habilidades recomendadas

Winner

Publica un concurso similar

Comentarios del empleador

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

wyndev, Australia.

Tablero de aclaración pública

tarik128
- 7 años atrás
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 años atrás
tarik128
- 7 años atrás
You quickly chose the winner, though tuanpht did a good work...
- 7 años atrás
surendrajop
- 7 años atrás
Hi, have you viewed my entry? #5
- 7 años atrás
tarik128
- 7 años atrás
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 años atrás
tauqirpervez
- 7 años atrás
Is using PHP mandatory? Or can the same be coded using ASP.NET and SQL Server?
- 7 años atrás
surendrajop
- 7 años atrás
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 años atrás
Ver 1 mensaje mas
1. surendrajop
  - 7 años atrás
  Done Pls Check :) . Let me know if you want the list of our large cleints as reference.
  - 7 años atrás
2. surendrajop
  - 7 años atrás
  Done Pls Check :) . Let me know if you want the list of our large cleints as reference.
  - 7 años atrás
tuanpht
- 7 años atrás
Hi, have you viewed my entry?
- 7 años atrás
actdesigners
- 7 años atrás
working on it i will upload soon.
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Thanks..
  - 7 años atrás
tayyabshahzad143
- 7 años atrás
Inbox me
- 7 años atrás
tuanpht
- 7 años atrás
I am working on project, but I don't see table "OS_GroupTypes" in schema and sample data. Do you forget including it?
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  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 años atrás
2. tuanpht
  - 7 años atrás
  Ok, thanks, database is now ok.
  - 7 años atrás
tarik128
- 7 años atrás
Hi, could you provide us with an SQL Server testing machine that we can access remotely?
- 7 años atrás
Ver 3 mensajes más
1. Organizador del concurso
  - 7 años atrás
  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 años atrás
2. Organizador del concurso
  - 7 años atrás
  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 años atrás
Kreaterz
- 7 años atrás
Thanks for your invitation. Will look at the requirements and come back to you. Thank you!
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Appreciate it.. Ta..
  - 7 años atrás
zekiel218
- 7 años atrás
This gonna be fun, Laravel with a MSSQL database :)
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Framework such as Laravel / Codeigniter is preferred but not mandatory.. As long as the code is structured, even vanilla PHP will be considered..
  - 7 años atrás
joaquntoraljr
- 7 años atrás
Will do this once done with personal stuffs.
- 7 años atrás
sharjeelimtiaz93
- 7 años atrás
I am interested in this contest, however it would have been better if you posted this as a project
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Understandable. The contest will be awarded if and when capabilities are assured..
  - 7 años atrás