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 page, Sample sample) { IPage 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 rw = new QueryWrapper<>(); rw.eq("sample_id", id).orderByDesc("operate_time").orderByDesc("id"); List records = stockRecordService.list(rw); QueryWrapper sw = new QueryWrapper<>(); sw.eq("sample_id", id).orderByDesc("operate_time").orderByDesc("id"); List logs = statusLogService.list(sw); Map 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 ids) { if (CollectionUtils.isEmpty(ids)) return AjaxResult.error("请传入要删除的ID"); return AjaxResult.success(sampleservice.removeBatchByIds(ids)); } /** * 样品出库:校验状态与数量 -> 写流水 -> 写状态历史 -> 更新样品状态 */ @PostMapping("/outStock") @ApiOperation("样品出库") public AjaxResult outStock(@RequestBody Map 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 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 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 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 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); } }