| 30859 |
tejbeer |
1 |
package com.spice.profitmandi.web.controller;
|
|
|
2 |
|
|
|
3 |
import java.math.BigDecimal;
|
|
|
4 |
import java.math.RoundingMode;
|
|
|
5 |
import java.time.LocalDate;
|
|
|
6 |
import java.time.LocalDateTime;
|
|
|
7 |
import java.util.Arrays;
|
|
|
8 |
import java.util.HashMap;
|
|
|
9 |
import java.util.List;
|
|
|
10 |
import java.util.Map;
|
|
|
11 |
import java.util.Map.Entry;
|
|
|
12 |
import java.util.stream.Collectors;
|
|
|
13 |
|
|
|
14 |
import javax.servlet.http.HttpServletRequest;
|
|
|
15 |
import javax.transaction.Transactional;
|
|
|
16 |
|
|
|
17 |
import org.apache.logging.log4j.LogManager;
|
|
|
18 |
import org.apache.logging.log4j.Logger;
|
|
|
19 |
import org.springframework.beans.factory.annotation.Autowired;
|
|
|
20 |
import org.springframework.stereotype.Controller;
|
|
|
21 |
import org.springframework.ui.Model;
|
|
|
22 |
import org.springframework.web.bind.annotation.RequestBody;
|
|
|
23 |
import org.springframework.web.bind.annotation.RequestMapping;
|
|
|
24 |
import org.springframework.web.bind.annotation.RequestMethod;
|
|
|
25 |
|
|
|
26 |
import com.spice.profitmandi.common.enumuration.MessageType;
|
|
|
27 |
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
|
|
|
28 |
import com.spice.profitmandi.common.model.CustomRetailer;
|
|
|
29 |
import com.spice.profitmandi.common.model.SendNotificationModel;
|
|
|
30 |
import com.spice.profitmandi.dao.entity.auth.AuthUser;
|
|
|
31 |
import com.spice.profitmandi.dao.entity.dtr.CreditAccount;
|
|
|
32 |
import com.spice.profitmandi.dao.entity.dtr.CreditStatus;
|
|
|
33 |
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
|
|
|
34 |
import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
|
|
|
35 |
import com.spice.profitmandi.dao.entity.transaction.SDCreditRequirement;
|
|
|
36 |
import com.spice.profitmandi.dao.entity.transaction.SanctionRequest;
|
|
|
37 |
import com.spice.profitmandi.dao.enumuration.fofo.Gateway;
|
|
|
38 |
import com.spice.profitmandi.dao.enumuration.transaction.CreditRisk;
|
|
|
39 |
import com.spice.profitmandi.dao.enumuration.transaction.SanctionStatus;
|
|
|
40 |
import com.spice.profitmandi.dao.model.SanctionRequestModel;
|
|
|
41 |
import com.spice.profitmandi.dao.model.SdCreditRequirementModel;
|
|
|
42 |
import com.spice.profitmandi.dao.repository.auth.AuthRepository;
|
|
|
43 |
import com.spice.profitmandi.dao.repository.dtr.CreditAccountRepository;
|
|
|
44 |
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
|
|
|
45 |
import com.spice.profitmandi.dao.repository.dtr.UserRepository;
|
|
|
46 |
import com.spice.profitmandi.dao.repository.fofo.PartnerDailyInvestmentRepository;
|
|
|
47 |
import com.spice.profitmandi.dao.repository.transaction.SDCreditRequirementRepository;
|
|
|
48 |
import com.spice.profitmandi.dao.repository.transaction.SanctionRequestRepository;
|
|
|
49 |
import com.spice.profitmandi.service.NotificationService;
|
|
|
50 |
import com.spice.profitmandi.service.transaction.SDCreditService;
|
|
|
51 |
import com.spice.profitmandi.service.user.RetailerService;
|
|
|
52 |
|
|
|
53 |
@Controller
|
|
|
54 |
@Transactional(rollbackOn = Throwable.class)
|
|
|
55 |
public class SDCreditController {
|
|
|
56 |
|
|
|
57 |
@Autowired
|
|
|
58 |
private RetailerService retailerService;
|
|
|
59 |
|
|
|
60 |
@Autowired
|
|
|
61 |
SDCreditRequirementRepository sdCreditRequirementRepository;
|
|
|
62 |
|
|
|
63 |
@Autowired
|
|
|
64 |
SanctionRequestRepository sanctionRequestRepository;
|
|
|
65 |
|
|
|
66 |
@Autowired
|
|
|
67 |
PartnerDailyInvestmentRepository partnerDailyInvestmentRepository;
|
|
|
68 |
|
|
|
69 |
@Autowired
|
|
|
70 |
private FofoStoreRepository fofoStoreRepository;
|
|
|
71 |
|
|
|
72 |
@Autowired
|
|
|
73 |
private CreditAccountRepository creditAccountRepository;
|
|
|
74 |
|
|
|
75 |
@Autowired
|
|
|
76 |
private SDCreditService sdCreditService;
|
|
|
77 |
|
|
|
78 |
@Autowired
|
|
|
79 |
private NotificationService notificationService;
|
|
|
80 |
|
|
|
81 |
@Autowired
|
|
|
82 |
private AuthRepository authRepository;
|
|
|
83 |
|
|
|
84 |
@Autowired
|
|
|
85 |
private UserRepository userRepository;
|
|
|
86 |
|
|
|
87 |
private static final Logger LOGGER = LogManager.getLogger(SDCreditController.class);
|
|
|
88 |
|
|
|
89 |
@RequestMapping(value = "/getSDCreditReq", method = RequestMethod.GET)
|
|
|
90 |
public String getSDCreditReq(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
|
|
|
91 |
|
|
|
92 |
Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(true);
|
|
|
93 |
|
|
|
94 |
Map<Integer, SDCreditRequirement> sdCreditRequirementMap = sdCreditRequirementRepository.selectAll().stream()
|
|
|
95 |
.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
|
|
|
96 |
|
|
|
97 |
for (Entry<Integer, CustomRetailer> customRetailerEntry : customRetailerMap.entrySet()) {
|
|
|
98 |
int fofoId = customRetailerEntry.getKey();
|
|
|
99 |
|
|
|
100 |
SDCreditRequirement sdCreditRequirement = sdCreditRequirementMap.get(customRetailerEntry.getKey());
|
|
|
101 |
FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(fofoId);
|
|
|
102 |
BigDecimal suggestedAmount = BigDecimal.valueOf(fofoStore.getMinimumInvestment() * 0.1);
|
|
|
103 |
|
|
|
104 |
LOGGER.info("suggestedAmount {} ", suggestedAmount);
|
|
|
105 |
|
|
|
106 |
if (sdCreditRequirement == null) {
|
|
|
107 |
sdCreditRequirement = new SDCreditRequirement();
|
|
|
108 |
sdCreditRequirement.setFofoId(fofoId);
|
|
|
109 |
sdCreditRequirement.setRisk(CreditRisk.NO_RISK);
|
|
|
110 |
sdCreditRequirement.setCreditDays(15);
|
|
|
111 |
sdCreditRequirement.setInterestRate(BigDecimal.valueOf(0.05));
|
|
|
112 |
sdCreditRequirement.setSuggestedLimit(suggestedAmount);
|
|
|
113 |
sdCreditRequirement.setLimit(suggestedAmount);
|
|
|
114 |
sdCreditRequirement.setUtilizedAmount(BigDecimal.ZERO);
|
|
|
115 |
sdCreditRequirement.setAvailableLimit(suggestedAmount);
|
|
|
116 |
|
|
|
117 |
sdCreditRequirement.setCreateTimestamp(LocalDateTime.now());
|
|
|
118 |
sdCreditRequirement.setUpdateTimestamp(LocalDateTime.now());
|
|
|
119 |
sdCreditRequirementRepository.persist(sdCreditRequirement);
|
|
|
120 |
} else {
|
|
|
121 |
sdCreditRequirement.setSuggestedLimit(suggestedAmount);
|
|
|
122 |
sdCreditRequirement.setUpdateTimestamp(LocalDateTime.now());
|
|
|
123 |
}
|
|
|
124 |
|
|
|
125 |
}
|
|
|
126 |
|
|
|
127 |
model.addAttribute("customRetailerMap", customRetailerMap);
|
|
|
128 |
model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
|
|
|
129 |
return "sd-credit";
|
|
|
130 |
}
|
|
|
131 |
|
|
|
132 |
@RequestMapping(value = "/creditRequirement", method = RequestMethod.POST)
|
|
|
133 |
public String sdCredit(HttpServletRequest request, @RequestBody SdCreditRequirementModel sdCreditRequirementModel,
|
|
|
134 |
Model model) throws Exception {
|
|
|
135 |
|
|
|
136 |
LOGGER.info("sdCreditRequirementModel {} ", sdCreditRequirementModel);
|
|
|
137 |
|
|
|
138 |
int fofoId = sdCreditRequirementModel.getFofoId();
|
|
|
139 |
|
|
|
140 |
SDCreditRequirement sdCreditRequirement = sdCreditRequirementRepository
|
|
|
141 |
.selectByFofoId(sdCreditRequirementModel.getFofoId());
|
|
|
142 |
|
|
|
143 |
FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(sdCreditRequirementModel.getFofoId());
|
|
|
144 |
BigDecimal suggestedAmount = new BigDecimal((fofoStore.getMinimumInvestment() * 0.1));
|
|
|
145 |
|
|
|
146 |
LOGGER.info("sdCreditRequirement {} ", sdCreditRequirement);
|
|
|
147 |
|
|
|
148 |
sdCreditRequirement.setSecurityCheck(sdCreditRequirementModel.getSecurityCheck());
|
|
|
149 |
// sdCreditRequirement.setSecurityCheck(2);
|
|
|
150 |
|
|
|
151 |
sdCreditRequirement.setInterestRate(sdCreditRequirementModel.getInterest());
|
|
|
152 |
sdCreditRequirement.setFreeDays(sdCreditRequirementModel.getFreeDays());
|
|
|
153 |
sdCreditRequirement.setLimit(sdCreditRequirementModel.getLimit());
|
|
|
154 |
sdCreditRequirement.setSuggestedLimit(suggestedAmount);
|
| 30865 |
tejbeer |
155 |
BigDecimal utilizedLimit = new BigDecimal(sdCreditService.getUtilizationAmount(fofoId));
|
|
|
156 |
|
|
|
157 |
BigDecimal availableLimit = sdCreditRequirement.getLimit().subtract(utilizedLimit);
|
|
|
158 |
|
| 30859 |
tejbeer |
159 |
sdCreditRequirement.setUtilizedAmount(utilizedLimit);
|
|
|
160 |
|
|
|
161 |
sdCreditRequirement.setAvailableLimit(availableLimit);
|
|
|
162 |
sdCreditRequirement.setCreditDays(15);
|
|
|
163 |
sdCreditRequirement.setRisk(CreditRisk.NO_RISK);
|
|
|
164 |
|
|
|
165 |
sdCreditRequirement.setUpdateTimestamp(LocalDateTime.now());
|
|
|
166 |
|
|
|
167 |
if (sdCreditRequirement.getSecurityCheck() > 0) {
|
|
|
168 |
|
|
|
169 |
CreditAccount creditAccount = creditAccountRepository
|
|
|
170 |
.selectByFofoIdAndGateway(sdCreditRequirementModel.getFofoId(), Gateway.SDDIRECT);
|
|
|
171 |
if (creditAccount == null) {
|
|
|
172 |
creditAccount = new CreditAccount();
|
|
|
173 |
creditAccount.setFofoId(sdCreditRequirementModel.getFofoId());
|
|
|
174 |
creditAccount.setGateway(Gateway.SDDIRECT);
|
|
|
175 |
creditAccount.setCreditStatus(CreditStatus.SANCTIONED);
|
|
|
176 |
creditAccount.setActive(false);
|
|
|
177 |
|
|
|
178 |
creditAccount.setUpdatedOn(LocalDateTime.now());
|
|
|
179 |
|
|
|
180 |
creditAccountRepository.persist(creditAccount);
|
|
|
181 |
}
|
|
|
182 |
|
|
|
183 |
creditAccount.setInterestRate(sdCreditRequirement.getInterestRate().floatValue());
|
|
|
184 |
creditAccount.setSanctionedAmount(sdCreditRequirement.getLimit().floatValue());
|
|
|
185 |
creditAccount.setAvailableAmount(availableLimit.floatValue());
|
|
|
186 |
creditAccount.setFreeDays(sdCreditRequirement.getFreeDays());
|
|
|
187 |
creditAccount.setUpdatedOn(LocalDateTime.now());
|
|
|
188 |
|
|
|
189 |
}
|
|
|
190 |
LOGGER.info("sdCreditRequirement {} ", sdCreditRequirement);
|
|
|
191 |
|
|
|
192 |
CustomRetailer customRetailer = retailerService.getFofoRetailer(sdCreditRequirementModel.getFofoId());
|
|
|
193 |
|
| 30865 |
tejbeer |
194 |
sdCreditRequirement = sdCreditRequirementRepository.selectByFofoId(sdCreditRequirementModel.getFofoId());
|
|
|
195 |
|
| 30859 |
tejbeer |
196 |
Map<Integer, SDCreditRequirement> sdCreditRequirementMap = new HashMap<>();
|
|
|
197 |
sdCreditRequirementMap.put(sdCreditRequirement.getFofoId(), sdCreditRequirement);
|
|
|
198 |
model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
|
|
|
199 |
model.addAttribute("customRetailer", customRetailer);
|
|
|
200 |
|
|
|
201 |
return "sd-credit-requirement-row";
|
|
|
202 |
|
|
|
203 |
}
|
|
|
204 |
|
|
|
205 |
@RequestMapping(value = "/getSanctionRequest", method = RequestMethod.GET)
|
|
|
206 |
public String getSanctionRequest(HttpServletRequest request, Model model) throws ProfitMandiBusinessException {
|
|
|
207 |
|
|
|
208 |
List<SanctionRequest> sanctionRequests = sanctionRequestRepository.selectByDate(LocalDate.now());
|
|
|
209 |
|
|
|
210 |
List<Integer> fofoIds = sanctionRequests.stream().map(x -> x.getFofoId()).collect(Collectors.toList());
|
|
|
211 |
|
|
|
212 |
Map<Integer, SDCreditRequirement> sdCreditRequirementMap = sdCreditRequirementRepository.selectAll().stream()
|
|
|
213 |
.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
|
|
|
214 |
|
|
|
215 |
if (!sanctionRequests.isEmpty()) {
|
|
|
216 |
|
|
|
217 |
Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(fofoIds);
|
|
|
218 |
Map<Integer, PartnerDailyInvestment> partnerDailyInvestmentMap = partnerDailyInvestmentRepository
|
|
|
219 |
.selectAll(fofoIds, LocalDate.now().minusDays(90)).stream()
|
|
|
220 |
.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
|
|
|
221 |
|
|
|
222 |
model.addAttribute("customRetailerMap", customRetailerMap);
|
|
|
223 |
|
|
|
224 |
model.addAttribute("partnerDailyInvestmentMap", partnerDailyInvestmentMap);
|
|
|
225 |
|
|
|
226 |
}
|
|
|
227 |
|
|
|
228 |
model.addAttribute("sanctionRequests", sanctionRequests);
|
|
|
229 |
|
|
|
230 |
model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
|
|
|
231 |
|
|
|
232 |
model.addAttribute("sanctionStatus", SanctionStatus.values());
|
|
|
233 |
return "sanction-request";
|
|
|
234 |
|
|
|
235 |
}
|
|
|
236 |
|
|
|
237 |
@RequestMapping(value = "/sanctionRequest", method = RequestMethod.POST)
|
|
|
238 |
public String sanctionRequest(HttpServletRequest request, @RequestBody SanctionRequestModel sanctionRequestModel,
|
|
|
239 |
Model model) throws Exception {
|
|
|
240 |
|
|
|
241 |
LOGGER.info("sanctionRequestModel {} ", sanctionRequestModel);
|
|
|
242 |
Map<Integer, SDCreditRequirement> sdCreditRequirementMap = sdCreditRequirementRepository.selectAll().stream()
|
|
|
243 |
.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
|
|
|
244 |
|
|
|
245 |
SanctionRequest sanctionRequest = sanctionRequestRepository.selectById(sanctionRequestModel.getId());
|
|
|
246 |
List<Integer> fofoIds = sanctionRequestRepository.selectByDate(LocalDate.now()).stream().map(x -> x.getFofoId())
|
|
|
247 |
.collect(Collectors.toList());
|
|
|
248 |
|
|
|
249 |
Map<Integer, CustomRetailer> customRetailerMap = retailerService.getFofoRetailers(fofoIds);
|
|
|
250 |
|
|
|
251 |
LOGGER.info("freeDays {} ", sdCreditRequirementMap.get(sanctionRequest.getFofoId()).getFreeDays());
|
|
|
252 |
|
|
|
253 |
if (sanctionRequestModel.getStatus().equals(SanctionStatus.APPROVED)) {
|
|
|
254 |
CustomRetailer customRetailer = customRetailerMap.get(sanctionRequest.getFofoId());
|
|
|
255 |
sanctionRequest.setApprovalTimestamp(LocalDateTime.now());
|
|
|
256 |
BigDecimal availableAmount = sdCreditService.getAvailableAmount(sanctionRequest.getFofoId());
|
|
|
257 |
|
|
|
258 |
String title = "Sanction Request Approved";
|
|
|
259 |
String url = "http://app.smartdukaan.com/pages/home/credit";
|
|
|
260 |
String message = "congratulations! Your credit limit is increased for today Rs."
|
|
|
261 |
+ sanctionRequest.getApprovalAmount().setScale(2, RoundingMode.HALF_UP)
|
|
|
262 |
+ " your total available limit is Rs." + availableAmount.setScale(2, RoundingMode.HALF_UP);
|
|
|
263 |
notificationService.sendNotification(sanctionRequest.getFofoId(), title, MessageType.notification, title,
|
|
|
264 |
message, url);
|
|
|
265 |
|
|
|
266 |
AuthUser authUser = authRepository.selectById(sanctionRequest.getAuthId());
|
|
|
267 |
|
|
|
268 |
SendNotificationModel sendNotificationModel = new SendNotificationModel();
|
|
|
269 |
sendNotificationModel.setCampaignName("Loan");
|
|
|
270 |
sendNotificationModel.setTitle("Sanction Request Approved");
|
|
|
271 |
sendNotificationModel.setMessage("congratulations! Your Partner " + customRetailer.getBusinessName()
|
|
|
272 |
+ "credit limit is increased for today Rs."
|
|
|
273 |
+ sanctionRequest.getApprovalAmount().setScale(2, RoundingMode.HALF_UP)
|
|
|
274 |
+ " your total available limit is Rs." + availableAmount.setScale(2, RoundingMode.HALF_UP));
|
|
|
275 |
sendNotificationModel.setType("url");
|
|
|
276 |
sendNotificationModel.setUrl("https://app.smartdukaan.com/pages/home/credit");
|
|
|
277 |
sendNotificationModel.setExpiresat(LocalDateTime.now().plusDays(2));
|
|
|
278 |
sendNotificationModel.setMessageType(MessageType.notification);
|
|
|
279 |
sendNotificationModel
|
|
|
280 |
.setUserIds(Arrays.asList(userRepository.selectByEmailId(authUser.getEmailId()).getId()));
|
|
|
281 |
System.out.println(sendNotificationModel);
|
|
|
282 |
notificationService.sendNotification(sendNotificationModel);
|
|
|
283 |
|
|
|
284 |
}
|
|
|
285 |
|
|
|
286 |
if (sdCreditRequirementMap.get(sanctionRequest.getFofoId()).getFreeDays() >= sanctionRequestModel
|
|
|
287 |
.getFreeDays()) {
|
|
|
288 |
sanctionRequest.setFreeDays(sanctionRequestModel.getFreeDays());
|
|
|
289 |
} else {
|
|
|
290 |
throw new ProfitMandiBusinessException("Free Days", "Free Days", "Free Days is not more than "
|
|
|
291 |
+ sdCreditRequirementMap.get(sanctionRequest.getFofoId()).getFreeDays() + " days ");
|
|
|
292 |
}
|
|
|
293 |
|
|
|
294 |
sanctionRequest.setApprovalAmount(sanctionRequestModel.getApprovalAmount());
|
|
|
295 |
sanctionRequest.setStatus(sanctionRequestModel.getStatus());
|
|
|
296 |
|
|
|
297 |
Map<Integer, PartnerDailyInvestment> partnerDailyInvestmentMap = partnerDailyInvestmentRepository
|
|
|
298 |
.selectAll(fofoIds, LocalDate.now().minusDays(90)).stream()
|
|
|
299 |
.collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
|
|
|
300 |
sanctionRequest = sanctionRequestRepository.selectById(sanctionRequestModel.getId());
|
|
|
301 |
model.addAttribute("customRetailerMap", customRetailerMap);
|
|
|
302 |
model.addAttribute("sanctionRequest", sanctionRequest);
|
|
|
303 |
model.addAttribute("partnerDailyInvestmentMap", partnerDailyInvestmentMap);
|
|
|
304 |
model.addAttribute("sdCreditRequirementMap", sdCreditRequirementMap);
|
|
|
305 |
|
|
|
306 |
model.addAttribute("sanctionStatus", SanctionStatus.values());
|
|
|
307 |
|
|
|
308 |
return "sanction-request-row";
|
|
|
309 |
|
|
|
310 |
}
|
|
|
311 |
|
|
|
312 |
}
|