| | |
| | | AND tsai.is_shelves = #{goods.showStatus} |
| | | </if> |
| | | |
| | | <if test="goods.status != null and goods.status =1"> |
| | | <if test="goods.status != null and goods.status ==1"> |
| | | AND tsai.start_time <![CDATA[>]]> NOW() |
| | | </if> |
| | | |
| | | <if test="goods.status != null and goods.status =2"> |
| | | <if test="goods.status != null and goods.status ==2"> |
| | | AND tsai.start_time <![CDATA[<=]]> NOW() AND tsai.end_time <![CDATA[>]]> NOW() |
| | | </if> |
| | | |
| | | <if test="goods.status != null and goods.status =3"> |
| | | <if test="goods.status != null and goods.status ==3"> |
| | | AND tsai.end_time <![CDATA[<]]> NOW() |
| | | </if> |
| | | |