#!/bin/bash

#=================================================
# IMPORT GENERIC HELPERS
#=================================================

source _common.sh
source /usr/share/yunohost/helpers

#=================================================
# ENSURE DOWNWARD COMPATIBILITY
#=================================================
ynh_script_progression --message="Ensuring downward compatibility..." --weight=1

# If fpm_footprint doesn't exist, create it
if [ -z "${fpm_footprint:-}" ]; then
    fpm_footprint=medium
    ynh_app_setting_set --app=$app --key=fpm_footprint --value=$fpm_footprint
fi

# If fpm_usage doesn't exist, create it
if [ -z "${fpm_usage:-}" ]; then
    fpm_usage=medium
    ynh_app_setting_set --app=$app --key=fpm_usage --value=$fpm_usage
fi

# Delete existing ini configuration file (backward compatibility)
if [ -f /etc/php/$YNH_PHP_VERSION/fpm/conf.d/20-$app.ini ]; then
    ynh_secure_remove --file=/etc/php/$YNH_PHP_VERSION/fpm/conf.d/20-$app.ini
fi

if [ -n "${version:-}" ]; then
    ynh_app_setting_delete --app=$app --key="version"
fi

charset=$(mysql -ss -N -e "SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = '$db_name'")
if [ "$charset" != "utf8" ]; then
    ynh_print_info --message="Changing Database charset to utf8"
    ynh_mysql_execute_as_root --sql="ALTER DATABASE $db_name charset=utf8"
    ynh_local_curl  "/install/repair.php" "force_utf8_on_tables=confirmed"
    ynh_exec_fully_quiet sleep 5
fi

#=================================================
# MAKE SEQUENTIAL UPGRADES FROM EACH MAJOR
# VERSION TO THE NEXT ONE
#=================================================
ynh_script_progression --message="Upgrading source files..." --weight=60

# Sort --version-sort cdécembrean handle underscore in versions numbers
mapfile -t main_versions < <(
    ynh_read_manifest --manifest_key="resources.sources | keys[]" | grep "main_" | sort --version-sort
)
current_version="$YNH_APP_CURRENT_VERSION"
for version in "${main_versions[@]}"; do
    new_version=$(echo "$version" | sed 's|main_||' | sed 's|_|.|g')
    if dpkg --compare-versions "$current_version" ge "$new_version"; then
        continue
    fi
    ynh_print_info --message="Upgrading app from $current_version to $new_version"
    source_id="$version"
    upgrade_dolibarr
    current_version="$new_version"
done

# Final upgrade to the final version
new_version=$(ynh_app_upstream_version)
source_id="main"
ynh_print_info --message="Upgrading app from $current_version to $new_version"
upgrade_dolibarr

if "php$phpversion" "$install_dir/scripts/user/sync_users_ldap2dolibarr.php" commitiferror --server=localhost -y; then
    ynh_print_info --message="LDAP user update ok"
else
    ynh_print_info --message="LDAP user update ended with error"
fi

ynh_backup_if_checksum_is_different --file="$install_dir/htdocs/conf/conf.php"
# Recalculate and store the checksum of the file for the next upgrade.
ynh_store_file_checksum --file="$install_dir/htdocs/conf/conf.php"
chmod 644 "$install_dir/htdocs/conf/conf.php"

if [ ! -f "$install_dir/documents/install.lock" ]; then
    echo 'This is a lock file to prevent use of install pages (set with permission 440)' > "$install_dir/documents/install.lock"
    chown "$app:$app" "$install_dir/documents/install.lock"
    chmod 440 "$install_dir/documents/install.lock"
fi

chmod 750 "$install_dir"
chmod -R o-rwx "$install_dir"
chown -R "$app:www-data" "$install_dir"

# mkdir -p "$data_dir"
# chown -R $app: "$data_dir"
# chmod go-w $data_dir

#=================================================
# REAPPLY SYSTEM CONFIGURATIONS
#=================================================
ynh_script_progression --message="Upgrading system configurations related to $app..." --weight=1

ynh_add_fpm_config

ynh_add_nginx_config

ynh_use_logrotate --non-append

#=================================================
# END OF SCRIPT
#=================================================

ynh_script_progression --message="Upgrade of $app completed" --last