Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.entity.transaction;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

@Entity

@Table(name = "transaction.userwallet", schema = "transaction")

@NamedQueries({

		@NamedQuery(name = "UserWallet.getSummary", query = "select new com.spice.profitmandi.dao.model.AccountStatementModel(uwh.referenceType, sum(case when uwh.amount>0 then amount else 0 end), sum(case when uwh.amount<0 then -amount else 0 end))\tfrom UserWalletHistory uwh where uwh.walletId=:walletId \tand uwh.timestamp between :startDate and :endDate group by uwh.referenceType") })

public class UserWallet {

	@Id

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	private int id;

	private int userId;

	private int amount;

	@Column(name = "refundable_amount")

	private int refundableAmount;

	public int getId() {

		return id;

	}

	public void setId(int id) {

		this.id = id;

	}

	public int getUserId() {

		return userId;

	}

	public void setUserId(int userId) {

		this.userId = userId;

	}

	public int getAmount() {

		return amount;

	}

	public void setAmount(int amount) {

		this.amount = amount;

	}

	public int getRefundableAmount() {

		return refundableAmount;

	}

	public void setRefundableAmount(int refundableAmount) {

		this.refundableAmount = refundableAmount;

	}

	@Override

	public int hashCode() {

		final int prime = 31;

		int result = 1;

		result = prime * result + id;

		return result;

	}

	@Override

	public boolean equals(Object obj) {

		if (this == obj)

			return true;

		if (obj == null)

			return false;

		if (getClass() != obj.getClass())

			return false;

		UserWallet other = (UserWallet) obj;

		if (id != other.id)

			return false;

		return true;

	}

	@Override

	public String toString() {

		return "UserWallet [id=" + id + ", userId=" + userId + ", amount=" + amount + ", refundableAmount="

				+ refundableAmount + "]";

	}

}