| | |
| | | |
| | | import com.rabbitmq.client.*; |
| | | import com.rabbitmq.client.Channel; |
| | | |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiImplicitParam; |
| | | import io.swagger.annotations.ApiImplicitParams; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import jdk.nashorn.internal.runtime.regexp.joni.Regex; |
| | | import net.sf.json.JSONString; |
| | | |
| | | import org.apache.commons.collections.CollectionUtils; |
| | | import org.apache.commons.collections.MapUtils; |
| | | import org.apache.commons.net.ftp.FTPClient; |
| | |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | import org.springframework.web.servlet.ModelAndView; |
| | | import org.xml.sax.InputSource; |
| | | |
| | | import static com.moral.common.util.ResourceUtil.getValue; |
| | | import static com.moral.common.util.WebUtils.getParametersStartingWith; |
| | | import static java.util.Calendar.*; |
| | |
| | | |
| | | @Resource |
| | | private ScreenVersionService screenVersionService; |
| | | |
| | | /** |
| | | * Screen login. 大屏登录 |
| | | * |
| | |
| | | return new ResultBean<List<Map<String, Object>>>(list); |
| | | } |
| | | |
| | | /* |
| | | * 根据大屏版本号获取版本更新信息 |
| | | */ |
| | | @GetMapping("screenVersion") |
| | | public Map<String, Object> getScreenVersion(HttpServletRequest request) { |
| | | Map<String, Object> parameters = getParametersStartingWith(request, null); |
| | | String version = parameters.get("version").toString(); |
| | | return screenVersionService.getScreenVersion(version); |
| | | } |
| | | |
| | | @GetMapping("devices-sensors-excel") |
| | | @ApiOperation(value = "所有设备多因子数据报表", notes = "所有设备多因子数据报表") |
| | | @ApiImplicitParams(value = { |
| | | @ApiImplicitParam(name = "monitor_point_id", defaultValue = "5", value = "监控站点id", required = true, paramType = "query", dataType = "String"), |
| | | @ApiImplicitParam(name = "sensorKey", value = "传感器key,多个逗号隔开", required = true, paramType = "query", dataType = "String"), |
| | | @ApiImplicitParam(name = "time", value = "时间(格式:2020-04-09)", required = true, paramType = "query", dataType = "String")}) |
| | | public ResultBean<List<Map<String, Object>>> getDevicesToExcel(HttpServletRequest request) throws Exception { |
| | | Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null); |
| | | ParameterUtils.getTimeType4Time(parameters); |
| | | /*String[] sensorKeys = parameters.get("sensorKey").toString().split(","); |
| | | parameters.put("sensorKeys", Arrays.asList(sensorKeys)); |
| | | List<String> macList = new ArrayList<>(); |
| | | List<MonitorPoint> monitorPoints = monitorPointService.getMonitorPointsAndDevicesByRegion(parameters); |
| | | for (MonitorPoint m : monitorPoints) { |
| | | for (Device d : m.getDevices()) { |
| | | macList.add(d.getMac()); |
| | | } |
| | | } |
| | | parameters.put("macs", macList); |
| | | List<Map<String, Object>> list = new ArrayList<>(); |
| | | if (!CollectionUtils.isEmpty(macList)) { |
| | | list = historyMinutelyService.getDevicesAvgDataToExcel(parameters); |
| | | }*/ |
| | | List<Map<String, Object>> list = historyMinutelyService.getDevicesSensorsToExcel(parameters); |
| | | return new ResultBean<List<Map<String, Object>>>(list); |
| | | } |
| | | } |