1 Cron task for Percentage Complete Figures

Issue #788 resolved
Emil Reisser-Weston created an issue

Please set up a Cron task to record the percentage completion in a table for the following on a daily basis. Please record the table details (name ) here as Ivan will need this to display this information on the dashboard...

  • Learning Resources (percentage of all Learning Resources with a "Completed" status

  • Also record separately percentages for each type of Learning Resource e.g. Blog Entries, e-Learning etc - this is less urgent but it is likely this will be needed later.

  • Committee Positions (percentage of Committee positions with a "Accepted" status

  • Staff Status (percentage of employees with a "Completed" status

  • SM Functions (percentage of those with a status of "Accepted")

  • SM Responsibilities (percentage of those with a status of "Accepted")

  • Certification Staff Functions (percentage of those with a status of "Accepted")

Comments (7)

  1. Lauris Mikulans

    I can intercept any learning results change and do live updates.
    Same for SMCR date, will see what can be done.

  2. Lauris Mikulans

    But then again, if no one has made any updates in following day, there is no entry in stats table.
    Cron task it is.

  3. Lauris Mikulans

    Created daily_statistics cron job that will generate numbers and put them in table "daily_statistics".
    I would need to spend few hours optimizing queries for performance, in future.

    Cron job will run every night at 12:10 AM, UK time.

  4. Log in to comment