/** * * @param type $sql * @param type $fieldname * @return type */ function list_ManyResult($sql, $fieldname) { // require hierarchy if ($fieldname == 'faculte') { require_once 'include/lib/hierarchy.class.php'; } $resu = array(); $res = Database::get()->queryArray($sql); foreach ($res as $resA) { if ($fieldname == 'faculte') { $name = hierarchy::unserializeLangField($resA->faculte); } else { $name = $resA->$fieldname; } $resu[$name] = $resA->nb; } return $resu; }
break; default: break; } // end of switch } else { // show username as well (useful) $sql = Database::get()->queryArray("SELECT id, givenname, surname, username, faculty_id, date_open, comment, password FROM user_request\n WHERE (state = 1 AND status = {$list_status} {$depqryadd})"); if (count($sql) > 0) { $tool_content .= "<div class='table-responsive'><table id='requests_table' class='table-default'>"; $tool_content .= table_header(); $tool_content .= "<tbody>"; foreach ($sql as $req) { $tool_content .= "<td>" . q($req->givenname) . " " . q($req->surname) . "</td>"; $tool_content .= "<td>" . q($req->username) . "</td>"; $tool_content .= "<td>" . hierarchy::unserializeLangField(find_faculty_by_id($req->faculty_id)) . "</td>"; $tool_content .= "<td align='center'>\n <small>" . nice_format(date('Y-m-d', strtotime($req->date_open))) . "</small></td>"; $tool_content .= "<td class='option_btn_cell'>"; switch ($req->password) { case 'pop3': $link = "../auth/ldapnewprofadmin.php?id={$req->id}&auth=2"; $authmethod = "({$langViaPop})"; break; case 'imap': $link = "../auth/ldapnewprofadmin.php?id={$req->id}&auth=3"; $authmethod = "({$langViaImap})"; break; case 'ldap': $link = "auth/ldapnewprofadmin.php?id={$req->id}&auth=4"; $authmethod = "({$langViaLdap})"; break;