a booking reservation More...

Collaboration diagram for ilBookingReservation:

Public Member Functions
	__construct ($a_id=null)
	Constructor. More...

	getId ()
	Get id. More...

	setObjectId ($a_object_id)
	Set object id. More...

	getObjectId ()
	Get object id. More...

	setUserId ($a_user_id)
	Set booking user id. More...

	getUserId ()
	Get booking user id. More...

	setAssignerId ($a_assigner_id)
	Set assigner user id. More...

	getAssignerId ()
	Get assigner user id. More...

	setFrom ($a_from)
	Set booking from date. More...

	getFrom ()
	Get booking from date. More...

	setTo ($a_to)
	Set booking to date. More...

	getTo ()
	Get booking to date. More...

	setStatus ($a_status)
	Set booking status. More...

	getStatus ()
	Get booking status. More...

	setGroupId ($a_group_id)
	Set group id. More...

	getGroupId ()
	Get group id. More...

	save ()
	Create new entry in db. More...

	update ()
	Update entry in db. More...

	delete ()
	Delete single entry. More...

	getCalendarEntry ()

Static Public Member Functions
static	isValidStatus ($a_status)
	Check if given status is valid. More...

static	getNewGroupId ()
	Get next group id. More...

static	getAvailableObject (array $a_ids, $a_from, $a_to, $a_return_single=true, $a_return_counter=false)
	Check if any of given objects are bookable. More...

static	isObjectAvailableInPeriod ($a_obj_id, ilBookingSchedule $a_schedule, $a_from, $a_to)

static	isBookingPoolLimitReachedByUser (int $a_user_id, int $a_pool_id)

static	getMembersWithoutReservation (int $a_object_id)

static	isObjectAvailableNoSchedule ($a_obj_id)

static	numAvailableFromObjectNoSchedule ($a_obj_id)

static	getNumAvailablesNoSchedule ($a_obj_id)

static	getCurrentOrUpcomingReservation ($a_object_id)
	Get details about object reservation. More...

static	getObjectReservationForUser ($a_object_id, $a_user_id, $a_multi=false)

static	getList ($a_object_ids, $a_limit=10, $a_offset=0, array $filter)
	List all reservations. More...

static	getListByDate ( $a_has_schedule, array $a_object_ids=null, array $filter=null, array $a_pool_ids=null)
	List all reservations by date. More...

static	getUserFilter (array $a_object_ids)
	Get all users who have reservations for object(s) More...

static	changeStatus (array $a_ids, $a_status)
	List all reservations. More...

static	getCancelDetails ($a_obj_id, $a_user_id, $a_from, $a_to)
	Get reservation ids from aggregated id for cancellation. More...

Data Fields
const	STATUS_IN_USE = 2

const	STATUS_CANCELLED = 5

Protected Member Functions
	read ()
	Get dataset from db. More...

Protected Attributes
	$db

	$id

	$object_id

	$user_id

	$from

	$to

	$status

	$group_id

	$assigner_id

Detailed Description

a booking reservation

Author: Jörg Lützenkirchen luetz.nosp@m.enki.nosp@m.rchen.nosp@m.@lei.nosp@m.fos.c.nosp@m.om

Version: $Id$

Definition at line 12 of file class.ilBookingReservation.php.

Constructor & Destructor Documentation

◆ __construct()

ilBookingReservation::__construct ( $a_id = null )

Constructor.

if id is given will read dataset from db

Parameters

int $a_id

Definition at line 38 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $this->db = $DIC->database();
        $this->id = (int) $a_id;
        $this->read();
    }

References $DIC, and read().

Here is the call graph for this function:

Member Function Documentation

◆ changeStatus()

static ilBookingReservation::changeStatus	(	array	$a_ids,
			$a_status
	)

static

List all reservations.

Parameters

array	$a_object_ids
int	$a_limit
int	$a_offset
array	$filter
array	$a_group_id

Returns: array Batch update reservation status

Parameters

array	$a_ids
int	$a_status

Returns: bool

Definition at line 1062 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        if (self::isValidStatus($a_status)) {
            return $ilDB->manipulate('UPDATE booking_reservation' .
                ' SET status = ' . $ilDB->quote($a_status, 'integer') .
                ' WHERE ' . $ilDB->in('booking_reservation_id', $a_ids, '', 'integer'));
        }
    }

References $DIC, and $ilDB.

Referenced by ilObjBookingPoolGUI\changeStatusObject().

Here is the caller graph for this function:

◆ delete()

ilBookingReservation::delete ( )

Delete single entry.

Returns: bool

Definition at line 285 of file class.ilBookingReservation.php.

    {
        $ilDB = $this->db;
 
        if ($this->id) {
            return $ilDB->manipulate('DELETE FROM booking_reservation' .
                ' WHERE booking_reservation_id = ' . $ilDB->quote($this->id, 'integer'));
        }
    }

References $db, and $ilDB.

◆ getAssignerId()

ilBookingReservation::getAssignerId ( )

Get assigner user id.

Returns: int

Definition at line 105 of file class.ilBookingReservation.php.

    {
        return $this->assigner_id;
    }

References $assigner_id.

◆ getAvailableObject()

static ilBookingReservation::getAvailableObject	(	array	$a_ids,
			$a_from,
			$a_to,
			$a_return_single = `true`,
			$a_return_counter = `false`
	)

static

Check if any of given objects are bookable.

Parameters

array	$a_ids
int	$a_from
int	$a_to
int	$a_return_single

Returns: int

Definition at line 316 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        $nr_map = ilBookingObject::getNrOfItemsForObjects($a_ids);
        
        $from = $ilDB->quote($a_from, 'integer');
        $to = $ilDB->quote($a_to, 'integer');
        
        $set = $ilDB->query('SELECT count(*) cnt, object_id' .
            ' FROM booking_reservation' .
            ' WHERE ' . $ilDB->in('object_id', $a_ids, '', 'integer') .
            ' AND (status IS NULL OR status <> ' . $ilDB->quote(self::STATUS_CANCELLED, 'integer') . ')' .
            ' AND ((date_from <= ' . $from . ' AND date_to >= ' . $from . ')' .
            ' OR (date_from <= ' . $to . ' AND date_to >= ' . $to . ')' .
            ' OR (date_from >= ' . $from . ' AND date_to <= ' . $to . '))' .
            ' GROUP BY object_id');
        $blocked = $counter = array();
        while ($row = $ilDB->fetchAssoc($set)) {
            if ($row['cnt'] >= $nr_map[$row['object_id']]) {
                $blocked[] = $row['object_id'];
            } elseif ($a_return_counter) {
                $counter[$row['object_id']] = (int) $nr_map[$row['object_id']] - (int) $row['cnt'];
            }
        }
        
        // #17868 - validate against schedule availability
        foreach ($a_ids as $obj_id) {
            $bobj = new ilBookingObject($obj_id);
            if ($bobj->getScheduleId()) {
                include_once "Modules/BookingManager/classes/class.ilBookingSchedule.php";
                $schedule = new ilBookingSchedule($bobj->getScheduleId());
 
                $av_from = ($schedule->getAvailabilityFrom() && !$schedule->getAvailabilityFrom()->isNull())
                    ? $schedule->getAvailabilityFrom()->get(IL_CAL_UNIX)
                    : null;
                $av_to = ($schedule->getAvailabilityTo() && !$schedule->getAvailabilityTo()->isNull())
                    ? strtotime($schedule->getAvailabilityTo()->get(IL_CAL_DATE) . " 23:59:59")
                    : null;
                
                if (($av_from && $a_from < $av_from) ||
                    ($av_to && $a_to > $av_to)) {
                    $blocked[] = $obj_id;
                    unset($counter[$obj_id]);
                }
            }
        }
        
        $available = array_diff($a_ids, $blocked);
        if (sizeof($available)) {
            if ($a_return_counter) {
                foreach ($a_ids as $id) {
                    if (!isset($counter[$id])) {
                        $counter[$id] = (int) $nr_map[$id];
                    }
                }
                return $counter;
            } elseif ($a_return_single) {
                return array_shift($available);
            } else {
                return $available;
            }
        }
    }

References $DIC, $from, $id, $ilDB, $row, $to, ilBookingObject\getNrOfItemsForObjects(), IL_CAL_DATE, and IL_CAL_UNIX.

Referenced by ilObjBookingPoolGUI\buildDatesBySchedule(), ilObjBookingPoolGUI\confirmedBookingNumbersObject(), and ilObjBookingPoolGUI\confirmedBookingObject().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getCalendarEntry()

ilBookingReservation::getCalendarEntry ( )

Definition at line 1075 of file class.ilBookingReservation.php.

    {
        $ilDB = $this->db;
        
        include_once 'Services/Calendar/classes/class.ilCalendarCategory.php';
        
        $set = $ilDB->query("SELECT ce.cal_id FROM cal_entries ce" .
            " JOIN cal_cat_assignments cca ON ce.cal_id = cca.cal_id" .
            " JOIN cal_categories cc ON cca.cat_id = cc.cat_id" .
            " JOIN booking_reservation br ON ce.context_id  = br.booking_reservation_id" .
            " WHERE cc.obj_id = " . $ilDB->quote($this->getUserId(), 'integer') .
            " AND br.user_id = " . $ilDB->quote($this->getUserId(), 'integer') .
            " AND cc.type = " . $ilDB->quote(ilCalendarCategory::TYPE_BOOK, 'integer') .
            " AND ce.context_id = " . $ilDB->quote($this->getId(), 'integer'));
        $row = $ilDB->fetchAssoc($set);
        return $row["cal_id"];
    }

References $db, $ilDB, $row, and ilCalendarCategory\TYPE_BOOK.

◆ getCancelDetails()

static ilBookingReservation::getCancelDetails	(	$a_obj_id,
		$a_user_id,
		$a_from,
		$a_to
	)

static

Get reservation ids from aggregated id for cancellation.

Parameters

int	$a_obj_id
int	$a_user_id
int	$a_from
int	$a_to

Returns: array

Definition at line 1102 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        $res = array();
        
        $sql = "SELECT booking_reservation_id" .
            " FROM booking_reservation" .
            " WHERE object_id = " . $ilDB->quote($a_obj_id, "integer") .
            " AND user_id = " . $ilDB->quote($a_user_id, "integer") .
            " AND date_from = " . $ilDB->quote($a_from, "integer") .
            " AND date_to = " . $ilDB->quote($a_to, "integer") .
            " AND (status IS NULL" .
            " OR status <> " . $ilDB->quote(self::STATUS_CANCELLED, "integer") . ")";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[] = $row["booking_reservation_id"];
        }
        
        return $res;
    }

References $DIC, $ilDB, $res, and $row.

Referenced by ilObjBookingPoolGUI\rsvConfirmCancelObject(), and ilObjBookingPoolGUI\rsvConfirmDeleteObject().

Here is the caller graph for this function:

◆ getCurrentOrUpcomingReservation()

static ilBookingReservation::getCurrentOrUpcomingReservation ( $a_object_id )

static

Get details about object reservation.

Parameters

int $a_object_id

Returns: array

Definition at line 548 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $now = $ilDB->quote(time(), 'integer');
 
        $ilDB->setLimit(1);
        $set = $ilDB->query('SELECT user_id, status, date_from, date_to' .
            ' FROM booking_reservation' .
            ' WHERE ((date_from <= ' . $now . ' AND date_to >= ' . $now . ')' .
            ' OR date_from > ' . $now . ')' .
            ' AND (status <> ' . $ilDB->quote(self::STATUS_CANCELLED, 'integer') .
            ' OR STATUS IS NULL) AND object_id = ' . $ilDB->quote($a_object_id, 'integer') .
            ' ORDER BY date_from');
        $row = $ilDB->fetchAssoc($set);
        return $row;
    }

References $DIC, $ilDB, and $row.

◆ getFrom()

ilBookingReservation::getFrom ( )

Get booking from date.

Returns: int

Definition at line 123 of file class.ilBookingReservation.php.

    {
        return $this->from;
    }

References $from.

◆ getGroupId()

ilBookingReservation::getGroupId ( )

Get group id.

Returns: int

Definition at line 195 of file class.ilBookingReservation.php.

    {
        return $this->group_id;
    }

References $group_id.

◆ getId()

ilBookingReservation::getId ( )

Get id.

Returns: int

Definition at line 51 of file class.ilBookingReservation.php.

    {
        return $this->id;
    }

References $id.

◆ getList()

static ilBookingReservation::getList	(		$a_object_ids,
			$a_limit = `10`,
			$a_offset = `0`,
		array	$filter
	)

static

List all reservations.

Parameters

array	$a_object_ids
int	$a_limit
int	$a_offset
array	$a_offset

Returns: array

Definition at line 599 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $sql = 'SELECT r.*,o.title' .
            ' FROM booking_reservation r' .
            ' JOIN booking_object o ON (o.booking_object_id = r.object_id)';
 
        $count_sql = 'SELECT COUNT(*) AS counter' .
            ' FROM booking_reservation r' .
            ' JOIN booking_object o ON (o.booking_object_id = r.object_id)';
        
        $where = array($ilDB->in('r.object_id', $a_object_ids, '', 'integer'));
        if ($filter['status']) {
            if ($filter['status'] > 0) {
                $where[] = 'status = ' . $ilDB->quote($filter['status'], 'integer');
            } else {
                $where[] = '(status != ' . $ilDB->quote(-$filter['status'], 'integer') .
                    ' OR status IS NULL)';
            }
        }
        if ($filter['from']) {
            $where[] = 'date_from >= ' . $ilDB->quote($filter['from'], 'integer');
        }
        if ($filter['to']) {
            $where[] = 'date_to <= ' . $ilDB->quote($filter['to'], 'integer');
        }
        if (sizeof($where)) {
            $sql .= ' WHERE ' . implode(' AND ', $where);
            $count_sql .= ' WHERE ' . implode(' AND ', $where);
        }
 
        $set = $ilDB->query($count_sql);
        $row = $ilDB->fetchAssoc($set);
        $counter = $row['counter'];
 
        $sql .= ' ORDER BY date_from DESC, booking_reservation_id DESC';
        
        $ilDB->setLimit($a_limit, $a_offset);
        $set = $ilDB->query($sql);
        $res = array();
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[] = $row;
        }
 
        return array('data' => $res, 'counter' => $counter);
    }

References $DIC, $ilDB, $res, and $row.

Referenced by ilBookingObjectsTableGUI\getItems().

Here is the caller graph for this function:

◆ getListByDate()

static ilBookingReservation::getListByDate	(		$a_has_schedule,
		array	$a_object_ids = `null`,
		array	$filter = `null`,
		array	$a_pool_ids = `null`
	)

static

List all reservations by date.

Parameters

bool	$a_has_schedule	has schedule
array	$a_object_ids	object ids
array	$filter	filter
array	$a_pool_ids	pool ids

Returns: array

Definition at line 657 of file class.ilBookingReservation.php.

      {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        $res = array();
        
        $sql = 'SELECT r.*, o.title, o.pool_id' .
            ' FROM booking_reservation r' .
            ' JOIN booking_object o ON (o.booking_object_id = r.object_id)';
 
        if ($a_pool_ids !== null) {
            $where = array($ilDB->in('pool_id', $a_pool_ids, '', 'integer'));
        }
 
        if ($a_object_ids !== null) {
            $where = array($ilDB->in('object_id', $a_object_ids, '', 'integer'));
        }
 
        if ($filter['status']) {
            if ($filter['status'] > 0) {
                $where[] = 'status = ' . $ilDB->quote($filter['status'], 'integer');
            } else {
                $where[] = '(status != ' . $ilDB->quote(-$filter['status'], 'integer') .
                    ' OR status IS NULL)';
            }
        }
        if ($filter['title']) {
            $where[] = '(' . $ilDB->like('title', 'text', '%' . $filter['title'] . '%') .
                ' OR ' . $ilDB->like('description', 'text', '%' . $filter['title'] . '%') . ')';
        }
        if ($a_has_schedule) {
            if ($filter['from']) {
                $where[] = 'date_from >= ' . $ilDB->quote($filter['from'], 'integer');
            }
            if ($filter['to']) {
                $where[] = 'date_to <= ' . $ilDB->quote($filter['to'], 'integer');
            }
            if (!$filter['past']) {
                $where[] = 'date_to > ' . $ilDB->quote(time(), 'integer');
            }
        }
        if ($filter['user_id']) { // #16584
            $where[] = 'user_id = ' . $ilDB->quote($filter['user_id'], 'integer');
        }
        /*
        if($a_group_id)
        {
            $where[] = 'group_id = '.$ilDB->quote(substr($a_group_id, 1), 'integer');
        }
        */
        if (sizeof($where)) {
            $sql .= ' WHERE ' . implode(' AND ', $where);
        }
        
        if ($a_has_schedule) {
            $sql .= ' ORDER BY date_from DESC';
        } else {
            // #16155 - could be cancelled and re-booked
            $sql .= ' ORDER BY status';
        }
                
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $obj_id = $row["object_id"];
            $user_id = $row["user_id"];
                        
            if ($a_has_schedule) {
                $slot = $row["date_from"] . "_" . $row["date_to"];
                $idx = $obj_id . "_" . $user_id . "_" . $slot;
            } else {
                $idx = $obj_id . "_" . $user_id;
            }
            
            if ($a_has_schedule && $filter["slot"]) {
                $slot_idx = date("w", $row["date_from"]) . "_" . date("H:i", $row["date_from"]) .
                    "-" . date("H:i", $row["date_to"] + 1);
                if ($filter["slot"] != $slot_idx) {
                    continue;
                }
            }
            
            if (!isset($res[$idx])) {
                $uname = ilObjUser::_lookupName($user_id);
                
                $res[$idx] = array(
                    "object_id" => $obj_id
                    ,"title" => $row["title"]
                    ,"pool_id" => $row["pool_id"]
                    ,"user_id" => $user_id
                    ,"counter" => 1
                    ,"user_name" => $uname["lastname"] . ", " . $uname["firstname"] // #17862
                );
                
                if ($a_has_schedule) {
                    $res[$idx]["booking_reservation_id"] = $idx;
                    $res[$idx]["date"] = date("Y-m-d", $row["date_from"]);
                    $res[$idx]["slot"] = date("H:i", $row["date_from"]) . " - " .
                        date("H:i", $row["date_to"] + 1);
                    $res[$idx]["week"] = date("W", $row["date_from"]);
                    $res[$idx]["weekday"] = date("w", $row["date_from"]);
                    $res[$idx]["can_be_cancelled"] = ($row["status"] != self::STATUS_CANCELLED &&
                        $row["date_from"] > time());
                    $res[$idx]["_sortdate"] = $row["date_from"];
                } else {
                    $res[$idx]["booking_reservation_id"] = $row["booking_reservation_id"];
                    $res[$idx]["status"] = $row["status"];
                    $res[$idx]["can_be_cancelled"] = ($row["status"] != self::STATUS_CANCELLED);
                }
            } else {
                $res[$idx]["counter"]++;
            }
        }
        
        return $res;
    }

References $DIC, $ilDB, $res, $row, $user_id, ilObjUser\_lookupName(), and STATUS_CANCELLED.

Referenced by ilBookingReservationsTableGUI\getItems(), and ilBookCronNotification\sendNotifications().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getMembersWithoutReservation()

static ilBookingReservation::getMembersWithoutReservation ( int $a_object_id )

static

Definition at line 486 of file class.ilBookingReservation.php.

                                                                          : array
    {
        global $DIC;
        $ilDB = $DIC->database();
 
        $pool_id = ilBookingObject::lookupPoolId($a_object_id);
 
        $res = array();
        $query = 'SELECT DISTINCT bm.user_id user_id' .
            ' FROM booking_member bm' .
            ' WHERE bm.booking_pool_id = ' . $ilDB->quote($pool_id, 'integer') .
            ' AND bm.user_id NOT IN (' .
            'SELECT user_id' .
            ' FROM booking_reservation' .
            ' WHERE object_id = ' . $ilDB->quote($a_object_id, 'integer') .
            ' AND (status IS NULL OR status <> ' . ilBookingReservation::STATUS_CANCELLED . '))';
 
        $set = $ilDB->query($query);
 
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[] = $row['user_id'];
        }
 
        return $res;
    }

References $DIC, $ilDB, $query, $res, $row, ilBookingObject\lookupPoolId(), and STATUS_CANCELLED.

Referenced by ilBookingParticipant\getAssignableParticipants().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getNewGroupId()

static ilBookingReservation::getNewGroupId ( )

static

Get next group id.

Returns: int

Definition at line 299 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        return $ilDB->nextId('booking_reservation_group');
    }

References $DIC, and $ilDB.

Referenced by ilObjBookingPoolGUI\confirmedBookingObject().

Here is the caller graph for this function:

◆ getNumAvailablesNoSchedule()

static ilBookingReservation::getNumAvailablesNoSchedule ( $a_obj_id )

static

Definition at line 523 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
 
        $all = ilBookingObject::getNrOfItemsForObjects(array($a_obj_id));
        $all = (int) $all[$a_obj_id];
 
        $set = $ilDB->query('SELECT COUNT(*) cnt' .
            ' FROM booking_reservation r' .
            ' JOIN booking_object o ON (o.booking_object_id = r.object_id)' .
            ' WHERE (status IS NULL OR status <> ' . $ilDB->quote(self::STATUS_CANCELLED, 'integer') . ')' .
            ' AND r.object_id = ' . $ilDB->quote($a_obj_id, 'integer'));
        $cnt = $ilDB->fetchAssoc($set);
        $cnt = (int) $cnt['cnt'];
 
        return (int) $all - $cnt; // #11864
    }

References $DIC, $ilDB, and ilBookingObject\getNrOfItemsForObjects().

Referenced by isObjectAvailableNoSchedule(), and numAvailableFromObjectNoSchedule().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getObjectId()

ilBookingReservation::getObjectId ( )

Get object id.

Returns: int

Definition at line 69 of file class.ilBookingReservation.php.

    {
        return $this->object_id;
    }

References $object_id.

◆ getObjectReservationForUser()

static ilBookingReservation::getObjectReservationForUser	(	$a_object_id,
		$a_user_id,
		$a_multi = `false`
	)

static

Definition at line 568 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        $set = $ilDB->query('SELECT booking_reservation_id FROM booking_reservation' .
            ' WHERE user_id = ' . $ilDB->quote($a_user_id, 'integer') .
            ' AND object_id = ' . $ilDB->quote($a_object_id, 'integer') .
            ' AND (status <> ' . $ilDB->quote(self::STATUS_CANCELLED, 'integer') .
            ' OR STATUS IS NULL)');
        if (!$a_multi) {
            $row = $ilDB->fetchAssoc($set);
            return $row['booking_reservation_id'];
        } else {
            $res = array();
            while ($row = $ilDB->fetchAssoc($set)) {
                $res[] = $row['booking_reservation_id'];
            }
            return $res;
        }
    }

References $DIC, $ilDB, $res, and $row.

Referenced by ilObjBookingPoolGUI\confirmedBookingObject(), ilBookingObjectGUI\deliverPostFile(), ilBookingObjectGUI\displayPostInfo(), ilBookingAssignObjectsTableGUI\getItems(), ilBookingParticipant\isParticipantAssigned(), and ilBookingObjectGUI\rsvCancelUser().

Here is the caller graph for this function:

◆ getStatus()

ilBookingReservation::getStatus ( )

Get booking status.

Returns: int

Definition at line 164 of file class.ilBookingReservation.php.

    {
        return $this->status;
    }

References $status.

◆ getTo()

ilBookingReservation::getTo ( )

Get booking to date.

Returns: int

Definition at line 141 of file class.ilBookingReservation.php.

    {
        return $this->to;
    }

References $to.

◆ getUserFilter()

static ilBookingReservation::getUserFilter ( array $a_object_ids )

static

Get all users who have reservations for object(s)

Parameters

array $a_object_ids

Returns: array

Definition at line 785 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
        
        $res = array();
        
        $sql = "SELECT ud.usr_id,ud.lastname,ud.firstname,ud.login" .
            " FROM usr_data ud " .
            " LEFT JOIN booking_reservation r ON (r.user_id = ud.usr_id)" .
            " WHERE ud.usr_id <> " . $ilDB->quote(ANONYMOUS_USER_ID, "integer") .
            " AND " . $ilDB->in("r.object_id", $a_object_ids, "", "integer") .
            " ORDER BY ud.lastname,ud.firstname";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[$row["usr_id"]] = $row["lastname"] . ", " . $row["firstname"] .
                " (" . $row["login"] . ")";
        }
                
        return $res;
    }

References $DIC, $ilDB, $res, and $row.

Referenced by ilBookingReservationsTableGUI\initFilter().

Here is the caller graph for this function:

◆ getUserId()

ilBookingReservation::getUserId ( )

Get booking user id.

Returns: int

Definition at line 87 of file class.ilBookingReservation.php.

    {
        return $this->user_id;
    }

References $user_id.

◆ isBookingPoolLimitReachedByUser()

static ilBookingReservation::isBookingPoolLimitReachedByUser	(	int	$a_user_id,
		int	$a_pool_id
	)

static

Definition at line 468 of file class.ilBookingReservation.php.

                                                                                           : int
    {
        global $DIC;
        $ilDB = $DIC->database();
 
        $booking_pool_objects = ilBookingObject::getObjectsForPool($a_pool_id);
 
        $query = "SELECT count(user_id) total" .
            " FROM booking_reservation" .
            " WHERE " . $ilDB->in('object_id', $booking_pool_objects, false, 'integer') .
            " AND user_id = " . $a_user_id .
            " AND (status IS NULL OR status <> " . ilBookingReservation::STATUS_CANCELLED . ')';
        $res = $ilDB->query($query);
        $row = $res->fetchRow(ilDBConstants::FETCHMODE_ASSOC);
 
        return (int) $row['total'];
    }

References $DIC, $ilDB, $query, $res, $row, ilDBConstants\FETCHMODE_ASSOC, ilBookingObject\getObjectsForPool(), and STATUS_CANCELLED.

Referenced by ilBookingParticipant\getAssignableParticipants().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ isObjectAvailableInPeriod()

static ilBookingReservation::isObjectAvailableInPeriod	(		$a_obj_id,
		ilBookingSchedule	$a_schedule,
			$a_from,
			$a_to
	)

static

Definition at line 383 of file class.ilBookingReservation.php.

    {
        global $DIC;
 
        $ilDB = $DIC->database();
            
        if (!$a_from) {
            $a_from = time();
        }
        if (!$a_to) {
            $a_to = strtotime("+1year", $a_from);
        }
        
        if ($a_from > $a_to) {
            return;
        }
        
        $from = $ilDB->quote($a_from, 'integer');
        $to = $ilDB->quote($a_to, 'integer');
        
        // all bookings in period
        $now = time();
        $set = $ilDB->query('SELECT count(*) cnt' .
            ' FROM booking_reservation' .
            ' WHERE object_id = ' . $ilDB->quote($a_obj_id, 'integer') .
            ' AND (status IS NULL OR status <> ' . $ilDB->quote(self::STATUS_CANCELLED, 'integer') . ')' .
            ' AND date_to > ' . $now .
            ' AND ((date_from <= ' . $from . ' AND date_to >= ' . $from . ')' .
            ' OR (date_from <= ' . $to . ' AND date_to >= ' . $to . ')' .
            ' OR (date_from >= ' . $from . ' AND date_to <= ' . $to . '))');
        $row = $ilDB->fetchAssoc($set);
        $booked_in_period = $row["cnt"];
        
        $per_slot = ilBookingObject::getNrOfItemsForObjects(array($a_obj_id));
        $per_slot = $per_slot[$a_obj_id];
                
        // max available nr of items per (week)day
        $schedule_slots = array();
        $definition = $a_schedule->getDefinition();
        $map = array_flip(array("su", "mo", "tu", "we", "th", "fr", "sa"));
        foreach ($definition as $day => $day_slots) {
            $schedule_slots[$map[$day]] = $day_slots;
        }
        
        $av_from = ($a_schedule->getAvailabilityFrom() && !$a_schedule->getAvailabilityFrom()->isNull())
            ? $a_schedule->getAvailabilityFrom()->get(IL_CAL_UNIX)
            : null;
        $av_to = ($a_schedule->getAvailabilityTo() && !$a_schedule->getAvailabilityTo()->isNull())
            ? strtotime($a_schedule->getAvailabilityTo()->get(IL_CAL_DATE) . " 23:59:59")
            : null;
        
        // sum up max available items in period per (week)day
        $available_in_period = 0;
        $loop = 0;
        while ($a_from < $a_to &&
            ++$loop < 1000) {
            // any slots for current weekday?
            $day_slots = $schedule_slots[date("w", $a_from)];
            if ($day_slots) {
                foreach ($day_slots as $slot) {
                    // convert slot to current datetime
                    $slot = explode("-", $slot);
                    $slot_from = strtotime(date("Y-m-d", $a_from) . " " . $slot[0]);
                    $slot_to = strtotime(date("Y-m-d", $a_from) . " " . $slot[1]);
 
                    // slot has to be in the future and part of schedule availability
                    if ($slot_to > time() &&
                        $slot_from >= $av_from &&
                        $slot_to <= $av_to) {
                        $available_in_period += $per_slot;
                    }
                }
            }
            
            $a_from += (60 * 60 * 24);
        }
 
        if ($available_in_period - $booked_in_period > 0) {
            return true;
        }
 
        return false;
    }

References $DIC, $from, $ilDB, $map, $row, $to, ilBookingSchedule\getAvailabilityFrom(), ilBookingSchedule\getAvailabilityTo(), ilBookingSchedule\getDefinition(), ilBookingObject\getNrOfItemsForObjects(), IL_CAL_DATE, and IL_CAL_UNIX.

Referenced by ilBookingObjectsTableGUI\getItems().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ isObjectAvailableNoSchedule()

static ilBookingReservation::isObjectAvailableNoSchedule ( $a_obj_id )

static

Definition at line 512 of file class.ilBookingReservation.php.

    {
        $available = self::getNumAvailablesNoSchedule($a_obj_id);
        return (bool) $available; // #11864
    }

References getNumAvailablesNoSchedule().

Referenced by ilObjBookingPoolGUI\confirmedBookingObject().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ isValidStatus()

static ilBookingReservation::isValidStatus ( $a_status )

static

Check if given status is valid.

Parameters

int $a_status

Returns: bool

Definition at line 174 of file class.ilBookingReservation.php.

    {
        if (in_array($a_status, array(self::STATUS_IN_USE, self::STATUS_CANCELLED))) {
            return true;
        }
        return false;
    }

Referenced by setStatus().

Here is the caller graph for this function:

◆ numAvailableFromObjectNoSchedule()

static ilBookingReservation::numAvailableFromObjectNoSchedule ( $a_obj_id )

static

Definition at line 517 of file class.ilBookingReservation.php.

    {
        $available = self::getNumAvailablesNoSchedule($a_obj_id);
        return (int) $available;
    }

References getNumAvailablesNoSchedule().

Referenced by ilBookingAssignParticipantsTableGUI\__construct(), ilObjBookingPoolGUI\bookMultipleParticipantsObject(), and ilBookingAssignObjectsTableGUI\getItems().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ read()

ilBookingReservation::read ( )

protected

Get dataset from db.

Definition at line 203 of file class.ilBookingReservation.php.

    {
        $ilDB = $this->db;
        
        if ($this->id) {
            $set = $ilDB->query('SELECT *' .
                ' FROM booking_reservation' .
                ' WHERE booking_reservation_id = ' . $ilDB->quote($this->id, 'integer'));
            $row = $ilDB->fetchAssoc($set);
            $this->setUserId($row['user_id']);
            $this->setAssignerId($row['assigner_id']);
            $this->setObjectId($row['object_id']);
            $this->setFrom($row['date_from']);
            $this->setTo($row['date_to']);
            $this->setStatus($row['status']);
            $this->setGroupId($row['group_id']);
        }
    }

References $db, $ilDB, $row, setAssignerId(), setFrom(), setGroupId(), setObjectId(), setStatus(), setTo(), and setUserId().

Referenced by __construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ save()

ilBookingReservation::save ( )

Create new entry in db.

Returns: bool

Definition at line 226 of file class.ilBookingReservation.php.

    {
        $ilDB = $this->db;
 
        if ($this->id) {
            return false;
        }
 
        $this->id = $ilDB->nextId('booking_reservation');
        
        return $ilDB->manipulate('INSERT INTO booking_reservation' .
            ' (booking_reservation_id,user_id,assigner_id,object_id,date_from,date_to,status,group_id)' .
            ' VALUES (' . $ilDB->quote($this->id, 'integer') .
            ',' . $ilDB->quote($this->getUserId(), 'integer') .
            ',' . $ilDB->quote($this->getAssignerId(), 'integer') .
            ',' . $ilDB->quote($this->getObjectId(), 'integer') .
            ',' . $ilDB->quote($this->getFrom(), 'integer') .
            ',' . $ilDB->quote($this->getTo(), 'integer') .
            ',' . $ilDB->quote($this->getStatus(), 'integer') .
            ',' . $ilDB->quote($this->getGroupId(), 'integer') . ')');
    }

References $db, and $ilDB.

◆ setAssignerId()

ilBookingReservation::setAssignerId ( $a_assigner_id )

Set assigner user id.

Parameters

$a_assigner_id

Definition at line 96 of file class.ilBookingReservation.php.

    {
        $this->assigner_id = (int) $a_assigner_id;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setFrom()

ilBookingReservation::setFrom ( $a_from )

Set booking from date.

Parameters

int $a_from

Definition at line 114 of file class.ilBookingReservation.php.

    {
        $this->from = (int) $a_from;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setGroupId()

ilBookingReservation::setGroupId ( $a_group_id )

Set group id.

Parameters

int $a_group_id

Definition at line 186 of file class.ilBookingReservation.php.

    {
        $this->group_id = $a_group_id;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setObjectId()

ilBookingReservation::setObjectId ( $a_object_id )

Set object id.

Parameters

int $a_object_id

Definition at line 60 of file class.ilBookingReservation.php.

    {
        $this->object_id = $a_object_id;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setStatus()

ilBookingReservation::setStatus ( $a_status )

Set booking status.

Parameters

int $a_status

Definition at line 150 of file class.ilBookingReservation.php.

    {
        if ($a_status === null) {
            $this->status = null;
        }
        if ($this->isValidStatus((int) $a_status)) {
            $this->status = (int) $a_status;
        }
    }

References isValidStatus().

Referenced by read().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setTo()

ilBookingReservation::setTo ( $a_to )

Set booking to date.

Parameters

int $a_to

Definition at line 132 of file class.ilBookingReservation.php.

    {
        $this->to = (int) $a_to;
    }

Referenced by read().

Here is the caller graph for this function:

◆ setUserId()

ilBookingReservation::setUserId ( $a_user_id )

Set booking user id.

Parameters

int $a_user_id

Definition at line 78 of file class.ilBookingReservation.php.

    {
        $this->user_id = (int) $a_user_id;
    }

Referenced by read().

Here is the caller graph for this function:

◆ update()

ilBookingReservation::update ( )

Update entry in db.

Returns: bool

Definition at line 252 of file class.ilBookingReservation.php.

    {
        $ilDB = $this->db;
 
        if (!$this->id) {
            return false;
        }
 
        /* there can only be 1
        if($this->getStatus() == self::STATUS_IN_USE)
        {
            $ilDB->manipulate('UPDATE booking_reservation'.
            ' SET status = '.$ilDB->quote(NULL, 'integer').
            ' WHERE object_id = '.$ilDB->quote($this->getObjectId(), 'integer').
            ' AND status = '.$ilDB->quote(self::STATUS_IN_USE, 'integer'));
        }
        */
        
        return $ilDB->manipulate('UPDATE booking_reservation' .
            ' SET object_id = ' . $ilDB->quote($this->getObjectId(), 'text') .
            ', user_id = ' . $ilDB->quote($this->getUserId(), 'integer') .
            ', assigner_id = ' . $ilDB->quote($this->getAssignerId(), 'integer') .
            ', date_from = ' . $ilDB->quote($this->getFrom(), 'integer') .
            ', date_to = ' . $ilDB->quote($this->getTo(), 'integer') .
            ', status = ' . $ilDB->quote($this->getStatus(), 'integer') .
            ', group_id = ' . $ilDB->quote($this->getGroupId(), 'integer') .
            ' WHERE booking_reservation_id = ' . $ilDB->quote($this->id, 'integer'));
    }