package com.ruoyi.lims.controller;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.CollectionUtils;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ruoyi.common.utils.SecurityUtils;
|
import com.ruoyi.framework.web.domain.AjaxResult;
|
import com.ruoyi.lims.pojo.Sample;
|
import com.ruoyi.lims.pojo.SampleStatusLog;
|
import com.ruoyi.lims.pojo.SampleStockRecord;
|
import com.ruoyi.lims.service.SampleService;
|
import com.ruoyi.lims.service.SampleStatusLogService;
|
import com.ruoyi.lims.service.SampleStockRecordService;
|
import io.swagger.annotations.Api;
|
import io.swagger.annotations.ApiOperation;
|
import lombok.AllArgsConstructor;
|
import org.springframework.web.bind.annotation.*;
|
|
import java.math.BigDecimal;
|
import java.time.LocalDateTime;
|
import java.util.LinkedHashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
@RestController
|
@AllArgsConstructor
|
@RequestMapping("/lims/sample")
|
@Api(value = "Sample", tags = "样品管理表")
|
public class SampleController {
|
|
private SampleService sampleservice;
|
private SampleStockRecordService stockRecordService;
|
private SampleStatusLogService statusLogService;
|
|
private static final String ST_IN_STOCK = "inStock";
|
private static final String ST_OUT_STOCK = "outStock";
|
private static final String ST_TESTING = "testing";
|
private static final String ST_DESTROYED = "destroyed";
|
|
@GetMapping("/listPage")
|
@ApiOperation("分页查询所有样品管理表")
|
public AjaxResult listPage(Page<Sample> page, Sample sample) {
|
IPage<Sample> listPage = sampleservice.listPage(page, sample);
|
return AjaxResult.success(listPage);
|
}
|
|
@GetMapping("/{id}")
|
@ApiOperation("根据ID查询样品管理表")
|
public AjaxResult getSample(@PathVariable Long id) {
|
return AjaxResult.success(sampleservice.getById(id));
|
}
|
|
/**
|
* 样品详情:样品本体 + 出入库流水 + 状态变更历史
|
*/
|
@GetMapping("/detail/{id}")
|
@ApiOperation("样品详情(含出入库流水与状态变更历史)")
|
public AjaxResult detail(@PathVariable Long id) {
|
Sample sample = sampleservice.getById(id);
|
if (sample == null) {
|
return AjaxResult.error("样品不存在");
|
}
|
|
QueryWrapper<SampleStockRecord> rw = new QueryWrapper<>();
|
rw.eq("sample_id", id).orderByDesc("operate_time").orderByDesc("id");
|
List<SampleStockRecord> records = stockRecordService.list(rw);
|
|
QueryWrapper<SampleStatusLog> sw = new QueryWrapper<>();
|
sw.eq("sample_id", id).orderByDesc("operate_time").orderByDesc("id");
|
List<SampleStatusLog> logs = statusLogService.list(sw);
|
|
Map<String, Object> result = new LinkedHashMap<>();
|
result.put("sample", sample);
|
result.put("stockRecords", records);
|
result.put("statusLogs", logs);
|
return AjaxResult.success(result);
|
}
|
|
@PostMapping("/add")
|
@ApiOperation("新增样品管理表")
|
public AjaxResult add(@RequestBody Sample sample) {
|
boolean ok = sampleservice.save(sample);
|
// 新建样品默认视为一次入库,补一条流水,方便追溯
|
if (ok && sample.getId() != null) {
|
SampleStockRecord rec = new SampleStockRecord();
|
rec.setSampleId(sample.getId());
|
rec.setSampleCode(sample.getSampleCode());
|
rec.setSampleName(sample.getSampleName());
|
rec.setRecordType("in");
|
rec.setQuantity(sample.getQuantity());
|
rec.setUnit(sample.getUnit());
|
rec.setAfterStatus(sample.getSampleStatus());
|
rec.setToLocation(sample.getStorageLocation());
|
rec.setOperator(currentUser());
|
rec.setOperateTime(LocalDateTime.now());
|
rec.setPurpose("样品登记入库");
|
stockRecordService.save(rec);
|
}
|
return AjaxResult.success(ok);
|
}
|
|
@PostMapping("/update")
|
@ApiOperation("修改样品管理表")
|
public AjaxResult update(@RequestBody Sample sample) {
|
Sample old = sampleservice.getById(sample.getId());
|
boolean ok = sampleservice.updateById(sample);
|
|
// 状态被手工改动时留痕
|
if (ok && old != null && sample.getSampleStatus() != null
|
&& !sample.getSampleStatus().equals(old.getSampleStatus())) {
|
SampleStatusLog log = new SampleStatusLog();
|
log.setSampleId(sample.getId());
|
log.setSampleCode(old.getSampleCode());
|
log.setFromStatus(old.getSampleStatus());
|
log.setToStatus(sample.getSampleStatus());
|
log.setChangeReason("表单修改");
|
log.setOperator(currentUser());
|
log.setOperateTime(LocalDateTime.now());
|
statusLogService.save(log);
|
}
|
return AjaxResult.success(ok);
|
}
|
|
@DeleteMapping("/delete")
|
@ApiOperation("删除样品管理表")
|
public AjaxResult delete(@RequestBody List<Long> ids) {
|
if (CollectionUtils.isEmpty(ids)) return AjaxResult.error("请传入要删除的ID");
|
return AjaxResult.success(sampleservice.removeBatchByIds(ids));
|
}
|
|
/**
|
* 样品出库:校验状态与数量 -> 写流水 -> 写状态历史 -> 更新样品状态
|
*/
|
@PostMapping("/outStock")
|
@ApiOperation("样品出库")
|
public AjaxResult outStock(@RequestBody Map<String, Object> body) {
|
Long sampleId = toLong(body.get("sampleId"));
|
if (sampleId == null) {
|
return AjaxResult.error("sampleId 不能为空");
|
}
|
Sample sample = sampleservice.getById(sampleId);
|
if (sample == null) {
|
return AjaxResult.error("样品不存在");
|
}
|
if (ST_DESTROYED.equals(sample.getSampleStatus())) {
|
return AjaxResult.error("样品已销毁,不能出库");
|
}
|
if (ST_OUT_STOCK.equals(sample.getSampleStatus())) {
|
return AjaxResult.error("样品已是出库状态,无需重复出库");
|
}
|
|
BigDecimal qty = toDecimal(body.get("quantity"));
|
if (qty == null || qty.compareTo(BigDecimal.ZERO) <= 0) {
|
return AjaxResult.error("出库数量必须大于 0");
|
}
|
BigDecimal stock = sample.getQuantity() == null ? BigDecimal.ZERO : sample.getQuantity();
|
if (qty.compareTo(stock) > 0) {
|
return AjaxResult.error("出库数量超过当前库存(现有 " + stock.stripTrailingZeros().toPlainString()
|
+ (sample.getUnit() == null ? "" : sample.getUnit()) + ")");
|
}
|
|
String beforeStatus = sample.getSampleStatus();
|
BigDecimal afterQty = stock.subtract(qty);
|
// 全部出库则置为出库状态,部分出库保持原状态
|
String afterStatus = afterQty.compareTo(BigDecimal.ZERO) == 0 ? ST_OUT_STOCK : beforeStatus;
|
|
SampleStockRecord rec = new SampleStockRecord();
|
rec.setSampleId(sample.getId());
|
rec.setSampleCode(sample.getSampleCode());
|
rec.setSampleName(sample.getSampleName());
|
rec.setRecordType("out");
|
rec.setQuantity(qty);
|
rec.setUnit(sample.getUnit());
|
rec.setBeforeStatus(beforeStatus);
|
rec.setAfterStatus(afterStatus);
|
rec.setFromLocation(sample.getStorageLocation());
|
rec.setToLocation(str(body.get("toLocation")));
|
rec.setRecipient(str(body.get("recipient")));
|
rec.setPurpose(str(body.get("purpose")));
|
rec.setRelatedExperiment(str(body.get("relatedExperiment")));
|
rec.setRemark(str(body.get("remark")));
|
rec.setOperator(currentUser());
|
rec.setOperateTime(LocalDateTime.now());
|
stockRecordService.save(rec);
|
|
if (!eq(beforeStatus, afterStatus)) {
|
SampleStatusLog log = new SampleStatusLog();
|
log.setSampleId(sample.getId());
|
log.setSampleCode(sample.getSampleCode());
|
log.setFromStatus(beforeStatus);
|
log.setToStatus(afterStatus);
|
log.setChangeReason("出库" + (str(body.get("purpose")) == null ? "" : ":" + str(body.get("purpose"))));
|
log.setOperator(currentUser());
|
log.setOperateTime(LocalDateTime.now());
|
statusLogService.save(log);
|
}
|
|
Sample upd = new Sample();
|
upd.setId(sample.getId());
|
upd.setQuantity(afterQty);
|
upd.setSampleStatus(afterStatus);
|
if (str(body.get("toLocation")) != null) {
|
upd.setStorageLocation(str(body.get("toLocation")));
|
}
|
sampleservice.updateById(upd);
|
|
Map<String, Object> ret = new LinkedHashMap<>();
|
ret.put("sampleId", sample.getId());
|
ret.put("beforeQuantity", stock);
|
ret.put("afterQuantity", afterQty);
|
ret.put("beforeStatus", beforeStatus);
|
ret.put("afterStatus", afterStatus);
|
return AjaxResult.success("出库成功", ret);
|
}
|
|
/**
|
* 样品入库(追加数量或新建后补录)
|
*/
|
@PostMapping("/inStock")
|
@ApiOperation("样品入库")
|
public AjaxResult inStock(@RequestBody Map<String, Object> body) {
|
Long sampleId = toLong(body.get("sampleId"));
|
if (sampleId == null) {
|
return AjaxResult.error("sampleId 不能为空");
|
}
|
Sample sample = sampleservice.getById(sampleId);
|
if (sample == null) {
|
return AjaxResult.error("样品不存在");
|
}
|
BigDecimal qty = toDecimal(body.get("quantity"));
|
if (qty == null || qty.compareTo(BigDecimal.ZERO) <= 0) {
|
return AjaxResult.error("入库数量必须大于 0");
|
}
|
|
String beforeStatus = sample.getSampleStatus();
|
BigDecimal stock = sample.getQuantity() == null ? BigDecimal.ZERO : sample.getQuantity();
|
BigDecimal afterQty = stock.add(qty);
|
String afterStatus = ST_OUT_STOCK.equals(beforeStatus) ? ST_IN_STOCK : beforeStatus;
|
|
SampleStockRecord rec = new SampleStockRecord();
|
rec.setSampleId(sample.getId());
|
rec.setSampleCode(sample.getSampleCode());
|
rec.setSampleName(sample.getSampleName());
|
rec.setRecordType("in");
|
rec.setQuantity(qty);
|
rec.setUnit(sample.getUnit());
|
rec.setBeforeStatus(beforeStatus);
|
rec.setAfterStatus(afterStatus);
|
rec.setToLocation(str(body.get("toLocation")) == null ? sample.getStorageLocation() : str(body.get("toLocation")));
|
rec.setRecipient(str(body.get("recipient")));
|
rec.setPurpose(str(body.get("purpose")) == null ? "样品入库" : str(body.get("purpose")));
|
rec.setRemark(str(body.get("remark")));
|
rec.setOperator(currentUser());
|
rec.setOperateTime(LocalDateTime.now());
|
stockRecordService.save(rec);
|
|
if (!eq(beforeStatus, afterStatus)) {
|
SampleStatusLog log = new SampleStatusLog();
|
log.setSampleId(sample.getId());
|
log.setSampleCode(sample.getSampleCode());
|
log.setFromStatus(beforeStatus);
|
log.setToStatus(afterStatus);
|
log.setChangeReason("入库");
|
log.setOperator(currentUser());
|
log.setOperateTime(LocalDateTime.now());
|
statusLogService.save(log);
|
}
|
|
Sample upd = new Sample();
|
upd.setId(sample.getId());
|
upd.setQuantity(afterQty);
|
upd.setSampleStatus(afterStatus);
|
if (str(body.get("toLocation")) != null) {
|
upd.setStorageLocation(str(body.get("toLocation")));
|
}
|
sampleservice.updateById(upd);
|
|
Map<String, Object> ret = new LinkedHashMap<>();
|
ret.put("sampleId", sample.getId());
|
ret.put("beforeQuantity", stock);
|
ret.put("afterQuantity", afterQty);
|
ret.put("beforeStatus", beforeStatus);
|
ret.put("afterStatus", afterStatus);
|
return AjaxResult.success("入库成功", ret);
|
}
|
|
/**
|
* 样品状态流转(在库/检测中/出库/销毁)
|
*/
|
@PostMapping("/changeStatus")
|
@ApiOperation("样品状态流转")
|
public AjaxResult changeStatus(@RequestBody Map<String, Object> body) {
|
Long sampleId = toLong(body.get("sampleId"));
|
String toStatus = str(body.get("toStatus"));
|
if (sampleId == null || toStatus == null) {
|
return AjaxResult.error("sampleId 和 toStatus 不能为空");
|
}
|
Sample sample = sampleservice.getById(sampleId);
|
if (sample == null) {
|
return AjaxResult.error("样品不存在");
|
}
|
String fromStatus = sample.getSampleStatus();
|
if (eq(fromStatus, toStatus)) {
|
return AjaxResult.error("样品已处于该状态");
|
}
|
|
SampleStatusLog log = new SampleStatusLog();
|
log.setSampleId(sample.getId());
|
log.setSampleCode(sample.getSampleCode());
|
log.setFromStatus(fromStatus);
|
log.setToStatus(toStatus);
|
log.setChangeReason(str(body.get("changeReason")));
|
log.setOperator(currentUser());
|
log.setOperateTime(LocalDateTime.now());
|
statusLogService.save(log);
|
|
Sample upd = new Sample();
|
upd.setId(sample.getId());
|
upd.setSampleStatus(toStatus);
|
sampleservice.updateById(upd);
|
|
return AjaxResult.success("状态已更新");
|
}
|
|
/* ---------------- helpers ---------------- */
|
|
private String currentUser() {
|
try {
|
return SecurityUtils.getUsername();
|
} catch (Exception e) {
|
return "system";
|
}
|
}
|
|
private static String str(Object v) {
|
if (v == null) return null;
|
String s = String.valueOf(v).trim();
|
return s.isEmpty() ? null : s;
|
}
|
|
private static Long toLong(Object v) {
|
if (v == null) return null;
|
try {
|
return Long.valueOf(String.valueOf(v).trim());
|
} catch (NumberFormatException e) {
|
return null;
|
}
|
}
|
|
private static BigDecimal toDecimal(Object v) {
|
if (v == null) return null;
|
try {
|
return new BigDecimal(String.valueOf(v).trim());
|
} catch (NumberFormatException e) {
|
return null;
|
}
|
}
|
|
private static boolean eq(String a, String b) {
|
return a == null ? b == null : a.equals(b);
|
}
|
}
|