| | |
| | | @ApiOperationSupport(order = 6) |
| | | @ApiOperation(value = "新增或修改", notes = "传入survey") |
| | | public R submit(@Valid Activation activation) { |
| | | //首先需判断票号是否存在 |
| | | |
| | | //如存在,判断该票是否已激活 |
| | | |
| | | //若已经激活,则返回已激活 |
| | | |
| | | //未激活,进入激活流程 |
| | | |
| | | |
| | | return R.status(activationService.saveOrUpdate(activation)); |
| | | } |
| | | |
| | |
| | | LEFT JOIN ( |
| | | SELECT |
| | | count( id ) AS jtype, |
| | | deviceNumber |
| | | deviceNumber as deviceN |
| | | FROM |
| | | sys_alarm |
| | | WHERE |
| | |
| | | OR jtype = 1 |
| | | GROUP BY |
| | | deviceNumber |
| | | ) alarm ON alarm.deviceNumber = equipment.deviceNumber |
| | | ) alarm ON alarm.deviceN = equipment.deviceNumber |
| | | where 1=1 |
| | | |
| | | <if test="equipment.deviceName!=null"> |
| | |
| | | LEFT JOIN ( |
| | | SELECT |
| | | count( id ) AS jtype, |
| | | deviceNumber |
| | | deviceNumber as deviceN |
| | | FROM |
| | | sys_alarm |
| | | WHERE |
| | |
| | | OR jtype = 1 |
| | | GROUP BY |
| | | deviceNumber |
| | | ) alarm ON alarm.deviceNumber = equipment.deviceNumber |
| | | ) alarm ON alarm.deviceN = equipment.deviceNumber |
| | | where 1=1 |
| | | |
| | | <if test="equipment.deviceName!=null"> |
| | |
| | | LEFT JOIN ( |
| | | SELECT |
| | | count( id ) AS jtype, |
| | | deviceNumber |
| | | deviceNumber as deviceN |
| | | FROM |
| | | sys_alarm |
| | | WHERE |
| | |
| | | OR jtype = 1 |
| | | GROUP BY |
| | | deviceNumber |
| | | ) alarm ON alarm.deviceNumber = equipment.deviceNumber |
| | | ) alarm ON alarm.deviceN = equipment.deviceNumber |
| | | WHERE |
| | | 1 =1 |
| | | |