QloApps Tours and Packages

QloApps Tours and Packages is an addon that will unlock a whole new dimension of hotel business for the admin.

The admin will be able to sell tours and packages from his website and not just hotels.

Tours and Packages option is on a hotel booking website is always one of the USP for that website.

People prefer booking tours instead of making all the bookings separately due for many reasons. It saves them time, money and is very convenient.

Users do not have to get into the trouble of arranging everything. And that is why they more attracted to the websites that offer tours and packages.

For the hotel websites to offering tours and packages is very fruitful. They help the admin to fill out the inventory quickly, also earn some extra revenue on the services offered in the package.

So let us now check what are the features of this addon and how it works.

• A totally separate interface for the tours and package
• Attractive and elegant design to display packages
• Responsive to different screen size
• Customer make the search for location and date
• User can filter the search results on the basis of package duration
• The customer can filter search results on the basis of the package price
• User can filter search results on the basis of package theme
• Customer can filter search results on the basis of package activity
• User can filter the search result for the location
• Search results show the offer tags for the packages that have a discount in them
• Customer can check the full itinerary of the tour
• Customer can add the room types to the packages as per their choice
• Book or Enquire about the package
• Book the whole package from a single cart

• Admin can create packages of any duration
• Admin can create as many packages as wants
• Decide if a user can book the packages or he can only enquire about it
• Three kinds of package pricing
  • Fixed package price
  • Price per person
  • Price per room
• Decide child age for no charges
• Offer a discount on the minimum number of persons or rooms
• Admin can define his Terms and Policies
• Admin can decide which room type will be offered in the package of a particular hotel
• The Admin can create the whole itinerary
• Admin can add admin activities in the package
• Add transport facility in the package
• Admin can Add special events in the package
• Admin can Add nearby attractions to the package
• Select the theme for the package
• Manage all the inquiries from the customer
• Decide the limit of rooms a user can purchase in a package
• Decide the max occupancy that can be added in a package
• Limit number of adult and children per room

Before you install QloApps Tours and Packages addon you must make few changes in the core for the proper functioning of the module.

The step is very simple, you just have to locate the following paths and replace the mention codes.

Open hotelcommerce folder –> modules–> hotelreservationsystem then open the hotelreservationsystem.php file.

Now go to the line number 362 and replace the following code:

$orderProducts = $order->getProducts();

replace this code from the following code.

$orderProducts = $order->product_list;

Open hotelcommerce folder –> modules–> hotelreservationsystem–> classes then open the HotelBookingDetail.php file.

The change the code from line no 348 to 350

$sql = 'SELECT ri.`id` AS `id_room`, ri.`id_product`, ri.`id_hotel`, ri.`room_num`, ri.`comment` AS `room_comment`
        FROM `'._DB_PREFIX_.'htl_room_information` AS ri
        WHERE ri.`id_hotel`='.(int)$hotel_id.' AND ri.`id_product`='.(int)$room_type['id_product'].' AND ri.`id_status` != 2 AND ri.`id` NOT IN ('.$exclude_ids.')';

will be replace by

$selectAvailRoomSearch = 'SELECT ri.`id` AS `id_room`, ri.`id_product`, ri.`id_hotel`, ri.`room_num`, ri.`comment` AS `room_comment`';

$joinAvailRoomSearch = '';

$whereAvailRoomSearch = 'WHERE ri.`id_hotel`='.(int)$hotel_id.' AND ri.`id_product`='.(int)$room_type['id_product'].' AND ri.`id_status` != 2 AND ri.`id` NOT IN ('.$exclude_ids.')';

$groupByAvailRoomSearch = '';
$orderByAvailRoomSearch = '';
$orderWayAvailRoomSearch = '';

Hook::exec('actionAvailRoomSearchSqlModifier',
    array(
        'select' => &$selectAvailRoomSearch,
        'join' => &$joinAvailRoomSearch,
        'where' => &$whereAvailRoomSearch,
        'group_by' => &$groupByAvailRoomSearch,
        'order_by' => &$orderByAvailRoomSearch,
        'order_way' => &$orderWayAvailRoomSearch,
        'params' => array(
            'id_hotel' => $hotel_id,
            'id_product' => $room_type['id_product'],
            'date_from' => $date_from,
            'date_to' => $date_to
        )
    )
);

$sql = $selectAvailRoomSearch;
$sql .= ' FROM `'._DB_PREFIX_.'htl_room_information` AS ri';
$sql .= ' '.$joinAvailRoomSearch;
$sql .= ' '.$whereAvailRoomSearch;
$sql .= ' '.$groupByAvailRoomSearch;
$sql .= ' '.$orderByAvailRoomSearch;
$sql .= ' '.$orderWayAvailRoomSearch;

Open hotelcommerce folder –> modules–> hotelreservationsystem–> classes then open the HotelCartBookingData.php file.

Paste the following code under “if condition” of line number 815 to 974.

if ($roomDetail = $objRoomType->;getRoomTypeInfoByIdProduct($product['id_product'])) {
	//place code from line no. 815 to 974 under this condition
}

Open hotelcommerce folder –> themes–> hotel-reservation-theme–> js–> modules –> blockcart then open the ajax_cart.js file.

Paste the following code under “if condition” of line number 813 to 822.

if (cart_booking_data[key].date_diff !== 'undefined') {
	// Place code from line no. 815 to 974 under the below if condition
}

Place code from line no. 849 to 858 under the below if condition https://prnt.sc/w5dyzq

if (cart_booking_data[key].date_diff !== 'undefined') {
	// Place code from line no. 815 to 974 under the below if condition
}

The installation of any module is very simple in QloApps.

• Go to the Module and Services tab
• Click on Add New Module

• Now upload the Zip file of Module and click on Install

Now You Have Installed The Module. So Let Us Check The Module Configuration.

The configuration of this addon is very simple. As the module is installed we will have a tab in our menu bar by the name of manage packages.

Now first let us check how we create activities, transport facilities, special events, nearby attractions, themes, and inclusions for the packages.

Then we will check how to create a package and use the above mention features in the package.

This section will help you add the activities which you can offer in a package.

Just go to the Manage Package tab and select Package Activities.

Now you can add or edit Package Activities.

Now when you click on Add New Facility the following page will appear which has three tabs for configuration.

Here you have to enter the basic information about the Activity.

Here you have to select what is included in the activity and what is not.

In this tab, you will be able to Add Activity images

This option will allow you to create all the transportation facilities you offer in your packages so that you can choose which transport facility you want to offer in which package.

Just go to the Manage Package tab and select Package Transport Facility.

When you click on the Add New transport facility you will have the following page with three tabs.

Enter the basic information of Transport Facility

Here you have to select what is included in the Transport Facility and what is not.

Here you can create and manage specials events that can be included in a package.

When you click on the Add New the following page will appear.

Enter the basic info of Special Events.

Here you have to select what is included in the Special Events and what is not.

Upload the images here.

With the help of this option, you will be able to add nearby attractions that can be added to a package.

Here to create a nearby attraction you just have to enter some basic information and upload the images.

Here you can create the Inclusions that can be added to a package.

Just go to Manage Package and select Package Inclusion.

Click on Add new Inclusion to create one.

Themes define a package. They tell us what kind of package it is. So here we can create themes and then select a theme in a package.

Just click on Add new theme to create one, then you will have the following page.

Here you can upload the header image of the Tours and Packages landing page.

Once you have created all the required options for a package, now you can actually create a package.

Just click on Manage Package Tab and you will land on the following page.

Click on Add New Package to create a package.

The process of creating a package is divided into multiple tabs. Let us understand each tab in detail.

In this tab, you will have to fill out the basic details of the package.

This tab will allow you to manage the pricing of the package.

You can price the package on three bases.

1. Fixed Price: Select a fixed price of the package and sell it at that price.
2. Price per person: Enter per adult price and age of child below which the child will not be charged. The cost of the package will be calculated as per the number of people added to the package by the user.
3. Room wise price: The cost of the package will be calculated as per the number of rooms added to the package by the user.

In this tab, you can offer a discount on dynamic prices. So if you are using per person pricing then you can offer a discount on the basis of the number of people.

Ex: If 10 people are included in a booking then offer a 10% discount.

The same can be done for room wise pricing.

In this tab, you can list down all the services that are included and are excluded from the package.

In this tab, you can define all the terms and policies of the package. You can define the Payment Policy, Cancellation Policy, Documents, and Terms & Conditions.

In this tab, you will be able to add all the locations available in the packages along with the hotels and room types included in this package.

In this tab, you can define the itinerary of the whole tour. You will have to define each day’s curriculum.

Once you land on this page you will see the list of the day-wise itinerary.

Now to create a day’s itinerary just click on Add New and fill out the following details.

Information: Here you will have to fill out the basic info of the day.

Select Activity: Select the activity on that day.

Events: Select the events scheduled on that day.

Transport Facility: Select the transport facility offered on that day.

Images: Upload up to 4 images for that day’s itinerary.

Select the nearby attractions for that day’s location

Here you can add all the inclusion that are there in the package along with their images.

Just click on Add new Inclusion, write its title, and upload the image.

In this tab, you can add the theme of the tour. You will have to write the name of the theme and upload its icon and cover image.

Here you will have to upload all the images that you want to show in the package.

You can enter the available quality of this package.

In this tab, you have the option to decide the maximum occupancy that this package can accommodate.

• You can limit the number of rooms that can be added in this package.
• Limit the number of adults and children in this package
• Limit the number of adults and childer allowed per room in this package.

To book the tours the user will have to click on the Tour and Packages button on your website homepage.

Once the user clicks on the Tours and Packages button then he will land on the Tours and Packages landing page.

Now once the user searches for a package on the basis of location and date then he is directed to the package search result page.

The user now clicks on View Details in order to proceed to book a process.

In the itinerary section, the user has the option to customize the room types he wants to book in the package.

The user can also customize the transport facility offered in the package.

Now the user can either Book the package or Enquire about the package.

To book a package the user will have to click on Book Now as shown in the above screenshots.

Once the user clicks on Book Now the system will ask him to add rooms in the package and select occupancy in each room.

The user cannot add more rooms than the limit selected by the admin. And he cannot add more occupancy than the limit set by the admin.

Once you click on submit you will have the details of your booking and then you will have to click on Proceed to Checkout.

Once you click on Proceed to Checkout then you will be directed to QloApps default checkout page where you can make the payment book the package.

When a user clicks on Submit Query a form opens up where the user to enter his details and queries and submit them for the admin to take action.

Once the user submits a query it will be raised at the backend for the admin to take action.

The admin can check Package Enquiries in the Manage Package tab –> Package Enquiries.

Then he will see the list of inquiries submitted by the users. He can click on it to check the details.

Once the admin clicks on View, he can view the details submitted by the user and then change the status of the query.

So this was all from QloApps Tours and Packages. Hope I was able to explain the module to you.

If you want to learn about the functionality of QloApps then you can visit this link: QLO Reservation System – Free Open-Source Hotel Booking & Reservation System

In case of any query, issue, or requirement please feel free to raise it on QloApps Forum