import 'package:brick_offline_first_with_supabase/brick_offline_first_with_supabase.dart';
import 'package:brick_sqlite/brick_sqlite.dart';
import 'package:brick_supabase/brick_supabase.dart';

import '../utils/app_time.dart';

@ConnectOfflineFirstWithSupabase(
  supabaseConfig: SupabaseSerializable(tableName: 'attendance_logs'),
)
class AttendanceLog extends OfflineFirstWithSupabaseModel {
  final String id;
  final String userId;
  final String dutyScheduleId;
  final String shiftType;
  final DateTime checkInAt;
  final double checkInLat;
  final double checkInLng;
  final DateTime? checkOutAt;
  final double? checkOutLat;
  final double? checkOutLng;
  final String? justification;
  final String? checkOutJustification;
  final String verificationStatus;
  final String? checkInVerificationPhotoUrl;
  final String? checkOutVerificationPhotoUrl;

  @Supabase(ignore: true)
  @Sqlite(ignore: true)
  bool get isCheckedOut => checkOutAt != null;
  @Supabase(ignore: true)
  @Sqlite(ignore: true)
  bool get isVerified => verificationStatus == 'verified';
  @Supabase(ignore: true)
  @Sqlite(ignore: true)
  bool get isUnverified =>
      verificationStatus == 'unverified' || verificationStatus == 'skipped';

  AttendanceLog({
    required this.id,
    required this.userId,
    required this.dutyScheduleId,
    required this.shiftType,
    required this.checkInAt,
    required this.checkInLat,
    required this.checkInLng,
    this.checkOutAt,
    this.checkOutLat,
    this.checkOutLng,
    this.justification,
    this.checkOutJustification,
    this.verificationStatus = 'pending',
    this.checkInVerificationPhotoUrl,
    this.checkOutVerificationPhotoUrl,
  });

  factory AttendanceLog.fromMap(Map<String, dynamic> map) {
    final legacyUrl = map['verification_photo_url'] as String?;
    return AttendanceLog(
      id: map['id'] as String,
      userId: map['user_id'] as String,
      dutyScheduleId: map['duty_schedule_id'] as String,
      shiftType: map['shift_type'] as String? ?? 'normal',
      checkInAt: AppTime.parse(map['check_in_at'] as String),
      checkInLat: (map['check_in_lat'] as num).toDouble(),
      checkInLng: (map['check_in_lng'] as num).toDouble(),
      checkOutAt: map['check_out_at'] == null
          ? null : AppTime.parse(map['check_out_at'] as String),
      checkOutLat: (map['check_out_lat'] as num?)?.toDouble(),
      checkOutLng: (map['check_out_lng'] as num?)?.toDouble(),
      justification: map['justification'] as String?,
      checkOutJustification: map['check_out_justification'] as String?,
      verificationStatus: map['verification_status'] as String? ?? 'pending',
      checkInVerificationPhotoUrl:
          map['check_in_verification_photo_url'] as String? ?? legacyUrl,
      checkOutVerificationPhotoUrl:
          map['check_out_verification_photo_url'] as String?,
    );
  }
}