Subversion Repositories SmartDukaan

Rev

Rev 31764 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 31764 Rev 34082
Line 1... Line 1...
1 
/**
 1 
/**
2 
 *
2 
 *
3 
 */
 3 
 */
4 
package com.spice.profitmandi.dao.entity.cs;
 4 
package com.spice.profitmandi.dao.entity.cs;
5 
 
 5 
 
6 
import java.time.LocalDateTime;
 - 
 
7 
import java.time.format.DateTimeFormatter;
 - 
 
8 
 
 - 
 
9 
import javax.persistence.Column;
 - 
 
10 
import javax.persistence.Convert;
 - 
 
11 
import javax.persistence.Entity;
 - 
 
12 
import javax.persistence.EnumType;
 - 
 
13 
import javax.persistence.Enumerated;
 - 
 
14 
import javax.persistence.GeneratedValue;
 - 
 
15 
import javax.persistence.GenerationType;
 - 
 
16 
import javax.persistence.Id;
 - 
 
17 
import javax.persistence.Table;
 - 
 
18 
 
 - 
 
19 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
 6 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
20 
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
 7 
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
21 
 
 8 
 
- 
 
 9 
import javax.persistence.*;
- 
 
 10 
import java.time.LocalDateTime;
- 
 
 11 
import java.time.format.DateTimeFormatter;
- 
 
 12 
 
22 
/**
 13 
/**
23 
 * @author govind
 14 
 * @author govind
24 
 *
 15 
 *
25 
 */
 16 
 */
26 
@Entity
 17 
@Entity
27 
@Table(name = "cs.position")
 18 
@Table(name = "cs.position")
- 
 
 19 
@NamedQueries({
- 
 
 20 
        @NamedQuery(name = "Position.Auth_User_Partner_Maping", query = "select new com.spice.profitmandi.dao.model.AuthUserPartnerMapModel( "
- 
 
 21 
                + "  p.authUserId, pp.fofoId )  from Position p" +
- 
 
 22 
                " JOIN PartnerPosition pp ON pp.positionId = p.id" +
- 
 
 23 
                "                  JOIN Region r ON pp.regionId = r.id" +
- 
 
 24 
                "                  JOIN PartnerRegion pr ON pr.regionId = pp.regionId" +
- 
 
 25 
                "                  JOIN FofoStore fs ON fs.id = pp.fofoId" +
- 
 
 26 
                "         where p.authUserId = :authId and fs.active= true and p.categoryId = :categoryId")
- 
 
 27 
})
28 
public class Position {
 28 
public class Position {
29 
 
 29 
 
30 
    @Id
 30 
    @Id
31 
    @Column(name = "id", unique = true, updatable = false)
 31 
    @Column(name = "id", unique = true, updatable = false)
32 
    @GeneratedValue(strategy = GenerationType.IDENTITY)
 32 
    @GeneratedValue(strategy = GenerationType.IDENTITY)