insideout10 / wordlift-plugin

src/wordlift/mappings/class-taxonomy-option.php

Indentation +45 added lines, -45 removed lines

@@ -15,64 +15,64 @@
  */
 class Taxonomy_Option {
 
-	/**
-	 * This value is used in rule field one and rule field two
-	 * options are linked to one by this value
-	 */
-	const PARENT_VALUE = 'taxonomy';
+    /**
+     * This value is used in rule field one and rule field two
+     * options are linked to one by this value
+     */
+    const PARENT_VALUE = 'taxonomy';
 
-	public function add_taxonomy_option() {
-		$this->add_rule_field_one_options();
-		$this->add_rule_field_two_options();
-	}
+    public function add_taxonomy_option() {
+        $this->add_rule_field_one_options();
+        $this->add_rule_field_two_options();
+    }
 
-	private function add_rule_field_one_options() {
+    private function add_rule_field_one_options() {
 
-		add_filter(
-			'wl_mappings_rule_field_one_options',
-			function ( $rule_field_one_options ) {
+        add_filter(
+            'wl_mappings_rule_field_one_options',
+            function ( $rule_field_one_options ) {
 
-				$rule_field_one_options[] = array(
-					'label'      => __( 'Taxonomy', 'wordlift' ),
-					'value'      => Taxonomy_Option::PARENT_VALUE,
-					// Left empty since these values are provided locally, not needed to be fetched from
-					// api.
-					'api_source' => '',
-				);
+                $rule_field_one_options[] = array(
+                    'label'      => __( 'Taxonomy', 'wordlift' ),
+                    'value'      => Taxonomy_Option::PARENT_VALUE,
+                    // Left empty since these values are provided locally, not needed to be fetched from
+                    // api.
+                    'api_source' => '',
+                );
 
-				return $rule_field_one_options;
+                return $rule_field_one_options;
 
-			}
-		);
-	}
+            }
+        );
+    }
 
-	private function add_rule_field_two_options() {
+    private function add_rule_field_two_options() {
 
-		add_filter(
-			'wl_mappings_rule_field_two_options',
-			function ( $rule_field_two_options ) {
+        add_filter(
+            'wl_mappings_rule_field_two_options',
+            function ( $rule_field_two_options ) {
 
-				$taxonomies = get_object_taxonomies( 'post', 'objects' );
+                $taxonomies = get_object_taxonomies( 'post', 'objects' );
 
-				$taxonomy_options = array();
+                $taxonomy_options = array();
 
-				foreach ( $taxonomies as $item ) {
-					/**
-					 * $item Taxonomy
-					 */
-					$taxonomy_options[] = array(
-						'label'        => $item->label,
-						'value'        => $item->name,
-						// The value of parent option on rule field one.
-						'parent_value' => Taxonomy_Option::PARENT_VALUE,
-					);
-				}
+                foreach ( $taxonomies as $item ) {
+                    /**
+                     * $item Taxonomy
+                     */
+                    $taxonomy_options[] = array(
+                        'label'        => $item->label,
+                        'value'        => $item->name,
+                        // The value of parent option on rule field one.
+                        'parent_value' => Taxonomy_Option::PARENT_VALUE,
+                    );
+                }
 
-				return array_merge( $rule_field_two_options, $taxonomy_options );
+                return array_merge( $rule_field_two_options, $taxonomy_options );
 
-			}
-		);
+            }
+        );
 
-	}
+    }
 
 }

Spacing +6 added lines, -6 removed lines

@@ -30,10 +30,10 @@ 
 
 		add_filter(
 			'wl_mappings_rule_field_one_options',
-			function ( $rule_field_one_options ) {
+			function($rule_field_one_options) {
 
 				$rule_field_one_options[] = array(
-					'label'      => __( 'Taxonomy', 'wordlift' ),
+					'label'      => __('Taxonomy', 'wordlift'),
 					'value'      => Taxonomy_Option::PARENT_VALUE,
 					// Left empty since these values are provided locally, not needed to be fetched from
 					// api.
@@ -50,13 +50,13 @@ 
 
 		add_filter(
 			'wl_mappings_rule_field_two_options',
-			function ( $rule_field_two_options ) {
+			function($rule_field_two_options) {
 
-				$taxonomies = get_object_taxonomies( 'post', 'objects' );
+				$taxonomies = get_object_taxonomies('post', 'objects');
 
 				$taxonomy_options = array();
 
-				foreach ( $taxonomies as $item ) {
+				foreach ($taxonomies as $item) {
 					/**
 					 * $item Taxonomy
 					 */
@@ -68,7 +68,7 @@ 
 					);
 				}
 
-				return array_merge( $rule_field_two_options, $taxonomy_options );
+				return array_merge($rule_field_two_options, $taxonomy_options);
 
 			}
 		);

src/wordlift/mappings/data-source/class-data-source-factory.php

Indentation +39 added lines, -39 removed lines

@@ -11,44 +11,44 @@
 
 class Data_Source_Factory {
 
-	private static $instance = null;
-
-	private $data_sources = array();
-
-	public function __construct() {
-		$this->data_sources = array(
-			'acf'  => new Acf_Data_Source(),
-			'meta' => new Meta_Data_Source(),
-		);
-	}
-
-	/**
-	 * @param $identifier int post id or term id based on type.
-	 * @param $property_data array
-	 * @param $type string post or term.
-	 *
-	 * @return mixed
-	 */
-	public function get_data( $identifier, $property_data, $type ) {
-		switch ( $property_data['field_type'] ) {
-			case Jsonld_Converter::FIELD_TYPE_ACF:
-				return $this->data_sources['acf']->get_data( $identifier, $property_data, $type );
-			case Jsonld_Converter::FIELD_TYPE_CUSTOM_FIELD:
-				return $this->data_sources['meta']->get_data( $identifier, $property_data, $type );
-			default:
-				return $property_data['field_name'];
-		}
-	}
-
-	/**
-	 * @return Data_Source_Factory
-	 */
-	public static function get_instance() {
-		if ( null === self::$instance ) {
-			self::$instance = new Data_Source_Factory();
-		}
-
-		return self::$instance;
-	}
+    private static $instance = null;
+
+    private $data_sources = array();
+
+    public function __construct() {
+        $this->data_sources = array(
+            'acf'  => new Acf_Data_Source(),
+            'meta' => new Meta_Data_Source(),
+        );
+    }
+
+    /**
+     * @param $identifier int post id or term id based on type.
+     * @param $property_data array
+     * @param $type string post or term.
+     *
+     * @return mixed
+     */
+    public function get_data( $identifier, $property_data, $type ) {
+        switch ( $property_data['field_type'] ) {
+            case Jsonld_Converter::FIELD_TYPE_ACF:
+                return $this->data_sources['acf']->get_data( $identifier, $property_data, $type );
+            case Jsonld_Converter::FIELD_TYPE_CUSTOM_FIELD:
+                return $this->data_sources['meta']->get_data( $identifier, $property_data, $type );
+            default:
+                return $property_data['field_name'];
+        }
+    }
+
+    /**
+     * @return Data_Source_Factory
+     */
+    public static function get_instance() {
+        if ( null === self::$instance ) {
+            self::$instance = new Data_Source_Factory();
+        }
+
+        return self::$instance;
+    }
 
 }

Spacing +5 added lines, -5 removed lines

@@ -29,12 +29,12 @@ 
 	 *
 	 * @return mixed
 	 */
-	public function get_data( $identifier, $property_data, $type ) {
-		switch ( $property_data['field_type'] ) {
+	public function get_data($identifier, $property_data, $type) {
+		switch ($property_data['field_type']) {
 			case Jsonld_Converter::FIELD_TYPE_ACF:
-				return $this->data_sources['acf']->get_data( $identifier, $property_data, $type );
+				return $this->data_sources['acf']->get_data($identifier, $property_data, $type);
 			case Jsonld_Converter::FIELD_TYPE_CUSTOM_FIELD:
-				return $this->data_sources['meta']->get_data( $identifier, $property_data, $type );
+				return $this->data_sources['meta']->get_data($identifier, $property_data, $type);
 			default:
 				return $property_data['field_name'];
 		}
@@ -44,7 +44,7 @@ 
 	 * @return Data_Source_Factory
 	 */
 	public static function get_instance() {
-		if ( null === self::$instance ) {
+		if (null === self::$instance) {
 			self::$instance = new Data_Source_Factory();
 		}
 

src/wordlift/mappings/data-source/class-acf-data-source.php

Indentation +54 added lines, -54 removed lines

@@ -11,63 +11,63 @@
 
 class Acf_Data_Source implements Abstract_Data_Source {
 
-	public function get_data( $identifier, $property_data, $type ) {
+    public function get_data( $identifier, $property_data, $type ) {
 
-		if ( ! function_exists( 'get_field' ) || ! function_exists( 'get_field_object' ) ) {
-			return array();
-		}
+        if ( ! function_exists( 'get_field' ) || ! function_exists( 'get_field_object' ) ) {
+            return array();
+        }
 
-		return $this->get_data_for_acf_field( $property_data['field_name'], $identifier, $type );
-	}
+        return $this->get_data_for_acf_field( $property_data['field_name'], $identifier, $type );
+    }
 
-	/**
-	 * Gets data from acf, format the data if it is a repeater field.
-	 *
-	 * @param $field_name string
-	 * @param $identifier int Identifier ( post id or term id )
-	 *
-	 * @return array|mixed
-	 */
-	private function get_data_for_acf_field( $field_name, $identifier, $type ) {
-		if ( Jsonld_Converter::TERM === $type ) {
-			$term = get_term( $identifier );
-			// Data fetching method for term is different.
-			$field_data = get_field_object( $field_name, $term );
-			$data       = get_field( $field_name, $term );
-		} else {
-			$field_data = get_field_object( $field_name, $identifier );
-			$data       = get_field( $field_name, $identifier );
-		}
-		// only process if it is a repeater field, else return the data.
-		if ( is_array( $field_data ) && array_key_exists( 'type', $field_data )
-			 && 'repeater' === $field_data['type'] ) {
-			/**
-			 * check if we have only one sub field, currently we only support one subfield,
-			 * so each repeater item should be checked if there is a single sub field.
-			 */
-			if ( is_array( $data ) &&
-				 count( $data ) > 0 &&
-				 count( array_keys( $data[0] ) ) === 1 ) {
-				$repeater_formatted_data = array();
-				foreach ( $data as $item ) {
-					$repeater_formatted_data = array_merge( $repeater_formatted_data, array_values( $item ) );
-				}
-				// Remove non unique values.
-				$repeater_formatted_data = array_unique( $repeater_formatted_data );
-				// Remove empty values
-				$repeater_formatted_data = array_filter(
-					$repeater_formatted_data,
-					function ( $item ) {
-						return is_array( $item ) || strlen( $item );
-					}
-				);
+    /**
+     * Gets data from acf, format the data if it is a repeater field.
+     *
+     * @param $field_name string
+     * @param $identifier int Identifier ( post id or term id )
+     *
+     * @return array|mixed
+     */
+    private function get_data_for_acf_field( $field_name, $identifier, $type ) {
+        if ( Jsonld_Converter::TERM === $type ) {
+            $term = get_term( $identifier );
+            // Data fetching method for term is different.
+            $field_data = get_field_object( $field_name, $term );
+            $data       = get_field( $field_name, $term );
+        } else {
+            $field_data = get_field_object( $field_name, $identifier );
+            $data       = get_field( $field_name, $identifier );
+        }
+        // only process if it is a repeater field, else return the data.
+        if ( is_array( $field_data ) && array_key_exists( 'type', $field_data )
+             && 'repeater' === $field_data['type'] ) {
+            /**
+             * check if we have only one sub field, currently we only support one subfield,
+             * so each repeater item should be checked if there is a single sub field.
+             */
+            if ( is_array( $data ) &&
+                 count( $data ) > 0 &&
+                 count( array_keys( $data[0] ) ) === 1 ) {
+                $repeater_formatted_data = array();
+                foreach ( $data as $item ) {
+                    $repeater_formatted_data = array_merge( $repeater_formatted_data, array_values( $item ) );
+                }
+                // Remove non unique values.
+                $repeater_formatted_data = array_unique( $repeater_formatted_data );
+                // Remove empty values
+                $repeater_formatted_data = array_filter(
+                    $repeater_formatted_data,
+                    function ( $item ) {
+                        return is_array( $item ) || strlen( $item );
+                    }
+                );
 
-				// re-index all the values.
-				return array_values( $repeater_formatted_data );
-			}
-		}
+                // re-index all the values.
+                return array_values( $repeater_formatted_data );
+            }
+        }
 
-		// Return normal acf data if it is not a repeater field.
-		return $data;
-	}
+        // Return normal acf data if it is not a repeater field.
+        return $data;
+    }
 }

Spacing +21 added lines, -21 removed lines

@@ -11,13 +11,13 @@ 
 
 class Acf_Data_Source implements Abstract_Data_Source {
 
-	public function get_data( $identifier, $property_data, $type ) {
+	public function get_data($identifier, $property_data, $type) {
 
-		if ( ! function_exists( 'get_field' ) || ! function_exists( 'get_field_object' ) ) {
+		if ( ! function_exists('get_field') || ! function_exists('get_field_object')) {
 			return array();
 		}
 
-		return $this->get_data_for_acf_field( $property_data['field_name'], $identifier, $type );
+		return $this->get_data_for_acf_field($property_data['field_name'], $identifier, $type);
 	}
 
 	/**
@@ -28,42 +28,42 @@ 
 	 *
 	 * @return array|mixed
 	 */
-	private function get_data_for_acf_field( $field_name, $identifier, $type ) {
-		if ( Jsonld_Converter::TERM === $type ) {
-			$term = get_term( $identifier );
+	private function get_data_for_acf_field($field_name, $identifier, $type) {
+		if (Jsonld_Converter::TERM === $type) {
+			$term = get_term($identifier);
 			// Data fetching method for term is different.
-			$field_data = get_field_object( $field_name, $term );
-			$data       = get_field( $field_name, $term );
+			$field_data = get_field_object($field_name, $term);
+			$data       = get_field($field_name, $term);
 		} else {
-			$field_data = get_field_object( $field_name, $identifier );
-			$data       = get_field( $field_name, $identifier );
+			$field_data = get_field_object($field_name, $identifier);
+			$data       = get_field($field_name, $identifier);
 		}
 		// only process if it is a repeater field, else return the data.
-		if ( is_array( $field_data ) && array_key_exists( 'type', $field_data )
-			 && 'repeater' === $field_data['type'] ) {
+		if (is_array($field_data) && array_key_exists('type', $field_data)
+			 && 'repeater' === $field_data['type']) {
 			/**
 			 * check if we have only one sub field, currently we only support one subfield,
 			 * so each repeater item should be checked if there is a single sub field.
 			 */
-			if ( is_array( $data ) &&
-				 count( $data ) > 0 &&
-				 count( array_keys( $data[0] ) ) === 1 ) {
+			if (is_array($data) &&
+				 count($data) > 0 &&
+				 count(array_keys($data[0])) === 1) {
 				$repeater_formatted_data = array();
-				foreach ( $data as $item ) {
-					$repeater_formatted_data = array_merge( $repeater_formatted_data, array_values( $item ) );
+				foreach ($data as $item) {
+					$repeater_formatted_data = array_merge($repeater_formatted_data, array_values($item));
 				}
 				// Remove non unique values.
-				$repeater_formatted_data = array_unique( $repeater_formatted_data );
+				$repeater_formatted_data = array_unique($repeater_formatted_data);
 				// Remove empty values
 				$repeater_formatted_data = array_filter(
 					$repeater_formatted_data,
-					function ( $item ) {
-						return is_array( $item ) || strlen( $item );
+					function($item) {
+						return is_array($item) || strlen($item);
 					}
 				);
 
 				// re-index all the values.
-				return array_values( $repeater_formatted_data );
+				return array_values($repeater_formatted_data);
 			}
 		}
 

src/wordlift/mappings/data-source/class-meta-data-source.php

Indentation +22 added lines, -22 removed lines

@@ -17,26 +17,26 @@
  */
 class Meta_Data_Source implements Abstract_Data_Source {
 
-	/**
-	 * @param int      $identifier Post id or term id
-	 * @param $property
-	 * @param $type
-	 *
-	 * @return array
-	 */
-	public function get_data( $identifier, $property, $type ) {
-
-		$value = $property['field_name'];
-
-		if ( Jsonld_Converter::TERM === $type ) {
-			$meta = get_term_meta( $identifier, $value );
-		} else {
-			$meta = get_post_meta( $identifier, $value );
-		}
-		$values = ( 1 === count( $meta ) && is_array( $meta[0] ) )
-			? $meta[0] : $meta;
-
-		return array_map( 'wp_strip_all_tags', $values );
-
-	}
+    /**
+     * @param int      $identifier Post id or term id
+     * @param $property
+     * @param $type
+     *
+     * @return array
+     */
+    public function get_data( $identifier, $property, $type ) {
+
+        $value = $property['field_name'];
+
+        if ( Jsonld_Converter::TERM === $type ) {
+            $meta = get_term_meta( $identifier, $value );
+        } else {
+            $meta = get_post_meta( $identifier, $value );
+        }
+        $values = ( 1 === count( $meta ) && is_array( $meta[0] ) )
+            ? $meta[0] : $meta;
+
+        return array_map( 'wp_strip_all_tags', $values );
+
+    }
 }

Spacing +6 added lines, -6 removed lines

@@ -24,19 +24,19 @@
 	 *
 	 * @return array
 	 */
-	public function get_data( $identifier, $property, $type ) {
+	public function get_data($identifier, $property, $type) {
 
 		$value = $property['field_name'];
 
-		if ( Jsonld_Converter::TERM === $type ) {
-			$meta = get_term_meta( $identifier, $value );
+		if (Jsonld_Converter::TERM === $type) {
+			$meta = get_term_meta($identifier, $value);
 		} else {
-			$meta = get_post_meta( $identifier, $value );
+			$meta = get_post_meta($identifier, $value);
 		}
-		$values = ( 1 === count( $meta ) && is_array( $meta[0] ) )
+		$values = (1 === count($meta) && is_array($meta[0]))
 			? $meta[0] : $meta;
 
-		return array_map( 'wp_strip_all_tags', $values );
+		return array_map('wp_strip_all_tags', $values);
 
 	}
 }

src/wordlift/mappings/class-acf-mappings.php

Indentation +80 added lines, -80 removed lines

@@ -15,85 +15,85 @@
  */
 class Acf_Mappings {
 
-	/**
-	 * Acf_Mappings constructor.
-	 *
-	 * Hooks `wl_mappings_field_types` to our own function to declare support for ACF fields.
-	 */
-	public function __construct() {
-
-		$that = $this;
-		add_action(
-			'plugins_loaded',
-			function () use ( $that ) {
-				$that->add_acf_option_to_mappings_ui();
-			}
-		);
-
-	}
-
-	private function add_acf_option_to_mappings_ui() {
-		// Bail out if ACF is not available.
-		if ( ! function_exists( 'acf_get_field_groups' ) ) {
-			return array();
-		}
-
-		add_filter( 'wl_mappings_field_types', array( $this, 'wl_mappings_field_types' ) );
-	}
-
-	/**
-	 * Hook to `wl_mappings_field_types` to declare support for ACF fields.
-	 *
-	 * @param array $field_types An array of field types.
-	 *
-	 * @return array The array with our ACF declaration.
-	 */
-	public function wl_mappings_field_types( $field_types ) {
-
-		$field_types[] = array(
-			'field_type' => 'acf',
-			'label'      => __( 'ACF', 'wordlift' ),
-			'value'      => self::get_acf_options(),
-		);
-
-		return $field_types;
-	}
-
-	/**
-	 * Returns array of acf options.
-	 *
-	 * The array is composed by all the ACF groups and their fields hierarchy.
-	 *
-	 * @return array ACF options array.
-	 */
-	private static function get_acf_options() {
-
-		$acf_options = array();
-
-		// Get all the ACF field groups.
-		$field_groups = acf_get_field_groups();
-
-		foreach ( $field_groups as $field_group ) {
-			$group_name = $field_group['title'];
-			$group_key  = $field_group['key'];
-
-			$group_fields = acf_get_fields( $group_key );
-
-			$group_options = array();
-			foreach ( $group_fields as $group_field ) {
-				$group_options[] = array(
-					'label' => $group_field['label'],
-					'value' => $group_field['key'],
-				);
-			}
-
-			$acf_options[] = array(
-				'group_name'    => $group_name,
-				'group_options' => $group_options,
-			);
-		}
-
-		return $acf_options;
-	}
+    /**
+     * Acf_Mappings constructor.
+     *
+     * Hooks `wl_mappings_field_types` to our own function to declare support for ACF fields.
+     */
+    public function __construct() {
+
+        $that = $this;
+        add_action(
+            'plugins_loaded',
+            function () use ( $that ) {
+                $that->add_acf_option_to_mappings_ui();
+            }
+        );
+
+    }
+
+    private function add_acf_option_to_mappings_ui() {
+        // Bail out if ACF is not available.
+        if ( ! function_exists( 'acf_get_field_groups' ) ) {
+            return array();
+        }
+
+        add_filter( 'wl_mappings_field_types', array( $this, 'wl_mappings_field_types' ) );
+    }
+
+    /**
+     * Hook to `wl_mappings_field_types` to declare support for ACF fields.
+     *
+     * @param array $field_types An array of field types.
+     *
+     * @return array The array with our ACF declaration.
+     */
+    public function wl_mappings_field_types( $field_types ) {
+
+        $field_types[] = array(
+            'field_type' => 'acf',
+            'label'      => __( 'ACF', 'wordlift' ),
+            'value'      => self::get_acf_options(),
+        );
+
+        return $field_types;
+    }
+
+    /**
+     * Returns array of acf options.
+     *
+     * The array is composed by all the ACF groups and their fields hierarchy.
+     *
+     * @return array ACF options array.
+     */
+    private static function get_acf_options() {
+
+        $acf_options = array();
+
+        // Get all the ACF field groups.
+        $field_groups = acf_get_field_groups();
+
+        foreach ( $field_groups as $field_group ) {
+            $group_name = $field_group['title'];
+            $group_key  = $field_group['key'];
+
+            $group_fields = acf_get_fields( $group_key );
+
+            $group_options = array();
+            foreach ( $group_fields as $group_field ) {
+                $group_options[] = array(
+                    'label' => $group_field['label'],
+                    'value' => $group_field['key'],
+                );
+            }
+
+            $acf_options[] = array(
+                'group_name'    => $group_name,
+                'group_options' => $group_options,
+            );
+        }
+
+        return $acf_options;
+    }
 
 }

Spacing +8 added lines, -8 removed lines

@@ -25,7 +25,7 @@ 
 		$that = $this;
 		add_action(
 			'plugins_loaded',
-			function () use ( $that ) {
+			function() use ($that) {
 				$that->add_acf_option_to_mappings_ui();
 			}
 		);
@@ -34,11 +34,11 @@ 
 
 	private function add_acf_option_to_mappings_ui() {
 		// Bail out if ACF is not available.
-		if ( ! function_exists( 'acf_get_field_groups' ) ) {
+		if ( ! function_exists('acf_get_field_groups')) {
 			return array();
 		}
 
-		add_filter( 'wl_mappings_field_types', array( $this, 'wl_mappings_field_types' ) );
+		add_filter('wl_mappings_field_types', array($this, 'wl_mappings_field_types'));
 	}
 
 	/**
@@ -48,11 +48,11 @@ 
 	 *
 	 * @return array The array with our ACF declaration.
 	 */
-	public function wl_mappings_field_types( $field_types ) {
+	public function wl_mappings_field_types($field_types) {
 
 		$field_types[] = array(
 			'field_type' => 'acf',
-			'label'      => __( 'ACF', 'wordlift' ),
+			'label'      => __('ACF', 'wordlift'),
 			'value'      => self::get_acf_options(),
 		);
 
@@ -73,14 +73,14 @@ 
 		// Get all the ACF field groups.
 		$field_groups = acf_get_field_groups();
 
-		foreach ( $field_groups as $field_group ) {
+		foreach ($field_groups as $field_group) {
 			$group_name = $field_group['title'];
 			$group_key  = $field_group['key'];
 
-			$group_fields = acf_get_fields( $group_key );
+			$group_fields = acf_get_fields($group_key);
 
 			$group_options = array();
-			foreach ( $group_fields as $group_field ) {
+			foreach ($group_fields as $group_field) {
 				$group_options[] = array(
 					'label' => $group_field['label'],
 					'value' => $group_field['key'],

src/wordlift/mappings/class-mappings-dbo.php

Spacing +43 added lines, -43 removed lines

@@ -66,10 +66,10 @@ 
 	 *
 	 * @return array List of property items belong to $mapping_id.
 	 */
-	public function get_properties( $mapping_id ) {
+	public function get_properties($mapping_id) {
 		global $wpdb;
 		$property_rows = $wpdb->get_results(
-			$wpdb->prepare( "SELECT * FROM {$wpdb->prefix}wl_mapping_property WHERE mapping_id=%d", $mapping_id ),
+			$wpdb->prepare("SELECT * FROM {$wpdb->prefix}wl_mapping_property WHERE mapping_id=%d", $mapping_id),
 			ARRAY_A
 		);
 
@@ -85,7 +85,7 @@ 
 	 *
 	 * @return bool Returns true if the row exists, false if it does not
 	 */
-	private function check_if_row_exists( $table_name, $primary_key_name, $primary_key_value ) {
+	private function check_if_row_exists($table_name, $primary_key_name, $primary_key_value) {
 		global $wpdb;
 		$primary_key_value = (int) $primary_key_value;
 		$count             = (int) $this->wpdb->get_var(
@@ -108,11 +108,11 @@ 
 	 *
 	 * @return int Id of the inserted mapping item.
 	 */
-	public function insert_mapping_item( $title ) {
-		$mapping_table_name = $this->wpdb->prefix . WL_MAPPING_TABLE_NAME;
+	public function insert_mapping_item($title) {
+		$mapping_table_name = $this->wpdb->prefix.WL_MAPPING_TABLE_NAME;
 		$this->wpdb->insert(
 			$mapping_table_name,
-			array( 'mapping_title' => $title )
+			array('mapping_title' => $title)
 		);
 
 		return $this->wpdb->insert_id;
@@ -125,14 +125,14 @@ 
 	 *
 	 * @return int Id of the inserted mapping item
 	 */
-	public function insert_or_update_mapping_item( $mapping_data ) {
-		$mapping_table_name = $this->wpdb->prefix . WL_MAPPING_TABLE_NAME;
-		$mapping_id         = array_key_exists( 'mapping_id', $mapping_data ) ? (int) $mapping_data['mapping_id'] : null;
-		if ( $this->check_if_row_exists( $mapping_table_name, 'mapping_id', $mapping_data['mapping_id'] ) ) {
+	public function insert_or_update_mapping_item($mapping_data) {
+		$mapping_table_name = $this->wpdb->prefix.WL_MAPPING_TABLE_NAME;
+		$mapping_id         = array_key_exists('mapping_id', $mapping_data) ? (int) $mapping_data['mapping_id'] : null;
+		if ($this->check_if_row_exists($mapping_table_name, 'mapping_id', $mapping_data['mapping_id'])) {
 			$this->wpdb->update(
 				$mapping_table_name,
 				$mapping_data,
-				array( 'mapping_id' => $mapping_id )
+				array('mapping_id' => $mapping_id)
 			);
 		} else {
 			$this->wpdb->insert(
@@ -152,13 +152,13 @@ 
 	 *
 	 * @return int $rule_id The inserted rule id.
 	 */
-	public function insert_or_update_rule_item( $rule_item_data ) {
-		$rule_table_name = $this->wpdb->prefix . WL_RULE_TABLE_NAME;
-		$rule_id         = array_key_exists( 'rule_id', $rule_item_data ) ? $rule_item_data['rule_id'] : null;
-		if ( $this->check_if_row_exists( $rule_table_name, 'rule_id', $rule_id ) ) {
-			$this->wpdb->update( $rule_table_name, $rule_item_data, array( 'rule_id' => $rule_id ) );
+	public function insert_or_update_rule_item($rule_item_data) {
+		$rule_table_name = $this->wpdb->prefix.WL_RULE_TABLE_NAME;
+		$rule_id         = array_key_exists('rule_id', $rule_item_data) ? $rule_item_data['rule_id'] : null;
+		if ($this->check_if_row_exists($rule_table_name, 'rule_id', $rule_id)) {
+			$this->wpdb->update($rule_table_name, $rule_item_data, array('rule_id' => $rule_id));
 		} else {
-			$this->wpdb->insert( $rule_table_name, $rule_item_data );
+			$this->wpdb->insert($rule_table_name, $rule_item_data);
 			$rule_id = $this->wpdb->insert_id;
 		}
 
@@ -173,8 +173,8 @@ 
 	 *
 	 * @return int The inserted rule group id.
 	 */
-	public function insert_rule_group( $mapping_id ) {
-		$rule_group_table_name = $this->wpdb->prefix . WL_RULE_GROUP_TABLE_NAME;
+	public function insert_rule_group($mapping_id) {
+		$rule_group_table_name = $this->wpdb->prefix.WL_RULE_GROUP_TABLE_NAME;
 		$this->wpdb->insert(
 			$rule_group_table_name,
 			array(
@@ -192,9 +192,9 @@ 
 	 *
 	 * @return void
 	 */
-	public function delete_rule_item( $rule_id ) {
-		$rule_table_name = $this->wpdb->prefix . WL_RULE_TABLE_NAME;
-		$this->wpdb->delete( $rule_table_name, array( 'rule_id' => $rule_id ) );
+	public function delete_rule_item($rule_id) {
+		$rule_table_name = $this->wpdb->prefix.WL_RULE_TABLE_NAME;
+		$this->wpdb->delete($rule_table_name, array('rule_id' => $rule_id));
 	}
 
 	/**
@@ -204,9 +204,9 @@ 
 	 *
 	 * @return void
 	 */
-	public function delete_rule_group_item( $rule_group_id ) {
-		$rule_group_table_name = $this->wpdb->prefix . WL_RULE_GROUP_TABLE_NAME;
-		$this->wpdb->delete( $rule_group_table_name, array( 'rule_group_id' => $rule_group_id ) );
+	public function delete_rule_group_item($rule_group_id) {
+		$rule_group_table_name = $this->wpdb->prefix.WL_RULE_GROUP_TABLE_NAME;
+		$this->wpdb->delete($rule_group_table_name, array('rule_group_id' => $rule_group_id));
 	}
 
 	/**
@@ -216,9 +216,9 @@ 
 	 *
 	 * @return void
 	 */
-	public function delete_mapping_item( $mapping_id ) {
-		$mapping_table_name = $this->wpdb->prefix . WL_MAPPING_TABLE_NAME;
-		$this->wpdb->delete( $mapping_table_name, array( 'mapping_id' => $mapping_id ) );
+	public function delete_mapping_item($mapping_id) {
+		$mapping_table_name = $this->wpdb->prefix.WL_MAPPING_TABLE_NAME;
+		$this->wpdb->delete($mapping_table_name, array('mapping_id' => $mapping_id));
 	}
 
 	/**
@@ -228,7 +228,7 @@ 
 	 *
 	 * @return array Get list of rule group items.
 	 */
-	public function get_rule_group_list( $mapping_id ) {
+	public function get_rule_group_list($mapping_id) {
 		global $wpdb;
 		return $wpdb->get_results(
 			$wpdb->prepare(
@@ -246,7 +246,7 @@ 
 	 *
 	 * @return array Get list of rule group items.
 	 */
-	public function get_rule_groups_by_mapping( $mapping_id ) {
+	public function get_rule_groups_by_mapping($mapping_id) {
 		global $wpdb;
 		$rule_group_rows = $wpdb->get_results(
 			$wpdb->prepare(
@@ -258,10 +258,10 @@ 
 
 		// List of all rule group items.
 		$rule_groups = array();
-		foreach ( $rule_group_rows as $rule_group_row ) {
+		foreach ($rule_group_rows as $rule_group_row) {
 			$rule_groups[] = array(
 				'rule_group_id' => $rule_group_row['rule_group_id'],
-				'rules'         => $this->get_rules_by_rule_group( $rule_group_row['rule_group_id'] ),
+				'rules'         => $this->get_rules_by_rule_group($rule_group_row['rule_group_id']),
 			);
 		}
 
@@ -275,7 +275,7 @@ 
 	 *
 	 * @return array Get list of rule items.
 	 */
-	public function get_rules_by_rule_group( $rule_group_id ) {
+	public function get_rules_by_rule_group($rule_group_id) {
 		global $wpdb;
 		return $wpdb->get_results(
 			$wpdb->prepare(
@@ -293,18 +293,18 @@ 
 	 *
 	 * @return int Inserted Property Id.
 	 */
-	public function insert_or_update_property( $property_data ) {
-		$property_table_name = $this->wpdb->prefix . WL_PROPERTY_TABLE_NAME;
-		$property_id         = array_key_exists( 'property_id', $property_data ) ? $property_data['property_id'] : null;
+	public function insert_or_update_property($property_data) {
+		$property_table_name = $this->wpdb->prefix.WL_PROPERTY_TABLE_NAME;
+		$property_id         = array_key_exists('property_id', $property_data) ? $property_data['property_id'] : null;
 
-		if ( $this->check_if_row_exists( $property_table_name, 'property_id', $property_id ) ) {
+		if ($this->check_if_row_exists($property_table_name, 'property_id', $property_id)) {
 			$this->wpdb->update(
 				$property_table_name,
 				$property_data,
-				array( 'property_id' => $property_id )
+				array('property_id' => $property_id)
 			);
 		} else {
-			$this->wpdb->insert( $property_table_name, $property_data );
+			$this->wpdb->insert($property_table_name, $property_data);
 			$property_id = $this->wpdb->insert_id;
 		}
 
@@ -318,7 +318,7 @@ 
 	 *
 	 * @return array Returns single mapping table row..
 	 */
-	public function get_mapping_item_data( $mapping_id ) {
+	public function get_mapping_item_data($mapping_id) {
 		global $wpdb;
 		return $wpdb->get_row(
 			$wpdb->prepare(
@@ -336,10 +336,10 @@ 
 	 *
 	 * @return int|false The number of rows updated, or false on error.
 	 */
-	public function delete_property( $property_id ) {
-		$property_table_name = $this->wpdb->prefix . WL_PROPERTY_TABLE_NAME;
+	public function delete_property($property_id) {
+		$property_table_name = $this->wpdb->prefix.WL_PROPERTY_TABLE_NAME;
 
-		return $this->wpdb->delete( $property_table_name, array( 'property_id' => $property_id ) );
+		return $this->wpdb->delete($property_table_name, array('property_id' => $property_id));
 	}
 
 }

Indentation +329 added lines, -329 removed lines

@@ -12,334 +12,334 @@
  */
 final class Mappings_DBO {
 
-	/**
-	 * The {@link wpdb} instance.
-	 *
-	 * @since  3.25.0
-	 * @access private
-	 * @var \wpdb $wpdb The {@link wpdb} instance.
-	 */
-	private $wpdb = null;
-
-	/**
-	 * Construct DBO object.
-	 */
-	public function __construct() {
-		global $wpdb;
-		$this->wpdb = $wpdb;
-	}
-
-	/**
-	 * Returns an array of mappings.
-	 *
-	 * Each mapping contains one or more rule groups which in turn contain one or more rules.
-	 *
-	 * @return array An array of mappings.
-	 */
-	public function get_mappings() {
-		global $wpdb;
-		return $this->wpdb->get_results(
-			"SELECT * FROM {$wpdb->prefix}wl_mapping",
-			ARRAY_A
-		);
-	}
-
-	/**
-	 * Returns an array of active mappings.
-	 *
-	 * Each mapping contains one or more rule groups which in turn contain one or more rules.
-	 *
-	 * @return array An array of mappings.
-	 */
-	public function get_active_mappings() {
-		global $wpdb;
-		return $this->wpdb->get_results(
-			"SELECT * FROM {$wpdb->prefix}wl_mapping WHERE mapping_status = 'active'",
-			ARRAY_A
-		);
-	}
-
-	/**
-	 * Returns a list of property rows
-	 *
-	 * @param int $mapping_id Primary key of mapping table.
-	 *
-	 * @return array List of property items belong to $mapping_id.
-	 */
-	public function get_properties( $mapping_id ) {
-		global $wpdb;
-		$property_rows = $wpdb->get_results(
-			$wpdb->prepare( "SELECT * FROM {$wpdb->prefix}wl_mapping_property WHERE mapping_id=%d", $mapping_id ),
-			ARRAY_A
-		);
-
-		return $property_rows;
-	}
-
-	/**
-	 * Check if the row exists in the table
-	 *
-	 * @param string $table_name The table name you want to query, completely escaped value.
-	 * @param string $primary_key_name The primary key you want to query, should be escaped before passing.
-	 * @param int    $primary_key_value The primary key value, no need to escape.
-	 *
-	 * @return bool Returns true if the row exists, false if it does not
-	 */
-	private function check_if_row_exists( $table_name, $primary_key_name, $primary_key_value ) {
-		global $wpdb;
-		$primary_key_value = (int) $primary_key_value;
-		$count             = (int) $this->wpdb->get_var(
-			$wpdb->prepare(
-				'SELECT COUNT(%1s) from %2s where %3s = %4d', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.UnquotedComplexPlaceholder
-				$primary_key_name,
-				$table_name,
-				$primary_key_name,
-				$primary_key_value
-			)
-		);
-
-		return $count > 0;
-	}
-
-	/**
-	 * Insert new mapping item with title
-	 *
-	 * @param string $title Title of the mapping item.
-	 *
-	 * @return int Id of the inserted mapping item.
-	 */
-	public function insert_mapping_item( $title ) {
-		$mapping_table_name = $this->wpdb->prefix . WL_MAPPING_TABLE_NAME;
-		$this->wpdb->insert(
-			$mapping_table_name,
-			array( 'mapping_title' => $title )
-		);
-
-		return $this->wpdb->insert_id;
-	}
-
-	/**
-	 * Update mapping item with new title
-	 *
-	 * @param array $mapping_data Array of the mapping data.
-	 *
-	 * @return int Id of the inserted mapping item
-	 */
-	public function insert_or_update_mapping_item( $mapping_data ) {
-		$mapping_table_name = $this->wpdb->prefix . WL_MAPPING_TABLE_NAME;
-		$mapping_id         = array_key_exists( 'mapping_id', $mapping_data ) ? (int) $mapping_data['mapping_id'] : null;
-		if ( $this->check_if_row_exists( $mapping_table_name, 'mapping_id', $mapping_data['mapping_id'] ) ) {
-			$this->wpdb->update(
-				$mapping_table_name,
-				$mapping_data,
-				array( 'mapping_id' => $mapping_id )
-			);
-		} else {
-			$this->wpdb->insert(
-				$mapping_table_name,
-				$mapping_data
-			);
-			$mapping_id = (int) $this->wpdb->insert_id;
-		}
-
-		return $mapping_id;
-	}
-
-	/**
-	 * Updates rule item.
-	 *
-	 * @param array $rule_item_data The rule_item_data, should contain rule_id.
-	 *
-	 * @return int $rule_id The inserted rule id.
-	 */
-	public function insert_or_update_rule_item( $rule_item_data ) {
-		$rule_table_name = $this->wpdb->prefix . WL_RULE_TABLE_NAME;
-		$rule_id         = array_key_exists( 'rule_id', $rule_item_data ) ? $rule_item_data['rule_id'] : null;
-		if ( $this->check_if_row_exists( $rule_table_name, 'rule_id', $rule_id ) ) {
-			$this->wpdb->update( $rule_table_name, $rule_item_data, array( 'rule_id' => $rule_id ) );
-		} else {
-			$this->wpdb->insert( $rule_table_name, $rule_item_data );
-			$rule_id = $this->wpdb->insert_id;
-		}
-
-		return $rule_id;
-	}
-
-	/**
-	 * If a rule group exists doesn't do anything, but if rule group
-	 * didn't exist then it inserts a new entry.
-	 *
-	 * @param int $mapping_id Primary key for mapping table.
-	 *
-	 * @return int The inserted rule group id.
-	 */
-	public function insert_rule_group( $mapping_id ) {
-		$rule_group_table_name = $this->wpdb->prefix . WL_RULE_GROUP_TABLE_NAME;
-		$this->wpdb->insert(
-			$rule_group_table_name,
-			array(
-				'mapping_id' => $mapping_id,
-			)
-		);
-
-		return $this->wpdb->insert_id;
-	}
-
-	/**
-	 * Deletes a rule item by rule_id from rule and rule group table.
-	 *
-	 * @param int $rule_id Primary key for rule table.
-	 *
-	 * @return void
-	 */
-	public function delete_rule_item( $rule_id ) {
-		$rule_table_name = $this->wpdb->prefix . WL_RULE_TABLE_NAME;
-		$this->wpdb->delete( $rule_table_name, array( 'rule_id' => $rule_id ) );
-	}
-
-	/**
-	 * Deletes a rule group item by rule_group_id from rule group table.
-	 *
-	 * @param int $rule_group_id Primary key for rule table.
-	 *
-	 * @return void
-	 */
-	public function delete_rule_group_item( $rule_group_id ) {
-		$rule_group_table_name = $this->wpdb->prefix . WL_RULE_GROUP_TABLE_NAME;
-		$this->wpdb->delete( $rule_group_table_name, array( 'rule_group_id' => $rule_group_id ) );
-	}
-
-	/**
-	 * Deletes a mapping item by mapping_id
-	 *
-	 * @param int $mapping_id Primary key for mapping table.
-	 *
-	 * @return void
-	 */
-	public function delete_mapping_item( $mapping_id ) {
-		$mapping_table_name = $this->wpdb->prefix . WL_MAPPING_TABLE_NAME;
-		$this->wpdb->delete( $mapping_table_name, array( 'mapping_id' => $mapping_id ) );
-	}
-
-	/**
-	 * Gets a list of rule group items.
-	 *
-	 * @param int $mapping_id Primary key for mapping table.
-	 *
-	 * @return array Get list of rule group items.
-	 */
-	public function get_rule_group_list( $mapping_id ) {
-		global $wpdb;
-		return $wpdb->get_results(
-			$wpdb->prepare(
-				"SELECT rule_group_id FROM {$wpdb->prefix}wl_mapping_rule_group WHERE mapping_id=%d",
-				$mapping_id
-			),
-			ARRAY_A
-		);
-	}
-
-	/**
-	 * Gets a list of rule group items.
-	 *
-	 * @param int $mapping_id Primary key for mapping table.
-	 *
-	 * @return array Get list of rule group items.
-	 */
-	public function get_rule_groups_by_mapping( $mapping_id ) {
-		global $wpdb;
-		$rule_group_rows = $wpdb->get_results(
-			$wpdb->prepare(
-				"SELECT rule_group_id FROM {$wpdb->prefix}wl_mapping_rule_group WHERE mapping_id=%d",
-				$mapping_id
-			),
-			ARRAY_A
-		);
-
-		// List of all rule group items.
-		$rule_groups = array();
-		foreach ( $rule_group_rows as $rule_group_row ) {
-			$rule_groups[] = array(
-				'rule_group_id' => $rule_group_row['rule_group_id'],
-				'rules'         => $this->get_rules_by_rule_group( $rule_group_row['rule_group_id'] ),
-			);
-		}
-
-		return $rule_groups;
-	}
-
-	/**
-	 * Gets a list of rule items belong to rule_group_id.
-	 *
-	 * @param int $rule_group_id Indicates which group the item belongs to.
-	 *
-	 * @return array Get list of rule items.
-	 */
-	public function get_rules_by_rule_group( $rule_group_id ) {
-		global $wpdb;
-		return $wpdb->get_results(
-			$wpdb->prepare(
-				"SELECT * FROM {$wpdb->prefix}wl_mapping_rule WHERE rule_group_id=%d",
-				$rule_group_id
-			),
-			ARRAY_A
-		);
-	}
-
-	/**
-	 * Insert/Update property item.
-	 *
-	 * @param array $property_data Property row from table/ui.
-	 *
-	 * @return int Inserted Property Id.
-	 */
-	public function insert_or_update_property( $property_data ) {
-		$property_table_name = $this->wpdb->prefix . WL_PROPERTY_TABLE_NAME;
-		$property_id         = array_key_exists( 'property_id', $property_data ) ? $property_data['property_id'] : null;
-
-		if ( $this->check_if_row_exists( $property_table_name, 'property_id', $property_id ) ) {
-			$this->wpdb->update(
-				$property_table_name,
-				$property_data,
-				array( 'property_id' => $property_id )
-			);
-		} else {
-			$this->wpdb->insert( $property_table_name, $property_data );
-			$property_id = $this->wpdb->insert_id;
-		}
-
-		return $property_id;
-	}
-
-	/**
-	 * Gets a single mapping item row.
-	 *
-	 * @param int $mapping_id Primary key of mapping table.
-	 *
-	 * @return array Returns single mapping table row..
-	 */
-	public function get_mapping_item_data( $mapping_id ) {
-		global $wpdb;
-		return $wpdb->get_row(
-			$wpdb->prepare(
-				"SELECT * FROM {$wpdb->prefix}wl_mapping WHERE mapping_id=%d",
-				$mapping_id
-			),
-			ARRAY_A
-		);
-	}
-
-	/**
-	 * Delete property item.
-	 *
-	 * @param int $property_id Primary key for property table.
-	 *
-	 * @return int|false The number of rows updated, or false on error.
-	 */
-	public function delete_property( $property_id ) {
-		$property_table_name = $this->wpdb->prefix . WL_PROPERTY_TABLE_NAME;
-
-		return $this->wpdb->delete( $property_table_name, array( 'property_id' => $property_id ) );
-	}
+    /**
+     * The {@link wpdb} instance.
+     *
+     * @since  3.25.0
+     * @access private
+     * @var \wpdb $wpdb The {@link wpdb} instance.
+     */
+    private $wpdb = null;
+
+    /**
+     * Construct DBO object.
+     */
+    public function __construct() {
+        global $wpdb;
+        $this->wpdb = $wpdb;
+    }
+
+    /**
+     * Returns an array of mappings.
+     *
+     * Each mapping contains one or more rule groups which in turn contain one or more rules.
+     *
+     * @return array An array of mappings.
+     */
+    public function get_mappings() {
+        global $wpdb;
+        return $this->wpdb->get_results(
+            "SELECT * FROM {$wpdb->prefix}wl_mapping",
+            ARRAY_A
+        );
+    }
+
+    /**
+     * Returns an array of active mappings.
+     *
+     * Each mapping contains one or more rule groups which in turn contain one or more rules.
+     *
+     * @return array An array of mappings.
+     */
+    public function get_active_mappings() {
+        global $wpdb;
+        return $this->wpdb->get_results(
+            "SELECT * FROM {$wpdb->prefix}wl_mapping WHERE mapping_status = 'active'",
+            ARRAY_A
+        );
+    }
+
+    /**
+     * Returns a list of property rows
+     *
+     * @param int $mapping_id Primary key of mapping table.
+     *
+     * @return array List of property items belong to $mapping_id.
+     */
+    public function get_properties( $mapping_id ) {
+        global $wpdb;
+        $property_rows = $wpdb->get_results(
+            $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}wl_mapping_property WHERE mapping_id=%d", $mapping_id ),
+            ARRAY_A
+        );
+
+        return $property_rows;
+    }
+
+    /**
+     * Check if the row exists in the table
+     *
+     * @param string $table_name The table name you want to query, completely escaped value.
+     * @param string $primary_key_name The primary key you want to query, should be escaped before passing.
+     * @param int    $primary_key_value The primary key value, no need to escape.
+     *
+     * @return bool Returns true if the row exists, false if it does not
+     */
+    private function check_if_row_exists( $table_name, $primary_key_name, $primary_key_value ) {
+        global $wpdb;
+        $primary_key_value = (int) $primary_key_value;
+        $count             = (int) $this->wpdb->get_var(
+            $wpdb->prepare(
+                'SELECT COUNT(%1s) from %2s where %3s = %4d', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.UnquotedComplexPlaceholder
+                $primary_key_name,
+                $table_name,
+                $primary_key_name,
+                $primary_key_value
+            )
+        );
+
+        return $count > 0;
+    }
+
+    /**
+     * Insert new mapping item with title
+     *
+     * @param string $title Title of the mapping item.
+     *
+     * @return int Id of the inserted mapping item.
+     */
+    public function insert_mapping_item( $title ) {
+        $mapping_table_name = $this->wpdb->prefix . WL_MAPPING_TABLE_NAME;
+        $this->wpdb->insert(
+            $mapping_table_name,
+            array( 'mapping_title' => $title )
+        );
+
+        return $this->wpdb->insert_id;
+    }
+
+    /**
+     * Update mapping item with new title
+     *
+     * @param array $mapping_data Array of the mapping data.
+     *
+     * @return int Id of the inserted mapping item
+     */
+    public function insert_or_update_mapping_item( $mapping_data ) {
+        $mapping_table_name = $this->wpdb->prefix . WL_MAPPING_TABLE_NAME;
+        $mapping_id         = array_key_exists( 'mapping_id', $mapping_data ) ? (int) $mapping_data['mapping_id'] : null;
+        if ( $this->check_if_row_exists( $mapping_table_name, 'mapping_id', $mapping_data['mapping_id'] ) ) {
+            $this->wpdb->update(
+                $mapping_table_name,
+                $mapping_data,
+                array( 'mapping_id' => $mapping_id )
+            );
+        } else {
+            $this->wpdb->insert(
+                $mapping_table_name,
+                $mapping_data
+            );
+            $mapping_id = (int) $this->wpdb->insert_id;
+        }
+
+        return $mapping_id;
+    }
+
+    /**
+     * Updates rule item.
+     *
+     * @param array $rule_item_data The rule_item_data, should contain rule_id.
+     *
+     * @return int $rule_id The inserted rule id.
+     */
+    public function insert_or_update_rule_item( $rule_item_data ) {
+        $rule_table_name = $this->wpdb->prefix . WL_RULE_TABLE_NAME;
+        $rule_id         = array_key_exists( 'rule_id', $rule_item_data ) ? $rule_item_data['rule_id'] : null;
+        if ( $this->check_if_row_exists( $rule_table_name, 'rule_id', $rule_id ) ) {
+            $this->wpdb->update( $rule_table_name, $rule_item_data, array( 'rule_id' => $rule_id ) );
+        } else {
+            $this->wpdb->insert( $rule_table_name, $rule_item_data );
+            $rule_id = $this->wpdb->insert_id;
+        }
+
+        return $rule_id;
+    }
+
+    /**
+     * If a rule group exists doesn't do anything, but if rule group
+     * didn't exist then it inserts a new entry.
+     *
+     * @param int $mapping_id Primary key for mapping table.
+     *
+     * @return int The inserted rule group id.
+     */
+    public function insert_rule_group( $mapping_id ) {
+        $rule_group_table_name = $this->wpdb->prefix . WL_RULE_GROUP_TABLE_NAME;
+        $this->wpdb->insert(
+            $rule_group_table_name,
+            array(
+                'mapping_id' => $mapping_id,
+            )
+        );
+
+        return $this->wpdb->insert_id;
+    }
+
+    /**
+     * Deletes a rule item by rule_id from rule and rule group table.
+     *
+     * @param int $rule_id Primary key for rule table.
+     *
+     * @return void
+     */
+    public function delete_rule_item( $rule_id ) {
+        $rule_table_name = $this->wpdb->prefix . WL_RULE_TABLE_NAME;
+        $this->wpdb->delete( $rule_table_name, array( 'rule_id' => $rule_id ) );
+    }
+
+    /**
+     * Deletes a rule group item by rule_group_id from rule group table.
+     *
+     * @param int $rule_group_id Primary key for rule table.
+     *
+     * @return void
+     */
+    public function delete_rule_group_item( $rule_group_id ) {
+        $rule_group_table_name = $this->wpdb->prefix . WL_RULE_GROUP_TABLE_NAME;
+        $this->wpdb->delete( $rule_group_table_name, array( 'rule_group_id' => $rule_group_id ) );
+    }
+
+    /**
+     * Deletes a mapping item by mapping_id
+     *
+     * @param int $mapping_id Primary key for mapping table.
+     *
+     * @return void
+     */
+    public function delete_mapping_item( $mapping_id ) {
+        $mapping_table_name = $this->wpdb->prefix . WL_MAPPING_TABLE_NAME;
+        $this->wpdb->delete( $mapping_table_name, array( 'mapping_id' => $mapping_id ) );
+    }
+
+    /**
+     * Gets a list of rule group items.
+     *
+     * @param int $mapping_id Primary key for mapping table.
+     *
+     * @return array Get list of rule group items.
+     */
+    public function get_rule_group_list( $mapping_id ) {
+        global $wpdb;
+        return $wpdb->get_results(
+            $wpdb->prepare(
+                "SELECT rule_group_id FROM {$wpdb->prefix}wl_mapping_rule_group WHERE mapping_id=%d",
+                $mapping_id
+            ),
+            ARRAY_A
+        );
+    }
+
+    /**
+     * Gets a list of rule group items.
+     *
+     * @param int $mapping_id Primary key for mapping table.
+     *
+     * @return array Get list of rule group items.
+     */
+    public function get_rule_groups_by_mapping( $mapping_id ) {
+        global $wpdb;
+        $rule_group_rows = $wpdb->get_results(
+            $wpdb->prepare(
+                "SELECT rule_group_id FROM {$wpdb->prefix}wl_mapping_rule_group WHERE mapping_id=%d",
+                $mapping_id
+            ),
+            ARRAY_A
+        );
+
+        // List of all rule group items.
+        $rule_groups = array();
+        foreach ( $rule_group_rows as $rule_group_row ) {
+            $rule_groups[] = array(
+                'rule_group_id' => $rule_group_row['rule_group_id'],
+                'rules'         => $this->get_rules_by_rule_group( $rule_group_row['rule_group_id'] ),
+            );
+        }
+
+        return $rule_groups;
+    }
+
+    /**
+     * Gets a list of rule items belong to rule_group_id.
+     *
+     * @param int $rule_group_id Indicates which group the item belongs to.
+     *
+     * @return array Get list of rule items.
+     */
+    public function get_rules_by_rule_group( $rule_group_id ) {
+        global $wpdb;
+        return $wpdb->get_results(
+            $wpdb->prepare(
+                "SELECT * FROM {$wpdb->prefix}wl_mapping_rule WHERE rule_group_id=%d",
+                $rule_group_id
+            ),
+            ARRAY_A
+        );
+    }
+
+    /**
+     * Insert/Update property item.
+     *
+     * @param array $property_data Property row from table/ui.
+     *
+     * @return int Inserted Property Id.
+     */
+    public function insert_or_update_property( $property_data ) {
+        $property_table_name = $this->wpdb->prefix . WL_PROPERTY_TABLE_NAME;
+        $property_id         = array_key_exists( 'property_id', $property_data ) ? $property_data['property_id'] : null;
+
+        if ( $this->check_if_row_exists( $property_table_name, 'property_id', $property_id ) ) {
+            $this->wpdb->update(
+                $property_table_name,
+                $property_data,
+                array( 'property_id' => $property_id )
+            );
+        } else {
+            $this->wpdb->insert( $property_table_name, $property_data );
+            $property_id = $this->wpdb->insert_id;
+        }
+
+        return $property_id;
+    }
+
+    /**
+     * Gets a single mapping item row.
+     *
+     * @param int $mapping_id Primary key of mapping table.
+     *
+     * @return array Returns single mapping table row..
+     */
+    public function get_mapping_item_data( $mapping_id ) {
+        global $wpdb;
+        return $wpdb->get_row(
+            $wpdb->prepare(
+                "SELECT * FROM {$wpdb->prefix}wl_mapping WHERE mapping_id=%d",
+                $mapping_id
+            ),
+            ARRAY_A
+        );
+    }
+
+    /**
+     * Delete property item.
+     *
+     * @param int $property_id Primary key for property table.
+     *
+     * @return int|false The number of rows updated, or false on error.
+     */
+    public function delete_property( $property_id ) {
+        $property_table_name = $this->wpdb->prefix . WL_PROPERTY_TABLE_NAME;
+
+        return $this->wpdb->delete( $property_table_name, array( 'property_id' => $property_id ) );
+    }
 
 }

src/wordlift/mappings/transforms/class-post-id-to-entity-transform-function.php

Indentation +54 added lines, -54 removed lines

@@ -20,79 +20,79 @@
  */
 class Post_Id_To_Entity_Transform_Function implements Mappings_Transform_Function {
 
-	public function __construct() {
+    public function __construct() {
 
-		add_filter( 'wl_mappings_transformation_functions', array( $this, 'wl_mappings_transformation_functions' ) );
+        add_filter( 'wl_mappings_transformation_functions', array( $this, 'wl_mappings_transformation_functions' ) );
 
-	}
+    }
 
-	/**
-	 * Hook to add ourselves to the list of available transform functions.
-	 *
-	 * @param Mappings_Transform_Function[] $value An array of {@link Mappings_Transform_Function}s.
-	 *
-	 * @return Mappings_Transform_Function[] An updated array with ourselves too.
-	 */
-	public function wl_mappings_transformation_functions( $value ) {
+    /**
+     * Hook to add ourselves to the list of available transform functions.
+     *
+     * @param Mappings_Transform_Function[] $value An array of {@link Mappings_Transform_Function}s.
+     *
+     * @return Mappings_Transform_Function[] An updated array with ourselves too.
+     */
+    public function wl_mappings_transformation_functions( $value ) {
 
-		$value[] = $this;
+        $value[] = $this;
 
-		return $value;
-	}
+        return $value;
+    }
 
-	/**
-	 * @inheritDoc
-	 */
-	public function get_name() {
+    /**
+     * @inheritDoc
+     */
+    public function get_name() {
 
-		return 'post_id_to_entity';
-	}
+        return 'post_id_to_entity';
+    }
 
-	/**
-	 * @inheritDoc
-	 */
-	public function get_label() {
+    /**
+     * @inheritDoc
+     */
+    public function get_label() {
 
-		return __( 'Post ID to Entity', 'wordlift' );
-	}
+        return __( 'Post ID to Entity', 'wordlift' );
+    }
 
-	/**
-	 * @inheritDoc
-	 */
-	// phpcs:ignore VariableAnalysis.CodeAnalysis.VariableAnalysis.UnusedVariable
-	public function transform_data( $data, $jsonld, &$references, $post_id ) {
+    /**
+     * @inheritDoc
+     */
+    // phpcs:ignore VariableAnalysis.CodeAnalysis.VariableAnalysis.UnusedVariable
+    public function transform_data( $data, $jsonld, &$references, $post_id ) {
 
-		$ret_val = array();
-		foreach ( (array) $data as $target_post_id ) {
+        $ret_val = array();
+        foreach ( (array) $data as $target_post_id ) {
 
-			// We need a numeric post ID.
-			if ( ! is_numeric( $target_post_id ) ) {
+            // We need a numeric post ID.
+            if ( ! is_numeric( $target_post_id ) ) {
 
-				// phpcs:ignore WordPress.PHP.NoSilencedErrors.Discouraged
-				@header( "X-Post-Id-To-Entity-Transform-Function: $target_post_id not numeric." );
+                // phpcs:ignore WordPress.PHP.NoSilencedErrors.Discouraged
+                @header( "X-Post-Id-To-Entity-Transform-Function: $target_post_id not numeric." );
 
-				continue;
-			}
+                continue;
+            }
 
-			// Get the entity by URI.
-			$entity_url = Wordpress_Content_Service::get_instance()
-												   ->get_entity_id( Wordpress_Content_Id::create_post( $target_post_id ) );
+            // Get the entity by URI.
+            $entity_url = Wordpress_Content_Service::get_instance()
+                                                    ->get_entity_id( Wordpress_Content_Id::create_post( $target_post_id ) );
 
-			// No entity URL.
-			if ( empty( $entity_url ) ) {
-				// phpcs:ignore WordPress.PHP.NoSilencedErrors.Discouraged
-				@header( "X-Post-Id-To-Entity-Transform-Function: entity url for $data not found." );
+            // No entity URL.
+            if ( empty( $entity_url ) ) {
+                // phpcs:ignore WordPress.PHP.NoSilencedErrors.Discouraged
+                @header( "X-Post-Id-To-Entity-Transform-Function: entity url for $data not found." );
 
-				continue;
-			}
+                continue;
+            }
 
-			// Add the entity among the references using the post ID.
-			$references[] = (int) $target_post_id;
+            // Add the entity among the references using the post ID.
+            $references[] = (int) $target_post_id;
 
-			$ret_val[] = array( '@id' => $entity_url );
-		}
+            $ret_val[] = array( '@id' => $entity_url );
+        }
 
-		return $ret_val;
-	}
+        return $ret_val;
+    }
 
 }

Spacing +11 added lines, -11 removed lines

@@ -22,7 +22,7 @@ 
 
 	public function __construct() {
 
-		add_filter( 'wl_mappings_transformation_functions', array( $this, 'wl_mappings_transformation_functions' ) );
+		add_filter('wl_mappings_transformation_functions', array($this, 'wl_mappings_transformation_functions'));
 
 	}
 
@@ -33,7 +33,7 @@ 
 	 *
 	 * @return Mappings_Transform_Function[] An updated array with ourselves too.
 	 */
-	public function wl_mappings_transformation_functions( $value ) {
+	public function wl_mappings_transformation_functions($value) {
 
 		$value[] = $this;
 
@@ -53,35 +53,35 @@ 
 	 */
 	public function get_label() {
 
-		return __( 'Post ID to Entity', 'wordlift' );
+		return __('Post ID to Entity', 'wordlift');
 	}
 
 	/**
 	 * @inheritDoc
 	 */
 	// phpcs:ignore VariableAnalysis.CodeAnalysis.VariableAnalysis.UnusedVariable
-	public function transform_data( $data, $jsonld, &$references, $post_id ) {
+	public function transform_data($data, $jsonld, &$references, $post_id) {
 
 		$ret_val = array();
-		foreach ( (array) $data as $target_post_id ) {
+		foreach ((array) $data as $target_post_id) {
 
 			// We need a numeric post ID.
-			if ( ! is_numeric( $target_post_id ) ) {
+			if ( ! is_numeric($target_post_id)) {
 
 				// phpcs:ignore WordPress.PHP.NoSilencedErrors.Discouraged
-				@header( "X-Post-Id-To-Entity-Transform-Function: $target_post_id not numeric." );
+				@header("X-Post-Id-To-Entity-Transform-Function: $target_post_id not numeric.");
 
 				continue;
 			}
 
 			// Get the entity by URI.
 			$entity_url = Wordpress_Content_Service::get_instance()
-												   ->get_entity_id( Wordpress_Content_Id::create_post( $target_post_id ) );
+												   ->get_entity_id(Wordpress_Content_Id::create_post($target_post_id));
 
 			// No entity URL.
-			if ( empty( $entity_url ) ) {
+			if (empty($entity_url)) {
 				// phpcs:ignore WordPress.PHP.NoSilencedErrors.Discouraged
-				@header( "X-Post-Id-To-Entity-Transform-Function: entity url for $data not found." );
+				@header("X-Post-Id-To-Entity-Transform-Function: entity url for $data not found.");
 
 				continue;
 			}
@@ -89,7 +89,7 @@ 
 			// Add the entity among the references using the post ID.
 			$references[] = (int) $target_post_id;
 
-			$ret_val[] = array( '@id' => $entity_url );
+			$ret_val[] = array('@id' => $entity_url);
 		}
 
 		return $ret_val;

src/wordlift/mappings/transforms/class-url-to-entity-transform-function.php

Indentation +67 added lines, -67 removed lines

@@ -19,72 +19,72 @@
  */
 class Url_To_Entity_Transform_Function implements Mappings_Transform_Function {
 
-	/**
-	 * The {@link Wordlift_Entity_Uri_Service} instance.
-	 *
-	 * @var Wordlift_Entity_Uri_Service $entity_uri_service The {@link Wordlift_Entity_Uri_Service} instance.
-	 */
-	private $entity_uri_service;
-
-	/**
-	 * Url_To_Entity_Transform_Function constructor.
-	 *
-	 * @param Wordlift_Entity_Uri_Service $entity_uri_service The {@link Wordlift_Entity_Uri_Service} instance.
-	 */
-	public function __construct( $entity_uri_service ) {
-
-		$this->entity_uri_service = $entity_uri_service;
-
-		add_filter( 'wl_mappings_transformation_functions', array( $this, 'wl_mappings_transformation_functions' ) );
-
-	}
-
-	/**
-	 * Hook to add ourselves to the list of available transform functions.
-	 *
-	 * @param Mappings_Transform_Function[] $value An array of {@link Mappings_Transform_Function}s.
-	 *
-	 * @return Mappings_Transform_Function[] An updated array with ourselves too.
-	 */
-	public function wl_mappings_transformation_functions( $value ) {
-
-		$value[] = $this;
-
-		return $value;
-	}
-
-	/**
-	 * @inheritDoc
-	 */
-	public function get_name() {
-
-		return 'url_to_entity';
-	}
-
-	/**
-	 * @inheritDoc
-	 */
-	public function get_label() {
-
-		return __( 'URL to Entity', 'wordlift' );
-	}
-
-	/**
-	 * @inheritDoc
-	 */
-	// phpcs:ignore VariableAnalysis.CodeAnalysis.VariableAnalysis.UnusedVariable
-	public function transform_data( $data, $jsonld, &$references, $post_id ) {
-
-		// Get the entity by URI.
-		$post = $this->entity_uri_service->get_entity( $data );
-
-		// If found, add the reference.
-		if ( is_a( $post, 'WP_Post' ) ) {
-			// Add the entity among the references using the post ID.
-			$references[] = $post->ID;
-		}
-
-		return array( '@id' => $data );
-	}
+    /**
+     * The {@link Wordlift_Entity_Uri_Service} instance.
+     *
+     * @var Wordlift_Entity_Uri_Service $entity_uri_service The {@link Wordlift_Entity_Uri_Service} instance.
+     */
+    private $entity_uri_service;
+
+    /**
+     * Url_To_Entity_Transform_Function constructor.
+     *
+     * @param Wordlift_Entity_Uri_Service $entity_uri_service The {@link Wordlift_Entity_Uri_Service} instance.
+     */
+    public function __construct( $entity_uri_service ) {
+
+        $this->entity_uri_service = $entity_uri_service;
+
+        add_filter( 'wl_mappings_transformation_functions', array( $this, 'wl_mappings_transformation_functions' ) );
+
+    }
+
+    /**
+     * Hook to add ourselves to the list of available transform functions.
+     *
+     * @param Mappings_Transform_Function[] $value An array of {@link Mappings_Transform_Function}s.
+     *
+     * @return Mappings_Transform_Function[] An updated array with ourselves too.
+     */
+    public function wl_mappings_transformation_functions( $value ) {
+
+        $value[] = $this;
+
+        return $value;
+    }
+
+    /**
+     * @inheritDoc
+     */
+    public function get_name() {
+
+        return 'url_to_entity';
+    }
+
+    /**
+     * @inheritDoc
+     */
+    public function get_label() {
+
+        return __( 'URL to Entity', 'wordlift' );
+    }
+
+    /**
+     * @inheritDoc
+     */
+    // phpcs:ignore VariableAnalysis.CodeAnalysis.VariableAnalysis.UnusedVariable
+    public function transform_data( $data, $jsonld, &$references, $post_id ) {
+
+        // Get the entity by URI.
+        $post = $this->entity_uri_service->get_entity( $data );
+
+        // If found, add the reference.
+        if ( is_a( $post, 'WP_Post' ) ) {
+            // Add the entity among the references using the post ID.
+            $references[] = $post->ID;
+        }
+
+        return array( '@id' => $data );
+    }
 
 }

Spacing +8 added lines, -8 removed lines

@@ -31,11 +31,11 @@ 
 	 *
 	 * @param Wordlift_Entity_Uri_Service $entity_uri_service The {@link Wordlift_Entity_Uri_Service} instance.
 	 */
-	public function __construct( $entity_uri_service ) {
+	public function __construct($entity_uri_service) {
 
 		$this->entity_uri_service = $entity_uri_service;
 
-		add_filter( 'wl_mappings_transformation_functions', array( $this, 'wl_mappings_transformation_functions' ) );
+		add_filter('wl_mappings_transformation_functions', array($this, 'wl_mappings_transformation_functions'));
 
 	}
 
@@ -46,7 +46,7 @@ 
 	 *
 	 * @return Mappings_Transform_Function[] An updated array with ourselves too.
 	 */
-	public function wl_mappings_transformation_functions( $value ) {
+	public function wl_mappings_transformation_functions($value) {
 
 		$value[] = $this;
 
@@ -66,25 +66,25 @@ 
 	 */
 	public function get_label() {
 
-		return __( 'URL to Entity', 'wordlift' );
+		return __('URL to Entity', 'wordlift');
 	}
 
 	/**
 	 * @inheritDoc
 	 */
 	// phpcs:ignore VariableAnalysis.CodeAnalysis.VariableAnalysis.UnusedVariable
-	public function transform_data( $data, $jsonld, &$references, $post_id ) {
+	public function transform_data($data, $jsonld, &$references, $post_id) {
 
 		// Get the entity by URI.
-		$post = $this->entity_uri_service->get_entity( $data );
+		$post = $this->entity_uri_service->get_entity($data);
 
 		// If found, add the reference.
-		if ( is_a( $post, 'WP_Post' ) ) {
+		if (is_a($post, 'WP_Post')) {
 			// Add the entity among the references using the post ID.
 			$references[] = $post->ID;
 		}
 
-		return array( '@id' => $data );
+		return array('@id' => $data);
 	}
 
 }

src/wordlift/mappings/transforms/class-taxonomy-to-terms-transform-function.php

Indentation +39 added lines, -39 removed lines

@@ -18,57 +18,57 @@
  */
 class Taxonomy_To_Terms_Transform_Function implements Mappings_Transform_Function {
 
-	/**
-	 * Taxonomy_To_Terms_Transform_Function constructor.
-	 */
-	public function __construct() {
+    /**
+     * Taxonomy_To_Terms_Transform_Function constructor.
+     */
+    public function __construct() {
 
-		add_filter( 'wl_mappings_transformation_functions', array( $this, 'wl_mappings_transformation_functions' ) );
+        add_filter( 'wl_mappings_transformation_functions', array( $this, 'wl_mappings_transformation_functions' ) );
 
-	}
+    }
 
-	/**
-	 * Hook to add ourselves to the list of available transform functions.
-	 *
-	 * @param Mappings_Transform_Function[] $value An array of {@link Mappings_Transform_Function}s.
-	 *
-	 * @return Mappings_Transform_Function[] An updated array with ourselves too.
-	 */
-	public function wl_mappings_transformation_functions( $value ) {
+    /**
+     * Hook to add ourselves to the list of available transform functions.
+     *
+     * @param Mappings_Transform_Function[] $value An array of {@link Mappings_Transform_Function}s.
+     *
+     * @return Mappings_Transform_Function[] An updated array with ourselves too.
+     */
+    public function wl_mappings_transformation_functions( $value ) {
 
-		$value[] = $this;
+        $value[] = $this;
 
-		return $value;
-	}
+        return $value;
+    }
 
-	/**
-	 * @inheritDoc
-	 */
-	public function get_name() {
+    /**
+     * @inheritDoc
+     */
+    public function get_name() {
 
-		return 'taxonomy_to_terms';
-	}
+        return 'taxonomy_to_terms';
+    }
 
-	/**
-	 * @inheritDoc
-	 */
-	public function get_label() {
+    /**
+     * @inheritDoc
+     */
+    public function get_label() {
 
-		return __( 'Taxonomy to Terms', 'wordlift' );
-	}
+        return __( 'Taxonomy to Terms', 'wordlift' );
+    }
 
-	/**
-	 * @inheritDoc
-	 */
-	public function transform_data( $data, $jsonld, &$references, $post_id ) {
+    /**
+     * @inheritDoc
+     */
+    public function transform_data( $data, $jsonld, &$references, $post_id ) {
 
-		$terms = wp_get_object_terms( $post_id, $data, array( 'fields' => 'names' ) );
+        $terms = wp_get_object_terms( $post_id, $data, array( 'fields' => 'names' ) );
 
-		if ( ! is_array( $terms ) || empty( $terms ) ) {
-			return null;
-		}
+        if ( ! is_array( $terms ) || empty( $terms ) ) {
+            return null;
+        }
 
-		return $terms;
-	}
+        return $terms;
+    }
 
 }

Spacing +6 added lines, -6 removed lines

@@ -23,7 +23,7 @@ 
 	 */
 	public function __construct() {
 
-		add_filter( 'wl_mappings_transformation_functions', array( $this, 'wl_mappings_transformation_functions' ) );
+		add_filter('wl_mappings_transformation_functions', array($this, 'wl_mappings_transformation_functions'));
 
 	}
 
@@ -34,7 +34,7 @@ 
 	 *
 	 * @return Mappings_Transform_Function[] An updated array with ourselves too.
 	 */
-	public function wl_mappings_transformation_functions( $value ) {
+	public function wl_mappings_transformation_functions($value) {
 
 		$value[] = $this;
 
@@ -54,17 +54,17 @@ 
 	 */
 	public function get_label() {
 
-		return __( 'Taxonomy to Terms', 'wordlift' );
+		return __('Taxonomy to Terms', 'wordlift');
 	}
 
 	/**
 	 * @inheritDoc
 	 */
-	public function transform_data( $data, $jsonld, &$references, $post_id ) {
+	public function transform_data($data, $jsonld, &$references, $post_id) {
 
-		$terms = wp_get_object_terms( $post_id, $data, array( 'fields' => 'names' ) );
+		$terms = wp_get_object_terms($post_id, $data, array('fields' => 'names'));
 
-		if ( ! is_array( $terms ) || empty( $terms ) ) {
+		if ( ! is_array($terms) || empty($terms)) {
 			return null;
 		}