public function bInDirectoryViaCurrentStatus($lClientID)
{
//---------------------------------------------------------------------
// dummy until status structure set up
//---------------------------------------------------------------------
whereAmI();
die;
return true;
}
function screamForHelp($strMsg, $bRecNotFound = false, $strUserErr = '')
{
//----------------------------------------------------------------------
//
//----------------------------------------------------------------------
global $gbDev;
if ($bRecNotFound) {
$strUserErr = 'The record you requested was not found. It may have been deleted.<br>' . $strUserErr;
} else {
if ($strUserErr == '') {
$strUserErr = 'This page is currently under construction.';
}
}
echoT('
<table class="error">
<tr>
<td class="error">
<img src="' . DL_IMAGEPATH . '/misc/errorIcon.png" title="Error!" border="0"><br>' . $strUserErr . '
</td>
</tr>
</table><br><br>');
if ($gbDev) {
whereAmI();
echoT('<blockquote><font face="Courier New">
<font color="RED">
<b>An error has occurred while processing your form!<br><br>
This is an unexpected situation and should be reviewed by technical support.</b><br><br>
</font>
We apologize for this inconvenience.<br><br>
<br>');
//-------------------------------------------------------
// include key version info for users to cut and paste
//-------------------------------------------------------
echoT('<table width="80%" class="errorReport">');
//------------------------------
// reported error
//------------------------------
echoT('<tr>
<td class="errorReport" nowrap valign="top">
<b>Reported Error:</b>
</td>
<td class="errorReport">' . $strMsg . '
</td>
</tr>');
//------------------------------
// mysql version
//------------------------------
$CI =& get_instance();
echoT('<tr>
<td class="errorReport" nowrap valign="top">
<b>mysql version:</b>
</td>
<td class="errorReport">' . mysqli_get_server_info($CI->db->conn_id) . '
</td>
</tr>');
//------------------------------
// php version
//------------------------------
echoT('<tr>
<td class="errorReport" nowrap valign="top">
<b>php version:</b>
</td>
<td class="errorReport">' . phpversion() . '
</td>
</tr>');
//------------------------------
// http server version
//------------------------------
echoT('<tr>
<td class="errorReport" nowrap valign="top">
<b>http server:</b>
</td>
<td class="errorReport">' . $_SERVER['SERVER_SOFTWARE'] . '
</td>
</tr>');
//------------------------------
// http user agent
//------------------------------
echoT('<tr>
<td class="errorReport" nowrap valign="top">
<b>http user agent:</b>
</td>
<td class="errorReport">' . $_SERVER['HTTP_USER_AGENT'] . '
</td>
</tr>');
//------------------------------
// request URI
//------------------------------
echoT('<tr>
<td class="errorReport" nowrap valign="top">
<b>request URI:</b>
</td>
<td class="errorReport">' . htmlspecialchars($_SERVER['REQUEST_URI']) . '
</td>
</tr>');
//------------------------------
// code version
//------------------------------
echoT('<tr>
<td class="errorReport" nowrap valign="top">
<b>Code Version:</b>
</td>
<td class="errorReport">' . number_format(CSNG_CODE_VERSION, 3) . '
</td>
</tr>');
//------------------------------
// schema level
//------------------------------
echoT('<tr>
<td class="errorReport" nowrap valign="top">
<b>DB Schema Level:</b>
</td>
<td class="errorReport">' . number_format(CSNG_DB_VERSION, 3) . '
</td>
</tr>');
echoT('</table>');
echoT('</blockquote><br>');
echoT('<pre>');
debug_print_backtrace();
echoT('</pre>');
}
exit;
}
public function loadEvents()
{
//-----------------------------------------------------------------------
//
//-----------------------------------------------------------------------
global $gdteNow;
if ($this->bCurrentFuture) {
$strWhereDate = ' AND vem_dteEventEndDate >= ' . strPrepDate($gdteNow) . ' ';
} elseif ($this->bPastEvents) {
$strWhereDate = ' AND vem_dteEventEndDate < ' . strPrepDate($gdteNow) . ' ';
} elseif ($this->bAllEvents) {
$strWhereDate = '';
} else {
whereAmI();
die;
}
$this->loadEventsGeneric($strWhereDate);
}
function rs_navigate_lTotPagesCalcs($lTotRecs, $lRecsPerPage)
{
//---------------------------------------------------------------------
// Utility to return the total number of pages, based on the total
// number of records and the records displayed per page
//
// INPUTS
// $lTotRecs - the total number of records
// $lRecsPerPage - the number of records to display per screen display
//
// OUTPUTS
// (function, integer) - total pages to display
//---------------------------------------------------------------------
if ($lRecsPerPage <= 0) {
whereAmI();
}
$lTotPages = (int) ($lTotRecs / $lRecsPerPage);
if ($lTotPages * $lRecsPerPage != $lTotRecs) {
++$lTotPages;
}
return $lTotPages;
}
function viewHoursViaEvent($strViaShift, $lEventID)
{
//-------------------------------------------------------------------------
//
//-------------------------------------------------------------------------
$this->load->helper('dl_util/verify_id');
verifyID($this, $lEventID, 'event ID');
$displayData = array();
$displayData['lEventID'] = $lEventID = (int) $lEventID;
$displayData['bViaShift'] = $bViaShift = strtoupper($strViaShift) == 'TRUE';
//------------------------------------------------
// libraries / models / utilities
//------------------------------------------------
$params = array('enumStyle' => 'terse');
$this->load->library('generic_rpt', $params);
$this->load->model('vols/mvol_event_dates', 'clsVolEventDates');
$this->load->model('vols/mvol_event_hours', 'clsVolHours');
$this->load->model('vols/mvol_event_dates_shifts', 'clsShifts');
$this->load->model('vols/mvol_event_dates_shifts_vols', 'clsSV');
$this->load->model('vols/mvol_events', 'clsVolEvents');
$this->load->helper('dl_util/web_layout');
$this->load->helper('dl_util/time_date');
$displayData['lNumShifts'] = $lNumShifts = $this->clsShifts->lNumShifsTotViaEventID($lEventID);
$displayData['lNumVols'] = $lNumVols = $this->clsSV->lTotVolsAssignedViaEventID($lEventID);
$displayData['mainTemplate'] = 'vols/vol_hours_via_event_shift';
if ($lNumShifts > 0 && $lNumVols > 0) {
if ($bViaShift) {
$this->clsShifts->loadShiftsViaEventID($lEventID);
$idx = 0;
foreach ($this->clsShifts->shifts as $shift) {
$lShiftID = $shift->lKeyID;
$this->clsVolHours->volEventHoursViaShift($lShiftID);
$shift->lNumVolsInShift = $this->clsVolHours->lNumVolsInShift;
if ($shift->lNumVolsInShift > 0) {
$shift->vols = array();
$jIdx = 0;
foreach ($this->clsVolHours->volEHrs as $vHours) {
$shift->vols[$jIdx] = new stdClass();
$shift->vols[$jIdx]->dHoursWorked = $vHours->dHoursWorked;
$shift->vols[$jIdx]->lVolShiftAssignID = $vHours->lVolShiftAssignID;
$shift->vols[$jIdx]->lPeopleID = $vHours->lPeopleID;
$shift->vols[$jIdx]->lVolID = $vHours->lVolID;
$shift->vols[$jIdx]->strFName = $vHours->strFName;
$shift->vols[$jIdx]->strLName = $vHours->strLName;
$shift->vols[$jIdx]->strAddr1 = $vHours->strAddr1;
$shift->vols[$jIdx]->strAddr2 = $vHours->strAddr2;
$shift->vols[$jIdx]->strCity = $vHours->strCity;
$shift->vols[$jIdx]->strState = $vHours->strState;
$shift->vols[$jIdx]->strCountry = $vHours->strCountry;
$shift->vols[$jIdx]->strZip = $vHours->strZip;
++$jIdx;
}
}
++$idx;
}
$displayData['shifts'] =& $this->clsShifts->shifts;
} else {
whereAmI();
die;
}
}
$this->clsVolEvents->loadEventsViaEID($lEventID);
$displayData['strEventName'] = $this->clsVolEvents->events[0]->strEventName;
$displayData['contextSummary'] = $this->clsVolEvents->volEventHTMLSummary(0);
//--------------------------
// breadcrumbs
//--------------------------
$displayData['title'] = CS_PROGNAME . ' | Volunteer Hours';
$displayData['pageTitle'] = anchor('main/menu/vols', 'Volunteers', 'class="breadcrumb"') . ' | ' . anchor('volunteers/events_schedule/viewEventsList', 'Event List', 'class="breadcrumb"') . ' | ' . anchor('volunteers/events_record/viewEvent/' . $lEventID, 'Event', 'class="breadcrumb"') . ' | Volunteer Hours';
$displayData['nav'] = $this->mnav_brain_jar->navData();
$this->load->vars($displayData);
$this->load->view('template');
}
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;
}
