cc17bd5fe4
* Bugfix Uncaught ReferenceError: $ is not defined on ITIL Object creation * Delete error message after case cancellation successfully * change minimum version of processmaker server * delete TODO comment * Add possibility to cancel case with multiple tasks * bugfix delete reminder on case's cancel or delete * Add behavior on a claimed task or reasign to the current user for show task in timeline * Fixed issue with default dates settings in reminders for tasks * Added shortcut to select "Me as sender" * Added a test to prevent post-only user to set reminder settings * Updated XML * Fix issue with screen view * Adjusted wordings * Reviewed $new_date computation in cron * Bugfix creating a case in processcase tab doesn't redirect to the case * Adjusted visualization for Reminder * Added an <hr> * Adjusted values in dropdowns when settings are NULL * Added a test to prevent sending of remminders to "ProcessMaker" user * Added view of default and actual reminder settings for a PM task * cronPMReminder reflects changes and send reminders * Re-engineered table fields and search options * Fixed issue with FUP that were no longuer added to timeline. * Added automatic reminders * bugfix on filter * Changed copyrights * added .gitignore * add process category search option + input in process form * Added process categories * bugfixes on helpdesk process * bugfixes html_tags and actiontime * Changed the way the userId of the first task was computed, to be able to have a tobeclaimed task * Added get/set APP_DATA scripts to be able to read/write the APP_DATA in json files * Added a followup when a reminder is sent to task user (or group) Set version 5.2.3
71 lines
3.1 KiB
PHP
71 lines
3.1 KiB
PHP
<?php
|
|
/*
|
|
-------------------------------------------------------------------------
|
|
ProcessMaker plugin for GLPI
|
|
Copyright (C) 2014-2023 by Raynet SAS a company of A.Raymond Network.
|
|
|
|
https://www.araymond.com/
|
|
-------------------------------------------------------------------------
|
|
|
|
LICENSE
|
|
|
|
This file is part of ProcessMaker plugin for GLPI.
|
|
|
|
This file is free software; you can redistribute it and/or modify
|
|
it under the terms of the GNU General Public License as published by
|
|
the Free Software Foundation; either version 2 of the License, or
|
|
(at your option) any later version.
|
|
|
|
This plugin is distributed in the hope that it will be useful,
|
|
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
GNU General Public License for more details.
|
|
|
|
You should have received a copy of the GNU General Public License
|
|
along with this plugin. If not, see <http://www.gnu.org/licenses/>.
|
|
--------------------------------------------------------------------------
|
|
*/
|
|
function update_4_4_0_to_4_5_0() {
|
|
global $DB;
|
|
|
|
if (!$DB->tableExists('glpi_plugin_processmaker_taskrecalls')) {
|
|
$query = "CREATE TABLE `glpi_plugin_processmaker_taskrecalls` (
|
|
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`plugin_processmaker_tasks_id` INT UNSIGNED NOT NULL,
|
|
`before_time` INT NOT NULL DEFAULT '-10',
|
|
`after_time` INT NOT NULL DEFAULT '-10',
|
|
`when` TIMESTAMP NULL DEFAULT NULL,
|
|
`users_id` INT UNSIGNED NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE INDEX `item` (`plugin_processmaker_tasks_id`),
|
|
INDEX `when` (`when`)
|
|
) ENGINE=InnoDB;";
|
|
$DB->query($query) or die("error when creating glpi_plugin_processmaker_taskrecalls table" . $DB->error());
|
|
}
|
|
|
|
if (!$DB->tableExists('glpi_plugin_processmaker_taskalerts')) {
|
|
$query = "CREATE TABLE `glpi_plugin_processmaker_taskalerts` (
|
|
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`plugin_processmaker_taskrecalls_id` INT UNSIGNED NOT NULL,
|
|
`date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`),
|
|
INDEX `plugin_processmaker_taskrecalls_id` (`plugin_processmaker_taskrecalls_id`),
|
|
INDEX `date` (`date`)
|
|
) ENGINE=InnoDB;";
|
|
|
|
$DB->query($query) or die("error when creating glpi_plugin_processmaker_taskalerts table" . $DB->error());
|
|
}
|
|
|
|
if (!$DB->fieldExists('glpi_plugin_processmaker_taskcategories', 'reminder_recall_time')) {
|
|
// add the field into table
|
|
$query = "ALTER TABLE `glpi_plugin_processmaker_taskcategories`
|
|
ADD COLUMN `before_time` INT NOT NULL DEFAULT '-10',
|
|
ADD COLUMN `after_time` INT NOT NULL DEFAULT '-10',
|
|
ADD COLUMN `users_id` INT UNSIGNED NULL
|
|
;";
|
|
|
|
$DB->query($query) or die("error when adding reminder_recall_time field to glpi_plugin_processmaker_taskcategories table" . $DB->error());
|
|
}
|
|
|
|
return '4.5.0';
|
|
} |