function cleanDBonPurge()
{
global $DB;
// Clean sla_levels
$query = "SELECT `id`\n FROM `glpi_slalevels`\n WHERE `slts_id` = '" . $this->fields['id'] . "'";
if ($result = $DB->query($query)) {
if ($DB->numrows($result) > 0) {
$slalevel = new SlaLevel();
while ($data = $DB->fetch_assoc($result)) {
$slalevel->delete($data);
}
}
}
// Update tickets : clean SLT
list($dateField, $sltField) = self::getSltFieldNames($this->fields['type']);
$query = "SELECT `id`\n FROM `glpi_tickets`\n WHERE `{$sltField}` = '" . $this->fields['id'] . "'";
if ($result = $DB->query($query)) {
if ($DB->numrows($result) > 0) {
$ticket = new Ticket();
while ($data = $DB->fetch_assoc($result)) {
$ticket->deleteSLT($data['id'], $this->fields['type']);
}
}
}
Rule::cleanForItemAction($this);
}