| | |
|---|
| | | TDMI.MODULEID, |
|---|
| | | TDMI.ITEMORDER, |
|---|
| | | TMPI.STATUS, |
|---|
| | | TDMI.CATEGORYID, |
|---|
| | | TMIO.POINTID, |
|---|
| | | TMIO.TAGNAME, |
|---|
| | | TMIO.RESULTTABLEID, |
|---|
| | | TMRT.TABLENAME |
|---|
| | | TDMI.CATEGORYID |
|---|
| | | 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 |
|---|
| | | WHERE 1 = 1 |
|---|
| | | <if test="itemno != null and itemno != ''"> |
|---|
| | | AND TMPI.ITEMNO LIKE CONCAT('%', #{itemno},'%') |
|---|
