public static function GetStaff()
{
if (!self::Is_Set("sid") || !self::Is_Set("secret")) {
return null;
}
return Staff::Load(self::GetStaffID());
}
<div class="form-group">
<label for="type">Account Type</label>
<select class="form-control" id="type" name="type">
<?php
for ($i = TYPE_FIRST; $i <= TYPE_LAST; $i++) {
echo "<option value=\"" . $i . "\">" . Staff::GetTypeReal($i) . "</option>";
}
?>
</select>
</div>
<button type="submit" name="add" class="btn btn-default">Create Account</button>
</form>
<?php
} elseif (isset($_GET["id"])) {
$staff = Staff::Load($_GET["id"]);
if ($staff->IsValid() && $staff->IsActive() && $me->GetType() == TYPE_SUPERSTAFF) {
if (isset($_POST["edit"])) {
$password = $_POST["password"];
$password_confirm = $_POST["password_confirm"];
$name = $_POST["name"];
$building = $_POST["building"];
$email = CleanString($_POST["email"]);
$phone_number = CleanString($_POST["phone_number"]);
$type = $_POST["type"];
if (empty($name) || empty($building) || empty($email) || empty($phone_number)) {
ShowError("One or more fields were empty!");
} elseif ($password != $password_confirm) {
ShowError("Passwords did not match! Go back and try again.");
} elseif (!Building::Exists($building) && $building !== "N/A") {
ShowError("Invalid building.");
/*
Query
*/
$statement = $database->prepare("SELECT COUNT(*) FROM tickets");
$statement->execute();
$totalNumRows = $statement->fetch(PDO::FETCH_NUM);
$statement = $database->prepare("SELECT SQL_CALC_FOUND_ROWS " . implode(",", $aColumns) . " FROM tickets " . $sWhere . " " . $sOrder . " " . $sLimit);
$statement->execute();
$statement2 = $database->prepare("SELECT FOUND_ROWS()");
$statement2->execute();
$filteredNumRows = $statement2->fetch(PDO::FETCH_NUM);
$rows = $statement->fetchAll(PDO::FETCH_ASSOC);
$rowCount = count($rows);
for ($i = 0; $i < $rowCount; $i++) {
$row = $rows[$i];
$color = "";
if ($q == -1) {
$color = " danger";
$rows[$i] = array($row["id"], Client::Load($row["cid"])->GetUsername(), DisplayDatetime($row["creation_date"]), DisplayLimited($row["description"]));
} else {
$sid = $row["sid"];
$status = $row["status"];
if ($sid == $me->GetID()) {
$color = " " . ($status == STATUS_OPENED ? "danger" : "success");
}
$rows[$i] = array($row["id"], $status == STATUS_OPENED ? "Opened" : "Closed", Client::Load($row["cid"])->GetUsername(), DisplayDatetime($row["creation_date"]), DisplayLimited($row["description"]), implode(", ", json_decode($row["tags"], true)), Staff::Load($sid)->GetUsername(), DisplayDatetime($row["closed_date"]));
}
$rows[$i]["DT_RowClass"] = "linkrow" . $color;
}
$output = array("sEcho" => intval($_GET['sEcho']), "iTotalRecords" => $totalNumRows[0], "iTotalDisplayRecords" => $filteredNumRows[0], "aaData" => $rows);
echo json_encode($output);
</div>
</div>
<?php
$updates = $ticket->GetUpdates();
if (!is_null($updates)) {
?>
<div class="row">
<div class="col-lg-12">
<?php
for ($i = 0; $i < count($updates); $i++) {
$update = $updates[$i];
$id = $update["id"];
$time = $update["time"];
$description = $update["description"];
$update_staff = Staff::Load($id);
?>
<div class="panel panel-default">
<div class="panel-heading">
Update #<?php
echo $i + 1;
?>
- <?php
echo $update_staff->GetUsername();
?>
- <?php
echo DisplayDatetime($time);
?>
</div>
<div class="panel-body">
<?php
