Non-core contributed modules

New Report: Comparative Reports (working title)

Details

  • Type: New Feature New Feature
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.9
  • Fix Version/s: None
  • Component/s: Admin report: Comparative
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE

Description

This is an on-going project Anthony and I have discussed over email that is moving here so it's easier for him to track and others to join in with.

This is a new report category of reports to show the following:

Year to year activity comparison
Usage by hour of the day
Most active users
Particular users' activity (over all courses)
Course disk usage

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Red Morris added a comment -

Here is an updated version to fix a debug notice, but I have noticed another when the Year vs Year report is run.

It must be to do with the sum I perform in the sql so that the months are offset to start from September, but I don't know what to replace it with. Is there a function like sql_concat for sums? I looked in dmllib.php but couldn't see anything that looked like it fit.

[05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 752
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 752
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 752
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 752
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 752
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 752
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 752
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 752
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 752
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 741
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 743
[05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 752

Show
Red Morris added a comment - Here is an updated version to fix a debug notice, but I have noticed another when the Year vs Year report is run. It must be to do with the sum I perform in the sql so that the months are offset to start from September, but I don't know what to replace it with. Is there a function like sql_concat for sums? I looked in dmllib.php but couldn't see anything that looked like it fit. [05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 752 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 752 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 752 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 752 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 752 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 7 in C:\xampplite\moodle\lib\graphlib.php on line 752 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 8 in C:\xampplite\moodle\lib\graphlib.php on line 752 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 9 in C:\xampplite\moodle\lib\graphlib.php on line 752 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 10 in C:\xampplite\moodle\lib\graphlib.php on line 752 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 741 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 743 [05-May-2009 16:10:53] PHP Notice: Undefined offset: 11 in C:\xampplite\moodle\lib\graphlib.php on line 752
Hide
Permalink
Anthony Borrow added a comment -

Hi Red - I am going to go ahead and add this code to CONTRIB and then we can work out the error with the year to year that you describe above. It's not clear to me since I do not have any stats on my test site so I cannot reproduce the error. Let me know how I can be of help. Peace - Anthony

Show
Anthony Borrow added a comment - Hi Red - I am going to go ahead and add this code to CONTRIB and then we can work out the error with the year to year that you describe above. It's not clear to me since I do not have any stats on my test site so I cannot reproduce the error. Let me know how I can be of help. Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

Actually - before uploading the code, I want to make sure I understand how the graphxx.php files work. Are these different for each version of Moodle? I did not see as I skimmed through things how this was implemented in the code. I just want to make sure they are not unnecessary files. Peace - Anthony

Show
Anthony Borrow added a comment - Actually - before uploading the code, I want to make sure I understand how the graphxx.php files work. Are these different for each version of Moodle? I did not see as I skimmed through things how this was implemented in the code. I just want to make sure they are not unnecessary files. Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

p.s. - BTW, sorry for the delay in getting back to these. I am just now at a point where I am able to play catchup with CONTRIB stuff.

Show
Anthony Borrow added a comment - p.s. - BTW, sorry for the delay in getting back to these. I am just now at a point where I am able to play catchup with CONTRIB stuff.
Hide
Permalink
Red Morris added a comment -

Hi Anthony, the graph files do differ from each other. Some are bar charts, some are line. And each one has a different SQL statement as a backup in case the one that should be passed is missing.

Show
Red Morris added a comment - Hi Anthony, the graph files do differ from each other. Some are bar charts, some are line. And each one has a different SQL statement as a backup in case the one that should be passed is missing.
Hide
Permalink
Anthony Borrow added a comment -

Red - Thanks for the verification about the graphxx.php files. I've added the code to CVS, created the component in the tracker, listed you as the component lead and set it up so that those issues are automagically assigned to you. I also added the path to your list of areas that you have write access for in CVS. Let me know if you need anything else. Keep up the great work and let me know how I can best support your efforts. Peace - Anthony

Show
Anthony Borrow added a comment - Red - Thanks for the verification about the graphxx.php files. I've added the code to CVS, created the component in the tracker, listed you as the component lead and set it up so that those issues are automagically assigned to you. I also added the path to your list of areas that you have write access for in CVS. Let me know if you need anything else. Keep up the great work and let me know how I can best support your efforts. Peace - Anthony
Hide
Permalink
Anthony Borrow added a comment -

Closing all of my resolved issues. Peace - Anthony

Show
Anthony Borrow added a comment - Closing all of my resolved issues. Peace - Anthony

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.