hook.php

<?php

/**
 * Install hook
 *
 * @return boolean
 */
function plugin_reservation_install()
{
    global $DB, $CFG_GLPI;

    $version = plugin_version_reservation();
    $migration = new Migration($version['version']);

    if (!$DB->tableExists("glpi_plugin_reservation_categories")) {
        $query = "CREATE TABLE `glpi_plugin_reservation_categories` (
                `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
                `name` VARCHAR(255) NOT NULL,
                PRIMARY KEY (`id`),
                UNIQUE (`name`)
                ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";

        $DB->queryOrDie($query, $DB->error());
    }

    if (!$DB->tableExists("glpi_plugin_reservation_categories_items")) {
        $query = "CREATE TABLE `glpi_plugin_reservation_categories_items` (
                `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
                `categories_id` int UNSIGNED NOT NULL,
                `reservationitems_id` int UNSIGNED NOT NULL,
                `priority` int(11) NOT NULL,
                PRIMARY KEY (`id`),
                  KEY `reservationitems_id` (`reservationitems_id`),
                  KEY `categories_id` (`categories_id`),
                  UNIQUE (`categories_id`, `reservationitems_id`)
                ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";

        $DB->queryOrDie($query, $DB->error());
    }

    if ($DB->tableExists('glpi_plugin_reservation_reservations')) { // UPDATE 2.2.0
        $migration->addField(
            'glpi_plugin_reservation_reservations',
            'checkindate',
            'datetime',
            ['null' => true]
        );
    }

    if (!$DB->tableExists("glpi_plugin_reservation_reservations")) { //INSTALL >= 2.0.0
        $query = "CREATE TABLE `glpi_plugin_reservation_reservations` (
                `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
                `reservations_id` int UNSIGNED NOT NULL,
                `baselinedate` timestamp NOT NULL,
                `effectivedate`  timestamp NULL,
                `mailingdate` timestamp NULL,
                `checkindate` timestamp NULL,
                PRIMARY KEY (`id`),
                KEY `reservations_id` (`reservations_id`)
                ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";

        $DB->queryOrDie($query, $DB->error());
    }

    // 2.2.0
    // mettre une date de checkin pour toutes les reservations precedentes à la date actuelle !
    // $query = "UPDATE glpi_plugin_reservation_reservations
    //          SET checkindate = NOW()
    //          WHERE `begin` <= NOW()
    //          AND effectivedate is null
    //          AND checkindate is null
    //          ";
    // $DB->queryOrDie($query, $DB->error());

    // add existing reservations if necessary
    $query = "SELECT *
            FROM glpi_reservations
            WHERE `end` >= NOW()
            AND glpi_reservations.id NOT IN
               (
                  SELECT reservations_id
                  FROM glpi_plugin_reservation_reservations
               )";
    $reservation = new Reservation();
    foreach ($DB->request($query) as $data) {
        $reservation->getFromDb($data['id']);
        plugin_item_add_reservation($reservation);
    }

    if (!$DB->tableExists("glpi_plugin_reservation_configs")) { //INSTALL >= 2.0.0
        $query = "CREATE TABLE `glpi_plugin_reservation_configs` (
               `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
               `name` VARCHAR(255) NOT NULL,
               `value` VARCHAR(255) NOT NULL,
               PRIMARY KEY (`id`),
               UNIQUE (`name`)
               ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci";
        $DB->queryOrDie($query, $DB->error());

        $query = "INSERT INTO `glpi_plugin_reservation_configs` (`name` , `value`)
               VALUES  (\"mode_auto\",0),
                        (\"conflict_action\",\"delete\")";

        $DB->queryOrDie($query, $DB->error());
    }

    $cron = new CronTask();

    if ($cron->getFromDBbyName('PluginReservationTask', 'SurveilleResa')) { // plugin < 2.0.0
        CronTask::unregister("Reservation");
    }

    if (!$cron->getFromDBbyName('PluginReservationTask', 'checkReservations')) {
        CronTask::Register(
            'PluginReservationTask',
            'checkReservations',
            $CFG_GLPI['time_step'] * MINUTE_TIMESTAMP,
            ['param' => 24, 'mode' => 2, 'logs_lifetime' => 10]
        );
    }

    if (!$cron->getFromDBbyName('PluginReservationTask', 'sendMailLateReservations')) {
        CronTask::Register(
            'PluginReservationTask',
            'sendMailLateReservations',
            DAY_TIMESTAMP,
            ['hourmin' => 23, 'hourmax' => 24, 'mode' => 2, 'logs_lifetime' => 30, 'state' => 0]
        );
    }

    // update event to new event type to preserve previous behaviour
    $query = "UPDATE `glpi_notifications`
   SET
      `event` = \"plugin_reservation_conflict_new_user\"
   WHERE
      `event` = \"plugin_reservation_conflit\"
   OR
      `event` = \"plugin_reservation_conflict\"";
    $DB->queryOrDie($query, $DB->error());

    //execute the whole migration
    $migration->executeMigration();

    return true;
}

/**
 * Uninstall hook
 *
 * @return boolean
 */
function plugin_reservation_uninstall()
{
    global $DB;
    $tables = ["glpi_plugin_reservation_reservations", "glpi_plugin_reservation_configs", "glpi_plugin_reservation_categories", "glpi_plugin_reservation_categories_items"];
    foreach ($tables as $table) {
        $DB->query("DROP TABLE IF EXISTS `$table`");
    }
    CronTask::unregister("Reservation");
    return true;
}

/**
 * hook : add Plugin reservation when a GLPI reservation is added
 *
 * @return void
 */
function plugin_item_add_reservation($reservation)
{
    global $DB;

    $DB->insertOrDie('glpi_plugin_reservation_reservations', [
        'reservations_id' => $reservation->fields['id'],
        'baselinedate' => $reservation->fields['end'],
    ]);
    Toolbox::logInFile('reservations_plugin', "plugin_item_add_reservation : " . json_encode($reservation) . "\n", $force = false);

    $config = new PluginReservationConfig();
    if ($config->getConfigurationValue("checkin", 0) == 1 && $config->getConfigurationValue("auto_checkin", 0) == 1) {
        $time = time();
        $until_auto_checkin = $config->getConfigurationValue("auto_checkin_time", 1) * MINUTE_TIMESTAMP;
        $until = date("Y-m-d H:i:s", $time + $until_auto_checkin);
        if ($reservation->fields['begin'] <= $until) {
            Toolbox::logInFile('reservations_plugin', "auto-checkin enable : reservation " . json_encode($reservation->fields['id']) . " is checkin automatically\n", $force = false);
            PluginReservationReservation::checkinReservation($reservation->fields['id']);
        }
    }
}

/**
 * hook : update plugin reservation when a GLPI reservation is updated
 *
 * @return void
 */
function plugin_item_update_reservation($reservation)
{
    global $DB;

    $end = $reservation->fields['end'];

    $query = 'SELECT `effectivedate`
            FROM glpi_plugin_reservation_reservations
            WHERE `reservations_id` = ' . $reservation->fields['id'];
    // maybe the reservation is over
    $resume = false;
    foreach ($DB->request($query) as $data) {
        if ($end >= $data['effectivedate']) {
            $resume = true;
        }
    }

    if ($resume) {
        $DB->updateOrDie(
            'glpi_plugin_reservation_reservations',
            [
                'baselinedate' => $end,
                'effectivedate' => 'NULL',
            ],
            [
                'reservations_id' => $reservation->fields["id"],
            ]
        );
    } else {
        $DB->updateOrDie(
            'glpi_plugin_reservation_reservations',
            [
                'baselinedate' => $end,
            ],
            [
                'reservations_id' => $reservation->fields["id"],
            ]
        );
    }
    Toolbox::logInFile('reservations_plugin', "plugin_item_update_reservation : " . json_encode($reservation) . "\n", $force = false);
}

/**
 * hook : delete Plugin reservation when a GLPI reservation is delete
 *
 * @return void
 */
function plugin_item_purge_reservation($reservation)
{
    global $DB;
    Toolbox::logInFile('reservations_plugin', "plugin_item_purge_reservation : " . json_encode($reservation) . "\n", $force = false);
    $DB->delete(
        'glpi_plugin_reservation_reservations',
        [
            'reservations_id' => $reservation->fields["id"],
        ]
    );
}