#!/bin/bash

LANG=en_GB.UTF-8

# Add PHP 7.2.x Repository
sudo add-apt-repository ppa:ondrej/php -y

# Copy filename from http://dev.mysql.com/downloads/repo/apt/
mysql_apt_deb_file=mysql-apt-config_0.8.9-1_all.deb

# Add MySQL 5.7.x Repository
curl -LO http://repo.mysql.com/${mysql_apt_deb_file}
echo mysql-apt-config mysql-apt-config/select-product          select Apply              | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-server           select mysql-5.7          | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-connector-python select none               | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-workbench        select none               | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-utilities        select none               | sudo debconf-set-selections
echo mysql-apt-config mysql-apt-config/select-connector-odbc   select connector-odbc-x.x | sudo debconf-set-selections
export DEBIAN_FRONTEND=noninteractive
sudo -E dpkg -i ${mysql_apt_deb_file}

# Update
sudo apt-get -y update

# PHP Modules for Apache
sudo apt-get -y install libapache2-mod-php7.2
sudo a2dismod php5
sudo a2enmod php7.2

# Add Module for Laravel 5.7
sudo apt-get -y install php7.2-pdo
sudo apt-get -y install php7.2-mbstring
sudo apt-get -y install php7.2-tokenizer
sudo apt-get -y install php7.2-xml
sudo apt-get -y install php7.2-curl
sudo apt-get -y install php7.2-cli 
sudo apt-get -y install php7.2-dev
sudo apt-get -y install php7.2-gd 
sudo apt-get -y install php7.2-intl 
sudo apt-get -y install php7.2-mcrypt 
sudo apt-get -y install php7.2-json
sudo apt-get -y install php7.2-opcache
sudo apt-get -y install php7.2-bcmath
sudo apt-get -y install php7.2-soap
sudo apt-get -y install php7.2-zip
sudo apt-get -y install php7.2-sqlite
sudo apt-get -y install php7.2-mysql
sudo apt-get -y install unzip

# Upgrade MySQL Version 5.7.x
sudo apt-get -y install mysql-server
mysql-ctl start
sudo mysql_upgrade -u root --force --upgrade-system-tables

# Create User and Database
mysql -u root -e "create user homestead;create database homestead;grant all on homestead.* to homestead@localhost identified by 'secret';"

# Composer install 
sudo rm -rf $HOME/.composer
sudo rm -f /usr/bin/composer
sudo curl -sS https://getcomposer.org/installer | php
sudo cp composer.phar /usr/bin/composer

# Laravel 5.5 install
composer create-project --prefer-dist laravel/laravel=5.7.* laravel
shopt -s dotglob
mv laravel/* ./

# Authentication and Migration
php artisan make:auth
php artisan migrate

# Change DocumentRoot
cat > .htaccess << "EOF"
RewriteEngine on
RewriteBase /
RewriteRule ^$ public/ [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.+)$ public/$1 [L]
EOF

# Clean packages
sudo apt-get autoremove

# Add Adminer (Database management in a single PHP file) from https://www.adminer.org/
wget -O ./public/adminer.php https://www.adminer.org/static/download/4.6.3/adminer-4.6.3.php

# Remove File and Folder
rm -rf laravel
rm -rf laravel-resources-lang-ja
rm hello-world.php
rm ${mysql_apt_deb_file}

echo "PHP version : "
php -v |head -1

echo
echo "Mysql version : "
mysql -V |head -1

echo
echo "Laravel version : "
php artisan --version

# End
echo
echo "done!"



exit