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"];