| Line 17... |
Line 17... |
| 17 |
/**
|
17 |
/**
|
| 18 |
* @author amit
|
18 |
* @author amit
|
| 19 |
*
|
19 |
*
|
| 20 |
*/
|
20 |
*/
|
| 21 |
@Entity
|
21 |
@Entity
|
| 22 |
@Table(name = "transaction.price_drop", schema = "transaction")
|
22 |
@Table(name = "transaction.price_drop")
|
| 23 |
|
23 |
|
| 24 |
@NamedQueries(value = {
|
24 |
@NamedQueries(value = {
|
| 25 |
@NamedQuery(name = "PriceDrop.selectBrandPendingPriceDropByYearMonth", query = "select new com.spice.profitmandi.dao.model.PriceDropYearMonthModel(i.brand, "
|
25 |
@NamedQuery(name = "PriceDrop.selectBrandPendingPriceDropByYearMonth", query = "select new com.spice.profitmandi.dao.model.PriceDropYearMonthModel(i.brand, "
|
| 26 |
+ " DATE_FORMAT(pd.affectedOn, '%m-%Y'),sum(cast(pd.amount As integer )) ) from PriceDrop pd join PriceDropIMEI pdi on"
|
26 |
+ " DATE_FORMAT(pd.affectedOn, '%m-%Y'),sum(cast(pd.amount As integer )) ) from PriceDrop pd join PriceDropIMEI pdi on"
|
| 27 |
+ " (pd.id = pdi.priceDropId) join InventoryItem it on (pdi.imei = it.serialNumber and pdi.partnerId=it.fofoId)"
|
27 |
+ " (pd.id = pdi.priceDropId) join InventoryItem it on (pdi.imei = it.serialNumber and pdi.partnerId=it.fofoId)"
|