LIB Science Info

 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> <img src=" https://blog.flamingtext.com/blog/2019/03/22/flamingtext_com_1553238916_676588398.gif " border="0" > <hr></hr> <img src=" https://blog.flamingtext.com/blog/2019/05/28/flamingtext_com_1559016309_767465469.gif " border="0"> or < marquee align="center" behavior="alternate" direction="left" onmouseout="this.start()" onmouseover="this

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(functi

  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