| | |
|---|
| | | .append(" , date_format( c.issueStartTime, '%Y-%m-%d %H:%i:%s') as issueStartTime ") |
|---|
| | | .append(" , date_format( c.issueEndTime, '%Y-%m-%d %H:%i:%s') as issueEndTime ") |
|---|
| | | .append(" , CASE c.type WHEN 0 THEN c.discountNum ELSE c.discountAmount END AS couponPrice") |
|---|
| | | .append(" , rr.opName,rr.userName,rr.CIQ ") |
|---|
| | | .append(" , rr.opName,rr.userName,rr.CIQ,ri.approveRemark as remark ") |
|---|
| | | .append(" FROM market_activity ma") |
|---|
| | | .append(" LEFT JOIN market_activity_item mai ON ma.id = mai.marketActivityId") |
|---|
| | | .append(" LEFT JOIN coupon c ON mai.commonId = c.id AND mai.commonType = #{m.commonType} ") |
|---|
| | |
|---|
| | | sql.append(" AND ri.approveStatus in (0,1,2,3)"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | sql.append(" ORDER BY c.createTime DESC "); |
|---|
| | | sql.append(" ORDER BY ri.createTime DESC "); |
|---|
| | | sqlSentence.setSqlSentence(sql.toString()); |
|---|
| | | |
|---|
| | | PageHelper.startPage(dto.getPageNum() == null ? 1 : dto.getPageNum(), dto.getPageSize() == null ? 10 : dto.getPageSize()); |
|---|
