| | |
| | | "<if test='pageEldersAuthDTO.authUserName != null'>" + |
| | | " AND ea.AUTH_USER_NAME = #{pageEldersAuthDTO.authUserName} " + |
| | | " </if> " + |
| | | "<if test='pageEldersAuthDTO.type == 1 '>" + |
| | | " AND ea.AUTH_USER_NAME = #{pageEldersAuthDTO.month} " + |
| | | " </if> " + |
| | | "<if test='pageEldersAuthDTO.type == 2 '>" + |
| | | "<if test='pageEldersAuthDTO.createAtStart != null'>" + |
| | | " AND ea.create_at <![CDATA[>=]]> #{pageComShopOrderSearchDTO.createAtStart} " + |
| | | " </if> " + |
| | | "<if test='pageEldersAuthDTO.createAtEnd != null'>" + |
| | | " AND ea.create_at <![CDATA[<=]]> #{pageComShopOrderSearchDTO.createAtEnd} " + |
| | | " </if> " + |
| | | " </if> " + |
| | | " </where>" + |
| | | " ORDER BY ea.${pageEldersAuthDTO.sortBy} ${pageEldersAuthDTO.order} " + |
| | | "</script>") |
| | |
| | | "<if test='pageEldersAuthDTO.authUserName != null'>" + |
| | | " AND ea.AUTH_USER_NAME = #{pageEldersAuthDTO.authUserName} " + |
| | | " </if> " + |
| | | "<if test='pageEldersAuthDTO.type == 1 '>" + |
| | | " AND ea.AUTH_USER_NAME = #{pageEldersAuthDTO.month} " + |
| | | " </if> " + |
| | | "<if test='pageEldersAuthDTO.type == 2 '>" + |
| | | "<if test='pageEldersAuthDTO.createAtStart != null'>" + |
| | | " AND ea.create_at <![CDATA[>=]]> #{pageComShopOrderSearchDTO.createAtStart} " + |
| | | " </if> " + |
| | | "<if test='pageEldersAuthDTO.createAtEnd != null'>" + |
| | | " AND ea.create_at <![CDATA[<=]]> #{pageComShopOrderSearchDTO.createAtEnd} " + |
| | | " </if> " + |
| | | " </if> " + |
| | | " </if> " + |
| | | " </where>" + |
| | | " ORDER BY ea.${pageEldersAuthDTO.sortBy} ${pageEldersAuthDTO.order} " + |