upgrade_from_v1.9.php

<?php

define('ROOT_PATH', '../');
include ROOT_PATH . 'define.php';
defined( '_PHP_CONGES' ) or die( 'Restricted access' );

/*******************************************************************/
// SCRIPT DE MIGRATION DE LA VERSION 1.9 vers 1.10
/*******************************************************************/
include ROOT_PATH .'fonctions_conges.php' ;
include INCLUDE_PATH .'fonction.php';

$PHP_SELF = filter_input(INPUT_SERVER, 'PHP_SELF', FILTER_SANITIZE_URL);

$version = (isset($_GET['version']) ? $_GET['version'] : (isset($_POST['version']) ? $_POST['version'] : "")) ;
$version = htmlentities($version, ENT_QUOTES | ENT_HTML401);

$sql = \includes\SQL::singleton();
$sql->getPdoObj()->begin_transaction();

//suppression de la variable print_disable_users de la bdd
$del_conf_from_db="DELETE FROM conges_config WHERE conf_nom = 'print_disable_users';";
$res_del_conf_from_db=\includes\SQL::query($del_conf_from_db);

//suppression de l'option calcul de nombre de jours, par défaut c'est automatique
$del_config_db="DELETE FROM conges_config WHERE conf_nom = 'affiche_bouton_calcul_nb_jours_pris';";
$res_del_config_from_db=\includes\SQL::query($del_config_db);

$del_config_db="DELETE FROM conges_config WHERE conf_nom = 'rempli_auto_champ_nb_jours_pris';";
$res_del_config_from_db=\includes\SQL::query($del_config_db);

//suppression de l'option de gestion des goupes
$del_config_db="DELETE FROM conges_config WHERE conf_nom = 'gestion_groupes';";
$res_del_config_from_db=\includes\SQL::query($del_config_db);

/* Ajout des champs de l'utilisateur requis pour l'API */
$alterApiUser = 'ALTER TABLE `conges_users`
    ADD `date_inscription` DATETIME NOT NULL DEFAULT NOW(),
    ADD `token` VARCHAR(100) NOT NULL DEFAULT "",
    ADD `date_last_access` DATETIME NOT NULL,
    ADD INDEX `token` (`token`)';
$sql->query($alterApiUser);

/* Ajout du token d'instance */
$addApiToken = 'INSERT IGNORE INTO `conges_appli` VALUES ("token_instance", "")';
$sql->query($addApiToken);

/* Modification de tous les mots de passe d'utilisateurs non db_conges */
$updateUserMD5 = 'UPDATE `conges_users` SET u_passwd = "' . md5('none') . '" where u_passwd = "none"';
$sql->query($updateUserMD5);

$sql->getPdoObj()->commit();

$del_config_db="DELETE FROM conges_config WHERE conf_nom = 'disable_saise_champ_nb_jours_pris';";
$res_del_config_from_db=\includes\SQL::query($del_config_db);

// on renvoit à la page mise_a_jour.php (là d'ou on vient)
echo "Migration depuis v1.9 effectuée. <a href=\"mise_a_jour.php?etape=2&version=$version\">Continuer.</a><br>\n";