| | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.iailab.framework.common.pojo.PageResult; |
| | | import com.iailab.framework.common.util.object.BeanUtils; |
| | | import com.iailab.module.data.api.point.DataPointApi; |
| | | import com.iailab.module.model.mcs.pre.dao.MmPredictItemDao; |
| | | import com.iailab.module.model.mcs.pre.dto.MmPredictItemDTO; |
| | | import com.iailab.module.model.mcs.pre.entity.*; |
| | |
| | | @Autowired |
| | | private MmPredictItemDao mmPredictItemDao; |
| | | |
| | | @Autowired |
| | | private DataPointApi dataPointApi; |
| | | |
| | | @Override |
| | | public PageResult<MmPredictItemRespVO> queryPage(MmPredictItemPageReqVO reqVO) { |
| | | IPage<MmPredictItemRespVO> page = mmPredictItemDao.selectPage(reqVO); |
| | | |
| | | return new PageResult<MmPredictItemRespVO>(page.getRecords(), page.getTotal()); |
| | | return new PageResult<>(page.getRecords(), page.getTotal()); |
| | | } |
| | | |
| | | @Override |
| | |
| | | |
| | | import java.io.Serializable; |
| | | import java.math.BigDecimal; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | @ExcelProperty("存放表") |
| | | private String tablename; |
| | | |
| | | @Schema(description = "运行时间") |
| | | @ExcelProperty("运行时间") |
| | | private Date lastTime; |
| | | |
| | | @Schema(description = "运行状态") |
| | | @ExcelProperty("运行状态") |
| | | private Integer runStatus; |
| | | |
| | | @Schema(description = "运行耗时") |
| | | @ExcelProperty("运行耗时") |
| | | private Long duration; |
| | | |
| | | } |
| | | |
| | |
| | | TDMI.ITEMORDER, |
| | | TMPI.STATUS, |
| | | TDMI.CATEGORYID, |
| | | TMIO.POINTID, |
| | | TMIO.TAGNAME, |
| | | TMIO.RESULTTABLEID, |
| | | TMRT.TABLENAME |
| | | TMIS.last_time, |
| | | TMIS.status run_status, |
| | | TMIS.duration |
| | | FROM T_MM_PREDICT_ITEM TMPI |
| | | LEFT JOIN T_MM_ITEM_TYPE TMIT ON TMIT.ID = TMPI.ITEMTYPEID |
| | | LEFT JOIN T_DM_MODULE_ITEM TDMI ON TDMI.ITEMID = TMPI.ID |
| | | LEFT JOIN T_MM_ITEM_OUTPUT TMIO ON TMIO.ITEMID = TMPI.ID |
| | | LEFT JOIN T_MM_RESULT_TABLE TMRT ON TMRT.ID = TMIO.RESULTTABLEID |
| | | LEFT JOIN t_mm_item_status TMIS ON TMIS.item_id = TMPI.ID |
| | | <where> |
| | | <if test="params.itemno != null and params.itemno != ''"> |
| | | AND TMPI.ITEMNO LIKE CONCAT('%', #{params.itemno},'%') |