| | |
|---|
| | | <if test="data.endTime != null and data.endTime != ''"> |
|---|
| | | AND STR_TO_DATE(SUBSTRING_INDEX(time, ' - ', -1), '%Y-%m-%d %H:%i') <![CDATA[ <= ]]> #{data.endTime} |
|---|
| | | </if> |
|---|
| | | <if test="data.completeTimeStart != null and data.completeTimeStart != ''"> |
|---|
| | | and DATE(o.complete_time) <![CDATA[ >= ]]> #{data.completeTimeStart} |
|---|
| | | </if> |
|---|
| | | <if test="data.completeTimeEnd != null and data.completeTimeEnd != ''"> |
|---|
| | | and DATE(o.complete_time) <![CDATA[ <= ]]> #{data.completeTimeEnd} |
|---|
| | | </if> |
|---|
| | | </where> |
|---|
| | | order by o.createTime desc |
|---|
| | | </select> |
|---|
