总销售额
query($query);
if ($result) {
while ($row = $result->fetch_assoc()) {
$visible_employees[] = intval($row['id']);
}
}
$employee_filter = $visible_employees;
} else {
// 组员只能看到自己
$employee_filter = intval($current_employee_id);
}
}
// 修改getRegionTotalSales和getActiveCountries函数调用，传入国家筛选条件
$total_sales = getRegionTotalSales($conn, $start_date, $end_date, $employee_filter, $country_filter);
echo "
¥" . number_format($total_sales['total_amount'], 2) . "
";
echo "
= 0 ? 'positive' : 'negative') . "'>";
echo ($total_sales['growth'] >= 0 ? '+' : '') . number_format($total_sales['growth'], 2) . "%
";
?>