"; // if($role != 'Administrator'){print " disabled ";} // print " >"; while(odbc_fetch_row($teams)){ $text .= ""; } $text .= ""; return $text; } function prnSelRole($id){ global $db_conn; global $role; $roles= odbc_exec($db_conn,'SELECT "RoleId","RoleName" FROM "WhiteListing"."UserRoles" order by "RoleId"; '); $text = ""; return $text; } function prn_usradd(){ return "
User login name
User name
Email Id
Password
re-enter password
Team " . prnSelTeam('new_team') . "
Role " . prnSelRole('new_role') . "
 Comments:
"; } function prn_usredit(){ global $db_conn; $sql = "SELECT \"UserId\", \"Login\", \"UserName\", \"Email\", \"RoleId\", \"TeamId\",\"Coments\" FROM \"WhiteListing\".\"Users\" order by \"UserId\""; $usr = odbc_exec($db_conn,$sql); $usr1 = odbc_exec($db_conn,$sql); $def=''; $text= "
"; $text .=" User login name
User name
Email Id
Team ". prnSelTeam('currTeam') . "
Role " . prnSelRole('currRole') . "
description
"; while(odbc_fetch_row($usr)){ $text .=""; } $text.="
"; return $text; } function prn_roleadd(){ return "
Role
Description
"; } function prn_teamadd(){ return "
Team
Description
"; } function prn_roleedit(){ global $db_conn; $def=''; $sql = "SELECT \"RoleId\",\"RoleName\", \"Description\" FROM \"WhiteListing\".\"UserRoles\" order by \"RoleId\""; $role=odbc_exec($db_conn,$sql); $role1=odbc_exec($db_conn,$sql); $text = "
"; $text .=" "; } $text .=" Role
Description
"; return $text; } function prn_teamedit(){ global $db_conn; $sql = "SELECT \"TeamId\",\"TeamName\", \"TeamDescription\" FROM \"WhiteListing\".\"Teams\" order by \"TeamId\""; $team=odbc_exec($db_conn,$sql); $team1=odbc_exec($db_conn,$sql); $text = "
"; $text .=" "; } $text .=" Team
Description
"; return $text; } function prnManage(){ print "
"; } function prnManagePers(){ global $db_conn; $login = $_SESSION['login']; $sql="select \"Login\", \"UserName\", \"Email\" from \"WhiteListing\".\"Users\" where lower(\"Login\")=lower('". $login ."')"; $usr= odbc_exec($db_conn,$sql); print "
User login name
User name
Email Id
"; } function prnSettings($username){ global $passwd; print "
Change Password
Old Password
New password
re-enter password
"; } function prnReport(){ print "
"; } ?>