/** * Deletes an associated CustomFieldAsDefault * @param CustomField $objCustomField * @return void */ public function DeleteAssociatedCustomFieldAsDefault(CustomField $objCustomField) { if (is_null($this->intCustomFieldValueId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateCustomFieldAsDefault on this unsaved CustomFieldValue.'); } if (is_null($objCustomField->CustomFieldId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateCustomFieldAsDefault on this CustomFieldValue with an unsaved CustomField.'); } // Get the Database Object for this Class $objDatabase = CustomFieldValue::GetDatabase(); // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `custom_field` WHERE `custom_field_id` = ' . $objDatabase->SqlVariable($objCustomField->CustomFieldId) . ' AND `default_custom_field_value_id` = ' . $objDatabase->SqlVariable($this->intCustomFieldValueId) . ' '); // Journaling if ($objDatabase->JournalingDatabase) { $objCustomField->Journal('DELETE'); } }
/** * Deletes an associated CustomFieldAsCreatedBy * @param CustomField $objCustomField * @return void */ public function DeleteAssociatedCustomFieldAsCreatedBy(CustomField $objCustomField) { if (is_null($this->intUserAccountId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateCustomFieldAsCreatedBy on this unsaved UserAccount.'); } if (is_null($objCustomField->CustomFieldId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateCustomFieldAsCreatedBy on this UserAccount with an unsaved CustomField.'); } // Get the Database Object for this Class $objDatabase = UserAccount::GetDatabase(); // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `custom_field` WHERE `custom_field_id` = ' . $objDatabase->SqlVariable($objCustomField->CustomFieldId) . ' AND `created_by` = ' . $objDatabase->SqlVariable($this->intUserAccountId) . ' '); // Journaling if ($objDatabase->JournalingDatabase) { $objCustomField->Journal('DELETE'); } }