mtb_crm_asp/region_stats.php

<?php
/**
 * 地区统计分析展示页面
 */
require_once 'conn.php';
require_once 'statistics_utils.php';
require_once 'statistics_region.php';

// 检查登录状态
if (!isset($_SESSION['employee_id'])) {
    checkLogin();
}

// 获取日期范围参数
$date_params = getDateRangeParams();
$start_date = $date_params['start_date_sql'];
$end_date = $date_params['end_date_sql'];
$date_range = $date_params['date_range'];

// 页面头部
include('statistics_header.php');
?>

<div class="container">
    <div class="page-header">
        <h1 class="page-title">地区统计分析</h1>
    </div>
    
    <!-- 日期筛选 -->
    <div class="filter-form">
        <form method="get" class="filter-form-inline">
            <div class="form-group">
                <label for="date_range">选择日期范围</label>
                <select class="form-control" id="date_range" name="date_range" onchange="toggleCustomDates()">
                    <option value="current_month" <?php echo $date_range == 'current_month' ? 'selected' : ''; ?>>本月</option>
                    <option value="last_month" <?php echo $date_range == 'last_month' ? 'selected' : ''; ?>>上月</option>
                    <option value="current_year" <?php echo $date_range == 'current_year' ? 'selected' : ''; ?>>今年</option>
                    <option value="last_30_days" <?php echo $date_range == 'last_30_days' ? 'selected' : ''; ?>>最近30天</option>
                    <option value="last_90_days" <?php echo $date_range == 'last_90_days' ? 'selected' : ''; ?>>最近90天</option>
                    <option value="custom" <?php echo $date_range == 'custom' ? 'selected' : ''; ?>>自定义日期范围</option>
                </select>
            </div>
            <div class="form-group custom-date-inputs" style="display: <?php echo $date_range == 'custom' ? 'inline-block' : 'none'; ?>">
                <label for="start_date">开始日期</label>
                <input type="date" class="form-control" id="start_date" name="start_date" value="<?php echo $date_params['custom_start']; ?>">
            </div>
            <div class="form-group custom-date-inputs" style="display: <?php echo $date_range == 'custom' ? 'inline-block' : 'none'; ?>">
                <label for="end_date">结束日期</label>
                <input type="date" class="form-control" id="end_date" name="end_date" value="<?php echo $date_params['custom_end']; ?>">
            </div>
            <div class="form-group">
                <button type="submit" class="btn">应用筛选</button>
            </div>
        </form>
    </div>
    
    <!-- 客户国家分布 -->
    <div class="chart-container">
        <?php
        $country_distribution = getCustomerCountryDistribution($conn);
        $country_labels = [];
        $country_data = [];
        
        while ($row = $country_distribution->fetch_assoc()) {
            $country_labels[] = $row['countryName'];
            $country_data[] = $row['customer_count'];
        }
        renderCustomerCountryDistributionChart($country_labels, $country_data);
        ?>
    </div>
    
    <!-- 地区订单分析 -->
    <div class="chart-container">
        <?php
        $region_orders = getOrdersByRegion($conn, $start_date, $end_date);
        $region_labels = [];
        $region_order_counts = [];
        $region_quantities = [];
        
        while ($row = $region_orders->fetch_assoc()) {
            $region_labels[] = $row['countryName'];
            $region_order_counts[] = $row['order_count'];
            $region_quantities[] = $row['total_quantity'];
        }
        renderRegionOrdersChart($region_labels, $region_order_counts, $region_quantities);
        ?>
    </div>
    
    <!-- 地区销售同比分析 -->
    <div class="chart-container">
        <?php
        $comparison_data = getRegionSalesComparison($conn, $start_date, $end_date);
        renderRegionSalesComparisonTable($comparison_data);
        ?>
    </div>
</div>

<style>
    .positive {
        color: #28a745;
        font-weight: bold;
    }
    .negative {
        color: #dc3545;
        font-weight: bold;
    }
</style>

<script>
function toggleCustomDates() {
    const dateRange = document.getElementById('date_range').value;
    const customDateInputs = document.querySelectorAll('.custom-date-inputs');
    
    if (dateRange === 'custom') {
        customDateInputs.forEach(el => el.style.display = 'inline-block');
    } else {
        customDateInputs.forEach(el => el.style.display = 'none');
    }
}
</script>

<?php
// 页面底部
include('statistics_footer.php');
?>