DeleteCommentMetaModule::change_meta_query() - Code Metrics - Inspection of "Refactors the way meta query is handled and fixes..." - sudar/bulk-delete - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — 516-fix/enhance-data-type-and-... ( 46e87d...caa875 )

unknown

created 2018-11-23 08:30 UTC

DeleteCommentMetaModule::change_meta_query() A

↳ Parent: DeleteCommentMetaModule

Complexity

Conditions	5
Paths	5

Size

Total Lines	29
Code Lines	23

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	5
eloc	23
nc	5
nop	2
dl	0
loc	29
rs	9.2408
c	0
b	0
f	0

<?php

namespace BulkWP\BulkDelete\Core\Metas\Modules;

use BulkWP\BulkDelete\Core\Metas\MetasModule;

defined( 'ABSPATH' ) || exit; // Exit if accessed directly.

/**
 * Delete Comment Meta Module.
 *
 * @since 6.0.0
 */
class DeleteCommentMetaModule extends MetasModule {
	protected function initialize() {
		$this->field_slug    = 'comment_meta';
		$this->meta_box_slug = 'bd-comment-meta';
		$this->action        = 'delete_comment_meta';
		$this->cron_hook     = 'do-bulk-delete-comment-meta';
		$this->messages      = array(
			'box_label'  => __( 'Bulk Delete Comment Meta', 'bulk-delete' ),
			'scheduled'  => __( 'Comment meta fields from the comments with the selected criteria are scheduled for deletion.', 'bulk-delete' ),
			'cron_label' => __( 'Delete Comment Meta', 'bulk-delete' ),
		);
	}

	public function register( $hook_suffix, $page_slug ) {
		parent::register( $hook_suffix, $page_slug );

		add_action( 'bd_delete_comment_meta_form', array( $this, 'add_filtering_options' ) );

		add_filter( 'bd_delete_comment_meta_options', array( $this, 'process_filtering_options' ), 10, 2 );
		add_filter( 'bd_delete_comment_meta_query', array( $this, 'change_meta_query' ), 10, 2 );
	}

	/**
	 * Render the Delete Comment Meta box.
	 */
	public function render() {
		?>
		<!-- Comment Meta box start-->
		<fieldset class="options">
			<h4><?php _e( 'Select the post type whose comment meta fields you want to delete', 'bulk-delete' ); ?></h4>
			<table class="optiontable">
				<?php $this->render_post_type_dropdown(); ?>
			</table>

			<h4><?php _e( 'Choose your comment meta field settings', 'bulk-delete' ); ?></h4>
			<table class="optiontable">
				<tr>
					<td>
						<input name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value" value="false" type="radio" checked>
						<label for="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value"><?php echo __( 'Delete based on comment meta key name only', 'bulk-delete' ); ?></label>
					</td>
				</tr>

				<tr>
					<td>
						<input type="radio" value="true" name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value">

						<label for="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value"><?php echo __( 'Delete based on comment meta key name and value', 'bulk-delete' ); ?></label>
					</td>
				</tr>

				<tr>
					<td>
						<label for="smbd_<?php echo esc_attr( $this->field_slug ); ?>_meta_key"><?php _e( 'Comment Meta Key ', 'bulk-delete' ); ?></label>
						<input name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_meta_key" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_meta_key" placeholder="<?php _e( 'Meta Key', 'bulk-delete' ); ?>">
					</td>
				</tr>
			</table>

			<?php
			/**
			 * Add more fields to the delete comment meta field form.
			 * This hook can be used to add more fields to the delete comment meta field form.
			 *
			 * @since 5.4
			 */
			do_action( 'bd_delete_comment_meta_form' );
			?>
			<table class="optiontable">
				<tr>
					<td colspan="2">
						<h4><?php _e( 'Choose your deletion options', 'bulk-delete' ); ?></h4>
					</td>
				</tr>

				<?php $this->render_restrict_settings( 'comments' ); ?>
				<?php $this->render_limit_settings(); ?>
				<?php $this->render_cron_settings(); ?>

			</table>
		</fieldset>

		<?php $this->render_submit_button(); ?>

		<!-- Comment Meta box end-->
		<?php
	}

	protected function convert_user_input_to_options( $request, $options ) {
		$options['post_type'] = esc_sql( bd_array_get( $request, 'smbd_' . $this->field_slug . '_post_type', 'post' ) );

		$options['use_value'] = bd_array_get_bool( $request, 'smbd_' . $this->field_slug . '_use_value', false );
		$options['meta_key']  = esc_sql( bd_array_get( $request, 'smbd_' . $this->field_slug . '_meta_key', '' ) );

		/**
		 * Delete comment-meta delete options filter.
		 *
		 * This filter is for processing filtering options for deleting comment meta.
		 *
		 * @since 5.4
		 */
		return apply_filters( 'bd_delete_comment_meta_options', $options, $request );
	}

	protected function do_delete( $options ) {
		$args = array(
			'post_type' => $options['post_type'],
		);

		if ( $options['limit_to'] > 0 ) {
			$args['number'] = $options['limit_to'];
		}

		$op   = $options['date_op'];
		$days = $options['days'];

		if ( $options['restrict'] ) {
			$args['date_query'] = array(
				array(
					'column' => 'comment_date',
					$op      => "{$days} day ago",
				),
			);
		}

		if ( $options['use_value'] ) {
			$args['meta_query'] = apply_filters( 'bd_delete_comment_meta_query', array(), $options );
		} else {
			$args['meta_key'] = $options['meta_key'];
		}

		$meta_deleted = 0;
		$comments     = get_comments( $args );

		foreach ( $comments as $comment ) {
			// Todo: Don't delete all meta rows if there are duplicate meta keys.
			// See https://github.com/sudar/bulk-delete/issues/515 for details.
			if ( delete_comment_meta( $comment->comment_ID, $options['meta_key'] ) ) {
				$meta_deleted ++;
			}
		}

		return $meta_deleted;
	}

	public function filter_js_array( $js_array ) {
		$js_array['dt_iterators'][]              = '_' . $this->field_slug;
		$js_array['validators'][ $this->action ] = 'noValidation';

		$js_array['pre_action_msg'][ $this->action ] = 'deleteCMWarning';
		$js_array['msg']['deleteCMWarning']          = __( 'Are you sure you want to delete all the comment meta fields that match the selected filters?', 'bulk-delete' );

		return $js_array;
	}

	protected function get_success_message( $items_deleted ) {
		/* translators: 1 Number of comment deleted */
		return _n( 'Deleted comment meta field from %d comment', 'Deleted comment meta field from %d comments', $items_deleted, 'bulk-delete' );
	}

	/**
	 * Append filtering options to the delete comment meta form.
	 *
	 * This function was originally part of the Bulk Delete Comment Meta add-on.
	 *
	 * @since 0.1 of Bulk Delete Comment Meta add-on
	 */
	public function add_filtering_options() {
		?>
		<table class="optiontable" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_filters" style="display:none;">
			<tr>
				<td>
					<?php _e( 'Comment Meta Value ', 'bulk-delete' ); ?>
					<?php $this->render_data_types_dropdown(); ?>
					<?php $this->render_numeric_operators_dropdown(); ?>	
					<?php $this->render_string_operators_dropdown(); ?>
					<?php
						$operators = array( '=', '!=', '>', '<=', '>', '>=', 'EXISTS', 'NOT EXISTS' );
						$class     = 'date';
					?>
					<?php $this->render_numeric_operators_dropdown( $class, $operators ); ?>
					<input name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_value"
						id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_value">
					<span class="date-fields">
						<?php _e( 'Or', 'bulk-delete' ); ?>
						<select name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_relative_date" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_relative_date" class="relative-date-fields">
							<option value=""><?php _e( 'Select Relative date', 'bulk-delete' ); ?></option>
							<option value="yesterday"><?php _e( 'Yesterday', 'bulk-delete' ); ?></option>
							<option value="today"><?php _e( 'Today', 'bulk-delete' ); ?></option>
							<option value="tomorrow"><?php _e( 'Tomorrow', 'bulk-delete' ); ?></option>
							<option value="custom"><?php _e( 'Custom', 'bulk-delete' ); ?></option>
						</select>
						<?php echo apply_filters( 'bd_help_tooltip', '', __( 'You can select a date or enter a date which is relative to today.', 'bulk-delete' ) ); ?>
					</span>
					<span class="custom-date-fields">
						<input type="number" name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_unit" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_unit" style="width: 5%;">
						<select name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_type" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_type">
							<option value="day"><?php _e( 'Day', 'bulk-delete' ); ?></option>
							<option value="week"><?php _e( 'Week', 'bulk-delete' ); ?></option>
							<option value="month"><?php _e( 'Month', 'bulk-delete' ); ?></option>
							<option value="year"><?php _e( 'Year', 'bulk-delete' ); ?></option>
						</select>
					</span>
				</td>
			</tr>
			<tr class="date-format-fields">
				<td colspan="2">
					<label for="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_format">
						<?php _e( 'Meta value date format', 'bulk-delete' ); ?>
					</label>
					<input name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_format" placeholder="%Y-%m-%d">
					<?php echo apply_filters( 'bd_help_tooltip', '', __( "If you leave date format blank, then '%Y-%m-%d', will be assumed.", 'bulk-delete' ) ); ?>
					<p>
						<?php
						printf(
							/* translators: 1 Mysql Format specifier url.  */
							__( 'If you are storing the date in a format other than <em>YYYY-MM-DD</em> then enter the date format using <a href="%s" target="_blank" rel="noopener noreferrer">Mysql format specifiers</a>.', 'bulk-delete' ),
							'https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format'
						);
						?>
					</p>
				</td>
			</tr>
		</table>
		<?php
	}

	/**
	 * Process additional delete options.
	 *
	 * This function was originally part of the Bulk Delete Comment Meta add-on.
	 *
	 * @since 0.1 of Bulk Delete Comment Meta add-on
	 *
	 * @param array $delete_options Delete options array.
	 * @param array $post           The POST array.
	 *
	 * @return array Processed delete options array.
	 */
	public function process_filtering_options( $delete_options, $post ) {
		if ( 'true' == bd_array_get( $post, 'smbd_' . $this->field_slug . '_use_value', 'false' ) ) {
			$delete_options['meta_op']       = bd_array_get( $post, 'smbd_' . $this->field_slug . '_operator', '=' );
			$delete_options['meta_type']     = bd_array_get( $post, 'smbd_' . $this->field_slug . '_type', 'CHAR' );
			$delete_options['meta_value']    = bd_array_get( $post, 'smbd_' . $this->field_slug . '_value', '' );
			$delete_options['relative_date'] = bd_array_get( $post, 'smbd_' . $this->field_slug . '_relative_date', '' );
			$delete_options['date_unit']     = bd_array_get( $post, 'smbd_' . $this->field_slug . '_date_unit', '' );
			$delete_options['date_type']     = bd_array_get( $post, 'smbd_' . $this->field_slug . '_date_type', '' );
			$delete_options['date_format']   = bd_array_get( $post, 'smbd_' . $this->field_slug . '_date_format' );
		}

		return $delete_options;
	}

	/**
	 * Change the meta query.
	 *
	 * This function was originally part of the Bulk Delete Comment Meta add-on.
	 *
	 * @since 0.1 of Bulk Delete Comment Meta add-on
	 *
	 * @param array $meta_query     Meta query.
	 * @param array $delete_options List of options chosen by the user.
	 *
	 * @return array Modified meta query.
	 */
	public function change_meta_query( $meta_query, $delete_options ) {
		$query_vars = array(
			'key'     => $delete_options['meta_key'],
			'compare' => $delete_options['meta_op'],
			'type'    => $delete_options['meta_type'],
		);
		if ( in_array( $delete_options['meta_op'], array( 'EXISTS', 'NOT EXISTS' ), true ) ) {
			$meta_query = array( $query_vars );
			return $meta_query;
		}
		if ( 'DATE' === $delete_options['meta_type'] ) {
			$bd_date_handler = new \Bulk_Delete_Date_Handler();
			$meta_query      = $bd_date_handler->get_query( $delete_options );
			return $meta_query;
		}
		switch ( $delete_options['meta_op'] ) {
			case 'IN':
				$meta_value = explode( ',', $delete_options['meta_value'] );
				break;
			case 'BETWEEN':
				$meta_value = explode( ',', $delete_options['meta_value'] );
				break;
			default:
				$meta_value = $delete_options['meta_value'];
		}

		$query_vars['value'] = $meta_value;
		$meta_query          = array( $query_vars );
		return $meta_query;
	}

	/**
	 * Hook handler.
	 *
	 * This function was originally part of the Bulk Delete Comment Meta add-on.
	 *
	 * @since 0.1 of Bulk Delete Comment Meta add-on
	 *
	 * @param array $delete_options Delete options array.
	 */
	public function do_delete_comment_meta( $delete_options ) {
		do_action( 'bd_before_scheduler', $this->messages['cron_label'] );
		$count = $this->delete( $delete_options );
		do_action( 'bd_after_scheduler', $this->messages['cron_label'], $count );
	}
}


1			<?php
2
3			namespace BulkWP\BulkDelete\Core\Metas\Modules;
4
5			use BulkWP\BulkDelete\Core\Metas\MetasModule;
6
7			defined( 'ABSPATH' ) \|\| exit; // Exit if accessed directly.
8
9			/**
10			* Delete Comment Meta Module.
11			*
12			* @since 6.0.0
13			*/
14			class DeleteCommentMetaModule extends MetasModule {
15			protected function initialize() {
16			$this->field_slug = 'comment_meta';
17			$this->meta_box_slug = 'bd-comment-meta';
18			$this->action = 'delete_comment_meta';
19			$this->cron_hook = 'do-bulk-delete-comment-meta';
20			$this->messages = array(
21			'box_label' => __( 'Bulk Delete Comment Meta', 'bulk-delete' ),
22			'scheduled' => __( 'Comment meta fields from the comments with the selected criteria are scheduled for deletion.', 'bulk-delete' ),
23			'cron_label' => __( 'Delete Comment Meta', 'bulk-delete' ),
24			);
25			}
26
27			public function register( $hook_suffix, $page_slug ) {
28			parent::register( $hook_suffix, $page_slug );
29
30			add_action( 'bd_delete_comment_meta_form', array( $this, 'add_filtering_options' ) );
31
32			add_filter( 'bd_delete_comment_meta_options', array( $this, 'process_filtering_options' ), 10, 2 );
33			add_filter( 'bd_delete_comment_meta_query', array( $this, 'change_meta_query' ), 10, 2 );
34			}
35
36			/**
37			* Render the Delete Comment Meta box.
38			*/
39			public function render() {
40			?>
41			<!-- Comment Meta box start-->
42			<fieldset class="options">
43			<h4><?php _e( 'Select the post type whose comment meta fields you want to delete', 'bulk-delete' ); ?></h4>
44			<table class="optiontable">
45			<?php $this->render_post_type_dropdown(); ?>
46			</table>
47
48			<h4><?php _e( 'Choose your comment meta field settings', 'bulk-delete' ); ?></h4>
49			<table class="optiontable">
50			<tr>
51			<td>
52			<input name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value" value="false" type="radio" checked>
53			<label for="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value"><?php echo __( 'Delete based on comment meta key name only', 'bulk-delete' ); ?></label>
54			</td>
55			</tr>
56
57			<tr>
58			<td>
59			<input type="radio" value="true" name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value">
60
61			<label for="smbd_<?php echo esc_attr( $this->field_slug ); ?>_use_value"><?php echo __( 'Delete based on comment meta key name and value', 'bulk-delete' ); ?></label>
62			</td>
63			</tr>
64
65			<tr>
66			<td>
67			<label for="smbd_<?php echo esc_attr( $this->field_slug ); ?>_meta_key"><?php _e( 'Comment Meta Key ', 'bulk-delete' ); ?></label>
68			<input name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_meta_key" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_meta_key" placeholder="<?php _e( 'Meta Key', 'bulk-delete' ); ?>">
69			</td>
70			</tr>
71			</table>
72
73			<?php
74			/**
75			* Add more fields to the delete comment meta field form.
76			* This hook can be used to add more fields to the delete comment meta field form.
77			*
78			* @since 5.4
79			*/
80			do_action( 'bd_delete_comment_meta_form' );
81			?>
82			<table class="optiontable">
83			<tr>
84			<td colspan="2">
85			<h4><?php _e( 'Choose your deletion options', 'bulk-delete' ); ?></h4>
86			</td>
87			</tr>
88
89			<?php $this->render_restrict_settings( 'comments' ); ?>
90			<?php $this->render_limit_settings(); ?>
91			<?php $this->render_cron_settings(); ?>
92
93			</table>
94			</fieldset>
95
96			<?php $this->render_submit_button(); ?>
97
98			<!-- Comment Meta box end-->
99			<?php
100			}
101
102			protected function convert_user_input_to_options( $request, $options ) {
103			$options['post_type'] = esc_sql( bd_array_get( $request, 'smbd_' . $this->field_slug . '_post_type', 'post' ) );
104
105			$options['use_value'] = bd_array_get_bool( $request, 'smbd_' . $this->field_slug . '_use_value', false );
106			$options['meta_key'] = esc_sql( bd_array_get( $request, 'smbd_' . $this->field_slug . '_meta_key', '' ) );
107
108			/**
109			* Delete comment-meta delete options filter.
110			*
111			* This filter is for processing filtering options for deleting comment meta.
112			*
113			* @since 5.4
114			*/
115			return apply_filters( 'bd_delete_comment_meta_options', $options, $request );
116			}
117
118			protected function do_delete( $options ) {
119			$args = array(
120			'post_type' => $options['post_type'],
121			);
122
123			if ( $options['limit_to'] > 0 ) {
124			$args['number'] = $options['limit_to'];
125			}
126
127			$op = $options['date_op'];
128			$days = $options['days'];
129
130			if ( $options['restrict'] ) {
131			$args['date_query'] = array(
132			array(
133			'column' => 'comment_date',
134			$op => "{$days} day ago",
135			),
136			);
137			}
138
139			if ( $options['use_value'] ) {
140			$args['meta_query'] = apply_filters( 'bd_delete_comment_meta_query', array(), $options );
141			} else {
142			$args['meta_key'] = $options['meta_key'];
143			}
144
145			$meta_deleted = 0;
146			$comments = get_comments( $args );
147
148			foreach ( $comments as $comment ) {
149			// Todo: Don't delete all meta rows if there are duplicate meta keys.
150			// See https://github.com/sudar/bulk-delete/issues/515 for details.
151			if ( delete_comment_meta( $comment->comment_ID, $options['meta_key'] ) ) {
152			$meta_deleted ++;
153			}
154			}
155
156			return $meta_deleted;
157			}
158
159			public function filter_js_array( $js_array ) {
160			$js_array['dt_iterators'][] = '_' . $this->field_slug;
161			$js_array['validators'][ $this->action ] = 'noValidation';
162
163			$js_array['pre_action_msg'][ $this->action ] = 'deleteCMWarning';
164			$js_array['msg']['deleteCMWarning'] = __( 'Are you sure you want to delete all the comment meta fields that match the selected filters?', 'bulk-delete' );
165
166			return $js_array;
167			}
168
169			protected function get_success_message( $items_deleted ) {
170			/* translators: 1 Number of comment deleted */
171			return _n( 'Deleted comment meta field from %d comment', 'Deleted comment meta field from %d comments', $items_deleted, 'bulk-delete' );
172			}
173
174			/**
175			* Append filtering options to the delete comment meta form.
176			*
177			* This function was originally part of the Bulk Delete Comment Meta add-on.
178			*
179			* @since 0.1 of Bulk Delete Comment Meta add-on
180			*/
181			public function add_filtering_options() {
182			?>
183			<table class="optiontable" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_filters" style="display:none;">
184			<tr>
185			<td>
186			<?php _e( 'Comment Meta Value ', 'bulk-delete' ); ?>
187			<?php $this->render_data_types_dropdown(); ?>
188			<?php $this->render_numeric_operators_dropdown(); ?>
189			<?php $this->render_string_operators_dropdown(); ?>
190			<?php
191			$operators = array( '=', '!=', '>', '<=', '>', '>=', 'EXISTS', 'NOT EXISTS' );
192			$class = 'date';
193			?>
194			<?php $this->render_numeric_operators_dropdown( $class, $operators ); ?>
195			<input name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_value"
196			id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_value">
197			<span class="date-fields">
198			<?php _e( 'Or', 'bulk-delete' ); ?>
199			<select name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_relative_date" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_relative_date" class="relative-date-fields">
200			<option value=""><?php _e( 'Select Relative date', 'bulk-delete' ); ?></option>
201			<option value="yesterday"><?php _e( 'Yesterday', 'bulk-delete' ); ?></option>
202			<option value="today"><?php _e( 'Today', 'bulk-delete' ); ?></option>
203			<option value="tomorrow"><?php _e( 'Tomorrow', 'bulk-delete' ); ?></option>
204			<option value="custom"><?php _e( 'Custom', 'bulk-delete' ); ?></option>
205			</select>
206			<?php echo apply_filters( 'bd_help_tooltip', '', __( 'You can select a date or enter a date which is relative to today.', 'bulk-delete' ) ); ?>
207			</span>
208			<span class="custom-date-fields">
209			<input type="number" name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_unit" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_unit" style="width: 5%;">
210			<select name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_type" id="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_type">
211			<option value="day"><?php _e( 'Day', 'bulk-delete' ); ?></option>
212			<option value="week"><?php _e( 'Week', 'bulk-delete' ); ?></option>
213			<option value="month"><?php _e( 'Month', 'bulk-delete' ); ?></option>
214			<option value="year"><?php _e( 'Year', 'bulk-delete' ); ?></option>
215			</select>
216			</span>
217			</td>
218			</tr>
219			<tr class="date-format-fields">
220			<td colspan="2">
221			<label for="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_format">
222			<?php _e( 'Meta value date format', 'bulk-delete' ); ?>
223			</label>
224			<input name="smbd_<?php echo esc_attr( $this->field_slug ); ?>_date_format" placeholder="%Y-%m-%d">
225			<?php echo apply_filters( 'bd_help_tooltip', '', __( "If you leave date format blank, then '%Y-%m-%d', will be assumed.", 'bulk-delete' ) ); ?>
226			<p>
227			<?php
228			printf(
229			/* translators: 1 Mysql Format specifier url. */
230			__( 'If you are storing the date in a format other than <em>YYYY-MM-DD</em> then enter the date format using <a href="%s" target="_blank" rel="noopener noreferrer">Mysql format specifiers</a>.', 'bulk-delete' ),
231			'https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format'
232			);
233			?>
234			</p>
235			</td>
236			</tr>
237			</table>
238			<?php
239			}
240
241			/**
242			* Process additional delete options.
243			*
244			* This function was originally part of the Bulk Delete Comment Meta add-on.
245			*
246			* @since 0.1 of Bulk Delete Comment Meta add-on
247			*
248			* @param array $delete_options Delete options array.
249			* @param array $post The POST array.
250			*
251			* @return array Processed delete options array.
252			*/
253			public function process_filtering_options( $delete_options, $post ) {
254			if ( 'true' == bd_array_get( $post, 'smbd_' . $this->field_slug . '_use_value', 'false' ) ) {
255			$delete_options['meta_op'] = bd_array_get( $post, 'smbd_' . $this->field_slug . '_operator', '=' );
256			$delete_options['meta_type'] = bd_array_get( $post, 'smbd_' . $this->field_slug . '_type', 'CHAR' );
257			$delete_options['meta_value'] = bd_array_get( $post, 'smbd_' . $this->field_slug . '_value', '' );
258			$delete_options['relative_date'] = bd_array_get( $post, 'smbd_' . $this->field_slug . '_relative_date', '' );
259			$delete_options['date_unit'] = bd_array_get( $post, 'smbd_' . $this->field_slug . '_date_unit', '' );
260			$delete_options['date_type'] = bd_array_get( $post, 'smbd_' . $this->field_slug . '_date_type', '' );
261			$delete_options['date_format'] = bd_array_get( $post, 'smbd_' . $this->field_slug . '_date_format' );
262			}
263
264			return $delete_options;
265			}
266
267			/**
268			* Change the meta query.
269			*
270			* This function was originally part of the Bulk Delete Comment Meta add-on.
271			*
272			* @since 0.1 of Bulk Delete Comment Meta add-on
273			*
274			* @param array $meta_query Meta query.
275			* @param array $delete_options List of options chosen by the user.
276			*
277			* @return array Modified meta query.
278			*/
279			public function change_meta_query( $meta_query, $delete_options ) {
280			$query_vars = array(
281			'key' => $delete_options['meta_key'],
282			'compare' => $delete_options['meta_op'],
283			'type' => $delete_options['meta_type'],
284			);
285			if ( in_array( $delete_options['meta_op'], array( 'EXISTS', 'NOT EXISTS' ), true ) ) {
286			$meta_query = array( $query_vars );
287			return $meta_query;
288			}
289			if ( 'DATE' === $delete_options['meta_type'] ) {
290			$bd_date_handler = new \Bulk_Delete_Date_Handler();
291			$meta_query = $bd_date_handler->get_query( $delete_options );
292			return $meta_query;
293			}
294			switch ( $delete_options['meta_op'] ) {
295			case 'IN':
296			$meta_value = explode( ',', $delete_options['meta_value'] );
297			break;
298			case 'BETWEEN':
299			$meta_value = explode( ',', $delete_options['meta_value'] );
300			break;
301			default:
302			$meta_value = $delete_options['meta_value'];
303			}
304
305			$query_vars['value'] = $meta_value;
306			$meta_query = array( $query_vars );
307			return $meta_query;
308			}
309
310			/**
311			* Hook handler.
312			*
313			* This function was originally part of the Bulk Delete Comment Meta add-on.
314			*
315			* @since 0.1 of Bulk Delete Comment Meta add-on
316			*
317			* @param array $delete_options Delete options array.
318			*/
319			public function do_delete_comment_meta( $delete_options ) {
320			do_action( 'bd_before_scheduler', $this->messages['cron_label'] );
321			$count = $this->delete( $delete_options );
322			do_action( 'bd_after_scheduler', $this->messages['cron_label'], $count );
323			}
324			}
325

sudar / bulk-delete

Push — 516-fix/enhance-data-type-and-... ( 46e87d...caa875 )

DeleteCommentMetaModule::change_meta_query() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like