<?php defined( 'ABSPATH' ) || exit;

if ( ! class_exists( 'WP_Sheet_Editor_Columns' ) ) {

	class WP_Sheet_Editor_Columns {

		private static $registered_items     = array();
		private $rejected_items              = array();
		private $prepared_items              = array();
		public static $skip_cache            = false;
		private static $blacklisted_patterns = array();

		function __construct() {
		}

		function has_item( $key, $provider = null ) {
			if ( empty( $provider ) ) {
				$provider = 'post';
			}
			return isset( self::$registered_items[ $provider ][ $key ] );
		}

		/**
		 * Converts php DateTime format to Javascript Moment format.
		 * @param string $php_format
		 * @return string
		 */
		public function convert_php_to_js_format( $php_format ) {
			$replacements = array(
				'A' => 'A', // for the sake of escaping below
				'a' => 'a', // for the sake of escaping below
				'B' => '', // Swatch internet time (.beats), no equivalent
				'c' => 'YYYY-MM-DD[T]HH:mm:ssZ', // ISO 8601
				'D' => 'ddd',
				'd' => 'DD',
				'e' => 'zz', // deprecated since version 1.6.0 of moment.js
				'F' => 'MMMM',
				'G' => 'H',
				'g' => 'h',
				'H' => 'HH',
				'h' => 'hh',
				'I' => '', // Daylight Saving Time? => moment().isDST();
				'i' => 'mm',
				'j' => 'D',
				'L' => '', // Leap year? => moment().isLeapYear();
				'l' => 'dddd',
				'M' => 'MMM',
				'm' => 'MM',
				'N' => 'E',
				'n' => 'M',
				'O' => 'ZZ',
				'o' => 'YYYY',
				'P' => 'Z',
				'r' => 'ddd, DD MMM YYYY HH:mm:ss ZZ', // RFC 2822
				'S' => 'o',
				's' => 'ss',
				'T' => 'z', // deprecated since version 1.6.0 of moment.js
				't' => '', // days in the month => moment().daysInMonth();
				'U' => 'X',
				'u' => 'SSSSSS', // microseconds
				'v' => 'SSS', // milliseconds (from PHP 7.0.0)
				'W' => 'W', // for the sake of escaping below
				'w' => 'e',
				'Y' => 'YYYY',
				'y' => 'YY',
				'Z' => '', // time zone offset in minutes => moment().zone();
				'z' => 'DDD',
			);

			// Converts escaped characters.
			foreach ( $replacements as $from => $to ) {
				$replacements[ '\\' . $from ] = '[' . $from . ']';
			}

			return strtr( $php_format, $replacements );
		}

		function get_blacklisted_column_keywords( $provider ) {
			if ( isset( self::$blacklisted_patterns[ $provider ] ) ) {
				return self::$blacklisted_patterns[ $provider ];
			}
			$blacklisted_keys = apply_filters( 'vg_sheet_editor/columns/blacklisted_columns', array( 'nxs_snap', '_edit_lock', '_edit_last', '_wp_old_slug', '_wpcom_is_markdown', 'vgse_column_sizes', 'wxr_import', '^_oembed', '^\d+_\d+_\d+$', '_user_wished_', '_user_wished_user', '_rehub_views_date', '-wpfoof-', '^_transient_tribe', '_learndash_memberpress_enrolled_courses_access', 'course_\d+_access_from', 'ld_sent_notification_enroll_course_', 'learndash_last_known_course_', 'learndash_group_users_', '_badgeos_achievements_', 'learndash_group_leaders_', 'course_timer_completed_', 'course_completed_', 'screen_layout_', 'enrolled_courses_access_counter_', '_sfwd-quizzes_', '_uo-course-cert-', 'screen_options_per_page', 'gform_recent_forms_', '^manage.+columnshidden_', '^edit_.+_per_page', 'uo_timer_', '_screen_options_default', '_edd_download_limit_override', '_wcj_product_input_fields', 'seopress_pro_rich_snippets', 'seopress_analysis_data', '[a-zA-Z0-9]{28,}$', '_wvs_product_attributes', 'wcml_sync_hash', 'product_tabel_', '_wp_attachment_backup_sizes', '_wp_attached_file', 'thb_postviews_count_', '_wcct_goaldeal_', 'amazonS3_cache_', '_wcct_product_taxonomy_term_ids', '_eg_gallery_data_gallery', '_user_IP', '_wds_readability', 'kc_data_', '_wds_analysis_checks', '_user_liked_', 'wpsebe', '^snap', 'better-related-', '_count-views_', '_ywcp_component_data_list', '_userwish_IP', '_fv_flowplayer_http', '_heateor_sss_shares_meta', '_wpas_skip_', 'cred_user_notification_data', 'googlesitekit_survey_timeouts_', 'yoast_test_helper_notifications', '_mylisting_stats_cache_', 'wpil_links_inbound_internal_count_data', '_et_builder_module_features_cache', 'xts-term' ), $provider, $this );
			if ( ! empty( VGSE()->options['blacklist_columns'] ) ) {
				$blacklisted_keys = array_merge( $blacklisted_keys, array_map( 'trim', explode( ',', VGSE()->options['blacklist_columns'] ) ) );
			}
			self::$blacklisted_patterns[ $provider ] = $blacklisted_keys;
			return self::$blacklisted_patterns[ $provider ];
		}

		function is_column_blacklisted( $key, $provider ) {

			$blacklisted_keys = $this->get_blacklisted_column_keywords( $provider );
			$out              = false;
			// We use preg_match to allow core and other plugins to use advanced
			// conditions and because some fields might have wp prefix
			foreach ( $blacklisted_keys as $blacklisted_field ) {
				// Make sure the blacklisted_field regex doesn't contain / to avoid breaking our regex delimiter
				// $blacklisted_field = str_replace('/', '\/', $blacklisted_field);
				if ( preg_match( '/' . $blacklisted_field . '/', $key ) ) {
					$out = $blacklisted_field;
					break;
				}
			}
			return $out;
		}

		function get_rejections( $provider, $key = null ) {

			if ( ! isset( $this->rejected_items[ $provider ] ) ) {
				$this->rejected_items[ $provider ] = array();
			}
			if ( $key ) {
				$out = isset( $this->rejected_items[ $provider ][ $key ] ) ? $this->rejected_items[ $provider ][ $key ] : array();
			} else {
				$out = $this->rejected_items[ $provider ];
			}
			return $out;
		}

		function add_rejection( $key, $reason, $provider ) {
			if ( empty( $reason ) ) {
				$reason = 'Unknown';
			}

			if ( ! isset( $this->rejected_items[ $provider ] ) ) {
				$this->rejected_items[ $provider ] = array();
			}
			if ( ! isset( $this->rejected_items[ $provider ][ $key ] ) ) {
				$this->rejected_items[ $provider ][ $key ] = array();
			}
			if ( ! in_array( $reason, $this->rejected_items[ $provider ][ $key ], true ) ) {
				$this->rejected_items[ $provider ][ $key ][] = $reason;
			}
		}

		function columns_limit_reached( $provider, $custom_count = null ) {
			$out   = false;
			$count = 0;
			if ( is_int( $custom_count ) ) {
				$count = $custom_count;
			} elseif ( ! empty( self::$registered_items[ $provider ] ) ) {
				$count = count( self::$registered_items[ $provider ] );
			}
			if ( $count > VGSE()->helpers->get_columns_limit() ) {
				$out = true;
			}
			return $out;
		}

		function columns_count( $provider ) {
			return ! empty( self::$registered_items[ $provider ] ) ? count( self::$registered_items[ $provider ] ) : 0;
		}

		/**
		 * Register spreadsheet column
		 * @param string $key
		 * @param string $provider
		 * @param array $args
		 */
		function register_item( $key, $provider = null, $args = array(), $update_existing = false ) {
			if ( is_numeric( $key ) ) {
				return;
			}
			if ( empty( $key ) ) {
				return;
			}

			// JS doesn't support columns with key length
			if ( $key === 'length' ) {
				$this->add_rejection( $key, 'column_key_length_not_supported_by_js', $provider );
				return;
			}

			// If updating existing column, merge new args with existing args. If column doesn't exist, use the new args only
			if ( $update_existing && $this->has_item( $key, $provider ) ) {
				$args = wp_parse_args( $args, $this->get_item( $key, $provider, false, true ) );
			}

			$args['provider'] = $provider;
			$args             = $this->_register_item( $key, $args );

			if ( in_array( $args['type'], array( 'boton_gallery', 'boton_gallery_multiple' ), true ) && ! WP_Sheet_Editor_Helpers::current_user_can( 'upload_files' ) ) {
				$this->add_rejection( $key, 'file_upload_column_rejected_user_without_upload_files_capability', $provider );
				return;
			}

			// Enforce columns limit to avoid performance bottlenecks
			// columns with allow_to_hide=false or columns already registered previously
			// are always allowed to avoid errors during saving.
			if ( $args['allow_to_hide'] && ! $this->has_item( $key, $provider ) && $this->columns_limit_reached( $provider ) && ! $args['skip_columns_limit'] ) {
				$this->add_rejection( $key, 'columns_limit_reached', $provider );
				return;
			}

			$blacklisted = $this->is_column_blacklisted( $key, $provider );
			if ( $args['allow_to_hide'] && $blacklisted && ! $args['skip_blacklist'] ) {
				$this->add_rejection( $key, 'blacklisted_by_pattern : ' . $blacklisted, $provider );
				return;
			}

			// Skip if column doesn't have title
			if ( empty( $args['title'] ) ) {
				$this->add_rejection( $key, 'empty_title', $provider );
				return;
			}
			if ( empty( $provider ) ) {
				$provider = 'post';
			}

			if ( ! isset( self::$registered_items[ $provider ] ) ) {
				self::$registered_items[ $provider ] = array();
			}
			self::$registered_items[ $provider ][ $key ] = $args;
		}

		function remove_item( $key, $provider ) {
			if ( isset( self::$registered_items[ $provider ][ $key ] ) ) {
				$this->add_rejection( $key, 'removed_programmatically', $provider );
				unset( self::$registered_items[ $provider ][ $key ] );
			}
		}

		function _register_item( $key, $args = array() ) {
			$defaults = array(
				'data_type'                                => 'post_data', // (post_data|meta_data|post_terms)
				'column_width'                             => null,
				'title'                                    => trim( ucwords( str_replace( array( '-', '_' ), ' ', $key ) ) ),
				'type'                                     => '', // String boton_gallery|boton_gallery_multiple|view_post|handsontable|metabox|(empty)
				'unformatted'                              => array(), // column args allowed by handsontable
				'formatted'                                => array(), // column args allowed by handsontable
				'export_key'                               => $key,
				'default_value'                            => '',
				// Visibility
				'allow_to_hide'                            => true,
				'skip_blacklist'                           => false,
				'skip_columns_limit'                       => false,
				// Enable features
				'allow_to_rename'                          => true,
				'allow_to_save'                            => true,
				'allow_to_save_sanitization'               => true,
				'allow_plain_text'                         => true,
				'allow_to_import'                          => true,
				'allow_direct_search'                      => true, // We use this to mark fields that can't be searched with the advanced filters
				'allow_search_during_import'               => true, // useful to exclude serialized fields from the import > wp fields dropdown in the step 3
				'is_locked'                                => false, // We'll add a lock icon before the cell value and disable editing
				'lock_template_key'                        => false, // We'll add a lock icon before the cell value and disable editing
				'forced_allow_to_save'                     => null,
				'forced_supports_formulas'                 => null,
				'allow_custom_format'                      => false,
				// Formulas
				'supports_formulas'                        => false,
				'supports_sql_formulas'                    => true,
				'key_for_formulas'                         => $key,
				'supported_formula_types'                  => array(),
				// Callbacks
				'get_value_callback'                       => '', // Callable. We'll use this to get the cell value during all contexts,
				'save_value_callback'                      => '', // Callable. We'll use this to get the cell value during all contexts,
				'prepare_value_for_database'               => '', // Callable. Modify the cell value before it's saved using the normal saving process
				'prepare_value_for_display'                => '', // Callable. Modify the cell value before it's displayed using the normal display process
				// Metabox and handsontable type
				'edit_button_label'                        => null,
				'edit_modal_id'                            => null,
				'edit_modal_title'                         => null,
				'edit_modal_description'                   => null,
				'edit_modal_local_cache'                   => true,
				'edit_modal_save_action'                   => null, // js_function_name:<function name>, <wp ajax action>
				'edit_modal_cancel_action'                 => null,
				// Metabox type
				'metabox_show_selector'                    => null,
				'metabox_value_selector'                   => null,
				// Handsontable type
				'handsontable_columns'                     => array(), // array( 'product' => array( array( 'data' => 'name' ), ) ),
				'handsontable_column_names'                => array(), // array('product' => array('Column name'),),
				'handsontable_column_widths'               => array(), // array('product' => array(160),),
				// Tmp. We use the new handsontable renderer only for _default_attributes for now
				// we will use it for all in the future
				'use_new_handsontable_renderer'            => false,
				// This parameter is used to indicate the separator character that should be
				// used when generating the append, prepend formulas
				'list_separation_character'                => false,
				'custom_sanitization_before_saving'        => null, // Default sanitization is wp_kses_post.
				'user_capabilities_can_read'               => null,
				'user_capabilities_can_edit'               => null,
				'allow_to_prefetch_value'                  => true,
				'prefetch_meta_key'                        => null, // Use for columns with keys different than the db key
				'external_button_template'                 => '',
				'gallery_cell_html_template_readonly'      => null,
				'gallery_cell_html_template_editable'      => null,
				'allow_for_global_sort'                    => true,
				'allow_role_restrictions_in_columns_manager' => true,
				'allow_readonly_option_in_columns_manager' => true,
				'value_type'                               => '', // text, number, email, date, post_terms, boton_gallery, boton_gallery_multiple, view_post, handsontable, metabox
				'allow_numeric_select_value'               => false, // When we save a friendly select, we allow the user to enter the friendly value and we replace it with the value key to save in the database, we only allow string keys but you can enable this if you want to save int keys as the select value
				'checkpoint_field_type'                    => '', // Indicate type of field for checkpoints: post_data, meta, terms, user_data, term_data, columns (if custom table sheet)
				'checkpoint_key'                           => '',
			);

			$args = wp_parse_args( $args, $defaults );

			if ( empty( $args['column_width'] ) ) {
				$args['column_width'] = (int) ( 6.1 * strlen( $args['title'] ) ) + 75;
			}

			if ( empty( $args['key'] ) ) {
				$args['key'] = $key;
			}
			if ( empty( $args['export_key'] ) ) {
				$args['export_key'] = $key;
			}
			if ( in_array( $args['type'], array( 'boton_gallery_multiple' ) ) ) {
				$args['wp_media_multiple'] = true;
			}
			// Disable allow_search_during_import for checkbox and selects
			if ( ( ! empty( $args['formatted']['type'] ) && $args['formatted']['type'] === 'checkbox' ) || ! empty( $args['formatted']['selectOptions'] ) ) {
				$args['allow_search_during_import'] = false;
			}

			if ( in_array( $args['type'], array( 'boton_gallery_multiple', 'boton_gallery' ) ) ) {
				unset( $args['unformatted'] );
				$args['column_width']               = 200;
				$args['formatted']                  = array(
					'data'              => $args['key'],
					'renderer'          => 'wp_media_gallery',
					'wp_media_multiple' => $args['type'] === 'boton_gallery_multiple',
				);
				$args['allow_search_during_import'] = false;
			}
			if ( in_array( $args['type'], array( 'boton_tiny' ) ) ) {
				$args['type'] = '';
				unset( $args['unformatted'] );
				$args['formatted']     = array(
					'data'     => $args['key'],
					'renderer' => 'wp_tinymce',
				);
				$args['allow_to_save'] = true;
			}
			if ( in_array( $args['type'], array( 'metabox', 'handsontable' ) ) ) {
				$args['supports_formulas']          = false;
				$args['allow_plain_text']           = false;
				$args['allow_to_save']              = false;
				$args['allow_search_during_import'] = false;
			}
			if ( in_array( $args['type'], array( 'metabox', 'handsontable' ) ) ) {
				if ( empty( $args['edit_modal_title'] ) ) {
					$args['edit_modal_title'] = $args['title'];
				}
				if ( empty( $args['edit_button_label'] ) ) {
					/* translators: %s: Column label */
					$args['edit_button_label'] = sprintf( esc_html__( 'Edit %s', 'vg_sheet_editor' ), esc_html( $args['title'] ) );
				}
				if ( empty( $args['edit_modal_id'] ) ) {
					$args['edit_modal_id'] = 'vgse-modal-editor-' . wp_generate_password( 5, false );
				}
			}
			if ( in_array( $args['type'], array( 'handsontable' ) ) && $args['use_new_handsontable_renderer'] ) {
				$args['supports_formulas']       = true;
				$args['allow_plain_text']        = true;
				$args['allow_to_save']           = true;
				$args['formatted']['renderer']   = 'wp_handsontable';
				$args['formatted']['readOnly']   = false;
				$args['unformatted']['renderer'] = 'text';
				$args['unformatted']['readOnly'] = false;
			}

			if ( empty( $args['default_title'] ) ) {
				$args['default_title'] = $args['title'];
			}

			// Remove double spaces from column titles, because double spaces are removed by sanitize_text_field and causes column mismatch during import
			$args['title'] = str_replace( '  ', ' ', $args['title'] );

			if ( empty( $args['unformatted'] ) ) {
				$args['unformatted'] = array(
					'data' => $args['key'],
				);
			}
			if ( empty( $args['formatted'] ) ) {
				$args['formatted'] = array(
					'data' => $args['key'],
				);
			}
			if ( empty( $args['formatted']['data'] ) ) {
				$args['formatted']['data'] = $args['key'];
			}
			if ( empty( $args['unformatted']['data'] ) ) {
				$args['unformatted']['data'] = $args['key'];
			}

			if ( empty( $args['value_type'] ) ) {
				if ( ! empty( $args['type'] ) ) {
					$args['value_type'] = $args['type'];
				} elseif ( $args['data_type'] === 'post_terms' ) {
					$args['value_type'] = 'post_terms';
				} elseif ( ! empty( $args['formatted'] ) && ! empty( $args['formatted']['type'] ) && $args['formatted']['type'] === 'checkbox' ) {
					$args['value_type'] = 'checkbox';
				} elseif ( ! empty( $args['formatted'] ) && ! empty( $args['formatted']['type'] ) && $args['formatted']['type'] === 'date' ) {
					$args['value_type'] = 'date';
				} else {
					$args['value_type'] = 'text';
				}
			}

			if ( ! empty( $args['data_type'] ) && $args['data_type'] === 'post_terms' ) {
				$args['allow_search_during_import'] = false;
			}

			// post_meta is an alias of meta_data
			if ( $args['data_type'] === 'post_meta' ) {
				$args['data_type'] = 'meta_data';
			}

			if ( ! $args['allow_to_save'] && $args['allow_to_save_sanitization'] ) {
				$args['formatted']['renderer']   = 'html';
				$args['formatted']['readOnly']   = true;
				$args['unformatted']['renderer'] = 'html';
				$args['unformatted']['readOnly'] = true;
			}
			if ( in_array( $args['type'], array( 'external_button' ) ) ) {
				$args['allow_search_during_import'] = false;
				$args['formatted']['renderer']      = 'wp_external_button';
				$args['formatted']['readOnly']      = true;
				$args['unformatted']['renderer']    = 'wp_external_button';
				$args['unformatted']['readOnly']    = true;
				$args['data_type']                  = null;
			}
			if ( $args['is_locked'] ) {
				$args = self::_make_column_read_only( $args, false );
			}
			if ( is_bool( $args['forced_allow_to_save'] ) ) {
				$args['formatted']['readOnly']   = ! $args['forced_allow_to_save'];
				$args['unformatted']['readOnly'] = ! $args['forced_allow_to_save'];
			}
			if ( is_bool( $args['forced_supports_formulas'] ) ) {
				$args['supports_formulas'] = $args['forced_supports_formulas'];
			}
			// Enable the friendly select cells if this column contains selectOptions and
			// selectOptions is not a callback and this wasn't disabled in the advanced settings
			if ( empty( VGSE()->options['enable_plain_select_cells'] ) && empty( $args['is_locked'] ) && ! empty( $args['formatted']['selectOptions'] ) && is_array( $args['formatted']['selectOptions'] ) && ! is_callable( $args['formatted']['selectOptions'] ) ) {
				$args['formatted']['renderer'] = 'wp_friendly_select';
			}
			if ( ! empty( $args['formatted']['selectOptions'] ) && ! is_callable( $args['formatted']['selectOptions'] ) ) {
				$args['formatted']['selectOptions'] = array_map( 'wp_filter_nohtml_kses', $args['formatted']['selectOptions'] );
			}

			return $args;
		}

		/**
		 * Get all spreadsheet columns
		 * @return array
		 */
		function get_items( $skip_filters = false ) {
			// Order columns by default, to show the enabled columns first and locked columns after
			foreach ( self::$registered_items as $post_type => $columns ) {
				$enabled_columns    = wp_list_filter(
					$columns,
					array(
						'lock_template_key' => 'lock_cell_template_pro',
					),
					'NOT'
				);
				$locked_pro_columns = wp_list_filter(
					$columns,
					array(
						'lock_template_key' => 'lock_cell_template_pro',
					)
				);

				self::$registered_items[ $post_type ] = array_merge( $enabled_columns, $locked_pro_columns );
			}

			self::$registered_items = $this->_enforce_unique_titles( self::$registered_items );

			$spreadsheet_columns = ( $skip_filters ) ? self::$registered_items : apply_filters( 'vg_sheet_editor/columns/all_items', self::$registered_items );

			// We run this after the hook to allow other modules/plugins to change the args
			$spreadsheet_columns = self::_filter_by_require_capabilities( $spreadsheet_columns );

			$spreadsheet_columns = $this->_convert_date_formats( $spreadsheet_columns );

			// We do this twice because other modules might modify titles through the filter and
			// some modules also use the initial value to display unfiltered columns
			$spreadsheet_columns = $this->_enforce_unique_titles( $spreadsheet_columns );

			// Detect registered columns that were filtered out
			foreach ( self::$registered_items as $post_type => $columns ) {
				foreach ( $columns as $key => $column ) {
					if ( ! isset( $spreadsheet_columns[ $post_type ] ) || ! isset( $spreadsheet_columns[ $post_type ][ $key ] ) ) {
						$this->add_rejection( $key, 'removed_with_filter:all_items', $post_type );
					}
				}
			}

			return $spreadsheet_columns;
		}

		function _convert_date_formats( $spreadsheet_columns ) {

			foreach ( $spreadsheet_columns as $post_type => $columns ) {
				foreach ( $columns as $column_key => $column ) {

					if ( ! empty( $column['formatted']['customDatabaseFormat'] ) ) {
						$spreadsheet_columns[ $post_type ][ $column_key ]['formatted']['customDatabaseFormatJs'] = $this->convert_php_to_js_format( $column['formatted']['customDatabaseFormat'] );
					}
					if ( ! empty( $column['formatted']['dateFormatPhp'] ) ) {
						$spreadsheet_columns[ $post_type ][ $column_key ]['formatted']['dateFormatJs'] = $this->convert_php_to_js_format( $column['formatted']['dateFormatPhp'] );
						$spreadsheet_columns[ $post_type ][ $column_key ]['formatted']['dateFormat']   = $spreadsheet_columns[ $post_type ][ $column_key ]['formatted']['dateFormatJs'];
					}
				}
			}
			return $spreadsheet_columns;
		}

		function _enforce_unique_titles( $spreadsheet_columns ) {
			// Make sure all the column titles are unique, append a number if needed, useful during imports
			foreach ( $spreadsheet_columns as $post_type => $columns ) {
				$post_type_titles = array_fill_keys( array_map( 'strtolower', wp_list_pluck( $columns, 'title' ) ), 0 );
				foreach ( $columns as $key => $column ) {
					if ( empty( $column['title'] ) ) {
						continue;
					}
					$column_title = strtolower( $column['title'] );
					++$post_type_titles[ $column_title ];
					if ( $post_type_titles[ $column_title ] > 1 ) {
						$spreadsheet_columns[ $post_type ][ $key ]['title'] .= ' ' . $post_type_titles[ $column_title ];
					}
				}
			}
			return $spreadsheet_columns;
		}

		static function _make_column_read_only( $column, $set_supports_formulas = true ) {
			$column['is_locked'] = true;
			if ( ! empty( VGSE()->options['dont_show_readonly_columns_in_advanced_search'] ) ) {
				$column['allow_direct_search'] = false;
			}
			if ( $set_supports_formulas ) {
				$column['supports_formulas'] = false;
			}
			$column['formatted']['readOnly']   = true;
			$column['unformatted']['readOnly'] = true;
			if ( empty( $column['formatted']['renderer'] ) || strpos( $column['formatted']['renderer'], 'wp_' ) === false ) {
				$column['formatted']['renderer'] = 'wp_locked';
			}
			if ( empty( $column['unformatted']['renderer'] ) || strpos( $column['unformatted']['renderer'], 'wp_' ) === false ) {
				$column['unformatted']['renderer'] = 'wp_locked';
			}
			return $column;
		}

		static function _get_column_args_keys( $columns ) {
			$keys = array();

			foreach ( $columns as $column ) {
				$keys = array_unique( array_merge( $keys, array_keys( $column ) ) );
			}

			return array_values( $keys );
		}
		static function _filter_by_require_capabilities( $spreadsheet_columns ) {
			foreach ( $spreadsheet_columns as $post_type => $columns ) {
				$all_columns = json_encode( self::_get_column_args_keys( $columns ) );

				// Skip if the columns don't have any reference to user_capabilities_can_edit or user_capabilities_can_read
				if ( ! preg_match( '/user_capabilities_can_edit|user_capabilities_can_read/', $all_columns ) ) {
					continue;
				}
				foreach ( $columns as $key => $column ) {
					if ( ! empty( $column['user_capabilities_can_read'] ) && ! WP_Sheet_Editor_Helpers::current_user_can( $column['user_capabilities_can_read'] ) ) {
						unset( $spreadsheet_columns[ $post_type ][ $key ] );
						continue;
					}

					if ( ! empty( $column['user_capabilities_can_edit'] ) && ! WP_Sheet_Editor_Helpers::current_user_can( $column['user_capabilities_can_edit'] ) ) {
						$spreadsheet_columns[ $post_type ][ $key ] = self::_make_column_read_only( $spreadsheet_columns[ $post_type ][ $key ] );
						continue;
					}
				}
			}
			return $spreadsheet_columns;
		}

		/**
		 * Get individual spreadsheet column
		 * @return array
		 */
		function get_item( $item_key, $provider = 'post', $run_callbacks = false, $skip_filters = false ) {
			$items = $this->get_provider_items( $provider, $run_callbacks, $skip_filters );
			if ( isset( $items[ $item_key ] ) ) {
				return $items[ $item_key ];
			} else {
				return false;
			}
		}

		function _remove_callbacks_on_items( $items ) {
			if ( empty( $items ) || ! is_array( $items ) ) {
				return array();
			}
			foreach ( $items as $column_key => $column_args ) {
				if ( isset( $column_args['formatted'] ) ) {
					if ( isset( $column_args['formatted']['selectOptions'] ) && is_callable( $column_args['formatted']['selectOptions'] ) ) {
						$items[ $column_key ]['formatted']['selectOptions'] = array();
					}
					if ( isset( $column_args['formatted']['source'] ) && is_callable( $column_args['formatted']['source'] ) ) {
						$items[ $column_key ]['formatted']['source'] = array();
					}
				}
			}
			return $items;
		}

		function _run_callbacks_on_items( $items ) {
			if ( empty( $items ) || ! is_array( $items ) ) {
				return array();
			}
			foreach ( $items as $column_key => $column_args ) {
				if ( isset( $column_args['formatted'] ) ) {
					if ( empty( $column_args['formatted']['callback_args'] ) ) {
						$column_args['formatted']['callback_args'] = array();
					}
					if ( isset( $column_args['formatted']['selectOptions'] ) && is_callable( $column_args['formatted']['selectOptions'] ) ) {
						$items[ $column_key ]['formatted']['selectOptions'] = array_map( 'html_entity_decode', call_user_func_array( $column_args['formatted']['selectOptions'], $column_args['formatted']['callback_args'] ) );
					}
					if ( isset( $column_args['formatted']['source'] ) && is_callable( $column_args['formatted']['source'] ) ) {
						$items[ $column_key ]['formatted']['source'] = call_user_func_array( $column_args['formatted']['source'], $column_args['formatted']['callback_args'] );
					}
					if ( isset( $column_args['formatted']['chosenOptions'] ) && isset( $column_args['formatted']['source'] ) && is_callable( $column_args['formatted']['source'] ) ) {
						$data       = call_user_func_array( $column_args['formatted']['source'], $column_args['formatted']['callback_args'] );
						$final_data = array();
						foreach ( $data as $term_name ) {
							$final_data[] = array(
								'id'    => $term_name,
								'label' => $term_name,
							);
						}
						$items[ $column_key ]['formatted']['chosenOptions']['data'] = $final_data;
					}
				}
			}
			return $items;
		}

		function clear_cache( $provider ) {
			if ( isset( $this->prepared_items[ $provider ] ) ) {
				unset( $this->prepared_items[ $provider ] );
			}
			if ( isset( $this->prepared_items[ $provider . '1' ] ) ) {
				unset( $this->prepared_items[ $provider . '1' ] );
			}
			if ( isset( $this->prepared_items[ $provider . '0' ] ) ) {
				unset( $this->prepared_items[ $provider . '0' ] );
			}
		}

		/**
		 * Get all spreadsheet columns by post type
		 * @return array
		 */
		function get_provider_items( $provider, $run_callbacks = false, $skip_filters = false ) {
			if ( isset( $this->prepared_items[ $provider . $skip_filters ] ) && ! self::$skip_cache ) {
				$out = $this->prepared_items[ $provider . $skip_filters ];
			} else {
				$items = $this->get_items( $skip_filters );
				$out   = array();
				if ( isset( $items[ $provider ] ) ) {
					$out = $items[ $provider ];
				}
				if ( ! self::$skip_cache ) {
					$this->prepared_items[ $provider . $skip_filters ] = $out;
				}
			}

			if ( $run_callbacks ) {
				$out = $this->_run_callbacks_on_items( $out );
			}
			$original = array_keys( $out );
			$out      = apply_filters( 'vg_sheet_editor/columns/provider_items', $out, $provider, $run_callbacks, $this );

			if ( count( $out ) < $original ) {
				foreach ( $original as $key ) {
					if ( ! isset( $out[ $key ] ) ) {
						$this->add_rejection( $key, 'removed_with_filter:provider_items', $provider );
					}
				}
			}
			return $out;
		}

		function __set( $name, $value ) {
			$this->$name = $value;
		}

		function __get( $name ) {
			return $this->$name;
		}
	}

}
