.
* ---------------------------------------------------------------------
*/
if (!defined('GLPI_ROOT')) {
die("Sorry. You can't access this file directly");
}
/**
* Reservation Class
**/
class Reservation extends CommonDBChild {
// From CommonDBChild
static public $itemtype = 'ReservationItem';
static public $items_id = 'reservationitems_id';
static $rightname = 'reservation';
static public $checkParentRights = self::HAVE_VIEW_RIGHT_ON_ITEM;
/**
* @param $nb integer for singular or plural
**/
static function getTypeName($nb = 0) {
return _n('Reservation', 'Reservations', $nb);
}
/**
* @see CommonGLPI::getTabNameForItem()
**/
function getTabNameForItem(CommonGLPI $item, $withtemplate = 0) {
if (!$withtemplate
&& Session::haveRight("reservation", READ)) {
return self::getTypeName(Session::getPluralNumber());
}
return '';
}
/**
* @param $item CommonGLPI object
* @param $tabnum (default1)
* @param $withtemplate (default0)
**/
static function displayTabContentForItem(CommonGLPI $item, $tabnum = 1, $withtemplate = 0) {
if ($item->getType() == 'User') {
self::showForUser($_GET["id"]);
} else {
self::showForItem($item);
}
return true;
}
function pre_deleteItem() {
global $CFG_GLPI;
if (isset($this->fields["users_id"])
&& (($this->fields["users_id"] === Session::getLoginUserID())
|| Session::haveRight("reservation", DELETE))) {
// Processing Email
if (!isset($this->input['_disablenotif']) && $CFG_GLPI["use_notifications"]) {
// Only notify for non-completed reservations
if (strtotime($this->fields['end']) > time()) {
NotificationEvent::raiseEvent("delete", $this);
}
}
}
return true;
}
/**
* @see CommonDBChild::prepareInputForUpdate()
**/
function prepareInputForUpdate($input) {
$item = 0;
if (isset($input['_item'])) {
$item = $_POST['_item'];
}
// Save fields
$oldfields = $this->fields;
// Needed for test already planned
if (isset($input["begin"])) {
$this->fields["begin"] = $input["begin"];
}
if (isset ($input["end"])) {
$this->fields["end"] = $input["end"];
}
if (!$this->test_valid_date()) {
$this->displayError("date", $item);
return false;
}
if ($this->is_reserved()) {
$this->displayError("is_res", $item);
return false;
}
// Restore fields
$this->fields = $oldfields;
return parent::prepareInputForUpdate($input);
}
/**
* @see CommonDBTM::post_updateItem()
**/
function post_updateItem($history = 1) {
global $CFG_GLPI;
if (count($this->updates)
&& $CFG_GLPI["use_notifications"]
&& !isset($this->input['_disablenotif'])) {
NotificationEvent::raiseEvent("update", $this);
//$mail = new MailingResa($this,"update");
//$mail->send();
}
parent::post_updateItem($history);
}
/**
* @see CommonDBChild::prepareInputForAdd()
**/
function prepareInputForAdd($input) {
// Error on previous added reservation on several add
if (isset($input['_ok']) && !$input['_ok']) {
return false;
}
// set new date.
$this->fields["reservationitems_id"] = $input["reservationitems_id"];
$this->fields["begin"] = $input["begin"];
$this->fields["end"] = $input["end"];
if (!$this->test_valid_date()) {
$this->displayError("date", $input["reservationitems_id"]);
return false;
}
if ($this->is_reserved()) {
$this->displayError("is_res", $input["reservationitems_id"]);
return false;
}
return parent::prepareInputForAdd($input);
}
function post_addItem() {
global $CFG_GLPI;
if (!isset($this->input['_disablenotif']) && $CFG_GLPI["use_notifications"]) {
NotificationEvent::raiseEvent("new", $this);
}
parent::post_addItem();
}
// SPECIFIC FUNCTIONS
/**
* @param $reservationitems_id
**/
function getUniqueGroupFor($reservationitems_id) {
global $DB;
do {
$rand = mt_rand(1, mt_getrandmax());
$result = $DB->request([
'COUNT' => 'cpt',
'FROM' => 'glpi_reservations',
'WHERE' => [
'reservationitems_id' => $reservationitems_id,
'group' => $rand
]
])->next();
$count = (int)$result['cpt'];
} while ($count > 0);
return $rand;
}
/**
* Is the item already reserved ?
*
*@return boolean
**/
function is_reserved() {
global $DB;
if (!isset($this->fields["reservationitems_id"])
|| empty($this->fields["reservationitems_id"])) {
return true;
}
// When modify a reservation do not itself take into account
$where = [];
if (isset($this->fields["id"])) {
$where['id'] = ['<>', $this->fields['id']];
}
$result = $DB->request([
'COUNT' => 'cpt',
'FROM' => $this->getTable(),
'WHERE' => $where + [
'reservationitems_id' => $this->fields['reservationitems_id'],
'end' => ['>', $this->fields['begin']],
'begin' => ['<', $this->fields['end']]
]
])->next();
return $result['cpt'] > 0;
}
/**
* Current dates are valid ? begin before end
*
*@return boolean
**/
function test_valid_date() {
return (!empty($this->fields["begin"])
&& !empty($this->fields["end"])
&& (strtotime($this->fields["begin"]) < strtotime($this->fields["end"])));
}
/**
* display error message
*
* @param $type error type : date / is_res / other
* @param $ID ID of the item
*
* @return void
**/
function displayError($type, $ID) {
echo "
";
switch ($type) {
case "date" :
echo __('Error in entering dates. The starting date is later than the ending date');
break;
case "is_res" :
echo __('The required item is already reserved for this timeframe');
break;
default :
echo __("Unknown error");
}
echo " ".__('Back to planning')."";
echo "
";
}
/**
* @since 0.84
**/
static function canCreate() {
return (Session::haveRight(self::$rightname, ReservationItem::RESERVEANITEM));
}
/**
* @since 0.84
**/
static function canUpdate() {
return (Session::haveRight(self::$rightname, ReservationItem::RESERVEANITEM));
}
/**
* @since 0.84
**/
static function canDelete() {
return (Session::haveRight(self::$rightname, ReservationItem::RESERVEANITEM));
}
/**
* Overload canChildItem to make specific checks
* @since 0.84
**/
function canChildItem($methodItem, $methodNotItem) {
// Original user always have right
if ($this->fields['users_id'] === Session::getLoginUserID()) {
return true;
}
if (!parent::canChildItem($methodItem, $methodNotItem)) {
return false;
}
$ri = $this->getItem();
if ($ri === false) {
return false;
}
$item = $ri->getItem();
if ($item === false) {
return false;
}
return Session::haveAccessToEntity($item->getEntityID());
}
function post_purgeItem() {
global $DB;
if (isset($this->input['_delete_group']) && $this->input['_delete_group']) {
$iterator = $DB->request([
'FROM' => 'glpi_reservations',
'WHERE' => [
'reservationitems_id' => $this->fields['reservationitems_id'],
'group' => $this->fields['group']
]
]);
$rr = clone $this;
while ($data = $iterator->next()) {
$rr->delete(['id' => $data['id']]);
}
}
}
/**
* Show reservation calendar
*
* @param $ID ID of the reservation item (if empty display all) (default '')
**/
static function showCalendar($ID = "") {
global $CFG_GLPI;
if (!Session::haveRight("reservation", ReservationItem::RESERVEANITEM)) {
return false;
}
if (!isset($_GET["mois_courant"])) {
$mois_courant = intval(strftime("%m"));
} else {
$mois_courant = $_GET["mois_courant"];
}
if (!isset($_GET["annee_courante"])) {
$annee_courante = strftime("%Y");
} else {
$annee_courante = $_GET["annee_courante"];
}
$mois_courant = intval($mois_courant);
$mois_suivant = $mois_courant+1;
$mois_precedent = $mois_courant-1;
$annee_suivante = $annee_courante;
$annee_precedente = $annee_courante;
if ($mois_precedent == 0) {
$mois_precedent = 12;
$annee_precedente --;
}
if ($mois_suivant == 13) {
$mois_suivant = 1;
$annee_suivante ++;
}
$monthsarray = Toolbox::getMonthsOfYearArray();
$str_suivant = "?reservationitems_id=$ID&mois_courant=$mois_suivant&".
"annee_courante=$annee_suivante";
$str_precedent = "?reservationitems_id=$ID&mois_courant=$mois_precedent&".
"annee_courante=$annee_precedente";
if (!empty($ID)) {
$m = new ReservationItem();
$m->getFromDB($ID);
if ((!isset($m->fields['is_active'])) || !$m->fields['is_active']) {
echo "
";
// il ne faut pas oublie d'aller a la ligne suivante en fin de semaine
if ((($i+$jour_debut_mois)%7) == 1) {
echo "
\n";
if ($i != $nb_jour[$mois_courant-1]) {
echo "
";
}
}
}
// on recommence pour finir le tableau proprement pour les m???es raisons
if ($jour_fin_mois != 0) {
for ($i=0; $i<7-$jour_fin_mois; $i++) {
echo "
";
}
}
echo "
\n";
echo "
\n";
}
/**
* Display for reservation
*
* @param $ID ID of the reservation (empty for create new)
* @param $options array of possibles options:
* - item reservation items ID for creation process
* - date date for creation process
**/
function showForm($ID, $options = []) {
global $CFG_GLPI;
if (!Session::haveRight("reservation", ReservationItem::RESERVEANITEM)) {
return false;
}
$resa = new self();
if (!empty($ID)) {
if (!$resa->getFromDB($ID)) {
return false;
}
if (!$resa->can($ID, UPDATE)) {
return false;
}
// Set item if not set
if ((!isset($options['item']) || (count($options['item']) == 0))
&& ($itemid = $resa->getField('reservationitems_id'))) {
$options['item'][$itemid] = $itemid;
}
} else {
$resa->getEmpty();
$resa->fields["begin"] = $options['begin'];
if (!isset($options['end'])) {
$resa->fields["end"] = date("Y-m-d H:00:00",
strtotime($resa->fields["begin"])+HOUR_TIMESTAMP);
} else {
$resa->fields["end"] = $options['end'];
}
}
// No item : problem
if (!isset($options['item']) || (count($options['item']) == 0)) {
return false;
}
echo "\n";
}
/**
* compute periodicities for reservation
*
* @since 0.84
*
* @param $begin begin of the initial reservation
* @param $end begin of the initial reservation
* @param $options array periodicity parameters : must contain : type (day/week/month), end
**/
static function computePeriodicities ($begin, $end, $options = []) {
$toadd = [];
if (isset($options['type']) && isset($options['end'])) {
$begin_time = strtotime($begin);
$end_time = strtotime($end);
$repeat_end = strtotime($options['end'].' 23:59:59');
switch ($options['type']) {
case 'day' :
$begin_time = strtotime("+1 day", $begin_time);
$end_time = strtotime("+1 day", $end_time);
while ($begin_time < $repeat_end) {
$toadd[date('Y-m-d H:i:s', $begin_time)] = date('Y-m-d H:i:s', $end_time);
$begin_time = strtotime("+1 day", $begin_time);
$end_time = strtotime("+1 day", $end_time);
}
break;
case 'week' :
$dates = [];
// No days set add 1 week
if (!isset($options['days'])) {
$dates = [['begin' => strtotime('+1 week', $begin_time),
'end' => strtotime('+1 week', $end_time)]];
} else {
if (is_array($options['days'])) {
$begin_hour = $begin_time- strtotime(date('Y-m-d', $begin_time));
$end_hour = $end_time - strtotime(date('Y-m-d', $end_time));
foreach ($options['days'] as $day => $val) {
$dates[] = ['begin' => strtotime("next $day", $begin_time)+$begin_hour,
'end' => strtotime("next $day", $end_time)+$end_hour];
}
}
}
foreach ($dates as $key => $val) {
$begin_time = $val['begin'];
$end_time = $val['end'];
while ($begin_time < $repeat_end) {
$toadd[date('Y-m-d H:i:s', $begin_time)] = date('Y-m-d H:i:s', $end_time);
$begin_time = strtotime('+1 week', $begin_time);
$end_time = strtotime('+1 week', $end_time);
}
}
break;
case 'month' :
if (isset($options['subtype'])) {
switch ($options['subtype']) {
case 'date':
$i=1;
$calc_begin_time = strtotime("+$i month", $begin_time);
$calc_end_time = strtotime("+$i month", $end_time);
while ($calc_begin_time < $repeat_end) {
$toadd[date('Y-m-d H:i:s', $calc_begin_time)] = date('Y-m-d H:i:s',
$calc_end_time);
$i++;
$calc_begin_time = strtotime("+$i month", $begin_time);
$calc_end_time = strtotime("+$i month", $end_time);
}
break;
case 'day':
$dayofweek = date('l', $begin_time);
$i = 1;
$calc_begin_time = strtotime("+$i month", $begin_time);
$calc_end_time = strtotime("+$i month", $end_time);
$begin_hour = $begin_time- strtotime(date('Y-m-d', $begin_time));
$end_hour = $end_time - strtotime(date('Y-m-d', $end_time));
$calc_begin_time = strtotime("next $dayofweek", $calc_begin_time)
+ $begin_hour;
$calc_end_time = strtotime("next $dayofweek", $calc_end_time) + $end_hour;
while ($calc_begin_time < $repeat_end) {
$toadd[date('Y-m-d H:i:s', $calc_begin_time)] = date('Y-m-d H:i:s',
$calc_end_time);
$i++;
$calc_begin_time = strtotime("+$i month", $begin_time);
$calc_end_time = strtotime("+$i month", $end_time);
$calc_begin_time = strtotime("next $dayofweek", $calc_begin_time)
+ $begin_hour;
$calc_end_time = strtotime("next $dayofweek", $calc_end_time)
+ $end_hour;
}
break;
}
}
break;
}
}
return $toadd;
}
/**
* Display for reservation
*
* @param $ID ID a the reservation item (empty to show all)
* @param $date date to display
**/
static function displayReservationDay($ID, $date) {
global $DB;
if (!empty($ID)) {
self::displayReservationsForAnItem($ID, $date);
} else {
$debut = $date." 00:00:00";
$fin = $date." 23:59:59";
$iterator = $DB->request([
'SELECT' => 'glpi_reservationitems.id',
'DISTINCT' => true,
'FROM' => 'glpi_reservationitems',
'INNER JOIN' => [
'glpi_reservations' => [
'ON' => [
'glpi_reservationitems' => 'id',
'glpi_reservations' => 'reservationitems_id'
]
]
],
'WHERE' => [
'is_active' => 1,
'end' => ['>', $debut],
'begin' => ['<', $fin]
],
'ORDERBY' => 'begin'
]);
if (count($iterator)) {
$m = new ReservationItem();
while ($data = $iterator->next()) {
$m->getFromDB($data['id']);
if (!($item = getItemForItemtype($m->fields["itemtype"]))) {
continue;
}
if ($item->getFromDB($m->fields["items_id"])
&& Session::haveAccessToEntity($item->fields["entities_id"])) {
$typename = $item->getTypeName();
if ($m->fields["itemtype"] == 'Peripheral') {
if (isset($item->fields["peripheraltypes_id"])
&& ($item->fields["peripheraltypes_id"] != 0)) {
$typename = Dropdown::getDropdownName("glpi_peripheraltypes",
$item->fields["peripheraltypes_id"]);
}
}
list($annee,$mois,$jour) = explode("-", $date);
echo "
\n";
}
/**
* Display reservations for a user
*
* @param $ID ID a the user
**/
static function showForUser($ID) {
global $DB, $CFG_GLPI;
$resaID = 0;
if (!Session::haveRight("reservation", READ)) {
return false;
}
echo "
![](".$CFG_GLPI["root_doc"]."/pics/reservation.png)
![\"".__s('Previous').](".$CFG_GLPI["root_doc"]."/pics/left.png "\\"\".__s('Previous').\"\\"")
![\"".__s('Next').](".$CFG_GLPI["root_doc"]."/pics/right.png "\\"\".__s('Next').\"\\"")
![\"".](".$CFG_GLPI["root_doc"]."/pics/addresa.png "\\"\".__s('Reserve').\"\\"")