mtb_crm_asp/customers_stats.php

<?php
/**
 * 客户统计分析展示页面
 */
require_once 'conn.php';
require_once 'statistics_utils.php';
require_once 'statistics_customers.php';
require_once 'statistics_sales.php';
// 检查登录状态
if (!isset($_SESSION['employee_id'])) {
    checkLogin();
}

function formatCurrency($value) {
    return '¥' . number_format($value ?? 0, 2);
}

// 获取当前登录用户信息
$current_employee_id = $_SESSION['employee_id'];
$current_permission_role = 0;

// 获取当前用户权限角色
$current_employee_id = intval($current_employee_id); // 确保是整数
$query = "SELECT em_permission_role_id FROM employee WHERE id = $current_employee_id";
$result = $conn->query($query);
if ($result && $row = $result->fetch_assoc()) {
    $current_permission_role = $row['em_permission_role_id'];
}

// 获取日期范围参数
$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'];

// 页面头部
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" id="custom_start_date" 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" id="custom_end_date" 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="selected_employee">选择业务员</label>
                <select class="form-control" id="selected_employee" name="selected_employee">
                    <option value="all">所有业务员</option>
                    <?php
                    // 获取当前用户可见的业务员列表
                    $visible_employees_query = "";
                    
                    if ($current_permission_role == 1) {
                        // 管理员可以看到所有业务员
                        $visible_employees_query = "SELECT id, em_user FROM employee WHERE em_role IS NOT NULL ORDER BY em_user";
                    } elseif ($current_permission_role == 2) {
                        // 组长可以看到自己和组员
                        $visible_employees_query = "SELECT id, em_user FROM employee WHERE id = $current_employee_id OR em_role = $current_employee_id ORDER BY em_user";
                    } else {
                        // 组员只能看到自己
                        $visible_employees_query = "SELECT id, em_user FROM employee WHERE id = $current_employee_id";
                    }
                    
                    $visible_employees_result = $conn->query($visible_employees_query);
                    $selected_employee = isset($_GET['selected_employee']) ? $_GET['selected_employee'] : 'all';
                    
                    while ($emp = $visible_employees_result->fetch_assoc()) {
                        $selected = ($selected_employee == $emp['id']) ? 'selected' : '';
                        echo "<option value='".$emp['id']."' $selected>".$emp['em_user']."</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
        // 获取选择的业务员
        $selected_employee = isset($_GET['selected_employee']) ? $_GET['selected_employee'] : 'all';
        
        // 确定要显示哪些业务员的数据
        $employee_filter = null;
        
        if ($selected_employee != 'all') {
            // 如果选择了特定业务员，则只显示该业务员的数据
            $employee_filter = intval($selected_employee);
        } else {
            // 否则按权限显示相应的业务员数据
            if ($current_permission_role == 1) {
                // 管理员可以看到所有业务员
                $employee_filter = null;
            } elseif ($current_permission_role == 2) {
                // 组长可以看到自己和组员
                $visible_employees = [];
                $query = "SELECT id FROM employee WHERE id = " . intval($current_employee_id) . " OR em_role = " . intval($current_employee_id);
                $result = $conn->query($query);
                
                if ($result) {
                    while ($row = $result->fetch_assoc()) {
                        $visible_employees[] = $row['id'];
                    }
                }
                
                $employee_filter = $visible_employees;
            } else {
                // 组员只能看到自己
                $employee_filter = intval($current_employee_id);
            }
        }
        
        // 获取关键指标数据
        $total_customers = getTotalCustomers($conn, $employee_filter);
        $new_customers = getNewCustomers($conn, $start_date, $end_date, $employee_filter);
        $avg_customer_value = getAverageCustomerValue($conn, $start_date, $end_date, $employee_filter);
        $retention_data = getCustomerRetentionRate($conn, $start_date, $end_date, $employee_filter);
        $conversion_data = getOrderConversionRate($conn, $start_date, $end_date, $employee_filter);

        // 组合所有指标数据
        $kpi_data = [
            'total_customers' => $total_customers,
            'new_customers' => $new_customers,
            'avg_customer_value' => $avg_customer_value,
            'retention_rate' => $retention_data['retention_rate'],
            'retained_count' => $retention_data['retained_count'],
            'total_previous' => $retention_data['total_previous'],
            'conversion_rate' => $conversion_data['conversion_rate'],
            'customers_with_orders' => $conversion_data['customers_with_orders']
        ];

        // 渲染关键指标卡片
        renderKeyMetricsCard($kpi_data);
        ?>
    </div>
    
    <!-- 新增客户列表 -->
    <div class="customer-section">
        <div class="section-title">
            <h2>新增客户明细</h2>
        </div>
        <?php
        // 获取选择的业务员
        $selected_employee = isset($_GET['selected_employee']) ? $_GET['selected_employee'] : 'all';
        
        // 获取新增客户详细数据
        $employee_filter = null;
        
        if ($selected_employee != 'all') {
            // 如果选择了特定业务员，则只显示该业务员的数据
            $employee_filter = intval($selected_employee);
        } else {
            // 否则按权限显示相应的业务员数据
            if ($current_permission_role == 1) {
                // 管理员可以看到所有业务员
                $employee_filter = null;
            } elseif ($current_permission_role == 2) {
                // 组长可以看到自己和组员
                $visible_employees = [];
                $query = "SELECT id FROM employee WHERE id = " . intval($current_employee_id) . " OR em_role = " . intval($current_employee_id);
                $result = $conn->query($query);
                
                if ($result) {
                    while ($row = $result->fetch_assoc()) {
                        $visible_employees[] = $row['id'];
                    }
                }
                
                $employee_filter = $visible_employees;
            } else {
                // 组员只能看到自己
                $employee_filter = intval($current_employee_id);
            }
        }
        
        $new_customers_details = getNewCustomersDetails($conn, $start_date, $end_date, $employee_filter);
        
        // 渲染新增客户图表
        renderNewCustomersChart($new_customers_details);
        ?>
    </div>
    
    <!-- 业务员新增客户统计 -->
    <div class="employee-section">
        <div class="section-title">
            <h2>业务员新增客户统计</h2>
        </div>
        <?php
        // 获取选择的业务员
        $selected_employee = isset($_GET['selected_employee']) ? $_GET['selected_employee'] : 'all';
        
        // 获取各业务员新增客户数据
        // 根据权限角色和选择的业务员过滤业务员数据
        $visible_employees = [];
        
        if ($selected_employee != 'all') {
            // 如果选择了特定业务员，则只显示该业务员的数据
            $visible_employees = [intval($selected_employee)];
            $employee_new_customers = getNewCustomersByEmployee($conn, $start_date, $end_date, $visible_employees);
        } else {
            // 否则按权限显示相应的业务员数据
            if ($current_permission_role == 1) {
                // 管理员可以看到所有业务员
                $employee_new_customers = getNewCustomersByEmployee($conn, $start_date, $end_date);
            } elseif ($current_permission_role == 2) {
                // 组长可以看到自己和组员
                $visible_employees = [];
                $query = "SELECT id FROM employee WHERE id = " . intval($current_employee_id) . " OR em_role = " . intval($current_employee_id);
                $result = $conn->query($query);
                
                if ($result) {
                    while ($row = $result->fetch_assoc()) {
                        $visible_employees[] = $row['id'];
                    }
                }
                
                $employee_new_customers = getNewCustomersByEmployee($conn, $start_date, $end_date, $visible_employees);
            } else {
                // 组员只能看到自己
                $visible_employees = [intval($current_employee_id)];
                $employee_new_customers = getNewCustomersByEmployee($conn, $start_date, $end_date, $visible_employees);
            }
        }
        
        // 渲染业务员新增客户图表
        renderNewCustomersByEmployeeChart($employee_new_customers);
        ?>
    </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');
    }
}
</script>

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