public Map<String, Object> sumCommodity(
String name, String startDate, String endDate, final Integer page, final Integer rows) {
List<SalesBean> sblist = new ArrayList<SalesBean>();
Map<String, Object> result =
reportDao.sumCommodity(name, startDate, endDate, (page - 1) * rows, rows);
List<?> list = (List<?>) result.get("list");
if (list != null && list.size() > 0) {
for (Object objs : list) {
Object[] obj = (Object[]) objs;
String commodityId = (String) obj[0];
String commodityName = (String) obj[1];
String commodityType = (String) obj[2];
Long num = obj[3] == null ? 0l : Long.valueOf(String.valueOf(obj[3]));
Double totalPrice = obj[4] == null ? 0d : Double.valueOf(String.valueOf(obj[4]));
Long storageNum = obj[5] == null ? 0l : Long.valueOf(String.valueOf(obj[5]));
SalesBean sb = new SalesBean();
sb.setCommodityId(commodityId);
sb.setCommodityName(commodityName);
sb.setCommodityType(commodityType);
sb.setStorageNum(storageNum);
sb.setTotalNum(num);
sb.setTotalPrice(totalPrice);
sblist.add(sb);
}
result.put("list", sblist);
}
return result;
}
public TotalBean sumTotal(String startDate, String endDate) {
TotalBean tb = new TotalBean();
if (startDate == null || startDate.length() <= 0 || endDate == null || endDate.length() <= 0) {
return tb;
}
List<?> list = reportDao.sumTotal(startDate, endDate);
if (list != null && list.size() > 0) {
for (Object obj : list) {
Object[] _obj = (Object[]) obj;
Object count = _obj[0];
count = count == null || String.valueOf(count).length() <= 0 ? 0 : count;
Object totalNum = _obj[1];
totalNum = totalNum == null || String.valueOf(totalNum).length() <= 0 ? 0 : totalNum;
Object totalPrice = _obj[2];
totalPrice =
totalPrice == null || String.valueOf(totalPrice).length() <= 0 ? 0 : totalPrice;
String type = (String) _obj[3];
if ("sales".equals(type)) {
// 销售
tb.setTotalSalesCount(Long.valueOf(count.toString()));
tb.setTotalSalesNum(Long.valueOf(totalNum.toString()));
tb.setTotalSalesPrice(Double.valueOf(totalPrice.toString()));
} else if ("purchase".equals(type)) {
// 采购
tb.setTotalPurchaseCount(Long.valueOf(count.toString()));
tb.setTotalPurchaseNum(Long.valueOf(totalNum.toString()));
tb.setTotalPurchasePrice(Double.valueOf(totalPrice.toString()));
} else if ("gift".equals(type)) {
// 赠送
tb.setGiftCount(Long.valueOf(count.toString()));
tb.setGiftNum(Long.valueOf(totalNum.toString()));
tb.setTotalGiftPurchasePrice(Double.valueOf(totalPrice.toString()));
}
}
}
return tb;
}
