$where_clauses .= " AND name IN ($escaped_where_names)";

[500] Fix | Delete

}

[501] Fix | Delete

[502] Fix | Delete

if ( ! empty( $escaped_where_excluded_names ) ) {

[503] Fix | Delete

$where_clauses .= " AND name NOT IN ($escaped_where_excluded_names)";

[504] Fix | Delete

}

[505] Fix | Delete

[506] Fix | Delete

if ( ! empty( $escaped_where_source ) ) {

[507] Fix | Delete

$where_clauses .= " AND source IN ($escaped_where_source)";

[508] Fix | Delete

}

[509] Fix | Delete

[510] Fix | Delete

if ( isset( $args['is_read'] ) ) {

[511] Fix | Delete

$where_clauses .= $args['is_read'] ? ' AND is_read = 1' : ' AND is_read = 0';

[512] Fix | Delete

}

[513] Fix | Delete

[514] Fix | Delete

$where_clauses .= $escaped_is_deleted ? ' AND is_deleted = 1' : ' AND is_deleted = 0';

[515] Fix | Delete

[516] Fix | Delete

return $where_clauses;

[517] Fix | Delete

}

[518] Fix | Delete

[519] Fix | Delete

/**

[520] Fix | Delete

* Find all the notes with a given name.

[521] Fix | Delete

*

[522] Fix | Delete

* @param string $name Name to search for.

[523] Fix | Delete

* @return array An array of matching note ids.

[524] Fix | Delete

*/

[525] Fix | Delete

public function get_notes_with_name( $name ) {

[526] Fix | Delete

global $wpdb;

[527] Fix | Delete

return $wpdb->get_col(

[528] Fix | Delete

$wpdb->prepare(

[529] Fix | Delete

"SELECT note_id FROM {$wpdb->prefix}wc_admin_notes WHERE name = %s ORDER BY note_id ASC",

[530] Fix | Delete

$name

[531] Fix | Delete

)

[532] Fix | Delete

);

[533] Fix | Delete

}

[534] Fix | Delete

[535] Fix | Delete

/**

[536] Fix | Delete

* Find the ids of all notes with a given type.

[537] Fix | Delete

*

[538] Fix | Delete

* @param string $note_type Type to search for.

[539] Fix | Delete

* @return array An array of matching note ids.

[540] Fix | Delete

*/

[541] Fix | Delete

public function get_note_ids_by_type( $note_type ) {

[542] Fix | Delete

global $wpdb;

[543] Fix | Delete

return $wpdb->get_col(

[544] Fix | Delete

$wpdb->prepare(

[545] Fix | Delete

"SELECT note_id FROM {$wpdb->prefix}wc_admin_notes WHERE type = %s ORDER BY note_id ASC",

[546] Fix | Delete

$note_type

[547] Fix | Delete

)

[548] Fix | Delete

);

[549] Fix | Delete

}

[550] Fix | Delete

}

[551] Fix | Delete

[552] Fix | Delete