YiWuProject.git

			@@ -63,7 +63,7 @@
			//工位显示
			@Override
			public List<Map<String, Object>> getTotalGlassDimensionsByWorkstation() {
			MPJQueryWrapper<DownWorkstionAndDownGlassinfo> queryWrapper = new MPJQueryWrapper<>();
			MPJQueryWrapper<DownWorkstation> queryWrapper = new MPJQueryWrapper<>();
			queryWrapper.select("t.workstation_id", "t.flow_card_id", "COALESCE(SUM(b.width), 0) AS totalwidth", "COALESCE(SUM(b.height), 0) AS totalheight")
			.leftJoin("down_glass_info b on t.flow_card_id = b.flow_card_id")
			.groupBy("t.workstation_id", "t.flow_card_id");
			@@ -91,17 +91,6 @@
			}


			// @Override
			// public int getTotalQuantity(int workstationId) {
			// Integer totalQuantity = downWorkstationMapper.getTotalQuantity(workstationId);
			// return totalQuantity != null ? totalQuantity : 0;
			// }

			// @Override
			// public int getRacksNumber(int workstationId) {
			// Integer racksNumber = downWorkstationMapper.getRacksNumber(workstationId);
			// return racksNumber != null ? racksNumber : 0;
			// }
			//根据条件获取落架数量
			@Override
			public int getRacksNumber(int workstationId) {
			@@ -130,7 +119,7 @@
			public void updateracksnumber(String flowCardId, int racksNumber) {
			UpdateWrapper<DownWorkstation> updateWrapper = new UpdateWrapper<>();
			updateWrapper.set("racks_number", racksNumber).eq("flow_card_id", flowCardId);
			baseMapper.update(null, updateWrapper);
			baseMapper.update(new DownWorkstation(), updateWrapper);
			}


			@@ -141,7 +130,7 @@
			.set("flow_card_id", flowCardId)
			.eq("workstation_id", workstationId);

			return baseMapper.update(null, updateWrapper);
			return baseMapper.update(new DownWorkstation(), updateWrapper);
			}

			@Override
			@@ -152,10 +141,13 @@
			.set("racks_number", 0)
			.eq("workstation_id", workstationId);

			baseMapper.update(null, updateWrapper);
			baseMapper.update(new DownWorkstation(), updateWrapper);
			}





			public DownWorkstation selectByFlowCardId(String flowcardid) {
			QueryWrapper<DownWorkstation> queryWrapper = new QueryWrapper<>();
			queryWrapper.eq("flow_card_id", flowcardid);