Subversion Repositories SmartDukaan

	public void createOffers(int offerId) throws Exception {

	public void createOffers(String fileName) throws Exception {

		Map<List<Integer>, List<Integer>> targetMap = new HashMap<>();

		Map<CreateOfferRequest, List<PartnerTargetModel>> offerPartnerTargetMap = this.parseFromExcel(fileName);

		targetMap.put(Arrays.asList(175138805, 175138733, 175138821, 175138886, 175138853, 175138799),

		for(Map.Entry<CreateOfferRequest, List<PartnerTargetModel>> partnerTargetEntry: offerPartnerTargetMap.entrySet()) {

				Arrays.asList(300000, 330000, 375000));

			CreateOfferRequest createOfferRequest = partnerTargetEntry.getKey();

		targetMap.put(Arrays.asList(175138895, 175138877, 175138854, 175138857, 175138870, 175138862, 175138873),

			Map<List<Integer>, List<Integer>> targetPartnerMap = partnerTargetEntry.getValue().stream().collect(Collectors.groupingBy(PartnerTargetModel::getTargets, Collectors.mapping(PartnerTargetModel::getFofoId, Collectors.toList())));

				Arrays.asList(350000, 400000, 450000));

					for (Map.Entry<List<Integer>, List<Integer>> targetPartnersEntry : targetPartnerMap.entrySet()) {

		targetMap.put(Arrays.asList(175138878), Arrays.asList(380000, 418000, 475000));

						List<Integer> fofoIds = createOfferRequest.getPartnerCriteria().getFofoIds();

		targetMap.put(Arrays.asList(175138922, 175138833, 175138893, 175138939, 175138832, 175138949, 175138882,

						List<Integer> filterFofoIds = targetPartnersEntry.getKey().stream().filter(x->!fofoIds.contains(x)).collect(Collectors.toList());

				175138876, 175138834, 175138930, 175138911, 175138522, 175138871, 175138934, 175138900, 4149607,

						List<Integer> targets = targetPartnersEntry.getKey();

				175138835, 175138941, 175138917, 175138855, 175138825, 175138896, 175138866, 175138174, 175138887,

						createOfferRequest.getPartnerCriteria().setFofoIds(filterFofoIds);

				175138816, 175138892, 175135376, 175138918, 175138845, 175138946, 175138920, 175138903, 175138813,

						int counter = 0;

				175138901, 175138899, 175136389, 175138913, 175138919, 175138923, 175138926, 175138950, 175138953,

						for (com.spice.profitmandi.dao.model.TargetSlab targetSlab : createOfferRequest.getTargetSlabs()) {

				175138954, 175138955), Arrays.asList(400000, 500000, 600000));

							targetSlab.setOnwardsAmount(targets.get(counter));

		targetMap.put(Arrays.asList(175138839), Arrays.asList(412000, 453200, 515000));

						offerService.addOfferService(createOfferRequest);

		targetMap.put(Arrays.asList(175138716), Arrays.asList(450000, 495000, 562500));

	private Map<CreateOfferRequest, List<PartnerTargetModel>> parseFromExcel(String fileName) throws ProfitMandiBusinessException {

		targetMap.put(Arrays.asList(175138812), Arrays.asList(465000, 511500, 581250));

		Map<CreateOfferRequest, List<PartnerTargetModel>> offerPartnerTargetMap =  new HashMap<>();

		targetMap.put(Arrays.asList(175138859, 175138906, 175138874, 175138940, 175138916, 175136207, 175138851,

			FileInputStream fileInputStream = new FileInputStream(fileName);

				175138844, 175138929), Arrays.asList(500000, 600000, 700000));

			myWorkBook = new XSSFWorkbook(fileInputStream);

		targetMap.put(Arrays.asList(175138804, 175138910), Arrays.asList(550000, 600000, 650000));

			myWorkBook.setMissingCellPolicy(MissingCellPolicy.RETURN_BLANK_AS_NULL);

		targetMap.put(Arrays.asList(175127215, 175138879), Arrays.asList(555000, 610500, 693750));

			for(int i=0; i< myWorkBook.getNumberOfSheets();i++) {

		targetMap.put(

				Arrays.asList(600000, 730000, 840000));

				XSSFSheet mySheet = myWorkBook.getSheetAt(i);

		targetMap.put(Arrays.asList(172157716), Arrays.asList(616000, 677600, 770000));

				int offerId = Integer.parseInt(mySheet.getSheetName());

		targetMap.put(Arrays.asList(175138674, 175138840), Arrays.asList(650000, 715000, 812500));

				CreateOfferRequest existingOffer = offerService.getOffer(offerId);

		targetMap.put(Arrays.asList(175138936, 175138952, 175138907, 156232687, 175138856, 175138836, 175138942),

				List<PartnerTargetModel> partnerTargetModels = new ArrayList<>();

				Arrays.asList(700000, 800000, 900000));

				offerPartnerTargetMap.put(existingOffer, partnerTargetModels);

		targetMap.put(Arrays.asList(175138868), Arrays.asList(775000, 852500, 968750));

				LOGGER.info("rowCellNum {}", mySheet.getLastRowNum());

		targetMap.put(Arrays.asList(175138820), Arrays.asList(780000, 850000, 1050000));

				for (int rowNumber = 1; rowNumber <= mySheet.getLastRowNum(); rowNumber++) {

		targetMap.put(Arrays.asList(175138864, 175138863, 175138867, 175138823, 175135227),

					XSSFRow row = mySheet.getRow(rowNumber);

				Arrays.asList(800000, 900000, 1000000));

					LOGGER.info("row {}", row);

		targetMap.put(Arrays.asList(175138408), Arrays.asList(850000, 900000, 950000));

					PartnerTargetModel partnerTargetModel = new PartnerTargetModel();

		targetMap.put(Arrays.asList(175135923, 175138888), Arrays.asList(900000, 990000, 1125000));

					if (row.getCell(0) != null && row.getCell(0).getCellTypeEnum() == CellType.NUMERIC) {

		targetMap.put(Arrays.asList(175138908), Arrays.asList(1000000, 1200000, 1350000));

						partnerTargetModel.setFofoId((int) row.getCell(0).getNumericCellValue());

		targetMap.put(Arrays.asList(175138843), Arrays.asList(1100000, 1200000, 1350000));

						ProfitMandiBusinessException profitMandiBusinessException = new ProfitMandiBusinessException(

		targetMap.put(Arrays.asList(175138827), Arrays.asList(1150000, 1265000, 1437500));

								"FOFO ID", row.getCell(0).toString(), "TGLSTNG_VE_1010");

		targetMap.put(Arrays.asList(175138883, 175135707), Arrays.asList(1200000, 1300000, 1400000));

						LOGGER.error("Excel file parse error : ", profitMandiBusinessException);

		targetMap.put(Arrays.asList(175138814, 175138829), Arrays.asList(1300000, 1500000, 1650000));

					for (int cellNumber = 1; cellNumber <= existingOffer.getTargetSlabs().size(); cellNumber++) {

		targetMap.put(Arrays.asList(175138842, 175138875), Arrays.asList(1500000, 1650000, 1800000));

								&& row.getCell(cellNumber).getCellTypeEnum() == CellType.NUMERIC) {

		targetMap.put(Arrays.asList(175138541), Arrays.asList(1600000, 1700000, 1850000));

							targets.add((int) row.getCell(cellNumber).getNumericCellValue());

		targetMap.put(Arrays.asList(175138372), Arrays.asList(1890000, 2079000, 2362500));

							ProfitMandiBusinessException profitMandiBusinessException = new ProfitMandiBusinessException(

		targetMap.put(Arrays.asList(175138885), Arrays.asList(2100000, 2400000, 2600000));

									"Target Column issue at " + rowNumber + ", " + cellNumber, row.getCell(cellNumber),

		CreateOfferRequest createOfferRequest = offerService.getOffer(offerId);

							LOGGER.error("Excel file parse error : ", profitMandiBusinessException);

		for (Map.Entry<List<Integer>, List<Integer>> targetEntry : targetMap.entrySet()) {

					partnerTargetModel.setTargets(targets);

			List<Integer> targets = targetEntry.getValue();

					partnerTargetModels.add(partnerTargetModel);

			}

			createOfferRequest.getPartnerCriteria().setFofoIds(targetEntry.getKey());

		} catch ( ProfitMandiBusinessException pbse) {

			int counter = 0;

			throw pbse;

			for (com.spice.profitmandi.dao.model.TargetSlab targetSlab : createOfferRequest.getTargetSlabs()) {

			throw new ProfitMandiBusinessException(ProfitMandiConstants.EXCEL_FILE, ioException.getMessage(),

				targetSlab.setOnwardsAmount(targets.get(counter));

			if (myWorkBook != null) {

				counter++;

				try {