/* * 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.stock.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.stock.vo.StocksVO; import org.springblade.modules.stockrecord.entity.Stockrecord; import org.springblade.modules.stockrecord.service.IStockrecordService; import org.springblade.modules.system.entity.DictBiz; import org.springblade.modules.system.service.IDictBizService; import org.springframework.web.bind.annotation.*; import org.springframework.web.bind.annotation.RequestParam; import com.baomidou.mybatisplus.core.metadata.IPage; import org.springblade.modules.stock.entity.Stock; import org.springblade.modules.stock.vo.StockVO; import org.springblade.modules.stock.service.IStockService; import org.springblade.core.boot.ctrl.BladeController; import java.math.BigDecimal; import java.text.DecimalFormat; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; /** * 农资库存表 控制器 * * @author BladeX * @since 2022-05-11 */ @RestController @AllArgsConstructor @RequestMapping("/stock/stock") @Api(value = "农资库存表", tags = "农资库存表接口") public class StockController extends BladeController { private final IStockService stockService; private final IStockrecordService stockrecordService; /** * 详情 */ @GetMapping("/detail") @ApiOperationSupport(order = 1) @ApiOperation(value = "详情", notes = "传入stock") public R detail(Stock stock) { Stock detail = stockService.getOne(Condition.getQueryWrapper(stock)); return R.data(detail); } /** * 分页 农资库存表 */ @GetMapping("/list") @ApiOperationSupport(order = 2) @ApiOperation(value = "分页", notes = "传入stock") public R> list(Stock stock, Query query) { IPage pages = stockService.page(Condition.getPage(query), Condition.getQueryWrapper(stock)); return R.data(pages); } /** * 自定义分页 农资库存表 */ @GetMapping("/page") @ApiOperationSupport(order = 3) @ApiOperation(value = "分页", notes = "传入stock") public R> page(StockVO stock, Query query) { IPage pages = stockService.selectLists(Condition.getPage(query), stock); for (int i = 0; i < pages.getRecords().size(); i++) { String specs = pages.getRecords().get(i).getSpecs(); Integer amount = pages.getRecords().get(i).getAmount(); 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); } /** * 自定义分页 农资库存表 */ @GetMapping("/pages") @ApiOperationSupport(order = 3) @ApiOperation(value = "分页", notes = "传入stock") public R> pages(StockVO stock) { List pages = stockService.selectListss(stock); for (int i = 0; i < pages.size(); i++) { String specs = pages.get(i).getSpecs(); Integer amount = pages.get(i).getAmount(); Integer num = Integer.parseInt(specs); String dic1 = pages.get(i).getDic1(); String dic2 = pages.get(i).getDic2(); String s = specs + dic1 + "/" + dic2; pages.get(i).setSpn(s); pages.get(i).setCnum(num * amount); } return R.data(pages); } /** * 新增 农资库存表 */ @PostMapping("/save") @ApiOperationSupport(order = 4) @ApiOperation(value = "新增", notes = "传入stock") public R save(@Valid @RequestBody Stock stock) { stock.setState("0"); stock.setSp1("stockSpecs1"); stock.setSp2("stockSpecs2"); boolean save = stockService.save(stock); //农资记录表 Stockrecord stockrecord = new Stockrecord(); //农资ID stockrecord.setSid(stock.getId()); stockrecord.setStockId1(stock.getStockId()); stockrecord.setAmount1(stock.getAmount()); stockrecord.setTime1(stock.getTime()); stockrecord.setType1(stock.getType()); stockrecord.setStockType1(1); stockrecord.setPicture1(stock.getPicture()); stockrecord.setRemarks1(stock.getRemarks()); stockrecord.setSpecs1(stock.getSpecs()); stockrecord.setSpecsVal1(stock.getSpecsValue1()); stockrecord.setSpecsVal2(stock.getSpecsValue2()); stockrecord.setSp1("stockSpecs1"); stockrecord.setSp2("stockSpecs2"); //统计公斤 Integer amount = stock.getAmount(); String specs = stock.getSpecs(); int i = Integer.parseInt(specs); Integer specsValue1 = stock.getSpecsValue1(); double v = 0; //克 if (specsValue1 == 0) { v = amount * i * 0.001; } //斤 if (specsValue1 == 1) { v = amount * i * 0.5; } //公斤 if (specsValue1 == 2) { v = amount * i; } //吨 if (specsValue1 == 3) { v = amount * i * 1000; } //毫升 if (specsValue1 == 4) { //毫升换成升 double s = amount * i * 0.001; //升换成公斤 v = s; } //升 if (specsValue1 == 5) { v = amount * i; } stockrecord.setCensus(v); stockrecordService.save(stockrecord); return R.status(save); } /** * 修改 农资库存表 */ @PostMapping("/update") @ApiOperationSupport(order = 5) @ApiOperation(value = "修改", notes = "传入stock") public R update(@Valid @RequestBody Stock stock) { return R.status(stockService.updateById(stock)); } /** * 新增或修改 农资库存表 */ @PostMapping("/submit") @ApiOperationSupport(order = 6) @ApiOperation(value = "新增或修改", notes = "传入stock") public R submit(@Valid @RequestBody Stock stock) { return R.status(stockService.saveOrUpdate(stock)); } /** * 删除 农资库存表 */ @PostMapping("/remove") @ApiOperationSupport(order = 7) @ApiOperation(value = "逻辑删除", notes = "传入ids") public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) { return R.status(stockService.deleteLogic(Func.toLongList(ids))); } /** * 数据统计 * * @param stock * @param query * @return */ @PostMapping("/pagenum") public R> pagenum(StocksVO stock, Query query) { IPage pages = stockService.slectNum(Condition.getPage(query), stock); for (int i = 0; i < pages.getRecords().size(); i++) { Double cgnum = pages.getRecords().get(i).getCgnum(); Double dbrknum = pages.getRecords().get(i).getDbrknum(); double v = cgnum + dbrknum; pages.getRecords().get(i).setRknum(v); Double lycknum = pages.getRecords().get(i).getLycknum(); Double dbcknum = pages.getRecords().get(i).getDbcknum(); Double bfcknum = pages.getRecords().get(i).getBfcknum(); double v1 = lycknum + dbcknum + bfcknum; pages.getRecords().get(i).setCknum(v1); } return R.data(pages); } /** * 首页农资入库数量统计 * * @return */ @GetMapping("/StockCount") public R StockCount(String detpId) { List> maps = stockService.StockCount(detpId); //化肥0 double hf = 0; //有机肥1 double yjf = 0; //杀虫剂2 double scj = 0; //杀菌剂3 double sjj = 0; //饲料4 double sl = 0; for (int i = 0; i < maps.size(); i++) { //规格 String specs = maps.get(i).get("specs").toString(); Integer specs1 = Integer.parseInt(specs); //数量 String amount = maps.get(i).get("amount").toString(); Integer amount1 = Integer.parseInt(amount); //规格类型 String spe = maps.get(i).get("spe").toString(); //类型 String type = maps.get(i).get("type").toString(); if (type.equals("0")) { //克 if (spe.equals("0")) { hf += amount1 * specs1 * 0.001; } //斤 if (spe.equals("1")) { hf += amount1 * specs1 * 0.5; } //公斤 if (spe.equals("2")) { hf += amount1 * specs1; } //吨 if (spe.equals("3")) { hf += amount1 * specs1 * 1000; } //毫升 if (spe.equals("4")) { //毫升换成升 double s = amount1 * specs1 * 0.001; //升换成公斤 hf += s; } //升 if (spe.equals("5")) { hf += amount1 * specs1; } } if (type.equals("1")) { //克 if (spe.equals("0")) { yjf += amount1 * specs1 * 0.001; } //斤 if (spe.equals("1")) { yjf += amount1 * specs1 * 0.5; } //公斤 if (spe.equals("2")) { yjf += amount1 * specs1; } //吨 if (spe.equals("3")) { yjf += amount1 * specs1 * 1000; } //毫升 if (spe.equals("4")) { //毫升换成升 double s = amount1 * specs1 * 0.001; //升换成公斤 yjf += s; } //升 if (spe.equals("5")) { yjf += amount1 * specs1; } } if (type.equals("2")) { //克 if (spe.equals("0")) { scj += amount1 * specs1 * 0.001; } //斤 if (spe.equals("1")) { scj += amount1 * specs1 * 0.5; } //公斤 if (spe.equals("2")) { scj += amount1 * specs1; } //吨 if (spe.equals("3")) { scj += amount1 * specs1 * 1000; } //毫升 if (spe.equals("4")) { //毫升换成升 double s = amount1 * specs1 * 0.001; //升换成公斤 scj += s; } //升 if (spe.equals("5")) { scj += amount1 * specs1; } } if (type.equals("3")) { //克 if (spe.equals("0")) { sjj += amount1 * specs1 * 0.001; } //斤 if (spe.equals("1")) { sjj += amount1 * specs1 * 0.5; } //公斤 if (spe.equals("2")) { sjj += amount1 * specs1; } //吨 if (spe.equals("3")) { sjj += amount1 * specs1 * 1000; } //毫升 if (spe.equals("4")) { //毫升换成升 double s = amount1 * specs1 * 0.001; //升换成公斤 sjj += s; } //升 if (spe.equals("5")) { sjj += amount1 * specs1; } } if (type.equals("4")) { //克 if (spe.equals("0")) { sl += amount1 * specs1 * 0.001; } //斤 if (spe.equals("1")) { sl += amount1 * specs1 * 0.5; } //公斤 if (spe.equals("2")) { sl += amount1 * specs1; } //吨 if (spe.equals("3")) { sl += amount1 * specs1 * 1000; } //毫升 if (spe.equals("4")) { //毫升换成升 double s = amount1 * specs1 * 0.001; //升换成公斤 sl += s; } //升 if (spe.equals("5")) { sl += amount1 * specs1; } } } Map map = new HashMap(); map.put("name", "化肥"); map.put("val", new BigDecimal(hf).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue()); Map map1 = new HashMap(); map1.put("name", "有机肥"); map1.put("val", new BigDecimal(String.valueOf(yjf)).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue()); Map map2 = new HashMap(); map2.put("name", "杀虫剂"); map2.put("val", new BigDecimal(String.valueOf(scj)).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue()); Map map3 = new HashMap(); map3.put("name", "杀菌剂"); map2.put("val", new BigDecimal(String.valueOf(sjj)).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue()); Map map4 = new HashMap(); map4.put("name", "饲料"); map2.put("val", new BigDecimal(String.valueOf(sl)).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue()); List list = new ArrayList(); list.add(map); list.add(map1); list.add(map2); list.add(map3); list.add(map4); return R.data(list); } /** * 小程序数据统计 * * @return */ @GetMapping("/pagenumx") public R pagenumx(String deptId, String startTime, String endTime) { Double rknu = 0.0; Double cknu = 0.0; List pages = stockService.slectNumx(deptId, startTime, endTime); for (int i = 0; i < pages.size(); i++) { Double cgnum = pages.get(i).getCgnum(); Double dbrknum = pages.get(i).getDbrknum(); double v = cgnum + dbrknum; pages.get(i).setRknum(v); Double lycknum = pages.get(i).getLycknum(); Double dbcknum = pages.get(i).getDbcknum(); Double bfcknum = pages.get(i).getBfcknum(); double v1 = lycknum + dbcknum + bfcknum; pages.get(i).setCknum(v1); } for (int j = 0; j < pages.size(); j++) { Double rknum = pages.get(j).getRknum(); Double cknum = pages.get(j).getCknum(); rknu += rknum; cknu += cknum; } Map map = new HashMap(); DecimalFormat df = new DecimalFormat("#0.000"); String format = df.format(rknu); Double a = Double.parseDouble(format); String format1 = df.format(cknu); double b = Double.parseDouble(format1); map.put("rknum", a); map.put("cknum", b); return R.data(map); } /** * 小程序农资数据统计详情 * * @param stock * @param query * @return */ @GetMapping("/pagenums") public R pagenums(StocksVO stock, Query query) { Double rknu = 0.0; Double cknu = 0.0; IPage pages = stockService.slectNum(Condition.getPage(query), stock); for (int i = 0; i < pages.getRecords().size(); i++) { Double cgnum = pages.getRecords().get(i).getCgnum(); Double dbrknum = pages.getRecords().get(i).getDbrknum(); double v = cgnum + dbrknum; pages.getRecords().get(i).setRknum(v); Double lycknum = pages.getRecords().get(i).getLycknum(); Double dbcknum = pages.getRecords().get(i).getDbcknum(); Double bfcknum = pages.getRecords().get(i).getBfcknum(); double v1 = lycknum + dbcknum + bfcknum; pages.getRecords().get(i).setCknum(v1); } for (int j = 0; j < pages.getRecords().size(); j++) { Double rknum = pages.getRecords().get(j).getRknum(); Double cknum = pages.getRecords().get(j).getCknum(); rknu += rknum; cknu += cknum; } Map map = new HashMap(); DecimalFormat df = new DecimalFormat("#0.000"); String format = df.format(rknu); Double a = Double.parseDouble(format); String format1 = df.format(cknu); double b = Double.parseDouble(format1); map.put("rknum", a); map.put("cknum", b); List list = new ArrayList(); list.add(map); list.add(pages); return R.data(list); } }