Subversion Repositories SmartDukaan

Rev

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

Rev 32950 Rev 33010
Line 4... Line 4...
4 
import com.spice.profitmandi.dao.enumuration.catalog.OfferSchemeType;
 4 
import com.spice.profitmandi.dao.enumuration.catalog.OfferSchemeType;
5 
 
 5 
 
6 
import javax.persistence.*;
 6 
import javax.persistence.*;
7 
import java.io.Serializable;
 7 
import java.io.Serializable;
8 
import java.time.LocalDateTime;
 8 
import java.time.LocalDateTime;
- 
 
 9 
 
9 
@NamedQueries({
 10 
@NamedQueries({
10 
 
 11 
 
11 
 
 12 
 
12 
 
 13 
 
13 
		/*int id, String code, String name, String city, String state, String brand, String modelName,
 14 
		/*int id, String code, String name, String city, String state, String brand, String modelName,
Line 23... Line 24...
23 
				"JOIN OfferPayout op ON op.fofoId = fs.id " +
 24 
				"JOIN OfferPayout op ON op.fofoId = fs.id " +
24 
				"JOIN Offer o ON o.id = op.offerId " +
 25 
				"JOIN Offer o ON o.id = op.offerId " +
25 
				"LEFT JOIN InventoryItem ii ON ii.serialNumber = op.serialNumber " +
 26 
				"LEFT JOIN InventoryItem ii ON ii.serialNumber = op.serialNumber " +
26 
				"LEFT JOIN Item i ON i.id = ii.itemId " +
 27 
				"LEFT JOIN Item i ON i.id = ii.itemId " +
27 
				"WHERE (op.createTimestamp BETWEEN :startDate AND :endDate) " +
 28 
				"WHERE (op.createTimestamp BETWEEN :startDate AND :endDate) " +
28 
				"OR (op.rejectTimestamp BETWEEN :startDate AND :endDate)")
 29 
				"OR (op.rejectTimestamp BETWEEN :startDate AND :endDate)"+ "and op.fofoId= :fofoId")
29 
 
 30 
 
30 
 
 31 
 
31 
})
 32 
})
32 
@Entity
 33 
@Entity
33 
@Table(name = "catalog.offer")
 34 
@Table(name = "catalog.offer")