Published by: vikrant

sudo apt-get update
sudo apt-get upgrade
sudo apt-get clean
Download and install the latest Koha release

sudo apt-get install koha-common
sudo a2enmod rewrite
sudo a2enmod cgi
sudo service apache2 restart
sudo nano /etc/apache2/ports.conf
sudo apt-get update
sudo apt-get upgrade
This should generally upgrade your koha-common. However, if the dependencies for koha have increased, you may have to:
$ sudo apt-get install koha-common

 

Published by: Jivesna Tech

SELECT items.booksellerid, items.barcode, items.dateaccessioned, items.itemcallnumber, biblioitems.isbn, biblio.author, biblio.title, biblioitems.pages, items.price, biblioitems.editionstatement, biblioitems.publishercode, biblioitems.place, biblio.copyrightdate FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE items.homebranch =<<Branch|branches>>AND items.itype= <<Item type code|itemtypes>> ORDER BY LPAD(items.barcode,40,' ') ASC.

 

Published by: Jivesna Tech

SELECT old_issues.returndate,items.barcode,biblio.title,biblio.author,borrowers.firstname,borrowers.surname,borrowers.cardnumber,borrowers.categorycode FROM old_issues  LEFT JOIN borrowers ON borrowers.borrowernumber=old_issues.borrowernumber   LEFT JOIN items ON old_issues.itemnumber=items.itemnumber LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber where old_issues.returndate BETWEEN <<Between Date (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>>  ORDER BY old_issues.returndate DESC.

 

Published by: Jivesna Tech

SELECT issues.issuedate,items.barcode,biblio.title, author,borrowers.firstname,borrowers.surname,borrowers.cardnumber ,borrowers.categorycode  FROM issues  LEFT JOIN borrowers ON borrowers.borrowernumber=issues.borrowernumber   LEFT JOIN items ON issues.itemnumber=items.itemnumber    LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber where issues.issuedate BETWEEN <<Between Date (yyyy-mm-dd)>> and <<and (yyyy-mm-dd)>>  ORDER BY issues.issuedate DESC.

 

Published by: Jivesna Tech

SELECT borrowers.cardnumber, borrowers.surname, items.barcode, biblio.title, biblio.author, old_issues.issuedate, old_issues.date_due, old_issues.returndate, (TO_DAYS(old_issues.returndate)-TO_DAYS(old_issues.date_due)) AS 'days overdue'
FROM borrowers
RIGHT JOIN statistics ON (borrowers.borrowernumber = statistics.borrowernumber)
LEFT JOIN old_issues ON (borrowers.borrowernumber=old_issues.borrowernumber)
LEFT JOIN items ON (old_issues.itemnumber=items.itemnumber)
LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
WHERE statistics.type IN ('return') AND old_issues.returndate > DATE_SUB(CURDATE(), INTERVAL 0 DAY)
GROUP BY borrowers.cardnumber
ORDER BY borrowers.cardnumber ASC.

Pages