package com.inteacc.hr.entity.ls;
import com.inteacc.mdg.entity.StandardTenantEntity;
import com.inteacc.mdg.entity.gen.Company;
import com.inteacc.mdg.entity.gen.OperatingLocation;
import io.jmix.core.DeletePolicy;
import io.jmix.core.entity.annotation.OnDeleteInverse;
import io.jmix.core.metamodel.annotation.Composition;
import io.jmix.core.metamodel.annotation.JmixEntity;
import io.jmix.core.metamodel.annotation.JmixProperty;
import jakarta.persistence.*;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.Date;
import java.util.List;
@JmixEntity
@Table(name = "HR_ATTEND_LOG_MANUAL", indexes = {
        @Index(name = "IDX_HRATTENDLOGMANUAL_COMPANY", columnList = "COMPANY_ID"),
        @Index(name = "IDX_HRATTENDLOGM_OPERATINGLOC", columnList = "OPERATING_LOCATION_ID")
})
@Entity(name = "hr_AttendLogManual")
public class AttendLogManual extends StandardTenantEntity {
    @Column(name = "ATTEND_ENTRY_NO")
    private String attendEntryNo;
    @Column(name = "ENTRY_DATE")
    private LocalDateTime entryDate;
    @OnDeleteInverse(DeletePolicy.DENY)
    @JoinColumn(name = "COMPANY_ID")
    @ManyToOne(fetch = FetchType.LAZY)
    private Company company;
    @OnDeleteInverse(DeletePolicy.DENY)
    @JoinColumn(name = "OPERATING_LOCATION_ID")
    @ManyToOne(fetch = FetchType.LAZY)
    private OperatingLocation operatingLocation;
    @Column(name = "POSTED_TIME")
    @Temporal(TemporalType.TIMESTAMP)
    private Date postedTime;
    @Column(name = "EMPLOYEE_LIST")
    private String employeeList;
    @Column(name = "COMMENTS")
    private String comments;
    @Composition
    @OneToMany(mappedBy = "attendLogManual")
    private List<AttendLogManualLine> attendLogManualLine;
    @JmixProperty
    @Transient
    private Integer checkInBufferMinute;
    @JmixProperty
    @Transient
    private LocalDate attenDateFrom;
    @JmixProperty
    @Transient
    private LocalDate attenDateTo;
    @JmixProperty
    @Transient
    private Boolean updateCheckInTime;
    @JmixProperty
    @Transient
    private Integer checkOutBufferMinute;
    @JmixProperty
    @Transient
    private Boolean updateCheckOutTime;
    public String getAttendEntryNo() {
        return attendEntryNo;
    }
    public void setAttendEntryNo(String attendEntryNo) {
        this.attendEntryNo = attendEntryNo;
    }
    public void setEntryDate(LocalDateTime entryDate) {
        this.entryDate = entryDate;
    }
    public LocalDateTime getEntryDate() {
        return entryDate;
    }
    public void setCheckOutBufferMinute(Integer checkOutBufferMinute) {
        this.checkOutBufferMinute = checkOutBufferMinute;
    }
    public Integer getCheckOutBufferMinute() {
        return checkOutBufferMinute;
    }
    public void setUpdateCheckOutTime(Boolean updateCheckOutTime) {
        this.updateCheckOutTime = updateCheckOutTime;
    }
    public Boolean getUpdateCheckOutTime() {
        return updateCheckOutTime;
    }
    public void setAttenDateFrom(LocalDate attenDateFrom) {
        this.attenDateFrom = attenDateFrom;
    }
    public LocalDate getAttenDateFrom() {
        return attenDateFrom;
    }
    public void setAttenDateTo(LocalDate attenDateTo) {
        this.attenDateTo = attenDateTo;
    }
    public LocalDate getAttenDateTo() {
        return attenDateTo;
    }
    public void setUpdateCheckInTime(Boolean updateCheckInTime) {
        this.updateCheckInTime = updateCheckInTime;
    }
    public Boolean getUpdateCheckInTime() {
        return updateCheckInTime;
    }
    public Integer getCheckInBufferMinute() {
        return checkInBufferMinute;
    }
    public void setCheckInBufferMinute(Integer checkInBufferMinute) {
        this.checkInBufferMinute = checkInBufferMinute;
    }
    public List<AttendLogManualLine> getAttendLogManualLine() {
        return attendLogManualLine;
    }
    public void setAttendLogManualLine(List<AttendLogManualLine> attendLogManualLine) {
        this.attendLogManualLine = attendLogManualLine;
    }
    public String getEmployeeList() {
        return employeeList;
    }
    public void setEmployeeList(String employeeList) {
        this.employeeList = employeeList;
    }
    public Date getPostedTime() {
        return postedTime;
    }
    public void setPostedTime(Date postedTime) {
        this.postedTime = postedTime;
    }
    public String getComments() {
        return comments;
    }
    public void setComments(String comments) {
        this.comments = comments;
    }
    public OperatingLocation getOperatingLocation() {
        return operatingLocation;
    }
    public void setOperatingLocation(OperatingLocation operatingLocation) {
        this.operatingLocation = operatingLocation;
    }
    public Company getCompany() {
        return company;
    }
    public void setCompany(Company company) {
        this.company = company;
    }
}


===================================

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<view xmlns="http://jmix.io/schema/flowui/view"
      title="msg://attendLogManualDetailView.title"
      focusComponent="form">
    <data>
        <collection class="com.inteacc.mdg.entity.gen.OperatingLocation" id="mdg_OperatingLocationsDc"
                    fetchPlan="_instance_name">
            <loader id="mdg_OperatingLocationsDl" readOnly="true">
                <query>
                    <![CDATA[select e from mdg_OperatingLocation e
                    join e.operatingLocationCo o
                    where o.company = :container_mdg_CompaniesDc]]>
                </query>
            </loader>
        </collection>
        <collection class="com.inteacc.mdg.entity.gen.Company" id="mdg_CompaniesDc" fetchPlan="_instance_name">
            <loader id="mdg_CompaniesDl" readOnly="true">
                <query>
                    <![CDATA[select e from mdg_Company e]]>
                </query>
            </loader>
        </collection>
        <instance id="attendLogManualDc"
                  class="com.inteacc.hr.entity.ls.AttendLogManual">
            <fetchPlan extends="_base">
                <property name="company" fetchPlan="_instance_name"/>
                <property name="operatingLocation" fetchPlan="_instance_name"/>
                <property name="attendLogManualLine" fetchPlan="_base">
                    <property name="employeeProfile" fetchPlan="_instance_name"/>
                    <property name="workShift" fetchPlan="_instance_name"/>
                </property>
            </fetchPlan>
            <loader/>
            <collection id="attendLogManualLineDc" property="attendLogManualLine"/>
        </instance>
    </data>
    <facets>
        <dataLoadCoordinator auto="true"/>
    </facets>
    <actions>
        <action id="saveAction" type="detail_saveClose"/>
        <action id="closeAction" type="detail_close"/>
    </actions>
    <layout>
        <formLayout id="form" dataContainer="attendLogManualDc">
            <entityComboBox id="companyField" property="company" itemsContainer="mdg_CompaniesDc" required="true">
                <actions>
                    <action id="entityLookup" type="entity_lookup"/>
                    <action id="entityClear" type="entity_clear"/>
                </actions>
            </entityComboBox>
            <entityComboBox id="operatingLocationField" property="operatingLocation"
                            itemsContainer="mdg_OperatingLocationsDc" required="true">
                <actions>
                    <action id="entityLookup" type="entity_lookup"/>
                    <action id="entityClear" type="entity_clear"/>
                </actions>
            </entityComboBox>
            <dateTimePicker id="entryDateField" property="entryDate" readOnly="true"/>
            <dateTimePicker id="postedTimeField" property="postedTime" readOnly="true"/>
            <textField id="commentsField" property="comments"/>
            <textField id="attendEntryNoField" property="attendEntryNo" readOnly="true"/>
        </formLayout>
        <details summaryText="msg://attendLogManualDetailView.summaryText">
            <formLayout id="form2" dataContainer="attendLogManualDc">
                <datePicker id="attenDateFromField" property="attenDateFrom"/>
                <datePicker id="attenDateToField" property="attenDateTo"/>
                <textField id="checkInBufferMinuteField" property="checkInBufferMinute"/>
                <checkbox id="updateCheckInTimeField" property="updateCheckInTime"/>
                <textField id="checkOutBufferMinuteField" property="checkOutBufferMinute"/>
                <checkbox id="updateCheckOutTimeField" property="updateCheckOutTime"/>
                <button id="selectEmployeeBtn" icon="LIST_SELECT"
                        title="msg://attendLogManualDetailView.selectEmployeeProfiles" text="Select employees"/>
            </formLayout>
        </details>
        <hbox id="buttonsPanel" classNames="buttons-panel">
            <button action="attendLogManualLineTable.create"/>
            <button action="attendLogManualLineTable.edit"/>
            <button action="attendLogManualLineTable.remove"/>
        </hbox>
        <dataGrid id="attendLogManualLineTable" dataContainer="attendLogManualLineDc" width="100%" minHeight="20em">
            <actions>
                <action id="create" type="list_create">
                    <properties>
                        <property name="openMode" value="DIALOG"/>
                    </properties>
                </action>
                <action id="edit" type="list_edit">
                    <properties>
                        <property name="openMode" value="DIALOG"/>
                    </properties>
                </action>
                <action id="remove" type="list_remove"/>
            </actions>
            <columns resizable="true">
                <column property="attenDate" autoWidth="true"/>
                <column property="employeeProfile" autoWidth="true"/>
                <column property="emplIdMachine" autoWidth="true"/>
                <column property="checkInBufferMinute" autoWidth="true"/>
                <column property="updateCheckInTime" autoWidth="true"/>
                <column property="checkOutBufferMinute" autoWidth="true"/>
                <column property="updateCheckOutTime" autoWidth="true"/>
                <column property="postedToAttendLog"/>
                <column property="workShift"/>
                <column property="comments"/>
            </columns>
        </dataGrid>
        <hbox id="detailActions">
            <button id="saveAndCloseBtn" action="saveAction"/>
            <button id="closeBtn" action="closeAction"/>
        </hbox>
    </layout>
</view>


=============================

package com.inteacc.hr.view.ls.attendlogmanual;
import com.inteacc.hr.entity.ls.*;
import com.inteacc.hr.entity.org.EmployeeProfile;
import com.inteacc.hr.view.employeeprofile.EmployeeProfileSelectListView;
import com.inteacc.hr.view.org.employeeprofile.EmployeeProfileListView;
import com.inteacc.mdg.entity.gen.Company;
import com.inteacc.mdg.entity.gen.WorkShift;
import com.vaadin.flow.component.ClickEvent;
import com.vaadin.flow.component.button.Button;
import com.vaadin.flow.component.formlayout.FormLayout;
import com.vaadin.flow.component.notification.Notification;
import com.vaadin.flow.router.Route;
import io.jmix.core.DataManager;
import io.jmix.core.EntityStates;
import io.jmix.core.UnconstrainedDataManager;
import io.jmix.core.session.SessionData;
import io.jmix.flowui.DialogWindows;
import io.jmix.flowui.Notifications;
import io.jmix.flowui.component.grid.DataGrid;
import io.jmix.flowui.component.validation.ValidationErrors;
import io.jmix.flowui.kit.component.button.JmixButton;
import io.jmix.flowui.model.CollectionPropertyContainer;
import io.jmix.flowui.model.DataContext;
import io.jmix.flowui.model.InstanceContainer;
import io.jmix.flowui.view.*;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.*;
import java.util.stream.Collectors;
@Route(value = "attendLogManuals/:id", layout = DefaultMainViewParent.class)
@ViewController("hr_AttendLogManual.detail")
@ViewDescriptor("attend-log-manual-detail-view.xml")
@EditedEntityContainer("attendLogManualDc")
public class AttendLogManualDetailView extends StandardDetailView<AttendLogManual> {
    private static final Logger log = LoggerFactory.getLogger(AttendLogManualDetailView.class);
    @ViewComponent
    private CollectionPropertyContainer<AttendLogManualLine> attendLogManualLineDc;
    @Autowired
    private DialogWindows dialogWindows;
    @Autowired
    private Notifications notifications;
    @ViewComponent
    private DataContext dataContext;
    @Autowired
    private EntityStates entityStates;
    @ViewComponent
    private DataGrid attendLogManualLineTable;
    @Autowired
    private SessionData sessionData;
    @Autowired
    private DataManager dataManager;
    @ViewComponent
    private FormLayout form;
    @ViewComponent
    private FormLayout form2;
    @Autowired
    private UnconstrainedDataManager unconstrainedDataManager;
    @Subscribe
    public void onInit(InitEvent event) {
        form.setResponsiveSteps(
                // Use one column by default
                new FormLayout.ResponsiveStep("0", 1),
                // Use two columns, if the layout's width exceeds 320px
                new FormLayout.ResponsiveStep("420px", 2),
                // Use three columns, if the layout's width exceeds 500px
                new FormLayout.ResponsiveStep("600px", 3),
                new FormLayout.ResponsiveStep("950px", 4),
                new FormLayout.ResponsiveStep("1250px", 5)
        );
        form2.setResponsiveSteps(
                // Use one column by default
                new FormLayout.ResponsiveStep("0", 1),
                // Use two columns, if the layout's width exceeds 320px
                new FormLayout.ResponsiveStep("420px", 2),
                // Use three columns, if the layout's width exceeds 500px
                new FormLayout.ResponsiveStep("600px", 3),
                new FormLayout.ResponsiveStep("950px", 4),
                new FormLayout.ResponsiveStep("1250px", 5)
        );
        attendLogManualLineTable.setMultiSelect(true);
    }
    @Subscribe
    public void onBeforeShow(BeforeShowEvent event) {
        if(entityStates.isNew(getEditedEntity())){
            getEditedEntity().setEntryDate(LocalDateTime.now());
            getEditedEntity().setCheckInBufferMinute(0);
            getEditedEntity().setCheckOutBufferMinute(0);
            getEditedEntity().setUpdateCheckInTime(false);
            getEditedEntity().setUpdateCheckOutTime(false);
            UUID id = (UUID) sessionData.getAttribute("companyId");
            if (id != null) {
                Company company = dataManager.load(Company.class).id(id).one();
                getEditedEntity().setCompany(company);
            }
        }
    }
    @Subscribe(id = "attendLogManualDc", target = Target.DATA_CONTAINER)
    public void onAttendLogManualDcItemPropertyChange(final InstanceContainer.ItemPropertyChangeEvent<AttendLogManual> event) {
        if("attenDateFrom".equals(event.getProperty()) || "attenDateTo".equals(event.getProperty())){
            if(event.getItem().getAttenDateFrom()!=null && event.getItem().getAttenDateTo()!=null){
                if(event.getItem().getAttenDateFrom().isAfter(event.getItem().getAttenDateTo())) {
                    event.getItem().setAttenDateFrom(null);
                    notifications.create("Atten date from can not be later than the atten date to")
                            .withDuration(3000)
                            .withCloseable(false)
                            .withPosition(Notification.Position.TOP_CENTER)
                            .withType(Notifications.Type.WARNING)
                            .show();
                }
            }
        }
    }
     @Subscribe(id = "selectEmployeeBtn", subject = "clickListener")
    public void onSelectEmployeeBtnClick1(final ClickEvent<JmixButton> event) {
        if(fieldSelectionValid()) {
            if(okToSelectEmployee()) {
                List<UUID> companyIdList = new ArrayList<>();
                List<UUID> operLocIdList = new ArrayList<>();
                companyIdList.add(getEditedEntity().getCompany().getId());
                operLocIdList.add(getEditedEntity().getOperatingLocation().getId());
                DialogWindow<EmployeeProfileSelectListView> window =
                        dialogWindows.lookup(this, EmployeeProfile.class)
                                .withViewClass(EmployeeProfileSelectListView.class)
                                .withSelectHandler(selectedItems -> {
                                    for (EmployeeProfile employeeProfile : selectedItems) {
                                        for (LocalDate date = getEditedEntity().getAttenDateFrom(); !date.isAfter(getEditedEntity().getAttenDateTo()); date = date.plusDays(1)) {
                                            if(!entryExists(employeeProfile.getId(), date)) {
                                                AttendLogManualLine line = dataContext.create(AttendLogManualLine.class);
                                                line.setEmployeeProfile(employeeProfile);
                                                line.setAttenDate(date);
                                                line.setWorkShift(this.getWorkshift(employeeProfile, date));
                                                //  line.setEmplIdMachine(employeeProfile.getAttendCardId());
                                                line.setCheckInBufferMinute(getEditedEntity().getCheckInBufferMinute());
                                                line.setCheckOutBufferMinute(getEditedEntity().getCheckOutBufferMinute());
                                                line.setUpdateCheckInTime(getEditedEntity().getUpdateCheckInTime());
                                                line.setUpdateCheckOutTime(getEditedEntity().getUpdateCheckOutTime());
                                                line.setPostedToAttendLog(false);
                                                line.setAttendLogManual(getEditedEntity());
                                                attendLogManualLineDc.getMutableItems().add(line);
                                            }
                                        }
                                    }
                                })
                                .build();
                EmployeeProfileSelectListView view = window.getView();
                view.setCompanyIdList(companyIdList);
                view.setOperLocIdList(operLocIdList);
                view.setWorkShiftRotated(false);
                view.setFilterNo(4);
                window.open();
            }
        }
    }
    private boolean fieldSelectionValid(){
        if(getEditedEntity().getCompany()==null){
            notifications.create("Please select the Company")
                    .withType(Notifications.Type.WARNING)
                    .withPosition(Notification.Position.BOTTOM_END)
                    .withDuration(5000)
                    .withCloseable(false)
                    .show();
            return false;
        }else if(getEditedEntity().getOperatingLocation()==null){
            notifications.create("Please select the Operating location")
                    .withType(Notifications.Type.WARNING)
                    .withPosition(Notification.Position.BOTTOM_END)
                    .withDuration(5000)
                    .withCloseable(false)
                    .show();
            return false;
        }else if(getEditedEntity().getAttenDateFrom()==null){
            notifications.create("Please select the attendance date from")
                    .withType(Notifications.Type.WARNING)
                    .withPosition(Notification.Position.BOTTOM_END)
                    .withDuration(5000)
                    .withCloseable(false)
                    .show();
            return false;
        }else if(getEditedEntity().getAttenDateTo()==null){
            notifications.create("Please select the attendance date to")
                    .withType(Notifications.Type.WARNING)
                    .withPosition(Notification.Position.BOTTOM_END)
                    .withDuration(5000)
                    .withCloseable(false)
                    .show();
            return false;
        }
        return true;
    }
    private boolean okToSelectEmployee(){
        if(getEditedEntity().getUpdateCheckInTime()==null && getEditedEntity().getUpdateCheckOutTime()==null){
            notifications.create("Please update check-in and/or check-out time")
                    .withPosition(Notification.Position.MIDDLE)
                    .withDuration(3000)
                    .withCloseable(false)
                    .show();
            return false;
        }else{
            if(getEditedEntity().getUpdateCheckInTime() && getEditedEntity().getCheckInBufferMinute() ==0) {
                notifications.create("Please update check-in buffer time")
                        .withPosition(Notification.Position.MIDDLE)
                        .withDuration(3000)
                        .withCloseable(false)
                        .show();
                return false;
            }else if(getEditedEntity().getUpdateCheckOutTime() && getEditedEntity().getCheckOutBufferMinute() ==0){
                notifications.create("Please update check-in buffer time")
                        .withPosition(Notification.Position.MIDDLE)
                        .withDuration(3000)
                        .withCloseable(false)
                        .show();
                return false;
            }
            return true;
        }
    }
    private WorkShift getWorkshift(EmployeeProfile employeeProfile1, LocalDate attenDate){
        final EmplWorkCalendar emplWorkCalendar = dataManager.load(EmplWorkCalendar.class)
                .query("select e from hr_EmplWorkCalendar e where e.employeeProfile = :employeeProfile1 and e.dutyDate = :dutyDate1")
                .parameter("employeeProfile1", employeeProfile1)
                .parameter("dutyDate1", attenDate)
                .optional().orElse(null);
        if(emplWorkCalendar!=null){
            return emplWorkCalendar.getWorkShift();
        }else{
            final EmployeeProfile employeeProfile = unconstrainedDataManager.load(EmployeeProfile.class)
                    .query("select e from hr_EmployeeProfile e where e.id = :id1")
                    .parameter("id1", employeeProfile1.getId())
                    .one();
            return employeeProfile.getWorkShift();
        }
    }
private boolean entryExists(UUID employeeId, LocalDate attenDate){
    //Check other transactions
    final AttendLogManualLine entity = dataManager.load(AttendLogManualLine.class)
            .query("select a from hr_AttendLogManualLine a where a.employeeProfile.id = :employeeProfileId1 and a.attendLogManual <> :attendLogManual1 and a.attenDate = :attenDate1")
            .parameter("employeeProfileId1", employeeId)
            .parameter("attendLogManual1", getEditedEntity())
            .parameter("attenDate1", attenDate)
            .optional().orElse(null);
    if(entity!=null) {
        notifications.create("Duplicate entries found")
                .show();
        return true;
    }
    return false;
}
    @Subscribe
    public void onValidation(final ValidationEvent event) {
        ValidationErrors errors = new ValidationErrors();
        //check duplicate entries
/*
        List<AttendLogManualLine> duplicates = getEditedEntity().getAttendLogManualLine().stream()
                .collect(Collectors.groupingBy(
                        line -> Map.of(
                                "employeeProfile", line.getEmployeeProfile().getEmployeeCode(),
                                "attenDate", line.getAttenDate()
                        ),
                        Collectors.toList()
                ))
                .values()
                .stream()
                .filter(list -> list.size() > 1) // Keep only duplicates
                .flatMap(Collection::stream)
                .collect(Collectors.toList());
        */
        if(getEditedEntity().getAttendLogManualLine()==null){
            errors.add("Please add employees attendance data");
        }else {
            boolean hasDuplicates = getEditedEntity().getAttendLogManualLine().stream()
                    .collect(Collectors.groupingBy(
                            line -> Map.of(
                                    "employeeProfile", line.getEmployeeProfile(),
                                    "attenDate", line.getAttenDate()
                            ),
                            Collectors.counting() // Count occurrences
                    ))
                    .values()
                    .stream()
                    .anyMatch(count -> count > 1); // Check if any group has more than 1 occurrence
            //System.out.println("Has Duplicates: " + hasDuplicates);
            // log.info("duplicates "+duplicates);
            if (hasDuplicates)
                // errors.add("Duplicate entries found "+duplicates);
                errors.add("Duplicate entry(ies) found");
        }
        //System.out.println("Duplicate Entries: " + duplicates);
        event.addErrors(errors);
    }
@Override
public boolean hasUnsavedChanges() {
    if (isReadOnly()) {
        return false;
    }
    return super.hasUnsavedChanges();
}
}


=================

package com.inteacc.hr.entity.ls;
import com.inteacc.hr.entity.org.EmployeeProfile;
import com.inteacc.mdg.entity.StandardTenantEntity;
import com.inteacc.mdg.entity.gen.WorkShift;
import io.jmix.core.DeletePolicy;
import io.jmix.core.MetadataTools;
import io.jmix.core.entity.annotation.OnDeleteInverse;
import io.jmix.core.metamodel.annotation.DependsOnProperties;
import io.jmix.core.metamodel.annotation.InstanceName;
import io.jmix.core.metamodel.annotation.JmixEntity;
import io.jmix.core.metamodel.datatype.DatatypeFormatter;
import jakarta.persistence.*;
import java.time.LocalDate;
@JmixEntity
@Table(name = "HR_ATTEND_LOG_MANUAL_LINE", indexes = {
        @Index(name = "IDX_HRATTENDLOGMANUA_WORKSHIFT", columnList = "WORK_SHIFT_ID"),
        @Index(name = "IDX_HRATTENDLOGM_ATTENDLOGMAN", columnList = "ATTEND_LOG_MANUAL_ID"),
        @Index(name = "IDX_HRATTENDLOGM_EMPLOYEEPROF", columnList = "EMPLOYEE_PROFILE_ID"),
        @Index(name = "IDX_HR_ATTEND_LOG_MANUAL_LINE_BUFFER_MIN", columnList = "CHECK_IN_BUFFER_MINUTE")
})
@Entity(name = "hr_AttendLogManualLine")
public class AttendLogManualLine extends StandardTenantEntity {
    @OnDeleteInverse(DeletePolicy.DENY)
    @JoinColumn(name = "EMPLOYEE_PROFILE_ID")
    @ManyToOne(fetch = FetchType.LAZY)
    private EmployeeProfile employeeProfile;
    @Column(name = "EMPL_ID_MACHINE")
    private String emplIdMachine;
    @Column(name = "ATTEN_DATE")
    private LocalDate attenDate;
    @OnDeleteInverse(DeletePolicy.DENY)
    @JoinColumn(name = "WORK_SHIFT_ID")
    @ManyToOne(fetch = FetchType.LAZY)
    private WorkShift workShift;
    @Column(name = "CHECK_IN_BUFFER_MINUTE")
    private Integer checkInBufferMinute;
    @Column(name = "CHECK_OUT_BUFFER_MINUTE")
    private Integer checkOutBufferMinute;
    @Column(name = "UPDATE_CHECK_IN_TIME")
    private Boolean updateCheckInTime;
    @Column(name = "UPDATE_CHECK_OUT_TIME")
    private Boolean updateCheckOutTime;
    @Column(name = "POSTED_TO_ATTEND_LOG")
    private Boolean postedToAttendLog;
    @Column(name = "COMMENTS")
    @Lob
    private String comments;
    @OnDeleteInverse(DeletePolicy.CASCADE)
    @JoinColumn(name = "ATTEND_LOG_MANUAL_ID", nullable = false)
    @ManyToOne(fetch = FetchType.LAZY, optional = false)
    private AttendLogManual attendLogManual;
    public void setAttenDate(LocalDate attenDate) {
        this.attenDate = attenDate;
    }
    public LocalDate getAttenDate() {
        return attenDate;
    }
    public EmployeeProfile getEmployeeProfile() {
        return employeeProfile;
    }
    public void setEmployeeProfile(EmployeeProfile employeeProfile) {
        this.employeeProfile = employeeProfile;
    }
    public AttendLogManual getAttendLogManual() {
        return attendLogManual;
    }
    public void setAttendLogManual(AttendLogManual attendLogManual) {
        this.attendLogManual = attendLogManual;
    }
    public String getComments() {
        return comments;
    }
    public void setComments(String comments) {
        this.comments = comments;
    }
    public Boolean getPostedToAttendLog() {
        return postedToAttendLog;
    }
    public void setPostedToAttendLog(Boolean postedToAttendLog) {
        this.postedToAttendLog = postedToAttendLog;
    }
    public Boolean getUpdateCheckOutTime() {
        return updateCheckOutTime;
    }
    public void setUpdateCheckOutTime(Boolean updateCheckOutTime) {
        this.updateCheckOutTime = updateCheckOutTime;
    }
    public Integer getCheckOutBufferMinute() {
        return checkOutBufferMinute;
    }
    public void setCheckOutBufferMinute(Integer checkOutBufferMinute) {
        this.checkOutBufferMinute = checkOutBufferMinute;
    }
    public Boolean getUpdateCheckInTime() {
        return updateCheckInTime;
    }
    public void setUpdateCheckInTime(Boolean updateCheckInTime) {
        this.updateCheckInTime = updateCheckInTime;
    }
    public Integer getCheckInBufferMinute() {
        return checkInBufferMinute;
    }
    public void setCheckInBufferMinute(Integer checkInBufferMinute) {
        this.checkInBufferMinute = checkInBufferMinute;
    }
    public WorkShift getWorkShift() {
        return workShift;
    }
    public void setWorkShift(WorkShift workShift) {
        this.workShift = workShift;
    }
    public String getEmplIdMachine() {
        return emplIdMachine;
    }
    public void setEmplIdMachine(String emplIdMachine) {
        this.emplIdMachine = emplIdMachine;
    }
    public EmployeeProfile getEmployee() {
        return employeeProfile;
    }
    public void setEmployee(EmployeeProfile employeeProfile) {
        this.employeeProfile = employeeProfile;
    }
    @InstanceName
    @DependsOnProperties({"attenDate", "employeeProfile"})
    public String getInstanceName(MetadataTools metadataTools, DatatypeFormatter datatypeFormatter) {
        return String.format("%s %s",
                datatypeFormatter.formatLocalDate(attenDate),
                metadataTools.format(employeeProfile));
    }
}


================================

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<view xmlns="http://jmix.io/schema/flowui/view"
      title="msg://attendLogManualLineDetailView.title"
      focusComponent="form">
    <data>
        <instance id="attendLogManualLineDc"
                  class="com.inteacc.hr.entity.ls.AttendLogManualLine">
            <fetchPlan extends="_base">
                <property name="employeeProfile" fetchPlan="_instance_name"/>
                <property name="workShift" fetchPlan="_instance_name"/>
            </fetchPlan>
            <loader/>
        </instance>
    </data>
    <facets>
        <dataLoadCoordinator auto="true"/>
    </facets>
    <actions>
        <action id="saveAction" type="detail_saveClose"/>
        <action id="closeAction" type="detail_close"/>
    </actions>
    <layout>
        <formLayout id="form" dataContainer="attendLogManualLineDc">
            <textField id="employeeCodeField" property="employeeProfile.employeeCode"/>
            <entityPicker id="employeeProfileField" property="employeeProfile" required="true">
                <actions>
                    <action id="entityLookup" type="entity_lookup"/>
                    <action id="entityClear" type="entity_clear"/>
                </actions>
            </entityPicker>
            <datePicker id="attenDateField" property="attenDate" required="true"/>
            <entityPicker id="workShiftField" property="workShift">
                <actions>
                    <action id="entityLookup" type="entity_lookup"/>
                    <action id="entityClear" type="entity_clear"/>
                </actions>
            </entityPicker>
            <textField id="checkInBufferMinuteField" property="checkInBufferMinute"/>
            <checkbox id="updateCheckInTimeField" property="updateCheckInTime"/>
            <textField id="checkOutBufferMinuteField" property="checkOutBufferMinute"/>
            <checkbox id="updateCheckOutTimeField" property="updateCheckOutTime"/>
            <checkbox id="postedToAttendLogField" property="postedToAttendLog"/>
            <textArea id="commentsField" height="9.5em" property="comments"/>
            <textField id="emplIdMachineField" property="emplIdMachine" readOnly="true"/>
        </formLayout>
        <hbox id="detailActions">
            <button id="saveAndCloseBtn" action="saveAction"/>
            <button id="closeBtn" action="closeAction"/>
        </hbox>
    </layout>
</view>


==========================

package com.inteacc.hr.view.ls.attendlogmanualline;
import com.inteacc.hr.entity.ls.AttendLogManualLine;
import com.inteacc.hr.entity.ls.EmplWorkCalendar;
import com.inteacc.hr.entity.org.EmployeeProfile;
import com.inteacc.hr.service.InteaccAttendServiceBean;
import com.inteacc.hr.service.InteaccHrServiceBean;
import com.inteacc.mdg.entity.gen.WorkShift;
import com.vaadin.flow.component.notification.Notification;
import com.vaadin.flow.component.shared.HasClientValidation;
import com.vaadin.flow.router.Route;
import io.jmix.core.DataManager;
import io.jmix.core.EntityStates;
import io.jmix.flowui.Notifications;
import io.jmix.flowui.component.SupportsTypedValue;
import io.jmix.flowui.component.textfield.TypedTextField;
import io.jmix.flowui.component.validation.ValidationErrors;
import io.jmix.flowui.model.InstanceContainer;
import io.jmix.flowui.view.*;
import org.springframework.beans.factory.annotation.Autowired;
import java.time.LocalDate;
import java.util.UUID;
@Route(value = "attendLogManualLines/:id", layout = DefaultMainViewParent.class)
@DialogMode(maxWidth = "800px")
@ViewController("hr_AttendLogManualLine.detail")
@ViewDescriptor("attend-log-manual-line-detail-view.xml")
@EditedEntityContainer("attendLogManualLineDc")
public class AttendLogManualLineDetailView extends StandardDetailView<AttendLogManualLine> {
    @Autowired
    private DataManager dataManager;
    @Autowired
    private Notifications notifications;
    @Autowired
    private EntityStates entityStates;
    @ViewComponent
    private TypedTextField<String> employeeCodeField;
    @Autowired
    private InteaccHrServiceBean inteaccHrServiceBean;
    @Autowired
    private InteaccAttendServiceBean inteaccAttendServiceBean;
    @Subscribe
    public void onReady(ReadyEvent event) {
        if(entityStates.isNew(getEditedEntity())){
            getEditedEntity().setPostedToAttendLog(false);
            getEditedEntity().setUpdateCheckInTime(true);
            getEditedEntity().setUpdateCheckOutTime(true);
            getEditedEntity().setCheckInBufferMinute(0);
            getEditedEntity().setCheckOutBufferMinute(0);
            getEditedEntity().setAttenDate(LocalDate.now());
        }
    }
    /*
    @Subscribe("employeeCodeField")
    public void onEmployeeCodeFieldClientValidated(final HasClientValidation.ClientValidatedEvent event) {
        final EmployeeProfile employeeProfile = dataManager.load(EmployeeProfile.class)
                .query("select e from hr_EmployeeProfile e where e.employeeCode = :employeeCode1")
                .parameter("employeeCode1", employeeCodeField.getTypedValue())
                .optional().orElse(null);
        if(employeeProfile!=null){
            getEditedEntity().setEmployeeProfile(employeeProfile);
        }else{
            employeeCodeField.setValue("");
            notifications.create("Invalid employee code").show();
        }
    }
*/
    @Subscribe(id = "attendLogManualLineDc", target = Target.DATA_CONTAINER)
    public void onAttendLogManualLineDcItemPropertyChange(InstanceContainer.ItemPropertyChangeEvent<AttendLogManualLine> event) {
        /*
        if("emplIdMachine".equals(event.getProperty()) && event.getItem().getEmplIdMachine()!=null) {
            EmployeeProfile employeeProfile = dataManager.load(EmployeeProfile.class)
                    .query("select e from hr_EmployeeProfile e where e.emplIdMachine = :emplIdMachine1")
                    .parameter("emplIdMachine1", event.getItem().getEmplIdMachine())
                    .optional().orElse(null);
            if (employeeProfile != null) {
                getEditedEntity().setEmployeeProfile(employeeProfile);
            } else {
                event.getItem().setEmplIdMachine(null);
                notifications.create("Sorry, invalid machine ID").show();
            }
        }else
            */
        if("employeeProfile".equals(event.getProperty()) && event.getItem().getEmployeeProfile()!=null) {
            WorkShift workShift = inteaccAttendServiceBean.getWorkshift(getEditedEntity().getEmployeeProfile().getId(), getEditedEntity().getAttenDate());
            getEditedEntity().setWorkShift(workShift);
            if(event.getItem().getAttenDate()!=null && entryExists(getEditedEntity().getEmployeeProfile().getId(), event.getItem().getAttenDate())){
                getEditedEntity().setAttenDate(null);
               // notifications.create("Sorry, the selected date has existing entries")
                 //       .withDuration(5000)
                   ///    .withPosition(Notification.Position.MIDDLE)
                     //   .show();
            }
        }else if("attenDate".equals(event.getProperty()) && event.getItem().getAttenDate()!=null && event.getItem().getEmployeeProfile()!=null){
            if(entryExists(getEditedEntity().getEmployeeProfile().getId(), event.getItem().getAttenDate())){
                getEditedEntity().setAttenDate(null);
              //  notifications.create("Sorry, the selected date has existing entries")
               //         .withDuration(3000)
                //        .withCloseable(false)
                   //     .withPosition(Notification.Position.MIDDLE)
                   //    .show();
            }
        }
    }
/*
    private void updateWorkshift(){
        final EmplWorkCalendar emplWorkCalendar = dataManager.load(EmplWorkCalendar.class)
                .query("select e from hr_EmplWorkCalendar e where e.employeeProfile = :employeeProfile1 and e.dutyDate = :dutyDate1")
                .parameter("employeeProfile1", getEditedEntity().getEmployeeProfile())
                .parameter("dutyDate1", getEditedEntity().getAttenDate())
                .optional().orElse(null);
        if(emplWorkCalendar!=null){
            getEditedEntity().setWorkShift(emplWorkCalendar.getWorkShift());
        }else{
            final EmployeeProfile employeeProfile = dataManager.load(EmployeeProfile.class)
                    .query("select e from hr_EmployeeProfile e where e.id = :id1")
                    .parameter("id1", getEditedEntity().getEmployeeProfile().getId())
                    .one();
            getEditedEntity().setWorkShift(employeeProfile.getWorkShift());
        }
    }
*/
    @Subscribe
    public void onValidation(final ValidationEvent event) {
        ValidationErrors errors = new ValidationErrors();
        if(!getEditedEntity().getUpdateCheckInTime() && !getEditedEntity().getUpdateCheckOutTime()){
            errors.add("Please select at least check in or check out time update option");
        }else if(getEditedEntity().getUpdateCheckInTime()){
            if(getEditedEntity().getCheckInBufferMinute()==null)
                errors.add("PLease update the check-in buffer minures from the employee's workshift");
        }else if(getEditedEntity().getUpdateCheckOutTime()){
            if(getEditedEntity().getCheckOutBufferMinute()==null)
                errors.add("PLease update the check-in buffer minures from the employee's workshift");
        }else if(getEditedEntity().getAttenDate().isAfter(LocalDate.now()))
            errors.add("Attendance date can not be in future");
        event.addErrors(errors);
    }
    private boolean entryExists(UUID employeeId, LocalDate attenDate){
        //Check other transactions
        final AttendLogManualLine entity = dataManager.load(AttendLogManualLine.class)
                .query("select a from hr_AttendLogManualLine a where a.employeeProfile.id = :employeeProfileId1 and a.attendLogManual <> :attendLogManual1 and a.attenDate = :attenDate1")
                .parameter("employeeProfileId1", employeeId)
                .parameter("attendLogManual1", getEditedEntity().getAttendLogManual())
                .parameter("attenDate1", attenDate)
                .optional().orElse(null);
        if(entity!=null) {
            notifications.create("Duplicate entries found")
                    .show();
            return true;
        }
        return false;
    }
    @Subscribe("employeeCodeField")
    public void onEmployeeCodeFieldTypedValueChange(final SupportsTypedValue.TypedValueChangeEvent<TypedTextField<String>, String> event) {
        if(getEditedEntity().getAttendLogManual().getOperatingLocation()!=null) {
            EmployeeProfile employeeProfile = inteaccHrServiceBean.getEmployeeProfileFromEmployeeCode(event.getValue());
            if (employeeProfile != null) {
                if(employeeProfile.getOperatingLocation().equals(getEditedEntity().getAttendLogManual().getOperatingLocation())) {
                    getEditedEntity().setEmployeeProfile(employeeProfile);
                }else{
                    getEditedEntity().setEmployeeProfile(null);
                    notifications.create("Sorry, this employee is not belonging to the selected operating location")
                            .withType(Notifications.Type.ERROR)
                            .withDuration(3000)
                            .withCloseable(false)
                            .withPosition(Notification.Position.MIDDLE)
                            .show();
                }
            } else {
                employeeCodeField.setValue("");
                notifications.create("Invalid employee code")
                        .withType(Notifications.Type.ERROR)
                        .withDuration(3000)
                        .withCloseable(false)
                        .withPosition(Notification.Position.MIDDLE)
                        .show();
            }
        }else{
            notifications.create("Please select the Operating location first")
                    .withDuration(3000)
                    .withCloseable(false)
                    .withPosition(Notification.Position.TOP_CENTER)
                    .withType(Notifications.Type.WARNING)
                    .show();
        }
    }
}