public static function getSecurityClearance($_id)
{
$mysqli = Database::connect();
$query = "SELECT security_clearance FROM business_groups WHERE id = " . $_id . " LIMIT 1";
$result = $mysqli->query($query);
if (count($result) > 0 && !is_null($result)) {
$id = $result[0]['security_clearance'];
return SecurityClearance::get($id);
}
return false;
}
if ($action == 'new') {
if ($do == 'none') {
?>
<form action="#" method="POST">
<input type="hidden" id="assignees" name="assignees" />
<table>
<tr>
<th><label for="subject">Title:</label></th>
<td><input type="text" id="subject" name="subject" required /></td>
</tr>
<tr>
<th><label for="clearance">Clearance:</label></th>
<td>
<select id="clearance" name="clearance">
<?php
foreach (SecurityClearance::getAllClearances() as $val => $name) {
if ($val != 0) {
echo '<option value=' . $val . '>' . $name . '</option>';
}
}
?>
</select>
</td>
</tr>
<tr>
<th><label for="prefix">Prefix:</label></th>
<td>
<select id="prefix" name="prefix">
<?php
foreach (DocPrefix::getAllPrefixes() as $val => $prefix) {
if ($val != 0) {