| | |
| | | TDMI.CATEGORYID, |
| | | TMIS.last_time, |
| | | TMIS.status run_status, |
| | | TMIS.duration |
| | | TMIS.duration, |
| | | TDMM.modulename |
| | | 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_status TMIS ON TMIS.item_id = TMPI.ID |
| | | LEFT JOIN T_DM_MODULE TDMM ON TDMM.id = TDMI.moduleid |
| | | <where> |
| | | <if test="params.itemno != null and params.itemno != ''"> |
| | | AND TMPI.ITEMNO LIKE CONCAT('%', #{params.itemno},'%') |
| | |
| | | <if test="params.status != null and params.status != ''"> |
| | | AND TMPI.STATUS = #{params.status} |
| | | </if> |
| | | <if test="params.modulename != null and params.modulename != ''"> |
| | | AND TDMM.modulename LIKE CONCAT('%', #{params.modulename},'%') |
| | | </if> |
| | | </where> |
| | | ORDER BY TMPI.CREATE_TIME DESC |
| | | </select> |