PluginProbe
Formidable Forms – WordPress Form Builder for Contact Forms, Calculators, Quizzes & More / 5.0.08
Formidable Forms – WordPress Form Builder for Contact Forms, Calculators, Quizzes & More v5.0.08
6.35 6.34 6.33.1 6.33 6.32.1 6.32 6.31 6.25 6.25.1 6.26 6.26.1 6.27 6.28 6.29 6.3 6.3.1 6.3.2 6.30 6.4 6.4.1 6.4.2 6.5 6.5.1 6.5.2 6.5.3 All 141 releases
← All changes | classes/helpers/FrmEntriesListHelper.php +87 -305 6.335.0.08 View file →
@@ -3,107 +3,51 @@
3 3 die( 'You are not allowed to call this page directly.' );
4 4 }
5 5
6 6 class FrmEntriesListHelper extends FrmListHelper {
7 -
8 - /**
9 - * @var string|null
10 - */
11 7 protected $column_name;
8 + protected $item;
9 + protected $field;
12 10
13 11 /**
14 12 * @since 4.07
15 - *
16 - * @var bool|int
17 13 */
18 14 public $total_items = 0;
19 15
20 - /**
21 - * @param array $args
22 - */
23 - public function __construct( $args ) {
24 - parent::__construct( $args );
25 - $this->screen->set_screen_reader_content(
26 - array(
27 - 'heading_list' => esc_html__( 'Entries list', 'formidable' ),
28 - )
29 - );
30 - }
31 -
32 - /**
33 - * @return void
34 - */
35 16 public function prepare_items() {
36 - $this->set_per_page();
37 - $s_query = array();
38 - $join_form_in_query = false;
17 + global $per_page;
39 18
40 - $this->items = $this->get_entry_items( $s_query, $join_form_in_query );
41 - $this->set_total_items( $s_query );
42 - $this->prepare_pagination();
43 - }
19 + $per_page = $this->get_items_per_page( 'formidable_page_formidable_entries_per_page' );
20 + $form_id = $this->params['form'];
44 21
45 - /**
46 - * @param array $s_query
47 - *
48 - * @return void
49 - */
50 - protected function set_total_items( $s_query ) {
51 - $this->total_items = FrmEntry::getRecordCount( $s_query );
52 - }
22 + $s_query = array();
53 23
54 - /**
55 - * Prepares pagination.
56 - *
57 - * @since 6.5.4
58 - *
59 - * @return void
60 - */
61 - protected function prepare_pagination() {
62 - global $per_page;
24 + if ( $form_id ) {
25 + $s_query['it.form_id'] = $form_id;
26 + $join_form_in_query = false;
27 + } else {
28 + $s_query[] = array(
29 + 'or' => 1,
30 + 'parent_form_id' => null,
31 + 'parent_form_id <' => 1,
32 + );
33 + $join_form_in_query = true;
34 + }
63 35
64 - $this->set_pagination_args(
36 + $s = self::get_param(
65 37 array(
66 - 'total_items' => $this->total_items,
67 - 'per_page' => $per_page,
38 + 'param' => 's',
39 + 'sanitize' => 'sanitize_text_field',
68 40 )
69 41 );
70 - }
71 42
72 - /**
73 - * Sets the global $per_page variable
74 - *
75 - * @since 6.5.4
76 - *
77 - * @return void
78 - */
79 - protected function set_per_page() {
80 - global $per_page;
81 - $per_page = $this->get_items_per_page( 'formidable_page_formidable_entries_per_page' );
82 - }
43 + if ( $s != '' && FrmAppHelper::pro_is_installed() ) {
44 + $fid = self::get_param( array( 'param' => 'fid' ) );
45 + $s_query = FrmProEntriesHelper::get_search_str( $s_query, $s, $form_id, $fid );
46 + }
83 47
84 - /**
85 - * @since 6.5.4
86 - *
87 - * @param array $s_query
88 - * @param bool $join_form_in_query
89 - *
90 - * @return array
91 - */
92 - protected function get_entry_items( &$s_query, &$join_form_in_query ) {
93 - global $per_page;
94 - $s_query = $this->get_search_query( $join_form_in_query );
95 - $limit = $this->get_limit( $per_page );
48 + $s_query = apply_filters( 'frm_entries_list_query', $s_query, compact( 'form_id' ) );
96 49
97 - return FrmEntry::getAll( $s_query, $this->get_order_by(), $limit, true, $join_form_in_query );
98 - }
99 -
100 - /**
101 - * @since 6.5.4
102 - *
103 - * @return string
104 - */
105 - protected function get_order_by() {
106 50 $orderby = self::get_param(
107 51 array(
108 52 'param' => 'orderby',
109 53 'default' => 'id',
@@ -108,36 +52,22 @@
108 52 'param' => 'orderby',
109 53 'default' => 'id',
110 54 )
111 55 );
112 - $order = self::get_param(
56 +
57 + if ( strpos( $orderby, 'meta' ) !== false ) {
58 + $order_field_type = FrmField::get_type( str_replace( 'meta_', '', $orderby ) );
59 + $orderby .= in_array( $order_field_type, array( 'number', 'scale', 'star' ) ) ? '+0' : '';
60 + }
61 +
62 + $order = self::get_param(
113 63 array(
114 64 'param' => 'order',
115 65 'default' => 'DESC',
116 66 )
117 67 );
68 + $order = FrmDb::esc_order( $orderby . ' ' . $order );
118 69
119 - FrmAppController::apply_saved_sort_preference( $orderby, $order );
120 -
121 - if ( str_contains( $orderby, 'meta' ) ) {
122 - $order_field_type = FrmField::get_type( str_replace( 'meta_', '', $orderby ) );
123 -
124 - if ( in_array( $order_field_type, array( 'number', 'scale', 'star' ), true ) ) {
125 - $orderby .= '+0';
126 - }
127 - }
128 -
129 - return FrmDb::esc_order( $orderby . ' ' . $order );
130 - }
131 -
132 - /**
133 - * @since 6.5.4
134 - *
135 - * @param int $per_page
136 - *
137 - * @return string
138 - */
139 - protected function get_limit( $per_page ) {
140 70 $page = $this->get_pagenum();
141 71 $start = (int) self::get_param(
142 72 array(
143 73 'param' => 'start',
@@ -144,63 +74,21 @@
144 74 'default' => ( $page - 1 ) * $per_page,
145 75 )
146 76 );
147 77
148 - return FrmDb::esc_limit( $start . ',' . $per_page );
149 - }
78 + $limit = FrmDb::esc_limit( $start . ',' . $per_page );
79 + $this->items = FrmEntry::getAll( $s_query, $order, $limit, true, $join_form_in_query );
80 + $total_items = FrmEntry::getRecordCount( $s_query );
81 + $this->total_items = $total_items;
150 82
151 - /**
152 - * @since 6.5.4
153 - *
154 - * @param bool $join_form_in_query
155 - *
156 - * @return array
157 - */
158 - protected function get_search_query( &$join_form_in_query ) {
159 - $form_id = $this->params['form'];
160 - $s_query = array();
161 -
162 - if ( $form_id ) {
163 - $form_ids = $this->get_form_ids( $form_id );
164 - $s_query['it.form_id'] = count( $form_ids ) > 1 ? $form_ids : $form_ids[0];
165 - } else {
166 - $s_query[] = array(
167 - 'or' => 1,
168 - 'parent_form_id' => null,
169 - 'parent_form_id <' => 1,
170 - );
171 - $join_form_in_query = true;
172 - }
173 -
174 - $s = self::get_param(
83 + $this->set_pagination_args(
175 84 array(
176 - 'param' => 's',
177 - 'sanitize' => 'sanitize_text_field',
85 + 'total_items' => $total_items,
86 + 'per_page' => $per_page,
178 87 )
179 88 );
180 -
181 - if ( $s !== '' && FrmAppHelper::pro_is_installed() ) {
182 - $fid = self::get_param( array( 'param' => 'fid' ) );
183 - $s_query = FrmProEntriesHelper::get_search_str( $s_query, $s, $form_id, $fid );
184 - }
185 -
186 - return apply_filters( 'frm_entries_list_query', $s_query, compact( 'form_id' ) );
187 89 }
188 90
189 - /**
190 - * @since 6.5.4
191 - *
192 - * @param int|string $form_id
193 - *
194 - * @return array<int>
195 - */
196 - protected function get_form_ids( $form_id ) {
197 - return array( (int) $form_id );
198 - }
199 -
200 - /**
201 - * @return void
202 - */
203 91 public function no_items() {
204 92 $s = self::get_param(
205 93 array(
206 94 'param' => 's',
@@ -206,11 +94,11 @@
206 94 'param' => 's',
207 95 'sanitize' => 'sanitize_text_field',
208 96 )
209 97 );
98 + if ( ! empty( $s ) ) {
99 + esc_html_e( 'No Entries Found', 'formidable' );
210 100
211 - if ( $s ) {
212 - esc_html_e( 'No Entries Found', 'formidable' );
213 101 return;
214 102 }
215 103
216 104 $form_id = $this->params['form'];
@@ -218,9 +106,8 @@
218 106
219 107 if ( $form_id ) {
220 108 $form = FrmForm::getOne( $form_id );
221 109 }
222 -
223 110 $has_form = ! empty( $form );
224 111
225 112 if ( ! $has_form ) {
226 113 $has_form = FrmForm::getAll( array(), '', 1 );
@@ -228,70 +115,42 @@
228 115 }
229 116
230 117 $colspan = $this->get_column_count();
231 118
232 - include FrmAppHelper::plugin_path() . '/classes/views/frm-entries/no_entries.php';
119 + include( FrmAppHelper::plugin_path() . '/classes/views/frm-entries/no_entries.php' );
233 120 }
234 121
235 - /**
236 - * @param string $text Text.
237 - * @param string $input_id Input ID.
238 - *
239 - * @return void
240 - */
241 122 public function search_box( $text, $input_id ) {
242 123 // Searching is a pro feature
243 124 }
244 125
245 - /**
246 - * @param string $which
247 - *
248 - * @return void
249 - */
250 126 protected function display_tablenav( $which ) {
251 - $is_footer = $which !== 'top';
252 -
127 + $is_footer = ( $which !== 'top' );
253 128 if ( $is_footer && ! empty( $this->items ) ) {
254 - $utm = array(
255 - 'campaign' => 'spam-protection',
256 - 'content' => 'entries-list-spam-protection',
257 - );
258 - // phpcs:disable Generic.WhiteSpace.ScopeIndent
259 129 ?>
260 130 <p>
261 131 <?php esc_html_e( 'Getting spam form submissions?', 'formidable' ); ?>
262 - <a href="<?php echo esc_url( FrmAppHelper::admin_upgrade_link( $utm, 'knowledgebase/add-spam-protection/' ) ); ?>" target="_blank">
132 + <a href="https://formidableforms.com/knowledgebase/add-spam-protection/" target="_blank">
263 133 <?php esc_html_e( 'Learn how to prevent them.', 'formidable' ); ?>
264 134 </a>
265 135 </p>
266 136 <?php
267 - // phpcs:enable Generic.WhiteSpace.ScopeIndent
268 137 }
269 138 parent::display_tablenav( $which );
270 139 }
271 140
272 - /**
273 - * @param string $which
274 - *
275 - * @return void
276 - */
277 141 protected function extra_tablenav( $which ) {
278 142 $form_id = FrmAppHelper::simple_get( 'form', 'absint' );
143 + if ( $which == 'top' && empty( $form_id ) ) {
144 + echo '<div class="alignleft actions">';
279 145
280 - if ( $which !== 'top' || $form_id ) {
281 - return;
146 + // Override the referrer to prevent it from being used for the screen options.
147 + echo '<input type="hidden" name="_wp_http_referer" value="" />';
148 +
149 + echo FrmFormsHelper::forms_dropdown( 'form', $form_id, array( 'blank' => __( 'View all forms', 'formidable' ) ) ); // WPCS: XSS ok.
150 + submit_button( __( 'Filter', 'formidable' ), 'filter_action action', '', false, array( 'id' => 'post-query-submit' ) );
151 + echo '</div>';
282 152 }
283 -
284 - echo '<div class="alignleft actions">';
285 -
286 - // Override the referrer to prevent it from being used for the screen options.
287 - echo '<input type="hidden" name="_wp_http_referer" value="" />';
288 -
289 - echo '<label for="form" class="screen-reader-text">' . esc_html__( 'Filter by form', 'formidable' ) . '</label>';
290 -
291 - FrmFormsHelper::forms_dropdown( 'form', $form_id, array( 'blank' => __( 'View all forms', 'formidable' ) ) );
292 - submit_button( __( 'Filter', 'formidable' ), 'filter_action action', '', false, array( 'id' => 'post-query-submit' ) );
293 - echo '</div>';
294 153 }
295 154
296 155 /**
297 156 * Gets the name of the primary column in the Entries screen
@@ -297,17 +156,18 @@
297 156 * Gets the name of the primary column in the Entries screen
298 157 *
299 158 * @since 2.0.14
300 159 *
301 - * @return string Primary column.
160 + * @return string $primary_column
302 161 */
303 162 protected function get_primary_column_name() {
304 - $columns = get_column_headers( $this->screen );
305 - $hidden = get_hidden_columns( $this->screen );
163 + $columns = get_column_headers( $this->screen );
164 + $hidden = get_hidden_columns( $this->screen );
165 +
306 166 $primary_column = '';
307 167
308 168 foreach ( $columns as $column_key => $column_display_name ) {
309 - if ( 'cb' !== $column_key && ! in_array( $column_key, $hidden, true ) ) {
169 + if ( 'cb' != $column_key && ! in_array( $column_key, $hidden ) ) {
310 170 $primary_column = $column_key;
311 171 break;
312 172 }
313 173 }
@@ -314,29 +174,8 @@
314 174
315 175 return $primary_column;
316 176 }
317 177
318 - /**
319 - * @since 6.12
320 - *
321 - * @param object $item
322 - *
323 - * @return string
324 - */
325 - private static function get_entry_label( $item ) {
326 - if ( $item->name ) {
327 - return $item->name;
328 - }
329 - /* translators: %d: Entry id */
330 - return sprintf( __( 'Entry %d', 'formidable' ), $item->id );
331 - }
332 -
333 - /**
334 - * @param stdClass $item
335 - * @param string $style
336 - *
337 - * @return string
338 - */
339 178 public function single_row( $item, $style = '' ) {
340 179 // Set up the hover actions for this user
341 180 $actions = array();
342 181 $view_link = '?page=formidable-entries&frm_action=show&id=' . $item->id;
@@ -346,10 +185,8 @@
346 185 $action_links = $this->row_actions( $actions );
347 186
348 187 // Set up the checkbox ( because the user is editable, otherwise its empty )
349 188 $checkbox = "<input type='checkbox' name='item-action[]' id='cb-item-action-{$item->id}' value='{$item->id}' />";
350 - /* translators: %s: Form name */
351 - $checkbox .= "<label for='cb-item-action-{$item->id}'><span class='screen-reader-text'>" . esc_html( sprintf( __( 'Select %s', 'formidable' ), self::get_entry_label( $item ) ) ) . '</span></label>'; // phpcs:ignore SlevomatCodingStandard.Files.LineLength.LineTooLong
352 189
353 190 $r = "<tr id='item-action-{$item->id}'$style>";
354 191
355 192 list( $columns, $hidden, , $primary ) = $this->get_column_info();
@@ -363,9 +200,9 @@
363 200 $class .= ' column-primary';
364 201 }
365 202
366 203 if ( in_array( $column_name, $hidden, true ) ) {
367 - $class .= ' hidden';
204 + $class .= ' frm_hidden';
368 205 } elseif ( ! $action_col && ! in_array( $column_name, $action_columns, true ) ) {
369 206 $action_col = $column_name;
370 207 }
371 208
@@ -370,50 +207,48 @@
370 207 }
371 208
372 209 $attributes = 'class="' . esc_attr( $class ) . '"';
373 210 unset( $class );
374 - $attributes .= ' data-colname="' . $column_display_name . '"';
211 + $attributes .= ' data-colname="' . $column_display_name . '"';
212 +
375 213 $form_id = $this->params['form'] ? $this->params['form'] : 0;
376 214 $this->column_name = preg_replace( '/^(' . $form_id . '_)/', '', $column_name );
377 215
378 - if ( $this->column_name === 'cb' ) {
216 + if ( $this->column_name == 'cb' ) {
379 217 $r .= "<th scope='row' class='check-column'>$checkbox</th>";
380 218 } else {
381 - $val = in_array( $column_name, $hidden, true ) ? '' : $this->column_value( $item );
382 - $r .= "<td $attributes>";
219 + if ( in_array( $column_name, $hidden, true ) ) {
220 + $val = '';
221 + } else {
222 + $val = $this->column_value( $item );
223 + }
383 224
384 - // phpcs:ignore Universal.Operators.StrictComparisons
225 + $r .= "<td $attributes>";
385 226 if ( $column_name == $action_col ) {
386 - $edit_link = admin_url( 'admin.php?page=formidable-entries&frm_action=edit&id=' . $item->id );
387 - $r .= '<a href="' . esc_url( isset( $actions['edit'] ) ? $edit_link : $view_link ) . '" class="row-title" >' . $val . '</a> ';
388 - $r .= $action_links;
227 + $edit_link = FrmAppHelper::maybe_full_screen_link( '?page=formidable-entries&frm_action=edit&id=' . $item->id );
228 + $r .= '<a href="' . esc_url( isset( $actions['edit'] ) ? $edit_link : $view_link ) . '" class="row-title" >' . $val . '</a> ';
229 + $r .= $action_links;
389 230 } else {
390 231 $r .= $val;
391 232 }
392 -
393 233 $r .= '</td>';
394 - }//end if
234 + }
395 235 unset( $val );
396 - }//end foreach
397 - return $r . '</tr>';
236 + }
237 + $r .= '</tr>';
238 +
239 + return $r;
398 240 }
399 241
400 242 /**
401 243 * Get the column names that the logged in user can action on
402 - *
403 - * @return string[]
404 244 */
405 245 private function get_action_columns() {
406 246 return array( 'cb', 'form_id', 'id', 'post_id' );
407 247 }
408 248
409 - /**
410 - * @param object $item
411 - *
412 - * @return mixed
413 - */
414 249 private function column_value( $item ) {
415 - $col_name = $this->maybe_fix_column_name( $this->column_name );
250 + $col_name = $this->column_name;
416 251
417 252 switch ( $col_name ) {
418 253 case 'ip':
419 254 case 'id':
@@ -420,8 +255,9 @@
420 255 case 'item_key':
421 256 $val = $item->{$col_name};
422 257 break;
423 258 case 'name':
259 + case 'description':
424 260 $val = FrmAppHelper::truncate( strip_tags( $item->{$col_name} ), 100 );
425 261 break;
426 262 case 'created_at':
427 263 case 'updated_at':
@@ -428,19 +264,13 @@
428 264 $date = FrmAppHelper::get_formatted_time( $item->{$col_name} );
429 265 $val = '<abbr title="' . esc_attr( FrmAppHelper::get_formatted_time( $item->{$col_name}, '', 'g:i:s A' ) ) . '">' . $date . '</abbr>';
430 266 break;
431 267 case 'is_draft':
432 - $entry_status = FrmEntriesHelper::get_entry_status_label( $item->is_draft );
433 - $val = sprintf(
434 - '<span class="frm-meta-tag frm-entry-status frm-entry-status-%s">%s</span>',
435 - sanitize_html_class( $item->is_draft ),
436 - esc_html( $entry_status )
437 - );
268 + $val = empty( $item->is_draft ) ? esc_html__( 'No', 'formidable' ) : esc_html__( 'Yes', 'formidable' );
438 269 break;
439 270 case 'form_id':
440 271 $form_id = $item->form_id;
441 272 $user_can_edit_forms = false === FrmAppHelper::permission_nonce_error( 'frm_edit_forms' );
442 -
443 273 if ( $user_can_edit_forms ) {
444 274 $val = FrmFormsHelper::edit_form_link( $form_id );
445 275 } else {
446 276 $val = FrmFormsHelper::edit_form_link_label( $form_id );
@@ -457,71 +287,36 @@
457 287 $val = $item->parent_item_id;
458 288 break;
459 289 default:
460 290 $val = apply_filters( 'frm_entries_' . $col_name . '_column', false, compact( 'item' ) );
461 -
462 291 if ( $val === false ) {
463 292 $this->get_column_value( $item, $val );
464 293 }
294 + }
465 295
466 - /**
467 - * Allows changing entries list column value.
468 - *
469 - * @since 5.1
470 - *
471 - * @param mixed $val Column value.
472 - * @param array $args Contains `item` and `col_name`.
473 - */
474 - $val = apply_filters( 'frm_entries_column_value', $val, compact( 'item', 'col_name' ) );
475 - }//end switch
476 -
477 296 return $val;
478 297 }
479 298
480 299 /**
481 - * When a form has entries with the 0 item meta value, the values do not appear properly in the entries list.
482 - *
483 - * @since 6.11.2
484 - *
485 - * @param string $column_name
486 - *
487 - * @return string
488 - */
489 - private function maybe_fix_column_name( $column_name ) {
490 - if ( str_starts_with( $column_name, '0_' ) ) {
491 - return substr( $column_name, 2 );
492 - }
493 - return $column_name;
494 - }
495 -
496 - /**
497 - * @param array $actions
498 - * @param object $item
499 300 * @param string $view_link
500 - *
501 - * @return void
502 301 */
503 302 private function get_actions( &$actions, $item, $view_link ) {
504 - $actions['view'] = '<a href="' . esc_url( $view_link ) . '">' . esc_html__( 'View', 'formidable' ) . '</a>';
303 + $view_link = FrmAppHelper::maybe_full_screen_link( $view_link );
304 + $actions['view'] = '<a href="' . esc_url( $view_link ) . '">' . __( 'View', 'formidable' ) . '</a>';
505 305
506 306 if ( current_user_can( 'frm_delete_entries' ) ) {
507 307 $delete_link = '?page=formidable-entries&frm_action=destroy&id=' . $item->id . '&form=' . $this->params['form'];
508 - $actions['delete'] = '<a href="' . esc_url( wp_nonce_url( $delete_link ) ) . '" class="submitdelete" data-frmverify="' . esc_attr__( 'Permanently delete this entry?', 'formidable' ) . '" data-frmverify-btn="frm-button-red">' . esc_html__( 'Delete', 'formidable' ) . '</a>'; // phpcs:ignore SlevomatCodingStandard.Files.LineLength.LineTooLong
308 + $delete_link = FrmAppHelper::maybe_full_screen_link( $delete_link );
309 + $actions['delete'] = '<a href="' . esc_url( wp_nonce_url( $delete_link ) ) . '" class="submitdelete" data-frmverify="' . esc_attr__( 'Permanently delete this entry?', 'formidable' ) . '">' . __( 'Delete', 'formidable' ) . '</a>';
509 310 }
510 311
511 312 $actions = apply_filters( 'frm_row_actions', $actions, $item );
512 313 }
513 314
514 - /**
515 - * @param object $item
516 - * @param mixed $val
517 - *
518 - * @return void
519 - */
520 315 private function get_column_value( $item, &$val ) {
521 316 $col_name = $this->column_name;
522 317
523 - if ( str_starts_with( $col_name, 'frmsep_' ) ) {
318 + if ( strpos( $col_name, 'frmsep_' ) === 0 ) {
524 319 $sep_val = true;
525 320 $col_name = str_replace( 'frmsep_', '', $col_name );
526 321 } else {
527 322 $sep_val = false;
@@ -526,14 +321,13 @@
526 321 } else {
527 322 $sep_val = false;
528 323 }
529 324
530 - if ( str_contains( $col_name, '-_-' ) ) {
325 + if ( strpos( $col_name, '-_-' ) ) {
531 326 list( $col_name, $embedded_field_id ) = explode( '-_-', $col_name );
532 327 }
533 328
534 329 $field = FrmField::getOne( $col_name );
535 -
536 330 if ( ! $field ) {
537 331 return;
538 332 }
539 333
@@ -560,19 +354,7 @@
560 354 /**
561 355 * @return string
562 356 */
563 357 protected function confirm_bulk_delete() {
564 - return sprintf(
565 - /* translators: %1$s: HTML break line, %2$s: HTML bold text */
566 - esc_html__( 'ALL entries in this form will be permanently deleted.%1$sWant to proceed? Type %2$s below.', 'formidable' ),
567 - '<br/>',
568 - '<b>DELETE ALL</b>'
569 - );
570 - }
571 -
572 - /**
573 - * @return string
574 - */
575 - protected function loaded_from() {
576 - return 'entries-list';
358 + return __( 'ALL selected entries in this form will be permanently deleted. Want to proceed?', 'formidable' );
577 359 }
578 360 }