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