<?php
$page_security = 'SA_ITEM';
$path_to_root = "..";
include_once $path_to_root . "/includes/session.inc";
add_access_extensions();
page(_($help_context = "Author List"));
include_once $path_to_root . "/includes/ui.inc";
include_once $path_to_root . "/inventory/author/includes/author_ui.inc";
include_once $path_to_root . "/inventory/author/includes/author_db.inc";
simple_page_mode(true);
//----------------------------------------------------------------------------------------------------
start_form();
start_table(TABLESTYLE, "width=30%");
$th = array(_('Author'), '');
table_header($th);
$result = fetchRoyaltyReport();
while ($myrow = db_fetch($result)) {
start_row();
label_cell($myrow[1]);
viewprinterRoyalty($myrow[0]);
end_row();
}
end_table();
end_form();
end_page();
$id = $_GET['id'];
}
$total = 0;
start_form();
start_table(TABLESTYLE, "width=50%");
$result = fetchRoyaltyReport($id);
$name = "";
while ($author = db_fetch($result)) {
$name = $author[1];
}
echo "<b>" . $name . "</b>";
br();
br();
$th = array(_('Book Title'), _('Percentage'), _('Total Sales'), _(''));
table_header($th);
$result = fetchRoyaltyReport($id);
while ($myrow = db_fetch($result)) {
start_row();
label_cell($myrow[2]);
label_cell($myrow[3]);
label_cell($myrow[5]);
echo "<td>";
submenu_print(_("&Print This"), ST_ROYALTY, $myrow[6], null, 1);
echo "</td>";
$total += $myrow[5];
end_row();
}
end_table();
br();
end_form();
end_page();
