<?php

class Prestashop
{
    public static function disableLanguagesExcept($language)
    {
        $link = mysqli_connect(DB_MAIN_HOST, DB_MAIN_LOGIN, DB_MAIN_PASSWORD, DB_MAIN_NAME, (int)DB_MAIN_PORT, DB_MAIN_SOCKET);

        if (!$link) {
            echo mysqli_connect_error();
            exit(1);
        }
        $db_prefix = DB_MAIN_PREFIX;
        $query = "SELECT * FROM {$db_prefix}lang";
        $query_result = mysqli_query($link, $query);
        if (false === $query_result) {
            echo "\nQuery $query failed.\n";
            echo mysqli_error($link) . "\n";
            exit(1);
        }
        for ($i = 1; $i <= mysqli_num_rows($query_result); $i++) {
            $deactivate_query = "UPDATE `{$db_prefix}lang` SET `active`='0' WHERE `id_lang`='$i';";
            mysqli_query($link, $deactivate_query);
        }
        mysqli_query($link, "UPDATE `{$db_prefix}lang` SET `active`='1' WHERE `iso_code`='$language';");
        $id_lang = selectSQL("SELECT `id_lang` FROM `{$db_prefix}lang` WHERE `iso_code`='$language';");
        mysqli_query($link, "UPDATE `{$db_prefix}configuration` SET `value`='$id_lang' WHERE `name`='PS_LANG_DEFAULT';");
        mysqli_close($link);
    }

    public static function activateHtaccess(){

        $htaccess = file_get_contents(dirname(__FILE__) . '/.htaccess', FILE_TEXT);
        $htaccess = replace('#BASE_URL_PATH#', BASE_URL_PATH, $htaccess);
        $htaccess = file_put_contents(WEBSPACE . '/.htaccess', $htaccess, FILE_TEXT);

        $db_prefix = DB_MAIN_PREFIX;
        $date = selectSQL("SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')");
        querySQL("UPDATE `{$db_prefix}configuration` SET `value`='1' WHERE `name`='PS_REWRITING_SETTINGS';");
        querySQL("UPDATE `{$db_prefix}configuration` SET `date_upd`='$date' WHERE `name`='PS_REWRITING_SETTINGS';");
    }

    public static function disableHtaccess(){

        $web_dir = WEBSPACE;
        system("rm -rf $web_dir/.htaccess");

        $db_prefix = DB_MAIN_PREFIX;
        $date = selectSQL("SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')");
        querySQL("UPDATE `{$db_prefix}configuration` SET `value`='0' WHERE `name`='PS_REWRITING_SETTINGS';");
        querySQL("UPDATE `{$db_prefix}configuration` SET `date_upd`='$date' WHERE `name`='PS_REWRITING_SETTINGS';");
    }

    public static function languageID()
    {
        switch (LOCALE) {
            case 'de_DE':
                $languageID = '1';
                break;
            case 'en_US':
                $languageID = '2';
                break;
            case 'es_ES':
                $languageID = '3';
                break;
            case 'fr_FR':
                $languageID = '4';
                break;
            case 'it_IT':
                $languageID = '5';
                break;
            case 'pl_PL':
                $languageID = '6';
                break;
            default:
                $languageID = '2';
        }

        return $languageID;
    }

    public static function countryID()
    {
        switch (LOCALE) {
            case 'de_DE':
                $countryID = '1';
                break;
            case 'en_US':
                $countryID = '21';
                break;
            case 'es_ES':
                $countryID = '6';
                break;
            case 'fr_FR':
                $countryID = '8';
                break;
            case 'it_IT':
                $countryID = '10';
                break;
            case 'pl_PL':
                $countryID = '14';
                break;
            default:
                $countryID = '21';
        }

        return $countryID;
    }

    public static function weightUnit()
    {
        switch (LOCALE) {
            case 'de_DE':
                $weight = 'kg';
                break;
            case 'en_US':
                $weight = 'lb';
                break;
            case 'es_ES':
                $weight = 'kg';
                break;
            case 'fr_FR':
                $weight = 'kg';
                break;
            case 'it_IT':
                $weight = 'kg';
                break;
            case 'pl_PL':
                $weight = 'kg';
                break;
            default:
                $weight = 'lb';
        }

        return $weight;
    }

    public static function volumeUnit()
    {
        switch (LOCALE) {
            case 'de_DE':
                $volume = 'L';
                break;
            case 'en_US':
                $volume = 'gal';
                break;
            case 'es_ES':
                $volume = 'L';
                break;
            case 'fr_FR':
                $volume = 'L';
                break;
            case 'it_IT':
                $volume = 'L';
                break;
            case 'pl_PL':
                $volume = 'L';
                break;
            default:
                $volume = 'gal';
        }

        return $volume;
    }

    public static function distanceUnit()
    {
        switch (LOCALE) {
            case 'de_DE':
                $distance = 'km';
                break;
            case 'en_US':
                $distance = 'mi';
                break;
            case 'es_ES':
                $distance = 'km';
                break;
            case 'fr_FR':
                $distance = 'km';
                break;
            case 'it_IT':
                $distance = 'km';
                break;
            case 'pl_PL':
                $distance = 'km';
                break;
            default:
                $distance = 'mi';
        }

        return $distance;
    }

    public static function dimensionUnit()
    {
        switch (LOCALE) {
            case 'de_DE':
                $dimension = 'cm';
                break;
            case 'en_US':
                $dimension = 'in';
                break;
            case 'es_ES':
                $dimension = 'cm';
                break;
            case 'fr_FR':
                $dimension = 'cm';
                break;
            case 'it_IT':
                $dimension = 'cm';
                break;
            case 'pl_PL':
                $dimension = 'cm';
                break;
            default:
                $dimension = 'in';
        }

        return $dimension;
    }

    public static function baseDistanceUnit()
    {
        switch (LOCALE) {
            case 'de_DE':
                $distance = 'm';
                break;
            case 'en_US':
                $distance = 'ft';
                break;
            case 'es_ES':
                $distance = 'm';
                break;
            case 'fr_FR':
                $distance = 'm';
                break;
            case 'it_IT':
                $distance = 'm';
                break;
            case 'pl_PL':
                $distance = 'm';
                break;
            default:
                $distance = 'ft';
        }

        return $distance;
    }

}