Subversion Repositories SmartDukaan

package in.shop2020.catalog.dashboard.server;

import in.shop2020.catalog.dashboard.client.CatalogService;

import in.shop2020.catalog.dashboard.shared.Item;

import in.shop2020.catalog.dashboard.shared.ItemStatus;

import in.shop2020.catalog.dashboard.shared.ItemsComparator;

import in.shop2020.catalog.dashboard.shared.SourcePricings;

import in.shop2020.catalog.dashboard.shared.VendorItemMapping;

import in.shop2020.catalog.dashboard.shared.VendorPricings;

import in.shop2020.config.ConfigException;

import in.shop2020.model.v1.catalog.InventoryService;

import in.shop2020.model.v1.catalog.status;

import in.shop2020.thrift.clients.CatalogClient;

import in.shop2020.thrift.clients.config.ConfigClient;

import in.shop2020.utils.CategoryManager;

import in.shop2020.utils.ConfigClientKeys;

import java.io.BufferedReader;

import java.io.FileReader;

import java.io.IOException;

import java.text.DateFormat;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Calendar;

import java.util.Collections;

import java.util.Date;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import java.util.Map.Entry;

import org.apache.log4j.Logger;

import com.google.gwt.user.server.rpc.RemoteServiceServlet;

@SuppressWarnings("serial")

public class CatalogServiceImpl extends RemoteServiceServlet implements CatalogService {

    private static Logger logger = Logger.getLogger(CatalogServiceImpl.class);

    private static Date pushToProdDate;

    @Override

    public int getItemCountByStatus(boolean useStatus, ItemStatus itemStatus){

        int count = 0;

        try{

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            status stat = status.findByValue(itemStatus.getValue());

            count = catalogClient.getItemCountByStatus(useStatus, stat);

        }catch(Exception e){

            logger.error("Error while getting the count of items from the catalog service", e);

        }

        return count;

    }

    @Override

    public List<Item> getAllItems(int start, int limit) {

        List<Item> itemList = new ArrayList<Item>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Item> thriftItems = catalogClient.getAllItemsInRange(start, limit);

            for(in.shop2020.model.v1.catalog.Item thriftItem : thriftItems) {

                itemList.add(getItemFromThriftItem(thriftItem, null, null, null));

            }

        } catch (Exception e) {

            logger.error("Error while getting all items from the catalog service", e);

        }

        return itemList;

    }

    public List<Item> getAllActiveItems(int start, int limit){

        return getItemsByStatus(status.ACTIVE, start, limit);

    }

    @Override

    public List<Item> getAllPhasedOutItems(int start, int limit){

        return getItemsByStatus(status.PHASED_OUT, start, limit);

    }

    @Override

    public List<Item> getAllPausedItems(int start, int limit){

        return getItemsByStatus(status.PAUSED, start, limit);

    }

    @Override

    public List<Item> getAllInProcessItems(int start, int limit) {

        return getItemsByStatus(status.IN_PROCESS, start, limit);

    }

    @Override

    public List<Item> getAllContentCompleteItems(int start, int limit) {

        return getItemsByStatus(status.CONTENT_COMPLETE, start, limit);

    }

    public List<Item> getBestDeals(){

        List<Item> itemList = new ArrayList<Item>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Item> thriftItems = catalogClient.getBestDeals();

            for(in.shop2020.model.v1.catalog.Item thriftItem : thriftItems) {

                itemList.add(getItemFromThriftItem(thriftItem, null, null, null));

            }

        } catch(Exception e){

            logger.error("Error while getting the best deals from the catalog service", e);

        }

        //Collections.sort(itemList, new ItemsComparator());

        return itemList;

    }

    @Override

    public List<Item> getRiskyItems() {

        List<Item> itemList = new ArrayList<Item>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Item> thriftItems = catalogClient.getItemsByRiskyFlag();

            for(in.shop2020.model.v1.catalog.Item thriftItem : thriftItems) {

                itemList.add(getItemFromThriftItem(thriftItem, null, null, null));

            }

        } catch(Exception e){

            logger.error("Error while getting the risky items from the catalog service", e);

        }

        Collections.sort(itemList, new ItemsComparator());

        return itemList;

    }

    public List<Item> getBestSellers(){

        List<Item> itemList = new ArrayList<Item>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Item> thriftItems = catalogClient.getBestSellers();

            for(in.shop2020.model.v1.catalog.Item thriftItem : thriftItems) {

                itemList.add(getItemFromThriftItem(thriftItem, null, null, null));

            }

        } catch(Exception e){

            logger.error("Error while getting the best sellers from the catalog service", e);

        }

        return itemList;        

    }

    public List<Item> getLatestArrivals(){

        List<Item> itemList = new ArrayList<Item>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Item> thriftItems = catalogClient.getLatestArrivals();

            for(in.shop2020.model.v1.catalog.Item thriftItem : thriftItems) {

                //List<in.shop2020.model.v1.catalog.VendorItemPricing> vip = catalogClient.getAllItemPricing(thriftItem.getId());

                itemList.add(getItemFromThriftItem(thriftItem, null, null, null));

            }

        } catch(Exception e){

            logger.error("Error while getting the latest arrivals from the catalog service", e);

        }

        return itemList;

    }

    public Item getItem(long itemId){

        try{

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            in.shop2020.model.v1.catalog.Item thriftItem = catalogClient.getItem(itemId);

            List<in.shop2020.model.v1.catalog.VendorItemPricing> vip = catalogClient.getAllItemPricing(thriftItem.getId());

            List<in.shop2020.model.v1.catalog.VendorItemMapping> vim = catalogClient.getVendorItemMappings(thriftItem.getId());

            List<in.shop2020.model.v1.catalog.SourceItemPricing> sip = catalogClient.getAllSourcePricing(thriftItem.getId());

            return getItemFromThriftItem(thriftItem, vip, vim, sip);

        }catch(Exception e){

            logger.error("Error while getting the item from the catalog service", e);

        }

        return null;

    }

    @Override

    public boolean updateItem(Item item) {

        logger.info("Updating item with Id: " + item.getId());

        try{

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            in.shop2020.model.v1.catalog.Item tItem = catalogClient.getItem(item.getId());

            setThriftItemParams(tItem, item);

            long rItemId;

            if((rItemId = catalogClient.updateItem(tItem)) != item.getId()) {

                logger.error("Error updating item, returned Item Id: " + rItemId);

                return false;

            }

            logger.info("Successfully updated item with id: " + item.getId());

            Map<String, VendorItemMapping> vendorMappings = item.getVendorKeysMap();

            if(vendorMappings != null && !vendorMappings.isEmpty()) {

                in.shop2020.model.v1.catalog.VendorItemMapping tVendorMapping;

                for(Entry<String, VendorItemMapping> e : vendorMappings.entrySet()) {

                    tVendorMapping = new in.shop2020.model.v1.catalog.VendorItemMapping();

                    VendorItemMapping v = e.getValue();

                    tVendorMapping.setVendorId(v.getVendorId());

                    tVendorMapping.setItemKey(v.getItemKey());

                    tVendorMapping.setItemId(item.getId());

                    tVendorMapping.setVendorCategory(item.getVendorCategory());

                    catalogClient.addVendorItemMapping(e.getKey().substring(e.getKey().indexOf(Item.KEY_SEPARATOR)+1), tVendorMapping);

                    logger.info("Updates VendorItemMapping: " + tVendorMapping.toString());

                }

            }

            Map<Long, VendorPricings> vendorPricings = item.getVendorPricesMap();

            if(vendorPricings != null && !vendorPricings.isEmpty()) {

                in.shop2020.model.v1.catalog.VendorItemPricing tVendorPricing;

                for(VendorPricings v : vendorPricings.values()) {

                    tVendorPricing = new in.shop2020.model.v1.catalog.VendorItemPricing();

                    tVendorPricing.setVendorId(v.getVendorId());

                    tVendorPricing.setItemId(item.getId());

                    tVendorPricing.setMop(v.getMop());

                    tVendorPricing.setTransferPrice(v.getTransferPrice());

                    tVendorPricing.setDealerPrice(v.getDealerPrice());

                    catalogClient.addVendorItemPricing(tVendorPricing);

                    logger.info("Updated VendorItemPricing: " + tVendorPricing.toString());

                }

            }

            Map<Long, SourcePricings> sourcePricings = item.getSourcePricesMap();

            if(sourcePricings != null && !sourcePricings.isEmpty()) {

                in.shop2020.model.v1.catalog.SourceItemPricing tSourcePricings;

                for(SourcePricings s : sourcePricings.values()) {

                	tSourcePricings = new in.shop2020.model.v1.catalog.SourceItemPricing();

                	tSourcePricings.setSourceId(s.getSourceId());

                    tSourcePricings.setItemId(item.getId());

                    tSourcePricings.setMrp(s.getMrp());

                    tSourcePricings.setSellingPrice(s.getSellingPrice());

                    catalogClient.addSourceItemPricing(tSourcePricings);

                    logger.info("Updated SourceItemPricing: " + tSourcePricings.toString());

                }

            }

        }catch(Exception e){

            logger.error("Error while updating item: ", e);

            return false;

        }

        return true;

    }

    @Override

    public Map<Long, String> getAllVendors() {

        Map<Long, String> vendorMap = new HashMap<Long, String>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Vendor> vendors = catalogClient.getAllVendors();

            for(in.shop2020.model.v1.catalog.Vendor v : vendors) {

                vendorMap.put(v.getId(), v.getName());

            }

        } catch (Exception e) {

            logger.error("Error while getting all the vendors: ", e);

        }

        return vendorMap;

    }

    @Override

    public Map<Long, String> getAllSources() {

        Map<Long, String> sourceMap = new HashMap<Long, String>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Source> sources = catalogClient.getAllSources();

            for(in.shop2020.model.v1.catalog.Source s : sources) {

            	sourceMap.put(s.getId(), s.getName());

            }

        } catch (Exception e) {

            logger.error("Error while getting all the vendors: ", e);

        }

        return sourceMap;

    }

    @Override

    public Map<Long, String> getAllWarehouses() {

        Map<Long, String> warehouseMap = new HashMap<Long, String>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Warehouse> warehouses = catalogClient.getAllWarehouses(true);

            for(in.shop2020.model.v1.catalog.Warehouse w : warehouses) {

                warehouseMap.put(w.getId(), w.getDisplayName());

            }

        } catch (Exception e) {

            logger.error("Error while getting all the warehouses:", e );

        }

        return warehouseMap;

    }

    @Override

    public long addItem(Item item) {

        long itemId = 0;

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            in.shop2020.model.v1.catalog.Item tItem = new in.shop2020.model.v1.catalog.Item();

            setThriftItemParams(tItem, item);

            itemId = catalogClient.addItem(tItem);

            Map<Long, VendorPricings> vendorPricings = item.getVendorPricesMap();

            if(vendorPricings != null && !vendorPricings.isEmpty()) {

                in.shop2020.model.v1.catalog.VendorItemPricing tVendorPricing;

                for(VendorPricings v : vendorPricings.values()) {

                    tVendorPricing = new in.shop2020.model.v1.catalog.VendorItemPricing();

                    tVendorPricing.setVendorId(v.getVendorId());

                    tVendorPricing.setItemId(itemId);

                    tVendorPricing.setMop(v.getMop());

                    tVendorPricing.setTransferPrice(v.getTransferPrice());

                    tVendorPricing.setDealerPrice(v.getDealerPrice());

                    catalogClient.addVendorItemPricing(tVendorPricing);

                }

            }

            Map<String, VendorItemMapping> vendorKeysMap = item.getVendorKeysMap();

            if(vendorKeysMap != null && !vendorKeysMap.isEmpty()) {

                in.shop2020.model.v1.catalog.VendorItemMapping tVendorMapping;

                for(Entry<String, VendorItemMapping> e : vendorKeysMap.entrySet()) {

                    tVendorMapping = new in.shop2020.model.v1.catalog.VendorItemMapping();

                    VendorItemMapping v = e.getValue();

                    tVendorMapping.setVendorId(v.getVendorId());

                    tVendorMapping.setItemKey(v.getItemKey());

                    tVendorMapping.setItemId(itemId);

                    tVendorMapping.setVendorCategory(item.getVendorCategory());

                    catalogClient.addVendorItemMapping(e.getKey().substring(e.getKey().indexOf(Item.KEY_SEPARATOR)+1), tVendorMapping);

                }

            }

        } catch (Exception e) {

            logger.error("Error while adding an item: ", e);

        }

        return itemId;

    }

    @Override

    public long checkSimilarItem(String productGroup, String brand, String modelNumber, String color) {

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            return catalogClient.checkSimilarItem(productGroup, brand, modelNumber, color);

        } catch (Exception e) {

            logger.error("Error while checking for a similar item: ", e);

        }

        return 0;

    }

    private void setThriftItemParams(in.shop2020.model.v1.catalog.Item tItem, Item item) {

        tItem.setId(tItem.getId());

        tItem.setProductGroup(item.getProductGroup());

        tItem.setBrand(item.getBrand());

        tItem.setModelName(item.getModelName());

        tItem.setModelNumber(item.getModelNumber());

        tItem.setColor(item.getColor());

        tItem.setStatus_description(item.getItemStatusDesc());

        tItem.setComments(item.getComments());

        if(item.getMrp() != null) {

            tItem.setMrp(item.getMrp());

        }

        if(item.getSellingPrice() != null) {

            tItem.setSellingPrice(item.getSellingPrice());

        }

        if(item.getWeight() != null) {

            tItem.setWeight(item.getWeight());

        }

        if(item.getExpectedDelay() != null) {

            tItem.setExpectedDelay(item.getExpectedDelay());

        }

        if(item.getPreferredWarehouse() != null) {

            tItem.setPreferredWarehouse(item.getPreferredWarehouse());

        }

        tItem.setBestDealText(item.getBestDealsText());

        if(item.getBestDealsValue() != null) {

            tItem.setBestDealValue(item.getBestDealsValue());

        }

        if(item.getBestSellingRank() != null) {

            tItem.setBestSellingRank(item.getBestSellingRank());

        }

        tItem.setDefaultForEntity(item.isDefaultForEntity());

        tItem.setRisky(item.isRisky());

        if(item.getStartDate() != null) {

            tItem.setStartDate(item.getStartDate());

        }

        if(item.getRetireDate() != null) {

            tItem.setRetireDate(item.getRetireDate());

        }

        tItem.setUpdatedOn(Calendar.getInstance().getTimeInMillis());

        tItem.setHotspotCategory(item.getVendorCategory());

    }

    @Override

    public void pauseItem(long itemId) {

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            catalogClient.changeItemStatus(itemId, Calendar.getInstance().getTimeInMillis(), status.PAUSED);

        } catch (Exception e) {

            logger.error("Error while pausing the item: " + itemId, e);

        }

    }

    @Override

    public void markInProcess(long itemId) {

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            catalogClient.changeItemStatus(itemId, Calendar.getInstance().getTimeInMillis(), status.IN_PROCESS);

        } catch (Exception e) {

            logger.error("Error while marking in-process the item: " + itemId, e);

        }

    }

    @Override

    public void phaseoutItem(long itemId) {

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            catalogClient.changeItemStatus(itemId, Calendar.getInstance().getTimeInMillis(), status.PHASED_OUT);

        } catch (Exception e) {

            logger.error("Error while phasing out the item: " + itemId, e);

        }

    }

    @Override

    public void activateItem(long itemId) {

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            catalogClient.changeItemStatus(itemId, Calendar.getInstance().getTimeInMillis(), status.ACTIVE);

        } catch (Exception e) {

            logger.error("Error while activating the item: " + itemId, e);

        }

    }

    @Override

    public boolean changeItemRiskyFlag(long itemId, boolean risky) {

        try {

            // Initialize client for staging server

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            // Initialize client for production server

            CatalogClient catalogServiceClient_Prod = new CatalogClient(ConfigClientKeys.catalog_service_server_host_prod.toString(),

                    ConfigClientKeys.catalog_service_server_port.toString());

            InventoryService.Client catalogClient_Prod = catalogServiceClient_Prod.getClient();

            catalogClient.changeItemRiskyFlag(itemId, risky);

            try{

                catalogClient_Prod.changeItemRiskyFlag(itemId, risky);

            }catch(Exception e){

                logger.error("Error while updating item's risky flag on production", e);

                // If not able to change risky flag on production, revert on staging and return false (to show error to user).

                catalogClient.changeItemRiskyFlag(itemId, !risky);        

                return false;

            }

        } catch (Exception e) {

            logger.error("Error while updating item's risky flag on staging", e);

            return false;

        }

        return true;

    }

    /**

     * Retuns list of Items filtered by Vendor category (column is hotspotCategory in catalog.item table)

     * This list is used to generate master sheet (excel sheet)

     * @param category

     * @return

     */

    public List<Item> getItemsByVendorCategory(String category) {

        List<Item> itemList = new ArrayList<Item>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Item> thriftItems = catalogClient.getItemsByVendorCategory(category);

            for(in.shop2020.model.v1.catalog.Item thriftItem : thriftItems) {

                List<in.shop2020.model.v1.catalog.VendorItemPricing> vip = catalogClient.getAllItemPricing(thriftItem.getId());

                List<in.shop2020.model.v1.catalog.VendorItemMapping> vim = catalogClient.getVendorItemMappings(thriftItem.getId());

                List<in.shop2020.model.v1.catalog.SourceItemPricing> sip = catalogClient.getAllSourcePricing(thriftItem.getId());

                itemList.add(getItemFromThriftItem(thriftItem, vip, vim, sip));

            }

        } catch (Exception e) {

            logger.error("Error while getting items by vendor category: " + category, e);

        }

        Collections.sort(itemList, new ItemsComparator());

        return itemList;

    }

    @Override

    public String updateItemOnProduction(Item item) {

        logger.info("Update item on production call, Item Id: " + item.getId());

        String errMsg = checkPushToProdCount();

        // If errMsg is not null, then return that message to user

        // else move forward with update.

        if(errMsg != null) {

            return errMsg;

        }

        try{

            CatalogClient catalogServiceClient_Prod = new CatalogClient( 

                    ConfigClientKeys.catalog_service_server_host_prod.toString(),

                    ConfigClientKeys.catalog_service_server_port.toString());

            //for testing, put catalog_service_server_port_test in shop2020.cfg

            /*CatalogServiceClient catalogServiceClient_Prod = new CatalogServiceClient(CatalogServiceClient.class.getSimpleName(), 

                    ConfigClientKeys.catalog_service_server_host.toString(), "catalog_service_server_port_test");*/

            InventoryService.Client catalogClient_Prod = catalogServiceClient_Prod.getClient();

            in.shop2020.model.v1.catalog.Item tItem = catalogClient_Prod.getItem(item.getId());

            if(item.getMrp() != null) {

                tItem.setMrp(item.getMrp());

            }

            if(item.getSellingPrice() != null) {

                tItem.setSellingPrice(item.getSellingPrice());

            }

            long rItemId;

            if((rItemId = catalogClient_Prod.updateItem(tItem)) != item.getId()) {

                logger.error("Error updating item on production, returned Item Id: " + rItemId);

                return "Error updating item prices on production";

            }

            logger.info("Successfully updated item: " + item.getId());

            Map<Long, VendorPricings> vendorPricings = item.getVendorPricesMap();

            StringBuilder sb = new StringBuilder();

            if(vendorPricings != null && !vendorPricings.isEmpty()) {

                in.shop2020.model.v1.catalog.VendorItemPricing tVendorPricing;

                for(VendorPricings v : vendorPricings.values()) {

                    tVendorPricing = new in.shop2020.model.v1.catalog.VendorItemPricing();

                    tVendorPricing.setVendorId(v.getVendorId());

                    tVendorPricing.setItemId(item.getId());

                    tVendorPricing.setMop(v.getMop());

                    tVendorPricing.setTransferPrice(v.getTransferPrice());

                    tVendorPricing.setDealerPrice(v.getDealerPrice());

                    catalogClient_Prod.addVendorItemPricing(tVendorPricing);

                    logger.info("VendorItemPricing updated. " + tVendorPricing.toString());

                    sb.append("[VId:" + v.getVendorId() + ",MOP=" + v.getMop() + ",TP=" + v.getTransferPrice() + ",DP=" + v.getDealerPrice() + "], ");

                }

            }

            logItemDetails("Id=" + item.getId() + ",MRP=" + item.getMrp() + ",SP=" + " " + item.getSellingPrice() + sb.toString());

        } catch (Exception e) {

            logger.error("Error while updating prices on production", e);

            return "Error while updating all prices on production. Some of the prices may have been  updated";

        }

        /*

        // Push the content of one item to production 

        Process p;

		try {

		    String scriptPath = ConfigClient.getClient().get(ConfigClientKeys.PUSH_PRICES_TO_PROD_SCRIPT_PATH.toString());

			p = Runtime.getRuntime().exec(scriptPath + " " + item.getCatalogItemId());

			p.waitFor();

		} catch (IOException e) {

			GWT.log("Not able to update content on production");

			e.printStackTrace();

			return "Error generating content. Prices updated successfully.";

		} catch (InterruptedException e) {

			GWT.log("Not able to update content on production");

			e.printStackTrace();

			return "Error generating content. Prices updated successfully.";

		} catch (ConfigException e) {

            e.printStackTrace();

            return "Error getting content script path";

        }*/

        return "Prices updated and content generated successfully";

    }

    /**

     * Returns list of items with a particular status.

     * @param st

     * @return

     */

    private List<Item> getItemsByStatus(status st, int start, int limit) {

        List<Item> itemList = new ArrayList<Item>();

        try {

            CatalogClient catalogServiceClient = new CatalogClient();

            InventoryService.Client catalogClient = catalogServiceClient.getClient();

            List<in.shop2020.model.v1.catalog.Item> thriftItems = catalogClient.getAllItemsByStatusInRange(st, start, limit);

            for(in.shop2020.model.v1.catalog.Item thriftItem : thriftItems) {

                itemList.add(getItemFromThriftItem(thriftItem, null, null, null));

            }

        } catch (Exception e) {

            logger.error("Error while getting items by status: " + st, e);

        }

        return itemList;

    }

    /**

     * Creates a new Item object and populates its attributes from thrift item passed as parameter.

     * Also creates a Map each for VendorItemPricing and VendorItemMapping and adds these maps to the

     * new Item object.

     * @param thriftItem

     * @param tVendorPricings

     * @param tVendorMappings

     * @return item object with attributes copied from thrift item object.

     */

    private Item getItemFromThriftItem(in.shop2020.model.v1.catalog.Item thriftItem, 

            List<in.shop2020.model.v1.catalog.VendorItemPricing> tVendorPricings, 

            List<in.shop2020.model.v1.catalog.VendorItemMapping> tVendorMappings,

            List<in.shop2020.model.v1.catalog.SourceItemPricing> tSourceMappings){

        Map<String, VendorItemMapping> vItemMap = new HashMap<String, VendorItemMapping>();

        VendorItemMapping vItemMapping;

        if(tVendorMappings != null) {

            for(in.shop2020.model.v1.catalog.VendorItemMapping vim : tVendorMappings) {

                vItemMapping = new VendorItemMapping();

                vItemMapping.setVendorId(vim.getVendorId());

                vItemMapping.setItemKey(vim.getItemKey());

                vItemMap.put(vItemMapping.getVendorId() + Item.KEY_SEPARATOR + vim.getItemKey(), vItemMapping);

            }

        }

        Map<Long, VendorPricings> vendorPricingMap = new HashMap<Long, VendorPricings>();

        VendorPricings vPricings;

        if(tVendorPricings != null) {

            for(in.shop2020.model.v1.catalog.VendorItemPricing vip : tVendorPricings) {

                vPricings = new VendorPricings();

                vPricings.setVendorId(vip.getVendorId());

                vPricings.setMop(vip.getMop());

                vPricings.setDealerPrice(vip.getDealerPrice());

                vPricings.setTransferPrice(vip.getTransferPrice());

                vendorPricingMap.put(vPricings.getVendorId(), vPricings);

            }

        }

        Map<Long, SourcePricings> sourcePricingMap = new HashMap<Long, SourcePricings>();

        SourcePricings sPricings;

        if(tSourceMappings != null) {

            for(in.shop2020.model.v1.catalog.SourceItemPricing sip : tSourceMappings) {

                sPricings = new SourcePricings();

                sPricings.setSourceId(sip.getSourceId());

                sPricings.setMrp(sip.getMrp());

                sPricings.setSellingPrice(sip.getSellingPrice());

                sourcePricingMap.put(sPricings.getSourceId(), sPricings);

            }

        }

        Item item = new Item(thriftItem.getId(),

                thriftItem.getHotspotCategory(),

                thriftItem.getProductGroup(),

                thriftItem.getBrand(),

                thriftItem.getModelNumber(),

                thriftItem.getModelName(),

                thriftItem.getColor(),

                CategoryManager.getCategoryManager().getCategoryLabel(thriftItem.getCategory()),

                thriftItem.getCategory(),

                thriftItem.getComments(),

                thriftItem.getCatalogItemId(),

                thriftItem.getFeatureId(),

                thriftItem.getFeatureDescription(),

                thriftItem.isSetMrp() ? thriftItem.getMrp() : null,

                thriftItem.isSetSellingPrice() ? thriftItem.getSellingPrice() : null,

                thriftItem.isSetWeight() ? thriftItem.getWeight() : null,

                thriftItem.getAddedOn(),

                thriftItem.getStartDate(),

                thriftItem.getRetireDate(),

                thriftItem.getUpdatedOn(),

                thriftItem.getItemStatus().name(),

                thriftItem.getItemStatus().getValue(),

                thriftItem.getStatus_description(),

                thriftItem.getOtherInfo(),

                thriftItem.getBestDealText(),

                thriftItem.isSetBestDealValue() ? thriftItem.getBestDealValue() : null,

                thriftItem.isSetBestSellingRank() ? thriftItem.getBestSellingRank() : null,

                thriftItem.isDefaultForEntity(),

                thriftItem.isRisky(),

                thriftItem.isSetExpectedDelay() ? thriftItem.getExpectedDelay() : null,

                thriftItem.isSetPreferredWarehouse() ? thriftItem.getPreferredWarehouse() : null,

                (thriftItem.getItemInventory() != null ? thriftItem.getItemInventory().getAvailability() : null),

                vendorPricingMap,

                vItemMap,

                sourcePricingMap);

        return item;

    }

    /**

     * 

     * @return null if push to production count is less than maximum allowed.

     *   <br>otherwise error message to be passed to the client side for showing to the user

     */

    private String checkPushToProdCount() {

        int count = 0, maxCount;

        try {

            //String logFile = ConfigClient.getClient().get(ConfigClientKeys.push_prices_to_prod_log_file.toString());

            maxCount = Integer.parseInt(ConfigClient.getClient().get(ConfigClientKeys.push_prices_to_prod_max_count.toString()));

            //count = getPushToProdCount(logFile);

            if(count >= maxCount) {

                return "Maximum push to production count reached for today";

            }

        } catch (ConfigException e) {

            logger.error("Error while getting the max count from the config server", e);

            return "Error getting push to production parameters";

        }

        return null;

    }

    /**

     * Log push to production details

     * @param str

     */

    private void logItemDetails(String str) {

        logger.info(str);

    }

    /**

     * If this is the first attempt to push to production for current date, returns 0

     * else reads number of lines from daily rolling log file to get the count.

     * @return push to production count for current date

     */

    private int getPushToProdCount(String logfile) {

        // logfile is "/var/log/services/pushToProductionCount/pushToProd.log"

        // this should also be set in log4j.properties

        int lineCount = 0;

        DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");

        Date currentDate = Calendar.getInstance().getTime();

        if(pushToProdDate == null ||  !dateFormat.format(pushToProdDate).equals(dateFormat.format(currentDate))) {

            pushToProdDate = currentDate;

            return lineCount;

        }

        try {

            BufferedReader br = new BufferedReader(new FileReader(logfile));

            while (br.readLine() != null) {

                lineCount++;

            }

        } catch (IOException e) {

            logger.error("Error while reading the log file", e);

        }

        return lineCount;

    }

}