Build a web application

  • Status: Closed
  • Hadiah: $900
  • Penyertaan Diterima: 4
  • Pemenang: tuanpht

Ringkasan Peraduan

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.

Kemahiran Disyorkan

Maklum Balas Majikan

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

Gambar Profil wyndev, Australia.

Papan Penjelasan Umum

  • tarik128
    tarik128
    • 6 tahun yang lalu

    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...

    • 6 tahun yang lalu
  • tarik128
    tarik128
    • 6 tahun yang lalu

    You quickly chose the winner, though tuanpht did a good work...

    • 6 tahun yang lalu
  • surendrajop
    surendrajop
    • 6 tahun yang lalu

    Hi, have you viewed my entry? #5

    • 6 tahun yang lalu
  • tarik128
    tarik128
    • 6 tahun yang lalu

    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?

    • 6 tahun yang lalu
  • tauqirpervez
    tauqirpervez
    • 6 tahun yang lalu

    Is using PHP mandatory? Or can the same be coded using ASP.NET and SQL Server?

    • 6 tahun yang lalu
  • surendrajop
    surendrajop
    • 7 tahun yang lalu

    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 tahun yang lalu
    1. surendrajop
      surendrajop
      • 6 tahun yang lalu

      Done Pls Check :) . Let me know if you want the list of our large cleints as reference.

      • 6 tahun yang lalu
    2. surendrajop
      surendrajop
      • 6 tahun yang lalu

      Done Pls Check :) . Let me know if you want the list of our large cleints as reference.

      • 6 tahun yang lalu
  • tuanpht
    tuanpht
    • 6 tahun yang lalu

    Hi, have you viewed my entry?

    • 6 tahun yang lalu
  • actdesigners
    actdesigners
    • 7 tahun yang lalu

    working on it i will upload soon.

    • 7 tahun yang lalu
    1. wyndev
      Penganjur Peraduan
      • 6 tahun yang lalu

      Thanks..

      • 6 tahun yang lalu
  • tayyabshahzad143
    tayyabshahzad143
    • 7 tahun yang lalu

    Inbox me

    • 7 tahun yang lalu
  • tuanpht
    tuanpht
    • 7 tahun yang lalu

    I am working on project, but I don't see table "OS_GroupTypes" in schema and sample data. Do you forget including it?

    • 7 tahun yang lalu
    1. wyndev
      Penganjur Peraduan
      • 7 tahun yang lalu

      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 tahun yang lalu
    2. tuanpht
      tuanpht
      • 7 tahun yang lalu

      Ok, thanks, database is now ok.

      • 7 tahun yang lalu
  • tarik128
    tarik128
    • 7 tahun yang lalu

    Hi, could you provide us with an SQL Server testing machine that we can access remotely?

    • 7 tahun yang lalu
    1. wyndev
      Penganjur Peraduan
      • 7 tahun yang lalu

      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 tahun yang lalu
    2. wyndev
      Penganjur Peraduan
      • 7 tahun yang lalu

      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 tahun yang lalu
  • Kreaterz
    Kreaterz
    • 7 tahun yang lalu

    Thanks for your invitation. Will look at the requirements and come back to you. Thank you!

    • 7 tahun yang lalu
    1. wyndev
      Penganjur Peraduan
      • 7 tahun yang lalu

      Appreciate it.. Ta..

      • 7 tahun yang lalu
  • zekiel218
    zekiel218
    • 7 tahun yang lalu

    This gonna be fun, Laravel with a MSSQL database :)

    • 7 tahun yang lalu
    1. wyndev
      Penganjur Peraduan
      • 7 tahun yang lalu

      Framework such as Laravel / Codeigniter is preferred but not mandatory.. As long as the code is structured, even vanilla PHP will be considered..

      • 7 tahun yang lalu
  • joaquntoraljr
    joaquntoraljr
    • 7 tahun yang lalu

    Will do this once done with personal stuffs.

    • 7 tahun yang lalu
  • sharjeelimtiaz93
    sharjeelimtiaz93
    • 7 tahun yang lalu

    I am interested in this contest, however it would have been better if you posted this as a project

    • 7 tahun yang lalu
    1. wyndev
      Penganjur Peraduan
      • 7 tahun yang lalu

      Understandable. The contest will be awarded if and when capabilities are assured..

      • 7 tahun yang lalu

Tunjukkan lebih banyak komen

Bagaimana untuk mulakan dengan peraduan

  • Siarkan peraduan anda

    Siarkan Peraduan Anda Cepat dan mudah

  • Dapatkan berjuta penyertaan

    Dapatkan Bertan-tan Penyertaan Dari serata dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail - Mudah!

Siarkan Peraduan Sekarang atau Sertai kami Hari Ini!