Forum Replies Created
August 3, 2018 at 2:55 am in reply to: Query takes a lot of time : STHotel->get_unavailability_hotel() #246620
More details about Caller :
Before waiting for your update, I mean which line of that query should edit/delete/ignore to escape slow mode.
I have to start my project nowadays!!
Thanks for understanding.
I used Query Monitor plugin to find where functions run slowly, and that plugin shows me below query takes 38s this TIME more than usual.
SELECT ID, hotel_id, count(hotel_id) as total_room
SELECT ID, wp_postmeta.meta_value as adult_number, st_meta1.meta_value as children_number, st_meta3.meta_value as number_room, st_meta2.meta_value as hotel_id
FROM wp_posts JOIN wp_postmeta on wp_postmeta.post_id=wp_posts.ID and wp_postmeta.meta_key=’adult_number’ JOIN wp_postmeta as st_meta1 on st_meta1.post_id=wp_posts.ID and st_meta1.meta_key=’children_number’ JOIN wp_postmeta as st_meta3 on st_meta3.post_id=wp_posts.ID and st_meta3.meta_key=’number_room’JOIN wp_postmeta as st_meta2 on st_meta2.post_id=wp_posts.ID and st_meta2.meta_key=’room_parent’ where 1=1
AND wp_posts.ID IN (
SELECT room_id from(
SELECT room_id, sum(room_num_search) AS total_booked, room.number_room
INNER JOIN wp_hotel_room AS room
ON room.post_id = wp_st_order_item_meta.room_id
WHERE 1 = 1
AND ( ( check_in_timestamp <= 1530230400
AND check_out_timestamp >= 1530230400 )
OR ( check_in_timestamp >= 1530230400
AND check_in_timestamp <= 1530316800 ) )
AND st_booking_post_type = ‘st_hotel’
AND STATUS NOT IN ( ‘trash’, ‘canceled’, ‘wc-cancelled’ )
GROUP BY room_id Having room.number_room – total_booked < 1 ) as booked_table )
OR wp_posts.ID IN (
WHERE 1 = 1
AND ( check_in >= 1530230400
AND check_out <= 1530316800
status= ‘unavailable’ ) )
OR wp_postmeta.meta_value < 1
OR st_meta3.meta_value < 1
GROUP BY wp_posts.ID ) as room_data
GROUP BY hotel_id
HAVING total_room >= (
WHERE meta_key = ‘room_parent’
AND meta_value = hotel_id )
Do YOU explain to me how to solve that?
The problem comes when I press search button for hotels on the tab on the front page.
PLS be Noted:
I am using your hotel’s demo (images, details etc.).
When pressing one of the Top Destinations it is work very well (shows me the results in 4s).
I did increase to 50GB SSD.
I hope to find an answer from you.
I know how to manage commission. But, I want to see and print invoices that contain commission amount.
Please, Tell me where can find it.
In relation between Partner and admin:
Am looking for all invoices were written inside it amount of commission for admin.
where can find commission invoices for all booking ??
After confirm booking from guest and approval from hotel, we need to let system send to the guest (status : confirmed).
I would like to know Which time(status) the room will be unavailable for other guests?
and Which time(status) the room will be ready for new booking?
I appreciate your effort, but I ask about features not included in Traveler WP. I know it is from hotel management system (PMS) such as:
• View all of room reservations on a calendar page.
• Check guests in and out.
• Add extra sale items (breakfast, internet service, laundry, etc.).
• Move existing bookings around.
• Add any payment from guests and Print invoices.
I hope from you to let me know if Traveler WP has any integration with a plugin to manage those features.
I hope these steps will explain:
1. After guest booking at Hotel, Traveler WP send hotel booking details to partner account. (This stage done)
2. Every Partner account can able to send booking details to Hotel management system OR property management system by using plugin WP.
3. We need that to let every partner manage other operations not included in Traveler WP. Such as, check in – check out – add other services – add payments invoices – print invoices to guests
Thanks for this question,
I have same query.March 6, 2018 at 5:10 pm in reply to: ( traveler settings > other options ) all fields can not change ?? #144280
Thanks A LOT
its working …March 6, 2018 at 4:20 am in reply to: ( traveler settings > other options ) all fields can not change ?? #143420
the issues Automatically comes again.
i found : Sorry! Payment Gateway: Submit Form is not available for this item!
back to asking help.March 6, 2018 at 4:05 am in reply to: ( traveler settings > other options ) all fields can not change ?? #143410
I did reinstall demo and it was solved that issues.
but in case i need to know why that fields can not change ? And how to solve it manually.