countAllPendingUpdates method

Implementation

Future<int> countAllPendingUpdates() async {
  final db = await database;

  int pendingIndividuosCount = Sqflite.firstIntValue(
          await db.rawQuery('SELECT COUNT(*) FROM pending_individuos')) ??
      0;

  int pendingMonitoreosCount = Sqflite.firstIntValue(
          await db.rawQuery('SELECT COUNT(*) FROM pending_monitoreos')) ??
      0;

  int pendingPrediosCount = Sqflite.firstIntValue(
          await db.rawQuery('SELECT COUNT(*) FROM pending_predios')) ??
      0;

  int pendingCoordenadasCount = Sqflite.firstIntValue(
          await db.rawQuery('SELECT COUNT(*) FROM pending_coordenadas')) ??
      0;

  int pendingUmsCount = Sqflite.firstIntValue(
          await db.rawQuery('SELECT COUNT(*) FROM pending_ums')) ??
      0;

  int pendingUmsCoordenadasCount = Sqflite.firstIntValue(await db
          .rawQuery('SELECT COUNT(*) FROM pending_ums_coordenadas')) ??
      0;

  int pendingSolicitudesCount = Sqflite.firstIntValue(await db.rawQuery(
          'SELECT COUNT(*) FROM pending_usuario_expediente_predio')) ??
      0;

  int pendingEspeciesCount = Sqflite.firstIntValue(await db
          .rawQuery('SELECT COUNT(*) FROM pending_especies_expediente')) ??
      0;

  int pendingDetallesEspecieCount = Sqflite.firstIntValue(await db.rawQuery(
          'SELECT COUNT(*) FROM pending_detalle_especie_expediente')) ??
      0;

  // Pendientes de nuevos individuos
  int pendingNewIndividuosCount = Sqflite.firstIntValue(
          await db.rawQuery('SELECT COUNT(*) FROM pending_new_individuos')) ??
      0;

  // Pendientes de palmas y árboles
  int pendingPalmasCount = Sqflite.firstIntValue(
          await db.rawQuery('SELECT COUNT(*) FROM pending_palmas')) ??
      0;

  int pendingArbolesCount = Sqflite.firstIntValue(
          await db.rawQuery('SELECT COUNT(*) FROM pending_arboles')) ??
      0;

  return pendingIndividuosCount +
      pendingMonitoreosCount +
      pendingPrediosCount +
      pendingCoordenadasCount +
      pendingUmsCount +
      pendingUmsCoordenadasCount +
      pendingSolicitudesCount +
      pendingEspeciesCount +
      pendingDetallesEspecieCount +
      pendingNewIndividuosCount + // ← se suma pendientes de nuevos individuos
      pendingPalmasCount +
      pendingArbolesCount;
}