Subversion Repositories SmartDukaan

Rev

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

Rev 31860 Rev 32044
Line 3... Line 3...
3 
import java.io.Serializable;
 3 
import java.io.Serializable;
4 
import java.time.LocalDate;
 4 
import java.time.LocalDate;
5 
import java.time.LocalDateTime;
 5 
import java.time.LocalDateTime;
6 
import java.time.format.DateTimeFormatter;
 6 
import java.time.format.DateTimeFormatter;
7 
 
 7 
 
8 
import javax.persistence.CascadeType;
 - 
 
9 
import javax.persistence.Column;
 8 
import javax.persistence.Column;
- 
 
 9 
import javax.persistence.ColumnResult;
- 
 
 10 
import javax.persistence.ConstructorResult;
10 
import javax.persistence.Convert;
 11 
import javax.persistence.Convert;
11 
import javax.persistence.Entity;
 12 
import javax.persistence.Entity;
12 
import javax.persistence.FetchType;
 - 
 
13 
import javax.persistence.GeneratedValue;
 13 
import javax.persistence.GeneratedValue;
14 
import javax.persistence.GenerationType;
 14 
import javax.persistence.GenerationType;
15 
import javax.persistence.Id;
 15 
import javax.persistence.Id;
16 
import javax.persistence.JoinColumn;
 - 
 
17 
import javax.persistence.ManyToOne;
 - 
 
18 
import javax.persistence.NamedNativeQueries;
 16 
import javax.persistence.NamedNativeQueries;
19 
import javax.persistence.NamedNativeQuery;
 17 
import javax.persistence.NamedNativeQuery;
20 
import javax.persistence.NamedQueries;
 18 
import javax.persistence.NamedQueries;
21 
import javax.persistence.NamedQuery;
 19 
import javax.persistence.NamedQuery;
- 
 
 20 
import javax.persistence.SqlResultSetMapping;
- 
 
 21 
import javax.persistence.SqlResultSetMappings;
22 
import javax.persistence.Table;
 22 
import javax.persistence.Table;
23 
import javax.persistence.Transient;
 23 
import javax.persistence.Transient;
24 
 
 24 
 
25 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
 25 
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
- 
 
 26 
import com.spice.profitmandi.dao.model.LastSaleDateModel;
26 
 
 27 
 
27 
@Entity
 28 
@Entity
28 
@Table(name = "fofo.fofo_order")
 29 
@Table(name = "fofo.fofo_order")
29 
 
 30 
 
30 
@NamedQueries({
 31 
@NamedQueries({
Line 71... Line 72...
71 
 
 72 
 
72 
 
 73 
 
73 
@NamedNativeQueries({
 74 
@NamedNativeQueries({
74 
 
 75 
 
75 
 
 76 
 
76 
        @NamedNativeQuery(name = "FofoOrder.getLastTertiaryByFofoId", query = "select fo.create_timestamp from  fofo.fofo_order fo where  fo.fofo_id = :fofoId order by fo.id desc limit 1"),
 77 
        @NamedNativeQuery(name = "FofoOrder.getLastTertiaryByFofoId", query = "select Max(fo.create_timestamp) from  fofo.fofo_order fo where fo.fofo_id = :fofoId and fo.cancelled_timestamp is null"),
77 
 
 78 
 
78 
 
 79 
 
- 
 
 80 
        @NamedNativeQuery(name = "FofoOrder.getLastTertiaryOrders", query = "select fo.fofo_id, Max(fo.create_timestamp) as maxdate from fofo.fofo_order fo where fo.cancelled_timestamp is null group by fofo_id", resultSetMapping = "LastTertiaryDays"),
- 
 
 81 
 
- 
 
 82 
 
- 
 
 83 
})
- 
 
 84 
 
- 
 
 85 
@SqlResultSetMappings({
- 
 
 86 
 
- 
 
 87 
        @SqlResultSetMapping(name = "LastTertiaryDays", classes = {@ConstructorResult(targetClass = LastSaleDateModel.class, columns = {@ColumnResult(name = "fofo_id", type = Integer.class), @ColumnResult(name = "maxdate ", type = LocalDateTime.class)})})
- 
 
 88 
 
79 
})
 89 
})
80 
 
 90 
 
81 
public class FofoOrder implements Serializable {
 91 
public class FofoOrder implements Serializable {
82 
 
 92 
 
83 
    private static final long serialVersionUID = 1L;
 93 
    private static final long serialVersionUID = 1L;