Count of user log records

Reports ::: report_rawrecordscount
Maintained by One poor developer...Eloy Lafuente (stronk7)
One simple report counting the log records per user in a given course. Exportable to ods/xls/txt.
Latest release:
33 sites
5 downloads
1 fans
Current versions available: 2

Screenshots

Screenshot #0

Contributors

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

Comments RSS

Comments

  • Claudia Sánchez
    Mon, 13 May 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, 13 May 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
  • Claudia Sánchez
    Sun, 2 June 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
  • Chirag Patel
    Thu, 13 Feb 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.
  • Chirag Patel
    Tue, 18 Feb 2014, 12:57 PM
    hey eloy can you explain this query?
  • Chirag Patel
    Thu, 20 Feb 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!


  • Chirag Patel
    Fri, 21 Feb 2014, 1:52 PM
    hey eloy can you help????????????please its important!!!
  • One poor developer...
    Wed, 26 Feb 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
  • Chirag Patel
    Wed, 26 Feb 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?"
  • Stefano Andreola
    Wed, 7 Jan 2015, 6:24 PM
    Hi all,



    I would like to ask if anyone can shed a light about how to use the installed add-on.

    I am new to moodle and I don't know where to look on the platform to create the count of users logs.

    Is there a standard path where the add-ons go or it depends on the specific add-on? In this specific case how do I create the report?



    Thank you in advance for your help.



    Stefano
  • Anderson Hsu
    Tue, 28 July 2015, 9:41 AM
    Dear all,
    Is the plugin suitable for Moodle 2.8 version ? Thank you.
Please login to post comments