package com.salesmanager.shop.admin.controller.products; import com.salesmanager.core.business.services.catalog.category.CategoryService; import com.salesmanager.core.business.services.catalog.product.ProductService; import com.salesmanager.core.business.services.catalog.product.relationship.ProductRelationshipService; import com.salesmanager.core.business.utils.ajax.AjaxPageableResponse; import com.salesmanager.core.business.utils.ajax.AjaxResponse; import com.salesmanager.core.model.catalog.category.Category; import com.salesmanager.core.model.catalog.product.Product; import com.salesmanager.core.model.catalog.product.description.ProductDescription; import com.salesmanager.core.model.catalog.product.relationship.ProductRelationship; import com.salesmanager.core.model.catalog.product.relationship.ProductRelationshipType; import com.salesmanager.core.model.merchant.MerchantStore; import com.salesmanager.core.model.reference.language.Language; import com.salesmanager.shop.admin.controller.ControllerConstants; import com.salesmanager.shop.admin.model.web.Menu; import com.salesmanager.shop.constants.Constants; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.http.HttpHeaders; import org.springframework.http.HttpStatus; import org.springframework.http.MediaType; import org.springframework.http.ResponseEntity; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import javax.inject.Inject; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Set; @Controller public class RelatedItemsController { private static final Logger LOGGER = LoggerFactory.getLogger(RelatedItemsController.class); @Inject CategoryService categoryService; @Inject ProductService productService; @Inject ProductRelationshipService productRelationshipService; @PreAuthorize("hasRole('PRODUCTS')") @RequestMapping(value="/admin/catalogue/related/list.html", method=RequestMethod.GET) public String displayRelatedItems(@RequestParam("id") long productId, Model model, HttpServletRequest request, HttpServletResponse response) throws Exception { setMenu(model,request); Language language = (Language)request.getAttribute("LANGUAGE"); MerchantStore store = (MerchantStore)request.getAttribute(Constants.ADMIN_STORE); //get the product and validate it belongs to the current merchant Product product = productService.getById(productId); if(product==null) { return "redirect:/admin/products/products.html"; } if(product.getMerchantStore().getId().intValue()!=store.getId().intValue()) { return "redirect:/admin/products/products.html"; } List<Category> categories = categoryService.listByStore(store,language); model.addAttribute("categories", categories); model.addAttribute("product", product); return ControllerConstants.Tiles.Product.relatedItems; } @SuppressWarnings({ "rawtypes", "unchecked" }) @PreAuthorize("hasRole('PRODUCTS')") @RequestMapping(value="/admin/catalogue/related/paging.html", method=RequestMethod.POST) public @ResponseBody ResponseEntity<String> pageRelatedItems(HttpServletRequest request, HttpServletResponse response) { String sProductId = request.getParameter("productId"); AjaxResponse resp = new AjaxResponse(); final HttpHeaders httpHeaders= new HttpHeaders(); httpHeaders.setContentType(MediaType.APPLICATION_JSON_UTF8); try { Long productId = Long.parseLong(sProductId); Product product = productService.getById(productId); Language language = (Language)request.getAttribute("LANGUAGE"); MerchantStore store = (MerchantStore)request.getAttribute(Constants.ADMIN_STORE); if(product==null || product.getMerchantStore().getId().intValue()!= store.getId().intValue()) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); resp.setErrorString("Product id is not valid"); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } List<ProductRelationship> relationships = productRelationshipService.getByType(store, product, ProductRelationshipType.RELATED_ITEM, language); for(ProductRelationship relationship : relationships) { Product relatedProduct = relationship.getRelatedProduct(); Map entry = new HashMap(); entry.put("relationshipId", relationship.getId()); entry.put("productId", relatedProduct.getId()); ProductDescription description = relatedProduct.getDescriptions().iterator().next(); Set<ProductDescription> descriptions = relatedProduct.getDescriptions(); for(ProductDescription desc : descriptions) { if(desc.getLanguage().getId().intValue()==language.getId().intValue()) { description = desc; } } entry.put("name", description.getName()); entry.put("sku", relatedProduct.getSku()); entry.put("available", relatedProduct.isAvailable()); resp.addDataEntry(entry); } resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_SUCCESS); } catch (Exception e) { LOGGER.error("Error while paging products", e); resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); resp.setErrorMessage(e); } String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } @PreAuthorize("hasRole('PRODUCTS')") @RequestMapping(value="/admin/catalogue/related/addItem.html", method=RequestMethod.POST) public @ResponseBody ResponseEntity<String> addItem(HttpServletRequest request, HttpServletResponse response) { String productId = request.getParameter("productId"); String baseProductId = request.getParameter("baseProductId"); AjaxResponse resp = new AjaxResponse(); final HttpHeaders httpHeaders= new HttpHeaders(); httpHeaders.setContentType(MediaType.APPLICATION_JSON_UTF8); try { Long lProductId = Long.parseLong(productId); Long lBaseProductId = Long.parseLong(baseProductId); MerchantStore store = (MerchantStore)request.getAttribute(Constants.ADMIN_STORE); Product product = productService.getById(lProductId); if(product==null) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } if(product.getMerchantStore().getId().intValue()!=store.getId().intValue()) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } Product baseProduct = productService.getById(lBaseProductId); if(baseProduct==null) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } if(baseProduct.getMerchantStore().getId().intValue()!=store.getId().intValue()) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } ProductRelationship relationship = new ProductRelationship(); relationship.setActive(true); relationship.setProduct(baseProduct); relationship.setCode(ProductRelationshipType.RELATED_ITEM.name()); relationship.setStore(store); relationship.setRelatedProduct(product); productRelationshipService.saveOrUpdate(relationship); resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_SUCCESS); } catch (Exception e) { LOGGER.error("Error while paging products", e); resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); resp.setErrorMessage(e); } String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } @PreAuthorize("hasRole('PRODUCTS')") @RequestMapping(value="/admin/catalogue/related/removeItem.html", method=RequestMethod.POST) public @ResponseBody ResponseEntity<String> removeItem(HttpServletRequest request, HttpServletResponse response) { String productId = request.getParameter("productId"); String baseProductId = request.getParameter("baseProductId"); AjaxResponse resp = new AjaxResponse(); final HttpHeaders httpHeaders= new HttpHeaders(); httpHeaders.setContentType(MediaType.APPLICATION_JSON_UTF8); try { Long lproductId = Long.parseLong(productId); Long lBaseProductId = Long.parseLong(baseProductId); MerchantStore store = (MerchantStore)request.getAttribute(Constants.ADMIN_STORE); Product product = productService.getById(lproductId); if(product==null) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } if(product.getMerchantStore().getId().intValue()!=store.getId().intValue()) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } Product baseProduct = productService.getById(lBaseProductId); if(baseProduct==null) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } if(baseProduct.getMerchantStore().getId().intValue()!=store.getId().intValue()) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } ProductRelationship relationship = null; List<ProductRelationship> relationships = productRelationshipService.getByType(store, baseProduct, ProductRelationshipType.RELATED_ITEM); for(ProductRelationship r : relationships) { if(r.getRelatedProduct().getId().longValue()==lproductId.longValue()) { relationship = r; break; } } if(relationship==null) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } if(relationship.getStore().getId().intValue()!=store.getId().intValue()) { resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } productRelationshipService.delete(relationship); resp.setStatus(AjaxPageableResponse.RESPONSE_OPERATION_COMPLETED); } catch (Exception e) { LOGGER.error("Error while paging products", e); resp.setStatus(AjaxPageableResponse.RESPONSE_STATUS_FAIURE); resp.setErrorMessage(e); } String returnString = resp.toJSONString(); return new ResponseEntity<String>(returnString,httpHeaders,HttpStatus.OK); } private void setMenu(Model model, HttpServletRequest request) throws Exception { //display menu Map<String,String> activeMenus = new HashMap<String,String>(); activeMenus.put("catalogue", "catalogue"); activeMenus.put("catalogue-products", "catalogue-products"); @SuppressWarnings("unchecked") Map<String, Menu> menus = (Map<String, Menu>)request.getAttribute("MENUMAP"); Menu currentMenu = (Menu)menus.get("catalogue"); model.addAttribute("currentMenu",currentMenu); model.addAttribute("activeMenus",activeMenus); // } }