Update instructions

Panda Resort - 7.0.0 (Dec 5, 2018)

Replace the following files and execute the queries in your SQL manager to perform the updates.

NEW FEATURES/IMPROVEMENTS

New column type in the admin listing (case)

/admin/includes/config.xsd
/admin/includes/Column.class.php
/admin/includes/fn_list.php

Possibility to add custom navigation and script in each module

/admin/modules/default/list.php
/admin/modules/default/form.php

Booking auto completion

/common/db.sql
>> New columns ex_tax, paid and balance in the table pm_booking:

ALTER TABLE pm_booking
ADD ex_tax FLOAT NULL AFTER total,
ADD paid FLOAT NULL AFTER down_payment,
ADD balance FLOAT NULL AFTER paid,
ADD tax_amount FLOAT NULL AFTER balance;

>> New columns ex_tax and tax_rate in the tables pm_booking_room, pm_booking_service and pm_booking_activity:

ALTER TABLE pm_booking_room
ADD ex_tax double DEFAULT 0 AFTER amount,
ADD tax_rate double DEFAULT 0 AFTER ex_tax;
ALTER TABLE pm_booking_activity
ADD ex_tax double DEFAULT 0 AFTER amount,
ADD tax_rate double DEFAULT 0 AFTER ex_tax;
ALTER TABLE pm_booking_service
ADD ex_tax double DEFAULT 0 AFTER amount,
ADD tax_rate double DEFAULT 0 AFTER ex_tax;

>> New table pm_booking_payment:

-- ========== CREATION OF THE TABLE pm_booking_payment ==========

CREATE TABLE pm_booking_payment(
    id int NOT NULL AUTO_INCREMENT,
    id_booking int NOT NULL,
    descr varchar(100),
    method varchar(100),
    amount double DEFAULT 0,
    trans varchar(100),
    PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE pm_booking_payment ADD CONSTRAINT booking_payment_fkey FOREIGN KEY (id_booking) REFERENCES pm_booking(id) ON UPDATE NO ACTION ON DELETE CASCADE;

>> New payment options reference:

UPDATE pm_booking SET payment_method = 'arrival' WHERE payment_method = 'On arrival';
UPDATE pm_booking SET payment_method = 'check' WHERE payment_method = 'Check';
UPDATE pm_booking SET payment_method = 'paypal' WHERE payment_method = 'PayPal';
UPDATE pm_booking SET payment_method = 'card' WHERE payment_method = 'Credit card (2Checkout.com)';

>> Column payment_method renamed:

ALTER TABLE pm_booking CHANGE payment_method payment_option varchar(50);

/templates/default/models/booking.php
/templates/default/models/booking-activities.php
/templates/default/models/details.php
/templates/default/models/summary.php
/templates/default/models/payment.php
/templates/default/common/functions.php
/templates/default/common/get_days.php
/templates/default/common/get_days_activity.php
/templates/default/common/get_activity_sessions.php
/templates/default/common/update_booking.php
/templates/default/common/booking-popup.php
/templates/default/common/cancel_booking.php
/includes/payments/2checkout_notify.php
/includes/payments/paypal_notify.php
/admin/modules/booking/booking/config.xml
/admin/includes/langs/*
/admin/settings.php

New service price types

/templates/default/models/details.php
/templates/default/common/update_booking.php
/admin/modules/booking/service/config.xml

Booking overview panel

/admin/modules/booking/booking/*
/admin/modules/default/list.php
/admin/modules/default/form.php
/admin/includes/langs/*
/admin/css/layout.css
/admin/css/print.css
/admin/css/pms.css
/common/js/custom.js
/common/lib.php
/common/db.sql
>> New table pm_room_closing

-- ============ CREATION OF THE TABLE pm_room_closing ============

CREATE TABLE pm_room_closing(
    id int NOT NULL AUTO_INCREMENT,
    id_room int NOT NULL,
    from_date int,
    to_date int,
    stock int DEFAULT 0,
    PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE pm_room_closing ADD CONSTRAINT room_closing_fkey FOREIGN KEY (id_room) REFERENCES pm_room(id) ON DELETE CASCADE ON UPDATE NO ACTION;

Possibility to block several periods per room

/templates/default/models/booking.php
/templates/default/common/functions.php
/templates/default/common/get_days.php
/admin/includes/langs/*
>> New entry CLOSING_DATES
/admin/modules/booking/room/config.xml

Filling fields with GET values

/admin/modules/default/form.php

Numeric value restriction

/admin/includes/inc_header_form.php

FIXED ISSUES

Bug on extra tables for multilingual modules

/admin/includes/fn_form.php