// Sending request------------------------------------------------------------------
@RequestMapping(value = "/sendRequest", method = RequestMethod.GET)
public ModelAndView sendRequest(@RequestParam int teamId) {
ModelAndView result;
Collection<Team> teams;
Collection<Team> teamsRequested = new ArrayList<Team>();
Team team;
Boolean showSend = true;
Collection<RequestTeam> requestTeam;
User principal;
principal = userService.findByPrincipal();
team = teamService.findOne(teamId);
requestTeamService.sendRequest(teamId);
teams = teamService.findAllOtherUser(principal.getId());
requestTeam = requestTeamService.findAllRequestSendFromUser(principal.getId());
for (RequestTeam r : requestTeam) {
teamsRequested.add(r.getTeam());
}
result = new ModelAndView("team/list");
result.addObject("teams", teams);
result.addObject("teamsRequested", teamsRequested);
result.addObject("showSend", showSend);
result.addObject("requestURI", "team/user/listAllTeams.do");
return result;
}
public Collection<Team> findAllTeamsByUserId() {
Collection<Team> all;
User user;
int userId;
user = userService.findByPrincipal();
userId = user.getId();
all = teamRepository.findAllTeamsByUserId(userId);
return all;
}
/** 用户自己创建的班级购 */
@Action(
value = "myGroupon",
interceptorRefs = {@InterceptorRef(value = "userActionStack")},
results = {@Result(name = SUCCESS, location = "/userPages/groupon.jsp")})
public String myGroupon() {
User sessionUser = (User) ServletActionContext.getRequest().getSession().getAttribute("user");
// 获得这个学校所有的团购项目
List<Groupon> groupons = grouponService.userGrounpons(sessionUser.getId());
ServletActionContext.getContext().getValueStack().set("search", 1);
ServletActionContext.getContext().getValueStack().set("groupons", groupons);
return SUCCESS;
}
// 1 团购增删改查
@Action(
value = "grouponOpePage",
interceptorRefs = {@InterceptorRef(value = "userActionStack")},
results = {@Result(name = SUCCESS, location = "/userPages/grouponindex.jsp")})
public String grouponOpePage() {
User sessionUser = (User) ServletActionContext.getRequest().getSession().getAttribute("user");
Groupon findGroupon = null;
if (groupon.getId() != null && groupon.getId() != 0) {
findGroupon = grouponService.getGrouponDetail(groupon.getId());
if (findGroupon == null && !findGroupon.getUser().getId().equals(sessionUser.getId())) {
findGroupon = null;
}
}
ServletActionContext.getContext().getValueStack().set("groupon", findGroupon);
return SUCCESS;
}
// Listing------------------------------------------------------------------
@RequestMapping(value = "/list", method = RequestMethod.GET)
public ModelAndView list() {
ModelAndView result;
Collection<RequestTeam> requestTeams;
User principal;
principal = userService.findByPrincipal();
requestTeams = requestTeamService.findAllRequestTeamUser(principal.getId());
result = new ModelAndView("requestTeam/list");
result.addObject("requestTeams", requestTeams);
result.addObject("requestURI", "requestTeam/user/list.do");
return result;
}
/**
* 数据库操作 更新个人用户数据
*
* @param user
*/
public void updateinfo(User user) {
QueryRunner queryRunner = new QueryRunner(JdbcUtils.getDataSource());
String sql =
"UPDATE user SET username = ?, password = ?, sex = ?, profession = ?, favourite = ?, note = ? WHERE id = ?;";
try {
queryRunner.update(
sql,
new Object[] {
user.getUsername(),
user.getPassword(),
user.getSex(),
user.getProfession(),
user.getFavourite(),
user.getNote(),
user.getId()
});
} catch (SQLException e) {
e.printStackTrace();
}
}
// 1 进入团购的页面
@Action(
value = "nextGrouponitemPage",
interceptorRefs = {@InterceptorRef(value = "userActionStack")},
results = {
@Result(name = SUCCESS, location = "/userPages/grouponitem.jsp"),
@Result(name = "over", location = "/userPages/cart.jsp")
})
public String nextGrouponitemPage() {
User findUser = (User) ServletActionContext.getRequest().getSession().getAttribute("user");
// if()
Groupon find = grouponService.getGroupon(groupon.getId());
Grouponitem grouponitem = new Grouponitem();
grouponitem.setId(page);
grouponitem.setGroupon(find);
Grouponitem findItem = grouponService.next(grouponitem);
// 如果没有找到,那么意味着查询已经结束
if (findItem == null) {
double fee = 0.0;
int num = 0;
List<Cart> result = new ArrayList<Cart>();
List<Cartitem> items = cartService.getGrouponitemsByUser(findUser.getId(), find.getId());
for (int i = 0; i < items.size(); i++) {
Cartitem cartitem = items.get(i);
num += cartitem.getNum();
if (cartitem.getSalesBook() == null) {
if (cartitem.getBook().getDiscount() == 0.0) {
cartitem.getBook().setDiscount(ConstantUtil.NEWBOOKDISCOUNT);
}
SalesBook newbookSalesBook =
salesBookService.getSalesBookByIsbnSeller(
cartitem.getBook().getIsbn(), ConstantUtil.NEWBOOKPRODUCT);
float discount = ConstantUtil.NEWBOOKDISCOUNT;
if (newbookSalesBook != null && newbookSalesBook.getDiscount() != null) {
discount = newbookSalesBook.getDiscount();
}
fee +=
cartitem.getNum() * Math.round(cartitem.getBook().getPrice() * discount * 10) / 10d;
} else {
fee += cartitem.getNum() * cartitem.getSalesBook().getPrice();
}
Cart cart = cartitem.getCart();
Cart findCart = getCartByList(cart.getId(), result);
if (findCart == null) {
Cart cartResult = new Cart();
cartResult.setId(cart.getId());
cartResult.setSeller(cart.getSeller());
cartResult.setCartitems(new HashSet());
cartResult.setTotalFee(cart.getTotalFee());
cartResult.setUser(cart.getUser());
cartResult.getCartitems().add(cartitem);
cartitem.setCart(cartResult);
result.add(cartResult);
} else {
findCart.getCartitems().add(cartitem);
cartitem.setCart(findCart);
}
}
System.out.println(result.size());
ActionContext.getContext().getValueStack().set("carts", result);
ActionContext.getContext().getValueStack().set("num", num);
ActionContext.getContext().getValueStack().set("fee", Math.round(fee * 10) / 10d);
return "over";
}
Book book = bookService.getBookByIsbn(findItem.getBook().getIsbn());
// 如果没有拿到数据，则返回空
ServiceArea serviceArea = findUser.getSchool().getServiceArea();
// 如果找到了，查看新书供应商有没有此数据，如果没有，那么就给新书供应商加进去
SalesBook newbookSalesBook =
salesBookService.getSalesBookByIsbnSeller(
findItem.getBook().getIsbn(), ConstantUtil.NEWBOOKPRODUCT);
Seller seller = sellerService.getSellerById(ConstantUtil.NEWBOOKPRODUCT);
SalesBook model =
salesBookService.getSalesBookByIsbnSeller(findItem.getBook().getIsbn(), seller.getId());
float bookDiscount;
if (newbookSalesBook == null) {
newbookSalesBook = new SalesBook();
newbookSalesBook.setSeller(seller);
newbookSalesBook.setBook(book);
newbookSalesBook.setTitle(book.getTitle());
newbookSalesBook.setAuthor(book.getAuthor());
newbookSalesBook.setStandardPrice(book.getPrice());
newbookSalesBook.setPublisher(book.getPublisher());
newbookSalesBook.setImage(book.getImage());
newbookSalesBook.setBigImage(book.getBigImage());
salesBookService.save(newbookSalesBook);
}
if (model == null) {
model = newbookSalesBook;
}
if (newbookSalesBook.getDiscount() == null) {
bookDiscount = ConstantUtil.NEWBOOKDISCOUNT;
} else {
bookDiscount = newbookSalesBook.getDiscount();
}
ActionContext.getContext().getValueStack().set("bookDiscount", bookDiscount);
newbookSalesBook.setDiscount(bookDiscount);
newbookSalesBook.setPrice(
Math.round(newbookSalesBook.getBook().getPrice() * bookDiscount * 10) / 10d);
newbookSalesBook.setNum(999);
SalesBook salesBook = newbookSalesBook;
School findSchool = findUser.getSchool();
List<SellerBean> sellerBeans =
salesBookService.getSellerBeans(
newbookSalesBook.getBook().getIsbn(), findSchool.getServiceArea().getId());
int totalNum = cartService.getGrouponitemsByUser(findUser.getId(), find.getId()).size();
ActionContext.getContext().getValueStack().set("sellerBeans", sellerBeans);
ActionContext.getContext().getValueStack().set("item", findItem);
Seller newBookSeller = sellerService.getSellerById(ConstantUtil.NEWBOOKPRODUCT);
ActionContext.getContext().getValueStack().set("totalNum", totalNum);
ActionContext.getContext().getValueStack().set("model", model);
ActionContext.getContext().getValueStack().set("newBookSeller", newBookSeller);
ActionContext.getContext()
.getValueStack()
.set("price", Math.round(newbookSalesBook.getBook().getPrice() * bookDiscount * 10) / 10d);
// 获得这个学校所有的团购项目
return SUCCESS;
}