"' (".get_string('capacity', 'facetoface').": '", 'r.capacity', "')'");
$search_info->sql = "
FROM
{facetoface_room} r
WHERE
{$searchsql}
AND r.custom = 0
";
$search_info->order = " ORDER BY r.name ASC";
$search_info->params = $params;
break;
case 'this':
$keywords = search_parse_keywords($query);
$this->put_search_info($search_info, $formdata, $keywords);
break;
default:
print_error('invalidsearchtable222', 'local_core');
}
// Generate forn markup
// Create form
$mform = new dialog_search_form(null, $formdata);
// Display form
$mform->display();
$requireapproval = (search_for_value($attendees, 'statuscode', SEARCH_OP_EQUAL, MDL_F2F_STATUS_REQUESTED)) ? 1 : 0;
}
// Main page
$attendeescount = count($attendees);
$where = "username <> 'guest' AND deleted = 0 AND suspended = 0 AND confirmed = 1";
$params = array();
// Apply search terms
$searchtext = trim($searchtext);
if ($searchtext !== '') { // Search for a subset of remaining users
$fullname = $DB->sql_fullname();
$fields = array($fullname, 'email', 'idnumber', 'username');
$keywords = search_parse_keywords($searchtext);
list($searchwhere, $searchparams) = search_get_keyword_where_clause($keywords, $fields);
$where .= ' AND ' . $searchwhere;
$params = array_merge($params, $searchparams);
}
if($designation !=='' && $designation !=='null'){
$designations= implode("','",$designation);
if($designations !=='null' && $designations !=='all'){
$where .= " AND ud.designation IN('{$designations}')";
}
if($designations =='all'){
$design=list_departments();
$alldesignation= implode("','",$design);