function cleanDBonPurge()
{
global $DB;
$query1 = "DELETE\n FROM `glpi_changetasks`\n WHERE `changes_id` = '" . $this->fields['id'] . "'";
$DB->query($query1);
$cp = new Change_Problem();
$cp->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
$ct = new Change_Ticket();
$ct->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
$cp = new Change_Project();
$cp->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
$ci = new Change_Item();
$ci->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
$cv = new ChangeValidation();
$cv->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
$cc = new ChangeCost();
$cc->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
parent::cleanDBonPurge();
}
function cleanDBonPurge()
{
global $DB;
$query1 = "DELETE\n FROM `glpi_problemtasks`\n WHERE `problems_id` = '" . $this->fields['id'] . "'";
$DB->query($query1);
$pt = new Problem_Ticket();
$pt->cleanDBonItemDelete('Problem', $this->fields['id']);
$ip = new Item_Problem();
$ip->cleanDBonItemDelete('Problem', $this->fields['id']);
parent::cleanDBonPurge();
}
function cleanDBonPurge()
{
global $DB;
$query1 = "DELETE\n FROM `glpi_tickettasks`\n WHERE `tickets_id` = '" . $this->fields['id'] . "'";
$DB->query($query1);
$query1 = "DELETE\n FROM `glpi_ticketfollowups`\n WHERE `tickets_id` = '" . $this->fields['id'] . "'";
$DB->query($query1);
$ts = new TicketValidation();
$ts->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$query1 = "DELETE\n FROM `glpi_ticketsatisfactions`\n WHERE `tickets_id` = '" . $this->fields['id'] . "'";
$DB->query($query1);
$pt = new Problem_Ticket();
$pt->cleanDBonItemDelete('Ticket', $this->fields['id']);
$ts = new TicketCost();
$ts->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$slaLevel_ticket = new SlaLevel_Ticket();
$slaLevel_ticket->deleteForTicket($this->getID(), SLT::TTO);
$slaLevel_ticket->deleteForTicket($this->getID(), SLT::TTR);
$query1 = "DELETE\n FROM `glpi_tickets_tickets`\n WHERE `tickets_id_1` = '" . $this->fields['id'] . "'\n OR `tickets_id_2` = '" . $this->fields['id'] . "'";
$DB->query($query1);
$ct = new Change_Ticket();
$ct->cleanDBonItemDelete(__CLASS__, $this->fields['id']);
$ip = new Item_Ticket();
$ip->cleanDBonItemDelete('Ticket', $this->fields['id']);
parent::cleanDBonPurge();
}
function cleanDBonPurge()
{
global $DB;
/// TODO uncomment when changetask OK
// $query1 = "DELETE
// FROM `glpi_changetasks`
// WHERE `changes_id` = '".$this->fields['id']."'";
// $DB->query($query1);
parent::cleanDBonPurge();
}
