产品销售概览
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);
}
}
$sales_overview = getProductSalesOverview($conn, $start_date, $end_date, $category_filter, $employee_filter);
renderProductSalesOverview($sales_overview);
?>
fetch_assoc()) {
$time_labels[] = $row['time_period'];
$quantities[] = $row['total_quantity'];
$revenues[] = $row['total_revenue'];
}
renderProductSalesTrendChart($time_labels, $quantities, $revenues);
?>
fetch_assoc()) {
$categories[] = $row['category_name'];
$category_quantities[] = $row['total_quantity'];
$category_revenues[] = $row['total_revenue'];
}
renderProductCategorySalesChart($categories, $category_quantities, $category_revenues);
?>