| 1 |
<?php |
| 2 |
/** |
| 3 |
* @version 1.0 |
| 4 |
* @package ICS functions |
| 5 |
* @subpackage Import / Export ICS |
| 6 |
* @category ICS |
| 7 |
* |
| 8 |
* @author wpdevelop |
| 9 |
* @link http://oplugins.com/ |
| 10 |
* @email info@oplugins.com |
| 11 |
* |
| 12 |
* @modified 2017-03-01 |
| 13 |
*/ |
| 14 |
|
| 15 |
if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly |
| 16 |
|
| 17 |
|
| 18 |
require_once( WPBM_PLUGIN_DIR . '/assets/libs/icalendar/zapcallib.php' ); |
| 19 |
|
| 20 |
|
| 21 |
/** Download Feed .ICS & Parse to Array |
| 22 |
* |
| 23 |
* @param string $ics_url - URL to ics file |
| 24 |
* @return array | WP_Error on error - Array return array( 'events' => $ics_events, 'data' => $ics_data ); |
| 25 |
$ics_events = array ( |
| 26 |
[DTSTART] => 20140716 |
| 27 |
[DTEND] => 20140717 |
| 28 |
[DTSTAMP] => 20170627T112020Z |
| 29 |
[UID] => d3ihiuv8nqbti9djmpetrgn5ok@google.com |
| 30 |
[CREATED] => 20140628T081753Z |
| 31 |
[DESCRIPTION] => |
| 32 |
[LAST-MODIFIED] => 20140628T081753Z |
| 33 |
[LOCATION] => |
| 34 |
[SEQUENCE] => 0 |
| 35 |
[STATUS] => CONFIRMED |
| 36 |
[SUMMARY] => Test booking here |
| 37 |
[TRANSP] => TRANSPARENT |
| 38 |
[RRULE] => FREQ=DAILY;UNTIL=20140717 |
| 39 |
[_BOOKING_DATES] => Array |
| 40 |
( |
| 41 |
[0] => 2014-07-16 00:00:00 |
| 42 |
[1] => 2014-07-17 00:00:00 |
| 43 |
[2] => 2014-07-17 00:00:00 |
| 44 |
) |
| 45 |
|
| 46 |
[_BOOKING_SUMMARY] => Test booking here |
| 47 |
[_BOOKING_DESCRIPTION] => |
| 48 |
[_BOOKING_LOCATION] => |
| 49 |
[_BOOKING_GUID] => d3ihiuv8nqbti9djmpetrgn5ok@google.com |
| 50 |
[_BOOKING_MODIFIED] => 2014-06-28 08:17:53 |
| 51 |
) |
| 52 |
*/ |
| 53 |
function wpbm_ics_file_to_array( $ics_url ) { |
| 54 |
|
| 55 |
$ics_content = wpbm_get_ssl_page_content( $ics_url ); |
| 56 |
|
| 57 |
if ( false === $ics_content ) |
| 58 |
return new WP_Error( 'wpbm_ics_url_error', '<strong>[WPBM Error]</strong> ' . __( 'Could not download URL' ) . ' ' . $ics_url , 'wrong_url' ); |
| 59 |
|
| 60 |
|
| 61 |
$ics_events = wpbm_ics_content_to_array( $ics_content ); |
| 62 |
|
| 63 |
return $ics_events; |
| 64 |
} |
| 65 |
|
| 66 |
|
| 67 |
/** Parse Content .ICS to array |
| 68 |
* |
| 69 |
* @param string $ics_content - ICS content |
| 70 |
* @return array | false on error - ICS Events Array |
| 71 |
* @return array | false on error - ICS Events Array return array( 'events' => $ics_events, 'data' => $ics_data ); |
| 72 |
$ics_events = array ( |
| 73 |
[DTSTART] => 20140716 |
| 74 |
[DTEND] => 20140717 |
| 75 |
[DTSTAMP] => 20170627T112020Z |
| 76 |
[UID] => d3ihiuv8nqbti9djmpetrgn5ok@google.com |
| 77 |
[CREATED] => 20140628T081753Z |
| 78 |
[DESCRIPTION] => |
| 79 |
[LAST-MODIFIED] => 20140628T081753Z |
| 80 |
[LOCATION] => |
| 81 |
[SEQUENCE] => 0 |
| 82 |
[STATUS] => CONFIRMED |
| 83 |
[SUMMARY] => Test booking here |
| 84 |
[TRANSP] => TRANSPARENT |
| 85 |
[RRULE] => FREQ=DAILY;UNTIL=20140717 |
| 86 |
[_BOOKING_DATES] => Array |
| 87 |
( |
| 88 |
[0] => 2014-07-16 00:00:00 |
| 89 |
[1] => 2014-07-17 00:00:00 |
| 90 |
[2] => 2014-07-17 00:00:00 |
| 91 |
) |
| 92 |
|
| 93 |
[_BOOKING_SUMMARY] => Test booking here |
| 94 |
[_BOOKING_DESCRIPTION] => |
| 95 |
[_BOOKING_LOCATION] => |
| 96 |
[_BOOKING_GUID] => d3ihiuv8nqbti9djmpetrgn5ok@google.com |
| 97 |
[_BOOKING_MODIFIED] => 2014-06-28 08:17:53 |
| 98 |
) |
| 99 |
*/ |
| 100 |
function wpbm_ics_content_to_array( $ics_content ) { |
| 101 |
|
| 102 |
if ( empty( $ics_content ) ) |
| 103 |
return false; |
| 104 |
|
| 105 |
if ( false === strpos( $ics_content, 'VEVENT' ) ) { |
| 106 |
return new WP_Error( 'wpbm_ics_error', '<strong>[WPBM Error]</strong> ' . __( 'File does not contain events' ) . ' ' , 'wrong_ics_content' ); |
| 107 |
} |
| 108 |
|
| 109 |
|
| 110 |
$icalobj = new ZCiCal( $ics_content ); // create the ical object |
| 111 |
|
| 112 |
|
| 113 |
$events_count = 0; |
| 114 |
$ics_events = array(); |
| 115 |
|
| 116 |
|
| 117 |
if ( isset( $icalobj->tree->child ) ) { |
| 118 |
foreach ( $icalobj->tree->child as $node ) { |
| 119 |
|
| 120 |
if ( $node->getName() == "VEVENT" ) { |
| 121 |
|
| 122 |
$ics_events[ $events_count ] = array(); |
| 123 |
|
| 124 |
foreach ( $node->data as $key => $value ) { |
| 125 |
|
| 126 |
$ics_events[ $events_count ][ $key ] = $value->getValues(); |
| 127 |
} |
| 128 |
$events_count++; |
| 129 |
} |
| 130 |
} |
| 131 |
} |
| 132 |
|
| 133 |
|
| 134 |
/** Data, like: array ( [PRODID] => -//Calendar Labs//Calendar 1.0//EN |
| 135 |
[VERSION] => 2.0 |
| 136 |
[CALSCALE] => GREGORIAN |
| 137 |
[METHOD] => PUBLISH |
| 138 |
[X-WR-CALNAME] => Us Holidays |
| 139 |
[X-WR-TIMEZONE] => America/New_York |
| 140 |
*/ |
| 141 |
$ics_data = array(); |
| 142 |
if ( isset( $icalobj->tree->data ) ) { |
| 143 |
foreach ( $icalobj->tree->data as $node ) { |
| 144 |
$ics_data[ $node->getName() ] = $node->getValues(); |
| 145 |
} |
| 146 |
} |
| 147 |
|
| 148 |
|
| 149 |
// Add Booking fields, like "_BOOKING_DATES, _BOOKING_SUMMARY, ..." |
| 150 |
foreach ( $ics_events as $i_key => $i_event) { |
| 151 |
|
| 152 |
$dates_arr = wpbm_get_dates_arr_from_ics_dates( $ics_events[ $i_key ][ 'DTSTART' ] |
| 153 |
, $ics_events[ $i_key ][ 'DTEND' ] |
| 154 |
, ( empty( $ics_events[ $i_key ]['RRULE'] ) ? '' : $ics_events[ $i_key ]['RRULE'] ) |
| 155 |
, ( empty( $ics_events[ $i_key ]['RDATE'] ) ? '' : $ics_events[ $i_key ]['RDATE'] ) |
| 156 |
); |
| 157 |
|
| 158 |
|
| 159 |
// Bookings Fields |
| 160 |
$ics_events[ $i_key ]['_BOOKING_DATES'] = $dates_arr; |
| 161 |
|
| 162 |
$ics_events[ $i_key ]['_BOOKING_SUMMARY'] = ''; |
| 163 |
$ics_events[ $i_key ]['_BOOKING_DESCRIPTION'] = ''; |
| 164 |
$ics_events[ $i_key ]['_BOOKING_LOCATION'] = ''; |
| 165 |
$ics_events[ $i_key ]['_BOOKING_UID'] = ''; |
| 166 |
$ics_events[ $i_key ]['_BOOKING_MODIFIED'] = ''; |
| 167 |
|
| 168 |
if ( ! empty( $ics_events[ $i_key ][ 'SUMMARY' ] ) ) |
| 169 |
$ics_events[ $i_key ]['_BOOKING_SUMMARY'] = $ics_events[ $i_key ][ 'SUMMARY' ]; |
| 170 |
if ( ! empty( $ics_events[ $i_key ][ 'DESCRIPTION' ] ) ) |
| 171 |
$ics_events[ $i_key ]['_BOOKING_DESCRIPTION'] = $ics_events[ $i_key ][ 'DESCRIPTION' ]; |
| 172 |
if ( ! empty( $ics_events[ $i_key ][ 'LOCATION' ] ) ) |
| 173 |
$ics_events[ $i_key ]['_BOOKING_LOCATION'] = $ics_events[ $i_key ][ 'LOCATION' ]; |
| 174 |
|
| 175 |
// 15ig8t0i739kajgjc8ekc386dt@google.com - ID of event from ICS |
| 176 |
// 15ig8t0i739kajgjc8ekc386dt_20170815 - ID of event during import from Google Calendar (probabaly created by ID before @ + first date) |
| 177 |
if ( ! empty( $ics_events[ $i_key ][ 'UID' ] ) ) |
| 178 |
$ics_events[ $i_key ]['_BOOKING_UID'] = $ics_events[ $i_key ][ 'UID' ]; |
| 179 |
if ( ! empty( $ics_events[ $i_key ][ 'LAST-MODIFIED' ] ) ) |
| 180 |
$ics_events[ $i_key ]['_BOOKING_MODIFIED'] = date_i18n( 'Y-m-d H:i:s' , ZDateHelper::fromiCaltoUnixDateTime( $ics_events[ $i_key ][ 'LAST-MODIFIED' ] ) ); |
| 181 |
|
| 182 |
} |
| 183 |
|
| 184 |
return array( 'data' => $ics_data, 'events' => $ics_events ); |
| 185 |
} |
| 186 |
|
| 187 |
|
| 188 |
/** Get Dates array from START & END times & RULES |
| 189 |
* Examples: 2017-07-10 00:00:00 -- 2017-07-13 00:00:00 on FREQ=MONTHLY;COUNT=4;BYDAY=2MO |
| 190 |
* OR 2017-06-14 12:00:00 -- 2017-06-14 15:30:00 on FREQ=WEEKLY;COUNT=3;BYDAY=WE,SA |
| 191 |
* |
| 192 |
* @param string $start_date_ics // 20170614T120000 |
| 193 |
* @param string $end_date_ics // 20170614T153000 |
| 194 |
* @param string $ics_rules // FREQ=WEEKLY;COUNT=3;BYDAY=WE,SA |
| 195 |
* @param string $ics_rdates // 20170826T120001,20170830T120001 |
| 196 |
* @return array // Array ( |
| 197 |
[0] => 2017-06-14 12:00:01 |
| 198 |
[1] => 2017-06-14 15:30:02 |
| 199 |
[2] => 2017-06-17 12:00:01 |
| 200 |
[3] => 2017-06-17 15:30:02 |
| 201 |
[4] => 2017-06-21 12:00:01 |
| 202 |
[5] => 2017-06-21 15:30:02 |
| 203 |
) |
| 204 |
*/ |
| 205 |
function wpbm_get_dates_arr_from_ics_dates( $start_date_ics, $end_date_ics, $ics_rules , $ics_rdates ) { |
| 206 |
|
| 207 |
$start_date_ics = wpbm_ics_date_reset_seconds( $start_date_ics ); // 20170614T120000 |
| 208 |
$end_date_ics = wpbm_ics_date_reset_seconds( $end_date_ics ); // 20170614T120000 |
| 209 |
|
| 210 |
// FREQ=MONTHLY;COUNT=4;BYDAY=2MO - Rules |
| 211 |
$start_date_unix = ZDateHelper::fromiCaltoUnixDateTime( $start_date_ics ); // 1499644800 - 20170710 |
| 212 |
$end_date_unix = ZDateHelper::fromiCaltoUnixDateTime( $end_date_ics ); // 1499904000 - 20170713 |
| 213 |
|
| 214 |
$time_difference = $end_date_unix - $start_date_unix; // 259200 - Difference in seconds |
| 215 |
|
| 216 |
$start_date = date_i18n( 'Y-m-d H:i:s', $start_date_unix ); // 2017-07-10 00:00:00 |
| 217 |
$end_date = date_i18n( 'Y-m-d H:i:s', $end_date_unix ); // 2017-07-13 00:00:00 |
| 218 |
|
| 219 |
// Get Unix Time for Strat Date at midnight -- 2017-07-10 |
| 220 |
$start_date_midnight_unix = strtotime( date_i18n( 'Y-m-d 00:00:00', $start_date_unix ) ); |
| 221 |
$start_date_midnight = date_i18n( 'Y-m-d H:i:s', $start_date_midnight_unix ); // Same in MySQL format: 2017-07-10 00:00:00 |
| 222 |
|
| 223 |
//////////////////////////////////////////////////////////////////////////////////////////////////////////// |
| 224 |
|
| 225 |
$internal_dates =array(); |
| 226 |
|
| 227 |
// Get Unix Time for Strat Date at midnight -- 2017-07-10 |
| 228 |
$end_date_midnight_unix = strtotime( date_i18n( 'Y-m-d 00:00:00', $end_date_unix ) ); |
| 229 |
$end_date_midnight = date_i18n( 'Y-m-d H:i:s', $end_date_midnight_unix ); // Same in MySQL format: 2018-01-14 00:00:00 |
| 230 |
|
| 231 |
// Get internal days between START and END dates: // array( [0] => 1499731200 [1] => 1499817600 ) |
| 232 |
// Need to check relative to the END MIDNIGHT, becase if |
| 233 |
// we have END DATE for specific time, like 2018-01-14 02:30:02 , we do NOT have this date as 2018-01-14 00:00:00 |
| 234 |
while( ( $start_date_midnight_unix + ( 60*60*24 ) ) < $end_date_midnight_unix ) { |
| 235 |
$start_date_midnight_unix += 60*60*24; // Get next day |
| 236 |
$internal_dates[] = $start_date_midnight_unix; |
| 237 |
} |
| 238 |
|
| 239 |
//////////////////////////////////////////////////////////////////////////////////////////////////////////// |
| 240 |
// Get Initial Dates interval |
| 241 |
$initial_time_interval_unix = array(); |
| 242 |
|
| 243 |
// In case if we have start time, like 15:00:00 we will trasnform it to 15:00:01 - for internal usage of Booking Calendar |
| 244 |
if ( substr( $start_date, 11 ) != '00:00:00' ) $initial_time_interval_unix[] = $start_date_unix + 1; // Start time for specific time slot |
| 245 |
else $initial_time_interval_unix[] = $start_date_unix ; // Full date |
| 246 |
|
| 247 |
foreach ( $internal_dates as $internal_date_unix ) { |
| 248 |
$initial_time_interval_unix[] = $internal_date_unix; |
| 249 |
} |
| 250 |
|
| 251 |
// Same for end date/time +2 seconds for having time like 10:00:02 |
| 252 |
if ( substr( $end_date, 11 ) != '00:00:00' ) $initial_time_interval_unix[] = $end_date_unix + 2; // End time for specific time slot |
| 253 |
// We do not need to add END date, if the TIME == '00:00:00', because EVENT ended at previous date |
| 254 |
|
| 255 |
//////////////////////////////////////////////////////////////////////////////////////////////////////////// |
| 256 |
|
| 257 |
// Here we are getting SHIFT in seonds starting from INITIAL start DATE_TIME |
| 258 |
$initial_time_interval_shift_unix = array(); |
| 259 |
foreach ( $initial_time_interval_unix as $internal_date_unix ) { |
| 260 |
$initial_time_interval_shift_unix[] = $internal_date_unix - $start_date_unix; |
| 261 |
} |
| 262 |
|
| 263 |
// $initial_time_interval_shift_unix >>> FULL DAYS: array( [0] => 0 [1] => 86400 [2] => 172800 ) |
| 264 |
// $initial_time_interval_shift_unix >>> TIMES: array( [0] => 1 [1] => 12602 ) |
| 265 |
|
| 266 |
|
| 267 |
//////////////////////////////////////////////////////////////////////////////////////////////////////////////// |
| 268 |
|
| 269 |
// Get DATES depsnding from RULES imported from ICS |
| 270 |
$ics_start_dates_unix = array(); |
| 271 |
if ( ! empty( $ics_rules ) ) { |
| 272 |
|
| 273 |
// Parse RULE and Get Dates array |
| 274 |
$rDates = new ZCRecurringDate( |
| 275 |
$ics_rules |
| 276 |
, strtotime( $start_date_ics ) |
| 277 |
); |
| 278 |
$ics_start_dates_unix = $rDates->getDates(); // MAX DATE: strtotime( $ics_events[ $i_key ][ 'DTEND' ] ) ); |
| 279 |
sort( $ics_start_dates_unix ); // Sort |
| 280 |
$ics_start_dates_unix = array_unique( $ics_start_dates_unix ); // Remove Duplicates |
| 281 |
} |
| 282 |
// Example: Array ( [0] => 1499644800 [1] => 1502668800 [2] => 1505088000 [3] => 1507507200 ) or array() |
| 283 |
|
| 284 |
// If we are having rDates |
| 285 |
if ( ! empty( $ics_rdates ) ) { |
| 286 |
$ics_rdates = explode( ',', $ics_rdates ); |
| 287 |
|
| 288 |
foreach ( $ics_rdates as $ics_rdates_key => $ics_rdates_value ) { |
| 289 |
|
| 290 |
$ics_rdates_value = wpbm_ics_date_reset_seconds( $ics_rdates_value ); // 20170614T120000 |
| 291 |
$ics_rdates_value = ZDateHelper::fromiCaltoUnixDateTime( $ics_rdates_value ); // // 1497441600 |
| 292 |
$ics_rdates[ $ics_rdates_key ] = $ics_rdates_value; |
| 293 |
} |
| 294 |
// We need to add also to these array start day |
| 295 |
$ics_rdates[] = strtotime( $start_date_ics ); |
| 296 |
|
| 297 |
sort( $ics_rdates ); // Sort |
| 298 |
|
| 299 |
$ics_start_dates_unix = array_merge( $ics_start_dates_unix, $ics_rdates ); |
| 300 |
$ics_start_dates_unix = array_unique( $ics_start_dates_unix ); // Remove Duplicates |
| 301 |
} |
| 302 |
|
| 303 |
//////////////////////////////////////////////////////////////////////////////////////////////////////////////// |
| 304 |
|
| 305 |
$dates_arr_unix = array(); |
| 306 |
|
| 307 |
// We are having some RULES |
| 308 |
if ( ! empty( $ics_start_dates_unix ) ) { |
| 309 |
foreach ( $ics_start_dates_unix as $ics_start_date_unix ) { // Depend from rules, we are having starting interval of our EVENT |
| 310 |
|
| 311 |
foreach ( $initial_time_interval_shift_unix as $shift_unix ) { // Because EVENT can have several dates or times, we add our SHIFT interval from INITIAL |
| 312 |
|
| 313 |
$dates_arr_unix[] = $ics_start_date_unix + $shift_unix; |
| 314 |
} |
| 315 |
} |
| 316 |
} else { // No Rules |
| 317 |
|
| 318 |
foreach ( $initial_time_interval_unix as $initial_time_unix ) { // So we are getting only INITIAL interval |
| 319 |
$dates_arr_unix[] = $initial_time_unix; |
| 320 |
} |
| 321 |
} |
| 322 |
//ex: Array ( [0] => 1497441601 [1] => 1497454202 [2] => 1497700801 [3] => 1497713402 [4] => 1498046401 [5] => 1498059002 ) |
| 323 |
|
| 324 |
$dates_arr_mysql = array(); |
| 325 |
foreach ( $dates_arr_unix as $date_unix ) { |
| 326 |
$dates_arr_mysql[] = date_i18n( 'Y-m-d H:i:s', $date_unix ); |
| 327 |
} |
| 328 |
//ex: Array ( [0] => 2017-06-14 12:00:01 [1] => 2017-06-14 15:30:02 [2] => 2017-06-17 12:00:01 [3] => 2017-06-17 15:30:02 [4] => 2017-06-21 12:00:01 [5] => 2017-06-21 15:30:02 ) |
| 329 |
|
| 330 |
return $dates_arr_mysql; |
| 331 |
} |
| 332 |
|
| 333 |
|
| 334 |
/** Reset any seconds in ics date and return it, |
| 335 |
* Its useful, if such info was exported by Booking Calendar and now is importing again. |
| 336 |
* |
| 337 |
* @param string $ics_date_time - 20170614T120001 |
| 338 |
* @return string - 20170614T120000 |
| 339 |
*/ |
| 340 |
function wpbm_ics_date_reset_seconds( $ics_date_time ) { |
| 341 |
|
| 342 |
// 1497441601 |
| 343 |
$date_time_unix = ZDateHelper::fromiCaltoUnixDateTime( $ics_date_time ); |
| 344 |
|
| 345 |
// 2017-07-10 00:00:01 |
| 346 |
$date_time_sql = date_i18n( 'Y-m-d H:i:s', $date_time_unix ); |
| 347 |
|
| 348 |
if( strlen( $date_time_sql ) > 10 ) { |
| 349 |
$date_time_sql = substr($date_time_sql, 0, -2 ) . '00'; // Reset seconds to 00, if previously we was have 01 or 02 |
| 350 |
} |
| 351 |
// 2017-07-10 00:00:00 |
| 352 |
|
| 353 |
$date_time_unix = strtotime( $date_time_sql ); |
| 354 |
|
| 355 |
$ics_date_time = ZDateHelper::fromUnixDateTimetoiCal( $date_time_unix ); |
| 356 |
|
| 357 |
return $ics_date_time; |
| 358 |
} |
