<?php
/**
 * Plugin Name: Aion Dashboard for WooCommerce
 * Description: Lekki i intuicyjny dashboard ze statystykami WooCommerce (zamówienia, przychody, nowi klienci + linki do edycji, rabaty i więcej).
 * Version: 1.4.1
 * Author: Aion Media
 * License: GPLv2 or later
 * License URI: https://www.gnu.org/licenses/gpl-2.0.html
 */

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

add_action( 'admin_enqueue_scripts', 'aion_woodashboard_enqueue_styles' );
function aion_woodashboard_enqueue_styles( $hook ) {
    if ( 'toplevel_page_aion-woodashboard' !== $hook ) {
        return;
    }

    $custom_css = '
        .aion-wrap { max-width: 1300px; margin: 20px 20px 20px 0; font-family: -apple-system,BlinkMacSystemFont,"Segoe UI",Roboto,Oxygen-Sans,Ubuntu,Cantarell,"Helvetica Neue",sans-serif; }
        .aion-header { display: flex; justify-content: space-between; align-items: center; margin-bottom: 20px; background: #fff; padding: 15px 25px; border-radius: 8px; box-shadow: 0 1px 3px rgba(0,0,0,0.1); }
        .aion-header h1 { margin: 0; font-size: 22px; color: #1d2327;}
        .aion-grid { display: grid; grid-template-columns: repeat(auto-fit, minmax(300px, 1fr)); gap: 20px; align-items: start; }
        .aion-card { background: #fff; padding: 25px; border-radius: 8px; box-shadow: 0 1px 3px rgba(0,0,0,0.1); box-sizing: border-box; }
        .aion-card h3 { margin: 0 0 15px 0; font-size: 14px; color: #646970; text-transform: uppercase; letter-spacing: 0.5px; }
        .aion-card .value { font-size: 34px; font-weight: 700; color: #2271b1; margin-bottom: 20px; }
        .aion-card .comparison { font-size: 13px; color: #50575e; margin-bottom: 8px; display:flex; justify-content: space-between; border-bottom: 1px solid #f0f0f1; padding-bottom: 8px;}
        .aion-card .comparison:last-child { border-bottom: none; margin-bottom: 0; padding-bottom: 0;}
        .aion-list { list-style: none; padding: 0; margin: 0; }
        .aion-list li { display: flex; justify-content: space-between; padding: 10px 0; border-bottom: 1px solid #f0f0f1; font-size: 14px; align-items: center;}
        .aion-list li:last-child { border-bottom: none; }
        .aion-list li strong { color: #1d2327; }
        .aion-list li .meta { font-size: 12px; color: #8c8f94; display: block; margin-top: 2px;}
        .aion-list a { text-decoration: none; color: #2271b1; transition: color 0.1s;}
        .aion-list a:hover { color: #135e96; text-decoration: underline; }
        .aion-scrollable { max-height: 180px; overflow-y: auto; padding-right: 5px; margin-top: 15px; border-top: 1px solid #e2e4e7; padding-top: 10px;}
        .aion-scrollable::-webkit-scrollbar { width: 5px; }
        .aion-scrollable::-webkit-scrollbar-thumb { background: #c3c4c7; border-radius: 4px; }
        .aion-select { padding: 6px 12px; border-radius: 4px; border: 1px solid #8c8f94; font-size: 14px; }
        .aion-btn { background: #2271b1; color: #fff; border: none; padding: 8px 16px; border-radius: 4px; cursor: pointer; text-decoration: none; font-weight: 600; font-size: 14px; transition: background 0.2s;}
        .aion-btn:hover { background: #135e96; }
    ';

    wp_register_style( 'aion-woodashboard-style', false );
    wp_enqueue_style( 'aion-woodashboard-style' );
    wp_add_inline_style( 'aion-woodashboard-style', wp_strip_all_tags( $custom_css ) );
}

add_action( 'admin_menu', 'aion_woodashboard_menu' );
function aion_woodashboard_menu() {
    add_menu_page(
        'Aion Dashboard',
        'Aion Dashboard',
        'manage_woocommerce',
        'aion-woodashboard',
        'aion_woodashboard_page',
        'dashicons-chart-area',
        55.5
    );
}

function aion_get_woo_stats( $month, $year ) {
    $first_day = gmdate( 'Y-m-d 00:00:00', gmmktime( 0, 0, 0, $month, 1, $year ) );
    $last_day  = gmdate( 'Y-m-d 23:59:59', gmmktime( 0, 0, 0, $month, gmdate( 't', gmmktime( 0, 0, 0, $month, 1, $year ) ), $year ) );

    $args = array(
        'status'       => array( 'wc-completed', 'wc-processing' ),
        'limit'        => -1,
        'date_created' => $first_day . '...' . $last_day,
        'return'       => 'objects',
    );

    $orders = wc_get_orders( $args );

    $total_sales       = 0;
    $total_discount    = 0;
    $total_items       = 0;
    $order_count       = count( $orders );
    $products_sold     = array();
    $coupons_used      = array();
    $customers_revenue = array();
    $unique_emails     = array();

    foreach ( $orders as $order ) {
        $order_total = $order->get_total();
        $total_sales    += $order_total;
        $total_discount += $order->get_total_discount();
        
        $email = $order->get_billing_email();
        $name  = trim( $order->get_billing_first_name() . ' ' . $order->get_billing_last_name() );
        $name  = ! empty( $name ) ? $name : 'Klient (Brak danych)';

        if ( ! empty( $email ) ) {
            if ( ! isset( $unique_emails[ $email ] ) ) {
                $unique_emails[ $email ] = $name;
            }

            if ( isset( $customers_revenue[ $email ] ) ) {
                $customers_revenue[ $email ]['revenue'] += $order_total;
            } else {
                $customers_revenue[ $email ] = array(
                    'name'    => $name,
                    'revenue' => $order_total,
                );
            }
        }
        
        foreach ( $order->get_items() as $item ) {
            $product_id = $item->get_product_id();
            $qty        = $item->get_quantity();
            
            $total_items += $qty;

            if ( isset( $products_sold[ $product_id ] ) ) {
                $products_sold[ $product_id ] += $qty;
            } else {
                $products_sold[ $product_id ] = $qty;
            }
        }

        foreach ( $order->get_coupon_codes() as $coupon_code ) {
            if ( isset( $coupons_used[ $coupon_code ] ) ) {
                $coupons_used[ $coupon_code ]++;
            } else {
                $coupons_used[ $coupon_code ] = 1;
            }
        }
    }

    arsort( $products_sold );
    $top_products = array_slice( $products_sold, 0, 5, true );

    arsort( $coupons_used );
    $top_coupons = array_slice( $coupons_used, 0, 5, true );

    uasort( $customers_revenue, function( $a, $b ) {
        return $b['revenue'] <=> $a['revenue'];
    });
    $top_customers = array_slice( $customers_revenue, 0, 5, true );

    $new_customers_list = array();
    foreach ( $unique_emails as $email => $name ) {
        $prev_orders = wc_get_orders( array(
            'billing_email' => $email,
            'status'        => array( 'wc-completed', 'wc-processing' ),
            'date_created'  => '<' . $first_day,
            'limit'         => 1,
            'return'        => 'ids',
        ) );

        if ( empty( $prev_orders ) ) {
            $new_customers_list[ $email ] = $name;
        }
    }

    $aov = $order_count > 0 ? $total_sales / $order_count : 0;

    return array(
        'count'              => $order_count,
        'revenue'            => $total_sales,
        'aov'                => $aov,
        'total_items'        => $total_items,
        'total_discount'     => $total_discount,
        'new_customers'      => count( $new_customers_list ),
        'new_customers_list' => $new_customers_list,
        'top_products'       => $top_products,
        'top_coupons'        => $top_coupons,
        'top_customers'      => $top_customers,
    );
}

function aion_calc_diff_html( $current, $previous ) {
    if ( $previous == 0 ) {
        $diff = $current > 0 ? 100 : 0;
    } else {
        $diff = ( ( $current - $previous ) / $previous ) * 100;
    }

    $color = $diff >= 0 ? '#46b450' : '#dc3232';
    $sign  = $diff > 0 ? '+' : '';
    
    return '<span style="color:' . esc_attr( $color ) . '; font-weight:600;">' . esc_html( $sign ) . esc_html( round( $diff, 1 ) ) . '%</span>';
}

function aion_calc_diff_html_inverted( $current, $previous ) {
    if ( $previous == 0 ) {
        $diff = $current > 0 ? 100 : 0;
    } else {
        $diff = ( ( $current - $previous ) / $previous ) * 100;
    }
    $color = $diff > 0 ? '#dc3232' : '#46b450';
    $sign  = $diff > 0 ? '+' : '';
    
    return '<span style="color:' . esc_attr( $color ) . '; font-weight:600;">' . esc_html( $sign ) . esc_html( round( $diff, 1 ) ) . '%</span>';
}

function aion_woodashboard_page() {
    if ( ! current_user_can( 'manage_woocommerce' ) ) {
        return;
    }

    $current_month = gmdate( 'n' );
    $current_year  = gmdate( 'Y' );

    if ( isset( $_GET['aion_nonce'] ) && wp_verify_nonce( sanitize_text_field( wp_unslash( $_GET['aion_nonce'] ) ), 'aion_woodashboard_filter' ) ) {
        $current_month = isset( $_GET['aion_month'] ) ? intval( $_GET['aion_month'] ) : $current_month;
        $current_year  = isset( $_GET['aion_year'] ) ? intval( $_GET['aion_year'] ) : $current_year;
    }

    $prev_month_m = $current_month - 1 == 0 ? 12 : $current_month - 1;
    $prev_month_y = $current_month - 1 == 0 ? $current_year - 1 : $current_year;
    
    $prev_year_m = $current_month;
    $prev_year_y = $current_year - 1;

    $stats_current = aion_get_woo_stats( $current_month, $current_year );
    $stats_mom     = aion_get_woo_stats( $prev_month_m, $prev_month_y );
    $stats_yoy     = aion_get_woo_stats( $prev_year_m, $prev_year_y );

    echo '<div class="aion-wrap">';
    
    echo '<div class="aion-header">';
    echo '<h1>Aion Dashboard for WooCommerce</h1>';
    echo '<form method="GET" action="">';
    echo '<input type="hidden" name="page" value="aion-woodashboard">';
    wp_nonce_field( 'aion_woodashboard_filter', 'aion_nonce' );
    
    echo '<select name="aion_month" class="aion-select" style="margin-right: 15px;">';
    for ( $m = 1; $m <= 12; $m++ ) {
        echo '<option value="' . esc_attr( $m ) . '" ' . selected( $m, $current_month, false ) . '>' . esc_html( date_i18n( 'F', gmmktime( 0, 0, 0, $m, 1 ) ) ) . '</option>';
    }
    echo '</select>';

    echo '<select name="aion_year" class="aion-select" style="margin-right: 15px;">';
    $start_year = gmdate( 'Y' ) - 3;
    for ( $y = gmdate( 'Y' ); $y >= $start_year; $y-- ) {
        echo '<option value="' . esc_attr( $y ) . '" ' . selected( $y, $current_year, false ) . '>' . esc_html( $y ) . '</option>';
    }
    echo '</select>';
    
    echo '<button type="submit" class="aion-btn">Odśwież dane</button>';
    echo '</form>';
    echo '</div>'; 

    echo '<div class="aion-grid">';

    echo '<div class="aion-card">';
    echo '<h3>Liczba zamówień</h3>';
    echo '<div class="value">' . esc_html( $stats_current['count'] ) . '</div>';
    echo '<div class="comparison"><span>Miesiąc do miesiąca:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['count'], $stats_mom['count'] ) ) . '</div>';
    echo '<div class="comparison"><span>Rok do roku:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['count'], $stats_yoy['count'] ) ) . '</div>';
    echo '</div>';

    echo '<div class="aion-card">';
    echo '<h3>Przychód brutto</h3>';
    echo '<div class="value">' . wp_kses_post( wc_price( $stats_current['revenue'] ) ) . '</div>';
    echo '<div class="comparison"><span>Miesiąc do miesiąca:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['revenue'], $stats_mom['revenue'] ) ) . '</div>';
    echo '<div class="comparison"><span>Rok do roku:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['revenue'], $stats_yoy['revenue'] ) ) . '</div>';
    echo '</div>';

    echo '<div class="aion-card">';
    echo '<h3>Średnia wartość koszyka (AOV)</h3>';
    echo '<div class="value">' . wp_kses_post( wc_price( $stats_current['aov'] ) ) . '</div>';
    echo '<div class="comparison"><span>Miesiąc do miesiąca:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['aov'], $stats_mom['aov'] ) ) . '</div>';
    echo '<div class="comparison"><span>Rok do roku:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['aov'], $stats_yoy['aov'] ) ) . '</div>';
    echo '</div>';

    echo '<div class="aion-card">';
    echo '<h3>Sprzedane produkty (szt.)</h3>';
    echo '<div class="value">' . esc_html( $stats_current['total_items'] ) . '</div>';
    echo '<div class="comparison"><span>Miesiąc do miesiąca:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['total_items'], $stats_mom['total_items'] ) ) . '</div>';
    echo '<div class="comparison"><span>Rok do roku:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['total_items'], $stats_yoy['total_items'] ) ) . '</div>';
    echo '</div>';

    echo '<div class="aion-card">';
    echo '<h3>Wartość udzielonych rabatów</h3>';
    echo '<div class="value" style="color: #d63638;">' . wp_kses_post( wc_price( $stats_current['total_discount'] ) ) . '</div>';
    echo '<div class="comparison"><span>Miesiąc do miesiąca:</span> ' . wp_kses_post( aion_calc_diff_html_inverted( $stats_current['total_discount'], $stats_mom['total_discount'] ) ) . '</div>';
    echo '<div class="comparison"><span>Rok do roku:</span> ' . wp_kses_post( aion_calc_diff_html_inverted( $stats_current['total_discount'], $stats_yoy['total_discount'] ) ) . '</div>';
    echo '</div>';

    echo '<div class="aion-card">';
    echo '<h3>Nowi klienci</h3>';
    echo '<div class="value" style="color: #46b450; margin-bottom: 10px;">' . esc_html( $stats_current['new_customers'] ) . '</div>';
    echo '<div class="comparison"><span>Miesiąc do miesiąca:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['new_customers'], $stats_mom['new_customers'] ) ) . '</div>';
    echo '<div class="comparison"><span>Rok do roku:</span> ' . wp_kses_post( aion_calc_diff_html( $stats_current['new_customers'], $stats_yoy['new_customers'] ) ) . '</div>';
    
    if ( ! empty( $stats_current['new_customers_list'] ) ) {
        echo '<div class="aion-scrollable">';
        echo '<ul class="aion-list">';
        foreach ( $stats_current['new_customers_list'] as $email => $name ) {
            $customer_url = admin_url( 'admin.php?page=wc-admin&path=/customers&filter-search=' . urlencode( $email ) );
            echo '<li>';
            echo '<div style="width: 100%;">';
            echo '<a href="' . esc_url( $customer_url ) . '" target="_blank" style="font-weight: 600; font-size: 13px;">' . esc_html( $name ) . '</a>';
            echo '<span class="meta" style="font-size: 11px;">' . esc_html( $email ) . '</span>';
            echo '</div>';
            echo '</li>';
        }
        echo '</ul>';
        echo '</div>';
    } else {
        echo '<div style="margin-top: 15px; border-top: 1px solid #e2e4e7; padding-top: 10px; color: #777; font-size: 13px;">Brak nowych klientów.</div>';
    }
    echo '</div>';

    echo '<div class="aion-card">';
    echo '<h3>Najbardziej dochodowi klienci</h3>';
    if ( empty( $stats_current['top_customers'] ) ) {
        echo '<p style="color:#777;">Brak danych w tym miesiącu.</p>';
    } else {
        echo '<ul class="aion-list">';
        foreach ( $stats_current['top_customers'] as $email => $data ) {
            $customer_url = admin_url( 'admin.php?page=wc-admin&path=/customers&filter-search=' . urlencode( $email ) );
            echo '<li>';
            echo '<div style="max-width: 65%; overflow: hidden;">';
            echo '<a href="' . esc_url( $customer_url ) . '" target="_blank" style="font-weight: 600;">' . esc_html( $data['name'] ) . '</a>';
            echo '<span class="meta">' . esc_html( $email ) . '</span>';
            echo '</div>';
            echo '<strong>' . wp_kses_post( wc_price( $data['revenue'] ) ) . '</strong>';
            echo '</li>';
        }
        echo '</ul>';
    }
    echo '</div>';

    echo '<div class="aion-card">';
    echo '<h3>Top 5 Produktów (wg sztuk)</h3>';
    if ( empty( $stats_current['top_products'] ) ) {
        echo '<p style="color:#777;">Brak sprzedaży w tym miesiącu.</p>';
    } else {
        echo '<ul class="aion-list">';
        foreach ( $stats_current['top_products'] as $product_id => $qty ) {
            $product = wc_get_product( $product_id );
            
            if ( $product ) {
                $edit_link = get_edit_post_link( $product_id );
                $title_html = '<a href="' . esc_url( $edit_link ) . '" target="_blank" title="' . esc_attr( $product->get_name() ) . '">' . esc_html( $product->get_name() ) . '</a>';
            } else {
                $title_html = '<span style="color:#777;">Usunięty (#' . esc_html( $product_id ) . ')</span>';
            }

            echo '<li><span style="white-space: nowrap; overflow: hidden; text-overflow: ellipsis; max-width: 80%;">' . wp_kses_post( $title_html ) . '</span> <strong>' . esc_html( $qty ) . ' szt.</strong></li>';
        }
        echo '</ul>';
    }
    echo '</div>';

    echo '<div class="aion-card">';
    echo '<h3>Najpopularniejsze kupony</h3>';
    if ( empty( $stats_current['top_coupons'] ) ) {
        echo '<p style="color:#777;">Brak użytych kuponów w tym miesiącu.</p>';
    } else {
        echo '<ul class="aion-list">';
        foreach ( $stats_current['top_coupons'] as $coupon_code => $uses ) {
            echo '<li><span style="text-transform: uppercase; font-weight: 600;">' . esc_html( $coupon_code ) . '</span> <strong>' . esc_html( $uses ) . ' użyć</strong></li>';
        }
        echo '</ul>';
    }
    echo '</div>';

    echo '</div>';
    echo '</div>';
}