Below is my Plain POJO object which is having all the mappings. Note that it is not an Entity object.
import javax.persistence.ColumnResult;
import javax.persistence.ConstructorResult;
import javax.persistence.NamedNativeQuery;
import javax.persistence.SqlResultSetMapping;
import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;
@Getter
@Setter
@ToString
@AllArgsConstructor
@SqlResultSetMapping(name = "refundReportMapping", classes = { @ConstructorResult(targetClass = RefundReport.class, columns = {
@ColumnResult(name = "customer_name"),
@ColumnResult(name = "hashed_email"), @ColumnResult(name = "address"),
@ColumnResult(name = "partner_order"),
@ColumnResult(name = "refund_amount") }) })
@NamedNativeQuery(name = "findRefundReportByStatusNamesParamsNative", query = "SELECT concat(bd.first_name,' ',bd.last_name) as 'customer_name',bd.email_address AS 'hashed_email',concat(bd.address1,' ',bd.address2) AS 'address',"
+ o.reservation_id AS 'partner_order',"
+ "(oa.principal_amount+oa.shipping_amount+oa.tax_amount) AS 'refund_amount'"
+ "FROM orders o, order_adjustments oa WHERE oa.status = :status"
+ "and o.buyer_detail_id=bd.buyer_detail_id and o.reservation_id=oa.order_id", resultClass = RefundReport.class, resultSetMapping = "refundReportMapping")
public class RefundReport {
private String customerName, email, address,
partnerOrder;
private BigDecimal partilaRefundAount;
}
public interface RefundReportRepository extends
Repository<RefundReport, String> {
List<RefundReport> findRefundReportByStatus(
@Param("status") String status);
}
