function viewUserOutreach()
{
global $user;
$UID = $user->uid;
$userName = dbGetUserName($UID);
$params = drupal_get_query_parameters();
$currentYear = date("Y");
$totalFilterHours = 0;
$markup = "<h1>All Outreach for {$userName}</h1>";
if (isset($params["cancelled"])) {
$outreaches = dbGetCancelledOutreach($TID);
} else {
if (isset($params['query']) && $params['query'] == 'search') {
$outreaches = dbSearchOutreach($_SESSION['searchSQL'], $_SESSION['proxyFields']);
} else {
$outreaches = dbGetOutreachesForTeam($TID);
if (isset($params['status']) && $params['status'] != 'all') {
$proxyFields = array();
$outreaches = dbSearchOutreach(generateSearchSQL(array('status' => array($params['status'])), $proxyFields), $proxyFields);
}
}
}
foreach ($outreaches as &$outreach) {
$outreach['hours'] = dbGetHoursForOutreach($outreach['OID']);
$totalFilterHours += $outreach['hours'];
}
unset($outreach);
$markup .= '<div style="float:left"><h4>Hours With Current Filters: ' . $totalFilterHours . '</h4></div><br><br>';
$sortParam = isset($params["sort"]) ? $params['sort'] : 'name';
$statusParam = isset($params["status"]) ? $params['status'] : 'all';
orderByValue($outreaches, $sortParam, true);
// custom function (see helperFunctions.inc)
$markup .= '<div align="left" style="float: left">Sort By: ';
switch ($sortParam) {
case 'name':
$markup .= '<b>Name</b><b> | </b><a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=status">Status</a><b> | </b><a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=hours">Hours</a><b> | </b><a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=logDate">Log Date</a><br>';
break;
case 'status':
$markup .= '<a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=name">Name</a><b> | </b><b>Status | </b><a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=hours">Hours</a><b> | </b><a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=logDate">Log Date</a><br>';
break;
case 'hours':
$markup .= '<a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=name">Name</a><b> | </b><a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=status">Status</a><b> | </b><b>Hours | </b><a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=logDate">Log Date</a><br>';
break;
case 'logDate':
$markup .= '<a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=name">Name</a><b> | </b><a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=status">Status</a><b> | </b><a href="?q=allTeamOutreach&status=' . $statusParam . '&sort=hours">Hours</a><b> | </b><b>Log Date</b><br>';
break;
}
$markup .= 'Include Status: ';
switch ($statusParam) {
case 'isIdea':
$markup .= '<a href="?q=allTeamOutreach&sort=' . $sortParam . '">All</a><b> | </b><b>Idea | </b><a href="?q=allTeamOutreach&status=isOutreach&sort=' . $sortParam . '">Outreach</a><b> | </b><a href="?q=allTeamOutreach&status=doingWriteUp&sort=' . $sortParam . '">Write Up</a><br>';
break;
case 'isOutreach':
$markup .= '<a href="?q=allTeamOutreach&sort=' . $sortParam . '">All</a><b> | </b><a href="?q=allTeamOutreach&status=isIdea&sort=' . $sortParam . '">Idea</a><b> | </b><b>Outreach | </b><a href="?q=allTeamOutreach&status=doingWriteUp&sort=' . $sortParam . '">Write Up</a><br>';
break;
case 'doingWriteUp':
$markup .= '<a href="?q=allTeamOutreach&sort=' . $sortParam . '">All</a><b> | </b><a href="?q=allTeamOutreach&status=isIdea&sort=' . $sortParam . '">Idea</a><b> | </b><a href="?q=allTeamOutreach&status=isOutreach&sort=' . $sortParam . '">Outreach</a><b> | </b><b>Write Up</b><br>';
break;
default:
$markup .= '<b>All</b><b> | </b><a href="?q=allTeamOutreach&status=isIdea&sort=' . $sortParam . '">Idea</a><b> | </b><a href="?q=allTeamOutreach&status=isOutreach&sort=' . $sortParam . '">Outreach</a><b> | </b><a href="?q=allTeamOutreach&status=doingWriteUp&sort=' . $sortParam . '">Write Up</a><br>';
}
$markup .= '</div>';
orderByValue($outreaches, $sortParam, true);
// custom function (see helperFunctions.inc)
// Begin Displaying Outreach Events
$markup .= '<div align="right" style="float:right"><a href="?q=searchForm"><button>Search</button></a>';
if (!isset($params["cancelled"])) {
$markup .= '<a href="?q=allTeamOutreach&cancelled"><button>Cancelled</button></a>';
} else {
$markup .= '<a href="?q=allTeamOutreach"><button>All Outreaches</button></a>';
}
$markup .= '<a href="?q=viewOutreachSettings"><button';
$markup .= dbGetRIDForTeam($user->uid, $TID) > 0 ? '' : ' disabled';
$markup .= '>Outreach Settings</button></a>';
$markup .= '</div><br>';
$markup .= '<table><tr><th>Name</th>';
$markup .= '<th>Description</th>';
$markup .= '<th>Status</th>';
$markup .= '<th>Hours</th>';
$markup .= '<th>Log Date</th>';
foreach ($outreaches as $outreach) {
$hours = dbGetHoursForOutreach($outreach['OID']);
$status;
switch ($outreach['status']) {
case 'isOutreach':
$status = 'Outreach';
break;
case 'isIdea':
$status = 'Idea';
break;
case 'doingWriteUp':
$status = 'Write-Up';
break;
default:
$status = '[none]';
break;
}
$markup .= "<tr><td><a href='?q=viewOutreach&OID={$outreach['OID']}'>{$outreach['name']}</a></td>";
if (isset($outreach['description'])) {
$markup .= "<td>" . chopString($outreach['description'], 50) . "</td>";
} else {
$markup .= '<td>[none]</td>';
}
$markup .= "<td>{$status}</td>";
$markup .= "<td>{$hours}</td>";
$eventDate = date(TIME_FORMAT, dbDateSQL2PHP($outreach['logDate']));
$markup .= "<td>{$eventDate}</td></tr>";
}
$markup .= '</table>';
return array('#markup' => $markup);
}
function viewUsersForTeam($form, &$form_state)
{
global $user;
$params = drupal_get_query_parameters();
if (isset($params['TID'])) {
$TID = $params['TID'];
} else {
$TID = getCurrentTeam()['TID'];
}
if (teamIsIneligible($TID) || !isMyTeam($TID)) {
drupal_set_message('You do not have permission to access that page.', 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
$form_state['TID'] = $TID;
$canManageTeamMembers = hasPermissionForTeam('manageTeamMembers', $TID);
$canManageTeamOwners = hasPermissionForTeam('manageTeamOwners', $TID);
$markup = '<table><tr><td colspan="3">';
if (isset($params['query'])) {
$persons = dbSearchUsersFromTeam($TID, $params['query']);
} else {
$type = isset($params['type']) ? $params['type'] : '';
// filter by type (student vs mentor vs alumni)
$persons = dbGetUsersFromTeam($TID, $type);
}
if (empty($persons)) {
drupal_set_message('No users found.', 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
} else {
if (isset($params['query'])) {
$markup .= '<h1>Search Results (' . count($persons) . ' matches)</h1></td>';
} else {
$markup .= '<h1>' . count($persons) . ' users on Team ' . dbGetTeamNumber($TID) . '</h1></td>';
}
}
// create page header, table, and pending users/view all button
$markup .= '<td colspan="3" style="text-align:right">';
if ($canManageTeamMembers) {
if (!empty(dbGetUsersAwaitingApproval($TID))) {
$markup .= '<a href="?q=viewUsersToBeApproved&TID=' . $TID;
$markup .= '"><button type="button">View Pending Users</button></a>';
} else {
$markup .= '<button type="button" disabled>No Pending Users</button>';
}
$markup .= '<a href="?q=addTeamMember&TID=' . $TID;
$markup .= '&destination=' . current_path();
$markup .= '"><button type="button">Add User</button></a>';
}
if (isset($params['type'])) {
$markup .= '<a href="?q=showUsersForTeam&TID=' . $TID;
$markup .= '"><button type="button">View All</button></a>';
}
$markup .= '</td></tr></table>';
// sets up the table to display name, role, and grade of every user on the certain team
$markup .= '<table class="infoTable"><th>Name</th>';
$markup .= '<th>Email</td></th>';
$markup .= '<th>Team Role</td></th>';
$markup .= '<th>CROMA Role</th>';
// if user is an admin, they see a new column where they can change the role of other team members
if ($canManageTeamMembers) {
$markup .= '<th>Admin Functions</th>';
} else {
$markup .= '<th></th>';
}
$form['tableHeader'] = array('#markup' => $markup);
$i = 0;
foreach ($persons as $person) {
$form_state["UID-{$i}"] = $person['UID'];
$markup = '<tr><td><a href="?q=viewUser&UID=' . $person["UID"] . ' ">';
// hyperlinks the name so every name is linked to its user profile
$markup .= $person["firstName"] . " " . $person["lastName"] . '</a></td>';
$form["name-{$i}"] = array('#markup' => $markup);
$email = dbGetUserPrimaryEmail($person['UID']);
$markup = "<td><a href=\"mailto:{$email}\" target=\"_top\">{$email}</a></td>";
$form["email-{$i}"] = array('#markup' => $markup);
$markup = '<td>' . ucfirst(dbGetUserProfile($person['UID'])['type']) . '</td>';
$form["isStudent-{$i}"] = array('#markup' => $markup);
$RID = dbGetRIDForTeam($person['UID'], $TID);
$teamOwnerRID = dbGetRID('teamOwner');
$personIsTeamOwner = $RID == $teamOwnerRID;
// allow current user to change roles (but not change the role of the team owner)
if ($canManageTeamMembers && !$personIsTeamOwner) {
// if the person in question doesn't have a role
if (!$RID) {
$RID = 0;
}
$roles = dbGetAllRoles();
$roles[0] = 'Team Member';
// if current user can't create team owners
if (!$canManageTeamOwners) {
unset($roles[$teamOwnerRID]);
}
// make sure the roles are still in order
ksort($roles);
$form["RID-{$i}"] = array('#prefix' => '<td class="roleSelector">', '#type' => 'select', '#default_value' => $RID, '#options' => $roles, '#suffix' => '</td>', '#ajax' => array('event' => 'change', 'callback' => 'callback', 'wrapper' => 'confirm-div', 'method' => 'replace'));
} else {
// if the current user can't change the role
if ($RID == 0) {
$role = 'Member';
} else {
$role = dbGetRoleName($RID);
}
$form["role-{$i}"] = array('#prefix' => '<td>', '#markup' => $role, '#suffix' => '</td>');
}
// if the person in question is the current user
if ($person['UID'] == $user->uid) {
// if the person is the team owner -- transfer ownership
if ($personIsTeamOwner) {
$markup = "<td><a href=\"?q=transferTeamOwnership&TID={$TID}\">";
$markup .= "<button type=\"button\">Transfer Ownership</button></a></td>";
} else {
// allow user to leave team
$markup = "<td><a href=\"?q=leaveTeam/{$TID}\">";
$markup .= "<button type=\"button\">Leave Team</button></a></td>";
}
// if the current user can remove users
} else {
if ($canManageTeamMembers && !$personIsTeamOwner) {
$markup = "<td><a href=\"?q=kickUserFromTeam/{$person['UID']}/{$TID}\">";
$markup .= "<button type=\"button\" onclick=\"if(!confirm('Are you sure you want to remove this user from your team?')){return false;}\">Kick User</button></a></td>";
} else {
// or just some random person
$markup = '<td></td>';
}
}
$form["adminFunctions-{$i}"] = array('#markup' => $markup);
$form["rowFooter-{$i}"] = array('#markup' => '</tr>');
$i++;
}
// end of foreach
$form_state['numUsers'] = $i;
$form['tableFooter'] = array('#markup' => '</table>');
if ($canManageTeamMembers) {
$form['buttons'] = array('#prefix' => '<div id="confirm-div" style="visibility:hidden">', '#suffix' => '</div>');
$form['buttons']['confirm'] = array('#type' => 'submit', '#value' => 'Confirm');
}
return $form;
}
