| Line 10... |
Line 10... |
| 10 |
import javax.persistence.EnumType;
|
10 |
import javax.persistence.EnumType;
|
| 11 |
import javax.persistence.Enumerated;
|
11 |
import javax.persistence.Enumerated;
|
| 12 |
import javax.persistence.GeneratedValue;
|
12 |
import javax.persistence.GeneratedValue;
|
| 13 |
import javax.persistence.GenerationType;
|
13 |
import javax.persistence.GenerationType;
|
| 14 |
import javax.persistence.Id;
|
14 |
import javax.persistence.Id;
|
| - |
|
15 |
import javax.persistence.NamedQueries;
|
| - |
|
16 |
import javax.persistence.NamedQuery;
|
| 15 |
import javax.persistence.Table;
|
17 |
import javax.persistence.Table;
|
| 16 |
import javax.persistence.Transient;
|
18 |
import javax.persistence.Transient;
|
| 17 |
import javax.persistence.UniqueConstraint;
|
19 |
import javax.persistence.UniqueConstraint;
|
| 18 |
|
20 |
|
| 19 |
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
|
21 |
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
|
| 20 |
import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
|
22 |
import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
|
| 21 |
|
23 |
|
| 22 |
@Entity
|
24 |
@Entity
|
| 23 |
@Table(name = "fofo.pending_order_item", schema = "fofo", uniqueConstraints = {
|
25 |
@Table(name = "fofo.pending_order_item", schema = "fofo", uniqueConstraints = {
|
| 24 |
@UniqueConstraint(name = "UK_ORDER_ID_AND_ITEM_ID", columnNames = { "order_id", "item_id" }) })
|
26 |
@UniqueConstraint(name = "UK_ORDER_ID_AND_ITEM_ID", columnNames = { "order_id", "item_id" }), })
|
| - |
|
27 |
|
| - |
|
28 |
@NamedQueries({
|
| - |
|
29 |
@NamedQuery(name = "PendingOrderItem.selectSumSellingPriceOnlineOrder", query = "select new com.spice.profitmandi.common.model.OnlineDeliveredOrderSum("
|
| - |
|
30 |
+ "SUM(CAST(poi.sellingPrice AS int)))"
|
| - |
|
31 |
+ " from PendingOrder po join PendingOrderItem poi on po.id = poi.orderId"
|
| - |
|
32 |
+ " where po.fofoId = :fofoId and po.createTimestamp between :startDate and :endDate and poi.deliveredTimestamp is not null and poi.cancelledTimestamp is null"),
|
| - |
|
33 |
|
| - |
|
34 |
})
|
| - |
|
35 |
|
| 25 |
public class PendingOrderItem implements Serializable {
|
36 |
public class PendingOrderItem implements Serializable {
|
| 26 |
|
37 |
|
| 27 |
public OrderStatus getStatus() {
|
38 |
public OrderStatus getStatus() {
|
| 28 |
return status;
|
39 |
return status;
|
| 29 |
}
|
40 |
}
|