/**
* Count ParentPagerIndividuals
* by ParentPagerHouseholdId Index(es)
* @param integer $intParentPagerHouseholdId
* @return int
*/
public static function CountByParentPagerHouseholdId($intParentPagerHouseholdId, $objOptionalClauses = null)
{
// Call ParentPagerIndividual::QueryCount to perform the CountByParentPagerHouseholdId query
return ParentPagerIndividual::QueryCount(QQ::Equal(QQN::ParentPagerIndividual()->ParentPagerHouseholdId, $intParentPagerHouseholdId), $objOptionalClauses);
}
/**
* Used internally by the Meta-based Add Column tools.
*
* Given a QQNode or a Text String, this will return a ParentPagerIndividual-based QQNode.
* It will also verify that it is a proper ParentPagerIndividual-based QQNode, and will throw an exception otherwise.
*
* @param mixed $mixContent
* @return QQNode
*/
protected function ResolveContentItem($mixContent)
{
if ($mixContent instanceof QQNode) {
if (!$mixContent->_ParentNode) {
throw new QCallerException('Content QQNode cannot be a Top Level Node');
}
if ($mixContent->_RootTableName == 'parent_pager_individual') {
if ($mixContent instanceof QQReverseReferenceNode && !$mixContent->_PropertyName) {
throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
}
$objCurrentNode = $mixContent;
while ($objCurrentNode = $objCurrentNode->_ParentNode) {
if (!$objCurrentNode instanceof QQNode) {
throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
}
if ($objCurrentNode instanceof QQReverseReferenceNode && !$objCurrentNode->_PropertyName) {
throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
}
}
return $mixContent;
} else {
throw new QCallerException('Content QQNode has a root table of "' . $mixContent->_RootTableName . '". Must be a root of "parent_pager_individual".');
}
} else {
if (is_string($mixContent)) {
switch ($mixContent) {
case 'Id':
return QQN::ParentPagerIndividual()->Id;
case 'ServerIdentifier':
return QQN::ParentPagerIndividual()->ServerIdentifier;
case 'PersonId':
return QQN::ParentPagerIndividual()->PersonId;
case 'Person':
return QQN::ParentPagerIndividual()->Person;
case 'HiddenFlag':
return QQN::ParentPagerIndividual()->HiddenFlag;
case 'ParentPagerSyncStatusTypeId':
return QQN::ParentPagerIndividual()->ParentPagerSyncStatusTypeId;
case 'ParentPagerHouseholdId':
return QQN::ParentPagerIndividual()->ParentPagerHouseholdId;
case 'ParentPagerHousehold':
return QQN::ParentPagerIndividual()->ParentPagerHousehold;
case 'FirstName':
return QQN::ParentPagerIndividual()->FirstName;
case 'MiddleName':
return QQN::ParentPagerIndividual()->MiddleName;
case 'LastName':
return QQN::ParentPagerIndividual()->LastName;
case 'Prefix':
return QQN::ParentPagerIndividual()->Prefix;
case 'Suffix':
return QQN::ParentPagerIndividual()->Suffix;
case 'Nickname':
return QQN::ParentPagerIndividual()->Nickname;
case 'GraduationYear':
return QQN::ParentPagerIndividual()->GraduationYear;
case 'Gender':
return QQN::ParentPagerIndividual()->Gender;
case 'DateOfBirth':
return QQN::ParentPagerIndividual()->DateOfBirth;
default:
throw new QCallerException('Simple Property not found in ParentPagerIndividualDataGrid content: ' . $mixContent);
}
} else {
if ($mixContent instanceof QQAssociationNode) {
throw new QCallerException('Content QQNode cannot go through any "To Many" association nodes.');
} else {
throw new QCallerException('Invalid Content type');
}
}
}
}
public function ParentPagerIndividuals_Bind()
{
$this->dtgParentPagerIndividuals->MetaDataBinder(QQ::Equal(QQN::ParentPagerIndividual()->PersonId, $this->objPerson->Id));
}
public function dtgParentPagerIndividual_Bind()
{
$objCondition = QQ::All();
if (strlen($strText = trim($this->txtServerIdentifier->Text))) {
$objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQN::ParentPagerIndividual()->ServerIdentifier, $strText));
}
if (strlen($strText = trim($this->txtFirstName->Text))) {
$objCondition = QQ::AndCondition($objCondition, QQ::Like(QQN::ParentPagerIndividual()->FirstName, $strText . '%'));
}
if (strlen($strText = trim($this->txtLastName->Text))) {
$objCondition = QQ::AndCondition($objCondition, QQ::Like(QQN::ParentPagerIndividual()->LastName, $strText . '%'));
}
if ($intId = $this->lstParentPagerSyncStatusTypeId->SelectedValue) {
if ($intId == -1) {
$objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQN::ParentPagerIndividual()->HiddenFlag, true));
} else {
$objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQN::ParentPagerIndividual()->ParentPagerSyncStatusTypeId, $intId), QQ::OrCondition(QQ::Equal(QQN::ParentPagerIndividual()->HiddenFlag, false), QQ::IsNull(QQN::ParentPagerIndividual()->HiddenFlag)));
}
}
if ($strValue = $this->lstGender->SelectedValue) {
$objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQN::ParentPagerIndividual()->Gender, $strValue));
}
if (strlen($strText = trim($this->txtGraduationYear->Text))) {
$objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQN::ParentPagerIndividual()->GraduationYear, $strText));
}
$this->dtgParentPagerIndividuals->MetaDataBinder($objCondition);
}
public function dtgParentPagerIndividual_Bind()
{
$objCondition = QQ::All();
if (strlen($strText = trim($this->txtServerIdentifier->Text))) {
$objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQN::ParentPagerIndividual()->ServerIdentifier, $strText));
}
if (strlen($strText = trim($this->txtFirstName->Text))) {
$objCondition = QQ::AndCondition($objCondition, QQ::Like(QQN::ParentPagerIndividual()->FirstName, $strText . '%'));
}
if (strlen($strText = trim($this->txtLastName->Text))) {
$objCondition = QQ::AndCondition($objCondition, QQ::Like(QQN::ParentPagerIndividual()->LastName, $strText . '%'));
}
if ($this->chkShowUnlinkedOnly->Checked) {
$objCondition = QQ::AndCondition($objCondition, QQ::IsNull(QQN::ParentPagerIndividual()->PersonId));
}
$this->dtgParentPagerIndividuals->MetaDataBinder($objCondition);
}
