Update instructions

Panda Resort - 7.6.0 (Feb 5, 2020)

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

NEW FEATURES/IMPROVEMENTS

New iCal synchronization

/common/db.sql
>> New tables "pm_room_calendar" and "pm_ical_event":

-- =========== CREATION OF THE TABLE pm_room_calendar ============

CREATE TABLE pm_room_calendar(
    id int NOT NULL AUTO_INCREMENT,
    id_room int NOT NULL,
    title varchar(150),
    latest_sync int,
    url text,
    PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

-- ============ CREATION OF THE TABLE pm_ical_event ==============

CREATE TABLE pm_ical_event(
    id int NOT NULL AUTO_INCREMENT,
    id_room int NOT NULL,
    title varchar(150),
    sync_date int,
    from_date int,
    to_date int,
    PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

/common/config(-tmp).php
>> new entries:

define('ENABLE_ICAL', '1');
define('ENABLE_AUTO_ICAL_SYNC', '1');
define('ICAL_SYNC_INTERVAL', 'daily'); // daily | hourly
define('ICAL_SYNC_CLOCK', '3'); // 0-23h mode, required if ICAL_SYNC_INTERVAL = daily

/admin/includes/langs/*.ini
>> new entries:

EXTERNAL_ICAL_CALENDARS="External iCal calendars"
LATEST_SYNC="Latest synchronization"
SYNC_ALL_CALENDARS="Synchronize all calendars"
NUM_IMPORTED_EVENTS="Num. of imported events:"
ICAL_SYNCHRONIZATION="iCal Synchronization"
CALENDAR_URL="Calendar URL"
COPY="Copy"
COPY_TO_CLIPBOARD="Copy to Clipboard"
COPIED="copied!"
DOWNLOAD_CALENDAR="Download calendar"
EXTERNAL_BOOKING="External_booking"
ENABLE_ICAL_SYNC="Enable iCal synchronization"
ENABLE_AUTO_ICAL_SYNC="Enable automatic iCal sync"
ICAL_SYNC_INTERVAL="Synchronization interval"
ICAL_SYNC_CLOCK="Synchronization clock"

/admin/settings.php
/admin/modules/default/list.php
/admin/modules/booking/room/config.xml
/admin/modules/booking/room/custom_nav.php
/admin/modules/booking/room/custom_form.php
/admin/modules/booking/booking/availabilities.php
/admin/css/pms.css
/includes/icalendar/
/templates/default/common/get_days.php
/templates/default/common/footer.php
/templates/default/common/functions.php
/js/custom.js
/common/js/custom.js
/admin/login.php

FIXED ISSUES

Layout fixes

/templates/default/css/main.css (#471)
/templates/default/models/booking.php

Block readonly datepicker fields in admin panel

/admin/includes/fn_form.php
/admin/includes/inc_header_form.php