}
}
if ($_SESSION['delId'][$delId]['Total'] > 0) {
$eventsDeletedCount = deleteEventsByFilter();
$_SESSION['delId'][$delId]['Deleted'] += $eventsDeletedCount;
$deletedPercent = $_SESSION['delId'][$delId]['Deleted'] * 100 / $_SESSION['delId'][$delId]['Total'];
if ($_SESSION['delId'][$delId]['Deleted'] - $_SESSION['delId'][$delId]['Total'] == 0) {
$deleteSensorResult = deleteSensor($_SESSION['delFilter']['src_sensor']);
$result = array('Total' => $_SESSION['delId'][$delId]['Total'], 'Current' => $_SESSION['delId'][$delId]['Deleted'], 'Percent' => $deletedPercent, 'SensorDelete' => $deleteSensorResult);
unset($_SESSION['delFilter']);
unset($_SESSION['delId']);
} else {
$result = array('Total' => $_SESSION['delId'][$delId]['Total'], 'Current' => $_SESSION['delId'][$delId]['Deleted'], 'Percent' => $deletedPercent, 'SensorDelete' => $deleteSensorResult);
}
} else {
$deleteSensorResult = deleteSensor($_SESSION['delFilter']['src_sensor']);
unset($_SESSION['delFilter']);
unset($_SESSION['delId']);
$result = array('Total' => 0, 'Current' => 0, 'Percent' => 100, 'SensorDelete' => $deleteSensorResult);
}
sleep(2);
print json_encode($result);
} elseif (isset($_GET['getWebHostsPartial'])) {
// Query web hostnames partially, using autocomplete from filter interface.
if (strlen($_GET['getWebHostsPartial']) > 2) {
$webHostsList = getWebHostsPartial($_GET['getWebHostsPartial']);
} else {
$webHostsList = "{}";
}
print json_encode($webHostsList);
} else {
$stid = oci_parse($conn, $sql);
$res = oci_execute($stid);
while ($row = oci_fetch_array($stid, OCI_ASSOC)) {
foreach ($row as $id) {
echo "<option value={$id}>{$id}</option>";
}
}
?>
</select>
<input type="submit" name="delete_person" value="Delete">
</form>
</div>
<br />
<span style="color:green">
<?php
addPerson($conn);
addUser($conn);
addSensor($conn);
deleteUser($conn);
deletePerson($conn);
deleteSensor($conn);
updatePerson($conn);
updateUser($conn);
?>
</span>
</body>
</html>
