MX Dynamic Charts Forum :: MX Charts Calendar Integration
This thread was displayed: 279 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
Rob Foster
10-10-2006 20:55:20 GMT +2
|
Hello,
I was wondering if it would be possible to integrate MX Charts and MX Calendar in the following way:
I would like a chart which has the days of the month as its label (for example the numbers 1 - 31 along the bottom of a bar chart and showing a per month view) and for the chart values to be the total hours worth of calendar entries for that day. That way, somebody could quickly look at a graph to see how full their monthly schedule was and quickly identify which days have the most amount of time available or booked.
I am using the PHP server model with a MySQL database.
I look forward to your response.
Kind Regards,
Rob Foster.
|
|
|
Ionut MOICIANU
10-13-2006 11:03:01 GMT +2
|
Hi Rob,
If your events start and end in the same day (don't spread across multiple days), a chart displaying days->scheduled hours could be obtained for a certain year and month (that are passed by URL) from a Recordset sql like:
SELECT DISTINCT day(datestart_eve) AS day, SUM(TIME_TO_SEC(TIMEDIFF(dateend_eve, datestart_eve))/60) AS hours
FROM event_eve
WHERE year(datestart_eve) = param1 AND month(datestart_eve) = param2
GROUP BY day
where param1, param2 are defined as numeric parameters taking the values from GET
(year number and month number)
I hope this helps.
Regards,
Ionut
|
|
|
