<?php

/**
 * WP Product Feed Support Class.
 *
 * @package WP Product Feed Manager/Application/Classes
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit;
}


if ( ! class_exists( 'WPPFM_Feed_Support' ) ) :

	/**
	 * Feed Support Class.
	 */
	class WPPFM_Feed_Support {

		/**
		 * Extract the query string from an object with query strings.
		 *
		 * @param object $query_object an object containing a query string.
		 *
		 * @return string|boolean with the query string or false if no string is found.
		 */
		public function get_query_string_from_query_object( $query_object ) {
			// TODO: There's probably a better way to do this!
			foreach ( $query_object as $value ) {
				return $value;
			}

			return false;
		}

		/**
		 * Extracts the database column title that is used for a specific feed field name, from the relation table.
		 *
		 * @param string $feed_name       the field name.
		 * @param array  $relations_table the relation table.
		 *
		 * @return string the database column title.
		 */
		public function get_db_column_title( $feed_name, $relations_table ) {
			$result = '';

			foreach ( $relations_table as $relation ) {
				if ( $relation['field'] === $feed_name ) {
					$result = $relation['db'];
					break;
				}
			}

			/** @noinspection PhpUnusedLocalVariableInspection */
			$relations_table = null;

			return $result;
		}

		/**
		 * Returns the category id of a specific categorie if it is selected in the category mapping table. Returns false if the category is not selected.
		 *
		 * @param int    $term_id          the id of the category.
		 * @param object $category_mapping the category mapping object
		 *
		 * @return false|int the category id or false if the category is not selected.
		 */
		public function selected_category_id( $term_id, $category_mapping ) {
			for ( $i = 0; $i < count( (array)$category_mapping ); $i ++ ) {
				if ( (string) $term_id === $category_mapping[ $i ]->shopCategoryId ) {
					return $i;
				}
			}

			return false;
		}

		/**
		 * Runs a query on a specific product and returns true of that query is true for that product.
		 *
		 * @param array $query_split  contains the query data.
		 * @param array $product_data contains the product data.
		 *
		 * @return bool true if the query is true for this product.
		 */
		public function check_query_result_on_specific_row( $query_split, $product_data ) {
			$queries_class = new WPPFM_Feed_Queries;
			$current_data  = key_exists( $query_split[1], $product_data ) ? $product_data[ $query_split[1] ] : '';

			// @since 2.24.0
			if ( '_weight' === $query_split[1] ) {
				$current_data = $this->format_weight_value( $current_data );
			}

			// The following attributes can or will contain an array so suppress the type warning for these attributes.
			$suppress_type_warning_attributes = apply_filters(
				'wppfm_suppress_type_warning_attributes',
				array(
					'_wp_attachement_metadata',
				)
			);

			if ( is_array( $current_data ) && ! in_array( $query_split[1], $suppress_type_warning_attributes ) ) { // A user had this once where he had an attribute that only showed "Array()"  as value.
				$product_id    = key_exists( 'ID', $product_data ) ? $product_data['ID'] : 'unknown';
				$product_title = key_exists( 'post_title', $product_data ) ? $product_data['post_title'] : 'unknown';

				$error_message = "There is something wrong with the '" . $query_split[1] . "' attribute of product '$product_title' with id $product_id. It seems to be of a wrong type.";

				wppfm_write_log_file( $error_message );

				$current_data = $current_data[0];
			}

			$result = true;

			switch ( $query_split[2] ) {
				case 0: // includes
					$result = $queries_class->includes_query( $query_split, $current_data );
					break;

				case 1: // does not include
					$result = $queries_class->does_not_include_query( $query_split, $current_data );
					break;

				case 2: // is equal to
					$result = $queries_class->is_equal_to_query( $query_split, $current_data );
					break;

				case 3: // is not equal to
					$result = $queries_class->is_not_equal_to_query( $query_split, $current_data );
					break;

				case 4: // is empty
					$result = $queries_class->is_empty( $current_data );
					break;

				case 5: // is not empty
					$result = $queries_class->is_not_empty_query( $current_data );
					break;

				case 6: // starts with
					$result = $queries_class->starts_with_query( $query_split, $current_data );
					break;

				case 7: // does not start with
					$result = $queries_class->does_not_start_with_query( $query_split, $current_data );
					break;

				case 8: // ends with
					$result = $queries_class->ends_with_query( $query_split, $current_data );
					break;

				case 9: // does not end with
					$result = $queries_class->does_not_end_with_query( $query_split, $current_data );
					break;

				case 10: // is greater than
					$result = $queries_class->is_greater_than_query( $query_split, $current_data );
					break;

				case 11: // is greater or equal to
					$result = $queries_class->is_greater_or_equal_to_query( $query_split, $current_data );
					break;

				case 12: // is smaller than
					$result = $queries_class->is_smaller_than_query( $query_split, $current_data );
					break;

				case 13: // is smaller or equal to
					$result = $queries_class->is_smaller_or_equal_to_query( $query_split, $current_data );
					break;

				case 14: // is between
					$result = $queries_class->is_between_query( $query_split, $current_data );
					break;

				default:
					break;
			}

			return $result;
		}

		/**
		 * Performs the "edit value" action on a feed value.
		 *
		 * @param string $current_value                the current value of the attribute.
		 * @param string $edit_string                  a string containing the edit value query.
		 * @param string $combination_string           a string containing combination values.
		 * @param array|string $combined_data_elements an array with combined data elements or an empty string to be used in recalculation queries.
		 * @param string $feed_language                selected Language in WPML add-on, leave empty if no exchange rate correction is required.
		 * @param string $feed_currency                selected currency in WOOCS add-on, leave empty if no correction is required.
		 *
		 * @return string Result of the edit value query.
		 */
		public function edit_value( $current_value, $edit_string, $combination_string, $combined_data_elements, $feed_language, $feed_currency ) {
			$value_editors = new WPPFM_Feed_Value_Editors;

			$query_split = explode( '#', $edit_string );

			// Heuristic: if the action is remove and the rule ends with '##' but the removal token
			// became empty due to splitting, assume the user intended to remove a literal '#'.
			// @since 3.17.0.
			if ( count( $query_split ) >= 3 && 'remove' === $query_split[1] && '' === $query_split[2] ) {
				if ( substr( $edit_string, -2 ) === '##' ) {
					$query_split[2] = '#';
				}
			}

			switch ( $query_split[1] ) {
				case 'change nothing':
					$result = $current_value;
					break;

				case 'overwrite':
					$result = $value_editors->overwrite_value( $query_split );
					break;

				case 'replace':
					$result = $value_editors->replace_value( $query_split, $current_value );
					break;

				case 'remove':
					$result = $value_editors->remove_value( $query_split, $current_value );
					break;

				case 'add prefix':
					$result = $value_editors->add_prefix_value( $query_split, $current_value );
					break;

				case 'add suffix':
					$result = $value_editors->add_suffix_value( $query_split, $current_value );
					break;

				case 'recalculate':
					$result = $value_editors->recalculate_value( $query_split, $current_value, $combination_string, $combined_data_elements, $feed_language, $feed_currency );
					break;

				case 'convert to child-element':
					$result = $value_editors->convert_to_child_element( $query_split, $current_value );
					break;

				case 'strip tags':
					$result = $value_editors->strip_tags_from_value( $current_value );
					break;

				// @since 2.34.0.
				case 'html entity decode':
					$result = $value_editors->html_entity_decode_value( $current_value );
					break;

				// @since 3.16.0.
				case 'html entity encode':
					$result = $value_editors->html_entity_encode_value( $current_value );
					break;

				case 'limit characters':
					$result = $value_editors->limit_characters_value( $query_split, $current_value );
					break;

				default:
					$result = false;
					break;
			}

			return $result;
		}

		/**
		 * Extracts the column names from the feed filter array.
		 *
		 * @param object $feed_filter_array the feed filter array, containing Feed Filter data strings.
		 *
		 * @return array with column names used in the Feed Filter.
		 */
		public function get_column_names_from_feed_filter_array( $feed_filter_array ) {
			$empty_array  = array();
			$filters      = $feed_filter_array ? json_decode( $feed_filter_array[0]['meta_value'] ) : $empty_array;
			$column_names = array();

			foreach ( $filters as $filter ) {
				$query_string = $this->get_query_string_from_query_object( $filter );
				$query_parts  = explode( '#', $query_string );

				$column_names[] = $query_parts[1];
			}

			return $column_names;
		}

		/**
		 * makes a unique feed name for a copy of an existing feed.
		 *
		 * @param string $current_feed_name the name of the current feed.
		 *
		 * @return string containing a unique feed name.
		 */
		public function next_unique_feed_name( $current_feed_name ) {
			$queries_class = new WPPFM_Queries();

			$title_end = explode( '_', $current_feed_name );
			$end_nr    = end( $title_end );

			if ( count( $title_end ) > 1 && is_numeric( $end_nr ) ) {
				$new_title = substr_replace( $current_feed_name, ( $end_nr + 1 ), - strlen( $end_nr ) );
			} else {
				$new_title = $current_feed_name . '_1';
				$end_nr    = '1';
			}

			// increase the end number of the title already exists
			while ( $queries_class->title_exists( $new_title ) ) {
				$new_title = substr_replace( $new_title, ( $end_nr + 1 ), - strlen( $end_nr ) );
				$end_nr ++;
			}

			return $new_title;
		}

		/**
		 * Adds multiple single draft image urls to the product, specific for the Ricardo.ch channel.
		 *
		 * @since 1.9.0
		 *
		 * @param array $product reference to the product placeholder.
		 * @param array $images
		 */
		public function process_ricardo_draft_images( &$product, $images ) {
			for ( $i = 0; $i < 10; $i ++ ) {
				$product["DraftImages[$i]"] = $images[ $i ] ?? '';
			}
		}

		/**
		 * Corrects issues where the active list is not the same as the data keys.
		 *
		 * @since 1.9.0
		 *
		 * @param array $active_fields reference to the array with active fields.
		 */
		public function correct_active_fields_list( &$active_fields ) {
			// correct for draft images in Ricardo.ch feed
			if ( ( $key = array_search( 'DraftImages', $active_fields ) ) !== false ) {
				unset( $active_fields[ $key ] );
				for ( $i = 0; $i < 10; $i ++ ) {
					$active_fields[] = "DraftImages[$i]";
				}
			}
		}

		/**
		 * The Weight data of a WooCommerce product always uses a period as decimal separator, independent of the WC price decimal separator
		 * setting. This function will convert a weight value to a format with the correct decimal separator for calculations.
		 *
		 * @since 2.24.0
		 *
		 * @param $weight
		 *
		 * @return string with the formatted weight.
		 */
		private function format_weight_value( $weight )
		{
			if ( ',' === wc_get_price_decimal_separator() ) {
				return str_replace( '.', ',', $weight );
			} else {
				return $weight;
			}
		}

	}

	// end of WPPFM_Feed_Support

endif;