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 
})