get_results(
"SELECT DISTINCT tm.term_id
FROM $wpdb->term_taxonomy AS tt
INNER JOIN $wpdb->terms AS t ON tt.term_id = t.term_id
INNER JOIN $wpdb->termmeta AS tm ON t.term_id = tm.term_id
WHERE tt.taxonomy = 'product_cat'
AND tm.meta_key = 'visibility'
AND tm.meta_value IN ( 'hidden' )
UNION DISTINCT
SELECT DISTINCT term_id
FROM $wpdb->term_taxonomy
WHERE parent IN (
SELECT DISTINCT tm.term_id
FROM $wpdb->term_taxonomy AS tt
INNER JOIN $wpdb->terms AS t ON tt.term_id = t.term_id
INNER JOIN $wpdb->termmeta AS tm ON t.term_id = tm.term_id
WHERE tt.taxonomy = 'product_cat'
AND tm.meta_key = 'visibility'
AND tm.meta_value IN ( 'hidden' )
)",
ARRAY_A
);
if ( is_wp_error( $results ) || empty( $results ) ) {
return apply_filters( 'orderable_hidden_categories', $hidden_categories );
}
$hidden_categories = array_map( 'absint', wp_list_pluck( $results, 'term_id' ) );
return apply_filters( 'orderable_hidden_categories', $hidden_categories );
}
/**
* Add logo to settings page.
*/
public static function settings_logo( $title = '' ) {
return sprintf( '', esc_url( ORDERABLE_ASSETS_URL . 'img/orderable-logo.svg' ) );
}
/**
* Add version number to settings page.
*/
public static function version_number() {
printf( 'v%s', ORDERABLE_VERSION );
}
}