#!/bin/sh
set -e
# mlohn postinst

# check, whether mlohn user exists
if ! mysql -umlohn -pmlohn mlohn -e";"
then
	echo "Installation of mlohn user ..."
	echo "Password of mysql root:"
	read pw
	mysql -uroot -p$pw <<END
create user mlohn@localhost identified by 'mlohn';
create database mlohn;
grant all on mlohn.* to mlohn@localhost;
END

	echo "Installation of mlohn schema ..."
	mysql -umlohn -pmlohn mlohn </usr/share/php/mLohn/Lohn/etc/schema.sql

	echo "Datainstallation ..."
	mysql -umlohn -pmlohn mlohn </usr/share/php/mLohn/Lohn/etc/insert.sql
else
	echo "Perform upgrade ... if necessary."
	/usr/share/php/mLohn/Lohn/etc/upgrade || exit 1
fi

# Check existence of mLohn configuration file
if ! [ -e /usr/share/php/mLohn/Lohn/impl/ConfigurationData.php ]
then
	cp /usr/share/php/mLohn/Lohn/impl/ConfigurationData.default.php /usr/share/php/mLohn/Lohn/impl/ConfigurationData.php
	echo "Default configuration copied to /usr/share/php/mLohn/Lohn/impl/ConfigurationData.php"
	echo "Edit this file, if necessary!"
fi

# add sysal site to apache configuration
cd /etc/apache2/sites-enabled
if ! grep "#mlohn#" * >/dev/null
then
	# .conf necessary for Debian 7
	a2ensite mlohn.conf
fi

# activate rewrite engine
if ! test -e /etc/apache2/mods-enabled/rewrite.load
then
	ln -s /etc/apache2/mods-available/rewrite.load /etc/apache2/mods-enabled
	echo "rewrite engine enabled"
fi

# restart apache
/etc/init.d/apache2 restart

# create directory for Lohnabrechnungen
mkdir -p /var/mlohn/print
chown www-data /var/mlohn/print
chgrp www-data /var/mlohn/print