package com.bofeng.service; import com.baomidou.mybatisplus.toolkit.IdWorker; import com.bofeng.dao.QzTaskDao; import com.bofeng.dao.YeweihuiSysOwnerMapper; import com.bofeng.dao.YeweihuiUserRoleMapper; import com.bofeng.entity.QzTask; import lombok.var; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Propagation; import org.springframework.transaction.annotation.Transactional; import java.util.Date; import java.util.List; @Service @Transactional(readOnly = true) public class QzTaskService { @Autowired private QzTaskDao qzTaskDao; @Autowired private YeweihuiUserRoleMapper yeweihuiUserRoleMapper; @Autowired private YeweihuiSysOwnerMapper yeweihuiSysOwnerMapper; public List selectAll(Long userId) { Long propertyId = yeweihuiUserRoleMapper.queryPropertyIdByUserId(userId); Long uptownId = yeweihuiSysOwnerMapper.queryUptownIdByUserId(propertyId); return qzTaskDao.selectAll(uptownId); } public List queryByHouseNumber(Long userId, String houseNumber, Integer status) { Long propertyId = yeweihuiUserRoleMapper.queryPropertyIdByUserId(userId); Long uptownId = yeweihuiSysOwnerMapper.queryUptownIdByUserId(propertyId); return qzTaskDao.queryByHouseNumber(uptownId, houseNumber, status); } public QzTask queryByTaskId(Long taskId) { return qzTaskDao.queryByTaskId(taskId); } //求助的新增 @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED) public int addHelp(String taskTitle, String taskTarget, String remark, Long userId) { var qzTak = new QzTask(); qzTak.setTaskId(IdWorker.getId()); qzTak.setTaskTitle(taskTitle); qzTak.setRemark(remark); qzTak.setTaskTarget(taskTarget); qzTak.setTaskStatus(1); qzTak.setUserId(userId); //当前用户名称 qzTak.setUserName(qzTaskDao.selectUserName(userId).getUserName()); //当前用户的门牌id 门牌号 QzTask qzTask1 = qzTaskDao.selectHome(userId); qzTak.setHouseId(qzTask1.getHouseId()); //获取当前小区id qzTak.setUptownId(qzTask1.getUptownId()); qzTak.setHouseNumber(qzTask1.getHouseNumber()); qzTak.setUserCreate(userId); qzTak.setTimeCreate(new Date()); qzTak.setUserUpdate(userId); qzTak.setTimeUpdate(new Date()); return qzTaskDao.insert(qzTak); } public List queryQzTaskByStatus(Long userId, Integer taskStatus) { Long propertyId = yeweihuiUserRoleMapper.queryPropertyIdByUserId(userId); Long uptownId = yeweihuiSysOwnerMapper.queryUptownIdByUserId(propertyId); return qzTaskDao.queryQzTaskByStatus(uptownId, taskStatus); } public List queryQzTask(Integer taskStatus, String taskTitle, Long userId) { return qzTaskDao.queryQzTask(taskStatus, taskTitle, userId); } public List queryQzTaskxq(Long userId,String taskTitle) { return qzTaskDao.queryQzTaskxq(userId,taskTitle); } @Transactional(rollbackFor = Exception.class, propagation = Propagation.REQUIRED) public int taskQueryTaskId(Long taskId) { return qzTaskDao.updateStatusById(taskId, 3);//求助完成 } }