function render_related_docs($dbc, $file_id)
{
echo "<p class='lead'><strong>相关文献</strong></p>";
//$query = "SELECT * FROM resource where title like '%$keywords%' or description like '%$keywords%' ORDER BY title ASC LIMIT 0,10";
$recommended = array();
$metadata_query = "SELECT * FROM metadata where value = '" . $file_id . "'";
$metadata_result = mysqli_query($dbc, $metadata_query) or die('Error querying database:' . $metadata_query);
while ($row = mysqli_fetch_array($metadata_result)) {
$id = $row[subject];
$property = $row[property];
$value = $row[value];
if (array_key_exists($id, $recommended)) {
$recommended[$id][] = array($property, $value);
} else {
$recommended[$id] = array(array($property, $value));
}
}
foreach ($recommended as $id => $pv) {
$query = "SELECT * FROM resource where id = {$id}";
$result = mysqli_query($dbc, $query) or die('Error querying database:' . $query);
if ($inner_row = mysqli_fetch_array($result)) {
$title = $inner_row[title];
$def = $inner_row[description];
echo "<a href=\"resource_viewer.php?db_name={$db_name}&id={$id}\">{$title}</a><br>";
echo tcmks_substr($def) . '<br>';
echo '<font color="green">';
foreach ($pv as $pair) {
echo '<strong>' . $pair[0] . ": " . $pair[1] . '</strong> ';
}
echo '</font>';
echo "<br><br>";
}
}
$query = build_query($file_id, array_keys($recommended)) . " LIMIT 0, 10";
$result = mysqli_query($dbc, $query) or die('Error querying database.');
while ($row = mysqli_fetch_array($result)) {
$title = $row[title];
$doc_id = $row[id];
$def = $row[description];
echo "<a href=\"resource_viewer.php?db_name={$db_name}&id={$doc_id}\">{$title}</a><br>";
echo tcmks_substr($def) . "<br>";
echo "<br>";
}
}
function render_value($dbc, $db_name, $name, $with_def = false)
{
if (strpos($name, $db_name . ':o') === 0) {
$id = str_replace($db_name . ':o', "", $name);
$query = "select * from def where id ='{$id}'";
$result = mysqli_query($dbc, $query) or die('Error querying database:' . $query);
if ($row = mysqli_fetch_array($result)) {
$pre_label = $row[name];
$def = $row[def];
$result = get_entity_link($id, get_type($dbc, $name) . ': ' . $pre_label, $db_name);
if ($with_def && $def != '') {
$result .= ' <em><small>(' . tcmks_substr($def) . ')' . '</small></em>';
}
} else {
$result = $name;
}
} else {
$result = $name;
}
return $result;
}
function render_graph($dbc, $name, $edit)
{
$query = "select * from graph where subject ='{$name}'";
if (!$edit) {
$query .= " limit 10";
}
$result = mysqli_query($dbc, $query) or die('Error querying database2.');
while ($row = mysqli_fetch_array($result)) {
$property = $row[property];
$value = $row[value];
if (!$edit) {
$value = tcmks_substr($value);
}
$id = $row[id];
echo "<p><strong>{$property}</strong>: {$value}";
if ($edit) {
echo '<a href="' . $_SERVER['PHP_SELF'] . '?name=' . $name . '&delete_triple_id=' . $id . '"><i class="icon-remove-circle"></i></a>';
}
echo "</p>";
}
}
}
echo '</div>';
echo '</div>';
}
// Calculate pagination information
//$query = "SELECT * FROM resource where title like '%$keywords%' or description like '%$keywords%' ORDER BY title ASC LIMIT 0,10";
$query = build_query($keywords, array_keys($recommended)) . " LIMIT {$skip}, {$results_per_page}";
$result = mysqli_query($dbc, $query) or die('Error querying database.');
while ($row = mysqli_fetch_array($result)) {
$id = $row[id];
//if (!array_key_exists($id, $recommended)) {
$title = $row[title];
$def = $row[description];
echo "<a class = 'lead' href=\"resource_viewer.php?db_name={$db_name}&id={$id}\">{$title}</a><br>";
echo '<font color="green">' . $row[creator] . ' ' . $row[source] . '</font><br>';
echo tcmks_substr($def);
echo "<br><br>";
//}
}
if ($num_pages > 1) {
generate_page_links($db_name, $keywords, $cur_page, $num_pages);
}
?>
<div class="tab-pane" id="tab5">
<?php
$url = 'http://s.wanfangdata.com.cn/sru/paper.ashx?operation=searchRetrieve&query=' . $keywords . '%20sortby%20relevance&maximumRecords=10&startRecord=1&version=1.2';
$xml = simplexml_load_file($url);
$feed = file_get_contents($url);
$feed = str_replace('srw_dc:dc xmlns:dc="info:srw/schema/1/dc-v1.1" xmlns:srw_dc="info:srw/schema/1/dc-v1.1"', 'srw', $feed);
$feed = str_replace('srw_dc:dc', 'srw', $feed);
$feed = str_replace('dc:', '', $feed);
$xml = new SimpleXmlElement($feed);
foreach ($xml->records->record as $r) {
$x = $r->recordData->srw;
$title = $x->title;
$Identifier = $x->Identifier;
echo '<h4><a href="http://d.wanfangdata.com.cn/' . $Identifier . '.aspx">' . $title . '</a></h4>';
echo '<p>' . $x->Creator . '等发表于' . $x->Date . '</p>';
echo "<p>" . tcmks_substr($x->Description, $word_count = 100) . "...</p>";
}
?>
</div>
<div class="tab-pane" id="tab6">
<?php
$query = "SELECT * FROM `tcmks`.`images` WHERE name like '%{$keywords}%' or subject like '%{$keywords}%' or description like '%{$keywords}%'";
//echo $query;
$result = mysqli_query($dbc, $query) or die('Error querying database.');
$row = mysqli_fetch_array($result);
while ($row) {
echo '<ul class = "thumbnails">';
for ($i = 0; $i < 4; $i++) {
if (!$row) {
break;
}
function render_article_summary($dbc, $article_id, $word_count = 0)
{
$article_info = get_article_info($dbc, $article_id);
echo "<h4><a href = \"article.php?id={$article_id}\">" . $article_info[title] . "</a></h4>";
echo "{$article_info['creators']}创建于{$article_info['create_time']}";
$abstract = get_abstract($dbc, $article_id);
if ($word_count != 0) {
$abstract = tcmks_substr($abstract);
}
echo '<p>' . $abstract . '</p>';
}
<button name ="submit" type="submit" class="btn btn-primary"> <i class="icon-search icon-white"></i> </button>
</form>
</div>
<div class="accordion" id="accordion2">
<?php
if (isset($keywords)) {
$query = "SELECT * FROM segment where title like '%{$keywords}%' or content like '%{$keywords}%' ";
$result = mysqli_query($dbc, $query) or die('Error querying database.');
while ($row = mysqli_fetch_array($result)) {
//$article_id = $row[article_id];
//$article_info = get_article_info($dbc, $article_id);
$segment_title = $row[title];
$segment_id = $row[id];
$segment_abstract = tcmks_substr($row[content]);
$segment_content = $row[content];
echo "<div class = \"accordion-group\">";
echo "<div class = \"accordion-heading\">";
echo "<a class = \"accordion-toggle\" data-toggle = \"collapse\" data-parent = \"#accordion2\" href = \"#{$segment_id}\">";
echo $segment_title;
echo "</a>";
echo $segment_abstract;
echo "</div>";
echo "<div id = \"{$segment_id}\" class = \"accordion-body collapse\">";
echo "<div class = \"accordion-inner\">";
echo $segment_content;
if ($_SESSION[id] == $row[user_id] && !is_segment_in_article($dbc, $article_id, $segment_id)) {
echo "<a class = \"btn btn-success\" href=\"article.php?id={$article_id}&insert={$segment_id}&prev={$prev}\"><i class=\"icon-plus icon-white\"></i>将本段插入综述</a>";
}
echo ' ';
$row_num = 1;
$color = true;
while ($row = mysqli_fetch_array($result)) {
if ($color) {
echo '<tr>';
} else {
echo '<tr class="info">';
}
$color = !$color;
$segment_id = $row['id'];
echo '<td>' . $row_num++ . '</td>';
echo '<td>';
echo "<a href=\"editor.php?act=edit&id={$segment_id}\">" . $row[title] . "</a>";
echo '</td>';
echo '<td>' . render_articles_by_seg($dbc, $row['id']) . '</td>';
echo '<td>' . tcmks_substr($row['content']) . '</td>';
echo '<td>' . render_tags($dbc, $row['id']) . '</td>';
echo '<td>' . $row[create_time] . '</td>';
echo '<td>';
if (!is_segment_used($dbc, $row['id'])) {
echo '<a href="' . $_SERVER['PHP_SELF'] . '?delete_segment=' . $row['id'] . '"><i class="icon-trash"></i></a>';
}
echo '</td>';
}
?>
</tbody>
</table>
<?php
} else {
render_warning('没有可显示的综述段落！您可以创建新的综述段落。');
