Alert: This function’s access is marked private. This means it is not intended for use by plugin or theme developers, only in other core functions. It is listed here for completeness.
Logs_List_Table::get_recipe_query()
Prepare query for recipe
Return Return
(string) query
Source Source
File: src/core/admin/class-logs-list-table.php
private function get_recipe_query() { global $wpdb; $view_exists = Automator_DB::is_view_exists(); if ( ! $view_exists ) { $search_conditions = ' 1=1 AND r.completed != -1 '; } else { $search_conditions = ' 1=1 AND completed != -1 '; } if ( automator_filter_has_var( 'search_key' ) && '' !== automator_filter_input( 'search_key' ) ) { $search_key = sanitize_text_field( automator_filter_input( 'search_key' ) ); if ( ! $view_exists ) { $search_conditions .= " AND ( (p.recipe_title LIKE '%$search_key%') OR (u.display_name LIKE '%$search_key%' ) OR (u.user_email LIKE '%$search_key%' ) ) "; } else { $search_conditions .= " AND ( (recipe_title LIKE '%$search_key%') OR (display_name LIKE '%$search_key%' ) OR (user_email LIKE '%$search_key%' ) ) "; } } if ( automator_filter_has_var( 'recipe_id' ) && '' !== automator_filter_input( 'recipe_id' ) ) { if ( ! $view_exists ) { $search_conditions .= " AND r.automator_recipe_id = '" . absint( automator_filter_input( 'recipe_id' ) ) . "' "; } else { $search_conditions .= " AND automator_recipe_id = '" . absint( automator_filter_input( 'recipe_id' ) ) . "' "; } } if ( $view_exists ) { return "SELECT * FROM {$wpdb->prefix}uap_recipe_logs_view WHERE $search_conditions"; } else { $sql = Automator_DB::recipe_log_view_query(); return "$sql WHERE $search_conditions"; } }
Expand full source code Collapse full source code View on Github