Update instructions

Panda Multi Resorts - 4.1.0 (Nov 14, 2016)

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

NEW FEATURES/IMPROVEMENTS

Fixed amount for discount (rooms and activities)

/common/db.sql
>> new column "discount_type" in the tables pm_rate and pm_activity_session:

ALTER TABLE pm_rate ADD discount_type varchar(10);
UPDATE pm_rate SET discount_type = 'rate' WHERE discount != '' AND discount > 0;
ALTER TABLE pm_activity_session ADD discount_type varchar(10);
UPDATE pm_activity_session SET discount_type = 'rate' WHERE discount != '' AND discount > 0;

/admin/includes/fn_form.php
/admin/modules/booking/rate/config.xml
/templates/default/models/booking.php
/templates/default/common/get_activity_sessions.php

Linked combobox fields to generate relative content

/common/lib.php
/admin/includes/fn_list.php
/admin/includes/fn_form.php
/admin/includes/Filter.class.php
/admin/includes/Field.class.php
/admin/includes/config.xsd
/admin/includes/inc_header_common.php
/admin/includes/inc_header_form.php

Rooms filtered after hotel selected in admin panel

/common/db.sql
>> new column "id_hotel" in tables pm_booking and pm_rate
(execute the 2 last queries (UPDATE) for each of your hotels, replace 1 with each ID):

ALTER TABLE pm_booking ADD id_hotel INT;
ALTER TABLE pm_rate ADD id_hotel INT;
UPDATE pm_booking SET id_hotel = 1 WHERE id_room IN(SELECT id FROM pm_room WHERE id_hotel = 1);
UPDATE pm_rate SET id_hotel = 1 WHERE id_room IN(SELECT id FROM pm_room WHERE id_hotel = 1);

/admin/modules/booking/booking/config.xml
/admin/modules/booking/rate/config.xml
/templates/default/models/booking.php
/templates/default/models/payment.php
/templates/default/models/hotel.php
/templates/default/common/get_hotels.php

Multi user selection in the admin panel

/common/db.sql
>> column "id_user" (int) becomes "users" (text) in tables pm_article, pm_hotel, pm_room, pm_rate, pm_service, pm_activity, pm_activity_session:

ALTER TABLE pm_article CHANGE id_user users TEXT;
ALTER TABLE pm_hotel CHANGE id_user users TEXT;
ALTER TABLE pm_room CHANGE id_user users TEXT;
ALTER TABLE pm_rate CHANGE id_user users TEXT;
ALTER TABLE pm_service CHANGE id_user users TEXT;
ALTER TABLE pm_activity CHANGE id_user users TEXT;
ALTER TABLE pm_activity_session CHANGE id_user users TEXT;

/admin/index.php
/admin/includes/lang.ini (USER)
/admin/includes/fn_form.php
/admin/modules/article/config.xml
/admin/modules/default/list.php
/admin/modules/default/form.php
/templates/default/models/article.php

Display of bookings if logged as hotel

/common/db.sql
>> new column "users" in the tables pm_booking:

ALTER TABLE pm_booking ADD users text;

/admin/index.php
/admin/modules/booking/booking/config.xml

New duration for activity (week) + translation

/common/db.sql
>> new entries in table pm_text (!replace with your translation and lang ids):

INSERT INTO pm_text (id, lang, name, value) VALUES
(138, 1, 'MINUTES', 'minute(s)'),
(138, 2, 'MINUTES', 'minute(s)'),
(138, 3, 'MINUTES', 'minute(s)'),
(139, 1, 'HOURS', 'heure(s)'),
(139, 2, 'HOURS', 'hour(s)'),
(139, 3, 'HOURS', 'hour(s)'),
(140, 1, 'DAYS', 'jour(s)'),
(140, 2, 'DAYS', 'day(s)'),
(140, 3, 'DAYS', 'day(s)'),
(141, 1, 'WEEKS', 'semaine(s)'),
(141, 2, 'WEEKS', 'week(s)'),
(141, 3, 'WEEKS', 'week(s)');
UPDATE pm_activity SET duration_unit = 'hours' WHERE duration_unit = 'hour(s)';
UPDATE pm_activity SET duration_unit = 'minutes' WHERE duration_unit = 'minute(s)';
UPDATE pm_activity SET duration_unit = 'days' WHERE duration_unit = 'day(s)';

/admin/modules/booking/activity/config.xml
/templates/default/models/activity.php
/templates/default/models/booking-activities.php

Search engine crawler

/common/db.sql
>> new entries in table pm_text (!replace with your translation and lang ids):

INSERT INTO pm_text (id, lang, name, value) VALUES
(142, 1, 'RESULTS', 'Résultats'),
(142, 2, 'RESULTS', 'Results'),
(142, 3, 'RESULTS', 'Results');

/common/lib.php
/includes/pdftotext/
/templates/default/models/search.php

FIXED ISSUES

Wrong restriction on a non-required field (contact > email)

/admin/settings.php

Combobox layout

/templates/default/css/main.css (select.form-control)

Booking results order

/templates/default/models/booking.php