本文整理汇总了PHP中Ticket_User::cleanDBonItemDelete方法的典型用法代码示例。如果您正苦于以下问题：PHP Ticket_User::cleanDBonItemDelete方法的具体用法？PHP Ticket_User::cleanDBonItemDelete怎么用？PHP Ticket_User::cleanDBonItemDelete使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Ticket_User的用法示例。
在下文中一共展示了Ticket_User::cleanDBonItemDelete方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: cleanDBonPurge
function cleanDBonPurge()
{
global $DB;
$query = "SELECT `id`\n FROM `glpi_tickettasks`\n WHERE `tickets_id` = '" . $this->fields['id'] . "'";
$result = $DB->query($query);
if ($DB->numrows($result) > 0) {
while ($data = $DB->fetch_array($result)) {
$querydel = "DELETE\n FROM `glpi_ticketplannings`\n WHERE `tickettasks_id` = '" . $data['id'] . "'";
$DB->query($querydel);
}
}
$query1 = "DELETE\n FROM `glpi_tickettasks`\n WHERE `tickets_id` = '" . $this->fields['id'] . "'";
$DB->query($query1);
$query1 = "DELETE\n FROM `glpi_ticketvalidations`\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);
$query1 = "DELETE\n FROM `glpi_ticketsatisfactions`\n WHERE `tickets_id` = '" . $this->fields['id'] . "'";
$DB->query($query1);
$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);
$query1 = "DELETE\n FROM `glpi_slalevels_tickets`\n WHERE `tickets_id` = '" . $this->fields['id'] . "'";
$DB->query($query1);
$tu = new Ticket_User();
$tu->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$gt = new Group_Ticket();
$gt->cleanDBonItemDelete($this->getType(), $this->fields['id']);
}示例2: cleanDBonPurge
function cleanDBonPurge()
{
global $DB;
$query = "DELETE\n FROM `glpi_profiles_users`\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
if ($this->fields['id'] > 0) {
// Security
$query = "DELETE\n FROM `glpi_displaypreferences`\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
$query = "DELETE\n FROM `glpi_bookmarks_users`\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
}
// Delete own reminders
$query = "DELETE\n FROM `glpi_reminders`\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
// Delete private bookmark
$query = "DELETE\n FROM `glpi_bookmarks`\n WHERE `users_id` = '" . $this->fields['id'] . "'\n AND `is_private` = '1'";
$DB->query($query);
// Set no user to public bookmark
$query = "UPDATE `glpi_bookmarks`\n SET `users_id` = '0'\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
// Set no user to consumables
$query = "UPDATE `glpi_consumables`\n SET `items_id` = '0'\n WHERE `items_id` = '" . $this->fields['id'] . "'\n AND `itemtype` = 'User'";
$DB->query($query);
$gu = new Group_User();
$gu->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$tu = new Ticket_User();
$tu->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$pu = new Problem_User();
$pu->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$kiu = new KnowbaseItem_User();
$kiu->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$ru = new Reminder_User();
$ru->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$ue = new UserEmail();
$ue->deleteByCriteria(array('users_id' => $this->fields['id']));
// Ticket rules use various _users_id_*
Rule::cleanForItemAction($this, '_users_id%');
Rule::cleanForItemCriteria($this, '_users_id%');
}示例3: cleanDBonPurge
function cleanDBonPurge()
{
global $DB;
$query = "DELETE\n FROM `glpi_profiles_users`\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
if ($this->fields['id'] > 0) {
// Security
$query = "DELETE\n FROM `glpi_displaypreferences`\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
$query = "DELETE\n FROM `glpi_bookmarks_users`\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
}
// Delete private reminder
$query = "DELETE\n FROM `glpi_reminders`\n WHERE `users_id` = '" . $this->fields['id'] . "'\n AND `is_private` = '1'";
$DB->query($query);
// Set no user to public reminder
$query = "UPDATE `glpi_reminders`\n SET `users_id` = '0'\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
// Delete private bookmark
$query = "DELETE\n FROM `glpi_bookmarks`\n WHERE `users_id` = '" . $this->fields['id'] . "'\n AND `is_private` = '1'";
$DB->query($query);
// Set no user to public bookmark
$query = "UPDATE `glpi_bookmarks`\n SET `users_id` = '0'\n WHERE `users_id` = '" . $this->fields['id'] . "'";
$DB->query($query);
$gu = new Group_User();
$gu->cleanDBonItemDelete($this->getType(), $this->fields['id']);
$tu = new Ticket_User();
$tu->cleanDBonItemDelete($this->getType(), $this->fields['id']);
}