| Line 6... |
Line 6... |
| 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 |
|
| 10 |
@Entity
|
10 |
@Entity
|
| 11 |
@Table(name = "fofo.scheme_in_out", schema = "fofo")
|
11 |
@Table(name = "fofo.scheme_in_out")
|
| 12 |
|
12 |
|
| 13 |
@NamedQueries({
|
13 |
@NamedQueries({
|
| 14 |
@NamedQuery(name = "SchemeInOut.selectPendingActivationGroupByBrandYearMonth", query = "select new com.spice.profitmandi.dao.model.ActivationYearMonthModel(i.brand, "
|
14 |
@NamedQuery(name = "SchemeInOut.selectPendingActivationGroupByBrandYearMonth", query = "select new com.spice.profitmandi.dao.model.ActivationYearMonthModel(i.brand, "
|
| 15 |
+ " DATE_FORMAT(sio.createTimestamp, '%m-%Y'),sum(cast(sio.amount As integer )) ) from Scheme sc join SchemeInOut sio on"
|
15 |
+ " DATE_FORMAT(sio.createTimestamp, '%m-%Y'),sum(cast(sio.amount As integer )) ) from Scheme sc join SchemeInOut sio on"
|
| 16 |
+ " sc.id = sio.schemeId join InventoryItem ii on ii.id = sio.inventoryItemId"
|
16 |
+ " sc.id = sio.schemeId join InventoryItem ii on ii.id = sio.inventoryItemId"
|