PHP SMWQueryResult类代码示例

 protected function getResultText(SMWQueryResult $res, $outputmode)
 {
     global $wgSitename;
     $result = '';
     if ($outputmode == SMW_OUTPUT_FILE) {
         // make file
         if ($this->m_title == '') {
             $this->m_title = $wgSitename;
         }
         $items = array();
         while ($row = $res->getNext()) {
             $items[] = $this->getItemForResultRow($row)->text();
         }
         $result = implode('', $items);
     } else {
         // just make link to export
         if ($this->getSearchLabel($outputmode)) {
             $label = $this->getSearchLabel($outputmode);
         } else {
             $label = wfMessage('srf_bibtex_link')->inContentLanguage()->text();
         }
         $link = $res->getQueryLink($label);
         $link->setParameter('bibtex', 'format');
         if ($this->getSearchLabel(SMW_OUTPUT_WIKI) != '') {
             $link->setParameter($this->getSearchLabel(SMW_OUTPUT_WIKI), 'searchlabel');
         }
         $result .= $link->getText($outputmode, $this->mLinker);
         $this->isHTML = $outputmode == SMW_OUTPUT_HTML;
         // yes, our code can be viewed as HTML if requested, no more parsing needed
     }
     return $result;
 }

 protected function getResultText(SMWQueryResult $res, $outputmode)
 {
     $this->isHTML = true;
     $t = "";
     $n = "";
     // if there is only one column in the results then stop right away
     if ($res->getColumnCount() == 1) {
         return "";
     }
     // print all result rows
     $first = true;
     $max = 0;
     // the biggest value. needed for scaling
     while ($row = $res->getNext()) {
         $name = $row[0]->getNextDataValue()->getShortWikiText();
         foreach ($row as $field) {
             while (($object = $field->getNextDataValue()) !== false) {
                 // use numeric sortkey
                 if ($object->isNumeric()) {
                     $nr = $object->getDataItem()->getSortKey();
                     $max = max($max, $nr);
                     if ($first) {
                         $first = false;
                         $t .= $nr;
                         $n = $name;
                     } else {
                         $t = $nr . ',' . $t;
                         $n = $name . '|' . $n;
                     }
                 }
             }
         }
     }
     return '<img src="http://chart.apis.google.com/chart?cht=p3&chs=' . $this->m_width . 'x' . $this->m_height . '&chds=0,' . $max . '&chd=t:' . $t . '&chl=' . $n . '" width="' . $this->m_width . '" height="' . $this->m_height . '"  />';
 }

	protected function addQueryResult( SMWQueryResult $queryResult ) {
		$serialized = $queryResult->serializeToArray();
		$result = $this->getResult();

		$result->setIndexedTagName( $serialized['results'], 'result' );
		$result->setIndexedTagName( $serialized['printrequests'], 'printrequest' );
		
		foreach ( $serialized['results'] as $subjectName => $subject ) {
			if ( is_array( $subject ) && array_key_exists( 'printouts', $subject ) ) {
				foreach ( $subject['printouts'] as $property => $values ) {
					if ( is_array( $values ) ) {
						$result->setIndexedTagName( $serialized['results'][$subjectName]['printouts'][$property], 'value' );
					}
				}
			}
		}
		
		$result->addValue( null, 'query', $serialized );
		
		if ( $queryResult->hasFurtherResults() ) {
			// TODO: obtain continuation data from store
			$result->disableSizeCheck();
			$result->addValue( null, 'query-continue', 0 );
			$result->enableSizeCheck();
		}
	}

 /**
  * Return relevant data set
  *
  * @param SMWQueryResult $res
  * @param $outputMode
  *
  * @return array
  */
 protected function getResultData(SMWQueryResult $res, $outputMode)
 {
     // Init
     $properties = array();
     $excludeProperties = explode($this->params['sep'], $this->params['exclude']);
     // Options used when retrieving data from the store
     $reqOptions = new SMWRequestOptions();
     $reqOptions->sort = true;
     $reqOptions->limit = $this->params['limit'];
     foreach ($res->getResults() as $key => $page) {
         // Find properties assigned to selected subject page
         foreach ($res->getStore()->getInProperties($page, $reqOptions) as $property) {
             $propertyLabel = $property->getLabel();
             // Exclude property from result set
             if (in_array($propertyLabel, $excludeProperties)) {
                 continue;
             }
             // NOTE There could be thousands of incoming links for one property,
             // counting the length of an array is inefficient but we don't want
             // to implement any native db select outside of smw core and rather
             // would like to see a counting method available but to counter
             // any potential inefficiencies we curb the selection by using
             // SMWRequestOptions -> limit as boundary
             $count = count($res->getStore()->getPropertySubjects($property, $page, $reqOptions));
             // Limit ouput by threshold
             if ($this->params['min'] <= $count) {
                 $properties[$propertyLabel] = $count;
             }
         }
     }
     return $properties;
 }

 /**
  * Returns an array with the numerical data
  *
  * @since 1.8
  *
  * @param SMWQueryResult $result
  * @param $outputMode
  *
  * @return array
  */
 protected function getResultData(SMWQueryResult $res, $outputMode)
 {
     $data = array();
     $data['series'] = array();
     while ($row = $res->getNext()) {
         // Loop over their fields (properties)
         $label = '';
         $i = 0;
         foreach ($row as $field) {
             $i++;
             $rowNumbers = array();
             // Grouping by subject (page object) or property
             if ($this->params['group'] === 'subject') {
                 $groupedBy = $field->getResultSubject()->getTitle()->getText();
             } else {
                 $groupedBy = $field->getPrintRequest()->getLabel();
             }
             // Property label
             $property = $field->getPrintRequest()->getLabel();
             // First column property typeid
             $i == 1 ? $data['fcolumntypeid'] = $field->getPrintRequest()->getTypeID() : '';
             // Loop over all values for the property.
             while (($object = $field->getNextDataValue()) !== false) {
                 if ($object->getDataItem()->getDIType() == SMWDataItem::TYPE_NUMBER) {
                     $number = $object->getNumber();
                     // Checking against the row and in case the first column is a numeric
                     // value it is handled as label with the remaining steps continue to work
                     // as it were a text label
                     // The first column container will not be part of the series container
                     if ($i == 1) {
                         $label = $number;
                         continue;
                     }
                     if ($label !== '' && $number >= $this->params['min']) {
                         // Reference array summarize all items per row
                         $rowNumbers += array('subject' => $label, 'value' => $number, 'property' => $property);
                         // Store plain numbers for simpler handling
                         $data['series'][$groupedBy][] = $number;
                     }
                 } elseif ($object->getDataItem()->getDIType() == SMWDataItem::TYPE_TIME) {
                     $label = $object->getShortWikiText();
                 } else {
                     $label = $object->getWikiValue();
                 }
             }
             // Only for array's with numbers
             if (count($rowNumbers) > 0) {
                 // For cases where mainlabel=- we assume that the subject should not be
                 // used as identifier and therefore we try to match the groupby
                 // with the first available text label
                 if ($this->params['mainlabel'] == '-' && $this->params['group'] === 'subject') {
                     $data[$this->params['group']][$label][] = $rowNumbers;
                 } else {
                     $data[$this->params['group']][$groupedBy][] = $rowNumbers;
                 }
             }
         }
     }
     return $data;
 }

 protected function addQueryResult(SMWQueryResult $queryResult)
 {
     $serialized = $queryResult->serializeToArray();
     $result = $this->getResult();
     $result->setIndexedTagName($serialized['results'], 'result');
     $result->setIndexedTagName($serialized['printrequests'], 'printrequest');
     foreach ($serialized['results'] as $subjectName => $subject) {
         if (is_array($subject) && array_key_exists('printouts', $subject)) {
             foreach ($subject['printouts'] as $property => $values) {
                 if (is_array($values)) {
                     $result->setIndexedTagName($serialized['results'][$subjectName]['printouts'][$property], 'value');
                 }
             }
         }
     }
     $output = array();
     header("Content-type: Application/JSON");
     foreach ($serialized['results'] as $r) {
         $common = count($r['printouts']['Has common name']) > 0 ? $r['printouts']['Has common name'][0]['fulltext'] : '';
         $taxo = count($r['printouts']['Is taxonomy type']) > 0 ? $r['printouts']['Is taxonomy type'][0]['fulltext'] : '';
         $output[$r['fulltext']] = array('taxonomy' => $taxo, 'common' => $common);
     }
     echo json_encode($output);
     exit;
 }

 /**
  * Return serialised results in specified format.
  * Implemented by subclasses.
  */
 protected function getResultText(SMWQueryResult $res, $outputmode)
 {
     $html = '';
     $id = uniqid();
     // build an array of article IDs contained in the result set
     $objects = array();
     foreach ($res->getResults() as $key => $object) {
         $objects[] = array($object->getTitle()->getArticleId());
         $html .= $key . ': ' . $object->getSerialization() . "<br>\n";
     }
     // build an array of data about the printrequests
     $printrequests = array();
     foreach ($res->getPrintRequests() as $key => $printrequest) {
         $data = $printrequest->getData();
         if ($data instanceof SMWPropertyValue) {
             $name = $data->getDataItem()->getKey();
         } else {
             $name = null;
         }
         $printrequests[] = array($printrequest->getMode(), $printrequest->getLabel(), $name, $printrequest->getOutputFormat(), $printrequest->getParameters());
     }
     // write out results and query params into JS arrays
     // Define the srf_filtered_values array
     SMWOutputs::requireScript('srf_slideshow', Html::inlineScript('srf_slideshow = {};'));
     SMWOutputs::requireScript('srf_slideshow' . $id, Html::inlineScript('srf_slideshow["' . $id . '"] = ' . json_encode(array($objects, $this->params['template'], $this->params['delay'] * 1000, $this->params['height'], $this->params['width'], $this->params['nav controls'], $this->params['effect'], json_encode($printrequests))) . ';'));
     SMWOutputs::requireResource('ext.srf.slideshow');
     if ($this->params['nav controls']) {
         SMWOutputs::requireResource('jquery.ui.slider');
     }
     return Html::element('div', array('id' => $id, 'class' => 'srf-slideshow ' . $id . ' ' . $this->params['class']));
 }

 protected function getResultText(SMWQueryResult $res, $outputmode)
 {
     if ($outputmode == SMW_OUTPUT_FILE) {
         // make RDF file
         $serializer = $this->syntax == 'turtle' ? new SMWTurtleSerializer() : new SMWRDFXMLSerializer();
         $serializer->startSerialization();
         $serializer->serializeExpData(SMWExporter::getOntologyExpData(''));
         while ($row = $res->getNext()) {
             $subjectDi = reset($row)->getResultSubject();
             $data = SMWExporter::makeExportDataForSubject($subjectDi);
             foreach ($row as $resultarray) {
                 $printreq = $resultarray->getPrintRequest();
                 $property = null;
                 switch ($printreq->getMode()) {
                     case SMWPrintRequest::PRINT_PROP:
                         $property = $printreq->getData()->getDataItem();
                         break;
                     case SMWPrintRequest::PRINT_CATS:
                         $property = new SMWDIProperty('_TYPE');
                         break;
                     case SMWPrintRequest::PRINT_CCAT:
                         // not serialised right now
                         break;
                     case SMWPrintRequest::PRINT_THIS:
                         // ignored here (object is always included in export)
                         break;
                 }
                 if (!is_null($property)) {
                     SMWExporter::addPropertyValues($property, $resultarray->getContent(), $data, $subjectDi);
                 }
             }
             $serializer->serializeExpData($data);
         }
         $serializer->finishSerialization();
         return $serializer->flushContent();
     } else {
         // just make link to feed
         if ($this->getSearchLabel($outputmode)) {
             $label = $this->getSearchLabel($outputmode);
         } else {
             $label = wfMsgForContent('smw_rdf_link');
         }
         $link = $res->getQueryLink($label);
         $link->setParameter('rdf', 'format');
         $link->setParameter($this->syntax, 'syntax');
         if (array_key_exists('limit', $this->params)) {
             $link->setParameter($this->params['limit'], 'limit');
         } else {
             // use a reasonable default limit
             $link->setParameter(100, 'limit');
         }
         $this->isHTML = $outputmode == SMW_OUTPUT_HTML;
         // yes, our code can be viewed as HTML if requested, no more parsing needed
         return $link->getText($outputmode, $this->mLinker);
     }
 }

 /**
  * Gets a list of all numbers.
  * 
  * @since 1.6
  * 
  * @param SMWQueryResult $res
  * 
  * @return array
  */
 protected function getNumbers(SMWQueryResult $res)
 {
     $numbers = array();
     while ($row = $res->getNext()) {
         foreach ($row as $resultArray) {
             foreach ($resultArray->getContent() as $dataItem) {
                 self::addNumbersForDataItem($dataItem, $numbers);
             }
         }
     }
     return $numbers;
 }

 protected function getResultText(SMWQueryResult $res, $outputmode)
 {
     $result = '';
     if ($outputmode == SMW_OUTPUT_FILE) {
         // make CSV file
         $csv = fopen('php://temp', 'r+');
         if ($this->mShowHeaders) {
             $header_items = array();
             foreach ($res->getPrintRequests() as $pr) {
                 $header_items[] = $pr->getLabel();
             }
             fputcsv($csv, $header_items, $this->m_sep);
         }
         while ($row = $res->getNext()) {
             $row_items = array();
             foreach ($row as $field) {
                 $growing = array();
                 while (($object = $field->getNextDataValue()) !== false) {
                     $growing[] = Sanitizer::decodeCharReferences($object->getWikiValue());
                 }
                 $row_items[] = implode(',', $growing);
             }
             fputcsv($csv, $row_items, $this->m_sep);
         }
         rewind($csv);
         $result .= stream_get_contents($csv);
     } else {
         // just make link to feed
         if ($this->getSearchLabel($outputmode)) {
             $label = $this->getSearchLabel($outputmode);
         } else {
             $label = wfMsgForContent('smw_csv_link');
         }
         $link = $res->getQueryLink($label);
         $link->setParameter('csv', 'format');
         $link->setParameter($this->m_sep, 'sep');
         if (array_key_exists('mainlabel', $this->params) && $this->params['mainlabel'] !== false) {
             $link->setParameter($this->params['mainlabel'], 'mainlabel');
         }
         $link->setParameter($this->mShowHeaders ? 'show' : 'hide', 'headers');
         if (array_key_exists('limit', $this->params)) {
             $link->setParameter($this->params['limit'], 'limit');
         } else {
             // use a reasonable default limit
             $link->setParameter(100, 'limit');
         }
         $result .= $link->getText($outputmode, $this->mLinker);
         $this->isHTML = $outputmode == SMW_OUTPUT_HTML;
         // yes, our code can be viewed as HTML if requested, no more parsing needed
     }
     return $result;
 }

 protected function getResultText(SMWQueryResult $res, $outputmode)
 {
     $result = '';
     $columnClasses = array();
     if ($this->mShowHeaders != SMW_HEADERS_HIDE) {
         // building headers
         $headers = array();
         foreach ($res->getPrintRequests() as $pr) {
             $attribs = array();
             $columnClass = str_replace(array(' ', '_'), '-', $pr->getText(SMW_OUTPUT_WIKI));
             $attribs['class'] = $columnClass;
             // Also add this to the array of classes, for
             // use in displaying each row.
             $columnClasses[] = $columnClass;
             $text = $pr->getText($outputmode, $this->mShowHeaders == SMW_HEADERS_PLAIN ? null : $this->mLinker);
             $headers[] = Html::rawElement('th', $attribs, $text === '' ? ' ' : $text);
         }
         $headers = '<tr>' . implode("\n", $headers) . '</tr>';
         if ($outputmode == SMW_OUTPUT_HTML) {
             $headers = '<thead>' . $headers . '</thead>';
         }
         $headers = "\n{$headers}\n";
         $result .= $headers;
     }
     $tableRows = array();
     $rowNum = 1;
     while ($subject = $res->getNext()) {
         $tableRows[] = $this->getRowForSubject($subject, $outputmode, $columnClasses, $rowNum++);
     }
     $tableRows = implode("\n", $tableRows);
     if ($outputmode == SMW_OUTPUT_HTML) {
         $tableRows = '<tbody>' . $tableRows . '</tbody>';
     }
     $result .= $tableRows;
     // print further results footer
     if ($this->linkFurtherResults($res)) {
         $link = $res->getQueryLink();
         if ($this->getSearchLabel($outputmode)) {
             $link->setCaption($this->getSearchLabel($outputmode));
         }
         $result .= "\t<tr class=\"smwfooter\"><td class=\"sortbottom\" colspan=\"" . $res->getColumnCount() . '"> ' . $link->getText($outputmode, $this->mLinker) . "</td></tr>\n";
     }
     // Put the <table> tag around the whole thing
     $tableAttrs = array('class' => $this->mHTMLClass);
     if ($this->mFormat == 'broadtable') {
         $tableAttrs['width'] = '100%';
     }
     $result = Xml::tags('table', $tableAttrs, $result);
     $this->isHTML = $outputmode == SMW_OUTPUT_HTML;
     // yes, our code can be viewed as HTML if requested, no more parsing needed
     return $result;
 }

 /**
  * Returns an array with sortkeys for dates pointing to their source DataItems.
  *
  * @param SMWQueryResult $res
  *
  * @return array
  */
 protected function getSortKeys(SMWQueryResult $res)
 {
     $seconds = array();
     while ($row = $res->getNext()) {
         foreach ($row as $resultArray) {
             foreach ($resultArray->getContent() as $dataItem) {
                 if ($dataItem->getDIType() === SMWDataItem::TYPE_TIME) {
                     $seconds[$dataItem->getSortKey()] = $dataItem;
                 }
             }
         }
     }
     return $seconds;
 }

 /**
  * Returns an array with numerical data
  *
  * @since 1.8
  *
  * @param SMWQueryResult $result
  * @param $outputMode
  *
  * @return array
  */
 protected function getAggregatedTimeSeries(SMWQueryResult $result, $outputMode)
 {
     $values = array();
     $aggregatedValues = array();
     while ($row = $result->getNext()) {
         // Objects (pages)
         $timeStamp = '';
         $value = '';
         $series = array();
         foreach ($row as $field) {
             $value = array();
             $sum = array();
             $rowSum = array();
             // Group by subject (page object)  or property
             if ($this->params['group'] == 'subject') {
                 $group = $field->getResultSubject()->getTitle()->getText();
             } else {
                 $group = $field->getPrintRequest()->getLabel();
             }
             while (($dataValue = $field->getNextDataValue()) !== false) {
                 // Data values
                 // Find the timestamp
                 if ($dataValue->getDataItem()->getDIType() == SMWDataItem::TYPE_TIME) {
                     // We work with a timestamp, we have to use intval because DataItem
                     // returns a string but we want a numeric representation of the timestamp
                     $timeStamp = intval($dataValue->getDataItem()->getMwTimestamp());
                 }
                 // Find the values (numbers only)
                 if ($dataValue->getDataItem()->getDIType() == SMWDataItem::TYPE_NUMBER) {
                     $sum[] = $dataValue->getNumber();
                 }
             }
             // Aggegate individual values into a sum
             $rowSum = array_sum($sum);
             // Check the sum and threshold/min
             if ($timeStamp !== '' && $rowSum == true && $rowSum >= $this->params['min']) {
                 $series[$group] = array($timeStamp, $rowSum);
             }
         }
         $values[] = $series;
     }
     // Re-assign values according to their group
     foreach ($values as $key => $value) {
         foreach ($values[$key] as $row => $rowvalue) {
             $aggregatedValues[$row][] = $rowvalue;
         }
     }
     return $aggregatedValues;
 }

 /**
  * Returns an array with the tags (keys) and the number of times they occur (values).
  *
  * @since 1.5.3
  *
  * @param SMWQueryResult $results
  * @param $outputmode
  *
  * @return array
  */
 protected function getTags(SMWQueryResult $results, $outputmode)
 {
     $tags = array();
     $excludetags = explode(';', $this->params['excludetags']);
     while ($row = $results->getNext()) {
         // Objects (pages)
         for ($i = 0, $n = count($row); $i < $n; $i++) {
             // SMWResultArray for a sinlge property
             /**
              * @var SMWDataValue $dataValue
              */
             while (($dataValue = $row[$i]->getNextDataValue()) !== false) {
                 // Data values
                 $isSubject = $row[$i]->getPrintRequest()->getMode() == SMWPrintRequest::PRINT_THIS;
                 // If the main object should not be included, skip it.
                 if ($i == 0 && !$this->params['includesubject'] && $isSubject) {
                     continue;
                 }
                 // Get the HTML for the tag content. Pages are linked, other stuff is just plaintext.
                 if ($dataValue->getTypeID() == '_wpg') {
                     $value = $dataValue->getTitle()->getText();
                     $html = $dataValue->getLongText($outputmode, $this->getLinker($isSubject));
                 } else {
                     $html = $dataValue->getShortText($outputmode, $this->getLinker(false));
                     $value = $html;
                 }
                 // Exclude tags from result set
                 if (in_array($value, $excludetags)) {
                     continue;
                 }
                 // Replace content with template inclusion
                 $html = $this->params['template'] !== '' ? $this->addTemplateOutput($value, $rownum) : $html;
                 if (!array_key_exists($value, $tags)) {
                     $tags[$value] = 0;
                     $this->tagsHtml[$value] = $html;
                     // Store the HTML separetely, so sorting can be done easily.
                 }
                 $tags[$value]++;
             }
         }
     }
     foreach ($tags as $name => $count) {
         if ($count < $this->params['mincount']) {
             unset($tags[$name]);
         }
     }
     return $tags;
 }

	protected function getResultText( SMWQueryResult $res, $outputmode ) {
		$this->isHTML = true;

		$t = "";
		$n = "";

		// if there is only one column in the results then stop right away
		if ($res->getColumnCount() == 1) return "";

		// print all result rows
		$first = true;
		$count = 0; // How many bars will they be? Needed to calculate the height of the image
		$max = 0; // the biggest value. needed for scaling
		
		while ( $row = $res->getNext() ) {
			$name = $row[0]->getNextDataValue()->getShortWikiText();
			foreach ( $row as $field ) {
				while ( ( $object = $field->getNextDataValue() ) !== false ) {
					
					// use numeric sortkey
					if ( $object->isNumeric() ) {
						$nr = $object->getDataItem()->getSortKey();

						$count++;
						$max = max( $max, $nr );

						if ( $first ) {
							$first = false;
							$t .= $nr;
							$n = $name;
						} else {
							$t = $nr . ',' . $t;
							$n .= '|' . $name; // yes, this is correct, it needs to be the other way
						}
					}
				}
			}
		}
		
		$barwidth = 20; // width of each bar
		$bardistance = 4; // distance between two bars
		$height = $count * ( $barwidth + $bardistance ) + 15; // calculates the height of the image
		
		return 	'<img src="http://chart.apis.google.com/chart?cht=bhs&chbh=' . $barwidth . ',' . $bardistance . '&chs=' . $this->m_width . 'x' . $height . '&chds=0,' . $max . '&chd=t:' . $t . '&chxt=y&chxl=0:|' . $n . '" width="' . $this->m_width . '" height="' . $height . '" />';

	}