function wpdev_booking_activate() { update_bk_option('booking_version_num', WP_BK_VERSION_NUM); $version = get_bk_version(); $is_demo = wpdev_bk_is_this_demo(); load_bk_Translation(); // set execution time to 15 minutes, its not worked if we have SAFE MODE ON at PHP if (function_exists('set_time_limit')) { if (!in_array(ini_get('safe_mode'), array('1', 'On'))) { set_time_limit(900); } } add_bk_option('booking_admin_cal_count', $is_demo ? '3' : '2'); add_bk_option('booking_skin', '/css/skins/traditional.css'); add_bk_option('bookings_num_per_page', '10'); add_bk_option('booking_sort_order', ''); add_bk_option('booking_default_toolbar_tab', 'filter'); add_bk_option('bookings_listing_default_view_mode', 'vm_calendar'); //,'vm_listing'); if ($version == 'free') { add_bk_option('booking_view_days_num', '90'); } else { add_bk_option('booking_view_days_num', '30'); } // Month view for several resources //add_bk_option( 'booking_sort_order_direction', 'ASC'); add_bk_option('booking_max_monthes_in_calendar', '1y'); add_bk_option('booking_client_cal_count', '1'); add_bk_option('booking_start_day_weeek', '0'); add_bk_option('booking_title_after_reservation', sprintf(__('Thank you for your online booking. %s We will send confirmation of your booking as soon as possible.', 'wpdev-booking'), '')); add_bk_option('booking_title_after_reservation_time', '7000'); add_bk_option('booking_type_of_thank_you_message', 'message'); add_bk_option('booking_thank_you_page_URL', '/thank-you'); add_bk_option('booking_is_use_autofill_4_logged_user', $is_demo ? 'On' : 'Off'); add_bk_option('booking_date_format', get_option('date_format')); add_bk_option('booking_date_view_type', 'short'); // short / wide add_bk_option('booking_is_delete_if_deactive', $is_demo ? 'On' : 'Off'); // check add_bk_option('booking_dif_colors_approval_pending', 'On'); add_bk_option('booking_is_use_hints_at_admin_panel', 'On'); add_bk_option('booking_is_not_load_bs_script_in_client', 'Off'); add_bk_option('booking_is_not_load_bs_script_in_admin', 'Off'); // Set the type of days selections based on the previous saved data .... $booking_type_of_day_selections = 'multiple'; //'single'; if (get_bk_option('booking_multiple_day_selections') == 'On') { $booking_type_of_day_selections = 'multiple'; } if (get_bk_option('booking_range_selection_is_active') == 'On') { $booking_type_of_day_selections = 'range'; } if ($is_demo) { $booking_type_of_day_selections = 'multiple'; } add_bk_option('booking_type_of_day_selections', $booking_type_of_day_selections); add_bk_option('booking_form_is_using_bs_css', 'On'); add_bk_option('booking_form_format_type', 'vertical'); add_bk_option('booking_form_field_active1', 'On'); add_bk_option('booking_form_field_required1', 'On'); add_bk_option('booking_form_field_label1', 'First Name'); add_bk_option('booking_form_field_active2', 'On'); add_bk_option('booking_form_field_required2', 'On'); add_bk_option('booking_form_field_label2', 'Last Name'); add_bk_option('booking_form_field_active3', 'On'); add_bk_option('booking_form_field_required3', 'On'); add_bk_option('booking_form_field_label3', 'Email'); add_bk_option('booking_form_field_active4', 'On'); add_bk_option('booking_form_field_required4', 'Off'); add_bk_option('booking_form_field_label4', 'Phone'); add_bk_option('booking_form_field_active5', 'On'); add_bk_option('booking_form_field_required5', 'Off'); add_bk_option('booking_form_field_label5', 'Details'); add_bk_option('booking_unavailable_days_num_from_today', '0'); add_bk_option('booking_unavailable_day0', 'Off'); add_bk_option('booking_unavailable_day1', 'Off'); add_bk_option('booking_unavailable_day2', 'Off'); add_bk_option('booking_unavailable_day3', 'Off'); add_bk_option('booking_unavailable_day4', 'Off'); add_bk_option('booking_unavailable_day5', 'Off'); add_bk_option('booking_unavailable_day6', 'Off'); if ($is_demo) { add_bk_option('booking_user_role_booking', 'subscriber'); add_bk_option('booking_user_role_addbooking', 'subscriber'); add_bk_option('booking_user_role_resources', 'subscriber'); add_bk_option('booking_user_role_settings', 'subscriber'); } else { add_bk_option('booking_user_role_booking', 'editor'); add_bk_option('booking_user_role_addbooking', 'editor'); add_bk_option('booking_user_role_resources', 'editor'); add_bk_option('booking_user_role_settings', 'administrator'); } $blg_title = get_option('blogname'); $blg_title = str_replace('"', '', $blg_title); $blg_title = str_replace("'", '', $blg_title); add_bk_option('booking_email_reservation_adress', htmlspecialchars('"Booking system" <' . get_option('admin_email') . '>')); add_bk_option('booking_email_reservation_from_adress', '[visitoremail]'); //htmlspecialchars('"Booking system" <' .get_option('admin_email').'>')); add_bk_option('booking_email_reservation_subject', __('New booking', 'wpdev-booking')); add_bk_option('booking_email_reservation_content', htmlspecialchars(sprintf(__('You need to approve a new booking %s for: %s Person detail information:%s Currently a new booking is waiting for approval. Please visit the moderation panel%sThank you, %s', 'wpdev-booking'), '[bookingtype]', '[dates]<br/><br/>', '<br/> [content]<br/><br/>', ' [moderatelink]<br/><br/>', $blg_title . '<br/>[siteurl]'))); add_bk_option('booking_email_approval_adress', htmlspecialchars('"Booking system" <' . get_option('admin_email') . '>')); add_bk_option('booking_email_approval_subject', __('Your booking has been approved', 'wpdev-booking')); if ($this->wpdev_bk_personal !== false) { add_bk_option('booking_email_approval_content', htmlspecialchars(sprintf(__('Your reservation %s for: %s has been approved.%sYou can edit the booking on this page: %s Thank you, %s', 'wpdev-booking'), '[bookingtype]', '[dates]', '<br/><br/>[content]<br/><br/>', '[visitorbookingediturl]<br/><br/>', $blg_title . '<br/>[siteurl]'))); } else { add_bk_option('booking_email_approval_content', htmlspecialchars(sprintf(__('Your booking %s for: %s has been approved.%sThank you, %s', 'wpdev-booking'), '[bookingtype]', '[dates]', '<br/><br/>[content]<br/><br/>', $blg_title . '<br/>[siteurl]'))); } add_bk_option('booking_email_deny_adress', htmlspecialchars('"Booking system" <' . get_option('admin_email') . '>')); add_bk_option('booking_email_deny_subject', __('Your booking has been declined', 'wpdev-booking')); add_bk_option('booking_email_deny_content', htmlspecialchars(sprintf(__('Your booking %s for: %s has been canceled. %sThank you, %s', 'wpdev-booking'), '[bookingtype]', '[dates]', '<br/><br/>[denyreason]<br/><br/>[content]<br/><br/>', $blg_title . '<br/>[siteurl]'))); add_bk_option('booking_is_email_reservation_adress', 'On'); add_bk_option('booking_is_email_approval_adress', 'On'); add_bk_option('booking_is_email_deny_adress', 'On'); add_bk_option('booking_widget_title', __('Booking form', 'wpdev-booking')); add_bk_option('booking_widget_show', 'booking_form'); add_bk_option('booking_widget_type', '1'); add_bk_option('booking_widget_calendar_count', '1'); add_bk_option('booking_widget_last_field', ''); add_bk_option('booking_wpdev_copyright_adminpanel', 'On'); add_bk_option('booking_is_show_powered_by_notice', 'On'); add_bk_option('booking_is_use_captcha', 'Off'); add_bk_option('booking_is_show_legend', 'Off'); add_bk_option('booking_legend_is_show_item_available', 'On'); add_bk_option('booking_legend_text_for_item_available', __('Available', 'wpdev-booking')); add_bk_option('booking_legend_is_show_item_pending', 'On'); add_bk_option('booking_legend_text_for_item_pending', __('Pending', 'wpdev-booking')); add_bk_option('booking_legend_is_show_item_approved', 'On'); add_bk_option('booking_legend_text_for_item_approved', __('Booked', 'wpdev-booking')); if (class_exists('wpdev_bk_biz_s')) { add_bk_option('booking_legend_is_show_item_partially', 'On'); add_bk_option('booking_legend_text_for_item_partially', __('Partially booked', 'wpdev-booking')); } // Create here tables which is needed for using plugin global $wpdb; $charset_collate = ''; //if ( $wpdb->has_cap( 'collation' ) ) { if (!empty($wpdb->charset)) { $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset}"; } if (!empty($wpdb->collate)) { $charset_collate .= " COLLATE {$wpdb->collate}"; } //} $wp_queries = array(); if (!$this->is_table_exists('booking')) { // Cehck if tables not exist yet $simple_sql = "CREATE TABLE {$wpdb->prefix}booking (\n booking_id bigint(20) unsigned NOT NULL auto_increment,\n form text ,\n booking_type bigint(10) NOT NULL default 1,\n PRIMARY KEY (booking_id)\n ) {$charset_collate};"; $wpdb->query($simple_sql); } elseif ($this->is_field_in_table_exists('booking', 'form') == 0) { $wp_queries[] = "ALTER TABLE {$wpdb->prefix}booking ADD form TEXT AFTER booking_id"; } if ($this->is_field_in_table_exists('booking', 'modification_date') == 0) { $wp_queries[] = "ALTER TABLE {$wpdb->prefix}booking ADD modification_date datetime AFTER booking_id"; } if ($this->is_field_in_table_exists('booking', 'sort_date') == 0) { $wp_queries[] = "ALTER TABLE {$wpdb->prefix}booking ADD sort_date datetime AFTER booking_id"; } if ($this->is_field_in_table_exists('booking', 'status') == 0) { $wp_queries[] = "ALTER TABLE {$wpdb->prefix}booking ADD status varchar(200) NOT NULL default '' AFTER booking_id"; } if ($this->is_field_in_table_exists('booking', 'is_new') == 0) { $wp_queries[] = "ALTER TABLE {$wpdb->prefix}booking ADD is_new bigint(10) NOT NULL default 1 AFTER booking_id"; } if (!$this->is_table_exists('bookingdates')) { // Cehck if tables not exist yet $simple_sql = "CREATE TABLE {$wpdb->prefix}bookingdates (\n booking_id bigint(20) unsigned NOT NULL,\n booking_date datetime NOT NULL default '0000-00-00 00:00:00',\n approved bigint(20) unsigned NOT NULL default 0\n ) {$charset_collate}"; $wpdb->query($simple_sql); if ($this->wpdev_bk_personal == false) { $wp_queries[] = "INSERT INTO {$wpdb->prefix}booking ( form, modification_date ) VALUES (\n 'text^name1^Jony~text^secondname1^Smith~text^email1^example-free@wpbookingcalendar.com~text^phone1^8(038)458-77-77~textarea^details1^Reserve a room with sea view', NOW() );"; } } if (!class_exists('wpdev_bk_biz_l')) { if ($this->is_index_in_table_exists('bookingdates', 'booking_id_dates') == 0) { $simple_sql = "CREATE UNIQUE INDEX booking_id_dates ON {$wpdb->prefix}bookingdates (booking_id, booking_date);"; $wpdb->query($simple_sql); } } else { if ($this->is_index_in_table_exists('bookingdates', 'booking_id_dates') != 0) { $simple_sql = "DROP INDEX booking_id_dates ON {$wpdb->prefix}bookingdates ;"; $wpdb->query($simple_sql); } } if (count($wp_queries) > 0) { foreach ($wp_queries as $wp_q) { $wpdb->query($wp_q); } if ($this->wpdev_bk_personal == false) { $temp_id = $wpdb->insert_id; $wp_queries_sub = "INSERT INTO {$wpdb->prefix}bookingdates (\n booking_id,\n booking_date\n ) VALUES\n ( " . $temp_id . ", CURDATE()+ INTERVAL 2 day ),\n ( " . $temp_id . ", CURDATE()+ INTERVAL 3 day ),\n ( " . $temp_id . ", CURDATE()+ INTERVAL 4 day );"; $wpdb->query($wp_queries_sub); } } // if( $this->wpdev_bk_personal !== false ) $this->wpdev_bk_personal->pro_activate(); make_bk_action('wpdev_booking_activation'); // Examples in demos if ($is_demo) { $this->createExamples4Demo(); } /* // Fill Development server by initial bookings if ( $_SERVER['HTTP_HOST'] === 'dev' ) { for ($i = 0; $i < 5; $i++) { //if (!class_exists('wpdev_bk_personal')) $this->createExamples4Demo( array(1,2,3,4,5,6,7,8,9,10,11,12) ); } } $this->setDefaultInitialValues();/**/ $this->reindex_booking_db(); }
function wpbc_sync_gcal_activate() { add_bk_option('booking_gcal_feed', ''); add_bk_option('booking_gcal_events_from', 'month-start'); add_bk_option('booking_gcal_events_from_offset', ''); add_bk_option('booking_gcal_events_from_offset_type', ''); add_bk_option('booking_gcal_events_until', 'any'); add_bk_option('booking_gcal_events_until_offset', ''); add_bk_option('booking_gcal_events_until_offset_type', ''); add_bk_option('booking_gcal_events_max', '25'); add_bk_option('booking_gcal_api_key', ''); add_bk_option('booking_gcal_timezone', ''); add_bk_option('booking_gcal_is_send_email', 'Off'); add_bk_option('booking_gcal_auto_import_is_active', 'Off'); add_bk_option('booking_gcal_auto_import_time', '24'); add_bk_option('booking_gcal_events_form_fields', 'a:3:{s:5:"title";s:9:"text^name";s:11:"description";s:12:"text^details";s:5:"where";s:5:"text^";}'); }
function wpbc_settings_emails() { if (isset($_POST['email_reservation_adress'])) { $email_reservation_adress = htmlspecialchars(str_replace('\\"', '"', $_POST['email_reservation_adress'])); $email_reservation_from_adress = htmlspecialchars(str_replace('\\"', '"', $_POST['email_reservation_from_adress'])); $email_reservation_subject = htmlspecialchars(str_replace('\\"', '"', $_POST['email_reservation_subject'])); $email_reservation_content = str_replace('\\"', '"', $_POST['email_reservation_content']); $email_reservation_adress = str_replace("\\'", "'", $email_reservation_adress); $email_reservation_from_adress = str_replace("\\'", "'", $email_reservation_from_adress); $email_reservation_subject = str_replace("\\'", "'", $email_reservation_subject); $email_reservation_content = str_replace("\\'", "'", $email_reservation_content); if (isset($_POST['is_email_reservation_adress'])) { $is_email_reservation_adress = 'On'; } else { $is_email_reservation_adress = 'Off'; } update_bk_option('booking_is_email_reservation_adress', $is_email_reservation_adress); if (get_bk_option('booking_email_reservation_adress') !== false) { update_bk_option('booking_email_reservation_adress', $email_reservation_adress); } else { add_bk_option('booking_email_reservation_adress', $email_reservation_adress); } if (get_bk_option('booking_email_reservation_from_adress') !== false) { update_bk_option('booking_email_reservation_from_adress', $email_reservation_from_adress); } else { add_bk_option('booking_email_reservation_from_adress', $email_reservation_from_adress); } if (get_bk_option('booking_email_reservation_subject') !== false) { update_bk_option('booking_email_reservation_subject', $email_reservation_subject); } else { add_bk_option('booking_email_reservation_subject', $email_reservation_subject); } if (get_bk_option('booking_email_reservation_content') !== false) { update_bk_option('booking_email_reservation_content', $email_reservation_content); } else { add_bk_option('booking_email_reservation_content', $email_reservation_content); } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $email_approval_adress = htmlspecialchars(str_replace('\\"', '"', $_POST['email_approval_adress'])); $email_approval_subject = htmlspecialchars(str_replace('\\"', '"', $_POST['email_approval_subject'])); $email_approval_content = str_replace('\\"', '"', $_POST['email_approval_content']); $email_approval_adress = str_replace("\\'", "'", $email_approval_adress); $email_approval_subject = str_replace("\\'", "'", $email_approval_subject); $email_approval_content = str_replace("\\'", "'", $email_approval_content); if (isset($_POST['is_email_approval_adress'])) { $is_email_approval_adress = 'On'; } else { $is_email_approval_adress = 'Off'; } update_bk_option('booking_is_email_approval_adress', $is_email_approval_adress); if (isset($_POST['is_email_approval_send_copy_to_admin'])) { $is_email_approval_send_copy_to_admin = 'On'; } else { $is_email_approval_send_copy_to_admin = 'Off'; } update_bk_option('booking_is_email_approval_send_copy_to_admin', $is_email_approval_send_copy_to_admin); if (get_bk_option('booking_email_approval_adress') !== false) { update_bk_option('booking_email_approval_adress', $email_approval_adress); } else { add_bk_option('booking_email_approval_adress', $email_approval_adress); } if (get_bk_option('booking_email_approval_subject') !== false) { update_bk_option('booking_email_approval_subject', $email_approval_subject); } else { add_bk_option('booking_email_approval_subject', $email_approval_subject); } if (get_bk_option('booking_email_approval_content') !== false) { update_bk_option('booking_email_approval_content', $email_approval_content); } else { add_bk_option('booking_email_approval_content', $email_approval_content); } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $email_newbookingbyperson_adress = htmlspecialchars(str_replace('\\"', '"', $_POST['email_newbookingbyperson_adress'])); $email_newbookingbyperson_subject = htmlspecialchars(str_replace('\\"', '"', $_POST['email_newbookingbyperson_subject'])); $email_newbookingbyperson_content = str_replace('\\"', '"', $_POST['email_newbookingbyperson_content']); $email_newbookingbyperson_adress = str_replace("\\'", "'", $email_newbookingbyperson_adress); $email_newbookingbyperson_subject = str_replace("\\'", "'", $email_newbookingbyperson_subject); $email_newbookingbyperson_content = str_replace("\\'", "'", $email_newbookingbyperson_content); if (isset($_POST['is_email_newbookingbyperson_adress'])) { $is_email_newbookingbyperson_adress = 'On'; } else { $is_email_newbookingbyperson_adress = 'Off'; } update_bk_option('booking_is_email_newbookingbyperson_adress', $is_email_newbookingbyperson_adress); if (get_bk_option('booking_email_newbookingbyperson_adress') !== false) { update_bk_option('booking_email_newbookingbyperson_adress', $email_newbookingbyperson_adress); } else { add_bk_option('booking_email_newbookingbyperson_adress', $email_newbookingbyperson_adress); } if (get_bk_option('booking_email_newbookingbyperson_subject') !== false) { update_bk_option('booking_email_newbookingbyperson_subject', $email_newbookingbyperson_subject); } else { add_bk_option('booking_email_newbookingbyperson_subject', $email_newbookingbyperson_subject); } if (get_bk_option('booking_email_newbookingbyperson_content') !== false) { update_bk_option('booking_email_newbookingbyperson_content', $email_newbookingbyperson_content); } else { add_bk_option('booking_email_newbookingbyperson_content', $email_newbookingbyperson_content); } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $email_deny_adress = htmlspecialchars(str_replace('\\"', '"', $_POST['email_deny_adress'])); $email_deny_subject = htmlspecialchars(str_replace('\\"', '"', $_POST['email_deny_subject'])); $email_deny_content = str_replace('\\"', '"', $_POST['email_deny_content']); $email_deny_adress = str_replace("\\'", "'", $email_deny_adress); $email_deny_subject = str_replace("\\'", "'", $email_deny_subject); $email_deny_content = str_replace("\\'", "'", $email_deny_content); if (isset($_POST['is_email_deny_adress'])) { $is_email_deny_adress = 'On'; } else { $is_email_deny_adress = 'Off'; } update_bk_option('booking_is_email_deny_adress', $is_email_deny_adress); if (isset($_POST['is_email_deny_send_copy_to_admin'])) { $is_email_deny_send_copy_to_admin = 'On'; } else { $is_email_deny_send_copy_to_admin = 'Off'; } update_bk_option('booking_is_email_deny_send_copy_to_admin', $is_email_deny_send_copy_to_admin); if (get_bk_option('booking_email_deny_adress') !== false) { update_bk_option('booking_email_deny_adress', $email_deny_adress); } else { add_bk_option('booking_email_deny_adress', $email_deny_adress); } if (get_bk_option('booking_email_deny_subject') !== false) { update_bk_option('booking_email_deny_subject', $email_deny_subject); } else { add_bk_option('booking_email_deny_subject', $email_deny_subject); } if (get_bk_option('booking_email_deny_content') !== false) { update_bk_option('booking_email_deny_content', $email_deny_content); } else { add_bk_option('booking_email_deny_content', $email_deny_content); } ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// } $email_reservation_adress = get_bk_option('booking_email_reservation_adress'); $email_reservation_from_adress = get_bk_option('booking_email_reservation_from_adress'); $email_reservation_subject = get_bk_option('booking_email_reservation_subject'); $email_reservation_content = get_bk_option('booking_email_reservation_content'); ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $email_newbookingbyperson_adress = get_bk_option('booking_email_newbookingbyperson_adress'); $email_newbookingbyperson_subject = get_bk_option('booking_email_newbookingbyperson_subject'); $email_newbookingbyperson_content = get_bk_option('booking_email_newbookingbyperson_content'); ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $email_approval_adress = get_bk_option('booking_email_approval_adress'); $email_approval_subject = get_bk_option('booking_email_approval_subject'); $email_approval_content = get_bk_option('booking_email_approval_content'); ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $email_deny_adress = get_bk_option('booking_email_deny_adress'); $email_deny_subject = get_bk_option('booking_email_deny_subject'); $email_deny_content = get_bk_option('booking_email_deny_content'); ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// $is_email_reservation_adress = get_bk_option('booking_is_email_reservation_adress'); $is_email_newbookingbyperson_adress = get_bk_option('booking_is_email_newbookingbyperson_adress'); $is_email_approval_adress = get_bk_option('booking_is_email_approval_adress'); $is_email_approval_send_copy_to_admin = get_bk_option('booking_is_email_approval_send_copy_to_admin'); $is_email_deny_adress = get_bk_option('booking_is_email_deny_adress'); $is_email_deny_send_copy_to_admin = get_bk_option('booking_is_email_deny_send_copy_to_admin'); // Replace <br> to <br> with new line $email_reservation_content = preg_replace(array("@(<|<)br/?(>|>)(\r\n)?@", "/\\[bookingtype\\]/"), array("<br/>", ""), $email_reservation_content); $email_newbookingbyperson_content = preg_replace(array("@(<|<)br/?(>|>)(\r\n)?@", "/\\[bookingtype\\]/"), array("<br/>", ""), $email_newbookingbyperson_content); $email_approval_content = preg_replace(array("@(<|<)br/?(>|>)(\r\n)?@", "/\\[bookingtype\\]/"), array("<br/>", ""), $email_approval_content); $email_deny_content = preg_replace(array("@(<|<)br/?(>|>)(\r\n)?@", "/\\[bookingtype\\]/"), array("<br/>", ""), $email_deny_content); ?> <div class="clear" style="height:0px;"></div> <div id="ajax_working"></div> <div id="poststuff0" class="metabox-holder"> <form name="post_settings_email_templates" action="" method="post" id="post_settings_email_templates" > <div id="visibility_container_email_new_to_admin" class="visibility_container" style="display:block;"> <div class='meta-box'> <div <?php $my_close_open_win_id = 'bk_settings_emails_to_admin'; ?> id="<?php echo $my_close_open_win_id; ?> " class="postbox <?php if ('1' == get_user_option('booking_win_' . $my_close_open_win_id)) { echo 'closed'; } ?> " > <div title="<?php _e('Click to toggle', 'booking'); ?> " class="handlediv" onclick="javascript:verify_window_opening(<?php echo get_bk_current_user_id(); ?> , '<?php echo $my_close_open_win_id; ?> ');" ><br></div> <h3 class='hndle'><span><?php _e('Email to "Admin" after a new booking', 'booking'); ?> </span></h3> <div class="inside"> <table class="form-table email-table0" > <tbody> <tr> <th scope="row"><?php _e('Status', 'booking'); ?> :</th> <td> <fieldset> <label for="is_email_reservation_adress"> <input id="is_email_reservation_adress" name="is_email_reservation_adress" type="checkbox" <?php if ($is_email_reservation_adress == 'On') { echo "checked"; } ?> value="<?php echo $is_email_reservation_adress; ?> " onchange="document.getElementById('booking_is_email_reservation_adress_dublicated').checked=this.checked;" /> <?php _e('Active', 'booking'); ?> </label> </fieldset> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_reservation_adress" ><?php _e('To', 'booking'); ?> :</label></th> <td><input id="email_reservation_adress" name="email_reservation_adress" class="regular-text code" type="text" size="45" value="<?php echo $email_reservation_adress; ?> " /> <span class="description"><?php printf(__('Type default %sadmin email%s for booking confirmation', 'booking'), '<b>', '</b>'); ?> </span> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_reservation_from_adress" ><?php _e('From', 'booking'); ?> :</label></th> <td><input id="email_reservation_from_adress" name="email_reservation_from_adress" class="regular-text code" type="text" size="45" value="<?php echo $email_reservation_from_adress; ?> " /> <span class="description"><?php printf(__('Type the default %sadmin email%s sending the booking confimation. You can use this %s shortcode.', 'booking'), '<b>', '</b>', '<code>[visitoremail]</code>'); ?> </span> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_reservation_subject" ><?php _e('Subject', 'booking'); ?> :</label></th> <td><input id="email_reservation_subject" name="email_reservation_subject" class="regular-text code" type="text" size="45" value="<?php echo $email_reservation_subject; ?> " /> <span class="description"><?php printf(__('Type your email %ssubject%s for the booking confimation message.', 'booking'), '<b>', '</b>'); ?> </span> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_reservation_content" ><?php _e('Content', 'booking'); ?> :</label></th> <td> <?php /**/ wp_editor($email_reservation_content, 'email_reservation_content', array('wpautop' => false, 'media_buttons' => false, 'textarea_name' => 'email_reservation_content', 'textarea_rows' => 10, 'editor_class' => 'wpbc-textarea-tinymce', 'teeny' => true, 'drag_drop_upload' => false)); /* <textarea id="email_reservation_content" name="email_reservation_content" style="width:100%;" rows="10"><?php echo ($email_reservation_content); ?></textarea> /**/ ?> <p class="description"><?php printf(__('Type your %semail message content for checking booking%s in. ', 'booking'), '<b>', '</b>'); ?> </p> </td> </tr> <tr><td></td> <td> <?php $skip_shortcodes = array('denyreason', 'paymentreason', 'visitorbookingediturl', 'visitorbookingcancelurl', 'visitorbookingpayurl', 'cost', 'bookingtype', 'check_in_date', 'check_out_date', 'dates_count'); email_help_section($skip_shortcodes, sprintf(__('For example: "You have a new reservation %s on the following date(s): %s Contact information: %s You can approve or cancel this booking at: %s Thank you, Reservation service."', 'booking'), '', '[dates]<br/><br/>', '<br/> [content]<br/><br/>', htmlentities(' <a href="[moderatelink]">' . __('here', 'booking') . '</a> ') . '<br/><br/> ')); ?> </td> </tr> </tbody> </table> </div> </div> </div> </div> <div id="visibility_container_email_new_to_visitor" class="visibility_container" style="display:none;"> <div class='meta-box'> <div <?php $my_close_open_win_id = 'bk_settings_emails_to_person_after_new'; ?> id="<?php echo $my_close_open_win_id; ?> " class="postbox <?php if ('1' == get_user_option('booking_win_' . $my_close_open_win_id)) { echo 'closed'; } ?> " > <div title="<?php _e('Click to toggle', 'booking'); ?> " class="handlediv" onclick="javascript:verify_window_opening(<?php echo get_bk_current_user_id(); ?> , '<?php echo $my_close_open_win_id; ?> ');" ><br></div> <h3 class='hndle'><span><?php _e('Email to "Person" after they make a new reservation', 'booking'); ?> </span></h3> <div class="inside"> <table class="form-table email-table0" > <tbody> <tr> <th scope="row"><?php _e('Status', 'booking'); ?> :</th> <td> <fieldset> <label for="is_email_newbookingbyperson_adress"> <input id="is_email_newbookingbyperson_adress" name="is_email_newbookingbyperson_adress" type="checkbox" <?php if ($is_email_newbookingbyperson_adress == 'On') { echo "checked"; } ?> value="<?php echo $is_email_newbookingbyperson_adress; ?> " onchange="document.getElementById('booking_is_email_newbookingbyperson_adress_dublicated').checked=this.checked;" /> <?php _e('Active', 'booking'); ?> </label> </fieldset> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_newbookingbyperson_adress" ><?php _e('From', 'booking'); ?> :</label></th> <td><input id="email_newbookingbyperson_adress" name="email_newbookingbyperson_adress" class="regular-text code" type="text" size="45" value="<?php echo $email_newbookingbyperson_adress; ?> " /> <span class="description"><?php printf(__('Type the default %sadmin email%s sending the booking confimation', 'booking'), '<b>', '</b>'); ?> </span> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_newbookingbyperson_subject" ><?php _e('Subject', 'booking'); ?> :</label></th> <td><input id="email_newbookingbyperson_subject" name="email_newbookingbyperson_subject" class="regular-text code" type="text" size="45" value="<?php echo $email_newbookingbyperson_subject; ?> " /> <span class="description"><?php printf(__('Type email subject for %svisitor after creating a new reservation%s.', 'booking'), '<b>', '</b>'); ?> </span> </td> </tr> <tr valign="top"> <th scope="row"> <label for="email_newbookingbyperson_content" ><?php _e('Content', 'booking'); ?> :</label></th> <td> <?php /**/ wp_editor($email_newbookingbyperson_content, 'email_newbookingbyperson_content', array('wpautop' => false, 'media_buttons' => false, 'textarea_name' => 'email_newbookingbyperson_content', 'textarea_rows' => 10, 'editor_class' => 'wpbc-textarea-tinymce', 'teeny' => true, 'drag_drop_upload' => false)); /* <textarea id="email_newbookingbyperson_content" name="email_newbookingbyperson_content" style="width:100%;" rows="10"><?php echo ($email_newbookingbyperson_content); ?></textarea> /**/ ?> <p class="description"><?php printf(__('Type your %semail message for visitor after creating a new reservation%s', 'booking'), '<b>', '</b>'); ?> </p> </td> </tr> <tr><td></td> <td> <?php $skip_shortcodes = array('moderatelink', 'denyreason', 'paymentreason', 'visitorbookingpayurl', 'cost', 'bookingtype', 'check_in_date', 'check_out_date', 'dates_count'); email_help_section($skip_shortcodes, sprintf(__('For example: "Your reservation %s on these date(s): %s is processing now! We will send confirmation by email. %s Thank you, Reservation service."', 'booking'), '', '[dates]', '<br/><br/>[content]<br/><br/>')); ?> </td></tr> </tbody> </table> </div> </div> </div> </div> <div id="visibility_container_email_approved" class="visibility_container" style="display:none;"> <div class='meta-box'> <div <?php $my_close_open_win_id = 'bk_settings_emails_to_person_after_approval'; ?> id="<?php echo $my_close_open_win_id; ?> " class="postbox <?php if ('1' == get_user_option('booking_win_' . $my_close_open_win_id)) { echo 'closed'; } ?> " > <div title="<?php _e('Click to toggle', 'booking'); ?> " class="handlediv" onclick="javascript:verify_window_opening(<?php echo get_bk_current_user_id(); ?> , '<?php echo $my_close_open_win_id; ?> ');" ><br></div> <h3 class='hndle'><span><?php _e('Email to "Person" after booking is approved', 'booking'); ?> </span></h3> <div class="inside"> <table class="form-table email-table0" > <tbody> <tr> <th scope="row"><?php _e('Status', 'booking'); ?> :</th> <td> <fieldset> <label for="is_email_approval_adress"> <input id="is_email_approval_adress" name="is_email_approval_adress" type="checkbox" <?php if ($is_email_approval_adress == 'On') { echo "checked"; } ?> value="<?php echo $is_email_approval_adress; ?> " onchange="document.getElementById('booking_is_email_approval_adress_dublicated').checked=this.checked;" /> <?php _e('Active', 'booking'); ?> </label> </fieldset> </td> </tr> <tr> <th scope="row"><?php _e('Send to Admin', 'booking'); ?> :</th> <td> <fieldset> <label for="is_email_approval_send_copy_to_admin"> <input id="is_email_approval_send_copy_to_admin" name="is_email_approval_send_copy_to_admin" type="checkbox" <?php if ($is_email_approval_send_copy_to_admin == 'On') { echo "checked"; } ?> value="<?php echo $is_email_approval_send_copy_to_admin; ?> " /> <?php _e('Check this box to send copy of this email to Admin', 'booking'); ?> </label> </fieldset> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_approval_adress" ><?php _e('From', 'booking'); ?> :</label></th> <td><input id="email_approval_adress" name="email_approval_adress" class="regular-text code" type="text" size="45" value="<?php echo $email_approval_adress; ?> " /> <span class="description"><?php printf(__('Type the default %sadmin email%s sending the booking confimation', 'booking'), '<b>', '</b>'); ?> </span> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_approval_subject" ><?php _e('Subject', 'booking'); ?> :</label></th> <td><input id="email_approval_subject" name="email_approval_subject" class="regular-text code" type="text" size="45" value="<?php echo $email_approval_subject; ?> " /> <span class="description"><?php printf(__('Type your email subject for the %sapproved booking%s.', 'booking'), '<b>', '</b>'); ?> </span> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_approval_content" ><?php _e('Content', 'booking'); ?> :</label></th> <td> <?php /**/ wp_editor($email_approval_content, 'email_approval_content', array('wpautop' => false, 'media_buttons' => false, 'textarea_name' => 'email_approval_content', 'textarea_rows' => 10, 'editor_class' => 'wpbc-textarea-tinymce', 'teeny' => true, 'drag_drop_upload' => false)); /* <textarea id="email_approval_content" name="email_approval_content" style="width:100%;" rows="10"><?php echo ($email_approval_content); ?></textarea> /**/ ?> <p class="description"><?php printf(__('Type your %semail message for the approved booking%s from the website', 'booking'), '<b>', '</b>'); ?> </p> </td> </tr> <tr valign="top"><td></td> <td> <?php $skip_shortcodes = array('moderatelink', 'denyreason', 'paymentreason', 'visitorbookingpayurl', 'cost', 'bookingtype', 'check_in_date', 'check_out_date', 'dates_count'); email_help_section($skip_shortcodes, sprintf(__('For example: "Your reservation %s on these date(s): %s has been approved.%s Thank you, Reservation service."', 'booking'), '', '[dates]', '<br/><br/>[content]<br/><br/>')); ?> </td> </tr> </tbody> </table> </div> </div> </div> </div> <div id="visibility_container_email_declined" class="visibility_container" style="display:none;"> <div class='meta-box'> <div <?php $my_close_open_win_id = 'bk_settings_emails_to_person_after_deny'; ?> id="<?php echo $my_close_open_win_id; ?> " class="postbox <?php if ('1' == get_user_option('booking_win_' . $my_close_open_win_id)) { echo 'closed'; } ?> " > <div title="<?php _e('Click to toggle', 'booking'); ?> " class="handlediv" onclick="javascript:verify_window_opening(<?php echo get_bk_current_user_id(); ?> , '<?php echo $my_close_open_win_id; ?> ');" ><br></div> <h3 class='hndle'><span><?php _e('Email to "Person" after their booking has been denied', 'booking'); ?> </span></h3> <div class="inside"> <table class="form-table email-table0" > <tbody> <tr> <th scope="row"><?php _e('Status', 'booking'); ?> :</th> <td> <fieldset> <label for="is_email_deny_adress"> <input id="is_email_deny_adress" name="is_email_deny_adress" type="checkbox" <?php if ($is_email_deny_adress == 'On') { echo "checked"; } ?> value="<?php echo $is_email_deny_adress; ?> " onchange="document.getElementById('booking_is_email_declined_adress_dublicated').checked=this.checked;" /> <?php _e('Active', 'booking'); ?> </label> </fieldset> </td> </tr> <tr> <th scope="row"><?php _e('Send to Admin', 'booking'); ?> :</th> <td> <fieldset> <label for="is_email_deny_send_copy_to_admin"> <input id="is_email_deny_send_copy_to_admin" name="is_email_deny_send_copy_to_admin" type="checkbox" <?php if ($is_email_deny_send_copy_to_admin == 'On') { echo "checked"; } ?> value="<?php echo $is_email_deny_send_copy_to_admin; ?> " /> <?php _e('Check this box to send copy of this email to Admin', 'booking'); ?> </label> </fieldset> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_deny_adress" ><?php _e('From', 'booking'); ?> :</label></th> <td><input id="email_deny_adress" name="email_deny_adress" class="regular-text code" type="text" size="45" value="<?php echo $email_deny_adress; ?> " /> <span class="description"><?php printf(__('Type the default %sadmin email%s sending the booking confimation', 'booking'), '<b>', '</b>'); ?> </span> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_deny_subject" ><?php _e('Subject', 'booking'); ?> :</label></th> <td><input id="email_deny_subject" name="email_deny_subject" class="regular-text code" type="text" size="45" value="<?php echo $email_deny_subject; ?> " /> <span class="description"><?php printf(__('Type your email subject for the %sdenied booking%s.', 'booking'), '<b>', '</b>'); ?> </span> </td> </tr> <tr valign="top"> <th scope="row"><label for="email_deny_content" ><?php _e('Content', 'booking'); ?> :</label></th> <td> <?php /**/ wp_editor($email_deny_content, 'email_deny_content', array('wpautop' => false, 'media_buttons' => false, 'textarea_name' => 'email_deny_content', 'textarea_rows' => 10, 'editor_class' => 'wpbc-textarea-tinymce', 'teeny' => true, 'drag_drop_upload' => false)); /* <textarea id="email_deny_content" name="email_deny_content" style="width:100%;" rows="10"><?php echo ($email_deny_content); ?></textarea> /**/ ?> <p class="description"><?php printf(__('Type your %semail message for the denied booking%s from the website', 'booking'), '<b>', '</b>'); ?> </p> </td> </tr> <tr valign="top"><td></td> <td> <?php $skip_shortcodes = array('moderatelink', 'paymentreason', 'visitorbookingpayurl', 'visitorbookingediturl', 'visitorbookingcancelurl', 'cost', 'bookingtype', 'check_in_date', 'check_out_date', 'dates_count'); email_help_section($skip_shortcodes, sprintf(__('For example: "Your reservation %s on these date(s): %s has been canceled. Please contact us for more information. %s Thank you, Reservation service."', 'booking'), '', '[dates]', '<br/><br/>[denyreason]<br/><br/>[content]<br/><br/>')); ?> </td> </tr> </tbody> </table> </div> </div> </div> </div> <span class="wpdevbk"> <div <?php $my_close_open_alert_id = 'bk_alert_settings_email_in_free'; ?> class="alert alert-block alert-info <?php if ('1' == get_user_option('booking_win_' . $my_close_open_alert_id)) { echo 'closed'; } ?> " id="<?php echo $my_close_open_alert_id; ?> "> <a class="close tooltip_left" rel="tooltip" title="Don't show the message anymore" data-dismiss="alert" href="javascript:void(0)" onclick="javascript:verify_window_opening(<?php echo get_bk_current_user_id(); ?> , '<?php echo $my_close_open_alert_id; ?> ');" >×</a> <strong class="alert-heading">Note!</strong> Check how in <a href="http://wpbookingcalendar.com/demo/" target="_blank" style="text-decoration:underline;">other versions of Booking Calendar</a> possible to customize email templates with new additional shortcodes</em> </div> </span> <input class="button-primary button" style="float:right;" type="submit" value="<?php _e('Save Changes', 'booking'); ?> " name="Submit"/> <div class="clear" style="height:10px;"></div> </form> </div> <?php }
function wpdev_booking_activate() { load_bk_Translation(); // set execution time to 15 minutes, its not worked if we have SAFE MODE ON at PHP if (function_exists('set_time_limit')) { if (!in_array(ini_get('safe_mode'), array('1', 'On'))) { set_time_limit(900); } } if (wpdev_bk_is_this_demo()) { add_bk_option('booking_admin_cal_count', '3'); } else { add_bk_option('booking_admin_cal_count', '2'); } add_bk_option('booking_skin', WPDEV_BK_PLUGIN_URL . '/css/skins/traditional.css'); add_bk_option('bookings_num_per_page', '10'); add_bk_option('booking_sort_order', ''); add_bk_option('booking_default_toolbar_tab', 'filter'); //add_bk_option( 'booking_sort_order_direction', 'ASC'); add_bk_option('booking_max_monthes_in_calendar', '1y'); add_bk_option('booking_client_cal_count', '1'); add_bk_option('booking_start_day_weeek', '0'); add_bk_option('booking_title_after_reservation', sprintf(__('Thank you for your online booking. %s We will send confirmation of your booking as soon as possible.', 'wpdev-booking'), '')); add_bk_option('booking_title_after_reservation_time', '7000'); add_bk_option('booking_type_of_thank_you_message', 'message'); add_bk_option('booking_thank_you_page_URL', site_url()); add_bk_option('booking_is_use_autofill_4_logged_user', 'On'); add_bk_option('booking_date_format', get_option('date_format')); add_bk_option('booking_date_view_type', 'short'); // short / wide if (wpdev_bk_is_this_demo()) { add_bk_option('booking_is_delete_if_deactive', 'On'); } else { add_bk_option('booking_is_delete_if_deactive', 'Off'); } // check add_bk_option('booking_dif_colors_approval_pending', 'On'); add_bk_option('booking_is_use_hints_at_admin_panel', 'On'); add_bk_option('booking_is_not_load_bs_script_in_client', 'Off'); add_bk_option('booking_is_not_load_bs_script_in_admin', 'Off'); add_bk_option('booking_multiple_day_selections', 'On'); add_bk_option('booking_unavailable_days_num_from_today', '0'); add_bk_option('booking_unavailable_day0', 'Off'); add_bk_option('booking_unavailable_day1', 'Off'); add_bk_option('booking_unavailable_day2', 'Off'); add_bk_option('booking_unavailable_day3', 'Off'); add_bk_option('booking_unavailable_day4', 'Off'); add_bk_option('booking_unavailable_day5', 'Off'); add_bk_option('booking_unavailable_day6', 'Off'); if (wpdev_bk_is_this_demo()) { add_bk_option('booking_user_role_booking', 'subscriber'); add_bk_option('booking_user_role_addbooking', 'subscriber'); add_bk_option('booking_user_role_resources', 'subscriber'); add_bk_option('booking_user_role_settings', 'subscriber'); } else { add_bk_option('booking_user_role_booking', 'editor'); add_bk_option('booking_user_role_addbooking', 'editor'); add_bk_option('booking_user_role_resources', 'editor'); add_bk_option('booking_user_role_settings', 'administrator'); } $blg_title = get_option('blogname'); $blg_title = str_replace('"', '', $blg_title); $blg_title = str_replace("'", '', $blg_title); add_bk_option('booking_email_reservation_adress', htmlspecialchars('"Booking system" <' . get_option('admin_email') . '>')); add_bk_option('booking_email_reservation_from_adress', htmlspecialchars('"Booking system" <' . get_option('admin_email') . '>')); add_bk_option('booking_email_reservation_subject', __('New booking', 'wpdev-booking')); add_bk_option('booking_email_reservation_content', htmlspecialchars(sprintf(__('You need to approve new booking %s for: %s Person detail information:%s Currently new booking is waiting for approval. Please visit the moderation panel%sThank you, %s', 'wpdev-booking'), '[bookingtype]', '[dates]<br/><br/>', '<br/> [content]<br/><br/>', ' [moderatelink]<br/><br/>', $blg_title . '<br/>[siteurl]'))); add_bk_option('booking_email_approval_adress', htmlspecialchars('"Booking system" <' . get_option('admin_email') . '>')); add_bk_option('booking_email_approval_subject', __('Your booking has been approved', 'wpdev-booking')); if ($this->wpdev_bk_personal !== false) { add_bk_option('booking_email_approval_content', htmlspecialchars(sprintf(__('Your booking %s for: %s has been approved.%sYou can edit this booking at this page: %s Thank you, %s', 'wpdev-booking'), '[bookingtype]', '[dates]', '<br/><br/>[content]<br/><br/>', '[visitorbookingediturl]<br/><br/>', $blg_title . '<br/>[siteurl]'))); } else { add_bk_option('booking_email_approval_content', htmlspecialchars(sprintf(__('Your booking %s for: %s has been approved.%sThank you, %s', 'wpdev-booking'), '[bookingtype]', '[dates]', '<br/><br/>[content]<br/><br/>', $blg_title . '<br/>[siteurl]'))); } add_bk_option('booking_email_deny_adress', htmlspecialchars('"Booking system" <' . get_option('admin_email') . '>')); add_bk_option('booking_email_deny_subject', __('Your booking has been declined', 'wpdev-booking')); add_bk_option('booking_email_deny_content', htmlspecialchars(sprintf(__('Your booking %s for: %s has been canceled. %sThank you, %s', 'wpdev-booking'), '[bookingtype]', '[dates]', '<br/><br/>[denyreason]<br/><br/>[content]<br/><br/>', $blg_title . '<br/>[siteurl]'))); add_bk_option('booking_is_email_reservation_adress', 'On'); add_bk_option('booking_is_email_approval_adress', 'On'); add_bk_option('booking_is_email_deny_adress', 'On'); add_bk_option('booking_widget_title', __('Booking form', 'wpdev-booking')); add_bk_option('booking_widget_show', 'booking_form'); add_bk_option('booking_widget_type', '1'); add_bk_option('booking_widget_calendar_count', '1'); add_bk_option('booking_widget_last_field', ''); add_bk_option('booking_wpdev_copyright', 'Off'); add_bk_option('booking_is_show_powered_by_notice', 'On'); add_bk_option('booking_is_use_captcha', 'Off'); add_bk_option('booking_is_show_legend', 'Off'); // Create here tables which is needed for using plugin global $wpdb; $charset_collate = ''; //if ( $wpdb->has_cap( 'collation' ) ) { if (!empty($wpdb->charset)) { $charset_collate = "DEFAULT CHARACTER SET {$wpdb->charset}"; } if (!empty($wpdb->collate)) { $charset_collate .= " COLLATE {$wpdb->collate}"; } //} if (!$this->is_table_exists('booking')) { $simple_sql = "CREATE TABLE " . $wpdb->prefix . "booking (\r\n booking_id bigint(20) unsigned NOT NULL auto_increment,\r\n firstname varchar(50) NOT NULL,\r\n lastname varchar(50),\r\n referrer varchar(50),\r\n created_by varchar(20) NOT NULL,\r\n created_date datetime NOT NULL,\r\n last_updated_by varchar(20) NOT NULL,\r\n last_updated_date datetime NOT NULL,\r\n PRIMARY KEY (booking_id)\r\n ) {$charset_collate};"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('bookingresources')) { $simple_sql = "CREATE TABLE " . $wpdb->prefix . "bookingresources (\r\n resource_id bigint(20) unsigned NOT NULL auto_increment,\r\n name varchar(50) NOT NULL,\r\n parent_resource_id bigint(20) unsigned,\r\n resource_type varchar(10) NOT NULL,\r\n room_type varchar(2),\r\n created_by varchar(20) NOT NULL,\r\n created_date datetime NOT NULL,\r\n last_updated_by varchar(20) NOT NULL,\r\n last_updated_date datetime NOT NULL,\r\n PRIMARY KEY (resource_id),\r\n FOREIGN KEY (parent_resource_id) REFERENCES " . $wpdb->prefix . "bookingresources(resource_id)\r\n ) {$charset_collate};"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('mv_resources_by_path')) { $simple_sql = "CREATE TABLE " . $wpdb->prefix . "mv_resources_by_path (\r\n resource_id bigint(20) unsigned NOT NULL,\r\n name varchar(50) NOT NULL,\r\n parent_resource_id bigint(20) unsigned,\r\n path varchar(100) NOT NULL,\r\n resource_type varchar(10) NOT NULL,\r\n room_type varchar(2),\r\n level int(10) unsigned NOT NULL,\r\n number_children int(10) unsigned NOT NULL,\r\n capacity int(10) unsigned NOT NULL,\r\n PRIMARY KEY (resource_id)\r\n ) {$charset_collate};"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('resource_properties')) { $simple_sql = "CREATE TABLE " . $wpdb->prefix . "resource_properties (\r\n property_id bigint(20) unsigned NOT NULL,\r\n description varchar(20) NOT NULL,\r\n PRIMARY KEY (property_id)\r\n ) {$charset_collate};"; $wpdb->query($wpdb->prepare($simple_sql)); $simple_sql = "INSERT INTO " . $wpdb->prefix . "resource_properties (property_id, description)\r\n VALUES(%d, %s)"; $wpdb->query($wpdb->prepare($simple_sql, 1, '4-Bed Dorm')); $wpdb->query($wpdb->prepare($simple_sql, 2, '8-Bed Dorm')); $wpdb->query($wpdb->prepare($simple_sql, 3, '10-Bed Dorm')); $wpdb->query($wpdb->prepare($simple_sql, 4, '12-Bed Dorm')); $wpdb->query($wpdb->prepare($simple_sql, 5, '14-Bed Dorm')); $wpdb->query($wpdb->prepare($simple_sql, 6, '16-Bed Dorm')); $wpdb->query($wpdb->prepare($simple_sql, 7, 'Twin Room')); $wpdb->query($wpdb->prepare($simple_sql, 8, 'Double Room')); $wpdb->query($wpdb->prepare($simple_sql, 9, 'Double Deluxe Room')); } if (!$this->is_table_exists('resource_properties_map')) { $simple_sql = "CREATE TABLE " . $wpdb->prefix . "resource_properties_map (\r\n resource_id bigint(20) unsigned NOT NULL,\r\n property_id bigint(20) unsigned NOT NULL,\r\n FOREIGN KEY (resource_id) REFERENCES " . $wpdb->prefix . "bookingresources(resource_id),\r\n FOREIGN KEY (property_id) REFERENCES " . $wpdb->prefix . "resource_properties(property_id)\r\n ) {$charset_collate};"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('bookingcomment')) { $simple_sql = "CREATE TABLE " . $wpdb->prefix . "bookingcomment (\r\n comment_id bigint(20) unsigned NOT NULL auto_increment,\r\n booking_id bigint(20) unsigned NOT NULL,\r\n comment TEXT NOT NULL,\r\n comment_type varchar(10) NOT NULL,\r\n created_by varchar(20) NOT NULL,\r\n created_date datetime NOT NULL,\r\n PRIMARY KEY (comment_id),\r\n FOREIGN KEY (booking_id) REFERENCES " . $wpdb->prefix . "booking(booking_id)\r\n ) {$charset_collate};"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('allocation')) { $simple_sql = "CREATE TABLE " . $wpdb->prefix . "allocation (\r\n allocation_id bigint(20) unsigned NOT NULL auto_increment,\r\n booking_id bigint(20) unsigned NOT NULL,\r\n resource_id bigint(20) unsigned NOT NULL,\r\n guest_name varchar(50) NOT NULL,\r\n gender varchar(1) NOT NULL,\r\n created_by varchar(20) NOT NULL,\r\n created_date datetime NOT NULL,\r\n last_updated_by varchar(20) NOT NULL,\r\n last_updated_date datetime NOT NULL,\r\n PRIMARY KEY (allocation_id),\r\n FOREIGN KEY (booking_id) REFERENCES " . $wpdb->prefix . "booking(booking_id),\r\n FOREIGN KEY (resource_id) REFERENCES " . $wpdb->prefix . "bookingresources(resource_id) \r\n ) {$charset_collate};"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('bookingdates')) { $simple_sql = "CREATE TABLE " . $wpdb->prefix . "bookingdates (\r\n allocation_id bigint(20) unsigned NOT NULL,\r\n booking_date date NOT NULL,\r\n status varchar(10) NOT NULL,\r\n checked_out varchar(1) NULL,\r\n created_by varchar(20) NOT NULL,\r\n created_date datetime NOT NULL,\r\n last_updated_by varchar(20) NOT NULL,\r\n last_updated_date datetime NOT NULL,\r\n FOREIGN KEY (allocation_id) REFERENCES " . $wpdb->prefix . "allocation(allocation_id)\r\n ) {$charset_collate};"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_routine_exists('walk_tree_path')) { $simple_sql = "CREATE FUNCTION walk_tree_path(p_resource_id BIGINT(20) UNSIGNED) RETURNS VARCHAR(255)\r\n -- walks the wp_bookingresources table from the given resource_id down to the root\r\n -- returns the path walked delimited with /\r\n BEGIN\r\n DECLARE last_id BIGINT(20) UNSIGNED;\r\n DECLARE parent_id BIGINT(20) UNSIGNED;\r\n DECLARE return_val VARCHAR(255);\r\n \r\n SET return_val = p_resource_id;\r\n SET parent_id = p_resource_id;\r\n \r\n WHILE parent_id IS NOT NULL DO\r\n \r\n SELECT parent_resource_id INTO parent_id\r\n FROM wp_bookingresources\r\n WHERE resource_id = parent_id;\r\n \r\n SET return_val = CONCAT(IFNULL(parent_id, ''), '/', return_val);\r\n \r\n END WHILE;\r\n \r\n RETURN return_val;\r\n \r\n END;"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('v_resources_sub1')) { $simple_sql = "CREATE OR REPLACE VIEW " . $wpdb->prefix . "v_resources_sub1 AS\r\n SELECT resource_id, name, parent_resource_id, walk_tree_path(resource_id) AS path, resource_type, room_type\r\n FROM " . $wpdb->prefix . "bookingresources"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('v_resources_by_path')) { $simple_sql = "CREATE OR REPLACE VIEW " . $wpdb->prefix . "v_resources_by_path AS\r\n SELECT resource_id, name, parent_resource_id, path, resource_type, room_type,\r\n LENGTH(path) - LENGTH(REPLACE(path, '/', '')) AS level,\r\n (SELECT COUNT(*) FROM wp_v_resources_sub1 s1 WHERE s1.path LIKE CAST(CONCAT(s.path, '/%') AS CHAR) AND resource_type = 'bed') AS number_children,\r\n (SELECT COUNT(*) FROM wp_v_resources_sub1 s1 WHERE (s1.path LIKE CAST(CONCAT(s.path, '/%') AS CHAR) OR s1.path = s.path) AND resource_type = 'bed') AS capacity\r\n FROM " . $wpdb->prefix . "v_resources_sub1 s\r\n ORDER BY path"; // FIXME: remove number_children, rename capacity ==> number_beds $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('v_booked_capacity')) { $simple_sql = "CREATE OR REPLACE VIEW " . $wpdb->prefix . "v_booked_capacity (booking_date, resource_id, used_capacity) AS\r\n SELECT bd.booking_date, alloc.resource_id, COUNT(*) used_capacity\r\n FROM " . $wpdb->prefix . "bookingdates bd\r\n JOIN " . $wpdb->prefix . "allocation alloc ON bd.allocation_id = alloc.allocation_id\r\n GROUP BY bd.booking_date, alloc.resource_id"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_table_exists('v_resource_availability')) { $simple_sql = "CREATE OR REPLACE VIEW " . $wpdb->prefix . "v_resource_availability (booking_date, resource_id, resource_name, path, capacity, used_capacity, avail_capacity) AS\r\n SELECT bc.booking_date, \r\n rp.resource_id, \r\n rp.name AS resource_name,\r\n rp.path, \r\n rp.capacity, \r\n bc.used_capacity,\r\n CAST(rp.capacity - IFNULL(bc.used_capacity, 0) AS SIGNED) AS avail_capacity \r\n FROM " . $wpdb->prefix . "mv_resources_by_path rp\r\n LEFT OUTER JOIN " . $wpdb->prefix . "v_booked_capacity bc ON rp.resource_id = bc.resource_id\r\n WHERE rp.number_children = 0\r\n ORDER BY bc.booking_date, rp.path"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_trigger_exists('trg_enforce_availability')) { $simple_sql = "CREATE TRIGGER " . $wpdb->prefix . "trg_enforce_availability\r\n -- this will raise an error by selecting from a non-existent table\r\n -- in order to enforce availability for a particular resource/date\r\n BEFORE INSERT ON " . $wpdb->prefix . "bookingdates FOR EACH ROW\r\n BEGIN\r\n DECLARE p_avail_capacity INT;\r\n SELECT avail_capacity INTO p_avail_capacity\r\n FROM " . $wpdb->prefix . "v_resource_availability ra\r\n JOIN " . $wpdb->prefix . "allocation alloc ON ra.resource_id = alloc.resource_id\r\n WHERE ra.booking_date = NEW.booking_date\r\n AND alloc.allocation_id = NEW.allocation_id;\r\n \r\n IF p_avail_capacity <= 0 THEN\r\n SELECT 'Reservation conflicts with an existing reservation' INTO p_avail_capacity \r\n FROM SANITY_CHECK_RESERVATION_CONFLICT_FOUND\r\n WHERE SANITY_CHECK_RESERVATION_CONFLICT_FOUND.id = NEW.allocation_id;\r\n END IF;\r\n END"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_trigger_exists('trg_mv_resources_by_path_ins')) { $simple_sql = "CREATE TRIGGER " . $wpdb->prefix . "trg_mv_resources_by_path_ins\r\n -- this will update the materialized view\r\n -- whenever an insert is made on the underlying table\r\n AFTER INSERT ON " . $wpdb->prefix . "bookingresources FOR EACH ROW \r\n BEGIN\r\n INSERT INTO " . $wpdb->prefix . "mv_resources_by_path\r\n SELECT * FROM " . $wpdb->prefix . "v_resources_by_path\r\n WHERE resource_id = NEW.resource_id;\r\n END"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_trigger_exists('trg_mv_resources_by_path_upd')) { $simple_sql = "CREATE TRIGGER " . $wpdb->prefix . "trg_mv_resources_by_path_upd\r\n -- this will update the materialized view\r\n -- whenever an update is made on the underlying table\r\n AFTER UPDATE ON " . $wpdb->prefix . "bookingresources FOR EACH ROW \r\n BEGIN\r\n DELETE FROM " . $wpdb->prefix . "mv_resources_by_path\r\n WHERE resource_id = OLD.resource_id;\r\n\r\n INSERT INTO " . $wpdb->prefix . "mv_resources_by_path\r\n SELECT * FROM " . $wpdb->prefix . "v_resources_by_path\r\n WHERE resource_id = NEW.resource_id;\r\n END"; $wpdb->query($wpdb->prepare($simple_sql)); } if (!$this->is_trigger_exists('trg_mv_resources_by_path_del')) { $simple_sql = "CREATE TRIGGER " . $wpdb->prefix . "trg_mv_resources_by_path_del\r\n -- this will update the materialized view\r\n -- whenever a delete is made on the underlying table\r\n AFTER DELETE ON " . $wpdb->prefix . "bookingresources FOR EACH ROW \r\n BEGIN\r\n DELETE FROM " . $wpdb->prefix . "mv_resources_by_path\r\n WHERE resource_id = OLD.resource_id;\r\n END"; $wpdb->query($wpdb->prepare($simple_sql)); } // if( $this->wpdev_bk_personal !== false ) $this->wpdev_bk_personal->pro_activate(); make_bk_action('wpdev_booking_activation'); //$this->setDefaultInitialValues(); }