Subversion Repositories SmartDukaan

Rev

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

Rev 36805 Rev 36834
Line 3... Line 3...
3 
import javax.persistence.*;
 3 
import javax.persistence.*;
4 
import java.time.LocalDate;
 4 
import java.time.LocalDate;
5 
import java.time.LocalDateTime;
 5 
import java.time.LocalDateTime;
6 
 
 6 
 
7 
@Entity
 7 
@Entity
- 
 
 8 
@NamedQueries({
- 
 
 9 
 
- 
 
 10 
        @NamedQuery(
- 
 
 11 
                name = "BeatSchedule.selectByUserIdAndDateRange",
- 
 
 12 
                query =
- 
 
 13 
                        "SELECT bs " +
- 
 
 14 
                                "FROM BeatSchedule bs, Beat b " +
- 
 
 15 
                                "WHERE bs.beatId = b.id " +
- 
 
 16 
                                "AND b.authUserId = :userId " +
- 
 
 17 
                                "AND b.active = true " +
- 
 
 18 
                                "AND bs.startDate <= :endDate " +
- 
 
 19 
                                "AND (bs.endDate IS NULL OR bs.endDate >= :startDate) " +
- 
 
 20 
                                "ORDER BY bs.startDate ASC"
- 
 
 21 
        )
- 
 
 22 
 
- 
 
 23 
})
8 
@Table(name = "user.beat_schedule")
 24 
@Table(name = "user.beat_schedule")
9 
public class BeatSchedule {
 25 
public class BeatSchedule {
10 
 
 26 
 
11 
    @Id
 27 
    @Id
12 
    @Column(name = "id", unique = true, updatable = false)
 28 
    @Column(name = "id", unique = true, updatable = false)