ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / ediuae / petalwellnessspa.com / wp-content / plugins / simply-schedule-appointments / includes

<?php
/**
 * Simply Schedule Appointments Availability External Model.
 *
 * @since   4.0.8.beta4
 * @package Simply_Schedule_Appointments
 */
use League\Period\Period;

/**
 * Simply Schedule Appointments Availability External Model.
 *
 * @since 4.0.8.beta4
 */
class SSA_Availability_External_Model extends SSA_Db_Model {
	protected $slug = 'availability_external';
	protected $pluralized_slug = 'availability_external';
	protected $version = '1.1.3';

/**
	 * Parent plugin class.
	 *
	 * @since 0.0.2
	 *
	 * @var   Simply_Schedule_Availabilities
	 */
	protected $plugin = null;

/**
	 * Constructor.
	 *
	 * @since  0.0.2
	 *
	 * @param  Simply_Schedule_Availabilities $plugin Main plugin object.
	 */
	public function __construct( $plugin ) {
		// $this->version = $this->version.'.'.time(); // dev mode
		parent::__construct( $plugin );

$this->hooks();
	}

/**
	 * Initiate our hooks.
	 *
	 * @since  0.0.2
	 */
	public function hooks() {

}

protected $schema = array(
		'staff_id' => array(
			'field' => 'staff_id',
			'label' => 'Staff ID',
			'default_value' => 0,
			'format' => '%d',
			'mysql_type' => 'BIGINT',
			'mysql_length' => 20,
			'mysql_unsigned' => true,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'appointment_id' => array(
			'field' => 'appointment_id',
			'label' => 'Appointment ID',
			'default_value' => 0,
			'format' => '%d',
			'mysql_type' => 'BIGINT',
			'mysql_length' => 20,
			'mysql_unsigned' => true,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'appointment_type_id' => array(
			'field' => 'appointment_type_id',
			'label' => 'Appointment ID',
			'default_value' => 0,
			'format' => '%d',
			'mysql_type' => 'BIGINT',
			'mysql_length' => 20,
			'mysql_unsigned' => true,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'type' => array(
			'field' => 'type',
			'label' => 'Type',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'VARCHAR',
			'mysql_length' => '16',
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'subtype' => array(
			'field' => 'subtype',
			'label' => 'Subtype',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'VARCHAR',
			'mysql_length' => '16',
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'service' => array(
			'field' => 'service',
			'label' => 'Service',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'VARCHAR',
			'mysql_length' => '8',
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'start_date' => array(
			'field' => 'start_date',
			'label' => 'Start Date',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'datetime',
			'mysql_length' => '',
			'mysql_unsigned' => false,
			'mysql_allow_null' => true,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'end_date' => array(
			'field' => 'end_date',
			'label' => 'End Date',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'datetime',
			'mysql_length' => '',
			'mysql_unsigned' => false,
			'mysql_allow_null' => true,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'is_available' => array(
			'field' => 'is_available',
			'label' => 'Is Available',
			'default_value' => 0,
			'format' => '%d',
			'mysql_type' => 'TINYINT',
			'mysql_length' => 1,
			'mysql_unsigned' => true,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'status' => array(
			'field' => 'status',
			'label' => 'Status',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'VARCHAR',
			'mysql_length' => 20,
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'account_id' => array(
			'field' => 'account_id',
			'label' => 'Account ID',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'TINYTEXT',
			'mysql_length' => false,
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'calendar_id' => array(
			'field' => 'calendar_id',
			'label' => 'Calendar ID',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'TINYTEXT',
			'mysql_length' => false,
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'calendar_id_hash' => array(
			'field' => 'calendar_id_hash',
			'label' => 'Calendar ID Hash',
			'default_value' => 0,
			'format' => '%d',
			'mysql_type' => 'INT',
			'mysql_length' => 10,
			'mysql_unsigned' => true,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'ical_uid' => array(
			'field' => 'ical_uid',
			'label' => 'iCal UID',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'TINYTEXT',
			'mysql_length' => false,
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'event_id' => array(
			'field' => 'event_id',
			'label' => 'Event ID',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'TINYTEXT',
			'mysql_length' => false,
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'is_all_day' => array(
			'field' => 'is_all_day',
			'label' => 'Is All Day Event?',
			'default_value' => 0,
			'format' => '%d',
			'mysql_type' => 'TINYINT',
			'mysql_length' => 1,
			'mysql_unsigned' => true,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'transparency' => array(
			'field' => 'transparency',
			'label' => 'Description',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'VARCHAR',
			'mysql_length' => 20,
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'date_created' => array(
			'field' => 'date_created',
			'label' => 'Date Created',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'datetime',
			'mysql_length' => '',
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
		'date_modified' => array(
			'field' => 'date_modified',
			'label' => 'Date Modified',
			'default_value' => false,
			'format' => '%s',
			'mysql_type' => 'datetime',
			'mysql_length' => '',
			'mysql_unsigned' => false,
			'mysql_allow_null' => false,
			'mysql_extra' => '',
			'cache_key' => false,
		),
	);

public $indexes = array(
		'staff_id' => [ 'staff_id' ],
		'calendar_id_hash' => [ 'calendar_id_hash' ],
		'is_available' => [ 'is_available' ],
		'start_date' => [ 'start_date' ],
		'end_date' => [ 'end_date' ],
		'type' => [ 'type' ],
		'subtype' => [ 'subtype' ],
		'service' => [ 'service' ],
		'date_created' => [ 'date_created' ],
	);

public function filter_where_conditions( $where, $args ) {
		global $wpdb;
		if ( !empty( $args['calendar_id_hash_IN'] ) ) {
			if ( is_array( $args['calendar_id_hash_IN'] ) ) {
				// prepare the array items one by one
				$calendar_id_hashes = array_map( 'intval', $args['calendar_id_hash_IN'] );
				$calendar_id_hash_csv = implode( ',', $calendar_id_hashes );
			} else {
				$calendar_id_hash_csv = intval( $args['calendar_id_hash_IN'] );
			}

$where .= ' AND calendar_id_hash IN ( ' . $calendar_id_hash_csv . ' )';
		}

if ( !empty( $args['staff_id'] ) ) {
			$where .= $wpdb->prepare( ' AND staff_id=%d', sanitize_text_field( $args['staff_id'] ) );
		}
		
		if ( !empty( $args['calendar_id_hash'] ) ) {
			$where .= $wpdb->prepare( ' AND calendar_id_hash=%d', sanitize_text_field( $args['calendar_id_hash'] ) );
		}
		
		if ( isset( $args['is_available'] ) ) {
			$where .= $wpdb->prepare( ' AND is_available=%d', sanitize_text_field( $args['is_available'] ) );
		}

if ( isset( $args['type'] ) ) {
			$where .= $wpdb->prepare( ' AND type=%s', sanitize_text_field( $args['type'] ) );
		}

if ( isset( $args['subtype'] ) ) {
			$where .= $wpdb->prepare( ' AND subtype=%s', sanitize_text_field( $args['subtype'] ) );
		}

if ( isset( $args['service'] ) ) {
			$where .= $wpdb->prepare( ' AND service=%s', sanitize_text_field( $args['service'] ) );
		}

if ( isset( $args['cache_key'] ) ) {
			$where .= $wpdb->prepare( ' AND cache_key=%d', sanitize_text_field( $args['cache_key'] ) );
		}

if ( isset( $args['intersects_period'] ) ) {
			if ( $args['intersects_period'] instanceof Period ) {
				$start_date_string = $args['intersects_period']->getStartDate()->format( 'Y-m-d H:i:s' );
				$end_date_string = $args['intersects_period']->getEndDate()->format( 'Y-m-d H:i:s' );

// it should END in the queried period
				// OR 
				// it should START in the queried period
				// OR
				// it should CONTAIN the queried period
				$where .= " AND (
					(end_date >= '{$start_date_string}' AND end_date <= '{$end_date_string}' )
					OR
					(start_date <= '{$end_date_string}' AND start_date >= '{$start_date_string}' )
					OR
					(start_date <= '{$start_date_string}' AND end_date >= '{$end_date_string}' )
				)";
			}
		}

return $where;
	}

public function update_rows( $availability_period_rows, $args = array() ) {
		$args = array_merge( array(
			'cache_key' => time(),
			'type' => '',
			'subtype' => '',
			'service' => '',
		), $args );

$execution_datetime = gmdate( 'Y-m-d H:i:s' );
		global $wpdb;

foreach ($availability_period_rows as $key => $availability_period_row) {
			$availability_period_row['cache_key'] = $args['cache_key'];
			$response = $this->insert( $availability_period_row );
		}

$query = "DELETE FROM {$this->get_table_name()} WHERE 1=1";
		$query = $wpdb->prepare( $query .= " AND cache_key < %d", $args['cache_key'] );
		$query = $wpdb->prepare( $query .= " AND start_date >= %s", $args['start_date_min'] );
		$query = $wpdb->prepare( $query .= " AND start_date <= %s", $args['start_date_max'] );
		$query = $wpdb->prepare( $query .= " AND type = %s", $args['type'] );
		$query = $wpdb->prepare( $query .= " AND subtype = %s", $args['subtype'] );
		$query = $wpdb->prepare( $query .= " AND service = %s", $args['service'] );
		$result = $wpdb->query( $query );

}

public function bulk_delete( $args=array() ) {
		return $this->db_bulk_delete( $args );
	}
}

[-] class-settings.php [edit]
[-] class-hooks.php [edit]
[-] class-availability-query.php [edit]
[-] class-appointment-model.php [edit]
[-] class-beaver-builder.php [edit]
[-] class-web-meetings.php [edit]
[-] class-availability-model.php [edit]
[-] class-recipient-admin.php [edit]
[-] class-recipient-customer.php [edit]
[-] class-constants.php [edit]
[-] class-async-action-model.php [edit]
[-] class-support.php [edit]
[-] class-google-calendar-client.php [edit]
[+] ..
[-] class-capabilities.php [edit]
[-] class-encryption.php [edit]
[-] class-availability-cache-invalidation.php [edit]
[-] class-calendar-events-settings.php [edit]
[-] class-settings-global.php [edit]
[-] class-translation.php [edit]
[-] class-cli.php [edit]
[-] class-missing.php [edit]
[-] class-action-scheduler.php [edit]
[-] class-templates-api.php [edit]
[-] class-blackout-dates.php [edit]
[-] class-calendar-events-object.php [edit]
[-] class-divi.php [edit]
[-] class-templates.php [edit]
[-] class-wp-admin.php [edit]
[-] class-appointment-factory.php [edit]
[-] class-scheduling-max-per-day.php [edit]
[-] class-notifications-api.php [edit]
[-] class-shortcodes.php [edit]
[-] class-validation.php [edit]
[-] class-resource-group-object-factory.php [edit]
[-] class-payment-object.php [edit]
[-] class-locale.php [edit]
[-] class-ics-exporter.php [edit]
[-] class-filesystem.php [edit]
[-] class-recipient-shared.php [edit]
[-] class-availability-schedule.php [edit]
[-] class-block-upcoming-appointments.php [edit]
[-] class-elementor.php [edit]
[-] class-appointment-meta-model.php [edit]
[-] class-revision-meta-model.php [edit]
[+] divi
[-] class-notifications.php [edit]
[-] class-upgrade.php [edit]
[-] class-utils.php [edit]
[-] class-availability-functions.php [edit]
[-] class-external-calendar-api.php [edit]
[-] class-csv-exporter.php [edit]
[-] class-external-google-calendar-api.php [edit]
[-] class-twig-extension.php [edit]
[-] class-bootstrap.php [edit]
[-] class-notices.php [edit]
[-] class-availability-schedule-factory.php [edit]
[-] class-blackout-dates-settings.php [edit]
[-] class-support-status.php [edit]
[-] class-block-booking.php [edit]
[-] class-advanced-scheduling-availability.php [edit]
[-] class-exception.php [edit]
[-] class-styles-settings.php [edit]
[-] class-forms.php [edit]
[-] class-recipient-staff.php [edit]
[+] beaver-builder
[-] class-users.php [edit]
[-] class-sequence-factory.php [edit]
[+] third-party
[-] class-locales.php [edit]
[-] class-db-model.php [edit]
[-] class-db.php [edit]
[-] class-availability-default.php [edit]
[-] class-staff-settings.php [edit]
[-] class-notification-model.php [edit]
[-] class-settings-installed.php [edit]
[-] class-appointment-object.php [edit]
[-] class-notices-api.php [edit]
[-] class-translation-settings.php [edit]
[-] class-support-status-api.php [edit]
[-] class-notices-data.php [edit]
[-] class-appointment-type-object.php [edit]
[-] class-appointment-type-object-factory.php [edit]
[-] class-availability-block-factory.php [edit]
[-] class-recipient.php [edit]
[-] class-revision-model.php [edit]
[-] class-customers.php [edit]
[-] class-settings-api.php [edit]
[-] class-cache.php [edit]
[-] class-availability-detective-case.php [edit]
[-] class-styles.php [edit]
[-] class-capacity-settings.php [edit]
[-] class-gcal-exporter.php [edit]
[-] class-advanced-scheduling-settings.php [edit]
[-] class-appointment-type-model.php [edit]
[-] class-notifications-settings.php [edit]
[-] class-period.php [edit]
[-] class-external-api.php [edit]
[-] class-error-notices.php [edit]
[-] class-availability-cache.php [edit]
[-] class-developer-settings.php [edit]
[-] class-dashboard-upcoming-appointments-widget.php [edit]
[-] class-availability-external-model.php [edit]
[-] class-availability-block.php [edit]
[-] class-customer-information.php [edit]
[+] elementor
[-] class-appointment-type-label-model.php [edit]
[-] class-embed-booking-app-api.php [edit]
[+] lib
[-] class-sequence.php [edit]
[-] class-debug.php [edit]
[-] class-appointment-types-db.php [edit]