/*
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);
public function GetEmailBody($clientid, $name, $community, $building, $room)
{
return "\n\nTicket #" . $this->GetID() . "\nClient ID: " . $clientid . "\nClient Name: " . $name . "\nCommunity: " . $community . "\nBuilding: " . $building . "\nRoom: " . $room . "\nOpen Date: " . DisplayDatetime($this->GetCreationDate()) . "\nDescription: " . $this->GetDescription();
}
<th>#</th>
<th>Client</th>
<th>Opened Date</th>
<th>Closed Date</th>
</tr>
</thead>
<tbody class="searchable rowlink" data-link="row">
<?php
$tickets = Ticket::GetByStaffIDWithStatusOrderLimit($me->GetID(), STATUS_CLOSED, "closed_date", "DESC", 20);
foreach ($tickets as $ticket) {
$client = Client::Load($ticket->GetClientID());
echo "<tr class='linkrow success' href='index.php?p=ticket&id=" . $ticket->GetID() . "'>";
echo "<td>" . $ticket->GetID() . "</td>";
echo "<td>" . $client->GetUsername() . "</td>";
echo "<td>" . DisplayDatetime($ticket->GetCreationDate()) . "</td>";
echo "<td>" . DisplayDatetime($ticket->GetClosedDate()) . "</td>";
echo "</tr>";
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-4">
<div class="panel panel-primary">
<div class="panel-heading">
<i class="fa fa-bar-chart-o fa-fw"></i> Lifetime Ticket Stats
$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
echo $description;
?>
</div>
</div>
<?php
}
?>
</div>
</div>
<?php
