public function strExportPeople()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$strDateFormat = strMysqlDateFormat(false);
$strDateTimeFormat = strMysqlDateFormat(true);
$sqlStr = 'SELECT ' . strExportFields_People() . ",\n peepTab.pe_strPreferredName AS `Preferred Name`,\n peepTab.pe_strSalutation AS Salutation,\n peepTab.pe_strImportID AS `Import ID`,\n peepTab.pe_lACO AS `Accounting Country ID`,\n aco_strName AS `Accounting Country`,\n aco_strCurrencySymbol AS `Currency Symbol`,\n lgen_strListItem AS `Attributed To`,\n peepTab.pe_lHouseholdID AS `Household ID`,\n CONCAT('The ', houseTab.pe_strFName,' ', houseTab.pe_strLName, ' Household') AS Household,\n\n DATE_FORMAT(peepTab.pe_dteBirthDate, {$strDateFormat}) AS `Birth Date`,\n DATE_FORMAT(peepTab.pe_dteOrigin, {$strDateTimeFormat}) AS `Record Creation Date`,\n DATE_FORMAT(peepTab.pe_dteLastUpdate, {$strDateTimeFormat}) AS `Record Last Update`\n\n FROM people_names AS peepTab\n INNER JOIN people_names AS houseTab ON peepTab.pe_lHouseholdID=houseTab.pe_lKeyID\n INNER JOIN admin_aco ON peepTab.pe_lACO=aco_lKeyID\n LEFT JOIN lists_generic ON peepTab.pe_lAttributedTo=lgen_lKeyID\n WHERE NOT peepTab.pe_bRetired\n AND NOT peepTab.pe_bBiz\n {$this->strPeopleWhere}\n ORDER BY peepTab.pe_lKeyID;";
$query = $this->db->query($sqlStr);
return $this->dbutil->csv_from_result($query, CS_CSV_DELIMITER, CS_CSV_NEWLINE);
}
private function strGroupRptExport_PeopleBiz($bBiz, &$strGroupsReviewed, $bShowAny)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
if ($bBiz) {
$strFields = strExportFields_Biz();
$strTableAlias = 'bizTab';
} else {
$strFields = strExportFields_People();
$strTableAlias = 'peepTab';
}
$sqlStr = "SELECT {$strFields}\n FROM tmpGroupMatch\n INNER JOIN people_names AS {$strTableAlias} ON {$strTableAlias}.pe_lKeyID=gm_lForeignID\n 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" . ($bBiz ? 'Businesses/Organizations' : 'People') . ' who are in ' . ($bShowAny ? 'any' : 'all') . ' of these groups: ' . $strGroupsReviewed, null, '"');
}
return $rptExport;
}
function strVolHoursPVAExport(&$sRpt)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$this->pvaHoursVars($sRpt, $dteStart, $dteEnd, $bSortVol, $bSortPHrs, $bSortLHours);
$strTabName = 'tmp_vol_pva';
$this->buildTmpPVATable($strTabName);
$this->tmpPVATableInserts('', $strTabName, $dteStart, $dteEnd);
$this->tmpPVA_ShiftDuration($strTabName, $dteStart, $dteEnd);
$sqlStr = 'SELECT
tmp_lVolID AS `volunteer ID`,
tmp_dHoursWorked AS `Hours Worked`,
tmp_dHoursScheduled AS `Hours Scheduled`, ' . strExportFields_People() . "\n FROM {$strTabName}\n INNER JOIN volunteers ON tmp_lVolID = vol_lKeyID\n INNER JOIN people_names AS peepTab ON vol_lPeopleID = peepTab.pe_lKeyID\n ORDER BY tmp_strLName, tmp_strFName, tmp_lPeopleID;";
$query = $this->db->query($sqlStr);
return $this->dbutil->csv_from_result($query);
}
function strExportFields_Vol()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
return '
vol_lKeyID AS volunteerID, ' . strExportFields_People();
}
