function writeVolEventRow(&$event)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
$lEventID = $event->lKeyID;
echoT('
<tr>
<td class="enpRpt" style="text-align: center;">' . strLinkView_VolEvent($lEventID, 'View event', true) . ' ' . str_pad($lEventID, 5, '0', STR_PAD_LEFT) . '
</td>
<td class="enpRpt" style="width: 150pt;">' . htmlspecialchars($event->strEventName) . '
</td>
<td class="enpRpt">' . date($genumDateFormat . ' (D)', $event->dteEventStart) . '
</td>
<td class="enpRpt">' . date($genumDateFormat . ' (D)', $event->dteEventEnd) . '
</td>
<td class="enpRpt" style="text-align: center;">' . $event->lNumShifts . '
</td>
<td class="enpRpt" style="text-align: center;">' . $event->lTotVolsNeeded . '
</td>
<td class="enpRpt" style="text-align: center;">' . $event->lTotVolsAssigned . ' ' . strLinkView_VolEventAssignments($lEventID, 'View volunteer assignments for this event', true) . '
</td>
</tr>');
}
function strShiftJobCodesDetailsViaMonth($strMoYr, $sRpt, $bAllJobCodes)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
$strOut = '
<table class="enpRptC" style="width: 600pt;">
<tr>
<td colspan="6" class="enpRptTitle">
Job Code Details for Scheduled Shifts: ' . $strMoYr . '
</td>
</tr>
<tr>
<td class="enpRptLabel">
Event
</td>
<td class="enpRptLabel">
Shift/Date
</td>
<td class="enpRptLabel">
Volunteer
</td>
<td class="enpRptLabel">
Job Code
</td>
<td class="enpRptLabel">
Hours
</td>
</tr>
';
if ($bAllJobCodes) {
$strWhereJC = '';
} else {
$strWhereJC = ' AND vs_lJobCode=' . $sRpt->lJobCodeID . ' ';
}
$sqlStr = 'SELECT vs_lJobCode, ved_dteEvent, vsa_dHoursWorked, vsa_lVolID, vem_lKeyID, ved_lKeyID,
jc.lgen_strListItem AS strJobCode,
vem_strEventName, vs_strShiftName,
pe_strFName, pe_strLName
FROM vol_events_dates
INNER JOIN vol_events_dates_shifts ON vs_lEventDateID = ved_lKeyID
INNER JOIN vol_events_dates_shifts_assign ON vsa_lEventDateShiftID = vs_lKeyID
INNER JOIN vol_events ON ved_lVolEventID = vem_lKeyID
INNER JOIN volunteers ON vol_lKeyID = vsa_lVolID
INNER JOIN people_names ON vol_lPeopleID = pe_lKeyID
LEFT JOIN lists_generic AS jc ON vs_lJobCode = jc.lgen_lKeyID
WHERE NOT vs_bRetired AND NOT vsa_bRetired
AND YEAR (ved_dteEvent)=' . $sRpt->lYear . '
AND MONTH(ved_dteEvent)=' . $sRpt->lMonth . '
AND vsa_dHoursWorked > 0
' . $strWhereJC . '
ORDER BY vem_strEventName, strJobCode, ved_dteEvent, pe_strLName, pe_strFName, pe_lKeyID;';
$query = $this->db->query($sqlStr);
$numRows = $query->num_rows();
$idx = 0;
$sngTotHrs = 0.0;
if ($numRows > 0) {
foreach ($query->result() as $row) {
$dteEvent = dteMySQLDate2Unix($row->ved_dteEvent);
$strJobCode = $row->strJobCode . '' == '' ? '(not set)' : htmlspecialchars($row->strJobCode);
$strOut .= '
<tr class="makeStripe">
<td class="enpRpt" style="width: 150pt;">' . strLinkView_VolEvent($row->vem_lKeyID, 'View event', true) . ' ' . htmlspecialchars($row->vem_strEventName) . '
</td>
<td class="enpRpt" style="width: 130pt;">' . strLinkView_VolEventDate($row->ved_lKeyID, 'View event date and shifts', true) . ' ' . htmlspecialchars($row->vs_strShiftName) . '<br> ' . date($genumDateFormat, $dteEvent) . '
</td>
<td class="enpRpt" style="width: 130pt;">' . strLinkView_Volunteer($row->vsa_lVolID, 'Volunteer Record', true) . ' ' . htmlspecialchars($row->pe_strLName . ', ' . $row->pe_strFName) . '
</td>
<td class="enpRpt" style="width: 100pt;">' . $strJobCode . '
</td>
<td class="enpRpt" style="width: 35pt; padding-right: 10px; text-align: right;">' . number_format($row->vsa_dHoursWorked, 2) . '
</td>
</tr>';
$sngTotHrs += $row->vsa_dHoursWorked;
}
}
$strOut .= '
<tr>
<td class="enpRpt" colspan="4"><b>
Total:</b>
</td>
<td class="enpRpt" style="width: 35pt; padding-right: 10px; text-align: right;"><b>' . number_format($sngTotHrs, 2) . '</b>
</td>
</tr>';
$strOut .= '</table>' . "\n";
return $strOut;
}
private function strVolScheduleRptHTML(&$query, $strLabel, $strSafeNameFL, $lVolID)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
$strOut = '<table class="enpRptC">
<tr>
<td class="enpRptTitle" colspan="7">' . $strLabel . ' Volunteer Schedule for ' . $strSafeNameFL . ' ' . strLinkView_Volunteer($lVolID, 'View volunteer record', true) . '
</td>
<tr>';
$strOut .= '
<tr>
<td class="enpRptLabel" style="vertical-align: bottom;">
Date
</td>
<td class="enpRptLabel" style="vertical-align: bottom;">
Event
</td>
<td class="enpRptLabel" style="vertical-align: bottom;">
Shift
</td>
<td class="enpRptLabel" style="vertical-align: bottom;">
Start
</td>
<td class="enpRptLabel" style="vertical-align: bottom;">
Duration
</td>
<td class="enpRptLabel" style="vertical-align: bottom;">
Hours Logged
</td>
<tr>';
foreach ($query->result() as $row) {
$lEventID = $row->ved_lVolEventID;
$lEdateID = $row->vs_lEventDateID;
$strOut .= '
<tr class="makeStripe">
<td class="enpRpt" style="text-align: center; width: 80pt;">' . date($genumDateFormat, dteMySQLDate2Unix($row->ved_dteEvent)) . '
</td>
<td class="enpRpt" style="text-align: left; width: 200pt;">' . strLinkView_VolEvent($lEventID, 'View Event', true) . htmlspecialchars($row->vem_strEventName) . '
</td>
<td class="enpRpt" style="text-align: left; width: 120pt;">' . strLinkView_VolEventDate($lEdateID, 'View shifts for this date', true) . htmlspecialchars($row->vs_strShiftName) . '
</td>
<td class="enpRpt" style="text-align: left; width: 50pt;">' . $row->dteStartTime . '
</td>
<td class="enpRpt" style="text-align: left; width: 100pt;">' . $row->strDuration . '
</td>
<td class="enpRpt" style="text-align: right; padding-right: 10px;; width: 30pt;">' . number_format($row->vsa_dHoursWorked, 2) . '
</td>
</tr>';
}
$strOut .= '</table>';
return $strOut;
}
<?php
echoT(strLinkSpecial_Export($strReportID, 'Export this report') . '<br><br>');
$lIndent = 15;
foreach ($events as $event) {
echoT('<font style="font-size: 12pt;"><b><u>' . htmlspecialchars($event->strEventName) . '</u></b></font> ' . strLinkView_VolEvent($event->lKeyID, 'View event', true) . '<br>');
echoT('<table>');
foreach ($event->dates as $oneDate) {
echoT('
<tr>
<td colspan="5" style="font-size: 12pt;font-variant:small-caps;">' . date('l, F jS, Y', $oneDate->dteEvent) . ' ' . strLinkView_VolEventDate($oneDate->lKeyID, 'View event date', true) . '
</td>
</tr>');
if ($oneDate->lNumShifts == 0) {
echoT('<tr>
<td style="width: ' . $lIndent . 'pt;"> </td>
<td colspan="4">
<i>No shifts</i>
</td>
</tr>');
} else {
foreach ($oneDate->shifts as $shift) {
echoT('<tr>
<td style="width: ' . $lIndent . 'pt;"> </td>
<td colspan="4" style="font-size: 10pt;">
Shift: <b>' . htmlspecialchars($shift->strShiftName) . '</b> <font style="font-size: 9pt;">(' . date('g:i A', $shift->dteEventStartTime) . ' / ' . $shift->enumDuration . ')</font>
</td>
</tr>');
if ($shift->lNumVols == 0) {
echoT('<tr>
<td style="width: ' . $lIndent . 'pt;"> </td>
public function volEventHTMLSummary($idx)
{
//-----------------------------------------------------------------------
// assumes user has called $clsEvent->loadEventsViaEID($lEventID);
//-----------------------------------------------------------------------
global $gdteNow, $genumDateFormat;
$clsVE = $this->events[$idx];
$lEventID = $clsVE->lKeyID;
$params = array('enumStyle' => 'terse');
$clsRpt = new generic_rpt($params);
$clsRpt->setEntrySummary();
return $clsRpt->openReport('', '') . $clsRpt->openRow(false) . $clsRpt->writeLabel('Event ID:') . $clsRpt->writeCell(strLinkView_VolEvent($lEventID, 'View event', true) . ' ' . str_pad($lEventID, 5, '0', STR_PAD_LEFT)) . $clsRpt->closeRow() . $clsRpt->openRow(false) . $clsRpt->writeLabel('Volunteer Event:') . $clsRpt->writeCell($clsVE->strEventName) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Start Date:') . $clsRpt->writeCell(date($genumDateFormat . ' (D)', $clsVE->dteEventStart)) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('End Date:') . $clsRpt->writeCell(date($genumDateFormat . ' (D)', $clsVE->dteEventEnd)) . $clsRpt->closeRow() . $clsRpt->closeReport('<br>');
}
function strVolHoursDetailReport(&$sRpt, $lStartRec, $lRecsPerPage)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
$this->hrsSumOpts($sRpt, $bUseYear, $lYear, $bUseMon, $lMon, $bUseVolID, $lVolID);
$strLimit = " LIMIT {$lStartRec}, {$lRecsPerPage} ";
$strTab = 'tmp_vol_hrs';
$this->buildPopHrsTmp($strTab, $lYear, $lMon, $lVolID);
$strWhere = '1';
$strTitle = 'Volunteer Details for ';
$strFail = 'There are no volunteer hours for ';
if ($bUseVolID) {
$cVol = new mvol();
$cVol->loadVolRecsViaVolID($lVolID, true);
$vRec =& $cVol->volRecs[0];
$strSafeName = $vRec->strSafeName;
$strTitle .= $strSafeName . ' ';
$strFail .= $strSafeName . ' ';
}
if ($bUseMon) {
$strMonth = strXlateMonth($lMon);
$strTitle .= $strMonth . ' ' . $lYear;
$strFail .= $strMonth . ' ' . $lYear;
} else {
$strTitle .= $lYear;
$strFail .= $lYear;
}
$sqlStr = "SELECT\n vsa_lKeyID, tmphr_dteVolActivity,\n tmphr_lVolID, vsa_dHoursWorked, vsa_lEventDateShiftID,\n lgen_strListItem,\n vs_strShiftName, vs_lEventDateID, vem_lKeyID, vem_strEventName,\n pe_strFName, pe_strLName\n\n FROM {$strTab}\n INNER JOIN vol_events_dates_shifts_assign ON vsa_lKeyID = tmphr_lEventAssignID\n INNER JOIN volunteers ON tmphr_lVolID = vol_lKeyID\n INNER JOIN people_names ON vol_lPeopleID = pe_lKeyID\n LEFT JOIN vol_events_dates_shifts ON vsa_lEventDateShiftID = vs_lKeyID\n LEFT JOIN vol_events_dates ON vs_lEventDateID = ved_lKeyID\n LEFT JOIN vol_events ON ved_lVolEventID = vem_lKeyID\n LEFT JOIN lists_generic ON vsa_lActivityID=lgen_lKeyID\n\n ORDER BY tmphr_dteVolActivity, vsa_lKeyID\n {$strLimit};";
$query = $this->db->query($sqlStr);
$lNumRows = $query->num_rows();
if ($lNumRows == 0) {
return '<br><i>' . $strFail . '.</i><br>';
}
$strOut = '
<table class="enpRptC">
<tr>
<td colspan="7" class="enpRptTitle">' . $strTitle . '
</td>
</tr>';
$strOut .= '
<tr>
<td class="enpRptLabel">
Date
</td>
<td class="enpRptLabel">
Vol ID
</td>
<td class="enpRptLabel">
Volunteer
</td>
<td class="enpRptLabel">
Event
</td>
<td class="enpRptLabel">
Shift/Activity
</td>
<td class="enpRptLabel">
Hours
</td>
</tr>';
foreach ($query->result() as $row) {
$lVolID = $row->tmphr_lVolID;
if (is_null($row->vsa_lEventDateShiftID)) {
$strEvent = '<i>(unscheduled)</i>';
$strActivity = strLinkEdit_VolUnschedHrs($lVolID, $row->vsa_lKeyID, 'Edit activity', true, '', 12) . ' ' . htmlspecialchars($row->lgen_strListItem);
} else {
$strEvent = strLinkView_VolEvent($row->vem_lKeyID, 'View event', true) . ' ' . htmlspecialchars($row->vem_strEventName);
$strActivity = strLinkView_VolEventDate($row->vs_lEventDateID, 'View event date/shifts', true) . ' ' . htmlspecialchars($row->vs_strShiftName);
}
$strOut .= '
<tr class="makeStripe">
<td class="enpRpt">' . date($genumDateFormat, dteMySQLDate2Unix($row->tmphr_dteVolActivity)) . '
</td>
<td class="enpRpt">' . str_pad($lVolID, 5, '0', STR_PAD_LEFT) . ' ' . strLinkView_Volunteer($lVolID, 'View volunteer record', true) . '
</td>
<td class="enpRpt">' . htmlspecialchars($row->pe_strLName . ', ' . $row->pe_strFName) . '
</td>
<td class="enpRpt">' . $strEvent . '
</td>
<td class="enpRpt">' . $strActivity . '
</td>
<td class="enpRpt" style="text-align: right; padding-right: 3px;">' . number_format($row->vsa_dHoursWorked, 2) . '
</td>
</tr>';
}
$strOut .= '</table><br>';
return $strOut;
}
$dteEvent = $edate->dteEvent;
$lDateID = $edate->lDateKeyID;
if ($dteEvent != $dteGroup) {
if ($dteGroup > 0) {
echoT('</ul>');
}
$dteGroup = $dteEvent;
echoT('
<li><b>' . date('l \\t\\h\\e jS \\o\\f F, Y', $edate->dteEvent) . '</b>
<ul style="
margin-left:-20px;
margin-right:0px;
list-style:none;
">');
}
echoT('<li>' . htmlspecialchars($edate->strEventName) . ' ' . strLinkView_VolEvent($edate->lVolEventID, 'View event', true) . '<ul style="list-style-type: none; margin-left:-20px; ">');
if ($edate->lNumShifts == 0) {
echoT('<li><i>No shifts associated with this event for this date</i><br><br></li></ul>');
} else {
foreach ($edate->shifts as $shift) {
echoT('<li>' . htmlspecialchars($shift->strShiftName) . ' (' . $shift->dteStartTime . ' / ' . $shift->enumDuration . ')' . strLinkView_VolEventDate($lDateID, 'View shifts', true) . '<br>Volunteers:<ul>');
if ($shift->lNumVols == 0) {
echoT('<li><i>No volunteers assigned</i><br><br></li>');
} else {
foreach ($shift->vols as $vol) {
$lVolID = $vol->lVolID;
echoT('<li>' . htmlspecialchars($vol->strFName . ' ' . $vol->strLName) . strLinkView_Volunteer($lVolID, 'View volunteer record', true) . '</li>');
}
}
echoT('</ul><br></li>');
}
