Subversion Repositories SmartDukaan

Rev

Rev 34641 | Rev 35464 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 34641 Rev 35458
Line 3... Line 3...
3 
import javax.persistence.*;
 3 
import javax.persistence.*;
4 
import java.time.LocalDateTime;
 4 
import java.time.LocalDateTime;
5 
import java.util.Objects;
 5 
import java.util.Objects;
6 
 
 6 
 
7 
@Entity
 7 
@Entity
8 
@Table(name = "fofo.activated_imei")
 8 
	@Table(name = "fofo.activated_imei")
9 
 
 9 
 
10 
@NamedQueries({
 10 
@NamedQueries({
11 
 
 11 
 
12 
		@NamedQuery(name = "ActivatedImei.selectActivatedModelGroupByBrand", query = "select new com.spice.profitmandi.dao.model.BrandWiseActivatedModel(li.brand, "
 12 
		@NamedQuery(name = "ActivatedImei.selectActivatedModelGroupByBrand", query = "select new com.spice.profitmandi.dao.model.BrandWiseActivatedModel(li.brand, "
13 
				+ "sum(case when concat(year(ai.activationTimestamp), month(ai.activationTimestamp))= :lms then 1 else 0 end),"
 13 
				+ "sum(case when concat(year(ai.activationTimestamp), month(ai.activationTimestamp))= :lms then 1 else 0 end),"