File "WPDA_Simple_Form_Item_Autocomplete.php"

Full Path: /home/vantageo/public_html/cache/cache/cache/cache/cache/cache/.wp-cli/wp-content/plugins/wp-data-access/WPDataAccess/Simple_Form/WPDA_Simple_Form_Item_Autocomplete.php
File size: 5.32 KB
MIME-type: text/x-php
Charset: utf-8

<?php

/**
 * Suppress "error - 0 - No summary was found for this file" on phpdoc generation
 *
 * @package WPDataAccess\Simple_Form
 */

namespace WPDataAccess\Simple_Form {

	use WPDataAccess\Utilities\WPDA_Autocomplete;

	/**
	 * Class WPDA_Simple_Form_Item_Autocomplete
	 *
	 * Adds autocomplete support to input field
	 *
	 * @author  Peter Schulz
	 * @since   4.1.3
	 */
	class WPDA_Simple_Form_Item_Autocomplete extends WPDA_Simple_Form_Item {

		const AUTOCOMPLE_NONCE_ACTION = 'WPDA-AUTO-COMPLETE*';

		protected $autocomplete_def   = null;
		protected $tableform_settings = null;

		protected function show_item() {
			$this->set_item_class( 'wpda_autocomplete_key' );

			parent::show_item();

			if ( null === $this->autocomplete_def ) {
				wp_die( '<span style="font-weight: bold">' . __( 'ERROR: Invalid autocomplete lookup usage', 'wp-data-access' ) . '</span>' );
			}

			$lookup_value = '';

			if ( null !== $this->item_value && '' !== $this->item_value ) {
				// Get lookup value
				$schema_name         = $this->autocomplete_def->target_schema_name;
				$table_name          = $this->autocomplete_def->target_table_name;
				$column_name         = $this->autocomplete_def->target_column_name[0];
				$lookup_column_name  = '';
				$lookup_column_value = $this->item_value;

				foreach ( $this->tableform_settings as $tableform_setting ) {
					if ( $tableform_setting->column_name === $this->autocomplete_def->source_column_name[0] ) {
						$lookup_column_name = $tableform_setting->lookup;
					}
				}
				if ( '' === $lookup_column_name ) {
					wp_die( '<span style="font-weight: bold">' . __( 'ERROR: Invalid autocomplete lookup usage', 'wp-data-access' ) . '</span>' );
				}

				$wpda_autocomplete = new WPDA_Autocomplete();
				$lookup_value      = $wpda_autocomplete->autocomplete_lookup(
					$schema_name,
					$table_name,
					$column_name,
					$lookup_column_name,
					$lookup_column_value
				);

				if ( false === $lookup_value ) {
					echo '<div>Lookup value not found!</div>';
				}
			}

			$placeholder = __( 'Start typing', 'wp-data-access' ) . ' ' . strtolower( $this->get_item_label() ) . '...';
			echo "<input type='text' id='wpda_autocomplete_{$this->get_item_name()}' class='wpda_autocomplete' placeholder='{$placeholder}' value='{$lookup_value}'/>"; // phpcs:ignore WordPress.Security.EscapeOutput

			$this->add_js();
		}

		protected function add_js() {
			$wpnonce = wp_create_nonce( self::AUTOCOMPLE_NONCE_ACTION . $this->autocomplete_def->target_table_name );
			?>
			<script type="text/javascript">
				jQuery(function() {
					let wpda_path = '<?php echo admin_url( 'admin-ajax.php' ); // phpcs:ignore WordPress.Security.EscapeOutput ?>';
					let item_name = '<?php echo esc_attr( $this->get_item_name() ); ?>';

					let autocomplete_def = '<?php echo json_encode( $this->autocomplete_def ); ?>';
					let tableform_settings = '<?php echo json_encode( $this->tableform_settings ); ?>';

					let autocomplete_def_json = jQuery.parseJSON(autocomplete_def);
					let tableform_settings_json = jQuery.parseJSON(tableform_settings);
					let lookup_label_column = '';

					for (i=0; i<tableform_settings_json.length; i++) {
						if (tableform_settings_json[i]['column_name']===item_name) {
							lookup_label_column = tableform_settings_json[i].lookup;
						}
					}

					if (lookup_label_column==='') {
						alert('ERROR: Cannot call autocomplete service [error in definition]');
					} else {
						jQuery('#wpda_autocomplete_' + item_name).autocomplete({
							autoFocus: true,
							source: function (name, response) {
								jQuery.ajax({
									method: 'POST',
									url: wpda_path + '?action=wpda_autocomplete',
									data: {
										wpda_wpnonce: '<?php echo esc_attr( $wpnonce ); ?>',
										wpda_source_column_value: jQuery('#wpda_autocomplete_' + item_name).val(),
										wpda_source_column_name: autocomplete_def_json.source_column_name[0],
										wpda_target_schema_name: autocomplete_def_json.target_schema_name,
										wpda_target_table_name: autocomplete_def_json.target_table_name,
										wpda_target_column_name: autocomplete_def_json.target_column_name[0],
										wpda_lookup_label_column: lookup_label_column
									}
								}).done(
									function (msg) {
										if (msg.status === "error") {
											alert(msg.message);
										} else {
											response(msg.rows);
										}
									}
								).error(
									function (msg) {
										alert('ERROR: Autocomplete service call return an invalid response');
									}
								);
							},
							select: function(e,ui) {
								jQuery('#' + item_name).val(ui.item.lookup);
							},
							change: function(event){
								if (jQuery('#wpda_autocomplete_' + item_name).val()=='') {
									jQuery('#' + item_name).val('');
								}
							},
							classes: {
								"ui-autocomplete": "wpda-autocomplete",
							}
						});
					}
				});
			</script>
			<style type="text/css">
				ul.wpda-autocomplete.ui-widget-content {
					background: white;
					color: inherit;
				}
				ul.wpda-autocomplete li.ui-menu-item .ui-menu-item-wrapper.ui-state-active {
					background: #efefef;
					color: unset;
					border: none;
				}
			</style>
			<?php
		}

		public function set_autocomplete( $autocomplete_def, $tableform_settings ) {
			$this->autocomplete_def   = $autocomplete_def;
			$this->tableform_settings = $tableform_settings;
		}

	}

}