<?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();
/**
* query the rows from the database
*/
function getRows()
{
global $db, $c, $sid, $lang, $auth;
$result = array();
$order = "ca.TITLE";
if ($this->order == "NAME") {
$order = "ca.TITLE";
} else {
if ($this->order == "CATEGORY") {
$order = "ca.CH_CAT_ID";
} else {
if ($this->order == "EDITED") {
$order = "cv.LAST_CHANGED";
} else {
if ($this->order == "CREATED") {
$order = "cv.CREATED_AT";
} else {
if ($this->order == "POSITION") {
$order = "ca.POSITION";
}
}
}
}
}
$order .= " " . $this->orderdir;
// $sql_articles = "Select ca.*, cv.LAST_USER, cv.CREATED_AT, cv.LAST_CHANGED FROM channel_articles ca, cluster_variations cv ".$this->getFilterJoin()." WHERE ca.CHID = ".$this->channelId." AND ca.ARTICLE_ID = cv.CLNID AND cv.VARIATION_ID = ".variation()." AND ca.VERSION=0 " . $this->getFilterSQL() . " ORDER BY $order LIMIT ".(($this->page - 1) * $this->recordsPerPage).",".$this->recordsPerPage;
$sql_articles = "SELECT DISTINCT ca.* FROM channel_articles ca, cluster_variations cv " . $this->getFilterJoin() . " WHERE ca.ARTICLE_ID = cv.CLNID AND ca.CHID = " . $this->channelId . " AND ca.VERSION = 0 " . $this->getFilterSQL() . " ORDER BY {$order} LIMIT " . ($this->page - 1) * $this->recordsPerPage . "," . $this->recordsPerPage;
// echo $sql_articles;
$query = new query($db, $sql_articles);
while ($query->getrow()) {
$tmp = array();
$varexists = true;
$article_id = $query->field("ARTICLE_ID");
$cvdatasql = "SELECT * FROM cluster_variations WHERE CLNID = " . $article_id . " AND VARIATION_ID=" . variation();
$cvdata = new query($db, $cvdatasql);
$cvdata->getrow();
if ($cvdata->count() < 1) {
$varexists = false;
}
array_push($tmp, $query->field("ARTICLE_ID"));
$clid = getDBCell("cluster_variations", "CLID", "CLNID = " . $query->field("ARTICLE_ID") . " AND VARIATION_ID = " . variation());
$live = isClusterLive($clid);
if ($varexists) {
if ($live) {
array_push($tmp, drawImage("green.gif", $lang->get("article_is_live", "Article is live")));
} else {
array_push($tmp, drawImage("red.gif", $lang->get("article_is_expired", "Article is expired")));
}
} else {
array_push($tmp, drawImage("gray.gif", $lang->get("article_variation_missing", "Variation of this article does not exist yet")));
}
array_push($tmp, $query->field("POSITION"));
array_push($tmp, '<b>' . $query->field("TITLE") . '</b>');
array_push($tmp, $this->categories[$query->field("CH_CAT_ID")]);
array_push($tmp, formatDBTimestamp($cvdata->field("LAST_CHANGED")));
$buttons = " " . crLink(drawImage('up.gif'), $c["docroot"] . "modules/channels/overview.php?sid={$sid}&action=up&article=" . $query->field("ARTICLE_ID"), "navelement");
$buttons .= " " . crLink(drawImage('down.gif'), $c["docroot"] . "modules/channels/overview.php?sid={$sid}&action=down&article=" . $query->field("ARTICLE_ID"), "navelement");
$buttons .= " ";
if ($auth->checkAccessToFunction("CHANNEL_DELETE")) {
$buttons .= " " . crLink($lang->get("delete"), "javascript:confirmAction('" . $lang->get("del_article") . "', '" . $c["docroot"] . "modules/channels/overview.php?sid={$sid}&action=deletearticle&article=" . $query->field("ARTICLE_ID") . "');", "navelement");
}
if ($auth->checkAccessToFunction("CHANNEL_LAUNCH")) {
$buttons .= " " . crLink($lang->get("launch", "Launch"), $c["docroot"] . "modules/channels/overview.php?sid={$sid}&action=launcharticle&article=" . $query->field("ARTICLE_ID"), "navelement");
$buttons .= " " . crLink($lang->get("expire", "Expire"), $c["docroot"] . "modules/channels/overview.php?sid={$sid}&action=expirearticle&article=" . $query->field("ARTICLE_ID"), "navelement");
}
array_push($tmp, $buttons);
array_push($result, $tmp);
}
return $result;
}
