FiveTech Support Forums

"The significant problems we face cannot be solved at the same level of thinking we were at when we created them" -Albert Einstein

James Bott wrote:Silvio,

As you have found, your current method is not going to help. Think outside the box.

What would a reservation clerk at an expensive hotel do? What would they try first, and next, and after that, just trying to find a solution for the customer? Make a list in order of best probable outcomes. Then post your list here.

Yep, "Outside the box Bott" they used to call me...

"The significant problems we face cannot be solved at the same level of thinking we were at when we created them" -Albert Einstein

any help please

practically now it seems that I do a search of the free rooms excluding the reservation concerned, how resolve ?

If ROOM_ID = cROOM_ID
   oReservations:skip()
endif

james,

This is not good, because there are many bookings in the archive and the strsso room_id could have many bookings with different periods, and excluding the room_id you would risk making a mes

if, for example, I have two reservations of the same number, one from 08/07/2021 to 28/07/2021 and the other reservation from 29/07/2021 to 29/07/2021 and I exclude the room_id number as you say, the procedure he does not see the second reservation and after that he will assign for example a day that belongs to the other reservation

Silvio,

I was only showing how to exclude a room number. You still have to check the dates.

nageswaragunupudi wrote:No need to open oSearchDB again. We can check with the main database object itself like this.

Code (fw): Select all Collapse

cSearch := oReserva:ApplyParams( "ROOM_ID == ? .AND. ALLTRIM(TYPE) == ? .AND. RECNO() != ? .AND. (CHECK_IN > ? .OR. CHECK_OUT < ? )", ;
            { cCamera, ALLTRIM( cTypeRoom ), oReserva:RecNo(), dCheckOut, dCheckIn } )

if oReserva:LookUp( cSearch, nil, { || .T. } ) == .T.
   ? "room is available"
else
   ? "room is not availble"
endif

there is already a reservation in the archive
Room_ID 6
TYpE 01
from 07/29/2021 to 07/29/2021

if I go to do a search and I am in modification it tells me that it is busy because it finds that reservation of the day 29/07

ok

if instead I would like from 08/07/2021 to 27/07/2021
it tells me that it is busy because in the search it would find the reservation that is being edited

James Bott wrote:Silvio,

there is already a reservation in the archive
Room_ID 6
TYpE 01
from 07/29/2021 to 07/29/2021

if I go to do a search and I am in modification it tells me that it is busy because it finds that reservation of the day 29/07

ok

if instead I would like from 08/07/2021 to 27/07/2021
it tells me that it is busy because in the search it would find the reservation that is being edited

All you really want to know is the date 29/07/21 available for that "room." That will show as free. Then you add that date to the existing reservation (i.e. change the end date of the existing reservation).

If that date is not available for that room, then look to see what other rooms are available. Then you could offer one of them as an alternative for that last day. You could also look for the entire range of dates being available for another room.

This is what I was referring earlier, when I said to think like a hotel reservation person. That is what they would do--look for alternative options if the original requested date & room is not available.

[For others reading this thread, the term "room" is really refering to "beach site." This is because the original reservation software was for rooms.]

now James do you understand?

if I change the date and insert from 08/07/2021 to 27/07/2021 I am going to modify a reservation only for one day.

when I check if there is already a reservation for that period it tells me that it already exists
but why does it tell me that it exists?

James Bott wrote:Silvio,

now James do you understand?

Yes, I understand perfectly. But apparently you still do not understand what I am saying.

if I change the date and insert from 08/07/2021 to 27/07/2021 I am going to modify a reservation only for one day.

when I check if there is already a reservation for that period it tells me that it already exists
but why does it tell me that it exists?

It tells you that BECAUSE the original reservation does still exist. It is doing exactly what it is supposed to do (but not what you need).

You don't need to search for the entire NEW reservation. All you need to find out is if the new day is available, so you search for the new day only. If it is, then you change the length of the original reservation to include the new day. Simple.

If they want add 2 days (or more) then you search for availability of the new days only. If those two days are available then you change the check_out day to the last day of the addon period (two days in this case). Done.

I'm sorry but I still can't understand maybe with a small example

I have from 08/07/2021 to 28/07/2021

1) we have already seen that if I increase by one day ie dlast = 29/07/2021 there is already a reservation so it tells me that it is busy.

I understand that. You don't need to search for the entire new reservation. You only need to know if 29/07/2021 is free, you already know the other dates 08/07/21 - 27/07/2021 are not free becuase that is the current reservation. But that doesn't matter. So you just search for 29/07/2021 to 29/07/2021. If that is free then you just change the check_out date of the current reservation to 29/07/2021.

2) Now I change dlast = 27/07/2021 that is one day less - so I call the search function

What do I have to look for ? What do I have to look for ? you say only that day that is the 27/07/2021?

Search_Element(cCamera,27/07/2021,27/07/2021,cTypeRoom) return me occupated from the same record I am editing

how do i exclude the current record from the search?

Assumption: All dates are in date format

// Current reservation
nRoom:= 10
oReservation:check_in:= 08/07/2021
oReservation:check_out:= 28/02/2021

To add a day (29/07/2021) to the end of the reservation:

nRoom:= 10          // beach site of existing reservation
dDate:= 29/07/2021  // date to add
If isFree(nRoom, dDate)
   oReservation:check_out := dDate
   oReservation:save()
endif

To subtract n days from the end of an existing reservation:
No searching is required since you are freeing up days not booking new days

// No search is required
oReservation:check_out := ( oReservation:check_out - nDays )
oReservation:save()

To subtract n days from the beginning of an existing reservation:

// No search required
oReservation:check_in := ( oReservation:check_in + nDays)
oReservation:save()