FileMaster
Search
Toggle Dark Mode
Home
/
.
/
wp-content
/
plugins
/
booking
/
core
Edit File: wpbc-dates.php
<?php /** * @version 1.0 * @package Booking Calendar * @subpackage Dates Functions * @category Functions * * @author wpdevelop * @link https://wpbookingcalendar.com/ * @email info@wpbookingcalendar.com * * @modified 29.09.2015 */ if ( ! defined( 'ABSPATH' ) ) exit; // Exit if accessed directly /** * Get the dates in different formats * * @param type $str_dates__dd_mm_yyyy * @param type $booking_type * @param type $booking_form_data * @return array( 'string' => "30.02.2014, 31.02.2014, 01.03.2014" , 'array' => array("2014-02-30", "2014-02-31", .... , 'start_time' => array('00','00','00'); , 'end_time' => array('00','00','00'); ); */ function wpbc_get_dates_in_diff_formats( $str_dates__dd_mm_yyyy, $booking_type, $booking_form_data ){ $str_dates__dd_mm_yyyy = str_replace( '|', ',', $str_dates__dd_mm_yyyy); // Check this for some old versions of plugin if ( strpos($str_dates__dd_mm_yyyy,' - ') !== false ) { // Recheck for any type of Range Days Formats $arr_check_in_out_dates = explode(' - ', $str_dates__dd_mm_yyyy ); $str_dates__dd_mm_yyyy = wpbc_get_comma_seprated_dates_from_to_day( $arr_check_in_out_dates[0], $arr_check_in_out_dates[1] ); } $days_array = explode( ',', $str_dates__dd_mm_yyyy ); // Create dates Array $only_days = array(); foreach ($days_array as $new_day) { if ( ! empty($new_day) ) { $new_day = trim( $new_day ); $new_day = str_replace( '-', '.', $new_day); $new_day = explode( '.', $new_day); $only_days[] = sprintf( "%04d-%02d-%02d", intval( $new_day[2] ), intval( $new_day[1] ), intval( $new_day[0] ) ); } } sort($only_days); // Sort Dates // Get Times from booking form if these fields exist $start_end_time = wpbc_get_times_in_form( $booking_form_data, $booking_type ); if ( $start_end_time !== false ) { $start_time = $start_end_time[0]; // array('00','00','01'); $end_time = $start_end_time[1]; // array('00','00','01'); if ( ( '00' == $start_time[0] ) && ( '00' == $start_time[1] ) ) { // FixIn: 8.7.8.8. $start_time = array( '00', '00', '00' ); $end_time = array( '00', '00', '00' ); } else { if ( count( $only_days ) == 1 ) { // add end date if selected 1 day only and times is exist $only_days[] = $only_days[0]; } } } else { $start_time = array( '00', '00', '00' ); $end_time = array( '00', '00', '00' ); } return array( 'string' => $str_dates__dd_mm_yyyy // dd_mm_yyyy , 'array' => $only_days , 'start_time' => $start_time , 'end_time' => $end_time ); } /** * Check for minimum and maximum available times, and restrict value to these limits. * * @param string $time 24:00 * @param string $min_time 00:01 * @param string $max_time 23:59 * * @return string 23:59 */ function wpbc_check_min_max_available_times( $time = '00:00', $min_time = '00:00', $max_time = '23:59' ) { // Time in minutes $time_m = explode( ':', trim( $time ) ); $time_m = intval( $time_m[0] ) * 60 + intval( $time_m[1] ); // Min time in minutes $min_time_m = explode( ':', trim( $min_time ) ); $min_time_m = intval( $min_time_m[0] ) * 60 + intval( $min_time_m[1] ); // Max time in minutes $max_time_m = explode( ':', trim( $max_time ) ); $max_time_m = intval( $max_time_m[0] ) * 60 + intval( $max_time_m[1] ); if ( $time_m < $min_time_m ) { $time_m = $min_time_m; } if ( $time_m > $max_time_m ) { $time_m = $max_time_m; } // Convert time in minutes back to string HH:MM $time_m_h = floor( $time_m / 60 ); $time_m_m = $time_m - $time_m_h * 60; // Check leading 0 if ( $time_m_h < 10 ) { $time_m_h = '0' . $time_m_h; } if ( $time_m_m < 10 ) { $time_m_m = '0' . $time_m_m; } return $time_m_h . ':' . $time_m_m; } /** * Get Times from booking Form, if these times fields exist * * @param type $booking_form_data * @param type $booking_type * @return mixed array ( array('00','00','01'), array('00','00','01') ) || false */ function wpbc_get_times_in_form( $booking_form_data, $booking_type ){ $is_time_exist = false; $start_time = $end_time = '00:00:00'; if ( strpos( $booking_form_data, 'rangetime' . $booking_type ) !== false ) { // ~checkbox^mymultiple4^~checkbox^rangetime4^ ~checkbox^rangetime4^12:00 - 13:00~ checkbox^rangetime4^~checkbox^rangetime4^~text^name4^Jonny~ // Types of the conditions $f_type = '[^\^]*'; $f_name = 'rangetime[\d]*[\[\]]{0,2}'; $f_value = '[\s]*([0-9:]*)[\s]*\-[\s]*([0-9:]*)[\s]*[^~]*'; $pattern_to_search='%[~]?'.$f_type.'\^'.$f_name.'\^'.$f_value.'[~]?%'; preg_match_all($pattern_to_search, $booking_form_data, $matches, PREG_SET_ORDER); /** * Example of $matches: [ [ [0] => '~checkbox^rangetime4^13:00 - 14:00~' [1] => '13:00' [2] => '14:00' ] ] */ if (count($matches)>0){ $start_time = wpbc_get_time_in_24_hours_format( trim( $matches[0][1] ) ); $start_time[2] = '01'; $end_time = wpbc_get_time_in_24_hours_format( trim( $matches[0][2] ) ); $end_time[2] = '02'; $is_time_exist = true; } else { $start_time = array('00','00','01'); $end_time = array('00','00','02'); } } else { if ( strpos( $booking_form_data, 'starttime' . $booking_type ) !== false ) { // Get START TIME From form request $pos1 = strpos( $booking_form_data, 'starttime' . $booking_type ); // Find start time pos $pos1 = strpos( $booking_form_data, '^', $pos1 ) + 1; // Find TIME pos $pos2 = strpos( $booking_form_data, '~', $pos1 ); // Find TIME length if ( $pos2 === false ) { $pos2 = strlen( $booking_form_data ); } $pos2 = $pos2 - $pos1; $start_time = substr( $booking_form_data, $pos1, $pos2 ); if ( $start_time == '' ) { $start_time = '00:00'; } $start_time = wpbc_check_min_max_available_times( $start_time, '00:01', '23:59' ); // FixIn: 8.7.11.1. $start_time = explode( ':', $start_time ); $start_time[2] = '01'; } else { $start_time = explode( ':', $start_time ); } if ( strpos( $booking_form_data, 'endtime' . $booking_type ) !== false ) { // Get END TIME From form request $pos1 = strpos( $booking_form_data, 'endtime' . $booking_type ); // Find start time pos $pos1 = strpos( $booking_form_data, '^', $pos1 ) + 1; // Find TIME pos $pos2 = strpos( $booking_form_data, '~', $pos1 ); // Find TIME length if ( $pos2 === false ) { $pos2 = strlen( $booking_form_data ); } $pos2 = $pos2 - $pos1; $end_time = substr( $booking_form_data, $pos1, $pos2 ); if ( $end_time == '' ) { $end_time = '00:00'; } $end_time = wpbc_check_min_max_available_times( $end_time, '00:01', '23:59' ); // FixIn: 8.7.11.1. $is_time_exist = true; $end_time = explode( ':', $end_time ); $end_time[2] = '02'; } else { $end_time = explode( ':', $end_time ); } if ( strpos( $booking_form_data, 'durationtime' . $booking_type ) !== false ) { // Get END TIME From form request $pos1 = strpos( $booking_form_data, 'durationtime' . $booking_type ); // Find start time pos $pos1 = strpos( $booking_form_data, '^', $pos1 ) + 1; // Find TIME pos $pos2 = strpos( $booking_form_data, '~', $pos1 ); // Find TIME length if ( $pos2 === false ) { $pos2 = strlen( $booking_form_data ); } $pos2 = $pos2 - $pos1; $end_time = substr( $booking_form_data, $pos1, $pos2 ); $is_time_exist = true; $end_time = explode( ':', $end_time ); // Here we are get start time and add duration for end time $new_end_time = mktime( intval( $start_time[0] ), intval( $start_time[1] ) ); $new_end_time = $new_end_time + $end_time[0] * 60 * 60 + $end_time[1] * 60; $end_time = gmdate( 'H:i', $new_end_time ); if ( $end_time == '00:00' ) { $end_time = '23:59'; } $end_time = explode( ':', $end_time ); $end_time[2] = '02'; } } if ( $is_time_exist ) { return array( $start_time, $end_time ); } else { return false; } } //FixIn: TimeFreeGenerator /** * Convert timeslot "10:00 - 12:00" to specfic timeformat, like "10:00 AM - 12:00 PM" * @param string $timeslot - "10:00 - 12:00" * @param string $time_format = "g:i A" */ function wpbc_time_slot_in_format( $timeslot, $time_format = false ){ // FixIn: 8.9.3.1. if ( ( empty( $timeslot ) ) ) { return ''; } $value_times = explode( '-', $timeslot ); $value_times[0] = trim( $value_times[0] ); $value_times[1] = trim( $value_times[1] ); $s_tm = wpbc_time_localized( $value_times[0] , $time_format); $e_tm = wpbc_time_localized( $value_times[1] , $time_format); $t_delimeter = ' - '; return $s_tm . $t_delimeter . $e_tm ; } //FixIn: 8.4.2.11 Deprecated, use this: wpbc_time_localized /** * Convert timeslot "10:00" to specfic timeformat, like "10:00 AM" * @param string $timeslot - "10:00" * @param string $time_format = "g:i A" */ function wpbc_time_in_format( $timeslot, $time_format = false ){ $s_tm = wpbc_time_localized( $timeslot, $time_format ); return $s_tm; } /** * Get dates from DB of specific booking -> '2023-10-09 12:00:01, 2023-10-09 20:00:02' * * @global type $wpdb * @param type $booking_id_str - booking ID * @return string - comma separated dates in SQL format -> '2023-10-09 12:00:01, 2023-10-09 20:00:02' */ function wpbc_db__get_sql_dates__in_booking__as_str( $booking_id_str ) { global $wpdb; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared $dates_result = $wpdb->get_results( "SELECT DISTINCT booking_date FROM {$wpdb->prefix}bookingdates WHERE booking_id IN ({$booking_id_str}) ORDER BY booking_date" ); $dates_str = array(); foreach ( $dates_result as $my_date ) { $dates_str[] = $my_date->booking_date; } $dates_str = implode( ', ', $dates_str ); return $dates_str; } /** * Get Only Dates array from Dates Dimes string with comma seperated values * * @param $dates_ymd_his_csv -> '2023-10-09 12:00:01, 2023-10-09 20:00:02' * * @return array|string[] -> '2023-10-09, 2023-10-09' * * * Usually it called like in this Example: * $dates_ymd_his_csv = wpbc_db__get_sql_dates__in_booking__as_str( $booking_id_str ); // '100' | '10,7' - booking ID * $dates_only_arr = wpbc_get_only_dates__from_dates_ymd_his_csv__as_arr( $dates_ymd_his_csv ); // -> '2023-10-09, 2023-10-09' */ function wpbc_get_only_dates__from_dates_ymd_his_csv__as_arr( $dates_ymd_his_csv ){ // FixIn: 10.1.5.6. $dates_only_arr = wpbc_get_dates_arr__from_dates_comma_separated( array( 'dates_separator' => ', ', // ', ' 'dates' => $dates_ymd_his_csv, // '2023-04-04 12:03:00, 2023-04-07 2024-06-30:00' ) ); // Get Only Dates $dates_only_arr = array_map( function ( $date_sql_ymd_his ) { $date_sql_ymd_his = trim( $date_sql_ymd_his ); $date_sql_ymd_his = substr( $date_sql_ymd_his, 0, 10 ); return $date_sql_ymd_his; } , $dates_only_arr ); $dates_only_arr = array_unique( $dates_only_arr ); return $dates_only_arr; } /** * Get Time in 24 hours (military) format, from possible AM/PM format * * @param string $time_str - '01:20 PM' * @return string - '13:20' */ function wpbc_get_time_in_24_hours_format( $time_str ) { $time_str = trim( $time_str ); $time_str_plus = 0; if ( strpos( strtolower( $time_str) ,'am' ) !== false ) { $time_str = str_replace('am', '', $time_str ); $time_str = str_replace('AM', '', $time_str ); } if ( strpos( strtolower( $time_str) ,'pm' ) !== false ) { $time_str = str_replace('pm', '', $time_str ); $time_str = str_replace('PM', '', $time_str ); $time_str_plus = 12; } $time_str = explode( ':', trim( $time_str ) ); // FixIn: 9.9.0.4. $time_str[0] = intval( $time_str[0] ) + $time_str_plus; $time_str[1] = intval( $time_str[1] ); if ($time_str[0] < 10 ) $time_str[0] = '0' . $time_str[0]; if ($time_str[1] < 10 ) $time_str[1] = '0' . $time_str[1]; return $time_str; } /** * Get number of days between 2 dates (dates in mySQL format) * * @param string $day1 - Day in MySQL format * @param string $day2 - Day in MySQL format * * @return int - number of days */ function wpbc_get_difference_in_days( $day1, $day2 ) { return floor( ( strtotime( $day1 ) - strtotime( $day2 ) ) / 86400 ); // FixIn: 8.2.1.11. } /** * Get sorted sql dates array, like: [ '2023-10-18 00:00:00', '2023-10-19 00:00:00', '2023-10-20 00:00:00' ] * * @param string $booking_days '19.10.2023,18.10.2023,20.10.2023' - comma separated dates: * @return array - [ '2023-10-18 00:00:00', '2023-10-19 00:00:00', '2023-10-20 00:00:00' ] - sorted dates array */ function wpbc_get_sorted_days_array( $booking_days ) { if ( strpos($booking_days,' - ') !== false ) { $booking_days = explode(' - ', $booking_days ); $booking_days = wpbc_get_comma_seprated_dates_from_to_day($booking_days[0],$booking_days[1]); } $days_array = explode(',', $booking_days); $only_days = array(); foreach ($days_array as $new_day) { if ( ! empty( $new_day ) ) { $new_day = trim( $new_day ); if ( strpos( $new_day, '.' ) !== false ) $new_day = explode('.',$new_day); else $new_day = explode('-',$new_day); $only_days[] = $new_day[2] .'-' . $new_day[1] .'-' . $new_day[0] . ' 00:00:00'; } } if ( ! empty( $only_days ) ) { sort($only_days); } return $only_days; } /** * Get Dates in Comma seperated format, based on start and end dates. * * @param string $date_str_from - start date: 06.04.2015 * @param string $date_str_to - end date: 08.04.2015 * @return string - comma seperated dates: 06.04.2015, 07.04.2015, 08.04.2015 */ function wpbc_get_comma_seprated_dates_from_to_day( $date_str_from, $date_str_to ) { $date_str_from = explode('.', $date_str_from); $date_str_to = explode('.', $date_str_to); $iDateFrom = mktime( 1, 0, 0, ( intval( $date_str_from[1] ) ), ( intval( $date_str_from[0] ) ), ( intval( $date_str_from[2] ) ) ); $iDateTo = mktime( 1, 0, 0, ( intval( $date_str_to[1] ) ), ( intval( $date_str_to[0] ) ), ( intval( $date_str_to[2] ) ) ); $aryRange=array(); if ( $iDateTo >= $iDateFrom ) { array_push( $aryRange, gmdate( 'd.m.Y', $iDateFrom ) ); // first entry while ($iDateFrom<$iDateTo) { $iDateFrom+=86400; // add 24 hours array_push( $aryRange, gmdate( 'd.m.Y', $iDateFrom ) ); } } $aryRange = implode(', ', $aryRange); return $aryRange; } /** * Get dates array based on start and end dates. * * @param string $sStartDate - start date: 2015-04-06 * @param string $sEndDate - end date: 2015-04-08 * @return array - array( 2015-04-06, 2015-04-07, 2015-04-08 ) */ function wpbc_get_dates_array_from_start_end_days( $sStartDate, $sEndDate ){ // Firstly, format the provided dates. // This function works best with YYYY-MM-DD // but other date formats will work thanks // to strtotime(). $sStartDate = gmdate("Y-m-d", strtotime($sStartDate)); $sEndDate = gmdate("Y-m-d", strtotime($sEndDate)); // Start the variable off with the start date $aDays[] = $sStartDate; // Set a 'temp' variable, sCurrentDate, with // the start date - before beginning the loop $sCurrentDate = $sStartDate; // While the current date is less than the end date while($sCurrentDate < $sEndDate){ // Add a day to the current date $sCurrentDate = gmdate("Y-m-d", strtotime("+1 day", strtotime($sCurrentDate))); // Add this new day to the aDays array $aDays[] = $sCurrentDate; } // Once the loop has finished, return the // array of days. return $aDays; } /** * Get dates array, from range days selection * * @param $params = array( * 'dates_separator' => ' ~ ', // Dates separator * 'dates' => '2023-04-04 ~ 2023-04-07' // Dates in 'Y-m-d' format: '2023-01-31' * ) * * @return array = array( * [0] => 2023-04-04 * [1] => 2023-04-05 * [2] => 2023-04-06 * [3] => 2023-04-07 * ) * * Example #1: wpbc_get_dates_arr__from_dates_range( array( 'dates_separator' => ' ~ ', 'dates' => '2023-04-04 ~ 2023-04-07' ) ); * Example #2: wpbc_get_dates_arr__from_dates_range( array( 'dates_separator' => ' - ', 'dates' => '2023-04-04 - 2023-04-07' ) ); */ function wpbc_get_dates_arr__from_dates_range( $params ){ $defaults = array( 'dates_separator' => ' ~ ', // ' ~ ' 'dates' => '', // '2023-04-04 ~ 2023-04-07' ); $params = wp_parse_args( $params, $defaults ); $dates_arr = array(); if ( ! empty( $params['dates'] ) ) { list( $check_in_date_ymd, $check_out_date_ymd ) = explode( $params['dates_separator'], $params['dates'] ); if ( ( ! empty( $check_in_date_ymd ) ) && ( ! empty( $check_out_date_ymd ) ) ) { $dates_arr = wpbc_get_dates_array_from_start_end_days( $check_in_date_ymd, $check_out_date_ymd ); } } return $dates_arr; } /** * Get dates array, from comma separated dates * * @param $params = array( * 'dates_separator' => ', ', // Dates separator * 'dates' => '2023-04-04, 2023-04-07, 2023-04-05' // Dates in 'Y-m-d' format: '2023-01-31' * ) * * @return array = array( * [0] => 2023-04-04 * [1] => 2023-04-05 * [2] => 2023-04-06 * [3] => 2023-04-07 * ) * * Example #1: wpbc_get_dates_arr__from_dates_comma_separated( array( 'dates_separator' => ', ', 'dates' => '2023-04-04, 2023-04-07, 2023-04-05' ) ); */ function wpbc_get_dates_arr__from_dates_comma_separated( $params ){ $defaults = array( 'dates_separator' => ', ', // ' ~ ' 'dates' => '', // ''2023-04-04, 2023-04-07, 2023-04-05' ); $params = wp_parse_args( $params, $defaults ); $dates_arr = array(); if ( ! empty( $params['dates'] ) ) { $dates_arr = explode( $params['dates_separator'], $params['dates'] ); sort( $dates_arr ); } return $dates_arr; } /** * Get tommorow day from input value * * @param string $nowday : 2015-02-29 * @return int : Unix timestamp for a date like this 2015-02-30 */ function wpbc_get_tommorow_day( $nowday ){ $nowday_d = gmdate( 'm.d.Y', mysql2date( 'U', $nowday ) ); $previos_array = explode( '.', $nowday_d ); $tommorow_day = mktime( 0, 0, 0, intval($previos_array[0]), ( intval($previos_array[1]) + 1 ), intval($previos_array[2]) ) ; return $tommorow_day; } /** * Check if this date is today day * * @param string $some_day : '2015-05-29' * @return boolean : true | false */ function wpbc_is_today_date( $some_day ) { $some_day_d = gmdate( 'm.d.Y', mysql2date( 'U', $some_day ) ); $today_day = gmdate( 'm.d.Y' ); if ( $today_day == $some_day_d ) { return true; } else { return false; } } /** * Check if this date is Tomorrow day * * @param string $some_day : '2024-08-18' * @return boolean : true | false */ function wpbc_is_tomorrow_date( $some_day ) { $some_day_d = gmdate( 'Y-m-d 00:00:00', mysql2date( 'U', $some_day ) ); $today_day = gmdate( 'Y-m-d 00:00:00' ); $tomorrow_day = gmdate( 'Y-m-d 00:00:00', strtotime( '+1 day', strtotime( $today_day ) ) ); if ( $tomorrow_day == $some_day_d ) { return true; } else { return false; } } // FixIn: 8.8.1.2. /** * Check if this date in past * * @param string $some_day : '2015-05-29' * @return boolean : true | false */ function wpbc_is_date_in_past( $some_day ) { $some_day_d = gmdate( 'm.d.Y', mysql2date( 'U', $some_day ) ); $some_array = explode( '.', $some_day_d ); $some_day = mktime( 0, 0, 0, intval($some_array[0]), ( intval($some_array[1]) + 1 ), intval($some_array[2]) ); $today_day = time(); if ( $today_day > $some_day ) { return true; } else { return false; } } //TODO: refactor it, by replacig date_i18n to wp_loc_date... (check depndencies of this function in other usage functions...) /** * Change date / time format * * @param string $dt - MySQL Date - '2015-11-21 00:00:00' * @param type $date_format - Optional. Date format * @param type $time_format - Optional. Time format * @return array( 'DATE in custom Format', 'TIME in custom Format' ) */ function wpbc_get_date_in_correct_format( $dt, $date_format = false, $time_format = false ) { if ( $date_format === false ) $date_format = get_bk_option( 'booking_date_format'); if ( empty( $date_format ) ) $date_format = "m / d / Y, D"; if ( $time_format === false ) $time_format = get_bk_option( 'booking_time_format'); if ( empty( $time_format ) ) $time_format = get_option( 'time_format' ); //'h:i a'; //FixIn: TimeFree 2 - in Booking Calendar Free version show by default times hints in AM/PM format $my_time = gmdate( 'H:i:s' , mysql2date( 'U', $dt ) ); if ( $my_time == '00:00:00' ) $time_format = ''; $bk_date = date_i18n( $date_format, mysql2date( 'U', $dt ) ); $bk_time = date_i18n( ' ' . $time_format , mysql2date( 'U', $dt ) ); if ( $bk_time == ' ' ) $bk_time = ''; return array($bk_date, $bk_time); } /** * Get SHORT Dates showing data * * @param array $bk_dates_short - Array of dates * @param bool $is_approved - is dates approved or not * @param type $bk_dates_short_id * @param type $booking_types * @return string */ function wpbc_get_short_dates_formated_to_show( $bk_dates_short, $is_approved = false, $bk_dates_short_id = array() , $booking_types = array() ){ $short_dates_content = ''; $dcnt = 0; foreach ( $bk_dates_short as $dt ) { if ( $dt == '-' ) { $short_dates_content .= '<span class="date_tire"> - </span>'; } elseif ( $dt == ',' ) { $short_dates_content .= '<span class="date_tire">, </span>'; } else { $short_dates_content .= '<a href="javascript:void(0)" class="field-booking-date label flex-label '; if ( $is_approved ) $short_dates_content .= ' approved'; $short_dates_content .= '">'; $bk_date = wpbc_get_date_in_correct_format( $dt ); $short_dates_content .= $bk_date[0]; $short_dates_content .= '<sup class="field-booking-time">' . $bk_date[1] . '</sup>'; if ( class_exists( 'wpdev_bk_biz_l' ) ) { // BL if ( ( !empty( $bk_dates_short_id[$dcnt] ) ) && ( isset( $booking_types[$bk_dates_short_id[$dcnt]] ) ) ){ $bk_booking_type_name_date = $booking_types[$bk_dates_short_id[$dcnt]]->title; // Default if ( strlen( $bk_booking_type_name_date ) > 19 ) $bk_booking_type_name_date = substr( $bk_booking_type_name_date, 0, 13 ) . '...' . substr( $bk_booking_type_name_date, -3 ); $short_dates_content .= '<sup class="field-booking-time date_from_dif_type"> ' . $bk_booking_type_name_date . '</sup>'; } } $short_dates_content .= '</a>'; } $dcnt++; } return $short_dates_content; } // FixIn: 9.6.3.5. /** * Get booking dates from DB for specific calendar * * @param array $params array( 'approved' => '' // '' - all | '0' - pending | '1' - approved , 'resource_id' => 1 // int or dcv , 'skip_booking_id' => '' // int or dcv ) * * @return array array( [1-7-2023] => array( [sec_0] => stdClass Object ( [booking_date] => 2023-01-07 00:00:00 [approved] => 0 [booking_id] => 96 ) ) [1-8-2023] => Array( [sec_0] => stdClass Object ( [booking_date] => 2023-01-08 00:00:00 [approved] => 0 [booking_id] => 42 ) ) ... */ function wpbc__sql__get_booked_dates( $params ){ $defaults = array( 'approved' => '' // '' - all | '0' - pending | '1' - approved , 'resource_id' => 1 // int or dcv , 'skip_booking_id' => '' // int or dcv ); $params = wp_parse_args( $params, $defaults ); // S a n i t i z e $params['approved'] = ( '' != $params['approved'] ) ? intval( $params['approved'] ) : ''; $params['skip_booking_id'] = ( '' != $params['skip_booking_id'] ) ? wpbc_sanitize_digit_or_csd( $params['skip_booking_id'] ) : ''; $params['resource_id'] = ( '' != $params['resource_id'] ) ? wpbc_sanitize_digit_or_csd( $params['resource_id'] ) : 1; // S Q L global $wpdb; $sql = "SELECT DISTINCT dt.booking_date, dt.approved, bk.booking_id FROM {$wpdb->prefix}bookingdates as dt INNER JOIN {$wpdb->prefix}booking as bk ON bk.booking_id = dt.booking_id WHERE ( 1 = 1 )"; // W H E R E $sql_where = ''; $sql_where .= ( '' != $params['approved'] ) ? " AND ( dt.approved = {$params['approved']} ) " : ''; // Approved (1) or Pending (0) or All // int $sql_where .= " AND dt.booking_date >= " . wpbc_sql_date_math_expr_explicit('', 'curdate') . " "; // Only actual bookings $sql_where .= " AND bk.trash != 1 "; // Not in Trash // int $sql_where .= " AND bk.booking_type IN ( {$params['resource_id']} ) "; // For specific calendar (booking resource) // int $sql_where .= ( '' != $params['skip_booking_id'] ) ? " AND dt.booking_id NOT IN ( {$params['skip_booking_id']} ) " : '' ; // Skip some bookings ? Usually, during booking edit. // O R D E R $sql_order = " ORDER BY dt.booking_date"; // Order by booking dates & times /** * Array( [0] => stdClass Object ( [booking_date] => 2022-12-27 00:00:00, [approved] => 0, [booking_id] => 187 ) [1] => stdClass Object ( [booking_date] => 2022-12-28 00:00:00, [approved] => 1, [booking_id] => 26 ) ... */ // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared $result_arr = $wpdb->get_results( $sql . $sql_where . $sql_order ); // P A R S E $prior_check_out_date = false; $dates_arr = array(); foreach ( $result_arr as $sql_date ) { $blocked_days_range = array( $sql_date->booking_date ); $resource_id = explode( ',', $params['resource_id'] ); $resource_id = $resource_id[0]; if ( ( ! class_exists( 'wpdev_bk_biz_l' ) ) || ( ( class_exists( 'wpdev_bk_biz_l' ) ) && ( ! wpbc_is_this_parent_resource( $resource_id ) ) ) ){ // FixIn: 9.1.2.7. list( $blocked_days_range, $prior_check_out_date ) = apply_filters( 'wpbc_get_extended_block_dates_filter', array( $blocked_days_range, $prior_check_out_date ) ); } foreach ( $blocked_days_range as $date_ymd_his ) { $sql_date->booking_date = $date_ymd_his; $date_as_int = strtotime( $sql_date->booking_date ); $date_key = gmdate( 'Y-m-d', $date_as_int ); $date_seconds = $date_as_int - strtotime( $date_key ); // Transform '2022-09-01' to 9-1-2022 $date_key__for_calendar = gmdate( 'n-j-Y', $date_as_int ); // j - Day of the month without leading zeros 1 to 31 ; n - Number of month, without leading zeros 1 to 12 if ( empty( $dates_arr[ $date_key__for_calendar ] ) ) { $dates_arr[ $date_key__for_calendar ] = array(); } /** * Important info about [ 'sec_' . $date_seconds ] * * We need to have 'sec_0' instead of simple 0 * * for having JavaScript Objects (object property 'sec_o') instead of Array (index 0), after sending Ajax response and JSON decode! */ $dates_arr[ $date_key__for_calendar ][ 'sec_' . $date_seconds] = $sql_date; } } return $dates_arr; } /** * Get season availability based on booking resource and seasons from Booking > Resources > Availability page * * @param array $params array( 'resource_id' => 1 // int or dcv , 'from' => 'NOW' // any value that is possible to use in strtotime() , 'count' => 365 // int ) * * @return array Array ( [2023-01-09] => 1 [2023-01-10] => 1 [2023-01-11] => 1 [2023-01-12] => 1 [2023-01-13] => 1 [2023-01-14] => [2023-01-15] => [2023-01-16] => 1 [2023-01-17] => 1 [2023-01-18] => 1 [2023-01-19] => 1 ... */ function wpbc__sql__get_season_availability( $params ){ // FixIn: 9.5.4.4. $max_days_count = 365; $max_monthes_in_calendar = get_bk_option( 'booking_max_monthes_in_calendar' ); if ( strpos( $max_monthes_in_calendar, 'm' ) !== false ) { $max_days_count = intval( str_replace( 'm', '', $max_monthes_in_calendar ) ) * 31 + 5; // FixIn: 9.6.1.1. } else { $max_days_count = intval( str_replace( 'y', '', $max_monthes_in_calendar ) ) * 365 + 15; // FixIn: 9.6.1.1. } $defaults = array( 'resource_id' => 1 // int or dcv , 'from' => 'NOW' // any value that is possible to use in strtotime() , 'count' => $max_days_count // int ); $params = wp_parse_args( $params, $defaults ); // S a n i t i z e $params['resource_id'] = ( '' != $params['resource_id'] ) ? wpbc_sanitize_digit_or_csd( $params['resource_id'] ) : 1; $is_all_days_available = true; $season_filters_id_arr = array(); if ( ( class_exists( 'wpdev_bk_biz_m' ) ) && ( function_exists( 'wpbc_get_resource_meta' ) ) ) { // BM and higher // FixIn: 9.9.0.13. // S Q L $availability_res = wpbc_get_resource_meta( $params['resource_id'], 'availability' ); if ( ! empty( $availability_res ) ) { /** * Array ( [general] => On, [filter] => Array ( [1] => On, ... * [2] => Off * ... * [8] => Off * [9] => On * ) * ) */ $availability = maybe_unserialize( $availability_res[0]->value ); $is_all_days_available = ( 'On' === $availability['general'] ) ? true : false; $season_filter = $availability['filter']; // Get ID of only activated Seasons if ( is_array( $season_filter ) ) { foreach ( $season_filter as $key => $value ) { if ( $value == 'On' ) { $season_filters_id_arr[] = intval( $key ); // Sanitize booking_filter_id for future SQL } } } } } $days_availability = array(); for( $i = 0; $i < $params['count']; $i++) { $date_y_m_d = gmdate( 'Y-m-d', strtotime( '+' . $i . 'days', strtotime( $params['from'] ) ) ); $days_availability[ $date_y_m_d ] = $is_all_days_available; $date_arr = explode( '-', $date_y_m_d ); foreach ( $season_filters_id_arr as $filter_id ) { $day = intval( $date_arr[2] ); $month = intval( $date_arr[1] ); $year = intval( $date_arr[0] ); if ( wpbc_is_day_inside_of_filter( $day, $month, $year, $filter_id ) ){ $days_availability[ $date_y_m_d ] = ! $days_availability[ $date_y_m_d ]; break; } } } return $days_availability; }
Save
Back