Gradebook

I think I'm close, however, my SQL and/or PHP skills are letting me down. Maybe one of you guys has more ability in this area. BTW I will refer to some files, so you should know that I am using Moodle 1.9.2 (in case the path names differ)

Cyril, I originally wanted exactly what you have in your diagram. After a little research I settled for the following.

1. I don't create a new column (when I got into the php files I realised that would be very difficult). Instead I simply display my custom field next to the student name.

2. I decided that a sort on Firstname is not really useful/needed, so I intend to replace this with a sort on my custom field. Again this way I don't really add any code or mess with the table too much. I simply tweak what is already there.

To achieve the first part I did the following. In the file grade/report/grader/lib.php I edited some code:

BEGIN CODE

$user_pic = '<div class="userpic">' . print_user_picture($user, $this->courseid, NULL, 0, true) . '</div>';

}

//change 1

//displays grouID next to name in Gradebook

$groupID = "SELECT data FROM mdl_user_info_data WHERE userid='$user->id'";

$groupIDget = mysql_query($groupID);

$groupIDshow = mysql_fetch_object($groupIDget);

//End change 1 (except for <span></span> a few lines below to show $groupIDshow in table

$studentshtml .= '<tr class="r'.$this->rowcount++ . $row_classes[$this->rowcount % 2] . '">'

.'<th class="header c'.$columncount++.' user" scope="row" onclick="set_row(this.parentNode.rowIndex);">'.$user_pic

.'<a href="'.$CFG->wwwroot.'/user/view.php?id='.$user->id.'&amp;course='.$this->course->id.'">'

.fullname($user).'</a><span style="font-size:smaller;margin-left:5px;">'.$groupIDshow->id.'</span></th>';

END CODE

If you open the file, you can then control+f and search for the first line of the code above. I only have 1 custom field, so if you have more than 1 you will need to find out the field name in the database and replace 'data' above with that name.

Right, now the tricky bit that I can't quite get to work. In this same file there is a function called load_users(). Again control+f and search for this. From my understanding we need to alter 2 things in this function. Firstly, we need to change the SQL statement so that we include the custom field. This should be something like:

SELECT data FROM mdl_user_info_data

Then we need to change the switch statement. This bit means that if you click on the column header 'FirstName' it will sort by that whatever is in the statement. At the moment you can see it sorts by u.firstname then by u.lastname. So if we can get all the SQL correct and include 'data' from the mdl_user_info_data table, then I would have thought that we could just change this to sort data instead of u.firstname. You'll also have to change the case name 'firstname' to 'yourCustomFieldName'

If we can get all this done, then the final touch is to change a couple of lang strings so that the column header doesn't read 'Firstname / Lastname'. This bit is easy. Find the function get_headerhtml() and replace

$strfirstname = $this->get_lang_string('firstname');
$strlastname = $this->get_lang_string('lastname');

with...

$strfirstname = $this->get_lang_string('lastname');
$strlastname = 'yourCustomFieldName';

 Like I said, my SQL and PHP skills mean I can't seem to quite get this. In principle it works, I have managed for instance to display userid numbers and sort by those. And I can display the custom field data, but I can't get it to sort :  (

I hope this helps someone enough that they could complete the job. I'll keep trying and let you know if I get there.

Good luck

Phil