Файл: whmcs/modules/reports/ticket_ratings_reviewer.php
Строк: 65
<?php
if (!defined("WHMCS"))
die("This file cannot be accessed directly");
require(ROOTDIR.'/includes/ticketfunctions.php');
if (!$rating) $rating='1';
if (!$startdate) $startdate = fromMySQLDate(date("Y-m-d",mktime(0,0,0,date("m"),date("d")-7,date("Y"))));
if (!$enddate) $enddate = fromMySQLDate(date("Y-m-d",mktime(0,0,0,date("m"),date("d"),date("Y"))));
$rsel[$rating] = ' selected';
$query = "SELECT tblticketreplies.*,tbltickets.tid AS ticketid FROM tblticketreplies INNER JOIN tbltickets ON tbltickets.id=tblticketreplies.tid WHERE tblticketreplies.admin!='' AND tblticketreplies.rating='".(int)$rating."' AND tblticketreplies.date BETWEEN '".db_make_safe_human_date($startdate)."' AND '".db_make_safe_human_date($enddate)."' ORDER BY date DESC";
$result = full_query($query);
$num_rows = mysql_num_rows($result);
$reportdata["title"] = "Support Ticket Ratings Reviewer";
$reportdata["description"] = "This report is showing all $num_rows ticket replies rated $rating between $startdate & $enddate for review";
$reportdata["headertext"] = '<form method="post" action="reports.php?report=ticket_ratings_reviewer">
<p align="center"><b>Filter:</b> Rating: <select name="rating"><option'.$rsel[1].'>1</option><option'.$rsel[2].'>2</option><option'.$rsel[3].'>3</option><option'.$rsel[4].'>4</option><option'.$rsel[5].'>5</option></select> Between Dates: <input type="text" name="startdate" value="'.$startdate.'" class="datepick" /> and <input type="text" name="enddate" value="'.$enddate.'" class="datepick" /> <input type="submit" value="Filter List" /></p>
</form>';
$reportdata["tableheadings"] = array("Ticket #","Date","Message","Admin","Rating");
while ($data = mysql_fetch_array($result)) {
$tid = $data["tid"];
$ticketid = $data["ticketid"];
$date = $data["date"];
$message = $data["message"];
$admin = $data["admin"];
$rating = $data["rating"];
$date = fromMySQLDate($date,true);
$message = ticketMessageFormat($message);
$reportdata["tablevalues"][] = array('<a href="supporttickets.php?action=viewticket&id='.$tid.'">'.$ticketid.'</a>',$date,'<div align="left">'.$message.'</div>',$admin,$rating);
}
?>