function viewOutreach()
{
global $user;
$UID = $user->uid;
$params = drupal_get_query_parameters();
$markup = "<script src=\"https://cdnjs.cloudflare.com/ajax/libs/jquery/3.0.0-beta1/jquery.js\"></script>";
$markup .= '<script src="numberCounting.js"></script>';
$markup .= '<h1>Outreach</h1><br>';
// if doing a custom search
if (isset($params['query']) && $params['query'] == 'search') {
$sql = generateSearchSQL($_SESSION['searchParams'], $_SESSION['proxyFields']);
$outreaches = dbSearchOutreach($sql, $_SESSION['proxyFields']);
$header = '<h2>Custom Search Results (';
$header .= empty($outreaches) ? '0' : count($outreaches);
$header .= ' matches)</h2>';
} else {
if (isset($params['tag'])) {
$_SESSION['searchParams'] = array('tags' => array($params['tag']));
$_SESSION['proxyFields'] = array();
$sql = generateSearchSQL($_SESSION['searchParams'], $_SESSION['proxyFields']);
$outreaches = dbSearchOutreach($sql, $_SESSION['proxyFields']);
$header = '<h2>Outreaches Tagged "' . dbGetTagName($params['tag']) . '"</h2>';
} else {
if (isset($params['owned'])) {
$outreaches = dbGetOwnedOutreachForUser($UID);
$header = '<h2>Outreaches I Own</h2>';
} else {
if (isset($params['signedUp'])) {
$outreaches = dbGetOutreachForUser($UID);
$header = '<h2>Outreaches I Am Signed Up For</h2>';
} else {
if (isset($params['allTeamOutreach'])) {
$TID = getCurrentTeam()['TID'];
$_SESSION['searchParams'] = array('TID' => array('value' => $TID, 'matchType' => 'exact'));
$_SESSION['proxyFields'] = array(':TID' => $TID);
$sql = generateSearchSQL($_SESSION['searchParams'], $_SESSION['proxyFields']);
$outreaches = dbSearchOutreach($sql, $_SESSION['proxyFields']);
$teamName = dbGetTeamName($TID);
$header = "<h2>All Outreach for {$teamName}</h2>";
} else {
$_SESSION['searchParams'] = array();
$_SESSION['proxyFields'] = array();
$header = "<h2>No Search Selected</h2>";
}
}
}
}
}
if (isset($_SESSION['searchParams']['teams']) && count($_SESSION['searchParams']['teams']) > 1) {
$multipleTeamsInResult = true;
} else {
$multipleTeamsInResult = false;
}
$markup .= $header;
// set $outreaches to an array rather than false (so that later functions don't have errors)
if (empty($outreaches)) {
$outreaches = array();
}
$totalFilterOutreaches = count($outreaches);
$totalFilterHours = 0;
foreach ($outreaches as &$outreach) {
$outreach['hours'] = dbGetHoursForOutreach($outreach['OID']);
$totalFilterHours += $outreach['hours'];
}
unset($outreach);
$sortParam = isset($params["sort"]) ? $params['sort'] : 'name';
$isAscending = isset($params['isAscending']) ? true : false;
orderByValue($outreaches, $sortParam, $isAscending);
// custom function (see helperFunctions.inc)
$markup .= '<table style="margin:0px">';
$markup .= '<tr><td style="padding:0px; text-align:left"><b>Outreaches with Current Filters: </b><span class="countUp">' . $totalFilterOutreaches . '</span></td>';
$markup .= '<td style="padding:0px; text-align:right" align="right"><b>Hours with Current Filters: </b><span class="countUp">' . $totalFilterHours . '</span></td></tr>';
$markup .= '<tr><td style="padding:0px" align="left">Sort By: ';
// remove special params (since they should not be added every time)
unset($params['isAscending']);
unset($params['sort']);
$markup .= sortHeader($sortParam, $params, $isAscending, 'Name', 'name', 'outreach') . ' | ';
$markup .= sortHeader($sortParam, $params, $isAscending, 'Status', 'status', 'outreach') . ' | ';
$markup .= sortHeader($sortParam, $params, $isAscending, 'Hours', 'hours', 'outreach') . ' | ';
$markup .= sortHeader($sortParam, $params, $isAscending, 'Event Date', 'eventDate', 'outreach');
$markup .= '</td><td style="padding:0px; text-align:right">';
if (!isset($params['owned'])) {
$markup .= '<a href="?q=outreach&owned"><div class="help tooltip4"><button>Owned</button><span id="helptext"; class="helptext tooltiptext4">Click here to sort by outreach you own.</span></div></a>';
} else {
$markup .= '<a href="?q=outreach&allTeamOutreach"><button>All Team Outreach</button></a>';
}
if (!isset($params['signedUp'])) {
$markup .= '<a href="?q=outreach&signedUp"><div class="help tooltip3"><button>Signed Up</button><span id="helptext"; class="helptext tooltiptext3">Click here to sort by outreach you are signed up for.</span></div></a>';
} else {
$markup .= '<a href="?q=outreach&allTeamOutreach"><button>All Team Outreach</button></a>';
}
$markup .= '</td></tr></table>';
$markup .= '<table class="infoTable" style="margin:0px"><tr><th colspan="2">Status</th>';
if ($multipleTeamsInResult) {
$markup .= '<th colspan="2">Team</th>';
}
$markup .= '<th colspan="4">Name</th>';
$markup .= '<th colspan="2">Hours</th>';
$markup .= '<th colspan="2">Event Date</th>';
if (empty($outreaches)) {
$markup .= '<tr><td colspan="11">No outreach found! Click <a href="?q=outreachForm">here</a> to create new outreach!</td></tr></table>';
return array('#markup' => $markup);
}
foreach ($outreaches as $outreach) {
$OID = $outreach['OID'];
$hours = dbGetHoursForOutreach($OID);
$status;
switch ($outreach['status']) {
case 'isOutreach':
$status = '<span title="Outreach Event"><img class="eventIndicatorIcon" src="/images/icons/outreachBlue.png"></span>';
break;
case 'isIdea':
$status = '<span title="Idea"><img class="eventIndicatorIcon" src="/images/icons/ideaBlue.png"></span>';
break;
case 'doingWriteUp':
$status = '<span title="Write Up"><img class="eventIndicatorIcon" src="/images/icons/writeUpBlue.png"></span>
';
break;
case 'locked':
$status = '<span title="Locked Event"><img class="eventIndicatorIcon" src="/images/icons/lockedBlue.png"></span>';
break;
default:
drupal_set_message('Invalid outreach data.');
break;
}
$markup .= '<tr><td colspan="2" style="padding: 0px 0px 0px 14px;">';
$markup .= showOutreachStatusIcon($outreach['status']) . '</td>';
if ($multipleTeamsInResult) {
$markup .= '<td colspan="2"><a href="?q=viewTeam&TID=' . $outreach['TID'] . '">' . dbGetTeamNumber($outreach['TID']) . '</a></td>';
}
$markup .= '<td colspan="4"><a href="?q=viewOutreach&OID=' . $OID . '">' . chopString($outreach['name'], 15) . '</a></td>';
$markup .= '<td colspan="2">' . $hours . '</td>';
if (dbGetEarliestTimeForOutreach($OID) != false) {
$markup .= '<td colspan="2">' . date(TIME_FORMAT, dbDateSQL2PHP(dbGetEarliestTimeForOutreach($OID))) . '</td>';
} else {
$markup .= '<td colspan="2">[none]</td>';
}
}
$markup .= '</table>';
return array('#markup' => $markup);
}
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);
}
