function publicOutreach($form, &$form_state)
{
global $user;
$UID = $user->uid;
$TID = getCurrentTeam()['TID'];
$outreaches = dbGetLockedOutreachForTeam($TID);
// checking to make sure user has permission to change team outreach settings
if (!hasPermissionForTeam('editAnyOutreach', $TID)) {
drupal_set_message("You don't have permission to change outreach settings for this team.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
// checking to see if the user has a team assigned
if (dbGetTeamsForUser($user->uid) == false) {
drupal_set_message("You don't have a team assigned.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
// checking to see if the user is approved for the team
if (!dbIsUserApprovedForTeam($UID, $TID)) {
drupal_set_message("You aren't approved for this team.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
// checking to see if the team is active
if (dbGetStatusForTeam($TID) == "0" || dbGetStatusForTeam($TID) == false) {
drupal_set_message("This team isn't active/approved.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
$names = array();
$data = array();
// if team has locked outreaches
if (!empty($outreaches)) {
foreach ($outreaches as $outreach) {
$names[$outreach['OID']] = $outreach['name'];
if ($outreach['isPublic']) {
$data[] = $outreach['OID'];
}
}
}
// begin form
$form = array();
$form['fields'] = array('#type' => 'fieldset', '#title' => t('Changing Visibilities For ' . dbGetTeamNumber($TID)));
$new = false;
// cancel changes button doesn't save anything and goes back to team outreach settings
if (!$new) {
$form['fields']['back'] = array('#prefix' => '<left>', '#limit_validation_errors' => array(), '#submit' => array('backToSettings'), '#type' => 'submit', '#value' => '⇦ Cancel Changes', '#attributes' => array('OnSubmit' => 'if(!confirm("Back?")){return false;}'), '#suffix' => '</left>');
}
// if the team has locked outreaches
if (!empty($outreaches)) {
$form['fields']['outreaches'] = array('#prefix' => '<table><tr><td>', '#type' => 'checkboxes', '#title' => t('<h5>Which outreaches would you like to make public?</h5>'), '#options' => $names, '#default_value' => $data, '#suffix' => '</td></tr><tr><td><br>Only showing outreaches which are "locked".</td></tr>', '#checkall' => true);
$form['fields']['footer'] = array('#markup' => '</table>');
$form['fields']['submit'] = array('#prefix' => '<table><tr><td colspan="3" style="text-align:right">', '#type' => 'submit', '#value' => t('Save'), '#suffix' => '</td></tr></table>');
} else {
// if the team does not have any locked outreaches
$form['fields']['outreaches'] = array('#prefix' => '<table><tr><td colspan="3" style="text-align:left">', '#markup' => "Your team doesn't have any locked outreaches. All locked outreaches are displayed on this page. If you make a locked outreach public, it becomes visible on the outreach directory widget.<br>", '#suffix' => '</td></tr></table>');
}
return $form;
}
function teamForm($form, &$form_state)
{
global $user;
$UID = $user->uid;
$params = drupal_get_query_parameters();
$new = true;
if (isset($params["TID"])) {
// getting the team ID if it's set in the URL's parameters
$oldTeam = dbGetTeam($params["TID"]);
$new = false;
}
$form = array();
if ($new) {
// if user is creating a completely new team
$form['fields'] = array('#type' => 'fieldset', '#title' => t('Create A New Team'));
} else {
// if user is editing a team
$form['fields'] = array('#type' => 'fieldset', '#title' => t('Edit: ' . $oldTeam['name']));
}
if (!$new) {
// if user wants to cancel any changes they made
$form['fields']['back'] = array('#prefix' => '<left>', '#limit_validation_errors' => array(), '#submit' => array('backToTeam'), '#type' => 'submit', '#value' => '⇦ Cancel Changes', '#attributes' => array('OnSubmit' => 'if(!confirm("Back?")){return false;}'), '#suffix' => '</left>');
}
// setting the team name
$form['fields']['name'] = array('#prefix' => '<table><tr><td colspan="3" style="text-align:center">', '#default_value' => $new ? '' : $oldTeam['name'], '#type' => 'textfield', '#disabled' => $new ? false : true, '#title' => t('Team Name'), '#suffix' => '</td>');
// setting the team number
$form['fields']['number'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#default_value' => $new ? '' : $oldTeam['number'], '#type' => 'textfield', '#disabled' => $new ? false : true, '#title' => t('Team Number'), '#suffix' => '</td></tr>');
// setting the type of robotics team (FLL vs FTC vs FRC etc.)
$form['fields']['type'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#default_value' => $new ? '' : $oldTeam['type'], '#type' => 'select', '#title' => t('Type of Team'), '#options' => array('FRC' => 'FIRST Robotics Competition', 'FTC' => 'FIRST Technology Challenge', 'FLL' => 'FIRST Lego League', 'Other' => 'Other'), '#chosen' => true, '#suffix' => '</td>');
// setting the home city
$form['fields']['city'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#default_value' => $new ? '' : $oldTeam['city'], '#type' => 'textfield', '#title' => t('City'), '#suffix' => '</td></tr>');
// setting the home state
$form['fields']['state'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#default_value' => $new ? '' : $oldTeam['state'], '#type' => 'select', '#title' => t('State'), '#options' => states_list(), '#chosen' => true, '#suffix' => '</td>');
// setting the home country of the team
$form['fields']['country'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#default_value' => $new ? '' : $oldTeam['country'], '#type' => 'select', '#title' => t('Country'), '#options' => countries_list(), '#default_value' => 'United States', '#chosen' => true, '#suffix' => '</td></tr>');
// rookie year of team
$form['fields']['rookieYear'] = array('#prefix' => '<tr><td colspan="6" style="text-align:center">', '#type' => 'textfield', '#title' => t('Rookie Year'), '#default_value' => $new ? NULL : $oldTeam['rookieYear'], '#suffix' => '</td></tr><tr>');
if (!$new) {
// if the team is not new and you want to delete permanently, then you can do it via this button
$form['fields']['delete'] = array('#prefix' => '<td colspan="3" style="text-align:left">', '#type' => 'submit', '#value' => 'Delete Team', '#limit_validation_errors' => array(), '#attributes' => array('onclick' => 'if(!confirm("Are you sure you want to delete this team PERMANENTLY?")){return false;}'), '#submit' => array('deleteTeam'), '#suffix' => '</td>');
// submitting the info which the user just updated
$form['fields']['submit'] = array('#prefix' => '<td colspan="3" style="text-align:right">', '#type' => 'submit', '#value' => t('Save'), '#suffix' => '</td>');
} else {
// submitting the info which the user just inputted (with a different colspan)
$form['fields']['submit'] = array('#prefix' => '<td colspan="6" style="text-align:right">', '#type' => 'submit', '#value' => t('Save'), '#suffix' => '</td>');
}
$form['fields']['footer'] = array('#markup' => '</tr></table>');
// checking proper permissions for user
if (!$new && !hasPermissionForTeam('editTeam', $params['TID'])) {
drupal_set_message("You don't have permission to edit {$oldTeam['name']}.", 'error');
drupal_goto('viewTeam', array('query' => array('TID' => $params['TID'])));
}
return $form;
}
function tagManager($form, &$form_state)
{
$team = getCurrentTeam();
$form_state['TID'] = $TID = $team['TID'];
if (teamIsIneligible($TID)) {
drupal_set_message('Your team does not have permission to access this page.', 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
$currentURL = getCurrentURL();
// if browser didn't end up here by coming from the current page
if ($currentURL != getAjaxURL() && (isset($_SERVER['HTTP_REFERER']) && $_SERVER['HTTP_REFERER'] != $currentURL)) {
switchTagEditMode(false);
// be sure to start with just viewing the tags
if (!empty(drupal_get_query_parameters())) {
// clear any other drupal_query_parameters
drupal_goto(parseURLAlias($_SERVER['QUERY_STRING']));
}
}
$markup = "<h1>Team {$team['number']} Outreach Settings</h1>";
$editMode = checkTagEditMode();
// create the wrapper-div used by AJAX
$form['tags'] = array('#prefix' => '<div id="tags-div">', '#suffix' => '</div>');
$tableHeader = '<table><tr><td><div class="help tooltip2"><h2>Outreach Tags</h2><span id="helptext"; class="helptext tooltiptext2">Outreach Tags are used to tag similar outreaches.</span></div></td><td><div align="right">';
$form['tags']['tableHeader'] = array('#markup' => $tableHeader);
// only show edit button if in "view mode" and the user has proper permissions
if (!$editMode && hasPermissionForTeam('manageOutreachTags', $TID)) {
$form['tags']['buttons'] = array('#type' => 'image_button', '#src' => '/images/icons/editWhite.png', '#attributes' => array('class' => array('editIcon')), '#limit_validation_errors' => array(), '#submit' => array('switchTagEditMode'));
}
// finish off the title and buttons table, then start the table for the tags themselves
$tableHeader2 = '</div></td></tr></table>';
$tableHeader2 .= '<table class="infoTable"><tr><th>Tag Name</th>';
if (!$editMode) {
$tableHeader2 .= '<th style="text-align:center">Matched Outreaches</th>';
} else {
$tableHeader2 .= '<th></th><th></th>';
}
$form['tags']['tableHeader2'] = array('#markup' => $tableHeader2);
$tags = dbGetOutreachTagsForTeam($TID);
if (!$editMode) {
// if in "view" mode (aka not acting as a form)
$tableContents = '';
$tableContents .= '</tr>';
if (!empty($tags)) {
foreach ($tags as $OTID => $tagName) {
// display the name
$tableContents .= '<tr><td>' . $tagName . '</td>';
// show the number of matching outreaches (which can be clicked on to search the outreach form by tags)
$numMatched = dbGetOutreachMatchingTags(array($tagName), $TID, true);
// "true" indicates only a count is returned
$tableContents .= "<td style=\"text-align:center\"><a href=\"?q=outreach&tag={$OTID}\">{$numMatched}</a></td></tr>";
}
} else {
$tableContents = '<tr><td colspan="2" style="text-align:center"><em>[None]</em></td></tr>';
}
$form['tags']['tableContents'] = array('#markup' => $tableContents);
} else {
// -------------------------------- in "edit" mode
$i = 0;
if (!empty($tags)) {
foreach ($tags as $OTID => $tagName) {
$i++;
$form['tags']["tagName-{$i}"] = array('#prefix' => '<tr><td colspan="2">', '#type' => 'textfield', '#maxlength' => 50, '#default_value' => $tagName, '#suffix' => '</td>');
$numMatching = dbGetOutreachMatchingTags(array(dbGetTagName($OTID)), $TID, true);
$confirmBoxJS = '';
if ($numMatching > 0) {
$confirmBoxJS = "if(!confirm('This tag matches {$numMatching} outreach(es). Are you sure you want to delete it?')){return false;}";
}
$form['tags']["deleteBttn-{$i}"] = array('#prefix' => "<td><a href=\"?q=deleteTag/{$OTID}/{$TID}\">", '#markup' => "<button onclick=\"{$confirmBoxJS}\" type=\"button\"><img src=\"/images/icons/trashWhite.png\" class=\"trashIcon\"></button>", '#suffix' => '</a></td></tr>');
$form_state["OTID-{$i}"] = $OTID;
}
// end of foreach
}
// end of if
$form_state['numTags'] = $i;
// initialize the 'numNewRows' variable
if (empty($form_state['numNewRows'])) {
$form_state['numNewRows'] = 1;
}
$x;
// PHP is weird and makes you declare a variable before the loop
// create the empty row for creating new tags
for ($x = 1; $x <= $form_state['numNewRows']; $x++) {
// have to be sure to not overwrite anything
// create row to allow entry of a new tag
$form['tags']["newTagName-{$x}"] = array('#prefix' => '<tr><td>', '#type' => 'textfield', '#maxlength' => 50, '#suffix' => '</td>');
// if this is the last row (and not the only row), add a "-" button
if ($form_state['numNewRows'] > 1 && $x == $form_state['numNewRows']) {
$form['tags']["newRemoveBttn-{$x}"] = array('#prefix' => '<td>', '#type' => 'submit', '#submit' => array('removeTagRow'), '#value' => '-', '#limit_validation_errors' => array(), '#ajax' => array('callback' => 'modifyTagRows_callback', 'wrapper' => 'tags-div'), '#suffix' => '</td>');
} else {
// add a placeholder instead of the "-" button
$form['tags']["removeBttnPlaceHolder-{$x}"] = array('#markup' => '<td></td>');
}
// if this is the last row, add a "+" button
if ($x == $form_state['numNewRows']) {
$form['tags']["newAddBttn-{$x}"] = array('#prefix' => '<td>', '#type' => 'submit', '#submit' => array('addTagRow'), '#value' => '+', '#limit_validation_errors' => array(), '#ajax' => array('callback' => 'modifyTagRows_callback', 'wrapper' => 'tags-div'), '#suffix' => '</td>');
} else {
// add a placeholder instead of the "+" button
$form['tags']["addBttnPlaceHolder-{$x}"] = array('#markup' => '<td></td>');
}
$for['tags']["rowFooter-{$x}"] = array('#markup' => '</tr>');
}
// end of for loop
}
// end of else (aka edit mode code)
$form['tags']['tableFooter'] = array('#markup' => '</table>');
// allow the user to cancel and return to the previous page
// (note that the URL for cancel has a random extra parameter to ensure the mode is changed to view)
if ($editMode) {
$form['cancel'] = array('#prefix' => '<table><tr><td style="text-align:left">', '#markup' => '<a href="?q=teamOutreachSettings¬Edit"><button type="button">Cancel</button></a>', '#suffix' => '</td>');
$form['submit'] = array('#prefix' => '<td style="text-align:right">', '#type' => 'submit', '#value' => 'Confirm', '#suffix' => '</td></tr></table>');
}
return $form;
}
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;
}
function teamSummary($form, &$form_state)
{
global $user;
$UID = $user->uid;
$team = getCurrentTeam();
$teams = dbGetTeamsForUser($UID);
$form = array();
if (isset($params["UID"])) {
$UID = $params["UID"];
} else {
$UID = $user->uid;
}
if (isset($params['TID'])) {
$TID = $params['TID'];
$team = dbGetTeam($TID);
$teamNumber = $team['number'];
} else {
$team = getCurrentTeam();
$TID = $team['TID'];
$team = dbGetTeam($TID);
$teamNumber = $team['number'];
}
// if team is not empty
if (!empty($teams)) {
$TID = $team['TID'];
if (count($teams) != 1) {
// if user has multiple teams then able to change team
$multiple = true;
$choices = array();
} else {
// if user has one team then display team number
$multiple = false;
}
foreach ($teams as $userTeam) {
$choices[$userTeam['TID']] = $userTeam['number'];
}
$markup = '<table id="teamPageSummary" style="margin:112px 0px 0px 0px; padding:0px"><tr style="text-align:center"><td ';
if (!$multiple) {
$markup .= 'colspan="2" style="text-align:center;';
} else {
$markup .= 'style="text-align:right;';
}
$markup .= ' width:50%; padding:0px"><h2>' . $team['type'] . ' ';
$form['fields']['header'] = array('#markup' => $markup);
if ($multiple) {
$form['fields']['team'] = array('#prefix' => '</h2></td><td style="width:50%;padding:0px">', '#type' => 'select', '#default_value' => $TID, '#options' => $choices, '#chosen' => true, '#attributes' => array('onChange' => 'document.getElementById("teamsummary").submit();'), '#suffix' => '</td></tr>');
} else {
$form['fields']['team'] = array('#markup' => $team['number'] . '</h2></td></tr>');
}
if (!empty($team['FID'])) {
$FID = $team['FID'];
$file = file_load($FID);
$uri = $file->uri;
$variables = array('style_name' => 'profile', 'path' => $uri, 'width' => '150', 'height' => '150');
$image = theme_image_style($variables);
$form['fields']['FID'] = array('#prefix' => '<tr><td colspan="2" style="text-align:center">', '#type' => 'item', '#markup' => $image, '#suffix' => '</td></tr>');
} else {
// if team does not have a picture, then displays default pic
$form['fields']['FID'] = array('#prefix' => '<tr><td colspan="2" style="text-align:center">', '#markup' => '<img src="/images/defaultPics/team.png" style="max-width:200px; width:auto; height:auto; padding: 15px 0px 15px 0px">', '#suffix' => '</td></tr>');
}
$form['fields']['markupOne'] = array('#markup' => '<tr><td style="text-align:left"><a href="?q=viewTeam&TID=' . $TID . '"><div class="help tooltip4"><button type="button">Team Info</button><span id="helptext"; class="helptext tooltiptext4">Click here to view/edit your team info or to enter old team hours.</span></div></a></td>');
if (hasPermissionForTeam('manageOutreachTags', $TID)) {
$form['fields']['markupTwo'] = array('#markup' => '<td colspan="2" style="text-align:right"><a href="?q=teamOutreachSettings"><div class="help tooltip3"><button type="button">Settings</button><span id="helptext"; class="helptext tooltiptext3">If you have permission, click here to manage your teams outreach tags and outreach visibilities.</span></div></a></td></tr></table>');
} else {
$form['fields']['markupTwo'] = array('#markup' => '<td colspan="2" style="text-align:right"><div class="help tooltip3"><button type="button" disabled>Settings</button><span id="helptext"; class="helptext tooltiptext3">If you have permission, click here to manage your teams outreach tags and outreach visibilities.</span></div></td></tr></table>');
}
if ($multiple) {
$form['fields']['submit'] = array('#type' => 'submit', '#value' => 'Update', '#attributes' => array('style' => array('display: none;')));
}
}
return $form;
}
function viewHours()
{
$params = drupal_get_query_parameters();
global $user;
// checks to make sure you are assigned to a team
if (dbGetTeamsForUser($user->uid) == NULL) {
drupal_set_message("You don't have a team assigned.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
// setting all permissions to a default "false" value
$canEdit = $canApprove = $myHours = false;
$markup = '';
// showing the hours if the UID is set for a user
$filterParams = array();
if (isset($params['UID'])) {
$UID = $params['UID'];
$myHours = $UID == $user->uid;
$filterParams['hourCounting.UID'] = $UID;
$userName = dbGetUserName($UID);
$markup = "<table><tr><td><h1>Hours for {$userName}</h1></td></tr></table>";
}
// showing the hours if the OID is set for an outreach
if (isset($params['OID'])) {
$OID = $params['OID'];
$TID = getCurrentTeam()['TID'];
$filterParams['OID'] = $OID;
$canEdit = canEditHoursForOutreach($OID);
// can be set for the entire page
if (hasPermissionForTeam('manageOutreachTags', $TID)) {
$canApprove = true;
// can be set for the entire page
}
$outreachName = dbGetOutreachName($OID);
$markup = "<table><tr><td><h1>Hours for {$outreachName}</a></h1></td>";
}
if (isset($params['OID']) && isset($params['UID']) && !isset($params['TID'])) {
$markup = "<table><tr><td><h1>Hours contributed to {$outreachName} by {$userName}</h1></td></tr></table>";
}
// showing the hours needing to be approved for a team if the TID is set
if (isset($params['TID'])) {
$TID = $params['TID'];
$filterParams['TID'] = $TID;
$filterParams['isApproved'] = 0;
$teamName = dbGetTeamName($TID);
$markup = "<table><tr><td><h1>Hours to be approved for {$teamName}</h1></td></tr></table>";
}
// if the filters are not empty...
if (!empty($filterParams)) {
$hoursEntries = dbGetHours($filterParams);
// get all the matching "hour" records
if (isset($OID)) {
$markup .= '<td style="text-align:right">';
$markup .= "<a href=\"?q=logHours&OID={$OID}\"><button>Add Hours</button></a></td></tr></table>";
}
$markup .= '<table class="infoTable">';
// starting the table
if (empty($OID)) {
$markup .= '<th>Event</th>';
}
if (!$myHours) {
$markup .= '<th>Person</th>';
}
$markup .= '<th>Type</th><th># Hours</th>';
$markup .= '<th></th>';
// create placeholder column
foreach ($hoursEntries as $hours) {
$markup .= '<tr>';
if (!isset($OID)) {
// permissions must be set per hour record
$canEdit = canEditHours($hours['HID']);
// can be set for the entire page
$canApprove = canApproveHours($hours['HID']);
// can be set for the entire page
if (isset($TID) && !$canApprove) {
// if trying to approve hours for the team
continue;
}
$outreachName = dbGetOutreachName($hours['OID']);
$markup .= "<td><a href=\"?q=viewOutreach&OID={$hours['OID']}\">{$outreachName}</a></td>";
}
// if the hours don't belong the current user, show the name of the person they do belong to
if (!$myHours) {
$markup .= '<td>';
if ($hours['UID'] != null) {
$name = dbGetUserName($hours['UID']);
$email = dbGetUserPrimaryEmail($hours['UID']);
$markup .= "<a href=\"mailto:{$email}\" target=\"_top\">{$name}</a>";
} else {
$markup .= '[none]';
}
$markup .= '</td>';
}
switch ($hours['type']) {
// switch the type to be more formal
case 'prep':
$formalType = "Preparation";
break;
case 'atEvent':
$formalType = "At Event";
break;
case 'writeUp':
$formalType = "Write Up";
break;
case 'followUp':
$formalType = "Follow Up";
break;
case 'other':
$formalType = "Other";
break;
}
$markup .= "<td>{$formalType}</td>";
$markup .= "<td>{$hours['numberOfHours']}</td>";
if ($canEdit || $canApprove) {
$markup .= '<td>';
if ($canEdit) {
// if user can edit...
$markup .= "<a href=\"?q=logHours&HID={$hours['HID']}\">";
$markup .= '<button><img class="editIcon" src="/images/icons/editWhite.png"></button></a>';
$markup .= "<a href=\"?q=deleteHours/{$hours['HID']}\">";
$markup .= '<button><img class="trashIcon" src="/images/icons/trashWhite.png"></button></a>';
}
if ($canApprove && !$hours['isApproved']) {
// if user can approve hours and the hours are not approved...
$markup .= "<a href=\"?q=approveHours/{$hours['HID']}\">";
$markup .= '<button>Approve Hours</button></a>';
} else {
if (!$hours['isApproved']) {
$markup .= '<button disabled>Approve Hours</button>';
}
}
$markup .= '</td>';
}
$markup .= '</tr>';
}
if (empty($hoursEntries)) {
$markup .= '<tr><td style="text-align:center" colspan="10"><em>[None]</em></td></tr>';
}
$markup .= '</table>';
} else {
// no filter params
drupal_set_message('No filter parameters selected.', 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
return array('#markup' => $markup);
}
function writeUpsAwaitingApproval()
{
$currentTeam = getCurrentTeam();
if ($currentTeam == false) {
drupal_set_message("You don't have a team assigned.", 'error');
return;
}
$TID = $currentTeam['TID'];
$teamNumber = $currentTeam['number'];
// create header
$markup = '<h2>Write-Ups Awaiting Approval</h2>';
$markup .= '<table class="infoTable"><tr><th colspan="3">Name</th>';
$markup .= '<th colspan="2">Log Date</th>';
$markup .= '<th colspan="2">Owner</th>';
$markup .= '<th></th>';
$markup .= "</tr>";
// "true" indicates to only get write-ups that have been submitted
$outreaches = dbGetWriteUpsForTeam($TID, true);
// if the team has write-ups
if (!empty($outreaches)) {
$count = 0;
foreach ($outreaches as $outreach) {
$count++;
$TID = $outreach['TID'];
$team = dbGetTeam($outreach['TID']);
$rawDate = $outreach['logDate'];
$rawDate = dbDateSQL2PHP($rawDate);
$logDate = date(TIME_FORMAT, $rawDate);
$OID = $outreach['OID'];
$owner = dbGetOutreachOwner($OID);
$markup .= "<tr>";
$markup .= '<td colspan="3">' . '<a href="?q=viewOutreach&OID=' . $outreach['OID'] . '">' . chopString($outreach["name"], 20) . '</a>' . '</td>';
$markup .= '<td colspan="2">' . $logDate . '</td>';
$markup .= '<td colspan="2">' . dbGetUserName($owner) . ' </td>';
// button to view the write up
if (hasPermissionForTeam('approveIdeas', $TID)) {
$markup .= '<td><a href="?q=writeupform&approving&OID=' . $OID . '"><button>View</button></a></td>';
} else {
$markup .= '<td></td>';
}
$markup .= "</tr>";
}
// if the team doesn't have any write-ups
} else {
$markup .= "<tr>";
$markup .= '<td style="text-align:center" colspan="8"><em>[None]</em></td>';
$markup .= "</tr>";
}
$markup .= "</table>";
$retArray = array();
$retArray['#markup'] = $markup;
return $retArray;
}
function outreachForm($form, &$form_state)
{
global $user;
$UID = $user->uid;
$params = drupal_get_query_parameters();
$currentTeam = getCurrentTeam();
$TID = $currentTeam['TID'];
$form_state['TID'] = $TID;
$new = $form_state['new'] = true;
if (teamIsIneligible($TID)) {
drupal_set_message('Your team does not have permission to access this page.', 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
if (isset($params["OID"])) {
$form_state['OID'] = $params['OID'];
$new = $form_state['new'] = false;
$outreach = dbGetOutreach($params["OID"]);
$times = dbGetTimesForOutreach($params["OID"]);
// set to display all times
$form_state['numRows'] = count($times);
// record how many were there before (in case user deletes one)
$form_state['initialNumTimes'] = count($times);
$TID = $outreach['TID'];
$form_state['TID'] = $TID;
}
$form = array();
// if the user is editing an old outreach
if (!$new) {
// menu hook to duplicate outreach
$confirmBoxJS = "if(!confirm('Are you sure you want to duplicate this outreach? Any changes you made just now will NOT be saved.')){return false;}";
$form['duplicate'] = array('#prefix' => "<div style=\"text-align:right\"><a href=\"?q=duplicateOutreach/{$form_state['OID']}/{$TID}\">", '#markup' => "<button onclick=\"{$confirmBoxJS}\" type=\"button\">Duplicate</button>", '#suffix' => '</a>');
}
if (!$new) {
// menu hook to cancel the outreach
if ($outreach["cancelled"]) {
$confirmBoxJS = "if(!confirm('Are you sure you want to uncancel this outreach for the team?')){return false;}";
$form['cancel'] = array('#prefix' => "<a href=\"?q=cancelOutreach/{$form_state['OID']}/{$TID}\">", '#markup' => "<button onclick=\"{$confirmBoxJS}\" type=\"button\">Uncancel Outreach</button>", '#suffix' => '</a></div>');
} else {
$confirmBoxJS = "if(!confirm('Are you sure you want to cancel this outreach for the team? This will remove the outreach from current team use.')){return false;}";
$form['cancel'] = array('#prefix' => "<a href=\"?q=cancelOutreach/{$form_state['OID']}/{$TID}\">", '#markup' => "<button onclick=\"{$confirmBoxJS}\" type=\"button\">Cancel From Team Use</button>", '#suffix' => '</a></div>');
}
}
$teamNumb = dbGetTeamNumber($TID);
// form title
$form['fields'] = array('#type' => 'fieldset', '#title' => t('Add Outreach: Team ' . '<b>' . $teamNumb . '</b>'));
// if editing an outreach, then allow a user to cancel changes
if (!$new) {
$form['fields']['back'] = array('#prefix' => '<left>', '#limit_validation_errors' => array(), '#submit' => array('backToEvent'), '#type' => 'submit', '#value' => '⇦ Cancel Changes', '#attributes' => array('OnSubmit' => 'if(!confirm("Back?")){return false;}'), '#suffix' => '</left>');
}
$form['fields']['markupOne'] = array('#markup' => '<table>');
// displays the name of the outreach editing
$form['fields']['name'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t('Outreach Name:'), '#default_value' => $new ? '' : $outreach['name'], '#placeholder' => 'Name of the event', '#attributes' => array('onsubmit' => 'return false'), '#suffix' => '</td>');
$tags = dbGetOutreachTagsForTeam($TID);
// notifies a user to create outreach tags if the team doesn't have any
if (empty($tags)) {
if (hasPermissionForTeam('manageOutreachTags', $TID)) {
$msg = 'Click <a href="?q=teamOutreachSettings"><b>here</b></a> to change your settings.';
} else {
$msg = 'Please have a team admin or owner set up tags for your team.';
}
drupal_set_message('To give the outreach a tag, you need to set up the tag options for your team! ' . $msg, 'error');
$form['fields']['tags'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#markup' => 'Tags:<br><em>You have no available tags.</em>', '#suffix' => '</td></tr>');
} else {
// allows a user to add tags to the outreach
if (!$new) {
// get only OTID's to satisfy select field
$oldTags = dbGetTagsForOutreach($form_state['OID'], true);
}
$form['fields']['tags'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#type' => 'select', '#id' => 'tags_field', '#title' => t('Tags:'), '#options' => $tags, '#default_value' => $new ? '' : $oldTags, '#chosen' => true, '#multiple' => true, '#suffix' => '</td></tr>');
}
// allows a user to change the status of the outreach if they have permission
if (hasPermissionForTeam('manageOutreachTags', $TID)) {
$form['fields']['status'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'select', '#default_value' => $new ? 'Select' : $outreach['status'], '#options' => array('isIdea' => 'Idea', 'isOutreach' => 'Outreach', 'doingWriteUp' => 'Write-Up', 'locked' => 'Locked'), '#title' => t('Status:'), '#chosen' => true, '#suffix' => '</td>');
// if the user doesn't have permission, then the status of isIdea displays idea
} else {
if (!$new && $outreach['status'] == 'isIdea') {
$form['fields']['status'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'select', '#title' => t('Status:'), '#options' => array('isIdea' => 'Idea'), '#default_value' => 'isIdea', '#disabled' => true, '#suffix' => '</td>');
// if the user doesn't have permission, then the status of isOutreach displays outreach
} else {
if (!$new && $outreach['status'] == 'isOutreach') {
$form['fields']['status'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'select', '#title' => t('Status:'), '#options' => array('isOutreach' => 'Outreach'), '#default_value' => 'isOutreach', '#disabled' => true, '#suffix' => '</td>');
// if the user doesn't have permission, then the status of doingWriteUp displays write-up
} else {
if (!$new && $outreach['status'] == 'doingWriteUp') {
$form['fields']['status'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'select', '#title' => t('Status:'), '#options' => array('doingWriteUp' => 'Write-Up'), '#default_value' => 'doingWriteUp', '#disabled' => true, '#suffix' => '</td>');
// if the user doesn't have permission, then the status of locked displays locked
} else {
if (!$new && $outreach['status'] == 'locked') {
$form['fields']['status'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'select', '#title' => t('Status:'), '#options' => array('locked' => 'Locked'), '#default_value' => 'locked', '#disabled' => true, '#suffix' => '</td>');
// if the user doesn't have permission, then the events created can only have a status of idea
} else {
$form['fields']['status'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'select', '#default_value' => $new ? 'Select' : $outreach['status'], '#options' => array('isIdea' => 'Idea'), '#title' => t('Status:'), '#chosen' => true, '#suffix' => '</td>');
}
}
}
}
}
// allows a user to go to team outreach settings
$form['fields']['manageTagsBttn'] = array('#prefix' => '<td colspan ="3" style="text-align:center">', '#markup' => '<a href="?q=teamOutreachSettings" target="_blank"><button type="button">Manage Tags</button></a>', '#suffix' => '</td></tr>');
$form['fields']['description'] = array('#prefix' => '<tr><td colspan="6" style="text-align:center">', '#type' => 'textarea', '#title' => t('Description:'), '#default_value' => $new ? '' : $outreach['description'], '#placeholder' => 'Maximum of 500 characters', '#suffix' => '</td></tr>', '#maxlength_js' => 'TRUE', '#maxlength' => '500');
$form['fields']['address'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t('Address:'), '#default_value' => $new ? '' : $outreach['address'], '#suffix' => '</td>');
$team = dbGetTeam($TID);
// default value from the team form
$form['fields']['city'] = array('#prefix' => '<td colspan="1" style="text-align:center">', '#type' => 'textfield', '#title' => t('City:'), '#default_value' => $new ? $team['city'] : $outreach['city'], '#suffix' => '</td></tr>');
$form['fields']['state'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'select', '#title' => t('State:'), '#options' => states_list(), '#default_value' => $new ? $team['state'] : $outreach['state'], '#chosen' => true, '#suffix' => '</td>');
$form['fields']['country'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#type' => 'select', '#title' => t('Country:'), '#options' => countries_list(), '#default_value' => $new ? $team['country'] : $outreach['country'], '#chosen' => true, '#suffix' => '</td></tr>');
$form['fields']['co_firstName'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t("Host Contact's First Name:"), '#default_value' => $new ? '' : $outreach['co_firstName'], '#placeholder' => 'Contact for this outreach', '#suffix' => '</td>');
$form['fields']['co_lastName'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t("Host Contact's Last Name:"), '#default_value' => $new ? '' : $outreach['co_lastName'], '#suffix' => '</tr>');
$form['fields']['co_phoneNumber'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t("Host Contact's Phone Number:"), '#default_value' => $new ? '' : $outreach['co_phoneNumber'], '#placeholder' => 'Format: XXXXXXXXXX', '#suffix' => '</td>');
$form['fields']['co_email'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t("Host Contact's Email:"), '#default_value' => $new ? '' : $outreach['co_email'], '#placeholder' => 'Email of outreach contact', '#suffix' => '</td></tr>');
$form['fields']['co_organization'] = array('#prefix' => '<tr><td colspan="6" style="text-align:center">', '#type' => 'textfield', '#title' => t("Host Organization:"), '#default_value' => $new ? '' : $outreach['co_organization'], '#placeholder' => 'Group participating with for this outreach', '#suffix' => '</td></tr>');
// allows a user to add dates to an outreach
if (empty($form_state['numRows'])) {
$form_state['numRows'] = 1;
}
$form['fields']['datesHeader'] = array('#markup' => '<tr><td colspan="6">');
$form['fields']['dates']['header'] = array('#markup' => '<div id="dates-div"><table>');
$date = date(DEFAULT_TIME_FORMAT, strtotime('today noon'));
for ($i = 0; $i < $form_state['numRows']; $i++) {
$form['fields']['dates']["openFieldOfStart-{$i}"] = array('#markup' => '<tr><td colspan="2" align="left" style="text-align:left">');
if (!empty($times)) {
$startTime = date(DEFAULT_TIME_FORMAT, dbDateSQL2PHP($times[$i]['startTime']));
}
$form['fields']['dates']["startTime-{$i}"] = array('#type' => 'date_popup', '#title' => t('Start Date:'), '#default_value' => !isset($startTime) ? $date : $startTime, '#date_format' => TIME_FORMAT, '#date_label_position' => 'within', '#date_increment' => 1, '#date_year_range' => '-20:+20', '#datepicker_options' => array(), '#states' => array('invisible' => array(':input[name="status"]' => array('value' => 'isIdea'))));
if (!$new) {
$form_state['fields']['dates']["TOID-{$i}"] = $times[$i]['TOID'];
}
$form['fields']['dates']["closeFieldOfStart-{$i}"] = array('#markup' => '</td>');
$form['fields']['dates']["openFieldOfEnd-{$i}"] = array('#markup' => '<td colspan="2" align="right" style="text-align:left">');
if (!empty($times)) {
$endTime = date(DEFAULT_TIME_FORMAT, dbDateSQL2PHP($times[$i]['endTime']));
}
$form['fields']['dates']["endTime-{$i}"] = array('#type' => 'date_popup', '#title' => t('End Date:'), '#default_value' => !isset($endTime) ? $date : $endTime, '#date_format' => TIME_FORMAT, '#date_label_position' => 'within', '#date_increment' => 1, '#date_year_range' => '-20:+20', '#datepicker_options' => array(), '#states' => array('invisible' => array(':input[name="status"]' => array('value' => 'isIdea'))));
$form['fields']['dates']["closeFieldOfEnd-{$i}"] = array('#markup' => '</td>');
if ($i == $form_state['numRows'] - 1) {
$form['fields']['dates']["addRowButton-{$i}"] = array('#prefix' => '<td colspan="1" style="text-align:center">', '#type' => 'submit', '#submit' => array('addDateRow'), '#value' => '+', '#limit_validation_errors' => array(), '#ajax' => array('callback' => 'modifyDateRows_callback', 'wrapper' => 'dates-div'), '#states' => array('invisible' => array(':input[name="status"]' => array('value' => 'isIdea'))), '#suffix' => '</td>');
}
if ($i == $form_state['numRows'] - 1) {
$form['fields']['dates']["removeRowButton-{$i}"] = array('#prefix' => '<td colspan="1" style="text-align:center">', '#type' => 'submit', '#submit' => array('removeDateRow'), '#value' => '-', '#limit_validation_errors' => array(), '#ajax' => array('callback' => 'modifyDateRows_callback', 'wrapper' => 'dates-div'), '#states' => array('invisible' => array(':input[name="status"]' => array('value' => 'isIdea'))), '#suffix' => '</td>');
}
$form['fields']['dates']["rowFooter-{$i}"] = array('#markup' => '</tr>');
}
// end of for loop
$form['fields']['dates']["divFooter-{$i}"] = array('#markup' => '</table></div></td>');
// allows the user to change the outreach visibility if the status is locked
if (!$new && $outreach["status"] == "locked") {
$isPublicOptions = array(0 => t('Private'), 1 => t('Public'));
$form['fields']['isPublic'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'radios', '#title' => t('Set Event Visibility'), '#options' => $isPublicOptions, '#default_value' => $new ? '1' : $outreach['isPublic'], '#suffix' => '</td></tr>');
}
$form['fields']['submit'] = array('#prefix' => '<tr><td colspan="6" style="text-align:right">', '#type' => 'submit', '#value' => t('Save'), '#sorted' => false, '#suffix' => '</td></tr>');
$form['fields']['finalFooter'] = array('#markup' => '</table>');
if (!$new && !(hasPermissionForTeam('editAnyOutreach', $TID) || isMyOutreach($params['OID']))) {
drupal_set_message("You don't have permission to edit this outreach.", 'error');
drupal_goto('viewOutreach', array('query' => array('OID' => $params['OID'])));
}
if (dbGetTeamsForUser($user->uid) == NULL) {
drupal_set_message("You don't have a team assigned.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
if (!dbIsUserApprovedForTeam($UID, $TID)) {
drupal_set_message("You aren't approved for this team.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
if (dbGetStatusForTeam($TID) == "0" || dbGetStatusForTeam($TID) == FALSE) {
drupal_set_message("This team isn't active/approved.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
return $form;
}
function hoursForm($form, &$form_state)
{
global $user;
$params = drupal_get_query_parameters();
$new = isset($form_state['new']) ? $form_state['new'] : true;
// checking that you are on a team
if (dbGetTeamsForUser($user->uid) == NULL) {
drupal_set_message("You don't have a team assigned.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
if (isset($params['HID'])) {
$new = false;
// editing an existing hours record
$form_state['new'] = $new;
// update form_state to reflect this
}
// setting values...
// creating a new record
if ($new) {
if (isset($form_state['OID'])) {
$OID = $form_state['OID'];
} else {
$OID = $params['OID'];
$form_state['OID'] = $OID;
}
$UID = $user->uid;
// editing an existing hours record
} else {
if (isset($form_state['HID'])) {
$HID = $form_state['HID'];
} else {
$HID = $params['HID'];
$form_state['HID'] = $HID;
}
$hour = dbGetHour($HID);
$UID = $hour['UID'];
$OID = $hour['OID'];
$form_state['OID'] = $OID;
if ($hour['isApproved']) {
drupal_set_message('Note that this hour will have to be re-approved once changes are made.', 'error');
}
}
// checking that you are accessing this page with a valid outreach
if (!isset($OID) && !isset($params['HID'])) {
drupal_set_message("No outreach selected.", 'error');
return;
}
// checking that you are associated with the team for which this outreach belongs to
$TID = dbGetTeamForOutreach($OID);
if (!isMyTeam($TID)) {
$teamName = dbGetTeamName($TID);
drupal_set_message("You are no longer on the team associated with this outreach ({$teamName}).", 'error');
return;
}
// checks if you have permission to edit hours
if (!(hasPermissionForTeam('editAnyHours', dbGetTeamForOutreach($OID)) || isMyOutreach($OID) || dbIsUserSignedUp($user->uid, $OID))) {
drupal_set_message("You don't have permission to log hours for this outreach.", 'error');
return;
}
if (isset($form_state['OID']) || isset($params['HID'])) {
$outreachData = dbGetOutreach($OID);
//begins form
$form['fields'] = array('#prefix' => '<div id="rows-div">', '#type' => 'fieldset', '#title' => t("Enter Hours For Outreach: \"{$outreachData['name']}\""), '#suffix' => '</div>');
$users = dbGetUsersListFromTeam($TID);
$users['0'] = '[none]';
if (hasPermissionForTeam('editAnyHours', $TID)) {
$form['fields']['UID'] = array('#prefix' => '<td>', '#type' => 'select', '#title' => t('User:'******'#options' => $users, '#attributes' => array('style' => 'width:200px'), '#default_value' => $UID, '#chosen' => true, '#suffix' => '</td>');
}
$form['fields']['tableHeader'] = array('#markup' => '<table>');
if (empty($form_state['numRows'])) {
$form_state['numRows'] = 1;
}
if (!hasPermissionForTeam('editAnyHours', $TID)) {
$signUpInfo = dbGetUserSignUpInfo($UID, $OID);
$numSignUps = count($signUpInfo);
$signUpCountLoop = 0;
$type = array();
foreach ($signUpInfo as $info) {
if ($numSignUps > 1 && $signUpCountLoop != $numSignUps - 1 && $form_state['numRows'] != $numSignUps) {
$form_state['numRows']++;
}
if ($info['type'] == 'prep') {
$type[$signUpCountLoop] = array('prep' => 'Preparation');
} else {
if ($info['type'] == 'atEvent') {
$type[$signUpCountLoop] = array('atEvent' => 'At Event');
} else {
if ($info['type'] == 'writeUp') {
$type[$signUpCountLoop] = array('writeUp' => 'Write-Up');
} else {
if ($info['type'] == 'followUp') {
$type[$signUpCountLoop] = array('followUp' => 'Follow Up');
} else {
if ($info['type'] == 'other') {
$type[$signUpCountLoop] = array('prep' => 'Other');
}
}
}
}
}
$signUpCountLoop++;
}
}
// looping through the rows
for ($i = 0; $i < $form_state['numRows']; $i++) {
$rowMarkUp = "<tr id=\"row-{$i}\"";
$rowMarkUp .= '>';
$form['fields']["rowHeader-{$i}"] = array('#markup' => $rowMarkUp);
$form['fields']["numberOfHours-{$i}"] = array('#prefix' => '<td colspan="1" style="text-align:left;width:20%;">', '#type' => 'textfield', '#title' => t('Number Of Hours:'), '#suffix' => '</td>', '#default_value' => $new ? '' : $hour['numberOfHours']);
if (hasPermissionForTeam('editAnyHours', $TID)) {
$types = array('prep' => 'Preparation', 'atEvent' => 'At Event', 'writeUp' => 'Write-Up', 'followUp' => 'Follow Up', 'other' => 'Other');
} else {
$types = $type[$i];
}
$form['fields']["type-{$i}"] = array('#prefix' => '<td colspan="1" style="text-align:left; width:20%;">', '#type' => 'radios', '#title' => t('Type:'), '#options' => $types, '#suffix' => '</td>', '#default_value' => $new ? '' : $hour['type']);
$form['fields']["description-{$i}"] = array('#prefix' => '<td colspan="3" style="text-align:left; width:50%;">', '#type' => 'textarea', '#title' => t('Description:'), '#suffix' => '</td>', '#default_value' => $new ? '' : $hour['description']);
if ($i == $form_state['numRows'] - 1) {
$form['fields']["addRowButton-{$i}"] = array('#prefix' => '<td colspan="1" style="width:5%">', '#type' => 'submit', '#submit' => array('addHourRow'), '#value' => '+', '#limit_validation_errors' => array(), '#ajax' => array('callback' => 'modifyHourRows_callback', 'wrapper' => 'rows-div'), '#suffix' => '</td>');
$form['fields']["removeRowButton-{$i}"] = array('#prefix' => '<td colspan="1" style="width:5%">', '#type' => 'submit', '#submit' => array('removeHourRow'), '#value' => '-', '#limit_validation_errors' => array(), '#ajax' => array('callback' => 'modifyHourRows_callback', 'wrapper' => 'rows-div'), '#suffix' => '</td>');
}
$form['fields']['rowFooter'] = array('#markup' => '</tr>');
// end of for loop
}
$form['fields']['submit'] = array('#prefix' => '<tr><td colspan="7" style="text-align:right">', '#type' => 'submit', '#value' => t('Submit'), '#suffix' => '</td></tr>');
$form['fields']['tableFooter'] = array('#markup' => '</table>');
}
return $form;
}
function profileForm($form, &$form_state)
{
global $user;
$params = drupal_get_query_parameters();
$new = true;
if (isset($params["UID"])) {
// editing a user other than the current one
$UID = $params['UID'];
} else {
// user is editing him/her own profile
$UID = $user->uid;
}
$data = dbGetUserProfile($UID);
if (empty($data)) {
// if the UID passed did not have any user data associated with it
} else {
$new = false;
// editing a user which already exists
}
// beginning the form
$form = array();
$form['fields'] = array('#type' => 'fieldset', '#title' => t('Edit: User Info'));
$form['fields']['tableHeader'] = array('#markup' => '<table>');
// checking permissions
$canEdit = false;
$sharedTeams = getSharedTeams($UID);
if (!empty($sharedTeams)) {
foreach ($sharedTeams as $TID) {
if (hasPermissionForTeam('manageTeamMembers', $TID)) {
$canEdit = true;
break;
}
}
}
// if the user is viewing his/her own profile, he/she should be able to edit it
if ($user->uid == $UID) {
$canEdit = true;
}
if (!$canEdit) {
drupal_set_message("You don't have permission to edit this user.", 'error');
return;
}
if (!$new) {
// if the profile is not new
$form['fields']['back'] = array('#prefix' => '<left>', '#limit_validation_errors' => array(), '#submit' => array('backToProfile'), '#type' => 'submit', '#value' => '⇦ Cancel Changes', '#attributes' => array('OnSubmit' => 'if(!confirm("Back?")){return false;}'), '#suffix' => '</left>');
}
$form['fields']['firstName'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t('First Name'), '#default_value' => $new ? '' : $data['firstName'], '#suffix' => '</td>');
$form['fields']['lastName'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t('Last Name'), '#default_value' => $new ? '' : $data['lastName'], '#suffix' => '</td></tr>');
$form['fields']['primaryEmail'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#markup' => "Primary Email <br>" . $user->mail, '#suffix' => '</td>');
if (!$new) {
$secondaryEmail = dbGetSecondaryEmailForUser($UID);
}
$form['fields']['secondaryEmail'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t('Secondary Email'), '#default_value' => $new ? '' : $secondaryEmail, '#suffix' => '</td></tr>');
$form['fields']['gender'] = array('#prefix' => '<tr><td colspan="2" style="text-align:center">', '#type' => 'radios', '#options' => array('Male' => 'Male', 'Female' => 'Female', 'Other' => 'Other'), '#title' => t('Gender'), '#default_value' => $new ? '' : $data['gender'], '#suffix' => '</td>');
$form['fields']['type'] = array('#prefix' => '<td colspan="2" style="text-align:center">', '#type' => 'radios', '#options' => array('student' => 'Student', 'mentor' => 'Mentor', 'alumni' => 'Alumni'), '#title' => t('Type'), '#default_value' => $new ? '' : $data['type'], '#suffix' => '</td>');
$form['fields']['grade'] = array('#prefix' => '<td colspan="2" style="text-align:center">', '#type' => 'select', '#options' => array('1' => '1st', '2' => '2nd', '3' => '3rd', '4' => '4th', '5' => '5th', '6' => '6th', '7' => '7th', '8' => '8th', '9' => '9th', '10' => '10th', '11' => '11th', '12' => '12th', '0' => 'N/A'), '#title' => t('Grade'), '#default_value' => $new ? '' : $data['grade'], '#chosen' => true, '#suffix' => '</td></tr>');
$form['fields']['phone'] = array('#prefix' => '<tr><td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t('Phone Number'), '#default_value' => $new ? '' : $data['phone'], '#placeholder' => 'Format: XXXXXXXXXX', '#suffix' => '</td>');
$form['fields']['position'] = array('#prefix' => '<td colspan="3" style="text-align:center">', '#type' => 'textfield', '#title' => t('Team Position'), '#default_value' => $new ? '' : $data['position'], '#placeholder' => "i.e. Chairman's Presenter", '#suffix' => '</td></tr>');
$form['fields']['bio'] = array('#prefix' => '<tr><td colspan="6">', '#type' => 'textarea', '#title' => t('Short Bio'), '#default_value' => $new ? '' : $data['bio'], '#suffix' => '</td></tr>');
// end of inputting info into the form
$form['fields']['tabling'] = array('#markup' => '</td></tr><tr>');
$form['fields']['tabling2'] = array('#markup' => '<td colspan="3"></td>');
$form['fields']['submit'] = array('#prefix' => '<td colspan="3" style="text-align:right">', '#type' => 'submit', '#value' => t('Save'), '#suffix' => '</td>');
$form['footer'] = array('#markup' => '</tr></table>');
return $form;
}
function viewOutreachEvent()
{
global $user;
$UID = $user->uid;
$params = drupal_get_query_parameters();
if (isset($params['OID']) && $params['OID'] > 0) {
$OID = $params['OID'];
$outreach = dbGetOutreach($OID);
if ($outreach == false) {
drupal_set_message('Invalid outreach event. Click <a href="?q=teamDashboard">here</a> to navigate back to events in Team Dashboard.', 'error');
return;
}
$TID = $outreach['TID'];
if (!isMyTeam($TID)) {
drupal_set_message('You do not have permission to access this page.', 'error');
return;
}
// if the outreach status is outreach and the event is over, then turn the status to write up
if ($outreach['status'] == "isOutreach") {
outreachToWriteUp($OID);
}
// determine if the user can physically sign up
$canSignUp = !dbIsOutreachOver($OID) && ($outreach['status'] == 'isOutreach' || $outreach['status'] == 'doingWriteUp');
$markup = '';
$markup .= '<div style="float:left; width:38%">';
$markup .= '<table style="margin:0px 0px 10px 0px;"><tr>';
$markup .= '<td style="padding:0px 14px 10px 14px;"><div align="left"><h2 style="margin:0px 0px 7px 0px;"><b>';
// display outreach name
$markup .= "{$outreach['name']}";
$markup .= '</b></h2></div></td></tr>';
$markup .= '<tr><td>';
$markup .= showOutreachStatusIcon($outreach['status']);
// displays the icon for a public outreach
$markup .= $outreach['isPublic'] ? '<span title="Public"><img class="eventPrivacyIcon" src="/images/icons/publicBlue.png"></span>' : '<span title="Private"><img class="eventPrivacyIcon" src="/images/icons/privateBlue.png"></span>';
// displays the icon for a cancelled outreach
$markup .= $outreach['cancelled'] ? '<span title="Event Cancelled"><img class="eventCancelledIcon" src="/images/icons/cancelledRed.png"' : '';
$markup .= '</td></tr></table>';
$markup .= '<table id="photoAndEdit"><tr><td style="padding:0px;">';
// cannot edit photo if user doesn't have the correct permissions
if (!isMyOutreach($OID) && !hasPermissionForTeam('editAnyOutreach', getCurrentTeam()['TID'])) {
$markup .= '<div align="right">';
$markup .= '<span title="Edit Photo"><button type="button" disabled><img class="editIcon" src="/images/icons/editThumbnailWhite.png"></button></span>';
$markup .= '</div>';
} else {
// edit photo if user has permissions
$markup .= '<div align="right">';
$markup .= '<a href= "?q=editThumbnail';
$markup .= '&OID=' . $OID . '&FID=' . $outreach['FID'] . '">';
$markup .= '<span title="Edit Photo"><button type="button"><img class="editIcon" src="/images/icons/editThumbnailWhite.png"></button></a></span>';
$markup .= '</div>';
}
$markup .= '</td></tr><tr><td style="padding:0px;">';
// default picture for outreach
if (!empty($outreach['FID'])) {
$FID = dbGetOutreachThumbnail($OID);
$url = generateURL($FID);
$markup .= '<div align="center"><img src="' . $url . '" style="max-width:150px; width:auto; height:auto; padding: 5px 0px 5px 0px">';
} else {
$markup .= '<div align="center"><img src="/images/defaultPics/team.png" style="max-width:200px; width:auto; height:auto; padding: 15px 0px 15px 0px">';
}
$markup .= '</div></td></tr></table></div>';
$markup .= '<div align="right">';
// if the status is write-up, then allow a user to submit a write up
if ($outreach['status'] == 'doingWriteUp' && !$outreach['isWriteUpSubmitted']) {
$markup .= '<a href="?q=writeupform&OID=' . $outreach['OID'] . '"><button>Write Up</button></a>';
} else {
if ($outreach['isWriteUpSubmitted'] && hasPermissionForTeam('approveIdeas', $TID) && $outreach['status'] == 'doingWriteUp') {
$markup .= '<a href="?q=writeupform&OID=' . $outreach['OID'] . '&approving"><button>Approve Write Up</button></a>';
}
}
// if the status is idea, then allow a user with permissions to approve or reject the idea
if ($outreach['status'] == 'isIdea' && hasPermissionForTeam('approveIdeas', $TID)) {
$markup .= '<a href="?q=approveIdea/' . $outreach['OID'] . '/' . $TID . '"><button>Approve</button></a>';
$markup .= '<a href="?q=rejectIdea/' . $outreach['OID'] . '/' . $TID . '"><button>Reject</button></a>';
}
// notifications button
if (!isMyOutreach($OID) && !hasPermissionForTeam('editAnyOutreach', getCurrentTeam()['TID'])) {
$markup .= '<button type="button" disabled>Notifications</button>';
} else {
$markup .= '<a href="?q=manageNotifications&OID=' . $outreach['OID'] . '"><button>Notifications</button></a>';
}
// manage sign-ups button
if (!dbIsOutreachCancelled($OID)) {
if (dbIsUserSignedUp($UID, $OID)) {
if (dbIsOutreachOver($OID)) {
$markup .= '<a href="?q=signUp&OID=' . $OID . '"><div class="help tooltip4"><button type="button" disabled>Edit Sign Up</button><span id="helptext"; class="helptext tooltiptext4">You cannot edit your sign up for this event because it is already over.</span></div></a>';
} else {
$markup .= '<a href="?q=signUp&OID=' . $OID . '"><div class="help tooltip4"><button type="button">Edit Sign Up</button><span id="helptext"; class="helptext tooltiptext4">Click here to edit your sign up for this event.</span></div></a>';
}
} else {
if (dbIsOutreachOver($OID) || $outreach['status'] == 'isIdea') {
$markup .= '<a href="?q=signUp&OID=' . $OID . '"><div class="help tooltip4"><button type="button" disabled>Sign Up</button><span id="helptext"; class="helptext tooltiptext4">You cannot sign up for this event because it is already over.</span></div></a>';
} else {
$markup .= '<a href="?q=signUp&OID=' . $OID . '"><div class="help tooltip4"><button type="button">Sign Up</button><span id="helptext"; class="helptext tooltiptext4">Click here to sign up for this event.</span></div></a>';
}
}
} else {
$markup .= '<a href="?q=signUp&OID=' . $OID . '"><div class="help tooltip4"><button type="button" disabled>Sign Up</button><span id="helptext"; class="helptext tooltiptext4">You cannot sign up for this event because it is cancelled.</span></div></a>';
}
// hours button
if (!dbIsOutreachCancelled($OID)) {
$markup .= '<a href= "?q=viewHours';
$markup .= '&OID=' . $OID . '">';
$markup .= '<button type="button" ';
$markup .= $outreach['status'] == 'isIdea' ? ' disabled' : '';
$markup .= '>Hours</button></a>';
} else {
// if outreach is cancelled
$markup .= '<button type="button" disabled';
$markup .= $outreach['status'] == 'isIdea' ? ' disabled' : '';
$markup .= '>Hours</button>';
}
// view media button
$markup .= '<a href="?q=viewMedia';
$markup .= '&OID=' . $OID . '">';
$markup .= '<button type="button"';
$markup .= $outreach['status'] == 'isIdea' ? ' disabled' : '';
$markup .= '>Media</button></a>';
// edit outreach button
if (!isMyOutreach($OID) && !hasPermissionForTeam('editAnyOutreach', getCurrentTeam()['TID'])) {
$markup .= '<button type="button" disabled><img class="editIcon" src="/images/icons/editWhite.png"></button>';
} else {
$markup .= '<a href= "?q=outreachForm';
$markup .= '&OID=' . $OID . '">';
$markup .= '<button type="button"><img class="editIcon" src="/images/icons/editWhite.png"></button></a>';
}
$markup .= '</div>';
$markup .= '<div style="width:60%; float:right; padding-left:10px">';
$hasPointOfContact = false;
if (!(empty($outreach['co_organization']) && empty($outreach['co_firstName']) && empty($outreach['co_email']) && empty($outreach['co_phoneNumber']))) {
$hasPointOfContact = true;
}
// account for cases where no info is present
if ($outreach['description'] == null) {
$outreach['description'] = '[none]';
}
if ($outreach['type'] == null || $outreach['type'] == '') {
$outreach['type'] = '[none]';
}
if ($outreach['status'] == null) {
$outreach['status'] = '[none]';
}
if ($outreach['co_organization'] == null) {
$outreach['co_organization'] = '[none]';
}
if ($outreach['co_position'] == null) {
$outreach['co_position'] = '[none]';
}
if ($outreach['co_firstName'] == null) {
$outreach['co_firstName'] = '[none]';
}
if ($outreach['co_email'] == null) {
$outreach['co_email'] = '[none]';
}
if ($outreach['co_phoneNumber'] == null) {
$outreach['co_phoneNumber'] = '[none]';
}
if ($outreach['city'] == null) {
$outreach['city'] = '[none]';
}
if ($outreach['state'] == null) {
$outreach['state'] = '[none]';
}
if ($outreach['address'] == null) {
$outreach['address'] = '[none]';
}
if ($outreach['country'] == null) {
$outreach['country'] = '[none]';
}
if ($outreach['totalAttendance'] == null) {
$outreach['totalAttendance'] = 0;
}
if ($outreach['testimonial'] == null) {
$outreach['testimonial'] = '[none]';
}
$team = dbGetTeam($outreach['TID']);
// begin displaying info body
$markup .= '<table id="miniViewTeam" style="margin:16px 0px 0px 0px"><tr><td><h3><b><u>General<u></b></h3></td></tr>';
$owner = dbGetOutreachOwner($OID);
$markup .= "<tr><td colspan='3'><b>Owner: </b>" . dbGetUserName($owner) . "</a></td>";
$markup .= "<td colspan='3'><b>Team: </b>{$team['number']}</td></tr>";
$markup .= '<tr><td colspan="3"><b>Tags: </b>';
$tags = dbGetTagsForOutreach($OID);
if (!empty($tags)) {
dpm($tags);
$first = true;
$length = count($tags);
$i = 1;
foreach ($tags as $OTID => $tagName) {
$markup .= '<a href="?q=outreach&tag=' . $OTID . '">' . $tagName . '</a>';
if ($i < $length) {
$markup .= ', ';
}
$i++;
}
// if there aren't any tags
} else {
$markup .= '[none]';
}
$markup .= '</td></tr>';
$times = dbGetTimesForOutreach($OID);
// display time if the outreach status isn't an idea
if ($outreach['status'] != 'isIdea') {
if (!empty($times)) {
foreach ($times as $time) {
$startTime = date(TIME_FORMAT, dbDateSQL2PHP($time['startTime']));
$endTime = date(TIME_FORMAT, dbDateSQL2PHP($time['endTime']));
$markup .= '<tr><td colspan="3"><b>Start Date: </b>' . $startTime . '</td>';
$markup .= '<td colspan="3"><b>End Date: </b>' . $endTime . '</td></tr>';
}
}
}
$markup .= '<tr><td colspan="5" style="word-break:break-word"><b>Description: </b>';
$markup .= wordwrap($outreach['description'], 70, "<br />\n");
$markup .= '</td></tr>';
// if the outreach has contact information
if ($hasPointOfContact) {
$markup .= '<tr><td><h3><b><u>Contact Info<u></b></h3></td></tr>';
$markup .= '<tr><td colspan="3"><b>Host Organization: </b>';
$markup .= strip_tags($outreach['co_organization'], ALLOWED_TAGS) . '</td>';
$markup .= '<td colspan="3"><b>Contact Name: </b>';
$markup .= strip_tags($outreach['co_firstName'] . ' ' . $outreach['co_lastName'], ALLOWED_TAGS) . '</td></tr>';
$markup .= '<tr><td colspan="3"><b>Contact Email: </b>' . strip_tags($outreach['co_email'], ALLOWED_TAGS) . '</td>';
$phoneNumber = dbFormatPhoneNumber($outreach['co_phoneNumber']);
$markup .= '<td colspan="3"><b>Contact Number: </b>' . $phoneNumber . '</td></tr>';
$markup .= '<tr><td colspan="6"><b>Address: </b>' . strip_tags($outreach['address'], ALLOWED_TAGS) . ', ' . strip_tags($outreach['city'], ALLOWED_TAGS) . ', ' . strip_tags($outreach['state'], ALLOWED_TAGS) . '</td></tr>';
$markup .= '</tr>';
} else {
$markup .= '<tr><td><h3><b><u>Contact Info<u></b></h3></td></tr>';
$markup .= '<tr><td colspan="6"><b>Address: </b>' . strip_tags($outreach['address'], ALLOWED_TAGS) . ', ' . strip_tags($outreach['city'], ALLOWED_TAGS) . ', ' . strip_tags($outreach['state'], ALLOWED_TAGS) . '</td></tr>';
$markup .= '</tr>';
}
$markup .= '<tr><td><h3><b><u>Statistics<u></b></h3></td></tr>';
$markup .= '<tr>';
if ($outreach['status'] != 'isIdea') {
$numPpl = dbGetNumPplSignedUpForEvent($OID);
$markup .= '<td colspan="3"><b>';
// only show the link if people are signed up
if ($numPpl != 0) {
$markup .= '<a href="?q=outreachList&OID=' . $OID . '"target="_blank">';
}
$markup .= 'People Signed Up: </b>';
// end the link
if ($numPpl != 0) {
$markup .= '</a>';
}
$markup .= $numPpl . '</td>';
// view total hours for the outreach
$markup .= '<td colspan="3"><b>Total Hours: </b><a href="?q=viewHours&OID=' . $OID . '">' . dbGetHoursForOutreach($OID) . '</a></td></tr>';
//if the outreach status is idea
} else {
$markup .= '<td colspan="3">';
$markup .= '<b>People Signed Up: </b>';
$markup .= 'None';
$markup .= '</td></tr>';
}
$markup .= '</table></div>';
// if the outreach has an approved write-up
if ($outreach['isWriteUpApproved'] && $outreach['status'] == 'locked') {
$writeUp = empty($outreach["writeUp"]) ? '[None]' : $outreach["writeUp"];
$totalAttendance = empty($outreach["totalAttendance"]) ? '[Not Filled Out]' : $outreach["totalAttendance"];
$testimonial = empty($outreach["testimonial"]) ? '[None]' : $outreach["testimonial"];
$markup .= '<div style="float:left; width:38%;"><table id="miniViewTeam" style="margin:16px 0px 0px 0px"><tr><td><h3><b><u>Write Up<u></b></h3></td>';
$markup .= '<td><a href="?q=writeupform&OID=' . $outreach['OID'] . '&approved"><button> View</button></a></td></tr>';
$markup .= '<tr><td><b>Write Up:</b></td></tr>';
$markup .= '<tr><td>' . $writeUp . '</td></tr>';
$markup .= '<tr><td><b>Total Attendance:</b></td></tr>';
$markup .= '<tr><td>' . $totalAttendance . '</td></tr>';
$markup .= '<tr><td><b>Testimonials/Comments:</b></td></tr>';
$markup .= '<tr><td>' . $testimonial . '</td></tr>';
$markup .= '</table></div>';
}
$retArray = array();
$retArray['#markup'] = $markup;
return $retArray;
} else {
drupal_set_message('Invalid outreach event. Click <a href="?q=teamDashboard">here</a> to navigate back to events in Team Dashboard.', 'error');
}
}
function oldHoursForm($form, &$form_state)
{
global $user;
$params = drupal_get_query_parameters();
// initialization of values
if (!isset($form_state['TID'])) {
// first time on form
$TID = $form_state['TID'] = $params['TID'];
// set to url params
$offset = dbGetOffsetHours($TID);
if ($offset != null) {
$new = $form_state['new'] = false;
$form_state['numRows'] = count($offset);
$form_state['initialNumTimes'] = count($offset);
// record how many were there before (in case user deletes one)
} else {
$new = $form_state['new'] = true;
}
} else {
// not first time on form
$TID = $form_state['TID'];
$offset = dbGetOffsetHours($TID);
}
// checking that user is on a team
if (dbGetTeamsForUser($user->uid) == false) {
drupal_set_message("You don't have a team assigned.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
// checking that you are accessing this page with a team in mind
if (!isset($TID)) {
// if $TID is still null
drupal_set_message("No team selected.", 'error');
return;
}
// checking to make sure you have permission to actually edit the offset hours
if (!isMyTeam($TID) || !hasPermissionForTeam('editTeam', $TID)) {
drupal_set_message("You don't have permission to edit the 'old hours' for this team.", 'error');
return;
}
// beginning the form itself
$form['fields'] = array('#prefix' => '<div id="oldHourRows-div">', '#type' => 'fieldset', '#title' => t('Enter Old Hours For Team: ' . dbGetTeamName($TID)), '#suffix' => '</div>');
if (!$new) {
// if user wants to cancel any changes they made
$form['fields']['back'] = array('#prefix' => '<left>', '#limit_validation_errors' => array(), '#submit' => array('backToTeam'), '#type' => 'submit', '#value' => '⇦ Cancel Changes', '#attributes' => array('OnSubmit' => 'if(!confirm("Back?")){return false;}'), '#suffix' => '</left>');
}
$form['fields']['tableHeader'] = array('#markup' => '<table>');
if (empty($form_state['numRows'])) {
$form_state['numRows'] = 1;
}
for ($i = 0; $i < $form_state['numRows']; $i++) {
$rowMarkUp = "<tr id=\"row-{$i}\"";
$rowMarkUp .= '>';
$form['fields']["rowHeader-{$i}"] = array('#markup' => $rowMarkUp);
$form['fields']["hours-{$i}"] = array('#prefix' => '<td style="text-align:left;">', '#type' => 'textfield', '#title' => t('Number Of Hours:'), '#suffix' => '</td>', '#default_value' => $new ? '' : $offset[$i]['numberOfHours']);
if (!$new) {
$form_state['fields']["HTID-{$i}"] = $offset[$i]['HTID'];
}
$form['fields']["year-{$i}"] = array('#prefix' => '<td style="text-align:left;">', '#type' => 'textfield', '#title' => t('Year:'), '#suffix' => '</td>', '#default_value' => $new ? '' : $offset[$i]['year']);
if ($i == $form_state['numRows'] - 1) {
$form['fields']["addRowButton-{$i}"] = array('#prefix' => '<td>', '#type' => 'submit', '#submit' => array('addOldHourRow'), '#value' => '+', '#limit_validation_errors' => array(), '#ajax' => array('callback' => 'modifyOldHourRows_callback', 'wrapper' => 'oldHourRows-div'), '#suffix' => '</td>');
}
if ($i == $form_state['numRows'] - 1) {
$form['fields']["removeRowButton-{$i}"] = array('#prefix' => '<td>', '#type' => 'submit', '#submit' => array('removeOldHourRow'), '#value' => '-', '#limit_validation_errors' => array(), '#ajax' => array('callback' => 'modifyOldHourRows_callback', 'wrapper' => 'oldHourRows-div'), '#suffix' => '</td>');
}
$form['fields']['rowFooter'] = array('#markup' => '</tr>');
}
// end of for loop
$form['fields']['submit'] = array('#prefix' => '<tr><td colspan="4" style="text-align:right">', '#type' => 'submit', '#value' => t('Submit'), '#suffix' => '</td></tr>');
$form['fields']['tableFooter'] = array('#markup' => '</table>');
return $form;
}
function viewUser()
{
global $user;
$currentUID = $user->uid;
$params = drupal_get_query_parameters();
// checks that there is a user
if (isset($params["UID"])) {
$UID = $params["UID"];
} else {
drupal_set_message('No user specified.', 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
// checks that the user being viewed shares a team with the user currently viewing
if (!($UID == $currentUID || isOnMyTeam($UID))) {
drupal_set_message("You can't view this profile.", 'error');
drupal_goto($_SERVER['HTTP_REFERER']);
}
$profile = dbGetUserProfile($UID);
$canEdit = false;
$sharedTeams = getSharedTeams($UID);
if (!empty($sharedTeams)) {
foreach ($sharedTeams as $TID) {
if (hasPermissionForTeam('manageTeamMembers', $TID)) {
$canEdit = true;
break;
}
}
}
if ($user->uid == $UID) {
$canEdit = true;
}
$markup = '';
// create name header and table
$markup .= '<div style="float:left; width:28%">';
$markup .= '<table style="margin:0px 0px 10px 0px;"><tr>';
$markup .= '<td style="padding:0px 14px 10px 14px;"><div align="left"><h2 style="margin:0px 0px 7px 0px;"><b>';
$markup .= $profile['firstName'] . ' ' . $profile['lastName'];
$markup .= '</b></h2></div></td></tr></table>';
$markup .= '<table id="photoAndEdit"><tr><td style="padding:0px;">';
// if the profile belongs to the currently logged in user, the picture should be editable
if ($canEdit) {
$markup .= '<div align="right">';
$markup .= '<a href= "?q=editThumbnail';
$markup .= '&UID=' . $UID . '&FID=' . $profile['FID'] . '">';
$markup .= '<span title="Edit Photo"><button type="button"><img class="editIcon" src="/images/icons/editThumbnailWhite.png"></button></a></span>';
$markup .= '</div>';
}
$markup .= '</td></tr><tr><td style="padding:0px;">';
// if user has picture, display picture
if (!empty($profile['FID'])) {
$url = generateURL($profile['FID']);
$markup .= '<div align="center"><img src="' . $url . '" style="max-width:150px; width:auto; height:auto; padding: 5px 0px 5px 0px">';
// default picture if user does not have a picture
} else {
$markup .= '<div align="center"><img src="/images/defaultPics/user.png" style="max-width:200px; width:auto; height:auto; padding: 15px 0px 15px 0px">';
}
$markup .= '</div></td></tr></table></div>';
$markup .= '<div align="right">';
// if user has permissions or owns the profile, edit info
if ($canEdit) {
$markup .= '<a href= "?q=profileForm';
$markup .= '&UID=' . $UID . '">';
$markup .= '<span title="Edit Profile"><button type="button"><img class="editIcon" src="/images/icons/editWhite.png"></button></a></span>';
}
// if the user wants to change their own password - no one else can access this feature on someone's profile
if ($UID == $currentUID) {
$markup .= '<a href="?q=user/' . $UID . '/edit"';
$markup .= '<span title="Change Password"><button type="button"><img class="keyIcon" src="/images/icons/keyWhite.png"></button></a></span>';
}
// users are only allowed to delete their own profiles
if ($UID == $currentUID) {
$markup .= '<span title="Delete User"><a href="?q=deleteUser&UID=' . $UID . '"><button type="button"><img class="trashIcon" src="/images/icons/trashWhite.png"></button></a></span>';
}
$markup .= '</div>';
// begin displaying info portion
$markup .= '<div style="width:70%; float:right; padding-left:10px">';
$markup .= '<table id="miniViewTeam" style="margin:16px 0px 0px 0px"><tr><td><b>Role: </b>' . ucfirst($profile['type']) . '</td>';
$markup .= '<td><b>Position: </b> ' . strip_tags($profile['position']) . '</td>';
if ($profile['grade'] == '0') {
$markup .= '<tr><td><b>Grade: </b> N/A</td>';
} else {
$markup .= '<tr><td><b>Grade: </b> ' . $profile['grade'] . '</td>';
}
$markup .= '<td><b>Gender: </b> ' . $profile['gender'] . '</td></tr>';
$email = dbGetUserPrimaryEmail($UID);
$markup .= '<tr><td><b>Email: </b> <a href="mailto:' . $email . '" target="_blank">';
$markup .= $email . '</a>';
$secondaryEmail = dbGetSecondaryEmailForUser($UID);
if ($secondaryEmail) {
$markup .= "<br>(" . '<a href="mailto:' . $secondaryEmail . '" target="_blank">' . $secondaryEmail . '</a>' . ')';
}
$phoneNumber = dbFormatPhoneNumber($profile['phone']);
$markup .= '</td><td><b>Phone: </b> ' . $phoneNumber . '</td></tr>';
// displays teams the user is on
$teamNumbers = '';
$first = true;
// used to put commas in the right places
$teams = dbGetTeamsForUser($UID);
foreach ($teams as $team) {
if ($first) {
$teamNumbers = '<a href="?q=viewTeam&TID=' . $team['TID'] . '">' . $team['number'] . '</a>';
$first = false;
} else {
$teamNumbers = $teamNumbers . ', <a href="?q=viewTeam&TID=' . $team['TID'] . '">' . $team['number'] . '</a>';
}
}
if (count($teams) > 1) {
$teamLabel = 'Teams';
} else {
$teamLabel = 'Team';
}
if ($UID == $currentUID) {
$markup .= '<tr><td><a href="?q=manageUserTeams"><b>' . $teamLabel . ':</b></a> ' . $teamNumbers . '</td>';
} else {
$markup .= '<tr><td><b>' . $teamLabel . ':</b> ' . $teamNumbers . '</td>';
}
// displays user hours
$numberOfHours = dbGetUserHours($UID);
if ($numberOfHours != 0) {
$markup .= "<td><a href=\"?q=viewHours&UID={$UID}\"><b>Number of Hours:</b></a> {$numberOfHours}</td>";
} else {
$markup .= "<td><b>Number of Hours:</b> No Hours!</td>";
}
// displays user bio
$markup .= '</table><table id="miniViewTeam" style="margin:16px 0px 0px 0px"><tr><td><b>Bio: </b>';
$markup .= wordwrap($profile['bio'], 92, "<br />\n") . '</td></tr>';
$markup .= '</table></div>';
return array("#markup" => $markup);
}
function viewOutreachIdeas()
{
global $user;
if (dbGetTeamsForUser($user->uid) == NULL) {
drupal_set_message("You don't have a team assigned.", 'error');
$TID = 0;
}
if (isset($params["UID"])) {
$UID = $params["UID"];
} else {
$UID = $user->uid;
}
$currentTeam = getCurrentTeam();
$TID = $currentTeam['TID'];
$teamNumber = $currentTeam['number'];
if (isset($params['OID']) && $params['OID'] > 0) {
$OID = $params['OID'];
$outreach = dbGetOutreach($OID);
}
// if the user has more than one team
if (count(dbGetTeamsForUser($UID)) > 1) {
$markup = '<div class="help tooltip2">';
$markup .= '<h2>My Outreach Ideas</h2>';
$markup .= '<span id="helptext"; class="helptext tooltiptext2">';
$markup .= 'These are your ideas that have not yet been approved to become outreaches.';
$markup .= '</span></div>';
// allows a user to see the outreach ideas of the team currently being used
$outreaches = dbGetOutreachIdeas($user->uid, PREVIEW_NUMBER);
// begin table
$markup .= '<table class="infoTable"><tr><th colspan="3">Name</th>';
$markup .= '<th colspan="3">Log Date</th>';
$markup .= '<th colspan="2">Team</th>';
$markup .= '<th colspan="2"></th>';
$markup .= "</tr>";
// of the user has outreach ideas
if (!empty($outreaches)) {
foreach ($outreaches as $outreach) {
$TID = $outreach['TID'];
$team = dbGetTeam($outreach['TID']);
$rawDate = $outreach['logDate'];
$rawDate = dbDateSQL2PHP($rawDate);
$logDate = date(TIME_FORMAT, $rawDate);
$markup .= "<tr>";
$markup .= '<td colspan="3">' . '<a href="?q=viewOutreach&OID=' . $outreach['OID'] . '">' . chopString($outreach["name"], 20) . '</a>' . "</td>";
$markup .= '<td colspan="3">' . $logDate . "</td>";
$markup .= "<td colspan='2'>{$team['number']}</td>";
// approve and reject idea buttons if the user has permission
if (hasPermissionForTeam('approveIdeas', $TID)) {
$markup .= "<td colspan=\"2\"><a href=\"?q=approveIdea/{$outreach['OID']}/{$TID}\"><button>Approve</button></a>";
$markup .= "<a href=\"?q=rejectIdea/{$outreach['OID']}/{$TID}\"><button>Reject</button></a></td>";
} else {
$markup .= '<td></td><td></td>';
}
$markup .= "</tr>";
}
} else {
// display none if the user doesnt have any outreaches
$markup .= "<tr>";
$markup .= '<td style="text-align:center" colspan="10"><em>[None]</em></td>';
$markup .= "</tr>";
}
$markup .= "</table>";
} else {
// if the user only has one team
$markup = '<div class="help tooltip2">';
$markup .= '<h2>My Outreach Ideas</h2>';
$markup .= '<span id="helptext"; class="helptext tooltiptext2">';
$markup .= 'These are your ideas that have not yet been approved to become outreaches.';
$markup .= '</span></div>';
// allows a user to see the outreach ideas of the team currently being used
$outreaches = dbGetOutreachIdeas($user->uid, PREVIEW_NUMBER);
$markup .= '<table class="infoTable"><tr><th>Name</th>';
$markup .= "<th>Log Date</th>";
$markup .= "<th></th>";
$markup .= "<th></th>";
$markup .= "</tr>";
// if the user has outreach ideas
if (!empty($outreaches)) {
foreach ($outreaches as $outreach) {
$TID = $outreach['TID'];
$rawDate = $outreach['logDate'];
$rawDate = dbDateSQL2PHP($rawDate);
$logDate = date(TIME_FORMAT, $rawDate);
$markup .= "<tr>";
$markup .= "<td>" . '<a href="?q=viewOutreach&OID=' . $outreach['OID'] . '">' . chopString($outreach["name"], 20) . '</a>' . "</td>";
$markup .= "<td>" . $logDate . "</td>";
if (hasPermissionForTeam('approveIdeas', $TID)) {
$markup .= "<td><a href=\"?q=approveIdea/{$outreach['OID']}/{$TID}\"><button>Approve</button></a></td>";
$markup .= "<td><a href=\"?q=rejectIdea/{$outreach['OID']}/{$TID}\"><button>Reject</button></a></td>";
} else {
$markup .= '<td></td><td></td>';
}
$markup .= "</tr>";
}
} else {
// display none if the user doesn't have any outreach ideas
$markup .= "<tr>";
$markup .= '<td style="text-align:center" colspan="10"><em>[None]</em></td>';
$markup .= "</tr>";
}
$markup .= "</table>";
}
$retArray = array();
$retArray['#markup'] = $markup;
return $retArray;
}
