Only one event at a time range

[ShulzR]

Hello,
I create new event entity ' Rooms Reservation'. Do you have any way to make it impossible to book one room at the same time?
Possibly any warning that there is a reservation in a certain period of time?

Regards,
Robert

[ShulzR]

https://www.espocrm.com/solutions/crm-for-hotel-and-hostel-management/

I see record: "Monitor the availability of rooms & services"
Somone can help?

[eymen-elkum]

You may need to have custom duplicate checker class, follow this doc:

https://docs.espocrm.com/development/duplicate-check/

[Enju]

Has anyone managed to write such a class? I'm looking for a solution too.

[rabii]

There is no such a class, you just need to add your own logic. there are many ways to achieve this depend on your business logic.

[yuri]

You can also utilize API before save script.

[yuri]

API Before Save script:

$message = "An event on the same time slot already exists.";

if (entity\isNew() && assignedUserId) {
    $existingId = record\findOne(
        'Event',
        null,
        null,
        'assignedUserId=', assignedUserId,
        'dateEnd>', dateEnd,
        'dateStart<', dateEnd
    );
    
    
    if ($existingId) {
        recordService\throwConflict($message);  
    }
    
    $existingId = record\findOne(
        'Event',
        null,
        null,
        'assignedUserId=', assignedUserId,
        'dateEnd>', dateStart,
        'dateStart<', dateStart
    );
    
    
    if ($existingId) {
        recordService\throwConflict($message);  
    }
    
    $existingId = record\findOne(
        'Event',
        null,
        null,
        'assignedUserId=', assignedUserId,
        'dateEnd<=', dateEnd,
        'dateStart>=', dateStart
    );
    
    
    if ($existingId) {
        recordService\throwConflict($message);  
    }
}
​

Where 'Event' should be your entity type.

[Enju]

Thank you Yuri, it work's perfect!