zy-asrs.git - Gitblit

			@@ -1,5 +1,7 @@
			package com.zy.asrs.controller;

			import com.alibaba.excel.EasyExcel;
			import com.alibaba.excel.write.style.column.LongestMatchColumnWidthStyleStrategy;
			import com.alibaba.fastjson.JSONArray;
			import com.alibaba.fastjson.JSONObject;
			import com.baomidou.mybatisplus.mapper.EntityWrapper;
			@@ -11,11 +13,18 @@
			import com.core.common.DateUtils;
			import com.core.common.R;
			import com.zy.asrs.entity.LocDetl;
			import com.zy.asrs.entity.MatCode;
			import com.zy.asrs.mapper.LocDetlMapper;
			import com.zy.asrs.service.LocDetlService;
			import com.zy.asrs.service.MatCodeService;
			import com.zy.asrs.utils.VersionUtils;
			import com.zy.common.web.BaseController;
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.web.bind.annotation.*;

			import javax.servlet.http.HttpServletResponse;
			import java.io.IOException;
			import java.net.URLEncoder;
			import java.util.*;

			@RestController
			@@ -23,6 +32,16 @@

			@Autowired
			private LocDetlService locDetlService;
			@Autowired
			private LocDetlMapper locDetlMapper;

			@RequestMapping(value = "/locDetl/update")
			public R update1() {
			if (!locDetlService.updateLocNo("0402805", "0402804")) {
			return R.error();
			}
			return R.ok();
			}

			@RequestMapping(value = "/locDetl/{id}/auth")
			@ManagerAuth
			@@ -30,12 +49,37 @@
			return R.ok(locDetlService.selectById(String.valueOf(id)));
			}

			@RequestMapping(value = "/locDetl/auth")
			@ManagerAuth
			public R stockOutList(@RequestParam(value = "locNos[]") List<String> locNos){
			if (!locNos.isEmpty()) {
			List<LocDetl> res = new ArrayList<>();
			for (String locNo : new HashSet<>(locNos)) {
			List<LocDetl> locDetls = locDetlService.selectList(new EntityWrapper<LocDetl>().eq("loc_no", locNo));
			if (!locDetls.isEmpty()) {
			res.addAll(locDetls);
			}
			}
			return R.ok().add(res);
			}
			return R.parse(BaseRes.EMPTY);
			}

			@RequestMapping(value = "/stock/out/list/auth")
			@ManagerAuth
			public R stockOutList(@RequestParam(defaultValue = "1")Integer curr,
			@RequestParam(defaultValue = "10")Integer limit,
			@RequestParam Map<String, Object> param){
			return R.ok(locDetlService.getStockOut(new Page<LocDetl>(curr, limit).setCondition(param)));
			if (!Cools.isEmpty(param.get("modi_time"))){
			String val = String.valueOf(param.get("modi_time"));
			if (val.contains(RANGE_TIME_LINK)) {
			String[] dates = val.split(RANGE_TIME_LINK);
			param.put("startTime", DateUtils.convert(dates[0]));
			param.put("endTime", DateUtils.convert(dates[1]));
			param.remove("modi_time");
			}
			}
			return R.ok(locDetlService.getStockOut(toPage(curr, limit, param, LocDetl.class)));
			}

			@RequestMapping(value = "/locDetl/list/auth")
			@@ -44,22 +88,29 @@
			@RequestParam(defaultValue = "10")Integer limit,
			@RequestParam(required = false)String orderByField,
			@RequestParam(required = false)String orderByType,
			@RequestParam(required = false)String condition,
			@RequestParam Map<String, Object> param){
			excludeTrash(param);
			EntityWrapper<LocDetl> wrapper = new EntityWrapper<>();
			convert(param, wrapper);
			allLike(LocDetl.class, param.keySet(), wrapper, condition);
			if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));}
			return R.ok(locDetlService.selectPage(new Page<>(curr, limit), wrapper));
			}

			private void convert(Map<String, Object> map, EntityWrapper wrapper){
			private <T> void convert(Map<String, Object> map, EntityWrapper<T> wrapper){
			for (Map.Entry<String, Object> entry : map.entrySet()){
			if (entry.getKey().endsWith(">")) {
			wrapper.ge(Cools.deleteChar(entry.getKey()), DateUtils.convert(String.valueOf(entry.getValue())));
			} else if (entry.getKey().endsWith("<")) {
			wrapper.le(Cools.deleteChar(entry.getKey()), DateUtils.convert(String.valueOf(entry.getValue())));
			String val = String.valueOf(entry.getValue());
			if (val.contains(RANGE_TIME_LINK)){
			String[] dates = val.split(RANGE_TIME_LINK);
			wrapper.ge(entry.getKey(), DateUtils.convert(dates[0]));
			wrapper.le(entry.getKey(), DateUtils.convert(dates[1]));
			} else {
			wrapper.like(entry.getKey(), String.valueOf(entry.getValue()));
			if (entry.getKey().equals("locNo")) {
			wrapper.eq("loc_no", String.valueOf(entry.getValue()));
			} else {
			wrapper.like(entry.getKey(), String.valueOf(entry.getValue()));
			}
			}
			}
			}
			@@ -137,4 +188,46 @@
			return R.ok();
			}


			@Autowired
			private MatCodeService matCodeService;

			@RequestMapping(value = "/locDetl/statis/auth")
			@ManagerAuth
			public R statis(@RequestParam(defaultValue = "1")Integer curr,
			@RequestParam(defaultValue = "10")Integer limit,
			@RequestParam Map<String, Object> param) {
			Page<LocDetl> stockStatis = locDetlService.getStockStatis(toPage(curr, limit, param, LocDetl.class));
			for (LocDetl locDetl : stockStatis.getRecords()) {
			MatCode matCode = matCodeService.selectById(locDetl.getMatnr());
			if (matCode != null) {
			VersionUtils.setLocDetl(locDetl, matCode);
			}
			}
			return R.ok().add(stockStatis);
			}

			@Autowired
			private LocDetlMapper LocDetlMapper;

			@RequestMapping(value = "/locDetl/statis/export")
			// @ManagerAuth
			public void statisExport(HttpServletResponse response) throws IOException {
			List<LocDetl> excel = LocDetlMapper.getStockStatisExcel();
			for (LocDetl locDetl : excel) {
			MatCode matCode = matCodeService.selectById(locDetl.getMatnr());
			if (matCode != null) {
			VersionUtils.setLocDetl(locDetl, matCode);
			}
			}
			response.setContentType("application/vnd.ms-excel");
			response.setCharacterEncoding("utf-8");
			String fileName = URLEncoder.encode("库存明细统计报表", "UTF-8");
			response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");
			EasyExcel.write(response.getOutputStream(), LocDetl.class)
			.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
			.sheet("表1")
			.doWrite(excel);
			}

			}