| Line 6... |
Line 6... |
| 6 |
|
6 |
|
| 7 |
import javax.persistence.CascadeType;
|
7 |
import javax.persistence.CascadeType;
|
| 8 |
import javax.persistence.Column;
|
8 |
import javax.persistence.Column;
|
| 9 |
import javax.persistence.Convert;
|
9 |
import javax.persistence.Convert;
|
| 10 |
import javax.persistence.Entity;
|
10 |
import javax.persistence.Entity;
|
| - |
|
11 |
import javax.persistence.EntityResult;
|
| 11 |
import javax.persistence.EnumType;
|
12 |
import javax.persistence.EnumType;
|
| 12 |
import javax.persistence.Enumerated;
|
13 |
import javax.persistence.Enumerated;
|
| 13 |
import javax.persistence.FetchType;
|
14 |
import javax.persistence.FetchType;
|
| - |
|
15 |
import javax.persistence.FieldResult;
|
| 14 |
import javax.persistence.GeneratedValue;
|
16 |
import javax.persistence.GeneratedValue;
|
| 15 |
import javax.persistence.GenerationType;
|
17 |
import javax.persistence.GenerationType;
|
| 16 |
import javax.persistence.Id;
|
18 |
import javax.persistence.Id;
|
| 17 |
import javax.persistence.JoinColumn;
|
19 |
import javax.persistence.JoinColumn;
|
| 18 |
import javax.persistence.ManyToOne;
|
20 |
import javax.persistence.ManyToOne;
|
| - |
|
21 |
import javax.persistence.NamedNativeQueries;
|
| - |
|
22 |
import javax.persistence.NamedNativeQuery;
|
| 19 |
import javax.persistence.NamedQueries;
|
23 |
import javax.persistence.NamedQueries;
|
| 20 |
import javax.persistence.NamedQuery;
|
24 |
import javax.persistence.NamedQuery;
|
| - |
|
25 |
import javax.persistence.SqlResultSetMapping;
|
| 21 |
import javax.persistence.Table;
|
26 |
import javax.persistence.Table;
|
| 22 |
|
27 |
|
| 23 |
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
|
28 |
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
|
| - |
|
29 |
import com.spice.profitmandi.dao.model.PartnerSecondaryPlanModel;
|
| 24 |
|
30 |
|
| 25 |
import in.shop2020.model.v1.order.OrderStatus;
|
31 |
import in.shop2020.model.v1.order.OrderStatus;
|
| 26 |
import in.shop2020.model.v1.order.TaxType;
|
32 |
import in.shop2020.model.v1.order.TaxType;
|
| 27 |
|
33 |
|
| 28 |
/**
|
34 |
/**
|
| Line 183... |
Line 189... |
| 183 |
+ " case when psp.secondaryPlan is not null then cast(psp.secondaryPlan As long) else 0 end , sum(cast(o.totalAmount AS integer)),"
|
189 |
+ " case when psp.secondaryPlan is not null then cast(psp.secondaryPlan As long) else 0 end , sum(cast(o.totalAmount AS integer)),"
|
| 184 |
+ " psp.authId )"
|
190 |
+ " psp.authId )"
|
| 185 |
+ " from FofoStore fs left join Order o on (fs.id = o.retailerId and o.status in (7,9,10,12)"
|
191 |
+ " from FofoStore fs left join Order o on (fs.id = o.retailerId and o.status in (7,9,10,12)"
|
| 186 |
+ " and o.billingTimestamp >= :startDate and o.billingTimestamp <= :endDate ) left join LineItem li on o.id = li.orderId left join "
|
192 |
+ " and o.billingTimestamp >= :startDate and o.billingTimestamp <= :endDate ) left join LineItem li on o.id = li.orderId left join "
|
| 187 |
+ " PartnerSecondaryPlan psp on (psp.fofoId = fs.id and psp.createTimestamp >= :startDate "
|
193 |
+ " PartnerSecondaryPlan psp on (psp.fofoId = fs.id and psp.createTimestamp >= :startDate "
|
| 188 |
+ " and psp.createTimestamp <= :endDate and psp.active = 1 and li.brand=psp.brand)"
|
194 |
+ " and psp.createTimestamp <= :endDate and psp.active = 1 )"
|
| 189 |
+ " where fs.id in :fofoIds and fs.internal = 0 group by li.brand,psp.brand,fs.id"),
|
195 |
+ " where fs.id in :fofoIds and fs.internal = 0 group by li.brand,psp.brand,fs.id"),
|
| 190 |
|
196 |
|
| 191 |
})
|
197 |
})
|
| - |
|
198 |
|
| 192 |
public class Order implements Serializable {
|
199 |
public class Order implements Serializable {
|
| 193 |
|
200 |
|
| 194 |
private static final long serialVersionUID = 1L;
|
201 |
private static final long serialVersionUID = 1L;
|
| 195 |
|
202 |
|
| 196 |
public Order() {
|
203 |
public Order() {
|