Ejemplo n.º 1
0
 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();
 }