private function strVolHoursSumReport(&$sRpt, $lStartRec, $lRecsPerPage) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $this->hrsSumOpts($sRpt, $bUseYear, $lYear, $bUseMon, $lMon, $bUseVolID, $lVolID); $strLimit = " LIMIT {$lStartRec}, {$lRecsPerPage} "; $strTab = 'tmp_vol_hrs'; $strWhere = '1'; if ($bUseVolID) { $cVol = new mvol(); whereAmI(); die; } elseif ($bUseMon) { $strMonth = strXlateMonth($lMon); $strTitle = 'Volunteer Summary for ' . $strMonth . ' ' . $lYear; $strFail = 'There are no volunteer hours for ' . $strMonth . ' ' . $lYear; } else { $strTitle = 'Volunteer Summary for the Year ' . $lYear; $strFail = 'There are no volunteer hours for the year ' . $lYear; } $sqlStr = "SELECT SUM(vsa_dHoursWorked) AS dHours,\n pe_strFName, pe_strLName, tmphr_lVolID\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\n WHERE {$strWhere}\n GROUP BY tmphr_lVolID\n ORDER BY pe_strLName, pe_strFName, tmphr_lVolID;"; $query = $this->db->query($sqlStr); $lNumRows = $query->num_rows(); if ($lNumRows == 0) { return '<br><i>' . $strFail . '.</i><br>'; } $strOut = ' <table class="enpRptC"> <tr> <td class="enpRptTitle" colspan="5">' . $strTitle . ' </td> </tr>'; $strOut .= ' <tr> <td class="enpRptLabel" > Vol ID </td> <td class="enpRptLabel" > Volunteer </td> <td class="enpRptLabel" > Total Hours </td> <td class="enpRptLabel" > Details </td> </tr>'; foreach ($query->result() as $row) { $lVolID = $row->tmphr_lVolID; $strOut .= ' <tr class="makeStripe"> <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" style="text-align: right; padding-right: 3px;">' . number_format($row->dHours, 2) . ' </td> <td class="enpRpt" style="text-align: center;">' . strLinkView_VolDetailHrsViaYrMon($lYear, $lMon, $lVolID, 'View details', true) . ' </tr>'; } $strOut .= '</table><br>'; return $strOut; }
function showVolHours($clsRpt, $volRec, $dTotHours, $dTotUnHours, $lVolID) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $attributes = new stdClass(); $attributes->lTableWidth = 900; $attributes->divID = 'volHrs'; $attributes->divImageID = 'volHrsDivImg'; openBlock('Volunteer Hours <span style="font-size: 9pt;">(' . number_format($dTotHours + $dTotUnHours, 2) . ' hrs.)</span>', '', $attributes); $clsRpt->openReport(); echoT(' <table> <tr> <td style="padding-right: 20pt;"> <b>Scheduled:</b> </td> <td style="text-align: right; ">' . number_format($dTotHours, 2) . ' hours </td> <td>' . strLinkView_VolHrsViaVolID($lVolID, true, 'View details', true) . ' </td> </tr>'); echoT(' <tr> <td style="vertical-align: bottom;"> <b>Unscheduled:</b> </td> <td style="vertical-align: bottom; text-align: right;">' . number_format($dTotUnHours, 2) . ' hours </td> <td>' . strLinkView_VolHrsViaVolID($lVolID, false, 'View details', true) . ' ' . strLinkAdd_VolUnschedHrs($lVolID, 'Log hours for an unscheduled activity', true) . ' ' . strLinkAdd_VolUnschedHrs($lVolID, 'Log volunteer activity', false) . ' </td> </tr> <tr> <td style="vertical-align: bottom;"> <b>Total:</b> </td> <td style="vertical-align: bottom; text-align: right;">' . number_format($dTotHours + $dTotUnHours, 2) . ' hours ' . ' </td> <td>' . strLinkView_VolDetailHrsViaYrMon(null, null, $lVolID, 'View All', true) . ' </td> </tr> </table>'); $clsRpt->closeReport(); $attributes = new stdClass(); $attributes->bCloseDiv = true; closeBlock($attributes); }