mtb_crm_asp/products_stats.php

<?php
/**
 * 产品统计分析展示页面
 */
require_once 'conn.php';
require_once 'statistics_utils.php';
require_once 'statistics_products.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'];
$period = $date_params['period'];

// 特定产品过滤
$product_id = isset($_GET['product_id']) ? intval($_GET['product_id']) : 0;

// 页面头部
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">
                <label for="period">时间粒度</label>
                <select class="form-control" id="period" name="period">
                    <option value="day" <?php echo $period == 'day' ? 'selected' : ''; ?>>日</option>
                    <option value="week" <?php echo $period == 'week' ? 'selected' : ''; ?>>周</option>
                    <option value="month" <?php echo $period == 'month' ? 'selected' : ''; ?>>月</option>
                </select>
            </div>
            <div class="form-group">
                <label for="category_id">产品分类</label>
                <select class="form-control" id="category_id" name="category_id">
                    <option value="0">全部分类</option>
                    <?php
                    $category_filter = isset($_GET['category_id']) ? intval($_GET['category_id']) : 0;
                    $categories = getProductCategories($conn);
                    while($category = $categories->fetch_assoc()) {
                        $selected = ($category_filter == $category['id']) ? 'selected' : '';
                        echo "<option value='{$category['id']}' {$selected}>{$category['name']}</option>";
                    }
                    ?>
                </select>
            </div>
            <div class="form-group">
                <button type="submit" class="btn">应用筛选</button>
            </div>
        </form>
    </div>
    
    <!-- 产品销售概览 -->
    <div class="key-metrics-section">
        <div class="section-title">
            <h2>产品销售概览</h2>
        </div>
        <?php
        $sales_overview = getProductSalesOverview($conn, $start_date, $end_date, $category_filter);
        renderProductSalesOverview($sales_overview);
        ?>
    </div>
    
    <!-- 热门产品 -->
    <div class="chart-container">
        <?php
        $top_products = getTopProducts($conn, $start_date, $end_date, 10);
        renderTopProductsTable($top_products);
        ?>
    </div>
    
    <!-- 新客户购买产品明细 -->
    <div class="section-container">
        <div class="section-title">
            <h2>新客户购买产品明细</h2>
        </div>
        <?php
        $new_customer_products = getNewCustomerProductPurchases($conn, $start_date, $end_date, $category_filter);
        renderNewCustomerProductPurchases($new_customer_products);
        ?>
    </div>
    
    <!-- 产品销售趋势 -->
    <div class="chart-container" style="display: none">
        <?php
        $product_trends = getProductSalesTrend($conn, $start_date, $end_date, $product_id, $period);
        
        $time_labels = [];
        $quantities = [];
        $revenues = [];
        
        while ($row = $product_trends->fetch_assoc()) {
            $time_labels[] = $row['time_period'];
            $quantities[] = $row['total_quantity'];
            $revenues[] = $row['total_revenue'];
        }
        renderProductSalesTrendChart($time_labels, $quantities, $revenues);
        ?>
    </div>
    
    <!-- 产品类别销售分布 -->
    <div class="chart-container" style="display: none">
        <?php
        $category_sales = getProductCategorySales($conn, $start_date, $end_date);
        
        $categories = [];
        $category_quantities = [];
        $category_revenues = [];
        
        while ($row = $category_sales->fetch_assoc()) {
            $categories[] = $row['category_name'];
            $category_quantities[] = $row['total_quantity'];
            $category_revenues[] = $row['total_revenue'];
        }
        renderProductCategorySalesChart($categories, $category_quantities, $category_revenues);
        ?>
    </div>
    
    <!-- 产品价格趋势分析 -->
    <div class="chart-container" style="display: none">
        <?php
        $price_trend_data = getProductPriceTrendAnalysis($conn, $start_date, $end_date, $product_id, $period);
        renderProductPriceTrendChart($price_trend_data);
        ?>
    </div>
    
    <!-- 产品季节性分析 -->
    <div class="chart-container" style="display: none">
        <?php
        $seasonality_data = getProductSeasonalityAnalysis($conn, $start_date, $end_date, $product_id);
        renderProductSeasonalityChart($seasonality_data);
        ?>
    </div>
    
    <!-- 产品客户细分分析 -->
    <div class="chart-container" style="display: none">
        <?php
        $customer_segment_data = getProductCustomerSegmentAnalysis($conn, $start_date, $end_date, $product_id);
        renderProductCustomerSegmentChart($customer_segment_data);
        ?>
    </div>
    
    <!-- 产品地区关联分析 -->
    <div class="chart-container" style="display: none">
        <?php
        $product_region_data = getProductRegionAnalysis($conn, $start_date, $end_date);
        renderProductRegionAnalysisTable($product_region_data);
        ?>
    </div>
    
    <!-- 产品增长率分析 -->
    <div class="chart-container" style="display: none">
        <?php
        $growth_data = getProductGrowthAnalysis($conn, $start_date, $end_date, $period);
        renderProductGrowthAnalysis($growth_data);
        ?>
    </div>
    
    <!-- 产品购买频率分析 -->
    <div class="chart-container" style="display: none">
        <?php
        $frequency_data = getProductPurchaseFrequency($conn, $start_date, $end_date);
        renderProductPurchaseFrequency($frequency_data);
        ?>
    </div>
</div>

<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');
    }
}

// 初始化所有图表的配置
Chart.defaults.font.family = "'Arial', sans-serif";
Chart.defaults.color = '#666';
Chart.defaults.plugins.tooltip.backgroundColor = 'rgba(0, 0, 0, 0.8)';
Chart.defaults.plugins.legend.position = 'bottom';
</script>

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