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/


View All View Non Threaded Newest first
  • 10-10-2006 20:55:20 GMT +2 Rob Foster

    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.

    • 10-13-2006 11:03:01 GMT +2 Ionut MOICIANU

      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
MX Dynamic Charts 1.1.0
© Adobe Systems Romania. All rights reserved.