Subversion Repositories SmartDukaan

Rev

Rev 29340 | Rev 30426 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
25640 tejbeer 1
 
2
package com.spice.profitmandi.web.controller;
3
 
29329 amit.gupta 4
import java.time.LocalDate;
25640 tejbeer 5
import java.time.LocalDateTime;
6
import java.util.ArrayList;
26751 amit.gupta 7
import java.util.Collection;
25640 tejbeer 8
import java.util.HashMap;
9
import java.util.List;
10
import java.util.Map;
26751 amit.gupta 11
import java.util.Set;
25640 tejbeer 12
import java.util.stream.Collectors;
13
 
14
import javax.servlet.http.HttpServletRequest;
15
 
16
import org.apache.logging.log4j.LogManager;
17
import org.apache.logging.log4j.Logger;
18
import org.springframework.beans.factory.annotation.Autowired;
19
import org.springframework.stereotype.Controller;
20
import org.springframework.transaction.annotation.Transactional;
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;
25650 tejbeer 25
import org.springframework.web.bind.annotation.RequestParam;
25640 tejbeer 26
 
27
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
28
import com.spice.profitmandi.common.model.CustomRetailer;
29
import com.spice.profitmandi.dao.entity.fofo.CustomerAddress;
30
import com.spice.profitmandi.dao.entity.fofo.FofoOrder;
31
import com.spice.profitmandi.dao.entity.fofo.FofoOrderItem;
32
import com.spice.profitmandi.dao.entity.fofo.HygieneData;
29329 amit.gupta 33
import com.spice.profitmandi.dao.model.DateRangeModel;
25640 tejbeer 34
import com.spice.profitmandi.dao.repository.catalog.HygieneDataModel;
25650 tejbeer 35
import com.spice.profitmandi.dao.repository.catalog.ItemRepository;
27489 tejbeer 36
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
25640 tejbeer 37
import com.spice.profitmandi.dao.repository.fofo.CustomerAddressRepository;
38
import com.spice.profitmandi.dao.repository.fofo.FofoOrderItemRepository;
39
import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
40
import com.spice.profitmandi.dao.repository.fofo.HygieneDataRepository;
29329 amit.gupta 41
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
25640 tejbeer 42
import com.spice.profitmandi.service.user.RetailerService;
43
import com.spice.profitmandi.web.util.MVCResponseSender;
44
 
45
@Controller
46
@Transactional(rollbackFor = Throwable.class)
47
public class HygieneController {
48
 
49
	@Autowired
50
	private FofoOrderRepository fofoOrderRepository;
51
 
52
	@Autowired
53
	private CustomerAddressRepository customerAddressRepository;
54
 
55
	@Autowired
56
	private RetailerService retailerService;
57
 
58
	@Autowired
59
	private FofoOrderItemRepository fofoOrderItemRepository;
60
 
61
	@Autowired
62
	private HygieneDataRepository hygieneDataRepository;
63
 
64
	@Autowired
25650 tejbeer 65
	private ItemRepository itemRepository;
27489 tejbeer 66
 
25650 tejbeer 67
	@Autowired
27489 tejbeer 68
	private RetailerService reatilerService;
69
 
70
	@Autowired
71
	private FofoStoreRepository fofotSoreRepository;
72
	@Autowired
25640 tejbeer 73
	private MVCResponseSender mvcResponseSender;
74
	private static final Logger LOGGER = LogManager.getLogger(HygieneController.class);
75
 
76
	@RequestMapping(value = "/getHygieneData", method = RequestMethod.GET)
27489 tejbeer 77
	public String getHygieneData(HttpServletRequest request,
78
			@RequestParam(name = "fofoId", required = false, defaultValue = "0") int fofoId, Model model)
79
			throws ProfitMandiBusinessException {
80
		List<HygieneData> hygieneData = null;
81
		if (fofoId != 0) {
82
			hygieneData = hygieneDataRepository.selectAllByFofoIdDisposedTimestamp(fofoId);
83
		} else {
84
			hygieneData = hygieneDataRepository.selectByDisposedTimestamp();
85
		}
86
 
26751 amit.gupta 87
		List<Integer> orderIds = hygieneData.stream().map(x -> x.getOrderId()).collect(Collectors.toList());
88
		Map<Integer, FofoOrder> fofoOrdersMap = this.getfofoOrderByOrderId(orderIds);
27489 tejbeer 89
		Set<Integer> fofoIds = fofoOrdersMap.values().stream().map(x -> x.getFofoId()).collect(Collectors.toSet());
26751 amit.gupta 90
		Map<Integer, CustomerAddress> customerAddress = this.getCustomerAddressByFofoOrder(fofoOrdersMap.values());
25640 tejbeer 91
 
27489 tejbeer 92
		Map<Integer, CustomRetailer> partnerAddressMap = retailerService
93
				.getFofoRetailers(new ArrayList<Integer>(fofoIds));
25640 tejbeer 94
 
27489 tejbeer 95
		model.addAttribute("hygieneData", hygieneData).addAttribute("fofoOrder", fofoOrdersMap)
96
				.addAttribute("partnerAddress", partnerAddressMap).addAttribute("customerAddress", customerAddress);
97
 
25640 tejbeer 98
		return "hygiene";
99
	}
100
 
26751 amit.gupta 101
	private Map<Integer, FofoOrder> getfofoOrderByOrderId(List<Integer> fofoOrderIds)
25650 tejbeer 102
			throws ProfitMandiBusinessException {
26751 amit.gupta 103
		Map<Integer, FofoOrder> fofoOrders = fofoOrderRepository.selectAllByOrderIds(fofoOrderIds).stream()
104
				.collect(Collectors.toMap(x -> x.getId(), x -> x));
25640 tejbeer 105
 
106
		return fofoOrders;
107
	}
108
 
26751 amit.gupta 109
	private Map<Integer, CustomerAddress> getCustomerAddressByFofoOrder(Collection<FofoOrder> fofoOrders)
25640 tejbeer 110
			throws ProfitMandiBusinessException {
111
		Map<Integer, CustomerAddress> customerAddressMap = new HashMap<>();
26751 amit.gupta 112
		for (FofoOrder fofoOrder : fofoOrders) {
25640 tejbeer 113
			CustomerAddress ca = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
25678 tejbeer 114
			customerAddressMap.put(fofoOrder.getCustomerAddressId(), ca);
25640 tejbeer 115
		}
116
		return customerAddressMap;
117
	}
118
 
119
	@RequestMapping(value = "/getFetchHygieneData", method = RequestMethod.GET)
120
	public String getFetchHygieneData(HttpServletRequest request, Model model) throws Exception {
121
 
122
		FofoOrder fofoOrder = null;
123
		CustomRetailer customRetailer = null;
124
		CustomerAddress customerAddress = null;
125
		List<FofoOrderItem> fofoOrderItems = null;
126
 
127
		List<HygieneData> hygiene = hygieneDataRepository.selectAllByDisposedTimestamp();
128
 
129
		hygiene = hygiene.stream().filter(x -> x.getNextTimestamp().isBefore(LocalDateTime.now()))
130
				.collect(Collectors.toList());
131
 
132
		if (!hygiene.isEmpty()) {
133
			fofoOrder = fofoOrderRepository.selectByOrderId(hygiene.get(0).getOrderId());
134
			customRetailer = retailerService.getFofoRetailer(fofoOrder.getFofoId());
135
			customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
136
			fofoOrderItems = fofoOrderItemRepository.selectByOrderId(fofoOrder.getId());
137
 
138
		} else {
139
 
140
			HygieneData hygieneData = hygieneDataRepository.selectFirstByDisposedTimestamp();
141
			if (hygieneData != null) {
142
				fofoOrder = fofoOrderRepository.selectByOrderId(hygieneData.getOrderId());
143
				customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
144
 
145
				customRetailer = retailerService.getFofoRetailer(fofoOrder.getFofoId());
146
 
147
				fofoOrderItems = fofoOrderItemRepository.selectByOrderId(fofoOrder.getId());
148
 
149
				LOGGER.info("hygieneData" + hygieneData);
150
				LOGGER.info("fofoOrder" + fofoOrder);
151
				LOGGER.info("customRetailer" + customRetailer);
152
				LOGGER.info("customerAddress" + customerAddress);
153
 
154
			}
155
 
156
		}
157
 
158
		model.addAttribute("fofoOrder", fofoOrder);
159
		model.addAttribute("customRetailer", customRetailer);
160
		model.addAttribute("customerAddress", customerAddress);
161
		model.addAttribute("fofoOrderItems", fofoOrderItems);
162
 
163
		return "hygiene-modal";
164
	}
165
 
25650 tejbeer 166
	@RequestMapping(value = "/getFetchHygieneDataByOrderId", method = RequestMethod.GET)
167
	public String getFetchHygieneDataByOrderId(HttpServletRequest request, @RequestParam int orderId, Model model)
168
			throws Exception {
169
 
170
		FofoOrder fofoOrder = null;
171
		CustomRetailer customRetailer = null;
172
		CustomerAddress customerAddress = null;
173
		List<FofoOrderItem> fofoOrderItems = null;
174
 
175
		HygieneData hygiene = hygieneDataRepository.selectById(orderId);
176
 
177
		fofoOrder = fofoOrderRepository.selectByOrderId(hygiene.getOrderId());
178
		customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
179
 
180
		customRetailer = retailerService.getFofoRetailer(fofoOrder.getFofoId());
181
 
182
		fofoOrderItems = fofoOrderItemRepository.selectByOrderId(fofoOrder.getId());
183
 
184
		LOGGER.info("hygieneData" + hygiene);
185
		LOGGER.info("fofoOrder" + fofoOrder);
186
		LOGGER.info("customRetailer" + customRetailer);
187
		LOGGER.info("customerAddress" + customerAddress);
188
 
189
		model.addAttribute("fofoOrder", fofoOrder);
190
		model.addAttribute("customRetailer", customRetailer);
191
		model.addAttribute("customerAddress", customerAddress);
192
		model.addAttribute("fofoOrderItems", fofoOrderItems);
193
 
194
		return "hygiene-modal";
195
	}
196
 
25640 tejbeer 197
	@RequestMapping(value = "/hygieneData", method = RequestMethod.POST)
198
	public String HygieneData(HttpServletRequest request, @RequestBody HygieneDataModel hygieneDataModel, Model model)
199
			throws Exception {
200
		HygieneData hygieneData = hygieneDataRepository.selectById(hygieneDataModel.getOrderId());
29329 amit.gupta 201
		FofoOrder fofoOrder = fofoOrderRepository.selectByOrderId(hygieneDataModel.getOrderId());
202
		LocalDateTime hygieneDateTime = hygieneData.getCreatedTimestamp().toLocalDate().atStartOfDay();
203
		CustomerAddress customerAddress = customerAddressRepository.selectById(fofoOrder.getCustomerAddressId());
204
		List<CustomerAddress> customerAddresses = customerAddressRepository.selectByMobileNumber(customerAddress.getPhoneNumber());
205
		LOGGER.info("Fofo id {}, Date Range = {}, Customer Address Ids  {}", fofoOrder.getFofoId(), DateRangeModel.of(hygieneDateTime, hygieneDateTime.plusDays(1)), 
206
				customerAddresses.stream().map(x->x.getId()).collect(Collectors.toList()));
207
		List<FofoOrder> fofoOrders = fofoOrderRepository.selectByCustomerAddressIds(fofoOrder.getFofoId(), DateRangeModel.of(hygieneDateTime, hygieneDateTime.plusDays(1)), 
208
				customerAddresses.stream().map(x->x.getId()).collect(Collectors.toList()));
209
		LOGGER.info("Order Size - {}", fofoOrders.size());
210
		for(FofoOrder fo : fofoOrders) {
29340 amit.gupta 211
			LOGGER.info("Order Id - {}", fo.getId());
29329 amit.gupta 212
			hygieneData = hygieneDataRepository.selectById(fo.getId());
29341 amit.gupta 213
			if(hygieneData==null) continue;
29329 amit.gupta 214
			if (hygieneDataModel.getScheduleTime() != null) {
215
				hygieneData.setStatus(hygieneDataModel.getStatus());
216
				hygieneData.setRemark(hygieneDataModel.getRemark());
217
				hygieneData.setHygieneRating(hygieneDataModel.getHygieneRating());
218
				hygieneData.setNextTimestamp(hygieneDataModel.getScheduleTime());
219
				hygieneDataRepository.persist(hygieneData);
220
			} else {
221
				hygieneData.setStatus(hygieneDataModel.getStatus());
222
				hygieneData.setRemark(hygieneDataModel.getRemark());
223
				hygieneData.setRating(hygieneDataModel.getRating());
224
				hygieneData.setHygieneRating(hygieneDataModel.getHygieneRating());
225
				hygieneData.setDOP(hygieneDataModel.getDOP());
226
				hygieneData.setFeedback(hygieneDataModel.getFeedback());
227
				hygieneData.setQuesPhone(hygieneDataModel.getQuesPhone());
228
				hygieneData.setQuesInformation(hygieneDataModel.getQuesInformation());
229
				hygieneData.setQuesInvoice(hygieneDataModel.getQuesInvoice());
230
				hygieneData.setDisposedTimestamp(LocalDateTime.now());
231
				hygieneData.setNextTimestamp(null);
232
				hygieneDataRepository.persist(hygieneData);
233
			}
25640 tejbeer 234
		}
235
 
236
		model.addAttribute("response", mvcResponseSender.createResponseString(true));
237
 
238
		return "response";
239
	}
240
 
241
}