| | |
| | | return R.status(status); |
| | | } |
| | | |
| | | @PostMapping("/overAll") |
| | | public R overAll(@RequestBody FarmPlantVO farmPlantVO){ |
| | | boolean status = false; |
| | | for (int i=0;i<farmPlantVO.getIds().length;i++){ |
| | | FarmPlant farmPlant = new FarmPlant(); |
| | | farmPlant.setId(farmPlantVO.getIds()[i]); |
| | | farmPlant.setEndPlantTime(farmPlantVO.getEndPlantTime()); |
| | | farmPlant.setStatus("2"); |
| | | status = farmplantService.updateById(farmPlant); |
| | | //判断该地块是否还有种植的农产品 |
| | | FarmPlant farmPlant2 = farmplantService.getById(farmPlant.getId()); |
| | | FarmPlant farmPlant1 = new FarmPlant(); |
| | | farmPlant1.setLandId(farmPlant2.getLandId()); |
| | | farmPlant1.setStatus("1"); |
| | | List<FarmPlant> list = farmplantService.list(new QueryWrapper<>(farmPlant1)); |
| | | if (list.size() < 1) { |
| | | //更新该地块的耕种状态 |
| | | Land land = new Land(); |
| | | land.setType(1); |
| | | land.setId(Long.parseLong(farmPlant2.getLandId())); |
| | | landService.updateById(land); |
| | | } |
| | | } |
| | | return R.data(status); |
| | | } |
| | | |
| | | /** |
| | | * 新增或修改 |
| | | */ |
| | |
| | | |
| | | <select id="selectFarmPlantPageCount" resultType="org.springblade.modules.farmplant.vo.FarmPlantVO"> |
| | | SELECT |
| | | a.strain_id,a.strainName,SUM(FORMAT(a.land_area,3)) area,a.url,a.tenant_id,a.dept_id |
| | | a.strain_id,a.strainName,SUM(TRUNCATE(a.land_area,3)) area,a.url,a.tenant_id,a.dept_id |
| | | FROM |
| | | ( |
| | | SELECT |
| | |
| | | import org.springblade.modules.farmplant.vo.FarmPlantVO; |
| | | import org.springblade.modules.farmplant.vo.StrainVO; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | |
| | | */ |
| | | private String transplanTimeEnd; |
| | | |
| | | private Long[] ids; |
| | | } |