| | |
| | | "w.reject_reason, " + |
| | | "su.`name` responsible_name, " + |
| | | "w.score, " + |
| | | "w.img_width, " + |
| | | "w.img_height, " + |
| | | "w.create_at " + |
| | | "FROM " + |
| | | "com_act_micro_wish w " + |
| | |
| | | "AND w.create_at BETWEEN #{comActMicroWishVO.createBegin} " + |
| | | "AND #{comActMicroWishVO.createEnd}" + |
| | | " </if> " + |
| | | "<if test='comActMicroWishVO.isApplets != null and comActMicroWishVO.isApplets != 0'>" + |
| | | "<if test='comActMicroWishVO.isApplets != null and comActMicroWishVO.isApplets != 0 and comActMicroWishVO.status != null and comActMicroWishVO.status != 7'>" + |
| | | "AND w.status in (3, 5, 6) " + |
| | | " </if> " + |
| | | "<if test='comActMicroWishVO.userId != null and comActMicroWishVO.userId != 0'>" + |
| | |
| | | "u.name sponsor_name, " + |
| | | "u.nick_name userNickName, " + |
| | | "w.create_at, " + |
| | | "w.aim_num, " + |
| | | "u.image_url, " + |
| | | "w.sponsor_phone, " + |
| | | "w.`status`, " + |
| | |
| | | "w.feedback_photo_path_list, " + |
| | | "w.distribution_at, " + |
| | | "w.evaluate_at, " + |
| | | "w.img_width, " + |
| | | "w.img_height, " + |
| | | "w.evaluate " + |
| | | "FROM " + |
| | | "com_act_micro_wish w " + |