| | |
| | | "w.sponsor_phone,\n" + |
| | | "w.wish_name,\n" + |
| | | "w.`status`,\n" + |
| | | "count(wu.id)start_num,\n" + |
| | | "count(wu.id)star_num,\n" + |
| | | "w.`detail`,\n" + |
| | | "w.form,\n" + |
| | | "su.`name` responsible_name,\n" + |
| | |
| | | "<if test='comActMicroWishVO.sponsorPhone != null and comActMicroWishVO.sponsorPhone.trim() != ""'>" + |
| | | "AND w.sponsor_phone = #{comActMicroWishVO.sponsorPhone} \n" + |
| | | " </if> " + |
| | | "<if test='comActMicroWishVO.status != null '>" + |
| | | "<if test='comActMicroWishVO.status != null and comActMicroWishVO.status!=0 '>" + |
| | | "AND w.`status` = #{comActMicroWishVO.status} \n" + |
| | | " </if> " + |
| | | "<if test='comActMicroWishVO.createBegin != null '>" + |