WebSVN – SmartDukaan – Diff – /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/catalog/ItemLoaderService.java

 import com.spice.profitmandi.common.enumuration.ItemType;
 import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
 import com.spice.profitmandi.common.util.ExcelUtils;
 import com.spice.profitmandi.common.util.Utils;
+import com.spice.profitmandi.dao.entity.catalog.BrandCatalog;
+import com.spice.profitmandi.dao.entity.catalog.Catalog;
 import com.spice.profitmandi.dao.entity.catalog.Item;
+import com.spice.profitmandi.dao.entity.dtr.Brand;
 import com.spice.profitmandi.dao.entity.inventory.VendorCatalogPricing;
 import com.spice.profitmandi.dao.entity.inventory.VendorItemPricing;
 import com.spice.profitmandi.dao.entity.warehouse.Supplier;
 import com.spice.profitmandi.dao.model.StateGstRateModel;
+import com.spice.profitmandi.dao.repository.catalog.BrandsRepository;
+import com.spice.profitmandi.dao.repository.catalog.CatalogRepository;
 import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
 import com.spice.profitmandi.dao.repository.catalog.StateGstRateRepository;
 import com.spice.profitmandi.dao.repository.inventory.VendorCatalogPricingRepository;
 import com.spice.profitmandi.dao.repository.inventory.VendorItemPricingRepository;
 import com.spice.profitmandi.dao.repository.warehouse.SupplierRepository;
 @Component
 public class ItemLoaderService {
     @Autowired
+    BrandsRepository brandsRepository;
+    @Autowired
     ItemRepository itemRepository;
     @Autowired
     VendorCatalogPricingRepository vendorCatalogPricingRepository;
             itemLoaderModel.setProductGroup(row.getCell(i++).getStringCellValue().trim());
             itemLoaderModel.setCategoryId((int) row.getCell(i++).getNumericCellValue());
             itemLoaderModel.setCategory(row.getCell(i++).getStringCellValue().trim());
             itemLoaderModel.setHsnCode(String.valueOf((int) row.getCell(i++).getNumericCellValue()));
             itemLoaderModel.setBrand(row.getCell(i++).getStringCellValue().trim());
+            Cell modelNumberCell = row.getCell(i++);
+            if(modelNumberCell== null || modelNumberCell.getStringCellValue().trim().equals("")) {
+                throw new Exception("Model Number cant be null or empty");
+            } else {
-            itemLoaderModel.setModelNumber(row.getCell(i++).getStringCellValue().trim());
+                itemLoaderModel.setModelNumber(modelNumberCell.getStringCellValue().trim());
+            }
-            Cell modelCell = row.getCell(i++);
+            Cell modelNameCell = row.getCell(i++);
-            if (modelCell == null) {
+            if (modelNameCell == null) {
                 itemLoaderModel.setModelName("");
             } else {
-                itemLoaderModel.setModelName(modelCell.getStringCellValue().trim());
+                itemLoaderModel.setModelName(modelNameCell.getStringCellValue().trim());
+            }
             itemLoaderModel.setColor(row.getCell(i++).getStringCellValue().trim());
             //MRP	SP	MOP	DP	TP	NLC	Startdate	Preferred Vendor	Risky
             // Weight	Item type(1 for Serialized and 2 for non-serialized)	TaxRate
             itemLoaderModel.setMrp(row.getCell(i++).getNumericCellValue());
+    }
-    //@Autowired
+    @Autowired
+    CatalogRepository catalogRepository;
     private void addItem(ItemLoaderModel itemLoaderModel) throws ProfitMandiBusinessException {
         this.validateItemLoaderModel(itemLoaderModel);
-        List<Item> items = itemRepository.selectAll(itemLoaderModel.getBrand(), itemLoaderModel.getModelName(), itemLoaderModel.getModelNumber());
+        Catalog catalog = catalogRepository.selectCatalog(itemLoaderModel.getBrand(), itemLoaderModel.getModelNumber(), itemLoaderModel.getModelName());
-        int catalogId = 0;
+        if (catalog != null) {
-        if (items.size() > 0) {
-            //Check if color already exist
+            List<Item> items = itemRepository.selectAllByCatalogItemId(catalog.getId());
             long similarColorCount = items.stream().filter(x -> itemLoaderModel.getColor().equals(x.getColorNatural())).count();
             if (similarColorCount > 0) {
                 throw new ProfitMandiBusinessException("Color alerady exist", "Pls check", itemLoaderModel.getColor());
+            }
             for (Map.Entry<String, Long> colorCountEntrySet : colorsCount.entrySet()) {
                 if (colorCountEntrySet.getValue() > 1) {
                     throw new ProfitMandiBusinessException("Model repeats the same color", "Pls check", colorCountEntrySet.getKey());
+                }
+            }
-            catalogId = items.get(0).getCatalogItemId();
         } else {
+            catalog = new Catalog();
+            BrandCatalog brand = brandsRepository.selectByBrand(itemLoaderModel.getBrand());
+            if(brand == null) {
+                    throw new ProfitMandiBusinessException("Brand Does not exist", "Pls check", itemLoaderModel.getBrand());
+            }
+            catalog.setBrandId(brand.getId());
+            catalog.setBrand(itemLoaderModel.getBrand());
+            catalog.setModelName(itemLoaderModel.getModelName());
+            catalog.setModelNumber(itemLoaderModel.getModelNumber());
+            catalog.setCreated(LocalDateTime.now());
+            catalog.setCreatedBy("System");
-            catalogId = itemRepository.getNextEntity();
+            catalogRepository.persist(catalog);
+        }
         //Finally either got valid existing model or new model altogether
         Item item = new Item();
         item.setBrand(itemLoaderModel.getBrand());
         item.setModelName(itemLoaderModel.getModelName());
         item.setMrp(new Float(Math.round(itemLoaderModel.getMrp())));
         item.setStartDate(itemLoaderModel.getStartDate());
         item.setCategoryId(itemLoaderModel.getCategoryId());
         item.setPreferredVendor(itemLoaderModel.getPreferredVendor());
         item.setRisky(itemLoaderModel.isRisky());
-        item.setCatalogItemId(catalogId);
+        item.setCatalogItemId(catalog.getId());
         if (itemLoaderModel.getWeight() <= 0) {
             throw new ProfitMandiBusinessException("Weight", "0", "Weight should be greater than 0");
+        }
         item.setWeight(itemLoaderModel.getWeight());
         item.setStatus(status.PARTIALLY_ACTIVE);

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/catalog/ItemLoaderService.java – Rev 33346 → 33771