| Line 3... |
Line 3... |
| 3 |
|
3 |
|
| 4 |
import com.spice.profitmandi.common.enumuration.ItemType;
|
4 |
import com.spice.profitmandi.common.enumuration.ItemType;
|
| 5 |
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
|
5 |
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
|
| 6 |
import com.spice.profitmandi.common.util.Utils;
|
6 |
import com.spice.profitmandi.common.util.Utils;
|
| 7 |
import com.spice.profitmandi.dao.entity.catalog.Item;
|
7 |
import com.spice.profitmandi.dao.entity.catalog.Item;
|
| - |
|
8 |
import com.spice.profitmandi.dao.entity.inventory.VendorCatalogPricing;
|
| 8 |
import com.spice.profitmandi.dao.entity.inventory.VendorItemPricing;
|
9 |
import com.spice.profitmandi.dao.entity.inventory.VendorItemPricing;
|
| 9 |
import com.spice.profitmandi.dao.entity.warehouse.Supplier;
|
10 |
import com.spice.profitmandi.dao.entity.warehouse.Supplier;
|
| 10 |
import com.spice.profitmandi.dao.model.StateGstRateModel;
|
11 |
import com.spice.profitmandi.dao.model.StateGstRateModel;
|
| 11 |
import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
|
12 |
import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
|
| 12 |
import com.spice.profitmandi.dao.repository.catalog.StateGstRateRepository;
|
13 |
import com.spice.profitmandi.dao.repository.catalog.StateGstRateRepository;
|
| - |
|
14 |
import com.spice.profitmandi.dao.repository.inventory.VendorCatalogPricingLogRepository;
|
| - |
|
15 |
import com.spice.profitmandi.dao.repository.inventory.VendorCatalogPricingRepository;
|
| 13 |
import com.spice.profitmandi.dao.repository.inventory.VendorItemPricingRepository;
|
16 |
import com.spice.profitmandi.dao.repository.inventory.VendorItemPricingRepository;
|
| 14 |
import com.spice.profitmandi.dao.repository.warehouse.SupplierRepository;
|
17 |
import com.spice.profitmandi.dao.repository.warehouse.SupplierRepository;
|
| - |
|
18 |
import com.spice.profitmandi.service.inventory.VendorCatalogPricingService;
|
| 15 |
import in.shop2020.model.v1.catalog.status;
|
19 |
import in.shop2020.model.v1.catalog.status;
|
| 16 |
import org.apache.logging.log4j.LogManager;
|
20 |
import org.apache.logging.log4j.LogManager;
|
| 17 |
import org.apache.logging.log4j.Logger;
|
21 |
import org.apache.logging.log4j.Logger;
|
| 18 |
import org.apache.poi.ss.usermodel.Cell;
|
22 |
import org.apache.poi.ss.usermodel.Cell;
|
| 19 |
import org.apache.poi.ss.usermodel.DateUtil;
|
23 |
import org.apache.poi.ss.usermodel.DateUtil;
|
| Line 39... |
Line 43... |
| 39 |
private static List<Character> ALPHABETS = "ABCDEFGHIJKLMNOPQRSTUVWXYZ".chars().mapToObj(c -> (char) c).collect(Collectors.toList());
|
43 |
private static List<Character> ALPHABETS = "ABCDEFGHIJKLMNOPQRSTUVWXYZ".chars().mapToObj(c -> (char) c).collect(Collectors.toList());
|
| 40 |
@Autowired
|
44 |
@Autowired
|
| 41 |
ItemRepository itemRepository;
|
45 |
ItemRepository itemRepository;
|
| 42 |
|
46 |
|
| 43 |
@Autowired
|
47 |
@Autowired
|
| - |
|
48 |
VendorCatalogPricingRepository vendorCatalogPricingRepository;
|
| - |
|
49 |
|
| - |
|
50 |
@Autowired
|
| 44 |
StateGstRateRepository stateGstRateRepository;
|
51 |
StateGstRateRepository stateGstRateRepository;
|
| 45 |
|
52 |
|
| 46 |
@Autowired
|
53 |
@Autowired
|
| 47 |
VendorItemPricingRepository vendorItemPricingRepository;
|
54 |
VendorItemPricingRepository vendorItemPricingRepository;
|
| 48 |
|
55 |
|
| Line 223... |
Line 230... |
| 223 |
stateGstRateModel.setItemId(item.getId());
|
230 |
stateGstRateModel.setItemId(item.getId());
|
| 224 |
stateGstRateModel.setIgstRate(itemLoaderModel.getTaxRate());
|
231 |
stateGstRateModel.setIgstRate(itemLoaderModel.getTaxRate());
|
| 225 |
stateGstRateRepository.addStateGstRates(Arrays.asList(stateGstRateModel));
|
232 |
stateGstRateRepository.addStateGstRates(Arrays.asList(stateGstRateModel));
|
| 226 |
|
233 |
|
| 227 |
//Add Vendor
|
234 |
//Add Vendor
|
| - |
|
235 |
this.addVendorItemPricing(item, itemLoaderModel);
|
| - |
|
236 |
}
|
| - |
|
237 |
|
| - |
|
238 |
private void addVendorItemPricing(Item item, ItemLoaderModel itemLoaderModel) {
|
| - |
|
239 |
List<VendorCatalogPricing> vendorCatalogPricingList = vendorCatalogPricingRepository.selectByCatalogId(item.getCatalogItemId());
|
| - |
|
240 |
for (VendorCatalogPricing vendorCatalogPricing : vendorCatalogPricingList) {
|
| 228 |
VendorItemPricing vendorItemPricing = new VendorItemPricing();
|
241 |
VendorItemPricing vendorItemPricing = new VendorItemPricing();
|
| 229 |
vendorItemPricing.setItemId(item.getId());
|
242 |
vendorItemPricing.setItemId(item.getId());
|
| 230 |
vendorItemPricing.setVendorId(item.getPreferredVendor());
|
243 |
vendorItemPricing.setVendorId(vendorCatalogPricing.getVendorId());
|
| 231 |
vendorItemPricing.setDp((float) itemLoaderModel.getDp());
|
244 |
vendorItemPricing.setDp(vendorCatalogPricing.getDealerPrice());
|
| 232 |
vendorItemPricing.setMop((float) itemLoaderModel.getMop());
|
245 |
vendorItemPricing.setMop(vendorCatalogPricing.getMop());
|
| 233 |
vendorItemPricing.setNlc((float) itemLoaderModel.getNlc());
|
246 |
vendorItemPricing.setNlc(vendorCatalogPricing.getTransferPrice());
|
| 234 |
vendorItemPricing.setTp((float) itemLoaderModel.getTp());
|
247 |
vendorItemPricing.setTp(vendorCatalogPricing.getTransferPrice());
|
| 235 |
vendorItemPricingRepository.persist(vendorItemPricing);
|
248 |
vendorItemPricingRepository.persist(vendorItemPricing);
|
| - |
|
249 |
}
|
| 236 |
}
|
250 |
}
|
| 237 |
/*
|
251 |
/*
|
| 238 |
|
252 |
|
| 239 |
item = Item()
|
253 |
item = Item()
|
| 240 |
item.productGroup = product_group
|
254 |
item.productGroup = product_group
|