protected function GetQqNodeForAttributeNode(QQCondition &$objQqCondition = null, &$objQqClauses = null, $strValue) { // Get the Attribute object we are trying to query against $objAttribute = Attribute::Load($this->NodeDetail); $strAttributeValueTableAlias = 'av' . self::$intJoinCount++; $objQqClauses[] = QQ::CustomJoin('attribute_value', $strAttributeValueTableAlias, sprintf('%s%s%s.%sperson_id%s = %st0%s.%sid%s AND %s%s%s.%sattribute_id%s = %s', self::GetDatabase()->EscapeIdentifierBegin, $strAttributeValueTableAlias, self::GetDatabase()->EscapeIdentifierEnd, self::GetDatabase()->EscapeIdentifierBegin, self::GetDatabase()->EscapeIdentifierEnd, self::GetDatabase()->EscapeIdentifierBegin, self::GetDatabase()->EscapeIdentifierEnd, self::GetDatabase()->EscapeIdentifierBegin, self::GetDatabase()->EscapeIdentifierEnd, self::GetDatabase()->EscapeIdentifierBegin, $strAttributeValueTableAlias, self::GetDatabase()->EscapeIdentifierEnd, self::GetDatabase()->EscapeIdentifierBegin, self::GetDatabase()->EscapeIdentifierEnd, $objAttribute->Id)); // What is the ATTRIBUTE's type? Figure out the Custom QQ Node based on that switch ($objAttribute->AttributeDataTypeId) { case AttributeDataType::Checkbox: $objQqNode = QQ::CustomNode(sprintf('%s.boolean_value', $strAttributeValueTableAlias)); break; case AttributeDataType::Date: $objQqNode = QQ::CustomNode(sprintf('%s.date_value', $strAttributeValueTableAlias)); break; case AttributeDataType::DateTime: $objQqNode = QQ::CustomNode(sprintf('%s.datetime_value', $strAttributeValueTableAlias)); break; case AttributeDataType::Text: $objQqNode = QQ::CustomNode(sprintf('%s.text_value', $strAttributeValueTableAlias)); break; case AttributeDataType::ImmutableSingleDropdown: case AttributeDataType::MutableSingleDropdown: $objQqNode = QQ::CustomNode(sprintf('%s.single_attribute_option_id', $strAttributeValueTableAlias)); break; case AttributeDataType::ImmutableMultipleDropdown: case AttributeDataType::MutableMultipleDropdown: $strAttributeOptionTableAlias = 'avmaoa' . self::$intJoinCount++; $objQqClauses[] = QQ::CustomJoin('attributevalue_multipleattributeoption_assn', $strAttributeOptionTableAlias, sprintf("%s.attribute_value_id = %s.id AND %s.attribute_option_id = '%s'", $strAttributeOptionTableAlias, $strAttributeValueTableAlias, $strAttributeOptionTableAlias, $strValue)); $objQqNode = QQ::CustomNode(sprintf('%s.attribute_option_id', $strAttributeOptionTableAlias)); break; default: throw new Exception('No Support for Attribute Data Type Id: ' . $objAttribute->AttributeDataTypeId); } return $objQqNode; }
/** * Static Helper Method to Create using PK arguments * You must pass in the PK arguments on an object to load, or leave it blank to create a new one. * If you want to load via QueryString or PathInfo, use the CreateFromQueryString or CreateFromPathInfo * static helper methods. Finally, specify a CreateType to define whether or not we are only allowed to * edit, or if we are also allowed to create a new one, etc. * * @param mixed $objParentObject QForm or QPanel which will be using this AttributeMetaControl * @param integer $intId primary key value * @param QMetaControlCreateType $intCreateType rules governing Attribute object creation - defaults to CreateOrEdit * @return AttributeMetaControl */ public static function Create($objParentObject, $intId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit) { // Attempt to Load from PK Arguments if (strlen($intId)) { $objAttribute = Attribute::Load($intId); // Attribute was found -- return it! if ($objAttribute) { return new AttributeMetaControl($objParentObject, $objAttribute); } else { if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) { throw new QCallerException('Could not find a Attribute object with PK arguments: ' . $intId); } } // If EditOnly is specified, throw an exception } else { if ($intCreateType == QMetaControlCreateType::EditOnly) { throw new QCallerException('No PK arguments specified'); } } // If we are here, then we need to create a new record return new AttributeMetaControl($objParentObject, new Attribute()); }
public function btnEditAttribute_Click($strFormId, $strControlId, $strParameter) { $paramArray = explode("_", $strParameter); // First, remove all children panels from pnlRight $this->pnlRight->Display = "block"; $this->pnlRight->DisplayStyle = "block"; $this->pnlRight->RemoveChildControls(true); // Determine where to display the panel $range = 1; if ($paramArray[3] < 5) { $range = 1; } elseif ($paramArray[3] < 15) { $range = 2; } else { $range = 3; } $height = $this->iAttributeCount / $range * 35; $this->strAttributeHeight = sprintf("-%dpx", $height); $this->pnlRight->Top = $this->strAttributeHeight; // Now create a new AttributeEditPanel, setting pnlRight as its parent // and specifying parent form's "CloseRightPanel" as the method callback // See the note in _constructor, above, for more information /*new Vicp_Attributes_Edit($this->pnlRight, null, $this->objPerson,$this->strUrlHashArgument);*/ // Test to see if it works // Special case for Co-Primary. If co-primary, then ensure there is a date of birth if ($paramArray[2] == 'Co-Primary' && !$this->objPerson->DateOfBirth) { $this->lblTitle = new QLabel($this->pnlRight); $this->lblTitle->HtmlEntities = false; $this->lblTitle->Text = "You cannot specify a Co-primary email unless the person has a Date Of Birth specified. <br>Please ensure that this is the case before setting this attribute."; } else { $this->objAttributeValue = AttributeValue::LoadByAttributeIdPersonId($strParameter, $this->objPerson->Id); if (!$this->objAttributeValue) { $this->objAttributeValue = new AttributeValue(); $this->objAttributeValue->AttributeId = $paramArray[0]; $this->objAttributeValue->Person = $this->objPerson; $this->objAttributeValue->Attribute = Attribute::Load($paramArray[0]); } // Determine what to display $this->lblTitle = new QLabel($this->pnlRight); $this->lblTitle->Text = $paramArray[2]; if ($paramArray[2] == 'Co-Primary') { $this->lblTitle->HtmlEntities = false; $this->lblTitle->Text .= '<br>Please not that the Co-Primary email entered MUST be an existing person in noah.'; } $this->lblTitle->CssClass = 'attributeLbl'; switch ($paramArray[1]) { case AttributeDataType::Checkbox: $this->chkValue = new QRadioButtonList($this->pnlRight); $this->chkValue->Name = $paramArray[2]; $this->chkValue->Required = true; $this->chkValue->AddItem('Yes', true, $this->objAttributeValue->BooleanValue === true); $this->chkValue->AddItem('No', false, $this->objAttributeValue->BooleanValue === false); break; case AttributeDataType::Date: case AttributeDataType::DateTime: $this->dtxValue = new QDateTimeTextBox($this->pnlRight); $this->dtxValue->Name = $paramArray[2]; $this->dtxValue->Required = true; $this->calValue = new QCalendar($this->pnlRight, $this->dtxValue); $this->dtxValue->RemoveAllActions(QClickEvent::EventName); if ($this->objAttributeValue->Attribute->AttributeDataTypeId == AttributeDataType::Date) { $this->dtxValue->Text = $this->objAttributeValue->DateValue ? $this->objAttributeValue->DateValue->ToString() : null; } else { $this->dtxValue->Text = $this->objAttributeValue->DatetimeValue ? $this->objAttributeValue->DatetimeValue->ToString() : null; } break; case AttributeDataType::Text: $this->txtValue = new QTextBox($this->pnlRight); $this->txtValue->Name = $paramArray[2]; $this->txtValue->Required = true; $this->txtValue->TextMode = QTextMode::MultiLine; $this->txtValue->Text = trim($this->objAttributeValue->TextValue); $this->txtValue->FontNames = QFontFamily::Arial; $this->txtValue->FontSize = '11px'; $this->txtValue->Width = '380px'; $this->txtValue->Height = '200px'; break; case AttributeDataType::ImmutableSingleDropdown: $this->lstValue = new QListBox($this->pnlRight); $this->lstValue->Name = $paramArray[2]; $this->lstValue->Required = true; if (!$this->objAttributeValue->SingleAttributeOptionId) { $this->lstValue->AddItem('- Select One -'); } foreach ($this->objAttributeValue->Attribute->GetAttributeOptionArray(QQ::OrderBy(QQN::AttributeOption()->Name)) as $objOption) { $this->lstValue->AddItem($objOption->Name, $objOption->Id, $objOption->Id == $this->objAttributeValue->SingleAttributeOptionId); } break; case AttributeDataType::ImmutableMultipleDropdown: $this->lstValue = new QListBox($this->pnlRight); $this->lstValue->Name = $paramArray[2]; $this->lstValue->Required = true; $this->lstValue->SelectionMode = QSelectionMode::Multiple; $this->lstValue->Width = '200px'; $this->lstValue->Height = '200px'; $intSelectedIdArray = array(); if ($this->objAttributeValue->Id) { foreach ($this->objAttributeValue->GetAttributeOptionAsMultipleArray() as $objOption) { $intSelectedIdArray[$objOption->Id] = $objOption->Id; } } foreach ($this->objAttributeValue->Attribute->GetAttributeOptionArray(QQ::OrderBy(QQN::AttributeOption()->Name)) as $objOption) { $this->lstValue->AddItem($objOption->Name, $objOption->Id, array_key_exists($objOption->Id, $intSelectedIdArray)); } break; case AttributeDataType::MutableSingleDropdown: $this->lstValue = new QListBox($this->pnlRight); $this->lstValue->Name = $paramArray[2]; $this->lstValue->Required = true; foreach ($this->objAttributeValue->Attribute->GetAttributeOptionArray(QQ::OrderBy(QQN::AttributeOption()->Name)) as $objOption) { $this->lstValue->AddItem($objOption->Name, $objOption->Id, $objOption->Id == $this->objAttributeValue->SingleAttributeOptionId); } $this->lstValue->AddItem('- Other... -', -1); $this->txtAddItem = new QTextBox($this->pnlRight); $this->txtAddItem->Name = 'Add a Value'; $this->txtAddItem->Visible = false; $this->lstValue->AddAction(new QChangeEvent(), new QAjaxControlAction($this, 'lstValue_Change')); $this->txtAddItem->AddAction(new QEnterKeyEvent(), new QTerminateAction()); break; case AttributeDataType::MutableMultipleDropdown: $this->lstValue = new QListBox($this->pnlRight); $this->lstValue->Name = $paramArray[2]; $this->lstValue->Required = true; $this->lstValue->SelectionMode = QSelectionMode::Multiple; $this->lstValue->Width = '200px'; $this->lstValue->Height = '200px'; $intSelectedIdArray = array(); if ($this->objAttributeValue->Id) { foreach ($this->objAttributeValue->GetAttributeOptionAsMultipleArray() as $objOption) { $intSelectedIdArray[$objOption->Id] = $objOption->Id; } } foreach ($this->objAttributeValue->Attribute->GetAttributeOptionArray(QQ::OrderBy(QQN::AttributeOption()->Name)) as $objOption) { $this->lstValue->AddItem($objOption->Name, $objOption->Id, array_key_exists($objOption->Id, $intSelectedIdArray)); } $this->txtAddItem = new QTextBox($this->pnlRight); $this->txtAddItem->Name = 'Add a Value'; $this->txtAddItem->AddAction(new QEnterKeyEvent(), new QAjaxControlAction($this, 'txtAddItem_Enter')); $this->txtAddItem->AddAction(new QEnterKeyEvent(), new QTerminateAction()); break; default: throw new Exception('Unhandled AttributeDataTypeId: ' . $this->objAttributeValue->Attribute->AttributeDataTypeId); } // Add a save button $this->btnSaveEdit = new QButton($this->pnlRight); $this->btnSaveEdit->Text = 'Save'; $this->btnSaveEdit->CssClass = 'attributeBtn'; $this->btnSaveEdit->AddAction(new QClickEvent(), new QAjaxControlAction($this, 'btnSaveEdit_Click')); $this->btnSaveEdit->CausesValidation = $this; } }
/** * Override method to perform a property "Get" * This will get the value of $strName * * @param string $strName Name of the property to get * @return mixed */ public function __get($strName) { switch ($strName) { /////////////////// // Member Variables /////////////////// case 'Id': // Gets the value for intId (Read-Only PK) // @return integer return $this->intId; case 'AttributeId': // Gets the value for intAttributeId (Not Null) // @return integer return $this->intAttributeId; case 'PersonId': // Gets the value for intPersonId (Not Null) // @return integer return $this->intPersonId; case 'DateValue': // Gets the value for dttDateValue // @return QDateTime return $this->dttDateValue; case 'DatetimeValue': // Gets the value for dttDatetimeValue // @return QDateTime return $this->dttDatetimeValue; case 'TextValue': // Gets the value for strTextValue // @return string return $this->strTextValue; case 'BooleanValue': // Gets the value for blnBooleanValue // @return boolean return $this->blnBooleanValue; case 'SingleAttributeOptionId': // Gets the value for intSingleAttributeOptionId // @return integer return $this->intSingleAttributeOptionId; /////////////////// // Member Objects /////////////////// /////////////////// // Member Objects /////////////////// case 'Attribute': // Gets the value for the Attribute object referenced by intAttributeId (Not Null) // @return Attribute try { if (!$this->objAttribute && !is_null($this->intAttributeId)) { $this->objAttribute = Attribute::Load($this->intAttributeId); } return $this->objAttribute; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } case 'Person': // Gets the value for the Person object referenced by intPersonId (Not Null) // @return Person try { if (!$this->objPerson && !is_null($this->intPersonId)) { $this->objPerson = Person::Load($this->intPersonId); } return $this->objPerson; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } case 'SingleAttributeOption': // Gets the value for the AttributeOption object referenced by intSingleAttributeOptionId // @return AttributeOption try { if (!$this->objSingleAttributeOption && !is_null($this->intSingleAttributeOptionId)) { $this->objSingleAttributeOption = AttributeOption::Load($this->intSingleAttributeOptionId); } return $this->objSingleAttributeOption; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } //////////////////////////// // Virtual Object References (Many to Many and Reverse References) // (If restored via a "Many-to" expansion) //////////////////////////// //////////////////////////// // Virtual Object References (Many to Many and Reverse References) // (If restored via a "Many-to" expansion) //////////////////////////// case '_AttributeOptionAsMultiple': // Gets the value for the private _objAttributeOptionAsMultiple (Read-Only) // if set due to an expansion on the attributevalue_multipleattributeoption_assn association table // @return AttributeOption return $this->_objAttributeOptionAsMultiple; case '_AttributeOptionAsMultipleArray': // Gets the value for the private _objAttributeOptionAsMultipleArray (Read-Only) // if set due to an ExpandAsArray on the attributevalue_multipleattributeoption_assn association table // @return AttributeOption[] return (array) $this->_objAttributeOptionAsMultipleArray; case '__Restored': return $this->__blnRestored; default: try { return parent::__get($strName); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } } }
/** * Reload this Attribute from the database. * @return void */ public function Reload() { // Make sure we are actually Restored from the database if (!$this->__blnRestored) { throw new QCallerException('Cannot call Reload() on a new, unsaved Attribute object.'); } // Reload the Object $objReloaded = Attribute::Load($this->intId); // Update $this's local variables to match $this->AttributeDataTypeId = $objReloaded->AttributeDataTypeId; $this->strName = $objReloaded->strName; }
/** * Override method to perform a property "Get" * This will get the value of $strName * * @param string $strName Name of the property to get * @return mixed */ public function __get($strName) { switch ($strName) { /////////////////// // Member Variables /////////////////// case 'Id': // Gets the value for intId (Read-Only PK) // @return integer return $this->intId; case 'AttributeId': // Gets the value for intAttributeId (Not Null) // @return integer return $this->intAttributeId; case 'Name': // Gets the value for strName // @return string return $this->strName; /////////////////// // Member Objects /////////////////// /////////////////// // Member Objects /////////////////// case 'Attribute': // Gets the value for the Attribute object referenced by intAttributeId (Not Null) // @return Attribute try { if (!$this->objAttribute && !is_null($this->intAttributeId)) { $this->objAttribute = Attribute::Load($this->intAttributeId); } return $this->objAttribute; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } //////////////////////////// // Virtual Object References (Many to Many and Reverse References) // (If restored via a "Many-to" expansion) //////////////////////////// //////////////////////////// // Virtual Object References (Many to Many and Reverse References) // (If restored via a "Many-to" expansion) //////////////////////////// case '_AttributeValueAsMultiple': // Gets the value for the private _objAttributeValueAsMultiple (Read-Only) // if set due to an expansion on the attributevalue_multipleattributeoption_assn association table // @return AttributeValue return $this->_objAttributeValueAsMultiple; case '_AttributeValueAsMultipleArray': // Gets the value for the private _objAttributeValueAsMultipleArray (Read-Only) // if set due to an ExpandAsArray on the attributevalue_multipleattributeoption_assn association table // @return AttributeValue[] return (array) $this->_objAttributeValueAsMultipleArray; case '_AttributeValueAsSingle': // Gets the value for the private _objAttributeValueAsSingle (Read-Only) // if set due to an expansion on the attribute_value.single_attribute_option_id reverse relationship // @return AttributeValue return $this->_objAttributeValueAsSingle; case '_AttributeValueAsSingleArray': // Gets the value for the private _objAttributeValueAsSingleArray (Read-Only) // if set due to an ExpandAsArray on the attribute_value.single_attribute_option_id reverse relationship // @return AttributeValue[] return (array) $this->_objAttributeValueAsSingleArray; case '__Restored': return $this->__blnRestored; default: try { return parent::__get($strName); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } } }