| | |
| | | AND t2.phone LIKE concat('%',#{req.phone}, '%') |
| | | </if> |
| | | <if test="req.status != null and req.status = 1"> |
| | | AND t1.status =1 and t1.endTime >= now() |
| | | AND t1.status =1 and t1.end_time >= now() |
| | | </if> |
| | | <if test="req.status != null and req.status = 2"> |
| | | AND t1.status =2 |
| | | </if> |
| | | <if test="req.status != null and req.status = 3"> |
| | | AND t1.status =1 and t1.endTime <= now() and t1.del_flag = 0 |
| | | AND t1.status =1 and t1.end_time <= now() and t1.del_flag = 0 |
| | | </if> |
| | | <if test="req.status != null and req.status = 4"> |
| | | AND t1.del_flag = 0 |