| | |
| | | * @param firmInfo |
| | | * @return |
| | | */ |
| | | @GetMapping("/fuzzyQuery") |
| | | @GetMapping("/fuzzyQuery") |
| | | @ApiOperationSupport(order = 10) |
| | | @ApiOperation(value = "模糊查询企业名称、应急空间名称、风险源名称", notes = "传入firmInfo") |
| | | public R fuzzyQuery(FirmInfoVO firmInfo) { |
| | |
| | | <select id="getDetail" resultType="org.springblade.modules.yw.vo.FirmInfoVO"> |
| | | select |
| | | yfi.*, |
| | | yrt.per_in_cha as rescuePerName,yrt.per_in_cha_pho as rescuePerPhone |
| | | yrt.per_in_cha as rescuePerName,yrt.per_in_cha_pho as rescuePerPhone, |
| | | yrt.per_in_cha_two as rescuePerNameTwo,yrt.per_in_cha_pho_two as rescuePerPhoneTwo |
| | | from yw_firm_info yfi |
| | | left join yw_rescue_team yrt on yrt.firm_id = yfi.id and yrt.is_deleted = 0 |
| | | where yfi.is_deleted = 0 |
| | |
| | | |
| | | @ApiModelProperty(value = "救援队伍人员电话") |
| | | private String rescuePerPhone; |
| | | |
| | | @ApiModelProperty(value = "救援队伍人员姓名2") |
| | | private String rescuePerNameTwo; |
| | | |
| | | @ApiModelProperty(value = "救援队伍人员电话2") |
| | | private String rescuePerPhoneTwo; |
| | | } |