powerage-ristoris-flutter/lib/database/daos/scadenze_dao.dart

import 'package:drift/drift.dart';
import '../database.dart';
import '../tables/scadenze.dart';

class ScadenzeDao {
  final AppDatabase db;
  ScadenzeDao(this.db);

  Future<List<Scadenza>> getScadenzeCliente(int idCliente) {
    return (db.select(db.scadenze)..where((t) => t.idCliente.equals(idCliente))).get();
  }

  Future<List<Scadenza>> getScadenzePerAgente(int idAgente) {
    return (db.select(db.scadenze)
      ..where((t) => t.idAgente.equals(idAgente) & (t.flgSoppressa.equals(0) | t.flgSoppressa.isNull()))
    ).get();
  }

  Future<void> markAllAsDeleted() {
    return (db.update(db.scadenze)).write(ScadenzeCompanion(stato: const Value('X')));
  }

  Future<void> removeDeleted() {
    return (db.delete(db.scadenze)..where((t) => t.stato.equals('X'))).go();
  }

  Future<int> insertScadenza(Scadenza s) {
    return db.into(db.scadenze).insert(s);
  }

  Future<void> clearAll() {
    return db.delete(db.scadenze).go();
  }
}