$ids = implode(',', $ids);
} else {
$ids = '';
}
$course = $DB->get_record('course', array('id' => $courseid));
//set some text vars
$strsearch = get_string('search');
$strsearchresults = get_string('searchresults');
$strshowall = trim(get_string('showall', 'moodle', ""));
//if isset form doactions
if ($frm = data_submitted()) {
if (!empty($frm->addselect) && confirm_sesskey()) {
credentials::bulk_assign_users($book->isbn, $array_ids, $frm->addselect);
} else {
if (!empty($frm->removeselect) && confirm_sesskey()) {
credentials::bulk_unassign_users($book->isbn, $frm->removeselect);
} else {
if ($showall) {
$searchtext = '';
$courseid = 0;
}
}
}
}
$already_asigned_users = $DB->get_records_sql("SELECT c.euserid as id, u.firstname, u.lastname, u.email FROM {user} u RIGHT JOIN {rcommon_user_credentials} c ON u.id = c.euserid WHERE c.id IN ({$ids}) AND euserid <> 0");
$already_asigned_users_cnt = $already_asigned_users ? count($already_asigned_users) : 0;
//echo '<hr>alredy_asigned_users: ' . serialize($already_asigned_users) . '<hr>';
$already_unassigned = $ids_cnt - $already_asigned_users_cnt;
$search_where = !empty($searchtext) ? " AND (firstname LIKE '%{$searchtext}%' OR lastname LIKE '%{$searchtext}%' OR username LIKE '%{$searchtext}%')" : '';
if (empty($courseid)) {
// MARSUPIAL ************* MODIFICAT -> Add extra control for just show the users confirmed and non deleted in the assigment books credentials process
