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' WITH GRANT OPTION;

FLUSH PRIVILEGES;

quit;

In the above syntax  'libinout' is the database, ‘libinout’ is the database username and ‘libinout123’ is the database password. Make sure you replace it with your credentials. Now restore the sample database which is present in the ‘inout/DB’ directory. 

 

Run the following command in terminal

sudo su

mysql -uroot -p libinout < /usr/share/koha/opac/htdocs/inout/DB/inout.sql

[Enter MySQL Root password eg: mysqlroot]   

Replace your database name, database username, and database password in the file dbconn.php located in ‘inout’ directory at line number 3 and change connection details

sudo gedit /usr/share/koha/opac/htdocs/inout/functions/dbconn.php

Restart Apache

sudo systemctl reload apache2

sudo systemctl restart apache2

The system is ready now.

You can access it at the address given below:

http://127.0.0.1/inout/login.php

NB: If it results with 404 Error Page not Found, Please do the following

Check inout directory

This system should be installed in /usr/share/koha/opac/htdocs/ directory.

Check Port Number

Many libraries change their default port number for OPAC.

Generally, we access inout system by http://127.0.0.1/inout where its port is default 80.

But sometimes you access OPAC with a different port number. Eg: http://127.0.0.1:8001

In this case, if you want to access inout you should follow this http://127.0.0.1:8001/inout

Backing up libinout database

sudo su

mysqldump -ulibinout -plibinout123 libinout | xz > libinout-$(date +%d-%m-%Y-%H.%M).sql.xz

Fix characters Length

Card numbers with more than 11 characters may not work with inout, that can be fixed,

Go to MySQL shell

sudo mysql -uroot -p

USE libinout;

ALTER TABLE 'inout' CHANGE 'cardnumber' 'cardnumber' VARCHAR(50);

FLUSH PRIVILEGES;

quit;