<?php
namespace JET_APB;

use JET_APB\Time_Slots;

/**
 * Tools class
 */
class Tools {

	/**
	 * Get services for provider ID
	 *
	 * @param  integer $provider_id [description]
	 * @return [type]              [description]
	 */
	public function get_services_for_provider( $provider_id = 0 ) {

		$services_cpt  = Plugin::instance()->settings->get( 'services_cpt' );
		$providers_cpt = Plugin::instance()->settings->get( 'providers_cpt' );

		if ( ! $provider_id || ! $services_cpt || ! $providers_cpt ) {
			return false;
		}

		$services = jet_engine()->relations->get_related_posts( array(
			'post_type_1' => $services_cpt,
			'post_type_2' => $providers_cpt,
			'post_id'     => $provider_id,
			'from'        => $services_cpt,
		) );

		return $services;

	}

	/**
	 * Get service capacity count
	 *
	 * @param  [type] $service [description]
	 * @return [type]          [description]
	 */
	public function get_service_count( $service ) {

		$capacity = get_post_meta( $service, '_app_capacity', true );
		$capacity = absint( $capacity );

		if ( ! $capacity ) {
			$capacity = 1;
		}

		return $capacity;

	}

	/**
	 * Get providers list for passed services ID
	 *
	 * @param  integer $service_id [description]
	 * @return [type]              [description]
	 */
	public function get_providers_for_service( $service_id = 0 ) {

		$services_cpt  = Plugin::instance()->settings->get( 'services_cpt' );
		$providers_cpt = Plugin::instance()->settings->get( 'providers_cpt' );

		if ( ! $service_id || ! $services_cpt || ! $providers_cpt ) {
			return array();
		}

		$providers = jet_engine()->relations->get_related_posts( array(
			'post_type_1' => $services_cpt,
			'post_type_2' => $providers_cpt,
			'post_id'     => $service_id,
			'from'        => $providers_cpt,
		) );

		$result = array();

		if ( ! empty( $providers ) ) {

			global $wpdb;

			$query  = implode( ', ', $providers );
			$table  = $wpdb->posts;
			$result = $wpdb->get_results( "SELECT ID, post_title FROM $table WHERE `ID` IN ( $query );" );

		}

		if ( ! is_array( $result ) ) {
			return array();
		} else {
			return $result;
		}

	}

	/**
	 * Returns services label
	 * @return [type] [description]
	 */
	public function get_services_label() {

		$services_cpt = Plugin::instance()->settings->get( 'services_cpt' );

		if ( ! $services_cpt ) {
			return null;
		}

		$services = get_post_type_object( $services_cpt );

		if ( ! $services ) {
			return null;
		}

		return $services->labels->singular_name;

	}

	/**
	 * Returns providers label
	 * @return [type] [description]
	 */
	public function get_providers_label() {

		$providers_cpt = Plugin::instance()->settings->get( 'providers_cpt' );

		if ( ! $providers_cpt ) {
			return null;
		}

		$providers = get_post_type_object( $providers_cpt );

		if ( ! $providers ) {
			return null;
		}

		return $providers->labels->singular_name;

	}

	/**
	 * Returns verbosed slot by timestatmp
	 * @return [type] [description]
	 */
	public function get_verbosed_slot( $slot ) {
		$date_format = get_option( 'date_format', 'F j, Y' );
		$time_format = Plugin::instance()->settings->get( 'slot_time_format' );

		if( ! $time_format ){
			$time_format = get_option( 'time_format', 'H:i' );
		}

		$format = $date_format . ' ' . $time_format;

		return date_i18n( $format, $slot );
	}

	public function get_posts( $from = 'services', $args = [ 'posts_per_page' => -1 ] ) {

		$post_type = false;

		switch ( $from ) {
			case 'services':
				$post_type = Plugin::instance()->settings->get( 'services_cpt' );
				break;

			case 'providers':
				$post_type = Plugin::instance()->settings->get( 'providers_cpt' );
				break;
		}

		if ( ! $post_type ) {
			return array();
		}

		$args  = wp_parse_args( [ 'post_type' => $post_type ] , $args );
		$posts = get_posts( $args );

		if ( empty( $posts ) ) {
			return array();
		} else {
			return wp_list_pluck( $posts, 'post_title', 'ID' );
		}

	}

	/**
	 * Returns path to template file.
	 *
	 * @return string|bool
	 */
	public function get_template( $name = null ) {

		$template_path = apply_filters( 'jet-apb/tools/template-path', 'jet-appointments-booking' );
		$template      = locate_template( $template_path . $name );

		if ( ! $template ) {
			$template = JET_APB_PATH . 'templates/public/' . $name;
		}

		if ( file_exists( $template ) ) {
			return $template;
		} else {
			return false;
		}
	}

	public function secondsToTime( $second = 0, $format = 'H:i:s' ){
		$result = date( $format,$second );

		return $result;
	}

	/**
	 * Returns time slots
	 *
	 * @return [type] [description]
	 */
	/*public function get_time_slots( $plain = true ) {

		return Time_Slots::prepare_slots_for_js(
			Time_Slots::generate_slots(
				array(
					'from'     => 30 * MINUTE_IN_SECONDS,
					'to'       => DAY_IN_SECONDS / 2,
					'interval' => 15 * MINUTE_IN_SECONDS,
					'format'   => 'U',
				)
			),
			'G\h i\m\i\n',
			$plain,
			true
		);

	}*/

	/**
	 * Returns time slots
	 *
	 * @return [type] [description]
	 */
	/*public function get_interval_time_slots( $plain = true ) {

		return Time_Slots::prepare_slots_for_js(
			Time_Slots::generate_slots(
				array(
					'to'       => DAY_IN_SECONDS / 2,
					'interval' => 15 * MINUTE_IN_SECONDS,
					'format'   => 'U',
				)
			),
			'G\h i\m\i\n',
			$plain,
			true
		);
	}*/

}