/* 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