function showVolClientAssoc($clsRpt, $volRec, $lVolID) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $attributes = new stdClass(); $attributes->lTableWidth = 900; $attributes->divID = 'volClient'; $attributes->divImageID = 'volClientImg'; openBlock('Volunteer-Client Associations <span style="font-size: 9pt;">(' . $volRec->lNumVolClientAssoc . ')</span>', strLinkAdd_VolClientAssoc($lVolID, 'Add new volunteer/client association', true, 'id="vcaImg"') . ' ' . strLinkAdd_VolClientAssoc($lVolID, 'Add new association', false, 'id="vcaImgLnk"'), $attributes); if ($volRec->lNumVolClientAssoc == 0) { echoT('<i>There are no volunteer/client associations for this volunteer.</i>'); } else { echoT(' <table class="enpRpt"> <tr> <td class="enpRptLabel"> clientID </td> <td class="enpRptLabel"> </td> <td class="enpRptLabel"> Name </td> <td class="enpRptLabel"> Address </td> <td class="enpRptLabel"> Phone </td> </tr>'); foreach ($volRec->vca as $va) { $lClientID = $va->lClientID; echoT(' <tr class="makeStripe"> <td class="enpRpt" style="text-align: center;">' . str_pad($lClientID, 5, '0', STR_PAD_LEFT) . ' ' . strLinkView_ClientRecord($lClientID, 'View client record', true, 'id="cr' . $lClientID . '"') . ' </td> <td class="enpRpt" style="text-align: center;">' . strLinkRem_VolClientAssoc($va->lKeyID, $lVolID, 'Remove association', true, true) . ' </td> <td class="enpRpt">' . htmlspecialchars($va->strLName . ', ' . $va->strFName) . ' </td> <td class="enpRpt">' . strBuildAddress($va->strAddr1, $va->strAddr2, $va->strCity, $va->strState, $va->strCountry, $va->strZip, true) . ' </td> <td class="enpRpt">' . strPhoneCell($va->strPhone, $va->strCell, true) . ' </td> </tr>'); } echoT(' </table>'); } $attributes = new stdClass(); $attributes->bCloseDiv = true; closeBlock($attributes); }
function loadLocationInfo($sqlWhere, &$lNumLocs, &$lNumActive, &$locations) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $locations = array(); $lNumActive = 0; $sqlStr = "SELECT\n ch_lKeyID, ch_bActive,\n ch_strChapterName, ch_strAddress1, ch_strAddress2,\n ch_strCity, ch_strState, ch_strCountry, ch_strZip,\n ch_strFax, ch_strPhone, ch_strBannerTagLine, ch_strNotes,\n ch_strEmail, ch_strWebSite,\n ch_strDefAreaCode, ch_strDefState, ch_strDefCountry,\n ch_lPW_MinLen, ch_bPW_UpperLower, ch_bPW_Number,\n ch_bRetired,\n\n ch_lOrigID, ch_lLastUpdateID,\n\n usersC.us_strFirstName AS strCFName, usersC.us_strLastName AS strCLName,\n usersL.us_strFirstName AS strLFName, usersL.us_strLastName AS strLLName,\n UNIX_TIMESTAMP(ch_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(ch_dteLastUpdate) AS dteLastUpdate\n\n FROM admin_chapters\n INNER JOIN admin_users AS usersC ON ch_lOrigID = usersC.us_lKeyID\n INNER JOIN admin_users AS usersL ON ch_lLastUpdateID = usersL.us_lKeyID\n\n WHERE NOT ch_bRetired {$sqlWhere}\n ORDER BY ch_strChapterName, ch_lKeyID;"; $query = $this->db->query($sqlStr); $lNumLocs = $query->num_rows(); if ($lNumLocs == 0) { $locations[0] = new stdClass(); $loc =& $locations[0]; $loc->lKeyID = $loc->bActive = $loc->strLocationName = $loc->strSafeLocationName = $loc->strBannerTagLine = $loc->strNotes = $loc->strAddress1 = $loc->strAddress2 = $loc->strCity = $loc->strState = $loc->strCountry = $loc->strZip = $loc->strAddress = null; $loc->strFax = $loc->strPhone = $loc->strEmail = $loc->strEmailCalDistLists = $loc->strWebSite = $loc->bRetired = $loc->strStaffCFName = $loc->strStaffCLName = $loc->strStaffLFName = $loc->strStaffLLName = $loc->dteOrigin = $loc->dteLastUpdate = null; } else { $idx = 0; foreach ($query->result() as $row) { $locations[$idx] = new stdClass(); $loc =& $locations[$idx]; $loc->lKeyID = (int) $row->ch_lKeyID; $loc->bActive = $bActive = (bool) $row->ch_bActive; if ($bActive) { ++$lNumActive; } $loc->strLocationName = $row->ch_strChapterName; $loc->strSafeLocationName = htmlspecialchars($row->ch_strChapterName); $loc->strBannerTagLine = $row->ch_strBannerTagLine; $loc->strNotes = $row->ch_strNotes; $loc->strAddress1 = $row->ch_strAddress1; $loc->strAddress2 = $row->ch_strAddress2; $loc->strCity = $row->ch_strCity; $loc->strState = $row->ch_strState; $loc->strCountry = $row->ch_strCountry; $loc->strZip = $row->ch_strZip; $loc->strAddress = strBuildAddress($loc->strAddress1, $loc->strAddress2, $loc->strCity, $loc->strState, $loc->strCountry, $loc->strZip, true); $loc->strFax = $row->ch_strFax; $loc->strPhone = $row->ch_strPhone; $loc->strEmail = $row->ch_strEmail; $loc->strWebSite = $row->ch_strWebSite; $loc->bRetired = (bool) $row->ch_bRetired; $loc->strStaffCFName = $row->strCFName; $loc->strStaffCLName = $row->strCLName; $loc->strStaffLFName = $row->strLFName; $loc->strStaffLLName = $row->strLLName; $loc->dteOrigin = $row->dteOrigin; $loc->dteLastUpdate = $row->dteLastUpdate; ++$idx; } } }
function loadVolClientAssoc($sqlWhere, &$volClient) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $gstrPassPhrase; $volClient = array(); $strOrder = ' AES_DECRYPT(cr_strLName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)), AES_DECRYPT(cr_strFName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)), AES_DECRYPT(cr_strMName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)), cr_lKeyID '; $sqlStr = 'SELECT vca_lKeyID, vca_lVolID, vca_lClientID, vca_strNotes, vca_bActive, vca_dteInactive, vca_bRetired, vca_lOriginID, vca_lLastUpdateID, vca_dteOrigin, vca_dteLastUpdate, vol_strLName, vol_strFName, vol_strMName, vol_bRetired, vol_strPreferredName, vol_strTitle, vol_strAddr1, vol_strAddr2, vol_strCity, vol_strState, vol_strZip, vol_strCountry, vol_strEmail, vol_strPhone, vol_strCell, vol_dteBirthDate, AES_DECRYPT(cr_dteBirth, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS dtePBirth, AES_DECRYPT(cr_dteDeath, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS dtePDeath, AES_DECRYPT(cr_strTitle, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPTitle, AES_DECRYPT(cr_strFName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPFName, AES_DECRYPT(cr_strMName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPMName, AES_DECRYPT(cr_strLName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPLName, AES_DECRYPT(cr_strAddr1, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPAddr1, AES_DECRYPT(cr_strAddr2, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPAddr2, AES_DECRYPT(cr_strCity, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPCity, AES_DECRYPT(cr_strState, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPState, AES_DECRYPT(cr_strCountry, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPCountry, AES_DECRYPT(cr_strZip, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPZip, AES_DECRYPT(cr_strPhone, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPPhone, AES_DECRYPT(cr_strCell, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPCell, AES_DECRYPT(cr_strEmail, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPEmail, AES_DECRYPT(cr_strBio, SHA2(' . strPrepStr($gstrPassPhrase) . ",256)) AS strPBio,\n cr_enumGender\n FROM vol_client_association\n INNER JOIN patient_records ON vca_lClientID = cr_lKeyID\n INNER JOIN volunteers ON vca_lVolID = vol_lKeyID\n\n WHERE NOT vca_bRetired\n {$sqlWhere}\n AND NOT cr_bRetired\n ORDER BY {$strOrder};"; $query = $this->db->query($sqlStr); $numRows = $query->num_rows(); if ($numRows > 0) { $idx = 0; foreach ($query->result() as $row) { $volClient[$idx] = new stdClass(); $vca =& $volClient[$idx]; $vca->lKeyID = (int) $row->vca_lKeyID; $vca->lVolID = (int) $row->vca_lVolID; $vca->lPatientID = (int) $row->vca_lClientID; $vca->strNotes = $row->vca_strNotes; $vca->bActive = (bool) $row->vca_bActive; $vca->dteInactive = $row->vca_dteInactive; $vca->bRetired = (bool) $row->vca_bRetired; $vca->lOriginID = (int) $row->vca_lOriginID; $vca->lLastUpdateID = (int) $row->vca_lLastUpdateID; $vca->dteOrigin = $row->vca_dteOrigin; $vca->dteLastUpdate = $row->vca_dteLastUpdate; $vca->vol = new stdClass(); $vca->vol->strFName = $row->vol_strFName; $vca->vol->strMName = $row->vol_strMName; $vca->vol->strLName = $row->vol_strLName; $vca->vol->dteBirth = $row->vol_dteBirthDate; // $vca->vol->enumGender = $row->vol_enumGender; $vca->vol->strAddr1 = $row->vol_strAddr1; $vca->vol->strAddr2 = $row->vol_strAddr2; $vca->vol->strCity = $row->vol_strCity; $vca->vol->strState = $row->vol_strState; $vca->vol->strCountry = $row->vol_strCountry; $vca->vol->strZip = $row->vol_strZip; $vca->vol->strPhone = $row->vol_strPhone; $vca->vol->strCell = $row->vol_strCell; $vca->vol->strEmail = $row->vol_strEmail; $vca->vol->strAddress = strBuildAddress($vca->vol->strAddr1, $vca->vol->strAddr2, $vca->vol->strCity, $vca->vol->strState, $vca->vol->strCountry, $vca->vol->strZip, true); $vca->patient = new stdClass(); $vca->patient->strFName = $row->strPFName; $vca->patient->strMName = $row->strPMName; $vca->patient->strLName = $row->strPLName; $vca->patient->dteBirth = $row->dtePBirth; $vca->patient->enumGender = $row->cr_enumGender; $vca->patient->strAddr1 = $row->strPAddr1; $vca->patient->strAddr2 = $row->strPAddr2; $vca->patient->strCity = $row->strPCity; $vca->patient->strState = $row->strPState; $vca->patient->strCountry = $row->strPCountry; $vca->patient->strZip = $row->strPZip; $vca->patient->strPhone = $row->strPPhone; $vca->patient->strCell = $row->strPCell; $vca->patient->strEmail = $row->strPEmail; ++$idx; } } }
echoT(' <tr class="makeStripe"> <td class="enpRpt" style="text-align: center; width: 60pt;">' . strLinkView_ClientLocation($lCLID, 'View client location', true, 'id="cLocView_' . $lCLID . '"') . ' ' . str_pad($lCLID, 5, '0', STR_PAD_LEFT) . ' </td> <td class="enpRpt" style="text-align: center; width: 18pt;">' . $strLinkRemove . ' </td> <td class="enpRpt" style=" width: 160pt;"><b>' . htmlspecialchars($clsLoc->strLocation) . '</b><br>'); echoT($clsLoc->strSponProg); $lNumSponsors = $clsLoc->lNumSponsors; if ($lNumSponsors > 0) { $strLinkSpon = strLinkView_SponsorsViaLocProg($lCLID, 'View sponsors for this location', true); } else { $strLinkSpon = ' '; } echoT(' </td> <td class="enpRpt" style=" width: 160pt;">' . strBuildAddress($clsLoc->strAddress1, $clsLoc->strAddress2, $clsLoc->strCity, $clsLoc->strState, $clsLoc->strCountry, $clsLoc->strPostalCode, true) . ' </td> <td class="enpRpt" style=" width: 70pt;">' . htmlspecialchars($clsLoc->strCountry) . ' </td> <td class="enpRpt" style="text-align: center; width: 70pt;">' . number_format($clsLoc->lNumberClients) . ' ' . strLinkView_ClientsViaLocation($lCLID, 'View Clients at this Location', true) . ' </td> <td class="enpRpt" style="text-align: center;">' . number_format($clsLoc->lNumSponsors) . ' ' . $strLinkSpon . ' </td> <td class="enpRpt" style="text-align: center;">' . ($clsLoc->bEnableEMR ? 'Yes' : 'No') . ' </td> </tr>'); } ?> </table><br>
function loadContactNameDirectoryPage($strWhereExtra, $lStartRec, $lRecsPerPage) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $sqlLimitExtra = " LIMIT {$lStartRec}, {$lRecsPerPage} "; $this->sqlWhereExtra = $strWhereExtra; $sqlStr = "SELECT\n pe_lKeyID, pe_strLName, pe_strFName, pe_strMName,\n pe_strTitle, pe_strPreferredName,\n pe_strAddr1,\n pe_strAddr2,\n pe_strCity,\n pe_strState,\n pe_strCountry,\n pe_strZip,\n pe_strPhone,\n pe_strCell,\n pe_strEmail\n FROM biz_contacts\n INNER JOIN people_names ON bc_lContactID=pe_lKeyID\n WHERE NOT pe_bBiz\n AND NOT pe_bRetired\n AND NOT bc_bRetired\n {$strWhereExtra}\n GROUP BY pe_lKeyID\n ORDER BY\n pe_strLName, pe_strFName, pe_strMName, pe_lKeyID\n {$sqlLimitExtra};"; $query = $this->db->query($sqlStr); $this->lNumContactsNames = $numRows = $query->num_rows(); $this->contactsNames = array(); if ($numRows > 0) { $idx = 0; foreach ($query->result() as $row) { $this->contactsNames[$idx] = new stdClass(); $cRec =& $this->contactsNames[$idx]; $cRec->lPeopleID = $row->pe_lKeyID; $cRec->strFName = $strFName = $row->pe_strFName; $cRec->strLName = $strLName = $row->pe_strLName; $cRec->strMName = $strMName = $row->pe_strMName; $cRec->strTitle = $strTitle = $row->pe_strTitle; $cRec->strPreferred = $strPreferred = $row->pe_strPreferredName; $cRec->strSafeName = htmlspecialchars(strBuildName(false, $strTitle, $strPreferred, $strFName, $strLName, $strMName)); $cRec->strSafeNameLF = htmlspecialchars(strBuildName(true, $strTitle, $strPreferred, $strFName, $strLName, $strMName)); $cRec->strAddr1 = $row->pe_strAddr1; $cRec->strAddr2 = $row->pe_strAddr2; $cRec->strCity = $row->pe_strCity; $cRec->strState = $row->pe_strState; $cRec->strCountry = $row->pe_strCountry; $cRec->strZip = $row->pe_strZip; $cRec->strPhone = $row->pe_strPhone; $cRec->strCell = $row->pe_strCell; $cRec->strEmail = $row->pe_strEmail; $cRec->strEmailFormatted = strBuildEmailLink($cRec->strEmail, '', false, ''); $cRec->strAddress = strBuildAddress($cRec->strAddr1, $cRec->strAddr2, $cRec->strCity, $cRec->strState, $cRec->strCountry, $cRec->strZip, true); $cRec->biz = $this->bizViaContactPID($cRec->lPeopleID, $cRec->lNumBiz); ++$idx; } } }
private function loadImgDocInfoViaContext($enumContext, $imgDoc, $row) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $genumDateFormat, $glChapterID; $lFID = (int) $imgDoc->lForeignID; switch ($enumContext) { case CENUM_CONTEXT_CLIENT: $imgDoc->strNameLabel = 'Client'; $imgDoc->strName = strLinkView_ClientRecord($lFID, 'View Client Record', true) . ' ' . str_pad($lFID, 6, '0', STR_PAD_LEFT) . ' <b>' . htmlspecialchars($row->cr_strLName . ', ' . $row->cr_strFName) . '</b>'; $imgDoc->strAddressLabel = 'Address'; $imgDoc->strAddr = strBuildAddress($row->cr_strAddr1, $row->cr_strAddr2, $row->cr_strCity, $row->cr_strState, $row->cr_strCountry, $row->cr_strZip, true); $strPhone = strPhoneCell($row->cr_strPhone, $row->cr_strCell); if ($strPhone != '') { $imgDoc->strAddr .= '<br>' . $strPhone; } break; case CENUM_CONTEXT_PEOPLE: $imgDoc->strNameLabel = 'Name'; $imgDoc->strName = strLinkView_PeopleRecord($lFID, 'View People Record', true) . ' ' . str_pad($lFID, 6, '0', STR_PAD_LEFT) . ' <b>' . htmlspecialchars($row->pe_strLName . ', ' . $row->pe_strFName) . '</b>'; $imgDoc->strAddressLabel = 'Address'; $imgDoc->strAddr = strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true); $strPhone = strPhoneCell($row->pe_strPhone, $row->pe_strCell); if ($strPhone != '') { $imgDoc->strAddr .= '<br>' . $strPhone; } break; case CENUM_CONTEXT_LOCATION: $imgDoc->strNameLabel = 'Client Location'; $imgDoc->strName = strLinkView_ClientLocation($lFID, 'View client location', true) . ' ' . htmlspecialchars($row->cl_strLocation); break; case CENUM_CONTEXT_GRANTPROVIDER: $imgDoc->strNameLabel = 'Funder/Provider'; $imgDoc->strName = strLinkView_GrantProvider($lFID, 'View funder/provider', true) . ' ' . htmlspecialchars($row->gpr_strGrantOrg); break; case CENUM_CONTEXT_INVITEM: $imgDoc->strNameLabel = 'Inventory Item'; $imgDoc->strName = strLinkView_InventoryItem($lFID, 'View inventory item', true) . ' ' . htmlspecialchars($row->ivi_strItemName); break; case CENUM_CONTEXT_AUCTION: $imgDoc->strNameLabel = 'Silent Auction'; $imgDoc->strName = strLinkView_AuctionRecord($lFID, 'View Auction', true) . ' ' . htmlspecialchars($row->auc_strAuctionName) . ' (' . date($genumDateFormat, dteMySQLDate2Unix($row->auc_dteAuctionDate)) . ')'; break; case CENUM_CONTEXT_AUCTIONITEM: $imgDoc->strNameLabel = 'Auction Item'; $imgDoc->strName = strLinkView_AuctionItem($lFID, 'View Auction Item', true) . ' ' . 'item: ' . htmlspecialchars($row->ait_strItemName) . '<br>package: ' . htmlspecialchars($row->ap_strPackageName) . '<br>auction: ' . htmlspecialchars($row->auc_strAuctionName); break; case CENUM_CONTEXT_AUCTIONPACKAGE: $imgDoc->strNameLabel = 'Auction Package'; $imgDoc->strName = strLinkView_AuctionPackageRecord($lFID, 'View Auction Package', true) . ' ' . 'package: ' . htmlspecialchars($row->ap_strPackageName) . '<br>auction: ' . htmlspecialchars($row->auc_strAuctionName); break; case CENUM_CONTEXT_BIZ: $imgDoc->strNameLabel = 'Business/Organization Name'; $imgDoc->strName = strLinkView_BizRecord($lFID, 'View Business/Organization Record', true) . ' ' . str_pad($lFID, 6, '0', STR_PAD_LEFT) . ' <b>' . htmlspecialchars($row->pe_strLName) . '</b>'; $imgDoc->strAddressLabel = 'Address'; $imgDoc->strAddr = strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true); $strPhone = strPhoneCell($row->pe_strPhone, $row->pe_strCell); if ($strPhone != '') { $imgDoc->strAddr .= '<br>' . $strPhone; } break; case CENUM_CONTEXT_SPONSORSHIP: $bBiz = (bool) $row->pe_bBiz; if ($bBiz) { $imgDoc->strNameLabel = 'Sponsor (Business/organization)'; $imgDoc->strName = strLinkView_PeopleRecord($lFID, 'View People Record', true) . ' ' . str_pad($lFID, 6, '0', STR_PAD_LEFT) . ' <b>' . htmlspecialchars($row->pe_strLName . ', ' . $row->pe_strFName) . '</b>'; } else { $imgDoc->strNameLabel = 'Sponsor (Individual)'; $imgDoc->strName = strLinkView_BizRecord($lFID, 'View Business/Organization Record', true) . ' ' . str_pad($lFID, 6, '0', STR_PAD_LEFT) . ' <b>' . htmlspecialchars($row->pe_strLName) . '</b>'; } $imgDoc->strAddressLabel = 'Address'; $imgDoc->strAddr = strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true); $strPhone = strPhoneCell($row->pe_strPhone, $row->pe_strCell); if ($strPhone != '') { $imgDoc->strAddr .= '<br>' . $strPhone; } break; case CENUM_CONTEXT_ORGANIZATION: $imgDoc->strNameLabel = 'Your organization'; $imgDoc->strName = strLinkView_OrganizationRecord($lFID, 'View organization record', true) . ' ' . htmlspecialchars($row->ch_strChapterName); break; case CENUM_CONTEXT_STAFF: $imgDoc->strNameLabel = 'Staff Member'; $imgDoc->strName = strLinkView_User($lFID, 'View staff member record', true) . ' ' . htmlspecialchars($row->strFirstName . ' ' . $row->strLastName); break; case CENUM_CONTEXT_VOLUNTEER: $imgDoc->strNameLabel = 'Name'; $imgDoc->strName = strLinkView_Volunteer($lFID, 'View Volunteer Record', true) . ' ' . str_pad($lFID, 6, '0', STR_PAD_LEFT) . ' <b>' . htmlspecialchars($row->pe_strLName . ', ' . $row->pe_strFName) . '</b>'; $imgDoc->strAddressLabel = 'Address'; $imgDoc->strAddr = strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true); $strPhone = strPhoneCell($row->pe_strPhone, $row->pe_strCell); if ($strPhone != '') { $imgDoc->strAddr .= '<br>' . $strPhone; } break; default: screamForHelp($enumContext . ': image context not currently implemented<br>error on line <b> -- ' . __LINE__ . ' --</b>,<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__); break; } }
public function loadClientsGeneric() { //----------------------------------------------------------------------- // //----------------------------------------------------------------------- global $glclsDTDateFormat; customClient_AAYHF_01($strInnerAAYHF, $strFieldsAAYHF, $bAAYHF_Beacon); $strOrder = $this->strClientOrder; if ($strOrder == '') { $strOrder = ' cl_strLocation, cr_strLName, cr_strFName, cr_strMName, cr_lKeyID '; } $clsDateTime = new dl_date_time(); $sqlStr = "SELECT\n cr_lKeyID, cr_strFName, cr_strMName, cr_strLName,\n cr_dteEnrollment,\n cr_dteBirth, cr_dteDeath, cr_enumGender,\n cr_lLocationID, cl_strCountry, cr_lStatusCatID, cr_lVocID,\n cr_lMaxSponsors, cr_strBio, cr_bNoLongerAtLocation,\n cr_bRetired, cr_lOriginID, cr_lLastUpdateID,\n UNIX_TIMESTAMP(cr_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(cr_dteLastUpdate) AS dteLastUpdate,\n cl_strLocation, cl_bEnableEMR,\n cr_lAttributedTo, lgen_strListItem,\n\n cr_strAddr1, cr_strAddr2,\n cr_strCity, cr_strState, cr_strCountry,\n cr_strZip, cr_strPhone, cr_strCell, cr_strEmail,\n\n -- ------------------------\n -- vocabulary\n -- ------------------------\n cv_strVocTitle,\n cv_strVocClientS, cv_strVocClientP,\n cv_strVocSponsorS, cv_strVocSponsorP,\n cv_strVocLocS, cv_strVocLocP,\n cv_strVocSubLocS, cv_strVocSubLocP,\n\n -- ------------------------\n -- current status\n -- ------------------------\n csh_lKeyID, csh_lStatusID,\n csh_dteStatusDate,\n csh_bIncludeNotesInPacket, csh_strStatusTxt,\n\n cst_lClientStatusCatID, cst_strStatus, cst_bAllowSponsorship,\n cst_bShowInDir, cst_bDefault,\n curStatSCat.csc_strCatName AS curStat_strCatName,\n defSCat.csc_strCatName AS defStat_strCatName,\n\n uc.us_strFirstName AS strUCFName, uc.us_strLastName AS strUCLName,\n ul.us_strFirstName AS strULFName, ul.us_strLastName AS strULLName\n\n {$strFieldsAAYHF}\n\n FROM client_records\n {$this->strInnerExtra}\n {$strInnerAAYHF}\n LEFT JOIN client_location ON cr_lLocationID = cl_lKeyID\n LEFT JOIN lists_client_vocab ON cr_lVocID = cv_lKeyID\n\n LEFT JOIN client_status ON csh_lClientID = cr_lKeyID\n LEFT JOIN lists_client_status_entries ON csh_lStatusID = cst_lKeyID\n LEFT JOIN client_status_cats AS curStatSCat ON cst_lClientStatusCatID = curStatSCat.csc_lKeyID\n LEFT JOIN client_status_cats AS defSCat ON cr_lStatusCatID = defSCat.csc_lKeyID\n\n INNER JOIN admin_users AS uc ON uc.us_lKeyID=cr_lOriginID\n INNER JOIN admin_users AS ul ON ul.us_lKeyID=cr_lLastUpdateID\n\n LEFT JOIN lists_generic ON cr_lAttributedTo=lgen_lKeyID\n WHERE 1\n AND NOT cr_bRetired\n\n -- ---------------------------------------\n -- subquery to find most current status\n -- ---------------------------------------\n AND csh_lKeyID=(SELECT csh_lKeyID\n FROM client_status\n WHERE csh_lClientID=cr_lKeyID\n AND NOT csh_bRetired\n ORDER BY csh_dteStatusDate DESC, csh_lKeyID DESC\n LIMIT 0,1)\n\n {$this->strExtraClientWhere}\n ORDER BY {$strOrder}\n {$this->strClientLimit};"; $query = $this->db->query($sqlStr); $this->lNumClients = $numRows = $query->num_rows(); $this->clients = array(); if ($numRows == 0) { $this->clients[0] = new stdClass(); $client =& $this->clients[0]; $client->lKeyID = $client->strFName = $client->strMName = $client->strLName = $client->dteEnrollment = $client->dteBirth = $client->dteDeath = $client->enumGender = $client->lLocationID = $client->lStatusCatID = $client->lVocID = $client->lMaxSponsors = $client->strBio = $client->lAttribID = $client->strAttrib = $client->bRetired = $client->lOriginID = $client->lLastUpdateID = $client->dteOrigin = $client->dteLastUpdate = $client->strLocation = $client->strLocCountry = $client->strAddr1 = $client->strAddr2 = $client->strCity = $client->strState = $client->strCountry = $client->strZip = $client->strPhone = $client->strCell = $client->strEmail = $client->strAddress = $client->cv_strVocTitle = $client->cv_strVocClientS = $client->cv_strVocClientP = $client->cv_strVocSponsorS = $client->cv_strVocSponsorP = $client->cv_strVocLocS = $client->cv_strVocLocP = $client->cv_strVocSubLocS = $client->cv_strVocSubLocP = $client->curStat_lStatRecKeyID = $client->curStat_lStatusID = $client->curStat_dteStatus = $client->curStat_bIncludeNotesInPacket = $client->curStat_strStatusNotes = $client->curStat_lClientStatusCatID = $client->curStat_strStatus = $client->curStat_bAllowSponsorship = $client->curStat_bShowInDir = $client->curStat_bDefaultStatus = $client->curStat_strStatusCatName = null; } else { $idx = 0; foreach ($query->result() as $row) { $this->clients[$idx] = new stdClass(); $client =& $this->clients[$idx]; $client->lKeyID = (int) $row->cr_lKeyID; $client->strFName = $row->cr_strFName; $client->strMName = $row->cr_strMName; $client->strLName = $row->cr_strLName; $client->strSafeName = htmlspecialchars($row->cr_strFName . ' ' . $row->cr_strLName); $client->strSafeNameLF = htmlspecialchars($row->cr_strLName . ', ' . $row->cr_strFName); $client->dteEnrollment = dteMySQLDate2Unix($row->cr_dteEnrollment); $client->dteBirth = $mySQLdteBirth = $row->cr_dteBirth; $client->dteDeath = $row->cr_dteDeath; $client->enumGender = $row->cr_enumGender; $client->lLocationID = $row->cr_lLocationID; $client->lStatusCatID = $row->cr_lStatusCatID; $client->strStatusCatName = $row->defStat_strCatName; //------------------------------ // client address/contact //------------------------------ $client->strAddr1 = $row->cr_strAddr1; $client->strAddr2 = $row->cr_strAddr2; $client->strCity = $row->cr_strCity; $client->strState = $row->cr_strState; $client->strCountry = $row->cr_strCountry; $client->strZip = $row->cr_strZip; $client->strPhone = $row->cr_strPhone; $client->strCell = $row->cr_strCell; $client->strEmail = $row->cr_strEmail; $client->strEmailFormatted = strBuildEmailLink($client->strEmail, '', false, ''); $client->strAddress = strBuildAddress($client->strAddr1, $client->strAddr2, $client->strCity, $client->strState, $client->strCountry, $client->strZip, true); //------------------------------ // client age/birth day info //------------------------------ if (is_null($mySQLdteBirth)) { $client->objClientBirth = null; $client->lAgeYears = null; $client->strClientAgeBDay = '(age n/a)'; } else { $client->objClientBirth = new dl_date_time(); $client->objClientBirth->setDateViaMySQL(0, $mySQLdteBirth); $client->strClientAgeBDay = $client->objClientBirth->strPeopleAge(0, $mySQLdteBirth, $client->lAgeYears, $glclsDTDateFormat); } $client->lVocID = $row->cr_lVocID; $client->lMaxSponsors = $row->cr_lMaxSponsors; $client->strBio = $row->cr_strBio; $client->bRetired = $row->cr_bRetired; $client->lOriginID = $row->cr_lOriginID; $client->lLastUpdateID = $row->cr_lLastUpdateID; $client->strLocation = $row->cl_strLocation; $client->strLocCountry = $row->cl_strCountry; $client->bEnableEMR = $row->cl_bEnableEMR; $client->cv_strVocTitle = $row->cv_strVocTitle; $client->cv_strVocClientS = $row->cv_strVocClientS; $client->cv_strVocClientP = $row->cv_strVocClientP; $client->cv_strVocSponsorS = $row->cv_strVocSponsorS; $client->cv_strVocSponsorP = $row->cv_strVocSponsorP; $client->cv_strVocLocS = $row->cv_strVocLocS; $client->cv_strVocLocP = $row->cv_strVocLocP; $client->cv_strVocSubLocS = $row->cv_strVocSubLocS; $client->cv_strVocSubLocP = $row->cv_strVocSubLocP; //--------------------------------- // status fields - current status //--------------------------------- $client->curStat_lStatRecKeyID = $row->csh_lKeyID; $client->curStat_lStatusID = $row->csh_lStatusID; $client->curStat_dteStatus = dteMySQLDate2Unix($row->csh_dteStatusDate); $client->curStat_bIncludeNotesInPacket = $row->csh_bIncludeNotesInPacket; $client->curStat_strStatusNotes = $row->csh_strStatusTxt; $client->curStat_lClientStatusCatID = $row->cst_lClientStatusCatID; $client->curStat_strStatus = $row->cst_strStatus; $client->curStat_bAllowSponsorship = $row->cst_bAllowSponsorship; $client->curStat_bShowInDir = $row->cst_bShowInDir; $client->curStat_bDefaultStatus = $row->cst_bDefault; $client->curStat_strStatusCatName = $row->curStat_strCatName; $client->lAttribID = $row->cr_lAttributedTo; $client->strAttrib = $row->lgen_strListItem; $client->dteOrigin = $row->dteOrigin; $client->dteLastUpdate = $row->dteLastUpdate; $client->ucstrFName = $row->strUCFName; $client->ucstrLName = $row->strUCLName; $client->ulstrFName = $row->strULFName; $client->ulstrLName = $row->strULLName; $client->strFlagsTable = ''; //------------------ // sponsors //------------------ $this->loadSponsorshipInfo($client->lKeyID, true, $client->lNumSponsors, $client->sponsors); //------------------ // custom fields //------------------ addClientFields_AAYHF_Beacon($bAAYHF_Beacon, $client, $row); ++$idx; } } if ($this->bDebug) { $this->dumpClientRecs(); } }
public function loadLocationRec($id) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $sqlStr = "SELECT\n cl_lKeyID, cl_strLocation, cl_strDescription,\n cl_strCountry, cl_strWebLink, cl_strAddress1,\n cl_strAddress2, cl_strCity, cl_strState,\n cl_strPostalCode, cl_strNotes, cl_bEnableEMR, cl_bRetired,\n cl_lOriginID, cl_lLastUpdateID,\n UNIX_TIMESTAMP(cl_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(cl_dteLastUpdate) AS dteLastUpdate,\n uc.us_strFirstName AS strUCFName, uc.us_strLastName AS strUCLName,\n ul.us_strFirstName AS strULFName, ul.us_strLastName AS strULLName\n\n FROM client_location\n INNER JOIN admin_users AS uc ON uc.us_lKeyID=cl_lOriginID\n INNER JOIN admin_users AS ul ON ul.us_lKeyID=cl_lLastUpdateID\n\n WHERE cl_lKeyID={$id};"; $query = $this->db->query($sqlStr); $numRows = $query->num_rows(); // $result = mysql_query($sqlStr); // if (bSQLError('SQL error on line '.__LINE__.', file '.__FILE__.', function '.__FUNCTION__, $sqlStr) ) { // screamForHelp('Unexpected SQL error'); // }else{ // $numRows = mysql_num_rows($result); if ($numRows == 0) { $this->lKeyID = $this->strLocation = $this->strDescription = $this->strCountry = $this->strWebLink = $this->strAddress1 = $this->strAddress2 = $this->strCity = $this->strState = $this->strPostalCode = $this->strNotes = $this->bEnableEMR = $this->bRetired = $this->lOriginID = $this->lLastUpdateID = $this->dteOrigin = $this->dteLastUpdate = null; } else { $row = $query->row(); // $row = mysql_fetch_array($result); $this->lKeyID = (int) $row->cl_lKeyID; $this->strLocation = $row->cl_strLocation; $this->strDescription = $row->cl_strDescription; $this->strCountry = $row->cl_strCountry; $this->strWebLink = $row->cl_strWebLink; $this->strAddress1 = $row->cl_strAddress1; $this->strAddress2 = $row->cl_strAddress2; $this->strCity = $row->cl_strCity; $this->strState = $row->cl_strState; $this->strPostalCode = $row->cl_strPostalCode; $this->strAddress = strBuildAddress($this->strAddress1, $this->strAddress2, $this->strCity, $this->strState, $this->strCountry, $this->strPostalCode, true); $this->strNotes = $row->cl_strNotes; $this->bEnableEMR = $row->cl_bEnableEMR; $this->bRetired = (bool) $row->cl_bRetired; $this->lOriginID = (int) $row->cl_lOriginID; $this->lLastUpdateID = (int) $row->cl_lLastUpdateID; $this->dteOrigin = (int) $row->dteOrigin; $this->dteLastUpdate = (int) $row->dteLastUpdate; $this->strUCFName = $row->strUCFName; $this->strUCLName = $row->strUCLName; $this->strULFName = $row->strULFName; $this->strULLName = $row->strULLName; } // } }
function loadChapterInfo() { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $clsACO = new madmin_aco(); if (is_null($this->lChapterID)) { screamForHelp('CHAPTER ID NOT SET<br>error on <b>line:</b> ' . __LINE__ . '<br><b>file: </b>' . __FILE__ . '<br><b>function: </b>' . __FUNCTION__); } $sqlStr = "SELECT\n ch_lKeyID,\n ch_strChapterName, ch_strAddress1, ch_strAddress2,\n ch_strCity, ch_strState, ch_strCountry, ch_strZip,\n ch_strFax, ch_strPhone, ch_strBannerTagLine,\n ch_strEmail, ch_strEmailCalDistr, ch_strWebSite,\n ch_strDefAreaCode, ch_strDefState, ch_strDefCountry,\n ch_lPW_MinLen, ch_bPW_UpperLower, ch_bPW_Number,\n ch_bUS_DateFormat, ch_lDefaultACO, ch_lTimeZone,\n ch_vocZip, ch_vocState, ch_vocJobSkills,\n aco_strFlag, aco_strCurrencySymbol, aco_strName,\n ch_bRetired,\n\n ch_lOrigID, ch_lLastUpdateID,\n UNIX_TIMESTAMP(ch_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(ch_dteLastUpdate) AS dteLastUpdate,\n\n tz_strTimeZone,\n\n usersC.us_strFirstName AS strCFName, usersC.us_strLastName AS strCLName,\n usersL.us_strFirstName AS strLFName, usersL.us_strLastName AS strLLName,\n UNIX_TIMESTAMP(ch_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(ch_dteLastUpdate) AS dteLastUpdate\n\n FROM admin_chapters\n INNER JOIN admin_users AS usersC ON ch_lOrigID = usersC.us_lKeyID\n INNER JOIN admin_users AS usersL ON ch_lLastUpdateID = usersL.us_lKeyID\n INNER JOIN admin_aco ON ch_lDefaultACO = aco_lKeyID\n INNER JOIN lists_tz ON ch_lTimeZone = tz_lKeyID\n\n WHERE ch_lKeyID={$this->lChapterID};"; $query = $this->db->query($sqlStr); $numRows = $query->num_rows(); if ($numRows == 0) { echo "<br><br>{$sqlStr}<br><br>"; screamForHelp('EOF error on line ' . __LINE__ . ', file ' . __FILE__ . ', function ' . __FUNCTION__); } else { $row = $query->row(); $this->chapterRec = new stdClass(); $this->chapterRec->lKeyID = (int) $row->ch_lKeyID; $this->chapterRec->strChapterName = $row->ch_strChapterName; $this->chapterRec->strSafeChapterName = htmlspecialchars($row->ch_strChapterName); $this->chapterRec->strBannerTagLine = $row->ch_strBannerTagLine; $this->chapterRec->strAddress1 = $row->ch_strAddress1; $this->chapterRec->strAddress2 = $row->ch_strAddress2; $this->chapterRec->strCity = $row->ch_strCity; $this->chapterRec->strState = $row->ch_strState; $this->chapterRec->strCountry = $row->ch_strCountry; $this->chapterRec->strZip = $row->ch_strZip; $this->chapterRec->strAddress = strBuildAddress($this->chapterRec->strAddress1, $this->chapterRec->strAddress2, $this->chapterRec->strCity, $this->chapterRec->strState, $this->chapterRec->strCountry, $this->chapterRec->strZip, true); $this->chapterRec->strFax = $row->ch_strFax; $this->chapterRec->strPhone = $row->ch_strPhone; $this->chapterRec->strEmail = $row->ch_strEmail; $this->chapterRec->strEmailCalDistLists = $row->ch_strEmailCalDistr; $this->chapterRec->strWebSite = $row->ch_strWebSite; $this->chapterRec->lTimeZoneID = (int) $row->ch_lTimeZone; $this->chapterRec->strTimeZone = $row->tz_strTimeZone; $this->chapterRec->strDefAreaCode = $row->ch_strDefAreaCode; $this->chapterRec->strDefState = $row->ch_strDefState; $this->chapterRec->strDefCountry = $row->ch_strDefCountry; $this->chapterRec->bUS_DateFormat = (bool) $row->ch_bUS_DateFormat; $this->chapterRec->lDefaultACO = (int) $row->ch_lDefaultACO; $this->chapterRec->strFlag = $row->aco_strFlag; $this->chapterRec->strFlagImg = $clsACO->strFlagImage($row->aco_strFlag, $row->aco_strName); $this->chapterRec->strCurrencySymbol = $row->aco_strCurrencySymbol; $this->chapterRec->strCountryName = $row->aco_strName; $this->chapterRec->lPW_MinLen = $row->ch_lPW_MinLen; $this->chapterRec->bPW_UpperLower = (bool) $row->ch_bPW_UpperLower; $this->chapterRec->bPW_Number = (bool) $row->ch_bPW_Number; $this->chapterRec->bRetired = (bool) $row->ch_bRetired; $this->chapterRec->strStaffCFName = $row->strCFName; $this->chapterRec->strStaffCLName = $row->strCLName; $this->chapterRec->strStaffLFName = $row->strLFName; $this->chapterRec->strStaffLLName = $row->strLLName; $this->chapterRec->vocabulary = new stdClass(); $this->chapterRec->vocabulary->vocZip = $row->ch_vocZip; $this->chapterRec->vocabulary->vocState = $row->ch_vocState; $this->chapterRec->vocabulary->vocJobSkills = $row->ch_vocJobSkills; $this->chapterRec->dteOrigin = $row->dteOrigin; $this->chapterRec->dteLastUpdate = $row->dteLastUpdate; } }
public function loadPContactsPatientTree($sqlWhereExtra, $sqlOrder, &$lNumPatients, &$pContacts) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $gstrPassPhrase; $lNumPatients = 0; $pContacts = array(); if ($sqlOrder == '') { $sqlOrder = ' cr_strLName, cr_strFName, cr_lKeyID, cc_strLName, cc_strFName, cc_lKeyID '; } $sqlStr = 'SELECT cr_lKeyID, cc_lKeyID, cc_lPatientID, lgRel.lgen_strListItem AS strRelationship, cc_lRelationshipID, cc_enumGender, AES_DECRYPT(cr_strFName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPatientFName, AES_DECRYPT(cr_strMName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPatientMName, AES_DECRYPT(cr_strLName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPatientLName, AES_DECRYPT(cc_strTitle, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPConTitle, AES_DECRYPT(cc_strFName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPConFName, AES_DECRYPT(cc_strMName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPConMName, AES_DECRYPT(cc_strLName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPConLName, AES_DECRYPT(cc_strAddr1, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strAddr1, AES_DECRYPT(cc_strAddr2, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strAddr2, AES_DECRYPT(cc_strCity, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strCity, AES_DECRYPT(cc_strState, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strState, AES_DECRYPT(cc_strCountry, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strCountry, AES_DECRYPT(cc_strZip, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strZip, AES_DECRYPT(cc_strPhone, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPhone, AES_DECRYPT(cc_strCell, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strCell, AES_DECRYPT(cc_strEmail, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strEmail, AES_DECRYPT(cc_strNotes, SHA2(' . strPrepStr($gstrPassPhrase) . ",256)) AS strNotes,\n\n cc_lOriginID, cc_lLastUpdateID, cc_dteOrigin, cc_dteLastUpdate\n FROM patient_records\n INNER JOIN patient_contacts ON cc_lPatientID = cr_lKeyID\n INNER JOIN lists_generic AS lgRel ON lgRel.lgen_lKeyID = cc_lRelationshipID\n WHERE NOT cr_bRetired AND NOT cc_bRetired\n {$sqlWhereExtra}\n ORDER BY {$sqlOrder};"; $query = $this->db->query($sqlStr); $numRows = $query->num_rows(); if ($numRows > 0) { $patientIDs = array(); $idx = 0; foreach ($query->result() as $row) { $lPID = (int) $row->cr_lKeyID; if (!isset($patientIDs[$lPID])) { $patientIDs[$lPID] = $idx; $pIDX = $idx; ++$idx; ++$lNumPatients; $pContacts[$pIDX] = new stdClass(); $pc =& $pContacts[$pIDX]; $pc->lNumContacts = 0; $pc->contacts = array(); $pc->lPatientID = (int) $row->cr_lKeyID; $pc->strPatientFName = $row->strPatientFName; $pc->strPatientMName = $row->strPatientMName; $pc->strPatientLName = $row->strPatientLName; } else { $pIDX = $patientIDs[$lPID]; } $pc->contacts[$pc->lNumContacts] = new stdClass(); $pcc =& $pc->contacts[$pc->lNumContacts]; $pcc->lContactID = $row->cc_lKeyID; $pcc->lPatientID = $row->cc_lPatientID; $pcc->lRelationshipID = $row->cc_lRelationshipID; $pcc->enumGender = $row->cc_enumGender; $pcc->strPConTitle = $row->strPConTitle; $pcc->strFName = $row->strPConFName; $pcc->strMName = $row->strPConMName; $pcc->strLName = $row->strPConLName; $pcc->strAddr1 = $row->strAddr1; $pcc->strAddr2 = $row->strAddr2; $pcc->strCity = $row->strCity; $pcc->strState = $row->strState; $pcc->strCountry = $row->strCountry; $pcc->strZip = $row->strZip; $pcc->strPhone = $row->strPhone; $pcc->strCell = $row->strCell; $pcc->strEmail = $row->strEmail; $pcc->strNotes = $row->strNotes; $pcc->strAddress = strBuildAddress($pcc->strAddr1, $pcc->strAddr2, $pcc->strCity, $pcc->strState, $pcc->strCountry, $pcc->strZip, true); $pcc->lOriginID = $row->cc_lOriginID; $pcc->lLastUpdateID = $row->cc_lLastUpdateID; $pcc->dteOrigin = $row->cc_dteOrigin; $pcc->dteLastUpdate = $row->cc_dteLastUpdate; $pcc->strRelationship = $row->strRelationship; ++$pc->lNumContacts; } } }
private function searchPeopleTableGeneric($bHofH, $bBiz, $enumSearchType, $bNewVol) { //----------------------------------------------------------------------- // //----------------------------------------------------------------------- $clsPeople = new mpeople(); if ($bHofH) { $strWhereHofH = ' AND pe_lKeyID=pe_lHouseholdID '; } else { $strWhereHofH = ''; } $strWhereVol = $strSelectVol = ''; if ($enumSearchType == CENUM_CONTEXT_VOLUNTEER) { $strSelectVol = ', vol_lKeyID, vol_bInactive '; if ($bNewVol) { $strInnerVol = ' LEFT JOIN volunteers ON pe_lKeyID=vol_lPeopleID '; $strWhereVol = ' AND ((vol_lKeyID IS NULL) OR (vol_bInactive)) '; } else { $strInnerVol = ' INNER JOIN volunteers ON pe_lKeyID=vol_lPeopleID '; } } else { $strInnerVol = ''; } $strWhereBiz = ' AND ' . ($bBiz ? '' : ' NOT ') . ' pe_bBiz '; $sqlStr = "SELECT\n pe_lKeyID, pe_strFName, pe_strLName, pe_strMName,\n pe_strPreferredName, pe_strTitle, pe_lHouseholdID,\n pe_strAddr1, pe_strAddr2, pe_strCity, pe_strState,\n pe_strCountry, pe_strZip\n {$strSelectVol}\n FROM people_names\n {$strInnerVol}\n WHERE 1\n AND NOT pe_bRetired\n {$strWhereHofH}\n {$strWhereBiz}\n {$strWhereVol}\n {$this->strWhereExtra}\n ORDER BY pe_strLName, pe_strFName, pe_lKeyID;"; $query = $this->db->query($sqlStr); $numRows = $query->num_rows(); if ($numRows > 0) { $idx = 0; foreach ($query->result() as $row) { $this->searchResults[$this->lNumSearchResults] = new stdClass(); $clsResult = $this->searchResults[$this->lNumSearchResults]; if ($enumSearchType == CENUM_CONTEXT_VOLUNTEER && !$bNewVol) { $clsResult->lKeyID = $row->vol_lKeyID; } else { $clsResult->lKeyID = $row->pe_lKeyID; } $clsResult->enumSearchType = $enumSearchType; switch ($enumSearchType) { case CENUM_CONTEXT_HOUSEHOLD: $clsResult->strResult = '<b>The ' . htmlspecialchars($row->pe_strFName . ' ' . $row->pe_strLName) . ' Household</b><br>' . strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true, true); break; case CENUM_CONTEXT_VOLUNTEER: $strSafeNameLF = htmlspecialchars(strBuildName(true, $row->pe_strTitle, $row->pe_strPreferredName, $row->pe_strFName, $row->pe_strLName, $row->pe_strMName)); $strFont = $strFontEnd = ''; if (!is_null($row->vol_lKeyID) && $row->vol_bInactive) { $strFont = '<font style="color: #777777"><i>'; $strFontEnd = '<br>(inactive volunteer)</i></font> '; } $clsResult->strResult = $strFont . '<b>' . $strSafeNameLF . "</b><br>\n" . strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true, true) . $strFontEnd; break; case CENUM_CONTEXT_PEOPLE: $strHousehold = $clsPeople->strHouseholdNameViaHID($row->pe_lHouseholdID); $strSafeNameLF = htmlspecialchars(strBuildName(true, $row->pe_strTitle, $row->pe_strPreferredName, $row->pe_strFName, $row->pe_strLName, $row->pe_strMName)); $clsResult->strResult = '<b>' . $strSafeNameLF . "</b><br>\n" . '<i>' . htmlspecialchars($strHousehold) . '</i><br>' . strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true, true); break; case CENUM_CONTEXT_BIZ: $clsResult->strResult = '<b>' . htmlspecialchars($row->pe_strLName) . '</b><br>' . strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true, true); break; default: screamForHelp($enumSearchType . ': invalid switch type<br>error on <b>line:</b> ' . __LINE__ . '<br><b>file: </b>' . __FILE__ . '<br><b>function: </b>' . __FUNCTION__); break; } ++$this->lNumSearchResults; ++$idx; } } }
public function searchSponsors(&$local) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $strDateFormat = strMysqlDateFormat(false); $sqlStr = "SELECT sp_lKeyID,\n sp_lClientID, sp_lSponsorProgramID, sp_bInactive,\n pe_lKeyID, pe_bBiz, pe_strFName, pe_strMName,\n pe_strLName, pe_strAddr1, pe_strAddr2, pe_strCity,\n pe_strState, pe_strCountry, pe_strZip,\n DATE_FORMAT(cr_dteBirth, {$strDateFormat}) AS strClientBDate, cr_enumGender,\n cr_strFName, cr_strLName, cl_strLocation, cl_strCountry,\n sc_strProgram\n FROM sponsor\n INNER JOIN people_names ON pe_lKeyID = sp_lForeignID\n INNER JOIN lists_sponsorship_programs ON sc_lKeyID = sp_lSponsorProgramID\n LEFT JOIN client_records ON cr_lKeyID = sp_lClientID\n LEFT JOIN client_location ON cr_lLocationID = cl_lKeyID\n WHERE NOT pe_bRetired AND NOT sp_bRetired\n {$this->strWhereExtra}\n ORDER BY pe_strLName, pe_strFName, pe_strMName, pe_lKeyID;"; $query = $local->db->query($sqlStr); $numRows = $query->num_rows(); $clsResult = new stdClass(); $clsResult->strResult = "\n\n\n\n"; if ($numRows > 0) { foreach ($query->result() as $row) { $bBiz = $row->pe_bBiz; $lSponID = $row->sp_lKeyID; $bInactive = $row->sp_bInactive; $this->searchResults[$this->lNumSearchResults] = new stdClass(); $clsResult = $this->searchResults[$this->lNumSearchResults]; $clsResult->lKeyID = $row->sp_lKeyID; if ($bInactive) { $strStart = '<span style="color: #999;">'; $strStop = '</span>'; } else { $strStart = $strStop = ''; } $clsResult->strResult .= $strStart; if ($bBiz) { $clsResult->strResult .= '<b>' . htmlspecialchars($row->pe_strLName) . '</b><br>'; } else { $clsResult->strResult .= '<b>' . htmlspecialchars($row->pe_strLName) . '</b>, ' . htmlspecialchars($row->pe_strFName) . "<br>\n"; } $clsResult->strResult .= strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true, true) . '<br>' . '<b>program:</b> ' . htmlspecialchars($row->sc_strProgram); if (is_null($row->sp_lClientID)) { $clsResult->strResult .= '<br>Client not set'; } else { $clsResult->strResult .= '<br><br>' . '<b>client:</b> ' . htmlspecialchars($row->cr_strLName . ', ' . $row->cr_strFName) . '<br>' . '<b>birthdate:</b> ' . $row->strClientBDate . '<br>' . '<b>gender:</b> ' . $row->cr_enumGender . '<br>' . '<b>location:</b> ' . htmlspecialchars($row->cl_strLocation . ' / ' . $row->cl_strCountry) . '<br>' . '<b>status:</b> ' . ($bInactive ? 'Inactive' : 'Active'); } $clsResult->strResult .= $strStop; ++$this->lNumSearchResults; } } }
private function strAttribRptSponsor(&$sRpt, $strLimit, $strAttrib, $strLabel) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $genumDateFormat; $this->load->model('sponsorship/msponsorship', 'clsSpon'); $params = array('enumStyle' => 'enpRptC'); $clsRpt = new generic_rpt($params); // $this->load->helper('dl_util/email_web'); $this->clsSpon->sponsorInfoGenericViaWhere(" AND sp_lAttributedTo {$strAttrib} ", $strLimit); $strOut = '<br>' . $clsRpt->openReport(); $strOut .= $clsRpt->writeTitle('Sponsorships ' . $strLabel, '', '', 7); $strOut .= $clsRpt->openRow(true); $strOut .= $clsRpt->writeLabel('SponsorID', 60) . $clsRpt->writeLabel('Active', 90) . $clsRpt->writeLabel('Sponsor', 150) . $clsRpt->writeLabel('Address') . $clsRpt->writeLabel('Client') . $clsRpt->writeLabel('Commitment') . $clsRpt->closeRow(); foreach ($this->clsSpon->sponInfo as $sponRec) { $lSponID = $sponRec->lKeyID; $lFID = $sponRec->lForeignID; if ($sponRec->bInactive) { $strIStyle = 'color: #999;'; $strActiveDates = 'sponsor dates: ' . date($genumDateFormat, $sponRec->dteStart) . ' - ' . date($genumDateFormat, $sponRec->dteInactive); } else { $strIStyle = ''; $strActiveDates = 'sponsor since: ' . date($genumDateFormat, $sponRec->dteStart); } $strOut .= $clsRpt->openRow(true); $strOut .= $clsRpt->writeCell(strLinkView_Sponsorship($lSponID, 'View sponsorship record', true) . ' ' . str_pad($lSponID, 5, '0', STR_PAD_LEFT), 60, $strIStyle); //--------------------------- // active state //--------------------------- $strOut .= $clsRpt->writeCell($strActiveDates, '', $strIStyle); if ($sponRec->bSponBiz) { $strLinkFID = 'business ID: ' . strLinkView_BizRecord($lFID, 'View business record', true); } else { $strLinkFID = 'people ID: ' . strLinkView_PeopleRecord($lFID, 'View people record', true); } $strLinkFID .= str_pad($lFID, 5, '0', STR_PAD_LEFT); //--------------------------- // sponsor name //--------------------------- $strHonoree = ''; if ($sponRec->bHonoree) { $lHFID = $sponRec->lHonoreeID; if ($sponRec->bHonBiz) { $strLinkHFID = 'business ID: ' . strLinkView_BizRecord($lHFID, 'View business record', true); } else { $strLinkHFID = 'people ID: ' . strLinkView_PeopleRecord($lHFID, 'View people record', true); } $strLinkHFID .= str_pad($lHFID, 5, '0', STR_PAD_LEFT); $strHonoree = '<br><br>Honoree: ' . $sponRec->strHonSafeNameLF . '<br>' . $strLinkHFID; } $strContact = '<b>' . $sponRec->strSponSafeNameLF . '</b>' . '<br>' . $strLinkFID . $strHonoree . '<br> program: ' . htmlspecialchars($sponRec->strSponProgram); $strOut .= $clsRpt->writeCell($strContact, '', $strIStyle); //--------------------------- // address / contact //--------------------------- $strAddr = strBuildAddress($sponRec->strSponAddr1, $sponRec->strSponAddr2, $sponRec->strSponCity, $sponRec->strSponState, $sponRec->strSponCountry, $sponRec->strSponZip, true); if ($sponRec->strSponEmail . '' != '') { $strAddr .= strBuildEmailLink($sponRec->strSponEmail, '<br>', false, ' style="' . $strIStyle . '"'); } $strPhone = strPhoneCell($sponRec->strSponPhone, $sponRec->strSponPhone, true, true); if ($strPhone != '') { $strAddr .= '<br>' . $strPhone; } $strOut .= $clsRpt->writeCell($strAddr, '', $strIStyle); //--------------------------- // client //--------------------------- $lClientID = $sponRec->lClientID; if (is_null($lClientID)) { if ($sponRec->bInactive) { $strClientInfo = '<i>Client not set</i>'; } else { $strClientInfo = '<i>Client not set</i><br>' . strLinkAdd_ClientToSpon($lSponID, 'Add client to sponsorship', false); } } else { $strClientInfo = '<b>' . $sponRec->strClientSafeNameLF . '</b><br>' . 'client ID: ' . strLinkView_ClientRecord($lClientID, 'View client record', true) . str_pad($lClientID, 5, '0', STR_PAD_LEFT) . '<br>' . htmlspecialchars($sponRec->strLocation) . '<br>' . 'birth/age: ' . $sponRec->strClientAgeBDay; $strClientInfo .= '<br>' . htmlspecialchars($sponRec->strLocation); } $strOut .= $clsRpt->writeCell($strClientInfo, '', $strIStyle); //--------------------------- // financial commitment //--------------------------- $strOut .= $clsRpt->writeCell($sponRec->strCommitACOCurSym . ' ' . number_format($sponRec->curCommitment, 2) . ' ' . $sponRec->strCommitACOFlagImg . '<br>' . strLinkView_SponsorFinancials($lSponID, 'View sponsorship financials', true) . strLinkView_SponsorFinancials($lSponID, 'View financials', false), '', $strIStyle); $strOut .= $clsRpt->closeRow(); } $strOut .= $clsRpt->closeReport(); return $strOut; }
function loadPeople($bIncludeSpon, $bIncludeGiftSum, $bPeople) { //------------------------------------------------------------------------------ // //------------------------------------------------------------------------------ $clsACO = new madmin_aco(); $this->people = array(); if ($bIncludeSpon) { $clsSpon = new msponsorship(); } $sqlStr = "SELECT\n pe_lKeyID,\n pe_lHouseholdID, pe_strTitle, pe_strFName,\n pe_strMName, pe_strLName, pe_strPreferredName,\n pe_strSalutation, pe_strAddr1, pe_strAddr2,\n pe_strCity, pe_strState, pe_strCountry,\n pe_strZip, pe_strPhone, pe_strCell, pe_strEmail,\n pe_enumGender, pe_strNotes, pe_bNoGiftAcknowledge,\n pe_lAttributedTo, pe_strImportID,\n pe_lOriginID, pe_lLastUpdateID,\n tblAttrib.lgen_strListItem AS strAttrib,\n\n pe_lACO, aco_strFlag, aco_strName, aco_strCurrencySymbol,\n\n pe_dteBirthDate,\n pe_dteDeathDate,\n usersC.us_strFirstName AS strCFName, usersC.us_strLastName AS strCLName,\n usersL.us_strFirstName AS strLFName, usersL.us_strLastName AS strLLName,\n pe_dteExpire,\n UNIX_TIMESTAMP(pe_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(pe_dteLastUpdate) AS dteLastUpdate\n FROM people_names\n INNER JOIN admin_users AS usersC ON pe_lOriginID = usersC.us_lKeyID\n INNER JOIN admin_users AS usersL ON pe_lLastUpdateID= usersL.us_lKeyID\n INNER JOIN admin_aco ON pe_lACO = aco_lKeyID\n {$this->sqlInnerExtra}\n LEFT JOIN lists_generic AS tblAttrib ON pe_lAttributedTo=tblAttrib.lgen_lKeyID\n\n WHERE 1\n {$this->sqlWhereExtra}\n AND " . ($bPeople ? 'NOT ' : '') . "pe_bBiz\n AND NOT pe_bRetired\n {$this->sqlOrderExtra}\n {$this->sqlLimitExtra};"; $query = $this->db->query($sqlStr); $this->lNumPeople = $query->num_rows(); if ($this->lNumPeople == 0) { $this->people[0] = new stdClass(); $pRec =& $this->people[0]; $pRec->lKeyID = $pRec->lHouseholdID = $pRec->bHOH = $pRec->strHouseholdName = $pRec->strTitle = $pRec->strFName = $pRec->strMName = $pRec->strLName = $pRec->strPreferredName = $pRec->strSafeName = $pRec->strSafeNameLF = null; $pRec->strSalutation = $pRec->strAddr1 = $pRec->strAddr2 = $pRec->strCity = $pRec->strState = $pRec->strCountry = $pRec->strZip = $pRec->strPhone = $pRec->strCell = $pRec->strAddress = null; $pRec->strEmail = $pRec->strEmailFormatted = $pRec->enumGender = $pRec->lACO = $pRec->strACO = $pRec->strCurSymbol = $pRec->strFlag = $pRec->strFlagImage = $pRec->bNoGiftAcknowledge = $pRec->lAttributedTo = $pRec->strAttrib = $pRec->lImportID = $pRec->strImportRecID = $pRec->dteExpire = $pRec->lOriginID = $pRec->lLastUpdateID = $pRec->dteMysqlBirthDate = $pRec->dteMysqlDeath = $pRec->dteOrigin = $pRec->dteLastUpdate = $pRec->strStaffCFName = $pRec->strStaffCLName = $pRec->strStaffLFName = $pRec->strStaffLLName = null; } else { $idx = 0; if ($bIncludeGiftSum) { $clsGifts = new mdonations(); $clsGifts->bUseDateRange = false; $clsGifts->cumulativeOpts = new stdClass(); $clsGifts->cumulativeOpts->enumCumulativeSource = 'people'; } foreach ($query->result() as $row) { $this->people[$idx] = new stdClass(); $pRec =& $this->people[$idx]; $pRec->lKeyID = $lPID = $row->pe_lKeyID; $pRec->lHouseholdID = $lHID = $row->pe_lHouseholdID; $pRec->bHOH = $lHID == $lPID; $pRec->strHouseholdName = $this->strHouseholdNameViaHID($lHID); $pRec->strTitle = $strTitle = $row->pe_strTitle; $pRec->strFName = $strFName = $row->pe_strFName; $pRec->strMName = $strMName = $row->pe_strMName; $pRec->strLName = $strLName = $row->pe_strLName; $pRec->strPreferredName = $strPreferred = $row->pe_strPreferredName; $pRec->strSafeName = htmlspecialchars(strBuildName(false, $strTitle, $strPreferred, $strFName, $strLName, $strMName)); $pRec->strSafeNameLF = htmlspecialchars(strBuildName(true, $strTitle, $strPreferred, $strFName, $strLName, $strMName)); $pRec->strSalutation = $row->pe_strSalutation; $pRec->strAddr1 = $row->pe_strAddr1; $pRec->strAddr2 = $row->pe_strAddr2; $pRec->strCity = $row->pe_strCity; $pRec->strState = $row->pe_strState; $pRec->strCountry = $row->pe_strCountry; $pRec->strZip = $row->pe_strZip; $pRec->strPhone = $row->pe_strPhone; $pRec->strCell = $row->pe_strCell; $pRec->strAddress = strBuildAddress($pRec->strAddr1, $pRec->strAddr2, $pRec->strCity, $pRec->strState, $pRec->strCountry, $pRec->strZip, true); $pRec->strEmail = $row->pe_strEmail; $pRec->strEmailFormatted = strBuildEmailLink($pRec->strEmail, '', false, ''); $pRec->enumGender = $row->pe_enumGender; $pRec->lACO = $row->pe_lACO; $pRec->strACO = $row->aco_strName; $pRec->strCurSymbol = $row->aco_strCurrencySymbol; $pRec->strFlag = $row->aco_strFlag; $pRec->strFlagImage = $clsACO->strFlagImage($pRec->strFlag, $pRec->strACO); $pRec->bNoGiftAcknowledge = $row->pe_bNoGiftAcknowledge; $pRec->lAttributedTo = $row->pe_lAttributedTo; $pRec->strAttrib = $row->strAttrib; $pRec->lImportID = $row->pe_strImportID; $pRec->strImportRecID = $row->pe_strImportID; $pRec->dteExpire = dteMySQLDate2Unix($row->pe_dteExpire); $pRec->lOriginID = $row->pe_lOriginID; $pRec->lLastUpdateID = $row->pe_lLastUpdateID; $pRec->dteMysqlBirthDate = $row->pe_dteBirthDate; $pRec->dteMysqlDeath = $row->pe_dteDeathDate; $pRec->strNotes = $row->pe_strNotes; $pRec->dteOrigin = $row->dteOrigin; $pRec->dteLastUpdate = $row->dteLastUpdate; $pRec->strStaffCFName = $row->strCFName; $pRec->strStaffCLName = $row->strCLName; $pRec->strStaffLFName = $row->strLFName; $pRec->strStaffLLName = $row->strLLName; //------------------- // sponsorship //------------------- if ($bIncludeSpon) { $clsSpon->sponsorshipInfoViaPID($lPID); $pRec->lNumSponsorship = $lNumSpons = $clsSpon->lNumSponsors; if ($lNumSpons == 0) { $pRec->sponInfo = null; } else { $pRec->sponInfo = $clsSpon->sponInfo; } } //------------------- // cumulative gifts //------------------- if ($bIncludeGiftSum) { $clsGifts->lPeopleID = $lPID; $clsGifts->cumulativeOpts->enumMoneySet = 'all'; $clsGifts->cumulativeOpts->bSoft = false; $clsGifts->cumulativeDonation($clsACO, $pRec->lTotHardGifts); $pRec->lNumACODonationGroups_hard = $clsGifts->lNumCumulative; $pRec->donationsViaACO_hard = $clsGifts->cumulative; $clsGifts->cumulativeOpts->bSoft = true; $clsGifts->cumulativeDonation($clsACO, $pRec->lTotSoftGifts); $pRec->lNumACODonationGroups_soft = $clsGifts->lNumCumulative; $pRec->donationsViaACO_soft = $clsGifts->cumulative; } else { $pRec->lNumACODonationGroups_hard = $pRec->donationsViaACO_hard = $pRec->lNumACODonationGroups_soft = $pRec->donationsViaACO_soft = null; } ++$idx; } } }
public function loadVolAssignmentsGeneric($strWhere) { //----------------------------------------------------------------------- // //----------------------------------------------------------------------- $this->vols = array(); $sqlStr = "SELECT\r\n vsa_lKeyID, vsa_lEventDateShiftID, vsa_lVolID,\r\n vsa_strNotes, vsa_dHoursWorked,\r\n vol_lPeopleID,\r\n pe_lHouseholdID, pe_strFName, pe_strLName,\r\n pe_strAddr1, pe_strAddr2, pe_strCity, pe_strState, pe_strCountry, pe_strZip,\r\n pe_strPhone, pe_strCell, pe_strEmail\r\n\r\n FROM vol_events_dates_shifts_assign\r\n INNER JOIN volunteers ON vsa_lVolID = vol_lKeyID\r\n INNER JOIN people_names ON vol_lPeopleID = pe_lKeyID\r\n WHERE\r\n NOT vsa_bRetired\r\n {$strWhere}\r\n ORDER BY pe_strLName, pe_strFName, vsa_lKeyID;"; $query = $this->db->query($sqlStr); $this->lNumVols = $numRows = $query->num_rows(); if ($numRows == 0) { $this->vols[0] = new stdClass(); $vol =& $this->vols[0]; $vol->lKeyID = $vol->lEventDateShiftID = $vol->lVolID = $vol->strNotes = $vol->dHoursWorked = $vol->lPeopleID = $vol->lHouseholdID = $vol->strFName = $vol->strLName = $vol->strSafeNameFL = $vol->strAddr1 = $vol->strAddr2 = $vol->strCity = $vol->strState = $vol->strCountry = $vol->strZip = $vol->strAddr = $vol->strPhone = $vol->strCell = $vol->strEmail = null; } else { $idx = 0; foreach ($query->result() as $row) { $this->vols[$idx] = new stdClass(); $vol =& $this->vols[$idx]; $vol->lKeyID = $row->vsa_lKeyID; $vol->lEventDateShiftID = $row->vsa_lEventDateShiftID; $vol->lVolID = $row->vsa_lVolID; $vol->strNotes = $row->vsa_strNotes; $vol->dHoursWorked = $row->vsa_dHoursWorked; $vol->lPeopleID = $row->vol_lPeopleID; $vol->lHouseholdID = $row->pe_lHouseholdID; $vol->strFName = $row->pe_strFName; $vol->strLName = $row->pe_strLName; $vol->strSafeNameFL = htmlspecialchars($row->pe_strFName . ' ' . $row->pe_strLName); $vol->strAddr1 = $row->pe_strAddr1; $vol->strAddr2 = $row->pe_strAddr2; $vol->strCity = $row->pe_strCity; $vol->strState = $row->pe_strState; $vol->strCountry = $row->pe_strCountry; $vol->strZip = $row->pe_strZip; $vol->strAddr = strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true); $vol->strPhone = $row->pe_strPhone; $vol->strCell = $row->pe_strCell; $vol->strEmail = $row->pe_strEmail; ++$idx; } } }
} $strLinkHFID .= str_pad($lHFID, 5, '0', STR_PAD_LEFT); $strHonoree = '<br><br>Honoree: ' . $sponRec->strHonSafeNameLF . '<br>' . $strLinkHFID; } } echoT(' <td class="enpRpt" style="width: 130pt;' . $strIStyle . '">' . '<b>' . $sponRec->strSponSafeNameLF . '</b>' . '<br>' . $strLinkFID . $strHonoree . '<br> program: ' . htmlspecialchars($sponRec->strSponProgram) . ' </td>'); } //--------------------------- // address / contact //--------------------------- if ($showFields->bAddress) { echoT(' <td class="enpRpt" style="width: 130pt;' . $strIStyle . '">' . strBuildAddress($sponRec->strSponAddr1, $sponRec->strSponAddr2, $sponRec->strSponCity, $sponRec->strSponState, $sponRec->strSponCountry, $sponRec->strSponZip, true)); if ($showFields->bPhoneEmail) { if ($sponRec->strSponEmail . '' != '') { echoT(strBuildEmailLink($sponRec->strSponEmail, '<br>', false, ' style="' . $strIStyle . '"')); } $strPhone = strPhoneCell($sponRec->strSponPhone, $sponRec->strSponPhone, true, true); if ($strPhone != '') { echoT('<br>' . $strPhone); } } echoT(' </td>'); } //--------------------------- // client //---------------------------
public function loadPatientsGeneric() { //----------------------------------------------------------------------- // //----------------------------------------------------------------------- global $glclsDTDateFormat, $gstrPassPhrase; $strOrder = $this->strClientOrder; if ($strOrder == '') { $strOrder = ' AES_DECRYPT(cr_strLName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)), AES_DECRYPT(cr_strFName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)), AES_DECRYPT(cr_strMName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)), cr_lKeyID '; } $sqlStr = 'SELECT cr_lKeyID, cr_bActive, cr_dteInactive, cr_dteEnrollment, cr_enumGender, AES_DECRYPT(cr_dteBirth, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS dteBirth, AES_DECRYPT(cr_dteDeath, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS dteDeath, AES_DECRYPT(cr_strTitle, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strTitle, AES_DECRYPT(cr_strFName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strFName, AES_DECRYPT(cr_strMName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strMName, AES_DECRYPT(cr_strLName, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strLName, AES_DECRYPT(cr_strAddr1, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strAddr1, AES_DECRYPT(cr_strAddr2, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strAddr2, AES_DECRYPT(cr_strCity, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strCity, AES_DECRYPT(cr_strState, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strState, AES_DECRYPT(cr_strCountry, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strCountry, AES_DECRYPT(cr_strZip, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strZip, AES_DECRYPT(cr_strPhone, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strPhone, AES_DECRYPT(cr_strCell, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strCell, AES_DECRYPT(cr_strEmail, SHA2(' . strPrepStr($gstrPassPhrase) . ',256)) AS strEmail, AES_DECRYPT(cr_strBio, SHA2(' . strPrepStr($gstrPassPhrase) . ",256)) AS strBio,\n\n cr_bRetired, cr_lOriginID, cr_lLastUpdateID,\n UNIX_TIMESTAMP(cr_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(cr_dteLastUpdate) AS dteLastUpdate,\n\n uc.us_strFirstName AS strUCFName, uc.us_strLastName AS strUCLName,\n ul.us_strFirstName AS strULFName, ul.us_strLastName AS strULLName\n\n FROM patient_records\n {$this->strInnerExtra}\n\n INNER JOIN admin_users AS uc ON uc.us_lKeyID=cr_lOriginID\n INNER JOIN admin_users AS ul ON ul.us_lKeyID=cr_lLastUpdateID\n\n WHERE 1\n AND NOT cr_bRetired\n\n {$this->strExtraClientWhere}\n ORDER BY {$strOrder}\n {$this->strClientLimit};"; $query = $this->db->query($sqlStr); $this->lNumPatients = $numRows = $query->num_rows(); $this->patients = array(); if ($numRows == 0) { $this->patients[0] = new stdClass(); $patient =& $this->patients[0]; $patient->lKeyID = $patient->strTitle = $patient->strFName = $patient->strMName = $patient->strLName = $patient->dteEnrollment = $patient->dteBirth = $patient->dteDeath = $patient->enumGender = $patient->strBio = $patient->bRetired = $patient->lOriginID = $patient->lLastUpdateID = $patient->dteOrigin = $patient->dteLastUpdate = $patient->strAddr1 = $patient->strAddr2 = $patient->strCity = $patient->strState = $patient->strCountry = $patient->strZip = $patient->strPhone = $patient->strCell = $patient->strEmail = $patient->strAddress = null; } else { $idx = 0; foreach ($query->result() as $row) { $this->patients[$idx] = new stdClass(); $patient =& $this->patients[$idx]; $patient->lKeyID = (int) $row->cr_lKeyID; $patient->strTitle = $row->strTitle; $patient->strFName = $row->strFName; $patient->strMName = $row->strMName; $patient->strLName = $row->strLName; $patient->strSafeName = htmlspecialchars($row->strFName . ' ' . $row->strMName . ' ' . $row->strLName); $patient->strSafeNameLF = htmlspecialchars($row->strLName . ', ' . $row->strFName . ' ' . $row->strMName); $patient->dteEnrollment = dteMySQLDate2Unix($row->cr_dteEnrollment); $patient->dteBirth = $mySQLdteBirth = $row->dteBirth; $patient->dteDeath = $row->dteDeath; $patient->enumGender = $row->cr_enumGender; $patient->bActive = (bool) $row->cr_bActive; $patient->mdteInactive = $row->cr_dteInactive; //------------------------------ // client address/contact //------------------------------ $patient->strAddr1 = $row->strAddr1; $patient->strAddr2 = $row->strAddr2; $patient->strCity = $row->strCity; $patient->strState = $row->strState; $patient->strCountry = $row->strCountry; $patient->strZip = $row->strZip; $patient->strPhone = $row->strPhone; $patient->strCell = $row->strCell; $patient->strEmail = $row->strEmail; $patient->strEmailFormatted = strBuildEmailLink($patient->strEmail, '', false, ''); $patient->strAddress = strBuildAddress($patient->strAddr1, $patient->strAddr2, $patient->strCity, $patient->strState, $patient->strCountry, $patient->strZip, true); /* //------------------------------ // client age/birth day info //------------------------------ if (is_null($mySQLdteBirth)){ $patient->objClientBirth = null; $patient->lAgeYears = null; $patient->strClientAgeBDay = '(age n/a)'; }else { $patient->objClientBirth = new dl_date_time; $patient->objClientBirth->setDateViaMySQL(0, $mySQLdteBirth); $patient->strClientAgeBDay = $patient->objClientBirth->strPeopleAge(0, $mySQLdteBirth, $patient->lAgeYears, $glclsDTDateFormat); } */ $patient->strBio = $row->strBio; $patient->bRetired = $row->cr_bRetired; $patient->lOriginID = $row->cr_lOriginID; $patient->lLastUpdateID = $row->cr_lLastUpdateID; $patient->dteOrigin = $row->dteOrigin; $patient->dteLastUpdate = $row->dteLastUpdate; $patient->ucstrFName = $row->strUCFName; $patient->ucstrLName = $row->strUCLName; $patient->ulstrFName = $row->strULFName; $patient->ulstrLName = $row->strULLName; ++$idx; } } if ($this->bDebug) { $this->dumpClientRecs(); } }
private function strJobSkillsRptHTML() { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $strOut = '<table class="enpRptC"> <tr> <td class="enpRptLabel"> volunteerID </td> <td class="enpRptLabel"> peopleID </td> <td class="enpRptLabel"> Name </td> <td class="enpRptLabel"> Address </td> <td class="enpRptLabel"> Phone/Email </td> <td class="enpRptLabel"> Job Skills </td> </tr>' . "\n"; $sqlStr = "SELECT\n vol_lKeyID, pe_lKeyID, vol_bInactive,\n pe_strLName, pe_strFName, pe_strAddr1, pe_strAddr2,\n pe_strCity, pe_strState, pe_strCountry, pe_strZip, pe_strPhone, pe_strCell, pe_strEmail\n FROM tmpGroupMatch\n INNER JOIN volunteers ON vol_lKeyID = gm_lForeignID\n INNER JOIN people_names ON vol_lPeopleID = pe_lKeyID\n ORDER BY gm_lKeyID;"; $query = $this->db->query($sqlStr); foreach ($query->result() as $row) { $lVolID = $this->lVolID = $row->vol_lKeyID; $lPID = $row->pe_lKeyID; $this->loadVolSkills(false); if ($row->vol_bInactive) { $strInactive = '<br>(inactive)'; } else { $strInactive = ''; } if ($row->pe_strEmail . '' == '') { $strEmail = ''; } else { $strEmail = '<br>' . mailto($row->pe_strEmail, $row->pe_strEmail); } /* tip for preventing that pesky line break before a list http://stackoverflow.com/questions/1682873/how-do-i-prevent-a-line-break-occurring-before-an-unordered-list ul.errorlist {list-style-type: none; display:inline; margin-left: 0; padding-left: 0;} ul.errorlist li {display: inline; color:red; font-size: 0.8em; margin-left: 0px; padding-left: 10px;} */ $strSkillList = '<ul style="list-style-type: square; display:inline; margin-left: 0; padding-left: 0;">'; foreach ($this->singleVolSkills as $skill) { $strSkillList .= '<li style="margin-left: 20px; padding-left: 3px;">' . htmlspecialchars($skill->strSkill) . '</li>'; } $strSkillList .= '</ul>'; $strOut .= '<tr> <td class="enpRpt" style="width: 65px;">' . strLinkView_Volunteer($lVolID, 'View volunteer record', true) . ' ' . str_pad($lVolID, 5, '0', STR_PAD_LEFT) . $strInactive . ' </td> <td class="enpRpt" style="width: 65px;">' . strLinkView_PeopleRecord($lPID, 'View people record', true) . ' ' . str_pad($lPID, 5, '0', STR_PAD_LEFT) . ' </td> <td class="enpRpt" style="width: 160px;">' . htmlspecialchars($row->pe_strLName . ', ' . $row->pe_strFName) . ' </td> <td class="enpRpt" style="width: 200px;">' . strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true) . ' </td> <td class="enpRpt" style="width: 120px;">' . htmlspecialchars(strPhoneCell($row->pe_strPhone, $row->pe_strCell)) . $strEmail . ' </td> <td class="enpRpt" style="width: 200px;">' . $strSkillList . ' </td> </tr>' . "\n"; $strOut .= '</tr>' . "\n"; } $strOut .= '</table>' . "\n"; return $strOut; }
public function sponsorInfoGenericViaWhere($strWhere, $strLimit) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- if ($this->strOrderBy == '') { $strOrder = 'tblPeopleSpon.pe_strLName, tblPeopleSpon.pe_strFName, tblPeopleSpon.pe_lKeyID, cr_strLName, cr_strFName, sp_lClientID, sp_lKeyID '; } else { $strOrder = $this->strOrderBy; } $sqlStr = "SELECT\n sp_lKeyID, sp_lClientID,\n sp_lForeignID, sp_lHonoreeID, sp_bInactive,\n sp_lSponsorProgramID, sp_lDefPayType, sp_curCommitment, sp_lCommitmentACO,\n aco_strFlag, aco_strCurrencySymbol, aco_strName,\n\n sp_dteStartMoYr, sp_dteInactive, sp_lInactiveCatID,\n\n sp_strTerminationNote, sp_bInactiveDueToXfer,\n listInactive.lgen_strListItem AS strSponTermType,\n\n tblPeopleSpon.pe_strLName AS strLName_Spon, tblPeopleSpon.pe_strFName AS strFName_Spon,\n tblPeopleSpon.pe_strMName AS strMName_Spon, tblPeopleSpon.pe_bRetired AS bSponRetired,\n tblPeopleSpon.pe_strAddr1 AS strSponAddr1, tblPeopleSpon.pe_strAddr2 AS strSponAddr2,\n tblPeopleSpon.pe_strCity AS strSponCity, tblPeopleSpon.pe_strState AS strSponState,\n tblPeopleSpon.pe_strZip AS strSponZip, tblPeopleSpon.pe_strCountry AS strSponCountry,\n tblPeopleSpon.pe_strEmail AS strSponEmail,\n tblPeopleSpon.pe_strPhone AS strSponPhone,\n tblPeopleSpon.pe_strCell AS strSponCell,\n tblPeopleSpon.pe_strPreferredName AS strSponPName, tblPeopleSpon.pe_strTitle AS strSponTitle,\n\n tblPeopleSpon.pe_bBiz AS bSponBiz,\n\n tblPeopleHon.pe_strLName AS strLName_Hon, tblPeopleHon.pe_strFName AS strFName_Hon,\n tblPeopleHon.pe_strMName AS strMName_Hon, tblPeopleHon.pe_bRetired AS bHonRetired,\n tblPeopleHon.pe_strAddr1 AS strHonAddr1, tblPeopleHon.pe_strAddr2 AS strHonAddr2,\n tblPeopleHon.pe_strCity AS strHonCity, tblPeopleHon.pe_strState AS strHonState,\n tblPeopleHon.pe_strZip AS strHonZip, tblPeopleHon.pe_strCountry AS strHonCountry,\n tblPeopleHon.pe_strEmail AS strHonEmail,\n tblPeopleHon.pe_strPhone AS strHonPhone,\n tblPeopleHon.pe_strCell AS strHonCell,\n tblPeopleHon.pe_strPreferredName AS strHonPName, tblPeopleHon.pe_strTitle AS strHonTitle,\n\n tblPeopleHon.pe_bBiz AS bHonBiz,\n\n sp_lAttributedTo,\n listAttrib.lgen_strListItem AS strAttributedTo,\n\n cr_strFName, cr_strLName, cr_dteBirth, cr_lLocationID,\n cr_enumGender,\n cl_strLocation, cl_strCountry,\n cr_bRetired,\n sc_strProgram,\n\n UNIX_TIMESTAMP(sp_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(sp_dteLastUpdate) AS dteLastUpdate,\n uc.us_strFirstName AS strUCFName, uc.us_strLastName AS strUCLName,\n ul.us_strFirstName AS strULFName, ul.us_strLastName AS strULLName\n\n FROM sponsor\n INNER JOIN people_names AS tblPeopleSpon ON sp_lForeignID = tblPeopleSpon.pe_lKeyID\n INNER JOIN admin_users AS uc ON uc.us_lKeyID=sp_lOriginID\n INNER JOIN admin_users AS ul ON ul.us_lKeyID=sp_lLastUpdateID\n INNER JOIN admin_aco ON aco_lKeyID = sp_lCommitmentACO\n LEFT JOIN people_names AS tblPeopleHon ON sp_lHonoreeID = tblPeopleHon.pe_lKeyID\n LEFT JOIN client_records ON cr_lKeyID = sp_lClientID\n LEFT JOIN client_location ON cr_lLocationID = cl_lKeyID\n LEFT JOIN lists_sponsorship_programs ON sp_lSponsorProgramID = sc_lKeyID\n LEFT JOIN lists_generic AS listInactive ON sp_lInactiveCatID = listInactive.lgen_lKeyID\n LEFT JOIN lists_generic AS listAttrib ON sp_lAttributedTo = listAttrib.lgen_lKeyID\n\n WHERE NOT sp_bRetired\n {$strWhere}\n ORDER BY {$strOrder}\n {$strLimit};"; $query = $this->db->query($sqlStr); $this->lNumSponsors = $numRows = $query->num_rows(); if ($numRows == 0) { $this->sponInfo[0] = new stdClass(); $sRec =& $this->sponInfo[0]; $sRec->lKeyID = $sRec->lForeignID = $sRec->strSponsorFName = $sRec->strSponsorMName = $sRec->strSponsorLName = $sRec->bSponBiz = $sRec->strSponSafeNameFL = $sRec->strSponSafeNameLF = $sRec->bPersonRetired = $sRec->bClientRetired = $sRec->bHonoreeRetired = $sRec->lHonoreeID = $sRec->strSponsorFNameHon = $sRec->strSponsorMNameHon = $sRec->strSponsorLNameHon = $sRec->bHonBiz = $sRec->strHonSafeNameFL = $sRec->strHonSafeNameLF = $sRec->strSFConID_Spon = $sRec->strSFConID_Hon = $sRec->lClientID = $sRec->lItemID = $sRec->lSponsorProgID = $sRec->strSponProgram = $sRec->lAttributedTo = $sRec->strAttributedTo = $sRec->strClientFName = $sRec->strClientLName = $sRec->strClientSafeNameFL = $sRec->strClientSafeNameLF = $sRec->dteClientBDayMySQL = $sRec->strGender = $sRec->strLocationName = $sRec->strLocationCountry = $sRec->dteStart = $sRec->bInactive = $sRec->dteInactive = $sRec->lInactiveCatID = $sRec->strInactiveCat = $sRec->bInactiveViaXfer = $sRec->lDefPaymentType = $sRec->curCommitment = $sRec->lCommitACO = $sRec->objClientBirth = $sRec->strAgeBDay = $sRec->dteOrigin = $sRec->dteLastUpdate = $sRec->ucstrFName = $sRec->ucstrLName = $sRec->ulstrFName = $sRec->ulstrLName = null; } else { $idx = 0; foreach ($query->result() as $row) { $this->sponInfo[$idx] = new stdClass(); $sRec =& $this->sponInfo[$idx]; $sRec->lKeyID = $row->sp_lKeyID; $sRec->lForeignID = $row->sp_lForeignID; $sRec->strSponsorFName = $row->strFName_Spon; $sRec->strSponsorMName = $row->strMName_Spon; $sRec->strSponsorLName = $row->strLName_Spon; $sRec->strSponsorPName = $row->strSponPName; $sRec->strSponTitle = $row->strSponTitle; $sRec->bSponBiz = $row->bSponBiz; if ($row->bSponBiz) { $sRec->strSponSafeNameFL = $sRec->strSponSafeNameLF = htmlspecialchars($sRec->strSponsorLName); } else { $sRec->strSponSafeNameFL = htmlspecialchars(strBuildName(false, $sRec->strSponTitle, $sRec->strSponsorPName, $sRec->strSponsorFName, $sRec->strSponsorLName, $sRec->strSponsorMName)); $sRec->strSponSafeNameLF = htmlspecialchars(strBuildName(true, $sRec->strSponTitle, $sRec->strSponsorPName, $sRec->strSponsorFName, $sRec->strSponsorLName, $sRec->strSponsorMName)); } $sRec->bPersonRetired = (bool) $row->bSponRetired; $sRec->bClientRetired = (bool) $row->cr_bRetired; $sRec->bHonoreeRetired = (bool) $row->bHonRetired; $sRec->lHonoreeID = $row->sp_lHonoreeID; $sRec->bHonoree = !is_null($row->sp_lHonoreeID); $sRec->strSponsorFNameHon = $row->strFName_Hon; $sRec->strSponsorMNameHon = $row->strMName_Hon; $sRec->strSponsorLNameHon = $row->strLName_Hon; $sRec->bHonBiz = $row->bHonBiz; $sRec->strHonPName = $row->strHonPName; $sRec->strHonTitle = $row->strHonTitle; if ($row->bHonBiz) { $sRec->strHonSafeNameFL = $sRec->strHonSafeNameLF = htmlspecialchars($sRec->strSponsorLName); } else { $sRec->strHonSafeNameFL = htmlspecialchars(strBuildName(false, $sRec->strHonTitle, $sRec->strHonPName, $sRec->strSponsorFNameHon, $sRec->strSponsorLNameHon, $sRec->strSponsorMNameHon)); // htmlspecialchars($sRec->strSponsorFNameHon.' ' .$sRec->strSponsorLNameHon); $sRec->strHonSafeNameLF = htmlspecialchars(strBuildName(true, $sRec->strHonTitle, $sRec->strHonPName, $sRec->strSponsorFNameHon, $sRec->strSponsorLNameHon, $sRec->strSponsorMNameHon)); // htmlspecialchars($sRec->strSponsorLNameHon.', '.$sRec->strSponsorFNameHon); } //------------------------------ // sponsor contact info //------------------------------ $sRec->strSponAddr1 = $row->strSponAddr1; $sRec->strSponAddr2 = $row->strSponAddr2; $sRec->strSponCity = $row->strSponCity; $sRec->strSponState = $row->strSponState; $sRec->strSponZip = $row->strSponZip; $sRec->strSponCountry = $row->strSponCountry; $sRec->strSponEmail = $row->strSponEmail; $sRec->strSponPhone = $row->strSponPhone; $sRec->strAddr = strBuildAddress($row->strSponAddr1, $row->strSponAddr2, $row->strSponCity, $row->strSponState, $row->strSponCountry, $row->strSponZip, true); //------------------------------ // honoree contact info //------------------------------ $sRec->strHonAddr1 = $row->strHonAddr1; $sRec->strHonAddr2 = $row->strHonAddr2; $sRec->strHonCity = $row->strHonCity; $sRec->strHonState = $row->strHonState; $sRec->strHonZip = $row->strHonZip; $sRec->strHonCountry = $row->strHonCountry; $sRec->strHonEmail = $row->strHonEmail; $sRec->strHonPhone = $row->strHonPhone; $sRec->lClientID = $row->sp_lClientID; $sRec->lSponsorProgID = $row->sp_lSponsorProgramID; $sRec->strSponProgram = $row->sc_strProgram; $sRec->lAttributedTo = $row->sp_lAttributedTo; $sRec->strAttributedTo = $row->strAttributedTo; $sRec->strClientFName = $row->cr_strFName . ''; $sRec->strClientLName = $row->cr_strLName . ''; if (is_null($sRec->lClientID)) { $sRec->strClientSafeNameFL = $sRec->strClientSafeNameLF = null; } else { $sRec->strClientSafeNameFL = htmlspecialchars($row->cr_strFName . ' ' . $row->cr_strLName); $sRec->strClientSafeNameLF = htmlspecialchars($row->cr_strLName . ', ' . $row->cr_strFName); } $sRec->dteClientBDayMySQL = $row->cr_dteBirth; $sRec->enumGender = $row->cr_enumGender; $sRec->strLocation = $row->cl_strLocation . ''; $sRec->strLocationCountry = $row->cl_strCountry . ''; $sRec->dteStart = dteMySQLDate2Unix($row->sp_dteStartMoYr); $sRec->bInactive = (bool) $row->sp_bInactive; $sRec->dteInactive = dteMySQLDate2Unix($row->sp_dteInactive); $sRec->lInactiveCatID = $row->sp_lInactiveCatID; $sRec->strSponTermType = $row->strSponTermType; $sRec->bInactiveViaXfer = (bool) $row->sp_bInactiveDueToXfer; $sRec->lDefPaymentType = $row->sp_lDefPayType; $sRec->curCommitment = $row->sp_curCommitment; $sRec->lCommitACO = $row->sp_lCommitmentACO; $sRec->strCommitACOFlagImg = '<img src="' . DL_IMAGEPATH . '/flags/' . $row->aco_strFlag . '" alt="flag icon" title="' . $row->aco_strName . '">'; $sRec->strCommitACOCurSym = $row->aco_strCurrencySymbol; $sRec->strCommitACOName = $row->aco_strName; //------------------------------ // client age/birth day info //------------------------------ if (is_null($sRec->dteClientBDayMySQL)) { $sRec->objClientBirth = null; $sRec->strClientAgeBDay = 'n/a'; } else { $sRec->objClientBirth = new dl_date_time(); $sRec->objClientBirth->setDateViaMySQL(0, $sRec->dteClientBDayMySQL); $sRec->strClientAgeBDay = $sRec->objClientBirth->strPeopleAge(0, $sRec->dteClientBDayMySQL, $lAgeYears); } $sRec->dteOrigin = $row->dteOrigin; $sRec->dteLastUpdate = $row->dteLastUpdate; $sRec->ucstrFName = $row->strUCFName; $sRec->ucstrLName = $row->strUCLName; $sRec->ulstrFName = $row->strULFName; $sRec->ulstrLName = $row->strULLName; ++$idx; } } }
function showSponHonInfo(&$clsRpt, $lSponID, &$sponRec, $bInactive) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- if ($bInactive) { $strLink = ''; } else { if ($sponRec->bHonoree) { $strLink = strLinkRem_SponsorHonoree($lSponID, 'Remove honoree', true, true) . ' ' . strLinkRem_SponsorHonoree($lSponID, 'Remove honoree', false, true); } else { $strLink = strLinkAdd_SponHonoree($lSponID, 'Add sponsorship honoree', true) . ' ' . strLinkAdd_SponHonoree($lSponID, 'Add sponsorship honoree', false); } } $attributes = new stdClass(); $attributes->lTableWidth = 900; $attributes->divID = 'sponHon'; $attributes->divImageID = 'sponHonDivImg'; openBlock('Honoree Info', $strLink, $attributes); if ($sponRec->bHonoree) { $lHonFID = $sponRec->lHonoreeID; if ($sponRec->bHonBiz) { $strLinkHon = strLinkView_Biz($lHonFID, 'View business record', true); } else { $strLinkHon = strLinkView_PeopleRecord($lHonFID, 'View people record', true); } echoT($clsRpt->openReport()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Honoree:') . $clsRpt->writeCell($strLinkHon . $sponRec->strHonSafeNameFL) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Address:') . $clsRpt->writeCell(strBuildAddress($sponRec->strHonAddr1, $sponRec->strHonAddr2, $sponRec->strHonCity, $sponRec->strHonState, $sponRec->strHonCountry, $sponRec->strHonZip, true)) . $clsRpt->closeRow()); echoT($clsRpt->closeReport('')); } else { echoT('<i>There is no honoree associated with this sponsorship</i>'); } $attributes = new stdClass(); $attributes->bCloseDiv = true; closeBlock($attributes); }
function loadGrantProviders($sqlWhere, $sqlOrder, &$lNumProviders, &$providers) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $providers = array(); $strOrder = $sqlOrder; if ($strOrder == '') { $strOrder = ' gpr_strGrantOrg, gpr_lKeyID '; } $sqlStr = "SELECT\n gpr_lKeyID, gpr_strGrantOrg, gpr_strAddr1, gpr_strAddr2, gpr_strCity,\n gpr_strState, gpr_strCountry, gpr_strZip, gpr_strPhone, gpr_strCell,\n gpr_strFax, gpr_strWebSite, gpr_strEmail, gpr_strNotes,\n\n gpr_lAttributedTo, lgen_strListItem AS strAttributedTo,\n\n -- gpr_lACO, aco_strFlag, aco_strName, aco_strCurrencySymbol,\n\n gpr_bHidden, gpr_lOriginID, gpr_lLastUpdateID,\n UNIX_TIMESTAMP(gpr_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(gpr_dteLastUpdate) AS dteLastUpdate,\n\n uc.us_strFirstName AS strCFName, uc.us_strLastName AS strCLName,\n ul.us_strFirstName AS strLFName, ul.us_strLastName AS strLLName\n\n FROM grant_providers\n INNER JOIN admin_users AS uc ON uc.us_lKeyID=gpr_lOriginID\n INNER JOIN admin_users AS ul ON ul.us_lKeyID=gpr_lLastUpdateID\n -- INNER JOIN admin_aco ON gpr_lACO = aco_lKeyID\n\n LEFT JOIN lists_generic ON gpr_lAttributedTo=lgen_lKeyID\n WHERE NOT gpr_bRetired {$sqlWhere}\n ORDER BY {$strOrder} "; $query = $this->db->query($sqlStr); $lNumProviders = $query->num_rows(); if ($lNumProviders == 0) { $providers[0] = new stdClass(); $pr =& $providers[0]; $pr->lKeyID = $pr->strGrantOrg = $pr->strAddr1 = $pr->strAddr2 = $pr->strCity = $pr->strState = $pr->strCountry = $pr->strZip = $pr->strPhone = $pr->strCell = $pr->strFax = $pr->strWebSite = $pr->strEmail = $pr->strNotes = $pr->lAttributedTo = $pr->strAttributedTo = $pr->strACOFlag = $pr->strACOName = $pr->strCurrencySymbol = $pr->gpr_bHidden = $pr->lOriginID = $pr->lLastUpdateID = $pr->ucstrFName = $pr->ucstrLName = $pr->ulstrFName = $pr->ulstrLName = $pr->dteOrigin = $pr->dteLastUpdate = $pr->strAddress = null; } else { $idx = 0; foreach ($query->result() as $row) { $providers[$idx] = new stdClass(); $pr =& $providers[$idx]; $pr->lKeyID = (int) $row->gpr_lKeyID; $pr->strGrantOrg = $row->gpr_strGrantOrg; $pr->strAddr1 = $row->gpr_strAddr1; $pr->strAddr2 = $row->gpr_strAddr2; $pr->strCity = $row->gpr_strCity; $pr->strState = $row->gpr_strState; $pr->strCountry = $row->gpr_strCountry; $pr->strZip = $row->gpr_strZip; $pr->strPhone = $row->gpr_strPhone; $pr->strCell = $row->gpr_strCell; $pr->strFax = $row->gpr_strFax; $pr->strWebSite = $row->gpr_strWebSite; $pr->strEmail = $row->gpr_strEmail; $pr->strNotes = $row->gpr_strNotes; $pr->lAttributedTo = $row->gpr_lAttributedTo; $pr->strAttributedTo = $row->strAttributedTo; $pr->bHidden = (bool) $row->gpr_bHidden; $pr->lOriginID = (int) $row->gpr_lOriginID; $pr->lLastUpdateID = (int) $row->gpr_lLastUpdateID; $pr->ucstrFName = $row->strCFName; $pr->ucstrLName = $row->strCLName; $pr->ulstrFName = $row->strLFName; $pr->ulstrLName = $row->strLLName; $pr->dteOrigin = (int) $row->dteOrigin; $pr->dteLastUpdate = (int) $row->dteLastUpdate; $pr->strAddress = strBuildAddress($pr->strAddr1, $pr->strAddr2, $pr->strCity, $pr->strState, $pr->strCountry, $pr->strZip, true); ++$idx; } } }
private function strPeopleBasedGroupRptHTML($enumContext) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- switch ($enumContext) { case CENUM_CONTEXT_PEOPLE: $strIDLabel = 'PeopleID'; $strInner = ' INNER JOIN people_names ON pe_lKeyID=gm_lForeignID '; $strFID = ' pe_lKeyID AS lFID '; break; case CENUM_CONTEXT_BIZ: $strIDLabel = 'businessID'; $strInner = ' INNER JOIN people_names ON pe_lKeyID=gm_lForeignID '; $strFID = ' pe_lKeyID AS lFID '; break; case CENUM_CONTEXT_VOLUNTEER: $strIDLabel = 'volunteerID'; $strInner = ' INNER JOIN volunteers ON vol_lKeyID = gm_lForeignID ' . ' INNER JOIN people_names ON vol_lPeopleID = pe_lKeyID '; $strFID = ' pe_lKeyID, vol_lKeyID AS lFID '; break; case CENUM_CONTEXT_SPONSORSHIP: $strIDLabel = 'sponsorID'; $strInner = ' INNER JOIN sponsor ON sp_lKeyID = gm_lForeignID ' . ' INNER JOIN people_names ON sp_lForeignID = pe_lKeyID '; $strFID = ' pe_lKeyID, sp_lKeyID AS lFID '; break; default: screamForHelp($enumContext . ': group type not yet available<br>error on <b>line:</b> ' . __LINE__ . '<br><b>file: </b>' . __FILE__ . '<br><b>function: </b>' . __FUNCTION__); break; } $strOut = '<table class="enpRptC"> <tr> <td class="enpRptLabel">' . $strIDLabel . ' </td> <td class="enpRptLabel"> Name </td> <td class="enpRptLabel"> Address </td> <td class="enpRptLabel"> Phone/Email </td> <td class="enpRptLabel"> Group Membership </td> </tr>' . "\n"; $sqlStr = "SELECT\n {$strFID},\n pe_strLName, pe_strFName, pe_strAddr1, pe_strAddr2,\n pe_strCity, pe_strState, pe_strCountry, pe_strZip, pe_strPhone, pe_strCell, pe_strEmail\n FROM tmpGroupMatch\n {$strInner}\n ORDER BY gm_lKeyID;"; $query = $this->db->query($sqlStr); foreach ($query->result() as $row) { $lFID = $row->lFID; if ($row->pe_strEmail . '' == '') { $strEmail = ''; } else { $strEmail = '<br>' . mailto($row->pe_strEmail, $row->pe_strEmail); } $this->groupMembershipViaFID($enumContext, $lFID); /* tip for preventing that pesky line break before a list http://stackoverflow.com/questions/1682873/how-do-i-prevent-a-line-break-occurring-before-an-unordered-list ul.errorlist {list-style-type: none; display:inline; margin-left: 0; padding-left: 0;} ul.errorlist li {display: inline; color:red; font-size: 0.8em; margin-left: 0px; padding-left: 10px;} */ $strGroupList = '<ul style="list-style-type: square; display:inline; margin-left: 0; padding-left: 0;">'; foreach ($this->arrMemberInGroups as $grpMember) { $strGroupList .= '<li style="margin-left: 20px; padding-left: 3px;">' . htmlspecialchars($grpMember->strGroupName) . '</li>'; } $strGroupList .= '</ul>'; switch ($enumContext) { case CENUM_CONTEXT_PEOPLE: $strLink = strLinkView_PeopleRecord($lFID, 'View people record', true) . ' '; break; case CENUM_CONTEXT_BIZ: $strLink = strLinkView_BizRecord($lFID, 'View people record', true) . ' '; break; case CENUM_CONTEXT_VOLUNTEER: $strLink = strLinkView_Volunteer($lFID, 'View volunteer record', true) . ' '; break; case CENUM_CONTEXT_SPONSORSHIP: $strLink = strLinkView_Sponsorship($lFID, 'View sponsor record', true) . ' '; break; default: screamForHelp($enumContext . ': group type not yet available<br>error on <b>line:</b> ' . __LINE__ . '<br><b>file: </b>' . __FILE__ . '<br><b>function: </b>' . __FUNCTION__); break; } $bBiz = $enumContext == CENUM_CONTEXT_BIZ; $strOut .= '<tr class="makeStripe"> <td class="enpRpt" style="width: 65px;">' . $strLink . str_pad($lFID, 5, '0', STR_PAD_LEFT) . ' </td> <td class="enpRpt" style="width: 160px;">' . htmlspecialchars($row->pe_strLName . ($bBiz ? '' : ', ' . $row->pe_strFName)) . ' </td> <td class="enpRpt" style="width: 200px;">' . strBuildAddress($row->pe_strAddr1, $row->pe_strAddr2, $row->pe_strCity, $row->pe_strState, $row->pe_strCountry, $row->pe_strZip, true) . ' </td> <td class="enpRpt" style="width: 120px;">' . htmlspecialchars(strPhoneCell($row->pe_strPhone, $row->pe_strCell)) . $strEmail . ' </td> <td class="enpRpt" style="width: 200px;">' . $strGroupList . ' </td> </tr>' . "\n"; $strOut .= '</tr>' . "\n"; } $strOut .= '</table>' . "\n"; return $strOut; }
public function loadUserRec() { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- if (is_null($this->us_lKeyID)) { screamForHelp('Uninitialized class!</b><br>error on <b>line:</b> ' . __LINE__ . '<br><b>file:</b> ' . __FILE__ . '<br><b>function:</b> ' . __FUNCTION__); } $sqlStr = "SELECT\n userBase.us_lKeyID, userBase.us_bInactive,\n userBase.us_lOriginID, userBase.us_lLastUpdateID, userBase.us_strUserName,\n userBase.us_bAdmin, userBase.us_bVolAccount,\n\n userBase.us_bVolEditContact, userBase.us_bVolPassReset,\n userBase.us_bVolViewGiftHistory,\n userBase.us_bVolEditJobSkills, userBase.us_bVolViewHrsHistory,\n userBase.us_bVolAddVolHours, userBase.us_bVolShiftSignup,\n\n userBase.us_bUserAllowSponsorship, userBase.us_bUserAllowSponFinancial,\n userBase.us_bUserAllowClient, userBase.us_bUserAllowAuctions, userBase.us_bUserAllowGrants,\n userBase.us_bUserAllowInventory, userBase.us_bUserVolManager,\n\n userBase.us_bUserDataEntryPeople,\n userBase.us_bUserDataEntryGifts,\n userBase.us_bUserEditPeople,\n userBase.us_bUserEditGifts,\n userBase.us_bUserViewPeople,\n userBase.us_bUserViewGiftHistory,\n userBase.us_bUserViewReports,\n userBase.us_bUserAllowExports,\n\n userBase.us_lVolID,\n\n userBase.us_bDebugger,\n\n userBase.us_strFirstName,\n userBase.us_strLastName, userBase.us_strTitle, userBase.us_strPhone,\n userBase.us_strCell, userBase.us_strEmail, userBase.us_strAddr1,\n userBase.us_strAddr2, userBase.us_strCity, userBase.us_strState,\n userBase.us_strCountry, userBase.us_strZip,\n\n userBase.us_enumDateFormat, userBase.us_enumMeasurePref,\n\n usersC.us_strFirstName AS strCFName, usersC.us_strLastName AS strCLName,\n usersL.us_strFirstName AS strLFName, usersL.us_strLastName AS strLLName,\n UNIX_TIMESTAMP(userBase.us_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(userBase.us_dteLastUpdate) AS dteLastUpdate\n\n FROM admin_users AS userBase\n INNER JOIN admin_users AS usersC ON userBase.us_lOriginID = usersC.us_lKeyID\n INNER JOIN admin_users AS usersL ON userBase.us_lLastUpdateID= usersL.us_lKeyID\n WHERE userBase.us_lKeyID={$this->us_lKeyID};"; $query = $this->db->query($sqlStr); $numRows = $query->num_rows(); if ($numRows == 0) { } else { $row = $query->row(); $this->userRec = new stdClass(); $this->userRec->us_lKeyID = $row->us_lKeyID; $this->userRec->us_bInactive = $row->us_bInactive; $this->userRec->dteOrigin = $row->dteOrigin; $this->userRec->dteLastUpdate = $row->dteLastUpdate; $this->userRec->us_lOriginID = $row->us_lOriginID; $this->userRec->us_lLastUpdateID = $row->us_lLastUpdateID; $this->userRec->us_strUserName = $row->us_strUserName; $this->userRec->us_bAdmin = $row->us_bAdmin; $this->userRec->us_bVolAccount = $row->us_bVolAccount; $this->userRec->us_bVolEditContact = $row->us_bVolEditContact; $this->userRec->us_bVolPassReset = $row->us_bVolPassReset; $this->userRec->us_bVolViewGiftHistory = $row->us_bVolViewGiftHistory; $this->userRec->us_bVolEditJobSkills = $row->us_bVolEditJobSkills; $this->userRec->us_bVolViewHrsHistory = $row->us_bVolViewHrsHistory; $this->userRec->us_bVolAddVolHours = $row->us_bVolAddVolHours; $this->userRec->us_bVolShiftSignup = $row->us_bVolShiftSignup; $this->userRec->bStandardUser = !$this->userRec->us_bVolAccount && !$this->userRec->us_bAdmin; $this->userRec->us_bUserDataEntryPeople = (bool) $row->us_bUserDataEntryPeople; $this->userRec->us_bUserDataEntryGifts = (bool) $row->us_bUserDataEntryGifts; $this->userRec->us_bUserEditPeople = (bool) $row->us_bUserEditPeople; $this->userRec->us_bUserEditGifts = (bool) $row->us_bUserEditGifts; $this->userRec->us_bUserViewPeople = (bool) $row->us_bUserViewPeople; $this->userRec->us_bUserViewGiftHistory = (bool) $row->us_bUserViewGiftHistory; $this->userRec->us_bUserViewReports = (bool) $row->us_bUserViewReports; $this->userRec->us_bUserAllowExports = (bool) $row->us_bUserAllowExports; $this->userRec->us_bUserVolManager = (bool) $row->us_bUserVolManager; $this->userRec->us_bUserAllowSponsorship = (bool) $row->us_bUserAllowSponsorship; $this->userRec->us_bUserAllowSponFinancial = (bool) $row->us_bUserAllowSponFinancial; $this->userRec->us_bUserAllowClient = (bool) $row->us_bUserAllowClient; $this->userRec->us_bUserAllowAuctions = (bool) $row->us_bUserAllowAuctions; $this->userRec->us_bUserAllowGrants = (bool) $row->us_bUserAllowGrants; $this->userRec->us_bUserAllowInventory = (bool) $row->us_bUserAllowInventory; $this->userRec->us_bUserAllowInventory = (bool) $row->us_bUserAllowInventory; $this->userRec->us_lVolID = $row->us_lVolID; $this->userRec->us_bDebugger = $row->us_bDebugger; $this->userRec->us_strFirstName = $row->us_strFirstName; $this->userRec->us_strLastName = $row->us_strLastName; $this->userRec->strSafeName = htmlspecialchars($row->us_strFirstName . ' ' . $row->us_strLastName); $this->userRec->us_strTitle = $row->us_strTitle; $this->userRec->us_strPhone = $row->us_strPhone; $this->userRec->us_strCell = $row->us_strCell; $this->userRec->us_strEmail = $row->us_strEmail; $this->userRec->us_strAddr1 = $row->us_strAddr1; $this->userRec->us_strAddr2 = $row->us_strAddr2; $this->userRec->us_strCity = $row->us_strCity; $this->userRec->us_strState = $row->us_strState; $this->userRec->us_strCountry = $row->us_strCountry; $this->userRec->us_strZip = $row->us_strZip; $this->userRec->strAddress = strBuildAddress($this->userRec->us_strAddr1, $this->userRec->us_strAddr2, $this->userRec->us_strCity, $this->userRec->us_strState, $this->userRec->us_strCountry, $this->userRec->us_strZip, true); $this->userRec->us_enumDateFormat = $row->us_enumDateFormat; $this->userRec->us_enumMeasurePref = $row->us_enumMeasurePref; $this->userRec->us_strUserPWord = null; $this->userRec->strStaffCFName = $row->strCFName; $this->userRec->strStaffCLName = $row->strCLName; $this->userRec->strStaffLFName = $row->strLFName; $this->userRec->strStaffLLName = $row->strLLName; } }
function showBizInfo($clsRpt, $lBID, &$clsBiz) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $gbDateFormatUS, $glclsDTDateFormat; $clsDateTime = new dl_date_time(); echoT(strLinkAdd_Biz('Add new business/organization', true) . ' ' . strLinkAdd_Biz('Add new business/organization', false) . '<br>'); openBlock('Business', strLinkEdit_Biz($lBID, 'Edit business/organization information', true) . ' ' . strLinkRem_Biz($lBID, 'Remove this business record', true, true)); echoT($clsRpt->openReport() . $clsRpt->openRow() . $clsRpt->writeLabel('Business ID:') . $clsRpt->writeCell(str_pad($lBID, 5, '0', STR_PAD_LEFT), '', '', 1, 1, ' id="bID" ') . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Name:') . $clsRpt->writeCell($clsBiz->strSafeName, '', '', 1, 1, ' id="safeBizName" ') . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Category:') . $clsRpt->writeCell($clsBiz->strIndustry) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Address:') . $clsRpt->writeCell(strBuildAddress($clsBiz->strAddr1, $clsBiz->strAddr2, $clsBiz->strCity, $clsBiz->strState, $clsBiz->strCountry, $clsBiz->strZip, true, true)) . $clsRpt->closeRow()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Phone:') . $clsRpt->writeCell(htmlspecialchars(strPhoneCell($clsBiz->strPhone, $clsBiz->strCell)), '', '', 1, 1, ' id="phone" ') . $clsRpt->closeRow()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Fax:') . $clsRpt->writeCell(htmlspecialchars($clsBiz->strFax), '', '', 1, 1, ' id="fax" ') . $clsRpt->closeRow()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Web Site:') . $clsRpt->writeCell(htmlspecialchars($clsBiz->strWebSite)) . $clsRpt->closeRow()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Email:') . $clsRpt->writeCell($clsBiz->strEmailFormatted) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('ACO:') . $clsRpt->writeCell($clsBiz->strFlagImage . ' ' . $clsBiz->strCurSymbol) . $clsRpt->closeRow()); //------------------ // Notes //------------------ echoT($clsRpt->openRow() . $clsRpt->writeLabel('Notes:') . $clsRpt->writeCell(nl2br(htmlspecialchars($clsBiz->strNotes))) . $clsRpt->closeRow()); //------------------ // Attributed To //------------------ echoT($clsRpt->openRow() . $clsRpt->writeLabel('Attributed To:') . $clsRpt->writeCell(htmlspecialchars($clsBiz->strAttrib)) . $clsRpt->closeRow()); echoT($clsRpt->closeReport()); closeBlock(); }
public function loadVolRecs() { //----------------------------------------------------------------------- // //----------------------------------------------------------------------- $this->volRecs = array(); $clsPeople = new mpeople(); if ($this->strOrderExtra . '' == '') { $this->strOrderExtra = ' ORDER BY pe_strLName, pe_strFName, pe_strMName, vol_lKeyID '; } $sqlStr = "SELECT\n vol_lKeyID, vol_lPeopleID, vol_bInactive, vol_lRegFormID,\n vol_Notes, vol_bRetired, vol_lOriginID, vol_lLastUpdateID,\n UNIX_TIMESTAMP(vol_dteInactive) AS dteInactive,\n\n vreg_strFormName, vreg_strURLHash,\n\n pe_strLName, pe_strFName,\n pe_strMName, pe_bRetired,\n pe_strPreferredName, pe_strTitle,\n pe_strAddr1, pe_strAddr2,\n pe_strCity, pe_strState,\n pe_strZip, pe_strCountry,\n pe_strEmail, pe_strPhone, pe_strCell,\n pe_lHouseholdID,\n\n UNIX_TIMESTAMP(vol_dteOrigin) AS dteOrigin,\n UNIX_TIMESTAMP(vol_dteLastUpdate) AS dteLastUpdate,\n uc.us_strFirstName AS strUCFName, uc.us_strLastName AS strUCLName,\n ul.us_strFirstName AS strULFName, ul.us_strLastName AS strULLName\n\n FROM volunteers\n INNER JOIN people_names ON vol_lPeopleID = pe_lKeyID\n INNER JOIN admin_users AS uc ON uc.us_lKeyID = vol_lOriginID\n INNER JOIN admin_users AS ul ON ul.us_lKeyID = vol_lLastUpdateID\n LEFT JOIN vol_reg ON vol_lRegFormID = vreg_lKeyID\n\n WHERE\n NOT vol_bRetired AND NOT pe_bRetired\n {$this->strWhereExtra}\n {$this->strOrderExtra}\n {$this->sqlLimitExtra};"; $query = $this->db->query($sqlStr); $this->lNumVolRecs = $numRows = $query->num_rows(); if ($numRows == 0) { $this->volRecs[0] = new stdClass(); $vRec =& $this->volRecs[0]; $vRec->lKeyID = $vRec->lPeopleID = $vRec->lHouseholdID = $vRec->bInactive = $vRec->Notes = $vRec->bRetired = $vRec->dteInactive = $vRec->strLName = $vRec->strFName = $vRec->strMName = $vRec->strSafeNameFL = $vRec->bRetired = $vRec->strAddr1 = $vRec->strAddr2 = $vRec->strCity = $vRec->strState = $vRec->strZip = $vRec->strCountry = $vRec->strEmail = $vRec->strPhone = $vRec->strCell = $vRec->lOriginID = $vRec->lLastUpdateID = $vRec->dteOrigin = $vRec->dteLastUpdate = $vRec->strUCFName = $vRec->strUCLName = $vRec->strULFName = $vRec->strULLName = null; } else { $idx = 0; foreach ($query->result() as $row) { $this->volRecs[$idx] = new stdClass(); $vRec =& $this->volRecs[$idx]; $vRec->lKeyID = (int) $row->vol_lKeyID; $vRec->lPeopleID = (int) $row->vol_lPeopleID; $vRec->lHouseholdID = $lHID = (int) $row->pe_lHouseholdID; $vRec->strHouseholdName = $clsPeople->strHouseholdNameViaHID($lHID); $vRec->bInactive = $row->vol_bInactive; $vRec->Notes = $row->vol_Notes; $vRec->bRetired = $row->vol_bRetired; $vRec->dteInactive = $row->dteInactive; $vRec->strLName = $strLName = $row->pe_strLName; $vRec->strFName = $strFName = $row->pe_strFName; $vRec->strMName = $strMName = $row->pe_strMName; $vRec->strTitle = $strTitle = $row->pe_strTitle; $vRec->strPreferred = $strPreferred = $row->pe_strPreferredName; $vRec->lRegFormID = (int) $row->vol_lRegFormID; $vRec->strFormName = $row->vreg_strFormName; $vRec->strURLHash = $row->vreg_strURLHash; $vRec->strSafeName = $vRec->strSafeNameFL = htmlspecialchars(strBuildName(false, $strTitle, $strPreferred, $strFName, $strLName, $strMName)); $vRec->strSafeNameLF = htmlspecialchars(strBuildName(true, $strTitle, $strPreferred, $strFName, $strLName, $strMName)); $vRec->bRetired = $row->pe_bRetired; $vRec->strAddr1 = $row->pe_strAddr1; $vRec->strAddr2 = $row->pe_strAddr2; $vRec->strCity = $row->pe_strCity; $vRec->strState = $row->pe_strState; $vRec->strZip = $row->pe_strZip; $vRec->strCountry = $row->pe_strCountry; $vRec->strEmail = $strEmail = $row->pe_strEmail; $vRec->strEmailFormatted = strBuildEmailLink($strEmail, '', false, ''); $vRec->strPhone = $row->pe_strPhone; $vRec->strCell = $row->pe_strCell; $vRec->strAddress = strBuildAddress($vRec->strAddr1, $vRec->strAddr2, $vRec->strCity, $vRec->strState, $vRec->strCountry, $vRec->strZip, true); $vRec->lOriginID = $row->vol_lOriginID; $vRec->lLastUpdateID = $row->vol_lLastUpdateID; $vRec->dteOrigin = $row->dteOrigin; $vRec->dteLastUpdate = $row->dteLastUpdate; $vRec->strUCFName = $row->strUCFName; $vRec->strUCLName = $row->strUCLName; $vRec->strULFName = $row->strULFName; $vRec->strULLName = $row->strULLName; ++$idx; } } }
function findSimilarPeopleBizNames($bPeople, $strFName, $strLName, &$lNumMatches, &$matches) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- if ($bPeople) { $strWhereExtra = ' AND pe_strFName SOUNDS LIKE ' . strPrepStr($strFName) . ' AND NOT pe_bBiz '; } else { $strWhereExtra = ' AND pe_bBiz '; } $lNumMatches = 0; $matches = array(); $sqlStr = 'SELECT pe_lKeyID, pe_strFName, pe_strLName, pe_enumGender, pe_strAddr1, pe_strAddr2, pe_strCity, pe_strState, pe_strCountry, pe_strZip, pe_strPhone, pe_strCell, pe_strEmail, UNIX_TIMESTAMP(pe_dteOrigin) AS dteOrigin, UNIX_TIMESTAMP(pe_dteLastUpdate) AS dteLastUpdate, uc.us_strFirstName AS strUCFName, uc.us_strLastName AS strUCLName, ul.us_strFirstName AS strULFName, ul.us_strLastName AS strULLName FROM people_names INNER JOIN admin_users AS uc ON uc.us_lKeyID=pe_lOriginID INNER JOIN admin_users AS ul ON ul.us_lKeyID=pe_lLastUpdateID WHERE pe_strLName SOUNDS LIKE ' . strPrepStr($strLName) . ' ' . $strWhereExtra . ' AND NOT pe_bRetired ORDER BY pe_strLName, pe_strFName, pe_lKeyID;'; $query = $this->db->query($sqlStr); $lNumMatches = $query->num_rows(); if ($lNumMatches > 0) { $idx = 0; foreach ($query->result() as $row) { $matches[$idx] = new stdClass(); $match =& $matches[$idx]; $match->lKeyID = (int) $row->pe_lKeyID; $match->strFName = $row->pe_strFName; $match->strLName = $row->pe_strLName; $match->strSafeName = htmlspecialchars($row->pe_strFName . ' ' . $row->pe_strLName); $match->strSafeNameLF = htmlspecialchars($row->pe_strLName . ', ' . $row->pe_strFName); $match->strAddr1 = $row->pe_strAddr1; $match->strAddr2 = $row->pe_strAddr2; $match->strCity = $row->pe_strCity; $match->strState = $row->pe_strState; $match->strCountry = $row->pe_strCountry; $match->strZip = $row->pe_strZip; $match->strPhone = $row->pe_strPhone; $match->strCell = $row->pe_strCell; $match->strEmail = $row->pe_strEmail; $match->strEmailFormatted = strBuildEmailLink($match->strEmail, '', false, ''); $match->strAddress = strBuildAddress($match->strAddr1, $match->strAddr2, $match->strCity, $match->strState, $match->strCountry, $match->strZip, true); $match->dteOrigin = $row->dteOrigin; $match->dteLastUpdate = $row->dteLastUpdate; $match->ucstrFName = $row->strUCFName; $match->ucstrLName = $row->strUCLName; $match->ulstrFName = $row->strULFName; $match->ulstrLName = $row->strULLName; ++$idx; } } }
private function loadHonoree(&$clsHMCon, &$row, $strPrefix) { //----------------------------------------------------------------- // honoree / mail contact info //----------------------------------------------------------------- $strMember = $strPrefix . '_FName'; $clsHMCon->strFName = $row->{$strMember}; //($strPrefix.'_FName'); $strMember = $strPrefix . '_LName'; $clsHMCon->strLName = $row->{$strMember}; //[$strPrefix.'_LName']; $strMember = $strPrefix . '_Addr1'; $clsHMCon->strAddr1 = $row->{$strMember}; //[$strPrefix.'_Addr1']; $strMember = $strPrefix . '_Addr2'; $clsHMCon->strAddr2 = $row->{$strMember}; //[$strPrefix.'_Addr2']; $strMember = $strPrefix . '_City'; $clsHMCon->strCity = $row->{$strMember}; //[$strPrefix.'_City']; $strMember = $strPrefix . '_State'; $clsHMCon->strState = $row->{$strMember}; //[$strPrefix.'_State']; $strMember = $strPrefix . '_Country'; $clsHMCon->strCountry = $row->{$strMember}; //[$strPrefix.'_Country']; $strMember = $strPrefix . '_Zip'; $clsHMCon->strZip = $row->{$strMember}; //[$strPrefix.'_Zip']; $strMember = $strPrefix . '_Phone'; $clsHMCon->strPhone = $row->{$strMember}; //[$strPrefix.'_Phone']; $clsHMCon->strSafeNameLF = htmlspecialchars($clsHMCon->strLName . ', ' . $clsHMCon->strFName); $clsHMCon->strSafeNameFL = htmlspecialchars($clsHMCon->strFName . ' ' . $clsHMCon->strLName); $clsHMCon->strAddress = strBuildAddress($clsHMCon->strAddr1, $clsHMCon->strAddr2, $clsHMCon->strCity, $clsHMCon->strState, $clsHMCon->strCountry, $clsHMCon->strZip, true); }
if (bAllowAccess('showSponsors')) { echoT($clsRpt->writeLabel('Sponsorship', 160)); } $bHOH = true; foreach ($households as $contact) { $strLinkGiftHistory = ''; $lPID = $contact->PID; if ($bHOH) { $strHOH = '<b>'; $strEndHOH = '</b> <span class="smaller">(head)</span>'; $bHOH = false; } else { $strHOH = strLinkSpecial_MakeHOH($lPID, $lHouseholdID, 'Make head-of-household', true) . ' ' . strLinkRem_PersonFromHousehold($lPID, $lHouseholdID, 'Remove from household', true, true, ''); $strEndHOH = ''; } $strAddr = strBuildAddress($contact->strAddr1, $contact->strAddr2, $contact->strCity, $contact->strState, $contact->strCountry, $contact->strZip, true); if ($strAddr != '') { $strAddr .= '<br><br>'; } $strEmail = $contact->strEmail; if ($strEmail != '') { $strAddr .= strBuildEmailLink($strEmail, '', false, '') . '<br>'; } $strPhone = $contact->strPhone; if ($strPhone != '') { $strAddr .= $strPhone; } if (bAllowAccess('showGiftHistory')) { if ($contact->lNumACODonationGroups_hard + $contact->lNumACODonationGroups_soft > 0) { $strLinkGiftHistory = '<br>' . strLinkView_GiftsHistory($lPID, 'Gift history', true) . ' ' . strLinkView_GiftsHistory($lPID, 'Gift history', false); }