Hotel & Booking Reservation Ecommerce system on Prestashop

Added Features:

• #264: Added SECURITY.md file.
• #313: Update for module upgrade and suggestion

Improvements:

• Core

  • #240: Updated TCPDF library
  • #242: Changes for PHP7 compatibility
  • #243: Removed pclzip library
  • #244: Removed pear JSON lib instead use PHP JSON library
  • #245: Updated swift mailer
  • #246: Updated htmlpurifier
  • #247: Updated Smarty library
  • #249: Updated Sql Parser Library
  • #250: Updated Pear and Archive tar library
  • #267: Removed mysql support, pdomysql now required
  • #269: Replaced mcrypt with openssl
  • #272: Changed default DB prefix to qlo_
  • #276: Paypal and PaypalUSA module removed
  • #290: Updated path for including css and js in modules | Moved plugins to core js folder
  • #299: Added composer.json file

• Front Office:

  • #296: Improved Social Sharing module
  • #316: Display Room Capacity on room type detail page

• Back Office

  • #297: Changed import button icon on Localization page
  • #310: Dashboard improvement
  • #327: Resolved QloApps dashboard issues

Bug Fixed:

• Core:

  • #238: Update date format in invoice according to format provided in language
  • #253: Using room status as constants instead in values
  • #270: Using room availability status as constants instead in values
  • #273: Fixed date format for additional facilities in invoice
  • #281: Resolved smarty html comments issue.
  • #283: Invalid value inserted in 'special_days' field in htl_room_type_feature_pricing table through API
  • #284: Resolved: No validation for the fields in 'hotel_refund_rules' API for add and update.
  • #285: Resolved: No validation for the fields in 'hotel_features' API for add and update
  • #286: Validations added for 'password' and 'email' fields for the 'employees' API.
  • #287: Resolved fatal error while generating class index file
  • #288: Resolved: No validation for field 'id_parent in' in 'categories' API.
  • #289: Validations added to the fields of "bookings" API for POST / PUT API requests
  • #307: Cart and Order API Issues resolved
  • #312: Text issues solved
  • #321: Fixed QloApps installation issues
  • #324: Resolved compatibility issue with php5.6

• Back Office:

  • #255: Fixed filter by Due amount results in "Bad SQL query"
  • #259: Fixed room reallocation availability list for temporary unavailable rooms
  • #256: Fixed Swap rooms leads to reservations duplications
  • #251: Removed unused options from images controller
  • #271: Fixed syntax issue in admin information cont
  • #275: Resolve order total update issue on additional facilities update
  • #282: Order refund states 'Refunded' and 'Denied' should not enabled together from render list
  • #293: Add profile access restriction when adding room types
  • #294: Resolve order edit issues, Added hooks in order edit process
  • #303: In 'Manage Hotel' Controller, validation added for 'check-out time must be before check in'
  • #304, #315: Text change.
  • #318: Resolve multiple rooms addition issue on AdminOrdersController
  • #320: Resolved new room features automatically mapping to all the room types

• Front Office:

  • #252: Update function getRoomBookingData
  • #268: Update blockrss module
  • #277: In _DB_PREFIX__orders table column advance_paid_amount value is wrong
  • #280: Wrong amount displayed in Order confirmation page in the payment gateways PaymentReturn Hook
  • #291: Resolved: Wrong price return by advance payment functions in HotelAdvancedPayment class
  • #295: Resolve DNI field issue during guest checkout
  • #298, #274: QloApps text changes
  • #300: Room amenities name shown with feature icon in room type details page
  • #301: Unused CSS file htl-reservation-general.css and its classes are removed
  • #302: Resolved: On translating page checking and checkout dates are changed to NaN-NaN-NaN
  • #305: Resolve tab design issue on room type detail page
  • #317: Resolve jQZoom issue on room type detail page
  • #319: Resolved smarty minify HTML issue

Added Features:

• Core:
  • #208: "Catalog Mode" option added by which user can view room details but not able to create the bookings

Improvements:

• Back Office:

  • #206: Removed Other Modules setting from admin Hotel Reservation System -> Settings
  • #200: Removed shipping option from car rule condition.
  • #199: Removed "Display suppliers and manufacturers" and "Display best sellers" options from Admin Preferences controller
  • #193: Removed Payment Modules setting from admin Hotel Reservation System -> Settings
  • #189: Moved hotel selection from the configuration tab to the information tab
  • #179: Added hotel column in room type feature pricing list
  • #177: Removed multishop option
  • #149: Removed carrier column from Booking Carts Controller
  • #183: Added hotel name along with room name when adding the filter of room type for cart rule
  • #204, #196, #182: Text Changes
  • #110, #111: Code Optimization

• Core:

  • #223: getHotelCartBookingData() : function multiplication optimized
  • #225: HotelRoomTypeFeaturePricing.php optimized (Removed unused variables, removed static values assigned)
  • #218: Added hotel name column in order confirmation mail and invoice.
  • #210: CMS page Delivery is not valid for hotel industry. So changed it to Policies page
  • #205: Prevent deleting profile which is used by at least one employee
  • #214: blockcart module :: Removed unused hooks displayLeftColumn and displayrightColumn
  • #180: license file name changed from LICENSES to LICENSE
  • #181: Readme file improvements with more information and links
  • #221: dataforfrontsearch() function now calculate and provide "feature_price_diff" value in response
  • #175: Changed QloApps versioning system (Ex: X.X.X.X)
  • #175: Updated module compatibility check with QloApps version
  • #215: "hotelreservationsystem.php" code optimization in hook "actionValidateOrder"
  • #117, #118, #119, #120, #121, #122, #134, #137, #138, #139: Changes for PHP7 compatibility
  • #178: Text Changes
  • #198, #226: Multiple hooks are added in the different QloApps core files
  • #217: auto_generated column in address table added to track address creation source
  • #207: New order states 'Partial payment accepted' and 'Awaiting partial payment' added for the partial payment

• Front Office:

  • #222: Disabled mobile keyboard pop up when using date-picker in home search
  • #208: Room type listing on search result page moved to different template "room_type_listing.tpl"
  • #185: Replaced star rating plugin with jquery Raty in Product Comments module
  • #156: "product.js" code multiplication optimized
  • #215: "ajax-cart.js" add validation
  • #125, #127, #141, #142: Changes for PHP7 compatibility
  • #187: Display voucher name along with voucher code on order page

Bug Fixed:

• Back Office:

  • #211: Errors on cart rule page when adding room type, which is not assigned to the hotel, selected in room type condition
  • #197: wrong theme information is displayed at Preferences -> Themes admin controller
  • #195: Filter by position in the render lists of admin controllers
  • #194: Entering the wrong discount while Group creation, page redirects to list page
  • #192: Using the filter in the customer Group list, the page redirects to the previous list
  • #189: Room Type associations with its hotel parent category
  • #176: Birthday input field width in Helper Form
  • #173: Undefined variable issue Manage Order Refund Request Controller
  • #171: Multiple requests on a single click in Helper List
  • #160: "Access Denied" issue when an employee other than super admin creates a new room.
  • #168: Room number not updating after room reallocation and swap
  • #162: Additional facility price changes for room type after saving
  • #147: Creating order status without entering "status name", page redirects to a blank page
  • #148: Creating order refund status without entering "status name", page redirects to list page
  • #229: Resolved undefined variable error in Manage Order Refund Request Controller

• Front Office:

  • #212: Design issue of select in the ADDITIONAL FACILITIES if the text exceeds from the block in the product detail page
  • #209: Errors on the search result page: If a new group is created and only this group is assigned to the customer
  • #203: Guest is unable to submit Refund Request again after entering invalid Refund Reason once
  • #158: Hotel selection in search panel for mobile devices
  • #169: The wrong price displayed when booking from 1 March to 30 March
  • #151: Room search check-in && check-out don't change when the friendly URL is disabled.

• Core:

  • #186: Links in the mail for my-account, guest tracking and my orders pages are now localized to customer language.
  • #109: updated invalid variable "pshone_mobile" to "phone_mobile"
  • #202: In "global.css" added a missing class for aligning images left and right in room type description

Added Features:

[+] CO : QloApps APIs are created (Prestashop APIs are modified as per hotel QloApps changes) [+] CO : is_advance_payment column is added in the 'cart' table. [+] CO : is_advance_payment, advance_paid_amount columns are added in the 'orders' table. [+] CO : id_transaction, payment_mode, refunded_amount, by_admin columns are added in the 'order_return' table. [+] CO : id_order_return_detail, id_htl_booking, refunded_amount columns are added in the 'order_return_detail' table. [+] CO : send_email_to_customer, send_email_to_superadmin, send_email_to_employee, send_email_to_hotelier, denied,refunded,module_namecolumns are added in the 'order_return_state' table. [+] CO :customer_template,admin_templatecolumns are added in the 'order_return_state_lang' table. [+] CO :id_htl_booking` column is added in the 'order_slip_detail' table. [+] CO : Refund emails will be sent to the customer as per return state setting [+] CO : All images link are now generated dynamically [+] FO : Room type refund policies in the policies tab is shown in the room type details page. [+] FO : A controller will be there for the customer which will show his refund requests info [+] BO : Admin can enable/disable refund for the hotel [+] BO : Refund Process:: Order return statuses improved for order refund statuses. [+] BO : Admin can select rules for the hotel [checkboxes] [+] BO : Admin can initiate refund if the refund is enabled for the system [+] BO : Admin can select which state is considered as refunded completely in the return state. [+] BO : Admin can select which state is considered as refunded denied in the return state. [+] BO : Admin can select which email will be sent to the customer and admin for the return state. [+] BO : Feature Price Rule: Groups wise Condition in feature price rules is added. [+] BO : Global refund policies cms page can be selected from the refund rules controller. [+] BO : Refund can be enabled/disabled globally from the refund rules controller. [+] BO : Payment mode and transaction id can be saved for the refund. [+] BO : Voucher slip can be generated for refund. [+] BO : Credit slip can be generated for refund. [+] BO : Additional facilities can be edited at the time of order editing. [+] BO : Room type features images are used as jpg images in place of png images.

Improved/changed features:

[*] BO : Refund Process:: Order return statuses improved for order refund statuses. [*] BO : In Additional Facilities list no price will be shown if the facility has advance options. [*] BO : Admin will be able to select a checkout date while changing the status of the room from the order details page. [*] BO : Hotel category will be selected Default room type category. [*] BO : In room type render list hotel(instead of category), city, number rooms, adults, Childs columns added. [*] BO : Merchandise Return tab is removed. [*] BO : Room type ids now start room type id from 1 in room type render list. [*] BO : Prestashop warning pop up will not be shown during module installation for Webkul modules. [*] BO : Updated addons link from store to addon's page [*] BO : Added recommended image size for room type images for appropriate view on the front end. [*] FO : Calendar Design is improved of date from and date to in QloApps. [*] FO : 'Proceed' button during checkout will be disabled in case of errors while checkout. [*] FO : Search panel is improved on all pages. [*] FO : Cart warning text changed [*] FO : Refund request process is improved for the customer. Designed is also improved. [*] CO : PayPal adaptive module (by Webkul) Removed completely from QloApps. [*] CO : All the irrelevant data creation from the installation process is removed Which is not related to Qloapps but Prestashop. e.g carriers, stores, suppliers, manufacturers...... etc. Order data will not be populated now. [*] CO : For refund request "order_return" and "order_return_detail" tables are used. [*] CO : For order, refund states "order_return_states" table is used.

Bug/Issues Resolved:

[-] BO : FIXED: The room does not free even after room status set to checkout. [-] BO : FIXED: The room does not free while order status is changed to Refunded, Cancelled or Payment Error. [-] BO : FIXED: Additional facilities price id not managed while deleting a booking from the admin order details page. [-] FO : FIXED: when using advance payment option, discount voucher (amount) gets applied to the advance payment amount along with the total order cost [-] FO : FIXED: If all rows are disabled then also blocks (Interior, Rooms, Features, Testimonials) are visible on the home page. [-] FO : FIXED: Zipcode error while making the guest check. [-] FO : FIXED: Issue while creating a customer/guest from the checkout page on the firefox browser. [-] FO : FIXED: Check-out date same as check-in date when current data is more than max order date for hotel [-] FO : FIXED: customer able to process booking for inactive rooms [-] FO : FIXED: Image stretch issue on the product page. [-] FO : FIXED: Cart page does not update when deleting from cart dropdown [-] FO : FIXED: While making the guest check out the system shows zip code error in some countries. [-] CO : FIXED: Fatal error: Uncaught exception 'ImagickException' while creating an invoice. [-] CO : FIXED: warning while creating invoice (total demands variable issue)

Added Features:

[+] BO: Hotel wise employee permission management is added. now admin can permit his employees according to the specific hotel selections [+] BO: Additional facility: functionality is added at backoffice order creation process also. [+] BO: Additional facility: Tax can be applied to additional facilities. [+] BO: Additional facility: Per day price calculation option is added.[Price will be calculated on per day basis of the booking or for the entire date range of the booking] [+] BO: Order Confirmation Email: Now admin can set to whom order confirmation email will be sent from Preferences -> orders tab. [+] CO : displayNavigationBottomHook hook added "hotelcommerce/modules/blockuserinfo/nav-xs.tpl".

Improved/changed features:

[*] FO: Address details on the order details page is changed. Only details (name, email and mobile number) will be shown which we are showing to the customer at the checkout page [*] FO: Address will not be shown to the customer while checkout process. edit link also removed from "Guest Information" section at the checkout page. [*] BO: Option to delete one room in two default created rows in while saving rooms of the room type. [*] BO: unit price fields removed from backoffice room type creation page. [*] CO: blocknavigationmenu: Navigation menu improved. All links are dynamic now. [*] CO: wkfooterexploreblock module is removed. All functionalities are merged with blocknavigationmenu module. [*] CO: hotel wise order split. A new order will be created for each hotel. [*] CO: Trademark and powered by changed to Webkul (from PrestaShop). [*] CO: Correct single quotes and double quotes of Class HotelBookingDetail.php [*] CO: Installed Paypal module by PrestaShop by default while QloApps installation. [*] CO: Translations are improved.

Bug/Issues Resolved:

[-] BO: Resolved: Room does not free even after room status set to checkout. [-] BO: Resolved: Infinite loop on Room type page while loading Booking Information tab. [-] BO: Resolved: Book now page showing error when the current date is the last date of the month. [-] BO: Resolved: Image is not showing while feature update (Catalog->features) and issue while updating feature. [-] CO: Resolved: As theme name was "hotel-theme". So on saving theme translations a new theme directory "hotel-theme" is created and translations are saved in this directory. now "hotel-theme" is replaced with "hotel-reservation-theme". [-] CO: Resolved: Feature price plans not working. [ Create two plans one for Sunday and other for Saturday. At the moment it's only showing the change/increase on Saturdays, not Sundays. If I unable Saturdays it is showing the price change on Sundays and not Saturdays. [-] CO: Resolved: Order status is 'Payment Error' if payment is done by advance payment with real payment gateways. [-] FO: Resolved: blockcart and blocknavigationmenu modules swap randomly at displayTop hook. [-] FO: Resolved: Disable dates of last room will be saved for all previous rooms while saving rooms of a room type. [-] FO: Resolved: Rooms are not visible when changing the minimum price in the filter by price. [-] FO: Resolved: Null quantity issue when check-in date and check-out dates are the same. When the date_from and the date_to passed in the URL parameter are identical they are accepted in the entries (Check-In Date & Check-out Date) on the room type detail page. Once we click on Book now pop up with "Null quantity" message appears.

New feature:

• Additional facilities functionality is added.

Improvement:

• Tools::generateHtaccess() improved
• ($round = true) parameter added in Tools::convertPriceFull()
• Localization updated
• mails/en/product_download.txt bug resolved
• swiftMailer version updated to 5.2.2
• translations updated
• config/config.inc.php improved (smarty early inclusion)
• config/smarty.config.inc.php improved (smartyHook() return improved)
• Security: Use Mcrypt’s CBC mode instead of the ECB mode.
• All Stats Module compatible with QloApps
• Room type details Page Design improved

Bug fix:

• QloApps Compatible with MySQL 5.7

Added Features:

[+] CO : pscleaner module is added for cleaning demo data from QloApps. [+] FO : Option for Guest checkout is given at Preferences->Orders tab. So Guest Checkout is enabled. [+] FO : Option for Shorter registration/address form is given at Preferences->Customers tab. (In this case address will be created from customer chosen room type's hotel address automatically). [+] CO : wkfooterexploreblock :: Admin can add custom explore links to show at footer explore block and navigation menu also. table 'htl_custom_explore_link' added with multilang.

Improved/changed features:

[-] BO : New category option from "quick access" links is removed. [+] FO : Checkout page design has been changed. [+] CO : Images validation improved.

Bug/Issues Resolved:

[-] CO : 56% Installation issue. [-] BO : Dashboard graphs not loading issues on php 7.2 [-] BO : feature update issue on not selecting image while updating the feature. [-] BO : Category bug resolve (Should not be created updated deleted from anywhere). Will be handled from hotel creation/updation/deletion.