Subversion Repositories SmartDukaan

Rev

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

Rev 33443 Rev 33464
Line 114... Line 114...
114
                        "li.itemId )" +
114
                        "li.itemId )" +
115
                        "FROM Order o JOIN LineItem li on o.id = li.orderId " +
115
                        "FROM Order o JOIN LineItem li on o.id = li.orderId " +
116
                        "JOIN LineItemImei lii on li.id = lii.lineItemId " +
116
                        "JOIN LineItemImei lii on li.id = lii.lineItemId " +
117
                        "WHERE li.brand = 'Live Demo' " +
117
                        "WHERE li.brand = 'Live Demo' " +
118
                        "AND o.billingTimestamp between  :startDate and :endDate"
118
                        "AND o.billingTimestamp between  :startDate and :endDate"
-
 
119
        ),
-
 
120
 
-
 
121
        @NamedQuery(
-
 
122
                name = "Order.selectTodayPocoBilling",
-
 
123
                query = "select new com.spice.profitmandi.dao.model.LiveDemoOrderLineItemModel (" +
-
 
124
                        "o.id, " +
-
 
125
                        "o.invoiceNumber, " +
-
 
126
                        "o.billingTimestamp, " +
-
 
127
                        "o.retailerName, " +
-
 
128
                        "o.retailerCity, " +
-
 
129
                        "o.retailerPinCode, " +
-
 
130
                        "o.retailerState, " +
-
 
131
                        "lii.serialNumber, " +
-
 
132
                        "li.modelNumber, " +
-
 
133
                        "li.modelName, " +
-
 
134
                        "li.brand," +
-
 
135
                        "li.itemId )" +
-
 
136
                        "FROM Order o JOIN LineItem li on o.id = li.orderId " +
-
 
137
                        "JOIN LineItemImei lii on li.id = lii.lineItemId " +
-
 
138
                        "JOIN FofoStore fs on fs.id=o.retailerId "+
-
 
139
                        "WHERE li.brand = 'POCO' " +
-
 
140
                        "AND fs.internal = false " +
-
 
141
                        "AND o.billingTimestamp between  :startDate and :endDate"
119
        )
142
        )
120
 
143
 
121
 
144
 
122
 
145
 
123
})
146
})