<?php
/**
 * Aiforya_Multi_Author_Tab_Authors — onglet « Auteurs ».
 *
 * Liste les utilisateurs disposant d'un rôle éditorial (rédacteur, éditeur,
 * publisher) avec leur charge d'articles par statut. Charte AIFORYA (thème
 * sombre, SVG Lucide stroke 1.5, zéro emoji, zéro classe inventée).
 *
 * @package aiforya-multi-author
 */

if ( ! defined( 'ABSPATH' ) ) {
    exit;
}

if ( class_exists( 'Aiforya_Multi_Author_Tab_Authors', false ) ) {
    return;
}

class Aiforya_Multi_Author_Tab_Authors extends Aiforya_Multi_Tab {

    public function slug(): string {
        return 'authors';
    }

    public function label(): string {
        return __( 'Authors', 'aiforya-multi-author' );
    }

    public function order(): int {
        return 30;
    }

    public function render( array $args = [] ): void {
        global $wpdb;

        $workflow    = Aiforya_Multi_Author_Workflow::get_instance();
        $role_labels = $workflow->get_editorial_roles();

        /*
         * ⛔ CET ONGLET DISAIT « 0 » PENDANT QUE LE WORKFLOW TOURNAIT — corrigé le 17/08/2026,
         * relevé par Greg à l'écran.
         *
         * Trois écrans de la MÊME extension définissaient « auteur » de trois façons :
         *   · cet onglet  : seulement les 3 rôles éditoriaux              -> 0
         *   · onglet Posts : + administrator, editor, author               -> proposait « aaa aaa »
         *   · Dashboard    : ceux qui ont au moins un article assigné      -> 1
         * Résultat pour l'utilisateur : il assigne un article, puis lit « No user has an
         * editorial role yet » sur l'écran censé lister son équipe. Ce n'est pas faux au sens
         * strict — c'est incohérent, et l'incohérence est le défaut.
         *
         * On liste désormais l'UNION : rôle éditorial OU participation réelle au workflow
         * (article assigné, ou co-signature). C'est aussi ce qui rend l'écran utile : il
         * montre la charge de ceux qui travaillent, pas l'état d'une case administrative.
         */
        // Charge par auteur : { user_id => { total, approved, published } }.
        $table = $wpdb->prefix . 'aiforya_ma_assignments';
        $rows  = $wpdb->get_results( $wpdb->prepare( 'SELECT user_id, status, COUNT(*) AS count FROM %i GROUP BY user_id, status', $table ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching

        $db            = Aiforya_Multi_Author_Db::get_instance();
        $participants  = array_map( static fn( $r ) => (int) $r->user_id, (array) $rows );
        $co_table      = $wpdb->prefix . 'aiforya_ma_coauthors';
        $co_rows       = $wpdb->get_results( $wpdb->prepare( 'SELECT DISTINCT user_id FROM %i', $co_table ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching
        $participants  = array_unique( array_merge(
            $participants,
            array_map( static fn( $r ) => (int) $r->user_id, (array) $co_rows )
        ) );
        unset( $db );

        $users = get_users( [
            'role__in' => array_keys( $role_labels ),
            'orderby'  => 'display_name',
            'order'    => 'ASC',
        ] );
        $deja = array_map( static fn( $u ) => (int) $u->ID, $users );
        foreach ( $participants as $uid ) {
            if ( $uid && ! in_array( $uid, $deja, true ) ) {
                $u = get_user_by( 'ID', $uid );
                if ( $u ) {
                    $users[] = $u;
                    $deja[]  = $uid;
                }
            }
        }
        usort( $users, static fn( $a, $b ) => strcasecmp( (string) $a->display_name, (string) $b->display_name ) );

        $charge = [];
        foreach ( (array) $rows as $row ) {
            $uid = (int) $row->user_id;
            if ( ! isset( $charge[ $uid ] ) ) {
                $charge[ $uid ] = [ 'total' => 0, 'approved' => 0, 'published' => 0 ];
            }
            $charge[ $uid ]['total'] += (int) $row->count;
            if ( 'approved' === $row->status ) {
                $charge[ $uid ]['approved'] += (int) $row->count;
            } elseif ( 'published' === $row->status ) {
                $charge[ $uid ]['published'] += (int) $row->count;
            }
        }

        // Helper D2 : pastille d'aide « ? » charte (AiforyaTooltip). $text déjà traduit.
        $tip = static function ( $text ) {
            printf( '<button type="button" class="aiforya-tip" data-aiforya-tooltip="%s">?</button>', esc_attr( $text ) );
        };

        ?>

        <div class="aiforya-tab-content aiforya-tab-authors">

            <div class="aiforya-header-section">
                <h2><?php esc_html_e( 'Authors', 'aiforya-multi-author' ); ?></h2>
                <p class="aiforya-description">
                    <?php esc_html_e( 'Everyone taking part in the workflow — users with an editorial role, plus anyone assigned a post or credited as a co-author — and their post load (total, approved, published).', 'aiforya-multi-author' ); ?>
                </p>
            </div>

            <div class="aiforya-card">
                <div class="aiforya-card-header">
                    <h3><?php esc_html_e( 'Editorial team', 'aiforya-multi-author' ); ?><?php $tip( __( 'Users allowed to take part in the editorial workflow, with how many posts they are handling. Roles are assigned from the WordPress Users screen.', 'aiforya-multi-author' ) );?></h3>
                    <span class="aiforya-badge aiforya-badge-secondary"><?php echo esc_html( (string) count( $users ) ); ?></span>
                </div>
                <div class="aiforya-card-body">
                    <?php if ( empty( $users ) ) : ?>
                        <div class="aiforya-empty-state">
                            <p style="color:#94a3b8;font-style:italic;margin:0;">
                                <?php esc_html_e( 'Nobody is taking part yet. Assign a post from the Posts tab, or give someone the Writer, Editor or Publisher role from the WordPress Users screen.', 'aiforya-multi-author' ); ?>
                            </p>
                        </div>
                    <?php else : ?>
                        <div class="aiforya-table-responsive">
                            <table class="aiforya-table aiforya-table-hover">
                                <thead>
                                    <tr>
                                        <th><?php esc_html_e( 'Author', 'aiforya-multi-author' ); ?></th>
                                        <th style="width:140px;"><?php esc_html_e( 'Role', 'aiforya-multi-author' ); ?><?php $tip( __( 'The person\'s function in the editorial team (writer, editor, publisher). It sets what they are allowed to do with posts.', 'aiforya-multi-author' ) );?></th>
                                        <th style="width:90px;text-align:right;"><?php esc_html_e( 'Total', 'aiforya-multi-author' ); ?></th>
                                        <th style="width:110px;text-align:right;"><?php esc_html_e( 'Approved', 'aiforya-multi-author' ); ?><?php $tip( __( 'This person\'s posts that passed review and are ready to be published.', 'aiforya-multi-author' ) );?></th>
                                        <th style="width:100px;text-align:right;"><?php esc_html_e( 'Published', 'aiforya-multi-author' ); ?><?php $tip( __( 'This person\'s posts that are already live on the site.', 'aiforya-multi-author' ) );?></th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <?php foreach ( $users as $user ) :
                                        $primary_role = '';
                                        foreach ( array_keys( $role_labels ) as $role_slug ) {
                                            if ( in_array( $role_slug, (array) $user->roles, true ) ) {
                                                $primary_role = $role_slug;
                                                break;
                                            }
                                        }
                                        /*
                                         * Sans rôle éditorial, cette cellule ne montrait qu'un tiret — une colonne
                                         * qui n'apprend rien. Depuis que l'onglet liste aussi les participants au
                                         * workflow, on affiche à défaut leur rôle WordPress (Administrator, Author…),
                                         * qui est l'information utile : elle dit ce que la personne peut déjà faire.
                                         */
                                        $role_label = $role_labels[ $primary_role ] ?? '';
                                        if ( '' === $role_label ) {
                                            $wp_roles   = wp_roles();
                                            $premier    = (array) $user->roles;
                                            $premier    = reset( $premier );
                                            $role_label = ( $premier && isset( $wp_roles->role_names[ $premier ] ) )
                                                ? translate_user_role( $wp_roles->role_names[ $premier ] )
                                                : __( 'No role', 'aiforya-multi-author' );
                                        }
                                        $c          = $charge[ $user->ID ] ?? [ 'total' => 0, 'approved' => 0, 'published' => 0 ];
                                    ?>
                                    <tr>
                                        <td>
                                            <div style="display:flex;align-items:center;gap:10px;">
                                                <?php echo get_avatar( $user->ID, 28, '', '', [ 'style' => 'border-radius:50%;' ] ); ?>
                                                <span style="color:#e2e8f0;"><?php echo esc_html( $user->display_name ); ?></span>
                                            </div>
                                        </td>
                                        <td>
                                            <span style="display:inline-block;padding:3px 10px;border-radius:12px;background:rgba(99,102,241,0.18);color:#a5b4fc;font-size:11px;text-transform:uppercase;letter-spacing:0.05em;">
                                                <?php echo esc_html( $role_label ); ?>
                                            </span>
                                        </td>
                                        <td style="text-align:right;color:#e2e8f0;font-weight:600;"><?php echo esc_html( (string) $c['total'] ); ?></td>
                                        <td style="text-align:right;color:#4ade80;"><?php echo esc_html( (string) $c['approved'] ); ?></td>
                                        <td style="text-align:right;color:#a5b4fc;"><?php echo esc_html( (string) $c['published'] ); ?></td>
                                    </tr>
                                    <?php endforeach; ?>
                                </tbody>
                            </table>
                        </div>
                    <?php endif; ?>
                </div>
            </div>

        </div>

        <?php
            }
}