function showClientInfo($clsRpt, $lCID, $clsClient, $clsDateTime, $bShowAddNew, $lSponID, $bViewOnly, $strClientPreLabel = '')
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $gbDateFormatUS, $genumDateFormat, $glclsDTDateFormat;
if (is_null($lCID)) {
if ($bViewOnly) {
$attributes = new stdClass();
$attributes->lTableWidth = 900;
$attributes->divID = 'clientA';
$attributes->divImageID = 'clientADivImg';
openBlock('Client Information', '', $attributes);
} else {
openBlock('Client Information', '');
}
echoT('<i>No client has been linked to this sponsorship.</i>');
if ($bShowAddNew) {
echoT(' ' . strLinkAdd_ClientToSpon($lSponID, 'Add client to this sponsorship', true) . ' ' . strLinkAdd_ClientToSpon($lSponID, 'Add client to this sponsorship', false) . ' ');
}
if ($bViewOnly) {
$attributes = new stdClass();
$attributes->bCloseDiv = true;
closeBlock($attributes);
} else {
closeBlock();
}
} else {
$clsC = $clsClient->clients[0];
if ($bShowAddNew) {
echoT(strLinkAdd_Client('Add new client', true) . ' ' . strLinkAdd_Client('Add new client', false) . ' ' . strLinkSpecial_SearchClient('Search clients', true) . ' ' . strLinkSpecial_SearchClient('Search clients', false) . '<br>');
}
if (isset($clsC->strFlagsTable)) {
$strCFlags = ' ' . $clsC->strFlagsTable;
} else {
$strCFlags = '';
}
if ($bViewOnly) {
$strBlockLink = strLinkView_ClientRecord($lCID, 'View client record', true) . ' ' . strLinkView_ClientRecord($lCID, 'View client record', false);
$strVocLink = '';
$strLinkLocation = '';
$strLinkStatCat = '';
$strLinkStatHist = '';
$strLinkRem = '';
$attributes = new stdClass();
$attributes->lTableWidth = 900;
$attributes->divID = 'clientB';
$attributes->divImageID = 'clientBDivImg';
openBlock($strClientPreLabel . $clsClient->clients[0]->cv_strVocClientS, $strBlockLink . $strCFlags, $attributes);
} else {
/*
$strBlockLink = strLinkEdit_Client ($lCID, 'Edit client record', true ).' '
.strLinkEdit_Client ($lCID, 'Edit client record', false).' '
.strLinkView_ClientAssessmentViaCID($lCID, 'Client Assessments', true ).' '
.strLinkView_ClientAssessmentViaCID($lCID, 'Client Assessments', false);
*/
$strBlockLink = strLinkEdit_Client($lCID, 'Edit client record', true) . ' ' . strLinkEdit_Client($lCID, 'Edit client record', false);
$strVocLink = strLinkEdit_ClientRecVoc($lCID, 'Edit this client\'s vocabulary', true) . ' ';
$strLinkLocation = strLinkView_ClientsViaLocation($clsC->lLocationID, 'View this location\'s directory', true);
$strLinkStatCat = strLinkEdit_ClientRecStatCat($lCID, 'Edit this client\'s status category', true) . ' ';
$strLinkStatHist = strLinkView_ClientStatusHistory($lCID, 'status history', true);
$strLinkRem = ' ' . strLinkRem_Client($lCID, 'Remove client record', true, true);
openBlock($strClientPreLabel . $clsClient->clients[0]->cv_strVocClientS, $strBlockLink . $strCFlags . $strLinkRem);
}
echoT($clsRpt->openReport() . $clsRpt->openRow() . $clsRpt->writeLabel('Client ID:') . $clsRpt->writeCell(str_pad($lCID, 5, '0', STR_PAD_LEFT)) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Name:') . $clsRpt->writeCell(htmlspecialchars($clsC->strFName . ' ' . $clsC->strMName . ' ' . $clsC->strLName . ' (' . $clsC->enumGender . ')')) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Enrollment Date:') . $clsRpt->writeCell(date($genumDateFormat, $clsC->dteEnrollment)) . $clsRpt->closeRow());
//---------------
// birthday
//---------------
$mdteBirth = $clsC->dteBirth;
$clsDateTime->setDateViaMySQL(0, $mdteBirth);
$strAgeBDay = $clsDateTime->strPeopleAge(0, $mdteBirth, $lAgeYears, $glclsDTDateFormat);
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Birth Date:') . $clsRpt->writeCell($strAgeBDay) . $clsRpt->closeRow());
//---------------
// location
//---------------
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Location:') . $clsRpt->writeCell($strLinkLocation . htmlspecialchars($clsC->strLocation)) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Max # of Sponsors:') . $clsRpt->writeCell($clsC->lMaxSponsors) . $clsRpt->closeRow());
//------------------------
// Address
//------------------------
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Address:') . $clsRpt->writeCell($clsC->strAddress) . $clsRpt->closeRow());
//------------------------
// Email
//------------------------
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Email:') . $clsRpt->writeCell($clsC->strEmailFormatted) . $clsRpt->closeRow());
//------------------------
// Phone
//------------------------
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Phone:') . $clsRpt->writeCell(htmlspecialchars(strPhoneCell($clsC->strPhone, $clsC->strCell))) . $clsRpt->closeRow());
//---------------
// Vocabulary
//---------------
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Vocabulary:') . $clsRpt->writeCell($strVocLink . $clsC->cv_strVocTitle) . $clsRpt->closeRow());
//------------------
// Status Category
//------------------
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Status Category:') . $clsRpt->writeCell($strLinkStatCat . $clsC->strStatusCatName) . $clsRpt->closeRow() . $clsRpt->openRow() . $clsRpt->writeLabel('Current Status:') . $clsRpt->writeCell($strLinkStatHist . $clsC->curStat_strStatus . ' <small>(set on ' . date($genumDateFormat, $clsC->curStat_dteStatus) . ')</small>') . $clsRpt->closeRow());
//------------------
// Attributed To
//------------------
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Attributed To:') . $clsRpt->writeCell(htmlspecialchars($clsC->strAttrib)) . $clsRpt->closeRow());
//------------------
// Bio
//------------------
echoT($clsRpt->openRow() . $clsRpt->writeLabel('Bio:') . $clsRpt->writeCell(nl2br(htmlspecialchars($clsC->strBio))) . $clsRpt->closeRow());
echoT($clsRpt->closeReport());
if ($bViewOnly) {
$attributes = new stdClass();
$attributes->bCloseDiv = true;
closeBlock($attributes);
} else {
closeBlock();
}
}
}
function showClientStatusInfo($clsRpt, $lCID, $clsClient, &$clientStatus, $lNumClientStatus)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
$attributes = new stdClass();
$attributes->lTableWidth = 900;
$attributes->divID = 'clientStat';
$attributes->divImageID = 'clientStatDivImg';
openBlock($clsClient->clients[0]->cv_strVocClientS . ' Status History', strLinkView_ClientStatusHistory($lCID, 'View status history', true), $attributes);
if ($lNumClientStatus == 0) {
echoT('<i>There are no status records for this ' . $clsClient->clients[0]->cv_strVocClientS . '</i><br>');
closeBlock();
return;
}
showStatusHistory(false, false, $clientStatus, $lNumClientStatus, $lCID, "80%");
$attributes = new stdClass();
$attributes->bCloseDiv = true;
closeBlock($attributes);
}
private function clientStatusSearch(&$results)
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
global $genumDateFormat;
$results->strLabel = 'Client Status';
$results->lNumResults = 0;
$sqlStr = 'SELECT csh_lKeyID, csh_lClientID, csh_lStatusID,
csh_dteStatusDate,
csh_strStatusTxt,
cr_strFName, cr_strLName, cr_lLocationID, cl_strLocation
FROM client_status
INNER JOIN client_records ON cr_lKeyID = csh_lClientID
INNER JOIN client_location ON cr_lLocationID = cl_lKeyID
WHERE NOT csh_bRetired AND ' . $this->textSearchWhere('csh_strStatusTxt') . '
ORDER BY csh_dteStatusDate, csh_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();
$lClientID = $row->csh_lClientID;
$match =& $results->matches[$idx];
$match->links = 'Client ID ' . str_pad($lClientID, 5, '0', STR_PAD_LEFT) . strLinkView_ClientRecord($lClientID, 'View client record', true) . ' ' . 'Client Status ID: ' . str_pad($row->csh_lKeyID, 5, '0', STR_PAD_LEFT) . strLinkView_ClientStatusHistory($lClientID, 'View client status', true);
$match->searchInfo = 'Client status record for ' . htmlspecialchars($row->cr_strFName . ' ' . $row->cr_strLName) . '
(' . htmlspecialchars($row->cl_strLocation) . ') of ' . date($genumDateFormat, dteMySQLDate2Unix($row->csh_dteStatusDate));
$match->text = $row->csh_strStatusTxt;
$match->textHighlighted = $this->highlightMatchedText($row->csh_strStatusTxt);
++$idx;
}
}
}
