';
echo 'alert(\''.__('Author succesfully removed!').'\');';
echo 'location.href = \'iframe_author.php\';';
echo '';
}
if (isset($_POST['remove'])) {
$id = (integer)$_POST['remove'];
$bid = (integer)$_POST['bid'];
$sql_op = new simbio_dbop($dbs);
$sql_op->delete('biblio_author', 'author_id='.$id.' AND biblio_id='.$bid);
echo '';
}
// if biblio ID is set
if ($biblioID) {
$table = new simbio_table();
$table->table_attr = 'align="center" style="width: 100%;" cellpadding="2" cellspacing="0"';
// database list
$biblio_author_q = $dbs->query("SELECT ba.*, a.author_name, a.author_year, a.authority_type FROM biblio_author AS ba
LEFT JOIN mst_author AS a ON ba.author_id=a.author_id
WHERE ba.biblio_id=$biblioID ORDER BY level ASC");
$row = 1;
while ($biblio_author_d = $biblio_author_q->fetch_assoc()) {
// alternate the row color
$row_class = ($row%2 == 0)?'alterCell':'alterCell2';
// remove link
$remove_link = 'Delete';
$author = $biblio_author_d['author_name'];
$author_year = $biblio_author_d['author_year'];
$authority_type = $sysconf['authority_type'][$biblio_author_d['authority_type']];
$table->appendTableRow(array($remove_link, $author, $author_year, $authority_type, $sysconf['authority_level'][$biblio_author_d['level']]));
$table->setCellAttr($row, 0, 'class="'.$row_class.'" style="font-weight: bold; width: 10%;"');
$table->setCellAttr($row, 1, 'class="'.$row_class.'" style="width: 30%;"');
$table->setCellAttr($row, 2, 'class="'.$row_class.'" style="width: 20%;"');
$table->setCellAttr($row, 3, 'class="'.$row_class.'" style="width: 20%;"');
$table->setCellAttr($row, 4, 'class="'.$row_class.'" style="width: 20%;"');
$row++;
}
echo $table->printTable();
// hidden form
echo '';
} else {
if ($_SESSION['biblioAuthor']) {
$table = new simbio_table();
$table->table_attr = 'align="center" style="width: 100%;" cellpadding="2" cellspacing="0"';
$row = 1;
$row_class = 'alterCell2';
foreach ($_SESSION['biblioAuthor'] as $biblio_session) {
// remove link
$remove_link = 'Remove';
if ($biblio_session) {
$author_q = $dbs->query("SELECT author_name, author_year, authority_type FROM mst_author
WHERE author_id=".$biblio_session[0]);
$author_d = $author_q->fetch_row();
$author = $author_d[0];
$author_year = $author_d[1];
$authority_type = $author_d[2];
}
$table->appendTableRow(array($remove_link, $author, $author_year, $authority_type, $sysconf['authority_level'][$biblio_session[1]]));
$table->setCellAttr($row, 0, 'class="'.$row_class.'" style="font-weight: bold; background-color: #fff; width: 10%;"');
$table->setCellAttr($row, 1, 'class="'.$row_class.'" style="background-color: #fff; width: 30%;"');
$table->setCellAttr($row, 2, 'class="'.$row_class.'" style="background-color: #fff; width: 20%;"');
$table->setCellAttr($row, 3, 'class="'.$row_class.'" style="background-color: #fff; width: 20%;"');
$table->setCellAttr($row, 4, 'class="'.$row_class.'" style="background-color: #fff; width: 20%;"');
$row++;
}
echo $table->printTable();
}
}
/* main content end */
$content = ob_get_clean();
// include the page template
require SB.'/admin/'.$sysconf['admin_template']['dir'].'/notemplate_page_tpl.php';