public function Delete()
{
$objCustomFieldValue = CustomFieldValue::Load($this->CustomFieldValueId);
//parent::Delete();
$objDatabase = CustomFieldSelection::GetDatabase();
// If the helper table exists
if ($objCustomFieldValue && ($strHelperTableArray = CustomFieldValue::GetHelperTableByEntityQtypeId($this->EntityQtypeId))) {
$strHelperTable = $strHelperTableArray[0];
$strTableName = $strHelperTableArray[1];
$strQuery = sprintf("UPDATE %s SET `cfv_%s`='' WHERE `%s_id`='%s';", $strHelperTable, $objCustomFieldValue->CustomFieldId, $strTableName, $this->EntityId);
$objDatabase->NonQuery($strQuery);
}
}
/**
* Truncate custom_field_selection table
* @return void
*/
public static function Truncate()
{
// Get the Database Object for this Class
$objDatabase = CustomFieldSelection::GetDatabase();
// Perform the Query
$objDatabase->NonQuery('
TRUNCATE `custom_field_selection`');
}