Koha HOME Page Reports

Koha HOME Page Reports

Displaying auto updated unique title and volume count on the Koha staff client or OPAC

First Create the SQL Public Report

Go to: Reports/ Create from SQL and (Copy and paste the following SQL query )

SELECT homebranch, count(DISTINCT biblionumber) AS bibs,
count(itemnumber) AS items
FROM items
GROUP BY homebranch
ORDER BY homebranch ASC

Go to: Koha administration/System preferences/Staff interface/IntranetUserJS
Copy and paste the following JQuery

Replace your IP address and report ID

http://Your koha IP Address/cgi-bin/koha/svc/report?id=36&annotated=1
//**No.of.Book.Dis in home page**//
$("label[for='sql_params_Reselectthesubjecttag']").hide()
$('#sql_params_Reselectthesubjecttag').hide();
$("#sql_params_Selectthesubject").change(function() {
var subval = $('#sql_params_Selectthesubject').val();
$("#sql_params_Reselectthesubjecttag").val(subval);
});
$(document).ready(function() {
if ( $('#main_intranet-main').length ) {
$.getJSON("http://Your koha IP Address/cgi-bin/koha/svc/report?id=36&annotated=1",

function(data) {
var branches = data[0].homebranch;
var bibs = data[0].bibs;
var items = data[0].items;
$('div.newsitem').prepend('<div class="newsitem" id="mystats"><table class="table table-striped" style="width: 100%; background: none;"><thead><th colspan="3" style="text-align: center; font-weight: bold; padding: 8px; line-height: 1.42857143; vertical-align: middle; text-transform: uppercase;">Library Statistics</thead><tbody><tr><td><strong>Branch</strong></td><td><strong>Unique Titles</strong></td><td><strong>Total Vols</strong></td></tr><tr><td class="text-center">'+branches+'</td><td class="text-center">'+bibs+'</td><td class="text-center">'+items+'</td></tr></tbody></table></div>');
});
}
});

Go to: Home Page (Successfully Your library unique title and volume displaying)

How to set Instant Reports Options in the Koha Main Page (libpowertech.blogspot.com)

How to set Instant Reports Options in the Koha Main Page

Go to: Koha Home/Tools/News

Go to: Koha Home/Tools/NewsClick the New Entry and Select Display location in Librarian interface.

Copy and paste the following HTML Code

<tbody>

<h3 style="text-align: center;">?? Catalog Report</h3>

</td>

</tr>

<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=1&phase=Run%20this%20report" rel="noopener"><span style="color: green;">Accession Register</span></a></strong></td>

</tr>

<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=12&phase=Run%20this%20report"><span style="color: green;">Total Number of Books</span></a><br /></strong></td>

</tr>

<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=33&phase=Run%20this%20report"><span style="color: green;">Department Wise Number of Books</span></a><br /></strong></td>

</tr>

<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=34&phase=Run%20this%20report"><span style="color: green;">Collection Wise Number of Books</span></a><br /></strong></td>

</tr>

<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=15&phase=Run%20this%20report" rel="noopener"><span style="color: green;">Item Type Wise Number of Books</span></a><br /></strong></td>

</tr>

</tbody>

</table>

</div>

<tbody>

<h3>?? Circulation Report</h3>

</td>

</tr>

<td style="height: 18px; width: 262.969px;"><strong style="text-align: center;"><a title="Check Out List of Books (Date wise)" href="/cgi-bin/koha/reports/guided_reports.pl?reports=13&phase=Run%20this%20report" rel="noopener"><span style="color: green;">Check Out List of Books (Date wise)</span></a></strong></td>

</tr>

<strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=7&phase=Run%20this%20report" rel="noopener"><span style="color: green;">Check in List of Books (Date 

</span></a></strong>

</tr>

<tr>

<td style="width: 262.969px;"><strong style="text-align: center;"><span style="color: green;"><strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=30&phase=Run%20this%20report" rel="noopener">Item Type Wise (Check Out Books)</a></strong><br /></span></strong></td>

</tr>

<strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=9&phase=Run%20this%20report" rel="noopener" style="color: #e67e23;">Overdues Book List</a></strong></span><strong><br /></strong></td>

</tr>

<td style="height: 18px; width: 262.969px;"><strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=24&phase=Run%20this%20report" rel="noopener"><span style="color: green;">Circulation Daily Transaction</span></a></strong><strong><br /></strong></td>

</tr>

<td style="height: 18px; width: 262.969px;"><strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=20&phase=Run%20this%20report" rel="noopener"><span style="color: green;">Month Wise Circulation Report</span></a></strong><strong><br /></strong></td>

</tr>

</tbody>

</table>

</div>

<tbody>

<h3 style="text-align: center;">?? Accounts Report</h3>

</td>

</tr>

<td style="width: 259.203px; height: 18px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=5&phase=Run%20this%20report" rel="noopener"><span style="color: green;">Paid Fine for Students</span></a></strong></td>

</tr>

<td style="width: 259.203px; height: 18px;"><strong><a title="Writeoff Fine" href="/cgi-bin/koha/reports/guided_reports.pl?reports=14&phase=Run%20this%20report" rel="noopener"><span style="color: red;">Writeoff Fine for Students</span></a></strong></td>

</tr>

</tr>

<td style="width: 259.203px; height: 18px;"><strong><a title="Fine Details" href="/cgi-bin/koha/reports/guided_reports.pl?reports=17&phase=Run%20this%20report" rel="noopener"><span style="color: green;">Fine Details<br /></span></a></strong></td>

</tr>

</tbody>

</table>

</div>

<tbody>

<h3 style="text-align: center;">??&zwj;??<strong> Library Membership Report</strong></h3>

</td>

</tr>

<td style="width: 259.203px; height: 18px;"><strong> <a title="Membership Staff " href="/cgi-bin/koha/reports/guided_reports.pl?reports=11&phase=Run%20this%20report" rel="noopener"><span style="color: green;">Membership Staff & Students</span></a></strong></td>

</tr>

</tbody>

</table>

</div>

Go to: Home Page (Successfully Your report displaying)

Search This Blog

LIB Science Info

Koha HOME Page Reports

Comments

Post a Comment

Popular posts from this blog

Install Dspace 7.2 on Ubuntu 22.04 LTS

How to delete library data in koha using the command line

Koha INSTALLATION

Total views