<?php
/*
// OPDS basic gestion (only add entities and relations, not modify)
// Version: 0.1
// Pierre FAUQUE, <pierre@fauque.net>
// Script: 2014, Script->Class: 2019, Gestion: may 2020
// Encoding: UTF-8
// Text editor: GNU/Linux Debian Vi
// File: tool_vieweb.php (v0.1)
// Role: Tools, to view all about a published ebook
*/
require("init.php");
require("lib_lddocs.php");
$idbook = $_GET["id"];
$idtype = $_GET["tf"];
$request = "SELECT * FROM ".TB_DOCS." WHERE iddoc=$idbook;";
$result = $cnx->query($request);
$r = $result->fetch();
function newline($tring) { return str_replace("\n","<br/>",$tring); }
?><!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>View ebooks details</title>
<link rel="stylesheet" href="opds.css" type="text/css" />
<style type="text/css">
img { margin-top:2em; margin-left:5em; }
pre {font-family:arial; font-size:1em; }
</style>
</head>
<body>
<table border="0" width="100%">
<tr>
<td class="cmen">
<?php menu(); ?></td>
<td class="cont">
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
<h1><?php echo "Details of : $r->title"; ?></h1>
<?php
// Keywords
$request = "SELECT keyword FROM ".TB_KW.",".TB_CLAS." WHERE ".TB_KW.".idkw=".TB_CLAS.".idkw AND iddoc=$idbook;";
$result = $cnx->query($request);
$r = $result->fetch();
$kws = $r->keyword; while($r = $result->fetch()) { $kws .= ", $r->keyword"; }
// Document, author
$request = "SELECT"
. " title,descd,issued,".TB_DOCS.".active as dact,"
. " cat,".TB_CAT.".active as cact,"
. " scat,".TB_SCAT.".active as scact,"
. " lname,fname,bdate,ddate,uri,bio "
. "FROM ".TB_DOCS.",".TB_CAT.",".TB_SCAT.",".TB_AUT.",".TB_WRIT." "
. "WHERE ".TB_DOCS.".idscat=".TB_SCAT.".idscat "
. "AND ".TB_SCAT.".idcat=".TB_CAT.".idcat "
. "AND ".TB_WRIT.".iddoc=".TB_DOCS.".iddoc "
. "AND ".TB_WRIT.".idaut=".TB_AUT.".idaut "
. "AND ".TB_DOCS.".iddoc=$idbook;";
$result = $cnx->query($request);
$r = $result->fetch(); // Author,
// Publication
$request = "SELECT filename,lang,thumb,descpe,updpe,type,format "
. "FROM ".TB_PUB.",".TB_TYP." "
. "WHERE ".TB_PUB.".idtype=".TB_TYP.".idtype "
. "AND iddoc=$idbook "
. "AND ".TB_PUB.".idtype=$idtype;";
$result = $cnx->query($request);
$p = $result->fetch();
?>
<table>
<tr><td colspan="2" class="col2">Document</td></tr>
<tr>
<td class="label">Title</td>
<td class="bkinfo"><?php echo $r->title; ?></td>
</tr><tr>
<td class="label">Description</td>
<td class="bkinfo" style="width:600px;"><?php echo newline($r->descd); ?></td>
</tr><tr>
<td class="label">Issued</td>
<td class="bkinfo"><?php if($r->issued == "0000-00-00") { echo "Unknown"; } else { echo $r->issued; } ?></td>
</tr><tr>
<td class="label">Status</td>
<td class="bkinfo"><?php if($r->dact) { echo "Visible"; } else { echo "Hidden"; } ?></td>
</tr><tr>
<td class="label">Category</td>
<td class="bkinfo"><?php echo $r->cat; if($r->cact) { echo " (Visible)"; } else { echo " (Hidden)"; } ?></td>
</tr><tr>
<td class="label">Subcategory</td>
<td class="bkinfo"><?php echo $r->scat; if($r->scact) { echo " (Visible)"; } else { echo " (Hidden)"; } ?></td>
</tr>
<tr><td colspan="2" class="col2">Author</td></tr>
<tr>
<td class="label">Name</td>
<td class="bkinfo"><?php echo trim("$r->fname $r->lname"); ?></td>
</tr><tr>
<td class="label">Date of birth</td>
<td class="bkinfo"><?php if($r->bdate == "0000-00-00") { echo "Unknown"; } else { echo $r->bdate; } ?></td>
</tr><tr>
<td class="label">Date of death</td>
<td class="bkinfo"><?php if($r->ddate == "0000-00-00") { echo "Unknown"; } else { echo $r->ddate; } ?></td>
</tr><tr>
<td class="label">Biography</td>
<td class="bkinfo"><?php echo newline($r->bio); ?></td>
</tr><tr>
<td class="label">URL page</td>
<td class="bkinfo"><a href="<?php echo $r->uri; ?>" target="_blank"><?php echo urldecode($r->uri); ?></a></td>
</tr>
<tr><td colspan="2" class="col2">Publication</td></tr>
<tr>
<td class="label">Language</td>
<td class="bkinfo"><?php echo $p->lang; ?></td>
</tr><tr>
<td class="label">Type of ebook</td>
<td class="bkinfo"><?php echo "$p->type / $p->format"; ?></td>
</tr><tr>
<td class="label">Ebook's filename</td>
<td class="bkinfo"><?php echo $p->filename; ?></td>
</tr><tr>
<td class="label">Ebook's thumbnail</td>
<td class="bkinfo"><?php echo $p->thumb; ?></td>
</tr><tr>
<td class="label">Publication description</td>
<td class="bkinfo"><?php echo newline($p->descpe); ?></td>
</tr><tr>
<td class="label">Published on</td>
<td class="bkinfo"><?php echo $p->updpe; ?></td>
</tr>
<tr><td colspan="2" class="col2">Keywords</td></tr>
<tr>
<td class="label">Keywords</td>
<td class="bkinfo"><?php echo $kws; ?></td>
</tr>
<tr><td colspan="2" class="col2">Thumbnail</td></tr>
<tr>
<td class="label">Thumbnail</td>
<td class="bkinfo"><img src="<?php echo "$rootsite$rootopds/$imgdir/$p->thumb"; ?>" width="200"></td>
</tr>
</table>
<p> </p>
<p> </p>
<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->
</td>
</tr>
</table>
<p> </p>
<p> </p>
</body>
</html>
|