From 6e54b432ab969eccb47b0aa388b95bf14e398790 Mon Sep 17 00:00:00 2001 From: aijinhui <aijinhui> Date: 星期四, 31 八月 2023 10:34:28 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java | 121 +++++++++++++++++++++++++++++++++------- 1 files changed, 99 insertions(+), 22 deletions(-) diff --git a/ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java b/ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java index 78e357e..e091a7b 100644 --- a/ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java +++ b/ard-work/src/main/java/com/ruoyi/alarmpoints/well/controller/ArdAlarmpointsWellController.java @@ -4,13 +4,22 @@ import javax.annotation.Resource; import javax.servlet.http.HttpServletResponse; +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.ruoyi.alarmpoints.well.domain.ArdAlarmpointsWell; +import com.ruoyi.alarmpoints.well.domain.ArdAlarmpointsWellParam; import com.ruoyi.alarmpoints.well.service.IArdAlarmpointsWellService; -import com.ruoyi.common.annotation.Anonymous; +import com.ruoyi.common.core.domain.entity.SysUser; import com.ruoyi.common.utils.SecurityUtils; import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.system.service.ISysDeptService; +import com.ruoyi.system.service.ISysUserService; +import com.ruoyi.utils.result.Results; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.dao.DuplicateKeyException; +import org.springframework.http.HttpStatus; +import org.springframework.http.ResponseEntity; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; @@ -27,21 +36,29 @@ import com.ruoyi.common.core.page.TableDataInfo; import org.springframework.web.multipart.MultipartFile; +import java.util.ArrayList; +import java.util.HashMap; import java.util.List; +import java.util.Map; /** * 浜曠鐞咰ontroller - * + * * @author 鍒樿嫃涔� * @date 2023-03-07 */ @RestController @RequestMapping("/alarmpoints/well") @Api(tags = "浜曠鐞嗘帴鍙�") -public class ArdAlarmpointsWellController extends BaseController -{ +public class ArdAlarmpointsWellController extends BaseController { @Resource private IArdAlarmpointsWellService ardAlarmpointsWellService; + + @Autowired + private ISysUserService sysUserService; + + @Autowired + private ISysDeptService sysDeptService; /** * 鏌ヨ浜曠鐞嗗垪琛� @@ -49,13 +66,19 @@ @PreAuthorize("@ss.hasPermi('alarmpoints:well:list')") @GetMapping("/list") @ApiOperation("鏌ヨ浜曞垪琛�") - public TableDataInfo list(ArdAlarmpointsWell ardAlarmpointsWell) - { + public TableDataInfo list(ArdAlarmpointsWell ardAlarmpointsWell) { startPage(); List<ArdAlarmpointsWell> list = ardAlarmpointsWellService.selectArdAlarmpointsWellList(ardAlarmpointsWell); return getDataTable(list); } + @PreAuthorize("@ss.hasPermi('alarmpoints:well:list')") + @GetMapping("/nonPageList") + @ApiOperation("鏌ヨ浜曞垪琛�-涓嶅垎椤�") + public AjaxResult nonPageList(ArdAlarmpointsWell ardAlarmpointsWell) { + List<ArdAlarmpointsWell> list = ardAlarmpointsWellService.selectArdAlarmpointsWellList(ardAlarmpointsWell); + return success(list); + } /** * 瀵煎嚭浜曠鐞嗗垪琛� */ @@ -63,8 +86,7 @@ @Log(title = "浜曠鐞�", businessType = BusinessType.EXPORT) @PostMapping("/export") @ApiOperation("瀵煎嚭浜曞垪琛�") - public void export(HttpServletResponse response, ArdAlarmpointsWell ardAlarmpointsWell) - { + public void export(HttpServletResponse response, ArdAlarmpointsWell ardAlarmpointsWell) { List<ArdAlarmpointsWell> list = ardAlarmpointsWellService.selectArdAlarmpointsWellList(ardAlarmpointsWell); ExcelUtil<ArdAlarmpointsWell> util = new ExcelUtil<ArdAlarmpointsWell>(ArdAlarmpointsWell.class); util.exportExcel(response, list, "浜曠鐞嗘暟鎹�"); @@ -76,8 +98,7 @@ @PreAuthorize("@ss.hasPermi('alarmpoints:well:query')") @GetMapping(value = "/{id}") @ApiOperation("鑾峰彇浜曡缁嗕俊鎭�") - public AjaxResult getInfo(@PathVariable("id") String id) - { + public AjaxResult getInfo(@PathVariable("id") String id) { return success(ardAlarmpointsWellService.selectArdAlarmpointsWellById(id)); } @@ -88,9 +109,12 @@ @Log(title = "浜曠鐞�", businessType = BusinessType.INSERT) @PostMapping @ApiOperation("鏂板浜�") - public AjaxResult add(@RequestBody ArdAlarmpointsWell ardAlarmpointsWell) - { - return toAjax(ardAlarmpointsWellService.insertArdAlarmpointsWell(ardAlarmpointsWell)); + public AjaxResult add(@RequestBody ArdAlarmpointsWell ardAlarmpointsWell) { + try { + return toAjax(ardAlarmpointsWellService.insertArdAlarmpointsWell(ardAlarmpointsWell)); + } catch (Exception e) { + return AjaxResult.error(e.getMessage()); + } } /** @@ -100,9 +124,12 @@ @Log(title = "浜曠鐞�", businessType = BusinessType.UPDATE) @PutMapping @ApiOperation("淇敼浜�") - public AjaxResult edit(@RequestBody ArdAlarmpointsWell ardAlarmpointsWell) - { + public AjaxResult edit(@RequestBody ArdAlarmpointsWell ardAlarmpointsWell) { + try { return toAjax(ardAlarmpointsWellService.updateArdAlarmpointsWell(ardAlarmpointsWell)); + } catch (Exception e) { + return AjaxResult.error(e.getMessage()); + } } /** @@ -110,10 +137,9 @@ */ @PreAuthorize("@ss.hasPermi('alarmpoints:well:remove')") @Log(title = "浜曠鐞�", businessType = BusinessType.DELETE) - @DeleteMapping("/{ids}") + @DeleteMapping("/{ids}") @ApiOperation("鍒犻櫎浜�") - public AjaxResult remove(@PathVariable String[] ids) - { + public AjaxResult remove(@PathVariable String[] ids) { return toAjax(ardAlarmpointsWellService.deleteArdAlarmpointsWellByIds(ids)); } @@ -121,19 +147,70 @@ @PreAuthorize("@ss.hasPermi('alarmpoints:well:import')") @PostMapping("/importData") @ApiOperation("瀵煎叆浜�") - public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception - { + public AjaxResult importData(MultipartFile file, boolean updateSupport) throws Exception { ExcelUtil<ArdAlarmpointsWell> util = new ExcelUtil<ArdAlarmpointsWell>(ArdAlarmpointsWell.class); List<ArdAlarmpointsWell> userList = util.importExcel(file.getInputStream()); String operName = getUsername(); String message = ardAlarmpointsWellService.importUser(userList, updateSupport, operName); return success(message); } + @PostMapping("/importTemplate") @ApiOperation("浜曞鍏ユā鏉�") - public void importTemplate(HttpServletResponse response) - { + public void importTemplate(HttpServletResponse response) { ExcelUtil<ArdAlarmpointsWell> util = new ExcelUtil<ArdAlarmpointsWell>(ArdAlarmpointsWell.class); util.importTemplateExcel(response, "浜曟暟鎹�"); } + + /** + * 浜曢�夐」鏁版嵁 + */ + @GetMapping("/options") + @ApiOperation("浜曢�夐」鏁版嵁") + public List options(ArdAlarmpointsWell ardAlarmpointsWell) { + List<ArdAlarmpointsWell> list = ardAlarmpointsWellService.selectArdAlarmpointsWellByWellIdLike(ardAlarmpointsWell); + List options = new ArrayList(); + for (ArdAlarmpointsWell item : list) { + Map option = new HashMap(); + option.put("value", item.getId()); + option.put("label", item.getWellId()); + option.put("description", item.getOilProduction()); + options.add(option); + } + return options; + } + + @GetMapping("/wellById/{id}") + @ApiOperation("鏌ヨ鍗曟潯鍏磋叮鐐�") + public Results wellById(@PathVariable String id) { + return Results.succeed(ardAlarmpointsWellService.wellById(id)); + } + + @PostMapping("/wellList") + @ApiOperation("鏌ヨ鏉冮檺涓嬫墍鏈夊叴瓒g偣") + public Results wellList(){ + String usersId = SecurityUtils.getUserId(); + //鏍规嵁userId鏌ヨ閮ㄩ棬Id + SysUser sysUser = sysUserService.selectUserById(usersId); + //鏍规嵁褰撳墠deptId鎴栬�呭綋鍓嶅強鎵�灞炰笅绾х殑鎵�鏈塪eptId + List<Long> deptList = sysDeptService.deptIdBySub(sysUser.getDeptId()); + //鏍规嵁deptId鑾峰彇瀵瑰簲鍏磋叮鐐规暟鎹� + List<ArdAlarmpointsWell> list = ardAlarmpointsWellService.wellList(deptList); + return Results.succeed(list); + } + + @PostMapping("/conditionList") + @ApiOperation("鏌ヨ骞剁瓫閫夋潈闄愪笅鎵�鏈夊叴瓒g偣") + public Results conditionList(ArdAlarmpointsWellParam ardAlarmpointsWellParam){ + String usersId = SecurityUtils.getUserId(); + //鏍规嵁userId鏌ヨ閮ㄩ棬Id + SysUser sysUser = sysUserService.selectUserById(usersId); + //鏍规嵁褰撳墠deptId鎴栬�呭綋鍓嶅強鎵�灞炰笅绾х殑鎵�鏈塪eptId + List<Long> deptList = sysDeptService.deptIdBySub(sysUser.getDeptId()); + ardAlarmpointsWellParam.setDeptList(deptList); + //鏍规嵁deptId鑾峰彇瀵瑰簲鍏磋叮鐐规暟鎹� + return Results.succeed(ardAlarmpointsWellService.conditionList(ardAlarmpointsWellParam)); + } + + } -- Gitblit v1.9.3