powerage-ristoris-flutter/lib/providers/dashboard_provider.dart

import 'package:flutter_riverpod/flutter_riverpod.dart';
import '../database/database.dart';
import 'database_provider.dart';
import '../database/daos/clienti_dao.dart';
import '../database/daos/articoli_dao.dart';
import '../database/daos/ordini_dao.dart';

class DashboardData {
  final List<TopCustomerData> topCustomers;
  final List<TopItemData> topItems;
  final int newOrdersCount;
  final int ordersOnHoldCount;
  final int newCustomersCount;

  DashboardData({
    this.topCustomers = const [],
    this.topItems = const [],
    this.newOrdersCount = 0,
    this.ordersOnHoldCount = 0,
    this.newCustomersCount = 0,
  });
}

final dashboardProvider = FutureProvider.family<DashboardData, int>((ref, idAgente) async {
  final clientiDao = ref.read(clientiDaoProvider);
  final articoliDao = ref.read(articoliDaoProvider);
  final ordiniDao = ref.read(ordiniDaoProvider);

  final topCusts = await clientiDao.topCustomers(5);
  final topItems = await articoliDao.getMostSoldItems(5);
  final newOrdC = await ordiniDao.countNewOrders();
  final ordHold = await ordiniDao.countOrdersOnHold();
  final newCust = await clientiDao.countNewCustomers();

  return DashboardData(
    topCustomers: topCusts,
    topItems: topItems,
    newOrdersCount: newOrdC,
    ordersOnHoldCount: ordHold,
    newCustomersCount: newCust,
  );
});