function showItemInfo(&$clsRpt, &$item, &$auction, $lPackageID, $lItemID) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $genumDateFormat; openBlock('Silent Auction Item', strLinkEdit_AuctionItem($lPackageID, $lItemID, 'Edit item information', true) . ' ' . ' ' . strLinkRem_AuctionItem($lPackageID, $lItemID, 'Remove this item record', true, true)); echoT($clsRpt->openReport()); // Item ID echoT($clsRpt->openRow() . $clsRpt->writeLabel('Item ID:') . $clsRpt->writeCell(str_pad($lItemID, 5, '0', STR_PAD_LEFT)) . $clsRpt->closeRow()); // Item Name echoT($clsRpt->openRow() . $clsRpt->writeLabel('Name:') . $clsRpt->writeCell($item->strSafeItemName) . $clsRpt->closeRow()); // Date Obtained echoT($clsRpt->openRow() . $clsRpt->writeLabel('Date Obtained:') . $clsRpt->writeCell(date($genumDateFormat, $item->dteObtained)) . $clsRpt->closeRow()); // Item Donor if ($item->itemDonor_bBiz) { $strNameLink = ' <i>(business)</i> ' . strLinkView_BizRecord($item->lItemDonorID, 'View business record', true); } else { $strNameLink = ' ' . strLinkView_PeopleRecord($item->lItemDonorID, 'View people record', true); } echoT($clsRpt->openRow() . $clsRpt->writeLabel('Item Donor:') . $clsRpt->writeCell($item->itemDonor_safeName . $strNameLink) . $clsRpt->closeRow()); // Donor Acknowledgement echoT($clsRpt->openRow() . $clsRpt->writeLabel('Donor Ack.:') . $clsRpt->writeCell(htmlspecialchars($item->strDonorAck)) . $clsRpt->closeRow()); // Est. Value echoT($clsRpt->openRow() . $clsRpt->writeLabel('Est. Value:') . $clsRpt->writeCell($auction->strCurrencySymbol . ' ' . number_format($item->curEstAmnt, 2)) . $clsRpt->closeRow()); // Out-of-Pocket echoT($clsRpt->openRow() . $clsRpt->writeLabel('Out-of-Pocket:') . $clsRpt->writeCell($auction->strCurrencySymbol . ' ' . number_format($item->curOutOfPocket, 2)) . $clsRpt->closeRow()); // Public Notes echoT($clsRpt->openRow() . $clsRpt->writeLabel('Public Notes:') . $clsRpt->writeCell(nl2br(htmlspecialchars($item->strDescription))) . $clsRpt->closeRow()); // Private Notes echoT($clsRpt->openRow() . $clsRpt->writeLabel('Private Notes:') . $clsRpt->writeCell(nl2br(htmlspecialchars($item->strInternalNotes))) . $clsRpt->closeRow()); echoT($clsRpt->closeReport()); closeBlock(); }
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 showPeopleInfo($clsDateTime, $clsRpt, $people, $dupIDs) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $gbDateFormatUS, $genumDateFormat, $glclsDTDateFormat; // People ID $lPeopleID = $people->lKeyID; echoT($clsRpt->openRow() . $clsRpt->writeLabel('People ID:') . $clsRpt->writeCell(strLinkView_PeopleRecord($lPeopleID, 'View people record', true) . ' ' . str_pad($lPeopleID, 5, '0', STR_PAD_LEFT)) . $clsRpt->closeRow()); // Name echoT($clsRpt->openRow() . $clsRpt->writeLabel('Name:') . $clsRpt->writeCell($people->strSafeNameLF) . $clsRpt->closeRow()); // Address echoT($clsRpt->openRow() . $clsRpt->writeLabel('Address:') . $clsRpt->writeCell($people->strAddress) . $clsRpt->closeRow()); // Phone echoT($clsRpt->openRow() . $clsRpt->writeLabel('Phone:') . $clsRpt->writeCell(htmlspecialchars(strPhoneCell($people->strPhone, $people->strCell))) . $clsRpt->closeRow()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Consolidated With:') . $clsRpt->writeCell('People IDs: ' . implode(', ', $dupIDs)) . $clsRpt->closeRow()); }
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 showPayRec($clsRpt, &$pRec, $lSponID, $lFPayerID, $lPayID) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $genumDateFormat; openBlock('Sponsor payment record ', strLinkEdit_SponsorPayment($lSponID, $lFPayerID, $lPayID, 'Edit payment record', true) . ' ' . strLinkAdd_SponsorPayment($lSponID, 'Add new payment', true) . ' ' . strLinkRem_SponsorPayment($lSponID, $lPayID, 'Remove payment', true, true)); echoT($clsRpt->openReport() . $clsRpt->openRow() . $clsRpt->writeLabel('Payment ID:') . $clsRpt->writeCell(str_pad($lPayID, 5, '0', STR_PAD_LEFT), '', '', 1, 1, 'id="sponPayID"') . $clsRpt->closeRow()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Amount:') . $clsRpt->writeCell($pRec->strCurSymbol . ' ' . number_format($pRec->curPaymentAmnt, 2) . ' ' . $pRec->strFlagImage) . $clsRpt->closeRow()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Date of payment:') . $clsRpt->writeCell(date($genumDateFormat, $pRec->dtePayment)) . $clsRpt->closeRow()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Payment type:') . $clsRpt->writeCell(htmlspecialchars($pRec->strPaymentType)) . $clsRpt->closeRow()); echoT($clsRpt->openRow() . $clsRpt->writeLabel('Check #:') . $clsRpt->writeCell(htmlspecialchars($pRec->strCheckNum)) . $clsRpt->closeRow()); if ($pRec->lSponPeopleID == $pRec->lDonorID) { $strPayer = $pRec->strSponSafeNameFL . ' (sponsor)'; } else { if ($pRec->bDonorBiz) { $strPayer = strLinkView_BizRecord($pRec->lDonorID, 'View business record', true) . ' '; } else { $strPayer = strLinkView_PeopleRecord($pRec->lDonorID, 'View people record', true) . ' '; } $strPayer .= $pRec->strDonorSafeNameFL . ' <b>(THIRD PARTY PAYER)</b>'; } echoT($clsRpt->openRow() . $clsRpt->writeLabel('Payer:') . $clsRpt->writeCell($strPayer) . $clsRpt->closeRow() . $clsRpt->closeReport()); }
function showBizContactInfo($clsRpt, $lBID, $clsBiz, $lNumContacts, &$contacts) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $attributes = new stdClass(); $attributes->lTableWidth = 900; $attributes->divID = 'bizCon'; $attributes->divImageID = 'bizConDivImg'; openBlock('Associated Contacts <span style="font-size: 9pt;"> (' . $lNumContacts . ')</span>', strLinkView_BizContacts($lBID, 'View contacts', true, '') . ' ' . strLinkView_BizContacts($lBID, 'View', false, '') . ' ' . strLinkAdd_BizContact($lBID, 'Add new business contact', true, '') . ' ' . strLinkAdd_BizContact($lBID, 'Add new contact', false, ''), $attributes); if ($lNumContacts == 0) { echoT('<i>There are no contacts associated with this business/organization</i><br>'); } else { echoT("\n\n" . $clsRpt->openReport()); foreach ($contacts as $clsCon) { $lContactID = $clsCon->lBizConRecID; $lPID = $clsCon->lPeopleID; echoT($clsRpt->openRow() . $clsRpt->writeCell(strLinkView_PeopleRecord($clsCon->lPeopleID, 'View people record', true)) . $clsRpt->writeCell(strLinkEdit_BizContact($lBID, $lContactID, $lPID, 'Edit business contact', true)) . $clsRpt->writeCell(strLinkRem_BizContact($lBID, $lContactID, 'Remove business contact', true, true)) . $clsRpt->writeCell($clsCon->strSafeNameLF)); if ($clsCon->strRelationship . '' == '') { echoT($clsRpt->writeCell(' ')); } else { echoT($clsRpt->writeCell('(' . htmlspecialchars($clsCon->strRelationship) . ')')); } if ($clsCon->bSoftCash) { echoT($clsRpt->writeCell('<img src="' . DL_IMAGEPATH . '/misc/dollar.gif" border="0" title="soft cash relationship">')); } else { echoT($clsRpt->writeCell(' ')); } echoT($clsRpt->closeRow()); } echoT($clsRpt->closeReport()); } $attributes = new stdClass(); $attributes->bCloseDiv = true; closeBlock($attributes); }
</td> <td class="enpRptLabel"> Account </td> <td class="enpRptLabel"> Campaign </td> </tr>'); foreach ($gifts as $gift) { $lGiftID = $gift->gi_lKeyID; $lDonorID = $gift->gi_lForeignID; $bBizGift = $gift->pe_bBiz; if ($bBizGift) { $strLinkDonor = strLinkView_BizRecord($lDonorID, 'View business record', true); } else { $strLinkDonor = strLinkView_PeopleRecord($lDonorID, 'View people record', true); } echoT(' <tr class="makeStripe"> <td class="enpRpt">' . strLinkView_GiftsRecord($lGiftID, 'View gift record', true) . ' ' . str_pad($lGiftID, 5, '0', STR_PAD_LEFT) . ' </td> <td class="enpRpt">' . $strLinkDonor . ' ' . str_pad($lDonorID, 5, '0', STR_PAD_LEFT) . ' </td> <td class="enpRpt">' . htmlspecialchars($gift->strImportID) . ' </td> <td class="enpRpt">' . $gift->strSafeNameLF . ' </td> <td class="enpRpt" style="text-align: right;">' . $gift->strFormattedAmnt . ' </td> <td class="enpRpt" style="text-align: center;">' . date($genumDateFormat, $gift->gi_dteDonation) . ' </td>
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 strPeopleBizDupWarning($bPeople, $strCheckBoxName, $lNumMatches, $matches) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $strWarning = ''; $strLabel1 = $bPeople ? 'people' : 'business/organization'; $strLabel2 = $bPeople ? 'People' : 'Biz/Org'; $strWarning = '<br><div class="formError" style="width: 400pt;"> <b><i>Delightful Labor</i></b> has detected ' . $lNumMatches . ' ' . $strLabel1 . ' records with similar names to your new entry.<br><br> To prevent duplicate records, please verify that your new ' . $strLabel1 . ' record <b><i>is not</i></b> in the database.<br> <table style="border:2px solid #ff0000; border-collapse:collapse;"> <tr> <td class="enpRptTitle" colspan="3" style="background-color: #ffd3d3;"> ' . $strLabel2 . ' records in the database </td> </tr> <tr> <td class="enpRptLabel" style="background-color: #ffd3d3;"> ' . $strLabel2 . ' ID </td> <td class="enpRptLabel" style="background-color: #ffd3d3;"> Name </td> <td class="enpRptLabel" style="background-color: #ffd3d3;"> Address </td>'; $strWarning .= '</tr>'; foreach ($matches as $match) { $lKeyID = $match->lKeyID; if ($bPeople) { $strLink = strLinkView_PeopleRecord($lKeyID, 'View people record', true); } else { $strLink = strLinkView_BizRecord($lKeyID, 'View business/organization record', true); } $strWarning .= ' <tr> <td class="enpRpt" style="text-align: center;background-color: #fff5f5;">' . str_pad($lKeyID, 6, '0', STR_PAD_LEFT) . ' ' . $strLink . ' </td> <td class="enpRpt" style="background-color: #fff5f5;">' . $match->strSafeNameLF . ' </td> <td class="enpRpt" style="background-color: #fff5f5;">' . $match->strAddress . ' </td>'; $strWarning .= '</tr>'; } $strWarning .= ' </table><br> <div style="width: 300pt; border: 1px solid black; padding: 3px 3px 6px 3px; background-color: #fff; vertical-align: middle;"> <input type="checkbox" name="' . $strCheckBoxName . '" value="true"> I have verified that this <b>IS NOT</b> a duplicate entry<br> </div> </div>'; return $strWarning; }
</table>'; } } } if ($person->lNumFromRels > 0) { $strRels .= '<br>'; } if ($person->lNumToRels > 0) { foreach ($person->toRels as $b2a) { if ($b2a->bSoftDonations) { $strSoftImg = ' <img src="' . IMGLINK_DOLLAR . ' " border="0">'; } else { $strSoftImg = ''; } $lPIDLink = $a2b->lPerson_A_ID; $strRels .= strLinkView_PeopleRecord($lPIDLink, 'View record', true) . ' ' . htmlspecialchars($b2a->strAFName . ' ' . $b2a->strALName) . ' is <b>' . $b2a->strRelationship . '</b> to ' . htmlspecialchars($b2a->strBFName . ' ' . $b2a->strBLName) . $strSoftImg . '<br>' . "\n"; if ($b2a->strNotes != '') { $strRels .= ' <table> <tr> <td style="width: 15pt;"> </td> <td>' . nl2br(htmlspecialchars($b2a->strNotes)) . '</td> </tr> </table>'; } } } } else { $strRels = ' '; } echoT($clsRpt->writeCell($strRels, 520, ' vertical-align: middle; '));
$lPayID = $payrec->lKeyID; $lSponID = $payrec->lSponsorshipID; $lClientID = $payrec->lClientID; $lDonorID = $payrec->lDonorID; $lSponFID = $payrec->lSponPeopleID; $bBizDonor = $payrec->bDonorBiz; $bBizSponsor = $payrec->bSponBiz; if ($bBizDonor) { $strLinkDonor = strLinkView_BizRecord($lDonorID, 'View business record of payer', true); } else { $strLinkDonor = strLinkView_PeopleRecord($lDonorID, 'View people record of payer', true); } 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) . '
function writeHonMemGiftsTable($lGiftID, $clsRpt, $honMemTable) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $gbAdmin; echoT($clsRpt->openReport()); foreach ($honMemTable as $clsHM) { echoT($clsRpt->openRow()); $bHon = $clsHM->ghm_bHon; $strCell = strLinkView_PeopleRecord($clsHM->ghm_lFID, 'View people record', true) . ' ' . strLinkRem_HonMemLink($clsHM->lHMLinkID, $lGiftID, $bHon, 'Remove ' . ($bHon ? 'honorarium' : 'memorial'), true, true) . ' ' . $clsHM->honorMem->strSafeNameFL; if ($bHon) { echoT($clsRpt->writeLabel('Honorarium:')); echoT($clsRpt->writeCell($strCell)); } else { $lMCID = $clsHM->ghm_lMailContactID; if (is_null($lMCID)) { $strCell .= ' <font color="red"><i>(Mail contact not set!'; if ($gbAdmin) { $strCell .= ' Click ' . strLinkView_ListHonMem(false, 'here', false) . ' to work with memorials.'; } $strCell .= ')</i></font>'; } else { $strCell .= ' (mail contact: ' . $clsHM->mailContact->strSafeNameFL . strLinkView_PeopleRecord($lMCID, 'View people record for the mail contact', true) . ' ' . ')'; } echoT($clsRpt->writeLabel('Memorial:')); echoT($clsRpt->writeCell($strCell, '', 'vertical-align: text-top;')); } echoT($clsRpt->closeRow()); } echoT($clsRpt->closeReport('<br>')); }
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; } }
function showRelEntry($lPID, &$clsRel, $bA2B) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- if ($bA2B) { $strLinkPeopleA = ''; $strLinkPeopleB = strLinkView_PeopleRecord($clsRel->lPerson_B_ID, 'View people record', true) . ' '; } else { $strLinkPeopleA = strLinkView_PeopleRecord($clsRel->lPerson_A_ID, 'View people record', true) . ' '; $strLinkPeopleB = ''; } echoT(' <tr>'); echoT(' <td>' . strLinkEdit_Relationship($clsRel->lRelID, $bA2B, 'Edit relationship', true) . ' </td> <td>' . strLinkRem_Relationship($clsRel->lRelID, $lPID, 'Remove relationship', true, true) . ' </td>'); if ($clsRel->bSoftDonations) { echoT('<td><img src="' . IMGLINK_DOLLAR . '" border="0" title="Soft cash relationship"></td>'); } else { echoT('<td> </td>'); } echoT(' <td>' . $strLinkPeopleA . htmlspecialchars($clsRel->strAFName . ' ' . $clsRel->strALName) . ' is <b>' . htmlspecialchars($clsRel->strRelationship) . '</b> to ' . $strLinkPeopleB . htmlspecialchars($clsRel->strBFName . ' ' . $clsRel->strBLName) . ' </td>'); echoT('</tr>'); }
private function strVolHoursRptViaEventHTML($reportID, &$query, $newReportID) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $lEventBase = -999; $strOut = ''; foreach ($query->result() as $row) { $lEventID = $row->ved_lVolEventID; if ($lEventBase != $lEventID) { if ($lEventBase > 0) { $strOut .= ' <tr> <td class="enpRpt" style="text-align: left; font-weight: bold;" colspan="3"> Total Hours </td> <td class="enpRpt" style="width: 50px; text-align: right; font-weight: bold;">' . number_format($dSumHours, 2) . ' </td> </tr>'; $strOut .= '</table><br><br>'; } $lEventBase = $lEventID; $dSumHours = 0; $strOut .= '<table class="enpRptC" style="width: 500px;"> <tr> <td class="enpRptTitle" colspan="6"> Event: ' . htmlspecialchars($row->vem_strEventName) . ' ' . strLinkView_VolEvent($lEventID, 'View Event', true) . ' </td> </tr> <tr> <td class="enpRptLabel" style="width: 60px;"> vol ID </td> <td class="enpRptLabel" style="width: 70px;"> people ID </td> <td class="enpRptLabel"> Name </td> <td class="enpRptLabel" style="width: 50px;"> Hours </td> </tr>'; } $lVolID = $row->vsa_lVolID; $lPID = $row->pe_lKeyID; $dHours = $row->dHours; $dSumHours += $dHours; $fIDs = array($lVolID, $lEventID); $strOut .= ' <tr class="makeStripe"> <td class="enpRpt" style="width: 60px; text-align: center;">' . strLinkView_Volunteer($lVolID, 'View Volunteer Record', true) . ' ' . str_pad($lVolID, 5, '0', STR_PAD_LEFT) . ' </td> <td class="enpRpt" style="width: 70px; text-align: center;">' . strLinkView_PeopleRecord($lPID, 'View People Record', true) . ' ' . str_pad($lPID, 5, '0', STR_PAD_LEFT) . ' </td> <td class="enpRpt">' . htmlspecialchars($row->pe_strLName . ', ' . $row->pe_strFName) . ' </td> <td class="enpRpt" style="width: 50px; text-align: right;">' . number_format($dHours, 2) . ' ' . strLinkView_RptDetailGeneric($newReportID, $fIDs, 'View details', true) . ' </td> </tr>'; } $strOut .= ' <tr> <td class="enpRpt" style="text-align: left; font-weight: bold;" colspan="3"> Total Hours </td> <td class="enpRpt" style="width: 50px; text-align: right; font-weight: bold;">' . number_format($dSumHours, 2) . ' </td> </tr>'; $strOut .= '</table><br><br>'; return $strOut; }
function showItemInfo(&$clsRpt, $lNumItems, &$items, $lPackageID) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $attributes = new stdClass(); $attributes->divID = 'aucENPItems'; $attributes->divImageID = 'aucENPItemsDivImg'; openBlock('Items', strLinkView_AuctionItemsViaPID($lPackageID, 'View package items', true) . ' ' . strLinkView_AuctionItemsViaPID($lPackageID, 'View package items', false) . ' ' . strLinkAdd_AuctionItem($lPackageID, 'Add new item', true) . ' ' . strLinkAdd_AuctionItem($lPackageID, 'Add new item', false), $attributes); if ($lNumItems == 0) { echoT('<i>There are no items assigned to this package.</i>'); } else { echoT(' <table class="enpRpt"> <tr> <td class="enpRptLabel"> Item ID </td> <td class="enpRptLabel"> Est. Value </td> <td class="enpRptLabel"> Out-of-Pocket </td> <td class="enpRptLabel"> Name </td> <td class="enpRptLabel"> Provided By </td> </tr>'); $curTotOOP = $curTotEst = 0.0; foreach ($items as $item) { $lItemID = $item->lKeyID; $bBiz = $item->itemDonor_bBiz; $lDonorID = $item->lItemDonorID; $curTotOOP += $item->curOutOfPocket; $curTotEst += $item->curEstAmnt; if ($bBiz) { $strName = strLinkView_BizRecord($lDonorID, 'View business record', true) . ' ' . $item->itemDonor_safeName . ' (business)'; } else { $strName = strLinkView_PeopleRecord($lDonorID, 'View people record', true) . ' ' . $item->itemDonor_safeName; } echoT(' <tr> <td class="enpRpt" style="text-align: center;">' . str_pad($lItemID, 6, '0', STR_PAD_LEFT) . ' ' . strLinkView_AuctionItem($lItemID, 'View auction item', true) . ' </td> <td class="enpRpt" style="text-align: right;">' . number_format($item->curEstAmnt, 2) . ' </td> <td class="enpRpt" style="text-align: right;">' . number_format($item->curOutOfPocket, 2) . ' </td> <td class="enpRpt">' . $item->strSafeItemName . ' </td> <td class="enpRpt">' . $strName . ' </td> </tr>'); } echoT(' <tr> <td class="enpRpt"><b> Total:</b> </td> <td class="enpRpt" style="text-align: right;"><b>' . number_format($curTotEst, 2) . '</b> </td> <td class="enpRpt" style="text-align: right;"><b>' . number_format($curTotOOP, 2) . '</b> </td> <td class="enpRpt"> </td> <td class="enpRpt"> </td> </tr>'); echoT('</table>'); } $attributes = new stdClass(); $attributes->bCloseDiv = true; closeBlock($attributes); }
private function giftNotesSearch(&$results) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $genumDateFormat; $results->strLabel = 'Gift notes'; $results->lNumResults = 0; $cACO = new madmin_aco(); $sqlStr = 'SELECT gi_lKeyID, gi_lForeignID, gi_curAmnt, gi_lACOID, gi_dteDonation, gi_strNotes, pe_strLName, pe_strFName, pe_bBiz, gi_lSponsorID FROM gifts INNER JOIN people_names ON pe_lKeyID=gi_lForeignID WHERE NOT gi_bRetired AND NOT pe_bRetired AND ' . $this->textSearchWhere('gi_strNotes') . ' ORDER BY pe_strLName, pe_strFName, gi_lKeyID;'; $query = $this->db->query($sqlStr); $results->lNumResults = $lNumRows = $query->num_rows(); if ($lNumRows > 0) { $idx = 0; $results->matches = array(); foreach ($query->result() as $row) { $results->matches[$idx] = new stdClass(); $match =& $results->matches[$idx]; $lGiftID = $row->gi_lKeyID; $lFID = $row->gi_lForeignID; $strFID = str_pad($lFID, 5, '0', STR_PAD_LEFT); $bBiz = $row->pe_bBiz; $lACOID = $row->gi_lACOID; $bSponPay = !is_null($row->gi_lSponsorID); $cACO->loadCountries(false, false, true, $lACOID); $giftACO =& $cACO->countries[0]; if ($bSponPay) { $match->links = 'Sponsor Payment ID ' . str_pad($lGiftID, 5, '0', STR_PAD_LEFT) . strLinkView_SponsorPayment($lGiftID, 'View payment record', true) . ' '; } else { $match->links = 'Gift ID ' . str_pad($lGiftID, 5, '0', STR_PAD_LEFT) . strLinkView_GiftsRecord($lGiftID, 'View gift record', true) . ' '; } $match->searchInfo = 'Donation record of ' . $giftACO->strCurrencySymbol . ' ' . number_format($row->gi_curAmnt, 2) . ' ' . $giftACO->strFlagImg . ' of ' . date($genumDateFormat, dteMySQLDate2Unix($row->gi_dteDonation)) . ' by '; if ($bBiz) { $match->links .= 'Business ID: ' . $strFID . strLinkView_BizRecord($lFID, 'View business record', true); $match->searchInfo .= htmlspecialchars($row->pe_strLName); } else { $match->links .= 'People ID: ' . $strFID . strLinkView_PeopleRecord($lFID, 'View people record', true); $match->searchInfo .= htmlspecialchars($row->pe_strFName . ' ' . $row->pe_strLName); } $match->text = $row->gi_strNotes; $match->textHighlighted = $this->highlightMatchedText($row->gi_strNotes); ++$idx; } } }
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>'); }
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; }
} else { foreach ($vols as $vol) { $bInactive = $vol->bInactive; $lVolID = $vol->lKeyID; $lPID = $vol->lPeopleID; if ($bInactive) { $strColor = ' color: #888;'; } else { $strColor = ''; } echoT($clsRpt->openRow(true)); if ($showFields->bVolID) { echoT($clsRpt->writeCell(strLinkView_Volunteer($lVolID, 'View volunteer record', true) . ' ' . str_pad($lVolID, 5, '0', STR_PAD_LEFT), 60, 'text-align: center;' . $strColor)); } if ($showFields->bPeopleID) { echoT($clsRpt->writeCell(strLinkView_PeopleRecord($lPID, 'View people record', true) . ' ' . str_pad($lPID, 5, '0', STR_PAD_LEFT), 60, 'text-align: center;' . $strColor)); } if ($showFields->bActiveInactive) { echoT($clsRpt->writeCell($vol->bInactive ? 'No' : 'Yes', 60, 'text-align: center;' . $strColor)); } if ($showFields->bName) { echoT($clsRpt->writeCell($vol->strSafeNameLF . '<br>' . strLinkView_Household($vol->lHouseholdID, $lPID, 'View household', true) . '<i>' . htmlspecialchars($vol->strHouseholdName) . '</i>', 240, $strColor)); } if ($showFields->bAddress) { echoT($clsRpt->writeCell($vol->strAddress, 160, $strColor)); } if ($showFields->bPhoneEmail) { echoT($clsRpt->writeCell(strPhoneCell($vol->strPhone, $vol->strCell, true, true) . '<br>' . $vol->strEmailFormatted, 100, $strColor)); } if ($showFields->bSkills) { if ($vol->lNumJobSkills == 0) {
function showHonMemList($honMemTable, $bHon, $strLabel, $numGifts) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- echoT('<table class="enpRptC">'); if ($bHon) { echoT(' <tr> <td class="enpRptLabel"> HonMemID </td> <td class="enpRptLabel"> </td> <td class="enpRptLabel"> </td> <td class="enpRptLabel"> Person being honored </td> <td class="enpRptLabel"> Gifts </td> </tr>'); } else { echoT(' <tr> <td class="enpRptLabel"> HonMemID </td> <td class="enpRptLabel"> </td> <td class="enpRptLabel"> </td> <td class="enpRptLabel"> Person being memorialized </td> <td class="enpRptLabel"> Contact for memorials </td> <td class="enpRptLabel"> Gifts </td> </tr>'); } $idx = 0; foreach ($honMemTable as $clsHM) { $bHidden = $clsHM->ghm_bHidden; $lHMID = $clsHM->ghm_lKeyID; if ($bHidden) { $strStyle = 'color: #aaa; font-style:italic;'; } else { $strStyle = ''; } echoT(' <tr class="makeStripe"> <td class="enpRpt" style="text-align: center; ' . $strStyle . '">' . str_pad($clsHM->ghm_lKeyID, 5, '0', STR_PAD_LEFT) . ' </td> <td class="enpRpt" style="' . $strStyle . '">' . strLinkHideUnhide_HonMem($lHMID, !$bHidden, $bHon, $bHidden ? 'Un-hide entry' : 'Hide entry', true) . ' </td> <td class="enpRpt" style="' . $strStyle . '">' . strLinkRem_HonMem($lHMID, $bHon, 'Remove this ' . $strLabel, true, true) . ' </td> <td class="enpRpt" style="' . $strStyle . '">' . strLinkView_PeopleRecord($clsHM->ghm_lFID, 'View people record', true) . $clsHM->honorMem->strSafeNameLF . '<br>' . $clsHM->honorMem->strAddress . ' </td>'); if (!$bHon) { $lMCID = $clsHM->ghm_lMailContactID; if (is_null($lMCID)) { $strMCEntry = '<font color="red">NOT SET</font> ' . strLinkAdd_HonMem(false, true, $lHMID, 'Add mail contact for this memorial', true); } else { $strMCEntry = $clsHM->mailContact->strSafeNameLF . ' ' . strLinkView_PeopleRecord($lMCID, 'View mail contact\'s people record', true) . strLinkRem_HonMemMailCon($lHMID, 'Remove this mail contact', true, true) . '<br>' . $clsHM->mailContact->strAddress; } echoT(' <td class="enpRpt" style="' . $strStyle . '">' . $strMCEntry . ' </td>'); } $lNumGifts = $numGifts[$idx]; if ($lNumGifts > 0) { $strLinkGifts = strLinkView_GiftsViaHM($lHMID, 'View gifts', true); } else { $strLinkGifts = ''; } echoT(' <td class="enpRpt" style="text-align: center; ' . $strStyle . '">' . number_format($lNumGifts) . ' ' . $strLinkGifts . ' </td> </tr>'); ++$idx; } echoT('</table>'); }
$params = array('enumStyle' => 'enpRptC'); $clsRpt = new generic_rpt($params); echoT('<br>' . $clsRpt->openReport()); echoT($clsRpt->writeTitle($strRptTitle, '', '', 6)); echoT($clsRpt->openRow(true)); echoT($clsRpt->writeLabel('PeopleID', 60)); // echoT($clsRpt->writeLabel(' ', 20)); echoT($clsRpt->writeLabel('Name', 150)); echoT($clsRpt->writeLabel('Address')); echoT($clsRpt->writeLabel('Phone/Email')); echoT($clsRpt->writeLabel('Business Relationships')); echoT($clsRpt->closeRow()); foreach ($bizRecs as $bz) { $lPID = $bz->lPeopleID; echoT($clsRpt->openRow(true)); echoT($clsRpt->writeCell(strLinkView_PeopleRecord($lPID, 'View people record', true) . ' ' . str_pad($lPID, 5, '0', STR_PAD_LEFT), 60)); echoT($clsRpt->writeCell($bz->strSafeNameLF, 210)); echoT($clsRpt->writeCell($bz->strAddress, 160)); echoT($clsRpt->writeCell(strPhoneCell($bz->strPhone, $bz->strCell, true, true) . '<br>' . $bz->strEmailFormatted)); if ($bz->lNumBiz == 0) { echoT($clsRpt->writeCell('<i>none</i>', 260)); } else { $strOut = '<table width="100%">' . "\n"; foreach ($bz->biz as $biz) { if ($biz->bSoftCash) { $strSoft = '<img src="' . IMGLINK_DOLLAR . '" border="0" title="Soft cash relationship">'; } else { $strSoft = ''; } if ($biz->strRelationship . '' == '') { $strRel = ' ';
Shift: <b>' . htmlspecialchars($shift->strShiftName) . '</b> <font style="font-size: 9pt;">(' . date('g:i A', $shift->dteEventStartTime) . ' / ' . $shift->enumDuration . ')</font> </td> </tr>'); if ($shift->lNumVols == 0) { echoT('<tr> <td style="width: ' . $lIndent . 'pt;"> </td> <td style="width: ' . $lIndent . 'pt;"> </td> <td colspan="3" style="font-size: 9pt;"> <i>No volunteers</i> </td> </tr>'); } else { foreach ($shift->vols as $vol) { echoT('<tr> <td style="width: ' . $lIndent . 'pt;"> </td> <td style="width: ' . $lIndent . 'pt;"> </td> <td colspan="3" style="font-size: 9pt;">' . $vol->strSafeNameFL . ' ' . strLinkView_PeopleRecord($vol->lPeopleID, 'View people record', true) . ' </td> </tr>'); } } } } echoT('<tr><td colspan="5"> </td></tr>'); } echoT('</table>'); } /* echo('<font class="debug">'.substr(__FILE__, strrpos(__FILE__, '\\')) .': '.__LINE__.'<pre>'); print_r($dates); echo('</pre></font><br>'); */
function writeAuctionItemsTable(&$package, &$items, $bDescriptions) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $lPackageID = $package->lKeyID; echoT(' <table class="enpRpt"> <tr> <td class="enpRptTitle" colspan="8"> Items in the package <b>"' . $package->strPackageSafeName . '"</b> </td> </tr>'); echoT(' <tr> <td class="enpRptLabel"> item ID </td> <td class="enpRptLabel"> </td> <td class="enpRptLabel"> </td> <td class="enpRptLabel"> Name </td> <td class="enpRptLabel"> Est. Value </td> <td class="enpRptLabel"> Out of Pocket </td> <td class="enpRptLabel"> From </td> </tr>'); $curTotVal = $curTotOOP = 0.0; foreach ($items as $item) { $lItemID = $item->lKeyID; if ($item->itemDonor_bBiz) { $strNameLink = ' <i>(business)</i> ' . strLinkView_BizRecord($item->lItemDonorID, 'View business record', true); } else { $strNameLink = ' ' . strLinkView_PeopleRecord($item->lItemDonorID, 'View people record', true); } echoT(' <tr class="makeStripe"> <td class="enpRpt" style="text-align: center; width: 20pt;">' . str_pad($lItemID, 5, '0', STR_PAD_LEFT) . ' ' . strLinkView_AuctionItem($lItemID, 'View auction item', true) . ' </td> <td class="enpRpt" style="text-align: center;">' . strLinkEdit_AuctionItem($lPackageID, $lItemID, 'Edit Item', true) . ' </td> <td class="enpRpt" style="text-align: center; width: 20pt;">' . strLinkRem_AuctionItem($lPackageID, $lItemID, 'Remove auction item', true, true) . ' </td> <td class="enpRpt" style="width: 140pt;">' . $item->strSafeItemName . ' </td> <td class="enpRpt" style="width: 40pt; text-align: right;">' . number_format($item->curEstAmnt, 2) . ' </td> <td class="enpRpt" style="width: 40pt; text-align: right;">' . number_format($item->curOutOfPocket, 2) . ' </td> <td class="enpRpt" style="width: 110pt;">' . $item->itemDonor_safeName . $strNameLink . ' </td> </tr>'); $curTotVal += $item->curEstAmnt; $curTotOOP += $item->curOutOfPocket; } echoT(' <tr class="makeStripe"> <td class="enpRpt" colspan="4"> <b>Total:</b> </td> <td class="enpRpt" style="width: 40pt; text-align: right;"><b>' . number_format($curTotVal, 2) . '</b> </td> <td class="enpRpt" style="width: 40pt; text-align: right;"><b>' . number_format($curTotOOP, 2) . '</b> </td> <td colspan="2"> </td> </tr>'); echoT(' </table><br>'); }
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 showPeopleInfo($clsDateTime, $clsRpt, $person) { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- $lPID = $person->lKeyID; echoT($clsRpt->openRow() . $clsRpt->writeLabel('People ID:') . $clsRpt->writeCell(strLinkView_PeopleRecord($lPID, 'View people record', true) . ' ' . str_pad($lPID, 5, '0', STR_PAD_LEFT)) . $clsRpt->closeRow()); // Name echoT($clsRpt->openRow() . $clsRpt->writeLabel('Name:') . $clsRpt->writeCell($person->strSafeNameLF) . $clsRpt->closeRow()); // Address echoT($clsRpt->openRow() . $clsRpt->writeLabel('Address:') . $clsRpt->writeCell($person->strAddress) . $clsRpt->closeRow()); // Phone echoT($clsRpt->openRow() . $clsRpt->writeLabel('Phone:') . $clsRpt->writeCell(htmlspecialchars(strPhoneCell($person->strPhone, $person->strCell))) . $clsRpt->closeRow()); }
public function volHTMLSummary($idx) { //----------------------------------------------------------------------- // assumes user has called $clsVol->loadVolRecs(... //----------------------------------------------------------------------- global $gdteNow, $genumDateFormat; $strOut = ''; $params = array('enumStyle' => 'terse'); $clsRpt = new generic_rpt($params); $clsRpt->setEntrySummary(); $lVolID = $this->volRecs[$idx]->lKeyID; $volRec =& $this->volRecs[$idx]; $lPID = $volRec->lPeopleID; $strOut .= $clsRpt->openReport('', '') . $clsRpt->openRow(false) . $clsRpt->writeLabel('Name:') . $clsRpt->writeCell($volRec->strSafeName . ' (people ID ' . str_pad($lPID, 5, '0', STR_PAD_LEFT) . strLinkView_PeopleRecord($lPID, 'View People Record', true) . ')') . $clsRpt->closeRow() . $clsRpt->openRow(false) . $clsRpt->writeLabel('Volunteer ID:') . $clsRpt->writeCell(str_pad($lVolID, 5, '0', STR_PAD_LEFT) . ' ' . strLinkView_Volunteer($lVolID, 'View Volunteer Record', true)) . $clsRpt->closeRow(); if ($volRec->bInactive) { $strVol = '<i>Inactive since ' . date($genumDateFormat, $volRec->dteInactive); } else { $strVol = 'Active'; } $strOut .= $clsRpt->openRow(false) . $clsRpt->writeLabel('Volunteer Status:') . $clsRpt->writeCell($strVol) . $clsRpt->closeRow() . $clsRpt->openRow(false) . $clsRpt->writeLabel('Address:') . $clsRpt->writeCell($volRec->strAddress) . $clsRpt->closeRow() . $clsRpt->closeReport(''); return $strOut; }
function strDisplayValueViaType($vVal, $enumType, $lTableID, $bAsTableRow, $lWidth = 0, $strClass = 'enpRpt', $strStyleExtra = '') { //--------------------------------------------------------------------- // //--------------------------------------------------------------------- global $gbDateFormatUS; $strAlign = 'left'; switch ($enumType) { case CS_FT_HEADING: $strOut = $vVal; break; case CS_FT_LOG: $strOut = $vVal; break; case CS_FT_CHECKBOX: $strOut = $vVal ? 'Yes' : 'No'; break; case CS_FT_DATE: $strAlign = 'center'; if ($vVal . '' == '') { $strOut = ' '; } else { $strOut = strNumericDateViaMysqlDate($vVal, $gbDateFormatUS); } break; case CS_FT_DDL: case CS_FT_DDL_SPECIAL: case CS_FT_DDLMULTI: case CS_FT_TEXT80: case CS_FT_TEXT255: case CS_FT_TEXT20: $strOut = htmlspecialchars($vVal); break; case CS_FT_TEXT: case CS_FT_TEXTLONG: $strOut = nl2br(htmlspecialchars($vVal)); break; case CS_FT_ID: $strAlign = 'center'; $strOut = str_pad($vVal, 5, '0', STR_PAD_LEFT); switch ($lTableID) { case CL_STID_CLIENT: $strOut .= ' ' . strLinkView_ClientRecord($vVal, 'View client record', true); break; case CL_STID_GIFTS: $strOut .= ' ' . strLinkView_GiftsRecord($vVal, 'View gift record', true); break; case CL_STID_PEOPLEBIZ: break; case CL_STID_PEOPLE: $strOut .= ' ' . strLinkView_PeopleRecord($vVal, 'View people record', true); break; case CL_STID_BIZ: $strOut .= ' ' . strLinkView_BizRecord($vVal, 'View business/organization record', true); break; } break; case CS_FT_INTEGER: $strAlign = 'right'; if ($vVal . '' == '') { $strOut = ' '; } else { $strOut = number_format($vVal, 0); } break; case CS_FT_CURRENCY: $strAlign = 'right'; if ($vVal . '' == '') { $strOut = ' '; } else { $strOut = number_format($vVal, 2); } break; default: screamForHelp($enumType . ': unexpected field type<br>error on line <b> -- ' . __LINE__ . ' --</b>,<br>file ' . __FILE__ . ',<br>function ' . __FUNCTION__); break; } if ($bAsTableRow) { if ($lWidth > 0) { $strStyle = ' style="width: ' . $lWidth . 'pt; ' . $strStyleExtra . ' text-align: ' . $strAlign . ';" '; } else { $strStyle = ' style="' . $strStyleExtra . ' text-align: ' . $strAlign . ';" '; } $strOut = '<td class="' . $strClass . '" ' . $strStyle . '>' . $strOut . '</td>'; } return $strOut; }
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)); } if ($showFields->bSponsorInfo) { if ($sponsor->bInactive) { $strDates = date($genumDateFormat, $sponsor->dteStart) . ' - ' . date($genumDateFormat, $sponsor->dteInactive) . '<br>Inactive'; } else { $strDates = date($genumDateFormat, $sponsor->dteStart) . ' - now '; } echoT($clsRpt->writeCell($strSpanInactive . $strDates . '<br>program: ' . htmlspecialchars($sponsor->strSponProgram) . $strStopSpan));
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(); }