getConnection();
// إحصائيات
$stats = [];
$stmt = $conn->query("SELECT COUNT(*) as total, SUM(quantity * unit_cost) as value FROM raw_materials");
$stats['raw'] = $stmt->fetch(PDO::FETCH_ASSOC);
$stmt = $conn->query("SELECT COUNT(*) as total, SUM(quantity * unit_cost) as value FROM packaging_materials");
$stats['packaging'] = $stmt->fetch(PDO::FETCH_ASSOC);
$stmt = $conn->query("SELECT COUNT(*) as total, SUM(quantity * unit_cost) as value FROM wrapping_materials");
$stats['wrapping'] = $stmt->fetch(PDO::FETCH_ASSOC);
$stmt = $conn->query("SELECT COUNT(*) FROM product_recipes");
$stats['recipes'] = $stmt->fetchColumn();
$stmt = $conn->query("SELECT COUNT(*) FROM production_batches WHERE status = 'completed'");
$stats['batches'] = $stmt->fetchColumn();
?>
التقارير والتحليلات