function categories_deactivate_children($parent_id, $level = 0)
{
global $db, $ENTRADA_USER;
if ($level > 99) {
exit;
}
$query = "\tSELECT * FROM `" . CLERKSHIP_DATABASE . "`.`categories`\n\t\t\t\tWHERE `category_parent` = " . $db->qstr($parent_id) . "\n\t\t\t\tAND `category_status` != 'trash'\n\t\t\t\tGROUP BY `category_id`";
$categories = $db->GetAll($query);
if ($categories) {
foreach ($categories as $category) {
$query = "UPDATE `" . CLERKSHIP_DATABASE . "`.`categories` SET `category_status` = 'trash', `updated_date` = " . $db->qstr(time()) . ", `updated_by` = " . $db->qstr($ENTRADA_USER->getID()) . " WHERE `category_id` = " . $db->qstr($category["category_id"]);
$level++;
if ($db->Execute($query)) {
return categories_deactivate_children($category["category_id"], $level);
}
}
} elseif ($level) {
return true;
}
return false;
}
}
if ($MODE == "ajax" && $CATEGORY_ID) {
ob_clear_open_buffers();
switch ($STEP) {
case "2":
if ($_POST["confirm"] == "on") {
$query = "\tSELECT * FROM `" . CLERKSHIP_DATABASE . "`.`categories`\n\t\t\t\t\t\t\t\tWHERE `category_id` = " . $db->qstr($CATEGORY_ID) . "\n\t\t\t\t\t\t\t\tAND `category_status` != 'trash'\n\t\t\t\t\t\t\t\tGROUP BY `category_id`";
$categories = $db->GetAll($query);
if ($categories) {
foreach ($categories as $category) {
$query = "UPDATE `" . CLERKSHIP_DATABASE . "`.`categories` SET `category_status` = 'trash', `updated_date` = " . $db->qstr(time()) . ", `updated_by` = " . $db->qstr($ENTRADA_USER->getID()) . " WHERE `category_id` = " . $db->qstr($category["category_id"]);
if (!$db->Execute($query)) {
application_log("Failed to update [" . CLERKSHIP_DATABASE . ".categories], DB said: " . $db->ErrorMsg());
}
}
categories_deactivate_children($CATEGORY_ID);
echo json_encode(array("status" => "success"));
}
} else {
echo json_encode(array("status" => "error"));
}
break;
case 1:
default:
$query = "\tSELECT * FROM `" . CLERKSHIP_DATABASE . "`.`categories`\n\t\t\t\t\t\t\tWHERE `category_id` = " . $db->qstr($CATEGORY_ID) . "\n\t\t\t\t\t\t\tAND `category_status` != 'trash'";
$category = $db->GetRow($query);
if ($category) {
?>
<div class="display-generic">
<p>You are about to delete the category <strong><?php
echo $category["category_name"];
