| Line 10... |
Line 10... |
| 10 |
import javax.persistence.NamedQueries;
|
10 |
import javax.persistence.NamedQueries;
|
| 11 |
import javax.persistence.NamedQuery;
|
11 |
import javax.persistence.NamedQuery;
|
| 12 |
import javax.persistence.Table;
|
12 |
import javax.persistence.Table;
|
| 13 |
|
13 |
|
| 14 |
@Entity
|
14 |
@Entity
|
| 15 |
@Table(name = "dtr.brands_limit", schema = "dtr")
|
15 |
@Table(name = "dtr.brands_limit")
|
| 16 |
|
16 |
|
| 17 |
@NamedQueries({
|
17 |
@NamedQueries({
|
| 18 |
@NamedQuery(name = "BrandLimit.selectAllPartnerBrandLimit", query = "select new com.spice.profitmandi.dao.model.PartnerBrandLimit(fs.id,bl.brandName,"
|
18 |
@NamedQuery(name = "BrandLimit.selectAllPartnerBrandLimit", query = "select new com.spice.profitmandi.dao.model.PartnerBrandLimit(fs.id,bl.brandName,"
|
| 19 |
+ " case when rbl.partnerId is null then bl.stockLimit else rbl.minStockLimit end) "
|
19 |
+ " case when rbl.partnerId is null then bl.stockLimit else rbl.minStockLimit end) "
|
| 20 |
+ " from FofoStore fs join BrandLimit bl on 1=1"
|
20 |
+ " from FofoStore fs join BrandLimit bl on 1=1"
|