function strVolHoursDetailExport(&$sRpt) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $strDateFormat = strMysqlDateFormat(false); $this->hrsSumOpts($sRpt, $bUseYear, $lYear, $bUseMon, $lMon, $bUseVolID, $lVolID); $strTab = 'tmp_vol_hrs'; $this->buildPopHrsTmp($strTab, $lYear, $lMon, $lVolID); $sqlStr = "SELECT\n vsa_lKeyID AS `Activity ID`,\n lgen_strListItem AS `Activity`,\n DATE_FORMAT(tmphr_dteVolActivity, {$strDateFormat}) AS `Date of Activity`,\n FORMAT(vsa_dHoursWorked, 2) AS `Hours Logged`,\n IF (vem_lKeyID IS NULL, 'n/a', vem_lKeyID) AS `Event ID`,\n IF (vem_lKeyID IS NULL, '(unscheduled)', vem_strEventName) AS `Event Name`,\n IF (vem_lKeyID IS NULL, 'n/a', vs_strShiftName) AS `Shift Name`,\n vsa_strNotes AS `Notes`, " . strExportFields_Vol() . "\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 AS peepTab ON vol_lPeopleID = peepTab.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;"; $query = $this->db->query($sqlStr); return $this->dbutil->csv_from_result($query); }
private function strGroupRptExport_Vol(&$strGroupsReviewed, $bShowAny) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $genumDateFormat; $sqlStr = 'SELECT ' . strExportFields_Vol() . ' FROM tmpGroupMatch INNER JOIN volunteers ON vol_lKeyID=gm_lForeignID INNER JOIN people_names AS peepTab ON peepTab.pe_lKeyID = vol_lPeopleID ORDER BY gm_lKeyID;'; $query = $this->db->query($sqlStr); $rptExport = $this->dbutil->csv_from_result($query); if ($this->config->item('dl_addExportRptInfo')) { $rptExport .= strPrepStr(CS_PROGNAME . " export\n" . 'Created ' . date($genumDateFormat . ' H:i:s e') . "\n" . 'Volunteers who are in ' . ($bShowAny ? 'any' : 'all') . ' of these groups: ' . $strGroupsReviewed, null, '"'); } return $rptExport; }