<?php
require_once "../../config.inc.php";
$auth = new auth("ANALYSE_RATINGS");
$page_action = "update";
$go = "update";
$page = new Page("Rating Results");
$form = new EditForm($lang->get("rateres", "Rate Results"));
$interval = array();
$count = countRows("pgn_rating", "RATINGID", "COMMENT <>''");
$steps = $count / 50;
for ($i = 0; $i < $steps; $i++) {
$interval[$i][0] = $i * 50 . " - " . (($i + 1) * 50 - 1);
$interval[$i][1] = $i;
}
$form->add(new Label("lbl", $lang->get("display", "Display"), "standard"));
$form->add(new Select("display", $interval, "standardlight", value("display"), 1));
$grid = new NXGrid("grid", 3);
$grid->setRatio(array(150, 350, 100));
$grid->addRow(array(new Label("lbl", "<b>" . $lang->get("page", "Page") . "</b>"), new Label("lbl", "<b>" . $lang->get("comment", "Comment") . "</b>"), new Label("lbl", "<b>" . $lang->get("date", "Date") . "</b>")));
$thisInterval = value("interval");
$sql = "SELECT SOURCEID, COMMENT, TIMESTAMP FROM pgn_rating WHERE COMMENT <> '' ORDER BY TIMESTAMP DESC";
$query = new query($db, $sql);
while ($query->getrow()) {
$grid->addRow(array(new Label("lbl", resolvePageToLink($query->field("SOURCEID"))), new Label("lbl", str_replace('\\\\', '\\', $query->field("COMMENT"))), new Label("lbl", formatDBTimestamp($query->field('TIMESTAMP')))));
}
$query->free();
$form->add($grid);
$page->add($form);
$page->draw();
/**
* prepare Statistic data
* @param array (0=>timeframe, 1=>valuetype)
*/
function renderStatsData()
{
global $lang;
$output = '<tr><td width="70%" class="underlined">' . $lang->get("path", "Path") . '</td><td width="30%" class="underlined" align="right">' . $lang->get("count", "Count") . '</td></tr>' . "\n";
$this->container .= $output;
for ($i = 0; $i < count($this->data); $i++) {
$spc = "";
$do = $this->data[$i];
$paths = "";
$count = $do->count;
for ($j = 0; $j < $do->length; $j++) {
$paths .= $spc . ($j + 1) . ". " . resolvePageToLink($do->documents[$j]) . "<br>";
$spc .= " ";
}
$this->container .= '<tr><td width="70%" class="underlined">' . $paths . '</td><td width="30%" class="underlined" align="right" valign="top">' . $count . '</td></tr>' . "\n";
}
}
/**
* prepare Statistic data
* @param array (0=>timeframe, 1=>valuetype)
*/
function renderStatsData()
{
global $lang;
$output = '<tr><td width="10%" class="underlined"><b>' . $lang->get("rank", "Rank") . '</b></td><td width="40%" class="underlined"><b>' . $lang->get("page", "Page") . '</b></td><td width="25%" class="underlined" align="right"><b>' . $lang->get("count", "Count") . '</b></td><td width="25%" class="underlined" align="right"><b>' . $lang->get("percent", "Percent") . '</b></td></tr>' . "\n";
$this->container .= $output;
for ($i = 0; $i < count($this->data["top_items"]); $i++) {
$this->container .= "<tr>";
$this->container .= '<td class="underlined">' . ($i + 1) . '</td>';
$this->container .= '<td class="underlined">' . resolvePageToLink($this->data["top_items"][$i]["string"]) . '</td>';
$this->container .= '<td class="underlined" align="right">' . $this->data["top_items"][$i]["count"] . '</td>';
$this->container .= '<td class="underlined" align="right">' . sprintf("%01.2f", $this->data["top_items"][$i]["percent"]) . ' %</td>';
$this->container .= '</tr>';
}
}
