/* * Copyright (c) 2018-2028, Chill Zhuang All rights reserved. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright notice, * this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * Neither the name of the dreamlu.net developer nor the names of its * contributors may be used to endorse or promote products derived from * this software without specific prior written permission. * Author: Chill 庄骞 (smallchill@163.com) */ package org.springblade.modules.soldr.controller; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiParam; import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; import lombok.AllArgsConstructor; import javax.validation.Valid; import org.springblade.core.mp.support.Condition; import org.springblade.core.mp.support.Query; import org.springblade.core.tool.api.R; import org.springblade.core.tool.utils.Func; import org.springblade.modules.soldr.vo.SoldrVOs; import org.springblade.modules.soldrecord.entity.Soldrecord; import org.springblade.modules.soldrecord.service.ISoldrecordService; import org.springblade.modules.stock.entity.Stock; import org.springblade.modules.stock.service.IStockService; import org.springblade.modules.stockrecord.entity.Stockrecord; import org.springblade.modules.stockrecord.service.IStockrecordService; import org.springframework.web.bind.annotation.*; import org.springframework.web.bind.annotation.RequestParam; import com.baomidou.mybatisplus.core.metadata.IPage; import org.springblade.modules.soldr.entity.Soldr; import org.springblade.modules.soldr.vo.SoldrVO; import org.springblade.modules.soldr.service.ISoldrService; import org.springblade.core.boot.ctrl.BladeController; import java.util.*; /** * 已出库存数量记录表 控制器 * * @author BladeX * @since 2022-05-27 */ @RestController @AllArgsConstructor @RequestMapping("/soldr/soldr") @Api(value = "已出库存数量记录表", tags = "已出库存数量记录表接口") public class SoldrController extends BladeController { private final ISoldrService soldrService; private final ISoldrecordService soldrecordService; private final IStockService stockService; private final IStockrecordService stockrecordService; /** * 详情 */ @GetMapping("/detail") @ApiOperationSupport(order = 1) @ApiOperation(value = "详情", notes = "传入soldr") public R detail(Soldr soldr) { Soldr detail = soldrService.getOne(Condition.getQueryWrapper(soldr)); return R.data(detail); } /** * 分页 已出库存数量记录表 */ @GetMapping("/list") @ApiOperationSupport(order = 2) @ApiOperation(value = "分页", notes = "传入soldr") public R> list(Soldr soldr, Query query) { IPage pages = soldrService.page(Condition.getPage(query), Condition.getQueryWrapper(soldr)); return R.data(pages); } /** * 自定义分页 已出库存数量记录表 */ @GetMapping("/page") @ApiOperationSupport(order = 3) @ApiOperation(value = "分页", notes = "传入soldr") public R> page(SoldrVO soldr, Query query) { IPage pages = soldrService.selectLists(Condition.getPage(query), soldr); for (int i = 0; i < pages.getRecords().size(); i++) { String specs = pages.getRecords().get(i).getSpecs1(); Integer amount = pages.getRecords().get(i).getAmount1(); Integer num = Integer.parseInt(specs); String dic1 = pages.getRecords().get(i).getDic1(); String dic2 = pages.getRecords().get(i).getDic2(); String s = specs + dic1 + "/" + dic2; pages.getRecords().get(i).setSpn(s); pages.getRecords().get(i).setCnum(num * amount); } return R.data(pages); } /** * 新增 已出库存数量记录表 */ @PostMapping("/save") @ApiOperationSupport(order = 4) @ApiOperation(value = "新增", notes = "传入soldr") public R save(@Valid @RequestBody Soldr soldr) { return R.status(soldrService.save(soldr)); } /** * 修改 已出库存数量记录表 */ @PostMapping("/update") @ApiOperationSupport(order = 5) @ApiOperation(value = "修改", notes = "传入soldr") public R update(@Valid @RequestBody Soldr soldr) { return R.status(soldrService.updateById(soldr)); } /** * 新增或修改 已出库存数量记录表 */ @PostMapping("/submit") @ApiOperationSupport(order = 6) @ApiOperation(value = "新增或修改", notes = "传入soldr") public R submit(@Valid @RequestBody Soldr soldr) { return R.status(soldrService.saveOrUpdate(soldr)); } /** * 删除 已出库存数量记录表 */ @PostMapping("/remove") @ApiOperationSupport(order = 7) @ApiOperation(value = "逻辑删除", notes = "传入ids") public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) { return R.status(soldrService.deleteLogic(Func.toLongList(ids))); } /** * 退回 * @param num 数量 * @param id 农资id * @param type * @return */ @PostMapping("/out") public R out(Integer num, Long id, Integer type,Long createUser,Long createDept) { double census1 = 0; //如果等于就修改并删除 if (type == 0) {//退回数量等于库存数量 Soldr soldr = new Soldr(); soldr.setSid(id); //通过农资库存id找到已出库农资表中对应的农资 Soldr detail = soldrService.getOne(Condition.getQueryWrapper(soldr)); census1 = detail.getCensus(); Stock stock = new Stock(); stock.setId(id); Stock detail1 = stockService.getOne(Condition.getQueryWrapper(stock)); Integer amount = detail1.getAmount(); stock.setAmount(amount + num); stock.setState("0"); stockService.Updaet(stock); //删除 soldrService.del(id); } //如果小于就修改 else {//退回数量小于库存数量 Soldr soldr = new Soldr(); soldr.setSid(id); //通过农资库存id找到已出库农资表中对应的农资 Soldr detail = soldrService.getOne(Condition.getQueryWrapper(soldr)); Integer amount1 = detail.getAmount1(); Double census = detail.getCensus(); //统计公斤 Integer specsValue1 = detail.getSpecsVal1(); double v = 0; //克 if (specsValue1 == 0) { v = num * 0.001; } //斤 else if (specsValue1 == 1) { v = num * 0.5; } //公斤 else if (specsValue1 == 2) { v = num; } //吨 else if (specsValue1 == 3) { v = num * 1000; } //毫升 else if (specsValue1 == 4) { //毫升换成升 double s = num * 0.001; //升换成公斤 v = s; } //升 else{ v = num; } census1 = v; //更新已出库农资的数据 soldrecordService.updateSold(amount1 - num, id,census-v); Stock stock = new Stock(); stock.setId(id); //根据传过来的sid获取对应的库存表数据 Stock detail1 = stockService.getOne(Condition.getQueryWrapper(stock)); Integer amount = detail1.getAmount(); stock.setAmount(amount + num); stock.setState("0"); //更新库存表 stockService.Updaet(stock); } Stock stock = new Stock(); stock.setId(id); Stock detail1 = stockService.getOne(Condition.getQueryWrapper(stock)); //更新已出库待使用农资记录表 Soldrecord soldrecord = new Soldrecord(); soldrecord.setAmount1(num); soldrecord.setSid(detail1.getId()); soldrecord.setSpecs1(detail1.getSpecs()); soldrecord.setSpecsVal1(detail1.getSpecsValue1()); soldrecord.setSpecsVal2(detail1.getSpecsValue2()); soldrecord.setType("4"); soldrecord.setStockId1(detail1.getStockId()); soldrecord.setIsDeleted(0); soldrecord.setStatus(1); soldrecord.setCreateTime(new Date()); soldrecord.setUpdateTime(new Date()); soldrecord.setCreateUser(createUser); soldrecord.setCreateDept(createDept); soldrecord.setUpdateUser(createUser); soldrecordService.save(soldrecord); //更新出入库记录表 Stockrecord stockrecord = new Stockrecord(); stockrecord.setAmount1(num); stockrecord.setCensus(census1); stockrecord.setDeptId(detail1.getDeptId()); stockrecord.setSid(detail1.getId()); stockrecord.setStockId1(detail1.getStockId()); stockrecord.setTime1(new Date()); stockrecord.setType1(soldrecord.getType());//入库类型? stockrecord.setSpecs1(detail1.getSpecs()); stockrecord.setSpecsVal1(detail1.getSpecsValue1()); stockrecord.setSpecsVal2(detail1.getSpecsValue2()); stockrecord.setCreateUser(createUser); stockrecord.setCreateDept(createDept); stockrecord.setCreateTime(new Date()); // stockrecord.setUpdateUser(); stockrecord.setStatus(1); stockrecord.setIsDeleted(0); stockrecord.setStockType1(0); stockrecord.setSrId(soldrecord.getId()); stockrecordService.save(stockrecord); return R.success("退回成功"); } @GetMapping("/outs") public R outs(SoldrVOs soldrVOs) { //如果等于就修改并删除 if (soldrVOs.getType().equals("0")) { Stock stock = new Stock(); stock.setId(soldrVOs.getId()); Stock detail1 = stockService.getOne(Condition.getQueryWrapper(stock)); Integer amount = detail1.getAmount(); stock.setAmount(amount + soldrVOs.getNum()); stockService.Updaet(stock); //删除 soldrService.del(soldrVOs.getId()); } //如果小于就修改 else { Soldr soldr = new Soldr(); soldr.setSid(soldrVOs.getId()); Soldr detail = soldrService.getOne(Condition.getQueryWrapper(soldr)); Integer amount1 = detail.getAmount1(); Double census = detail.getCensus(); //统计公斤 Integer specsValue1 = detail.getSpecsVal1(); double v = 0; //克 if (specsValue1 == 0) { v = soldrVOs.getNum() * 0.001; } //斤 if (specsValue1 == 1) { v = soldrVOs.getNum() * 0.5; } //公斤 if (specsValue1 == 2) { v = soldrVOs.getNum(); } //吨 if (specsValue1 == 3) { v = soldrVOs.getNum() * 1000; } //毫升 if (specsValue1 == 4) { //毫升换成升 double s = soldrVOs.getNum() * 0.001; //升换成公斤 v = s; } //升 if (specsValue1 == 5) { v = soldrVOs.getNum(); } soldrecordService.updateSold(amount1 - soldrVOs.getNum(), soldrVOs.getId(),census-v); Stock stock = new Stock(); stock.setId(soldrVOs.getId()); Stock detail1 = stockService.getOne(Condition.getQueryWrapper(stock)); Integer amount = detail1.getAmount(); stock.setAmount(amount + soldrVOs.getNum()); stockService.Updaet(stock); } return R.success("退回成功"); } /** * 已出农资列表 * * @return */ @GetMapping("/selectSol") public R selectSol(String farmId) { List soldrVOS = soldrService.selectSol(farmId); for (int i = 0; i < soldrVOS.size(); i++) { String specs1 = soldrVOS.get(i).getSpecs1(); String dic1 = soldrVOS.get(i).getDic1(); String dic2 = soldrVOS.get(i).getDic2(); String agrname = soldrVOS.get(i).getAgrname(); String s = agrname + specs1 + dic1 + "/" + dic2; soldrVOS.get(i).setSpn(s); } return R.data(soldrVOS); } }