Subversion Repositories SmartDukaan

Rev

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

Rev 35040 Rev 35420
Line 234... Line 234...
234
 
234
 
235
    <T> List<T> selectAllByOr(Class<T> class1, List<Map<String, Object>> equalsMapList);
235
    <T> List<T> selectAllByOr(Class<T> class1, List<Map<String, Object>> equalsMapList);
236
 
236
 
237
    <T> List<SimpleEntry> selectLatestGroupBy(Class<T> class1, String groupBy, String keyColumn, List<Integer> assignedTo, LocalDateTime startDate, LocalDateTime endDate);
237
    <T> List<SimpleEntry> selectLatestGroupBy(Class<T> class1, String groupBy, String keyColumn, List<Integer> assignedTo, LocalDateTime startDate, LocalDateTime endDate);
238
 
238
 
-
 
239
    /**
-
 
240
     * Selects valueColumn grouped by groupBy, where the row is determined by MAX of maxColumn.
-
 
241
     * Supports filtering via equalsMap (supports DateRangeModel for date range filters).
-
 
242
     *
-
 
243
     * @param class1 Entity class
-
 
244
     * @param groupBy Column to group by (e.g., "leadId")
-
 
245
     * @param valueColumn Column whose value to return (e.g., "schelduleTimestamp")
-
 
246
     * @param maxColumn Column to find MAX of to determine the row (e.g., "createdTimestamp")
-
 
247
     * @param equalsMap Filter conditions (supports DateRangeModel for date ranges)
-
 
248
     * @return List of SimpleEntry with groupBy value as key and valueColumn value as value
-
 
249
     */
-
 
250
    <T> List<SimpleEntry> selectValueByMaxOfAnotherColumn(Class<T> class1, String groupBy, String valueColumn, String maxColumn, Map<String, Object> equalsMap);
-
 
251
 
239
    <T> List<T> selectBetweenKeys(Class<T> tClass, String startKey, Object value, String endKey);
252
    <T> List<T> selectBetweenKeys(Class<T> tClass, String startKey, Object value, String endKey);
240
 
253
 
241
    <T> void deleteAll(Class<T> tClass);
254
    <T> void deleteAll(Class<T> tClass);
242
 
255
 
243
    public List<Map<String, Object>> executeRawSqlAsListMap(String sql, List<Object> params);
256
    public List<Map<String, Object>> executeRawSqlAsListMap(String sql, List<Object> params);