Select Moodle version:

Reports: Count of user log records

report_rawrecordscount
One simple report counting the log records per user in a given course. Exportable to ods/xls/txt.
Maintained by: One poor developer... Eloy Lafuente (stronk7)
for Moodle
2.3, 2.4, 2.5, 2.6

Screenshots

screenshot

Contributors

One poor developer...
Eloy Lafuente (stronk7) (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Picture of Claudia Sánchez
    Mon, May 13, 2013, 12:05 AM
    NECESITO AYUDA URGENTE, ESTE MODULO DICE QUE SIRVE PARA MOODLE 2.3 PERO ME DA ERROR, ME DICE QUE EL MODULO ESTA DESACTUALIZADO O TIENE ERRORES..GRACIAS POR CUALQUIER AYUDA POSIBLE
  • One poor developer...
    Mon, May 13, 2013, 3:03 AM
    Hi Claudia, I've been quick-testing the report both under Moodle 2.3.x and 2.5 and it seems to be working ok. I've upload a renewed version fixing a strict-standards warning. Not sure if that is your problem.

    Please use English in the comments, it helps everybody to understand them.

    Ciao smile
  • Picture of Claudia Sánchez
    Sun, Jun 2, 2013, 6:26 AM
    HI AGAIN, I HAVE BEEN TRAING TO USE THE MODULE THAN YOU UPLOAD BUT GIVE THE SAME ERROR, IF YOU HAVE A WAY FOR I CONTACT TO YOU, EMAIL OR SOMETHING, PLEASE WRITE ME BACK FOR SEND YOU A SCREENSHOOT OF THE ERROR...BYE
  • Picture of Chirag Patel
    Thu, Feb 13, 2014, 2:10 PM
    hey eloy can you explain that query in your plugin code in index.php file?
    "SELECT $ufields , count(l.id) as count
    FROM {user} u
    JOIN ($esql) je ON je.id = u.id
    LEFT JOIN {log} l on l.userid = u.id AND l.course = :course
    WHERE u.id $msql
    GROUP BY " . user_picture::fields('u') . "
    ORDER BY u.lastname, u.firstname"
    and i am novice to moodle so please keep that in mind.
  • Picture of Chirag Patel
    Tue, Feb 18, 2014, 12:57 PM
    hey eloy can you explain this query?
  • Picture of Chirag Patel
    Thu, Feb 20, 2014, 9:26 PM
    hey guys I am getting database query like this



    // Get the list of all users having moodle/course:manageactivities capability

    // in order to take out them later from the report (to try to get "students" only).

    if



    ($havemanage = get_users_by_capability($context, 'moodle/course:manageactivities', 'u.id') ){



    $havemanage = array_keys($havemanage);

    }



    now i want to see what is inside havemanage,then How i can do that?

    How can i print contents of havemanage on my moodle page,

    This line is from report plugin rawrecordscount!


  • Picture of Chirag Patel
    Fri, Feb 21, 2014, 1:52 PM
    hey eloy can you help????????????please its important!!!
  • One poor developer...
    Wed, Feb 26, 2014, 7:55 AM
    Hi Chirag,

    sorry for the delay, I just saw today that there were a bunch of messages from you here.

    First of all let me point you to the main course "Moodle in English" where there are sections to ask and discuss about development and other matters. I'd suggest you to ask there when you get "blocked" at any time when playing with Moodle code.

    Said that... about your questions... that query is really not complex. It's a simple join getting information from the users table (name, email, picture...) for all the enrolled users in a course not being managers. So it will provide the list of "students" (more or less), independently of how the roles are named/configured in the site.

    And then, for every user in that list, it simply returns the number of records in the log table. And that's exactly what the report does: To return the list of "students" in a course with their number of logs (actions performed in the course).

    About how to view the contents of any variable... you can use any IDE (Netbeans...) able to set break points and debug... or alternatively... use/add print_r() or print_object() manual calls in the code to see the contents of any variable at any point.

    Hope it helps... again, sorry for the delay... ciao smile
  • Picture of Chirag Patel
    Wed, Feb 26, 2014, 12:59 PM
    I am new to moodle so I am not used to with this queries,but there is another question "Why yuo are using groups in this report?"
Please login to post comments