Exemplo n.º 1
0
 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);
 }
Exemplo n.º 2
0
 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;
 }