zy-asrs.git - Gitblit

			@@ -52,6 +52,8 @@
			private LocDetlService locDetlService;
			@Autowired
			private MatService matService;
			@Autowired
			private AgvLocDetlService agvLocDetlService;

			@RequestMapping(value = "/order/nav/list/auth")
			@ManagerAuth
			@@ -130,7 +132,19 @@
			@RequestParam(required = false)String orderByField,
			@RequestParam(required = false)String orderByType,
			@RequestParam Map<String, Object> param){
			return R.ok(orderDetlService.getPakoutPage(toPage(curr, limit, param, OrderDetl.class)));
			EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>();
			excludeTrash(param);
			convert(param, wrapper);
			// return R.ok(orderDetlService.getPakoutPage(toPage(curr, limit, param, OrderDetl.class)));
			List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakin", 1));
			List<Long> docIds = new ArrayList<>();
			for (DocType pakin : pakins) {
			if (pakin.getDocId() != 32) {
			docIds.add(pakin.getDocId());
			}
			}
			wrapper.in("source",docIds);
			return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper));
			// EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>();
			// excludeTrash(param);
			// convert(param, wrapper);
			@@ -150,6 +164,56 @@
			// }
			// wrapper.in("order_no",orderNos);
			// return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper));
			}

			// 所有入库订单明细
			@RequestMapping(value = "/order/bcp/detls/pakin/page/auth")
			@ManagerAuth
			public R bcpOrderDetls(@RequestParam(defaultValue = "1")Integer curr,
			@RequestParam(defaultValue = "100")Integer limit,
			@RequestParam(required = false)String orderByField,
			@RequestParam(required = false)String orderByType,
			@RequestParam Map<String, Object> param){
			EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>();
			excludeTrash(param);
			convert(param, wrapper);
			// return R.ok(orderDetlService.getPakoutPage(toPage(curr, limit, param, OrderDetl.class)));
			List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakin", 1));
			List<Long> docIds = new ArrayList<>();
			for (DocType pakin : pakins) {
			if (pakin.getDocId() == 32) {
			docIds.add(pakin.getDocId());
			}
			}
			wrapper.in("source",docIds);
			return R.ok(orderDetlService.selectPage(new Page<>(curr, limit), wrapper));
			}

			@RequestMapping(value = "/order/bcpDb/detls/pakin/page/auth")
			@ManagerAuth
			public R bcpDbOrderDetls(@RequestParam(defaultValue = "1")Integer curr,
			@RequestParam(defaultValue = "100")Integer limit,
			@RequestParam(required = false)String orderByField,
			@RequestParam(required = false)String orderByType,
			@RequestParam Map<String, Object> param){
			EntityWrapper<OrderDetl> wrapper = new EntityWrapper<>();
			excludeTrash(param);
			convert(param, wrapper);
			// return R.ok(orderDetlService.getPakoutPage(toPage(curr, limit, param, OrderDetl.class)));
			List<DocType> pakins = docTypeService.selectList(new EntityWrapper<DocType>().eq("pakout", 1));
			List<Long> docIds = new ArrayList<>();
			for (DocType pakin : pakins) {
			if (pakin.getDocId() == 33) {
			docIds.add(pakin.getDocId());
			}
			}
			wrapper.in("source",docIds);
			Page<OrderDetl> page = orderDetlService.selectPage(new Page<>(curr, limit), wrapper);
			for (OrderDetl record : page.getRecords()) {
			Double sumAnfme = agvLocDetlService.getSumAnfmeDb(record.getMatnr(), record.getThreeCode(),1);
			record.setStock(sumAnfme == null ? 0 : sumAnfme);
			}
			return R.ok(page);
			}

			@RequestMapping(value = "/order/detl/all/auth")
			@@ -219,6 +283,7 @@
			list.add(dto);
			orderDetl.setOrderId(order.getId());
			orderDetl.setOrderNo(order.getOrderNo());
			orderDetl.setSource(param.getDocType().intValue());
			orderDetl.setCreateBy(getUserId());
			orderDetl.setCreateTime(now);
			orderDetl.setUpdateBy(getUserId());
			@@ -230,6 +295,74 @@
			}
			}
			}
			if (param.getDocType().intValue() == 32) {
			order = new Order(
			String.valueOf(snowflakeIdWorker.nextId()), // 编号[非空]
			"DB" + param.getOrderNo(), // 订单编号
			DateUtils.convert(now), // 单据日期
			33L, // 单据类型
			null, // 项目编号
			null, //
			null, // 调拨项目编号
			null, // 初始票据号
			null, // 票据号
			null, // 客户编号
			null, // 客户
			null, // 联系方式
			null, // 操作人员
			null, // 合计金额
			null, // 优惠率
			null, // 优惠金额
			null, // 销售或采购费用合计
			null, // 实付金额
			null, // 付款类型
			null, // 业务员
			null, // 结算天数
			null, // 邮费支付类型
			null, // 邮费
			null, // 付款时间
			null, // 发货时间
			null, // 物流名称
			null, // 物流单号
			1L, // 订单状态
			1, // 状态
			getUserId(), // 添加人员
			now, // 添加时间
			getUserId(), // 修改人员
			now, // 修改时间
			null // 备注
			);
			if (!orderService.insert(order)) {
			throw new CoolException("生成半成品调拨单失败");
			}
			List<DetlDto> dbList = new ArrayList<>();
			for (OrderDetl orderDetl : param.getOrderDetlList()) {
			DetlDto dto = new DetlDto(orderDetl.getMatnr(), orderDetl.getBatch());
			if (DetlDto.has(dbList, dto)) {
			OrderDetl item = orderDetlService.selectItem(order.getId(), orderDetl.getMatnr(), orderDetl.getBatch(),orderDetl.getThreeCode(),orderDetl.getDeadTime());
			item.setAnfme(item.getAnfme() + orderDetl.getAnfme());
			if (!orderDetlService.updateById(item)) {
			throw new CoolException("生成半成品调拨单明细档失败");
			}
			} else {
			dbList.add(dto);
			orderDetl.setOrderId(order.getId());
			orderDetl.setOrderNo(order.getOrderNo());
			orderDetl.setSource(33);
			orderDetl.setCreateBy(getUserId());
			orderDetl.setCreateTime(now);
			orderDetl.setUpdateBy(getUserId());
			orderDetl.setUpdateTime(now);
			orderDetl.setStatus(1);
			orderDetl.setQty(0.0D);
			if (!orderDetlService.insert(orderDetl)) {
			throw new CoolException("生成半成品调拨单明细档失败");
			}
			}
			}
			}


			return R.ok("订单添加成功");
			}

			@@ -492,6 +625,7 @@
			Date now = new Date();
			DataFormatter dataFormatter = new DataFormatter();
			for (int i = 1; i < totalRows; i++) {
			Integer proSts = 0;
			Row row = sheet.getRow(i);
			//单据类型
			String docName = dataFormatter.formatCellValue(row.getCell(0));
			@@ -508,6 +642,7 @@
			continue;
			}
			Double anfme = Double.parseDouble(dataFormatter.formatCellValue(row.getCell(5)));

			Mat mat = matService.selectByMatnr(matnr);
			if (null == mat) {
			throw new CoolException(matnr + "商品编码的商品不存在，请重新导入！");
			@@ -516,6 +651,26 @@
			//String timeStr = DateUtils.convert(new Date());

			DocType docType = docTypeService.selectOne(new EntityWrapper<DocType>().eq("doc_name", docName));

			// 单据类型为半成品入库单才有工序
			if (docType.getDocId().intValue() == 32) {
			//工序
			if (Cools.isEmpty(dataFormatter.formatCellValue(row.getCell(6)))) {
			// 工序为空，默认为无需加工
			proSts = 3;
			} else {
			String processSts = dataFormatter.formatCellValue(row.getCell(6));
			//1: 待加工 2：已加工 3：无需加工
			if ("待加工".equals(processSts)) {
			proSts = 1;
			} else if ("已加工".equals(processSts)) {
			proSts = 2;
			} else {
			proSts = 3;
			}
			}
			}


			if(docType.getPakin() == 1){
			uuid += "_I";
			@@ -573,6 +728,7 @@
			if (orderDetl == null) {
			orderDetl = new OrderDetl();
			orderDetl.sync(mat);
			orderDetl.setSource(docType.getDocId().intValue());
			orderDetl.setBatch(null);
			orderDetl.setAnfme(anfme);
			orderDetl.setOrderId(order.getId());
			@@ -585,6 +741,7 @@
			orderDetl.setDeadTime(isocode);
			orderDetl.setStatus(1);
			orderDetl.setQty(0.0D);
			orderDetl.setProcessSts(proSts);
			if (!orderDetlService.insert(orderDetl)) {
			throw new CoolException("生成单据明细失败，请重新导入！");
			}
			@@ -593,6 +750,160 @@
			throw new CoolException("生成单据明细失败，请重新导入！");
			}
			}
			// 生成调拨单
			if (docType.getDocId().intValue() == 32) {
			String dbUuid = "DB" + uuid;
			Order order2 = orderService.selectByNo(dbUuid);
			if (null == order2) {
			order2 = new Order(
			String.valueOf(snowflakeIdWorker.nextId()), // 编号[非空]
			dbUuid, // 订单编号
			null, // 单据日期
			33L, // 单据类型
			null, // 项目编号
			null, //
			null, // 调拨项目编号
			null, // 初始票据号
			null, // 票据号
			null, // 客户编号
			null, // 客户
			null, // 联系方式
			null, // 操作人员
			null, // 合计金额
			null, // 优惠率
			null, // 优惠金额
			null, // 销售或采购费用合计
			null, // 实付金额
			null, // 付款类型
			null, // 业务员
			null, // 结算天数
			null, // 邮费支付类型
			null, // 邮费
			null, // 付款时间
			null, // 发货时间
			null, // 物流名称
			null, // 物流单号
			1L, // 订单状态
			1, // 状态
			userId, // 添加人员
			now, // 添加时间
			userId, // 修改人员
			now, // 修改时间
			null // 备注
			);
			if (!orderService.insert(order2)) {
			throw new CoolException("生成单据主档失败，请重新导入！");
			}
			}else {
			order2.setSettle(order.getSettle() == 1L ? 1L : 2L );
			orderService.updateById(order2);
			}

			OrderDetl orderDetl2 = orderDetlService.selectItem(order2.getId(), matnr, null,csocode,isocode);
			if (orderDetl2 == null) {
			orderDetl2 = new OrderDetl();
			orderDetl2.sync(mat);
			orderDetl2.setSource(33);
			orderDetl2.setBatch(null);
			orderDetl2.setAnfme(anfme);
			orderDetl2.setOrderId(order2.getId());
			orderDetl2.setOrderNo(order2.getOrderNo());
			orderDetl2.setCreateBy(userId);
			orderDetl2.setCreateTime(now);
			orderDetl2.setUpdateBy(userId);
			orderDetl2.setUpdateTime(now);
			orderDetl2.setThreeCode(csocode);
			orderDetl2.setDeadTime(isocode);
			orderDetl2.setStatus(1);
			orderDetl2.setQty(0.0D);
			if (!orderDetlService.insert(orderDetl2)) {
			throw new CoolException("生成单据明细失败，请重新导入！");
			}
			} else {
			if(!orderDetlService.increaseAnfme(order2.getId(), matnr, null, anfme,csocode,isocode)) {
			throw new CoolException("生成单据明细失败，请重新导入！");
			}
			}
			}

			// 工序为1：待加工生成加工单
			if (proSts == 1) {
			if (docType.getDocId().intValue() == 32) {
			String dbUuid = "JG" + uuid;
			Order order3 = orderService.selectByNo(dbUuid);
			if (null == order3) {
			order3 = new Order(
			String.valueOf(snowflakeIdWorker.nextId()), // 编号[非空]
			dbUuid, // 订单编号
			null, // 单据日期
			35L, // 单据类型
			null, // 项目编号
			null, //
			null, // 调拨项目编号
			null, // 初始票据号
			null, // 票据号
			null, // 客户编号
			null, // 客户
			null, // 联系方式
			null, // 操作人员
			null, // 合计金额
			null, // 优惠率
			null, // 优惠金额
			null, // 销售或采购费用合计
			null, // 实付金额
			null, // 付款类型
			null, // 业务员
			null, // 结算天数
			null, // 邮费支付类型
			null, // 邮费
			null, // 付款时间
			null, // 发货时间
			null, // 物流名称
			null, // 物流单号
			1L, // 订单状态
			1, // 状态
			userId, // 添加人员
			now, // 添加时间
			userId, // 修改人员
			now, // 修改时间
			null // 备注
			);
			if (!orderService.insert(order3)) {
			throw new CoolException("生成单据主档失败，请重新导入！");
			}
			}else {
			order3.setSettle(order.getSettle() == 1L ? 1L : 2L );
			orderService.updateById(order3);
			}

			OrderDetl orderDetl3 = orderDetlService.selectItem(order3.getId(), matnr, null,csocode,isocode);
			if (orderDetl3 == null) {
			orderDetl3 = new OrderDetl();
			orderDetl3.sync(mat);
			orderDetl3.setSource(35);
			orderDetl3.setBatch(null);
			orderDetl3.setAnfme(anfme);
			orderDetl3.setOrderId(order3.getId());
			orderDetl3.setOrderNo(order3.getOrderNo());
			orderDetl3.setCreateBy(userId);
			orderDetl3.setCreateTime(now);
			orderDetl3.setUpdateBy(userId);
			orderDetl3.setUpdateTime(now);
			orderDetl3.setThreeCode(csocode);
			orderDetl3.setDeadTime(isocode);
			orderDetl3.setStatus(1);
			orderDetl3.setQty(0.0D);
			if (!orderDetlService.insert(orderDetl3)) {
			throw new CoolException("生成单据明细失败，请重新导入！");
			}
			} else {
			if(!orderDetlService.increaseAnfme(order3.getId(), matnr, null, anfme,csocode,isocode)) {
			throw new CoolException("生成单据明细失败，请重新导入！");
			}
			}
			}
			}

			}
			return R.ok("导入成功");
			}