package com.qianwen.mdc.collect.cache;
|
|
import java.time.Duration;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Objects;
|
import java.util.Optional;
|
import java.util.Set;
|
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
//import com.qianwen.core.redis.cache.BladeRedis;
|
import com.qianwen.mdc.collect.dto.WorkstationDTO;
|
import com.qianwen.mdc.collect.entity.mgr.EmployeeOnOffWork;
|
import com.qianwen.mdc.collect.entity.mgr.GlobalWcsOfRps;
|
import com.qianwen.mdc.collect.entity.mgr.Workstation;
|
import com.qianwen.mdc.collect.mapper.mgr.EmployeeOnOffWorkMapper;
|
import com.qianwen.mdc.collect.mapper.mgr.GlobalWcsOfRpsMapper;
|
import com.qianwen.mdc.collect.service.WorkstationService;
|
import com.qianwen.mdc.collect.utils.redis.RedisUtil;
|
import cn.hutool.core.util.ObjectUtil;
|
|
@Component
|
public class WorkstationCache {
|
private static final String WORKSTATION_ID = "workstation:id:";
|
private static final String CALENDAR_DATE = ":calendar:date:";
|
private static final String WORKSTATION_ALL = "workstation:all";
|
private static final String WCS_SETTING = ":wcsSetting";
|
private static final String EMPLOYEE = ":employee";
|
@Autowired
|
private RedisUtil redisUtil;
|
private static final Logger log = LoggerFactory.getLogger(WorkstationCache.class);
|
//private static final BladeRedis bladeRedis = (BladeRedis) SpringUtil.getBean(BladeRedis.class);
|
//private static final IWorkstationService workStationService = (IWorkstationService) SpringUtil.getBean(IWorkstationService.class);
|
@Autowired
|
private GlobalWcsOfRpsMapper globalWcsOfRpsMapper;
|
@Autowired
|
private WorkstationService workstationService;
|
@Autowired
|
private EmployeeOnOffWorkMapper employeeOnOffWorkMapper;
|
|
//private static final EmployeeOnOffWorkMapper employeeOnOffWorkMapper = (EmployeeOnOffWorkMapper) SpringUtil.getBean(EmployeeOnOffWorkMapper.class);
|
|
|
|
public Map<Long, WorkstationDTO> getWorkstations() {
|
String redisKey = "posting:workstation".concat("::").concat(WORKSTATION_ALL);
|
/*Map<String, WorkstationDTO> map = bladeRedis.hGetAll(redisKey);
|
|
|
if (Func.isEmpty(map)) {
|
map = setWorkStations();
|
}
|
return map;
|
*/
|
Map<Long, WorkstationDTO> map = convertMap(redisUtil.hmget(redisKey));
|
|
if (ObjectUtil.isEmpty(map)) {
|
map = setWorkstations();
|
}
|
|
return map;
|
|
}
|
|
private Map<Long, WorkstationDTO> setWorkstations() {
|
List<Workstation> list = workstationService.list();
|
String redisKey = "posting:workstation".concat("::").concat(WORKSTATION_ALL);
|
|
list.forEach(ws -> {
|
/*
|
WorkStationDTO workStationDTO = WorkstationConvert.INSTANCE.convertDTO(workStation);
|
bladeRedis.hSet(redisKey, workStation.getId(), workStationDTO);
|
*/
|
WorkstationDTO dto = new WorkstationDTO();
|
dto.setCalendarCode(ws.getCalendarCode());
|
dto.setCode(ws.getCode());
|
dto.setId(ws.getId());
|
dto.setName(ws.getName());
|
redisUtil.hset(redisKey, ws.getId(), dto);
|
});
|
|
//bladeRedis.expire(redisKey, 259200L);
|
redisUtil.expire(redisKey, 259200L);
|
//return bladeRedis.hGetAll(redisKey);
|
|
return convertMap(redisUtil.hmget(redisKey));
|
}
|
|
static <K,V> Map<K,V> convertMap(Map<?,?> map){
|
Map<K,V> result = new HashMap<>();
|
for(Map.Entry<?,?> entry : map.entrySet()) {
|
result.put((K)entry.getKey(), (V)entry.getValue());
|
}
|
return result;
|
}
|
/*
|
public static Boolean clearWorkStationCache() {
|
String redisKey = "posting:workstation".concat("::").concat(WORKSTATION_ALL);
|
return bladeRedis.del(redisKey);
|
}
|
*/
|
/**
|
* 获取指定日期的日历代码
|
* @param workstationId
|
* @param date
|
* @return
|
*/
|
public String getWorkstationCalendarCodeForDate(Long workstationId, String date) {
|
String redisKey = "posting:workstation".concat("::").concat(WORKSTATION_ID).concat(workstationId.toString().concat(CALENDAR_DATE)).concat(date);
|
//String calendarCode = (String) bladeRedis.get(redisKey);
|
String calendarCode = (String) redisUtil.get(redisKey);
|
if (ObjectUtil.isEmpty(calendarCode)) {
|
log.warn("获取工位{}指定日期{}日历缓存不存在,从数据库内获取并生成缓存", workstationId, date);
|
Optional.ofNullable(workstationService.getById(workstationId)).ifPresent(workStation -> {
|
//bladeRedis.setEx(redisKey, workStation.getCalendarCode(), 259200L);
|
redisUtil.set(redisKey, workStation.getCalendarCode(), 259200L);
|
});
|
}
|
|
//return (String) bladeRedis.get(redisKey);
|
return calendarCode;
|
}
|
|
public GlobalWcsOfRps getWorkstationWcsSetting(Long workstationId, String code) {
|
String redisKey = "posting:workstation".concat("::").concat(WORKSTATION_ID).concat(workstationId.toString()
|
.concat(WCS_SETTING));
|
|
//GlobalWcsOfRps wcsSetting = (GlobalWcsOfRps)redisUtil.hGet(redisKey, code);
|
GlobalWcsOfRps wcsSetting = (GlobalWcsOfRps)redisUtil.hget(redisKey, code);
|
if (wcsSetting == null) {
|
wcsSetting = globalWcsOfRpsMapper.selectOne(Wrappers.<GlobalWcsOfRps>lambdaQuery()
|
.eq(GlobalWcsOfRps::getCode, code)
|
.isNull(GlobalWcsOfRps::getPrecondition));
|
if(wcsSetting == null) {
|
wcsSetting = new GlobalWcsOfRps();
|
wcsSetting.setRps(0);
|
wcsSetting.setIsPlan(GlobalWcsOfRps.IN_PLAN);
|
}
|
//wcsSetting = Func.isNotEmpty(wcsSetting) ? wcsSetting : GlobalWcsOfRps.builder().rps(0).isPlan(0).build();
|
//bladeRedis.hSet(redisKey, code, wcsSetting);
|
//bladeRedis.expire(redisKey, Duration.ofDays(1L));
|
redisUtil.hset(redisKey, code, wcsSetting, Duration.ofDays(1L).getSeconds());
|
}
|
return wcsSetting;
|
}
|
|
/**
|
* 获取工位在指定时间的上班员工
|
* @param workstationId
|
* @param timePoint
|
* @return
|
*/
|
public Long getBelongToEmployeeForWorkstation(Long workstationId, Date timePoint) {
|
Long employeeId = null;
|
String redisKey = "posting:workstation".concat("::").concat("workstation:id:")
|
.concat(workstationId.toString().concat(EMPLOYEE));
|
// Set<EmployeeOnOffWork> employeeOnOffWorks = bladeRedis.sMembers(redisKey);
|
|
Set<EmployeeOnOffWork> employeeOnOffWorks = (Set<EmployeeOnOffWork>) redisUtil.sGet(redisKey);
|
EmployeeOnOffWork matchEmployee = null;
|
if (ObjectUtil.isNotEmpty(employeeOnOffWorks)) {
|
matchEmployee = employeeOnOffWorks.stream().filter(
|
item -> (item.getOnlineTime().getTime() <= timePoint.getTime() && (item.getOfflineTime() == null
|
|| item.getOfflineTime().getTime() > timePoint.getTime())))
|
.findFirst().orElse(null);
|
}
|
if (ObjectUtil.isNotEmpty(matchEmployee)) {
|
employeeId = matchEmployee.getOnEmployeeId();
|
} else {
|
List<EmployeeOnOffWork> queryResult = employeeOnOffWorkMapper.selectList(
|
Wrappers.<EmployeeOnOffWork>lambdaQuery().eq(EmployeeOnOffWork::getWorkstationId, workstationId)
|
.le(EmployeeOnOffWork::getOnlineTime, timePoint)
|
.and(wrapper -> wrapper.gt(EmployeeOnOffWork::getOfflineTime, timePoint).or()
|
.isNull(EmployeeOnOffWork::getOfflineTime)));
|
if (ObjectUtil.isNotEmpty(queryResult)) {
|
employeeId = ((EmployeeOnOffWork) queryResult.get(0)).getOnEmployeeId();
|
//bladeRedis.sAdd(redisKey, new Object[] { queryResult.get(0) });
|
//bladeRedis.expire(redisKey, 259200L);
|
redisUtil.sSetAndTime(redisKey, 259200L, new Object[] { queryResult.get(0) });
|
}
|
}
|
return employeeId;
|
}
|
}
|
