$call_request = $call->call_request;
$call_department = $call->call_department;
$call_device = $call->call_device;
$request_name = $db->get_var("SELECT type_name from site_types WHERE (type_id = {$call_request});");
$department_name = $db->get_var("SELECT type_name from site_types WHERE (type_id = {$call_department});");
$device_name = $db->get_var("SELECT type_name from site_types WHERE (type_id = {$call_device});");
//show closed or deleted as muted.
$display = "";
if ($call_status != 0) {
$display = " class='text-muted'";
}
echo "<tr{$display}>\n<td style='text-align: center;'><a href='fhd_call_details.php?call_id={$call_id}'><i class='fa fa-eye' title='view'></i></a></td>\n";
if ($user_level != 1) {
echo "<td style='text-align: center;'><a href='fhd_call_edit.php?call_id={$call_id}'><i class='fa fa-pencil-square-o' title='edit'></i></a></td>\n";
}
echo "<td>" . call_status($call_status) . "</td></td><td>{$call_date}</td>\n<td>{$call_first_name} {$call_last_name}</td>\n<td>{$request_name}</td>\n<td>{$department_name}</td>\n<td>{$device_name}</td>\n</tr>\n";
}
?>
</table>
<?php
}
//</RESULTS>
?>
<h4 id="searchform"><i class='fa fa-search'></i> Ticket Search</h4>
<form action="fhd_search.php" method="get" name="chooseDateForm" class="form-horizontal">
<table class="<?php
echo $table_style_3;
?>
" style='width: auto;'>
echo $table_style_2;
?>
" style='width: auto;'>
<?php
$call_id = $site_calls->call_id;
$call_status = $site_calls->call_status;
$call_request = $site_calls->call_request;
$request_name = $db->get_var("SELECT type_name from site_types WHERE (type_id = {$call_request});");
$call_department = $site_calls->call_department;
$department_name = $db->get_var("SELECT type_name from site_types WHERE (type_id = {$call_department});");
$call_device = $site_calls->call_device;
$device_name = $db->get_var("SELECT type_name from site_types WHERE (type_id = {$call_device});");
$call_staff = $site_calls->call_staff;
$staff_name = $db->get_var("SELECT user_name from site_users WHERE (user_id = {$call_staff});");
$call_date = date("Y-m-d", $site_calls->call_date + FHD_TIMEADJUST * 3600);
echo "<tr><td>Status</td><td>" . call_status($site_calls->call_status) . "</td></tr>\n";
echo "<tr><td>Date</td><td>" . $call_date . "</td></tr>\n";
if ($call_status == 1) {
echo "<tr><td>Closed</td><td>" . date('Y-m-d', $site_calls->call_date2) . "</td></tr>\n";
}
echo "<tr><td>Name</td><td>" . $site_calls->call_first_name . "</td></tr>\n";
echo "<tr><td>Email</td><td>" . $site_calls->call_email . "</td></tr>\n";
echo "<tr><td>Dept</td><td>{$department_name}</td></tr>\n";
echo "<tr><td>Request</td><td>{$request_name}</td></tr>\n";
echo "<tr><td>Device</td><td>{$device_name}</td></tr>\n";
echo "<tr><td>Details</td><td style='width: 500px;'>" . $site_calls->call_details . "</td></tr>\n";
echo "<tr><td>Solution</td><td style='width: 500px;'>" . $site_calls->call_solution . "</td></tr>\n";
echo "<tr><td>Staff</td><td>{$staff_name}</td></tr>\n";
//********** manage file upload
if (FHD_UPLOAD_ALLOW == "yes") {
$getuploads = $db->get_results("SELECT id,call_id,file_name,file_ext,timestamp FROM site_upload WHERE call_id = {$call_id};");