| | |
| | | AND equipmentName LIKE CONCAT(CONCAT('%',#{equipmentSpindleStatisticalVo.equipmentName}),'%') |
| | | </if> |
| | | <if test="equipmentSpindleStatisticalVo.createDate != null and equipmentSpindleStatisticalVo.createDate != ''"> |
| | | AND createDate LIKE CONCAT(CONCAT('%',#{equipmentSpindleStatisticalVo.createDate}),'%') |
| | | AND createDate = #{equipmentSpindleStatisticalVo.createDate} |
| | | </if> |
| | | <if test="equipmentSpindleStatisticalVo.equipmentIdList != null and equipmentSpindleStatisticalVo.equipmentIdList.size() > 0"> |
| | | AND equipmentID IN |
| | |
| | | AND equipmentName LIKE CONCAT(CONCAT('%',#{equipmentSpindleStatisticalVo.equipmentName}),'%') |
| | | </if> |
| | | <if test="equipmentSpindleStatisticalVo.createDate != null and equipmentSpindleStatisticalVo.createDate != ''"> |
| | | AND createDate LIKE CONCAT(CONCAT('%',#{equipmentSpindleStatisticalVo.createDate}),'%') |
| | | AND createDate = #{equipmentSpindleStatisticalVo.createDate} |
| | | </if> |
| | | <if test="equipmentSpindleStatisticalVo.equipmentIdList != null and equipmentSpindleStatisticalVo.equipmentIdList.size() > 0"> |
| | | AND equipmentID IN |