/*
* 统计销售
*/
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";
}
@SuppressWarnings("unchecked")
@Override
public String execute() throws Exception {
if (user.getNumber() != null
&& !"".equals(user.getNumber().trim())
&& user.getPassword() != null
&& !"".equals(user.getPassword())) {
if (userService.checkUser(user.getNumber(), user.getPassword())) {
user = userService.findByNumber(user.getNumber().trim());
session.put("user", user);
if (user.getVisible() == false) {
request.setAttribute("message", "对不起您的账号已被禁用，无法登陆系统！");
return INPUT;
}
if (user.getRole().toString().equals("SALESMANAGER")) return "salesmanager";
else if (user.getRole().toString().equals("SALESPEOPLE")) {
return "salespeople";
} else if (user.getRole().toString().equals("PRESALES")) {
return "presales";
} else if (user.getRole().toString().equals("BOSS")) {
return "boss";
} else if (user.getRole().toString().equals("STOCKANALYST")) {
return "stockanalyst";
} else if (user.getRole().toString().equals("SERVICE")) {
return "service";
} else if (user.getRole().toString().equals("PROXY")) {
return "proxy";
} else if (user.getRole().toString().equals("CHANNEL")) {
return "channel";
} else {
return SUCCESS;
}
} else {
request.setAttribute("message", "用户名或密码错误！");
return INPUT;
}
}
return INPUT;
}