Solar energy dashboard, php graphs

Status: Closed
Hadiah: $240
Penyertaan Diterima: 5
Pemenang: VictorDuran

Winner

Ringkasan Peraduan

We have a solar thermal field to monitor and intend to build a number of ”widgets” to display different features. The entry should be an examples of such dashboard. A dataset from the MySQL database and and example PDF has been attached.

The “widgets” should display the data as a bar chart, a line chart and as text/number.

The system will in the end display a number of different boxes with different information. This competition is to get a first idea of the look and feel of the components.

The “widget” should have an upper frame with the name of the widget and a mark to collapse it into a single line. The “widget” should be possible to invoke on a website with a php function. No need to have any interface to arrange them or configure them, the set will be configured directly in php-code.

I think the demo should have one part of the php-program with the main ccs-file and a design for the full screen (e.g. the gray background with a black thin frame) and then one or several functions that is called to put the three different widget on that screen.

Graphic layouts that we have found appealing is ”The Panic Status Board” and ”Geckoboard”. The trick seems to have shadings on the right places... Please make a google image search and look at those designs!

Attached files:
graphical idea in the attached pdf-file that we have created as an example dashboard
example data attached as Mysql query export file dashboard.sql

PDF file
The five pages illustrate first the empty dashboard, then when the bar chart is enabled, then also the line chart and text boxes are enabled. Then with all three boxes activated and finally when the “widgets” has been collapsed by clicking on the symbol to the right to the name of the box.

SQL-file (saved with the extention .txt to allow Freelacer to accept it, change the extention to .sql after daownloading it)
Use the text file dashboard.sql.zip to create a database and use the example data in the database in the contest:
Bar chart: display the five different temperatures in the table log from channel_id = 1
Line chart: display the five different temperatures in the table log from channel_id = 2
Text box: display the last 2 entries in the table status and the last temperature measured from table log, channel_id = 2

Good luck!

Kemahiran Disyorkan

Winner

Siarkan Peraduan Seperti Ini

Maklum Balas Majikan

“VictorDuran was one of three more or less equal contestants (out of 18) who solved the task, but his technical solution was the best, scalable and easy to implement.”

bystrom, Sweden.

Papan Penjelasan Umum

Penganjur Peraduan
- 11 tahun yang lalu
Thank you all contestants! Sorry for some slow feedback. I'm impressed by the effort all have shown in this contest and the top three have all solved the task entirely according to the instructions (installing the sql database, implementing all requested features and diagrams) in a very good way. I have selected a Venezuelan winner, but special thanks to CBabbage and Wade Gilchrist for good communication. I think that a personal touch to the presentations and the communication is a big plus. Good luck everybody in your continuous work!
- 11 tahun yang lalu
1. SmartChoice Solutions
  - 11 tahun yang lalu
  bystrom, thank you very much for your rating on my entries. I really enjoyed participating in this contest, it was a fun project. Best wishes.
  - 11 tahun yang lalu
Penganjur Peraduan
- 11 tahun yang lalu
Sorry contestants for some slow feedback! I'll get back with the final result after the weekend!
- 11 tahun yang lalu
1. SmartChoice Solutions
  - 11 tahun yang lalu
  thank you
  - 11 tahun yang lalu
simplicitysoft
- 11 tahun yang lalu
@bystrom: can you please check #11 and give me feedback?
Thanks
- 11 tahun yang lalu
Penganjur Peraduan
- 11 tahun yang lalu
It will stay up at least 24 hours more. However, I have a great respect for peoples time and effort, and it feels bad to have many good entries and only being able to work together with one. This competition tool is a powerful way to choose freelancer, but I feel it can easily be misused.
- 11 tahun yang lalu
SmartChoice Solutions
- 11 tahun yang lalu
bystrom can you give me a bit of time to submit my solution ?
- 11 tahun yang lalu
yogeshsharma89
- 11 tahun yang lalu
Would you please wait for some hours ? I'll make some good changes in the design and will show you. Hope you like that.
- 11 tahun yang lalu
Penganjur Peraduan
- 11 tahun yang lalu
#7 has done everything right, only missing the final graphic touch. I like the look of e.g. Panic Status Board or Geckoboard
- 11 tahun yang lalu
Penganjur Peraduan
- 11 tahun yang lalu
Yes, temperature in Celsius
- 11 tahun yang lalu
SmartChoice Solutions
- 11 tahun yang lalu
any chance you can upload a rough mockup of your data would look on the graph, just a hand sketch would do
- 11 tahun yang lalu
1. Penganjur Peraduan
  - 11 tahun yang lalu
  There are two file enclosed in the contest, a pdf and the data as an sql (but named as txt). What is it that you don't find in those files?
  - 11 tahun yang lalu
2. SmartChoice Solutions
  - 11 tahun yang lalu
  bystrom i am not sure what you want for the axis of the bar and line graph, is it Y temp vs X time in min ? that was what i was trying to figure out
  - 11 tahun yang lalu
yogeshsharma89
- 11 tahun yang lalu
thanks for rating. Any feedback over entry #3 ?
- 11 tahun yang lalu
yogeshsharma89
- 11 tahun yang lalu
Please check entry #3 and open the working link for the early demo. Please let me know your feedback so we can go ahead with this. Thanks.
- 11 tahun yang lalu