LIB Science Info

  Koha Plugin : In Out Management System System Requirements:   Software:   Apache (Already there in koha server)   PHP   MySQL (Already there in koha server)  Any text editor like vim/mousepad/leafpad/gedit Hardware:  A computer system with a widescreen monitor  Automatic barcode scanner Installation: PHP Installation:  for Debian 10 & Ubuntu 20.04 LTS Open a terminal and enter the following commands. sudo apt-get install -y git php libapache2-mod-php php-{bcmath,bz2,intl,gd,mbstring,mysql,zip,cli,fpm,opcache,xml,curl,intl,xsl,soap,json} cd /usr/share/koha/opac/htdocs sudo git clone https://github.com/omkar2403/inout.git sudo chmod 777 -R inout Setup the database: Go to MySQL shell and create a database, user, and password for inout   sudo su mysql -uroot -p [Enter MySQL Root password] CREATE database   libinout ; CREATE USER ' libinout '@'localhost' IDENTIFIED BY ' libinout123 '; GRANT ALL PRIVILEGES ON *.* TO ' libinout '@'localhost' WIT

  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