Subversion Repositories SmartDukaan

package com.spice.profitmandi.web.controller;

import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
import com.spice.profitmandi.dao.entity.dtr.EmployeeAttendance;
import com.spice.profitmandi.dao.entity.dtr.HypertrackKey;
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
import com.spice.profitmandi.dao.repository.dtr.EmployeeAttendanceRepository;
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
import com.spice.profitmandi.dao.repository.user.HypertrackKeyRepository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.time.LocalDate;
import java.util.List;

/**
 * Read-only DB lookups used by HyperTrackController for endpoints that combine
 * a DB read + an external HyperTrack API call. By keeping the reads in a separate
 * @Service with @Transactional(readOnly=true), the DB connection is released
 * BEFORE the controller makes its external HTTP call — so a slow HyperTrack
 * response can no longer pin a DB connection.
 */
@Service
public class HyperTrackService {

    @Autowired
    private HypertrackKeyRepository hypertrackKeyRepository;

    @Autowired
    private EmployeeAttendanceRepository employeeAttendanceRepository;

    @Autowired
    private FofoStoreRepository fofoStoreRepository;

    @Transactional(readOnly = true)
    public LocationContext loadLocationContext(int userId, int deviceId) {
        HypertrackKey key = hypertrackKeyRepository.selectByUserIdAndDeviceId(userId, deviceId);
        List<EmployeeAttendance> attendances = employeeAttendanceRepository.selectByUserIdKey(
                userId, deviceId, LocalDate.now());
        return new LocationContext(key, attendances);
    }

    @Transactional(readOnly = true)
    public PartnerLocationContext loadPartnerLocationContext(int userId, int deviceId, int fofoId)
            throws ProfitMandiBusinessException {
        FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoId);
        HypertrackKey key = hypertrackKeyRepository.selectByUserIdAndDeviceId(userId, deviceId);
        return new PartnerLocationContext(fs, key);
    }

    public static final class LocationContext {
        public final HypertrackKey hypertrackKey;
        public final List<EmployeeAttendance> employeeAttendances;
        public LocationContext(HypertrackKey k, List<EmployeeAttendance> a) {
            this.hypertrackKey = k;
            this.employeeAttendances = a;
        }
    }

    public static final class PartnerLocationContext {
        public final FofoStore fofoStore;
        public final HypertrackKey hypertrackKey;
        public PartnerLocationContext(FofoStore fs, HypertrackKey k) {
            this.fofoStore = fs;
            this.hypertrackKey = k;
        }
    }
}