Build a web application

Stanje: Closed
Nagrade: $900
Prejetih vnosov: 4
Zmagovalec/ka: tuanpht

Winner

Navodila natečaja

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.

Priporočene spretnosti

Winner

Objavi podoben natečaj

Delodajalčev feedback

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

wyndev, Australia.

Javna tabla za pojasnila

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