I have a postgresql database and a static website. I want to display some information from the database on html page. I want you to write my sql queries to export the data to csv and I want you to make a simple html page with Google charts that loads the data from csv.
The details are below:
The pages are about domain statistics. There is a domain table. The fields that are related with the project are as follows:
- createdate
- zone (the extension of the domain, namely, .mobi, .com, .fr etc.. The number of zones are dynamic and hold in Zone table)
There will be three pages.
1) Daily statistics:
This page will contain a bar graph and a date control. The graph should dynamically show the graph of the date which is selected. There are also back and forward buttons which should bring you the graph of the previous day or the next day accordingly. You can see a sample screenshot on [login to view URL]
2) Monthly Statistics
It is similar to daily statistics. The only difference is the date combo. You can see a sample screenshot on [login to view URL]
3) yearly statistics
You can see a sample screenshot on yearly.png. In addition to this screenshot there should be a year selection combo box. The graph can be bar graph as well.
Deliverables:
I want you to deliver 3 sqls and 3 html files. The sql should generate csv files and html should read from that csv and generate the graph. It is a very trivial task for someone who has done it before, so the bugdet is low for that.
Hello, i can help you with this. I have work with google charts before and its not so hard, take a look at my feedbacks and let me know if you are interested
It can be better, if page will recieve data not from csv file, that updates in certain shedule, but dinamically from php script, that contains sql queries.
Thu, 26 Mar 2015 22:17:57 +0530
Web software?
Operating system?
Schema?
sample tables output?
Data input for csv files changes to show in html?
HTML source for existing pages if any?
Hello, I am an expert PostgreSQL programmer. I can complete your task quickly and correctly.
In order to do so, I will need you to either provide me either 1) a representative sample of your data table(s) that I can load into into my pgsql server, or 2) access to your database.
I would prefer method #1