Sorry but I did not quite understand what are you trying to achieve. Can you please describe me more because charts from our plugin does not have months.
The chart gets the data from the tables so if you pass the value for the chart to be string ( which you enter and it can be type by desired language) the chart will display it.
I created an wpdatatable with a mysql query and I'm doing the wpdatachart in relation to this wpdatatable. I managed to put in order but the months are in English while I want them in French
My query :
SELECT DATE_FORMAT(cp_inscriptions.date,'%M') AS dateMonth, SUM(cp_inscriptions.nbparticipants) AS NBParticpants FROM cp_inscriptions GROUP by Month(cp_inscriptions.date) ORDER BY Month(cp_inscriptions.date)
The setlocale will not work because the data from that MYSQL is in English.
If you make a query from and change the data in it to be French then the table and the chart will be displayed in French. The charts does not have any methods or codes related to translation just showing the data which they get in your case from Mysql query table.
You can take a look at our documentation section for the developers where you can see all of the available filters or hooks in case you need to customize the data.
Hi,
How to translate months for charts and in order ?
For any type of chart
Thanks
Hi Maximus6978,
Thank you for your purchase.
Sorry but I did not quite understand what are you trying to achieve. Can you please describe me more because charts from our plugin does not have months.
The chart gets the data from the tables so if you pass the value for the chart to be string ( which you enter and it can be type by desired language) the chart will display it.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi,
I created an wpdatatable with a mysql query and I'm doing the wpdatachart in relation to this wpdatatable. I managed to put in order but the months are in English while I want them in French
My query :
SELECT DATE_FORMAT(cp_inscriptions.date,'%M') AS dateMonth,
SUM(cp_inscriptions.nbparticipants) AS NBParticpants
FROM cp_inscriptions
GROUP by Month(cp_inscriptions.date)
ORDER BY Month(cp_inscriptions.date)
I try :
setlocale(LC_ALL, 'fr_FR', 'french', 'fr', 'fr_FR.ISO8859-1');
But don't work
Hi Maximus6978,
The setlocale will not work because the data from that MYSQL is in English.
If you make a query from and change the data in it to be French then the table and the chart will be displayed in French.
The charts does not have any methods or codes related to translation just showing the data which they get in your case from Mysql query table.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi,
Ok How can I modify the information sent to the graphics, a filter between the database and the html rendering ?
Hi Maximus6978
You can take a look at our documentation section for the developers where you can see all of the available filters or hooks in case you need to customize the data.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables