Build a web application

Статус: Closed
Винагорода: $900
Надіслані роботи: 4
Переможець: tuanpht

Winner

Стисле описання конкурсу

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.

Відгук роботодавця

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

wyndev, Australia.

Публічна роз'яснювальна дошка

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