Subversion Repositories SmartDukaan

Rev

Rev 36586 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 36586 Rev 37319
Line 107... Line 107...
107 
                        "FROM FofoOrder fo " +
 107 
                        "FROM FofoOrder fo " +
108 
                        "JOIN FofoOrderItem foi ON fo.id = foi.orderId " +
 108 
                        "JOIN FofoOrderItem foi ON fo.id = foi.orderId " +
109 
                        "WHERE fo.cancelledTimestamp IS NULL " +
 109 
                        "WHERE fo.cancelledTimestamp IS NULL " +
110 
                        "AND fo.createTimestamp >= :lmtdStartDate " +
 110 
                        "AND fo.createTimestamp >= :lmtdStartDate " +
111 
                        "GROUP BY fo.fofoId"
 111 
                        "GROUP BY fo.fofoId"
- 
 
 112 
        ),
- 
 
 113 
 
- 
 
 114 
        @NamedQuery(name = "FofoOrder.selectMonthlyBrandTertiary",
- 
 
 115 
                query = "select new com.spice.profitmandi.dao.model.MonthlyBrandTertiaryModel(" +
- 
 
 116 
                        "(year(fo.createTimestamp)*100 + month(fo.createTimestamp)), foi.brand, " +
- 
 
 117 
                        "sum(CAST(foi.quantity*foi.mop AS long))) " +
- 
 
 118 
                        "FROM FofoOrder fo " +
- 
 
 119 
                        "JOIN FofoOrderItem foi ON fo.id = foi.orderId " +
- 
 
 120 
                        "WHERE fo.fofoId = :fofoId " +
- 
 
 121 
                        "AND fo.cancelledTimestamp IS NULL " +
- 
 
 122 
                        "AND fo.createTimestamp BETWEEN :startDate AND :endDate " +
- 
 
 123 
                        "GROUP BY (year(fo.createTimestamp)*100 + month(fo.createTimestamp)), foi.brand"
112 
        )
 124 
        )
113 
 
 125 
 
114 
 
 126 
 
115 
})
 127 
})
116 
 
 128