get_id(); $status = $order->get_status(); $date_obj = $order->get_date_created(); $date_raw = $date_obj ? $date_obj->date( 'Y-m-d H:i' ) : ''; $date_ts = $date_obj ? $date_obj->getTimestamp() : 0; $date_disp = $date_obj ? $date_obj->date( 'd/m/Y H:i' ) : '—'; $total_raw = (float) $order->get_total(); $total_fmt = wc_price( $total_raw ); $status_label = wc_get_order_status_name( $status ); $badge_cls = $badge_map[ $status ] ?? 'badge-gray';$client = trim( $order->get_billing_first_name() . ' ' . $order->get_billing_last_name() ); $email = $order->get_billing_email(); $phone = $order->get_billing_phone(); $message = $order->get_customer_note(); $company = $order->get_billing_company();/* Champs spéciaux devis YWRAQ */ if ( $status === 'ywraq-new' ) { $tbl = $wpdb->prefix . 'wc_orders_meta'; $mn = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $tbl WHERE order_id=%d AND meta_key='ywraq_customer_name'", $oid ) ); $me = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $tbl WHERE order_id=%d AND meta_key='ywraq_customer_email'", $oid ) ); if ( $mn ) $client = $mn; if ( $me ) $email = $me;$ser = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $tbl WHERE order_id=%d AND meta_key='ywraq_other_email_fields'", $oid ) ); $des = maybe_unserialize( $ser ); if ( is_array( $des ) ) { $phone = $des['Téléphone'] ?? $phone; $message = $des['Message'] ?? $message; } $dm = $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $tbl WHERE order_id=%d AND meta_key='ywraq_customer_message'", $oid ) ); if ( ! empty( $dm ) ) $message = $dm; }/* Avatar initiales */ $parts = explode( ' ', trim( $client ) ); $initials = strtoupper( mb_substr( $parts[0] ?? '?', 0, 1 ) . mb_substr( $parts[1] ?? '', 0, 1 ) );/* Adresses */ $addr_f = implode( ', ', array_filter( [ $order->get_billing_address_1(), $order->get_billing_city(), $order->get_billing_postcode(), $order->get_billing_country(), ] ) ); $addr_l = implode( ', ', array_filter( [ $order->get_shipping_address_1(), $order->get_shipping_city(), $order->get_shipping_postcode(), $order->get_shipping_country(), ] ) );/* Produits (HTML table) */ $prod_rows = ''; foreach ( $order->get_items() as $item ) { $prod_rows .= sprintf( '', esc_html( $item->get_name() ), $item->get_quantity(), wp_strip_all_tags( wc_price( $item->get_total() ) ) ); }/* HTML détail (expand) */ $det = '

	N° Cmd	Date	Client	Email	Téléphone	Statut	Total	Actions
%s	%d	%s

' . $prod_rows . '

Produit	Qté	Total