| Line 8... |
Line 8... |
| 8 |
import com.spice.profitmandi.common.util.Utils;
|
8 |
import com.spice.profitmandi.common.util.Utils;
|
| 9 |
import com.spice.profitmandi.dao.entity.catalog.BrandCatalog;
|
9 |
import com.spice.profitmandi.dao.entity.catalog.BrandCatalog;
|
| 10 |
import com.spice.profitmandi.dao.entity.catalog.Catalog;
|
10 |
import com.spice.profitmandi.dao.entity.catalog.Catalog;
|
| 11 |
import com.spice.profitmandi.dao.entity.catalog.CategorisedCatalog;
|
11 |
import com.spice.profitmandi.dao.entity.catalog.CategorisedCatalog;
|
| 12 |
import com.spice.profitmandi.dao.entity.catalog.Item;
|
12 |
import com.spice.profitmandi.dao.entity.catalog.Item;
|
| 13 |
import com.spice.profitmandi.dao.entity.inventory.VendorCatalogPricing;
|
- |
|
| 14 |
import com.spice.profitmandi.dao.entity.inventory.VendorItemPricing;
|
- |
|
| 15 |
import com.spice.profitmandi.dao.entity.warehouse.Supplier;
|
13 |
import com.spice.profitmandi.dao.entity.warehouse.Supplier;
|
| 16 |
import com.spice.profitmandi.dao.enumuration.inventory.CatalogMovingEnum;
|
14 |
import com.spice.profitmandi.dao.enumuration.inventory.CatalogMovingEnum;
|
| 17 |
import com.spice.profitmandi.dao.model.StateGstRateModel;
|
15 |
import com.spice.profitmandi.dao.model.StateGstRateModel;
|
| 18 |
import com.spice.profitmandi.dao.repository.catalog.*;
|
16 |
import com.spice.profitmandi.dao.repository.catalog.*;
|
| 19 |
import com.spice.profitmandi.dao.repository.inventory.VendorCatalogPricingRepository;
|
- |
|
| 20 |
import com.spice.profitmandi.dao.repository.inventory.VendorItemPricingRepository;
|
- |
|
| 21 |
import com.spice.profitmandi.dao.repository.warehouse.SupplierRepository;
|
17 |
import com.spice.profitmandi.dao.repository.warehouse.SupplierRepository;
|
| 22 |
import in.shop2020.model.v1.catalog.status;
|
18 |
import in.shop2020.model.v1.catalog.status;
|
| 23 |
import org.apache.logging.log4j.LogManager;
|
19 |
import org.apache.logging.log4j.LogManager;
|
| 24 |
import org.apache.logging.log4j.Logger;
|
20 |
import org.apache.logging.log4j.Logger;
|
| 25 |
import org.apache.poi.ss.usermodel.Cell;
|
21 |
import org.apache.poi.ss.usermodel.Cell;
|
| Line 47... |
Line 43... |
| 47 |
|
43 |
|
| 48 |
@Autowired
|
44 |
@Autowired
|
| 49 |
ItemRepository itemRepository;
|
45 |
ItemRepository itemRepository;
|
| 50 |
|
46 |
|
| 51 |
@Autowired
|
47 |
@Autowired
|
| 52 |
VendorCatalogPricingRepository vendorCatalogPricingRepository;
|
- |
|
| 53 |
|
- |
|
| 54 |
@Autowired
|
- |
|
| 55 |
StateGstRateRepository stateGstRateRepository;
|
48 |
StateGstRateRepository stateGstRateRepository;
|
| 56 |
|
49 |
|
| 57 |
@Autowired
|
- |
|
| 58 |
VendorItemPricingRepository vendorItemPricingRepository;
|
- |
|
| 59 |
|
50 |
|
| 60 |
|
51 |
|
| 61 |
private static final Logger LOGGER = LogManager.getLogger(ItemLoaderService.class);
|
52 |
private static final Logger LOGGER = LogManager.getLogger(ItemLoaderService.class);
|
| 62 |
|
53 |
|
| 63 |
public void parse(MultipartFile file) throws Exception {
|
54 |
public void parse(MultipartFile file) throws Exception {
|
| Line 251... |
Line 242... |
| 251 |
//Set Tax Rate
|
242 |
//Set Tax Rate
|
| 252 |
StateGstRateModel stateGstRateModel = new StateGstRateModel();
|
243 |
StateGstRateModel stateGstRateModel = new StateGstRateModel();
|
| 253 |
stateGstRateModel.setItemId(item.getId());
|
244 |
stateGstRateModel.setItemId(item.getId());
|
| 254 |
stateGstRateModel.setIgstRate(itemLoaderModel.getTaxRate());
|
245 |
stateGstRateModel.setIgstRate(itemLoaderModel.getTaxRate());
|
| 255 |
stateGstRateRepository.addStateGstRates(Arrays.asList(stateGstRateModel));
|
246 |
stateGstRateRepository.addStateGstRates(Arrays.asList(stateGstRateModel));
|
| 256 |
|
- |
|
| 257 |
//Add Vendor
|
- |
|
| 258 |
this.addVendorItemPricing(item);
|
- |
|
| 259 |
}
|
- |
|
| 260 |
|
- |
|
| 261 |
private void addVendorItemPricing(Item item) {
|
- |
|
| 262 |
List<VendorCatalogPricing> vendorCatalogPricingList = vendorCatalogPricingRepository.selectByCatalogId(item.getCatalogItemId());
|
- |
|
| 263 |
for (VendorCatalogPricing vendorCatalogPricing : vendorCatalogPricingList) {
|
- |
|
| 264 |
VendorItemPricing vendorItemPricing = new VendorItemPricing();
|
- |
|
| 265 |
vendorItemPricing.setItemId(item.getId());
|
- |
|
| 266 |
vendorItemPricing.setVendorId(vendorCatalogPricing.getVendorId());
|
- |
|
| 267 |
vendorItemPricing.setDp(vendorCatalogPricing.getDealerPrice());
|
- |
|
| 268 |
vendorItemPricing.setMop(vendorCatalogPricing.getMop());
|
- |
|
| 269 |
vendorItemPricing.setNlc(vendorCatalogPricing.getTransferPrice());
|
- |
|
| 270 |
vendorItemPricing.setTp(vendorCatalogPricing.getTransferPrice());
|
- |
|
| 271 |
vendorItemPricingRepository.persist(vendorItemPricing);
|
- |
|
| 272 |
}
|
- |
|
| 273 |
}
|
247 |
}
|
| 274 |
|
248 |
|
| 275 |
}
|
249 |
}
|