/** * 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); }