package pl.zgora.uz.wmie.fe.admin.ajax.table.action;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import org.hibernate.criterion.Criterion;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.ProjectionList;
import org.hibernate.criterion.Projections;
import pl.zgora.uz.wmie.fe.gui.common.util.FiltersUtil;
import pl.zgora.uz.wmie.fe.sps.business.dto.DataResult;
import pl.zgora.uz.wmie.fe.sps.business.service.OfferService;
import pl.zgora.uz.wmie.fe.sps.business.util.BusinessUtil;
import pl.zgora.uz.wmie.fe.sps.database.classes.Offer;
public class OfferTableAjaxAction extends BaseTableAjaxAction {
private static final int ROW_AMOUNT = 10;
@Override
public DataResult tableAjax(Map<String, String> filters,
String[] projections, String columnOrder, String columnOrderDir,
int startIndex) throws Exception {
OfferService offerService = (OfferService) BusinessUtil
.findBusiness("OfferService");
ProjectionList projectionList = Projections.projectionList();
for (int i = 0; i < projections.length; i++) {
projectionList.add(Projections.property(projections[i]));
}
List<Criterion> criterions = new ArrayList<Criterion>();
FiltersUtil filtersUtil = new FiltersUtil();
criterions = filtersUtil
.createCriteriaFromFilters(filters, Offer.class);
List<Order> orders = null;
// stala czesc sluzaca sortowaniu
if (columnOrder.compareTo("null") != 0) {
orders = new ArrayList<Order>();
if (columnOrderDir.compareTo("desc") == 0) {
orders.add(Order.desc(columnOrder));
} else {
orders.add(Order.asc(columnOrder));
}
}
startIndex = (startIndex - 1) * ROW_AMOUNT;
DataResult dataResult = offerService.findByParams(projectionList,
criterions, orders, startIndex, ROW_AMOUNT);
return dataResult;
}
}