Subversion Repositories SmartDukaan

Rev

Rev 21924 | Rev 22067 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 21924 Rev 22009
Line 10... Line 10...
10
import javax.persistence.NamedQueries;
10
import javax.persistence.NamedQueries;
11
import javax.persistence.NamedQuery;
11
import javax.persistence.NamedQuery;
12
import javax.persistence.Table;
12
import javax.persistence.Table;
13
import javax.persistence.UniqueConstraint;
13
import javax.persistence.UniqueConstraint;
14
 
14
 
-
 
15
import com.spice.profitmandi.dao.enumuration.dtr.RoleType;
-
 
16
 
15
/**
17
/**
16
 * This class basically contains api details
18
 * This class basically contains api details
17
 * 
19
 * 
18
 * @author ashikali
20
 * @author ashikali
19
 *
21
 *
20
 */
22
 */
21
@Entity
23
@Entity
22
@Table(name="dtr.user_role", schema = "dtr", uniqueConstraints = {@UniqueConstraint(columnNames = {"user_id", "role_id"})})
24
@Table(name="dtr.user_role", schema = "dtr", uniqueConstraints = {@UniqueConstraint(columnNames = {"user_id", "role_type"})})
23
@NamedQueries({
25
@NamedQueries({
24
	@NamedQuery(name="UserRole.selectByUserId", query="select ur from UserRole ur where ur.userId= :userId"),
26
	@NamedQuery(name="UserRole.selectByUserId", query="select ur from UserRole ur where ur.userId= :userId"),
25
	@NamedQuery(name="UserRole.deleteByUserAndRoleId", query="delete from UserRole ur where ur.userId= :userId and ur.roleId = :roleId"),
27
	@NamedQuery(name="UserRole.deleteByUserAndRoleType", query="delete from UserRole ur where ur.userId= :userId and ur.roleType = :roleType"),
26
	@NamedQuery(name = "UserRole.selectRolesByUserId", query = "select r.id, r.name, r.type, r.status, r.createTimestamp, r.updateTimestamp, p.type from UserRole ur join Role r on r.id = ur.roleId join Permission p on p.roleId = ur.roleId where ur.userId = :userId")
28
	@NamedQuery(name = "UserRole.selectRolesByUserId", query = "select ur from UserRole ur where ur.userId = :userId")
27
})
29
})
28
public class UserRole implements Serializable{
30
public class UserRole implements Serializable{
29
	
31
	
30
	private static final long serialVersionUID = 1L;
32
	private static final long serialVersionUID = 1L;
31
	
33
	
Line 44... Line 46...
44
		this.id = id;
46
		this.id = id;
45
	}
47
	}
46
	@Column(name="user_id", unique=false, updatable=false)
48
	@Column(name="user_id", unique=false, updatable=false)
47
	private int userId;
49
	private int userId;
48
	
50
	
49
	@Column(name="role_id", unique = false)
51
	@Column(name="role_type", unique = false)
50
	private int roleId;
52
	private RoleType roleType;
51
 
53
 
52
	public int getUserId() {
54
	public int getUserId() {
53
		return userId;
55
		return userId;
54
	}
56
	}
55
	
57
	
56
	public void setUserId(int userId) {
58
	public void setUserId(int userId) {
57
		this.userId = userId;
59
		this.userId = userId;
58
	}
60
	}
59
	public int getRoleId() {
61
	public RoleType getRoleType() {
60
		return roleId;
62
		return roleType;
61
	}
63
	}
62
	public void setRoleId(int roleId) {
64
	public void setRoleType(RoleType roleType) {
63
		this.roleId = roleId;
65
		this.roleType = roleType;
64
	}
66
	}
65
 
67
 
66
	@Override
68
	@Override
67
	public int hashCode() {
69
	public int hashCode() {
68
		final int prime = 31;
70
		final int prime = 31;
69
		int result = 1;
71
		int result = 1;
70
		result = prime * result + id;
-
 
71
		result = prime * result + roleId;
72
		result = prime * result + roleType.getValue();
72
		result = prime * result + userId;
73
		result = prime * result + userId;
73
		return result;
74
		return result;
74
	}
75
	}
75
 
76
 
76
	@Override
77
	@Override
Line 80... Line 81...
80
		if (obj == null)
81
		if (obj == null)
81
			return false;
82
			return false;
82
		if (getClass() != obj.getClass())
83
		if (getClass() != obj.getClass())
83
			return false;
84
			return false;
84
		UserRole other = (UserRole) obj;
85
		UserRole other = (UserRole) obj;
85
		if (id != other.id)
-
 
86
			return false;
-
 
87
		if (roleId != other.roleId)
86
		if (roleType != other.roleType)
88
			return false;
87
			return false;
89
		if (userId != other.userId)
88
		if (userId != other.userId)
90
			return false;
89
			return false;
91
		return true;
90
		return true;
92
	}
91
	}
93
 
92
 
94
	@Override
93
	@Override
95
	public String toString() {
94
	public String toString() {
96
		return "UserRole [id=" + id + ", userId=" + userId + ", roleId=" + roleId + "]";
95
		return "UserRole [id=" + id + ", userId=" + userId + ", roleType=" + roleType + "]";
97
	}
96
	}
98
	
97
	
99
	
98
	
100
	
99
	
101
}
100
}
102
101