function strSponsorSummaryViaCID($bTerse, $clsClient)
{
//-----------------------------------------------------------------
// assumes $clsClient in the form of $this->clients[$idx]
//-----------------------------------------------------------------
$strOut = '';
if ($clsClient->lNumSponsors <= 0) {
return ' ';
}
if ($bTerse) {
$strOut = '<table width="100%" class="enpRpt">';
foreach ($clsClient->sponsors as $clsSpon) {
$lSponID = $clsSpon->lKeyID;
$bInactive = $clsSpon->bInactive;
if ($bInactive) {
$strStyle = 'color: #999; font-style:italic;';
} else {
$strStyle = '';
}
$strOut .= '<tr>
<td class="enpRpt" style="' . $strStyle . '">' . strLinkView_Sponsorship($lSponID, 'View sponsorship', true) . ' ' . str_pad($lSponID, 5, '0', STR_PAD_LEFT) . ' ' . $clsSpon->strSafeNameFL . '
</td>
</tr>';
}
$strOut .= '</table>';
} else {
echo __FILE__ . ' ' . __LINE__ . '<br>' . "\n";
die;
}
return $strOut;
}
function writeAutoChargeRow($clsACInfo)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$lCID = $clsACInfo->lKeyID;
$lSponID = $clsACInfo->lSponsorshipID;
$bBiz = $clsACInfo->bBiz;
$lFID = $clsACInfo->lForeignID;
$lClientID = $clsACInfo->lClientID;
if (is_null($lClientID)) {
$strClientRow = 'n/a';
} else {
$strClientRow = strLinkView_ClientRecord($lClientID, 'View Client', true) . ' ' . str_pad($lClientID, 5, '0', STR_PAD_LEFT) . ' ' . $clsACInfo->strClientSafeNameFL . ' / ' . htmlspecialchars($clsACInfo->strLocation);
}
if ($bBiz) {
$strFLink = strLinkView_BizRecord($lFID, 'View business record', true);
} else {
$strFLink = strLinkView_PeopleRecord($lFID, 'View people record', true);
}
echoT('
<tr>
<td class="enpRpt" style="text-align:center">' . strLinkView_SponsorCharge($lCID, 'View charge record', true) . ' ' . str_pad($lCID, 5, '0', STR_PAD_LEFT) . '
</td>');
echoT('
<td class="enpRpt" style="text-align:center">' . strLinkView_Sponsorship($lSponID, 'View sponsorship record', true) . ' ' . str_pad($lSponID, 5, '0', STR_PAD_LEFT) . '
</td>');
//------------------------------
// sponsor
//------------------------------
echoT('
<td class="enpRpt">' . $strFLink . ' ' . $clsACInfo->strSponSafeNameFL . '
</td>');
//------------------------------
// charge
//------------------------------
echoT('
<td class="enpRpt" style="text-align: right;">' . $clsACInfo->strCurSymbol . ' ' . number_format($clsACInfo->curChargeAmnt, 2) . ' ' . $clsACInfo->strFlagImage . '
</td>');
//------------------------------
// client
//------------------------------
echoT('
<td class="enpRpt">' . $strClientRow . '
</td>');
echoT('
</tr>');
}
function showGiftSponsorInfo(&$clsRpt, $lGiftID, $lFID, $gifts, &$spon)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$bMismo = $lFID == $spon->lForeignID;
$lSponID = $spon->lKeyID;
$lClientID = $spon->lClientID;
if (is_null($lClientID)) {
$strClientID = '<i>not set</i>';
} else {
$strClientID = str_pad($lClientID, 5, '0', STR_PAD_LEFT) . ' ' . strLinkView_ClientRecord($lClientID, 'View client record', true) . ' ' . $spon->strClientSafeNameFL;
}
openBlock('Sponsorship' . "\n", strLinkView_Sponsorship($lSponID, 'View sponsorship', true) . ' ' . strLinkView_Sponsorship($lSponID, 'View sponsorship', false) . "\n");
echoT($clsRpt->openReport());
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Sponsor ID:') . $clsRpt->writeCell(str_pad($spon->lKeyID, 5, '0', STR_PAD_LEFT)) . $clsRpt->closeRow());
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Sponsor:') . $clsRpt->writeCell($spon->strSponSafeNameLF . ($bMismo ? ' (same as donor)' : '')) . $clsRpt->closeRow());
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Sponsorship program:') . $clsRpt->writeCell(htmlspecialchars($spon->strSponProgram)) . $clsRpt->closeRow());
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Client:') . $clsRpt->writeCell($strClientID) . $clsRpt->closeRow());
echoT($clsRpt->closeReport(''));
closeBlock();
}
function showSingleSponsorshipInfo($clsRpt, $strTitle, $clsSpon)
{
//---------------------------------------------------------------------
// use for single sponsorship
//---------------------------------------------------------------------
$attributes = new stdClass();
$attributes->lTableWidth = 900;
$attributes->divID = 'ssponDiv';
$attributes->divImageID = 'ssponDivImg';
openBlock($strTitle, '', $attributes);
$clsRpt->openReport();
if ($clsSpon->lNumSponsors == 0) {
echoT('<i>(no sponsorships)</i><br>');
} else {
foreach ($clsSpon->sponInfo as $idx => $spon) {
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Sponsor ID:') . $clsRpt->writeCell(strLinkView_Sponsorship($spon->lKeyID, 'view sponsorship', true) . ' ' . str_pad($spon->lKeyID, 5, '0', STR_PAD_LEFT)) . $clsRpt->closeRow());
$lFID = $spon->lForeignID;
if ($spon->bSponBiz) {
$strLinkFID = strLinkView_Biz($lFID, 'View business record', true);
} else {
$strLinkFID = strLinkView_PeopleRecord($lFID, 'View people record', true);
}
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Sponsor:') . $clsRpt->writeCell($strLinkFID . ' ' . str_pad($lFID, 5, '0', STR_PAD_LEFT) . ' ' . $spon->strSponSafeNameFL) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Sponsorship Program:') . $clsRpt->writeCell(htmlspecialchars($spon->strSponProgram)) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Client:'));
if (is_null($spon->lClientID)) {
echoT($clsRpt->writeCell('<i>Client not set</i>'));
} else {
echoT($clsRpt->writeCell(strLinkView_Client($spon->lClientID, 'View client record', true) . ' ' . $spon->strClientSafeNameFL . ' (' . htmlspecialchars($spon->strLocation) . ')'));
}
echoT($clsRpt->closeRow());
}
}
echoT($clsRpt->closeReport());
$attributes = new stdClass();
$attributes->bCloseDiv = true;
closeBlock($attributes);
}
function showSponsorsPayments(&$sponInfo, &$clsForm, &$linkOpts, &$validation)
{
// $strSort, $lSponProgID, $lStartRec, $lRecsPerPage){
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
openSponsorPaymentTable($clsForm, $linkOpts);
foreach ($sponInfo as $spon) {
$lSponID = $spon->lKeyID;
$lFID = $spon->lForeignID;
echoT('<input type="hidden" name="hdnAOCID[' . $lSponID . ']" value="' . $spon->lCommitACO . '">' . "\n");
echoT('<input type="hidden" name="hdnFID[' . $lSponID . ']" value="' . $spon->lForeignID . '">' . "\n");
if ($spon->bSponBiz) {
$strFLink = 'bizID: ' . str_pad($lFID, 6, '0', STR_PAD_LEFT) . ' ' . strLinkView_BizRecord($lFID, 'View business record (new window)', true, 'target="_blank"');
} else {
$strFLink = 'peopleID: ' . str_pad($lFID, 6, '0', STR_PAD_LEFT) . ' ' . strLinkView_PeopleRecord($lFID, 'View people record (new window)', true, 'target="_blank"');
}
$strRadioName = 'rdoPayType' . $lSponID;
$lClientID = $spon->lClientID;
if (is_null($lClientID)) {
$strClient = 'client: n/a';
} else {
$strClient = 'client: ' . str_pad($lClientID, 6, '0', STR_PAD_LEFT) . strLinkView_ClientRecord($lClientID, 'View client record (new window)', true, 'target="_blank"') . ' ' . $spon->strClientSafeNameFL;
}
echoT('
<tr class="makeStripe">
<td class="enpRpt" style="text-align: center;">' . str_pad($lSponID, 6, '0', STR_PAD_LEFT) . ' ' . strLinkView_Sponsorship($lSponID, 'View sponsorship (new window)', true, 'target="_blank"') . '
</td>');
echoT('
<td class="enpRpt" style="width: 230pt;"><b>' . $spon->strSponSafeNameLF . '</b><br>' . $strFLink . '<br>' . $strClient . '<br>
program: ' . htmlspecialchars($spon->strSponProgram) . '
</td>');
echoT('
<td class="enpRpt" style="text-align: right;">' . $spon->strCommitACOCurSym . ' ' . number_format($spon->curCommitment, 2) . ' ' . $spon->strCommitACOFlagImg . '
</td>');
echoT('
<td class="enpRpt" style="vertical-align: top;">' . $spon->strCommitACOCurSym . ' ' . '<input type="text"
name="' . $spon->strAmountFN . '" style="width: 60pt; text-align: right;"
onChange="bUserDataEntered = true;"
value="' . $spon->txtAmount . '">' . $validation->amount[$lSponID] . '<br><span style="font-size: 8pt;">' . $spon->strLastPay . '</span>
</td>');
echoT('
<td class="enpRpt">
<table cellpadding="0" cellspacing="0">
<tr>
<td style="text-align: right; font-size: 8pt;">
check #:
</td>
<td>
<input type="text" style="width: 60pt;"
onChange="bUserDataEntered = true;"
name="' . $spon->strCheckFN . '"
value="' . $spon->txtCheckNum . '">
</tr>');
echoT(' <tr>
<td style="text-align: right; vertical-align: top; font-size: 8pt; padding-top: 4px;">
payment type:
</td>
<td>' . $spon->strDDLPayType . $validation->paymentType[$lSponID] . '
</td>
</tr>');
//----------------------
// Payment Date
//----------------------
echoT(' <tr>
<td style="text-align: right; vertical-align: top; font-size: 8pt; padding-top: 6px;">
payment date:
</td>
<td>' . $clsForm->strGenericDatePicker('', 'txtPayDate' . $lSponID, true, $spon->txtPayDate, 'frmBatchPayments', 'datepicker' . $lSponID, '', true) . $validation->paymentDate[$lSponID] . '
</td>
</tr>');
echoT('
</table>
</td>');
echoT('
</tr>');
echoT(strDatePicker('datepicker' . $lSponID, true));
}
closeSponsorPaymentTable();
}
public function strHTMLOneLineLink($clsSingleRem)
{
/*---------------------------------------------------------------------
sample call:
$clsRem->loadReminders();
if ($clsRem->lNumReminders > 0){
foreach ($clsRem->reminders as $clsSingleRem){
$strRemLink = $clsRem->strHTMLOneLineLink($clsSingleRem);
}
}
---------------------------------------------------------------------*/
global $genumDateFormat;
$enumRemType = $clsSingleRem->enumSource;
$lFID = $clsSingleRem->lForeignID;
switch ($enumRemType) {
case CENUM_CONTEXT_PEOPLE:
$people = new mpeople();
$people->lPeopleID = $lFID;
$people->peopleInfoLight();
$strRemLink = 'people reminder for ' . $people->strSafeName . strLinkView_PeopleRecord($lFID, 'View people record', true);
break;
case CENUM_CONTEXT_BIZ:
$clsBiz = new mbiz();
$clsBiz->lBID = $lFID;
$clsBiz->bizInfoLight();
$strRemLink = 'business reminder for ' . $clsBiz->strSafeName . strLinkView_BizRecord($lFID, 'View business record', true);
break;
case CENUM_CONTEXT_CLIENT:
$clsClient = new mclients();
$clsClient->loadClientsViaClientID($lFID);
$strRemLink = 'client reminder for ' . $clsClient->clients[0]->strSafeName . ' ' . strLinkView_ClientRecord($lFID, 'View client record', true);
break;
case CENUM_CONTEXT_GIFT:
$clsGifts = new mdonations();
$clsGifts->loadGiftViaGID($lFID);
$gift = $clsGifts->gifts[0];
$strRemLink = 'gift reminder for ' . $gift->strACOCurSymbol . number_format($gift->gi_curAmnt, 2) . ' ' . $gift->strSafeName . ' of ' . date($genumDateFormat, $gift->gi_dteDonation) . ' ' . strLinkView_GiftsRecord($lFID, 'View gift record', true);
break;
case CENUM_CONTEXT_USER:
$clsUser = new muser_accts();
$clsUser->loadSingleUserRecord($lFID);
$user =& $clsUser->userRec[0];
$strRemLink = 'user reminder for ' . $user->strSafeName . ' ' . strLinkView_User($lFID, 'View user record', true);
break;
case CENUM_CONTEXT_SPONSORSHIP:
$cSpon = new msponsorship();
$cSpon->sponsorInfoViaID($lFID);
$strRemLink = 'sponsorship reminder for sponsor ' . $cSpon->sponInfo[0]->strSponSafeNameFL . ' ' . strLinkView_Sponsorship($lFID, 'View sponsorship record', true);
break;
case CENUM_CONTEXT_LOCATION:
case CENUM_CONTEXT_VOLUNTEER:
default:
screamForHelp($enumRemType . ': Switch type not implemented</b><br>error on <b>line:</b> ' . __LINE__ . '<br><b>file:</b> ' . __FILE__ . '<br><b>function:</b> ' . __FUNCTION__);
break;
}
return $strRemLink;
}
}
if ($bBizSponsor) {
$strLinkSpon = strLinkView_BizRecord($lSponFID, 'View business record of sponsor', true);
} else {
$strLinkSpon = strLinkView_PeopleRecord($lSponFID, 'View people record of sponsor', true);
}
if (is_null($lClientID)) {
$strClientLink = ' ';
} else {
$strClientLink = strLinkView_ClientRecord($lClientID, 'View client record', true) . ' ';
}
echoT('
<tr class="makeStripe">
<td class="enpRpt" style="text-align: center;">' . strLinkView_SponsorPayment($lPayID, 'View payment record', true) . ' ' . str_pad($lPayID, 5, '0', STR_PAD_LEFT) . '
</td>
<td class="enpRpt" style="text-align: center;">' . strLinkView_Sponsorship($lSponID, 'View sponsorship record', true) . ' ' . str_pad($lSponID, 5, '0', STR_PAD_LEFT) . '
</td>
<td class="enpRpt" style="text-align: center;">' . $strLinkDonor . ' ' . str_pad($lDonorID, 5, '0', STR_PAD_LEFT) . '
</td>
<td class="enpRpt">' . htmlspecialchars($payrec->strImportID) . '
</td>
<td class="enpRpt">' . $payrec->strDonorSafeNameLF . '
</td>
<td class="enpRpt" style="text-align: right;">' . number_format($payrec->curPaymentAmnt, 2) . ' ' . $payrec->strFlagImage . '
</td>
<td class="enpRpt" style="text-align: center;">' . date($genumDateFormat, $payrec->dtePayment) . '
</td>
<td class="enpRpt">' . $strLinkSpon . ' ' . htmlspecialchars($payrec->strSponSafeNameLF) . '
</td>
<td class="enpRpt">' . $strClientLink . htmlspecialchars($payrec->strClientSafeNameFL) . '
</td>
public function sponsorChargeHTMLSummary()
{
//-----------------------------------------------------------------------
// assumes user has called $clsSCP->loadChargeRecord()
//-----------------------------------------------------------------------
global $gdteNow, $genumDateFormat;
$params = array('enumStyle' => 'terse');
$clsRpt = new generic_rpt($params);
$clsRpt->setBreadCrumbs();
$cRec = $this->chargeRec;
$bBiz = $cRec->bBiz;
if ($bBiz) {
$strLinkPeopleBiz = strLinkView_Biz($cRec->lForeignID, 'View business record', true);
} else {
$strLinkPeopleBiz = strLinkView_People($cRec->lForeignID, 'View people record', true);
}
$lSponID = $cRec->lSponsorshipID;
$clsRpt->openReport('', '');
$clsRpt->openRow(false);
$clsRpt->writeLabel(' Sponsor:');
$clsRpt->writeCell($strLinkPeopleBiz . ' ' . str_pad($cRec->lForeignID, 5, '0', STR_PAD_LEFT) . ' ' . $cRec->strSponSafeNameFL);
$clsRpt->closeRow();
$clsRpt->openRow(false);
$clsRpt->writeLabel('Sponsor ID:');
$clsRpt->writeCell(strLinkView_Sponsorship($lSponID, 'View sponsorship', true) . ' ' . str_pad($lSponID, 5, '0', STR_PAD_LEFT));
$clsRpt->closeRow();
if (is_null($cRec->lClientID)) {
$strClient = '<i>not set</i>';
} else {
$strClient = strLinkView_Client($cRec->lClientID, 'View client record', true) . ' ' . str_pad($cRec->lClientID, 5, '0', STR_PAD_LEFT) . ' ' . $cRec->strClientSafeNameFL;
}
$clsRpt->openRow(false);
$clsRpt->writeLabel('Client:');
$clsRpt->writeCell($strClient);
$clsRpt->closeRow();
$clsRpt->openRow(false);
$clsRpt->writeLabel('Status:');
$clsRpt->writeCell($cRec->bInactive ? 'Inactive' : 'Active');
$clsRpt->closeRow();
$clsRpt->openRow(false);
$clsRpt->writeLabel('Charge ID:');
$clsRpt->writeCell(str_pad($cRec->lKeyID, 5, '0', STR_PAD_LEFT));
$clsRpt->closeRow();
$clsRpt->openRow(false);
$clsRpt->writeLabel('Amount:');
$clsRpt->writeCell($cRec->strCurSymbol . ' ' . number_format($cRec->curChargeAmnt, 2) . ' ' . $cRec->strFlagImage);
$clsRpt->closeRow();
$clsRpt->openRow(false);
$clsRpt->writeLabel('Date of Charge:');
$clsRpt->writeCell(date($genumDateFormat, $cRec->dteCharge));
$clsRpt->closeRow();
$clsRpt->closeReport(true);
}
function showClientSponsorInfo($clsRpt, $lCID, $clsClient)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
$attributes = new stdClass();
$attributes->lTableWidth = 900;
$attributes->divID = 'clientSpon';
$attributes->divImageID = 'clientSponDivImg';
openBlock('Sponsorships', '', $attributes);
if ($clsClient->clients[0]->lNumSponsors == 0) {
echoT('<i>There are currently no sponsors for this ' . $clsClient->clients[0]->cv_strVocClientS . '</i><br>');
} else {
$clsRpt->openReport();
foreach ($clsClient->clients[0]->sponsors as $clsCSpon) {
$bInactive = $clsCSpon->bInactive;
if ($bInactive) {
$strSpanStart = '<span style="color: #999;"><i>';
$strSpanStop = '</i></span>';
$strInactive = ' (inactive since ' . date($genumDateFormat, $clsCSpon->dteInactive) . ')';
} else {
$strSpanStart = $strSpanStop = $strInactive = '';
}
echoT(strLinkView_Sponsorship($clsCSpon->lKeyID, 'View sponsorship', true) . $strSpanStart . str_pad($clsCSpon->lKeyID, 5, '0', STR_PAD_LEFT) . ' ' . $clsCSpon->strSafeNameFL . $strInactive . $strSpanStop . '<br>');
}
$clsRpt->closeReport();
}
$attributes = new stdClass();
$attributes->bCloseDiv = true;
closeBlock($attributes);
}
private function loadSponsorshipContext()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$this->clsSpon = new msponsorship();
$this->clsSpon->sponsorInfoViaID($this->lForeignID);
$this->strContextLabel = 'sponsorship record';
$sponRec = $this->clsSpon->sponInfo[0];
$this->strContextName = $sponRec->strSponProgram;
$this->strContextViewLink = strLinkView_Sponsorship($this->lForeignID, 'View sponsorship record', true);
}
function contextNameLink($enumType, $lForeignID, &$strContextName, &$strContextLink)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$CI =& get_instance();
$strContextLink = str_pad($lForeignID, 5, '0', STR_PAD_LEFT);
switch ($enumType) {
case CENUM_CONTEXT_PEOPLE:
$CI->clsPeople->loadPeopleViaPIDs($lForeignID, false, false);
$strContextName = $CI->clsPeople->people[0]->strFName . ' ' . $CI->clsPeople->people[0]->strLName;
$strContextLink .= strLinkView_PeopleRecord($lForeignID, 'View people record', true);
break;
case CENUM_CONTEXT_CLIENT:
$CI->clsClients->loadClientsViaClientID($lForeignID);
$strContextName = $CI->clsClients->clients[0]->strFName . ' ' . $CI->clsClients->clients[0]->strLName;
$strContextLink .= strLinkView_ClientRecord($lForeignID, 'View client record', true);
break;
case CENUM_CONTEXT_GIFT:
$CI->clsGifts->loadGiftViaGID($lForeignID);
$strContextName = 'Donation by ' . $CI->clsGifts->gifts[0]->strSafeName;
$strContextLink .= strLinkView_GiftsRecord($lForeignID, 'View gift record', true);
break;
case CENUM_CONTEXT_BIZ:
$CI->clsBiz->loadBizRecsViaBID($lForeignID);
$strContextName = $CI->clsBiz->bizRecs[0]->strSafeName;
$strContextLink .= strLinkView_BizRecord($lForeignID, 'View business record', true);
break;
case CENUM_CONTEXT_SPONSORSHIP:
$CI->clsSpon->sponsorInfoViaID($lForeignID);
$strContextName = 'Sponsor ' . $CI->clsSpon->sponInfo[0]->strSponSafeNameFL;
$strContextLink .= strLinkView_Sponsorship($lForeignID, 'View sponsorship record', true);
break;
case CENUM_CONTEXT_VOLUNTEER:
$CI->clsVol->loadVolRecsViaVolID($lForeignID, true);
$strContextName = $CI->clsVol->volRecs[0]->strSafeNameFL;
$strContextLink .= strLinkView_Volunteer($lForeignID, 'View volunteer record', true);
break;
case CENUM_CONTEXT_LOCATION:
$CI->clsLoc->loadLocationRec($lForeignID);
$strContextName = $CI->clsLoc->strLocation;
$strContextLink .= strLinkView_ClientLocation($lForeignID, 'View client location record', true);
break;
case CENUM_CONTEXT_ORGANIZATION:
$CI->clsLoc->loadLocationRec($lForeignID);
$strContextName = $CI->clsChapter->chapterRec->strSafeChapterName;
$strContextLink .= strLinkView_OrganizationRecord($lForeignID, 'View your organization record', true);
break;
default:
screamForHelp($enumType . ': feature not available yet<br>error on line ' . __LINE__ . ',<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__);
break;
}
}
function strLinkView_ViaRecType($enumSearchType, $lFKey01 = null, $lFKey02 = null)
{
//-----------------------------------------------------------------
//
//-----------------------------------------------------------------
switch ($enumSearchType) {
case CENUM_CONTEXT_HOUSEHOLD:
return strLinkView_Household($lFKey01, $lFKey02, 'View household', true);
break;
case CENUM_CONTEXT_PEOPLE:
return strLinkView_PeopleRecord($lFKey01, 'View people record', true);
break;
case CENUM_CONTEXT_BIZ:
return strLinkView_BizRecord($lFKey01, 'View business/prganization record', true);
break;
case CENUM_CONTEXT_CLIENT:
return strLinkView_ClientRecord($lFKey01, 'View client record', true);
break;
case CENUM_CONTEXT_SPONSORSHIP:
return strLinkView_Sponsorship($lFKey01, 'View sponsor record', true);
break;
default:
screamForHelp($enumSearchType . ': invalid link type<br>error on <b>line:</b> ' . __LINE__ . '<br><b>file: </b>' . __FILE__ . '<br><b>function: </b>' . __FUNCTION__);
break;
}
}
public function strDonationViewTable($sqlStr, $bIncludeAck, $bShowACO, $strTitle = '')
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
if ($bShowACO) {
$clsACO = new madmin_aco();
}
$query = $this->db->query($sqlStr);
if ($query->num_rows() == 0) {
return '<br><br><i>There are no donations that match your search criteria.</i>';
} else {
$strOut = '
<table class="enpRptC" style="width: 100%;">' . $strTitle . '
<tr>
<td class="enpRptLabel" style="width: 70px;">
giftID
</td>
<td class="enpRptLabel" style="width: 80px;">
Amount
</td>
<td class="enpRptLabel" style="width: 90px;">
Date
</td>
<td class="enpRptLabel" style="width: 200px;">
Donor
</td>
<td class="enpRptLabel" style="width: 110px;">
Account
</td>
<td class="enpRptLabel" style="width: 130px;">
Campaign
</td>
<td class="enpRptLabel" style="width: 90px;">
In-Kind?
</td>';
if ($bIncludeAck) {
$strOut .= '
<td class="enpRptLabel" style="">
Acknowledged?
</td>';
}
$strOut .= '
</tr>';
foreach ($query->result() as $row) {
$lGiftID = $row->gi_lKeyID;
$bBiz = $row->pe_bBiz;
$bSpon = !is_null($row->gi_lSponsorID);
$lPeopleID = $row->pe_lKeyID;
if ($bShowACO) {
$strFlagImg = ' ' . $clsACO->strFlagImage($row->aco_strFlag, $row->aco_strName);
} else {
$strFlagImg = '';
}
if ($bIncludeAck) {
if ($row->gi_bAck) {
$strAlignAck = 'left';
$strAck = 'Yes - ' . date($genumDateFormat, dteMySQLDate2Unix($row->gi_dteAck)) . ' by ' . htmlspecialchars($row->us_strFirstName . ' ' . $row->us_strLastName);
} else {
$strAlignAck = 'center';
$strAck = '-';
}
}
if ($bSpon) {
$strLinkViewRec = strLinkView_SponsorPayment($lGiftID, 'View sponsorship payment record', true);
$sponLink = ' ' . strLinkView_Sponsorship($row->gi_lSponsorID, 'View sponsorship', true);
} else {
$strLinkViewRec = strLinkView_GiftsRecord($lGiftID, 'View gift record', true);
$sponLink = '';
}
if ($row->gi_bGIK) {
$strAlign = 'left';
$strGIK = htmlspecialchars($row->strGIK);
} else {
$strAlign = 'center';
$strGIK = '-';
}
if ($bBiz) {
$strName = htmlspecialchars($row->pe_strLName);
$strLink = strLinkView_BizRecord($lPeopleID, 'View business/organization record', true);
} else {
$strName = htmlspecialchars($row->pe_strLName . ', ' . $row->pe_strFName);
$strLink = strLinkView_PeopleRecord($lPeopleID, 'View people record', true);
}
$strOut .= '
<tr class="makeStripe">
<td class="enpRpt" style="width: 50px; text-align: center;">' . $strLinkViewRec . ' ' . str_pad($lGiftID, 5, '0', STR_PAD_LEFT) . '
</td>
<td class="enpRpt" style="width: 60px; text-align: right; padding-right: 5px;">' . number_format($row->gi_curAmnt, 2) . $strFlagImg . '
</td>
<td class="enpRpt" style="text-align: left;">' . date($genumDateFormat, dteMySQLDate2Unix($row->gi_dteDonation)) . '
</td>
<td class="enpRpt" style="text-align: left;">' . $strLink . str_pad($lPeopleID, 5, '0', STR_PAD_LEFT) . ' ' . $strName . '
</td>
<td class="enpRpt" style="text-align: left;">' . htmlspecialchars($row->ga_strAccount) . '
</td>
<td class="enpRpt" style="text-align: left;">' . htmlspecialchars($row->gc_strCampaign) . $sponLink . '
</td>
<td class="enpRpt" style="text-align: ' . $strAlign . ';">' . $strGIK . '
</td>';
if ($bIncludeAck) {
$strOut .= '
<td class="enpRpt" style="text-align: ' . $strAlignAck . ';">' . $strAck . '
</td>';
}
$strOut .= '
</tr>';
}
$strOut .= '</table>' . "\n";
return $strOut;
}
}
</td>
</tr>');
foreach ($clients as $client) {
$lCID = $client->lClientID;
if ($client->lNumSponsors == 0) {
$strSponsors = '<br><i>No sponsors</i>';
} else {
$strSponsors = '<br><b><i>Sponsors</i></b><br><ul style="margin-top: 0px; margin-left:-10px;">';
foreach ($client->sponsors as $spon) {
if ($spon->bInactive) {
$strSStart = '<font style="color: #999;">';
$strSEnd = ' (inactive)</font>';
} else {
$strSStart = $strSEnd = '';
}
$strSponsors .= '<li>' . $strSStart . strLinkView_Sponsorship($spon->lKeyID, 'View sponsorship', true) . ' ' . htmlspecialchars($spon->strFName . ' ' . $spon->strLName) . $strSEnd . '</li>' . "\n";
}
$strSponsors .= '</ul>';
}
echoT('
<tr class="makeStripe">
<td class="enpRpt" style="text-align: center; width: 40pt" nowrap>' . str_pad($lCID, 6, '0', STR_PAD_LEFT) . ' ' . strLinkView_ClientRecord($lCID, 'View client record', true) . '
</td>
<td class="enpRpt">' . htmlspecialchars($client->strClientLName . ', ' . $client->strClientFName) . $strSponsors . '
</td>
<td class="enpRpt" style="width: 270pt;">' . strEnrollmentTable($cprog, $lCID, $client->lNumEnrollments, $client->erecs) . '
</td>
</tr>');
}
echoT('
</table>');
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;
}
$strActiveDates = 'sponsor dates: ' . date($genumDateFormat, $sponRec->dteStart) . ' - ' . date($genumDateFormat, $sponRec->dteInactive);
} else {
$strIStyle = '';
$strActiveDates = 'sponsor since: ' . date($genumDateFormat, $sponRec->dteStart);
}
} else {
$strIStyle = '';
}
echoT('
<tr class="makeStripe">');
//----------------------
// sponsor ID
//----------------------
if ($showFields->bSponID) {
echoT('
<td class="enpRpt" style="' . $strIStyle . '">' . strLinkView_Sponsorship($lSponsorID, 'View sponsorship record', true, 'id="viewSponRec_' . $lSponsorID . '"') . ' ' . str_pad($lSponsorID, 5, '0', STR_PAD_LEFT) . '
</td>');
}
//---------------------------
// active state
//---------------------------
if ($showFields->bActiveInactive) {
echoT('
<td class="enpRpt" style="' . $strIStyle . '">' . $strActiveDates . '
</td>');
}
//---------------------------
// sponsor name
//---------------------------
if ($showFields->bName) {
if ($sponRec->bSponBiz) {
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;
}
function strSponMonthIncomeReport(&$sRpt, &$displayData, $lStartRec, $lRecsPerPage)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
$strOut = '';
$strLimit = " LIMIT {$lStartRec}, {$lRecsPerPage} ";
$this->sponIncomeViaMonthVars($sRpt, $lYear, $lMonth, $lACOID);
$cACO = new madmin_aco();
$cACO->loadCountries(false, true, true, $lACOID);
$cCountry = $cACO->countries[0];
$strOut = '<table class="enpView">
<tr>
<td class="enpViewLabel" colspan="2" style="text-align: left; font-size: 13pt;">
Sponsorship Income
</td>
</tr>
<tr>
<td class="enpViewLabel">
Accounting Country:
</td>
<td class="enpView">' . $cCountry->strName . ' ' . $cCountry->strCurrencySymbol . ' ' . $cCountry->strFlagImg . '
</td>
</tr>
<tr>
<td class="enpViewLabel">
Month:
</td>
<td class="enpView">' . strXlateMonth($lMonth) . ' ' . $lYear . '
</td>
</tr>
</table>';
$sqlStr = "SELECT\n gi_lKeyID, gi_lSponsorID,\n gi_dteDonation,\n gi_curAmnt, gi_lForeignID, sp_lForeignID,\n payer.pe_bBiz AS bPayerBiz, payer.pe_strLName AS strPayerLName, payer.pe_strFName AS strPayerFName,\n payer.pe_strAddr1, payer.pe_strAddr2, payer.pe_strCity, payer.pe_strState, payer.pe_strZip, payer.pe_strCountry,\n spon.pe_bBiz AS bSponBiz, spon.pe_strLName AS strSponLName, spon.pe_strFName AS strSponFName\n FROM gifts\n INNER JOIN people_names AS payer ON gi_lForeignID=payer.pe_lKeyID\n INNER JOIN sponsor ON gi_lSponsorID=sp_lKeyID\n INNER JOIN people_names AS spon ON sp_lForeignID=spon.pe_lKeyID\n\n WHERE NOT gi_bRetired\n AND gi_lACOID={$lACOID}\n AND MONTH(gi_dteDonation)={$lMonth}\n AND YEAR (gi_dteDonation)={$lYear}\n AND gi_lSponsorID IS NOT NULL\n ORDER BY gi_dteDonation, gi_lKeyID\n {$strLimit};";
$query = $this->db->query($sqlStr);
$lNumRows = $query->num_rows();
if ($lNumRows > 0) {
$strOut .= '
<table class="enpRptC">
<tr>
<td class="enpRptLabel">
Payment ID
</td>
<td class="enpRptLabel">
Sponsor ID
</td>
<td class="enpRptLabel">
Amount
</td>
<td class="enpRptLabel">
Date
</td>
<td class="enpRptLabel">
Payer
</td>
<td class="enpRptLabel">
Sponsor
</td>
</tr>';
foreach ($query->result() as $row) {
$lPayID = $row->gi_lKeyID;
$lSponsorID = $row->gi_lSponsorID;
$lSponsorFID = $row->sp_lForeignID;
$lPayerID = $row->gi_lForeignID;
// gift ID
$strOut .= '
<tr>
<td class="enpRpt" style="text-align: center;">' . strLinkView_SponsorPayment($lPayID, 'View payment record', true) . ' ' . str_pad($lPayID, 5, '0', STR_PAD_LEFT) . '
</td>';
// sponsor ID
$strOut .= '
<td class="enpRpt" style="text-align: center;">' . strLinkView_Sponsorship($lSponsorID, 'View sponsorship record', true) . ' ' . str_pad($lSponsorID, 5, '0', STR_PAD_LEFT) . '
</td>';
// Amount
$strOut .= '
<td class="enpRpt" style="text-align: right; padding-left: 14px;">' . number_format($row->gi_curAmnt, 2) . '
</td>';
// Date
$strOut .= '
<td class="enpRpt" style="text-align: right;">' . date($genumDateFormat, dteMySQLDate2Unix($row->gi_dteDonation)) . '
</td>';
// Payer
if ($row->bPayerBiz) {
$strName = strLinkView_BizRecord($lPayerID, 'View business record', true) . ' ' . str_pad($lPayerID, 5, '0', STR_PAD_LEFT) . ' ' . htmlspecialchars($row->strPayerLName) . ' (business)';
} else {
$strName = strLinkView_PeopleRecord($lPayerID, 'View people record', true) . ' ' . str_pad($lPayerID, 5, '0', STR_PAD_LEFT) . ' ' . htmlspecialchars($row->strPayerLName . ', ' . $row->strPayerFName);
}
$strOut .= '
<td class="enpRpt" >' . $strName . '
</td>';
// Sponsor
if ($lPayerID == $lSponsorFID) {
$strName = '<span style="color: #999; font-style: italic;">(same as payer)';
} else {
if ($row->bSponBiz) {
$strName = strLinkView_BizRecord($lSponsorFID, 'View business record', true) . ' ' . str_pad($lSponsorFID, 5, '0', STR_PAD_LEFT) . ' ' . htmlspecialchars($row->strSponLName) . ' (business)';
} else {
$strName = strLinkView_PeopleRecord($lSponsorFID, 'View people record', true) . ' ' . str_pad($lSponsorFID, 5, '0', STR_PAD_LEFT) . ' ' . htmlspecialchars($row->strSponLName . ', ' . $row->strSponFName);
}
}
$strOut .= '
<td class="enpRpt" >' . $strName . '
</td>';
$strOut . '
</tr>';
}
$strOut .= '</table>';
} else {
$strOut .= '<br><br><i>There are no records that match your search criteria</i><br>';
}
return $strOut;
}
function writeGiftHistoryRow($idx, $lPID, $clsGH, &$curTotal)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
$lGiftID = $clsGH->gi_lKeyID;
$lDonorID = $clsGH->gi_lForeignID;
$lSponsorID = $clsGH->gi_lSponsorID;
$bSoft = $lDonorID != $lPID;
$bBiz = $clsGH->pe_bBiz;
if ($bSoft) {
if ($bBiz) {
$strLink = strLinkView_BizRecord($lDonorID, 'View business record ' . str_pad($lDonorID, 5, '0', STR_PAD_LEFT), true) . ' ';
} else {
$strLink = strLinkView_PeopleRecord($lDonorID, 'View people record ' . str_pad($lDonorID, 5, '0', STR_PAD_LEFT), true) . ' ';
}
$strFontStyle = 'font-style:italic; color: #666;';
} else {
$strLink = '';
$strFontStyle = '';
}
if ($bBiz) {
$strDonor = htmlspecialchars($clsGH->pe_strLName);
} else {
$strDonor = htmlspecialchars($clsGH->pe_strLName . ', ' . $clsGH->pe_strFName);
}
if ($clsGH->gi_bGIK) {
$strGH = '<br><small>in-kind: ' . $clsGH->strGIK . '</small>';
} else {
$strGH = '';
}
if (is_null($lSponsorID)) {
$strSponID = ' ';
$strGiftLink = strLinkView_GiftsRecord($lGiftID, 'View gift record', true);
} else {
if (bAllowAccess('showSponsors')) {
$strSponID = strLinkView_Sponsorship($lSponsorID, 'view sponsorship', true) . ' ' . str_pad($lSponsorID, 5, '0', STR_PAD_LEFT);
} else {
$strSponID = ' ';
}
$strGiftLink = strLinkView_SponsorPayment($lGiftID, 'View sponsorship payment record', true);
}
$strFlags = '';
if ($clsGH->bHon) {
$strFlags .= ' H';
}
if ($clsGH->bMem) {
$strFlags .= ' M';
}
$strFlags = trim($strFlags);
if ($strFlags == '') {
$strFlags = ' ';
}
$curTotal += $clsGH->gi_curAmnt;
echoT('
<tr class="makeStripe">
<td class="enpRpt" style="' . $strFontStyle . ' text-align:center; width: 15pt;">' . $idx . '
</td>
<td class="enpRpt" style="' . $strFontStyle . ' width: 50pt;">' . $strGiftLink . ' ' . str_pad($lGiftID, 5, '0', STR_PAD_LEFT) . '
</td>
<td class="enpRpt" style="text-align: right;' . $strFontStyle . ' width: 60pt;">' . number_format($clsGH->gi_curAmnt, 2) . '
</td>
<td class="enpRpt" style="text-align: center;' . $strFontStyle . ' width: 60pt;">' . date($genumDateFormat, $clsGH->gi_dteDonation) . '
</td>
<td class="enpRpt" style="' . $strFontStyle . ' width: 140pt;">' . $strLink . $strDonor . '
</td>
<td class="enpRpt" style="' . $strFontStyle . ' width: 70pt;">' . htmlspecialchars($clsGH->ga_strAccount) . '
</td>
<td class="enpRpt" style="' . $strFontStyle . ' width: 130pt;">' . htmlspecialchars($clsGH->gc_strCampaign) . $strGH . '
</td>');
if (bAllowAccess('showSponsors')) {
echoT('
<td class="enpRpt" style="text-align: center;' . $strFontStyle . ' width: 50pt;">' . $strSponID . '
</td>');
}
echoT('
<td class="enpRpt" style="text-align: center;' . $strFontStyle . ' width: 30pt;">' . $strFlags . '
</td>
</tr>');
}
This client's record can not be removed because it is associated with
the following sponsorships:
<table>
<?php
foreach ($sponsors as $sponsor) {
$lSponID = $sponsor->lKeyID;
echoT('
<tr>
<td>' . strLinkView_Sponsorship($lSponID, 'View sponsorship record', true) . ' ' . str_pad($lSponID, 5, '0', STR_PAD_LEFT) . '
</td>
<td>' . $sponsor->strSafeNameFL . '
</td>
</tr>');
}
?>
</table>
foreach ($pastDue as $pd) {
$lSponID = $pd->lSponID;
$curCommit = $pd->curCommit;
$curCharges = $pd->curCharges;
$curPayments = $pd->curPayments;
$curBal = $curCharges - $curPayments;
$lMonthsPast = (int) ($curBal / $curCommit);
$curCommitTot += $curCommit;
$curChargeTot += $curCharges;
$curPayTot += $curPayments;
$curBalTot += $curBal;
$bInactive = $pd->bInactive;
$strInactive = $bInactive ? 'color: #777;' : '';
echoT('
<tr class="makeStripe">
<td class="enpRpt" style="width: 50pt; text-align: center;' . $strInactive . '">' . str_pad($lSponID, 5, '0', STR_PAD_LEFT) . ' ' . strLinkView_Sponsorship($lSponID, 'View sponsorship record', true) . '
</td>
<td class="enpRpt" style="width: 150pt;' . $strInactive . '">' . $pd->strSponSafeNameLF . ($bInactive ? ' (inactive)' : '') . '
</td>
<td class="enpRpt" style="width: 100pt;' . $strInactive . '">' . $pd->strClientSafeNameLF . '
</td>
<td class="enpRpt" style="width: 50pt; text-align: right; padding-right: 5pt;' . $strInactive . '">' . number_format($curCommit, 2) . '
</td>
<td class="enpRpt" style="width: 50pt; text-align: right; padding-right: 5pt;' . $strInactive . '">' . number_format($curCharges, 2) . '
</td>
<td class="enpRpt" style="width: 50pt; text-align: right; padding-right: 5pt;' . $strInactive . '">' . number_format($curPayments, 2) . '
</td>
<td class="enpRpt" style="width: 50pt; text-align: right; padding-right: 5pt;' . $strInactive . '"><b>' . number_format($curBal, 2) . '</b>
</td>
<td class="enpRpt" style="width: 30pt; text-align: center;' . $strInactive . '"><b>' . number_format($lMonthsPast) . '</b>
</td>
foreach ($sponInfo as $sponsor) {
$lSponID = $sponsor->lKeyID;
$bBiz = $sponsor->bSponBiz;
$lForeignID = $sponsor->lForeignID;
$lClientID = $sponsor->lClientID;
$bInactive = $sponsor->bInactive;
$dteInactive = $sponsor->dteInactive;
if ($bInactive) {
$strSpanInactive = '<span style="color: #999;">';
$strStopSpan = '</span>';
} else {
$strSpanInactive = $strStopSpan = '';
}
echoT($clsRpt->openRow(true));
if ($showFields->bSponsorID) {
echoT($clsRpt->writeCell(strLinkView_Sponsorship($lSponID, 'View sponsorship record', true) . ' ' . $strSpanInactive . str_pad($lSponID, 5, '0', STR_PAD_LEFT) . $strStopSpan, '40', $strStyleExtra = 'text-align: center;'));
}
if ($showFields->bName) {
if ($bBiz) {
$strLink = strLinkView_BizRecord($lForeignID, 'View Business Record', true);
$strName = htmlspecialchars($sponsor->strSponsorLName) . ' <i>(business)</i>';
} else {
$strLink = strLinkView_PeopleRecord($lForeignID, 'View People Record', true);
$strName = htmlspecialchars($sponsor->strSponsorLName . ', ' . $sponsor->strSponsorFName);
}
$strName .= '<br>' . $strLink . ' ' . str_pad($lForeignID, 5, '0', STR_PAD_LEFT);
if ($showFields->bSponAddr) {
$strName .= '<br>' . $sponsor->strAddr;
}
echoT($clsRpt->writeCell($strSpanInactive . $strName . $strStopSpan, 175));
}
} else {
foreach ($sponInfo as $sponsor) {
$lSponID = $sponsor->lKeyID;
$bBiz = $sponsor->bSponBiz;
$lForeignID = $sponsor->lForeignID;
$lClientID = $sponsor->lClientID;
$bInactive = $sponsor->bInactive;
$strColorInactive = $bInactive ? 'color: #999;' : '';
if (is_null($lClientID) && !$bInactive) {
$strLinkAddClient = '<br><br>' . strLinkAdd_ClientToSpon($lSponID, 'Add client to this sponsorship', true) . ' ' . strLinkAdd_ClientToSpon($lSponID, 'Add client to this sponsorship', false);
} else {
$strLinkAddClient = '';
}
echoT($clsRpt->openRow(true));
if ($showFields->bSponsorID) {
echoT($clsRpt->writeCell(strLinkView_Sponsorship($lSponID, 'View sponsorship record', true) . ' ' . str_pad($lSponID, 5, '0', STR_PAD_LEFT), '40', 'text-align: center;' . $strColorInactive));
}
if ($showFields->bName) {
if ($bBiz) {
$strLink = strLinkView_BizRecord($lForeignID, 'View Business Record', true);
$strName = htmlspecialchars($sponsor->strSponsorLName) . ' <i>(business)</i>';
} else {
$strLink = strLinkView_PeopleRecord($lForeignID, 'View People Record', true);
$strName = htmlspecialchars($sponsor->strSponsorLName . ', ' . $sponsor->strSponsorFName);
}
$strName .= '<br>' . $strLink . ' ' . str_pad($lForeignID, 5, '0', STR_PAD_LEFT);
if ($showFields->bSponAddr) {
$strName .= '<br>' . $sponsor->strAddr;
}
echoT($clsRpt->writeCell($strName, 175, $strColorInactive));
}
