Meta Box

Hi,

I finally use this snippet to display a metabox in my cpt with a link to the related user. The link display the billing company field, but you can use any other user field.

// MODIFIER AFFICHAGE CHAMP relationnel clients-wp-bdd METABOX.IO cote BDD clients
add_action( 'add_meta_boxes', 'add_link_to_wp_user_meta_box' );

function add_link_to_wp_user_meta_box() {
    add_meta_box(
        'link_to_wp_user_meta_box',     // ID unique
        'Lien vers le compte utilisateur WP', // Titre de la metabox
        'display_link_to_wp_user_meta_box',  // Fonction callback pour afficher le contenu
        'client',  // Le CPT auquel cette metabox est liée
        'side',    // Position de la metabox
        'high'     // Priorité de l'affichage
    );
}

function display_link_to_wp_user_meta_box( $post ) {
    global $wpdb;

    // Récupérer l'ID de l'utilisateur associé au CPT via la relation 'clients-wp-bdd'
    $client_id = $post->ID;
    $user_id = $wpdb->get_var( $wpdb->prepare(
        "SELECT <code>from</code> FROM {$wpdb->prefix}mb_relationships WHERE <code>to</code> = %d AND <code>type</code> = 'clients-wp-bdd'",
        $client_id
    ));

    if ( !empty( $user_id ) ) {
        // Récupérer les informations de l'utilisateur WP
        $user = get_userdata( $user_id );
        $billing_company = get_user_meta( $user_id, 'billing_company', true );
        $edit_link = get_edit_user_link( $user_id );

        // Afficher un lien cliquable vers la page d'édition de l'utilisateur WP
        if ( !empty( $billing_company ) ) {
            echo '<p>Société : <a href="' . esc_url( $edit_link ) . '">' . esc_html( $billing_company ) . '</a></p>';
        } else {
            echo '<p>Aucun champ "billing_company" trouvé pour cet utilisateur.</p>';
        }
    } else {
        echo '<p>Aucun utilisateur lié trouvé.</p>';
    }
}

Thank you for the quick answer. Hope they will find something.
If you give some clues maybe I could on my side.
Best regards

Hello,
Ok I understand what you mean. The default value is displayed when I clone the field.
In my case this is a group of datetime fields. I don't clone the datetime field but all the group.
I checked the "clone default value" at the group level and now it works. Many thanks!

Is it possible to limit the available time slots (disable useless hours)?

Hello. It works, thank you! I had to enable this option for all the 60 fields but now I can see and edit them all.
Best regards

Hello,
It works. Any idea why it wasn't a problem the 2 last years?

Thank you!

Hi,
sorry to bother you with this, but do you think there is a chance to solve this problem? I really need this feature...
Best regards

I have the same issue using relationships addon. I tried bidirectionnal relationship between CPT and shop_order but still can't see order in the metabox select field.

I installed posts 2 posts plugin (by scribu) with the same settings and it works. But I don't want to use another plugin. And I the relationship to work with admin column plugin, as metabox.io does.

Do you have an idea to make this work please?

It's ok, thank you again!
Last question... each time I send a file wordpress creates a new post with attached file. Is it possible to skip this?
And the the uploaded file is renamed with the extension. myfile.png becomes username_myflie.png.png