/*
* 统计销售
*/
public String salespeople() {
PageView<User> pageView = new PageView<User>(12, this.getPage());
LinkedHashMap<String, String> orderby = new LinkedHashMap<String, String>();
orderby.put("realname", "desc");
StringBuilder sb = new StringBuilder();
List<Object> params = new ArrayList<Object>();
sb.append("o.proxy=?").append(params.size() + 1);
params.add(((User) session.get("user")).getProxy());
sb.append(" and o.role=?").append(params.size() + 1);
params.add(Role.SALESPEOPLE);
if ("true".equals(this.getQuery())) {
if (user.getNumber() != null && !"".equals(user.getNumber().trim())) {
sb.append(" and ");
sb.append(" o.number=?").append(params.size() + 1);
params.add(user.getNumber());
}
if (user.getRealname() != null && !"".equals(user.getRealname().trim())) {
if (params.size() > 0) sb.append(" and ");
sb.append(" o.realname like ?").append(params.size() + 1);
params.add("%" + user.getRealname() + "%");
}
pageView.setQueryResult(
userService.getScrollData(
pageView.getFirstResult(),
pageView.getMaxresult(),
sb.toString(),
params.toArray(),
orderby));
} else {
pageView.setQueryResult(
userService.getScrollData(
pageView.getFirstResult(),
pageView.getMaxresult(),
sb.toString(),
params.toArray(),
orderby));
}
request.setAttribute("pageView", pageView);
return "salespeople";
}
