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

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


<div style="text-align: justify;"></div>
<div style="text-align: justify;">
<table border="0" cellspacing="1" cellpadding="1" style="border-collapse: collapse; width: 280px; height: 90px; margin-left: auto; margin-right: auto;">
<tbody>
<tr style="height: 18px;">
<td style="height: 10px; width: 278px; text-align: center;" colspan="2">
<h3 style="text-align: center;">?? Catalog Report</h3>
</td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 10px; text-align: center;"><strong>1</strong></td>
<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=1&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;">Accession Register</span></a></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 10px; text-align: center;"><strong>2</strong></td>
<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=12&amp;phase=Run%20this%20report"><span style="color: green;">Total Number of Books</span></a><br /></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 10px; text-align: center;"><strong>3</strong></td>
<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=33&amp;phase=Run%20this%20report"><span style="color: green;">Department Wise Number of Books</span></a><br /></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 10px; text-align: center;"><strong>4</strong></td>
<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=34&amp;phase=Run%20this%20report"><span style="color: green;">Collection Wise Number of Books</span></a><br /></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 10px; text-align: center;"><strong>5</strong></td>
<td style="height: 18px; width: 265px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=15&amp;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>
<div style="text-align: justify;"><br />
<table border="0" cellspacing="1" cellpadding="1" style="border-collapse: collapse; width: 279px; height: 110px; margin-left: auto; margin-right: auto;">
<tbody>
<tr style="height: 18px;">
<td style="height: 18px; width: 275px; text-align: center;" colspan="2">
<h3>?? Circulation Report</h3>
</td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 9.03125px; text-align: center;"><strong>1</strong></td>
<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&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;">Check Out List of Books (Date wise)</span></a></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 9.03125px; text-align: center;"><strong>2</strong></td>
<td style="height: 18px; width: 262.969px;">
<strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=7&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;">Check in List of Books (Date&nbsp;
</span></a></strong>
<strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=7&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;"> wise)</span></a></strong>
<strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=7&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;"></span></a></strong>
<strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=7&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;"><br /></span></a></strong></td>
</tr>
<tr>
<td style="width: 9.03125px; text-align: center;"><strong>3</strong></td>
<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&amp;phase=Run%20this%20report" rel="noopener">Item Type Wise (Check Out Books)</a></strong><br /></span></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 9.03125px; text-align: center;"><strong>4</strong></td>
<td style="height: 18px; width: 262.969px;"><span style="color: #e67e23;">
<strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=9&amp;phase=Run%20this%20report" rel="noopener" style="color: #e67e23;">Overdues Book List</a></strong></span><strong><br /></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 9.03125px; text-align: center;"><strong>5</strong></td>
<td style="height: 18px; width: 262.969px;"><strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=24&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;">Circulation Daily Transaction</span></a></strong><strong><br /></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 9.03125px; text-align: center;"><strong>6</strong></td>
<td style="height: 18px; width: 262.969px;"><strong style="text-align: center;"><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=20&amp;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>
<div style="text-align: justify;"><br />
<table border="0" cellspacing="1" cellpadding="1" style="border-collapse: collapse; width: 280px; height: 25px; margin-left: auto; margin-right: auto;">
<tbody>
<tr style="height: 18px;">
<td style="height: 18px; width: 276px; text-align: center;" colspan="2">
<h3 style="text-align: center;">?? Accounts Report</h3>
</td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 13.7969px; text-align: center;"><strong>1</strong></td>
<td style="width: 259.203px; height: 18px;"><strong><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=5&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;">Paid Fine for Students</span></a></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 13.7969px; text-align: center;"><strong>2</strong></td>
<td style="width: 259.203px; height: 18px;"><strong><a title="Writeoff Fine" href="/cgi-bin/koha/reports/guided_reports.pl?reports=14&amp;phase=Run%20this%20report" rel="noopener"><span style="color: red;">Writeoff Fine for Students</span></a></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 13.7969px; text-align: center;"><strong>3</strong></td>
<td style="width: 259.203px; height: 18px;"><strong><a title="A/C Type of Fine" href="/cgi-bin/koha/reports/guided_reports.pl?reports=16&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;">A/C Type of Fine<br /></span></a></strong></td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 13.7969px; text-align: center;"><strong>4</strong></td>
<td style="width: 259.203px; height: 18px;"><strong><a title="Fine Details" href="/cgi-bin/koha/reports/guided_reports.pl?reports=17&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;">Fine Details<br /></span></a></strong></td>
</tr>
</tbody>
</table>
</div>
<div style="text-align: justify;"><br />
<table border="0" cellspacing="1" cellpadding="1" style="border-collapse: collapse; width: 280px; height: 25px; margin-left: auto; margin-right: auto;">
<tbody>
<tr style="height: 18px;">
<td style="height: 18px; width: 276px; text-align: center;" colspan="2">
<h3 style="text-align: center;">??&zwj;??<strong> Library Membership Report</strong></h3>
</td>
</tr>
<tr style="height: 18px;">
<td style="height: 18px; width: 13.7969px; text-align: center;"><strong>1</strong></td>
<td style="width: 259.203px; height: 18px;"><strong> <a title="Membership Staff " href="/cgi-bin/koha/reports/guided_reports.pl?reports=11&amp;phase=Run%20this%20report" rel="noopener"><span style="color: green;">Membership Staff &amp; Students</span></a></strong></td>
</tr>
</tbody>
</table>
</div>
<div style="text-align: justify;"></div>

Go to: Home Page (Successfully Your report displaying)




Comments

Post a Comment

Popular posts from this blog

Install Dspace 7.2 on Ubuntu 22.04 LTS

-
Image
  Install Dspace 7.2 on Ubuntu 22.04 LTS Install Dspace 7.2 on Ubuntu 22.04 LTS Prerequisite software : i) Java JDK ii) Apache Maven iii) Apache Ant iv) Apache Tomcat v) PostgreSQL vi) Solr vii) Dspace 7.2 – backend viii) Dspace-angular 7.2 – frontend ix) Node.js x) Node Version Manager (NVM) xi) Yarn xii) gedit (text editor software) Note: It is highly recommended to install Dspace7 on fresh installed Linux-based operating system. It may not be compatible with the Virtual box platform. (Note the red mark lines are the commands that need to be executed on the terminal) Open the terminal by pressing (Ctrl+Alt+T) or go to Applications > Accessories > Terminal and select it for executing the below command. First update and upgrade your package system sudo apt update && sudo apt upgrade -y Install gedit for text editing sudo apt-get install gedit Create a Dspace user with password sudo useradd -m dspace sudo passwd d...
Read more

How to delete library data in koha using the command line

-
 How to delete library data in koha using the command line Sometimes you need to empty the all data (e.g. bibliographic, borrowers, and transaction details)  from your Koha LMS without losing the configuration settings and authorized values, e.g. libraries, item types, patron categories, locations, etc. Let us know how to delete data from the Koha instance/library. Delete Koha's bibliographic data NB: I would recommend taking a backup of the database before applying the following commands. Login as a root user sudo su Log into MySQL database mysql -uroot -p Enter MySQL root password use koha_library; Disable foreign key constraints when you truncate the tables SET FOREIGN_KEY_CHECKS=0; Delete all bibliographic details TRUNCATE items;  TRUNCATE biblioitems;  TRUNCATE biblio;  TRUNCATE deletedbiblioitems; TRUNCATE deletedbiblio;  TRUNCATE biblio_metadata; Delete all transactions  TRUNCATE old_issues;  TRUNCATE issues;  Delete borrowers details ...
Read more

Koha INSTALLATION

-
Image
   Koha INSTALLATION After installation of ubuntu 20.4 (Focal Fossa), right click on the mouse choose open terminal. past the following comments in terminal. Update Ubuntu using apt   sudo apt update sudo apt upgrade -y if the system asks for update make it "Remind me later" it may confuse the process Clear the apt-get packager manager cache sudo apt clean Install MariaDB-server dependence sudo apt install -y mariadb-server Provide MySQL/MariaDB root password (If the password asks during the installation process, enter the password in the window. Apply the following command, if the password window did not appear during the installation secure it) Securing MariaDB Run this command to improve the security of the MariaDB installation:   sudo mysql_secure_installation   (The script will prompt you to set up the root user password, remove the anonymous user, restrict root user access to the local machine and remove the test d...
Read more

Total views