| Line 23... |
Line 23... |
| 23 |
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
|
23 |
import com.spice.profitmandi.dao.convertor.LocalDateTimeAttributeConverter;
|
| 24 |
import com.spice.profitmandi.dao.entity.catalog.Item;
|
24 |
import com.spice.profitmandi.dao.entity.catalog.Item;
|
| 25 |
import com.spice.profitmandi.dao.enumuration.fofo.ScanType;
|
25 |
import com.spice.profitmandi.dao.enumuration.fofo.ScanType;
|
| 26 |
|
26 |
|
| 27 |
@NamedQueries({
|
27 |
@NamedQueries({
|
| 28 |
@NamedQuery(name = "InventoryItem.selectCount", query = "select count(ii) from InventoryItem ii"),
|
- |
|
| 29 |
@NamedQuery(name = "InventoryItem.selectByItemId", query = "select ii from InventoryItem ii where ii.itemId = :itemId"),
|
- |
|
| 30 |
@NamedQuery(name = "InventoryItem.selectByFofoId", query = "select ii from InventoryItem ii where ii.fofoId = :fofoId"),
|
- |
|
| 31 |
@NamedQuery(
|
28 |
@NamedQuery(
|
| 32 |
name = "InventoryItem.selectScannedCount",
|
29 |
name = "InventoryItem.selectScannedCount",
|
| 33 |
query = "select ii.itemId, sum(ii.initialQuantity) from InventoryItem ii "
|
30 |
query = "select ii.itemId, sum(ii.initialQuantity) from InventoryItem ii "
|
| 34 |
+ "where ii.itemId in :itemIds and ii.fofoId = :fofoId and ii.purchaseId = :purchaseId group by ii.itemId"),
|
31 |
+ "where ii.itemId in :itemIds and ii.fofoId = :fofoId and ii.purchaseId = :purchaseId group by ii.itemId")
|
| 35 |
|
- |
|
| 36 |
@NamedQuery(
|
- |
|
| 37 |
name = "InventoryItem.selectBySerialNumbers",
|
- |
|
| 38 |
query = "select ii from InventoryItem ii where ii.serialNumber in :serialNumbers"),
|
- |
|
| 39 |
|
- |
|
| 40 |
@NamedQuery(
|
- |
|
| 41 |
name = "InventoryItem.selectSerialNumberBySerialNumbers",
|
- |
|
| 42 |
query = "select ii.serialNumber from InventoryItem ii where ii.serialNumber in :serialNumbers"),
|
- |
|
| 43 |
|
- |
|
| 44 |
})
|
32 |
})
|
| 45 |
@Entity
|
33 |
@Entity
|
| 46 |
@Table(name="fofo.inventory_item", schema = "fofo")
|
34 |
@Table(name="fofo.inventory_item", schema = "fofo")
|
| 47 |
public class InventoryItem {
|
35 |
public class InventoryItem {
|
| 48 |
|
36 |
|