| Line 20... |
Line 20... |
| 20 |
|
20 |
|
| 21 |
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
|
21 |
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
|
| 22 |
import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
|
22 |
import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
|
| 23 |
|
23 |
|
| 24 |
@Entity
|
24 |
@Entity
|
| 25 |
@Table(name = "fofo.pending_order_item", schema = "fofo", uniqueConstraints = {
|
25 |
@Table(name = "fofo.pending_order_item", uniqueConstraints = {
|
| 26 |
@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 |
|
27 |
|
| 28 |
@NamedQueries({
|
28 |
@NamedQueries({
|
| 29 |
@NamedQuery(name = "PendingOrderItem.selectSumSellingPriceOnlineOrder", query = "select new com.spice.profitmandi.common.model.OnlineDeliveredOrderSum("
|
29 |
@NamedQuery(name = "PendingOrderItem.selectSumSellingPriceOnlineOrder", query = "select new com.spice.profitmandi.common.model.OnlineDeliveredOrderSum("
|
| 30 |
+ "SUM(CAST(poi.sellingPrice AS int)))"
|
30 |
+ "SUM(CAST(poi.sellingPrice AS int)))"
|