<?php
/**
 * Plugin generic functions file
 *
 * @package WebCodexWorld Events Manager
 * @since 1.0.0
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly
}

/**
 * Create table for event submissions
 * 
 * @since 1.0.0
 */
function em_wcw_create_db_tables() {

	global $wpdb, $charset_collate;

	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );

	$sql = "CREATE TABLE ".EM_WCW_EVENTS_TBL." (
		id bigint(20) NOT NULL AUTO_INCREMENT,
		event_id bigint(20) NOT NULL,
		event_type text NOT NULL,
		all_day_event bigint(20) NOT NULL,
		user_id bigint(20) NOT NULL,
		venue_id bigint(20) NOT NULL,
		organizer_id text NOT NULL,
		cat_id text NOT NULL,
		tag_id text NOT NULL,
		event_status text NOT NULL,
		post_status text NOT NULL,
		start_date datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
		end_date datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
		hide_from_listing bigint(20) NOT NULL,
		featured bigint(20) NOT NULL,
		created_date datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
		modified_date datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
		PRIMARY KEY  (id)
	)  $charset_collate";

	dbDelta( $sql );
}

/**
 * Clean variables using sanitize_text_field. Arrays are cleaned recursively.
 * Non-scalar values are ignored.
 * 
 * @since 1.0.0
 */
function em_wcw_clean( $var ) {
	if ( is_array( $var ) ) {
		return array_map( 'em_wcw_clean', $var );
	} else {
		$data = is_scalar( $var ) ? sanitize_text_field( $var ) : $var;
		return wp_unslash( $data );
	}
}

/**
 * Sanitize number value and return fallback value if it is blank
 * 
 * @since 1.0.0
 */
function em_wcw_clean_number( $var, $fallback = null, $type = 'int' ) {

	// An attacker can send array-valued request data for a field that is normally a scalar
	// (e.g. field[]=1). Reject that here instead of letting it reach trim()/abs() below,
	// which would otherwise throw a TypeError.
	if ( is_array( $var ) ) {
		return isset( $fallback ) ? $fallback : 0;
	}

	$var = trim( $var );

	if( $type == 'int' ) {
		$data = absint( $var );
	} elseif ( $type == 'number' ) {
		$data = intval( $var );
	} else {
		$data = abs( $var );
	}

	return ( empty($data) && isset($fallback) ) ? $fallback : $data;
}

/**
 * Sanitize url
 * 
 * @since 1.0.0
 */
function em_wcw_clean_url( $url ) {
	if ( is_array( $url ) ) {
		return '';
	}
	return esc_url_raw( trim( $url ) );
}

/**
 * Sanitize phone value allowing only +, digits and spaces.
 *
 * @since 1.0.0
 */
function em_wcw_clean_phone( $phone ) {
	$phone = is_string( $phone ) ? wp_unslash( $phone ) : '';
	$phone = preg_replace( '/[^0-9+\s]/', '', $phone );
	$phone = preg_replace( '/\s+/', ' ', trim( $phone ) );
	return $phone;
}

/**
 * Sanitize Hex Color
 * 
 * @since 1.0.0
 */
function em_wcw_clean_color( $color, $fallback = null ) {

	if ( is_array( $color ) ) {
		return isset( $fallback ) ? $fallback : '';
	}

	if ( false === strpos( $color, 'rgb' ) ) {

		$data = sanitize_hex_color( $color );

	} else {

		$red	= 0;
		$green	= 0;
		$blue	= 0;
		$alpha	= 0.5;

		// By now we know the string is formatted as an rgba color so we need to further sanitize it.
		$color = str_replace( ' ', '', $color );
		
		// If rgba color else we treat it as rgb
		if( false !== strpos( $color, 'rgba' ) ) {
			
			sscanf( $color, 'rgba(%d,%d,%d,%f)', $red, $green, $blue, $alpha );
			$data = 'rgba('.$red.','.$green.','.$blue.','.$alpha.')';
			
		} else {
			
			sscanf( $color, 'rgb(%d,%d,%d)', $red, $green, $blue );
			$data = 'rgb('.$red.','.$green.','.$blue.')';
		}
	}

	return ( empty( $data ) && $fallback ) ? $fallback : $data;
}

/**
 * Allow Valid Html Tags
 * It will sanitize HTML (strip script and style tags)
 *
 * @since 1.0.0
 */
function em_wcw_clean_html( $data = array() ) {

	if ( is_array( $data ) ) {

		$data = array_map( 'em_wcw_clean_html', $data );

	} elseif ( is_string( $data ) ) {
		$data = trim( $data );
		$data = wp_kses_post( $data );
	}

	return $data;
}

/**
 * Sanitize multiple HTML classes
 * 
 * @since 1.0.0
 */
function em_wcw_sanitize_html_classes( $classes, $sep = " " ) {
	$return = "";

	if( ! is_array($classes) ) {
		$classes = explode($sep, $classes);
	}

	if( ! empty($classes) ) {
		foreach($classes as $class) {
			$return .= sanitize_html_class($class) . " ";
		}
		$return = trim( $return );
	}

	return $return;
}

/**
 * Sanitize permalink values before insertion into DB.
 * Cannot use em_wcw_clean because it sometimes strips % chars and breaks the user's setting.
 *
 * @since 1.0.0
 */
function em_wcw_clean_permalink( $value ) {
	global $wpdb;

	if ( is_array( $value ) ) {
		return '';
	}

	$value = $wpdb->strip_invalid_text_for_column( $wpdb->options, 'option_value', $value ?? '' );

	if ( is_wp_error( $value ) ) {
		$value = '';
	}

	$value = esc_url_raw( trim( $value ) );
	$value = str_replace( 'http://', '', $value );
	return untrailingslashit( $value );
}

/**
 * Function to add array after specific key
 * 
 * @since 1.0.0
 */
function em_wcw_add_array(&$array, $value, $index, $from_last = false) {

	if( is_array($array) && is_array($value) ) {

		if( $from_last ) {
			$total_count    = count($array);
			$index          = (!empty($total_count) && ($total_count > $index)) ? ($total_count-$index): $index;
		}

		$split_arr  = array_splice($array, max(0, $index));
		$array      = array_merge( $array, $value, $split_arr);
	}
	return $array;
}

/**
 * Function to unique number value
 * 
 * @since 1.0.0
 */
function em_wcw_get_unique() {
	static $unique = 0;
	$unique++;

	// For VC front end editing
	if ( ( function_exists('vc_is_page_editable') && vc_is_page_editable() )
		 || ( defined('ELEMENTOR_PLUGIN_BASE') && isset( $_POST['action'] ) && $_POST['action'] == 'elementor_ajax' && isset($_POST['editor_post_id']) )
		)
	{
		return wp_rand() .'-'. current_time( 'timestamp' );
	}

	return $unique;
}

/**
 * Convert color hex value to rgb format
 * 
 * @since 1.0.0
 */
function em_wcw_hex2rgb( $hex = '', $format = 'string' ) {

	if( empty($hex) ) return false;

	$hex = str_replace("#", "", $hex);

	if(strlen($hex) == 3) {
		$r = hexdec(substr($hex,0,1).substr($hex,0,1));
		$g = hexdec(substr($hex,1,1).substr($hex,1,1));
		$b = hexdec(substr($hex,2,1).substr($hex,2,1));
	} else {
		$r = hexdec(substr($hex,0,2));
		$g = hexdec(substr($hex,2,2));
		$b = hexdec(substr($hex,4,2));
	}

	$rgb = array($r, $g, $b);

	if( $format == 'string' ) {
		$rgb = implode(",", $rgb);
	}

	return $rgb;
}

/**
 * Converts a string (e.g. 'yes' or 'no') to a bool.
 *
 * @since 1.0.0
 * @param string|bool $string String to convert. If a bool is passed it will be returned as-is.
 * @return bool
 */
function em_wcw_string_to_bool( $string ) {
	if ( is_array( $string ) ) {
		return false;
	}
	$string = $string ? trim( $string ) : '';
	return is_bool( $string ) ? $string : ( 'yes' === strtolower( $string ) || 1 === $string || 'true' === strtolower( $string ) || '1' === $string );
}

/**
 * Function to validate that public script should be enqueue at last.
 * Call this function at last.
 * 
 * @since 1.0.0
 */
function em_wcw_enqueue_script() {

	// Check public script is in queue
	if( wp_script_is( 'em-wcw-public', 'enqueued' ) ) {
		
		// Dequeue Script
		wp_dequeue_script( 'em-wcw-public' );

		// Enqueue Script
		wp_enqueue_script( 'em-wcw-public' );
	}
}