Subversion Repositories SmartDukaan

package com.spice.profitmandi.web.controller;

import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

import javax.servlet.http.HttpServletRequest;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;

import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
import com.spice.profitmandi.common.model.CustomCurrentInventorySnapshot;
import com.spice.profitmandi.common.model.ProfitMandiConstants;
import com.spice.profitmandi.dao.entity.FofoItemId;
import com.spice.profitmandi.dao.entity.InventoryItem;
import com.spice.profitmandi.dao.repository.CurrentInventorySnapshotRepository;
import com.spice.profitmandi.dao.repository.InventoryItemRepository;
import com.spice.profitmandi.web.model.FofoDetails;
import com.spice.profitmandi.web.response.GrnHistory;
import com.spice.profitmandi.web.util.CookiesFetcher;
import com.spice.profitmandi.web.util.MVCResponseSender;

@Controller
public class InventoryController {
        
        private static final Logger LOGGER = LoggerFactory.getLogger(InventoryController.class);
        
        @Autowired
        CurrentInventorySnapshotRepository  currentInventorySnapshotRepository;
        
        @Autowired
        InventoryItemRepository inventoryItemRepository;
        
        @Autowired
        MVCResponseSender mvcResponseSender;
        
        @Autowired
        CookiesFetcher cookiesFetcher;
        
        @RequestMapping(value = "/checkCurrentAvailability")
        public String getCurrentAvailability(HttpServletRequest request, @ModelAttribute ModelMap model) throws Exception{
                FofoDetails fofoDetails;
                try {
                        fofoDetails = cookiesFetcher.getCookiesObject(request);
                } catch (ProfitMandiBusinessException e) {
                        model.addAttribute("loginResponse", mvcResponseSender.createResponseString("RTLR_1009", false, "/login"));
                        return "response";
                }
                List<Object[]> rows = currentInventorySnapshotRepository.selectCustomByFofoId(fofoDetails.getFofoId());
                
                model.addAttribute("currentInventorySnapshots", this.getCustomCurrentInventorySnapshots(rows));
                return "dashboard";
        }
        
        private Set<CustomCurrentInventorySnapshot> getCustomCurrentInventorySnapshots(List<Object[]> rows){
                Set<CustomCurrentInventorySnapshot> currentInventorySnapshots = new HashSet<>();
                for(Object[] row : rows){
                        currentInventorySnapshots.add(this.createCustomCurrentInventorySnapshop(row));
                }
                return currentInventorySnapshots;
        }
        
        private CustomCurrentInventorySnapshot createCustomCurrentInventorySnapshop(Object[] row)
        {
                CustomCurrentInventorySnapshot currentInventorySnapshot = new CustomCurrentInventorySnapshot();
                currentInventorySnapshot.setItemId((Integer)row[0]);
                currentInventorySnapshot.setAvailability((Integer)row[1]);
                currentInventorySnapshot.setBrand((String)row[2]);
                currentInventorySnapshot.setModelName((String)row[3]);
                currentInventorySnapshot.setModelNumber((String)row[4]);
                currentInventorySnapshot.setColor((String)row[5]);
                return currentInventorySnapshot;
        }
        @RequestMapping(value = "/checkItemAvailability")
        public String getItemAvailability(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.ITEM_ID) int itemId, @ModelAttribute Model model) throws Exception{
                FofoDetails fofoDetails;
                try {
                        fofoDetails = cookiesFetcher.getCookiesObject(request);
                } catch (ProfitMandiBusinessException e) {
                        model.addAttribute("loginResponse", mvcResponseSender.createResponseString("RTLR_1009", false, "/login"));
                        return "response";
                }
                try{
                        FofoItemId fofoItemId = new FofoItemId();
                        fofoItemId.setFofoId(fofoDetails.getFofoId());
                        fofoItemId.setItemId(itemId);
                        Object[] row = currentInventorySnapshotRepository.selectCustomByFofoItemId(fofoItemId);
                        model.addAttribute("currentInventorySnapshots", this.createCustomCurrentInventorySnapshop(row));
                        return "dashboard";
                }catch(ProfitMandiBusinessException profitMandiBusinessException){
                        model.addAttribute("loginResponse", mvcResponseSender.createResponseString("INVNTRY_SNPSHT", false, "/dashboard"));
                        return "response";
                }
        }
        
        private List<GrnHistory> grnHistory(List<InventoryItem> inventoryItems){
                List<GrnHistory> grnHistories = new ArrayList<>();
                for(InventoryItem inventoryItem : inventoryItems){
                        GrnHistory searchablePurchaseReference = new GrnHistory();
                        searchablePurchaseReference.setPurchaseReference(inventoryItem.getPurchaseId());
                        if(!grnHistories.contains(searchablePurchaseReference)){
                                GrnHistory grnHistory = new GrnHistory();
                                grnHistory.setPurchaseReference(inventoryItem.getPurchaseId());
                                if(null != inventoryItem.getSerialNumber() || !inventoryItem.getSerialNumber().equals("")){
                                        grnHistory.setSerializedQuantity(inventoryItem.getInitialQuantity());
                                }else{
                                        grnHistory.setNonSerializedQuantity(inventoryItem.getInitialQuantity());
                                }
                                grnHistory.setTotalQuantity(grnHistory.getSerializedQuantity() + grnHistory.getNonSerializedQuantity());
                                grnHistories.add(grnHistory);
                        }else{
                                GrnHistory grnHistory = grnHistories.get(grnHistories.indexOf(searchablePurchaseReference));
                                grnHistory.setSerializedQuantity(grnHistory.getSerializedQuantity() + 1);
                                grnHistory.setNonSerializedQuantity(grnHistory.getNonSerializedQuantity() + 1);
                                grnHistory.setTotalQuantity(grnHistory.getSerializedQuantity() + grnHistory.getNonSerializedQuantity());
                        }
                }
                return grnHistories;
        }
        
        @RequestMapping(value = "/grnHistory")
        public String grnHistory(HttpServletRequest request, @RequestParam(name = ProfitMandiConstants.PAGE_NUMBER) int pageNumber, @RequestParam(name = ProfitMandiConstants.PAGE_SIZE) int pageSize, Model model) throws Exception{
                FofoDetails fofoDetails;
                try {
                        fofoDetails = cookiesFetcher.getCookiesObject(request);
                } catch (ProfitMandiBusinessException e) {
                        model.addAttribute("loginResponse", mvcResponseSender.createResponseString("RTLR_1009", false, "/login"));
                        return "response";
                }
                List<InventoryItem> inventoryItems = inventoryItemRepository.selectByFofoId(fofoDetails.getFofoId(), pageNumber, pageSize);
                model.addAttribute("grnHistories", this.grnHistory(inventoryItems));
                return "";
        }
        
}