Koha Manual

Koha Logo Change

Koha ›Administration › System Preferences ›Staff Client /StaffLoginInstructions

<p><b><center><img src="http://your college logo.png" height="25" width="30"><font color="Red" size="3"> Your college Name</font>

<p><b><center> <font color="GREEN" size="3"><center> <marquee>Library Management Software</marquee></center></font></center></b></p>

Koha staff login image Create your logo and put the koha home folder (Image size: 250x75 pix)

sudo su

sudo mv /home/koha/koha-logo.gif/ usr/share/koha/intranet/htdocs/intranet-tmpc/prog/img

Koha staff login image size change css file

Sudo su

sudo mv /home/koha/login_22.0506000.css /usr/share/koha/intranet-tmpl/prog/css/login_22.0506000.css

Koha staff interface images location

sudo su

sudo mv /home/koha/koha-logo-medium.png /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/img/koha-logo-medium.png

Koha staff interface image size change css file

sudo su

sudo mv /home/koha/staff-global.css /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/css/staff-global.css

Search logo then change the size or background

( margin: 0;

overflow: hidden;

padding: 44px 0 0;

text-decoration: none;

width: 180px; )

OPAC Header Image in Intranet

sudo cp /home/koha/header.png /usr/share/koha/opac/htdocs

Find it : http://localhost/header.png or http://Your IP/header.png

Sort Fields Customization: intranetuserjs

//Change text of sort1 and sort2

$("#memberentry_library_management label[for='sort1']").text("County:");

$("fieldset.rows label[for='sort1']").text("County:");});

Item check-out

Goto: Tools › Notices and Slips › Check out slip

Email Section Past it these codes

<!DOCTYPE html>

<head>

<style>

body{

}

h1,h2,h3,h4,h5,h6{

margin: 0;

padding: 0;

}

margin: 0;

padding: 0;

}

.container{

width: 90%;

margin-right: auto;

margin-left: auto;

}

.brand-section{

background-color: #0047AB;

padding: 10px 20px;

}

.logo{

width: 50%;

}

.col-6{

width: 50%;

flex: 0 0 auto;

}

.text-white{

color: #fff;

}

.company-details{

float: left;

text-align: left;

}

.body-section{

padding: 16px;

border: 1px solid gray;

}

.heading{

font-size: 20px;

margin-bottom: 08px;

}

</style>

</head>

<body>

<p class="text-white"> <p style="text-align:left">Library Name</p></h1>

</div>

</div>

<h3>Welcome <br>

Name: <<borrowers.firstname>> <<borrowers.surname>><br>

Card No: <<borrowers.cardnumber>><br>

Department of: <<borrowers.borrowernotes>><br>

Barcode / Accession No:<<items.barcode>><br>

Title:<<biblio.title>><br>

Author:<<biblio.author>><br>

Date of Checkout:<<issues.date>> <br>

Due Date: <<issues.date_due>><br>

<br>Thank you for visiting</b><br>

</div>

</div>

</body>

</html>

Item check-in

Goto: Tools › Notices and Slips › Check out slip

Email Section Past it these codes

<!DOCTYPE html>

<head>

<style>

body{

}

h1,h2,h3,h4,h5,h6{

margin: 0;

padding: 0;

}

margin: 0;

padding: 0;

}

.container{

width: 90%;

margin-right: auto;

margin-left: auto;

}

.brand-section{

background-color: #0047AB;

padding: 10px 20px;

}

.logo{

width: 50%;

}

.col-6{

width: 50%;

flex: 0 0 auto;

}

.text-white{

color: #fff;

}

.company-details{

float: left;

text-align: left;

}

.body-section{

padding: 16px;

border: 1px solid gray;

}

.heading{

font-size: 20px;

margin-bottom: 08px;

}

</style>

</head>

<body>

<p class="text-white"> <p style="text-align:left">Library Name</p></h1>

</div>

</div>

<h3>Welcome <br>

Name: <<borrowers.firstname>> <<borrowers.surname>><br>

Card No: <<borrowers.cardnumber>><br>

Department of: <<borrowers.borrowernotes>><br>

Barcode / Accession No:<<items.barcode>><br>

Title:<<biblio.title>><br>

Author:<<biblio.author>><br>

Date of Checkin:<<old_issues.returndate>> <br>

<br> Thank you for visiting</b><br>

</div>

</div>

</body>

</html>

OPAC Modifications

OPAC Interface Color and Set the OPAC Background Image

OPAC Header Image in Intranet

sudo cp /home/koha/header.png /usr/share/koha/opac/htdocs

Find it : http://localhost/header.png or http://Your IP/header.png

Go to : Home › Administration › System preferences › OPAC › OpacUserCSS

OpacUserCSS open a tag for body and set the background to color:

body {

background:#FFF8D6;

}

OPACUserJS

$("select[name='idx']").append("<option value='bc'>Accession No.</option>");

$("#login").hide();

$("#logo").hide();

OPAC Youtube video autoplay

</iframe></center>

OpacUserCSS open a tag for body and set the background to Image:

Final Full coding Style available in the last

body {

background-image: url("http://www.lecturemaker.com/wp-content/uploads/2013/07/HP_paper.gif");

}

body {

background-color: #F4ECF7;

}

Next try changing the standard link colour:

a, a:visited

{

color:#3366ff;

}

To change the link colour on mouse over.

/*change link hover property*/

a:hover {

color:#900C3F;

}

The footer is a good place to put copyright and contact information if you want to display that on the OPAC.

#opaccredits {

background: linear-gradient(180deg, #8b0000 0%, #990000 32%, #900C3F 64%, #8b0000 100%); filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#8b0000', endColorstr='#8b0000', GradientType=1 ); padding: 10px; color:#fff;

}

change the colour of the top header/navbar.

#header-region, .navbar-inverse .navbar-inner { background:#63F1F8; }

You might notice that the dividers keeping the text nicely spaced on the header are still black like the header background was before we changed the colour.

.navbar-inverse .divider-vertical

{

border-right-color: #993300;

}

The text on the header is also now unreadable so we need to change the font colour in order to make in readable.

.cartlabel, .listslabel
{
color: #2db300;
}
#members a
{
color: #8000ff;
}

OPAC User Login / logout link a darker red.

#members a.logout
{
color:#ff3300;
}

Final Full coding Style sheet

body
{
background:#FFF8D6;
}
{
background-image: url("http://www.lecturemaker.com/wp-content/uploads/2013/07/HP_paper.gif"); background-color: #F4ECF7;
}
a, a:visited { color:#3366ff;
}
/*change link hover property*/ a:hover
{
color:#900C3F;
}
#opaccredits
{
background: linear-gradient(180deg, #8b0000 0%, #990000 32%, #900C3F 64%, #8b0000 100%); filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#8b0000', endColorstr='#8b0000', GradientType=1 ); padding: 10px; color:#fff;
}
#header-region, .navbar-inverse .navbar-inner
{
background:#63F1F8;
}
.navbar-inverse .divider-vertical
{
border-right-color: #993300;
}
.cartlabel, .listslabel
{
color: #2db300;
}
#members a
{
color: #8000ff;
}
#members a.logout
{
color:#ff3300;
}

Header OPAC

<center><a href=Koha OPAC Web Address target="_blank"><img

Src=Image address title="Library Name"/></a></center>

<h4><center>Library Name Display as Heading</h4></center>

Display New Arrivals on OPAC

Manual Method | Specifies the URL of the image (src)

<p>Please tab the cover image for biblio record.</p>

</marquee>

Opac Main User Block

<p align="justify"><h4>..:: Welcome to Library Name ::..</br></br></p align="justify"></h5><p align="justify">You are at the Summon Search of Library Name. Summon is a new kind of database or library search engine that includes records of print and electronic books, book contents, journals, theses and dissertations, videos lectures, and more.<br><br> The new system easy the searching and browsing of all resources of Library Name through the simple and advanced search options; the simple search engine is limited to, search by the keyword, title, author, subject, ISBN, series and the call number while the advanced search brings the Boolean operators and also limit the date-range of publications, item types, languages, locations, libraries and the availability.<br><br>Furthermore, all electronic resources can be accessed on-campus only, while registered members are allowed to log in with their ID and password, and after login, they can modify their personal details along with password change; members are also permitted to view the summary of their checked out items, fine paid, reading and search history and can submit on-line recommendations for purchasing of books or journals.<br><br>Kindly contact us at <a href="mailto:Your Email ID">Your Email ID</a> or <a href="mailto: Your Email ID "> Your Email ID </a> for further details.<hr></h7>

OPAC NAV Important Links

<h6>Important Links</h6>
<ul class="unstyled">
<li><a href="http://www.digitallibrary..com">Digital Library</a></li>
<li><a href="https://youtube.com">Youtube</a></li>
<li><a href="https://fb.com/">facebook</a></li>
</ul>

Enable Quote of the Day feature

Koha > Administration > Global System Preferences > OPAC > QuoteOfTheDay > Enable

Add CSS

Koha > Administration > Global System Preferences > OPAC > OPACUserCSS

Add following CSS query.

#daily-quote {
background-color:#FFFFFF;
border:2px solid #000000;
border-radius:15px 15px 15px 15px;
margin:0 0px 0px;
text-align:center;
width:auto;
}
#daily-quote-text{
color: Green;
font-weight: bold;
}
#daily-quote-source {
color: Red;
font-weight: bold;
}

Save it

Upload the quotes file

Koha > Tools > Edit quotes for QOTD feature > Import quotes

Model File: https://drive.google.com/file/d/1u5soG4dYsq0PKcjoumutvDJVz75HFfv_/view

Enhanced Digital Library Virtual Interface OPAC

User JS

// eBook results

$("#userresults").ready(function(){

$("#userresults table td").each(function(i){

td = $(this);

var pgbks_link = td.find("a[href^='https://doaj.org/toc']");

var linkc = pgbks_link.parent();

var pgbks_link = pgbks_link.attr("href");

if(pgbks_link){

$("td:eq("+i+") span.availability,td:eq("+i+") span.actions").hide();

linkc.html('<a class="ebook" href="'+pgbks_link+'"><img src="https://lh4.googleusercontent.com/Tsij938Mxo5xDpEK4LNXJoj5LSN6tA6jIQDcUFeJeraWIPxusy4QawNkHEeatXkQvNJiHvFz9zKiI0CtmUdY8f0=w1280" alt="Tab here for eBook" width="200" height="25" /></a>');

}

});

// eBook detail

$("span.online_resources").ready(function(){

var pgbks_link = $("span.online_resources a[href^='https://doaj.org/toc']").attr("href");

if(pgbks_link){

$("#holdings").html('<a href="'+pgbks_link+'"><img src="https://lh4.googleusercontent.com/Tsij938Mxo5xDpEK4LNXJoj5LSN6tA6jIQDcUFeJeraWIPxusy4QawNkHEeatXkQvNJiHvFz9zKiI0CtmUdY8f0=w1280" alt="Tab here for eBook" width="300" height="50" /></a>');

}

});

/* ---------------------------------------------------------------------------- */

// E-Journal results

$("#userresults").ready(function(){

$("#userresults table td").each(function(i){

td = $(this);

var pgbks_link = td.find("a[href^='http://link.springer.com']");

var linkc = pgbks_link.parent();

var pgbks_link = pgbks_link.attr("href");

if(pgbks_link){

$("td:eq("+i+") span.availability,td:eq("+i+") span.actions").hide();

linkc.html('<a class="ebook" href="'+pgbks_link+'"><img src="https://lh3.googleusercontent.com/k_Gvt985TAisv59DBViDw1nCKYsuRTiBUmEOSUZVQmigK7HiPk1Em7cqxCwSVHWAPP912Xo47Zbs_wqJFlVCDs4=w1280" alt="Tab here for E-Journal" width="200" height="25" /></a>');

}

});

// E-Journal detail

$("span.online_resources").ready(function(){

var pgbks_link = $("span.online_resources a[href^='http://link.springer.com']").attr("href");

if(pgbks_link){

$("#holdings").html('<a href="'+pgbks_link+'"><img src="https://lh3.googleusercontent.com/k_Gvt985TAisv59DBViDw1nCKYsuRTiBUmEOSUZVQmigK7HiPk1Em7cqxCwSVHWAPP912Xo47Zbs_wqJFlVCDs4=w1280" alt="Tab here for E-Journal" width="300" height="50" /></a>');

}

});

/* ---------------------------------------------------------------------------- */

// E-Thesis results

$("#userresults").ready(function(){

$("#userresults table td").each(function(i){

td = $(this);

var pgbks_link = td.find("a[href^='https://www.tandfonline.com']");

var linkc = pgbks_link.parent();

var pgbks_link = pgbks_link.attr("href");

if(pgbks_link){

$("td:eq("+i+") span.availability,td:eq("+i+") span.actions").hide();

linkc.html('<a class="ebook" href="'+pgbks_link+'"><img src="https://lh3.googleusercontent.com/x_uCPUycp-5WDThKUHC4j7TZFZRgewYxafkyb1-QDq1594B3l41E2-pJFPou1AlaLj8bN8LgRL2gc8oZBn_rN_8=w1280" alt="Tab here for E-Thesis" width="200" height="25" /></a>');

}

});

// E-Thesis detail

$("span.online_resources").ready(function(){

var pgbks_link = $("span.online_resources a[href^='https://www.tandfonline.com']").attr("href");

if(pgbks_link){

$("#holdings").html('<a href="'+pgbks_link+'"><img src="https://lh3.googleusercontent.com/x_uCPUycp-5WDThKUHC4j7TZFZRgewYxafkyb1-QDq1594B3l41E2-pJFPou1AlaLj8bN8LgRL2gc8oZBn_rN_8=w1280" alt=" Tab here for E-Thesis" width="300" height="50" /></a>');

}

});

/* ---------------------------------------------------------------------------- */

OPACUserCSS

/*page background and font*/

body {

background-color: #fff;

font-family: sans-serif;

font-size: 14px;

}

/*header background*/

#opacheader {

background-color: #fff;

margin-top: 5px;

}

/*padding around header image*/

#opacheader img {

padding-top:15px;

padding-bottom:15px;

padding-left:10px;

}

/*link color*/

a, a:hover, a:focus {

color: #5a2374 !important;

}

/* center more searches bar */

#moresearches {

text-align: center;

}

/*Change navbar color*/

.navbar-inverse .navbar-inner {

background-image: linear-gradient(to bottom, #5a2374, #5a2374);

border-color: #5a2374;

background-color: #5a2374;

}

/*change navbar font to white*/

.navbar-inverse .brand, .navbar-inverse .nav > li > a, #members a {

color: #fff !important;

}

/*remove black bars from nav bar*/

.navbar-inverse .divider-vertical {

border-left-color: #5a2374;

border-right-color: #5a2374;

}

/*searchbox background*/

.mastheadsearch {

background: linear-gradient(to bottom, #5a2374 38%, #5a2374 100%) repeat scroll 0% 0% transparent;

}

/*search label made white*/

.mastheadsearch label {

color: white;

}

/*Search button color*/

.btn-primary {

color: #000;

text-shadow: 0px -1px 0px rgba(0, 0, 0, 0.25);

background-color: #F2F2EF !important;

background-image: linear-gradient(to bottom, #F2F2EF, #5a2374) !important;

}

#bib_holds {

border: 2px solid #5a2374;

border-radius: 15px 15px 15px 15px;

font-weight: bold;

padding-left: 10px;

}

-----

OPACUserCSS

#opac-main-search {

background: #151b54;

margin: 7px 0;

padding: 15px;

}

body {

background-color: #E5E4E2;

}

.main {

background-color: #E5E4E2;

border: 1px solid #E5E4E2;

margin: 15px;

padding: 1rem 0;

}

HTML button

<a href="https://youtube.com"><button type="button">Facebook</button></a>

CSS button

<style>

.button {

border: none;

color: white;

padding: 12px 80px;

text-align: center;

text-decoration: none;

display: inline-block;

font-size: 16px;

margin: 4px 2px;

transition-duration: 0.4s;

cursor: pointer;

}

.button1 {

background-color: white;

color: black;

border: 2px solid #008CBA;

}

.button1:hover {

background-color: #008CBA;

color: white;

}

.button2 {

background-color: white;

color: black;

border: 2px solid #008CBA;

}

.button2:hover {

background-color: #008CBA;

color: white;

}

.button3 {

background-color: white;

color: black;

border: 2px solid #008CBA;

}

.button3:hover {

background-color: #008CBA;

color: white;

}

.button4 {

background-color: white;

color: black;

border: 2px solid #008CBA;

}

.button4:hover {

background-color: #008CBA;

color: white;

}

.button5 {

background-color: white;

color: black;

border: 2px solid #008CBA;

}

.button5:hover {

background-color: #008CBA;

color: white;

}

.button6 {

background-color: white;

color: black;

border: 2px solid #008CBA;

}

.button6:hover {

background-color: #008CBA;

color: white;

}

.button7 {

background-color: white;

color: black;

border: 2px solid #008CBA;

}

.button7:hover {

background-color: #008CBA;

color: white;

}

</style>

<h2>Important links here</h2>

<a href="https://youtube.com"" target="_blank"><button class="button button1">Facebook</button></a> <br />

<a href="https://youtube.com"" target="_blank"><button class="button button2">Facebook</button></a><br />

<a href="https://youtube.com"" target="_blank"><button class="button button3">Facebook</button></a><br />

<a href="https://youtube.com"" target="_blank"><button class="button button4">Facebook</button></a><br />

<a href="https://youtube.com"" target="_blank"><button class="button button5">Facebook</button></a><br />

<a href="https://youtube.com"" target="_blank"><button class="button button6">Facebook</button></a><br />

<a href="https://youtube.com"" target="_blank"><button class="button button7">Facebook</button></a>

https://catalog.slocanlibrary.ca/cgi-bin/koha/opac-search.pl?advsearch=1&weight_search=1&do=Search&limit=mc-itype%2Cphr%3ABK&sort_by=relevance

OPAC Credits

href="http://wiki.koha-community.org/wiki/KohaUsers/SouthAsian#table_row_4">Koha-ILS,</a>

Implemented and Customized by <a href="https://pk.linkedin.com/pub/furrukh-hussain-

zai/a2/1/598">Mr. Furrukh Hussain Zai</a> for Ready Access to Free Library and Information Management Technologies in

2019)</font></center></p>

OPAC calendar add in Tools - News - HTML

<!DOCTYPE html>
<html>
<center>
<h2 style="color:DodgerBlue;">Calendar</h2>
<script language="javascript" type="text/javascript">
var day_of_week = new Array('Sun','Mon','Tue','Wed','Thu','Fri','Sat');
var month_of_year = new Array('January','February','March','April','May','June','July','August','September','October','November','December');

// DECLARE AND INITIALIZE VARIABLES

var Calendar = new Date();

var year = Calendar.getFullYear(); // Returns year

var month = Calendar.getMonth(); // Returns month (0-11)

var today = Calendar.getDate(); // Returns day (1-31)

var weekday = Calendar.getDay(); // Returns day (1-31)

var DAYS_OF_WEEK = 7; // "constant" for number of days in a week

var DAYS_OF_MONTH = 31; // "constant" for number of days in a month

var cal; // Used for printing

Calendar.setDate(1); // Start the calendar day at '1'

Calendar.setMonth(month); // Start the calendar month at now

/* VARIABLES FOR FORMATTING

NOTE: You can format the 'BORDER', 'BGCOLOR', 'CELLPADDING', 'BORDERCOLOR'

tags to customize your caledanr's look. */

var TR_start = '<TR>';

var TR_end = '</TR>';

var highlight_start = '<TD WIDTH="30"><TABLE CELLSPACING=0 BORDER=1 BGCOLOR=DEDEFF BORDERCOLOR=CCCCCC><TR><TD WIDTH=20><B><CENTER>';

var highlight_end = '</CENTER></TD></TR></TABLE></B>';

var TD_start = '<TD WIDTH="30"><CENTER>';

var TD_end = '</CENTER></TD>';

/* BEGIN CODE FOR CALENDAR

NOTE: You can format the 'BORDER', 'BGCOLOR', 'CELLPADDING', 'BORDERCOLOR'

tags to customize your calendar's look.*/

cal = '<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=0 BORDERCOLOR=BBBBBB><TR><TD>';

cal += '<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2>' + TR_start;

cal += '<TD COLSPAN="' + DAYS_OF_WEEK + '" BGCOLOR="#EFEFEF"><CENTER><B>';

cal += month_of_year[month] + ' ' + year + '</B>' + TD_end + TR_end;

cal += TR_start;

// DO NOT EDIT BELOW THIS POINT //

// LOOPS FOR EACH DAY OF WEEK

for(index=0; index < DAYS_OF_WEEK; index++)

{

// BOLD TODAY'S DAY OF WEEK

if(weekday == index)

cal += TD_start + '<B>' + day_of_week[index] + '</B>' + TD_end;

// PRINTS DAY

else

cal += TD_start + day_of_week[index] + TD_end;

}

cal += TD_end + TR_end;

cal += TR_start;

// FILL IN BLANK GAPS UNTIL TODAY'S DAY

for(index=0; index < Calendar.getDay(); index++)

cal += TD_start + ' ' + TD_end;

// LOOPS FOR EACH DAY IN CALENDAR

for(index=0; index < DAYS_OF_MONTH; index++)

{

if( Calendar.getDate() > index )

{

// RETURNS THE NEXT DAY TO PRINT

week_day =Calendar.getDay();

// START NEW ROW FOR FIRST DAY OF WEEK

if(week_day == 0)

cal += TR_start;

if(week_day != DAYS_OF_WEEK)

{

// SET VARIABLE INSIDE LOOP FOR INCREMENTING PURPOSES

var day = Calendar.getDate();

// HIGHLIGHT TODAY'S DATE

if( today==Calendar.getDate() )

cal += highlight_start + day + highlight_end + TD_end;

// PRINTS DAY

else

cal += TD_start + day + TD_end;

}

// END ROW FOR LAST DAY OF WEEK

if(week_day == DAYS_OF_WEEK)

cal += TR_end;

}

// INCREMENTS UNTIL END OF THE MONTH

Calendar.setDate(Calendar.getDate()+1);

}// end for loop

cal += '</TD></TR></TABLE></TABLE>';

// PRINT CALENDAR

document.write(cal);

// End -->

</script>

</center><br />

</html>

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)

Koha CoverFlow (New Arrivals)

Create a SQL public Report

Create a report and please note down the report id (here is SQL statement for New Arrivals)

Reports › Create from SQL

Copy and paste the following line

SELECT b.biblionumber, i.Barcode, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title

FROM items i

LEFT JOIN biblioitems m USING (biblioitemnumber)

LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)

WHERE DATE_SUB(CURDATE(),INTERVAL 15 DAY) <= i.dateaccessioned AND m.isbn IS NOT NULL AND m.isbn != ''

GROUP BY biblionumber

HAVING isbn != ""

LIMIT 30

Plugin: https://github.com/bywatersolutions/koha-plugin-coverflow

Download: https://github.com/bywatersolutions/koha-plugin-coverflow/releases

Enable koha plugin in terminal if not enabled

Terminal

sudo su

sudo leafpad /etc/koha/sites/library/koha-conf.xml

(find) <pluginsdir>/var/lib/koha/library/plugins</pluginsdir>

<enable>_plugins>0</enable_plugins> (Change 0 to 1) like this below

<enable>_plugins>1</enable_plugins>

save it

Restart Apache,

/etc/init.d/apache2 restart

Then Global System Preferences

UseKohaPlugins (Enable)

go to Tools > Tools Plugins

Upload Plugin

Go to Administration > Manage plugins > Upload a plugin > Choose > koha-coverflow-plugin-v2.4.0.kpz and upload

Once the Koha coverflow plugin was install click on Configure

In the Image options Section

Limit image size (height in pixels) 250

Limit title length (width in pixels) 150

In the mapping Section following line copy and paste

---

- id: 27

selector: "#coverflow"

options:

style: coverflow

- id: 27

selector: ".coverflow_class"

options:

buttons: true

autoplay: 3000

style: wheel

NOTE: Where id: 20 is the report id please write your SQL report id

Web Server Configuration

Open Applications > System Tools > Terminal

Apply the following command

sudo su (Enter the mysql password)

sudo leafpad /etc/apache2/sites-enabled/library.conf

Add the following line at the bottom of the file. replace the library with your koha instance name

ScriptAlias /coverflow.pl "/var/lib/koha/library/plugins/Koha/Plugin/Com/ByWaterSolutions/CoverFlow/coverflow.pl"

Alias /plugin/ "/var/lib/koha/library/plugins/"

# The stanza below is needed for Apache 2.4+

Options Indexes FollowSymLinks

AllowOverride None

Require all granted

</Directory>

Restart memcached:

sudo service memcached restart

Restart your webserver:

sudo service apache2 restart

OPAC Config

Now go to Administrator > global system preferences > OpacMainUserBlock

Put the following line in the system preference OpacMainUserBlock:

<b><h2><center><u><font color="purple">New Arrivals</font></h2></b></u>

<span id="coverflow">Loading...</span></center>

Other one method for New Arrivals

sudo gedit /etc/koha/sites/library/koha-conf.xml

1. In the xml file Change <enable_plugins>0<enable_plugins> to

<enable_plugins>1</enable_plugins>

2.Download the Carousel Plugin kpz file.

3.Go to: Koha Home › Tools › Plugins › Upload Plugin (Carrousel.kpz)

4. Go to: Koha Home › Lists › New Lists › Create 'New Arrivals' Public list

Add the New Arrivals items Barcodes: For example barcode 22300, 22301, 22302

5.Go to: Plugin Carrousel Click Actions 'Configure' (Select New Arrivals and change Bg color Etc..)

6.Go to: Plugin Carrousel Click Actions 'Run tool'

7. Generate carrousel ( Select New Arrivals ) and Click Generate

Search This Blog

LIB Science Info

Koha Manual

Koha Logo Change

Item check-out

Item check-in

OPAC Modifications

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