| 1 |
=== SQL Chart Builder === |
| 2 |
Contributors: elvinhaci |
| 3 |
Tags: charts,mysql,sql,visualizer,graphs,sql reports,dynamic chart |
| 4 |
Requires at least: 5.0.0 |
| 5 |
Tested up to: 6.0.2 |
| 6 |
Stable tag: 2.3.4 |
| 7 |
Donate link: https://guaven.com/service/small-thankyou-premium-support-service/ |
| 8 |
License: GPLv2 or later |
| 9 |
License URI: http://www.gnu.org/licenses/gpl-2.0.html |
| 10 |
|
| 11 |
Turn Your SQL Queries to Beautiful Dynamic Charts- Pie, Line, Area, Donut, Bar Charts with date/input filters. |
| 12 |
|
| 13 |
== Description == |
| 14 |
The plugin can create beautiful charts based on your SQL queries, then you can use those charts in any part of your website. |
| 15 |
You can use both native wp and non-wp mysql tables in your queries. |
| 16 |
|
| 17 |
### Pie chart, Donut chart, Line chart, Bar chart, Column chart, Area chart |
| 18 |
|
| 19 |
= How to use = |
| 20 |
|
| 21 |
1. Give any name to your report. |
| 22 |
|
| 23 |
2. Use our preinstalled chart or create new one yourself: choose desired chart type, type sql query, |
| 24 |
enter field names, labels and then press to Publish/Update |
| 25 |
|
| 26 |
3. You can use multiple SQL queries too. Just split them by ; sign. You can also add shortcode argument to SQL query. For example if you |
| 27 |
type "select * from wp_posts where ID>{arg1}" then it you can pass arg1 value to the query with [gvn_schart_2 id="2" arg1="11"] shortcode. |
| 28 |
|
| 29 |
4. After update/save you will see needed shortcode below there. You can use that shortcode anywhere in your website: in pages, posts, widgets etc. |
| 30 |
|
| 31 |
5. Just check "Show table-view data below the graph" in order to get table-list view below each chart. |
| 32 |
|
| 33 |
6. Using "Dynamic Filters" you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart. |
| 34 |
|
| 35 |
= Dynamic filters = |
| 36 |
|
| 37 |
Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc. |
| 38 |
|
| 39 |
* variable_name - any single name you want. |
| 40 |
* default_value - default value when no any variable chosen by a user |
| 41 |
* variable_label - Label which would be visible at a form above the chart |
| 42 |
* variable_type - number, text or date |
| 43 |
* ~ is a separator between variable elements. |
| 44 |
* | is a separator between variables |
| 45 |
|
| 46 |
For example if to put |
| 47 |
|
| 48 |
limit_tag~10~Count~number | post_date_tag~2010-07-05 17:25:18~Date Published~date, |
| 49 |
|
| 50 |
then you can use this SQL code |
| 51 |
|
| 52 |
select * from wp_posts where post_date<{post_date_tag} limit {limit_tag} |
| 53 |
|
| 54 |
in SQL CODE field. |
| 55 |
{post_date_tag} and {limit_tag} would be replaced with dynamic variables. |
| 56 |
|
| 57 |
So, the plugin will automatically recognize it and put corresponding selectboxes above the chart. |
| 58 |
|
| 59 |
|
| 60 |
= Website = |
| 61 |
[https://guaven.com/my-sql-charts/](https://guaven.com/my-sql-charts/) |
| 62 |
|
| 63 |
= Documentation = |
| 64 |
[https://guaven.com/my-sql-charts/#docs](https://guaven.com/my-sql-charts/#docs) |
| 65 |
|
| 66 |
= Bug Submission and Forum Support = |
| 67 |
[Contact Page](https://guaven.com/contact/solution-request/) |
| 68 |
|
| 69 |
= Please Vote if you liked our plugin = |
| 70 |
Your votes really helps us. Thanks. |
| 71 |
|
| 72 |
|
| 73 |
== Installation == |
| 74 |
|
| 75 |
1. Upload 'guaven_sqlcharts.zip' to the '/wp-content/plugins/' directory |
| 76 |
2. Unzip it. |
| 77 |
3. Go to Dashboard/Plugins and Activate the plugin. |
| 78 |
4. Go to “Dashboard/My SQL Charts” to create new charts. You will also see howtouse guide texts there. |
| 79 |
|
| 80 |
|
| 81 |
|
| 82 |
== Frequently Asked Questions == |
| 83 |
|
| 84 |
|
| 85 |
== Screenshots == |
| 86 |
|
| 87 |
1. Screenshot 1 |
| 88 |
|
| 89 |
2. Screenshot 2 |
| 90 |
|
| 91 |
3. Screenshot 3 |
| 92 |
|
| 93 |
4. Screenshot 4 |
| 94 |
|
| 95 |
5. Screenshot 5 |
| 96 |
|
| 97 |
|
| 98 |
== Changelog == |
| 99 |
= 2.3.4= |
| 100 |
|
| 101 |
* Backend improvements on existing features |
| 102 |
= 2.3.3= |
| 103 |
|
| 104 |
* Fixed: PHP warning issue |
| 105 |
|
| 106 |
= 2.3.2= |
| 107 |
|
| 108 |
* Added: Enable/disable Stackedness of bar charts |
| 109 |
|
| 110 |
= 2.3.1= |
| 111 |
|
| 112 |
* Added: Enable/disable Legend section in Charts |
| 113 |
|
| 114 |
= 2.3.0= |
| 115 |
|
| 116 |
* Added: One new chart - Polar Area |
| 117 |
|
| 118 |
* Added: New small feature - Round Y Axis tick values |
| 119 |
|
| 120 |
* Improvement: Hashing DB Remote password |
| 121 |
|
| 122 |
= 2.2.2= |
| 123 |
|
| 124 |
* Added: Custom color support for PIE charts |
| 125 |
|
| 126 |
* Added: Insert custom chart parameters via Shortcode attributes |
| 127 |
|
| 128 |
= 2.2.1= |
| 129 |
|
| 130 |
* Small improvements |
| 131 |
|
| 132 |
= 2.2.0= |
| 133 |
|
| 134 |
* Added width-height support |
| 135 |
|
| 136 |
* Added "Zero point" to line chart |
| 137 |
|
| 138 |
* Bugfixes |
| 139 |
|
| 140 |
= 2.1.2= |
| 141 |
|
| 142 |
* New feature: Remote Database Connection |
| 143 |
|
| 144 |
* Setting custom & fixed colors for charts |
| 145 |
|
| 146 |
* Small improvement in table-view component |
| 147 |
|
| 148 |
= 2.1.1= |
| 149 |
|
| 150 |
* Fixed small bug in Area Charts |
| 151 |
|
| 152 |
* Chart library has been updated to the latest version |
| 153 |
|
| 154 |
= 2.1.0= |
| 155 |
|
| 156 |
* Dynamic filters added: You can use dynamic date/number/text filters at frontend. |
| 157 |
|
| 158 |
* Table-view support added. |
| 159 |
|
| 160 |
= 2.0.4= |
| 161 |
|
| 162 |
Now you can add custom arguments to the SQL query. |
| 163 |
|
| 164 |
= 2.0.0= |
| 165 |
|
| 166 |
* New non-Google Local Charts added. |
| 167 |
|
| 168 |
* Use multiple mysql queries in one graph. |
| 169 |
|
| 170 |
= 1.0.0= |
| 171 |
|
| 172 |
* Uploaded to Wordpress.org |
| 173 |
|
| 174 |
= 1.0.2= |
| 175 |
|
| 176 |
* Little fixes |
| 177 |
|
| 178 |
= 1.0.5= |
| 179 |
|
| 180 |
* Added WP 4.7 compatibility |
| 181 |
|
| 182 |
* Fixed "multiple charts in one page" issue. |
| 183 |
|
