关键指标
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);
?>
新增客户明细
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);
?>
业务员新增客户统计
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);
?>