WebSVN – SmartDukaan – Diff – /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

 import com.spice.profitmandi.dao.entity.auth.AuthUser;
 import com.spice.profitmandi.dao.entity.auth.PartnerCollectionRemark;
 import com.spice.profitmandi.dao.entity.catalog.FocusedModel;
 import com.spice.profitmandi.dao.entity.catalog.Item;
 import com.spice.profitmandi.dao.entity.catalog.Scheme;
+import com.spice.profitmandi.dao.entity.catalog.TagListing;
 import com.spice.profitmandi.dao.entity.cs.Position;
 import com.spice.profitmandi.dao.entity.cs.Ticket;
 import com.spice.profitmandi.dao.entity.dtr.User;
 import com.spice.profitmandi.dao.entity.dtr.*;
 import com.spice.profitmandi.dao.entity.fofo.*;
 	private static final Logger LOGGER = LogManager.getLogger(ScheduledTasks.class);
 	private String FCM_URL = "https://fcm.googleapis.com/fcm/send";
 	private String FCM_API_KEY = "AAAASAjNcn4:APA91bG6fWRIgYJI0L9gCjP5ynaXz2hJHYKtD9dfH7Depdv31Nd9APJwhx-OPkAJ1WSz4BGNYG8lHThLFSjDGFxIwUZv241YcAJEGDLgt86mxq9FXJe-yBRu-S0_ZwHqmX-QaVKl5F_A";
+	@Autowired
+	private TagListingRepository tagListingRepository;
 	public void generateDailyRecharge() {
 		List<RechargeProviderCreditWalletHistory> allCreditHistory = rechargeProviderCreditWalletHistoryRepository
 				.selectAll(0, 2000);
 		List<RechargeProvider> rechargeProviders = rechargeProviderRepository.selectAll();
 		rechargeProviders.stream().forEach(x -> x.setAmount(0));
 				int grnStockQty = grnPendingQty + inStockQty;
 				int totalQty = processingQty + grnPendingQty + inStockQty;
 				int shortageQty = minQty - totalQty;
 				List<Item> items = itemRepository.selectAllByCatalogItemId(entry.getKey());
+				TagListing tagListing = tagListingRepository.selectByCatalogId(entry.getKey());
 				FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(fofoId);
 				Map<Integer, List<SaholicCIS>> itemAvailabilityMap = warehouseItemAvailabilityMap
 						.get(fofoStore.getWarehouseId());
 				fm.setModelName(items.get(0).getModelName());
 				fm.setModelNumber(items.get(0).getModelNumber());
 				fm.setGrnStockQty(grnStockQty);
 				fm.setPendingIndentQty(processingQty);
 				fm.setShortageQty(shortageQty);
-				fm.setPoAvailabitiy(allColorPoAvailability);
+				fm.setPoAvailability(allColorPoAvailability);
+				fm.setDp(tagListing.getSellingPrice());
 				fm.setWarehouseName(warehouseMap.get(customRetailer.getWarehouseId()));
 				fm.setStateManager(partnerIdSalesHeadersMap.get(fofoId).getRegionalManager());
 				fm.setTerritoryManager(partnerIdSalesHeadersMap.get(fofoId).getTerritoryManager());
 				fm.setItemName(items.get(0).getBrand() + items.get(0).getModelNumber() + items.get(0).getModelName());
-				fm.setAvailabitiy(allColorNetAvailability);
+				fm.setAvailability(allColorNetAvailability);
 				focusedModelShortageList.add(fm);
+			}
-			/*
-			 * if (!focusedModelShortageList.isEmpty()) { String subject = "Stock Alert";
-			 * String messageText = this.getMessage(focusedModelShortageList);
-			 *
-			 * this.sendMailWithAttachments(subject, messageText,
-			 * customRetailer.getEmail()); String notificationMessage =
-			 * this.getNotificationMessage(focusedModelShortageList);
-			 *
-			 * LOGGER.info("notificationMessage" + notificationMessage);
-			 *
-			 * SendNotificationModel sendNotificationModel = new SendNotificationModel();
-			 * sendNotificationModel.setCampaignName("Stock Alert");
-			 * sendNotificationModel.setTitle("Alert");
-			 * sendNotificationModel.setMessage(notificationMessage);
-			 * sendNotificationModel.setType("url"); sendNotificationModel.setUrl(
-			 * "https://app.smartdukaan.com/pages/home/notifications");
-			 * sendNotificationModel.setExpiresat(LocalDateTime.now().plusDays(2));
-			 * sendNotificationModel.setMessageType(MessageType.notification); int userId =
-			 * userAccountRepository.selectUserIdByRetailerId(fofoId);
-			 * sendNotificationModel.setUserIds(Arrays.asList(userId));
-			 * notificationService.sendNotification(sendNotificationModel);
-			 *
-			 * }
-			 */
+		}
 		if (!focusedModelShortageReportMap.isEmpty()) {
 			String fileName = "Stock Alert-" + FormattingUtils.formatDate(LocalDateTime.now()) + ".csv";
 			Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
 			Map<String, List<List<?>>> emailRowsMap = new HashMap<>();
 						if (!emailRowsMap.containsKey(y.getKey())) {
 							emailRowsMap.put(y.getKey(), new ArrayList<>());
+						}
 						List<List<? extends Serializable>> fms = x.getValue().stream()
 								.map(r -> Arrays.asList(r.getStoreCode(), r.getStoreName(), r.getBrandName(),
-										r.getModelName(), r.getModelNumber(), r.getWarehouseName(), r.getStateManager(),
+										r.getModelName(), r.getModelNumber(), r.getDp(), r.getWarehouseName(), r.getStateManager(),
 										r.getTerritoryManager(), r.getPendingIndentQty(), r.getGrnStockQty(),
-										r.getShortageQty(), r.getAvailabitiy()))
+										r.getShortageQty(), r.getAvailability()))
 								.collect(Collectors.toList());
 						emailRowsMap.get(y.getKey()).addAll(fms);
+					}
 				});
 			});
-			List<String> headers = Arrays.asList("Store Code", "Store Name", "Brand", "Model Name", "Model Number",
+			List<String> headers = Arrays.asList("Store Code", "Store Name", "Brand", "Model Name", "Model Number", "DP",
 					"Warehouse Name", "State Manager", "Territory Manager", "Pending Indent", "InStock", "Shortage Qty",
 					"Availability");
 			emailRowsMap.entrySet().forEach(entry -> {
 				ByteArrayOutputStream baos = null;
 		List<Integer> assignTo = Arrays.asList(15, 9, 54, 53);
 		Map<Integer, AuthUser> assignAuthUserMap = authRepository.selectAllAuthUserByIds(assignTo).stream()
 				.collect(Collectors.toMap(x -> x.getId(), x -> x));
-		List<String> sendTo = Arrays.asList("kamini.sharma@smartdukaan.com", "tarun.verma@smartdukaan.com",
+		List<String> sendTo = Arrays.asList("kamini.sharma@smartdukaan.com", "tarun.verma@smartdukaan.com", "sm@smartdukaan.com");
-				"niranjan.kala@smartdukaan.com", "sm@smartdukaan.com");
 		LOGGER.info("partnerProblem" + partnerProblems);
 		StringBuilder sb = new StringBuilder();
 		sb.append("<htl><body>");
 		sb.append(
 				"<p>Number against MTD or Investment are the count of days the MTD is low VS LMTD OR Investment is below 75%.</p><br/><p>These partners needs immediate attention.</p><br/><table style='border:1px solid black';cellspacing=0>");

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java – Rev 31332 → 31388