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