/**
* Get HTML output (exactly the same as for the 'table' result format) and
* prepare mail merge data. Perhaps storing the latter in the DB should be
* done elsewhere.
*
* @uses SMWTableResultPrinter::getResultText()
* @return string
*/
protected function getResultText(\SMWQueryResult $queryResult, $outputmode)
{
global $wgTitle;
$this->pageTitle = "{$wgTitle}";
$this->emailsTable = new SemanticMailMerge_ORM();
$this->emailsTable->delete(array('title' => $this->pageTitle));
$results = clone $queryResult;
while ($row = $results->getNext()) {
$this->handleRow($row);
}
return parent::getResultText($queryResult, $outputmode);
}
/**
* Exectues ask-interface as done in SMW<=0.7, using a simple textbox interface and supporting only
* certain parameters.
*/
protected function executeSimpleAsk()
{
global $wgRequest, $wgOut, $smwgQEnabled, $smwgQMaxLimit, $wgUser, $smwgQSortingSupport, $smwgIP;
$skin = $wgUser->getSkin();
$query = $wgRequest->getVal('query');
$sort = $wgRequest->getVal('sort');
$order = $wgRequest->getVal('order');
$limit = $wgRequest->getVal('limit');
if ('' == $limit) {
$limit = 20;
}
$offset = $wgRequest->getVal('offset');
if ('' == $offset) {
$offset = 0;
}
// display query form
$spectitle = Title::makeTitle(NS_SPECIAL, 'Ask');
$docutitle = Title::newFromText(wfMsg('smw_ask_doculink'), NS_HELP);
$html = '<form name="ask" action="' . $spectitle->escapeLocalURL() . '" method="get">' . "\n" . '<input type="hidden" name="title" value="' . $spectitle->getPrefixedText() . '"/>';
$html .= '<textarea name="query" cols="40" rows="6">' . htmlspecialchars($query) . '</textarea><br />' . "\n";
if ($smwgQSortingSupport) {
$html .= wfMsg('smw_ask_sortby') . ' <input type="text" name="sort" value="' . htmlspecialchars($sort) . '"/> <select name="order"><option ';
if ($order == 'ASC') {
$html .= 'selected="selected" ';
}
$html .= 'value="ASC">' . wfMsg('smw_ask_ascorder') . '</option><option ';
if ($order == 'DESC') {
$html .= 'selected="selected" ';
}
$html .= 'value="DESC">' . wfMsg('smw_ask_descorder') . '</option></select> <br />';
}
$html .= '<br /><input type="submit" value="' . wfMsg('smw_ask_submit') . '"/> <a href="' . $docutitle->getFullURL() . '">' . wfMsg('smw_ask_help') . "</a>\n</form>";
// print results if any
if ($smwgQEnabled && '' != $query) {
include_once "{$smwgIP}/includes/SMW_QueryProcessor.php";
$params = array('offset' => $offset, 'limit' => $limit, 'format' => 'broadtable', 'mainlabel' => ' ', 'link' => 'all', 'default' => wfMsg('smw_result_noresults'), 'sort' => $sort, 'order' => $order);
$queryobj = SMWQueryProcessor::createQuery($query, $params, false);
$res = smwfGetStore()->getQueryResult($queryobj);
$printer = new SMWTableResultPrinter('broadtable', false);
$result = $printer->getResultHTML($res, $params);
// prepare navigation bar
if ($offset > 0) {
$navigation = '<a href="' . htmlspecialchars($skin->makeSpecialUrl('Ask', 'offset=' . max(0, $offset - $limit) . '&limit=' . $limit . '&query=' . urlencode($query) . '&sort=' . urlencode($sort) . '&order=' . urlencode($order))) . '">' . wfMsg('smw_result_prev') . '</a>';
} else {
$navigation = wfMsg('smw_result_prev');
}
$navigation .= ' <b>' . wfMsg('smw_result_results') . ' ' . ($offset + 1) . '– ' . ($offset + $res->getCount()) . '</b> ';
if ($res->hasFurtherResults()) {
$navigation .= ' <a href="' . htmlspecialchars($skin->makeSpecialUrl('Ask', 'offset=' . ($offset + $limit) . '&limit=' . $limit . '&query=' . urlencode($query) . '&sort=' . urlencode($sort) . '&order=' . urlencode($order))) . '">' . wfMsg('smw_result_next') . '</a>';
} else {
$navigation .= wfMsg('smw_result_next');
}
$max = false;
$first = true;
foreach (array(20, 50, 100, 250, 500) as $l) {
if ($max) {
continue;
}
if ($first) {
$navigation .= ' (';
$first = false;
} else {
$navigation .= ' | ';
}
if ($l > $smwgQMaxLimit) {
$l = $smwgQMaxLimit;
$max = true;
}
if ($limit != $l) {
$navigation .= '<a href="' . htmlspecialchars($skin->makeSpecialUrl('Ask', 'offset=' . $offset . '&limit=' . $l . '&query=' . urlencode($query) . '&sort=' . urlencode($sort) . '&order=' . urlencode($order))) . '">' . $l . '</a>';
} else {
$navigation .= '<b>' . $l . '</b>';
}
}
$navigation .= ')';
$html .= '<br /><div style="text-align: center;">' . $navigation;
$html .= '<br />' . $result;
$html .= '<br />' . $navigation . '</div>';
} elseif (!$smwgQEnabled) {
$html .= '<br />' . wfMsgForContent('smw_iq_disabled');
}
$wgOut->addHTML($html);
}
function execute()
{
global $wgRequest, $wgOut, $wgUser, $smwgQMaxInlineLimit, $smwgIP;
$skin = $wgUser->getSkin();
$limit = $wgRequest->getVal('limit');
if ('' == $limit) {
$limit = 20;
}
$offset = $wgRequest->getVal('offset');
if ('' == $offset) {
$offset = 0;
}
$html = '';
$attributestring = 'Status';
$action = $this->action;
$userPageTitle = $this->article->getTitle();
$user_nick = $userPageTitle->getDBkey();
$user = User::newFromName($user_nick);
$groups = $user->getGroups();
include_once "{$smwgIP}/includes/SMW_QueryProcessor.php";
$query = '[[Status::' . $action . ']]';
if (in_array('reporter', $groups)) {
$query .= ' [[Reported By::' . $user->getRealName() . ']]';
}
if (in_array('reader', $groups)) {
$query .= ' [[Read By::' . $user->getRealName() . ']]';
}
if (in_array('editor', $groups)) {
$query .= ' [[Edited By::' . $user->getRealName() . ']]';
}
$params = array('offset' => $offset, 'limit' => $limit, 'format' => 'broadtable', 'mainlabel' => ' ', 'link' => 'all', 'default' => wfMsg('smw_result_noresults'), 'sort' => $sort, 'order' => $order);
$queryobj = SMWQueryProcessor::createQuery($query, $params, false);
$res = smwfGetStore()->getQueryResult($queryobj);
$printer = new SMWTableResultPrinter('broadtable', false);
$result = $printer->getResultHTML($res, $params);
// prepare navigation bar
if ($offset > 0) {
$navigation = '<a href="' . htmlspecialchars($skin->makeUrl("{$userPageTitle}", 'action=' . $action . '&offset=' . max(0, $offset - $limit) . '&limit=' . $limit . '&sort=' . urlencode($sort) . '&order=' . urlencode($order))) . '">' . wfMsg('smw_result_prev') . '</a>';
} else {
$navigation = wfMsg('smw_result_prev');
}
$navigation .= ' <b>' . wfMsg('smw_result_results') . ' ' . ($offset + 1) . '– ' . ($offset + $res->getCount()) . '</b> ';
if ($res->hasFurtherResults()) {
$navigation .= ' <a href="' . htmlspecialchars($skin->makeUrl("{$userPageTitle}", 'action=' . $action . '&offset=' . ($offset + $limit) . '&limit=' . $limit . '&sort=' . urlencode($sort) . '&order=' . urlencode($order))) . '">' . wfMsg('smw_result_next') . '</a>';
} else {
$navigation .= wfMsg('smw_result_next');
}
$max = false;
$first = true;
foreach (array(20, 50, 100, 250, 500) as $l) {
if ($max) {
continue;
}
if ($first) {
$navigation .= ' (';
$first = false;
} else {
$navigation .= ' | ';
}
if ($l > $smwgQMaxLimit) {
$l = $smwgQMaxLimit;
$max = true;
}
if ($limit != $l) {
$navigation .= '<a href="' . htmlspecialchars($skin->makeSpecialUrl('Ask', 'offset=' . $offset . '&limit=' . $l . '&query=' . urlencode($query) . '&sort=' . urlencode($sort) . '&order=' . urlencode($order))) . '">' . $l . '</a>';
} else {
$navigation .= '<b>' . $l . '</b>';
}
}
$navigation .= ')';
$html .= '<br /><div style="text-align: center;">' . $navigation;
$html .= '<br />' . $result;
$html .= '<br />' . $navigation . '</div>';
$wgOut->addHTML($html);
}