Skip to content

pipiscrew/mysql-records-to-google-chart

Repository files navigation

mysql-records-to-google-chart

We need to illustrate the progress, right ?

First set the needed parameters

alt text

then draw it with - Google Charts

alt text

-- the linear chart --

alt text

on the last tab you can see the actual records by database with the help of wenzhixin


alt text

all are structured and commented. Optimization is not done.



The sample made with this table :

CREATE TABLE `jobs` (
  `rec_id` int(11) NOT NULL AUTO_INCREMENT,
  `USER_NAME` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DATE_CREATED` datetime DEFAULT NULL,
  `COUNTRY` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `QUEUE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DELIVERED` smallint(10) DEFAULT NULL,
  PRIMARY KEY (`rec_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



##This project uses the following 3rd-party dependencies :
-Bootstrap
-bootstrap-selector
-Datepicker for Bootstrap
-bootstrap-table
-YaLinqo
-Google Charts


##This project is no longer maintained
Copyright (c) 2017 PipisCrew

Licensed under the MIT license.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages