/** * Gets all associated RoleEntityQtypeCustomFieldAuthorizations as an array of RoleEntityQtypeCustomFieldAuthorization objects * @param QQClause[] $objOptionalClauses additional optional QQClause objects for this query * @return RoleEntityQtypeCustomFieldAuthorization[] */ public function GetRoleEntityQtypeCustomFieldAuthorizationArray($objOptionalClauses = null) { if (is_null($this->intEntityQtypeCustomFieldId)) { return array(); } try { return RoleEntityQtypeCustomFieldAuthorization::LoadArrayByEntityQtypeCustomFieldId($this->intEntityQtypeCustomFieldId, $objOptionalClauses); } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } }
/** * Deletes all associated RoleEntityQtypeCustomFieldAuthorizations * @return void */ public function DeleteAllRoleEntityQtypeCustomFieldAuthorizations() { if (is_null($this->intEntityQtypeCustomFieldId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateRoleEntityQtypeCustomFieldAuthorization on this unsaved EntityQtypeCustomField.'); } // Get the Database Object for this Class $objDatabase = EntityQtypeCustomField::GetDatabase(); // Journaling if ($objDatabase->JournalingDatabase) { foreach (RoleEntityQtypeCustomFieldAuthorization::LoadArrayByEntityQtypeCustomFieldId($this->intEntityQtypeCustomFieldId) as $objRoleEntityQtypeCustomFieldAuthorization) { $objRoleEntityQtypeCustomFieldAuthorization->Journal('DELETE'); } } // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `role_entity_qtype_custom_field_authorization` WHERE `entity_qtype_custom_field_id` = ' . $objDatabase->SqlVariable($this->intEntityQtypeCustomFieldId) . ' '); }
protected function DeleteEntityQtypeCustomFields() { $objEntityQtypeCustomFieldArray = EntityQtypeCustomField::LoadArrayByCustomFieldId($this->objCustomField->CustomFieldId); if ($objEntityQtypeCustomFieldArray) { foreach ($objEntityQtypeCustomFieldArray as $objEntityQtypeCustomField) { // If the EntityQtype needs to be deleted, you must delete EntityQtypeId for all roles in RoleEntityQTypeCustomFieldAuthorization $objRoleEntityCustomAuthArray = RoleEntityQtypeCustomFieldAuthorization::LoadArrayByEntityQtypeCustomFieldId($objEntityQtypeCustomField->EntityQtypeCustomFieldId); if ($objRoleEntityCustomAuthArray) { foreach ($objRoleEntityCustomAuthArray as $objRoleEntityCustomAuth) { $objRoleEntityCustomAuth->Delete(); } } // If there was Asset Type Custom field Delete AssetCustomField if ($objEntityQtypeCustomField->EntityQtypeId == 1) { $this->DeleteAssetCustomFieldAssetModels(); } // If the helper table exists for that EntityQtype delete the columns in the helper table if ($strHelperTableArray = CustomFieldValue::GetHelperTableByEntityQtypeId($objEntityQtypeCustomField->EntityQtypeId)) { $strHelperTable = $strHelperTableArray[0]; $objDatabase = CustomField::GetDatabase(); $strQuery = sprintf("ALTER TABLE %s DROP `cfv_%s`;", $strHelperTable, $objEntityQtypeCustomField->CustomFieldId); $objDatabase->NonQuery($strQuery); } // Delete the EntityQtypeCustomField last $objEntityQtypeCustomField->Delete(); } } }
protected function DeleteEntityQtypeCustomFields() { $objEntityQtypeCustomFieldArray = EntityQtypeCustomField::LoadArrayByCustomFieldId($this->objCustomField->CustomFieldId); if ($objEntityQtypeCustomFieldArray) { foreach ($objEntityQtypeCustomFieldArray as $objEntityQtypeCustomField) { // If the EntityQtype needs to be deleted, you must delete EntityQtypeId for all roles in RoleEntityQTypeCustomFieldAuthorization $objRoleEntityCustomAuthArray = RoleEntityQtypeCustomFieldAuthorization::LoadArrayByEntityQtypeCustomFieldId($objEntityQtypeCustomField->EntityQtypeCustomFieldId); if ($objRoleEntityCustomAuthArray) { foreach ($objRoleEntityCustomAuthArray as $objRoleEntityCustomAuth) { $objRoleEntityCustomAuth->Delete(); } } // Delete the EntityQtypeCustomField last //$objEntityQtypeCustomField->Delete(); } } }