using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations.Schema;
using System.Data;

namespace GPW.CORE.Data.DbModels
{
    // <Auto-Generated>
    // This is here so CodeMaid doesn't reorganize this document
    // </Auto-Generated>
    [Table("TimbratureExpl")]
    public partial class TimbratureExplModel
    {
        public DateTime DataLav { get; set; }
        public int IdxDipendente { get; set; }
        public string? CognomeNome { get; set; }
        public DateTime? Entrata1 { get; set; }
        public DateTime? Uscita1 { get; set; }
        public DateTime? Entrata2 { get; set; }
        public DateTime? Uscita2 { get; set; }
        public DateTime? Entrata3 { get; set; }
        public DateTime? Uscita3 { get; set; }
        public DateTime? Entrata4 { get; set; }
        public DateTime? Uscita4 { get; set; }
        public double? HLav { get; set; }
        public int? MinLav { get; set; }
        public int? MinOrd { get; set; }
        /// <summary>
        /// minuti non lavorati (ovvero se fatti meno di ordinari e senza giustificativi)
        /// </summary>
        public int? MinNonLav { get; set; }
        public int? MinStra { get; set; }
        public int? MinPerm { get; set; }
        public int? MinFer { get; set; }
        public int? MinMal { get; set; }
        public int? MinFest { get; set; }
        /// <summary>
        /// Minuti di Cassa Integrazione
        /// </summary>
        public int? MinCassa { get; set; }
        /// <summary>
        /// Minuti Permessi per 104
        /// </summary>
        public int? Min104 { get; set; }
        public int? MinMpp { get; set; }
        /// <summary>
        /// DATEDIFF(n, ISNULL(entrata_1,GETDATE()), ISNULL(ISNULL(uscita_4,ISNULL(uscita_3,ISNULL(uscita_2,ISNULL(uscita_1,entrata_1)))),GETDATE()))
        /// </summary>
        public int? MinArcoPres { get; set; }
        public bool? IsOkTim { get; set; }
        /// <summary>
        /// dato sintetico x indicare se TUTTE le timbrature componenti siano approvate
        /// </summary>
        public bool? IsOkApp { get; set; }
        /// <summary>
        /// determina se il record sia &quot;bloccato&quot; (archiviazione e blocco mesi precedenti...)
        /// </summary>
        public bool? Block { get; set; }
        /// <summary>
        /// eventuale diagnostica da check function sulla riga indicata (codice)
        /// </summary>
        public string? ChkFunCod { get; set; }
        /// <summary>
        /// eventuale diagnostica da check function sulla riga indicata (spiegazione)
        /// </summary>
        public string? ChkFunRes { get; set; }
        public int? IsOk { get; set; }
        /// <summary>
        /// determina se la giornata sia ok (oreLav + giustificativi &gt;= oreOrd)
        /// </summary>
        public int IsOkLav { get; set; }
        /// <summary>
        /// totale ore giustificate
        /// </summary>
        public double? HGiust { get; set; }
        /// <summary>
        /// Temperatura rilevata
        /// </summary>
        public decimal TempRil { get; set; }

        [NotMapped]
        public string UID
        {
            get => $"{IdxDipendente:000}_{DataLav:yyyyMMdd}";
        }
    }
}