$req->execute(array('id' => $id));
$data = $req->fetch();
?>
<section class="item">
<a class='align_right' href='delete_item.php?id=<?php
echo $data['id'];
?>
' onClick="return confirm('Delete this item ?');"><img src='themes/<?php
echo $_SESSION['prefs']['theme'];
?>
/img/trash.png' title='delete' alt='delete' /></a>
<h3 style='color:#<?php
echo get_item_info_from_id($data['type'], 'bgcolor');
?>
'><?php
echo get_item_info_from_id($data['type'], 'name');
?>
</h3>
<?php
echo "<span class='date'><img src='themes/" . $_SESSION['prefs']['theme'] . "/img/calendar.png' title='date' alt='Date :' />" . $data['date'] . "</span><br />";
show_stars($data['rating']);
// buttons
echo "<a href='database.php?mode=edit&id=" . $data['id'] . "'><img src='themes/" . $_SESSION['prefs']['theme'] . "/img/edit.png' title='edit' alt='edit' /></a> \n<a href='duplicate_item.php?id=" . $data['id'] . "&type=db'><img src='themes/" . $_SESSION['prefs']['theme'] . "/img/duplicate.png' title='duplicate item' alt='duplicate' /></a> \n<a href='make_pdf.php?id=" . $data['id'] . "&type=items'><img src='themes/" . $_SESSION['prefs']['theme'] . "/img/pdf.png' title='make a pdf' alt='pdf' /></a> \n<a href='javascript:window.print()'><img src='themes/" . $_SESSION['prefs']['theme'] . "/img/print.png' title='Print this page' alt='Print' /></a> \n<a href='make_zip.php?id=" . $data['id'] . "&type=items'><img src='themes/" . $_SESSION['prefs']['theme'] . "/img/zip.gif' title='make a zip archive' alt='zip' /></a>\n<a href='experiments.php?mode=show&related=" . $data['id'] . "'><img src='img/related.png' alt='Linked experiments' title='Linked experiments' /></a>";
// TAGS
echo show_tags($id, 'items_tags');
// TITLE : click on it to go to edit mode
?>
<div OnClick="document.location='database.php?mode=edit&id=<?php
echo $data['id'];
?>
'" class='title'>
$link_id[] = $link_data['link_id'];
}
$linknb = $link_req->rowCount();
if ($linknb > 0) {
$html .= "\n <section>\n <h3>Linked items :</h3>\n <ul>";
// create url for database
$url = str_replace('make_zip.php', 'database.php', $url);
// put links in list with link to the url of item
for ($j = 0; $j < $linknb; $j++) {
// get title and type of the item linked
$sql = "SELECT * FROM items WHERE id = :id";
$req = $bdd->prepare($sql);
$req->execute(array('id' => $link_id[$j]));
$item_infos = $req->fetch();
$link_title = $item_infos['title'];
$link_type = get_item_info_from_id($item_infos['type'], 'name');
$html .= "<li>[" . $link_type . "] - <a href='" . $url . "?mode=view&id=" . $link_id[$j] . "'>" . $link_title . "</a></li>";
}
$html .= "\n </ul>\n </section>";
}
}
// FOOTER
$html .= "~~~~<br />\n <footer>\n File created with <strong>elabFTW</strong> -- Free open source lab manager<br />\n <a href='http://www.elabftw.net'>eLabFTW.net</a>\n </footer>";
$html .= "</section></body></html>";
// CREATE TXT FILE
// utf8 ftw
$html = utf8_encode($html);
// add header for utf-8
$html = "" . $html;
$txtfile = 'uploads/export/' . 'elabftw-' . uniqid();
$tf = fopen($txtfile, 'w+');
return false;
})
} // end if key is enter
}
// LINKS AUTOCOMPLETE
$(function() {
var availableLinks = [
<?php
// get all links for autocomplete
$sql = "SELECT title, id, type FROM items";
$getalllinks = $bdd->prepare($sql);
$getalllinks->execute();
while ($link = $getalllinks->fetch()) {
// html_entity_decode is needed to convert the quotes
// str_replace to remove ' because it messes everything up
$name = get_item_info_from_id($link['type'], 'name');
echo "'" . $link['id'] . " - " . $name . " - " . str_replace("'", "", html_entity_decode(substr($link[0], 0, 60), ENT_QUOTES)) . "',";
}
?>
];
$( "#linkinput" ).autocomplete({
source: availableLinks
});
});
// DELETE LINK
function delete_link(id, item_id) {
var you_sure = confirm('Delete this link ?');
if (you_sure == true) {
var jqxhr = $.post('delete_link.php', {
id: id,
item_id : item_id
function showDB($id, $display)
{
// Show unique DB item
global $bdd;
// SQL to get everything from selected id
$sql = "SELECT * FROM items WHERE id = :id";
$req = $bdd->prepare($sql);
$req->execute(array('id' => $id));
$final_query = $req->fetch();
if ($display === 'compact') {
// COMPACT MODE //
?>
<section class='item'>
<h4 style='color:#<?php
echo get_item_info_from_id($final_query['type'], 'bgcolor');
?>
'><?php
echo get_item_info_from_id($final_query['type'], 'name');
?>
</h4>
<span class='date date_compact'><?php
echo $final_query['date'];
?>
</span>
<span><?php
echo stripslashes($final_query['title']);
// view link
echo "<a href='database.php?mode=view&id=" . $final_query['id'] . "'>\n <img class='align_right' style='margin-left:5px;' src='img/view_compact.png' alt='view' title='view item' /></a>";
// STAR RATING read only
show_stars($final_query['rating']);
echo "</section>";
} else {
// NOT COMPACT
echo "<section class='item'>";
echo "<h4 style='color:#" . get_item_info_from_id($final_query['type'], 'bgcolor') . "'>" . get_item_info_from_id($final_query['type'], 'name') . " </h4>";
// TAGS
echo show_tags($id, 'items_tags');
// view link
echo "<a href='database.php?mode=view&id=" . $final_query['id'] . "'>\n <img class='align_right' style='margin-left:5px;' src='img/view.png' alt='view' title='view item' /></a>";
// STARS
show_stars($final_query['rating']);
// show attached if there is a file attached
if (has_attachement($final_query['id'])) {
echo "<img class='align_right' src='themes/" . $_SESSION['prefs']['theme'] . "/img/attached_file.png' alt='file attached' />";
}
echo "<p class='title'>" . stripslashes($final_query['title']) . "</p>";
echo "</section>";
}
}
